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 29: dpp_debug_high_on constant boolean := fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_debug_high);

25: --01-Jun-09 anbbalas Bug no.8563518 - Validation for negative Prior Price and
26: -- negative Change Value when the change type is Amount Decrease
27:
28: -- NOTE :
29: dpp_debug_high_on constant boolean := fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_debug_high);
30: dpp_debug_low_on constant boolean := fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_debug_low);
31: dpp_debug_medium_on constant boolean := fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_debug_medium);
32:
33: g_pkg_name constant VARCHAR2(30) := 'DPP_TRANSACTION_PVT';

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

26: -- negative Change Value when the change type is Amount Decrease
27:
28: -- NOTE :
29: dpp_debug_high_on constant boolean := fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_debug_high);
30: dpp_debug_low_on constant boolean := fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_debug_low);
31: dpp_debug_medium_on constant boolean := fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_debug_medium);
32:
33: g_pkg_name constant VARCHAR2(30) := 'DPP_TRANSACTION_PVT';
34: g_debug boolean := fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_debug_high);

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

27:
28: -- NOTE :
29: dpp_debug_high_on constant boolean := fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_debug_high);
30: dpp_debug_low_on constant boolean := fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_debug_low);
31: dpp_debug_medium_on constant boolean := fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_debug_medium);
32:
33: g_pkg_name constant VARCHAR2(30) := 'DPP_TRANSACTION_PVT';
34: g_debug boolean := fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_debug_high);
35: g_file_name constant VARCHAR2(14) := 'dppvtxnb.pls';

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

30: dpp_debug_low_on constant boolean := fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_debug_low);
31: dpp_debug_medium_on constant boolean := fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_debug_medium);
32:
33: g_pkg_name constant VARCHAR2(30) := 'DPP_TRANSACTION_PVT';
34: g_debug boolean := fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_debug_high);
35: g_file_name constant VARCHAR2(14) := 'dppvtxnb.pls';
36:
37: PROCEDURE Update_InterfaceErrSts(
38: p_txn_header_rec_type IN OUT nocopy txn_header_rec,

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

69: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
70: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
71: WHEN OTHERS THEN
72: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
73: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
74: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
75: fnd_message.set_token('ROUTINE', 'DPP_TRANSACTION_PVT');
76: fnd_message.set_token('ERRNO', SQLCODE);
77: fnd_message.set_token('REASON', sqlerrm);

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

98: x_return_status := fnd_api.g_ret_sts_success;
99: --BUG 6806974
100: IF p_txn_header_rec_type.operating_unit_name IS NULL
101: AND p_txn_header_rec_type.org_id IS NULL THEN
102: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
103: fnd_message.set_name( 'DPP', 'DPP_TXN_OPERATING_UNIT_NULL');
104: x_msg_data := fnd_message.get();
105: END IF;
106: x_return_status := fnd_api.g_ret_sts_error;

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

129:
130: EXCEPTION
131: WHEN NO_DATA_FOUND THEN
132: x_return_status := fnd_api.g_ret_sts_error;
133: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
134: fnd_message.set_name( 'DPP', 'DPP_TXN_OPERATING_UNIT_ERR');
135: fnd_message.set_token('OPERATING_UNIT', p_txn_header_rec_type.operating_unit_name);
136: fnd_message.set_token('ORG_ID', p_txn_header_rec_type.org_id);
137: x_msg_data := fnd_message.get();

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

140: WHEN Fnd_Api.G_EXC_ERROR THEN
141: x_return_status := Fnd_Api.g_ret_sts_error ;
142: WHEN OTHERS THEN
143: x_return_status := fnd_api.g_ret_sts_unexp_error;
144: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
145: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
146: fnd_message.set_token('ROUTINE', l_full_name);
147: fnd_message.set_token('ERRNO', SQLCODE);
148: fnd_message.set_token('REASON', sqlerrm);

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

185: END IF;
186: -- Initialize API return status to sucess
187: x_return_status := fnd_api.g_ret_sts_success;
188: IF p_txn_header_rec_type.ref_document_number IS NULL THEN
189: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
190: fnd_message.set_name('DPP', 'DPP_DOC_REF_NUM_NULL');
191: END IF;
192: x_msg_data := fnd_message.get();
193: p_txn_header_rec_type.error_code := 'DPP_DOC_REF_NUM_NULL';

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

199: );
200:
201: IF l_valid_doc = 'N' OR length(p_txn_header_rec_type.ref_document_number) > 40 THEN
202: x_return_status := fnd_api.g_ret_sts_error;
203: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
204: fnd_message.set_name('DPP', 'DPP_DOC_REF_NUM_ERR');
205: fnd_message.set_token('DOC_REF_NO', p_txn_header_rec_type.ref_document_number);
206: END IF;
207: x_msg_data := fnd_message.get();

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

214: WHEN Fnd_Api.G_EXC_ERROR THEN
215: x_return_status := Fnd_Api.g_ret_sts_error ;
216: WHEN OTHERS THEN
217: x_return_status := fnd_api.g_ret_sts_unexp_error;
218: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
219: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
220: fnd_message.set_token('ROUTINE', l_full_name);
221: fnd_message.set_token('ERRNO', SQLCODE);
222: fnd_message.set_token('REASON', sqlerrm);

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

242: x_return_status := fnd_api.g_ret_sts_success;
243: --BUG 6806974
244: IF (p_txn_header_rec_type.vendor_name IS NULL
245: AND p_txn_header_rec_type.vendor_id IS NULL) THEN
246: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
247: fnd_message.set_name('DPP', 'DPP_TXN_SUPP_INFO_NULL');
248: x_msg_data :=fnd_message.get();
249: END IF;
250: p_txn_header_rec_type.error_code := 'DPP_TXN_SUPP_INFO_NULL';

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

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

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

277: END;
278: --Validate Supplier Site
279: IF (p_txn_header_rec_type.vendor_site_code IS NULL
280: AND p_txn_header_rec_type.vendor_site_id IS NULL) THEN
281: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
282: fnd_message.set_name('DPP', 'DPP_TXN_SUPP_SITE_NULL');
283: x_msg_data :=fnd_message.get();
284: END IF;
285: p_txn_header_rec_type.error_code := 'DPP_TXN_SUPP_SITE_NULL';

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

303: AND apssa.org_id = to_number(p_txn_header_rec_type.org_id);
304: EXCEPTION
305: WHEN NO_DATA_FOUND THEN
306: x_return_status := fnd_api.g_ret_sts_error;
307: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
308: fnd_message.set_name('DPP', 'DPP_TXN_SUPP_SITE_ERR');
309: fnd_message.set_token('SUPPLIER_SITE', p_txn_header_rec_type.vendor_site_code);
310: fnd_message.set_token('SITE_ID', p_txn_header_rec_type.vendor_site_id);
311: x_msg_data :=fnd_message.get();

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

320: WHEN Fnd_Api.G_EXC_ERROR THEN
321: x_return_status := Fnd_Api.g_ret_sts_error ;
322: WHEN others THEN
323: x_return_status := fnd_api.g_ret_sts_unexp_error;
324: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
325: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
326: fnd_message.set_token('ROUTINE', l_full_name);
327: fnd_message.set_token('ERRNO', SQLCODE);
328: fnd_message.set_token('REASON', sqlerrm);

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

364: CLOSE get_supp_trd_prfl_csr;
365: EXCEPTION
366: WHEN NO_DATA_FOUND THEN
367: x_return_status := fnd_api.g_ret_sts_error;
368: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
369: fnd_message.set_name('DPP','DPP_SUPP_TRDPRFLS_MISSING_ERR');
370: x_msg_data :=fnd_message.get();
371: END IF;
372: p_txn_header_rec_type.error_code := 'DPP_SUPP_TRDPRFLS_MISSING_ERR';

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

388: WHEN Fnd_Api.G_EXC_ERROR THEN
389: x_return_status := Fnd_Api.g_ret_sts_error ;
390: WHEN others THEN
391: x_return_status := fnd_api.g_ret_sts_unexp_error;
392: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
393: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
394: fnd_message.set_token('ROUTINE', l_full_name);
395: fnd_message.set_token('ERRNO', SQLCODE);
396: fnd_message.set_token('REASON', sqlerrm);

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

446: END;
447:
448: IF l_count = 0 THEN --Process Setup does not exist
449: x_return_status := fnd_api.g_ret_sts_error;
450: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
451: fnd_message.set_name( 'DPP','DPP_PROCESS_SETUP_MISSING_ERR');
452: x_msg_data :=fnd_message.get();
453: END IF;
454: p_txn_header_rec_type.error_code := 'DPP_PROCESS_SETUP_MISSING_ERR';

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

464: WHEN Fnd_Api.G_EXC_ERROR THEN
465: x_return_status := Fnd_Api.g_ret_sts_error ;
466: WHEN others THEN
467: x_return_status := fnd_api.g_ret_sts_unexp_error;
468: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
469: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
470: fnd_message.set_token('ROUTINE', l_full_name);
471: fnd_message.set_token('ERRNO', SQLCODE);
472: fnd_message.set_token('REASON', sqlerrm);

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

603: WHEN Fnd_Api.G_EXC_ERROR THEN
604: x_return_status := Fnd_Api.g_ret_sts_error ;
605: WHEN others THEN
606: x_return_status := fnd_api.g_ret_sts_unexp_error;
607: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
608: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
609: fnd_message.set_token('ROUTINE', l_full_name);
610: fnd_message.set_token('ERRNO', SQLCODE);
611: fnd_message.set_token('REASON', sqlerrm);

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

637: END IF;
638: EXCEPTION
639: WHEN NO_DATA_FOUND THEN
640: x_return_status := fnd_api.g_ret_sts_error;
641: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
642: fnd_message.set_name('DPP', 'DPP_DAYS_COVRD_ERR');
643: fnd_message.set_token('SUPPLIER_NAME', p_txn_header_rec_type.vendor_name);
644: x_msg_data :=fnd_message.get();
645: END IF;

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

646: FND_FILE.PUT_LINE(FND_FILE.LOG,' '||x_msg_data);
647: p_txn_header_rec_type.error_code := 'DPP_DAYS_COVRD_ERR';
648: WHEN others THEN
649: x_return_status := fnd_api.g_ret_sts_unexp_error;
650: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
651: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
652: fnd_message.set_token('ROUTINE', 'DPP_TRANSACTION_PVT');
653: fnd_message.set_token('ERRNO', SQLCODE);
654: fnd_message.set_token('REASON', sqlerrm);

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

738:
739: EXCEPTION
740: WHEN no_data_found THEN
741: x_return_status := fnd_api.g_ret_sts_error;
742: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
743: fnd_message.set_name('DPP', 'DPP_TXN_SEQ_NO_ERR');
744: fnd_message.set_token('SEQ_NUM', 'Transaction Number');
745: END IF;
746: x_msg_data := fnd_message.get();

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

771: CLOSE get_trunc_dates;
772: EXCEPTION
773: WHEN OTHERS THEN
774: x_return_status := fnd_api.g_ret_sts_error;
775: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
776: fnd_message.set_name('DPP', 'DPP_TXN_STS_ERR');
777: END IF;
778: x_msg_data := fnd_message.get();
779: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error while getting the truncated date' || x_msg_data);

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

797: AND lookup_code = l_txn_status_lookup_code; --ANBBALAS for 12_1_2
798: EXCEPTION
799: WHEN no_data_found THEN
800: x_return_status := fnd_api.g_ret_sts_error;
801: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
802: fnd_message.set_name('DPP', 'DPP_TXN_STS_ERR');
803: END IF;
804: x_msg_data := fnd_message.get();
805: FND_FILE.PUT_LINE(FND_FILE.LOG,' '||x_msg_data);

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

828: OR p_txn_header_rec_type.days_covered > 9999
829: OR p_txn_header_rec_type.days_covered <> ROUND(p_txn_header_rec_type.days_covered)
830: THEN
831: x_return_status := fnd_api.g_ret_sts_error;
832: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
833: fnd_message.set_name('DPP', 'DPP_TXN_DAYS_COV_ERR');
834: END IF;
835: x_msg_data := fnd_message.get();
836: FND_FILE.PUT_LINE(FND_FILE.LOG,' '||x_msg_data);

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

839: --RAISE Fnd_Api.g_exc_error;
840: END IF;
841: IF p_txn_header_rec_type.effective_start_date IS NULL THEN
842: x_return_status := fnd_api.g_ret_sts_error;
843: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
844: fnd_message.set_name('DPP', 'DPP_EFF_START_DATE_ERR');
845: END IF;
846: x_msg_data := fnd_message.get();
847: FND_FILE.PUT_LINE(FND_FILE.LOG,' '||x_msg_data);

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

859: FND_FILE.PUT_LINE(FND_FILE.LOG,' '||x_msg_data);
860: x_return_status := Fnd_Api.g_ret_sts_error ;
861: WHEN others THEN
862: x_return_status := fnd_api.g_ret_sts_unexp_error;
863: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
864: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
865: fnd_message.set_token('ROUTINE', l_full_name);
866: fnd_message.set_token('ERRNO', SQLCODE);
867: fnd_message.set_token('REASON', sqlerrm);

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

1029: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
1030: WHEN OTHERS THEN
1031: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_EXCEPTION, 'dpp.plsql.' || L_FULL_NAME, 'Create Header OTHERS'||sqlerrm);
1032: x_return_status := Fnd_Api.g_ret_sts_unexp_erroR ;
1033: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR )
1034: THEN
1035: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1036: fnd_message.set_token('ROUTINE', 'DPP_TRANSACTION_PVT');
1037: fnd_message.set_token('ERRNO', SQLCODE);

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

1073:
1074: EXCEPTION
1075: WHEN no_data_found THEN
1076: x_return_status := fnd_api.g_ret_sts_error;
1077: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1078: fnd_message.set_name('DPP', 'DPP_TXN_SEQ_NO_ERR');
1079: fnd_message.set_token('SEQ_NUM', 'Transaction Line Id');
1080: END IF;
1081: x_msg_data := fnd_message.get();

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

1098: AND lookup_type = 'DPP_TRANSACTION_STATUSES';
1099: EXCEPTION
1100: WHEN no_data_found THEN
1101: x_return_status := fnd_api.g_ret_sts_error;
1102: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1103: fnd_message.set_name('DPP', 'DPP_TXN_STS_ERR');
1104: END IF;
1105: x_msg_data := fnd_message.get();
1106: FND_FILE.PUT_LINE(FND_FILE.LOG,' '||x_msg_data);

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

1115: END;
1116: --BUG 6806974
1117: IF (p_txn_lines_tbl_type(i).supplier_part_num IS NULL AND p_txn_lines_tbl_type(i).item_number IS NULL
1118: AND p_txn_lines_tbl_type(i).inventory_item_id IS NULL) THEN
1119: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1120: fnd_message.set_name('DPP', 'DPP_TXN_SUP_PART_NO_NULL');
1121: END IF;
1122: x_msg_data := fnd_message.get();
1123: l_error_message :=l_error_message|| x_msg_data;

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

1700: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
1701: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
1702: WHEN OTHERS THEN
1703: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
1704: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1705: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1706: fnd_message.set_token('ROUTINE', 'DPP_TRANSACTION_PVT VALIDATE SUPPLIER PART NUMBER');
1707: fnd_message.set_token('ERRNO', SQLCODE);
1708: fnd_message.set_token('REASON', sqlerrm);

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

1907: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
1908: WHEN OTHERS THEN
1909: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_EXCEPTION, 'dpp.plsql.' || L_FULL_NAME, 'Exception Create Lines'||sqlerrm);
1910: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
1911: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1912: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1913: fnd_message.set_token('ROUTINE', l_full_name);
1914: fnd_message.set_token('ERRNO', SQLCODE);
1915: fnd_message.set_token('REASON', sqlerrm);

Line 2067: FND_MSG_PUB.add;

2063: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
2064: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');
2065: fnd_message.set_token('ERRNO', sqlcode);
2066: fnd_message.set_token('REASON', 'SUPPLIER TRADE PROFILE IS NOT FOUND'); --To be modified
2067: FND_MSG_PUB.add;
2068: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
2069: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
2070: END IF;
2071: RAISE FND_API.g_exc_error;

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

2064: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');
2065: fnd_message.set_token('ERRNO', sqlcode);
2066: fnd_message.set_token('REASON', 'SUPPLIER TRADE PROFILE IS NOT FOUND'); --To be modified
2067: FND_MSG_PUB.add;
2068: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
2069: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
2070: END IF;
2071: RAISE FND_API.g_exc_error;
2072: WHEN OTHERS THEN

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

2065: fnd_message.set_token('ERRNO', sqlcode);
2066: fnd_message.set_token('REASON', 'SUPPLIER TRADE PROFILE IS NOT FOUND'); --To be modified
2067: FND_MSG_PUB.add;
2068: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
2069: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
2070: END IF;
2071: RAISE FND_API.g_exc_error;
2072: WHEN OTHERS THEN
2073: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');

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

2073: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
2074: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');
2075: fnd_message.set_token('ERRNO', sqlcode);
2076: fnd_message.set_token('REASON', sqlerrm);
2077: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
2078: FND_MESSAGE.set_name('DPP', 'DPP_BUSEVT_INVALID_EXE_DET_ID'); --To be modified
2079: fnd_message.set_token('SEQ_NAME', 'DPP_EXECUTION_DETAIL_ID_SEQ'); --To be modified
2080: FND_MSG_PUB.add;
2081: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);

Line 2080: FND_MSG_PUB.add;

2076: fnd_message.set_token('REASON', sqlerrm);
2077: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
2078: FND_MESSAGE.set_name('DPP', 'DPP_BUSEVT_INVALID_EXE_DET_ID'); --To be modified
2079: fnd_message.set_token('SEQ_NAME', 'DPP_EXECUTION_DETAIL_ID_SEQ'); --To be modified
2080: FND_MSG_PUB.add;
2081: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
2082: END IF;
2083: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2084: END;

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

2077: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
2078: FND_MESSAGE.set_name('DPP', 'DPP_BUSEVT_INVALID_EXE_DET_ID'); --To be modified
2079: fnd_message.set_token('SEQ_NAME', 'DPP_EXECUTION_DETAIL_ID_SEQ'); --To be modified
2080: FND_MSG_PUB.add;
2081: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
2082: END IF;
2083: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2084: END;
2085:

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

2121: p_txn_header_rec_type.error_code := 'DPP_UPDATE_COVEREDINV';
2122: ROLLBACK TO DPP_Update_CoveredInv;
2123: WHEN OTHERS THEN
2124: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
2125: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2126: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
2127: fnd_message.set_token('ROUTINE', l_full_name);
2128: fnd_message.set_token('ERRNO', SQLCODE);
2129: fnd_message.set_token('REASON', sqlerrm);

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

2159: --Check whether the claim lines belong to the transaction
2160: IF (p_txn_header_rec_type.supp_dist_claim_number IS NULL AND
2161: p_txn_header_rec_type.supp_dist_claim_id IS NULL ) THEN
2162: x_return_status := fnd_api.g_ret_sts_error;
2163: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2164: fnd_message.set_name('DPP', 'DPP_CLAIM_NUMBER_NULL');
2165: x_msg_data := fnd_message.get();
2166: p_txn_header_rec_type.error_code := 'DPP_CLAIM_NUMBER_NULL';
2167: l_error_message := l_error_message || x_msg_data;

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

2255: WHEN Fnd_Api.G_EXC_ERROR THEN
2256: x_return_status := Fnd_Api.g_ret_sts_error ;
2257: WHEN others THEN
2258: x_return_status := fnd_api.g_ret_sts_unexp_error;
2259: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2260: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
2261: fnd_message.set_token('ROUTINE', 'DPP_TRANSACTION_PVT');
2262: fnd_message.set_token('ERRNO', SQLCODE);
2263: fnd_message.set_token('REASON', sqlerrm);

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

2301: AND fl.lookup_code = 'UPDCLM';
2302: EXCEPTION
2303: WHEN no_data_found THEN
2304: x_return_status := fnd_api.g_ret_sts_error;
2305: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2306: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
2307: fnd_message.set_token('ROUTINE', l_full_name);
2308: fnd_message.set_token('ERRNO', SQLCODE);
2309: fnd_message.set_token('REASON', sqlerrm);

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

2388: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
2389: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
2390: WHEN OTHERS THEN
2391: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
2392: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2393: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
2394: fnd_message.set_token('ROUTINE', l_full_name);
2395: fnd_message.set_token('ERRNO', SQLCODE);
2396: fnd_message.set_token('REASON', sqlerrm);

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

2524: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
2525: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
2526: WHEN OTHERS THEN
2527: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
2528: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2529: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
2530: fnd_message.set_token('ROUTINE', 'DPP_TRANSACTION_PVT');
2531: fnd_message.set_token('ERRNO', SQLCODE);
2532: fnd_message.set_token('REASON', sqlerrm);

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

2639: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
2640: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
2641: WHEN OTHERS THEN
2642: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
2643: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2644: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
2645: fnd_message.set_token('ROUTINE', l_full_name);
2646: fnd_message.set_token('ERRNO', SQLCODE);
2647: fnd_message.set_token('REASON', sqlerrm);

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

2774: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
2775: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
2776: WHEN OTHERS THEN
2777: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
2778: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2779: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
2780: fnd_message.set_token('ROUTINE', l_full_name);
2781: fnd_message.set_token('ERRNO', SQLCODE);
2782: fnd_message.set_token('REASON', sqlerrm);

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

2840: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
2841:
2842: WHEN OTHERS THEN
2843: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
2844: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2845: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
2846: fnd_message.set_token('ROUTINE', 'DPP_TRANSACTION_PVT');
2847: fnd_message.set_token('ERRNO', SQLCODE);
2848: fnd_message.set_token('REASON', sqlerrm);

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

2903: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
2904: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
2905: WHEN OTHERS THEN
2906: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
2907: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2908: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
2909: fnd_message.set_token('ROUTINE', 'DPP_TRANSACTION_PVT');
2910: fnd_message.set_token('ERRNO', SQLCODE);
2911: fnd_message.set_token('REASON', sqlerrm);

Line 2972: Fnd_Msg_Pub.initialize;

2968: BEGIN
2969: -- Standard begin of API savepoint
2970: SAVEPOINT DPP_Insert_Transaction;
2971: IF Fnd_Api.to_boolean(p_init_msg_list) THEN
2972: Fnd_Msg_Pub.initialize;
2973: END IF;
2974: IF NOT Fnd_Api.compatible_api_call
2975: (
2976: l_api_version,

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

3268: AND lookup_code = 'CANCELLED';
3269: EXCEPTION
3270: WHEN no_data_found THEN
3271: x_return_status := fnd_api.g_ret_sts_error;
3272: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3273: fnd_message.set_name('DPP', 'DPP_TXN_STS_ERR');
3274: END IF;
3275: x_msg_data := fnd_message.get();
3276: --RAISE Fnd_Api.G_EXC_ERROR;

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

3739: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_EXCEPTION, 'dpp.plsql.' || L_FULL_NAME, 'Error:' ||x_msg_data);
3740: x_msg_data := x_msg_data || l_concatenated_error_message;
3741: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
3742: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_EXCEPTION, 'dpp.plsql.' || L_FULL_NAME, 'Error after assignment:' ||x_msg_data);
3743: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR )
3744: THEN
3745: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3746: END IF;
3747: END insert_transaction;

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

3741: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
3742: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_EXCEPTION, 'dpp.plsql.' || L_FULL_NAME, 'Error after assignment:' ||x_msg_data);
3743: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR )
3744: THEN
3745: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3746: END IF;
3747: END insert_transaction;
3748:
3749: PROCEDURE Create_IntHeader(

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

3964:
3965: EXCEPTION
3966: WHEN others THEN
3967: x_return_status := fnd_api.g_ret_sts_unexp_error;
3968: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3969: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
3970: fnd_message.set_token('ROUTINE', 'DPP_TRANSACTION_PVT');
3971: fnd_message.set_token('ERRNO', SQLCODE);
3972: fnd_message.set_token('REASON', sqlerrm);

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

4111: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_EXCEPTION, 'dpp.plsql.' || L_FULL_NAME, 'Create IntLines l_error_message:'||l_error_message || 'sqlerrm'||sqlerrm);
4112: WHEN others THEN
4113: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_EXCEPTION, 'dpp.plsql.' || L_FULL_NAME, 'Create IntLines : SQLERRM:'||SQLERRM);
4114: x_return_status := fnd_api.g_ret_sts_unexp_error;
4115: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
4116: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
4117: fnd_message.set_token('ROUTINE', 'DPP_TRANSACTION_PVT');
4118: fnd_message.set_token('ERRNO', SQLCODE);
4119: fnd_message.set_token('REASON', sqlerrm);

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

4561: WHEN OTHERS THEN
4562: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_EXCEPTION, 'dpp.plsql.' || L_FULL_NAME, 'DPP EXCEPTION OTHERS'||SQLERRM);
4563: x_return_status := Fnd_Api.g_ret_sts_unexp_error;
4564: --ROLLBACK TO dpp_create_webadi_transaction;
4565: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR )
4566: THEN
4567: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
4568: END IF;
4569: END create_webadi_transaction;

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

4563: x_return_status := Fnd_Api.g_ret_sts_unexp_error;
4564: --ROLLBACK TO dpp_create_webadi_transaction;
4565: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR )
4566: THEN
4567: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
4568: END IF;
4569: END create_webadi_transaction;
4570:
4571: PROCEDURE Raise_OutBoundEvent(

Line 4637: Fnd_Msg_Pub.Count_AND_Get

4633: ROLLBACK TO DPP_Raise_OutBoundEvent;
4634: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
4635: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
4636: ROLLBACK TO DPP_Raise_OutBoundEvent;
4637: Fnd_Msg_Pub.Count_AND_Get
4638: ( p_count => x_msg_count,
4639: p_data => x_msg_data,
4640: p_encoded => Fnd_Api.G_FALSE
4641: );

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

4640: p_encoded => Fnd_Api.G_FALSE
4641: );
4642: WHEN OTHERS THEN
4643: x_return_status := Fnd_Api.g_ret_sts_unexp_error;
4644: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
4645: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
4646: fnd_message.set_token('ROUTINE', l_full_name);
4647: fnd_message.set_token('ERRNO', SQLCODE);
4648: fnd_message.set_token('REASON', sqlerrm);

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

4647: fnd_message.set_token('ERRNO', SQLCODE);
4648: fnd_message.set_token('REASON', sqlerrm);
4649: END IF;
4650: ROLLBACK TO DPP_Raise_OutBoundEvent;
4651: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR )
4652: THEN
4653: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
4654: END IF;
4655: Fnd_Msg_Pub.Count_AND_Get

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

4649: END IF;
4650: ROLLBACK TO DPP_Raise_OutBoundEvent;
4651: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR )
4652: THEN
4653: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
4654: END IF;
4655: Fnd_Msg_Pub.Count_AND_Get
4656: ( p_count => x_msg_count,
4657: p_data => x_msg_data,

Line 4655: Fnd_Msg_Pub.Count_AND_Get

4651: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR )
4652: THEN
4653: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
4654: END IF;
4655: Fnd_Msg_Pub.Count_AND_Get
4656: ( p_count => x_msg_count,
4657: p_data => x_msg_data,
4658: p_encoded => Fnd_Api.G_FALSE
4659: );

Line 5197: Fnd_Msg_Pub.Count_AND_Get

5193: EXCEPTION
5194: WHEN Fnd_Api.G_EXC_ERROR THEN
5195: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_EXCEPTION, 'dpp.plsql.' || L_FULL_NAME, 'DPP EXCEPTION G_EXC_ERROR');
5196: ROLLBACK TO dpp_create_txn;
5197: Fnd_Msg_Pub.Count_AND_Get
5198: ( p_count => l_msg_count,
5199: p_data => l_msg_data,
5200: p_encoded => Fnd_Api.G_FALSE
5201: );

Line 5205: Fnd_Msg_Pub.Count_AND_Get

5201: );
5202: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
5203: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_EXCEPTION, 'dpp.plsql.' || L_FULL_NAME, 'DPP EXCEPTION G_EXC_UNEXPECTED_ERROR');
5204: ROLLBACK TO dpp_create_txn;
5205: Fnd_Msg_Pub.Count_AND_Get
5206: ( p_count => l_msg_count,
5207: p_data => l_msg_data,
5208: p_encoded => Fnd_Api.G_FALSE
5209: );

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

5209: );
5210: WHEN OTHERS THEN
5211: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_EXCEPTION, 'dpp.plsql.' || L_FULL_NAME, 'DPP EXCEPTION OTHERS'||SQLERRM);
5212: ROLLBACK TO dpp_create_txn;
5213: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR )
5214: THEN
5215: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
5216: END IF;
5217: Fnd_Msg_Pub.Count_AND_Get

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

5211: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_EXCEPTION, 'dpp.plsql.' || L_FULL_NAME, 'DPP EXCEPTION OTHERS'||SQLERRM);
5212: ROLLBACK TO dpp_create_txn;
5213: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR )
5214: THEN
5215: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
5216: END IF;
5217: Fnd_Msg_Pub.Count_AND_Get
5218: ( p_count => l_msg_count,
5219: p_data => l_msg_data,

Line 5217: Fnd_Msg_Pub.Count_AND_Get

5213: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR )
5214: THEN
5215: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
5216: END IF;
5217: Fnd_Msg_Pub.Count_AND_Get
5218: ( p_count => l_msg_count,
5219: p_data => l_msg_data,
5220: p_encoded => Fnd_Api.G_FALSE
5221: );