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_MESSAGE

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

146: );
147: x_exp_flag := l_exp_flag;
148: x_exp_item := l_exp_item;
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;

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

147: x_exp_flag := l_exp_flag;
148: x_exp_item := l_exp_item;
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;

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

148: x_exp_item := l_exp_item;
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;

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

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);
257: FND_MSG_PUB.Add;
258: RAISE FND_API.G_EXC_ERROR;

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

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

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

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

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

403: ||p_inventory_item_id||' ('||l_error_code||') '||l_error_msg
404: );
405: END IF;
406:
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;

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

404: );
405: END IF;
406:
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;

Line 409: FND_MESSAGE.set_token('MESSAGE', 'process_nonreworkassembly_txns for cost group '||p_cost_group_id||' item id '

405: END IF;
406:
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:

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

502: l_error_msg := NVL(l_error_msg, 'No Error');
503:
504: IF l_error_num <> 0
505: THEN
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;

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

503:
504: IF l_error_num <> 0
505: THEN
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;

Line 508: FND_MESSAGE.set_token('MESSAGE', 'CSTPPWAS.process_reworkassembly_txns for cost group '||p_cost_group_id||' item id '

504: IF l_error_num <> 0
505: THEN
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:

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

705: ||l_upd_val_txn_tab(i).transaction_id||' ('||l_error_code||') '||l_error_msg
706: );
707: END IF;
708:
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;

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

706: );
707: END IF;
708:
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;

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

707: END IF;
708:
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;

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

808: , 'Error for cost group '||p_cost_group_id||' ('||l_error_code||') '||l_error_msg
809: );
810: END IF;
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;

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

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

Line 814: FND_MESSAGE.set_token('MESSAGE', 'Error for cost group '||p_cost_group_id||' ('||l_error_code||') '||l_error_msg);

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

Line 953: FND_MESSAGE.Set_Name('BOM', 'CST_PAC_PROCESS_DATE_ACQ');

949: , p_req_id => p_req_id
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;

Line 1068: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_SOL_MST');

1064:
1065: x_master_org_id := l_master_org_id;
1066:
1067: ELSE
1068: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_SOL_MST');
1069: FND_MESSAGE.set_token('CSTGRP', p_cost_group_id);
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);

Line 1069: FND_MESSAGE.set_token('CSTGRP', p_cost_group_id);

1065: x_master_org_id := l_master_org_id;
1066:
1067: ELSE
1068: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_SOL_MST');
1069: FND_MESSAGE.set_token('CSTGRP', p_cost_group_id);
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);

Line 1070: l_message := FND_MESSAGE.GET;

1066:
1067: ELSE
1068: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_SOL_MST');
1069: FND_MESSAGE.set_token('CSTGRP', p_cost_group_id);
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;

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

1067: ELSE
1068: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_SOL_MST');
1069: FND_MESSAGE.set_token('CSTGRP', p_cost_group_id);
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;

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

1068: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_SOL_MST');
1069: FND_MESSAGE.set_token('CSTGRP', p_cost_group_id);
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;

Line 1073: FND_MESSAGE.set_token('MESSAGE', l_message);

1069: FND_MESSAGE.set_token('CSTGRP', p_cost_group_id);
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:

Line 1192: FND_MESSAGE.Set_Name('BOM', 'CST_PAC_PROCESS_DATE_ERROR');

1188: , ' Count of Periods in the range:' || l_count
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

Line 1200: FND_MESSAGE.Set_Name('BOM', 'CST_PAC_PROCESS_DATE_NULL');

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

Line 1369: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_VAL_CG');

1365: AND cppp.pac_period_id = p_period_id);
1366:
1367: IF l_count = 0
1368: THEN
1369: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_VAL_CG');
1370: FND_MESSAGE.set_token('CSTGRP', p_cost_group_id);
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);

Line 1370: FND_MESSAGE.set_token('CSTGRP', p_cost_group_id);

1366:
1367: IF l_count = 0
1368: THEN
1369: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_VAL_CG');
1370: FND_MESSAGE.set_token('CSTGRP', p_cost_group_id);
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);

Line 1371: l_message := FND_MESSAGE.GET;

1367: IF l_count = 0
1368: THEN
1369: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_VAL_CG');
1370: FND_MESSAGE.set_token('CSTGRP', p_cost_group_id);
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;

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

1368: THEN
1369: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_VAL_CG');
1370: FND_MESSAGE.set_token('CSTGRP', p_cost_group_id);
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;

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

1369: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_VAL_CG');
1370: FND_MESSAGE.set_token('CSTGRP', p_cost_group_id);
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;

Line 1374: FND_MESSAGE.set_token('MESSAGE', l_message);

1370: FND_MESSAGE.set_token('CSTGRP', p_cost_group_id);
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:

Line 1478: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_VAL_PHS_SED');

1474: AND pac_period_id = p_period_id;
1475:
1476: IF l_count <> 8
1477: THEN
1478: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_VAL_PHS_SED');
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);

Line 1479: l_message := FND_MESSAGE.GET;

1475:
1476: IF l_count <> 8
1477: THEN
1478: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_VAL_PHS_SED');
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;

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

1476: IF l_count <> 8
1477: THEN
1478: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_VAL_PHS_SED');
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;

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

1477: THEN
1478: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_VAL_PHS_SED');
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;

Line 1482: FND_MESSAGE.set_token('MESSAGE', l_message);

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

Line 1547: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_VAL_PRE_PER');

1543: AND cpp.open_flag = 'N'
1544: AND cpp.period_close_date IS NOT NULL;
1545:
1546: IF l_period_closed = 0 THEN
1547: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_VAL_PRE_PER');
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);

Line 1548: l_message := FND_MESSAGE.GET;

1544: AND cpp.period_close_date IS NOT NULL;
1545:
1546: IF l_period_closed = 0 THEN
1547: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_VAL_PRE_PER');
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;

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

1545:
1546: IF l_period_closed = 0 THEN
1547: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_VAL_PRE_PER');
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;

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

1546: IF l_period_closed = 0 THEN
1547: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_VAL_PRE_PER');
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;

Line 1551: FND_MESSAGE.set_token('MESSAGE', l_message);

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

Line 1615: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_VAL_CUR_PER');

1611: AND cpp.period_close_date IS NULL;
1612:
1613: IF l_count = 0
1614: THEN
1615: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_VAL_CUR_PER');
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);

Line 1616: l_message := FND_MESSAGE.GET;

1612:
1613: IF l_count = 0
1614: THEN
1615: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_VAL_CUR_PER');
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;

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

1613: IF l_count = 0
1614: THEN
1615: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_VAL_CUR_PER');
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;

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

1614: THEN
1615: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_VAL_CUR_PER');
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;

Line 1619: FND_MESSAGE.set_token('MESSAGE', l_message);

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

Line 1671: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_VAL_CT');

1667: AND trunc(nvl(cct.disable_date, SYSDATE+1)) > trunc(SYSDATE);
1668:
1669: IF l_count = 0
1670: THEN
1671: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_VAL_CT');
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);

Line 1672: l_message := FND_MESSAGE.GET;

1668:
1669: IF l_count = 0
1670: THEN
1671: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_VAL_CT');
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;

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

1669: IF l_count = 0
1670: THEN
1671: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_VAL_CT');
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;

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

1670: THEN
1671: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_VAL_CT');
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;

Line 1675: FND_MESSAGE.set_token('MESSAGE', l_message);

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

Line 1688: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_VAL_LE_CT');

1684: AND clct.cost_type_id = p_cost_type_id;
1685:
1686: IF l_count = 0
1687: THEN
1688: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_VAL_LE_CT');
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);

Line 1689: l_message := FND_MESSAGE.GET;

1685:
1686: IF l_count = 0
1687: THEN
1688: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_VAL_LE_CT');
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;

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

1686: IF l_count = 0
1687: THEN
1688: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_VAL_LE_CT');
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;

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

1687: THEN
1688: FND_MESSAGE.Set_Name('BOM', 'CST_INTERORG_PAC_VAL_LE_CT');
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;

Line 1692: FND_MESSAGE.set_token('MESSAGE', l_message);

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

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

2367: );
2368: END IF;
2369:
2370: IF l_error_num <> 0 THEN
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;

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

2368: END IF;
2369:
2370: IF l_error_num <> 0 THEN
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;

Line 2373: FND_MESSAGE.set_token('MESSAGE', 'Error in insert/update cpbb for cost group id '

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

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

2504: END IF;
2505:
2506: IF l_error_num <> 0
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;

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

2505:
2506: IF l_error_num <> 0
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;

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

2506: IF l_error_num <> 0
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:

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

2534: , G_MODULE_HEAD || l_routine || '.group2_other_exc'
2535: , 'group2_other_exc for txn_id '||error_transaction_id || l_error_code || l_error_msg
2536: );
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;

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

2535: , 'group2_other_exc for txn_id '||error_transaction_id || l_error_code || l_error_msg
2536: );
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

Line 2540: FND_MESSAGE.set_token('MESSAGE', 'group2_other_exc for txn_id '||error_transaction_id|| l_error_code || l_error_msg);

2536: );
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');

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

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);
2547: FND_MSG_PUB.Add;
2548: RAISE FND_API.G_EXC_ERROR;

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

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

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

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

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

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);
2699: FND_MSG_PUB.Add;
2700: RAISE FND_API.G_EXC_ERROR;

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

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

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

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

Line 2902: FND_MESSAGE.Set_Name('BOM', 'CST_PAC_ABS_DEAD_LOCK');

2898: CLOSE items_in_deadlock_cur;
2899:
2900: EXCEPTION
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;

Line 2903: FND_MESSAGE.Set_token('ABS_CODE', l_absorption_level_code);

2899:
2900: EXCEPTION
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;

Line 2904: FND_MESSAGE.set_token('ITEMS', l_dead_lock_message);

2900: EXCEPTION
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:

Line 2909: FND_MESSAGE.Set_Name('BOM', 'CST_PAC_ABS_DEAD_LOCK');

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);
2911: FND_MESSAGE.set_token('ITEMS', l_dead_lock_message);
2912: FND_MSG_PUB.Add;
2913: RAISE FND_API.G_EXC_ERROR;

Line 2910: FND_MESSAGE.Set_token('ABS_CODE', l_absorption_level_code);

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

Line 2911: FND_MESSAGE.set_token('ITEMS', l_dead_lock_message);

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

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

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);
2998: FND_MSG_PUB.Add;
2999: RAISE FND_API.G_EXC_ERROR;

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

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

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

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

Line 3303: FND_MESSAGE.Set_Name('BOM', 'CST_PAC_PENDING_TXN');

3299: , 'Rerun the processor with run options Start'
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

Line 3314: FND_MESSAGE.Set_Name('BOM', 'CST_PAC_BACKDATED_TXN');

3310: , G_MODULE_HEAD || l_routine || '.backdated_exc'
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:

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

3381: l_error_code := NVL(l_error_code, 'No Error');
3382: l_error_msg := NVL(l_error_msg, 'No Error');
3383:
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;

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

3382: l_error_msg := NVL(l_error_msg, 'No Error');
3383:
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;

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

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

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

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);
3417: FND_MSG_PUB.Add;
3418: RAISE FND_API.G_EXC_ERROR;

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

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

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

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

Line 3539: FND_MESSAGE.Set_Name('BOM', 'CST_PAC_OUTPUT_MESSAGE');

3535: CST_PAC_ITERATION_PROCESS_PVT.Initialize
3536: (p_legal_entity_id => p_legal_entity
3537: );
3538: -- TAB is used as a delimiter in output which can be viewed in spreadsheet application to see the progress through iterations.
3539: FND_MESSAGE.Set_Name('BOM', 'CST_PAC_OUTPUT_MESSAGE');
3540: l_message := FND_MESSAGE.Get;
3541: FND_FILE.put_line(FND_FILE.OUTPUT, l_message);
3542:
3543: FND_MESSAGE.Set_Name('BOM', 'CST_PAC_PMAC_ITR_PROMPT');

Line 3540: l_message := FND_MESSAGE.Get;

3536: (p_legal_entity_id => p_legal_entity
3537: );
3538: -- TAB is used as a delimiter in output which can be viewed in spreadsheet application to see the progress through iterations.
3539: FND_MESSAGE.Set_Name('BOM', 'CST_PAC_OUTPUT_MESSAGE');
3540: l_message := FND_MESSAGE.Get;
3541: FND_FILE.put_line(FND_FILE.OUTPUT, l_message);
3542:
3543: FND_MESSAGE.Set_Name('BOM', 'CST_PAC_PMAC_ITR_PROMPT');
3544: l_message := FND_MESSAGE.Get;

Line 3543: FND_MESSAGE.Set_Name('BOM', 'CST_PAC_PMAC_ITR_PROMPT');

3539: FND_MESSAGE.Set_Name('BOM', 'CST_PAC_OUTPUT_MESSAGE');
3540: l_message := FND_MESSAGE.Get;
3541: FND_FILE.put_line(FND_FILE.OUTPUT, l_message);
3542:
3543: FND_MESSAGE.Set_Name('BOM', 'CST_PAC_PMAC_ITR_PROMPT');
3544: l_message := FND_MESSAGE.Get;
3545: FND_FILE.put_line(FND_FILE.OUTPUT, l_message);
3546: /* Storing the translated messages in global variable since in CST_PAC_ITERATION_PROCESS_PVT.Verify_Tolerance_Of_Item
3547: it need not be translated for each item */

Line 3544: l_message := FND_MESSAGE.Get;

3540: l_message := FND_MESSAGE.Get;
3541: FND_FILE.put_line(FND_FILE.OUTPUT, l_message);
3542:
3543: FND_MESSAGE.Set_Name('BOM', 'CST_PAC_PMAC_ITR_PROMPT');
3544: l_message := FND_MESSAGE.Get;
3545: FND_FILE.put_line(FND_FILE.OUTPUT, l_message);
3546: /* Storing the translated messages in global variable since in CST_PAC_ITERATION_PROCESS_PVT.Verify_Tolerance_Of_Item
3547: it need not be translated for each item */
3548: FND_MESSAGE.SET_NAME('BOM', 'CST_PAC_INTORG_TOLERANCE');

Line 3548: FND_MESSAGE.SET_NAME('BOM', 'CST_PAC_INTORG_TOLERANCE');

3544: l_message := FND_MESSAGE.Get;
3545: FND_FILE.put_line(FND_FILE.OUTPUT, l_message);
3546: /* Storing the translated messages in global variable since in CST_PAC_ITERATION_PROCESS_PVT.Verify_Tolerance_Of_Item
3547: it need not be translated for each item */
3548: FND_MESSAGE.SET_NAME('BOM', 'CST_PAC_INTORG_TOLERANCE');
3549: CST_PAC_ITERATION_PROCESS_PVT.G_TOL_ACHIEVED_MESSAGE := FND_MESSAGE.GET;
3550: FND_MESSAGE.SET_NAME('BOM', 'CST_PAC_INTORG_NO_TOL');
3551: CST_PAC_ITERATION_PROCESS_PVT.G_TOL_NOT_ACHIEVED_MESSAGE := FND_MESSAGE.GET;
3552:

Line 3549: CST_PAC_ITERATION_PROCESS_PVT.G_TOL_ACHIEVED_MESSAGE := FND_MESSAGE.GET;

3545: FND_FILE.put_line(FND_FILE.OUTPUT, l_message);
3546: /* Storing the translated messages in global variable since in CST_PAC_ITERATION_PROCESS_PVT.Verify_Tolerance_Of_Item
3547: it need not be translated for each item */
3548: FND_MESSAGE.SET_NAME('BOM', 'CST_PAC_INTORG_TOLERANCE');
3549: CST_PAC_ITERATION_PROCESS_PVT.G_TOL_ACHIEVED_MESSAGE := FND_MESSAGE.GET;
3550: FND_MESSAGE.SET_NAME('BOM', 'CST_PAC_INTORG_NO_TOL');
3551: CST_PAC_ITERATION_PROCESS_PVT.G_TOL_NOT_ACHIEVED_MESSAGE := FND_MESSAGE.GET;
3552:
3553: -- Get the iteration process flag to check whether an iteration is an

Line 3550: FND_MESSAGE.SET_NAME('BOM', 'CST_PAC_INTORG_NO_TOL');

3546: /* Storing the translated messages in global variable since in CST_PAC_ITERATION_PROCESS_PVT.Verify_Tolerance_Of_Item
3547: it need not be translated for each item */
3548: FND_MESSAGE.SET_NAME('BOM', 'CST_PAC_INTORG_TOLERANCE');
3549: CST_PAC_ITERATION_PROCESS_PVT.G_TOL_ACHIEVED_MESSAGE := FND_MESSAGE.GET;
3550: FND_MESSAGE.SET_NAME('BOM', 'CST_PAC_INTORG_NO_TOL');
3551: CST_PAC_ITERATION_PROCESS_PVT.G_TOL_NOT_ACHIEVED_MESSAGE := FND_MESSAGE.GET;
3552:
3553: -- Get the iteration process flag to check whether an iteration is an
3554: -- optional process

Line 3551: CST_PAC_ITERATION_PROCESS_PVT.G_TOL_NOT_ACHIEVED_MESSAGE := FND_MESSAGE.GET;

3547: it need not be translated for each item */
3548: FND_MESSAGE.SET_NAME('BOM', 'CST_PAC_INTORG_TOLERANCE');
3549: CST_PAC_ITERATION_PROCESS_PVT.G_TOL_ACHIEVED_MESSAGE := FND_MESSAGE.GET;
3550: FND_MESSAGE.SET_NAME('BOM', 'CST_PAC_INTORG_NO_TOL');
3551: CST_PAC_ITERATION_PROCESS_PVT.G_TOL_NOT_ACHIEVED_MESSAGE := FND_MESSAGE.GET;
3552:
3553: -- Get the iteration process flag to check whether an iteration is an
3554: -- optional process
3555:

Line 3995: FND_MESSAGE.Set_Name('BOM', 'CST_PAC_TOL_NOT_ACHIEVED');

3991: , p_period_end_date => p_end_date
3992: , p_phase_status => 5
3993: );
3994:
3995: FND_MESSAGE.Set_Name('BOM', 'CST_PAC_TOL_NOT_ACHIEVED');
3996: fnd_file.put_line(fnd_file.output, fnd_message.get);
3997:
3998: EXIT;
3999:

Line 3996: fnd_file.put_line(fnd_file.output, fnd_message.get);

3992: , p_phase_status => 5
3993: );
3994:
3995: FND_MESSAGE.Set_Name('BOM', 'CST_PAC_TOL_NOT_ACHIEVED');
3996: fnd_file.put_line(fnd_file.output, fnd_message.get);
3997:
3998: EXIT;
3999:
4000: END IF;

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

4112: ,p_period_end_date => p_end_date
4113: ,p_phase_status => 3
4114: );
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;

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

4113: ,p_phase_status => 3
4114: );
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:

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

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

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

4258: ,o_err_msg => l_error_msg
4259: );
4260:
4261: IF l_error_num <> 0 THEN
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;

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

4259: );
4260:
4261: IF l_error_num <> 0 THEN
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

Line 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

4260:
4261: IF l_error_num <> 0 THEN
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

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

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);
4302: FND_MSG_PUB.Add;
4303: RAISE FND_API.G_EXC_ERROR;

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

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

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

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

Line 4348: FND_MESSAGE.Set_Name('BOM', 'CST_PAC_AVG_WORKER_ERROR');

4344: ,x_status => G_REQUEST_TABLE(i).phase_status
4345: );
4346:
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;

Line 4349: FND_MESSAGE.set_token('CG_ID', G_REQUEST_TABLE(i).cost_group_id);

4345: );
4346:
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;

Line 4350: FND_MESSAGE.set_token('REQUEST_ID', G_REQUEST_TABLE(i).request_id);

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

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

4442: );
4443: END IF;
4444:
4445: IF p_run_options > 2 AND p_cg_tab(l_current_index).starting_phase < 5 THEN
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;

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

4443: END IF;
4444:
4445: IF p_run_options > 2 AND p_cg_tab(l_current_index).starting_phase < 5 THEN
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;

Line 4448: FND_MESSAGE.set_token('MESSAGE', 'Run Options Resume for Tolerance and Final cannot be chosen since the cost group '

4444:
4445: IF p_run_options > 2 AND p_cg_tab(l_current_index).starting_phase < 5 THEN
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;

Line 4476: l_message := fnd_message.get;

4472: p_end_date
4473: );
4474: COMMIT;
4475: IF (l_submit_req_id = 0) THEN
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;

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

4473: );
4474: COMMIT;
4475: IF (l_submit_req_id = 0) THEN
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;

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

4474: COMMIT;
4475: IF (l_submit_req_id = 0) THEN
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;

Line 4479: FND_MESSAGE.set_token('MESSAGE', 'Unable to submit request for Iterative PAC Worker '||l_message);

4475: IF (l_submit_req_id = 0) THEN
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

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

4603: ,x_errcode => l_error_code
4604: );
4605:
4606: IF l_return_code <> 0 THEN
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;

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

4604: );
4605:
4606: IF l_return_code <> 0 THEN
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

Line 4609: FND_MESSAGE.set_token('MESSAGE', 'CST_MGD_LIFO_COST_PROCESSOR.Lifo_Cost_Processor for cost group '||

4605:
4606: IF l_return_code <> 0 THEN
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

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

4655: ,x_err_msg => l_error_msg
4656: );
4657:
4658: IF l_error_num <> 0 THEN
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;

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

4656: );
4657:
4658: IF l_error_num <> 0 THEN
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

Line 4661: FND_MESSAGE.set_token('MESSAGE', 'CSTPPWCL.process_wip_close_txns for cost group '||

4657:
4658: IF l_error_num <> 0 THEN
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