DBA Data[Home] [Help]

APPS.CST_PERIODIC_ABSORPTION_PROC dependencies on FND_MSG_PUB

Line 237: FND_MSG_PUB.Add;

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);
237: FND_MSG_PUB.Add;
238: RAISE FND_API.G_EXC_ERROR;
239: END get_phase_status;
240:
241: -- =========================================================================

Line 391: FND_MSG_PUB.Add;

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

Line 490: FND_MSG_PUB.Add;

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

Line 693: FND_MSG_PUB.Add;

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

Line 811: FND_MSG_PUB.Add;

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

Line 952: FND_MSG_PUB.Add;

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

Line 1072: FND_MSG_PUB.Add;

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

Line 1191: FND_MSG_PUB.Add;

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

Line 1199: FND_MSG_PUB.Add;

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

Line 1373: FND_MSG_PUB.Add;

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

Line 1481: FND_MSG_PUB.Add;

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

Line 1550: FND_MSG_PUB.Add;

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

Line 1618: FND_MSG_PUB.Add;

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

Line 1674: FND_MSG_PUB.Add;

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

Line 1691: FND_MSG_PUB.Add;

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

Line 2373: FND_MSG_PUB.Add;

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

Line 2509: FND_MSG_PUB.Add;

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

Line 2539: FND_MSG_PUB.Add;

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

Line 2545: FND_MSG_PUB.Add;

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

Line 2697: FND_MSG_PUB.Add;

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

Line 2960: FND_MSG_PUB.Add;

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

Line 2967: FND_MSG_PUB.Add;

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

Line 3053: FND_MSG_PUB.Add;

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);
3053: FND_MSG_PUB.Add;
3054: RAISE FND_API.G_EXC_ERROR;
3055:
3056: END Get_Absorption_Level_Of_Items;
3057:

Line 3359: FND_MSG_PUB.Add;

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

Line 3370: FND_MSG_PUB.Add;

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

Line 3443: FND_MSG_PUB.Add;

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

Line 3472: FND_MSG_PUB.Add;

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);
3472: FND_MSG_PUB.Add;
3473: RAISE FND_API.G_EXC_ERROR;
3474: END Insert_Ending_Balance_All_Cgs;
3475:
3476: --=========================================================================

Line 4092: FND_MSG_PUB.Add;

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

Line 4211: FND_MSG_PUB.Add;

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

Line 4488: FND_MSG_PUB.Add;

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

Line 4635: FND_MSG_PUB.Add;

4631: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_ERROR');
4632: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
4633: 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
4634: ||' 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);
4635: FND_MSG_PUB.Add;
4636: -- Set Phase 5 status to Error
4637: CST_PAC_ITERATION_PROCESS_PVT.Set_Phase5_Status(p_legal_entity_id => p_legal_entity_id
4638: ,p_period_id => p_period_id
4639: ,p_period_end_date => p_end_date

Line 4671: FND_MSG_PUB.Add;

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);
4671: FND_MSG_PUB.Add;
4672: RAISE FND_API.G_EXC_ERROR;
4673: END process_logical_txns;
4674:
4675: --========================================================================

Line 4720: FND_MSG_PUB.Add;

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

Line 4819: FND_MSG_PUB.Add;

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

Line 4849: FND_MSG_PUB.Add;

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

Line 4980: FND_MSG_PUB.Add;

4976: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_ERROR');
4977: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
4978: FND_MESSAGE.set_token('MESSAGE', 'CST_MGD_LIFO_COST_PROCESSOR.Lifo_Cost_Processor for cost group '||
4979: p_cg_tab(l_current_index).cost_group_id||' ('||l_error_code||') '||l_error_msg);
4980: FND_MSG_PUB.Add;
4981: -- Set Phase 5 status to Error
4982: CST_PAC_ITERATION_PROCESS_PVT.Set_Phase5_Status(p_legal_entity_id => p_legal_entity
4983: ,p_period_id => p_period_id
4984: ,p_period_end_date => p_end_date

Line 5032: FND_MSG_PUB.Add;

5028: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_ERROR');
5029: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
5030: FND_MESSAGE.set_token('MESSAGE', 'CSTPPWCL.process_wip_close_txns for cost group '||
5031: p_cg_tab(l_current_index).cost_group_id||' ('||l_error_code||') '||l_error_msg);
5032: FND_MSG_PUB.Add;
5033: -- Set Phase 5 status to Error
5034: CST_PAC_ITERATION_PROCESS_PVT.Set_Phase5_Status(p_legal_entity_id => p_legal_entity
5035: ,p_period_id => p_period_id
5036: ,p_period_end_date => p_end_date

Line 5155: FND_MSG_PUB.Initialize;

5151: );
5152: END IF;
5153:
5154: -- initialize the message stack
5155: FND_MSG_PUB.Initialize;
5156:
5157: -- Getting Program Information
5158: l_prg_appid := FND_GLOBAL.prog_appl_id;
5159: l_prg_id := FND_GLOBAL.conc_program_id;

Line 5398: FND_MSG_PUB.Count_And_Get

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
5401: ,p_data => l_msg_data
5402: );

Line 5416: FND_MSG_PUB.Count_And_Get

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