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_AVF_OPER_VSTS_PVT dependencies on FND_LOG

Line 10: l_log_current_level NUMBER := fnd_log.g_current_runtime_level;

6:
7: ------------------------------------
8: -- Common constants and variables --
9: ------------------------------------
10: l_log_current_level NUMBER := fnd_log.g_current_runtime_level;
11: l_log_statement NUMBER := fnd_log.level_statement;
12: l_log_procedure NUMBER := fnd_log.level_procedure;
13:
14: ---------------------------------------------------------------------

Line 11: l_log_statement NUMBER := fnd_log.level_statement;

7: ------------------------------------
8: -- Common constants and variables --
9: ------------------------------------
10: l_log_current_level NUMBER := fnd_log.g_current_runtime_level;
11: l_log_statement NUMBER := fnd_log.level_statement;
12: l_log_procedure NUMBER := fnd_log.level_procedure;
13:
14: ---------------------------------------------------------------------
15: -- Define Record Types for record structures needed by the APIs --

Line 12: l_log_procedure NUMBER := fnd_log.level_procedure;

8: -- Common constants and variables --
9: ------------------------------------
10: l_log_current_level NUMBER := fnd_log.g_current_runtime_level;
11: l_log_statement NUMBER := fnd_log.level_statement;
12: l_log_procedure NUMBER := fnd_log.level_procedure;
13:
14: ---------------------------------------------------------------------
15: -- Define Record Types for record structures needed by the APIs --
16: ---------------------------------------------------------------------

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

281: WHERE VISIT_ID = c_visit_id;
282:
283: BEGIN
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.AHL_AVF_OPER_VSTS_PVT.Create_Oper_Visit.begin',

Line 286: fnd_log.string

282:
283: BEGIN
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.AHL_AVF_OPER_VSTS_PVT.Create_Oper_Visit.begin',
290: 'At the start of PLSQL procedure'

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.AHL_AVF_OPER_VSTS_PVT.Create_Oper_Visit.begin',
290: 'At the start of PLSQL procedure'
291: );
292: END IF;

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

326: l_flight_schedule_rec.arrival_dept_id := flight_schedule_rec.arrival_dept_id;
327: l_flight_schedule_rec.est_arrival_time := flight_schedule_rec.est_arrival_time;
328:
329: -- CASE I: First consider the departing org of the flight schedule record
330: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
331: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'CASE 1, flight_schedule_rec.unit_schedule_id= '||flight_schedule_rec.unit_schedule_id );
332: END IF;
333:
334: OPEN get_non_null_org_count(flight_schedule_rec.unit_config_header_id,flight_schedule_rec.departure_org_id);

Line 331: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'CASE 1, flight_schedule_rec.unit_schedule_id= '||flight_schedule_rec.unit_schedule_id );

327: l_flight_schedule_rec.est_arrival_time := flight_schedule_rec.est_arrival_time;
328:
329: -- CASE I: First consider the departing org of the flight schedule record
330: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
331: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'CASE 1, flight_schedule_rec.unit_schedule_id= '||flight_schedule_rec.unit_schedule_id );
332: END IF;
333:
334: OPEN get_non_null_org_count(flight_schedule_rec.unit_config_header_id,flight_schedule_rec.departure_org_id);
335: FETCH get_non_null_org_count INTO l_count_org;

Line 352: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'flight_schedule_rec.preceding_us_id--@>'||flight_schedule_rec.preceding_us_id);

348: -- check if there exisits a visit and if yes, get the visit details
349: AHL_AVF_OPER_VSTS_PVT.Get_Visit_Type(flight_schedule_rec.unit_schedule_id, 'P', l_visit_type, l_visit_id,l_visit_id2);
350:
351: IF (l_log_statement >= l_log_current_level) THEN
352: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'flight_schedule_rec.preceding_us_id--@>'||flight_schedule_rec.preceding_us_id);
353: END IF;
354: --If the flight schedule does not have any preceeding event then
355: IF ( flight_schedule_rec.preceding_us_id IS NULL ) THEN
356: IF substr (l_visit_type,1,1) = 'D' THEN --existing visit is a departure visit

Line 358: fnd_log.string(l_log_statement,L_DEBUG_KEY, ' There is an existing departure visit at dep org, do nothing');

354: --If the flight schedule does not have any preceeding event then
355: IF ( flight_schedule_rec.preceding_us_id IS NULL ) THEN
356: IF substr (l_visit_type,1,1) = 'D' THEN --existing visit is a departure visit
357: IF (l_log_statement >= l_log_current_level) THEN
358: fnd_log.string(l_log_statement,L_DEBUG_KEY, ' There is an existing departure visit at dep org, do nothing');
359: END IF;
360: NULL; --Do nothing :: Go to arrival org consideration
361: ELSIF l_visit_type = 'N' THEN -- no visit
362:

Line 364: fnd_log.string(l_log_statement,L_DEBUG_KEY, ' flight_schedule_rec.unit_config_header_id--@>'||flight_schedule_rec.unit_config_header_id||

360: NULL; --Do nothing :: Go to arrival org consideration
361: ELSIF l_visit_type = 'N' THEN -- no visit
362:
363: IF (l_log_statement >= l_log_current_level) THEN
364: fnd_log.string(l_log_statement,L_DEBUG_KEY, ' flight_schedule_rec.unit_config_header_id--@>'||flight_schedule_rec.unit_config_header_id||
365: ' ;flight_schedule_rec.departure_org_id--@>'||flight_schedule_rec.departure_org_id||
366: ' ;flight_schedule_rec.departure_dept_id--@>'||flight_schedule_rec.departure_dept_id||
367: ' ;flight_schedule_rec.flight_category_code--@>'||flight_schedule_rec.flight_category_code||
368: ' ;l_count_org--@>'||l_count_org||

Line 382: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'Before Type 1 and before calling Create_Departure_visit');

378: IF get_oper_param_rows1%FOUND THEN
379: --If there is a possibility to create a departure visit
380: --TYPE 1: Departure Org :: no visit to cancel :: create a departure visit
381: IF (l_log_statement >= l_log_current_level) THEN
382: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'Before Type 1 and before calling Create_Departure_visit');
383: END IF;
384: l_oper_param_rec.visit_type_code := get_oper_param_rec.visit_type_code;
385: l_oper_param_rec.mc_id := get_oper_param_rec.mc_id;
386: l_oper_param_rec.alternate_dep_id := get_oper_param_rec.alternate_dep_id;

Line 403: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'After calling Create_Departure_visit and l_return_status: '||l_return_status);

399: x_msg_data => l_msg_data
400: );
401:
402: IF (l_log_statement >= l_log_current_level) THEN
403: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'After calling Create_Departure_visit and l_return_status: '||l_return_status);
404: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'l_is_creation_success: '||l_is_creation_success);
405: END IF;
406:
407: -- Bug 14336467 :: PRAKKUM :: 13/07/2012

Line 404: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'l_is_creation_success: '||l_is_creation_success);

400: );
401:
402: IF (l_log_statement >= l_log_current_level) THEN
403: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'After calling Create_Departure_visit and l_return_status: '||l_return_status);
404: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'l_is_creation_success: '||l_is_creation_success);
405: END IF;
406:
407: -- Bug 14336467 :: PRAKKUM :: 13/07/2012
408: IF l_is_creation_success<>'Y' THEN

Line 432: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'After calling load_can_cancel_visit and l_return_status: '||l_return_status);

428: x_msg_count => l_msg_count,
429: x_msg_data => l_msg_data
430: );
431: IF (l_log_statement >= l_log_current_level) THEN
432: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'After calling load_can_cancel_visit and l_return_status: '||l_return_status);
433: END IF;
434:
435: OPEN get_pre_fs_det(flight_schedule_rec.preceding_us_id);
436: FETCH get_pre_fs_det INTO pre_fs_det_rec;

Line 447: fnd_log.string(l_log_statement,L_DEBUG_KEY, ' flight_schedule_rec.unit_config_header_id--@>'||flight_schedule_rec.unit_config_header_id||

443: l_prec_flight_schedule_rec.arrival_dept_id := pre_fs_det_rec.arrival_dept_id;
444: l_prec_flight_schedule_rec.est_arrival_time := pre_fs_det_rec.est_arrival_time;
445:
446: IF (l_log_statement >= l_log_current_level) THEN
447: fnd_log.string(l_log_statement,L_DEBUG_KEY, ' flight_schedule_rec.unit_config_header_id--@>'||flight_schedule_rec.unit_config_header_id||
448: ' ;flight_schedule_rec.departure_org_id--@>'||flight_schedule_rec.departure_org_id||
449: ' ;flight_schedule_rec.departure_dept_id--@>'||flight_schedule_rec.departure_dept_id||
450: ' ;flight_schedule_rec.flight_category_code--@>'||flight_schedule_rec.flight_category_code||
451: ' ;l_count_org--@>'||l_count_org||

Line 470: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'Before Type 1a and before calling Create_Departure_visit');

466: IF get_oper_param_rows1%FOUND THEN
467: --If there is a possibility to create a departure visit
468: --TYPE 1a: Departure Org :: no visit to cancel :: create a departure visit
469: IF (l_log_statement >= l_log_current_level) THEN
470: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'Before Type 1a and before calling Create_Departure_visit');
471: END IF;
472: l_oper_param_rec.visit_type_code := get_oper_param_rec.visit_type_code;
473: l_oper_param_rec.mc_id := get_oper_param_rec.mc_id;
474: l_oper_param_rec.alternate_dep_id := get_oper_param_rec.alternate_dep_id;

Line 490: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'After calling Create_Departure_visit and l_return_status: '||l_return_status);

486: x_msg_count => l_msg_count,
487: x_msg_data => l_msg_data
488: );
489: IF (l_log_statement >= l_log_current_level) THEN
490: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'After calling Create_Departure_visit and l_return_status: '||l_return_status);
491: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'l_is_creation_success: '||l_is_creation_success);
492: END IF;
493:
494: IF l_is_creation_success<>'Y' THEN

Line 491: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'l_is_creation_success: '||l_is_creation_success);

487: x_msg_data => l_msg_data
488: );
489: IF (l_log_statement >= l_log_current_level) THEN
490: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'After calling Create_Departure_visit and l_return_status: '||l_return_status);
491: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'l_is_creation_success: '||l_is_creation_success);
492: END IF;
493:
494: IF l_is_creation_success<>'Y' THEN
495: ROLLBACK TO OPER_VISIT_CREATION;

Line 511: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'Ground time is '||l_ground_time);

507: FETCH get_ground_time INTO l_ground_time;
508: CLOSE get_ground_time;
509:
510: IF (l_log_statement >= l_log_current_level) THEN
511: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'Ground time is '||l_ground_time);
512: END IF;
513:
514: OPEN get_non_null_org_count(pre_fs_det_rec.unit_config_header_id,pre_fs_det_rec.arrival_org_id);
515: FETCH get_non_null_org_count INTO l_count_prec_arr_org;

Line 530: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'unit_config_header_id: '||pre_fs_det_rec.unit_config_header_id

526: CLOSE get_non_null_cat_count;
527:
528: IF substr (l_visit_type,1,1) <> 'T' THEN -- either no visit or departure visit at the departing org of current FS
529: IF (l_log_statement >= l_log_current_level) THEN
530: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'unit_config_header_id: '||pre_fs_det_rec.unit_config_header_id
531: ||', pre_fs_det_rec.arrival_org_id: '||pre_fs_det_rec.arrival_org_id||', arrival_dept_id: , '
532: ||pre_fs_det_rec.arrival_dept_id ||', flight_category_code: ,'||pre_fs_det_rec.flight_category_code
533: ||', l_count_prec_arr_org: ,'||l_count_prec_arr_org
534: ||', l_count_prec_arr_dep: ,'||l_count_prec_arr_dep||', l_count_prec_arr_cat: ,'||l_count_prec_arr_cat);

Line 556: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'Before Type 2 and before calling Create_Downtime_visit');

552: p_visit_id => l_visit_id,
553: x_return_status => l_return_status);
554: END IF;--IF(l_visit_id is not null) then
555: IF (l_log_statement >= l_log_current_level) THEN
556: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'Before Type 2 and before calling Create_Downtime_visit');
557: END IF;
558: l_oper_param_rec.visit_type_code := get_oper_param_rec.visit_type_code;
559: l_oper_param_rec.alternate_dep_id := get_oper_param_rec.alternate_dep_id;
560: l_oper_param_rec.autovst_oper_id := get_oper_param_rec.autovst_oper_id;

Line 575: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'After calling Create_Downtime_visit and l_return_status: '||l_return_status);

571: x_msg_data => l_msg_data
572: );
573:
574: IF (l_log_statement >= l_log_current_level) THEN
575: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'After calling Create_Downtime_visit and l_return_status: '||l_return_status);
576: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'l_is_creation_success: '||l_is_creation_success);
577: END IF;
578:
579: IF l_is_creation_success<>'Y' THEN

Line 576: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'l_is_creation_success: '||l_is_creation_success);

572: );
573:
574: IF (l_log_statement >= l_log_current_level) THEN
575: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'After calling Create_Downtime_visit and l_return_status: '||l_return_status);
576: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'l_is_creation_success: '||l_is_creation_success);
577: END IF;
578:
579: IF l_is_creation_success<>'Y' THEN
580: ROLLBACK TO OPER_VISIT_CREATION;

Line 594: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'Before Type 3');

590: IF l_visit_type_code <> get_oper_param_rec.visit_type_code THEN
591: -- if it does not match then Cancel the visit assoc to arrival org and also if any departure visit associated
592: -- to the dep org of current FS. then create a downtime visit
593: IF (l_log_statement >= l_log_current_level) THEN
594: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'Before Type 3');
595: END IF;
596:
597: -- Bug 14336467 :: PRAKKUM :: 13/07/2012 :: START
598: SAVEPOINT OPER_VISIT_CREATION;

Line 613: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'Before calling Create_Downtime_visit');

609: p_visit_id => l_visit_id,
610: x_return_status => l_return_status);
611: END IF;--IF(l_visit_id is not null) then
612: IF (l_log_statement >= l_log_current_level) THEN
613: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'Before calling Create_Downtime_visit');
614: END IF;
615: l_oper_param_rec.visit_type_code := get_oper_param_rec.visit_type_code;
616: l_oper_param_rec.alternate_dep_id := get_oper_param_rec.alternate_dep_id;
617: l_oper_param_rec.autovst_oper_id := get_oper_param_rec.autovst_oper_id;

Line 631: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'After calling Create_Downtime_visit and l_return_status: '||l_return_status);

627: x_msg_data => l_msg_data
628: );
629:
630: IF (l_log_statement >= l_log_current_level) THEN
631: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'After calling Create_Downtime_visit and l_return_status: '||l_return_status);
632: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'l_is_creation_success: '||l_is_creation_success);
633: END IF;
634:
635: IF l_is_creation_success<>'Y' THEN

Line 632: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'l_is_creation_success: '||l_is_creation_success);

628: );
629:
630: IF (l_log_statement >= l_log_current_level) THEN
631: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'After calling Create_Downtime_visit and l_return_status: '||l_return_status);
632: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'l_is_creation_success: '||l_is_creation_success);
633: END IF;
634:
635: IF l_is_creation_success<>'Y' THEN
636: ROLLBACK TO OPER_VISIT_CREATION;

Line 653: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'Before Type 4 and before calling Create_Departure_visit');

649: IF get_oper_param_rows1%FOUND THEN
650: --there is a possibility to create a departure visit
651: --TYPE 4: Departure Org :: no dep visit associated to current FS dep org :: create a departure visit
652: IF (l_log_statement >= l_log_current_level) THEN
653: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'Before Type 4 and before calling Create_Departure_visit');
654: END IF;
655: l_oper_param_rec.visit_type_code := get_oper_param_rec.visit_type_code;
656: l_oper_param_rec.mc_id := get_oper_param_rec.mc_id;
657: l_oper_param_rec.alternate_dep_id := get_oper_param_rec.alternate_dep_id;

Line 673: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'After calling Create_Departure_visit and l_return_status: '||l_return_status);

669: x_msg_count => l_msg_count,
670: x_msg_data => l_msg_data
671: );
672: IF (l_log_statement >= l_log_current_level) THEN
673: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'After calling Create_Departure_visit and l_return_status: '||l_return_status);
674: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'l_is_creation_success: '||l_is_creation_success);
675: END IF;
676:
677: IF l_is_creation_success<>'Y' THEN

Line 674: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'l_is_creation_success: '||l_is_creation_success);

670: x_msg_data => l_msg_data
671: );
672: IF (l_log_statement >= l_log_current_level) THEN
673: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'After calling Create_Departure_visit and l_return_status: '||l_return_status);
674: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'l_is_creation_success: '||l_is_creation_success);
675: END IF;
676:
677: IF l_is_creation_success<>'Y' THEN
678: ROLLBACK TO OPER_VISIT_CREATION;

Line 703: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'Before Type 5 and before calling Create_Departure_visit');

699: FETCH get_oper_param_rows1 INTO get_oper_param_rec;
700: IF get_oper_param_rows1%FOUND THEN
701: --TYPE 5: Departure Org :: no visit to cancel :: create a departure visit
702: IF (l_log_statement >= l_log_current_level) THEN
703: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'Before Type 5 and before calling Create_Departure_visit');
704: END IF;
705: l_oper_param_rec.visit_type_code := get_oper_param_rec.visit_type_code;
706: l_oper_param_rec.mc_id := get_oper_param_rec.mc_id;
707: l_oper_param_rec.alternate_dep_id := get_oper_param_rec.alternate_dep_id;

Line 723: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'After calling Create_Departure_visit and l_return_status: '||l_return_status);

719: x_msg_count => l_msg_count,
720: x_msg_data => l_msg_data
721: );
722: IF (l_log_statement >= l_log_current_level) THEN
723: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'After calling Create_Departure_visit and l_return_status: '||l_return_status);
724: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'l_is_creation_success: '||l_is_creation_success);
725: END IF;
726:
727: IF l_is_creation_success<>'Y' THEN

Line 724: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'l_is_creation_success: '||l_is_creation_success);

720: x_msg_data => l_msg_data
721: );
722: IF (l_log_statement >= l_log_current_level) THEN
723: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'After calling Create_Departure_visit and l_return_status: '||l_return_status);
724: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'l_is_creation_success: '||l_is_creation_success);
725: END IF;
726:
727: IF l_is_creation_success<>'Y' THEN
728: ROLLBACK TO OPER_VISIT_CREATION;

Line 765: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'Before Type 6');

761: -- if it does not match then cancel the existing downtime visit with id 'l_visit_id2'
762: -- create a downtime visit
763: -- TYPE 6: Departure Org :: cancel existing downtime visit :: create a downtime visit
764: IF (l_log_statement >= l_log_current_level) THEN
765: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'Before Type 6');
766: END IF;
767: Delete_Oper_Visit(
768: p_visit_id => l_visit_id2,
769: x_return_status => l_return_status);

Line 771: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'Before calling Create_Downtime_visit');

767: Delete_Oper_Visit(
768: p_visit_id => l_visit_id2,
769: x_return_status => l_return_status);
770: IF (l_log_statement >= l_log_current_level) THEN
771: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'Before calling Create_Downtime_visit');
772: END IF;
773: l_oper_param_rec.visit_type_code := get_oper_param_rec.visit_type_code;
774: l_oper_param_rec.alternate_dep_id := get_oper_param_rec.alternate_dep_id;
775: l_oper_param_rec.autovst_oper_id := get_oper_param_rec.autovst_oper_id;

Line 789: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'After calling Create_Downtime_visit and l_return_status: '||l_return_status);

785: x_msg_data => l_msg_data
786: );
787:
788: IF (l_log_statement >= l_log_current_level) THEN
789: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'After calling Create_Downtime_visit and l_return_status: '||l_return_status);
790: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'l_is_creation_success: '||l_is_creation_success);
791: END IF;
792:
793: IF l_is_creation_success<>'Y' THEN

Line 790: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'l_is_creation_success: '||l_is_creation_success);

786: );
787:
788: IF (l_log_statement >= l_log_current_level) THEN
789: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'After calling Create_Downtime_visit and l_return_status: '||l_return_status);
790: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'l_is_creation_success: '||l_is_creation_success);
791: END IF;
792:
793: IF l_is_creation_success<>'Y' THEN
794: ROLLBACK TO OPER_VISIT_CREATION;

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

802: END IF; --if the existing visit is a downtime visit
803: END IF; -- IF (l_can_cancel_visit IS NOT NULL) AND (l_can_cancel_visit2 IS NOT NULL) THEN
804: END IF; -- if there is any preceeding event
805:
806: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
807: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'CASE II, flight_schedule_rec.unit_schedule_id= '||flight_schedule_rec.unit_schedule_id );
808: END IF;
809: -- CASE II: Now consider the arrival org of the flight schedule record
810: OPEN get_non_null_org_count(flight_schedule_rec.unit_config_header_id,flight_schedule_rec.arrival_org_id);

Line 807: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'CASE II, flight_schedule_rec.unit_schedule_id= '||flight_schedule_rec.unit_schedule_id );

803: END IF; -- IF (l_can_cancel_visit IS NOT NULL) AND (l_can_cancel_visit2 IS NOT NULL) THEN
804: END IF; -- if there is any preceeding event
805:
806: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
807: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'CASE II, flight_schedule_rec.unit_schedule_id= '||flight_schedule_rec.unit_schedule_id );
808: END IF;
809: -- CASE II: Now consider the arrival org of the flight schedule record
810: OPEN get_non_null_org_count(flight_schedule_rec.unit_config_header_id,flight_schedule_rec.arrival_org_id);
811: FETCH get_non_null_org_count INTO l_count_org;

Line 831: fnd_log.string(l_log_statement,L_DEBUG_KEY, ' l_succeeding_us_id--@>'||l_succeeding_us_id);

827:
828: -- check if there exisits a visit and if yes, what visit type - either arrival or downtime
829: AHL_AVF_OPER_VSTS_PVT.Get_Visit_Type(flight_schedule_rec.unit_schedule_id, 'S', l_visit_type, l_visit_id,l_visit_id2);
830: IF (l_log_statement >= l_log_current_level) THEN
831: fnd_log.string(l_log_statement,L_DEBUG_KEY, ' l_succeeding_us_id--@>'||l_succeeding_us_id);
832: END IF;
833: --If the flight schedule does not have any succeeding flight then
834: IF ( l_succeeding_us_id IS NULL ) THEN
835: IF substr (l_visit_type,1,1) = 'A' THEN -- arrival visit associated to the arrival org of current FS

Line 838: fnd_log.string(l_log_statement,L_DEBUG_KEY, ' There is an existing arrival visit at arrival org, do nothing');

834: IF ( l_succeeding_us_id IS NULL ) THEN
835: IF substr (l_visit_type,1,1) = 'A' THEN -- arrival visit associated to the arrival org of current FS
836: -- Go to end
837: IF (l_log_statement >= l_log_current_level) THEN
838: fnd_log.string(l_log_statement,L_DEBUG_KEY, ' There is an existing arrival visit at arrival org, do nothing');
839: END IF;
840: NULL; --Do nothing :: Go to end
841: ELSIF l_visit_type = 'N' THEN -- no visit associated to the arrival org of current FS
842: -- check for the possibility of creating an arrival visit;

Line 844: fnd_log.string(l_log_statement,L_DEBUG_KEY, ' flight_schedule_rec.unit_config_header_id--@>'||flight_schedule_rec.unit_config_header_id||

840: NULL; --Do nothing :: Go to end
841: ELSIF l_visit_type = 'N' THEN -- no visit associated to the arrival org of current FS
842: -- check for the possibility of creating an arrival visit;
843: IF (l_log_statement >= l_log_current_level) THEN
844: fnd_log.string(l_log_statement,L_DEBUG_KEY, ' flight_schedule_rec.unit_config_header_id--@>'||flight_schedule_rec.unit_config_header_id||
845: ' ;flight_schedule_rec.arrival_org_id--@>'||flight_schedule_rec.arrival_org_id||
846: ' ;flight_schedule_rec.arrival_dept_id--@>'||flight_schedule_rec.arrival_dept_id||
847: ' ;flight_schedule_rec.flight_category_code--@>'||flight_schedule_rec.flight_category_code||
848: ' ;l_count_org--@>'||l_count_org||

Line 861: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'Before Type 7 and before calling Create_Arrival_visit');

857: IF get_oper_param_rows1%FOUND THEN
858: --If there is a possibility , create an arrival visit
859: --TYPE 7: Arrival Org :: no visit to cancel :: create an arrival visit
860: IF (l_log_statement >= l_log_current_level) THEN
861: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'Before Type 7 and before calling Create_Arrival_visit');
862: END IF;
863: l_oper_param_rec.visit_type_code := get_oper_param_rec.visit_type_code;
864: l_oper_param_rec.mc_id := get_oper_param_rec.mc_id;
865: l_oper_param_rec.alternate_dep_id := get_oper_param_rec.alternate_dep_id;

Line 882: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'After calling Create_Arrival_visit and l_return_status: '||l_return_status);

878: x_msg_data => l_msg_data
879: );
880:
881: IF (l_log_statement >= l_log_current_level) THEN
882: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'After calling Create_Arrival_visit and l_return_status: '||l_return_status);
883: END IF;
884:
885: IF l_is_creation_success<>'Y' THEN
886: ROLLBACK TO OPER_VISIT_CREATION;

Line 910: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'After calling load_can_cancel_visit and l_return_status: '||l_return_status);

906: x_msg_count => l_msg_count,
907: x_msg_data => l_msg_data
908: );
909: IF (l_log_statement >= l_log_current_level) THEN
910: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'After calling load_can_cancel_visit and l_return_status: '||l_return_status);
911: END IF;
912:
913: IF (l_log_statement >= l_log_current_level) THEN
914: fnd_log.string(l_log_statement,L_DEBUG_KEY, ' flight_schedule_rec.unit_config_header_id--@>'||flight_schedule_rec.unit_config_header_id||

Line 914: fnd_log.string(l_log_statement,L_DEBUG_KEY, ' flight_schedule_rec.unit_config_header_id--@>'||flight_schedule_rec.unit_config_header_id||

910: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'After calling load_can_cancel_visit and l_return_status: '||l_return_status);
911: END IF;
912:
913: IF (l_log_statement >= l_log_current_level) THEN
914: fnd_log.string(l_log_statement,L_DEBUG_KEY, ' flight_schedule_rec.unit_config_header_id--@>'||flight_schedule_rec.unit_config_header_id||
915: ' ;flight_schedule_rec.arrival_org_id--@>'||flight_schedule_rec.arrival_org_id||
916: ' ;flight_schedule_rec.arrival_dept_id--@>'||flight_schedule_rec.arrival_dept_id||
917: ' ;flight_schedule_rec.flight_category_code--@>'||flight_schedule_rec.flight_category_code||
918: ' ;l_count_org--@>'||l_count_org||

Line 937: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'Before Type 8 and before calling Create_Arrival_visit');

933: IF get_oper_param_rows1%FOUND THEN
934: -- if there is possibility of creating an arrival visit
935: --TYPE 8: Arrival Org :: no visit to cancel :: create an arrival visit
936: IF (l_log_statement >= l_log_current_level) THEN
937: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'Before Type 8 and before calling Create_Arrival_visit');
938: END IF;
939: l_oper_param_rec.visit_type_code := get_oper_param_rec.visit_type_code;
940: l_oper_param_rec.mc_id := get_oper_param_rec.mc_id;
941: l_oper_param_rec.alternate_dep_id := get_oper_param_rec.alternate_dep_id;

Line 957: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'After calling Create_Arrival_visit and l_return_status: '||l_return_status);

953: x_msg_count => l_msg_count,
954: x_msg_data => l_msg_data
955: );
956: IF (l_log_statement >= l_log_current_level) THEN
957: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'After calling Create_Arrival_visit and l_return_status: '||l_return_status);
958: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'l_is_creation_success: '||l_is_creation_success);
959: END IF;
960:
961: IF l_is_creation_success<>'Y' THEN

Line 958: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'l_is_creation_success: '||l_is_creation_success);

954: x_msg_data => l_msg_data
955: );
956: IF (l_log_statement >= l_log_current_level) THEN
957: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'After calling Create_Arrival_visit and l_return_status: '||l_return_status);
958: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'l_is_creation_success: '||l_is_creation_success);
959: END IF;
960:
961: IF l_is_creation_success<>'Y' THEN
962: ROLLBACK TO OPER_VISIT_CREATION;

Line 987: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'Before Type 9');

983: l_is_downtime_vst_created := 'Y';
984: IF get_oper_param_rows1%FOUND THEN -- if there is possibiliy of creating a downtime visit
985: IF l_visit_type = 'N' THEN -- no visit associated to the arrival org of current FS
986: IF (l_log_statement >= l_log_current_level) THEN
987: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'Before Type 9');
988: END IF;
989: --TYPE 9: Arrival Org :: no visit of current FS to cancel :: create a downtime visit
990: --cancel the departure visit of the succeeding flight if it is not null
991:

Line 1001: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'Before calling Create_Downtime_visit');

997: p_visit_id => l_visit_id2,
998: x_return_status => l_return_status);
999: END IF;--IF(l_visit_id2 is not null) then
1000: IF (l_log_statement >= l_log_current_level) THEN
1001: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'Before calling Create_Downtime_visit');
1002: END IF;
1003: l_oper_param_rec.visit_type_code := get_oper_param_rec.visit_type_code;
1004: l_oper_param_rec.alternate_dep_id := get_oper_param_rec.alternate_dep_id;
1005: l_oper_param_rec.autovst_oper_id := get_oper_param_rec.autovst_oper_id;

Line 1019: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'After calling Create_Downtime_visit and l_return_status: '||l_return_status);

1015: x_msg_data => l_msg_data
1016: );
1017:
1018: IF (l_log_statement >= l_log_current_level) THEN
1019: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'After calling Create_Downtime_visit and l_return_status: '||l_return_status);
1020: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'l_is_creation_success: '||l_is_creation_success);
1021: END IF;
1022:
1023: IF l_is_creation_success<>'Y' THEN

Line 1020: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'l_is_creation_success: '||l_is_creation_success);

1016: );
1017:
1018: IF (l_log_statement >= l_log_current_level) THEN
1019: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'After calling Create_Downtime_visit and l_return_status: '||l_return_status);
1020: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'l_is_creation_success: '||l_is_creation_success);
1021: END IF;
1022:
1023: IF l_is_creation_success<>'Y' THEN
1024: ROLLBACK TO OPER_VISIT_CREATION;

Line 1039: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'Before Type 10');

1035: IF l_visit_type_code <> get_oper_param_rec.visit_type_code THEN
1036: -- if it does not match, then cancel the arrival visit with id 'l_visit_id'
1037: -- and create a downtime visit
1038: IF (l_log_statement >= l_log_current_level) THEN
1039: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'Before Type 10');
1040: END IF;
1041: --TYPE 10: Arrival Org :: cancel existing arrival visit :: create a downtime visit
1042: Delete_Oper_Visit(
1043: p_visit_id => l_visit_id,

Line 1053: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'Before calling Create_Downtime_visit');

1049: p_visit_id => l_visit_id2,
1050: x_return_status => l_return_status);
1051: END IF;--IF(l_visit_id2 is not null) then
1052: IF (l_log_statement >= l_log_current_level) THEN
1053: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'Before calling Create_Downtime_visit');
1054: END IF;
1055: l_oper_param_rec.visit_type_code := get_oper_param_rec.visit_type_code;
1056: l_oper_param_rec.alternate_dep_id := get_oper_param_rec.alternate_dep_id;
1057: l_oper_param_rec.autovst_oper_id := get_oper_param_rec.autovst_oper_id;

Line 1073: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'After calling Create_Downtime_visit and l_return_status: '||l_return_status);

1069: x_msg_count => l_msg_count,
1070: x_msg_data => l_msg_data
1071: );
1072: IF (l_log_statement >= l_log_current_level) THEN
1073: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'After calling Create_Downtime_visit and l_return_status: '||l_return_status);
1074: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'l_is_creation_success: '||l_is_creation_success);
1075: END IF;
1076:
1077: IF l_is_creation_success<>'Y' THEN

Line 1074: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'l_is_creation_success: '||l_is_creation_success);

1070: x_msg_data => l_msg_data
1071: );
1072: IF (l_log_statement >= l_log_current_level) THEN
1073: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'After calling Create_Downtime_visit and l_return_status: '||l_return_status);
1074: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'l_is_creation_success: '||l_is_creation_success);
1075: END IF;
1076:
1077: IF l_is_creation_success<>'Y' THEN
1078: ROLLBACK TO OPER_VISIT_CREATION;

Line 1100: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'Before Type 11 and before calling Create_Arrival_visit');

1096: FETCH get_oper_param_rows1 INTO get_oper_param_rec;
1097: IF get_oper_param_rows1%FOUND THEN
1098: --TYPE 11: Arrival Org :: no visit to cancel :: create an arrival visit
1099: IF (l_log_statement >= l_log_current_level) THEN
1100: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'Before Type 11 and before calling Create_Arrival_visit');
1101: END IF;
1102: l_oper_param_rec.visit_type_code := get_oper_param_rec.visit_type_code;
1103: l_oper_param_rec.mc_id := get_oper_param_rec.mc_id;
1104: l_oper_param_rec.alternate_dep_id := get_oper_param_rec.alternate_dep_id;

Line 1120: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'After calling Create_Arrival_visit and l_return_status: '||l_return_status);

1116: x_msg_count => l_msg_count,
1117: x_msg_data => l_msg_data
1118: );
1119: IF (l_log_statement >= l_log_current_level) THEN
1120: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'After calling Create_Arrival_visit and l_return_status: '||l_return_status);
1121: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'l_is_creation_success: '||l_is_creation_success);
1122: END IF;
1123:
1124: IF l_is_creation_success<>'Y' THEN

Line 1121: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'l_is_creation_success: '||l_is_creation_success);

1117: x_msg_data => l_msg_data
1118: );
1119: IF (l_log_statement >= l_log_current_level) THEN
1120: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'After calling Create_Arrival_visit and l_return_status: '||l_return_status);
1121: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'l_is_creation_success: '||l_is_creation_success);
1122: END IF;
1123:
1124: IF l_is_creation_success<>'Y' THEN
1125: ROLLBACK TO OPER_VISIT_CREATION;

Line 1152: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'Before Type 12 ');

1148: IF l_visit_type_code <> get_oper_param_rec.visit_type_code THEN
1149: -- if it does not match then cancel the existing downtime visit with id 'l_visit_id'
1150: -- and create a downtime visit
1151: IF (l_log_statement >= l_log_current_level) THEN
1152: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'Before Type 12 ');
1153: END IF;
1154: --TYPE 12: Arrival Org :: cancel existing downtime visit :: create a downtime visit
1155: Delete_Oper_Visit(
1156: p_visit_id => l_visit_id,

Line 1159: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'Before calling Create_Downtime_visit');

1155: Delete_Oper_Visit(
1156: p_visit_id => l_visit_id,
1157: x_return_status => l_return_status);
1158: IF (l_log_statement >= l_log_current_level) THEN
1159: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'Before calling Create_Downtime_visit');
1160: END IF;
1161: l_oper_param_rec.visit_type_code := get_oper_param_rec.visit_type_code;
1162: l_oper_param_rec.alternate_dep_id := get_oper_param_rec.alternate_dep_id;
1163: l_oper_param_rec.autovst_oper_id := get_oper_param_rec.autovst_oper_id;

Line 1180: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'After calling Create_Downtime_visit and l_return_status: '||l_return_status);

1176: x_msg_data => l_msg_data
1177: );
1178:
1179: IF (l_log_statement >= l_log_current_level) THEN
1180: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'After calling Create_Downtime_visit and l_return_status: '||l_return_status);
1181: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'l_is_creation_success: '||l_is_creation_success);
1182: END IF;
1183:
1184: IF l_is_creation_success<>'Y' THEN

Line 1181: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'l_is_creation_success: '||l_is_creation_success);

1177: );
1178:
1179: IF (l_log_statement >= l_log_current_level) THEN
1180: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'After calling Create_Downtime_visit and l_return_status: '||l_return_status);
1181: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'l_is_creation_success: '||l_is_creation_success);
1182: END IF;
1183:
1184: IF l_is_creation_success<>'Y' THEN
1185: ROLLBACK TO OPER_VISIT_CREATION;

Line 1222: fnd_log.string(l_log_procedure,

1218: p_data => x_msg_data
1219: );
1220:
1221: IF (l_log_procedure >= l_log_current_level) THEN
1222: fnd_log.string(l_log_procedure,
1223: L_DEBUG_KEY ||'.end',
1224: 'At the end of PL SQL procedure. Return Status = ' || x_return_status);
1225: END IF;
1226:

Line 1363: fnd_log.string(l_log_procedure,

1359:
1360: BEGIN
1361:
1362: IF (l_log_procedure >= l_log_current_level) THEN
1363: fnd_log.string(l_log_procedure,
1364: L_DEBUG_KEY ||'.begin',
1365: 'At the start of PL SQL function.');
1366: END IF;
1367:

Line 1369: fnd_log.string(l_log_statement,L_DEBUG_KEY, ' Flight schedule id: ' || p_fs_id||' , type: '||p_fs_type);

1365: 'At the start of PL SQL function.');
1366: END IF;
1367:
1368: IF (l_log_statement >= l_log_current_level) THEN
1369: fnd_log.string(l_log_statement,L_DEBUG_KEY, ' Flight schedule id: ' || p_fs_id||' , type: '||p_fs_type);
1370: END IF;
1371:
1372: IF p_fs_type = 'P' THEN -- we are processing visits associated to the departure org of the flight schedule
1373: OPEN c_is_visit_departure (p_fs_id);

Line 1433: fnd_log.string(l_log_statement,L_DEBUG_KEY, ' l_visit_type = ' || l_visit_type||',x_visit_id: '||x_visit_id||', x_visit_id2: '||x_visit_id2);

1429: END IF;
1430: END IF;
1431:
1432: IF (l_log_statement >= l_log_current_level) THEN
1433: fnd_log.string(l_log_statement,L_DEBUG_KEY, ' l_visit_type = ' || l_visit_type||',x_visit_id: '||x_visit_id||', x_visit_id2: '||x_visit_id2);
1434: END IF;
1435:
1436: IF (l_log_procedure >= l_log_current_level) THEN
1437: fnd_log.string(l_log_procedure,

Line 1437: fnd_log.string(l_log_procedure,

1433: fnd_log.string(l_log_statement,L_DEBUG_KEY, ' l_visit_type = ' || l_visit_type||',x_visit_id: '||x_visit_id||', x_visit_id2: '||x_visit_id2);
1434: END IF;
1435:
1436: IF (l_log_procedure >= l_log_current_level) THEN
1437: fnd_log.string(l_log_procedure,
1438: L_DEBUG_KEY ||'.end',
1439: 'At the end of PL SQL function.');
1440: END IF;
1441: x_vst_typ := l_visit_type;

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

1692: l_is_org_in_curr_OU VARCHAR2(1);
1693:
1694: BEGIN
1695:
1696: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
1697: fnd_log.string
1698: (
1699: fnd_log.level_procedure,
1700: 'ahl.plsql.AHL_AVF_OPER_VSTS_PVT.Update_Oper_Visit.begin',

Line 1697: fnd_log.string

1693:
1694: BEGIN
1695:
1696: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
1697: fnd_log.string
1698: (
1699: fnd_log.level_procedure,
1700: 'ahl.plsql.AHL_AVF_OPER_VSTS_PVT.Update_Oper_Visit.begin',
1701: 'At the start of PLSQL procedure'

Line 1699: fnd_log.level_procedure,

1695:
1696: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
1697: fnd_log.string
1698: (
1699: fnd_log.level_procedure,
1700: 'ahl.plsql.AHL_AVF_OPER_VSTS_PVT.Update_Oper_Visit.begin',
1701: 'At the start of PLSQL procedure'
1702: );
1703: END IF;

Line 1743: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'assoc_visits_rec.visit_id is: '||assoc_visits_rec.visit_id||

1739:
1740: -- For each flight schedule, get all the visits IDs associated
1741: FOR assoc_visits_rec IN get_assoc_visits(flight_schedule_rec.UNIT_SCHEDULE_ID) LOOP
1742: IF (l_log_statement >= l_log_current_level) THEN
1743: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'assoc_visits_rec.visit_id is: '||assoc_visits_rec.visit_id||
1744: ', assoc_visits_rec.AUTO_VISIT_TYPE_FLAG: '||assoc_visits_rec.AUTO_VISIT_TYPE_FLAG||', assoc_visits_rec.organization_id: '||assoc_visits_rec.organization_id
1745: ||', flight_schedule_rec.departure_org_id: '||flight_schedule_rec.departure_org_id||', flight_schedule_rec.arrival_org_id: '||flight_schedule_rec.arrival_org_id);
1746: END IF;
1747:

Line 1766: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'inside else assoc_visits_rec.visit_id is: '||assoc_visits_rec.visit_id);

1762: -- If the visit is either firm/locked or not in planning status then disassociate the visit from the flight schedule
1763: ELSE
1764: --PRAKKUM :: 01/08/2012 :: Added procedure :: START
1765: IF (l_log_statement >= l_log_current_level) THEN
1766: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'inside else assoc_visits_rec.visit_id is: '||assoc_visits_rec.visit_id);
1767: END IF;
1768:
1769: Disconnect_Flight_Visit(
1770: p_visit_id => assoc_visits_rec.visit_id,

Line 1777: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'After calling Disconnect_Flight_Visit and l_return_status: '||l_return_status);

1773: x_msg_count => l_msg_count,
1774: x_msg_data => l_msg_data
1775: );
1776: IF (l_log_statement >= l_log_current_level) THEN
1777: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'After calling Disconnect_Flight_Visit and l_return_status: '||l_return_status);
1778: END IF;
1779:
1780: IF l_msg_count > 0 OR NVL(l_return_status,'x') <> FND_API.G_RET_STS_SUCCESS THEN
1781: x_msg_count := l_msg_count;

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

1793:
1794: -- Now we have handled all the scenarios where the organization of the FS is updated. Next step is to look into
1795: -- the departure and arrival timings update
1796: -- CASE I: First consider the departing org of the flight schedule record
1797: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1798: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'CASE 1, flight_schedule_rec.unit_schedule_id= '||flight_schedule_rec.unit_schedule_id );
1799: END IF;
1800:
1801: OPEN get_non_null_org_count(flight_schedule_rec.unit_config_header_id,flight_schedule_rec.departure_org_id);

Line 1798: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'CASE 1, flight_schedule_rec.unit_schedule_id= '||flight_schedule_rec.unit_schedule_id );

1794: -- Now we have handled all the scenarios where the organization of the FS is updated. Next step is to look into
1795: -- the departure and arrival timings update
1796: -- CASE I: First consider the departing org of the flight schedule record
1797: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1798: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'CASE 1, flight_schedule_rec.unit_schedule_id= '||flight_schedule_rec.unit_schedule_id );
1799: END IF;
1800:
1801: OPEN get_non_null_org_count(flight_schedule_rec.unit_config_header_id,flight_schedule_rec.departure_org_id);
1802: FETCH get_non_null_org_count INTO l_count_org;

Line 1823: fnd_log.string(l_log_statement,L_DEBUG_KEY, ' There is an existing departure visit at dep org, do nothing');

1819: --If the flight schedule does not have any preceeding event then
1820: IF ( flight_schedule_rec.preceding_us_id IS NULL ) THEN
1821: IF substr (l_visit_type,1,1) = 'D' THEN --there is a visit at the departing org of the current FS
1822: IF (l_log_statement >= l_log_current_level) THEN
1823: fnd_log.string(l_log_statement,L_DEBUG_KEY, ' There is an existing departure visit at dep org, do nothing');
1824: END IF;
1825: -- based on the profile value see if you can adjust the visit dates
1826: OPEN get_visit_end_time(l_visit_id);
1827: FETCH get_visit_end_time INTO l_visit_end_time;

Line 1840: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'l_visit_end_time is: '||l_visit_end_time||' ,est_departure_time: '||flight_schedule_rec.est_departure_time||', l_can_update_visit is: '||l_can_update_visit);

1836: FETCH can_cancel_visit INTO l_can_update_visit;
1837: CLOSE can_cancel_visit;
1838:
1839: IF (l_log_statement >= l_log_current_level) THEN
1840: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'l_visit_end_time is: '||l_visit_end_time||' ,est_departure_time: '||flight_schedule_rec.est_departure_time||', l_can_update_visit is: '||l_can_update_visit);
1841: END IF;
1842:
1843: IF flight_schedule_rec.est_departure_time > l_visit_end_time THEN
1844: l_difference_dep_time := (flight_schedule_rec.est_departure_time - l_visit_end_time)*24*60;

Line 1850: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'l_difference_dep_time is: '||l_difference_dep_time);

1846: l_difference_dep_time := (l_visit_end_time - flight_schedule_rec.est_departure_time)*24*60;
1847: END IF;
1848:
1849: IF (l_log_statement >= l_log_current_level) THEN
1850: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'l_difference_dep_time is: '||l_difference_dep_time);
1851: END IF;
1852:
1853: IF l_profile_varchar is not null THEN
1854: l_profile_number := to_number(l_profile_varchar) ;

Line 1872: fnd_log.string(l_log_statement,L_DEBUG_KEY, ' Before type 1 ');

1868: -- TCHIMIRA : Bug 13844759 : check if the visit is updateable.
1869: -- if yes, the update the visit else diconnect the visit
1870: IF l_can_update_visit IS NOT NULL THEN
1871: IF (l_log_statement >= l_log_current_level) THEN
1872: fnd_log.string(l_log_statement,L_DEBUG_KEY, ' Before type 1 ');
1873: END IF;
1874: --TYPE 1: Departure Org :: dep visit at dep org of current FS :: Update the departure visit dates
1875: l_start_date := (flight_schedule_rec.est_departure_time - l_visit_type_duration/24);
1876: l_end_date := flight_schedule_rec.est_departure_time;

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

1886: CLOSE c_Visit;
1887: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
1888: Fnd_Message.set_name('AHL', 'AHL_API_RECORD_NOT_FOUND');
1889: Fnd_Msg_Pub.ADD;
1890: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1891: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Visit not found for - ' ||l_visit_rec.visit_id );
1892: END IF;
1893: END IF;
1894: RAISE Fnd_Api.g_exc_error;

Line 1891: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Visit not found for - ' ||l_visit_rec.visit_id );

1887: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
1888: Fnd_Message.set_name('AHL', 'AHL_API_RECORD_NOT_FOUND');
1889: Fnd_Msg_Pub.ADD;
1890: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1891: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Visit not found for - ' ||l_visit_rec.visit_id );
1892: END IF;
1893: END IF;
1894: RAISE Fnd_Api.g_exc_error;
1895: ELSE

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

1909: l_visit_rec.ORGANIZATION_ID := c_Visit_rec.ORGANIZATION_ID;
1910: l_visit_rec.DEPARTMENT_ID := c_Visit_rec.DEPARTMENT_ID;
1911: l_visit_rec.AUTO_VISIT_TYPE_FLAG := c_Visit_rec.AUTO_VISIT_TYPE_FLAG; --TCHIMIRA :: 14-Jun-2012 :: ER 14015560
1912:
1913: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1914: fnd_log.string
1915: ( fnd_log.level_procedure,
1916: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1917: 'Before calling AHL_VWP_VISITS_PVT.Update_Visit autovst_oper_id: '||get_oper_param_rec.autovst_oper_id||', l_visit_rec.START_DATE: '||l_visit_rec.START_DATE);

Line 1914: fnd_log.string

1910: l_visit_rec.DEPARTMENT_ID := c_Visit_rec.DEPARTMENT_ID;
1911: l_visit_rec.AUTO_VISIT_TYPE_FLAG := c_Visit_rec.AUTO_VISIT_TYPE_FLAG; --TCHIMIRA :: 14-Jun-2012 :: ER 14015560
1912:
1913: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1914: fnd_log.string
1915: ( fnd_log.level_procedure,
1916: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1917: 'Before calling AHL_VWP_VISITS_PVT.Update_Visit autovst_oper_id: '||get_oper_param_rec.autovst_oper_id||', l_visit_rec.START_DATE: '||l_visit_rec.START_DATE);
1918: END IF;

Line 1915: ( fnd_log.level_procedure,

1911: l_visit_rec.AUTO_VISIT_TYPE_FLAG := c_Visit_rec.AUTO_VISIT_TYPE_FLAG; --TCHIMIRA :: 14-Jun-2012 :: ER 14015560
1912:
1913: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1914: fnd_log.string
1915: ( fnd_log.level_procedure,
1916: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1917: 'Before calling AHL_VWP_VISITS_PVT.Update_Visit autovst_oper_id: '||get_oper_param_rec.autovst_oper_id||', l_visit_rec.START_DATE: '||l_visit_rec.START_DATE);
1918: END IF;
1919: AHL_VWP_VISITS_PVT.Update_Visit (

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

1927: x_msg_count => l_msg_count,
1928: x_msg_data => l_msg_data
1929: );
1930:
1931: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1932: fnd_log.string
1933: ( fnd_log.level_procedure,
1934: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1935: 'After calling AHL_VWP_VISITS_PVT.Update_Visit, l_return_status= '||l_return_status||', visit id= '||l_visit_rec.visit_id);

Line 1932: fnd_log.string

1928: x_msg_data => l_msg_data
1929: );
1930:
1931: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1932: fnd_log.string
1933: ( fnd_log.level_procedure,
1934: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1935: 'After calling AHL_VWP_VISITS_PVT.Update_Visit, l_return_status= '||l_return_status||', visit id= '||l_visit_rec.visit_id);
1936: END IF;

Line 1933: ( fnd_log.level_procedure,

1929: );
1930:
1931: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1932: fnd_log.string
1933: ( fnd_log.level_procedure,
1934: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1935: 'After calling AHL_VWP_VISITS_PVT.Update_Visit, l_return_status= '||l_return_status||', visit id= '||l_visit_rec.visit_id);
1936: END IF;
1937: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

Line 1940: fnd_log.string(l_log_statement,

1936: END IF;
1937: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1938: x_msg_count := FND_MSG_PUB.count_msg;
1939: IF (l_log_statement >= l_log_current_level) THEN
1940: fnd_log.string(l_log_statement,
1941: L_DEBUG_KEY,
1942: 'Errors from Update_Visit. Message count: ' || x_msg_count);
1943: END IF;
1944: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

Line 1960: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'After calling Disconnect_Flight_Visit and l_return_status: '||l_return_status);

1956: x_msg_count => l_msg_count,
1957: x_msg_data => l_msg_data
1958: );
1959: IF (l_log_statement >= l_log_current_level) THEN
1960: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'After calling Disconnect_Flight_Visit and l_return_status: '||l_return_status);
1961: END IF;
1962:
1963: IF l_msg_count > 0 OR NVL(l_return_status,'x') <> FND_API.G_RET_STS_SUCCESS THEN
1964: x_msg_count := l_msg_count;

Line 2002: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'Before Type 2 and before calling Create_Departure_visit');

1998: IF get_oper_param_rows1%FOUND THEN
1999: -- there is a possibility to create a departure visit
2000: --TYPE 2: Departure Org :: no dep visit associated to current FS dep org :: create a departure visit
2001: IF (l_log_statement >= l_log_current_level) THEN
2002: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'Before Type 2 and before calling Create_Departure_visit');
2003: END IF;
2004: l_oper_param_rec.visit_type_code := get_oper_param_rec.visit_type_code;
2005: l_oper_param_rec.mc_id := get_oper_param_rec.mc_id;
2006: l_oper_param_rec.alternate_dep_id := get_oper_param_rec.alternate_dep_id;

Line 2022: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'After calling Create_Departure_visit and l_return_status: '||l_return_status);

2018: x_msg_count => l_msg_count,
2019: x_msg_data => l_msg_data
2020: );
2021: IF (l_log_statement >= l_log_current_level) THEN
2022: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'After calling Create_Departure_visit and l_return_status: '||l_return_status);
2023: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'l_is_creation_success: '||l_is_creation_success);
2024: END IF;
2025:
2026: IF l_is_creation_success<>'Y' THEN

Line 2023: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'l_is_creation_success: '||l_is_creation_success);

2019: x_msg_data => l_msg_data
2020: );
2021: IF (l_log_statement >= l_log_current_level) THEN
2022: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'After calling Create_Departure_visit and l_return_status: '||l_return_status);
2023: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'l_is_creation_success: '||l_is_creation_success);
2024: END IF;
2025:
2026: IF l_is_creation_success<>'Y' THEN
2027: ROLLBACK TO OPER_VISIT_CREATION;

Line 2050: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'After calling load_can_cancel_visit and l_return_status: '||l_return_status);

2046: x_msg_data => l_msg_data
2047:
2048: );
2049: IF (l_log_statement >= l_log_current_level) THEN
2050: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'After calling load_can_cancel_visit and l_return_status: '||l_return_status);
2051: END IF;
2052:
2053: OPEN get_pre_fs_det(flight_schedule_rec.preceding_us_id);
2054: FETCH get_pre_fs_det INTO pre_fs_det_rec;

Line 2070: fnd_log.string(l_log_statement,L_DEBUG_KEY, ' There is an existing departure visit at dep org, do nothing');

2066: IF substr (l_visit_type,1,1) = 'D' THEN -- if there is a visit
2067: IF l_visit_id IS NOT NULL THEN
2068:
2069: IF (l_log_statement >= l_log_current_level) THEN
2070: fnd_log.string(l_log_statement,L_DEBUG_KEY, ' There is an existing departure visit at dep org, do nothing');
2071: END IF;
2072: -- based on the profile value see if you can adjust the visit dates
2073: OPEN get_visit_end_time(l_visit_id);
2074: FETCH get_visit_end_time INTO l_visit_end_time;

Line 2087: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'l_visit_end_time is: '||l_visit_end_time||' ,est_departure_time: '||flight_schedule_rec.est_departure_time||', l_can_update_visit is: '||l_can_update_visit);

2083: FETCH can_cancel_visit INTO l_can_update_visit;
2084: CLOSE can_cancel_visit;
2085:
2086: IF (l_log_statement >= l_log_current_level) THEN
2087: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'l_visit_end_time is: '||l_visit_end_time||' ,est_departure_time: '||flight_schedule_rec.est_departure_time||', l_can_update_visit is: '||l_can_update_visit);
2088: END IF;
2089:
2090: IF flight_schedule_rec.est_departure_time > l_visit_end_time THEN
2091: l_difference_dep_time := (flight_schedule_rec.est_departure_time - l_visit_end_time)*24*60;

Line 2097: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'l_difference_dep_time is: '||l_difference_dep_time);

2093: l_difference_dep_time := (l_visit_end_time - flight_schedule_rec.est_departure_time)*24*60;
2094: END IF;
2095:
2096: IF (l_log_statement >= l_log_current_level) THEN
2097: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'l_difference_dep_time is: '||l_difference_dep_time);
2098: END IF;
2099:
2100: IF l_profile_varchar is not null THEN
2101: l_profile_number := to_number(l_profile_varchar) ;

Line 2119: fnd_log.string(l_log_statement,L_DEBUG_KEY, ' Before type 1 ');

2115: -- TCHIMIRA : Bug 13844759 : check if the visit is updateable.
2116: -- if yes, the update the visit else diconnect the visit
2117: IF l_can_update_visit IS NOT NULL THEN
2118: IF (l_log_statement >= l_log_current_level) THEN
2119: fnd_log.string(l_log_statement,L_DEBUG_KEY, ' Before type 1 ');
2120: END IF;
2121: --TYPE 1: Departure Org :: dep visit at dep org of current FS :: Update the departure visit dates
2122: l_start_date := (flight_schedule_rec.est_departure_time - l_visit_type_duration/24);
2123: l_end_date := flight_schedule_rec.est_departure_time;

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

2133: CLOSE c_Visit;
2134: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
2135: Fnd_Message.set_name('AHL', 'AHL_API_RECORD_NOT_FOUND');
2136: Fnd_Msg_Pub.ADD;
2137: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2138: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Visit not found for - ' ||l_visit_rec.visit_id );
2139: END IF;
2140: END IF;
2141: RAISE Fnd_Api.g_exc_error;

Line 2138: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Visit not found for - ' ||l_visit_rec.visit_id );

2134: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
2135: Fnd_Message.set_name('AHL', 'AHL_API_RECORD_NOT_FOUND');
2136: Fnd_Msg_Pub.ADD;
2137: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2138: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Visit not found for - ' ||l_visit_rec.visit_id );
2139: END IF;
2140: END IF;
2141: RAISE Fnd_Api.g_exc_error;
2142: ELSE

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

2156: l_visit_rec.ORGANIZATION_ID := c_Visit_rec.ORGANIZATION_ID;
2157: l_visit_rec.DEPARTMENT_ID := c_Visit_rec.DEPARTMENT_ID;
2158: l_visit_rec.AUTO_VISIT_TYPE_FLAG := c_Visit_rec.AUTO_VISIT_TYPE_FLAG; --TCHIMIRA :: 14-Jun-2012 :: ER 14015560
2159:
2160: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
2161: fnd_log.string
2162: ( fnd_log.level_procedure,
2163: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
2164: 'Before calling AHL_VWP_VISITS_PVT.Update_Visit autovst_oper_id: '||get_oper_param_rec.autovst_oper_id||', l_visit_rec.START_DATE: '||l_visit_rec.START_DATE);

Line 2161: fnd_log.string

2157: l_visit_rec.DEPARTMENT_ID := c_Visit_rec.DEPARTMENT_ID;
2158: l_visit_rec.AUTO_VISIT_TYPE_FLAG := c_Visit_rec.AUTO_VISIT_TYPE_FLAG; --TCHIMIRA :: 14-Jun-2012 :: ER 14015560
2159:
2160: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
2161: fnd_log.string
2162: ( fnd_log.level_procedure,
2163: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
2164: 'Before calling AHL_VWP_VISITS_PVT.Update_Visit autovst_oper_id: '||get_oper_param_rec.autovst_oper_id||', l_visit_rec.START_DATE: '||l_visit_rec.START_DATE);
2165: END IF;

Line 2162: ( fnd_log.level_procedure,

2158: l_visit_rec.AUTO_VISIT_TYPE_FLAG := c_Visit_rec.AUTO_VISIT_TYPE_FLAG; --TCHIMIRA :: 14-Jun-2012 :: ER 14015560
2159:
2160: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
2161: fnd_log.string
2162: ( fnd_log.level_procedure,
2163: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
2164: 'Before calling AHL_VWP_VISITS_PVT.Update_Visit autovst_oper_id: '||get_oper_param_rec.autovst_oper_id||', l_visit_rec.START_DATE: '||l_visit_rec.START_DATE);
2165: END IF;
2166: AHL_VWP_VISITS_PVT.Update_Visit (

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

2174: x_msg_count => l_msg_count,
2175: x_msg_data => l_msg_data
2176: );
2177:
2178: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
2179: fnd_log.string
2180: ( fnd_log.level_procedure,
2181: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
2182: 'After calling AHL_VWP_VISITS_PVT.Update_Visit, l_return_status= '||l_return_status||', visit id= '||l_visit_rec.visit_id);

Line 2179: fnd_log.string

2175: x_msg_data => l_msg_data
2176: );
2177:
2178: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
2179: fnd_log.string
2180: ( fnd_log.level_procedure,
2181: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
2182: 'After calling AHL_VWP_VISITS_PVT.Update_Visit, l_return_status= '||l_return_status||', visit id= '||l_visit_rec.visit_id);
2183: END IF;

Line 2180: ( fnd_log.level_procedure,

2176: );
2177:
2178: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
2179: fnd_log.string
2180: ( fnd_log.level_procedure,
2181: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
2182: 'After calling AHL_VWP_VISITS_PVT.Update_Visit, l_return_status= '||l_return_status||', visit id= '||l_visit_rec.visit_id);
2183: END IF;
2184: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

Line 2187: fnd_log.string(l_log_statement,

2183: END IF;
2184: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2185: x_msg_count := FND_MSG_PUB.count_msg;
2186: IF (l_log_statement >= l_log_current_level) THEN
2187: fnd_log.string(l_log_statement,
2188: L_DEBUG_KEY,
2189: 'Errors from Update_Visit. Message count: ' || x_msg_count);
2190: END IF;
2191: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

Line 2207: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'After calling Disconnect_Flight_Visit and l_return_status: '||l_return_status);

2203: x_msg_count => l_msg_count,
2204: x_msg_data => l_msg_data
2205: );
2206: IF (l_log_statement >= l_log_current_level) THEN
2207: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'After calling Disconnect_Flight_Visit and l_return_status: '||l_return_status);
2208: END IF;
2209:
2210: IF l_msg_count > 0 OR NVL(l_return_status,'x') <> FND_API.G_RET_STS_SUCCESS THEN
2211: x_msg_count := l_msg_count;

Line 2239: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'After calling load_can_cancel_visit and l_return_status: '||l_return_status);

2235: x_msg_count => l_msg_count,
2236: x_msg_data => l_msg_data
2237: );
2238: IF (l_log_statement >= l_log_current_level) THEN
2239: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'After calling load_can_cancel_visit and l_return_status: '||l_return_status);
2240: END IF;
2241:
2242: -- PRAKKUM :: Bug 14368696 :: 01/08/2012 :: START
2243: IF (l_can_cancel_visit2 IS NULL) THEN -- If downtime or arrival is not allowed to cancel

Line 2247: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'Handle case that downtime visit not allowed to cancel--@>');

2243: IF (l_can_cancel_visit2 IS NULL) THEN -- If downtime or arrival is not allowed to cancel
2244: IF substr (l_visit_type,1,1) = 'T' AND l_visit_id2 IS NOT NULL THEN --Downtime visit exists
2245:
2246: IF (l_log_statement >= l_log_current_level) THEN
2247: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'Handle case that downtime visit not allowed to cancel--@>');
2248: END IF;
2249:
2250: --Get ground time at the departing org of a FS
2251: OPEN get_ground_time (flight_schedule_rec.preceding_us_id, flight_schedule_rec.UNIT_SCHEDULE_ID);

Line 2307: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'l_difference_dep_time--@>'||l_difference_dep_time);

2303: l_profile_number2 := flight_schedule_rec.est_departure_time-sysdate+1;
2304: END IF;
2305:
2306: IF (l_log_statement >= l_log_current_level) THEN
2307: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'l_difference_dep_time--@>'||l_difference_dep_time);
2308: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'l_profile_number--@>'||l_profile_number);
2309: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'l_profile_number2--@>'||l_profile_number);
2310: fnd_log.string(l_log_statement,L_DEBUG_KEY, '(sysdate + l_profile_number2)--@>'||(cast((sysdate + l_profile_number2) AS timestamp)));
2311: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'flight_schedule_rec.est_departure_time--@>'||(cast((flight_schedule_rec.est_departure_time) AS timestamp)));

Line 2308: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'l_profile_number--@>'||l_profile_number);

2304: END IF;
2305:
2306: IF (l_log_statement >= l_log_current_level) THEN
2307: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'l_difference_dep_time--@>'||l_difference_dep_time);
2308: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'l_profile_number--@>'||l_profile_number);
2309: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'l_profile_number2--@>'||l_profile_number);
2310: fnd_log.string(l_log_statement,L_DEBUG_KEY, '(sysdate + l_profile_number2)--@>'||(cast((sysdate + l_profile_number2) AS timestamp)));
2311: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'flight_schedule_rec.est_departure_time--@>'||(cast((flight_schedule_rec.est_departure_time) AS timestamp)));
2312: END IF;

Line 2309: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'l_profile_number2--@>'||l_profile_number);

2305:
2306: IF (l_log_statement >= l_log_current_level) THEN
2307: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'l_difference_dep_time--@>'||l_difference_dep_time);
2308: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'l_profile_number--@>'||l_profile_number);
2309: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'l_profile_number2--@>'||l_profile_number);
2310: fnd_log.string(l_log_statement,L_DEBUG_KEY, '(sysdate + l_profile_number2)--@>'||(cast((sysdate + l_profile_number2) AS timestamp)));
2311: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'flight_schedule_rec.est_departure_time--@>'||(cast((flight_schedule_rec.est_departure_time) AS timestamp)));
2312: END IF;
2313:

Line 2310: fnd_log.string(l_log_statement,L_DEBUG_KEY, '(sysdate + l_profile_number2)--@>'||(cast((sysdate + l_profile_number2) AS timestamp)));

2306: IF (l_log_statement >= l_log_current_level) THEN
2307: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'l_difference_dep_time--@>'||l_difference_dep_time);
2308: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'l_profile_number--@>'||l_profile_number);
2309: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'l_profile_number2--@>'||l_profile_number);
2310: fnd_log.string(l_log_statement,L_DEBUG_KEY, '(sysdate + l_profile_number2)--@>'||(cast((sysdate + l_profile_number2) AS timestamp)));
2311: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'flight_schedule_rec.est_departure_time--@>'||(cast((flight_schedule_rec.est_departure_time) AS timestamp)));
2312: END IF;
2313:
2314: IF((l_difference_dep_time > l_profile_number)

Line 2311: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'flight_schedule_rec.est_departure_time--@>'||(cast((flight_schedule_rec.est_departure_time) AS timestamp)));

2307: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'l_difference_dep_time--@>'||l_difference_dep_time);
2308: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'l_profile_number--@>'||l_profile_number);
2309: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'l_profile_number2--@>'||l_profile_number);
2310: fnd_log.string(l_log_statement,L_DEBUG_KEY, '(sysdate + l_profile_number2)--@>'||(cast((sysdate + l_profile_number2) AS timestamp)));
2311: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'flight_schedule_rec.est_departure_time--@>'||(cast((flight_schedule_rec.est_departure_time) AS timestamp)));
2312: END IF;
2313:
2314: IF((l_difference_dep_time > l_profile_number)
2315: AND (l_difference_dep_time <> 0)

Line 2337: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'After calling Disconnect_Flight_Visit and l_return_status: '||l_return_status);

2333: x_msg_count => l_msg_count,
2334: x_msg_data => l_msg_data
2335: );
2336: IF (l_log_statement >= l_log_current_level) THEN
2337: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'After calling Disconnect_Flight_Visit and l_return_status: '||l_return_status);
2338: END IF;
2339:
2340: IF l_msg_count > 0 OR NVL(l_return_status,'x') <> FND_API.G_RET_STS_SUCCESS THEN
2341: x_msg_count := l_msg_count;

Line 2367: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'After calling load_can_cancel_visit and l_return_status: '||l_return_status);

2363: x_msg_count => l_msg_count,
2364: x_msg_data => l_msg_data
2365: );
2366: IF (l_log_statement >= l_log_current_level) THEN
2367: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'After calling load_can_cancel_visit and l_return_status: '||l_return_status);
2368: END IF;
2369: -- PRAKKUM :: Bug 14368696 :: 01/08/2012 :: END
2370:
2371: -- if preceding arrival flight visit can not be cancelled and there is no visit associated to departure org of current FS

Line 2434: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'l_difference_dep_time--@>'||l_difference_dep_time);

2430: l_profile_number2 := flight_schedule_rec.est_departure_time-sysdate+1;
2431: END IF;
2432:
2433: IF (l_log_statement >= l_log_current_level) THEN --PRAKKUM :: Bug 14342603 :: 18/07/2012
2434: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'l_difference_dep_time--@>'||l_difference_dep_time);
2435: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'l_profile_number--@>'||l_profile_number);
2436: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'l_profile_number2--@>'||l_profile_number);
2437: fnd_log.string(l_log_statement,L_DEBUG_KEY, '(sysdate + l_profile_number2)--@>'||(cast((sysdate + l_profile_number2) AS timestamp)));
2438: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'flight_schedule_rec.est_departure_time--@>'||(cast((flight_schedule_rec.est_departure_time) AS timestamp)));

Line 2435: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'l_profile_number--@>'||l_profile_number);

2431: END IF;
2432:
2433: IF (l_log_statement >= l_log_current_level) THEN --PRAKKUM :: Bug 14342603 :: 18/07/2012
2434: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'l_difference_dep_time--@>'||l_difference_dep_time);
2435: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'l_profile_number--@>'||l_profile_number);
2436: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'l_profile_number2--@>'||l_profile_number);
2437: fnd_log.string(l_log_statement,L_DEBUG_KEY, '(sysdate + l_profile_number2)--@>'||(cast((sysdate + l_profile_number2) AS timestamp)));
2438: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'flight_schedule_rec.est_departure_time--@>'||(cast((flight_schedule_rec.est_departure_time) AS timestamp)));
2439: END IF;

Line 2436: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'l_profile_number2--@>'||l_profile_number);

2432:
2433: IF (l_log_statement >= l_log_current_level) THEN --PRAKKUM :: Bug 14342603 :: 18/07/2012
2434: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'l_difference_dep_time--@>'||l_difference_dep_time);
2435: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'l_profile_number--@>'||l_profile_number);
2436: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'l_profile_number2--@>'||l_profile_number);
2437: fnd_log.string(l_log_statement,L_DEBUG_KEY, '(sysdate + l_profile_number2)--@>'||(cast((sysdate + l_profile_number2) AS timestamp)));
2438: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'flight_schedule_rec.est_departure_time--@>'||(cast((flight_schedule_rec.est_departure_time) AS timestamp)));
2439: END IF;
2440:

Line 2437: fnd_log.string(l_log_statement,L_DEBUG_KEY, '(sysdate + l_profile_number2)--@>'||(cast((sysdate + l_profile_number2) AS timestamp)));

2433: IF (l_log_statement >= l_log_current_level) THEN --PRAKKUM :: Bug 14342603 :: 18/07/2012
2434: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'l_difference_dep_time--@>'||l_difference_dep_time);
2435: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'l_profile_number--@>'||l_profile_number);
2436: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'l_profile_number2--@>'||l_profile_number);
2437: fnd_log.string(l_log_statement,L_DEBUG_KEY, '(sysdate + l_profile_number2)--@>'||(cast((sysdate + l_profile_number2) AS timestamp)));
2438: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'flight_schedule_rec.est_departure_time--@>'||(cast((flight_schedule_rec.est_departure_time) AS timestamp)));
2439: END IF;
2440:
2441: IF((l_difference_dep_time > l_profile_number)

Line 2438: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'flight_schedule_rec.est_departure_time--@>'||(cast((flight_schedule_rec.est_departure_time) AS timestamp)));

2434: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'l_difference_dep_time--@>'||l_difference_dep_time);
2435: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'l_profile_number--@>'||l_profile_number);
2436: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'l_profile_number2--@>'||l_profile_number);
2437: fnd_log.string(l_log_statement,L_DEBUG_KEY, '(sysdate + l_profile_number2)--@>'||(cast((sysdate + l_profile_number2) AS timestamp)));
2438: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'flight_schedule_rec.est_departure_time--@>'||(cast((flight_schedule_rec.est_departure_time) AS timestamp)));
2439: END IF;
2440:
2441: IF((l_difference_dep_time > l_profile_number)
2442: AND (l_difference_dep_time <> 0)

Line 2470: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'After calling Disconnect_Flight_Visit and l_return_status: '||l_return_status);

2466: x_msg_count => l_msg_count,
2467: x_msg_data => l_msg_data
2468: );
2469: IF (l_log_statement >= l_log_current_level) THEN
2470: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'After calling Disconnect_Flight_Visit and l_return_status: '||l_return_status);
2471: END IF;
2472:
2473: IF l_msg_count > 0 OR NVL(l_return_status,'x') <> FND_API.G_RET_STS_SUCCESS THEN
2474: x_msg_count := l_msg_count;

Line 2499: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'Before Type 3 and before calling Create_Departure_visit');

2495: IF get_oper_param_rows1%FOUND THEN
2496: --If there is a possibility to create a departure visit
2497: --TYPE 3: Departure Org :: no visit to cancel :: create a departure visit
2498: IF (l_log_statement >= l_log_current_level) THEN
2499: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'Before Type 3 and before calling Create_Departure_visit');
2500: END IF;
2501: l_oper_param_rec.visit_type_code := get_oper_param_rec.visit_type_code;
2502: l_oper_param_rec.mc_id := get_oper_param_rec.mc_id;
2503: l_oper_param_rec.alternate_dep_id := get_oper_param_rec.alternate_dep_id;

Line 2519: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'After calling Create_Departure_visit and l_return_status: '||l_return_status);

2515: x_msg_count => l_msg_count,
2516: x_msg_data => l_msg_data
2517: );
2518: IF (l_log_statement >= l_log_current_level) THEN
2519: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'After calling Create_Departure_visit and l_return_status: '||l_return_status);
2520: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'l_is_creation_success: '||l_is_creation_success);
2521: END IF;
2522:
2523: IF l_is_creation_success<>'Y' THEN

Line 2520: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'l_is_creation_success: '||l_is_creation_success);

2516: x_msg_data => l_msg_data
2517: );
2518: IF (l_log_statement >= l_log_current_level) THEN
2519: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'After calling Create_Departure_visit and l_return_status: '||l_return_status);
2520: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'l_is_creation_success: '||l_is_creation_success);
2521: END IF;
2522:
2523: IF l_is_creation_success<>'Y' THEN
2524: ROLLBACK TO OPER_VISIT_CREATION;

Line 2556: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'passing values are unit_config_header_id: '||pre_fs_det_rec.unit_config_header_id

2552: FETCH get_non_null_cat_count INTO l_count_prec_arr_cat;
2553: CLOSE get_non_null_cat_count;
2554:
2555: IF (l_log_statement >= l_log_current_level) THEN
2556: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'passing values are unit_config_header_id: '||pre_fs_det_rec.unit_config_header_id
2557: ||', pre_fs_det_rec.arrival_org_id: '||pre_fs_det_rec.arrival_org_id||', arrival_dept_id: , '||pre_fs_det_rec.arrival_dept_id
2558: ||', flight_category_code: ,'||pre_fs_det_rec.flight_category_code||', l_count_prec_arr_org: ,'||l_count_prec_arr_org
2559: ||', l_count_prec_arr_dep: ,'||l_count_prec_arr_dep||', l_count_prec_arr_cat: ,'
2560: ||l_count_prec_arr_cat||' ground time is '||l_ground_time);

Line 2572: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'Before Type 4');

2568: l_is_downtime_vst_created := 'Y';
2569: IF get_oper_param_rows1%FOUND THEN -- there is a possibility of creating a downtime visit at arrival org of prec FS
2570: IF l_visit_id2 is null THEN -- if there is no visit associated to the arrival org of previous FS
2571: IF (l_log_statement >= l_log_current_level) THEN
2572: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'Before Type 4');
2573: END IF;
2574:
2575: -- Bug 14336467 :: PRAKKUM :: 13/07/2012 :: START
2576: SAVEPOINT OPER_VISIT_CREATION;

Line 2586: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'Before calling Create_Downtime_visit');

2582: p_visit_id => l_visit_id,
2583: x_return_status => l_return_status);
2584: END IF;--IF(l_visit_id is not null) then
2585: IF (l_log_statement >= l_log_current_level) THEN
2586: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'Before calling Create_Downtime_visit');
2587: END IF;
2588: l_oper_param_rec.visit_type_code := get_oper_param_rec.visit_type_code;
2589: l_oper_param_rec.alternate_dep_id := get_oper_param_rec.alternate_dep_id;
2590: l_oper_param_rec.autovst_oper_id := get_oper_param_rec.autovst_oper_id;

Line 2604: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'After calling Create_Downtime_visit and l_return_status: '||l_return_status);

2600: x_msg_data => l_msg_data
2601: );
2602:
2603: IF (l_log_statement >= l_log_current_level) THEN
2604: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'After calling Create_Downtime_visit and l_return_status: '||l_return_status);
2605: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'l_is_creation_success: '||l_is_creation_success);
2606: END IF;
2607: IF l_is_creation_success<>'Y' THEN
2608: ROLLBACK TO OPER_VISIT_CREATION;

Line 2605: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'l_is_creation_success: '||l_is_creation_success);

2601: );
2602:
2603: IF (l_log_statement >= l_log_current_level) THEN
2604: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'After calling Create_Downtime_visit and l_return_status: '||l_return_status);
2605: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'l_is_creation_success: '||l_is_creation_success);
2606: END IF;
2607: IF l_is_creation_success<>'Y' THEN
2608: ROLLBACK TO OPER_VISIT_CREATION;
2609: l_is_downtime_vst_created := 'N'; -- Downtime visit creation failed, so consider for creating arrival visit

Line 2622: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'Before Type 5');

2618: IF l_visit_type_code <> get_oper_param_rec.visit_type_code THEN
2619: -- if it does not match then Cancel the visit assoc to arrival org and also if any departure visit associated
2620: -- to the dep org of current FS. then create a downtime visit
2621: IF (l_log_statement >= l_log_current_level) THEN
2622: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'Before Type 5');
2623: END IF;
2624: --TYPE 5: Departure Org :: cancel arrival visit and dep visit(if exists) :: create a downtime visit
2625: --Cancel the existing arrival visit of the prec FS since the visit types did not match
2626: Delete_Oper_Visit(

Line 2635: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'Before calling Create_Downtime_visit');

2631: p_visit_id => l_visit_id,
2632: x_return_status => l_return_status);
2633: END IF;--IF(l_visit_id is not null) then
2634: IF (l_log_statement >= l_log_current_level) THEN
2635: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'Before calling Create_Downtime_visit');
2636: END IF;
2637: l_oper_param_rec.visit_type_code := get_oper_param_rec.visit_type_code;
2638: l_oper_param_rec.alternate_dep_id := get_oper_param_rec.alternate_dep_id;
2639: l_oper_param_rec.autovst_oper_id := get_oper_param_rec.autovst_oper_id;

Line 2656: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'After calling Create_Downtime_visit and l_return_status: '||l_return_status);

2652: x_msg_data => l_msg_data
2653: );
2654:
2655: IF (l_log_statement >= l_log_current_level) THEN
2656: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'After calling Create_Downtime_visit and l_return_status: '||l_return_status);
2657: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'l_is_creation_success: '||l_is_creation_success);
2658: END IF;
2659: IF l_is_creation_success<>'Y' THEN
2660: ROLLBACK TO OPER_VISIT_CREATION;

Line 2657: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'l_is_creation_success: '||l_is_creation_success);

2653: );
2654:
2655: IF (l_log_statement >= l_log_current_level) THEN
2656: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'After calling Create_Downtime_visit and l_return_status: '||l_return_status);
2657: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'l_is_creation_success: '||l_is_creation_success);
2658: END IF;
2659: IF l_is_creation_success<>'Y' THEN
2660: ROLLBACK TO OPER_VISIT_CREATION;
2661: l_is_downtime_vst_created := 'N'; -- Downtime visit creation failed, so consider for creating arrival visit

Line 2666: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'Before Type 6');

2662: END IF;
2663: -- Bug 14336467 :: PRAKKUM :: 13/07/2012 :: END
2664: ELSE
2665: IF (l_log_statement >= l_log_current_level) THEN
2666: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'Before Type 6');
2667: END IF;
2668: --TYPE 6::Departure Org::cancel dep visit(if exists):: extend the existing visit
2669: -- If the visit type matches, we need to update the visit dates
2670: --Before updating the visit first cancel the departure visit of the current if it is not null

Line 2702: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'l_difference_dep_time--@>'||l_difference_dep_time);

2698: l_profile_number2 := flight_schedule_rec.est_departure_time-sysdate+1;
2699: END IF;
2700:
2701: IF (l_log_statement >= l_log_current_level) THEN --PRAKKUM :: Bug 14342603 :: 18/07/2012
2702: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'l_difference_dep_time--@>'||l_difference_dep_time);
2703: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'l_profile_number--@>'||l_profile_number);
2704: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'l_profile_number2--@>'||l_profile_number);
2705: fnd_log.string(l_log_statement,L_DEBUG_KEY, '(sysdate + l_profile_number2)--@>'||(cast((sysdate + l_profile_number2) AS timestamp)));
2706: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'flight_schedule_rec.est_departure_time--@>'||(cast((flight_schedule_rec.est_departure_time) AS timestamp)));

Line 2703: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'l_profile_number--@>'||l_profile_number);

2699: END IF;
2700:
2701: IF (l_log_statement >= l_log_current_level) THEN --PRAKKUM :: Bug 14342603 :: 18/07/2012
2702: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'l_difference_dep_time--@>'||l_difference_dep_time);
2703: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'l_profile_number--@>'||l_profile_number);
2704: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'l_profile_number2--@>'||l_profile_number);
2705: fnd_log.string(l_log_statement,L_DEBUG_KEY, '(sysdate + l_profile_number2)--@>'||(cast((sysdate + l_profile_number2) AS timestamp)));
2706: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'flight_schedule_rec.est_departure_time--@>'||(cast((flight_schedule_rec.est_departure_time) AS timestamp)));
2707: END IF;

Line 2704: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'l_profile_number2--@>'||l_profile_number);

2700:
2701: IF (l_log_statement >= l_log_current_level) THEN --PRAKKUM :: Bug 14342603 :: 18/07/2012
2702: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'l_difference_dep_time--@>'||l_difference_dep_time);
2703: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'l_profile_number--@>'||l_profile_number);
2704: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'l_profile_number2--@>'||l_profile_number);
2705: fnd_log.string(l_log_statement,L_DEBUG_KEY, '(sysdate + l_profile_number2)--@>'||(cast((sysdate + l_profile_number2) AS timestamp)));
2706: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'flight_schedule_rec.est_departure_time--@>'||(cast((flight_schedule_rec.est_departure_time) AS timestamp)));
2707: END IF;
2708:

Line 2705: fnd_log.string(l_log_statement,L_DEBUG_KEY, '(sysdate + l_profile_number2)--@>'||(cast((sysdate + l_profile_number2) AS timestamp)));

2701: IF (l_log_statement >= l_log_current_level) THEN --PRAKKUM :: Bug 14342603 :: 18/07/2012
2702: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'l_difference_dep_time--@>'||l_difference_dep_time);
2703: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'l_profile_number--@>'||l_profile_number);
2704: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'l_profile_number2--@>'||l_profile_number);
2705: fnd_log.string(l_log_statement,L_DEBUG_KEY, '(sysdate + l_profile_number2)--@>'||(cast((sysdate + l_profile_number2) AS timestamp)));
2706: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'flight_schedule_rec.est_departure_time--@>'||(cast((flight_schedule_rec.est_departure_time) AS timestamp)));
2707: END IF;
2708:
2709: IF((l_difference_dep_time > l_profile_number)

Line 2706: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'flight_schedule_rec.est_departure_time--@>'||(cast((flight_schedule_rec.est_departure_time) AS timestamp)));

2702: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'l_difference_dep_time--@>'||l_difference_dep_time);
2703: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'l_profile_number--@>'||l_profile_number);
2704: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'l_profile_number2--@>'||l_profile_number);
2705: fnd_log.string(l_log_statement,L_DEBUG_KEY, '(sysdate + l_profile_number2)--@>'||(cast((sysdate + l_profile_number2) AS timestamp)));
2706: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'flight_schedule_rec.est_departure_time--@>'||(cast((flight_schedule_rec.est_departure_time) AS timestamp)));
2707: END IF;
2708:
2709: IF((l_difference_dep_time > l_profile_number)
2710: AND (l_difference_dep_time <> 0)

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

2721: CLOSE c_Visit;
2722: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
2723: Fnd_Message.set_name('AHL', 'AHL_API_RECORD_NOT_FOUND');
2724: Fnd_Msg_Pub.ADD;
2725: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2726: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Visit not found for - ' ||l_visit_rec.visit_id );
2727: END IF;
2728: END IF;
2729: RAISE Fnd_Api.g_exc_error;

Line 2726: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Visit not found for - ' ||l_visit_rec.visit_id );

2722: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
2723: Fnd_Message.set_name('AHL', 'AHL_API_RECORD_NOT_FOUND');
2724: Fnd_Msg_Pub.ADD;
2725: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2726: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Visit not found for - ' ||l_visit_rec.visit_id );
2727: END IF;
2728: END IF;
2729: RAISE Fnd_Api.g_exc_error;
2730: ELSE

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

2745: l_visit_rec.ORGANIZATION_ID := c_Visit_rec.ORGANIZATION_ID;
2746: l_visit_rec.DEPARTMENT_ID := c_Visit_rec.DEPARTMENT_ID;
2747: l_visit_rec.AUTO_VISIT_TYPE_FLAG := 'T'; --TCHIMIRA :: 14-Jun-2012 :: ER 14015560
2748:
2749: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
2750: fnd_log.string
2751: ( fnd_log.level_procedure,
2752: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
2753: 'Before calling AHL_VWP_VISITS_PVT.Update_Visit autovst_oper_id: '||get_oper_param_rec.autovst_oper_id);

Line 2750: fnd_log.string

2746: l_visit_rec.DEPARTMENT_ID := c_Visit_rec.DEPARTMENT_ID;
2747: l_visit_rec.AUTO_VISIT_TYPE_FLAG := 'T'; --TCHIMIRA :: 14-Jun-2012 :: ER 14015560
2748:
2749: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
2750: fnd_log.string
2751: ( fnd_log.level_procedure,
2752: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
2753: 'Before calling AHL_VWP_VISITS_PVT.Update_Visit autovst_oper_id: '||get_oper_param_rec.autovst_oper_id);
2754: END IF;

Line 2751: ( fnd_log.level_procedure,

2747: l_visit_rec.AUTO_VISIT_TYPE_FLAG := 'T'; --TCHIMIRA :: 14-Jun-2012 :: ER 14015560
2748:
2749: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
2750: fnd_log.string
2751: ( fnd_log.level_procedure,
2752: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
2753: 'Before calling AHL_VWP_VISITS_PVT.Update_Visit autovst_oper_id: '||get_oper_param_rec.autovst_oper_id);
2754: END IF;
2755: AHL_VWP_VISITS_PVT.Update_Visit (

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

2763: x_msg_count => l_msg_count,
2764: x_msg_data => l_msg_data
2765: );
2766:
2767: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
2768: fnd_log.string
2769: ( fnd_log.level_procedure,
2770: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
2771: 'After calling AHL_VWP_VISITS_PVT.Update_Visit, l_return_status= '||l_return_status||', visit id= '||l_visit_rec.visit_id);

Line 2768: fnd_log.string

2764: x_msg_data => l_msg_data
2765: );
2766:
2767: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
2768: fnd_log.string
2769: ( fnd_log.level_procedure,
2770: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
2771: 'After calling AHL_VWP_VISITS_PVT.Update_Visit, l_return_status= '||l_return_status||', visit id= '||l_visit_rec.visit_id);
2772: END IF;

Line 2769: ( fnd_log.level_procedure,

2765: );
2766:
2767: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
2768: fnd_log.string
2769: ( fnd_log.level_procedure,
2770: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
2771: 'After calling AHL_VWP_VISITS_PVT.Update_Visit, l_return_status= '||l_return_status||', visit id= '||l_visit_rec.visit_id);
2772: END IF;
2773: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

Line 2776: fnd_log.string(l_log_statement,

2772: END IF;
2773: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2774: x_msg_count := FND_MSG_PUB.count_msg;
2775: IF (l_log_statement >= l_log_current_level) THEN
2776: fnd_log.string(l_log_statement,
2777: L_DEBUG_KEY,
2778: 'Errors from Update_Visit. Message count: ' || x_msg_count);
2779: END IF;
2780: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

Line 2798: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'Before Type 7');

2794: IF l_is_downtime_vst_created = 'N' THEN -- Downtime visit cannot be created
2795: -- if there is a visit associated to the arrival org of Prec FS
2796: IF l_visit_id2 is not null THEN
2797: IF (l_log_statement >= l_log_current_level) THEN
2798: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'Before Type 7');
2799: END IF;
2800: -- TYPE 7::Departure Org:: there is a visit assoc to arrival org of prev FS::
2801: -- we need to check the type of the visit associated to the arrival org
2802: -- it can be either arrival or downtime;

Line 2831: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'Before Type 8');

2827: END IF;-- l_visit_id2 is not null
2828: -- PRAKKUM :: Bug 13844759 :: 31/07/2012
2829: IF substr (l_visit_type,1,1) = 'D' AND l_visit_id IS NOT NULL THEN --existing visit is a departure visit
2830: IF (l_log_statement >= l_log_current_level) THEN
2831: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'Before Type 8');
2832: END IF;
2833: -- TYPE 8::Departure Org:: there is a dep visit assoc to dep org of curr FS::
2834: -- based on the profile value see if you can adjust the visit dates
2835: OPEN get_visit_end_time(l_visit_id);

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

2874: CLOSE c_Visit;
2875: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
2876: Fnd_Message.set_name('AHL', 'AHL_API_RECORD_NOT_FOUND');
2877: Fnd_Msg_Pub.ADD;
2878: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2879: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Visit not found for - ' ||l_visit_rec.visit_id );
2880: END IF;
2881: END IF;
2882: RAISE Fnd_Api.g_exc_error;

Line 2879: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Visit not found for - ' ||l_visit_rec.visit_id );

2875: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
2876: Fnd_Message.set_name('AHL', 'AHL_API_RECORD_NOT_FOUND');
2877: Fnd_Msg_Pub.ADD;
2878: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2879: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Visit not found for - ' ||l_visit_rec.visit_id );
2880: END IF;
2881: END IF;
2882: RAISE Fnd_Api.g_exc_error;
2883: ELSE

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

2898: l_visit_rec.ORGANIZATION_ID := c_Visit_rec.ORGANIZATION_ID;
2899: l_visit_rec.DEPARTMENT_ID := c_Visit_rec.DEPARTMENT_ID;
2900: l_visit_rec.AUTO_VISIT_TYPE_FLAG := c_Visit_rec.AUTO_VISIT_TYPE_FLAG;--TCHIMIRA :: 14-Jun-2012 :: ER 14015560
2901:
2902: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
2903: fnd_log.string
2904: ( fnd_log.level_procedure,
2905: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
2906: 'Before calling AHL_VWP_VISITS_PVT.Update_Visit autovst_oper_id: '||get_oper_param_rec.autovst_oper_id);

Line 2903: fnd_log.string

2899: l_visit_rec.DEPARTMENT_ID := c_Visit_rec.DEPARTMENT_ID;
2900: l_visit_rec.AUTO_VISIT_TYPE_FLAG := c_Visit_rec.AUTO_VISIT_TYPE_FLAG;--TCHIMIRA :: 14-Jun-2012 :: ER 14015560
2901:
2902: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
2903: fnd_log.string
2904: ( fnd_log.level_procedure,
2905: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
2906: 'Before calling AHL_VWP_VISITS_PVT.Update_Visit autovst_oper_id: '||get_oper_param_rec.autovst_oper_id);
2907: END IF;

Line 2904: ( fnd_log.level_procedure,

2900: l_visit_rec.AUTO_VISIT_TYPE_FLAG := c_Visit_rec.AUTO_VISIT_TYPE_FLAG;--TCHIMIRA :: 14-Jun-2012 :: ER 14015560
2901:
2902: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
2903: fnd_log.string
2904: ( fnd_log.level_procedure,
2905: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
2906: 'Before calling AHL_VWP_VISITS_PVT.Update_Visit autovst_oper_id: '||get_oper_param_rec.autovst_oper_id);
2907: END IF;
2908: AHL_VWP_VISITS_PVT.Update_Visit (

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

2916: x_msg_count => l_msg_count,
2917: x_msg_data => l_msg_data
2918: );
2919:
2920: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
2921: fnd_log.string
2922: ( fnd_log.level_procedure,
2923: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
2924: 'After calling AHL_VWP_VISITS_PVT.Update_Visit, l_return_status= '||l_return_status||', visit id= '||l_visit_rec.visit_id);

Line 2921: fnd_log.string

2917: x_msg_data => l_msg_data
2918: );
2919:
2920: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
2921: fnd_log.string
2922: ( fnd_log.level_procedure,
2923: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
2924: 'After calling AHL_VWP_VISITS_PVT.Update_Visit, l_return_status= '||l_return_status||', visit id= '||l_visit_rec.visit_id);
2925: END IF;

Line 2922: ( fnd_log.level_procedure,

2918: );
2919:
2920: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
2921: fnd_log.string
2922: ( fnd_log.level_procedure,
2923: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
2924: 'After calling AHL_VWP_VISITS_PVT.Update_Visit, l_return_status= '||l_return_status||', visit id= '||l_visit_rec.visit_id);
2925: END IF;
2926: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

Line 2929: fnd_log.string(l_log_statement,

2925: END IF;
2926: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2927: x_msg_count := FND_MSG_PUB.count_msg;
2928: IF (l_log_statement >= l_log_current_level) THEN
2929: fnd_log.string(l_log_statement,
2930: L_DEBUG_KEY,
2931: 'Errors from Update_Visit. Message count: ' || x_msg_count);
2932: END IF;
2933: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

Line 2948: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'Before Type 9 and before calling Create_Departure_visit');

2944: FETCH get_oper_param_rows1 INTO get_oper_param_rec;
2945: IF get_oper_param_rows1%FOUND THEN
2946: --TYPE 9: Departure Org :: no visit at dep org of current FS :: create a departure visit
2947: IF (l_log_statement >= l_log_current_level) THEN
2948: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'Before Type 9 and before calling Create_Departure_visit');
2949: END IF;
2950: l_oper_param_rec.visit_type_code := get_oper_param_rec.visit_type_code;
2951: l_oper_param_rec.mc_id := get_oper_param_rec.mc_id;
2952: l_oper_param_rec.alternate_dep_id := get_oper_param_rec.alternate_dep_id;

Line 2968: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'After calling Create_Departure_visit and l_return_status: '||l_return_status);

2964: x_msg_count => l_msg_count,
2965: x_msg_data => l_msg_data
2966: );
2967: IF (l_log_statement >= l_log_current_level) THEN
2968: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'After calling Create_Departure_visit and l_return_status: '||l_return_status);
2969: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'l_is_creation_success: '||l_is_creation_success);
2970: END IF;
2971: IF l_is_creation_success<>'Y' THEN
2972: ROLLBACK TO OPER_VISIT_CREATION;

Line 2969: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'l_is_creation_success: '||l_is_creation_success);

2965: x_msg_data => l_msg_data
2966: );
2967: IF (l_log_statement >= l_log_current_level) THEN
2968: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'After calling Create_Departure_visit and l_return_status: '||l_return_status);
2969: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'l_is_creation_success: '||l_is_creation_success);
2970: END IF;
2971: IF l_is_creation_success<>'Y' THEN
2972: ROLLBACK TO OPER_VISIT_CREATION;
2973: END IF;

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

2980: END IF; --IF (l_can_cancel_visit IS NOT NULL) AND (l_can_cancel_visit2 IS NOT NULL) THEN
2981: END IF; --IF ( flight_schedule_rec.preceding_us_id IS NULL )
2982:
2983:
2984: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2985: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'CASE II, flight_schedule_rec.unit_schedule_id= '||flight_schedule_rec.unit_schedule_id );
2986: END IF;
2987: -- CASE II: Now consider the arrival org of the flight schedule record
2988: OPEN get_non_null_org_count(flight_schedule_rec.unit_config_header_id,flight_schedule_rec.arrival_org_id);

Line 2985: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'CASE II, flight_schedule_rec.unit_schedule_id= '||flight_schedule_rec.unit_schedule_id );

2981: END IF; --IF ( flight_schedule_rec.preceding_us_id IS NULL )
2982:
2983:
2984: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2985: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'CASE II, flight_schedule_rec.unit_schedule_id= '||flight_schedule_rec.unit_schedule_id );
2986: END IF;
2987: -- CASE II: Now consider the arrival org of the flight schedule record
2988: OPEN get_non_null_org_count(flight_schedule_rec.unit_config_header_id,flight_schedule_rec.arrival_org_id);
2989: FETCH get_non_null_org_count INTO l_count_org;

Line 3015: fnd_log.string(l_log_statement,L_DEBUG_KEY, ' Before Type 10.There is an existing arrival visit at arrival org');

3011:
3012: IF substr (l_visit_type,1,1) = 'A' THEN -- if there is a visit
3013:
3014: IF (l_log_statement >= l_log_current_level) THEN
3015: fnd_log.string(l_log_statement,L_DEBUG_KEY, ' Before Type 10.There is an existing arrival visit at arrival org');
3016: END IF;
3017: --TYPE 10: Arrival Org :: arrival visit associated to the arrival org of current FS :: update the visit
3018:
3019: OPEN get_visit_type_duration (get_oper_param_rec.visit_type_code,get_oper_param_rec.mc_id);

Line 3024: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'Visit type duration is: '||l_visit_type_duration);

3020: FETCH get_visit_type_duration INTO l_visit_type_duration;
3021: CLOSE get_visit_type_duration;
3022:
3023: IF (l_log_statement >= l_log_current_level) THEN
3024: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'Visit type duration is: '||l_visit_type_duration);
3025: END IF;
3026: -- based on the profile value see if you can adjust the visit dates
3027: OPEN get_visit_start_time(l_visit_id);
3028: FETCH get_visit_start_time INTO l_visit_start_time;

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

3074: CLOSE c_Visit;
3075: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
3076: Fnd_Message.set_name('AHL', 'AHL_API_RECORD_NOT_FOUND');
3077: Fnd_Msg_Pub.ADD;
3078: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3079: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Visit not found for - ' ||l_visit_rec.visit_id );
3080: END IF;
3081: END IF;
3082: RAISE Fnd_Api.g_exc_error;

Line 3079: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Visit not found for - ' ||l_visit_rec.visit_id );

3075: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
3076: Fnd_Message.set_name('AHL', 'AHL_API_RECORD_NOT_FOUND');
3077: Fnd_Msg_Pub.ADD;
3078: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3079: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Visit not found for - ' ||l_visit_rec.visit_id );
3080: END IF;
3081: END IF;
3082: RAISE Fnd_Api.g_exc_error;
3083: ELSE

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

3098: l_visit_rec.ORGANIZATION_ID := c_Visit_rec.ORGANIZATION_ID;
3099: l_visit_rec.DEPARTMENT_ID := c_Visit_rec.DEPARTMENT_ID;
3100: l_visit_rec.AUTO_VISIT_TYPE_FLAG := c_Visit_rec.AUTO_VISIT_TYPE_FLAG;--TCHIMIRA :: 14-Jun-2012 :: ER 14015560
3101:
3102: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
3103: fnd_log.string
3104: ( fnd_log.level_procedure,
3105: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
3106: 'Before calling AHL_VWP_VISITS_PVT.Update_Visit autovst_oper_id: '||get_oper_param_rec.autovst_oper_id);

Line 3103: fnd_log.string

3099: l_visit_rec.DEPARTMENT_ID := c_Visit_rec.DEPARTMENT_ID;
3100: l_visit_rec.AUTO_VISIT_TYPE_FLAG := c_Visit_rec.AUTO_VISIT_TYPE_FLAG;--TCHIMIRA :: 14-Jun-2012 :: ER 14015560
3101:
3102: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
3103: fnd_log.string
3104: ( fnd_log.level_procedure,
3105: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
3106: 'Before calling AHL_VWP_VISITS_PVT.Update_Visit autovst_oper_id: '||get_oper_param_rec.autovst_oper_id);
3107: END IF;

Line 3104: ( fnd_log.level_procedure,

3100: l_visit_rec.AUTO_VISIT_TYPE_FLAG := c_Visit_rec.AUTO_VISIT_TYPE_FLAG;--TCHIMIRA :: 14-Jun-2012 :: ER 14015560
3101:
3102: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
3103: fnd_log.string
3104: ( fnd_log.level_procedure,
3105: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
3106: 'Before calling AHL_VWP_VISITS_PVT.Update_Visit autovst_oper_id: '||get_oper_param_rec.autovst_oper_id);
3107: END IF;
3108: AHL_VWP_VISITS_PVT.Update_Visit (

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

3116: x_msg_count => l_msg_count,
3117: x_msg_data => l_msg_data
3118: );
3119:
3120: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
3121: fnd_log.string
3122: ( fnd_log.level_procedure,
3123: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
3124: 'After calling AHL_VWP_VISITS_PVT.Update_Visit, l_return_status= '||l_return_status||', visit id= '||l_visit_rec.visit_id);

Line 3121: fnd_log.string

3117: x_msg_data => l_msg_data
3118: );
3119:
3120: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
3121: fnd_log.string
3122: ( fnd_log.level_procedure,
3123: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
3124: 'After calling AHL_VWP_VISITS_PVT.Update_Visit, l_return_status= '||l_return_status||', visit id= '||l_visit_rec.visit_id);
3125: END IF;

Line 3122: ( fnd_log.level_procedure,

3118: );
3119:
3120: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
3121: fnd_log.string
3122: ( fnd_log.level_procedure,
3123: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
3124: 'After calling AHL_VWP_VISITS_PVT.Update_Visit, l_return_status= '||l_return_status||', visit id= '||l_visit_rec.visit_id);
3125: END IF;
3126: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

Line 3129: fnd_log.string(l_log_statement,

3125: END IF;
3126: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3127: x_msg_count := FND_MSG_PUB.count_msg;
3128: IF (l_log_statement >= l_log_current_level) THEN
3129: fnd_log.string(l_log_statement,
3130: L_DEBUG_KEY,
3131: 'Errors from Update_Visit. Message count: ' || x_msg_count);
3132: END IF;
3133: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

Line 3149: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'After calling Disconnect_Flight_Visit and l_return_status: '||l_return_status);

3145: x_msg_count => l_msg_count,
3146: x_msg_data => l_msg_data
3147: );
3148: IF (l_log_statement >= l_log_current_level) THEN
3149: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'After calling Disconnect_Flight_Visit and l_return_status: '||l_return_status);
3150: END IF;
3151:
3152: IF l_msg_count > 0 OR NVL(l_return_status,'x') <> FND_API.G_RET_STS_SUCCESS THEN
3153: x_msg_count := l_msg_count;

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

3179: -- TCHIMIRA : Bug 13844759 : 29 - Mar - 2012
3180: -- If there is no arrival visit, look for the possibility of creating one
3181: IF ((substr (l_visit_type,1,1) <> 'A') OR (l_can_update_visit IS NULL)) THEN
3182: -- check for the possibility of creating an arrival visit;
3183: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3184: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'passing values are unit_config_header_id: '||flight_schedule_rec.unit_config_header_id
3185: ||', flight_schedule_rec.arrival_org_id: '||flight_schedule_rec.arrival_org_id||', arrival_dept_id: , '||flight_schedule_rec.arrival_dept_id
3186: ||', flight_category_code: ,'||flight_schedule_rec.flight_category_code||', l_count_org: ,'||l_count_org||', l_count_dep: ,'
3187: ||l_count_dep||', l_count_cat: ,'||l_count_cat);

Line 3184: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'passing values are unit_config_header_id: '||flight_schedule_rec.unit_config_header_id

3180: -- If there is no arrival visit, look for the possibility of creating one
3181: IF ((substr (l_visit_type,1,1) <> 'A') OR (l_can_update_visit IS NULL)) THEN
3182: -- check for the possibility of creating an arrival visit;
3183: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3184: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'passing values are unit_config_header_id: '||flight_schedule_rec.unit_config_header_id
3185: ||', flight_schedule_rec.arrival_org_id: '||flight_schedule_rec.arrival_org_id||', arrival_dept_id: , '||flight_schedule_rec.arrival_dept_id
3186: ||', flight_category_code: ,'||flight_schedule_rec.flight_category_code||', l_count_org: ,'||l_count_org||', l_count_dep: ,'
3187: ||l_count_dep||', l_count_cat: ,'||l_count_cat);
3188: END IF;

Line 3197: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'Before Type 11 and before calling Create_Arrival_visit');

3193: IF get_oper_param_rows1%FOUND THEN
3194: -- if there is a possibility , create an arrival visit
3195: --TYPE 11: Arrival Org :: no visit associated to the arrival org of current FS :: create an arrival visit
3196: IF (l_log_statement >= l_log_current_level) THEN
3197: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'Before Type 11 and before calling Create_Arrival_visit');
3198: END IF;
3199: l_oper_param_rec.visit_type_code := get_oper_param_rec.visit_type_code;
3200: l_oper_param_rec.mc_id := get_oper_param_rec.mc_id;
3201: l_oper_param_rec.alternate_dep_id := get_oper_param_rec.alternate_dep_id;

Line 3217: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'After calling Create_Arrival_visit and l_return_status: '||l_return_status);

3213: x_msg_count => l_msg_count,
3214: x_msg_data => l_msg_data
3215: );
3216: IF (l_log_statement >= l_log_current_level) THEN
3217: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'After calling Create_Arrival_visit and l_return_status: '||l_return_status);
3218: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'l_is_creation_success: '||l_is_creation_success);
3219: END IF;
3220: IF l_is_creation_success<>'Y' THEN
3221: ROLLBACK TO OPER_VISIT_CREATION;

Line 3218: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'l_is_creation_success: '||l_is_creation_success);

3214: x_msg_data => l_msg_data
3215: );
3216: IF (l_log_statement >= l_log_current_level) THEN
3217: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'After calling Create_Arrival_visit and l_return_status: '||l_return_status);
3218: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'l_is_creation_success: '||l_is_creation_success);
3219: END IF;
3220: IF l_is_creation_success<>'Y' THEN
3221: ROLLBACK TO OPER_VISIT_CREATION;
3222: END IF;

Line 3245: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'After calling load_can_cancel_visit and l_return_status: '||l_return_status);

3241: x_msg_count => l_msg_count,
3242: x_msg_data => l_msg_data
3243: );
3244: IF (l_log_statement >= l_log_current_level) THEN
3245: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'After calling load_can_cancel_visit and l_return_status: '||l_return_status);
3246: END IF;
3247:
3248: -- PRAKKUM :: Bug 13844759 :: 25/07/2012
3249: -- If existing visit is arrival visit, then see whether it needs to be updated or disassociate

Line 3254: fnd_log.string(l_log_statement,L_DEBUG_KEY, ' Before Type 10.There is an existing arrival visit at arrival org');

3250: IF substr (l_visit_type,1,1) = 'A' THEN -- if there is a visit
3251: IF l_visit_id IS NOT NULL THEN
3252:
3253: IF (l_log_statement >= l_log_current_level) THEN
3254: fnd_log.string(l_log_statement,L_DEBUG_KEY, ' Before Type 10.There is an existing arrival visit at arrival org');
3255: END IF;
3256: --TYPE 10: Arrival Org :: arrival visit associated to the arrival org of current FS :: update the visit
3257:
3258: OPEN get_visit_type_duration (get_oper_param_rec.visit_type_code,get_oper_param_rec.mc_id);

Line 3263: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'Visit type duration is: '||l_visit_type_duration);

3259: FETCH get_visit_type_duration INTO l_visit_type_duration;
3260: CLOSE get_visit_type_duration;
3261:
3262: IF (l_log_statement >= l_log_current_level) THEN
3263: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'Visit type duration is: '||l_visit_type_duration);
3264: END IF;
3265: -- based on the profile value see if you can adjust the visit dates
3266: OPEN get_visit_start_time(l_visit_id);
3267: FETCH get_visit_start_time INTO l_visit_start_time;

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

3313: CLOSE c_Visit;
3314: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
3315: Fnd_Message.set_name('AHL', 'AHL_API_RECORD_NOT_FOUND');
3316: Fnd_Msg_Pub.ADD;
3317: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3318: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Visit not found for - ' ||l_visit_rec.visit_id );
3319: END IF;
3320: END IF;
3321: RAISE Fnd_Api.g_exc_error;

Line 3318: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Visit not found for - ' ||l_visit_rec.visit_id );

3314: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
3315: Fnd_Message.set_name('AHL', 'AHL_API_RECORD_NOT_FOUND');
3316: Fnd_Msg_Pub.ADD;
3317: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3318: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Visit not found for - ' ||l_visit_rec.visit_id );
3319: END IF;
3320: END IF;
3321: RAISE Fnd_Api.g_exc_error;
3322: ELSE

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

3337: l_visit_rec.ORGANIZATION_ID := c_Visit_rec.ORGANIZATION_ID;
3338: l_visit_rec.DEPARTMENT_ID := c_Visit_rec.DEPARTMENT_ID;
3339: l_visit_rec.AUTO_VISIT_TYPE_FLAG := c_Visit_rec.AUTO_VISIT_TYPE_FLAG;--TCHIMIRA :: 14-Jun-2012 :: ER 14015560
3340:
3341: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
3342: fnd_log.string
3343: ( fnd_log.level_procedure,
3344: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
3345: 'Before calling AHL_VWP_VISITS_PVT.Update_Visit autovst_oper_id: '||get_oper_param_rec.autovst_oper_id);

Line 3342: fnd_log.string

3338: l_visit_rec.DEPARTMENT_ID := c_Visit_rec.DEPARTMENT_ID;
3339: l_visit_rec.AUTO_VISIT_TYPE_FLAG := c_Visit_rec.AUTO_VISIT_TYPE_FLAG;--TCHIMIRA :: 14-Jun-2012 :: ER 14015560
3340:
3341: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
3342: fnd_log.string
3343: ( fnd_log.level_procedure,
3344: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
3345: 'Before calling AHL_VWP_VISITS_PVT.Update_Visit autovst_oper_id: '||get_oper_param_rec.autovst_oper_id);
3346: END IF;

Line 3343: ( fnd_log.level_procedure,

3339: l_visit_rec.AUTO_VISIT_TYPE_FLAG := c_Visit_rec.AUTO_VISIT_TYPE_FLAG;--TCHIMIRA :: 14-Jun-2012 :: ER 14015560
3340:
3341: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
3342: fnd_log.string
3343: ( fnd_log.level_procedure,
3344: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
3345: 'Before calling AHL_VWP_VISITS_PVT.Update_Visit autovst_oper_id: '||get_oper_param_rec.autovst_oper_id);
3346: END IF;
3347: AHL_VWP_VISITS_PVT.Update_Visit (

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

3355: x_msg_count => l_msg_count,
3356: x_msg_data => l_msg_data
3357: );
3358:
3359: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
3360: fnd_log.string
3361: ( fnd_log.level_procedure,
3362: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
3363: 'After calling AHL_VWP_VISITS_PVT.Update_Visit, l_return_status= '||l_return_status||', visit id= '||l_visit_rec.visit_id);

Line 3360: fnd_log.string

3356: x_msg_data => l_msg_data
3357: );
3358:
3359: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
3360: fnd_log.string
3361: ( fnd_log.level_procedure,
3362: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
3363: 'After calling AHL_VWP_VISITS_PVT.Update_Visit, l_return_status= '||l_return_status||', visit id= '||l_visit_rec.visit_id);
3364: END IF;

Line 3361: ( fnd_log.level_procedure,

3357: );
3358:
3359: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
3360: fnd_log.string
3361: ( fnd_log.level_procedure,
3362: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
3363: 'After calling AHL_VWP_VISITS_PVT.Update_Visit, l_return_status= '||l_return_status||', visit id= '||l_visit_rec.visit_id);
3364: END IF;
3365: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

Line 3368: fnd_log.string(l_log_statement,

3364: END IF;
3365: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3366: x_msg_count := FND_MSG_PUB.count_msg;
3367: IF (l_log_statement >= l_log_current_level) THEN
3368: fnd_log.string(l_log_statement,
3369: L_DEBUG_KEY,
3370: 'Errors from Update_Visit. Message count: ' || x_msg_count);
3371: END IF;
3372: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

Line 3388: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'After calling Disconnect_Flight_Visit and l_return_status: '||l_return_status);

3384: x_msg_count => l_msg_count,
3385: x_msg_data => l_msg_data
3386: );
3387: IF (l_log_statement >= l_log_current_level) THEN
3388: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'After calling Disconnect_Flight_Visit and l_return_status: '||l_return_status);
3389: END IF;
3390:
3391: IF l_msg_count > 0 OR NVL(l_return_status,'x') <> FND_API.G_RET_STS_SUCCESS THEN
3392: x_msg_count := l_msg_count;

Line 3421: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'After calling load_can_cancel_visit and l_return_status: '||l_return_status);

3417: x_msg_count => l_msg_count,
3418: x_msg_data => l_msg_data
3419: );
3420: IF (l_log_statement >= l_log_current_level) THEN
3421: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'After calling load_can_cancel_visit and l_return_status: '||l_return_status);
3422: END IF;
3423:
3424: -- PRAKKUM :: Bug 14368696 :: 01/08/2012 :: START
3425: IF (l_can_cancel_visit IS NULL) THEN -- If downtime or arrival is not allowed to cancel

Line 3429: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'Handle case that downtime visit not allowed to cancel--@>');

3425: IF (l_can_cancel_visit IS NULL) THEN -- If downtime or arrival is not allowed to cancel
3426: IF substr (l_visit_type,1,1) = 'T' AND l_visit_id IS NOT NULL THEN --Downtime visit exists
3427:
3428: IF (l_log_statement >= l_log_current_level) THEN
3429: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'Handle case that downtime visit not allowed to cancel--@>');
3430: END IF;
3431:
3432: --Get ground time at the departing org of a FS
3433: OPEN get_ground_time (flight_schedule_rec.UNIT_SCHEDULE_ID, l_succeeding_us_id);

Line 3478: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'l_difference_arrival_time--@>'||l_difference_arrival_time);

3474: l_profile_number2 := flight_schedule_rec.est_arrival_time-sysdate+1;
3475: END IF;
3476:
3477: IF (l_log_statement >= l_log_current_level) THEN
3478: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'l_difference_arrival_time--@>'||l_difference_arrival_time);
3479: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'l_profile_number--@>'||l_profile_number);
3480: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'l_profile_number2--@>'||l_profile_number);
3481: fnd_log.string(l_log_statement,L_DEBUG_KEY, '(sysdate + l_profile_number2)--@>'||(cast((sysdate + l_profile_number2) AS timestamp)));
3482: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'flight_schedule_rec.est_arrival_time--@>'||(cast((flight_schedule_rec.est_arrival_time) AS timestamp)));

Line 3479: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'l_profile_number--@>'||l_profile_number);

3475: END IF;
3476:
3477: IF (l_log_statement >= l_log_current_level) THEN
3478: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'l_difference_arrival_time--@>'||l_difference_arrival_time);
3479: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'l_profile_number--@>'||l_profile_number);
3480: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'l_profile_number2--@>'||l_profile_number);
3481: fnd_log.string(l_log_statement,L_DEBUG_KEY, '(sysdate + l_profile_number2)--@>'||(cast((sysdate + l_profile_number2) AS timestamp)));
3482: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'flight_schedule_rec.est_arrival_time--@>'||(cast((flight_schedule_rec.est_arrival_time) AS timestamp)));
3483: END IF;

Line 3480: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'l_profile_number2--@>'||l_profile_number);

3476:
3477: IF (l_log_statement >= l_log_current_level) THEN
3478: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'l_difference_arrival_time--@>'||l_difference_arrival_time);
3479: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'l_profile_number--@>'||l_profile_number);
3480: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'l_profile_number2--@>'||l_profile_number);
3481: fnd_log.string(l_log_statement,L_DEBUG_KEY, '(sysdate + l_profile_number2)--@>'||(cast((sysdate + l_profile_number2) AS timestamp)));
3482: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'flight_schedule_rec.est_arrival_time--@>'||(cast((flight_schedule_rec.est_arrival_time) AS timestamp)));
3483: END IF;
3484:

Line 3481: fnd_log.string(l_log_statement,L_DEBUG_KEY, '(sysdate + l_profile_number2)--@>'||(cast((sysdate + l_profile_number2) AS timestamp)));

3477: IF (l_log_statement >= l_log_current_level) THEN
3478: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'l_difference_arrival_time--@>'||l_difference_arrival_time);
3479: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'l_profile_number--@>'||l_profile_number);
3480: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'l_profile_number2--@>'||l_profile_number);
3481: fnd_log.string(l_log_statement,L_DEBUG_KEY, '(sysdate + l_profile_number2)--@>'||(cast((sysdate + l_profile_number2) AS timestamp)));
3482: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'flight_schedule_rec.est_arrival_time--@>'||(cast((flight_schedule_rec.est_arrival_time) AS timestamp)));
3483: END IF;
3484:
3485: IF((l_difference_arrival_time > l_profile_number)

Line 3482: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'flight_schedule_rec.est_arrival_time--@>'||(cast((flight_schedule_rec.est_arrival_time) AS timestamp)));

3478: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'l_difference_arrival_time--@>'||l_difference_arrival_time);
3479: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'l_profile_number--@>'||l_profile_number);
3480: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'l_profile_number2--@>'||l_profile_number);
3481: fnd_log.string(l_log_statement,L_DEBUG_KEY, '(sysdate + l_profile_number2)--@>'||(cast((sysdate + l_profile_number2) AS timestamp)));
3482: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'flight_schedule_rec.est_arrival_time--@>'||(cast((flight_schedule_rec.est_arrival_time) AS timestamp)));
3483: END IF;
3484:
3485: IF((l_difference_arrival_time > l_profile_number)
3486: AND (l_difference_arrival_time <> 0)

Line 3509: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'After calling Disconnect_Flight_Visit and l_return_status: '||l_return_status);

3505: x_msg_count => l_msg_count,
3506: x_msg_data => l_msg_data
3507: );
3508: IF (l_log_statement >= l_log_current_level) THEN
3509: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'After calling Disconnect_Flight_Visit and l_return_status: '||l_return_status);
3510: END IF;
3511:
3512: IF l_msg_count > 0 OR NVL(l_return_status,'x') <> FND_API.G_RET_STS_SUCCESS THEN
3513: x_msg_count := l_msg_count;

Line 3538: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'After calling load_can_cancel_visit and l_return_status: '||l_return_status);

3534: x_msg_count => l_msg_count,
3535: x_msg_data => l_msg_data
3536: );
3537: IF (l_log_statement >= l_log_current_level) THEN
3538: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'After calling load_can_cancel_visit and l_return_status: '||l_return_status);
3539: END IF;
3540:
3541: -- if departure succ flight visit can not be cancelled and there is no visit associated to arrival org of current FS
3542: -- then look for the possibility of creating an arrival visit at arrival org of current FS

Line 3549: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'passing values are unit_config_header_id: '

3545: IF l_visit_id IS NULL THEN -- PRAKKUM :: Bug 13844759 :: 25/07/2012 :: END
3546:
3547: -- check for the possibility of creating an arrival visit;
3548: IF (l_log_statement >= l_log_current_level) THEN
3549: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'passing values are unit_config_header_id: '
3550: ||flight_schedule_rec.unit_config_header_id||', flight_schedule_rec.arrival_org_id: '||flight_schedule_rec.arrival_org_id||', arrival_dept_id: , '
3551: ||flight_schedule_rec.arrival_dept_id||', flight_category_code: ,'||flight_schedule_rec.flight_category_code||', l_count_org: ,'||l_count_org||', l_count_dep: ,'
3552: ||l_count_dep||', l_count_cat: ,'||l_count_cat);
3553: END IF;

Line 3562: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'Before Type 12 and before calling Create_Arrival_visit');

3558: IF get_oper_param_rows1%FOUND THEN
3559: -- if there is possibility of creating an arrival visit
3560: --TYPE 12: Arrival Org :: no visit to cancel :: create an arrival visit
3561: IF (l_log_statement >= l_log_current_level) THEN
3562: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'Before Type 12 and before calling Create_Arrival_visit');
3563: END IF;
3564: l_oper_param_rec.visit_type_code := get_oper_param_rec.visit_type_code;
3565: l_oper_param_rec.mc_id := get_oper_param_rec.mc_id;
3566: l_oper_param_rec.alternate_dep_id := get_oper_param_rec.alternate_dep_id;

Line 3581: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'After calling Create_Arrival_visit and l_return_status: '||l_return_status);

3577: x_msg_count => l_msg_count,
3578: x_msg_data => l_msg_data
3579: );
3580: IF (l_log_statement >= l_log_current_level) THEN
3581: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'After calling Create_Arrival_visit and l_return_status: '||l_return_status);
3582: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'l_is_creation_success: '||l_is_creation_success);
3583: END IF;
3584: IF l_is_creation_success<>'Y' THEN
3585: ROLLBACK TO OPER_VISIT_CREATION;

Line 3582: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'l_is_creation_success: '||l_is_creation_success);

3578: x_msg_data => l_msg_data
3579: );
3580: IF (l_log_statement >= l_log_current_level) THEN
3581: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'After calling Create_Arrival_visit and l_return_status: '||l_return_status);
3582: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'l_is_creation_success: '||l_is_creation_success);
3583: END IF;
3584: IF l_is_creation_success<>'Y' THEN
3585: ROLLBACK TO OPER_VISIT_CREATION;
3586: END IF;

Line 3625: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'Before Type 13');

3621: l_is_downtime_vst_created := 'Y';
3622: IF get_oper_param_rows1%FOUND THEN
3623: IF l_visit_id is null THEN -- if there is no visit associated to the arrival org of currrent FS
3624: IF (l_log_statement >= l_log_current_level) THEN
3625: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'Before Type 13');
3626: END IF;
3627:
3628: -- Bug 14336467 :: PRAKKUM :: 13/07/2012 :: START
3629: SAVEPOINT OPER_VISIT_CREATION;

Line 3639: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'Before calling Create_Downtime_visit');

3635: p_visit_id => l_visit_id2,
3636: x_return_status => l_return_status);
3637: END IF;--IF(l_visit_id2 is not null) then
3638: IF (l_log_statement >= l_log_current_level) THEN
3639: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'Before calling Create_Downtime_visit');
3640: END IF;
3641: l_oper_param_rec.visit_type_code := get_oper_param_rec.visit_type_code;
3642: l_oper_param_rec.alternate_dep_id := get_oper_param_rec.alternate_dep_id;
3643: l_oper_param_rec.autovst_oper_id := get_oper_param_rec.autovst_oper_id;

Line 3657: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'After calling Create_Downtime_visit and l_return_status: '||l_return_status);

3653: x_msg_data => l_msg_data
3654: );
3655:
3656: IF (l_log_statement >= l_log_current_level) THEN
3657: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'After calling Create_Downtime_visit and l_return_status: '||l_return_status);
3658: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'l_is_creation_success: '||l_is_creation_success);
3659: END IF;
3660:
3661: IF l_is_creation_success<>'Y' THEN

Line 3658: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'l_is_creation_success: '||l_is_creation_success);

3654: );
3655:
3656: IF (l_log_statement >= l_log_current_level) THEN
3657: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'After calling Create_Downtime_visit and l_return_status: '||l_return_status);
3658: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'l_is_creation_success: '||l_is_creation_success);
3659: END IF;
3660:
3661: IF l_is_creation_success<>'Y' THEN
3662: ROLLBACK TO OPER_VISIT_CREATION;

Line 3677: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'Before Type 14');

3673: -- if it does not match then call create visit API
3674: -- Cancel the arrival visit with id 'l_visit_id' and also if any departure visit associated
3675: -- to the dep org of succ FS. then create a downtime visit
3676: IF (l_log_statement >= l_log_current_level) THEN
3677: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'Before Type 14');
3678: END IF;
3679:
3680: -- Bug 14336467 :: PRAKKUM :: 13/07/2012 :: START
3681: SAVEPOINT OPER_VISIT_CREATION;

Line 3695: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'Before calling Create_Downtime_visit');

3691: p_visit_id => l_visit_id2,
3692: x_return_status => l_return_status);
3693: END IF;--IF(l_visit_id2 is not null) then
3694: IF (l_log_statement >= l_log_current_level) THEN
3695: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'Before calling Create_Downtime_visit');
3696: END IF;
3697: l_oper_param_rec.visit_type_code := get_oper_param_rec.visit_type_code;
3698: l_oper_param_rec.alternate_dep_id := get_oper_param_rec.alternate_dep_id;
3699: l_oper_param_rec.autovst_oper_id := get_oper_param_rec.autovst_oper_id;

Line 3713: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'After calling Create_Downtime_visit and l_return_status: '||l_return_status);

3709: x_msg_data => l_msg_data
3710: );
3711:
3712: IF (l_log_statement >= l_log_current_level) THEN
3713: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'After calling Create_Downtime_visit and l_return_status: '||l_return_status);
3714: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'l_is_creation_success: '||l_is_creation_success);
3715: END IF;
3716:
3717: IF l_is_creation_success<>'Y' THEN

Line 3714: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'l_is_creation_success: '||l_is_creation_success);

3710: );
3711:
3712: IF (l_log_statement >= l_log_current_level) THEN
3713: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'After calling Create_Downtime_visit and l_return_status: '||l_return_status);
3714: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'l_is_creation_success: '||l_is_creation_success);
3715: END IF;
3716:
3717: IF l_is_creation_success<>'Y' THEN
3718: ROLLBACK TO OPER_VISIT_CREATION;

Line 3727: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'Before Type 15');

3723: ELSE
3724: -- If the visit type matches, we need to update the visit dates
3725: --Before updating the visit first cancel the departure visit of the succ event if it is not null
3726: IF (l_log_statement >= l_log_current_level) THEN
3727: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'Before Type 15');
3728: END IF;
3729: --TYPE 15: Arrival Org :: visit types do match :: update the visit
3730: IF(l_visit_id2 IS NOT NULL) THEN
3731: Delete_Oper_Visit(

Line 3764: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'l_difference_arrival_time--@>'||l_difference_arrival_time);

3760: l_profile_number2 := flight_schedule_rec.est_arrival_time-sysdate+1;
3761: END IF;
3762:
3763: IF (l_log_statement >= l_log_current_level) THEN --PRAKKUM :: Bug 14342603 :: 18/07/2012
3764: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'l_difference_arrival_time--@>'||l_difference_arrival_time);
3765: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'l_profile_number--@>'||l_profile_number);
3766: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'l_profile_number2--@>'||l_profile_number);
3767: fnd_log.string(l_log_statement,L_DEBUG_KEY, '(sysdate + l_profile_number2)--@>'||(cast((sysdate + l_profile_number2) AS timestamp)));
3768: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'flight_schedule_rec.est_arrival_time--@>'||(cast((flight_schedule_rec.est_arrival_time) AS timestamp)));

Line 3765: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'l_profile_number--@>'||l_profile_number);

3761: END IF;
3762:
3763: IF (l_log_statement >= l_log_current_level) THEN --PRAKKUM :: Bug 14342603 :: 18/07/2012
3764: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'l_difference_arrival_time--@>'||l_difference_arrival_time);
3765: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'l_profile_number--@>'||l_profile_number);
3766: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'l_profile_number2--@>'||l_profile_number);
3767: fnd_log.string(l_log_statement,L_DEBUG_KEY, '(sysdate + l_profile_number2)--@>'||(cast((sysdate + l_profile_number2) AS timestamp)));
3768: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'flight_schedule_rec.est_arrival_time--@>'||(cast((flight_schedule_rec.est_arrival_time) AS timestamp)));
3769: END IF;

Line 3766: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'l_profile_number2--@>'||l_profile_number);

3762:
3763: IF (l_log_statement >= l_log_current_level) THEN --PRAKKUM :: Bug 14342603 :: 18/07/2012
3764: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'l_difference_arrival_time--@>'||l_difference_arrival_time);
3765: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'l_profile_number--@>'||l_profile_number);
3766: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'l_profile_number2--@>'||l_profile_number);
3767: fnd_log.string(l_log_statement,L_DEBUG_KEY, '(sysdate + l_profile_number2)--@>'||(cast((sysdate + l_profile_number2) AS timestamp)));
3768: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'flight_schedule_rec.est_arrival_time--@>'||(cast((flight_schedule_rec.est_arrival_time) AS timestamp)));
3769: END IF;
3770:

Line 3767: fnd_log.string(l_log_statement,L_DEBUG_KEY, '(sysdate + l_profile_number2)--@>'||(cast((sysdate + l_profile_number2) AS timestamp)));

3763: IF (l_log_statement >= l_log_current_level) THEN --PRAKKUM :: Bug 14342603 :: 18/07/2012
3764: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'l_difference_arrival_time--@>'||l_difference_arrival_time);
3765: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'l_profile_number--@>'||l_profile_number);
3766: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'l_profile_number2--@>'||l_profile_number);
3767: fnd_log.string(l_log_statement,L_DEBUG_KEY, '(sysdate + l_profile_number2)--@>'||(cast((sysdate + l_profile_number2) AS timestamp)));
3768: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'flight_schedule_rec.est_arrival_time--@>'||(cast((flight_schedule_rec.est_arrival_time) AS timestamp)));
3769: END IF;
3770:
3771: IF((l_difference_arrival_time > l_profile_number)

Line 3768: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'flight_schedule_rec.est_arrival_time--@>'||(cast((flight_schedule_rec.est_arrival_time) AS timestamp)));

3764: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'l_difference_arrival_time--@>'||l_difference_arrival_time);
3765: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'l_profile_number--@>'||l_profile_number);
3766: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'l_profile_number2--@>'||l_profile_number);
3767: fnd_log.string(l_log_statement,L_DEBUG_KEY, '(sysdate + l_profile_number2)--@>'||(cast((sysdate + l_profile_number2) AS timestamp)));
3768: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'flight_schedule_rec.est_arrival_time--@>'||(cast((flight_schedule_rec.est_arrival_time) AS timestamp)));
3769: END IF;
3770:
3771: IF((l_difference_arrival_time > l_profile_number)
3772: AND (l_difference_arrival_time <> 0)

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

3784: CLOSE c_Visit;
3785: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
3786: Fnd_Message.set_name('AHL', 'AHL_API_RECORD_NOT_FOUND');
3787: Fnd_Msg_Pub.ADD;
3788: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3789: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Visit not found for - ' ||l_visit_rec.visit_id );
3790: END IF;
3791: END IF;
3792: RAISE Fnd_Api.g_exc_error;

Line 3789: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Visit not found for - ' ||l_visit_rec.visit_id );

3785: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
3786: Fnd_Message.set_name('AHL', 'AHL_API_RECORD_NOT_FOUND');
3787: Fnd_Msg_Pub.ADD;
3788: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3789: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Visit not found for - ' ||l_visit_rec.visit_id );
3790: END IF;
3791: END IF;
3792: RAISE Fnd_Api.g_exc_error;
3793: ELSE

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

3808: l_visit_rec.ORGANIZATION_ID := c_Visit_rec.ORGANIZATION_ID;
3809: l_visit_rec.DEPARTMENT_ID := c_Visit_rec.DEPARTMENT_ID;
3810: l_visit_rec.AUTO_VISIT_TYPE_FLAG := 'T';--TCHIMIRA :: 14-Jun-2012 :: ER 14015560
3811:
3812: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
3813: fnd_log.string
3814: ( fnd_log.level_procedure,
3815: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
3816: 'Before calling AHL_VWP_VISITS_PVT.Update_Visit autovst_oper_id: '||get_oper_param_rec.autovst_oper_id);

Line 3813: fnd_log.string

3809: l_visit_rec.DEPARTMENT_ID := c_Visit_rec.DEPARTMENT_ID;
3810: l_visit_rec.AUTO_VISIT_TYPE_FLAG := 'T';--TCHIMIRA :: 14-Jun-2012 :: ER 14015560
3811:
3812: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
3813: fnd_log.string
3814: ( fnd_log.level_procedure,
3815: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
3816: 'Before calling AHL_VWP_VISITS_PVT.Update_Visit autovst_oper_id: '||get_oper_param_rec.autovst_oper_id);
3817: END IF;

Line 3814: ( fnd_log.level_procedure,

3810: l_visit_rec.AUTO_VISIT_TYPE_FLAG := 'T';--TCHIMIRA :: 14-Jun-2012 :: ER 14015560
3811:
3812: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
3813: fnd_log.string
3814: ( fnd_log.level_procedure,
3815: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
3816: 'Before calling AHL_VWP_VISITS_PVT.Update_Visit autovst_oper_id: '||get_oper_param_rec.autovst_oper_id);
3817: END IF;
3818: AHL_VWP_VISITS_PVT.Update_Visit (

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

3826: x_msg_count => l_msg_count,
3827: x_msg_data => l_msg_data
3828: );
3829:
3830: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
3831: fnd_log.string
3832: ( fnd_log.level_procedure,
3833: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
3834: 'After calling AHL_VWP_VISITS_PVT.Update_Visit, l_return_status= '||l_return_status||', visit id= '||l_visit_rec.visit_id);

Line 3831: fnd_log.string

3827: x_msg_data => l_msg_data
3828: );
3829:
3830: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
3831: fnd_log.string
3832: ( fnd_log.level_procedure,
3833: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
3834: 'After calling AHL_VWP_VISITS_PVT.Update_Visit, l_return_status= '||l_return_status||', visit id= '||l_visit_rec.visit_id);
3835: END IF;

Line 3832: ( fnd_log.level_procedure,

3828: );
3829:
3830: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
3831: fnd_log.string
3832: ( fnd_log.level_procedure,
3833: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
3834: 'After calling AHL_VWP_VISITS_PVT.Update_Visit, l_return_status= '||l_return_status||', visit id= '||l_visit_rec.visit_id);
3835: END IF;
3836: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

Line 3839: fnd_log.string(l_log_statement,

3835: END IF;
3836: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3837: x_msg_count := FND_MSG_PUB.count_msg;
3838: IF (l_log_statement >= l_log_current_level) THEN
3839: fnd_log.string(l_log_statement,
3840: L_DEBUG_KEY,
3841: 'Errors from Update_Visit. Message count: ' || x_msg_count);
3842: END IF;
3843: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

Line 3918: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'Before Type 16');

3914: IF((l_difference_arrival_time > l_profile_number)
3915: AND (l_difference_arrival_time <> 0)
3916: AND ((sysdate + l_profile_number2)> flight_schedule_rec.est_arrival_time) ) THEN
3917: IF (l_log_statement >= l_log_current_level) THEN
3918: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'Before Type 16');
3919: END IF;
3920: --TYPE 16: Arrival Org :: a visit at arrival org of current FS:: update the arrival visit
3921: l_start_date := flight_schedule_rec.est_arrival_time;
3922: l_end_date := flight_schedule_rec.est_arrival_time + l_visit_type_duration/24;

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

3932: CLOSE c_Visit;
3933: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
3934: Fnd_Message.set_name('AHL', 'AHL_API_RECORD_NOT_FOUND');
3935: Fnd_Msg_Pub.ADD;
3936: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3937: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Visit not found for - ' ||l_visit_rec.visit_id );
3938: END IF;
3939: END IF;
3940: RAISE Fnd_Api.g_exc_error;

Line 3937: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Visit not found for - ' ||l_visit_rec.visit_id );

3933: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
3934: Fnd_Message.set_name('AHL', 'AHL_API_RECORD_NOT_FOUND');
3935: Fnd_Msg_Pub.ADD;
3936: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3937: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Visit not found for - ' ||l_visit_rec.visit_id );
3938: END IF;
3939: END IF;
3940: RAISE Fnd_Api.g_exc_error;
3941: ELSE

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

3956: l_visit_rec.ORGANIZATION_ID := c_Visit_rec.ORGANIZATION_ID;
3957: l_visit_rec.DEPARTMENT_ID := c_Visit_rec.DEPARTMENT_ID;
3958: l_visit_rec.AUTO_VISIT_TYPE_FLAG := c_Visit_rec.AUTO_VISIT_TYPE_FLAG;--TCHIMIRA :: 14-Jun-2012 :: ER 14015560
3959:
3960: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
3961: fnd_log.string
3962: ( fnd_log.level_procedure,
3963: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
3964: 'Before calling AHL_VWP_VISITS_PVT.Update_Visit autovst_oper_id: '||get_oper_param_rec.autovst_oper_id);

Line 3961: fnd_log.string

3957: l_visit_rec.DEPARTMENT_ID := c_Visit_rec.DEPARTMENT_ID;
3958: l_visit_rec.AUTO_VISIT_TYPE_FLAG := c_Visit_rec.AUTO_VISIT_TYPE_FLAG;--TCHIMIRA :: 14-Jun-2012 :: ER 14015560
3959:
3960: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
3961: fnd_log.string
3962: ( fnd_log.level_procedure,
3963: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
3964: 'Before calling AHL_VWP_VISITS_PVT.Update_Visit autovst_oper_id: '||get_oper_param_rec.autovst_oper_id);
3965: END IF;

Line 3962: ( fnd_log.level_procedure,

3958: l_visit_rec.AUTO_VISIT_TYPE_FLAG := c_Visit_rec.AUTO_VISIT_TYPE_FLAG;--TCHIMIRA :: 14-Jun-2012 :: ER 14015560
3959:
3960: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
3961: fnd_log.string
3962: ( fnd_log.level_procedure,
3963: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
3964: 'Before calling AHL_VWP_VISITS_PVT.Update_Visit autovst_oper_id: '||get_oper_param_rec.autovst_oper_id);
3965: END IF;
3966: AHL_VWP_VISITS_PVT.Update_Visit (

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

3974: x_msg_count => l_msg_count,
3975: x_msg_data => l_msg_data
3976: );
3977:
3978: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
3979: fnd_log.string
3980: ( fnd_log.level_procedure,
3981: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
3982: 'After calling AHL_VWP_VISITS_PVT.Update_Visit, l_return_status= '||l_return_status||', visit id= '||l_visit_rec.visit_id);

Line 3979: fnd_log.string

3975: x_msg_data => l_msg_data
3976: );
3977:
3978: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
3979: fnd_log.string
3980: ( fnd_log.level_procedure,
3981: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
3982: 'After calling AHL_VWP_VISITS_PVT.Update_Visit, l_return_status= '||l_return_status||', visit id= '||l_visit_rec.visit_id);
3983: END IF;

Line 3980: ( fnd_log.level_procedure,

3976: );
3977:
3978: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
3979: fnd_log.string
3980: ( fnd_log.level_procedure,
3981: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
3982: 'After calling AHL_VWP_VISITS_PVT.Update_Visit, l_return_status= '||l_return_status||', visit id= '||l_visit_rec.visit_id);
3983: END IF;
3984: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

Line 3987: fnd_log.string(l_log_statement,

3983: END IF;
3984: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3985: x_msg_count := FND_MSG_PUB.count_msg;
3986: IF (l_log_statement >= l_log_current_level) THEN
3987: fnd_log.string(l_log_statement,
3988: L_DEBUG_KEY,
3989: 'Errors from Update_Visit. Message count: ' || x_msg_count);
3990: END IF;
3991: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

Line 4007: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'Before Type 17 and before calling Create_Arrival_visit');

4003: FETCH get_oper_param_rows1 INTO get_oper_param_rec;
4004: IF get_oper_param_rows1%FOUND THEN
4005: --TYPE 17: Arrival Org :: no visit at arrival org of current FS:: create the arrival visit
4006: IF (l_log_statement >= l_log_current_level) THEN
4007: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'Before Type 17 and before calling Create_Arrival_visit');
4008: END IF;
4009: l_oper_param_rec.visit_type_code := get_oper_param_rec.visit_type_code;
4010: l_oper_param_rec.mc_id := get_oper_param_rec.mc_id;
4011: l_oper_param_rec.alternate_dep_id := get_oper_param_rec.alternate_dep_id;

Line 4027: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'After calling Create_Arrival_visit and l_return_status: '||l_return_status);

4023: x_msg_count => l_msg_count,
4024: x_msg_data => l_msg_data
4025: );
4026: IF (l_log_statement >= l_log_current_level) THEN
4027: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'After calling Create_Arrival_visit and l_return_status: '||l_return_status);
4028: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'l_is_creation_success: '||l_is_creation_success);
4029: END IF;
4030: IF l_is_creation_success<>'Y' THEN
4031: ROLLBACK TO OPER_VISIT_CREATION;

Line 4028: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'l_is_creation_success: '||l_is_creation_success);

4024: x_msg_data => l_msg_data
4025: );
4026: IF (l_log_statement >= l_log_current_level) THEN
4027: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'After calling Create_Arrival_visit and l_return_status: '||l_return_status);
4028: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'l_is_creation_success: '||l_is_creation_success);
4029: END IF;
4030: IF l_is_creation_success<>'Y' THEN
4031: ROLLBACK TO OPER_VISIT_CREATION;
4032: END IF;

Line 4065: fnd_log.string(l_log_procedure,

4061: p_data => x_msg_data
4062: );
4063:
4064: IF (l_log_procedure >= l_log_current_level) THEN
4065: fnd_log.string(l_log_procedure,
4066: L_DEBUG_KEY ||'.end',
4067: 'At the end of PL SQL procedure. Return Status = ' || x_return_status);
4068: END IF;
4069:

Line 4185: fnd_log.string(l_log_procedure,

4181:
4182: SAVEPOINT Create_Dep_visit_pvt;
4183:
4184: IF (l_log_procedure >= l_log_current_level) THEN
4185: fnd_log.string(l_log_procedure,
4186: L_DEBUG_KEY ||'.begin',
4187: 'At the start of PL SQL function.');
4188: END IF;
4189:

Line 4238: fnd_log.string(l_log_statement, L_DEBUG_KEY , 'l_start_date --@>'||cast(l_start_date as timestamp));

4234: FETCH is_org_in_current_OU INTO l_is_org_in_curr_OU;
4235: CLOSE is_org_in_current_OU;
4236:
4237: IF (l_log_statement >= l_log_current_level) THEN
4238: fnd_log.string(l_log_statement, L_DEBUG_KEY , 'l_start_date --@>'||cast(l_start_date as timestamp));
4239: fnd_log.string(l_log_statement, L_DEBUG_KEY , 'l_end_date --@>'||cast(l_end_date as timestamp));
4240: fnd_log.string(l_log_statement, L_DEBUG_KEY , 'p_present_time --@>'||cast(p_present_time as timestamp));
4241: fnd_log.string(l_log_statement, L_DEBUG_KEY , 'mo_global.get_current_org_id() --@>'||mo_global.get_current_org_id());
4242: fnd_log.string(l_log_statement, L_DEBUG_KEY , 'l_visit_rec.ORGANIZATION_ID --@>'||l_visit_rec.ORGANIZATION_ID);

Line 4239: fnd_log.string(l_log_statement, L_DEBUG_KEY , 'l_end_date --@>'||cast(l_end_date as timestamp));

4235: CLOSE is_org_in_current_OU;
4236:
4237: IF (l_log_statement >= l_log_current_level) THEN
4238: fnd_log.string(l_log_statement, L_DEBUG_KEY , 'l_start_date --@>'||cast(l_start_date as timestamp));
4239: fnd_log.string(l_log_statement, L_DEBUG_KEY , 'l_end_date --@>'||cast(l_end_date as timestamp));
4240: fnd_log.string(l_log_statement, L_DEBUG_KEY , 'p_present_time --@>'||cast(p_present_time as timestamp));
4241: fnd_log.string(l_log_statement, L_DEBUG_KEY , 'mo_global.get_current_org_id() --@>'||mo_global.get_current_org_id());
4242: fnd_log.string(l_log_statement, L_DEBUG_KEY , 'l_visit_rec.ORGANIZATION_ID --@>'||l_visit_rec.ORGANIZATION_ID);
4243: fnd_log.string(l_log_statement, L_DEBUG_KEY , 'l_is_org_in_curr_OU --@>'||l_is_org_in_curr_OU);

Line 4240: fnd_log.string(l_log_statement, L_DEBUG_KEY , 'p_present_time --@>'||cast(p_present_time as timestamp));

4236:
4237: IF (l_log_statement >= l_log_current_level) THEN
4238: fnd_log.string(l_log_statement, L_DEBUG_KEY , 'l_start_date --@>'||cast(l_start_date as timestamp));
4239: fnd_log.string(l_log_statement, L_DEBUG_KEY , 'l_end_date --@>'||cast(l_end_date as timestamp));
4240: fnd_log.string(l_log_statement, L_DEBUG_KEY , 'p_present_time --@>'||cast(p_present_time as timestamp));
4241: fnd_log.string(l_log_statement, L_DEBUG_KEY , 'mo_global.get_current_org_id() --@>'||mo_global.get_current_org_id());
4242: fnd_log.string(l_log_statement, L_DEBUG_KEY , 'l_visit_rec.ORGANIZATION_ID --@>'||l_visit_rec.ORGANIZATION_ID);
4243: fnd_log.string(l_log_statement, L_DEBUG_KEY , 'l_is_org_in_curr_OU --@>'||l_is_org_in_curr_OU);
4244: END IF;

Line 4241: fnd_log.string(l_log_statement, L_DEBUG_KEY , 'mo_global.get_current_org_id() --@>'||mo_global.get_current_org_id());

4237: IF (l_log_statement >= l_log_current_level) THEN
4238: fnd_log.string(l_log_statement, L_DEBUG_KEY , 'l_start_date --@>'||cast(l_start_date as timestamp));
4239: fnd_log.string(l_log_statement, L_DEBUG_KEY , 'l_end_date --@>'||cast(l_end_date as timestamp));
4240: fnd_log.string(l_log_statement, L_DEBUG_KEY , 'p_present_time --@>'||cast(p_present_time as timestamp));
4241: fnd_log.string(l_log_statement, L_DEBUG_KEY , 'mo_global.get_current_org_id() --@>'||mo_global.get_current_org_id());
4242: fnd_log.string(l_log_statement, L_DEBUG_KEY , 'l_visit_rec.ORGANIZATION_ID --@>'||l_visit_rec.ORGANIZATION_ID);
4243: fnd_log.string(l_log_statement, L_DEBUG_KEY , 'l_is_org_in_curr_OU --@>'||l_is_org_in_curr_OU);
4244: END IF;
4245:

Line 4242: fnd_log.string(l_log_statement, L_DEBUG_KEY , 'l_visit_rec.ORGANIZATION_ID --@>'||l_visit_rec.ORGANIZATION_ID);

4238: fnd_log.string(l_log_statement, L_DEBUG_KEY , 'l_start_date --@>'||cast(l_start_date as timestamp));
4239: fnd_log.string(l_log_statement, L_DEBUG_KEY , 'l_end_date --@>'||cast(l_end_date as timestamp));
4240: fnd_log.string(l_log_statement, L_DEBUG_KEY , 'p_present_time --@>'||cast(p_present_time as timestamp));
4241: fnd_log.string(l_log_statement, L_DEBUG_KEY , 'mo_global.get_current_org_id() --@>'||mo_global.get_current_org_id());
4242: fnd_log.string(l_log_statement, L_DEBUG_KEY , 'l_visit_rec.ORGANIZATION_ID --@>'||l_visit_rec.ORGANIZATION_ID);
4243: fnd_log.string(l_log_statement, L_DEBUG_KEY , 'l_is_org_in_curr_OU --@>'||l_is_org_in_curr_OU);
4244: END IF;
4245:
4246: IF l_start_date < p_present_time THEN -- Bug 14336486 :: PRAKKUM :: 12/07/2012

Line 4243: fnd_log.string(l_log_statement, L_DEBUG_KEY , 'l_is_org_in_curr_OU --@>'||l_is_org_in_curr_OU);

4239: fnd_log.string(l_log_statement, L_DEBUG_KEY , 'l_end_date --@>'||cast(l_end_date as timestamp));
4240: fnd_log.string(l_log_statement, L_DEBUG_KEY , 'p_present_time --@>'||cast(p_present_time as timestamp));
4241: fnd_log.string(l_log_statement, L_DEBUG_KEY , 'mo_global.get_current_org_id() --@>'||mo_global.get_current_org_id());
4242: fnd_log.string(l_log_statement, L_DEBUG_KEY , 'l_visit_rec.ORGANIZATION_ID --@>'||l_visit_rec.ORGANIZATION_ID);
4243: fnd_log.string(l_log_statement, L_DEBUG_KEY , 'l_is_org_in_curr_OU --@>'||l_is_org_in_curr_OU);
4244: END IF;
4245:
4246: IF l_start_date < p_present_time THEN -- Bug 14336486 :: PRAKKUM :: 12/07/2012
4247: -- Do not create a visit

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

4258:
4259: ELSE
4260: -- IF the visit org is NOT in current OU, do not create the visit
4261: IF l_is_org_in_curr_OU = 'X' THEN
4262: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
4263: fnd_log.string
4264: ( fnd_log.level_procedure,
4265: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
4266: 'Before calling AHL_VWP_VISITS_PVT.Create_Visit autovst_oper_id: '||p_oper_param_rec.autovst_oper_id);

Line 4263: fnd_log.string

4259: ELSE
4260: -- IF the visit org is NOT in current OU, do not create the visit
4261: IF l_is_org_in_curr_OU = 'X' THEN
4262: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
4263: fnd_log.string
4264: ( fnd_log.level_procedure,
4265: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
4266: 'Before calling AHL_VWP_VISITS_PVT.Create_Visit autovst_oper_id: '||p_oper_param_rec.autovst_oper_id);
4267: END IF;

Line 4264: ( fnd_log.level_procedure,

4260: -- IF the visit org is NOT in current OU, do not create the visit
4261: IF l_is_org_in_curr_OU = 'X' THEN
4262: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
4263: fnd_log.string
4264: ( fnd_log.level_procedure,
4265: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
4266: 'Before calling AHL_VWP_VISITS_PVT.Create_Visit autovst_oper_id: '||p_oper_param_rec.autovst_oper_id);
4267: END IF;
4268: AHL_VWP_VISITS_PVT.Create_Visit (

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

4273: x_msg_count => x_msg_count,
4274: x_msg_data => x_msg_data
4275: );
4276:
4277: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
4278: fnd_log.string
4279: ( fnd_log.level_procedure,
4280: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
4281: 'After calling AHL_VWP_VISITS_PVT.Create_Visit, l_return_status= '||l_return_status||', visit id= '||l_visit_rec.visit_id);

Line 4278: fnd_log.string

4274: x_msg_data => x_msg_data
4275: );
4276:
4277: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
4278: fnd_log.string
4279: ( fnd_log.level_procedure,
4280: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
4281: 'After calling AHL_VWP_VISITS_PVT.Create_Visit, l_return_status= '||l_return_status||', visit id= '||l_visit_rec.visit_id);
4282: END IF;

Line 4279: ( fnd_log.level_procedure,

4275: );
4276:
4277: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
4278: fnd_log.string
4279: ( fnd_log.level_procedure,
4280: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
4281: 'After calling AHL_VWP_VISITS_PVT.Create_Visit, l_return_status= '||l_return_status||', visit id= '||l_visit_rec.visit_id);
4282: END IF;
4283:

Line 4289: fnd_log.string

4285: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
4286: l_pub_msg := FND_MSG_PUB.Get_Detail (p_msg_index => FND_MSG_PUB.G_LAST);
4287: IF (l_pub_msg like '%AHL_VWP_PRD_MR_ASSOC_FAIL%') THEN
4288: IF (l_log_statement >= l_log_current_level) THEN
4289: fnd_log.string
4290: ( l_log_statement,
4291: L_DEBUG_KEY,
4292: 'visit id= '||l_visit_rec.visit_id || 'Had problems with the MRs associated. So departure visit creation is not successful. ');
4293: END IF;

Line 4308: fnd_log.string(l_log_statement,

4304: ELSE
4305: x_return_status := l_return_status ;
4306: x_msg_count := FND_MSG_PUB.count_msg;
4307: IF (l_log_statement >= l_log_current_level) THEN
4308: fnd_log.string(l_log_statement,
4309: L_DEBUG_KEY,
4310: 'Errors from Create_Visit. Message count: ' || x_msg_count);
4311: END IF;
4312: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

Line 4332: fnd_log.string(l_log_procedure,

4328: END IF; -- IF l_is_org_in_curr_OU = 'X'
4329: END IF; -- l_start_date
4330:
4331: IF (l_log_procedure >= l_log_current_level) THEN
4332: fnd_log.string(l_log_procedure,
4333: L_DEBUG_KEY ||'.end',
4334: 'At the end of PL SQL function.');
4335: END IF;
4336: EXCEPTION

Line 4444: fnd_log.string(l_log_procedure,

4440: BEGIN
4441:
4442: SAVEPOINT Create_Arr_visit_pvt;
4443: IF (l_log_procedure >= l_log_current_level) THEN
4444: fnd_log.string(l_log_procedure,
4445: L_DEBUG_KEY ||'.begin',
4446: 'At the start of PL SQL function.');
4447: END IF;
4448:

Line 4498: fnd_log.string(l_log_statement, L_DEBUG_KEY , 'l_start_date --@>'||cast(l_start_date as timestamp));

4494: FETCH is_org_in_current_OU INTO l_is_org_in_curr_OU;
4495: CLOSE is_org_in_current_OU;
4496:
4497: IF (l_log_statement >= l_log_current_level) THEN
4498: fnd_log.string(l_log_statement, L_DEBUG_KEY , 'l_start_date --@>'||cast(l_start_date as timestamp));
4499: fnd_log.string(l_log_statement, L_DEBUG_KEY , 'l_end_date --@>'||cast(l_end_date as timestamp));
4500: fnd_log.string(l_log_statement, L_DEBUG_KEY , 'p_present_time --@>'||cast(p_present_time as timestamp));
4501: fnd_log.string(l_log_statement, L_DEBUG_KEY , 'mo_global.get_current_org_id() --@>'||mo_global.get_current_org_id());
4502: fnd_log.string(l_log_statement, L_DEBUG_KEY , 'l_visit_rec.ORGANIZATION_ID --@>'||l_visit_rec.ORGANIZATION_ID);

Line 4499: fnd_log.string(l_log_statement, L_DEBUG_KEY , 'l_end_date --@>'||cast(l_end_date as timestamp));

4495: CLOSE is_org_in_current_OU;
4496:
4497: IF (l_log_statement >= l_log_current_level) THEN
4498: fnd_log.string(l_log_statement, L_DEBUG_KEY , 'l_start_date --@>'||cast(l_start_date as timestamp));
4499: fnd_log.string(l_log_statement, L_DEBUG_KEY , 'l_end_date --@>'||cast(l_end_date as timestamp));
4500: fnd_log.string(l_log_statement, L_DEBUG_KEY , 'p_present_time --@>'||cast(p_present_time as timestamp));
4501: fnd_log.string(l_log_statement, L_DEBUG_KEY , 'mo_global.get_current_org_id() --@>'||mo_global.get_current_org_id());
4502: fnd_log.string(l_log_statement, L_DEBUG_KEY , 'l_visit_rec.ORGANIZATION_ID --@>'||l_visit_rec.ORGANIZATION_ID);
4503: fnd_log.string(l_log_statement, L_DEBUG_KEY , 'l_is_org_in_curr_OU --@>'||l_is_org_in_curr_OU);

Line 4500: fnd_log.string(l_log_statement, L_DEBUG_KEY , 'p_present_time --@>'||cast(p_present_time as timestamp));

4496:
4497: IF (l_log_statement >= l_log_current_level) THEN
4498: fnd_log.string(l_log_statement, L_DEBUG_KEY , 'l_start_date --@>'||cast(l_start_date as timestamp));
4499: fnd_log.string(l_log_statement, L_DEBUG_KEY , 'l_end_date --@>'||cast(l_end_date as timestamp));
4500: fnd_log.string(l_log_statement, L_DEBUG_KEY , 'p_present_time --@>'||cast(p_present_time as timestamp));
4501: fnd_log.string(l_log_statement, L_DEBUG_KEY , 'mo_global.get_current_org_id() --@>'||mo_global.get_current_org_id());
4502: fnd_log.string(l_log_statement, L_DEBUG_KEY , 'l_visit_rec.ORGANIZATION_ID --@>'||l_visit_rec.ORGANIZATION_ID);
4503: fnd_log.string(l_log_statement, L_DEBUG_KEY , 'l_is_org_in_curr_OU --@>'||l_is_org_in_curr_OU);
4504: END IF;

Line 4501: fnd_log.string(l_log_statement, L_DEBUG_KEY , 'mo_global.get_current_org_id() --@>'||mo_global.get_current_org_id());

4497: IF (l_log_statement >= l_log_current_level) THEN
4498: fnd_log.string(l_log_statement, L_DEBUG_KEY , 'l_start_date --@>'||cast(l_start_date as timestamp));
4499: fnd_log.string(l_log_statement, L_DEBUG_KEY , 'l_end_date --@>'||cast(l_end_date as timestamp));
4500: fnd_log.string(l_log_statement, L_DEBUG_KEY , 'p_present_time --@>'||cast(p_present_time as timestamp));
4501: fnd_log.string(l_log_statement, L_DEBUG_KEY , 'mo_global.get_current_org_id() --@>'||mo_global.get_current_org_id());
4502: fnd_log.string(l_log_statement, L_DEBUG_KEY , 'l_visit_rec.ORGANIZATION_ID --@>'||l_visit_rec.ORGANIZATION_ID);
4503: fnd_log.string(l_log_statement, L_DEBUG_KEY , 'l_is_org_in_curr_OU --@>'||l_is_org_in_curr_OU);
4504: END IF;
4505:

Line 4502: fnd_log.string(l_log_statement, L_DEBUG_KEY , 'l_visit_rec.ORGANIZATION_ID --@>'||l_visit_rec.ORGANIZATION_ID);

4498: fnd_log.string(l_log_statement, L_DEBUG_KEY , 'l_start_date --@>'||cast(l_start_date as timestamp));
4499: fnd_log.string(l_log_statement, L_DEBUG_KEY , 'l_end_date --@>'||cast(l_end_date as timestamp));
4500: fnd_log.string(l_log_statement, L_DEBUG_KEY , 'p_present_time --@>'||cast(p_present_time as timestamp));
4501: fnd_log.string(l_log_statement, L_DEBUG_KEY , 'mo_global.get_current_org_id() --@>'||mo_global.get_current_org_id());
4502: fnd_log.string(l_log_statement, L_DEBUG_KEY , 'l_visit_rec.ORGANIZATION_ID --@>'||l_visit_rec.ORGANIZATION_ID);
4503: fnd_log.string(l_log_statement, L_DEBUG_KEY , 'l_is_org_in_curr_OU --@>'||l_is_org_in_curr_OU);
4504: END IF;
4505:
4506: -- Bug 14336486 :: PRAKKUM :: 13/07/2012

Line 4503: fnd_log.string(l_log_statement, L_DEBUG_KEY , 'l_is_org_in_curr_OU --@>'||l_is_org_in_curr_OU);

4499: fnd_log.string(l_log_statement, L_DEBUG_KEY , 'l_end_date --@>'||cast(l_end_date as timestamp));
4500: fnd_log.string(l_log_statement, L_DEBUG_KEY , 'p_present_time --@>'||cast(p_present_time as timestamp));
4501: fnd_log.string(l_log_statement, L_DEBUG_KEY , 'mo_global.get_current_org_id() --@>'||mo_global.get_current_org_id());
4502: fnd_log.string(l_log_statement, L_DEBUG_KEY , 'l_visit_rec.ORGANIZATION_ID --@>'||l_visit_rec.ORGANIZATION_ID);
4503: fnd_log.string(l_log_statement, L_DEBUG_KEY , 'l_is_org_in_curr_OU --@>'||l_is_org_in_curr_OU);
4504: END IF;
4505:
4506: -- Bug 14336486 :: PRAKKUM :: 13/07/2012
4507: IF l_start_date < p_present_time THEN -- If arrival time is in past, do not create a visit

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

4516:
4517: ELSE
4518: -- IF the visit org is NOT in current OU, do not create the visit
4519: IF l_is_org_in_curr_OU = 'X' THEN
4520: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
4521: fnd_log.string
4522: ( fnd_log.level_procedure,
4523: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
4524: 'Before calling AHL_VWP_VISITS_PVT.Create_Visit autovst_oper_id: '||p_oper_param_rec.autovst_oper_id);

Line 4521: fnd_log.string

4517: ELSE
4518: -- IF the visit org is NOT in current OU, do not create the visit
4519: IF l_is_org_in_curr_OU = 'X' THEN
4520: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
4521: fnd_log.string
4522: ( fnd_log.level_procedure,
4523: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
4524: 'Before calling AHL_VWP_VISITS_PVT.Create_Visit autovst_oper_id: '||p_oper_param_rec.autovst_oper_id);
4525: END IF;

Line 4522: ( fnd_log.level_procedure,

4518: -- IF the visit org is NOT in current OU, do not create the visit
4519: IF l_is_org_in_curr_OU = 'X' THEN
4520: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
4521: fnd_log.string
4522: ( fnd_log.level_procedure,
4523: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
4524: 'Before calling AHL_VWP_VISITS_PVT.Create_Visit autovst_oper_id: '||p_oper_param_rec.autovst_oper_id);
4525: END IF;
4526: AHL_VWP_VISITS_PVT.Create_Visit (

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

4531: x_msg_count => x_msg_count,
4532: x_msg_data => x_msg_data
4533: );
4534:
4535: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
4536: fnd_log.string
4537: ( fnd_log.level_procedure,
4538: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
4539: 'After calling AHL_VWP_VISITS_PVT.Create_Visit, l_return_status= '||l_return_status||', visit id= '||l_visit_rec.visit_id);

Line 4536: fnd_log.string

4532: x_msg_data => x_msg_data
4533: );
4534:
4535: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
4536: fnd_log.string
4537: ( fnd_log.level_procedure,
4538: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
4539: 'After calling AHL_VWP_VISITS_PVT.Create_Visit, l_return_status= '||l_return_status||', visit id= '||l_visit_rec.visit_id);
4540: END IF;

Line 4537: ( fnd_log.level_procedure,

4533: );
4534:
4535: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
4536: fnd_log.string
4537: ( fnd_log.level_procedure,
4538: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
4539: 'After calling AHL_VWP_VISITS_PVT.Create_Visit, l_return_status= '||l_return_status||', visit id= '||l_visit_rec.visit_id);
4540: END IF;
4541: -- SATRAJEN :: Bug 14336467 :: Prevent Erroring out when the called from Operational Visit Procedure. :: START

Line 4546: fnd_log.string

4542: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
4543: l_pub_msg := FND_MSG_PUB.Get_Detail (p_msg_index => FND_MSG_PUB.G_LAST);
4544: IF (l_pub_msg like '%AHL_VWP_PRD_MR_ASSOC_FAIL%') THEN
4545: IF (l_log_statement >= l_log_current_level) THEN
4546: fnd_log.string
4547: ( l_log_statement,
4548: L_DEBUG_KEY,
4549: 'visit id= '||l_visit_rec.visit_id || 'Had problems with the MRs associated. So arrival visit creation is not successful.');
4550: END IF;

Line 4565: fnd_log.string(l_log_statement,

4561: ELSE
4562: x_return_status := l_return_status ;
4563: x_msg_count := FND_MSG_PUB.count_msg;
4564: IF (l_log_statement >= l_log_current_level) THEN
4565: fnd_log.string(l_log_statement,
4566: L_DEBUG_KEY,
4567: 'Errors from Create_Visit. Message count: ' || x_msg_count);
4568: END IF;
4569: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

Line 4589: fnd_log.string(l_log_procedure,

4585: END IF; -- IF l_is_org_in_curr_OU = 'X'
4586: END IF; -- l_start_date < p_present_time
4587:
4588: IF (l_log_procedure >= l_log_current_level) THEN
4589: fnd_log.string(l_log_procedure,
4590: L_DEBUG_KEY ||'.end',
4591: 'At the end of PL SQL function.');
4592: END IF;
4593: EXCEPTION

Line 4712: fnd_log.string(l_log_procedure,

4708:
4709: SAVEPOINT Create_Downtime_visit_pvt;
4710:
4711: IF (l_log_procedure >= l_log_current_level) THEN
4712: fnd_log.string(l_log_procedure,
4713: L_DEBUG_KEY ||'.begin',
4714: 'At the start of PL SQL function.');
4715: END IF;
4716:

Line 4754: fnd_log.string(l_log_statement, L_DEBUG_KEY, 'p_oper_param_rec.visit_type_code--@>' || p_oper_param_rec.visit_type_code);

4750: FETCH get_visit_type_dur INTO l_vst_type_est_dur;
4751: CLOSE get_visit_type_dur;
4752:
4753: IF (l_log_statement >= l_log_current_level) THEN
4754: fnd_log.string(l_log_statement, L_DEBUG_KEY, 'p_oper_param_rec.visit_type_code--@>' || p_oper_param_rec.visit_type_code);
4755: fnd_log.string(l_log_statement, L_DEBUG_KEY, 'p_oper_param_rec.mc_id--@>' || p_oper_param_rec.mc_id);
4756: fnd_log.string(l_log_statement, L_DEBUG_KEY, 'l_vst_type_est_dur--@>' || l_vst_type_est_dur);
4757: END IF;
4758:

Line 4755: fnd_log.string(l_log_statement, L_DEBUG_KEY, 'p_oper_param_rec.mc_id--@>' || p_oper_param_rec.mc_id);

4751: CLOSE get_visit_type_dur;
4752:
4753: IF (l_log_statement >= l_log_current_level) THEN
4754: fnd_log.string(l_log_statement, L_DEBUG_KEY, 'p_oper_param_rec.visit_type_code--@>' || p_oper_param_rec.visit_type_code);
4755: fnd_log.string(l_log_statement, L_DEBUG_KEY, 'p_oper_param_rec.mc_id--@>' || p_oper_param_rec.mc_id);
4756: fnd_log.string(l_log_statement, L_DEBUG_KEY, 'l_vst_type_est_dur--@>' || l_vst_type_est_dur);
4757: END IF;
4758:
4759: OPEN get_flight_details(p_flight_schedule_rec.unit_schedule_id);

Line 4756: fnd_log.string(l_log_statement, L_DEBUG_KEY, 'l_vst_type_est_dur--@>' || l_vst_type_est_dur);

4752:
4753: IF (l_log_statement >= l_log_current_level) THEN
4754: fnd_log.string(l_log_statement, L_DEBUG_KEY, 'p_oper_param_rec.visit_type_code--@>' || p_oper_param_rec.visit_type_code);
4755: fnd_log.string(l_log_statement, L_DEBUG_KEY, 'p_oper_param_rec.mc_id--@>' || p_oper_param_rec.mc_id);
4756: fnd_log.string(l_log_statement, L_DEBUG_KEY, 'l_vst_type_est_dur--@>' || l_vst_type_est_dur);
4757: END IF;
4758:
4759: OPEN get_flight_details(p_flight_schedule_rec.unit_schedule_id);
4760: FETCH get_flight_details INTO flt_dets_rec;

Line 4795: fnd_log.string(l_log_statement, L_DEBUG_KEY , 'l_start_date --@>'||cast(l_start_date as timestamp));

4791: FETCH is_org_in_current_OU INTO l_is_org_in_curr_OU;
4792: CLOSE is_org_in_current_OU;
4793:
4794: IF (l_log_statement >= l_log_current_level) THEN
4795: fnd_log.string(l_log_statement, L_DEBUG_KEY , 'l_start_date --@>'||cast(l_start_date as timestamp));
4796: fnd_log.string(l_log_statement, L_DEBUG_KEY , 'l_end_date --@>'||cast(l_end_date as timestamp));
4797: fnd_log.string(l_log_statement, L_DEBUG_KEY , 'p_present_time --@>'||cast(p_present_time as timestamp));
4798: fnd_log.string(l_log_statement, L_DEBUG_KEY , 'mo_global.get_current_org_id() --@>'||mo_global.get_current_org_id());
4799: fnd_log.string(l_log_statement, L_DEBUG_KEY , 'l_visit_rec.ORGANIZATION_ID --@>'||l_visit_rec.ORGANIZATION_ID);

Line 4796: fnd_log.string(l_log_statement, L_DEBUG_KEY , 'l_end_date --@>'||cast(l_end_date as timestamp));

4792: CLOSE is_org_in_current_OU;
4793:
4794: IF (l_log_statement >= l_log_current_level) THEN
4795: fnd_log.string(l_log_statement, L_DEBUG_KEY , 'l_start_date --@>'||cast(l_start_date as timestamp));
4796: fnd_log.string(l_log_statement, L_DEBUG_KEY , 'l_end_date --@>'||cast(l_end_date as timestamp));
4797: fnd_log.string(l_log_statement, L_DEBUG_KEY , 'p_present_time --@>'||cast(p_present_time as timestamp));
4798: fnd_log.string(l_log_statement, L_DEBUG_KEY , 'mo_global.get_current_org_id() --@>'||mo_global.get_current_org_id());
4799: fnd_log.string(l_log_statement, L_DEBUG_KEY , 'l_visit_rec.ORGANIZATION_ID --@>'||l_visit_rec.ORGANIZATION_ID);
4800: fnd_log.string(l_log_statement, L_DEBUG_KEY , 'l_is_org_in_curr_OU --@>'||l_is_org_in_curr_OU);

Line 4797: fnd_log.string(l_log_statement, L_DEBUG_KEY , 'p_present_time --@>'||cast(p_present_time as timestamp));

4793:
4794: IF (l_log_statement >= l_log_current_level) THEN
4795: fnd_log.string(l_log_statement, L_DEBUG_KEY , 'l_start_date --@>'||cast(l_start_date as timestamp));
4796: fnd_log.string(l_log_statement, L_DEBUG_KEY , 'l_end_date --@>'||cast(l_end_date as timestamp));
4797: fnd_log.string(l_log_statement, L_DEBUG_KEY , 'p_present_time --@>'||cast(p_present_time as timestamp));
4798: fnd_log.string(l_log_statement, L_DEBUG_KEY , 'mo_global.get_current_org_id() --@>'||mo_global.get_current_org_id());
4799: fnd_log.string(l_log_statement, L_DEBUG_KEY , 'l_visit_rec.ORGANIZATION_ID --@>'||l_visit_rec.ORGANIZATION_ID);
4800: fnd_log.string(l_log_statement, L_DEBUG_KEY , 'l_is_org_in_curr_OU --@>'||l_is_org_in_curr_OU);
4801: END IF;

Line 4798: fnd_log.string(l_log_statement, L_DEBUG_KEY , 'mo_global.get_current_org_id() --@>'||mo_global.get_current_org_id());

4794: IF (l_log_statement >= l_log_current_level) THEN
4795: fnd_log.string(l_log_statement, L_DEBUG_KEY , 'l_start_date --@>'||cast(l_start_date as timestamp));
4796: fnd_log.string(l_log_statement, L_DEBUG_KEY , 'l_end_date --@>'||cast(l_end_date as timestamp));
4797: fnd_log.string(l_log_statement, L_DEBUG_KEY , 'p_present_time --@>'||cast(p_present_time as timestamp));
4798: fnd_log.string(l_log_statement, L_DEBUG_KEY , 'mo_global.get_current_org_id() --@>'||mo_global.get_current_org_id());
4799: fnd_log.string(l_log_statement, L_DEBUG_KEY , 'l_visit_rec.ORGANIZATION_ID --@>'||l_visit_rec.ORGANIZATION_ID);
4800: fnd_log.string(l_log_statement, L_DEBUG_KEY , 'l_is_org_in_curr_OU --@>'||l_is_org_in_curr_OU);
4801: END IF;
4802:

Line 4799: fnd_log.string(l_log_statement, L_DEBUG_KEY , 'l_visit_rec.ORGANIZATION_ID --@>'||l_visit_rec.ORGANIZATION_ID);

4795: fnd_log.string(l_log_statement, L_DEBUG_KEY , 'l_start_date --@>'||cast(l_start_date as timestamp));
4796: fnd_log.string(l_log_statement, L_DEBUG_KEY , 'l_end_date --@>'||cast(l_end_date as timestamp));
4797: fnd_log.string(l_log_statement, L_DEBUG_KEY , 'p_present_time --@>'||cast(p_present_time as timestamp));
4798: fnd_log.string(l_log_statement, L_DEBUG_KEY , 'mo_global.get_current_org_id() --@>'||mo_global.get_current_org_id());
4799: fnd_log.string(l_log_statement, L_DEBUG_KEY , 'l_visit_rec.ORGANIZATION_ID --@>'||l_visit_rec.ORGANIZATION_ID);
4800: fnd_log.string(l_log_statement, L_DEBUG_KEY , 'l_is_org_in_curr_OU --@>'||l_is_org_in_curr_OU);
4801: END IF;
4802:
4803:

Line 4800: fnd_log.string(l_log_statement, L_DEBUG_KEY , 'l_is_org_in_curr_OU --@>'||l_is_org_in_curr_OU);

4796: fnd_log.string(l_log_statement, L_DEBUG_KEY , 'l_end_date --@>'||cast(l_end_date as timestamp));
4797: fnd_log.string(l_log_statement, L_DEBUG_KEY , 'p_present_time --@>'||cast(p_present_time as timestamp));
4798: fnd_log.string(l_log_statement, L_DEBUG_KEY , 'mo_global.get_current_org_id() --@>'||mo_global.get_current_org_id());
4799: fnd_log.string(l_log_statement, L_DEBUG_KEY , 'l_visit_rec.ORGANIZATION_ID --@>'||l_visit_rec.ORGANIZATION_ID);
4800: fnd_log.string(l_log_statement, L_DEBUG_KEY , 'l_is_org_in_curr_OU --@>'||l_is_org_in_curr_OU);
4801: END IF;
4802:
4803:
4804: -- Bug 14336486 :: PRAKKUM :: 12/07/2012

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

4804: -- Bug 14336486 :: PRAKKUM :: 12/07/2012
4805: IF p_is_creation_success<>'N' THEN --Don't create a downtime visit, if visit duration is going to be lesser than visit type duration
4806: -- IF the visit org is NOT in current OU, do not create the visit
4807: IF l_is_org_in_curr_OU = 'X' THEN
4808: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
4809: fnd_log.string
4810: ( fnd_log.level_procedure,
4811: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
4812: 'Before calling AHL_VWP_VISITS_PVT.Create_Visit autovst_oper_id: '||p_oper_param_rec.autovst_oper_id);

Line 4809: fnd_log.string

4805: IF p_is_creation_success<>'N' THEN --Don't create a downtime visit, if visit duration is going to be lesser than visit type duration
4806: -- IF the visit org is NOT in current OU, do not create the visit
4807: IF l_is_org_in_curr_OU = 'X' THEN
4808: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
4809: fnd_log.string
4810: ( fnd_log.level_procedure,
4811: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
4812: 'Before calling AHL_VWP_VISITS_PVT.Create_Visit autovst_oper_id: '||p_oper_param_rec.autovst_oper_id);
4813: END IF;

Line 4810: ( fnd_log.level_procedure,

4806: -- IF the visit org is NOT in current OU, do not create the visit
4807: IF l_is_org_in_curr_OU = 'X' THEN
4808: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
4809: fnd_log.string
4810: ( fnd_log.level_procedure,
4811: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
4812: 'Before calling AHL_VWP_VISITS_PVT.Create_Visit autovst_oper_id: '||p_oper_param_rec.autovst_oper_id);
4813: END IF;
4814: AHL_VWP_VISITS_PVT.Create_Visit (

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

4819: x_msg_count => x_msg_count,
4820: x_msg_data => x_msg_data
4821: );
4822:
4823: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
4824: fnd_log.string
4825: ( fnd_log.level_procedure,
4826: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
4827: 'After calling AHL_VWP_VISITS_PVT.Create_Visit, l_return_status= '||l_return_status||', visit id= '||l_visit_rec.visit_id);

Line 4824: fnd_log.string

4820: x_msg_data => x_msg_data
4821: );
4822:
4823: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
4824: fnd_log.string
4825: ( fnd_log.level_procedure,
4826: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
4827: 'After calling AHL_VWP_VISITS_PVT.Create_Visit, l_return_status= '||l_return_status||', visit id= '||l_visit_rec.visit_id);
4828: END IF;

Line 4825: ( fnd_log.level_procedure,

4821: );
4822:
4823: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
4824: fnd_log.string
4825: ( fnd_log.level_procedure,
4826: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
4827: 'After calling AHL_VWP_VISITS_PVT.Create_Visit, l_return_status= '||l_return_status||', visit id= '||l_visit_rec.visit_id);
4828: END IF;
4829:

Line 4835: fnd_log.string

4831: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
4832: l_pub_msg := FND_MSG_PUB.Get_Detail (p_msg_index => FND_MSG_PUB.G_LAST);
4833: IF (l_pub_msg like '%AHL_VWP_PRD_MR_ASSOC_FAIL%') THEN
4834: IF (l_log_statement >= l_log_current_level) THEN
4835: fnd_log.string
4836: ( l_log_statement,
4837: L_DEBUG_KEY,
4838: 'visit id= '||l_visit_rec.visit_id || 'Had problems with the MRs associated. So downtime visit creation is not successful. ');
4839: END IF;

Line 4849: fnd_log.string(l_log_statement,

4845: ELSE
4846: x_return_status := l_return_status ;
4847: x_msg_count := FND_MSG_PUB.count_msg;
4848: IF (l_log_statement >= l_log_current_level) THEN
4849: fnd_log.string(l_log_statement,
4850: L_DEBUG_KEY,
4851: 'Errors from Create_Visit. Message count: ' || x_msg_count);
4852: END IF;
4853: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

Line 4873: fnd_log.string(l_log_procedure,

4869: END IF; -- IF l_is_org_in_curr_OU = 'X'
4870: END IF; -- (l_end_date - l_vst_type_est_dur) > l_start_date
4871:
4872: IF (l_log_procedure >= l_log_current_level) THEN
4873: fnd_log.string(l_log_procedure,
4874: L_DEBUG_KEY ||'.end',
4875: 'At the end of PL SQL function.');
4876: END IF;
4877: EXCEPTION

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

4945: x_item_key VARCHAR2(100);
4946:
4947: BEGIN
4948:
4949: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
4950: fnd_log.string
4951: ( fnd_log.level_procedure,
4952: L_DEBUG_KEY||'.begin',
4953: 'Before calling AHL_VWP_VISITS_PVT.Delete_Visit, visit id: '||p_visit_id);

Line 4950: fnd_log.string

4946:
4947: BEGIN
4948:
4949: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
4950: fnd_log.string
4951: ( fnd_log.level_procedure,
4952: L_DEBUG_KEY||'.begin',
4953: 'Before calling AHL_VWP_VISITS_PVT.Delete_Visit, visit id: '||p_visit_id);
4954: END IF;

Line 4951: ( fnd_log.level_procedure,

4947: BEGIN
4948:
4949: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
4950: fnd_log.string
4951: ( fnd_log.level_procedure,
4952: L_DEBUG_KEY||'.begin',
4953: 'Before calling AHL_VWP_VISITS_PVT.Delete_Visit, visit id: '||p_visit_id);
4954: END IF;
4955:

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

4971: x_msg_count => l_msg_count,
4972: x_msg_data => l_msg_data
4973: );
4974:
4975: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
4976: fnd_log.string
4977: ( fnd_log.level_procedure,
4978: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
4979: 'After calling AHL_VWP_VISITS_PVT.Delete_Visit, l_return_status= '||l_return_status);

Line 4976: fnd_log.string

4972: x_msg_data => l_msg_data
4973: );
4974:
4975: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
4976: fnd_log.string
4977: ( fnd_log.level_procedure,
4978: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
4979: 'After calling AHL_VWP_VISITS_PVT.Delete_Visit, l_return_status= '||l_return_status);
4980: END IF;

Line 4977: ( fnd_log.level_procedure,

4973: );
4974:
4975: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
4976: fnd_log.string
4977: ( fnd_log.level_procedure,
4978: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
4979: 'After calling AHL_VWP_VISITS_PVT.Delete_Visit, l_return_status= '||l_return_status);
4980: END IF;
4981: x_return_status := l_return_status ;

Line 4985: fnd_log.string(l_log_statement,

4981: x_return_status := l_return_status ;
4982: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
4983: l_msg_count := FND_MSG_PUB.count_msg;
4984: IF (l_log_statement >= l_log_current_level) THEN
4985: fnd_log.string(l_log_statement,
4986: L_DEBUG_KEY,
4987: 'Errors from Delete_Visit. Message count: ' || l_msg_count);
4988: END IF;
4989: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

Line 5008: fnd_log.string(l_log_statement,

5004: x_return_status => l_return_status );
5005: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
5006: l_msg_count := FND_MSG_PUB.count_msg;
5007: IF (l_log_statement >= l_log_current_level) THEN
5008: fnd_log.string(l_log_statement,
5009: L_DEBUG_KEY,
5010: 'Errors from Launch_Visit_Can_Notification ' );
5011: END IF;
5012: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

Line 5021: fnd_log.string(l_log_procedure,

5017: END IF; -- Return Status is not Success
5018: END IF; --IF l_ue_ids is not null then
5019:
5020: IF (l_log_procedure >= l_log_current_level) THEN
5021: fnd_log.string(l_log_procedure,
5022: L_DEBUG_KEY ||'.end',
5023: 'At the end of PL SQL function.');
5024: END IF;
5025:

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

5228: --
5229:
5230: BEGIN
5231: IF (l_log_procedure >= l_log_current_level) THEN
5232: FND_LOG.string(l_log_procedure, l_full_name || '.begin', 'At the start of the API');
5233: END IF;
5234:
5235: -- initialize procedure return status to success
5236: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 5239: FND_LOG.string(l_log_statement, l_full_name, 'the arguments: '||

5235: -- initialize procedure return status to success
5236: x_return_status := FND_API.G_RET_STS_SUCCESS;
5237:
5238: IF (l_log_statement >= l_log_current_level) THEN
5239: FND_LOG.string(l_log_statement, l_full_name, 'the arguments: '||
5240: ' Visit ID > '||p_visit_id||
5241: ' UE IDs > '||p_ue_ids||
5242: ', p_commit > '||p_commit);
5243: END IF;

Line 5274: FND_LOG.string(l_log_statement, l_full_name, 'the returned values from AHL_UTILITY_PVT.Get_WF_Process_Name : '||

5270: x_msg_data => l_msg_data,
5271: x_return_status => x_return_status);
5272:
5273: IF (l_log_statement >= l_log_current_level) THEN
5274: FND_LOG.string(l_log_statement, l_full_name, 'the returned values from AHL_UTILITY_PVT.Get_WF_Process_Name : '||
5275: ' l_active_flag > '||l_active_flag||
5276: ', l_process_name > '||l_process_name||
5277: ', l_item_type > '||l_item_type||
5278: ', x_return_status > '||x_return_status);

Line 5292: FND_LOG.string(l_log_statement, l_full_name,

5288: -- get the subject text
5289: l_subject := FND_MESSAGE.GET_STRING(G_APP_NAME, G_VISIT_CANC_SBJ);
5290:
5291: IF (l_log_statement >= l_log_current_level) THEN
5292: FND_LOG.string(l_log_statement, l_full_name,
5293: 'before calling AHL_WF_NOTIFICATION_PVT.Launch_OA_Notification with arguments: '||
5294: ' p_object > '||G_WF_CANC_OBJ||
5295: ', p_process_name > '||l_process_name||
5296: ', p_item_type > '||l_item_type||

Line 5322: FND_LOG.string(l_log_statement, l_full_name,

5318: x_item_key => x_item_key,
5319: x_return_status => x_return_status);
5320:
5321: IF (l_log_statement >= l_log_current_level) THEN
5322: FND_LOG.string(l_log_statement, l_full_name,
5323: 'after calling AHL_WF_NOTIFICATION_PVT.Launch_OA_Notification, '||
5324: ' x_item_key > '||x_item_key||
5325: ', x_return_status > '||x_return_status);
5326: END IF;

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

5336: COMMIT WORK;
5337: END IF;
5338:
5339: IF (l_log_procedure >= l_log_current_level) THEN
5340: FND_LOG.string(l_log_procedure, l_full_name || '.end', 'At the end of the API');
5341: END IF;
5342:
5343: END Launch_Visit_Can_Notification;
5344: ------------------------------------------------------------------------------------

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

5384: --
5385:
5386: BEGIN
5387: IF (l_log_procedure >= l_log_current_level) THEN
5388: FND_LOG.string(l_log_procedure, l_full_name || '.begin', 'At the start of the API');
5389: END IF;
5390:
5391: -- initialize procedure return status to success
5392: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 5395: FND_LOG.string(l_log_statement, l_full_name, 'the arguments: '||

5391: -- initialize procedure return status to success
5392: x_return_status := FND_API.G_RET_STS_SUCCESS;
5393:
5394: IF (l_log_statement >= l_log_current_level) THEN
5395: FND_LOG.string(l_log_statement, l_full_name, 'the arguments: '||
5396: ' Visit ID > '||p_visit_id||
5397: ' UE IDs > '||p_ue_ids||
5398: ', p_commit > '||p_commit);
5399: END IF;

Line 5430: FND_LOG.string(l_log_statement, l_full_name, 'the returned values from AHL_UTILITY_PVT.Get_WF_Process_Name : '||

5426: x_msg_data => l_msg_data,
5427: x_return_status => x_return_status);
5428:
5429: IF (l_log_statement >= l_log_current_level) THEN
5430: FND_LOG.string(l_log_statement, l_full_name, 'the returned values from AHL_UTILITY_PVT.Get_WF_Process_Name : '||
5431: ' l_active_flag > '||l_active_flag||
5432: ', l_process_name > '||l_process_name||
5433: ', l_item_type > '||l_item_type||
5434: ', x_return_status > '||x_return_status);

Line 5448: FND_LOG.string(l_log_statement, l_full_name,

5444: -- get the subject text
5445: l_subject := FND_MESSAGE.GET_STRING(G_APP_NAME, G_VISIT_USCE_SBJ);
5446:
5447: IF (l_log_statement >= l_log_current_level) THEN
5448: FND_LOG.string(l_log_statement, l_full_name,
5449: 'before calling AHL_WF_NOTIFICATION_PVT.Launch_OA_Notification with arguments: '||
5450: ' p_object > '||G_WF_VSCE_OBJ||
5451: ', p_process_name > '||l_process_name||
5452: ', p_item_type > '||l_item_type||

Line 5478: FND_LOG.string(l_log_statement, l_full_name,

5474: x_item_key => x_item_key,
5475: x_return_status => x_return_status);
5476:
5477: IF (l_log_statement >= l_log_current_level) THEN
5478: FND_LOG.string(l_log_statement, l_full_name,
5479: 'after calling AHL_WF_NOTIFICATION_PVT.Launch_OA_Notification, '||
5480: ' x_item_key > '||x_item_key||
5481: ', x_return_status > '||x_return_status);
5482: END IF;

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

5492: COMMIT WORK;
5493: END IF;
5494:
5495: IF (l_log_procedure >= l_log_current_level) THEN
5496: FND_LOG.string(l_log_procedure, l_full_name || '.end', 'At the end of the API');
5497: END IF;
5498:
5499: END Launch_Visit_SCE_Notification;
5500: ------------------------------------------------------------------------------------

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

5539: --
5540:
5541: BEGIN
5542: IF (l_log_procedure >= l_log_current_level) THEN
5543: FND_LOG.string(l_log_procedure, l_full_name || '.begin', 'At the start of the API');
5544: END IF;
5545:
5546: -- initialize procedure return status to success
5547: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 5550: FND_LOG.string(l_log_statement, l_full_name, 'the arguments: '||

5546: -- initialize procedure return status to success
5547: x_return_status := FND_API.G_RET_STS_SUCCESS;
5548:
5549: IF (l_log_statement >= l_log_current_level) THEN
5550: FND_LOG.string(l_log_statement, l_full_name, 'the arguments: '||
5551: 'Unit Schedule Id > '||p_unit_schedule_id||
5552: ' Visit IDs > '||p_visit_ids||
5553: ', p_commit > '||p_commit);
5554: END IF;

Line 5585: FND_LOG.string(l_log_statement, l_full_name, 'the returned values from AHL_UTILITY_PVT.Get_WF_Process_Name : '||

5581: x_msg_data => l_msg_data,
5582: x_return_status => x_return_status);
5583:
5584: IF (l_log_statement >= l_log_current_level) THEN
5585: FND_LOG.string(l_log_statement, l_full_name, 'the returned values from AHL_UTILITY_PVT.Get_WF_Process_Name : '||
5586: ' l_active_flag > '||l_active_flag||
5587: ', l_process_name > '||l_process_name||
5588: ', l_item_type > '||l_item_type||
5589: ', x_return_status > '||x_return_status);

Line 5603: FND_LOG.string(l_log_statement, l_full_name,

5599: -- get the subject text
5600: l_subject := FND_MESSAGE.GET_STRING(G_APP_NAME, G_VISIT_DISC_SBJ);
5601:
5602: IF (l_log_statement >= l_log_current_level) THEN
5603: FND_LOG.string(l_log_statement, l_full_name,
5604: 'before calling AHL_WF_NOTIFICATION_PVT.Launch_OA_Notification with arguments: '||
5605: ' p_object > '||G_WF_DISC_OBJ||
5606: ', p_process_name > '||l_process_name||
5607: ', p_item_type > '||l_item_type||

Line 5633: FND_LOG.string(l_log_statement, l_full_name,

5629: x_item_key => x_item_key,
5630: x_return_status => x_return_status);
5631:
5632: IF (l_log_statement >= l_log_current_level) THEN
5633: FND_LOG.string(l_log_statement, l_full_name,
5634: 'after calling AHL_WF_NOTIFICATION_PVT.Launch_OA_Notification, '||
5635: ' x_item_key > '||x_item_key||
5636: ', x_return_status > '||x_return_status);
5637: END IF;

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

5647: COMMIT WORK;
5648: END IF;
5649:
5650: IF (l_log_procedure >= l_log_current_level) THEN
5651: FND_LOG.string(l_log_procedure, l_full_name || '.end', 'At the end of the API');
5652: END IF;
5653:
5654: END Launch_Visit_Disc_Notification;
5655: ------------------------------------------------------------------------------------

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

5694: --
5695:
5696: BEGIN
5697: IF (l_log_procedure >= l_log_current_level) THEN
5698: FND_LOG.string(l_log_procedure, l_full_name || '.begin', 'At the start of the API');
5699: END IF;
5700:
5701: -- initialize procedure return status to success
5702: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 5705: FND_LOG.string(l_log_statement, l_full_name, 'the arguments: '||

5701: -- initialize procedure return status to success
5702: x_return_status := FND_API.G_RET_STS_SUCCESS;
5703:
5704: IF (l_log_statement >= l_log_current_level) THEN
5705: FND_LOG.string(l_log_statement, l_full_name, 'the arguments: '||
5706: 'Unit Schedule Id > '||p_unit_schedule_id||
5707: ' Visit ID > '||p_visit_ids||
5708: ', p_commit > '||p_commit);
5709: END IF;

Line 5740: FND_LOG.string(l_log_statement, l_full_name, 'the returned values from AHL_UTILITY_PVT.Get_WF_Process_Name : '||

5736: x_msg_data => l_msg_data,
5737: x_return_status => x_return_status);
5738:
5739: IF (l_log_statement >= l_log_current_level) THEN
5740: FND_LOG.string(l_log_statement, l_full_name, 'the returned values from AHL_UTILITY_PVT.Get_WF_Process_Name : '||
5741: ' l_active_flag > '||l_active_flag||
5742: ', l_process_name > '||l_process_name||
5743: ', l_item_type > '||l_item_type||
5744: ', x_return_status > '||x_return_status);

Line 5758: FND_LOG.string(l_log_statement, l_full_name,

5754: -- get the subject text
5755: l_subject := FND_MESSAGE.GET_STRING(G_APP_NAME, G_VISIT_DURA_SBJ);
5756:
5757: IF (l_log_statement >= l_log_current_level) THEN
5758: FND_LOG.string(l_log_statement, l_full_name,
5759: 'before calling AHL_WF_NOTIFICATION_PVT.Launch_OA_Notification with arguments: '||
5760: ' p_object > '||G_WF_VDUR_OBJ||
5761: ', p_process_name > '||l_process_name||
5762: ', p_item_type > '||l_item_type||

Line 5788: FND_LOG.string(l_log_statement, l_full_name,

5784: x_item_key => x_item_key,
5785: x_return_status => x_return_status);
5786:
5787: IF (l_log_statement >= l_log_current_level) THEN
5788: FND_LOG.string(l_log_statement, l_full_name,
5789: 'after calling AHL_WF_NOTIFICATION_PVT.Launch_OA_Notification, '||
5790: ' x_item_key > '||x_item_key||
5791: ', x_return_status > '||x_return_status);
5792: END IF;

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

5802: COMMIT WORK;
5803: END IF;
5804:
5805: IF (l_log_procedure >= l_log_current_level) THEN
5806: FND_LOG.string(l_log_procedure, l_full_name || '.end', 'At the end of the API');
5807: END IF;
5808:
5809: END Launch_Visit_Dur_Notification;
5810: ------------------------------------------------------------------------------------

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

5853: AND NVL(LOCKED_FLAG,'N') <> 'Y';
5854:
5855: BEGIN
5856: IF (l_log_procedure >= l_log_current_level) THEN
5857: FND_LOG.string(l_log_procedure, l_full_name || '.begin', 'At the start of the API');
5858: END IF;
5859:
5860: -- Standard start of API savepoint
5861: SAVEPOINT Load_Can_Cancel_Visit;

Line 5867: FND_LOG.string(l_log_statement, l_full_name, 'the arguments: '||

5863: -- initialize procedure return status to success
5864: x_return_status := FND_API.G_RET_STS_SUCCESS;
5865:
5866: IF (l_log_statement >= l_log_current_level) THEN
5867: FND_LOG.string(l_log_statement, l_full_name, 'the arguments: '||
5868: 'p_visit_id --@> '||p_visit_id||
5869: 'p_visit_id2 --@> '||p_visit_id2);
5870: END IF;
5871:

Line 5890: FND_LOG.string(l_log_statement, l_full_name, 'p_visit_id x_can_cancel_visit: '||p_visit_id||' '||x_can_cancel_visit);

5886: x_can_cancel_visit2 := 'X';
5887: END IF;
5888:
5889: IF (l_log_statement >= l_log_current_level) THEN
5890: FND_LOG.string(l_log_statement, l_full_name, 'p_visit_id ** x_can_cancel_visit: '||p_visit_id||' ** '||x_can_cancel_visit);
5891: FND_LOG.string(l_log_statement, l_full_name, 'p_visit_id2 ** x_can_cancel_visit2: '||p_visit_id2||' ** '||x_can_cancel_visit2);
5892: END IF;
5893:
5894: IF (l_log_procedure >= l_log_current_level) THEN

Line 5891: FND_LOG.string(l_log_statement, l_full_name, 'p_visit_id2 x_can_cancel_visit2: '||p_visit_id2||' '||x_can_cancel_visit2);

5887: END IF;
5888:
5889: IF (l_log_statement >= l_log_current_level) THEN
5890: FND_LOG.string(l_log_statement, l_full_name, 'p_visit_id ** x_can_cancel_visit: '||p_visit_id||' ** '||x_can_cancel_visit);
5891: FND_LOG.string(l_log_statement, l_full_name, 'p_visit_id2 ** x_can_cancel_visit2: '||p_visit_id2||' ** '||x_can_cancel_visit2);
5892: END IF;
5893:
5894: IF (l_log_procedure >= l_log_current_level) THEN
5895: FND_LOG.string(l_log_procedure, l_full_name || '.end', 'At the end of the API');

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

5891: FND_LOG.string(l_log_statement, l_full_name, 'p_visit_id2 ** x_can_cancel_visit2: '||p_visit_id2||' ** '||x_can_cancel_visit2);
5892: END IF;
5893:
5894: IF (l_log_procedure >= l_log_current_level) THEN
5895: FND_LOG.string(l_log_procedure, l_full_name || '.end', 'At the end of the API');
5896: END IF;
5897:
5898: EXCEPTION
5899:

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

5969:
5970: BEGIN
5971:
5972: IF (l_log_procedure >= l_log_current_level) THEN
5973: FND_LOG.string(l_log_procedure, l_full_name || '.begin', 'At the start of the API');
5974: END IF;
5975:
5976: -- Standard start of API savepoint
5977: SAVEPOINT Disconnect_Flight_Visit;

Line 5983: FND_LOG.string(l_log_statement, l_full_name, 'the arguments: '||

5979: -- initialize procedure return status to success
5980: x_return_status := FND_API.G_RET_STS_SUCCESS;
5981:
5982: IF (l_log_statement >= l_log_current_level) THEN
5983: FND_LOG.string(l_log_statement, l_full_name, 'the arguments: '||
5984: 'p_visit_id --@> '||p_visit_id||
5985: 'p_unit_schedule_id --@> '||p_unit_schedule_id);
5986: END IF;
5987:

Line 6006: fnd_log.string(l_log_statement,

6002: x_return_status => l_return_status );
6003: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
6004: x_msg_count := FND_MSG_PUB.count_msg;
6005: IF (l_log_statement >= l_log_current_level) THEN
6006: fnd_log.string(l_log_statement,
6007: l_full_name,
6008: 'Errors from Launch_Visit_Disc_Notification ' );
6009: END IF;
6010: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

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

6034: END IF;
6035: -- For Logging :: END
6036:
6037: IF (l_log_procedure >= l_log_current_level) THEN
6038: FND_LOG.string(l_log_procedure, l_full_name || '.end', 'At the end of the API');
6039: END IF;
6040:
6041: EXCEPTION
6042: