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 CEP_STANDARD

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

198: BEGIN
199: SAVEPOINT create_bank;
200:
201: IF l_DEBUG in ('Y', 'C') THEN
202: cep_standard.debug('>>CE_EXT_BANK_ACCT_PUB.create_bank.');
203: END IF;
204:
205: -- initialize message list
206: IF fnd_api.to_boolean(p_init_msg_list) THEN

Line 304: cep_standard.debug('<

300: p_count => x_msg_count,
301: p_data => x_msg_data);
302:
303: IF l_DEBUG in ('Y', 'C') THEN
304: cep_standard.debug('< 305: END IF;
306:
307: EXCEPTION
308: WHEN fnd_api.g_exc_error THEN

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

312: p_count => x_msg_count,
313: p_data => x_msg_data);
314:
315: IF l_DEBUG in ('Y', 'C') THEN
316: cep_standard.debug_msg_stack(x_msg_count, x_msg_data);
317: END IF;
318:
319: WHEN fnd_api.g_exc_unexpected_error THEN
320: ROLLBACK TO create_bank;

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

323: p_count => x_msg_count,
324: p_data => x_msg_data);
325:
326: IF l_DEBUG in ('Y', 'C') THEN
327: cep_standard.debug_msg_stack(x_msg_count, x_msg_data);
328: END IF;
329:
330: WHEN OTHERS THEN
331: ROLLBACK TO create_bank;

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

337: p_count => x_msg_count,
338: p_data => x_msg_data);
339:
340: IF l_DEBUG in ('Y', 'C') THEN
341: cep_standard.debug_msg_stack(x_msg_count, x_msg_data);
342: END IF;
343:
344: END create_bank;
345:

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

428: BEGIN
429: SAVEPOINT update_bank;
430:
431: IF l_DEBUG in ('Y', 'C') THEN
432: cep_standard.debug('>>CE_EXT_BANK_ACCT_PUB.update_bank.');
433: END IF;
434:
435: -- initialize message list
436: IF fnd_api.to_boolean(p_init_msg_list) THEN

Line 540: cep_standard.debug('<

536: p_count => x_msg_count,
537: p_data => x_msg_data);
538:
539: IF l_DEBUG in ('Y', 'C') THEN
540: cep_standard.debug('< 541: END IF;
542:
543: EXCEPTION
544: WHEN fnd_api.g_exc_error THEN

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

548: p_count => x_msg_count,
549: p_data => x_msg_data);
550:
551: IF l_DEBUG in ('Y', 'C') THEN
552: cep_standard.debug_msg_stack(x_msg_count, x_msg_data);
553: END IF;
554:
555: WHEN fnd_api.g_exc_unexpected_error THEN
556: ROLLBACK TO update_bank;

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

559: p_count => x_msg_count,
560: p_data => x_msg_data);
561:
562: IF l_DEBUG in ('Y', 'C') THEN
563: cep_standard.debug_msg_stack(x_msg_count, x_msg_data);
564: END IF;
565:
566: WHEN OTHERS THEN
567: ROLLBACK TO update_bank;

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

573: p_count => x_msg_count,
574: p_data => x_msg_data);
575:
576: IF l_DEBUG in ('Y', 'C') THEN
577: cep_standard.debug_msg_stack(x_msg_count, x_msg_data);
578: END IF;
579:
580: END update_bank;
581:

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

658: BEGIN
659: SAVEPOINT set_bank_end_date;
660:
661: IF l_DEBUG in ('Y', 'C') THEN
662: cep_standard.debug('>>CE_EXT_BANK_ACCT_PUB.set_bank_end_date.');
663: END IF;
664:
665: -- initialize message list
666: IF fnd_api.to_boolean(p_init_msg_list) THEN

Line 755: cep_standard.debug('<

751: p_count => x_msg_count,
752: p_data => x_msg_data);
753:
754: IF l_DEBUG in ('Y', 'C') THEN
755: cep_standard.debug('< 756: END IF;
757:
758: EXCEPTION
759: WHEN fnd_api.g_exc_error THEN

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

763: p_count => x_msg_count,
764: p_data => x_msg_data);
765:
766: IF l_DEBUG in ('Y', 'C') THEN
767: cep_standard.debug_msg_stack(x_msg_count, x_msg_data);
768: END IF;
769:
770: WHEN fnd_api.g_exc_unexpected_error THEN
771: ROLLBACK TO set_bank_end_date;

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

774: p_count => x_msg_count,
775: p_data => x_msg_data);
776:
777: IF l_DEBUG in ('Y', 'C') THEN
778: cep_standard.debug_msg_stack(x_msg_count, x_msg_data);
779: END IF;
780:
781: WHEN OTHERS THEN
782: ROLLBACK TO set_bank_end_date;

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

788: p_count => x_msg_count,
789: p_data => x_msg_data);
790:
791: IF l_DEBUG in ('Y', 'C') THEN
792: cep_standard.debug_msg_stack(x_msg_count, x_msg_data);
793: END IF;
794:
795: END set_bank_end_date;
796:

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

856: AND hz_hop.bank_or_branch_number = p_bank_number;
857:
858: BEGIN
859: IF l_DEBUG in ('Y', 'C') THEN
860: cep_standard.debug('>>CE_EXT_BANK_ACCT_PUB.check_bank_exist.');
861: END IF;
862:
863: IF p_bank_name IS NOT NULL THEN
864: OPEN c_bank_name;

Line 885: cep_standard.debug('<

881: x_end_date := null;
882: END IF;
883:
884: IF l_DEBUG in ('Y', 'C') THEN
885: cep_standard.debug('< 886: END IF;
887:
888: EXCEPTION
889: WHEN OTHERS THEN

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

886: END IF;
887:
888: EXCEPTION
889: WHEN OTHERS THEN
890: cep_standard.sql_error('CE_EXT_BANK_ACCT_PUB.check_bank_exist', sqlcode, sqlerrm);
891:
892: END check_bank_exist;
893:
894:

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

1000: BEGIN
1001: SAVEPOINT create_bank_branch;
1002:
1003: IF l_DEBUG in ('Y', 'C') THEN
1004: cep_standard.debug('>>CE_EXT_BANK_ACCT_PUB.create_bank_branch.');
1005: END IF;
1006:
1007: -- initialize message list
1008: IF fnd_api.to_boolean(p_init_msg_list) THEN

Line 1148: cep_standard.debug('<

1144: p_count => x_msg_count,
1145: p_data => x_msg_data);
1146:
1147: IF l_DEBUG in ('Y', 'C') THEN
1148: cep_standard.debug('< 1149: END IF;
1150:
1151: EXCEPTION
1152: WHEN fnd_api.g_exc_error THEN

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

1156: p_count => x_msg_count,
1157: p_data => x_msg_data);
1158:
1159: IF l_DEBUG in ('Y', 'C') THEN
1160: cep_standard.debug_msg_stack(x_msg_count, x_msg_data);
1161: END IF;
1162:
1163: WHEN fnd_api.g_exc_unexpected_error THEN
1164: ROLLBACK TO create_bank_branch;

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

1167: p_count => x_msg_count,
1168: p_data => x_msg_data);
1169:
1170: IF l_DEBUG in ('Y', 'C') THEN
1171: cep_standard.debug_msg_stack(x_msg_count, x_msg_data);
1172: END IF;
1173:
1174: WHEN OTHERS THEN
1175: ROLLBACK TO create_bank_branch;

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

1181: p_count => x_msg_count,
1182: p_data => x_msg_data);
1183:
1184: IF l_DEBUG in ('Y', 'C') THEN
1185: cep_standard.debug_msg_stack(x_msg_count, x_msg_data);
1186: END IF;
1187:
1188: END create_bank_branch;
1189:

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

1298: BEGIN
1299: SAVEPOINT update_bank_branch;
1300:
1301: IF l_DEBUG in ('Y', 'C') THEN
1302: cep_standard.debug('>>CE_EXT_BANK_ACCT_PUB.update_bank_branch.');
1303: END IF;
1304:
1305: -- initialize message list
1306: IF fnd_api.to_boolean(p_init_msg_list) THEN

Line 1441: cep_standard.debug('<

1437: p_count => x_msg_count,
1438: p_data => x_msg_data);
1439:
1440: IF l_DEBUG in ('Y', 'C') THEN
1441: cep_standard.debug('< 1442: END IF;
1443:
1444: EXCEPTION
1445: WHEN fnd_api.g_exc_error THEN

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

1449: p_count => x_msg_count,
1450: p_data => x_msg_data);
1451:
1452: IF l_DEBUG in ('Y', 'C') THEN
1453: cep_standard.debug_msg_stack(x_msg_count, x_msg_data);
1454: END IF;
1455:
1456: WHEN fnd_api.g_exc_unexpected_error THEN
1457: ROLLBACK TO update_bank_branch;

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

1460: p_count => x_msg_count,
1461: p_data => x_msg_data);
1462:
1463: IF l_DEBUG in ('Y', 'C') THEN
1464: cep_standard.debug_msg_stack(x_msg_count, x_msg_data);
1465: END IF;
1466:
1467: WHEN OTHERS THEN
1468: ROLLBACK TO update_bank_branch;

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

1474: p_count => x_msg_count,
1475: p_data => x_msg_data);
1476:
1477: IF l_DEBUG in ('Y', 'C') THEN
1478: cep_standard.debug_msg_stack(x_msg_count, x_msg_data);
1479: END IF;
1480:
1481: END update_bank_branch;
1482:

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

1577: BEGIN
1578: SAVEPOINT set_bank_branch_end_date;
1579:
1580: IF l_DEBUG in ('Y', 'C') THEN
1581: cep_standard.debug('>>CE_EXT_BANK_ACCT_PUB.set_bank_branch_end_date.');
1582: END IF;
1583:
1584: -- initialize message list
1585: IF fnd_api.to_boolean(p_init_msg_list) THEN

Line 1721: cep_standard.debug('<

1717: p_count => x_msg_count,
1718: p_data => x_msg_data);
1719:
1720: IF l_DEBUG in ('Y', 'C') THEN
1721: cep_standard.debug('< 1722: END IF;
1723:
1724: EXCEPTION
1725: WHEN fnd_api.g_exc_error THEN

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

1729: p_count => x_msg_count,
1730: p_data => x_msg_data);
1731:
1732: IF l_DEBUG in ('Y', 'C') THEN
1733: cep_standard.debug_msg_stack(x_msg_count, x_msg_data);
1734: END IF;
1735:
1736: WHEN fnd_api.g_exc_unexpected_error THEN
1737: ROLLBACK TO set_bank_branch_end_date;

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

1740: p_count => x_msg_count,
1741: p_data => x_msg_data);
1742:
1743: IF l_DEBUG in ('Y', 'C') THEN
1744: cep_standard.debug_msg_stack(x_msg_count, x_msg_data);
1745: END IF;
1746:
1747: WHEN OTHERS THEN
1748: ROLLBACK TO set_bank_branch_end_date;

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

1754: p_count => x_msg_count,
1755: p_data => x_msg_data);
1756:
1757: IF l_DEBUG in ('Y', 'C') THEN
1758: cep_standard.debug_msg_stack(x_msg_count, x_msg_data);
1759: END IF;
1760:
1761: END set_bank_branch_end_date;
1762:

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

1836: and NVL(TRUNC(hz_branchProf.effective_end_date), SYSDATE+1)
1837: AND hz_branchProf.bank_or_branch_number = p_branch_number;
1838: BEGIN
1839: IF l_DEBUG in ('Y', 'C') THEN
1840: cep_standard.debug('>>CE_EXT_BANK_ACCT_PUB.check_branch_exist.');
1841: END IF;
1842:
1843: IF p_branch_name IS NOT NULL THEN
1844: OPEN c_branch_name;

Line 1865: cep_standard.debug('<

1861: x_end_date := null;
1862: END IF;
1863:
1864: IF l_DEBUG in ('Y', 'C') THEN
1865: cep_standard.debug('< 1866: END IF;
1867:
1868: EXCEPTION
1869: WHEN OTHERS THEN

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

1866: END IF;
1867:
1868: EXCEPTION
1869: WHEN OTHERS THEN
1870: cep_standard.sql_error('CE_EXT_BANK_ACCT_PUB.check_branch_exist', sqlcode, sqlerrm);
1871:
1872: END check_branch_exist;
1873:
1874:

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

1941: BEGIN
1942: SAVEPOINT create_bank_acct;
1943:
1944: IF l_DEBUG in ('Y', 'C') THEN
1945: cep_standard.debug('>>CE_BANK_PUB.create_bank_acct.');
1946: END IF;
1947:
1948: -- initialize message list
1949: IF fnd_api.to_boolean(p_init_msg_list) THEN

Line 2269: cep_standard.debug('<

2265: p_count => x_msg_count,
2266: p_data => x_msg_data);
2267:
2268: IF l_DEBUG in ('Y', 'C') THEN
2269: cep_standard.debug('< 2270: END IF;
2271:
2272: EXCEPTION
2273: WHEN fnd_api.g_exc_error THEN

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

2277: p_count => x_msg_count,
2278: p_data => x_msg_data);
2279:
2280: IF l_DEBUG in ('Y', 'C') THEN
2281: cep_standard.debug_msg_stack(x_msg_count, x_msg_data);
2282: END IF;
2283:
2284: WHEN fnd_api.g_exc_unexpected_error THEN
2285: ROLLBACK TO create_bank_acct;

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

2288: p_count => x_msg_count,
2289: p_data => x_msg_data);
2290:
2291: IF l_DEBUG in ('Y', 'C') THEN
2292: cep_standard.debug_msg_stack(x_msg_count, x_msg_data);
2293: END IF;
2294:
2295: WHEN OTHERS THEN
2296: ROLLBACK TO create_bank_acct;

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

2302: p_count => x_msg_count,
2303: p_data => x_msg_data);
2304:
2305: IF l_DEBUG in ('Y', 'C') THEN
2306: cep_standard.debug_msg_stack(x_msg_count, x_msg_data);
2307: END IF;
2308:
2309: END create_bank_acct;
2310:

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

2375: BEGIN
2376: SAVEPOINT update_bank_acct;
2377:
2378: IF l_DEBUG in ('Y', 'C') THEN
2379: cep_standard.debug('>>CE_BANK_PUB.update_bank_acct.');
2380: END IF;
2381:
2382: -- initialize message list
2383: IF fnd_api.to_boolean(p_init_msg_list) THEN

Line 2635: cep_standard.debug('<

2631: p_count => x_msg_count,
2632: p_data => x_msg_data);
2633:
2634: IF l_DEBUG in ('Y', 'C') THEN
2635: cep_standard.debug('< 2636: END IF;
2637:
2638: EXCEPTION
2639: WHEN fnd_api.g_exc_error THEN

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

2643: p_count => x_msg_count,
2644: p_data => x_msg_data);
2645:
2646: IF l_DEBUG in ('Y', 'C') THEN
2647: cep_standard.debug_msg_stack(x_msg_count, x_msg_data);
2648: END IF;
2649:
2650: WHEN fnd_api.g_exc_unexpected_error THEN
2651: ROLLBACK TO update_bank_acct;

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

2654: p_count => x_msg_count,
2655: p_data => x_msg_data);
2656:
2657: IF l_DEBUG in ('Y', 'C') THEN
2658: cep_standard.debug_msg_stack(x_msg_count, x_msg_data);
2659: END IF;
2660:
2661: WHEN OTHERS THEN
2662: ROLLBACK TO udpate_bank_acct;

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

2668: p_count => x_msg_count,
2669: p_data => x_msg_data);
2670:
2671: IF l_DEBUG in ('Y', 'C') THEN
2672: cep_standard.debug_msg_stack(x_msg_count, x_msg_data);
2673: END IF;
2674:
2675: END update_bank_acct;
2676:

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

2702: BEGIN
2703: SAVEPOINT create_bank_acct_use;
2704:
2705: IF l_DEBUG in ('Y', 'C') THEN
2706: cep_standard.debug('>>CE_BANK_PUB.create_bank_acct_use.');
2707: END IF;
2708:
2709: -- initialize message list
2710: IF fnd_api.to_boolean(p_init_msg_list) THEN

Line 2983: cep_standard.debug('<

2979: p_count => x_msg_count,
2980: p_data => x_msg_data);
2981:
2982: IF l_DEBUG in ('Y', 'C') THEN
2983: cep_standard.debug('< 2984: END IF;
2985:
2986: EXCEPTION
2987: WHEN fnd_api.g_exc_error THEN

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

2991: p_count => x_msg_count,
2992: p_data => x_msg_data);
2993:
2994: IF l_DEBUG in ('Y', 'C') THEN
2995: cep_standard.debug_msg_stack(x_msg_count, x_msg_data);
2996: END IF;
2997:
2998: WHEN fnd_api.g_exc_unexpected_error THEN
2999: ROLLBACK TO create_bank_acct_use;

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

3002: p_count => x_msg_count,
3003: p_data => x_msg_data);
3004:
3005: IF l_DEBUG in ('Y', 'C') THEN
3006: cep_standard.debug_msg_stack(x_msg_count, x_msg_data);
3007: END IF;
3008:
3009: WHEN OTHERS THEN
3010: ROLLBACK TO create_bank_acct_use;

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

3016: p_count => x_msg_count,
3017: p_data => x_msg_data);
3018:
3019: IF l_DEBUG in ('Y', 'C') THEN
3020: cep_standard.debug_msg_stack(x_msg_count, x_msg_data);
3021: END IF;
3022:
3023:
3024: END create_bank_acct_use;

Line 3064: cep_standard.debug('>>CE_BANK_PUB.update_bank_acct_use.');

3060: BEGIN
3061: SAVEPOINT update_bank_acct_use;
3062:
3063: IF l_DEBUG in ('Y', 'C') THEN
3064: cep_standard.debug('>>CE_BANK_PUB.update_bank_acct_use.');
3065: END IF;
3066:
3067: -- initialize message list
3068: IF fnd_api.to_boolean(p_init_msg_list) THEN

Line 3282: cep_standard.debug('<

3278: p_count => x_msg_count,
3279: p_data => x_msg_data);
3280:
3281: IF l_DEBUG in ('Y', 'C') THEN
3282: cep_standard.debug('< 3283: END IF;
3284:
3285: EXCEPTION
3286: WHEN fnd_api.g_exc_error THEN

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

3290: p_count => x_msg_count,
3291: p_data => x_msg_data);
3292:
3293: IF l_DEBUG in ('Y', 'C') THEN
3294: cep_standard.debug_msg_stack(x_msg_count, x_msg_data);
3295: END IF;
3296:
3297: WHEN fnd_api.g_exc_unexpected_error THEN
3298: ROLLBACK TO update_bank_acct_use;

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

3301: p_count => x_msg_count,
3302: p_data => x_msg_data);
3303:
3304: IF l_DEBUG in ('Y', 'C') THEN
3305: cep_standard.debug_msg_stack(x_msg_count, x_msg_data);
3306: END IF;
3307:
3308: WHEN OTHERS THEN
3309: ROLLBACK TO udpate_bank_acct_use;

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

3315: p_count => x_msg_count,
3316: p_data => x_msg_data);
3317:
3318: IF l_DEBUG in ('Y', 'C') THEN
3319: cep_standard.debug_msg_stack(x_msg_count, x_msg_data);
3320: END IF;
3321:
3322: END update_bank_acct_use;
3323: