DBA Data[Home] [Help]

APPS.PJI_FM_PLAN_MAINT_T_PVT dependencies on FND_MSG_PUB

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

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

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

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

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

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

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

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

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

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

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

1932: EXCEPTION
1933: WHEN OTHERS THEN
1934: print_time('EXTRACT_PLAN_AMOUNTS_PRIRBS : Exception ' || SQLERRM );
1935: print_time('EXTRACT_PLAN_AMOUNTS_PRIRBS : Begin worker id is ... ' || 1);
1936: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
1937: p_procedure_name => 'EXTRACT_PLAN_AMOUNTS_PRIRBS');
1938: RAISE;
1939: END;
1940:

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

1950:
1951: EXCEPTION
1952: WHEN OTHERS THEN
1953: print_time('EXTRACT_PLAN_AMOUNTS_SECRBS : Exception ' || SQLERRM );
1954: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
1955: p_procedure_name => 'EXTRACT_PLAN_AMOUNTS_SECRBS');
1956: RAISE;
1957: END;
1958:

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

3016:
3017: EXCEPTION
3018: WHEN OTHERS THEN
3019: print_time('EXTRACT_PLAN_AMOUNTS_SECRBS : Exception ' || SQLERRM );
3020: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
3021: p_procedure_name => 'EXTRACT_PLAN_AMTS_SECRBS_GLC12');
3022: RAISE;
3023: END;
3024:

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

4050:
4051: EXCEPTION
4052: WHEN OTHERS THEN
4053: print_time('EXTRACT_PLAN_AMTS_PRIRBS_GLC12 : Exception ' || SQLERRM );
4054: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
4055: p_procedure_name => 'EXTRACT_PLAN_AMTS_PRIRBS_GLC12');
4056: RAISE;
4057: END;
4058:

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

4233:
4234: EXCEPTION
4235: WHEN OTHERS THEN
4236: print_time('REVERSE_PLAN_AMTS : Exception ' || SQLERRM );
4237: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
4238: p_procedure_name => 'REVERSE_PLAN_AMTS');
4239: RAISE;
4240: END;
4241:

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

4250: AND worker_id = g_worker_id;
4251:
4252: EXCEPTION
4253: WHEN OTHERS THEN
4254: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
4255: p_procedure_name => 'RETRIEVE_RL_SECSLC_TIMEPH');
4256: RAISE;
4257: END;
4258:

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

4283: END IF;
4284:
4285: EXCEPTION
4286: WHEN OTHERS THEN
4287: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
4288: p_procedure_name => 'INSERT_INTO_FP_FACT');
4289: RAISE;
4290: END;
4291:

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

4471:
4472:
4473: EXCEPTION
4474: WHEN OTHERS THEN
4475: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
4476: p_procedure_name => 'GET_PRI_SLICE_DATA');
4477: RAISE;
4478: END;
4479:

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

4484: NULL;
4485:
4486: EXCEPTION
4487: WHEN OTHERS THEN
4488: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
4489: p_procedure_name => 'GET_PRI_SLICE_DATA');
4490: RAISE;
4491: END;
4492:

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

4510: AND bl.rowid IN ( SELECT extr_lines_rowid FROM pji_fp_rmap_fpr_update_t);
4511:
4512: EXCEPTION
4513: WHEN OTHERS THEN
4514: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
4515: p_procedure_name => 'UPDATE_ACTUALS_TO_NULL');
4516: RAISE;
4517: END;
4518:

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

5042: print_time('........RETRIEVE_DELTA_SLICE : End.' );
5043:
5044: EXCEPTION
5045: WHEN OTHERS THEN
5046: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
5047: p_procedure_name => 'RETRIEVE_DELTA_SLICE');
5048: print_time('........RETRIEVE_DELTA_SLICE : Exception ' || sqlerrm );
5049: RAISE;
5050: END;

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

5118: print_time('........POPULATE_PLN_VER_TABLE : End.' );
5119:
5120: EXCEPTION
5121: WHEN OTHERS THEN
5122: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
5123: p_procedure_name => 'POPULATE_PLN_VER_TABLE');
5124: print_time('........POPULATE_PLN_VER_TABLE : Exception: ' || sqlerrm );
5125: RAISE;
5126: END;

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

5299: print_time('........GET_GLOBAL_EXCHANGE_RATES: End. ' );
5300:
5301: EXCEPTION
5302: WHEN OTHERS THEN
5303: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
5304: p_procedure_name => 'GET_GLOBAL_EXCHANGE_RATES');
5305: print_time('........GET_GLOBAL_EXCHANGE_RATES: Exception: ' || sqlerrm );
5306: RAISE;
5307: END;

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

5318: print_time('........DELETE_GLOBAL_EXCHANGE_RATES: End. # rows is.. ' || SQL%ROWCOUNT );
5319:
5320: EXCEPTION
5321: WHEN OTHERS THEN
5322: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
5323: p_procedure_name => 'DELETE_GLOBAL_EXCHANGE_RATES');
5324: print_time('........DELETE_GLOBAL_EXCHANGE_RATES: Exception: ' || sqlerrm );
5325: RAISE;
5326: END;

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

5351: -- This wont work!!!
5352:
5353: EXCEPTION
5354: WHEN OTHERS THEN
5355: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
5356: p_procedure_name => 'UPDATE_CURR_RCD_TYPES_GL1_GL2');
5357: RAISE;
5358: END;
5359: */

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

5500:
5501: EXCEPTION
5502: WHEN OTHERS THEN
5503: print_time('........CONV_TO_GLOBAL_CURRENCIES: Exception ' || sqlerrm );
5504: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
5505: p_procedure_name => 'CONV_TO_GLOBAL_CURRENCIES');
5506: RAISE;
5507: END;
5508: */

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

5521: AND worker_id = g_worker_id;
5522:
5523: EXCEPTION
5524: WHEN OTHERS THEN
5525: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
5526: p_procedure_name => 'DELETE_DNGLRATE_PLNVER_DATA');
5527: RAISE;
5528: END;
5529:

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

6245:
6246: EXCEPTION
6247: WHEN OTHERS THEN
6248: print_time('........CREATE_GL1_GL2_CURR_RCDS: Exception. ' || sqlerrm );
6249: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
6250: p_procedure_name => 'CREATE_GL1_GL2_CURR_RCDS');
6251: RAISE;
6252: END;
6253: */

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

6289:
6290: EXCEPTION
6291: WHEN OTHERS THEN
6292: print_time('........UPDATE_TPFG1_CURR_RCDS: Exception: ' || sqlerrm );
6293: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
6294: p_procedure_name => 'UPDATE_TPFG1_CURR_RCDS');
6295: RAISE;
6296: END;
6297:

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

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

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

6344: NULL;
6345:
6346: EXCEPTION
6347: WHEN OTHERS THEN
6348: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
6349: p_procedure_name => 'GET_PRORATE_FORMAT');
6350: RAISE;
6351: END;
6352:

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

6357: NULL;
6358:
6359: EXCEPTION
6360: WHEN OTHERS THEN
6361: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
6362: p_procedure_name => 'GET_SPREAD_DATE_RANGE_AMOUNTS');
6363: RAISE;
6364: END;
6365:

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

6370: NULL;
6371:
6372: EXCEPTION
6373: WHEN OTHERS THEN
6374: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
6375: p_procedure_name => 'SPREAD_NON_TIME_PHASE_AMOUNTS');
6376: RAISE;
6377: END;
6378:

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

6388: NULL;
6389:
6390: EXCEPTION
6391: WHEN OTHERS THEN
6392: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
6393: p_procedure_name => 'PRORATE_NON_TIME_PHASED_AMTS');
6394: RAISE;
6395: END;
6396:

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

6433: END IF;
6434:
6435: EXCEPTION
6436: WHEN OTHERS THEN
6437: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
6438: p_procedure_name => 'PRORATE_TO_OTHER_CALENDAR');
6439: RAISE;
6440: END;
6441:

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

6472: -- Not raising any exception as we want the processing to happen properly.
6473: -- The where condition is added to make sure that workplan versions are not marked as dangling.
6474: WHEN OTHERS THEN
6475: print_time('PRORATE_TO_ALL_CALENDARS: Exception.. ' || sqlerrm);
6476: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
6477: p_procedure_name => 'PRORATE_TO_ALL_CALENDARS');
6478: RAISE;
6479: END;
6480:

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

6524: END IF;
6525:
6526: EXCEPTION
6527: WHEN OTHERS THEN
6528: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
6529: p_procedure_name => 'PRORATE_TO_ENT');
6530: RAISE;
6531: END;
6532:

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

6611: END IF;
6612:
6613: EXCEPTION
6614: WHEN OTHERS THEN
6615: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
6616: p_procedure_name => 'PRORATE');
6617: RAISE;
6618: END;
6619:

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

6648:
6649: EXCEPTION
6650: WHEN OTHERS THEN
6651: print_time ( ' MERGE_INTO_FP_FACT 6 ' ) ;
6652: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
6653: p_procedure_name => 'MERGE_INTO_FP_FACT');
6654: RAISE;
6655: END;
6656:

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

6667:
6668: EXCEPTION
6669: WHEN OTHERS THEN
6670: print_time ( 'ccc' || sqlerrm );
6671: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
6672: p_procedure_name => 'CLEANUP_FP_RMAP_FPR');
6673: RAISE;
6674: END;
6675:

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

6722: print_time ( ' MERGE_INTO_FP_FACT 1.1 ' || SQL%ROWCOUNT ) ;
6723:
6724: EXCEPTION
6725: WHEN OTHERS THEN
6726: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
6727: p_procedure_name => 'GET_FP_ROW_IDS');
6728: RAISE;
6729: END;
6730:

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

6738: NULL;
6739:
6740: EXCEPTION
6741: WHEN OTHERS THEN
6742: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
6743: p_procedure_name => 'GET_ACTUALS');
6744: RAISE;
6745: END;
6746:

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

7356: DELETE_NTP_CAL_RECORD ( p_max_plnver_id => l_max_plnver_id );
7357:
7358: EXCEPTION
7359: WHEN OTHERS THEN
7360: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
7361: p_procedure_name => 'REVERSE_ETC');
7362: RAISE;
7363: END;
7364:

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

7590:
7591:
7592: EXCEPTION
7593: WHEN OTHERS THEN
7594: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
7595: p_procedure_name => 'UPDATE_FP_ROWS');
7596: RAISE;
7597: END;
7598:

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

7860:
7861:
7862: EXCEPTION
7863: WHEN OTHERS THEN
7864: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
7865: p_procedure_name => 'INSERT_FP_ROWS');
7866: RAISE;
7867: END;
7868:

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

8014: , CURRENCY_CODE;
8015:
8016: EXCEPTION
8017: WHEN OTHERS THEN
8018: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
8019: p_procedure_name => 'INSERT_INTO_AC_FACT');
8020: RAISE;
8021: END;
8022:

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

8033: INSERT_AC_ROWS;
8034:
8035: EXCEPTION
8036: WHEN OTHERS THEN
8037: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
8038: p_procedure_name => 'MERGE_INTO_AC_FACT');
8039: RAISE;
8040: END;
8041:

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

8047: WHERE worker_id = g_worker_id;
8048:
8049: EXCEPTION
8050: WHEN OTHERS THEN
8051: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
8052: p_procedure_name => 'CLEANUP_AC_RMAP_FPR');
8053: RAISE;
8054: END;
8055:

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

8085: AND tmp.CURRENCY_CODE = rl.CURRENCY_CODE (+) ;
8086:
8087: EXCEPTION
8088: WHEN OTHERS THEN
8089: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
8090: p_procedure_name => 'GET_AC_ROW_IDS');
8091: RAISE;
8092: END;
8093:

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

8224: AND rwid.worker_id = g_worker_id);
8225:
8226: EXCEPTION
8227: WHEN OTHERS THEN
8228: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
8229: p_procedure_name => 'UPDATE_AC_ROWS');
8230: RAISE;
8231: END;
8232:

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

8383: , CURRENCY_CODE;
8384:
8385: EXCEPTION
8386: WHEN OTHERS THEN
8387: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
8388: p_procedure_name => 'INSERT_AC_ROWS');
8389: RAISE;
8390: END;
8391:

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

8430: );
8431:
8432: EXCEPTION
8433: WHEN OTHERS THEN
8434: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
8435: p_procedure_name => 'MARK_DANGLING_PLAN_VERSIONS');
8436: RAISE;
8437: END;
8438:

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

8480: -- END LOOP;
8481:
8482: EXCEPTION
8483: WHEN OTHERS THEN
8484: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
8485: p_procedure_name => 'PULL_DANGLING_PLANS');
8486: RAISE;
8487: END;
8488:

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

8649: );
8650:
8651: EXCEPTION
8652: WHEN OTHERS THEN
8653: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
8654: p_procedure_name => 'RETRIEVE_ENTERED_SLICE');
8655: RAISE;
8656: END;
8657:

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

8854:
8855:
8856: EXCEPTION
8857: WHEN OTHERS THEN
8858: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
8859: p_procedure_name => 'ROLLUP_FPR_RBS');
8860: RAISE;
8861: END;
8862:

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

9050:
9051:
9052: EXCEPTION
9053: WHEN OTHERS THEN
9054: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
9055: p_procedure_name => 'ROLLUP_FPR_RBS_T_SLICE');
9056: RAISE;
9057: END;
9058:

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

9061: BEGIN
9062: NULL;
9063: EXCEPTION
9064: WHEN OTHERS THEN
9065: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
9066: p_procedure_name => 'COMPUTE_XBS_UPDATED_ROLLUPS');
9067: RAISE;
9068: END;
9069:

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

9162:
9163: EXCEPTION
9164: WHEN OTHERS THEN
9165: print_time ( ' update rbs header exception ' || sqlerrm );
9166: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
9167: p_procedure_name => 'POPULATE_RBS_HDR');
9168: RAISE;
9169: END;
9170:

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

9233:
9234: EXCEPTION
9235: WHEN OTHERS THEN
9236: print_time ( ' populate wbs header exception ' || sqlerrm );
9237: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
9238: p_procedure_name => 'POPULATE_WBS_HDR');
9239: RAISE;
9240: END;
9241:

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

9290:
9291: EXCEPTION
9292: WHEN OTHERS THEN
9293: print_time ( ' update wbs header exception ' || sqlerrm );
9294: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
9295: p_procedure_name => 'POPULATE_WBS_HDR');
9296: RAISE;
9297: END;
9298:

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

9330: AND TO_NUMBER(TO_CHAR(time.end_date, 'J')) > pa_calendar_max_date);
9331:
9332: EXCEPTION
9333: WHEN OTHERS THEN
9334: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
9335: p_procedure_name => 'MARK_TIME_DANGLING_VERSIONS');
9336: RAISE;
9337: END;
9338:

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

9463: END IF;
9464:
9465: EXCEPTION
9466: WHEN OTHERS THEN
9467: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
9468: p_procedure_name => 'MARK_EXTRACTED_PLANS');
9469: RAISE;
9470: END;
9471:

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

9494:
9495: EXCEPTION
9496: WHEN OTHERS THEN
9497: print_time('... Exception CREATE_WBSRLP ' );
9498: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
9499: p_procedure_name => 'CREATE_WBSRLP');
9500: RAISE;
9501: END;
9502:

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

9588:
9589: EXCEPTION
9590: WHEN OTHERS THEN
9591: print_time('.......CLEANUP_INTERIM_TABLES: Exception. ' || sqlerrm);
9592: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
9593: p_procedure_name => 'CLEANUP_INTERIM_TABLES');
9594: RAISE;
9595: END CLEANUP_INTERIM_TABLES;
9596:

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

9678: print_time (' INSERT_NTP_CAL_RECORD, # rows inserted is: ' || SQL%ROWCOUNT );
9679:
9680: EXCEPTION
9681: WHEN OTHERS THEN
9682: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
9683: p_procedure_name => 'INSERT_NTP_CAL_RECORD');
9684: RAISE;
9685: END;
9686:

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

9696: print_time (' DELETE_NTP_CAL_RECORD, # rows deleted is: ' || SQL%ROWCOUNT );
9697:
9698: EXCEPTION
9699: WHEN OTHERS THEN
9700: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
9701: p_procedure_name => 'DELETE_NTP_CAL_RECORD');
9702: RAISE;
9703: END;
9704:

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

9785:
9786: EXCEPTION
9787: WHEN OTHERS THEN
9788: print_time('MAP_ORG_CAL_INFO : exception.. ');
9789: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
9790: p_procedure_name => 'MAP_ORG_CAL_INFO');
9791: RAISE;
9792: END;
9793:

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

9799: BEGIN
9800: PJI_PJP_FP_CURR_WRAP.print_time(p_tag);
9801: EXCEPTION
9802: WHEN OTHERS THEN
9803: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
9804: p_procedure_name => 'PRINT_TIME');
9805: RAISE;
9806: END;
9807: