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_LOG

Line 16: l_log_current_level NUMBER := FND_LOG.g_current_runtime_level;

12:
13: ------------------------------------------------------------------------------------
14: -- Common variables
15: ------------------------------------------------------------------------------------
16: l_log_current_level NUMBER := FND_LOG.g_current_runtime_level;
17: l_log_statement NUMBER := FND_LOG.level_statement;
18: l_log_procedure NUMBER := FND_LOG.level_procedure;
19: l_log_error NUMBER := FND_LOG.level_error;
20: l_log_exception NUMBER := FND_LOG.level_exception;

Line 17: l_log_statement NUMBER := FND_LOG.level_statement;

13: ------------------------------------------------------------------------------------
14: -- Common variables
15: ------------------------------------------------------------------------------------
16: l_log_current_level NUMBER := FND_LOG.g_current_runtime_level;
17: l_log_statement NUMBER := FND_LOG.level_statement;
18: l_log_procedure NUMBER := FND_LOG.level_procedure;
19: l_log_error NUMBER := FND_LOG.level_error;
20: l_log_exception NUMBER := FND_LOG.level_exception;
21: l_log_unexpected NUMBER := FND_LOG.level_unexpected;

Line 18: l_log_procedure NUMBER := FND_LOG.level_procedure;

14: -- Common variables
15: ------------------------------------------------------------------------------------
16: l_log_current_level NUMBER := FND_LOG.g_current_runtime_level;
17: l_log_statement NUMBER := FND_LOG.level_statement;
18: l_log_procedure NUMBER := FND_LOG.level_procedure;
19: l_log_error NUMBER := FND_LOG.level_error;
20: l_log_exception NUMBER := FND_LOG.level_exception;
21: l_log_unexpected NUMBER := FND_LOG.level_unexpected;
22: ------------------------------------------------------------------------------------

Line 19: l_log_error NUMBER := FND_LOG.level_error;

15: ------------------------------------------------------------------------------------
16: l_log_current_level NUMBER := FND_LOG.g_current_runtime_level;
17: l_log_statement NUMBER := FND_LOG.level_statement;
18: l_log_procedure NUMBER := FND_LOG.level_procedure;
19: l_log_error NUMBER := FND_LOG.level_error;
20: l_log_exception NUMBER := FND_LOG.level_exception;
21: l_log_unexpected NUMBER := FND_LOG.level_unexpected;
22: ------------------------------------------------------------------------------------
23:

Line 20: l_log_exception NUMBER := FND_LOG.level_exception;

16: l_log_current_level NUMBER := FND_LOG.g_current_runtime_level;
17: l_log_statement NUMBER := FND_LOG.level_statement;
18: l_log_procedure NUMBER := FND_LOG.level_procedure;
19: l_log_error NUMBER := FND_LOG.level_error;
20: l_log_exception NUMBER := FND_LOG.level_exception;
21: l_log_unexpected NUMBER := FND_LOG.level_unexpected;
22: ------------------------------------------------------------------------------------
23:
24: -- Internal record structure used to pass visit reschedule related details to

Line 21: l_log_unexpected NUMBER := FND_LOG.level_unexpected;

17: l_log_statement NUMBER := FND_LOG.level_statement;
18: l_log_procedure NUMBER := FND_LOG.level_procedure;
19: l_log_error NUMBER := FND_LOG.level_error;
20: l_log_exception NUMBER := FND_LOG.level_exception;
21: l_log_unexpected NUMBER := FND_LOG.level_unexpected;
22: ------------------------------------------------------------------------------------
23:
24: -- Internal record structure used to pass visit reschedule related details to
25: -- Visit sync procedure.

Line 127: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN

123: l_msg_data VARCHAR2(2000);
124:
125: BEGIN
126:
127: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
128: fnd_log.string
129: (
130: fnd_log.level_procedure,
131: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||'.begin',

Line 128: fnd_log.string

124:
125: BEGIN
126:
127: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
128: fnd_log.string
129: (
130: fnd_log.level_procedure,
131: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||'.begin',
132: 'At the start of '||l_api_name

Line 130: fnd_log.level_procedure,

126:
127: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
128: fnd_log.string
129: (
130: fnd_log.level_procedure,
131: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||'.begin',
132: 'At the start of '||l_api_name
133: );
134: END IF;

Line 155: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)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: (
158: fnd_log.level_error,
159: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',

Line 156: fnd_log.string

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: (
158: fnd_log.level_error,
159: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
160: 'DML Operation specified is invalid for '

Line 158: fnd_log.level_error,

154: FND_MSG_PUB.add;
155: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
156: fnd_log.string
157: (
158: fnd_log.level_error,
159: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
160: 'DML Operation specified is invalid for '
161: ||p_x_flight_schedule_rec.unit_schedule_id
162: );

Line 182: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN

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: (
185: fnd_log.level_error,
186: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',

Line 183: fnd_log.string

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: (
185: fnd_log.level_error,
186: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
187: 'Unit Schedule ID is null for '

Line 185: fnd_log.level_error,

181: FND_MSG_PUB.add;
182: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
183: fnd_log.string
184: (
185: fnd_log.level_error,
186: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
187: 'Unit Schedule ID is null for '
188: ||p_x_flight_schedule_rec.unit_schedule_id
189: );

Line 202: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN

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: (
205: fnd_log.level_error,
206: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',

Line 203: fnd_log.string

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: (
205: fnd_log.level_error,
206: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
207: 'Object Version Number is null for '

Line 205: fnd_log.level_error,

201: FND_MSG_PUB.add;
202: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
203: fnd_log.string
204: (
205: fnd_log.level_error,
206: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
207: 'Object Version Number is null for '
208: ||p_x_flight_schedule_rec.unit_schedule_id
209: );

Line 223: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN

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: (
226: fnd_log.level_error,
227: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',

Line 224: fnd_log.string

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: (
226: fnd_log.level_error,
227: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
228: 'Unit Schedule record is not valid ->'

Line 226: fnd_log.level_error,

222: FND_MSG_PUB.add;
223: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
224: fnd_log.string
225: (
226: fnd_log.level_error,
227: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
228: 'Unit Schedule record is not valid ->'
229: ||p_x_flight_schedule_rec.unit_schedule_id
230: );

Line 275: FND_LOG.string(l_log_statement, l_full_name,

271: END IF;
272: FND_MSG_PUB.add;
273:
274: IF (l_log_statement >= l_log_current_level) THEN
275: FND_LOG.string(l_log_statement, l_full_name,
276: 'Flight Category Code ' || p_x_flight_schedule_rec.flight_category_code || ' is not valid.');
277: END IF;
278: RAISE FND_API.G_EXC_ERROR;
279:

Line 285: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN

281: END IF;
282:
283: END IF; -- if p_x_flight_schedule_rec.dml_operation = 'C' or 'U'
284:
285: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
286: fnd_log.string
287: (
288: fnd_log.level_procedure,
289: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||'.end',

Line 286: fnd_log.string

282:
283: END IF; -- if p_x_flight_schedule_rec.dml_operation = 'C' or 'U'
284:
285: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
286: fnd_log.string
287: (
288: fnd_log.level_procedure,
289: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||'.end',
290: 'At the end of '||l_api_name

Line 288: fnd_log.level_procedure,

284:
285: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
286: fnd_log.string
287: (
288: fnd_log.level_procedure,
289: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||'.end',
290: 'At the end of '||l_api_name
291: );
292: END IF;

Line 359: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN

355: l_msg_data VARCHAR2(30);
356:
357: BEGIN
358:
359: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
360: fnd_log.string
361: (
362: fnd_log.level_procedure,
363: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||'.begin',

Line 360: fnd_log.string

356:
357: BEGIN
358:
359: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
360: fnd_log.string
361: (
362: fnd_log.level_procedure,
363: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||'.begin',
364: 'At the start of '||l_api_name

Line 362: fnd_log.level_procedure,

358:
359: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
360: fnd_log.string
361: (
362: fnd_log.level_procedure,
363: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||'.begin',
364: 'At the start of '||l_api_name
365: );
366: END IF;

Line 393: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN

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: (
396: fnd_log.level_error,
397: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',

Line 394: fnd_log.string

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: (
396: fnd_log.level_error,
397: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
398: 'Unit Config name specified for '||p_x_flight_schedule_rec.unit_schedule_id

Line 396: fnd_log.level_error,

392: FND_MSG_PUB.ADD;
393: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
394: fnd_log.string
395: (
396: fnd_log.level_error,
397: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
398: 'Unit Config name specified for '||p_x_flight_schedule_rec.unit_schedule_id
399: ||' is invalid'
400: );

Line 425: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN

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: (
428: fnd_log.level_error,
429: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',

Line 426: fnd_log.string

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: (
428: fnd_log.level_error,
429: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
430: 'Arrival Org code specified for '||p_x_flight_schedule_rec.unit_schedule_id

Line 428: fnd_log.level_error,

424: FND_MSG_PUB.ADD;
425: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
426: fnd_log.string
427: (
428: fnd_log.level_error,
429: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
430: 'Arrival Org code specified for '||p_x_flight_schedule_rec.unit_schedule_id
431: ||' is invalid'
432: );

Line 462: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN

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: (
465: fnd_log.level_error,
466: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',

Line 463: fnd_log.string

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: (
465: fnd_log.level_error,
466: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
467: 'Arrival Department code specified for '||p_x_flight_schedule_rec.unit_schedule_id

Line 465: fnd_log.level_error,

461: FND_MSG_PUB.ADD;
462: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
463: fnd_log.string
464: (
465: fnd_log.level_error,
466: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
467: 'Arrival Department code specified for '||p_x_flight_schedule_rec.unit_schedule_id
468: ||' is invalid'
469: );

Line 494: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN

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: (
497: fnd_log.level_error,
498: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',

Line 495: fnd_log.string

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: (
497: fnd_log.level_error,
498: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
499: 'Departure org code specified for '||p_x_flight_schedule_rec.unit_schedule_id

Line 497: fnd_log.level_error,

493: FND_MSG_PUB.ADD;
494: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
495: fnd_log.string
496: (
497: fnd_log.level_error,
498: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
499: 'Departure org code specified for '||p_x_flight_schedule_rec.unit_schedule_id
500: ||' is invalid'
501: );

Line 531: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN

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: (
534: fnd_log.level_error,
535: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',

Line 532: fnd_log.string

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: (
534: fnd_log.level_error,
535: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
536: 'Departure department code specified for '||p_x_flight_schedule_rec.unit_schedule_id

Line 534: fnd_log.level_error,

530: FND_MSG_PUB.ADD;
531: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
532: fnd_log.string
533: (
534: fnd_log.level_error,
535: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
536: 'Departure department code specified for '||p_x_flight_schedule_rec.unit_schedule_id
537: ||' is invalid'
538: );

Line 570: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN

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: (
573: fnd_log.level_error,
574: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',

Line 571: fnd_log.string

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: (
573: fnd_log.level_error,
574: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
575: 'visit reschedule mode specified for '||p_x_flight_schedule_rec.unit_schedule_id

Line 573: fnd_log.level_error,

569: FND_MSG_PUB.ADD;
570: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
571: fnd_log.string
572: (
573: fnd_log.level_error,
574: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
575: 'visit reschedule mode specified for '||p_x_flight_schedule_rec.unit_schedule_id
576: ||' is invalid'
577: );

Line 600: FND_LOG.string(l_log_statement, l_full_name,

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,
601: 'Departure Space name ' || p_x_flight_schedule_rec.departure_space_name || ' is not valid.');
602: END IF;
603:
604: END IF;

Line 624: FND_LOG.string(l_log_statement, l_full_name,

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,
625: 'Arrival Space name ' || p_x_flight_schedule_rec.arrival_space_name || ' is not valid.');
626: END IF;
627: END IF;
628: CLOSE space_name_to_id_csr;

Line 631: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN

627: END IF;
628: CLOSE space_name_to_id_csr;
629: END IF;
630:
631: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
632: fnd_log.string
633: (
634: fnd_log.level_procedure,
635: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||'.end',

Line 632: fnd_log.string

628: CLOSE space_name_to_id_csr;
629: END IF;
630:
631: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
632: fnd_log.string
633: (
634: fnd_log.level_procedure,
635: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||'.end',
636: 'At the end of '||l_api_name

Line 634: fnd_log.level_procedure,

630:
631: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
632: fnd_log.string
633: (
634: fnd_log.level_procedure,
635: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||'.end',
636: 'At the end of '||l_api_name
637: );
638: END IF;

Line 662: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN

658: l_record_identifier VARCHAR2(150);
659:
660: BEGIN
661:
662: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
663: fnd_log.string
664: (
665: fnd_log.level_procedure,
666: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||'.begin',

Line 663: fnd_log.string

659:
660: BEGIN
661:
662: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
663: fnd_log.string
664: (
665: fnd_log.level_procedure,
666: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||'.begin',
667: 'At the start of '||l_api_name

Line 665: fnd_log.level_procedure,

661:
662: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
663: fnd_log.string
664: (
665: fnd_log.level_procedure,
666: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||'.begin',
667: 'At the start of '||l_api_name
668: );
669: END IF;

Line 796: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN

792: ELSIF (p_x_flight_schedule_rec.arrival_space_id = FND_API.G_MISS_NUM) THEN
793: p_x_flight_schedule_rec.arrival_space_id := NULL;
794: END IF;
795:
796: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
797: fnd_log.string
798: (
799: fnd_log.level_procedure,
800: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||'.end',

Line 797: fnd_log.string

793: p_x_flight_schedule_rec.arrival_space_id := NULL;
794: END IF;
795:
796: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
797: fnd_log.string
798: (
799: fnd_log.level_procedure,
800: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||'.end',
801: 'At the end of '||l_api_name

Line 799: fnd_log.level_procedure,

795:
796: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
797: fnd_log.string
798: (
799: fnd_log.level_procedure,
800: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||'.end',
801: 'At the end of '||l_api_name
802: );
803: END IF;

Line 826: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN

822: l_record_identifier VARCHAR2(150);
823:
824: BEGIN
825:
826: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
827: fnd_log.string
828: (
829: fnd_log.level_procedure,
830: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||'.begin',

Line 827: fnd_log.string

823:
824: BEGIN
825:
826: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
827: fnd_log.string
828: (
829: fnd_log.level_procedure,
830: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||'.begin',
831: 'At the start of '||l_api_name

Line 829: fnd_log.level_procedure,

825:
826: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
827: fnd_log.string
828: (
829: fnd_log.level_procedure,
830: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||'.begin',
831: 'At the start of '||l_api_name
832: );
833: END IF;

Line 851: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN

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: (
854: fnd_log.level_error,
855: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',

Line 852: fnd_log.string

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: (
854: fnd_log.level_error,
855: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
856: 'Unit Config Header id is a mandatory input field and cannot be null for '

Line 854: fnd_log.level_error,

850: FND_MSG_PUB.add;
851: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
852: fnd_log.string
853: (
854: fnd_log.level_error,
855: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
856: 'Unit Config Header id is a mandatory input field and cannot be null for '
857: ||p_flight_schedule_rec.unit_schedule_id
858: );

Line 872: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN

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: (
875: fnd_log.level_error,
876: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',

Line 873: fnd_log.string

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: (
875: fnd_log.level_error,
876: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
877: 'Flight Number cannot be null for '

Line 875: fnd_log.level_error,

871: FND_MSG_PUB.add;
872: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
873: fnd_log.string
874: (
875: fnd_log.level_error,
876: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
877: 'Flight Number cannot be null for '
878: ||p_flight_schedule_rec.unit_schedule_id
879: );

Line 894: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN

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: (
897: fnd_log.level_error,
898: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',

Line 895: fnd_log.string

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: (
897: fnd_log.level_error,
898: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
899: 'Segment cannot be null for '

Line 897: fnd_log.level_error,

893: FND_MSG_PUB.add;
894: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
895: fnd_log.string
896: (
897: fnd_log.level_error,
898: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
899: 'Segment cannot be null for '
900: ||p_flight_schedule_rec.unit_schedule_id
901: );

Line 916: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN

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: (
919: fnd_log.level_error,
920: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',

Line 917: fnd_log.string

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: (
919: fnd_log.level_error,
920: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
921: 'Departure_Dept_Id is a mandatory input field and cannot be null for '

Line 919: fnd_log.level_error,

915: FND_MSG_PUB.add;
916: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
917: fnd_log.string
918: (
919: fnd_log.level_error,
920: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
921: 'Departure_Dept_Id is a mandatory input field and cannot be null for '
922: ||p_flight_schedule_rec.unit_schedule_id
923: );

Line 937: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN

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: (
940: fnd_log.level_error,
941: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',

Line 938: fnd_log.string

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: (
940: fnd_log.level_error,
941: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
942: 'Departure_Org_Id is a mandatory input field and cannot be null for '

Line 940: fnd_log.level_error,

936: FND_MSG_PUB.add;
937: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
938: fnd_log.string
939: (
940: fnd_log.level_error,
941: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
942: 'Departure_Org_Id is a mandatory input field and cannot be null for '
943: ||p_flight_schedule_rec.unit_schedule_id
944: );

Line 958: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN

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: (
961: fnd_log.level_error,
962: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',

Line 959: fnd_log.string

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: (
961: fnd_log.level_error,
962: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
963: 'Arrival_Dept_Id is a mandatory input field and cannot be null for '

Line 961: fnd_log.level_error,

957: FND_MSG_PUB.add;
958: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
959: fnd_log.string
960: (
961: fnd_log.level_error,
962: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
963: 'Arrival_Dept_Id is a mandatory input field and cannot be null for '
964: ||p_flight_schedule_rec.unit_schedule_id
965: );

Line 979: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN

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: (
982: fnd_log.level_error,
983: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',

Line 980: fnd_log.string

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: (
982: fnd_log.level_error,
983: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
984: 'Arrival_Org_Id is a mandatory input field and cannot be null for '

Line 982: fnd_log.level_error,

978: FND_MSG_PUB.add;
979: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
980: fnd_log.string
981: (
982: fnd_log.level_error,
983: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
984: 'Arrival_Org_Id is a mandatory input field and cannot be null for '
985: ||p_flight_schedule_rec.unit_schedule_id
986: );

Line 1000: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN

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: (
1003: fnd_log.level_error,
1004: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',

Line 1001: fnd_log.string

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: (
1003: fnd_log.level_error,
1004: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1005: 'Est_Departure_Time is a mandatory input field and cannot be null for '

Line 1003: fnd_log.level_error,

999: FND_MSG_PUB.add;
1000: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1001: fnd_log.string
1002: (
1003: fnd_log.level_error,
1004: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1005: 'Est_Departure_Time is a mandatory input field and cannot be null for '
1006: ||p_flight_schedule_rec.unit_schedule_id
1007: );

Line 1021: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN

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: (
1024: fnd_log.level_error,
1025: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',

Line 1022: fnd_log.string

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: (
1024: fnd_log.level_error,
1025: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1026: 'Est_Arrival_Time is a mandatory input field and cannot be null for '

Line 1024: fnd_log.level_error,

1020: FND_MSG_PUB.add;
1021: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1022: fnd_log.string
1023: (
1024: fnd_log.level_error,
1025: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1026: 'Est_Arrival_Time is a mandatory input field and cannot be null for '
1027: ||p_flight_schedule_rec.unit_schedule_id
1028: );

Line 1042: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN

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: (
1045: fnd_log.level_error,
1046: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',

Line 1043: fnd_log.string

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: (
1045: fnd_log.level_error,
1046: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1047: 'Visit_Reschedule_Mode is a mandatory input field and cannot be null for '

Line 1045: fnd_log.level_error,

1041: FND_MSG_PUB.add;
1042: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1043: fnd_log.string
1044: (
1045: fnd_log.level_error,
1046: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1047: 'Visit_Reschedule_Mode is a mandatory input field and cannot be null for '
1048: ||p_flight_schedule_rec.unit_schedule_id
1049: );

Line 1055: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN

1051: x_return_status := FND_API.G_RET_STS_ERROR;
1052: --RAISE FND_API.G_EXC_ERROR;
1053: END IF;
1054:
1055: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
1056: fnd_log.string
1057: (
1058: fnd_log.level_procedure,
1059: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||'.end',

Line 1056: fnd_log.string

1052: --RAISE FND_API.G_EXC_ERROR;
1053: END IF;
1054:
1055: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
1056: fnd_log.string
1057: (
1058: fnd_log.level_procedure,
1059: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||'.end',
1060: 'At the end of '||l_api_name

Line 1058: fnd_log.level_procedure,

1054:
1055: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
1056: fnd_log.string
1057: (
1058: fnd_log.level_procedure,
1059: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||'.end',
1060: 'At the end of '||l_api_name
1061: );
1062: END IF;

Line 1088: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN

1084: l_record_identifier VARCHAR2(150);
1085:
1086: BEGIN
1087:
1088: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
1089: fnd_log.string
1090: (
1091: fnd_log.level_procedure,
1092: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||'.end',

Line 1089: fnd_log.string

1085:
1086: BEGIN
1087:
1088: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
1089: fnd_log.string
1090: (
1091: fnd_log.level_procedure,
1092: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||'.end',
1093: 'At the end of '||l_api_name

Line 1091: fnd_log.level_procedure,

1087:
1088: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
1089: fnd_log.string
1090: (
1091: fnd_log.level_procedure,
1092: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||'.end',
1093: 'At the end of '||l_api_name
1094: );
1095: END IF;

Line 1120: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN

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: (
1123: fnd_log.level_error,
1124: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',

Line 1121: fnd_log.string

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: (
1123: fnd_log.level_error,
1124: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1125: 'Flight schedule record not found for id '

Line 1123: fnd_log.level_error,

1119: FND_MSG_PUB.add;
1120: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1121: fnd_log.string
1122: (
1123: fnd_log.level_error,
1124: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1125: 'Flight schedule record not found for id '
1126: ||p_x_flight_schedule_rec.unit_schedule_id
1127: );

Line 1142: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN

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: (
1145: fnd_log.level_error,
1146: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',

Line 1143: fnd_log.string

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: (
1145: fnd_log.level_error,
1146: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1147: 'Unit config header id cannot be updated for '

Line 1145: fnd_log.level_error,

1141: FND_MSG_PUB.add;
1142: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1143: fnd_log.string
1144: (
1145: fnd_log.level_error,
1146: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1147: 'Unit config header id cannot be updated for '
1148: ||p_x_flight_schedule_rec.unit_schedule_id
1149: );

Line 1163: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN

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: (
1166: fnd_log.level_error,
1167: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',

Line 1164: fnd_log.string

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: (
1166: fnd_log.level_error,
1167: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1168: 'Flight Number cannot be updated for '

Line 1166: fnd_log.level_error,

1162: FND_MSG_PUB.add;
1163: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1164: fnd_log.string
1165: (
1166: fnd_log.level_error,
1167: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1168: 'Flight Number cannot be updated for '
1169: ||p_x_flight_schedule_rec.unit_schedule_id
1170: );

Line 1182: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN

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: (
1185: fnd_log.level_error,
1186: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',

Line 1183: fnd_log.string

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: (
1185: fnd_log.level_error,
1186: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1187: 'Flight Segment cannot be updated for '

Line 1185: fnd_log.level_error,

1181: FND_MSG_PUB.add;
1182: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1183: fnd_log.string
1184: (
1185: fnd_log.level_error,
1186: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1187: 'Flight Segment cannot be updated for '
1188: ||p_x_flight_schedule_rec.unit_schedule_id
1189: );

Line 1204: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN

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: (
1207: fnd_log.level_error,
1208: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',

Line 1205: fnd_log.string

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: (
1207: fnd_log.level_error,
1208: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1209: 'Departure deparment cannot be updated for '

Line 1207: fnd_log.level_error,

1203: FND_MSG_PUB.add;
1204: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1205: fnd_log.string
1206: (
1207: fnd_log.level_error,
1208: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1209: 'Departure deparment cannot be updated for '
1210: ||p_x_flight_schedule_rec.unit_schedule_id
1211: );

Line 1224: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN

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: (
1227: fnd_log.level_error,
1228: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',

Line 1225: fnd_log.string

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: (
1227: fnd_log.level_error,
1228: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1229: 'Departure org cannot be updated for '

Line 1227: fnd_log.level_error,

1223: FND_MSG_PUB.add;
1224: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1225: fnd_log.string
1226: (
1227: fnd_log.level_error,
1228: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1229: 'Departure org cannot be updated for '
1230: ||p_x_flight_schedule_rec.unit_schedule_id
1231: );

Line 1244: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN

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: (
1247: fnd_log.level_error,
1248: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',

Line 1245: fnd_log.string

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: (
1247: fnd_log.level_error,
1248: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1249: 'Arrival Department cannot be updated for'

Line 1247: fnd_log.level_error,

1243: FND_MSG_PUB.add;
1244: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1245: fnd_log.string
1246: (
1247: fnd_log.level_error,
1248: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1249: 'Arrival Department cannot be updated for'
1250: ||p_x_flight_schedule_rec.unit_schedule_id
1251: );

Line 1264: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN

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: (
1267: fnd_log.level_error,
1268: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',

Line 1265: fnd_log.string

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: (
1267: fnd_log.level_error,
1268: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1269: 'Arrival org cannot be updated for '

Line 1267: fnd_log.level_error,

1263: FND_MSG_PUB.add;
1264: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1265: fnd_log.string
1266: (
1267: fnd_log.level_error,
1268: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1269: 'Arrival org cannot be updated for '
1270: ||p_x_flight_schedule_rec.unit_schedule_id
1271: );

Line 1284: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN

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: (
1287: fnd_log.level_error,
1288: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',

Line 1285: fnd_log.string

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: (
1287: fnd_log.level_error,
1288: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1289: 'Estimated Departure time cannot be updated for '

Line 1287: fnd_log.level_error,

1283: FND_MSG_PUB.add;
1284: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1285: fnd_log.string
1286: (
1287: fnd_log.level_error,
1288: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1289: 'Estimated Departure time cannot be updated for '
1290: ||p_x_flight_schedule_rec.unit_schedule_id
1291: );

Line 1304: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN

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: (
1307: fnd_log.level_error,
1308: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',

Line 1305: fnd_log.string

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: (
1307: fnd_log.level_error,
1308: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1309: 'Estimated Arrival time cannot be updated for '

Line 1307: fnd_log.level_error,

1303: FND_MSG_PUB.add;
1304: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1305: fnd_log.string
1306: (
1307: fnd_log.level_error,
1308: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1309: 'Estimated Arrival time cannot be updated for '
1310: ||p_x_flight_schedule_rec.unit_schedule_id
1311: );

Line 1317: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN

1313: x_return_status := FND_API.G_RET_STS_ERROR;
1314: --RAISE FND_API.G_EXC_ERROR;
1315: END IF;
1316:
1317: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
1318: fnd_log.string
1319: (
1320: fnd_log.level_procedure,
1321: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||'.end',

Line 1318: fnd_log.string

1314: --RAISE FND_API.G_EXC_ERROR;
1315: END IF;
1316:
1317: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
1318: fnd_log.string
1319: (
1320: fnd_log.level_procedure,
1321: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||'.end',
1322: 'At the end of '||l_api_name

Line 1320: fnd_log.level_procedure,

1316:
1317: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
1318: fnd_log.string
1319: (
1320: fnd_log.level_procedure,
1321: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||'.end',
1322: 'At the end of '||l_api_name
1323: );
1324: END IF;

Line 1413: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN

1409: l_dummy VARCHAR2(1);
1410:
1411: BEGIN
1412:
1413: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
1414: fnd_log.string
1415: (
1416: fnd_log.level_procedure,
1417: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||'.begin',

Line 1414: fnd_log.string

1410:
1411: BEGIN
1412:
1413: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
1414: fnd_log.string
1415: (
1416: fnd_log.level_procedure,
1417: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||'.begin',
1418: 'At the start of '||l_api_name

Line 1416: fnd_log.level_procedure,

1412:
1413: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
1414: fnd_log.string
1415: (
1416: fnd_log.level_procedure,
1417: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||'.begin',
1418: 'At the start of '||l_api_name
1419: );
1420: END IF;

Line 1449: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN

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: (
1452: fnd_log.level_error,
1453: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',

Line 1450: fnd_log.string

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: (
1452: fnd_log.level_error,
1453: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1454: 'Actual times are entered for '||p_x_flight_schedule_rec.unit_schedule_id

Line 1452: fnd_log.level_error,

1448: FND_MSG_PUB.add;
1449: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1450: fnd_log.string
1451: (
1452: fnd_log.level_error,
1453: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1454: 'Actual times are entered for '||p_x_flight_schedule_rec.unit_schedule_id
1455: ||'so delete not allowed'
1456: );

Line 1477: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)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: (
1480: fnd_log.level_error,
1481: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',

Line 1478: fnd_log.string

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: (
1480: fnd_log.level_error,
1481: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1482: 'Duplicates flight schedules found for ,'

Line 1480: fnd_log.level_error,

1476: FND_MSG_PUB.add;
1477: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1478: fnd_log.string
1479: (
1480: fnd_log.level_error,
1481: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1482: 'Duplicates flight schedules found for ,'
1483: ||p_x_flight_schedule_rec.unit_schedule_id
1484: );

Line 1504: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN

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: (
1507: fnd_log.level_error,
1508: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',

Line 1505: fnd_log.string

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: (
1507: fnd_log.level_error,
1508: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1509: 'Actuals Arrival time cannot be entered until departure time is entered '||p_x_flight_schedule_rec.unit_schedule_id

Line 1507: fnd_log.level_error,

1503: FND_MSG_PUB.add;
1504: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1505: fnd_log.string
1506: (
1507: fnd_log.level_error,
1508: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1509: 'Actuals Arrival time cannot be entered until departure time is entered '||p_x_flight_schedule_rec.unit_schedule_id
1510: );
1511: END IF;

Line 1531: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN

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: (
1534: fnd_log.level_error,
1535: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',

Line 1532: fnd_log.string

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: (
1534: fnd_log.level_error,
1535: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1536: 'Actuals cannot be greater than sysdate for '||p_x_flight_schedule_rec.unit_schedule_id

Line 1534: fnd_log.level_error,

1530: FND_MSG_PUB.add;
1531: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1532: fnd_log.string
1533: (
1534: fnd_log.level_error,
1535: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1536: 'Actuals cannot be greater than sysdate for '||p_x_flight_schedule_rec.unit_schedule_id
1537: );
1538: END IF;

Line 1553: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN

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: (
1556: fnd_log.level_error,
1557: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',

Line 1554: fnd_log.string

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: (
1556: fnd_log.level_error,
1557: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1558: 'Estimated Departure cannot be greater than arrival for '

Line 1556: fnd_log.level_error,

1552: FND_MSG_PUB.add;
1553: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1554: fnd_log.string
1555: (
1556: fnd_log.level_error,
1557: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1558: 'Estimated Departure cannot be greater than arrival for '
1559: ||p_x_flight_schedule_rec.unit_schedule_id
1560: );

Line 1576: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN

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: (
1579: fnd_log.level_error,
1580: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',

Line 1577: fnd_log.string

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: (
1579: fnd_log.level_error,
1580: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1581: 'Actual Departure cannot be greater than arrival for '

Line 1579: fnd_log.level_error,

1575: FND_MSG_PUB.add;
1576: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1577: fnd_log.string
1578: (
1579: fnd_log.level_error,
1580: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1581: 'Actual Departure cannot be greater than arrival for '
1582: ||p_x_flight_schedule_rec.unit_schedule_id
1583: );

Line 1631: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN

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: (
1634: fnd_log.level_error,
1635: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',

Line 1632: fnd_log.string

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: (
1634: fnd_log.level_error,
1635: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1636: 'previous actuals are not entered for '||p_x_flight_schedule_rec.unit_schedule_id

Line 1634: fnd_log.level_error,

1630: FND_MSG_PUB.add;
1631: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1632: fnd_log.string
1633: (
1634: fnd_log.level_error,
1635: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1636: 'previous actuals are not entered for '||p_x_flight_schedule_rec.unit_schedule_id
1637: );
1638: END IF;

Line 1658: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN

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: (
1661: fnd_log.level_error,
1662: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',

Line 1659: fnd_log.string

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: (
1661: fnd_log.level_error,
1662: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1663: 'estimated arrival time violates another flight'||

Line 1661: fnd_log.level_error,

1657: FND_MSG_PUB.add;
1658: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1659: fnd_log.string
1660: (
1661: fnd_log.level_error,
1662: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1663: 'estimated arrival time violates another flight'||
1664: 'schedules estimated arrival time for '||p_x_flight_schedule_rec.unit_schedule_id
1665: );

Line 1687: FND_LOG.string(l_log_statement, l_full_name,

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,
1688: 'Departure Space id ' || p_x_flight_schedule_rec.departure_space_id || ' is not valid.');
1689: END IF;
1690: END IF;
1691: CLOSE validate_space_id_csr;

Line 1711: FND_LOG.string(l_log_statement, l_full_name,

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,
1712: 'Arrival Space id ' || p_x_flight_schedule_rec.arrival_space_id || ' is not valid.');
1713: END IF;
1714: END IF;
1715: CLOSE validate_space_id_csr;

Line 1720: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN

1716:
1717: END IF;
1718:
1719: END IF;
1720: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
1721: fnd_log.string
1722: (
1723: fnd_log.level_procedure,
1724: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||'.end',

Line 1721: fnd_log.string

1717: END IF;
1718:
1719: END IF;
1720: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
1721: fnd_log.string
1722: (
1723: fnd_log.level_procedure,
1724: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||'.end',
1725: 'At the end of '||l_api_name

Line 1723: fnd_log.level_procedure,

1719: END IF;
1720: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
1721: fnd_log.string
1722: (
1723: fnd_log.level_procedure,
1724: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||'.end',
1725: 'At the end of '||l_api_name
1726: );
1727: END IF;

Line 1804: FND_LOG.string(l_log_procedure, l_full_name || '.begin', 'At the start of the API');

1800: --
1801: BEGIN
1802:
1803: IF (l_log_procedure >= l_log_current_level) THEN
1804: FND_LOG.string(l_log_procedure, l_full_name || '.begin', 'At the start of the API');
1805: END IF;
1806:
1807: -- Initialize Procedure return status to success
1808: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1843: FND_LOG.string(l_log_statement, l_full_name, 'Invoking AHL_AVF_OPER_VSTS_PVT.Launch_Visit_Dur_Notification API for visit ids: ' || l_visit_rec.visit_id);

1839: CLOSE chk_planned_mrs_csr;
1840:
1841: IF (l_vst_contain_planned_mrs = 'Y') THEN
1842: IF (l_log_statement >= l_log_current_level) THEN
1843: FND_LOG.string(l_log_statement, l_full_name, 'Invoking AHL_AVF_OPER_VSTS_PVT.Launch_Visit_Dur_Notification API for visit ids: ' || l_visit_rec.visit_id);
1844: END IF;
1845:
1846: AHL_AVF_OPER_VSTS_PVT.Launch_Visit_Dur_Notification(
1847: p_unit_schedule_id => p_flight_schedule_rec.preceding_us_id,

Line 1855: FND_LOG.string(l_log_statement, l_full_name, 'After call to AHL_AVF_OPER_VSTS_PVT.Launch_Visit_Dur_Notification API, Return Status: ' || x_return_status);

1851: x_return_status => x_return_status
1852: );
1853:
1854: IF (l_log_statement >= l_log_current_level) THEN
1855: FND_LOG.string(l_log_statement, l_full_name, 'After call to AHL_AVF_OPER_VSTS_PVT.Launch_Visit_Dur_Notification API, Return Status: ' || x_return_status);
1856: END IF;
1857: END IF;
1858:
1859: END IF;

Line 1893: FND_LOG.string(l_log_statement, l_full_name, 'Invoking AHL_AVF_OPER_VSTS_PVT.Launch_Visit_Dur_Notification API for visit ids: ' || l_visit_rec.visit_id);

1889: CLOSE chk_planned_mrs_csr;
1890:
1891: IF (l_vst_contain_planned_mrs = 'Y') THEN
1892: IF (l_log_statement >= l_log_current_level) THEN
1893: FND_LOG.string(l_log_statement, l_full_name, 'Invoking AHL_AVF_OPER_VSTS_PVT.Launch_Visit_Dur_Notification API for visit ids: ' || l_visit_rec.visit_id);
1894: END IF;
1895:
1896: AHL_AVF_OPER_VSTS_PVT.Launch_Visit_Dur_Notification(
1897: p_unit_schedule_id => p_flight_schedule_rec.unit_schedule_id,

Line 1905: FND_LOG.string(l_log_statement, l_full_name, 'After call to AHL_AVF_OPER_VSTS_PVT.Launch_Visit_Dur_Notification API, Return Status: ' || x_return_status);

1901: x_return_status => x_return_status
1902: );
1903:
1904: IF (l_log_statement >= l_log_current_level) THEN
1905: FND_LOG.string(l_log_statement, l_full_name, 'After call to AHL_AVF_OPER_VSTS_PVT.Launch_Visit_Dur_Notification API, Return Status: ' || x_return_status);
1906: END IF;
1907: END IF;
1908:
1909: END IF;

Line 1919: FND_LOG.string(l_log_procedure, l_full_name || '.end', 'At the end of the API');

1915:
1916: END IF; -- Succeeding Flight Schedule
1917:
1918: IF (l_log_procedure >= l_log_current_level) THEN
1919: FND_LOG.string(l_log_procedure, l_full_name || '.end', 'At the end of the API');
1920: END IF;
1921:
1922: END Invoke_Visit_Dur_Notification;
1923:

Line 2046: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN

2042: -- Initialize the return status to success.
2043:
2044: x_return_status := FND_API.G_RET_STS_SUCCESS;
2045:
2046: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
2047: fnd_log.string
2048: (
2049: fnd_log.level_procedure,
2050: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||'.begin',

Line 2047: fnd_log.string

2043:
2044: x_return_status := FND_API.G_RET_STS_SUCCESS;
2045:
2046: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
2047: fnd_log.string
2048: (
2049: fnd_log.level_procedure,
2050: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||'.begin',
2051: 'At the start of '||l_api_name

Line 2049: fnd_log.level_procedure,

2045:
2046: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
2047: fnd_log.string
2048: (
2049: fnd_log.level_procedure,
2050: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||'.begin',
2051: 'At the start of '||l_api_name
2052: );
2053: END IF;

Line 2075: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

2071: l_visit_tbl(l_visit_count).visit_id := l_flight_visit.visit_id;
2072: l_visit_tbl(l_visit_count).object_version_number := l_flight_visit.object_version_number;
2073: l_visit_tbl(l_visit_count).start_date := l_flight_visit.start_date_time + l_time_diff;
2074:
2075: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2076: fnd_log.string
2077: (
2078: fnd_log.level_statement,
2079: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,

Line 2076: fnd_log.string

2072: l_visit_tbl(l_visit_count).object_version_number := l_flight_visit.object_version_number;
2073: l_visit_tbl(l_visit_count).start_date := l_flight_visit.start_date_time + l_time_diff;
2074:
2075: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2076: fnd_log.string
2077: (
2078: fnd_log.level_statement,
2079: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
2080: ' changed arrival time ' || p_visit_sync_rec.CHANGED_ARRIVAL_TIME ||

Line 2078: fnd_log.level_statement,

2074:
2075: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2076: fnd_log.string
2077: (
2078: fnd_log.level_statement,
2079: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
2080: ' changed arrival time ' || p_visit_sync_rec.CHANGED_ARRIVAL_TIME ||
2081: ' changed org id ' || TO_CHAR(p_visit_sync_rec.CHANGED_ORG_ID) ||
2082: ' changed dept id ' || TO_CHAR(p_visit_sync_rec.CHANGED_DEPT_ID )

Line 2146: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN

2142:
2143: -- Bug # 9075539 -- start
2144: -- If any severe error occurs, then, abort API.
2145: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2146: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN
2147: fnd_log.string
2148: (
2149: fnd_log.level_exception,
2150: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,

Line 2147: fnd_log.string

2143: -- Bug # 9075539 -- start
2144: -- If any severe error occurs, then, abort API.
2145: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2146: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN
2147: fnd_log.string
2148: (
2149: fnd_log.level_exception,
2150: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
2151: 'AHL_VWP_VISITS_PVT.Process_Visit returned with expected error..'

Line 2149: fnd_log.level_exception,

2145: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2146: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN
2147: fnd_log.string
2148: (
2149: fnd_log.level_exception,
2150: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
2151: 'AHL_VWP_VISITS_PVT.Process_Visit returned with expected error..'
2152: );
2153: END IF;

Line 2158: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN

2154: -- fix for bug 13866936
2155: -- RAISE FND_API.G_EXC_ERROR;
2156: x_return_status := 'V';-- status assigned to force flight schedule updates
2157: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2158: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN
2159: fnd_log.string
2160: (
2161: fnd_log.level_exception,
2162: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,

Line 2159: fnd_log.string

2155: -- RAISE FND_API.G_EXC_ERROR;
2156: x_return_status := 'V';-- status assigned to force flight schedule updates
2157: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2158: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN
2159: fnd_log.string
2160: (
2161: fnd_log.level_exception,
2162: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
2163: 'AHL_VWP_VISITS_PVT.Process_Visit returned with un-expected error..'

Line 2161: fnd_log.level_exception,

2157: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2158: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN
2159: fnd_log.string
2160: (
2161: fnd_log.level_exception,
2162: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
2163: 'AHL_VWP_VISITS_PVT.Process_Visit returned with un-expected error..'
2164: );
2165: END IF;

Line 2170: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN

2166: -- fix for bug 13866936
2167: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2168: x_return_status := 'V';-- status assigned to force flight schedule updates
2169: ELSIF x_return_status = 'V' THEN
2170: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN
2171: fnd_log.string
2172: (
2173: fnd_log.level_exception,
2174: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,

Line 2171: fnd_log.string

2167: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2168: x_return_status := 'V';-- status assigned to force flight schedule updates
2169: ELSIF x_return_status = 'V' THEN
2170: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN
2171: fnd_log.string
2172: (
2173: fnd_log.level_exception,
2174: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
2175: 'Visit could not be deleted or cancelled...Please refer error stack for more details..'

Line 2173: fnd_log.level_exception,

2169: ELSIF x_return_status = 'V' THEN
2170: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN
2171: fnd_log.string
2172: (
2173: fnd_log.level_exception,
2174: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
2175: 'Visit could not be deleted or cancelled...Please refer error stack for more details..'
2176: );
2177: END IF;

Line 2183: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN

2179: -- Bug # 9075539 -- end
2180:
2181: END IF;
2182:
2183: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
2184: fnd_log.string
2185: (
2186: fnd_log.level_procedure,
2187: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||'.end',

Line 2184: fnd_log.string

2180:
2181: END IF;
2182:
2183: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
2184: fnd_log.string
2185: (
2186: fnd_log.level_procedure,
2187: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||'.end',
2188: 'At the end of '||l_api_name

Line 2186: fnd_log.level_procedure,

2182:
2183: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
2184: fnd_log.string
2185: (
2186: fnd_log.level_procedure,
2187: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||'.end',
2188: 'At the end of '||l_api_name
2189: );
2190: END IF;

Line 2244: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

2240: LOOP
2241: IF p_x_flight_schedules_tbl(i).DML_OPERATION = 'C'
2242: THEN
2243: -- Validate all attributes (Item level validation)
2244: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2245: fnd_log.string
2246: (
2247: fnd_log.level_statement,
2248: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',

Line 2245: fnd_log.string

2241: IF p_x_flight_schedules_tbl(i).DML_OPERATION = 'C'
2242: THEN
2243: -- Validate all attributes (Item level validation)
2244: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2245: fnd_log.string
2246: (
2247: fnd_log.level_statement,
2248: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
2249: 'Validate attributes before creating flight schedules...'

Line 2247: fnd_log.level_statement,

2243: -- Validate all attributes (Item level validation)
2244: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2245: fnd_log.string
2246: (
2247: fnd_log.level_statement,
2248: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
2249: 'Validate attributes before creating flight schedules...'
2250: );
2251: END IF;

Line 2259: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

2255: p_x_flight_schedules_tbl(i),
2256: x_return_status
2257: );
2258:
2259: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2260: fnd_log.string
2261: (
2262: fnd_log.level_statement,
2263: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',

Line 2260: fnd_log.string

2256: x_return_status
2257: );
2258:
2259: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2260: fnd_log.string
2261: (
2262: fnd_log.level_statement,
2263: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
2264: 'p_x_flight_schedules_tbl('||i||').DML_OPERATION : ' || p_x_flight_schedules_tbl(i).DML_OPERATION

Line 2262: fnd_log.level_statement,

2258:
2259: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2260: fnd_log.string
2261: (
2262: fnd_log.level_statement,
2263: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
2264: 'p_x_flight_schedules_tbl('||i||').DML_OPERATION : ' || p_x_flight_schedules_tbl(i).DML_OPERATION
2265: );
2266: END IF;

Line 2269: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

2265: );
2266: END IF;
2267:
2268: -- Convert Values to Ids.
2269: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2270: fnd_log.string
2271: (
2272: fnd_log.level_statement,
2273: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',

Line 2270: fnd_log.string

2266: END IF;
2267:
2268: -- Convert Values to Ids.
2269: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2270: fnd_log.string
2271: (
2272: fnd_log.level_statement,
2273: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
2274: 'Calling convert_values_to_ids..'

Line 2272: fnd_log.level_statement,

2268: -- Convert Values to Ids.
2269: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2270: fnd_log.string
2271: (
2272: fnd_log.level_statement,
2273: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
2274: 'Calling convert_values_to_ids..'
2275: );
2276: END IF;

Line 2288: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN

2284: );
2285:
2286: -- If any severe error occurs, then, abort API.
2287: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2288: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN
2289: fnd_log.string
2290: (
2291: fnd_log.level_exception,
2292: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,

Line 2289: fnd_log.string

2285:
2286: -- If any severe error occurs, then, abort API.
2287: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2288: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN
2289: fnd_log.string
2290: (
2291: fnd_log.level_exception,
2292: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
2293: 'convert_values_to_ids returned with expected error..'

Line 2291: fnd_log.level_exception,

2287: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2288: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN
2289: fnd_log.string
2290: (
2291: fnd_log.level_exception,
2292: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
2293: 'convert_values_to_ids returned with expected error..'
2294: );
2295: END IF;

Line 2298: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN

2294: );
2295: END IF;
2296: RAISE FND_API.G_EXC_ERROR;
2297: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2298: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN
2299: fnd_log.string
2300: (
2301: fnd_log.level_exception,
2302: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,

Line 2299: fnd_log.string

2295: END IF;
2296: RAISE FND_API.G_EXC_ERROR;
2297: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2298: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN
2299: fnd_log.string
2300: (
2301: fnd_log.level_exception,
2302: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
2303: 'convert_values_to_ids returned with un-expected error..'

Line 2301: fnd_log.level_exception,

2297: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2298: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN
2299: fnd_log.string
2300: (
2301: fnd_log.level_exception,
2302: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
2303: 'convert_values_to_ids returned with un-expected error..'
2304: );
2305: END IF;

Line 2311: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

2307: END IF;-- return status
2308: END IF;-- module type
2309:
2310:
2311: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2312: fnd_log.string
2313: (
2314: fnd_log.level_statement,
2315: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',

Line 2312: fnd_log.string

2308: END IF;-- module type
2309:
2310:
2311: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2312: fnd_log.string
2313: (
2314: fnd_log.level_statement,
2315: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
2316: 'call validate_mandatory_inputs to check all missing mandatory fields'

Line 2314: fnd_log.level_statement,

2310:
2311: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2312: fnd_log.string
2313: (
2314: fnd_log.level_statement,
2315: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
2316: 'call validate_mandatory_inputs to check all missing mandatory fields'
2317: );
2318: END IF;

Line 2328: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN

2324: );
2325:
2326: -- If any severe error occurs, then, abort API.
2327: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2328: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN
2329: fnd_log.string
2330: (
2331: fnd_log.level_exception,
2332: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,

Line 2329: fnd_log.string

2325:
2326: -- If any severe error occurs, then, abort API.
2327: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2328: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN
2329: fnd_log.string
2330: (
2331: fnd_log.level_exception,
2332: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
2333: 'validate_mandatory_fields returned with expected error..'

Line 2331: fnd_log.level_exception,

2327: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2328: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN
2329: fnd_log.string
2330: (
2331: fnd_log.level_exception,
2332: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
2333: 'validate_mandatory_fields returned with expected error..'
2334: );
2335: END IF;

Line 2338: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN

2334: );
2335: END IF;
2336: RAISE FND_API.G_EXC_ERROR;
2337: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2338: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN
2339: fnd_log.string
2340: (
2341: fnd_log.level_exception,
2342: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,

Line 2339: fnd_log.string

2335: END IF;
2336: RAISE FND_API.G_EXC_ERROR;
2337: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2338: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN
2339: fnd_log.string
2340: (
2341: fnd_log.level_exception,
2342: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
2343: 'validate_mandatory_fields returned with un-expected error..'

Line 2341: fnd_log.level_exception,

2337: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2338: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN
2339: fnd_log.string
2340: (
2341: fnd_log.level_exception,
2342: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
2343: 'validate_mandatory_fields returned with un-expected error..'
2344: );
2345: END IF;

Line 2349: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

2345: END IF;
2346: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2347: END IF;
2348:
2349: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2350: fnd_log.string
2351: (
2352: fnd_log.level_statement,
2353: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',

Line 2350: fnd_log.string

2346: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2347: END IF;
2348:
2349: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2350: fnd_log.string
2351: (
2352: fnd_log.level_statement,
2353: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
2354: 'Validate all records before DML '

Line 2352: fnd_log.level_statement,

2348:
2349: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2350: fnd_log.string
2351: (
2352: fnd_log.level_statement,
2353: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
2354: 'Validate all records before DML '
2355: );
2356: END IF;

Line 2366: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN

2362: );
2363:
2364: -- If any severe error occurs, then, abort API.
2365: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2366: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN
2367: fnd_log.string
2368: (
2369: fnd_log.level_exception,
2370: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,

Line 2367: fnd_log.string

2363:
2364: -- If any severe error occurs, then, abort API.
2365: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2366: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN
2367: fnd_log.string
2368: (
2369: fnd_log.level_exception,
2370: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
2371: 'validate_record returned with expected error..'

Line 2369: fnd_log.level_exception,

2365: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2366: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN
2367: fnd_log.string
2368: (
2369: fnd_log.level_exception,
2370: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
2371: 'validate_record returned with expected error..'
2372: );
2373: END IF;

Line 2376: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN

2372: );
2373: END IF;
2374: RAISE FND_API.G_EXC_ERROR;
2375: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2376: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN
2377: fnd_log.string
2378: (
2379: fnd_log.level_exception,
2380: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,

Line 2377: fnd_log.string

2373: END IF;
2374: RAISE FND_API.G_EXC_ERROR;
2375: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2376: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN
2377: fnd_log.string
2378: (
2379: fnd_log.level_exception,
2380: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
2381: 'validate_record returned with un-expected error..'

Line 2379: fnd_log.level_exception,

2375: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2376: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN
2377: fnd_log.string
2378: (
2379: fnd_log.level_exception,
2380: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
2381: 'validate_record returned with un-expected error..'
2382: );
2383: END IF;

Line 2393: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

2389: * This signifies that a Visit corresponding to this Flight record is yet to be created.
2390: */
2391: l_autovisit_process_status := 'C';
2392:
2393: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2394: fnd_log.string
2395: (
2396: fnd_log.level_statement,
2397: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',

Line 2394: fnd_log.string

2390: */
2391: l_autovisit_process_status := 'C';
2392:
2393: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2394: fnd_log.string
2395: (
2396: fnd_log.level_statement,
2397: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
2398: 'Creating new Flight scehdule ..'

Line 2396: fnd_log.level_statement,

2392:
2393: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2394: fnd_log.string
2395: (
2396: fnd_log.level_statement,
2397: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
2398: 'Creating new Flight scehdule ..'
2399: );
2400: END IF;

Line 2546: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN

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,
2550: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',

Line 2547: fnd_log.string

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,
2550: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
2551: 'Overlap in flight times specified,'||

Line 2549: fnd_log.level_error,

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,
2550: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
2551: 'Overlap in flight times specified,'||
2552: 'this is a warning and not a error for '||p_x_flight_schedules_tbl(i).unit_schedule_id
2553: );

Line 2604: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

2600: LOOP
2601: IF ( p_x_flight_schedules_tbl(i).DML_OPERATION = 'U' )
2602: THEN
2603: -- Validate all attributes (Item level validation)
2604: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2605: fnd_log.string
2606: (
2607: fnd_log.level_statement,
2608: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',

Line 2605: fnd_log.string

2601: IF ( p_x_flight_schedules_tbl(i).DML_OPERATION = 'U' )
2602: THEN
2603: -- Validate all attributes (Item level validation)
2604: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2605: fnd_log.string
2606: (
2607: fnd_log.level_statement,
2608: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
2609: 'Validate attributes before creating flight schedules...'

Line 2607: fnd_log.level_statement,

2603: -- Validate all attributes (Item level validation)
2604: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2605: fnd_log.string
2606: (
2607: fnd_log.level_statement,
2608: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
2609: 'Validate attributes before creating flight schedules...'
2610: );
2611: END IF;

Line 2619: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

2615: p_x_flight_schedules_tbl(i),
2616: x_return_status
2617: );
2618:
2619: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2620: fnd_log.string
2621: (
2622: fnd_log.level_statement,
2623: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',

Line 2620: fnd_log.string

2616: x_return_status
2617: );
2618:
2619: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2620: fnd_log.string
2621: (
2622: fnd_log.level_statement,
2623: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
2624: 'p_x_flight_schedules_tbl('||i||').DML_OPERATION : ' || p_x_flight_schedules_tbl(i).DML_OPERATION

Line 2622: fnd_log.level_statement,

2618:
2619: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2620: fnd_log.string
2621: (
2622: fnd_log.level_statement,
2623: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
2624: 'p_x_flight_schedules_tbl('||i||').DML_OPERATION : ' || p_x_flight_schedules_tbl(i).DML_OPERATION
2625: );
2626: END IF;

Line 2628: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

2624: 'p_x_flight_schedules_tbl('||i||').DML_OPERATION : ' || p_x_flight_schedules_tbl(i).DML_OPERATION
2625: );
2626: END IF;
2627:
2628: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2629: fnd_log.string
2630: (
2631: fnd_log.level_statement,
2632: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',

Line 2629: fnd_log.string

2625: );
2626: END IF;
2627:
2628: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2629: fnd_log.string
2630: (
2631: fnd_log.level_statement,
2632: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
2633: 'Calling convert_values_to_ids..'

Line 2631: fnd_log.level_statement,

2627:
2628: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2629: fnd_log.string
2630: (
2631: fnd_log.level_statement,
2632: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
2633: 'Calling convert_values_to_ids..'
2634: );
2635: END IF;

Line 2647: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN

2643: );
2644:
2645: -- If any severe error occurs, then, abort API.
2646: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2647: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN
2648: fnd_log.string
2649: (
2650: fnd_log.level_exception,
2651: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,

Line 2648: fnd_log.string

2644:
2645: -- If any severe error occurs, then, abort API.
2646: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2647: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN
2648: fnd_log.string
2649: (
2650: fnd_log.level_exception,
2651: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
2652: 'convert_values_to_ids returned with expected error..'

Line 2650: fnd_log.level_exception,

2646: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2647: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN
2648: fnd_log.string
2649: (
2650: fnd_log.level_exception,
2651: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
2652: 'convert_values_to_ids returned with expected error..'
2653: );
2654: END IF;

Line 2657: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN

2653: );
2654: END IF;
2655: RAISE FND_API.G_EXC_ERROR;
2656: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2657: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN
2658: fnd_log.string
2659: (
2660: fnd_log.level_exception,
2661: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,

Line 2658: fnd_log.string

2654: END IF;
2655: RAISE FND_API.G_EXC_ERROR;
2656: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2657: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN
2658: fnd_log.string
2659: (
2660: fnd_log.level_exception,
2661: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
2662: 'convert_values_to_ids returned with un-expected error..'

Line 2660: fnd_log.level_exception,

2656: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2657: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN
2658: fnd_log.string
2659: (
2660: fnd_log.level_exception,
2661: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
2662: 'convert_values_to_ids returned with un-expected error..'
2663: );
2664: END IF;

Line 2672: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

2668:
2669: -- Default missing and unchanged attributes.
2670: IF ( p_module_type <> 'OAF' )
2671: THEN
2672: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2673: fnd_log.string
2674: (
2675: fnd_log.level_statement,
2676: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',

Line 2673: fnd_log.string

2669: -- Default missing and unchanged attributes.
2670: IF ( p_module_type <> 'OAF' )
2671: THEN
2672: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2673: fnd_log.string
2674: (
2675: fnd_log.level_statement,
2676: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
2677: 'default_unchanged_attributes for update operation. Module type is '||p_module_type

Line 2675: fnd_log.level_statement,

2671: THEN
2672: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2673: fnd_log.string
2674: (
2675: fnd_log.level_statement,
2676: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
2677: 'default_unchanged_attributes for update operation. Module type is '||p_module_type
2678: );
2679: END IF;

Line 2686: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

2682: (
2683: p_x_flight_schedule_rec => p_x_flight_schedules_tbl(i)
2684: );
2685:
2686: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2687: fnd_log.string
2688: (
2689: fnd_log.level_statement,
2690: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',

Line 2687: fnd_log.string

2683: p_x_flight_schedule_rec => p_x_flight_schedules_tbl(i)
2684: );
2685:
2686: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2687: fnd_log.string
2688: (
2689: fnd_log.level_statement,
2690: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
2691: 'call validate_mandatory_inputs to check all missing mandatory fields'

Line 2689: fnd_log.level_statement,

2685:
2686: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2687: fnd_log.string
2688: (
2689: fnd_log.level_statement,
2690: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
2691: 'call validate_mandatory_inputs to check all missing mandatory fields'
2692: );
2693: END IF;

Line 2704: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN

2700: );
2701:
2702: -- If any severe error occurs, then, abort API.
2703: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2704: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN
2705: fnd_log.string
2706: (
2707: fnd_log.level_exception,
2708: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,

Line 2705: fnd_log.string

2701:
2702: -- If any severe error occurs, then, abort API.
2703: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2704: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN
2705: fnd_log.string
2706: (
2707: fnd_log.level_exception,
2708: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
2709: 'validate_mandatory_fields returned with expected error..'

Line 2707: fnd_log.level_exception,

2703: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2704: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN
2705: fnd_log.string
2706: (
2707: fnd_log.level_exception,
2708: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
2709: 'validate_mandatory_fields returned with expected error..'
2710: );
2711: END IF;

Line 2714: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN

2710: );
2711: END IF;
2712: RAISE FND_API.G_EXC_ERROR;
2713: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2714: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN
2715: fnd_log.string
2716: (
2717: fnd_log.level_exception,
2718: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,

Line 2715: fnd_log.string

2711: END IF;
2712: RAISE FND_API.G_EXC_ERROR;
2713: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2714: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN
2715: fnd_log.string
2716: (
2717: fnd_log.level_exception,
2718: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
2719: 'validate_mandatory_fields returned with un-expected error..'

Line 2717: fnd_log.level_exception,

2713: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2714: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN
2715: fnd_log.string
2716: (
2717: fnd_log.level_exception,
2718: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
2719: 'validate_mandatory_fields returned with un-expected error..'
2720: );
2721: END IF;

Line 2726: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

2722: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2723: END IF; -- return status
2724:
2725:
2726: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2727: THEN
2728: fnd_log.string
2729: (
2730: fnd_log.level_statement,

Line 2728: fnd_log.string

2724:
2725:
2726: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2727: THEN
2728: fnd_log.string
2729: (
2730: fnd_log.level_statement,
2731: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
2732: 'Validate all records before DML '

Line 2730: fnd_log.level_statement,

2726: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2727: THEN
2728: fnd_log.string
2729: (
2730: fnd_log.level_statement,
2731: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
2732: 'Validate all records before DML '
2733: );
2734: END IF;

Line 2744: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN

2740: );
2741:
2742: -- If any severe error occurs, then, abort API.
2743: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2744: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN
2745: fnd_log.string
2746: (
2747: fnd_log.level_exception,
2748: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,

Line 2745: fnd_log.string

2741:
2742: -- If any severe error occurs, then, abort API.
2743: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2744: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN
2745: fnd_log.string
2746: (
2747: fnd_log.level_exception,
2748: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
2749: 'validate_update returned with expected error..'

Line 2747: fnd_log.level_exception,

2743: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2744: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN
2745: fnd_log.string
2746: (
2747: fnd_log.level_exception,
2748: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
2749: 'validate_update returned with expected error..'
2750: );
2751: END IF;

Line 2754: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN

2750: );
2751: END IF;
2752: RAISE FND_API.G_EXC_ERROR;
2753: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2754: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN
2755: fnd_log.string
2756: (
2757: fnd_log.level_exception,
2758: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,

Line 2755: fnd_log.string

2751: END IF;
2752: RAISE FND_API.G_EXC_ERROR;
2753: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2754: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN
2755: fnd_log.string
2756: (
2757: fnd_log.level_exception,
2758: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
2759: 'validate_update returned with un-expected error..'

Line 2757: fnd_log.level_exception,

2753: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2754: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN
2755: fnd_log.string
2756: (
2757: fnd_log.level_exception,
2758: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
2759: 'validate_update returned with un-expected error..'
2760: );
2761: END IF;

Line 2765: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

2761: END IF;
2762: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2763: END IF;
2764:
2765: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2766: fnd_log.string
2767: (
2768: fnd_log.level_statement,
2769: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',

Line 2766: fnd_log.string

2762: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2763: END IF;
2764:
2765: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2766: fnd_log.string
2767: (
2768: fnd_log.level_statement,
2769: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
2770: 'Validate all records before DML '

Line 2768: fnd_log.level_statement,

2764:
2765: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2766: fnd_log.string
2767: (
2768: fnd_log.level_statement,
2769: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
2770: 'Validate all records before DML '
2771: );
2772: END IF;

Line 2782: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN

2778: );
2779:
2780: -- If any severe error occurs, then, abort API.
2781: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2782: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN
2783: fnd_log.string
2784: (
2785: fnd_log.level_exception,
2786: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,

Line 2783: fnd_log.string

2779:
2780: -- If any severe error occurs, then, abort API.
2781: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2782: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN
2783: fnd_log.string
2784: (
2785: fnd_log.level_exception,
2786: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
2787: 'validate_record returned with expected error..'

Line 2785: fnd_log.level_exception,

2781: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2782: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN
2783: fnd_log.string
2784: (
2785: fnd_log.level_exception,
2786: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
2787: 'validate_record returned with expected error..'
2788: );
2789: END IF;

Line 2792: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN

2788: );
2789: END IF;
2790: RAISE FND_API.G_EXC_ERROR;
2791: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2792: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN
2793: fnd_log.string
2794: (
2795: fnd_log.level_exception,
2796: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,

Line 2793: fnd_log.string

2789: END IF;
2790: RAISE FND_API.G_EXC_ERROR;
2791: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2792: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN
2793: fnd_log.string
2794: (
2795: fnd_log.level_exception,
2796: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
2797: 'validate_record returned with un-expected error..'

Line 2795: fnd_log.level_exception,

2791: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2792: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN
2793: fnd_log.string
2794: (
2795: fnd_log.level_exception,
2796: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
2797: 'validate_record returned with un-expected error..'
2798: );
2799: END IF;

Line 2803: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

2799: END IF;
2800: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2801: END IF;
2802:
2803: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2804: fnd_log.string
2805: (
2806: fnd_log.level_statement,
2807: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',

Line 2804: fnd_log.string

2800: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2801: END IF;
2802:
2803: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2804: fnd_log.string
2805: (
2806: fnd_log.level_statement,
2807: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
2808: 'Updating Flight scehdule ->'||p_x_flight_schedules_tbl(i).UNIT_SCHEDULE_ID

Line 2806: fnd_log.level_statement,

2802:
2803: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2804: fnd_log.string
2805: (
2806: fnd_log.level_statement,
2807: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
2808: 'Updating Flight scehdule ->'||p_x_flight_schedules_tbl(i).UNIT_SCHEDULE_ID
2809: );
2810: END IF;

Line 2821: FND_LOG.string(l_log_statement, l_full_name, 'Invoking Invoke_Visit_Dur_Notification API');

2817: IF (l_old_flight_rec.est_departure_time <> p_x_flight_schedules_tbl(i).est_departure_time OR
2818: l_old_flight_rec.est_arrival_time <> p_x_flight_schedules_tbl(i).est_arrival_time) THEN
2819:
2820: IF (l_log_statement >= l_log_current_level) THEN
2821: FND_LOG.string(l_log_statement, l_full_name, 'Invoking Invoke_Visit_Dur_Notification API');
2822: END IF;
2823:
2824: Invoke_Visit_Dur_Notification(
2825: p_flight_schedule_rec => p_x_flight_schedules_tbl(i),

Line 2830: FND_LOG.string(l_log_statement, l_full_name, 'After call to Invoke_Visit_Dur_Notification API, Return Status: ' || x_return_status);

2826: x_return_status => x_return_status
2827: );
2828:
2829: IF (l_log_statement >= l_log_current_level) THEN
2830: FND_LOG.string(l_log_statement, l_full_name, 'After call to Invoke_Visit_Dur_Notification API, Return Status: ' || x_return_status);
2831: END IF;
2832:
2833: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2834:

Line 2918: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN

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
2919: fnd_log.string
2920: (
2921: fnd_log.level_error,
2922: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',

Line 2919: fnd_log.string

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
2919: fnd_log.string
2920: (
2921: fnd_log.level_error,
2922: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
2923: 'SQL Error, Update failed..'

Line 2921: fnd_log.level_error,

2917: FND_MSG_PUB.add;
2918: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
2919: fnd_log.string
2920: (
2921: fnd_log.level_error,
2922: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
2923: 'SQL Error, Update failed..'
2924: );
2925: END IF;

Line 2967: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

2963: --populate visit reschedule mode.
2964: l_visit_sync_rec.visit_reschedule_mode := p_x_flight_schedules_tbl(i).visit_reschedule_mode;
2965: l_visit_sync_rec.unit_schedule_id := p_x_flight_schedules_tbl(i).unit_schedule_id;
2966:
2967: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2968: fnd_log.string
2969: (
2970: fnd_log.level_statement,
2971: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',

Line 2968: fnd_log.string

2964: l_visit_sync_rec.visit_reschedule_mode := p_x_flight_schedules_tbl(i).visit_reschedule_mode;
2965: l_visit_sync_rec.unit_schedule_id := p_x_flight_schedules_tbl(i).unit_schedule_id;
2966:
2967: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2968: fnd_log.string
2969: (
2970: fnd_log.level_statement,
2971: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
2972: 'Synchronize visits affected if any for flight -> '||p_x_flight_schedules_tbl(i).UNIT_SCHEDULE_ID

Line 2970: fnd_log.level_statement,

2966:
2967: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2968: fnd_log.string
2969: (
2970: fnd_log.level_statement,
2971: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
2972: 'Synchronize visits affected if any for flight -> '||p_x_flight_schedules_tbl(i).UNIT_SCHEDULE_ID
2973: );
2974: END IF;

Line 2985: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN

2981: );
2982:
2983: -- If any severe error occurs, then, abort API.
2984: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2985: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN
2986: fnd_log.string
2987: (
2988: fnd_log.level_exception,
2989: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,

Line 2986: fnd_log.string

2982:
2983: -- If any severe error occurs, then, abort API.
2984: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2985: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN
2986: fnd_log.string
2987: (
2988: fnd_log.level_exception,
2989: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
2990: 'Synchronize_Visit_Details returned with expected error..'

Line 2988: fnd_log.level_exception,

2984: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2985: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN
2986: fnd_log.string
2987: (
2988: fnd_log.level_exception,
2989: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
2990: 'Synchronize_Visit_Details returned with expected error..'
2991: );
2992: END IF;

Line 2995: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN

2991: );
2992: END IF;
2993: RAISE FND_API.G_EXC_ERROR;
2994: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2995: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN
2996: fnd_log.string
2997: (
2998: fnd_log.level_exception,
2999: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,

Line 2996: fnd_log.string

2992: END IF;
2993: RAISE FND_API.G_EXC_ERROR;
2994: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2995: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN
2996: fnd_log.string
2997: (
2998: fnd_log.level_exception,
2999: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
3000: 'Synchronize_Visit_Details returned with un-expected error..'

Line 2998: fnd_log.level_exception,

2994: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2995: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN
2996: fnd_log.string
2997: (
2998: fnd_log.level_exception,
2999: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
3000: 'Synchronize_Visit_Details returned with un-expected error..'
3001: );
3002: END IF;

Line 3059: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN

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,
3063: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',

Line 3060: fnd_log.string

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,
3063: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
3064: 'Overlap in flight times specified,'||

Line 3062: fnd_log.level_error,

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,
3063: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
3064: 'Overlap in flight times specified,'||
3065: 'this is a warning and not a error for '||p_x_flight_schedules_tbl(i).unit_schedule_id
3066: );

Line 3110: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

3106:
3107: IF ( p_x_flight_schedules_tbl(i).DML_OPERATION = 'D' )
3108: THEN
3109: -- Validate all attributes (Item level validation)
3110: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
3111: fnd_log.string
3112: (
3113: fnd_log.level_statement,
3114: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',

Line 3111: fnd_log.string

3107: IF ( p_x_flight_schedules_tbl(i).DML_OPERATION = 'D' )
3108: THEN
3109: -- Validate all attributes (Item level validation)
3110: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
3111: fnd_log.string
3112: (
3113: fnd_log.level_statement,
3114: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
3115: 'Validate attributes before creating flight schedules...'

Line 3113: fnd_log.level_statement,

3109: -- Validate all attributes (Item level validation)
3110: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
3111: fnd_log.string
3112: (
3113: fnd_log.level_statement,
3114: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
3115: 'Validate attributes before creating flight schedules...'
3116: );
3117: END IF;

Line 3125: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

3121: p_x_flight_schedules_tbl(i),
3122: x_return_status
3123: );
3124:
3125: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
3126: fnd_log.string
3127: (
3128: fnd_log.level_statement,
3129: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',

Line 3126: fnd_log.string

3122: x_return_status
3123: );
3124:
3125: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
3126: fnd_log.string
3127: (
3128: fnd_log.level_statement,
3129: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
3130: 'Validate all records before DML '

Line 3128: fnd_log.level_statement,

3124:
3125: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
3126: fnd_log.string
3127: (
3128: fnd_log.level_statement,
3129: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
3130: 'Validate all records before DML '
3131: );
3132: END IF;

Line 3142: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN

3138: );
3139:
3140: -- If any severe error occurs, then, abort API.
3141: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3142: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN
3143: fnd_log.string
3144: (
3145: fnd_log.level_exception,
3146: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,

Line 3143: fnd_log.string

3139:
3140: -- If any severe error occurs, then, abort API.
3141: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3142: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN
3143: fnd_log.string
3144: (
3145: fnd_log.level_exception,
3146: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
3147: 'validate_record returned with expected error..'

Line 3145: fnd_log.level_exception,

3141: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3142: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN
3143: fnd_log.string
3144: (
3145: fnd_log.level_exception,
3146: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
3147: 'validate_record returned with expected error..'
3148: );
3149: END IF;

Line 3152: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN

3148: );
3149: END IF;
3150: RAISE FND_API.G_EXC_ERROR;
3151: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3152: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN
3153: fnd_log.string
3154: (
3155: fnd_log.level_exception,
3156: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,

Line 3153: fnd_log.string

3149: END IF;
3150: RAISE FND_API.G_EXC_ERROR;
3151: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3152: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN
3153: fnd_log.string
3154: (
3155: fnd_log.level_exception,
3156: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
3157: 'validate_record returned with un-expected error..'

Line 3155: fnd_log.level_exception,

3151: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3152: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN
3153: fnd_log.string
3154: (
3155: fnd_log.level_exception,
3156: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
3157: 'validate_record returned with un-expected error..'
3158: );
3159: END IF;

Line 3164: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

3160: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3161: END IF;
3162:
3163: -- Delete the record
3164: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
3165: fnd_log.string
3166: (
3167: fnd_log.level_statement,
3168: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',

Line 3165: fnd_log.string

3161: END IF;
3162:
3163: -- Delete the record
3164: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
3165: fnd_log.string
3166: (
3167: fnd_log.level_statement,
3168: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
3169: 'Deleting Flight scehdule -> '||p_x_flight_schedules_tbl(i).unit_schedule_id

Line 3167: fnd_log.level_statement,

3163: -- Delete the record
3164: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
3165: fnd_log.string
3166: (
3167: fnd_log.level_statement,
3168: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
3169: 'Deleting Flight scehdule -> '||p_x_flight_schedules_tbl(i).unit_schedule_id
3170: );
3171: END IF;

Line 3193: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN

3189: );
3190:
3191: -- If any severe error occurs, then, abort API.
3192: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3193: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN
3194: fnd_log.string
3195: (
3196: fnd_log.level_exception,
3197: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,

Line 3194: fnd_log.string

3190:
3191: -- If any severe error occurs, then, abort API.
3192: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3193: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN
3194: fnd_log.string
3195: (
3196: fnd_log.level_exception,
3197: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
3198: 'AHL_VWP_VISITS_PVT.Process_Visit returned with expected error..'

Line 3196: fnd_log.level_exception,

3192: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3193: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN
3194: fnd_log.string
3195: (
3196: fnd_log.level_exception,
3197: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
3198: 'AHL_VWP_VISITS_PVT.Process_Visit returned with expected error..'
3199: );
3200: END IF;

Line 3203: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN

3199: );
3200: END IF;
3201: RAISE FND_API.G_EXC_ERROR;
3202: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3203: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN
3204: fnd_log.string
3205: (
3206: fnd_log.level_exception,
3207: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,

Line 3204: fnd_log.string

3200: END IF;
3201: RAISE FND_API.G_EXC_ERROR;
3202: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3203: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN
3204: fnd_log.string
3205: (
3206: fnd_log.level_exception,
3207: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
3208: 'validate_record returned with un-expected error..'

Line 3206: fnd_log.level_exception,

3202: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3203: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN
3204: fnd_log.string
3205: (
3206: fnd_log.level_exception,
3207: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
3208: 'validate_record returned with un-expected error..'
3209: );
3210: END IF;

Line 3225: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN

3221: OPEN c_get_sync_rule(p_x_flight_schedules_tbl(i).UNIT_SCHEDULE_ID);
3222: FETCH c_get_sync_rule INTO l_sync_rule;
3223: CLOSE c_get_sync_rule;
3224:
3225: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN
3226: fnd_log.string
3227: (
3228: fnd_log.level_exception,
3229: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,

Line 3226: fnd_log.string

3222: FETCH c_get_sync_rule INTO l_sync_rule;
3223: CLOSE c_get_sync_rule;
3224:
3225: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN
3226: fnd_log.string
3227: (
3228: fnd_log.level_exception,
3229: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
3230: 'VISIT_RESCHEDULE_MODE => '||l_sync_rule

Line 3228: fnd_log.level_exception,

3224:
3225: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN
3226: fnd_log.string
3227: (
3228: fnd_log.level_exception,
3229: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
3230: 'VISIT_RESCHEDULE_MODE => '||l_sync_rule
3231: );
3232: END IF;

Line 3255: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN

3251: );
3252:
3253: -- If any severe error occurs, then, abort API.
3254: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3255: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN
3256: fnd_log.string
3257: (
3258: fnd_log.level_exception,
3259: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,

Line 3256: fnd_log.string

3252:
3253: -- If any severe error occurs, then, abort API.
3254: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3255: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN
3256: fnd_log.string
3257: (
3258: fnd_log.level_exception,
3259: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
3260: 'AHL_VWP_VISITS_PVT.Process_Visit returned with expected error..'

Line 3258: fnd_log.level_exception,

3254: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3255: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN
3256: fnd_log.string
3257: (
3258: fnd_log.level_exception,
3259: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
3260: 'AHL_VWP_VISITS_PVT.Process_Visit returned with expected error..'
3261: );
3262: END IF;

Line 3267: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN

3263: -- fix for bug 13866936
3264: -- RAISE FND_API.G_EXC_ERROR;
3265: x_return_status := 'V';-- status assigned to force flight schedule updates
3266: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3267: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN
3268: fnd_log.string
3269: (
3270: fnd_log.level_exception,
3271: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,

Line 3268: fnd_log.string

3264: -- RAISE FND_API.G_EXC_ERROR;
3265: x_return_status := 'V';-- status assigned to force flight schedule updates
3266: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3267: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN
3268: fnd_log.string
3269: (
3270: fnd_log.level_exception,
3271: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
3272: 'AHL_VWP_VISITS_PVT.Process_Visit returned with un-expected error..'

Line 3270: fnd_log.level_exception,

3266: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3267: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN
3268: fnd_log.string
3269: (
3270: fnd_log.level_exception,
3271: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
3272: 'AHL_VWP_VISITS_PVT.Process_Visit returned with un-expected error..'
3273: );
3274: END IF;

Line 3279: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN

3275: -- fix for bug 13866936
3276: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3277: x_return_status := 'V';-- status assigned to force flight schedule updates
3278: ELSIF x_return_status = 'V' THEN
3279: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN
3280: fnd_log.string
3281: (
3282: fnd_log.level_exception,
3283: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,

Line 3280: fnd_log.string

3276: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3277: x_return_status := 'V';-- status assigned to force flight schedule updates
3278: ELSIF x_return_status = 'V' THEN
3279: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN
3280: fnd_log.string
3281: (
3282: fnd_log.level_exception,
3283: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
3284: 'Visit could not be deleted or cancelled...Please refer error stack for more details..'

Line 3282: fnd_log.level_exception,

3278: ELSIF x_return_status = 'V' THEN
3279: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN
3280: fnd_log.string
3281: (
3282: fnd_log.level_exception,
3283: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
3284: 'Visit could not be deleted or cancelled...Please refer error stack for more details..'
3285: );
3286: END IF;

Line 3303: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN

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
3304: fnd_log.string
3305: (
3306: fnd_log.level_error,
3307: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',

Line 3304: fnd_log.string

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
3304: fnd_log.string
3305: (
3306: fnd_log.level_error,
3307: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
3308: 'SQL Error, Delete failed..'

Line 3306: fnd_log.level_error,

3302: FND_MSG_PUB.add;
3303: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
3304: fnd_log.string
3305: (
3306: fnd_log.level_error,
3307: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
3308: 'SQL Error, Delete failed..'
3309: );
3310: END IF;

Line 3339: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN

3335: -- Bug # 9075539 - start
3336: l_return_status varchar2(1);
3337: -- Bug # 9075539 - end
3338: BEGIN
3339: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
3340: fnd_log.string
3341: (
3342: fnd_log.level_procedure,
3343: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||'.begin',

Line 3340: fnd_log.string

3336: l_return_status varchar2(1);
3337: -- Bug # 9075539 - end
3338: BEGIN
3339: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
3340: fnd_log.string
3341: (
3342: fnd_log.level_procedure,
3343: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||'.begin',
3344: 'At the start of Process_Flight_Schedules'

Line 3342: fnd_log.level_procedure,

3338: BEGIN
3339: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
3340: fnd_log.string
3341: (
3342: fnd_log.level_procedure,
3343: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||'.begin',
3344: 'At the start of Process_Flight_Schedules'
3345: );
3346: END IF;

Line 3408: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

3404: p_x_flight_schedules_tbl => p_x_flight_schedules_tbl
3405: );
3406:
3407:
3408: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
3409: fnd_log.string
3410: (
3411: fnd_log.level_statement,
3412: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',

Line 3409: fnd_log.string

3405: );
3406:
3407:
3408: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
3409: fnd_log.string
3410: (
3411: fnd_log.level_statement,
3412: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
3413: 'Done DML , committing the work'

Line 3411: fnd_log.level_statement,

3407:
3408: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
3409: fnd_log.string
3410: (
3411: fnd_log.level_statement,
3412: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
3413: 'Done DML , committing the work'
3414: );
3415: END IF;

Line 3431: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN

3427: p_data => X_msg_data);
3428: END IF;
3429: -- Bug # 9075539 - end
3430:
3431: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
3432: fnd_log.string
3433: (
3434: fnd_log.level_procedure,
3435: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||'.end',

Line 3432: fnd_log.string

3428: END IF;
3429: -- Bug # 9075539 - end
3430:
3431: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
3432: fnd_log.string
3433: (
3434: fnd_log.level_procedure,
3435: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||'.end',
3436: 'At the end of Process_Flight_Schedules'

Line 3434: fnd_log.level_procedure,

3430:
3431: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
3432: fnd_log.string
3433: (
3434: fnd_log.level_procedure,
3435: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||'.end',
3436: 'At the end of Process_Flight_Schedules'
3437: );
3438: END IF;

Line 3501: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN

3497: WHERE unit_schedule_id = p_unit_schedule_id
3498: AND unit_config_header_id = nvl(p_unit_config_id, unit_config_header_id);
3499:
3500: BEGIN
3501: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
3502: fnd_log.string
3503: (
3504: fnd_log.level_procedure,
3505: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||'.begin',

Line 3502: fnd_log.string

3498: AND unit_config_header_id = nvl(p_unit_config_id, unit_config_header_id);
3499:
3500: BEGIN
3501: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
3502: fnd_log.string
3503: (
3504: fnd_log.level_procedure,
3505: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||'.begin',
3506: 'At the start of '||l_api_name

Line 3504: fnd_log.level_procedure,

3500: BEGIN
3501: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
3502: fnd_log.string
3503: (
3504: fnd_log.level_procedure,
3505: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||'.begin',
3506: 'At the start of '||l_api_name
3507: );
3508: END IF;

Line 3510: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

3506: 'At the start of '||l_api_name
3507: );
3508: END IF;
3509:
3510: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
3511: fnd_log.string
3512: (
3513: fnd_log.level_statement,
3514: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',

Line 3511: fnd_log.string

3507: );
3508: END IF;
3509:
3510: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
3511: fnd_log.string
3512: (
3513: fnd_log.level_statement,
3514: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
3515: 'p_unit_schedule_id -> '||p_unit_schedule_id

Line 3513: fnd_log.level_statement,

3509:
3510: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
3511: fnd_log.string
3512: (
3513: fnd_log.level_statement,
3514: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
3515: 'p_unit_schedule_id -> '||p_unit_schedule_id
3516: ||', p_unit_config_id -> '||p_unit_config_id
3517: );

Line 3535: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN

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: (
3538: fnd_log.level_error,
3539: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',

Line 3536: fnd_log.string

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: (
3538: fnd_log.level_error,
3539: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
3540: 'unit schedule id is null..'

Line 3538: fnd_log.level_error,

3534: FND_MSG_PUB.add;
3535: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
3536: fnd_log.string
3537: (
3538: fnd_log.level_error,
3539: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
3540: 'unit schedule id is null..'
3541: );
3542: END IF;

Line 3551: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN

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: (
3554: fnd_log.level_error,
3555: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',

Line 3552: fnd_log.string

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: (
3554: fnd_log.level_error,
3555: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
3556: 'unit schedule Record is invalid..'

Line 3554: fnd_log.level_error,

3550: FND_MSG_PUB.add;
3551: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
3552: fnd_log.string
3553: (
3554: fnd_log.level_error,
3555: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
3556: 'unit schedule Record is invalid..'
3557: );
3558: END IF;

Line 3566: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN

3562: END IF;
3563: CLOSE check_flight_exists_csr;
3564: END IF;
3565:
3566: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
3567: fnd_log.string
3568: (
3569: fnd_log.level_procedure,
3570: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||'.end',

Line 3567: fnd_log.string

3563: CLOSE check_flight_exists_csr;
3564: END IF;
3565:
3566: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
3567: fnd_log.string
3568: (
3569: fnd_log.level_procedure,
3570: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||'.end',
3571: 'At the start of '||l_api_name

Line 3569: fnd_log.level_procedure,

3565:
3566: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
3567: fnd_log.string
3568: (
3569: fnd_log.level_procedure,
3570: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||'.end',
3571: 'At the start of '||l_api_name
3572: );
3573: END IF;

Line 3649: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN

3645: l_api_name CONSTANT VARCHAR2(30) := 'is_delete_allowed';
3646:
3647: BEGIN
3648: --l_is_super_user := p_is_super_user;
3649: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
3650: fnd_log.string
3651: (
3652: fnd_log.level_procedure,
3653: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||'.begin',

Line 3650: fnd_log.string

3646:
3647: BEGIN
3648: --l_is_super_user := p_is_super_user;
3649: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
3650: fnd_log.string
3651: (
3652: fnd_log.level_procedure,
3653: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||'.begin',
3654: 'At the start of '||l_api_name

Line 3652: fnd_log.level_procedure,

3648: --l_is_super_user := p_is_super_user;
3649: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
3650: fnd_log.string
3651: (
3652: fnd_log.level_procedure,
3653: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||'.begin',
3654: 'At the start of '||l_api_name
3655: );
3656: END IF;

Line 3658: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

3654: 'At the start of '||l_api_name
3655: );
3656: END IF;
3657:
3658: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
3659: fnd_log.string
3660: (
3661: fnd_log.level_statement,
3662: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',

Line 3659: fnd_log.string

3655: );
3656: END IF;
3657:
3658: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
3659: fnd_log.string
3660: (
3661: fnd_log.level_statement,
3662: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
3663: 'Flight Schedule id --> '|| p_unit_schedule_id ||' and is super user? '||p_is_super_user

Line 3661: fnd_log.level_statement,

3657:
3658: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
3659: fnd_log.string
3660: (
3661: fnd_log.level_statement,
3662: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
3663: 'Flight Schedule id --> '|| p_unit_schedule_id ||' and is super user? '||p_is_super_user
3664: );
3665: END IF;

Line 3713: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN

3709: l_actual_recorded VARCHAR2(1);
3710:
3711: BEGIN
3712:
3713: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
3714: fnd_log.string
3715: (
3716: fnd_log.level_procedure,
3717: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||'.begin',

Line 3714: fnd_log.string

3710:
3711: BEGIN
3712:
3713: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
3714: fnd_log.string
3715: (
3716: fnd_log.level_procedure,
3717: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||'.begin',
3718: 'At the start of '||l_api_name

Line 3716: fnd_log.level_procedure,

3712:
3713: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
3714: fnd_log.string
3715: (
3716: fnd_log.level_procedure,
3717: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||'.begin',
3718: 'At the start of '||l_api_name
3719: );
3720: END IF;

Line 3722: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

3718: 'At the start of '||l_api_name
3719: );
3720: END IF;
3721:
3722: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
3723: fnd_log.string
3724: (
3725: fnd_log.level_statement,
3726: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',

Line 3723: fnd_log.string

3719: );
3720: END IF;
3721:
3722: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
3723: fnd_log.string
3724: (
3725: fnd_log.level_statement,
3726: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
3727: 'Flight Schedule id --> '|| p_unit_schedule_id ||' and is super user? '||p_is_super_user

Line 3725: fnd_log.level_statement,

3721:
3722: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
3723: fnd_log.string
3724: (
3725: fnd_log.level_statement,
3726: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
3727: 'Flight Schedule id --> '|| p_unit_schedule_id ||' and is super user? '||p_is_super_user
3728: );
3729: END IF;