To avoid companies accidentally registering twice in the Portal, you can use the M_PCK_COMPANY_CUSTOM.EXISTS_COMPANY_DATA1 and .EXISTS_COMPANY_DATA2 CIP procedures to apply your own checks. The CIPs return Null if the check does not find any existing data that conflicts with the entered data. If the checks find conflicting data, an error message is displayed that prompts the user to change the entered data. By default, the EXISTS_COMPANY_DATA1 checks the uniqueness of the combination company name, country and postal code, and the EXISTS_COMPANY_DATA2 checks the uniqueness of the combination company name and federal ID.
Below you can find the description of the default CIPs that are delivered with the software.
EXISTS_COMPANY_DATA1
Description: |
CIP to check that the combination of Company Name, Country and Postal Code is unique. If data exist, the p_exists_ind is set to Y and an appropriate MAR-message is displayed. |
Type: |
Procedure |
Usage: |
Smart Materials Portal, Company Registration |
Event: |
Insert or update company data |
Default: |
Null if p_exists_ind=N, MAR-message if p_exists_ind=Y |
EXISTS_COMPANY_DATA2
Description: |
CIP to check that the combination of Company Name and Federal ID (tax ID, business registration number) is unique. If data exist, the p_exists_ind is set to Y and an appropriate MAR-message is displayed. |
Type: |
Procedure |
Usage: |
Smart Materials Portal, Company Registration |
Event: |
Insert or update company data |
Default: |
Null if p_exists_ind=N, MAR-message if p_exists_ind=Y |
CHECK_FEDERAL_ID
Description: |
This CIP checks whether the Federal-Id (Business Registration) is valid in the given Country. If the return value is Y, the entered Business Registration is valid in the Country; otherwise not. |
Type: |
Function |
Usage: |
Smart Materials Portal, Company Registration |
Event: |
Navigating out of the Federal ID or Country box on the Company screen |
Default: |
Y |