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.DPP_TRANSACTION_PVT dependencies on FND_MSG_PUB

Line 24: dpp_debug_high_on constant boolean := fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_debug_high);

20: --08-Oct-08 rvkondur Added code for DPP Price Increase Enhancement
21:
22:
23: -- NOTE :
24: dpp_debug_high_on constant boolean := fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_debug_high);
25: dpp_debug_low_on constant boolean := fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_debug_low);
26: dpp_debug_medium_on constant boolean := fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_debug_medium);
27:
28: g_pkg_name constant VARCHAR2(30) := 'DPP_TRANSACTION_PVT';

Line 25: dpp_debug_low_on constant boolean := fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_debug_low);

21:
22:
23: -- NOTE :
24: dpp_debug_high_on constant boolean := fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_debug_high);
25: dpp_debug_low_on constant boolean := fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_debug_low);
26: dpp_debug_medium_on constant boolean := fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_debug_medium);
27:
28: g_pkg_name constant VARCHAR2(30) := 'DPP_TRANSACTION_PVT';
29: g_debug boolean := fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_debug_high);

Line 26: dpp_debug_medium_on constant boolean := fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_debug_medium);

22:
23: -- NOTE :
24: dpp_debug_high_on constant boolean := fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_debug_high);
25: dpp_debug_low_on constant boolean := fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_debug_low);
26: dpp_debug_medium_on constant boolean := fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_debug_medium);
27:
28: g_pkg_name constant VARCHAR2(30) := 'DPP_TRANSACTION_PVT';
29: g_debug boolean := fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_debug_high);
30: g_file_name constant VARCHAR2(14) := 'dppvtxnb.pls';

Line 29: g_debug boolean := fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_debug_high);

25: dpp_debug_low_on constant boolean := fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_debug_low);
26: dpp_debug_medium_on constant boolean := fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_debug_medium);
27:
28: g_pkg_name constant VARCHAR2(30) := 'DPP_TRANSACTION_PVT';
29: g_debug boolean := fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_debug_high);
30: g_file_name constant VARCHAR2(14) := 'dppvtxnb.pls';
31:
32: PROCEDURE Update_InterfaceErrSts(
33: p_txn_header_rec_type IN OUT nocopy txn_header_rec,

Line 68: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

64: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
65: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
66: WHEN OTHERS THEN
67: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
68: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
69: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
70: fnd_message.set_token('ROUTINE', 'DPP_TRANSACTION_PVT');
71: fnd_message.set_token('ERRNO', SQLCODE);
72: fnd_message.set_token('REASON', sqlerrm);

Line 97: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

93: x_return_status := fnd_api.g_ret_sts_success;
94: --BUG 6806974
95: IF p_txn_header_rec_type.operating_unit_name IS NULL
96: AND p_txn_header_rec_type.org_id IS NULL THEN
97: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
98: fnd_message.set_name( 'DPP', 'DPP_TXN_OPERATING_UNIT_NULL');
99: x_msg_data := fnd_message.get();
100: END IF;
101: x_return_status := fnd_api.g_ret_sts_error;

Line 128: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

124:
125: EXCEPTION
126: WHEN NO_DATA_FOUND THEN
127: x_return_status := fnd_api.g_ret_sts_error;
128: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
129: fnd_message.set_name( 'DPP', 'DPP_TXN_OPERATING_UNIT_ERR');
130: fnd_message.set_token('OPERATING_UNIT', p_txn_header_rec_type.operating_unit_name);
131: fnd_message.set_token('ORG_ID', p_txn_header_rec_type.org_id);
132: x_msg_data := fnd_message.get();

Line 139: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

135: WHEN Fnd_Api.G_EXC_ERROR THEN
136: x_return_status := Fnd_Api.g_ret_sts_error ;
137: WHEN OTHERS THEN
138: x_return_status := fnd_api.g_ret_sts_unexp_error;
139: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
140: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
141: fnd_message.set_token('ROUTINE', l_full_name);
142: fnd_message.set_token('ERRNO', SQLCODE);
143: fnd_message.set_token('REASON', sqlerrm);

Line 184: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

180: END IF;
181: -- Initialize API return status to sucess
182: x_return_status := fnd_api.g_ret_sts_success;
183: IF p_txn_header_rec_type.ref_document_number IS NULL THEN
184: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
185: fnd_message.set_name('DPP', 'DPP_DOC_REF_NUM_NULL');
186: END IF;
187: x_msg_data := fnd_message.get();
188: p_txn_header_rec_type.error_code := 'DPP_DOC_REF_NUM_NULL';

Line 198: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

194: );
195:
196: IF l_valid_doc = 'N' OR length(p_txn_header_rec_type.ref_document_number) > 40 THEN
197: x_return_status := fnd_api.g_ret_sts_error;
198: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
199: fnd_message.set_name('DPP', 'DPP_DOC_REF_NUM_ERR');
200: fnd_message.set_token('DOC_REF_NO', p_txn_header_rec_type.ref_document_number);
201: END IF;
202: x_msg_data := fnd_message.get();

Line 213: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

209: WHEN Fnd_Api.G_EXC_ERROR THEN
210: x_return_status := Fnd_Api.g_ret_sts_error ;
211: WHEN OTHERS THEN
212: x_return_status := fnd_api.g_ret_sts_unexp_error;
213: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
214: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
215: fnd_message.set_token('ROUTINE', l_full_name);
216: fnd_message.set_token('ERRNO', SQLCODE);
217: fnd_message.set_token('REASON', sqlerrm);

Line 241: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

237: x_return_status := fnd_api.g_ret_sts_success;
238: --BUG 6806974
239: IF (p_txn_header_rec_type.vendor_name IS NULL
240: AND p_txn_header_rec_type.vendor_id IS NULL) THEN
241: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
242: fnd_message.set_name('DPP', 'DPP_TXN_SUPP_INFO_NULL');
243: x_msg_data :=fnd_message.get();
244: END IF;
245: p_txn_header_rec_type.error_code := 'DPP_TXN_SUPP_INFO_NULL';

Line 264: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

260: AND TRUNC(sysdate) < nvl(TRUNC(end_date_active), TRUNC(sysdate) + 1);
261: EXCEPTION
262: WHEN NO_DATA_FOUND THEN
263: x_return_status := fnd_api.g_ret_sts_error;
264: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
265: fnd_message.set_name('DPP', 'DPP_TXN_SUPP_INFO_ERR');
266: fnd_message.set_token('SUPPLIER_NAME', p_txn_header_rec_type.vendor_name);
267: fnd_message.set_token('SUPPLIER_ID', p_txn_header_rec_type.vendor_id);
268: x_msg_data :=fnd_message.get();

Line 276: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

272: END;
273: --Validate Supplier Site
274: IF (p_txn_header_rec_type.vendor_site_code IS NULL
275: AND p_txn_header_rec_type.vendor_site_id IS NULL) THEN
276: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
277: fnd_message.set_name('DPP', 'DPP_TXN_SUPP_SITE_NULL');
278: x_msg_data :=fnd_message.get();
279: END IF;
280: p_txn_header_rec_type.error_code := 'DPP_TXN_SUPP_SITE_NULL';

Line 302: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

298: AND apssa.org_id = to_number(p_txn_header_rec_type.org_id);
299: EXCEPTION
300: WHEN NO_DATA_FOUND THEN
301: x_return_status := fnd_api.g_ret_sts_error;
302: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
303: fnd_message.set_name('DPP', 'DPP_TXN_SUPP_SITE_ERR');
304: fnd_message.set_token('SUPPLIER_SITE', p_txn_header_rec_type.vendor_site_code);
305: fnd_message.set_token('SITE_ID', p_txn_header_rec_type.vendor_site_id);
306: x_msg_data :=fnd_message.get();

Line 319: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

315: WHEN Fnd_Api.G_EXC_ERROR THEN
316: x_return_status := Fnd_Api.g_ret_sts_error ;
317: WHEN others THEN
318: x_return_status := fnd_api.g_ret_sts_unexp_error;
319: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
320: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
321: fnd_message.set_token('ROUTINE', l_full_name);
322: fnd_message.set_token('ERRNO', SQLCODE);
323: fnd_message.set_token('REASON', sqlerrm);

Line 458: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

454: WHEN Fnd_Api.G_EXC_ERROR THEN
455: x_return_status := Fnd_Api.g_ret_sts_error ;
456: WHEN others THEN
457: x_return_status := fnd_api.g_ret_sts_unexp_error;
458: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
459: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
460: fnd_message.set_token('ROUTINE', l_full_name);
461: fnd_message.set_token('ERRNO', SQLCODE);
462: fnd_message.set_token('REASON', sqlerrm);

Line 492: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

488: END IF;
489: EXCEPTION
490: WHEN NO_DATA_FOUND THEN
491: x_return_status := fnd_api.g_ret_sts_error;
492: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
493: fnd_message.set_name('DPP', 'DPP_DAYS_COVRD_ERR');
494: fnd_message.set_token('SUPPLIER_NAME', p_txn_header_rec_type.vendor_name);
495: x_msg_data :=fnd_message.get();
496: END IF;

Line 501: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

497: FND_FILE.PUT_LINE(FND_FILE.LOG,' '||x_msg_data);
498: p_txn_header_rec_type.error_code := 'DPP_DAYS_COVRD_ERR';
499: WHEN others THEN
500: x_return_status := fnd_api.g_ret_sts_unexp_error;
501: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
502: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
503: fnd_message.set_token('ROUTINE', 'DPP_TRANSACTION_PVT');
504: fnd_message.set_token('ERRNO', SQLCODE);
505: fnd_message.set_token('REASON', sqlerrm);

Line 583: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

579:
580: EXCEPTION
581: WHEN no_data_found THEN
582: x_return_status := fnd_api.g_ret_sts_error;
583: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
584: fnd_message.set_name('DPP', 'DPP_TXN_SEQ_NO_ERR');
585: fnd_message.set_token('SEQ_NUM', 'Transaction Number');
586: END IF;
587: x_msg_data := fnd_message.get();

Line 618: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

614: AND lookup_code = 'NEW';
615: EXCEPTION
616: WHEN no_data_found THEN
617: x_return_status := fnd_api.g_ret_sts_error;
618: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
619: fnd_message.set_name('DPP', 'DPP_TXN_STS_ERR');
620: END IF;
621: x_msg_data := fnd_message.get();
622: FND_FILE.PUT_LINE(FND_FILE.LOG,' '||x_msg_data);

Line 649: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

645: OR p_txn_header_rec_type.days_covered > 9999
646: OR p_txn_header_rec_type.days_covered <> ROUND(p_txn_header_rec_type.days_covered)
647: THEN
648: x_return_status := fnd_api.g_ret_sts_error;
649: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
650: fnd_message.set_name('DPP', 'DPP_TXN_DAYS_COV_ERR');
651: END IF;
652: x_msg_data := fnd_message.get();
653: FND_FILE.PUT_LINE(FND_FILE.LOG,' '||x_msg_data);

Line 660: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

656: --RAISE Fnd_Api.g_exc_error;
657: END IF;
658: IF p_txn_header_rec_type.effective_start_date IS NULL THEN
659: x_return_status := fnd_api.g_ret_sts_error;
660: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
661: fnd_message.set_name('DPP', 'DPP_EFF_START_DATE_ERR');
662: END IF;
663: x_msg_data := fnd_message.get();
664: FND_FILE.PUT_LINE(FND_FILE.LOG,' '||x_msg_data);

Line 680: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

676: FND_FILE.PUT_LINE(FND_FILE.LOG,' '||x_msg_data);
677: x_return_status := Fnd_Api.g_ret_sts_error ;
678: WHEN others THEN
679: x_return_status := fnd_api.g_ret_sts_unexp_error;
680: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
681: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
682: fnd_message.set_token('ROUTINE', l_full_name);
683: fnd_message.set_token('ERRNO', SQLCODE);
684: fnd_message.set_token('REASON', sqlerrm);

Line 850: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR )

846: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
847: WHEN OTHERS THEN
848: dpp_utility_pvt.debug_message('Create Header OTHERS'||sqlerrm);
849: x_return_status := Fnd_Api.g_ret_sts_unexp_erroR ;
850: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR )
851: THEN
852: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
853: fnd_message.set_token('ROUTINE', 'DPP_TRANSACTION_PVT');
854: fnd_message.set_token('ERRNO', SQLCODE);

Line 894: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

890:
891: EXCEPTION
892: WHEN no_data_found THEN
893: x_return_status := fnd_api.g_ret_sts_error;
894: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
895: fnd_message.set_name('DPP', 'DPP_TXN_SEQ_NO_ERR');
896: fnd_message.set_token('SEQ_NUM', 'Transaction Line Id');
897: END IF;
898: x_msg_data := fnd_message.get();

Line 919: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

915: AND lookup_type = 'DPP_TRANSACTION_STATUSES';
916: EXCEPTION
917: WHEN no_data_found THEN
918: x_return_status := fnd_api.g_ret_sts_error;
919: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
920: fnd_message.set_name('DPP', 'DPP_TXN_STS_ERR');
921: END IF;
922: x_msg_data := fnd_message.get();
923: FND_FILE.PUT_LINE(FND_FILE.LOG,' '||x_msg_data);

Line 936: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

932: END;
933: --BUG 6806974
934: IF (p_txn_lines_tbl_type(i).supplier_part_num IS NULL AND p_txn_lines_tbl_type(i).item_number IS NULL
935: AND p_txn_lines_tbl_type(i).inventory_item_id IS NULL) THEN
936: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
937: fnd_message.set_name('DPP', 'DPP_TXN_SUP_PART_NO_NULL');
938: END IF;
939: x_msg_data := fnd_message.get();
940: l_error_message :=l_error_message|| x_msg_data;

Line 1499: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

1495: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
1496: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
1497: WHEN OTHERS THEN
1498: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
1499: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1500: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1501: fnd_message.set_token('ROUTINE', 'DPP_TRANSACTION_PVT VALIDATE SUPPLIER PART NUMBER');
1502: fnd_message.set_token('ERRNO', SQLCODE);
1503: fnd_message.set_token('REASON', sqlerrm);

Line 1706: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

1702: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
1703: WHEN OTHERS THEN
1704: dpp_utility_pvt.debug_message('Exception Create Lines'||sqlerrm);
1705: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
1706: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1707: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1708: fnd_message.set_token('ROUTINE', l_full_name);
1709: fnd_message.set_token('ERRNO', SQLCODE);
1710: fnd_message.set_token('REASON', sqlerrm);

Line 1858: FND_MSG_PUB.add;

1854: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1855: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');
1856: fnd_message.set_token('ERRNO', sqlcode);
1857: fnd_message.set_token('REASON', 'SUPPLIER TRADE PROFILE IS NOT FOUND'); --To be modified
1858: FND_MSG_PUB.add;
1859: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1860: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
1861: END IF;
1862: RAISE FND_API.g_exc_error;

Line 1859: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

1855: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');
1856: fnd_message.set_token('ERRNO', sqlcode);
1857: fnd_message.set_token('REASON', 'SUPPLIER TRADE PROFILE IS NOT FOUND'); --To be modified
1858: FND_MSG_PUB.add;
1859: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1860: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
1861: END IF;
1862: RAISE FND_API.g_exc_error;
1863: WHEN OTHERS THEN

Line 1860: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);

1856: fnd_message.set_token('ERRNO', sqlcode);
1857: fnd_message.set_token('REASON', 'SUPPLIER TRADE PROFILE IS NOT FOUND'); --To be modified
1858: FND_MSG_PUB.add;
1859: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1860: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
1861: END IF;
1862: RAISE FND_API.g_exc_error;
1863: WHEN OTHERS THEN
1864: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');

Line 1868: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

1864: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1865: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');
1866: fnd_message.set_token('ERRNO', sqlcode);
1867: fnd_message.set_token('REASON', sqlerrm);
1868: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1869: FND_MESSAGE.set_name('DPP', 'DPP_BUSEVT_INVALID_EXE_DET_ID'); --To be modified
1870: fnd_message.set_token('SEQ_NAME', 'DPP_EXECUTION_DETAIL_ID_SEQ'); --To be modified
1871: FND_MSG_PUB.add;
1872: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);

Line 1871: FND_MSG_PUB.add;

1867: fnd_message.set_token('REASON', sqlerrm);
1868: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1869: FND_MESSAGE.set_name('DPP', 'DPP_BUSEVT_INVALID_EXE_DET_ID'); --To be modified
1870: fnd_message.set_token('SEQ_NAME', 'DPP_EXECUTION_DETAIL_ID_SEQ'); --To be modified
1871: FND_MSG_PUB.add;
1872: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
1873: END IF;
1874: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1875: END;

Line 1872: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);

1868: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1869: FND_MESSAGE.set_name('DPP', 'DPP_BUSEVT_INVALID_EXE_DET_ID'); --To be modified
1870: fnd_message.set_token('SEQ_NAME', 'DPP_EXECUTION_DETAIL_ID_SEQ'); --To be modified
1871: FND_MSG_PUB.add;
1872: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
1873: END IF;
1874: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1875: END;
1876:

Line 1916: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

1912: p_txn_header_rec_type.error_code := 'DPP_UPDATE_COVEREDINV';
1913: ROLLBACK TO DPP_Update_CoveredInv;
1914: WHEN OTHERS THEN
1915: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
1916: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1917: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1918: fnd_message.set_token('ROUTINE', l_full_name);
1919: fnd_message.set_token('ERRNO', SQLCODE);
1920: fnd_message.set_token('REASON', sqlerrm);

Line 1954: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

1950: --Check whether the claim lines belong to the transaction
1951: IF (p_txn_header_rec_type.supp_dist_claim_number IS NULL AND
1952: p_txn_header_rec_type.supp_dist_claim_id IS NULL ) THEN
1953: x_return_status := fnd_api.g_ret_sts_error;
1954: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1955: fnd_message.set_name('DPP', 'DPP_CLAIM_NUMBER_NULL');
1956: x_msg_data := fnd_message.get();
1957: p_txn_header_rec_type.error_code := 'DPP_CLAIM_NUMBER_NULL';
1958: l_error_message := l_error_message || x_msg_data;

Line 2050: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

2046: WHEN Fnd_Api.G_EXC_ERROR THEN
2047: x_return_status := Fnd_Api.g_ret_sts_error ;
2048: WHEN others THEN
2049: x_return_status := fnd_api.g_ret_sts_unexp_error;
2050: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2051: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
2052: fnd_message.set_token('ROUTINE', 'DPP_TRANSACTION_PVT');
2053: fnd_message.set_token('ERRNO', SQLCODE);
2054: fnd_message.set_token('REASON', sqlerrm);

Line 2096: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

2092: AND fl.lookup_code = 'UPDCLM';
2093: EXCEPTION
2094: WHEN no_data_found THEN
2095: x_return_status := fnd_api.g_ret_sts_error;
2096: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2097: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
2098: fnd_message.set_token('ROUTINE', l_full_name);
2099: fnd_message.set_token('ERRNO', SQLCODE);
2100: fnd_message.set_token('REASON', sqlerrm);

Line 2183: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

2179: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
2180: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
2181: WHEN OTHERS THEN
2182: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
2183: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2184: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
2185: fnd_message.set_token('ROUTINE', l_full_name);
2186: fnd_message.set_token('ERRNO', SQLCODE);
2187: fnd_message.set_token('REASON', sqlerrm);

Line 2318: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

2314: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
2315: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
2316: WHEN OTHERS THEN
2317: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
2318: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2319: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
2320: fnd_message.set_token('ROUTINE', 'DPP_TRANSACTION_PVT');
2321: fnd_message.set_token('ERRNO', SQLCODE);
2322: fnd_message.set_token('REASON', sqlerrm);

Line 2433: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

2429: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
2430: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
2431: WHEN OTHERS THEN
2432: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
2433: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2434: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
2435: fnd_message.set_token('ROUTINE', l_full_name);
2436: fnd_message.set_token('ERRNO', SQLCODE);
2437: fnd_message.set_token('REASON', sqlerrm);

Line 2568: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

2564: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
2565: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
2566: WHEN OTHERS THEN
2567: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
2568: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2569: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
2570: fnd_message.set_token('ROUTINE', l_full_name);
2571: fnd_message.set_token('ERRNO', SQLCODE);
2572: fnd_message.set_token('REASON', sqlerrm);

Line 2634: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

2630: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
2631:
2632: WHEN OTHERS THEN
2633: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
2634: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2635: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
2636: fnd_message.set_token('ROUTINE', 'DPP_TRANSACTION_PVT');
2637: fnd_message.set_token('ERRNO', SQLCODE);
2638: fnd_message.set_token('REASON', sqlerrm);

Line 2697: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

2693: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
2694: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
2695: WHEN OTHERS THEN
2696: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
2697: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2698: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
2699: fnd_message.set_token('ROUTINE', 'DPP_TRANSACTION_PVT');
2700: fnd_message.set_token('ERRNO', SQLCODE);
2701: fnd_message.set_token('REASON', sqlerrm);

Line 2761: Fnd_Msg_Pub.initialize;

2757: BEGIN
2758: -- Standard begin of API savepoint
2759: SAVEPOINT DPP_Insert_Transaction;
2760: IF Fnd_Api.to_boolean(p_init_msg_list) THEN
2761: Fnd_Msg_Pub.initialize;
2762: END IF;
2763: IF NOT Fnd_Api.compatible_api_call
2764: (
2765: l_api_version,

Line 3010: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

3006: AND lookup_code = 'CANCELLED';
3007: EXCEPTION
3008: WHEN no_data_found THEN
3009: x_return_status := fnd_api.g_ret_sts_error;
3010: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3011: fnd_message.set_name('DPP', 'DPP_TXN_STS_ERR');
3012: END IF;
3013: x_msg_data := fnd_message.get();
3014: --RAISE Fnd_Api.G_EXC_ERROR;

Line 3456: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR )

3452: dpp_utility_pvt.debug_message('Error:' ||x_msg_data);
3453: x_msg_data := x_msg_data || l_concatenated_error_message;
3454: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
3455: dpp_utility_pvt.debug_message('Error after assignment:' ||x_msg_data);
3456: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR )
3457: THEN
3458: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3459: END IF;
3460: END insert_transaction;

Line 3458: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);

3454: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
3455: dpp_utility_pvt.debug_message('Error after assignment:' ||x_msg_data);
3456: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR )
3457: THEN
3458: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3459: END IF;
3460: END insert_transaction;
3461:
3462: PROCEDURE Create_IntHeader(

Line 3681: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

3677:
3678: EXCEPTION
3679: WHEN others THEN
3680: x_return_status := fnd_api.g_ret_sts_unexp_error;
3681: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3682: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
3683: fnd_message.set_token('ROUTINE', 'DPP_TRANSACTION_PVT');
3684: fnd_message.set_token('ERRNO', SQLCODE);
3685: fnd_message.set_token('REASON', sqlerrm);

Line 3825: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

3821: dpp_utility_pvt.debug_message('Create IntLines l_error_message:'||l_error_message || 'sqlerrm'||sqlerrm);
3822: WHEN others THEN
3823: dpp_utility_pvt.debug_message('Create IntLines : SQLERRM:'||SQLERRM);
3824: x_return_status := fnd_api.g_ret_sts_unexp_error;
3825: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3826: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
3827: fnd_message.set_token('ROUTINE', 'DPP_TRANSACTION_PVT');
3828: fnd_message.set_token('ERRNO', SQLCODE);
3829: fnd_message.set_token('REASON', sqlerrm);

Line 4276: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR )

4272: WHEN OTHERS THEN
4273: dpp_utility_pvt.debug_message('DPP EXCEPTION OTHERS'||SQLERRM);
4274: x_return_status := Fnd_Api.g_ret_sts_unexp_error;
4275: --ROLLBACK TO dpp_create_webadi_transaction;
4276: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR )
4277: THEN
4278: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
4279: END IF;
4280: END create_webadi_transaction;

Line 4278: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);

4274: x_return_status := Fnd_Api.g_ret_sts_unexp_error;
4275: --ROLLBACK TO dpp_create_webadi_transaction;
4276: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR )
4277: THEN
4278: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
4279: END IF;
4280: END create_webadi_transaction;
4281:
4282: PROCEDURE Raise_OutBoundEvent(

Line 4350: Fnd_Msg_Pub.Count_AND_Get

4346: ROLLBACK TO DPP_Raise_OutBoundEvent;
4347: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
4348: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
4349: ROLLBACK TO DPP_Raise_OutBoundEvent;
4350: Fnd_Msg_Pub.Count_AND_Get
4351: ( p_count => x_msg_count,
4352: p_data => x_msg_data,
4353: p_encoded => Fnd_Api.G_FALSE
4354: );

Line 4357: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

4353: p_encoded => Fnd_Api.G_FALSE
4354: );
4355: WHEN OTHERS THEN
4356: x_return_status := Fnd_Api.g_ret_sts_unexp_error;
4357: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
4358: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
4359: fnd_message.set_token('ROUTINE', l_full_name);
4360: fnd_message.set_token('ERRNO', SQLCODE);
4361: fnd_message.set_token('REASON', sqlerrm);

Line 4364: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR )

4360: fnd_message.set_token('ERRNO', SQLCODE);
4361: fnd_message.set_token('REASON', sqlerrm);
4362: END IF;
4363: ROLLBACK TO DPP_Raise_OutBoundEvent;
4364: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR )
4365: THEN
4366: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
4367: END IF;
4368: Fnd_Msg_Pub.Count_AND_Get

Line 4366: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);

4362: END IF;
4363: ROLLBACK TO DPP_Raise_OutBoundEvent;
4364: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR )
4365: THEN
4366: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
4367: END IF;
4368: Fnd_Msg_Pub.Count_AND_Get
4369: ( p_count => x_msg_count,
4370: p_data => x_msg_data,

Line 4368: Fnd_Msg_Pub.Count_AND_Get

4364: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR )
4365: THEN
4366: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
4367: END IF;
4368: Fnd_Msg_Pub.Count_AND_Get
4369: ( p_count => x_msg_count,
4370: p_data => x_msg_data,
4371: p_encoded => Fnd_Api.G_FALSE
4372: );

Line 4911: Fnd_Msg_Pub.Count_AND_Get

4907: EXCEPTION
4908: WHEN Fnd_Api.G_EXC_ERROR THEN
4909: dpp_utility_pvt.debug_message('DPP EXCEPTION G_EXC_ERROR');
4910: ROLLBACK TO dpp_create_txn;
4911: Fnd_Msg_Pub.Count_AND_Get
4912: ( p_count => l_msg_count,
4913: p_data => l_msg_data,
4914: p_encoded => Fnd_Api.G_FALSE
4915: );

Line 4919: Fnd_Msg_Pub.Count_AND_Get

4915: );
4916: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
4917: dpp_utility_pvt.debug_message('DPP EXCEPTION G_EXC_UNEXPECTED_ERROR');
4918: ROLLBACK TO dpp_create_txn;
4919: Fnd_Msg_Pub.Count_AND_Get
4920: ( p_count => l_msg_count,
4921: p_data => l_msg_data,
4922: p_encoded => Fnd_Api.G_FALSE
4923: );

Line 4927: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR )

4923: );
4924: WHEN OTHERS THEN
4925: dpp_utility_pvt.debug_message('DPP EXCEPTION OTHERS'||SQLERRM);
4926: ROLLBACK TO dpp_create_txn;
4927: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR )
4928: THEN
4929: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
4930: END IF;
4931: Fnd_Msg_Pub.Count_AND_Get

Line 4929: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);

4925: dpp_utility_pvt.debug_message('DPP EXCEPTION OTHERS'||SQLERRM);
4926: ROLLBACK TO dpp_create_txn;
4927: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR )
4928: THEN
4929: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
4930: END IF;
4931: Fnd_Msg_Pub.Count_AND_Get
4932: ( p_count => l_msg_count,
4933: p_data => l_msg_data,

Line 4931: Fnd_Msg_Pub.Count_AND_Get

4927: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR )
4928: THEN
4929: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
4930: END IF;
4931: Fnd_Msg_Pub.Count_AND_Get
4932: ( p_count => l_msg_count,
4933: p_data => l_msg_data,
4934: p_encoded => Fnd_Api.G_FALSE
4935: );