243:
244: EXCEPTION
245:
246: WHEN OTHERS THEN
247: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
248: THEN
249: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME
250: , 'Insert_Rpt_Data'
251: );
245:
246: WHEN OTHERS THEN
247: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
248: THEN
249: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME
250: , 'Insert_Rpt_Data'
251: );
252: END IF;
253: RAISE;
332:
333: WHEN acct_period_not_found_exc THEN
334: FND_MESSAGE.Set_Name('BOM', 'CST_MGD_INFL_ACCT_PER_ID_INVBK');
335:
336: FND_MSG_PUB.Add;
337: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
338: THEN
339: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME
340: , 'Get_Acct_Period_ID_invmbk'
333: WHEN acct_period_not_found_exc THEN
334: FND_MESSAGE.Set_Name('BOM', 'CST_MGD_INFL_ACCT_PER_ID_INVBK');
335:
336: FND_MSG_PUB.Add;
337: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
338: THEN
339: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME
340: , 'Get_Acct_Period_ID_invmbk'
341: );
335:
336: FND_MSG_PUB.Add;
337: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
338: THEN
339: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME
340: , 'Get_Acct_Period_ID_invmbk'
341: );
342: END IF;
343: RAISE ;
343: RAISE ;
344:
345:
346: WHEN OTHERS THEN
347: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
348: THEN
349: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME
350: , 'Get_Acct_Period_ID_invmbk'
351: );
345:
346: WHEN OTHERS THEN
347: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
348: THEN
349: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME
350: , 'Get_Acct_Period_ID_invmbk'
351: );
352: END IF;
353: RAISE;
435: EXCEPTION
436:
437: WHEN acct_period_not_found_exc THEN
438: FND_MESSAGE.Set_Name('BOM', 'CST_MGD_INFL_ND_ACCT_PER_ID');
439: FND_MSG_PUB.Add;
440: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
441: THEN
442: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME
443: , 'Get_Acct_Period_ID'
436:
437: WHEN acct_period_not_found_exc THEN
438: FND_MESSAGE.Set_Name('BOM', 'CST_MGD_INFL_ND_ACCT_PER_ID');
439: FND_MSG_PUB.Add;
440: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
441: THEN
442: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME
443: , 'Get_Acct_Period_ID'
444: );
438: FND_MESSAGE.Set_Name('BOM', 'CST_MGD_INFL_ND_ACCT_PER_ID');
439: FND_MSG_PUB.Add;
440: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
441: THEN
442: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME
443: , 'Get_Acct_Period_ID'
444: );
445: END IF;
446: RAISE ;
446: RAISE ;
447:
448:
449: WHEN OTHERS THEN
450: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
451: THEN
452: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME
453: , 'Get_Acct_Period_ID'
454: );
448:
449: WHEN OTHERS THEN
450: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
451: THEN
452: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME
453: , 'Get_Acct_Period_ID'
454: );
455: END IF;
456: RAISE;
505:
506: EXCEPTION
507:
508: WHEN OTHERS THEN
509: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
510: THEN
511: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME
512: , 'Get_Unit_Infl_Adj_Cost'
513: );
507:
508: WHEN OTHERS THEN
509: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
510: THEN
511: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME
512: , 'Get_Unit_Infl_Adj_Cost'
513: );
514: END IF;
515: RAISE;
543: -- AND NVL(Disable_Date, SYSDATE + 1) > SYSDATE;
544:
545: EXCEPTION
546: WHEN OTHERS THEN
547: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
548: THEN
549: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME
550: , 'Get_Txn_Type'
551: );
545: EXCEPTION
546: WHEN OTHERS THEN
547: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
548: THEN
549: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME
550: , 'Get_Txn_Type'
551: );
552: END IF;
553: RAISE;
917: EXCEPTION
918:
919: WHEN l_txn_cost_exc THEN
920: FND_MESSAGE.Set_Name('BOM', 'CST_MGD_INFL_UNIT_COST_NULL');
921: FND_MSG_PUB.Add;
922: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
923: THEN
924: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME
925: , 'Get_Item_Txn_Info'
918:
919: WHEN l_txn_cost_exc THEN
920: FND_MESSAGE.Set_Name('BOM', 'CST_MGD_INFL_UNIT_COST_NULL');
921: FND_MSG_PUB.Add;
922: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
923: THEN
924: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME
925: , 'Get_Item_Txn_Info'
926: );
920: FND_MESSAGE.Set_Name('BOM', 'CST_MGD_INFL_UNIT_COST_NULL');
921: FND_MSG_PUB.Add;
922: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
923: THEN
924: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME
925: , 'Get_Item_Txn_Info'
926: );
927: END IF;
928: RAISE g_txn_cost_exc;
926: );
927: END IF;
928: RAISE g_txn_cost_exc;
929: WHEN OTHERS THEN
930: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
931: THEN
932: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME
933: , 'Get_Item_Txn_Info'
934: );
928: RAISE g_txn_cost_exc;
929: WHEN OTHERS THEN
930: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
931: THEN
932: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME
933: , 'Get_Item_Txn_Info'
934: );
935: END IF;
936: RAISE;
1405: END LOOP;
1406:
1407: EXCEPTION
1408: WHEN cost_method_not_found_except THEN
1409: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1410: THEN
1411: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME
1412: , 'Create_Inv_Msbk_Rpt' || ' Cost Method Not Found'
1413: );
1407: EXCEPTION
1408: WHEN cost_method_not_found_except THEN
1409: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1410: THEN
1411: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME
1412: , 'Create_Inv_Msbk_Rpt' || ' Cost Method Not Found'
1413: );
1414: END IF;
1415: RAISE;
1414: END IF;
1415: RAISE;
1416:
1417: WHEN OTHERS THEN
1418: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1419: THEN
1420: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME
1421: , 'Create_Inv_Msbk_Rpt'
1422: );
1416:
1417: WHEN OTHERS THEN
1418: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1419: THEN
1420: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME
1421: , 'Create_Inv_Msbk_Rpt'
1422: );
1423: END IF;
1424: RAISE;