eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AHL_UA_FLIGHT_SCHEDULES_PVT dependencies on FND_MESSAGE

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

129: p_flight_schedule_rec.DML_OPERATION <> 'U' AND
130: p_flight_schedule_rec.DML_OPERATION <> 'C'
131: )
132: THEN
133: FND_MESSAGE.set_name( 'AHL','AHL_COM_INVALID_DML' );
134: FND_MESSAGE.set_token( 'FIELD', p_flight_schedule_rec.DML_OPERATION);
135: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
136: FND_MSG_PUB.add;
137: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN

Line 134: FND_MESSAGE.set_token( 'FIELD', p_flight_schedule_rec.DML_OPERATION);

130: p_flight_schedule_rec.DML_OPERATION <> 'C'
131: )
132: THEN
133: FND_MESSAGE.set_name( 'AHL','AHL_COM_INVALID_DML' );
134: FND_MESSAGE.set_token( 'FIELD', p_flight_schedule_rec.DML_OPERATION);
135: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
136: FND_MSG_PUB.add;
137: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
138: fnd_log.string

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

131: )
132: THEN
133: FND_MESSAGE.set_name( 'AHL','AHL_COM_INVALID_DML' );
134: FND_MESSAGE.set_token( 'FIELD', p_flight_schedule_rec.DML_OPERATION);
135: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
136: FND_MSG_PUB.add;
137: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
138: fnd_log.string
139: (

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

157: --Unit Schedule id cannot be null
158: IF p_flight_schedule_rec.UNIT_SCHEDULE_ID IS NULL OR
159: p_flight_schedule_rec.UNIT_SCHEDULE_ID = FND_API.G_MISS_NUM
160: THEN
161: FND_MESSAGE.set_name( 'AHL','AHL_UA_US_NOT_FOUND' );
162: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
163: FND_MSG_PUB.add;
164: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
165: fnd_log.string

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

158: IF p_flight_schedule_rec.UNIT_SCHEDULE_ID IS NULL OR
159: p_flight_schedule_rec.UNIT_SCHEDULE_ID = FND_API.G_MISS_NUM
160: THEN
161: FND_MESSAGE.set_name( 'AHL','AHL_UA_US_NOT_FOUND' );
162: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
163: FND_MSG_PUB.add;
164: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
165: fnd_log.string
166: (

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

177: -- Check for Object Version number.
178: IF ( p_flight_schedule_rec.OBJECT_VERSION_NUMBER IS NULL OR
179: p_flight_schedule_rec.OBJECT_VERSION_NUMBER = FND_API.G_MISS_NUM )
180: THEN
181: FND_MESSAGE.set_name( 'AHL','AHL_UA_OBJ_VERNO_NULL' );
182: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
183: FND_MSG_PUB.add;
184: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
185: fnd_log.string

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

178: IF ( p_flight_schedule_rec.OBJECT_VERSION_NUMBER IS NULL OR
179: p_flight_schedule_rec.OBJECT_VERSION_NUMBER = FND_API.G_MISS_NUM )
180: THEN
181: FND_MESSAGE.set_name( 'AHL','AHL_UA_OBJ_VERNO_NULL' );
182: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
183: FND_MSG_PUB.add;
184: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
185: fnd_log.string
186: (

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

198: OPEN get_cur_us_csr(p_flight_schedule_rec.unit_schedule_id, p_flight_schedule_rec.object_version_number);
199: FETCH get_cur_us_csr INTO l_dummy;
200: IF get_cur_us_csr%NOTFOUND
201: THEN
202: FND_MESSAGE.set_name( 'AHL','AHL_UA_REC_CHANGED' );
203: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
204: FND_MSG_PUB.add;
205: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
206: fnd_log.string

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

199: FETCH get_cur_us_csr INTO l_dummy;
200: IF get_cur_us_csr%NOTFOUND
201: THEN
202: FND_MESSAGE.set_name( 'AHL','AHL_UA_REC_CHANGED' );
203: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
204: FND_MSG_PUB.add;
205: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
206: fnd_log.string
207: (

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

304:
305: OPEN uc_name_to_id_csr(p_x_flight_schedule_rec.unit_config_name);
306: FETCH uc_name_to_id_csr INTO p_x_flight_schedule_rec.unit_config_header_id;
307: IF uc_name_to_id_csr%NOTFOUND THEN
308: FND_MESSAGE.SET_NAME('AHL','AHL_UA_INV_UC_NAME');
309: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
310: FND_MSG_PUB.ADD;
311: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
312: fnd_log.string

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

305: OPEN uc_name_to_id_csr(p_x_flight_schedule_rec.unit_config_name);
306: FETCH uc_name_to_id_csr INTO p_x_flight_schedule_rec.unit_config_header_id;
307: IF uc_name_to_id_csr%NOTFOUND THEN
308: FND_MESSAGE.SET_NAME('AHL','AHL_UA_INV_UC_NAME');
309: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
310: FND_MSG_PUB.ADD;
311: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
312: fnd_log.string
313: (

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

336: THEN
337: OPEN org_name_to_id_csr(p_x_flight_schedule_rec.ARRIVAL_ORG_CODE);
338: FETCH org_name_to_id_csr INTO p_x_flight_schedule_rec.arrival_org_id;
339: IF org_name_to_id_csr%NOTFOUND THEN
340: FND_MESSAGE.SET_NAME('AHL','AHL_UA_INV_ARR_ORG');
341: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
342: FND_MSG_PUB.ADD;
343: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
344: fnd_log.string

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

337: OPEN org_name_to_id_csr(p_x_flight_schedule_rec.ARRIVAL_ORG_CODE);
338: FETCH org_name_to_id_csr INTO p_x_flight_schedule_rec.arrival_org_id;
339: IF org_name_to_id_csr%NOTFOUND THEN
340: FND_MESSAGE.SET_NAME('AHL','AHL_UA_INV_ARR_ORG');
341: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
342: FND_MSG_PUB.ADD;
343: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
344: fnd_log.string
345: (

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

373: OPEN dept_name_to_id_csr(p_x_flight_schedule_rec.arrival_dept_code,
374: p_x_flight_schedule_rec.ARRIVAL_ORG_ID);
375: FETCH dept_name_to_id_csr INTO p_x_flight_schedule_rec.arrival_dept_id;
376: IF dept_name_to_id_csr%NOTFOUND THEN
377: FND_MESSAGE.SET_NAME('AHL','AHL_UA_INV_ARR_DEPT');
378: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
379: FND_MSG_PUB.ADD;
380: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
381: fnd_log.string

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

374: p_x_flight_schedule_rec.ARRIVAL_ORG_ID);
375: FETCH dept_name_to_id_csr INTO p_x_flight_schedule_rec.arrival_dept_id;
376: IF dept_name_to_id_csr%NOTFOUND THEN
377: FND_MESSAGE.SET_NAME('AHL','AHL_UA_INV_ARR_DEPT');
378: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
379: FND_MSG_PUB.ADD;
380: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
381: fnd_log.string
382: (

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

405: THEN
406: OPEN org_name_to_id_csr(p_x_flight_schedule_rec.departure_org_code);
407: FETCH org_name_to_id_csr INTO p_x_flight_schedule_rec.departure_org_id;
408: IF org_name_to_id_csr%NOTFOUND THEN
409: FND_MESSAGE.SET_NAME('AHL','AHL_UA_INV_DEP_ORG');
410: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
411: FND_MSG_PUB.ADD;
412: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
413: fnd_log.string

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

406: OPEN org_name_to_id_csr(p_x_flight_schedule_rec.departure_org_code);
407: FETCH org_name_to_id_csr INTO p_x_flight_schedule_rec.departure_org_id;
408: IF org_name_to_id_csr%NOTFOUND THEN
409: FND_MESSAGE.SET_NAME('AHL','AHL_UA_INV_DEP_ORG');
410: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
411: FND_MSG_PUB.ADD;
412: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
413: fnd_log.string
414: (

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

442: OPEN dept_name_to_id_csr(p_x_flight_schedule_rec.departure_dept_code,
443: p_x_flight_schedule_rec.departure_org_id);
444: FETCH dept_name_to_id_csr INTO p_x_flight_schedule_rec.departure_dept_id;
445: IF dept_name_to_id_csr%NOTFOUND THEN
446: FND_MESSAGE.SET_NAME('AHL','AHL_UA_INV_DEP_DEPT');
447: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
448: FND_MSG_PUB.ADD;
449: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
450: fnd_log.string

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

443: p_x_flight_schedule_rec.departure_org_id);
444: FETCH dept_name_to_id_csr INTO p_x_flight_schedule_rec.departure_dept_id;
445: IF dept_name_to_id_csr%NOTFOUND THEN
446: FND_MESSAGE.SET_NAME('AHL','AHL_UA_INV_DEP_DEPT');
447: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
448: FND_MSG_PUB.ADD;
449: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
450: fnd_log.string
451: (

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

481: );
482:
483: -- If any severe error occurs, then, abort API.
484: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
485: FND_MESSAGE.SET_NAME('AHL','AHL_UA_INV_RESCH_MODE');
486: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
487: FND_MSG_PUB.ADD;
488: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
489: fnd_log.string

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

482:
483: -- If any severe error occurs, then, abort API.
484: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
485: FND_MESSAGE.SET_NAME('AHL','AHL_UA_INV_RESCH_MODE');
486: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
487: FND_MSG_PUB.ADD;
488: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
489: fnd_log.string
490: (

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

694: p_flight_schedule_rec.unit_config_header_id IS NULL OR
695: p_flight_schedule_rec.unit_config_header_id = FND_API.G_MISS_NUM
696: )
697: THEN
698: FND_MESSAGE.set_name( 'AHL','AHL_UA_INV_UC_NAME' );
699: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
700: FND_MSG_PUB.add;
701: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
702: fnd_log.string

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

695: p_flight_schedule_rec.unit_config_header_id = FND_API.G_MISS_NUM
696: )
697: THEN
698: FND_MESSAGE.set_name( 'AHL','AHL_UA_INV_UC_NAME' );
699: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
700: FND_MSG_PUB.add;
701: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
702: fnd_log.string
703: (

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

715: p_flight_schedule_rec.flight_number IS NULL OR
716: p_flight_schedule_rec.flight_number = FND_API.G_MISS_CHAR
717: )
718: THEN
719: FND_MESSAGE.set_name( 'AHL', 'AHL_UA_FLG_NUMBER_NULL' );
720: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
721: FND_MSG_PUB.add;
722: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
723: fnd_log.string

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

716: p_flight_schedule_rec.flight_number = FND_API.G_MISS_CHAR
717: )
718: THEN
719: FND_MESSAGE.set_name( 'AHL', 'AHL_UA_FLG_NUMBER_NULL' );
720: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
721: FND_MSG_PUB.add;
722: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
723: fnd_log.string
724: (

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

737: p_flight_schedule_rec.segment IS NULL OR
738: p_flight_schedule_rec.segment = FND_API.G_MISS_CHAR
739: )
740: THEN
741: FND_MESSAGE.set_name( 'AHL', 'AHL_UA_SEGMENT_NULL' );
742: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
743: FND_MSG_PUB.add;
744: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
745: fnd_log.string

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

738: p_flight_schedule_rec.segment = FND_API.G_MISS_CHAR
739: )
740: THEN
741: FND_MESSAGE.set_name( 'AHL', 'AHL_UA_SEGMENT_NULL' );
742: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
743: FND_MSG_PUB.add;
744: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
745: fnd_log.string
746: (

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

759: p_flight_schedule_rec.departure_dept_id IS NULL OR
760: p_flight_schedule_rec.departure_dept_id = FND_API.G_MISS_NUM
761: )
762: THEN
763: FND_MESSAGE.set_name( 'AHL','AHL_UA_DEP_DEPT_NULL' );
764: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
765: FND_MSG_PUB.add;
766: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
767: fnd_log.string

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

760: p_flight_schedule_rec.departure_dept_id = FND_API.G_MISS_NUM
761: )
762: THEN
763: FND_MESSAGE.set_name( 'AHL','AHL_UA_DEP_DEPT_NULL' );
764: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
765: FND_MSG_PUB.add;
766: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
767: fnd_log.string
768: (

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

780: p_flight_schedule_rec.departure_org_id IS NULL OR
781: p_flight_schedule_rec.departure_org_id = FND_API.G_MISS_NUM
782: )
783: THEN
784: FND_MESSAGE.set_name( 'AHL','AHL_UA_DEP_ORG_NULL' );
785: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
786: FND_MSG_PUB.add;
787: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
788: fnd_log.string

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

781: p_flight_schedule_rec.departure_org_id = FND_API.G_MISS_NUM
782: )
783: THEN
784: FND_MESSAGE.set_name( 'AHL','AHL_UA_DEP_ORG_NULL' );
785: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
786: FND_MSG_PUB.add;
787: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
788: fnd_log.string
789: (

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

801: p_flight_schedule_rec.arrival_dept_id IS NULL OR
802: p_flight_schedule_rec.arrival_dept_id = FND_API.G_MISS_NUM
803: )
804: THEN
805: FND_MESSAGE.set_name( 'AHL','AHL_UA_ARR_DEPT_NULL' );
806: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
807: FND_MSG_PUB.add;
808: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
809: fnd_log.string

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

802: p_flight_schedule_rec.arrival_dept_id = FND_API.G_MISS_NUM
803: )
804: THEN
805: FND_MESSAGE.set_name( 'AHL','AHL_UA_ARR_DEPT_NULL' );
806: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
807: FND_MSG_PUB.add;
808: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
809: fnd_log.string
810: (

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

822: p_flight_schedule_rec.arrival_org_id IS NULL OR
823: p_flight_schedule_rec.arrival_org_id = FND_API.G_MISS_NUM
824: )
825: THEN
826: FND_MESSAGE.set_name( 'AHL','AHL_UA_ARR_ORG_NULL' );
827: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
828: FND_MSG_PUB.add;
829: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
830: fnd_log.string

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

823: p_flight_schedule_rec.arrival_org_id = FND_API.G_MISS_NUM
824: )
825: THEN
826: FND_MESSAGE.set_name( 'AHL','AHL_UA_ARR_ORG_NULL' );
827: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
828: FND_MSG_PUB.add;
829: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
830: fnd_log.string
831: (

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

843: p_flight_schedule_rec.est_departure_time IS NULL OR
844: p_flight_schedule_rec.est_departure_time = FND_API.G_MISS_DATE
845: )
846: THEN
847: FND_MESSAGE.set_name( 'AHL','AHL_UA_EST_DEP_TIME_NULL' );
848: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
849: FND_MSG_PUB.add;
850: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
851: fnd_log.string

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

844: p_flight_schedule_rec.est_departure_time = FND_API.G_MISS_DATE
845: )
846: THEN
847: FND_MESSAGE.set_name( 'AHL','AHL_UA_EST_DEP_TIME_NULL' );
848: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
849: FND_MSG_PUB.add;
850: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
851: fnd_log.string
852: (

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

864: p_flight_schedule_rec.est_arrival_time IS NULL OR
865: p_flight_schedule_rec.est_arrival_time = FND_API.G_MISS_DATE
866: )
867: THEN
868: FND_MESSAGE.set_name( 'AHL','AHL_UA_EST_ARR_TIME_NULL' );
869: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
870: FND_MSG_PUB.add;
871: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
872: fnd_log.string

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

865: p_flight_schedule_rec.est_arrival_time = FND_API.G_MISS_DATE
866: )
867: THEN
868: FND_MESSAGE.set_name( 'AHL','AHL_UA_EST_ARR_TIME_NULL' );
869: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
870: FND_MSG_PUB.add;
871: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
872: fnd_log.string
873: (

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

885: p_flight_schedule_rec.visit_reschedule_mode IS NULL OR
886: p_flight_schedule_rec.visit_reschedule_mode = FND_API.G_MISS_CHAR
887: )
888: THEN
889: FND_MESSAGE.set_name( 'AHL','AHL_UA_VST_RES_MODE_NULL' );
890: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
891: FND_MSG_PUB.add;
892: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
893: fnd_log.string

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

886: p_flight_schedule_rec.visit_reschedule_mode = FND_API.G_MISS_CHAR
887: )
888: THEN
889: FND_MESSAGE.set_name( 'AHL','AHL_UA_VST_RES_MODE_NULL' );
890: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
891: FND_MSG_PUB.add;
892: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
893: fnd_log.string
894: (

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

963: OPEN get_current_us_csr(p_x_flight_schedule_rec.unit_schedule_id);
964: FETCH get_current_us_csr INTO l_current_us_rec;
965: IF get_current_us_csr%NOTFOUND
966: THEN
967: FND_MESSAGE.set_name( 'AHL', 'AHL_UA_US_NOT_FOUND' );
968: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
969: FND_MSG_PUB.add;
970: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
971: fnd_log.string

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

964: FETCH get_current_us_csr INTO l_current_us_rec;
965: IF get_current_us_csr%NOTFOUND
966: THEN
967: FND_MESSAGE.set_name( 'AHL', 'AHL_UA_US_NOT_FOUND' );
968: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
969: FND_MSG_PUB.add;
970: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
971: fnd_log.string
972: (

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

985:
986: -- Unit cannot be updated irrespective of the whether the user is super user or not
987: IF p_x_flight_schedule_rec.unit_config_header_id <> l_current_us_rec.unit_config_header_id
988: THEN
989: FND_MESSAGE.set_name( 'AHL','AHL_UA_UNIT_NO_UPDATE' );
990: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
991: FND_MSG_PUB.add;
992: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
993: fnd_log.string

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

986: -- Unit cannot be updated irrespective of the whether the user is super user or not
987: IF p_x_flight_schedule_rec.unit_config_header_id <> l_current_us_rec.unit_config_header_id
988: THEN
989: FND_MESSAGE.set_name( 'AHL','AHL_UA_UNIT_NO_UPDATE' );
990: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
991: FND_MSG_PUB.add;
992: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
993: fnd_log.string
994: (

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

1006: /* --Un comment the code if this is required
1007: -- Flight Number cannot be updated unless user is super user.
1008: IF p_x_flight_schedule_rec.flight_number <> l_current_us_rec.flight_number
1009: THEN
1010: FND_MESSAGE.set_name( 'AHL','AHL_UA_FLIGHT_NO_UPDATE' );
1011: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
1012: FND_MSG_PUB.add;
1013: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1014: fnd_log.string

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

1007: -- Flight Number cannot be updated unless user is super user.
1008: IF p_x_flight_schedule_rec.flight_number <> l_current_us_rec.flight_number
1009: THEN
1010: FND_MESSAGE.set_name( 'AHL','AHL_UA_FLIGHT_NO_UPDATE' );
1011: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
1012: FND_MSG_PUB.add;
1013: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1014: fnd_log.string
1015: (

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

1025:
1026: -- Flight Segment cannot be updated unless user is super user.
1027: IF p_x_flight_schedule_rec.segment <> l_current_us_rec.segment
1028: THEN
1029: FND_MESSAGE.set_name( 'AHL','AHL_UA_SEGMENT_NO_UPDATE' );
1030: FND_MESSAGE.set_token( 'RECORD', l_record_identifier);
1031: FND_MSG_PUB.add;
1032: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1033: fnd_log.string

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

1026: -- Flight Segment cannot be updated unless user is super user.
1027: IF p_x_flight_schedule_rec.segment <> l_current_us_rec.segment
1028: THEN
1029: FND_MESSAGE.set_name( 'AHL','AHL_UA_SEGMENT_NO_UPDATE' );
1030: FND_MESSAGE.set_token( 'RECORD', l_record_identifier);
1031: FND_MSG_PUB.add;
1032: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1033: fnd_log.string
1034: (

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

1047: -- Departure department cannot be updated unless user is super user.
1048: IF p_x_flight_schedule_rec.departure_dept_id <> l_current_us_rec.departure_dept_id AND
1049: l_update_allowed = FND_API.G_FALSE
1050: THEN
1051: FND_MESSAGE.set_name( 'AHL', 'AHL_UA_DEP_DEPT_NO_UPDATE' );
1052: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
1053: FND_MSG_PUB.add;
1054: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1055: fnd_log.string

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

1048: IF p_x_flight_schedule_rec.departure_dept_id <> l_current_us_rec.departure_dept_id AND
1049: l_update_allowed = FND_API.G_FALSE
1050: THEN
1051: FND_MESSAGE.set_name( 'AHL', 'AHL_UA_DEP_DEPT_NO_UPDATE' );
1052: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
1053: FND_MSG_PUB.add;
1054: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1055: fnd_log.string
1056: (

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

1067: -- Departure Organization cannot be updated unless user is super user.
1068: IF p_x_flight_schedule_rec.departure_org_id <> l_current_us_rec.departure_org_id AND
1069: l_update_allowed = FND_API.G_FALSE
1070: THEN
1071: FND_MESSAGE.set_name( 'AHL', 'AHL_UA_DEP_ORG_NO_UPDATE' );
1072: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
1073: FND_MSG_PUB.add;
1074: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1075: fnd_log.string

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

1068: IF p_x_flight_schedule_rec.departure_org_id <> l_current_us_rec.departure_org_id AND
1069: l_update_allowed = FND_API.G_FALSE
1070: THEN
1071: FND_MESSAGE.set_name( 'AHL', 'AHL_UA_DEP_ORG_NO_UPDATE' );
1072: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
1073: FND_MSG_PUB.add;
1074: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1075: fnd_log.string
1076: (

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

1087: -- Arrival Department cannot be updated unless user is super user.
1088: IF p_x_flight_schedule_rec.arrival_dept_id <> l_current_us_rec.arrival_dept_id AND
1089: l_update_allowed = FND_API.G_FALSE
1090: THEN
1091: FND_MESSAGE.set_name( 'AHL', 'AHL_UA_ARR_DEP_NO_UPDATE' );
1092: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
1093: FND_MSG_PUB.add;
1094: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1095: fnd_log.string

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

1088: IF p_x_flight_schedule_rec.arrival_dept_id <> l_current_us_rec.arrival_dept_id AND
1089: l_update_allowed = FND_API.G_FALSE
1090: THEN
1091: FND_MESSAGE.set_name( 'AHL', 'AHL_UA_ARR_DEP_NO_UPDATE' );
1092: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
1093: FND_MSG_PUB.add;
1094: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1095: fnd_log.string
1096: (

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

1107: -- Arrival Organization cannot be updated unless user is super user.
1108: IF p_x_flight_schedule_rec.arrival_org_id <> l_current_us_rec.arrival_org_id AND
1109: l_update_allowed = FND_API.G_FALSE
1110: THEN
1111: FND_MESSAGE.set_name( 'AHL', 'AHL_UA_ARR_ORG_NO_UPDATE' );
1112: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
1113: FND_MSG_PUB.add;
1114: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1115: fnd_log.string

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

1108: IF p_x_flight_schedule_rec.arrival_org_id <> l_current_us_rec.arrival_org_id AND
1109: l_update_allowed = FND_API.G_FALSE
1110: THEN
1111: FND_MESSAGE.set_name( 'AHL', 'AHL_UA_ARR_ORG_NO_UPDATE' );
1112: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
1113: FND_MSG_PUB.add;
1114: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1115: fnd_log.string
1116: (

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

1127: -- Estimated Departure Time cannot be updated unless user is super user.
1128: IF p_x_flight_schedule_rec.est_departure_time <> l_current_us_rec.est_departure_time AND
1129: l_update_allowed = FND_API.G_FALSE
1130: THEN
1131: FND_MESSAGE.set_name( 'AHL', 'AHL_UA_EST_DEP_NO_UPDATE' );
1132: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
1133: FND_MSG_PUB.add;
1134: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1135: fnd_log.string

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

1128: IF p_x_flight_schedule_rec.est_departure_time <> l_current_us_rec.est_departure_time AND
1129: l_update_allowed = FND_API.G_FALSE
1130: THEN
1131: FND_MESSAGE.set_name( 'AHL', 'AHL_UA_EST_DEP_NO_UPDATE' );
1132: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
1133: FND_MSG_PUB.add;
1134: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1135: fnd_log.string
1136: (

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

1147: -- Estimated Arrival Time cannot be updated unless user is super user.
1148: IF p_x_flight_schedule_rec.est_arrival_time <> l_current_us_rec.est_arrival_time AND
1149: l_update_allowed = FND_API.G_FALSE
1150: THEN
1151: FND_MESSAGE.set_name( 'AHL', 'AHL_UA_EST_ARR_NO_UPDATE' );
1152: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
1153: FND_MSG_PUB.add;
1154: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1155: fnd_log.string

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

1148: IF p_x_flight_schedule_rec.est_arrival_time <> l_current_us_rec.est_arrival_time AND
1149: l_update_allowed = FND_API.G_FALSE
1150: THEN
1151: FND_MESSAGE.set_name( 'AHL', 'AHL_UA_EST_ARR_NO_UPDATE' );
1152: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
1153: FND_MSG_PUB.add;
1154: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1155: fnd_log.string
1156: (

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

1277: AND is_delete_allowed(p_unit_schedule_id => p_x_flight_schedule_rec.unit_schedule_id,
1278: p_is_super_user => is_super_user
1279: ) = FND_API.G_FALSE
1280: THEN
1281: FND_MESSAGE.set_name( 'AHL', 'AHL_UA_ACT_NO_DEL' );
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: p_is_super_user => is_super_user
1279: ) = FND_API.G_FALSE
1280: THEN
1281: FND_MESSAGE.set_name( 'AHL', 'AHL_UA_ACT_NO_DEL' );
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 1309: FND_MESSAGE.set_name( 'AHL', 'AHL_UA_DUP_FLG_SCH' );

1305: AND unit_schedule_id <> nvl(p_x_flight_schedule_rec.unit_schedule_id,-100);
1306:
1307: IF l_us_dup_count > 0 THEN
1308: -- Duplicate found, so throw error.
1309: FND_MESSAGE.set_name( 'AHL', 'AHL_UA_DUP_FLG_SCH' );
1310: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
1311: FND_MSG_PUB.add;
1312: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1313: fnd_log.string

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

1306:
1307: IF l_us_dup_count > 0 THEN
1308: -- Duplicate found, so throw error.
1309: FND_MESSAGE.set_name( 'AHL', 'AHL_UA_DUP_FLG_SCH' );
1310: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
1311: FND_MSG_PUB.add;
1312: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1313: fnd_log.string
1314: (

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

1332: p_x_flight_schedule_rec.ACTUAL_DEPARTURE_TIME IS NULL OR
1333: p_x_flight_schedule_rec.ACTUAL_DEPARTURE_TIME = FND_API.G_MISS_DATE
1334: )
1335: THEN
1336: FND_MESSAGE.set_name( 'AHL', 'AHL_UA_ARR_WO_DEP' );
1337: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
1338: FND_MSG_PUB.add;
1339: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1340: fnd_log.string

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

1333: p_x_flight_schedule_rec.ACTUAL_DEPARTURE_TIME = FND_API.G_MISS_DATE
1334: )
1335: THEN
1336: FND_MESSAGE.set_name( 'AHL', 'AHL_UA_ARR_WO_DEP' );
1337: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
1338: FND_MSG_PUB.add;
1339: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1340: fnd_log.string
1341: (

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

1359: p_x_flight_schedule_rec.ACTUAL_ARRIVAL_TIME <> FND_API.G_MISS_DATE AND
1360: p_x_flight_schedule_rec.ACTUAL_ARRIVAL_TIME > SYSDATE
1361: )
1362: THEN
1363: FND_MESSAGE.set_name( 'AHL', 'AHL_UA_ACT_GT_SYSDATE' );
1364: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
1365: FND_MSG_PUB.add;
1366: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1367: fnd_log.string

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

1360: p_x_flight_schedule_rec.ACTUAL_ARRIVAL_TIME > SYSDATE
1361: )
1362: THEN
1363: FND_MESSAGE.set_name( 'AHL', 'AHL_UA_ACT_GT_SYSDATE' );
1364: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
1365: FND_MSG_PUB.add;
1366: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1367: fnd_log.string
1368: (

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

1381: )
1382: AND
1383: p_x_flight_schedule_rec.EST_DEPARTURE_TIME >= p_x_flight_schedule_rec.EST_ARRIVAL_TIME
1384: THEN
1385: FND_MESSAGE.set_name( 'AHL', 'AHL_UA_ARR_LT_DEP' );
1386: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
1387: FND_MSG_PUB.add;
1388: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1389: fnd_log.string

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

1382: AND
1383: p_x_flight_schedule_rec.EST_DEPARTURE_TIME >= p_x_flight_schedule_rec.EST_ARRIVAL_TIME
1384: THEN
1385: FND_MESSAGE.set_name( 'AHL', 'AHL_UA_ARR_LT_DEP' );
1386: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
1387: FND_MSG_PUB.add;
1388: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1389: fnd_log.string
1390: (

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

1404: )
1405: AND
1406: p_x_flight_schedule_rec.ACTUAL_DEPARTURE_TIME >= p_x_flight_schedule_rec.ACTUAL_ARRIVAL_TIME
1407: THEN
1408: FND_MESSAGE.set_name( 'AHL', 'AHL_UA_ARR_LT_DEP' );
1409: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
1410: FND_MSG_PUB.add;
1411: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1412: fnd_log.string

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

1405: AND
1406: p_x_flight_schedule_rec.ACTUAL_DEPARTURE_TIME >= p_x_flight_schedule_rec.ACTUAL_ARRIVAL_TIME
1407: THEN
1408: FND_MESSAGE.set_name( 'AHL', 'AHL_UA_ARR_LT_DEP' );
1409: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
1410: FND_MSG_PUB.add;
1411: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1412: fnd_log.string
1413: (

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

1459: IF l_preceeding_us_rec.unit_schedule_id IS NOT NULL AND
1460: (l_preceeding_us_rec.actual_departure_time IS NULL OR
1461: l_preceeding_us_rec.actual_arrival_time IS NULL )
1462: THEN
1463: FND_MESSAGE.set_name( 'AHL', 'AHL_UA_PRE_ACT_NOT_REC' );
1464: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
1465: FND_MSG_PUB.add;
1466: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1467: fnd_log.string

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

1460: (l_preceeding_us_rec.actual_departure_time IS NULL OR
1461: l_preceeding_us_rec.actual_arrival_time IS NULL )
1462: THEN
1463: FND_MESSAGE.set_name( 'AHL', 'AHL_UA_PRE_ACT_NOT_REC' );
1464: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
1465: FND_MSG_PUB.add;
1466: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1467: fnd_log.string
1468: (

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

1486: )
1487: AND unit_schedule_id <> nvl(p_x_flight_schedule_rec.unit_schedule_id,-110);
1488:
1489: IF l_est_violation_count > 0 THEN
1490: FND_MESSAGE.set_name( 'AHL', 'AHL_UA_EST_ARR_VIO' );
1491: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
1492: FND_MSG_PUB.add;
1493: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1494: fnd_log.string

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

1487: AND unit_schedule_id <> nvl(p_x_flight_schedule_rec.unit_schedule_id,-110);
1488:
1489: IF l_est_violation_count > 0 THEN
1490: FND_MESSAGE.set_name( 'AHL', 'AHL_UA_EST_ARR_VIO' );
1491: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
1492: FND_MSG_PUB.add;
1493: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1494: fnd_log.string
1495: (

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

2087: END IF;
2088:
2089: IF l_overlap_us_count > 0 THEN
2090: -- There is an overlap in times.
2091: FND_MESSAGE.set_name('AHL', 'AHL_UA_US_TIME_OVERLAP');
2092: FND_MESSAGE.set_token( 'RECORD', get_record_identifier(
2093: p_flight_schedule_rec => p_x_flight_schedules_tbl(i)
2094: ) );
2095:

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

2088:
2089: IF l_overlap_us_count > 0 THEN
2090: -- There is an overlap in times.
2091: FND_MESSAGE.set_name('AHL', 'AHL_UA_US_TIME_OVERLAP');
2092: FND_MESSAGE.set_token( 'RECORD', get_record_identifier(
2093: p_flight_schedule_rec => p_x_flight_schedules_tbl(i)
2094: ) );
2095:
2096: p_x_flight_schedules_tbl(i).conflict_message := FND_MESSAGE.GET;

Line 2096: p_x_flight_schedules_tbl(i).conflict_message := FND_MESSAGE.GET;

2092: FND_MESSAGE.set_token( 'RECORD', get_record_identifier(
2093: p_flight_schedule_rec => p_x_flight_schedules_tbl(i)
2094: ) );
2095:
2096: p_x_flight_schedules_tbl(i).conflict_message := FND_MESSAGE.GET;
2097: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
2098: fnd_log.string
2099: (
2100: fnd_log.level_error,

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

2398: AND object_version_number= p_x_flight_schedules_tbl(i).object_version_number;
2399:
2400: -- If the record does not exist, then, abort API.
2401: IF ( SQL%ROWCOUNT = 0 ) THEN
2402: FND_MESSAGE.set_name('AHL','AHL_COM_RECORD_CHANGED');
2403: FND_MESSAGE.set_token( 'RECORD', get_record_identifier(
2404: p_flight_schedule_rec => p_x_flight_schedules_tbl(i)
2405: ) );
2406: FND_MSG_PUB.add;

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

2399:
2400: -- If the record does not exist, then, abort API.
2401: IF ( SQL%ROWCOUNT = 0 ) THEN
2402: FND_MESSAGE.set_name('AHL','AHL_COM_RECORD_CHANGED');
2403: FND_MESSAGE.set_token( 'RECORD', get_record_identifier(
2404: p_flight_schedule_rec => p_x_flight_schedules_tbl(i)
2405: ) );
2406: FND_MSG_PUB.add;
2407: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN

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

2538: END IF;
2539:
2540: IF l_overlap_us_count > 0 THEN
2541: -- There is an overlap in times.
2542: FND_MESSAGE.set_name('AHL', 'AHL_UA_US_TIME_OVERLAP');
2543: FND_MESSAGE.set_token( 'RECORD', get_record_identifier(
2544: p_flight_schedule_rec => p_x_flight_schedules_tbl(i)
2545: ) );
2546:

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

2539:
2540: IF l_overlap_us_count > 0 THEN
2541: -- There is an overlap in times.
2542: FND_MESSAGE.set_name('AHL', 'AHL_UA_US_TIME_OVERLAP');
2543: FND_MESSAGE.set_token( 'RECORD', get_record_identifier(
2544: p_flight_schedule_rec => p_x_flight_schedules_tbl(i)
2545: ) );
2546:
2547: p_x_flight_schedules_tbl(i).conflict_message := FND_MESSAGE.GET;

Line 2547: p_x_flight_schedules_tbl(i).conflict_message := FND_MESSAGE.GET;

2543: FND_MESSAGE.set_token( 'RECORD', get_record_identifier(
2544: p_flight_schedule_rec => p_x_flight_schedules_tbl(i)
2545: ) );
2546:
2547: p_x_flight_schedules_tbl(i).conflict_message := FND_MESSAGE.GET;
2548: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
2549: fnd_log.string
2550: (
2551: fnd_log.level_error,

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

2730: AND object_version_number= p_x_flight_schedules_tbl(i).object_version_number;
2731:
2732: -- If the record does not exist, then, abort API.
2733: IF ( SQL%ROWCOUNT = 0 ) THEN
2734: FND_MESSAGE.set_name('AHL','AHL_COM_RECORD_CHANGED');
2735: FND_MESSAGE.set_token( 'RECORD', get_record_identifier(
2736: p_flight_schedule_rec => p_x_flight_schedules_tbl(i)
2737: ) );
2738: FND_MSG_PUB.add;

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

2731:
2732: -- If the record does not exist, then, abort API.
2733: IF ( SQL%ROWCOUNT = 0 ) THEN
2734: FND_MESSAGE.set_name('AHL','AHL_COM_RECORD_CHANGED');
2735: FND_MESSAGE.set_token( 'RECORD', get_record_identifier(
2736: p_flight_schedule_rec => p_x_flight_schedules_tbl(i)
2737: ) );
2738: FND_MSG_PUB.add;
2739: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN

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

2939:
2940: -- Throw error if p_unit_schedule_id is null
2941:
2942: IF p_unit_schedule_id IS NULL THEN
2943: FND_MESSAGE.set_name('AHL','AHL_UA_US_NOT_FOUND');
2944: FND_MSG_PUB.add;
2945: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
2946: fnd_log.string
2947: (

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

2955: ELSE
2956: OPEN check_flight_exists_csr(p_unit_schedule_id, p_unit_config_id);
2957: FETCH check_flight_exists_csr INTO l_dummy;
2958: IF check_flight_exists_csr%NOTFOUND THEN
2959: FND_MESSAGE.set_name('AHL','AHL_UA_US_NOT_FOUND');
2960: FND_MSG_PUB.add;
2961: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
2962: fnd_log.string
2963: (