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

Line 112: FND_MSG_PUB.initialize;

108: END IF;
109:
110: -- Initialize message list if p_init_msg_list is set to TRUE.
111: IF FND_API.to_Boolean(p_init_msg_list) THEN
112: FND_MSG_PUB.initialize;
113: END IF;
114:
115: -- Initialize API return status to success
116: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 200: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

196: END IF;
197: -- End of API body
198:
199: -- get message count and if count is 1, get message info.
200: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
201: p_count => x_msg_count,
202: p_data => x_msg_data);
203:
204: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 215: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

211: x_return_status := fnd_api.g_ret_sts_error;
212: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
213: print_debuginfo('Exception : ' || SQLERRM);
214: END IF;
215: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
216: p_count => x_msg_count,
217: p_data => x_msg_data);
218:
219:

Line 226: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

222: x_return_status := fnd_api.g_ret_sts_unexp_error;
223: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
224: print_debuginfo('Exception : ' || SQLERRM);
225: END IF;
226: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
227: p_count => x_msg_count,
228: p_data => x_msg_data);
229:
230:

Line 237: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);

233: x_return_status := fnd_api.g_ret_sts_unexp_error;
234: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
235: print_debuginfo('Exception : ' || SQLERRM);
236: END IF;
237: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);
238:
239: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
240: p_count => x_msg_count,
241: p_data => x_msg_data);

Line 239: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

235: print_debuginfo('Exception : ' || SQLERRM);
236: END IF;
237: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);
238:
239: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
240: p_count => x_msg_count,
241: p_data => x_msg_data);
242:
243:

Line 290: FND_MSG_PUB.initialize;

286: END IF;
287:
288: -- Initialize message list if p_init_msg_list is set to TRUE.
289: IF FND_API.to_Boolean(p_init_msg_list) THEN
290: FND_MSG_PUB.initialize;
291: END IF;
292:
293: -- Initialize API return status to success
294: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 352: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

348: END IF;
349: -- End of API body
350:
351: -- get message count and if count is 1, get message info.
352: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
353: p_count => x_msg_count,
354: p_data => x_msg_data);
355:
356: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 367: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

363: x_return_status := fnd_api.g_ret_sts_error;
364: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
365: print_debuginfo('Exception : ' || SQLERRM);
366: END IF;
367: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
368: p_count => x_msg_count,
369: p_data => x_msg_data);
370:
371:

Line 378: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

374: x_return_status := fnd_api.g_ret_sts_unexp_error;
375: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
376: print_debuginfo('Exception : ' || SQLERRM);
377: END IF;
378: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
379: p_count => x_msg_count,
380: p_data => x_msg_data);
381:
382:

Line 390: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);

386: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
387: print_debuginfo('Exception : ' || SQLERRM);
388:
389: END IF;
390: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);
391: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
392: p_count => x_msg_count,
393: p_data => x_msg_data);
394:

Line 391: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

387: print_debuginfo('Exception : ' || SQLERRM);
388:
389: END IF;
390: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);
391: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
392: p_count => x_msg_count,
393: p_data => x_msg_data);
394:
395:

Line 449: FND_MSG_PUB.initialize;

445: END IF;
446:
447: -- Initialize message list if p_init_msg_list is set to TRUE.
448: IF FND_API.to_Boolean(p_init_msg_list) THEN
449: FND_MSG_PUB.initialize;
450: END IF;
451:
452: -- Initialize API return status to success
453: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 483: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

479:
480: -- End of API body
481:
482: -- get message count and if count is 1, get message info.
483: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
484: p_count => x_msg_count,
485: p_data => x_msg_data);
486:
487: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 497: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

493: x_return_status := fnd_api.g_ret_sts_error;
494: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
495: print_debuginfo('Exception : ' || SQLERRM);
496: END IF;
497: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
498: p_count => x_msg_count,
499: p_data => x_msg_data);
500:
501:

Line 508: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

504: x_return_status := fnd_api.g_ret_sts_unexp_error;
505: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
506: print_debuginfo('Exception : ' || SQLERRM);
507: END IF;
508: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
509: p_count => x_msg_count,
510: p_data => x_msg_data);
511:
512:

Line 519: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);

515: x_return_status := fnd_api.g_ret_sts_unexp_error;
516: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
517: print_debuginfo('Exception : ' || SQLERRM);
518: END IF;
519: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);
520:
521: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
522: p_count => x_msg_count,
523: p_data => x_msg_data);

Line 521: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

517: print_debuginfo('Exception : ' || SQLERRM);
518: END IF;
519: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);
520:
521: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
522: p_count => x_msg_count,
523: p_data => x_msg_data);
524:
525: END set_bank_end_date;

Line 573: FND_MSG_PUB.initialize;

569: END IF;
570:
571: -- Initialize message list if p_init_msg_list is set to TRUE.
572: IF FND_API.to_Boolean(p_init_msg_list) THEN
573: FND_MSG_PUB.initialize;
574: END IF;
575:
576: -- Initialize API return status to success
577: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 600: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

596: END IF;
597: -- End of API body
598:
599: -- get message count and if count is 1, get message info.
600: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
601: p_count => x_msg_count,
602: p_data => x_msg_data);
603:
604: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 613: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

609: x_return_status := fnd_api.g_ret_sts_error;
610: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
611: print_debuginfo('Exception : ' || SQLERRM);
612: END IF;
613: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
614: p_count => x_msg_count,
615: p_data => x_msg_data);
616:
617:

Line 623: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

619: x_return_status := fnd_api.g_ret_sts_unexp_error;
620: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
621: print_debuginfo('Exception : ' || SQLERRM);
622: END IF;
623: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
624: p_count => x_msg_count,
625: p_data => x_msg_data);
626:
627:

Line 634: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);

630: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
631: print_debuginfo('Exception : ' || SQLERRM);
632:
633: END IF;
634: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);
635:
636: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
637: p_count => x_msg_count,
638: p_data => x_msg_data);

Line 636: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

632:
633: END IF;
634: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);
635:
636: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
637: p_count => x_msg_count,
638: p_data => x_msg_data);
639:
640: END check_bank_exist;

Line 686: FND_MSG_PUB.initialize;

682: END IF;
683:
684: -- Initialize message list if p_init_msg_list is set to TRUE.
685: IF FND_API.to_Boolean(p_init_msg_list) THEN
686: FND_MSG_PUB.initialize;
687: END IF;
688:
689: -- Initialize API return status to success
690: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 755: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

751: END IF;
752: -- End of API body
753:
754: -- get message count and if count is 1, get message info.
755: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
756: p_count => x_msg_count,
757: p_data => x_msg_data);
758:
759: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 770: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

766: x_return_status := fnd_api.g_ret_sts_error;
767: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
768: print_debuginfo('Exception : ' || SQLERRM);
769: END IF;
770: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
771: p_count => x_msg_count,
772: p_data => x_msg_data);
773:
774:

Line 781: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

777: x_return_status := fnd_api.g_ret_sts_unexp_error;
778: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
779: print_debuginfo('Exception : ' || SQLERRM);
780: END IF;
781: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
782: p_count => x_msg_count,
783: p_data => x_msg_data);
784:
785:

Line 793: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);

789: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
790: print_debuginfo('Exception : ' || SQLERRM);
791:
792: END IF;
793: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);
794: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
795: p_count => x_msg_count,
796: p_data => x_msg_data);
797:

Line 794: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

790: print_debuginfo('Exception : ' || SQLERRM);
791:
792: END IF;
793: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);
794: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
795: p_count => x_msg_count,
796: p_data => x_msg_data);
797:
798: END create_ext_bank_branch;

Line 861: FND_MSG_PUB.initialize;

857: END IF;
858:
859: -- Initialize message list if p_init_msg_list is set to TRUE.
860: IF FND_API.to_Boolean(p_init_msg_list) THEN
861: FND_MSG_PUB.initialize;
862: END IF;
863:
864: -- Initialize API return status to success
865: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 899: fnd_msg_pub.add;

895: IF (l_rfc_identifier_ovn <> p_ext_bank_branch_rec.rfc_object_version_number) THEN
896:
897: fnd_message.set_name('IBY', 'IBY_DATA_VERSION_ERROR');
898:
899: fnd_msg_pub.add;
900: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
901: print_debuginfo('Object Version Number mismatch');
902: END IF;
903: END IF;

Line 921: fnd_msg_pub.add;

917: print_debuginfo('Current RFC Identifier OVN ' || l_eft_record_ovn);
918: END IF;
919: IF (l_eft_record_ovn <> p_ext_bank_branch_rec.eft_object_version_number) THEN
920: fnd_message.set_name('IBY', 'IBY_DATA_VERSION_ERROR');
921: fnd_msg_pub.add;
922: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
923: print_debuginfo('Object Version Number mismatch');
924: END IF;
925: END IF;

Line 985: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

981: END IF;
982: -- End of API Body
983:
984: -- get message count and if count is 1, get message info.
985: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
986: p_count => x_msg_count,
987: p_data => x_msg_data);
988:
989: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 1000: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

996: x_return_status := fnd_api.g_ret_sts_error;
997: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
998: print_debuginfo('Exception : ' || SQLERRM);
999: END IF;
1000: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1001: p_count => x_msg_count,
1002: p_data => x_msg_data);
1003:
1004:

Line 1011: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

1007: x_return_status := fnd_api.g_ret_sts_unexp_error;
1008: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1009: print_debuginfo('Exception : ' || SQLERRM);
1010: END IF;
1011: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1012: p_count => x_msg_count,
1013: p_data => x_msg_data);
1014:
1015:

Line 1023: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);

1019: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1020: print_debuginfo('Exception : ' || SQLERRM);
1021:
1022: END IF;
1023: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);
1024: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1025: p_count => x_msg_count,
1026: p_data => x_msg_data);
1027:

Line 1024: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

1020: print_debuginfo('Exception : ' || SQLERRM);
1021:
1022: END IF;
1023: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);
1024: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1025: p_count => x_msg_count,
1026: p_data => x_msg_data);
1027:
1028:

Line 1082: FND_MSG_PUB.initialize;

1078: END IF;
1079:
1080: -- Initialize message list if p_init_msg_list is set to TRUE.
1081: IF FND_API.to_Boolean(p_init_msg_list) THEN
1082: FND_MSG_PUB.initialize;
1083: END IF;
1084:
1085: -- Initialize API return status to success
1086: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1116: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

1112:
1113: -- End of API body
1114:
1115: -- get message count and if count is 1, get message info.
1116: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1117: p_count => x_msg_count,
1118: p_data => x_msg_data);
1119:
1120: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 1130: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

1126: x_return_status := fnd_api.g_ret_sts_error;
1127: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1128: print_debuginfo('Exception : ' || SQLERRM);
1129: END IF;
1130: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1131: p_count => x_msg_count,
1132: p_data => x_msg_data);
1133:
1134:

Line 1141: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

1137: x_return_status := fnd_api.g_ret_sts_unexp_error;
1138: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1139: print_debuginfo('Exception : ' || SQLERRM);
1140: END IF;
1141: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1142: p_count => x_msg_count,
1143: p_data => x_msg_data);
1144:
1145:

Line 1153: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);

1149: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1150: print_debuginfo('Exception : ' || SQLERRM);
1151:
1152: END IF;
1153: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);
1154: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1155: p_count => x_msg_count,
1156: p_data => x_msg_data);
1157:

Line 1154: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

1150: print_debuginfo('Exception : ' || SQLERRM);
1151:
1152: END IF;
1153: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);
1154: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1155: p_count => x_msg_count,
1156: p_data => x_msg_data);
1157:
1158:

Line 1208: FND_MSG_PUB.initialize;

1204: END IF;
1205:
1206: -- Initialize message list if p_init_msg_list is set to TRUE.
1207: IF FND_API.to_Boolean(p_init_msg_list) THEN
1208: FND_MSG_PUB.initialize;
1209: END IF;
1210:
1211: -- Initialize API return status to success
1212: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1235: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

1231: END IF;
1232: -- End of API body
1233:
1234: -- get message count and if count is 1, get message info.
1235: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1236: p_count => x_msg_count,
1237: p_data => x_msg_data);
1238:
1239: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 1249: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

1245: x_return_status := fnd_api.g_ret_sts_error;
1246: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1247: print_debuginfo('Exception : ' || SQLERRM);
1248: END IF;
1249: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1250: p_count => x_msg_count,
1251: p_data => x_msg_data);
1252:
1253:

Line 1259: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

1255: x_return_status := fnd_api.g_ret_sts_unexp_error;
1256: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1257: print_debuginfo('Exception : ' || SQLERRM);
1258: END IF;
1259: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1260: p_count => x_msg_count,
1261: p_data => x_msg_data);
1262:
1263:

Line 1269: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);

1265: x_return_status := fnd_api.g_ret_sts_unexp_error;
1266: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1267: print_debuginfo('Exception : ' || SQLERRM);
1268: END IF;
1269: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);
1270:
1271: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1272: p_count => x_msg_count,
1273: p_data => x_msg_data);

Line 1271: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

1267: print_debuginfo('Exception : ' || SQLERRM);
1268: END IF;
1269: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);
1270:
1271: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1272: p_count => x_msg_count,
1273: p_data => x_msg_data);
1274:
1275:

Line 1377: FND_MSG_PUB.initialize;

1373: END IF;
1374:
1375: -- Initialize message list if p_init_msg_list is set to TRUE.
1376: IF FND_API.to_Boolean(p_init_msg_list) THEN
1377: FND_MSG_PUB.initialize;
1378: END IF;
1379:
1380: -- Initialize API return status to success
1381: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1445: fnd_msg_pub.add;

1441: OPEN c_branch(p_ext_bank_acct_rec.branch_id);
1442: FETCH c_branch INTO l_branch_number;
1443: IF c_branch%NOTFOUND THEN
1444: fnd_message.set_name('IBY', 'IBY_API_NO_BRANCH');
1445: fnd_msg_pub.add;
1446: x_return_status := fnd_api.g_ret_sts_error;
1447: RAISE fnd_api.g_exc_error;
1448: ELSE
1449: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 1482: fnd_msg_pub.add;

1478: END IF;
1479: IF ((not x_return_status = fnd_api.g_ret_sts_success) OR
1480: (not l_dup_acct_id is null)) THEN
1481: fnd_message.set_name('IBY', 'IBY_UNIQ_ACCOUNT');
1482: fnd_msg_pub.add;
1483: /*OPEN c_supplier(l_dup_acct_id);
1484: FETCH c_supplier INTO l_party_id;
1485: IF l_party_id IS NOT NULL THEN
1486: SELECT vendor_name, segment1 INTO l_supplier_name, l_supplier_number FROM ap_suppliers WHERE party_id = l_party_id;

Line 1490: fnd_msg_pub.add;

1486: SELECT vendor_name, segment1 INTO l_supplier_name, l_supplier_number FROM ap_suppliers WHERE party_id = l_party_id;
1487: fnd_message.set_name('IBY', 'IBY_UNIQ_ACCOUNT_SUPPLIER');
1488: fnd_message.set_Token('SUPPLIER',l_supplier_name);
1489: fnd_message.set_Token('SUPPLIERNUMBER',l_supplier_number);
1490: fnd_msg_pub.add;
1491: END IF;
1492: CLOSE c_supplier;*/
1493: l_org_id := find_assignment_OU(l_dup_acct_id);
1494: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 1501: fnd_msg_pub.add;

1497: IF l_org_id <> -1 THEN
1498: select name into l_org_name from hr_operating_units where organization_id = l_org_id;
1499: fnd_message.set_name('IBY', 'IBY_UNIQ_ACCOUNT_OU');
1500: fnd_message.set_Token('OU', l_org_name);
1501: fnd_msg_pub.add;
1502: END IF;
1503: x_return_status := fnd_api.g_ret_sts_error;
1504: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1505: print_debuginfo('Error : Duplicate Bank Account');

Line 1512: fnd_msg_pub.delete_msg;

1508: END IF;
1509:
1510: -- country specific validation API call here.
1511: -- delete the message as CE using message count for error
1512: fnd_msg_pub.delete_msg;
1513: x_msg_count:=0;
1514:
1515: /*
1516: * Fix for bug 5413958:

Line 1638: fnd_msg_pub.add;

1634: END IF;
1635: x_return_status := fnd_api.g_ret_sts_error;
1636: fnd_message.set_name('IBY', 'IBY_CUST_BANK_ACCT_VAL');
1637: fnd_message.set_Token('ERROR_MESSAGE',l_error_msg);
1638: fnd_msg_pub.add;
1639: RETURN;
1640: END IF;
1641:
1642: Get_Mask_Settings(lx_mask_option,lx_unmask_len);

Line 1852: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

1848: END IF;
1849: END IF;
1850:
1851: -- get message count and if count is 1, get message info.
1852: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1853: p_count => x_msg_count,
1854: p_data => x_msg_data);
1855:
1856: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 1868: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

1864: x_return_status := fnd_api.g_ret_sts_error;
1865: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1866: print_debuginfo('Exception : ' || SQLERRM);
1867: END IF;
1868: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1869: p_count => x_msg_count,
1870: p_data => x_msg_data);
1871:
1872:

Line 1879: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

1875: x_return_status := fnd_api.g_ret_sts_unexp_error;
1876: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1877: print_debuginfo('Exception : ' || SQLERRM);
1878: END IF;
1879: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1880: p_count => x_msg_count,
1881: p_data => x_msg_data);
1882:
1883:

Line 1888: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);

1884: WHEN OTHERS THEN
1885: ROLLBACK TO create_ext_bank_acct_pub;
1886:
1887: x_return_status := fnd_api.g_ret_sts_unexp_error;
1888: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);
1889:
1890: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1891: print_debuginfo('Exception : ' || SQLERRM);
1892: END IF;

Line 1893: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

1889:
1890: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1891: print_debuginfo('Exception : ' || SQLERRM);
1892: END IF;
1893: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1894: p_count => x_msg_count,
1895: p_data => x_msg_data);
1896:
1897: END create_ext_bank_acct;

Line 1989: fnd_msg_pub.add;

1985: OPEN c_branch(p_ext_bank_acct_rec.branch_id);
1986: FETCH c_branch INTO l_branch_number;
1987: IF c_branch%NOTFOUND THEN
1988: fnd_message.set_name('IBY', 'IBY_API_NO_BRANCH');
1989: fnd_msg_pub.add;
1990: x_return_status := fnd_api.g_ret_sts_error;
1991: RAISE fnd_api.g_exc_error;
1992: ELSE
1993: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 2161: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

2157: x_return_status := fnd_api.g_ret_sts_error;
2158: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2159: print_debuginfo('Exception : ' || SQLERRM);
2160: END IF;
2161: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2162: p_count => x_msg_count,
2163: p_data => x_msg_data);
2164: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2165: ROLLBACK TO create_ext_bank_acct_thru_api;

Line 2170: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

2166: x_return_status := fnd_api.g_ret_sts_unexp_error;
2167: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2168: print_debuginfo('Exception : ' || SQLERRM);
2169: END IF;
2170: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2171: p_count => x_msg_count,
2172: p_data => x_msg_data);
2173: WHEN L_INVALID_SUPPLIER_ID THEN
2174: ROLLBACK TO create_ext_bank_acct_thru_api;

Line 2179: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

2175: x_return_status := FND_API.G_RET_STS_ERROR ;
2176: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2177: print_debuginfo('Exception : invalid supplier id');
2178: END IF;
2179: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2180: p_count => x_msg_count,
2181: p_data => x_msg_data);
2182: WHEN L_INVALID_PARTY_SITE THEN
2183: ROLLBACK TO create_ext_bank_acct_thru_api;

Line 2188: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

2184: x_return_status := FND_API.G_RET_STS_ERROR ;
2185: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2186: print_debuginfo('Exception : invalid party site id');
2187: END IF;
2188: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2189: p_count => x_msg_count,
2190: p_data => x_msg_data);
2191: WHEN L_INVALID_AO THEN
2192: ROLLBACK TO create_ext_bank_acct_thru_api;

Line 2197: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

2193: x_return_status := FND_API.G_RET_STS_ERROR ;
2194: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2195: print_debuginfo('Exception : invalid combination of party site id and org id');
2196: END IF;
2197: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2198: p_count => x_msg_count,
2199: p_data => x_msg_data);
2200: WHEN L_INVALID_ASSOCIATION_LEVEL THEN
2201: ROLLBACK TO create_ext_bank_acct_thru_api;

Line 2206: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

2202: x_return_status := FND_API.G_RET_STS_ERROR ;
2203: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2204: print_debuginfo('Exception : invalid Association level');
2205: END IF;
2206: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2207: p_count => x_msg_count,
2208: p_data => x_msg_data);
2209: WHEN OTHERS THEN
2210: ROLLBACK TO create_ext_bank_acct_thru_api;

Line 2212: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module, null);

2208: p_data => x_msg_data);
2209: WHEN OTHERS THEN
2210: ROLLBACK TO create_ext_bank_acct_thru_api;
2211: x_return_status := fnd_api.g_ret_sts_unexp_error;
2212: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module, null);
2213: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2214: print_debuginfo('Exception : ' || SQLERRM);
2215: END IF;
2216: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

Line 2216: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

2212: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module, null);
2213: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2214: print_debuginfo('Exception : ' || SQLERRM);
2215: END IF;
2216: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2217: p_count => x_msg_count,
2218: p_data => x_msg_data);
2219:
2220: END create_ext_bank_acct;

Line 2364: FND_MSG_PUB.initialize;

2360: END IF;
2361:
2362: -- Initialize message list if p_init_msg_list is set to TRUE.
2363: IF FND_API.to_Boolean(p_init_msg_list) THEN
2364: FND_MSG_PUB.initialize;
2365: END IF;
2366:
2367: -- Initialize API return status to success
2368: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2396: fnd_msg_pub.add;

2392: l_old_masked_iban,
2393: l_ba_elec_segment_id;
2394: IF c_ovn%NOTFOUND THEN
2395: fnd_message.set_name('IBY', 'IBY_API_NO_EXT_BANK_ACCT');
2396: fnd_msg_pub.add;
2397: x_return_status := fnd_api.g_ret_sts_error;
2398: CLOSE c_ovn;
2399: RAISE fnd_api.g_exc_error;
2400: END IF;

Line 2408: fnd_msg_pub.add;

2404:
2405: END IF;
2406: IF l_old_ovn <> p_ext_bank_acct_rec.object_version_number THEN
2407: fnd_message.set_name('IBY', 'IBY_DATA_VERSION_ERROR');
2408: fnd_msg_pub.add;
2409: x_return_status := fnd_api.g_ret_sts_error;
2410: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2411: print_debuginfo('Error: Object Version Number Mismatch');
2412: END IF;

Line 2428: fnd_msg_pub.add;

2424: p_ext_bank_acct_rec.bank_account_id);
2425: FETCH uniq_check into l_count;
2426: IF (l_count > 1) THEN
2427: fnd_message.set_name('IBY', 'IBY_UNIQ_ACCOUNT');
2428: fnd_msg_pub.add;
2429: x_return_status := fnd_api.g_ret_sts_error;
2430: RAISE fnd_api.g_exc_error;
2431: END IF;
2432: CLOSE uniq_check;

Line 2443: fnd_msg_pub.add;

2439: END IF;
2440: IF ((not x_return_status = fnd_api.g_ret_sts_success) OR
2441: (not l_dup_acct_id is null)) THEN
2442: fnd_message.set_name('IBY', 'IBY_UNIQ_ACCOUNT');
2443: fnd_msg_pub.add;
2444: x_return_status := fnd_api.g_ret_sts_error;
2445: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2446: print_debuginfo('Error : Duplicate Bank Account');
2447: END IF;

Line 2680: fnd_msg_pub.add;

2676: END IF;
2677: IF ((not x_return_status = fnd_api.g_ret_sts_success) OR
2678: (not l_dup_acct_id is null)) THEN
2679: fnd_message.set_name('IBY', 'IBY_UNIQ_ACCOUNT');
2680: fnd_msg_pub.add;
2681: /*OPEN c_supplier(l_dup_acct_id);
2682: FETCH c_supplier INTO l_party_id;
2683: IF l_party_id IS NOT NULL THEN
2684: SELECT vendor_name, segment1 INTO l_supplier_name, l_supplier_number FROM ap_suppliers WHERE party_id = l_party_id;

Line 2688: fnd_msg_pub.add;

2684: SELECT vendor_name, segment1 INTO l_supplier_name, l_supplier_number FROM ap_suppliers WHERE party_id = l_party_id;
2685: fnd_message.set_name('IBY', 'IBY_UNIQ_ACCOUNT_SUPPLIER');
2686: fnd_message.set_Token('SUPPLIER',l_supplier_name);
2687: fnd_message.set_Token('SUPPLIERNUMBER',l_supplier_number);
2688: fnd_msg_pub.add;
2689: END IF;
2690: CLOSE c_supplier;*/
2691: l_org_id := find_assignment_OU(l_dup_acct_id);
2692: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 2699: fnd_msg_pub.add;

