APPS.JL_INTERFACE_VAL dependencies on JG_TAXID_VAL_PKG

Line 1968: -- call JG_TAXID_VAL_PKG package

1964:
1965: ---------------------------------------------------------------------------
1966: -- JL_ZZ_TAXID_RA_CUSTOMERS():
1967: -- This procedure validates Bussines Rules for each country and
1968: -- call JG_TAXID_VAL_PKG package
1969: --------------------------------------------------------------------------
1970: PROCEDURE jl_zz_taxid_customers(
1971: p_country_code IN VARCHAR2,
1972: p_calling_program_name IN VARCHAR2,

Line 2041: IF JG_TAXID_VAL_PKG.CHECK_NUMERIC(p_jgzz_fiscal_code) <> 'TRUE' THEN

2037: (p_global_attribute9 = 'FOREIGN_ORIGIN' AND p_global_attribute10 = '80')) THEN
2038:
2039: -- Check for Numeric
2040:
2041: IF JG_TAXID_VAL_PKG.CHECK_NUMERIC(p_jgzz_fiscal_code) <> 'TRUE' THEN
2042:
2043: -- Return the record status and the error message code
2044: -- k3 - Taxpayer ID should be numeric) to update
2045: -- INTERFACE_STATUS field in RA_CUSTOMERS_INTERFACE

Line 2056: IF JG_TAXID_VAL_PKG.CHECK_LENGTH(

2052: END IF;
2053:
2054: -- Check maximun digits allowed.
2055:
2056: IF JG_TAXID_VAL_PKG.CHECK_LENGTH(
2057: p_country_code,
2058: l_num_digits,
2059: p_jgzz_fiscal_code
2060: ) <> 'TRUE' THEN

Line 2111: IF JG_TAXID_VAL_PKG.CHECK_UNIQUENESS(

2107:
2108:
2109: IF (p_country_code IN ('CL','CO')) OR
2110: (p_country_code = 'AR' and p_global_attribute9='DOMESTIC_ORIGIN') THEN
2111: IF JG_TAXID_VAL_PKG.CHECK_UNIQUENESS(
2112: p_country_code,
2113: p_jgzz_fiscal_code,
2114: l_customer_id,
2115: --'RACUST',

Line 2143: JG_TAXID_VAL_PKG.CHECK_CROSS_MODULE(

2139: -- as a Supplier with different Tax ID and Name
2140:
2141: IF p_customer_name IS NOT NULL THEN
2142:
2143: JG_TAXID_VAL_PKG.CHECK_CROSS_MODULE(
2144: p_country_code,
2145: p_customer_name,
2146: p_jgzz_fiscal_code,
2147: p_global_attribute9,

Line 2261: IF JG_TAXID_VAL_PKG.CHECK_ALGORITHM(

2257: (p_country_code = 'CO' and p_global_attribute10 = 'LEGAL_ENTITY') OR
2258: ((p_country_code = 'AR' and (p_global_attribute9 = 'DOMESTIC_ORIGIN' AND p_global_attribute10 IN ('80','82')) OR
2259: (p_global_attribute9 = 'FOREIGN_ORIGIN' AND p_global_attribute10 = '80')))
2260: THEN
2261: IF JG_TAXID_VAL_PKG.CHECK_ALGORITHM(
2262: p_jgzz_fiscal_code,
2263: p_country_code,
2264: p_global_attribute12
2265: ) <> 'TRUE' THEN