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_SPACE_ASSIGN_PVT dependencies on FND_MESSAGE

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

330: OPEN c_space_assign_rec;
331: FETCH c_space_assign_rec INTO l_space_assign_rec;
332: IF c_space_assign_rec%NOTFOUND THEN
333: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
334: FND_MESSAGE.set_name('AHL', 'AHL_LTP_RECORD_NOT_FOUND');
335: FND_MSG_PUB.add;
336: CLOSE c_space_assign_rec;
337: RAISE Fnd_Api.G_EXC_ERROR;
338: END IF;

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

340: CLOSE c_space_assign_rec;
341: --Check for object version number
342: IF (l_space_assign_rec.object_version_number <> p_space_assign_rec.object_version_number)
343: THEN
344: Fnd_Message.SET_NAME('AHL','AHL_COM_RECORD_CHANGED');
345: Fnd_Msg_Pub.ADD;
346: RAISE Fnd_Api.G_EXC_ERROR;
347: END IF;
348:

Line 547: Fnd_Message.set_name('AHL', 'AHL_LTP_SPACE_ID_NOT_EXIST');

543: THEN
544: -- missing required fields
545: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.G_MSG_LVL_ERROR)
546: THEN
547: Fnd_Message.set_name('AHL', 'AHL_LTP_SPACE_ID_NOT_EXIST');
548: Fnd_Msg_Pub.ADD;
549: RAISE Fnd_Api.G_EXC_ERROR;
550: END IF;
551: x_return_status := Fnd_Api.G_RET_STS_ERROR;

Line 560: Fnd_Message.set_name('AHL', 'AHL_LTP_VISIT_ID_NOT_EXIST');

556: THEN
557: -- missing required fields
558: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.G_MSG_LVL_ERROR)
559: THEN
560: Fnd_Message.set_name('AHL', 'AHL_LTP_VISIT_ID_NOT_EXIST');
561: Fnd_Msg_Pub.ADD;
562: END IF;
563: x_return_status := Fnd_Api.G_RET_STS_ERROR;
564: END IF;

Line 573: Fnd_Message.set_name('AHL', 'AHL_LTP_SP_ASSIGN_DUP_RECORD');

569: FETCH check_unique INTO l_dummy;
570: CLOSE check_unique;
571: --
572: IF l_dummy IS NOT NULL THEN
573: Fnd_Message.set_name('AHL', 'AHL_LTP_SP_ASSIGN_DUP_RECORD');
574: Fnd_Msg_Pub.ADD;
575: END IF;
576: --- Validation for visit type and inventory item
577: OPEN visit_item_cur(p_space_assign_rec.visit_id);

Line 592: Fnd_Message.set_name('AHL', 'AHL_LTP_SP_UNAVAL_PERIOD');

588: LOOP
589: FETCH space_unavailable_cur INTO l_start_date,l_end_date;
590: EXIT WHEN space_unavailable_cur%NOTFOUND;
591: IF space_unavailable_cur%FOUND THEN
592: Fnd_Message.set_name('AHL', 'AHL_LTP_SP_UNAVAL_PERIOD');
593: Fnd_message.set_token( 'PERIOD', l_start_date ||' '||'to'||' '||l_end_date );
594: Fnd_Msg_Pub.ADD;
595: END IF;
596: END LOOP;

Line 593: Fnd_message.set_token( 'PERIOD', l_start_date ||' '||'to'||' '||l_end_date );

589: FETCH space_unavailable_cur INTO l_start_date,l_end_date;
590: EXIT WHEN space_unavailable_cur%NOTFOUND;
591: IF space_unavailable_cur%FOUND THEN
592: Fnd_Message.set_name('AHL', 'AHL_LTP_SP_UNAVAL_PERIOD');
593: Fnd_message.set_token( 'PERIOD', l_start_date ||' '||'to'||' '||l_end_date );
594: Fnd_Msg_Pub.ADD;
595: END IF;
596: END LOOP;
597: CLOSE space_unavailable_cur;

Line 608: Fnd_Message.set_name('AHL', 'AHL_LTP_SP_UNAVAL_PERIOD');

604: FETCH space_available_cur INTO l_start_date,l_end_date;
605: EXIT WHEN space_available_cur%NOTFOUND;
606: IF (l_start_date_time >= l_start_date AND
607: l_start_date_time <= l_end_date) THEN
608: Fnd_Message.set_name('AHL', 'AHL_LTP_SP_UNAVAL_PERIOD');
609: Fnd_message.set_token( 'PERIOD', l_start_date ||' '||'to'||' '||l_end_date );
610: Fnd_Msg_Pub.ADD;
611: END IF;
612: END LOOP;

Line 609: Fnd_message.set_token( 'PERIOD', l_start_date ||' '||'to'||' '||l_end_date );

605: EXIT WHEN space_available_cur%NOTFOUND;
606: IF (l_start_date_time >= l_start_date AND
607: l_start_date_time <= l_end_date) THEN
608: Fnd_Message.set_name('AHL', 'AHL_LTP_SP_UNAVAL_PERIOD');
609: Fnd_message.set_token( 'PERIOD', l_start_date ||' '||'to'||' '||l_end_date );
610: Fnd_Msg_Pub.ADD;
611: END IF;
612: END LOOP;
613: CLOSE space_available_cur;

Line 622: Fnd_Message.set_name('AHL', 'AHL_LTP_VISIT_ITEM_NOT_EXIST');

618: l_visit_type_code,
619: l_inventory_item_id);
620: FETCH space_capable_cur INTO l_space_capability_id;
621: IF l_space_capability_id IS NULL THEN
622: Fnd_Message.set_name('AHL', 'AHL_LTP_VISIT_ITEM_NOT_EXIST');
623: Fnd_Msg_Pub.ADD;
624: END IF;
625: CLOSE space_capable_cur;
626:

Line 840: Fnd_Message.SET_NAME('AHL','AHL_LTP_SPACE_NOT_EXISTS');

836: x_error_msg_code => l_msg_data);
837:
838: IF NVL(l_return_status,'x') <> 'S'
839: THEN
840: Fnd_Message.SET_NAME('AHL','AHL_LTP_SPACE_NOT_EXISTS');
841: Fnd_Message.SET_TOKEN('SPACEID',p_x_space_assign_rec.space_name);
842: Fnd_Msg_Pub.ADD;
843: END IF;
844: END IF;

Line 841: Fnd_Message.SET_TOKEN('SPACEID',p_x_space_assign_rec.space_name);

837:
838: IF NVL(l_return_status,'x') <> 'S'
839: THEN
840: Fnd_Message.SET_NAME('AHL','AHL_LTP_SPACE_NOT_EXISTS');
841: Fnd_Message.SET_TOKEN('SPACEID',p_x_space_assign_rec.space_name);
842: Fnd_Msg_Pub.ADD;
843: END IF;
844: END IF;
845: --Assign the returned value

Line 863: Fnd_Message.SET_NAME('AHL','AHL_LTP_VISIT_ID_NOT_EXIST');

859: x_error_msg_code => l_msg_data);
860:
861: IF NVL(l_return_status,'x') <> 'S'
862: THEN
863: Fnd_Message.SET_NAME('AHL','AHL_LTP_VISIT_ID_NOT_EXIST');
864: Fnd_Msg_Pub.ADD;
865: RAISE Fnd_Api.G_EXC_ERROR;
866: END IF;
867: END IF;

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

922: -- If the value for the ID already exists, then
923: -- l_dummy would be populated with '1', otherwise,
924: -- it receives NULL.
925: IF l_dummy IS NOT NULL THEN
926: Fnd_Message.SET_NAME('AHL','AHL_LTP_SEQUENCE_NOT_EXISTS');
927: Fnd_Msg_Pub.ADD;
928: END IF;
929: -- For optional fields
930: --

Line 1268: Fnd_Message.SET_NAME('AHL','AHL_LTP_SPACE_NOT_EXISTS');

1264: x_error_msg_code => l_msg_data);
1265:
1266: IF NVL(l_return_status,'x') <> 'S'
1267: THEN
1268: Fnd_Message.SET_NAME('AHL','AHL_LTP_SPACE_NOT_EXISTS');
1269: Fnd_Message.SET_TOKEN('SPACEID',p_space_assign_rec.space_name);
1270: Fnd_Msg_Pub.ADD;
1271: END IF;
1272: END IF;

Line 1269: Fnd_Message.SET_TOKEN('SPACEID',p_space_assign_rec.space_name);

1265:
1266: IF NVL(l_return_status,'x') <> 'S'
1267: THEN
1268: Fnd_Message.SET_NAME('AHL','AHL_LTP_SPACE_NOT_EXISTS');
1269: Fnd_Message.SET_TOKEN('SPACEID',p_space_assign_rec.space_name);
1270: Fnd_Msg_Pub.ADD;
1271: END IF;
1272: END IF;
1273: --Assign the returned value

Line 1291: Fnd_Message.SET_NAME('AHL','AHL_LTP_VISIT_NOT_EXISTS');

1287: x_error_msg_code => l_msg_data);
1288:
1289: IF NVL(l_return_status,'x') <> 'S'
1290: THEN
1291: Fnd_Message.SET_NAME('AHL','AHL_LTP_VISIT_NOT_EXISTS');
1292: Fnd_Message.SET_TOKEN('VISITID',p_space_assign_rec.visit_number);
1293: Fnd_Msg_Pub.ADD;
1294: END IF;
1295: END IF;

Line 1292: Fnd_Message.SET_TOKEN('VISITID',p_space_assign_rec.visit_number);

1288:
1289: IF NVL(l_return_status,'x') <> 'S'
1290: THEN
1291: Fnd_Message.SET_NAME('AHL','AHL_LTP_VISIT_NOT_EXISTS');
1292: Fnd_Message.SET_TOKEN('VISITID',p_space_assign_rec.visit_number);
1293: Fnd_Msg_Pub.ADD;
1294: END IF;
1295: END IF;
1296: --Assign the returned value

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

1572: FETCH c_space_assign_cur INTO l_space_assignment_id,
1573: l_object_version_number;
1574: IF c_space_assign_cur%NOTFOUND THEN
1575: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1576: FND_MESSAGE.set_name('AHL', 'AHL_LTP_RECORD_NOT_FOUND');
1577: FND_MSG_PUB.add;
1578: END IF;
1579: CLOSE c_space_assign_cur;
1580: RAISE FND_API.g_exc_error;

Line 1591: FND_MESSAGE.set_name('AHL', 'AHL_COM_RECORD_CHANGED');

1587: END IF;
1588: --Check for object version number
1589: IF l_object_version_number <> p_space_assign_rec.object_version_number
1590: THEN
1591: FND_MESSAGE.set_name('AHL', 'AHL_COM_RECORD_CHANGED');
1592: FND_MSG_PUB.add;
1593: RAISE FND_API.g_exc_error;
1594: END IF;
1595: -------------------Call Table handler generated procedure------------

Line 1845: Fnd_Message.SET_NAME('AHL','AHL_LTP_VISIT_NOT_EXISTS');

1841: x_error_msg_code => l_msg_data);
1842:
1843: IF NVL(l_return_status,'x') <> 'S'
1844: THEN
1845: Fnd_Message.SET_NAME('AHL','AHL_LTP_VISIT_NOT_EXISTS');
1846: Fnd_Message.SET_TOKEN('VISITID',p_x_schedule_visit_rec.visit_number);
1847: Fnd_Msg_Pub.ADD;
1848: END IF;
1849: END IF;

Line 1846: Fnd_Message.SET_TOKEN('VISITID',p_x_schedule_visit_rec.visit_number);

1842:
1843: IF NVL(l_return_status,'x') <> 'S'
1844: THEN
1845: Fnd_Message.SET_NAME('AHL','AHL_LTP_VISIT_NOT_EXISTS');
1846: Fnd_Message.SET_TOKEN('VISITID',p_x_schedule_visit_rec.visit_number);
1847: Fnd_Msg_Pub.ADD;
1848: END IF;
1849: END IF;
1850:

Line 1866: Fnd_Message.SET_NAME('AHL','AHL_LTP_ORG_REQUIRED');

1862: IF ( p_x_schedule_visit_rec.org_name IS NULL OR
1863: p_x_schedule_visit_rec.org_name = FND_API.G_MISS_CHAR) THEN
1864: -- anraj: if visit is in planning Organization is not mandatory
1865: IF (l_schedule_visit_rec.status_code <> 'PLANNING') THEN
1866: Fnd_Message.SET_NAME('AHL','AHL_LTP_ORG_REQUIRED');
1867: Fnd_Msg_Pub.ADD;
1868: END IF;
1869: END IF;
1870:

Line 1879: Fnd_Message.SET_NAME('AHL','AHL_LTP_DEPT_REQUIRED');

1875: IF ( p_x_schedule_visit_rec.dept_name IS NULL OR
1876: p_x_schedule_visit_rec.dept_name = FND_API.G_MISS_CHAR) THEN
1877: -- anraj: if visit is in planning Department is not mandatory
1878: IF (l_schedule_visit_rec.status_code <> 'PLANNING') THEN
1879: Fnd_Message.SET_NAME('AHL','AHL_LTP_DEPT_REQUIRED');
1880: Fnd_Msg_Pub.ADD;
1881: END IF;
1882: END IF;
1883: --

Line 1889: Fnd_Message.SET_NAME('AHL','AHL_LTP_START_DATE_INVALID');

1885: -- Check for visit start date
1886: IF ( p_x_schedule_visit_rec.start_date IS NULL AND
1887: p_x_schedule_visit_rec.start_date = FND_API.G_MISS_DATE)
1888: THEN
1889: Fnd_Message.SET_NAME('AHL','AHL_LTP_START_DATE_INVALID');
1890: Fnd_Msg_Pub.ADD;
1891: RAISE Fnd_Api.G_EXC_ERROR;
1892: END IF;
1893: --

Line 1914: Fnd_Message.SET_NAME('AHL','AHL_LTP_SP_CATEGORY_NOT_EXIST');

1910: x_return_status => l_return_status);
1911:
1912: IF NVL(l_return_status, 'X') <> 'S'
1913: THEN
1914: Fnd_Message.SET_NAME('AHL','AHL_LTP_SP_CATEGORY_NOT_EXIST');
1915: Fnd_Msg_Pub.ADD;
1916: RAISE Fnd_Api.G_EXC_ERROR;
1917: END IF;
1918: ELSE

Line 1946: Fnd_Message.SET_NAME('AHL','AHL_LTP_VISIT_TYPE_NOT_EXISTS');

1942: x_return_status => l_return_status);
1943:
1944: IF NVL(l_return_status, 'X') <> 'S'
1945: THEN
1946: Fnd_Message.SET_NAME('AHL','AHL_LTP_VISIT_TYPE_NOT_EXISTS');
1947: Fnd_Message.SET_TOKEN('VISIT',p_x_schedule_visit_rec.visit_type_mean);
1948: Fnd_Msg_Pub.ADD;
1949: END IF;
1950: ELSE

Line 1947: Fnd_Message.SET_TOKEN('VISIT',p_x_schedule_visit_rec.visit_type_mean);

1943:
1944: IF NVL(l_return_status, 'X') <> 'S'
1945: THEN
1946: Fnd_Message.SET_NAME('AHL','AHL_LTP_VISIT_TYPE_NOT_EXISTS');
1947: Fnd_Message.SET_TOKEN('VISIT',p_x_schedule_visit_rec.visit_type_mean);
1948: Fnd_Msg_Pub.ADD;
1949: END IF;
1950: ELSE
1951: -- Id presents

Line 1961: Fnd_Message.SET_NAME('AHL','AHL_LTP_VISIT_TYPE_REQUIRED');

1957: --Commented by mpothuku on 02/25/04 as Visit type in not mandatory
1958: /*
1959: ELSIF (l_schedule_visit_rec.status_code <> 'PLANNING' )
1960: THEN
1961: Fnd_Message.SET_NAME('AHL','AHL_LTP_VISIT_TYPE_REQUIRED');
1962: Fnd_Msg_Pub.ADD;
1963: RAISE Fnd_Api.G_EXC_ERROR;
1964: */
1965: END IF;

Line 1971: Fnd_Message.SET_NAME('AHL','AHL_LTP_INVALID_RECORD');

1967: END IF;
1968: --
1969: IF p_x_schedule_visit_rec.object_version_number <> l_schedule_visit_rec.object_version_number
1970: THEN
1971: Fnd_Message.SET_NAME('AHL','AHL_LTP_INVALID_RECORD');
1972: Fnd_Msg_Pub.ADD;
1973: END IF;
1974:
1975: -- Check for visit status

Line 1978: Fnd_Message.SET_NAME('AHL','AHL_VISIT_NOT_PLANNED');

1974:
1975: -- Check for visit status
1976: -- anraj : Commented the following block as Impelmented/Partially Implemented visits can also be updated.
1977: /* IF (l_schedule_visit_rec.status_code <> 'PLANNING' )THEN
1978: Fnd_Message.SET_NAME('AHL','AHL_VISIT_NOT_PLANNED');
1979: Fnd_Msg_Pub.ADD;
1980: RAISE Fnd_Api.G_EXC_ERROR;
1981: END IF;
1982: */

Line 2417: Fnd_Message.SET_NAME('AHL','AHL_LTP_VISIT_NOT_EXISTS');

2413: x_error_msg_code => l_msg_data);
2414:
2415: IF NVL(l_return_status,'x') <> 'S'
2416: THEN
2417: Fnd_Message.SET_NAME('AHL','AHL_LTP_VISIT_NOT_EXISTS');
2418: Fnd_Message.SET_TOKEN('VISITID',p_x_schedule_visit_rec.visit_number);
2419: Fnd_Msg_Pub.ADD;
2420: END IF;
2421: END IF;

Line 2418: Fnd_Message.SET_TOKEN('VISITID',p_x_schedule_visit_rec.visit_number);

2414:
2415: IF NVL(l_return_status,'x') <> 'S'
2416: THEN
2417: Fnd_Message.SET_NAME('AHL','AHL_LTP_VISIT_NOT_EXISTS');
2418: Fnd_Message.SET_TOKEN('VISITID',p_x_schedule_visit_rec.visit_number);
2419: Fnd_Msg_Pub.ADD;
2420: END IF;
2421: END IF;
2422: --Assign the returned value

Line 2432: Fnd_Message.SET_NAME('AHL','AHL_LTP_INAVLID_RECORD');

2428: CLOSE c_schedule_visit_cur;
2429: --
2430: IF p_x_schedule_visit_rec.object_version_number <> l_object_version_number
2431: THEN
2432: Fnd_Message.SET_NAME('AHL','AHL_LTP_INAVLID_RECORD');
2433: Fnd_Msg_Pub.ADD;
2434: RAISE Fnd_Api.G_EXC_ERROR;
2435: END IF;
2436: -- Check for visit status

Line 2438: Fnd_Message.SET_NAME('AHL','AHL_VISIT_NOT_PLANNED');

2434: RAISE Fnd_Api.G_EXC_ERROR;
2435: END IF;
2436: -- Check for visit status
2437: IF (l_visit_status_code <> 'PLANNING' )THEN
2438: Fnd_Message.SET_NAME('AHL','AHL_VISIT_NOT_PLANNED');
2439: Fnd_Msg_Pub.ADD;
2440: RAISE Fnd_Api.G_EXC_ERROR;
2441: END IF;
2442: --

Line 2458: Fnd_Message.SET_NAME('AHL','AHL_LTP_MRP_SCHEDUl_ITEM');

2454: --Check for Item scheduled
2455: OPEN c_visit_task_matrl_cur(l_schedule_material_id);
2456: FETCH c_visit_task_matrl_cur INTO l_scheduled_date,l_scheduled_quantity;
2457: IF l_scheduled_date IS NOT NULL THEN
2458: Fnd_Message.SET_NAME('AHL','AHL_LTP_MRP_SCHEDUl_ITEM');
2459: Fnd_Msg_Pub.ADD;
2460: CLOSE c_visit_task_matrl_cur;
2461: RAISE Fnd_Api.G_EXC_ERROR;
2462: ELSE