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

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

55: IF FND_API.to_boolean( p_init_msg_list ) THEN
56: FND_MSG_PUB.initialize;
57: END IF;
58:
59: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
60: fnd_log.string
61: (
62: fnd_log.level_procedure,
63: l_debug_module ||'.begin',

Line 60: fnd_log.string

56: FND_MSG_PUB.initialize;
57: END IF;
58:
59: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
60: fnd_log.string
61: (
62: fnd_log.level_procedure,
63: l_debug_module ||'.begin',
64: 'At the start of PLSQL procedure'

Line 62: fnd_log.level_procedure,

58:
59: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
60: fnd_log.string
61: (
62: fnd_log.level_procedure,
63: l_debug_module ||'.begin',
64: 'At the start of PLSQL procedure'
65: );
66: END IF;

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

64: 'At the start of PLSQL procedure'
65: );
66: END IF;
67:
68: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
69:
70: fnd_log.string
71: (
72: fnd_log.level_statement,

Line 70: fnd_log.string

66: END IF;
67:
68: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
69:
70: fnd_log.string
71: (
72: fnd_log.level_statement,
73: l_debug_module ,
74: 'Before calling the private API AHL_RM_ROUTE_PVT.process_route.....'

Line 72: fnd_log.level_statement,

68: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
69:
70: fnd_log.string
71: (
72: fnd_log.level_statement,
73: l_debug_module ,
74: 'Before calling the private API AHL_RM_ROUTE_PVT.process_route.....'
75: );
76:

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

113: ElSE
114: -- If the DML operation is not Cretae then its invalid
115: FND_MESSAGE.SET_NAME('AHL','AHL_COM_INVALID_DML_FLAG');
116: FND_MSG_PUB.ADD;
117: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level) THEN
118: fnd_log.string
119: (
120: fnd_log.level_error,
121: l_debug_module ,

Line 118: fnd_log.string

114: -- If the DML operation is not Cretae then its invalid
115: FND_MESSAGE.SET_NAME('AHL','AHL_COM_INVALID_DML_FLAG');
116: FND_MSG_PUB.ADD;
117: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level) THEN
118: fnd_log.string
119: (
120: fnd_log.level_error,
121: l_debug_module ,
122: 'Invalid DML Operation is specified....DML Operation should be create'

Line 120: fnd_log.level_error,

116: FND_MSG_PUB.ADD;
117: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level) THEN
118: fnd_log.string
119: (
120: fnd_log.level_error,
121: l_debug_module ,
122: 'Invalid DML Operation is specified....DML Operation should be create'
123: );
124: END IF;

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

124: END IF;
125: RAISE FND_API.G_EXC_ERROR;
126: END IF;
127:
128: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
129:
130: fnd_log.string
131: (
132: fnd_log.level_statement,

Line 130: fnd_log.string

126: END IF;
127:
128: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
129:
130: fnd_log.string
131: (
132: fnd_log.level_statement,
133: l_debug_module ,
134: 'Route Id of the Route created .....' || p_x_route_rec.ROUTE_ID

Line 132: fnd_log.level_statement,

128: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
129:
130: fnd_log.string
131: (
132: fnd_log.level_statement,
133: l_debug_module ,
134: 'Route Id of the Route created .....' || p_x_route_rec.ROUTE_ID
135: );
136:

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

150: p_x_route_doc_tbl(i).DML_OPERATION := 'C';
151:
152: END LOOP;
153:
154: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
155:
156: fnd_log.string
157: (
158: fnd_log.level_statement,

Line 156: fnd_log.string

152: END LOOP;
153:
154: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
155:
156: fnd_log.string
157: (
158: fnd_log.level_statement,
159: l_debug_module ,
160: 'Before calling the private API AHL_RM_ASSO_DOCASO_PVT.PROCESS_ASSOCIATION.....'

Line 158: fnd_log.level_statement,

154: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
155:
156: fnd_log.string
157: (
158: fnd_log.level_statement,
159: l_debug_module ,
160: 'Before calling the private API AHL_RM_ASSO_DOCASO_PVT.PROCESS_ASSOCIATION.....'
161: );
162:

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

367: END IF;
368:
369: END IF;
370:
371: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
372: fnd_log.string
373: (
374: fnd_log.level_procedure,
375: l_debug_module ||'.End',

Line 372: fnd_log.string

368:
369: END IF;
370:
371: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
372: fnd_log.string
373: (
374: fnd_log.level_procedure,
375: l_debug_module ||'.End',
376: 'At the end of PLSQL procedure...'

Line 374: fnd_log.level_procedure,

370:
371: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
372: fnd_log.string
373: (
374: fnd_log.level_procedure,
375: l_debug_module ||'.End',
376: 'At the end of PLSQL procedure...'
377: );
378: END IF;

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

378: END IF;
379:
380: -- Check Error Message stack.
381: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
382: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level) THEN
383: fnd_log.string
384: (
385: fnd_log.level_error,
386: l_debug_module ,

Line 383: fnd_log.string

379:
380: -- Check Error Message stack.
381: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
382: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level) THEN
383: fnd_log.string
384: (
385: fnd_log.level_error,
386: l_debug_module ,
387: 'Private API raised expected error....'

Line 385: fnd_log.level_error,

381: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
382: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level) THEN
383: fnd_log.string
384: (
385: fnd_log.level_error,
386: l_debug_module ,
387: 'Private API raised expected error....'
388: );
389: END IF;

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

388: );
389: END IF;
390: RAISE FND_API.G_EXC_ERROR;
391: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
392: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
393: fnd_log.string
394: (
395: fnd_log.level_error,
396: l_debug_module ,

Line 393: fnd_log.string

389: END IF;
390: RAISE FND_API.G_EXC_ERROR;
391: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
392: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
393: fnd_log.string
394: (
395: fnd_log.level_error,
396: l_debug_module ,
397: 'Private API raised unexpected error....'

Line 395: fnd_log.level_error,

391: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
392: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
393: fnd_log.string
394: (
395: fnd_log.level_error,
396: l_debug_module ,
397: 'Private API raised unexpected error....'
398: );
399: END IF;

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

493: FND_MSG_PUB.initialize;
494: END IF;
495:
496:
497: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
498: fnd_log.string
499: (
500: fnd_log.level_procedure,
501: l_debug_module ||'.begin',

Line 498: fnd_log.string

494: END IF;
495:
496:
497: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
498: fnd_log.string
499: (
500: fnd_log.level_procedure,
501: l_debug_module ||'.begin',
502: 'At the start of PLSQL procedure'

Line 500: fnd_log.level_procedure,

496:
497: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
498: fnd_log.string
499: (
500: fnd_log.level_procedure,
501: l_debug_module ||'.begin',
502: 'At the start of PLSQL procedure'
503: );
504: END IF;

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

502: 'At the start of PLSQL procedure'
503: );
504: END IF;
505:
506: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
507:
508: fnd_log.string
509: (
510: fnd_log.level_statement,

Line 508: fnd_log.string

504: END IF;
505:
506: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
507:
508: fnd_log.string
509: (
510: fnd_log.level_statement,
511: l_debug_module ,
512: 'Before calling the private API AHL_RM_ROUTE_PVT.process_route.....'

Line 510: fnd_log.level_statement,

506: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
507:
508: fnd_log.string
509: (
510: fnd_log.level_statement,
511: l_debug_module ,
512: 'Before calling the private API AHL_RM_ROUTE_PVT.process_route.....'
513: );
514:

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

526: x_route_id => l_route_id ,
527: x_return_status => x_return_status
528: );
529: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
530: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
531: fnd_log.string
532: (
533: fnd_log.level_error,
534: l_debug_module ,

Line 531: fnd_log.string

527: x_return_status => x_return_status
528: );
529: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
530: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
531: fnd_log.string
532: (
533: fnd_log.level_error,
534: l_debug_module ,
535: 'Error in AHL_RM_ROUTE_UTIL.Route_Number_To_Id API'

Line 533: fnd_log.level_error,

529: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
530: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
531: fnd_log.string
532: (
533: fnd_log.level_error,
534: l_debug_module ,
535: 'Error in AHL_RM_ROUTE_UTIL.Route_Number_To_Id API'
536: );
537: END IF;

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

539: END IF;
540:
541: END IF;
542:
543: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
544:
545: fnd_log.string
546: (
547: fnd_log.level_statement,

Line 545: fnd_log.string

541: END IF;
542:
543: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
544:
545: fnd_log.string
546: (
547: fnd_log.level_statement,
548: l_debug_module ,
549: 'Route Id of the Route that is being updated .....' || l_route_id

Line 547: fnd_log.level_statement,

543: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
544:
545: fnd_log.string
546: (
547: fnd_log.level_statement,
548: l_debug_module ,
549: 'Route Id of the Route that is being updated .....' || l_route_id
550: );
551:

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

580: ElSIF p_route_rec.DML_OPERATION IS NOT NULL THEN
581: -- If the DML operation is not 'U' and is also not NULL, then throw an error
582: FND_MESSAGE.SET_NAME('AHL','AHL_COM_INVALID_DML_FLAG');
583: FND_MSG_PUB.ADD;
584: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level) THEN
585: fnd_log.string
586: (
587: fnd_log.level_error,
588: l_debug_module ,

Line 585: fnd_log.string

581: -- If the DML operation is not 'U' and is also not NULL, then throw an error
582: FND_MESSAGE.SET_NAME('AHL','AHL_COM_INVALID_DML_FLAG');
583: FND_MSG_PUB.ADD;
584: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level) THEN
585: fnd_log.string
586: (
587: fnd_log.level_error,
588: l_debug_module ,
589: 'Invalid DML Operation is specified....DML Operation should be Update'

Line 587: fnd_log.level_error,

583: FND_MSG_PUB.ADD;
584: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level) THEN
585: fnd_log.string
586: (
587: fnd_log.level_error,
588: l_debug_module ,
589: 'Invalid DML Operation is specified....DML Operation should be Update'
590: );
591: END IF;

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

607: p_x_route_doc_tbl(i).OBJECT_ID := l_route_id;
608:
609: END LOOP;
610:
611: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
612:
613: fnd_log.string
614: (
615: fnd_log.level_statement,

Line 613: fnd_log.string

609: END LOOP;
610:
611: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
612:
613: fnd_log.string
614: (
615: fnd_log.level_statement,
616: l_debug_module ,
617: 'Before calling the private API AHL_RM_ASSO_DOCASO_PVT.PROCESS_ASSOCIATION.....'

Line 615: fnd_log.level_statement,

611: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
612:
613: fnd_log.string
614: (
615: fnd_log.level_statement,
616: l_debug_module ,
617: 'Before calling the private API AHL_RM_ASSO_DOCASO_PVT.PROCESS_ASSOCIATION.....'
618: );
619:

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

801: END IF;
802:
803: END IF;
804:
805: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
806: fnd_log.string
807: (
808: fnd_log.level_procedure,
809: l_debug_module ||'.End',

Line 806: fnd_log.string

802:
803: END IF;
804:
805: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
806: fnd_log.string
807: (
808: fnd_log.level_procedure,
809: l_debug_module ||'.End',
810: 'At the end of PLSQL procedure...'

Line 808: fnd_log.level_procedure,

804:
805: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
806: fnd_log.string
807: (
808: fnd_log.level_procedure,
809: l_debug_module ||'.End',
810: 'At the end of PLSQL procedure...'
811: );
812: END IF;

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

812: END IF;
813:
814: -- Check Error Message stack.
815: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
816: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level) THEN
817: fnd_log.string
818: (
819: fnd_log.level_error,
820: l_debug_module ,

Line 817: fnd_log.string

813:
814: -- Check Error Message stack.
815: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
816: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level) THEN
817: fnd_log.string
818: (
819: fnd_log.level_error,
820: l_debug_module ,
821: 'Private API raised expected error....'

Line 819: fnd_log.level_error,

815: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
816: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level) THEN
817: fnd_log.string
818: (
819: fnd_log.level_error,
820: l_debug_module ,
821: 'Private API raised expected error....'
822: );
823: END IF;

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

822: );
823: END IF;
824: RAISE FND_API.G_EXC_ERROR;
825: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
826: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
827: fnd_log.string
828: (
829: fnd_log.level_error,
830: l_debug_module ,

Line 827: fnd_log.string

823: END IF;
824: RAISE FND_API.G_EXC_ERROR;
825: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
826: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
827: fnd_log.string
828: (
829: fnd_log.level_error,
830: l_debug_module ,
831: 'Private API raised unexpected error....'

Line 829: fnd_log.level_error,

825: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
826: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
827: fnd_log.string
828: (
829: fnd_log.level_error,
830: l_debug_module ,
831: 'Private API raised unexpected error....'
832: );
833: END IF;

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

920: IF FND_API.to_boolean( p_init_msg_list ) THEN
921: FND_MSG_PUB.initialize;
922: END IF;
923:
924: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
925: fnd_log.string
926: (
927: fnd_log.level_procedure,
928: l_debug_module ||'.begin',

Line 925: fnd_log.string

921: FND_MSG_PUB.initialize;
922: END IF;
923:
924: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
925: fnd_log.string
926: (
927: fnd_log.level_procedure,
928: l_debug_module ||'.begin',
929: 'At the start of PLSQL procedure'

Line 927: fnd_log.level_procedure,

923:
924: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
925: fnd_log.string
926: (
927: fnd_log.level_procedure,
928: l_debug_module ||'.begin',
929: 'At the start of PLSQL procedure'
930: );
931: END IF;

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

929: 'At the start of PLSQL procedure'
930: );
931: END IF;
932:
933: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
934:
935: fnd_log.string
936: (
937: fnd_log.level_statement,

Line 935: fnd_log.string

931: END IF;
932:
933: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
934:
935: fnd_log.string
936: (
937: fnd_log.level_statement,
938: l_debug_module ,
939: 'Before calling the private API AHL_RM_ROUTE_PVT.delete_route.....'

Line 937: fnd_log.level_statement,

933: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
934:
935: fnd_log.string
936: (
937: fnd_log.level_statement,
938: l_debug_module ,
939: 'Before calling the private API AHL_RM_ROUTE_PVT.delete_route.....'
940: );
941:

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

952: x_route_id => l_route_id,
953: x_return_status => x_return_status
954: );
955: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
956: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
957: fnd_log.string
958: (
959: fnd_log.level_error,
960: l_debug_module ,

Line 957: fnd_log.string

953: x_return_status => x_return_status
954: );
955: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
956: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
957: fnd_log.string
958: (
959: fnd_log.level_error,
960: l_debug_module ,
961: 'Error in AHL_RM_ROUTE_UTIL.Route_Number_To_Id API'

Line 959: fnd_log.level_error,

955: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
956: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
957: fnd_log.string
958: (
959: fnd_log.level_error,
960: l_debug_module ,
961: 'Error in AHL_RM_ROUTE_UTIL.Route_Number_To_Id API'
962: );
963: END IF;

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

965: END IF;
966:
967: END IF;
968:
969: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
970:
971: fnd_log.string
972: (
973: fnd_log.level_statement,

Line 971: fnd_log.string

967: END IF;
968:
969: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
970:
971: fnd_log.string
972: (
973: fnd_log.level_statement,
974: l_debug_module ,
975: 'Route Id of the Route that is being deleted .....' || l_route_id

Line 973: fnd_log.level_statement,

969: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
970:
971: fnd_log.string
972: (
973: fnd_log.level_statement,
974: l_debug_module ,
975: 'Route Id of the Route that is being deleted .....' || l_route_id
976: );
977:

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

1000: RAISE FND_API.G_EXC_ERROR;
1001: END IF;
1002:
1003:
1004: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1005: fnd_log.string
1006: (
1007: fnd_log.level_procedure,
1008: l_debug_module ||'.End',

Line 1005: fnd_log.string

1001: END IF;
1002:
1003:
1004: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1005: fnd_log.string
1006: (
1007: fnd_log.level_procedure,
1008: l_debug_module ||'.End',
1009: 'At the end of PLSQL procedure...'

Line 1007: fnd_log.level_procedure,

1003:
1004: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1005: fnd_log.string
1006: (
1007: fnd_log.level_procedure,
1008: l_debug_module ||'.End',
1009: 'At the end of PLSQL procedure...'
1010: );
1011: END IF;

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

1011: END IF;
1012:
1013: -- Check Error Message stack.
1014: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1015: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level) THEN
1016: fnd_log.string
1017: (
1018: fnd_log.level_error,
1019: l_debug_module ,

Line 1016: fnd_log.string

1012:
1013: -- Check Error Message stack.
1014: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1015: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level) THEN
1016: fnd_log.string
1017: (
1018: fnd_log.level_error,
1019: l_debug_module ,
1020: 'Private API raised expected error....'

Line 1018: fnd_log.level_error,

1014: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1015: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level) THEN
1016: fnd_log.string
1017: (
1018: fnd_log.level_error,
1019: l_debug_module ,
1020: 'Private API raised expected error....'
1021: );
1022: END IF;

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

1021: );
1022: END IF;
1023: RAISE FND_API.G_EXC_ERROR;
1024: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1025: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1026: fnd_log.string
1027: (
1028: fnd_log.level_error,
1029: l_debug_module ,

Line 1026: fnd_log.string

1022: END IF;
1023: RAISE FND_API.G_EXC_ERROR;
1024: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1025: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1026: fnd_log.string
1027: (
1028: fnd_log.level_error,
1029: l_debug_module ,
1030: 'Private API raised unexpected error....'

Line 1028: fnd_log.level_error,

1024: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1025: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1026: fnd_log.string
1027: (
1028: fnd_log.level_error,
1029: l_debug_module ,
1030: 'Private API raised unexpected error....'
1031: );
1032: END IF;

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

1123: FND_MSG_PUB.initialize;
1124: END IF;
1125:
1126:
1127: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
1128: fnd_log.string
1129: (
1130: fnd_log.level_procedure,
1131: l_debug_module ||'.begin',

Line 1128: fnd_log.string

1124: END IF;
1125:
1126:
1127: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
1128: fnd_log.string
1129: (
1130: fnd_log.level_procedure,
1131: l_debug_module ||'.begin',
1132: 'At the start of PLSQL procedure'

Line 1130: fnd_log.level_procedure,

1126:
1127: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
1128: fnd_log.string
1129: (
1130: fnd_log.level_procedure,
1131: l_debug_module ||'.begin',
1132: 'At the start of PLSQL procedure'
1133: );
1134: END IF;

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

1148: x_route_id => l_route_id,
1149: x_return_status => x_return_status
1150: );
1151: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1152: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1153: fnd_log.string
1154: (
1155: fnd_log.level_error,
1156: l_debug_module ,

Line 1153: fnd_log.string

1149: x_return_status => x_return_status
1150: );
1151: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1152: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1153: fnd_log.string
1154: (
1155: fnd_log.level_error,
1156: l_debug_module ,
1157: 'Error in converting Object Number, Object Revision to ID'

Line 1155: fnd_log.level_error,

1151: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1152: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1153: fnd_log.string
1154: (
1155: fnd_log.level_error,
1156: l_debug_module ,
1157: 'Error in converting Object Number, Object Revision to ID'
1158: );
1159: END IF;

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

1161: END IF;
1162: END IF;
1163:
1164:
1165: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1166: fnd_log.string
1167: (
1168: fnd_log.level_statement,
1169: l_debug_module ,

Line 1166: fnd_log.string

1162: END IF;
1163:
1164:
1165: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1166: fnd_log.string
1167: (
1168: fnd_log.level_statement,
1169: l_debug_module ,
1170: 'Before calling the private API.....'

Line 1168: fnd_log.level_statement,

1164:
1165: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1166: fnd_log.string
1167: (
1168: fnd_log.level_statement,
1169: l_debug_module ,
1170: 'Before calling the private API.....'
1171: );
1172: END IF;

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

1194: IF l_x_route_efct_tbl(1).ROUTE_EFFECTIVITY_ID IS NULL
1195: THEN
1196: FND_MESSAGE.set_Name('AHL','AHL_RM_PUB_EFFEC_ID_NULL');
1197: FND_MSG_PUB.add;
1198: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1199: fnd_log.string
1200: (
1201: fnd_log.level_error,
1202: l_debug_module ,

Line 1199: fnd_log.string

1195: THEN
1196: FND_MESSAGE.set_Name('AHL','AHL_RM_PUB_EFFEC_ID_NULL');
1197: FND_MSG_PUB.add;
1198: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1199: fnd_log.string
1200: (
1201: fnd_log.level_error,
1202: l_debug_module ,
1203: 'Error Effectivity id is null'

Line 1201: fnd_log.level_error,

1197: FND_MSG_PUB.add;
1198: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1199: fnd_log.string
1200: (
1201: fnd_log.level_error,
1202: l_debug_module ,
1203: 'Error Effectivity id is null'
1204: );
1205: END IF;

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

1223: p_object_id => l_x_route_efct_tbl(1).ROUTE_EFFECTIVITY_ID, -- this is the object id for association type DISPOSITION
1224: p_association_type => 'DISPOSITION'
1225: );
1226:
1227: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1228: fnd_log.string
1229: (
1230: fnd_log.level_procedure,
1231: l_debug_module ||'.End',

Line 1228: fnd_log.string

1224: p_association_type => 'DISPOSITION'
1225: );
1226:
1227: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1228: fnd_log.string
1229: (
1230: fnd_log.level_procedure,
1231: l_debug_module ||'.End',
1232: 'At the end of PLSQL procedure...'

Line 1230: fnd_log.level_procedure,

1226:
1227: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1228: fnd_log.string
1229: (
1230: fnd_log.level_procedure,
1231: l_debug_module ||'.End',
1232: 'At the end of PLSQL procedure...'
1233: );
1234: END IF;

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

1234: END IF;
1235:
1236: -- Check Error Message stack.
1237: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1238: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level) THEN
1239: fnd_log.string
1240: (
1241: fnd_log.level_error,
1242: l_debug_module ,

Line 1239: fnd_log.string

1235:
1236: -- Check Error Message stack.
1237: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1238: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level) THEN
1239: fnd_log.string
1240: (
1241: fnd_log.level_error,
1242: l_debug_module ,
1243: 'Private API raised expected error....'

Line 1241: fnd_log.level_error,

1237: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1238: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level) THEN
1239: fnd_log.string
1240: (
1241: fnd_log.level_error,
1242: l_debug_module ,
1243: 'Private API raised expected error....'
1244: );
1245: END IF;

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

1244: );
1245: END IF;
1246: RAISE FND_API.G_EXC_ERROR;
1247: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1248: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1249: fnd_log.string
1250: (
1251: fnd_log.level_error,
1252: l_debug_module ,

Line 1249: fnd_log.string

1245: END IF;
1246: RAISE FND_API.G_EXC_ERROR;
1247: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1248: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1249: fnd_log.string
1250: (
1251: fnd_log.level_error,
1252: l_debug_module ,
1253: 'Private API raised unexpected error....'

Line 1251: fnd_log.level_error,

1247: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1248: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1249: fnd_log.string
1250: (
1251: fnd_log.level_error,
1252: l_debug_module ,
1253: 'Private API raised unexpected error....'
1254: );
1255: END IF;

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

1345: IF FND_API.to_boolean( p_init_msg_list ) THEN
1346: FND_MSG_PUB.initialize;
1347: END IF;
1348:
1349: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
1350: fnd_log.string
1351: (
1352: fnd_log.level_procedure,
1353: l_debug_module ||'.begin',

Line 1350: fnd_log.string

1346: FND_MSG_PUB.initialize;
1347: END IF;
1348:
1349: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
1350: fnd_log.string
1351: (
1352: fnd_log.level_procedure,
1353: l_debug_module ||'.begin',
1354: 'At the start of PLSQL procedure'

Line 1352: fnd_log.level_procedure,

1348:
1349: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
1350: fnd_log.string
1351: (
1352: fnd_log.level_procedure,
1353: l_debug_module ||'.begin',
1354: 'At the start of PLSQL procedure'
1355: );
1356: END IF;

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

1368: x_route_id => l_route_id,
1369: x_return_status => x_return_status
1370: );
1371: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1372: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1373: fnd_log.string
1374: (
1375: fnd_log.level_error,
1376: l_debug_module ,

Line 1373: fnd_log.string

1369: x_return_status => x_return_status
1370: );
1371: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1372: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1373: fnd_log.string
1374: (
1375: fnd_log.level_error,
1376: l_debug_module ,
1377: 'Error in AHL_RM_ROUTE_UTIL.Operation_Number_To_Id API'

Line 1375: fnd_log.level_error,

1371: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1372: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1373: fnd_log.string
1374: (
1375: fnd_log.level_error,
1376: l_debug_module ,
1377: 'Error in AHL_RM_ROUTE_UTIL.Operation_Number_To_Id API'
1378: );
1379: END IF;

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

1380: RAISE FND_API.G_EXC_ERROR;
1381: END IF;
1382: END IF;
1383:
1384: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1385: fnd_log.string
1386: (
1387: fnd_log.level_statement,
1388: l_debug_module ,

Line 1385: fnd_log.string

1381: END IF;
1382: END IF;
1383:
1384: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1385: fnd_log.string
1386: (
1387: fnd_log.level_statement,
1388: l_debug_module ,
1389: 'Before calling the private API .....'

Line 1387: fnd_log.level_statement,

1383:
1384: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1385: fnd_log.string
1386: (
1387: fnd_log.level_statement,
1388: l_debug_module ,
1389: 'Before calling the private API .....'
1390: );
1391: END IF;

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

1406: p_object_version_number => p_route_object_version,
1407: x_route_id => x_new_route_id
1408: );
1409:
1410: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
1411: fnd_log.string
1412: (
1413: fnd_log.level_procedure,
1414: l_debug_module ||'.End',

Line 1411: fnd_log.string

1407: x_route_id => x_new_route_id
1408: );
1409:
1410: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
1411: fnd_log.string
1412: (
1413: fnd_log.level_procedure,
1414: l_debug_module ||'.End',
1415: 'At the end of PLSQL procedure...'

Line 1413: fnd_log.level_procedure,

1409:
1410: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
1411: fnd_log.string
1412: (
1413: fnd_log.level_procedure,
1414: l_debug_module ||'.End',
1415: 'At the end of PLSQL procedure...'
1416: );
1417: END IF;

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

1417: END IF;
1418:
1419: -- Check Error Message stack.
1420: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1421: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1422: fnd_log.string
1423: (
1424: fnd_log.level_error,
1425: l_debug_module ,

Line 1422: fnd_log.string

1418:
1419: -- Check Error Message stack.
1420: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1421: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1422: fnd_log.string
1423: (
1424: fnd_log.level_error,
1425: l_debug_module ,
1426: 'Private API raised expected error....'

Line 1424: fnd_log.level_error,

1420: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1421: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1422: fnd_log.string
1423: (
1424: fnd_log.level_error,
1425: l_debug_module ,
1426: 'Private API raised expected error....'
1427: );
1428: END IF;

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

1427: );
1428: END IF;
1429: RAISE FND_API.G_EXC_ERROR;
1430: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1431: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1432: fnd_log.string
1433: (
1434: fnd_log.level_error,
1435: l_debug_module ,

Line 1432: fnd_log.string

1428: END IF;
1429: RAISE FND_API.G_EXC_ERROR;
1430: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1431: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1432: fnd_log.string
1433: (
1434: fnd_log.level_error,
1435: l_debug_module ,
1436: 'Private API raised unexpected error....'

Line 1434: fnd_log.level_error,

1430: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1431: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1432: fnd_log.string
1433: (
1434: fnd_log.level_error,
1435: l_debug_module ,
1436: 'Private API raised unexpected error....'
1437: );
1438: END IF;

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

1528: IF FND_API.to_boolean( p_init_msg_list ) THEN
1529: FND_MSG_PUB.initialize;
1530: END IF;
1531:
1532: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
1533: fnd_log.string
1534: (
1535: fnd_log.level_procedure,
1536: l_debug_module ||'.begin',

Line 1533: fnd_log.string

1529: FND_MSG_PUB.initialize;
1530: END IF;
1531:
1532: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
1533: fnd_log.string
1534: (
1535: fnd_log.level_procedure,
1536: l_debug_module ||'.begin',
1537: 'At the start of PLSQL procedure'

Line 1535: fnd_log.level_procedure,

1531:
1532: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
1533: fnd_log.string
1534: (
1535: fnd_log.level_procedure,
1536: l_debug_module ||'.begin',
1537: 'At the start of PLSQL procedure'
1538: );
1539: END IF;

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

1550: x_route_id => l_source_route_id,
1551: x_return_status => x_return_status
1552: );
1553: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1554: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1555: fnd_log.string
1556: (
1557: fnd_log.level_error,
1558: l_debug_module ,

Line 1555: fnd_log.string

1551: x_return_status => x_return_status
1552: );
1553: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1554: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1555: fnd_log.string
1556: (
1557: fnd_log.level_error,
1558: l_debug_module ,
1559: 'Error in AHL_RM_ROUTE_UTIL.Operation_Number_To_Id API'

Line 1557: fnd_log.level_error,

1553: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1554: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1555: fnd_log.string
1556: (
1557: fnd_log.level_error,
1558: l_debug_module ,
1559: 'Error in AHL_RM_ROUTE_UTIL.Operation_Number_To_Id API'
1560: );
1561: END IF;

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

1562: RAISE FND_API.G_EXC_ERROR;
1563: END IF;
1564: END IF;
1565:
1566: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1567: fnd_log.string
1568: (
1569: fnd_log.level_statement,
1570: l_debug_module ,

Line 1567: fnd_log.string

1563: END IF;
1564: END IF;
1565:
1566: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1567: fnd_log.string
1568: (
1569: fnd_log.level_statement,
1570: l_debug_module ,
1571: 'Before calling the private API.....'

Line 1569: fnd_log.level_statement,

1565:
1566: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1567: fnd_log.string
1568: (
1569: fnd_log.level_statement,
1570: l_debug_module ,
1571: 'Before calling the private API.....'
1572: );
1573: END IF;

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

1590: p_apprvl_type => p_apprv_type
1591: );
1592:
1593:
1594: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
1595: fnd_log.string
1596: (
1597: fnd_log.level_procedure,
1598: l_debug_module ||'.end',

Line 1595: fnd_log.string

1591: );
1592:
1593:
1594: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
1595: fnd_log.string
1596: (
1597: fnd_log.level_procedure,
1598: l_debug_module ||'.end',
1599: 'At the end of PLSQL procedure...'

Line 1597: fnd_log.level_procedure,

1593:
1594: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
1595: fnd_log.string
1596: (
1597: fnd_log.level_procedure,
1598: l_debug_module ||'.end',
1599: 'At the end of PLSQL procedure...'
1600: );
1601: END IF;

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

1601: END IF;
1602:
1603: -- Check Error Message stack.
1604: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1605: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1606: fnd_log.string
1607: (
1608: fnd_log.level_error,
1609: l_debug_module ,

Line 1606: fnd_log.string

1602:
1603: -- Check Error Message stack.
1604: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1605: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1606: fnd_log.string
1607: (
1608: fnd_log.level_error,
1609: l_debug_module ,
1610: 'Private API raised expected error....'

Line 1608: fnd_log.level_error,

1604: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1605: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1606: fnd_log.string
1607: (
1608: fnd_log.level_error,
1609: l_debug_module ,
1610: 'Private API raised expected error....'
1611: );
1612: END IF;

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

1611: );
1612: END IF;
1613: RAISE FND_API.G_EXC_ERROR;
1614: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1615: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1616: fnd_log.string
1617: (
1618: fnd_log.level_error,
1619: l_debug_module ,

Line 1616: fnd_log.string

1612: END IF;
1613: RAISE FND_API.G_EXC_ERROR;
1614: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1615: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1616: fnd_log.string
1617: (
1618: fnd_log.level_error,
1619: l_debug_module ,
1620: 'Private API raised unexpected error....'

Line 1618: fnd_log.level_error,

1614: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1615: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1616: fnd_log.string
1617: (
1618: fnd_log.level_error,
1619: l_debug_module ,
1620: 'Private API raised unexpected error....'
1621: );
1622: END IF;

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

1705: IF FND_API.to_boolean( p_init_msg_list ) THEN
1706: FND_MSG_PUB.initialize;
1707: END IF;
1708:
1709: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
1710: fnd_log.string
1711: (
1712: fnd_log.level_procedure,
1713: l_debug_module ||'.begin',

Line 1710: fnd_log.string

1706: FND_MSG_PUB.initialize;
1707: END IF;
1708:
1709: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
1710: fnd_log.string
1711: (
1712: fnd_log.level_procedure,
1713: l_debug_module ||'.begin',
1714: 'At the start of PLSQL procedure'

Line 1712: fnd_log.level_procedure,

1708:
1709: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
1710: fnd_log.string
1711: (
1712: fnd_log.level_procedure,
1713: l_debug_module ||'.begin',
1714: 'At the start of PLSQL procedure'
1715: );
1716: END IF;

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

1728: x_route_id => l_route_id,
1729: x_return_status => x_return_status
1730: );
1731: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1732: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1733: fnd_log.string
1734: (
1735: fnd_log.level_error,
1736: l_debug_module ,

Line 1733: fnd_log.string

1729: x_return_status => x_return_status
1730: );
1731: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1732: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1733: fnd_log.string
1734: (
1735: fnd_log.level_error,
1736: l_debug_module ,
1737: 'Error in AHL_RM_ROUTE_UTIL.Operation_Number_To_Id API'

Line 1735: fnd_log.level_error,

1731: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1732: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1733: fnd_log.string
1734: (
1735: fnd_log.level_error,
1736: l_debug_module ,
1737: 'Error in AHL_RM_ROUTE_UTIL.Operation_Number_To_Id API'
1738: );
1739: END IF;

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

1740: RAISE FND_API.G_EXC_ERROR;
1741: END IF;
1742: END IF;
1743:
1744: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1745: fnd_log.string
1746: (
1747: fnd_log.level_statement,
1748: l_debug_module ,

Line 1745: fnd_log.string

1741: END IF;
1742: END IF;
1743:
1744: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1745: fnd_log.string
1746: (
1747: fnd_log.level_statement,
1748: l_debug_module ,
1749: 'Before calling the private API.....'

Line 1747: fnd_log.level_statement,

1743:
1744: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1745: fnd_log.string
1746: (
1747: fnd_log.level_statement,
1748: l_debug_module ,
1749: 'Before calling the private API.....'
1750: );
1751: END IF;

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

1765: p_x_route_operation_tbl => p_x_route_operation_tbl,
1766: p_route_id => l_route_id
1767: );
1768:
1769: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
1770: fnd_log.string
1771: (
1772: fnd_log.level_procedure,
1773: l_debug_module ||'.End',

Line 1770: fnd_log.string

1766: p_route_id => l_route_id
1767: );
1768:
1769: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
1770: fnd_log.string
1771: (
1772: fnd_log.level_procedure,
1773: l_debug_module ||'.End',
1774: 'At the end of PLSQL procedure...'

Line 1772: fnd_log.level_procedure,

1768:
1769: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
1770: fnd_log.string
1771: (
1772: fnd_log.level_procedure,
1773: l_debug_module ||'.End',
1774: 'At the end of PLSQL procedure...'
1775: );
1776: END IF;

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

1776: END IF;
1777:
1778: -- Check Error Message stack.
1779: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1780: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1781: fnd_log.string
1782: (
1783: fnd_log.level_error,
1784: l_debug_module ,

Line 1781: fnd_log.string

1777:
1778: -- Check Error Message stack.
1779: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1780: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1781: fnd_log.string
1782: (
1783: fnd_log.level_error,
1784: l_debug_module ,
1785: 'Private API raised expected error....'

Line 1783: fnd_log.level_error,

1779: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1780: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1781: fnd_log.string
1782: (
1783: fnd_log.level_error,
1784: l_debug_module ,
1785: 'Private API raised expected error....'
1786: );
1787: END IF;

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

1786: );
1787: END IF;
1788: RAISE FND_API.G_EXC_ERROR;
1789: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1790: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1791: fnd_log.string
1792: (
1793: fnd_log.level_error,
1794: l_debug_module ,

Line 1791: fnd_log.string

1787: END IF;
1788: RAISE FND_API.G_EXC_ERROR;
1789: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1790: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1791: fnd_log.string
1792: (
1793: fnd_log.level_error,
1794: l_debug_module ,
1795: 'Private API raised unexpected error....'

Line 1793: fnd_log.level_error,

1789: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1790: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1791: fnd_log.string
1792: (
1793: fnd_log.level_error,
1794: l_debug_module ,
1795: 'Private API raised unexpected error....'
1796: );
1797: END IF;

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

1914: IF FND_API.to_boolean( p_init_msg_list ) THEN
1915: FND_MSG_PUB.initialize;
1916: END IF;
1917:
1918: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
1919: fnd_log.string
1920: (
1921: fnd_log.level_procedure,
1922: l_debug_module ||'.begin',

Line 1919: fnd_log.string

1915: FND_MSG_PUB.initialize;
1916: END IF;
1917:
1918: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
1919: fnd_log.string
1920: (
1921: fnd_log.level_procedure,
1922: l_debug_module ||'.begin',
1923: 'At the start of PLSQL procedure'

Line 1921: fnd_log.level_procedure,

1917:
1918: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
1919: fnd_log.string
1920: (
1921: fnd_log.level_procedure,
1922: l_debug_module ||'.begin',
1923: 'At the start of PLSQL procedure'
1924: );
1925: END IF;

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

1937: x_return_status => x_return_status
1938: );
1939:
1940: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1941: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1942: fnd_log.string
1943: (
1944: fnd_log.level_error,
1945: l_debug_module ||':',

Line 1942: fnd_log.string

1938: );
1939:
1940: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1941: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1942: fnd_log.string
1943: (
1944: fnd_log.level_error,
1945: l_debug_module ||':',
1946: 'Error in AHL_RM_ROUTE_UTIL.Route_Number_To_Id API'

Line 1944: fnd_log.level_error,

1940: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1941: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1942: fnd_log.string
1943: (
1944: fnd_log.level_error,
1945: l_debug_module ||':',
1946: 'Error in AHL_RM_ROUTE_UTIL.Route_Number_To_Id API'
1947: );
1948: END IF;

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

1949: RAISE FND_API.G_EXC_ERROR;
1950: END IF;
1951: END IF;
1952:
1953: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1954:
1955: fnd_log.string
1956: (
1957: fnd_log.level_statement,

Line 1955: fnd_log.string

1951: END IF;
1952:
1953: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1954:
1955: fnd_log.string
1956: (
1957: fnd_log.level_statement,
1958: l_debug_module ,
1959: 'Route Id of the Operation that is being updated .....' || l_route_id

Line 1957: fnd_log.level_statement,

1953: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1954:
1955: fnd_log.string
1956: (
1957: fnd_log.level_statement,
1958: l_debug_module ,
1959: 'Route Id of the Operation that is being updated .....' || l_route_id
1960: );
1961: END IF;

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

1990: END IF;
1991:
1992: CLOSE get_rt_oper_resource;
1993:
1994: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1995:
1996: fnd_log.string
1997: (
1998: fnd_log.level_statement,

Line 1996: fnd_log.string

1992: CLOSE get_rt_oper_resource;
1993:
1994: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1995:
1996: fnd_log.string
1997: (
1998: fnd_log.level_statement,
1999: l_debug_module ,
2000: 'Before calling Private API AHL_RM_RT_OPER_RESOURCE_PVT.process_alternate_resource'

Line 1998: fnd_log.level_statement,

1994: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1995:
1996: fnd_log.string
1997: (
1998: fnd_log.level_statement,
1999: l_debug_module ,
2000: 'Before calling Private API AHL_RM_RT_OPER_RESOURCE_PVT.process_alternate_resource'
2001: );
2002: END IF;

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

2016: p_x_alt_resource_tbl => p_x_alt_resource_tbl
2017: );
2018:
2019:
2020: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2021:
2022: fnd_log.string
2023: (
2024: fnd_log.level_statement,

Line 2022: fnd_log.string

2018:
2019:
2020: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2021:
2022: fnd_log.string
2023: (
2024: fnd_log.level_statement,
2025: l_debug_module ,
2026: 'After calling Private API AHL_RM_RT_OPER_RESOURCE_PVT.process_alternate_resource'

Line 2024: fnd_log.level_statement,

2020: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2021:
2022: fnd_log.string
2023: (
2024: fnd_log.level_statement,
2025: l_debug_module ,
2026: 'After calling Private API AHL_RM_RT_OPER_RESOURCE_PVT.process_alternate_resource'
2027: );
2028: END IF;

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

2027: );
2028: END IF;
2029:
2030:
2031: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
2032: fnd_log.string
2033: (
2034: fnd_log.level_procedure,
2035: l_debug_module ||'.End',

Line 2032: fnd_log.string

2028: END IF;
2029:
2030:
2031: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
2032: fnd_log.string
2033: (
2034: fnd_log.level_procedure,
2035: l_debug_module ||'.End',
2036: 'At the end of PLSQL procedure...'

Line 2034: fnd_log.level_procedure,

2030:
2031: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
2032: fnd_log.string
2033: (
2034: fnd_log.level_procedure,
2035: l_debug_module ||'.End',
2036: 'At the end of PLSQL procedure...'
2037: );
2038: END IF;

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

2038: END IF;
2039:
2040: -- Check Error Message stack.
2041: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
2042: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level) THEN
2043: fnd_log.string
2044: (
2045: fnd_log.level_error,
2046: l_debug_module ,

Line 2043: fnd_log.string

2039:
2040: -- Check Error Message stack.
2041: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
2042: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level) THEN
2043: fnd_log.string
2044: (
2045: fnd_log.level_error,
2046: l_debug_module ,
2047: 'Public API raised expected error....'

Line 2045: fnd_log.level_error,

2041: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
2042: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level) THEN
2043: fnd_log.string
2044: (
2045: fnd_log.level_error,
2046: l_debug_module ,
2047: 'Public API raised expected error....'
2048: );
2049: END IF;

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

2048: );
2049: END IF;
2050: RAISE FND_API.G_EXC_ERROR;
2051: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2052: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
2053: fnd_log.string
2054: (
2055: fnd_log.level_error,
2056: l_debug_module ,

Line 2053: fnd_log.string

2049: END IF;
2050: RAISE FND_API.G_EXC_ERROR;
2051: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2052: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
2053: fnd_log.string
2054: (
2055: fnd_log.level_error,
2056: l_debug_module ,
2057: 'Public API raised unexpected error....'

Line 2055: fnd_log.level_error,

2051: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2052: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
2053: fnd_log.string
2054: (
2055: fnd_log.level_error,
2056: l_debug_module ,
2057: 'Public API raised unexpected error....'
2058: );
2059: END IF;