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

APPS.OKS_MISC_UTIL_WEB dependencies on FND_LOG

Line 242: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

238: WHERE shdr.chr_id = p_chr_id;
239:
240: BEGIN
241: -- start debug log
242: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
243: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
244: G_MODULE||l_api_name,
245: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
246: END IF;

Line 243: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

239:
240: BEGIN
241: -- start debug log
242: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
243: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
244: G_MODULE||l_api_name,
245: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
246: END IF;
247:

Line 257: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

253: FETCH c_tax_amount INTO l_tax_amount;
254: CLOSE c_tax_amount;
255:
256: -- end debug log
257: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
258: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
259: G_MODULE||l_api_name,
260: '1000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
261: END IF;

Line 258: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

254: CLOSE c_tax_amount;
255:
256: -- end debug log
257: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
258: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
259: G_MODULE||l_api_name,
260: '1000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
261: END IF;
262:

Line 270: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

266:
267:
268: EXCEPTION
269: WHEN OTHERS THEN
270: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
271: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
272: G_MODULE||l_api_name,
273: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
274: END IF;

Line 271: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

267:
268: EXCEPTION
269: WHEN OTHERS THEN
270: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
271: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
272: G_MODULE||l_api_name,
273: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
274: END IF;
275:

Line 416: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

412: l_amount NUMBER;
413:
414: BEGIN
415:
416: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
417: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: Inside get_line_billed_amount');
418: END IF;
419:
420: IF p_line_level = 'L' THEN

Line 417: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: Inside get_line_billed_amount');

413:
414: BEGIN
415:
416: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
417: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: Inside get_line_billed_amount');
418: END IF;
419:
420: IF p_line_level = 'L' THEN
421: OPEN line_billed_amount_curr(p_line_id);

Line 433: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

429: CLOSE sub_line_billed_amount_curr;
430: END IF;
431:
432:
433: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
434: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'101: get_line_billed_amount');
435: END IF;
436:
437: return l_amount;

Line 434: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'101: get_line_billed_amount');

430: END IF;
431:
432:
433: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
434: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'101: get_line_billed_amount');
435: END IF;
436:
437: return l_amount;
438:

Line 441: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

437: return l_amount;
438:
439: EXCEPTION
440: WHEN OTHERS THEN
441: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
442: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'1000: Leaving get_line_billed_amount because of EXCEPTION: '||sqlerrm);
443: END IF;
444: IF line_billed_amount_curr %ISOPEN THEN
445: CLOSE line_billed_amount_curr ;

Line 442: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'1000: Leaving get_line_billed_amount because of EXCEPTION: '||sqlerrm);

438:
439: EXCEPTION
440: WHEN OTHERS THEN
441: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
442: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'1000: Leaving get_line_billed_amount because of EXCEPTION: '||sqlerrm);
443: END IF;
444: IF line_billed_amount_curr %ISOPEN THEN
445: CLOSE line_billed_amount_curr ;
446: END IF;

Line 609: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

605: l_unbilled_amount NUMBER;
606:
607: BEGIN
608:
609: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
610: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: Inside get_line_unbilled_amount');
611: END IF;
612:
613:

Line 610: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: Inside get_line_unbilled_amount');

606:
607: BEGIN
608:
609: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
610: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: Inside get_line_unbilled_amount');
611: END IF;
612:
613:
614: IF p_line_level = 'L' THEN

Line 627: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

623: CLOSE sub_line_unbilled_amount_curr;
624: END IF;
625:
626:
627: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
628: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'101: get_line_unbilled_amount');
629: END IF;
630:
631: return l_unbilled_amount;

Line 628: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'101: get_line_unbilled_amount');

624: END IF;
625:
626:
627: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
628: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'101: get_line_unbilled_amount');
629: END IF;
630:
631: return l_unbilled_amount;
632:

Line 635: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

631: return l_unbilled_amount;
632:
633: EXCEPTION
634: WHEN OTHERS THEN
635: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
636: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'1000: Leaving get_line_unbilled_amount because of EXCEPTION: '||sqlerrm);
637: END IF;
638:
639: IF line_unbilled_amount_curr %ISOPEN THEN

Line 636: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'1000: Leaving get_line_unbilled_amount because of EXCEPTION: '||sqlerrm);

632:
633: EXCEPTION
634: WHEN OTHERS THEN
635: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
636: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'1000: Leaving get_line_unbilled_amount because of EXCEPTION: '||sqlerrm);
637: END IF;
638:
639: IF line_unbilled_amount_curr %ISOPEN THEN
640: CLOSE line_unbilled_amount_curr ;

Line 733: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

729: l_unbilled_amount NUMBER := 0;
730:
731: BEGIN
732:
733: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
734: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: Inside get_header_unbilled_amount');
735: END IF;
736:
737: OPEN c_header_unbilled_amount(p_chr_id);

Line 734: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: Inside get_header_unbilled_amount');

730:
731: BEGIN
732:
733: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
734: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: Inside get_header_unbilled_amount');
735: END IF;
736:
737: OPEN c_header_unbilled_amount(p_chr_id);
738: FETCH c_header_unbilled_amount INTO l_unbilled_amount;

Line 741: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

737: OPEN c_header_unbilled_amount(p_chr_id);
738: FETCH c_header_unbilled_amount INTO l_unbilled_amount;
739: CLOSE c_header_unbilled_amount;
740:
741: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
742: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'101: get_header_unbilled_amount');
743: END IF;
744:
745: return l_unbilled_amount;

Line 742: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'101: get_header_unbilled_amount');

738: FETCH c_header_unbilled_amount INTO l_unbilled_amount;
739: CLOSE c_header_unbilled_amount;
740:
741: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
742: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'101: get_header_unbilled_amount');
743: END IF;
744:
745: return l_unbilled_amount;
746:

Line 749: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

745: return l_unbilled_amount;
746:
747: EXCEPTION
748: WHEN OTHERS THEN
749: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
750: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'1000: Leaving due EXCEPTION: '||sqlerrm);
751: END IF;
752: IF c_header_unbilled_amount %ISOPEN THEN
753: CLOSE c_header_unbilled_amount ;

Line 750: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'1000: Leaving due EXCEPTION: '||sqlerrm);

746:
747: EXCEPTION
748: WHEN OTHERS THEN
749: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
750: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'1000: Leaving due EXCEPTION: '||sqlerrm);
751: END IF;
752: IF c_header_unbilled_amount %ISOPEN THEN
753: CLOSE c_header_unbilled_amount ;
754: END IF;

Line 848: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

844: l_billed_amount NUMBER := 0;
845:
846: BEGIN
847:
848: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
849: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: Inside get_header_billed_amount');
850: END IF;
851:
852: OPEN c_header_billed_amount(p_chr_id);

Line 849: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: Inside get_header_billed_amount');

845:
846: BEGIN
847:
848: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
849: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: Inside get_header_billed_amount');
850: END IF;
851:
852: OPEN c_header_billed_amount(p_chr_id);
853: FETCH c_header_billed_amount INTO l_billed_amount;

Line 856: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

852: OPEN c_header_billed_amount(p_chr_id);
853: FETCH c_header_billed_amount INTO l_billed_amount;
854: CLOSE c_header_billed_amount;
855:
856: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
857: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'101: get_header_billed_amount');
858: END IF;
859:
860: return l_billed_amount;

Line 857: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'101: get_header_billed_amount');

853: FETCH c_header_billed_amount INTO l_billed_amount;
854: CLOSE c_header_billed_amount;
855:
856: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
857: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'101: get_header_billed_amount');
858: END IF;
859:
860: return l_billed_amount;
861:

Line 864: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

860: return l_billed_amount;
861:
862: EXCEPTION
863: WHEN OTHERS THEN
864: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
865: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'1000: Leaving due EXCEPTION: '||sqlerrm);
866: END IF;
867: IF c_header_billed_amount %ISOPEN THEN
868: CLOSE c_header_billed_amount ;

Line 865: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'1000: Leaving due EXCEPTION: '||sqlerrm);

861:
862: EXCEPTION
863: WHEN OTHERS THEN
864: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
865: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'1000: Leaving due EXCEPTION: '||sqlerrm);
866: END IF;
867: IF c_header_billed_amount %ISOPEN THEN
868: CLOSE c_header_billed_amount ;
869: END IF;

Line 896: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

892: AND language = userenv('LANG');
893:
894: BEGIN
895:
896: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
897: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'Inside get_duration_period');
898: END IF;
899:
900: OPEN get_period_maening(duration_unit(p_start_date,p_end_date));

Line 897: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'Inside get_duration_period');

893:
894: BEGIN
895:
896: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
897: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'Inside get_duration_period');
898: END IF;
899:
900: OPEN get_period_maening(duration_unit(p_start_date,p_end_date));
901: FETCH get_period_maening INTO l_period_meaning;

Line 908: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

904: return duration_period(p_start_date,p_end_date) || ' ' || l_period_meaning ;
905:
906: EXCEPTION
907: WHEN OTHERS THEN
908: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
909: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'EXCEPTION: '||sqlerrm);
910: END IF;
911: END get_duration_period;
912:

Line 909: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'EXCEPTION: '||sqlerrm);

905:
906: EXCEPTION
907: WHEN OTHERS THEN
908: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
909: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'EXCEPTION: '||sqlerrm);
910: END IF;
911: END get_duration_period;
912:
913: -- Function to get the covered level name (Service).

Line 970: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

966: WHERE site.party_site_id = to_number(p_object1_id1);
967:
968: BEGIN
969:
970: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
971: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'Inside get_covdlvl_name ' ||
972: 'p_jtot_object1_code is : ' || p_jtot_object1_code ||
973: 'p_object1_id1 is : ' || p_object1_id1 ||
974: 'p_object1_id2 is : ' || p_object1_id2);

Line 971: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'Inside get_covdlvl_name ' ||

967:
968: BEGIN
969:
970: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
971: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'Inside get_covdlvl_name ' ||
972: 'p_jtot_object1_code is : ' || p_jtot_object1_code ||
973: 'p_object1_id1 is : ' || p_object1_id1 ||
974: 'p_object1_id2 is : ' || p_object1_id2);
975: END IF;

Line 1009: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1005: FETCH get_system_name_csr INTO l_name;
1006: CLOSE get_system_name_csr;
1007: END IF;
1008:
1009: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1010: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'Exit get_covdlvl_name ' ||
1011: 'l_name is : ' || l_name);
1012: END IF;
1013:

Line 1010: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'Exit get_covdlvl_name ' ||

1006: CLOSE get_system_name_csr;
1007: END IF;
1008:
1009: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1010: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'Exit get_covdlvl_name ' ||
1011: 'l_name is : ' || l_name);
1012: END IF;
1013:
1014: RETURN (l_name);

Line 1018: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1014: RETURN (l_name);
1015:
1016: EXCEPTION
1017: WHEN OTHERS THEN
1018: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1019: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'EXCEPTION: '||sqlerrm);
1020: END IF;
1021: IF get_item_name_csr%ISOPEN THEN
1022: CLOSE get_item_name_csr ;

Line 1019: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'EXCEPTION: '||sqlerrm);

1015:
1016: EXCEPTION
1017: WHEN OTHERS THEN
1018: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1019: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'EXCEPTION: '||sqlerrm);
1020: END IF;
1021: IF get_item_name_csr%ISOPEN THEN
1022: CLOSE get_item_name_csr ;
1023: ELSIF get_account_name_csr%ISOPEN THEN

Line 1064: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1060: WHERE sysitems.inventory_item_id = to_number(p_object1_id1)
1061: AND rownum < 2;
1062: BEGIN
1063:
1064: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1065: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'Inside get_covdlvl_name ' ||
1066: 'p_line_id is : ' || p_line_id ||
1067: 'p_lse_id is : ' || p_lse_id);
1068:

Line 1065: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'Inside get_covdlvl_name ' ||

1061: AND rownum < 2;
1062: BEGIN
1063:
1064: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1065: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'Inside get_covdlvl_name ' ||
1066: 'p_line_id is : ' || p_line_id ||
1067: 'p_lse_id is : ' || p_lse_id);
1068:
1069: END IF;

Line 1088: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1084: RETURN (l_name);
1085:
1086: EXCEPTION
1087: WHEN OTHERS THEN
1088: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1089: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'EXCEPTION: '||sqlerrm);
1090: END IF;
1091:
1092: IF get_objec_rel_csr%ISOPEN THEN

Line 1089: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'EXCEPTION: '||sqlerrm);

1085:
1086: EXCEPTION
1087: WHEN OTHERS THEN
1088: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1089: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'EXCEPTION: '||sqlerrm);
1090: END IF;
1091:
1092: IF get_objec_rel_csr%ISOPEN THEN
1093: CLOSE get_objec_rel_csr;

Line 1120: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1116: AND nvl(rah.org_id,-99) = p_org_id;
1117:
1118: BEGIN
1119:
1120: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1121: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'Inside GET_COMMITMENT_NUMBER ' ||
1122: 'p_commitment_id is : ' || p_commitment_id ||
1123: ' p_org_id is: ' || p_org_id);
1124:

Line 1121: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'Inside GET_COMMITMENT_NUMBER ' ||

1117:
1118: BEGIN
1119:
1120: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1121: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'Inside GET_COMMITMENT_NUMBER ' ||
1122: 'p_commitment_id is : ' || p_commitment_id ||
1123: ' p_org_id is: ' || p_org_id);
1124:
1125: END IF;

Line 1134: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1130: return l_commitment_number;
1131:
1132: EXCEPTION
1133: WHEN OTHERS THEN
1134: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1135: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'EXCEPTION: ' || sqlerrm);
1136: END IF;
1137: IF get_commitment_number_csr %ISOPEN THEN
1138: CLOSE get_commitment_number_csr ;

Line 1135: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'EXCEPTION: ' || sqlerrm);

1131:
1132: EXCEPTION
1133: WHEN OTHERS THEN
1134: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1135: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'EXCEPTION: ' || sqlerrm);
1136: END IF;
1137: IF get_commitment_number_csr %ISOPEN THEN
1138: CLOSE get_commitment_number_csr ;
1139: END IF;

Line 1181: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1177: AND oel.service_reference_type_code = 'ORDER';
1178:
1179: BEGIN
1180:
1181: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1182: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1183: G_MODULE||l_api_name,
1184: 'Entered '||G_PKG_NAME ||'.'||l_api_name);
1185: END IF;

Line 1182: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1178:
1179: BEGIN
1180:
1181: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1182: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1183: G_MODULE||l_api_name,
1184: 'Entered '||G_PKG_NAME ||'.'||l_api_name);
1185: END IF;
1186:

Line 1194: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1190: l_component_yn := 'N';
1191: END IF;
1192: CLOSE is_component_yn_cur;
1193:
1194: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1195: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1196: G_MODULE||l_api_name,
1197: 'Leaving '||G_PKG_NAME ||'.'||l_api_name);
1198: END IF;

Line 1195: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1191: END IF;
1192: CLOSE is_component_yn_cur;
1193:
1194: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1195: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1196: G_MODULE||l_api_name,
1197: 'Leaving '||G_PKG_NAME ||'.'||l_api_name);
1198: END IF;
1199:

Line 1204: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1200: RETURN l_component_yn;
1201:
1202: EXCEPTION
1203: WHEN OTHERS THEN
1204: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1205: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1206: G_MODULE||l_api_name,
1207: 'Leaving '||G_PKG_NAME ||'.'||l_api_name);
1208: END IF;

Line 1205: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1201:
1202: EXCEPTION
1203: WHEN OTHERS THEN
1204: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1205: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1206: G_MODULE||l_api_name,
1207: 'Leaving '||G_PKG_NAME ||'.'||l_api_name);
1208: END IF;
1209: IF is_component_yn_cur%ISOPEN THEN