DBA Data[Home] [Help]

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 1245: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_ERROR');

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;

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

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:

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

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

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

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;

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

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;

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

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:

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

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;

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

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;

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

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:

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

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;

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

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:

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

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

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

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;

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

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:

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

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

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

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;

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

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:

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

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

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

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;

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

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

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

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:

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

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;

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

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:

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

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;

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

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;

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

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:

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

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;

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

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;

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

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:

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

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;

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

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;

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

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:

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

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;

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

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;

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

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;

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

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:

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

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;

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

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;

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

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:

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

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;

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

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;

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

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;

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

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

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

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;

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

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;

Line 4400: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_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;

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

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;

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

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:

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

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;

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

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;

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

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;

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

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

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

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;

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

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;

Line 4814: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_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;

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

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;

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

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: -- +========================================================================+

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

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

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

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;

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

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

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

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

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

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;

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

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;

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

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:

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

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;

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

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;

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

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: