DBA Data[Home] [Help]

APPS.PJI_FM_PLAN_MAINT_T_PVT dependencies on FND_MSG_PUB

Line 341: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,

337: END IF;
338:
339: EXCEPTION
340: WHEN OTHERS THEN
341: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
342: p_procedure_name => 'COPY_PRIMARY');
343: RAISE;
344: END;
345:

Line 584: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,

580: END IF;
581:
582: EXCEPTION
583: WHEN OTHERS THEN
584: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
585: p_procedure_name => 'COPY_PLANS');
586: RAISE;
587: END;
588:

Line 808: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,

804: print_time ( ' COPY_PRIMARY_SINGLE api 005 ');
805:
806: EXCEPTION
807: WHEN OTHERS THEN
808: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
809: p_procedure_name => 'COPY_PRIMARY_SINGLE');
810: RAISE;
811: END;
812:

Line 1038: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,

1034: print_time('EXTRACT_FIN_PLAN_VERS_BULK : End .. rows processed ' || SQL%ROWCOUNT );
1035:
1036: EXCEPTION
1037: WHEN OTHERS THEN
1038: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
1039: p_procedure_name => 'EXTRACT_FIN_PLAN_VERS_BULK');
1040: print_time('EXTRACT_FIN_PLAN_VERS_BULK : Exception: ' || sqlerrm );
1041: RAISE;
1042: END;

Line 1289: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,

1285:
1286: EXCEPTION
1287: WHEN OTHERS THEN
1288: print_time('EXTRACT_FIN_PLAN_VERSIONS : Exception: ' || sqlerrm );
1289: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
1290: p_procedure_name => 'EXTRACT_FIN_PLAN_VERSIONS');
1291: RAISE;
1292: END;
1293:

Line 1884: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,

1880: EXCEPTION
1881: WHEN OTHERS THEN
1882: print_time('EXTRACT_PLAN_AMOUNTS_PRIRBS : Exception ' || SQLERRM );
1883: print_time('EXTRACT_PLAN_AMOUNTS_PRIRBS : Begin worker id is ... ' || 1);
1884: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
1885: p_procedure_name => 'EXTRACT_PLAN_AMOUNTS_PRIRBS');
1886: RAISE;
1887: END;
1888:

Line 1902: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,

1898:
1899: EXCEPTION
1900: WHEN OTHERS THEN
1901: print_time('EXTRACT_PLAN_AMOUNTS_SECRBS : Exception ' || SQLERRM );
1902: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
1903: p_procedure_name => 'EXTRACT_PLAN_AMOUNTS_SECRBS');
1904: RAISE;
1905: END;
1906:

Line 2950: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,

2946:
2947: EXCEPTION
2948: WHEN OTHERS THEN
2949: print_time('EXTRACT_PLAN_AMOUNTS_SECRBS : Exception ' || SQLERRM );
2950: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
2951: p_procedure_name => 'EXTRACT_PLAN_AMTS_SECRBS_GLC12');
2952: RAISE;
2953: END;
2954:

Line 3967: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,

3963:
3964: EXCEPTION
3965: WHEN OTHERS THEN
3966: print_time('EXTRACT_PLAN_AMTS_PRIRBS_GLC12 : Exception ' || SQLERRM );
3967: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
3968: p_procedure_name => 'EXTRACT_PLAN_AMTS_PRIRBS_GLC12');
3969: RAISE;
3970: END;
3971:

Line 4150: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,

4146:
4147: EXCEPTION
4148: WHEN OTHERS THEN
4149: print_time('REVERSE_PLAN_AMTS : Exception ' || SQLERRM );
4150: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
4151: p_procedure_name => 'REVERSE_PLAN_AMTS');
4152: RAISE;
4153: END;
4154:

Line 4167: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,

4163: AND worker_id = g_worker_id;
4164:
4165: EXCEPTION
4166: WHEN OTHERS THEN
4167: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
4168: p_procedure_name => 'RETRIEVE_RL_SECSLC_TIMEPH');
4169: RAISE;
4170: END;
4171:

Line 4200: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,

4196: END IF;
4197:
4198: EXCEPTION
4199: WHEN OTHERS THEN
4200: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
4201: p_procedure_name => 'INSERT_INTO_FP_FACT');
4202: RAISE;
4203: END;
4204:

Line 4388: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,

4384:
4385:
4386: EXCEPTION
4387: WHEN OTHERS THEN
4388: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
4389: p_procedure_name => 'GET_PRI_SLICE_DATA');
4390: RAISE;
4391: END;
4392:

Line 4401: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,

4397: NULL;
4398:
4399: EXCEPTION
4400: WHEN OTHERS THEN
4401: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
4402: p_procedure_name => 'GET_PRI_SLICE_DATA');
4403: RAISE;
4404: END;
4405:

Line 4427: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,

4423: AND bl.rowid IN ( SELECT extr_lines_rowid FROM pji_fp_rmap_fpr_update_t);
4424:
4425: EXCEPTION
4426: WHEN OTHERS THEN
4427: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
4428: p_procedure_name => 'UPDATE_ACTUALS_TO_NULL');
4429: RAISE;
4430: END;
4431:

Line 4946: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,

4942: print_time('........RETRIEVE_DELTA_SLICE : End.' );
4943:
4944: EXCEPTION
4945: WHEN OTHERS THEN
4946: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
4947: p_procedure_name => 'RETRIEVE_DELTA_SLICE');
4948: print_time('........RETRIEVE_DELTA_SLICE : Exception ' || sqlerrm );
4949: RAISE;
4950: END;

Line 5022: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,

5018: print_time('........POPULATE_PLN_VER_TABLE : End.' );
5019:
5020: EXCEPTION
5021: WHEN OTHERS THEN
5022: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
5023: p_procedure_name => 'POPULATE_PLN_VER_TABLE');
5024: print_time('........POPULATE_PLN_VER_TABLE : Exception: ' || sqlerrm );
5025: RAISE;
5026: END;

Line 5202: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,

5198: print_time('........GET_GLOBAL_EXCHANGE_RATES: End. ' );
5199:
5200: EXCEPTION
5201: WHEN OTHERS THEN
5202: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
5203: p_procedure_name => 'GET_GLOBAL_EXCHANGE_RATES');
5204: print_time('........GET_GLOBAL_EXCHANGE_RATES: Exception: ' || sqlerrm );
5205: RAISE;
5206: END;

Line 5221: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,

5217: print_time('........DELETE_GLOBAL_EXCHANGE_RATES: End. # rows is.. ' || SQL%ROWCOUNT );
5218:
5219: EXCEPTION
5220: WHEN OTHERS THEN
5221: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
5222: p_procedure_name => 'DELETE_GLOBAL_EXCHANGE_RATES');
5223: print_time('........DELETE_GLOBAL_EXCHANGE_RATES: Exception: ' || sqlerrm );
5224: RAISE;
5225: END;

Line 5254: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,

5250: -- This wont work!!!
5251:
5252: EXCEPTION
5253: WHEN OTHERS THEN
5254: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
5255: p_procedure_name => 'UPDATE_CURR_RCD_TYPES_GL1_GL2');
5256: RAISE;
5257: END;
5258: */

Line 5403: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,

5399:
5400: EXCEPTION
5401: WHEN OTHERS THEN
5402: print_time('........CONV_TO_GLOBAL_CURRENCIES: Exception ' || sqlerrm );
5403: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
5404: p_procedure_name => 'CONV_TO_GLOBAL_CURRENCIES');
5405: RAISE;
5406: END;
5407: */

Line 5424: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,

5420: AND worker_id = g_worker_id;
5421:
5422: EXCEPTION
5423: WHEN OTHERS THEN
5424: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
5425: p_procedure_name => 'DELETE_DNGLRATE_PLNVER_DATA');
5426: RAISE;
5427: END;
5428:

Line 6148: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,

6144:
6145: EXCEPTION
6146: WHEN OTHERS THEN
6147: print_time('........CREATE_GL1_GL2_CURR_RCDS: Exception. ' || sqlerrm );
6148: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
6149: p_procedure_name => 'CREATE_GL1_GL2_CURR_RCDS');
6150: RAISE;
6151: END;
6152: */

Line 6192: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,

6188:
6189: EXCEPTION
6190: WHEN OTHERS THEN
6191: print_time('........UPDATE_TPFG1_CURR_RCDS: Exception: ' || sqlerrm );
6192: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
6193: p_procedure_name => 'UPDATE_TPFG1_CURR_RCDS');
6194: RAISE;
6195: END;
6196:

Line 6234: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,

6230:
6231:
6232: EXCEPTION
6233: WHEN OTHERS THEN
6234: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
6235: p_procedure_name => 'DO_CURRENCY_DANGLING_CHECK');
6236: RAISE;
6237: END;
6238:

Line 6247: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,

6243: NULL;
6244:
6245: EXCEPTION
6246: WHEN OTHERS THEN
6247: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
6248: p_procedure_name => 'GET_PRORATE_FORMAT');
6249: RAISE;
6250: END;
6251:

Line 6260: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,

6256: NULL;
6257:
6258: EXCEPTION
6259: WHEN OTHERS THEN
6260: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
6261: p_procedure_name => 'GET_SPREAD_DATE_RANGE_AMOUNTS');
6262: RAISE;
6263: END;
6264:

Line 6273: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,

6269: NULL;
6270:
6271: EXCEPTION
6272: WHEN OTHERS THEN
6273: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
6274: p_procedure_name => 'SPREAD_NON_TIME_PHASE_AMOUNTS');
6275: RAISE;
6276: END;
6277:

Line 6291: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,

6287: NULL;
6288:
6289: EXCEPTION
6290: WHEN OTHERS THEN
6291: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
6292: p_procedure_name => 'PRORATE_NON_TIME_PHASED_AMTS');
6293: RAISE;
6294: END;
6295:

Line 6336: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,

6332: END IF;
6333:
6334: EXCEPTION
6335: WHEN OTHERS THEN
6336: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
6337: p_procedure_name => 'PRORATE_TO_OTHER_CALENDAR');
6338: RAISE;
6339: END;
6340:

Line 6375: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,

6371: -- Not raising any exception as we want the processing to happen properly.
6372: -- The where condition is added to make sure that workplan versions are not marked as dangling.
6373: WHEN OTHERS THEN
6374: print_time('PRORATE_TO_ALL_CALENDARS: Exception.. ' || sqlerrm);
6375: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
6376: p_procedure_name => 'PRORATE_TO_ALL_CALENDARS');
6377: RAISE;
6378: END;
6379:

Line 6427: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,

6423: END IF;
6424:
6425: EXCEPTION
6426: WHEN OTHERS THEN
6427: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
6428: p_procedure_name => 'PRORATE_TO_ENT');
6429: RAISE;
6430: END;
6431:

Line 6514: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,

6510: END IF;
6511:
6512: EXCEPTION
6513: WHEN OTHERS THEN
6514: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
6515: p_procedure_name => 'PRORATE');
6516: RAISE;
6517: END;
6518:

Line 6536: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,

6532:
6533: EXCEPTION
6534: WHEN OTHERS THEN
6535: print_time ( ' MERGE_INTO_FP_FACT 6 ' ) ;
6536: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
6537: p_procedure_name => 'MERGE_INTO_FP_FACT');
6538: RAISE;
6539: END;
6540:

Line 6555: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,

6551:
6552: EXCEPTION
6553: WHEN OTHERS THEN
6554: print_time ( 'ccc' || sqlerrm );
6555: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
6556: p_procedure_name => 'CLEANUP_FP_RMAP_FPR');
6557: RAISE;
6558: END;
6559:

Line 6603: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,

6599: print_time ( ' MERGE_INTO_FP_FACT 1.1 ' || SQL%ROWCOUNT ) ;
6600:
6601: EXCEPTION
6602: WHEN OTHERS THEN
6603: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
6604: p_procedure_name => 'GET_FP_ROW_IDS');
6605: RAISE;
6606: END;
6607:

Line 6619: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,

6615: NULL;
6616:
6617: EXCEPTION
6618: WHEN OTHERS THEN
6619: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
6620: p_procedure_name => 'GET_ACTUALS');
6621: RAISE;
6622: END;
6623:

Line 7227: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,

7223: DELETE_NTP_CAL_RECORD ( p_max_plnver_id => l_max_plnver_id );
7224:
7225: EXCEPTION
7226: WHEN OTHERS THEN
7227: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
7228: p_procedure_name => 'REVERSE_ETC');
7229: RAISE;
7230: END;
7231:

Line 7455: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,

7451:
7452:
7453: EXCEPTION
7454: WHEN OTHERS THEN
7455: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
7456: p_procedure_name => 'UPDATE_FP_ROWS');
7457: RAISE;
7458: END;
7459:

Line 7716: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,

7712:
7713:
7714: EXCEPTION
7715: WHEN OTHERS THEN
7716: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
7717: p_procedure_name => 'INSERT_FP_ROWS');
7718: RAISE;
7719: END;
7720:

Line 7870: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,

7866: , CURRENCY_CODE;
7867:
7868: EXCEPTION
7869: WHEN OTHERS THEN
7870: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
7871: p_procedure_name => 'INSERT_INTO_AC_FACT');
7872: RAISE;
7873: END;
7874:

Line 7889: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,

7885: INSERT_AC_ROWS;
7886:
7887: EXCEPTION
7888: WHEN OTHERS THEN
7889: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
7890: p_procedure_name => 'MERGE_INTO_AC_FACT');
7891: RAISE;
7892: END;
7893:

Line 7903: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,

7899: WHERE worker_id = g_worker_id;
7900:
7901: EXCEPTION
7902: WHEN OTHERS THEN
7903: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
7904: p_procedure_name => 'CLEANUP_AC_RMAP_FPR');
7905: RAISE;
7906: END;
7907:

Line 7941: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,

7937: AND tmp.CURRENCY_CODE = rl.CURRENCY_CODE (+) ;
7938:
7939: EXCEPTION
7940: WHEN OTHERS THEN
7941: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
7942: p_procedure_name => 'GET_AC_ROW_IDS');
7943: RAISE;
7944: END;
7945:

Line 8080: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,

8076: AND rwid.worker_id = g_worker_id);
8077:
8078: EXCEPTION
8079: WHEN OTHERS THEN
8080: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
8081: p_procedure_name => 'UPDATE_AC_ROWS');
8082: RAISE;
8083: END;
8084:

Line 8239: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,

8235: , CURRENCY_CODE;
8236:
8237: EXCEPTION
8238: WHEN OTHERS THEN
8239: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
8240: p_procedure_name => 'INSERT_AC_ROWS');
8241: RAISE;
8242: END;
8243:

Line 8286: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,

8282: );
8283:
8284: EXCEPTION
8285: WHEN OTHERS THEN
8286: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
8287: p_procedure_name => 'MARK_DANGLING_PLAN_VERSIONS');
8288: RAISE;
8289: END;
8290:

Line 8336: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,

8332: -- END LOOP;
8333:
8334: EXCEPTION
8335: WHEN OTHERS THEN
8336: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
8337: p_procedure_name => 'PULL_DANGLING_PLANS');
8338: RAISE;
8339: END;
8340:

Line 8505: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,

8501: );
8502:
8503: EXCEPTION
8504: WHEN OTHERS THEN
8505: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
8506: p_procedure_name => 'RETRIEVE_ENTERED_SLICE');
8507: RAISE;
8508: END;
8509:

Line 8710: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,

8706:
8707:
8708: EXCEPTION
8709: WHEN OTHERS THEN
8710: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
8711: p_procedure_name => 'ROLLUP_FPR_RBS');
8712: RAISE;
8713: END;
8714:

Line 8906: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,

8902:
8903:
8904: EXCEPTION
8905: WHEN OTHERS THEN
8906: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
8907: p_procedure_name => 'ROLLUP_FPR_RBS_T_SLICE');
8908: RAISE;
8909: END;
8910:

Line 8917: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,

8913: BEGIN
8914: NULL;
8915: EXCEPTION
8916: WHEN OTHERS THEN
8917: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
8918: p_procedure_name => 'COMPUTE_XBS_UPDATED_ROLLUPS');
8919: RAISE;
8920: END;
8921:

Line 9018: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,

9014:
9015: EXCEPTION
9016: WHEN OTHERS THEN
9017: print_time ( ' update rbs header exception ' || sqlerrm );
9018: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
9019: p_procedure_name => 'POPULATE_RBS_HDR');
9020: RAISE;
9021: END;
9022:

Line 9089: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,

9085:
9086: EXCEPTION
9087: WHEN OTHERS THEN
9088: print_time ( ' populate wbs header exception ' || sqlerrm );
9089: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
9090: p_procedure_name => 'POPULATE_WBS_HDR');
9091: RAISE;
9092: END;
9093:

Line 9139: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,

9135:
9136: EXCEPTION
9137: WHEN OTHERS THEN
9138: print_time ( ' update wbs header exception ' || sqlerrm );
9139: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
9140: p_procedure_name => 'POPULATE_WBS_HDR');
9141: RAISE;
9142: END;
9143:

Line 9179: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,

9175: AND TO_NUMBER(TO_CHAR(time.end_date, 'J')) > pa_calendar_max_date);
9176:
9177: EXCEPTION
9178: WHEN OTHERS THEN
9179: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
9180: p_procedure_name => 'MARK_TIME_DANGLING_VERSIONS');
9181: RAISE;
9182: END;
9183:

Line 9312: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,

9308: END IF;
9309:
9310: EXCEPTION
9311: WHEN OTHERS THEN
9312: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
9313: p_procedure_name => 'MARK_EXTRACTED_PLANS');
9314: RAISE;
9315: END;
9316:

Line 9343: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,

9339:
9340: EXCEPTION
9341: WHEN OTHERS THEN
9342: print_time('... Exception CREATE_WBSRLP ' );
9343: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
9344: p_procedure_name => 'CREATE_WBSRLP');
9345: RAISE;
9346: END;
9347:

Line 9437: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,

9433:
9434: EXCEPTION
9435: WHEN OTHERS THEN
9436: print_time('.......CLEANUP_INTERIM_TABLES: Exception. ' || sqlerrm);
9437: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
9438: p_procedure_name => 'CLEANUP_INTERIM_TABLES');
9439: RAISE;
9440: END CLEANUP_INTERIM_TABLES;
9441:

Line 9527: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,

9523: print_time (' INSERT_NTP_CAL_RECORD, # rows inserted is: ' || SQL%ROWCOUNT );
9524:
9525: EXCEPTION
9526: WHEN OTHERS THEN
9527: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
9528: p_procedure_name => 'INSERT_NTP_CAL_RECORD');
9529: RAISE;
9530: END;
9531:

Line 9545: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,

9541: print_time (' DELETE_NTP_CAL_RECORD, # rows deleted is: ' || SQL%ROWCOUNT );
9542:
9543: EXCEPTION
9544: WHEN OTHERS THEN
9545: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
9546: p_procedure_name => 'DELETE_NTP_CAL_RECORD');
9547: RAISE;
9548: END;
9549:

Line 9634: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,

9630:
9631: EXCEPTION
9632: WHEN OTHERS THEN
9633: print_time('MAP_ORG_CAL_INFO : exception.. ');
9634: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
9635: p_procedure_name => 'MAP_ORG_CAL_INFO');
9636: RAISE;
9637: END;
9638:

Line 9648: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,

9644: BEGIN
9645: PJI_PJP_FP_CURR_WRAP.print_time(p_tag);
9646: EXCEPTION
9647: WHEN OTHERS THEN
9648: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
9649: p_procedure_name => 'PRINT_TIME');
9650: RAISE;
9651: END;
9652: