APPS.AHL_UA_FLIGHT_SCHEDULES_PUB dependencies on FND_MESSAGE

Line 71: FND_MESSAGE.set_name('AHL', 'AHL_UA_SEARCH_DATE_APP_FLAG');

67:
68: -- Validations for dates-based search... If dates criteria applied to arrival / departure, then both start and end need to be passed
69: IF (p_flight_search_rec.DATE_APPLY_TO_FLAG IS NOT NULL AND (p_flight_search_rec.START_DATE IS NULL OR p_flight_search_rec.END_DATE IS NULL))
70: THEN
71: FND_MESSAGE.set_name('AHL', 'AHL_UA_SEARCH_DATE_APP_FLAG');
72: FND_MSG_PUB.add;
73:
74: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
75: END IF;

Line 534: FND_MESSAGE.set_name( 'AHL','AHL_COM_INVALID_DML' );

530: IF (p_x_flight_schedules_tbl(i).DML_OPERATION <> 'D' AND p_x_flight_schedules_tbl(i).DML_OPERATION <> 'd' AND
531: p_x_flight_schedules_tbl(i).DML_OPERATION <> 'U' AND p_x_flight_schedules_tbl(i).DML_OPERATION <> 'u' AND
532: p_x_flight_schedules_tbl(i).DML_OPERATION <> 'C' AND p_x_flight_schedules_tbl(i).DML_OPERATION <> 'c')
533: THEN
534: FND_MESSAGE.set_name( 'AHL','AHL_COM_INVALID_DML' );
535: FND_MESSAGE.set_token( 'RECORD', p_x_flight_schedules_tbl(i).UNIT_SCHEDULE_ID);
536: FND_MESSAGE.set_token( 'FIELD', p_x_flight_schedules_tbl(i).DML_OPERATION);
537: FND_MSG_PUB.add;
538: END IF;

Line 535: FND_MESSAGE.set_token( 'RECORD', p_x_flight_schedules_tbl(i).UNIT_SCHEDULE_ID);

531: p_x_flight_schedules_tbl(i).DML_OPERATION <> 'U' AND p_x_flight_schedules_tbl(i).DML_OPERATION <> 'u' AND
532: p_x_flight_schedules_tbl(i).DML_OPERATION <> 'C' AND p_x_flight_schedules_tbl(i).DML_OPERATION <> 'c')
533: THEN
534: FND_MESSAGE.set_name( 'AHL','AHL_COM_INVALID_DML' );
535: FND_MESSAGE.set_token( 'RECORD', p_x_flight_schedules_tbl(i).UNIT_SCHEDULE_ID);
536: FND_MESSAGE.set_token( 'FIELD', p_x_flight_schedules_tbl(i).DML_OPERATION);
537: FND_MSG_PUB.add;
538: END IF;
539:

Line 536: FND_MESSAGE.set_token( 'FIELD', p_x_flight_schedules_tbl(i).DML_OPERATION);

532: p_x_flight_schedules_tbl(i).DML_OPERATION <> 'C' AND p_x_flight_schedules_tbl(i).DML_OPERATION <> 'c')
533: THEN
534: FND_MESSAGE.set_name( 'AHL','AHL_COM_INVALID_DML' );
535: FND_MESSAGE.set_token( 'RECORD', p_x_flight_schedules_tbl(i).UNIT_SCHEDULE_ID);
536: FND_MESSAGE.set_token( 'FIELD', p_x_flight_schedules_tbl(i).DML_OPERATION);
537: FND_MSG_PUB.add;
538: END IF;
539:
540:

Line 549: FND_MESSAGE.set_name( 'AHL','AHL_UA_US_NOT_FOUND' );

545: --Unit Schedule id cannot be null
546: IF (p_x_flight_schedules_tbl(i).UNIT_SCHEDULE_ID IS NULL OR
547: p_x_flight_schedules_tbl(i).UNIT_SCHEDULE_ID = FND_API.G_MISS_NUM)
548: THEN
549: FND_MESSAGE.set_name( 'AHL','AHL_UA_US_NOT_FOUND' );
550: FND_MESSAGE.set_token( 'RECORD', p_x_flight_schedules_tbl(i).UNIT_SCHEDULE_ID);
551: FND_MSG_PUB.add;
552: END IF;
553:

Line 550: FND_MESSAGE.set_token( 'RECORD', p_x_flight_schedules_tbl(i).UNIT_SCHEDULE_ID);

546: IF (p_x_flight_schedules_tbl(i).UNIT_SCHEDULE_ID IS NULL OR
547: p_x_flight_schedules_tbl(i).UNIT_SCHEDULE_ID = FND_API.G_MISS_NUM)
548: THEN
549: FND_MESSAGE.set_name( 'AHL','AHL_UA_US_NOT_FOUND' );
550: FND_MESSAGE.set_token( 'RECORD', p_x_flight_schedules_tbl(i).UNIT_SCHEDULE_ID);
551: FND_MSG_PUB.add;
552: END IF;
553:
554: -- Check for Object Version number.

Line 558: FND_MESSAGE.set_name( 'AHL','AHL_UA_OBJ_VERNO_NULL' );

554: -- Check for Object Version number.
555: IF (p_x_flight_schedules_tbl(i).OBJECT_VERSION_NUMBER IS NULL OR
556: p_x_flight_schedules_tbl(i).OBJECT_VERSION_NUMBER = FND_API.G_MISS_NUM)
557: THEN
558: FND_MESSAGE.set_name( 'AHL','AHL_UA_OBJ_VERNO_NULL' );
559: FND_MESSAGE.set_token( 'RECORD', p_x_flight_schedules_tbl(i).UNIT_SCHEDULE_ID);
560: FND_MSG_PUB.add;
561: END IF;
562: END IF;

Line 559: FND_MESSAGE.set_token( 'RECORD', p_x_flight_schedules_tbl(i).UNIT_SCHEDULE_ID);

555: IF (p_x_flight_schedules_tbl(i).OBJECT_VERSION_NUMBER IS NULL OR
556: p_x_flight_schedules_tbl(i).OBJECT_VERSION_NUMBER = FND_API.G_MISS_NUM)
557: THEN
558: FND_MESSAGE.set_name( 'AHL','AHL_UA_OBJ_VERNO_NULL' );
559: FND_MESSAGE.set_token( 'RECORD', p_x_flight_schedules_tbl(i).UNIT_SCHEDULE_ID);
560: FND_MSG_PUB.add;
561: END IF;
562: END IF;
563:

Line 576: FND_MESSAGE.set_name( 'AHL','AHL_UA_INV_UC_NAME' );

572: (p_x_flight_schedules_tbl(i).UNIT_CONFIG_NAME IS NULL OR
573: p_x_flight_schedules_tbl(i).UNIT_CONFIG_NAME = FND_API.G_MISS_CHAR)
574:
575: THEN
576: FND_MESSAGE.set_name( 'AHL','AHL_UA_INV_UC_NAME' );
577: FND_MESSAGE.set_token( 'RECORD', p_x_flight_schedules_tbl(i).UNIT_SCHEDULE_ID);
578: FND_MSG_PUB.add;
579: END IF;
580:

Line 577: FND_MESSAGE.set_token( 'RECORD', p_x_flight_schedules_tbl(i).UNIT_SCHEDULE_ID);

573: p_x_flight_schedules_tbl(i).UNIT_CONFIG_NAME = FND_API.G_MISS_CHAR)
574:
575: THEN
576: FND_MESSAGE.set_name( 'AHL','AHL_UA_INV_UC_NAME' );
577: FND_MESSAGE.set_token( 'RECORD', p_x_flight_schedules_tbl(i).UNIT_SCHEDULE_ID);
578: FND_MSG_PUB.add;
579: END IF;
580:
581: --Flight Number is a mandatory input field and cannot be null.

Line 585: FND_MESSAGE.set_name( 'AHL','AHL_UA_FLG_NUMBER_NULL' );

581: --Flight Number is a mandatory input field and cannot be null.
582: IF p_x_flight_schedules_tbl(i).FLIGHT_NUMBER IS NULL OR
583: p_x_flight_schedules_tbl(i).FLIGHT_NUMBER = FND_API.G_MISS_CHAR
584: THEN
585: FND_MESSAGE.set_name( 'AHL','AHL_UA_FLG_NUMBER_NULL' );
586: FND_MESSAGE.set_token( 'RECORD', p_x_flight_schedules_tbl(i).UNIT_SCHEDULE_ID);
587: FND_MSG_PUB.add;
588: END IF;
589:

Line 586: FND_MESSAGE.set_token( 'RECORD', p_x_flight_schedules_tbl(i).UNIT_SCHEDULE_ID);

582: IF p_x_flight_schedules_tbl(i).FLIGHT_NUMBER IS NULL OR
583: p_x_flight_schedules_tbl(i).FLIGHT_NUMBER = FND_API.G_MISS_CHAR
584: THEN
585: FND_MESSAGE.set_name( 'AHL','AHL_UA_FLG_NUMBER_NULL' );
586: FND_MESSAGE.set_token( 'RECORD', p_x_flight_schedules_tbl(i).UNIT_SCHEDULE_ID);
587: FND_MSG_PUB.add;
588: END IF;
589:
590: --Segment is a mandatory input field and cannot be null

Line 594: FND_MESSAGE.set_name( 'AHL','AHL_UA_SEGMENT_NULL' );

590: --Segment is a mandatory input field and cannot be null
591: IF p_x_flight_schedules_tbl(i).SEGMENT IS NULL OR
592: p_x_flight_schedules_tbl(i).SEGMENT = FND_API.G_MISS_CHAR
593: THEN
594: FND_MESSAGE.set_name( 'AHL','AHL_UA_SEGMENT_NULL' );
595: FND_MESSAGE.set_token( 'RECORD', p_x_flight_schedules_tbl(i).UNIT_SCHEDULE_ID);
596: FND_MSG_PUB.add;
597: END IF;
598:

Line 595: FND_MESSAGE.set_token( 'RECORD', p_x_flight_schedules_tbl(i).UNIT_SCHEDULE_ID);

591: IF p_x_flight_schedules_tbl(i).SEGMENT IS NULL OR
592: p_x_flight_schedules_tbl(i).SEGMENT = FND_API.G_MISS_CHAR
593: THEN
594: FND_MESSAGE.set_name( 'AHL','AHL_UA_SEGMENT_NULL' );
595: FND_MESSAGE.set_token( 'RECORD', p_x_flight_schedules_tbl(i).UNIT_SCHEDULE_ID);
596: FND_MSG_PUB.add;
597: END IF;
598:
599: --Departure_Dept_Id is a mandatory input field and cannot be null

Line 605: FND_MESSAGE.set_name( 'AHL','AHL_UA_DEP_DEPT_NULL' );

601: p_x_flight_schedules_tbl(i).DEPARTURE_DEPT_ID = FND_API.G_MISS_NUM ) AND
602: ( p_x_flight_schedules_tbl(i).DEPARTURE_DEPT_CODE IS NULL OR
603: p_x_flight_schedules_tbl(i).DEPARTURE_DEPT_CODE = FND_API.G_MISS_CHAR )
604: THEN
605: FND_MESSAGE.set_name( 'AHL','AHL_UA_DEP_DEPT_NULL' );
606: FND_MESSAGE.set_token( 'RECORD', p_x_flight_schedules_tbl(i).UNIT_SCHEDULE_ID);
607: FND_MSG_PUB.add;
608: END IF;
609:

Line 606: FND_MESSAGE.set_token( 'RECORD', p_x_flight_schedules_tbl(i).UNIT_SCHEDULE_ID);

602: ( p_x_flight_schedules_tbl(i).DEPARTURE_DEPT_CODE IS NULL OR
603: p_x_flight_schedules_tbl(i).DEPARTURE_DEPT_CODE = FND_API.G_MISS_CHAR )
604: THEN
605: FND_MESSAGE.set_name( 'AHL','AHL_UA_DEP_DEPT_NULL' );
606: FND_MESSAGE.set_token( 'RECORD', p_x_flight_schedules_tbl(i).UNIT_SCHEDULE_ID);
607: FND_MSG_PUB.add;
608: END IF;
609:
610: --Departure_Org_Id is a mandatory input field and cannot be null

Line 616: FND_MESSAGE.set_name( 'AHL','AHL_UA_DEP_ORG_NULL' );

612: p_x_flight_schedules_tbl(i).DEPARTURE_ORG_ID = FND_API.G_MISS_NUM ) AND
613: ( p_x_flight_schedules_tbl(i).DEPARTURE_ORG_CODE IS NULL OR
614: p_x_flight_schedules_tbl(i).DEPARTURE_ORG_CODE = FND_API.G_MISS_CHAR )
615: THEN
616: FND_MESSAGE.set_name( 'AHL','AHL_UA_DEP_ORG_NULL' );
617: FND_MESSAGE.set_token( 'RECORD', p_x_flight_schedules_tbl(i).UNIT_SCHEDULE_ID);
618: FND_MSG_PUB.add;
619: END IF;
620:

Line 617: FND_MESSAGE.set_token( 'RECORD', p_x_flight_schedules_tbl(i).UNIT_SCHEDULE_ID);

613: ( p_x_flight_schedules_tbl(i).DEPARTURE_ORG_CODE IS NULL OR
614: p_x_flight_schedules_tbl(i).DEPARTURE_ORG_CODE = FND_API.G_MISS_CHAR )
615: THEN
616: FND_MESSAGE.set_name( 'AHL','AHL_UA_DEP_ORG_NULL' );
617: FND_MESSAGE.set_token( 'RECORD', p_x_flight_schedules_tbl(i).UNIT_SCHEDULE_ID);
618: FND_MSG_PUB.add;
619: END IF;
620:
621: --Arrival_Dept_Id is a mandatory input field and cannot be null

Line 628: FND_MESSAGE.set_name( 'AHL','AHL_UA_ARR_DEPT_NULL' );

624: ( p_x_flight_schedules_tbl(i).ARRIVAL_DEPT_CODE IS NULL OR
625: p_x_flight_schedules_tbl(i).ARRIVAL_DEPT_CODE = FND_API.G_MISS_CHAR )
626:
627: THEN
628: FND_MESSAGE.set_name( 'AHL','AHL_UA_ARR_DEPT_NULL' );
629: FND_MESSAGE.set_token( 'RECORD', p_x_flight_schedules_tbl(i).UNIT_SCHEDULE_ID);
630: FND_MSG_PUB.add;
631: END IF;
632:

Line 629: FND_MESSAGE.set_token( 'RECORD', p_x_flight_schedules_tbl(i).UNIT_SCHEDULE_ID);

625: p_x_flight_schedules_tbl(i).ARRIVAL_DEPT_CODE = FND_API.G_MISS_CHAR )
626:
627: THEN
628: FND_MESSAGE.set_name( 'AHL','AHL_UA_ARR_DEPT_NULL' );
629: FND_MESSAGE.set_token( 'RECORD', p_x_flight_schedules_tbl(i).UNIT_SCHEDULE_ID);
630: FND_MSG_PUB.add;
631: END IF;
632:
633: --Arrival_Org_Id is a mandatory input field and cannot be null

Line 639: FND_MESSAGE.set_name( 'AHL','AHL_UA_ARR_ORG_NULL' );

635: p_x_flight_schedules_tbl(i).ARRIVAL_ORG_ID = FND_API.G_MISS_NUM ) AND
636: ( p_x_flight_schedules_tbl(i).ARRIVAL_ORG_CODE IS NULL OR
637: p_x_flight_schedules_tbl(i).ARRIVAL_ORG_CODE = FND_API.G_MISS_CHAR )
638: THEN
639: FND_MESSAGE.set_name( 'AHL','AHL_UA_ARR_ORG_NULL' );
640: FND_MESSAGE.set_token( 'RECORD', p_x_flight_schedules_tbl(i).UNIT_SCHEDULE_ID);
641: FND_MSG_PUB.add;
642: END IF;
643:

Line 640: FND_MESSAGE.set_token( 'RECORD', p_x_flight_schedules_tbl(i).UNIT_SCHEDULE_ID);

636: ( p_x_flight_schedules_tbl(i).ARRIVAL_ORG_CODE IS NULL OR
637: p_x_flight_schedules_tbl(i).ARRIVAL_ORG_CODE = FND_API.G_MISS_CHAR )
638: THEN
639: FND_MESSAGE.set_name( 'AHL','AHL_UA_ARR_ORG_NULL' );
640: FND_MESSAGE.set_token( 'RECORD', p_x_flight_schedules_tbl(i).UNIT_SCHEDULE_ID);
641: FND_MSG_PUB.add;
642: END IF;
643:
644: --Est_Departure_Time is a mandatory input field and cannot be null

Line 648: FND_MESSAGE.set_name( 'AHL','AHL_UA_EST_DEP_TIME_NULL' );

644: --Est_Departure_Time is a mandatory input field and cannot be null
645: IF p_x_flight_schedules_tbl(i).EST_DEPARTURE_TIME IS NULL OR
646: p_x_flight_schedules_tbl(i).EST_DEPARTURE_TIME = FND_API.G_MISS_DATE
647: THEN
648: FND_MESSAGE.set_name( 'AHL','AHL_UA_EST_DEP_TIME_NULL' );
649: FND_MESSAGE.set_token( 'RECORD', p_x_flight_schedules_tbl(i).UNIT_SCHEDULE_ID);
650: FND_MSG_PUB.add;
651: END IF;
652:

Line 649: FND_MESSAGE.set_token( 'RECORD', p_x_flight_schedules_tbl(i).UNIT_SCHEDULE_ID);

645: IF p_x_flight_schedules_tbl(i).EST_DEPARTURE_TIME IS NULL OR
646: p_x_flight_schedules_tbl(i).EST_DEPARTURE_TIME = FND_API.G_MISS_DATE
647: THEN
648: FND_MESSAGE.set_name( 'AHL','AHL_UA_EST_DEP_TIME_NULL' );
649: FND_MESSAGE.set_token( 'RECORD', p_x_flight_schedules_tbl(i).UNIT_SCHEDULE_ID);
650: FND_MSG_PUB.add;
651: END IF;
652:
653: --Est_Arrival_Time is a mandatory input field and cannot be null

Line 657: FND_MESSAGE.set_name( 'AHL','AHL_UA_EST_ARR_TIME_NULL' );

653: --Est_Arrival_Time is a mandatory input field and cannot be null
654: IF p_x_flight_schedules_tbl(i).EST_ARRIVAL_TIME IS NULL OR
655: p_x_flight_schedules_tbl(i).EST_ARRIVAL_TIME = FND_API.G_MISS_DATE
656: THEN
657: FND_MESSAGE.set_name( 'AHL','AHL_UA_EST_ARR_TIME_NULL' );
658: FND_MESSAGE.set_token( 'RECORD', p_x_flight_schedules_tbl(i).UNIT_SCHEDULE_ID);
659: FND_MSG_PUB.add;
660: END IF;
661:

Line 658: FND_MESSAGE.set_token( 'RECORD', p_x_flight_schedules_tbl(i).UNIT_SCHEDULE_ID);

654: IF p_x_flight_schedules_tbl(i).EST_ARRIVAL_TIME IS NULL OR
655: p_x_flight_schedules_tbl(i).EST_ARRIVAL_TIME = FND_API.G_MISS_DATE
656: THEN
657: FND_MESSAGE.set_name( 'AHL','AHL_UA_EST_ARR_TIME_NULL' );
658: FND_MESSAGE.set_token( 'RECORD', p_x_flight_schedules_tbl(i).UNIT_SCHEDULE_ID);
659: FND_MSG_PUB.add;
660: END IF;
661:
662: --Visit_Reschedule_Mode is a mandatory input field and cannot be null

Line 668: FND_MESSAGE.set_name( 'AHL','AHL_UA_VST_RES_MODE_NULL' );

664: p_x_flight_schedules_tbl(i).VISIT_RESCHEDULE_MODE = FND_API.G_MISS_CHAR ) AND
665: ( p_x_flight_schedules_tbl(i).VISIT_RESCHEDULE_MEANING IS NULL OR
666: p_x_flight_schedules_tbl(i).VISIT_RESCHEDULE_MEANING = FND_API.G_MISS_CHAR )
667: THEN
668: FND_MESSAGE.set_name( 'AHL','AHL_UA_VST_RES_MODE_NULL' );
669: FND_MESSAGE.set_token( 'RECORD', p_x_flight_schedules_tbl(i).UNIT_SCHEDULE_ID);
670: FND_MSG_PUB.add;
671: END IF;
672:

Line 669: FND_MESSAGE.set_token( 'RECORD', p_x_flight_schedules_tbl(i).UNIT_SCHEDULE_ID);

665: ( p_x_flight_schedules_tbl(i).VISIT_RESCHEDULE_MEANING IS NULL OR
666: p_x_flight_schedules_tbl(i).VISIT_RESCHEDULE_MEANING = FND_API.G_MISS_CHAR )
667: THEN
668: FND_MESSAGE.set_name( 'AHL','AHL_UA_VST_RES_MODE_NULL' );
669: FND_MESSAGE.set_token( 'RECORD', p_x_flight_schedules_tbl(i).UNIT_SCHEDULE_ID);
670: FND_MSG_PUB.add;
671: END IF;
672:
673: END IF;

Line 1362: FND_MESSAGE.set_name( 'AHL','AHL_COM_INVALID_DML' );

1358: 'Invalid DML Operation flag for '
1359: ||p_flight_visit_sch_tbl(i).unit_schedule_id
1360: );
1361: END IF;
1362: FND_MESSAGE.set_name( 'AHL','AHL_COM_INVALID_DML' );
1363: FND_MESSAGE.set_token( 'RECORD', get_record_identifier(p_flight_visit_sch_tbl(i)));
1364: FND_MESSAGE.set_token( 'FIELD', p_flight_visit_sch_tbl(i).DML_OPERATION);
1365: FND_MSG_PUB.add;
1366: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1363: FND_MESSAGE.set_token( 'RECORD', get_record_identifier(p_flight_visit_sch_tbl(i)));

1359: ||p_flight_visit_sch_tbl(i).unit_schedule_id
1360: );
1361: END IF;
1362: FND_MESSAGE.set_name( 'AHL','AHL_COM_INVALID_DML' );
1363: FND_MESSAGE.set_token( 'RECORD', get_record_identifier(p_flight_visit_sch_tbl(i)));
1364: FND_MESSAGE.set_token( 'FIELD', p_flight_visit_sch_tbl(i).DML_OPERATION);
1365: FND_MSG_PUB.add;
1366: x_return_status := FND_API.G_RET_STS_ERROR;
1367: END IF;

Line 1364: FND_MESSAGE.set_token( 'FIELD', p_flight_visit_sch_tbl(i).DML_OPERATION);

1360: );
1361: END IF;
1362: FND_MESSAGE.set_name( 'AHL','AHL_COM_INVALID_DML' );
1363: FND_MESSAGE.set_token( 'RECORD', get_record_identifier(p_flight_visit_sch_tbl(i)));
1364: FND_MESSAGE.set_token( 'FIELD', p_flight_visit_sch_tbl(i).DML_OPERATION);
1365: FND_MSG_PUB.add;
1366: x_return_status := FND_API.G_RET_STS_ERROR;
1367: END IF;
1368:

Line 1386: FND_MESSAGE.set_name( 'AHL','AHL_UA_US_NOT_FOUND' );

1382: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1383: 'Flight Schedule doesnt id cannot be null '
1384: );
1385: END IF;
1386: FND_MESSAGE.set_name( 'AHL','AHL_UA_US_NOT_FOUND' );
1387: FND_MESSAGE.set_token( 'RECORD', get_record_identifier(p_flight_visit_sch_tbl(i)));
1388: FND_MSG_PUB.add;
1389: x_return_status := FND_API.G_RET_STS_ERROR;
1390: END IF;

Line 1387: FND_MESSAGE.set_token( 'RECORD', get_record_identifier(p_flight_visit_sch_tbl(i)));

1383: 'Flight Schedule doesnt id cannot be null '
1384: );
1385: END IF;
1386: FND_MESSAGE.set_name( 'AHL','AHL_UA_US_NOT_FOUND' );
1387: FND_MESSAGE.set_token( 'RECORD', get_record_identifier(p_flight_visit_sch_tbl(i)));
1388: FND_MSG_PUB.add;
1389: x_return_status := FND_API.G_RET_STS_ERROR;
1390: END IF;
1391:

Line 1405: FND_MESSAGE.set_name( 'AHL','AHL_UA_OBJ_VERNO_NULL' );

1401: 'Object version number cannot be null for '
1402: ||p_flight_visit_sch_tbl(i).unit_schedule_id
1403: );
1404: END IF;
1405: FND_MESSAGE.set_name( 'AHL','AHL_UA_OBJ_VERNO_NULL' );
1406: FND_MESSAGE.set_token( 'RECORD', get_record_identifier(p_flight_visit_sch_tbl(i)));
1407: FND_MSG_PUB.add;
1408: x_return_status := FND_API.G_RET_STS_ERROR;
1409: END IF;

Line 1406: FND_MESSAGE.set_token( 'RECORD', get_record_identifier(p_flight_visit_sch_tbl(i)));

1402: ||p_flight_visit_sch_tbl(i).unit_schedule_id
1403: );
1404: END IF;
1405: FND_MESSAGE.set_name( 'AHL','AHL_UA_OBJ_VERNO_NULL' );
1406: FND_MESSAGE.set_token( 'RECORD', get_record_identifier(p_flight_visit_sch_tbl(i)));
1407: FND_MSG_PUB.add;
1408: x_return_status := FND_API.G_RET_STS_ERROR;
1409: END IF;
1410: END IF;

Line 1433: FND_MESSAGE.set_name( 'AHL','AHL_UA_INV_UC_NAME' );

1429: 'Unit config header id and name, both cannot be null for '
1430: ||p_flight_visit_sch_tbl(i).unit_schedule_id
1431: );
1432: END IF;
1433: FND_MESSAGE.set_name( 'AHL','AHL_UA_INV_UC_NAME' );
1434: FND_MESSAGE.set_token( 'RECORD', get_record_identifier(p_flight_visit_sch_tbl(i)));
1435: FND_MSG_PUB.add;
1436: x_return_status := FND_API.G_RET_STS_ERROR;
1437: END IF;

Line 1434: FND_MESSAGE.set_token( 'RECORD', get_record_identifier(p_flight_visit_sch_tbl(i)));

1430: ||p_flight_visit_sch_tbl(i).unit_schedule_id
1431: );
1432: END IF;
1433: FND_MESSAGE.set_name( 'AHL','AHL_UA_INV_UC_NAME' );
1434: FND_MESSAGE.set_token( 'RECORD', get_record_identifier(p_flight_visit_sch_tbl(i)));
1435: FND_MSG_PUB.add;
1436: x_return_status := FND_API.G_RET_STS_ERROR;
1437: END IF;
1438:

Line 1452: FND_MESSAGE.set_name( 'AHL','AHL_UA_FLG_NUMBER_NULL' );

1448: 'Flight Number cannot be null for '
1449: ||p_flight_visit_sch_tbl(i).unit_schedule_id
1450: );
1451: END IF;
1452: FND_MESSAGE.set_name( 'AHL','AHL_UA_FLG_NUMBER_NULL' );
1453: FND_MESSAGE.set_token( 'RECORD', get_record_identifier(p_flight_visit_sch_tbl(i)));
1454: FND_MSG_PUB.add;
1455: x_return_status := FND_API.G_RET_STS_ERROR;
1456: END IF;

Line 1453: FND_MESSAGE.set_token( 'RECORD', get_record_identifier(p_flight_visit_sch_tbl(i)));

1449: ||p_flight_visit_sch_tbl(i).unit_schedule_id
1450: );
1451: END IF;
1452: FND_MESSAGE.set_name( 'AHL','AHL_UA_FLG_NUMBER_NULL' );
1453: FND_MESSAGE.set_token( 'RECORD', get_record_identifier(p_flight_visit_sch_tbl(i)));
1454: FND_MSG_PUB.add;
1455: x_return_status := FND_API.G_RET_STS_ERROR;
1456: END IF;
1457:

Line 1471: FND_MESSAGE.set_name( 'AHL','AHL_UA_SEGMENT_NULL' );

1467: 'Flight Segment cannot be null for '
1468: ||p_flight_visit_sch_tbl(i).unit_schedule_id
1469: );
1470: END IF;
1471: FND_MESSAGE.set_name( 'AHL','AHL_UA_SEGMENT_NULL' );
1472: FND_MESSAGE.set_token( 'RECORD', get_record_identifier(p_flight_visit_sch_tbl(i)));
1473: FND_MSG_PUB.add;
1474: x_return_status := FND_API.G_RET_STS_ERROR;
1475: END IF;

Line 1472: FND_MESSAGE.set_token( 'RECORD', get_record_identifier(p_flight_visit_sch_tbl(i)));

1468: ||p_flight_visit_sch_tbl(i).unit_schedule_id
1469: );
1470: END IF;
1471: FND_MESSAGE.set_name( 'AHL','AHL_UA_SEGMENT_NULL' );
1472: FND_MESSAGE.set_token( 'RECORD', get_record_identifier(p_flight_visit_sch_tbl(i)));
1473: FND_MSG_PUB.add;
1474: x_return_status := FND_API.G_RET_STS_ERROR;
1475: END IF;
1476:

Line 1492: FND_MESSAGE.set_name( 'AHL','AHL_UA_DEP_DEPT_NULL' );

1488: 'Departure Department id and code, both cannot be null '
1489: ||p_flight_visit_sch_tbl(i).unit_schedule_id
1490: );
1491: END IF;
1492: FND_MESSAGE.set_name( 'AHL','AHL_UA_DEP_DEPT_NULL' );
1493: FND_MESSAGE.set_token( 'RECORD', get_record_identifier(p_flight_visit_sch_tbl(i)));
1494: FND_MSG_PUB.add;
1495: x_return_status := FND_API.G_RET_STS_ERROR;
1496: END IF;

Line 1493: FND_MESSAGE.set_token( 'RECORD', get_record_identifier(p_flight_visit_sch_tbl(i)));

1489: ||p_flight_visit_sch_tbl(i).unit_schedule_id
1490: );
1491: END IF;
1492: FND_MESSAGE.set_name( 'AHL','AHL_UA_DEP_DEPT_NULL' );
1493: FND_MESSAGE.set_token( 'RECORD', get_record_identifier(p_flight_visit_sch_tbl(i)));
1494: FND_MSG_PUB.add;
1495: x_return_status := FND_API.G_RET_STS_ERROR;
1496: END IF;
1497:

Line 1513: FND_MESSAGE.set_name( 'AHL','AHL_UA_DEP_ORG_NULL' );

1509: 'Departure Org id and code, both cannot be null '
1510: ||p_flight_visit_sch_tbl(i).unit_schedule_id
1511: );
1512: END IF;
1513: FND_MESSAGE.set_name( 'AHL','AHL_UA_DEP_ORG_NULL' );
1514: FND_MESSAGE.set_token( 'RECORD', get_record_identifier(p_flight_visit_sch_tbl(i)));
1515: FND_MSG_PUB.add;
1516: x_return_status := FND_API.G_RET_STS_ERROR;
1517: END IF;

Line 1514: FND_MESSAGE.set_token( 'RECORD', get_record_identifier(p_flight_visit_sch_tbl(i)));

1510: ||p_flight_visit_sch_tbl(i).unit_schedule_id
1511: );
1512: END IF;
1513: FND_MESSAGE.set_name( 'AHL','AHL_UA_DEP_ORG_NULL' );
1514: FND_MESSAGE.set_token( 'RECORD', get_record_identifier(p_flight_visit_sch_tbl(i)));
1515: FND_MSG_PUB.add;
1516: x_return_status := FND_API.G_RET_STS_ERROR;
1517: END IF;
1518:

Line 1535: FND_MESSAGE.set_name( 'AHL','AHL_UA_ARR_DEPT_NULL' );

1531: 'Arrival dept id and code, both cannot be null '
1532: ||p_flight_visit_sch_tbl(i).unit_schedule_id
1533: );
1534: END IF;
1535: FND_MESSAGE.set_name( 'AHL','AHL_UA_ARR_DEPT_NULL' );
1536: FND_MESSAGE.set_token( 'RECORD', get_record_identifier(p_flight_visit_sch_tbl(i)));
1537: FND_MSG_PUB.add;
1538: x_return_status := FND_API.G_RET_STS_ERROR;
1539: END IF;

Line 1536: FND_MESSAGE.set_token( 'RECORD', get_record_identifier(p_flight_visit_sch_tbl(i)));

1532: ||p_flight_visit_sch_tbl(i).unit_schedule_id
1533: );
1534: END IF;
1535: FND_MESSAGE.set_name( 'AHL','AHL_UA_ARR_DEPT_NULL' );
1536: FND_MESSAGE.set_token( 'RECORD', get_record_identifier(p_flight_visit_sch_tbl(i)));
1537: FND_MSG_PUB.add;
1538: x_return_status := FND_API.G_RET_STS_ERROR;
1539: END IF;
1540:

Line 1556: FND_MESSAGE.set_name( 'AHL','AHL_UA_ARR_ORG_NULL' );

1552: 'Arrival org id and code, both cannot be null '
1553: ||p_flight_visit_sch_tbl(i).unit_schedule_id
1554: );
1555: END IF;
1556: FND_MESSAGE.set_name( 'AHL','AHL_UA_ARR_ORG_NULL' );
1557: FND_MESSAGE.set_token( 'RECORD', get_record_identifier(p_flight_visit_sch_tbl(i)));
1558: FND_MSG_PUB.add;
1559: x_return_status := FND_API.G_RET_STS_ERROR;
1560: END IF;

Line 1557: FND_MESSAGE.set_token( 'RECORD', get_record_identifier(p_flight_visit_sch_tbl(i)));

1553: ||p_flight_visit_sch_tbl(i).unit_schedule_id
1554: );
1555: END IF;
1556: FND_MESSAGE.set_name( 'AHL','AHL_UA_ARR_ORG_NULL' );
1557: FND_MESSAGE.set_token( 'RECORD', get_record_identifier(p_flight_visit_sch_tbl(i)));
1558: FND_MSG_PUB.add;
1559: x_return_status := FND_API.G_RET_STS_ERROR;
1560: END IF;
1561:

Line 1575: FND_MESSAGE.set_name( 'AHL','AHL_UA_EST_DEP_TIME_NULL' );

1571: 'estimated departure time cannot be null '
1572: ||p_flight_visit_sch_tbl(i).unit_schedule_id
1573: );
1574: END IF;
1575: FND_MESSAGE.set_name( 'AHL','AHL_UA_EST_DEP_TIME_NULL' );
1576: FND_MESSAGE.set_token( 'RECORD', get_record_identifier(p_flight_visit_sch_tbl(i)));
1577: FND_MSG_PUB.add;
1578: x_return_status := FND_API.G_RET_STS_ERROR;
1579: END IF;

Line 1576: FND_MESSAGE.set_token( 'RECORD', get_record_identifier(p_flight_visit_sch_tbl(i)));

1572: ||p_flight_visit_sch_tbl(i).unit_schedule_id
1573: );
1574: END IF;
1575: FND_MESSAGE.set_name( 'AHL','AHL_UA_EST_DEP_TIME_NULL' );
1576: FND_MESSAGE.set_token( 'RECORD', get_record_identifier(p_flight_visit_sch_tbl(i)));
1577: FND_MSG_PUB.add;
1578: x_return_status := FND_API.G_RET_STS_ERROR;
1579: END IF;
1580:

Line 1594: FND_MESSAGE.set_name( 'AHL','AHL_UA_EST_ARR_TIME_NULL' );

1590: 'Estimated arrival cannot be null '
1591: ||p_flight_visit_sch_tbl(i).unit_schedule_id
1592: );
1593: END IF;
1594: FND_MESSAGE.set_name( 'AHL','AHL_UA_EST_ARR_TIME_NULL' );
1595: FND_MESSAGE.set_token( 'RECORD', get_record_identifier(p_flight_visit_sch_tbl(i)));
1596: FND_MSG_PUB.add;
1597: x_return_status := FND_API.G_RET_STS_ERROR;
1598: END IF;

Line 1595: FND_MESSAGE.set_token( 'RECORD', get_record_identifier(p_flight_visit_sch_tbl(i)));

1591: ||p_flight_visit_sch_tbl(i).unit_schedule_id
1592: );
1593: END IF;
1594: FND_MESSAGE.set_name( 'AHL','AHL_UA_EST_ARR_TIME_NULL' );
1595: FND_MESSAGE.set_token( 'RECORD', get_record_identifier(p_flight_visit_sch_tbl(i)));
1596: FND_MSG_PUB.add;
1597: x_return_status := FND_API.G_RET_STS_ERROR;
1598: END IF;
1599:

Line 1615: FND_MESSAGE.set_name( 'AHL','AHL_UA_VST_RES_MODE_NULL' );

1611: 'Visit Reschedule mode cannot be null for '
1612: ||p_flight_visit_sch_tbl(i).unit_schedule_id
1613: );
1614: END IF;
1615: FND_MESSAGE.set_name( 'AHL','AHL_UA_VST_RES_MODE_NULL' );
1616: FND_MESSAGE.set_token( 'RECORD', get_record_identifier(p_flight_visit_sch_tbl(i)));
1617: FND_MSG_PUB.add;
1618: x_return_status := FND_API.G_RET_STS_ERROR;
1619: END IF;

Line 1616: FND_MESSAGE.set_token( 'RECORD', get_record_identifier(p_flight_visit_sch_tbl(i)));

1612: ||p_flight_visit_sch_tbl(i).unit_schedule_id
1613: );
1614: END IF;
1615: FND_MESSAGE.set_name( 'AHL','AHL_UA_VST_RES_MODE_NULL' );
1616: FND_MESSAGE.set_token( 'RECORD', get_record_identifier(p_flight_visit_sch_tbl(i)));
1617: FND_MSG_PUB.add;
1618: x_return_status := FND_API.G_RET_STS_ERROR;
1619: END IF;
1620:

Line 1640: FND_MESSAGE.set_name( 'AHL','AHL_UA_VST_TYPE_NULL' );

1636: 'Visit Type Code cannot be null for '
1637: ||p_flight_visit_sch_tbl(i).unit_schedule_id
1638: );
1639: END IF;
1640: FND_MESSAGE.set_name( 'AHL','AHL_UA_VST_TYPE_NULL' );
1641: FND_MESSAGE.set_token( 'RECORD', get_record_identifier(p_flight_visit_sch_tbl(i)));
1642: FND_MSG_PUB.add;
1643: x_return_status := FND_API.G_RET_STS_ERROR;
1644: END IF;

Line 1641: FND_MESSAGE.set_token( 'RECORD', get_record_identifier(p_flight_visit_sch_tbl(i)));

1637: ||p_flight_visit_sch_tbl(i).unit_schedule_id
1638: );
1639: END IF;
1640: FND_MESSAGE.set_name( 'AHL','AHL_UA_VST_TYPE_NULL' );
1641: FND_MESSAGE.set_token( 'RECORD', get_record_identifier(p_flight_visit_sch_tbl(i)));
1642: FND_MSG_PUB.add;
1643: x_return_status := FND_API.G_RET_STS_ERROR;
1644: END IF;
1645:

Line 1661: FND_MESSAGE.set_name( 'AHL','AHL_UA_VST_CRE_TYPE_NULL' );

1657: 'Visit create type code cannot be null for '
1658: ||p_flight_visit_sch_tbl(i).unit_schedule_id
1659: );
1660: END IF;
1661: FND_MESSAGE.set_name( 'AHL','AHL_UA_VST_CRE_TYPE_NULL' );
1662: FND_MESSAGE.set_token( 'RECORD', get_record_identifier(p_flight_visit_sch_tbl(i)));
1663: FND_MSG_PUB.add;
1664: x_return_status := FND_API.G_RET_STS_ERROR;
1665: END IF;

Line 1662: FND_MESSAGE.set_token( 'RECORD', get_record_identifier(p_flight_visit_sch_tbl(i)));

1658: ||p_flight_visit_sch_tbl(i).unit_schedule_id
1659: );
1660: END IF;
1661: FND_MESSAGE.set_name( 'AHL','AHL_UA_VST_CRE_TYPE_NULL' );
1662: FND_MESSAGE.set_token( 'RECORD', get_record_identifier(p_flight_visit_sch_tbl(i)));
1663: FND_MSG_PUB.add;
1664: x_return_status := FND_API.G_RET_STS_ERROR;
1665: END IF;
1666: END IF;