DBA Data[Home] [Help]

APPS.PJI_FM_PLAN_MAINT_PVT dependencies on FND_MSG_PUB

Line 1606: Fnd_Msg_Pub.add_detail(p_message_type=>Fnd_Api.G_RET_STS_ERROR);

1602:
1603: -- PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PJI'
1604: -- , p_msg_name => 'PJI_LOCK_NOT_OBTAINED');
1605: Fnd_Message.SET_NAME('PJI', 'PJI_LOCK_NOT_OBTAINED');
1606: Fnd_Msg_Pub.add_detail(p_message_type=>Fnd_Api.G_RET_STS_ERROR);
1607:
1608: print_time ( ' UPDATE_LOCKS exception ' || SQLERRM);
1609:
1610: Pji_Pjp_Fp_Curr_Wrap.EXCP_HANDLER

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

2802:
2803: EXCEPTION
2804: WHEN OTHERS THEN
2805:
2806: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
2807: p_procedure_name => 'EXTRACT_FIN_PLAN_VERS_BULK');
2808: print_time('EXTRACT_FIN_PLAN_VERS_BULK : Exception: ' || sqlerrm );
2809: RAISE;
2810: END;

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

3087:
3088: EXCEPTION
3089: WHEN OTHERS THEN
3090: print_time('EXTRACT_FIN_PLAN_VERSIONS : Exception: ' || sqlerrm );
3091: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
3092: p_procedure_name => 'EXTRACT_FIN_PLAN_VERSIONS');
3093: RAISE;
3094: END;
3095:

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

3608: EXCEPTION
3609: WHEN OTHERS THEN
3610: print_time('EXTRACT_PLAN_AMOUNTS_PRIRBS : Exception ' || SQLERRM );
3611: print_time('EXTRACT_PLAN_AMOUNTS_PRIRBS : Begin worker id is ... ' || 1);
3612: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
3613: p_procedure_name => 'EXTRACT_PLAN_AMOUNTS_PRIRBS');
3614: RAISE;
3615: END;
3616:

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

4571: END IF;
4572:
4573: EXCEPTION
4574: WHEN OTHERS THEN
4575: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
4576: p_procedure_name => 'INSERT_INTO_FP_FACT');
4577: RAISE;
4578: END;
4579:

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

4759:
4760:
4761: EXCEPTION
4762: WHEN OTHERS THEN
4763: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
4764: p_procedure_name => 'GET_PRI_SLICE_DATA');
4765: RAISE;
4766: END;
4767:

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

4840: print_time('........POPULATE_PLN_VER_TABLE : End.' );
4841:
4842: EXCEPTION
4843: WHEN OTHERS THEN
4844: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
4845: p_procedure_name => 'POPULATE_PLN_VER_TABLE');
4846: print_time('........POPULATE_PLN_VER_TABLE : Exception: ' || sqlerrm );
4847: RAISE;
4848: END;

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

5026: print_time('........GET_GLOBAL_EXCHANGE_RATES: End. # rows inserted is: ' || SQL%ROWCOUNT );
5027:
5028: EXCEPTION
5029: WHEN OTHERS THEN
5030: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
5031: p_procedure_name => 'GET_GLOBAL_EXCHANGE_RATES');
5032: print_time('........GET_GLOBAL_EXCHANGE_RATES: Exception: ' || sqlerrm );
5033: RAISE;
5034: END;

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

5045: print_time('........DELETE_GLOBAL_EXCHANGE_RATES: End. # rows is.. ' || SQL%ROWCOUNT );
5046:
5047: EXCEPTION
5048: WHEN OTHERS THEN
5049: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
5050: p_procedure_name => 'DELETE_GLOBAL_EXCHANGE_RATES');
5051: print_time('........DELETE_GLOBAL_EXCHANGE_RATES: Exception: ' || sqlerrm );
5052: RAISE;
5053: END;

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

5067:
5068: EXCEPTION
5069: WHEN OTHERS THEN
5070: print_time('........CONV_TO_GLOBAL_CURRENCIES: Exception ' || sqlerrm );
5071: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
5072: p_procedure_name => 'CONV_TO_GLOBAL_CURRENCIES');
5073: RAISE;
5074: END;
5075:

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

5087: AND worker_id = g_worker_id;
5088:
5089: EXCEPTION
5090: WHEN OTHERS THEN
5091: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
5092: p_procedure_name => 'DELETE_DNGLRATE_PLNVER_DATA');
5093: RAISE;
5094: END;
5095:

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

5101: NULL; -- Rate dangling check already done in get global exchange rates.
5102:
5103: EXCEPTION
5104: WHEN OTHERS THEN
5105: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
5106: p_procedure_name => 'DO_CURRENCY_DANGLING_CHECK');
5107: RAISE;
5108: END;
5109:

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

5114: NULL;
5115:
5116: EXCEPTION
5117: WHEN OTHERS THEN
5118: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
5119: p_procedure_name => 'GET_PRORATE_FORMAT');
5120: RAISE;
5121: END;
5122:

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

5127: NULL;
5128:
5129: EXCEPTION
5130: WHEN OTHERS THEN
5131: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
5132: p_procedure_name => 'GET_SPREAD_DATE_RANGE_AMOUNTS');
5133: RAISE;
5134: END;
5135:

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

5140: NULL;
5141:
5142: EXCEPTION
5143: WHEN OTHERS THEN
5144: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
5145: p_procedure_name => 'SPREAD_NON_TIME_PHASE_AMOUNTS');
5146: RAISE;
5147: END;
5148:

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

5187: END IF;
5188:
5189: EXCEPTION
5190: WHEN OTHERS THEN
5191: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
5192: p_procedure_name => 'PRORATE_TO_OTHER_CALENDAR');
5193: RAISE;
5194: END;
5195:

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

5201: PRORATE('PA');
5202:
5203: EXCEPTION
5204: WHEN OTHERS THEN
5205: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
5206: p_procedure_name => 'PRORATE_TO_PA');
5207: RAISE;
5208: END;
5209:

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

5215: PRORATE('GL');
5216:
5217: EXCEPTION
5218: WHEN OTHERS THEN
5219: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
5220: p_procedure_name => 'PRORATE_TO_GL');
5221: RAISE;
5222: END;
5223:

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

5255: AND baselined_flag = 'Y'
5256: AND worker_id = g_worker_id; -- Not raising any exception as we want the processing to happen properly.
5257: WHEN OTHERS THEN
5258: print_time('PRORATE_TO_ALL_CALENDARS: Exception.. ' || sqlerrm);
5259: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
5260: p_procedure_name => 'PRORATE_TO_ALL_CALENDARS');
5261: RAISE;
5262: END;
5263:

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

5301: END IF;
5302:
5303: EXCEPTION
5304: WHEN OTHERS THEN
5305: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
5306: p_procedure_name => 'PRORATE_TO_ENT');
5307: RAISE;
5308: END;
5309:

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

5362: END IF;
5363:
5364: EXCEPTION
5365: WHEN OTHERS THEN
5366: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
5367: p_procedure_name => 'PRORATE');
5368: RAISE;
5369: END;
5370:

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

5384:
5385: EXCEPTION
5386: WHEN OTHERS THEN
5387: print_time ( ' MERGE_INTO_FP_FACT 6 ' ) ;
5388: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
5389: p_procedure_name => 'MERGE_INTO_FP_FACT');
5390: RAISE;
5391: END;
5392:

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

5403:
5404: EXCEPTION
5405: WHEN OTHERS THEN
5406: print_time ( 'ccc' || sqlerrm );
5407: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
5408: p_procedure_name => 'CLEANUP_FP_RMAP_FPR');
5409: RAISE;
5410: END;
5411:

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

5472: print_time ( ' MERGE_INTO_FP_FACT 1.1 ' || SQL%ROWCOUNT ) ;
5473:
5474: EXCEPTION
5475: WHEN OTHERS THEN
5476: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
5477: p_procedure_name => 'GET_FP_ROW_IDS');
5478: RAISE;
5479: END;
5480:

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

5705:
5706:
5707: EXCEPTION
5708: WHEN OTHERS THEN
5709: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
5710: p_procedure_name => 'UPDATE_FP_ROWS');
5711: RAISE;
5712: END;
5713:

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

5984:
5985:
5986: EXCEPTION
5987: WHEN OTHERS THEN
5988: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
5989: p_procedure_name => 'INSERT_FP_ROWS');
5990: RAISE;
5991: END;
5992:

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

6138: , CURRENCY_CODE;
6139:
6140: EXCEPTION
6141: WHEN OTHERS THEN
6142: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
6143: p_procedure_name => 'INSERT_INTO_AC_FACT');
6144: RAISE;
6145: END;
6146:

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

6157: CLEANUP_AC_RMAP_FPR;
6158:
6159: EXCEPTION
6160: WHEN OTHERS THEN
6161: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
6162: p_procedure_name => 'MERGE_INTO_AC_FACT');
6163: RAISE;
6164: END;
6165:

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

6171: WHERE worker_id = g_worker_id;
6172:
6173: EXCEPTION
6174: WHEN OTHERS THEN
6175: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
6176: p_procedure_name => 'CLEANUP_AC_RMAP_FPR');
6177: RAISE;
6178: END;
6179:

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

6209: AND tmp.CURRENCY_CODE = rl.CURRENCY_CODE (+) ;
6210:
6211: EXCEPTION
6212: WHEN OTHERS THEN
6213: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
6214: p_procedure_name => 'GET_AC_ROW_IDS');
6215: RAISE;
6216: END;
6217:

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

6348: AND rwid.worker_id = g_worker_id);
6349:
6350: EXCEPTION
6351: WHEN OTHERS THEN
6352: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
6353: p_procedure_name => 'UPDATE_AC_ROWS');
6354: RAISE;
6355: END;
6356:

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

6507: , CURRENCY_CODE;
6508:
6509: EXCEPTION
6510: WHEN OTHERS THEN
6511: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
6512: p_procedure_name => 'INSERT_AC_ROWS');
6513: RAISE;
6514: END;
6515:

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

6553: );
6554:
6555: EXCEPTION
6556: WHEN OTHERS THEN
6557: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
6558: p_procedure_name => 'MARK_DANGLING_PLAN_VERSIONS');
6559: RAISE;
6560: END;
6561:

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

6584: NULL; -- Pull dangling calls bulk "create secondary private" directly.
6585:
6586: EXCEPTION
6587: WHEN OTHERS THEN
6588: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
6589: p_procedure_name => 'PULL_DANGLING_PLANS');
6590: RAISE;
6591: END;
6592:

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

6753: );
6754:
6755: EXCEPTION
6756: WHEN OTHERS THEN
6757: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
6758: p_procedure_name => 'RETRIEVE_ENTERED_SLICE');
6759: RAISE;
6760: END;
6761:

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

6958:
6959:
6960: EXCEPTION
6961: WHEN OTHERS THEN
6962: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
6963: p_procedure_name => 'ROLLUP_FPR_RBS');
6964: RAISE;
6965: END;
6966:

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

7155:
7156:
7157: EXCEPTION
7158: WHEN OTHERS THEN
7159: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
7160: p_procedure_name => 'ROLLUP_FPR_RBS_T_SLICE');
7161: RAISE;
7162: END;
7163:

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

7166: BEGIN
7167: NULL;
7168: EXCEPTION
7169: WHEN OTHERS THEN
7170: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
7171: p_procedure_name => 'COMPUTE_XBS_UPDATED_ROLLUPS');
7172: RAISE;
7173: END;
7174:

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

7230:
7231: EXCEPTION
7232: WHEN OTHERS THEN
7233: print_time ( ' update rbs header exception ' || sqlerrm );
7234: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
7235: p_procedure_name => 'POPULATE_RBS_HDR');
7236: RAISE;
7237: END;
7238:

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

7303:
7304: EXCEPTION
7305: WHEN OTHERS THEN
7306: print_time ( ' Populate wbs header exception ' || sqlerrm );
7307: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
7308: p_procedure_name => 'POPULATE_WBS_HDR');
7309: RAISE;
7310: END;
7311:

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

7383:
7384: EXCEPTION
7385: WHEN OTHERS THEN
7386: print_time ( ' update wbs header exception ' || sqlerrm );
7387: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
7388: p_procedure_name => 'POPULATE_WBS_HDR');
7389: RAISE;
7390: END;
7391:

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

7459: END IF;
7460:
7461: EXCEPTION
7462: WHEN OTHERS THEN
7463: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
7464: p_procedure_name => 'MARK_EXTRACTED_PLANS');
7465: RAISE;
7466: END;
7467:

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

7489:
7490: EXCEPTION
7491: WHEN OTHERS THEN
7492: print_time('... Exception CREATE_WBSRLP ' );
7493: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
7494: p_procedure_name => 'CREATE_WBSRLP');
7495: RAISE;
7496: END;
7497:

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

7585:
7586: EXCEPTION
7587: WHEN OTHERS THEN
7588: print_time('.......CLEANUP_INTERIM_TABLES: Exception. ' || sqlerrm);
7589: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
7590: p_procedure_name => 'CLEANUP_INTERIM_TABLES');
7591: RAISE;
7592: END CLEANUP_INTERIM_TABLES;
7593:

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

7599: BEGIN
7600: PJI_PJP_FP_CURR_WRAP.print_time(p_tag);
7601: EXCEPTION
7602: WHEN OTHERS THEN
7603: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
7604: p_procedure_name => 'PRINT_TIME');
7605: RAISE;
7606: END;
7607:

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

8763:
8764: EXCEPTION
8765: WHEN OTHERS THEN
8766: print_time('EXTRACT_PLAN_AMOUNTS_SECRBS : Exception ' || SQLERRM );
8767: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
8768: p_procedure_name => 'EXTRACT_PLAN_AMTS_SECRBS_GLC12');
8769: RAISE;
8770: END;
8771:

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

9897: print_time ( ' EXTRACT_PLAN_AMTS_PRIRBS_GLC12 end. Inserted rows # is: ' || SQL%ROWCOUNT );
9898: EXCEPTION
9899: WHEN OTHERS THEN
9900: print_time('EXTRACT_PLAN_AMTS_PRIRBS_GLC12 : Exception ' || SQLERRM );
9901: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
9902: p_procedure_name => 'EXTRACT_PLAN_AMTS_PRIRBS_GLC12');
9903: RAISE;
9904: END;
9905:

Line 10094: Fnd_Msg_Pub.add_exc_msg( p_pkg_name => g_package_name ,

10090:
10091: EXCEPTION
10092: WHEN OTHERS THEN
10093: print_time(' EXTRACT_DANGL_REVERSAL : Exception ' || SQLERRM );
10094: Fnd_Msg_Pub.add_exc_msg( p_pkg_name => g_package_name ,
10095: p_procedure_name => 'EXTRACT_DANGL_REVERSAL');
10096: RAISE;
10097:
10098: END;

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

10542: DELETE_NTP_CAL_RECORD ( p_max_project_id => l_max_project_id );
10543:
10544: EXCEPTION
10545: WHEN OTHERS THEN
10546: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
10547: p_procedure_name => 'EXTRACT_ACTUALS');
10548: RAISE;
10549: END;
10550:

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

10613: print_time (' INSERT_NTP_CAL_RECORD, # rows inserted is: ' || SQL%ROWCOUNT );
10614:
10615: EXCEPTION
10616: WHEN OTHERS THEN
10617: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
10618: p_procedure_name => 'INSERT_NTP_CAL_RECORD');
10619: RAISE;
10620: END;
10621:

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

10631: print_time (' DELETE_NTP_CAL_RECORD, # rows deleted is: ' || SQL%ROWCOUNT );
10632:
10633: EXCEPTION
10634: WHEN OTHERS THEN
10635: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
10636: p_procedure_name => 'DELETE_NTP_CAL_RECORD');
10637: RAISE;
10638: END;
10639:

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

11653: close c1;
11654:
11655: EXCEPTION
11656: WHEN OTHERS THEN
11657: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,
11658: p_procedure_name => 'MERGE_INTO_FP_FACTS');
11659: RAISE;
11660: END MERGE_INTO_FP_FACTS;
11661: