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 POS_SUPPLIER_INT_REJECTIONS

Line 48: INSERT INTO pos_supplier_int_rejections

44: to_char(p_parent_id) || ', p_reject_code: ' ||
45: p_reject_code);
46: END IF;
47:
48: INSERT INTO pos_supplier_int_rejections
49: (batch_id,
50: import_request_id,
51: parent_table,
52: parent_id,

Line 781: INSERT INTO pos_supplier_int_rejections

777: END IF;
778:
779: IF (l_return_status <> fnd_api.g_ret_sts_success /*OR l_party_valid <> 'Y'*/
780: ) THEN
781: INSERT INTO pos_supplier_int_rejections
782: (batch_id,
783: import_request_id,
784: parent_table,
785: parent_id,

Line 1399: INSERT INTO pos_supplier_int_rejections

1395: x_vendor_id => l_vendor_id,
1396: x_party_id => l_party_id);
1397:
1398: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1399: INSERT INTO pos_supplier_int_rejections
1400: (batch_id,
1401: import_request_id,
1402: parent_table,
1403: parent_id,

Line 1460: INSERT INTO pos_supplier_int_rejections

1456: x_vendor_id => l_vendor_id,
1457: x_party_id => l_party_id);
1458:
1459: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1460: INSERT INTO pos_supplier_int_rejections
1461: (batch_id,
1462: import_request_id,
1463: parent_table,
1464: parent_id,

Line 1964: INSERT INTO pos_supplier_int_rejections

1960: SET status = 'REJECTED'
1961: WHERE vendor_interface_id = p_vendor_rec.vendor_interface_id
1962: AND sdh_batch_id = p_batch_id;
1963:
1964: INSERT INTO pos_supplier_int_rejections
1965: (batch_id,
1966: import_request_id,
1967: parent_table,
1968: parent_id,

Line 2139: INSERT INTO pos_supplier_int_rejections

2135: ' Message: Inside PROCEDURE IMPORT_VENDORS' ||
2136: ' Not imported(marked REMOVED) : ' || SQL%ROWCOUNT ||
2137: ' records. Reason interface_status in hz_imp_parties_int = R');
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,

Line 2496: INSERT INTO pos_supplier_int_rejections

2492: SET status = 'REJECTED'
2493: WHERE vendor_interface_id = vendor_rec.vendor_interface_id
2494: AND sdh_batch_id = p_batch_id;
2495:
2496: INSERT INTO pos_supplier_int_rejections
2497: (batch_id,
2498: import_request_id,
2499: parent_table,
2500: parent_id,

Line 2941: INSERT INTO pos_supplier_int_rejections

2937: SET status = 'REJECTED'
2938: WHERE vendor_site_interface_id = p_site_rec.vendor_site_interface_id
2939: AND sdh_batch_id = p_batch_id;
2940:
2941: INSERT INTO pos_supplier_int_rejections
2942: (batch_id,
2943: import_request_id,
2944: parent_table,
2945: parent_id,

Line 3118: INSERT INTO pos_supplier_int_rejections

3114: WHERE (operating_unit_name IS NULL AND org_id IS NULL)
3115: AND sdh_batch_id = p_batch_id
3116: AND nvl(status, 'ACTIVE') <> 'PROCESSED';
3117:
3118: INSERT INTO pos_supplier_int_rejections
3119: (SELECT p_batch_id,
3120: l_request_id,
3121: 'AP_SUPPLIER_SITES_INT',
3122: vendor_site_interface_id,

Line 3158: INSERT INTO pos_supplier_int_rejections

3154: ' Message: Inside PROCEDURE IMPORT_VENDOR_SITES' ||
3155: ' Not imported(marked REMOVED) : ' || SQL%ROWCOUNT ||
3156: ' records. Reason interface_status in hz_imp_addresses_int = R');
3157:
3158: INSERT INTO pos_supplier_int_rejections
3159: (SELECT p_batch_id,
3160: l_request_id,
3161: 'AP_SUPPLIER_SITES_INT',
3162: vendor_site_interface_id,

Line 3528: INSERT INTO pos_supplier_int_rejections

3524: WHERE vendor_site_interface_id =
3525: site_rec.vendor_site_interface_id
3526: AND sdh_batch_id = p_batch_id;
3527:
3528: INSERT INTO pos_supplier_int_rejections
3529: (batch_id,
3530: import_request_id,
3531: parent_table,
3532: parent_id,

Line 3808: INSERT INTO pos_supplier_int_rejections

3804: WHERE ((operating_unit_name IS NULL AND org_id IS NULL) OR
3805: (last_name IS NULL))
3806: AND sdh_batch_id = p_batch_id;
3807:
3808: INSERT INTO pos_supplier_int_rejections
3809: (SELECT p_batch_id,
3810: l_request_id,
3811: 'AP_SUP_SITE_CONTACT_INT',
3812: vendor_contact_interface_id,

Line 3863: INSERT INTO pos_supplier_int_rejections

3859: ' Message: Inside PROCEDURE IMPORT_VENDOR_CONTACTS' ||
3860: ' Not imported(marked REMOVED) : ' || SQL%ROWCOUNT ||
3861: ' records. Reason interface_status in hz_imp_contacts_int = R');
3862:
3863: INSERT INTO pos_supplier_int_rejections
3864: (SELECT p_batch_id,
3865: l_request_id,
3866: 'AP_SUP_SITE_CONTACT_INT',
3867: vendor_contact_interface_id,

Line 4245: INSERT INTO pos_supplier_int_rejections

4241: WHERE vendor_contact_interface_id =
4242: vendor_contact_rec.vendor_contact_interface_id
4243: AND sdh_batch_id = p_batch_id;
4244:
4245: INSERT INTO pos_supplier_int_rejections
4246: (batch_id,
4247: import_request_id,
4248: parent_table,
4249: parent_id,

Line 4864: INSERT INTO pos_supplier_int_rejections

4860: ' Message: Inside PROCEDURE IMPORT_VENDOR_PRODS_SERVICES' ||
4861: ' Not imported(marked REMOVED) : ' || SQL%ROWCOUNT ||
4862: ' records. Reason interface_status in hz_imp_parties_int = R');
4863:
4864: INSERT INTO pos_supplier_int_rejections
4865: (SELECT p_batch_id,
4866: l_request_id,
4867: 'POS_PRODUCT_SERVICE_INT',
4868: ps_interface_id,

Line 5632: INSERT INTO pos_supplier_int_rejections

5628: ' Message: Inside PROCEDURE IMPORT_VENDOR_BUSS_CLASS' ||
5629: ' Not imported(marked REMOVED) : ' || SQL%ROWCOUNT ||
5630: ' records. Reason interface_status in hz_imp_parties_int = R');
5631:
5632: INSERT INTO pos_supplier_int_rejections
5633: (SELECT p_batch_id,
5634: l_request_id,
5635: 'POS_BUSINESS_CLASS_INT',
5636: business_class_interface_id,

Line 7475: INSERT INTO pos_supplier_int_rejections

7471: ' Message: Inside PROCEDURE IMPORT_VENDOR_TAX_DTLS' ||
7472: ' Not imported(marked REMOVED) : ' || SQL%ROWCOUNT ||
7473: ' records from table pos_party_tax_profile_int. Reason interface_status in hz_imp_parties_int = R');
7474:
7475: INSERT INTO pos_supplier_int_rejections
7476: (SELECT p_batch_id,
7477: l_request_id,
7478: 'POS_PRODUCT_SERVICE_INT',
7479: tax_profile_interface_id,

Line 7510: INSERT INTO pos_supplier_int_rejections

7506: ' Message: Inside PROCEDURE IMPORT_VENDOR_TAX_DTLS' ||
7507: ' Not imported(marked REMOVED) : ' || SQL%ROWCOUNT ||
7508: ' records from table pos_party_tax_reg_int. Reason interface_status in hz_imp_parties_int = R');
7509:
7510: INSERT INTO pos_supplier_int_rejections
7511: (SELECT p_batch_id,
7512: l_request_id,
7513: 'POS_PRODUCT_SERVICE_INT',
7514: tax_reg_interface_id,

Line 7545: INSERT INTO pos_supplier_int_rejections

7541: ' Message: Inside PROCEDURE IMPORT_VENDOR_TAX_DTLS' ||
7542: ' Not imported(marked REMOVED) : ' || SQL%ROWCOUNT ||
7543: ' records from table pos_fiscal_class_int. Reason interface_status in hz_imp_parties_int = R');
7544:
7545: INSERT INTO pos_supplier_int_rejections
7546: (SELECT p_batch_id,
7547: l_request_id,
7548: 'POS_PRODUCT_SERVICE_INT',
7549: fiscal_class_interface_id,

Line 8204: INSERT INTO pos_supplier_int_rejections

8200: ' Message: Inside PROCEDURE IMPORT_VENDOR_BANK_DTLS' ||
8201: ' Not imported(marked REMOVED) : ' || SQL%ROWCOUNT ||
8202: ' records from table pos_bank_account_det_int. Reason interface_status in hz_imp_parties_int = R');
8203:
8204: INSERT INTO pos_supplier_int_rejections
8205: (SELECT p_batch_id,
8206: l_request_id,
8207: 'POS_BANK_ACCOUNT_DET_INT',
8208: bank_account_interface_id,

Line 8239: INSERT INTO pos_supplier_int_rejections

8235: ' Message: Inside PROCEDURE IMPORT_VENDOR_BANK_DTLS' ||
8236: ' Not imported(marked REMOVED) : ' || SQL%ROWCOUNT ||
8237: ' records from table pos_bank_accnt_owners_int. Reason interface_status in hz_imp_parties_int = R');
8238:
8239: INSERT INTO pos_supplier_int_rejections
8240: (SELECT p_batch_id,
8241: l_request_id,
8242: 'POS_BANK_ACCNT_OWNERS_INT',
8243: bank_acct_owner_interface_id,