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.AHL_LTP_SIMUL_PLAN_PVT dependencies on FND_MESSAGE

Line 158: FND_MESSAGE.set_name('AHL', 'AHL_LTP_RECORD_NOT_FOUND');

154: OPEN c_simulation_rec;
155: FETCH c_simulation_rec INTO l_simulation_rec;
156: IF c_simulation_rec%NOTFOUND THEN
157: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
158: FND_MESSAGE.set_name('AHL', 'AHL_LTP_RECORD_NOT_FOUND');
159: FND_MSG_PUB.add;
160: RAISE Fnd_Api.G_EXC_ERROR;
161: END IF;
162: END IF;

Line 167: Fnd_Message.SET_NAME('AHL','AHL_COM_RECORD_CHANGED');

163: CLOSE c_simulation_rec;
164: --Check for object version number
165: IF (l_simulation_rec.object_version_number <> p_simulation_rec.object_version_number)
166: THEN
167: Fnd_Message.SET_NAME('AHL','AHL_COM_RECORD_CHANGED');
168: Fnd_Msg_Pub.ADD;
169: RAISE Fnd_Api.G_EXC_ERROR;
170: END IF;
171:

Line 364: Fnd_Message.set_name('AHL', 'AHL_LTP_PLAN_NAME_NOT_EXIST');

360:
361: -- missing required fields
362: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.G_MSG_LVL_ERROR)
363: THEN
364: Fnd_Message.set_name('AHL', 'AHL_LTP_PLAN_NAME_NOT_EXIST');
365: Fnd_Msg_Pub.ADD;
366: END IF;
367: x_return_status := Fnd_Api.G_RET_STS_ERROR;
368: END IF;

Line 373: Fnd_Message.set_name('AHL', 'AHL_LTP_SIMUL_DUPLE_NAME');

369: -- Validate uniqueness
370: OPEN check_plan_name_cur(p_simulation_plan_rec.simulation_plan_name);
371: FETCH check_plan_name_cur INTO l_dummy;
372: IF check_plan_name_cur%FOUND THEN
373: Fnd_Message.set_name('AHL', 'AHL_LTP_SIMUL_DUPLE_NAME');
374: Fnd_Msg_Pub.ADD;
375: END IF;
376: x_return_status := Fnd_Api.g_ret_sts_error;
377: CLOSE check_plan_name_cur;

Line 380: Fnd_Message.set_name('AHL', 'AHL_LTP_SIMUL_DUPLE_NAME');

376: x_return_status := Fnd_Api.g_ret_sts_error;
377: CLOSE check_plan_name_cur;
378: --Check for primary plan
379: IF p_simulation_plan_rec.primary_plan_flag = 'Y' THEN
380: Fnd_Message.set_name('AHL', 'AHL_LTP_SIMUL_DUPLE_NAME');
381: Fnd_Msg_Pub.ADD;
382: x_return_status := Fnd_Api.g_ret_sts_error;
383: END IF;
384:

Line 630: Fnd_Message.SET_NAME('AHL','AHL_LTP_SEQUENCE_NOT_EXISTS');

626: -- If the value for the ID already exists, then
627: -- l_dummy would be populated with '1', otherwise,
628: -- it receives NULL.
629: IF l_dummy IS NOT NULL THEN
630: Fnd_Message.SET_NAME('AHL','AHL_LTP_SEQUENCE_NOT_EXISTS');
631: Fnd_Msg_Pub.ADD;
632: END IF;
633: -- For optional fields
634: IF p_x_simulation_plan_rec.description = FND_API.G_MISS_CHAR THEN

Line 948: Fnd_Message.SET_NAME('AHL','AHL_LTP_PLAN_NOT_EXISTS');

944: x_error_msg_code => l_msg_data);
945:
946: IF NVL(l_return_status,'x') <> 'S'
947: THEN
948: Fnd_Message.SET_NAME('AHL','AHL_LTP_PLAN_NOT_EXISTS');
949: Fnd_Message.SET_TOKEN('PLANID',p_simulation_plan_rec.plan_name);
950: Fnd_Msg_Pub.ADD;
951: END IF;
952: END IF;

Line 949: Fnd_Message.SET_TOKEN('PLANID',p_simulation_plan_rec.plan_name);

945:
946: IF NVL(l_return_status,'x') <> 'S'
947: THEN
948: Fnd_Message.SET_NAME('AHL','AHL_LTP_PLAN_NOT_EXISTS');
949: Fnd_Message.SET_TOKEN('PLANID',p_simulation_plan_rec.plan_name);
950: Fnd_Msg_Pub.ADD;
951: END IF;
952: END IF;
953: --Assign the returned value

Line 977: Fnd_Message.SET_NAME('AHL','AHL_LTP_PRIMARY_PLAN');

973: OPEN primary_plan_cur(l_ASimulation_plan_rec.simulation_plan_id);
974: FETCH primary_plan_cur INTO l_primary_plan_flag;
975: CLOSE primary_plan_cur;
976: IF l_primary_plan_flag = 'Y' THEN
977: Fnd_Message.SET_NAME('AHL','AHL_LTP_PRIMARY_PLAN');
978: Fnd_Msg_Pub.ADD;
979: END IF;
980: END IF;
981: --Standard check to count messages

Line 1199: FND_MESSAGE.set_name('AHL', 'AHL_LTP_RECORD_NOT_FOUND');

1195: l_object_version_number,
1196: l_primary_plan_flag;
1197: IF c_simulation_plan_cur%NOTFOUND THEN
1198: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1199: FND_MESSAGE.set_name('AHL', 'AHL_LTP_RECORD_NOT_FOUND');
1200: FND_MSG_PUB.add;
1201: END IF;
1202: CLOSE c_simulation_plan_cur;
1203: RAISE FND_API.g_exc_error;

Line 1210: FND_MESSAGE.set_name('AHL', 'AHL_LTP_PRIMARY_PLAN');

1206: --
1207: --Check for primary plan
1208: IF l_primary_plan_flag = 'Y'
1209: THEN
1210: FND_MESSAGE.set_name('AHL', 'AHL_LTP_PRIMARY_PLAN');
1211: FND_MSG_PUB.add;
1212: RAISE FND_API.g_exc_error;
1213: END IF;
1214:

Line 1250: FND_MESSAGE.set_name('AHL', 'AHL_LTP_RECORD_CHANGED');

1246:
1247: --Check for object version number
1248: IF l_object_version_number <> p_simulation_plan_rec.object_version_number
1249: THEN
1250: FND_MESSAGE.set_name('AHL', 'AHL_LTP_RECORD_CHANGED');
1251: FND_MSG_PUB.add;
1252: RAISE FND_API.g_exc_error;
1253: END IF;
1254: -------------------Call Table handler generated procedure------------

Line 1742: Fnd_message.SET_NAME('AHL','AHL_LTP_INVALID_VISIT_NUMBER');

1738: --
1739: OPEN get_visit_id_cur(p_visit_number);
1740: FETCH get_visit_id_cur INTO l_pvisit_id, l_primary_visit_id;
1741: IF get_visit_id_cur%NOTFOUND THEN
1742: Fnd_message.SET_NAME('AHL','AHL_LTP_INVALID_VISIT_NUMBER');
1743: Fnd_Msg_Pub.ADD;
1744: CLOSE get_visit_id_cur;
1745: RAISE Fnd_Api.G_EXC_ERROR;
1746: --

Line 1761: Fnd_message.SET_NAME('AHL','AHL_LTP_INVALID_VISIT_NUMBER');

1757: p_visit_id <> FND_API.G_MISS_NUM) THEN
1758: OPEN get_visit_num_cur(p_visit_id);
1759: FETCH get_visit_num_cur INTO l_pvisit_id, l_primary_visit_id;
1760: IF get_visit_num_cur%NOTFOUND THEN
1761: Fnd_message.SET_NAME('AHL','AHL_LTP_INVALID_VISIT_NUMBER');
1762: Fnd_Msg_Pub.ADD;
1763: CLOSE get_visit_num_cur;
1764: RAISE Fnd_Api.G_EXC_ERROR;
1765: END IF;

Line 1777: Fnd_message.SET_NAME('AHL','AHL_LTP_INVALID_SIMUL_NAME');

1773: INTO l_simulation_plan_id, l_plan_flag
1774: FROM AHL_SIMULATION_PLANS_VL
1775: WHERE simulation_plan_id = p_plan_id;
1776: ELSE
1777: Fnd_message.SET_NAME('AHL','AHL_LTP_INVALID_SIMUL_NAME');
1778: Fnd_Msg_Pub.ADD;
1779: RAISE Fnd_Api.G_EXC_ERROR;
1780: END IF;
1781: --Check for copying to priamry plan

Line 1783: Fnd_message.SET_NAME('AHL','AHL_LTP_NO_COPY_PRIM_PLAN');

1779: RAISE Fnd_Api.G_EXC_ERROR;
1780: END IF;
1781: --Check for copying to priamry plan
1782: IF l_plan_flag = 'Y' THEN
1783: Fnd_message.SET_NAME('AHL','AHL_LTP_NO_COPY_PRIM_PLAN');
1784: Fnd_Msg_Pub.ADD;
1785: RAISE Fnd_Api.G_EXC_ERROR;
1786: END IF;
1787: --

Line 1795: Fnd_message.SET_NAME('AHL','AHL_LTP_RECORD_EXISTS');

1791: --
1792: --Check for duplicate records
1793: IF l_visit_detail_rec.visit_id = l_pvisit_id THEN
1794: IF l_visit_detail_rec.simulation_plan_id = p_plan_id THEN
1795: Fnd_message.SET_NAME('AHL','AHL_LTP_RECORD_EXISTS');
1796: Fnd_Msg_Pub.ADD;
1797: RAISE Fnd_Api.G_EXC_ERROR;
1798: END IF;
1799: END IF;

Line 1805: Fnd_message.SET_NAME('AHL','AHL_LTP_INVALID_VISIT_RECORD');

1801: --Check for Object version number
1802: IF (p_v_ovn IS NOT NULL AND p_v_ovn <> FND_API.G_MISS_NUM )
1803: THEN
1804: IF p_v_ovn <> l_visit_detail_rec.object_version_number THEN
1805: Fnd_message.SET_NAME('AHL','AHL_LTP_INVALID_VISIT_RECORD');
1806: Fnd_Msg_Pub.ADD;
1807: RAISE Fnd_Api.G_EXC_ERROR;
1808: END IF;
1809: END IF;

Line 1817: Fnd_message.SET_NAME('AHL','AHL_LTP_INVALID_PLAN_RECORD');

1813: --Check for plan object version number
1814: IF (p_p_ovn IS NOT NULL AND p_p_ovn <> FND_API.G_MISS_NUM )
1815: THEN
1816: IF p_p_ovn <> l_plan_ovn_number THEN
1817: Fnd_message.SET_NAME('AHL','AHL_LTP_INVALID_PLAN_RECORD');
1818: Fnd_Msg_Pub.ADD;
1819: RAISE Fnd_Api.G_EXC_ERROR;
1820: END IF;
1821: END IF;

Line 1828: Fnd_message.SET_NAME('AHL','AHL_LTP_VISIT_NUMBER_EXISTS');

1824: FETCH check_visit_exist_cur INTO l_dup_id;
1825: CLOSE check_visit_exist_cur;
1826: --
1827: IF l_dup_id IS NOT NULL THEN
1828: Fnd_message.SET_NAME('AHL','AHL_LTP_VISIT_NUMBER_EXISTS');
1829: Fnd_Msg_Pub.ADD;
1830: RAISE Fnd_Api.G_EXC_ERROR;
1831: END IF;
1832: IF G_DEBUG='Y' THEN

Line 2023: Fnd_Message.SET_NAME('AHL','AHL_LTP_SIM_VISIT_UNIT_FOUND');

2019: OPEN c_ue_sr_details(ue_mr_sr_rec.cs_incident_id,ue_mr_sr_rec.csi_item_instance_id);
2020: FETCH c_ue_sr_details INTO ue_sr_details_rec;
2021: CLOSE c_ue_sr_details;
2022:
2023: Fnd_Message.SET_NAME('AHL','AHL_LTP_SIM_VISIT_UNIT_FOUND');
2024: Fnd_Message.SET_TOKEN('UE_TITLE', ue_sr_details_rec.ue_title);
2025: Fnd_Message.SET_TOKEN('ITEM_NUMBER', ue_sr_details_rec.part_number);
2026: Fnd_Message.SET_TOKEN('SERIAL_NUMBER', ue_sr_details_rec.serial_number);
2027: Fnd_Message.SET_TOKEN('MR_TITLE', ue_sr_details_rec.mr_title);

Line 2024: Fnd_Message.SET_TOKEN('UE_TITLE', ue_sr_details_rec.ue_title);

2020: FETCH c_ue_sr_details INTO ue_sr_details_rec;
2021: CLOSE c_ue_sr_details;
2022:
2023: Fnd_Message.SET_NAME('AHL','AHL_LTP_SIM_VISIT_UNIT_FOUND');
2024: Fnd_Message.SET_TOKEN('UE_TITLE', ue_sr_details_rec.ue_title);
2025: Fnd_Message.SET_TOKEN('ITEM_NUMBER', ue_sr_details_rec.part_number);
2026: Fnd_Message.SET_TOKEN('SERIAL_NUMBER', ue_sr_details_rec.serial_number);
2027: Fnd_Message.SET_TOKEN('MR_TITLE', ue_sr_details_rec.mr_title);
2028: ELSE

Line 2025: Fnd_Message.SET_TOKEN('ITEM_NUMBER', ue_sr_details_rec.part_number);

2021: CLOSE c_ue_sr_details;
2022:
2023: Fnd_Message.SET_NAME('AHL','AHL_LTP_SIM_VISIT_UNIT_FOUND');
2024: Fnd_Message.SET_TOKEN('UE_TITLE', ue_sr_details_rec.ue_title);
2025: Fnd_Message.SET_TOKEN('ITEM_NUMBER', ue_sr_details_rec.part_number);
2026: Fnd_Message.SET_TOKEN('SERIAL_NUMBER', ue_sr_details_rec.serial_number);
2027: Fnd_Message.SET_TOKEN('MR_TITLE', ue_sr_details_rec.mr_title);
2028: ELSE
2029: -- Else if UE corresponds to MR

Line 2026: Fnd_Message.SET_TOKEN('SERIAL_NUMBER', ue_sr_details_rec.serial_number);

2022:
2023: Fnd_Message.SET_NAME('AHL','AHL_LTP_SIM_VISIT_UNIT_FOUND');
2024: Fnd_Message.SET_TOKEN('UE_TITLE', ue_sr_details_rec.ue_title);
2025: Fnd_Message.SET_TOKEN('ITEM_NUMBER', ue_sr_details_rec.part_number);
2026: Fnd_Message.SET_TOKEN('SERIAL_NUMBER', ue_sr_details_rec.serial_number);
2027: Fnd_Message.SET_TOKEN('MR_TITLE', ue_sr_details_rec.mr_title);
2028: ELSE
2029: -- Else if UE corresponds to MR
2030: OPEN c_ue_mr_details(ue_mr_sr_rec.mr_header_id,ue_mr_sr_rec.csi_item_instance_id);

Line 2027: Fnd_Message.SET_TOKEN('MR_TITLE', ue_sr_details_rec.mr_title);

2023: Fnd_Message.SET_NAME('AHL','AHL_LTP_SIM_VISIT_UNIT_FOUND');
2024: Fnd_Message.SET_TOKEN('UE_TITLE', ue_sr_details_rec.ue_title);
2025: Fnd_Message.SET_TOKEN('ITEM_NUMBER', ue_sr_details_rec.part_number);
2026: Fnd_Message.SET_TOKEN('SERIAL_NUMBER', ue_sr_details_rec.serial_number);
2027: Fnd_Message.SET_TOKEN('MR_TITLE', ue_sr_details_rec.mr_title);
2028: ELSE
2029: -- Else if UE corresponds to MR
2030: OPEN c_ue_mr_details(ue_mr_sr_rec.mr_header_id,ue_mr_sr_rec.csi_item_instance_id);
2031: FETCH c_ue_mr_details INTO ue_mr_details_rec;

Line 2034: Fnd_Message.SET_NAME('AHL','AHL_LTP_SIM_VISIT_UNIT_FOUND');

2030: OPEN c_ue_mr_details(ue_mr_sr_rec.mr_header_id,ue_mr_sr_rec.csi_item_instance_id);
2031: FETCH c_ue_mr_details INTO ue_mr_details_rec;
2032: CLOSE c_ue_mr_details;
2033:
2034: Fnd_Message.SET_NAME('AHL','AHL_LTP_SIM_VISIT_UNIT_FOUND');
2035: Fnd_Message.SET_TOKEN('UE_TITLE', ue_mr_details_rec.ue_title);
2036: Fnd_Message.SET_TOKEN('ITEM_NUMBER', ue_mr_details_rec.part_number);
2037: Fnd_Message.SET_TOKEN('SERIAL_NUMBER', ue_mr_details_rec.serial_number);
2038: Fnd_Message.SET_TOKEN('MR_TITLE', ue_mr_details_rec.mr_title);

Line 2035: Fnd_Message.SET_TOKEN('UE_TITLE', ue_mr_details_rec.ue_title);

2031: FETCH c_ue_mr_details INTO ue_mr_details_rec;
2032: CLOSE c_ue_mr_details;
2033:
2034: Fnd_Message.SET_NAME('AHL','AHL_LTP_SIM_VISIT_UNIT_FOUND');
2035: Fnd_Message.SET_TOKEN('UE_TITLE', ue_mr_details_rec.ue_title);
2036: Fnd_Message.SET_TOKEN('ITEM_NUMBER', ue_mr_details_rec.part_number);
2037: Fnd_Message.SET_TOKEN('SERIAL_NUMBER', ue_mr_details_rec.serial_number);
2038: Fnd_Message.SET_TOKEN('MR_TITLE', ue_mr_details_rec.mr_title);
2039: END IF;

Line 2036: Fnd_Message.SET_TOKEN('ITEM_NUMBER', ue_mr_details_rec.part_number);

2032: CLOSE c_ue_mr_details;
2033:
2034: Fnd_Message.SET_NAME('AHL','AHL_LTP_SIM_VISIT_UNIT_FOUND');
2035: Fnd_Message.SET_TOKEN('UE_TITLE', ue_mr_details_rec.ue_title);
2036: Fnd_Message.SET_TOKEN('ITEM_NUMBER', ue_mr_details_rec.part_number);
2037: Fnd_Message.SET_TOKEN('SERIAL_NUMBER', ue_mr_details_rec.serial_number);
2038: Fnd_Message.SET_TOKEN('MR_TITLE', ue_mr_details_rec.mr_title);
2039: END IF;
2040:

Line 2037: Fnd_Message.SET_TOKEN('SERIAL_NUMBER', ue_mr_details_rec.serial_number);

2033:
2034: Fnd_Message.SET_NAME('AHL','AHL_LTP_SIM_VISIT_UNIT_FOUND');
2035: Fnd_Message.SET_TOKEN('UE_TITLE', ue_mr_details_rec.ue_title);
2036: Fnd_Message.SET_TOKEN('ITEM_NUMBER', ue_mr_details_rec.part_number);
2037: Fnd_Message.SET_TOKEN('SERIAL_NUMBER', ue_mr_details_rec.serial_number);
2038: Fnd_Message.SET_TOKEN('MR_TITLE', ue_mr_details_rec.mr_title);
2039: END IF;
2040:
2041: OPEN get_visit_number (l_pvisit_id);

Line 2038: Fnd_Message.SET_TOKEN('MR_TITLE', ue_mr_details_rec.mr_title);

2034: Fnd_Message.SET_NAME('AHL','AHL_LTP_SIM_VISIT_UNIT_FOUND');
2035: Fnd_Message.SET_TOKEN('UE_TITLE', ue_mr_details_rec.ue_title);
2036: Fnd_Message.SET_TOKEN('ITEM_NUMBER', ue_mr_details_rec.part_number);
2037: Fnd_Message.SET_TOKEN('SERIAL_NUMBER', ue_mr_details_rec.serial_number);
2038: Fnd_Message.SET_TOKEN('MR_TITLE', ue_mr_details_rec.mr_title);
2039: END IF;
2040:
2041: OPEN get_visit_number (l_pvisit_id);
2042: FETCH get_visit_number INTO l_primary_visit_number;

Line 2053: Fnd_Message.SET_NAME('AHL','AHL_LTP_SIM_VISIT_UNIT_FOUND');

2049:
2050: x_return_status := Fnd_Api.g_ret_sts_error;
2051:
2052: /*
2053: Fnd_Message.SET_NAME('AHL','AHL_LTP_SIM_VISIT_UNIT_FOUND');
2054: Fnd_Message.SET_TOKEN('UE_TITLE', l_ue_details_rec.ue_title);
2055: Fnd_Message.SET_TOKEN('ITEM_NUMBER', l_ue_details_rec.part_number);
2056: Fnd_Message.SET_TOKEN('SERIAL_NUMBER', l_ue_details_rec.serial_number);
2057: Fnd_Message.SET_TOKEN('MR_TITLE', l_ue_details_rec.mr_title);

Line 2054: Fnd_Message.SET_TOKEN('UE_TITLE', l_ue_details_rec.ue_title);

2050: x_return_status := Fnd_Api.g_ret_sts_error;
2051:
2052: /*
2053: Fnd_Message.SET_NAME('AHL','AHL_LTP_SIM_VISIT_UNIT_FOUND');
2054: Fnd_Message.SET_TOKEN('UE_TITLE', l_ue_details_rec.ue_title);
2055: Fnd_Message.SET_TOKEN('ITEM_NUMBER', l_ue_details_rec.part_number);
2056: Fnd_Message.SET_TOKEN('SERIAL_NUMBER', l_ue_details_rec.serial_number);
2057: Fnd_Message.SET_TOKEN('MR_TITLE', l_ue_details_rec.mr_title);
2058: */

Line 2055: Fnd_Message.SET_TOKEN('ITEM_NUMBER', l_ue_details_rec.part_number);

2051:
2052: /*
2053: Fnd_Message.SET_NAME('AHL','AHL_LTP_SIM_VISIT_UNIT_FOUND');
2054: Fnd_Message.SET_TOKEN('UE_TITLE', l_ue_details_rec.ue_title);
2055: Fnd_Message.SET_TOKEN('ITEM_NUMBER', l_ue_details_rec.part_number);
2056: Fnd_Message.SET_TOKEN('SERIAL_NUMBER', l_ue_details_rec.serial_number);
2057: Fnd_Message.SET_TOKEN('MR_TITLE', l_ue_details_rec.mr_title);
2058: */
2059: /*

Line 2056: Fnd_Message.SET_TOKEN('SERIAL_NUMBER', l_ue_details_rec.serial_number);

2052: /*
2053: Fnd_Message.SET_NAME('AHL','AHL_LTP_SIM_VISIT_UNIT_FOUND');
2054: Fnd_Message.SET_TOKEN('UE_TITLE', l_ue_details_rec.ue_title);
2055: Fnd_Message.SET_TOKEN('ITEM_NUMBER', l_ue_details_rec.part_number);
2056: Fnd_Message.SET_TOKEN('SERIAL_NUMBER', l_ue_details_rec.serial_number);
2057: Fnd_Message.SET_TOKEN('MR_TITLE', l_ue_details_rec.mr_title);
2058: */
2059: /*
2060: AnRaj: End of Fix bug#:4919576

Line 2057: Fnd_Message.SET_TOKEN('MR_TITLE', l_ue_details_rec.mr_title);

2053: Fnd_Message.SET_NAME('AHL','AHL_LTP_SIM_VISIT_UNIT_FOUND');
2054: Fnd_Message.SET_TOKEN('UE_TITLE', l_ue_details_rec.ue_title);
2055: Fnd_Message.SET_TOKEN('ITEM_NUMBER', l_ue_details_rec.part_number);
2056: Fnd_Message.SET_TOKEN('SERIAL_NUMBER', l_ue_details_rec.serial_number);
2057: Fnd_Message.SET_TOKEN('MR_TITLE', l_ue_details_rec.mr_title);
2058: */
2059: /*
2060: AnRaj: End of Fix bug#:4919576
2061: */

Line 2064: Fnd_Message.SET_TOKEN('VISIT1', l_primary_visit_number);

2060: AnRaj: End of Fix bug#:4919576
2061: */
2062:
2063:
2064: Fnd_Message.SET_TOKEN('VISIT1', l_primary_visit_number);
2065: Fnd_Message.SET_TOKEN('VISIT2', l_asso_prim_visit_number);
2066: Fnd_Msg_Pub.ADD;
2067: RAISE Fnd_Api.G_EXC_ERROR;
2068: ELSE

Line 2065: Fnd_Message.SET_TOKEN('VISIT2', l_asso_prim_visit_number);

2061: */
2062:
2063:
2064: Fnd_Message.SET_TOKEN('VISIT1', l_primary_visit_number);
2065: Fnd_Message.SET_TOKEN('VISIT2', l_asso_prim_visit_number);
2066: Fnd_Msg_Pub.ADD;
2067: RAISE Fnd_Api.G_EXC_ERROR;
2068: ELSE
2069: CLOSE chk_unit_effectivities;

Line 2825: Fnd_message.SET_NAME('AHL','AHL_LTP_INVALID_RECORD');

2821: FETCH visit_detail_cur INTO l_visit_id,
2822: l_object_version_number,
2823: l_simulation_delete_flag;
2824: IF visit_detail_cur%NOTFOUND THEN
2825: Fnd_message.SET_NAME('AHL','AHL_LTP_INVALID_RECORD');
2826: Fnd_Msg_Pub.ADD;
2827: END IF;
2828: CLOSE visit_detail_cur;
2829: END IF;

Line 2832: Fnd_message.SET_NAME('AHL','AHL_LTP_INVALID_RECORD');

2828: CLOSE visit_detail_cur;
2829: END IF;
2830: --Check for object version number
2831: IF p_visit_object_version_number <> l_object_version_number THEN
2832: Fnd_message.SET_NAME('AHL','AHL_LTP_INVALID_RECORD');
2833: Fnd_Msg_Pub.ADD;
2834: END IF;
2835: --
2836: IF l_simulation_delete_flag = 'N' THEN

Line 3024: Fnd_message.SET_NAME('AHL','AHL_LTP_RECORD_INVALID');

3020: FETCH plan_cur INTO l_simulation_plan_id,
3021: l_object_version_number,
3022: l_primary_plan_flag;
3023: IF plan_cur%NOTFOUND THEN
3024: Fnd_message.SET_NAME('AHL','AHL_LTP_RECORD_INVALID');
3025: Fnd_Msg_Pub.ADD;
3026: END IF;
3027: CLOSE plan_cur;
3028: END IF;

Line 3033: Fnd_message.SET_NAME('AHL','AHL_LTP_SIMULATION_NO_VISITS');

3029: --Check for any visits
3030: OPEN check_visit_cur(p_plan_id);
3031: FETCH check_visit_cur INTO l_dummy;
3032: IF check_visit_cur%NOTFOUND THEN
3033: Fnd_message.SET_NAME('AHL','AHL_LTP_SIMULATION_NO_VISITS');
3034: Fnd_Msg_Pub.ADD;
3035: CLOSE check_visit_cur;
3036: RAISE Fnd_Api.G_EXC_ERROR;
3037: END IF;

Line 3042: Fnd_message.SET_NAME('AHL','AHL_LTP_INVALID_PLAN_RECORD');

3038: CLOSE check_visit_cur;
3039: --
3040: --Check for Record change
3041: IF p_object_version_number <> l_object_version_number THEN
3042: Fnd_message.SET_NAME('AHL','AHL_LTP_INVALID_PLAN_RECORD');
3043: Fnd_Msg_Pub.ADD;
3044: END IF;
3045: --Get all the simulated visits
3046: IF p_plan_id IS NOT NULL AND p_plan_id <> FND_API.G_MISS_NUM

Line 3621: Fnd_message.SET_NAME('AHL','AHL_LTP_PRIMARY_PLAN');

3617: FETCH check_primary_cur INTO l_primary_plan_id;
3618: CLOSE check_primary_cur;
3619: --
3620: IF l_primary_plan_id IS NOT NULL THEN
3621: Fnd_message.SET_NAME('AHL','AHL_LTP_PRIMARY_PLAN');
3622: Fnd_Msg_Pub.ADD;
3623: RAISE Fnd_Api.G_EXC_ERROR;
3624: END IF;
3625: --Check for visit belongs to simulation plan

Line 3635: Fnd_message.SET_NAME('AHL','AHL_LTP_PRIMARY_PLAN');

3631: WHERE simulation_plan_id = p_plan_id
3632: AND primary_plan_flag = 'N';
3633: --
3634: IF l_simulation_plan_id IS NULL THEN
3635: Fnd_message.SET_NAME('AHL','AHL_LTP_PRIMARY_PLAN');
3636: Fnd_Msg_Pub.ADD;
3637: RAISE Fnd_Api.G_EXC_ERROR;
3638: END IF;
3639:

Line 3644: Fnd_message.SET_NAME('AHL','AHL_LTP_INVALID_RECORD');

3640: --Check for simulation plan
3641: OPEN simul_visit_cur(p_visit_id,p_plan_id);
3642: FETCH simul_visit_cur INTO l_simul_visit_rec;
3643: IF simul_visit_cur%NOTFOUND THEN
3644: Fnd_message.SET_NAME('AHL','AHL_LTP_INVALID_RECORD');
3645: Fnd_Msg_Pub.ADD;
3646: CLOSE simul_visit_cur;
3647: RAISE Fnd_Api.G_EXC_ERROR;
3648: END IF;

Line 3654: Fnd_message.SET_NAME('AHL','AHL_LTP_INVALID_PLAN_RECORD');

3650:
3651: --Check for object version number
3652: IF p_object_version_number <> l_simul_visit_rec.object_version_number
3653: THEN
3654: Fnd_message.SET_NAME('AHL','AHL_LTP_INVALID_PLAN_RECORD');
3655: Fnd_Msg_Pub.ADD;
3656: RAISE Fnd_Api.G_EXC_ERROR;
3657: END IF;
3658: --Get corresponding primary visit

Line 3677: Fnd_message.SET_NAME('AHL','AHL_LTP_VISIT_REMOVED');

3673: --Check for simulation delete flag
3674: IF l_simul_visit_rec.simulation_delete_flag = 'Y' THEN --Remove the Primary Visit
3675: /* Modified by mpothuku on 01/25/05 to delete the primary visit if the Simulation Flag is delete */
3676: /*
3677: Fnd_message.SET_NAME('AHL','AHL_LTP_VISIT_REMOVED');
3678: Fnd_Msg_Pub.ADD;
3679: RAISE Fnd_Api.G_EXC_ERROR;
3680: */
3681: IF l_primary_visit_id IS NOT NULL THEN

Line 3967: Fnd_Message.SET_NAME('AHL','AHL_LTP_PRIM_VISIT_UNIT_FOUND');

3963: IF ue_mr_sr_id_rec.cs_incident_id IS NOT NULL THEN
3964: OPEN c_ue_sr_details(ue_mr_sr_id_rec.cs_incident_id,ue_mr_sr_id_rec.csi_item_instance_id);
3965: FETCH c_ue_sr_details INTO ue_sr_details_rec;
3966: CLOSE c_ue_sr_details;
3967: Fnd_Message.SET_NAME('AHL','AHL_LTP_PRIM_VISIT_UNIT_FOUND');
3968: Fnd_Message.SET_TOKEN('UE_TITLE', ue_sr_details_rec.ue_title);
3969: Fnd_Message.SET_TOKEN('ITEM_NUMBER', ue_sr_details_rec.part_number);
3970: Fnd_Message.SET_TOKEN('SERIAL_NUMBER', ue_sr_details_rec.serial_number);
3971: Fnd_Message.SET_TOKEN('MR_TITLE', ue_sr_details_rec.mr_title);

Line 3968: Fnd_Message.SET_TOKEN('UE_TITLE', ue_sr_details_rec.ue_title);

3964: OPEN c_ue_sr_details(ue_mr_sr_id_rec.cs_incident_id,ue_mr_sr_id_rec.csi_item_instance_id);
3965: FETCH c_ue_sr_details INTO ue_sr_details_rec;
3966: CLOSE c_ue_sr_details;
3967: Fnd_Message.SET_NAME('AHL','AHL_LTP_PRIM_VISIT_UNIT_FOUND');
3968: Fnd_Message.SET_TOKEN('UE_TITLE', ue_sr_details_rec.ue_title);
3969: Fnd_Message.SET_TOKEN('ITEM_NUMBER', ue_sr_details_rec.part_number);
3970: Fnd_Message.SET_TOKEN('SERIAL_NUMBER', ue_sr_details_rec.serial_number);
3971: Fnd_Message.SET_TOKEN('MR_TITLE', ue_sr_details_rec.mr_title);
3972: Fnd_Message.SET_TOKEN('VISIT1', l_primary_visit_number);

Line 3969: Fnd_Message.SET_TOKEN('ITEM_NUMBER', ue_sr_details_rec.part_number);

3965: FETCH c_ue_sr_details INTO ue_sr_details_rec;
3966: CLOSE c_ue_sr_details;
3967: Fnd_Message.SET_NAME('AHL','AHL_LTP_PRIM_VISIT_UNIT_FOUND');
3968: Fnd_Message.SET_TOKEN('UE_TITLE', ue_sr_details_rec.ue_title);
3969: Fnd_Message.SET_TOKEN('ITEM_NUMBER', ue_sr_details_rec.part_number);
3970: Fnd_Message.SET_TOKEN('SERIAL_NUMBER', ue_sr_details_rec.serial_number);
3971: Fnd_Message.SET_TOKEN('MR_TITLE', ue_sr_details_rec.mr_title);
3972: Fnd_Message.SET_TOKEN('VISIT1', l_primary_visit_number);
3973: Fnd_Message.SET_TOKEN('VISIT2', l_visit_number);

Line 3970: Fnd_Message.SET_TOKEN('SERIAL_NUMBER', ue_sr_details_rec.serial_number);

3966: CLOSE c_ue_sr_details;
3967: Fnd_Message.SET_NAME('AHL','AHL_LTP_PRIM_VISIT_UNIT_FOUND');
3968: Fnd_Message.SET_TOKEN('UE_TITLE', ue_sr_details_rec.ue_title);
3969: Fnd_Message.SET_TOKEN('ITEM_NUMBER', ue_sr_details_rec.part_number);
3970: Fnd_Message.SET_TOKEN('SERIAL_NUMBER', ue_sr_details_rec.serial_number);
3971: Fnd_Message.SET_TOKEN('MR_TITLE', ue_sr_details_rec.mr_title);
3972: Fnd_Message.SET_TOKEN('VISIT1', l_primary_visit_number);
3973: Fnd_Message.SET_TOKEN('VISIT2', l_visit_number);
3974: Fnd_Msg_Pub.ADD;

Line 3971: Fnd_Message.SET_TOKEN('MR_TITLE', ue_sr_details_rec.mr_title);

3967: Fnd_Message.SET_NAME('AHL','AHL_LTP_PRIM_VISIT_UNIT_FOUND');
3968: Fnd_Message.SET_TOKEN('UE_TITLE', ue_sr_details_rec.ue_title);
3969: Fnd_Message.SET_TOKEN('ITEM_NUMBER', ue_sr_details_rec.part_number);
3970: Fnd_Message.SET_TOKEN('SERIAL_NUMBER', ue_sr_details_rec.serial_number);
3971: Fnd_Message.SET_TOKEN('MR_TITLE', ue_sr_details_rec.mr_title);
3972: Fnd_Message.SET_TOKEN('VISIT1', l_primary_visit_number);
3973: Fnd_Message.SET_TOKEN('VISIT2', l_visit_number);
3974: Fnd_Msg_Pub.ADD;
3975: RAISE Fnd_Api.G_EXC_ERROR;

Line 3972: Fnd_Message.SET_TOKEN('VISIT1', l_primary_visit_number);

3968: Fnd_Message.SET_TOKEN('UE_TITLE', ue_sr_details_rec.ue_title);
3969: Fnd_Message.SET_TOKEN('ITEM_NUMBER', ue_sr_details_rec.part_number);
3970: Fnd_Message.SET_TOKEN('SERIAL_NUMBER', ue_sr_details_rec.serial_number);
3971: Fnd_Message.SET_TOKEN('MR_TITLE', ue_sr_details_rec.mr_title);
3972: Fnd_Message.SET_TOKEN('VISIT1', l_primary_visit_number);
3973: Fnd_Message.SET_TOKEN('VISIT2', l_visit_number);
3974: Fnd_Msg_Pub.ADD;
3975: RAISE Fnd_Api.G_EXC_ERROR;
3976: ELSE

Line 3973: Fnd_Message.SET_TOKEN('VISIT2', l_visit_number);

3969: Fnd_Message.SET_TOKEN('ITEM_NUMBER', ue_sr_details_rec.part_number);
3970: Fnd_Message.SET_TOKEN('SERIAL_NUMBER', ue_sr_details_rec.serial_number);
3971: Fnd_Message.SET_TOKEN('MR_TITLE', ue_sr_details_rec.mr_title);
3972: Fnd_Message.SET_TOKEN('VISIT1', l_primary_visit_number);
3973: Fnd_Message.SET_TOKEN('VISIT2', l_visit_number);
3974: Fnd_Msg_Pub.ADD;
3975: RAISE Fnd_Api.G_EXC_ERROR;
3976: ELSE
3977: OPEN c_ue_mr_details(ue_mr_sr_id_rec.mr_header_id,ue_mr_sr_id_rec.csi_item_instance_id);

Line 3980: Fnd_Message.SET_NAME('AHL','AHL_LTP_PRIM_VISIT_UNIT_FOUND');

3976: ELSE
3977: OPEN c_ue_mr_details(ue_mr_sr_id_rec.mr_header_id,ue_mr_sr_id_rec.csi_item_instance_id);
3978: FETCH c_ue_mr_details INTO ue_mr_details_rec;
3979: CLOSE c_ue_mr_details;
3980: Fnd_Message.SET_NAME('AHL','AHL_LTP_PRIM_VISIT_UNIT_FOUND');
3981: Fnd_Message.SET_TOKEN('UE_TITLE', ue_mr_details_rec.ue_title);
3982: Fnd_Message.SET_TOKEN('ITEM_NUMBER', ue_mr_details_rec.part_number);
3983: Fnd_Message.SET_TOKEN('SERIAL_NUMBER', ue_mr_details_rec.serial_number);
3984: Fnd_Message.SET_TOKEN('MR_TITLE', ue_mr_details_rec.mr_title);

Line 3981: Fnd_Message.SET_TOKEN('UE_TITLE', ue_mr_details_rec.ue_title);

3977: OPEN c_ue_mr_details(ue_mr_sr_id_rec.mr_header_id,ue_mr_sr_id_rec.csi_item_instance_id);
3978: FETCH c_ue_mr_details INTO ue_mr_details_rec;
3979: CLOSE c_ue_mr_details;
3980: Fnd_Message.SET_NAME('AHL','AHL_LTP_PRIM_VISIT_UNIT_FOUND');
3981: Fnd_Message.SET_TOKEN('UE_TITLE', ue_mr_details_rec.ue_title);
3982: Fnd_Message.SET_TOKEN('ITEM_NUMBER', ue_mr_details_rec.part_number);
3983: Fnd_Message.SET_TOKEN('SERIAL_NUMBER', ue_mr_details_rec.serial_number);
3984: Fnd_Message.SET_TOKEN('MR_TITLE', ue_mr_details_rec.mr_title);
3985: Fnd_Message.SET_TOKEN('VISIT1', l_primary_visit_number);

Line 3982: Fnd_Message.SET_TOKEN('ITEM_NUMBER', ue_mr_details_rec.part_number);

3978: FETCH c_ue_mr_details INTO ue_mr_details_rec;
3979: CLOSE c_ue_mr_details;
3980: Fnd_Message.SET_NAME('AHL','AHL_LTP_PRIM_VISIT_UNIT_FOUND');
3981: Fnd_Message.SET_TOKEN('UE_TITLE', ue_mr_details_rec.ue_title);
3982: Fnd_Message.SET_TOKEN('ITEM_NUMBER', ue_mr_details_rec.part_number);
3983: Fnd_Message.SET_TOKEN('SERIAL_NUMBER', ue_mr_details_rec.serial_number);
3984: Fnd_Message.SET_TOKEN('MR_TITLE', ue_mr_details_rec.mr_title);
3985: Fnd_Message.SET_TOKEN('VISIT1', l_primary_visit_number);
3986: Fnd_Message.SET_TOKEN('VISIT2', l_visit_number);

Line 3983: Fnd_Message.SET_TOKEN('SERIAL_NUMBER', ue_mr_details_rec.serial_number);

3979: CLOSE c_ue_mr_details;
3980: Fnd_Message.SET_NAME('AHL','AHL_LTP_PRIM_VISIT_UNIT_FOUND');
3981: Fnd_Message.SET_TOKEN('UE_TITLE', ue_mr_details_rec.ue_title);
3982: Fnd_Message.SET_TOKEN('ITEM_NUMBER', ue_mr_details_rec.part_number);
3983: Fnd_Message.SET_TOKEN('SERIAL_NUMBER', ue_mr_details_rec.serial_number);
3984: Fnd_Message.SET_TOKEN('MR_TITLE', ue_mr_details_rec.mr_title);
3985: Fnd_Message.SET_TOKEN('VISIT1', l_primary_visit_number);
3986: Fnd_Message.SET_TOKEN('VISIT2', l_visit_number);
3987: Fnd_Msg_Pub.ADD;

Line 3984: Fnd_Message.SET_TOKEN('MR_TITLE', ue_mr_details_rec.mr_title);

3980: Fnd_Message.SET_NAME('AHL','AHL_LTP_PRIM_VISIT_UNIT_FOUND');
3981: Fnd_Message.SET_TOKEN('UE_TITLE', ue_mr_details_rec.ue_title);
3982: Fnd_Message.SET_TOKEN('ITEM_NUMBER', ue_mr_details_rec.part_number);
3983: Fnd_Message.SET_TOKEN('SERIAL_NUMBER', ue_mr_details_rec.serial_number);
3984: Fnd_Message.SET_TOKEN('MR_TITLE', ue_mr_details_rec.mr_title);
3985: Fnd_Message.SET_TOKEN('VISIT1', l_primary_visit_number);
3986: Fnd_Message.SET_TOKEN('VISIT2', l_visit_number);
3987: Fnd_Msg_Pub.ADD;
3988: RAISE Fnd_Api.G_EXC_ERROR;

Line 3985: Fnd_Message.SET_TOKEN('VISIT1', l_primary_visit_number);

3981: Fnd_Message.SET_TOKEN('UE_TITLE', ue_mr_details_rec.ue_title);
3982: Fnd_Message.SET_TOKEN('ITEM_NUMBER', ue_mr_details_rec.part_number);
3983: Fnd_Message.SET_TOKEN('SERIAL_NUMBER', ue_mr_details_rec.serial_number);
3984: Fnd_Message.SET_TOKEN('MR_TITLE', ue_mr_details_rec.mr_title);
3985: Fnd_Message.SET_TOKEN('VISIT1', l_primary_visit_number);
3986: Fnd_Message.SET_TOKEN('VISIT2', l_visit_number);
3987: Fnd_Msg_Pub.ADD;
3988: RAISE Fnd_Api.G_EXC_ERROR;
3989: END IF;

Line 3986: Fnd_Message.SET_TOKEN('VISIT2', l_visit_number);

3982: Fnd_Message.SET_TOKEN('ITEM_NUMBER', ue_mr_details_rec.part_number);
3983: Fnd_Message.SET_TOKEN('SERIAL_NUMBER', ue_mr_details_rec.serial_number);
3984: Fnd_Message.SET_TOKEN('MR_TITLE', ue_mr_details_rec.mr_title);
3985: Fnd_Message.SET_TOKEN('VISIT1', l_primary_visit_number);
3986: Fnd_Message.SET_TOKEN('VISIT2', l_visit_number);
3987: Fnd_Msg_Pub.ADD;
3988: RAISE Fnd_Api.G_EXC_ERROR;
3989: END IF;
3990: /*