DBA Data[Home] [Help]

APPS.AHL_UMP_PROCESSUNIT_EXTN_PVT dependencies on FND_API

Line 766: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

762: FND_MESSAGE.Set_Token('CSI_II',dependent_rec.preceding_csi_item_instance_id);
763: FND_MSG_PUB.ADD;
764: -- dbms_output.put_line('preceding mr not found for dependent ue id in temporary table');
765: CLOSE preceding_mr_csr;
766: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
767: END IF;
768: END IF; -- preceding_mr_csr%NOTFOUND
769: */
770:

Line 842: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

838: FND_MESSAGE.Set_Token('UE_ID',l_ue_rec.unit_effectivity_id);
839: FND_MSG_PUB.ADD;
840: -- dbms_output.put_line('preceding mr not found for dependent ue id');
841: ClOSE ahl_unit_effectivity_csr;
842: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
843: END IF;
844: ClOSE ahl_unit_effectivity_csr;
845: END IF; -- preceding_mr_csr%FOUND
846: CLOSE preceding_mr_csr;

Line 1258: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1254: FND_MESSAGE.Set_Token('UE_ID',l_ue_rec.unit_effectivity_id);
1255: FND_MSG_PUB.ADD;
1256: -- dbms_output.put_line('preceding mr not found for dependent ue id');
1257: ClOSE ahl_unit_effectivity_csr;
1258: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1259: END IF;
1260: ClOSE ahl_unit_effectivity_csr;
1261: END LOOP;
1262:

Line 1426: RAISE FND_API.G_EXC_ERROR;

1422: -- If any error occurs, then, abort API.
1423: WHEN NO_DATA_FOUND THEN
1424: FND_MESSAGE.SET_NAME('AHL','AHL_COM_RECORD_CHANGED');
1425: FND_MSG_PUB.ADD;
1426: RAISE FND_API.G_EXC_ERROR;
1427:
1428: END create_record;
1429:
1430:

Line 1528: RAISE FND_API.G_EXC_ERROR;

1524: -- If any error occurs, then, abort API.
1525: WHEN NO_DATA_FOUND THEN
1526: FND_MESSAGE.SET_NAME('AHL','AHL_COM_RECORD_CHANGED');
1527: FND_MSG_PUB.ADD;
1528: RAISE FND_API.G_EXC_ERROR;
1529:
1530: END update_record;
1531:
1532:

Line 1680: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1676: FND_MESSAGE.Set_Token ('INST_ID',l_temp_grp_rec.csi_item_instance_id);
1677: FND_MESSAGE.Set_Token ('MR_ID',l_temp_grp_rec.mr_header_id);
1678: FND_MSG_PUB.ADD;
1679: CLOSE ahl_temp_parent_csr;
1680: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1681: END IF;
1682: CLOSE ahl_temp_parent_csr;
1683:
1684: -- Insert into ahl_ue_relationships.

Line 1725: RAISE FND_API.G_EXC_ERROR;

1721: -- If any error occurs, then, abort API.
1722: WHEN NO_DATA_FOUND THEN
1723: FND_MESSAGE.SET_NAME('AHL','AHL_COM_RECORD_CHANGED');
1724: FND_MSG_PUB.ADD;
1725: RAISE FND_API.G_EXC_ERROR;
1726:
1727: END create_group;
1728:
1729: --------------------------------------------------------------------------------

Line 1967: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1963: FND_Message.set_token ('UE_ID',reln_rec.parent_ue_id);
1964: FND_Message.set_token ('RELATED_UE_ID',reln_rec.ue_id);
1965: FND_MSG_PUB.ADD;
1966: CLOSE ahl_ue_grp_csr;
1967: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1968: END IF;
1969: CLOSE ahl_ue_grp_csr;
1970: l_ue_grp_tbl(i) := l_ue_grp_rec;
1971: i := i + 1;

Line 2069: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2065: FND_Message.Set_Name ('AHL','AHL_UMP_PUE_UE_NOTFOUND');
2066: FND_Message.set_token ('UE_ID',l_ue_grp_tbl(j).csi_item_instance_id);
2067: FND_MSG_PUB.ADD;
2068: CLOSE ahl_unit_effectivity_csr;
2069: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2070: ELSE
2071:
2072: update_record (p_temp_mr_rec, l_unit_effectivity_rec);
2073: l_grp_match_flag := TRUE; -- matched record.

Line 2136: RAISE FND_API.G_EXC_ERROR;

2132: -- If any error occurs, then, abort API.
2133: WHEN NO_DATA_FOUND THEN
2134: FND_MESSAGE.SET_NAME('AHL','AHL_COM_RECORD_CHANGED');
2135: FND_MSG_PUB.ADD;
2136: RAISE FND_API.G_EXC_ERROR;
2137:
2138: END update_group;
2139: ----------------------------------------------------------------------
2140: -- To update unit effectivities for Deferrals and Service Request UEs.

Line 2343: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2339: FND_Message.Set_Name ('AHL','AHL_UMP_PUE_UE_NOTFOUND');
2340: FND_Message.set_token ('UE_ID',unit_sr_def_rec.unit_effectivity_id);
2341: FND_MSG_PUB.ADD;
2342: CLOSE ahl_unit_effectivity_csr;
2343: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2344: ELSE
2345: l_unit_effectivity_rec.tolerance_flag := unit_sr_def_rec.tolerance_flag;
2346: l_unit_effectivity_rec.message_code := unit_sr_def_rec.message_code;
2347: l_unit_effectivity_rec.due_date := unit_sr_def_rec.due_date;

Line 2435: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2431: FND_Message.Set_Name ('AHL','AHL_UMP_PUE_UE_NOTFOUND');
2432: FND_Message.set_token ('UE_ID',l_ue_rec.related_ue_id);
2433: FND_MSG_PUB.ADD;
2434: CLOSE ahl_unit_effectivity_csr;
2435: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2436: ELSE
2437: l_unit_effectivity_rec.tolerance_flag := unit_sr_def_rec.tolerance_flag;
2438: l_unit_effectivity_rec.message_code := unit_sr_def_rec.message_code;
2439: l_unit_effectivity_rec.due_date := unit_sr_def_rec.due_date;

Line 2531: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2527: FND_Message.Set_Name ('AHL','AHL_UMP_PUE_UE_NOTFOUND');
2528: FND_Message.set_token ('UE_ID',unit_sr_def_rec.unit_effectivity_id);
2529: FND_MSG_PUB.ADD;
2530: CLOSE ahl_unit_effectivity_csr;
2531: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2532: ELSE
2533: l_unit_effectivity_rec.tolerance_flag := unit_sr_def_rec.tolerance_flag;
2534: l_unit_effectivity_rec.message_code := unit_sr_def_rec.message_code;
2535: l_unit_effectivity_rec.due_date := unit_sr_def_rec.due_date;

Line 2737: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2733: --FND_MESSAGE.Set_Token ('INST_ID',ahl_temp_rec.csi_item_instance_id);
2734: --FND_MESSAGE.Set_Token ('MR_ID',ahl_temp_rec.mr_header_id);
2735: --FND_MSG_PUB.ADD;
2736: --CLOSE ahl_temp_parent_csr;
2737: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2738: END IF;
2739: CLOSE ahl_temp_parent_csr;
2740:
2741: -- Insert into ahl_ue_relationships.

Line 2786: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2782: FND_Message.Set_Name ('AHL','AHL_UMP_PUE_UE_NOTFOUND');
2783: FND_Message.set_token ('UE_ID',unit_sr_def_rec.unit_effectivity_id);
2784: FND_MSG_PUB.ADD;
2785: CLOSE ahl_unit_effectivity_csr;
2786: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2787: ELSE
2788: AHL_UNIT_EFFECTIVITIES_PKG.Insert_Row (
2789: X_ROWID => l_rowid,
2790: X_UNIT_EFFECTIVITY_ID => l_unit_effectivity_id,

Line 4207: RAISE FND_API.G_EXC_ERROR;

4203: -- If any error occurs, then, abort API.
4204: WHEN NO_DATA_FOUND THEN
4205: FND_MESSAGE.SET_NAME('AHL','AHL_COM_RECORD_CHANGED');
4206: FND_MSG_PUB.ADD;
4207: RAISE FND_API.G_EXC_ERROR;
4208:
4209: END create_sim_ue_record;
4210:
4211: -- To create decendent records if the MR is a group MR for Simulated UEs

Line 4352: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4348: FND_MESSAGE.Set_Token ('INST_ID',l_temp_grp_rec.csi_item_instance_id);
4349: FND_MESSAGE.Set_Token ('MR_ID',l_temp_grp_rec.mr_header_id);
4350: FND_MSG_PUB.ADD;
4351: CLOSE ahl_temp_parent_csr;
4352: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4353: END IF;
4354: CLOSE ahl_temp_parent_csr;
4355: l_temp_child_rec.parent_ue_id:= l_parent_ue_id;
4356:

Line 4378: RAISE FND_API.G_EXC_ERROR;

4374: -- If any error occurs, then, abort API.
4375: WHEN NO_DATA_FOUND THEN
4376: FND_MESSAGE.SET_NAME('AHL','AHL_COM_RECORD_CHANGED');
4377: FND_MSG_PUB.ADD;
4378: RAISE FND_API.G_EXC_ERROR;
4379:
4380: END Create_group_for_sim_ue;
4381:
4382: -- To create simulation ue rec from ahl_unit_effectivities record.

Line 4493: RAISE FND_API.G_EXC_ERROR;

4489: -- If any error occurs, then, abort API.
4490: WHEN NO_DATA_FOUND THEN
4491: FND_MESSAGE.SET_NAME('AHL','AHL_COM_RECORD_CHANGED');
4492: FND_MSG_PUB.ADD;
4493: RAISE FND_API.G_EXC_ERROR;
4494:
4495: END create_simue_from_ue_record;
4496:
4497: