16: BEGIN
17: CREATE_FP_PA_PRI_ROLLUP ;
18: EXCEPTION
19: WHEN OTHERS THEN
20: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
21: p_procedure_name => 'CREATE_FP_PA_ROLLUP');
22: RAISE;
23: END;
24:
27: BEGIN
28: CREATE_FP_GL_PRI_ROLLUP ;
29: EXCEPTION
30: WHEN OTHERS THEN
31: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
32: p_procedure_name => 'CREATE_FP_GL_ROLLUP');
33: RAISE;
34: END;
35:
37: BEGIN
38: NULL;
39: EXCEPTION
40: WHEN OTHERS THEN
41: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
42: p_procedure_name => 'CREATE_FP_NONTP_ROLLUP');
43: RAISE;
44: END;
45:
254: AND period_type_id < 2048;
255:
256: EXCEPTION
257: WHEN OTHERS THEN
258: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
259: p_procedure_name => 'CREATE_FP_ENT_ROLLUP');
260: RAISE;
261: END;
262:
493: AND period_type_id < 2048;
494:
495: EXCEPTION
496: WHEN OTHERS THEN
497: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
498: p_procedure_name => 'CREATE_FP_PA_PRI_ROLLUP');
499: RAISE;
500: END;
501:
739:
740:
741: EXCEPTION
742: WHEN OTHERS THEN
743: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
744: p_procedure_name => 'CREATE_FP_GL_PRI_ROLLUP');
745: RAISE;
746: END;
747:
1339: END IF;
1340:
1341: EXCEPTION
1342: WHEN OTHERS THEN
1343: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
1344: p_procedure_name => 'CREATE_FP_ALL_T_PRI_ROLLUP');
1345: RAISE;
1346: END;
1347:
1546:
1547:
1548: EXCEPTION
1549: WHEN OTHERS THEN
1550: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
1551: p_procedure_name => 'CREATE_FP_ALLT_PRI_AGGREGATE');
1552: RAISE;
1553: END;
1554:
1810:
1811:
1812: EXCEPTION
1813: WHEN OTHERS THEN
1814: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
1815: p_procedure_name => 'CREATE_FP_ALLT_SEC_AGGREGATE');
1816: RAISE;
1817: END;
1818:
2053:
2054:
2055: EXCEPTION
2056: WHEN OTHERS THEN
2057: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
2058: p_procedure_name => 'CREATE_FP_GL_SEC_ROLLUP');
2059: RAISE;
2060: END;
2061:
2294: AND period_type_id < 2048;
2295:
2296: EXCEPTION
2297: WHEN OTHERS THEN
2298: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
2299: p_procedure_name => 'CREATE_FP_ENT_SEC_ROLLUP');
2300: RAISE;
2301: END;
2302:
2477:
2478:
2479: EXCEPTION
2480: WHEN OTHERS THEN
2481: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
2482: p_procedure_name => 'CREATE_AC_PA_ROLLUP');
2483: RAISE;
2484: END;
2485:
2659: AND period_type_id < 2048;
2660:
2661: EXCEPTION
2662: WHEN OTHERS THEN
2663: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
2664: p_procedure_name => 'CREATE_AC_GL_ROLLUP');
2665: RAISE;
2666: END;
2667:
2841: AND period_type_id < 2048;
2842:
2843: EXCEPTION
2844: WHEN OTHERS THEN
2845: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
2846: p_procedure_name => 'CREATE_AC_ENT_ROLLUP');
2847: RAISE;
2848: END;
2849:
3041: AND period_type_id = 2048;
3042:
3043: EXCEPTION
3044: WHEN OTHERS THEN
3045: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
3046: p_procedure_name => 'CREATE_AC_ALL_T_PRI_ROLLUP');
3047: RAISE;
3048: END;
3049:
4483: , a.RATE_DANGLING_FLAG;
4484:
4485: EXCEPTION
4486: WHEN OTHERS THEN
4487: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
4488: p_procedure_name => ' PRORATE_TO_ENT_PG_PJP1_D ');
4489: RAISE;
4490: END;
4491:
5631: , a.PLAN_TYPE_CODE ;
5632:
5633: EXCEPTION
5634: WHEN OTHERS THEN
5635: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
5636: p_procedure_name => 'PRORATE_TO_ENT_PG_FPRL_D ');
5637: RAISE;
5638: END;
5639:
7076: , a.RATE_DANGLING_FLAG;
7077:
7078: EXCEPTION
7079: WHEN OTHERS THEN
7080: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
7081: p_procedure_name => ' PRORATE_TO_ENT_N_PJP1_D ');
7082: RAISE;
7083: END;
7084:
7484: , fact.RATE_DANGLING_FLAG;
7485:
7486: EXCEPTION
7487: WHEN OTHERS THEN
7488: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
7489: p_procedure_name => 'PRORATE_TO_ENT_PG_PJP1_SE');
7490: RAISE;
7491: END;
7492:
7687: , fact.PLAN_TYPE_CODE ; /* 4471527 */
7688:
7689: EXCEPTION
7690: WHEN OTHERS THEN
7691: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
7692: p_procedure_name => 'PRORATE_TO_ENT_PG_FPRL_SE');
7693: RAISE;
7694: END;
7695:
8108:
8109:
8110: EXCEPTION
8111: WHEN OTHERS THEN
8112: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
8113: p_procedure_name => 'PRORATE_TO_ENT_N_PJP1_SE');
8114: RAISE;
8115: END;
8116:
9573:
9574:
9575: EXCEPTION
9576: WHEN OTHERS THEN
9577: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
9578: p_procedure_name => ' PRORATE_TO_PAGL_PGE_PJP1_D ');
9579: RAISE;
9580: END;
9581:
10729:
10730:
10731: EXCEPTION
10732: WHEN OTHERS THEN
10733: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
10734: p_procedure_name => 'PRORATE_TO_PAGL_PGE_FPRL_D ');
10735: RAISE;
10736: END;
10737:
12188:
12189:
12190: EXCEPTION
12191: WHEN OTHERS THEN
12192: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
12193: p_procedure_name => ' PRORATE_TO_PAGL_N_PJP1_D ');
12194: RAISE;
12195: END;
12196:
12598: , fact.PLAN_TYPE_CODe ; /* 4471527 */
12599:
12600: EXCEPTION
12601: WHEN OTHERS THEN
12602: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
12603: p_procedure_name => 'PRORATE_TO_PAGL_PGE_PJP1_SE');
12604: RAISE;
12605: END;
12606:
12812:
12813:
12814: EXCEPTION
12815: WHEN OTHERS THEN
12816: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
12817: p_procedure_name => 'PRORATE_TO_PAGL_PGE_FPRL_SE');
12818: RAISE;
12819: END;
12820:
13249: , DECODE(pa_cal.calendar_id,orginfo.pa_calendar_id,'P',orginfo.gl_calendar_id,'G');
13250:
13251: EXCEPTION
13252: WHEN OTHERS THEN
13253: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
13254: p_procedure_name => 'PRORATE_TO_PAGL_N_PJP1_SE');
13255: RAISE;
13256: END;
13257:
13263: BEGIN
13264: PJI_PJP_FP_CURR_WRAP.print_time(p_tag);
13265: EXCEPTION
13266: WHEN OTHERS THEN
13267: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
13268: p_procedure_name => 'PRINT_TIME');
13269: RAISE;
13270: END;
13271: