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

Line 338: -- Declare global varibles for FND log messages

334: g_chart_of_accounts_id NUMBER;
335: g_gl_or_trx_date_filter varchar(1); --Bug 5347188
336: g_reported_status VARCHAR2(30);
337:
338: -- Declare global varibles for FND log messages
339:
340: g_current_runtime_level NUMBER;
341: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
342: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;

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

337:
338: -- Declare global varibles for FND log messages
339:
340: g_current_runtime_level NUMBER;
341: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
342: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
343: g_level_event CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
344: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
345: g_error_buffer VARCHAR2(100);

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

338: -- Declare global varibles for FND log messages
339:
340: g_current_runtime_level NUMBER;
341: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
342: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
343: g_level_event CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
344: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
345: g_error_buffer VARCHAR2(100);
346:

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

339:
340: g_current_runtime_level NUMBER;
341: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
342: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
343: g_level_event CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
344: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
345: g_error_buffer VARCHAR2(100);
346:
347:

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

340: g_current_runtime_level NUMBER;
341: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
342: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
343: g_level_event CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
344: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
345: g_error_buffer VARCHAR2(100);
346:
347:
348: /*===========================================================================+

Line 372: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

368: )
369: IS
370:
371: BEGIN
372: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
373:
374: g_retcode := p_trl_global_variables_rec.retcode;
375: IF (g_level_procedure >= g_current_runtime_level ) THEN
376: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.INSERT_TAX_DATA.BEGIN',

Line 376: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.INSERT_TAX_DATA.BEGIN',

372: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
373:
374: g_retcode := p_trl_global_variables_rec.retcode;
375: IF (g_level_procedure >= g_current_runtime_level ) THEN
376: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.INSERT_TAX_DATA.BEGIN',
377: 'ZX_AP_EXTRACT_PKG: INSERT_TAX_DATA(+)');
378: END IF;
379:
380: assign_global_parameters(

Line 388: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_EXTRACT_PKG',

384: build_sql;
385: END IF;
386:
387: IF ( g_level_statement>= g_current_runtime_level ) THEN
388: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_EXTRACT_PKG',
389: ' g_ret_code after build_sql : '||g_retcode );
390: END IF;
391:
392: IF g_retcode <> 2 THEN

Line 397: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_EXTRACT_PKG',

393: execute_sql_stmt;
394: END IF;
395:
396: IF ( g_level_statement>= g_current_runtime_level ) THEN
397: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_EXTRACT_PKG',
398: ' g_ret_code after execute_sql_stmt : '||g_retcode );
399: END IF;
400:
401: IF g_retcode <> 2 AND g_summary_level = 'TRANSACTION' AND g_report_name = 'RXZXPFTR' THEN

Line 406: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_EXTRACT_PKG',

402: ftr_taxable_amount_prorate;
403: END IF;
404:
405: IF ( g_level_statement>= g_current_runtime_level ) THEN
406: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_EXTRACT_PKG',
407: ' g_ret_code after ftr_taxable_amount_prorate : '||g_retcode );
408: END IF;
409:
410: IF g_retcode <> 2 THEN

Line 415: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_EXTRACT_PKG',

411: filter_validated;
412: END IF;
413:
414: IF ( g_level_statement>= g_current_runtime_level ) THEN
415: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_EXTRACT_PKG',
416: ' g_ret_code after filter_validated : '||g_retcode );
417: END IF;
418:
419: p_trl_global_variables_rec.retcode := g_retcode;

Line 422: FND_LOG.STRING(g_level_procedure,

418:
419: p_trl_global_variables_rec.retcode := g_retcode;
420:
421: IF (g_level_procedure >= g_current_runtime_level ) THEN
422: FND_LOG.STRING(g_level_procedure,
423: 'ZX.TRL.ZX_AP_EXTRACT_PKG.INSERT_TAX_DATA.END',
424: 'ZX_AP_EXTRACT_PKG: INSERT_TAX_DATA(-)');
425: END IF;
426:

Line 434: FND_LOG.STRING(g_level_unexpected,

430: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
431: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','insert_tax_data- '|| g_error_buffer);
432: FND_MSG_PUB.Add;
433: IF (g_level_unexpected >= g_current_runtime_level ) THEN
434: FND_LOG.STRING(g_level_unexpected,
435: 'ZX.TRL.ZX_AP_EXTRACT_PKG.insert_tax_data',
436: g_error_buffer);
437: END IF;
438: p_trl_global_variables_rec.retcode := 2;

Line 566: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.BUILD_SQL.BEGIN',

562:
563: BEGIN
564:
565: IF (g_level_procedure >= g_current_runtime_level ) THEN
566: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.BUILD_SQL.BEGIN',
567: 'ZX_AP_EXTRACT_PKG: BUILD_SQL(+)');
568: END IF;
569:
570:

Line 585: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.BUILD_SQL',

581: FND_MO_REPORTING_API.INITIALIZE(G_REPORTING_LEVEL,G_REPORTING_CONTEXT,'AUTO');
582:
583: l_fnd_mo_org_stg := FND_MO_REPORTING_API.GET_PREDICATE('ZX_DET',NULL,L_REPORTING_CONTEXT_VAL);
584: IF (g_level_procedure >= g_current_runtime_level ) THEN
585: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.BUILD_SQL',
586: 'l_fnd_mo_org_stg = '||l_fnd_mo_org_stg);
587: END IF;
588:
589: -- l_string_len := LENGTH(l_fnd_mo_org_stg);

Line 594: -- FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.BUILD_SQL',

590: -- l_equal_pos := instr(l_fnd_mo_org_stg,'=');
591: -- l_org_len := l_string_len - 19;
592: -- l_get_org_id := substr(l_fnd_mo_org_stg,l_equal_pos,l_string_len);
593: -- IF (g_level_procedure >= g_current_runtime_level ) THEN
594: -- FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.BUILD_SQL',
595: -- 'l_fnd_mo_org_stg = '||l_get_org_id||' Pos '||to_char(l_equal_pos)||' Len '||to_char(l_string_len));
596: -- END IF;
597:
598: IF instr(l_fnd_mo_org_stg,'ORG_ID') = 0 THEN

Line 605: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.BUILD_SQL',

601: l_internal_org_stg:= replace (l_fnd_mo_org_stg,'ORG_ID','INTERNAL_ORGANIZATION_ID');
602: END IF;
603:
604: IF (g_level_procedure >= g_current_runtime_level ) THEN
605: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.BUILD_SQL',
606: 'l_internal_org_stg = '||l_internal_org_stg);
607: END IF;
608:
609: IF G_REPORTING_LEVEL IN ('1000','3000') THEN

Line 618: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.BUILD_SQL',

614: L_WHERE_ZXXTATAT_SPECIFIC := ' AND NULL IS NULL ';
615: END IF;
616:
617: IF (g_level_procedure >= g_current_runtime_level ) THEN
618: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.BUILD_SQL',
619: 'L_WHERE_REPORT_CONTEXT = '||L_WHERE_REPORT_CONTEXT);
620: END IF;
621:
622: -- New Parameter code

Line 989: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.BUILD_SQL',

985:
986: IF g_report_name = 'RXZXPFTR' THEN
987:
988: IF (g_level_procedure >= g_current_runtime_level ) THEN
989: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.BUILD_SQL',
990: 'SQL-1-FTR For Invoice, Credit Memo, Debit Memo: Header Level');
991: END IF;
992:
993: l_sql_statement :=

Line 1337: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.BUILD_SQL',

1333: zx_dist.gl_date';
1334: ELSE
1335:
1336: IF (g_level_procedure >= g_current_runtime_level ) THEN
1337: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.BUILD_SQL',
1338: 'SQL-1 For Invoice, Credit Memo, Debit Memo: Header Level');
1339: END IF;
1340:
1341: l_sql_statement :=

Line 1708: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.BUILD_SQL',

1704:
1705: ELSIF G_SUMMARY_LEVEL = 'TRANSACTION_DISTRIBUTION' THEN
1706:
1707: IF (g_level_procedure >= g_current_runtime_level ) THEN
1708: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.BUILD_SQL',
1709: 'SQL-2 For Invoice, Credit Memo, Debit Memo: Distribution Level');
1710: END IF;
1711: -- bug 8250832 adding hint dynamically
1712: IF g_gl_date_low IS NOT NULL AND

Line 1949: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.BUILD_SQL',

1945: g_sql_statement := l_sql_statement ;
1946:
1947: IF g_report_name ='ZXXTATAT' THEN
1948: IF (g_level_procedure >= g_current_runtime_level ) THEN
1949: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.BUILD_SQL',
1950: 'SQL-2-1 For Invoice, Credit Memo, Debit Memo: Distribution Level');
1951: END IF;
1952: l_sql_statement_no_tax := 'SELECT /*+ leading(ap_dist) index(ap_dist AP_INVOICE_DISTRIBUTIONS_N4) */ ' ||
1953: ' DISTINCT zx_det.application_id,

Line 2184: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.BUILD_SQL',

2180:
2181: IF G_SUMMARY_LEVEL = 'TRANSACTION_LINE' THEN
2182:
2183: IF (g_level_procedure >= g_current_runtime_level ) THEN
2184: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.BUILD_SQL',
2185: 'SQL-3 For Invoice, Credit Memo, Debit Memo: Line Level');
2186: END IF;
2187: -- bug 8250832 adding hint dynamically
2188: IF g_gl_date_low IS NOT NULL AND

Line 2601: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.BUILD_SQL.END',

2597:
2598: END IF; -- summary level
2599:
2600: IF (g_level_procedure >= g_current_runtime_level ) THEN
2601: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.BUILD_SQL.END',
2602: 'ZX_AP_EXTRACT_PKG: BUILD_SQL(-)');
2603: END IF;
2604:
2605: EXCEPTION

Line 2612: FND_LOG.STRING(g_level_unexpected,

2608: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
2609: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','build_sql- '|| g_error_buffer);
2610: FND_MSG_PUB.Add;
2611: IF (g_level_unexpected >= g_current_runtime_level ) THEN
2612: FND_LOG.STRING(g_level_unexpected,
2613: 'ZX.TRL.ZX_AP_EXTRACT_PKG.build_sql',
2614: g_error_buffer);
2615: END IF;
2616: g_retcode := 2;

Line 2661: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT.BEGIN',

2657:
2658: BEGIN
2659:
2660: IF (g_level_procedure >= g_current_runtime_level ) THEN
2661: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT.BEGIN',
2662: 'ZX_AP_EXTRACT_PKG: EXECUTE_SQL_STMT(+)');
2663: END IF;
2664:
2665:

Line 2672: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL',

2668: -- l_sql_statement_tbl(3) := G_COLUMN_LIST_TRX_LINE_LVL; --AP Line level
2669:
2670: IF (g_level_procedure >= g_current_runtime_level ) THEN
2671: --Added as part of testing ( for showing all the bind vars values )
2672: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL',
2673: ' Displaying all the Global Bind Variable Values used for the Dynamic SQL Stmt ' );
2674: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL',
2675: 'g_report_name : '||g_report_name);
2676: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL',

Line 2674: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL',

2670: IF (g_level_procedure >= g_current_runtime_level ) THEN
2671: --Added as part of testing ( for showing all the bind vars values )
2672: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL',
2673: ' Displaying all the Global Bind Variable Values used for the Dynamic SQL Stmt ' );
2674: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL',
2675: 'g_report_name : '||g_report_name);
2676: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL',
2677: 'g_gl_date_low : '||g_gl_date_low);
2678: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL',

Line 2676: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL',

2672: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL',
2673: ' Displaying all the Global Bind Variable Values used for the Dynamic SQL Stmt ' );
2674: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL',
2675: 'g_report_name : '||g_report_name);
2676: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL',
2677: 'g_gl_date_low : '||g_gl_date_low);
2678: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL',
2679: 'g_gl_date_high : '||g_gl_date_high);
2680: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL',

Line 2678: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL',

2674: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL',
2675: 'g_report_name : '||g_report_name);
2676: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL',
2677: 'g_gl_date_low : '||g_gl_date_low);
2678: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL',
2679: 'g_gl_date_high : '||g_gl_date_high);
2680: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL',
2681: 'G_LEDGER_ID : '||G_LEDGER_ID);
2682: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL',

Line 2680: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL',

2676: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL',
2677: 'g_gl_date_low : '||g_gl_date_low);
2678: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL',
2679: 'g_gl_date_high : '||g_gl_date_high);
2680: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL',
2681: 'G_LEDGER_ID : '||G_LEDGER_ID);
2682: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL',
2683: 'g_trx_date_low : '||g_trx_date_low);
2684: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL',

Line 2682: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL',

2678: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL',
2679: 'g_gl_date_high : '||g_gl_date_high);
2680: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL',
2681: 'G_LEDGER_ID : '||G_LEDGER_ID);
2682: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL',
2683: 'g_trx_date_low : '||g_trx_date_low);
2684: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL',
2685: 'g_trx_date_high : '||g_trx_date_high);
2686: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL',

Line 2684: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL',

2680: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL',
2681: 'G_LEDGER_ID : '||G_LEDGER_ID);
2682: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL',
2683: 'g_trx_date_low : '||g_trx_date_low);
2684: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL',
2685: 'g_trx_date_high : '||g_trx_date_high);
2686: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL',
2687: 'g_trx_number_low : '||g_trx_number_low);
2688: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL',

Line 2686: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL',

2682: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL',
2683: 'g_trx_date_low : '||g_trx_date_low);
2684: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL',
2685: 'g_trx_date_high : '||g_trx_date_high);
2686: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL',
2687: 'g_trx_number_low : '||g_trx_number_low);
2688: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL',
2689: 'g_trx_number_high : '||g_trx_number_high);
2690: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL',

Line 2688: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL',

2684: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL',
2685: 'g_trx_date_high : '||g_trx_date_high);
2686: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL',
2687: 'g_trx_number_low : '||g_trx_number_low);
2688: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL',
2689: 'g_trx_number_high : '||g_trx_number_high);
2690: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL',
2691: 'g_vat_transaction_type_code : '||g_vat_transaction_type_code);
2692: -- FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL',

Line 2690: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL',

2686: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL',
2687: 'g_trx_number_low : '||g_trx_number_low);
2688: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL',
2689: 'g_trx_number_high : '||g_trx_number_high);
2690: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL',
2691: 'g_vat_transaction_type_code : '||g_vat_transaction_type_code);
2692: -- FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL',
2693: -- 'g_document_sub_type : '||g_document_sub_type);
2694: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL',

Line 2692: -- FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL',

2688: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL',
2689: 'g_trx_number_high : '||g_trx_number_high);
2690: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL',
2691: 'g_vat_transaction_type_code : '||g_vat_transaction_type_code);
2692: -- FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL',
2693: -- 'g_document_sub_type : '||g_document_sub_type);
2694: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL',
2695: 'g_trx_business_category : '||g_trx_business_category);
2696: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL',

Line 2694: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL',

2690: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL',
2691: 'g_vat_transaction_type_code : '||g_vat_transaction_type_code);
2692: -- FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL',
2693: -- 'g_document_sub_type : '||g_document_sub_type);
2694: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL',
2695: 'g_trx_business_category : '||g_trx_business_category);
2696: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL',
2697: 'g_tax_invoice_date_low : '||g_tax_invoice_date_low);
2698: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL',

Line 2696: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL',

2692: -- FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL',
2693: -- 'g_document_sub_type : '||g_document_sub_type);
2694: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL',
2695: 'g_trx_business_category : '||g_trx_business_category);
2696: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL',
2697: 'g_tax_invoice_date_low : '||g_tax_invoice_date_low);
2698: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL',
2699: 'g_tax_invoice_date_high : '||g_tax_invoice_date_high);
2700: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL',

Line 2698: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL',

2694: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL',
2695: 'g_trx_business_category : '||g_trx_business_category);
2696: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL',
2697: 'g_tax_invoice_date_low : '||g_tax_invoice_date_low);
2698: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL',
2699: 'g_tax_invoice_date_high : '||g_tax_invoice_date_high);
2700: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL',
2701: 'g_tax_jurisdiction_code : '||g_tax_jurisdiction_code);
2702: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL',

Line 2700: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL',

2696: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL',
2697: 'g_tax_invoice_date_low : '||g_tax_invoice_date_low);
2698: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL',
2699: 'g_tax_invoice_date_high : '||g_tax_invoice_date_high);
2700: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL',
2701: 'g_tax_jurisdiction_code : '||g_tax_jurisdiction_code);
2702: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL',
2703: 'g_first_party_tax_reg_num : '||g_first_party_tax_reg_num);
2704: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL',

Line 2702: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL',

2698: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL',
2699: 'g_tax_invoice_date_high : '||g_tax_invoice_date_high);
2700: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL',
2701: 'g_tax_jurisdiction_code : '||g_tax_jurisdiction_code);
2702: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL',
2703: 'g_first_party_tax_reg_num : '||g_first_party_tax_reg_num);
2704: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL',
2705: 'g_tax_regime_code : '||g_tax_regime_code);
2706: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL',

Line 2704: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL',

2700: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL',
2701: 'g_tax_jurisdiction_code : '||g_tax_jurisdiction_code);
2702: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL',
2703: 'g_first_party_tax_reg_num : '||g_first_party_tax_reg_num);
2704: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL',
2705: 'g_tax_regime_code : '||g_tax_regime_code);
2706: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL',
2707: 'g_tax : '||g_tax);
2708: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL',

Line 2706: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL',

2702: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL',
2703: 'g_first_party_tax_reg_num : '||g_first_party_tax_reg_num);
2704: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL',
2705: 'g_tax_regime_code : '||g_tax_regime_code);
2706: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL',
2707: 'g_tax : '||g_tax);
2708: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL',
2709: 'g_tax_status_code : '||g_tax_status_code);
2710: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL',

Line 2708: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL',

2704: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL',
2705: 'g_tax_regime_code : '||g_tax_regime_code);
2706: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL',
2707: 'g_tax : '||g_tax);
2708: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL',
2709: 'g_tax_status_code : '||g_tax_status_code);
2710: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL',
2711: 'g_tax_rate_code_low : '||g_tax_rate_code_low);
2712: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL',

Line 2710: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL',

2706: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL',
2707: 'g_tax : '||g_tax);
2708: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL',
2709: 'g_tax_status_code : '||g_tax_status_code);
2710: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL',
2711: 'g_tax_rate_code_low : '||g_tax_rate_code_low);
2712: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL',
2713: 'g_tax_rate_code_high : '||g_tax_rate_code_high);
2714: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL',

Line 2712: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL',

2708: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL',
2709: 'g_tax_status_code : '||g_tax_status_code);
2710: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL',
2711: 'g_tax_rate_code_low : '||g_tax_rate_code_low);
2712: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL',
2713: 'g_tax_rate_code_high : '||g_tax_rate_code_high);
2714: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL',
2715: 'g_tax_type_code_low : '||g_tax_type_code_low);
2716: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL',

Line 2714: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL',

2710: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL',
2711: 'g_tax_rate_code_low : '||g_tax_rate_code_low);
2712: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL',
2713: 'g_tax_rate_code_high : '||g_tax_rate_code_high);
2714: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL',
2715: 'g_tax_type_code_low : '||g_tax_type_code_low);
2716: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL',
2717: 'g_tax_type_code_high : '||g_tax_type_code_high);
2718: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL',

Line 2716: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL',

2712: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL',
2713: 'g_tax_rate_code_high : '||g_tax_rate_code_high);
2714: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL',
2715: 'g_tax_type_code_low : '||g_tax_type_code_low);
2716: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL',
2717: 'g_tax_type_code_high : '||g_tax_type_code_high);
2718: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL',
2719: 'g_currency_code_low : '||g_currency_code_low);
2720: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL',

Line 2718: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL',

2714: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL',
2715: 'g_tax_type_code_low : '||g_tax_type_code_low);
2716: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL',
2717: 'g_tax_type_code_high : '||g_tax_type_code_high);
2718: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL',
2719: 'g_currency_code_low : '||g_currency_code_low);
2720: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL',
2721: 'g_currency_code_high : '||g_currency_code_high);
2722: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL',

Line 2720: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL',

2716: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL',
2717: 'g_tax_type_code_high : '||g_tax_type_code_high);
2718: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL',
2719: 'g_currency_code_low : '||g_currency_code_low);
2720: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL',
2721: 'g_currency_code_high : '||g_currency_code_high);
2722: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL',
2723: 'g_legal_entity_id : '||g_legal_entity_id);
2724: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL',

Line 2722: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL',

2718: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL',
2719: 'g_currency_code_low : '||g_currency_code_low);
2720: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL',
2721: 'g_currency_code_high : '||g_currency_code_high);
2722: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL',
2723: 'g_legal_entity_id : '||g_legal_entity_id);
2724: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL',
2725: 'g_ledger_id : '||g_ledger_id);
2726:

Line 2724: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL',

2720: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL',
2721: 'g_currency_code_high : '||g_currency_code_high);
2722: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL',
2723: 'g_legal_entity_id : '||g_legal_entity_id);
2724: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL',
2725: 'g_ledger_id : '||g_ledger_id);
2726:
2727: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL', 'Dynamic sql statement : '||g_summary_level);
2728: l_sql1 := substr(g_sql_statement,1,3000);

Line 2727: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL', 'Dynamic sql statement : '||g_summary_level);

2723: 'g_legal_entity_id : '||g_legal_entity_id);
2724: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL',
2725: 'g_ledger_id : '||g_ledger_id);
2726:
2727: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL', 'Dynamic sql statement : '||g_summary_level);
2728: l_sql1 := substr(g_sql_statement,1,3000);
2729: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL', 'g_sql_statement : '||l_sql1);
2730: l_sql2 := substr(g_sql_statement,3001,3000);
2731: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL', 'g_sql_statement : '||l_sql2);

Line 2729: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL', 'g_sql_statement : '||l_sql1);

2725: 'g_ledger_id : '||g_ledger_id);
2726:
2727: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL', 'Dynamic sql statement : '||g_summary_level);
2728: l_sql1 := substr(g_sql_statement,1,3000);
2729: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL', 'g_sql_statement : '||l_sql1);
2730: l_sql2 := substr(g_sql_statement,3001,3000);
2731: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL', 'g_sql_statement : '||l_sql2);
2732: l_sql3 := substr(g_sql_statement,6001,3000);
2733: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL', 'g_sql_statement : '||l_sql3);

Line 2731: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL', 'g_sql_statement : '||l_sql2);

2727: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL', 'Dynamic sql statement : '||g_summary_level);
2728: l_sql1 := substr(g_sql_statement,1,3000);
2729: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL', 'g_sql_statement : '||l_sql1);
2730: l_sql2 := substr(g_sql_statement,3001,3000);
2731: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL', 'g_sql_statement : '||l_sql2);
2732: l_sql3 := substr(g_sql_statement,6001,3000);
2733: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL', 'g_sql_statement : '||l_sql3);
2734: l_sql4 := substr(g_sql_statement,9001,3000);
2735: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL', 'g_sql_statement : '||l_sql4);

Line 2733: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL', 'g_sql_statement : '||l_sql3);

2729: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL', 'g_sql_statement : '||l_sql1);
2730: l_sql2 := substr(g_sql_statement,3001,3000);
2731: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL', 'g_sql_statement : '||l_sql2);
2732: l_sql3 := substr(g_sql_statement,6001,3000);
2733: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL', 'g_sql_statement : '||l_sql3);
2734: l_sql4 := substr(g_sql_statement,9001,3000);
2735: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL', 'g_sql_statement : '||l_sql4);
2736: l_sql5 := substr(g_sql_statement,12001,3000);
2737: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL', 'g_sql_statement : '||l_sql5);

Line 2735: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL', 'g_sql_statement : '||l_sql4);

2731: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL', 'g_sql_statement : '||l_sql2);
2732: l_sql3 := substr(g_sql_statement,6001,3000);
2733: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL', 'g_sql_statement : '||l_sql3);
2734: l_sql4 := substr(g_sql_statement,9001,3000);
2735: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL', 'g_sql_statement : '||l_sql4);
2736: l_sql5 := substr(g_sql_statement,12001,3000);
2737: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL', 'g_sql_statement : '||l_sql5);
2738: l_sql6 := substr(g_sql_statement,15001,3000);
2739: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL', 'g_sql_statement : '||l_sql6);

Line 2737: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL', 'g_sql_statement : '||l_sql5);

2733: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL', 'g_sql_statement : '||l_sql3);
2734: l_sql4 := substr(g_sql_statement,9001,3000);
2735: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL', 'g_sql_statement : '||l_sql4);
2736: l_sql5 := substr(g_sql_statement,12001,3000);
2737: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL', 'g_sql_statement : '||l_sql5);
2738: l_sql6 := substr(g_sql_statement,15001,3000);
2739: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL', 'g_sql_statement : '||l_sql6);
2740: l_sql7 := substr(g_sql_statement,18001,3000);
2741: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL', 'g_sql_statement : '||l_sql7);

Line 2739: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL', 'g_sql_statement : '||l_sql6);

2735: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL', 'g_sql_statement : '||l_sql4);
2736: l_sql5 := substr(g_sql_statement,12001,3000);
2737: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL', 'g_sql_statement : '||l_sql5);
2738: l_sql6 := substr(g_sql_statement,15001,3000);
2739: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL', 'g_sql_statement : '||l_sql6);
2740: l_sql7 := substr(g_sql_statement,18001,3000);
2741: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL', 'g_sql_statement : '||l_sql7);
2742: l_sql8 := substr(g_sql_statement,21001,3000);
2743: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL', 'g_sql_statement : '||l_sql8);

Line 2741: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL', 'g_sql_statement : '||l_sql7);

2737: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL', 'g_sql_statement : '||l_sql5);
2738: l_sql6 := substr(g_sql_statement,15001,3000);
2739: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL', 'g_sql_statement : '||l_sql6);
2740: l_sql7 := substr(g_sql_statement,18001,3000);
2741: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL', 'g_sql_statement : '||l_sql7);
2742: l_sql8 := substr(g_sql_statement,21001,3000);
2743: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL', 'g_sql_statement : '||l_sql8);
2744:
2745: l_sql1_no_tax := substr(g_sql_statement_no_tax,1,3000);

Line 2743: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL', 'g_sql_statement : '||l_sql8);

2739: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL', 'g_sql_statement : '||l_sql6);
2740: l_sql7 := substr(g_sql_statement,18001,3000);
2741: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL', 'g_sql_statement : '||l_sql7);
2742: l_sql8 := substr(g_sql_statement,21001,3000);
2743: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL', 'g_sql_statement : '||l_sql8);
2744:
2745: l_sql1_no_tax := substr(g_sql_statement_no_tax,1,3000);
2746: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL', 'g_sql_statement_no_tax : '||l_sql1_no_tax);
2747: l_sql2_no_tax := substr(g_sql_statement_no_tax,3001,3000);

Line 2746: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL', 'g_sql_statement_no_tax : '||l_sql1_no_tax);

2742: l_sql8 := substr(g_sql_statement,21001,3000);
2743: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL', 'g_sql_statement : '||l_sql8);
2744:
2745: l_sql1_no_tax := substr(g_sql_statement_no_tax,1,3000);
2746: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL', 'g_sql_statement_no_tax : '||l_sql1_no_tax);
2747: l_sql2_no_tax := substr(g_sql_statement_no_tax,3001,3000);
2748: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL', 'g_sql_statement_no_tax : '||l_sql2_no_tax);
2749: l_sql3_no_tax := substr(g_sql_statement_no_tax,6001,3000);
2750: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL', 'g_sql_statement_no_tax : '||l_sql3_no_tax);

Line 2748: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL', 'g_sql_statement_no_tax : '||l_sql2_no_tax);

2744:
2745: l_sql1_no_tax := substr(g_sql_statement_no_tax,1,3000);
2746: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL', 'g_sql_statement_no_tax : '||l_sql1_no_tax);
2747: l_sql2_no_tax := substr(g_sql_statement_no_tax,3001,3000);
2748: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL', 'g_sql_statement_no_tax : '||l_sql2_no_tax);
2749: l_sql3_no_tax := substr(g_sql_statement_no_tax,6001,3000);
2750: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL', 'g_sql_statement_no_tax : '||l_sql3_no_tax);
2751: l_sql4_no_tax := substr(g_sql_statement_no_tax,9001,3000);
2752: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL', 'g_sql_statement_no_tax : '||l_sql4_no_tax);

Line 2750: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL', 'g_sql_statement_no_tax : '||l_sql3_no_tax);

2746: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL', 'g_sql_statement_no_tax : '||l_sql1_no_tax);
2747: l_sql2_no_tax := substr(g_sql_statement_no_tax,3001,3000);
2748: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL', 'g_sql_statement_no_tax : '||l_sql2_no_tax);
2749: l_sql3_no_tax := substr(g_sql_statement_no_tax,6001,3000);
2750: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL', 'g_sql_statement_no_tax : '||l_sql3_no_tax);
2751: l_sql4_no_tax := substr(g_sql_statement_no_tax,9001,3000);
2752: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL', 'g_sql_statement_no_tax : '||l_sql4_no_tax);
2753: l_sql5_no_tax := substr(g_sql_statement_no_tax,12001,3000);
2754: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL', 'g_sql_statement_no_tax : '||l_sql5_no_tax);

Line 2752: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL', 'g_sql_statement_no_tax : '||l_sql4_no_tax);

2748: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL', 'g_sql_statement_no_tax : '||l_sql2_no_tax);
2749: l_sql3_no_tax := substr(g_sql_statement_no_tax,6001,3000);
2750: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL', 'g_sql_statement_no_tax : '||l_sql3_no_tax);
2751: l_sql4_no_tax := substr(g_sql_statement_no_tax,9001,3000);
2752: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL', 'g_sql_statement_no_tax : '||l_sql4_no_tax);
2753: l_sql5_no_tax := substr(g_sql_statement_no_tax,12001,3000);
2754: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL', 'g_sql_statement_no_tax : '||l_sql5_no_tax);
2755: l_sql6_no_tax := substr(g_sql_statement_no_tax,15001,3000);
2756: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL', 'g_sql_statement_no_tax : '||l_sql6_no_tax);

Line 2754: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL', 'g_sql_statement_no_tax : '||l_sql5_no_tax);

2750: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL', 'g_sql_statement_no_tax : '||l_sql3_no_tax);
2751: l_sql4_no_tax := substr(g_sql_statement_no_tax,9001,3000);
2752: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL', 'g_sql_statement_no_tax : '||l_sql4_no_tax);
2753: l_sql5_no_tax := substr(g_sql_statement_no_tax,12001,3000);
2754: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL', 'g_sql_statement_no_tax : '||l_sql5_no_tax);
2755: l_sql6_no_tax := substr(g_sql_statement_no_tax,15001,3000);
2756: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL', 'g_sql_statement_no_tax : '||l_sql6_no_tax);
2757: l_sql7_no_tax := substr(g_sql_statement_no_tax,18001,3000);
2758: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL', 'g_sql_statement_no_tax : '||l_sql7_no_tax);

Line 2756: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL', 'g_sql_statement_no_tax : '||l_sql6_no_tax);

2752: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL', 'g_sql_statement_no_tax : '||l_sql4_no_tax);
2753: l_sql5_no_tax := substr(g_sql_statement_no_tax,12001,3000);
2754: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL', 'g_sql_statement_no_tax : '||l_sql5_no_tax);
2755: l_sql6_no_tax := substr(g_sql_statement_no_tax,15001,3000);
2756: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL', 'g_sql_statement_no_tax : '||l_sql6_no_tax);
2757: l_sql7_no_tax := substr(g_sql_statement_no_tax,18001,3000);
2758: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL', 'g_sql_statement_no_tax : '||l_sql7_no_tax);
2759: l_sql8_no_tax := substr(g_sql_statement_no_tax,21001,3000);
2760: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL', 'g_sql_statement_no_tax : '||l_sql8_no_tax);

Line 2758: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL', 'g_sql_statement_no_tax : '||l_sql7_no_tax);

2754: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL', 'g_sql_statement_no_tax : '||l_sql5_no_tax);
2755: l_sql6_no_tax := substr(g_sql_statement_no_tax,15001,3000);
2756: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL', 'g_sql_statement_no_tax : '||l_sql6_no_tax);
2757: l_sql7_no_tax := substr(g_sql_statement_no_tax,18001,3000);
2758: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL', 'g_sql_statement_no_tax : '||l_sql7_no_tax);
2759: l_sql8_no_tax := substr(g_sql_statement_no_tax,21001,3000);
2760: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL', 'g_sql_statement_no_tax : '||l_sql8_no_tax);
2761: END IF;
2762:

Line 2760: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL', 'g_sql_statement_no_tax : '||l_sql8_no_tax);

2756: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL', 'g_sql_statement_no_tax : '||l_sql6_no_tax);
2757: l_sql7_no_tax := substr(g_sql_statement_no_tax,18001,3000);
2758: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL', 'g_sql_statement_no_tax : '||l_sql7_no_tax);
2759: l_sql8_no_tax := substr(g_sql_statement_no_tax,21001,3000);
2760: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL', 'g_sql_statement_no_tax : '||l_sql8_no_tax);
2761: END IF;
2762:
2763:
2764:

Line 2768: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL',

2764:
2765: fetch_tax_info(g_sql_statement);
2766: IF g_report_name = 'ZXXTATAT' THEN
2767: IF (g_level_procedure >= g_current_runtime_level ) THEN
2768: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT SQL',
2769: 'Calling fetch_tax_info explicitly for TAT report');
2770: END IF;
2771: fetch_tax_info(g_sql_statement_no_tax);
2772: END IF;

Line 2782: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.execute_sql_stmt.END',

2778: -- COMMIT;
2779: -- END LOOP;
2780:
2781: IF (g_level_procedure >= g_current_runtime_level ) THEN
2782: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.execute_sql_stmt.END',
2783: 'ZX_AP_EXTRACT_PKG: execute_sql_stmt(-)');
2784: END IF;
2785:
2786: EXCEPTION

Line 2793: FND_LOG.STRING(g_level_unexpected,

2789: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
2790: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','execute_sql_stmt- '|| g_error_buffer);
2791: FND_MSG_PUB.Add;
2792: IF (g_level_unexpected >= g_current_runtime_level ) THEN
2793: FND_LOG.STRING(g_level_unexpected,
2794: 'ZX.TRL.ZX_AP_EXTRACT_PKG.execute_sql_stmt',
2795: g_error_buffer);
2796: END IF;
2797: g_retcode := 2;

Line 2826: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.fetch_tax_info.BEGIN',

2822:
2823: BEGIN
2824:
2825: IF (g_level_procedure >= g_current_runtime_level ) THEN
2826: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.fetch_tax_info.BEGIN',
2827: 'ZX_AP_EXTRACT_PKG: fetch_tax_info(+)');
2828: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.fetch_tax_info',
2829: 'Open cursor');
2830: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.fetch_tax_info',

Line 2828: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.fetch_tax_info',

2824:
2825: IF (g_level_procedure >= g_current_runtime_level ) THEN
2826: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.fetch_tax_info.BEGIN',
2827: 'ZX_AP_EXTRACT_PKG: fetch_tax_info(+)');
2828: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.fetch_tax_info',
2829: 'Open cursor');
2830: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.fetch_tax_info',
2831: 'Gl Date Low/High'||to_char(g_gl_date_low)||' '
2832: ||to_char(g_gl_date_high));

Line 2830: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.fetch_tax_info',

2826: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.fetch_tax_info.BEGIN',
2827: 'ZX_AP_EXTRACT_PKG: fetch_tax_info(+)');
2828: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.fetch_tax_info',
2829: 'Open cursor');
2830: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.fetch_tax_info',
2831: 'Gl Date Low/High'||to_char(g_gl_date_low)||' '
2832: ||to_char(g_gl_date_high));
2833: END IF;
2834:

Line 2872: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.FETCH_TAX_INFO',

2868: g_adjusted_doc_to;
2869: -- g_trading_partner_id;
2870:
2871: IF (g_level_procedure >= g_current_runtime_level ) THEN
2872: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.FETCH_TAX_INFO',
2873: 'After USING Clause Call :');
2874: END IF;
2875:
2876: i := 1;

Line 3064: -- FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.fetch_tax_info',

3060: gt_gl_date(i), -- Bug 5439099
3061: gt_def_rec_settlement_opt_cd(i); -- Bug10238948
3062:
3063: -- IF (g_level_procedure >= g_current_runtime_level ) THEN
3064: -- FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.fetch_tax_info',
3065: -- 'Before insert Call :' ||to_char(GT_TRX_ID.count));
3066: -- END IF;
3067:
3068: IF zx_rep_detail_csr%FOUND THEN

Line 3070: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.fetch_tax_info',

3066: -- END IF;
3067:
3068: IF zx_rep_detail_csr%FOUND THEN
3069: IF (g_level_procedure >= g_current_runtime_level ) THEN
3070: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.fetch_tax_info',
3071: 'zx_rep_detail_csr Found :' );
3072: END IF;
3073:
3074: -- populate EXTRACT_REPORT_LINE_NUMBER

Line 3084: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.FETCH_TAX_INFO',

3080: insert_tax_info;
3081: --COMMIT; Bug 8262631
3082:
3083: IF (g_level_procedure >= g_current_runtime_level ) THEN
3084: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.FETCH_TAX_INFO',
3085: 'After insert_tax_info Call :' );
3086: END IF;
3087: i := 1;
3088: init_gt_variables;

Line 3094: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.FETCH_TAX_INFO',

3090: i := i + 1;
3091: END IF;
3092: ELSE
3093: IF (g_level_procedure >= g_current_runtime_level ) THEN
3094: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.FETCH_TAX_INFO',
3095: 'Before INSERT_TAX_INFO 2 Call :' );
3096: END IF;
3097:
3098: -- total rows fetched less than 1000

Line 3105: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.FETCH_TAX_INFO',

3101: insert_tax_info;
3102: --COMMIT; Bug 8262631
3103:
3104: IF (g_level_procedure >= g_current_runtime_level ) THEN
3105: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.FETCH_TAX_INFO',
3106: 'After INSERT_TAX_INFO 2 :' );
3107: END IF;
3108:
3109: CLOSE zx_rep_detail_csr;

Line 3115: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.fetch_tax_info.END',

3111: END IF;
3112: END LOOP;
3113:
3114: IF (g_level_procedure >= g_current_runtime_level ) THEN
3115: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.fetch_tax_info.END',
3116: 'ZX_AP_EXTRACT_PKG: fetch_tax_info(-)');
3117: END IF;
3118:
3119: EXCEPTION

Line 3126: FND_LOG.STRING(g_level_unexpected,

3122: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
3123: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','populate_tax_data- '|| g_error_buffer);
3124: FND_MSG_PUB.Add;
3125: IF (g_level_unexpected >= g_current_runtime_level ) THEN
3126: FND_LOG.STRING(g_level_unexpected,
3127: 'ZX.TRL.ZX_AP_EXTRACT_PKG.fetch_tax_info',
3128: g_error_buffer);
3129: END IF;
3130:

Line 3156: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.init_gt_variables.BEGIN',

3152:
3153: BEGIN
3154:
3155: IF (g_level_procedure >= g_current_runtime_level ) THEN
3156: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.init_gt_variables.BEGIN',
3157: 'ZX_AP_EXTRACT_PKG: init_gt_variables(+)');
3158: END IF;
3159:
3160: gt_extract_rep_line_num.delete;

Line 3332: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.init_gt_variables.END',

3328: GT_TAX_RATE_CODE_NAME.DELETE;
3329: gt_tax_rate_code_description.delete;
3330: gt_def_rec_settlement_opt_cd.delete; -- Bug10238948
3331: IF (g_level_procedure >= g_current_runtime_level ) THEN
3332: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.init_gt_variables.END',
3333: 'ZX_AP_EXTRACT_PKG: init_gt_variables(-)');
3334: END IF;
3335:
3336: END init_gt_variables;

Line 3360: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.insert_tax_info.BEGIN',

3356:
3357: BEGIN
3358:
3359: IF (g_level_procedure >= g_current_runtime_level ) THEN
3360: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.insert_tax_info.BEGIN',
3361: 'ZX_AP_EXTRACT_PKG: insert_tax_info(+)');
3362: END IF;
3363:
3364: l_count := GT_TRX_ID.COUNT;

Line 3368: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.insert_tax_info',

3364: l_count := GT_TRX_ID.COUNT;
3365:
3366:
3367: IF (g_level_procedure >= g_current_runtime_level ) THEN
3368: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.insert_tax_info',
3369: ' Record Count = ' ||to_char(GT_TRX_ID.COUNT));
3370: END IF;
3371:
3372: FORALL i IN 1 .. l_count

Line 3745: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.insert_tax_info',

3741: )
3742: RETURNING detail_tax_line_id bulk collect into GT_DETAIL_TAX_LINE_ID ;
3743:
3744: IF (g_level_procedure >= g_current_runtime_level ) THEN
3745: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.insert_tax_info',
3746: 'Number of Tax Lines successfully inserted = '||TO_CHAR(l_count));
3747:
3748: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.INSERT_TAX_INFO.END',
3749: 'ZX_AP_EXTRACT_PKG: INIT_GT_VARIABLES(-)');

Line 3748: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.INSERT_TAX_INFO.END',

3744: IF (g_level_procedure >= g_current_runtime_level ) THEN
3745: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.insert_tax_info',
3746: 'Number of Tax Lines successfully inserted = '||TO_CHAR(l_count));
3747:
3748: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.INSERT_TAX_INFO.END',
3749: 'ZX_AP_EXTRACT_PKG: INIT_GT_VARIABLES(-)');
3750: END IF;
3751:
3752: EXCEPTION

Line 3759: FND_LOG.STRING(g_level_unexpected,

3755: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
3756: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','populate_tax_data- '|| g_error_buffer);
3757: FND_MSG_PUB.Add;
3758: IF (g_level_unexpected >= g_current_runtime_level ) THEN
3759: FND_LOG.STRING(g_level_unexpected,
3760: 'ZX.TRL.ZX_AP_EXTRACT_PKG.INSERT_TAX_INFO',
3761: g_error_buffer);
3762: END IF;
3763:

Line 3794: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.assign_global_parameTERS.BEGIN',

3790:
3791: BEGIN
3792:
3793: IF (g_level_procedure >= g_current_runtime_level ) THEN
3794: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.assign_global_parameTERS.BEGIN',
3795: 'ZX_AP_EXTRACT_PKG: assign_global_parametERS(+)');
3796: END IF;
3797:
3798: g_reporting_level := p_trl_global_variables_rec.reporting_level;

Line 3906: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.assign_global_parameters.END',

3902:
3903:
3904:
3905: IF (g_level_procedure >= g_current_runtime_level ) THEN
3906: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.assign_global_parameters.END',
3907: 'ZX_AP_EXTRACT_PKG: assign_global_parameters(-)');
3908: END IF;
3909:
3910: END assign_global_parameters;

Line 4040: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.ftr_taxable_amount_prorate.BEGIN', 'ZX_AP_EXTRACT_PKG: ftr_taxable_amount_prorate(+)');

4036: gl_date;
4037:
4038: BEGIN
4039: IF (g_level_procedure >= g_current_runtime_level ) THEN
4040: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.ftr_taxable_amount_prorate.BEGIN', 'ZX_AP_EXTRACT_PKG: ftr_taxable_amount_prorate(+)');
4041: END IF;
4042:
4043: OPEN get_det_for_merging;
4044: LOOP

Line 4095: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.ftr_taxable_amount_prorate.END ', 'ZX_AP_EXTRACT_PKG: ftr_taxable_amount_prorate(-)');

4091:
4092: init_gt_variables;
4093:
4094: IF (g_level_procedure >= g_current_runtime_level ) THEN
4095: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.ftr_taxable_amount_prorate.END ', 'ZX_AP_EXTRACT_PKG: ftr_taxable_amount_prorate(-)');
4096: END IF;
4097:
4098: EXCEPTION
4099: WHEN OTHERS THEN

Line 4105: FND_LOG.STRING(g_level_unexpected, 'ZX.TRL.ZX_AP_EXTRACT_PKG.ftr_taxable_amount_prorate', g_error_buffer);

4101: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
4102: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','ftr_taxable_amount_prorate- '|| g_error_buffer);
4103: FND_MSG_PUB.Add;
4104: IF (g_level_unexpected >= g_current_runtime_level ) THEN
4105: FND_LOG.STRING(g_level_unexpected, 'ZX.TRL.ZX_AP_EXTRACT_PKG.ftr_taxable_amount_prorate', g_error_buffer);
4106: END IF;
4107: g_retcode := 2;
4108: END FTR_TAXABLE_AMOUNT_PRORATE;
4109:

Line 4131: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.FILTER_VALIDATED.BEGIN',

4127:
4128: BEGIN
4129:
4130: IF (g_level_procedure >= g_current_runtime_level ) THEN
4131: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.FILTER_VALIDATED.BEGIN',
4132: 'ZX_AP_EXTRACT_PKG: FILTER_VALIDATED(+)');
4133: END IF;
4134:
4135: IF g_accounting_status <> 'ACCOUNTED' THEN

Line 4178: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_EXTRACT_PKG',

4174: );
4175: END IF;
4176:
4177: IF ( g_level_statement>= g_current_runtime_level ) THEN
4178: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_EXTRACT_PKG',
4179: ' Deleted Count : Filter_Validated : '||to_char(sql%ROWCOUNT) ); --Bug 5347188
4180: END IF;
4181:
4182: IF (g_level_procedure >= g_current_runtime_level ) THEN

Line 4183: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.FILTER_VALIDATED.BEGIN',

4179: ' Deleted Count : Filter_Validated : '||to_char(sql%ROWCOUNT) ); --Bug 5347188
4180: END IF;
4181:
4182: IF (g_level_procedure >= g_current_runtime_level ) THEN
4183: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.FILTER_VALIDATED.BEGIN',
4184: 'ZX_AP_EXTRACT_PKG: FILTER_VALIDATED(-)');
4185: END IF;
4186:
4187: EXCEPTION

Line 4194: FND_LOG.STRING(g_level_unexpected,

4190: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
4191: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','filter_validated- '|| g_error_buffer);
4192: FND_MSG_PUB.Add;
4193: IF (g_level_unexpected >= g_current_runtime_level ) THEN
4194: FND_LOG.STRING(g_level_unexpected,
4195: 'ZX.TRL.ZX_AP_EXTRACT_PKG.filter_validated',
4196: g_error_buffer);
4197: END IF;
4198: g_retcode := 2;