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

227: );
228: END IF;
229:
230: EXCEPTION
231: WHEN FND_API.G_EXC_ERROR THEN
232: RAISE FND_API.G_EXC_ERROR;
233: WHEN OTHERS THEN
234: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_ERROR');
235: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);

Line 232: RAISE FND_API.G_EXC_ERROR;

228: END IF;
229:
230: EXCEPTION
231: WHEN FND_API.G_EXC_ERROR THEN
232: RAISE FND_API.G_EXC_ERROR;
233: WHEN OTHERS THEN
234: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_ERROR');
235: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
236: FND_MESSAGE.set_token('MESSAGE', '('||SQLCODE||') '||SQLERRM);

Line 238: RAISE FND_API.G_EXC_ERROR;

234: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_ERROR');
235: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
236: FND_MESSAGE.set_token('MESSAGE', '('||SQLCODE||') '||SQLERRM);
237: FND_MSG_PUB.Add;
238: RAISE FND_API.G_EXC_ERROR;
239: END get_phase_status;
240:
241: -- =========================================================================
242: -- FUNCTION Find_Prev_Process_Upto_Date PRIVATE

Line 392: RAISE FND_API.G_EXC_ERROR;

388: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
389: FND_MESSAGE.set_token('MESSAGE', 'process_nonreworkassembly_txns for cost group '||p_cost_group_id||' item id '
390: ||p_inventory_item_id||' ('||l_error_code||') '||l_error_msg);
391: FND_MSG_PUB.Add;
392: RAISE FND_API.G_EXC_ERROR;
393:
394: END IF;
395:
396:

Line 491: RAISE FND_API.G_EXC_ERROR;

487: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
488: FND_MESSAGE.set_token('MESSAGE', 'CSTPPWAS.process_reworkassembly_txns for cost group '||p_cost_group_id||' item id '
489: ||p_inventory_item_id||' ('||l_error_code||') '||l_error_msg);
490: FND_MSG_PUB.Add;
491: RAISE FND_API.G_EXC_ERROR;
492:
493: END IF;
494:
495:

Line 694: RAISE FND_API.G_EXC_ERROR;

690: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
691: FND_MESSAGE.set_token('MESSAGE', 'cost_inv_txn for cost group '||p_cost_group_id||' txn id '
692: ||l_upd_val_txn_tab(i).transaction_id||' ('||l_error_code||') '||l_error_msg);
693: FND_MSG_PUB.Add;
694: RAISE FND_API.G_EXC_ERROR;
695: END IF;
696: END LOOP; -- FOR i IN 1..l_loop_count
697:
698: EXIT WHEN upd_val_csr_type_level%NOTFOUND;

Line 812: RAISE FND_API.G_EXC_ERROR;

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

Line 953: RAISE FND_API.G_EXC_ERROR;

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

Line 1073: RAISE FND_API.G_EXC_ERROR;

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

Line 1192: RAISE FND_API.G_EXC_ERROR;

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

Line 1200: RAISE FND_API.G_EXC_ERROR;

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

Line 1374: RAISE FND_API.G_EXC_ERROR;

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

Line 1482: RAISE FND_API.G_EXC_ERROR;

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

Line 1551: RAISE FND_API.G_EXC_ERROR;

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

Line 1619: RAISE FND_API.G_EXC_ERROR;

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

Line 1675: RAISE FND_API.G_EXC_ERROR;

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

Line 1692: RAISE FND_API.G_EXC_ERROR;

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

Line 2374: RAISE FND_API.G_EXC_ERROR;

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

Line 2510: RAISE FND_API.G_EXC_ERROR;

2506: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_ERROR');
2507: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
2508: 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);
2509: FND_MSG_PUB.Add;
2510: RAISE FND_API.G_EXC_ERROR;
2511: END IF;
2512:
2513:
2514: EXIT WHEN l_current_index = p_cg_tab.LAST;

Line 2527: WHEN FND_API.G_EXC_ERROR THEN

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

Line 2528: RAISE FND_API.G_EXC_ERROR;

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

Line 2540: RAISE FND_API.G_EXC_ERROR;

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

Line 2546: RAISE FND_API.G_EXC_ERROR;

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

Line 2691: WHEN FND_API.G_EXC_ERROR THEN

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

Line 2692: RAISE FND_API.G_EXC_ERROR;

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

Line 2698: RAISE FND_API.G_EXC_ERROR;

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

Line 2961: RAISE FND_API.G_EXC_ERROR;

2957: FND_MESSAGE.Set_Name('BOM', 'CST_PAC_ABS_DEAD_LOCK');
2958: FND_MESSAGE.Set_token('ABS_CODE', l_absorption_level_code);
2959: FND_MESSAGE.set_token('ITEMS', l_dead_lock_message);
2960: FND_MSG_PUB.Add;
2961: RAISE FND_API.G_EXC_ERROR;
2962: END;
2963:
2964: FND_MESSAGE.Set_Name('BOM', 'CST_PAC_ABS_DEAD_LOCK');
2965: FND_MESSAGE.Set_token('ABS_CODE', l_absorption_level_code);

Line 2968: RAISE FND_API.G_EXC_ERROR;

2964: FND_MESSAGE.Set_Name('BOM', 'CST_PAC_ABS_DEAD_LOCK');
2965: FND_MESSAGE.Set_token('ABS_CODE', l_absorption_level_code);
2966: FND_MESSAGE.set_token('ITEMS', l_dead_lock_message);
2967: FND_MSG_PUB.Add;
2968: RAISE FND_API.G_EXC_ERROR;
2969: END IF;
2970:
2971:
2972: WHILE (items_in_current_absl_cur%FOUND) LOOP

Line 3047: WHEN FND_API.G_EXC_ERROR THEN

3043: END IF;
3044:
3045:
3046: EXCEPTION
3047: WHEN FND_API.G_EXC_ERROR THEN
3048: RAISE FND_API.G_EXC_ERROR;
3049: WHEN OTHERS THEN
3050: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_ERROR');
3051: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);

Line 3048: RAISE FND_API.G_EXC_ERROR;

3044:
3045:
3046: EXCEPTION
3047: WHEN FND_API.G_EXC_ERROR THEN
3048: RAISE FND_API.G_EXC_ERROR;
3049: WHEN OTHERS THEN
3050: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_ERROR');
3051: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
3052: FND_MESSAGE.set_token('MESSAGE', '('||SQLCODE||') '||SQLERRM);

Line 3054: RAISE FND_API.G_EXC_ERROR;

3050: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_ERROR');
3051: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
3052: FND_MESSAGE.set_token('MESSAGE', '('||SQLCODE||') '||SQLERRM);
3053: FND_MSG_PUB.Add;
3054: RAISE FND_API.G_EXC_ERROR;
3055:
3056: END Get_Absorption_Level_Of_Items;
3057:
3058: --========================================================================

Line 3360: RAISE FND_API.G_EXC_ERROR;

3356: END IF;
3357:
3358: FND_MESSAGE.Set_Name('BOM', 'CST_PAC_PENDING_TXN');
3359: FND_MSG_PUB.Add;
3360: RAISE FND_API.G_EXC_ERROR;
3361:
3362: WHEN l_backdated_txns_except THEN
3363: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3364: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION

Line 3371: RAISE FND_API.G_EXC_ERROR;

3367: END IF;
3368:
3369: FND_MESSAGE.Set_Name('BOM', 'CST_PAC_BACKDATED_TXN');
3370: FND_MSG_PUB.Add;
3371: RAISE FND_API.G_EXC_ERROR;
3372:
3373:
3374: END Validate_Uncosted_Txns;
3375:

Line 3444: RAISE FND_API.G_EXC_ERROR;

3440: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_ERROR');
3441: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
3442: 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);
3443: FND_MSG_PUB.Add;
3444: RAISE FND_API.G_EXC_ERROR;
3445: END IF;
3446:
3447: EXIT WHEN l_cg_idx = p_cg_tab.LAST;
3448:

Line 3466: WHEN FND_API.G_EXC_ERROR THEN

3462: );
3463: END IF;
3464:
3465: EXCEPTION
3466: WHEN FND_API.G_EXC_ERROR THEN
3467: RAISE FND_API.G_EXC_ERROR;
3468: WHEN OTHERS THEN
3469: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_ERROR');
3470: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);

Line 3467: RAISE FND_API.G_EXC_ERROR;

3463: END IF;
3464:
3465: EXCEPTION
3466: WHEN FND_API.G_EXC_ERROR THEN
3467: RAISE FND_API.G_EXC_ERROR;
3468: WHEN OTHERS THEN
3469: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_ERROR');
3470: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
3471: FND_MESSAGE.set_token('MESSAGE', '('||SQLCODE||') '||SQLERRM);

Line 3473: RAISE FND_API.G_EXC_ERROR;

3469: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_ERROR');
3470: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
3471: FND_MESSAGE.set_token('MESSAGE', '('||SQLCODE||') '||SQLERRM);
3472: FND_MSG_PUB.Add;
3473: RAISE FND_API.G_EXC_ERROR;
3474: END Insert_Ending_Balance_All_Cgs;
3475:
3476: --=========================================================================
3477: -- FUNCTION : Check_For_No_Interorg_CG PRIVATE

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

3651: l_message VARCHAR2(2000);
3652:
3653:
3654: -- Variables for Iteration Process
3655: l_init_msg_list VARCHAR2(1) := FND_API.G_TRUE;
3656: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;
3657: l_iteration_proc_flag VARCHAR2(1);
3658:
3659: l_cg_idx BINARY_INTEGER;

Line 3656: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;

3652:
3653:
3654: -- Variables for Iteration Process
3655: l_init_msg_list VARCHAR2(1) := FND_API.G_TRUE;
3656: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;
3657: l_iteration_proc_flag VARCHAR2(1);
3658:
3659: l_cg_idx BINARY_INTEGER;
3660: l_cost_update_type NUMBER;

Line 4093: RAISE FND_API.G_EXC_ERROR;

4089: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_ERROR');
4090: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
4091: FND_MESSAGE.set_token('MESSAGE', 'Error for cost group '||p_cg_tab(l_cg_idx).cost_group_id||' ('||l_error_code||') '||l_error_msg);
4092: FND_MSG_PUB.Add;
4093: RAISE FND_API.G_EXC_ERROR;
4094: END IF;
4095:
4096: END IF;
4097:

Line 4212: RAISE FND_API.G_EXC_ERROR;

4208: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_ERROR');
4209: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
4210: FND_MESSAGE.set_token('MESSAGE', 'Error for cost group '||p_cg_tab(l_cg_idx).cost_group_id||' ('||l_error_code||') '||l_error_msg);
4211: FND_MSG_PUB.Add;
4212: RAISE FND_API.G_EXC_ERROR;
4213: END IF;
4214:
4215: END IF;
4216:

Line 4465: WHEN FND_API.G_EXC_ERROR THEN

4461: );
4462: END IF;
4463:
4464: EXCEPTION
4465: WHEN FND_API.G_EXC_ERROR THEN
4466: ROLLBACK;
4467: -- Set Phase 7 Status to error
4468: CST_PAC_ITERATION_PROCESS_PVT.Set_Process_Status(p_legal_entity_id => p_legal_entity
4469: ,p_period_id => p_period_id

Line 4474: RAISE FND_API.G_EXC_ERROR;

4470: ,p_period_end_date => p_end_date
4471: ,p_phase_status => 3
4472: );
4473: COMMIT;
4474: RAISE FND_API.G_EXC_ERROR;
4475:
4476: WHEN OTHERS THEN
4477: ROLLBACK;
4478: -- Set Phase 7 Status to error

Line 4489: RAISE FND_API.G_EXC_ERROR;

4485: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_ERROR');
4486: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
4487: FND_MESSAGE.set_token('MESSAGE', '('||SQLCODE||') '||SQLERRM);
4488: FND_MSG_PUB.Add;
4489: RAISE FND_API.G_EXC_ERROR;
4490:
4491: END Absorption_Cost_Process;
4492:
4493: -- =======================================================================

Line 4642: RAISE FND_API.G_EXC_ERROR;

4638: ,p_period_id => p_period_id
4639: ,p_period_end_date => p_end_date
4640: ,p_phase_status => 3
4641: );
4642: RAISE FND_API.G_EXC_ERROR;
4643: END IF;
4644:
4645:
4646: END LOOP;

Line 4665: WHEN FND_API.G_EXC_ERROR THEN

4661: END IF;
4662:
4663:
4664: EXCEPTION
4665: WHEN FND_API.G_EXC_ERROR THEN
4666: RAISE FND_API.G_EXC_ERROR;
4667: WHEN OTHERS THEN
4668: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_ERROR');
4669: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);

Line 4666: RAISE FND_API.G_EXC_ERROR;

4662:
4663:
4664: EXCEPTION
4665: WHEN FND_API.G_EXC_ERROR THEN
4666: RAISE FND_API.G_EXC_ERROR;
4667: WHEN OTHERS THEN
4668: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_ERROR');
4669: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
4670: FND_MESSAGE.set_token('MESSAGE', '('||SQLCODE||') '||SQLERRM);

Line 4672: RAISE FND_API.G_EXC_ERROR;

4668: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_ERROR');
4669: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
4670: FND_MESSAGE.set_token('MESSAGE', '('||SQLCODE||') '||SQLERRM);
4671: FND_MSG_PUB.Add;
4672: RAISE FND_API.G_EXC_ERROR;
4673: END process_logical_txns;
4674:
4675: --========================================================================
4676: -- PROCEDURE : GET_OPEN_REQUESTS_COUNT

Line 4721: RAISE FND_API.G_EXC_ERROR;

4717: FND_MESSAGE.Set_Name('BOM', 'CST_PAC_AVG_WORKER_ERROR');
4718: FND_MESSAGE.set_token('CG_ID', G_REQUEST_TABLE(i).cost_group_id);
4719: FND_MESSAGE.set_token('REQUEST_ID', G_REQUEST_TABLE(i).request_id);
4720: FND_MSG_PUB.Add;
4721: RAISE FND_API.G_EXC_ERROR;
4722: END IF;
4723: ELSE
4724: l_count := l_count + 1;
4725: END IF;

Line 4820: RAISE FND_API.G_EXC_ERROR;

4816: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
4817: FND_MESSAGE.set_token('MESSAGE', 'Run Options Resume for Tolerance and Final cannot be chosen since the cost group '
4818: ||p_cg_tab(l_current_index).cost_group_id||' has not completed one of previous phases');
4819: FND_MSG_PUB.Add;
4820: RAISE FND_API.G_EXC_ERROR;
4821: END IF;
4822:
4823: 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
4824: -- submit concurrent request. Run Options should never be greater than 2 for these concurrent requests

Line 4850: RAISE FND_API.G_EXC_ERROR;

4846: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_ERROR');
4847: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
4848: FND_MESSAGE.set_token('MESSAGE', 'Unable to submit request for Iterative PAC Worker '||l_message);
4849: FND_MSG_PUB.Add;
4850: RAISE FND_API.G_EXC_ERROR;
4851: END IF;
4852: -- store the request id in G_REQUEST_TABLE
4853: 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);
4854: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 4987: RAISE FND_API.G_EXC_ERROR;

4983: ,p_period_id => p_period_id
4984: ,p_period_end_date => p_end_date
4985: ,p_phase_status => 3
4986: );
4987: RAISE FND_API.G_EXC_ERROR;
4988: END IF;
4989:
4990: END IF;
4991:

Line 5039: RAISE FND_API.G_EXC_ERROR;

5035: ,p_period_id => p_period_id
5036: ,p_period_end_date => p_end_date
5037: ,p_phase_status => 3
5038: );
5039: RAISE FND_API.G_EXC_ERROR;
5040: END IF;
5041:
5042:
5043: EXIT WHEN l_current_index = p_cg_tab.LAST;

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

5131: -- Material Relief Algorithm - R12 enhancement
5132: l_mat_relief_algorithm NUMBER;
5133:
5134: -- Variables for Iteration Process
5135: l_init_msg_list VARCHAR2(1) := FND_API.G_TRUE;
5136: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;
5137: l_return_status VARCHAR2(1);
5138: l_msg_count NUMBER;
5139: l_msg_data VARCHAR2(2000);

Line 5136: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;

5132: l_mat_relief_algorithm NUMBER;
5133:
5134: -- Variables for Iteration Process
5135: l_init_msg_list VARCHAR2(1) := FND_API.G_TRUE;
5136: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;
5137: l_return_status VARCHAR2(1);
5138: l_msg_count NUMBER;
5139: l_msg_data VARCHAR2(2000);
5140: l_error_msg VARCHAR2(2000);

Line 5390: x_return_status := FND_API.G_RET_STS_SUCCESS;

5386: ,l_routine || '>'
5387: );
5388: END IF;
5389:
5390: x_return_status := FND_API.G_RET_STS_SUCCESS;
5391:
5392: EXCEPTION
5393: WHEN FND_API.G_EXC_ERROR THEN
5394: IF l_error_msg IS NOT NULL THEN

Line 5393: WHEN FND_API.G_EXC_ERROR THEN

5389:
5390: x_return_status := FND_API.G_RET_STS_SUCCESS;
5391:
5392: EXCEPTION
5393: WHEN FND_API.G_EXC_ERROR THEN
5394: IF l_error_msg IS NOT NULL THEN
5395: x_msg_data := l_error_msg;
5396: x_return_status := FND_API.G_RET_STS_ERROR;
5397: ELSE

Line 5396: x_return_status := FND_API.G_RET_STS_ERROR;

5392: EXCEPTION
5393: WHEN FND_API.G_EXC_ERROR THEN
5394: IF l_error_msg IS NOT NULL THEN
5395: x_msg_data := l_error_msg;
5396: x_return_status := FND_API.G_RET_STS_ERROR;
5397: ELSE
5398: FND_MSG_PUB.Count_And_Get
5399: (p_encoded => FND_API.G_FALSE
5400: ,p_count => x_msg_count

Line 5399: (p_encoded => FND_API.G_FALSE

5395: x_msg_data := l_error_msg;
5396: x_return_status := FND_API.G_RET_STS_ERROR;
5397: ELSE
5398: FND_MSG_PUB.Count_And_Get
5399: (p_encoded => FND_API.G_FALSE
5400: ,p_count => x_msg_count
5401: ,p_data => l_msg_data
5402: );
5403: x_return_status := FND_API.G_RET_STS_ERROR;

Line 5403: x_return_status := FND_API.G_RET_STS_ERROR;

5399: (p_encoded => FND_API.G_FALSE
5400: ,p_count => x_msg_count
5401: ,p_data => l_msg_data
5402: );
5403: x_return_status := FND_API.G_RET_STS_ERROR;
5404: x_msg_data := l_msg_data;
5405: END IF;
5406:
5407: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 5415: x_return_status := FND_API.G_RET_STS_ERROR;

5411: END IF;
5412:
5413: WHEN OTHERS THEN
5414: x_msg_data := SQLCODE || substr(SQLERRM, 1, 200);
5415: x_return_status := FND_API.G_RET_STS_ERROR;
5416: FND_MSG_PUB.Count_And_Get
5417: (p_encoded => FND_API.G_FALSE
5418: ,p_count => x_msg_count
5419: ,p_data => l_msg_data

Line 5417: (p_encoded => FND_API.G_FALSE

5413: WHEN OTHERS THEN
5414: x_msg_data := SQLCODE || substr(SQLERRM, 1, 200);
5415: x_return_status := FND_API.G_RET_STS_ERROR;
5416: FND_MSG_PUB.Count_And_Get
5417: (p_encoded => FND_API.G_FALSE
5418: ,p_count => x_msg_count
5419: ,p_data => l_msg_data
5420: );
5421: