DBA Data[Home] [Help]

APPS.CST_PERIODIC_ABSORPTION_PROC dependencies on FND_MSG_PUB

Line 153: FND_MSG_PUB.Add;

149: ELSE
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:

Line 257: FND_MSG_PUB.Add;

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);
257: FND_MSG_PUB.Add;
258: RAISE FND_API.G_EXC_ERROR;
259: END get_phase_status;
260:
261: -- =========================================================================

Line 411: FND_MSG_PUB.Add;

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

Line 510: FND_MSG_PUB.Add;

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

Line 713: FND_MSG_PUB.Add;

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

Line 815: FND_MSG_PUB.Add;

811:
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:

Line 954: FND_MSG_PUB.Add;

950: , p_prg_id => p_prg_id
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:

Line 1074: FND_MSG_PUB.Add;

1070: l_message := FND_MESSAGE.GET;
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

Line 1193: FND_MSG_PUB.Add;

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

Line 1201: FND_MSG_PUB.Add;

1197: -- All other run options: 2 - Resume for Error, 3 - Resume for non tolerance
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:

Line 1375: FND_MSG_PUB.Add;

1371: l_message := FND_MESSAGE.GET;
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

Line 1483: FND_MSG_PUB.Add;

1479: l_message := FND_MESSAGE.GET;
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

Line 1552: FND_MSG_PUB.Add;

1548: l_message := FND_MESSAGE.GET;
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;

Line 1620: FND_MSG_PUB.Add;

1616: l_message := FND_MESSAGE.GET;
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

Line 1676: FND_MSG_PUB.Add;

1672: l_message := FND_MESSAGE.GET;
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)

Line 1693: FND_MSG_PUB.Add;

1689: l_message := FND_MESSAGE.GET;
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

Line 2375: FND_MSG_PUB.Add;

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

Line 2511: FND_MSG_PUB.Add;

2507: THEN
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:

Line 2541: FND_MSG_PUB.Add;

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

Line 2547: FND_MSG_PUB.Add;

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);
2547: FND_MSG_PUB.Add;
2548: RAISE FND_API.G_EXC_ERROR;
2549:
2550: END Process_Gp2_Other_Txns;
2551:

Line 2699: FND_MSG_PUB.Add;

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);
2699: FND_MSG_PUB.Add;
2700: RAISE FND_API.G_EXC_ERROR;
2701: END Process_Comp_Items;
2702:
2703:

Line 2905: FND_MSG_PUB.Add;

2901: WHEN OTHERS THEN
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');

Line 2912: FND_MSG_PUB.Add;

2908:
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:

Line 2998: FND_MSG_PUB.Add;

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);
2998: FND_MSG_PUB.Add;
2999: RAISE FND_API.G_EXC_ERROR;
3000:
3001: END Get_Absorption_Level_Of_Items;
3002:

Line 3304: FND_MSG_PUB.Add;

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

Line 3315: FND_MSG_PUB.Add;

3311: , 'Backdated Trasactions exist. Rerun the processor with run options Start');
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;

Line 3388: FND_MSG_PUB.Add;

3384: IF l_error_num <> 0 THEN
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;

Line 3417: FND_MSG_PUB.Add;

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);
3417: FND_MSG_PUB.Add;
3418: RAISE FND_API.G_EXC_ERROR;
3419: END Insert_Ending_Balance_All_Cgs;
3420:
3421: --=========================================================================

Line 4119: FND_MSG_PUB.Add;

4115: COMMIT;
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:

Line 4266: FND_MSG_PUB.Add;

4262: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_ERROR');
4263: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
4264: FND_MESSAGE.set_token('MESSAGE', 'CSTPPINV.cost_acct_events for cost group '||p_cost_group_id||' logical txn id '||l_logical_txn_tab(i).transaction_id
4265: ||' item id '||l_logical_txn_tab(i).inventory_item_id||' org id '||l_logical_txn_tab(i).organization_id||' ('||l_error_code||') '||l_error_msg);
4266: FND_MSG_PUB.Add;
4267: -- Set Phase 5 status to Error
4268: CST_PAC_ITERATION_PROCESS_PVT.Set_Phase5_Status(p_legal_entity_id => p_legal_entity_id
4269: ,p_period_id => p_period_id
4270: ,p_period_end_date => p_end_date

Line 4302: FND_MSG_PUB.Add;

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);
4302: FND_MSG_PUB.Add;
4303: RAISE FND_API.G_EXC_ERROR;
4304: END process_logical_txns;
4305:
4306: --========================================================================

Line 4351: FND_MSG_PUB.Add;

4347: IF G_REQUEST_TABLE(i).phase_status = 3 THEN
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;

Line 4450: FND_MSG_PUB.Add;

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

Line 4480: FND_MSG_PUB.Add;

4476: l_message := fnd_message.get;
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);

Line 4611: FND_MSG_PUB.Add;

4607: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_ERROR');
4608: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
4609: FND_MESSAGE.set_token('MESSAGE', 'CST_MGD_LIFO_COST_PROCESSOR.Lifo_Cost_Processor for cost group '||
4610: p_cg_tab(l_current_index).cost_group_id||' ('||l_error_code||') '||l_error_msg);
4611: FND_MSG_PUB.Add;
4612: -- Set Phase 5 status to Error
4613: CST_PAC_ITERATION_PROCESS_PVT.Set_Phase5_Status(p_legal_entity_id => p_legal_entity
4614: ,p_period_id => p_period_id
4615: ,p_period_end_date => p_end_date

Line 4663: FND_MSG_PUB.Add;

4659: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_ERROR');
4660: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
4661: FND_MESSAGE.set_token('MESSAGE', 'CSTPPWCL.process_wip_close_txns for cost group '||
4662: p_cg_tab(l_current_index).cost_group_id||' ('||l_error_code||') '||l_error_msg);
4663: FND_MSG_PUB.Add;
4664: -- Set Phase 5 status to Error
4665: CST_PAC_ITERATION_PROCESS_PVT.Set_Phase5_Status(p_legal_entity_id => p_legal_entity
4666: ,p_period_id => p_period_id
4667: ,p_period_end_date => p_end_date

Line 4786: FND_MSG_PUB.Initialize;

4782: );
4783: END IF;
4784:
4785: -- initialize the message stack
4786: FND_MSG_PUB.Initialize;
4787:
4788: -- Getting Program Information
4789: l_prg_appid := FND_GLOBAL.prog_appl_id;
4790: l_prg_id := FND_GLOBAL.conc_program_id;

Line 5029: FND_MSG_PUB.Count_And_Get

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
5032: ,p_data => l_msg_data
5033: );

Line 5047: FND_MSG_PUB.Count_And_Get

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