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 519: FND_MESSAGE.set_name( 'AHL','AHL_COM_INVALID_DML' );

515: IF (p_x_flight_schedules_tbl(i).DML_OPERATION <> 'D' AND p_x_flight_schedules_tbl(i).DML_OPERATION <> 'd' AND
516: p_x_flight_schedules_tbl(i).DML_OPERATION <> 'U' AND p_x_flight_schedules_tbl(i).DML_OPERATION <> 'u' AND
517: p_x_flight_schedules_tbl(i).DML_OPERATION <> 'C' AND p_x_flight_schedules_tbl(i).DML_OPERATION <> 'c')
518: THEN
519: FND_MESSAGE.set_name( 'AHL','AHL_COM_INVALID_DML' );
520: FND_MESSAGE.set_token( 'RECORD', p_x_flight_schedules_tbl(i).UNIT_SCHEDULE_ID);
521: FND_MESSAGE.set_token( 'FIELD', p_x_flight_schedules_tbl(i).DML_OPERATION);
522: FND_MSG_PUB.add;
523: END IF;

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

516: p_x_flight_schedules_tbl(i).DML_OPERATION <> 'U' AND p_x_flight_schedules_tbl(i).DML_OPERATION <> 'u' AND
517: p_x_flight_schedules_tbl(i).DML_OPERATION <> 'C' AND p_x_flight_schedules_tbl(i).DML_OPERATION <> 'c')
518: THEN
519: FND_MESSAGE.set_name( 'AHL','AHL_COM_INVALID_DML' );
520: FND_MESSAGE.set_token( 'RECORD', p_x_flight_schedules_tbl(i).UNIT_SCHEDULE_ID);
521: FND_MESSAGE.set_token( 'FIELD', p_x_flight_schedules_tbl(i).DML_OPERATION);
522: FND_MSG_PUB.add;
523: END IF;
524:

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

517: p_x_flight_schedules_tbl(i).DML_OPERATION <> 'C' AND p_x_flight_schedules_tbl(i).DML_OPERATION <> 'c')
518: THEN
519: FND_MESSAGE.set_name( 'AHL','AHL_COM_INVALID_DML' );
520: FND_MESSAGE.set_token( 'RECORD', p_x_flight_schedules_tbl(i).UNIT_SCHEDULE_ID);
521: FND_MESSAGE.set_token( 'FIELD', p_x_flight_schedules_tbl(i).DML_OPERATION);
522: FND_MSG_PUB.add;
523: END IF;
524:
525:

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

530: --Unit Schedule id cannot be null
531: IF (p_x_flight_schedules_tbl(i).UNIT_SCHEDULE_ID IS NULL OR
532: p_x_flight_schedules_tbl(i).UNIT_SCHEDULE_ID = FND_API.G_MISS_NUM)
533: THEN
534: FND_MESSAGE.set_name( 'AHL','AHL_UA_US_NOT_FOUND' );
535: FND_MESSAGE.set_token( 'RECORD', p_x_flight_schedules_tbl(i).UNIT_SCHEDULE_ID);
536: FND_MSG_PUB.add;
537: END IF;
538:

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

531: IF (p_x_flight_schedules_tbl(i).UNIT_SCHEDULE_ID IS NULL OR
532: p_x_flight_schedules_tbl(i).UNIT_SCHEDULE_ID = FND_API.G_MISS_NUM)
533: THEN
534: FND_MESSAGE.set_name( 'AHL','AHL_UA_US_NOT_FOUND' );
535: FND_MESSAGE.set_token( 'RECORD', p_x_flight_schedules_tbl(i).UNIT_SCHEDULE_ID);
536: FND_MSG_PUB.add;
537: END IF;
538:
539: -- Check for Object Version number.

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

539: -- Check for Object Version number.
540: IF (p_x_flight_schedules_tbl(i).OBJECT_VERSION_NUMBER IS NULL OR
541: p_x_flight_schedules_tbl(i).OBJECT_VERSION_NUMBER = FND_API.G_MISS_NUM)
542: THEN
543: FND_MESSAGE.set_name( 'AHL','AHL_UA_OBJ_VERNO_NULL' );
544: FND_MESSAGE.set_token( 'RECORD', p_x_flight_schedules_tbl(i).UNIT_SCHEDULE_ID);
545: FND_MSG_PUB.add;
546: END IF;
547: END IF;

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

540: IF (p_x_flight_schedules_tbl(i).OBJECT_VERSION_NUMBER IS NULL OR
541: p_x_flight_schedules_tbl(i).OBJECT_VERSION_NUMBER = FND_API.G_MISS_NUM)
542: THEN
543: FND_MESSAGE.set_name( 'AHL','AHL_UA_OBJ_VERNO_NULL' );
544: FND_MESSAGE.set_token( 'RECORD', p_x_flight_schedules_tbl(i).UNIT_SCHEDULE_ID);
545: FND_MSG_PUB.add;
546: END IF;
547: END IF;
548:

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

557: (p_x_flight_schedules_tbl(i).UNIT_CONFIG_NAME IS NULL OR
558: p_x_flight_schedules_tbl(i).UNIT_CONFIG_NAME = FND_API.G_MISS_CHAR)
559:
560: THEN
561: FND_MESSAGE.set_name( 'AHL','AHL_UA_INV_UC_NAME' );
562: FND_MESSAGE.set_token( 'RECORD', p_x_flight_schedules_tbl(i).UNIT_SCHEDULE_ID);
563: FND_MSG_PUB.add;
564: END IF;
565:

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

558: p_x_flight_schedules_tbl(i).UNIT_CONFIG_NAME = FND_API.G_MISS_CHAR)
559:
560: THEN
561: FND_MESSAGE.set_name( 'AHL','AHL_UA_INV_UC_NAME' );
562: FND_MESSAGE.set_token( 'RECORD', p_x_flight_schedules_tbl(i).UNIT_SCHEDULE_ID);
563: FND_MSG_PUB.add;
564: END IF;
565:
566: --Flight Number is a mandatory input field and cannot be null.

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

566: --Flight Number is a mandatory input field and cannot be null.
567: IF p_x_flight_schedules_tbl(i).FLIGHT_NUMBER IS NULL OR
568: p_x_flight_schedules_tbl(i).FLIGHT_NUMBER = FND_API.G_MISS_CHAR
569: THEN
570: FND_MESSAGE.set_name( 'AHL','AHL_UA_FLG_NUMBER_NULL' );
571: FND_MESSAGE.set_token( 'RECORD', p_x_flight_schedules_tbl(i).UNIT_SCHEDULE_ID);
572: FND_MSG_PUB.add;
573: END IF;
574:

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

567: IF p_x_flight_schedules_tbl(i).FLIGHT_NUMBER IS NULL OR
568: p_x_flight_schedules_tbl(i).FLIGHT_NUMBER = FND_API.G_MISS_CHAR
569: THEN
570: FND_MESSAGE.set_name( 'AHL','AHL_UA_FLG_NUMBER_NULL' );
571: FND_MESSAGE.set_token( 'RECORD', p_x_flight_schedules_tbl(i).UNIT_SCHEDULE_ID);
572: FND_MSG_PUB.add;
573: END IF;
574:
575: --Segment is a mandatory input field and cannot be null

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

575: --Segment is a mandatory input field and cannot be null
576: IF p_x_flight_schedules_tbl(i).SEGMENT IS NULL OR
577: p_x_flight_schedules_tbl(i).SEGMENT = FND_API.G_MISS_CHAR
578: THEN
579: FND_MESSAGE.set_name( 'AHL','AHL_UA_SEGMENT_NULL' );
580: FND_MESSAGE.set_token( 'RECORD', p_x_flight_schedules_tbl(i).UNIT_SCHEDULE_ID);
581: FND_MSG_PUB.add;
582: END IF;
583:

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

576: IF p_x_flight_schedules_tbl(i).SEGMENT IS NULL OR
577: p_x_flight_schedules_tbl(i).SEGMENT = FND_API.G_MISS_CHAR
578: THEN
579: FND_MESSAGE.set_name( 'AHL','AHL_UA_SEGMENT_NULL' );
580: FND_MESSAGE.set_token( 'RECORD', p_x_flight_schedules_tbl(i).UNIT_SCHEDULE_ID);
581: FND_MSG_PUB.add;
582: END IF;
583:
584: --Departure_Dept_Id is a mandatory input field and cannot be null

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

586: p_x_flight_schedules_tbl(i).DEPARTURE_DEPT_ID = FND_API.G_MISS_NUM ) AND
587: ( p_x_flight_schedules_tbl(i).DEPARTURE_DEPT_CODE IS NULL OR
588: p_x_flight_schedules_tbl(i).DEPARTURE_DEPT_CODE = FND_API.G_MISS_CHAR )
589: THEN
590: FND_MESSAGE.set_name( 'AHL','AHL_UA_DEP_DEPT_NULL' );
591: FND_MESSAGE.set_token( 'RECORD', p_x_flight_schedules_tbl(i).UNIT_SCHEDULE_ID);
592: FND_MSG_PUB.add;
593: END IF;
594:

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

587: ( p_x_flight_schedules_tbl(i).DEPARTURE_DEPT_CODE IS NULL OR
588: p_x_flight_schedules_tbl(i).DEPARTURE_DEPT_CODE = FND_API.G_MISS_CHAR )
589: THEN
590: FND_MESSAGE.set_name( 'AHL','AHL_UA_DEP_DEPT_NULL' );
591: FND_MESSAGE.set_token( 'RECORD', p_x_flight_schedules_tbl(i).UNIT_SCHEDULE_ID);
592: FND_MSG_PUB.add;
593: END IF;
594:
595: --Departure_Org_Id is a mandatory input field and cannot be null

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

597: p_x_flight_schedules_tbl(i).DEPARTURE_ORG_ID = FND_API.G_MISS_NUM ) AND
598: ( p_x_flight_schedules_tbl(i).DEPARTURE_ORG_CODE IS NULL OR
599: p_x_flight_schedules_tbl(i).DEPARTURE_ORG_CODE = FND_API.G_MISS_CHAR )
600: THEN
601: FND_MESSAGE.set_name( 'AHL','AHL_UA_DEP_ORG_NULL' );
602: FND_MESSAGE.set_token( 'RECORD', p_x_flight_schedules_tbl(i).UNIT_SCHEDULE_ID);
603: FND_MSG_PUB.add;
604: END IF;
605:

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

598: ( p_x_flight_schedules_tbl(i).DEPARTURE_ORG_CODE IS NULL OR
599: p_x_flight_schedules_tbl(i).DEPARTURE_ORG_CODE = FND_API.G_MISS_CHAR )
600: THEN
601: FND_MESSAGE.set_name( 'AHL','AHL_UA_DEP_ORG_NULL' );
602: FND_MESSAGE.set_token( 'RECORD', p_x_flight_schedules_tbl(i).UNIT_SCHEDULE_ID);
603: FND_MSG_PUB.add;
604: END IF;
605:
606: --Arrival_Dept_Id is a mandatory input field and cannot be null

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

609: ( p_x_flight_schedules_tbl(i).ARRIVAL_DEPT_CODE IS NULL OR
610: p_x_flight_schedules_tbl(i).ARRIVAL_DEPT_CODE = FND_API.G_MISS_CHAR )
611:
612: THEN
613: FND_MESSAGE.set_name( 'AHL','AHL_UA_ARR_DEPT_NULL' );
614: FND_MESSAGE.set_token( 'RECORD', p_x_flight_schedules_tbl(i).UNIT_SCHEDULE_ID);
615: FND_MSG_PUB.add;
616: END IF;
617:

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

610: p_x_flight_schedules_tbl(i).ARRIVAL_DEPT_CODE = FND_API.G_MISS_CHAR )
611:
612: THEN
613: FND_MESSAGE.set_name( 'AHL','AHL_UA_ARR_DEPT_NULL' );
614: FND_MESSAGE.set_token( 'RECORD', p_x_flight_schedules_tbl(i).UNIT_SCHEDULE_ID);
615: FND_MSG_PUB.add;
616: END IF;
617:
618: --Arrival_Org_Id is a mandatory input field and cannot be null

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

620: p_x_flight_schedules_tbl(i).ARRIVAL_ORG_ID = FND_API.G_MISS_NUM ) AND
621: ( p_x_flight_schedules_tbl(i).ARRIVAL_ORG_CODE IS NULL OR
622: p_x_flight_schedules_tbl(i).ARRIVAL_ORG_CODE = FND_API.G_MISS_CHAR )
623: THEN
624: FND_MESSAGE.set_name( 'AHL','AHL_UA_ARR_ORG_NULL' );
625: FND_MESSAGE.set_token( 'RECORD', p_x_flight_schedules_tbl(i).UNIT_SCHEDULE_ID);
626: FND_MSG_PUB.add;
627: END IF;
628:

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

621: ( p_x_flight_schedules_tbl(i).ARRIVAL_ORG_CODE IS NULL OR
622: p_x_flight_schedules_tbl(i).ARRIVAL_ORG_CODE = FND_API.G_MISS_CHAR )
623: THEN
624: FND_MESSAGE.set_name( 'AHL','AHL_UA_ARR_ORG_NULL' );
625: FND_MESSAGE.set_token( 'RECORD', p_x_flight_schedules_tbl(i).UNIT_SCHEDULE_ID);
626: FND_MSG_PUB.add;
627: END IF;
628:
629: --Est_Departure_Time is a mandatory input field and cannot be null

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

629: --Est_Departure_Time is a mandatory input field and cannot be null
630: IF p_x_flight_schedules_tbl(i).EST_DEPARTURE_TIME IS NULL OR
631: p_x_flight_schedules_tbl(i).EST_DEPARTURE_TIME = FND_API.G_MISS_DATE
632: THEN
633: FND_MESSAGE.set_name( 'AHL','AHL_UA_EST_DEP_TIME_NULL' );
634: FND_MESSAGE.set_token( 'RECORD', p_x_flight_schedules_tbl(i).UNIT_SCHEDULE_ID);
635: FND_MSG_PUB.add;
636: END IF;
637:

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

630: IF p_x_flight_schedules_tbl(i).EST_DEPARTURE_TIME IS NULL OR
631: p_x_flight_schedules_tbl(i).EST_DEPARTURE_TIME = FND_API.G_MISS_DATE
632: THEN
633: FND_MESSAGE.set_name( 'AHL','AHL_UA_EST_DEP_TIME_NULL' );
634: FND_MESSAGE.set_token( 'RECORD', p_x_flight_schedules_tbl(i).UNIT_SCHEDULE_ID);
635: FND_MSG_PUB.add;
636: END IF;
637:
638: --Est_Arrival_Time is a mandatory input field and cannot be null

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

638: --Est_Arrival_Time is a mandatory input field and cannot be null
639: IF p_x_flight_schedules_tbl(i).EST_ARRIVAL_TIME IS NULL OR
640: p_x_flight_schedules_tbl(i).EST_ARRIVAL_TIME = FND_API.G_MISS_DATE
641: THEN
642: FND_MESSAGE.set_name( 'AHL','AHL_UA_EST_ARR_TIME_NULL' );
643: FND_MESSAGE.set_token( 'RECORD', p_x_flight_schedules_tbl(i).UNIT_SCHEDULE_ID);
644: FND_MSG_PUB.add;
645: END IF;
646:

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

639: IF p_x_flight_schedules_tbl(i).EST_ARRIVAL_TIME IS NULL OR
640: p_x_flight_schedules_tbl(i).EST_ARRIVAL_TIME = FND_API.G_MISS_DATE
641: THEN
642: FND_MESSAGE.set_name( 'AHL','AHL_UA_EST_ARR_TIME_NULL' );
643: FND_MESSAGE.set_token( 'RECORD', p_x_flight_schedules_tbl(i).UNIT_SCHEDULE_ID);
644: FND_MSG_PUB.add;
645: END IF;
646:
647: --Visit_Reschedule_Mode is a mandatory input field and cannot be null

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

649: p_x_flight_schedules_tbl(i).VISIT_RESCHEDULE_MODE = FND_API.G_MISS_CHAR ) AND
650: ( p_x_flight_schedules_tbl(i).VISIT_RESCHEDULE_MEANING IS NULL OR
651: p_x_flight_schedules_tbl(i).VISIT_RESCHEDULE_MEANING = FND_API.G_MISS_CHAR )
652: THEN
653: FND_MESSAGE.set_name( 'AHL','AHL_UA_VST_RES_MODE_NULL' );
654: FND_MESSAGE.set_token( 'RECORD', p_x_flight_schedules_tbl(i).UNIT_SCHEDULE_ID);
655: FND_MSG_PUB.add;
656: END IF;
657:

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

650: ( p_x_flight_schedules_tbl(i).VISIT_RESCHEDULE_MEANING IS NULL OR
651: p_x_flight_schedules_tbl(i).VISIT_RESCHEDULE_MEANING = FND_API.G_MISS_CHAR )
652: THEN
653: FND_MESSAGE.set_name( 'AHL','AHL_UA_VST_RES_MODE_NULL' );
654: FND_MESSAGE.set_token( 'RECORD', p_x_flight_schedules_tbl(i).UNIT_SCHEDULE_ID);
655: FND_MSG_PUB.add;
656: END IF;
657:
658: END IF;

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

1327: 'Invalid DML Operation flag for '
1328: ||p_flight_visit_sch_tbl(i).unit_schedule_id
1329: );
1330: END IF;
1331: FND_MESSAGE.set_name( 'AHL','AHL_COM_INVALID_DML' );
1332: FND_MESSAGE.set_token( 'RECORD', get_record_identifier(p_flight_visit_sch_tbl(i)));
1333: FND_MESSAGE.set_token( 'FIELD', p_flight_visit_sch_tbl(i).DML_OPERATION);
1334: FND_MSG_PUB.add;
1335: x_return_status := FND_API.G_RET_STS_ERROR;

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

1328: ||p_flight_visit_sch_tbl(i).unit_schedule_id
1329: );
1330: END IF;
1331: FND_MESSAGE.set_name( 'AHL','AHL_COM_INVALID_DML' );
1332: FND_MESSAGE.set_token( 'RECORD', get_record_identifier(p_flight_visit_sch_tbl(i)));
1333: FND_MESSAGE.set_token( 'FIELD', p_flight_visit_sch_tbl(i).DML_OPERATION);
1334: FND_MSG_PUB.add;
1335: x_return_status := FND_API.G_RET_STS_ERROR;
1336: END IF;

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

1329: );
1330: END IF;
1331: FND_MESSAGE.set_name( 'AHL','AHL_COM_INVALID_DML' );
1332: FND_MESSAGE.set_token( 'RECORD', get_record_identifier(p_flight_visit_sch_tbl(i)));
1333: FND_MESSAGE.set_token( 'FIELD', p_flight_visit_sch_tbl(i).DML_OPERATION);
1334: FND_MSG_PUB.add;
1335: x_return_status := FND_API.G_RET_STS_ERROR;
1336: END IF;
1337:

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

1351: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1352: 'Flight Schedule doesnt id cannot be null '
1353: );
1354: END IF;
1355: FND_MESSAGE.set_name( 'AHL','AHL_UA_US_NOT_FOUND' );
1356: FND_MESSAGE.set_token( 'RECORD', get_record_identifier(p_flight_visit_sch_tbl(i)));
1357: FND_MSG_PUB.add;
1358: x_return_status := FND_API.G_RET_STS_ERROR;
1359: END IF;

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

1352: 'Flight Schedule doesnt id cannot be null '
1353: );
1354: END IF;
1355: FND_MESSAGE.set_name( 'AHL','AHL_UA_US_NOT_FOUND' );
1356: FND_MESSAGE.set_token( 'RECORD', get_record_identifier(p_flight_visit_sch_tbl(i)));
1357: FND_MSG_PUB.add;
1358: x_return_status := FND_API.G_RET_STS_ERROR;
1359: END IF;
1360:

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

1370: 'Object version number cannot be null for '
1371: ||p_flight_visit_sch_tbl(i).unit_schedule_id
1372: );
1373: END IF;
1374: FND_MESSAGE.set_name( 'AHL','AHL_UA_OBJ_VERNO_NULL' );
1375: FND_MESSAGE.set_token( 'RECORD', get_record_identifier(p_flight_visit_sch_tbl(i)));
1376: FND_MSG_PUB.add;
1377: x_return_status := FND_API.G_RET_STS_ERROR;
1378: END IF;

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

1371: ||p_flight_visit_sch_tbl(i).unit_schedule_id
1372: );
1373: END IF;
1374: FND_MESSAGE.set_name( 'AHL','AHL_UA_OBJ_VERNO_NULL' );
1375: FND_MESSAGE.set_token( 'RECORD', get_record_identifier(p_flight_visit_sch_tbl(i)));
1376: FND_MSG_PUB.add;
1377: x_return_status := FND_API.G_RET_STS_ERROR;
1378: END IF;
1379: END IF;

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

1398: 'Unit config header id and name, both cannot be null for '
1399: ||p_flight_visit_sch_tbl(i).unit_schedule_id
1400: );
1401: END IF;
1402: FND_MESSAGE.set_name( 'AHL','AHL_UA_INV_UC_NAME' );
1403: FND_MESSAGE.set_token( 'RECORD', get_record_identifier(p_flight_visit_sch_tbl(i)));
1404: FND_MSG_PUB.add;
1405: x_return_status := FND_API.G_RET_STS_ERROR;
1406: END IF;

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

1399: ||p_flight_visit_sch_tbl(i).unit_schedule_id
1400: );
1401: END IF;
1402: FND_MESSAGE.set_name( 'AHL','AHL_UA_INV_UC_NAME' );
1403: FND_MESSAGE.set_token( 'RECORD', get_record_identifier(p_flight_visit_sch_tbl(i)));
1404: FND_MSG_PUB.add;
1405: x_return_status := FND_API.G_RET_STS_ERROR;
1406: END IF;
1407:

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

1417: 'Flight Number cannot be null for '
1418: ||p_flight_visit_sch_tbl(i).unit_schedule_id
1419: );
1420: END IF;
1421: FND_MESSAGE.set_name( 'AHL','AHL_UA_FLG_NUMBER_NULL' );
1422: FND_MESSAGE.set_token( 'RECORD', get_record_identifier(p_flight_visit_sch_tbl(i)));
1423: FND_MSG_PUB.add;
1424: x_return_status := FND_API.G_RET_STS_ERROR;
1425: END IF;

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

1418: ||p_flight_visit_sch_tbl(i).unit_schedule_id
1419: );
1420: END IF;
1421: FND_MESSAGE.set_name( 'AHL','AHL_UA_FLG_NUMBER_NULL' );
1422: FND_MESSAGE.set_token( 'RECORD', get_record_identifier(p_flight_visit_sch_tbl(i)));
1423: FND_MSG_PUB.add;
1424: x_return_status := FND_API.G_RET_STS_ERROR;
1425: END IF;
1426:

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

1436: 'Flight Segment cannot be null for '
1437: ||p_flight_visit_sch_tbl(i).unit_schedule_id
1438: );
1439: END IF;
1440: FND_MESSAGE.set_name( 'AHL','AHL_UA_SEGMENT_NULL' );
1441: FND_MESSAGE.set_token( 'RECORD', get_record_identifier(p_flight_visit_sch_tbl(i)));
1442: FND_MSG_PUB.add;
1443: x_return_status := FND_API.G_RET_STS_ERROR;
1444: END IF;

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

1437: ||p_flight_visit_sch_tbl(i).unit_schedule_id
1438: );
1439: END IF;
1440: FND_MESSAGE.set_name( 'AHL','AHL_UA_SEGMENT_NULL' );
1441: FND_MESSAGE.set_token( 'RECORD', get_record_identifier(p_flight_visit_sch_tbl(i)));
1442: FND_MSG_PUB.add;
1443: x_return_status := FND_API.G_RET_STS_ERROR;
1444: END IF;
1445:

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

1457: 'Departure Department id and code, both cannot be null '
1458: ||p_flight_visit_sch_tbl(i).unit_schedule_id
1459: );
1460: END IF;
1461: FND_MESSAGE.set_name( 'AHL','AHL_UA_DEP_DEPT_NULL' );
1462: FND_MESSAGE.set_token( 'RECORD', get_record_identifier(p_flight_visit_sch_tbl(i)));
1463: FND_MSG_PUB.add;
1464: x_return_status := FND_API.G_RET_STS_ERROR;
1465: END IF;

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

1458: ||p_flight_visit_sch_tbl(i).unit_schedule_id
1459: );
1460: END IF;
1461: FND_MESSAGE.set_name( 'AHL','AHL_UA_DEP_DEPT_NULL' );
1462: FND_MESSAGE.set_token( 'RECORD', get_record_identifier(p_flight_visit_sch_tbl(i)));
1463: FND_MSG_PUB.add;
1464: x_return_status := FND_API.G_RET_STS_ERROR;
1465: END IF;
1466:

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

1478: 'Departure Org id and code, both cannot be null '
1479: ||p_flight_visit_sch_tbl(i).unit_schedule_id
1480: );
1481: END IF;
1482: FND_MESSAGE.set_name( 'AHL','AHL_UA_DEP_ORG_NULL' );
1483: FND_MESSAGE.set_token( 'RECORD', get_record_identifier(p_flight_visit_sch_tbl(i)));
1484: FND_MSG_PUB.add;
1485: x_return_status := FND_API.G_RET_STS_ERROR;
1486: END IF;

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

1479: ||p_flight_visit_sch_tbl(i).unit_schedule_id
1480: );
1481: END IF;
1482: FND_MESSAGE.set_name( 'AHL','AHL_UA_DEP_ORG_NULL' );
1483: FND_MESSAGE.set_token( 'RECORD', get_record_identifier(p_flight_visit_sch_tbl(i)));
1484: FND_MSG_PUB.add;
1485: x_return_status := FND_API.G_RET_STS_ERROR;
1486: END IF;
1487:

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

1500: 'Arrival dept id and code, both cannot be null '
1501: ||p_flight_visit_sch_tbl(i).unit_schedule_id
1502: );
1503: END IF;
1504: FND_MESSAGE.set_name( 'AHL','AHL_UA_ARR_DEPT_NULL' );
1505: FND_MESSAGE.set_token( 'RECORD', get_record_identifier(p_flight_visit_sch_tbl(i)));
1506: FND_MSG_PUB.add;
1507: x_return_status := FND_API.G_RET_STS_ERROR;
1508: END IF;

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

1501: ||p_flight_visit_sch_tbl(i).unit_schedule_id
1502: );
1503: END IF;
1504: FND_MESSAGE.set_name( 'AHL','AHL_UA_ARR_DEPT_NULL' );
1505: FND_MESSAGE.set_token( 'RECORD', get_record_identifier(p_flight_visit_sch_tbl(i)));
1506: FND_MSG_PUB.add;
1507: x_return_status := FND_API.G_RET_STS_ERROR;
1508: END IF;
1509:

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

1521: 'Arrival org id and code, both cannot be null '
1522: ||p_flight_visit_sch_tbl(i).unit_schedule_id
1523: );
1524: END IF;
1525: FND_MESSAGE.set_name( 'AHL','AHL_UA_ARR_ORG_NULL' );
1526: FND_MESSAGE.set_token( 'RECORD', get_record_identifier(p_flight_visit_sch_tbl(i)));
1527: FND_MSG_PUB.add;
1528: x_return_status := FND_API.G_RET_STS_ERROR;
1529: END IF;

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

1522: ||p_flight_visit_sch_tbl(i).unit_schedule_id
1523: );
1524: END IF;
1525: FND_MESSAGE.set_name( 'AHL','AHL_UA_ARR_ORG_NULL' );
1526: FND_MESSAGE.set_token( 'RECORD', get_record_identifier(p_flight_visit_sch_tbl(i)));
1527: FND_MSG_PUB.add;
1528: x_return_status := FND_API.G_RET_STS_ERROR;
1529: END IF;
1530:

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

1540: 'estimated departure time cannot be null '
1541: ||p_flight_visit_sch_tbl(i).unit_schedule_id
1542: );
1543: END IF;
1544: FND_MESSAGE.set_name( 'AHL','AHL_UA_EST_DEP_TIME_NULL' );
1545: FND_MESSAGE.set_token( 'RECORD', get_record_identifier(p_flight_visit_sch_tbl(i)));
1546: FND_MSG_PUB.add;
1547: x_return_status := FND_API.G_RET_STS_ERROR;
1548: END IF;

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

1541: ||p_flight_visit_sch_tbl(i).unit_schedule_id
1542: );
1543: END IF;
1544: FND_MESSAGE.set_name( 'AHL','AHL_UA_EST_DEP_TIME_NULL' );
1545: FND_MESSAGE.set_token( 'RECORD', get_record_identifier(p_flight_visit_sch_tbl(i)));
1546: FND_MSG_PUB.add;
1547: x_return_status := FND_API.G_RET_STS_ERROR;
1548: END IF;
1549:

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

1559: 'Estimated arrival cannot be null '
1560: ||p_flight_visit_sch_tbl(i).unit_schedule_id
1561: );
1562: END IF;
1563: FND_MESSAGE.set_name( 'AHL','AHL_UA_EST_ARR_TIME_NULL' );
1564: FND_MESSAGE.set_token( 'RECORD', get_record_identifier(p_flight_visit_sch_tbl(i)));
1565: FND_MSG_PUB.add;
1566: x_return_status := FND_API.G_RET_STS_ERROR;
1567: END IF;

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

1560: ||p_flight_visit_sch_tbl(i).unit_schedule_id
1561: );
1562: END IF;
1563: FND_MESSAGE.set_name( 'AHL','AHL_UA_EST_ARR_TIME_NULL' );
1564: FND_MESSAGE.set_token( 'RECORD', get_record_identifier(p_flight_visit_sch_tbl(i)));
1565: FND_MSG_PUB.add;
1566: x_return_status := FND_API.G_RET_STS_ERROR;
1567: END IF;
1568:

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

1580: 'Visit Reschedule mode cannot be null for '
1581: ||p_flight_visit_sch_tbl(i).unit_schedule_id
1582: );
1583: END IF;
1584: FND_MESSAGE.set_name( 'AHL','AHL_UA_VST_RES_MODE_NULL' );
1585: FND_MESSAGE.set_token( 'RECORD', get_record_identifier(p_flight_visit_sch_tbl(i)));
1586: FND_MSG_PUB.add;
1587: x_return_status := FND_API.G_RET_STS_ERROR;
1588: END IF;

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

1581: ||p_flight_visit_sch_tbl(i).unit_schedule_id
1582: );
1583: END IF;
1584: FND_MESSAGE.set_name( 'AHL','AHL_UA_VST_RES_MODE_NULL' );
1585: FND_MESSAGE.set_token( 'RECORD', get_record_identifier(p_flight_visit_sch_tbl(i)));
1586: FND_MSG_PUB.add;
1587: x_return_status := FND_API.G_RET_STS_ERROR;
1588: END IF;
1589:

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

1605: 'Visit Type Code cannot be null for '
1606: ||p_flight_visit_sch_tbl(i).unit_schedule_id
1607: );
1608: END IF;
1609: FND_MESSAGE.set_name( 'AHL','AHL_UA_VST_TYPE_NULL' );
1610: FND_MESSAGE.set_token( 'RECORD', get_record_identifier(p_flight_visit_sch_tbl(i)));
1611: FND_MSG_PUB.add;
1612: x_return_status := FND_API.G_RET_STS_ERROR;
1613: END IF;

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

1606: ||p_flight_visit_sch_tbl(i).unit_schedule_id
1607: );
1608: END IF;
1609: FND_MESSAGE.set_name( 'AHL','AHL_UA_VST_TYPE_NULL' );
1610: FND_MESSAGE.set_token( 'RECORD', get_record_identifier(p_flight_visit_sch_tbl(i)));
1611: FND_MSG_PUB.add;
1612: x_return_status := FND_API.G_RET_STS_ERROR;
1613: END IF;
1614:

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

1626: 'Visit create type code cannot be null for '
1627: ||p_flight_visit_sch_tbl(i).unit_schedule_id
1628: );
1629: END IF;
1630: FND_MESSAGE.set_name( 'AHL','AHL_UA_VST_CRE_TYPE_NULL' );
1631: FND_MESSAGE.set_token( 'RECORD', get_record_identifier(p_flight_visit_sch_tbl(i)));
1632: FND_MSG_PUB.add;
1633: x_return_status := FND_API.G_RET_STS_ERROR;
1634: END IF;

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

1627: ||p_flight_visit_sch_tbl(i).unit_schedule_id
1628: );
1629: END IF;
1630: FND_MESSAGE.set_name( 'AHL','AHL_UA_VST_CRE_TYPE_NULL' );
1631: FND_MESSAGE.set_token( 'RECORD', get_record_identifier(p_flight_visit_sch_tbl(i)));
1632: FND_MSG_PUB.add;
1633: x_return_status := FND_API.G_RET_STS_ERROR;
1634: END IF;
1635: END IF;