DBA Data[Home] [Help]

APPS.AHL_APPR_SPACE_UNAVL_PVT dependencies on FND_MESSAGE

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

264: OPEN c_space_restriction_rec;
265: FETCH c_space_restriction_rec INTO l_space_restriction_rec;
266: IF c_space_restriction_rec%NOTFOUND THEN
267: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
268: FND_MESSAGE.set_name('AHL', 'AHL_APPR_RECORD_NOT_FOUND');
269: FND_MSG_PUB.add;
270: RAISE Fnd_Api.G_EXC_ERROR;
271: END IF;
272: END IF;

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

273: CLOSE c_space_restriction_rec;
274: --Check for object version number
275: IF (l_space_restriction_rec.object_version_number <> p_space_restriction_rec.object_version_number)
276: THEN
277: Fnd_Message.SET_NAME('AHL','AHL_COM_RECORD_CHANGED');
278: Fnd_Msg_Pub.ADD;
279: RAISE Fnd_Api.G_EXC_ERROR;
280: END IF;
281: -- SPACE ID

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

392: THEN
393: -- missing required fields
394: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.G_MSG_LVL_ERROR)
395: THEN
396: Fnd_Message.set_name('AHL', 'AHL_APPR_ORG_REQUIRED');
397: Fnd_Msg_Pub.ADD;
398: END IF;
399: x_return_status := Fnd_Api.G_RET_STS_ERROR;
400: END IF;

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

406: THEN
407: -- missing required fields
408: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.G_MSG_LVL_ERROR)
409: THEN
410: Fnd_Message.set_name('AHL', 'AHL_APPR_DEPT_REQUIRED');
411: Fnd_Msg_Pub.ADD;
412: END IF;
413: x_return_status := Fnd_Api.G_RET_STS_ERROR;
414: END IF;

Line 424: Fnd_Message.set_name('AHL', 'AHL_APPR_SPACE_ID_NOT_EXIST');

420: THEN
421: -- missing required fields
422: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.G_MSG_LVL_ERROR)
423: THEN
424: Fnd_Message.set_name('AHL', 'AHL_APPR_SPACE_ID_NOT_EXIST');
425: Fnd_Msg_Pub.ADD;
426: END IF;
427: x_return_status := Fnd_Api.G_RET_STS_ERROR;
428: END IF;

Line 436: Fnd_Message.set_name('AHL', 'AHL_APPR_START_DATE_NOT_EXIST');

432: THEN
433: -- missing required fields
434: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.G_MSG_LVL_ERROR)
435: THEN
436: Fnd_Message.set_name('AHL', 'AHL_APPR_START_DATE_NOT_EXIST');
437: Fnd_Msg_Pub.ADD;
438: END IF;
439: x_return_status := Fnd_Api.G_RET_STS_ERROR;
440: END IF;

Line 448: Fnd_Message.set_name('AHL', 'AHL_APPR_END_DATE_NOT_EXIST');

444: THEN
445: -- missing required fields
446: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.G_MSG_LVL_ERROR)
447: THEN
448: Fnd_Message.set_name('AHL', 'AHL_APPR_END_DATE_NOT_EXIST');
449: Fnd_Msg_Pub.ADD;
450: END IF;
451: x_return_status := Fnd_Api.G_RET_STS_ERROR;
452: END IF;

Line 468: Fnd_Message.set_name('AHL', 'AHL_APPR_INVALID_SPACE_ID');

464: ) = Fnd_Api.G_FALSE
465: THEN
466: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.G_MSG_LVL_ERROR)
467: THEN
468: Fnd_Message.set_name('AHL', 'AHL_APPR_INVALID_SPACE_ID');
469: Fnd_Msg_Pub.ADD;
470: END IF;
471: x_return_status := Fnd_Api.G_RET_STS_ERROR;
472: END IF; -- check_fk_exists

Line 526: Fnd_Message.set_name('AHL', 'AHL_APPR_INVALID_START_DATE');

522: IF p_space_restriction_rec.START_DATE IS NOT NULL
523: THEN
524: IF p_space_restriction_rec.START_DATE < TRUNC(SYSDATE)
525: THEN
526: Fnd_Message.set_name('AHL', 'AHL_APPR_INVALID_START_DATE');
527: Fnd_Msg_Pub.ADD;
528: x_return_status := Fnd_Api.G_RET_STS_ERROR;
529: END IF;
530: END IF;

Line 538: Fnd_Message.set_name('AHL', 'AHL_APPR_INV_START_END_DATE');

534: p_space_restriction_rec.START_DATE IS NOT NULL)
535: THEN
536: IF( p_space_restriction_rec.END_DATE < p_space_restriction_rec.START_DATE )
537: THEN
538: Fnd_Message.set_name('AHL', 'AHL_APPR_INV_START_END_DATE');
539: Fnd_Msg_Pub.ADD;
540: x_return_status := Fnd_Api.G_RET_STS_ERROR;
541: END IF;
542: END IF;

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

543:
544: --
545: IF (p_space_restriction_rec.START_DATE IS NULL AND
546: p_space_restriction_rec.END_DATE IS NOT NULL) THEN
547: Fnd_Message.set_name('AHL', 'AHL_APPR_INVALID_START_DATE');
548: Fnd_Msg_Pub.ADD;
549: END IF;
550: --
551: ELSE

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

556: p_space_restriction_rec.START_DATE <> l_start_date)
557: THEN
558: IF p_space_restriction_rec.START_DATE < TRUNC(SYSDATE)
559: THEN
560: Fnd_Message.set_name('AHL', 'AHL_APPR_INVALID_START_DATE');
561: Fnd_Msg_Pub.ADD;
562: END IF;
563: END IF;
564: --

Line 572: Fnd_Message.set_name('AHL', 'AHL_APPR_INV_START_END_DATE');

568: p_space_restriction_rec.START_DATE <> l_start_date))
569: THEN
570: IF( p_space_restriction_rec.END_DATE < p_space_restriction_rec.START_DATE )
571: THEN
572: Fnd_Message.set_name('AHL', 'AHL_APPR_INV_START_END_DATE');
573: Fnd_Msg_Pub.ADD;
574: x_return_status := Fnd_Api.G_RET_STS_ERROR;
575: END IF;
576: END IF;

Line 585: Fnd_Message.set_name('AHL', 'AHL_APPR_INV_START_END_DATE');

581: p_space_restriction_rec.START_DATE = l_start_date))
582: THEN
583: IF( p_space_restriction_rec.END_DATE < p_space_restriction_rec.START_DATE )
584: THEN
585: Fnd_Message.set_name('AHL', 'AHL_APPR_INV_START_END_DATE');
586: Fnd_Msg_Pub.ADD;
587: x_return_status := Fnd_Api.G_RET_STS_ERROR;
588: END IF;
589: END IF;

Line 598: Fnd_Message.set_name('AHL', 'AHL_APPR_INV_START_END_DATE');

594: p_space_restriction_rec.START_DATE <> l_start_date))
595: THEN
596: IF( p_space_restriction_rec.END_DATE < p_space_restriction_rec.START_DATE )
597: THEN
598: Fnd_Message.set_name('AHL', 'AHL_APPR_INV_START_END_DATE');
599: Fnd_Msg_Pub.ADD;
600: x_return_status := Fnd_Api.G_RET_STS_ERROR;
601: END IF;
602: END IF;

Line 612: Fnd_Message.set_name('AHL', 'AHL_APPR_INV_START_END_DATE');

608: p_space_restriction_rec.START_DATE = l_start_date))
609: THEN
610: IF( p_space_restriction_rec.END_DATE < p_space_restriction_rec.START_DATE )
611: THEN
612: Fnd_Message.set_name('AHL', 'AHL_APPR_INV_START_END_DATE');
613: Fnd_Msg_Pub.ADD;
614: x_return_status := Fnd_Api.G_RET_STS_ERROR;
615: END IF;
616: END IF;

Line 627: Fnd_Message.set_name('AHL', 'AHL_APPR_INVALID_END_DATE');

623: (p_space_restriction_rec.END_DATE IS NOT NULL AND
624: p_space_restriction_rec.END_DATE <> l_end_date ))
625: THEN
626: IF p_space_restriction_rec.END_DATE < trunc(sysdate) THEN
627: Fnd_Message.set_name('AHL', 'AHL_APPR_INVALID_END_DATE');
628: Fnd_Msg_Pub.ADD;
629: x_return_status := Fnd_Api.G_RET_STS_ERROR;
630: END IF;
631: END IF; */

Line 637: Fnd_Message.set_name('AHL', 'AHL_APPR_INVALID_END_DATE');

633: IF (p_space_restriction_rec.END_DATE IS NOT NULL AND
634: p_space_restriction_rec.END_DATE <> l_end_date )
635: THEN
636: IF p_space_restriction_rec.END_DATE < trunc(sysdate) THEN
637: Fnd_Message.set_name('AHL', 'AHL_APPR_INVALID_END_DATE');
638: Fnd_Msg_Pub.ADD;
639: x_return_status := Fnd_Api.G_RET_STS_ERROR;
640: END IF;
641: END IF;

Line 656: Fnd_Message.set_name('AHL', 'AHL_APPR_SPACE_VISITS_EXIST');

652: IF l_visit_id IS NOT NULL THEN
653: IF (l_start_date_time >= p_space_restriction_rec.START_DATE
654: AND l_start_date_time <= p_space_restriction_rec.END_DATE)
655: THEN
656: Fnd_Message.set_name('AHL', 'AHL_APPR_SPACE_VISITS_EXIST');
657: Fnd_Msg_Pub.ADD;
658: END IF;
659: END IF;
660: END LOOP;

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

891: x_error_msg_code => l_msg_data);
892:
893: IF NVL(l_return_status,'x') <> 'S'
894: THEN
895: Fnd_Message.SET_NAME('AHL','AHL_APPR_ORG_NT_EXISTS');
896: Fnd_Message.SET_TOKEN('ORGID',p_x_space_restriction_rec.org_name);
897: Fnd_Msg_Pub.ADD;
898: END IF;
899: END IF;

Line 896: Fnd_Message.SET_TOKEN('ORGID',p_x_space_restriction_rec.org_name);

892:
893: IF NVL(l_return_status,'x') <> 'S'
894: THEN
895: Fnd_Message.SET_NAME('AHL','AHL_APPR_ORG_NT_EXISTS');
896: Fnd_Message.SET_TOKEN('ORGID',p_x_space_restriction_rec.org_name);
897: Fnd_Msg_Pub.ADD;
898: END IF;
899: END IF;
900: --Assign the returned value

Line 924: Fnd_Message.SET_NAME('AHL','AHL_APPR_DPT_NOT_EXISTS');

920: x_error_msg_code => l_msg_data);
921:
922: IF NVL(l_return_status,'x') <> 'S'
923: THEN
924: Fnd_Message.SET_NAME('AHL','AHL_APPR_DPT_NOT_EXISTS');
925: Fnd_Message.SET_TOKEN('DEPTID',p_x_space_restriction_rec.dept_description);
926: Fnd_Msg_Pub.ADD;
927: END IF;
928: END IF;

Line 925: Fnd_Message.SET_TOKEN('DEPTID',p_x_space_restriction_rec.dept_description);

921:
922: IF NVL(l_return_status,'x') <> 'S'
923: THEN
924: Fnd_Message.SET_NAME('AHL','AHL_APPR_DPT_NOT_EXISTS');
925: Fnd_Message.SET_TOKEN('DEPTID',p_x_space_restriction_rec.dept_description);
926: Fnd_Msg_Pub.ADD;
927: END IF;
928: END IF;
929: --Assign the returned value

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

946: x_error_msg_code => l_msg_data);
947:
948: IF NVL(l_return_status,'x') <> 'S'
949: THEN
950: Fnd_Message.SET_NAME('AHL','AHL_APPR_SPACE_NOT_EXISTS');
951: Fnd_Message.SET_TOKEN('SPACEID',p_x_space_restriction_rec.space_name);
952: Fnd_Msg_Pub.ADD;
953: END IF;
954: END IF;

Line 951: Fnd_Message.SET_TOKEN('SPACEID',p_x_space_restriction_rec.space_name);

947:
948: IF NVL(l_return_status,'x') <> 'S'
949: THEN
950: Fnd_Message.SET_NAME('AHL','AHL_APPR_SPACE_NOT_EXISTS');
951: Fnd_Message.SET_TOKEN('SPACEID',p_x_space_restriction_rec.space_name);
952: Fnd_Msg_Pub.ADD;
953: END IF;
954: END IF;
955: --Assign the returned value

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

1002: -- If the value for the ID already exists, then
1003: -- l_dummy would be populated with '1', otherwise,
1004: -- it receives NULL.
1005: IF l_dummy IS NOT NULL THEN
1006: Fnd_Message.SET_NAME('AHL','AHL_APPR_SEQUENCE_NOT_EXISTS');
1007: Fnd_Msg_Pub.ADD;
1008: END IF;
1009:
1010: -- For optional fields

Line 1139: Fnd_Message.SET_NAME('AHL','AHL_APPR_RECORD_EXISTS');

1135: FETCH check_duplicate_cur INTO l_dup_id;
1136: CLOSE check_duplicate_cur;
1137: IF l_dup_id IS NOT NULL
1138: THEN
1139: Fnd_Message.SET_NAME('AHL','AHL_APPR_RECORD_EXISTS');
1140: Fnd_Msg_Pub.ADD;
1141: END IF;
1142:
1143: --Standard check to count messages

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

1374: x_error_msg_code => l_msg_data);
1375:
1376: IF NVL(l_return_status,'x') <> 'S'
1377: THEN
1378: Fnd_Message.SET_NAME('AHL','AHL_APPR_SPACE_NOT_EXISTS');
1379: Fnd_Message.SET_TOKEN('ORGID',p_space_restriction_rec.space_name);
1380: Fnd_Msg_Pub.ADD;
1381: END IF;
1382: END IF;

Line 1379: Fnd_Message.SET_TOKEN('ORGID',p_space_restriction_rec.space_name);

1375:
1376: IF NVL(l_return_status,'x') <> 'S'
1377: THEN
1378: Fnd_Message.SET_NAME('AHL','AHL_APPR_SPACE_NOT_EXISTS');
1379: Fnd_Message.SET_TOKEN('ORGID',p_space_restriction_rec.space_name);
1380: Fnd_Msg_Pub.ADD;
1381: END IF;
1382: END IF;
1383: -- Get organization , department id

Line 1426: Fnd_Message.SET_NAME('AHL','AHL_APPR_RECORD_EXISTS');

1422: CLOSE get_space_capb_cur;
1423: --
1424: IF (p_space_restriction_rec.start_date <> l_start_date OR
1425: p_space_restriction_rec.end_date <> l_end_date ) THEN
1426: Fnd_Message.SET_NAME('AHL','AHL_APPR_RECORD_EXISTS');
1427: Fnd_Msg_Pub.ADD;
1428: END IF;
1429: END IF;
1430: --Standard check to count messages

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

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

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

1626: CLOSE c_space_restrict_cur;
1627: --Check for object version number
1628: IF l_object_version_number <> p_space_restriction_rec.object_version_number
1629: THEN
1630: FND_MESSAGE.set_name('AHL', 'AHL_COM_RECORD_CHANGED');
1631: FND_MSG_PUB.add;
1632: RAISE FND_API.g_exc_error;
1633: END IF;
1634: -------------------Call Table handler generated procedure------------