27: fnd_message.set_name('CE', 'CE_API_REQUIRED_PARAM');
28: fnd_message.set_token('PARAM', p_param_name);
29: fnd_msg_pub.add;
30: IF l_DEBUG in ('Y', 'C') THEN
31: cep_standard.debug(p_param_name|| ' is a required parameter.');
32: END IF;
33: RAISE fnd_api.g_exc_error;
34:
35: END IF;
228: BEGIN
229: SAVEPOINT create_bank;
230:
231: IF l_DEBUG in ('Y', 'C') THEN
232: cep_standard.debug('>>CE_EXT_BANK_ACCT_PUB.create_bank.');
233: END IF;
234:
235: -- initialize message list
236: IF fnd_api.to_boolean(p_init_msg_list) THEN
326: p_count => x_msg_count,
327: p_data => x_msg_data);
328:
329: IF l_DEBUG in ('Y', 'C') THEN
330: cep_standard.debug('<
332:
333: EXCEPTION
334: WHEN fnd_api.g_exc_error THEN
338: p_count => x_msg_count,
339: p_data => x_msg_data);
340:
341: IF l_DEBUG in ('Y', 'C') THEN
342: cep_standard.debug_msg_stack(x_msg_count, x_msg_data);
343: END IF;
344:
345: WHEN fnd_api.g_exc_unexpected_error THEN
346: ROLLBACK TO create_bank;
349: p_count => x_msg_count,
350: p_data => x_msg_data);
351:
352: IF l_DEBUG in ('Y', 'C') THEN
353: cep_standard.debug_msg_stack(x_msg_count, x_msg_data);
354: END IF;
355:
356: WHEN OTHERS THEN
357: ROLLBACK TO create_bank;
363: p_count => x_msg_count,
364: p_data => x_msg_data);
365:
366: IF l_DEBUG in ('Y', 'C') THEN
367: cep_standard.debug_msg_stack(x_msg_count, x_msg_data);
368: END IF;
369:
370: END create_bank;
371:
458: BEGIN
459: SAVEPOINT update_bank;
460:
461: IF l_DEBUG in ('Y', 'C') THEN
462: cep_standard.debug('>>CE_EXT_BANK_ACCT_PUB.update_bank.');
463: END IF;
464:
465: -- initialize message list
466: IF fnd_api.to_boolean(p_init_msg_list) THEN
564: p_count => x_msg_count,
565: p_data => x_msg_data);
566:
567: IF l_DEBUG in ('Y', 'C') THEN
568: cep_standard.debug('<
570:
571: EXCEPTION
572: WHEN fnd_api.g_exc_error THEN
576: p_count => x_msg_count,
577: p_data => x_msg_data);
578:
579: IF l_DEBUG in ('Y', 'C') THEN
580: cep_standard.debug_msg_stack(x_msg_count, x_msg_data);
581: END IF;
582:
583: WHEN fnd_api.g_exc_unexpected_error THEN
584: ROLLBACK TO update_bank;
587: p_count => x_msg_count,
588: p_data => x_msg_data);
589:
590: IF l_DEBUG in ('Y', 'C') THEN
591: cep_standard.debug_msg_stack(x_msg_count, x_msg_data);
592: END IF;
593:
594: WHEN OTHERS THEN
595: ROLLBACK TO update_bank;
601: p_count => x_msg_count,
602: p_data => x_msg_data);
603:
604: IF l_DEBUG in ('Y', 'C') THEN
605: cep_standard.debug_msg_stack(x_msg_count, x_msg_data);
606: END IF;
607:
608: END update_bank;
609:
686: BEGIN
687: SAVEPOINT set_bank_end_date;
688:
689: IF l_DEBUG in ('Y', 'C') THEN
690: cep_standard.debug('>>CE_EXT_BANK_ACCT_PUB.set_bank_end_date.');
691: END IF;
692:
693: -- initialize message list
694: IF fnd_api.to_boolean(p_init_msg_list) THEN
775: p_count => x_msg_count,
776: p_data => x_msg_data);
777:
778: IF l_DEBUG in ('Y', 'C') THEN
779: cep_standard.debug('<
781:
782: EXCEPTION
783: WHEN fnd_api.g_exc_error THEN
787: p_count => x_msg_count,
788: p_data => x_msg_data);
789:
790: IF l_DEBUG in ('Y', 'C') THEN
791: cep_standard.debug_msg_stack(x_msg_count, x_msg_data);
792: END IF;
793:
794: WHEN fnd_api.g_exc_unexpected_error THEN
795: ROLLBACK TO set_bank_end_date;
798: p_count => x_msg_count,
799: p_data => x_msg_data);
800:
801: IF l_DEBUG in ('Y', 'C') THEN
802: cep_standard.debug_msg_stack(x_msg_count, x_msg_data);
803: END IF;
804:
805: WHEN OTHERS THEN
806: ROLLBACK TO set_bank_end_date;
812: p_count => x_msg_count,
813: p_data => x_msg_data);
814:
815: IF l_DEBUG in ('Y', 'C') THEN
816: cep_standard.debug_msg_stack(x_msg_count, x_msg_data);
817: END IF;
818:
819: END set_bank_end_date;
820:
884: AND hz_hop.bank_or_branch_number = p_bank_number;
885:
886: BEGIN
887: IF l_DEBUG in ('Y', 'C') THEN
888: cep_standard.debug('>>CE_EXT_BANK_ACCT_PUB.check_bank_exist.');
889: END IF;
890:
891: IF p_bank_name IS NOT NULL THEN
892: OPEN c_bank_name;
909: x_end_date := null;
910: END IF;
911:
912: IF l_DEBUG in ('Y', 'C') THEN
913: cep_standard.debug('<
915:
916: EXCEPTION
917: WHEN OTHERS THEN
914: END IF;
915:
916: EXCEPTION
917: WHEN OTHERS THEN
918: cep_standard.sql_error('CE_EXT_BANK_ACCT_PUB.check_bank_exist', sqlcode, sqlerrm);
919:
920: END check_bank_exist;
921:
922:
1028: BEGIN
1029: SAVEPOINT create_bank_branch;
1030:
1031: IF l_DEBUG in ('Y', 'C') THEN
1032: cep_standard.debug('>>CE_EXT_BANK_ACCT_PUB.create_bank_branch.');
1033: END IF;
1034:
1035: -- initialize message list
1036: IF fnd_api.to_boolean(p_init_msg_list) THEN
1197: p_count => x_msg_count,
1198: p_data => x_msg_data);
1199:
1200: IF l_DEBUG in ('Y', 'C') THEN
1201: cep_standard.debug('<
1203:
1204: EXCEPTION
1205: WHEN fnd_api.g_exc_error THEN
1209: p_count => x_msg_count,
1210: p_data => x_msg_data);
1211:
1212: IF l_DEBUG in ('Y', 'C') THEN
1213: cep_standard.debug_msg_stack(x_msg_count, x_msg_data);
1214: END IF;
1215:
1216: WHEN fnd_api.g_exc_unexpected_error THEN
1217: ROLLBACK TO create_bank_branch;
1220: p_count => x_msg_count,
1221: p_data => x_msg_data);
1222:
1223: IF l_DEBUG in ('Y', 'C') THEN
1224: cep_standard.debug_msg_stack(x_msg_count, x_msg_data);
1225: END IF;
1226:
1227: WHEN OTHERS THEN
1228: ROLLBACK TO create_bank_branch;
1234: p_count => x_msg_count,
1235: p_data => x_msg_data);
1236:
1237: IF l_DEBUG in ('Y', 'C') THEN
1238: cep_standard.debug_msg_stack(x_msg_count, x_msg_data);
1239: END IF;
1240:
1241: END create_bank_branch;
1242:
1355: BEGIN
1356: SAVEPOINT update_bank_branch;
1357:
1358: IF l_DEBUG in ('Y', 'C') THEN
1359: cep_standard.debug('>>CE_EXT_BANK_ACCT_PUB.update_bank_branch.');
1360: END IF;
1361:
1362: -- initialize message list
1363: IF fnd_api.to_boolean(p_init_msg_list) THEN
1520: p_count => x_msg_count,
1521: p_data => x_msg_data);
1522:
1523: IF l_DEBUG in ('Y', 'C') THEN
1524: cep_standard.debug('<
1526:
1527: EXCEPTION
1528: WHEN fnd_api.g_exc_error THEN
1532: p_count => x_msg_count,
1533: p_data => x_msg_data);
1534:
1535: IF l_DEBUG in ('Y', 'C') THEN
1536: cep_standard.debug_msg_stack(x_msg_count, x_msg_data);
1537: END IF;
1538:
1539: WHEN fnd_api.g_exc_unexpected_error THEN
1540: ROLLBACK TO update_bank_branch;
1543: p_count => x_msg_count,
1544: p_data => x_msg_data);
1545:
1546: IF l_DEBUG in ('Y', 'C') THEN
1547: cep_standard.debug_msg_stack(x_msg_count, x_msg_data);
1548: END IF;
1549:
1550: WHEN OTHERS THEN
1551: ROLLBACK TO update_bank_branch;
1557: p_count => x_msg_count,
1558: p_data => x_msg_data);
1559:
1560: IF l_DEBUG in ('Y', 'C') THEN
1561: cep_standard.debug_msg_stack(x_msg_count, x_msg_data);
1562: END IF;
1563:
1564: END update_bank_branch;
1565:
1676: BEGIN
1677: SAVEPOINT set_bank_branch_end_date;
1678:
1679: IF l_DEBUG in ('Y', 'C') THEN
1680: cep_standard.debug('>>CE_EXT_BANK_ACCT_PUB.set_bank_branch_end_date.');
1681: END IF;
1682:
1683: -- initialize message list
1684: IF fnd_api.to_boolean(p_init_msg_list) THEN
1854: p_count => x_msg_count,
1855: p_data => x_msg_data);
1856:
1857: IF l_DEBUG in ('Y', 'C') THEN
1858: cep_standard.debug('<
1860:
1861: EXCEPTION
1862: WHEN fnd_api.g_exc_error THEN
1867: p_count => x_msg_count,
1868: p_data => x_msg_data);
1869:
1870: IF l_DEBUG in ('Y', 'C') THEN
1871: cep_standard.debug_msg_stack(x_msg_count, x_msg_data);
1872: END IF;
1873:
1874: WHEN fnd_api.g_exc_unexpected_error THEN
1875: ROLLBACK TO set_bank_branch_end_date;
1879: p_count => x_msg_count,
1880: p_data => x_msg_data);
1881:
1882: IF l_DEBUG in ('Y', 'C') THEN
1883: cep_standard.debug_msg_stack(x_msg_count, x_msg_data);
1884: END IF;
1885:
1886: WHEN OTHERS THEN
1887: ROLLBACK TO set_bank_branch_end_date;
1894: p_count => x_msg_count,
1895: p_data => x_msg_data);
1896:
1897: IF l_DEBUG in ('Y', 'C') THEN
1898: cep_standard.debug_msg_stack(x_msg_count, x_msg_data);
1899: END IF;
1900: END set_bank_branch_end_date;
1901:
1902:
1975: and NVL(TRUNC(hz_branchProf.effective_end_date), SYSDATE+1)
1976: AND hz_branchProf.bank_or_branch_number = p_branch_number;
1977: BEGIN
1978: IF l_DEBUG in ('Y', 'C') THEN
1979: cep_standard.debug('>>CE_EXT_BANK_ACCT_PUB.check_branch_exist.');
1980: END IF;
1981:
1982: IF p_branch_name IS NOT NULL THEN
1983: OPEN c_branch_name;
2000: x_end_date := null;
2001: END IF;
2002:
2003: IF l_DEBUG in ('Y', 'C') THEN
2004: cep_standard.debug('<
2006:
2007: EXCEPTION
2008: WHEN OTHERS THEN
2005: END IF;
2006:
2007: EXCEPTION
2008: WHEN OTHERS THEN
2009: cep_standard.sql_error('CE_EXT_BANK_ACCT_PUB.check_branch_exist', sqlcode, sqlerrm);
2010:
2011: END check_branch_exist;
2012:
2013:
2092: BEGIN
2093: SAVEPOINT create_bank_acct;
2094:
2095: IF l_DEBUG in ('Y', 'C') THEN
2096: cep_standard.debug('>>CE_BANK_PUB.create_bank_acct.');
2097: END IF;
2098:
2099: -- initialize message list
2100: IF fnd_api.to_boolean(p_init_msg_list) THEN
2409: CLOSE c_acct_rowid;
2410:
2411: -- Bug 14350260 Start
2412: -- Added a call to xtr API to insert XTR part of the data.
2413: cep_standard.debug('Starting XTR API Call...');
2414:
2415: cep_standard.debug('p_acct_rec.xtr_use_allowed_flag = ' || p_acct_rec.xtr_use_allowed_flag);
2416: if p_acct_rec.xtr_use_allowed_flag = 'Y' then
2417:
2411: -- Bug 14350260 Start
2412: -- Added a call to xtr API to insert XTR part of the data.
2413: cep_standard.debug('Starting XTR API Call...');
2414:
2415: cep_standard.debug('p_acct_rec.xtr_use_allowed_flag = ' || p_acct_rec.xtr_use_allowed_flag);
2416: if p_acct_rec.xtr_use_allowed_flag = 'Y' then
2417:
2418: cep_standard.debug('p_acct_rec.account_owner_org_id = ' || p_acct_rec.account_owner_org_id);
2419:
2414:
2415: cep_standard.debug('p_acct_rec.xtr_use_allowed_flag = ' || p_acct_rec.xtr_use_allowed_flag);
2416: if p_acct_rec.xtr_use_allowed_flag = 'Y' then
2417:
2418: cep_standard.debug('p_acct_rec.account_owner_org_id = ' || p_acct_rec.account_owner_org_id);
2419:
2420: select party_code
2421: into l_party_code
2422: from xtr_parties_v
2421: into l_party_code
2422: from xtr_parties_v
2423: where legal_entity_id = p_acct_rec.account_owner_org_id
2424: and authorised = 'Y';
2425: cep_standard.debug('l_party_code = ' || l_party_code);
2426: cep_standard.debug('x_acct_id = ' || x_acct_id);
2427: cep_standard.debug('p_acct_rec.branch_id = ' || p_acct_rec.branch_id);
2428:
2429: select party_code
2422: from xtr_parties_v
2423: where legal_entity_id = p_acct_rec.account_owner_org_id
2424: and authorised = 'Y';
2425: cep_standard.debug('l_party_code = ' || l_party_code);
2426: cep_standard.debug('x_acct_id = ' || x_acct_id);
2427: cep_standard.debug('p_acct_rec.branch_id = ' || p_acct_rec.branch_id);
2428:
2429: select party_code
2430: into l_bank_code
2423: where legal_entity_id = p_acct_rec.account_owner_org_id
2424: and authorised = 'Y';
2425: cep_standard.debug('l_party_code = ' || l_party_code);
2426: cep_standard.debug('x_acct_id = ' || x_acct_id);
2427: cep_standard.debug('p_acct_rec.branch_id = ' || p_acct_rec.branch_id);
2428:
2429: select party_code
2430: into l_bank_code
2431: from xtr_party_info
2429: select party_code
2430: into l_bank_code
2431: from xtr_party_info
2432: where ce_bank_branch_id = p_acct_rec.branch_id;
2433: cep_standard.debug('l_bank_code = ' || l_bank_code);
2434:
2435:
2436:
2437: select city, ADDRESS_LINE1, EFT_SWIFT_CODE
2437: select city, ADDRESS_LINE1, EFT_SWIFT_CODE
2438: into l_city, l_ADDRESS_LINE1, l_EFT_SWIFT_CODE
2439: from ce_bank_branches_v
2440: where BRANCH_PARTY_ID =p_acct_rec.branch_id;
2441: cep_standard.debug('l_city = ' || l_city);
2442: cep_standard.debug('l_ADDRESS_LINE1 = ' || l_ADDRESS_LINE1);
2443: cep_standard.debug('l_EFT_SWIFT_CODE = ' || l_EFT_SWIFT_CODE);
2444:
2445: XTR_REPLICATE_BANK_ACCOUNTS_P.REPLICATE_BANK_ACCOUNTS(
2438: into l_city, l_ADDRESS_LINE1, l_EFT_SWIFT_CODE
2439: from ce_bank_branches_v
2440: where BRANCH_PARTY_ID =p_acct_rec.branch_id;
2441: cep_standard.debug('l_city = ' || l_city);
2442: cep_standard.debug('l_ADDRESS_LINE1 = ' || l_ADDRESS_LINE1);
2443: cep_standard.debug('l_EFT_SWIFT_CODE = ' || l_EFT_SWIFT_CODE);
2444:
2445: XTR_REPLICATE_BANK_ACCOUNTS_P.REPLICATE_BANK_ACCOUNTS(
2446: l_account_number, -- p_account_number
2439: from ce_bank_branches_v
2440: where BRANCH_PARTY_ID =p_acct_rec.branch_id;
2441: cep_standard.debug('l_city = ' || l_city);
2442: cep_standard.debug('l_ADDRESS_LINE1 = ' || l_ADDRESS_LINE1);
2443: cep_standard.debug('l_EFT_SWIFT_CODE = ' || l_EFT_SWIFT_CODE);
2444:
2445: XTR_REPLICATE_BANK_ACCOUNTS_P.REPLICATE_BANK_ACCOUNTS(
2446: l_account_number, -- p_account_number
2447: NULL, -- p_authorised
2486: x_xtr_api_msg_count, -- x_msg_count OUT
2487: x_xtr_api_msg_data, -- x_msg_data OUT
2488: l_iban
2489: );
2490: cep_standard.debug('Call to XTR API XTR_REPLICATE_BANK_ACCOUNTS_P.REPLICATE_BANK_ACCOUNTS Sucessfully Completed...');
2491: if x_xtr_api_return_status<>FND_API.G_RET_STS_SUCCESS then
2492: cep_standard.debug('Call to XTR API XTR_REPLICATE_BANK_ACCOUNTS_P.REPLICATE_BANK_ACCOUNTS has failed...');
2493: RAISE fnd_api.g_exc_error;
2494: end if;
2488: l_iban
2489: );
2490: cep_standard.debug('Call to XTR API XTR_REPLICATE_BANK_ACCOUNTS_P.REPLICATE_BANK_ACCOUNTS Sucessfully Completed...');
2491: if x_xtr_api_return_status<>FND_API.G_RET_STS_SUCCESS then
2492: cep_standard.debug('Call to XTR API XTR_REPLICATE_BANK_ACCOUNTS_P.REPLICATE_BANK_ACCOUNTS has failed...');
2493: RAISE fnd_api.g_exc_error;
2494: end if;
2495: end if;
2496: -- Bug 14350260 End
2500: p_count => x_msg_count,
2501: p_data => x_msg_data);
2502:
2503: IF l_DEBUG in ('Y', 'C') THEN
2504: cep_standard.debug('<
2506:
2507: EXCEPTION
2508: WHEN fnd_api.g_exc_error THEN
2512: p_count => x_msg_count,
2513: p_data => x_msg_data);
2514:
2515: IF l_DEBUG in ('Y', 'C') THEN
2516: cep_standard.debug_msg_stack(x_msg_count, x_msg_data);
2517: END IF;
2518:
2519: WHEN fnd_api.g_exc_unexpected_error THEN
2520: ROLLBACK TO create_bank_acct;
2523: p_count => x_msg_count,
2524: p_data => x_msg_data);
2525:
2526: IF l_DEBUG in ('Y', 'C') THEN
2527: cep_standard.debug_msg_stack(x_msg_count, x_msg_data);
2528: END IF;
2529:
2530: WHEN OTHERS THEN
2531: ROLLBACK TO create_bank_acct;
2537: p_count => x_msg_count,
2538: p_data => x_msg_data);
2539:
2540: IF l_DEBUG in ('Y', 'C') THEN
2541: cep_standard.debug_msg_stack(x_msg_count, x_msg_data);
2542: END IF;
2543:
2544: END create_bank_acct;
2545:
2668: BEGIN
2669: SAVEPOINT update_bank_acct;
2670:
2671: IF l_DEBUG in ('Y', 'C') THEN
2672: cep_standard.debug('>>CE_BANK_PUB.update_bank_acct.');
2673: END IF;
2674:
2675: -- initialize message list
2676: IF fnd_api.to_boolean(p_init_msg_list) THEN
2999: p_count => x_msg_count,
3000: p_data => x_msg_data);
3001:
3002: IF l_DEBUG in ('Y', 'C') THEN
3003: cep_standard.debug('<
3005:
3006: EXCEPTION
3007: WHEN fnd_api.g_exc_error THEN
3011: p_count => x_msg_count,
3012: p_data => x_msg_data);
3013:
3014: IF l_DEBUG in ('Y', 'C') THEN
3015: cep_standard.debug_msg_stack(x_msg_count, x_msg_data);
3016: END IF;
3017:
3018: WHEN fnd_api.g_exc_unexpected_error THEN
3019: ROLLBACK TO update_bank_acct;
3022: p_count => x_msg_count,
3023: p_data => x_msg_data);
3024:
3025: IF l_DEBUG in ('Y', 'C') THEN
3026: cep_standard.debug_msg_stack(x_msg_count, x_msg_data);
3027: END IF;
3028:
3029: WHEN OTHERS THEN
3030: ROLLBACK TO udpate_bank_acct;
3036: p_count => x_msg_count,
3037: p_data => x_msg_data);
3038:
3039: IF l_DEBUG in ('Y', 'C') THEN
3040: cep_standard.debug_msg_stack(x_msg_count, x_msg_data);
3041: END IF;
3042:
3043: END update_bank_acct;
3044:
3069: BEGIN
3070: SAVEPOINT create_bank_acct_use;
3071:
3072: IF l_DEBUG in ('Y', 'C') THEN
3073: cep_standard.debug('>>CE_BANK_PUB.create_bank_acct_use.');
3074: END IF;
3075:
3076: -- initialize message list
3077: IF fnd_api.to_boolean(p_init_msg_list) THEN
3345: p_count => x_msg_count,
3346: p_data => x_msg_data);
3347:
3348: IF l_DEBUG in ('Y', 'C') THEN
3349: cep_standard.debug('<
3351:
3352: EXCEPTION
3353: WHEN fnd_api.g_exc_error THEN
3357: p_count => x_msg_count,
3358: p_data => x_msg_data);
3359:
3360: IF l_DEBUG in ('Y', 'C') THEN
3361: cep_standard.debug_msg_stack(x_msg_count, x_msg_data);
3362: END IF;
3363:
3364: WHEN fnd_api.g_exc_unexpected_error THEN
3365: ROLLBACK TO create_bank_acct_use;
3368: p_count => x_msg_count,
3369: p_data => x_msg_data);
3370:
3371: IF l_DEBUG in ('Y', 'C') THEN
3372: cep_standard.debug_msg_stack(x_msg_count, x_msg_data);
3373: END IF;
3374:
3375: WHEN OTHERS THEN
3376: ROLLBACK TO create_bank_acct_use;
3382: p_count => x_msg_count,
3383: p_data => x_msg_data);
3384:
3385: IF l_DEBUG in ('Y', 'C') THEN
3386: cep_standard.debug_msg_stack(x_msg_count, x_msg_data);
3387: END IF;
3388:
3389:
3390: END create_bank_acct_use;
3426: BEGIN
3427: SAVEPOINT update_bank_acct_use;
3428:
3429: IF l_DEBUG in ('Y', 'C') THEN
3430: cep_standard.debug('>>CE_BANK_PUB.update_bank_acct_use.');
3431: END IF;
3432:
3433: -- initialize message list
3434: IF fnd_api.to_boolean(p_init_msg_list) THEN
3640: p_count => x_msg_count,
3641: p_data => x_msg_data);
3642:
3643: IF l_DEBUG in ('Y', 'C') THEN
3644: cep_standard.debug('<
3646:
3647: EXCEPTION
3648: WHEN fnd_api.g_exc_error THEN
3652: p_count => x_msg_count,
3653: p_data => x_msg_data);
3654:
3655: IF l_DEBUG in ('Y', 'C') THEN
3656: cep_standard.debug_msg_stack(x_msg_count, x_msg_data);
3657: END IF;
3658:
3659: WHEN fnd_api.g_exc_unexpected_error THEN
3660: ROLLBACK TO update_bank_acct_use;
3663: p_count => x_msg_count,
3664: p_data => x_msg_data);
3665:
3666: IF l_DEBUG in ('Y', 'C') THEN
3667: cep_standard.debug_msg_stack(x_msg_count, x_msg_data);
3668: END IF;
3669:
3670: WHEN OTHERS THEN
3671: ROLLBACK TO udpate_bank_acct_use;
3677: p_count => x_msg_count,
3678: p_data => x_msg_data);
3679:
3680: IF l_DEBUG in ('Y', 'C') THEN
3681: cep_standard.debug_msg_stack(x_msg_count, x_msg_data);
3682: END IF;
3683:
3684: END update_bank_acct_use;
3685:
3728: BEGIN
3729: SAVEPOINT set_bank_acct_end_date;
3730:
3731: IF l_DEBUG in ('Y', 'C') THEN
3732: cep_standard.debug('>>CE_EXT_BANK_ACCT_PUB.set_bank_acct_end_date.');
3733: END IF;
3734:
3735: -- initialize message list
3736: IF fnd_api.to_boolean(p_init_msg_list) THEN
3787: p_count => x_msg_count,
3788: p_data => x_msg_data);
3789:
3790: IF l_DEBUG in ('Y', 'C') THEN
3791: cep_standard.debug('<
3793:
3794: EXCEPTION
3795: WHEN fnd_api.g_exc_error THEN
3800: p_count => x_msg_count,
3801: p_data => x_msg_data);
3802:
3803: IF l_DEBUG in ('Y', 'C') THEN
3804: cep_standard.debug_msg_stack(x_msg_count, x_msg_data);
3805: END IF;
3806:
3807: WHEN fnd_api.g_exc_unexpected_error THEN
3808: ROLLBACK TO set_bank_acct_end_date;
3812: p_count => x_msg_count,
3813: p_data => x_msg_data);
3814:
3815: IF l_DEBUG in ('Y', 'C') THEN
3816: cep_standard.debug_msg_stack(x_msg_count, x_msg_data);
3817: END IF;
3818:
3819: WHEN OTHERS THEN
3820: ROLLBACK TO set_bank_acct_end_date;
3827: p_count => x_msg_count,
3828: p_data => x_msg_data);
3829:
3830: IF l_DEBUG in ('Y', 'C') THEN
3831: cep_standard.debug_msg_stack(x_msg_count, x_msg_data);
3832: END IF;
3833: END set_bank_acct_end_date;
3834:
3835: END ce_bank_pub;