DBA Data[Home] [Help]

APPS.AHL_UA_FLIGHT_SCHEDULES_PVT dependencies on FND_MESSAGE

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

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

Line 152: FND_MESSAGE.set_token( 'FIELD', p_x_flight_schedule_rec.DML_OPERATION);

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

Line 153: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );

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: (

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

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

Line 180: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );

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: (

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

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

Line 200: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );

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: (

Line 220: FND_MESSAGE.set_name( 'AHL','AHL_UA_REC_CHANGED' );

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

Line 221: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );

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: (

Line 259: FND_MESSAGE.set_name(G_APP_NAME, 'AHL_UA_INVALID_FLIGHT_CAT');

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);

Line 261: FND_MESSAGE.set_name(G_APP_NAME, 'AHL_UA_TOO_MANY_FLIGHT_CATS');

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:

Line 263: FND_MESSAGE.set_name(G_APP_NAME, l_msg_data);

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

Line 268: FND_MESSAGE.set_token('FIELD', p_x_flight_schedule_rec.flight_category_code);

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;

Line 270: FND_MESSAGE.set_token('FIELD', p_x_flight_schedule_rec.flight_category_meaning);

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

Line 390: FND_MESSAGE.SET_NAME('AHL','AHL_UA_INV_UC_NAME');

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

Line 391: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );

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: (

Line 422: FND_MESSAGE.SET_NAME('AHL','AHL_UA_INV_ARR_ORG');

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

Line 423: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );

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: (

Line 459: FND_MESSAGE.SET_NAME('AHL','AHL_UA_INV_ARR_DEPT');

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

Line 460: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );

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: (

Line 491: FND_MESSAGE.SET_NAME('AHL','AHL_UA_INV_DEP_ORG');

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

Line 492: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );

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: (

Line 528: FND_MESSAGE.SET_NAME('AHL','AHL_UA_INV_DEP_DEPT');

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

Line 529: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );

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: (

Line 567: FND_MESSAGE.SET_NAME('AHL','AHL_UA_INV_RESCH_MODE');

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

Line 568: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );

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: (

Line 595: FND_MESSAGE.set_name(G_APP_NAME, 'AHL_UA_INV_DEP_SPACE');

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

Line 596: FND_MESSAGE.set_token('RECORD', l_record_identifier);

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,

Line 619: FND_MESSAGE.set_name(G_APP_NAME, 'AHL_UA_INV_ARR_SPACE');

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

Line 620: FND_MESSAGE.set_token('RECORD', l_record_identifier);

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,

Line 848: FND_MESSAGE.set_name( 'AHL','AHL_UA_INV_UC_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

Line 849: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );

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: (

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

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

Line 870: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );

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: (

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

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

Line 892: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );

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: (

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

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

Line 914: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );

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: (

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

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

Line 935: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );

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: (

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

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

Line 956: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );

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: (

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

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

Line 977: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );

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: (

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

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

Line 998: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );

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: (

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

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

Line 1019: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );

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: (

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

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

Line 1040: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );

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: (

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

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

Line 1118: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );

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: (

Line 1139: FND_MESSAGE.set_name( 'AHL','AHL_UA_UNIT_NO_UPDATE' );

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

Line 1140: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );

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: (

Line 1160: FND_MESSAGE.set_name( 'AHL','AHL_UA_FLIGHT_NO_UPDATE' );

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

Line 1161: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );

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: (

Line 1179: FND_MESSAGE.set_name( 'AHL','AHL_UA_SEGMENT_NO_UPDATE' );

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

Line 1180: FND_MESSAGE.set_token( 'RECORD', l_record_identifier);

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: (

Line 1201: FND_MESSAGE.set_name( 'AHL', 'AHL_UA_DEP_DEPT_NO_UPDATE' );

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

Line 1202: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );

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: (

Line 1221: FND_MESSAGE.set_name( 'AHL', 'AHL_UA_DEP_ORG_NO_UPDATE' );

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

Line 1222: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );

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: (

Line 1241: FND_MESSAGE.set_name( 'AHL', 'AHL_UA_ARR_DEP_NO_UPDATE' );

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

Line 1242: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );

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: (

Line 1261: FND_MESSAGE.set_name( 'AHL', 'AHL_UA_ARR_ORG_NO_UPDATE' );

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

Line 1262: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );

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: (

Line 1281: FND_MESSAGE.set_name( 'AHL', 'AHL_UA_EST_DEP_NO_UPDATE' );

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

Line 1282: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );

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: (

Line 1301: FND_MESSAGE.set_name( 'AHL', 'AHL_UA_EST_ARR_NO_UPDATE' );

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

Line 1302: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );

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: (

Line 1446: FND_MESSAGE.set_name( 'AHL', 'AHL_UA_ACT_NO_DEL' );

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

Line 1447: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );

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: (

Line 1474: FND_MESSAGE.set_name( 'AHL', 'AHL_UA_DUP_FLG_SCH' );

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

Line 1475: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );

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: (

Line 1501: FND_MESSAGE.set_name( 'AHL', 'AHL_UA_ARR_WO_DEP' );

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

Line 1502: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );

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: (

Line 1528: FND_MESSAGE.set_name( 'AHL', 'AHL_UA_ACT_GT_SYSDATE' );

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

Line 1529: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );

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: (

Line 1550: FND_MESSAGE.set_name( 'AHL', 'AHL_UA_ARR_LT_DEP' );

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

Line 1551: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );

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: (

Line 1573: FND_MESSAGE.set_name( 'AHL', 'AHL_UA_ARR_LT_DEP' );

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

Line 1574: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );

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: (

Line 1628: FND_MESSAGE.set_name( 'AHL', 'AHL_UA_PRE_ACT_NOT_REC' );

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

Line 1629: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );

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: (

Line 1655: FND_MESSAGE.set_name( 'AHL', 'AHL_UA_EST_ARR_VIO' );

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

Line 1656: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );

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: (

Line 1682: FND_MESSAGE.set_name(G_APP_NAME, 'AHL_UA_INV_DEP_SPACE');

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

Line 1683: FND_MESSAGE.set_token('RECORD', l_record_identifier);

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,

Line 1706: FND_MESSAGE.set_name(G_APP_NAME, 'AHL_UA_INV_ARR_SPACE');

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

Line 1707: FND_MESSAGE.set_token('RECORD', l_record_identifier);

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,

Line 2540: FND_MESSAGE.set_name('AHL', 'AHL_UA_US_TIME_OVERLAP');

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:

Line 2541: FND_MESSAGE.set_token( 'RECORD', get_record_identifier(

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;

Line 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,

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

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;

Line 2914: FND_MESSAGE.set_token( 'RECORD', get_record_identifier(

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

Line 3053: FND_MESSAGE.set_name('AHL', 'AHL_UA_US_TIME_OVERLAP');

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:

Line 3054: FND_MESSAGE.set_token( 'RECORD', get_record_identifier(

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;

Line 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,

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

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;

Line 3299: FND_MESSAGE.set_token( 'RECORD', get_record_identifier(

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

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

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: (

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

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: (