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_API

Line 99: IF NOT FND_API.Compatible_API_Call(l_api_version,

95:
96: SAVEPOINT create_bank_pub;
97:
98: -- Standard call to check for call compatibility.
99: IF NOT FND_API.Compatible_API_Call(l_api_version,
100: p_api_version,
101: l_api_name,
102: G_PKG_NAME) THEN
103: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 103: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

99: IF NOT FND_API.Compatible_API_Call(l_api_version,
100: p_api_version,
101: l_api_name,
102: G_PKG_NAME) THEN
103: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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

Line 107: IF FND_API.to_Boolean(p_init_msg_list) THEN

103: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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

Line 112: x_return_status := FND_API.G_RET_STS_SUCCESS;

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;
113:
114: -- Start of API body
115:
116: -- Parameter validations

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 195: WHEN fnd_api.g_exc_error THEN

191:
192: print_debuginfo('RETURN ' || l_module_name);
193:
194: EXCEPTION
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,

Line 197: x_return_status := fnd_api.g_ret_sts_error;

193:
194: EXCEPTION
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);

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 204: WHEN fnd_api.g_exc_unexpected_error THEN

200: p_count => x_msg_count,
201: p_data => x_msg_data);
202:
203:
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,

Line 206: x_return_status := fnd_api.g_ret_sts_unexp_error;

202:
203:
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);

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 215: x_return_status := fnd_api.g_ret_sts_unexp_error;

211:
212:
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,

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 259: IF NOT FND_API.Compatible_API_Call(l_api_version,

255:
256: SAVEPOINT update_bank_pub;
257:
258: -- Standard call to check for call compatibility.
259: IF NOT FND_API.Compatible_API_Call(l_api_version,
260: p_api_version,
261: l_api_name,
262: G_PKG_NAME) THEN
263: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 263: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

259: IF NOT FND_API.Compatible_API_Call(l_api_version,
260: p_api_version,
261: l_api_name,
262: G_PKG_NAME) THEN
263: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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

Line 267: IF FND_API.to_Boolean(p_init_msg_list) THEN

263: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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

Line 272: x_return_status := FND_API.G_RET_STS_SUCCESS;

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;
273:
274: -- Start of API body
275:
276: -- Parameter validations

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 333: WHEN fnd_api.g_exc_error THEN

329:
330: print_debuginfo('RETURN ' || l_module_name);
331:
332: EXCEPTION
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,

Line 335: x_return_status := fnd_api.g_ret_sts_error;

331:
332: EXCEPTION
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);

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 342: WHEN fnd_api.g_exc_unexpected_error THEN

338: p_count => x_msg_count,
339: p_data => x_msg_data);
340:
341:
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,

Line 344: x_return_status := fnd_api.g_ret_sts_unexp_error;

340:
341:
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);

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 353: x_return_status := fnd_api.g_ret_sts_unexp_error;

349:
350:
351: WHEN OTHERS THEN
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,

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 404: IF NOT FND_API.Compatible_API_Call(l_api_version,

400:
401: SAVEPOINT set_bank_end_date_pub;
402:
403: -- Standard call to check for call compatibility.
404: IF NOT FND_API.Compatible_API_Call(l_api_version,
405: p_api_version,
406: l_api_name,
407: G_PKG_NAME) THEN
408: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 408: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

404: IF NOT FND_API.Compatible_API_Call(l_api_version,
405: p_api_version,
406: l_api_name,
407: G_PKG_NAME) THEN
408: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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

Line 412: IF FND_API.to_Boolean(p_init_msg_list) THEN

408: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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

Line 417: x_return_status := FND_API.G_RET_STS_SUCCESS;

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;
418:
419: -- Start of API body
420:
421: -- Parameter validations

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 451: WHEN fnd_api.g_exc_error THEN

447: p_data => x_msg_data);
448:
449: print_debuginfo('RETURN ' || l_module_name);
450: EXCEPTION
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,

Line 453: x_return_status := fnd_api.g_ret_sts_error;

449: print_debuginfo('RETURN ' || l_module_name);
450: EXCEPTION
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);

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 460: WHEN fnd_api.g_exc_unexpected_error THEN

456: p_count => x_msg_count,
457: p_data => x_msg_data);
458:
459:
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,

Line 462: x_return_status := fnd_api.g_ret_sts_unexp_error;

458:
459:
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);

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 471: x_return_status := fnd_api.g_ret_sts_unexp_error;

467:
468:
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,

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 516: IF NOT FND_API.Compatible_API_Call(l_api_version,

512:
513: print_debuginfo('ENTER ' || l_module_name);
514:
515: -- Standard call to check for call compatibility.
516: IF NOT FND_API.Compatible_API_Call(l_api_version,
517: p_api_version,
518: l_api_name,
519: G_PKG_NAME) THEN
520: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 520: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

516: IF NOT FND_API.Compatible_API_Call(l_api_version,
517: p_api_version,
518: l_api_name,
519: G_PKG_NAME) THEN
520: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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

Line 524: IF FND_API.to_Boolean(p_init_msg_list) THEN

520: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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

Line 529: x_return_status := FND_API.G_RET_STS_SUCCESS;

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;
530:
531: -- Start of API body
532:
533: print_debuginfo('Before Call to CE_BANK_PUB.check_bank_exist ');

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 554: WHEN fnd_api.g_exc_error THEN

550: p_data => x_msg_data);
551:
552: print_debuginfo('RETURN ' || l_module_name);
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,

Line 555: x_return_status := fnd_api.g_ret_sts_error;

551:
552: print_debuginfo('RETURN ' || l_module_name);
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);

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 562: WHEN fnd_api.g_exc_unexpected_error THEN

558: p_count => x_msg_count,
559: p_data => x_msg_data);
560:
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,

Line 563: x_return_status := fnd_api.g_ret_sts_unexp_error;

559: p_data => x_msg_data);
560:
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);

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 571: x_return_status := fnd_api.g_ret_sts_unexp_error;

567: p_data => x_msg_data);
568:
569:
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:

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 615: IF NOT FND_API.Compatible_API_Call(l_api_version,

611:
612: SAVEPOINT create_bank_branch_pub;
613:
614: -- Standard call to check for call compatibility.
615: IF NOT FND_API.Compatible_API_Call(l_api_version,
616: p_api_version,
617: l_api_name,
618: G_PKG_NAME) THEN
619: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 619: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

615: IF NOT FND_API.Compatible_API_Call(l_api_version,
616: p_api_version,
617: l_api_name,
618: G_PKG_NAME) THEN
619: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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

Line 623: IF FND_API.to_Boolean(p_init_msg_list) THEN

619: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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

Line 628: x_return_status := FND_API.G_RET_STS_SUCCESS;

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;
629:
630: -- Start of API body
631:
632: -- Parameter validations

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 696: WHEN fnd_api.g_exc_error THEN

692:
693: print_debuginfo('RETURN ' || l_module_name);
694:
695: EXCEPTION
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,

Line 698: x_return_status := fnd_api.g_ret_sts_error;

694:
695: EXCEPTION
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);

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 705: WHEN fnd_api.g_exc_unexpected_error THEN

701: p_count => x_msg_count,
702: p_data => x_msg_data);
703:
704:
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,

Line 707: x_return_status := fnd_api.g_ret_sts_unexp_error;

703:
704:
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);

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 716: x_return_status := fnd_api.g_ret_sts_unexp_error;

712:
713:
714: WHEN OTHERS THEN
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,

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 776: IF NOT FND_API.Compatible_API_Call(l_api_version,

772:
773: SAVEPOINT update_bank_branch_pub;
774:
775: -- Standard call to check for call compatibility.
776: IF NOT FND_API.Compatible_API_Call(l_api_version,
777: p_api_version,
778: l_api_name,
779: G_PKG_NAME) THEN
780: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 780: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

776: IF NOT FND_API.Compatible_API_Call(l_api_version,
777: p_api_version,
778: l_api_name,
779: G_PKG_NAME) THEN
780: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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

Line 784: IF FND_API.to_Boolean(p_init_msg_list) THEN

780: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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

Line 789: x_return_status := FND_API.G_RET_STS_SUCCESS;

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;
790:
791: -- Start of API Body
792:
793: -- Parameter validations

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 896: WHEN fnd_api.g_exc_error THEN

892:
893: print_debuginfo('RETURN ' || l_module_name);
894:
895: EXCEPTION
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,

Line 898: x_return_status := fnd_api.g_ret_sts_error;

894:
895: EXCEPTION
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);

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 905: WHEN fnd_api.g_exc_unexpected_error THEN

901: p_count => x_msg_count,
902: p_data => x_msg_data);
903:
904:
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,

Line 907: x_return_status := fnd_api.g_ret_sts_unexp_error;

903:
904:
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);

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 916: x_return_status := fnd_api.g_ret_sts_unexp_error;

912:
913:
914: WHEN OTHERS THEN
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,

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 967: IF NOT FND_API.Compatible_API_Call(l_api_version,

963:
964: SAVEPOINT set_ext_branch_end_date_pub;
965:
966: -- Standard call to check for call compatibility.
967: IF NOT FND_API.Compatible_API_Call(l_api_version,
968: p_api_version,
969: l_api_name,
970: G_PKG_NAME) THEN
971: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 971: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

967: IF NOT FND_API.Compatible_API_Call(l_api_version,
968: p_api_version,
969: l_api_name,
970: G_PKG_NAME) THEN
971: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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

Line 975: IF FND_API.to_Boolean(p_init_msg_list) THEN

971: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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

Line 980: x_return_status := FND_API.G_RET_STS_SUCCESS;

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;
981:
982: -- Start of API body
983:
984: -- Parameter validations

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 1014: WHEN fnd_api.g_exc_error THEN

1010: p_data => x_msg_data);
1011:
1012: print_debuginfo('RETURN ' || l_module_name);
1013: EXCEPTION
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,

Line 1016: x_return_status := fnd_api.g_ret_sts_error;

1012: print_debuginfo('RETURN ' || l_module_name);
1013: EXCEPTION
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);

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 1023: WHEN fnd_api.g_exc_unexpected_error THEN

1019: p_count => x_msg_count,
1020: p_data => x_msg_data);
1021:
1022:
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,

Line 1025: x_return_status := fnd_api.g_ret_sts_unexp_error;

1021:
1022:
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);

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 1034: x_return_status := fnd_api.g_ret_sts_unexp_error;

1030:
1031:
1032: WHEN OTHERS THEN
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,

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 1081: IF NOT FND_API.Compatible_API_Call(l_api_version,

1077:
1078: print_debuginfo('ENTER ' || l_module_name);
1079:
1080: -- Standard call to check for call compatibility.
1081: IF NOT FND_API.Compatible_API_Call(l_api_version,
1082: p_api_version,
1083: l_api_name,
1084: G_PKG_NAME) THEN
1085: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1085: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1081: IF NOT FND_API.Compatible_API_Call(l_api_version,
1082: p_api_version,
1083: l_api_name,
1084: G_PKG_NAME) THEN
1085: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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

Line 1089: IF FND_API.to_Boolean(p_init_msg_list) THEN

1085: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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

Line 1094: x_return_status := FND_API.G_RET_STS_SUCCESS;

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;
1095:
1096: -- Start of API body
1097:
1098: print_debuginfo('Before Call to CE_BANK_PUB.check_branch_exist ');

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 1120: WHEN fnd_api.g_exc_error THEN

1116:
1117: print_debuginfo('RETURN ' || l_module_name);
1118:
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,

Line 1121: x_return_status := fnd_api.g_ret_sts_error;

1117: print_debuginfo('RETURN ' || l_module_name);
1118:
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);

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 1128: WHEN fnd_api.g_exc_unexpected_error THEN

1124: p_count => x_msg_count,
1125: p_data => x_msg_data);
1126:
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,

Line 1129: x_return_status := fnd_api.g_ret_sts_unexp_error;

1125: p_data => x_msg_data);
1126:
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);

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 1137: x_return_status := fnd_api.g_ret_sts_unexp_error;

1133: p_data => x_msg_data);
1134:
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,

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 1232: IF NOT FND_API.Compatible_API_Call(l_api_version,

1228:
1229: SAVEPOINT create_ext_bank_acct_pub;
1230:
1231: -- Standard call to check for call compatibility.
1232: IF NOT FND_API.Compatible_API_Call(l_api_version,
1233: p_api_version,
1234: l_api_name,
1235: G_PKG_NAME) THEN
1236: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1236: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1232: IF NOT FND_API.Compatible_API_Call(l_api_version,
1233: p_api_version,
1234: l_api_name,
1235: G_PKG_NAME) THEN
1236: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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

Line 1240: IF FND_API.to_Boolean(p_init_msg_list) THEN

1236: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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

Line 1245: x_return_status := FND_API.G_RET_STS_SUCCESS;

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;
1246:
1247: -- Start of API
1248:
1249: -- Parameter validations

Line 1268: IF not x_return_status=fnd_api.g_ret_sts_success

1264:
1265: -- validate iban
1266: IF p_ext_bank_acct_rec.iban IS NOT NULL THEN
1267: CE_BANK_AND_ACCOUNT_VALIDATION.validate_IBAN(p_ext_bank_acct_rec.iban, l_iban, x_return_status);
1268: IF not x_return_status=fnd_api.g_ret_sts_success
1269: THEN
1270: x_return_status := fnd_api.g_ret_sts_error;
1271: print_debuginfo('IBAN Validation Failed ');
1272: RAISE fnd_api.g_exc_error;

Line 1270: x_return_status := fnd_api.g_ret_sts_error;

1266: IF p_ext_bank_acct_rec.iban IS NOT NULL THEN
1267: CE_BANK_AND_ACCOUNT_VALIDATION.validate_IBAN(p_ext_bank_acct_rec.iban, l_iban, x_return_status);
1268: IF not x_return_status=fnd_api.g_ret_sts_success
1269: THEN
1270: x_return_status := fnd_api.g_ret_sts_error;
1271: print_debuginfo('IBAN Validation Failed ');
1272: RAISE fnd_api.g_exc_error;
1273: ELSE
1274: print_debuginfo('IBAN Validation Successful');

Line 1272: RAISE fnd_api.g_exc_error;

1268: IF not x_return_status=fnd_api.g_ret_sts_success
1269: THEN
1270: x_return_status := fnd_api.g_ret_sts_error;
1271: print_debuginfo('IBAN Validation Failed ');
1272: RAISE fnd_api.g_exc_error;
1273: ELSE
1274: print_debuginfo('IBAN Validation Successful');
1275: END IF;
1276: print_debuginfo('Validated IBAN Number');

Line 1292: x_return_status := fnd_api.g_ret_sts_error;

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);
1296: END IF;

Line 1293: RAISE fnd_api.g_exc_error;

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);
1296: END IF;
1297: CLOSE c_branch;

Line 1321: IF ((not x_return_status = fnd_api.g_ret_sts_success) OR

1317: );
1318:
1319: print_debuginfo('Return status from check exist:'||x_return_status);
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);

Line 1335: x_return_status := fnd_api.g_ret_sts_error;

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');
1337: RAISE fnd_api.g_exc_error;
1338: END IF;
1339:

Line 1337: RAISE fnd_api.g_exc_error;

1333: END IF;
1334: CLOSE c_supplier;
1335: x_return_status := fnd_api.g_ret_sts_error;
1336: print_debuginfo('Error : Duplicate Bank Account');
1337: RAISE fnd_api.g_exc_error;
1338: END IF;
1339:
1340: -- country specific validation API call here.
1341: -- delete the message as CE using message count for error

Line 1382: FND_API.G_FALSE,

1378: p_ext_bank_acct_rec.check_digits,
1379: l_bank_number,
1380: l_branch_number,
1381: p_ext_bank_acct_rec.bank_account_num,
1382: FND_API.G_FALSE,
1383: x_msg_count,
1384: x_msg_data,
1385: x_return_status,
1386: 'EXTERNAL');

Line 1402: FND_API.G_FALSE,

1398: p_ext_bank_acct_rec.acct_type,
1399: p_ext_bank_acct_rec.acct_suffix,
1400: null, -- p_secondary_acct_reference,
1401: p_ext_bank_acct_rec.bank_account_name,
1402: FND_API.G_FALSE,
1403: x_msg_count,
1404: x_msg_data,
1405: l_account_number,
1406: x_return_status,

Line 1413: IF not x_return_status=fnd_api.g_ret_sts_success THEN

1409: l_bank_account_num_electronic);
1410:
1411: print_debuginfo('Returned from Country Specific Account Validations');
1412:
1413: IF not x_return_status=fnd_api.g_ret_sts_success THEN
1414: x_return_status := fnd_api.g_ret_sts_error;
1415: print_debuginfo('Account Validations Failed ');
1416: return;
1417: ELSE

Line 1414: x_return_status := fnd_api.g_ret_sts_error;

1410:
1411: print_debuginfo('Returned from Country Specific Account Validations');
1412:
1413: IF not x_return_status=fnd_api.g_ret_sts_success THEN
1414: x_return_status := fnd_api.g_ret_sts_error;
1415: print_debuginfo('Account Validations Failed ');
1416: return;
1417: ELSE
1418: print_debuginfo('Account Validations Successful');

Line 1581: RAISE fnd_api.g_exc_unexpected_error;

1577: IF (SQL%FOUND) THEN
1578: print_debuginfo('New Row inserted in IBY_EXT_BANK_ACCOUNTS');
1579: ELSE
1580: print_debuginfo('Failed to insert in IBY_EXT_BANK_ACCOUNTS');
1581: RAISE fnd_api.g_exc_unexpected_error;
1582: END IF;
1583:
1584: -- End of API
1585:

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 1625: WHEN fnd_api.g_exc_error THEN

1621: print_debuginfo('RETURN ' || l_module_name);
1622:
1623:
1624: EXCEPTION
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,

Line 1627: x_return_status := fnd_api.g_ret_sts_error;

1623:
1624: EXCEPTION
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);

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 1634: WHEN fnd_api.g_exc_unexpected_error THEN

1630: p_count => x_msg_count,
1631: p_data => x_msg_data);
1632:
1633:
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,

Line 1636: x_return_status := fnd_api.g_ret_sts_unexp_error;

1632:
1633:
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);

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 1646: x_return_status := fnd_api.g_ret_sts_unexp_error;

1642:
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,

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 1829: WHEN FND_API.G_EXC_ERROR THEN

1825:
1826: print_debuginfo('Exit '||l_module);
1827: EXCEPTION
1828:
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,

Line 1831: x_return_status := fnd_api.g_ret_sts_error;

1827: EXCEPTION
1828:
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);

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 1836: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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;
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,

Line 1838: x_return_status := fnd_api.g_ret_sts_unexp_error;

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;
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);

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 1845: x_return_status := FND_API.G_RET_STS_ERROR ;

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;
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);

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 1852: x_return_status := FND_API.G_RET_STS_ERROR ;

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;
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);

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 1859: x_return_status := FND_API.G_RET_STS_ERROR ;

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;
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);

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 1866: x_return_status := FND_API.G_RET_STS_ERROR ;

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;
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);

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 1873: x_return_status := fnd_api.g_ret_sts_unexp_error;

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;
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,

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 2008: IF NOT FND_API.Compatible_API_Call(l_api_version,

2004:
2005: SAVEPOINT update_ext_bank_acct_pub;
2006:
2007: -- Standard call to check for call compatibility.
2008: IF NOT FND_API.Compatible_API_Call(l_api_version,
2009: p_api_version,
2010: l_api_name,
2011: G_PKG_NAME) THEN
2012: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2012: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2008: IF NOT FND_API.Compatible_API_Call(l_api_version,
2009: p_api_version,
2010: l_api_name,
2011: G_PKG_NAME) THEN
2012: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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

Line 2016: IF FND_API.to_Boolean(p_init_msg_list) THEN

2012: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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

Line 2021: x_return_status := FND_API.G_RET_STS_SUCCESS;

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;
2022:
2023: -- Start of API Body
2024:
2025: -- Parameter validations

Line 2049: x_return_status := fnd_api.g_ret_sts_error;

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;
2053: CLOSE c_ovn;

Line 2051: RAISE fnd_api.g_exc_error;

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;
2053: CLOSE c_ovn;
2054: print_debuginfo('Current object_version_number Version Number ' || l_old_ovn);
2055:

Line 2059: x_return_status := fnd_api.g_ret_sts_error;

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;
2063: -- no need for unique check

Line 2061: RAISE fnd_api.g_exc_error;

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;
2063: -- no need for unique check
2064: -- perform unique check for account
2065: -- passing in the ext bank account id to the query for unique check

Line 2077: x_return_status := fnd_api.g_ret_sts_error;

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;
2081:

Line 2078: RAISE fnd_api.g_exc_error;

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;
2081:
2082:

Line 2086: IF ((not x_return_status = fnd_api.g_ret_sts_success) OR

2082:
2083:
2084: print_debuginfo('Return status from check exist:'||x_return_status);
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;

Line 2090: x_return_status := fnd_api.g_ret_sts_error;

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;
2094:

Line 2092: RAISE fnd_api.g_exc_error;

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;
2094:
2095: */
2096:

Line 2210: IF x_return_status=fnd_api.g_ret_sts_success THEN

2206: IF(NOT l_iban IS NULL) THEN
2207: CE_BANK_AND_ACCOUNT_VALIDATION.validate_IBAN
2208: (p_ext_bank_acct_rec.iban, l_iban, x_return_status);
2209: -- throw exception???
2210: IF x_return_status=fnd_api.g_ret_sts_success THEN
2211: l_iban :=p_ext_bank_acct_rec.iban;
2212: END IF;
2213: print_debuginfo('Validated IBAN Number');
2214: print_debuginfo(x_return_status);

Line 2269: IF ((not x_return_status = fnd_api.g_ret_sts_success) OR

2265: );
2266:
2267: print_debuginfo('Return status from check exist:'||x_return_status);
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);

Line 2283: x_return_status := fnd_api.g_ret_sts_error;

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');
2285: RAISE fnd_api.g_exc_error;
2286: END IF;
2287:

Line 2285: RAISE fnd_api.g_exc_error;

2281: END IF;
2282: CLOSE c_supplier;
2283: x_return_status := fnd_api.g_ret_sts_error;
2284: print_debuginfo('Error : Duplicate Bank Account');
2285: RAISE fnd_api.g_exc_error;
2286: END IF;
2287:
2288: -- country specific validation API call here.
2289: -- delete the message as CE using message count for error

Line 2312: FND_API.G_FALSE,

2308: p_ext_bank_acct_rec.check_digits,
2309: l_bank_number,
2310: l_branch_number,
2311: p_ext_bank_acct_rec.bank_account_num,
2312: FND_API.G_FALSE,
2313: x_msg_count,
2314: x_msg_data,
2315: x_return_status,
2316: 'EXTERNAL');

Line 2321: IF not x_return_status=fnd_api.g_ret_sts_success THEN

2317:
2318: print_debuginfo('Returned from Country Specific Check Digit Validations status:' || x_return_status);
2319: print_debuginfo('After Country Specific validations, l_masked_ba_num:'||
2320: l_masked_ba_num);
2321: IF not x_return_status=fnd_api.g_ret_sts_success THEN
2322:
2323: x_return_status := fnd_api.g_ret_sts_error;
2324: print_debuginfo('Account Validations Failed ');
2325: return;

Line 2323: x_return_status := fnd_api.g_ret_sts_error;

2319: print_debuginfo('After Country Specific validations, l_masked_ba_num:'||
2320: l_masked_ba_num);
2321: IF not x_return_status=fnd_api.g_ret_sts_success THEN
2322:
2323: x_return_status := fnd_api.g_ret_sts_error;
2324: print_debuginfo('Account Validations Failed ');
2325: return;
2326: ELSE
2327: print_debuginfo('Account Validations Successful');

Line 2343: FND_API.G_FALSE,

2339: p_ext_bank_acct_rec.acct_type,
2340: p_ext_bank_acct_rec.acct_suffix,
2341: null, -- p_secondary_acct_reference,
2342: p_ext_bank_acct_rec.bank_account_name,
2343: FND_API.G_FALSE,
2344: x_msg_count,
2345: x_msg_data,
2346: l_acct_number,
2347: x_return_status,

Line 2355: IF not x_return_status=fnd_api.g_ret_sts_success THEN

2351:
2352: print_debuginfo('Returned from Account Validations' || x_return_status);
2353: print_debuginfo('After CE s UPD_ACCOUNT_VALIDATE'||
2354: 'l_masked_ba_num:'||l_masked_ba_num);
2355: IF not x_return_status=fnd_api.g_ret_sts_success THEN
2356: x_return_status := fnd_api.g_ret_sts_error;
2357: print_debuginfo('Account Validations Failed ');
2358: return;
2359: ELSE

Line 2356: x_return_status := fnd_api.g_ret_sts_error;

2352: print_debuginfo('Returned from Account Validations' || x_return_status);
2353: print_debuginfo('After CE s UPD_ACCOUNT_VALIDATE'||
2354: 'l_masked_ba_num:'||l_masked_ba_num);
2355: IF not x_return_status=fnd_api.g_ret_sts_success THEN
2356: x_return_status := fnd_api.g_ret_sts_error;
2357: print_debuginfo('Account Validations Failed ');
2358: return;
2359: ELSE
2360: print_debuginfo('Account Validations Successful');

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 2435: WHEN fnd_api.g_exc_error THEN

2431:
2432: print_debuginfo('RETURN ' || l_module_name);
2433:
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,

Line 2437: x_return_status := fnd_api.g_ret_sts_error;

2433:
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:

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 2443: WHEN fnd_api.g_exc_unexpected_error THEN

2439: p_count => x_msg_count,
2440: p_data => x_msg_data);
2441:
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,

Line 2445: x_return_status := fnd_api.g_ret_sts_unexp_error;

2441:
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:

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 2453: x_return_status := fnd_api.g_ret_sts_unexp_error;

2449:
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,

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 2570: IF NOT FND_API.Compatible_API_Call(l_api_version,

2566:
2567: print_debuginfo('ENTER ' || l_module_name);
2568:
2569: -- Standard call to check for call compatibility.
2570: IF NOT FND_API.Compatible_API_Call(l_api_version,
2571: p_api_version,
2572: l_api_name,
2573: G_PKG_NAME) THEN
2574: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2574: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2570: IF NOT FND_API.Compatible_API_Call(l_api_version,
2571: p_api_version,
2572: l_api_name,
2573: G_PKG_NAME) THEN
2574: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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

Line 2578: IF FND_API.to_Boolean(p_init_msg_list) THEN

2574: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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

Line 2583: x_return_status := FND_API.G_RET_STS_SUCCESS;

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;
2584:
2585: -- Start of API body
2586:
2587: check_mandatory('Bank Account Id', p_bankacct_id);

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 2654: WHEN fnd_api.g_exc_error THEN

2650: p_data => x_msg_data);
2651:
2652: print_debuginfo('RETURN ' || l_module_name);
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,

Line 2655: x_return_status := fnd_api.g_ret_sts_error;

2651:
2652: print_debuginfo('RETURN ' || l_module_name);
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);

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 2662: WHEN fnd_api.g_exc_unexpected_error THEN

2658: p_count => x_msg_count,
2659: p_data => x_msg_data);
2660:
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,

Line 2663: x_return_status := fnd_api.g_ret_sts_unexp_error;

2659: p_data => x_msg_data);
2660:
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);

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 2671: x_return_status := fnd_api.g_ret_sts_unexp_error;

2667: p_data => x_msg_data);
2668:
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,

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 2717: IF NOT FND_API.Compatible_API_Call(l_api_version,

2713:
2714: SAVEPOINT get_ext_bank_acct_pub;
2715:
2716: -- Standard call to check for call compatibility.
2717: IF NOT FND_API.Compatible_API_Call(l_api_version,
2718: p_api_version,
2719: l_api_name,
2720: G_PKG_NAME) THEN
2721: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2721: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2717: IF NOT FND_API.Compatible_API_Call(l_api_version,
2718: p_api_version,
2719: l_api_name,
2720: G_PKG_NAME) THEN
2721: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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

Line 2725: IF FND_API.to_Boolean(p_init_msg_list) THEN

2721: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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

Line 2730: x_return_status := FND_API.G_RET_STS_SUCCESS;

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;
2731:
2732: -- Start of API body
2733:
2734: --

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 2757: WHEN fnd_api.g_exc_error THEN

2753: p_data => x_msg_data);
2754:
2755: print_debuginfo('RETURN ' || l_module_name);
2756: EXCEPTION
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,

Line 2759: x_return_status := fnd_api.g_ret_sts_error;

2755: print_debuginfo('RETURN ' || l_module_name);
2756: EXCEPTION
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);

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 2766: WHEN fnd_api.g_exc_unexpected_error THEN

2762: p_count => x_msg_count,
2763: p_data => x_msg_data);
2764:
2765:
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,

Line 2768: x_return_status := fnd_api.g_ret_sts_unexp_error;

2764:
2765:
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);

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 2777: x_return_status := fnd_api.g_ret_sts_unexp_error;

2773:
2774:
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,

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 2823: IF NOT FND_API.Compatible_API_Call(l_api_version,

2819:
2820: SAVEPOINT set_ext_bank_acct_dates_pub;
2821:
2822: -- Standard call to check for call compatibility.
2823: IF NOT FND_API.Compatible_API_Call(l_api_version,
2824: p_api_version,
2825: l_api_name,
2826: G_PKG_NAME) THEN
2827: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2827: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2823: IF NOT FND_API.Compatible_API_Call(l_api_version,
2824: p_api_version,
2825: l_api_name,
2826: G_PKG_NAME) THEN
2827: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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

Line 2831: IF FND_API.to_Boolean(p_init_msg_list) THEN

2827: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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

Line 2836: x_return_status := FND_API.G_RET_STS_SUCCESS;

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;
2837:
2838: -- Start of API body
2839:
2840: -- Parameter validations

Line 2852: RAISE fnd_api.g_exc_error;

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
2856: UPDATE IBY_EXT_BANK_ACCOUNTS

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 2876: WHEN fnd_api.g_exc_error THEN

2872:
2873: print_debuginfo('RETURN ' || l_module_name);
2874:
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,

Line 2878: x_return_status := fnd_api.g_ret_sts_error;

2874:
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:

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 2884: WHEN fnd_api.g_exc_unexpected_error THEN

2880: p_count => x_msg_count,
2881: p_data => x_msg_data);
2882:
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,

Line 2886: x_return_status := fnd_api.g_ret_sts_unexp_error;

2882:
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:

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 2894: x_return_status := fnd_api.g_ret_sts_unexp_error;

2890:
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);

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 3031: IF NOT FND_API.Compatible_API_Call(l_api_version,

3027: print_debuginfo('external_bank_account_id:'|| p_ext_bank_acct_rec.bank_account_id);
3028:
3029:
3030: -- Standard call to check for call compatibility.
3031: IF NOT FND_API.Compatible_API_Call(l_api_version,
3032: p_api_version,
3033: l_api_name,
3034: G_PKG_NAME) THEN
3035: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3035: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3031: IF NOT FND_API.Compatible_API_Call(l_api_version,
3032: p_api_version,
3033: l_api_name,
3034: G_PKG_NAME) THEN
3035: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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

Line 3039: IF FND_API.to_Boolean(p_init_msg_list) THEN

3035: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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

Line 3044: x_return_status := FND_API.G_RET_STS_SUCCESS;

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;
3045:
3046: -- Parameter validations
3047:
3048: IF (p_ext_bank_acct_rec.bank_id is not null) THEN

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 3100: WHEN fnd_api.g_exc_error THEN

3096:
3097: print_debuginfo('RETURN ' || l_module_name);
3098:
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,

Line 3101: x_return_status := fnd_api.g_ret_sts_error;

3097: print_debuginfo('RETURN ' || l_module_name);
3098:
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);

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 3108: WHEN fnd_api.g_exc_unexpected_error THEN

3104: p_count => x_msg_count,
3105: p_data => x_msg_data);
3106:
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,

Line 3109: x_return_status := fnd_api.g_ret_sts_unexp_error;

3105: p_data => x_msg_data);
3106:
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);

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 3117: x_return_status := fnd_api.g_ret_sts_unexp_error;

3113: p_data => x_msg_data);
3114:
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,

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 3231: IF NOT FND_API.Compatible_API_Call(l_api_version,

3227:
3228: SAVEPOINT create_intermediary_acct_pub;
3229:
3230: -- Standard call to check for call compatibility.
3231: IF NOT FND_API.Compatible_API_Call(l_api_version,
3232: p_api_version,
3233: l_api_name,
3234: G_PKG_NAME) THEN
3235: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3235: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3231: IF NOT FND_API.Compatible_API_Call(l_api_version,
3232: p_api_version,
3233: l_api_name,
3234: G_PKG_NAME) THEN
3235: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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

Line 3239: IF FND_API.to_Boolean(p_init_msg_list) THEN

3235: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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

Line 3244: x_return_status := FND_API.G_RET_STS_SUCCESS;

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;
3245:
3246: -- Parameter validations
3247: check_mandatory('Bank Account Id', p_intermed_acct_rec.bank_account_id);
3248:

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 3301: WHEN fnd_api.g_exc_error THEN

3297: print_debuginfo('RETURN ' || l_module_name);
3298:
3299:
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,

Line 3303: x_return_status := fnd_api.g_ret_sts_error;

3299:
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:

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 3309: WHEN fnd_api.g_exc_unexpected_error THEN

3305: p_count => x_msg_count,
3306: p_data => x_msg_data);
3307:
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,

Line 3311: x_return_status := fnd_api.g_ret_sts_unexp_error;

3307:
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:

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 3319: x_return_status := fnd_api.g_ret_sts_unexp_error;

3315:
3316:
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,

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 3371: IF NOT FND_API.Compatible_API_Call(l_api_version,

3367:
3368: SAVEPOINT update_intermediary_acct;
3369:
3370: -- Standard call to check for call compatibility.
3371: IF NOT FND_API.Compatible_API_Call(l_api_version,
3372: p_api_version,
3373: l_api_name,
3374: G_PKG_NAME) THEN
3375: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3375: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3371: IF NOT FND_API.Compatible_API_Call(l_api_version,
3372: p_api_version,
3373: l_api_name,
3374: G_PKG_NAME) THEN
3375: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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

Line 3379: IF FND_API.to_Boolean(p_init_msg_list) THEN

3375: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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

Line 3384: x_return_status := FND_API.G_RET_STS_SUCCESS;

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;
3385:
3386: --START of API
3387:
3388: -- Parameter validations

Line 3398: x_return_status := fnd_api.g_ret_sts_error;

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;
3402: CLOSE c_ovn;

Line 3400: RAISE fnd_api.g_exc_error;

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;
3402: CLOSE c_ovn;
3403:
3404: IF l_old_ovn > p_intermed_acct_rec.object_version_number THEN

Line 3407: x_return_status := fnd_api.g_ret_sts_error;

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:
3411: -- update the table IBY_INTERMEDIARY_ACCOUNTS

Line 3408: RAISE fnd_api.g_exc_error;

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:
3411: -- update the table IBY_INTERMEDIARY_ACCOUNTS
3412: UPDATE IBY_INTERMEDIARY_ACCTS

Line 3433: x_return_status := fnd_api.g_ret_sts_error;

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:
3437: -- END of API

Line 3434: RAISE fnd_api.g_exc_error;

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:
3437: -- END of API
3438:

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 3447: WHEN fnd_api.g_exc_error THEN

3443:
3444: print_debuginfo('RETURN ' || l_module_name);
3445:
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,

Line 3449: x_return_status := fnd_api.g_ret_sts_error;

3445:
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:

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 3455: WHEN fnd_api.g_exc_unexpected_error THEN

3451: p_count => x_msg_count,
3452: p_data => x_msg_data);
3453:
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,

Line 3457: x_return_status := fnd_api.g_ret_sts_unexp_error;

3453:
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:

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 3465: x_return_status := fnd_api.g_ret_sts_unexp_error;

3461:
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,

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 3519: IF NOT FND_API.Compatible_API_Call(l_api_version,

3515:
3516: SAVEPOINT add_joint_account_owner;
3517:
3518: -- Standard call to check for call compatibility.
3519: IF NOT FND_API.Compatible_API_Call(l_api_version,
3520: p_api_version,
3521: l_api_name,
3522: G_PKG_NAME) THEN
3523: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3523: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3519: IF NOT FND_API.Compatible_API_Call(l_api_version,
3520: p_api_version,
3521: l_api_name,
3522: G_PKG_NAME) THEN
3523: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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

Line 3527: IF FND_API.to_Boolean(p_init_msg_list) THEN

3523: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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

Line 3532: x_return_status := FND_API.G_RET_STS_SUCCESS;

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;
3533:
3534: -- Parameter validations
3535: check_mandatory('Bank Account Id',p_bank_account_id);
3536: check_mandatory('Account Owner Party Id',p_acct_owner_party_id);

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 3587: WHEN fnd_api.g_exc_error THEN

3583:
3584: print_debuginfo('RETURN ' || l_module_name);
3585:
3586: EXCEPTION
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,

Line 3589: x_return_status := fnd_api.g_ret_sts_error;

3585:
3586: EXCEPTION
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);

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 3596: WHEN fnd_api.g_exc_unexpected_error THEN

3592: p_count => x_msg_count,
3593: p_data => x_msg_data);
3594:
3595:
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,

Line 3598: x_return_status := fnd_api.g_ret_sts_unexp_error;

3594:
3595:
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);

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 3607: x_return_status := fnd_api.g_ret_sts_unexp_error;

3603:
3604:
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,

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 3652: IF NOT FND_API.Compatible_API_Call(l_api_version,

3648:
3649: SAVEPOINT set_acct_owner_end_date_pub;
3650:
3651: -- Standard call to check for call compatibility.
3652: IF NOT FND_API.Compatible_API_Call(l_api_version,
3653: p_api_version,
3654: l_api_name,
3655: G_PKG_NAME) THEN
3656: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3656: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3652: IF NOT FND_API.Compatible_API_Call(l_api_version,
3653: p_api_version,
3654: l_api_name,
3655: G_PKG_NAME) THEN
3656: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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

Line 3660: IF FND_API.to_Boolean(p_init_msg_list) THEN

3656: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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

Line 3665: x_return_status := FND_API.G_RET_STS_SUCCESS;

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;
3666:
3667: -- Start of API body
3668: print_debuginfo('Object Version Number : ' || p_object_version_number);
3669:

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 3699: WHEN fnd_api.g_exc_error THEN

3695:
3696: print_debuginfo('RETURN ' || l_module_name);
3697:
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,

Line 3701: x_return_status := fnd_api.g_ret_sts_error;

3697:
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:

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 3707: WHEN fnd_api.g_exc_unexpected_error THEN

3703: p_count => x_msg_count,
3704: p_data => x_msg_data);
3705:
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,

Line 3709: x_return_status := fnd_api.g_ret_sts_unexp_error;

3705:
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:

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 3717: x_return_status := fnd_api.g_ret_sts_unexp_error;

3713:
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);

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 3769: IF NOT FND_API.Compatible_API_Call(l_api_version,

3765:
3766: SAVEPOINT change_primary_acct_owner_pub;
3767:
3768: -- Standard call to check for call compatibility.
3769: IF NOT FND_API.Compatible_API_Call(l_api_version,
3770: p_api_version,
3771: l_api_name,
3772: G_PKG_NAME) THEN
3773: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3773: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3769: IF NOT FND_API.Compatible_API_Call(l_api_version,
3770: p_api_version,
3771: l_api_name,
3772: G_PKG_NAME) THEN
3773: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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

Line 3777: IF FND_API.to_Boolean(p_init_msg_list) THEN

3773: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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

Line 3782: x_return_status := FND_API.G_RET_STS_SUCCESS;

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;
3783:
3784: -- Start of API body
3785:
3786: -- Parameter validations

Line 3809: raise fnd_api.g_exc_unexpected_error;

3805: IF (l_count = 1) THEN
3806: print_debuginfo('Primary Flag set for Account Owner '||p_acct_owner_party_id);
3807: ELSE
3808: print_debuginfo('Too many matching rows found');
3809: raise fnd_api.g_exc_unexpected_error;
3810: END IF;
3811:
3812: -- End of API body
3813:

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 3821: WHEN fnd_api.g_exc_error THEN

3817: p_data => x_msg_data);
3818:
3819: print_debuginfo('RETURN ' || l_module_name);
3820: EXCEPTION
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,

Line 3823: x_return_status := fnd_api.g_ret_sts_error;

3819: print_debuginfo('RETURN ' || l_module_name);
3820: EXCEPTION
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);

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 3830: WHEN fnd_api.g_exc_unexpected_error THEN

3826: p_count => x_msg_count,
3827: p_data => x_msg_data);
3828:
3829:
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,

Line 3832: x_return_status := fnd_api.g_ret_sts_unexp_error;

3828:
3829:
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);

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 3841: x_return_status := fnd_api.g_ret_sts_unexp_error;

3837:
3838:
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,

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 3876: x_return_status := fnd_api.g_ret_sts_success;

3872: AND hp.status = 'A';
3873: l_country VARCHAR2(60);
3874: BEGIN
3875: -- initialize API return status to success.
3876: x_return_status := fnd_api.g_ret_sts_success;
3877:
3878: OPEN c_country;
3879: FETCH c_country INTO l_country;
3880: IF c_country%NOTFOUND THEN

Line 3883: x_return_status := fnd_api.g_ret_sts_error;

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:
3887: RETURN NVL(l_country, 'NULL');

Line 3962: x_return_status := fnd_api.g_ret_sts_success;

3958: BEGIN
3959: print_debuginfo('ENTER ' || l_module_name);
3960:
3961: -- initialize API return status to success.
3962: x_return_status := fnd_api.g_ret_sts_success;
3963:
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

Line 3969: x_return_status := fnd_api.g_ret_sts_error;

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:
3973: print_debuginfo('RETURN ' || l_module_name);

Line 4008: RAISE fnd_api.g_exc_error;

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:
4011:
4012: --Validate Currency

Line 4022: RAISE fnd_api.g_exc_error;

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;
4026: print_debuginfo('Checked mandatory field : ' || p_field || ' : ' || p_value);

Line 4208: (p_commit IN VARCHAR2 := FND_API.G_TRUE,

4204: RETURN l_bank_num;
4205: END Uncipher_Bank_Number;
4206:
4207: PROCEDURE Remask_Accounts
4208: (p_commit IN VARCHAR2 := FND_API.G_TRUE,
4209: p_sys_key IN iby_security_pkg.DES3_KEY_TYPE
4210: )
4211: IS
4212: lx_mask_option iby_ext_bank_accounts.ba_mask_setting%TYPE;

Line 4329: (FND_API.G_FALSE,l_ba_segment,

4325: l_ba_segment := IBY_SECURITY_PKG.PKCS5_PAD(l_ba_segment);
4326:
4327: IF (ext_ba_rec.ba_num_sec_segment_id IS NULL) THEN
4328: IBY_SECURITY_PKG.Create_Segment
4329: (FND_API.G_FALSE,l_ba_segment,
4330: iby_security_pkg.G_ENCODING_UTF8_AL32,
4331: p_sys_key,lx_ba_segment_id);
4332: ELSE
4333: lx_ba_segment_id := ext_ba_rec.ba_num_sec_segment_id;

Line 4335: (FND_API.G_FALSE,lx_ba_segment_id,l_ba_segment,

4331: p_sys_key,lx_ba_segment_id);
4332: ELSE
4333: lx_ba_segment_id := ext_ba_rec.ba_num_sec_segment_id;
4334: IBY_SECURITY_PKG.Update_Segment
4335: (FND_API.G_FALSE,lx_ba_segment_id,l_ba_segment,
4336: iby_security_pkg.G_ENCODING_UTF8_AL32,p_sys_key,
4337: ext_ba_rec.ba_subkey_cipher);
4338: END IF;
4339: ELSE

Line 4356: (FND_API.G_FALSE,l_iban_segment,

4352: l_iban_segment := IBY_SECURITY_PKG.PKCS5_PAD(l_iban_segment);
4353:
4354: IF (ext_ba_rec.iban_sec_segment_id IS NULL) THEN
4355: IBY_SECURITY_PKG.Create_Segment
4356: (FND_API.G_FALSE,l_iban_segment,
4357: iby_security_pkg.G_ENCODING_UTF8_AL32,p_sys_key,
4358: lx_iban_segment_id);
4359: ELSE
4360: lx_iban_segment_id := ext_ba_rec.iban_sec_segment_id;

Line 4362: (FND_API.G_FALSE,lx_iban_segment_id,l_iban_segment,

4358: lx_iban_segment_id);
4359: ELSE
4360: lx_iban_segment_id := ext_ba_rec.iban_sec_segment_id;
4361: IBY_SECURITY_PKG.Update_Segment
4362: (FND_API.G_FALSE,lx_iban_segment_id,l_iban_segment,
4363: iby_security_pkg.G_ENCODING_UTF8_AL32,p_sys_key,
4364: ext_ba_rec.iban_subkey_cipher);
4365: END IF;
4366: ELSE

Line 4406: IF FND_API.to_Boolean( p_commit ) THEN

4402: WHERE (ext_bank_account_id = ext_ba_rec.ext_bank_account_id);
4403:
4404: END LOOP;
4405:
4406: IF FND_API.to_Boolean( p_commit ) THEN
4407: COMMIT;
4408: END IF;
4409:
4410: iby_debug_pub.add('Exit',iby_debug_pub.G_LEVEL_PROCEDURE,l_dbg_mod);

Line 4482: (FND_API.G_FALSE,l_ba_segment,iby_security_pkg.G_ENCODING_UTF8_AL32,

4478: -- pad to unit 8 length
4479: l_ba_segment := IBY_SECURITY_PKG.PKCS5_PAD(l_ba_segment);
4480:
4481: IBY_SECURITY_PKG.Create_Segment
4482: (FND_API.G_FALSE,l_ba_segment,iby_security_pkg.G_ENCODING_UTF8_AL32,
4483: p_sys_key,lx_ba_segment_id);
4484: END IF;
4485: ELSE
4486: lx_ba_unmask_digits := ext_ba_rec.bank_account_num;

Line 4504: (FND_API.G_FALSE,l_iban_segment,

4500: -- pad to unit 8 length
4501: l_iban_segment := IBY_SECURITY_PKG.PKCS5_PAD(l_iban_segment);
4502:
4503: IBY_SECURITY_PKG.Create_Segment
4504: (FND_API.G_FALSE,l_iban_segment,
4505: iby_security_pkg.G_ENCODING_UTF8_AL32,p_sys_key,lx_iban_segment_id);
4506: END IF;
4507: ELSE
4508: lx_iban_unmask_digits := ext_ba_rec.iban;

Line 4523: (FND_API.G_FALSE,l_e_ba_segment,

4519: -- pad to unit 8 length
4520: l_e_ba_segment := IBY_SECURITY_PKG.PKCS5_PAD(l_e_ba_segment);
4521:
4522: IBY_SECURITY_PKG.Create_Segment
4523: (FND_API.G_FALSE,l_e_ba_segment,
4524: iby_security_pkg.G_ENCODING_UTF8_AL32,p_sys_key,lx_e_ba_segment_id);
4525: ELSE
4526: lx_e_ba_unmask_digits := ext_ba_rec.bank_account_num_electronic;
4527: END IF;

Line 4542: IF FND_API.to_Boolean( p_commit ) THEN

4538: encrypted = 'Y'
4539: WHERE (ext_bank_account_id = ext_ba_rec.ext_bank_account_id);
4540: END LOOP;
4541:
4542: IF FND_API.to_Boolean( p_commit ) THEN
4543: COMMIT;
4544: END IF;
4545: END Encrypt_Accounts;
4546:

Line 4666: IF FND_API.to_Boolean( p_commit ) THEN

4662: WHERE sec_segment_id = ext_ba_rec.ba_num_elec_sec_segment_id;
4663:
4664: END LOOP;
4665:
4666: IF FND_API.to_Boolean( p_commit ) THEN
4667: COMMIT;
4668: END IF;
4669: END Decrypt_Accounts;
4670: