DBA Data[Home] [Help]

APPS.AHL_UMP_PROCESSUNIT_EXTN_PVT dependencies on FND_MESSAGE

Line 482: FND_MESSAGE.Set_Name('AHL','AHL_UMP_PUE_PRECID_NOTFOUND');

478:
479: IF (l_acc_unit_effectivity_id IS NOT NULL) THEN
480: l_unit_effectivity_id := l_acc_unit_effectivity_id;
481: ELSE
482: FND_MESSAGE.Set_Name('AHL','AHL_UMP_PUE_PRECID_NOTFOUND');
483: FND_MESSAGE.Set_Token('UE_ID',dependent_rec.unit_effectivity_id);
484: FND_MSG_PUB.ADD;
485: -- dbms_output.put_line('preceding mr not found for dependent ue id in temporary table');
486: CLOSE preceding_mr_csr;

Line 483: FND_MESSAGE.Set_Token('UE_ID',dependent_rec.unit_effectivity_id);

479: IF (l_acc_unit_effectivity_id IS NOT NULL) THEN
480: l_unit_effectivity_id := l_acc_unit_effectivity_id;
481: ELSE
482: FND_MESSAGE.Set_Name('AHL','AHL_UMP_PUE_PRECID_NOTFOUND');
483: FND_MESSAGE.Set_Token('UE_ID',dependent_rec.unit_effectivity_id);
484: FND_MSG_PUB.ADD;
485: -- dbms_output.put_line('preceding mr not found for dependent ue id in temporary table');
486: CLOSE preceding_mr_csr;
487: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 556: FND_MESSAGE.Set_Name('AHL','AHL_UMP_PUE_UE_NOTFOUND');

552: X_LAST_UPDATED_BY => fnd_global.user_id,
553: X_LAST_UPDATE_LOGIN => fnd_global.login_id);
554: ELSE
555:
556: FND_MESSAGE.Set_Name('AHL','AHL_UMP_PUE_UE_NOTFOUND');
557: FND_MESSAGE.Set_Token('UE_ID',l_ue_rec.unit_effectivity_id);
558: FND_MSG_PUB.ADD;
559: -- dbms_output.put_line('preceding mr not found for dependent ue id');
560: ClOSE ahl_unit_effectivity_csr;

Line 557: FND_MESSAGE.Set_Token('UE_ID',l_ue_rec.unit_effectivity_id);

553: X_LAST_UPDATE_LOGIN => fnd_global.login_id);
554: ELSE
555:
556: FND_MESSAGE.Set_Name('AHL','AHL_UMP_PUE_UE_NOTFOUND');
557: FND_MESSAGE.Set_Token('UE_ID',l_ue_rec.unit_effectivity_id);
558: FND_MSG_PUB.ADD;
559: -- dbms_output.put_line('preceding mr not found for dependent ue id');
560: ClOSE ahl_unit_effectivity_csr;
561: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 882: FND_MESSAGE.Set_Name('AHL','AHL_UMP_PUE_UE_NOTFOUND');

878: -- Delete the corresponding rows in ahl_schedule materials for this ue.
879: Delete_Sch_Materials(l_ue_rec.unit_effectivity_id);
880:
881: ELSE
882: FND_MESSAGE.Set_Name('AHL','AHL_UMP_PUE_UE_NOTFOUND');
883: FND_MESSAGE.Set_Token('UE_ID',l_ue_rec.unit_effectivity_id);
884: FND_MSG_PUB.ADD;
885: -- dbms_output.put_line('preceding mr not found for dependent ue id');
886: ClOSE ahl_unit_effectivity_csr;

Line 883: FND_MESSAGE.Set_Token('UE_ID',l_ue_rec.unit_effectivity_id);

879: Delete_Sch_Materials(l_ue_rec.unit_effectivity_id);
880:
881: ELSE
882: FND_MESSAGE.Set_Name('AHL','AHL_UMP_PUE_UE_NOTFOUND');
883: FND_MESSAGE.Set_Token('UE_ID',l_ue_rec.unit_effectivity_id);
884: FND_MSG_PUB.ADD;
885: -- dbms_output.put_line('preceding mr not found for dependent ue id');
886: ClOSE ahl_unit_effectivity_csr;
887: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1037: FND_MESSAGE.SET_NAME('AHL','AHL_COM_RECORD_CHANGED');

1033:
1034: EXCEPTION
1035: -- If any error occurs, then, abort API.
1036: WHEN NO_DATA_FOUND THEN
1037: FND_MESSAGE.SET_NAME('AHL','AHL_COM_RECORD_CHANGED');
1038: FND_MSG_PUB.ADD;
1039: RAISE FND_API.G_EXC_ERROR;
1040:
1041: END create_record;

Line 1129: FND_MESSAGE.SET_NAME('AHL','AHL_COM_RECORD_CHANGED');

1125:
1126: EXCEPTION
1127: -- If any error occurs, then, abort API.
1128: WHEN NO_DATA_FOUND THEN
1129: FND_MESSAGE.SET_NAME('AHL','AHL_COM_RECORD_CHANGED');
1130: FND_MSG_PUB.ADD;
1131: RAISE FND_API.G_EXC_ERROR;
1132:
1133: END update_record;

Line 1275: FND_MESSAGE.Set_Name ('AHL','AHL_UMP_PUE_PARENT_NOTFOUND');

1271: l_orig_mr_header_id,
1272: p_x_temp_grp_rec.forecast_sequence);
1273: FETCH ahl_temp_parent_csr INTO l_parent_ue_id;
1274: IF (ahl_temp_parent_csr%NOTFOUND) THEN
1275: FND_MESSAGE.Set_Name ('AHL','AHL_UMP_PUE_PARENT_NOTFOUND');
1276: FND_MESSAGE.Set_Token ('INST_ID',l_temp_grp_rec.csi_item_instance_id);
1277: FND_MESSAGE.Set_Token ('MR_ID',l_temp_grp_rec.mr_header_id);
1278: FND_MSG_PUB.ADD;
1279: CLOSE ahl_temp_parent_csr;

Line 1276: FND_MESSAGE.Set_Token ('INST_ID',l_temp_grp_rec.csi_item_instance_id);

1272: p_x_temp_grp_rec.forecast_sequence);
1273: FETCH ahl_temp_parent_csr INTO l_parent_ue_id;
1274: IF (ahl_temp_parent_csr%NOTFOUND) THEN
1275: FND_MESSAGE.Set_Name ('AHL','AHL_UMP_PUE_PARENT_NOTFOUND');
1276: FND_MESSAGE.Set_Token ('INST_ID',l_temp_grp_rec.csi_item_instance_id);
1277: FND_MESSAGE.Set_Token ('MR_ID',l_temp_grp_rec.mr_header_id);
1278: FND_MSG_PUB.ADD;
1279: CLOSE ahl_temp_parent_csr;
1280: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1277: FND_MESSAGE.Set_Token ('MR_ID',l_temp_grp_rec.mr_header_id);

1273: FETCH ahl_temp_parent_csr INTO l_parent_ue_id;
1274: IF (ahl_temp_parent_csr%NOTFOUND) THEN
1275: FND_MESSAGE.Set_Name ('AHL','AHL_UMP_PUE_PARENT_NOTFOUND');
1276: FND_MESSAGE.Set_Token ('INST_ID',l_temp_grp_rec.csi_item_instance_id);
1277: FND_MESSAGE.Set_Token ('MR_ID',l_temp_grp_rec.mr_header_id);
1278: FND_MSG_PUB.ADD;
1279: CLOSE ahl_temp_parent_csr;
1280: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1281: END IF;

Line 1323: FND_MESSAGE.SET_NAME('AHL','AHL_COM_RECORD_CHANGED');

1319:
1320: EXCEPTION
1321: -- If any error occurs, then, abort API.
1322: WHEN NO_DATA_FOUND THEN
1323: FND_MESSAGE.SET_NAME('AHL','AHL_COM_RECORD_CHANGED');
1324: FND_MSG_PUB.ADD;
1325: RAISE FND_API.G_EXC_ERROR;
1326:
1327: END create_group;

Line 1560: FND_Message.Set_Name ('AHL','AHL_UMP_PUE_RELN_NOTFOUND');

1556: OPEN ahl_ue_grp_csr(reln_rec.ue_id,
1557: reln_rec.parent_ue_id);
1558: FETCH ahl_ue_grp_csr INTO l_ue_grp_rec;
1559: IF ahl_ue_grp_csr%NOTFOUND THEN
1560: FND_Message.Set_Name ('AHL','AHL_UMP_PUE_RELN_NOTFOUND');
1561: FND_Message.set_token ('UE_ID',reln_rec.parent_ue_id);
1562: FND_Message.set_token ('RELATED_UE_ID',reln_rec.ue_id);
1563: FND_MSG_PUB.ADD;
1564: CLOSE ahl_ue_grp_csr;

Line 1561: FND_Message.set_token ('UE_ID',reln_rec.parent_ue_id);

1557: reln_rec.parent_ue_id);
1558: FETCH ahl_ue_grp_csr INTO l_ue_grp_rec;
1559: IF ahl_ue_grp_csr%NOTFOUND THEN
1560: FND_Message.Set_Name ('AHL','AHL_UMP_PUE_RELN_NOTFOUND');
1561: FND_Message.set_token ('UE_ID',reln_rec.parent_ue_id);
1562: FND_Message.set_token ('RELATED_UE_ID',reln_rec.ue_id);
1563: FND_MSG_PUB.ADD;
1564: CLOSE ahl_ue_grp_csr;
1565: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1562: FND_Message.set_token ('RELATED_UE_ID',reln_rec.ue_id);

1558: FETCH ahl_ue_grp_csr INTO l_ue_grp_rec;
1559: IF ahl_ue_grp_csr%NOTFOUND THEN
1560: FND_Message.Set_Name ('AHL','AHL_UMP_PUE_RELN_NOTFOUND');
1561: FND_Message.set_token ('UE_ID',reln_rec.parent_ue_id);
1562: FND_Message.set_token ('RELATED_UE_ID',reln_rec.ue_id);
1563: FND_MSG_PUB.ADD;
1564: CLOSE ahl_ue_grp_csr;
1565: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1566: END IF;

Line 1663: FND_Message.Set_Name ('AHL','AHL_UMP_PUE_UE_NOTFOUND');

1659: l_unit_effectivity_rec.ATTRIBUTE15 ,
1660: l_unit_effectivity_rec.OBJECT_VERSION_NUMBER;
1661:
1662: IF (ahl_unit_effectivity_csr%NOTFOUND) THEN
1663: FND_Message.Set_Name ('AHL','AHL_UMP_PUE_UE_NOTFOUND');
1664: FND_Message.set_token ('UE_ID',l_ue_grp_tbl(j).csi_item_instance_id);
1665: FND_MSG_PUB.ADD;
1666: CLOSE ahl_unit_effectivity_csr;
1667: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1664: FND_Message.set_token ('UE_ID',l_ue_grp_tbl(j).csi_item_instance_id);

1660: l_unit_effectivity_rec.OBJECT_VERSION_NUMBER;
1661:
1662: IF (ahl_unit_effectivity_csr%NOTFOUND) THEN
1663: FND_Message.Set_Name ('AHL','AHL_UMP_PUE_UE_NOTFOUND');
1664: FND_Message.set_token ('UE_ID',l_ue_grp_tbl(j).csi_item_instance_id);
1665: FND_MSG_PUB.ADD;
1666: CLOSE ahl_unit_effectivity_csr;
1667: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1668: ELSE

Line 1732: FND_MESSAGE.SET_NAME('AHL','AHL_COM_RECORD_CHANGED');

1728:
1729: EXCEPTION
1730: -- If any error occurs, then, abort API.
1731: WHEN NO_DATA_FOUND THEN
1732: FND_MESSAGE.SET_NAME('AHL','AHL_COM_RECORD_CHANGED');
1733: FND_MSG_PUB.ADD;
1734: RAISE FND_API.G_EXC_ERROR;
1735:
1736: END update_group;

Line 1922: FND_Message.Set_Name ('AHL','AHL_UMP_PUE_UE_NOTFOUND');

1918:
1919: OPEN ahl_unit_effectivity_csr(unit_sr_def_rec.unit_effectivity_id);
1920: FETCH ahl_unit_effectivity_csr INTO l_unit_effectivity_rec;
1921: IF (ahl_unit_effectivity_csr%NOTFOUND) THEN
1922: FND_Message.Set_Name ('AHL','AHL_UMP_PUE_UE_NOTFOUND');
1923: FND_Message.set_token ('UE_ID',unit_sr_def_rec.unit_effectivity_id);
1924: FND_MSG_PUB.ADD;
1925: CLOSE ahl_unit_effectivity_csr;
1926: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1923: FND_Message.set_token ('UE_ID',unit_sr_def_rec.unit_effectivity_id);

1919: OPEN ahl_unit_effectivity_csr(unit_sr_def_rec.unit_effectivity_id);
1920: FETCH ahl_unit_effectivity_csr INTO l_unit_effectivity_rec;
1921: IF (ahl_unit_effectivity_csr%NOTFOUND) THEN
1922: FND_Message.Set_Name ('AHL','AHL_UMP_PUE_UE_NOTFOUND');
1923: FND_Message.set_token ('UE_ID',unit_sr_def_rec.unit_effectivity_id);
1924: FND_MSG_PUB.ADD;
1925: CLOSE ahl_unit_effectivity_csr;
1926: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1927: ELSE

Line 2012: FND_Message.Set_Name ('AHL','AHL_UMP_PUE_UE_NOTFOUND');

2008: -- Read Unit Effectivity record.
2009: OPEN ahl_unit_effectivity_csr(l_ue_rec.related_ue_id);
2010: FETCH ahl_unit_effectivity_csr INTO l_unit_effectivity_rec;
2011: IF (ahl_unit_effectivity_csr%NOTFOUND) THEN
2012: FND_Message.Set_Name ('AHL','AHL_UMP_PUE_UE_NOTFOUND');
2013: FND_Message.set_token ('UE_ID',l_ue_rec.related_ue_id);
2014: FND_MSG_PUB.ADD;
2015: CLOSE ahl_unit_effectivity_csr;
2016: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2013: FND_Message.set_token ('UE_ID',l_ue_rec.related_ue_id);

2009: OPEN ahl_unit_effectivity_csr(l_ue_rec.related_ue_id);
2010: FETCH ahl_unit_effectivity_csr INTO l_unit_effectivity_rec;
2011: IF (ahl_unit_effectivity_csr%NOTFOUND) THEN
2012: FND_Message.Set_Name ('AHL','AHL_UMP_PUE_UE_NOTFOUND');
2013: FND_Message.set_token ('UE_ID',l_ue_rec.related_ue_id);
2014: FND_MSG_PUB.ADD;
2015: CLOSE ahl_unit_effectivity_csr;
2016: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2017: ELSE

Line 2108: FND_Message.Set_Name ('AHL','AHL_UMP_PUE_UE_NOTFOUND');

2104: -- Create new group.
2105: OPEN ahl_unit_effectivity_csr(unit_sr_def_rec.unit_effectivity_id);
2106: FETCH ahl_unit_effectivity_csr INTO l_unit_effectivity_rec;
2107: IF (ahl_unit_effectivity_csr%NOTFOUND) THEN
2108: FND_Message.Set_Name ('AHL','AHL_UMP_PUE_UE_NOTFOUND');
2109: FND_Message.set_token ('UE_ID',unit_sr_def_rec.unit_effectivity_id);
2110: FND_MSG_PUB.ADD;
2111: CLOSE ahl_unit_effectivity_csr;
2112: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2109: FND_Message.set_token ('UE_ID',unit_sr_def_rec.unit_effectivity_id);

2105: OPEN ahl_unit_effectivity_csr(unit_sr_def_rec.unit_effectivity_id);
2106: FETCH ahl_unit_effectivity_csr INTO l_unit_effectivity_rec;
2107: IF (ahl_unit_effectivity_csr%NOTFOUND) THEN
2108: FND_Message.Set_Name ('AHL','AHL_UMP_PUE_UE_NOTFOUND');
2109: FND_Message.set_token ('UE_ID',unit_sr_def_rec.unit_effectivity_id);
2110: FND_MSG_PUB.ADD;
2111: CLOSE ahl_unit_effectivity_csr;
2112: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2113: ELSE

Line 2304: --FND_MESSAGE.Set_Name ('AHL','AHL_UMP_PUE_PARENT_NOTFOUND');

2300: FETCH ahl_temp_parent_csr INTO l_parent_ue_id;
2301: IF (ahl_temp_parent_csr%NOTFOUND) THEN
2302: -- parent is root UE.
2303: l_parent_ue_id := l_new_top_ue_id;
2304: --FND_MESSAGE.Set_Name ('AHL','AHL_UMP_PUE_PARENT_NOTFOUND');
2305: --FND_MESSAGE.Set_Token ('INST_ID',ahl_temp_rec.csi_item_instance_id);
2306: --FND_MESSAGE.Set_Token ('MR_ID',ahl_temp_rec.mr_header_id);
2307: --FND_MSG_PUB.ADD;
2308: --CLOSE ahl_temp_parent_csr;

Line 2305: --FND_MESSAGE.Set_Token ('INST_ID',ahl_temp_rec.csi_item_instance_id);

2301: IF (ahl_temp_parent_csr%NOTFOUND) THEN
2302: -- parent is root UE.
2303: l_parent_ue_id := l_new_top_ue_id;
2304: --FND_MESSAGE.Set_Name ('AHL','AHL_UMP_PUE_PARENT_NOTFOUND');
2305: --FND_MESSAGE.Set_Token ('INST_ID',ahl_temp_rec.csi_item_instance_id);
2306: --FND_MESSAGE.Set_Token ('MR_ID',ahl_temp_rec.mr_header_id);
2307: --FND_MSG_PUB.ADD;
2308: --CLOSE ahl_temp_parent_csr;
2309: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2306: --FND_MESSAGE.Set_Token ('MR_ID',ahl_temp_rec.mr_header_id);

2302: -- parent is root UE.
2303: l_parent_ue_id := l_new_top_ue_id;
2304: --FND_MESSAGE.Set_Name ('AHL','AHL_UMP_PUE_PARENT_NOTFOUND');
2305: --FND_MESSAGE.Set_Token ('INST_ID',ahl_temp_rec.csi_item_instance_id);
2306: --FND_MESSAGE.Set_Token ('MR_ID',ahl_temp_rec.mr_header_id);
2307: --FND_MSG_PUB.ADD;
2308: --CLOSE ahl_temp_parent_csr;
2309: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2310: END IF;

Line 2355: FND_Message.Set_Name ('AHL','AHL_UMP_PUE_UE_NOTFOUND');

2351: -- Get Unit effectivity details.
2352: OPEN ahl_unit_effectivity_csr(unit_sr_def_rec.unit_effectivity_id);
2353: FETCH ahl_unit_effectivity_csr INTO l_unit_effectivity_rec;
2354: IF (ahl_unit_effectivity_csr%NOTFOUND) THEN
2355: FND_Message.Set_Name ('AHL','AHL_UMP_PUE_UE_NOTFOUND');
2356: FND_Message.set_token ('UE_ID',unit_sr_def_rec.unit_effectivity_id);
2357: FND_MSG_PUB.ADD;
2358: CLOSE ahl_unit_effectivity_csr;
2359: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2356: FND_Message.set_token ('UE_ID',unit_sr_def_rec.unit_effectivity_id);

2352: OPEN ahl_unit_effectivity_csr(unit_sr_def_rec.unit_effectivity_id);
2353: FETCH ahl_unit_effectivity_csr INTO l_unit_effectivity_rec;
2354: IF (ahl_unit_effectivity_csr%NOTFOUND) THEN
2355: FND_Message.Set_Name ('AHL','AHL_UMP_PUE_UE_NOTFOUND');
2356: FND_Message.set_token ('UE_ID',unit_sr_def_rec.unit_effectivity_id);
2357: FND_MSG_PUB.ADD;
2358: CLOSE ahl_unit_effectivity_csr;
2359: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2360: ELSE