2695: IF l_org_id <> -1 THEN
2696: select name into l_org_name from hr_operating_units where organization_id = l_org_id;
2697: fnd_message.set_name('IBY', 'IBY_UNIQ_ACCOUNT_OU');
2698: fnd_message.set_Token('OU',l_org_name);
2699: fnd_msg_pub.add;
2700: END IF;
2701: x_return_status := fnd_api.g_ret_sts_error;
2702: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2703: print_debuginfo('Error : Duplicate Bank Account');

Line 2710: fnd_msg_pub.delete_msg;

2706: END IF;
2707:
2708: -- country specific validation API call here.
2709: -- delete the message as CE using message count for error
2710: fnd_msg_pub.delete_msg;
2711: x_msg_count:=0;
2712:
2713:
2714: --Get_Mask_Settings(lx_mask_option,lx_unmask_len);

Line 2915: fnd_msg_pub.add;

2911: END IF;
2912: x_return_status := fnd_api.g_ret_sts_error;
2913: fnd_message.set_name('IBY', 'IBY_CUST_BANK_ACCT_VAL');
2914: fnd_message.set_Token('ERROR_MESSAGE',l_error_msg);
2915: fnd_msg_pub.add;
2916: RETURN;
2917: END IF;
2918:
2919:

Line 2993: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

2989:
2990: -- End of API body
2991:
2992: -- get message count and if count is 1, get message info.
2993: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2994: p_count => x_msg_count,
2995: p_data => x_msg_data);
2996:
2997: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 3005: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

3001: EXCEPTION
3002: WHEN fnd_api.g_exc_error THEN
3003: ROLLBACK TO update_ext_bank_acct_pub;
3004: x_return_status := fnd_api.g_ret_sts_error;
3005: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3006: p_count => x_msg_count,
3007: p_data => x_msg_data);
3008:
3009:

Line 3013: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

3009:
3010: WHEN fnd_api.g_exc_unexpected_error THEN
3011: ROLLBACK TO update_ext_bank_acct_pub;
3012: x_return_status := fnd_api.g_ret_sts_unexp_error;
3013: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3014: p_count => x_msg_count,
3015: p_data => x_msg_data);
3016:
3017:

Line 3021: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);

3017:
3018: WHEN OTHERS THEN
3019: ROLLBACK TO update_ext_bank_acct_pub;
3020: x_return_status := fnd_api.g_ret_sts_unexp_error;
3021: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);
3022:
3023: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3024: p_count => x_msg_count,
3025: p_data => x_msg_data);

Line 3023: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

3019: ROLLBACK TO update_ext_bank_acct_pub;
3020: x_return_status := fnd_api.g_ret_sts_unexp_error;
3021: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);
3022:
3023: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3024: p_count => x_msg_count,
3025: p_data => x_msg_data);
3026:
3027:

Line 3148: FND_MSG_PUB.initialize;

3144: END IF;
3145:
3146: -- Initialize message list if p_init_msg_list is set to TRUE.
3147: IF FND_API.to_Boolean(p_init_msg_list) THEN
3148: FND_MSG_PUB.initialize;
3149: END IF;
3150:
3151: -- Initialize API return status to success
3152: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3217: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

3213:
3214: -- End of API body
3215:
3216: -- get message count and if count is 1, get message info.
3217: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3218: p_count => x_msg_count,
3219: p_data => x_msg_data);
3220:
3221: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 3230: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

3226: x_return_status := fnd_api.g_ret_sts_error;
3227: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3228: print_debuginfo('Exception : ' || SQLERRM);
3229: END IF;
3230: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3231: p_count => x_msg_count,
3232: p_data => x_msg_data);
3233:
3234:

Line 3240: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

3236: x_return_status := fnd_api.g_ret_sts_unexp_error;
3237: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3238: print_debuginfo('Exception : ' || SQLERRM);
3239: END IF;
3240: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3241: p_count => x_msg_count,
3242: p_data => x_msg_data);
3243:
3244:

Line 3250: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);

3246: x_return_status := fnd_api.g_ret_sts_unexp_error;
3247: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3248: print_debuginfo('Exception : ' || SQLERRM);
3249: END IF;
3250: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);
3251:
3252: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3253: p_count => x_msg_count,
3254: p_data => x_msg_data);

Line 3252: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

3248: print_debuginfo('Exception : ' || SQLERRM);
3249: END IF;
3250: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);
3251:
3252: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3253: p_count => x_msg_count,
3254: p_data => x_msg_data);
3255:
3256:

Line 3305: FND_MSG_PUB.initialize;

3301: END IF;
3302:
3303: -- Initialize message list if p_init_msg_list is set to TRUE.
3304: IF FND_API.to_Boolean(p_init_msg_list) THEN
3305: FND_MSG_PUB.initialize;
3306: END IF;
3307:
3308: -- Initialize API return status to success
3309: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3330: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

3326:
3327: -- End of API body
3328:
3329: -- get message count and if count is 1, get message info.
3330: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3331: p_count => x_msg_count,
3332: p_data => x_msg_data);
3333:
3334: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 3344: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

3340: x_return_status := fnd_api.g_ret_sts_error;
3341: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3342: print_debuginfo('Exception : ' || SQLERRM);
3343: END IF;
3344: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3345: p_count => x_msg_count,
3346: p_data => x_msg_data);
3347:
3348:

Line 3355: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

3351: x_return_status := fnd_api.g_ret_sts_unexp_error;
3352: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3353: print_debuginfo('Exception : ' || SQLERRM);
3354: END IF;
3355: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3356: p_count => x_msg_count,
3357: p_data => x_msg_data);
3358:
3359:

Line 3366: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);

3362: x_return_status := fnd_api.g_ret_sts_unexp_error;
3363: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3364: print_debuginfo('Exception : ' || SQLERRM);
3365: END IF;
3366: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);
3367:
3368: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3369: p_count => x_msg_count,
3370: p_data => x_msg_data);

Line 3368: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

3364: print_debuginfo('Exception : ' || SQLERRM);
3365: END IF;
3366: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);
3367:
3368: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3369: p_count => x_msg_count,
3370: p_data => x_msg_data);
3371:
3372:

Line 3421: FND_MSG_PUB.initialize;

3417: END IF;
3418:
3419: -- Initialize message list if p_init_msg_list is set to TRUE.
3420: IF FND_API.to_Boolean(p_init_msg_list) THEN
3421: FND_MSG_PUB.initialize;
3422: END IF;
3423:
3424: -- Initialize API return status to success
3425: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3440: fnd_msg_pub.add;

3436: IF (p_end_date IS NOT NULL AND p_start_date > p_end_date) THEN
3437: -- throw exception if start date
3438: -- exceeds end_date
3439: fnd_message.set_name('IBY', 'IBY_START_END_DATE_BAD');
3440: fnd_msg_pub.add;
3441: RAISE fnd_api.g_exc_error;
3442: END IF;
3443:
3444: -- update bank account dates

Line 3462: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

3458:
3459: -- End of API body
3460:
3461: -- get message count and if count is 1, get message info.
3462: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3463: p_count => x_msg_count,
3464: p_data => x_msg_data);
3465:
3466: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 3474: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

3470: EXCEPTION
3471: WHEN fnd_api.g_exc_error THEN
3472: ROLLBACK TO set_ext_bank_acct_dates_pub;
3473: x_return_status := fnd_api.g_ret_sts_error;
3474: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3475: p_count => x_msg_count,
3476: p_data => x_msg_data);
3477:
3478:

Line 3482: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

3478:
3479: WHEN fnd_api.g_exc_unexpected_error THEN
3480: ROLLBACK TO set_ext_bank_acct_dates_pub;
3481: x_return_status := fnd_api.g_ret_sts_unexp_error;
3482: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3483: p_count => x_msg_count,
3484: p_data => x_msg_data);
3485:
3486:

Line 3490: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);

3486:
3487: WHEN OTHERS THEN
3488: ROLLBACK TO set_ext_bank_acct_dates_pub;
3489: x_return_status := fnd_api.g_ret_sts_unexp_error;
3490: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);
3491: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3492: p_count => x_msg_count,
3493: p_data => x_msg_data);
3494:

Line 3491: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

3487: WHEN OTHERS THEN
3488: ROLLBACK TO set_ext_bank_acct_dates_pub;
3489: x_return_status := fnd_api.g_ret_sts_unexp_error;
3490: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);
3491: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3492: p_count => x_msg_count,
3493: p_data => x_msg_data);
3494:
3495:

Line 3640: FND_MSG_PUB.initialize;

3636: END IF;
3637:
3638: -- Initialize message list if p_init_msg_list is set to TRUE.
3639: IF FND_API.to_Boolean(p_init_msg_list) THEN
3640: FND_MSG_PUB.initialize;
3641: END IF;
3642:
3643: -- Initialize API return status to success
3644: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3703: -- fnd_msg_pub.add;

3699: END IF;
3700:
3701: IF (SQL%NOTFOUND) THEN
3702: -- fnd_message.set_name('IBY', 'IBY_EXT_ACCT_NOT_EXIST');
3703: -- fnd_msg_pub.add;
3704: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3705: print_debuginfo('External Account does not exist ');
3706: END IF;
3707: END IF;

Line 3716: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

3712: print_debuginfo('x_end_date:' || x_end_date);
3713: END IF;
3714:
3715: -- get message count and if count is 1, get message info.
3716: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3717: p_count => x_msg_count,
3718: p_data => x_msg_data);
3719:
3720: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 3730: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

3726: x_return_status := fnd_api.g_ret_sts_error;
3727: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3728: print_debuginfo('Exception : ' || SQLERRM);
3729: END IF;
3730: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3731: p_count => x_msg_count,
3732: p_data => x_msg_data);
3733:
3734:

Line 3740: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

3736: x_return_status := fnd_api.g_ret_sts_unexp_error;
3737: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3738: print_debuginfo('Exception : ' || SQLERRM);
3739: END IF;
3740: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3741: p_count => x_msg_count,
3742: p_data => x_msg_data);
3743:
3744:

Line 3750: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);

3746: x_return_status := fnd_api.g_ret_sts_unexp_error;
3747: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3748: print_debuginfo('Exception : ' || SQLERRM);
3749: END IF;
3750: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);
3751:
3752: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3753: p_count => x_msg_count,
3754: p_data => x_msg_data);

Line 3752: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

3748: print_debuginfo('Exception : ' || SQLERRM);
3749: END IF;
3750: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);
3751:
3752: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3753: p_count => x_msg_count,
3754: p_data => x_msg_data);
3755:
3756:

Line 3879: FND_MSG_PUB.initialize;

3875: END IF;
3876:
3877: -- Initialize message list if p_init_msg_list is set to TRUE.
3878: IF FND_API.to_Boolean(p_init_msg_list) THEN
3879: FND_MSG_PUB.initialize;
3880: END IF;
3881:
3882: -- Initialize API return status to success
3883: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3934: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

3930: RETURNING INTERMEDIARY_ACCT_ID INTO x_intermediary_acct_id;
3931:
3932:
3933: -- get message count and if count is 1, get message info.
3934: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3935: p_count => x_msg_count,
3936: p_data => x_msg_data);
3937:
3938: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 3947: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

3943: EXCEPTION
3944: WHEN fnd_api.g_exc_error THEN
3945: ROLLBACK TO create_intermediary_acct_pub;
3946: x_return_status := fnd_api.g_ret_sts_error;
3947: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3948: p_count => x_msg_count,
3949: p_data => x_msg_data);
3950:
3951:

Line 3955: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

3951:
3952: WHEN fnd_api.g_exc_unexpected_error THEN
3953: ROLLBACK TO create_intermediary_acct_pub;
3954: x_return_status := fnd_api.g_ret_sts_unexp_error;
3955: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3956: p_count => x_msg_count,
3957: p_data => x_msg_data);
3958:
3959:

Line 3966: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);

3962: x_return_status := fnd_api.g_ret_sts_unexp_error;
3963: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3964: print_debuginfo('Exception : ' || SQLERRM);
3965: END IF;
3966: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);
3967:
3968: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3969: p_count => x_msg_count,
3970: p_data => x_msg_data);

Line 3968: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

3964: print_debuginfo('Exception : ' || SQLERRM);
3965: END IF;
3966: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);
3967:
3968: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3969: p_count => x_msg_count,
3970: p_data => x_msg_data);
3971:
3972:

Line 4027: FND_MSG_PUB.initialize;

4023: END IF;
4024:
4025: -- Initialize message list if p_init_msg_list is set to TRUE.
4026: IF FND_API.to_Boolean(p_init_msg_list) THEN
4027: FND_MSG_PUB.initialize;
4028: END IF;
4029:
4030: -- Initialize API return status to success
4031: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 4044: fnd_msg_pub.add;

4040: OPEN c_ovn;
4041: FETCH c_ovn INTO l_old_ovn;
4042: IF c_ovn%NOTFOUND THEN
4043: fnd_message.set_name('IBY', 'IBY_API_NO_INTERMEDIARY_ACCT');
4044: fnd_msg_pub.add;
4045: x_return_status := fnd_api.g_ret_sts_error;
4046: CLOSE c_ovn;
4047: RAISE fnd_api.g_exc_error;
4048: END IF;

Line 4053: fnd_msg_pub.add;

4049: CLOSE c_ovn;
4050:
4051: IF l_old_ovn > p_intermed_acct_rec.object_version_number THEN
4052: fnd_message.set_name('IBY', 'IBY_DATA_VERSION_ERROR');
4053: fnd_msg_pub.add;
4054: x_return_status := fnd_api.g_ret_sts_error;
4055: RAISE fnd_api.g_exc_error;
4056: END IF;
4057:

Line 4079: fnd_msg_pub.add;

4075: RETURNING object_version_number INTO p_intermed_acct_rec.object_version_number;
4076:
4077: IF (SQL%NOTFOUND) THEN
4078: fnd_message.set_name('IBY', 'IBY_API_NO_INTERMEDIARY_ACCT');
4079: fnd_msg_pub.add;
4080: x_return_status := fnd_api.g_ret_sts_error;
4081: RAISE fnd_api.g_exc_error;
4082: END IF;
4083:

Line 4087: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

4083:
4084: -- END of API
4085:
4086: -- get message count and if count is 1, get message info.
4087: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4088: p_count => x_msg_count,
4089: p_data => x_msg_data);
4090:
4091: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 4099: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

4095: EXCEPTION
4096: WHEN fnd_api.g_exc_error THEN
4097: ROLLBACK TO update_intermediary_bank_acct;
4098: x_return_status := fnd_api.g_ret_sts_error;
4099: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4100: p_count => x_msg_count,
4101: p_data => x_msg_data);
4102:
4103:

Line 4107: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

4103:
4104: WHEN fnd_api.g_exc_unexpected_error THEN
4105: ROLLBACK TO update_intermediary_bank_acct;
4106: x_return_status := fnd_api.g_ret_sts_unexp_error;
4107: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4108: p_count => x_msg_count,
4109: p_data => x_msg_data);
4110:
4111:

Line 4115: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);

4111:
4112: WHEN OTHERS THEN
4113: ROLLBACK TO update_intermediary_bank_acct;
4114: x_return_status := fnd_api.g_ret_sts_unexp_error;
4115: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);
4116:
4117: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4118: p_count => x_msg_count,
4119: p_data => x_msg_data);

Line 4117: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

4113: ROLLBACK TO update_intermediary_bank_acct;
4114: x_return_status := fnd_api.g_ret_sts_unexp_error;
4115: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);
4116:
4117: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4118: p_count => x_msg_count,
4119: p_data => x_msg_data);
4120:
4121: END update_intermediary_acct;

Line 4188: FND_MSG_PUB.initialize;

4184: END IF;
4185:
4186: -- Initialize message list if p_init_msg_list is set to TRUE.
4187: IF FND_API.to_Boolean(p_init_msg_list) THEN
4188: FND_MSG_PUB.initialize;
4189: END IF;
4190:
4191: -- Initialize API return status to success
4192: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 4205: fnd_msg_pub.add;

4201: CLOSE uniq_check;
4202:
4203: IF (l_count > 0) THEN
4204: fnd_message.set_name('IBY', 'IBY_ACCT_OWNER_EXISTS');
4205: fnd_msg_pub.add;
4206: x_return_status := fnd_api.g_ret_sts_error;
4207: RETURN;
4208: END IF;
4209:

Line 4252: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

4248: 1.0
4249: ) RETURNING ACCOUNT_OWNER_ID INTO x_joint_acct_owner_id;
4250:
4251: -- get message count and if count is 1, get message info.
4252: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4253: p_count => x_msg_count,
4254: p_data => x_msg_data);
4255:
4256: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 4267: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

4263: x_return_status := fnd_api.g_ret_sts_error;
4264: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
4265: print_debuginfo('Exception : ' || SQLERRM);
4266: END IF;
4267: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4268: p_count => x_msg_count,
4269: p_data => x_msg_data);
4270:
4271:

Line 4278: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

4274: x_return_status := fnd_api.g_ret_sts_unexp_error;
4275: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
4276: print_debuginfo('Exception : ' || SQLERRM);
4277: END IF;
4278: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4279: p_count => x_msg_count,
4280: p_data => x_msg_data);
4281:
4282:

Line 4289: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);

4285: x_return_status := fnd_api.g_ret_sts_unexp_error;
4286: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
4287: print_debuginfo('Exception : ' || SQLERRM);
4288: END IF;
4289: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);
4290:
4291: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4292: p_count => x_msg_count,
4293: p_data => x_msg_data);

Line 4291: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

4287: print_debuginfo('Exception : ' || SQLERRM);
4288: END IF;
4289: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);
4290:
4291: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4292: p_count => x_msg_count,
4293: p_data => x_msg_data);
4294:
4295: END add_joint_account_owner;

Line 4343: FND_MSG_PUB.initialize;

4339: END IF;
4340:
4341: -- Initialize message list if p_init_msg_list is set to TRUE.
4342: IF FND_API.to_Boolean(p_init_msg_list) THEN
4343: FND_MSG_PUB.initialize;
4344: END IF;
4345:
4346: -- Initialize API return status to success
4347: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 4380: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

4376: END IF;
4377: -- End of API body
4378:
4379: -- get message count and if count is 1, get message info.
4380: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4381: p_count => x_msg_count,
4382: p_data => x_msg_data);
4383:
4384: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 4392: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

4388: EXCEPTION
4389: WHEN fnd_api.g_exc_error THEN
4390: ROLLBACK TO set_acct_owner_end_date_pub;
4391: x_return_status := fnd_api.g_ret_sts_error;
4392: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4393: p_count => x_msg_count,
4394: p_data => x_msg_data);
4395:
4396:

Line 4400: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

4396:
4397: WHEN fnd_api.g_exc_unexpected_error THEN
4398: ROLLBACK TO set_acct_owner_end_date_pub;
4399: x_return_status := fnd_api.g_ret_sts_unexp_error;
4400: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4401: p_count => x_msg_count,
4402: p_data => x_msg_data);
4403:
4404:

Line 4408: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);

4404:
4405: WHEN OTHERS THEN
4406: ROLLBACK TO set_acct_owner_end_date_pub;
4407: x_return_status := fnd_api.g_ret_sts_unexp_error;
4408: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);
4409: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4410: p_count => x_msg_count,
4411: p_data => x_msg_data);
4412:

Line 4409: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

4405: WHEN OTHERS THEN
4406: ROLLBACK TO set_acct_owner_end_date_pub;
4407: x_return_status := fnd_api.g_ret_sts_unexp_error;
4408: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);
4409: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4410: p_count => x_msg_count,
4411: p_data => x_msg_data);
4412:
4413:

Line 4470: FND_MSG_PUB.initialize;

4466: END IF;
4467:
4468: -- Initialize message list if p_init_msg_list is set to TRUE.
4469: IF FND_API.to_Boolean(p_init_msg_list) THEN
4470: FND_MSG_PUB.initialize;
4471: END IF;
4472:
4473: -- Initialize API return status to success
4474: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 4513: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

4509:
4510: -- End of API body
4511:
4512: -- get message count and if count is 1, get message info.
4513: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4514: p_count => x_msg_count,
4515: p_data => x_msg_data);
4516:
4517: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 4527: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

4523: x_return_status := fnd_api.g_ret_sts_error;
4524: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
4525: print_debuginfo('Exception : ' || SQLERRM);
4526: END IF;
4527: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4528: p_count => x_msg_count,
4529: p_data => x_msg_data);
4530:
4531:

Line 4538: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

4534: x_return_status := fnd_api.g_ret_sts_unexp_error;
4535: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
4536: print_debuginfo('Exception : ' || SQLERRM);
4537: END IF;
4538: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4539: p_count => x_msg_count,
4540: p_data => x_msg_data);
4541:
4542:

Line 4549: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);

4545: x_return_status := fnd_api.g_ret_sts_unexp_error;
4546: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
4547: print_debuginfo('Exception : ' || SQLERRM);
4548: END IF;
4549: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);
4550:
4551: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4552: p_count => x_msg_count,
4553: p_data => x_msg_data);

Line 4551: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

4547: print_debuginfo('Exception : ' || SQLERRM);
4548: END IF;
4549: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);
4550:
4551: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4552: p_count => x_msg_count,
4553: p_data => x_msg_data);
4554:
4555: END change_primary_acct_owner;

Line 4602: FND_MSG_PUB.initialize;

4598: END IF;
4599:
4600: -- Initialize message list if p_init_msg_list is set to TRUE.
4601: IF FND_API.to_Boolean(p_init_msg_list) THEN
4602: FND_MSG_PUB.initialize;
4603: END IF;
4604:
4605: -- Initialize API return status to success
4606: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 4632: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

4628:
4629: -- End of API body
4630:
4631: -- get message count and if count is 1, get message info.
4632: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4633: p_count => x_msg_count,
4634: p_data => x_msg_data);
4635:
4636: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 4645: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

4641: x_return_status := fnd_api.g_ret_sts_error;
4642: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
4643: print_debuginfo('Exception : ' || SQLERRM);
4644: END IF;
4645: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4646: p_count => x_msg_count,
4647: p_data => x_msg_data);
4648: Raise;
4649:

Line 4655: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

4651: x_return_status := fnd_api.g_ret_sts_unexp_error;
4652: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
4653: print_debuginfo('Exception : ' || SQLERRM);
4654: END IF;
4655: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4656: p_count => x_msg_count,
4657: p_data => x_msg_data);
4658: Raise;
4659:

Line 4665: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);

4661: x_return_status := fnd_api.g_ret_sts_unexp_error;
4662: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
4663: print_debuginfo('Exception : ' || SQLERRM);
4664: END IF;
4665: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);
4666:
4667: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4668: p_count => x_msg_count,
4669: p_data => x_msg_data);

Line 4667: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

4663: print_debuginfo('Exception : ' || SQLERRM);
4664: END IF;
4665: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);
4666:
4667: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4668: p_count => x_msg_count,
4669: p_data => x_msg_data);
4670: Raise;
4671: END check_bank_acct_owner;

Line 4704: fnd_msg_pub.add;

4700: OPEN c_country;
4701: FETCH c_country INTO l_country;
4702: IF c_country%NOTFOUND THEN
4703: fnd_message.set_name('IBY', 'IBY_API_NO_BANK');
4704: fnd_msg_pub.add;
4705: x_return_status := fnd_api.g_ret_sts_error;
4706: END IF;
4707: CLOSE c_country;
4708:

Line 4792: fnd_msg_pub.add;

4788: OPEN c_bank;
4789: FETCH c_bank INTO x_bank_id, x_country_code, x_bank_name, x_bank_number;
4790: IF c_bank%NOTFOUND THEN
4791: fnd_message.set_name('IBY', 'IBY_API_NO_BANK');
4792: fnd_msg_pub.add;
4793: x_return_status := fnd_api.g_ret_sts_error;
4794: END IF;
4795: CLOSE c_bank;
4796:

Line 4832: fnd_msg_pub.add;

4828:
4829: if (p_value is NULL) THEN
4830: fnd_message.set_name('IBY', 'IBY_MISSING_MANDATORY_PARAM');
4831: fnd_message.set_token('PARAM', fnd_message.get_string('IBY',p_field));
4832: fnd_msg_pub.add;
4833: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
4834: print_debuginfo(fnd_message.get_string('IBY',p_field)|| ' is a required parameter.');
4835: END IF;
4836: RAISE fnd_api.g_exc_error;

Line 4849: fnd_msg_pub.add;

4845:
4846: IF (l_temp IS NULL) THEN
4847: fnd_message.set_name('IBY', 'IBY_INVALID_CURRENCY');
4848: fnd_message.set_token('CURRENCY_CODE', p_field);
4849: fnd_msg_pub.add;
4850: RAISE fnd_api.g_exc_error;
4851: END IF;
4852:
4853: END IF;

Line 5668: fnd_msg_pub.add;

5664: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
5665: print_debuginfo(l_module_name||': Sys key Validation Failed');
5666: END IF;
5667: fnd_message.set_name('IBY', l_err_code);
5668: fnd_msg_pub.add;
5669: return null;
5670: END IF;
5671:
5672: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN