147: p_x_flight_schedule_rec.DML_OPERATION <> 'U' AND
148: p_x_flight_schedule_rec.DML_OPERATION <> 'C'
149: )
150: THEN
151: FND_MESSAGE.set_name( 'AHL','AHL_COM_INVALID_DML' );
152: FND_MESSAGE.set_token( 'FIELD', p_x_flight_schedule_rec.DML_OPERATION);
153: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
154: FND_MSG_PUB.add;
155: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
148: p_x_flight_schedule_rec.DML_OPERATION <> 'C'
149: )
150: THEN
151: FND_MESSAGE.set_name( 'AHL','AHL_COM_INVALID_DML' );
152: FND_MESSAGE.set_token( 'FIELD', p_x_flight_schedule_rec.DML_OPERATION);
153: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
154: FND_MSG_PUB.add;
155: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
156: fnd_log.string
149: )
150: THEN
151: FND_MESSAGE.set_name( 'AHL','AHL_COM_INVALID_DML' );
152: FND_MESSAGE.set_token( 'FIELD', p_x_flight_schedule_rec.DML_OPERATION);
153: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
154: FND_MSG_PUB.add;
155: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
156: fnd_log.string
157: (
175: --Unit Schedule id cannot be null
176: IF p_x_flight_schedule_rec.UNIT_SCHEDULE_ID IS NULL OR
177: p_x_flight_schedule_rec.UNIT_SCHEDULE_ID = FND_API.G_MISS_NUM
178: THEN
179: FND_MESSAGE.set_name( 'AHL','AHL_UA_US_NOT_FOUND' );
180: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
181: FND_MSG_PUB.add;
182: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
183: fnd_log.string
176: IF p_x_flight_schedule_rec.UNIT_SCHEDULE_ID IS NULL OR
177: p_x_flight_schedule_rec.UNIT_SCHEDULE_ID = FND_API.G_MISS_NUM
178: THEN
179: FND_MESSAGE.set_name( 'AHL','AHL_UA_US_NOT_FOUND' );
180: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
181: FND_MSG_PUB.add;
182: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
183: fnd_log.string
184: (
195: -- Check for Object Version number.
196: IF ( p_x_flight_schedule_rec.OBJECT_VERSION_NUMBER IS NULL OR
197: p_x_flight_schedule_rec.OBJECT_VERSION_NUMBER = FND_API.G_MISS_NUM )
198: THEN
199: FND_MESSAGE.set_name( 'AHL','AHL_UA_OBJ_VERNO_NULL' );
200: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
201: FND_MSG_PUB.add;
202: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
203: fnd_log.string
196: IF ( p_x_flight_schedule_rec.OBJECT_VERSION_NUMBER IS NULL OR
197: p_x_flight_schedule_rec.OBJECT_VERSION_NUMBER = FND_API.G_MISS_NUM )
198: THEN
199: FND_MESSAGE.set_name( 'AHL','AHL_UA_OBJ_VERNO_NULL' );
200: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
201: FND_MSG_PUB.add;
202: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
203: fnd_log.string
204: (
216: OPEN get_cur_us_csr(p_x_flight_schedule_rec.unit_schedule_id, p_x_flight_schedule_rec.object_version_number);
217: FETCH get_cur_us_csr INTO l_dummy;
218: IF get_cur_us_csr%NOTFOUND
219: THEN
220: FND_MESSAGE.set_name( 'AHL','AHL_UA_REC_CHANGED' );
221: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
222: FND_MSG_PUB.add;
223: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
224: fnd_log.string
217: FETCH get_cur_us_csr INTO l_dummy;
218: IF get_cur_us_csr%NOTFOUND
219: THEN
220: FND_MESSAGE.set_name( 'AHL','AHL_UA_REC_CHANGED' );
221: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
222: FND_MSG_PUB.add;
223: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
224: fnd_log.string
225: (
255: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
256: x_return_status := l_return_status;
257:
258: IF (l_msg_data = 'AHL_COM_INVALID_LOOKUP') THEN
259: FND_MESSAGE.set_name(G_APP_NAME, 'AHL_UA_INVALID_FLIGHT_CAT');
260: ELSIF (l_msg_data = 'AHL_COM_TOO_MANY_LOOKUPS') THEN
261: FND_MESSAGE.set_name(G_APP_NAME, 'AHL_UA_TOO_MANY_FLIGHT_CATS');
262: ELSE
263: FND_MESSAGE.set_name(G_APP_NAME, l_msg_data);
257:
258: IF (l_msg_data = 'AHL_COM_INVALID_LOOKUP') THEN
259: FND_MESSAGE.set_name(G_APP_NAME, 'AHL_UA_INVALID_FLIGHT_CAT');
260: ELSIF (l_msg_data = 'AHL_COM_TOO_MANY_LOOKUPS') THEN
261: FND_MESSAGE.set_name(G_APP_NAME, 'AHL_UA_TOO_MANY_FLIGHT_CATS');
262: ELSE
263: FND_MESSAGE.set_name(G_APP_NAME, l_msg_data);
264: END IF;
265:
259: FND_MESSAGE.set_name(G_APP_NAME, 'AHL_UA_INVALID_FLIGHT_CAT');
260: ELSIF (l_msg_data = 'AHL_COM_TOO_MANY_LOOKUPS') THEN
261: FND_MESSAGE.set_name(G_APP_NAME, 'AHL_UA_TOO_MANY_FLIGHT_CATS');
262: ELSE
263: FND_MESSAGE.set_name(G_APP_NAME, l_msg_data);
264: END IF;
265:
266: IF (p_x_flight_schedule_rec.flight_category_meaning IS NULL OR
267: p_x_flight_schedule_rec.flight_category_meaning = FND_API.G_MISS_CHAR) THEN
264: END IF;
265:
266: IF (p_x_flight_schedule_rec.flight_category_meaning IS NULL OR
267: p_x_flight_schedule_rec.flight_category_meaning = FND_API.G_MISS_CHAR) THEN
268: FND_MESSAGE.set_token('FIELD', p_x_flight_schedule_rec.flight_category_code);
269: ELSE
270: FND_MESSAGE.set_token('FIELD', p_x_flight_schedule_rec.flight_category_meaning);
271: END IF;
272: FND_MSG_PUB.add;
266: IF (p_x_flight_schedule_rec.flight_category_meaning IS NULL OR
267: p_x_flight_schedule_rec.flight_category_meaning = FND_API.G_MISS_CHAR) THEN
268: FND_MESSAGE.set_token('FIELD', p_x_flight_schedule_rec.flight_category_code);
269: ELSE
270: FND_MESSAGE.set_token('FIELD', p_x_flight_schedule_rec.flight_category_meaning);
271: END IF;
272: FND_MSG_PUB.add;
273:
274: IF (l_log_statement >= l_log_current_level) THEN
386:
387: OPEN uc_name_to_id_csr(p_x_flight_schedule_rec.unit_config_name);
388: FETCH uc_name_to_id_csr INTO p_x_flight_schedule_rec.unit_config_header_id;
389: IF uc_name_to_id_csr%NOTFOUND THEN
390: FND_MESSAGE.SET_NAME('AHL','AHL_UA_INV_UC_NAME');
391: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
392: FND_MSG_PUB.ADD;
393: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
394: fnd_log.string
387: OPEN uc_name_to_id_csr(p_x_flight_schedule_rec.unit_config_name);
388: FETCH uc_name_to_id_csr INTO p_x_flight_schedule_rec.unit_config_header_id;
389: IF uc_name_to_id_csr%NOTFOUND THEN
390: FND_MESSAGE.SET_NAME('AHL','AHL_UA_INV_UC_NAME');
391: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
392: FND_MSG_PUB.ADD;
393: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
394: fnd_log.string
395: (
418: THEN
419: OPEN org_name_to_id_csr(p_x_flight_schedule_rec.ARRIVAL_ORG_CODE);
420: FETCH org_name_to_id_csr INTO p_x_flight_schedule_rec.arrival_org_id;
421: IF org_name_to_id_csr%NOTFOUND THEN
422: FND_MESSAGE.SET_NAME('AHL','AHL_UA_INV_ARR_ORG');
423: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
424: FND_MSG_PUB.ADD;
425: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
426: fnd_log.string
419: OPEN org_name_to_id_csr(p_x_flight_schedule_rec.ARRIVAL_ORG_CODE);
420: FETCH org_name_to_id_csr INTO p_x_flight_schedule_rec.arrival_org_id;
421: IF org_name_to_id_csr%NOTFOUND THEN
422: FND_MESSAGE.SET_NAME('AHL','AHL_UA_INV_ARR_ORG');
423: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
424: FND_MSG_PUB.ADD;
425: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
426: fnd_log.string
427: (
455: OPEN dept_name_to_id_csr(p_x_flight_schedule_rec.arrival_dept_code,
456: p_x_flight_schedule_rec.ARRIVAL_ORG_ID);
457: FETCH dept_name_to_id_csr INTO p_x_flight_schedule_rec.arrival_dept_id;
458: IF dept_name_to_id_csr%NOTFOUND THEN
459: FND_MESSAGE.SET_NAME('AHL','AHL_UA_INV_ARR_DEPT');
460: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
461: FND_MSG_PUB.ADD;
462: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
463: fnd_log.string
456: p_x_flight_schedule_rec.ARRIVAL_ORG_ID);
457: FETCH dept_name_to_id_csr INTO p_x_flight_schedule_rec.arrival_dept_id;
458: IF dept_name_to_id_csr%NOTFOUND THEN
459: FND_MESSAGE.SET_NAME('AHL','AHL_UA_INV_ARR_DEPT');
460: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
461: FND_MSG_PUB.ADD;
462: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
463: fnd_log.string
464: (
487: THEN
488: OPEN org_name_to_id_csr(p_x_flight_schedule_rec.departure_org_code);
489: FETCH org_name_to_id_csr INTO p_x_flight_schedule_rec.departure_org_id;
490: IF org_name_to_id_csr%NOTFOUND THEN
491: FND_MESSAGE.SET_NAME('AHL','AHL_UA_INV_DEP_ORG');
492: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
493: FND_MSG_PUB.ADD;
494: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
495: fnd_log.string
488: OPEN org_name_to_id_csr(p_x_flight_schedule_rec.departure_org_code);
489: FETCH org_name_to_id_csr INTO p_x_flight_schedule_rec.departure_org_id;
490: IF org_name_to_id_csr%NOTFOUND THEN
491: FND_MESSAGE.SET_NAME('AHL','AHL_UA_INV_DEP_ORG');
492: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
493: FND_MSG_PUB.ADD;
494: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
495: fnd_log.string
496: (
524: OPEN dept_name_to_id_csr(p_x_flight_schedule_rec.departure_dept_code,
525: p_x_flight_schedule_rec.departure_org_id);
526: FETCH dept_name_to_id_csr INTO p_x_flight_schedule_rec.departure_dept_id;
527: IF dept_name_to_id_csr%NOTFOUND THEN
528: FND_MESSAGE.SET_NAME('AHL','AHL_UA_INV_DEP_DEPT');
529: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
530: FND_MSG_PUB.ADD;
531: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
532: fnd_log.string
525: p_x_flight_schedule_rec.departure_org_id);
526: FETCH dept_name_to_id_csr INTO p_x_flight_schedule_rec.departure_dept_id;
527: IF dept_name_to_id_csr%NOTFOUND THEN
528: FND_MESSAGE.SET_NAME('AHL','AHL_UA_INV_DEP_DEPT');
529: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
530: FND_MSG_PUB.ADD;
531: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
532: fnd_log.string
533: (
563: );
564:
565: -- If any severe error occurs, then, abort API.
566: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
567: FND_MESSAGE.SET_NAME('AHL','AHL_UA_INV_RESCH_MODE');
568: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
569: FND_MSG_PUB.ADD;
570: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
571: fnd_log.string
564:
565: -- If any severe error occurs, then, abort API.
566: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
567: FND_MESSAGE.SET_NAME('AHL','AHL_UA_INV_RESCH_MODE');
568: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
569: FND_MSG_PUB.ADD;
570: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
571: fnd_log.string
572: (
591: FETCH space_name_to_id_csr INTO p_x_flight_schedule_rec.departure_space_id;
592: IF (space_name_to_id_csr%NOTFOUND) THEN
593: x_return_status := FND_API.G_RET_STS_ERROR;
594:
595: FND_MESSAGE.set_name(G_APP_NAME, 'AHL_UA_INV_DEP_SPACE');
596: FND_MESSAGE.set_token('RECORD', l_record_identifier);
597: FND_MSG_PUB.add;
598:
599: IF (l_log_statement >= l_log_current_level) THEN
592: IF (space_name_to_id_csr%NOTFOUND) THEN
593: x_return_status := FND_API.G_RET_STS_ERROR;
594:
595: FND_MESSAGE.set_name(G_APP_NAME, 'AHL_UA_INV_DEP_SPACE');
596: FND_MESSAGE.set_token('RECORD', l_record_identifier);
597: FND_MSG_PUB.add;
598:
599: IF (l_log_statement >= l_log_current_level) THEN
600: FND_LOG.string(l_log_statement, l_full_name,
615: FETCH space_name_to_id_csr INTO p_x_flight_schedule_rec.arrival_space_id;
616: IF (space_name_to_id_csr%NOTFOUND) THEN
617: x_return_status := FND_API.G_RET_STS_ERROR;
618:
619: FND_MESSAGE.set_name(G_APP_NAME, 'AHL_UA_INV_ARR_SPACE');
620: FND_MESSAGE.set_token('RECORD', l_record_identifier);
621: FND_MSG_PUB.add;
622:
623: IF (l_log_statement >= l_log_current_level) THEN
616: IF (space_name_to_id_csr%NOTFOUND) THEN
617: x_return_status := FND_API.G_RET_STS_ERROR;
618:
619: FND_MESSAGE.set_name(G_APP_NAME, 'AHL_UA_INV_ARR_SPACE');
620: FND_MESSAGE.set_token('RECORD', l_record_identifier);
621: FND_MSG_PUB.add;
622:
623: IF (l_log_statement >= l_log_current_level) THEN
624: FND_LOG.string(l_log_statement, l_full_name,
844: p_flight_schedule_rec.unit_config_header_id IS NULL OR
845: p_flight_schedule_rec.unit_config_header_id = FND_API.G_MISS_NUM
846: )
847: THEN
848: FND_MESSAGE.set_name( 'AHL','AHL_UA_INV_UC_NAME' );
849: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
850: FND_MSG_PUB.add;
851: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
852: fnd_log.string
845: p_flight_schedule_rec.unit_config_header_id = FND_API.G_MISS_NUM
846: )
847: THEN
848: FND_MESSAGE.set_name( 'AHL','AHL_UA_INV_UC_NAME' );
849: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
850: FND_MSG_PUB.add;
851: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
852: fnd_log.string
853: (
865: p_flight_schedule_rec.flight_number IS NULL OR
866: p_flight_schedule_rec.flight_number = FND_API.G_MISS_CHAR
867: )
868: THEN
869: FND_MESSAGE.set_name( 'AHL', 'AHL_UA_FLG_NUMBER_NULL' );
870: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
871: FND_MSG_PUB.add;
872: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
873: fnd_log.string
866: p_flight_schedule_rec.flight_number = FND_API.G_MISS_CHAR
867: )
868: THEN
869: FND_MESSAGE.set_name( 'AHL', 'AHL_UA_FLG_NUMBER_NULL' );
870: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
871: FND_MSG_PUB.add;
872: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
873: fnd_log.string
874: (
887: p_flight_schedule_rec.segment IS NULL OR
888: p_flight_schedule_rec.segment = FND_API.G_MISS_CHAR
889: )
890: THEN
891: FND_MESSAGE.set_name( 'AHL', 'AHL_UA_SEGMENT_NULL' );
892: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
893: FND_MSG_PUB.add;
894: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
895: fnd_log.string
888: p_flight_schedule_rec.segment = FND_API.G_MISS_CHAR
889: )
890: THEN
891: FND_MESSAGE.set_name( 'AHL', 'AHL_UA_SEGMENT_NULL' );
892: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
893: FND_MSG_PUB.add;
894: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
895: fnd_log.string
896: (
909: p_flight_schedule_rec.departure_dept_id IS NULL OR
910: p_flight_schedule_rec.departure_dept_id = FND_API.G_MISS_NUM
911: )
912: THEN
913: FND_MESSAGE.set_name( 'AHL','AHL_UA_DEP_DEPT_NULL' );
914: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
915: FND_MSG_PUB.add;
916: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
917: fnd_log.string
910: p_flight_schedule_rec.departure_dept_id = FND_API.G_MISS_NUM
911: )
912: THEN
913: FND_MESSAGE.set_name( 'AHL','AHL_UA_DEP_DEPT_NULL' );
914: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
915: FND_MSG_PUB.add;
916: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
917: fnd_log.string
918: (
930: p_flight_schedule_rec.departure_org_id IS NULL OR
931: p_flight_schedule_rec.departure_org_id = FND_API.G_MISS_NUM
932: )
933: THEN
934: FND_MESSAGE.set_name( 'AHL','AHL_UA_DEP_ORG_NULL' );
935: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
936: FND_MSG_PUB.add;
937: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
938: fnd_log.string
931: p_flight_schedule_rec.departure_org_id = FND_API.G_MISS_NUM
932: )
933: THEN
934: FND_MESSAGE.set_name( 'AHL','AHL_UA_DEP_ORG_NULL' );
935: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
936: FND_MSG_PUB.add;
937: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
938: fnd_log.string
939: (
951: p_flight_schedule_rec.arrival_dept_id IS NULL OR
952: p_flight_schedule_rec.arrival_dept_id = FND_API.G_MISS_NUM
953: )
954: THEN
955: FND_MESSAGE.set_name( 'AHL','AHL_UA_ARR_DEPT_NULL' );
956: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
957: FND_MSG_PUB.add;
958: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
959: fnd_log.string
952: p_flight_schedule_rec.arrival_dept_id = FND_API.G_MISS_NUM
953: )
954: THEN
955: FND_MESSAGE.set_name( 'AHL','AHL_UA_ARR_DEPT_NULL' );
956: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
957: FND_MSG_PUB.add;
958: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
959: fnd_log.string
960: (
972: p_flight_schedule_rec.arrival_org_id IS NULL OR
973: p_flight_schedule_rec.arrival_org_id = FND_API.G_MISS_NUM
974: )
975: THEN
976: FND_MESSAGE.set_name( 'AHL','AHL_UA_ARR_ORG_NULL' );
977: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
978: FND_MSG_PUB.add;
979: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
980: fnd_log.string
973: p_flight_schedule_rec.arrival_org_id = FND_API.G_MISS_NUM
974: )
975: THEN
976: FND_MESSAGE.set_name( 'AHL','AHL_UA_ARR_ORG_NULL' );
977: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
978: FND_MSG_PUB.add;
979: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
980: fnd_log.string
981: (
993: p_flight_schedule_rec.est_departure_time IS NULL OR
994: p_flight_schedule_rec.est_departure_time = FND_API.G_MISS_DATE
995: )
996: THEN
997: FND_MESSAGE.set_name( 'AHL','AHL_UA_EST_DEP_TIME_NULL' );
998: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
999: FND_MSG_PUB.add;
1000: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1001: fnd_log.string
994: p_flight_schedule_rec.est_departure_time = FND_API.G_MISS_DATE
995: )
996: THEN
997: FND_MESSAGE.set_name( 'AHL','AHL_UA_EST_DEP_TIME_NULL' );
998: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
999: FND_MSG_PUB.add;
1000: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1001: fnd_log.string
1002: (
1014: p_flight_schedule_rec.est_arrival_time IS NULL OR
1015: p_flight_schedule_rec.est_arrival_time = FND_API.G_MISS_DATE
1016: )
1017: THEN
1018: FND_MESSAGE.set_name( 'AHL','AHL_UA_EST_ARR_TIME_NULL' );
1019: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
1020: FND_MSG_PUB.add;
1021: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1022: fnd_log.string
1015: p_flight_schedule_rec.est_arrival_time = FND_API.G_MISS_DATE
1016: )
1017: THEN
1018: FND_MESSAGE.set_name( 'AHL','AHL_UA_EST_ARR_TIME_NULL' );
1019: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
1020: FND_MSG_PUB.add;
1021: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1022: fnd_log.string
1023: (
1035: p_flight_schedule_rec.visit_reschedule_mode IS NULL OR
1036: p_flight_schedule_rec.visit_reschedule_mode = FND_API.G_MISS_CHAR
1037: )
1038: THEN
1039: FND_MESSAGE.set_name( 'AHL','AHL_UA_VST_RES_MODE_NULL' );
1040: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
1041: FND_MSG_PUB.add;
1042: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1043: fnd_log.string
1036: p_flight_schedule_rec.visit_reschedule_mode = FND_API.G_MISS_CHAR
1037: )
1038: THEN
1039: FND_MESSAGE.set_name( 'AHL','AHL_UA_VST_RES_MODE_NULL' );
1040: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
1041: FND_MSG_PUB.add;
1042: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1043: fnd_log.string
1044: (
1113: OPEN get_current_us_csr(p_x_flight_schedule_rec.unit_schedule_id);
1114: FETCH get_current_us_csr INTO l_current_us_rec;
1115: IF get_current_us_csr%NOTFOUND
1116: THEN
1117: FND_MESSAGE.set_name( 'AHL', 'AHL_UA_US_NOT_FOUND' );
1118: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
1119: FND_MSG_PUB.add;
1120: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1121: fnd_log.string
1114: FETCH get_current_us_csr INTO l_current_us_rec;
1115: IF get_current_us_csr%NOTFOUND
1116: THEN
1117: FND_MESSAGE.set_name( 'AHL', 'AHL_UA_US_NOT_FOUND' );
1118: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
1119: FND_MSG_PUB.add;
1120: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1121: fnd_log.string
1122: (
1135:
1136: -- Unit cannot be updated irrespective of the whether the user is super user or not
1137: IF p_x_flight_schedule_rec.unit_config_header_id <> l_current_us_rec.unit_config_header_id
1138: THEN
1139: FND_MESSAGE.set_name( 'AHL','AHL_UA_UNIT_NO_UPDATE' );
1140: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
1141: FND_MSG_PUB.add;
1142: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1143: fnd_log.string
1136: -- Unit cannot be updated irrespective of the whether the user is super user or not
1137: IF p_x_flight_schedule_rec.unit_config_header_id <> l_current_us_rec.unit_config_header_id
1138: THEN
1139: FND_MESSAGE.set_name( 'AHL','AHL_UA_UNIT_NO_UPDATE' );
1140: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
1141: FND_MSG_PUB.add;
1142: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1143: fnd_log.string
1144: (
1156: /* --Un comment the code if this is required
1157: -- Flight Number cannot be updated unless user is super user.
1158: IF p_x_flight_schedule_rec.flight_number <> l_current_us_rec.flight_number
1159: THEN
1160: FND_MESSAGE.set_name( 'AHL','AHL_UA_FLIGHT_NO_UPDATE' );
1161: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
1162: FND_MSG_PUB.add;
1163: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1164: fnd_log.string
1157: -- Flight Number cannot be updated unless user is super user.
1158: IF p_x_flight_schedule_rec.flight_number <> l_current_us_rec.flight_number
1159: THEN
1160: FND_MESSAGE.set_name( 'AHL','AHL_UA_FLIGHT_NO_UPDATE' );
1161: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
1162: FND_MSG_PUB.add;
1163: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1164: fnd_log.string
1165: (
1175:
1176: -- Flight Segment cannot be updated unless user is super user.
1177: IF p_x_flight_schedule_rec.segment <> l_current_us_rec.segment
1178: THEN
1179: FND_MESSAGE.set_name( 'AHL','AHL_UA_SEGMENT_NO_UPDATE' );
1180: FND_MESSAGE.set_token( 'RECORD', l_record_identifier);
1181: FND_MSG_PUB.add;
1182: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1183: fnd_log.string
1176: -- Flight Segment cannot be updated unless user is super user.
1177: IF p_x_flight_schedule_rec.segment <> l_current_us_rec.segment
1178: THEN
1179: FND_MESSAGE.set_name( 'AHL','AHL_UA_SEGMENT_NO_UPDATE' );
1180: FND_MESSAGE.set_token( 'RECORD', l_record_identifier);
1181: FND_MSG_PUB.add;
1182: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1183: fnd_log.string
1184: (
1197: -- Departure department cannot be updated unless user is super user.
1198: IF p_x_flight_schedule_rec.departure_dept_id <> l_current_us_rec.departure_dept_id AND
1199: l_update_allowed = FND_API.G_FALSE
1200: THEN
1201: FND_MESSAGE.set_name( 'AHL', 'AHL_UA_DEP_DEPT_NO_UPDATE' );
1202: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
1203: FND_MSG_PUB.add;
1204: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1205: fnd_log.string
1198: IF p_x_flight_schedule_rec.departure_dept_id <> l_current_us_rec.departure_dept_id AND
1199: l_update_allowed = FND_API.G_FALSE
1200: THEN
1201: FND_MESSAGE.set_name( 'AHL', 'AHL_UA_DEP_DEPT_NO_UPDATE' );
1202: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
1203: FND_MSG_PUB.add;
1204: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1205: fnd_log.string
1206: (
1217: -- Departure Organization cannot be updated unless user is super user.
1218: IF p_x_flight_schedule_rec.departure_org_id <> l_current_us_rec.departure_org_id AND
1219: l_update_allowed = FND_API.G_FALSE
1220: THEN
1221: FND_MESSAGE.set_name( 'AHL', 'AHL_UA_DEP_ORG_NO_UPDATE' );
1222: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
1223: FND_MSG_PUB.add;
1224: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1225: fnd_log.string
1218: IF p_x_flight_schedule_rec.departure_org_id <> l_current_us_rec.departure_org_id AND
1219: l_update_allowed = FND_API.G_FALSE
1220: THEN
1221: FND_MESSAGE.set_name( 'AHL', 'AHL_UA_DEP_ORG_NO_UPDATE' );
1222: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
1223: FND_MSG_PUB.add;
1224: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1225: fnd_log.string
1226: (
1237: -- Arrival Department cannot be updated unless user is super user.
1238: IF p_x_flight_schedule_rec.arrival_dept_id <> l_current_us_rec.arrival_dept_id AND
1239: l_update_allowed = FND_API.G_FALSE
1240: THEN
1241: FND_MESSAGE.set_name( 'AHL', 'AHL_UA_ARR_DEP_NO_UPDATE' );
1242: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
1243: FND_MSG_PUB.add;
1244: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1245: fnd_log.string
1238: IF p_x_flight_schedule_rec.arrival_dept_id <> l_current_us_rec.arrival_dept_id AND
1239: l_update_allowed = FND_API.G_FALSE
1240: THEN
1241: FND_MESSAGE.set_name( 'AHL', 'AHL_UA_ARR_DEP_NO_UPDATE' );
1242: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
1243: FND_MSG_PUB.add;
1244: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1245: fnd_log.string
1246: (
1257: -- Arrival Organization cannot be updated unless user is super user.
1258: IF p_x_flight_schedule_rec.arrival_org_id <> l_current_us_rec.arrival_org_id AND
1259: l_update_allowed = FND_API.G_FALSE
1260: THEN
1261: FND_MESSAGE.set_name( 'AHL', 'AHL_UA_ARR_ORG_NO_UPDATE' );
1262: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
1263: FND_MSG_PUB.add;
1264: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1265: fnd_log.string
1258: IF p_x_flight_schedule_rec.arrival_org_id <> l_current_us_rec.arrival_org_id AND
1259: l_update_allowed = FND_API.G_FALSE
1260: THEN
1261: FND_MESSAGE.set_name( 'AHL', 'AHL_UA_ARR_ORG_NO_UPDATE' );
1262: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
1263: FND_MSG_PUB.add;
1264: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1265: fnd_log.string
1266: (
1277: -- Estimated Departure Time cannot be updated unless user is super user.
1278: IF p_x_flight_schedule_rec.est_departure_time <> l_current_us_rec.est_departure_time AND
1279: l_update_allowed = FND_API.G_FALSE
1280: THEN
1281: FND_MESSAGE.set_name( 'AHL', 'AHL_UA_EST_DEP_NO_UPDATE' );
1282: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
1283: FND_MSG_PUB.add;
1284: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1285: fnd_log.string
1278: IF p_x_flight_schedule_rec.est_departure_time <> l_current_us_rec.est_departure_time AND
1279: l_update_allowed = FND_API.G_FALSE
1280: THEN
1281: FND_MESSAGE.set_name( 'AHL', 'AHL_UA_EST_DEP_NO_UPDATE' );
1282: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
1283: FND_MSG_PUB.add;
1284: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1285: fnd_log.string
1286: (
1297: -- Estimated Arrival Time cannot be updated unless user is super user.
1298: IF p_x_flight_schedule_rec.est_arrival_time <> l_current_us_rec.est_arrival_time AND
1299: l_update_allowed = FND_API.G_FALSE
1300: THEN
1301: FND_MESSAGE.set_name( 'AHL', 'AHL_UA_EST_ARR_NO_UPDATE' );
1302: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
1303: FND_MSG_PUB.add;
1304: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1305: fnd_log.string
1298: IF p_x_flight_schedule_rec.est_arrival_time <> l_current_us_rec.est_arrival_time AND
1299: l_update_allowed = FND_API.G_FALSE
1300: THEN
1301: FND_MESSAGE.set_name( 'AHL', 'AHL_UA_EST_ARR_NO_UPDATE' );
1302: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
1303: FND_MSG_PUB.add;
1304: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1305: fnd_log.string
1306: (
1442: AND is_delete_allowed(p_unit_schedule_id => p_x_flight_schedule_rec.unit_schedule_id,
1443: p_is_super_user => is_super_user
1444: ) = FND_API.G_FALSE
1445: THEN
1446: FND_MESSAGE.set_name( 'AHL', 'AHL_UA_ACT_NO_DEL' );
1447: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
1448: FND_MSG_PUB.add;
1449: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1450: fnd_log.string
1443: p_is_super_user => is_super_user
1444: ) = FND_API.G_FALSE
1445: THEN
1446: FND_MESSAGE.set_name( 'AHL', 'AHL_UA_ACT_NO_DEL' );
1447: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
1448: FND_MSG_PUB.add;
1449: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1450: fnd_log.string
1451: (
1470: AND unit_schedule_id <> nvl(p_x_flight_schedule_rec.unit_schedule_id,-100);
1471:
1472: IF l_us_dup_count > 0 THEN
1473: -- Duplicate found, so throw error.
1474: FND_MESSAGE.set_name( 'AHL', 'AHL_UA_DUP_FLG_SCH' );
1475: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
1476: FND_MSG_PUB.add;
1477: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1478: fnd_log.string
1471:
1472: IF l_us_dup_count > 0 THEN
1473: -- Duplicate found, so throw error.
1474: FND_MESSAGE.set_name( 'AHL', 'AHL_UA_DUP_FLG_SCH' );
1475: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
1476: FND_MSG_PUB.add;
1477: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1478: fnd_log.string
1479: (
1497: p_x_flight_schedule_rec.ACTUAL_DEPARTURE_TIME IS NULL OR
1498: p_x_flight_schedule_rec.ACTUAL_DEPARTURE_TIME = FND_API.G_MISS_DATE
1499: )
1500: THEN
1501: FND_MESSAGE.set_name( 'AHL', 'AHL_UA_ARR_WO_DEP' );
1502: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
1503: FND_MSG_PUB.add;
1504: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1505: fnd_log.string
1498: p_x_flight_schedule_rec.ACTUAL_DEPARTURE_TIME = FND_API.G_MISS_DATE
1499: )
1500: THEN
1501: FND_MESSAGE.set_name( 'AHL', 'AHL_UA_ARR_WO_DEP' );
1502: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
1503: FND_MSG_PUB.add;
1504: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1505: fnd_log.string
1506: (
1524: p_x_flight_schedule_rec.ACTUAL_ARRIVAL_TIME <> FND_API.G_MISS_DATE AND
1525: p_x_flight_schedule_rec.ACTUAL_ARRIVAL_TIME > SYSDATE
1526: )
1527: THEN
1528: FND_MESSAGE.set_name( 'AHL', 'AHL_UA_ACT_GT_SYSDATE' );
1529: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
1530: FND_MSG_PUB.add;
1531: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1532: fnd_log.string
1525: p_x_flight_schedule_rec.ACTUAL_ARRIVAL_TIME > SYSDATE
1526: )
1527: THEN
1528: FND_MESSAGE.set_name( 'AHL', 'AHL_UA_ACT_GT_SYSDATE' );
1529: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
1530: FND_MSG_PUB.add;
1531: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1532: fnd_log.string
1533: (
1546: )
1547: AND
1548: p_x_flight_schedule_rec.EST_DEPARTURE_TIME >= p_x_flight_schedule_rec.EST_ARRIVAL_TIME
1549: THEN
1550: FND_MESSAGE.set_name( 'AHL', 'AHL_UA_ARR_LT_DEP' );
1551: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
1552: FND_MSG_PUB.add;
1553: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1554: fnd_log.string
1547: AND
1548: p_x_flight_schedule_rec.EST_DEPARTURE_TIME >= p_x_flight_schedule_rec.EST_ARRIVAL_TIME
1549: THEN
1550: FND_MESSAGE.set_name( 'AHL', 'AHL_UA_ARR_LT_DEP' );
1551: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
1552: FND_MSG_PUB.add;
1553: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1554: fnd_log.string
1555: (
1569: )
1570: AND
1571: p_x_flight_schedule_rec.ACTUAL_DEPARTURE_TIME >= p_x_flight_schedule_rec.ACTUAL_ARRIVAL_TIME
1572: THEN
1573: FND_MESSAGE.set_name( 'AHL', 'AHL_UA_ARR_LT_DEP' );
1574: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
1575: FND_MSG_PUB.add;
1576: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1577: fnd_log.string
1570: AND
1571: p_x_flight_schedule_rec.ACTUAL_DEPARTURE_TIME >= p_x_flight_schedule_rec.ACTUAL_ARRIVAL_TIME
1572: THEN
1573: FND_MESSAGE.set_name( 'AHL', 'AHL_UA_ARR_LT_DEP' );
1574: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
1575: FND_MSG_PUB.add;
1576: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1577: fnd_log.string
1578: (
1624: IF l_preceeding_us_rec.unit_schedule_id IS NOT NULL AND
1625: (l_preceeding_us_rec.actual_departure_time IS NULL OR
1626: l_preceeding_us_rec.actual_arrival_time IS NULL )
1627: THEN
1628: FND_MESSAGE.set_name( 'AHL', 'AHL_UA_PRE_ACT_NOT_REC' );
1629: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
1630: FND_MSG_PUB.add;
1631: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1632: fnd_log.string
1625: (l_preceeding_us_rec.actual_departure_time IS NULL OR
1626: l_preceeding_us_rec.actual_arrival_time IS NULL )
1627: THEN
1628: FND_MESSAGE.set_name( 'AHL', 'AHL_UA_PRE_ACT_NOT_REC' );
1629: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
1630: FND_MSG_PUB.add;
1631: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1632: fnd_log.string
1633: (
1651: )
1652: AND unit_schedule_id <> nvl(p_x_flight_schedule_rec.unit_schedule_id,-110);
1653:
1654: IF l_est_violation_count > 0 THEN
1655: FND_MESSAGE.set_name( 'AHL', 'AHL_UA_EST_ARR_VIO' );
1656: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
1657: FND_MSG_PUB.add;
1658: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1659: fnd_log.string
1652: AND unit_schedule_id <> nvl(p_x_flight_schedule_rec.unit_schedule_id,-110);
1653:
1654: IF l_est_violation_count > 0 THEN
1655: FND_MESSAGE.set_name( 'AHL', 'AHL_UA_EST_ARR_VIO' );
1656: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
1657: FND_MSG_PUB.add;
1658: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1659: fnd_log.string
1660: (
1678: FETCH validate_space_id_csr INTO l_dummy;
1679: IF (validate_space_id_csr%NOTFOUND) THEN
1680: x_return_status := FND_API.G_RET_STS_ERROR;
1681:
1682: FND_MESSAGE.set_name(G_APP_NAME, 'AHL_UA_INV_DEP_SPACE');
1683: FND_MESSAGE.set_token('RECORD', l_record_identifier);
1684: FND_MSG_PUB.ADD;
1685:
1686: IF (l_log_statement >= l_log_current_level) THEN
1679: IF (validate_space_id_csr%NOTFOUND) THEN
1680: x_return_status := FND_API.G_RET_STS_ERROR;
1681:
1682: FND_MESSAGE.set_name(G_APP_NAME, 'AHL_UA_INV_DEP_SPACE');
1683: FND_MESSAGE.set_token('RECORD', l_record_identifier);
1684: FND_MSG_PUB.ADD;
1685:
1686: IF (l_log_statement >= l_log_current_level) THEN
1687: FND_LOG.string(l_log_statement, l_full_name,
1702: FETCH validate_space_id_csr INTO l_dummy;
1703: IF (validate_space_id_csr%NOTFOUND) THEN
1704: x_return_status := FND_API.G_RET_STS_ERROR;
1705:
1706: FND_MESSAGE.set_name(G_APP_NAME, 'AHL_UA_INV_ARR_SPACE');
1707: FND_MESSAGE.set_token('RECORD', l_record_identifier);
1708: FND_MSG_PUB.ADD;
1709:
1710: IF (l_log_statement >= l_log_current_level) THEN
1703: IF (validate_space_id_csr%NOTFOUND) THEN
1704: x_return_status := FND_API.G_RET_STS_ERROR;
1705:
1706: FND_MESSAGE.set_name(G_APP_NAME, 'AHL_UA_INV_ARR_SPACE');
1707: FND_MESSAGE.set_token('RECORD', l_record_identifier);
1708: FND_MSG_PUB.ADD;
1709:
1710: IF (l_log_statement >= l_log_current_level) THEN
1711: FND_LOG.string(l_log_statement, l_full_name,
2536: END IF;
2537:
2538: IF l_overlap_us_count > 0 THEN
2539: -- There is an overlap in times.
2540: FND_MESSAGE.set_name('AHL', 'AHL_UA_US_TIME_OVERLAP');
2541: FND_MESSAGE.set_token( 'RECORD', get_record_identifier(
2542: p_flight_schedule_rec => p_x_flight_schedules_tbl(i)
2543: ) );
2544:
2537:
2538: IF l_overlap_us_count > 0 THEN
2539: -- There is an overlap in times.
2540: FND_MESSAGE.set_name('AHL', 'AHL_UA_US_TIME_OVERLAP');
2541: FND_MESSAGE.set_token( 'RECORD', get_record_identifier(
2542: p_flight_schedule_rec => p_x_flight_schedules_tbl(i)
2543: ) );
2544:
2545: p_x_flight_schedules_tbl(i).conflict_message := FND_MESSAGE.GET;
2541: FND_MESSAGE.set_token( 'RECORD', get_record_identifier(
2542: p_flight_schedule_rec => p_x_flight_schedules_tbl(i)
2543: ) );
2544:
2545: p_x_flight_schedules_tbl(i).conflict_message := FND_MESSAGE.GET;
2546: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
2547: fnd_log.string
2548: (
2549: fnd_log.level_error,
2909: AND object_version_number= p_x_flight_schedules_tbl(i).object_version_number;
2910:
2911: -- If the record does not exist, then, abort API.
2912: IF ( SQL%ROWCOUNT = 0 ) THEN
2913: FND_MESSAGE.set_name('AHL','AHL_COM_RECORD_CHANGED');
2914: FND_MESSAGE.set_token( 'RECORD', get_record_identifier(
2915: p_flight_schedule_rec => p_x_flight_schedules_tbl(i)
2916: ) );
2917: FND_MSG_PUB.add;
2910:
2911: -- If the record does not exist, then, abort API.
2912: IF ( SQL%ROWCOUNT = 0 ) THEN
2913: FND_MESSAGE.set_name('AHL','AHL_COM_RECORD_CHANGED');
2914: FND_MESSAGE.set_token( 'RECORD', get_record_identifier(
2915: p_flight_schedule_rec => p_x_flight_schedules_tbl(i)
2916: ) );
2917: FND_MSG_PUB.add;
2918: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
3049: END IF;
3050:
3051: IF l_overlap_us_count > 0 THEN
3052: -- There is an overlap in times.
3053: FND_MESSAGE.set_name('AHL', 'AHL_UA_US_TIME_OVERLAP');
3054: FND_MESSAGE.set_token( 'RECORD', get_record_identifier(
3055: p_flight_schedule_rec => p_x_flight_schedules_tbl(i)
3056: ) );
3057:
3050:
3051: IF l_overlap_us_count > 0 THEN
3052: -- There is an overlap in times.
3053: FND_MESSAGE.set_name('AHL', 'AHL_UA_US_TIME_OVERLAP');
3054: FND_MESSAGE.set_token( 'RECORD', get_record_identifier(
3055: p_flight_schedule_rec => p_x_flight_schedules_tbl(i)
3056: ) );
3057:
3058: p_x_flight_schedules_tbl(i).conflict_message := FND_MESSAGE.GET;
3054: FND_MESSAGE.set_token( 'RECORD', get_record_identifier(
3055: p_flight_schedule_rec => p_x_flight_schedules_tbl(i)
3056: ) );
3057:
3058: p_x_flight_schedules_tbl(i).conflict_message := FND_MESSAGE.GET;
3059: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
3060: fnd_log.string
3061: (
3062: fnd_log.level_error,
3294: AND object_version_number= p_x_flight_schedules_tbl(i).object_version_number;
3295:
3296: -- If the record does not exist, then, abort API.
3297: IF ( SQL%ROWCOUNT = 0 ) THEN
3298: FND_MESSAGE.set_name('AHL','AHL_COM_RECORD_CHANGED');
3299: FND_MESSAGE.set_token( 'RECORD', get_record_identifier(
3300: p_flight_schedule_rec => p_x_flight_schedules_tbl(i)
3301: ) );
3302: FND_MSG_PUB.add;
3295:
3296: -- If the record does not exist, then, abort API.
3297: IF ( SQL%ROWCOUNT = 0 ) THEN
3298: FND_MESSAGE.set_name('AHL','AHL_COM_RECORD_CHANGED');
3299: FND_MESSAGE.set_token( 'RECORD', get_record_identifier(
3300: p_flight_schedule_rec => p_x_flight_schedules_tbl(i)
3301: ) );
3302: FND_MSG_PUB.add;
3303: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
3529:
3530: -- Throw error if p_unit_schedule_id is null
3531:
3532: IF p_unit_schedule_id IS NULL THEN
3533: FND_MESSAGE.set_name('AHL','AHL_UA_US_NOT_FOUND');
3534: FND_MSG_PUB.add;
3535: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
3536: fnd_log.string
3537: (
3545: ELSE
3546: OPEN check_flight_exists_csr(p_unit_schedule_id, p_unit_config_id);
3547: FETCH check_flight_exists_csr INTO l_dummy;
3548: IF check_flight_exists_csr%NOTFOUND THEN
3549: FND_MESSAGE.set_name('AHL','AHL_UA_US_NOT_FOUND');
3550: FND_MSG_PUB.add;
3551: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
3552: fnd_log.string
3553: (