DBA Data[Home] [Help]

APPS.ZX_JE_EXTRACT_PKG dependencies on FND_LOG

Line 24: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;

20: --Public Variable Declarations
21: -----------------------------------------
22: --
23: g_current_runtime_level NUMBER ;
24: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
25: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
26: g_level_event CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
27: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
28: g_error_buffer VARCHAR2(100);

Line 25: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;

21: -----------------------------------------
22: --
23: g_current_runtime_level NUMBER ;
24: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
25: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
26: g_level_event CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
27: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
28: g_error_buffer VARCHAR2(100);
29: -----------------------------------------

Line 26: g_level_event CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;

22: --
23: g_current_runtime_level NUMBER ;
24: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
25: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
26: g_level_event CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
27: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
28: g_error_buffer VARCHAR2(100);
29: -----------------------------------------
30: --Public Methods Declarations

Line 27: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;

23: g_current_runtime_level NUMBER ;
24: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
25: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
26: g_level_event CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
27: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
28: g_error_buffer VARCHAR2(100);
29: -----------------------------------------
30: --Public Methods Declarations
31: -----------------------------------------

Line 134: FND_LOG.STRING(g_level_unexpected,'ZX.TRL.ZX_JE_EXTRACT_PKG.get_emea_rep_code_name',SQLERRM);

130: IF get_lgl_msg%ISOPEN THEN
131: CLOSE get_lgl_msg;
132: END IF;
133: IF ( g_level_unexpected >= g_current_runtime_level) THEN
134: FND_LOG.STRING(g_level_unexpected,'ZX.TRL.ZX_JE_EXTRACT_PKG.get_emea_rep_code_name',SQLERRM);
135: END IF;
136: END;
137:
138: /*===========================================================================+

Line 341: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

337: AND rep_type.reporting_type_code = p_reporting_type ;
338:
339: BEGIN
340:
341: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
342: IF (g_level_statement >= g_current_runtime_level ) THEN
343: FND_LOG.STRING(g_level_statement,
344: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_ar.BEGIN',
345: 'je_tax_extract.populate_je_ar(+)');

Line 343: FND_LOG.STRING(g_level_statement,

339: BEGIN
340:
341: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
342: IF (g_level_statement >= g_current_runtime_level ) THEN
343: FND_LOG.STRING(g_level_statement,
344: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_ar.BEGIN',
345: 'je_tax_extract.populate_je_ar(+)');
346: FND_LOG.STRING(g_level_statement,
347: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_ar',

Line 346: FND_LOG.STRING(g_level_statement,

342: IF (g_level_statement >= g_current_runtime_level ) THEN
343: FND_LOG.STRING(g_level_statement,
344: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_ar.BEGIN',
345: 'je_tax_extract.populate_je_ar(+)');
346: FND_LOG.STRING(g_level_statement,
347: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_ar',
348: 'P_TAX_INVOICE_DATE_HIGH = '||P_TRL_GLOBAL_VARIABLES_REC.TAX_INVOICE_DATE_HIGH);
349: FND_LOG.STRING(g_level_statement,
350: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_ar',

Line 349: FND_LOG.STRING(g_level_statement,

345: 'je_tax_extract.populate_je_ar(+)');
346: FND_LOG.STRING(g_level_statement,
347: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_ar',
348: 'P_TAX_INVOICE_DATE_HIGH = '||P_TRL_GLOBAL_VARIABLES_REC.TAX_INVOICE_DATE_HIGH);
349: FND_LOG.STRING(g_level_statement,
350: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_ar',
351: 'TRX_DATE_HIGH = '||P_TRL_GLOBAL_VARIABLES_REC.TRX_DATE_HIGH);
352: FND_LOG.STRING(g_level_statement,
353: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_ar',

Line 352: FND_LOG.STRING(g_level_statement,

348: 'P_TAX_INVOICE_DATE_HIGH = '||P_TRL_GLOBAL_VARIABLES_REC.TAX_INVOICE_DATE_HIGH);
349: FND_LOG.STRING(g_level_statement,
350: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_ar',
351: 'TRX_DATE_HIGH = '||P_TRL_GLOBAL_VARIABLES_REC.TRX_DATE_HIGH);
352: FND_LOG.STRING(g_level_statement,
353: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_ar',
354: 'GL_DATE_HIGH = '||P_TRL_GLOBAL_VARIABLES_REC.GL_DATE_HIGH);
355: END IF;
356:

Line 392: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JE_EXTRACT.POPULATE_JE_AR',

388: and dtl.EVENT_CLASS_CODE = 'ADJ';
389:
390: EXCEPTION WHEN OTHERS THEN
391: IF ( g_level_statement>= g_current_runtime_level ) THEN
392: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JE_EXTRACT.POPULATE_JE_AR',
393: 'Error in updating tax line id zx_rep_trx_detail_t: Error Message : '||substrb(SQLERRM,1,120) );
394: END IF;
395: END;
396:

Line 500: FND_LOG.STRING(g_level_statement,

496:
497: l_count := nvl(L_DETAIL_TAX_LINE_ID_TBL.COUNT,0);
498:
499: IF (g_level_statement >= g_current_runtime_level ) THEN
500: FND_LOG.STRING(g_level_statement,
501: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_ar.BEGIN',
502: 'l_count : '||l_count);
503: END IF;
504:

Line 597: FND_LOG.STRING(g_level_statement,

593: L_ATTRIBUTE7_TBL(i) := L_ATTRIBUTE7_TMP_TBL(L_TAX_RATE_ID_TBL(i));
594: END IF ;
595:
596: IF (g_level_statement >= g_current_runtime_level ) THEN
597: FND_LOG.STRING(g_level_statement,
598: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_ar.BEGIN',
599: 'Displaying the Vlaues for attributes : i :'||i);
600: FND_LOG.STRING(g_level_statement,
601: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_ar.BEGIN',

Line 600: FND_LOG.STRING(g_level_statement,

596: IF (g_level_statement >= g_current_runtime_level ) THEN
597: FND_LOG.STRING(g_level_statement,
598: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_ar.BEGIN',
599: 'Displaying the Vlaues for attributes : i :'||i);
600: FND_LOG.STRING(g_level_statement,
601: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_ar.BEGIN',
602: 'L_DETAIL_TAX_LINE_ID_TBL(i)'||L_DETAIL_TAX_LINE_ID_TBL(i));
603: FND_LOG.STRING(g_level_statement,
604: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_ar.BEGIN',

Line 603: FND_LOG.STRING(g_level_statement,

599: 'Displaying the Vlaues for attributes : i :'||i);
600: FND_LOG.STRING(g_level_statement,
601: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_ar.BEGIN',
602: 'L_DETAIL_TAX_LINE_ID_TBL(i)'||L_DETAIL_TAX_LINE_ID_TBL(i));
603: FND_LOG.STRING(g_level_statement,
604: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_ar.BEGIN',
605: 'L_ATTRIBUTE1_TBL(i) :'||L_ATTRIBUTE1_TBL(i));
606: FND_LOG.STRING(g_level_statement,
607: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_ar.BEGIN',

Line 606: FND_LOG.STRING(g_level_statement,

602: 'L_DETAIL_TAX_LINE_ID_TBL(i)'||L_DETAIL_TAX_LINE_ID_TBL(i));
603: FND_LOG.STRING(g_level_statement,
604: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_ar.BEGIN',
605: 'L_ATTRIBUTE1_TBL(i) :'||L_ATTRIBUTE1_TBL(i));
606: FND_LOG.STRING(g_level_statement,
607: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_ar.BEGIN',
608: 'L_ATTRIBUTE2_TBL(i) :'||L_ATTRIBUTE2_TBL(i));
609: FND_LOG.STRING(g_level_statement,
610: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_ar.BEGIN',

Line 609: FND_LOG.STRING(g_level_statement,

605: 'L_ATTRIBUTE1_TBL(i) :'||L_ATTRIBUTE1_TBL(i));
606: FND_LOG.STRING(g_level_statement,
607: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_ar.BEGIN',
608: 'L_ATTRIBUTE2_TBL(i) :'||L_ATTRIBUTE2_TBL(i));
609: FND_LOG.STRING(g_level_statement,
610: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_ar.BEGIN',
611: 'L_ATTRIBUTE3_TBL(i) :'||L_ATTRIBUTE3_TBL(i));
612: FND_LOG.STRING(g_level_statement,
613: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_ar.BEGIN',

Line 612: FND_LOG.STRING(g_level_statement,

608: 'L_ATTRIBUTE2_TBL(i) :'||L_ATTRIBUTE2_TBL(i));
609: FND_LOG.STRING(g_level_statement,
610: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_ar.BEGIN',
611: 'L_ATTRIBUTE3_TBL(i) :'||L_ATTRIBUTE3_TBL(i));
612: FND_LOG.STRING(g_level_statement,
613: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_ar.BEGIN',
614: 'L_ATTRIBUTE4_TBL(i) :'||L_ATTRIBUTE4_TBL(i));
615: FND_LOG.STRING(g_level_statement,
616: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_ar.BEGIN',

Line 615: FND_LOG.STRING(g_level_statement,

611: 'L_ATTRIBUTE3_TBL(i) :'||L_ATTRIBUTE3_TBL(i));
612: FND_LOG.STRING(g_level_statement,
613: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_ar.BEGIN',
614: 'L_ATTRIBUTE4_TBL(i) :'||L_ATTRIBUTE4_TBL(i));
615: FND_LOG.STRING(g_level_statement,
616: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_ar.BEGIN',
617: 'L_ATTRIBUTE5_TBL(i) :'||L_ATTRIBUTE5_TBL(i));
618: FND_LOG.STRING(g_level_statement,
619: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_ar.BEGIN',

Line 618: FND_LOG.STRING(g_level_statement,

614: 'L_ATTRIBUTE4_TBL(i) :'||L_ATTRIBUTE4_TBL(i));
615: FND_LOG.STRING(g_level_statement,
616: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_ar.BEGIN',
617: 'L_ATTRIBUTE5_TBL(i) :'||L_ATTRIBUTE5_TBL(i));
618: FND_LOG.STRING(g_level_statement,
619: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_ar.BEGIN',
620: 'L_ATTRIBUTE6_TBL(i) :'||L_ATTRIBUTE6_TBL(i));
621: FND_LOG.STRING(g_level_statement,
622: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_ar.BEGIN',

Line 621: FND_LOG.STRING(g_level_statement,

617: 'L_ATTRIBUTE5_TBL(i) :'||L_ATTRIBUTE5_TBL(i));
618: FND_LOG.STRING(g_level_statement,
619: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_ar.BEGIN',
620: 'L_ATTRIBUTE6_TBL(i) :'||L_ATTRIBUTE6_TBL(i));
621: FND_LOG.STRING(g_level_statement,
622: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_ar.BEGIN',
623: 'L_ATTRIBUTE7_TBL(i) :'||L_ATTRIBUTE7_TBL(i));
624: FND_LOG.STRING(g_level_statement,
625: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_ar.BEGIN',

Line 624: FND_LOG.STRING(g_level_statement,

620: 'L_ATTRIBUTE6_TBL(i) :'||L_ATTRIBUTE6_TBL(i));
621: FND_LOG.STRING(g_level_statement,
622: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_ar.BEGIN',
623: 'L_ATTRIBUTE7_TBL(i) :'||L_ATTRIBUTE7_TBL(i));
624: FND_LOG.STRING(g_level_statement,
625: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_ar.BEGIN',
626: 'L_ATTRIBUTE25_TBL(i) :'||L_ATTRIBUTE25_TBL(i));
627: FND_LOG.STRING(g_level_statement,
628: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_ar.BEGIN',

Line 627: FND_LOG.STRING(g_level_statement,

623: 'L_ATTRIBUTE7_TBL(i) :'||L_ATTRIBUTE7_TBL(i));
624: FND_LOG.STRING(g_level_statement,
625: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_ar.BEGIN',
626: 'L_ATTRIBUTE25_TBL(i) :'||L_ATTRIBUTE25_TBL(i));
627: FND_LOG.STRING(g_level_statement,
628: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_ar.BEGIN',
629: 'L_ATTRIBUTE26_TBL(i) :'||L_ATTRIBUTE26_TBL(i));
630: FND_LOG.STRING(g_level_statement,
631: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_ar.BEGIN',

Line 630: FND_LOG.STRING(g_level_statement,

626: 'L_ATTRIBUTE25_TBL(i) :'||L_ATTRIBUTE25_TBL(i));
627: FND_LOG.STRING(g_level_statement,
628: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_ar.BEGIN',
629: 'L_ATTRIBUTE26_TBL(i) :'||L_ATTRIBUTE26_TBL(i));
630: FND_LOG.STRING(g_level_statement,
631: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_ar.BEGIN',
632: 'L_ATTRIBUTE27_TBL(i) :'||L_ATTRIBUTE27_TBL(i));
633: FND_LOG.STRING(g_level_statement,
634: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_ar.BEGIN',

Line 633: FND_LOG.STRING(g_level_statement,

629: 'L_ATTRIBUTE26_TBL(i) :'||L_ATTRIBUTE26_TBL(i));
630: FND_LOG.STRING(g_level_statement,
631: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_ar.BEGIN',
632: 'L_ATTRIBUTE27_TBL(i) :'||L_ATTRIBUTE27_TBL(i));
633: FND_LOG.STRING(g_level_statement,
634: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_ar.BEGIN',
635: 'L_ATTRIBUTE28_TBL(i) :'||L_ATTRIBUTE28_TBL(i));
636: END IF;
637:

Line 641: FND_LOG.STRING(g_level_statement,

637:
638: END LOOP ;
639:
640: IF (g_level_statement >= g_current_runtime_level ) THEN
641: FND_LOG.STRING(g_level_statement,
642: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_ar.BEGIN',
643: 'Before Updating ZX_REP_TRX_JX_EXT_T with attribute columns obtained ' );
644: END IF;
645:

Line 669: FND_LOG.STRING(g_level_statement,

665: WHERE detail_tax_line_id = L_DETAIL_TAX_LINE_ID_TBL(i) and
666: request_id = P_TRL_GLOBAL_VARIABLES_REC.REQUEST_ID;
667:
668: IF (g_level_statement >= g_current_runtime_level ) THEN
669: FND_LOG.STRING(g_level_statement,
670: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_ar.BEGIN',
671: 'After Updating ZX_REP_TRX_JX_EXT_T with attribute columns obtained ' );
672: END IF;
673: -- exit when get_rep_entity_info_cur%NOTFOUND;

Line 685: FND_LOG.STRING(g_level_statement,

681:
682: END IF;
683: --commit; Bug 8262631
684: IF (g_level_statement >= g_current_runtime_level ) THEN
685: FND_LOG.STRING(g_level_statement,
686: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_ar.END',
687: 'je_tax_extract.populate_je_ar(-)');
688: END IF;
689:

Line 930: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

926: AND assoc.entity_code = 'ZX_RATES'
927: AND rep_type.reporting_type_code = p_reporting_type ;
928:
929: BEGIN
930: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
931: IF (g_level_statement >= g_current_runtime_level ) THEN
932: FND_LOG.STRING(g_level_statement,
933: 'ZX.TRL.je_tax_extract.populate_je_ap.BEGIN',
934: 'je_tax_extract.populate_je_ap(+)');

Line 932: FND_LOG.STRING(g_level_statement,

928:
929: BEGIN
930: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
931: IF (g_level_statement >= g_current_runtime_level ) THEN
932: FND_LOG.STRING(g_level_statement,
933: 'ZX.TRL.je_tax_extract.populate_je_ap.BEGIN',
934: 'je_tax_extract.populate_je_ap(+)');
935: END IF;
936:

Line 946: FND_LOG.STRING(g_level_statement,

942:
943:
944: IF l_tax_line_id_tbl.count <> 0 THEN
945: IF (g_level_statement >= g_current_runtime_level ) THEN
946: FND_LOG.STRING(g_level_statement,
947: 'ZX.TRL.je_tax_extract.populate_je_ap',
948: 'POPULATE_JE_AP - Rows extracted : '||to_char(l_tax_line_id_tbl.count));
949: END IF;
950: INSERT INTO ZX_REP_TRX_JX_EXT_T

Line 1012: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JE_AP',

1008: and itf1.ledger_id = ap_inv.set_of_books_id
1009: and itf1.request_id = P_TRL_GLOBAL_VARIABLES_REC.REQUEST_ID;
1010:
1011: IF ( g_level_statement>= g_current_runtime_level ) THEN
1012: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JE_AP',
1013: 'No. of rows inserted into ZX_REP_TRX_JX_EXT_T : '||to_char(SQL%ROWCOUNT) );
1014: END IF;
1015:
1016: open get_rep_entity_info_cur ;

Line 1039: FND_LOG.STRING(g_level_statement,

1035:
1036: l_count := nvl(L_DETAIL_TAX_LINE_ID_TBL.COUNT,0);
1037:
1038: IF (g_level_statement >= g_current_runtime_level ) THEN
1039: FND_LOG.STRING(g_level_statement,
1040: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_ap.BEGIN',
1041: 'l_count : '||l_count);
1042: END IF;
1043:

Line 1136: FND_LOG.STRING(g_level_statement,

1132: L_ATTRIBUTE7_TBL(i) := L_ATTRIBUTE7_TMP_TBL(L_TAX_RATE_ID_TBL(i));
1133: END IF ;
1134:
1135: IF (g_level_statement >= g_current_runtime_level ) THEN
1136: FND_LOG.STRING(g_level_statement,
1137: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_ap.BEGIN',
1138: 'Displaying the Vlaues for attributes : i :'||i);
1139: FND_LOG.STRING(g_level_statement,
1140: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_ap.BEGIN',

Line 1139: FND_LOG.STRING(g_level_statement,

1135: IF (g_level_statement >= g_current_runtime_level ) THEN
1136: FND_LOG.STRING(g_level_statement,
1137: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_ap.BEGIN',
1138: 'Displaying the Vlaues for attributes : i :'||i);
1139: FND_LOG.STRING(g_level_statement,
1140: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_ap.BEGIN',
1141: 'L_DETAIL_TAX_LINE_ID_TBL(i)'||L_DETAIL_TAX_LINE_ID_TBL(i));
1142: FND_LOG.STRING(g_level_statement,
1143: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_ap.BEGIN',

Line 1142: FND_LOG.STRING(g_level_statement,

1138: 'Displaying the Vlaues for attributes : i :'||i);
1139: FND_LOG.STRING(g_level_statement,
1140: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_ap.BEGIN',
1141: 'L_DETAIL_TAX_LINE_ID_TBL(i)'||L_DETAIL_TAX_LINE_ID_TBL(i));
1142: FND_LOG.STRING(g_level_statement,
1143: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_ap.BEGIN',
1144: 'L_ATTRIBUTE1_TBL(i) :'||L_ATTRIBUTE1_TBL(i));
1145: FND_LOG.STRING(g_level_statement,
1146: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_ap.BEGIN',

Line 1145: FND_LOG.STRING(g_level_statement,

1141: 'L_DETAIL_TAX_LINE_ID_TBL(i)'||L_DETAIL_TAX_LINE_ID_TBL(i));
1142: FND_LOG.STRING(g_level_statement,
1143: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_ap.BEGIN',
1144: 'L_ATTRIBUTE1_TBL(i) :'||L_ATTRIBUTE1_TBL(i));
1145: FND_LOG.STRING(g_level_statement,
1146: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_ap.BEGIN',
1147: 'L_ATTRIBUTE2_TBL(i) :'||L_ATTRIBUTE2_TBL(i));
1148: FND_LOG.STRING(g_level_statement,
1149: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_ap.BEGIN',

Line 1148: FND_LOG.STRING(g_level_statement,

1144: 'L_ATTRIBUTE1_TBL(i) :'||L_ATTRIBUTE1_TBL(i));
1145: FND_LOG.STRING(g_level_statement,
1146: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_ap.BEGIN',
1147: 'L_ATTRIBUTE2_TBL(i) :'||L_ATTRIBUTE2_TBL(i));
1148: FND_LOG.STRING(g_level_statement,
1149: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_ap.BEGIN',
1150: 'L_ATTRIBUTE3_TBL(i) :'||L_ATTRIBUTE3_TBL(i));
1151: FND_LOG.STRING(g_level_statement,
1152: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_ap.BEGIN',

Line 1151: FND_LOG.STRING(g_level_statement,

1147: 'L_ATTRIBUTE2_TBL(i) :'||L_ATTRIBUTE2_TBL(i));
1148: FND_LOG.STRING(g_level_statement,
1149: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_ap.BEGIN',
1150: 'L_ATTRIBUTE3_TBL(i) :'||L_ATTRIBUTE3_TBL(i));
1151: FND_LOG.STRING(g_level_statement,
1152: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_ap.BEGIN',
1153: 'L_ATTRIBUTE4_TBL(i) :'||L_ATTRIBUTE4_TBL(i));
1154: FND_LOG.STRING(g_level_statement,
1155: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_ap.BEGIN',

Line 1154: FND_LOG.STRING(g_level_statement,

1150: 'L_ATTRIBUTE3_TBL(i) :'||L_ATTRIBUTE3_TBL(i));
1151: FND_LOG.STRING(g_level_statement,
1152: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_ap.BEGIN',
1153: 'L_ATTRIBUTE4_TBL(i) :'||L_ATTRIBUTE4_TBL(i));
1154: FND_LOG.STRING(g_level_statement,
1155: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_ap.BEGIN',
1156: 'L_ATTRIBUTE5_TBL(i) :'||L_ATTRIBUTE5_TBL(i));
1157: FND_LOG.STRING(g_level_statement,
1158: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_ap.BEGIN',

Line 1157: FND_LOG.STRING(g_level_statement,

1153: 'L_ATTRIBUTE4_TBL(i) :'||L_ATTRIBUTE4_TBL(i));
1154: FND_LOG.STRING(g_level_statement,
1155: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_ap.BEGIN',
1156: 'L_ATTRIBUTE5_TBL(i) :'||L_ATTRIBUTE5_TBL(i));
1157: FND_LOG.STRING(g_level_statement,
1158: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_ap.BEGIN',
1159: 'L_ATTRIBUTE6_TBL(i) :'||L_ATTRIBUTE6_TBL(i));
1160: FND_LOG.STRING(g_level_statement,
1161: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_ap.BEGIN',

Line 1160: FND_LOG.STRING(g_level_statement,

1156: 'L_ATTRIBUTE5_TBL(i) :'||L_ATTRIBUTE5_TBL(i));
1157: FND_LOG.STRING(g_level_statement,
1158: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_ap.BEGIN',
1159: 'L_ATTRIBUTE6_TBL(i) :'||L_ATTRIBUTE6_TBL(i));
1160: FND_LOG.STRING(g_level_statement,
1161: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_ap.BEGIN',
1162: 'L_ATTRIBUTE7_TBL(i) :'||L_ATTRIBUTE7_TBL(i));
1163: FND_LOG.STRING(g_level_statement,
1164: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_ap.BEGIN',

Line 1163: FND_LOG.STRING(g_level_statement,

1159: 'L_ATTRIBUTE6_TBL(i) :'||L_ATTRIBUTE6_TBL(i));
1160: FND_LOG.STRING(g_level_statement,
1161: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_ap.BEGIN',
1162: 'L_ATTRIBUTE7_TBL(i) :'||L_ATTRIBUTE7_TBL(i));
1163: FND_LOG.STRING(g_level_statement,
1164: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_ap.BEGIN',
1165: 'L_ATTRIBUTE27_TBL(i) :'||L_ATTRIBUTE27_TBL(i));
1166: FND_LOG.STRING(g_level_statement,
1167: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_ap.BEGIN',

Line 1166: FND_LOG.STRING(g_level_statement,

1162: 'L_ATTRIBUTE7_TBL(i) :'||L_ATTRIBUTE7_TBL(i));
1163: FND_LOG.STRING(g_level_statement,
1164: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_ap.BEGIN',
1165: 'L_ATTRIBUTE27_TBL(i) :'||L_ATTRIBUTE27_TBL(i));
1166: FND_LOG.STRING(g_level_statement,
1167: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_ap.BEGIN',
1168: 'L_ATTRIBUTE28_TBL(i) :'||L_ATTRIBUTE28_TBL(i));
1169: END IF;
1170:

Line 1174: FND_LOG.STRING(g_level_statement,

1170:
1171: END LOOP ;
1172:
1173: IF (g_level_statement >= g_current_runtime_level ) THEN
1174: FND_LOG.STRING(g_level_statement,
1175: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_ap.BEGIN',
1176: 'Before Updating ZX_REP_TRX_JX_EXT_T with attribute columns obtained ' );
1177: END IF;
1178:

Line 1182: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JE_AP',

1178:
1179: IF ( l_count > 0 ) THEN
1180:
1181: IF ( g_level_statement>= g_current_runtime_level ) THEN
1182: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JE_AP',
1183: 'Before Updating ZX_REP_TRX_JX_EXT_T' );
1184: END IF;
1185: FORALL i IN 1 .. L_DETAIL_TAX_LINE_ID_TBL.count
1186: UPDATE ZX_REP_TRX_JX_EXT_T

Line 1210: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JE_AP',

1206: and request_id = P_TRL_GLOBAL_VARIABLES_REC.REQUEST_ID;
1207:
1208:
1209: IF ( g_level_statement>= g_current_runtime_level ) THEN
1210: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JE_AP',
1211: 'After Updating ZX_REP_TRX_JX_EXT_T' );
1212: END IF;
1213: ELSE
1214: EXIT ;

Line 1225: FND_LOG.STRING(g_level_statement,

1221:
1222: END IF;
1223: --commit; Bug 8262631
1224: IF (g_level_statement >= g_current_runtime_level ) THEN
1225: FND_LOG.STRING(g_level_statement,
1226: 'ZX.TRL.je_tax_extract.populate_je_ap.END',
1227: 'je_tax_extract.populate_je_ap(-)');
1228: END IF;
1229:

Line 1392: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1388: AND itf1.request_id = P_TRL_GLOBAL_VARIABLES_REC.REQUEST_ID;
1389:
1390: BEGIN
1391:
1392: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1393: IF (g_level_statement >= g_current_runtime_level ) THEN
1394: FND_LOG.STRING(g_level_statement,
1395: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_gl.BEGIN',
1396: 'je_tax_extract.populate_je_gl(+)');

Line 1394: FND_LOG.STRING(g_level_statement,

1390: BEGIN
1391:
1392: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1393: IF (g_level_statement >= g_current_runtime_level ) THEN
1394: FND_LOG.STRING(g_level_statement,
1395: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_gl.BEGIN',
1396: 'je_tax_extract.populate_je_gl(+)');
1397:
1398: FND_LOG.STRING(g_level_statement,

Line 1398: FND_LOG.STRING(g_level_statement,

1394: FND_LOG.STRING(g_level_statement,
1395: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_gl.BEGIN',
1396: 'je_tax_extract.populate_je_gl(+)');
1397:
1398: FND_LOG.STRING(g_level_statement,
1399: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_gl.BEGIN',
1400: 'Before insertion into ZX_REP_TRX_JX_EXT_T - 1');
1401: END IF;
1402:

Line 1409: FND_LOG.STRING(g_level_statement,

1405: FROM zx_rep_trx_detail_t itf1
1406: WHERE itf1.request_id = P_TRL_GLOBAL_VARIABLES_REC.REQUEST_ID;
1407:
1408: IF (g_level_statement >= g_current_runtime_level ) THEN
1409: FND_LOG.STRING(g_level_statement,
1410: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_gl.BEGIN',
1411: 'Count Before insertion - 1'||to_char(l_detail_tax_line_id_tbl.count));
1412: END IF;
1413:

Line 1445: FND_LOG.STRING(g_level_statement,

1441: AND gjl.je_line_num = itf1.trx_line_id
1442: );
1443:
1444: IF (g_level_statement >= g_current_runtime_level ) THEN
1445: FND_LOG.STRING(g_level_statement,
1446: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_gl.BEGIN',
1447: 'No. of rows inserted into ZX_REP_TRX_JX_EXT_T - 1'||to_char(sql%ROWCOUNT));
1448: END IF;
1449:

Line 1468: FND_LOG.STRING(g_level_statement,

1464:
1465: l_count := nvl(L_DETAIL_TAX_LINE_ID_TBL.COUNT,0);
1466:
1467: IF (g_level_statement >= g_current_runtime_level ) THEN
1468: FND_LOG.STRING(g_level_statement,
1469: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_gl.BEGIN',
1470: 'l_count : '||l_count);
1471: END IF;
1472:

Line 1561: FND_LOG.STRING(g_level_statement,

1557: END IF ;
1558:
1559:
1560: IF (g_level_statement >= g_current_runtime_level ) THEN
1561: FND_LOG.STRING(g_level_statement,
1562: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_gl.BEGIN',
1563: 'Displaying the Vlaues for attributes : i :'||i);
1564: FND_LOG.STRING(g_level_statement,
1565: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_gl.BEGIN',

Line 1564: FND_LOG.STRING(g_level_statement,

1560: IF (g_level_statement >= g_current_runtime_level ) THEN
1561: FND_LOG.STRING(g_level_statement,
1562: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_gl.BEGIN',
1563: 'Displaying the Vlaues for attributes : i :'||i);
1564: FND_LOG.STRING(g_level_statement,
1565: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_gl.BEGIN',
1566: 'L_DETAIL_TAX_LINE_ID_TBL(i)'||L_DETAIL_TAX_LINE_ID_TBL(i));
1567: FND_LOG.STRING(g_level_statement,
1568: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_gl.BEGIN',

Line 1567: FND_LOG.STRING(g_level_statement,

1563: 'Displaying the Vlaues for attributes : i :'||i);
1564: FND_LOG.STRING(g_level_statement,
1565: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_gl.BEGIN',
1566: 'L_DETAIL_TAX_LINE_ID_TBL(i)'||L_DETAIL_TAX_LINE_ID_TBL(i));
1567: FND_LOG.STRING(g_level_statement,
1568: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_gl.BEGIN',
1569: 'L_ATTRIBUTE1_TBL(i) :'||L_ATTRIBUTE1_TBL(i));
1570: FND_LOG.STRING(g_level_statement,
1571: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_gl.BEGIN',

Line 1570: FND_LOG.STRING(g_level_statement,

1566: 'L_DETAIL_TAX_LINE_ID_TBL(i)'||L_DETAIL_TAX_LINE_ID_TBL(i));
1567: FND_LOG.STRING(g_level_statement,
1568: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_gl.BEGIN',
1569: 'L_ATTRIBUTE1_TBL(i) :'||L_ATTRIBUTE1_TBL(i));
1570: FND_LOG.STRING(g_level_statement,
1571: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_gl.BEGIN',
1572: 'L_ATTRIBUTE2_TBL(i) :'||L_ATTRIBUTE2_TBL(i));
1573: FND_LOG.STRING(g_level_statement,
1574: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_gl.BEGIN',

Line 1573: FND_LOG.STRING(g_level_statement,

1569: 'L_ATTRIBUTE1_TBL(i) :'||L_ATTRIBUTE1_TBL(i));
1570: FND_LOG.STRING(g_level_statement,
1571: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_gl.BEGIN',
1572: 'L_ATTRIBUTE2_TBL(i) :'||L_ATTRIBUTE2_TBL(i));
1573: FND_LOG.STRING(g_level_statement,
1574: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_gl.BEGIN',
1575: 'L_ATTRIBUTE3_TBL(i) :'||L_ATTRIBUTE3_TBL(i));
1576: FND_LOG.STRING(g_level_statement,
1577: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_gl.BEGIN',

Line 1576: FND_LOG.STRING(g_level_statement,

1572: 'L_ATTRIBUTE2_TBL(i) :'||L_ATTRIBUTE2_TBL(i));
1573: FND_LOG.STRING(g_level_statement,
1574: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_gl.BEGIN',
1575: 'L_ATTRIBUTE3_TBL(i) :'||L_ATTRIBUTE3_TBL(i));
1576: FND_LOG.STRING(g_level_statement,
1577: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_gl.BEGIN',
1578: 'L_ATTRIBUTE4_TBL(i) :'||L_ATTRIBUTE4_TBL(i));
1579: FND_LOG.STRING(g_level_statement,
1580: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_gl.BEGIN',

Line 1579: FND_LOG.STRING(g_level_statement,

1575: 'L_ATTRIBUTE3_TBL(i) :'||L_ATTRIBUTE3_TBL(i));
1576: FND_LOG.STRING(g_level_statement,
1577: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_gl.BEGIN',
1578: 'L_ATTRIBUTE4_TBL(i) :'||L_ATTRIBUTE4_TBL(i));
1579: FND_LOG.STRING(g_level_statement,
1580: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_gl.BEGIN',
1581: 'L_ATTRIBUTE5_TBL(i) :'||L_ATTRIBUTE5_TBL(i));
1582: FND_LOG.STRING(g_level_statement,
1583: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_gl.BEGIN',

Line 1582: FND_LOG.STRING(g_level_statement,

1578: 'L_ATTRIBUTE4_TBL(i) :'||L_ATTRIBUTE4_TBL(i));
1579: FND_LOG.STRING(g_level_statement,
1580: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_gl.BEGIN',
1581: 'L_ATTRIBUTE5_TBL(i) :'||L_ATTRIBUTE5_TBL(i));
1582: FND_LOG.STRING(g_level_statement,
1583: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_gl.BEGIN',
1584: 'L_ATTRIBUTE6_TBL(i) :'||L_ATTRIBUTE6_TBL(i));
1585: FND_LOG.STRING(g_level_statement,
1586: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_gl.BEGIN',

Line 1585: FND_LOG.STRING(g_level_statement,

1581: 'L_ATTRIBUTE5_TBL(i) :'||L_ATTRIBUTE5_TBL(i));
1582: FND_LOG.STRING(g_level_statement,
1583: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_gl.BEGIN',
1584: 'L_ATTRIBUTE6_TBL(i) :'||L_ATTRIBUTE6_TBL(i));
1585: FND_LOG.STRING(g_level_statement,
1586: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_gl.BEGIN',
1587: 'L_ATTRIBUTE7_TBL(i) :'||L_ATTRIBUTE7_TBL(i));
1588: FND_LOG.STRING(g_level_statement,
1589: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_gl.BEGIN',

Line 1588: FND_LOG.STRING(g_level_statement,

1584: 'L_ATTRIBUTE6_TBL(i) :'||L_ATTRIBUTE6_TBL(i));
1585: FND_LOG.STRING(g_level_statement,
1586: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_gl.BEGIN',
1587: 'L_ATTRIBUTE7_TBL(i) :'||L_ATTRIBUTE7_TBL(i));
1588: FND_LOG.STRING(g_level_statement,
1589: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_gl.BEGIN',
1590: 'L_TAX_STATUS_CODE_TBL(i) :'||L_TAX_STATUS_CODE_TBL(i));
1591: FND_LOG.STRING(g_level_statement,
1592: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_gl.BEGIN',

Line 1591: FND_LOG.STRING(g_level_statement,

1587: 'L_ATTRIBUTE7_TBL(i) :'||L_ATTRIBUTE7_TBL(i));
1588: FND_LOG.STRING(g_level_statement,
1589: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_gl.BEGIN',
1590: 'L_TAX_STATUS_CODE_TBL(i) :'||L_TAX_STATUS_CODE_TBL(i));
1591: FND_LOG.STRING(g_level_statement,
1592: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_gl.BEGIN',
1593: 'L_TRX_BUSINESS_CATEGORY_TBL(i) :'||L_TRX_BUSINESS_CATEGORY_TBL(i));
1594: FND_LOG.STRING(g_level_statement,
1595: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_gl.BEGIN',

Line 1594: FND_LOG.STRING(g_level_statement,

1590: 'L_TAX_STATUS_CODE_TBL(i) :'||L_TAX_STATUS_CODE_TBL(i));
1591: FND_LOG.STRING(g_level_statement,
1592: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_gl.BEGIN',
1593: 'L_TRX_BUSINESS_CATEGORY_TBL(i) :'||L_TRX_BUSINESS_CATEGORY_TBL(i));
1594: FND_LOG.STRING(g_level_statement,
1595: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_gl.BEGIN',
1596: 'L_DOCUMENT_SUB_TYPE_TBL(i) :'||L_DOCUMENT_SUB_TYPE_TBL(i));
1597: END IF;
1598:

Line 1604: FND_LOG.STRING(g_level_statement,

1600:
1601: IF ( l_count > 0 ) THEN
1602:
1603: IF (g_level_statement >= g_current_runtime_level ) THEN
1604: FND_LOG.STRING(g_level_statement,
1605: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_gl.BEGIN',
1606: 'Before Updating ZX_REP_TRX_JX_EXT_T with attribute columns obtained -GL ' );
1607: END IF;
1608:

Line 1628: FND_LOG.STRING(g_level_statement,

1624: WHERE detail_tax_line_id = L_DETAIL_TAX_LINE_ID_TBL(i) and
1625: request_id = P_TRL_GLOBAL_VARIABLES_REC.REQUEST_ID;
1626:
1627: IF (g_level_statement >= g_current_runtime_level ) THEN
1628: FND_LOG.STRING(g_level_statement,
1629: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_gl.BEGIN',
1630: 'After Updating ZX_REP_TRX_JX_EXT_T with attribute columns obtained ' );
1631: END IF;
1632: -- exit when get_rep_entity_info_cur%NOTFOUND;

Line 1645: FND_LOG.STRING(g_level_statement,

1641: END IF ;
1642:
1643: --commit; Bug 8262631
1644: IF (g_level_statement >= g_current_runtime_level ) THEN
1645: FND_LOG.STRING(g_level_statement,
1646: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_gl.END',
1647: 'je_tax_extract.populate_je_gl(-)');
1648: END IF;
1649: