DBA Data[Home] [Help]

APPS.AHL_UMP_PROCESSUNIT_EXTN_PVT dependencies on FND_API

Line 487: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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;
488: END IF;
489: END IF; -- preceding_mr_csr%NOTFOUND
490: CLOSE preceding_mr_csr;
491:

Line 561: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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;
562: END IF;
563: ClOSE ahl_unit_effectivity_csr;
564:
565: END LOOP;

Line 887: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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;
888: END IF;
889: ClOSE ahl_unit_effectivity_csr;
890: END LOOP;
891:

Line 1039: RAISE FND_API.G_EXC_ERROR;

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;
1042:
1043:

Line 1131: RAISE FND_API.G_EXC_ERROR;

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;
1134:
1135:

Line 1280: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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;
1282: CLOSE ahl_temp_parent_csr;
1283:
1284: -- Insert into ahl_ue_relationships.

Line 1325: RAISE FND_API.G_EXC_ERROR;

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;
1328:
1329: --------------------------------------------------------------------------------

Line 1565: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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;
1567: CLOSE ahl_ue_grp_csr;
1568: l_ue_grp_tbl(i) := l_ue_grp_rec;
1569: i := i + 1;

Line 1667: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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
1669:
1670: update_record (p_temp_mr_rec, l_unit_effectivity_rec);
1671: l_grp_match_flag := TRUE; -- matched record.

Line 1734: RAISE FND_API.G_EXC_ERROR;

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;
1737: ----------------------------------------------------------------------
1738: -- To update unit effectivities for Deferrals and Service Request UEs.

Line 1926: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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
1928: l_unit_effectivity_rec.tolerance_flag := unit_sr_def_rec.tolerance_flag;
1929: l_unit_effectivity_rec.message_code := unit_sr_def_rec.message_code;
1930: l_unit_effectivity_rec.due_date := unit_sr_def_rec.due_date;

Line 2016: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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
2018: l_unit_effectivity_rec.tolerance_flag := unit_sr_def_rec.tolerance_flag;
2019: l_unit_effectivity_rec.message_code := unit_sr_def_rec.message_code;
2020: l_unit_effectivity_rec.due_date := unit_sr_def_rec.due_date;

Line 2112: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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
2114: l_unit_effectivity_rec.tolerance_flag := unit_sr_def_rec.tolerance_flag;
2115: l_unit_effectivity_rec.message_code := unit_sr_def_rec.message_code;
2116: l_unit_effectivity_rec.due_date := unit_sr_def_rec.due_date;

Line 2309: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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;
2311: CLOSE ahl_temp_parent_csr;
2312:
2313: -- Insert into ahl_ue_relationships.

Line 2359: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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
2361: AHL_UNIT_EFFECTIVITIES_PKG.Insert_Row (
2362: X_ROWID => l_rowid,
2363: X_UNIT_EFFECTIVITY_ID => l_unit_effectivity_id,