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 FND_MSG_PUB

Line 215: fnd_msg_pub.add;

211: EXCEPTION
212: WHEN OTHERS THEN
213: x_return_status := fnd_api.g_ret_sts_unexp_error;
214: fnd_message.set_name('SQLAP', 'AP_INVALID_PARTY');
215: fnd_msg_pub.add;
216: fnd_msg_pub.count_and_get(p_count => x_msg_count,
217: p_data => x_msg_data);
218: fnd_file.put_line(fnd_file.log,
219: ' Inside check_party_exist EXCEPTION ' ||

Line 216: fnd_msg_pub.count_and_get(p_count => x_msg_count,

212: WHEN OTHERS THEN
213: x_return_status := fnd_api.g_ret_sts_unexp_error;
214: fnd_message.set_name('SQLAP', 'AP_INVALID_PARTY');
215: fnd_msg_pub.add;
216: fnd_msg_pub.count_and_get(p_count => x_msg_count,
217: p_data => x_msg_data);
218: fnd_file.put_line(fnd_file.log,
219: ' Inside check_party_exist EXCEPTION ' ||
220: ' Message: ' || SQLCODE || ' ' || SQLERRM);

Line 379: fnd_msg_pub.add;

375: EXCEPTION
376: WHEN OTHERS THEN
377: x_return_status := fnd_api.g_ret_sts_unexp_error;
378: fnd_message.set_name('SQLAP', 'AP_INVALID_PARTY_SITE');
379: fnd_msg_pub.add;
380: fnd_msg_pub.count_and_get(p_count => x_msg_count,
381: p_data => x_msg_data);
382: fnd_file.put_line(fnd_file.log,
383: ' Inside check_party_site_exist EXCEPTION ' ||

Line 380: fnd_msg_pub.count_and_get(p_count => x_msg_count,

376: WHEN OTHERS THEN
377: x_return_status := fnd_api.g_ret_sts_unexp_error;
378: fnd_message.set_name('SQLAP', 'AP_INVALID_PARTY_SITE');
379: fnd_msg_pub.add;
380: fnd_msg_pub.count_and_get(p_count => x_msg_count,
381: p_data => x_msg_data);
382: fnd_file.put_line(fnd_file.log,
383: ' Inside check_party_site_exist EXCEPTION ' ||
384: ' Message: ' || SQLCODE || ' ' || SQLERRM);

Line 591: fnd_msg_pub.count_and_get(p_count => x_msg_count,

587: EXCEPTION
588: WHEN OTHERS THEN
589: x_return_status := fnd_api.g_ret_sts_unexp_error;
590:
591: fnd_msg_pub.count_and_get(p_count => x_msg_count,
592: p_data => x_msg_data);
593:
594: fnd_file.put_line(fnd_file.log,
595: ' Inside check_party_contact_exist EXCEPTION ' ||

Line 874: fnd_msg_pub.add;

870: EXCEPTION
871: WHEN OTHERS THEN
872: x_return_status := fnd_api.g_ret_sts_unexp_error;
873: fnd_message.set_name('SQLAP', 'AP_INVALID_PARTY');
874: fnd_msg_pub.add;
875: fnd_msg_pub.count_and_get(p_count => x_msg_count,
876: p_data => x_msg_data);
877:
878: fnd_file.put_line(fnd_file.log,

Line 875: fnd_msg_pub.count_and_get(p_count => x_msg_count,

871: WHEN OTHERS THEN
872: x_return_status := fnd_api.g_ret_sts_unexp_error;
873: fnd_message.set_name('SQLAP', 'AP_INVALID_PARTY');
874: fnd_msg_pub.add;
875: fnd_msg_pub.count_and_get(p_count => x_msg_count,
876: p_data => x_msg_data);
877:
878: fnd_file.put_line(fnd_file.log,
879: ' Inside validate_vendor EXCEPTION ' ||

Line 1023: fnd_msg_pub.add;

1019: EXCEPTION
1020: WHEN OTHERS THEN
1021: x_return_status := fnd_api.g_ret_sts_unexp_error;
1022: fnd_message.set_name('SQLAP', 'AP_INVALID_PARTY');
1023: fnd_msg_pub.add;
1024: fnd_msg_pub.count_and_get(p_count => x_msg_count,
1025: p_data => x_msg_data);
1026:
1027: fnd_file.put_line(fnd_file.log,

Line 1024: fnd_msg_pub.count_and_get(p_count => x_msg_count,

1020: WHEN OTHERS THEN
1021: x_return_status := fnd_api.g_ret_sts_unexp_error;
1022: fnd_message.set_name('SQLAP', 'AP_INVALID_PARTY');
1023: fnd_msg_pub.add;
1024: fnd_msg_pub.count_and_get(p_count => x_msg_count,
1025: p_data => x_msg_data);
1026:
1027: fnd_file.put_line(fnd_file.log,
1028: ' Inside update_contact_dtls EXCEPTION ' ||

Line 1064: fnd_msg_pub.add;

1060: EXCEPTION
1061: WHEN OTHERS THEN
1062: x_return_status := fnd_api.g_ret_sts_unexp_error;
1063: fnd_message.set_name('SQLAP', 'AP_INVALID_PARTY');
1064: fnd_msg_pub.add;
1065: fnd_msg_pub.count_and_get(p_count => x_msg_count,
1066: p_data => x_msg_data);
1067:
1068: fnd_file.put_line(fnd_file.log,

Line 1065: fnd_msg_pub.count_and_get(p_count => x_msg_count,

1061: WHEN OTHERS THEN
1062: x_return_status := fnd_api.g_ret_sts_unexp_error;
1063: fnd_message.set_name('SQLAP', 'AP_INVALID_PARTY');
1064: fnd_msg_pub.add;
1065: fnd_msg_pub.count_and_get(p_count => x_msg_count,
1066: p_data => x_msg_data);
1067:
1068: fnd_file.put_line(fnd_file.log,
1069: ' Inside update_party_id EXCEPTION ' ||

Line 1118: fnd_msg_pub.add;

1114: EXCEPTION
1115: WHEN OTHERS THEN
1116: x_return_status := fnd_api.g_ret_sts_unexp_error;
1117: fnd_message.set_name('SQLAP', 'AP_INVALID_PARTY');
1118: fnd_msg_pub.add;
1119: fnd_msg_pub.count_and_get(p_count => x_msg_count,
1120: p_data => x_msg_data);
1121:
1122: fnd_file.put_line(fnd_file.log,

Line 1119: fnd_msg_pub.count_and_get(p_count => x_msg_count,

1115: WHEN OTHERS THEN
1116: x_return_status := fnd_api.g_ret_sts_unexp_error;
1117: fnd_message.set_name('SQLAP', 'AP_INVALID_PARTY');
1118: fnd_msg_pub.add;
1119: fnd_msg_pub.count_and_get(p_count => x_msg_count,
1120: p_data => x_msg_data);
1121:
1122: fnd_file.put_line(fnd_file.log,
1123: ' Inside update_party_site_id EXCEPTION ' ||

Line 1209: fnd_msg_pub.add;

1205: EXCEPTION
1206: WHEN OTHERS THEN
1207: x_return_status := fnd_api.g_ret_sts_unexp_error;
1208: fnd_message.set_name('SQLAP', 'AP_INVALID_PARTY');
1209: fnd_msg_pub.add;
1210: fnd_msg_pub.count_and_get(p_count => x_msg_count,
1211: p_data => x_msg_data);
1212:
1213: fnd_file.put_line(fnd_file.log,

Line 1210: fnd_msg_pub.count_and_get(p_count => x_msg_count,

1206: WHEN OTHERS THEN
1207: x_return_status := fnd_api.g_ret_sts_unexp_error;
1208: fnd_message.set_name('SQLAP', 'AP_INVALID_PARTY');
1209: fnd_msg_pub.add;
1210: fnd_msg_pub.count_and_get(p_count => x_msg_count,
1211: p_data => x_msg_data);
1212:
1213: fnd_file.put_line(fnd_file.log,
1214: ' Inside pre_processing EXCEPTION ' || ' Message: ' ||

Line 1524: fnd_msg_pub.add;

1520: EXCEPTION
1521: WHEN OTHERS THEN
1522: x_return_status := fnd_api.g_ret_sts_unexp_error;
1523: fnd_message.set_name('SQLAP', 'AP_INVALID_PARTY');
1524: fnd_msg_pub.add;
1525: fnd_msg_pub.count_and_get(p_count => x_msg_count,
1526: p_data => x_msg_data);
1527:
1528: fnd_file.put_line(fnd_file.log,

Line 1525: fnd_msg_pub.count_and_get(p_count => x_msg_count,

1521: WHEN OTHERS THEN
1522: x_return_status := fnd_api.g_ret_sts_unexp_error;
1523: fnd_message.set_name('SQLAP', 'AP_INVALID_PARTY');
1524: fnd_msg_pub.add;
1525: fnd_msg_pub.count_and_get(p_count => x_msg_count,
1526: p_data => x_msg_data);
1527:
1528: fnd_file.put_line(fnd_file.log,
1529: ' Inside enable_party_as_supplier EXCEPTION ' ||

Line 1630: fnd_msg_pub.add;

1626: EXCEPTION
1627: WHEN OTHERS THEN
1628: x_return_status := fnd_api.g_ret_sts_unexp_error;
1629: fnd_message.set_name('SQLAP', 'AP_INVALID_PARTY_CONTACT');
1630: fnd_msg_pub.add;
1631: fnd_msg_pub.count_and_get(p_count => x_msg_count,
1632: p_data => x_msg_data);
1633:
1634: fnd_file.put_line(fnd_file.log,

Line 1631: fnd_msg_pub.count_and_get(p_count => x_msg_count,

1627: WHEN OTHERS THEN
1628: x_return_status := fnd_api.g_ret_sts_unexp_error;
1629: fnd_message.set_name('SQLAP', 'AP_INVALID_PARTY_CONTACT');
1630: fnd_msg_pub.add;
1631: fnd_msg_pub.count_and_get(p_count => x_msg_count,
1632: p_data => x_msg_data);
1633:
1634: fnd_file.put_line(fnd_file.log,
1635: ' Inside enable_partycont_as_suppcont EXCEPTION ' ||

Line 1825: fnd_msg_pub.count_and_get(p_count => l_msg_count,

1821: g_login_id,
1822: 'Import_Vendor') <> TRUE) THEN
1823:
1824: IF (g_level_procedure >= g_current_runtime_level) THEN
1825: fnd_msg_pub.count_and_get(p_count => l_msg_count,
1826: p_data => l_msg_data);
1827: fnd_log.string(g_level_procedure,
1828: g_module_name || l_api_name,
1829: 'Parameters: ' ||

Line 1837: fnd_msg_pub.add;

1833: END IF;
1834: END IF;
1835:
1836: fnd_message.set_name('SQLAP', 'AP_BANK_ACCT_CREATION');
1837: fnd_msg_pub.add;
1838:
1839: fnd_file.put_line(fnd_file.log,
1840: ' Message: Inside PROCEDURE CREATE_VENDOR' ||
1841: ' failed in iby_disbursement_setup_pub.create_temp_ext_bank_acct ' ||

Line 1864: fnd_msg_pub.count_and_get(p_count => l_msg_count,

1860: g_login_id,
1861: 'Import_Vendor') <> TRUE) THEN
1862:
1863: IF (g_level_procedure >= g_current_runtime_level) THEN
1864: fnd_msg_pub.count_and_get(p_count => l_msg_count,
1865: p_data => l_msg_data);
1866: fnd_log.string(g_level_procedure,
1867: g_module_name || l_api_name,
1868: 'Parameters: ' || ' Vendor_Interface_Id: ' ||

Line 1875: fnd_msg_pub.add;

1871: END IF;
1872: END IF;
1873:
1874: fnd_message.set_name('SQLAP', 'AP_INVALID_BANK_ACCT_INFO');
1875: fnd_msg_pub.add;
1876:
1877: fnd_file.put_line(fnd_file.log,
1878: ' Message: Inside PROCEDURE CREATE_VENDOR' ||
1879: ' failed in iby_disbursement_setup_pub.validate_temp_ext_bank_acct ' ||

Line 1901: fnd_msg_pub.count_and_get(p_count => l_msg_count,

1897: g_login_id,
1898: 'Import_Vendor') <> TRUE) THEN
1899:
1900: IF (g_level_procedure >= g_current_runtime_level) THEN
1901: fnd_msg_pub.count_and_get(p_count => l_msg_count,
1902: p_data => l_msg_data);
1903: fnd_log.string(g_level_procedure,
1904: g_module_name || l_api_name,
1905: 'Parameters: ' || ' Vendor_Interface_Id: ' ||

Line 1912: fnd_msg_pub.add;

1908: END IF;
1909: END IF;
1910:
1911: fnd_message.set_name('SQLAP', 'AP_PAYEE_CREATION');
1912: fnd_msg_pub.add;
1913:
1914: fnd_file.put_line(fnd_file.log,
1915: ' Message: Inside PROCEDURE CREATE_VENDOR' ||
1916: ' failed in iby_disbursement_setup_pub.create_external_payee ' ||

Line 1935: fnd_msg_pub.count_and_get(p_count => l_msg_count,

1931: g_login_id,
1932: 'Import_Vendor') <> TRUE) THEN
1933:
1934: IF (g_level_procedure >= g_current_runtime_level) THEN
1935: fnd_msg_pub.count_and_get(p_count => l_msg_count,
1936: p_data => l_msg_data);
1937: fnd_log.string(g_level_procedure,
1938: g_module_name || l_api_name,
1939: 'Parameters: ' || ' Vendor_Interface_Id: ' ||

Line 1946: fnd_msg_pub.add;

1942: END IF;
1943: END IF;
1944:
1945: fnd_message.set_name('SQLAP', 'AP_INVALID_PAYEE');
1946: fnd_msg_pub.add;
1947:
1948: fnd_file.put_line(fnd_file.log,
1949: ' Message: Inside PROCEDURE CREATE_VENDOR' ||
1950: ' failed in iby_disbursement_setup_pub.validate_external_payee ' ||

Line 2029: fnd_msg_pub.count_and_get(p_count => x_msg_count,

2025: EXCEPTION
2026: WHEN OTHERS THEN
2027: x_return_status := fnd_api.g_ret_sts_unexp_error;
2028:
2029: fnd_msg_pub.count_and_get(p_count => x_msg_count,
2030: p_data => x_msg_data);
2031:
2032: fnd_file.put_line(fnd_file.log,
2033: ' Inside create_vendor EXCEPTION ' || ' Message: ' ||

Line 2215: fnd_msg_pub.count_and_get(p_count => l_msg_count,

2211: g_login_id,
2212: 'IMPORT_VENDORS') <> TRUE) THEN
2213:
2214: IF (g_level_procedure >= g_current_runtime_level) THEN
2215: fnd_msg_pub.count_and_get(p_count => l_msg_count,
2216: p_data => l_msg_data);
2217: fnd_log.string(g_level_procedure,
2218: g_module_name || l_api_name,
2219: ' Rejected Vendor_Interface_Id: ' ||

Line 2393: fnd_msg_pub.count_and_get(p_count => l_msg_count,

2389: g_login_id,
2390: 'IMPORT_VENDORS') <> TRUE) THEN
2391:
2392: IF (g_level_procedure >= g_current_runtime_level) THEN
2393: fnd_msg_pub.count_and_get(p_count => l_msg_count,
2394: p_data => l_msg_data);
2395: fnd_log.string(g_level_procedure,
2396: g_module_name || l_api_name,
2397: ' Rejected vendor_interface_id: ' ||

Line 2569: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

2565: COMMIT WORK;
2566:
2567: -- Standard call to get message count and if count is 1,
2568: -- get message info.
2569: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2570: EXCEPTION
2571: WHEN fnd_api.g_exc_error THEN
2572: ROLLBACK TO import_vendor_pub;
2573: x_return_status := fnd_api.g_ret_sts_error;

Line 2574: fnd_msg_pub.count_and_get(p_count => x_msg_count,

2570: EXCEPTION
2571: WHEN fnd_api.g_exc_error THEN
2572: ROLLBACK TO import_vendor_pub;
2573: x_return_status := fnd_api.g_ret_sts_error;
2574: fnd_msg_pub.count_and_get(p_count => x_msg_count,
2575: p_data => x_msg_data);
2576: fnd_file.put_line(fnd_file.log,
2577: ' Inside import_vendors EXCEPTION ' || ' Message: ' ||
2578: SQLCODE || ' ' || SQLERRM);

Line 2582: fnd_msg_pub.count_and_get(p_count => x_msg_count,

2578: SQLCODE || ' ' || SQLERRM);
2579: WHEN fnd_api.g_exc_unexpected_error THEN
2580: ROLLBACK TO import_vendor_pub;
2581: x_return_status := fnd_api.g_ret_sts_unexp_error;
2582: fnd_msg_pub.count_and_get(p_count => x_msg_count,
2583: p_data => x_msg_data);
2584: fnd_file.put_line(fnd_file.log,
2585: ' Inside import_vendors unexcepted EXCEPTION ' ||
2586: ' Message: ' || SQLCODE || ' ' || SQLERRM);

Line 2591: fnd_msg_pub.count_and_get(p_count => x_msg_count,

2587: WHEN OTHERS THEN
2588: ROLLBACK TO import_vendor_pub;
2589: x_return_status := fnd_api.g_ret_sts_unexp_error;
2590:
2591: fnd_msg_pub.count_and_get(p_count => x_msg_count,
2592: p_data => x_msg_data);
2593: fnd_file.put_line(fnd_file.log,
2594: ' Inside import_vendors others EXCEPTION ' ||
2595: ' Message: ' || SQLCODE || ' ' || SQLERRM);

Line 2702: fnd_msg_pub.count_and_get(p_count => l_payee_msg_count,

2698: ext_payee_rec.payment_function
2699: FROM po_vendors
2700: WHERE vendor_id = p_site_rec.vendor_id;
2701:
2702: fnd_msg_pub.count_and_get(p_count => l_payee_msg_count,
2703: p_data => l_payee_msg_data);
2704:
2705: /* Calling IBY Payee Validation API */
2706: iby_disbursement_setup_pub.validate_external_payee(p_api_version => 1.0,

Line 2777: fnd_msg_pub.add;

2773: ELSE
2774: l_rollback_vendor_site := 'Y';
2775:
2776: fnd_message.set_name('SQLAP', 'AP_BANK_ACCT_CREATION');
2777: fnd_msg_pub.add;
2778:
2779: END IF; -- Bank Account Creation API
2780:
2781: ELSE

Line 2785: fnd_msg_pub.add;

2781: ELSE
2782: l_rollback_vendor_site := 'Y';
2783:
2784: fnd_message.set_name('SQLAP', 'AP_INVALID_BANK_ACCT_INFO');
2785: fnd_msg_pub.add;
2786:
2787: END IF; -- Bank Account Validation API
2788:
2789: END LOOP;

Line 2817: fnd_msg_pub.count_and_get(p_count => l_msg_count,

2813: g_login_id,
2814: 'Create_Vendor_Site') <> TRUE) THEN
2815:
2816: IF (g_level_procedure >= g_current_runtime_level) THEN
2817: fnd_msg_pub.count_and_get(p_count => l_msg_count,
2818: p_data => l_msg_data);
2819: fnd_log.string(g_level_procedure,
2820: g_module_name || l_api_name,
2821: 'Parameters: ' ||

Line 2851: fnd_msg_pub.count_and_get(p_count => l_msg_count,

2847: g_login_id,
2848: 'Create_Vendor_Site') <> TRUE) THEN
2849:
2850: IF (g_level_procedure >= g_current_runtime_level) THEN
2851: fnd_msg_pub.count_and_get(p_count => l_msg_count,
2852: p_data => l_msg_data);
2853: fnd_log.string(g_level_procedure,
2854: g_module_name || l_api_name,
2855: 'Parameters: ' ||

Line 2863: fnd_msg_pub.add;

2859: END IF;
2860: END IF;
2861:
2862: fnd_message.set_name('SQLAP', 'AP_PAYEE_CREATION');
2863: fnd_msg_pub.add;
2864:
2865: fnd_file.put_line(fnd_file.log,
2866: ' Message: Inside PROCEDURE CREATE_VENDOR_SITE' ||
2867: ' failed in payee creation ' ||

Line 2885: fnd_msg_pub.count_and_get(p_count => l_msg_count,

2881: g_login_id,
2882: 'Create_Vendor_Site') <> TRUE) THEN
2883:
2884: IF (g_level_procedure >= g_current_runtime_level) THEN
2885: fnd_msg_pub.count_and_get(p_count => l_msg_count,
2886: p_data => l_msg_data);
2887: fnd_log.string(g_level_procedure,
2888: g_module_name || l_api_name,
2889: 'Parameters: ' || ' Vendor_Site_Interface_Id: ' ||

Line 2909: l_error_code := fnd_msg_pub.get(p_msg_index => i,

2905: -- If the l_msg_data is null then the IBY service returned
2906: -- more than one error. The calling module will need to get
2907: -- them from the message stack
2908: FOR i IN l_payee_msg_count .. l_msg_count LOOP
2909: l_error_code := fnd_msg_pub.get(p_msg_index => i,
2910: p_encoded => 'F');
2911:
2912: IF i = l_payee_msg_count THEN
2913: l_error_code := '4)Error in ' || l_debug_info ||

Line 2924: fnd_msg_pub.add;

2920:
2921: END IF;
2922:
2923: fnd_message.set_name('SQLAP', 'AP_INVALID_PAYEE_INFO');
2924: fnd_msg_pub.add;
2925:
2926: fnd_file.put_line(fnd_file.log,
2927: ' Message: Inside PROCEDURE CREATE_VENDOR_SITE' ||
2928: ' failed in payee validation ' ||

Line 3010: fnd_msg_pub.count_and_get(p_count => x_msg_count,

3006: EXCEPTION
3007: WHEN OTHERS THEN
3008: x_return_status := fnd_api.g_ret_sts_unexp_error;
3009:
3010: fnd_msg_pub.count_and_get(p_count => x_msg_count,
3011: p_data => x_msg_data);
3012: fnd_file.put_line(fnd_file.log,
3013: ' Inside create_vendor_site EXCEPTION ' ||
3014: ' Message: ' || SQLCODE || ' ' || SQLERRM);

Line 3081: -- fnd_msg_pub.initialize;

3077:
3078: -- Standard Start of API savepoint
3079: SAVEPOINT import_vendor_sites_pub;
3080:
3081: -- fnd_msg_pub.initialize;
3082:
3083: -- Initialize API return status to success
3084: x_return_status := fnd_api.g_ret_sts_success;
3085:

Line 3229: fnd_msg_pub.count_and_get(p_count => l_msg_count,

3225: g_login_id,
3226: 'IMPORT_VENDOR_SITES') <> TRUE) THEN
3227:
3228: IF (g_level_procedure >= g_current_runtime_level) THEN
3229: fnd_msg_pub.count_and_get(p_count => l_msg_count,
3230: p_data => l_msg_data);
3231: fnd_log.string(g_level_procedure,
3232: g_module_name || l_api_name,
3233: ' Rejected vendor_site_interface_id: ' ||

Line 3600: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

3596: COMMIT WORK;
3597:
3598: -- Standard call to get message count and if count is 1,
3599: -- get message info.
3600: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3601:
3602: EXCEPTION
3603: WHEN fnd_api.g_exc_error THEN
3604: ROLLBACK TO import_vendor_sites_pub;

Line 3606: fnd_msg_pub.count_and_get(p_count => x_msg_count,

3602: EXCEPTION
3603: WHEN fnd_api.g_exc_error THEN
3604: ROLLBACK TO import_vendor_sites_pub;
3605: x_return_status := fnd_api.g_ret_sts_error;
3606: fnd_msg_pub.count_and_get(p_count => x_msg_count,
3607: p_data => x_msg_data);
3608: fnd_file.put_line(fnd_file.log,
3609: ' Inside import_vendor_sites EXCEPTION ' ||
3610: ' Message: ' || SQLCODE || ' ' || SQLERRM);

Line 3614: fnd_msg_pub.count_and_get(p_count => x_msg_count,

3610: ' Message: ' || SQLCODE || ' ' || SQLERRM);
3611: WHEN fnd_api.g_exc_unexpected_error THEN
3612: ROLLBACK TO import_vendor_sites_pub;
3613: x_return_status := fnd_api.g_ret_sts_unexp_error;
3614: fnd_msg_pub.count_and_get(p_count => x_msg_count,
3615: p_data => x_msg_data);
3616: fnd_file.put_line(fnd_file.log,
3617: ' Inside import_vendor_sites unexcepted EXCEPTION ' ||
3618: ' Message: ' || SQLCODE || ' ' || SQLERRM);

Line 3623: fnd_msg_pub.count_and_get(p_count => x_msg_count,

3619: WHEN OTHERS THEN
3620: ROLLBACK TO import_vendor_sites_pub;
3621: x_return_status := fnd_api.g_ret_sts_unexp_error;
3622:
3623: fnd_msg_pub.count_and_get(p_count => x_msg_count,
3624: p_data => x_msg_data);
3625: fnd_file.put_line(fnd_file.log,
3626: ' Inside import_vendor_sites others EXCEPTION ' ||
3627: ' Message: ' || SQLCODE || ' ' || SQLERRM);

Line 3724: fnd_msg_pub.count_and_get(p_count => x_msg_count,

3720: EXCEPTION
3721: WHEN OTHERS THEN
3722: x_return_status := fnd_api.g_ret_sts_unexp_error;
3723:
3724: fnd_msg_pub.count_and_get(p_count => x_msg_count,
3725: p_data => x_msg_data);
3726: fnd_file.put_line(fnd_file.log,
3727: ' Inside create_vendor_contact EXCEPTION ' ||
3728: ' Message: ' || SQLCODE || ' ' || SQLERRM);

Line 3948: fnd_msg_pub.count_and_get(p_count => l_msg_count,

3944: g_login_id,
3945: 'IMPORT_VENDOR_CONTACTS') <> TRUE) THEN
3946:
3947: IF (g_level_procedure >= g_current_runtime_level) THEN
3948: fnd_msg_pub.count_and_get(p_count => l_msg_count,
3949: p_data => l_msg_data);
3950: fnd_log.string(g_level_procedure,
3951: g_module_name || l_api_name,
3952: ' Rejected vendor_contact_interface_id: ' ||

Line 4012: fnd_msg_pub.count_and_get(p_count => l_msg_count,

4008: g_login_id,
4009: 'IMPORT_VENDOR_CONTACTS') <> TRUE) THEN
4010:
4011: IF (g_level_procedure >= g_current_runtime_level) THEN
4012: fnd_msg_pub.count_and_get(p_count => l_msg_count,
4013: p_data => l_msg_data);
4014: fnd_log.string(g_level_procedure,
4015: g_module_name || l_api_name,
4016: ' Rejected vendor_contact_interface_id: ' ||

Line 4115: fnd_msg_pub.count_and_get(p_count => l_msg_count,

4111: g_login_id,
4112: 'IMPORT_VENDOR_CONTACTS') <> TRUE) THEN
4113:
4114: IF (g_level_procedure >= g_current_runtime_level) THEN
4115: fnd_msg_pub.count_and_get(p_count => l_msg_count,
4116: p_data => l_msg_data);
4117: fnd_log.string(g_level_procedure,
4118: g_module_name || l_api_name,
4119: ' Rejected vendor_contact_interface_id: ' ||

Line 4171: fnd_msg_pub.count_and_get(p_count => l_msg_count,

4167: g_login_id,
4168: 'IMPORT_VENDOR_CONTACTS') <> TRUE) THEN
4169:
4170: IF (g_level_procedure >= g_current_runtime_level) THEN
4171: fnd_msg_pub.count_and_get(p_count => l_msg_count,
4172: p_data => l_msg_data);
4173: fnd_log.string(g_level_procedure,
4174: g_module_name || l_api_name,
4175: ' Rejected vendor_contact_interface_id: ' ||

Line 4285: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

4281: COMMIT WORK;
4282:
4283: -- Standard call to get message count and if count is 1,
4284: -- get message info.
4285: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4286:
4287: EXCEPTION
4288: WHEN fnd_api.g_exc_error THEN
4289: ROLLBACK TO import_vendor_contact_pub;

Line 4291: fnd_msg_pub.count_and_get(p_count => x_msg_count,

4287: EXCEPTION
4288: WHEN fnd_api.g_exc_error THEN
4289: ROLLBACK TO import_vendor_contact_pub;
4290: x_return_status := fnd_api.g_ret_sts_error;
4291: fnd_msg_pub.count_and_get(p_count => x_msg_count,
4292: p_data => x_msg_data);
4293: fnd_file.put_line(fnd_file.log,
4294: ' Inside import_vendor_contacts EXCEPTION ' ||
4295: ' Message: ' || SQLCODE || ' ' || SQLERRM);

Line 4299: fnd_msg_pub.count_and_get(p_count => x_msg_count,

4295: ' Message: ' || SQLCODE || ' ' || SQLERRM);
4296: WHEN fnd_api.g_exc_unexpected_error THEN
4297: ROLLBACK TO import_vendor_contact_pub;
4298: x_return_status := fnd_api.g_ret_sts_unexp_error;
4299: fnd_msg_pub.count_and_get(p_count => x_msg_count,
4300: p_data => x_msg_data);
4301: fnd_file.put_line(fnd_file.log,
4302: ' Inside import_vendor_contacts unexpected EXCEPTION ' ||
4303: ' Message: ' || SQLCODE || ' ' || SQLERRM);

Line 4308: fnd_msg_pub.count_and_get(p_count => x_msg_count,

4304: WHEN OTHERS THEN
4305: ROLLBACK TO import_vendor_contact_pub;
4306: x_return_status := fnd_api.g_ret_sts_unexp_error;
4307:
4308: fnd_msg_pub.count_and_get(p_count => x_msg_count,
4309: p_data => x_msg_data);
4310: fnd_file.put_line(fnd_file.log,
4311: ' Inside import_vendor_contacts others EXCEPTION ' ||
4312: ' Message: ' || SQLCODE || ' ' || SQLERRM);

Line 4392: fnd_msg_pub.count_and_get(p_count => l_msg_count,

4388: g_login_id,
4389: 'validate_vendor_prods_services') <> TRUE) THEN
4390:
4391: IF (g_level_procedure >= g_current_runtime_level) THEN
4392: fnd_msg_pub.count_and_get(p_count => l_msg_count,
4393: p_data => l_msg_data);
4394: fnd_log.string(g_level_procedure,
4395: g_module_name || l_api_name,
4396: 'Parameters: ' || ' PS_INTERFACE_ID: ' ||

Line 4509: fnd_msg_pub.count_and_get(p_count => l_msg_count,

4505: g_login_id,
4506: 'validate_vendor_prods_services') <> TRUE) THEN
4507:
4508: IF (g_level_procedure >= g_current_runtime_level) THEN
4509: fnd_msg_pub.count_and_get(p_count => l_msg_count,
4510: p_data => l_msg_data);
4511: fnd_log.string(g_level_procedure,
4512: g_module_name || l_api_name,
4513: 'Parameters: ' || ' PS_INTERFACE_ID: ' ||

Line 4562: fnd_msg_pub.count_and_get(p_count => l_msg_count,

4558: g_login_id,
4559: 'validate_vendor_prods_services') <> TRUE) THEN
4560:
4561: IF (g_level_procedure >= g_current_runtime_level) THEN
4562: fnd_msg_pub.count_and_get(p_count => l_msg_count,
4563: p_data => l_msg_data);
4564: fnd_log.string(g_level_procedure,
4565: g_module_name || l_api_name,
4566: 'Parameters: ' || ' PS_INTERFACE_ID: ' ||

Line 4594: fnd_msg_pub.count_and_get(p_count => l_msg_count,

4590: g_login_id,
4591: 'validate_vendor_prods_services') <> TRUE) THEN
4592:
4593: IF (g_level_procedure >= g_current_runtime_level) THEN
4594: fnd_msg_pub.count_and_get(p_count => l_msg_count,
4595: p_data => l_msg_data);
4596: fnd_log.string(g_level_procedure,
4597: g_module_name || l_api_name,
4598: 'Parameters: ' || ' PS_INTERFACE_ID: ' ||

Line 4619: fnd_msg_pub.count_and_get(p_count => x_msg_count,

4615: WHEN OTHERS THEN
4616: x_prod_valid := 'N';
4617: x_return_status := fnd_api.g_ret_sts_unexp_error;
4618:
4619: fnd_msg_pub.count_and_get(p_count => x_msg_count,
4620: p_data => x_msg_data);
4621: fnd_file.put_line(fnd_file.log,
4622: ' Inside validate_vendor_prods_services EXCEPTION ' ||
4623: ' Message: ' || SQLCODE || ' ' || SQLERRM);

Line 4743: fnd_msg_pub.count_and_get(p_count => x_msg_count,

4739: END IF;
4740: EXCEPTION
4741: WHEN fnd_api.g_exc_error THEN
4742: x_return_status := fnd_api.g_ret_sts_error;
4743: fnd_msg_pub.count_and_get(p_count => x_msg_count,
4744: p_data => x_msg_data);
4745: fnd_file.put_line(fnd_file.log,
4746: ' Inside create_vendor_prods_services EXCEPTION ' ||
4747: ' Message: ' || SQLCODE || ' ' || SQLERRM);

Line 4750: fnd_msg_pub.count_and_get(p_count => x_msg_count,

4746: ' Inside create_vendor_prods_services EXCEPTION ' ||
4747: ' Message: ' || SQLCODE || ' ' || SQLERRM);
4748: WHEN fnd_api.g_exc_unexpected_error THEN
4749: x_return_status := fnd_api.g_ret_sts_unexp_error;
4750: fnd_msg_pub.count_and_get(p_count => x_msg_count,
4751: p_data => x_msg_data);
4752: fnd_file.put_line(fnd_file.log,
4753: ' Inside create_vendor_prods_services unexpected EXCEPTION ' ||
4754: ' Message: ' || SQLCODE || ' ' || SQLERRM);

Line 4758: fnd_msg_pub.count_and_get(p_count => x_msg_count,

4754: ' Message: ' || SQLCODE || ' ' || SQLERRM);
4755: WHEN OTHERS THEN
4756: x_return_status := fnd_api.g_ret_sts_unexp_error;
4757:
4758: fnd_msg_pub.count_and_get(p_count => x_msg_count,
4759: p_data => x_msg_data);
4760: fnd_file.put_line(fnd_file.log,
4761: ' Inside create_vendor_prods_services others EXCEPTION ' ||
4762: ' Message: ' || SQLCODE || ' ' || SQLERRM);

Line 4956: fnd_msg_pub.count_and_get(p_count => l_msg_count,

4952: g_login_id,
4953: 'import_vendor_prods_services') <> TRUE) THEN
4954:
4955: IF (g_level_procedure >= g_current_runtime_level) THEN
4956: fnd_msg_pub.count_and_get(p_count => l_msg_count,
4957: p_data => l_msg_data);
4958: fnd_log.string(g_level_procedure,
4959: g_module_name || l_api_name,
4960: 'Parameters: ' || ' PS_INTERFACE_ID: ' ||

Line 5147: fnd_msg_pub.count_and_get(p_count => l_msg_count,

5143: g_login_id,
5144: 'import_vendor_prods_services') <> TRUE) THEN
5145:
5146: IF (g_level_procedure >= g_current_runtime_level) THEN
5147: fnd_msg_pub.count_and_get(p_count => l_msg_count,
5148: p_data => l_msg_data);
5149: fnd_log.string(g_level_procedure,
5150: g_module_name || l_api_name,
5151: 'Parameters: ' || ' PS_INTERFACE_ID: ' ||

Line 5281: fnd_msg_pub.count_and_get(p_count => l_msg_count,

5277: g_login_id,
5278: 'import_vendor_prods_services') <> TRUE) THEN
5279:
5280: IF (g_level_procedure >= g_current_runtime_level) THEN
5281: fnd_msg_pub.count_and_get(p_count => l_msg_count,
5282: p_data => l_msg_data);
5283: fnd_log.string(g_level_procedure,
5284: g_module_name || l_api_name,
5285: 'Parameters: ' || ' PS_INTERFACE_ID: ' ||

Line 5302: fnd_msg_pub.count_and_get(p_count => x_msg_count,

5298: CLOSE vendor_int_prod_srv_cur;
5299: EXCEPTION
5300: WHEN fnd_api.g_exc_error THEN
5301: x_return_status := fnd_api.g_ret_sts_error;
5302: fnd_msg_pub.count_and_get(p_count => x_msg_count,
5303: p_data => x_msg_data);
5304: fnd_file.put_line(fnd_file.log,
5305: ' Inside import_vendor_prods_services EXCEPTION ' ||
5306: ' Message: ' || SQLCODE || ' ' || SQLERRM);

Line 5309: fnd_msg_pub.count_and_get(p_count => x_msg_count,

5305: ' Inside import_vendor_prods_services EXCEPTION ' ||
5306: ' Message: ' || SQLCODE || ' ' || SQLERRM);
5307: WHEN fnd_api.g_exc_unexpected_error THEN
5308: x_return_status := fnd_api.g_ret_sts_unexp_error;
5309: fnd_msg_pub.count_and_get(p_count => x_msg_count,
5310: p_data => x_msg_data);
5311: fnd_file.put_line(fnd_file.log,
5312: ' Inside import_vendor_prods_services unexpected EXCEPTION ' ||
5313: ' Message: ' || SQLCODE || ' ' || SQLERRM);

Line 5317: fnd_msg_pub.count_and_get(p_count => x_msg_count,

5313: ' Message: ' || SQLCODE || ' ' || SQLERRM);
5314: WHEN OTHERS THEN
5315: x_return_status := fnd_api.g_ret_sts_unexp_error;
5316:
5317: fnd_msg_pub.count_and_get(p_count => x_msg_count,
5318: p_data => x_msg_data);
5319: fnd_file.put_line(fnd_file.log,
5320: ' Inside import_vendor_prods_services others EXCEPTION ' ||
5321: ' Message: ' || SQLCODE || ' ' || SQLERRM);

Line 5381: fnd_msg_pub.count_and_get(p_count => l_msg_count,

5377: g_login_id,
5378: 'Validate_Vendor_Buss_Class') <> TRUE) THEN
5379:
5380: IF (g_level_procedure >= g_current_runtime_level) THEN
5381: fnd_msg_pub.count_and_get(p_count => l_msg_count,
5382: p_data => l_msg_data);
5383: fnd_log.string(g_level_procedure,
5384: g_module_name || l_api_name,
5385: 'Parameters: ' ||

Line 5426: fnd_msg_pub.count_and_get(p_count => l_msg_count,

5422: g_login_id,
5423: 'Validate_Vendor_Buss_Class') <> TRUE) THEN
5424:
5425: IF (g_level_procedure >= g_current_runtime_level) THEN
5426: fnd_msg_pub.count_and_get(p_count => l_msg_count,
5427: p_data => l_msg_data);
5428: fnd_log.string(g_level_procedure,
5429: g_module_name || l_api_name,
5430: 'Parameters: ' ||

Line 5448: fnd_msg_pub.count_and_get(p_count => x_msg_count,

5444: WHEN OTHERS THEN
5445: x_buss_valid := 'N';
5446: x_return_status := fnd_api.g_ret_sts_unexp_error;
5447:
5448: fnd_msg_pub.count_and_get(p_count => x_msg_count,
5449: p_data => x_msg_data);
5450: fnd_file.put_line(fnd_file.log,
5451: ' Inside validate_vendor_buss_class EXCEPTION ' ||
5452: ' Message: ' || SQLCODE || ' ' || SQLERRM);

Line 5521: fnd_msg_pub.count_and_get(p_count => x_msg_count,

5517: END IF;
5518: EXCEPTION
5519: WHEN fnd_api.g_exc_error THEN
5520: x_return_status := fnd_api.g_ret_sts_error;
5521: fnd_msg_pub.count_and_get(p_count => x_msg_count,
5522: p_data => x_msg_data);
5523: fnd_file.put_line(fnd_file.log,
5524: ' Inside create_vendor_buss_class EXCEPTION ' ||
5525: ' Message: ' || SQLCODE || ' ' || SQLERRM);

Line 5528: fnd_msg_pub.count_and_get(p_count => x_msg_count,

5524: ' Inside create_vendor_buss_class EXCEPTION ' ||
5525: ' Message: ' || SQLCODE || ' ' || SQLERRM);
5526: WHEN fnd_api.g_exc_unexpected_error THEN
5527: x_return_status := fnd_api.g_ret_sts_unexp_error;
5528: fnd_msg_pub.count_and_get(p_count => x_msg_count,
5529: p_data => x_msg_data);
5530: fnd_file.put_line(fnd_file.log,
5531: ' Inside create_vendor_buss_class unexpected EXCEPTION ' ||
5532: ' Message: ' || SQLCODE || ' ' || SQLERRM);

Line 5536: fnd_msg_pub.count_and_get(p_count => x_msg_count,

5532: ' Message: ' || SQLCODE || ' ' || SQLERRM);
5533: WHEN OTHERS THEN
5534: x_return_status := fnd_api.g_ret_sts_unexp_error;
5535:
5536: fnd_msg_pub.count_and_get(p_count => x_msg_count,
5537: p_data => x_msg_data);
5538: fnd_file.put_line(fnd_file.log,
5539: ' Inside create_vendor_buss_class others EXCEPTION ' ||
5540: ' Message: ' || SQLCODE || ' ' || SQLERRM);

Line 5714: fnd_msg_pub.count_and_get(p_count => l_msg_count,

5710: g_login_id,
5711: 'import_vendor_buss_class') <> TRUE) THEN
5712:
5713: IF (g_level_procedure >= g_current_runtime_level) THEN
5714: fnd_msg_pub.count_and_get(p_count => l_msg_count,
5715: p_data => l_msg_data);
5716: fnd_log.string(g_level_procedure,
5717: g_module_name || l_api_name,
5718: 'Parameters: ' ||

Line 5833: fnd_msg_pub.count_and_get(p_count => l_msg_count,

5829: g_login_id,
5830: 'import_vendor_buss_class') <> TRUE) THEN
5831:
5832: IF (g_level_procedure >= g_current_runtime_level) THEN
5833: fnd_msg_pub.count_and_get(p_count => l_msg_count,
5834: p_data => l_msg_data);
5835: fnd_log.string(g_level_procedure,
5836: g_module_name || l_api_name,
5837: 'Parameters: ' ||

Line 5906: fnd_msg_pub.count_and_get(p_count => l_msg_count,

5902: g_login_id,
5903: 'import_vendor_buss_class') <> TRUE) THEN
5904:
5905: IF (g_level_procedure >= g_current_runtime_level) THEN
5906: fnd_msg_pub.count_and_get(p_count => l_msg_count,
5907: p_data => l_msg_data);
5908: fnd_log.string(g_level_procedure,
5909: g_module_name || l_api_name,
5910: 'Parameters: ' ||

Line 5932: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

5928: COMMIT;
5929:
5930: -- Standard call to get message count and if count is 1,
5931: -- get message info.
5932: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
5933:
5934: EXCEPTION
5935: WHEN fnd_api.g_exc_error THEN
5936: x_return_status := fnd_api.g_ret_sts_error;

Line 5937: fnd_msg_pub.count_and_get(p_count => x_msg_count,

5933:
5934: EXCEPTION
5935: WHEN fnd_api.g_exc_error THEN
5936: x_return_status := fnd_api.g_ret_sts_error;
5937: fnd_msg_pub.count_and_get(p_count => x_msg_count,
5938: p_data => x_msg_data);
5939: fnd_file.put_line(fnd_file.log,
5940: ' Inside import_vendor_buss_class EXCEPTION ' ||
5941: ' Message: ' || SQLCODE || ' ' || SQLERRM);

Line 5944: fnd_msg_pub.count_and_get(p_count => x_msg_count,

5940: ' Inside import_vendor_buss_class EXCEPTION ' ||
5941: ' Message: ' || SQLCODE || ' ' || SQLERRM);
5942: WHEN fnd_api.g_exc_unexpected_error THEN
5943: x_return_status := fnd_api.g_ret_sts_unexp_error;
5944: fnd_msg_pub.count_and_get(p_count => x_msg_count,
5945: p_data => x_msg_data);
5946: fnd_file.put_line(fnd_file.log,
5947: ' Inside import_vendor_buss_class unexpected EXCEPTION ' ||
5948: ' Message: ' || SQLCODE || ' ' || SQLERRM);

Line 5952: fnd_msg_pub.count_and_get(p_count => x_msg_count,

5948: ' Message: ' || SQLCODE || ' ' || SQLERRM);
5949: WHEN OTHERS THEN
5950: x_return_status := fnd_api.g_ret_sts_unexp_error;
5951:
5952: fnd_msg_pub.count_and_get(p_count => x_msg_count,
5953: p_data => x_msg_data);
5954: fnd_file.put_line(fnd_file.log,
5955: ' Inside import_vendor_buss_class others EXCEPTION ' ||
5956: ' Message: ' || SQLCODE || ' ' || SQLERRM);

Line 6027: fnd_msg_pub.count_and_get(p_count => l_msg_count,

6023: g_login_id,
6024: ' Validate_Tax_Profile ') <> TRUE) THEN
6025:
6026: IF (g_level_procedure >= g_current_runtime_level) THEN
6027: fnd_msg_pub.count_and_get(p_count => l_msg_count,
6028: p_data => l_msg_data);
6029: fnd_log.string(g_level_procedure,
6030: g_module_name || l_api_name,
6031: ' Acct Validation Msg: ' || l_msg_data);

Line 6071: fnd_msg_pub.count_and_get(p_count => l_msg_count,

6067: g_login_id,
6068: ' Validate_Tax_Profile ') <> TRUE) THEN
6069:
6070: IF (g_level_procedure >= g_current_runtime_level) THEN
6071: fnd_msg_pub.count_and_get(p_count => l_msg_count,
6072: p_data => l_msg_data);
6073: fnd_log.string(g_level_procedure,
6074: g_module_name || l_api_name,
6075: 'Msg: ' || l_msg_data);

Line 6111: fnd_msg_pub.count_and_get(p_count => l_msg_count,

6107: g_login_id,
6108: ' Validate_Tax_Profile ') <> TRUE) THEN
6109:
6110: IF (g_level_procedure >= g_current_runtime_level) THEN
6111: fnd_msg_pub.count_and_get(p_count => l_msg_count,
6112: p_data => l_msg_data);
6113: fnd_log.string(g_level_procedure,
6114: g_module_name || l_api_name,
6115: 'Msg: ' || l_msg_data);

Line 6155: fnd_msg_pub.count_and_get(p_count => l_msg_count,

6151: g_login_id,
6152: ' Validate_Tax_Profile ') <> TRUE) THEN
6153:
6154: IF (g_level_procedure >= g_current_runtime_level) THEN
6155: fnd_msg_pub.count_and_get(p_count => l_msg_count,
6156: p_data => l_msg_data);
6157: fnd_log.string(g_level_procedure,
6158: g_module_name || l_api_name,
6159: 'Msg: ' || l_msg_data);

Line 6174: fnd_msg_pub.count_and_get(p_count => x_msg_count,

6170: EXCEPTION
6171: WHEN OTHERS THEN
6172: x_tax_prof_valid := 'N';
6173: x_return_status := fnd_api.g_ret_sts_error;
6174: fnd_msg_pub.count_and_get(p_count => x_msg_count,
6175: p_data => x_msg_data);
6176: fnd_file.put_line(fnd_file.log,
6177: ' Inside validate_tax_profile EXCEPTION ' ||
6178: ' Message: ' || SQLCODE || ' ' || SQLERRM);

Line 6346: fnd_msg_pub.count_and_get(p_count => x_msg_count,

6342: EXCEPTION
6343: WHEN OTHERS THEN
6344: x_return_status := fnd_api.g_ret_sts_unexp_error;
6345:
6346: fnd_msg_pub.count_and_get(p_count => x_msg_count,
6347: p_data => x_msg_data);
6348: fnd_file.put_line(fnd_file.log,
6349: ' Inside create_tax_profile EXCEPTION ' ||
6350: ' Message: ' || SQLCODE || ' ' || SQLERRM);

Line 6414: fnd_msg_pub.count_and_get(p_count => l_msg_count,

6410: g_login_id,
6411: ' Validate_Tax_Registration ') <> TRUE) THEN
6412:
6413: IF (g_level_procedure >= g_current_runtime_level) THEN
6414: fnd_msg_pub.count_and_get(p_count => l_msg_count,
6415: p_data => l_msg_data);
6416: fnd_log.string(g_level_procedure,
6417: g_module_name || l_api_name,
6418: 'Msg: ' || l_msg_data);

Line 6459: fnd_msg_pub.count_and_get(p_count => l_msg_count,

6455: g_login_id,
6456: ' Validate_Tax_Registration ') <> TRUE) THEN
6457:
6458: IF (g_level_procedure >= g_current_runtime_level) THEN
6459: fnd_msg_pub.count_and_get(p_count => l_msg_count,
6460: p_data => l_msg_data);
6461: fnd_log.string(g_level_procedure,
6462: g_module_name || l_api_name,
6463: 'Msg: ' || l_msg_data);

Line 6505: fnd_msg_pub.count_and_get(p_count => l_msg_count,

6501: g_login_id,
6502: ' Validate_Tax_Registration ') <> TRUE) THEN
6503:
6504: IF (g_level_procedure >= g_current_runtime_level) THEN
6505: fnd_msg_pub.count_and_get(p_count => l_msg_count,
6506: p_data => l_msg_data);
6507: fnd_log.string(g_level_procedure,
6508: g_module_name || l_api_name,
6509: 'Msg: ' || l_msg_data);

Line 6550: fnd_msg_pub.count_and_get(p_count => l_msg_count,

6546: g_login_id,
6547: ' Validate_Tax_Registration ') <> TRUE) THEN
6548:
6549: IF (g_level_procedure >= g_current_runtime_level) THEN
6550: fnd_msg_pub.count_and_get(p_count => l_msg_count,
6551: p_data => l_msg_data);
6552: fnd_log.string(g_level_procedure,
6553: g_module_name || l_api_name,
6554: 'Msg: ' || l_msg_data);

Line 6595: fnd_msg_pub.count_and_get(p_count => l_msg_count,

6591: g_login_id,
6592: ' Validate_Tax_Registration ') <> TRUE) THEN
6593:
6594: IF (g_level_procedure >= g_current_runtime_level) THEN
6595: fnd_msg_pub.count_and_get(p_count => l_msg_count,
6596: p_data => l_msg_data);
6597: fnd_log.string(g_level_procedure,
6598: g_module_name || l_api_name,
6599: 'Msg: ' || l_msg_data);

Line 6640: fnd_msg_pub.count_and_get(p_count => l_msg_count,

6636: g_login_id,
6637: ' Validate_Tax_Registration ') <> TRUE) THEN
6638:
6639: IF (g_level_procedure >= g_current_runtime_level) THEN
6640: fnd_msg_pub.count_and_get(p_count => l_msg_count,
6641: p_data => l_msg_data);
6642: fnd_log.string(g_level_procedure,
6643: g_module_name || l_api_name,
6644: 'Msg: ' || l_msg_data);

Line 6685: fnd_msg_pub.count_and_get(p_count => l_msg_count,

6681: g_login_id,
6682: ' Validate_Tax_Registration ') <> TRUE) THEN
6683:
6684: IF (g_level_procedure >= g_current_runtime_level) THEN
6685: fnd_msg_pub.count_and_get(p_count => l_msg_count,
6686: p_data => l_msg_data);
6687: fnd_log.string(g_level_procedure,
6688: g_module_name || l_api_name,
6689: 'Msg: ' || l_msg_data);

Line 6704: fnd_msg_pub.count_and_get(p_count => x_msg_count,

6700: EXCEPTION
6701: WHEN OTHERS THEN
6702: x_tax_reg_valid := 'N';
6703: x_return_status := fnd_api.g_ret_sts_error;
6704: fnd_msg_pub.count_and_get(p_count => x_msg_count,
6705: p_data => x_msg_data);
6706: fnd_file.put_line(fnd_file.log,
6707: ' Inside validate_tax_registration EXCEPTION ' ||
6708: ' Message: ' || SQLCODE || ' ' || SQLERRM);

Line 6817: fnd_msg_pub.count_and_get(p_count => l_msg_count,

6813: g_login_id,
6814: ' Create_Tax_Registration ') <> TRUE) THEN
6815:
6816: IF (g_level_procedure >= g_current_runtime_level) THEN
6817: fnd_msg_pub.count_and_get(p_count => l_msg_count,
6818: p_data => l_msg_data);
6819: fnd_log.string(g_level_procedure,
6820: g_module_name || 'Create_Tax_Registration',
6821: 'Msg: ' || l_msg_data);

Line 6832: fnd_msg_pub.count_and_get(p_count => x_msg_count,

6828: END IF;
6829: EXCEPTION
6830: WHEN OTHERS THEN
6831: x_return_status := fnd_api.g_ret_sts_error;
6832: fnd_msg_pub.count_and_get(p_count => x_msg_count,
6833: p_data => x_msg_data);
6834: fnd_file.put_line(fnd_file.log,
6835: ' Inside create_tax_registration EXCEPTION ' ||
6836: ' Message: ' || SQLCODE || ' ' || SQLERRM);

Line 6945: fnd_msg_pub.count_and_get(p_count => l_msg_count,

6941: g_login_id,
6942: ' UPDATE_TAX_REGISTRATION ') <> TRUE) THEN
6943:
6944: IF (g_level_procedure >= g_current_runtime_level) THEN
6945: fnd_msg_pub.count_and_get(p_count => l_msg_count,
6946: p_data => l_msg_data);
6947: fnd_log.string(g_level_procedure,
6948: g_module_name || 'UPDATE_TAX_REGISTRATION',
6949: 'Msg: ' || l_msg_data);

Line 6961: fnd_msg_pub.count_and_get(p_count => x_msg_count,

6957:
6958: EXCEPTION
6959: WHEN OTHERS THEN
6960: x_return_status := fnd_api.g_ret_sts_error;
6961: fnd_msg_pub.count_and_get(p_count => x_msg_count,
6962: p_data => x_msg_data);
6963: fnd_file.put_line(fnd_file.log,
6964: ' Inside update_tax_registration EXCEPTION ' ||
6965: ' Message: ' || SQLCODE || ' ' || SQLERRM);

Line 7026: fnd_msg_pub.count_and_get(p_count => l_msg_count,

7022: g_login_id,
7023: ' Validate_fiscal_classification ') <> TRUE) THEN
7024:
7025: IF (g_level_procedure >= g_current_runtime_level) THEN
7026: fnd_msg_pub.count_and_get(p_count => l_msg_count,
7027: p_data => l_msg_data);
7028: fnd_log.string(g_level_procedure,
7029: g_module_name || l_api_name,
7030: 'Parameters: ' ||

Line 7070: fnd_msg_pub.count_and_get(p_count => l_msg_count,

7066: g_login_id,
7067: ' Validate_fiscal_classification ') <> TRUE) THEN
7068:
7069: IF (g_level_procedure >= g_current_runtime_level) THEN
7070: fnd_msg_pub.count_and_get(p_count => l_msg_count,
7071: p_data => l_msg_data);
7072: fnd_log.string(g_level_procedure,
7073: g_module_name || l_api_name,
7074: 'Parameters: ' ||

Line 7088: fnd_msg_pub.count_and_get(p_count => x_msg_count,

7084: END;
7085: EXCEPTION
7086: WHEN OTHERS THEN
7087: x_return_status := fnd_api.g_ret_sts_error;
7088: fnd_msg_pub.count_and_get(p_count => x_msg_count,
7089: p_data => x_msg_data);
7090: fnd_file.put_line(fnd_file.log,
7091: ' Inside validate_fiscal_classification EXCEPTION ' ||
7092: ' Message: ' || SQLCODE || ' ' || SQLERRM);

Line 7179: fnd_msg_pub.count_and_get(p_count => l_msg_count,

7175: g_login_id,
7176: ' Create_Tax_Registration ') <> TRUE) THEN
7177:
7178: IF (g_level_procedure >= g_current_runtime_level) THEN
7179: fnd_msg_pub.count_and_get(p_count => l_msg_count,
7180: p_data => l_msg_data);
7181: fnd_log.string(g_level_procedure,
7182: g_module_name || 'Create_Tax_Registration',
7183: 'Msg: ' || l_msg_data);

Line 7194: fnd_msg_pub.count_and_get(p_count => x_msg_count,

7190: END IF;
7191: EXCEPTION
7192: WHEN OTHERS THEN
7193: x_return_status := fnd_api.g_ret_sts_error;
7194: fnd_msg_pub.count_and_get(p_count => x_msg_count,
7195: p_data => x_msg_data);
7196: fnd_file.put_line(fnd_file.log,
7197: ' Inside create_fiscal_classification EXCEPTION ' ||
7198: ' Message: ' || SQLCODE || ' ' || SQLERRM);

Line 7299: fnd_msg_pub.count_and_get(p_count => l_msg_count,

7295: g_login_id,
7296: ' Create_Tax_Registration ') <> TRUE) THEN
7297:
7298: IF (g_level_procedure >= g_current_runtime_level) THEN
7299: fnd_msg_pub.count_and_get(p_count => l_msg_count,
7300: p_data => l_msg_data);
7301: fnd_log.string(g_level_procedure,
7302: g_module_name || 'Create_Tax_Registration',
7303: 'Msg: ' || l_msg_data);

Line 7315: fnd_msg_pub.count_and_get(p_count => x_msg_count,

7311:
7312: EXCEPTION
7313: WHEN OTHERS THEN
7314: x_return_status := fnd_api.g_ret_sts_error;
7315: fnd_msg_pub.count_and_get(p_count => x_msg_count,
7316: p_data => x_msg_data);
7317: fnd_file.put_line(fnd_file.log,
7318: ' Inside update_fiscal_classification EXCEPTION ' ||
7319: ' Message: ' || SQLCODE || ' ' || SQLERRM);

Line 7665: fnd_msg_pub.count_and_get(p_count => l_msg_count,

7661: g_login_id,
7662: 'import_vendor_tax_dtls') <> TRUE) THEN
7663:
7664: IF (g_level_procedure >= g_current_runtime_level) THEN
7665: fnd_msg_pub.count_and_get(p_count => l_msg_count,
7666: p_data => l_msg_data);
7667: fnd_log.string(g_level_procedure,
7668: g_module_name || l_api_name,
7669: 'Parameters: ' || ' Vendor_Interface_Id: ' || l_tax_profile_rec_tab(cntr)

Line 7838: fnd_msg_pub.count_and_get(p_count => l_msg_count,

7834: g_login_id,
7835: 'import_vendor_tax_dtls') <> TRUE) THEN
7836:
7837: IF (g_level_procedure >= g_current_runtime_level) THEN
7838: fnd_msg_pub.count_and_get(p_count => l_msg_count,
7839: p_data => l_msg_data);
7840: fnd_log.string(g_level_procedure,
7841: g_module_name || l_api_name,
7842: 'Parameters: ' || ' Vendor_Interface_Id: ' || l_tax_reg_rec_tab(cntr)

Line 7898: fnd_msg_pub.count_and_get(p_count => l_msg_count,

7894: g_login_id,
7895: 'import_vendor_tax_dtls') <> TRUE) THEN
7896:
7897: IF (g_level_procedure >= g_current_runtime_level) THEN
7898: fnd_msg_pub.count_and_get(p_count => l_msg_count,
7899: p_data => l_msg_data);
7900: fnd_log.string(g_level_procedure,
7901: g_module_name || l_api_name,
7902: 'Parameters: ' || ' Vendor_Interface_Id: ' || l_fiscal_class_rec_tab(cntr)

Line 8011: fnd_msg_pub.count_and_get(p_count => l_msg_count,

8007: g_login_id,
8008: 'import_vendor_tax_dtls') <> TRUE) THEN
8009:
8010: IF (g_level_procedure >= g_current_runtime_level) THEN
8011: fnd_msg_pub.count_and_get(p_count => l_msg_count,
8012: p_data => l_msg_data);
8013: fnd_log.string(g_level_procedure,
8014: g_module_name || l_api_name,
8015: 'Parameters: ' || ' Vendor_Interface_Id: ' || l_fiscal_class_rec_tab(cntr)

Line 8030: fnd_msg_pub.count_and_get(p_count => x_msg_count,

8026: EXCEPTION
8027: WHEN OTHERS THEN
8028: x_return_status := fnd_api.g_ret_sts_unexp_error;
8029:
8030: fnd_msg_pub.count_and_get(p_count => x_msg_count,
8031: p_data => x_msg_data);
8032: fnd_file.put_line(fnd_file.log,
8033: ' Inside import_vendor_tax_dtls EXCEPTION ' ||
8034: ' Message: ' || SQLCODE || ' ' || SQLERRM);

Line 8329: fnd_msg_pub.count_and_get(p_count => l_msg_count,

8325: g_login_id,
8326: 'IMPORT_VENDOR_BANK_DTLS') <> TRUE) THEN
8327:
8328: IF (g_level_procedure >= g_current_runtime_level) THEN
8329: fnd_msg_pub.count_and_get(p_count => l_msg_count,
8330: p_data => l_msg_data);
8331: fnd_log.string(g_level_procedure,
8332: g_module_name || l_api_name,
8333: 'Parameters: ' || ' Interface_Id: ' ||

Line 8426: fnd_msg_pub.count_and_get(p_count => l_msg_count,

8422: g_login_id,
8423: 'IMPORT_VENDOR_BANK_DTLS') <> TRUE) THEN
8424:
8425: IF (g_level_procedure >= g_current_runtime_level) THEN
8426: fnd_msg_pub.count_and_get(p_count => l_msg_count,
8427: p_data => l_msg_data);
8428: fnd_log.string(g_level_procedure,
8429: g_module_name || l_api_name,
8430: 'Parameters: ' || ' Interface_Id: ' ||

Line 8579: fnd_msg_pub.count_and_get(p_count => l_msg_count,

8575: g_login_id,
8576: 'IMPORT_VENDOR_BANK_DTLS') <> TRUE) THEN
8577:
8578: IF (g_level_procedure >= g_current_runtime_level) THEN
8579: fnd_msg_pub.count_and_get(p_count => l_msg_count,
8580: p_data => l_msg_data);
8581: fnd_log.string(g_level_procedure,
8582: g_module_name || l_api_name,
8583: 'Parameters: ' || ' Interface_Id: ' ||

Line 8636: fnd_msg_pub.count_and_get(p_count => l_msg_count,

8632: g_login_id,
8633: 'IMPORT_VENDOR_BANK_DTLS') <> TRUE) THEN
8634:
8635: IF (g_level_procedure >= g_current_runtime_level) THEN
8636: fnd_msg_pub.count_and_get(p_count => l_msg_count,
8637: p_data => l_msg_data);
8638: fnd_log.string(g_level_procedure,
8639: g_module_name || l_api_name,
8640: 'Parameters: ' || ' Interface_Id: ' ||

Line 8768: fnd_msg_pub.count_and_get(p_count => l_msg_count,

8764: g_login_id,
8765: 'IMPORT_VENDOR_BANK_DTLS') <> TRUE) THEN
8766:
8767: IF (g_level_procedure >= g_current_runtime_level) THEN
8768: fnd_msg_pub.count_and_get(p_count => l_msg_count,
8769: p_data => l_msg_data);
8770: fnd_log.string(g_level_procedure,
8771: g_module_name || l_api_name,
8772: 'Parameters: ' || ' Interface_Id: ' ||

Line 8923: fnd_msg_pub.count_and_get(p_count => l_msg_count,

8919: g_login_id,
8920: 'IMPORT_VENDOR_BANK_DTLS') <> TRUE) THEN
8921:
8922: IF (g_level_procedure >= g_current_runtime_level) THEN
8923: fnd_msg_pub.count_and_get(p_count => l_msg_count,
8924: p_data => l_msg_data);
8925: fnd_log.string(g_level_procedure,
8926: g_module_name || l_api_name,
8927: 'Parameters: ' || ' Interface_Id: ' ||

Line 9090: fnd_msg_pub.count_and_get(p_count => l_msg_count,

9086: g_login_id,
9087: 'IMPORT_VENDOR_BANK_DTLS') <> TRUE) THEN
9088:
9089: IF (g_level_procedure >= g_current_runtime_level) THEN
9090: fnd_msg_pub.count_and_get(p_count => l_msg_count,
9091: p_data => l_msg_data);
9092: fnd_log.string(g_level_procedure,
9093: g_module_name || l_api_name,
9094: 'Parameters: ' || ' Interface_Id: ' ||

Line 9323: fnd_msg_pub.count_and_get(p_count => l_msg_count,

9319: g_login_id,
9320: 'IMPORT_VENDOR_BANK_DTLS') <> TRUE) THEN
9321:
9322: IF (g_level_procedure >= g_current_runtime_level) THEN
9323: fnd_msg_pub.count_and_get(p_count => l_msg_count,
9324: p_data => l_msg_data);
9325: fnd_log.string(g_level_procedure,
9326: g_module_name || l_api_name,
9327: 'Parameters: ' || ' Interface_Id: ' ||

Line 9491: fnd_msg_pub.count_and_get(p_count => l_msg_count,

9487: g_login_id,
9488: 'IMPORT_VENDOR_BANK_DTLS') <> TRUE) THEN
9489:
9490: IF (g_level_procedure >= g_current_runtime_level) THEN
9491: fnd_msg_pub.count_and_get(p_count => l_msg_count,
9492: p_data => l_msg_data);
9493: fnd_log.string(g_level_procedure,
9494: g_module_name || l_api_name,
9495: 'Parameters: ' || ' Interface_Id: ' ||

Line 9635: fnd_msg_pub.count_and_get(p_count => l_msg_count,

9631: g_login_id,
9632: 'IMPORT_VENDOR_BANK_DTLS') <> TRUE) THEN
9633:
9634: IF (g_level_procedure >= g_current_runtime_level) THEN
9635: fnd_msg_pub.count_and_get(p_count => l_msg_count,
9636: p_data => l_msg_data);
9637: fnd_log.string(g_level_procedure,
9638: g_module_name || l_api_name,
9639: 'Parameters: ' || ' Interface_Id: ' ||

Line 9760: fnd_msg_pub.count_and_get(p_count => l_msg_count,

9756: g_login_id,
9757: 'import_vendor_bank_dtls') <> TRUE) THEN
9758:
9759: IF (g_level_procedure >= g_current_runtime_level) THEN
9760: fnd_msg_pub.count_and_get(p_count => l_msg_count,
9761: p_data => l_msg_data);
9762: fnd_log.string(g_level_procedure,
9763: g_module_name || l_api_name,
9764: 'Parameters: ' || ' Interface_Id: ' ||

Line 9814: fnd_msg_pub.count_and_get(p_count => l_msg_count,

9810: g_login_id,
9811: 'import_vendor_bank_dtls') <> TRUE) THEN
9812:
9813: IF (g_level_procedure >= g_current_runtime_level) THEN
9814: fnd_msg_pub.count_and_get(p_count => l_msg_count,
9815: p_data => l_msg_data);
9816: fnd_log.string(g_level_procedure,
9817: g_module_name || l_api_name,
9818: 'Parameters: ' || ' Interface_Id: ' ||

Line 9885: fnd_msg_pub.count_and_get(p_count => l_msg_count,

9881: g_login_id,
9882: 'import_vendor_bank_dtls') <> TRUE) THEN
9883:
9884: IF (g_level_procedure >= g_current_runtime_level) THEN
9885: fnd_msg_pub.count_and_get(p_count => l_msg_count,
9886: p_data => l_msg_data);
9887: fnd_log.string(g_level_procedure,
9888: g_module_name || l_api_name,
9889: 'Parameters: ' || ' Interface_Id: ' ||

Line 9938: fnd_msg_pub.count_and_get(p_count => l_msg_count,

9934: g_login_id,
9935: 'import_vendor_bank_dtls') <> TRUE) THEN
9936:
9937: IF (g_level_procedure >= g_current_runtime_level) THEN
9938: fnd_msg_pub.count_and_get(p_count => l_msg_count,
9939: p_data => l_msg_data);
9940: fnd_log.string(g_level_procedure,
9941: g_module_name || l_api_name,
9942: 'Parameters: ' || ' Interface_Id: ' ||

Line 9982: fnd_msg_pub.count_and_get(p_count => x_msg_count,

9978: EXCEPTION
9979: WHEN OTHERS THEN
9980: x_return_status := fnd_api.g_ret_sts_unexp_error;
9981:
9982: fnd_msg_pub.count_and_get(p_count => x_msg_count,
9983: p_data => x_msg_data);
9984: fnd_file.put_line(fnd_file.log,
9985: ' Inside import_vendor_bank_dtls EXCEPTION ' ||
9986: ' Message: ' || SQLCODE || ' ' || SQLERRM);

Line 10025: fnd_msg_pub.initialize;

10021: ---UDA Import
10022: l_uda_imported_count NUMBER := 0;
10023:
10024: BEGIN
10025: fnd_msg_pub.initialize;
10026:
10027: fnd_file.put_line(fnd_file.log,
10028: ' Message: Inside PROCEDURE IMPORT_BATCH' ||
10029: ' Parameters: ' || ' p_batch_id: ' || p_batch_id ||