816: , G_MODULE_HEAD || l_routine ||'.others_exc'
817: , 'txn_id '|| p_transaction_id || 'Opp Txn_id '||p_opp_transaction_id || SQLCODE || substr(SQLERRM, 1,200)
818: );
819: END IF;
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;
817: , 'txn_id '|| p_transaction_id || 'Opp Txn_id '||p_opp_transaction_id || SQLCODE || substr(SQLERRM, 1,200)
818: );
819: END IF;
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:
818: );
819: END IF;
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
1241: , G_MODULE_HEAD || l_routine ||'.others_exc'
1242: , 'Item_id' ||p_inventory_item_id || SQLCODE || substr(SQLERRM, 1,200)
1243: );
1244: END IF;
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;
1242: , 'Item_id' ||p_inventory_item_id || SQLCODE || substr(SQLERRM, 1,200)
1243: );
1244: END IF;
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:
1243: );
1244: END IF;
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
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);
1739: FND_MESSAGE.set_token('MESSAGE', '('||SQLCODE||') '||SQLERRM);
1740: FND_MSG_PUB.Add;
1741: RAISE FND_API.G_EXC_ERROR;
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);
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;
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);
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:
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);
1959: FND_MSG_PUB.Add;
1960: RAISE FND_API.G_EXC_ERROR;
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);
1959: FND_MSG_PUB.Add;
1960: RAISE FND_API.G_EXC_ERROR;
1961: END Calc_Pmac_Update_Cppb;
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);
1959: FND_MSG_PUB.Add;
1960: RAISE FND_API.G_EXC_ERROR;
1961: END Calc_Pmac_Update_Cppb;
1962:
2074: , G_MODULE_HEAD || l_routine ||'.others_exc'
2075: , 'others:' || SQLCODE || substr(SQLERRM, 1,200)
2076: );
2077: END IF;
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;
2075: , 'others:' || SQLCODE || substr(SQLERRM, 1,200)
2076: );
2077: END IF;
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:
2076: );
2077: END IF;
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
2379: , G_MODULE_HEAD || l_routine ||'.others_exc'
2380: , 'others:' || SQLCODE || substr(SQLERRM, 1,200)
2381: );
2382: END IF;
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;
2380: , 'others:' || SQLCODE || substr(SQLERRM, 1,200)
2381: );
2382: END IF;
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:
2381: );
2382: END IF;
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
2477: , G_MODULE_HEAD || l_routine ||'.others_exc'
2478: , 'others:' || SQLCODE || substr(SQLERRM, 1,200)
2479: );
2480: END IF;
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;
2478: , 'others:' || SQLCODE || substr(SQLERRM, 1,200)
2479: );
2480: END IF;
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:
2479: );
2480: END IF;
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
2599: , G_MODULE_HEAD || l_routine ||'.others_exc'
2600: , 'others:' || SQLCODE || substr(SQLERRM, 1,200)
2601: );
2602: END IF;
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;
2600: , 'others:' || SQLCODE || substr(SQLERRM, 1,200)
2601: );
2602: END IF;
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
2601: );
2602: END IF;
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:
2791: , G_MODULE_HEAD || l_routine ||'.others_exc'
2792: , 'Item_id'||p_inventory_item_id ||'Iteration Number' ||p_iteration_num || SQLCODE || substr(SQLERRM, 1,200)
2793: );
2794: END IF;
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;
2792: , 'Item_id'||p_inventory_item_id ||'Iteration Number' ||p_iteration_num || SQLCODE || substr(SQLERRM, 1,200)
2793: );
2794: END IF;
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:
2793: );
2794: END IF;
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;
2943: , G_MODULE_HEAD || l_routine ||'.others_exc'
2944: , 'others:' || SQLCODE || substr(SQLERRM, 1,200)
2945: );
2946: END IF;
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;
2944: , 'others:' || SQLCODE || substr(SQLERRM, 1,200)
2945: );
2946: END IF;
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:
2945: );
2946: END IF;
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;
3389: , G_MODULE_HEAD || l_routine ||'.others_exc'
3390: , 'others:' || SQLCODE || substr(SQLERRM, 1,200)
3391: );
3392: END IF;
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;
3390: , 'others:' || SQLCODE || substr(SQLERRM, 1,200)
3391: );
3392: END IF;
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:
3391: );
3392: END IF;
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;
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);
3648: FND_MESSAGE.set_token('MESSAGE', '('||SQLCODE||') '||SQLERRM);
3649: FND_MSG_PUB.Add;
3650: RAISE FND_API.G_EXC_ERROR;
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);
3648: FND_MESSAGE.set_token('MESSAGE', '('||SQLCODE||') '||SQLERRM);
3649: FND_MSG_PUB.Add;
3650: RAISE FND_API.G_EXC_ERROR;
3651:
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);
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;
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);
3703: FND_MSG_PUB.Add;
3704: RAISE FND_API.G_EXC_ERROR;
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);
3703: FND_MSG_PUB.Add;
3704: RAISE FND_API.G_EXC_ERROR;
3705: END Process_Optimal_Sequence;
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);
3703: FND_MSG_PUB.Add;
3704: RAISE FND_API.G_EXC_ERROR;
3705: END Process_Optimal_Sequence;
3706:
3903: , G_MODULE_HEAD || l_routine ||'.others_exc'
3904: , 'others:' || SQLCODE || substr(SQLERRM, 1,200)
3905: );
3906: END IF;
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;
3904: , 'others:' || SQLCODE || substr(SQLERRM, 1,200)
3905: );
3906: END IF;
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;
3905: );
3906: END IF;
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:
4118: , 'group1 cost_inv_txn for cost group '|| p_cost_group_id ||' txn id '
4119: || l_group1_interorg_tab(i).transaction_id||' ('||l_error_code||') '||l_error_msg
4120: );
4121: END IF;
4122: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_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;
4119: || l_group1_interorg_tab(i).transaction_id||' ('||l_error_code||') '||l_error_msg
4120: );
4121: END IF;
4122: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_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;
4120: );
4121: END IF;
4122: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_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;
4359: AND transaction_id = l_txn_id_tbl(l_mpacd_idx);
4360: END IF;
4361:
4362: IF l_error_num <> 0 THEN
4363: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_ERROR');
4364: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
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);
4360: END IF;
4361:
4362: IF l_error_num <> 0 THEN
4363: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_ERROR');
4364: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
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;
4361:
4362: IF l_error_num <> 0 THEN
4363: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_ERROR');
4364: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
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;
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);
4403: FND_MSG_PUB.Add;
4404: RAISE FND_API.G_EXC_ERROR;
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);
4403: FND_MSG_PUB.Add;
4404: RAISE FND_API.G_EXC_ERROR;
4405: END Group1_Interorg_Iteration1;
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);
4403: FND_MSG_PUB.Add;
4404: RAISE FND_API.G_EXC_ERROR;
4405: END Group1_Interorg_Iteration1;
4406:
4591: , 'group2 cost_inv_txn for cost group '|| p_cost_group_id ||' txn id '
4592: || l_group2_interorg_tab(i).transaction_id||' ('||l_error_code||') '||l_error_msg
4593: );
4594: END IF;
4595: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_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;
4592: || l_group2_interorg_tab(i).transaction_id||' ('||l_error_code||') '||l_error_msg
4593: );
4594: END IF;
4595: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_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;
4593: );
4594: END IF;
4595: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_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;
4797: ||l_txn_category||' t_low_level_code ' ||p_low_level_code
4798: ||' error('||l_error_code||') '||l_error_msg
4799: );
4800: END IF;
4801: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_ERROR');
4802: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
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);
4798: ||' error('||l_error_code||') '||l_error_msg
4799: );
4800: END IF;
4801: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_ERROR');
4802: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
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;
4799: );
4800: END IF;
4801: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_ERROR');
4802: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
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;
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);
4817: FND_MSG_PUB.Add;
4818: RAISE FND_API.G_EXC_ERROR;
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);
4817: FND_MSG_PUB.Add;
4818: RAISE FND_API.G_EXC_ERROR;
4819: END Group2_Interorg_Iteration1;
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);
4817: FND_MSG_PUB.Add;
4818: RAISE FND_API.G_EXC_ERROR;
4819: END Group2_Interorg_Iteration1;
4820: -- +========================================================================+
5636: WHEN l_diverging_exception THEN
5637: -- Just a warning. No need to raise an exception. The process can continue for other cost groups for the item.
5638: l_cost_group_id_idx := p_cost_group_id;
5639: l_cost_group_name := CST_PAC_ITERATION_PROCESS_PVT.G_CST_GROUP_TBL(l_cost_group_id_idx).cost_group;
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
5637: -- Just a warning. No need to raise an exception. The process can continue for other cost groups for the item.
5638: l_cost_group_id_idx := p_cost_group_id;
5639: l_cost_group_name := CST_PAC_ITERATION_PROCESS_PVT.G_CST_GROUP_TBL(l_cost_group_id_idx).cost_group;
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;
5638: l_cost_group_id_idx := p_cost_group_id;
5639: l_cost_group_name := CST_PAC_ITERATION_PROCESS_PVT.G_CST_GROUP_TBL(l_cost_group_id_idx).cost_group;
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
5639: l_cost_group_name := CST_PAC_ITERATION_PROCESS_PVT.G_CST_GROUP_TBL(l_cost_group_id_idx).cost_group;
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
5649: , G_MODULE_HEAD || l_routine ||'.others_exc'
5650: , 'others:' || SQLCODE || substr(SQLERRM, 1,200)
5651: );
5652: END IF;
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;
5650: , 'others:' || SQLCODE || substr(SQLERRM, 1,200)
5651: );
5652: END IF;
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;
5651: );
5652: END IF;
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:
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);
6418: FND_MSG_PUB.Add;
6419: RAISE FND_API.G_EXC_ERROR;
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);
6418: FND_MSG_PUB.Add;
6419: RAISE FND_API.G_EXC_ERROR;
6420: END Iteration_Process;
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);
6418: FND_MSG_PUB.Add;
6419: RAISE FND_API.G_EXC_ERROR;
6420: END Iteration_Process;
6421: