eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CST_PAC_ITERATION_PROCESS_PVT dependencies on FND_API

Line 811: WHEN FND_API.G_EXC_ERROR THEN

807: );
808: END IF;
809:
810: EXCEPTION
811: WHEN FND_API.G_EXC_ERROR THEN
812: RAISE FND_API.G_EXC_ERROR;
813: WHEN OTHERS THEN
814: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
815: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION

Line 812: RAISE FND_API.G_EXC_ERROR;

808: END IF;
809:
810: EXCEPTION
811: WHEN FND_API.G_EXC_ERROR THEN
812: RAISE FND_API.G_EXC_ERROR;
813: WHEN OTHERS THEN
814: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
815: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION
816: , G_MODULE_HEAD || l_routine ||'.others_exc'

Line 824: RAISE FND_API.G_EXC_ERROR;

820: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_ERROR');
821: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
822: FND_MESSAGE.set_token('MESSAGE', 'txn_id '|| p_transaction_id || 'Opp Txn_id '||p_opp_transaction_id || '('||SQLCODE||') '||SQLERRM);
823: FND_MSG_PUB.Add;
824: RAISE FND_API.G_EXC_ERROR;
825:
826: END; -- Get correspond actual cost
827:
828: -- +========================================================================+

Line 1139: WHEN FND_API.G_EXC_ERROR THEN

1135: END LOOP; -- FETCH loop
1136: CLOSE pac_interorg_txns_cur;
1137:
1138: EXCEPTION
1139: WHEN FND_API.G_EXC_ERROR THEN
1140: RAISE FND_API.G_EXC_ERROR;
1141: WHEN OTHERS THEN
1142:
1143: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 1140: RAISE FND_API.G_EXC_ERROR;

1136: CLOSE pac_interorg_txns_cur;
1137:
1138: EXCEPTION
1139: WHEN FND_API.G_EXC_ERROR THEN
1140: RAISE FND_API.G_EXC_ERROR;
1141: WHEN OTHERS THEN
1142:
1143: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1144: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION

Line 1153: RAISE FND_API.G_EXC_ERROR;

1149: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_ERROR');
1150: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
1151: FND_MESSAGE.set_token('MESSAGE', 'Item_id' ||p_inventory_item_id ||'('||SQLCODE||') '||SQLERRM);
1152: FND_MSG_PUB.Add;
1153: RAISE FND_API.G_EXC_ERROR;
1154:
1155: END; -- Balance pac txn
1156:
1157: -- ==========================================================================

Line 1627: WHEN FND_API.G_EXC_ERROR THEN

1623: , '<< CST_PERIODIC_ABSORPTION_PROC:Calc_Pmac_For_Interorg'
1624: );
1625:
1626: EXCEPTION
1627: WHEN FND_API.G_EXC_ERROR THEN
1628: RAISE FND_API.G_EXC_ERROR;
1629: WHEN OTHERS THEN
1630: ROLLBACK;
1631: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_ERROR');

Line 1628: RAISE FND_API.G_EXC_ERROR;

1624: );
1625:
1626: EXCEPTION
1627: WHEN FND_API.G_EXC_ERROR THEN
1628: RAISE FND_API.G_EXC_ERROR;
1629: WHEN OTHERS THEN
1630: ROLLBACK;
1631: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_ERROR');
1632: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);

Line 1635: RAISE FND_API.G_EXC_ERROR;

1631: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_ERROR');
1632: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
1633: FND_MESSAGE.set_token('MESSAGE', '('||SQLCODE||') '||SQLERRM);
1634: FND_MSG_PUB.Add;
1635: RAISE FND_API.G_EXC_ERROR;
1636: END Calc_Pmac_For_Interorg;
1637:
1638:
1639: --=====================================================================================

Line 1837: WHEN FND_API.G_EXC_ERROR THEN

1833: END IF;
1834:
1835:
1836: EXCEPTION
1837: WHEN FND_API.G_EXC_ERROR THEN
1838: RAISE FND_API.G_EXC_ERROR;
1839: WHEN OTHERS THEN
1840: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_ERROR');
1841: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);

Line 1838: RAISE FND_API.G_EXC_ERROR;

1834:
1835:
1836: EXCEPTION
1837: WHEN FND_API.G_EXC_ERROR THEN
1838: RAISE FND_API.G_EXC_ERROR;
1839: WHEN OTHERS THEN
1840: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_ERROR');
1841: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
1842: FND_MESSAGE.set_token('MESSAGE', '('||SQLCODE||') '||SQLERRM);

Line 1844: RAISE FND_API.G_EXC_ERROR;

1840: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_ERROR');
1841: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
1842: FND_MESSAGE.set_token('MESSAGE', '('||SQLCODE||') '||SQLERRM);
1843: FND_MSG_PUB.Add;
1844: RAISE FND_API.G_EXC_ERROR;
1845: END Calc_Pmac_Update_Cppb;
1846:
1847: -- +========================================================================+
1848: -- PROCEDURE: Create_Mpacd_With_New_Values PRIVATE UTILITY

Line 1943: WHEN FND_API.G_EXC_ERROR THEN

1939: );
1940: END IF;
1941:
1942: EXCEPTION
1943: WHEN FND_API.G_EXC_ERROR THEN
1944: RAISE FND_API.G_EXC_ERROR;
1945: WHEN OTHERS THEN
1946: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1947: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION

Line 1944: RAISE FND_API.G_EXC_ERROR;

1940: END IF;
1941:
1942: EXCEPTION
1943: WHEN FND_API.G_EXC_ERROR THEN
1944: RAISE FND_API.G_EXC_ERROR;
1945: WHEN OTHERS THEN
1946: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1947: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION
1948: , G_MODULE_HEAD || l_routine ||'.others_exc'

Line 1956: RAISE FND_API.G_EXC_ERROR;

1952: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_ERROR');
1953: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
1954: FND_MESSAGE.set_token('MESSAGE', '('||SQLCODE||') '||SQLERRM);
1955: FND_MSG_PUB.Add;
1956: RAISE FND_API.G_EXC_ERROR;
1957:
1958: END; -- Create Mpacd With New Values
1959:
1960:

Line 2232: WHEN FND_API.G_EXC_ERROR THEN

2228: );
2229: END IF;
2230:
2231: EXCEPTION
2232: WHEN FND_API.G_EXC_ERROR THEN
2233: RAISE FND_API.G_EXC_ERROR;
2234: WHEN OTHERS THEN
2235: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2236: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION

Line 2233: RAISE FND_API.G_EXC_ERROR;

2229: END IF;
2230:
2231: EXCEPTION
2232: WHEN FND_API.G_EXC_ERROR THEN
2233: RAISE FND_API.G_EXC_ERROR;
2234: WHEN OTHERS THEN
2235: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2236: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION
2237: , G_MODULE_HEAD || l_routine ||'.others_exc'

Line 2245: RAISE FND_API.G_EXC_ERROR;

2241: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_ERROR');
2242: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
2243: FND_MESSAGE.set_token('MESSAGE', '('||SQLCODE||') '||SQLERRM);
2244: FND_MSG_PUB.Add;
2245: RAISE FND_API.G_EXC_ERROR;
2246:
2247: END; -- Update Cpicd With New Values
2248:
2249:

Line 2330: WHEN FND_API.G_EXC_ERROR THEN

2326: );
2327: END IF;
2328:
2329: EXCEPTION
2330: WHEN FND_API.G_EXC_ERROR THEN
2331: RAISE FND_API.G_EXC_ERROR;
2332: WHEN OTHERS THEN
2333: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2334: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION

Line 2331: RAISE FND_API.G_EXC_ERROR;

2327: END IF;
2328:
2329: EXCEPTION
2330: WHEN FND_API.G_EXC_ERROR THEN
2331: RAISE FND_API.G_EXC_ERROR;
2332: WHEN OTHERS THEN
2333: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2334: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION
2335: , G_MODULE_HEAD || l_routine ||'.others_exc'

Line 2343: RAISE FND_API.G_EXC_ERROR;

2339: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_ERROR');
2340: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
2341: FND_MESSAGE.set_token('MESSAGE', '('||SQLCODE||') '||SQLERRM);
2342: FND_MSG_PUB.Add;
2343: RAISE FND_API.G_EXC_ERROR;
2344:
2345: END; -- Set_Phase5_Status
2346:
2347:

Line 2452: WHEN FND_API.G_EXC_ERROR THEN

2448: );
2449: END IF;
2450:
2451: EXCEPTION
2452: WHEN FND_API.G_EXC_ERROR THEN
2453: RAISE FND_API.G_EXC_ERROR;
2454: WHEN OTHERS THEN
2455: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2456: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION

Line 2453: RAISE FND_API.G_EXC_ERROR;

2449: END IF;
2450:
2451: EXCEPTION
2452: WHEN FND_API.G_EXC_ERROR THEN
2453: RAISE FND_API.G_EXC_ERROR;
2454: WHEN OTHERS THEN
2455: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2456: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION
2457: , G_MODULE_HEAD || l_routine ||'.others_exc'

Line 2465: RAISE FND_API.G_EXC_ERROR;

2461: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_ERROR');
2462: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
2463: FND_MESSAGE.set_token('MESSAGE', '('||SQLCODE||') '||SQLERRM);
2464: FND_MSG_PUB.Add;
2465: RAISE FND_API.G_EXC_ERROR;
2466: END; -- Set_Process_Status
2467:
2468:
2469: -- +============================================================================+

Line 2640: WHEN FND_API.G_EXC_ERROR THEN

2636:
2637: END IF;
2638:
2639: EXCEPTION
2640: WHEN FND_API.G_EXC_ERROR THEN
2641: RAISE FND_API.G_EXC_ERROR;
2642: WHEN OTHERS THEN
2643: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2644: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION

Line 2641: RAISE FND_API.G_EXC_ERROR;

2637: END IF;
2638:
2639: EXCEPTION
2640: WHEN FND_API.G_EXC_ERROR THEN
2641: RAISE FND_API.G_EXC_ERROR;
2642: WHEN OTHERS THEN
2643: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2644: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION
2645: , G_MODULE_HEAD || l_routine ||'.others_exc'

Line 2653: RAISE FND_API.G_EXC_ERROR;

2649: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_ERROR');
2650: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
2651: FND_MESSAGE.set_token('MESSAGE', 'Item_id'||p_inventory_item_id ||'Iteration Number' ||p_iteration_num ||'('||SQLCODE||') '||SQLERRM);
2652: FND_MSG_PUB.Add;
2653: RAISE FND_API.G_EXC_ERROR;
2654:
2655: END Verify_Tolerance_Of_Item;
2656:
2657: -- +========================================================================+

Line 2792: WHEN FND_API.G_EXC_ERROR THEN

2788: );
2789: END IF;
2790:
2791: EXCEPTION
2792: WHEN FND_API.G_EXC_ERROR THEN
2793: RAISE FND_API.G_EXC_ERROR;
2794: WHEN OTHERS THEN
2795: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2796: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION

Line 2793: RAISE FND_API.G_EXC_ERROR;

2789: END IF;
2790:
2791: EXCEPTION
2792: WHEN FND_API.G_EXC_ERROR THEN
2793: RAISE FND_API.G_EXC_ERROR;
2794: WHEN OTHERS THEN
2795: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2796: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION
2797: , G_MODULE_HEAD || l_routine ||'.others_exc'

Line 2805: RAISE FND_API.G_EXC_ERROR;

2801: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_ERROR');
2802: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
2803: FND_MESSAGE.set_token('MESSAGE', '('||SQLCODE||') '||SQLERRM);
2804: FND_MSG_PUB.Add;
2805: RAISE FND_API.G_EXC_ERROR;
2806:
2807: END Initialize;
2808:
2809: -- +========================================================================+

Line 3228: WHEN FND_API.G_EXC_ERROR THEN

3224: );
3225: END IF;
3226:
3227: EXCEPTION
3228: WHEN FND_API.G_EXC_ERROR THEN
3229: RAISE FND_API.G_EXC_ERROR;
3230: WHEN OTHERS THEN
3231: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3232: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION

Line 3229: RAISE FND_API.G_EXC_ERROR;

3225: END IF;
3226:
3227: EXCEPTION
3228: WHEN FND_API.G_EXC_ERROR THEN
3229: RAISE FND_API.G_EXC_ERROR;
3230: WHEN OTHERS THEN
3231: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3232: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION
3233: , G_MODULE_HEAD || l_routine ||'.others_exc'

Line 3241: RAISE FND_API.G_EXC_ERROR;

3237: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_ERROR');
3238: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
3239: FND_MESSAGE.set_token('MESSAGE', '('||SQLCODE||') '||SQLERRM);
3240: FND_MSG_PUB.Add;
3241: RAISE FND_API.G_EXC_ERROR;
3242:
3243: END Populate_Temp_Tables;
3244:
3245: -- +========================================================================+

Line 3486: WHEN FND_API.G_EXC_ERROR THEN

3482: AND cpiit.INTERORG_RECEIPT_FLAG = 'Y';
3483:
3484:
3485: EXCEPTION
3486: WHEN FND_API.G_EXC_ERROR THEN
3487: RAISE FND_API.G_EXC_ERROR;
3488: WHEN OTHERS THEN
3489:
3490: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_ERROR');

Line 3487: RAISE FND_API.G_EXC_ERROR;

3483:
3484:
3485: EXCEPTION
3486: WHEN FND_API.G_EXC_ERROR THEN
3487: RAISE FND_API.G_EXC_ERROR;
3488: WHEN OTHERS THEN
3489:
3490: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_ERROR');
3491: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);

Line 3494: RAISE FND_API.G_EXC_ERROR;

3490: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_ERROR');
3491: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
3492: FND_MESSAGE.set_token('MESSAGE', '('||SQLCODE||') '||SQLERRM);
3493: FND_MSG_PUB.Add;
3494: RAISE FND_API.G_EXC_ERROR;
3495:
3496: END Retrieve_Interorg_Items;
3497:
3498: -- +========================================================================+

Line 3541: WHEN FND_API.G_EXC_ERROR THEN

3537: and cos1.pac_period_id = Q.pac_period_id)
3538: WHERE cos1.pac_period_id = p_period_id;
3539:
3540: EXCEPTION
3541: WHEN FND_API.G_EXC_ERROR THEN
3542: RAISE FND_API.G_EXC_ERROR;
3543: WHEN OTHERS THEN
3544: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_ERROR');
3545: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);

Line 3542: RAISE FND_API.G_EXC_ERROR;

3538: WHERE cos1.pac_period_id = p_period_id;
3539:
3540: EXCEPTION
3541: WHEN FND_API.G_EXC_ERROR THEN
3542: RAISE FND_API.G_EXC_ERROR;
3543: WHEN OTHERS THEN
3544: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_ERROR');
3545: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
3546: FND_MESSAGE.set_token('MESSAGE', '('||SQLCODE||') '||SQLERRM);

Line 3548: RAISE FND_API.G_EXC_ERROR;

3544: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_ERROR');
3545: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
3546: FND_MESSAGE.set_token('MESSAGE', '('||SQLCODE||') '||SQLERRM);
3547: FND_MSG_PUB.Add;
3548: RAISE FND_API.G_EXC_ERROR;
3549: END Process_Optimal_Sequence;
3550:
3551: -- +========================================================================+
3552: -- PROCEDURE: Get_Balance_Before_Intorg

Line 3665: WHEN FND_API.G_EXC_ERROR THEN

3661: END IF;
3662:
3663:
3664: EXCEPTION
3665: WHEN FND_API.G_EXC_ERROR THEN
3666: RAISE FND_API.G_EXC_ERROR;
3667: WHEN OTHERS THEN
3668: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3669: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION

Line 3666: RAISE FND_API.G_EXC_ERROR;

3662:
3663:
3664: EXCEPTION
3665: WHEN FND_API.G_EXC_ERROR THEN
3666: RAISE FND_API.G_EXC_ERROR;
3667: WHEN OTHERS THEN
3668: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3669: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION
3670: , G_MODULE_HEAD || l_routine ||'.others_exc'

Line 3678: RAISE FND_API.G_EXC_ERROR;

3674: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_ERROR');
3675: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
3676: FND_MESSAGE.set_token('MESSAGE', '('||SQLCODE||') '||SQLERRM);
3677: FND_MSG_PUB.Add;
3678: RAISE FND_API.G_EXC_ERROR;
3679: END Get_Balance_Before_Intorg;
3680:
3681: -- +========================================================================+
3682: -- PROCEDURE: PRIVATE UTILITY

Line 3894: RAISE FND_API.G_EXC_ERROR;

3890: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
3891: FND_MESSAGE.set_token('MESSAGE', 'group1 cost_inv_txn for cost group '|| p_cost_group_id ||' txn id '
3892: || l_group1_interorg_tab(i).transaction_id||' ('||l_error_code||') '||l_error_msg);
3893: FND_MSG_PUB.Add;
3894: RAISE FND_API.G_EXC_ERROR;
3895: END IF;
3896:
3897: -- Insert into MTL_PAC_ACT_CST_DTL_TEMP only if the iteration
3898: -- process flag is enabled with more than 1 iteration

Line 4136: RAISE FND_API.G_EXC_ERROR;

4132: FND_MESSAGE.set_token('MESSAGE', 'CSTPPWAC.update_item_cppb for CG '|| p_cost_group_id ||' txn category '
4133: ||l_txn_category||' t_low_level_code ' ||p_low_level_code
4134: ||' error('||l_error_code||') '||l_error_msg);
4135: FND_MSG_PUB.Add;
4136: RAISE FND_API.G_EXC_ERROR;
4137: END IF;
4138:
4139: CSTPPWAC.update_item_cppb (i_pac_period_id => p_period_id,
4140: i_cost_group_id => p_cost_group_id,

Line 4164: WHEN FND_API.G_EXC_ERROR THEN

4160: AND cost_group_id = p_cost_group_id
4161: AND inventory_item_id = p_inventory_item_id;
4162:
4163: EXCEPTION
4164: WHEN FND_API.G_EXC_ERROR THEN
4165: RAISE FND_API.G_EXC_ERROR;
4166: WHEN OTHERS THEN
4167: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_ERROR');
4168: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);

Line 4165: RAISE FND_API.G_EXC_ERROR;

4161: AND inventory_item_id = p_inventory_item_id;
4162:
4163: EXCEPTION
4164: WHEN FND_API.G_EXC_ERROR THEN
4165: RAISE FND_API.G_EXC_ERROR;
4166: WHEN OTHERS THEN
4167: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_ERROR');
4168: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
4169: FND_MESSAGE.set_token('MESSAGE', '('||SQLCODE||') '||SQLERRM);

Line 4171: RAISE FND_API.G_EXC_ERROR;

4167: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_ERROR');
4168: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
4169: FND_MESSAGE.set_token('MESSAGE', '('||SQLCODE||') '||SQLERRM);
4170: FND_MSG_PUB.Add;
4171: RAISE FND_API.G_EXC_ERROR;
4172: END Group1_Interorg_Iteration1;
4173:
4174: -- +========================================================================+
4175: -- PROCEDURE: PRIVATE UTILITY

Line 4367: RAISE FND_API.G_EXC_ERROR;

4363: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
4364: FND_MESSAGE.set_token('MESSAGE', 'group2 cost_inv_txn for cost group '|| p_cost_group_id ||' txn id '
4365: || l_group2_interorg_tab(i).transaction_id||' ('||l_error_code||') '||l_error_msg);
4366: FND_MSG_PUB.Add;
4367: RAISE FND_API.G_EXC_ERROR;
4368: END IF;
4369:
4370: -- Insert into MTL_PAC_ACT_CST_DTL_TEMP only if the iteration
4371: -- process flag is enabled and consecutive iterations exist

Line 4574: RAISE FND_API.G_EXC_ERROR;

4570: FND_MESSAGE.set_token('MESSAGE', 'CSTPPWAC.update_item_cppb for CG '|| p_cost_group_id ||' txn category '
4571: ||l_txn_category||' t_low_level_code ' ||p_low_level_code
4572: ||' error('||l_error_code||') '||l_error_msg);
4573: FND_MSG_PUB.Add;
4574: RAISE FND_API.G_EXC_ERROR;
4575: END IF;
4576:
4577: EXCEPTION
4578: WHEN FND_API.G_EXC_ERROR THEN

Line 4578: WHEN FND_API.G_EXC_ERROR THEN

4574: RAISE FND_API.G_EXC_ERROR;
4575: END IF;
4576:
4577: EXCEPTION
4578: WHEN FND_API.G_EXC_ERROR THEN
4579: RAISE FND_API.G_EXC_ERROR;
4580: WHEN OTHERS THEN
4581: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_ERROR');
4582: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);

Line 4579: RAISE FND_API.G_EXC_ERROR;

4575: END IF;
4576:
4577: EXCEPTION
4578: WHEN FND_API.G_EXC_ERROR THEN
4579: RAISE FND_API.G_EXC_ERROR;
4580: WHEN OTHERS THEN
4581: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_ERROR');
4582: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
4583: FND_MESSAGE.set_token('MESSAGE', '('||SQLCODE||') '||SQLERRM);

Line 4585: RAISE FND_API.G_EXC_ERROR;

4581: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_ERROR');
4582: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
4583: FND_MESSAGE.set_token('MESSAGE', '('||SQLCODE||') '||SQLERRM);
4584: FND_MSG_PUB.Add;
4585: RAISE FND_API.G_EXC_ERROR;
4586: END Group2_Interorg_Iteration1;
4587: -- +========================================================================+
4588: -- PROCEDURE: Compute_Iterative_Pwac_Cost PRIVATE UTILITY
4589: -- PARAMETERS:

Line 5369: WHEN FND_API.G_EXC_ERROR THEN

5365: FND_MESSAGE.Set_Name('BOM', 'CST_PAC_DIVERGE_WARNING');
5366: FND_MESSAGE.set_token('ITEM', p_inventory_item_number);
5367: FND_MESSAGE.set_token('COSTGROUP', l_cost_group_name);
5368: fnd_file.put_line(FND_FILE.OUTPUT, FND_MESSAGE.GET);
5369: WHEN FND_API.G_EXC_ERROR THEN
5370: RAISE FND_API.G_EXC_ERROR;
5371: WHEN OTHERS THEN
5372: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5373: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION

Line 5370: RAISE FND_API.G_EXC_ERROR;

5366: FND_MESSAGE.set_token('ITEM', p_inventory_item_number);
5367: FND_MESSAGE.set_token('COSTGROUP', l_cost_group_name);
5368: fnd_file.put_line(FND_FILE.OUTPUT, FND_MESSAGE.GET);
5369: WHEN FND_API.G_EXC_ERROR THEN
5370: RAISE FND_API.G_EXC_ERROR;
5371: WHEN OTHERS THEN
5372: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5373: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION
5374: , G_MODULE_HEAD || l_routine ||'.others_exc'

Line 5382: RAISE FND_API.G_EXC_ERROR;

5378: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_ERROR');
5379: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
5380: FND_MESSAGE.set_token('MESSAGE', '('||SQLCODE||') '||SQLERRM);
5381: FND_MSG_PUB.Add;
5382: RAISE FND_API.G_EXC_ERROR;
5383: END Compute_Iterative_Pwac_Cost;
5384:
5385: -- +========================================================================+
5386: -- PROCEDURE: Iteration_Process PRIVATE UTILITY

Line 5903: WHEN FND_API.G_EXC_ERROR THEN

5899: );
5900: END IF;
5901:
5902: EXCEPTION
5903: WHEN FND_API.G_EXC_ERROR THEN
5904: RAISE FND_API.G_EXC_ERROR;
5905: WHEN OTHERS THEN
5906: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_ERROR');
5907: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);

Line 5904: RAISE FND_API.G_EXC_ERROR;

5900: END IF;
5901:
5902: EXCEPTION
5903: WHEN FND_API.G_EXC_ERROR THEN
5904: RAISE FND_API.G_EXC_ERROR;
5905: WHEN OTHERS THEN
5906: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_ERROR');
5907: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
5908: FND_MESSAGE.set_token('MESSAGE', '('||SQLCODE||') '||SQLERRM);

Line 5910: RAISE FND_API.G_EXC_ERROR;

5906: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_ERROR');
5907: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
5908: FND_MESSAGE.set_token('MESSAGE', '('||SQLCODE||') '||SQLERRM);
5909: FND_MSG_PUB.Add;
5910: RAISE FND_API.G_EXC_ERROR;
5911: END Iteration_Process;
5912:
5913: END CST_PAC_ITERATION_PROCESS_PVT;