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.POS_BATCH_IMPORT_PKG dependencies on AP_SUPPLIERS_INT

Line 140: -- source id, source reference in cross reference table and update the ap_suppliers_int table

136: -- Initialize API return status to success
137: x_return_status := fnd_api.g_ret_sts_success;
138:
139: -- Check if party is present for the perticular batch id,
140: -- source id, source reference in cross reference table and update the ap_suppliers_int table
141: UPDATE ap_suppliers_int supp
142: SET party_id =
143: (SELECT party_id
144: FROM hz_orig_sys_references hr

Line 141: UPDATE ap_suppliers_int supp

137: x_return_status := fnd_api.g_ret_sts_success;
138:
139: -- Check if party is present for the perticular batch id,
140: -- source id, source reference in cross reference table and update the ap_suppliers_int table
141: UPDATE ap_suppliers_int supp
142: SET party_id =
143: (SELECT party_id
144: FROM hz_orig_sys_references hr
145: WHERE hr.owner_table_name = 'HZ_PARTIES'

Line 156: -- HZ_IMP_PARTIES_INT table using AP_SUPPLIERS_INT.

152: AND sdh_batch_id = p_batch_id
153: AND nvl(status, 'ACTIVE') <> 'PROCESSED';
154:
155: -- If the party record is not present insert data into
156: -- HZ_IMP_PARTIES_INT table using AP_SUPPLIERS_INT.
157: INSERT INTO hz_imp_parties_int
158: (batch_id,
159: party_orig_system,
160: party_orig_system_reference,

Line 182: FROM ap_suppliers_int supp

178: num_1099,
179: vat_registration_num,
180: ceo_name,
181: ceo_title
182: FROM ap_suppliers_int supp
183: WHERE /* party_id IS NULL AND */
184: sdh_batch_id = p_batch_id
185: AND nvl(status, 'ACTIVE') <> 'PROCESSED'
186: AND NOT EXISTS (SELECT *

Line 416: -- HZ_IMP_PARTIES_INT table using AP_SUPPLIERS_INT.

412: AND sdh_batch_id = p_batch_id
413: AND nvl(status, 'ACTIVE') <> 'PROCESSED';
414:
415: -- If the party record is not present insert data into
416: -- HZ_IMP_PARTIES_INT table using AP_SUPPLIERS_INT.
417: INSERT INTO hz_imp_parties_int
418: (batch_id,
419: party_orig_system,
420: party_orig_system_reference,

Line 653: FROM ap_suppliers_int supp

649: AND interface_status IS NULL
650: AND party_type = 'ORGANIZATION'
651: AND NOT EXISTS
652: (SELECT *
653: FROM ap_suppliers_int supp
654: WHERE hp.batch_id = supp.sdh_batch_id
655: AND hp.party_orig_system = supp.party_orig_system
656: AND hp.party_orig_system_reference =
657: supp.party_orig_system_reference);

Line 675: WHERE parent_table = 'AP_SUPPLIERS_INT';

671: -- Initialize API return status to success
672: x_return_status := fnd_api.g_ret_sts_success;
673:
674: DELETE ap_supplier_int_rejections
675: WHERE parent_table = 'AP_SUPPLIERS_INT';
676:
677: fnd_file.put_line(fnd_file.log,
678: ' Validating vendor record before the party is created. ');
679: OPEN party_int_cur;

Line 803: WHERE parent_table = 'AP_SUPPLIERS_INT';

799: last_update_login,
800: created_by,
801: creation_date
802: FROM ap_supplier_int_rejections
803: WHERE parent_table = 'AP_SUPPLIERS_INT';
804:
805: IF (g_level_procedure >= g_current_runtime_level) THEN
806: fnd_log.string(g_level_procedure,
807: g_module_name || l_api_name,

Line 1045: UPDATE ap_suppliers_int supp

1041:
1042: -- Initialize API return status to success
1043: x_return_status := fnd_api.g_ret_sts_success;
1044:
1045: UPDATE ap_suppliers_int supp
1046: SET supp.party_id =
1047: (SELECT party_id
1048: FROM hz_orig_sys_references hr
1049: WHERE hr.owner_table_name = 'HZ_PARTIES'

Line 1270: FROM ap_suppliers_int supp

1266: AND interface_status IS NULL
1267: AND party_type = 'ORGANIZATION'
1268: AND NOT EXISTS
1269: (SELECT *
1270: FROM ap_suppliers_int supp
1271: WHERE hp.batch_id = supp.sdh_batch_id
1272: AND hp.party_orig_system = supp.party_orig_system
1273: AND hp.party_orig_system_reference =
1274: supp.party_orig_system_reference);

Line 1299: WHERE parent_table = 'AP_SUPPLIERS_INT';

1295: -- Initialize API return status to success
1296: x_return_status := fnd_api.g_ret_sts_success;
1297:
1298: DELETE ap_supplier_int_rejections
1299: WHERE parent_table = 'AP_SUPPLIERS_INT';
1300:
1301: OPEN party_int_cur;
1302:
1303: LOOP

Line 1421: WHERE parent_table = 'AP_SUPPLIERS_INT';

1417: last_update_login,
1418: created_by,
1419: creation_date
1420: FROM ap_supplier_int_rejections
1421: WHERE parent_table = 'AP_SUPPLIERS_INT';
1422:
1423: IF (g_level_procedure >= g_current_runtime_level) THEN
1424: fnd_log.string(g_level_procedure,
1425: g_module_name || l_api_name,

Line 1482: WHERE parent_table = 'AP_SUPPLIERS_INT';

1478: last_update_login,
1479: created_by,
1480: creation_date
1481: FROM ap_supplier_int_rejections
1482: WHERE parent_table = 'AP_SUPPLIERS_INT';
1483:
1484: IF (g_level_procedure >= g_current_runtime_level) THEN
1485: fnd_log.string(g_level_procedure,
1486: g_module_name || l_api_name,

Line 1695: UPDATE ap_suppliers_int

1691: x_party_id => l_party_id);
1692:
1693: IF l_return_status = fnd_api.g_ret_sts_success THEN
1694:
1695: UPDATE ap_suppliers_int
1696: SET status = 'PROCESSED'
1697: WHERE vendor_interface_id = p_vendor_rec.vendor_interface_id
1698: AND sdh_batch_id = p_batch_id;
1699:

Line 1893: 'AP_SUPPLIERS_INT',

1889:
1890: ELSE
1891: IF (insert_rejections(p_batch_id,
1892: l_request_id,
1893: 'AP_SUPPLIERS_INT',
1894: p_vendor_rec.vendor_interface_id,
1895: 'AP_PAYEE_CREATION',
1896: g_user_id,
1897: g_login_id,

Line 1927: 'AP_SUPPLIERS_INT',

1923:
1924: ELSE
1925: IF (insert_rejections(p_batch_id,
1926: l_request_id,
1927: 'AP_SUPPLIERS_INT',
1928: p_vendor_rec.vendor_interface_id,
1929: 'AP_INVALID_PAYEE',
1930: g_user_id,
1931: g_login_id,

Line 1959: UPDATE ap_suppliers_int

1955: END IF; -- Payee Validation API
1956:
1957: ELSE
1958:
1959: UPDATE ap_suppliers_int
1960: SET status = 'REJECTED'
1961: WHERE vendor_interface_id = p_vendor_rec.vendor_interface_id
1962: AND sdh_batch_id = p_batch_id;
1963:

Line 1986: WHERE parent_table = 'AP_SUPPLIERS_INT'

1982: last_update_login,
1983: created_by,
1984: creation_date
1985: FROM ap_supplier_int_rejections
1986: WHERE parent_table = 'AP_SUPPLIERS_INT'
1987: AND parent_id = p_vendor_rec.vendor_interface_id;
1988:
1989: IF (g_level_procedure >= g_current_runtime_level) THEN
1990: fnd_log.string(g_level_procedure,

Line 2055: FROM ap_suppliers_int supp

2051: l_vendor_id NUMBER;
2052:
2053: CURSOR vendor_int_cur IS
2054: SELECT *
2055: FROM ap_suppliers_int supp
2056: WHERE import_request_id = l_request_id
2057: AND vendor_interface_id IS NOT NULL
2058: AND sdh_batch_id = p_batch_id
2059: AND nvl(status, 'ACTIVE') NOT IN ('PROCESSED', 'REMOVED')

Line 2096: WHERE parent_table = 'AP_SUPPLIERS_INT';

2092: -- Standard Start of API savepoint
2093: SAVEPOINT import_vendor_pub;
2094:
2095: DELETE ap_supplier_int_rejections
2096: WHERE parent_table = 'AP_SUPPLIERS_INT';
2097:
2098: -- API body
2099:
2100: -- This update statement resets the unprocessed rows so

Line 2102: UPDATE ap_suppliers_int api

2098: -- API body
2099:
2100: -- This update statement resets the unprocessed rows so
2101: -- that they get picked in the current run.
2102: UPDATE ap_suppliers_int api
2103: SET import_request_id = NULL
2104: WHERE import_request_id IS NOT NULL
2105: AND sdh_batch_id = p_batch_id
2106: AND nvl(status, 'ACTIVE') IN ('ACTIVE', 'REJECTED')

Line 2113: UPDATE ap_suppliers_int

2109: WHERE fcr.request_id = api.import_request_id
2110: AND fcr.phase_code = 'C');
2111:
2112: -- Updating Interface Record with request id
2113: UPDATE ap_suppliers_int
2114: SET import_request_id = l_request_id
2115: WHERE import_request_id IS NULL
2116: AND sdh_batch_id = p_batch_id
2117: AND nvl(status, 'ACTIVE') NOT IN ('PROCESSED', 'REMOVED');

Line 2119: UPDATE ap_suppliers_int supp

2115: WHERE import_request_id IS NULL
2116: AND sdh_batch_id = p_batch_id
2117: AND nvl(status, 'ACTIVE') NOT IN ('PROCESSED', 'REMOVED');
2118:
2119: UPDATE ap_suppliers_int supp
2120: SET status = 'REMOVED',
2121: import_request_id = l_request_id
2122: WHERE sdh_batch_id = p_batch_id
2123: AND nvl(status, 'ACTIVE') <> 'PROCESSED'

Line 2142: 'AP_SUPPLIERS_INT',

2138:
2139: INSERT INTO pos_supplier_int_rejections
2140: (SELECT p_batch_id,
2141: l_request_id,
2142: 'AP_SUPPLIERS_INT',
2143: vendor_interface_id,
2144: 'POS_INVALID_PARTY_ORIG_SYSTEM',
2145: g_user_id,
2146: SYSDATE,

Line 2150: FROM ap_suppliers_int

2146: SYSDATE,
2147: g_login_id,
2148: g_user_id,
2149: SYSDATE
2150: FROM ap_suppliers_int
2151: WHERE status = 'REMOVED'
2152: AND import_request_id = l_request_id
2153: AND sdh_batch_id = p_batch_id);
2154:

Line 2200: UPDATE ap_suppliers_int

2196: vendor_rec.hold_reason := vendor_int_rec.hold_reason;
2197:
2198: IF length(vendor_int_rec.num_1099) > 20 THEN
2199:
2200: UPDATE ap_suppliers_int
2201: SET status = 'REJECTED'
2202: WHERE vendor_interface_id = vendor_int_rec.vendor_interface_id
2203: AND sdh_batch_id = p_batch_id;
2204:

Line 2207: 'AP_SUPPLIERS_INT',

2203: AND sdh_batch_id = p_batch_id;
2204:
2205: IF (insert_rejections(p_batch_id,
2206: l_request_id,
2207: 'AP_SUPPLIERS_INT',
2208: vendor_rec.vendor_interface_id,
2209: 'AP_INVALID_NUM_1099',
2210: g_user_id,
2211: g_login_id,

Line 2378: UPDATE ap_suppliers_int

2374: vendor_rec.party_id := vendor_int_rec.party_id;
2375: END IF;
2376:
2377: IF (vendor_rec.party_id IS NULL OR vendor_rec.party_id = 0) THEN
2378: UPDATE ap_suppliers_int
2379: SET status = 'REJECTED'
2380: WHERE vendor_interface_id = vendor_rec.vendor_interface_id
2381: AND sdh_batch_id = p_batch_id;
2382:

Line 2385: 'AP_SUPPLIERS_INT',

2381: AND sdh_batch_id = p_batch_id;
2382:
2383: IF (insert_rejections(p_batch_id,
2384: l_request_id,
2385: 'AP_SUPPLIERS_INT',
2386: vendor_rec.vendor_interface_id,
2387: 'POS_INVALID_PARTY_ORIG_SYSTEM',
2388: g_user_id,
2389: g_login_id,

Line 2479: UPDATE ap_suppliers_int

2475: l_vendor_id);
2476:
2477: IF l_return_status = fnd_api.g_ret_sts_success THEN
2478:
2479: UPDATE ap_suppliers_int
2480: SET status = 'PROCESSED'
2481: WHERE vendor_interface_id = vendor_rec.vendor_interface_id
2482: AND sdh_batch_id = p_batch_id;
2483:

Line 2491: UPDATE ap_suppliers_int

2487: suppliers_updated = suppliers_updated + 1,
2488: suppliers_imported = suppliers_imported + 1
2489: WHERE batch_id = p_batch_id;
2490: ELSE
2491: UPDATE ap_suppliers_int
2492: SET status = 'REJECTED'
2493: WHERE vendor_interface_id = vendor_rec.vendor_interface_id
2494: AND sdh_batch_id = p_batch_id;
2495:

Line 2518: WHERE parent_table = 'AP_SUPPLIERS_INT'

2514: last_update_login,
2515: created_by,
2516: creation_date
2517: FROM ap_supplier_int_rejections
2518: WHERE parent_table = 'AP_SUPPLIERS_INT'
2519: AND parent_id = vendor_rec.vendor_interface_id;
2520:
2521: IF (g_level_procedure >= g_current_runtime_level) THEN
2522: fnd_log.string(g_level_procedure,

Line 10306: FROM ap_suppliers_int

10302: retcode := 1;
10303: ELSE
10304: SELECT COUNT(1)
10305: INTO l_error_count
10306: FROM ap_suppliers_int
10307: WHERE sdh_batch_id = p_batch_id
10308: AND nvl(status, 'ACTIVE') = 'REJECTED'
10309: AND rownum = 1;
10310: