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

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

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

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

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

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

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

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

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

Line 185: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

181: AND rep_type.reporting_type_code = p_reporting_type ;
182:
183: BEGIN
184:
185: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
186: IF (g_level_unexpected >= g_current_runtime_level ) THEN
187: FND_LOG.STRING(g_level_unexpected,
188: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_ar.BEGIN',
189: 'je_tax_extract.populate_je_ar(+)');

Line 187: FND_LOG.STRING(g_level_unexpected,

183: BEGIN
184:
185: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
186: IF (g_level_unexpected >= g_current_runtime_level ) THEN
187: FND_LOG.STRING(g_level_unexpected,
188: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_ar.BEGIN',
189: 'je_tax_extract.populate_je_ar(+)');
190: END IF;
191:

Line 269: FND_LOG.STRING(g_level_unexpected,

265:
266: l_count := nvl(L_DETAIL_TAX_LINE_ID_TBL.COUNT,0);
267:
268: IF (g_level_unexpected >= g_current_runtime_level ) THEN
269: FND_LOG.STRING(g_level_unexpected,
270: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_ar.BEGIN',
271: 'l_count : '||l_count);
272: END IF;
273:

Line 361: FND_LOG.STRING(g_level_unexpected,

357: L_ATTRIBUTE7_TBL(i) := L_ATTRIBUTE7_TMP_TBL(L_TAX_RATE_ID_TBL(i));
358: END IF ;
359:
360: IF (g_level_unexpected >= g_current_runtime_level ) THEN
361: FND_LOG.STRING(g_level_unexpected,
362: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_ar.BEGIN',
363: 'Displaying the Vlaues for attributes : i :'||i);
364: FND_LOG.STRING(g_level_unexpected,
365: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_ar.BEGIN',

Line 364: FND_LOG.STRING(g_level_unexpected,

360: IF (g_level_unexpected >= g_current_runtime_level ) THEN
361: FND_LOG.STRING(g_level_unexpected,
362: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_ar.BEGIN',
363: 'Displaying the Vlaues for attributes : i :'||i);
364: FND_LOG.STRING(g_level_unexpected,
365: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_ar.BEGIN',
366: 'L_DETAIL_TAX_LINE_ID_TBL(i)'||L_DETAIL_TAX_LINE_ID_TBL(i));
367: FND_LOG.STRING(g_level_unexpected,
368: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_ar.BEGIN',

Line 367: FND_LOG.STRING(g_level_unexpected,

363: 'Displaying the Vlaues for attributes : i :'||i);
364: FND_LOG.STRING(g_level_unexpected,
365: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_ar.BEGIN',
366: 'L_DETAIL_TAX_LINE_ID_TBL(i)'||L_DETAIL_TAX_LINE_ID_TBL(i));
367: FND_LOG.STRING(g_level_unexpected,
368: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_ar.BEGIN',
369: 'L_ATTRIBUTE1_TBL(i) :'||L_ATTRIBUTE1_TBL(i));
370: FND_LOG.STRING(g_level_unexpected,
371: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_ar.BEGIN',

Line 370: FND_LOG.STRING(g_level_unexpected,

366: 'L_DETAIL_TAX_LINE_ID_TBL(i)'||L_DETAIL_TAX_LINE_ID_TBL(i));
367: FND_LOG.STRING(g_level_unexpected,
368: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_ar.BEGIN',
369: 'L_ATTRIBUTE1_TBL(i) :'||L_ATTRIBUTE1_TBL(i));
370: FND_LOG.STRING(g_level_unexpected,
371: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_ar.BEGIN',
372: 'L_ATTRIBUTE2_TBL(i) :'||L_ATTRIBUTE2_TBL(i));
373: FND_LOG.STRING(g_level_unexpected,
374: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_ar.BEGIN',

Line 373: FND_LOG.STRING(g_level_unexpected,

369: 'L_ATTRIBUTE1_TBL(i) :'||L_ATTRIBUTE1_TBL(i));
370: FND_LOG.STRING(g_level_unexpected,
371: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_ar.BEGIN',
372: 'L_ATTRIBUTE2_TBL(i) :'||L_ATTRIBUTE2_TBL(i));
373: FND_LOG.STRING(g_level_unexpected,
374: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_ar.BEGIN',
375: 'L_ATTRIBUTE3_TBL(i) :'||L_ATTRIBUTE3_TBL(i));
376: FND_LOG.STRING(g_level_unexpected,
377: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_ar.BEGIN',

Line 376: FND_LOG.STRING(g_level_unexpected,

372: 'L_ATTRIBUTE2_TBL(i) :'||L_ATTRIBUTE2_TBL(i));
373: FND_LOG.STRING(g_level_unexpected,
374: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_ar.BEGIN',
375: 'L_ATTRIBUTE3_TBL(i) :'||L_ATTRIBUTE3_TBL(i));
376: FND_LOG.STRING(g_level_unexpected,
377: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_ar.BEGIN',
378: 'L_ATTRIBUTE4_TBL(i) :'||L_ATTRIBUTE4_TBL(i));
379: FND_LOG.STRING(g_level_unexpected,
380: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_ar.BEGIN',

Line 379: FND_LOG.STRING(g_level_unexpected,

375: 'L_ATTRIBUTE3_TBL(i) :'||L_ATTRIBUTE3_TBL(i));
376: FND_LOG.STRING(g_level_unexpected,
377: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_ar.BEGIN',
378: 'L_ATTRIBUTE4_TBL(i) :'||L_ATTRIBUTE4_TBL(i));
379: FND_LOG.STRING(g_level_unexpected,
380: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_ar.BEGIN',
381: 'L_ATTRIBUTE5_TBL(i) :'||L_ATTRIBUTE5_TBL(i));
382: FND_LOG.STRING(g_level_unexpected,
383: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_ar.BEGIN',

Line 382: FND_LOG.STRING(g_level_unexpected,

378: 'L_ATTRIBUTE4_TBL(i) :'||L_ATTRIBUTE4_TBL(i));
379: FND_LOG.STRING(g_level_unexpected,
380: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_ar.BEGIN',
381: 'L_ATTRIBUTE5_TBL(i) :'||L_ATTRIBUTE5_TBL(i));
382: FND_LOG.STRING(g_level_unexpected,
383: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_ar.BEGIN',
384: 'L_ATTRIBUTE6_TBL(i) :'||L_ATTRIBUTE6_TBL(i));
385: FND_LOG.STRING(g_level_unexpected,
386: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_ar.BEGIN',

Line 385: FND_LOG.STRING(g_level_unexpected,

381: 'L_ATTRIBUTE5_TBL(i) :'||L_ATTRIBUTE5_TBL(i));
382: FND_LOG.STRING(g_level_unexpected,
383: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_ar.BEGIN',
384: 'L_ATTRIBUTE6_TBL(i) :'||L_ATTRIBUTE6_TBL(i));
385: FND_LOG.STRING(g_level_unexpected,
386: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_ar.BEGIN',
387: 'L_ATTRIBUTE7_TBL(i) :'||L_ATTRIBUTE7_TBL(i));
388: END IF;
389:

Line 393: FND_LOG.STRING(g_level_unexpected,

389:
390: END LOOP ;
391:
392: IF (g_level_unexpected >= g_current_runtime_level ) THEN
393: FND_LOG.STRING(g_level_unexpected,
394: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_ar.BEGIN',
395: 'Before Updating ZX_REP_TRX_JX_EXT_T with attribute columns obtained ' );
396: END IF;
397:

Line 419: FND_LOG.STRING(g_level_unexpected,

415: WHERE detail_tax_line_id = L_DETAIL_TAX_LINE_ID_TBL(i) and
416: request_id = P_TRL_GLOBAL_VARIABLES_REC.REQUEST_ID;
417:
418: IF (g_level_unexpected >= g_current_runtime_level ) THEN
419: FND_LOG.STRING(g_level_unexpected,
420: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_ar.BEGIN',
421: 'After Updating ZX_REP_TRX_JX_EXT_T with attribute columns obtained ' );
422: END IF;
423: -- exit when get_rep_entity_info_cur%NOTFOUND;

Line 435: FND_LOG.STRING(g_level_unexpected,

431:
432: END IF;
433: commit;
434: IF (g_level_unexpected >= g_current_runtime_level ) THEN
435: FND_LOG.STRING(g_level_unexpected,
436: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_ar.END',
437: 'je_tax_extract.populate_je_ar(-)');
438: END IF;
439:

Line 644: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

640: AND assoc.entity_code = 'ZX_RATES'
641: AND rep_type.reporting_type_code = p_reporting_type ;
642:
643: BEGIN
644: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
645: IF (g_level_unexpected >= g_current_runtime_level ) THEN
646: FND_LOG.STRING(g_level_unexpected,
647: 'ZX.TRL.je_tax_extract.populate_je_ap.BEGIN',
648: 'je_tax_extract.populate_je_ap(+)');

Line 646: FND_LOG.STRING(g_level_unexpected,

642:
643: BEGIN
644: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
645: IF (g_level_unexpected >= g_current_runtime_level ) THEN
646: FND_LOG.STRING(g_level_unexpected,
647: 'ZX.TRL.je_tax_extract.populate_je_ap.BEGIN',
648: 'je_tax_extract.populate_je_ap(+)');
649: END IF;
650:

Line 660: FND_LOG.STRING(g_level_unexpected,

656:
657:
658: IF l_tax_line_id_tbl.count <> 0 THEN
659: IF (g_level_unexpected >= g_current_runtime_level ) THEN
660: FND_LOG.STRING(g_level_unexpected,
661: 'ZX.TRL.je_tax_extract.populate_je_ap',
662: 'POPULATE_JE_AP - Rows extracted : '||to_char(l_tax_line_id_tbl.count));
663: END IF;
664: INSERT INTO ZX_REP_TRX_JX_EXT_T

Line 734: FND_LOG.STRING(g_level_unexpected, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JE_AP',

730: and itf1.ledger_id = ap_inv.set_of_books_id
731: and itf1.request_id = P_TRL_GLOBAL_VARIABLES_REC.REQUEST_ID;
732:
733: IF ( g_level_unexpected>= g_current_runtime_level ) THEN
734: FND_LOG.STRING(g_level_unexpected, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JE_AP',
735: 'No. of rows inserted into ZX_REP_TRX_JX_EXT_T : '||to_char(SQL%ROWCOUNT) );
736: END IF;
737:
738: open get_rep_entity_info_cur ;

Line 760: FND_LOG.STRING(g_level_unexpected,

756:
757: l_count := nvl(L_DETAIL_TAX_LINE_ID_TBL.COUNT,0);
758:
759: IF (g_level_unexpected >= g_current_runtime_level ) THEN
760: FND_LOG.STRING(g_level_unexpected,
761: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_ap.BEGIN',
762: 'l_count : '||l_count);
763: END IF;
764:

Line 852: FND_LOG.STRING(g_level_unexpected,

848: L_ATTRIBUTE7_TBL(i) := L_ATTRIBUTE7_TMP_TBL(L_TAX_RATE_ID_TBL(i));
849: END IF ;
850:
851: IF (g_level_unexpected >= g_current_runtime_level ) THEN
852: FND_LOG.STRING(g_level_unexpected,
853: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_ap.BEGIN',
854: 'Displaying the Vlaues for attributes : i :'||i);
855: FND_LOG.STRING(g_level_unexpected,
856: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_ap.BEGIN',

Line 855: FND_LOG.STRING(g_level_unexpected,

851: IF (g_level_unexpected >= g_current_runtime_level ) THEN
852: FND_LOG.STRING(g_level_unexpected,
853: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_ap.BEGIN',
854: 'Displaying the Vlaues for attributes : i :'||i);
855: FND_LOG.STRING(g_level_unexpected,
856: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_ap.BEGIN',
857: 'L_DETAIL_TAX_LINE_ID_TBL(i)'||L_DETAIL_TAX_LINE_ID_TBL(i));
858: FND_LOG.STRING(g_level_unexpected,
859: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_ap.BEGIN',

Line 858: FND_LOG.STRING(g_level_unexpected,

854: 'Displaying the Vlaues for attributes : i :'||i);
855: FND_LOG.STRING(g_level_unexpected,
856: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_ap.BEGIN',
857: 'L_DETAIL_TAX_LINE_ID_TBL(i)'||L_DETAIL_TAX_LINE_ID_TBL(i));
858: FND_LOG.STRING(g_level_unexpected,
859: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_ap.BEGIN',
860: 'L_ATTRIBUTE1_TBL(i) :'||L_ATTRIBUTE1_TBL(i));
861: FND_LOG.STRING(g_level_unexpected,
862: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_ap.BEGIN',

Line 861: FND_LOG.STRING(g_level_unexpected,

857: 'L_DETAIL_TAX_LINE_ID_TBL(i)'||L_DETAIL_TAX_LINE_ID_TBL(i));
858: FND_LOG.STRING(g_level_unexpected,
859: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_ap.BEGIN',
860: 'L_ATTRIBUTE1_TBL(i) :'||L_ATTRIBUTE1_TBL(i));
861: FND_LOG.STRING(g_level_unexpected,
862: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_ap.BEGIN',
863: 'L_ATTRIBUTE2_TBL(i) :'||L_ATTRIBUTE2_TBL(i));
864: FND_LOG.STRING(g_level_unexpected,
865: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_ap.BEGIN',

Line 864: FND_LOG.STRING(g_level_unexpected,

860: 'L_ATTRIBUTE1_TBL(i) :'||L_ATTRIBUTE1_TBL(i));
861: FND_LOG.STRING(g_level_unexpected,
862: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_ap.BEGIN',
863: 'L_ATTRIBUTE2_TBL(i) :'||L_ATTRIBUTE2_TBL(i));
864: FND_LOG.STRING(g_level_unexpected,
865: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_ap.BEGIN',
866: 'L_ATTRIBUTE3_TBL(i) :'||L_ATTRIBUTE3_TBL(i));
867: FND_LOG.STRING(g_level_unexpected,
868: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_ap.BEGIN',

Line 867: FND_LOG.STRING(g_level_unexpected,

863: 'L_ATTRIBUTE2_TBL(i) :'||L_ATTRIBUTE2_TBL(i));
864: FND_LOG.STRING(g_level_unexpected,
865: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_ap.BEGIN',
866: 'L_ATTRIBUTE3_TBL(i) :'||L_ATTRIBUTE3_TBL(i));
867: FND_LOG.STRING(g_level_unexpected,
868: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_ap.BEGIN',
869: 'L_ATTRIBUTE4_TBL(i) :'||L_ATTRIBUTE4_TBL(i));
870: FND_LOG.STRING(g_level_unexpected,
871: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_ap.BEGIN',

Line 870: FND_LOG.STRING(g_level_unexpected,

866: 'L_ATTRIBUTE3_TBL(i) :'||L_ATTRIBUTE3_TBL(i));
867: FND_LOG.STRING(g_level_unexpected,
868: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_ap.BEGIN',
869: 'L_ATTRIBUTE4_TBL(i) :'||L_ATTRIBUTE4_TBL(i));
870: FND_LOG.STRING(g_level_unexpected,
871: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_ap.BEGIN',
872: 'L_ATTRIBUTE5_TBL(i) :'||L_ATTRIBUTE5_TBL(i));
873: FND_LOG.STRING(g_level_unexpected,
874: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_ap.BEGIN',

Line 873: FND_LOG.STRING(g_level_unexpected,

869: 'L_ATTRIBUTE4_TBL(i) :'||L_ATTRIBUTE4_TBL(i));
870: FND_LOG.STRING(g_level_unexpected,
871: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_ap.BEGIN',
872: 'L_ATTRIBUTE5_TBL(i) :'||L_ATTRIBUTE5_TBL(i));
873: FND_LOG.STRING(g_level_unexpected,
874: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_ap.BEGIN',
875: 'L_ATTRIBUTE6_TBL(i) :'||L_ATTRIBUTE6_TBL(i));
876: FND_LOG.STRING(g_level_unexpected,
877: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_ap.BEGIN',

Line 876: FND_LOG.STRING(g_level_unexpected,

872: 'L_ATTRIBUTE5_TBL(i) :'||L_ATTRIBUTE5_TBL(i));
873: FND_LOG.STRING(g_level_unexpected,
874: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_ap.BEGIN',
875: 'L_ATTRIBUTE6_TBL(i) :'||L_ATTRIBUTE6_TBL(i));
876: FND_LOG.STRING(g_level_unexpected,
877: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_ap.BEGIN',
878: 'L_ATTRIBUTE7_TBL(i) :'||L_ATTRIBUTE7_TBL(i));
879: END IF;
880:

Line 884: FND_LOG.STRING(g_level_unexpected,

880:
881: END LOOP ;
882:
883: IF (g_level_unexpected >= g_current_runtime_level ) THEN
884: FND_LOG.STRING(g_level_unexpected,
885: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_ap.BEGIN',
886: 'Before Updating ZX_REP_TRX_JX_EXT_T with attribute columns obtained ' );
887: END IF;
888:

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

888:
889: IF ( l_count > 0 ) THEN
890:
891: IF ( g_level_statement>= g_current_runtime_level ) THEN
892: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JE_AP',
893: 'Before Updating ZX_REP_TRX_JX_EXT_T' );
894: END IF;
895: FORALL i IN 1 .. L_DETAIL_TAX_LINE_ID_TBL.count
896: UPDATE ZX_REP_TRX_JX_EXT_T

Line 919: FND_LOG.STRING(g_level_unexpected, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JE_AP',

915:
916: --exit when get_rep_entity_info_cur%NOTFOUND;
917:
918: IF ( g_level_unexpected>= g_current_runtime_level ) THEN
919: FND_LOG.STRING(g_level_unexpected, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JE_AP',
920: 'After Updating ZX_REP_TRX_JX_EXT_T' );
921: END IF;
922: ELSE
923: EXIT ;

Line 934: FND_LOG.STRING(g_level_unexpected,

930:
931: END IF;
932: commit;
933: IF (g_level_unexpected >= g_current_runtime_level ) THEN
934: FND_LOG.STRING(g_level_unexpected,
935: 'ZX.TRL.je_tax_extract.populate_je_ap.END',
936: 'je_tax_extract.populate_je_ap(-)');
937: END IF;
938:

Line 1069: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1065: AND itf1.request_id = P_TRL_GLOBAL_VARIABLES_REC.REQUEST_ID;
1066:
1067: BEGIN
1068:
1069: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1070: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1071: FND_LOG.STRING(g_level_unexpected,
1072: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_gl.BEGIN',
1073: 'je_tax_extract.populate_je_gl(+)');

Line 1071: FND_LOG.STRING(g_level_unexpected,

1067: BEGIN
1068:
1069: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1070: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1071: FND_LOG.STRING(g_level_unexpected,
1072: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_gl.BEGIN',
1073: 'je_tax_extract.populate_je_gl(+)');
1074:
1075: FND_LOG.STRING(g_level_unexpected,

Line 1075: FND_LOG.STRING(g_level_unexpected,

1071: FND_LOG.STRING(g_level_unexpected,
1072: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_gl.BEGIN',
1073: 'je_tax_extract.populate_je_gl(+)');
1074:
1075: FND_LOG.STRING(g_level_unexpected,
1076: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_gl.BEGIN',
1077: 'Before insertion into ZX_REP_TRX_JX_EXT_T - 1');
1078: END IF;
1079:

Line 1086: FND_LOG.STRING(g_level_unexpected,

1082: FROM zx_rep_trx_detail_t itf1
1083: WHERE itf1.request_id = P_TRL_GLOBAL_VARIABLES_REC.REQUEST_ID;
1084:
1085: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1086: FND_LOG.STRING(g_level_unexpected,
1087: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_gl.BEGIN',
1088: 'Count Before insertion - 1'||to_char(l_detail_tax_line_id_tbl.count));
1089: END IF;
1090:

Line 1120: FND_LOG.STRING(g_level_unexpected,

1116: AND itf1.trx_id = gjl.je_header_id
1117: AND itf1.trx_line_id = gjl.je_line_num;
1118:
1119: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1120: FND_LOG.STRING(g_level_unexpected,
1121: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_gl.BEGIN',
1122: 'No. of rows inserted into ZX_REP_TRX_JX_EXT_T - 1'||to_char(sql%ROWCOUNT));
1123: END IF;
1124:

Line 1143: FND_LOG.STRING(g_level_unexpected,

1139:
1140: l_count := nvl(L_DETAIL_TAX_LINE_ID_TBL.COUNT,0);
1141:
1142: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1143: FND_LOG.STRING(g_level_unexpected,
1144: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_gl.BEGIN',
1145: 'l_count : '||l_count);
1146: END IF;
1147:

Line 1236: FND_LOG.STRING(g_level_unexpected,

1232: END IF ;
1233:
1234:
1235: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1236: FND_LOG.STRING(g_level_unexpected,
1237: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_gl.BEGIN',
1238: 'Displaying the Vlaues for attributes : i :'||i);
1239: FND_LOG.STRING(g_level_unexpected,
1240: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_gl.BEGIN',

Line 1239: FND_LOG.STRING(g_level_unexpected,

1235: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1236: FND_LOG.STRING(g_level_unexpected,
1237: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_gl.BEGIN',
1238: 'Displaying the Vlaues for attributes : i :'||i);
1239: FND_LOG.STRING(g_level_unexpected,
1240: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_gl.BEGIN',
1241: 'L_DETAIL_TAX_LINE_ID_TBL(i)'||L_DETAIL_TAX_LINE_ID_TBL(i));
1242: FND_LOG.STRING(g_level_unexpected,
1243: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_gl.BEGIN',

Line 1242: FND_LOG.STRING(g_level_unexpected,

1238: 'Displaying the Vlaues for attributes : i :'||i);
1239: FND_LOG.STRING(g_level_unexpected,
1240: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_gl.BEGIN',
1241: 'L_DETAIL_TAX_LINE_ID_TBL(i)'||L_DETAIL_TAX_LINE_ID_TBL(i));
1242: FND_LOG.STRING(g_level_unexpected,
1243: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_gl.BEGIN',
1244: 'L_ATTRIBUTE1_TBL(i) :'||L_ATTRIBUTE1_TBL(i));
1245: FND_LOG.STRING(g_level_unexpected,
1246: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_gl.BEGIN',

Line 1245: FND_LOG.STRING(g_level_unexpected,

1241: 'L_DETAIL_TAX_LINE_ID_TBL(i)'||L_DETAIL_TAX_LINE_ID_TBL(i));
1242: FND_LOG.STRING(g_level_unexpected,
1243: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_gl.BEGIN',
1244: 'L_ATTRIBUTE1_TBL(i) :'||L_ATTRIBUTE1_TBL(i));
1245: FND_LOG.STRING(g_level_unexpected,
1246: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_gl.BEGIN',
1247: 'L_ATTRIBUTE2_TBL(i) :'||L_ATTRIBUTE2_TBL(i));
1248: FND_LOG.STRING(g_level_unexpected,
1249: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_gl.BEGIN',

Line 1248: FND_LOG.STRING(g_level_unexpected,

1244: 'L_ATTRIBUTE1_TBL(i) :'||L_ATTRIBUTE1_TBL(i));
1245: FND_LOG.STRING(g_level_unexpected,
1246: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_gl.BEGIN',
1247: 'L_ATTRIBUTE2_TBL(i) :'||L_ATTRIBUTE2_TBL(i));
1248: FND_LOG.STRING(g_level_unexpected,
1249: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_gl.BEGIN',
1250: 'L_ATTRIBUTE3_TBL(i) :'||L_ATTRIBUTE3_TBL(i));
1251: FND_LOG.STRING(g_level_unexpected,
1252: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_gl.BEGIN',

Line 1251: FND_LOG.STRING(g_level_unexpected,

1247: 'L_ATTRIBUTE2_TBL(i) :'||L_ATTRIBUTE2_TBL(i));
1248: FND_LOG.STRING(g_level_unexpected,
1249: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_gl.BEGIN',
1250: 'L_ATTRIBUTE3_TBL(i) :'||L_ATTRIBUTE3_TBL(i));
1251: FND_LOG.STRING(g_level_unexpected,
1252: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_gl.BEGIN',
1253: 'L_ATTRIBUTE4_TBL(i) :'||L_ATTRIBUTE4_TBL(i));
1254: FND_LOG.STRING(g_level_unexpected,
1255: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_gl.BEGIN',

Line 1254: FND_LOG.STRING(g_level_unexpected,

1250: 'L_ATTRIBUTE3_TBL(i) :'||L_ATTRIBUTE3_TBL(i));
1251: FND_LOG.STRING(g_level_unexpected,
1252: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_gl.BEGIN',
1253: 'L_ATTRIBUTE4_TBL(i) :'||L_ATTRIBUTE4_TBL(i));
1254: FND_LOG.STRING(g_level_unexpected,
1255: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_gl.BEGIN',
1256: 'L_ATTRIBUTE5_TBL(i) :'||L_ATTRIBUTE5_TBL(i));
1257: FND_LOG.STRING(g_level_unexpected,
1258: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_gl.BEGIN',

Line 1257: FND_LOG.STRING(g_level_unexpected,

1253: 'L_ATTRIBUTE4_TBL(i) :'||L_ATTRIBUTE4_TBL(i));
1254: FND_LOG.STRING(g_level_unexpected,
1255: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_gl.BEGIN',
1256: 'L_ATTRIBUTE5_TBL(i) :'||L_ATTRIBUTE5_TBL(i));
1257: FND_LOG.STRING(g_level_unexpected,
1258: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_gl.BEGIN',
1259: 'L_ATTRIBUTE6_TBL(i) :'||L_ATTRIBUTE6_TBL(i));
1260: FND_LOG.STRING(g_level_unexpected,
1261: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_gl.BEGIN',

Line 1260: FND_LOG.STRING(g_level_unexpected,

1256: 'L_ATTRIBUTE5_TBL(i) :'||L_ATTRIBUTE5_TBL(i));
1257: FND_LOG.STRING(g_level_unexpected,
1258: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_gl.BEGIN',
1259: 'L_ATTRIBUTE6_TBL(i) :'||L_ATTRIBUTE6_TBL(i));
1260: FND_LOG.STRING(g_level_unexpected,
1261: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_gl.BEGIN',
1262: 'L_ATTRIBUTE7_TBL(i) :'||L_ATTRIBUTE7_TBL(i));
1263: FND_LOG.STRING(g_level_unexpected,
1264: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_gl.BEGIN',

Line 1263: FND_LOG.STRING(g_level_unexpected,

1259: 'L_ATTRIBUTE6_TBL(i) :'||L_ATTRIBUTE6_TBL(i));
1260: FND_LOG.STRING(g_level_unexpected,
1261: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_gl.BEGIN',
1262: 'L_ATTRIBUTE7_TBL(i) :'||L_ATTRIBUTE7_TBL(i));
1263: FND_LOG.STRING(g_level_unexpected,
1264: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_gl.BEGIN',
1265: 'L_TAX_STATUS_CODE_TBL(i) :'||L_TAX_STATUS_CODE_TBL(i));
1266: FND_LOG.STRING(g_level_unexpected,
1267: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_gl.BEGIN',

Line 1266: FND_LOG.STRING(g_level_unexpected,

1262: 'L_ATTRIBUTE7_TBL(i) :'||L_ATTRIBUTE7_TBL(i));
1263: FND_LOG.STRING(g_level_unexpected,
1264: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_gl.BEGIN',
1265: 'L_TAX_STATUS_CODE_TBL(i) :'||L_TAX_STATUS_CODE_TBL(i));
1266: FND_LOG.STRING(g_level_unexpected,
1267: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_gl.BEGIN',
1268: 'L_TRX_BUSINESS_CATEGORY_TBL(i) :'||L_TRX_BUSINESS_CATEGORY_TBL(i));
1269: FND_LOG.STRING(g_level_unexpected,
1270: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_gl.BEGIN',

Line 1269: FND_LOG.STRING(g_level_unexpected,

1265: 'L_TAX_STATUS_CODE_TBL(i) :'||L_TAX_STATUS_CODE_TBL(i));
1266: FND_LOG.STRING(g_level_unexpected,
1267: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_gl.BEGIN',
1268: 'L_TRX_BUSINESS_CATEGORY_TBL(i) :'||L_TRX_BUSINESS_CATEGORY_TBL(i));
1269: FND_LOG.STRING(g_level_unexpected,
1270: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_gl.BEGIN',
1271: 'L_DOCUMENT_SUB_TYPE_TBL(i) :'||L_DOCUMENT_SUB_TYPE_TBL(i));
1272: END IF;
1273:

Line 1279: FND_LOG.STRING(g_level_unexpected,

1275:
1276: IF ( l_count > 0 ) THEN
1277:
1278: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1279: FND_LOG.STRING(g_level_unexpected,
1280: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_gl.BEGIN',
1281: 'Before Updating ZX_REP_TRX_JX_EXT_T with attribute columns obtained -GL ' );
1282: END IF;
1283:

Line 1303: FND_LOG.STRING(g_level_unexpected,

1299: WHERE detail_tax_line_id = L_DETAIL_TAX_LINE_ID_TBL(i) and
1300: request_id = P_TRL_GLOBAL_VARIABLES_REC.REQUEST_ID;
1301:
1302: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1303: FND_LOG.STRING(g_level_unexpected,
1304: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_gl.BEGIN',
1305: 'After Updating ZX_REP_TRX_JX_EXT_T with attribute columns obtained ' );
1306: END IF;
1307: -- exit when get_rep_entity_info_cur%NOTFOUND;

Line 1320: FND_LOG.STRING(g_level_unexpected,

1316: END IF ;
1317:
1318: commit;
1319: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1320: FND_LOG.STRING(g_level_unexpected,
1321: 'ZX.TRL.je_tax_extract.je_tax_extract.populate_je_gl.END',
1322: 'je_tax_extract.populate_je_gl(-)');
1323: END IF;
1324: