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 1235: WHEN FND_API.G_EXC_ERROR THEN

1231: END LOOP; -- FETCH loop
1232: CLOSE pac_interorg_txns_cur;
1233:
1234: EXCEPTION
1235: WHEN FND_API.G_EXC_ERROR THEN
1236: RAISE FND_API.G_EXC_ERROR;
1237: WHEN OTHERS THEN
1238:
1239: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 1236: RAISE FND_API.G_EXC_ERROR;

1232: CLOSE pac_interorg_txns_cur;
1233:
1234: EXCEPTION
1235: WHEN FND_API.G_EXC_ERROR THEN
1236: RAISE FND_API.G_EXC_ERROR;
1237: WHEN OTHERS THEN
1238:
1239: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1240: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION

Line 1249: RAISE FND_API.G_EXC_ERROR;

1245: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_ERROR');
1246: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
1247: FND_MESSAGE.set_token('MESSAGE', 'Item_id' ||p_inventory_item_id ||'('||SQLCODE||') '||SQLERRM);
1248: FND_MSG_PUB.Add;
1249: RAISE FND_API.G_EXC_ERROR;
1250:
1251: END; -- Balance pac txn
1252:
1253: -- ==========================================================================

Line 1733: WHEN FND_API.G_EXC_ERROR THEN

1729: , '<< CST_PERIODIC_ABSORPTION_PROC:Calc_Pmac_For_Interorg'
1730: );
1731:
1732: EXCEPTION
1733: WHEN FND_API.G_EXC_ERROR THEN
1734: RAISE FND_API.G_EXC_ERROR;
1735: WHEN OTHERS THEN
1736: ROLLBACK;
1737: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_ERROR');

Line 1734: RAISE FND_API.G_EXC_ERROR;

1730: );
1731:
1732: EXCEPTION
1733: WHEN FND_API.G_EXC_ERROR THEN
1734: RAISE FND_API.G_EXC_ERROR;
1735: WHEN OTHERS THEN
1736: ROLLBACK;
1737: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_ERROR');
1738: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);

Line 1741: RAISE FND_API.G_EXC_ERROR;

1737: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_ERROR');
1738: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
1739: FND_MESSAGE.set_token('MESSAGE', '('||SQLCODE||') '||SQLERRM);
1740: FND_MSG_PUB.Add;
1741: RAISE FND_API.G_EXC_ERROR;
1742: END Calc_Pmac_For_Interorg;
1743:
1744:
1745: --=====================================================================================

Line 1953: WHEN FND_API.G_EXC_ERROR THEN

1949: END IF;
1950:
1951:
1952: EXCEPTION
1953: WHEN FND_API.G_EXC_ERROR THEN
1954: RAISE FND_API.G_EXC_ERROR;
1955: WHEN OTHERS THEN
1956: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_ERROR');
1957: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);

Line 1954: RAISE FND_API.G_EXC_ERROR;

1950:
1951:
1952: EXCEPTION
1953: WHEN FND_API.G_EXC_ERROR THEN
1954: RAISE FND_API.G_EXC_ERROR;
1955: WHEN OTHERS THEN
1956: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_ERROR');
1957: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
1958: FND_MESSAGE.set_token('MESSAGE', '('||SQLCODE||') '||SQLERRM);

Line 1960: RAISE FND_API.G_EXC_ERROR;

1956: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_ERROR');
1957: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
1958: FND_MESSAGE.set_token('MESSAGE', '('||SQLCODE||') '||SQLERRM);
1959: FND_MSG_PUB.Add;
1960: RAISE FND_API.G_EXC_ERROR;
1961: END Calc_Pmac_Update_Cppb;
1962:
1963: -- +========================================================================+
1964: -- PROCEDURE: Create_Mpacd_With_New_Values PRIVATE UTILITY

Line 2069: WHEN FND_API.G_EXC_ERROR THEN

2065: );
2066: END IF;
2067:
2068: EXCEPTION
2069: WHEN FND_API.G_EXC_ERROR THEN
2070: RAISE FND_API.G_EXC_ERROR;
2071: WHEN OTHERS THEN
2072: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2073: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION

Line 2070: RAISE FND_API.G_EXC_ERROR;

2066: END IF;
2067:
2068: EXCEPTION
2069: WHEN FND_API.G_EXC_ERROR THEN
2070: RAISE FND_API.G_EXC_ERROR;
2071: WHEN OTHERS THEN
2072: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2073: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION
2074: , G_MODULE_HEAD || l_routine ||'.others_exc'

Line 2082: RAISE FND_API.G_EXC_ERROR;

2078: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_ERROR');
2079: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
2080: FND_MESSAGE.set_token('MESSAGE', '('||SQLCODE||') '||SQLERRM);
2081: FND_MSG_PUB.Add;
2082: RAISE FND_API.G_EXC_ERROR;
2083:
2084: END; -- Create Mpacd With New Values
2085:
2086:

Line 2374: WHEN FND_API.G_EXC_ERROR THEN

2370: );
2371: END IF;
2372:
2373: EXCEPTION
2374: WHEN FND_API.G_EXC_ERROR THEN
2375: RAISE FND_API.G_EXC_ERROR;
2376: WHEN OTHERS THEN
2377: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2378: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION

Line 2375: RAISE FND_API.G_EXC_ERROR;

2371: END IF;
2372:
2373: EXCEPTION
2374: WHEN FND_API.G_EXC_ERROR THEN
2375: RAISE FND_API.G_EXC_ERROR;
2376: WHEN OTHERS THEN
2377: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2378: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION
2379: , G_MODULE_HEAD || l_routine ||'.others_exc'

Line 2387: RAISE FND_API.G_EXC_ERROR;

2383: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_ERROR');
2384: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
2385: FND_MESSAGE.set_token('MESSAGE', '('||SQLCODE||') '||SQLERRM);
2386: FND_MSG_PUB.Add;
2387: RAISE FND_API.G_EXC_ERROR;
2388:
2389: END; -- Update Cpicd With New Values
2390:
2391:

Line 2472: WHEN FND_API.G_EXC_ERROR THEN

2468: );
2469: END IF;
2470:
2471: EXCEPTION
2472: WHEN FND_API.G_EXC_ERROR THEN
2473: RAISE FND_API.G_EXC_ERROR;
2474: WHEN OTHERS THEN
2475: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2476: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION

Line 2473: RAISE FND_API.G_EXC_ERROR;

2469: END IF;
2470:
2471: EXCEPTION
2472: WHEN FND_API.G_EXC_ERROR THEN
2473: RAISE FND_API.G_EXC_ERROR;
2474: WHEN OTHERS THEN
2475: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2476: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION
2477: , G_MODULE_HEAD || l_routine ||'.others_exc'

Line 2485: RAISE FND_API.G_EXC_ERROR;

2481: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_ERROR');
2482: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
2483: FND_MESSAGE.set_token('MESSAGE', '('||SQLCODE||') '||SQLERRM);
2484: FND_MSG_PUB.Add;
2485: RAISE FND_API.G_EXC_ERROR;
2486:
2487: END; -- Set_Phase5_Status
2488:
2489:

Line 2594: WHEN FND_API.G_EXC_ERROR THEN

2590: );
2591: END IF;
2592:
2593: EXCEPTION
2594: WHEN FND_API.G_EXC_ERROR THEN
2595: RAISE FND_API.G_EXC_ERROR;
2596: WHEN OTHERS THEN
2597: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2598: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION

Line 2595: RAISE FND_API.G_EXC_ERROR;

2591: END IF;
2592:
2593: EXCEPTION
2594: WHEN FND_API.G_EXC_ERROR THEN
2595: RAISE FND_API.G_EXC_ERROR;
2596: WHEN OTHERS THEN
2597: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2598: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION
2599: , G_MODULE_HEAD || l_routine ||'.others_exc'

Line 2607: RAISE FND_API.G_EXC_ERROR;

2603: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_ERROR');
2604: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
2605: FND_MESSAGE.set_token('MESSAGE', '('||SQLCODE||') '||SQLERRM);
2606: FND_MSG_PUB.Add;
2607: RAISE FND_API.G_EXC_ERROR;
2608: END; -- Set_Process_Status
2609:
2610:
2611: -- +============================================================================+

Line 2786: WHEN FND_API.G_EXC_ERROR THEN

2782:
2783: END IF;
2784:
2785: EXCEPTION
2786: WHEN FND_API.G_EXC_ERROR THEN
2787: RAISE FND_API.G_EXC_ERROR;
2788: WHEN OTHERS THEN
2789: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2790: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION

Line 2787: RAISE FND_API.G_EXC_ERROR;

2783: END IF;
2784:
2785: EXCEPTION
2786: WHEN FND_API.G_EXC_ERROR THEN
2787: RAISE FND_API.G_EXC_ERROR;
2788: WHEN OTHERS THEN
2789: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2790: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION
2791: , G_MODULE_HEAD || l_routine ||'.others_exc'

Line 2799: RAISE FND_API.G_EXC_ERROR;

2795: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_ERROR');
2796: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
2797: FND_MESSAGE.set_token('MESSAGE', 'Item_id'||p_inventory_item_id ||'Iteration Number' ||p_iteration_num ||'('||SQLCODE||') '||SQLERRM);
2798: FND_MSG_PUB.Add;
2799: RAISE FND_API.G_EXC_ERROR;
2800:
2801: END Verify_Tolerance_Of_Item;
2802:
2803: -- +========================================================================+

Line 2938: WHEN FND_API.G_EXC_ERROR THEN

2934: );
2935: END IF;
2936:
2937: EXCEPTION
2938: WHEN FND_API.G_EXC_ERROR THEN
2939: RAISE FND_API.G_EXC_ERROR;
2940: WHEN OTHERS THEN
2941: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2942: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION

Line 2939: RAISE FND_API.G_EXC_ERROR;

2935: END IF;
2936:
2937: EXCEPTION
2938: WHEN FND_API.G_EXC_ERROR THEN
2939: RAISE FND_API.G_EXC_ERROR;
2940: WHEN OTHERS THEN
2941: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2942: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION
2943: , G_MODULE_HEAD || l_routine ||'.others_exc'

Line 2951: RAISE FND_API.G_EXC_ERROR;

2947: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_ERROR');
2948: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
2949: FND_MESSAGE.set_token('MESSAGE', '('||SQLCODE||') '||SQLERRM);
2950: FND_MSG_PUB.Add;
2951: RAISE FND_API.G_EXC_ERROR;
2952:
2953: END Initialize;
2954:
2955: -- +========================================================================+

Line 3384: WHEN FND_API.G_EXC_ERROR THEN

3380: );
3381: END IF;
3382:
3383: EXCEPTION
3384: WHEN FND_API.G_EXC_ERROR THEN
3385: RAISE FND_API.G_EXC_ERROR;
3386: WHEN OTHERS THEN
3387: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3388: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION

Line 3385: RAISE FND_API.G_EXC_ERROR;

3381: END IF;
3382:
3383: EXCEPTION
3384: WHEN FND_API.G_EXC_ERROR THEN
3385: RAISE FND_API.G_EXC_ERROR;
3386: WHEN OTHERS THEN
3387: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3388: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION
3389: , G_MODULE_HEAD || l_routine ||'.others_exc'

Line 3397: RAISE FND_API.G_EXC_ERROR;

3393: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_ERROR');
3394: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
3395: FND_MESSAGE.set_token('MESSAGE', '('||SQLCODE||') '||SQLERRM);
3396: FND_MSG_PUB.Add;
3397: RAISE FND_API.G_EXC_ERROR;
3398:
3399: END Populate_Temp_Tables;
3400:
3401: -- +========================================================================+

Line 3642: WHEN FND_API.G_EXC_ERROR THEN

3638: AND cpiit.INTERORG_RECEIPT_FLAG = 'Y';
3639:
3640:
3641: EXCEPTION
3642: WHEN FND_API.G_EXC_ERROR THEN
3643: RAISE FND_API.G_EXC_ERROR;
3644: WHEN OTHERS THEN
3645:
3646: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_ERROR');

Line 3643: RAISE FND_API.G_EXC_ERROR;

3639:
3640:
3641: EXCEPTION
3642: WHEN FND_API.G_EXC_ERROR THEN
3643: RAISE FND_API.G_EXC_ERROR;
3644: WHEN OTHERS THEN
3645:
3646: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_ERROR');
3647: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);

Line 3650: RAISE FND_API.G_EXC_ERROR;

3646: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_ERROR');
3647: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
3648: FND_MESSAGE.set_token('MESSAGE', '('||SQLCODE||') '||SQLERRM);
3649: FND_MSG_PUB.Add;
3650: RAISE FND_API.G_EXC_ERROR;
3651:
3652: END Retrieve_Interorg_Items;
3653:
3654: -- +========================================================================+

Line 3697: WHEN FND_API.G_EXC_ERROR THEN

3693: and cos1.pac_period_id = Q.pac_period_id)
3694: WHERE cos1.pac_period_id = p_period_id;
3695:
3696: EXCEPTION
3697: WHEN FND_API.G_EXC_ERROR THEN
3698: RAISE FND_API.G_EXC_ERROR;
3699: WHEN OTHERS THEN
3700: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_ERROR');
3701: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);

Line 3698: RAISE FND_API.G_EXC_ERROR;

3694: WHERE cos1.pac_period_id = p_period_id;
3695:
3696: EXCEPTION
3697: WHEN FND_API.G_EXC_ERROR THEN
3698: RAISE FND_API.G_EXC_ERROR;
3699: WHEN OTHERS THEN
3700: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_ERROR');
3701: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
3702: FND_MESSAGE.set_token('MESSAGE', '('||SQLCODE||') '||SQLERRM);

Line 3704: RAISE FND_API.G_EXC_ERROR;

3700: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_ERROR');
3701: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
3702: FND_MESSAGE.set_token('MESSAGE', '('||SQLCODE||') '||SQLERRM);
3703: FND_MSG_PUB.Add;
3704: RAISE FND_API.G_EXC_ERROR;
3705: END Process_Optimal_Sequence;
3706:
3707: -- +========================================================================+
3708: -- PROCEDURE: Get_Balance_Before_Intorg

Line 3898: WHEN FND_API.G_EXC_ERROR THEN

3894: END IF;
3895:
3896:
3897: EXCEPTION
3898: WHEN FND_API.G_EXC_ERROR THEN
3899: RAISE FND_API.G_EXC_ERROR;
3900: WHEN OTHERS THEN
3901: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3902: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION

Line 3899: RAISE FND_API.G_EXC_ERROR;

3895:
3896:
3897: EXCEPTION
3898: WHEN FND_API.G_EXC_ERROR THEN
3899: RAISE FND_API.G_EXC_ERROR;
3900: WHEN OTHERS THEN
3901: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3902: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION
3903: , G_MODULE_HEAD || l_routine ||'.others_exc'

Line 3911: RAISE FND_API.G_EXC_ERROR;

3907: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_ERROR');
3908: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
3909: FND_MESSAGE.set_token('MESSAGE', '('||SQLCODE||') '||SQLERRM);
3910: FND_MSG_PUB.Add;
3911: RAISE FND_API.G_EXC_ERROR;
3912: END Get_Balance_Before_Intorg;
3913:
3914: -- +========================================================================+
3915: -- PROCEDURE: PRIVATE UTILITY

Line 4127: RAISE FND_API.G_EXC_ERROR;

4123: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
4124: FND_MESSAGE.set_token('MESSAGE', 'group1 cost_inv_txn for cost group '|| p_cost_group_id ||' txn id '
4125: || l_group1_interorg_tab(i).transaction_id||' ('||l_error_code||') '||l_error_msg);
4126: FND_MSG_PUB.Add;
4127: RAISE FND_API.G_EXC_ERROR;
4128: END IF;
4129:
4130: -- Insert into MTL_PAC_ACT_CST_DTL_TEMP only if the iteration
4131: -- process flag is enabled with more than 1 iteration

Line 4369: RAISE FND_API.G_EXC_ERROR;

4365: FND_MESSAGE.set_token('MESSAGE', 'CSTPPWAC.update_item_cppb for CG '|| p_cost_group_id ||' txn category '
4366: ||l_txn_category||' t_low_level_code ' ||p_low_level_code
4367: ||' error('||l_error_code||') '||l_error_msg);
4368: FND_MSG_PUB.Add;
4369: RAISE FND_API.G_EXC_ERROR;
4370: END IF;
4371:
4372: CSTPPWAC.update_item_cppb (i_pac_period_id => p_period_id,
4373: i_cost_group_id => p_cost_group_id,

Line 4397: WHEN FND_API.G_EXC_ERROR THEN

4393: AND cost_group_id = p_cost_group_id
4394: AND inventory_item_id = p_inventory_item_id;
4395:
4396: EXCEPTION
4397: WHEN FND_API.G_EXC_ERROR THEN
4398: RAISE FND_API.G_EXC_ERROR;
4399: WHEN OTHERS THEN
4400: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_ERROR');
4401: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);

Line 4398: RAISE FND_API.G_EXC_ERROR;

4394: AND inventory_item_id = p_inventory_item_id;
4395:
4396: EXCEPTION
4397: WHEN FND_API.G_EXC_ERROR THEN
4398: RAISE FND_API.G_EXC_ERROR;
4399: WHEN OTHERS THEN
4400: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_ERROR');
4401: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
4402: FND_MESSAGE.set_token('MESSAGE', '('||SQLCODE||') '||SQLERRM);

Line 4404: RAISE FND_API.G_EXC_ERROR;

4400: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_ERROR');
4401: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
4402: FND_MESSAGE.set_token('MESSAGE', '('||SQLCODE||') '||SQLERRM);
4403: FND_MSG_PUB.Add;
4404: RAISE FND_API.G_EXC_ERROR;
4405: END Group1_Interorg_Iteration1;
4406:
4407: -- +========================================================================+
4408: -- PROCEDURE: PRIVATE UTILITY

Line 4600: RAISE FND_API.G_EXC_ERROR;

4596: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
4597: FND_MESSAGE.set_token('MESSAGE', 'group2 cost_inv_txn for cost group '|| p_cost_group_id ||' txn id '
4598: || l_group2_interorg_tab(i).transaction_id||' ('||l_error_code||') '||l_error_msg);
4599: FND_MSG_PUB.Add;
4600: RAISE FND_API.G_EXC_ERROR;
4601: END IF;
4602:
4603: -- Insert into MTL_PAC_ACT_CST_DTL_TEMP only if the iteration
4604: -- process flag is enabled and consecutive iterations exist

Line 4807: RAISE FND_API.G_EXC_ERROR;

4803: FND_MESSAGE.set_token('MESSAGE', 'CSTPPWAC.update_item_cppb for CG '|| p_cost_group_id ||' txn category '
4804: ||l_txn_category||' t_low_level_code ' ||p_low_level_code
4805: ||' error('||l_error_code||') '||l_error_msg);
4806: FND_MSG_PUB.Add;
4807: RAISE FND_API.G_EXC_ERROR;
4808: END IF;
4809:
4810: EXCEPTION
4811: WHEN FND_API.G_EXC_ERROR THEN

Line 4811: WHEN FND_API.G_EXC_ERROR THEN

4807: RAISE FND_API.G_EXC_ERROR;
4808: END IF;
4809:
4810: EXCEPTION
4811: WHEN FND_API.G_EXC_ERROR THEN
4812: RAISE FND_API.G_EXC_ERROR;
4813: WHEN OTHERS THEN
4814: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_ERROR');
4815: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);

Line 4812: RAISE FND_API.G_EXC_ERROR;

4808: END IF;
4809:
4810: EXCEPTION
4811: WHEN FND_API.G_EXC_ERROR THEN
4812: RAISE FND_API.G_EXC_ERROR;
4813: WHEN OTHERS THEN
4814: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_ERROR');
4815: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
4816: FND_MESSAGE.set_token('MESSAGE', '('||SQLCODE||') '||SQLERRM);

Line 4818: RAISE FND_API.G_EXC_ERROR;

4814: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_ERROR');
4815: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
4816: FND_MESSAGE.set_token('MESSAGE', '('||SQLCODE||') '||SQLERRM);
4817: FND_MSG_PUB.Add;
4818: RAISE FND_API.G_EXC_ERROR;
4819: END Group2_Interorg_Iteration1;
4820: -- +========================================================================+
4821: -- PROCEDURE: Compute_Iterative_Pwac_Cost PRIVATE UTILITY
4822: -- PARAMETERS:

Line 5644: WHEN FND_API.G_EXC_ERROR THEN

5640: FND_MESSAGE.Set_Name('BOM', 'CST_PAC_DIVERGE_WARNING');
5641: FND_MESSAGE.set_token('ITEM', p_inventory_item_number);
5642: FND_MESSAGE.set_token('COSTGROUP', l_cost_group_name);
5643: fnd_file.put_line(FND_FILE.OUTPUT, FND_MESSAGE.GET);
5644: WHEN FND_API.G_EXC_ERROR THEN
5645: RAISE FND_API.G_EXC_ERROR;
5646: WHEN OTHERS THEN
5647: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5648: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION

Line 5645: RAISE FND_API.G_EXC_ERROR;

5641: FND_MESSAGE.set_token('ITEM', p_inventory_item_number);
5642: FND_MESSAGE.set_token('COSTGROUP', l_cost_group_name);
5643: fnd_file.put_line(FND_FILE.OUTPUT, FND_MESSAGE.GET);
5644: WHEN FND_API.G_EXC_ERROR THEN
5645: RAISE FND_API.G_EXC_ERROR;
5646: WHEN OTHERS THEN
5647: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5648: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION
5649: , G_MODULE_HEAD || l_routine ||'.others_exc'

Line 5657: RAISE FND_API.G_EXC_ERROR;

5653: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_ERROR');
5654: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
5655: FND_MESSAGE.set_token('MESSAGE', '('||SQLCODE||') '||SQLERRM);
5656: FND_MSG_PUB.Add;
5657: RAISE FND_API.G_EXC_ERROR;
5658: END Compute_Iterative_Pwac_Cost;
5659:
5660: -- +========================================================================+
5661: -- PROCEDURE: Iteration_Process PRIVATE UTILITY

Line 5959: RAISE FND_API.G_EXC_ERROR;

5955: l_error_code := NVL(l_error_code, 'No Error');
5956: l_error_msg := NVL(l_error_msg, 'No Error');
5957:
5958: IF l_error_num <> 0 THEN
5959: RAISE FND_API.G_EXC_ERROR;
5960: END IF;
5961:
5962: END LOOP;
5963: -- end Bug 12663454 fix

Line 6412: WHEN FND_API.G_EXC_ERROR THEN

6408: );
6409: END IF;
6410:
6411: EXCEPTION
6412: WHEN FND_API.G_EXC_ERROR THEN
6413: RAISE FND_API.G_EXC_ERROR;
6414: WHEN OTHERS THEN
6415: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_ERROR');
6416: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);

Line 6413: RAISE FND_API.G_EXC_ERROR;

6409: END IF;
6410:
6411: EXCEPTION
6412: WHEN FND_API.G_EXC_ERROR THEN
6413: RAISE FND_API.G_EXC_ERROR;
6414: WHEN OTHERS THEN
6415: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_ERROR');
6416: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
6417: FND_MESSAGE.set_token('MESSAGE', '('||SQLCODE||') '||SQLERRM);

Line 6419: RAISE FND_API.G_EXC_ERROR;

6415: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_ERROR');
6416: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
6417: FND_MESSAGE.set_token('MESSAGE', '('||SQLCODE||') '||SQLERRM);
6418: FND_MSG_PUB.Add;
6419: RAISE FND_API.G_EXC_ERROR;
6420: END Iteration_Process;
6421:
6422: END CST_PAC_ITERATION_PROCESS_PVT;