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_MESSAGE

Line 820: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_ERROR');

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;

Line 821: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);

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:

Line 822: FND_MESSAGE.set_token('MESSAGE', 'txn_id '|| p_transaction_id || 'Opp Txn_id '||p_opp_transaction_id || '('||SQLCODE||') '||SQLERRM);

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

Line 1149: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_ERROR');

1145: , G_MODULE_HEAD || l_routine ||'.others_exc'
1146: , 'Item_id' ||p_inventory_item_id || SQLCODE || substr(SQLERRM, 1,200)
1147: );
1148: END IF;
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;

Line 1150: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);

1146: , 'Item_id' ||p_inventory_item_id || SQLCODE || substr(SQLERRM, 1,200)
1147: );
1148: END IF;
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:

Line 1151: FND_MESSAGE.set_token('MESSAGE', 'Item_id' ||p_inventory_item_id ||'('||SQLCODE||') '||SQLERRM);

1147: );
1148: END IF;
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

Line 1631: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_ERROR');

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);
1633: FND_MESSAGE.set_token('MESSAGE', '('||SQLCODE||') '||SQLERRM);
1634: FND_MSG_PUB.Add;
1635: RAISE FND_API.G_EXC_ERROR;

Line 1632: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);

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);
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;

Line 1633: FND_MESSAGE.set_token('MESSAGE', '('||SQLCODE||') '||SQLERRM);

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);
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:

Line 1840: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_ERROR');

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);
1843: FND_MSG_PUB.Add;
1844: RAISE FND_API.G_EXC_ERROR;

Line 1841: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);

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);
1843: FND_MSG_PUB.Add;
1844: RAISE FND_API.G_EXC_ERROR;
1845: END Calc_Pmac_Update_Cppb;

Line 1842: FND_MESSAGE.set_token('MESSAGE', '('||SQLCODE||') '||SQLERRM);

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);
1843: FND_MSG_PUB.Add;
1844: RAISE FND_API.G_EXC_ERROR;
1845: END Calc_Pmac_Update_Cppb;
1846:

Line 1952: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_ERROR');

1948: , G_MODULE_HEAD || l_routine ||'.others_exc'
1949: , 'others:' || SQLCODE || substr(SQLERRM, 1,200)
1950: );
1951: END IF;
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;

Line 1953: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);

1949: , 'others:' || SQLCODE || substr(SQLERRM, 1,200)
1950: );
1951: END IF;
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:

Line 1954: FND_MESSAGE.set_token('MESSAGE', '('||SQLCODE||') '||SQLERRM);

1950: );
1951: END IF;
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

Line 2241: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_ERROR');

2237: , G_MODULE_HEAD || l_routine ||'.others_exc'
2238: , 'others:' || SQLCODE || substr(SQLERRM, 1,200)
2239: );
2240: END IF;
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;

Line 2242: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);

2238: , 'others:' || SQLCODE || substr(SQLERRM, 1,200)
2239: );
2240: END IF;
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:

Line 2243: FND_MESSAGE.set_token('MESSAGE', '('||SQLCODE||') '||SQLERRM);

2239: );
2240: END IF;
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

Line 2339: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_ERROR');

2335: , G_MODULE_HEAD || l_routine ||'.others_exc'
2336: , 'others:' || SQLCODE || substr(SQLERRM, 1,200)
2337: );
2338: END IF;
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;

Line 2340: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);

2336: , 'others:' || SQLCODE || substr(SQLERRM, 1,200)
2337: );
2338: END IF;
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:

Line 2341: FND_MESSAGE.set_token('MESSAGE', '('||SQLCODE||') '||SQLERRM);

2337: );
2338: END IF;
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

Line 2461: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_ERROR');

2457: , G_MODULE_HEAD || l_routine ||'.others_exc'
2458: , 'others:' || SQLCODE || substr(SQLERRM, 1,200)
2459: );
2460: END IF;
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;

Line 2462: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);

2458: , 'others:' || SQLCODE || substr(SQLERRM, 1,200)
2459: );
2460: END IF;
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

Line 2463: FND_MESSAGE.set_token('MESSAGE', '('||SQLCODE||') '||SQLERRM);

2459: );
2460: END IF;
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:

Line 2649: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_ERROR');

2645: , G_MODULE_HEAD || l_routine ||'.others_exc'
2646: , 'Item_id'||p_inventory_item_id ||'Iteration Number' ||p_iteration_num || SQLCODE || substr(SQLERRM, 1,200)
2647: );
2648: END IF;
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;

Line 2650: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);

2646: , 'Item_id'||p_inventory_item_id ||'Iteration Number' ||p_iteration_num || SQLCODE || substr(SQLERRM, 1,200)
2647: );
2648: END IF;
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:

Line 2651: FND_MESSAGE.set_token('MESSAGE', 'Item_id'||p_inventory_item_id ||'Iteration Number' ||p_iteration_num ||'('||SQLCODE||') '||SQLERRM);

2647: );
2648: END IF;
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;

Line 2801: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_ERROR');

2797: , G_MODULE_HEAD || l_routine ||'.others_exc'
2798: , 'others:' || SQLCODE || substr(SQLERRM, 1,200)
2799: );
2800: END IF;
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;

Line 2802: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);

2798: , 'others:' || SQLCODE || substr(SQLERRM, 1,200)
2799: );
2800: END IF;
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:

Line 2803: FND_MESSAGE.set_token('MESSAGE', '('||SQLCODE||') '||SQLERRM);

2799: );
2800: END IF;
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;

Line 3237: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_ERROR');

3233: , G_MODULE_HEAD || l_routine ||'.others_exc'
3234: , 'others:' || SQLCODE || substr(SQLERRM, 1,200)
3235: );
3236: END IF;
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;

Line 3238: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);

3234: , 'others:' || SQLCODE || substr(SQLERRM, 1,200)
3235: );
3236: END IF;
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:

Line 3239: FND_MESSAGE.set_token('MESSAGE', '('||SQLCODE||') '||SQLERRM);

3235: );
3236: END IF;
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;

Line 3490: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_ERROR');

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);
3492: FND_MESSAGE.set_token('MESSAGE', '('||SQLCODE||') '||SQLERRM);
3493: FND_MSG_PUB.Add;
3494: RAISE FND_API.G_EXC_ERROR;

Line 3491: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);

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);
3492: FND_MESSAGE.set_token('MESSAGE', '('||SQLCODE||') '||SQLERRM);
3493: FND_MSG_PUB.Add;
3494: RAISE FND_API.G_EXC_ERROR;
3495:

Line 3492: FND_MESSAGE.set_token('MESSAGE', '('||SQLCODE||') '||SQLERRM);

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);
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;

Line 3544: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_ERROR');

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);
3547: FND_MSG_PUB.Add;
3548: RAISE FND_API.G_EXC_ERROR;

Line 3545: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);

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);
3547: FND_MSG_PUB.Add;
3548: RAISE FND_API.G_EXC_ERROR;
3549: END Process_Optimal_Sequence;

Line 3546: FND_MESSAGE.set_token('MESSAGE', '('||SQLCODE||') '||SQLERRM);

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);
3547: FND_MSG_PUB.Add;
3548: RAISE FND_API.G_EXC_ERROR;
3549: END Process_Optimal_Sequence;
3550:

Line 3674: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_ERROR');

3670: , G_MODULE_HEAD || l_routine ||'.others_exc'
3671: , 'others:' || SQLCODE || substr(SQLERRM, 1,200)
3672: );
3673: END IF;
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;

Line 3675: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);

3671: , 'others:' || SQLCODE || substr(SQLERRM, 1,200)
3672: );
3673: END IF;
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;

Line 3676: FND_MESSAGE.set_token('MESSAGE', '('||SQLCODE||') '||SQLERRM);

3672: );
3673: END IF;
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:

Line 3889: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_ERROR');

3885: , 'group1 cost_inv_txn for cost group '|| p_cost_group_id ||' txn id '
3886: || l_group1_interorg_tab(i).transaction_id||' ('||l_error_code||') '||l_error_msg
3887: );
3888: END IF;
3889: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_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;

Line 3890: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);

3886: || l_group1_interorg_tab(i).transaction_id||' ('||l_error_code||') '||l_error_msg
3887: );
3888: END IF;
3889: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_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;

Line 3891: FND_MESSAGE.set_token('MESSAGE', 'group1 cost_inv_txn for cost group '|| p_cost_group_id ||' txn id '

3887: );
3888: END IF;
3889: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_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;

Line 4130: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_ERROR');

4126: AND transaction_id = l_txn_id_tbl(l_mpacd_idx);
4127: END IF;
4128:
4129: IF l_error_num <> 0 THEN
4130: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_ERROR');
4131: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
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);

Line 4131: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);

4127: END IF;
4128:
4129: IF l_error_num <> 0 THEN
4130: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_ERROR');
4131: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
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;

Line 4132: FND_MESSAGE.set_token('MESSAGE', 'CSTPPWAC.update_item_cppb for CG '|| p_cost_group_id ||' txn category '

4128:
4129: IF l_error_num <> 0 THEN
4130: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_ERROR');
4131: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
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;

Line 4167: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_ERROR');

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);
4170: FND_MSG_PUB.Add;
4171: RAISE FND_API.G_EXC_ERROR;

Line 4168: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);

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);
4170: FND_MSG_PUB.Add;
4171: RAISE FND_API.G_EXC_ERROR;
4172: END Group1_Interorg_Iteration1;

Line 4169: FND_MESSAGE.set_token('MESSAGE', '('||SQLCODE||') '||SQLERRM);

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);
4170: FND_MSG_PUB.Add;
4171: RAISE FND_API.G_EXC_ERROR;
4172: END Group1_Interorg_Iteration1;
4173:

Line 4362: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_ERROR');

4358: , 'group2 cost_inv_txn for cost group '|| p_cost_group_id ||' txn id '
4359: || l_group2_interorg_tab(i).transaction_id||' ('||l_error_code||') '||l_error_msg
4360: );
4361: END IF;
4362: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_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;

Line 4363: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);

4359: || l_group2_interorg_tab(i).transaction_id||' ('||l_error_code||') '||l_error_msg
4360: );
4361: END IF;
4362: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_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;

Line 4364: FND_MESSAGE.set_token('MESSAGE', 'group2 cost_inv_txn for cost group '|| p_cost_group_id ||' txn id '

4360: );
4361: END IF;
4362: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_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;

Line 4568: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_ERROR');

4564: ||l_txn_category||' t_low_level_code ' ||p_low_level_code
4565: ||' error('||l_error_code||') '||l_error_msg
4566: );
4567: END IF;
4568: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_ERROR');
4569: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
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);

Line 4569: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);

4565: ||' error('||l_error_code||') '||l_error_msg
4566: );
4567: END IF;
4568: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_ERROR');
4569: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
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;

Line 4570: FND_MESSAGE.set_token('MESSAGE', 'CSTPPWAC.update_item_cppb for CG '|| p_cost_group_id ||' txn category '

4566: );
4567: END IF;
4568: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_ERROR');
4569: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
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;

Line 4581: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_ERROR');

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);
4584: FND_MSG_PUB.Add;
4585: RAISE FND_API.G_EXC_ERROR;

Line 4582: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);

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);
4584: FND_MSG_PUB.Add;
4585: RAISE FND_API.G_EXC_ERROR;
4586: END Group2_Interorg_Iteration1;

Line 4583: FND_MESSAGE.set_token('MESSAGE', '('||SQLCODE||') '||SQLERRM);

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);
4584: FND_MSG_PUB.Add;
4585: RAISE FND_API.G_EXC_ERROR;
4586: END Group2_Interorg_Iteration1;
4587: -- +========================================================================+

Line 5365: FND_MESSAGE.Set_Name('BOM', 'CST_PAC_DIVERGE_WARNING');

5361: WHEN l_diverging_exception THEN
5362: -- Just a warning. No need to raise an exception. The process can continue for other cost groups for the item.
5363: l_cost_group_id_idx := p_cost_group_id;
5364: l_cost_group_name := CST_PAC_ITERATION_PROCESS_PVT.G_CST_GROUP_TBL(l_cost_group_id_idx).cost_group;
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

Line 5366: FND_MESSAGE.set_token('ITEM', p_inventory_item_number);

5362: -- Just a warning. No need to raise an exception. The process can continue for other cost groups for the item.
5363: l_cost_group_id_idx := p_cost_group_id;
5364: l_cost_group_name := CST_PAC_ITERATION_PROCESS_PVT.G_CST_GROUP_TBL(l_cost_group_id_idx).cost_group;
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;

Line 5367: FND_MESSAGE.set_token('COSTGROUP', l_cost_group_name);

5363: l_cost_group_id_idx := p_cost_group_id;
5364: l_cost_group_name := CST_PAC_ITERATION_PROCESS_PVT.G_CST_GROUP_TBL(l_cost_group_id_idx).cost_group;
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

Line 5368: fnd_file.put_line(FND_FILE.OUTPUT, FND_MESSAGE.GET);

5364: l_cost_group_name := CST_PAC_ITERATION_PROCESS_PVT.G_CST_GROUP_TBL(l_cost_group_id_idx).cost_group;
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

Line 5378: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_ERROR');

5374: , G_MODULE_HEAD || l_routine ||'.others_exc'
5375: , 'others:' || SQLCODE || substr(SQLERRM, 1,200)
5376: );
5377: END IF;
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;

Line 5379: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);

5375: , 'others:' || SQLCODE || substr(SQLERRM, 1,200)
5376: );
5377: END IF;
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;

Line 5380: FND_MESSAGE.set_token('MESSAGE', '('||SQLCODE||') '||SQLERRM);

5376: );
5377: END IF;
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:

Line 5906: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_ERROR');

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);
5909: FND_MSG_PUB.Add;
5910: RAISE FND_API.G_EXC_ERROR;

Line 5907: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);

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);
5909: FND_MSG_PUB.Add;
5910: RAISE FND_API.G_EXC_ERROR;
5911: END Iteration_Process;

Line 5908: FND_MESSAGE.set_token('MESSAGE', '('||SQLCODE||') '||SQLERRM);

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);
5909: FND_MSG_PUB.Add;
5910: RAISE FND_API.G_EXC_ERROR;
5911: END Iteration_Process;
5912: