eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JL_INTERFACE_VAL dependencies on RA_CUSTOMERS_INTERFACE

Line 1547: -- INTERFACE_STATUS field in RA_CUSTOMERS_INTERFACE

1543: (p_glob_attr_set1.global_attribute10 IS NULL) THEN
1544:
1545: -- Return the record status and the error message code
1546: -- (j2 -Invalid Value in Global Attribute10) to update
1547: -- INTERFACE_STATUS field in RA_CUSTOMERS_INTERFACE
1548: -- with error code
1549:
1550: l_mesg_code := 'j2,';
1551: l_record_status := 'E';

Line 1565: -- INTERFACE_STATUS field in RA_CUSTOMERS_INTERFACE

1561: ('0','1','2','3','4','5','6','7','8','9','K') ))) THEN
1562:
1563: -- Return the record status and the error message code
1564: -- (j4 -Invalid Value in Global Attribute12) to update
1565: -- INTERFACE_STATUS field in RA_CUSTOMERS_INTERFACE
1566: -- with error code
1567:
1568: -- Checking for global attribute12 has a value then check if it is
1569: -- between 0 - 9 or K.

Line 1603: 'RA_CUSTOMERS_INTERFACE',

1599: END IF;
1600:
1601: IF (l_record_status = 'E') THEN
1602: jg_globe_flex_val_shared.update_interface_status (l_row_id,
1603: 'RA_CUSTOMERS_INTERFACE',
1604: l_mesg_code,
1605: l_record_status);
1606: END IF;
1607:

Line 1637: 'RA_CUSTOMERS_INTERFACE',

1633: END IF; -- End IF l_record_status = 'S'
1634:
1635: IF (l_taxid_record_status = 'E') THEN
1636: jg_globe_flex_val_shared.update_interface_status (l_row_id,
1637: 'RA_CUSTOMERS_INTERFACE',
1638: l_taxid_mesg_code,
1639: l_taxid_record_status);
1640: ELSIF (l_taxid_record_status = 'W') THEN
1641: jg_globe_flex_val_shared.update_interface_status (l_row_id,

Line 1642: 'RA_CUSTOMERS_INTERFACE',

1638: l_taxid_mesg_code,
1639: l_taxid_record_status);
1640: ELSIF (l_taxid_record_status = 'W') THEN
1641: jg_globe_flex_val_shared.update_interface_status (l_row_id,
1642: 'RA_CUSTOMERS_INTERFACE',
1643: l_taxid_mesg_code,
1644: l_taxid_record_status);
1645: END IF;
1646:

Line 1693: -- to update INTERFACE_STATUS field in RA_CUSTOMERS_INTERFACE

1689: (p_glob_attr_set1.global_attribute10 IS NULL) THEN
1690:
1691: -- Return the record status and the error message code
1692: -- (j2 -Invalid Value in Global Attribute10)
1693: -- to update INTERFACE_STATUS field in RA_CUSTOMERS_INTERFACE
1694: -- with error code
1695:
1696: l_mesg_code := 'j2,';
1697: l_record_status := 'E';

Line 1713: -- INTERFACE_STATUS field in RA_CUSTOMERS_INTERFACE

1709: ('0','1','2','3','4','5','6','7','8','9')))) THEN
1710:
1711: -- Return the record status and the error message code
1712: -- (j4 -Invalid Value in Global Attribute12) to update
1713: -- INTERFACE_STATUS field in RA_CUSTOMERS_INTERFACE
1714: -- with error code
1715:
1716: -- Checking for global attribute12 has a value then check if it is
1717: -- between 0 - 9 or K.

Line 1750: 'RA_CUSTOMERS_INTERFACE',

1746: END IF;
1747:
1748: IF (l_record_status = 'E') THEN
1749: jg_globe_flex_val_shared.update_interface_status (l_row_id,
1750: 'RA_CUSTOMERS_INTERFACE',
1751: l_mesg_code,
1752: l_record_status);
1753: END IF;
1754:

Line 1782: 'RA_CUSTOMERS_INTERFACE',

1778:
1779:
1780: IF (l_taxid_record_status = 'E') THEN
1781: jg_globe_flex_val_shared.update_interface_status (l_row_id,
1782: 'RA_CUSTOMERS_INTERFACE',
1783: l_taxid_mesg_code,
1784: l_taxid_record_status);
1785:
1786: ELSIF (l_taxid_record_status = 'W') THEN

Line 1788: 'RA_CUSTOMERS_INTERFACE',

1784: l_taxid_record_status);
1785:
1786: ELSIF (l_taxid_record_status = 'W') THEN
1787: jg_globe_flex_val_shared.update_interface_status (l_row_id,
1788: 'RA_CUSTOMERS_INTERFACE',
1789: l_taxid_mesg_code,
1790: l_taxid_record_status);
1791: END IF;
1792:

Line 1840: -- to update INTERFACE_STATUS field in RA_CUSTOMERS_INTERFACE

1836: (p_glob_attr_set1.global_attribute9 IS NULL) THEN
1837:
1838: -- Return the record status and the error message code
1839: -- (j1 -Invalid Value in Global Attribute9)
1840: -- to update INTERFACE_STATUS field in RA_CUSTOMERS_INTERFACE
1841: -- with error code
1842:
1843: l_mesg_code := 'j1,';
1844: l_record_status := 'E';

Line 1861: -- INTERFACE_STATUS field in RA_CUSTOMERS_INTERFACE

1857: EXCEPTION
1858: WHEN NO_DATA_FOUND THEN
1859: -- Return the record status and the error message code
1860: -- (j2 -Invalid Value in Global Attribute10) to update
1861: -- INTERFACE_STATUS field in RA_CUSTOMERS_INTERFACE
1862: -- with error code
1863:
1864: l_mesg_code := l_mesg_code||'j2,';
1865: l_record_status := 'E';

Line 1882: -- INTERFACE_STATUS field in RA_CUSTOMERS_INTERFACE

1878: ('0','1','2','3','4','5','6','7','8','9')))) THEN
1879:
1880: -- Return the record status and the error message code
1881: -- (j4 -Invalid Value in Global Attribute12) to update
1882: -- INTERFACE_STATUS field in RA_CUSTOMERS_INTERFACE
1883: -- with error code
1884:
1885: l_mesg_code := l_mesg_code||'j4,';
1886: l_record_status := 'E';

Line 1916: 'RA_CUSTOMERS_INTERFACE',

1912: END IF;
1913:
1914: IF (l_record_status = 'E') THEN
1915: jg_globe_flex_val_shared.update_interface_status (l_row_id,
1916: 'RA_CUSTOMERS_INTERFACE',
1917: l_mesg_code,
1918: l_record_status);
1919: END IF;
1920:

Line 1947: 'RA_CUSTOMERS_INTERFACE',

1943: END IF; -- End IF l_record_status = 'S'
1944:
1945: IF (l_taxid_record_status = 'E') THEN
1946: jg_globe_flex_val_shared.update_interface_status (l_row_id,
1947: 'RA_CUSTOMERS_INTERFACE',
1948: l_taxid_mesg_code,
1949: l_taxid_record_status);
1950: ELSIF (l_taxid_record_status = 'W') THEN
1951: jg_globe_flex_val_shared.update_interface_status (l_row_id,

Line 1952: 'RA_CUSTOMERS_INTERFACE',

1948: l_taxid_mesg_code,
1949: l_taxid_record_status);
1950: ELSIF (l_taxid_record_status = 'W') THEN
1951: jg_globe_flex_val_shared.update_interface_status (l_row_id,
1952: 'RA_CUSTOMERS_INTERFACE',
1953: l_taxid_mesg_code,
1954: l_taxid_record_status);
1955: END IF;
1956:

Line 2045: -- INTERFACE_STATUS field in RA_CUSTOMERS_INTERFACE

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
2046: -- with error code
2047:
2048: p_taxid_mesg_code := 'k3,';
2049: p_taxid_record_status := 'E';

Line 2064: -- RA_CUSTOMERS_INTERFACE with error code

2060: ) <> 'TRUE' THEN
2061: -- Return the record status and the error message code
2062: -- (k4 - Taxpayer ID exceeds maximun digits allowed)
2063: -- to update INTERFACE_STATUS field in
2064: -- RA_CUSTOMERS_INTERFACE with error code
2065:
2066: p_taxid_mesg_code := 'k4,';
2067: p_taxid_record_status := 'E';
2068: return;

Line 2076: -- Update in RA_CUSTOMERS_INTERFACE

2072:
2073: -- Validation for CHECK_UNIQUENESS
2074:
2075: -- Checking for Customer_id in RA_CUSTOMERS table for records marked for
2076: -- Update in RA_CUSTOMERS_INTERFACE
2077:
2078: IF (p_insert_update_flag = 'U') THEN
2079:
2080: BEGIN

Line 2123: -- field in RA_CUSTOMERS_INTERFACE with error code

2119: p_request_id) <> 'TRUE' THEN
2120:
2121: -- Return the record status and the error message code
2122: -- (k5 - Duplicate Tax ID) to update INTERFACE_STATUS
2123: -- field in RA_CUSTOMERS_INTERFACE with error code
2124:
2125: p_taxid_mesg_code := 'k5,';
2126: p_taxid_record_status := 'E';
2127: return;

Line 2159: -- RA_CUSTOMERS_INTERFACE with error code

