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

Line 134: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

130: ,pv_remittance_bill_number IN VARCHAR2
131: )
132: IS
133: lv_procedure_name VARCHAR2(40) := 'Add_XML_Node';
134: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
135: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
136:
137: BEGIN
138: --logging for debug

Line 135: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;

131: )
132: IS
133: lv_procedure_name VARCHAR2(40) := 'Add_XML_Node';
134: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
135: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
136:
137: BEGIN
138: --logging for debug
139: IF (ln_proc_level >= ln_dbg_level)

Line 141: FND_LOG.STRING(ln_proc_level,

137: BEGIN
138: --logging for debug
139: IF (ln_proc_level >= ln_dbg_level)
140: THEN
141: FND_LOG.STRING(ln_proc_level,
142: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
143: '.begin',
144: 'Enter procedure');
145: END IF; --ln_proc_level>=ln_dbg_level

Line 308: FND_LOG.STRING(ln_proc_level,

304:
305: --logging for debug
306: IF (ln_proc_level >= ln_dbg_level)
307: THEN
308: FND_LOG.STRING(ln_proc_level,
309: GV_MODULE_PREFIX || '.' || lv_procedure_name || '.end',
310: 'Exit procedure');
311: END IF; -- (ln_proc_level>=ln_dbg_level)
312:

Line 399: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

395: ,pv_remittance_bill_number IN VARCHAR2
396: )
397: IS
398: lv_procedure_name VARCHAR2(40) := 'Add_XML_Node';
399: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
400: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
401:
402: BEGIN
403: --logging for debug

Line 400: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;

396: )
397: IS
398: lv_procedure_name VARCHAR2(40) := 'Add_XML_Node';
399: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
400: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
401:
402: BEGIN
403: --logging for debug
404: IF (ln_proc_level >= ln_dbg_level)

Line 406: FND_LOG.STRING(ln_proc_level,

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

Line 573: FND_LOG.STRING(ln_proc_level,

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

Line 616: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

612: ,pn_customer_trx_id IN NUMBER
613: ) RETURN VARCHAR2
614: IS
615: lv_procedure_name VARCHAR2(40) := 'Get_Transaction_Clear_Flag';
616: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
617: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
618:
619: ln_trx_entered_amount NUMBER := 0;
620: ln_trx_functional_amount NUMBER := 0;

Line 617: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;

613: ) RETURN VARCHAR2
614: IS
615: lv_procedure_name VARCHAR2(40) := 'Get_Transaction_Clear_Flag';
616: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
617: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
618:
619: ln_trx_entered_amount NUMBER := 0;
620: ln_trx_functional_amount NUMBER := 0;
621: ln_trx_e_amount_applied NUMBER := -1;

Line 811: FND_LOG.STRING(ln_proc_level,

807: BEGIN
808: --logging for debug
809: IF (ln_proc_level >= ln_dbg_level)
810: THEN
811: FND_LOG.STRING(ln_proc_level,
812: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
813: '.begin',
814: 'Enter procedure');
815: END IF; --ln_proc_level>=ln_dbg_level

Line 845: FND_LOG.STRING(ln_proc_level,

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

Line 884: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

880: ,pv_attribute_column4bal_side IN VARCHAR2
881: ) RETURN VARCHAR2
882: IS
883: lv_procedure_name VARCHAR2(40) := 'Get_Account_Balance_Side';
884: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
885: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
886:
887: lv_balance_side_code FND_LOOKUP_VALUES.LOOKUP_CODE%TYPE;
888: lv_balance_side_meaning FND_LOOKUP_VALUES.MEANING%TYPE;

Line 885: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;

881: ) RETURN VARCHAR2
882: IS
883: lv_procedure_name VARCHAR2(40) := 'Get_Account_Balance_Side';
884: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
885: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
886:
887: lv_balance_side_code FND_LOOKUP_VALUES.LOOKUP_CODE%TYPE;
888: lv_balance_side_meaning FND_LOOKUP_VALUES.MEANING%TYPE;
889:

Line 921: FND_LOG.STRING(ln_proc_level,

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

Line 961: FND_LOG.STRING(ln_proc_level,

957:
958: --logging for debug
959: IF (ln_proc_level >= ln_dbg_level)
960: THEN
961: FND_LOG.STRING(ln_proc_level,
962: GV_MODULE_PREFIX || '.' || lv_procedure_name || '.end',
963: 'Exit procedure');
964: END IF; -- (ln_proc_level>=ln_dbg_level)
965:

Line 999: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

995: ,pv_period_name IN VARCHAR2
996: ) RETURN VARCHAR2
997: IS
998: lv_procedure_name VARCHAR2(40) := 'Get_VAT_Invoice_Number';
999: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1000: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
1001:
1002: lv_vat_invoice_number AR_GTA_TRX_HEADERS_ALL.Gt_Invoice_Number%TYPE;
1003:

Line 1000: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;

996: ) RETURN VARCHAR2
997: IS
998: lv_procedure_name VARCHAR2(40) := 'Get_VAT_Invoice_Number';
999: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1000: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
1001:
1002: lv_vat_invoice_number AR_GTA_TRX_HEADERS_ALL.Gt_Invoice_Number%TYPE;
1003:
1004: --Cursor for getting VAT invoice number from Golden Tax Invoice for transaction

Line 1017: FND_LOG.STRING(ln_proc_level,

1013: BEGIN
1014: --logging for debug
1015: IF (ln_proc_level >= ln_dbg_level)
1016: THEN
1017: FND_LOG.STRING(ln_proc_level,
1018: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
1019: '.begin',
1020: 'Enter procedure');
1021: END IF; --ln_proc_level>=ln_dbg_level

Line 1039: FND_LOG.STRING(ln_proc_level,

1035:
1036: --logging for debug
1037: IF (ln_proc_level >= ln_dbg_level)
1038: THEN
1039: FND_LOG.STRING(ln_proc_level,
1040: GV_MODULE_PREFIX || '.' || lv_procedure_name || '.end',
1041: 'Exit procedure');
1042: END IF; -- (ln_proc_level>=ln_dbg_level)
1043:

Line 1079: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1075: lv_cursor_sql VARCHAR(200);
1076: TYPE ref_cursor is REF CURSOR;
1077: v_bill_num_row ref_cursor;
1078: lv_procedure_name VARCHAR2(40) := 'Get_Remittance_Bill_Number';
1079: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1080: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
1081:
1082: --Cursor for getting the Attribute Column for storing Remittance Bill Number
1083: CURSOR dff_assignments_cur

Line 1080: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;

1076: TYPE ref_cursor is REF CURSOR;
1077: v_bill_num_row ref_cursor;
1078: lv_procedure_name VARCHAR2(40) := 'Get_Remittance_Bill_Number';
1079: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1080: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
1081:
1082: --Cursor for getting the Attribute Column for storing Remittance Bill Number
1083: CURSOR dff_assignments_cur
1084: IS

Line 1095: FND_LOG.STRING(ln_proc_level,

1091: BEGIN
1092: --logging for debug
1093: IF (ln_proc_level >= ln_dbg_level)
1094: THEN
1095: FND_LOG.STRING(ln_proc_level,
1096: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
1097: '.begin',
1098: 'Enter procedure');
1099: END IF; --ln_proc_level>=ln_dbg_level

Line 1123: FND_LOG.STRING(ln_proc_level,

1119:
1120: --logging for debug
1121: IF (ln_proc_level >= ln_dbg_level)
1122: THEN
1123: FND_LOG.STRING(ln_proc_level,
1124: GV_MODULE_PREFIX || '.' || lv_procedure_name || '.end',
1125: 'Exit procedure');
1126: END IF; -- (ln_proc_level>=ln_dbg_level)
1127:

Line 1169: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1165: ) RETURN NUMBER
1166: IS
1167: ln_balance NUMBER := NULL;
1168: lv_procedure_name VARCHAR2(40) := 'Get_Balance';
1169: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1170: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
1171:
1172: --Cursor for getting 'Functional Balance', 'Entered Balance' from
1173: --Account Balance Itemization table ja_cn_account_balances

Line 1170: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;

1166: IS
1167: ln_balance NUMBER := NULL;
1168: lv_procedure_name VARCHAR2(40) := 'Get_Balance';
1169: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1170: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
1171:
1172: --Cursor for getting 'Functional Balance', 'Entered Balance' from
1173: --Account Balance Itemization table ja_cn_account_balances
1174: CURSOR account_balance_cur

Line 1190: FND_LOG.STRING(ln_proc_level,

1186: BEGIN
1187: --logging for debug
1188: IF (ln_proc_level >= ln_dbg_level)
1189: THEN
1190: FND_LOG.STRING(ln_proc_level,
1191: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
1192: '.begin',
1193: 'Enter procedure');
1194: END IF; --ln_proc_level>=ln_dbg_level

Line 1212: FND_LOG.STRING(ln_proc_level,

1208:
1209: --logging for debug
1210: IF (ln_proc_level >= ln_dbg_level)
1211: THEN
1212: FND_LOG.STRING(ln_proc_level,
1213: GV_MODULE_PREFIX || '.' || lv_procedure_name || '.end',
1214: 'Exit procedure');
1215: END IF; -- (ln_proc_level>=ln_dbg_level)
1216:

Line 1250: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1246: ,xa_receivable_account_num OUT NOCOPY ACCOUNT_NUMBER_TBL
1247: )
1248: IS
1249: lv_procedure_name VARCHAR2(40) := 'Get_Account_Number';
1250: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1251: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
1252: la_receivable_account_num ACCOUNT_NUMBER_TBL := ACCOUNT_NUMBER_TBL();
1253: ln_account_num_count NUMBER := 0;
1254:

Line 1251: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;

1247: )
1248: IS
1249: lv_procedure_name VARCHAR2(40) := 'Get_Account_Number';
1250: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1251: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
1252: la_receivable_account_num ACCOUNT_NUMBER_TBL := ACCOUNT_NUMBER_TBL();
1253: ln_account_num_count NUMBER := 0;
1254:
1255: --getting account number

Line 1289: FND_LOG.STRING(ln_proc_level,

1285: BEGIN
1286: --logging for debug
1287: IF (ln_proc_level >= ln_dbg_level)
1288: THEN
1289: FND_LOG.STRING(ln_proc_level,
1290: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
1291: '.begin',
1292: 'Enter procedure');
1293: END IF; --ln_proc_level>=ln_dbg_level

Line 1307: FND_LOG.STRING(ln_proc_level,

1303:
1304: --logging for debug
1305: IF (ln_proc_level >= ln_dbg_level)
1306: THEN
1307: FND_LOG.STRING(ln_proc_level,
1308: GV_MODULE_PREFIX || '.' || lv_procedure_name || '.end',
1309: 'Exit procedure');
1310: END IF; -- (ln_proc_level>=ln_dbg_level)
1311:

Line 1338: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1334: RETURN VARCHAR2
1335: IS
1336: lv_customer_num VARCHAR(30) := NULL;
1337: lv_procedure_name VARCHAR2(40) := 'Get_Customer_Number';
1338: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1339: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
1340:
1341: CURSOR customer_num_cur
1342: IS

Line 1339: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;

1335: IS
1336: lv_customer_num VARCHAR(30) := NULL;
1337: lv_procedure_name VARCHAR2(40) := 'Get_Customer_Number';
1338: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1339: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
1340:
1341: CURSOR customer_num_cur
1342: IS
1343: SELECT cust.Account_Number Customer_Number

Line 1351: FND_LOG.STRING(ln_proc_level,

1347: BEGIN
1348: --logging for debug
1349: IF (ln_proc_level >= ln_dbg_level)
1350: THEN
1351: FND_LOG.STRING(ln_proc_level,
1352: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
1353: '.begin',
1354: 'Enter procedure');
1355: END IF; --ln_proc_level>=ln_dbg_level

Line 1366: FND_LOG.STRING(ln_proc_level,

1362:
1363: --logging for debug
1364: IF (ln_proc_level >= ln_dbg_level)
1365: THEN
1366: FND_LOG.STRING(ln_proc_level,
1367: GV_MODULE_PREFIX || '.' || lv_procedure_name || '.end',
1368: 'Exit procedure');
1369: END IF; -- (ln_proc_level>=ln_dbg_level)
1370:

Line 1410: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1406: )
1407: RETURN VARCHAR2
1408: IS
1409: lv_procedure_name VARCHAR2(40) := 'Add_Year_Beginning_Balance';
1410: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1411: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
1412: ln_account_num_count NUMBER := 0;
1413: lv_fun_currency VARCHAR2(100);
1414: lv_beginning_bal_exported_flag VARCHAR2(1) := 'N';

Line 1411: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;

1407: RETURN VARCHAR2
1408: IS
1409: lv_procedure_name VARCHAR2(40) := 'Add_Year_Beginning_Balance';
1410: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1411: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
1412: ln_account_num_count NUMBER := 0;
1413: lv_fun_currency VARCHAR2(100);
1414: lv_beginning_bal_exported_flag VARCHAR2(1) := 'N';
1415: lv_balance_desc VARCHAR2(200);

Line 1511: FND_LOG.STRING(ln_proc_level,

1507: BEGIN
1508: --logging for debug
1509: IF (ln_proc_level >= ln_dbg_level)
1510: THEN
1511: FND_LOG.STRING(ln_proc_level,
1512: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
1513: '.begin',
1514: 'Enter procedure');
1515: END IF; --ln_proc_level>=ln_dbg_level

Line 1592: FND_LOG.STRING(ln_proc_level,

1588:
1589: --logging for debug
1590: IF (ln_proc_level >= ln_dbg_level)
1591: THEN
1592: FND_LOG.STRING(ln_proc_level,
1593: GV_MODULE_PREFIX || '.' || lv_procedure_name || '.end',
1594: 'Exit procedure');
1595: END IF; -- (ln_proc_level>=ln_dbg_level)
1596:

Line 1648: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1644: ,pv_period_to IN VARCHAR2
1645: )
1646: IS
1647: lv_procedure_name VARCHAR2(40) := 'Add_Receivables_Balance_Detail';
1648: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1649: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
1650: ln_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;
1651: NO_DATA EXCEPTION;
1652:

Line 1649: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;

1645: )
1646: IS
1647: lv_procedure_name VARCHAR2(40) := 'Add_Receivables_Balance_Detail';
1648: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1649: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
1650: ln_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;
1651: NO_DATA EXCEPTION;
1652:
1653: ln_row_count NUMBER := 0;

Line 1650: ln_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;

1646: IS
1647: lv_procedure_name VARCHAR2(40) := 'Add_Receivables_Balance_Detail';
1648: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1649: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
1650: ln_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;
1651: NO_DATA EXCEPTION;
1652:
1653: ln_row_count NUMBER := 0;
1654: ld_start_date DATE;

Line 2400: FND_LOG.STRING(ln_proc_level,

2396: BEGIN
2397: --logging for debug
2398: IF (ln_proc_level >= ln_dbg_level)
2399: THEN
2400: FND_LOG.STRING(ln_proc_level,
2401: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
2402: '.begin',
2403: 'Enter procedure');
2404: -- logging the parameters

Line 2405: FND_LOG.STRING(ln_proc_level,

2401: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
2402: '.begin',
2403: 'Enter procedure');
2404: -- logging the parameters
2405: FND_LOG.STRING(ln_proc_level,
2406: lv_procedure_name ||
2407: '.parameters',
2408: 'pn_legal_entity_id=' || pn_legal_entity_id || ',' ||
2409: 'pn_ledger_id=' || pn_ledger_id || ',' ||

Line 2518: FND_LOG.STRING(ln_statement_level,

2514:
2515: --logging the variables
2516: IF (ln_statement_level >= ln_dbg_level)
2517: THEN
2518: FND_LOG.STRING(ln_statement_level,
2519: lv_procedure_name,
2520: 'ld_start_date=' || ld_start_date || ',' ||
2521: 'ld_end_date=' || ld_end_date);
2522: END IF; --(ln_statement_level >= ln_dbg_level)

Line 2547: FND_LOG.STRING(ln_statement_level,

2543:
2544: --logging the variables
2545: IF (ln_statement_level >= ln_dbg_level)
2546: THEN
2547: FND_LOG.STRING(ln_statement_level,
2548: lv_procedure_name,
2549: 'ln_flex_value_set_id=' || ln_flex_value_set_id);
2550: END IF; --(ln_statement_level >= ln_dbg_level)
2551: /*FND_FILE.put_line(FND_FILE.log, lv_procedure_name ||

Line 2567: FND_LOG.STRING(ln_statement_level,

2563:
2564: --logging the variables
2565: IF (ln_statement_level >= ln_dbg_level)
2566: THEN
2567: FND_LOG.STRING(ln_statement_level,
2568: lv_procedure_name,
2569: 'lv_functional_currency=' || lv_functional_currency);
2570: END IF; --(ln_statement_level >= ln_dbg_level)
2571: /*FND_FILE.put_line(FND_FILE.log, lv_procedure_name ||

Line 2593: FND_LOG.STRING(ln_statement_level,

2589:
2590: --logging the variables
2591: IF (ln_statement_level >= ln_dbg_level)
2592: THEN
2593: FND_LOG.STRING(ln_statement_level,
2594: lv_procedure_name,
2595: 'lv_attribute_column4bal_side=' || lv_attribute_column4bal_side || ',' ||
2596: 'lv_attribute_column4bill_num=' || lv_attribute_column4bill_num);
2597: END IF; --(ln_statement_level >= ln_dbg_level)

Line 2612: FND_LOG.STRING(ln_statement_level,

2608:
2609: --logging the variables
2610: IF (ln_statement_level >= ln_dbg_level)
2611: THEN
2612: FND_LOG.STRING(ln_statement_level,
2613: lv_procedure_name,
2614: 'lv_contract_number_column=' || lv_contract_number_column);
2615: END IF; --(ln_statement_level >= ln_dbg_level)
2616: /*FND_FILE.put_line(FND_FILE.log, lv_procedure_name ||

Line 3197: FND_LOG.STRING(ln_proc_level,

3193:
3194: --logging for debug
3195: IF (ln_proc_level >= ln_dbg_level)
3196: THEN
3197: FND_LOG.STRING(ln_proc_level,
3198: GV_MODULE_PREFIX || '.' || lv_procedure_name || '.end',
3199: 'Exit procedure');
3200: END IF; -- (ln_proc_level>=ln_dbg_level)
3201:

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

3201:
3202: --To handle the No Data Found Exception
3203: EXCEPTION
3204: WHEN OTHERS THEN
3205: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3206: THEN
3207: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
3208: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
3209: '.Other_Exception ',

Line 3207: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,

3203: EXCEPTION
3204: WHEN OTHERS THEN
3205: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3206: THEN
3207: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
3208: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
3209: '.Other_Exception ',
3210: SQLCODE || SQLERRM);
3211: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

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

3207: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
3208: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
3209: '.Other_Exception ',
3210: SQLCODE || SQLERRM);
3211: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3212: FND_FILE.put_line(FND_FILE.log, lv_procedure_name || SQLCODE || SQLERRM);
3213: RAISE;
3214:
3215: END Add_Receivables_Balance_Detail;