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

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

75: --Public Variable Declarations
76: -----------------------------------------
77: --
78: g_current_runtime_level NUMBER ;
79: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
80: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
81: g_level_event CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
82: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
83: g_error_buffer VARCHAR2(100);

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

76: -----------------------------------------
77: --
78: g_current_runtime_level NUMBER ;
79: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
80: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
81: g_level_event CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
82: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
83: g_error_buffer VARCHAR2(100);
84: -----------------------------------------

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

77: --
78: g_current_runtime_level NUMBER ;
79: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
80: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
81: g_level_event CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
82: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
83: g_error_buffer VARCHAR2(100);
84: -----------------------------------------
85: --Public Methods Declarations

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

78: g_current_runtime_level NUMBER ;
79: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
80: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
81: g_level_event CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
82: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
83: g_error_buffer VARCHAR2(100);
84: -----------------------------------------
85: --Public Methods Declarations
86: -----------------------------------------

Line 141: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

137: lp_count_taxable number(15);
138: l_insert_sql_string varchar2(1000);
139:
140: BEGIN
141: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
142: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
143: IF (g_level_statement >= g_current_runtime_level ) THEN
144: FND_LOG.STRING(g_level_statement,
145: 'ZX.TRL.ja_tax_extract.filter_ja_tax_lines.BEGIN',

Line 142: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

138: l_insert_sql_string varchar2(1000);
139:
140: BEGIN
141: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
142: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
143: IF (g_level_statement >= g_current_runtime_level ) THEN
144: FND_LOG.STRING(g_level_statement,
145: 'ZX.TRL.ja_tax_extract.filter_ja_tax_lines.BEGIN',
146: 'ja_tax_extract.filter_ja_tax_lines(+)');

Line 144: FND_LOG.STRING(g_level_statement,

140: BEGIN
141: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
142: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
143: IF (g_level_statement >= g_current_runtime_level ) THEN
144: FND_LOG.STRING(g_level_statement,
145: 'ZX.TRL.ja_tax_extract.filter_ja_tax_lines.BEGIN',
146: 'ja_tax_extract.filter_ja_tax_lines(+)');
147: END IF;
148:

Line 155: FND_LOG.STRING(g_level_statement,

151: -- ------------------------ --
152:
153: if P_TRL_GLOBAL_VARIABLES_REC.REPORT_NAME = 'ZXTWRVAT' then
154: IF (g_level_statement >= g_current_runtime_level ) THEN
155: FND_LOG.STRING(g_level_statement,
156: 'ZX.TRL.ja_tax_extract.filter_ja_tax_lines',
157: 'P_TRL_GLOBAL_VARIABLES_REC.BATCH_SOURCE_ID'||to_char(P_TRL_GLOBAL_VARIABLES_REC.BATCH_SOURCE_ID));
158: END IF;
159: /* Taiwanese Output VAT Report */

Line 168: FND_LOG.STRING(g_level_statement,

164: WHERE batch_source_Id = P_TRL_GLOBAL_VARIABLES_REC.BATCH_SOURCE_ID;
165:
166:
167: IF (g_level_statement >= g_current_runtime_level ) THEN
168: FND_LOG.STRING(g_level_statement,
169: 'ZX.TRL.ja_tax_extract.filter_ja_tax_lines',
170: 'batch_source_type'||l_loc_trx_src_type);
171: END IF;
172:

Line 190: FND_LOG.STRING(g_level_statement,

186: lp_where_inc_reference_source:= ' and 1 = 1';
187: end if;
188:
189: IF (g_level_statement >= g_current_runtime_level ) THEN
190: FND_LOG.STRING(g_level_statement,
191: 'ZX.TRL.ja_tax_extract.filter_ja_tax_lines',
192: 'lp_where_trx_source_id:'||lp_where_trx_source_id);
193: FND_LOG.STRING(g_level_statement,
194: 'ZX.TRL.ja_tax_extract.filter_ja_tax_lines',

Line 193: FND_LOG.STRING(g_level_statement,

189: IF (g_level_statement >= g_current_runtime_level ) THEN
190: FND_LOG.STRING(g_level_statement,
191: 'ZX.TRL.ja_tax_extract.filter_ja_tax_lines',
192: 'lp_where_trx_source_id:'||lp_where_trx_source_id);
193: FND_LOG.STRING(g_level_statement,
194: 'ZX.TRL.ja_tax_extract.filter_ja_tax_lines',
195: 'lp_where_inc_reference_source::'||lp_where_inc_reference_source);
196: END IF;
197:

Line 209: FND_LOG.STRING(g_level_statement,

205: lp_where_trx_source_id || '' || lp_where_inc_reference_source || '))';
206:
207:
208: IF (g_level_statement >= g_current_runtime_level ) THEN
209: FND_LOG.STRING(g_level_statement,
210: 'ZX.TRL.ja_tax_extract.filter_ja_tax_lines',
211: 'l_delete_sql_string::'||l_delete_sql_string);
212: END IF;
213:

Line 223: FND_LOG.STRING(g_level_statement,

219: DET.TRX_LINE_CLASS IN ('INVOICE', 'CREDIT_MEMO') and
220: DET.DOC_EVENT_STATUS <> 'CANCELLED' and ( DET.TRX_BATCH_SOURCE_ID = P_TRL_GLOBAL_VARIABLES_REC.BATCH_SOURCE_ID and 1 = 1));
221:
222: IF (g_level_statement >= g_current_runtime_level ) THEN
223: FND_LOG.STRING(g_level_statement,
224: 'ZX.TRL.ja_tax_extract.filter_ja_tax_lines',
225: 'l_delete_sql_string::'||l_delete_sql_string);
226: END IF;
227:

Line 301: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.filter_ja_ar_tax_lines',

297:
298: EXECUTE IMMEDIATE l_delete_sql_string;
299:
300: IF ( g_level_statement>= g_current_runtime_level ) THEN
301: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.filter_ja_ar_tax_lines',
302: 'Deleted Count : '||to_char(SQL%ROWCOUNT) );
303: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.filter_ja_ar_tax_lines',
304: ' l_delete_sql_string : '||l_delete_sql_string );
305:

Line 303: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.filter_ja_ar_tax_lines',

299:
300: IF ( g_level_statement>= g_current_runtime_level ) THEN
301: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.filter_ja_ar_tax_lines',
302: 'Deleted Count : '||to_char(SQL%ROWCOUNT) );
303: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.filter_ja_ar_tax_lines',
304: ' l_delete_sql_string : '||l_delete_sql_string );
305:
306: END IF;
307:

Line 346: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.filter_ja_ar_tax_lines',

342: lp_where_export_date_to ||
343: lp_where_export_method|| ')';
344:
345: IF ( g_level_statement>= g_current_runtime_level ) THEN
346: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.filter_ja_ar_tax_lines',
347: 'Deleted Count : '||to_char(SQL%ROWCOUNT) );
348: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.filter_ja_ar_tax_lines',
349: ' l_delete_sql_string : '||l_delete_sql_string );
350:

Line 348: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.filter_ja_ar_tax_lines',

344:
345: IF ( g_level_statement>= g_current_runtime_level ) THEN
346: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.filter_ja_ar_tax_lines',
347: 'Deleted Count : '||to_char(SQL%ROWCOUNT) );
348: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.filter_ja_ar_tax_lines',
349: ' l_delete_sql_string : '||l_delete_sql_string );
350:
351: END IF;
352:

Line 356: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.filter_ja_ar_tax_lines',

352:
353: EXECUTE IMMEDIATE l_delete_sql_string;
354:
355: IF ( g_level_statement>= g_current_runtime_level ) THEN
356: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.filter_ja_ar_tax_lines',
357: 'Deleted Count : '||to_char(SQL%ROWCOUNT) );
358: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.filter_ja_ar_tax_lines',
359: ' l_delete_sql_string : '||l_delete_sql_string );
360:

Line 358: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.filter_ja_ar_tax_lines',

354:
355: IF ( g_level_statement>= g_current_runtime_level ) THEN
356: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.filter_ja_ar_tax_lines',
357: 'Deleted Count : '||to_char(SQL%ROWCOUNT) );
358: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.filter_ja_ar_tax_lines',
359: ' l_delete_sql_string : '||l_delete_sql_string );
360:
361: END IF;
362:

Line 377: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.filter_ja_ar_tax_lines',

373: DET.EXTRACT_SOURCE_LEDGER = 'AR' and
374: substrb(DET.DOCUMENT_SUB_TYPE,10,2) IN ('33','34'));
375:
376: IF ( g_level_statement>= g_current_runtime_level ) THEN
377: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.filter_ja_ar_tax_lines',
378: 'Deleted Count : '||to_char(SQL%ROWCOUNT) );
379: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.filter_ja_ar_tax_lines',
380: ' l_delete_sql_string : '||l_delete_sql_string );
381:

Line 379: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.filter_ja_ar_tax_lines',

375:
376: IF ( g_level_statement>= g_current_runtime_level ) THEN
377: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.filter_ja_ar_tax_lines',
378: 'Deleted Count : '||to_char(SQL%ROWCOUNT) );
379: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.filter_ja_ar_tax_lines',
380: ' l_delete_sql_string : '||l_delete_sql_string );
381:
382: END IF;
383:

Line 422: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.filter_ja_ar_tax_lines',

418:
419:
420:
421: IF ( g_level_statement>= g_current_runtime_level ) THEN
422: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.filter_ja_ar_tax_lines',
423: 'Deleted Count : '||to_char(SQL%ROWCOUNT) );
424: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.filter_ja_ar_tax_lines',
425: ' l_delete_sql_string : '||l_delete_sql_string );
426:

Line 424: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.filter_ja_ar_tax_lines',

420:
421: IF ( g_level_statement>= g_current_runtime_level ) THEN
422: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.filter_ja_ar_tax_lines',
423: 'Deleted Count : '||to_char(SQL%ROWCOUNT) );
424: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.filter_ja_ar_tax_lines',
425: ' l_delete_sql_string : '||l_delete_sql_string );
426:
427: END IF;
428:

Line 432: FND_LOG.STRING(g_level_statement,

428:
429: end if;
430:
431: IF (g_level_statement >= g_current_runtime_level ) THEN
432: FND_LOG.STRING(g_level_statement,
433: 'ZX.TRL.ja_tax_extract.filter_ja_tax_lines.END',
434: 'ja_tax_extract.filter_ar_tax_lines(-)');
435: END IF;
436:

Line 440: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.filter_ja_ar_tax_lines',

436:
437: EXCEPTION
438: WHEN OTHERS THEN
439: IF ( g_level_statement>= g_current_runtime_level ) THEN
440: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.filter_ja_ar_tax_lines',
441: 'Error Message : '||substrb(SQLERRM,1,120) );
442: END IF;
443:
444: END filter_ja_ar_tax_lines;

Line 520: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

516: WHERE org_id = p_org_id;
517:
518:
519: BEGIN
520: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
521: IF (g_level_procedure >= g_current_runtime_level ) THEN
522: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_JA_EXTRACT_PKG.FILTER_JA_AP_TAX_LINES.BEGIN',
523: 'ZX_JA_EXTRACT_PKG.filter_ap_tax_lines(+)');
524: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_JA_EXTRACT_PKG.FILTER_JA_AP_TAX_LINES.BEGIN',

Line 522: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_JA_EXTRACT_PKG.FILTER_JA_AP_TAX_LINES.BEGIN',

518:
519: BEGIN
520: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
521: IF (g_level_procedure >= g_current_runtime_level ) THEN
522: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_JA_EXTRACT_PKG.FILTER_JA_AP_TAX_LINES.BEGIN',
523: 'ZX_JA_EXTRACT_PKG.filter_ap_tax_lines(+)');
524: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_JA_EXTRACT_PKG.FILTER_JA_AP_TAX_LINES.BEGIN',
525: 'P_TRL_GLOBAL_VARIABLES_REC.REPORT_NAME : '||P_TRL_GLOBAL_VARIABLES_REC.REPORT_NAME);
526: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_JA_EXTRACT_PKG.FILTER_JA_AP_TAX_LINES.BEGIN',

Line 524: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_JA_EXTRACT_PKG.FILTER_JA_AP_TAX_LINES.BEGIN',

520: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
521: IF (g_level_procedure >= g_current_runtime_level ) THEN
522: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_JA_EXTRACT_PKG.FILTER_JA_AP_TAX_LINES.BEGIN',
523: 'ZX_JA_EXTRACT_PKG.filter_ap_tax_lines(+)');
524: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_JA_EXTRACT_PKG.FILTER_JA_AP_TAX_LINES.BEGIN',
525: 'P_TRL_GLOBAL_VARIABLES_REC.REPORT_NAME : '||P_TRL_GLOBAL_VARIABLES_REC.REPORT_NAME);
526: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_JA_EXTRACT_PKG.FILTER_JA_AP_TAX_LINES.BEGIN',
527: 'P_TRL_GLOBAL_VARIABLES_REC.DOCUMENT_SUB_TYPE : '||P_TRL_GLOBAL_VARIABLES_REC.DOCUMENT_SUB_TYPE );
528:

Line 526: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_JA_EXTRACT_PKG.FILTER_JA_AP_TAX_LINES.BEGIN',

522: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_JA_EXTRACT_PKG.FILTER_JA_AP_TAX_LINES.BEGIN',
523: 'ZX_JA_EXTRACT_PKG.filter_ap_tax_lines(+)');
524: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_JA_EXTRACT_PKG.FILTER_JA_AP_TAX_LINES.BEGIN',
525: 'P_TRL_GLOBAL_VARIABLES_REC.REPORT_NAME : '||P_TRL_GLOBAL_VARIABLES_REC.REPORT_NAME);
526: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_JA_EXTRACT_PKG.FILTER_JA_AP_TAX_LINES.BEGIN',
527: 'P_TRL_GLOBAL_VARIABLES_REC.DOCUMENT_SUB_TYPE : '||P_TRL_GLOBAL_VARIABLES_REC.DOCUMENT_SUB_TYPE );
528:
529: END IF;
530:

Line 542: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.FILTER_JA_AP_TAX_LINES',

538: substrb(DET.DOCUMENT_SUB_TYPE, 10, 2) in ('21','22','23','24','25','26','27','28')
539: );
540:
541: IF ( g_level_statement>= g_current_runtime_level ) THEN
542: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.FILTER_JA_AP_TAX_LINES',
543: 'Deleted Count : '||to_char(SQL%ROWCOUNT) );
544: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.FILTER_JA_AP_TAX_LINES',
545: 'ja_tax_extract.filter_ja_tax_lines '||'l_delete_sql_string: ' || l_delete_sql_string);
546: END IF;

Line 544: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.FILTER_JA_AP_TAX_LINES',

540:
541: IF ( g_level_statement>= g_current_runtime_level ) THEN
542: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.FILTER_JA_AP_TAX_LINES',
543: 'Deleted Count : '||to_char(SQL%ROWCOUNT) );
544: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.FILTER_JA_AP_TAX_LINES',
545: 'ja_tax_extract.filter_ja_tax_lines '||'l_delete_sql_string: ' || l_delete_sql_string);
546: END IF;
547:
548: elsif P_TRL_GLOBAL_VARIABLES_REC.REPORT_NAME = 'ZXTWPSPC' then

Line 578: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.FILTER_JA_AP_TAX_LINES',

574:
575: EXECUTE IMMEDIATE l_delete_sql_string;
576:
577: IF ( g_level_statement>= g_current_runtime_level ) THEN
578: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.FILTER_JA_AP_TAX_LINES',
579: 'Deleted Count : '||to_char(SQL%ROWCOUNT) );
580: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.FILTER_JA_AP_TAX_LINES',
581: ' l_delete_sql_string : '||l_delete_sql_string );
582:

Line 580: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.FILTER_JA_AP_TAX_LINES',

576:
577: IF ( g_level_statement>= g_current_runtime_level ) THEN
578: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.FILTER_JA_AP_TAX_LINES',
579: 'Deleted Count : '||to_char(SQL%ROWCOUNT) );
580: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.FILTER_JA_AP_TAX_LINES',
581: ' l_delete_sql_string : '||l_delete_sql_string );
582:
583: END IF;
584:

Line 604: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.FILTER_JA_AP_TAX_LINES',

600:
601:
602:
603: IF ( g_level_statement>= g_current_runtime_level ) THEN
604: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.FILTER_JA_AP_TAX_LINES',
605: 'Deleted Count : '||to_char(SQL%ROWCOUNT) );
606: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.FILTER_JA_AP_TAX_LINES',
607: ' l_delete_sql_string : '||l_delete_sql_string );
608:

Line 606: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.FILTER_JA_AP_TAX_LINES',

602:
603: IF ( g_level_statement>= g_current_runtime_level ) THEN
604: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.FILTER_JA_AP_TAX_LINES',
605: 'Deleted Count : '||to_char(SQL%ROWCOUNT) );
606: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.FILTER_JA_AP_TAX_LINES',
607: ' l_delete_sql_string : '||l_delete_sql_string );
608:
609: END IF;
610:

Line 621: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.FILTER_JA_AP_TAX_LINES',

617: substrb(DET.DOCUMENT_SUB_TYPE,10,2) IN ('23','24') and
618: DET.CANCEL_FLAG <> 'Y'
619: );
620: IF ( g_level_statement>= g_current_runtime_level ) THEN
621: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.FILTER_JA_AP_TAX_LINES',
622: ' NULL supplier '||l_delete_sql_string );
623:
624: END IF;
625:

Line 627: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.FILTER_JA_AP_TAX_LINES',

623:
624: END IF;
625:
626: IF ( g_level_statement>= g_current_runtime_level ) THEN
627: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.FILTER_JA_AP_TAX_LINES',
628: 'Deleted Count : '||to_char(SQL%ROWCOUNT) );
629: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.FILTER_JA_AP_TAX_LINES',
630: ' l_delete_sql_string : '||l_delete_sql_string );
631:

Line 629: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.FILTER_JA_AP_TAX_LINES',

625:
626: IF ( g_level_statement>= g_current_runtime_level ) THEN
627: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.FILTER_JA_AP_TAX_LINES',
628: 'Deleted Count : '||to_char(SQL%ROWCOUNT) );
629: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.FILTER_JA_AP_TAX_LINES',
630: ' l_delete_sql_string : '||l_delete_sql_string );
631:
632: END IF;
633:

Line 644: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.FILTER_JA_AP_TAX_LINES',

640: DET.SUPPLIER_EXCHANGE_RATE IS NOT NULL and
641: DET.CURRENCY_CONVERSION_RATE is NOT NULL);
642:
643: IF ( g_level_statement>= g_current_runtime_level ) THEN
644: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.FILTER_JA_AP_TAX_LINES',
645: 'Deleted Count : '||to_char(SQL%ROWCOUNT) );
646: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.FILTER_JA_AP_TAX_LINES',
647: ' l_delete_sql_string : '||l_delete_sql_string );
648:

Line 646: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.FILTER_JA_AP_TAX_LINES',

642:
643: IF ( g_level_statement>= g_current_runtime_level ) THEN
644: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.FILTER_JA_AP_TAX_LINES',
645: 'Deleted Count : '||to_char(SQL%ROWCOUNT) );
646: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.FILTER_JA_AP_TAX_LINES',
647: ' l_delete_sql_string : '||l_delete_sql_string );
648:
649: END IF;
650:

Line 704: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.FILTER_JA_AP_TAX_LINES',

700: -- EXECUTE IMMEDIATE l_delete_sql_string;
701:
702:
703: IF ( g_level_statement>= g_current_runtime_level ) THEN
704: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.FILTER_JA_AP_TAX_LINES',
705: 'Deleted Count : '||to_char(SQL%ROWCOUNT) );
706: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.FILTER_JA_AP_TAX_LINES',
707: ' l_delete_sql_string : '||l_delete_sql_string );
708:

Line 706: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.FILTER_JA_AP_TAX_LINES',

702:
703: IF ( g_level_statement>= g_current_runtime_level ) THEN
704: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.FILTER_JA_AP_TAX_LINES',
705: 'Deleted Count : '||to_char(SQL%ROWCOUNT) );
706: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.FILTER_JA_AP_TAX_LINES',
707: ' l_delete_sql_string : '||l_delete_sql_string );
708:
709: END IF;
710:

Line 714: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_JA_EXTRACT_PKG.FILTER_JA_AP_TAX_LINES.END',

710:
711: end if;
712:
713: IF (g_level_procedure >= g_current_runtime_level ) THEN
714: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_JA_EXTRACT_PKG.FILTER_JA_AP_TAX_LINES.END',
715: 'ZX_JA_EXTRACT_PKG.filter_ap_tax_lines(-):');
716: END IF;
717:
718: EXCEPTION

Line 721: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.FILTER_JA_AP_TAX_LINES',

717:
718: EXCEPTION
719: WHEN OTHERS THEN
720: IF ( g_level_statement>= g_current_runtime_level ) THEN
721: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.FILTER_JA_AP_TAX_LINES',
722: 'Error Message for report : '||substrb(SQLERRM,1,120) );
723: END IF;
724:
725: END filter_ja_ap_tax_lines;

Line 889: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

885: l_trx_date DATE;
886:
887: BEGIN
888:
889: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
890: IF (g_level_statement >= g_current_runtime_level ) THEN
891: FND_LOG.STRING(g_level_statement,
892: 'ZX.TRL.ja_tax_extract.ja_tax_extract.populate_ja_ar.BEGIN',
893: 'ja_tax_extract.populate_ja_ar(+)');

Line 891: FND_LOG.STRING(g_level_statement,

887: BEGIN
888:
889: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
890: IF (g_level_statement >= g_current_runtime_level ) THEN
891: FND_LOG.STRING(g_level_statement,
892: 'ZX.TRL.ja_tax_extract.ja_tax_extract.populate_ja_ar.BEGIN',
893: 'ja_tax_extract.populate_ja_ar(+)');
894: END IF;
895:

Line 897: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.populate_ja_ar',

893: 'ja_tax_extract.populate_ja_ar(+)');
894: END IF;
895:
896: IF ( g_level_statement>= g_current_runtime_level ) THEN
897: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.populate_ja_ar',
898: 'P_TRL_GLOBAL_VARIABLES_REC.REPORT_NAME : '||P_TRL_GLOBAL_VARIABLES_REC.REPORT_NAME );
899: END IF;
900:
901:

Line 922: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.populate_ja_ar',

918: FROM zx_rep_trx_detail_t itf1
919: WHERE itf1.request_id = P_TRL_GLOBAL_VARIABLES_REC.REQUEST_ID;
920:
921: IF ( g_level_statement>= g_current_runtime_level ) THEN
922: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.populate_ja_ar',
923: 'Count fetched : '||to_char(nvl(l_detail_tax_line_id_tbl.count,0)) );
924: END IF;
925:
926: P_LOOKUP_CODE:= NULL;

Line 944: FND_LOG.STRING(g_level_statement,

940: -- select translate(l_trx_business_category_tbl(i), '0123456789.ABCDEFGHIJKLMNOPQRSTUVWXYZ', '0123456789') into P_LOOKUP_CODE from dual;
941: p_lookup_code := l_trx_business_category_tbl(i);
942: X_DEDUCTIBLE_TYPE_TBL(i):= GET_LOOKUP_INFO(P_LOOKUP_TYPE, P_LOOKUP_CODE,l_trx_date_tbl(i));
943: IF (g_level_statement >= g_current_runtime_level ) THEN
944: FND_LOG.STRING(g_level_statement,
945: 'ZX.TRL.ja_tax_extract.ja_tax_extract.populate_ja_ar',
946: 'P_LOOKUP_CODE:'||P_LOOKUP_CODE||'-'||l_tax_status_code_tbl(i));
947: END IF;
948:

Line 1004: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.populate_ja_ar',

1000: END IF;
1001:
1002: --Bug 5251425 : To get the taiwan specific date format.
1003: IF ( g_level_statement>= g_current_runtime_level ) THEN
1004: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.populate_ja_ar',
1005: 'Before call to fnd_date.date_to_canonical to get canonical date format ');
1006: END IF;
1007: l_canonical_date := fnd_date.date_to_canonical(l_trx_date_tbl(i));
1008: l_roc_year := TO_NUMBER(SUBSTRB(l_canonical_date,1,4)) - 1911;

Line 1053: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.populate_ja_ar',

1049: fnd_global.login_id,
1050: p_trl_global_variables_rec.request_id);
1051:
1052: IF ( g_level_statement>= g_current_runtime_level ) THEN
1053: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.populate_ja_ar',
1054: 'After insertion into zx_rep_trx_jx_ext_t ');
1055: END IF;
1056: elsif P_TRL_GLOBAL_VARIABLES_REC.REPORT_NAME = 'ZXTWRZTR' and l_detail_tax_line_id_tbl.count <> 0 then
1057:

Line 1120: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.populate_ja_ar',

1116: fnd_global.login_id,
1117: p_trl_global_variables_rec.request_id);
1118:
1119: IF ( g_level_statement>= g_current_runtime_level ) THEN
1120: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.populate_ja_ar',
1121: 'After insertion into zx_rep_trx_jx_ext_t ');
1122: END IF;
1123: elsif P_TRL_GLOBAL_VARIABLES_REC.REPORT_NAME = 'ZXTWSEDI' and l_detail_tax_line_id_tbl.count <> 0 then
1124: INSERT INTO ZX_REP_TRX_JX_EXT_T(

Line 1153: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.populate_ja_ar',

1149: and types.cust_trx_type_id = dtl.trx_type_id
1150: and types.org_id = dtl.internal_organization_id ;
1151:
1152: IF ( g_level_statement>= g_current_runtime_level ) THEN
1153: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.populate_ja_ar',
1154: 'After insertion into zx_rep_trx_jx_ext_t ');
1155: END IF;
1156: elsif P_TRL_GLOBAL_VARIABLES_REC.REPORT_NAME = 'RXZXKVAT' THEN
1157:

Line 1202: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.populate_ja_ar',

1198: AND dtl.application_id in (222,101)
1199: AND dtl.request_id = p_trl_global_variables_rec.request_id ;
1200:
1201: IF ( g_level_statement>= g_current_runtime_level ) THEN
1202: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.populate_ja_ar',
1203: 'Reporting Type Query Count : '||to_char(nvl(l_detail_tax_line_id_tbl.count,0)) );
1204:
1205: END IF;
1206:

Line 1226: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.populate_ja_ar',

1222: AND dtl.application_id = 222
1223: AND dtl.request_id = p_trl_global_variables_rec.request_id ;
1224:
1225: IF ( g_level_statement>= g_current_runtime_level ) THEN
1226: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.populate_ja_ar',
1227: 'AR Industry Class Query Count: '||to_char(nvl(l_ind_classif_tbl.count,0)) );
1228: END IF;
1229: END IF;
1230:

Line 1283: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.populate_ja_ar',

1279: bank_info(P_TRL_GLOBAL_VARIABLES_REC);
1280: end if;
1281:
1282: IF ( g_level_statement>= g_current_runtime_level ) THEN
1283: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.populate_ja_ar',
1284: 'After insertion into zx_rep_trx_jx_ext_t ');
1285: END IF;
1286:
1287: IF (g_level_procedure >= g_current_runtime_level ) THEN

Line 1288: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_JA_EXTRACT_PKG.populate_ja_ar.END',

1284: 'After insertion into zx_rep_trx_jx_ext_t ');
1285: END IF;
1286:
1287: IF (g_level_procedure >= g_current_runtime_level ) THEN
1288: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_JA_EXTRACT_PKG.populate_ja_ar.END',
1289: 'ZX_JA_EXTRACT_PKG.populate_ja_ar(-)');
1290: END IF;
1291:
1292: EXCEPTION

Line 1295: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.populate_ja_ar',

1291:
1292: EXCEPTION
1293: WHEN OTHERS THEN
1294: IF ( g_level_statement>= g_current_runtime_level ) THEN
1295: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.populate_ja_ar',
1296: 'Error Message for report : '||substrb(SQLERRM,1,120) );
1297: END IF;
1298:
1299: END populate_ja_ar;

Line 1450: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1446:
1447:
1448: BEGIN
1449:
1450: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1451:
1452: IF (g_level_procedure >= g_current_runtime_level ) THEN
1453: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JA_AP.BEGIN',
1454: 'ZX_JA_EXTRACT_PKG.POPULATE_JA_AP(+)');

Line 1453: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JA_AP.BEGIN',

1449:
1450: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1451:
1452: IF (g_level_procedure >= g_current_runtime_level ) THEN
1453: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JA_AP.BEGIN',
1454: 'ZX_JA_EXTRACT_PKG.POPULATE_JA_AP(+)');
1455: END IF;
1456:
1457: SELECT detail_tax_line_id,

Line 1493: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JA_AP',

1489: FROM zx_rep_trx_detail_t itf1
1490: WHERE itf1.request_id = P_TRL_GLOBAL_VARIABLES_REC.REQUEST_ID;
1491:
1492: IF ( g_level_statement>= g_current_runtime_level ) THEN
1493: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JA_AP',
1494: 'Count fetched : '||to_char(nvl(l_detail_tax_line_id_tbl.count,0)) );
1495: END IF;
1496:
1497: P_LOOKUP_CODE:= NULL;

Line 1501: FND_LOG.STRING(g_level_statement,

1497: P_LOOKUP_CODE:= NULL;
1498:
1499: if P_TRL_GLOBAL_VARIABLES_REC.REPORT_NAME = ('ZXTWPVAT') and l_detail_tax_line_id_tbl.count <> 0 then
1500: IF (g_level_statement >= g_current_runtime_level ) THEN
1501: FND_LOG.STRING(g_level_statement,
1502: 'ZX.TRL.ja_tax_extract.populate_ja_ap',
1503: 'ZXTWPVAT');
1504: END IF;
1505: /****** Populate the missing columns ********/

Line 1513: FND_LOG.STRING(g_level_statement,

1509: P_LOOKUP_CODE:= l_tax_status_code_tbl(i); --Bug 5438409
1510: -- P_LOOKUP_CODE:=l_tax_status_id_tbl(i);
1511:
1512: IF (g_level_statement >= g_current_runtime_level ) THEN
1513: FND_LOG.STRING(g_level_statement,
1514: 'ZX.TRL.ja_tax_extract.populate_ja_ap',
1515: 'P_LOOKUP_CODE:'||P_LOOKUP_CODE||'-'||to_char(l_tax_status_id_tbl(i)));
1516: END IF;
1517:

Line 1553: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JA_AP',

1549: fnd_global.login_id,
1550: p_trl_global_variables_rec.request_id);
1551:
1552: IF ( g_level_statement>= g_current_runtime_level ) THEN
1553: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JA_AP',
1554: 'After insertion into zx_rep_trx_jx_ext_t ');
1555: END IF;
1556: elsif P_TRL_GLOBAL_VARIABLES_REC.REPORT_NAME = 'ZXTWSPRF' and l_detail_tax_line_id_tbl.count <> 0 then
1557:

Line 1561: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JA_AP',

1557:
1558: /****** Populate the missing columns ********/
1559: FOR i in 1 .. nvl(l_detail_tax_line_id_tbl.count,0) LOOP
1560: IF ( g_level_statement>= g_current_runtime_level ) THEN
1561: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JA_AP',
1562: 'Processing detail_tax_line_id : '||l_detail_tax_line_id_tbl(i)||' trx id : '||l_trx_id_tbl(i));
1563: END IF;
1564:
1565: P_LOOKUP_TYPE:= 'JATW_GUI_TYPE';

Line 1572: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JA_AP',

1568: p_lookup_code := l_document_sub_type_tbl(i);
1569: X_GUI_TYPE_TBL(i):= GET_LOOKUP_INFO(P_LOOKUP_TYPE, P_LOOKUP_CODE, l_trx_date_tbl(i));
1570:
1571: IF ( g_level_statement>= g_current_runtime_level ) THEN
1572: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JA_AP',
1573: 'Debug 1');
1574: END IF;
1575:
1576: P_LOOKUP_TYPE:= 'JATW_GOVERNMENT_TAX_TYPE';

Line 1581: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JA_AP',

1577: P_LOOKUP_CODE:= l_tax_status_code_tbl(i);
1578: X_GOVERNMENT_TAX_TYPE_TBL(i):= GET_LOOKUP_INFO(P_LOOKUP_TYPE, P_LOOKUP_CODE, l_trx_date_tbl(i));
1579:
1580: IF ( g_level_statement>= g_current_runtime_level ) THEN
1581: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JA_AP',
1582: 'Debug 2');
1583: END IF;
1584:
1585: P_LOOKUP_TYPE:= 'JATW_DEDUCTIBLE_TYPE';

Line 1592: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JA_AP',

1588: -- select translate(l_trx_business_category_tbl(i), '0123456789.ABCDEFGHIJKLMNOPQRSTUVWXYZ', '0123456789') into P_LOOKUP_CODE from dual;
1589: X_DEDUCTIBLE_TYPE_TBL(i):= GET_LOOKUP_INFO(P_LOOKUP_TYPE, P_LOOKUP_CODE, l_trx_date_tbl(i));
1590:
1591: IF ( g_level_statement>= g_current_runtime_level ) THEN
1592: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JA_AP',
1593: 'Debug 3');
1594: END IF;
1595:
1596: END LOOP;

Line 1601: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JA_AP',

1597:
1598: /****** Bulk Insert into Ext Table *******/
1599:
1600: IF ( g_level_statement>= g_current_runtime_level ) THEN
1601: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JA_AP',
1602: 'Before into zx_rep_trx_jx_ext_t ap ');
1603: END IF;
1604:
1605: FORALL i in 1 .. nvl(l_detail_tax_line_id_tbl.last, 0)

Line 1632: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JA_AP',

1628: fnd_global.login_id,
1629: p_trl_global_variables_rec.request_id);
1630:
1631: IF ( g_level_statement>= g_current_runtime_level ) THEN
1632: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JA_AP',
1633: 'After insertion into zx_rep_trx_jx_ext_t ');
1634: END IF;
1635: elsif P_TRL_GLOBAL_VARIABLES_REC.REPORT_NAME = ('ZXTWPSPC') and l_detail_tax_line_id_tbl.count <> 0 then
1636:

Line 1689: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JA_AP',

1685: fnd_global.login_id,
1686: p_trl_global_variables_rec.request_id);
1687:
1688: IF ( g_level_statement>= g_current_runtime_level ) THEN
1689: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JA_AP',
1690: 'After insertion into zx_rep_trx_jx_ext_t ');
1691: END IF;
1692: elsif P_TRL_GLOBAL_VARIABLES_REC.REPORT_NAME = 'ZXTWPPRD' and l_detail_tax_line_id_tbl.count <> 0 then
1693:

Line 1732: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JA_AP',

1728: fnd_global.login_id,
1729: p_trl_global_variables_rec.request_id);
1730:
1731: IF ( g_level_statement>= g_current_runtime_level ) THEN
1732: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JA_AP',
1733: 'After insertion into zx_rep_trx_jx_ext_t ');
1734: END IF;
1735:
1736: ELSIF P_TRL_GLOBAL_VARIABLES_REC.REPORT_NAME = 'ZXTWSEDI' AND l_detail_tax_line_id_tbl.count <> 0 then

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

1735:
1736: ELSIF P_TRL_GLOBAL_VARIABLES_REC.REPORT_NAME = 'ZXTWSEDI' AND l_detail_tax_line_id_tbl.count <> 0 then
1737:
1738: IF ( g_level_statement>= g_current_runtime_level ) THEN
1739: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JE_AP',
1740: 'P_TRL_GLOBAL_VARIABLES_REC.REPORT_NAME : '||P_TRL_GLOBAL_VARIABLES_REC.REPORT_NAME);
1741: END IF;
1742:
1743: INSERT INTO zx_rep_trx_jx_ext_t (

Line 1801: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JA_AP',

1797: FOR i in 1 .. nvl(l_detail_tax_line_id_tbl.count,0) LOOP
1798: k:= to_number(to_char(l_trx_id_tbl(i))||to_char(l_trx_line_id_tbl(i)));
1799:
1800: IF ( g_level_statement>= g_current_runtime_level ) THEN
1801: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JA_AP',
1802: 'l_trx_id_tbl(i) : '||l_trx_id_tbl(i));
1803: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JA_AP',
1804: 'l_trx_line_id_tbl(i) : '||l_trx_line_id_tbl(i));
1805: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JA_AP',

Line 1803: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JA_AP',

1799:
1800: IF ( g_level_statement>= g_current_runtime_level ) THEN
1801: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JA_AP',
1802: 'l_trx_id_tbl(i) : '||l_trx_id_tbl(i));
1803: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JA_AP',
1804: 'l_trx_line_id_tbl(i) : '||l_trx_line_id_tbl(i));
1805: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JA_AP',
1806: 'i : '||i||' k : '||k);
1807: END IF;

Line 1805: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JA_AP',

1801: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JA_AP',
1802: 'l_trx_id_tbl(i) : '||l_trx_id_tbl(i));
1803: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JA_AP',
1804: 'l_trx_line_id_tbl(i) : '||l_trx_line_id_tbl(i));
1805: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JA_AP',
1806: 'i : '||i||' k : '||k);
1807: END IF;
1808:
1809: IF L_INHOUSE_INV_AMT_TBL.EXISTS(k) THEN

Line 1816: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JA_AP',

1812: L_INHOUSE_INV_AMT_TBL(k) := null;
1813: END IF;
1814:
1815: IF ( g_level_statement>= g_current_runtime_level ) THEN
1816: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JA_AP',
1817: 'L_INHOUSE_INV_AMT_TBL(k) : '||L_INHOUSE_INV_AMT_TBL(k));
1818: END IF;
1819:
1820: IF L_INHOUSE_INV_AMT_TBL(k) is NULL THEN

Line 1838: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JA_AP',

1834: X_SUPPLIER_INV_AMT_TBL(i):=L_SUPPLIER_INV_AMT_TBL(k);
1835: X_TAXABLE_GAINLOSS_TBL(i):= L_TAXABLE_GAINLOSS_TBL(k);
1836:
1837: IF ( g_level_statement>= g_current_runtime_level ) THEN
1838: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JA_AP',
1839: 'X_INHOUSE_INV_AMT_TBL(i) : '||X_INHOUSE_INV_AMT_TBL(i));
1840: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JA_AP',
1841: 'X_SUPPLIER_INV_AMT_TBL(i) : '||X_SUPPLIER_INV_AMT_TBL(i));
1842: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JA_AP',

Line 1840: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JA_AP',

1836:
1837: IF ( g_level_statement>= g_current_runtime_level ) THEN
1838: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JA_AP',
1839: 'X_INHOUSE_INV_AMT_TBL(i) : '||X_INHOUSE_INV_AMT_TBL(i));
1840: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JA_AP',
1841: 'X_SUPPLIER_INV_AMT_TBL(i) : '||X_SUPPLIER_INV_AMT_TBL(i));
1842: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JA_AP',
1843: 'X_TAXABLE_GAINLOSS_TBL(i) : '||X_TAXABLE_GAINLOSS_TBL(i));
1844: END IF;

Line 1842: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JA_AP',

1838: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JA_AP',
1839: 'X_INHOUSE_INV_AMT_TBL(i) : '||X_INHOUSE_INV_AMT_TBL(i));
1840: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JA_AP',
1841: 'X_SUPPLIER_INV_AMT_TBL(i) : '||X_SUPPLIER_INV_AMT_TBL(i));
1842: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JA_AP',
1843: 'X_TAXABLE_GAINLOSS_TBL(i) : '||X_TAXABLE_GAINLOSS_TBL(i));
1844: END IF;
1845:
1846: X_INHOUSE_TAX_AMT_TBL(i):= round(l_tax_amt_tbl(i) *

Line 1853: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JA_AP',

1849: to_number(nvl(l_supplier_exchange_rate_tbl(i),1)), l_precision_tbl(i));
1850: X_TAX_GAINLOSS_TBL(i):= X_INHOUSE_TAX_AMT_TBL(i) - X_SUPPLIER_TAX_AMT_TBL(i);
1851:
1852: IF ( g_level_statement>= g_current_runtime_level ) THEN
1853: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JA_AP',
1854: 'X_INHOUSE_TAX_AMT_TBL(i) : '||X_INHOUSE_TAX_AMT_TBL(i));
1855: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JA_AP',
1856: 'X_SUPPLIER_TAX_AMT_TBL(i) : '||X_SUPPLIER_TAX_AMT_TBL(i));
1857: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JA_AP',

Line 1855: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JA_AP',

1851:
1852: IF ( g_level_statement>= g_current_runtime_level ) THEN
1853: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JA_AP',
1854: 'X_INHOUSE_TAX_AMT_TBL(i) : '||X_INHOUSE_TAX_AMT_TBL(i));
1855: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JA_AP',
1856: 'X_SUPPLIER_TAX_AMT_TBL(i) : '||X_SUPPLIER_TAX_AMT_TBL(i));
1857: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JA_AP',
1858: 'X_TAX_GAINLOSS_TBL(i) : '||X_TAX_GAINLOSS_TBL(i));
1859: END IF;

Line 1857: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JA_AP',

1853: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JA_AP',
1854: 'X_INHOUSE_TAX_AMT_TBL(i) : '||X_INHOUSE_TAX_AMT_TBL(i));
1855: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JA_AP',
1856: 'X_SUPPLIER_TAX_AMT_TBL(i) : '||X_SUPPLIER_TAX_AMT_TBL(i));
1857: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JA_AP',
1858: 'X_TAX_GAINLOSS_TBL(i) : '||X_TAX_GAINLOSS_TBL(i));
1859: END IF;
1860:
1861: /*

Line 1911: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JA_AP',

1907: fnd_global.login_id,
1908: p_trl_global_variables_rec.request_id);
1909:
1910: IF ( g_level_statement>= g_current_runtime_level ) THEN
1911: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JA_AP',
1912: 'After insertion into zx_rep_trx_jx_ext_t ');
1913: END IF;
1914:
1915:

Line 1962: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.populate_ja_ar',

1958: AND dtl.application_id = 200
1959: AND dtl.request_id = p_trl_global_variables_rec.request_id ;
1960:
1961: IF ( g_level_statement>= g_current_runtime_level ) THEN
1962: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.populate_ja_ar',
1963: 'Reporting Types Query Count : '||to_char(nvl(l_detail_tax_line_id_tbl.count,0)) );
1964:
1965: END IF;
1966:

Line 1980: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.populate_ja_ar',

1976: AND dtl.application_id = 200
1977: AND dtl.request_id = p_trl_global_variables_rec.request_id ;
1978:
1979: IF ( g_level_statement>= g_current_runtime_level ) THEN
1980: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.populate_ja_ar',
1981: 'AP Industry Class Query Count: '||to_char(nvl(l_ind_classif_tbl.count,0)) );
1982: END IF;
1983:
1984:

Line 2034: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JA_AP.END',

2030:
2031: end if;
2032:
2033: IF (g_level_procedure >= g_current_runtime_level ) THEN
2034: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JA_AP.END',
2035: 'ZX_JA_EXTRACT_PKG.POPULATE_JA_AP(-)');
2036: END IF;
2037:
2038: EXCEPTION

Line 2042: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JA_AP',

2038: EXCEPTION
2039: WHEN OTHERS THEN
2040:
2041: IF ( g_level_statement>= g_current_runtime_level ) THEN
2042: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JA_AP',
2043: 'Error Message for report : '||substrb(SQLERRM,1,120) );
2044: END IF;
2045: END populate_ja_ap;
2046:

Line 2082: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

2078:
2079: x_lookup_meaning VARCHAR2(80);
2080:
2081: BEGIN
2082: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2083:
2084: IF (g_level_statement >= g_current_runtime_level ) THEN
2085: FND_LOG.STRING(g_level_statement,
2086: 'ZX.TRL.ja_tax_extract.get_lookup_info',

Line 2085: FND_LOG.STRING(g_level_statement,

2081: BEGIN
2082: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2083:
2084: IF (g_level_statement >= g_current_runtime_level ) THEN
2085: FND_LOG.STRING(g_level_statement,
2086: 'ZX.TRL.ja_tax_extract.get_lookup_info',
2087: 'x_lookup_meaning:'||x_lookup_meaning);
2088: END IF;
2089:

Line 2091: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_JA_EXTRACT_PKG',

2087: 'x_lookup_meaning:'||x_lookup_meaning);
2088: END IF;
2089:
2090: IF (g_level_procedure >= g_current_runtime_level ) THEN
2091: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_JA_EXTRACT_PKG',
2092: 'GET_LOOKUP_INFO(+)');
2093: END IF;
2094:
2095: IF ( g_level_statement>= g_current_runtime_level ) THEN

Line 2096: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JA_AP',

2092: 'GET_LOOKUP_INFO(+)');
2093: END IF;
2094:
2095: IF ( g_level_statement>= g_current_runtime_level ) THEN
2096: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JA_AP',
2097: ' P_LOOKUP_TYPE : '||P_LOOKUP_TYPE );
2098: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JA_AP',
2099: ' P_LOOKUP_CODE : '||P_LOOKUP_CODE );
2100: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JA_AP',

Line 2098: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JA_AP',

2094:
2095: IF ( g_level_statement>= g_current_runtime_level ) THEN
2096: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JA_AP',
2097: ' P_LOOKUP_TYPE : '||P_LOOKUP_TYPE );
2098: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JA_AP',
2099: ' P_LOOKUP_CODE : '||P_LOOKUP_CODE );
2100: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JA_AP',
2101: ' LANG : '||userenv('LANG') );
2102: END IF;

Line 2100: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JA_AP',

2096: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JA_AP',
2097: ' P_LOOKUP_TYPE : '||P_LOOKUP_TYPE );
2098: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JA_AP',
2099: ' P_LOOKUP_CODE : '||P_LOOKUP_CODE );
2100: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JA_AP',
2101: ' LANG : '||userenv('LANG') );
2102: END IF;
2103:
2104: IF P_LOOKUP_TYPE = 'JATW_GUI_TYPE' then

Line 2164: FND_LOG.STRING(g_level_statement,

2160: END IF;
2161:
2162:
2163: IF (g_level_statement >= g_current_runtime_level ) THEN
2164: FND_LOG.STRING(g_level_statement,
2165: 'ZX.TRL.ja_tax_extract.get_lookup_info',
2166: 'x_lookup_meaning:'||x_lookup_meaning);
2167: END IF;
2168:

Line 2170: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_JA_EXTRACT_PKG',

2166: 'x_lookup_meaning:'||x_lookup_meaning);
2167: END IF;
2168:
2169: IF (g_level_procedure >= g_current_runtime_level ) THEN
2170: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_JA_EXTRACT_PKG',
2171: 'GET_LOOKUP_INFO(-)');
2172: END IF;
2173:
2174: return (X_LOOKUP_MEANING);

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

2179: return (NULL);
2180:
2181: WHEN OTHERS THEN
2182: IF ( g_level_statement>= g_current_runtime_level ) THEN
2183: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG',
2184: 'Error Message : '||substrb(SQLERRM,1,120) );
2185: END IF;
2186: return (NULL);
2187:

Line 2227: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_JA_EXTRACT_PKG',

2223: IS
2224: BEGIN
2225:
2226: IF (g_level_procedure >= g_current_runtime_level ) THEN
2227: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_JA_EXTRACT_PKG',
2228: 'GET_INVOICE_AMT(+)');
2229: END IF;
2230:
2231: IF ( g_level_statement>= g_current_runtime_level ) THEN

Line 2232: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JA_AP',

2228: 'GET_INVOICE_AMT(+)');
2229: END IF;
2230:
2231: IF ( g_level_statement>= g_current_runtime_level ) THEN
2232: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JA_AP',
2233: ' P_VENDOR_ID : '||P_VENDOR_ID );
2234: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JA_AP',
2235: ' P_INVOICE_NUM : '||P_INVOICE_NUM );
2236: END IF;

Line 2234: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JA_AP',

2230:
2231: IF ( g_level_statement>= g_current_runtime_level ) THEN
2232: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JA_AP',
2233: ' P_VENDOR_ID : '||P_VENDOR_ID );
2234: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JA_AP',
2235: ' P_INVOICE_NUM : '||P_INVOICE_NUM );
2236: END IF;
2237:
2238: SELECT AI.GLOBAL_ATTRIBUTE4, AI.INVOICE_AMOUNT, AI.BASE_AMOUNT

Line 2245: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JA_AP',

2241: WHERE AI.VENDOR_ID = P_VENDOR_ID and
2242: AI.INVOICE_NUM = P_INVOICE_NUM;
2243:
2244: IF ( g_level_statement>= g_current_runtime_level ) THEN
2245: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JA_AP',
2246: ' X_INVOICE_AMT : '||X_INVOICE_AMT );
2247: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JA_AP',
2248: ' X_BASE_AMT : '||X_BASE_AMT );
2249: END IF;

Line 2247: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JA_AP',

2243:
2244: IF ( g_level_statement>= g_current_runtime_level ) THEN
2245: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JA_AP',
2246: ' X_INVOICE_AMT : '||X_INVOICE_AMT );
2247: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JA_AP',
2248: ' X_BASE_AMT : '||X_BASE_AMT );
2249: END IF;
2250:
2251: IF (g_level_procedure >= g_current_runtime_level ) THEN

Line 2252: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_JA_EXTRACT_PKG',

2248: ' X_BASE_AMT : '||X_BASE_AMT );
2249: END IF;
2250:
2251: IF (g_level_procedure >= g_current_runtime_level ) THEN
2252: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_JA_EXTRACT_PKG',
2253: 'GET_INVOICE_AMT(-)');
2254: END IF;
2255:
2256:

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

2257: EXCEPTION
2258:
2259: WHEN NO_DATA_FOUND THEN
2260: IF ( g_level_statement>= g_current_runtime_level ) THEN
2261: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG',
2262: 'Error Message : '||substrb(SQLERRM,1,120) );
2263: END IF;
2264:
2265: END get_invoice_amt;

Line 2306: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_JA_EXTRACT_PKG',

2302:
2303: BEGIN
2304:
2305: IF (g_level_procedure >= g_current_runtime_level ) THEN
2306: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_JA_EXTRACT_PKG',
2307: 'GET_GUI_SOURCE(+)');
2308: END IF;
2309:
2310: IF ( g_level_statement>= g_current_runtime_level ) THEN

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

2307: 'GET_GUI_SOURCE(+)');
2308: END IF;
2309:
2310: IF ( g_level_statement>= g_current_runtime_level ) THEN
2311: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG',
2312: ' P_TRX_SOURCE_NAME : '||P_TRX_SOURCE_NAME );
2313: END IF;
2314:
2315: IF P_TRX_SOURCE_NAME is not null THEN

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

2319: FROM ra_batch_sources src
2320: WHERE src.name = P_TRX_SOURCE_NAME;
2321:
2322: IF ( g_level_statement>= g_current_runtime_level ) THEN
2323: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG',
2324: ' X_GDF_RA_BATCH_SOURCES_ATT1 : '||X_GDF_RA_BATCH_SOURCES_ATT1 );
2325: END IF;
2326:
2327: SELECT substr(global_attribute3,1,2),

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

2335:
2336: END IF;
2337:
2338: IF ( g_level_statement>= g_current_runtime_level ) THEN
2339: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG',
2340: ' X_GDF_RA_BATCH_SOURCES_ATT2 : '||X_GDF_RA_BATCH_SOURCES_ATT2 );
2341: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG',
2342: ' X_GDF_RA_BATCH_SOURCES_ATT3 : '||X_GDF_RA_BATCH_SOURCES_ATT3 );
2343: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG',

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

2337:
2338: IF ( g_level_statement>= g_current_runtime_level ) THEN
2339: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG',
2340: ' X_GDF_RA_BATCH_SOURCES_ATT2 : '||X_GDF_RA_BATCH_SOURCES_ATT2 );
2341: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG',
2342: ' X_GDF_RA_BATCH_SOURCES_ATT3 : '||X_GDF_RA_BATCH_SOURCES_ATT3 );
2343: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG',
2344: ' X_GDF_RA_BATCH_SOURCES_ATT4 : '||X_GDF_RA_BATCH_SOURCES_ATT4 );
2345: END IF;

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

2339: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG',
2340: ' X_GDF_RA_BATCH_SOURCES_ATT2 : '||X_GDF_RA_BATCH_SOURCES_ATT2 );
2341: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG',
2342: ' X_GDF_RA_BATCH_SOURCES_ATT3 : '||X_GDF_RA_BATCH_SOURCES_ATT3 );
2343: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG',
2344: ' X_GDF_RA_BATCH_SOURCES_ATT4 : '||X_GDF_RA_BATCH_SOURCES_ATT4 );
2345: END IF;
2346:
2347: IF (g_level_procedure >= g_current_runtime_level ) THEN

Line 2348: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_JA_EXTRACT_PKG',

2344: ' X_GDF_RA_BATCH_SOURCES_ATT4 : '||X_GDF_RA_BATCH_SOURCES_ATT4 );
2345: END IF;
2346:
2347: IF (g_level_procedure >= g_current_runtime_level ) THEN
2348: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_JA_EXTRACT_PKG',
2349: 'GET_GUI_SOURCE(-)');
2350: END IF;
2351: EXCEPTION
2352: WHEN NO_DATA_FOUND THEN

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

2350: END IF;
2351: EXCEPTION
2352: WHEN NO_DATA_FOUND THEN
2353: IF ( g_level_statement>= g_current_runtime_level ) THEN
2354: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG',
2355: 'Error Message : '||substrb(SQLERRM,1,120) );
2356: END IF;
2357:
2358: END get_gui_source;

Line 2410: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_JA_EXTRACT_PKG',

2406: -- Cannot use 'CURRENT OF' for 'SELECT FOR UPDATE NOWAIT'
2407: -- because of bug 219936.
2408: --
2409: IF (g_level_procedure >= g_current_runtime_level ) THEN
2410: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_JA_EXTRACT_PKG',
2411: 'UPDATE_PRINT_DATE(+)');
2412: END IF;
2413:
2414: IF ( g_level_statement>= g_current_runtime_level ) THEN

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

2411: 'UPDATE_PRINT_DATE(+)');
2412: END IF;
2413:
2414: IF ( g_level_statement>= g_current_runtime_level ) THEN
2415: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG',
2416: ' p_invoice_id : '||p_invoice_id );
2417: END IF;
2418:
2419: OPEN c_invoice(p_invoice_id);

Line 2432: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JA_AP',

2428: WHERE
2429: invoice_id = p_invoice_id;
2430:
2431: IF ( g_level_statement>= g_current_runtime_level ) THEN
2432: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JA_AP',
2433: 'Update Count : '||to_char(SQL%ROWCOUNT) );
2434: END IF;
2435: END LOOP;
2436: CLOSE c_invoice;

Line 2439: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_JA_EXTRACT_PKG',

2435: END LOOP;
2436: CLOSE c_invoice;
2437:
2438: IF (g_level_procedure >= g_current_runtime_level ) THEN
2439: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_JA_EXTRACT_PKG',
2440: 'UPDATE_PRINT_DATE(-)');
2441: END IF;
2442:
2443: EXCEPTION

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

2442:
2443: EXCEPTION
2444: WHEN NO_DATA_FOUND THEN
2445: IF ( g_level_statement>= g_current_runtime_level ) THEN
2446: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG',
2447: 'Error Message : '||substrb(SQLERRM,1,120) );
2448: END IF;
2449:
2450:

Line 2489: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_JA_EXTRACT_PKG',

2485:
2486: BEGIN
2487:
2488: IF (g_level_procedure >= g_current_runtime_level ) THEN
2489: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_JA_EXTRACT_PKG',
2490: 'GET_ORG_TRX_NUMBER(+)');
2491: END IF;
2492:
2493: IF ( g_level_statement>= g_current_runtime_level ) THEN

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

2490: 'GET_ORG_TRX_NUMBER(+)');
2491: END IF;
2492:
2493: IF ( g_level_statement>= g_current_runtime_level ) THEN
2494: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG',
2495: ' P_TRX_SOURCE_ID : '||P_TRX_SOURCE_ID );
2496: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG',
2497: ' P_TRX_ID : '||P_TRX_ID );
2498: END IF;

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

2492:
2493: IF ( g_level_statement>= g_current_runtime_level ) THEN
2494: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG',
2495: ' P_TRX_SOURCE_ID : '||P_TRX_SOURCE_ID );
2496: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG',
2497: ' P_TRX_ID : '||P_TRX_ID );
2498: END IF;
2499:
2500: IF P_TRX_SOURCE_ID is not null THEN

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

2510:
2511: END IF;
2512:
2513: IF ( g_level_statement>= g_current_runtime_level ) THEN
2514: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG',
2515: ' X_ORG_TRX_NUMBER : '||X_ORG_TRX_NUMBER );
2516: END IF;
2517:
2518: IF (g_level_procedure >= g_current_runtime_level ) THEN

Line 2519: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_JA_EXTRACT_PKG',

2515: ' X_ORG_TRX_NUMBER : '||X_ORG_TRX_NUMBER );
2516: END IF;
2517:
2518: IF (g_level_procedure >= g_current_runtime_level ) THEN
2519: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_JA_EXTRACT_PKG',
2520: 'GET_ORG_TRX_NUMBER(-)');
2521: END IF;
2522:
2523: EXCEPTION

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

2522:
2523: EXCEPTION
2524: WHEN NO_DATA_FOUND THEN
2525: IF ( g_level_statement>= g_current_runtime_level ) THEN
2526: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG',
2527: 'Error Message : '||substrb(SQLERRM,1,120) );
2528: END IF;
2529: END get_org_trx_number;
2530:

Line 2571: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_JA_EXTRACT_PKG',

2567:
2568: BEGIN
2569:
2570: IF (g_level_procedure >= g_current_runtime_level ) THEN
2571: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_JA_EXTRACT_PKG',
2572: 'GET_EXPORT_INFO(+)');
2573: END IF;
2574:
2575: IF ( g_level_statement>= g_current_runtime_level ) THEN

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

2572: 'GET_EXPORT_INFO(+)');
2573: END IF;
2574:
2575: IF ( g_level_statement>= g_current_runtime_level ) THEN
2576: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG',
2577: ' P_TRX_ID : '||P_TRX_ID );
2578: END IF;
2579:
2580: IF P_TRX_ID is not null THEN

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

2597: rct.customer_trx_id = P_TRX_ID and
2598: rct.global_attribute_category = 'JA.TW.ARXTWMAI.RA_CUSTOMER_TRX';
2599:
2600: IF ( g_level_statement>= g_current_runtime_level ) THEN
2601: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG',
2602: ' X_GDF_RA_CUST_TRX_ATT4 : '||X_GDF_RA_CUST_TRX_ATT4 );
2603: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG',
2604: ' X_GDF_RA_CUST_TRX_ATT5 : '||X_GDF_RA_CUST_TRX_ATT5 );
2605: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG',

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

2599:
2600: IF ( g_level_statement>= g_current_runtime_level ) THEN
2601: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG',
2602: ' X_GDF_RA_CUST_TRX_ATT4 : '||X_GDF_RA_CUST_TRX_ATT4 );
2603: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG',
2604: ' X_GDF_RA_CUST_TRX_ATT5 : '||X_GDF_RA_CUST_TRX_ATT5 );
2605: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG',
2606: ' X_GDF_RA_CUST_TRX_ATT6 : '||X_GDF_RA_CUST_TRX_ATT6 );
2607: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG',

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

2601: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG',
2602: ' X_GDF_RA_CUST_TRX_ATT4 : '||X_GDF_RA_CUST_TRX_ATT4 );
2603: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG',
2604: ' X_GDF_RA_CUST_TRX_ATT5 : '||X_GDF_RA_CUST_TRX_ATT5 );
2605: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG',
2606: ' X_GDF_RA_CUST_TRX_ATT6 : '||X_GDF_RA_CUST_TRX_ATT6 );
2607: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG',
2608: ' X_GDF_RA_CUST_TRX_ATT7 : '||X_GDF_RA_CUST_TRX_ATT7 );
2609: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG',

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

2603: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG',
2604: ' X_GDF_RA_CUST_TRX_ATT5 : '||X_GDF_RA_CUST_TRX_ATT5 );
2605: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG',
2606: ' X_GDF_RA_CUST_TRX_ATT6 : '||X_GDF_RA_CUST_TRX_ATT6 );
2607: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG',
2608: ' X_GDF_RA_CUST_TRX_ATT7 : '||X_GDF_RA_CUST_TRX_ATT7 );
2609: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG',
2610: ' X_GDF_RA_CUST_TRX_ATT8 : '||X_GDF_RA_CUST_TRX_ATT8 );
2611:

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

2605: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG',
2606: ' X_GDF_RA_CUST_TRX_ATT6 : '||X_GDF_RA_CUST_TRX_ATT6 );
2607: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG',
2608: ' X_GDF_RA_CUST_TRX_ATT7 : '||X_GDF_RA_CUST_TRX_ATT7 );
2609: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG',
2610: ' X_GDF_RA_CUST_TRX_ATT8 : '||X_GDF_RA_CUST_TRX_ATT8 );
2611:
2612: END IF;
2613:

Line 2617: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_JA_EXTRACT_PKG',

2613:
2614: END IF;
2615:
2616: IF (g_level_procedure >= g_current_runtime_level ) THEN
2617: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_JA_EXTRACT_PKG',
2618: 'GET_EXPORT_INFO(-)');
2619: END IF;
2620:
2621: EXCEPTION

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

2620:
2621: EXCEPTION
2622: WHEN NO_DATA_FOUND THEN
2623: IF ( g_level_statement>= g_current_runtime_level ) THEN
2624: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG',
2625: 'Error Message : GET_EXPORT_INFO : '||substrb(SQLERRM,1,120) );
2626: END IF;
2627:
2628: