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

Line 146: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

142: pv_payment_date IN VARCHAR2,
143: pv_clear_flag IN VARCHAR2,
144: pv_remittance_bill_number IN VARCHAR2) IS
145: lv_procedure_name VARCHAR2(40) := 'Add_XML_Node';
146: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
147: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
148:
149: BEGIN
150: --logging for debug

Line 147: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;

143: pv_clear_flag IN VARCHAR2,
144: pv_remittance_bill_number IN VARCHAR2) IS
145: lv_procedure_name VARCHAR2(40) := 'Add_XML_Node';
146: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
147: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
148:
149: BEGIN
150: --logging for debug
151: IF (ln_proc_level >= ln_dbg_level) THEN

Line 152: FND_LOG.STRING(ln_proc_level,

148:
149: BEGIN
150: --logging for debug
151: IF (ln_proc_level >= ln_dbg_level) THEN
152: FND_LOG.STRING(ln_proc_level,
153: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
154: '.begin',
155: 'Enter procedure');
156: END IF; --ln_proc_level>=ln_dbg_level

Line 316: FND_LOG.STRING(ln_proc_level,

312: Ja_Cn_Utility.GV_TAG_TYPE_END,
313: Ja_Cn_Utility.GV_MODULE_APAR);
314: --logging for debug
315: IF (ln_proc_level >= ln_dbg_level) THEN
316: FND_LOG.STRING(ln_proc_level,
317: GV_MODULE_PREFIX || '.' || lv_procedure_name || '.end',
318: 'Exit procedure');
319: END IF; -- (ln_proc_level>=ln_dbg_level)
320:

Line 402: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

398: pv_payment_date IN VARCHAR2,
399: pv_clear_flag IN VARCHAR2,
400: pv_remittance_bill_number IN VARCHAR2) IS
401: lv_procedure_name VARCHAR2(40) := 'Add_YBB_XML_Node';
402: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
403: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
404:
405: BEGIN
406: --logging for debug

Line 403: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;

399: pv_clear_flag IN VARCHAR2,
400: pv_remittance_bill_number IN VARCHAR2) IS
401: lv_procedure_name VARCHAR2(40) := 'Add_YBB_XML_Node';
402: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
403: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
404:
405: BEGIN
406: --logging for debug
407: IF (ln_proc_level >= ln_dbg_level) THEN

Line 408: FND_LOG.STRING(ln_proc_level,

404:
405: BEGIN
406: --logging for debug
407: IF (ln_proc_level >= ln_dbg_level) THEN
408: FND_LOG.STRING(ln_proc_level,
409: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
410: '.begin',
411: 'Enter procedure');
412: END IF; --ln_proc_level>=ln_dbg_level

Line 572: FND_LOG.STRING(ln_proc_level,

568: Ja_Cn_Utility.GV_TAG_TYPE_END,
569: Ja_Cn_Utility.GV_MODULE_APAR);
570: --logging for debug
571: IF (ln_proc_level >= ln_dbg_level) THEN
572: FND_LOG.STRING(ln_proc_level,
573: GV_MODULE_PREFIX || '.' || lv_procedure_name || '.end',
574: 'Exit procedure');
575: END IF; -- (ln_proc_level>=ln_dbg_level)
576:

Line 602: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

598: FUNCTION Get_Supplier_Number(pv_supplier_num IN VARCHAR2,
599: pn_invoice_id IN NUMBER) RETURN VARCHAR2 IS
600: lv_supplier_num VARCHAR(30) := pv_supplier_num;
601: lv_procedure_name VARCHAR2(40) := 'Get_Supplier_Number';
602: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
603: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
604:
605: CURSOR customer_num_cur IS
606: SELECT DISTINCT part.party_number Customer_Number

Line 603: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;

599: pn_invoice_id IN NUMBER) RETURN VARCHAR2 IS
600: lv_supplier_num VARCHAR(30) := pv_supplier_num;
601: lv_procedure_name VARCHAR2(40) := 'Get_Supplier_Number';
602: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
603: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
604:
605: CURSOR customer_num_cur IS
606: SELECT DISTINCT part.party_number Customer_Number
607: FROM HZ_CUST_ACCOUNTS cust, HZ_PARTIES part, AP_INVOICES_ALL aia

Line 615: FND_LOG.STRING(ln_proc_level,

611:
612: BEGIN
613: --logging for debug
614: IF (ln_proc_level >= ln_dbg_level) THEN
615: FND_LOG.STRING(ln_proc_level,
616: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
617: '.begin',
618: 'Enter procedure');
619: END IF; --ln_proc_level>=ln_dbg_level

Line 630: FND_LOG.STRING(ln_proc_level,

626: END IF;
627:
628: --logging for debug
629: IF (ln_proc_level >= ln_dbg_level) THEN
630: FND_LOG.STRING(ln_proc_level,
631: GV_MODULE_PREFIX || '.' || lv_procedure_name || '.end',
632: 'Exit procedure');
633: END IF; -- (ln_proc_level>=ln_dbg_level)
634:

Line 665: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

661: RETURN VARCHAR2 IS
662: lv_period_num VARCHAR(5) := NULL;
663: lv_period_name VARCHAR(25) := pv_period_name;
664: lv_procedure_name VARCHAR2(40) := 'Get_Accounting_Period_Number';
665: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
666: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
667:
668: CURSOR period_num_cur(lv_period_name VARCHAR2) IS
669: SELECT TO_CHAR(Gp.Period_Num)

Line 666: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;

662: lv_period_num VARCHAR(5) := NULL;
663: lv_period_name VARCHAR(25) := pv_period_name;
664: lv_procedure_name VARCHAR2(40) := 'Get_Accounting_Period_Number';
665: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
666: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
667:
668: CURSOR period_num_cur(lv_period_name VARCHAR2) IS
669: SELECT TO_CHAR(Gp.Period_Num)
670: FROM Gl_Periods Gp, Gl_Ledgers Gl

Line 684: FND_LOG.STRING(ln_proc_level,

680:
681: BEGIN
682: --logging for debug
683: IF (ln_proc_level >= ln_dbg_level) THEN
684: FND_LOG.STRING(ln_proc_level,
685: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
686: '.begin',
687: 'Enter procedure');
688: END IF; --ln_proc_level>=ln_dbg_level

Line 704: FND_LOG.STRING(ln_proc_level,

700: CLOSE period_num_cur;
701:
702: --logging for debug
703: IF (ln_proc_level >= ln_dbg_level) THEN
704: FND_LOG.STRING(ln_proc_level,
705: GV_MODULE_PREFIX || '.' || lv_procedure_name || '.end',
706: 'Exit procedure');
707: END IF; -- (ln_proc_level>=ln_dbg_level)
708:

Line 736: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

732: pn_ledger_id IN NUMBER)
733: RETURN VARCHAR2 IS
734: lv_prepaid_account_num VARCHAR(30) := NULL;
735: lv_procedure_name VARCHAR2(40) := 'Get_Prepaid_Account_Number';
736: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
737: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
738:
739: CURSOR prepaid_account_num_cur IS
740: SELECT DISTINCT Jcc.account_segment Prepaid_Account_Num

Line 737: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;

733: RETURN VARCHAR2 IS
734: lv_prepaid_account_num VARCHAR(30) := NULL;
735: lv_procedure_name VARCHAR2(40) := 'Get_Prepaid_Account_Number';
736: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
737: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
738:
739: CURSOR prepaid_account_num_cur IS
740: SELECT DISTINCT Jcc.account_segment Prepaid_Account_Num
741: FROM Ap_Invoices_All Aia,

Line 761: FND_LOG.STRING(ln_proc_level,

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

Line 774: FND_LOG.STRING(ln_proc_level,

770: END LOOP;
771:
772: --logging for debug
773: IF (ln_proc_level >= ln_dbg_level) THEN
774: FND_LOG.STRING(ln_proc_level,
775: GV_MODULE_PREFIX || '.' || lv_procedure_name || '.end',
776: 'Exit procedure');
777: END IF; -- (ln_proc_level>=ln_dbg_level)
778:

Line 807: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

803: pn_legal_entity_id IN NUMBER) --Add a parameter, by Jianchao Chi for V2 Upgrade 06-Jan-2011
804: RETURN VARCHAR2 IS
805: lv_journal_num VARCHAR(20) := NULL;
806: lv_procedure_name VARCHAR2(40) := 'Get_Journal_Number';
807: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
808: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
809:
810: CURSOR journal_num_cur IS
811: --Update by Jianchao Chi, for cnaov2 upgrade 06-JAN-2011

Line 808: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;

804: RETURN VARCHAR2 IS
805: lv_journal_num VARCHAR(20) := NULL;
806: lv_procedure_name VARCHAR2(40) := 'Get_Journal_Number';
807: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
808: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
809:
810: CURSOR journal_num_cur IS
811: --Update by Jianchao Chi, for cnaov2 upgrade 06-JAN-2011
812: --Add ja_cn_voucher_number table, voucher number and legal entity

Line 829: FND_LOG.STRING(ln_proc_level,

825:
826: BEGIN
827: --logging for debug
828: IF (ln_proc_level >= ln_dbg_level) THEN
829: FND_LOG.STRING(ln_proc_level,
830: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
831: '.begin',
832: 'Enter procedure');
833: END IF; --ln_proc_level>=ln_dbg_level

Line 842: FND_LOG.STRING(ln_proc_level,

838: END LOOP;
839:
840: --logging for debug
841: IF (ln_proc_level >= ln_dbg_level) THEN
842: FND_LOG.STRING(ln_proc_level,
843: GV_MODULE_PREFIX || '.' || lv_procedure_name || '.end',
844: 'Exit procedure');
845: END IF; -- (ln_proc_level>=ln_dbg_level)
846:

Line 880: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

876: pn_legal_entity_id IN NUMBER,
877: pv_amount_type IN VARCHAR2) RETURN NUMBER IS
878: ln_amount NUMBER := NULL;
879: lv_procedure_name VARCHAR2(40) := 'Get_Liability_Amount';
880: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
881: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
882:
883: --Cursor for fetching invoice amount or payment amount at SLA level
884: CURSOR amount_cur IS

Line 881: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;

877: pv_amount_type IN VARCHAR2) RETURN NUMBER IS
878: ln_amount NUMBER := NULL;
879: lv_procedure_name VARCHAR2(40) := 'Get_Liability_Amount';
880: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
881: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
882:
883: --Cursor for fetching invoice amount or payment amount at SLA level
884: CURSOR amount_cur IS
885: SELECT SUM(-1 * NVL(Ael.Accounted_Dr, 0) + NVL(Ael.Accounted_Cr, 0)) Functional_Amount,

Line 925: FND_LOG.STRING(ln_proc_level,

921:
922: BEGIN
923: --logging for debug
924: IF (ln_proc_level >= ln_dbg_level) THEN
925: FND_LOG.STRING(ln_proc_level,
926: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
927: '.begin',
928: 'Enter procedure');
929: END IF; --ln_proc_level>=ln_dbg_level

Line 942: FND_LOG.STRING(ln_proc_level,

938: END LOOP;
939:
940: --logging for debug
941: IF (ln_proc_level >= ln_dbg_level) THEN
942: FND_LOG.STRING(ln_proc_level,
943: GV_MODULE_PREFIX || '.' || lv_procedure_name || '.end',
944: 'Exit procedure');
945: END IF; -- (ln_proc_level>=ln_dbg_level)
946:

Line 976: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

972: pv_amount_type IN VARCHAR2)
973: RETURN NUMBER IS
974: ln_amount NUMBER := NULL;
975: lv_procedure_name VARCHAR2(40) := 'Get_Payment_Liability_Amount';
976: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
977: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
978:
979: --Cursor for fetching invoice amount or payment amount at SLA level
980: CURSOR amount_cur IS

Line 977: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;

973: RETURN NUMBER IS
974: ln_amount NUMBER := NULL;
975: lv_procedure_name VARCHAR2(40) := 'Get_Payment_Liability_Amount';
976: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
977: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
978:
979: --Cursor for fetching invoice amount or payment amount at SLA level
980: CURSOR amount_cur IS
981: SELECT -1 * NVL(Aip.Amount, 0) Entered_Amount,

Line 989: FND_LOG.STRING(ln_proc_level,

985:
986: BEGIN
987: --logging for debug
988: IF (ln_proc_level >= ln_dbg_level) THEN
989: FND_LOG.STRING(ln_proc_level,
990: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
991: '.begin',
992: 'Enter procedure');
993: END IF; --ln_proc_level>=ln_dbg_level

Line 1006: FND_LOG.STRING(ln_proc_level,

1002: END LOOP;
1003:
1004: --logging for debug
1005: IF (ln_proc_level >= ln_dbg_level) THEN
1006: FND_LOG.STRING(ln_proc_level,
1007: GV_MODULE_PREFIX || '.' || lv_procedure_name || '.end',
1008: 'Exit procedure');
1009: END IF; -- (ln_proc_level>=ln_dbg_level)
1010:

Line 1044: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1040: pv_account_num IN VARCHAR2,
1041: pv_amount_type IN VARCHAR2) RETURN NUMBER IS
1042: ln_amount NUMBER := NULL;
1043: lv_procedure_name VARCHAR2(40) := 'Get_Prepaid_Amount';
1044: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1045: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
1046:
1047: --Cursor for fetching invoice amount or payment amount at SLA level
1048: CURSOR amount_cur IS

Line 1045: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;

1041: pv_amount_type IN VARCHAR2) RETURN NUMBER IS
1042: ln_amount NUMBER := NULL;
1043: lv_procedure_name VARCHAR2(40) := 'Get_Prepaid_Amount';
1044: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1045: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
1046:
1047: --Cursor for fetching invoice amount or payment amount at SLA level
1048: CURSOR amount_cur IS
1049: SELECT SUM(NVL(Ael.Accounted_Dr, 0) + -1 * NVL(Ael.Accounted_Cr, 0)) Functional_Amount,

Line 1072: FND_LOG.STRING(ln_proc_level,

1068:
1069: BEGIN
1070: --logging for debug
1071: IF (ln_proc_level >= ln_dbg_level) THEN
1072: FND_LOG.STRING(ln_proc_level,
1073: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
1074: '.begin',
1075: 'Enter procedure');
1076: END IF; --ln_proc_level>=ln_dbg_level

Line 1089: FND_LOG.STRING(ln_proc_level,

1085: END LOOP;
1086:
1087: --logging for debug
1088: IF (ln_proc_level >= ln_dbg_level) THEN
1089: FND_LOG.STRING(ln_proc_level,
1090: GV_MODULE_PREFIX || '.' || lv_procedure_name || '.end',
1091: 'Exit procedure');
1092: END IF; -- (ln_proc_level>=ln_dbg_level)
1093:

Line 1133: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1129: pv_balance_type IN VARCHAR2)
1130: RETURN NUMBER IS
1131: ln_balance NUMBER := NULL;
1132: lv_procedure_name VARCHAR2(40) := 'Get_Liability_Balance';
1133: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1134: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
1135:
1136: --Cursor for fetching balance at itemization level
1137: CURSOR balance_cur IS

Line 1134: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;

1130: RETURN NUMBER IS
1131: ln_balance NUMBER := NULL;
1132: lv_procedure_name VARCHAR2(40) := 'Get_Liability_Balance';
1133: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1134: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
1135:
1136: --Cursor for fetching balance at itemization level
1137: CURSOR balance_cur IS
1138: SELECT SUM(func_end_balance) Functional_Balance,

Line 1151: FND_LOG.STRING(ln_proc_level,

1147:
1148: BEGIN
1149: --logging for debug
1150: IF (ln_proc_level >= ln_dbg_level) THEN
1151: FND_LOG.STRING(ln_proc_level,
1152: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
1153: '.begin',
1154: 'Enter procedure');
1155: END IF; --ln_proc_level>=ln_dbg_level

Line 1168: FND_LOG.STRING(ln_proc_level,

1164: END LOOP;
1165:
1166: --logging for debug
1167: IF (ln_proc_level >= ln_dbg_level) THEN
1168: FND_LOG.STRING(ln_proc_level,
1169: GV_MODULE_PREFIX || '.' || lv_procedure_name || '.end',
1170: 'Exit procedure');
1171: END IF; -- (ln_proc_level>=ln_dbg_level)
1172:

Line 1211: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1207: pv_period_name IN VARCHAR2,
1208: pv_balance_type IN VARCHAR2) RETURN NUMBER IS
1209: ln_balance NUMBER := NULL;
1210: lv_procedure_name VARCHAR2(40) := 'Get_Prepaid_Balance';
1211: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1212: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
1213:
1214: --Cursor for fetching balance at itemization level
1215: CURSOR balance_cur IS

Line 1212: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;

1208: pv_balance_type IN VARCHAR2) RETURN NUMBER IS
1209: ln_balance NUMBER := NULL;
1210: lv_procedure_name VARCHAR2(40) := 'Get_Prepaid_Balance';
1211: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1212: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
1213:
1214: --Cursor for fetching balance at itemization level
1215: CURSOR balance_cur IS
1216: SELECT SUM(NVL(jcab.func_period_net_dr, 0) +

Line 1231: FND_LOG.STRING(ln_proc_level,

1227:
1228: BEGIN
1229: --logging for debug
1230: IF (ln_proc_level >= ln_dbg_level) THEN
1231: FND_LOG.STRING(ln_proc_level,
1232: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
1233: '.begin',
1234: 'Enter procedure');
1235: END IF; --ln_proc_level>=ln_dbg_level

Line 1248: FND_LOG.STRING(ln_proc_level,

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

Line 1284: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1280: lv_credit VARCHAR2(25);
1281: lv_balance_side VARCHAR2(25);
1282: lv_attribute_column4bal_side ja_cn_dff_assignments.attribute_column%TYPE;
1283: lv_procedure_name VARCHAR2(40) := 'Get_Balance_Side';
1284: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1285: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
1286:
1287: CURSOR balance_side_cur(ln_flex_value_set_id NUMBER,
1288: lv_attribute_column4bal_side VARCHAR2) IS

Line 1285: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;

1281: lv_balance_side VARCHAR2(25);
1282: lv_attribute_column4bal_side ja_cn_dff_assignments.attribute_column%TYPE;
1283: lv_procedure_name VARCHAR2(40) := 'Get_Balance_Side';
1284: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1285: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
1286:
1287: CURSOR balance_side_cur(ln_flex_value_set_id NUMBER,
1288: lv_attribute_column4bal_side VARCHAR2) IS
1289: SELECT SUBSTR(TO_CHAR(COMPILED_VALUE_ATTRIBUTES), 5, 1) Account_Type,

Line 1409: FND_LOG.STRING(ln_proc_level,

1405:
1406: BEGIN
1407: --logging for debug
1408: IF (ln_proc_level >= ln_dbg_level) THEN
1409: FND_LOG.STRING(ln_proc_level,
1410: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
1411: '.begin',
1412: 'Enter procedure');
1413: END IF; --ln_proc_level>=ln_dbg_level

Line 1472: FND_LOG.STRING(ln_proc_level,

1468: END LOOP; --end balance_side_cur
1469:
1470: --logging for debug
1471: IF (ln_proc_level >= ln_dbg_level) THEN
1472: FND_LOG.STRING(ln_proc_level,
1473: GV_MODULE_PREFIX || '.' || lv_procedure_name || '.end',
1474: 'Exit procedure');
1475: END IF; -- (ln_proc_level>=ln_dbg_level)
1476:

Line 1510: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1506: lv_cursor_sql VARCHAR(200);
1507: TYPE ref_cursor is REF CURSOR;
1508: v_bill_num_row ref_cursor;
1509: lv_procedure_name VARCHAR2(40) := 'Get_Remittance_Bill_Number';
1510: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1511: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
1512:
1513: --Cursor for getting the Attribute Column for storing Remittance Bill Number
1514: CURSOR dff_assignments_cur IS

Line 1511: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;

1507: TYPE ref_cursor is REF CURSOR;
1508: v_bill_num_row ref_cursor;
1509: lv_procedure_name VARCHAR2(40) := 'Get_Remittance_Bill_Number';
1510: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1511: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
1512:
1513: --Cursor for getting the Attribute Column for storing Remittance Bill Number
1514: CURSOR dff_assignments_cur IS
1515: SELECT attribute_column, context_code

Line 1523: FND_LOG.STRING(ln_proc_level,

1519:
1520: BEGIN
1521: --logging for debug
1522: IF (ln_proc_level >= ln_dbg_level) THEN
1523: FND_LOG.STRING(ln_proc_level,
1524: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
1525: '.begin',
1526: 'Enter procedure');
1527: END IF; --ln_proc_level>=ln_dbg_level

Line 1550: FND_LOG.STRING(ln_proc_level,

1546: END IF;
1547:
1548: --logging for debug
1549: IF (ln_proc_level >= ln_dbg_level) THEN
1550: FND_LOG.STRING(ln_proc_level,
1551: GV_MODULE_PREFIX || '.' || lv_procedure_name || '.end',
1552: 'Exit procedure');
1553: END IF; -- (ln_proc_level>=ln_dbg_level)
1554:

Line 1581: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1577: FUNCTION Get_Due_Date(pn_invoice_id IN NUMBER,
1578: pn_inovice_payment_id IN NUMBER) RETURN VARCHAR2 IS
1579: lv_due_date VARCHAR(10) := NULL;
1580: lv_procedure_name VARCHAR2(40) := 'Get_Due_Date';
1581: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1582: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
1583:
1584: CURSOR due_date_cur IS
1585: SELECT TO_CHAR(apsa.Due_Date, 'YYYYMMDD') Due_Date

Line 1582: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;

1578: pn_inovice_payment_id IN NUMBER) RETURN VARCHAR2 IS
1579: lv_due_date VARCHAR(10) := NULL;
1580: lv_procedure_name VARCHAR2(40) := 'Get_Due_Date';
1581: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1582: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
1583:
1584: CURSOR due_date_cur IS
1585: SELECT TO_CHAR(apsa.Due_Date, 'YYYYMMDD') Due_Date
1586: FROM Ap_Payment_Schedules_All apsa

Line 1602: FND_LOG.STRING(ln_proc_level,

1598:
1599: BEGIN
1600: --logging for debug
1601: IF (ln_proc_level >= ln_dbg_level) THEN
1602: FND_LOG.STRING(ln_proc_level,
1603: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
1604: '.begin',
1605: 'Enter procedure');
1606: END IF; --ln_proc_level>=ln_dbg_level

Line 1615: FND_LOG.STRING(ln_proc_level,

1611: END LOOP;
1612:
1613: --logging for debug
1614: IF (ln_proc_level >= ln_dbg_level) THEN
1615: FND_LOG.STRING(ln_proc_level,
1616: GV_MODULE_PREFIX || '.' || lv_procedure_name || '.end',
1617: 'Exit procedure');
1618: END IF; -- (ln_proc_level>=ln_dbg_level)
1619:

Line 1655: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1651: lv_clear_flag VARCHAR(1) := '0';
1652: ln_paid_amount NUMBER;
1653: ln_inv_amount NUMBER;
1654: lv_procedure_name VARCHAR2(40) := 'Get_Liability_Clear_Flag';
1655: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1656: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
1657:
1658: --collecting invoice amount
1659: CURSOR inv_amount_cur IS

Line 1656: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;

1652: ln_paid_amount NUMBER;
1653: ln_inv_amount NUMBER;
1654: lv_procedure_name VARCHAR2(40) := 'Get_Liability_Clear_Flag';
1655: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1656: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
1657:
1658: --collecting invoice amount
1659: CURSOR inv_amount_cur IS
1660: SELECT SUM(-1 * NVL(Ael.Entered_Dr, 0) + NVL(Ael.Entered_Cr, 0)) Inv_Amount

Line 1823: FND_LOG.STRING(ln_proc_level,

1819:
1820: BEGIN
1821: --logging for debug
1822: IF (ln_proc_level >= ln_dbg_level) THEN
1823: FND_LOG.STRING(ln_proc_level,
1824: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
1825: '.begin',
1826: 'Enter procedure');
1827: END IF; --ln_proc_level>=ln_dbg_level

Line 1847: FND_LOG.STRING(ln_proc_level,

1843: END IF;
1844:
1845: --logging for debug
1846: IF (ln_proc_level >= ln_dbg_level) THEN
1847: FND_LOG.STRING(ln_proc_level,
1848: GV_MODULE_PREFIX || '.' || lv_procedure_name || '.end',
1849: 'Exit procedure');
1850: END IF; -- (ln_proc_level>=ln_dbg_level)
1851:

Line 1887: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1883: lv_clear_flag VARCHAR(1) := '0';
1884: ln_prepaid_amount NUMBER;
1885: ln_applied_amount NUMBER;
1886: lv_procedure_name VARCHAR2(40) := 'Get_Prepaid_Clear_Flag';
1887: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1888: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
1889:
1890: --collecting prepayment amount
1891: CURSOR prepaid_amount_cur IS

Line 1888: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;

1884: ln_prepaid_amount NUMBER;
1885: ln_applied_amount NUMBER;
1886: lv_procedure_name VARCHAR2(40) := 'Get_Prepaid_Clear_Flag';
1887: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1888: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
1889:
1890: --collecting prepayment amount
1891: CURSOR prepaid_amount_cur IS
1892: SELECT SUM(NVL(Ael.Entered_Dr, 0) + -1 * NVL(Ael.Entered_Cr, 0)) Prepaid_Amount

Line 1965: FND_LOG.STRING(ln_proc_level,

1961:
1962: BEGIN
1963: --logging for debug
1964: IF (ln_proc_level >= ln_dbg_level) THEN
1965: FND_LOG.STRING(ln_proc_level,
1966: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
1967: '.begin',
1968: 'Enter procedure');
1969: END IF; --ln_proc_level>=ln_dbg_level

Line 1989: FND_LOG.STRING(ln_proc_level,

1985: END IF;
1986:
1987: --logging for debug
1988: IF (ln_proc_level >= ln_dbg_level) THEN
1989: FND_LOG.STRING(ln_proc_level,
1990: GV_MODULE_PREFIX || '.' || lv_procedure_name || '.end',
1991: 'Exit procedure');
1992: END IF; -- (ln_proc_level>=ln_dbg_level)
1993:

Line 2025: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

2021: pv_first_period IN VARCHAR2,
2022: xa_prepaid_account_num OUT NOCOPY ACCOUNT_NUMBER_TBL,
2023: xa_liability_account_num OUT NOCOPY ACCOUNT_NUMBER_TBL) IS
2024: lv_procedure_name VARCHAR2(40) := 'Get_Account_Number';
2025: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2026: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
2027: la_prepaid_acc_num_array ACCOUNT_NUMBER_TBL := ACCOUNT_NUMBER_TBL();
2028: la_liability_acc_num_array ACCOUNT_NUMBER_TBL := ACCOUNT_NUMBER_TBL();
2029: ln_account_num_count NUMBER := 0;

Line 2026: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;

2022: xa_prepaid_account_num OUT NOCOPY ACCOUNT_NUMBER_TBL,
2023: xa_liability_account_num OUT NOCOPY ACCOUNT_NUMBER_TBL) IS
2024: lv_procedure_name VARCHAR2(40) := 'Get_Account_Number';
2025: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2026: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
2027: la_prepaid_acc_num_array ACCOUNT_NUMBER_TBL := ACCOUNT_NUMBER_TBL();
2028: la_liability_acc_num_array ACCOUNT_NUMBER_TBL := ACCOUNT_NUMBER_TBL();
2029: ln_account_num_count NUMBER := 0;
2030:

Line 2065: FND_LOG.STRING(ln_proc_level,

2061:
2062: BEGIN
2063: --logging for debug
2064: IF (ln_proc_level >= ln_dbg_level) THEN
2065: FND_LOG.STRING(ln_proc_level,
2066: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
2067: '.begin',
2068: 'Enter procedure');
2069: END IF; --ln_proc_level>=ln_dbg_level

Line 2090: FND_LOG.STRING(ln_proc_level,

2086: xa_prepaid_account_num := la_prepaid_acc_num_array;
2087:
2088: --logging for debug
2089: IF (ln_proc_level >= ln_dbg_level) THEN
2090: FND_LOG.STRING(ln_proc_level,
2091: GV_MODULE_PREFIX || '.' || lv_procedure_name || '.end',
2092: 'Exit procedure');
2093: END IF; -- (ln_proc_level>=ln_dbg_level)
2094:

Line 2118: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

2114: --==========================================================================
2115: FUNCTION Get_Supplier_Number(pn_supplier_id IN NUMBER) RETURN VARCHAR2 IS
2116: lv_supplier_num VARCHAR(30) := NULL;
2117: lv_procedure_name VARCHAR2(40) := 'Get_Supplier_Number';
2118: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2119: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
2120:
2121: CURSOR supplier_num_cur IS
2122: SELECT part.party_number Supplier_Number

Line 2119: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;

2115: FUNCTION Get_Supplier_Number(pn_supplier_id IN NUMBER) RETURN VARCHAR2 IS
2116: lv_supplier_num VARCHAR(30) := NULL;
2117: lv_procedure_name VARCHAR2(40) := 'Get_Supplier_Number';
2118: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2119: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
2120:
2121: CURSOR supplier_num_cur IS
2122: SELECT part.party_number Supplier_Number
2123: FROM HZ_PARTIES part

Line 2133: FND_LOG.STRING(ln_proc_level,

2129:
2130: BEGIN
2131: --logging for debug
2132: IF (ln_proc_level >= ln_dbg_level) THEN
2133: FND_LOG.STRING(ln_proc_level,
2134: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
2135: '.begin',
2136: 'Enter procedure');
2137: END IF; --ln_proc_level>=ln_dbg_level

Line 2146: FND_LOG.STRING(ln_proc_level,

2142: END LOOP;
2143:
2144: --logging for debug
2145: IF (ln_proc_level >= ln_dbg_level) THEN
2146: FND_LOG.STRING(ln_proc_level,
2147: GV_MODULE_PREFIX || '.' || lv_procedure_name || '.end',
2148: 'Exit procedure');
2149: END IF; -- (ln_proc_level>=ln_dbg_level)
2150:

Line 2189: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

2185: pa_liability_account_num IN ACCOUNT_NUMBER_TBL,
2186: pa_prepaid_account_num IN ACCOUNT_NUMBER_TBL)
2187: RETURN VARCHAR2 IS
2188: lv_procedure_name VARCHAR2(40) := 'Add_Year_Beginning_Balance';
2189: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2190: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
2191: ln_account_num_count NUMBER := 0;
2192: lv_fun_currency VARCHAR2(100);
2193: lv_beginning_bal_exported_flag VARCHAR2(1) := 'N';

Line 2190: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;

2186: pa_prepaid_account_num IN ACCOUNT_NUMBER_TBL)
2187: RETURN VARCHAR2 IS
2188: lv_procedure_name VARCHAR2(40) := 'Add_Year_Beginning_Balance';
2189: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2190: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
2191: ln_account_num_count NUMBER := 0;
2192: lv_fun_currency VARCHAR2(100);
2193: lv_beginning_bal_exported_flag VARCHAR2(1) := 'N';
2194: lv_balance_desc VARCHAR2(200);

Line 2296: FND_LOG.STRING(ln_proc_level,

2292:
2293: BEGIN
2294: --logging for debug
2295: IF (ln_proc_level >= ln_dbg_level) THEN
2296: FND_LOG.STRING(ln_proc_level,
2297: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
2298: '.begin',
2299: 'Enter procedure');
2300: END IF; --ln_proc_level>=ln_dbg_level

Line 2415: FND_LOG.STRING(ln_proc_level,

2411: END LOOP; --Step1: supplier id list
2412:
2413: --logging for debug
2414: IF (ln_proc_level >= ln_dbg_level) THEN
2415: FND_LOG.STRING(ln_proc_level,
2416: GV_MODULE_PREFIX || '.' || lv_procedure_name || '.end',
2417: 'Exit procedure');
2418: END IF; -- (ln_proc_level>=ln_dbg_level)
2419:

Line 2452: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

2448: l_invoice_status varchar2(30);
2449: l_enent_type_code varchar2(50);
2450: l_entered_amount number;
2451: lv_procedure_name VARCHAR2(40) := 'Is_Void_Invoice';
2452: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2453: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
2454: begin
2455: --logging for debug
2456: IF (ln_proc_level >= ln_dbg_level) THEN

Line 2453: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;

2449: l_enent_type_code varchar2(50);
2450: l_entered_amount number;
2451: lv_procedure_name VARCHAR2(40) := 'Is_Void_Invoice';
2452: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2453: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
2454: begin
2455: --logging for debug
2456: IF (ln_proc_level >= ln_dbg_level) THEN
2457: FND_LOG.STRING(ln_proc_level,

Line 2457: FND_LOG.STRING(ln_proc_level,

2453: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
2454: begin
2455: --logging for debug
2456: IF (ln_proc_level >= ln_dbg_level) THEN
2457: FND_LOG.STRING(ln_proc_level,
2458: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
2459: '.begin',
2460: 'Enter procedure');
2461: END IF; --ln_proc_level>=ln_dbg_level

Line 2494: FND_LOG.STRING(ln_proc_level,

2490:
2491: end loop;
2492: --logging for debug
2493: IF (ln_proc_level >= ln_dbg_level) THEN
2494: FND_LOG.STRING(ln_proc_level,
2495: GV_MODULE_PREFIX || '.' || lv_procedure_name || '.end',
2496: 'Exit procedure');
2497: END IF; -- (ln_proc_level>=ln_dbg_level)
2498: return true;

Line 2533: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

2529: l_enent_type_code varchar2(50);
2530: l_entered_amount number;
2531: l_period_name date :=p_period_name;
2532: lv_procedure_name VARCHAR2(40) := 'Is_Void_Invoice';
2533: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2534: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
2535: begin
2536: --logging for debug
2537: IF (ln_proc_level >= ln_dbg_level) THEN

Line 2534: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;

2530: l_entered_amount number;
2531: l_period_name date :=p_period_name;
2532: lv_procedure_name VARCHAR2(40) := 'Is_Void_Invoice';
2533: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2534: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
2535: begin
2536: --logging for debug
2537: IF (ln_proc_level >= ln_dbg_level) THEN
2538: FND_LOG.STRING(ln_proc_level,

Line 2538: FND_LOG.STRING(ln_proc_level,

2534: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
2535: begin
2536: --logging for debug
2537: IF (ln_proc_level >= ln_dbg_level) THEN
2538: FND_LOG.STRING(ln_proc_level,
2539: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
2540: '.begin',
2541: 'Enter procedure');
2542: END IF; --ln_proc_level>=ln_dbg_level

Line 2568: FND_LOG.STRING(ln_proc_level,

2564: end if;
2565: end if;
2566: --logging for debug
2567: IF (ln_proc_level >= ln_dbg_level) THEN
2568: FND_LOG.STRING(ln_proc_level,
2569: GV_MODULE_PREFIX || '.' || lv_procedure_name || '.end',
2570: 'Exit procedure');
2571: END IF; -- (ln_proc_level>=ln_dbg_level)
2572:

Line 2620: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

2616: pv_accounting_year IN VARCHAR2,
2617: pv_period_from IN VARCHAR2,
2618: pv_period_to IN VARCHAR2) IS
2619: lv_procedure_name VARCHAR2(40) := 'Add_Payables_Balance_Detail';
2620: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2621: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
2622: lv_invoice_exported_flag VARCHAR2(1); --indicate whether invoice information has been exported or not
2623: lv_prepay_export_flag VARCHAR(1); --use to indicate whether prepaid line for prepayment should be exported or not
2624: lv_inv_prepay_same_period_flag VARCHAR(1); --use to indicate whether invoice and its prepayment application are in the same period

Line 2621: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;

2617: pv_period_from IN VARCHAR2,
2618: pv_period_to IN VARCHAR2) IS
2619: lv_procedure_name VARCHAR2(40) := 'Add_Payables_Balance_Detail';
2620: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2621: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
2622: lv_invoice_exported_flag VARCHAR2(1); --indicate whether invoice information has been exported or not
2623: lv_prepay_export_flag VARCHAR(1); --use to indicate whether prepaid line for prepayment should be exported or not
2624: lv_inv_prepay_same_period_flag VARCHAR(1); --use to indicate whether invoice and its prepayment application are in the same period
2625: lv_prepaid_account_num VARCHAR(30) := NULL;

Line 3036: FND_LOG.STRING(ln_proc_level,

3032: l_reversal_flag pls_integer :=0 ;
3033: BEGIN
3034: --logging for debug
3035: IF (ln_proc_level >= ln_dbg_level) THEN
3036: FND_LOG.STRING(ln_proc_level,
3037: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
3038: '.begin',
3039: 'Enter procedure');
3040: -- logging the parameters

Line 3041: FND_LOG.STRING(ln_proc_level,

3037: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
3038: '.begin',
3039: 'Enter procedure');
3040: -- logging the parameters
3041: FND_LOG.STRING(ln_proc_level,
3042: lv_procedure_name || '.parameters',
3043: 'pn_legal_entity_id=' || pn_legal_entity_id || ',' ||
3044: 'pn_ledger_id=' || pn_ledger_id || ',' || 'pn_coa_id=' ||
3045: pn_coa_id || ',' || 'pv_accounting_year=' ||

Line 3895: FND_LOG.STRING(ln_proc_level,

3891: END IF; --(ln_row_count = 0)
3892:
3893: --logging for debug
3894: IF (ln_proc_level >= ln_dbg_level) THEN
3895: FND_LOG.STRING(ln_proc_level,
3896: GV_MODULE_PREFIX || '.' || lv_procedure_name || '.end',
3897: 'Exit procedure');
3898: END IF; -- (ln_proc_level>=ln_dbg_level)
3899:

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

3898: END IF; -- (ln_proc_level>=ln_dbg_level)
3899:
3900: EXCEPTION
3901: WHEN OTHERS THEN
3902: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3903: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
3904: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
3905: '.Other_Exception ',
3906: SQLCODE || SQLERRM);

Line 3903: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,

3899:
3900: EXCEPTION
3901: WHEN OTHERS THEN
3902: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3903: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
3904: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
3905: '.Other_Exception ',
3906: SQLCODE || SQLERRM);
3907: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

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

3903: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
3904: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
3905: '.Other_Exception ',
3906: SQLCODE || SQLERRM);
3907: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3908: FND_FILE.put_line(FND_FILE.log,
3909: lv_procedure_name || SQLCODE || SQLERRM);
3910: RAISE;
3911: END Add_Payables_Balance_Detail;