2155:
2156: -- Return the record status and the warning message
2157: -- code (k6 -Tax ID used by different Supplier)
2158: -- to update INTERFACE_STATUS field in
2159: -- RA_CUSTOMERS_INTERFACE with error code
2160:
2161: IF l_taxid_raise_error= 'VALIDATION_TYPE_ERROR' THEN
2162: p_taxid_mesg_code := 'k6,';
2163: p_taxid_record_status := 'E';

Line 2174: -- RA_CUSTOMERS_INTERFACE with error code

2170:
2171: -- Return the record status and the warning message code
2172: -- (k8 - Customer exist as Supplier with different
2173: -- Tax id) to update WARNING_TEXT field in
2174: -- RA_CUSTOMERS_INTERFACE with error code
2175:
2176: IF l_taxid_raise_error='VALIDATION_TYPE_ERROR' THEN
2177: p_taxid_mesg_code := 'k8,';
2178: p_taxid_record_status := 'E';

Line 2191: -- RA_CUSTOMERS_INTERFACE with error code

2187:
2188: -- Return the record status and the warning message
2189: -- code (k7 -Tax ID used by different Company - Company
2190: -- with different name) to update WARNING_TEXT field in
2191: -- RA_CUSTOMERS_INTERFACE with error code
2192:
2193: IF l_taxid_raise_error='VALIDATION_TYPE_ERROR' THEN
2194: p_taxid_mesg_code := 'k7,';
2195: p_taxid_record_status := 'E';

Line 2206: -- RA_CUSTOMERS_INTERFACE with error code

2202:
2203: -- Return the record status and the warning message code
2204: -- (k9 - Customer exist as Company with
2205: -- different Tax ID) to update WARNING_TEXT field in
2206: -- RA_CUSTOMERS_INTERFACE with error code
2207:
2208: IF l_taxid_raise_error='VALIDATION_TYPE_ERROR' THEN
2209: p_taxid_mesg_code := 'k9,';
2210: p_taxid_record_status := 'E';

Line 2224: -- RA_CUSTOMERS_INTERFACE with error code

2220:
2221: -- Return the record status and the warning message
2222: -- code (l1 - Tax ID used by different Bank)
2223: -- to update WARNING_TEXT field in
2224: -- RA_CUSTOMERS_INTERFACE with error code
2225:
2226: IF l_taxid_raise_error='VALIDATION_TYPE_ERROR' THEN
2227: p_taxid_mesg_code := 'l1,';
2228: p_taxid_record_status := 'E';

Line 2239: -- RA_CUSTOMERS_INTERFACE with error code

2235:
2236: -- Return the record status and the warning message code
2237: -- (l2 - Customer exist as a Bank with different Tax ID
2238: -- or ID Type) to update WARNING_TEXT field in
2239: -- RA_CUSTOMERS_INTERFACE with error code
2240:
2241: IF l_taxid_raise_error='VALIDATION_TYPE_ERROR' THEN
2242: p_taxid_mesg_code := 'l2,';
2243: p_taxid_record_status := 'E';

Line 2271: -- RA_CUSTOMERS_INTERFACE with error code

2267:
2268: -- Return the record status and the error message code
2269: -- (k0 - Validation Routine Failed)
2270: -- to update INTERFACE_STATUS field in
2271: -- RA_CUSTOMERS_INTERFACE with error code
2272:
2273: p_taxid_mesg_code := 'k0,';
2274: p_taxid_record_status := 'E';
2275: return;

Line 2281: -- WARNING_TEXT in RA_CUSTOMERS_INTERFACE with

2277: ELSE
2278:
2279: -- The record can be processed. But a Warning message
2280: -- should appear in the Log File. Update field
2281: -- WARNING_TEXT in RA_CUSTOMERS_INTERFACE with
2282: -- error code k0 - Tax ID Validation Routine Failed
2283:
2284: p_taxid_mesg_code := p_taxid_mesg_code||'k0,';
2285: p_taxid_record_status := 'W';

Line 2294: UPDATE ra_customers_interface

2290:
2291: IF (p_country_code = 'CL' AND l_copy = 'Y' AND p_customer_number IS NULL) THEN
2292:
2293: IF p_global_attribute12 IS NOT NULL THEN
2294: UPDATE ra_customers_interface
2295: SET customer_number = p_jgzz_fiscal_code||'-'||p_global_attribute12
2296: WHERE rowid = p_row_id;
2297: ELSE
2298: UPDATE ra_customers_interface

Line 2298: UPDATE ra_customers_interface

2294: UPDATE ra_customers_interface
2295: SET customer_number = p_jgzz_fiscal_code||'-'||p_global_attribute12
2296: WHERE rowid = p_row_id;
2297: ELSE
2298: UPDATE ra_customers_interface
2299: SET customer_number = p_jgzz_fiscal_code
2300: WHERE rowid = p_row_id;
2301: END IF;
2302: END IF;

Line 2307: UPDATE ra_customers_interface

2303:
2304: IF (p_country_code = 'CO' AND l_copy = 'Y' AND p_customer_number IS NULL) THEN
2305:
2306: IF (p_global_attribute10 = 'LEGAL_ENTITY') AND (p_global_attribute12 IS NOT NULL) THEN
2307: UPDATE ra_customers_interface
2308: SET customer_number = p_jgzz_fiscal_code||'-'||p_global_attribute12
2309: WHERE rowid = p_row_id;
2310: ELSE
2311: UPDATE ra_customers_interface

Line 2311: UPDATE ra_customers_interface

2307: UPDATE ra_customers_interface
2308: SET customer_number = p_jgzz_fiscal_code||'-'||p_global_attribute12
2309: WHERE rowid = p_row_id;
2310: ELSE
2311: UPDATE ra_customers_interface
2312: SET customer_number = p_jgzz_fiscal_code
2313: WHERE rowid = p_row_id;
2314: END IF;
2315:

Line 2775: -- table (RA_CUSTOMERS_INTERFACE) for specific Brazilian requirements.

2771: END jl_br_apxiisim_val_cfo_code;
2772:
2773: --=========================================================================
2774: -- This procedure validates address attribute columns From Customer Interface
2775: -- table (RA_CUSTOMERS_INTERFACE) for specific Brazilian requirements.
2776: -- IF any validation fails, this procedure writes the error code
2777: -- in the interface_status column of RA_CUSTOMERS_INTERFACE
2778: --========================================================================
2779: Procedure jl_br_arxcudci_additional

Line 2777: -- in the interface_status column of RA_CUSTOMERS_INTERFACE

2773: --=========================================================================
2774: -- This procedure validates address attribute columns From Customer Interface
2775: -- table (RA_CUSTOMERS_INTERFACE) for specific Brazilian requirements.
2776: -- IF any validation fails, this procedure writes the error code
2777: -- in the interface_status column of RA_CUSTOMERS_INTERFACE
2778: --========================================================================
2779: Procedure jl_br_arxcudci_additional
2780: ( p_glob_attr_set1 IN jg_globe_flex_val_shared.GdfRec,
2781: p_glob_attr_set2 IN jg_globe_flex_val_shared.GdfRec,

Line 2877: 'RA_CUSTOMERS_INTERFACE',

2873: ELSE
2874: p_record_status := 'E';
2875: jg_globe_flex_val_shared.update_interface_status
2876: (l_row_id,
2877: 'RA_CUSTOMERS_INTERFACE',
2878: l_error_code,
2879: p_record_status);
2880: END IF;
2881:

Line 2886: -- Customer Interface table (RA_CUSTOMERS_INTERFACE) for specific

2882: END;
2883:
2884: --=========================================================================
2885: -- This procedure validates the customer profile attribute columns From
2886: -- Customer Interface table (RA_CUSTOMERS_INTERFACE) for specific
2887: -- Brazilian requirements. IF any validation fails, this procedure writes
2888: --the error code in the Interface status column of RA_CUSTOMER_PROFILES_
2889: --INTERFACE
2890: --========================================================================+

Line 2961: -- table (RA_CUSTOMERS_INTERFACE) for LTE requirements.

2957: END;
2958:
2959: --=========================================================================
2960: -- This procedure validates address attribute column From Customer Interface
2961: -- table (RA_CUSTOMERS_INTERFACE) for LTE requirements.
2962: -- IF any validation fails, this procedure writes the error code
2963: -- in the interface_status column of RA_CUSTOMERS_INTERFACE
2964: --========================================================================
2965: procedure jl_zz_ar_tx_arxcudci_address

Line 2963: -- in the interface_status column of RA_CUSTOMERS_INTERFACE

2959: --=========================================================================
2960: -- This procedure validates address attribute column From Customer Interface
2961: -- table (RA_CUSTOMERS_INTERFACE) for LTE requirements.
2962: -- IF any validation fails, this procedure writes the error code
2963: -- in the interface_status column of RA_CUSTOMERS_INTERFACE
2964: --========================================================================
2965: procedure jl_zz_ar_tx_arxcudci_address
2966: ( p_glob_attr_set1 IN jg_globe_flex_val_shared.GdfRec,
2967: p_glob_attr_set2 IN jg_globe_flex_val_shared.GdfRec,

Line 3047: 'RA_CUSTOMERS_INTERFACE',

3043: p_record_status := 'S';
3044: ELSE
3045: p_record_status := 'E';
3046: jg_globe_flex_val_shared.update_interface_status (l_row_id,
3047: 'RA_CUSTOMERS_INTERFACE',
3048: l_error_code,
3049: p_record_status);
3050: END IF;
3051: