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

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

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

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

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

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

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

383: ||p_inventory_item_id||' ('||l_error_code||') '||l_error_msg
384: );
385: END IF;
386:
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;

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

384: );
385: END IF;
386:
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;

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

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

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

482: l_error_msg := NVL(l_error_msg, 'No Error');
483:
484: IF l_error_num <> 0
485: THEN
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;

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

483:
484: IF l_error_num <> 0
485: THEN
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;

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

484: IF l_error_num <> 0
485: THEN
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:

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

685: ||l_upd_val_txn_tab(i).transaction_id||' ('||l_error_code||') '||l_error_msg
686: );
687: END IF;
688:
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;

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

686: );
687: END IF;
688:
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;

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

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

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

804: 'txn category:' || p_txn_category || ' ('||l_error_code||') '||l_error_msg
805: );
806: END IF;
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;

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

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

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

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

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

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

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

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

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

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

Line 1068: l_message := FND_MESSAGE.GET;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 1369: l_message := FND_MESSAGE.GET;

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

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

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

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

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

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

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

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

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

Line 1477: l_message := FND_MESSAGE.GET;

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

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

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

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

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

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

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

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

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

Line 1546: l_message := FND_MESSAGE.GET;

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

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

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

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

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

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

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

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

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

Line 1614: l_message := FND_MESSAGE.GET;

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

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

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

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

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

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

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

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

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

Line 1670: l_message := FND_MESSAGE.GET;

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

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

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

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

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

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

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

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

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

Line 1687: l_message := FND_MESSAGE.GET;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

2502: END IF;
2503:
2504: IF l_error_num <> 0
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;

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

2503:
2504: IF l_error_num <> 0
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;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

2953: CLOSE items_in_deadlock_cur;
2954:
2955: EXCEPTION
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;

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

2954:
2955: EXCEPTION
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;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

3436: l_error_code := NVL(l_error_code, 'No Error');
3437: l_error_msg := NVL(l_error_msg, 'No Error');
3438:
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;

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

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

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

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

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

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

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

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

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

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

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

3681: CST_PAC_ITERATION_PROCESS_PVT.Initialize
3682: (p_legal_entity_id => p_legal_entity
3683: );
3684: -- TAB is used as a delimiter in output which can be viewed in spreadsheet application to see the progress through iterations.
3685: FND_MESSAGE.Set_Name('BOM', 'CST_PAC_OUTPUT_MESSAGE');
3686: l_message := FND_MESSAGE.Get;
3687: FND_FILE.put_line(FND_FILE.OUTPUT, l_message);
3688:
3689: FND_MESSAGE.Set_Name('BOM', 'CST_PAC_PMAC_ITR_PROMPT');

Line 3686: l_message := FND_MESSAGE.Get;

3682: (p_legal_entity_id => p_legal_entity
3683: );
3684: -- TAB is used as a delimiter in output which can be viewed in spreadsheet application to see the progress through iterations.
3685: FND_MESSAGE.Set_Name('BOM', 'CST_PAC_OUTPUT_MESSAGE');
3686: l_message := FND_MESSAGE.Get;
3687: FND_FILE.put_line(FND_FILE.OUTPUT, l_message);
3688:
3689: FND_MESSAGE.Set_Name('BOM', 'CST_PAC_PMAC_ITR_PROMPT');
3690: l_message := FND_MESSAGE.Get;

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

3685: FND_MESSAGE.Set_Name('BOM', 'CST_PAC_OUTPUT_MESSAGE');
3686: l_message := FND_MESSAGE.Get;
3687: FND_FILE.put_line(FND_FILE.OUTPUT, l_message);
3688:
3689: FND_MESSAGE.Set_Name('BOM', 'CST_PAC_PMAC_ITR_PROMPT');
3690: l_message := FND_MESSAGE.Get;
3691: FND_FILE.put_line(FND_FILE.OUTPUT, l_message);
3692: /* Storing the translated messages in global variable since in CST_PAC_ITERATION_PROCESS_PVT.Verify_Tolerance_Of_Item
3693: it need not be translated for each item */

Line 3690: l_message := FND_MESSAGE.Get;

3686: l_message := FND_MESSAGE.Get;
3687: FND_FILE.put_line(FND_FILE.OUTPUT, l_message);
3688:
3689: FND_MESSAGE.Set_Name('BOM', 'CST_PAC_PMAC_ITR_PROMPT');
3690: l_message := FND_MESSAGE.Get;
3691: FND_FILE.put_line(FND_FILE.OUTPUT, l_message);
3692: /* Storing the translated messages in global variable since in CST_PAC_ITERATION_PROCESS_PVT.Verify_Tolerance_Of_Item
3693: it need not be translated for each item */
3694: FND_MESSAGE.SET_NAME('BOM', 'CST_PAC_INTORG_TOLERANCE');

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

3690: l_message := FND_MESSAGE.Get;
3691: FND_FILE.put_line(FND_FILE.OUTPUT, l_message);
3692: /* Storing the translated messages in global variable since in CST_PAC_ITERATION_PROCESS_PVT.Verify_Tolerance_Of_Item
3693: it need not be translated for each item */
3694: FND_MESSAGE.SET_NAME('BOM', 'CST_PAC_INTORG_TOLERANCE');
3695: CST_PAC_ITERATION_PROCESS_PVT.G_TOL_ACHIEVED_MESSAGE := FND_MESSAGE.GET;
3696: FND_MESSAGE.SET_NAME('BOM', 'CST_PAC_INTORG_NO_TOL');
3697: CST_PAC_ITERATION_PROCESS_PVT.G_TOL_NOT_ACHIEVED_MESSAGE := FND_MESSAGE.GET;
3698:

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

3691: FND_FILE.put_line(FND_FILE.OUTPUT, l_message);
3692: /* Storing the translated messages in global variable since in CST_PAC_ITERATION_PROCESS_PVT.Verify_Tolerance_Of_Item
3693: it need not be translated for each item */
3694: FND_MESSAGE.SET_NAME('BOM', 'CST_PAC_INTORG_TOLERANCE');
3695: CST_PAC_ITERATION_PROCESS_PVT.G_TOL_ACHIEVED_MESSAGE := FND_MESSAGE.GET;
3696: FND_MESSAGE.SET_NAME('BOM', 'CST_PAC_INTORG_NO_TOL');
3697: CST_PAC_ITERATION_PROCESS_PVT.G_TOL_NOT_ACHIEVED_MESSAGE := FND_MESSAGE.GET;
3698:
3699: -- Get the iteration process flag to check whether an iteration is an

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

3692: /* Storing the translated messages in global variable since in CST_PAC_ITERATION_PROCESS_PVT.Verify_Tolerance_Of_Item
3693: it need not be translated for each item */
3694: FND_MESSAGE.SET_NAME('BOM', 'CST_PAC_INTORG_TOLERANCE');
3695: CST_PAC_ITERATION_PROCESS_PVT.G_TOL_ACHIEVED_MESSAGE := FND_MESSAGE.GET;
3696: FND_MESSAGE.SET_NAME('BOM', 'CST_PAC_INTORG_NO_TOL');
3697: CST_PAC_ITERATION_PROCESS_PVT.G_TOL_NOT_ACHIEVED_MESSAGE := FND_MESSAGE.GET;
3698:
3699: -- Get the iteration process flag to check whether an iteration is an
3700: -- optional process

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

3693: it need not be translated for each item */
3694: FND_MESSAGE.SET_NAME('BOM', 'CST_PAC_INTORG_TOLERANCE');
3695: CST_PAC_ITERATION_PROCESS_PVT.G_TOL_ACHIEVED_MESSAGE := FND_MESSAGE.GET;
3696: FND_MESSAGE.SET_NAME('BOM', 'CST_PAC_INTORG_NO_TOL');
3697: CST_PAC_ITERATION_PROCESS_PVT.G_TOL_NOT_ACHIEVED_MESSAGE := FND_MESSAGE.GET;
3698:
3699: -- Get the iteration process flag to check whether an iteration is an
3700: -- optional process
3701:

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

4085: 'txn category :' || l_txn_category || ' ('||l_error_code||') '||l_error_msg
4086: );
4087: END IF;
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;

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

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

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

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

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

4204: 'txn category :' || l_txn_category || ' ('||l_error_code||') '||l_error_msg
4205: );
4206: END IF;
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;

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

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

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

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

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

4360: , p_period_end_date => p_end_date
4361: , p_phase_status => 5
4362: );
4363:
4364: FND_MESSAGE.Set_Name('BOM', 'CST_PAC_TOL_NOT_ACHIEVED');
4365: fnd_file.put_line(fnd_file.output, fnd_message.get);
4366:
4367: EXIT;
4368:

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

4361: , p_phase_status => 5
4362: );
4363:
4364: FND_MESSAGE.Set_Name('BOM', 'CST_PAC_TOL_NOT_ACHIEVED');
4365: fnd_file.put_line(fnd_file.output, fnd_message.get);
4366:
4367: EXIT;
4368:
4369: END IF;

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

4481: ,p_period_end_date => p_end_date
4482: ,p_phase_status => 3
4483: );
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;

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

4482: ,p_phase_status => 3
4483: );
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:

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

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

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

4627: ,o_err_msg => l_error_msg
4628: );
4629:
4630: IF l_error_num <> 0 THEN
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;

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

4628: );
4629:
4630: IF l_error_num <> 0 THEN
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

Line 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

4629:
4630: IF l_error_num <> 0 THEN
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

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

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

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

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

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

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

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

4713: ,x_status => G_REQUEST_TABLE(i).phase_status
4714: );
4715:
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;

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

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

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

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

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

4811: );
4812: END IF;
4813:
4814: IF p_run_options > 2 AND p_cg_tab(l_current_index).starting_phase < 5 THEN
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;

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

4812: END IF;
4813:
4814: IF p_run_options > 2 AND p_cg_tab(l_current_index).starting_phase < 5 THEN
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;

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

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

Line 4845: l_message := fnd_message.get;

4841: p_end_date
4842: );
4843: COMMIT;
4844: IF (l_submit_req_id = 0) THEN
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;

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

4842: );
4843: COMMIT;
4844: IF (l_submit_req_id = 0) THEN
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;

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

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

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

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

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

4972: ,x_errcode => l_error_code
4973: );
4974:
4975: IF l_return_code <> 0 THEN
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;

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

4973: );
4974:
4975: IF l_return_code <> 0 THEN
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

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

4974:
4975: IF l_return_code <> 0 THEN
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

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

5024: ,x_err_msg => l_error_msg
5025: );
5026:
5027: IF l_error_num <> 0 THEN
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;

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

5025: );
5026:
5027: IF l_error_num <> 0 THEN
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

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

5026:
5027: IF l_error_num <> 0 THEN
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