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.CE_BANK_PUB dependencies on STANDARD

Line 31: cep_standard.debug(p_param_name|| ' is a required parameter.');

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;

Line 232: cep_standard.debug('>>CE_EXT_BANK_ACCT_PUB.create_bank.');

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

Line 330: cep_standard.debug('<

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('< 331: END IF;
332:
333: EXCEPTION
334: WHEN fnd_api.g_exc_error THEN

Line 342: cep_standard.debug_msg_stack(x_msg_count, x_msg_data);

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;

Line 353: cep_standard.debug_msg_stack(x_msg_count, x_msg_data);

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;

Line 367: cep_standard.debug_msg_stack(x_msg_count, x_msg_data);

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:

Line 462: cep_standard.debug('>>CE_EXT_BANK_ACCT_PUB.update_bank.');

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

Line 568: cep_standard.debug('<

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('< 569: END IF;
570:
571: EXCEPTION
572: WHEN fnd_api.g_exc_error THEN

Line 580: cep_standard.debug_msg_stack(x_msg_count, x_msg_data);

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;

Line 591: cep_standard.debug_msg_stack(x_msg_count, x_msg_data);

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;

Line 605: cep_standard.debug_msg_stack(x_msg_count, x_msg_data);

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:

Line 690: cep_standard.debug('>>CE_EXT_BANK_ACCT_PUB.set_bank_end_date.');

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

Line 779: cep_standard.debug('<

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('< 780: END IF;
781:
782: EXCEPTION
783: WHEN fnd_api.g_exc_error THEN

Line 791: cep_standard.debug_msg_stack(x_msg_count, x_msg_data);

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;

Line 802: cep_standard.debug_msg_stack(x_msg_count, x_msg_data);

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;

Line 816: cep_standard.debug_msg_stack(x_msg_count, x_msg_data);

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:

Line 888: cep_standard.debug('>>CE_EXT_BANK_ACCT_PUB.check_bank_exist.');

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;

Line 913: cep_standard.debug('<

909: x_end_date := null;
910: END IF;
911:
912: IF l_DEBUG in ('Y', 'C') THEN
913: cep_standard.debug('< 914: END IF;
915:
916: EXCEPTION
917: WHEN OTHERS THEN

Line 918: cep_standard.sql_error('CE_EXT_BANK_ACCT_PUB.check_bank_exist', sqlcode, sqlerrm);

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:

Line 1032: cep_standard.debug('>>CE_EXT_BANK_ACCT_PUB.create_bank_branch.');

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

Line 1201: cep_standard.debug('<

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('< 1202: END IF;
1203:
1204: EXCEPTION
1205: WHEN fnd_api.g_exc_error THEN

Line 1213: cep_standard.debug_msg_stack(x_msg_count, x_msg_data);

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;

Line 1224: cep_standard.debug_msg_stack(x_msg_count, x_msg_data);

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;

Line 1238: cep_standard.debug_msg_stack(x_msg_count, x_msg_data);

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:

Line 1359: cep_standard.debug('>>CE_EXT_BANK_ACCT_PUB.update_bank_branch.');

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

Line 1524: cep_standard.debug('<

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('< 1525: END IF;
1526:
1527: EXCEPTION
1528: WHEN fnd_api.g_exc_error THEN

Line 1536: cep_standard.debug_msg_stack(x_msg_count, x_msg_data);

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;

Line 1547: cep_standard.debug_msg_stack(x_msg_count, x_msg_data);

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;

Line 1561: cep_standard.debug_msg_stack(x_msg_count, x_msg_data);

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:

Line 1680: cep_standard.debug('>>CE_EXT_BANK_ACCT_PUB.set_bank_branch_end_date.');

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

Line 1858: cep_standard.debug('<

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('< 1859: END IF;
1860:
1861: EXCEPTION
1862: WHEN fnd_api.g_exc_error THEN

Line 1871: cep_standard.debug_msg_stack(x_msg_count, x_msg_data);

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;

Line 1883: cep_standard.debug_msg_stack(x_msg_count, x_msg_data);

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;

Line 1898: cep_standard.debug_msg_stack(x_msg_count, x_msg_data);

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:

Line 1979: cep_standard.debug('>>CE_EXT_BANK_ACCT_PUB.check_branch_exist.');

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;

Line 2004: cep_standard.debug('<

2000: x_end_date := null;
2001: END IF;
2002:
2003: IF l_DEBUG in ('Y', 'C') THEN
2004: cep_standard.debug('< 2005: END IF;
2006:
2007: EXCEPTION
2008: WHEN OTHERS THEN

Line 2009: cep_standard.sql_error('CE_EXT_BANK_ACCT_PUB.check_branch_exist', sqlcode, sqlerrm);

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:

Line 2096: cep_standard.debug('>>CE_BANK_PUB.create_bank_acct.');

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

Line 2413: cep_standard.debug('Starting XTR API Call...');

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:

Line 2415: cep_standard.debug('p_acct_rec.xtr_use_allowed_flag = ' || p_acct_rec.xtr_use_allowed_flag);

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:

Line 2418: cep_standard.debug('p_acct_rec.account_owner_org_id = ' || p_acct_rec.account_owner_org_id);

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

Line 2425: cep_standard.debug('l_party_code = ' || l_party_code);

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

Line 2426: cep_standard.debug('x_acct_id = ' || x_acct_id);

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

Line 2427: cep_standard.debug('p_acct_rec.branch_id = ' || p_acct_rec.branch_id);

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

Line 2433: cep_standard.debug('l_bank_code = ' || l_bank_code);

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

Line 2441: cep_standard.debug('l_city = ' || l_city);

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(

Line 2442: cep_standard.debug('l_ADDRESS_LINE1 = ' || l_ADDRESS_LINE1);

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

Line 2443: cep_standard.debug('l_EFT_SWIFT_CODE = ' || 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
2447: NULL, -- p_authorised

Line 2490: cep_standard.debug('Call to XTR API XTR_REPLICATE_BANK_ACCOUNTS_P.REPLICATE_BANK_ACCOUNTS Sucessfully Completed...');

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;

Line 2492: cep_standard.debug('Call to XTR API XTR_REPLICATE_BANK_ACCOUNTS_P.REPLICATE_BANK_ACCOUNTS has failed...');

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

Line 2504: cep_standard.debug('<

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('< 2505: END IF;
2506:
2507: EXCEPTION
2508: WHEN fnd_api.g_exc_error THEN

Line 2516: cep_standard.debug_msg_stack(x_msg_count, x_msg_data);

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;

Line 2527: cep_standard.debug_msg_stack(x_msg_count, x_msg_data);

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;

Line 2541: cep_standard.debug_msg_stack(x_msg_count, x_msg_data);

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:

Line 2672: cep_standard.debug('>>CE_BANK_PUB.update_bank_acct.');

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

Line 3003: cep_standard.debug('<

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('< 3004: END IF;
3005:
3006: EXCEPTION
3007: WHEN fnd_api.g_exc_error THEN

Line 3015: cep_standard.debug_msg_stack(x_msg_count, x_msg_data);

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;

Line 3026: cep_standard.debug_msg_stack(x_msg_count, x_msg_data);

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;

Line 3040: cep_standard.debug_msg_stack(x_msg_count, x_msg_data);

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:

Line 3073: cep_standard.debug('>>CE_BANK_PUB.create_bank_acct_use.');

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

Line 3349: cep_standard.debug('<

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('< 3350: END IF;
3351:
3352: EXCEPTION
3353: WHEN fnd_api.g_exc_error THEN

Line 3361: cep_standard.debug_msg_stack(x_msg_count, x_msg_data);

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;

Line 3372: cep_standard.debug_msg_stack(x_msg_count, x_msg_data);

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;

Line 3386: cep_standard.debug_msg_stack(x_msg_count, x_msg_data);

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;

Line 3430: cep_standard.debug('>>CE_BANK_PUB.update_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

Line 3644: cep_standard.debug('<

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('< 3645: END IF;
3646:
3647: EXCEPTION
3648: WHEN fnd_api.g_exc_error THEN

Line 3656: cep_standard.debug_msg_stack(x_msg_count, x_msg_data);

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;

Line 3667: cep_standard.debug_msg_stack(x_msg_count, x_msg_data);

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;

Line 3681: cep_standard.debug_msg_stack(x_msg_count, x_msg_data);

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:

Line 3732: cep_standard.debug('>>CE_EXT_BANK_ACCT_PUB.set_bank_acct_end_date.');

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

Line 3791: cep_standard.debug('<

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('< 3792: END IF;
3793:
3794: EXCEPTION
3795: WHEN fnd_api.g_exc_error THEN

Line 3804: cep_standard.debug_msg_stack(x_msg_count, x_msg_data);

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;

Line 3816: cep_standard.debug_msg_stack(x_msg_count, x_msg_data);

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;

Line 3831: cep_standard.debug_msg_stack(x_msg_count, x_msg_data);

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;