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

99: END IF;
100: SAVEPOINT create_bank_pub;
101:
102: -- Standard call to check for call compatibility.
103: IF NOT FND_API.Compatible_API_Call(l_api_version,
104: p_api_version,
105: l_api_name,
106: G_PKG_NAME) THEN
107: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 107: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

103: IF NOT FND_API.Compatible_API_Call(l_api_version,
104: p_api_version,
105: l_api_name,
106: G_PKG_NAME) THEN
107: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
108: END IF;
109:
110: -- Initialize message list if p_init_msg_list is set to TRUE.
111: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 111: IF FND_API.to_Boolean(p_init_msg_list) THEN

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

Line 116: x_return_status := FND_API.G_RET_STS_SUCCESS;

112: FND_MSG_PUB.initialize;
113: END IF;
114:
115: -- Initialize API return status to success
116: x_return_status := FND_API.G_RET_STS_SUCCESS;
117:
118: -- Start of API body
119:
120: -- Parameter validations

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

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

Line 209: WHEN fnd_api.g_exc_error THEN

205: print_debuginfo('RETURN ' || l_module_name);
206:
207: END IF;
208: EXCEPTION
209: WHEN fnd_api.g_exc_error THEN
210: ROLLBACK TO create_bank_pub;
211: x_return_status := fnd_api.g_ret_sts_error;
212: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
213: print_debuginfo('Exception : ' || SQLERRM);

Line 211: x_return_status := fnd_api.g_ret_sts_error;

207: END IF;
208: EXCEPTION
209: WHEN fnd_api.g_exc_error THEN
210: ROLLBACK TO create_bank_pub;
211: x_return_status := fnd_api.g_ret_sts_error;
212: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
213: print_debuginfo('Exception : ' || SQLERRM);
214: END IF;
215: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

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

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

Line 220: WHEN fnd_api.g_exc_unexpected_error THEN

216: p_count => x_msg_count,
217: p_data => x_msg_data);
218:
219:
220: WHEN fnd_api.g_exc_unexpected_error THEN
221: ROLLBACK TO create_bank_pub;
222: x_return_status := fnd_api.g_ret_sts_unexp_error;
223: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
224: print_debuginfo('Exception : ' || SQLERRM);

Line 222: x_return_status := fnd_api.g_ret_sts_unexp_error;

218:
219:
220: WHEN fnd_api.g_exc_unexpected_error THEN
221: ROLLBACK TO create_bank_pub;
222: x_return_status := fnd_api.g_ret_sts_unexp_error;
223: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
224: print_debuginfo('Exception : ' || SQLERRM);
225: END IF;
226: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

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

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

Line 233: x_return_status := fnd_api.g_ret_sts_unexp_error;

229:
230:
231: WHEN OTHERS THEN
232: ROLLBACK TO create_bank_pub;
233: x_return_status := fnd_api.g_ret_sts_unexp_error;
234: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
235: print_debuginfo('Exception : ' || SQLERRM);
236: END IF;
237: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);

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

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

Line 281: IF NOT FND_API.Compatible_API_Call(l_api_version,

277: END IF;
278: SAVEPOINT update_bank_pub;
279:
280: -- Standard call to check for call compatibility.
281: IF NOT FND_API.Compatible_API_Call(l_api_version,
282: p_api_version,
283: l_api_name,
284: G_PKG_NAME) THEN
285: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 285: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

281: IF NOT FND_API.Compatible_API_Call(l_api_version,
282: p_api_version,
283: l_api_name,
284: G_PKG_NAME) THEN
285: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
286: END IF;
287:
288: -- Initialize message list if p_init_msg_list is set to TRUE.
289: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 289: IF FND_API.to_Boolean(p_init_msg_list) THEN

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

Line 294: x_return_status := FND_API.G_RET_STS_SUCCESS;

290: FND_MSG_PUB.initialize;
291: END IF;
292:
293: -- Initialize API return status to success
294: x_return_status := FND_API.G_RET_STS_SUCCESS;
295:
296: -- Start of API body
297:
298: -- Parameter validations

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

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

Line 361: WHEN fnd_api.g_exc_error THEN

357: print_debuginfo('RETURN ' || l_module_name);
358:
359: END IF;
360: EXCEPTION
361: WHEN fnd_api.g_exc_error THEN
362: ROLLBACK TO update_bank_pub;
363: x_return_status := fnd_api.g_ret_sts_error;
364: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
365: print_debuginfo('Exception : ' || SQLERRM);

Line 363: x_return_status := fnd_api.g_ret_sts_error;

359: END IF;
360: EXCEPTION
361: WHEN fnd_api.g_exc_error THEN
362: ROLLBACK TO update_bank_pub;
363: x_return_status := fnd_api.g_ret_sts_error;
364: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
365: print_debuginfo('Exception : ' || SQLERRM);
366: END IF;
367: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

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

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

Line 372: WHEN fnd_api.g_exc_unexpected_error THEN

368: p_count => x_msg_count,
369: p_data => x_msg_data);
370:
371:
372: WHEN fnd_api.g_exc_unexpected_error THEN
373: ROLLBACK TO update_bank_pub;
374: x_return_status := fnd_api.g_ret_sts_unexp_error;
375: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
376: print_debuginfo('Exception : ' || SQLERRM);

Line 374: x_return_status := fnd_api.g_ret_sts_unexp_error;

370:
371:
372: WHEN fnd_api.g_exc_unexpected_error THEN
373: ROLLBACK TO update_bank_pub;
374: x_return_status := fnd_api.g_ret_sts_unexp_error;
375: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
376: print_debuginfo('Exception : ' || SQLERRM);
377: END IF;
378: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

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

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

Line 385: x_return_status := fnd_api.g_ret_sts_unexp_error;

381:
382:
383: WHEN OTHERS THEN
384: ROLLBACK TO update_bank_pub;
385: x_return_status := fnd_api.g_ret_sts_unexp_error;
386: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
387: print_debuginfo('Exception : ' || SQLERRM);
388:
389: END IF;

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

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

Line 440: IF NOT FND_API.Compatible_API_Call(l_api_version,

436: END IF;
437: SAVEPOINT set_bank_end_date_pub;
438:
439: -- Standard call to check for call compatibility.
440: IF NOT FND_API.Compatible_API_Call(l_api_version,
441: p_api_version,
442: l_api_name,
443: G_PKG_NAME) THEN
444: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 444: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

440: IF NOT FND_API.Compatible_API_Call(l_api_version,
441: p_api_version,
442: l_api_name,
443: G_PKG_NAME) THEN
444: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
445: END IF;
446:
447: -- Initialize message list if p_init_msg_list is set to TRUE.
448: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 448: IF FND_API.to_Boolean(p_init_msg_list) THEN

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

Line 453: x_return_status := FND_API.G_RET_STS_SUCCESS;

449: FND_MSG_PUB.initialize;
450: END IF;
451:
452: -- Initialize API return status to success
453: x_return_status := FND_API.G_RET_STS_SUCCESS;
454:
455: -- Start of API body
456:
457: -- Parameter validations

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

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

Line 491: WHEN fnd_api.g_exc_error THEN

487: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
488: print_debuginfo('RETURN ' || l_module_name);
489: END IF;
490: EXCEPTION
491: WHEN fnd_api.g_exc_error THEN
492: ROLLBACK TO set_bank_end_date_pub;
493: x_return_status := fnd_api.g_ret_sts_error;
494: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
495: print_debuginfo('Exception : ' || SQLERRM);

Line 493: x_return_status := fnd_api.g_ret_sts_error;

489: END IF;
490: EXCEPTION
491: WHEN fnd_api.g_exc_error THEN
492: ROLLBACK TO set_bank_end_date_pub;
493: x_return_status := fnd_api.g_ret_sts_error;
494: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
495: print_debuginfo('Exception : ' || SQLERRM);
496: END IF;
497: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

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

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

Line 502: WHEN fnd_api.g_exc_unexpected_error THEN

498: p_count => x_msg_count,
499: p_data => x_msg_data);
500:
501:
502: WHEN fnd_api.g_exc_unexpected_error THEN
503: ROLLBACK TO set_bank_end_date_pub;
504: x_return_status := fnd_api.g_ret_sts_unexp_error;
505: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
506: print_debuginfo('Exception : ' || SQLERRM);

Line 504: x_return_status := fnd_api.g_ret_sts_unexp_error;

500:
501:
502: WHEN fnd_api.g_exc_unexpected_error THEN
503: ROLLBACK TO set_bank_end_date_pub;
504: x_return_status := fnd_api.g_ret_sts_unexp_error;
505: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
506: print_debuginfo('Exception : ' || SQLERRM);
507: END IF;
508: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

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

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

Line 515: x_return_status := fnd_api.g_ret_sts_unexp_error;

511:
512:
513: WHEN OTHERS THEN
514: ROLLBACK TO set_bank_end_date_pub;
515: x_return_status := fnd_api.g_ret_sts_unexp_error;
516: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
517: print_debuginfo('Exception : ' || SQLERRM);
518: END IF;
519: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);

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

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

Line 564: IF NOT FND_API.Compatible_API_Call(l_api_version,

560: print_debuginfo('ENTER ' || l_module_name);
561:
562: END IF;
563: -- Standard call to check for call compatibility.
564: IF NOT FND_API.Compatible_API_Call(l_api_version,
565: p_api_version,
566: l_api_name,
567: G_PKG_NAME) THEN
568: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 568: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

564: IF NOT FND_API.Compatible_API_Call(l_api_version,
565: p_api_version,
566: l_api_name,
567: G_PKG_NAME) THEN
568: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
569: END IF;
570:
571: -- Initialize message list if p_init_msg_list is set to TRUE.
572: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 572: IF FND_API.to_Boolean(p_init_msg_list) THEN

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

Line 577: x_return_status := FND_API.G_RET_STS_SUCCESS;

573: FND_MSG_PUB.initialize;
574: END IF;
575:
576: -- Initialize API return status to success
577: x_return_status := FND_API.G_RET_STS_SUCCESS;
578:
579: -- Start of API body
580:
581: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

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

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

Line 608: WHEN fnd_api.g_exc_error THEN

604: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
605: print_debuginfo('RETURN ' || l_module_name);
606: END IF;
607: EXCEPTION
608: WHEN fnd_api.g_exc_error THEN
609: x_return_status := fnd_api.g_ret_sts_error;
610: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
611: print_debuginfo('Exception : ' || SQLERRM);
612: END IF;

Line 609: x_return_status := fnd_api.g_ret_sts_error;

605: print_debuginfo('RETURN ' || l_module_name);
606: END IF;
607: EXCEPTION
608: WHEN fnd_api.g_exc_error THEN
609: x_return_status := fnd_api.g_ret_sts_error;
610: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
611: print_debuginfo('Exception : ' || SQLERRM);
612: END IF;
613: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

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

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

Line 618: WHEN fnd_api.g_exc_unexpected_error THEN

614: p_count => x_msg_count,
615: p_data => x_msg_data);
616:
617:
618: WHEN fnd_api.g_exc_unexpected_error THEN
619: x_return_status := fnd_api.g_ret_sts_unexp_error;
620: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
621: print_debuginfo('Exception : ' || SQLERRM);
622: END IF;

Line 619: x_return_status := fnd_api.g_ret_sts_unexp_error;

615: p_data => x_msg_data);
616:
617:
618: WHEN fnd_api.g_exc_unexpected_error THEN
619: x_return_status := fnd_api.g_ret_sts_unexp_error;
620: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
621: print_debuginfo('Exception : ' || SQLERRM);
622: END IF;
623: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

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

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

Line 629: x_return_status := fnd_api.g_ret_sts_unexp_error;

625: p_data => x_msg_data);
626:
627:
628: WHEN OTHERS THEN
629: x_return_status := fnd_api.g_ret_sts_unexp_error;
630: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
631: print_debuginfo('Exception : ' || SQLERRM);
632:
633: END IF;

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

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

Line 677: IF NOT FND_API.Compatible_API_Call(l_api_version,

673: END IF;
674: SAVEPOINT create_bank_branch_pub;
675:
676: -- Standard call to check for call compatibility.
677: IF NOT FND_API.Compatible_API_Call(l_api_version,
678: p_api_version,
679: l_api_name,
680: G_PKG_NAME) THEN
681: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 681: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

677: IF NOT FND_API.Compatible_API_Call(l_api_version,
678: p_api_version,
679: l_api_name,
680: G_PKG_NAME) THEN
681: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
682: END IF;
683:
684: -- Initialize message list if p_init_msg_list is set to TRUE.
685: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 685: IF FND_API.to_Boolean(p_init_msg_list) THEN

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

Line 690: x_return_status := FND_API.G_RET_STS_SUCCESS;

686: FND_MSG_PUB.initialize;
687: END IF;
688:
689: -- Initialize API return status to success
690: x_return_status := FND_API.G_RET_STS_SUCCESS;
691:
692: -- Start of API body
693:
694: -- Parameter validations

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

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

Line 764: WHEN fnd_api.g_exc_error THEN

760: print_debuginfo('RETURN ' || l_module_name);
761:
762: END IF;
763: EXCEPTION
764: WHEN fnd_api.g_exc_error THEN
765: ROLLBACK TO create_bank_branch_pub;
766: x_return_status := fnd_api.g_ret_sts_error;
767: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
768: print_debuginfo('Exception : ' || SQLERRM);

Line 766: x_return_status := fnd_api.g_ret_sts_error;

762: END IF;
763: EXCEPTION
764: WHEN fnd_api.g_exc_error THEN
765: ROLLBACK TO create_bank_branch_pub;
766: x_return_status := fnd_api.g_ret_sts_error;
767: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
768: print_debuginfo('Exception : ' || SQLERRM);
769: END IF;
770: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

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

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

Line 775: WHEN fnd_api.g_exc_unexpected_error THEN

771: p_count => x_msg_count,
772: p_data => x_msg_data);
773:
774:
775: WHEN fnd_api.g_exc_unexpected_error THEN
776: ROLLBACK TO create_bank_branch_pub;
777: x_return_status := fnd_api.g_ret_sts_unexp_error;
778: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
779: print_debuginfo('Exception : ' || SQLERRM);

Line 777: x_return_status := fnd_api.g_ret_sts_unexp_error;

773:
774:
775: WHEN fnd_api.g_exc_unexpected_error THEN
776: ROLLBACK TO create_bank_branch_pub;
777: x_return_status := fnd_api.g_ret_sts_unexp_error;
778: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
779: print_debuginfo('Exception : ' || SQLERRM);
780: END IF;
781: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

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

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

Line 788: x_return_status := fnd_api.g_ret_sts_unexp_error;

784:
785:
786: WHEN OTHERS THEN
787: ROLLBACK TO create_bank_branch_pub;
788: x_return_status := fnd_api.g_ret_sts_unexp_error;
789: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
790: print_debuginfo('Exception : ' || SQLERRM);
791:
792: END IF;

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

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

Line 852: IF NOT FND_API.Compatible_API_Call(l_api_version,

848: END IF;
849: SAVEPOINT update_bank_branch_pub;
850:
851: -- Standard call to check for call compatibility.
852: IF NOT FND_API.Compatible_API_Call(l_api_version,
853: p_api_version,
854: l_api_name,
855: G_PKG_NAME) THEN
856: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 856: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

852: IF NOT FND_API.Compatible_API_Call(l_api_version,
853: p_api_version,
854: l_api_name,
855: G_PKG_NAME) THEN
856: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
857: END IF;
858:
859: -- Initialize message list if p_init_msg_list is set to TRUE.
860: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 860: IF FND_API.to_Boolean(p_init_msg_list) THEN

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

Line 865: x_return_status := FND_API.G_RET_STS_SUCCESS;

861: FND_MSG_PUB.initialize;
862: END IF;
863:
864: -- Initialize API return status to success
865: x_return_status := FND_API.G_RET_STS_SUCCESS;
866:
867: -- Start of API Body
868:
869: -- Parameter validations

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

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

Line 994: WHEN fnd_api.g_exc_error THEN

990: print_debuginfo('RETURN ' || l_module_name);
991:
992: END IF;
993: EXCEPTION
994: WHEN fnd_api.g_exc_error THEN
995: ROLLBACK TO update_bank_branch_pub;
996: x_return_status := fnd_api.g_ret_sts_error;
997: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
998: print_debuginfo('Exception : ' || SQLERRM);

Line 996: x_return_status := fnd_api.g_ret_sts_error;

992: END IF;
993: EXCEPTION
994: WHEN fnd_api.g_exc_error THEN
995: ROLLBACK TO update_bank_branch_pub;
996: x_return_status := fnd_api.g_ret_sts_error;
997: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
998: print_debuginfo('Exception : ' || SQLERRM);
999: END IF;
1000: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

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

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

Line 1005: WHEN fnd_api.g_exc_unexpected_error THEN

1001: p_count => x_msg_count,
1002: p_data => x_msg_data);
1003:
1004:
1005: WHEN fnd_api.g_exc_unexpected_error THEN
1006: ROLLBACK TO update_bank_branch_pub;
1007: x_return_status := fnd_api.g_ret_sts_unexp_error;
1008: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1009: print_debuginfo('Exception : ' || SQLERRM);

Line 1007: x_return_status := fnd_api.g_ret_sts_unexp_error;

1003:
1004:
1005: WHEN fnd_api.g_exc_unexpected_error THEN
1006: ROLLBACK TO update_bank_branch_pub;
1007: x_return_status := fnd_api.g_ret_sts_unexp_error;
1008: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1009: print_debuginfo('Exception : ' || SQLERRM);
1010: END IF;
1011: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

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

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

Line 1018: x_return_status := fnd_api.g_ret_sts_unexp_error;

1014:
1015:
1016: WHEN OTHERS THEN
1017: ROLLBACK TO update_bank_branch_pub;
1018: x_return_status := fnd_api.g_ret_sts_unexp_error;
1019: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1020: print_debuginfo('Exception : ' || SQLERRM);
1021:
1022: END IF;

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

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

Line 1073: IF NOT FND_API.Compatible_API_Call(l_api_version,

1069: END IF;
1070: SAVEPOINT set_ext_branch_end_date_pub;
1071:
1072: -- Standard call to check for call compatibility.
1073: IF NOT FND_API.Compatible_API_Call(l_api_version,
1074: p_api_version,
1075: l_api_name,
1076: G_PKG_NAME) THEN
1077: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1077: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1073: IF NOT FND_API.Compatible_API_Call(l_api_version,
1074: p_api_version,
1075: l_api_name,
1076: G_PKG_NAME) THEN
1077: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1078: END IF;
1079:
1080: -- Initialize message list if p_init_msg_list is set to TRUE.
1081: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 1081: IF FND_API.to_Boolean(p_init_msg_list) THEN

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

Line 1086: x_return_status := FND_API.G_RET_STS_SUCCESS;

1082: FND_MSG_PUB.initialize;
1083: END IF;
1084:
1085: -- Initialize API return status to success
1086: x_return_status := FND_API.G_RET_STS_SUCCESS;
1087:
1088: -- Start of API body
1089:
1090: -- Parameter validations

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

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

Line 1124: WHEN fnd_api.g_exc_error THEN

1120: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1121: print_debuginfo('RETURN ' || l_module_name);
1122: END IF;
1123: EXCEPTION
1124: WHEN fnd_api.g_exc_error THEN
1125: ROLLBACK TO set_ext_branch_end_date_pub;
1126: x_return_status := fnd_api.g_ret_sts_error;
1127: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1128: print_debuginfo('Exception : ' || SQLERRM);

Line 1126: x_return_status := fnd_api.g_ret_sts_error;

1122: END IF;
1123: EXCEPTION
1124: WHEN fnd_api.g_exc_error THEN
1125: ROLLBACK TO set_ext_branch_end_date_pub;
1126: x_return_status := fnd_api.g_ret_sts_error;
1127: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1128: print_debuginfo('Exception : ' || SQLERRM);
1129: END IF;
1130: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

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

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

Line 1135: WHEN fnd_api.g_exc_unexpected_error THEN

1131: p_count => x_msg_count,
1132: p_data => x_msg_data);
1133:
1134:
1135: WHEN fnd_api.g_exc_unexpected_error THEN
1136: ROLLBACK TO set_ext_branch_end_date_pub;
1137: x_return_status := fnd_api.g_ret_sts_unexp_error;
1138: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1139: print_debuginfo('Exception : ' || SQLERRM);

Line 1137: x_return_status := fnd_api.g_ret_sts_unexp_error;

1133:
1134:
1135: WHEN fnd_api.g_exc_unexpected_error THEN
1136: ROLLBACK TO set_ext_branch_end_date_pub;
1137: x_return_status := fnd_api.g_ret_sts_unexp_error;
1138: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1139: print_debuginfo('Exception : ' || SQLERRM);
1140: END IF;
1141: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

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

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

Line 1148: x_return_status := fnd_api.g_ret_sts_unexp_error;

1144:
1145:
1146: WHEN OTHERS THEN
1147: ROLLBACK TO set_ext_branch_end_date_pub;
1148: x_return_status := fnd_api.g_ret_sts_unexp_error;
1149: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1150: print_debuginfo('Exception : ' || SQLERRM);
1151:
1152: END IF;

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

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

Line 1199: IF NOT FND_API.Compatible_API_Call(l_api_version,

1195: print_debuginfo('ENTER ' || l_module_name);
1196:
1197: END IF;
1198: -- Standard call to check for call compatibility.
1199: IF NOT FND_API.Compatible_API_Call(l_api_version,
1200: p_api_version,
1201: l_api_name,
1202: G_PKG_NAME) THEN
1203: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1203: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1199: IF NOT FND_API.Compatible_API_Call(l_api_version,
1200: p_api_version,
1201: l_api_name,
1202: G_PKG_NAME) THEN
1203: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1204: END IF;
1205:
1206: -- Initialize message list if p_init_msg_list is set to TRUE.
1207: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 1207: IF FND_API.to_Boolean(p_init_msg_list) THEN

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

Line 1212: x_return_status := FND_API.G_RET_STS_SUCCESS;

1208: FND_MSG_PUB.initialize;
1209: END IF;
1210:
1211: -- Initialize API return status to success
1212: x_return_status := FND_API.G_RET_STS_SUCCESS;
1213:
1214: -- Start of API body
1215:
1216: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

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

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

Line 1244: WHEN fnd_api.g_exc_error THEN

1240: print_debuginfo('RETURN ' || l_module_name);
1241:
1242: END IF;
1243: EXCEPTION
1244: WHEN fnd_api.g_exc_error THEN
1245: x_return_status := fnd_api.g_ret_sts_error;
1246: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1247: print_debuginfo('Exception : ' || SQLERRM);
1248: END IF;

Line 1245: x_return_status := fnd_api.g_ret_sts_error;

1241:
1242: END IF;
1243: EXCEPTION
1244: WHEN fnd_api.g_exc_error THEN
1245: x_return_status := fnd_api.g_ret_sts_error;
1246: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1247: print_debuginfo('Exception : ' || SQLERRM);
1248: END IF;
1249: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

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

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

Line 1254: WHEN fnd_api.g_exc_unexpected_error THEN

1250: p_count => x_msg_count,
1251: p_data => x_msg_data);
1252:
1253:
1254: WHEN fnd_api.g_exc_unexpected_error THEN
1255: x_return_status := fnd_api.g_ret_sts_unexp_error;
1256: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1257: print_debuginfo('Exception : ' || SQLERRM);
1258: END IF;

Line 1255: x_return_status := fnd_api.g_ret_sts_unexp_error;

1251: p_data => x_msg_data);
1252:
1253:
1254: WHEN fnd_api.g_exc_unexpected_error THEN
1255: x_return_status := fnd_api.g_ret_sts_unexp_error;
1256: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1257: print_debuginfo('Exception : ' || SQLERRM);
1258: END IF;
1259: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

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

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

Line 1265: x_return_status := fnd_api.g_ret_sts_unexp_error;

1261: p_data => x_msg_data);
1262:
1263:
1264: WHEN OTHERS THEN
1265: x_return_status := fnd_api.g_ret_sts_unexp_error;
1266: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1267: print_debuginfo('Exception : ' || SQLERRM);
1268: END IF;
1269: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);

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

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

Line 1368: IF NOT FND_API.Compatible_API_Call(l_api_version,

1364: END IF;
1365: SAVEPOINT create_ext_bank_acct_pub;
1366:
1367: -- Standard call to check for call compatibility.
1368: IF NOT FND_API.Compatible_API_Call(l_api_version,
1369: p_api_version,
1370: l_api_name,
1371: G_PKG_NAME) THEN
1372: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1372: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1368: IF NOT FND_API.Compatible_API_Call(l_api_version,
1369: p_api_version,
1370: l_api_name,
1371: G_PKG_NAME) THEN
1372: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1373: END IF;
1374:
1375: -- Initialize message list if p_init_msg_list is set to TRUE.
1376: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 1376: IF FND_API.to_Boolean(p_init_msg_list) THEN

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

Line 1381: x_return_status := FND_API.G_RET_STS_SUCCESS;

1377: FND_MSG_PUB.initialize;
1378: END IF;
1379:
1380: -- Initialize API return status to success
1381: x_return_status := FND_API.G_RET_STS_SUCCESS;
1382:
1383: -- Start of API
1384:
1385: -- Parameter validations

Line 1412: IF not x_return_status=fnd_api.g_ret_sts_success

1408:
1409: -- validate iban
1410: IF p_ext_bank_acct_rec.iban IS NOT NULL THEN
1411: CE_BANK_AND_ACCOUNT_VALIDATION.validate_IBAN(p_ext_bank_acct_rec.iban, l_iban, x_return_status);
1412: IF not x_return_status=fnd_api.g_ret_sts_success
1413: THEN
1414: x_return_status := fnd_api.g_ret_sts_error;
1415: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1416: print_debuginfo('IBAN Validation Failed ');

Line 1414: x_return_status := fnd_api.g_ret_sts_error;

1410: IF p_ext_bank_acct_rec.iban IS NOT NULL THEN
1411: CE_BANK_AND_ACCOUNT_VALIDATION.validate_IBAN(p_ext_bank_acct_rec.iban, l_iban, x_return_status);
1412: IF not x_return_status=fnd_api.g_ret_sts_success
1413: THEN
1414: x_return_status := fnd_api.g_ret_sts_error;
1415: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1416: print_debuginfo('IBAN Validation Failed ');
1417: END IF;
1418: RAISE fnd_api.g_exc_error;

Line 1418: RAISE fnd_api.g_exc_error;

1414: x_return_status := fnd_api.g_ret_sts_error;
1415: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1416: print_debuginfo('IBAN Validation Failed ');
1417: END IF;
1418: RAISE fnd_api.g_exc_error;
1419: ELSE
1420: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1421: print_debuginfo('IBAN Validation Successful');
1422: END IF;

Line 1446: x_return_status := fnd_api.g_ret_sts_error;

1442: FETCH c_branch INTO l_branch_number;
1443: IF c_branch%NOTFOUND THEN
1444: fnd_message.set_name('IBY', 'IBY_API_NO_BRANCH');
1445: fnd_msg_pub.add;
1446: x_return_status := fnd_api.g_ret_sts_error;
1447: RAISE fnd_api.g_exc_error;
1448: ELSE
1449: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1450: print_debuginfo('Got Branch Number : '||l_branch_number);

Line 1447: RAISE fnd_api.g_exc_error;

1443: IF c_branch%NOTFOUND THEN
1444: fnd_message.set_name('IBY', 'IBY_API_NO_BRANCH');
1445: fnd_msg_pub.add;
1446: x_return_status := fnd_api.g_ret_sts_error;
1447: RAISE fnd_api.g_exc_error;
1448: ELSE
1449: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1450: print_debuginfo('Got Branch Number : '||l_branch_number);
1451: END IF;

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

1475: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1476: print_debuginfo('Return status from check exist:'||x_return_status);
1477: print_debuginfo('Duplicate account id:'||l_dup_acct_id);
1478: END IF;
1479: IF ((not x_return_status = fnd_api.g_ret_sts_success) OR
1480: (not l_dup_acct_id is null)) THEN
1481: fnd_message.set_name('IBY', 'IBY_UNIQ_ACCOUNT');
1482: fnd_msg_pub.add;
1483: /*OPEN c_supplier(l_dup_acct_id);

Line 1503: x_return_status := fnd_api.g_ret_sts_error;

1499: fnd_message.set_name('IBY', 'IBY_UNIQ_ACCOUNT_OU');
1500: fnd_message.set_Token('OU', l_org_name);
1501: fnd_msg_pub.add;
1502: END IF;
1503: x_return_status := fnd_api.g_ret_sts_error;
1504: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1505: print_debuginfo('Error : Duplicate Bank Account');
1506: END IF;
1507: RAISE fnd_api.g_exc_error;

Line 1507: RAISE fnd_api.g_exc_error;

1503: x_return_status := fnd_api.g_ret_sts_error;
1504: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1505: print_debuginfo('Error : Duplicate Bank Account');
1506: END IF;
1507: RAISE fnd_api.g_exc_error;
1508: END IF;
1509:
1510: -- country specific validation API call here.
1511: -- delete the message as CE using message count for error

Line 1557: FND_API.G_FALSE,

1553: p_ext_bank_acct_rec.check_digits,
1554: l_bank_number,
1555: l_branch_number,
1556: p_ext_bank_acct_rec.bank_account_num,
1557: FND_API.G_FALSE,
1558: x_msg_count,
1559: x_msg_data,
1560: x_return_status,
1561: 'EXTERNAL');

Line 1569: IF not x_return_status=fnd_api.g_ret_sts_success THEN

1565: print_debuginfo('Returned from Country Specific Check Digit Validations status:' || x_return_status);
1566: print_debuginfo('After Country Specific validations, l_masked_ba_num:'||
1567: l_masked_ba_num);
1568: END IF;
1569: IF not x_return_status=fnd_api.g_ret_sts_success THEN
1570: x_return_status := fnd_api.g_ret_sts_error;
1571: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1572: print_debuginfo('Account Validations Failed ');
1573: END IF;

Line 1570: x_return_status := fnd_api.g_ret_sts_error;

1566: print_debuginfo('After Country Specific validations, l_masked_ba_num:'||
1567: l_masked_ba_num);
1568: END IF;
1569: IF not x_return_status=fnd_api.g_ret_sts_success THEN
1570: x_return_status := fnd_api.g_ret_sts_error;
1571: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1572: print_debuginfo('Account Validations Failed ');
1573: END IF;
1574: return;

Line 1594: FND_API.G_FALSE,

1590: p_ext_bank_acct_rec.acct_type,
1591: p_ext_bank_acct_rec.acct_suffix,
1592: null, -- p_secondary_acct_reference,
1593: p_ext_bank_acct_rec.bank_account_name,
1594: FND_API.G_FALSE,
1595: x_msg_count,
1596: x_msg_data,
1597: l_account_number,
1598: x_return_status,

Line 1607: IF not x_return_status=fnd_api.g_ret_sts_success THEN

1603: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1604: print_debuginfo('Returned from Country Specific Account Validations');
1605:
1606: END IF;
1607: IF not x_return_status=fnd_api.g_ret_sts_success THEN
1608: x_return_status := fnd_api.g_ret_sts_error;
1609: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1610: print_debuginfo('Account Validations Failed ');
1611: END IF;

Line 1608: x_return_status := fnd_api.g_ret_sts_error;

1604: print_debuginfo('Returned from Country Specific Account Validations');
1605:
1606: END IF;
1607: IF not x_return_status=fnd_api.g_ret_sts_success THEN
1608: x_return_status := fnd_api.g_ret_sts_error;
1609: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1610: print_debuginfo('Account Validations Failed ');
1611: END IF;
1612: return;

Line 1631: IF nvl(l_ret_stat,fnd_api.g_ret_sts_success) = fnd_api.g_ret_sts_error THEN

1627: print_debuginfo('Return Status from Custom Validation::'||l_ret_stat);
1628: print_debuginfo('Error Message from Custom Validation::'||l_error_msg);
1629: END IF;
1630:
1631: IF nvl(l_ret_stat,fnd_api.g_ret_sts_success) = fnd_api.g_ret_sts_error THEN
1632: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1633: print_debuginfo('Custom Validation Failed..');
1634: END IF;
1635: x_return_status := fnd_api.g_ret_sts_error;

Line 1635: x_return_status := fnd_api.g_ret_sts_error;

1631: IF nvl(l_ret_stat,fnd_api.g_ret_sts_success) = fnd_api.g_ret_sts_error THEN
1632: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1633: print_debuginfo('Custom Validation Failed..');
1634: END IF;
1635: x_return_status := fnd_api.g_ret_sts_error;
1636: fnd_message.set_name('IBY', 'IBY_CUST_BANK_ACCT_VAL');
1637: fnd_message.set_Token('ERROR_MESSAGE',l_error_msg);
1638: fnd_msg_pub.add;
1639: RETURN;

Line 1814: RAISE fnd_api.g_exc_unexpected_error;

1810: ELSE
1811: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1812: print_debuginfo('Failed to insert in IBY_EXT_BANK_ACCOUNTS');
1813: END IF;
1814: RAISE fnd_api.g_exc_unexpected_error;
1815: END IF;
1816:
1817: -- End of API
1818:

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

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

Line 1862: WHEN fnd_api.g_exc_error THEN

1858:
1859:
1860: END IF;
1861: EXCEPTION
1862: WHEN fnd_api.g_exc_error THEN
1863: ROLLBACK TO create_ext_bank_acct_pub;
1864: x_return_status := fnd_api.g_ret_sts_error;
1865: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1866: print_debuginfo('Exception : ' || SQLERRM);

Line 1864: x_return_status := fnd_api.g_ret_sts_error;

1860: END IF;
1861: EXCEPTION
1862: WHEN fnd_api.g_exc_error THEN
1863: ROLLBACK TO create_ext_bank_acct_pub;
1864: x_return_status := fnd_api.g_ret_sts_error;
1865: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1866: print_debuginfo('Exception : ' || SQLERRM);
1867: END IF;
1868: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

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

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

Line 1873: WHEN fnd_api.g_exc_unexpected_error THEN

1869: p_count => x_msg_count,
1870: p_data => x_msg_data);
1871:
1872:
1873: WHEN fnd_api.g_exc_unexpected_error THEN
1874: ROLLBACK TO create_ext_bank_acct_pub;
1875: x_return_status := fnd_api.g_ret_sts_unexp_error;
1876: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1877: print_debuginfo('Exception : ' || SQLERRM);

Line 1875: x_return_status := fnd_api.g_ret_sts_unexp_error;

1871:
1872:
1873: WHEN fnd_api.g_exc_unexpected_error THEN
1874: ROLLBACK TO create_ext_bank_acct_pub;
1875: x_return_status := fnd_api.g_ret_sts_unexp_error;
1876: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1877: print_debuginfo('Exception : ' || SQLERRM);
1878: END IF;
1879: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

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

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

Line 1887: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

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

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

Line 1990: x_return_status := fnd_api.g_ret_sts_error;

1986: FETCH c_branch INTO l_branch_number;
1987: IF c_branch%NOTFOUND THEN
1988: fnd_message.set_name('IBY', 'IBY_API_NO_BRANCH');
1989: fnd_msg_pub.add;
1990: x_return_status := fnd_api.g_ret_sts_error;
1991: RAISE fnd_api.g_exc_error;
1992: ELSE
1993: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1994: print_debuginfo('Got Branch Number : '||l_branch_number);

Line 1991: RAISE fnd_api.g_exc_error;

1987: IF c_branch%NOTFOUND THEN
1988: fnd_message.set_name('IBY', 'IBY_API_NO_BRANCH');
1989: fnd_msg_pub.add;
1990: x_return_status := fnd_api.g_ret_sts_error;
1991: RAISE fnd_api.g_exc_error;
1992: ELSE
1993: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1994: print_debuginfo('Got Branch Number : '||l_branch_number);
1995: END IF;

Line 2008: FND_API.G_FALSE,

2004: p_ext_bank_acct_rec.check_digits,
2005: l_bank_number,
2006: l_branch_number,
2007: p_ext_bank_acct_rec.bank_account_num,
2008: FND_API.G_FALSE,
2009: x_msg_count,
2010: x_msg_data,
2011: x_return_status,
2012: 'EXTERNAL');

Line 2015: IF(x_return_status<>fnd_api.g_ret_sts_success)

2011: x_return_status,
2012: 'EXTERNAL');
2013: END IF;
2014:
2015: IF(x_return_status<>fnd_api.g_ret_sts_success)
2016: THEN
2017: x_return_status := fnd_api.g_ret_sts_error;
2018: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2019: print_debuginfo('Account Validations Failed ');

Line 2017: x_return_status := fnd_api.g_ret_sts_error;

2013: END IF;
2014:
2015: IF(x_return_status<>fnd_api.g_ret_sts_success)
2016: THEN
2017: x_return_status := fnd_api.g_ret_sts_error;
2018: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2019: print_debuginfo('Account Validations Failed ');
2020: END IF;
2021: return;

Line 2155: WHEN FND_API.G_EXC_ERROR THEN

2151: print_debuginfo('Exit '||l_module);
2152: END IF;
2153: EXCEPTION
2154:
2155: WHEN FND_API.G_EXC_ERROR THEN
2156: ROLLBACK TO create_ext_bank_acct_thru_api;
2157: x_return_status := fnd_api.g_ret_sts_error;
2158: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2159: print_debuginfo('Exception : ' || SQLERRM);

Line 2157: x_return_status := fnd_api.g_ret_sts_error;

2153: EXCEPTION
2154:
2155: WHEN FND_API.G_EXC_ERROR THEN
2156: ROLLBACK TO create_ext_bank_acct_thru_api;
2157: x_return_status := fnd_api.g_ret_sts_error;
2158: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2159: print_debuginfo('Exception : ' || SQLERRM);
2160: END IF;
2161: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

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

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

Line 2164: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 2166: x_return_status := fnd_api.g_ret_sts_unexp_error;

2162: p_count => x_msg_count,
2163: p_data => x_msg_data);
2164: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2165: ROLLBACK TO create_ext_bank_acct_thru_api;
2166: x_return_status := fnd_api.g_ret_sts_unexp_error;
2167: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2168: print_debuginfo('Exception : ' || SQLERRM);
2169: END IF;
2170: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

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

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

Line 2175: x_return_status := FND_API.G_RET_STS_ERROR ;

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

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

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

Line 2184: x_return_status := FND_API.G_RET_STS_ERROR ;

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

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

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

Line 2193: x_return_status := FND_API.G_RET_STS_ERROR ;

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

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

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

Line 2202: x_return_status := FND_API.G_RET_STS_ERROR ;

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

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

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

Line 2211: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

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

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

Line 2355: IF NOT FND_API.Compatible_API_Call(l_api_version,

2351: END IF;
2352: SAVEPOINT update_ext_bank_acct_pub;
2353:
2354: -- Standard call to check for call compatibility.
2355: IF NOT FND_API.Compatible_API_Call(l_api_version,
2356: p_api_version,
2357: l_api_name,
2358: G_PKG_NAME) THEN
2359: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2359: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2355: IF NOT FND_API.Compatible_API_Call(l_api_version,
2356: p_api_version,
2357: l_api_name,
2358: G_PKG_NAME) THEN
2359: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2360: END IF;
2361:
2362: -- Initialize message list if p_init_msg_list is set to TRUE.
2363: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 2363: IF FND_API.to_Boolean(p_init_msg_list) THEN

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

Line 2368: x_return_status := FND_API.G_RET_STS_SUCCESS;

2364: FND_MSG_PUB.initialize;
2365: END IF;
2366:
2367: -- Initialize API return status to success
2368: x_return_status := FND_API.G_RET_STS_SUCCESS;
2369:
2370: -- Start of API Body
2371:
2372: -- Parameter validations

Line 2397: x_return_status := fnd_api.g_ret_sts_error;

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

Line 2399: RAISE fnd_api.g_exc_error;

2395: fnd_message.set_name('IBY', 'IBY_API_NO_EXT_BANK_ACCT');
2396: fnd_msg_pub.add;
2397: x_return_status := fnd_api.g_ret_sts_error;
2398: CLOSE c_ovn;
2399: RAISE fnd_api.g_exc_error;
2400: END IF;
2401: CLOSE c_ovn;
2402: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2403: print_debuginfo('Current object_version_number Version Number ' || l_old_ovn);

Line 2409: x_return_status := fnd_api.g_ret_sts_error;

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

Line 2413: RAISE fnd_api.g_exc_error;

2409: x_return_status := fnd_api.g_ret_sts_error;
2410: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2411: print_debuginfo('Error: Object Version Number Mismatch');
2412: END IF;
2413: RAISE fnd_api.g_exc_error;
2414: END IF;
2415: -- no need for unique check
2416: -- perform unique check for account
2417: -- passing in the ext bank account id to the query for unique check

Line 2429: x_return_status := fnd_api.g_ret_sts_error;

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

Line 2430: RAISE fnd_api.g_exc_error;

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

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

2436: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2437: print_debuginfo('Return status from check exist:'||x_return_status);
2438: print_debuginfo('Duplicate account id:'||l_dup_acct_id);
2439: END IF;
2440: IF ((not x_return_status = fnd_api.g_ret_sts_success) OR
2441: (not l_dup_acct_id is null)) THEN
2442: fnd_message.set_name('IBY', 'IBY_UNIQ_ACCOUNT');
2443: fnd_msg_pub.add;
2444: x_return_status := fnd_api.g_ret_sts_error;

Line 2444: x_return_status := fnd_api.g_ret_sts_error;

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

Line 2448: RAISE fnd_api.g_exc_error;

2444: x_return_status := fnd_api.g_ret_sts_error;
2445: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2446: print_debuginfo('Error : Duplicate Bank Account');
2447: END IF;
2448: RAISE fnd_api.g_exc_error;
2449: END IF;
2450:
2451: */
2452:

Line 2587: IF x_return_status=fnd_api.g_ret_sts_success THEN

2583: IF(NOT l_iban IS NULL) THEN
2584: CE_BANK_AND_ACCOUNT_VALIDATION.validate_IBAN
2585: (p_ext_bank_acct_rec.iban, l_iban, x_return_status);
2586: -- throw exception???
2587: IF x_return_status=fnd_api.g_ret_sts_success THEN
2588: l_iban :=p_ext_bank_acct_rec.iban;
2589: ELSE
2590: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2591: print_debuginfo('IBAN Validation Failed ');

Line 2593: RAISE fnd_api.g_exc_error;

2589: ELSE
2590: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2591: print_debuginfo('IBAN Validation Failed ');
2592: END IF;
2593: RAISE fnd_api.g_exc_error;
2594: END IF;
2595: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2596: print_debuginfo('Validated IBAN Number');
2597: print_debuginfo(x_return_status);

Line 2641: when fnd_api.g_exc_error then

2637: l_iban_hash2:=l_old_iban_hash2;
2638: l_masked_iban:=l_old_masked_iban;
2639: end if;
2640: exception
2641: when fnd_api.g_exc_error then
2642: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2643: print_debuginfo('Exception in iban compare');
2644: END IF;
2645: Raise fnd_api.g_exc_error;

Line 2645: Raise fnd_api.g_exc_error;

2641: when fnd_api.g_exc_error then
2642: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2643: print_debuginfo('Exception in iban compare');
2644: END IF;
2645: Raise fnd_api.g_exc_error;
2646: when others then
2647:
2648: -- the bank account number is not provided by the user
2649: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

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

2673: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2674: print_debuginfo('Return status from check exist:'||x_return_status);
2675: print_debuginfo('Duplicate account id:'||l_dup_acct_id);
2676: END IF;
2677: IF ((not x_return_status = fnd_api.g_ret_sts_success) OR
2678: (not l_dup_acct_id is null)) THEN
2679: fnd_message.set_name('IBY', 'IBY_UNIQ_ACCOUNT');
2680: fnd_msg_pub.add;
2681: /*OPEN c_supplier(l_dup_acct_id);

Line 2701: x_return_status := fnd_api.g_ret_sts_error;

2697: fnd_message.set_name('IBY', 'IBY_UNIQ_ACCOUNT_OU');
2698: fnd_message.set_Token('OU',l_org_name);
2699: fnd_msg_pub.add;
2700: END IF;
2701: x_return_status := fnd_api.g_ret_sts_error;
2702: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2703: print_debuginfo('Error : Duplicate Bank Account');
2704: END IF;
2705: RAISE fnd_api.g_exc_error;

Line 2705: RAISE fnd_api.g_exc_error;

2701: x_return_status := fnd_api.g_ret_sts_error;
2702: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2703: print_debuginfo('Error : Duplicate Bank Account');
2704: END IF;
2705: RAISE fnd_api.g_exc_error;
2706: END IF;
2707:
2708: -- country specific validation API call here.
2709: -- delete the message as CE using message count for error

Line 2736: FND_API.G_FALSE,

2732: p_ext_bank_acct_rec.check_digits,
2733: l_bank_number,
2734: l_branch_number,
2735: p_ext_bank_acct_rec.bank_account_num,
2736: FND_API.G_FALSE,
2737: x_msg_count,
2738: x_msg_data,
2739: x_return_status,
2740: 'EXTERNAL');

Line 2747: IF not x_return_status=fnd_api.g_ret_sts_success THEN

2743: print_debuginfo('Returned from Country Specific Check Digit Validations status:' || x_return_status);
2744: print_debuginfo('After Country Specific validations, l_masked_ba_num:'||
2745: l_masked_ba_num);
2746: END IF;
2747: IF not x_return_status=fnd_api.g_ret_sts_success THEN
2748:
2749: x_return_status := fnd_api.g_ret_sts_error;
2750: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2751: print_debuginfo('Account Validations Failed ');

Line 2749: x_return_status := fnd_api.g_ret_sts_error;

2745: l_masked_ba_num);
2746: END IF;
2747: IF not x_return_status=fnd_api.g_ret_sts_success THEN
2748:
2749: x_return_status := fnd_api.g_ret_sts_error;
2750: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2751: print_debuginfo('Account Validations Failed ');
2752: END IF;
2753: return;

Line 2773: FND_API.G_FALSE,

2769: p_ext_bank_acct_rec.acct_type,
2770: p_ext_bank_acct_rec.acct_suffix,
2771: null, -- p_secondary_acct_reference,
2772: p_ext_bank_acct_rec.bank_account_name,
2773: FND_API.G_FALSE,
2774: x_msg_count,
2775: x_msg_data,
2776: l_acct_number,
2777: x_return_status,

Line 2867: IF not x_return_status=fnd_api.g_ret_sts_success THEN

2863: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2864: print_debuginfo('Returned from Account Validations' || x_return_status);
2865: print_debuginfo('After CE s and after masking l_masked_ba_num:'||l_masked_ba_num);
2866: END IF;
2867: IF not x_return_status=fnd_api.g_ret_sts_success THEN
2868: x_return_status := fnd_api.g_ret_sts_error;
2869: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2870: print_debuginfo('Account Validations Failed ');
2871: END IF;

Line 2868: x_return_status := fnd_api.g_ret_sts_error;

2864: print_debuginfo('Returned from Account Validations' || x_return_status);
2865: print_debuginfo('After CE s and after masking l_masked_ba_num:'||l_masked_ba_num);
2866: END IF;
2867: IF not x_return_status=fnd_api.g_ret_sts_success THEN
2868: x_return_status := fnd_api.g_ret_sts_error;
2869: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2870: print_debuginfo('Account Validations Failed ');
2871: END IF;
2872: return;

Line 2908: IF nvl(l_ret_stat,fnd_api.g_ret_sts_success) = fnd_api.g_ret_sts_error THEN

2904: print_debuginfo('Return Status from Custom Validation::'||l_ret_stat);
2905: print_debuginfo('Error Message from Custom Validation::'||l_error_msg);
2906: END IF;
2907:
2908: IF nvl(l_ret_stat,fnd_api.g_ret_sts_success) = fnd_api.g_ret_sts_error THEN
2909: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2910: print_debuginfo('Custom Validation Failed..');
2911: END IF;
2912: x_return_status := fnd_api.g_ret_sts_error;

Line 2912: x_return_status := fnd_api.g_ret_sts_error;

2908: IF nvl(l_ret_stat,fnd_api.g_ret_sts_success) = fnd_api.g_ret_sts_error THEN
2909: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2910: print_debuginfo('Custom Validation Failed..');
2911: END IF;
2912: x_return_status := fnd_api.g_ret_sts_error;
2913: fnd_message.set_name('IBY', 'IBY_CUST_BANK_ACCT_VAL');
2914: fnd_message.set_Token('ERROR_MESSAGE',l_error_msg);
2915: fnd_msg_pub.add;
2916: RETURN;

Line 2929: IBAN = DECODE(l_iban, FND_API.G_MISS_CHAR,NULL,l_iban),

2925: UPDATE IBY_EXT_BANK_ACCOUNTS
2926: SET BANK_ACCOUNT_NUM = nvl(l_acct_number, BANK_ACCOUNT_NUM),
2927: COUNTRY_CODE=p_ext_bank_acct_rec.country_code,
2928: CURRENCY_CODE =p_ext_bank_acct_rec.currency,
2929: IBAN = DECODE(l_iban, FND_API.G_MISS_CHAR,NULL,l_iban),
2930: CHECK_DIGITS = p_ext_bank_acct_rec.check_digits,
2931: -- MULTI_CURRENCY_ALLOWED_FLAG = p_ext_bank_acct_rec.multi_currency_allowed_flag,
2932: BANK_ACCOUNT_TYPE =p_ext_bank_acct_rec.acct_type,
2933: ACCOUNT_SUFFIX = p_ext_bank_acct_rec.acct_suffix,

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

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

Line 3002: WHEN fnd_api.g_exc_error THEN

2998: print_debuginfo('RETURN ' || l_module_name);
2999:
3000: END IF;
3001: EXCEPTION
3002: WHEN fnd_api.g_exc_error THEN
3003: ROLLBACK TO update_ext_bank_acct_pub;
3004: x_return_status := fnd_api.g_ret_sts_error;
3005: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3006: p_count => x_msg_count,

Line 3004: x_return_status := fnd_api.g_ret_sts_error;

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

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

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

Line 3010: WHEN fnd_api.g_exc_unexpected_error THEN

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

Line 3012: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

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

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

Line 3020: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

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

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

Line 3139: IF NOT FND_API.Compatible_API_Call(l_api_version,

3135: print_debuginfo('ENTER ' || l_module_name);
3136:
3137: END IF;
3138: -- Standard call to check for call compatibility.
3139: IF NOT FND_API.Compatible_API_Call(l_api_version,
3140: p_api_version,
3141: l_api_name,
3142: G_PKG_NAME) THEN
3143: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3143: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3139: IF NOT FND_API.Compatible_API_Call(l_api_version,
3140: p_api_version,
3141: l_api_name,
3142: G_PKG_NAME) THEN
3143: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3144: END IF;
3145:
3146: -- Initialize message list if p_init_msg_list is set to TRUE.
3147: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 3147: IF FND_API.to_Boolean(p_init_msg_list) THEN

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

Line 3152: x_return_status := FND_API.G_RET_STS_SUCCESS;

3148: FND_MSG_PUB.initialize;
3149: END IF;
3150:
3151: -- Initialize API return status to success
3152: x_return_status := FND_API.G_RET_STS_SUCCESS;
3153:
3154: -- Start of API body
3155:
3156: check_mandatory('IBY_BANKACCT_ID_FIELD', p_bankacct_id);

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

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

Line 3225: WHEN fnd_api.g_exc_error THEN

3221: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3222: print_debuginfo('RETURN ' || l_module_name);
3223: END IF;
3224: EXCEPTION
3225: WHEN fnd_api.g_exc_error THEN
3226: x_return_status := fnd_api.g_ret_sts_error;
3227: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3228: print_debuginfo('Exception : ' || SQLERRM);
3229: END IF;

Line 3226: x_return_status := fnd_api.g_ret_sts_error;

3222: print_debuginfo('RETURN ' || l_module_name);
3223: END IF;
3224: EXCEPTION
3225: WHEN fnd_api.g_exc_error THEN
3226: x_return_status := fnd_api.g_ret_sts_error;
3227: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3228: print_debuginfo('Exception : ' || SQLERRM);
3229: END IF;
3230: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

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

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

Line 3235: WHEN fnd_api.g_exc_unexpected_error THEN

3231: p_count => x_msg_count,
3232: p_data => x_msg_data);
3233:
3234:
3235: WHEN fnd_api.g_exc_unexpected_error THEN
3236: x_return_status := fnd_api.g_ret_sts_unexp_error;
3237: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3238: print_debuginfo('Exception : ' || SQLERRM);
3239: END IF;

Line 3236: x_return_status := fnd_api.g_ret_sts_unexp_error;

3232: p_data => x_msg_data);
3233:
3234:
3235: WHEN fnd_api.g_exc_unexpected_error THEN
3236: x_return_status := fnd_api.g_ret_sts_unexp_error;
3237: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3238: print_debuginfo('Exception : ' || SQLERRM);
3239: END IF;
3240: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

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

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

Line 3246: x_return_status := fnd_api.g_ret_sts_unexp_error;

3242: p_data => x_msg_data);
3243:
3244:
3245: WHEN OTHERS THEN
3246: x_return_status := fnd_api.g_ret_sts_unexp_error;
3247: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3248: print_debuginfo('Exception : ' || SQLERRM);
3249: END IF;
3250: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);

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

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

Line 3296: IF NOT FND_API.Compatible_API_Call(l_api_version,

3292: END IF;
3293: SAVEPOINT get_ext_bank_acct_pub;
3294:
3295: -- Standard call to check for call compatibility.
3296: IF NOT FND_API.Compatible_API_Call(l_api_version,
3297: p_api_version,
3298: l_api_name,
3299: G_PKG_NAME) THEN
3300: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3300: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3296: IF NOT FND_API.Compatible_API_Call(l_api_version,
3297: p_api_version,
3298: l_api_name,
3299: G_PKG_NAME) THEN
3300: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3301: END IF;
3302:
3303: -- Initialize message list if p_init_msg_list is set to TRUE.
3304: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 3304: IF FND_API.to_Boolean(p_init_msg_list) THEN

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

Line 3309: x_return_status := FND_API.G_RET_STS_SUCCESS;

3305: FND_MSG_PUB.initialize;
3306: END IF;
3307:
3308: -- Initialize API return status to success
3309: x_return_status := FND_API.G_RET_STS_SUCCESS;
3310:
3311: -- Start of API body
3312:
3313: --

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

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

Line 3338: WHEN fnd_api.g_exc_error THEN

3334: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3335: print_debuginfo('RETURN ' || l_module_name);
3336: END IF;
3337: EXCEPTION
3338: WHEN fnd_api.g_exc_error THEN
3339: ROLLBACK TO get_ext_bank_acct_pub;
3340: x_return_status := fnd_api.g_ret_sts_error;
3341: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3342: print_debuginfo('Exception : ' || SQLERRM);

Line 3340: x_return_status := fnd_api.g_ret_sts_error;

3336: END IF;
3337: EXCEPTION
3338: WHEN fnd_api.g_exc_error THEN
3339: ROLLBACK TO get_ext_bank_acct_pub;
3340: x_return_status := fnd_api.g_ret_sts_error;
3341: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3342: print_debuginfo('Exception : ' || SQLERRM);
3343: END IF;
3344: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

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

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

Line 3349: WHEN fnd_api.g_exc_unexpected_error THEN

3345: p_count => x_msg_count,
3346: p_data => x_msg_data);
3347:
3348:
3349: WHEN fnd_api.g_exc_unexpected_error THEN
3350: ROLLBACK TO get_ext_bank_acct_pub;
3351: x_return_status := fnd_api.g_ret_sts_unexp_error;
3352: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3353: print_debuginfo('Exception : ' || SQLERRM);

Line 3351: x_return_status := fnd_api.g_ret_sts_unexp_error;

3347:
3348:
3349: WHEN fnd_api.g_exc_unexpected_error THEN
3350: ROLLBACK TO get_ext_bank_acct_pub;
3351: x_return_status := fnd_api.g_ret_sts_unexp_error;
3352: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3353: print_debuginfo('Exception : ' || SQLERRM);
3354: END IF;
3355: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

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

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

Line 3362: x_return_status := fnd_api.g_ret_sts_unexp_error;

3358:
3359:
3360: WHEN OTHERS THEN
3361: ROLLBACK TO get_ext_bank_acct_pub;
3362: x_return_status := fnd_api.g_ret_sts_unexp_error;
3363: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3364: print_debuginfo('Exception : ' || SQLERRM);
3365: END IF;
3366: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);

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

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

Line 3412: IF NOT FND_API.Compatible_API_Call(l_api_version,

3408: END IF;
3409: SAVEPOINT set_ext_bank_acct_dates_pub;
3410:
3411: -- Standard call to check for call compatibility.
3412: IF NOT FND_API.Compatible_API_Call(l_api_version,
3413: p_api_version,
3414: l_api_name,
3415: G_PKG_NAME) THEN
3416: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3416: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3412: IF NOT FND_API.Compatible_API_Call(l_api_version,
3413: p_api_version,
3414: l_api_name,
3415: G_PKG_NAME) THEN
3416: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3417: END IF;
3418:
3419: -- Initialize message list if p_init_msg_list is set to TRUE.
3420: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 3420: IF FND_API.to_Boolean(p_init_msg_list) THEN

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

Line 3425: x_return_status := FND_API.G_RET_STS_SUCCESS;

3421: FND_MSG_PUB.initialize;
3422: END IF;
3423:
3424: -- Initialize API return status to success
3425: x_return_status := FND_API.G_RET_STS_SUCCESS;
3426:
3427: -- Start of API body
3428:
3429: -- Parameter validations

Line 3441: RAISE fnd_api.g_exc_error;

3437: -- throw exception if start date
3438: -- exceeds end_date
3439: fnd_message.set_name('IBY', 'IBY_START_END_DATE_BAD');
3440: fnd_msg_pub.add;
3441: RAISE fnd_api.g_exc_error;
3442: END IF;
3443:
3444: -- update bank account dates
3445: UPDATE IBY_EXT_BANK_ACCOUNTS

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

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

Line 3471: WHEN fnd_api.g_exc_error THEN

3467: print_debuginfo('RETURN ' || l_module_name);
3468:
3469: END IF;
3470: EXCEPTION
3471: WHEN fnd_api.g_exc_error THEN
3472: ROLLBACK TO set_ext_bank_acct_dates_pub;
3473: x_return_status := fnd_api.g_ret_sts_error;
3474: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3475: p_count => x_msg_count,

Line 3473: x_return_status := fnd_api.g_ret_sts_error;

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

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

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

Line 3479: WHEN fnd_api.g_exc_unexpected_error THEN

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

Line 3481: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

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

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

Line 3489: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

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

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

Line 3631: IF NOT FND_API.Compatible_API_Call(l_api_version,

3627:
3628:
3629: END IF;
3630: -- Standard call to check for call compatibility.
3631: IF NOT FND_API.Compatible_API_Call(l_api_version,
3632: p_api_version,
3633: l_api_name,
3634: G_PKG_NAME) THEN
3635: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3635: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3631: IF NOT FND_API.Compatible_API_Call(l_api_version,
3632: p_api_version,
3633: l_api_name,
3634: G_PKG_NAME) THEN
3635: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3636: END IF;
3637:
3638: -- Initialize message list if p_init_msg_list is set to TRUE.
3639: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 3639: IF FND_API.to_Boolean(p_init_msg_list) THEN

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

Line 3644: x_return_status := FND_API.G_RET_STS_SUCCESS;

3640: FND_MSG_PUB.initialize;
3641: END IF;
3642:
3643: -- Initialize API return status to success
3644: x_return_status := FND_API.G_RET_STS_SUCCESS;
3645:
3646: -- Parameter validations
3647:
3648: IF (p_ext_bank_acct_rec.bank_account_name IS NULL) THEN

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

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

Line 3725: WHEN fnd_api.g_exc_error THEN

3721: print_debuginfo('RETURN ' || l_module_name);
3722:
3723: END IF;
3724: EXCEPTION
3725: WHEN fnd_api.g_exc_error THEN
3726: x_return_status := fnd_api.g_ret_sts_error;
3727: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3728: print_debuginfo('Exception : ' || SQLERRM);
3729: END IF;

Line 3726: x_return_status := fnd_api.g_ret_sts_error;

3722:
3723: END IF;
3724: EXCEPTION
3725: WHEN fnd_api.g_exc_error THEN
3726: x_return_status := fnd_api.g_ret_sts_error;
3727: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3728: print_debuginfo('Exception : ' || SQLERRM);
3729: END IF;
3730: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

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

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

Line 3735: WHEN fnd_api.g_exc_unexpected_error THEN

3731: p_count => x_msg_count,
3732: p_data => x_msg_data);
3733:
3734:
3735: WHEN fnd_api.g_exc_unexpected_error THEN
3736: x_return_status := fnd_api.g_ret_sts_unexp_error;
3737: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3738: print_debuginfo('Exception : ' || SQLERRM);
3739: END IF;

Line 3736: x_return_status := fnd_api.g_ret_sts_unexp_error;

3732: p_data => x_msg_data);
3733:
3734:
3735: WHEN fnd_api.g_exc_unexpected_error THEN
3736: x_return_status := fnd_api.g_ret_sts_unexp_error;
3737: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3738: print_debuginfo('Exception : ' || SQLERRM);
3739: END IF;
3740: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

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

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

Line 3746: x_return_status := fnd_api.g_ret_sts_unexp_error;

3742: p_data => x_msg_data);
3743:
3744:
3745: WHEN OTHERS THEN
3746: x_return_status := fnd_api.g_ret_sts_unexp_error;
3747: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3748: print_debuginfo('Exception : ' || SQLERRM);
3749: END IF;
3750: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);

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

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

Line 3870: IF NOT FND_API.Compatible_API_Call(l_api_version,

3866: END IF;
3867: SAVEPOINT create_intermediary_acct_pub;
3868:
3869: -- Standard call to check for call compatibility.
3870: IF NOT FND_API.Compatible_API_Call(l_api_version,
3871: p_api_version,
3872: l_api_name,
3873: G_PKG_NAME) THEN
3874: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3874: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3870: IF NOT FND_API.Compatible_API_Call(l_api_version,
3871: p_api_version,
3872: l_api_name,
3873: G_PKG_NAME) THEN
3874: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3875: END IF;
3876:
3877: -- Initialize message list if p_init_msg_list is set to TRUE.
3878: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 3878: IF FND_API.to_Boolean(p_init_msg_list) THEN

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

Line 3883: x_return_status := FND_API.G_RET_STS_SUCCESS;

3879: FND_MSG_PUB.initialize;
3880: END IF;
3881:
3882: -- Initialize API return status to success
3883: x_return_status := FND_API.G_RET_STS_SUCCESS;
3884:
3885: -- Parameter validations
3886: check_mandatory('IBY_BANKACCT_ID_FIELD', p_intermed_acct_rec.bank_account_id);
3887:

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

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

Line 3944: WHEN fnd_api.g_exc_error THEN

3940:
3941:
3942: END IF;
3943: EXCEPTION
3944: WHEN fnd_api.g_exc_error THEN
3945: ROLLBACK TO create_intermediary_acct_pub;
3946: x_return_status := fnd_api.g_ret_sts_error;
3947: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3948: p_count => x_msg_count,

Line 3946: x_return_status := fnd_api.g_ret_sts_error;

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

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

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

Line 3952: WHEN fnd_api.g_exc_unexpected_error THEN

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

Line 3954: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

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

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

Line 3962: x_return_status := fnd_api.g_ret_sts_unexp_error;

3958:
3959:
3960: WHEN OTHERS THEN
3961: ROLLBACK TO create_intermediary_acct_pub;
3962: x_return_status := fnd_api.g_ret_sts_unexp_error;
3963: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3964: print_debuginfo('Exception : ' || SQLERRM);
3965: END IF;
3966: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);

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

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

Line 4018: IF NOT FND_API.Compatible_API_Call(l_api_version,

4014: END IF;
4015: SAVEPOINT update_intermediary_acct;
4016:
4017: -- Standard call to check for call compatibility.
4018: IF NOT FND_API.Compatible_API_Call(l_api_version,
4019: p_api_version,
4020: l_api_name,
4021: G_PKG_NAME) THEN
4022: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4022: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4018: IF NOT FND_API.Compatible_API_Call(l_api_version,
4019: p_api_version,
4020: l_api_name,
4021: G_PKG_NAME) THEN
4022: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4023: END IF;
4024:
4025: -- Initialize message list if p_init_msg_list is set to TRUE.
4026: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 4026: IF FND_API.to_Boolean(p_init_msg_list) THEN

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

Line 4031: x_return_status := FND_API.G_RET_STS_SUCCESS;

4027: FND_MSG_PUB.initialize;
4028: END IF;
4029:
4030: -- Initialize API return status to success
4031: x_return_status := FND_API.G_RET_STS_SUCCESS;
4032:
4033: --START of API
4034:
4035: -- Parameter validations

Line 4045: x_return_status := fnd_api.g_ret_sts_error;

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

Line 4047: RAISE fnd_api.g_exc_error;

4043: fnd_message.set_name('IBY', 'IBY_API_NO_INTERMEDIARY_ACCT');
4044: fnd_msg_pub.add;
4045: x_return_status := fnd_api.g_ret_sts_error;
4046: CLOSE c_ovn;
4047: RAISE fnd_api.g_exc_error;
4048: END IF;
4049: CLOSE c_ovn;
4050:
4051: IF l_old_ovn > p_intermed_acct_rec.object_version_number THEN

Line 4054: x_return_status := fnd_api.g_ret_sts_error;

4050:
4051: IF l_old_ovn > p_intermed_acct_rec.object_version_number THEN
4052: fnd_message.set_name('IBY', 'IBY_DATA_VERSION_ERROR');
4053: fnd_msg_pub.add;
4054: x_return_status := fnd_api.g_ret_sts_error;
4055: RAISE fnd_api.g_exc_error;
4056: END IF;
4057:
4058: -- update the table IBY_INTERMEDIARY_ACCOUNTS

Line 4055: RAISE fnd_api.g_exc_error;

4051: IF l_old_ovn > p_intermed_acct_rec.object_version_number THEN
4052: fnd_message.set_name('IBY', 'IBY_DATA_VERSION_ERROR');
4053: fnd_msg_pub.add;
4054: x_return_status := fnd_api.g_ret_sts_error;
4055: RAISE fnd_api.g_exc_error;
4056: END IF;
4057:
4058: -- update the table IBY_INTERMEDIARY_ACCOUNTS
4059: UPDATE IBY_INTERMEDIARY_ACCTS

Line 4080: x_return_status := fnd_api.g_ret_sts_error;

4076:
4077: IF (SQL%NOTFOUND) THEN
4078: fnd_message.set_name('IBY', 'IBY_API_NO_INTERMEDIARY_ACCT');
4079: fnd_msg_pub.add;
4080: x_return_status := fnd_api.g_ret_sts_error;
4081: RAISE fnd_api.g_exc_error;
4082: END IF;
4083:
4084: -- END of API

Line 4081: RAISE fnd_api.g_exc_error;

4077: IF (SQL%NOTFOUND) THEN
4078: fnd_message.set_name('IBY', 'IBY_API_NO_INTERMEDIARY_ACCT');
4079: fnd_msg_pub.add;
4080: x_return_status := fnd_api.g_ret_sts_error;
4081: RAISE fnd_api.g_exc_error;
4082: END IF;
4083:
4084: -- END of API
4085:

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

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

Line 4096: WHEN fnd_api.g_exc_error THEN

4092: print_debuginfo('RETURN ' || l_module_name);
4093:
4094: END IF;
4095: EXCEPTION
4096: WHEN fnd_api.g_exc_error THEN
4097: ROLLBACK TO update_intermediary_bank_acct;
4098: x_return_status := fnd_api.g_ret_sts_error;
4099: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4100: p_count => x_msg_count,

Line 4098: x_return_status := fnd_api.g_ret_sts_error;

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

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

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

Line 4104: WHEN fnd_api.g_exc_unexpected_error THEN

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

Line 4106: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

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

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

Line 4114: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

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

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

Line 4179: IF NOT FND_API.Compatible_API_Call(l_api_version,

4175: END IF;
4176: SAVEPOINT add_joint_account_owner;
4177:
4178: -- Standard call to check for call compatibility.
4179: IF NOT FND_API.Compatible_API_Call(l_api_version,
4180: p_api_version,
4181: l_api_name,
4182: G_PKG_NAME) THEN
4183: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4183: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4179: IF NOT FND_API.Compatible_API_Call(l_api_version,
4180: p_api_version,
4181: l_api_name,
4182: G_PKG_NAME) THEN
4183: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4184: END IF;
4185:
4186: -- Initialize message list if p_init_msg_list is set to TRUE.
4187: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 4187: IF FND_API.to_Boolean(p_init_msg_list) THEN

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

Line 4192: x_return_status := FND_API.G_RET_STS_SUCCESS;

4188: FND_MSG_PUB.initialize;
4189: END IF;
4190:
4191: -- Initialize API return status to success
4192: x_return_status := FND_API.G_RET_STS_SUCCESS;
4193:
4194: -- Parameter validations
4195: check_mandatory('IBY_BANKACCT_ID_FIELD',p_bank_account_id);
4196: check_mandatory('IBY_ACCTOWNER_PARTYID_FIELD',p_acct_owner_party_id);

Line 4206: x_return_status := fnd_api.g_ret_sts_error;

4202:
4203: IF (l_count > 0) THEN
4204: fnd_message.set_name('IBY', 'IBY_ACCT_OWNER_EXISTS');
4205: fnd_msg_pub.add;
4206: x_return_status := fnd_api.g_ret_sts_error;
4207: RETURN;
4208: END IF;
4209:
4210: -- Check the no. of active owners

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

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

Line 4261: WHEN fnd_api.g_exc_error THEN

4257: print_debuginfo('RETURN ' || l_module_name);
4258:
4259: END IF;
4260: EXCEPTION
4261: WHEN fnd_api.g_exc_error THEN
4262: ROLLBACK TO add_joint_account_owner;
4263: x_return_status := fnd_api.g_ret_sts_error;
4264: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
4265: print_debuginfo('Exception : ' || SQLERRM);

Line 4263: x_return_status := fnd_api.g_ret_sts_error;

4259: END IF;
4260: EXCEPTION
4261: WHEN fnd_api.g_exc_error THEN
4262: ROLLBACK TO add_joint_account_owner;
4263: x_return_status := fnd_api.g_ret_sts_error;
4264: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
4265: print_debuginfo('Exception : ' || SQLERRM);
4266: END IF;
4267: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

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

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

Line 4272: WHEN fnd_api.g_exc_unexpected_error THEN

4268: p_count => x_msg_count,
4269: p_data => x_msg_data);
4270:
4271:
4272: WHEN fnd_api.g_exc_unexpected_error THEN
4273: ROLLBACK TO add_joint_account_owner;
4274: x_return_status := fnd_api.g_ret_sts_unexp_error;
4275: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
4276: print_debuginfo('Exception : ' || SQLERRM);

Line 4274: x_return_status := fnd_api.g_ret_sts_unexp_error;

4270:
4271:
4272: WHEN fnd_api.g_exc_unexpected_error THEN
4273: ROLLBACK TO add_joint_account_owner;
4274: x_return_status := fnd_api.g_ret_sts_unexp_error;
4275: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
4276: print_debuginfo('Exception : ' || SQLERRM);
4277: END IF;
4278: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

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

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

Line 4285: x_return_status := fnd_api.g_ret_sts_unexp_error;

4281:
4282:
4283: WHEN OTHERS THEN
4284: ROLLBACK TO add_joint_account_owner;
4285: x_return_status := fnd_api.g_ret_sts_unexp_error;
4286: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
4287: print_debuginfo('Exception : ' || SQLERRM);
4288: END IF;
4289: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);

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

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

Line 4334: IF NOT FND_API.Compatible_API_Call(l_api_version,

4330: END IF;
4331: SAVEPOINT set_acct_owner_end_date_pub;
4332:
4333: -- Standard call to check for call compatibility.
4334: IF NOT FND_API.Compatible_API_Call(l_api_version,
4335: p_api_version,
4336: l_api_name,
4337: G_PKG_NAME) THEN
4338: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4338: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4334: IF NOT FND_API.Compatible_API_Call(l_api_version,
4335: p_api_version,
4336: l_api_name,
4337: G_PKG_NAME) THEN
4338: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4339: END IF;
4340:
4341: -- Initialize message list if p_init_msg_list is set to TRUE.
4342: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 4342: IF FND_API.to_Boolean(p_init_msg_list) THEN

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

Line 4347: x_return_status := FND_API.G_RET_STS_SUCCESS;

4343: FND_MSG_PUB.initialize;
4344: END IF;
4345:
4346: -- Initialize API return status to success
4347: x_return_status := FND_API.G_RET_STS_SUCCESS;
4348:
4349: -- Start of API body
4350: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
4351: print_debuginfo('Object Version Number : ' || p_object_version_number);

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

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

Line 4389: WHEN fnd_api.g_exc_error THEN

4385: print_debuginfo('RETURN ' || l_module_name);
4386:
4387: END IF;
4388: EXCEPTION
4389: WHEN fnd_api.g_exc_error THEN
4390: ROLLBACK TO set_acct_owner_end_date_pub;
4391: x_return_status := fnd_api.g_ret_sts_error;
4392: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4393: p_count => x_msg_count,

Line 4391: x_return_status := fnd_api.g_ret_sts_error;

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

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

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

Line 4397: WHEN fnd_api.g_exc_unexpected_error THEN

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

Line 4399: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

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

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

Line 4407: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

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

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

Line 4461: IF NOT FND_API.Compatible_API_Call(l_api_version,

4457: END IF;
4458: SAVEPOINT change_primary_acct_owner_pub;
4459:
4460: -- Standard call to check for call compatibility.
4461: IF NOT FND_API.Compatible_API_Call(l_api_version,
4462: p_api_version,
4463: l_api_name,
4464: G_PKG_NAME) THEN
4465: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4465: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4461: IF NOT FND_API.Compatible_API_Call(l_api_version,
4462: p_api_version,
4463: l_api_name,
4464: G_PKG_NAME) THEN
4465: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4466: END IF;
4467:
4468: -- Initialize message list if p_init_msg_list is set to TRUE.
4469: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 4469: IF FND_API.to_Boolean(p_init_msg_list) THEN

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

Line 4474: x_return_status := FND_API.G_RET_STS_SUCCESS;

4470: FND_MSG_PUB.initialize;
4471: END IF;
4472:
4473: -- Initialize API return status to success
4474: x_return_status := FND_API.G_RET_STS_SUCCESS;
4475:
4476: -- Start of API body
4477:
4478: -- Parameter validations

Line 4507: raise fnd_api.g_exc_unexpected_error;

4503: ELSE
4504: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
4505: print_debuginfo('Too many matching rows found');
4506: END IF;
4507: raise fnd_api.g_exc_unexpected_error;
4508: END IF;
4509:
4510: -- End of API body
4511:

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

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

Line 4521: WHEN fnd_api.g_exc_error THEN

4517: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
4518: print_debuginfo('RETURN ' || l_module_name);
4519: END IF;
4520: EXCEPTION
4521: WHEN fnd_api.g_exc_error THEN
4522: ROLLBACK TO change_primary_acct_owner_pub;
4523: x_return_status := fnd_api.g_ret_sts_error;
4524: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
4525: print_debuginfo('Exception : ' || SQLERRM);

Line 4523: x_return_status := fnd_api.g_ret_sts_error;

4519: END IF;
4520: EXCEPTION
4521: WHEN fnd_api.g_exc_error THEN
4522: ROLLBACK TO change_primary_acct_owner_pub;
4523: x_return_status := fnd_api.g_ret_sts_error;
4524: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
4525: print_debuginfo('Exception : ' || SQLERRM);
4526: END IF;
4527: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

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

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

Line 4532: WHEN fnd_api.g_exc_unexpected_error THEN

4528: p_count => x_msg_count,
4529: p_data => x_msg_data);
4530:
4531:
4532: WHEN fnd_api.g_exc_unexpected_error THEN
4533: ROLLBACK TO change_primary_acct_owner_pub;
4534: x_return_status := fnd_api.g_ret_sts_unexp_error;
4535: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
4536: print_debuginfo('Exception : ' || SQLERRM);

Line 4534: x_return_status := fnd_api.g_ret_sts_unexp_error;

4530:
4531:
4532: WHEN fnd_api.g_exc_unexpected_error THEN
4533: ROLLBACK TO change_primary_acct_owner_pub;
4534: x_return_status := fnd_api.g_ret_sts_unexp_error;
4535: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
4536: print_debuginfo('Exception : ' || SQLERRM);
4537: END IF;
4538: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

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

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

Line 4545: x_return_status := fnd_api.g_ret_sts_unexp_error;

4541:
4542:
4543: WHEN OTHERS THEN
4544: ROLLBACK TO change_primary_acct_owner_pub;
4545: x_return_status := fnd_api.g_ret_sts_unexp_error;
4546: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
4547: print_debuginfo('Exception : ' || SQLERRM);
4548: END IF;
4549: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);

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

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

Line 4572: p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,

4568: -- Initial version : 1.0
4569: --
4570: PROCEDURE check_bank_acct_owner (
4571: p_api_version IN NUMBER,
4572: p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,
4573: p_bank_acct_id IN NUMBER,
4574: p_acct_owner_party_id IN NUMBER,
4575: x_return_status OUT NOCOPY VARCHAR2,
4576: x_msg_count OUT NOCOPY NUMBER,

Line 4593: IF NOT FND_API.Compatible_API_Call(l_api_version,

4589:
4590: END IF;
4591:
4592: -- Standard call to check for call compatibility.
4593: IF NOT FND_API.Compatible_API_Call(l_api_version,
4594: p_api_version,
4595: l_api_name,
4596: G_PKG_NAME) THEN
4597: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4597: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4593: IF NOT FND_API.Compatible_API_Call(l_api_version,
4594: p_api_version,
4595: l_api_name,
4596: G_PKG_NAME) THEN
4597: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4598: END IF;
4599:
4600: -- Initialize message list if p_init_msg_list is set to TRUE.
4601: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 4601: IF FND_API.to_Boolean(p_init_msg_list) THEN

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

Line 4606: x_return_status := FND_API.G_RET_STS_SUCCESS;

4602: FND_MSG_PUB.initialize;
4603: END IF;
4604:
4605: -- Initialize API return status to success
4606: x_return_status := FND_API.G_RET_STS_SUCCESS;
4607:
4608: -- Start of API body
4609:
4610: -- Parameter validations

Line 4623: x_return_status := fnd_api.g_ret_sts_error;

4619: AND account_owner_party_id = p_acct_owner_party_id
4620: AND nvl(end_date, sysdate+1) > sysdate;
4621:
4622: EXCEPTION WHEN No_Data_Found THEN
4623: x_return_status := fnd_api.g_ret_sts_error;
4624: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
4625: print_debuginfo('Given Party is not the owner of the account');
4626: END IF;
4627: END;

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

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

Line 4640: WHEN fnd_api.g_exc_error THEN

4636: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
4637: print_debuginfo('RETURN ' || l_module_name);
4638: END IF;
4639: EXCEPTION
4640: WHEN fnd_api.g_exc_error THEN
4641: x_return_status := fnd_api.g_ret_sts_error;
4642: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
4643: print_debuginfo('Exception : ' || SQLERRM);
4644: END IF;

Line 4641: x_return_status := fnd_api.g_ret_sts_error;

4637: print_debuginfo('RETURN ' || l_module_name);
4638: END IF;
4639: EXCEPTION
4640: WHEN fnd_api.g_exc_error THEN
4641: x_return_status := fnd_api.g_ret_sts_error;
4642: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
4643: print_debuginfo('Exception : ' || SQLERRM);
4644: END IF;
4645: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

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

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

Line 4650: WHEN fnd_api.g_exc_unexpected_error THEN

4646: p_count => x_msg_count,
4647: p_data => x_msg_data);
4648: Raise;
4649:
4650: WHEN fnd_api.g_exc_unexpected_error THEN
4651: x_return_status := fnd_api.g_ret_sts_unexp_error;
4652: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
4653: print_debuginfo('Exception : ' || SQLERRM);
4654: END IF;

Line 4651: x_return_status := fnd_api.g_ret_sts_unexp_error;

4647: p_data => x_msg_data);
4648: Raise;
4649:
4650: WHEN fnd_api.g_exc_unexpected_error THEN
4651: x_return_status := fnd_api.g_ret_sts_unexp_error;
4652: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
4653: print_debuginfo('Exception : ' || SQLERRM);
4654: END IF;
4655: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

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

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

Line 4661: x_return_status := fnd_api.g_ret_sts_unexp_error;

4657: p_data => x_msg_data);
4658: Raise;
4659:
4660: WHEN OTHERS THEN
4661: x_return_status := fnd_api.g_ret_sts_unexp_error;
4662: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
4663: print_debuginfo('Exception : ' || SQLERRM);
4664: END IF;
4665: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_module_name, null);

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

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

Line 4698: x_return_status := fnd_api.g_ret_sts_success;

4694: AND hp.status = 'A';
4695: l_country VARCHAR2(60);
4696: BEGIN
4697: -- initialize API return status to success.
4698: x_return_status := fnd_api.g_ret_sts_success;
4699:
4700: OPEN c_country;
4701: FETCH c_country INTO l_country;
4702: IF c_country%NOTFOUND THEN

Line 4705: x_return_status := fnd_api.g_ret_sts_error;

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

Line 4786: x_return_status := fnd_api.g_ret_sts_success;

4782: print_debuginfo('ENTER ' || l_module_name);
4783:
4784: END IF;
4785: -- initialize API return status to success.
4786: x_return_status := fnd_api.g_ret_sts_success;
4787:
4788: OPEN c_bank;
4789: FETCH c_bank INTO x_bank_id, x_country_code, x_bank_name, x_bank_number;
4790: IF c_bank%NOTFOUND THEN

Line 4793: x_return_status := fnd_api.g_ret_sts_error;

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

Line 4836: RAISE fnd_api.g_exc_error;

4832: fnd_msg_pub.add;
4833: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
4834: print_debuginfo(fnd_message.get_string('IBY',p_field)|| ' is a required parameter.');
4835: END IF;
4836: RAISE fnd_api.g_exc_error;
4837: END IF;
4838:
4839:
4840: --Validate Currency

Line 4850: RAISE fnd_api.g_exc_error;

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

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

5042: RETURN l_bank_num;
5043: END Uncipher_Bank_Number;
5044:
5045: PROCEDURE Remask_Accounts
5046: (p_commit IN VARCHAR2 := FND_API.G_TRUE,
5047: p_sys_key IN iby_security_pkg.DES3_KEY_TYPE
5048: )
5049: IS
5050: lx_mask_option iby_ext_bank_accounts.ba_mask_setting%TYPE;

Line 5167: (FND_API.G_FALSE,l_ba_segment,

5163: l_ba_segment := IBY_SECURITY_PKG.PKCS5_PAD(l_ba_segment);
5164:
5165: IF (ext_ba_rec.ba_num_sec_segment_id IS NULL) THEN
5166: IBY_SECURITY_PKG.Create_Segment
5167: (FND_API.G_FALSE,l_ba_segment,
5168: iby_security_pkg.G_ENCODING_UTF8_AL32,
5169: p_sys_key,lx_ba_segment_id);
5170: ELSE
5171: lx_ba_segment_id := ext_ba_rec.ba_num_sec_segment_id;

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

5169: p_sys_key,lx_ba_segment_id);
5170: ELSE
5171: lx_ba_segment_id := ext_ba_rec.ba_num_sec_segment_id;
5172: IBY_SECURITY_PKG.Update_Segment
5173: (FND_API.G_FALSE,lx_ba_segment_id,l_ba_segment,
5174: iby_security_pkg.G_ENCODING_UTF8_AL32,p_sys_key,
5175: ext_ba_rec.ba_subkey_cipher);
5176: END IF;
5177: ELSE

Line 5194: (FND_API.G_FALSE,l_iban_segment,

5190: l_iban_segment := IBY_SECURITY_PKG.PKCS5_PAD(l_iban_segment);
5191:
5192: IF (ext_ba_rec.iban_sec_segment_id IS NULL) THEN
5193: IBY_SECURITY_PKG.Create_Segment
5194: (FND_API.G_FALSE,l_iban_segment,
5195: iby_security_pkg.G_ENCODING_UTF8_AL32,p_sys_key,
5196: lx_iban_segment_id);
5197: ELSE
5198: lx_iban_segment_id := ext_ba_rec.iban_sec_segment_id;

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

5196: lx_iban_segment_id);
5197: ELSE
5198: lx_iban_segment_id := ext_ba_rec.iban_sec_segment_id;
5199: IBY_SECURITY_PKG.Update_Segment
5200: (FND_API.G_FALSE,lx_iban_segment_id,l_iban_segment,
5201: iby_security_pkg.G_ENCODING_UTF8_AL32,p_sys_key,
5202: ext_ba_rec.iban_subkey_cipher);
5203: END IF;
5204: ELSE

Line 5244: IF FND_API.to_Boolean( p_commit ) THEN

5240: WHERE (ext_bank_account_id = ext_ba_rec.ext_bank_account_id);
5241:
5242: END LOOP;
5243:
5244: IF FND_API.to_Boolean( p_commit ) THEN
5245: COMMIT;
5246: END IF;
5247:
5248: iby_debug_pub.add('Exit',iby_debug_pub.G_LEVEL_PROCEDURE,l_dbg_mod);

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

5316: -- pad to unit 8 length
5317: l_ba_segment := IBY_SECURITY_PKG.PKCS5_PAD(l_ba_segment);
5318:
5319: IBY_SECURITY_PKG.Create_Segment
5320: (FND_API.G_FALSE,l_ba_segment,iby_security_pkg.G_ENCODING_UTF8_AL32,
5321: p_sys_key,lx_ba_segment_id);
5322: END IF;
5323: ELSE
5324: lx_ba_unmask_digits := ext_ba_rec.bank_account_num;

Line 5342: (FND_API.G_FALSE,l_iban_segment,

5338: -- pad to unit 8 length
5339: l_iban_segment := IBY_SECURITY_PKG.PKCS5_PAD(l_iban_segment);
5340:
5341: IBY_SECURITY_PKG.Create_Segment
5342: (FND_API.G_FALSE,l_iban_segment,
5343: iby_security_pkg.G_ENCODING_UTF8_AL32,p_sys_key,lx_iban_segment_id);
5344: END IF;
5345: ELSE
5346: lx_iban_unmask_digits := ext_ba_rec.iban;

Line 5361: (FND_API.G_FALSE,l_e_ba_segment,

5357: -- pad to unit 8 length
5358: l_e_ba_segment := IBY_SECURITY_PKG.PKCS5_PAD(l_e_ba_segment);
5359:
5360: IBY_SECURITY_PKG.Create_Segment
5361: (FND_API.G_FALSE,l_e_ba_segment,
5362: iby_security_pkg.G_ENCODING_UTF8_AL32,p_sys_key,lx_e_ba_segment_id);
5363: ELSE
5364: lx_e_ba_unmask_digits := ext_ba_rec.bank_account_num_electronic;
5365: END IF;

Line 5380: IF FND_API.to_Boolean( p_commit ) THEN

5376: encrypted = 'Y'
5377: WHERE (ext_bank_account_id = ext_ba_rec.ext_bank_account_id);
5378: END LOOP;
5379:
5380: IF FND_API.to_Boolean( p_commit ) THEN
5381: COMMIT;
5382: END IF;
5383: END Encrypt_Accounts;
5384:

Line 5504: IF FND_API.to_Boolean( p_commit ) THEN

5500: WHERE sec_segment_id = ext_ba_rec.ba_num_elec_sec_segment_id;
5501:
5502: END LOOP;
5503:
5504: IF FND_API.to_Boolean( p_commit ) THEN
5505: COMMIT;
5506: END IF;
5507: END Decrypt_Accounts;
5508: