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.

[Home] [Help]

APPS.AHL_UA_FLIGHT_SCHEDULES_PUB dependencies on FND_LOG

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

37: l_unit_schedule_id NUMBER;
38: l_flight_schedule_rec AHL_UA_FLIGHT_SCHEDULES_PVT.FLIGHT_SCHEDULE_REC_TYPE;
39: BEGIN
40:
41: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
42: fnd_log.string
43: (
44: fnd_log.level_procedure,
45: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||'.begin',

Line 42: fnd_log.string

38: l_flight_schedule_rec AHL_UA_FLIGHT_SCHEDULES_PVT.FLIGHT_SCHEDULE_REC_TYPE;
39: BEGIN
40:
41: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
42: fnd_log.string
43: (
44: fnd_log.level_procedure,
45: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||'.begin',
46: 'At the start of PLSQL procedure'

Line 44: fnd_log.level_procedure,

40:
41: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
42: fnd_log.string
43: (
44: fnd_log.level_procedure,
45: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||'.begin',
46: 'At the start of PLSQL procedure'
47: );
48: END IF;

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

439: );
440: END LOOP;
441: CLOSE l_flight_schedule_csr;
442:
443: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
444: fnd_log.string
445: (
446: fnd_log.level_procedure,
447: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||'.begin',

Line 444: fnd_log.string

440: END LOOP;
441: CLOSE l_flight_schedule_csr;
442:
443: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
444: fnd_log.string
445: (
446: fnd_log.level_procedure,
447: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||'.begin',
448: 'At the end of PLSQL procedure'

Line 446: fnd_log.level_procedure,

442:
443: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
444: fnd_log.string
445: (
446: fnd_log.level_procedure,
447: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||'.begin',
448: 'At the end of PLSQL procedure'
449: );
450: END IF;

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

495: l_api_name CONSTANT VARCHAR2(30) := 'Process_Flight_Schedules';
496: l_api_version CONSTANT NUMBER := 1.0;
497: l_msg_count NUMBER;
498: BEGIN
499: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
500: fnd_log.string
501: (
502: fnd_log.level_procedure,
503: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||'.begin',

Line 500: fnd_log.string

496: l_api_version CONSTANT NUMBER := 1.0;
497: l_msg_count NUMBER;
498: BEGIN
499: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
500: fnd_log.string
501: (
502: fnd_log.level_procedure,
503: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||'.begin',
504: 'At the start of PLSQL procedure'

Line 502: fnd_log.level_procedure,

498: BEGIN
499: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
500: fnd_log.string
501: (
502: fnd_log.level_procedure,
503: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||'.begin',
504: 'At the start of PLSQL procedure'
505: );
506: END IF;

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

680: RAISE FND_API.G_EXC_ERROR;
681: END IF;
682:
683:
684: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
685: fnd_log.string
686: (
687: fnd_log.level_statement,
688: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',

Line 685: fnd_log.string

681: END IF;
682:
683:
684: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
685: fnd_log.string
686: (
687: fnd_log.level_statement,
688: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
689: 'Before calling the private API.....'

Line 687: fnd_log.level_statement,

683:
684: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
685: fnd_log.string
686: (
687: fnd_log.level_statement,
688: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
689: 'Before calling the private API.....'
690: );
691: END IF;

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

704: );
705:
706: -- Check Error Message stack.
707: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
708: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
709: fnd_log.string
710: (
711: fnd_log.level_error,
712: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',

Line 709: fnd_log.string

705:
706: -- Check Error Message stack.
707: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
708: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
709: fnd_log.string
710: (
711: fnd_log.level_error,
712: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
713: 'Private API raised expected error....'

Line 711: fnd_log.level_error,

707: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
708: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
709: fnd_log.string
710: (
711: fnd_log.level_error,
712: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
713: 'Private API raised expected error....'
714: );
715: END IF;

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

714: );
715: END IF;
716: RAISE FND_API.G_EXC_ERROR;
717: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
718: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
719: fnd_log.string
720: (
721: fnd_log.level_error,
722: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',

Line 719: fnd_log.string

715: END IF;
716: RAISE FND_API.G_EXC_ERROR;
717: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
718: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
719: fnd_log.string
720: (
721: fnd_log.level_error,
722: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
723: 'Private API raised unexpected error....'

Line 721: fnd_log.level_error,

717: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
718: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
719: fnd_log.string
720: (
721: fnd_log.level_error,
722: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
723: 'Private API raised unexpected error....'
724: );
725: END IF;

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

731: THEN
732: COMMIT;
733: END IF;
734:
735: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
736: fnd_log.string
737: (
738: fnd_log.level_procedure,
739: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||'.begin',

Line 736: fnd_log.string

732: COMMIT;
733: END IF;
734:
735: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
736: fnd_log.string
737: (
738: fnd_log.level_procedure,
739: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||'.begin',
740: 'At the end of PLSQL procedure'

Line 738: fnd_log.level_procedure,

734:
735: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
736: fnd_log.string
737: (
738: fnd_log.level_procedure,
739: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||'.begin',
740: 'At the end of PLSQL procedure'
741: );
742: END IF;

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

819: l_x_flight_schedules_tbl AHL_UA_FLIGHT_SCHEDULES_PVT.FLIGHT_SCHEDULES_TBL_TYPE;
820: l_api_name CONSTANT VARCHAR2(30) := 'handle_flight_schedules';
821: BEGIN
822:
823: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
824: fnd_log.string
825: (
826: fnd_log.level_procedure,
827: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||'.begin',

Line 824: fnd_log.string

820: l_api_name CONSTANT VARCHAR2(30) := 'handle_flight_schedules';
821: BEGIN
822:
823: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
824: fnd_log.string
825: (
826: fnd_log.level_procedure,
827: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||'.begin',
828: 'At the start of procedure'

Line 826: fnd_log.level_procedure,

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

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

885: l_x_flight_schedules_tbl(i).DML_OPERATION := p_x_flght_visit_schedules_tbl(i).DML_OPERATION;
886: END LOOP;
887:
888: -- Call the private procedure for processing visits
889: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
890: fnd_log.string
891: (
892: fnd_log.level_statement,
893: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',

Line 890: fnd_log.string

886: END LOOP;
887:
888: -- Call the private procedure for processing visits
889: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
890: fnd_log.string
891: (
892: fnd_log.level_statement,
893: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
894: 'Calling AHL_UA_FLIGHT_SCHEDULES_PVT.Process_Flight_Schedules..'

Line 892: fnd_log.level_statement,

888: -- Call the private procedure for processing visits
889: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
890: fnd_log.string
891: (
892: fnd_log.level_statement,
893: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
894: 'Calling AHL_UA_FLIGHT_SCHEDULES_PVT.Process_Flight_Schedules..'
895: );
896: END IF;

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

907: x_msg_data => x_msg_data,
908: p_x_flight_schedules_tbl => l_x_flight_schedules_tbl
909: );
910:
911: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
912: fnd_log.string
913: (
914: fnd_log.level_statement,
915: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',

Line 912: fnd_log.string

908: p_x_flight_schedules_tbl => l_x_flight_schedules_tbl
909: );
910:
911: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
912: fnd_log.string
913: (
914: fnd_log.level_statement,
915: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
916: 'After calling AHL_UA_FLIGHT_SCHEDULES_PVT.Process_Flight_Schedules....'

Line 914: fnd_log.level_statement,

910:
911: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
912: fnd_log.string
913: (
914: fnd_log.level_statement,
915: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
916: 'After calling AHL_UA_FLIGHT_SCHEDULES_PVT.Process_Flight_Schedules....'
917: );
918: END IF;

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

918: END IF;
919:
920: -- Check Error Message stack.
921: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
922: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
923: fnd_log.string
924: (
925: fnd_log.level_error,
926: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',

Line 923: fnd_log.string

919:
920: -- Check Error Message stack.
921: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
922: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
923: fnd_log.string
924: (
925: fnd_log.level_error,
926: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
927: 'AHL_UA_FLIGHT_SCHEDULES_PVT.Process_Flight_Schedules API raised expected error....'

Line 925: fnd_log.level_error,

921: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
922: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
923: fnd_log.string
924: (
925: fnd_log.level_error,
926: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
927: 'AHL_UA_FLIGHT_SCHEDULES_PVT.Process_Flight_Schedules API raised expected error....'
928: );
929: END IF;

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

928: );
929: END IF;
930: RAISE FND_API.G_EXC_ERROR;
931: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
932: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
933: fnd_log.string
934: (
935: fnd_log.level_error,
936: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',

Line 933: fnd_log.string

929: END IF;
930: RAISE FND_API.G_EXC_ERROR;
931: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
932: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
933: fnd_log.string
934: (
935: fnd_log.level_error,
936: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
937: 'AHL_UA_FLIGHT_SCHEDULES_PVT.Process_Flight_Schedules API raised unexpected error....'

Line 935: fnd_log.level_error,

931: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
932: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
933: fnd_log.string
934: (
935: fnd_log.level_error,
936: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
937: 'AHL_UA_FLIGHT_SCHEDULES_PVT.Process_Flight_Schedules API raised unexpected error....'
938: );
939: END IF;

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

995: p_x_flght_visit_schedules_tbl(i).ATTRIBUTE13 := l_x_flight_schedules_tbl(i).ATTRIBUTE13;
996: p_x_flght_visit_schedules_tbl(i).ATTRIBUTE14 := l_x_flight_schedules_tbl(i).ATTRIBUTE14;
997: p_x_flght_visit_schedules_tbl(i).ATTRIBUTE15 := l_x_flight_schedules_tbl(i).ATTRIBUTE15;
998: END LOOP;
999: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
1000: fnd_log.string
1001: (
1002: fnd_log.level_procedure,
1003: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||'.begin',

Line 1000: fnd_log.string

996: p_x_flght_visit_schedules_tbl(i).ATTRIBUTE14 := l_x_flight_schedules_tbl(i).ATTRIBUTE14;
997: p_x_flght_visit_schedules_tbl(i).ATTRIBUTE15 := l_x_flight_schedules_tbl(i).ATTRIBUTE15;
998: END LOOP;
999: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
1000: fnd_log.string
1001: (
1002: fnd_log.level_procedure,
1003: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||'.begin',
1004: 'At the end of procedure'

Line 1002: fnd_log.level_procedure,

998: END LOOP;
999: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
1000: fnd_log.string
1001: (
1002: fnd_log.level_procedure,
1003: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||'.begin',
1004: 'At the end of procedure'
1005: );
1006: END IF;

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

1030: l_api_name CONSTANT VARCHAR2(30) := 'auto_create_transit_visit';
1031: l_api_version CONSTANT NUMBER := 1.0;
1032: BEGIN
1033:
1034: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
1035: fnd_log.string
1036: (
1037: fnd_log.level_procedure,
1038: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||'.begin',

Line 1035: fnd_log.string

1031: l_api_version CONSTANT NUMBER := 1.0;
1032: BEGIN
1033:
1034: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
1035: fnd_log.string
1036: (
1037: fnd_log.level_procedure,
1038: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||'.begin',
1039: 'At the start of procedure'

Line 1037: fnd_log.level_procedure,

1033:
1034: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
1035: fnd_log.string
1036: (
1037: fnd_log.level_procedure,
1038: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||'.begin',
1039: 'At the start of procedure'
1040: );
1041: END IF;

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

1086: );
1087:
1088: -- Check Error Message stack.
1089: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1090: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1091: fnd_log.string
1092: (
1093: fnd_log.level_error,
1094: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',

Line 1091: fnd_log.string

1087:
1088: -- Check Error Message stack.
1089: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1090: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1091: fnd_log.string
1092: (
1093: fnd_log.level_error,
1094: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1095: 'AHL_UA_FLIGHT_SCHEDULES_PVT.Process_Flight_Schedules API raised expected error....'

Line 1093: fnd_log.level_error,

1089: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1090: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1091: fnd_log.string
1092: (
1093: fnd_log.level_error,
1094: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1095: 'AHL_UA_FLIGHT_SCHEDULES_PVT.Process_Flight_Schedules API raised expected error....'
1096: );
1097: END IF;

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

1096: );
1097: END IF;
1098: RAISE FND_API.G_EXC_ERROR;
1099: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1100: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1101: fnd_log.string
1102: (
1103: fnd_log.level_error,
1104: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',

Line 1101: fnd_log.string

1097: END IF;
1098: RAISE FND_API.G_EXC_ERROR;
1099: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1100: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1101: fnd_log.string
1102: (
1103: fnd_log.level_error,
1104: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1105: 'AHL_UA_FLIGHT_SCHEDULES_PVT.Process_Flight_Schedules API raised unexpected error....'

Line 1103: fnd_log.level_error,

1099: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1100: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1101: fnd_log.string
1102: (
1103: fnd_log.level_error,
1104: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1105: 'AHL_UA_FLIGHT_SCHEDULES_PVT.Process_Flight_Schedules API raised unexpected error....'
1106: );
1107: END IF;

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

1123: );
1124:
1125: -- Check Error Message stack.
1126: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1127: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1128: fnd_log.string
1129: (
1130: fnd_log.level_error,
1131: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',

Line 1128: fnd_log.string

1124:
1125: -- Check Error Message stack.
1126: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1127: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1128: fnd_log.string
1129: (
1130: fnd_log.level_error,
1131: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1132: 'AHL_UA_FLIGHT_SCHEDULES_PVT.Process_Flight_Schedules API raised expected error....'

Line 1130: fnd_log.level_error,

1126: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1127: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1128: fnd_log.string
1129: (
1130: fnd_log.level_error,
1131: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1132: 'AHL_UA_FLIGHT_SCHEDULES_PVT.Process_Flight_Schedules API raised expected error....'
1133: );
1134: END IF;

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

1133: );
1134: END IF;
1135: RAISE FND_API.G_EXC_ERROR;
1136: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1137: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1138: fnd_log.string
1139: (
1140: fnd_log.level_error,
1141: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',

Line 1138: fnd_log.string

1134: END IF;
1135: RAISE FND_API.G_EXC_ERROR;
1136: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1137: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1138: fnd_log.string
1139: (
1140: fnd_log.level_error,
1141: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1142: 'AHL_UA_FLIGHT_SCHEDULES_PVT.Process_Flight_Schedules API raised unexpected error....'

Line 1140: fnd_log.level_error,

1136: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1137: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1138: fnd_log.string
1139: (
1140: fnd_log.level_error,
1141: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1142: 'AHL_UA_FLIGHT_SCHEDULES_PVT.Process_Flight_Schedules API raised unexpected error....'
1143: );
1144: END IF;

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

1155: l_x_visit_tbl(j).PLAN_END_HOUR := TO_NUMBER(TO_CHAR(l_x_visit_tbl(j).PLAN_END_DATE, 'HH24'));
1156: l_x_visit_tbl(j).PLAN_END_MIN := TO_NUMBER(TO_CHAR(l_x_visit_tbl(j).PLAN_END_DATE, 'MI'));
1157: END IF;
1158:
1159: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1160: fnd_log.string
1161: (
1162: fnd_log.level_statement,
1163: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',

Line 1160: fnd_log.string

1156: l_x_visit_tbl(j).PLAN_END_MIN := TO_NUMBER(TO_CHAR(l_x_visit_tbl(j).PLAN_END_DATE, 'MI'));
1157: END IF;
1158:
1159: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1160: fnd_log.string
1161: (
1162: fnd_log.level_statement,
1163: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1164: 'l_x_visit_tbl(j).VISIT_NAME->'||l_x_visit_tbl(j).VISIT_NAME

Line 1162: fnd_log.level_statement,

1158:
1159: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1160: fnd_log.string
1161: (
1162: fnd_log.level_statement,
1163: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1164: 'l_x_visit_tbl(j).VISIT_NAME->'||l_x_visit_tbl(j).VISIT_NAME
1165: );
1166: fnd_log.string

Line 1166: fnd_log.string

1162: fnd_log.level_statement,
1163: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1164: 'l_x_visit_tbl(j).VISIT_NAME->'||l_x_visit_tbl(j).VISIT_NAME
1165: );
1166: fnd_log.string
1167: (
1168: fnd_log.level_statement,
1169: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1170: 'l_x_visit_tbl(j).ORGANIZATION_ID->'||l_x_visit_tbl(j).ORGANIZATION_ID

Line 1168: fnd_log.level_statement,

1164: 'l_x_visit_tbl(j).VISIT_NAME->'||l_x_visit_tbl(j).VISIT_NAME
1165: );
1166: fnd_log.string
1167: (
1168: fnd_log.level_statement,
1169: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1170: 'l_x_visit_tbl(j).ORGANIZATION_ID->'||l_x_visit_tbl(j).ORGANIZATION_ID
1171: );
1172: fnd_log.string

Line 1172: fnd_log.string

1168: fnd_log.level_statement,
1169: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1170: 'l_x_visit_tbl(j).ORGANIZATION_ID->'||l_x_visit_tbl(j).ORGANIZATION_ID
1171: );
1172: fnd_log.string
1173: (
1174: fnd_log.level_statement,
1175: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1176: 'l_x_visit_tbl(j).DEPARTMENT_ID->'||l_x_visit_tbl(j).DEPARTMENT_ID

Line 1174: fnd_log.level_statement,

1170: 'l_x_visit_tbl(j).ORGANIZATION_ID->'||l_x_visit_tbl(j).ORGANIZATION_ID
1171: );
1172: fnd_log.string
1173: (
1174: fnd_log.level_statement,
1175: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1176: 'l_x_visit_tbl(j).DEPARTMENT_ID->'||l_x_visit_tbl(j).DEPARTMENT_ID
1177: );
1178: fnd_log.string

Line 1178: fnd_log.string

1174: fnd_log.level_statement,
1175: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1176: 'l_x_visit_tbl(j).DEPARTMENT_ID->'||l_x_visit_tbl(j).DEPARTMENT_ID
1177: );
1178: fnd_log.string
1179: (
1180: fnd_log.level_statement,
1181: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1182: 'l_x_visit_tbl(j).START_DATE->'||l_x_visit_tbl(j).START_DATE

Line 1180: fnd_log.level_statement,

1176: 'l_x_visit_tbl(j).DEPARTMENT_ID->'||l_x_visit_tbl(j).DEPARTMENT_ID
1177: );
1178: fnd_log.string
1179: (
1180: fnd_log.level_statement,
1181: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1182: 'l_x_visit_tbl(j).START_DATE->'||l_x_visit_tbl(j).START_DATE
1183: );
1184: fnd_log.string

Line 1184: fnd_log.string

1180: fnd_log.level_statement,
1181: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1182: 'l_x_visit_tbl(j).START_DATE->'||l_x_visit_tbl(j).START_DATE
1183: );
1184: fnd_log.string
1185: (
1186: fnd_log.level_statement,
1187: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1188: 'l_x_visit_tbl(j).VISIT_TYPE_CODE->'||l_x_visit_tbl(j).VISIT_TYPE_CODE

Line 1186: fnd_log.level_statement,

1182: 'l_x_visit_tbl(j).START_DATE->'||l_x_visit_tbl(j).START_DATE
1183: );
1184: fnd_log.string
1185: (
1186: fnd_log.level_statement,
1187: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1188: 'l_x_visit_tbl(j).VISIT_TYPE_CODE->'||l_x_visit_tbl(j).VISIT_TYPE_CODE
1189: );
1190: fnd_log.string

Line 1190: fnd_log.string

1186: fnd_log.level_statement,
1187: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1188: 'l_x_visit_tbl(j).VISIT_TYPE_CODE->'||l_x_visit_tbl(j).VISIT_TYPE_CODE
1189: );
1190: fnd_log.string
1191: (
1192: fnd_log.level_statement,
1193: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1194: 'l_x_visit_tbl(j).VISIT_TYPE_NAME->'||l_x_visit_tbl(j).VISIT_TYPE_NAME

Line 1192: fnd_log.level_statement,

1188: 'l_x_visit_tbl(j).VISIT_TYPE_CODE->'||l_x_visit_tbl(j).VISIT_TYPE_CODE
1189: );
1190: fnd_log.string
1191: (
1192: fnd_log.level_statement,
1193: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1194: 'l_x_visit_tbl(j).VISIT_TYPE_NAME->'||l_x_visit_tbl(j).VISIT_TYPE_NAME
1195: );
1196: fnd_log.string

Line 1196: fnd_log.string

1192: fnd_log.level_statement,
1193: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1194: 'l_x_visit_tbl(j).VISIT_TYPE_NAME->'||l_x_visit_tbl(j).VISIT_TYPE_NAME
1195: );
1196: fnd_log.string
1197: (
1198: fnd_log.level_statement,
1199: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1200: 'l_x_visit_tbl(j).VISIT_CREATE_TYPE->'||l_x_visit_tbl(j).VISIT_CREATE_TYPE

Line 1198: fnd_log.level_statement,

1194: 'l_x_visit_tbl(j).VISIT_TYPE_NAME->'||l_x_visit_tbl(j).VISIT_TYPE_NAME
1195: );
1196: fnd_log.string
1197: (
1198: fnd_log.level_statement,
1199: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1200: 'l_x_visit_tbl(j).VISIT_CREATE_TYPE->'||l_x_visit_tbl(j).VISIT_CREATE_TYPE
1201: );
1202: fnd_log.string

Line 1202: fnd_log.string

1198: fnd_log.level_statement,
1199: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1200: 'l_x_visit_tbl(j).VISIT_CREATE_TYPE->'||l_x_visit_tbl(j).VISIT_CREATE_TYPE
1201: );
1202: fnd_log.string
1203: (
1204: fnd_log.level_statement,
1205: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1206: 'l_x_visit_tbl(j).UNIT_NAME->'||l_x_visit_tbl(j).UNIT_NAME

Line 1204: fnd_log.level_statement,

1200: 'l_x_visit_tbl(j).VISIT_CREATE_TYPE->'||l_x_visit_tbl(j).VISIT_CREATE_TYPE
1201: );
1202: fnd_log.string
1203: (
1204: fnd_log.level_statement,
1205: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1206: 'l_x_visit_tbl(j).UNIT_NAME->'||l_x_visit_tbl(j).UNIT_NAME
1207: );
1208: fnd_log.string

Line 1208: fnd_log.string

1204: fnd_log.level_statement,
1205: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1206: 'l_x_visit_tbl(j).UNIT_NAME->'||l_x_visit_tbl(j).UNIT_NAME
1207: );
1208: fnd_log.string
1209: (
1210: fnd_log.level_statement,
1211: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1212: 'l_x_visit_tbl(j).ITEM_INSTANCE_ID->'||l_x_visit_tbl(j).ITEM_INSTANCE_ID

Line 1210: fnd_log.level_statement,

1206: 'l_x_visit_tbl(j).UNIT_NAME->'||l_x_visit_tbl(j).UNIT_NAME
1207: );
1208: fnd_log.string
1209: (
1210: fnd_log.level_statement,
1211: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1212: 'l_x_visit_tbl(j).ITEM_INSTANCE_ID->'||l_x_visit_tbl(j).ITEM_INSTANCE_ID
1213: );
1214: fnd_log.string

Line 1214: fnd_log.string

1210: fnd_log.level_statement,
1211: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1212: 'l_x_visit_tbl(j).ITEM_INSTANCE_ID->'||l_x_visit_tbl(j).ITEM_INSTANCE_ID
1213: );
1214: fnd_log.string
1215: (
1216: fnd_log.level_statement,
1217: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1218: 'l_x_visit_tbl(j).ITEM_NAME->'||l_x_visit_tbl(j).ITEM_NAME

Line 1216: fnd_log.level_statement,

1212: 'l_x_visit_tbl(j).ITEM_INSTANCE_ID->'||l_x_visit_tbl(j).ITEM_INSTANCE_ID
1213: );
1214: fnd_log.string
1215: (
1216: fnd_log.level_statement,
1217: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1218: 'l_x_visit_tbl(j).ITEM_NAME->'||l_x_visit_tbl(j).ITEM_NAME
1219: );
1220: fnd_log.string

Line 1220: fnd_log.string

1216: fnd_log.level_statement,
1217: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1218: 'l_x_visit_tbl(j).ITEM_NAME->'||l_x_visit_tbl(j).ITEM_NAME
1219: );
1220: fnd_log.string
1221: (
1222: fnd_log.level_statement,
1223: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1224: 'l_x_visit_tbl(j).SERIAL_NUMBER->'||l_x_visit_tbl(j).SERIAL_NUMBER

Line 1222: fnd_log.level_statement,

1218: 'l_x_visit_tbl(j).ITEM_NAME->'||l_x_visit_tbl(j).ITEM_NAME
1219: );
1220: fnd_log.string
1221: (
1222: fnd_log.level_statement,
1223: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1224: 'l_x_visit_tbl(j).SERIAL_NUMBER->'||l_x_visit_tbl(j).SERIAL_NUMBER
1225: );
1226: fnd_log.string

Line 1226: fnd_log.string

1222: fnd_log.level_statement,
1223: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1224: 'l_x_visit_tbl(j).SERIAL_NUMBER->'||l_x_visit_tbl(j).SERIAL_NUMBER
1225: );
1226: fnd_log.string
1227: (
1228: fnd_log.level_statement,
1229: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1230: 'l_x_visit_tbl(j).UNIT_SCHEDULE_ID->'||l_x_visit_tbl(j).UNIT_SCHEDULE_ID

Line 1228: fnd_log.level_statement,

1224: 'l_x_visit_tbl(j).SERIAL_NUMBER->'||l_x_visit_tbl(j).SERIAL_NUMBER
1225: );
1226: fnd_log.string
1227: (
1228: fnd_log.level_statement,
1229: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1230: 'l_x_visit_tbl(j).UNIT_SCHEDULE_ID->'||l_x_visit_tbl(j).UNIT_SCHEDULE_ID
1231: );
1232:

Line 1233: fnd_log.string

1229: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1230: 'l_x_visit_tbl(j).UNIT_SCHEDULE_ID->'||l_x_visit_tbl(j).UNIT_SCHEDULE_ID
1231: );
1232:
1233: fnd_log.string
1234: (
1235: fnd_log.level_statement,
1236: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1237: 'l_x_visit_tbl(j).OPERATION_FLAG->'||l_x_visit_tbl(j).OPERATION_FLAG

Line 1235: fnd_log.level_statement,

1231: );
1232:
1233: fnd_log.string
1234: (
1235: fnd_log.level_statement,
1236: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1237: 'l_x_visit_tbl(j).OPERATION_FLAG->'||l_x_visit_tbl(j).OPERATION_FLAG
1238: );
1239: END IF;

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

1242:
1243: IF l_x_visit_tbl.COUNT > 0
1244: THEN
1245:
1246: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1247: fnd_log.string
1248: (
1249: fnd_log.level_statement,
1250: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',

Line 1247: fnd_log.string

1243: IF l_x_visit_tbl.COUNT > 0
1244: THEN
1245:
1246: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1247: fnd_log.string
1248: (
1249: fnd_log.level_statement,
1250: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1251: 'Calling AHL_VWP_VISITS_PVT.Process_Visit'

Line 1249: fnd_log.level_statement,

1245:
1246: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1247: fnd_log.string
1248: (
1249: fnd_log.level_statement,
1250: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1251: 'Calling AHL_VWP_VISITS_PVT.Process_Visit'
1252: );
1253: END IF;

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

1263: x_msg_count => x_msg_count,
1264: x_msg_data => x_msg_data
1265: );
1266:
1267: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1268: fnd_log.string
1269: (
1270: fnd_log.level_statement,
1271: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',

Line 1268: fnd_log.string

1264: x_msg_data => x_msg_data
1265: );
1266:
1267: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1268: fnd_log.string
1269: (
1270: fnd_log.level_statement,
1271: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1272: 'After calling AHL_VWP_VISITS_PVT.Process_Visit'

Line 1270: fnd_log.level_statement,

1266:
1267: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1268: fnd_log.string
1269: (
1270: fnd_log.level_statement,
1271: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1272: 'After calling AHL_VWP_VISITS_PVT.Process_Visit'
1273: );
1274: END IF;

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

1274: END IF;
1275:
1276: -- Check Error Message stack.
1277: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1278: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1279: fnd_log.string
1280: (
1281: fnd_log.level_error,
1282: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',

Line 1279: fnd_log.string

1275:
1276: -- Check Error Message stack.
1277: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1278: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1279: fnd_log.string
1280: (
1281: fnd_log.level_error,
1282: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1283: 'AHL_VWP_VISITS_PVT.Process_Visit API raised expected error....'

Line 1281: fnd_log.level_error,

1277: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1278: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1279: fnd_log.string
1280: (
1281: fnd_log.level_error,
1282: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1283: 'AHL_VWP_VISITS_PVT.Process_Visit API raised expected error....'
1284: );
1285: END IF;

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

1284: );
1285: END IF;
1286: RAISE FND_API.G_EXC_ERROR;
1287: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1288: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1289: fnd_log.string
1290: (
1291: fnd_log.level_error,
1292: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',

Line 1289: fnd_log.string

1285: END IF;
1286: RAISE FND_API.G_EXC_ERROR;
1287: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1288: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1289: fnd_log.string
1290: (
1291: fnd_log.level_error,
1292: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1293: 'AHL_VWP_VISITS_PVT.Process_Visit API raised unexpected error....'

Line 1291: fnd_log.level_error,

1287: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1288: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1289: fnd_log.string
1290: (
1291: fnd_log.level_error,
1292: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1293: 'AHL_VWP_VISITS_PVT.Process_Visit API raised unexpected error....'
1294: );
1295: END IF;

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

1313: END LOOP;
1314:
1315: END IF;
1316:
1317: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
1318: fnd_log.string
1319: (
1320: fnd_log.level_procedure,
1321: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||'.begin',

Line 1318: fnd_log.string

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

Line 1320: fnd_log.level_procedure,

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

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

1349: p_flight_visit_sch_tbl(i).DML_OPERATION <> 'C' AND p_flight_visit_sch_tbl(i).DML_OPERATION <> 'c'
1350: )
1351: )
1352: THEN
1353: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1354: fnd_log.string
1355: (
1356: fnd_log.level_error,
1357: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',

Line 1354: fnd_log.string

1350: )
1351: )
1352: THEN
1353: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1354: fnd_log.string
1355: (
1356: fnd_log.level_error,
1357: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1358: 'Invalid DML Operation flag for '

Line 1356: fnd_log.level_error,

1352: THEN
1353: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1354: fnd_log.string
1355: (
1356: fnd_log.level_error,
1357: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1358: 'Invalid DML Operation flag for '
1359: ||p_flight_visit_sch_tbl(i).unit_schedule_id
1360: );

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

1374: --Unit Schedule id cannot be null
1375: IF (p_flight_visit_sch_tbl(i).UNIT_SCHEDULE_ID IS NULL OR
1376: p_flight_visit_sch_tbl(i).UNIT_SCHEDULE_ID = FND_API.G_MISS_NUM)
1377: THEN
1378: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1379: fnd_log.string
1380: (
1381: fnd_log.level_error,
1382: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',

Line 1379: fnd_log.string

1375: IF (p_flight_visit_sch_tbl(i).UNIT_SCHEDULE_ID IS NULL OR
1376: p_flight_visit_sch_tbl(i).UNIT_SCHEDULE_ID = FND_API.G_MISS_NUM)
1377: THEN
1378: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1379: fnd_log.string
1380: (
1381: fnd_log.level_error,
1382: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1383: 'Flight Schedule doesnt id cannot be null '

Line 1381: fnd_log.level_error,

1377: THEN
1378: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1379: fnd_log.string
1380: (
1381: fnd_log.level_error,
1382: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1383: 'Flight Schedule doesnt id cannot be null '
1384: );
1385: END IF;

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

1392: -- Check for Object Version number.
1393: IF (p_flight_visit_sch_tbl(i).OBJECT_VERSION_NUMBER IS NULL OR
1394: p_flight_visit_sch_tbl(i).OBJECT_VERSION_NUMBER = FND_API.G_MISS_NUM)
1395: THEN
1396: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1397: fnd_log.string
1398: (
1399: fnd_log.level_error,
1400: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',

Line 1397: fnd_log.string

1393: IF (p_flight_visit_sch_tbl(i).OBJECT_VERSION_NUMBER IS NULL OR
1394: p_flight_visit_sch_tbl(i).OBJECT_VERSION_NUMBER = FND_API.G_MISS_NUM)
1395: THEN
1396: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1397: fnd_log.string
1398: (
1399: fnd_log.level_error,
1400: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1401: 'Object version number cannot be null for '

Line 1399: fnd_log.level_error,

1395: THEN
1396: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1397: fnd_log.string
1398: (
1399: fnd_log.level_error,
1400: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1401: 'Object version number cannot be null for '
1402: ||p_flight_visit_sch_tbl(i).unit_schedule_id
1403: );

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

1420: (p_flight_visit_sch_tbl(i).UNIT_CONFIG_NAME IS NULL OR
1421: p_flight_visit_sch_tbl(i).UNIT_CONFIG_NAME = FND_API.G_MISS_CHAR)
1422:
1423: THEN
1424: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1425: fnd_log.string
1426: (
1427: fnd_log.level_error,
1428: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',

Line 1425: fnd_log.string

1421: p_flight_visit_sch_tbl(i).UNIT_CONFIG_NAME = FND_API.G_MISS_CHAR)
1422:
1423: THEN
1424: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1425: fnd_log.string
1426: (
1427: fnd_log.level_error,
1428: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1429: 'Unit config header id and name, both cannot be null for '

Line 1427: fnd_log.level_error,

1423: THEN
1424: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1425: fnd_log.string
1426: (
1427: fnd_log.level_error,
1428: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1429: 'Unit config header id and name, both cannot be null for '
1430: ||p_flight_visit_sch_tbl(i).unit_schedule_id
1431: );

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

1439: --Flight Number is a mandatory input field and cannot be null.
1440: IF p_flight_visit_sch_tbl(i).FLIGHT_NUMBER IS NULL OR
1441: p_flight_visit_sch_tbl(i).FLIGHT_NUMBER = FND_API.G_MISS_CHAR
1442: THEN
1443: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1444: fnd_log.string
1445: (
1446: fnd_log.level_error,
1447: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',

Line 1444: fnd_log.string

1440: IF p_flight_visit_sch_tbl(i).FLIGHT_NUMBER IS NULL OR
1441: p_flight_visit_sch_tbl(i).FLIGHT_NUMBER = FND_API.G_MISS_CHAR
1442: THEN
1443: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1444: fnd_log.string
1445: (
1446: fnd_log.level_error,
1447: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1448: 'Flight Number cannot be null for '

Line 1446: fnd_log.level_error,

1442: THEN
1443: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1444: fnd_log.string
1445: (
1446: fnd_log.level_error,
1447: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1448: 'Flight Number cannot be null for '
1449: ||p_flight_visit_sch_tbl(i).unit_schedule_id
1450: );

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

1458: --Segment is a mandatory input field and cannot be null
1459: IF p_flight_visit_sch_tbl(i).SEGMENT IS NULL OR
1460: p_flight_visit_sch_tbl(i).SEGMENT = FND_API.G_MISS_CHAR
1461: THEN
1462: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1463: fnd_log.string
1464: (
1465: fnd_log.level_error,
1466: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',

Line 1463: fnd_log.string

1459: IF p_flight_visit_sch_tbl(i).SEGMENT IS NULL OR
1460: p_flight_visit_sch_tbl(i).SEGMENT = FND_API.G_MISS_CHAR
1461: THEN
1462: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1463: fnd_log.string
1464: (
1465: fnd_log.level_error,
1466: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1467: 'Flight Segment cannot be null for '

Line 1465: fnd_log.level_error,

1461: THEN
1462: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1463: fnd_log.string
1464: (
1465: fnd_log.level_error,
1466: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1467: 'Flight Segment cannot be null for '
1468: ||p_flight_visit_sch_tbl(i).unit_schedule_id
1469: );

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

1479: p_flight_visit_sch_tbl(i).DEPARTURE_DEPT_ID = FND_API.G_MISS_NUM ) AND
1480: ( p_flight_visit_sch_tbl(i).DEPARTURE_DEPT_CODE IS NULL OR
1481: p_flight_visit_sch_tbl(i).DEPARTURE_DEPT_CODE = FND_API.G_MISS_CHAR )
1482: THEN
1483: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1484: fnd_log.string
1485: (
1486: fnd_log.level_error,
1487: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',

Line 1484: fnd_log.string

1480: ( p_flight_visit_sch_tbl(i).DEPARTURE_DEPT_CODE IS NULL OR
1481: p_flight_visit_sch_tbl(i).DEPARTURE_DEPT_CODE = FND_API.G_MISS_CHAR )
1482: THEN
1483: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1484: fnd_log.string
1485: (
1486: fnd_log.level_error,
1487: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1488: 'Departure Department id and code, both cannot be null '

Line 1486: fnd_log.level_error,

1482: THEN
1483: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1484: fnd_log.string
1485: (
1486: fnd_log.level_error,
1487: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1488: 'Departure Department id and code, both cannot be null '
1489: ||p_flight_visit_sch_tbl(i).unit_schedule_id
1490: );

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

1500: p_flight_visit_sch_tbl(i).DEPARTURE_ORG_ID = FND_API.G_MISS_NUM ) AND
1501: ( p_flight_visit_sch_tbl(i).DEPARTURE_ORG_CODE IS NULL OR
1502: p_flight_visit_sch_tbl(i).DEPARTURE_ORG_CODE = FND_API.G_MISS_CHAR )
1503: THEN
1504: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1505: fnd_log.string
1506: (
1507: fnd_log.level_error,
1508: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',

Line 1505: fnd_log.string

1501: ( p_flight_visit_sch_tbl(i).DEPARTURE_ORG_CODE IS NULL OR
1502: p_flight_visit_sch_tbl(i).DEPARTURE_ORG_CODE = FND_API.G_MISS_CHAR )
1503: THEN
1504: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1505: fnd_log.string
1506: (
1507: fnd_log.level_error,
1508: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1509: 'Departure Org id and code, both cannot be null '

Line 1507: fnd_log.level_error,

1503: THEN
1504: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1505: fnd_log.string
1506: (
1507: fnd_log.level_error,
1508: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1509: 'Departure Org id and code, both cannot be null '
1510: ||p_flight_visit_sch_tbl(i).unit_schedule_id
1511: );

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

1522: ( p_flight_visit_sch_tbl(i).ARRIVAL_DEPT_CODE IS NULL OR
1523: p_flight_visit_sch_tbl(i).ARRIVAL_DEPT_CODE = FND_API.G_MISS_CHAR )
1524:
1525: THEN
1526: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1527: fnd_log.string
1528: (
1529: fnd_log.level_error,
1530: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',

Line 1527: fnd_log.string

1523: p_flight_visit_sch_tbl(i).ARRIVAL_DEPT_CODE = FND_API.G_MISS_CHAR )
1524:
1525: THEN
1526: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1527: fnd_log.string
1528: (
1529: fnd_log.level_error,
1530: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1531: 'Arrival dept id and code, both cannot be null '

Line 1529: fnd_log.level_error,

1525: THEN
1526: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1527: fnd_log.string
1528: (
1529: fnd_log.level_error,
1530: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1531: 'Arrival dept id and code, both cannot be null '
1532: ||p_flight_visit_sch_tbl(i).unit_schedule_id
1533: );

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

1543: p_flight_visit_sch_tbl(i).ARRIVAL_ORG_ID = FND_API.G_MISS_NUM ) AND
1544: ( p_flight_visit_sch_tbl(i).ARRIVAL_ORG_CODE IS NULL OR
1545: p_flight_visit_sch_tbl(i).ARRIVAL_ORG_CODE = FND_API.G_MISS_CHAR )
1546: THEN
1547: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1548: fnd_log.string
1549: (
1550: fnd_log.level_error,
1551: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',

Line 1548: fnd_log.string

1544: ( p_flight_visit_sch_tbl(i).ARRIVAL_ORG_CODE IS NULL OR
1545: p_flight_visit_sch_tbl(i).ARRIVAL_ORG_CODE = FND_API.G_MISS_CHAR )
1546: THEN
1547: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1548: fnd_log.string
1549: (
1550: fnd_log.level_error,
1551: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1552: 'Arrival org id and code, both cannot be null '

Line 1550: fnd_log.level_error,

1546: THEN
1547: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1548: fnd_log.string
1549: (
1550: fnd_log.level_error,
1551: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1552: 'Arrival org id and code, both cannot be null '
1553: ||p_flight_visit_sch_tbl(i).unit_schedule_id
1554: );

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

1562: --Est_Departure_Time is a mandatory input field and cannot be null
1563: IF p_flight_visit_sch_tbl(i).EST_DEPARTURE_TIME IS NULL OR
1564: p_flight_visit_sch_tbl(i).EST_DEPARTURE_TIME = FND_API.G_MISS_DATE
1565: THEN
1566: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1567: fnd_log.string
1568: (
1569: fnd_log.level_error,
1570: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',

Line 1567: fnd_log.string

1563: IF p_flight_visit_sch_tbl(i).EST_DEPARTURE_TIME IS NULL OR
1564: p_flight_visit_sch_tbl(i).EST_DEPARTURE_TIME = FND_API.G_MISS_DATE
1565: THEN
1566: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1567: fnd_log.string
1568: (
1569: fnd_log.level_error,
1570: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1571: 'estimated departure time cannot be null '

Line 1569: fnd_log.level_error,

1565: THEN
1566: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1567: fnd_log.string
1568: (
1569: fnd_log.level_error,
1570: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1571: 'estimated departure time cannot be null '
1572: ||p_flight_visit_sch_tbl(i).unit_schedule_id
1573: );

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

1581: --Est_Arrival_Time is a mandatory input field and cannot be null
1582: IF p_flight_visit_sch_tbl(i).EST_ARRIVAL_TIME IS NULL OR
1583: p_flight_visit_sch_tbl(i).EST_ARRIVAL_TIME = FND_API.G_MISS_DATE
1584: THEN
1585: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1586: fnd_log.string
1587: (
1588: fnd_log.level_error,
1589: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',

Line 1586: fnd_log.string

1582: IF p_flight_visit_sch_tbl(i).EST_ARRIVAL_TIME IS NULL OR
1583: p_flight_visit_sch_tbl(i).EST_ARRIVAL_TIME = FND_API.G_MISS_DATE
1584: THEN
1585: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1586: fnd_log.string
1587: (
1588: fnd_log.level_error,
1589: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1590: 'Estimated arrival cannot be null '

Line 1588: fnd_log.level_error,

1584: THEN
1585: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1586: fnd_log.string
1587: (
1588: fnd_log.level_error,
1589: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1590: 'Estimated arrival cannot be null '
1591: ||p_flight_visit_sch_tbl(i).unit_schedule_id
1592: );

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

1602: p_flight_visit_sch_tbl(i).VISIT_RESCHEDULE_MODE = FND_API.G_MISS_CHAR ) AND
1603: ( p_flight_visit_sch_tbl(i).VISIT_RESCHEDULE_MEANING IS NULL OR
1604: p_flight_visit_sch_tbl(i).VISIT_RESCHEDULE_MEANING = FND_API.G_MISS_CHAR )
1605: THEN
1606: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1607: fnd_log.string
1608: (
1609: fnd_log.level_error,
1610: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',

Line 1607: fnd_log.string

1603: ( p_flight_visit_sch_tbl(i).VISIT_RESCHEDULE_MEANING IS NULL OR
1604: p_flight_visit_sch_tbl(i).VISIT_RESCHEDULE_MEANING = FND_API.G_MISS_CHAR )
1605: THEN
1606: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1607: fnd_log.string
1608: (
1609: fnd_log.level_error,
1610: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1611: 'Visit Reschedule mode cannot be null for '

Line 1609: fnd_log.level_error,

1605: THEN
1606: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1607: fnd_log.string
1608: (
1609: fnd_log.level_error,
1610: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1611: 'Visit Reschedule mode cannot be null for '
1612: ||p_flight_visit_sch_tbl(i).unit_schedule_id
1613: );

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

1627: p_flight_visit_sch_tbl(i).VISIT_TYPE_CODE = FND_API.G_MISS_CHAR ) AND
1628: ( p_flight_visit_sch_tbl(i).VISIT_TYPE_MEANING IS NULL OR
1629: p_flight_visit_sch_tbl(i).VISIT_TYPE_MEANING = FND_API.G_MISS_CHAR )
1630: THEN
1631: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1632: fnd_log.string
1633: (
1634: fnd_log.level_error,
1635: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',

Line 1632: fnd_log.string

1628: ( p_flight_visit_sch_tbl(i).VISIT_TYPE_MEANING IS NULL OR
1629: p_flight_visit_sch_tbl(i).VISIT_TYPE_MEANING = FND_API.G_MISS_CHAR )
1630: THEN
1631: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1632: fnd_log.string
1633: (
1634: fnd_log.level_error,
1635: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1636: 'Visit Type Code cannot be null for '

Line 1634: fnd_log.level_error,

1630: THEN
1631: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1632: fnd_log.string
1633: (
1634: fnd_log.level_error,
1635: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1636: 'Visit Type Code cannot be null for '
1637: ||p_flight_visit_sch_tbl(i).unit_schedule_id
1638: );

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

1648: p_flight_visit_sch_tbl(i).VISIT_CREATE_TYPE = FND_API.G_MISS_CHAR ) AND
1649: ( p_flight_visit_sch_tbl(i).VISIT_CREATE_MEANING IS NULL OR
1650: p_flight_visit_sch_tbl(i).VISIT_CREATE_MEANING = FND_API.G_MISS_CHAR )
1651: THEN
1652: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1653: fnd_log.string
1654: (
1655: fnd_log.level_error,
1656: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',

Line 1653: fnd_log.string

1649: ( p_flight_visit_sch_tbl(i).VISIT_CREATE_MEANING IS NULL OR
1650: p_flight_visit_sch_tbl(i).VISIT_CREATE_MEANING = FND_API.G_MISS_CHAR )
1651: THEN
1652: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1653: fnd_log.string
1654: (
1655: fnd_log.level_error,
1656: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1657: 'Visit create type code cannot be null for '

Line 1655: fnd_log.level_error,

1651: THEN
1652: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1653: fnd_log.string
1654: (
1655: fnd_log.level_error,
1656: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1657: 'Visit create type code cannot be null for '
1658: ||p_flight_visit_sch_tbl(i).unit_schedule_id
1659: );

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

1694: IS
1695: l_api_name CONSTANT VARCHAR2(30) := 'Process_FlightVisit_Sch';
1696: l_api_version CONSTANT NUMBER := 1.0;
1697: BEGIN
1698: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
1699: fnd_log.string
1700: (
1701: fnd_log.level_procedure,
1702: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||'.begin',

Line 1699: fnd_log.string

1695: l_api_name CONSTANT VARCHAR2(30) := 'Process_FlightVisit_Sch';
1696: l_api_version CONSTANT NUMBER := 1.0;
1697: BEGIN
1698: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
1699: fnd_log.string
1700: (
1701: fnd_log.level_procedure,
1702: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||'.begin',
1703: 'At the start of PLSQL procedure Process_FlightVisit_Sch'

Line 1701: fnd_log.level_procedure,

1697: BEGIN
1698: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
1699: fnd_log.string
1700: (
1701: fnd_log.level_procedure,
1702: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||'.begin',
1703: 'At the start of PLSQL procedure Process_FlightVisit_Sch'
1704: );
1705: END IF;

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

1722: FND_MSG_PUB.initialize;
1723: END IF;
1724:
1725:
1726: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1727: fnd_log.string
1728: (
1729: fnd_log.level_statement,
1730: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',

Line 1727: fnd_log.string

1723: END IF;
1724:
1725:
1726: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1727: fnd_log.string
1728: (
1729: fnd_log.level_statement,
1730: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1731: 'Before calling the private API.....'

Line 1729: fnd_log.level_statement,

1725:
1726: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1727: fnd_log.string
1728: (
1729: fnd_log.level_statement,
1730: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1731: 'Before calling the private API.....'
1732: );
1733: END IF;

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

1739: );
1740:
1741: -- If any severe error occurs, then, abort API.
1742: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1743: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1744: fnd_log.string
1745: (
1746: fnd_log.level_error,
1747: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',

Line 1744: fnd_log.string

1740:
1741: -- If any severe error occurs, then, abort API.
1742: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1743: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1744: fnd_log.string
1745: (
1746: fnd_log.level_error,
1747: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1748: 'validate_api_inputs API raised expected error....'

Line 1746: fnd_log.level_error,

1742: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1743: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1744: fnd_log.string
1745: (
1746: fnd_log.level_error,
1747: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1748: 'validate_api_inputs API raised expected error....'
1749: );
1750: END IF;

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

1749: );
1750: END IF;
1751: RAISE FND_API.G_EXC_ERROR;
1752: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1753: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1754: fnd_log.string
1755: (
1756: fnd_log.level_error,
1757: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',

Line 1754: fnd_log.string

1750: END IF;
1751: RAISE FND_API.G_EXC_ERROR;
1752: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1753: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1754: fnd_log.string
1755: (
1756: fnd_log.level_error,
1757: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1758: 'validate_api_inputs API raised unexpected error....'

Line 1756: fnd_log.level_error,

1752: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1753: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1754: fnd_log.string
1755: (
1756: fnd_log.level_error,
1757: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1758: 'validate_api_inputs API raised unexpected error....'
1759: );
1760: END IF;

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

1785: THEN
1786: COMMIT;
1787: END IF;
1788:
1789: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
1790: fnd_log.string
1791: (
1792: fnd_log.level_procedure,
1793: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||'.begin',

Line 1790: fnd_log.string

1786: COMMIT;
1787: END IF;
1788:
1789: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
1790: fnd_log.string
1791: (
1792: fnd_log.level_procedure,
1793: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||'.begin',
1794: 'At the end of PLSQL procedure Process_FlightVisit_Sch'

Line 1792: fnd_log.level_procedure,

1788:
1789: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
1790: fnd_log.string
1791: (
1792: fnd_log.level_procedure,
1793: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||'.begin',
1794: 'At the end of PLSQL procedure Process_FlightVisit_Sch'
1795: );
1796: END IF;