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_PERIODIC_ABSORPTION_PROC dependencies on FND_API

Line 134: WHEN FND_API.G_EXC_ERROR THEN

130: ,l_routine || '>'
131: );
132: END IF;
133: EXCEPTION
134: WHEN FND_API.G_EXC_ERROR THEN
135: RAISE FND_API.G_EXC_ERROR;
136: WHEN OTHERS THEN /* to catch overflow exception */
137: IF g_loop_flag = 0 THEN
138: g_loop_flag := 1;

Line 135: RAISE FND_API.G_EXC_ERROR;

131: );
132: END IF;
133: EXCEPTION
134: WHEN FND_API.G_EXC_ERROR THEN
135: RAISE FND_API.G_EXC_ERROR;
136: WHEN OTHERS THEN /* to catch overflow exception */
137: IF g_loop_flag = 0 THEN
138: g_loop_flag := 1;
139: G_EXPENSE_FLAG_CACHE.DELETE;

Line 154: RAISE FND_API.G_EXC_ERROR;

150: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_ERROR');
151: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
152: FND_MESSAGE.set_token('MESSAGE', '('||SQLCODE||') '||SQLERRM);
153: FND_MSG_PUB.Add;
154: RAISE FND_API.G_EXC_ERROR;
155: END IF;
156: END get_exp_flag;
157:
158: -- +========================================================================+

Line 251: WHEN FND_API.G_EXC_ERROR THEN

247: );
248: END IF;
249:
250: EXCEPTION
251: WHEN FND_API.G_EXC_ERROR THEN
252: RAISE FND_API.G_EXC_ERROR;
253: WHEN OTHERS THEN
254: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_ERROR');
255: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);

Line 252: RAISE FND_API.G_EXC_ERROR;

248: END IF;
249:
250: EXCEPTION
251: WHEN FND_API.G_EXC_ERROR THEN
252: RAISE FND_API.G_EXC_ERROR;
253: WHEN OTHERS THEN
254: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_ERROR');
255: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
256: FND_MESSAGE.set_token('MESSAGE', '('||SQLCODE||') '||SQLERRM);

Line 258: RAISE FND_API.G_EXC_ERROR;

254: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_ERROR');
255: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
256: FND_MESSAGE.set_token('MESSAGE', '('||SQLCODE||') '||SQLERRM);
257: FND_MSG_PUB.Add;
258: RAISE FND_API.G_EXC_ERROR;
259: END get_phase_status;
260:
261: -- =========================================================================
262: -- FUNCTION Find_Prev_Process_Upto_Date PRIVATE

Line 412: RAISE FND_API.G_EXC_ERROR;

408: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
409: FND_MESSAGE.set_token('MESSAGE', 'process_nonreworkassembly_txns for cost group '||p_cost_group_id||' item id '
410: ||p_inventory_item_id||' ('||l_error_code||') '||l_error_msg);
411: FND_MSG_PUB.Add;
412: RAISE FND_API.G_EXC_ERROR;
413:
414: END IF;
415:
416:

Line 511: RAISE FND_API.G_EXC_ERROR;

507: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
508: FND_MESSAGE.set_token('MESSAGE', 'CSTPPWAS.process_reworkassembly_txns for cost group '||p_cost_group_id||' item id '
509: ||p_inventory_item_id||' ('||l_error_code||') '||l_error_msg);
510: FND_MSG_PUB.Add;
511: RAISE FND_API.G_EXC_ERROR;
512:
513: END IF;
514:
515:

Line 714: RAISE FND_API.G_EXC_ERROR;

710: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
711: FND_MESSAGE.set_token('MESSAGE', 'cost_inv_txn for cost group '||p_cost_group_id||' txn id '
712: ||l_upd_val_txn_tab(i).transaction_id||' ('||l_error_code||') '||l_error_msg);
713: FND_MSG_PUB.Add;
714: RAISE FND_API.G_EXC_ERROR;
715: END IF;
716: END LOOP; -- FOR i IN 1..l_loop_count
717:
718: EXIT WHEN upd_val_csr_type_level%NOTFOUND;

Line 816: RAISE FND_API.G_EXC_ERROR;

812: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_ERROR');
813: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
814: FND_MESSAGE.set_token('MESSAGE', 'Error for cost group '||p_cost_group_id||' ('||l_error_code||') '||l_error_msg);
815: FND_MSG_PUB.Add;
816: RAISE FND_API.G_EXC_ERROR;
817: END IF;
818:
819:
820: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 955: RAISE FND_API.G_EXC_ERROR;

951: , p_prg_appid => p_prg_appid);
952:
953: FND_MESSAGE.Set_Name('BOM', 'CST_PAC_PROCESS_DATE_ACQ');
954: FND_MSG_PUB.Add;
955: RAISE FND_API.G_EXC_ERROR;
956:
957: END IF;
958:
959: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 1075: RAISE FND_API.G_EXC_ERROR;

1071: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_ERROR');
1072: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
1073: FND_MESSAGE.set_token('MESSAGE', l_message);
1074: FND_MSG_PUB.Add;
1075: RAISE FND_API.G_EXC_ERROR;
1076: END IF;
1077:
1078: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1079: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

Line 1194: RAISE FND_API.G_EXC_ERROR;

1190:
1191: IF l_count = 0 THEN
1192: FND_MESSAGE.Set_Name('BOM', 'CST_PAC_PROCESS_DATE_ERROR');
1193: FND_MSG_PUB.Add;
1194: RAISE FND_API.G_EXC_ERROR;
1195: END IF;
1196: ELSE
1197: -- All other run options: 2 - Resume for Error, 3 - Resume for non tolerance
1198: -- , 4 - Final process upto date should be NULL

Line 1202: RAISE FND_API.G_EXC_ERROR;

1198: -- , 4 - Final process upto date should be NULL
1199: IF p_process_upto_date IS NOT NULL THEN
1200: FND_MESSAGE.Set_Name('BOM', 'CST_PAC_PROCESS_DATE_NULL');
1201: FND_MSG_PUB.Add;
1202: RAISE FND_API.G_EXC_ERROR;
1203: END IF;
1204: END IF; -- run options check
1205:
1206: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 1376: RAISE FND_API.G_EXC_ERROR;

1372: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_ERROR');
1373: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
1374: FND_MESSAGE.set_token('MESSAGE', l_message);
1375: FND_MSG_PUB.Add;
1376: RAISE FND_API.G_EXC_ERROR;
1377: END IF;
1378:
1379: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1380: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

Line 1484: RAISE FND_API.G_EXC_ERROR;

1480: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_ERROR');
1481: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
1482: FND_MESSAGE.set_token('MESSAGE', l_message);
1483: FND_MSG_PUB.Add;
1484: RAISE FND_API.G_EXC_ERROR;
1485: END IF;
1486:
1487: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1488: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

Line 1553: RAISE FND_API.G_EXC_ERROR;

1549: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_ERROR');
1550: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
1551: FND_MESSAGE.set_token('MESSAGE', l_message);
1552: FND_MSG_PUB.Add;
1553: RAISE FND_API.G_EXC_ERROR;
1554: END IF;
1555:
1556: END IF;
1557:

Line 1621: RAISE FND_API.G_EXC_ERROR;

1617: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_ERROR');
1618: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
1619: FND_MESSAGE.set_token('MESSAGE', l_message);
1620: FND_MSG_PUB.Add;
1621: RAISE FND_API.G_EXC_ERROR;
1622: END IF;
1623:
1624: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1625: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

Line 1677: RAISE FND_API.G_EXC_ERROR;

1673: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_ERROR');
1674: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
1675: FND_MESSAGE.set_token('MESSAGE', l_message);
1676: FND_MSG_PUB.Add;
1677: RAISE FND_API.G_EXC_ERROR;
1678: END IF;
1679:
1680: SELECT count(1)
1681: INTO l_count

Line 1694: RAISE FND_API.G_EXC_ERROR;

1690: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_ERROR');
1691: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
1692: FND_MESSAGE.set_token('MESSAGE', l_message);
1693: FND_MSG_PUB.Add;
1694: RAISE FND_API.G_EXC_ERROR;
1695: END IF;
1696:
1697: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1698: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

Line 2376: RAISE FND_API.G_EXC_ERROR;

2372: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
2373: FND_MESSAGE.set_token('MESSAGE', 'Error in insert/update cpbb for cost group id '
2374: ||p_cg_tab(l_current_index).cost_group_id||' ( '||l_error_code||' ) '||l_error_msg);
2375: FND_MSG_PUB.Add;
2376: RAISE FND_API.G_EXC_ERROR;
2377: END IF;
2378: END IF;
2379:
2380: IF l_error_num = 0 THEN

Line 2512: RAISE FND_API.G_EXC_ERROR;

2508: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_ERROR');
2509: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
2510: FND_MESSAGE.set_token('MESSAGE', 'Error in insert/update cpbb for cost group id '||p_cg_tab(l_current_index).cost_group_id||' ( '||l_error_code||' ) '||l_error_msg);
2511: FND_MSG_PUB.Add;
2512: RAISE FND_API.G_EXC_ERROR;
2513: END IF;
2514:
2515:
2516: EXIT WHEN l_current_index = p_cg_tab.LAST;

Line 2529: WHEN FND_API.G_EXC_ERROR THEN

2525: );
2526: END IF;
2527:
2528: EXCEPTION
2529: WHEN FND_API.G_EXC_ERROR THEN
2530: RAISE FND_API.G_EXC_ERROR;
2531: WHEN group2_other_except THEN
2532: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2533: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION

Line 2530: RAISE FND_API.G_EXC_ERROR;

2526: END IF;
2527:
2528: EXCEPTION
2529: WHEN FND_API.G_EXC_ERROR THEN
2530: RAISE FND_API.G_EXC_ERROR;
2531: WHEN group2_other_except THEN
2532: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2533: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION
2534: , G_MODULE_HEAD || l_routine || '.group2_other_exc'

Line 2542: RAISE FND_API.G_EXC_ERROR;

2538: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_ERROR');
2539: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
2540: FND_MESSAGE.set_token('MESSAGE', 'group2_other_exc for txn_id '||error_transaction_id|| l_error_code || l_error_msg);
2541: FND_MSG_PUB.Add;
2542: RAISE FND_API.G_EXC_ERROR;
2543: WHEN OTHERS THEN
2544: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_ERROR');
2545: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
2546: FND_MESSAGE.set_token('MESSAGE', '('||SQLCODE||') '||SQLERRM);

Line 2548: RAISE FND_API.G_EXC_ERROR;

2544: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_ERROR');
2545: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
2546: FND_MESSAGE.set_token('MESSAGE', '('||SQLCODE||') '||SQLERRM);
2547: FND_MSG_PUB.Add;
2548: RAISE FND_API.G_EXC_ERROR;
2549:
2550: END Process_Gp2_Other_Txns;
2551:
2552:

Line 2693: WHEN FND_API.G_EXC_ERROR THEN

2689: ,l_routine || '>'
2690: );
2691: END IF;
2692: EXCEPTION
2693: WHEN FND_API.G_EXC_ERROR THEN
2694: RAISE FND_API.G_EXC_ERROR;
2695: WHEN OTHERS THEN
2696: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_ERROR');
2697: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);

Line 2694: RAISE FND_API.G_EXC_ERROR;

2690: );
2691: END IF;
2692: EXCEPTION
2693: WHEN FND_API.G_EXC_ERROR THEN
2694: RAISE FND_API.G_EXC_ERROR;
2695: WHEN OTHERS THEN
2696: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_ERROR');
2697: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
2698: FND_MESSAGE.set_token('MESSAGE', '('||SQLCODE||') '||SQLERRM);

Line 2700: RAISE FND_API.G_EXC_ERROR;

2696: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_ERROR');
2697: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
2698: FND_MESSAGE.set_token('MESSAGE', '('||SQLCODE||') '||SQLERRM);
2699: FND_MSG_PUB.Add;
2700: RAISE FND_API.G_EXC_ERROR;
2701: END Process_Comp_Items;
2702:
2703:
2704: --=========================================================================

Line 2906: RAISE FND_API.G_EXC_ERROR;

2902: FND_MESSAGE.Set_Name('BOM', 'CST_PAC_ABS_DEAD_LOCK');
2903: FND_MESSAGE.Set_token('ABS_CODE', l_absorption_level_code);
2904: FND_MESSAGE.set_token('ITEMS', l_dead_lock_message);
2905: FND_MSG_PUB.Add;
2906: RAISE FND_API.G_EXC_ERROR;
2907: END;
2908:
2909: FND_MESSAGE.Set_Name('BOM', 'CST_PAC_ABS_DEAD_LOCK');
2910: FND_MESSAGE.Set_token('ABS_CODE', l_absorption_level_code);

Line 2913: RAISE FND_API.G_EXC_ERROR;

2909: FND_MESSAGE.Set_Name('BOM', 'CST_PAC_ABS_DEAD_LOCK');
2910: FND_MESSAGE.Set_token('ABS_CODE', l_absorption_level_code);
2911: FND_MESSAGE.set_token('ITEMS', l_dead_lock_message);
2912: FND_MSG_PUB.Add;
2913: RAISE FND_API.G_EXC_ERROR;
2914: END IF;
2915:
2916:
2917: WHILE (items_in_current_absl_cur%FOUND) LOOP

Line 2992: WHEN FND_API.G_EXC_ERROR THEN

2988: END IF;
2989:
2990:
2991: EXCEPTION
2992: WHEN FND_API.G_EXC_ERROR THEN
2993: RAISE FND_API.G_EXC_ERROR;
2994: WHEN OTHERS THEN
2995: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_ERROR');
2996: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);

Line 2993: RAISE FND_API.G_EXC_ERROR;

2989:
2990:
2991: EXCEPTION
2992: WHEN FND_API.G_EXC_ERROR THEN
2993: RAISE FND_API.G_EXC_ERROR;
2994: WHEN OTHERS THEN
2995: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_ERROR');
2996: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
2997: FND_MESSAGE.set_token('MESSAGE', '('||SQLCODE||') '||SQLERRM);

Line 2999: RAISE FND_API.G_EXC_ERROR;

2995: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_ERROR');
2996: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
2997: FND_MESSAGE.set_token('MESSAGE', '('||SQLCODE||') '||SQLERRM);
2998: FND_MSG_PUB.Add;
2999: RAISE FND_API.G_EXC_ERROR;
3000:
3001: END Get_Absorption_Level_Of_Items;
3002:
3003: --========================================================================

Line 3305: RAISE FND_API.G_EXC_ERROR;

3301: END IF;
3302:
3303: FND_MESSAGE.Set_Name('BOM', 'CST_PAC_PENDING_TXN');
3304: FND_MSG_PUB.Add;
3305: RAISE FND_API.G_EXC_ERROR;
3306:
3307: WHEN l_backdated_txns_except THEN
3308: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3309: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION

Line 3316: RAISE FND_API.G_EXC_ERROR;

3312: END IF;
3313:
3314: FND_MESSAGE.Set_Name('BOM', 'CST_PAC_BACKDATED_TXN');
3315: FND_MSG_PUB.Add;
3316: RAISE FND_API.G_EXC_ERROR;
3317:
3318:
3319: END Validate_Uncosted_Txns;
3320:

Line 3389: RAISE FND_API.G_EXC_ERROR;

3385: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_ERROR');
3386: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
3387: FND_MESSAGE.set_token('MESSAGE', 'Error in CSTPPWAC.insert_ending_balance for cost group id '||p_cg_tab(l_cg_idx).cost_group_id||' ( '||l_error_code||' ) '||l_error_msg);
3388: FND_MSG_PUB.Add;
3389: RAISE FND_API.G_EXC_ERROR;
3390: END IF;
3391:
3392: EXIT WHEN l_cg_idx = p_cg_tab.LAST;
3393:

Line 3411: WHEN FND_API.G_EXC_ERROR THEN

3407: );
3408: END IF;
3409:
3410: EXCEPTION
3411: WHEN FND_API.G_EXC_ERROR THEN
3412: RAISE FND_API.G_EXC_ERROR;
3413: WHEN OTHERS THEN
3414: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_ERROR');
3415: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);

Line 3412: RAISE FND_API.G_EXC_ERROR;

3408: END IF;
3409:
3410: EXCEPTION
3411: WHEN FND_API.G_EXC_ERROR THEN
3412: RAISE FND_API.G_EXC_ERROR;
3413: WHEN OTHERS THEN
3414: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_ERROR');
3415: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
3416: FND_MESSAGE.set_token('MESSAGE', '('||SQLCODE||') '||SQLERRM);

Line 3418: RAISE FND_API.G_EXC_ERROR;

3414: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_ERROR');
3415: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
3416: FND_MESSAGE.set_token('MESSAGE', '('||SQLCODE||') '||SQLERRM);
3417: FND_MSG_PUB.Add;
3418: RAISE FND_API.G_EXC_ERROR;
3419: END Insert_Ending_Balance_All_Cgs;
3420:
3421: --=========================================================================
3422: -- PROCEDURE : Absorption_Cost_Process PRIVATE

Line 3517: l_init_msg_list VARCHAR2(1) := FND_API.G_TRUE;

3513: l_message VARCHAR2(2000);
3514:
3515:
3516: -- Variables for Iteration Process
3517: l_init_msg_list VARCHAR2(1) := FND_API.G_TRUE;
3518: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;
3519: l_iteration_proc_flag VARCHAR2(1);
3520:
3521: l_cg_idx BINARY_INTEGER;

Line 3518: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;

3514:
3515:
3516: -- Variables for Iteration Process
3517: l_init_msg_list VARCHAR2(1) := FND_API.G_TRUE;
3518: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;
3519: l_iteration_proc_flag VARCHAR2(1);
3520:
3521: l_cg_idx BINARY_INTEGER;
3522: l_cost_update_type NUMBER;

Line 4096: WHEN FND_API.G_EXC_ERROR THEN

4092: );
4093: END IF;
4094:
4095: EXCEPTION
4096: WHEN FND_API.G_EXC_ERROR THEN
4097: ROLLBACK;
4098: -- Set Phase 7 Status to error
4099: CST_PAC_ITERATION_PROCESS_PVT.Set_Process_Status(p_legal_entity_id => p_legal_entity
4100: ,p_period_id => p_period_id

Line 4105: RAISE FND_API.G_EXC_ERROR;

4101: ,p_period_end_date => p_end_date
4102: ,p_phase_status => 3
4103: );
4104: COMMIT;
4105: RAISE FND_API.G_EXC_ERROR;
4106:
4107: WHEN OTHERS THEN
4108: ROLLBACK;
4109: -- Set Phase 7 Status to error

Line 4120: RAISE FND_API.G_EXC_ERROR;

4116: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_ERROR');
4117: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
4118: FND_MESSAGE.set_token('MESSAGE', '('||SQLCODE||') '||SQLERRM);
4119: FND_MSG_PUB.Add;
4120: RAISE FND_API.G_EXC_ERROR;
4121:
4122: END Absorption_Cost_Process;
4123:
4124: -- =======================================================================

Line 4273: RAISE FND_API.G_EXC_ERROR;

4269: ,p_period_id => p_period_id
4270: ,p_period_end_date => p_end_date
4271: ,p_phase_status => 3
4272: );
4273: RAISE FND_API.G_EXC_ERROR;
4274: END IF;
4275:
4276:
4277: END LOOP;

Line 4296: WHEN FND_API.G_EXC_ERROR THEN

4292: END IF;
4293:
4294:
4295: EXCEPTION
4296: WHEN FND_API.G_EXC_ERROR THEN
4297: RAISE FND_API.G_EXC_ERROR;
4298: WHEN OTHERS THEN
4299: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_ERROR');
4300: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);

Line 4297: RAISE FND_API.G_EXC_ERROR;

4293:
4294:
4295: EXCEPTION
4296: WHEN FND_API.G_EXC_ERROR THEN
4297: RAISE FND_API.G_EXC_ERROR;
4298: WHEN OTHERS THEN
4299: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_ERROR');
4300: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
4301: FND_MESSAGE.set_token('MESSAGE', '('||SQLCODE||') '||SQLERRM);

Line 4303: RAISE FND_API.G_EXC_ERROR;

4299: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_ERROR');
4300: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
4301: FND_MESSAGE.set_token('MESSAGE', '('||SQLCODE||') '||SQLERRM);
4302: FND_MSG_PUB.Add;
4303: RAISE FND_API.G_EXC_ERROR;
4304: END process_logical_txns;
4305:
4306: --========================================================================
4307: -- PROCEDURE : GET_OPEN_REQUESTS_COUNT

Line 4352: RAISE FND_API.G_EXC_ERROR;

4348: FND_MESSAGE.Set_Name('BOM', 'CST_PAC_AVG_WORKER_ERROR');
4349: FND_MESSAGE.set_token('CG_ID', G_REQUEST_TABLE(i).cost_group_id);
4350: FND_MESSAGE.set_token('REQUEST_ID', G_REQUEST_TABLE(i).request_id);
4351: FND_MSG_PUB.Add;
4352: RAISE FND_API.G_EXC_ERROR;
4353: END IF;
4354: ELSE
4355: l_count := l_count + 1;
4356: END IF;

Line 4451: RAISE FND_API.G_EXC_ERROR;

4447: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
4448: FND_MESSAGE.set_token('MESSAGE', 'Run Options Resume for Tolerance and Final cannot be chosen since the cost group '
4449: ||p_cg_tab(l_current_index).cost_group_id||' has not completed one of previous phases');
4450: FND_MSG_PUB.Add;
4451: RAISE FND_API.G_EXC_ERROR;
4452: END IF;
4453:
4454: IF p_run_options < 3 AND (p_cg_tab(l_current_index).starting_phase < 5 OR p_cg_tab(l_current_index).starting_phase = 8) THEN
4455: -- submit concurrent request. Run Options should never be greater than 2 for these concurrent requests

Line 4481: RAISE FND_API.G_EXC_ERROR;

4477: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_ERROR');
4478: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
4479: FND_MESSAGE.set_token('MESSAGE', 'Unable to submit request for Iterative PAC Worker '||l_message);
4480: FND_MSG_PUB.Add;
4481: RAISE FND_API.G_EXC_ERROR;
4482: END IF;
4483: -- store the request id in G_REQUEST_TABLE
4484: fnd_file.put_line(FND_FILE.LOG, 'Request Id for Cost Group ' || p_cg_tab(l_current_index).cost_group_id ||' : '||l_submit_req_id);
4485: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 4618: RAISE FND_API.G_EXC_ERROR;

4614: ,p_period_id => p_period_id
4615: ,p_period_end_date => p_end_date
4616: ,p_phase_status => 3
4617: );
4618: RAISE FND_API.G_EXC_ERROR;
4619: END IF;
4620:
4621: END IF;
4622:

Line 4670: RAISE FND_API.G_EXC_ERROR;

4666: ,p_period_id => p_period_id
4667: ,p_period_end_date => p_end_date
4668: ,p_phase_status => 3
4669: );
4670: RAISE FND_API.G_EXC_ERROR;
4671: END IF;
4672:
4673:
4674: EXIT WHEN l_current_index = p_cg_tab.LAST;

Line 4766: l_init_msg_list VARCHAR2(1) := FND_API.G_TRUE;

4762: -- Material Relief Algorithm - R12 enhancement
4763: l_mat_relief_algorithm NUMBER;
4764:
4765: -- Variables for Iteration Process
4766: l_init_msg_list VARCHAR2(1) := FND_API.G_TRUE;
4767: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;
4768: l_return_status VARCHAR2(1);
4769: l_msg_count NUMBER;
4770: l_msg_data VARCHAR2(2000);

Line 4767: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;

4763: l_mat_relief_algorithm NUMBER;
4764:
4765: -- Variables for Iteration Process
4766: l_init_msg_list VARCHAR2(1) := FND_API.G_TRUE;
4767: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;
4768: l_return_status VARCHAR2(1);
4769: l_msg_count NUMBER;
4770: l_msg_data VARCHAR2(2000);
4771: l_error_msg VARCHAR2(2000);

Line 5021: x_return_status := FND_API.G_RET_STS_SUCCESS;

5017: ,l_routine || '>'
5018: );
5019: END IF;
5020:
5021: x_return_status := FND_API.G_RET_STS_SUCCESS;
5022:
5023: EXCEPTION
5024: WHEN FND_API.G_EXC_ERROR THEN
5025: IF l_error_msg IS NOT NULL THEN

Line 5024: WHEN FND_API.G_EXC_ERROR THEN

5020:
5021: x_return_status := FND_API.G_RET_STS_SUCCESS;
5022:
5023: EXCEPTION
5024: WHEN FND_API.G_EXC_ERROR THEN
5025: IF l_error_msg IS NOT NULL THEN
5026: x_msg_data := l_error_msg;
5027: x_return_status := FND_API.G_RET_STS_ERROR;
5028: ELSE

Line 5027: x_return_status := FND_API.G_RET_STS_ERROR;

5023: EXCEPTION
5024: WHEN FND_API.G_EXC_ERROR THEN
5025: IF l_error_msg IS NOT NULL THEN
5026: x_msg_data := l_error_msg;
5027: x_return_status := FND_API.G_RET_STS_ERROR;
5028: ELSE
5029: FND_MSG_PUB.Count_And_Get
5030: (p_encoded => FND_API.G_FALSE
5031: ,p_count => x_msg_count

Line 5030: (p_encoded => FND_API.G_FALSE

5026: x_msg_data := l_error_msg;
5027: x_return_status := FND_API.G_RET_STS_ERROR;
5028: ELSE
5029: FND_MSG_PUB.Count_And_Get
5030: (p_encoded => FND_API.G_FALSE
5031: ,p_count => x_msg_count
5032: ,p_data => l_msg_data
5033: );
5034: x_return_status := FND_API.G_RET_STS_ERROR;

Line 5034: x_return_status := FND_API.G_RET_STS_ERROR;

5030: (p_encoded => FND_API.G_FALSE
5031: ,p_count => x_msg_count
5032: ,p_data => l_msg_data
5033: );
5034: x_return_status := FND_API.G_RET_STS_ERROR;
5035: x_msg_data := l_msg_data;
5036: END IF;
5037:
5038: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 5046: x_return_status := FND_API.G_RET_STS_ERROR;

5042: END IF;
5043:
5044: WHEN OTHERS THEN
5045: x_msg_data := SQLCODE || substr(SQLERRM, 1, 200);
5046: x_return_status := FND_API.G_RET_STS_ERROR;
5047: FND_MSG_PUB.Count_And_Get
5048: (p_encoded => FND_API.G_FALSE
5049: ,p_count => x_msg_count
5050: ,p_data => l_msg_data

Line 5048: (p_encoded => FND_API.G_FALSE

5044: WHEN OTHERS THEN
5045: x_msg_data := SQLCODE || substr(SQLERRM, 1, 200);
5046: x_return_status := FND_API.G_RET_STS_ERROR;
5047: FND_MSG_PUB.Count_And_Get
5048: (p_encoded => FND_API.G_FALSE
5049: ,p_count => x_msg_count
5050: ,p_data => l_msg_data
5051: );
5052: