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_VENDOR_PUB_PKG

Line 619: vendor_rec ap_vendor_pub_pkg.r_vendor_rec_type;

615:
616: l_party_valid VARCHAR2(1);
617: l_payee_valid VARCHAR2(1);
618:
619: vendor_rec ap_vendor_pub_pkg.r_vendor_rec_type;
620:
621: CURSOR party_int_cur IS
622: SELECT ROWID,
623: organization_name,

Line 737: ap_vendor_pub_pkg.g_source := 'IMPORT';

733:
734: -- Setting the vendor source as IMPORT so that the
735: -- errors are logged in the rejections table
736: --
737: ap_vendor_pub_pkg.g_source := 'IMPORT';
738:
739: -- Check if the vendor already exists
740: OPEN check_vendor_exsists(vendor_rec.party_id);
741: FETCH check_vendor_exsists

Line 751: ap_vendor_pub_pkg.validate_vendor(p_api_version => 1.0,

747: IF l_vendor_exists <> 0 THEN
748: l_vendor_exists := 0;
749:
750: /* Call validate vendor in update mode */
751: ap_vendor_pub_pkg.validate_vendor(p_api_version => 1.0,
752: p_init_msg_list => fnd_api.g_false,
753: p_commit => fnd_api.g_false,
754: x_return_status => l_return_status,
755: x_msg_count => l_msg_count,

Line 765: ap_vendor_pub_pkg.validate_vendor(p_api_version => 1.0,

761: x_payee_valid => l_payee_valid,
762: p_vendor_id => l_vendor_id);
763: ELSE
764: /* Call validate vendor in insert mode */
765: ap_vendor_pub_pkg.validate_vendor(p_api_version => 1.0,
766: p_init_msg_list => fnd_api.g_false,
767: p_commit => fnd_api.g_false,
768: x_return_status => l_return_status,
769: x_msg_count => l_msg_count,

Line 856: ' From ap_vendor_pub_pkg.validate_vendor API for party id: ' ||

852:
853: fnd_file.put_line(fnd_file.log,
854: 'Error Message Count: ' || x_msg_count ||
855: ' Error Message Data: ' || x_msg_data ||
856: ' From ap_vendor_pub_pkg.validate_vendor API for party id: ' ||
857: vendor_rec.party_id ||
858: ' or for party_orig_system_reference: ' ||
859: party_int_rec.party_orig_system_reference);
860:

Line 1237: vendor_rec ap_vendor_pub_pkg.r_vendor_rec_type;

1233: l_msg_data VARCHAR2(2000);
1234: l_vendor_id NUMBER;
1235: l_party_id NUMBER;
1236:
1237: vendor_rec ap_vendor_pub_pkg.r_vendor_rec_type;
1238:
1239: CURSOR party_int_cur IS
1240: SELECT organization_name,
1241: organization_name_phonetic,

Line 1355: ap_vendor_pub_pkg.g_source := 'IMPORT';

1351:
1352: -- Setting the vendor source as IMPORT so that the
1353: -- errors are logged in the rejections table
1354: --
1355: ap_vendor_pub_pkg.g_source := 'IMPORT';
1356:
1357: -- bug 9049391
1358: -- If the record is being updated in that case the AP suppliers data
1359: -- has to be synchronized with the TCA repository. This is done by making

Line 1378: ap_vendor_pub_pkg.raise_supplier_event(i_vendor_id => l_vendor_id);

1374: l_sync_msg_count,
1375: l_sync_msg_data,
1376: vendor_rec.party_id);
1377: IF l_sync_return_status = fnd_api.g_ret_sts_success THEN
1378: ap_vendor_pub_pkg.raise_supplier_event(i_vendor_id => l_vendor_id);
1379: x_return_status := fnd_api.g_ret_sts_success;
1380: ELSE
1381: x_return_status := l_sync_return_status;
1382: x_msg_count := l_sync_msg_count;

Line 1387: ap_vendor_pub_pkg.create_vendor(p_api_version => 1.0,

1383: x_msg_data := l_sync_msg_data;
1384: END IF;
1385: ELSE
1386: /* Call create vendor API to create a supplier */
1387: ap_vendor_pub_pkg.create_vendor(p_api_version => 1.0,
1388: p_init_msg_list => fnd_api.g_true,
1389: p_commit => fnd_api.g_false,
1390: p_validation_level => fnd_api.g_valid_level_full,
1391: x_return_status => l_return_status,

Line 1437: ' From ap_vendor_pub_pkg.create_vendor API for party id: ' ||

1433:
1434: fnd_file.put_line(fnd_file.log,
1435: 'Error Message Count: ' || x_msg_count ||
1436: ' Error Message Data: ' || x_msg_data ||
1437: ' From ap_vendor_pub_pkg.create_vendor API for party id: ' ||
1438: vendor_rec.party_id);
1439:
1440: x_return_status := l_return_status;
1441: x_msg_count := l_msg_count;

Line 1448: ap_vendor_pub_pkg.create_vendor(p_api_version => 1.0,

1444:
1445: END IF;
1446: ELSIF party_int_rec.insert_update_flag = 'I' THEN
1447: /* Call create vendor API to create a supplier */
1448: ap_vendor_pub_pkg.create_vendor(p_api_version => 1.0,
1449: p_init_msg_list => fnd_api.g_true,
1450: p_commit => fnd_api.g_false,
1451: p_validation_level => fnd_api.g_valid_level_full,
1452: x_return_status => l_return_status,

Line 1496: ' From ap_vendor_pub_pkg.create_vendor API for party id: ' ||

1492:
1493: fnd_file.put_line(fnd_file.log,
1494: 'Error Message Count: ' || x_msg_count ||
1495: ' Error Message Data: ' || x_msg_data ||
1496: ' From ap_vendor_pub_pkg.create_vendor API for party id: ' ||
1497: vendor_rec.party_id);
1498: x_return_status := l_return_status;
1499: x_msg_count := l_msg_count;
1500: x_msg_data := l_msg_data;

Line 1508: ap_vendor_pub_pkg.raise_supplier_event(i_vendor_id => l_vendor_id);

1504: l_sync_msg_count,
1505: l_sync_msg_data,
1506: vendor_rec.party_id);
1507: IF l_sync_return_status = fnd_api.g_ret_sts_success THEN
1508: ap_vendor_pub_pkg.raise_supplier_event(i_vendor_id => l_vendor_id);
1509: x_return_status := fnd_api.g_ret_sts_success;
1510: ELSE
1511: x_return_status := l_sync_return_status;
1512: x_msg_count := l_sync_msg_count;

Line 1642: p_vendor_rec IN ap_vendor_pub_pkg.r_vendor_rec_type,

1638:
1639: PROCEDURE create_vendor
1640: (
1641: p_batch_id IN NUMBER,
1642: p_vendor_rec IN ap_vendor_pub_pkg.r_vendor_rec_type,
1643: ext_payee_rec IN OUT NOCOPY iby_disbursement_setup_pub.external_payee_rec_type,
1644: x_return_status OUT NOCOPY VARCHAR2,
1645: x_msg_count OUT NOCOPY NUMBER,
1646: x_msg_data OUT NOCOPY VARCHAR2

Line 1682: ap_vendor_pub_pkg.create_vendor(p_api_version => 1.0,

1678: ' vendor_id: ' || p_vendor_rec.vendor_id ||
1679: ' vendor_interface_id: ' ||
1680: p_vendor_rec.vendor_interface_id);
1681:
1682: ap_vendor_pub_pkg.create_vendor(p_api_version => 1.0,
1683: p_init_msg_list => fnd_api.g_true,
1684: p_commit => fnd_api.g_false,
1685: p_validation_level => fnd_api.g_valid_level_full,
1686: x_return_status => l_return_status,

Line 2005: ' failed in ap_vendor_pub_pkg.create_vendor ' ||

2001: l_msg_count := l_error_msg_tbl.first;
2002: WHILE l_msg_count IS NOT NULL LOOP
2003: fnd_file.put_line(fnd_file.log,
2004: ' Message: Inside PROCEDURE CREATE_VENDOR' ||
2005: ' failed in ap_vendor_pub_pkg.create_vendor ' ||
2006: ' vendor_interface_id: ' ||
2007: p_vendor_rec.vendor_interface_id ||
2008: ', No. of Messages: ' || l_msg_count ||
2009: ', Message: ' || l_error_msg_tbl(l_msg_count)

Line 2016: ' failed in ap_vendor_pub_pkg.create_vendor ' ||

2012: END LOOP;
2013: ELSE
2014: fnd_file.put_line(fnd_file.log,
2015: ' Message: Inside PROCEDURE CREATE_VENDOR' ||
2016: ' failed in ap_vendor_pub_pkg.create_vendor ' ||
2017: ' vendor_interface_id: ' ||
2018: p_vendor_rec.vendor_interface_id);
2019: END IF;
2020: x_return_status := l_return_status;

Line 2072: vendor_rec ap_vendor_pub_pkg.r_vendor_rec_type;

2068: AND party.interface_status = 'R')
2069: ORDER BY segment1;
2070:
2071: vendor_int_rec vendor_int_cur%ROWTYPE;
2072: vendor_rec ap_vendor_pub_pkg.r_vendor_rec_type;
2073:
2074: l_vendor_num_code financials_system_parameters.user_defined_vendor_num_code%TYPE;
2075: l_insert_update_flag VARCHAR2(1);
2076:

Line 2163: ap_vendor_pub_pkg.g_source := 'IMPORT';

2159:
2160: COMMIT;
2161:
2162: SAVEPOINT import_vendor_pub;
2163: ap_vendor_pub_pkg.g_source := 'IMPORT';
2164:
2165: -- Cursor processing for vendor interface record
2166: OPEN vendor_int_cur;
2167: LOOP

Line 2464: ' As vendor exists calling ap_vendor_pub_pkg.update_vendor for vendor id : ' ||

2460: l_vendor_exists := 0;
2461:
2462: fnd_file.put_line(fnd_file.log,
2463: ' Message: Inside PROCEDURE IMPORT_VENDORS' ||
2464: ' As vendor exists calling ap_vendor_pub_pkg.update_vendor for vendor id : ' ||
2465: l_vendor_id);
2466:
2467: ap_vendor_pub_pkg.update_vendor(1.0,
2468: fnd_api.g_false,

Line 2467: ap_vendor_pub_pkg.update_vendor(1.0,

2463: ' Message: Inside PROCEDURE IMPORT_VENDORS' ||
2464: ' As vendor exists calling ap_vendor_pub_pkg.update_vendor for vendor id : ' ||
2465: l_vendor_id);
2466:
2467: ap_vendor_pub_pkg.update_vendor(1.0,
2468: fnd_api.g_false,
2469: fnd_api.g_false,
2470: fnd_api.g_valid_level_full,
2471: l_return_status,

Line 2534: ' failed in ap_vendor_pub_pkg.update_vendor ' ||

2530: END IF;
2531:
2532: fnd_file.put_line(fnd_file.log,
2533: ' Message: Inside PROCEDURE IMPORT_VENDORS' ||
2534: ' failed in ap_vendor_pub_pkg.update_vendor ' ||
2535: ' vendor_interface_id: ' ||
2536: vendor_rec.vendor_interface_id ||
2537: ', No. of Messages: ' || l_msg_count ||
2538: ', Message: ' || l_msg_data ||

Line 2601: p_site_rec IN ap_vendor_pub_pkg.r_vendor_site_rec_type,

2597:
2598: PROCEDURE create_vendor_site
2599: (
2600: p_batch_id IN NUMBER,
2601: p_site_rec IN ap_vendor_pub_pkg.r_vendor_site_rec_type,
2602: ext_payee_rec IN OUT NOCOPY iby_disbursement_setup_pub.external_payee_rec_type,
2603: x_return_status OUT NOCOPY VARCHAR2,
2604: x_msg_count OUT NOCOPY NUMBER,
2605: x_msg_data OUT NOCOPY VARCHAR2

Line 2653: ap_vendor_pub_pkg.create_vendor_site(p_api_version => 1.0,

2649: p_site_rec.vendor_site_interface_id);
2650:
2651: SAVEPOINT import_vendor_sites_pub2;
2652:
2653: ap_vendor_pub_pkg.create_vendor_site(p_api_version => 1.0,
2654: p_init_msg_list => fnd_api.g_true,
2655: p_commit => fnd_api.g_false,
2656: p_validation_level => fnd_api.g_valid_level_full,
2657: x_return_status => l_return_status,

Line 2986: ' failed in ap_vendor_pub_pkg.create_vendor_site ' ||

2982: l_msg_count := l_error_msg_tbl.first;
2983: WHILE l_msg_count IS NOT NULL LOOP
2984: fnd_file.put_line(fnd_file.log,
2985: ' Message: Inside PROCEDURE CREATE_VENDOR_SITE' ||
2986: ' failed in ap_vendor_pub_pkg.create_vendor_site ' ||
2987: ' vendor_site_interface_id: ' ||
2988: p_site_rec.vendor_site_interface_id ||
2989: ', No. of Messages: ' || l_msg_count ||
2990: ', Message: ' || l_error_msg_tbl(l_msg_count)

Line 2997: ' failed in ap_vendor_pub_pkg.create_vendor_site ' ||

2993: END LOOP;
2994: ELSE
2995: fnd_file.put_line(fnd_file.log,
2996: ' Message: Inside PROCEDURE CREATE_VENDOR_SITE' ||
2997: ' failed in ap_vendor_pub_pkg.create_vendor_site ' ||
2998: ' vendor_site_interface_id: ' ||
2999: p_site_rec.vendor_site_interface_id);
3000: END IF;
3001: x_return_status := l_return_status;

Line 3055: site_rec ap_vendor_pub_pkg.r_vendor_site_rec_type;

3051: party.site_orig_system_reference
3052: AND party.interface_status = 'R');
3053:
3054: site_int_rec site_int_cur%ROWTYPE;
3055: site_rec ap_vendor_pub_pkg.r_vendor_site_rec_type;
3056:
3057: /* Variable Declaration for IBY */
3058: ext_payee_rec iby_disbursement_setup_pub.external_payee_rec_type;
3059:

Line 3184: ap_vendor_pub_pkg.g_source := 'IMPORT';

3180: SAVEPOINT import_vendor_sites_pub; --Incase there is an unexpected error in loop below,
3181: --the rollback in exception can happen to this savepoint, since
3182: --after commit the savepoint set at the begining would be lost.
3183:
3184: ap_vendor_pub_pkg.g_source := 'IMPORT';
3185:
3186: -- Cursor processing for vendor site interface record
3187: OPEN site_int_cur;
3188: LOOP

Line 3492: ' ap_vendor_pub_pkg.update_vendor_site for vendor_site_id: ' ||

3488:
3489: fnd_file.put_line(fnd_file.log,
3490: ' Message: Inside PROCEDURE IMPORT_VENDOR_SITES' ||
3491: ' As vendor site exists calling' ||
3492: ' ap_vendor_pub_pkg.update_vendor_site for vendor_site_id: ' ||
3493: l_vendor_site_id);
3494:
3495: site_rec.vendor_site_code := null; --Bug 16441477 avoid duplicate supplier site checking
3496:

Line 3497: ap_vendor_pub_pkg.update_vendor_site(1.0,

3493: l_vendor_site_id);
3494:
3495: site_rec.vendor_site_code := null; --Bug 16441477 avoid duplicate supplier site checking
3496:
3497: ap_vendor_pub_pkg.update_vendor_site(1.0,
3498: fnd_api.g_false,
3499: fnd_api.g_false,
3500: fnd_api.g_valid_level_full,
3501: l_return_status,

Line 3566: ' failed in ap_vendor_pub_pkg.update_vendor_site ' ||

3562: END IF;
3563:
3564: fnd_file.put_line(fnd_file.log,
3565: ' Message: Inside PROCEDURE IMPORT_VENDOR_SITES' ||
3566: ' failed in ap_vendor_pub_pkg.update_vendor_site ' ||
3567: ' vendor_site_interface_id: ' ||
3568: site_rec.vendor_site_interface_id ||
3569: ', No. of Messages: ' || l_msg_count ||
3570: ', Message: ' || l_msg_data ||

Line 3636: p_vendor_contact_rec IN ap_vendor_pub_pkg.r_vendor_contact_rec_type

3632: p_batch_id IN NUMBER,
3633: x_return_status OUT NOCOPY VARCHAR2,
3634: x_msg_count OUT NOCOPY NUMBER,
3635: x_msg_data OUT NOCOPY VARCHAR2,
3636: p_vendor_contact_rec IN ap_vendor_pub_pkg.r_vendor_contact_rec_type
3637: ) IS
3638: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_VENDOR_CONTACT';
3639: l_request_id NUMBER := fnd_global.conc_request_id;
3640:

Line 3678: ap_vendor_pub_pkg.create_vendor_contact(p_api_version => 1.0,

3674: -- already has such assignment
3675: CLOSE l_cur;
3676: l_return_status := fnd_api.g_ret_sts_success;
3677: ELSE
3678: ap_vendor_pub_pkg.create_vendor_contact(p_api_version => 1.0,
3679: p_init_msg_list => fnd_api.g_true,
3680: p_commit => fnd_api.g_false,
3681: p_validation_level => fnd_api.g_valid_level_full,
3682: x_return_status => l_return_status,

Line 3770: vendor_contact_rec ap_vendor_pub_pkg.r_vendor_contact_rec_type;

3766: party.contact_orig_system_reference
3767: AND party.interface_status = 'R');
3768:
3769: contact_int_rec contact_int_cur%ROWTYPE;
3770: vendor_contact_rec ap_vendor_pub_pkg.r_vendor_contact_rec_type;
3771:
3772: BEGIN
3773: -- Initialize API return status to success
3774: x_return_status := fnd_api.g_ret_sts_success;

Line 3887: ap_vendor_pub_pkg.g_source := 'IMPORT';

3883: COMMIT;
3884:
3885: SAVEPOINT import_vendor_contact_pub;
3886:
3887: ap_vendor_pub_pkg.g_source := 'IMPORT';
3888:
3889: -- Cursor processing for vendor contact interface record
3890: OPEN contact_int_cur;
3891: LOOP