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

Line 319: FND_MESSAGE.set_name('AHL', 'AHL_APPR_RECORD_NOT_FOUND');

315: OPEN c_space_rec;
316: FETCH c_space_rec INTO l_space_rec;
317: IF c_space_rec%NOTFOUND THEN
318: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
319: FND_MESSAGE.set_name('AHL', 'AHL_APPR_RECORD_NOT_FOUND');
320: FND_MSG_PUB.add;
321: RAISE Fnd_Api.G_EXC_ERROR;
322: END IF;
323: END IF;

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

325: --
326: --Check for object version number
327: IF (l_space_rec.object_version_number <> p_space_rec.object_version_number)
328: THEN
329: Fnd_Message.SET_NAME('AHL','AHL_COM_RECORD_CHANGED');
330: Fnd_Msg_Pub.ADD;
331: RAISE Fnd_Api.G_EXC_ERROR;
332: END IF;
333: --

Line 342: Fnd_Message.SET_NAME('AHL','AHL_APPR_SPACE_NAME_EXISTS');

338: IF G_DEBUG='Y' THEN
339: AHL_DEBUG_PUB.debug( 'DUMMY'||l_dummy);
340: END IF;
341: IF l_dummy IS NOT NULL THEN
342: Fnd_Message.SET_NAME('AHL','AHL_APPR_SPACE_NAME_EXISTS');
343: Fnd_Msg_Pub.ADD;
344: RAISE Fnd_Api.G_EXC_ERROR;
345: END IF;
346: END IF;

Line 522: Fnd_Message.set_name('AHL', 'AHL_APPR_ORG_REQUIRED');

518: THEN
519: -- missing required fields
520: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.G_MSG_LVL_ERROR)
521: THEN
522: Fnd_Message.set_name('AHL', 'AHL_APPR_ORG_REQUIRED');
523: Fnd_Msg_Pub.ADD;
524: END IF;
525: x_return_status := Fnd_Api.G_RET_STS_ERROR;
526: END IF;

Line 534: Fnd_Message.set_name('AHL', 'AHL_APPR_DEPT_REQUIRED');

530: THEN
531: -- missing required fields
532: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.G_MSG_LVL_ERROR)
533: THEN
534: Fnd_Message.set_name('AHL', 'AHL_APPR_DEPT_REQUIRED');
535: Fnd_Msg_Pub.ADD;
536: END IF;
537: x_return_status := Fnd_Api.G_RET_STS_ERROR;
538: END IF;

Line 546: Fnd_Message.set_name('AHL', 'AHL_APPR_SP_CATEGORY_NOT_EXIST');

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

Line 559: Fnd_Message.set_name('AHL', 'AHL_APPR_SPACE_NAME_NOT_EXIST');

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

Line 576: Fnd_Message.set_name('AHL', 'AHL_APPR_SPACE_NAME_EXISTS');

572: ) = Fnd_Api.g_false
573: THEN
574: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error)
575: THEN
576: Fnd_Message.set_name('AHL', 'AHL_APPR_SPACE_NAME_EXISTS');
577: Fnd_Msg_Pub.ADD;
578: END IF;
579: x_return_status := Fnd_Api.g_ret_sts_error;
580: END IF;

Line 588: Fnd_Message.set_name('AHL', 'AHL_APPR_SPACE_NAME_EXISTS');

584: p_space_rec.space_id IS NULL) THEN
585: OPEN space_name_cur(p_space_rec.space_name,p_space_rec.department_id);
586: FETCH space_name_cur INTO l_space_name;
587: IF l_space_name IS NOT NULL THEN
588: Fnd_Message.set_name('AHL', 'AHL_APPR_SPACE_NAME_EXISTS');
589: Fnd_Msg_Pub.ADD;
590: END IF;
591: CLOSE space_name_cur;
592: END IF;

Line 604: Fnd_Message.set_name('AHL', 'AHL_APPR_SPACE_ASSIGN_EXISTS');

600: FROM AHL_SPACE_ASSIGNMENTS
601: WHERE space_id = p_space_rec.space_id;
602: --
603: IF l_space_id IS NOT NULL THEN
604: Fnd_Message.set_name('AHL', 'AHL_APPR_SPACE_ASSIGN_EXISTS');
605: Fnd_Msg_Pub.ADD;
606: ELSE
607: OPEN space_name_cur(p_space_rec.space_name,p_space_rec.department_id);
608: FETCH space_name_cur INTO l_space_name;

Line 610: Fnd_Message.set_name('AHL', 'AHL_APPR_SPACE_NAME_EXISTS');

606: ELSE
607: OPEN space_name_cur(p_space_rec.space_name,p_space_rec.department_id);
608: FETCH space_name_cur INTO l_space_name;
609: IF l_space_name IS NOT NULL THEN
610: Fnd_Message.set_name('AHL', 'AHL_APPR_SPACE_NAME_EXISTS');
611: Fnd_Msg_Pub.ADD;
612: END IF;
613: CLOSE space_name_cur;
614: END IF;

Line 857: Fnd_Message.SET_NAME('AHL','AHL_APPR_ORG_ID_NOT_EXISTS');

853: x_error_msg_code => l_msg_data);
854:
855: IF NVL(l_return_status,'x') <> 'S'
856: THEN
857: Fnd_Message.SET_NAME('AHL','AHL_APPR_ORG_ID_NOT_EXISTS');
858: Fnd_Msg_Pub.ADD;
859: END IF;
860: ELSE
861: Fnd_Message.SET_NAME('AHL','AHL_APPR_ORG_REQUIRED');

Line 861: Fnd_Message.SET_NAME('AHL','AHL_APPR_ORG_REQUIRED');

857: Fnd_Message.SET_NAME('AHL','AHL_APPR_ORG_ID_NOT_EXISTS');
858: Fnd_Msg_Pub.ADD;
859: END IF;
860: ELSE
861: Fnd_Message.SET_NAME('AHL','AHL_APPR_ORG_REQUIRED');
862: Fnd_Msg_Pub.ADD;
863: END IF;
864:
865: --Assign the returned value

Line 885: Fnd_Message.SET_NAME('AHL','AHL_APPR_DEPT_ID_NOT_EXIST');

881: x_error_msg_code => l_msg_data);
882:
883: IF NVL(l_return_status,'x') <> 'S'
884: THEN
885: Fnd_Message.SET_NAME('AHL','AHL_APPR_DEPT_ID_NOT_EXIST');
886: Fnd_Msg_Pub.ADD;
887: END IF;
888: ELSE
889: Fnd_Message.SET_NAME('AHL','AHL_APPR_DEPT_REQUIRED');

Line 889: Fnd_Message.SET_NAME('AHL','AHL_APPR_DEPT_REQUIRED');

885: Fnd_Message.SET_NAME('AHL','AHL_APPR_DEPT_ID_NOT_EXIST');
886: Fnd_Msg_Pub.ADD;
887: END IF;
888: ELSE
889: Fnd_Message.SET_NAME('AHL','AHL_APPR_DEPT_REQUIRED');
890: Fnd_Msg_Pub.ADD;
891: END IF;
892:
893:

Line 911: Fnd_Message.SET_NAME('AHL','AHL_APPR_SP_CATEGORY_NOT_EXIST');

907: x_return_status => l_return_status);
908:
909: IF NVL(l_return_status, 'X') <> 'S'
910: THEN
911: Fnd_Message.SET_NAME('AHL','AHL_APPR_SP_CATEGORY_NOT_EXIST');
912: Fnd_Msg_Pub.ADD;
913: END IF;
914: END IF;
915: -- Id presents

Line 921: Fnd_Message.SET_NAME('AHL','AHL_APPR_SP_CATEGORY_NOT_EXIST');

917: p_x_space_rec.space_category_code <> Fnd_Api.G_MISS_CHAR
918: THEN
919: l_space_rec.space_category_code := p_x_space_rec.space_category_code;
920: ELSE
921: Fnd_Message.SET_NAME('AHL','AHL_APPR_SP_CATEGORY_NOT_EXIST');
922: Fnd_Msg_Pub.ADD;
923: END IF;
924: --
925: --SPACE_NAME

Line 930: Fnd_Message.set_name('AHL', 'AHL_APPR_SPACE_NAME_NOT_EXIST');

926: IF (p_x_space_rec.space_name = Fnd_Api.G_MISS_CHAR OR
927: p_x_space_rec.SPACE_NAME IS NULL)
928: THEN
929: -- missing required fields
930: Fnd_Message.set_name('AHL', 'AHL_APPR_SPACE_NAME_NOT_EXIST');
931: Fnd_Msg_Pub.ADD;
932: END IF;
933:
934: --Standard check to count messages

Line 980: Fnd_Message.SET_NAME('AHL','AHL_APPR_SEQUENCE_NOT_EXISTS');

976: -- If the value for the ID already exists, then
977: -- l_dummy would be populated with '1', otherwise,
978: -- it receives NULL.
979: IF l_dummy IS NOT NULL THEN
980: Fnd_Message.SET_NAME('AHL','AHL_APPR_SEQUENCE_NOT_EXISTS');
981: Fnd_Msg_Pub.ADD;
982: END IF;
983: -- For optional fields
984: IF p_x_space_rec.description = FND_API.G_MISS_CHAR

Line 1325: Fnd_Message.SET_NAME('AHL','AHL_APPR_SPACE_NOT_EXISTS');

1321: x_error_msg_code => l_msg_data);
1322:
1323: IF NVL(l_return_status,'x') <> 'S'
1324: THEN
1325: Fnd_Message.SET_NAME('AHL','AHL_APPR_SPACE_NOT_EXISTS');
1326: Fnd_Message.SET_TOKEN('SPACEID',l_space_rec.space_name);
1327: Fnd_Msg_Pub.ADD;
1328: END IF;
1329: ELSE

Line 1326: Fnd_Message.SET_TOKEN('SPACEID',l_space_rec.space_name);

1322:
1323: IF NVL(l_return_status,'x') <> 'S'
1324: THEN
1325: Fnd_Message.SET_NAME('AHL','AHL_APPR_SPACE_NOT_EXISTS');
1326: Fnd_Message.SET_TOKEN('SPACEID',l_space_rec.space_name);
1327: Fnd_Msg_Pub.ADD;
1328: END IF;
1329: ELSE
1330: Fnd_Message.SET_NAME('AHL','AHL_APPR_SPACE_ID_NOT_EXIST');

Line 1330: Fnd_Message.SET_NAME('AHL','AHL_APPR_SPACE_ID_NOT_EXIST');

1326: Fnd_Message.SET_TOKEN('SPACEID',l_space_rec.space_name);
1327: Fnd_Msg_Pub.ADD;
1328: END IF;
1329: ELSE
1330: Fnd_Message.SET_NAME('AHL','AHL_APPR_SPACE_ID_NOT_EXIST');
1331: Fnd_Msg_Pub.ADD;
1332: RAISE Fnd_Api.G_EXC_ERROR;
1333: END IF;
1334:

Line 1342: Fnd_Message.set_name('AHL', 'AHL_APPR_SPACE_NAME_NOT_EXIST');

1338: --Check for space name
1339: IF (l_space_rec.space_name IS NULL OR
1340: l_space_rec.space_name = fnd_api.g_miss_char)
1341: THEN
1342: Fnd_Message.set_name('AHL', 'AHL_APPR_SPACE_NAME_NOT_EXIST');
1343: Fnd_Msg_Pub.ADD;
1344: RAISE Fnd_Api.G_EXC_ERROR;
1345: END IF;
1346:

Line 1361: Fnd_Message.SET_NAME('AHL','AHL_APPR_SP_CATEGORY_NOT_EXIST');

1357: x_return_status => l_return_status);
1358:
1359: IF NVL(l_return_status, 'X') <> 'S'
1360: THEN
1361: Fnd_Message.SET_NAME('AHL','AHL_APPR_SP_CATEGORY_NOT_EXIST');
1362: Fnd_Msg_Pub.ADD;
1363: END IF;
1364: END IF;
1365: -- Id presents

Line 1386: Fnd_Message.SET_NAME('AHL','AHL_APPR_SP_STATUS_NOT_EXIST');

1382: x_return_status => l_return_status);
1383:
1384: IF NVL(l_return_status, 'X') <> 'S'
1385: THEN
1386: Fnd_Message.SET_NAME('AHL','AHL_APPR_SP_STATUS_NOT_EXIST');
1387: Fnd_Msg_Pub.ADD;
1388: END IF;
1389: END IF;
1390: -- Id presents

Line 1619: FND_MESSAGE.set_name('AHL', 'AHL_APPR_RECORD_NOT_FOUND');

1615: FETCH c_space_cur INTO l_space_id,
1616: l_object_version_number;
1617: IF c_space_cur%NOTFOUND THEN
1618: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1619: FND_MESSAGE.set_name('AHL', 'AHL_APPR_RECORD_NOT_FOUND');
1620: FND_MSG_PUB.add;
1621: END IF;
1622: CLOSE c_space_cur;
1623: RAISE FND_API.g_exc_error;

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

1625: CLOSE c_space_cur;
1626: --Check for object version number
1627: IF l_object_version_number <> p_space_rec.object_version_number
1628: THEN
1629: FND_MESSAGE.set_name('AHL', 'AHL_COM_RECORD_CHANGED');
1630: FND_MSG_PUB.add;
1631: RAISE FND_API.g_exc_error;
1632: END IF;
1633: --Ckeck for any visits assigned

Line 1645: FND_MESSAGE.set_name('AHL', 'AHL_APPR_SP_VISITS_ASSIGNED');

1641: FETCH get_status_cur INTO l_visit_status_code;
1642: CLOSE get_status_cur;
1643: --
1644: IF l_visit_status_code <> 'CLOSED' THEN
1645: FND_MESSAGE.set_name('AHL', 'AHL_APPR_SP_VISITS_ASSIGNED');
1646: FND_MSG_PUB.add;
1647: RAISE Fnd_Api.G_EXC_ERROR;
1648: ELSE
1649: UPDATE AHL_SPACES_B

Line 1888: FND_MESSAGE.set_name('AHL', 'AHL_APPR_RECORD_NOT_FOUND');

1884: OPEN c_space_capbl_rec;
1885: FETCH c_space_capbl_rec INTO l_space_capbl_rec;
1886: IF c_space_capbl_rec%NOTFOUND THEN
1887: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1888: FND_MESSAGE.set_name('AHL', 'AHL_APPR_RECORD_NOT_FOUND');
1889: FND_MSG_PUB.add;
1890: RAISE Fnd_Api.G_EXC_ERROR;
1891: END IF;
1892: END IF;

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

1904:
1905: --Check for object version number
1906: IF (l_space_capbl_rec.object_version_number <> p_space_capbl_rec.object_version_number)
1907: THEN
1908: Fnd_Message.SET_NAME('AHL','AHL_COM_RECORD_CHANGED');
1909: Fnd_Msg_Pub.ADD;
1910: RAISE Fnd_Api.G_EXC_ERROR;
1911: END IF;
1912: -- SPACE ID

Line 2055: Fnd_Message.set_name('AHL', 'AHL_APPR_ORG_ID_NOT_EXISTS');

2051: THEN
2052: -- missing required fields
2053: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.G_MSG_LVL_ERROR)
2054: THEN
2055: Fnd_Message.set_name('AHL', 'AHL_APPR_ORG_ID_NOT_EXISTS');
2056: Fnd_Msg_Pub.ADD;
2057: END IF;
2058: x_return_status := Fnd_Api.G_RET_STS_ERROR;
2059: END IF;

Line 2067: Fnd_Message.set_name('AHL', 'AHL_APPR_DEPT_ID_NOT_EXIST');

2063: THEN
2064: -- missing required fields
2065: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.G_MSG_LVL_ERROR)
2066: THEN
2067: Fnd_Message.set_name('AHL', 'AHL_APPR_DEPT_ID_NOT_EXIST');
2068: Fnd_Msg_Pub.ADD;
2069: END IF;
2070: x_return_status := Fnd_Api.G_RET_STS_ERROR;
2071: END IF;

Line 2079: Fnd_Message.set_name('AHL', 'AHL_APPR_VISIT_TYPE_NOT_EXIST');

2075: THEN
2076: -- missing required fields
2077: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.G_MSG_LVL_ERROR)
2078: THEN
2079: Fnd_Message.set_name('AHL', 'AHL_APPR_VISIT_TYPE_NOT_EXIST');
2080: Fnd_Msg_Pub.ADD;
2081: END IF;
2082: x_return_status := Fnd_Api.G_RET_STS_ERROR;
2083: END IF;

Line 2092: Fnd_Message.set_name('AHL', 'AHL_APPR_INV_ITEM_NOT_EXIST');

2088: THEN
2089: -- missing required fields
2090: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.G_MSG_LVL_ERROR)
2091: THEN
2092: Fnd_Message.set_name('AHL', 'AHL_APPR_INV_ITEM_NOT_EXIST');
2093: Fnd_Msg_Pub.ADD;
2094: END IF;
2095: x_return_status := Fnd_Api.G_RET_STS_ERROR;
2096: END IF;

Line 2110: Fnd_Message.set_name('AHL', 'AHL_APPR_SPACE_CAPBL_DUPL_ID');

2106: ) = Fnd_Api.g_false
2107: THEN
2108: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error)
2109: THEN
2110: Fnd_Message.set_name('AHL', 'AHL_APPR_SPACE_CAPBL_DUPL_ID');
2111: Fnd_Msg_Pub.ADD;
2112: END IF;
2113: x_return_status := Fnd_Api.g_ret_sts_error;
2114: END IF;

Line 2134: Fnd_Message.set_name('AHL', 'AHL_APPR_SPACE_CAPBL_DUPL_ID');

2130: p_space_capbl_rec.inventory_item_id,
2131: p_space_capbl_rec.space_id);
2132: FETCH check_unique_cur INTO l_dummy;
2133: IF l_dummy is NOT NULL THEN
2134: Fnd_Message.set_name('AHL', 'AHL_APPR_SPACE_CAPBL_DUPL_ID');
2135: Fnd_Msg_Pub.ADD;
2136: END IF;
2137: x_return_status := Fnd_Api.g_ret_sts_error;
2138: END IF;

Line 2396: Fnd_Message.SET_NAME('AHL','AHL_APPR_SPACE_NOT_EXISTS');

2392: x_error_msg_code => l_msg_data);
2393:
2394: IF NVL(l_return_status,'x') <> 'S'
2395: THEN
2396: Fnd_Message.SET_NAME('AHL','AHL_APPR_SPACE_NOT_EXISTS');
2397: Fnd_Message.SET_TOKEN('ORGID',p_x_space_capblts_rec.space_name);
2398: Fnd_Msg_Pub.ADD;
2399: END IF;
2400: END IF;

Line 2397: Fnd_Message.SET_TOKEN('ORGID',p_x_space_capblts_rec.space_name);

2393:
2394: IF NVL(l_return_status,'x') <> 'S'
2395: THEN
2396: Fnd_Message.SET_NAME('AHL','AHL_APPR_SPACE_NOT_EXISTS');
2397: Fnd_Message.SET_TOKEN('ORGID',p_x_space_capblts_rec.space_name);
2398: Fnd_Msg_Pub.ADD;
2399: END IF;
2400: END IF;
2401: --Assign the returned value

Line 2419: Fnd_Message.SET_NAME('AHL','AHL_APPR_ORG_NT_EXISTS');

2415: x_error_msg_code => l_msg_data);
2416:
2417: IF NVL(l_return_status,'x') <> 'S'
2418: THEN
2419: Fnd_Message.SET_NAME('AHL','AHL_APPR_ORG_NT_EXISTS');
2420: Fnd_Message.SET_TOKEN('ORGID',p_x_space_capblts_rec.org_name);
2421: Fnd_Msg_Pub.ADD;
2422: END IF;
2423: END IF;

Line 2420: Fnd_Message.SET_TOKEN('ORGID',p_x_space_capblts_rec.org_name);

2416:
2417: IF NVL(l_return_status,'x') <> 'S'
2418: THEN
2419: Fnd_Message.SET_NAME('AHL','AHL_APPR_ORG_NT_EXISTS');
2420: Fnd_Message.SET_TOKEN('ORGID',p_x_space_capblts_rec.org_name);
2421: Fnd_Msg_Pub.ADD;
2422: END IF;
2423: END IF;
2424: --Assign the returned value

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

2454: x_error_msg_code => l_msg_data);
2455:
2456: IF NVL(l_return_status,'x') <> 'S'
2457: THEN
2458: Fnd_Message.SET_NAME('AHL','AHL_APPR_ITEM_NOT_EXISTS');
2459: Fnd_Message.SET_TOKEN('ITEM',p_x_space_capblts_rec.item_description);
2460: Fnd_Msg_Pub.ADD;
2461: END IF;
2462: --Assign the returned value

Line 2459: Fnd_Message.SET_TOKEN('ITEM',p_x_space_capblts_rec.item_description);

2455:
2456: IF NVL(l_return_status,'x') <> 'S'
2457: THEN
2458: Fnd_Message.SET_NAME('AHL','AHL_APPR_ITEM_NOT_EXISTS');
2459: Fnd_Message.SET_TOKEN('ITEM',p_x_space_capblts_rec.item_description);
2460: Fnd_Msg_Pub.ADD;
2461: END IF;
2462: --Assign the returned value
2463: p_x_space_capblts_rec.inventory_item_id := l_inventory_item_id;

Line 2488: Fnd_Message.SET_NAME('AHL','AHL_APPR_VISIT_TYPE_NOT_EXISTS');

2484: x_return_status => l_return_status);
2485:
2486: IF NVL(l_return_status, 'X') <> 'S'
2487: THEN
2488: Fnd_Message.SET_NAME('AHL','AHL_APPR_VISIT_TYPE_NOT_EXISTS');
2489: Fnd_Message.SET_TOKEN('VISIT',p_x_space_capblts_rec.visit_type_mean);
2490: Fnd_Msg_Pub.ADD;
2491: END IF;
2492: -- END IF;

Line 2489: Fnd_Message.SET_TOKEN('VISIT',p_x_space_capblts_rec.visit_type_mean);

2485:
2486: IF NVL(l_return_status, 'X') <> 'S'
2487: THEN
2488: Fnd_Message.SET_NAME('AHL','AHL_APPR_VISIT_TYPE_NOT_EXISTS');
2489: Fnd_Message.SET_TOKEN('VISIT',p_x_space_capblts_rec.visit_type_mean);
2490: Fnd_Msg_Pub.ADD;
2491: END IF;
2492: -- END IF;
2493: -- Id presents

Line 2499: Fnd_Message.SET_NAME('AHL','AHL_APPR_VISIT_TYPE_NOT_EXIST');

2495: p_x_space_capblts_rec.visit_type_code <> Fnd_Api.G_MISS_CHAR
2496: THEN
2497: l_space_capblts_rec.visit_type_code := p_x_space_capblts_rec.visit_type_code;
2498: ELSE
2499: Fnd_Message.SET_NAME('AHL','AHL_APPR_VISIT_TYPE_NOT_EXIST');
2500: Fnd_Msg_Pub.ADD;
2501: END IF;
2502: -- Assign return value
2503: p_x_space_capblts_rec.visit_type_code := l_space_capblts_rec.visit_type_code;

Line 2564: Fnd_Message.SET_NAME('AHL','AHL_APPR_SEQUENCE_NOT_EXISTS');

2560: -- If the value for the ID already exists, then
2561: -- l_dummy would be populated with '1', otherwise,
2562: -- it receives NULL.
2563: IF l_dummy IS NOT NULL THEN
2564: Fnd_Message.SET_NAME('AHL','AHL_APPR_SEQUENCE_NOT_EXISTS');
2565: Fnd_Msg_Pub.ADD;
2566: END IF;
2567: -- For optional fields
2568: --

Line 2940: Fnd_Message.SET_NAME('AHL','AHL_APPR_ORG_NT_EXISTS');

2936: x_error_msg_code => l_msg_data);
2937:
2938: IF NVL(l_return_status,'x') <> 'S'
2939: THEN
2940: Fnd_Message.SET_NAME('AHL','AHL_APPR_ORG_NT_EXISTS');
2941: Fnd_Message.SET_TOKEN('ORGID',p_space_capblts_rec.org_name);
2942: Fnd_Msg_Pub.ADD;
2943: END IF;
2944: END IF;

Line 2941: Fnd_Message.SET_TOKEN('ORGID',p_space_capblts_rec.org_name);

2937:
2938: IF NVL(l_return_status,'x') <> 'S'
2939: THEN
2940: Fnd_Message.SET_NAME('AHL','AHL_APPR_ORG_NT_EXISTS');
2941: Fnd_Message.SET_TOKEN('ORGID',p_space_capblts_rec.org_name);
2942: Fnd_Msg_Pub.ADD;
2943: END IF;
2944: END IF;
2945: --Assign the returned value

Line 2964: Fnd_Message.SET_NAME('AHL','AHL_APPR_SPACE_NOT_EXISTS');

2960: x_error_msg_code => l_msg_data);
2961:
2962: IF NVL(l_return_status,'x') <> 'S'
2963: THEN
2964: Fnd_Message.SET_NAME('AHL','AHL_APPR_SPACE_NOT_EXISTS');
2965: Fnd_Message.SET_TOKEN('SPACEID',p_space_capblts_rec.space_name);
2966: Fnd_Msg_Pub.ADD;
2967: END IF;
2968: END IF;

Line 2965: Fnd_Message.SET_TOKEN('SPACEID',p_space_capblts_rec.space_name);

2961:
2962: IF NVL(l_return_status,'x') <> 'S'
2963: THEN
2964: Fnd_Message.SET_NAME('AHL','AHL_APPR_SPACE_NOT_EXISTS');
2965: Fnd_Message.SET_TOKEN('SPACEID',p_space_capblts_rec.space_name);
2966: Fnd_Msg_Pub.ADD;
2967: END IF;
2968: END IF;
2969: --Assign the returned value

Line 2997: Fnd_Message.SET_NAME('AHL','AHL_APPR_ITEM_NOT_EXISTS');

2993: x_error_msg_code => l_msg_data);
2994:
2995: IF NVL(l_return_status,'x') <> 'S'
2996: THEN
2997: Fnd_Message.SET_NAME('AHL','AHL_APPR_ITEM_NOT_EXISTS');
2998: Fnd_Message.SET_TOKEN('DEPTID',p_space_capblts_rec.item_description);
2999: Fnd_Msg_Pub.ADD;
3000: END IF;
3001: END IF;

Line 2998: Fnd_Message.SET_TOKEN('DEPTID',p_space_capblts_rec.item_description);

2994:
2995: IF NVL(l_return_status,'x') <> 'S'
2996: THEN
2997: Fnd_Message.SET_NAME('AHL','AHL_APPR_ITEM_NOT_EXISTS');
2998: Fnd_Message.SET_TOKEN('DEPTID',p_space_capblts_rec.item_description);
2999: Fnd_Msg_Pub.ADD;
3000: END IF;
3001: END IF;
3002: --Assign the returned value

Line 3019: Fnd_Message.SET_NAME('AHL','AHL_APPR_VISIT_TYPE_NOT_EXIST');

3015: x_return_status => l_return_status);
3016:
3017: IF NVL(l_return_status, 'X') <> 'S'
3018: THEN
3019: Fnd_Message.SET_NAME('AHL','AHL_APPR_VISIT_TYPE_NOT_EXIST');
3020: Fnd_Msg_Pub.ADD;
3021: END IF;
3022: END IF;
3023: -- Id presents

Line 3029: Fnd_Message.SET_NAME('AHL','AHL_APPR_VISIT_TYPE_NOT_EXIST');

3025: p_space_capblts_rec.visit_type_code <> Fnd_Api.G_MISS_CHAR
3026: THEN
3027: l_space_capblts_rec.visit_type_code := p_space_capblts_rec.visit_type_code;
3028: ELSE
3029: Fnd_Message.SET_NAME('AHL','AHL_APPR_VISIT_TYPE_NOT_EXIST');
3030: Fnd_Msg_Pub.ADD;
3031: END IF;
3032:
3033:

Line 3255: FND_MESSAGE.set_name('AHL', 'AHL_APPR_RECORD_NOT_FOUND');

3251: l_object_version_number,l_visit_type,
3252: l_inventory_item_id;
3253: IF c_space_capb_cur%NOTFOUND THEN
3254: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3255: FND_MESSAGE.set_name('AHL', 'AHL_APPR_RECORD_NOT_FOUND');
3256: FND_MSG_PUB.add;
3257: END IF;
3258: CLOSE c_space_capb_cur;
3259: RAISE FND_API.g_exc_error;

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

3262:
3263: --Check for object version number
3264: IF l_object_version_number <> p_space_capblts_rec.object_version_number
3265: THEN
3266: FND_MESSAGE.set_name('AHL', 'AHL_COM_RECORD_CHANGED');
3267: FND_MSG_PUB.add;
3268: RAISE FND_API.g_exc_error;
3269: END IF;
3270: -- Check for space assignment exists, If so any visit has same capability

Line 3279: FND_MESSAGE.set_name('AHL', 'AHL_CAPBL_ASIGN_TO_VIIST');

3275: IF l_visit_id IS NOT NULL THEN
3276: OPEN check_space_capb_cur(l_visit_id,l_visit_type,l_inventory_item_id);
3277: FETCH check_space_capb_cur INTO l_dummy;
3278: IF check_space_capb_cur%FOUND THEN
3279: FND_MESSAGE.set_name('AHL', 'AHL_CAPBL_ASIGN_TO_VIIST');
3280: FND_MSG_PUB.add;
3281: CLOSE check_space_capb_cur;
3282: RAISE FND_API.g_exc_error;
3283: END IF;