APPS.IBY_EXT_BANKACCT_PUB dependencies on FND_MSG_PUB

Line 108: FND_MSG_PUB.initialize;

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

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

184: print_debuginfo('Ext Bank Id : ' || x_bank_id);
185: -- End of API body
186:
187: -- get message count and if count is 1, get message info.
188: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
189: p_count => x_msg_count,
190: p_data => x_msg_data);
191:
192: print_debuginfo('RETURN ' || l_module_name);

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

195: WHEN fnd_api.g_exc_error THEN
196: ROLLBACK TO create_bank_pub;
197: x_return_status := fnd_api.g_ret_sts_error;
198: print_debuginfo('Exception : ' || SQLERRM);
199: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
200: p_count => x_msg_count,
201: p_data => x_msg_data);
202:
203:

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

204: WHEN fnd_api.g_exc_unexpected_error THEN
205: ROLLBACK TO create_bank_pub;
206: x_return_status := fnd_api.g_ret_sts_unexp_error;
207: print_debuginfo('Exception : ' || SQLERRM);
208: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
209: p_count => x_msg_count,
210: p_data => x_msg_data);
211:
212:

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

213: WHEN OTHERS THEN
214: ROLLBACK TO create_bank_pub;
215: x_return_status := fnd_api.g_ret_sts_unexp_error;
216: print_debuginfo('Exception : ' || SQLERRM);
217: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);
218:
219: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
220: p_count => x_msg_count,
221: p_data => x_msg_data);

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

215: x_return_status := fnd_api.g_ret_sts_unexp_error;
216: print_debuginfo('Exception : ' || SQLERRM);
217: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);
218:
219: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
220: p_count => x_msg_count,
221: p_data => x_msg_data);
222:
223:

Line 268: FND_MSG_PUB.initialize;

264: END IF;
265:
266: -- Initialize message list if p_init_msg_list is set to TRUE.
267: IF FND_API.to_Boolean(p_init_msg_list) THEN
268: FND_MSG_PUB.initialize;
269: END IF;
270:
271: -- Initialize API return status to success
272: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

322: print_debuginfo('Returned from CE API');
323: -- End of API body
324:
325: -- get message count and if count is 1, get message info.
326: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
327: p_count => x_msg_count,
328: p_data => x_msg_data);
329:
330: print_debuginfo('RETURN ' || l_module_name);

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

333: WHEN fnd_api.g_exc_error THEN
334: ROLLBACK TO update_bank_pub;
335: x_return_status := fnd_api.g_ret_sts_error;
336: print_debuginfo('Exception : ' || SQLERRM);
337: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
338: p_count => x_msg_count,
339: p_data => x_msg_data);
340:
341:

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

342: WHEN fnd_api.g_exc_unexpected_error THEN
343: ROLLBACK TO update_bank_pub;
344: x_return_status := fnd_api.g_ret_sts_unexp_error;
345: print_debuginfo('Exception : ' || SQLERRM);
346: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
347: p_count => x_msg_count,
348: p_data => x_msg_data);
349:
350:

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

352: ROLLBACK TO update_bank_pub;
353: x_return_status := fnd_api.g_ret_sts_unexp_error;
354: print_debuginfo('Exception : ' || SQLERRM);
355:
356: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);
357: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
358: p_count => x_msg_count,
359: p_data => x_msg_data);
360:

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

353: x_return_status := fnd_api.g_ret_sts_unexp_error;
354: print_debuginfo('Exception : ' || SQLERRM);
355:
356: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);
357: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
358: p_count => x_msg_count,
359: p_data => x_msg_data);
360:
361:

Line 413: FND_MSG_PUB.initialize;

409: END IF;
410:
411: -- Initialize message list if p_init_msg_list is set to TRUE.
412: IF FND_API.to_Boolean(p_init_msg_list) THEN
413: FND_MSG_PUB.initialize;
414: END IF;
415:
416: -- Initialize API return status to success
417: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

441:
442: -- End of API body
443:
444: -- get message count and if count is 1, get message info.
445: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
446: p_count => x_msg_count,
447: p_data => x_msg_data);
448:
449: print_debuginfo('RETURN ' || l_module_name);

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

451: WHEN fnd_api.g_exc_error THEN
452: ROLLBACK TO set_bank_end_date_pub;
453: x_return_status := fnd_api.g_ret_sts_error;
454: print_debuginfo('Exception : ' || SQLERRM);
455: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
456: p_count => x_msg_count,
457: p_data => x_msg_data);
458:
459:

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

460: WHEN fnd_api.g_exc_unexpected_error THEN
461: ROLLBACK TO set_bank_end_date_pub;
462: x_return_status := fnd_api.g_ret_sts_unexp_error;
463: print_debuginfo('Exception : ' || SQLERRM);
464: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
465: p_count => x_msg_count,
466: p_data => x_msg_data);
467:
468:

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

469: WHEN OTHERS THEN
470: ROLLBACK TO set_bank_end_date_pub;
471: x_return_status := fnd_api.g_ret_sts_unexp_error;
472: print_debuginfo('Exception : ' || SQLERRM);
473: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);
474:
475: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
476: p_count => x_msg_count,
477: p_data => x_msg_data);

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

471: x_return_status := fnd_api.g_ret_sts_unexp_error;
472: print_debuginfo('Exception : ' || SQLERRM);
473: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);
474:
475: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
476: p_count => x_msg_count,
477: p_data => x_msg_data);
478:
479: END set_bank_end_date;

Line 525: FND_MSG_PUB.initialize;

521: END IF;
522:
523: -- Initialize message list if p_init_msg_list is set to TRUE.
524: IF FND_API.to_Boolean(p_init_msg_list) THEN
525: FND_MSG_PUB.initialize;
526: END IF;
527:
528: -- Initialize API return status to success
529: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

544:
545: -- End of API body
546:
547: -- get message count and if count is 1, get message info.
548: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
549: p_count => x_msg_count,
550: p_data => x_msg_data);
551:
552: print_debuginfo('RETURN ' || l_module_name);

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

553: EXCEPTION
554: WHEN fnd_api.g_exc_error THEN
555: x_return_status := fnd_api.g_ret_sts_error;
556: print_debuginfo('Exception : ' || SQLERRM);
557: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
558: p_count => x_msg_count,
559: p_data => x_msg_data);
560:
561:

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

561:
562: WHEN fnd_api.g_exc_unexpected_error THEN
563: x_return_status := fnd_api.g_ret_sts_unexp_error;
564: print_debuginfo('Exception : ' || SQLERRM);
565: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
566: p_count => x_msg_count,
567: p_data => x_msg_data);
568:
569:

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

570: WHEN OTHERS THEN
571: x_return_status := fnd_api.g_ret_sts_unexp_error;
572: print_debuginfo('Exception : ' || SQLERRM);
573:
574: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);
575:
576: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
577: p_count => x_msg_count,
578: p_data => x_msg_data);

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

572: print_debuginfo('Exception : ' || SQLERRM);
573:
574: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);
575:
576: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
577: p_count => x_msg_count,
578: p_data => x_msg_data);
579:
580: END check_bank_exist;

Line 624: FND_MSG_PUB.initialize;

620: END IF;
621:
622: -- Initialize message list if p_init_msg_list is set to TRUE.
623: IF FND_API.to_Boolean(p_init_msg_list) THEN
624: FND_MSG_PUB.initialize;
625: END IF;
626:
627: -- Initialize API return status to success
628: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

685: print_debuginfo('Ext Bank Branch Id : ' || x_branch_id);
686: -- End of API body
687:
688: -- get message count and if count is 1, get message info.
689: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
690: p_count => x_msg_count,
691: p_data => x_msg_data);
692:
693: print_debuginfo('RETURN ' || l_module_name);

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

696: WHEN fnd_api.g_exc_error THEN
697: ROLLBACK TO create_bank_branch_pub;
698: x_return_status := fnd_api.g_ret_sts_error;
699: print_debuginfo('Exception : ' || SQLERRM);
700: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
701: p_count => x_msg_count,
702: p_data => x_msg_data);
703:
704:

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

705: WHEN fnd_api.g_exc_unexpected_error THEN
706: ROLLBACK TO create_bank_branch_pub;
707: x_return_status := fnd_api.g_ret_sts_unexp_error;
708: print_debuginfo('Exception : ' || SQLERRM);
709: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
710: p_count => x_msg_count,
711: p_data => x_msg_data);
712:
713:

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

715: ROLLBACK TO create_bank_branch_pub;
716: x_return_status := fnd_api.g_ret_sts_unexp_error;
717: print_debuginfo('Exception : ' || SQLERRM);
718:
719: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);
720: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
721: p_count => x_msg_count,
722: p_data => x_msg_data);
723:

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

716: x_return_status := fnd_api.g_ret_sts_unexp_error;
717: print_debuginfo('Exception : ' || SQLERRM);
718:
719: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);
720: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
721: p_count => x_msg_count,
722: p_data => x_msg_data);
723:
724: END create_ext_bank_branch;

Line 785: FND_MSG_PUB.initialize;

781: END IF;
782:
783: -- Initialize message list if p_init_msg_list is set to TRUE.
784: IF FND_API.to_Boolean(p_init_msg_list) THEN
785: FND_MSG_PUB.initialize;
786: END IF;
787:
788: -- Initialize API return status to success
789: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 819: fnd_msg_pub.add;

815: IF (l_rfc_identifier_ovn <> p_ext_bank_branch_rec.rfc_object_version_number) THEN
816:
817: fnd_message.set_name('IBY', 'IBY_DATA_VERSION_ERROR');
818:
819: fnd_msg_pub.add;
820: print_debuginfo('Object Version Number mismatch');
821: END IF;
822: ELSE
823: print_debuginfo('Current RFC Identifier OVN is NULL');

Line 833: fnd_msg_pub.add;

829: IF (l_eft_record_ovn IS NOT NULL) THEN
830: print_debuginfo('Current RFC Identifier OVN ' || l_eft_record_ovn);
831: IF (l_eft_record_ovn <> p_ext_bank_branch_rec.eft_object_version_number) THEN
832: fnd_message.set_name('IBY', 'IBY_DATA_VERSION_ERROR');
833: fnd_msg_pub.add;
834: print_debuginfo('Object Version Number mismatch');
835: END IF;
836: ELSE
837: print_debuginfo('Current RFC Identifier OVN is NULL');

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

885: print_debuginfo('Returned from CE API');
886: -- End of API Body
887:
888: -- get message count and if count is 1, get message info.
889: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
890: p_count => x_msg_count,
891: p_data => x_msg_data);
892:
893: print_debuginfo('RETURN ' || l_module_name);

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

896: WHEN fnd_api.g_exc_error THEN
897: ROLLBACK TO update_bank_branch_pub;
898: x_return_status := fnd_api.g_ret_sts_error;
899: print_debuginfo('Exception : ' || SQLERRM);
900: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
901: p_count => x_msg_count,
902: p_data => x_msg_data);
903:
904:

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

905: WHEN fnd_api.g_exc_unexpected_error THEN
906: ROLLBACK TO update_bank_branch_pub;
907: x_return_status := fnd_api.g_ret_sts_unexp_error;
908: print_debuginfo('Exception : ' || SQLERRM);
909: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
910: p_count => x_msg_count,
911: p_data => x_msg_data);
912:
913:

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

915: ROLLBACK TO update_bank_branch_pub;
916: x_return_status := fnd_api.g_ret_sts_unexp_error;
917: print_debuginfo('Exception : ' || SQLERRM);
918:
919: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);
920: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
921: p_count => x_msg_count,
922: p_data => x_msg_data);
923:

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

916: x_return_status := fnd_api.g_ret_sts_unexp_error;
917: print_debuginfo('Exception : ' || SQLERRM);
918:
919: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);
920: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
921: p_count => x_msg_count,
922: p_data => x_msg_data);
923:
924:

Line 976: FND_MSG_PUB.initialize;

972: END IF;
973:
974: -- Initialize message list if p_init_msg_list is set to TRUE.
975: IF FND_API.to_Boolean(p_init_msg_list) THEN
976: FND_MSG_PUB.initialize;
977: END IF;
978:
979: -- Initialize API return status to success
980: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

1004:
1005: -- End of API body
1006:
1007: -- get message count and if count is 1, get message info.
1008: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1009: p_count => x_msg_count,
1010: p_data => x_msg_data);
1011:
1012: print_debuginfo('RETURN ' || l_module_name);

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

1014: WHEN fnd_api.g_exc_error THEN
1015: ROLLBACK TO set_ext_branch_end_date_pub;
1016: x_return_status := fnd_api.g_ret_sts_error;
1017: print_debuginfo('Exception : ' || SQLERRM);
1018: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1019: p_count => x_msg_count,
1020: p_data => x_msg_data);
1021:
1022:

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

1023: WHEN fnd_api.g_exc_unexpected_error THEN
1024: ROLLBACK TO set_ext_branch_end_date_pub;
1025: x_return_status := fnd_api.g_ret_sts_unexp_error;
1026: print_debuginfo('Exception : ' || SQLERRM);
1027: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1028: p_count => x_msg_count,
1029: p_data => x_msg_data);
1030:
1031:

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

1033: ROLLBACK TO set_ext_branch_end_date_pub;
1034: x_return_status := fnd_api.g_ret_sts_unexp_error;
1035: print_debuginfo('Exception : ' || SQLERRM);
1036:
1037: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);
1038: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1039: p_count => x_msg_count,
1040: p_data => x_msg_data);
1041:

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

1034: x_return_status := fnd_api.g_ret_sts_unexp_error;
1035: print_debuginfo('Exception : ' || SQLERRM);
1036:
1037: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);
1038: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1039: p_count => x_msg_count,
1040: p_data => x_msg_data);
1041:
1042:

Line 1090: FND_MSG_PUB.initialize;

1086: END IF;
1087:
1088: -- Initialize message list if p_init_msg_list is set to TRUE.
1089: IF FND_API.to_Boolean(p_init_msg_list) THEN
1090: FND_MSG_PUB.initialize;
1091: END IF;
1092:
1093: -- Initialize API return status to success
1094: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

1109:
1110: -- End of API body
1111:
1112: -- get message count and if count is 1, get message info.
1113: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1114: p_count => x_msg_count,
1115: p_data => x_msg_data);
1116:
1117: print_debuginfo('RETURN ' || l_module_name);

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

1119: EXCEPTION
1120: WHEN fnd_api.g_exc_error THEN
1121: x_return_status := fnd_api.g_ret_sts_error;
1122: print_debuginfo('Exception : ' || SQLERRM);
1123: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1124: p_count => x_msg_count,
1125: p_data => x_msg_data);
1126:
1127:

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

1127:
1128: WHEN fnd_api.g_exc_unexpected_error THEN
1129: x_return_status := fnd_api.g_ret_sts_unexp_error;
1130: print_debuginfo('Exception : ' || SQLERRM);
1131: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1132: p_count => x_msg_count,
1133: p_data => x_msg_data);
1134:
1135:

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

1135:
1136: WHEN OTHERS THEN
1137: x_return_status := fnd_api.g_ret_sts_unexp_error;
1138: print_debuginfo('Exception : ' || SQLERRM);
1139: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);
1140:
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);

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: print_debuginfo('Exception : ' || SQLERRM);
1139: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);
1140:
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 1241: FND_MSG_PUB.initialize;

1237: END IF;
1238:
1239: -- Initialize message list if p_init_msg_list is set to TRUE.
1240: IF FND_API.to_Boolean(p_init_msg_list) THEN
1241: FND_MSG_PUB.initialize;
1242: END IF;
1243:
1244: -- Initialize API return status to success
1245: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1291: fnd_msg_pub.add;

1287: OPEN c_branch(p_ext_bank_acct_rec.branch_id);
1288: FETCH c_branch INTO l_branch_number;
1289: IF c_branch%NOTFOUND THEN
1290: fnd_message.set_name('IBY', 'IBY_API_NO_BRANCH');
1291: fnd_msg_pub.add;
1292: x_return_status := fnd_api.g_ret_sts_error;
1293: RAISE fnd_api.g_exc_error;
1294: ELSE
1295: print_debuginfo('Got Branch Number : '||l_branch_number);

Line 1324: fnd_msg_pub.add;

1320: print_debuginfo('Duplicate account id:'||l_dup_acct_id);
1321: IF ((not x_return_status = fnd_api.g_ret_sts_success) OR
1322: (not l_dup_acct_id is null)) THEN
1323: fnd_message.set_name('IBY', 'IBY_UNIQ_ACCOUNT');
1324: fnd_msg_pub.add;
1325: OPEN c_supplier(l_dup_acct_id);
1326: FETCH c_supplier INTO l_party_id;
1327: IF l_party_id IS NOT NULL THEN
1328: SELECT vendor_name, segment1 INTO l_supplier_name, l_supplier_number FROM ap_suppliers WHERE party_id = l_party_id;

Line 1332: fnd_msg_pub.add;

1328: SELECT vendor_name, segment1 INTO l_supplier_name, l_supplier_number FROM ap_suppliers WHERE party_id = l_party_id;
1329: fnd_message.set_name('IBY', 'IBY_UNIQ_ACCOUNT_SUPPLIER');
1330: fnd_message.set_Token('SUPPLIER',l_supplier_name);
1331: fnd_message.set_Token('SUPPLIERNUMBER',l_supplier_number);
1332: fnd_msg_pub.add;
1333: END IF;
1334: CLOSE c_supplier;
1335: x_return_status := fnd_api.g_ret_sts_error;
1336: print_debuginfo('Error : Duplicate Bank Account');

Line 1342: fnd_msg_pub.delete_msg;

1338: END IF;
1339:
1340: -- country specific validation API call here.
1341: -- delete the message as CE using message count for error
1342: fnd_msg_pub.delete_msg;
1343: x_msg_count:=0;
1344:
1345: /*
1346: * Fix for bug 5413958:

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

1613: END IF;
1614: END IF;
1615:
1616: -- get message count and if count is 1, get message info.
1617: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1618: p_count => x_msg_count,
1619: p_data => x_msg_data);
1620:
1621: print_debuginfo('RETURN ' || l_module_name);

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

1625: WHEN fnd_api.g_exc_error THEN
1626: ROLLBACK TO create_ext_bank_acct_pub;
1627: x_return_status := fnd_api.g_ret_sts_error;
1628: print_debuginfo('Exception : ' || SQLERRM);
1629: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1630: p_count => x_msg_count,
1631: p_data => x_msg_data);
1632:
1633:

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

1634: WHEN fnd_api.g_exc_unexpected_error THEN
1635: ROLLBACK TO create_ext_bank_acct_pub;
1636: x_return_status := fnd_api.g_ret_sts_unexp_error;
1637: print_debuginfo('Exception : ' || SQLERRM);
1638: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1639: p_count => x_msg_count,
1640: p_data => x_msg_data);
1641:
1642:

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

1643: WHEN OTHERS THEN
1644: ROLLBACK TO create_ext_bank_acct_pub;
1645:
1646: x_return_status := fnd_api.g_ret_sts_unexp_error;
1647: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);
1648:
1649: print_debuginfo('Exception : ' || SQLERRM);
1650: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1651: p_count => x_msg_count,

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

1646: x_return_status := fnd_api.g_ret_sts_unexp_error;
1647: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);
1648:
1649: print_debuginfo('Exception : ' || SQLERRM);
1650: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1651: p_count => x_msg_count,
1652: p_data => x_msg_data);
1653:
1654: END create_ext_bank_acct;

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

1829: WHEN FND_API.G_EXC_ERROR THEN
1830: ROLLBACK TO create_ext_bank_acct_thru_api;
1831: x_return_status := fnd_api.g_ret_sts_error;
1832: print_debuginfo('Exception : ' || SQLERRM);
1833: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1834: p_count => x_msg_count,
1835: p_data => x_msg_data);
1836: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1837: ROLLBACK TO create_ext_bank_acct_thru_api;

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

1836: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1837: ROLLBACK TO create_ext_bank_acct_thru_api;
1838: x_return_status := fnd_api.g_ret_sts_unexp_error;
1839: print_debuginfo('Exception : ' || SQLERRM);
1840: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1841: p_count => x_msg_count,
1842: p_data => x_msg_data);
1843: WHEN L_INVALID_SUPPLIER_ID THEN
1844: ROLLBACK TO create_ext_bank_acct_thru_api;

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

1843: WHEN L_INVALID_SUPPLIER_ID THEN
1844: ROLLBACK TO create_ext_bank_acct_thru_api;
1845: x_return_status := FND_API.G_RET_STS_ERROR ;
1846: print_debuginfo('Exception : invalid supplier id');
1847: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1848: p_count => x_msg_count,
1849: p_data => x_msg_data);
1850: WHEN L_INVALID_PARTY_SITE THEN
1851: ROLLBACK TO create_ext_bank_acct_thru_api;

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

1850: WHEN L_INVALID_PARTY_SITE THEN
1851: ROLLBACK TO create_ext_bank_acct_thru_api;
1852: x_return_status := FND_API.G_RET_STS_ERROR ;
1853: print_debuginfo('Exception : invalid party site id');
1854: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1855: p_count => x_msg_count,
1856: p_data => x_msg_data);
1857: WHEN L_INVALID_AO THEN
1858: ROLLBACK TO create_ext_bank_acct_thru_api;

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

1857: WHEN L_INVALID_AO THEN
1858: ROLLBACK TO create_ext_bank_acct_thru_api;
1859: x_return_status := FND_API.G_RET_STS_ERROR ;
1860: print_debuginfo('Exception : invalid combination of party site id and org id');
1861: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1862: p_count => x_msg_count,
1863: p_data => x_msg_data);
1864: WHEN L_INVALID_ASSOCIATION_LEVEL THEN
1865: ROLLBACK TO create_ext_bank_acct_thru_api;

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

1864: WHEN L_INVALID_ASSOCIATION_LEVEL THEN
1865: ROLLBACK TO create_ext_bank_acct_thru_api;
1866: x_return_status := FND_API.G_RET_STS_ERROR ;
1867: print_debuginfo('Exception : invalid Association level');
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: WHEN OTHERS THEN
1872: ROLLBACK TO create_ext_bank_acct_thru_api;

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

1870: p_data => x_msg_data);
1871: WHEN OTHERS THEN
1872: ROLLBACK TO create_ext_bank_acct_thru_api;
1873: x_return_status := fnd_api.g_ret_sts_unexp_error;
1874: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module, null);
1875: print_debuginfo('Exception : ' || SQLERRM);
1876: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1877: p_count => x_msg_count,
1878: p_data => x_msg_data);

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

1872: ROLLBACK TO create_ext_bank_acct_thru_api;
1873: x_return_status := fnd_api.g_ret_sts_unexp_error;
1874: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module, null);
1875: print_debuginfo('Exception : ' || SQLERRM);
1876: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1877: p_count => x_msg_count,
1878: p_data => x_msg_data);
1879:
1880: END create_ext_bank_acct;

Line 2017: FND_MSG_PUB.initialize;

2013: END IF;
2014:
2015: -- Initialize message list if p_init_msg_list is set to TRUE.
2016: IF FND_API.to_Boolean(p_init_msg_list) THEN
2017: FND_MSG_PUB.initialize;
2018: END IF;
2019:
2020: -- Initialize API return status to success
2021: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2048: fnd_msg_pub.add;

2044: l_old_iban,
2045: l_old_masked_iban;
2046: IF c_ovn%NOTFOUND THEN
2047: fnd_message.set_name('IBY', 'IBY_API_NO_EXT_BANK_ACCT');
2048: fnd_msg_pub.add;
2049: x_return_status := fnd_api.g_ret_sts_error;
2050: CLOSE c_ovn;
2051: RAISE fnd_api.g_exc_error;
2052: END IF;

Line 2058: fnd_msg_pub.add;

2054: print_debuginfo('Current object_version_number Version Number ' || l_old_ovn);
2055:
2056: IF l_old_ovn <> p_ext_bank_acct_rec.object_version_number THEN
2057: fnd_message.set_name('IBY', 'IBY_DATA_VERSION_ERROR');
2058: fnd_msg_pub.add;
2059: x_return_status := fnd_api.g_ret_sts_error;
2060: print_debuginfo('Error: Object Version Number Mismatch');
2061: RAISE fnd_api.g_exc_error;
2062: END IF;

Line 2076: fnd_msg_pub.add;

2072: p_ext_bank_acct_rec.bank_account_id);
2073: FETCH uniq_check into l_count;
2074: IF (l_count > 1) THEN
2075: fnd_message.set_name('IBY', 'IBY_UNIQ_ACCOUNT');
2076: fnd_msg_pub.add;
2077: x_return_status := fnd_api.g_ret_sts_error;
2078: RAISE fnd_api.g_exc_error;
2079: END IF;
2080: CLOSE uniq_check;

Line 2089: fnd_msg_pub.add;

2085: print_debuginfo('Duplicate account id:'||l_dup_acct_id);
2086: IF ((not x_return_status = fnd_api.g_ret_sts_success) OR
2087: (not l_dup_acct_id is null)) THEN
2088: fnd_message.set_name('IBY', 'IBY_UNIQ_ACCOUNT');
2089: fnd_msg_pub.add;
2090: x_return_status := fnd_api.g_ret_sts_error;
2091: print_debuginfo('Error : Duplicate Bank Account');
2092: RAISE fnd_api.g_exc_error;
2093: END IF;

Line 2272: fnd_msg_pub.add;

2268: print_debuginfo('Duplicate account id:'||l_dup_acct_id);
2269: IF ((not x_return_status = fnd_api.g_ret_sts_success) OR
2270: (not l_dup_acct_id is null)) THEN
2271: fnd_message.set_name('IBY', 'IBY_UNIQ_ACCOUNT');
2272: fnd_msg_pub.add;
2273: OPEN c_supplier(l_dup_acct_id);
2274: FETCH c_supplier INTO l_party_id;
2275: IF l_party_id IS NOT NULL THEN
2276: SELECT vendor_name, segment1 INTO l_supplier_name, l_supplier_number FROM ap_suppliers WHERE party_id = l_party_id;

Line 2280: fnd_msg_pub.add;

2276: SELECT vendor_name, segment1 INTO l_supplier_name, l_supplier_number FROM ap_suppliers WHERE party_id = l_party_id;
2277: fnd_message.set_name('IBY', 'IBY_UNIQ_ACCOUNT_SUPPLIER');
2278: fnd_message.set_Token('SUPPLIER',l_supplier_name);
2279: fnd_message.set_Token('SUPPLIERNUMBER',l_supplier_number);
2280: fnd_msg_pub.add;
2281: END IF;
2282: CLOSE c_supplier;
2283: x_return_status := fnd_api.g_ret_sts_error;
2284: print_debuginfo('Error : Duplicate Bank Account');

Line 2290: fnd_msg_pub.delete_msg;

2286: END IF;
2287:
2288: -- country specific validation API call here.
2289: -- delete the message as CE using message count for error
2290: fnd_msg_pub.delete_msg;
2291: x_msg_count:=0;
2292:
2293:
2294: --Get_Mask_Settings(lx_mask_option,lx_unmask_len);

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

2424:
2425: -- End of API body
2426:
2427: -- get message count and if count is 1, get message info.
2428: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2429: p_count => x_msg_count,
2430: p_data => x_msg_data);
2431:
2432: print_debuginfo('RETURN ' || l_module_name);

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

2434: EXCEPTION
2435: WHEN fnd_api.g_exc_error THEN
2436: ROLLBACK TO update_ext_bank_acct_pub;
2437: x_return_status := fnd_api.g_ret_sts_error;
2438: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2439: p_count => x_msg_count,
2440: p_data => x_msg_data);
2441:
2442:

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

2442:
2443: WHEN fnd_api.g_exc_unexpected_error THEN
2444: ROLLBACK TO update_ext_bank_acct_pub;
2445: x_return_status := fnd_api.g_ret_sts_unexp_error;
2446: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2447: p_count => x_msg_count,
2448: p_data => x_msg_data);
2449:
2450:

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

2450:
2451: WHEN OTHERS THEN
2452: ROLLBACK TO update_ext_bank_acct_pub;
2453: x_return_status := fnd_api.g_ret_sts_unexp_error;
2454: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);
2455:
2456: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2457: p_count => x_msg_count,
2458: p_data => x_msg_data);

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

2452: ROLLBACK TO update_ext_bank_acct_pub;
2453: x_return_status := fnd_api.g_ret_sts_unexp_error;
2454: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);
2455:
2456: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2457: p_count => x_msg_count,
2458: p_data => x_msg_data);
2459:
2460:

Line 2579: FND_MSG_PUB.initialize;

2575: END IF;
2576:
2577: -- Initialize message list if p_init_msg_list is set to TRUE.
2578: IF FND_API.to_Boolean(p_init_msg_list) THEN
2579: FND_MSG_PUB.initialize;
2580: END IF;
2581:
2582: -- Initialize API return status to success
2583: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

2644:
2645: -- End of API body
2646:
2647: -- get message count and if count is 1, get message info.
2648: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2649: p_count => x_msg_count,
2650: p_data => x_msg_data);
2651:
2652: print_debuginfo('RETURN ' || l_module_name);

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

2653: EXCEPTION
2654: WHEN fnd_api.g_exc_error THEN
2655: x_return_status := fnd_api.g_ret_sts_error;
2656: print_debuginfo('Exception : ' || SQLERRM);
2657: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2658: p_count => x_msg_count,
2659: p_data => x_msg_data);
2660:
2661:

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

2661:
2662: WHEN fnd_api.g_exc_unexpected_error THEN
2663: x_return_status := fnd_api.g_ret_sts_unexp_error;
2664: print_debuginfo('Exception : ' || SQLERRM);
2665: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2666: p_count => x_msg_count,
2667: p_data => x_msg_data);
2668:
2669:

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

2669:
2670: WHEN OTHERS THEN
2671: x_return_status := fnd_api.g_ret_sts_unexp_error;
2672: print_debuginfo('Exception : ' || SQLERRM);
2673: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);
2674:
2675: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2676: p_count => x_msg_count,
2677: p_data => x_msg_data);

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

2671: x_return_status := fnd_api.g_ret_sts_unexp_error;
2672: print_debuginfo('Exception : ' || SQLERRM);
2673: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);
2674:
2675: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2676: p_count => x_msg_count,
2677: p_data => x_msg_data);
2678:
2679:

Line 2726: FND_MSG_PUB.initialize;

2722: END IF;
2723:
2724: -- Initialize message list if p_init_msg_list is set to TRUE.
2725: IF FND_API.to_Boolean(p_init_msg_list) THEN
2726: FND_MSG_PUB.initialize;
2727: END IF;
2728:
2729: -- Initialize API return status to success
2730: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

2747:
2748: -- End of API body
2749:
2750: -- get message count and if count is 1, get message info.
2751: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2752: p_count => x_msg_count,
2753: p_data => x_msg_data);
2754:
2755: print_debuginfo('RETURN ' || l_module_name);

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

2757: WHEN fnd_api.g_exc_error THEN
2758: ROLLBACK TO get_ext_bank_acct_pub;
2759: x_return_status := fnd_api.g_ret_sts_error;
2760: print_debuginfo('Exception : ' || SQLERRM);
2761: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2762: p_count => x_msg_count,
2763: p_data => x_msg_data);
2764:
2765:

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

2766: WHEN fnd_api.g_exc_unexpected_error THEN
2767: ROLLBACK TO get_ext_bank_acct_pub;
2768: x_return_status := fnd_api.g_ret_sts_unexp_error;
2769: print_debuginfo('Exception : ' || SQLERRM);
2770: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2771: p_count => x_msg_count,
2772: p_data => x_msg_data);
2773:
2774:

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

2775: WHEN OTHERS THEN
2776: ROLLBACK TO get_ext_bank_acct_pub;
2777: x_return_status := fnd_api.g_ret_sts_unexp_error;
2778: print_debuginfo('Exception : ' || SQLERRM);
2779: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);
2780:
2781: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2782: p_count => x_msg_count,
2783: p_data => x_msg_data);

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

2777: x_return_status := fnd_api.g_ret_sts_unexp_error;
2778: print_debuginfo('Exception : ' || SQLERRM);
2779: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);
2780:
2781: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2782: p_count => x_msg_count,
2783: p_data => x_msg_data);
2784:
2785:

Line 2832: FND_MSG_PUB.initialize;

2828: END IF;
2829:
2830: -- Initialize message list if p_init_msg_list is set to TRUE.
2831: IF FND_API.to_Boolean(p_init_msg_list) THEN
2832: FND_MSG_PUB.initialize;
2833: END IF;
2834:
2835: -- Initialize API return status to success
2836: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2851: fnd_msg_pub.add;

2847: IF (p_end_date IS NOT NULL AND p_start_date > p_end_date) THEN
2848: -- throw exception if start date
2849: -- exceeds end_date
2850: fnd_message.set_name('IBY', 'IBY_START_END_DATE_BAD');
2851: fnd_msg_pub.add;
2852: RAISE fnd_api.g_exc_error;
2853: END IF;
2854:
2855: -- update bank account dates

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

2865:
2866: -- End of API body
2867:
2868: -- get message count and if count is 1, get message info.
2869: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2870: p_count => x_msg_count,
2871: p_data => x_msg_data);
2872:
2873: print_debuginfo('RETURN ' || l_module_name);

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

2875: EXCEPTION
2876: WHEN fnd_api.g_exc_error THEN
2877: ROLLBACK TO set_ext_bank_acct_dates_pub;
2878: x_return_status := fnd_api.g_ret_sts_error;
2879: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2880: p_count => x_msg_count,
2881: p_data => x_msg_data);
2882:
2883:

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

2883:
2884: WHEN fnd_api.g_exc_unexpected_error THEN
2885: ROLLBACK TO set_ext_bank_acct_dates_pub;
2886: x_return_status := fnd_api.g_ret_sts_unexp_error;
2887: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2888: p_count => x_msg_count,
2889: p_data => x_msg_data);
2890:
2891:

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

2891:
2892: WHEN OTHERS THEN
2893: ROLLBACK TO set_ext_bank_acct_dates_pub;
2894: x_return_status := fnd_api.g_ret_sts_unexp_error;
2895: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);
2896: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2897: p_count => x_msg_count,
2898: p_data => x_msg_data);
2899:

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

2892: WHEN OTHERS THEN
2893: ROLLBACK TO set_ext_bank_acct_dates_pub;
2894: x_return_status := fnd_api.g_ret_sts_unexp_error;
2895: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);
2896: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2897: p_count => x_msg_count,
2898: p_data => x_msg_data);
2899:
2900:

Line 3040: FND_MSG_PUB.initialize;

3036: END IF;
3037:
3038: -- Initialize message list if p_init_msg_list is set to TRUE.
3039: IF FND_API.to_Boolean(p_init_msg_list) THEN
3040: FND_MSG_PUB.initialize;
3041: END IF;
3042:
3043: -- Initialize API return status to success
3044: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3088: -- fnd_msg_pub.add;

3084: END IF;
3085:
3086: IF (SQL%NOTFOUND) THEN
3087: -- fnd_message.set_name('IBY', 'IBY_EXT_ACCT_NOT_EXIST');
3088: -- fnd_msg_pub.add;
3089: print_debuginfo('External Account does not exist ');
3090: END IF;
3091:
3092: -- get message count and if count is 1, get message info.

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

3089: print_debuginfo('External Account does not exist ');
3090: END IF;
3091:
3092: -- get message count and if count is 1, get message info.
3093: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3094: p_count => x_msg_count,
3095: p_data => x_msg_data);
3096:
3097: print_debuginfo('RETURN ' || l_module_name);

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

3099: EXCEPTION
3100: WHEN fnd_api.g_exc_error THEN
3101: x_return_status := fnd_api.g_ret_sts_error;
3102: print_debuginfo('Exception : ' || SQLERRM);
3103: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3104: p_count => x_msg_count,
3105: p_data => x_msg_data);
3106:
3107:

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

3107:
3108: WHEN fnd_api.g_exc_unexpected_error THEN
3109: x_return_status := fnd_api.g_ret_sts_unexp_error;
3110: print_debuginfo('Exception : ' || SQLERRM);
3111: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3112: p_count => x_msg_count,
3113: p_data => x_msg_data);
3114:
3115:

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

3115:
3116: WHEN OTHERS THEN
3117: x_return_status := fnd_api.g_ret_sts_unexp_error;
3118: print_debuginfo('Exception : ' || SQLERRM);
3119: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);
3120:
3121: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3122: p_count => x_msg_count,
3123: p_data => x_msg_data);

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

3117: x_return_status := fnd_api.g_ret_sts_unexp_error;
3118: print_debuginfo('Exception : ' || SQLERRM);
3119: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);
3120:
3121: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3122: p_count => x_msg_count,
3123: p_data => x_msg_data);
3124:
3125:

Line 3240: FND_MSG_PUB.initialize;

3236: END IF;
3237:
3238: -- Initialize message list if p_init_msg_list is set to TRUE.
3239: IF FND_API.to_Boolean(p_init_msg_list) THEN
3240: FND_MSG_PUB.initialize;
3241: END IF;
3242:
3243: -- Initialize API return status to success
3244: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

3289: RETURNING INTERMEDIARY_ACCT_ID INTO x_intermediary_acct_id;
3290:
3291:
3292: -- get message count and if count is 1, get message info.
3293: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3294: p_count => x_msg_count,
3295: p_data => x_msg_data);
3296:
3297: print_debuginfo('RETURN ' || l_module_name);

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

3300: EXCEPTION
3301: WHEN fnd_api.g_exc_error THEN
3302: ROLLBACK TO create_intermediary_acct_pub;
3303: x_return_status := fnd_api.g_ret_sts_error;
3304: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3305: p_count => x_msg_count,
3306: p_data => x_msg_data);
3307:
3308:

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

3308:
3309: WHEN fnd_api.g_exc_unexpected_error THEN
3310: ROLLBACK TO create_intermediary_acct_pub;
3311: x_return_status := fnd_api.g_ret_sts_unexp_error;
3312: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3313: p_count => x_msg_count,
3314: p_data => x_msg_data);
3315:
3316:

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

3317: WHEN OTHERS THEN
3318: ROLLBACK TO create_intermediary_acct_pub;
3319: x_return_status := fnd_api.g_ret_sts_unexp_error;
3320: print_debuginfo('Exception : ' || SQLERRM);
3321: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);
3322:
3323: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3324: p_count => x_msg_count,
3325: p_data => x_msg_data);

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

3319: x_return_status := fnd_api.g_ret_sts_unexp_error;
3320: print_debuginfo('Exception : ' || SQLERRM);
3321: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);
3322:
3323: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3324: p_count => x_msg_count,
3325: p_data => x_msg_data);
3326:
3327:

Line 3380: FND_MSG_PUB.initialize;

3376: END IF;
3377:
3378: -- Initialize message list if p_init_msg_list is set to TRUE.
3379: IF FND_API.to_Boolean(p_init_msg_list) THEN
3380: FND_MSG_PUB.initialize;
3381: END IF;
3382:
3383: -- Initialize API return status to success
3384: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3397: fnd_msg_pub.add;

3393: OPEN c_ovn;
3394: FETCH c_ovn INTO l_old_ovn;
3395: IF c_ovn%NOTFOUND THEN
3396: fnd_message.set_name('IBY', 'IBY_API_NO_INTERMEDIARY_ACCT');
3397: fnd_msg_pub.add;
3398: x_return_status := fnd_api.g_ret_sts_error;
3399: CLOSE c_ovn;
3400: RAISE fnd_api.g_exc_error;
3401: END IF;

Line 3406: fnd_msg_pub.add;

3402: CLOSE c_ovn;
3403:
3404: IF l_old_ovn > p_intermed_acct_rec.object_version_number THEN
3405: fnd_message.set_name('IBY', 'IBY_DATA_VERSION_ERROR');
3406: fnd_msg_pub.add;
3407: x_return_status := fnd_api.g_ret_sts_error;
3408: RAISE fnd_api.g_exc_error;
3409: END IF;
3410:

Line 3432: fnd_msg_pub.add;

3428: RETURNING object_version_number INTO p_intermed_acct_rec.object_version_number;
3429:
3430: IF (SQL%NOTFOUND) THEN
3431: fnd_message.set_name('IBY', 'IBY_API_NO_INTERMEDIARY_ACCT');
3432: fnd_msg_pub.add;
3433: x_return_status := fnd_api.g_ret_sts_error;
3434: RAISE fnd_api.g_exc_error;
3435: END IF;
3436:

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

3436:
3437: -- END of API
3438:
3439: -- get message count and if count is 1, get message info.
3440: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3441: p_count => x_msg_count,
3442: p_data => x_msg_data);
3443:
3444: print_debuginfo('RETURN ' || l_module_name);

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

3446: EXCEPTION
3447: WHEN fnd_api.g_exc_error THEN
3448: ROLLBACK TO update_intermediary_bank_acct;
3449: x_return_status := fnd_api.g_ret_sts_error;
3450: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3451: p_count => x_msg_count,
3452: p_data => x_msg_data);
3453:
3454:

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

3454:
3455: WHEN fnd_api.g_exc_unexpected_error THEN
3456: ROLLBACK TO update_intermediary_bank_acct;
3457: x_return_status := fnd_api.g_ret_sts_unexp_error;
3458: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3459: p_count => x_msg_count,
3460: p_data => x_msg_data);
3461:
3462:

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

3462:
3463: WHEN OTHERS THEN
3464: ROLLBACK TO update_intermediary_bank_acct;
3465: x_return_status := fnd_api.g_ret_sts_unexp_error;
3466: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);
3467:
3468: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3469: p_count => x_msg_count,
3470: p_data => x_msg_data);

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

3464: ROLLBACK TO update_intermediary_bank_acct;
3465: x_return_status := fnd_api.g_ret_sts_unexp_error;
3466: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);
3467:
3468: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3469: p_count => x_msg_count,
3470: p_data => x_msg_data);
3471:
3472: END update_intermediary_acct;

Line 3528: FND_MSG_PUB.initialize;

3524: END IF;
3525:
3526: -- Initialize message list if p_init_msg_list is set to TRUE.
3527: IF FND_API.to_Boolean(p_init_msg_list) THEN
3528: FND_MSG_PUB.initialize;
3529: END IF;
3530:
3531: -- Initialize API return status to success
3532: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3545: fnd_msg_pub.add;

3541: CLOSE uniq_check;
3542:
3543: IF (l_count > 0) THEN
3544: fnd_message.set_name('IBY', 'IBY_ACCT_OWNER_EXISTS');
3545: fnd_msg_pub.add;
3546: RETURN;
3547: END IF;
3548:
3549: -- Insert Row in IBY_ACCOUNT_OWNERS

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

3576: 1.0
3577: ) RETURNING ACCOUNT_OWNER_ID INTO x_joint_acct_owner_id;
3578:
3579: -- get message count and if count is 1, get message info.
3580: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3581: p_count => x_msg_count,
3582: p_data => x_msg_data);
3583:
3584: print_debuginfo('RETURN ' || l_module_name);

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

3587: WHEN fnd_api.g_exc_error THEN
3588: ROLLBACK TO add_joint_account_owner;
3589: x_return_status := fnd_api.g_ret_sts_error;
3590: print_debuginfo('Exception : ' || SQLERRM);
3591: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3592: p_count => x_msg_count,
3593: p_data => x_msg_data);
3594:
3595:

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

3596: WHEN fnd_api.g_exc_unexpected_error THEN
3597: ROLLBACK TO add_joint_account_owner;
3598: x_return_status := fnd_api.g_ret_sts_unexp_error;
3599: print_debuginfo('Exception : ' || SQLERRM);
3600: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3601: p_count => x_msg_count,
3602: p_data => x_msg_data);
3603:
3604:

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

3605: WHEN OTHERS THEN
3606: ROLLBACK TO add_joint_account_owner;
3607: x_return_status := fnd_api.g_ret_sts_unexp_error;
3608: print_debuginfo('Exception : ' || SQLERRM);
3609: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);
3610:
3611: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3612: p_count => x_msg_count,
3613: p_data => x_msg_data);

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

3607: x_return_status := fnd_api.g_ret_sts_unexp_error;
3608: print_debuginfo('Exception : ' || SQLERRM);
3609: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);
3610:
3611: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3612: p_count => x_msg_count,
3613: p_data => x_msg_data);
3614:
3615: END add_joint_account_owner;

Line 3661: FND_MSG_PUB.initialize;

3657: END IF;
3658:
3659: -- Initialize message list if p_init_msg_list is set to TRUE.
3660: IF FND_API.to_Boolean(p_init_msg_list) THEN
3661: FND_MSG_PUB.initialize;
3662: END IF;
3663:
3664: -- Initialize API return status to success
3665: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

3688:
3689: -- End of API body
3690:
3691: -- get message count and if count is 1, get message info.
3692: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3693: p_count => x_msg_count,
3694: p_data => x_msg_data);
3695:
3696: print_debuginfo('RETURN ' || l_module_name);

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

3698: EXCEPTION
3699: WHEN fnd_api.g_exc_error THEN
3700: ROLLBACK TO set_acct_owner_end_date_pub;
3701: x_return_status := fnd_api.g_ret_sts_error;
3702: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3703: p_count => x_msg_count,
3704: p_data => x_msg_data);
3705:
3706:

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

3706:
3707: WHEN fnd_api.g_exc_unexpected_error THEN
3708: ROLLBACK TO set_acct_owner_end_date_pub;
3709: x_return_status := fnd_api.g_ret_sts_unexp_error;
3710: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3711: p_count => x_msg_count,
3712: p_data => x_msg_data);
3713:
3714:

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

3714:
3715: WHEN OTHERS THEN
3716: ROLLBACK TO set_acct_owner_end_date_pub;
3717: x_return_status := fnd_api.g_ret_sts_unexp_error;
3718: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);
3719: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3720: p_count => x_msg_count,
3721: p_data => x_msg_data);
3722:

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

3715: WHEN OTHERS THEN
3716: ROLLBACK TO set_acct_owner_end_date_pub;
3717: x_return_status := fnd_api.g_ret_sts_unexp_error;
3718: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);
3719: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3720: p_count => x_msg_count,
3721: p_data => x_msg_data);
3722:
3723:

Line 3778: FND_MSG_PUB.initialize;

3774: END IF;
3775:
3776: -- Initialize message list if p_init_msg_list is set to TRUE.
3777: IF FND_API.to_Boolean(p_init_msg_list) THEN
3778: FND_MSG_PUB.initialize;
3779: END IF;
3780:
3781: -- Initialize API return status to success
3782: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

3811:
3812: -- End of API body
3813:
3814: -- get message count and if count is 1, get message info.
3815: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3816: p_count => x_msg_count,
3817: p_data => x_msg_data);
3818:
3819: print_debuginfo('RETURN ' || l_module_name);

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

3821: WHEN fnd_api.g_exc_error THEN
3822: ROLLBACK TO change_primary_acct_owner_pub;
3823: x_return_status := fnd_api.g_ret_sts_error;
3824: print_debuginfo('Exception : ' || SQLERRM);
3825: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3826: p_count => x_msg_count,
3827: p_data => x_msg_data);
3828:
3829:

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

3830: WHEN fnd_api.g_exc_unexpected_error THEN
3831: ROLLBACK TO change_primary_acct_owner_pub;
3832: x_return_status := fnd_api.g_ret_sts_unexp_error;
3833: print_debuginfo('Exception : ' || SQLERRM);
3834: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3835: p_count => x_msg_count,
3836: p_data => x_msg_data);
3837:
3838:

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

3839: WHEN OTHERS THEN
3840: ROLLBACK TO change_primary_acct_owner_pub;
3841: x_return_status := fnd_api.g_ret_sts_unexp_error;
3842: print_debuginfo('Exception : ' || SQLERRM);
3843: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);
3844:
3845: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3846: p_count => x_msg_count,
3847: p_data => x_msg_data);

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

3841: x_return_status := fnd_api.g_ret_sts_unexp_error;
3842: print_debuginfo('Exception : ' || SQLERRM);
3843: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);
3844:
3845: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3846: p_count => x_msg_count,
3847: p_data => x_msg_data);
3848:
3849: END change_primary_acct_owner;

Line 3882: fnd_msg_pub.add;

3878: OPEN c_country;
3879: FETCH c_country INTO l_country;
3880: IF c_country%NOTFOUND THEN
3881: fnd_message.set_name('IBY', 'IBY_API_NO_BANK');
3882: fnd_msg_pub.add;
3883: x_return_status := fnd_api.g_ret_sts_error;
3884: END IF;
3885: CLOSE c_country;
3886:

Line 3968: fnd_msg_pub.add;

3964: OPEN c_bank;
3965: FETCH c_bank INTO x_bank_id, x_country_code, x_bank_name, x_bank_number;
3966: IF c_bank%NOTFOUND THEN
3967: fnd_message.set_name('IBY', 'IBY_API_NO_BANK');
3968: fnd_msg_pub.add;
3969: x_return_status := fnd_api.g_ret_sts_error;
3970: END IF;
3971: CLOSE c_bank;
3972:

Line 4006: fnd_msg_pub.add;

4002:
4003: if (p_value is NULL) THEN
4004: fnd_message.set_name('IBY', 'IBY_MISSING_MANDATORY_PARAM');
4005: fnd_message.set_token('PARAM', p_field);
4006: fnd_msg_pub.add;
4007: print_debuginfo(p_field || ' is a required parameter.');
4008: RAISE fnd_api.g_exc_error;
4009: END IF;
4010:

Line 4021: fnd_msg_pub.add;

4017:
4018: IF (l_temp IS NULL) THEN
4019: fnd_message.set_name('IBY', 'IBY_INVALID_CURRENCY');
4020: fnd_message.set_token('CURRENCY_CODE', p_field);
4021: fnd_msg_pub.add;
4022: RAISE fnd_api.g_exc_error;
4023: END IF;
4024:
4025: END IF;