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 410: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.filter_ja_ar_tax_lines',

406: substrb(DET.DOCUMENT_SUB_TYPE, 10,2) IN ('21','22', '23','24','25','26','27','28'))
407: );
408:
409: IF ( g_level_statement>= g_current_runtime_level ) THEN
410: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.filter_ja_ar_tax_lines',
411: 'Deleted Count : '||to_char(SQL%ROWCOUNT) );
412: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.filter_ja_ar_tax_lines',
413: ' l_delete_sql_string : '||l_delete_sql_string );
414:

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

408:
409: IF ( g_level_statement>= g_current_runtime_level ) THEN
410: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.filter_ja_ar_tax_lines',
411: 'Deleted Count : '||to_char(SQL%ROWCOUNT) );
412: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.filter_ja_ar_tax_lines',
413: ' l_delete_sql_string : '||l_delete_sql_string );
414:
415: END IF;
416:

Line 420: FND_LOG.STRING(g_level_statement,

416:
417: end if;
418:
419: IF (g_level_statement >= g_current_runtime_level ) THEN
420: FND_LOG.STRING(g_level_statement,
421: 'ZX.TRL.ja_tax_extract.filter_ja_tax_lines.END',
422: 'ja_tax_extract.filter_ar_tax_lines(-)');
423: END IF;
424:

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

424:
425: EXCEPTION
426: WHEN OTHERS THEN
427: IF ( g_level_statement>= g_current_runtime_level ) THEN
428: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.filter_ja_ar_tax_lines',
429: 'Error Message : '||substrb(SQLERRM,1,120) );
430: END IF;
431:
432: END filter_ja_ar_tax_lines;

Line 508: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

504: WHERE org_id = p_org_id;
505:
506:
507: BEGIN
508: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
509: IF (g_level_procedure >= g_current_runtime_level ) THEN
510: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_JA_EXTRACT_PKG.FILTER_JA_AP_TAX_LINES.BEGIN',
511: 'ZX_JA_EXTRACT_PKG.filter_ap_tax_lines(+)');
512: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_JA_EXTRACT_PKG.FILTER_JA_AP_TAX_LINES.BEGIN',

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

506:
507: BEGIN
508: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
509: IF (g_level_procedure >= g_current_runtime_level ) THEN
510: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_JA_EXTRACT_PKG.FILTER_JA_AP_TAX_LINES.BEGIN',
511: 'ZX_JA_EXTRACT_PKG.filter_ap_tax_lines(+)');
512: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_JA_EXTRACT_PKG.FILTER_JA_AP_TAX_LINES.BEGIN',
513: 'P_TRL_GLOBAL_VARIABLES_REC.REPORT_NAME : '||P_TRL_GLOBAL_VARIABLES_REC.REPORT_NAME);
514: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_JA_EXTRACT_PKG.FILTER_JA_AP_TAX_LINES.BEGIN',

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

508: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
509: IF (g_level_procedure >= g_current_runtime_level ) THEN
510: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_JA_EXTRACT_PKG.FILTER_JA_AP_TAX_LINES.BEGIN',
511: 'ZX_JA_EXTRACT_PKG.filter_ap_tax_lines(+)');
512: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_JA_EXTRACT_PKG.FILTER_JA_AP_TAX_LINES.BEGIN',
513: 'P_TRL_GLOBAL_VARIABLES_REC.REPORT_NAME : '||P_TRL_GLOBAL_VARIABLES_REC.REPORT_NAME);
514: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_JA_EXTRACT_PKG.FILTER_JA_AP_TAX_LINES.BEGIN',
515: 'P_TRL_GLOBAL_VARIABLES_REC.DOCUMENT_SUB_TYPE : '||P_TRL_GLOBAL_VARIABLES_REC.DOCUMENT_SUB_TYPE );
516:

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

510: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_JA_EXTRACT_PKG.FILTER_JA_AP_TAX_LINES.BEGIN',
511: 'ZX_JA_EXTRACT_PKG.filter_ap_tax_lines(+)');
512: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_JA_EXTRACT_PKG.FILTER_JA_AP_TAX_LINES.BEGIN',
513: 'P_TRL_GLOBAL_VARIABLES_REC.REPORT_NAME : '||P_TRL_GLOBAL_VARIABLES_REC.REPORT_NAME);
514: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_JA_EXTRACT_PKG.FILTER_JA_AP_TAX_LINES.BEGIN',
515: 'P_TRL_GLOBAL_VARIABLES_REC.DOCUMENT_SUB_TYPE : '||P_TRL_GLOBAL_VARIABLES_REC.DOCUMENT_SUB_TYPE );
516:
517: END IF;
518:

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

526: substrb(DET.DOCUMENT_SUB_TYPE, 10, 2) in ('21','22','23','24','25','26','27','28')
527: );
528:
529: IF ( g_level_statement>= g_current_runtime_level ) THEN
530: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.FILTER_JA_AP_TAX_LINES',
531: 'Deleted Count : '||to_char(SQL%ROWCOUNT) );
532: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.FILTER_JA_AP_TAX_LINES',
533: 'ja_tax_extract.filter_ja_tax_lines '||'l_delete_sql_string: ' || l_delete_sql_string);
534: END IF;

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

528:
529: IF ( g_level_statement>= g_current_runtime_level ) THEN
530: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.FILTER_JA_AP_TAX_LINES',
531: 'Deleted Count : '||to_char(SQL%ROWCOUNT) );
532: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.FILTER_JA_AP_TAX_LINES',
533: 'ja_tax_extract.filter_ja_tax_lines '||'l_delete_sql_string: ' || l_delete_sql_string);
534: END IF;
535:
536: elsif P_TRL_GLOBAL_VARIABLES_REC.REPORT_NAME = 'ZXTWPSPC' then

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

562:
563: EXECUTE IMMEDIATE l_delete_sql_string;
564:
565: IF ( g_level_statement>= g_current_runtime_level ) THEN
566: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.FILTER_JA_AP_TAX_LINES',
567: 'Deleted Count : '||to_char(SQL%ROWCOUNT) );
568: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.FILTER_JA_AP_TAX_LINES',
569: ' l_delete_sql_string : '||l_delete_sql_string );
570:

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

564:
565: IF ( g_level_statement>= g_current_runtime_level ) THEN
566: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.FILTER_JA_AP_TAX_LINES',
567: 'Deleted Count : '||to_char(SQL%ROWCOUNT) );
568: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.FILTER_JA_AP_TAX_LINES',
569: ' l_delete_sql_string : '||l_delete_sql_string );
570:
571: END IF;
572:

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

588:
589:
590:
591: IF ( g_level_statement>= g_current_runtime_level ) THEN
592: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.FILTER_JA_AP_TAX_LINES',
593: 'Deleted Count : '||to_char(SQL%ROWCOUNT) );
594: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.FILTER_JA_AP_TAX_LINES',
595: ' l_delete_sql_string : '||l_delete_sql_string );
596:

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

590:
591: IF ( g_level_statement>= g_current_runtime_level ) THEN
592: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.FILTER_JA_AP_TAX_LINES',
593: 'Deleted Count : '||to_char(SQL%ROWCOUNT) );
594: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.FILTER_JA_AP_TAX_LINES',
595: ' l_delete_sql_string : '||l_delete_sql_string );
596:
597: END IF;
598:

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

605: substrb(DET.DOCUMENT_SUB_TYPE,10,2) IN ('23','24') and
606: DET.CANCEL_FLAG <> 'Y'
607: );
608: IF ( g_level_statement>= g_current_runtime_level ) THEN
609: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.FILTER_JA_AP_TAX_LINES',
610: ' NULL supplier '||l_delete_sql_string );
611:
612: END IF;
613:

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

611:
612: END IF;
613:
614: IF ( g_level_statement>= g_current_runtime_level ) THEN
615: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.FILTER_JA_AP_TAX_LINES',
616: 'Deleted Count : '||to_char(SQL%ROWCOUNT) );
617: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.FILTER_JA_AP_TAX_LINES',
618: ' l_delete_sql_string : '||l_delete_sql_string );
619:

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

613:
614: IF ( g_level_statement>= g_current_runtime_level ) THEN
615: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.FILTER_JA_AP_TAX_LINES',
616: 'Deleted Count : '||to_char(SQL%ROWCOUNT) );
617: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.FILTER_JA_AP_TAX_LINES',
618: ' l_delete_sql_string : '||l_delete_sql_string );
619:
620: END IF;
621:

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

628: DET.SUPPLIER_EXCHANGE_RATE IS NOT NULL and
629: DET.CURRENCY_CONVERSION_RATE is NOT NULL);
630:
631: IF ( g_level_statement>= g_current_runtime_level ) THEN
632: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.FILTER_JA_AP_TAX_LINES',
633: 'Deleted Count : '||to_char(SQL%ROWCOUNT) );
634: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.FILTER_JA_AP_TAX_LINES',
635: ' l_delete_sql_string : '||l_delete_sql_string );
636:

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

630:
631: IF ( g_level_statement>= g_current_runtime_level ) THEN
632: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.FILTER_JA_AP_TAX_LINES',
633: 'Deleted Count : '||to_char(SQL%ROWCOUNT) );
634: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.FILTER_JA_AP_TAX_LINES',
635: ' l_delete_sql_string : '||l_delete_sql_string );
636:
637: END IF;
638:

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

688: -- EXECUTE IMMEDIATE l_delete_sql_string;
689:
690:
691: IF ( g_level_statement>= g_current_runtime_level ) THEN
692: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.FILTER_JA_AP_TAX_LINES',
693: 'Deleted Count : '||to_char(SQL%ROWCOUNT) );
694: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.FILTER_JA_AP_TAX_LINES',
695: ' l_delete_sql_string : '||l_delete_sql_string );
696:

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

690:
691: IF ( g_level_statement>= g_current_runtime_level ) THEN
692: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.FILTER_JA_AP_TAX_LINES',
693: 'Deleted Count : '||to_char(SQL%ROWCOUNT) );
694: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.FILTER_JA_AP_TAX_LINES',
695: ' l_delete_sql_string : '||l_delete_sql_string );
696:
697: END IF;
698:

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

698:
699: end if;
700:
701: IF (g_level_procedure >= g_current_runtime_level ) THEN
702: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_JA_EXTRACT_PKG.FILTER_JA_AP_TAX_LINES.END',
703: 'ZX_JA_EXTRACT_PKG.filter_ap_tax_lines(-):');
704: END IF;
705:
706: EXCEPTION

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

705:
706: EXCEPTION
707: WHEN OTHERS THEN
708: IF ( g_level_statement>= g_current_runtime_level ) THEN
709: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.FILTER_JA_AP_TAX_LINES',
710: 'Error Message for report : '||substrb(SQLERRM,1,120) );
711: END IF;
712:
713: END filter_ja_ap_tax_lines;

Line 877: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

873: l_trx_date DATE;
874:
875: BEGIN
876:
877: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
878: IF (g_level_statement >= g_current_runtime_level ) THEN
879: FND_LOG.STRING(g_level_statement,
880: 'ZX.TRL.ja_tax_extract.ja_tax_extract.populate_ja_ar.BEGIN',
881: 'ja_tax_extract.populate_ja_ar(+)');

Line 879: FND_LOG.STRING(g_level_statement,

875: BEGIN
876:
877: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
878: IF (g_level_statement >= g_current_runtime_level ) THEN
879: FND_LOG.STRING(g_level_statement,
880: 'ZX.TRL.ja_tax_extract.ja_tax_extract.populate_ja_ar.BEGIN',
881: 'ja_tax_extract.populate_ja_ar(+)');
882: END IF;
883:

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

881: 'ja_tax_extract.populate_ja_ar(+)');
882: END IF;
883:
884: IF ( g_level_statement>= g_current_runtime_level ) THEN
885: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.populate_ja_ar',
886: 'P_TRL_GLOBAL_VARIABLES_REC.REPORT_NAME : '||P_TRL_GLOBAL_VARIABLES_REC.REPORT_NAME );
887: END IF;
888:
889: SELECT detail_tax_line_id,

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

905: FROM zx_rep_trx_detail_t itf1
906: WHERE itf1.request_id = P_TRL_GLOBAL_VARIABLES_REC.REQUEST_ID;
907:
908: IF ( g_level_statement>= g_current_runtime_level ) THEN
909: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.populate_ja_ar',
910: 'Count fetched : '||to_char(nvl(l_detail_tax_line_id_tbl.count,0)) );
911: END IF;
912:
913: P_LOOKUP_CODE:= NULL;

Line 931: FND_LOG.STRING(g_level_statement,

927: -- select translate(l_trx_business_category_tbl(i), '0123456789.ABCDEFGHIJKLMNOPQRSTUVWXYZ', '0123456789') into P_LOOKUP_CODE from dual;
928: p_lookup_code := l_trx_business_category_tbl(i);
929: X_DEDUCTIBLE_TYPE_TBL(i):= GET_LOOKUP_INFO(P_LOOKUP_TYPE, P_LOOKUP_CODE,l_trx_date_tbl(i));
930: IF (g_level_statement >= g_current_runtime_level ) THEN
931: FND_LOG.STRING(g_level_statement,
932: 'ZX.TRL.ja_tax_extract.ja_tax_extract.populate_ja_ar',
933: 'P_LOOKUP_CODE:'||P_LOOKUP_CODE||'-'||l_tax_status_code_tbl(i));
934: END IF;
935:

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

985: END IF;
986:
987: --Bug 5251425 : To get the taiwan specific date format.
988: IF ( g_level_statement>= g_current_runtime_level ) THEN
989: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.populate_ja_ar',
990: 'Before call to fnd_date.date_to_canonical to get canonical date format ');
991: END IF;
992: l_canonical_date := fnd_date.date_to_canonical(l_trx_date_tbl(i));
993: l_roc_year := TO_NUMBER(SUBSTRB(l_canonical_date,1,4)) - 1911;

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

1032: sysdate,
1033: fnd_global.login_id);
1034:
1035: IF ( g_level_statement>= g_current_runtime_level ) THEN
1036: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.populate_ja_ar',
1037: 'After insertion into zx_rep_trx_jx_ext_t ');
1038: END IF;
1039: elsif P_TRL_GLOBAL_VARIABLES_REC.REPORT_NAME = 'ZXTWRZTR' and l_detail_tax_line_id_tbl.count <> 0 then
1040:

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

1097: sysdate,
1098: fnd_global.login_id);
1099:
1100: IF ( g_level_statement>= g_current_runtime_level ) THEN
1101: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.populate_ja_ar',
1102: 'After insertion into zx_rep_trx_jx_ext_t ');
1103: END IF;
1104: elsif P_TRL_GLOBAL_VARIABLES_REC.REPORT_NAME = 'JATWSEDI' and l_detail_tax_line_id_tbl.count <> 0 then
1105:

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

1144: sysdate,
1145: fnd_global.login_id);
1146:
1147: IF ( g_level_statement>= g_current_runtime_level ) THEN
1148: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.populate_ja_ar',
1149: 'After insertion into zx_rep_trx_jx_ext_t ');
1150: END IF;
1151: elsif P_TRL_GLOBAL_VARIABLES_REC.REPORT_NAME = 'RXZXKVAT' THEN
1152:

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

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

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

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

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

1274: bank_info(P_TRL_GLOBAL_VARIABLES_REC);
1275: end if;
1276:
1277: IF ( g_level_statement>= g_current_runtime_level ) THEN
1278: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.populate_ja_ar',
1279: 'After insertion into zx_rep_trx_jx_ext_t ');
1280: END IF;
1281:
1282: IF (g_level_procedure >= g_current_runtime_level ) THEN

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

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

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

1286:
1287: EXCEPTION
1288: WHEN OTHERS THEN
1289: IF ( g_level_statement>= g_current_runtime_level ) THEN
1290: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.populate_ja_ar',
1291: 'Error Message for report : '||substrb(SQLERRM,1,120) );
1292: END IF;
1293:
1294: END populate_ja_ar;

Line 1445: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1441:
1442:
1443: BEGIN
1444:
1445: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1446:
1447: IF (g_level_procedure >= g_current_runtime_level ) THEN
1448: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JA_AP.BEGIN',
1449: 'ZX_JA_EXTRACT_PKG.POPULATE_JA_AP(+)');

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

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

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

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

Line 1496: FND_LOG.STRING(g_level_statement,

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

Line 1508: FND_LOG.STRING(g_level_statement,

1504: P_LOOKUP_CODE:= l_tax_status_code_tbl(i); --Bug 5438409
1505: -- P_LOOKUP_CODE:=l_tax_status_id_tbl(i);
1506:
1507: IF (g_level_statement >= g_current_runtime_level ) THEN
1508: FND_LOG.STRING(g_level_statement,
1509: 'ZX.TRL.ja_tax_extract.populate_ja_ap',
1510: 'P_LOOKUP_CODE:'||P_LOOKUP_CODE||'-'||to_char(l_tax_status_id_tbl(i)));
1511: END IF;
1512:

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

1542: sysdate,
1543: fnd_global.login_id);
1544:
1545: IF ( g_level_statement>= g_current_runtime_level ) THEN
1546: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JA_AP',
1547: 'After insertion into zx_rep_trx_jx_ext_t ');
1548: END IF;
1549: elsif P_TRL_GLOBAL_VARIABLES_REC.REPORT_NAME = 'ZXTWSPRF' and l_detail_tax_line_id_tbl.count <> 0 then
1550:

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

1550:
1551: /****** Populate the missing columns ********/
1552: FOR i in 1 .. nvl(l_detail_tax_line_id_tbl.count,0) LOOP
1553: IF ( g_level_statement>= g_current_runtime_level ) THEN
1554: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JA_AP',
1555: 'Processing detail_tax_line_id : '||l_detail_tax_line_id_tbl(i)||' trx id : '||l_trx_id_tbl(i));
1556: END IF;
1557:
1558: P_LOOKUP_TYPE:= 'JATW_GUI_TYPE';

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

1561: p_lookup_code := l_document_sub_type_tbl(i);
1562: X_GUI_TYPE_TBL(i):= GET_LOOKUP_INFO(P_LOOKUP_TYPE, P_LOOKUP_CODE, l_trx_date_tbl(i));
1563:
1564: IF ( g_level_statement>= g_current_runtime_level ) THEN
1565: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JA_AP',
1566: 'Debug 1');
1567: END IF;
1568:
1569: P_LOOKUP_TYPE:= 'JATW_GOVERNMENT_TAX_TYPE';

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

1570: P_LOOKUP_CODE:= l_tax_status_code_tbl(i);
1571: X_GOVERNMENT_TAX_TYPE_TBL(i):= GET_LOOKUP_INFO(P_LOOKUP_TYPE, P_LOOKUP_CODE, l_trx_date_tbl(i));
1572:
1573: IF ( g_level_statement>= g_current_runtime_level ) THEN
1574: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JA_AP',
1575: 'Debug 2');
1576: END IF;
1577:
1578: P_LOOKUP_TYPE:= 'JATW_DEDUCTIBLE_TYPE';

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

1581: -- select translate(l_trx_business_category_tbl(i), '0123456789.ABCDEFGHIJKLMNOPQRSTUVWXYZ', '0123456789') into P_LOOKUP_CODE from dual;
1582: X_DEDUCTIBLE_TYPE_TBL(i):= GET_LOOKUP_INFO(P_LOOKUP_TYPE, P_LOOKUP_CODE, l_trx_date_tbl(i));
1583:
1584: IF ( g_level_statement>= g_current_runtime_level ) THEN
1585: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JA_AP',
1586: 'Debug 3');
1587: END IF;
1588:
1589: END LOOP;

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

1590:
1591: /****** Bulk Insert into Ext Table *******/
1592:
1593: IF ( g_level_statement>= g_current_runtime_level ) THEN
1594: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JA_AP',
1595: 'Before into zx_rep_trx_jx_ext_t ap ');
1596: END IF;
1597:
1598: FORALL i in 1 .. nvl(l_detail_tax_line_id_tbl.last, 0)

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

1619: sysdate,
1620: fnd_global.login_id);
1621:
1622: IF ( g_level_statement>= g_current_runtime_level ) THEN
1623: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JA_AP',
1624: 'After insertion into zx_rep_trx_jx_ext_t ');
1625: END IF;
1626: elsif P_TRL_GLOBAL_VARIABLES_REC.REPORT_NAME = ('ZXTWPSPC') and l_detail_tax_line_id_tbl.count <> 0 then
1627:

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

1674: sysdate,
1675: fnd_global.login_id);
1676:
1677: IF ( g_level_statement>= g_current_runtime_level ) THEN
1678: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JA_AP',
1679: 'After insertion into zx_rep_trx_jx_ext_t ');
1680: END IF;
1681: elsif P_TRL_GLOBAL_VARIABLES_REC.REPORT_NAME = 'ZXTWPPRD' and l_detail_tax_line_id_tbl.count <> 0 then
1682:

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

1715: sysdate,
1716: fnd_global.login_id);
1717:
1718: IF ( g_level_statement>= g_current_runtime_level ) THEN
1719: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JA_AP',
1720: 'After insertion into zx_rep_trx_jx_ext_t ');
1721: END IF;
1722: elsif P_TRL_GLOBAL_VARIABLES_REC.REPORT_NAME = 'ZXSGAGAL' and l_detail_tax_line_id_tbl.count <> 0 then
1723:

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

1726: FOR i in 1 .. nvl(l_detail_tax_line_id_tbl.count,0) LOOP
1727: k:= to_number(to_char(l_trx_id_tbl(i))||to_char(l_trx_line_id_tbl(i)));
1728:
1729: IF ( g_level_statement>= g_current_runtime_level ) THEN
1730: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JA_AP',
1731: 'l_trx_id_tbl(i) : '||l_trx_id_tbl(i));
1732: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JA_AP',
1733: 'l_trx_line_id_tbl(i) : '||l_trx_line_id_tbl(i));
1734: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JA_AP',

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

1728:
1729: IF ( g_level_statement>= g_current_runtime_level ) THEN
1730: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JA_AP',
1731: 'l_trx_id_tbl(i) : '||l_trx_id_tbl(i));
1732: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JA_AP',
1733: 'l_trx_line_id_tbl(i) : '||l_trx_line_id_tbl(i));
1734: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JA_AP',
1735: 'i : '||i||' k : '||k);
1736: END IF;

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

1730: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JA_AP',
1731: 'l_trx_id_tbl(i) : '||l_trx_id_tbl(i));
1732: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JA_AP',
1733: 'l_trx_line_id_tbl(i) : '||l_trx_line_id_tbl(i));
1734: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JA_AP',
1735: 'i : '||i||' k : '||k);
1736: END IF;
1737:
1738: IF L_INHOUSE_INV_AMT_TBL.EXISTS(k) THEN

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

1741: L_INHOUSE_INV_AMT_TBL(k) := null;
1742: END IF;
1743:
1744: IF ( g_level_statement>= g_current_runtime_level ) THEN
1745: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JA_AP',
1746: 'L_INHOUSE_INV_AMT_TBL(k) : '||L_INHOUSE_INV_AMT_TBL(k));
1747: END IF;
1748:
1749: IF L_INHOUSE_INV_AMT_TBL(k) is NULL THEN

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

1763: X_SUPPLIER_INV_AMT_TBL(i):=L_SUPPLIER_INV_AMT_TBL(k);
1764: X_TAXABLE_GAINLOSS_TBL(i):= L_TAXABLE_GAINLOSS_TBL(k);
1765:
1766: IF ( g_level_statement>= g_current_runtime_level ) THEN
1767: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JA_AP',
1768: 'X_INHOUSE_INV_AMT_TBL(i) : '||X_INHOUSE_INV_AMT_TBL(i));
1769: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JA_AP',
1770: 'X_SUPPLIER_INV_AMT_TBL(i) : '||X_SUPPLIER_INV_AMT_TBL(i));
1771: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JA_AP',

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

1765:
1766: IF ( g_level_statement>= g_current_runtime_level ) THEN
1767: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JA_AP',
1768: 'X_INHOUSE_INV_AMT_TBL(i) : '||X_INHOUSE_INV_AMT_TBL(i));
1769: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JA_AP',
1770: 'X_SUPPLIER_INV_AMT_TBL(i) : '||X_SUPPLIER_INV_AMT_TBL(i));
1771: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JA_AP',
1772: 'X_TAXABLE_GAINLOSS_TBL(i) : '||X_TAXABLE_GAINLOSS_TBL(i));
1773: END IF;

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

1767: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JA_AP',
1768: 'X_INHOUSE_INV_AMT_TBL(i) : '||X_INHOUSE_INV_AMT_TBL(i));
1769: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JA_AP',
1770: 'X_SUPPLIER_INV_AMT_TBL(i) : '||X_SUPPLIER_INV_AMT_TBL(i));
1771: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JA_AP',
1772: 'X_TAXABLE_GAINLOSS_TBL(i) : '||X_TAXABLE_GAINLOSS_TBL(i));
1773: END IF;
1774:
1775: X_INHOUSE_TAX_AMT_TBL(i):= round(l_tax_amt_tbl(i) *

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

1778: to_number(nvl(l_supplier_exchange_rate_tbl(i),1)), l_precision_tbl(i));
1779: X_TAX_GAINLOSS_TBL(i):= X_INHOUSE_TAX_AMT_TBL(i) - X_SUPPLIER_TAX_AMT_TBL(i);
1780:
1781: IF ( g_level_statement>= g_current_runtime_level ) THEN
1782: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JA_AP',
1783: 'X_INHOUSE_TAX_AMT_TBL(i) : '||X_INHOUSE_TAX_AMT_TBL(i));
1784: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JA_AP',
1785: 'X_SUPPLIER_TAX_AMT_TBL(i) : '||X_SUPPLIER_TAX_AMT_TBL(i));
1786: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JA_AP',

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

1780:
1781: IF ( g_level_statement>= g_current_runtime_level ) THEN
1782: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JA_AP',
1783: 'X_INHOUSE_TAX_AMT_TBL(i) : '||X_INHOUSE_TAX_AMT_TBL(i));
1784: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JA_AP',
1785: 'X_SUPPLIER_TAX_AMT_TBL(i) : '||X_SUPPLIER_TAX_AMT_TBL(i));
1786: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JA_AP',
1787: 'X_TAX_GAINLOSS_TBL(i) : '||X_TAX_GAINLOSS_TBL(i));
1788: END IF;

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

1782: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JA_AP',
1783: 'X_INHOUSE_TAX_AMT_TBL(i) : '||X_INHOUSE_TAX_AMT_TBL(i));
1784: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JA_AP',
1785: 'X_SUPPLIER_TAX_AMT_TBL(i) : '||X_SUPPLIER_TAX_AMT_TBL(i));
1786: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JA_AP',
1787: 'X_TAX_GAINLOSS_TBL(i) : '||X_TAX_GAINLOSS_TBL(i));
1788: END IF;
1789:
1790: /*

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

1834: sysdate,
1835: fnd_global.login_id);
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: 'After insertion into zx_rep_trx_jx_ext_t ');
1840: END IF;
1841:
1842:

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

1885: AND dtl.application_id = 200
1886: AND dtl.request_id = p_trl_global_variables_rec.request_id ;
1887:
1888: IF ( g_level_statement>= g_current_runtime_level ) THEN
1889: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.populate_ja_ar',
1890: 'Reporting Types Query Count : '||to_char(nvl(l_detail_tax_line_id_tbl.count,0)) );
1891:
1892: END IF;
1893:

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

1903: AND dtl.application_id = 200
1904: AND dtl.request_id = p_trl_global_variables_rec.request_id ;
1905:
1906: IF ( g_level_statement>= g_current_runtime_level ) THEN
1907: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.populate_ja_ar',
1908: 'AP Industry Class Query Count: '||to_char(nvl(l_ind_classif_tbl.count,0)) );
1909: END IF;
1910:
1911:

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

1957:
1958: end if;
1959:
1960: IF (g_level_procedure >= g_current_runtime_level ) THEN
1961: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JA_AP.END',
1962: 'ZX_JA_EXTRACT_PKG.POPULATE_JA_AP(-)');
1963: END IF;
1964:
1965: EXCEPTION

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

1965: EXCEPTION
1966: WHEN OTHERS THEN
1967:
1968: IF ( g_level_statement>= g_current_runtime_level ) THEN
1969: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JA_AP',
1970: 'Error Message for report : '||substrb(SQLERRM,1,120) );
1971: END IF;
1972: END populate_ja_ap;
1973:

Line 2009: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

2005:
2006: x_lookup_meaning VARCHAR2(80);
2007:
2008: BEGIN
2009: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2010:
2011: IF (g_level_statement >= g_current_runtime_level ) THEN
2012: FND_LOG.STRING(g_level_statement,
2013: 'ZX.TRL.ja_tax_extract.get_lookup_info',

Line 2012: FND_LOG.STRING(g_level_statement,

2008: BEGIN
2009: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2010:
2011: IF (g_level_statement >= g_current_runtime_level ) THEN
2012: FND_LOG.STRING(g_level_statement,
2013: 'ZX.TRL.ja_tax_extract.get_lookup_info',
2014: 'x_lookup_meaning:'||x_lookup_meaning);
2015: END IF;
2016:

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

2014: 'x_lookup_meaning:'||x_lookup_meaning);
2015: END IF;
2016:
2017: IF (g_level_procedure >= g_current_runtime_level ) THEN
2018: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_JA_EXTRACT_PKG',
2019: 'GET_LOOKUP_INFO(+)');
2020: END IF;
2021:
2022: IF ( g_level_statement>= g_current_runtime_level ) THEN

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

2019: 'GET_LOOKUP_INFO(+)');
2020: END IF;
2021:
2022: IF ( g_level_statement>= g_current_runtime_level ) THEN
2023: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JA_AP',
2024: ' P_LOOKUP_TYPE : '||P_LOOKUP_TYPE );
2025: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JA_AP',
2026: ' P_LOOKUP_CODE : '||P_LOOKUP_CODE );
2027: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JA_AP',

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

2021:
2022: IF ( g_level_statement>= g_current_runtime_level ) THEN
2023: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JA_AP',
2024: ' P_LOOKUP_TYPE : '||P_LOOKUP_TYPE );
2025: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JA_AP',
2026: ' P_LOOKUP_CODE : '||P_LOOKUP_CODE );
2027: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JA_AP',
2028: ' LANG : '||userenv('LANG') );
2029: END IF;

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

2023: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JA_AP',
2024: ' P_LOOKUP_TYPE : '||P_LOOKUP_TYPE );
2025: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JA_AP',
2026: ' P_LOOKUP_CODE : '||P_LOOKUP_CODE );
2027: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JA_AP',
2028: ' LANG : '||userenv('LANG') );
2029: END IF;
2030:
2031: IF P_LOOKUP_TYPE = 'JATW_GUI_TYPE' then

Line 2091: FND_LOG.STRING(g_level_statement,

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

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

2093: 'x_lookup_meaning:'||x_lookup_meaning);
2094: END IF;
2095:
2096: IF (g_level_procedure >= g_current_runtime_level ) THEN
2097: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_JA_EXTRACT_PKG',
2098: 'GET_LOOKUP_INFO(-)');
2099: END IF;
2100:
2101: return (X_LOOKUP_MEANING);

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

2106: return (NULL);
2107:
2108: WHEN OTHERS THEN
2109: IF ( g_level_statement>= g_current_runtime_level ) THEN
2110: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG',
2111: 'Error Message : '||substrb(SQLERRM,1,120) );
2112: END IF;
2113: return (NULL);
2114:

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

2150: IS
2151: BEGIN
2152:
2153: IF (g_level_procedure >= g_current_runtime_level ) THEN
2154: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_JA_EXTRACT_PKG',
2155: 'GET_INVOICE_AMT(+)');
2156: END IF;
2157:
2158: IF ( g_level_statement>= g_current_runtime_level ) THEN

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

2155: 'GET_INVOICE_AMT(+)');
2156: END IF;
2157:
2158: IF ( g_level_statement>= g_current_runtime_level ) THEN
2159: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JA_AP',
2160: ' P_VENDOR_ID : '||P_VENDOR_ID );
2161: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JA_AP',
2162: ' P_INVOICE_NUM : '||P_INVOICE_NUM );
2163: END IF;

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

2157:
2158: IF ( g_level_statement>= g_current_runtime_level ) THEN
2159: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JA_AP',
2160: ' P_VENDOR_ID : '||P_VENDOR_ID );
2161: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JA_AP',
2162: ' P_INVOICE_NUM : '||P_INVOICE_NUM );
2163: END IF;
2164:
2165: SELECT AI.GLOBAL_ATTRIBUTE4, AI.INVOICE_AMOUNT, AI.BASE_AMOUNT

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

2168: WHERE AI.VENDOR_ID = P_VENDOR_ID and
2169: AI.INVOICE_NUM = P_INVOICE_NUM;
2170:
2171: IF ( g_level_statement>= g_current_runtime_level ) THEN
2172: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JA_AP',
2173: ' X_INVOICE_AMT : '||X_INVOICE_AMT );
2174: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JA_AP',
2175: ' X_BASE_AMT : '||X_BASE_AMT );
2176: END IF;

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

2170:
2171: IF ( g_level_statement>= g_current_runtime_level ) THEN
2172: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JA_AP',
2173: ' X_INVOICE_AMT : '||X_INVOICE_AMT );
2174: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JA_AP',
2175: ' X_BASE_AMT : '||X_BASE_AMT );
2176: END IF;
2177:
2178: IF (g_level_procedure >= g_current_runtime_level ) THEN

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

2175: ' X_BASE_AMT : '||X_BASE_AMT );
2176: END IF;
2177:
2178: IF (g_level_procedure >= g_current_runtime_level ) THEN
2179: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_JA_EXTRACT_PKG',
2180: 'GET_INVOICE_AMT(-)');
2181: END IF;
2182:
2183:

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

2184: EXCEPTION
2185:
2186: WHEN NO_DATA_FOUND THEN
2187: IF ( g_level_statement>= g_current_runtime_level ) THEN
2188: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG',
2189: 'Error Message : '||substrb(SQLERRM,1,120) );
2190: END IF;
2191:
2192: END get_invoice_amt;

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

2229:
2230: BEGIN
2231:
2232: IF (g_level_procedure >= g_current_runtime_level ) THEN
2233: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_JA_EXTRACT_PKG',
2234: 'GET_GUI_SOURCE(+)');
2235: END IF;
2236:
2237: IF ( g_level_statement>= g_current_runtime_level ) THEN

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

2234: 'GET_GUI_SOURCE(+)');
2235: END IF;
2236:
2237: IF ( g_level_statement>= g_current_runtime_level ) THEN
2238: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG',
2239: ' P_TRX_SOURCE_NAME : '||P_TRX_SOURCE_NAME );
2240: END IF;
2241:
2242: IF P_TRX_SOURCE_NAME is not null THEN

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

2246: FROM ra_batch_sources src
2247: WHERE src.name = P_TRX_SOURCE_NAME;
2248:
2249: IF ( g_level_statement>= g_current_runtime_level ) THEN
2250: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG',
2251: ' X_GDF_RA_BATCH_SOURCES_ATT1 : '||X_GDF_RA_BATCH_SOURCES_ATT1 );
2252: END IF;
2253:
2254: SELECT substr(global_attribute3,1,2),

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

2262:
2263: END IF;
2264:
2265: IF ( g_level_statement>= g_current_runtime_level ) THEN
2266: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG',
2267: ' X_GDF_RA_BATCH_SOURCES_ATT2 : '||X_GDF_RA_BATCH_SOURCES_ATT2 );
2268: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG',
2269: ' X_GDF_RA_BATCH_SOURCES_ATT3 : '||X_GDF_RA_BATCH_SOURCES_ATT3 );
2270: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG',

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

2264:
2265: IF ( g_level_statement>= g_current_runtime_level ) THEN
2266: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG',
2267: ' X_GDF_RA_BATCH_SOURCES_ATT2 : '||X_GDF_RA_BATCH_SOURCES_ATT2 );
2268: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG',
2269: ' X_GDF_RA_BATCH_SOURCES_ATT3 : '||X_GDF_RA_BATCH_SOURCES_ATT3 );
2270: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG',
2271: ' X_GDF_RA_BATCH_SOURCES_ATT4 : '||X_GDF_RA_BATCH_SOURCES_ATT4 );
2272: END IF;

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

2266: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG',
2267: ' X_GDF_RA_BATCH_SOURCES_ATT2 : '||X_GDF_RA_BATCH_SOURCES_ATT2 );
2268: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG',
2269: ' X_GDF_RA_BATCH_SOURCES_ATT3 : '||X_GDF_RA_BATCH_SOURCES_ATT3 );
2270: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG',
2271: ' X_GDF_RA_BATCH_SOURCES_ATT4 : '||X_GDF_RA_BATCH_SOURCES_ATT4 );
2272: END IF;
2273:
2274: IF (g_level_procedure >= g_current_runtime_level ) THEN

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

2271: ' X_GDF_RA_BATCH_SOURCES_ATT4 : '||X_GDF_RA_BATCH_SOURCES_ATT4 );
2272: END IF;
2273:
2274: IF (g_level_procedure >= g_current_runtime_level ) THEN
2275: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_JA_EXTRACT_PKG',
2276: 'GET_GUI_SOURCE(-)');
2277: END IF;
2278: EXCEPTION
2279: WHEN NO_DATA_FOUND THEN

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

2277: END IF;
2278: EXCEPTION
2279: WHEN NO_DATA_FOUND THEN
2280: IF ( g_level_statement>= g_current_runtime_level ) THEN
2281: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG',
2282: 'Error Message : '||substrb(SQLERRM,1,120) );
2283: END IF;
2284:
2285: END get_gui_source;

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

2333: -- Cannot use 'CURRENT OF' for 'SELECT FOR UPDATE NOWAIT'
2334: -- because of bug 219936.
2335: --
2336: IF (g_level_procedure >= g_current_runtime_level ) THEN
2337: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_JA_EXTRACT_PKG',
2338: 'UPDATE_PRINT_DATE(+)');
2339: END IF;
2340:
2341: IF ( g_level_statement>= g_current_runtime_level ) THEN

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

2338: 'UPDATE_PRINT_DATE(+)');
2339: END IF;
2340:
2341: IF ( g_level_statement>= g_current_runtime_level ) THEN
2342: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG',
2343: ' p_invoice_id : '||p_invoice_id );
2344: END IF;
2345:
2346: OPEN c_invoice(p_invoice_id);

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

2355: WHERE
2356: invoice_id = p_invoice_id;
2357:
2358: IF ( g_level_statement>= g_current_runtime_level ) THEN
2359: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JA_AP',
2360: 'Update Count : '||to_char(SQL%ROWCOUNT) );
2361: END IF;
2362: END LOOP;
2363: CLOSE c_invoice;

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

2362: END LOOP;
2363: CLOSE c_invoice;
2364:
2365: IF (g_level_procedure >= g_current_runtime_level ) THEN
2366: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_JA_EXTRACT_PKG',
2367: 'UPDATE_PRINT_DATE(-)');
2368: END IF;
2369:
2370: EXCEPTION

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

2369:
2370: EXCEPTION
2371: WHEN NO_DATA_FOUND THEN
2372: IF ( g_level_statement>= g_current_runtime_level ) THEN
2373: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG',
2374: 'Error Message : '||substrb(SQLERRM,1,120) );
2375: END IF;
2376:
2377:

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

2412:
2413: BEGIN
2414:
2415: IF (g_level_procedure >= g_current_runtime_level ) THEN
2416: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_JA_EXTRACT_PKG',
2417: 'GET_ORG_TRX_NUMBER(+)');
2418: END IF;
2419:
2420: IF ( g_level_statement>= g_current_runtime_level ) THEN

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

2417: 'GET_ORG_TRX_NUMBER(+)');
2418: END IF;
2419:
2420: IF ( g_level_statement>= g_current_runtime_level ) THEN
2421: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG',
2422: ' P_TRX_SOURCE_ID : '||P_TRX_SOURCE_ID );
2423: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG',
2424: ' P_TRX_ID : '||P_TRX_ID );
2425: END IF;

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

2419:
2420: IF ( g_level_statement>= g_current_runtime_level ) THEN
2421: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG',
2422: ' P_TRX_SOURCE_ID : '||P_TRX_SOURCE_ID );
2423: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG',
2424: ' P_TRX_ID : '||P_TRX_ID );
2425: END IF;
2426:
2427: IF P_TRX_SOURCE_ID is not null THEN

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

2437:
2438: END IF;
2439:
2440: IF ( g_level_statement>= g_current_runtime_level ) THEN
2441: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG',
2442: ' X_ORG_TRX_NUMBER : '||X_ORG_TRX_NUMBER );
2443: END IF;
2444:
2445: IF (g_level_procedure >= g_current_runtime_level ) THEN

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

2442: ' X_ORG_TRX_NUMBER : '||X_ORG_TRX_NUMBER );
2443: END IF;
2444:
2445: IF (g_level_procedure >= g_current_runtime_level ) THEN
2446: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_JA_EXTRACT_PKG',
2447: 'GET_ORG_TRX_NUMBER(-)');
2448: END IF;
2449:
2450: EXCEPTION

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

2449:
2450: EXCEPTION
2451: WHEN NO_DATA_FOUND THEN
2452: IF ( g_level_statement>= g_current_runtime_level ) THEN
2453: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG',
2454: 'Error Message : '||substrb(SQLERRM,1,120) );
2455: END IF;
2456: END get_org_trx_number;
2457:

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

2494:
2495: BEGIN
2496:
2497: IF (g_level_procedure >= g_current_runtime_level ) THEN
2498: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_JA_EXTRACT_PKG',
2499: 'GET_EXPORT_INFO(+)');
2500: END IF;
2501:
2502: IF ( g_level_statement>= g_current_runtime_level ) THEN

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

2499: 'GET_EXPORT_INFO(+)');
2500: END IF;
2501:
2502: IF ( g_level_statement>= g_current_runtime_level ) THEN
2503: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG',
2504: ' P_TRX_ID : '||P_TRX_ID );
2505: END IF;
2506:
2507: IF P_TRX_ID is not null THEN

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

2524: rct.customer_trx_id = P_TRX_ID and
2525: rct.global_attribute_category = 'JA.TW.ARXTWMAI.RA_CUSTOMER_TRX';
2526:
2527: IF ( g_level_statement>= g_current_runtime_level ) THEN
2528: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG',
2529: ' X_GDF_RA_CUST_TRX_ATT4 : '||X_GDF_RA_CUST_TRX_ATT4 );
2530: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG',
2531: ' X_GDF_RA_CUST_TRX_ATT5 : '||X_GDF_RA_CUST_TRX_ATT5 );
2532: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG',

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

2526:
2527: IF ( g_level_statement>= g_current_runtime_level ) THEN
2528: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG',
2529: ' X_GDF_RA_CUST_TRX_ATT4 : '||X_GDF_RA_CUST_TRX_ATT4 );
2530: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG',
2531: ' X_GDF_RA_CUST_TRX_ATT5 : '||X_GDF_RA_CUST_TRX_ATT5 );
2532: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG',
2533: ' X_GDF_RA_CUST_TRX_ATT6 : '||X_GDF_RA_CUST_TRX_ATT6 );
2534: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG',

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

2528: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG',
2529: ' X_GDF_RA_CUST_TRX_ATT4 : '||X_GDF_RA_CUST_TRX_ATT4 );
2530: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG',
2531: ' X_GDF_RA_CUST_TRX_ATT5 : '||X_GDF_RA_CUST_TRX_ATT5 );
2532: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG',
2533: ' X_GDF_RA_CUST_TRX_ATT6 : '||X_GDF_RA_CUST_TRX_ATT6 );
2534: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG',
2535: ' X_GDF_RA_CUST_TRX_ATT7 : '||X_GDF_RA_CUST_TRX_ATT7 );
2536: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG',

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

2530: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG',
2531: ' X_GDF_RA_CUST_TRX_ATT5 : '||X_GDF_RA_CUST_TRX_ATT5 );
2532: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG',
2533: ' X_GDF_RA_CUST_TRX_ATT6 : '||X_GDF_RA_CUST_TRX_ATT6 );
2534: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG',
2535: ' X_GDF_RA_CUST_TRX_ATT7 : '||X_GDF_RA_CUST_TRX_ATT7 );
2536: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG',
2537: ' X_GDF_RA_CUST_TRX_ATT8 : '||X_GDF_RA_CUST_TRX_ATT8 );
2538:

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

2532: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG',
2533: ' X_GDF_RA_CUST_TRX_ATT6 : '||X_GDF_RA_CUST_TRX_ATT6 );
2534: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG',
2535: ' X_GDF_RA_CUST_TRX_ATT7 : '||X_GDF_RA_CUST_TRX_ATT7 );
2536: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG',
2537: ' X_GDF_RA_CUST_TRX_ATT8 : '||X_GDF_RA_CUST_TRX_ATT8 );
2538:
2539: END IF;
2540:

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

2540:
2541: END IF;
2542:
2543: IF (g_level_procedure >= g_current_runtime_level ) THEN
2544: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_JA_EXTRACT_PKG',
2545: 'GET_EXPORT_INFO(-)');
2546: END IF;
2547:
2548: EXCEPTION

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

2547:
2548: EXCEPTION
2549: WHEN NO_DATA_FOUND THEN
2550: IF ( g_level_statement>= g_current_runtime_level ) THEN
2551: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG',
2552: 'Error Message : GET_EXPORT_INFO : '||substrb(SQLERRM,1,120) );
2553: END IF;
2554:
2555: