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.JAI_PO_WF_UTIL_PUB dependencies on FND_LOG

Line 80: ln_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;

76: ln_req_conv_curr_rate po_requisition_lines_all.rate%TYPE;
77: lv_req_conv_curr_code po_requisition_lines_all.currency_code%TYPE;
78:
79: lv_procedure_name VARCHAR2(40):='Get_Req_Curr_Conv_Rate';
80: ln_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;
81: ln_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;
82:
83: CURSOR Get_Curr_Conv_Rate_Cur
84: IS

Line 81: ln_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;

77: lv_req_conv_curr_code po_requisition_lines_all.currency_code%TYPE;
78:
79: lv_procedure_name VARCHAR2(40):='Get_Req_Curr_Conv_Rate';
80: ln_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;
81: ln_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;
82:
83: CURSOR Get_Curr_Conv_Rate_Cur
84: IS
85: SELECT

Line 97: FND_LOG.STRING( ln_proc_level

93: BEGIN
94: --logging for debug
95: IF (ln_proc_level >= ln_dbg_level)
96: THEN
97: FND_LOG.STRING( ln_proc_level
98: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.begin'
99: , 'Enter procedure'
100: );
101: END IF; --l_proc_level>=l_dbg_level

Line 173: FND_LOG.STRING( ln_proc_level

169:
170: --logging for debug
171: IF (ln_proc_level >= ln_dbg_level)
172: THEN
173: FND_LOG.STRING( ln_proc_level
174: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.end'
175: , 'Exit procedure'
176: );
177: END IF; -- (ln_proc_level>=ln_dbg_level)

Line 181: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

177: END IF; -- (ln_proc_level>=ln_dbg_level)
178: EXCEPTION
179: WHEN OTHERS
180: THEN
181: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
182: THEN
183: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
184: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.Other_Exception '
185: , Sqlcode||Sqlerrm);

Line 183: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED

179: WHEN OTHERS
180: THEN
181: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
182: THEN
183: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
184: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.Other_Exception '
185: , Sqlcode||Sqlerrm);
186: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
187: END Get_Req_Curr_Conv_Rate;

Line 186: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

182: THEN
183: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
184: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.Other_Exception '
185: , Sqlcode||Sqlerrm);
186: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
187: END Get_Req_Curr_Conv_Rate;
188:
189: --==========================================================================
190: -- PROCEDURE NAME:

Line 227: ln_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;

223: lv_base_currency GL_SETS_OF_BOOKS.currency_code%TYPE;
224: lv_po_currency PO_HEADERS_ALL.currency_code%TYPE;
225:
226: lv_procedure_name VARCHAR2(40):='Get_Currency_Convertion_Rate';
227: ln_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;
228: ln_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;
229: BEGIN
230: --logging for debug
231: IF (ln_proc_level >= ln_dbg_level)

Line 228: ln_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;

224: lv_po_currency PO_HEADERS_ALL.currency_code%TYPE;
225:
226: lv_procedure_name VARCHAR2(40):='Get_Currency_Convertion_Rate';
227: ln_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;
228: ln_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;
229: BEGIN
230: --logging for debug
231: IF (ln_proc_level >= ln_dbg_level)
232: THEN

Line 233: FND_LOG.STRING( ln_proc_level

229: BEGIN
230: --logging for debug
231: IF (ln_proc_level >= ln_dbg_level)
232: THEN
233: FND_LOG.STRING( ln_proc_level
234: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.begin'
235: , 'Enter procedure'
236: );
237: END IF; --l_proc_level>=l_dbg_level

Line 287: FND_LOG.STRING( ln_proc_level

283:
284: --logging for debug
285: IF (ln_proc_level >= ln_dbg_level)
286: THEN
287: FND_LOG.STRING( ln_proc_level
288: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.end'
289: , 'Exit procedure'
290: );
291: END IF; -- (ln_proc_level>=ln_dbg_level)

Line 295: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

291: END IF; -- (ln_proc_level>=ln_dbg_level)
292: EXCEPTION
293: WHEN OTHERS
294: THEN
295: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
296: THEN
297: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
298: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.Other_Exception '
299: , Sqlcode||Sqlerrm);

Line 297: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED

293: WHEN OTHERS
294: THEN
295: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
296: THEN
297: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
298: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.Other_Exception '
299: , Sqlcode||Sqlerrm);
300: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
301: END Get_Currency_Convertion_Rate;

Line 300: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

296: THEN
297: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
298: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.Other_Exception '
299: , Sqlcode||Sqlerrm);
300: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
301: END Get_Currency_Convertion_Rate;
302:
303: --==========================================================================
304: -- PROCEDURE NAME:

Line 362: ln_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;

358: ln_rounding_factor jai_cmn_taxes_all.rounding_factor%TYPE;
359: lv_tax_type jai_cmn_taxes_all.tax_type%TYPE; -- added by Eric Ma for bug10426971 on 28-Dec-2010
360:
361: lv_procedure_name VARCHAR2(40):='Get_Tax_Amount_Info';
362: ln_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;
363: ln_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;
364: BEGIN
365: --logging for debug
366: IF (ln_proc_level >= ln_dbg_level)

Line 363: ln_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;

359: lv_tax_type jai_cmn_taxes_all.tax_type%TYPE; -- added by Eric Ma for bug10426971 on 28-Dec-2010
360:
361: lv_procedure_name VARCHAR2(40):='Get_Tax_Amount_Info';
362: ln_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;
363: ln_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;
364: BEGIN
365: --logging for debug
366: IF (ln_proc_level >= ln_dbg_level)
367: THEN

Line 368: FND_LOG.STRING( ln_proc_level

364: BEGIN
365: --logging for debug
366: IF (ln_proc_level >= ln_dbg_level)
367: THEN
368: FND_LOG.STRING( ln_proc_level
369: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.begin'
370: , 'Enter procedure'
371: );
372: END IF; --l_proc_level>=l_dbg_level

Line 424: FND_LOG.STRING( ln_proc_level

420:
421: --logging for debug
422: IF (ln_proc_level >= ln_dbg_level)
423: THEN
424: FND_LOG.STRING( ln_proc_level
425: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.end'
426: , 'Exit procedure'
427: );
428: END IF; -- (ln_proc_level>=ln_dbg_level)

Line 432: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

428: END IF; -- (ln_proc_level>=ln_dbg_level)
429: EXCEPTION
430: WHEN OTHERS
431: THEN
432: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
433: THEN
434: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
435: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.Other_Exception '
436: , Sqlcode||Sqlerrm);

Line 434: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED

430: WHEN OTHERS
431: THEN
432: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
433: THEN
434: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
435: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.Other_Exception '
436: , Sqlcode||Sqlerrm);
437: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
438: RAISE;

Line 437: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

433: THEN
434: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
435: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.Other_Exception '
436: , Sqlcode||Sqlerrm);
437: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
438: RAISE;
439: END Get_Tax_Amount_Info;
440:
441: --==========================================================================

Line 540: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

536: WHERE POA.PO_RELEASE_ID = pn_document_id;
537:
538:
539: lv_procedure_name VARCHAR2(40) := 'Get_Jai_Tax_Amount';
540: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
541: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
542:
543: BEGIN
544: --logging for debug

Line 541: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;

537:
538:
539: lv_procedure_name VARCHAR2(40) := 'Get_Jai_Tax_Amount';
540: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
541: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
542:
543: BEGIN
544: --logging for debug
545: IF (ln_proc_level >= ln_dbg_level)

Line 547: FND_LOG.STRING( ln_proc_level

543: BEGIN
544: --logging for debug
545: IF (ln_proc_level >= ln_dbg_level)
546: THEN
547: FND_LOG.STRING( ln_proc_level
548: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.begin'
549: , 'Enter procedure'
550: );
551: END IF; --l_proc_level>=l_dbg_level

Line 709: FND_LOG.STRING( ln_proc_level

705:
706: --logging for debug
707: IF (ln_proc_level >= ln_dbg_level)
708: THEN
709: FND_LOG.STRING( ln_proc_level
710: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.end'
711: , 'Exit procedure'
712: );
713: END IF; -- (ln_proc_level>=ln_dbg_level)

Line 718: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

714:
715: EXCEPTION
716: WHEN OTHERS
717: THEN
718: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
719: THEN
720: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
721: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.Other_Exception '
722: , Sqlcode||Sqlerrm);

Line 720: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED

716: WHEN OTHERS
717: THEN
718: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
719: THEN
720: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
721: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.Other_Exception '
722: , Sqlcode||Sqlerrm);
723: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
724: RAISE;

Line 723: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

719: THEN
720: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
721: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.Other_Exception '
722: , Sqlcode||Sqlerrm);
723: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
724: RAISE;
725: END Get_Jai_Tax_Amount;
726:
727: --==========================================================================

Line 756: ln_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;

752: ) RETURN VARCHAR2
753: IS
754: ln_org_id NUMBER := pn_org_id;
755: lv_procedure_name VARCHAR2(40):='Get_Tax_Region';
756: ln_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;
757: ln_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;
758: BEGIN
759: --logging for debug
760: IF (ln_proc_level >= ln_dbg_level)

Line 757: ln_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;

753: IS
754: ln_org_id NUMBER := pn_org_id;
755: lv_procedure_name VARCHAR2(40):='Get_Tax_Region';
756: ln_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;
757: ln_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;
758: BEGIN
759: --logging for debug
760: IF (ln_proc_level >= ln_dbg_level)
761: THEN

Line 762: FND_LOG.STRING( ln_proc_level

758: BEGIN
759: --logging for debug
760: IF (ln_proc_level >= ln_dbg_level)
761: THEN
762: FND_LOG.STRING( ln_proc_level
763: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.begin'
764: , 'Enter procedure'
765: );
766: END IF; --l_proc_level>=l_dbg_level

Line 793: FND_LOG.STRING( ln_proc_level

789: THEN
790: --logging for debug
791: IF (ln_proc_level >= ln_dbg_level)
792: THEN
793: FND_LOG.STRING( ln_proc_level
794: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.end'
795: , 'Exit procedure'
796: );
797: END IF; -- (ln_proc_level>=ln_dbg_level)

Line 804: FND_LOG.STRING( ln_proc_level

800: ELSE
801: --logging for debug
802: IF (ln_proc_level >= ln_dbg_level)
803: THEN
804: FND_LOG.STRING( ln_proc_level
805: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.end'
806: , 'Exit procedure'
807: );
808: END IF; -- (ln_proc_level>=ln_dbg_level)

Line 815: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

811: END IF;--(jai_cmn_utils_pkg.check_jai_exists)
812: EXCEPTION
813: WHEN OTHERS
814: THEN
815: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
816: THEN
817: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
818: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.Other_Exception '
819: , Sqlcode||Sqlerrm);

Line 817: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED

813: WHEN OTHERS
814: THEN
815: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
816: THEN
817: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
818: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.Other_Exception '
819: , Sqlcode||Sqlerrm);
820: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
821: RAISE;

Line 820: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

816: THEN
817: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
818: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.Other_Exception '
819: , Sqlcode||Sqlerrm);
820: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
821: RAISE;
822: END Get_Tax_Region;
823:
824:

Line 908: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

904: and request_level='LINE'
905: and change_request_group_id =pn_chg_request_group_id;
906:
907: lv_procedure_name VARCHAR2(40) := 'Get_Jai_New_Tax_Amount';
908: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
909: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
910:
911: BEGIN
912: --logging for debug

Line 909: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;

905: and change_request_group_id =pn_chg_request_group_id;
906:
907: lv_procedure_name VARCHAR2(40) := 'Get_Jai_New_Tax_Amount';
908: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
909: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
910:
911: BEGIN
912: --logging for debug
913: IF (ln_proc_level >= ln_dbg_level)

Line 915: FND_LOG.STRING( ln_proc_level

911: BEGIN
912: --logging for debug
913: IF (ln_proc_level >= ln_dbg_level)
914: THEN
915: FND_LOG.STRING( ln_proc_level
916: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.begin'
917: , 'Enter procedure'
918: );
919: END IF; --l_proc_level>=l_dbg_level

Line 1028: FND_LOG.STRING( ln_proc_level

1024:
1025: --logging for debug
1026: IF (ln_proc_level >= ln_dbg_level)
1027: THEN
1028: FND_LOG.STRING( ln_proc_level
1029: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.end'
1030: , 'Exit procedure'
1031: );
1032: END IF; -- (ln_proc_level>=ln_dbg_level)

Line 1037: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

1033:
1034: EXCEPTION
1035: WHEN OTHERS
1036: THEN
1037: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1038: THEN
1039: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
1040: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.Other_Exception '
1041: , Sqlcode||Sqlerrm);

Line 1039: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED

1035: WHEN OTHERS
1036: THEN
1037: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1038: THEN
1039: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
1040: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.Other_Exception '
1041: , Sqlcode||Sqlerrm);
1042: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1043: RAISE;

Line 1042: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

1038: THEN
1039: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
1040: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.Other_Exception '
1041: , Sqlcode||Sqlerrm);
1042: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1043: RAISE;
1044: END Get_Jai_New_Tax_Amount;
1045:
1046: --==========================================================================

Line 1076: ln_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1072: IS
1073: lv_jai_excl_nr_tax_disp VARCHAR2(32000);
1074: lv_amount_for_tax_disp VARCHAR2(32000);
1075: lv_procedure_name VARCHAR2(40):='Get_Jai_Req_Tax_Disp';
1076: ln_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1077: ln_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;
1078: BEGIN
1079: --logging for debug
1080: IF (ln_proc_level >= ln_dbg_level)

Line 1077: ln_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;

1073: lv_jai_excl_nr_tax_disp VARCHAR2(32000);
1074: lv_amount_for_tax_disp VARCHAR2(32000);
1075: lv_procedure_name VARCHAR2(40):='Get_Jai_Req_Tax_Disp';
1076: ln_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1077: ln_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;
1078: BEGIN
1079: --logging for debug
1080: IF (ln_proc_level >= ln_dbg_level)
1081: THEN

Line 1082: FND_LOG.STRING( ln_proc_level

1078: BEGIN
1079: --logging for debug
1080: IF (ln_proc_level >= ln_dbg_level)
1081: THEN
1082: FND_LOG.STRING( ln_proc_level
1083: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.begin'
1084: , 'Enter procedure'
1085: );
1086: END IF; --l_proc_level>=l_dbg_level

Line 1094: FND_LOG.STRING( ln_proc_level

1090:
1091: --logging for debug
1092: IF (ln_proc_level >= ln_dbg_level)
1093: THEN
1094: FND_LOG.STRING( ln_proc_level
1095: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.end'
1096: , 'Exit procedure'
1097: );
1098: END IF; --l_proc_level>=l_dbg_level

Line 1103: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

1099: RETURN lv_amount_for_tax_disp;
1100: EXCEPTION
1101: WHEN OTHERS
1102: THEN
1103: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1104: THEN
1105: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
1106: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.Other_Exception '
1107: , Sqlcode||Sqlerrm);

Line 1105: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED

1101: WHEN OTHERS
1102: THEN
1103: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1104: THEN
1105: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
1106: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.Other_Exception '
1107: , Sqlcode||Sqlerrm);
1108: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1109: RAISE;

Line 1108: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

1104: THEN
1105: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
1106: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.Other_Exception '
1107: , Sqlcode||Sqlerrm);
1108: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1109: RAISE;
1110: END Get_Jai_Req_Tax_Disp;
1111:
1112: --==========================================================================

Line 1139: ln_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1135: ) RETURN VARCHAR2
1136: IS
1137: lv_amount_for_tax_disp VARCHAR2(32000);
1138: lv_procedure_name VARCHAR2(40):='Get_Jai_Tax_Disp';
1139: ln_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1140: ln_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;
1141: BEGIN
1142: --logging for debug
1143: IF (ln_proc_level >= ln_dbg_level)

Line 1140: ln_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;

1136: IS
1137: lv_amount_for_tax_disp VARCHAR2(32000);
1138: lv_procedure_name VARCHAR2(40):='Get_Jai_Tax_Disp';
1139: ln_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1140: ln_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;
1141: BEGIN
1142: --logging for debug
1143: IF (ln_proc_level >= ln_dbg_level)
1144: THEN

Line 1145: FND_LOG.STRING( ln_proc_level

1141: BEGIN
1142: --logging for debug
1143: IF (ln_proc_level >= ln_dbg_level)
1144: THEN
1145: FND_LOG.STRING( ln_proc_level
1146: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.begin'
1147: , 'Enter procedure'
1148: );
1149: END IF; --l_proc_level>=l_dbg_level

Line 1155: FND_LOG.STRING( ln_proc_level

1151:
1152: --logging for debug
1153: IF (ln_proc_level >= ln_dbg_level)
1154: THEN
1155: FND_LOG.STRING( ln_proc_level
1156: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.end'
1157: , 'Exit procedure'
1158: );
1159: END IF; --l_proc_level>=l_dbg_level

Line 1164: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

1160: RETURN lv_amount_for_tax_disp;
1161: EXCEPTION
1162: WHEN OTHERS
1163: THEN
1164: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1165: THEN
1166: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
1167: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.Other_Exception '
1168: , Sqlcode||Sqlerrm);

Line 1166: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED

1162: WHEN OTHERS
1163: THEN
1164: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1165: THEN
1166: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
1167: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.Other_Exception '
1168: , Sqlcode||Sqlerrm);
1169: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1170: RAISE;

Line 1169: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

1165: THEN
1166: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
1167: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.Other_Exception '
1168: , Sqlcode||Sqlerrm);
1169: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1170: RAISE;
1171: END Get_Jai_Tax_Disp;
1172:
1173: --==========================================================================

Line 1195: ln_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1191: RETURN VARCHAR2
1192: IS
1193: lv_open_form VARCHAR2 (32000);
1194: lv_procedure_name VARCHAR2(40):='Get_Jai_Open_Form_command';
1195: ln_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1196: ln_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;
1197: BEGIN
1198: --logging for debug
1199: IF (ln_proc_level >= ln_dbg_level)

Line 1196: ln_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;

1192: IS
1193: lv_open_form VARCHAR2 (32000);
1194: lv_procedure_name VARCHAR2(40):='Get_Jai_Open_Form_command';
1195: ln_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1196: ln_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;
1197: BEGIN
1198: --logging for debug
1199: IF (ln_proc_level >= ln_dbg_level)
1200: THEN

Line 1201: FND_LOG.STRING( ln_proc_level

1197: BEGIN
1198: --logging for debug
1199: IF (ln_proc_level >= ln_dbg_level)
1200: THEN
1201: FND_LOG.STRING( ln_proc_level
1202: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.begin'
1203: , 'Enter procedure'
1204: );
1205: END IF; --l_proc_level>=l_dbg_level

Line 1248: FND_LOG.STRING( ln_proc_level

1244:
1245: --logging for debug
1246: IF (ln_proc_level >= ln_dbg_level)
1247: THEN
1248: FND_LOG.STRING( ln_proc_level
1249: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.end'
1250: , 'Exit procedure'
1251: );
1252: END IF; --l_proc_level>=l_dbg_level

Line 1258: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

1254: RETURN lv_open_form;
1255: EXCEPTION
1256: WHEN OTHERS
1257: THEN
1258: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1259: THEN
1260: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
1261: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.Other_Exception '
1262: , Sqlcode||Sqlerrm);

Line 1260: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED

1256: WHEN OTHERS
1257: THEN
1258: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1259: THEN
1260: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
1261: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.Other_Exception '
1262: , Sqlcode||Sqlerrm);
1263: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1264: RAISE;

Line 1263: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

1259: THEN
1260: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
1261: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.Other_Exception '
1262: , Sqlcode||Sqlerrm);
1263: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1264: RAISE;
1265: END Get_Jai_Open_Form_Command;
1266:
1267:

Line 1360: ln_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1356: AND POA.PO_HEADER_ID = pn_document_id
1357: AND PLLA.LINE_LOCATION_ID = pn_line_location_id ;
1358:
1359: lv_procedure_name VARCHAR2(40):='Get_Poreq_Tax';
1360: ln_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1361: ln_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;
1362:
1363: BEGIN
1364: --logging for debug

Line 1361: ln_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;

1357: AND PLLA.LINE_LOCATION_ID = pn_line_location_id ;
1358:
1359: lv_procedure_name VARCHAR2(40):='Get_Poreq_Tax';
1360: ln_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1361: ln_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;
1362:
1363: BEGIN
1364: --logging for debug
1365: IF (ln_proc_level >= ln_dbg_level)

Line 1367: FND_LOG.STRING( ln_proc_level

1363: BEGIN
1364: --logging for debug
1365: IF (ln_proc_level >= ln_dbg_level)
1366: THEN
1367: FND_LOG.STRING( ln_proc_level
1368: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.begin'
1369: , 'Enter procedure'
1370: );
1371: END IF; --l_proc_level>=l_dbg_level

Line 1498: FND_LOG.STRING( ln_proc_level

1494:
1495: --logging for debug
1496: IF (ln_proc_level >= ln_dbg_level)
1497: THEN
1498: FND_LOG.STRING( ln_proc_level
1499: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.end'
1500: , 'Exit procedure'
1501: );
1502: END IF; -- (ln_proc_level>=ln_dbg_level)

Line 1509: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

1505:
1506: EXCEPTION
1507: WHEN OTHERS
1508: THEN
1509: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1510: THEN
1511: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
1512: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.Other_Exception '
1513: , Sqlcode||Sqlerrm);

Line 1511: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED

1507: WHEN OTHERS
1508: THEN
1509: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1510: THEN
1511: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
1512: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.Other_Exception '
1513: , Sqlcode||Sqlerrm);
1514: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1515: RAISE;

Line 1514: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

1510: THEN
1511: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
1512: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.Other_Exception '
1513: , Sqlcode||Sqlerrm);
1514: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1515: RAISE;
1516: END Get_Poreq_Tax;
1517:
1518: