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 336: -- Declare global varibles for FND log messages

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

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

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

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

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

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

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

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

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

Line 370: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

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

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

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

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

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

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

391: execute_sql_stmt;
392: END IF;
393:
394: IF ( g_level_statement>= g_current_runtime_level ) THEN
395: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_EXTRACT_PKG',
396: ' g_ret_code after execute_sql_stmt : '||g_retcode );
397: END IF;
398:
399: IF g_retcode <> 2 THEN

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

400: filter_validated;
401: END IF;
402:
403: IF ( g_level_statement>= g_current_runtime_level ) THEN
404: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_EXTRACT_PKG',
405: ' g_ret_code after filter_validated : '||g_retcode );
406: END IF;
407:
408: p_trl_global_variables_rec.retcode := g_retcode;

Line 411: FND_LOG.STRING(g_level_procedure,

407:
408: p_trl_global_variables_rec.retcode := g_retcode;
409:
410: IF (g_level_procedure >= g_current_runtime_level ) THEN
411: FND_LOG.STRING(g_level_procedure,
412: 'ZX.TRL.ZX_AP_EXTRACT_PKG.INSERT_TAX_DATA.END',
413: 'ZX_AP_EXTRACT_PKG: INSERT_TAX_DATA(-)');
414: END IF;
415:

Line 423: FND_LOG.STRING(g_level_unexpected,

419: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
420: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','insert_tax_data- '|| g_error_buffer);
421: FND_MSG_PUB.Add;
422: IF (g_level_unexpected >= g_current_runtime_level ) THEN
423: FND_LOG.STRING(g_level_unexpected,
424: 'ZX.TRL.ZX_AP_EXTRACT_PKG.insert_tax_data',
425: g_error_buffer);
426: END IF;
427: p_trl_global_variables_rec.retcode := 2;

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

537:
538: BEGIN
539:
540: IF (g_level_procedure >= g_current_runtime_level ) THEN
541: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.BUILD_SQL.BEGIN',
542: 'ZX_AP_EXTRACT_PKG: BUILD_SQL(+)');
543: END IF;
544:
545:

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

556: FND_MO_REPORTING_API.INITIALIZE(G_REPORTING_LEVEL,G_REPORTING_CONTEXT,'AUTO');
557:
558: l_fnd_mo_org_stg := FND_MO_REPORTING_API.GET_PREDICATE('ZX_DET',NULL,L_REPORTING_CONTEXT_VAL);
559: IF (g_level_procedure >= g_current_runtime_level ) THEN
560: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.BUILD_SQL',
561: 'l_fnd_mo_org_stg = '||l_fnd_mo_org_stg);
562: END IF;
563:
564: /* l_string_len := LENGTH(l_fnd_mo_org_stg);

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

565: l_equal_pos := instr(l_fnd_mo_org_stg,'=');
566: -- l_org_len := l_string_len - 19;
567: l_get_org_id := substr(l_fnd_mo_org_stg,l_equal_pos,l_string_len);
568: IF (g_level_procedure >= g_current_runtime_level ) THEN
569: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.BUILD_SQL',
570: 'l_fnd_mo_org_stg = '||l_get_org_id||' Pos '||to_char(l_equal_pos)||' Len '||to_char(l_string_len));
571: END IF; */
572: l_internal_org_stg:= replace (l_fnd_mo_org_stg,'ORG_ID','INTERNAL_ORGANIZATION_ID');
573:

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

571: END IF; */
572: l_internal_org_stg:= replace (l_fnd_mo_org_stg,'ORG_ID','INTERNAL_ORGANIZATION_ID');
573:
574: IF (g_level_procedure >= g_current_runtime_level ) THEN
575: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.BUILD_SQL',
576: 'l_internal_org_stg = '||l_internal_org_stg);
577: END IF;
578:
579: --L_WHERE_REPORT_CONTEXT := 'AND ZX_DET.INTERNAL_ORGANIZATION_ID '||l_get_org_id;

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

584: L_WHERE_REPORT_CONTEXT := 'AND NULL IS NULL';
585: END IF;
586:
587: IF (g_level_procedure >= g_current_runtime_level ) THEN
588: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.BUILD_SQL',
589: 'L_WHERE_REPORT_CONTEXT = '||L_WHERE_REPORT_CONTEXT);
590: END IF;
591:
592: -- New Parameter code

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

906:
907: IF g_summary_level = 'TRANSACTION' THEN
908:
909: IF (g_level_procedure >= g_current_runtime_level ) THEN
910: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.BUILD_SQL',
911: 'SQL-1 For Invoice, Credit Memo, Debit Memo: Header Level');
912: END IF;
913:
914: l_sql_statement :=

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

1283:
1284: ELSIF G_SUMMARY_LEVEL = 'TRANSACTION_DISTRIBUTION' THEN
1285:
1286: IF (g_level_procedure >= g_current_runtime_level ) THEN
1287: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.BUILD_SQL',
1288: 'SQL-2 For Invoice, Credit Memo, Debit Memo: Distribution Level');
1289: END IF;
1290:
1291: l_sql_statement :=

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

1512:
1513: IF G_SUMMARY_LEVEL = 'TRANSACTION_LINE' THEN
1514:
1515: IF (g_level_procedure >= g_current_runtime_level ) THEN
1516: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.BUILD_SQL',
1517: 'SQL-3 For Invoice, Credit Memo, Debit Memo: Line Level');
1518: END IF;
1519:
1520: l_sql_statement :=

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

1915:
1916: END IF; -- summary level
1917:
1918: IF (g_level_procedure >= g_current_runtime_level ) THEN
1919: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.BUILD_SQL.BEGIN',
1920: 'ZX_AP_EXTRACT_PKG: BUILD_SQL(-)');
1921: END IF;
1922:
1923: EXCEPTION

Line 1930: FND_LOG.STRING(g_level_unexpected,

1926: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
1927: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','build_sql- '|| g_error_buffer);
1928: FND_MSG_PUB.Add;
1929: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1930: FND_LOG.STRING(g_level_unexpected,
1931: 'ZX.TRL.ZX_AP_EXTRACT_PKG.build_sql',
1932: g_error_buffer);
1933: END IF;
1934: g_retcode := 2;

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

1966:
1967: BEGIN
1968:
1969: IF (g_level_procedure >= g_current_runtime_level ) THEN
1970: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.EXECUTE_SQL_STMT.BEGIN',
1971: 'ZX_AP_EXTRACT_PKG: EXECUTE_SQL_STMT(+)');
1972: END IF;
1973:
1974:

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

1977: -- l_sql_statement_tbl(3) := G_COLUMN_LIST_TRX_LINE_LVL; --AP Line level
1978:
1979: IF (g_level_procedure >= g_current_runtime_level ) THEN
1980: --Added as part of testing ( for showing all the bind vars values )
1981: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL',
1982: ' Displaying all the Global Bind Variable Values used for the Dynamic SQL Stmt ' );
1983: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL',
1984: 'g_gl_date_low : '||g_gl_date_low);
1985: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL',

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

1979: IF (g_level_procedure >= g_current_runtime_level ) THEN
1980: --Added as part of testing ( for showing all the bind vars values )
1981: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL',
1982: ' Displaying all the Global Bind Variable Values used for the Dynamic SQL Stmt ' );
1983: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL',
1984: 'g_gl_date_low : '||g_gl_date_low);
1985: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL',
1986: 'g_gl_date_high : '||g_gl_date_high);
1987: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL',

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

1981: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL',
1982: ' Displaying all the Global Bind Variable Values used for the Dynamic SQL Stmt ' );
1983: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL',
1984: 'g_gl_date_low : '||g_gl_date_low);
1985: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL',
1986: 'g_gl_date_high : '||g_gl_date_high);
1987: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL',
1988: 'G_LEDGER_ID : '||G_LEDGER_ID);
1989: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL',

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

1983: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL',
1984: 'g_gl_date_low : '||g_gl_date_low);
1985: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL',
1986: 'g_gl_date_high : '||g_gl_date_high);
1987: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL',
1988: 'G_LEDGER_ID : '||G_LEDGER_ID);
1989: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL',
1990: 'g_trx_date_low : '||g_trx_date_low);
1991: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL',

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

1985: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL',
1986: 'g_gl_date_high : '||g_gl_date_high);
1987: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL',
1988: 'G_LEDGER_ID : '||G_LEDGER_ID);
1989: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL',
1990: 'g_trx_date_low : '||g_trx_date_low);
1991: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL',
1992: 'g_trx_date_high : '||g_trx_date_high);
1993: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL',

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

1987: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL',
1988: 'G_LEDGER_ID : '||G_LEDGER_ID);
1989: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL',
1990: 'g_trx_date_low : '||g_trx_date_low);
1991: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL',
1992: 'g_trx_date_high : '||g_trx_date_high);
1993: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL',
1994: 'g_trx_number_low : '||g_trx_number_low);
1995: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL',

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

1989: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL',
1990: 'g_trx_date_low : '||g_trx_date_low);
1991: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL',
1992: 'g_trx_date_high : '||g_trx_date_high);
1993: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL',
1994: 'g_trx_number_low : '||g_trx_number_low);
1995: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL',
1996: 'g_trx_number_high : '||g_trx_number_high);
1997: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL',

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

1991: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL',
1992: 'g_trx_date_high : '||g_trx_date_high);
1993: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL',
1994: 'g_trx_number_low : '||g_trx_number_low);
1995: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL',
1996: 'g_trx_number_high : '||g_trx_number_high);
1997: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL',
1998: 'g_vat_transaction_type_code : '||g_vat_transaction_type_code);
1999: -- FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL',

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

1993: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL',
1994: 'g_trx_number_low : '||g_trx_number_low);
1995: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL',
1996: 'g_trx_number_high : '||g_trx_number_high);
1997: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL',
1998: 'g_vat_transaction_type_code : '||g_vat_transaction_type_code);
1999: -- FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL',
2000: -- 'g_document_sub_type : '||g_document_sub_type);
2001: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL',

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

1995: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL',
1996: 'g_trx_number_high : '||g_trx_number_high);
1997: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL',
1998: 'g_vat_transaction_type_code : '||g_vat_transaction_type_code);
1999: -- FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL',
2000: -- 'g_document_sub_type : '||g_document_sub_type);
2001: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL',
2002: 'g_trx_business_category : '||g_trx_business_category);
2003: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL',

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

1997: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL',
1998: 'g_vat_transaction_type_code : '||g_vat_transaction_type_code);
1999: -- FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL',
2000: -- 'g_document_sub_type : '||g_document_sub_type);
2001: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL',
2002: 'g_trx_business_category : '||g_trx_business_category);
2003: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL',
2004: 'g_tax_invoice_date_low : '||g_tax_invoice_date_low);
2005: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL',

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

1999: -- FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL',
2000: -- 'g_document_sub_type : '||g_document_sub_type);
2001: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL',
2002: 'g_trx_business_category : '||g_trx_business_category);
2003: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL',
2004: 'g_tax_invoice_date_low : '||g_tax_invoice_date_low);
2005: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL',
2006: 'g_tax_invoice_date_high : '||g_tax_invoice_date_high);
2007: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL',

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

2001: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL',
2002: 'g_trx_business_category : '||g_trx_business_category);
2003: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL',
2004: 'g_tax_invoice_date_low : '||g_tax_invoice_date_low);
2005: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL',
2006: 'g_tax_invoice_date_high : '||g_tax_invoice_date_high);
2007: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL',
2008: 'g_tax_jurisdiction_code : '||g_tax_jurisdiction_code);
2009: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL',

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

2003: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL',
2004: 'g_tax_invoice_date_low : '||g_tax_invoice_date_low);
2005: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL',
2006: 'g_tax_invoice_date_high : '||g_tax_invoice_date_high);
2007: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL',
2008: 'g_tax_jurisdiction_code : '||g_tax_jurisdiction_code);
2009: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL',
2010: 'g_first_party_tax_reg_num : '||g_first_party_tax_reg_num);
2011: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL',

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

2005: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL',
2006: 'g_tax_invoice_date_high : '||g_tax_invoice_date_high);
2007: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL',
2008: 'g_tax_jurisdiction_code : '||g_tax_jurisdiction_code);
2009: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL',
2010: 'g_first_party_tax_reg_num : '||g_first_party_tax_reg_num);
2011: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL',
2012: 'g_tax_regime_code : '||g_tax_regime_code);
2013: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL',

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

2007: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL',
2008: 'g_tax_jurisdiction_code : '||g_tax_jurisdiction_code);
2009: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL',
2010: 'g_first_party_tax_reg_num : '||g_first_party_tax_reg_num);
2011: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL',
2012: 'g_tax_regime_code : '||g_tax_regime_code);
2013: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL',
2014: 'g_tax : '||g_tax);
2015: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL',

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

2009: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL',
2010: 'g_first_party_tax_reg_num : '||g_first_party_tax_reg_num);
2011: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL',
2012: 'g_tax_regime_code : '||g_tax_regime_code);
2013: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL',
2014: 'g_tax : '||g_tax);
2015: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL',
2016: 'g_tax_status_code : '||g_tax_status_code);
2017: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL',

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

2011: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL',
2012: 'g_tax_regime_code : '||g_tax_regime_code);
2013: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL',
2014: 'g_tax : '||g_tax);
2015: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL',
2016: 'g_tax_status_code : '||g_tax_status_code);
2017: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL',
2018: 'g_tax_rate_code_low : '||g_tax_rate_code_low);
2019: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL',

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

2013: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL',
2014: 'g_tax : '||g_tax);
2015: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL',
2016: 'g_tax_status_code : '||g_tax_status_code);
2017: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL',
2018: 'g_tax_rate_code_low : '||g_tax_rate_code_low);
2019: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL',
2020: 'g_tax_rate_code_high : '||g_tax_rate_code_high);
2021: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL',

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

2015: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL',
2016: 'g_tax_status_code : '||g_tax_status_code);
2017: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL',
2018: 'g_tax_rate_code_low : '||g_tax_rate_code_low);
2019: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL',
2020: 'g_tax_rate_code_high : '||g_tax_rate_code_high);
2021: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL',
2022: 'g_tax_type_code_low : '||g_tax_type_code_low);
2023: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL',

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

2017: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL',
2018: 'g_tax_rate_code_low : '||g_tax_rate_code_low);
2019: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL',
2020: 'g_tax_rate_code_high : '||g_tax_rate_code_high);
2021: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL',
2022: 'g_tax_type_code_low : '||g_tax_type_code_low);
2023: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL',
2024: 'g_tax_type_code_high : '||g_tax_type_code_high);
2025: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL',

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

2019: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL',
2020: 'g_tax_rate_code_high : '||g_tax_rate_code_high);
2021: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL',
2022: 'g_tax_type_code_low : '||g_tax_type_code_low);
2023: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL',
2024: 'g_tax_type_code_high : '||g_tax_type_code_high);
2025: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL',
2026: 'g_currency_code_low : '||g_currency_code_low);
2027: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL',

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

2021: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL',
2022: 'g_tax_type_code_low : '||g_tax_type_code_low);
2023: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL',
2024: 'g_tax_type_code_high : '||g_tax_type_code_high);
2025: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL',
2026: 'g_currency_code_low : '||g_currency_code_low);
2027: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL',
2028: 'g_currency_code_high : '||g_currency_code_high);
2029: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL',

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

2023: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL',
2024: 'g_tax_type_code_high : '||g_tax_type_code_high);
2025: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL',
2026: 'g_currency_code_low : '||g_currency_code_low);
2027: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL',
2028: 'g_currency_code_high : '||g_currency_code_high);
2029: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL',
2030: 'g_legal_entity_id : '||g_legal_entity_id);
2031: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL',

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

2025: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL',
2026: 'g_currency_code_low : '||g_currency_code_low);
2027: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL',
2028: 'g_currency_code_high : '||g_currency_code_high);
2029: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL',
2030: 'g_legal_entity_id : '||g_legal_entity_id);
2031: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL',
2032: 'g_ledger_id : '||g_ledger_id);
2033:

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

2027: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL',
2028: 'g_currency_code_high : '||g_currency_code_high);
2029: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL',
2030: 'g_legal_entity_id : '||g_legal_entity_id);
2031: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL',
2032: 'g_ledger_id : '||g_ledger_id);
2033:
2034: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'Dynamic sql statement : '||g_summary_level);
2035: l_sql1 := substr(g_sql_statement,1,3000);

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

2030: 'g_legal_entity_id : '||g_legal_entity_id);
2031: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL',
2032: 'g_ledger_id : '||g_ledger_id);
2033:
2034: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'Dynamic sql statement : '||g_summary_level);
2035: l_sql1 := substr(g_sql_statement,1,3000);
2036: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'g_sql_statement : '||l_sql1);
2037: l_sql2 := substr(g_sql_statement,3001,3000);
2038: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'g_sql_statement : '||l_sql2);

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

2032: 'g_ledger_id : '||g_ledger_id);
2033:
2034: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'Dynamic sql statement : '||g_summary_level);
2035: l_sql1 := substr(g_sql_statement,1,3000);
2036: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'g_sql_statement : '||l_sql1);
2037: l_sql2 := substr(g_sql_statement,3001,3000);
2038: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'g_sql_statement : '||l_sql2);
2039: l_sql3 := substr(g_sql_statement,6001,3000);
2040: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'g_sql_statement : '||l_sql3);

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

2034: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'Dynamic sql statement : '||g_summary_level);
2035: l_sql1 := substr(g_sql_statement,1,3000);
2036: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'g_sql_statement : '||l_sql1);
2037: l_sql2 := substr(g_sql_statement,3001,3000);
2038: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'g_sql_statement : '||l_sql2);
2039: l_sql3 := substr(g_sql_statement,6001,3000);
2040: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'g_sql_statement : '||l_sql3);
2041: l_sql4 := substr(g_sql_statement,9001,3000);
2042: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'g_sql_statement : '||l_sql4);

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

2036: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'g_sql_statement : '||l_sql1);
2037: l_sql2 := substr(g_sql_statement,3001,3000);
2038: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'g_sql_statement : '||l_sql2);
2039: l_sql3 := substr(g_sql_statement,6001,3000);
2040: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'g_sql_statement : '||l_sql3);
2041: l_sql4 := substr(g_sql_statement,9001,3000);
2042: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'g_sql_statement : '||l_sql4);
2043: l_sql5 := substr(g_sql_statement,12001,3000);
2044: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'g_sql_statement : '||l_sql5);

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

2038: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'g_sql_statement : '||l_sql2);
2039: l_sql3 := substr(g_sql_statement,6001,3000);
2040: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'g_sql_statement : '||l_sql3);
2041: l_sql4 := substr(g_sql_statement,9001,3000);
2042: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'g_sql_statement : '||l_sql4);
2043: l_sql5 := substr(g_sql_statement,12001,3000);
2044: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'g_sql_statement : '||l_sql5);
2045: l_sql6 := substr(g_sql_statement,15001,3000);
2046: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'g_sql_statement : '||l_sql6);

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

2040: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'g_sql_statement : '||l_sql3);
2041: l_sql4 := substr(g_sql_statement,9001,3000);
2042: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'g_sql_statement : '||l_sql4);
2043: l_sql5 := substr(g_sql_statement,12001,3000);
2044: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'g_sql_statement : '||l_sql5);
2045: l_sql6 := substr(g_sql_statement,15001,3000);
2046: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'g_sql_statement : '||l_sql6);
2047: l_sql7 := substr(g_sql_statement,18001,3000);
2048: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'g_sql_statement : '||l_sql7);

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

2042: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'g_sql_statement : '||l_sql4);
2043: l_sql5 := substr(g_sql_statement,12001,3000);
2044: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'g_sql_statement : '||l_sql5);
2045: l_sql6 := substr(g_sql_statement,15001,3000);
2046: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'g_sql_statement : '||l_sql6);
2047: l_sql7 := substr(g_sql_statement,18001,3000);
2048: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'g_sql_statement : '||l_sql7);
2049: l_sql8 := substr(g_sql_statement,21001,3000);
2050: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'g_sql_statement : '||l_sql8);

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

2044: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'g_sql_statement : '||l_sql5);
2045: l_sql6 := substr(g_sql_statement,15001,3000);
2046: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'g_sql_statement : '||l_sql6);
2047: l_sql7 := substr(g_sql_statement,18001,3000);
2048: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'g_sql_statement : '||l_sql7);
2049: l_sql8 := substr(g_sql_statement,21001,3000);
2050: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'g_sql_statement : '||l_sql8);
2051: END IF;
2052:

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

2046: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'g_sql_statement : '||l_sql6);
2047: l_sql7 := substr(g_sql_statement,18001,3000);
2048: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'g_sql_statement : '||l_sql7);
2049: l_sql8 := substr(g_sql_statement,21001,3000);
2050: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'g_sql_statement : '||l_sql8);
2051: END IF;
2052:
2053:
2054:

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

2061: COMMIT;
2062: END LOOP; */
2063:
2064: IF (g_level_procedure >= g_current_runtime_level ) THEN
2065: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.execute_sql_stmt.END',
2066: 'ZX_AP_EXTRACT_PKG: execute_sql_stmt(-)');
2067: END IF;
2068:
2069: EXCEPTION

Line 2076: FND_LOG.STRING(g_level_unexpected,

2072: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
2073: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','execute_sql_stmt- '|| g_error_buffer);
2074: FND_MSG_PUB.Add;
2075: IF (g_level_unexpected >= g_current_runtime_level ) THEN
2076: FND_LOG.STRING(g_level_unexpected,
2077: 'ZX.TRL.ZX_AP_EXTRACT_PKG.execute_sql_stmt',
2078: g_error_buffer);
2079: END IF;
2080: g_retcode := 2;

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

2105:
2106: BEGIN
2107:
2108: IF (g_level_procedure >= g_current_runtime_level ) THEN
2109: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.fetch_tax_info.BEGIN',
2110: 'ZX_AP_EXTRACT_PKG: fetch_tax_info(+)');
2111: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.fetch_tax_info',
2112: 'Open cursor');
2113: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.fetch_tax_info',

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

2107:
2108: IF (g_level_procedure >= g_current_runtime_level ) THEN
2109: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.fetch_tax_info.BEGIN',
2110: 'ZX_AP_EXTRACT_PKG: fetch_tax_info(+)');
2111: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.fetch_tax_info',
2112: 'Open cursor');
2113: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.fetch_tax_info',
2114: 'Gl Date Low/High'||to_char(g_gl_date_low)||' '
2115: ||to_char(g_gl_date_high));

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

2109: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.fetch_tax_info.BEGIN',
2110: 'ZX_AP_EXTRACT_PKG: fetch_tax_info(+)');
2111: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.fetch_tax_info',
2112: 'Open cursor');
2113: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.fetch_tax_info',
2114: 'Gl Date Low/High'||to_char(g_gl_date_low)||' '
2115: ||to_char(g_gl_date_high));
2116: END IF;
2117:

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

2151: g_adjusted_doc_to;
2152: -- g_trading_partner_id;
2153:
2154: IF (g_level_procedure >= g_current_runtime_level ) THEN
2155: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.FETCH_TAX_INFO',
2156: 'After USING Clause Call :');
2157: END IF;
2158:
2159: i := 1;

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

2342: gt_unit_price_tbl(i), -- Bug 5439099
2343: gt_gl_date(i); --Bug 5523095
2344:
2345: /* IF (g_level_procedure >= g_current_runtime_level ) THEN
2346: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.fetch_tax_info',
2347: 'Before insert Call :' ||to_char(GT_TRX_ID.count));
2348: END IF;
2349: */
2350: IF zx_rep_detail_csr%FOUND THEN

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

2348: END IF;
2349: */
2350: IF zx_rep_detail_csr%FOUND THEN
2351: IF (g_level_procedure >= g_current_runtime_level ) THEN
2352: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.fetch_tax_info',
2353: 'zx_rep_detail_csr Found :' );
2354: END IF;
2355:
2356: -- populate EXTRACT_REPORT_LINE_NUMBER

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

2362: insert_tax_info;
2363: COMMIT;
2364:
2365: IF (g_level_procedure >= g_current_runtime_level ) THEN
2366: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.FETCH_TAX_INFO',
2367: 'After insert_tax_info Call :' );
2368: END IF;
2369: i := 1;
2370: init_gt_variables;

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

2372: i := i + 1;
2373: END IF;
2374: ELSE
2375: IF (g_level_procedure >= g_current_runtime_level ) THEN
2376: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.FETCH_TAX_INFO',
2377: 'Before INSERT_TAX_INFO 2 Call :' );
2378: END IF;
2379:
2380: -- total rows fetched less than 1000

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

2383: insert_tax_info;
2384: COMMIT;
2385:
2386: IF (g_level_procedure >= g_current_runtime_level ) THEN
2387: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.FETCH_TAX_INFO',
2388: 'After INSERT_TAX_INFO 2 :' );
2389: END IF;
2390:
2391: CLOSE zx_rep_detail_csr;

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

2393: END IF;
2394: END LOOP;
2395:
2396: IF (g_level_procedure >= g_current_runtime_level ) THEN
2397: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.fetch_tax_info.END',
2398: 'ZX_AP_EXTRACT_PKG: fetch_tax_info(-)');
2399: END IF;
2400:
2401: EXCEPTION

Line 2408: FND_LOG.STRING(g_level_unexpected,

2404: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
2405: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','populate_tax_data- '|| g_error_buffer);
2406: FND_MSG_PUB.Add;
2407: IF (g_level_unexpected >= g_current_runtime_level ) THEN
2408: FND_LOG.STRING(g_level_unexpected,
2409: 'ZX.TRL.ZX_AP_EXTRACT_PKG.fetch_tax_info',
2410: g_error_buffer);
2411: END IF;
2412:

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

2434:
2435: BEGIN
2436:
2437: IF (g_level_procedure >= g_current_runtime_level ) THEN
2438: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.init_gt_variables.BEGIN',
2439: 'ZX_AP_EXTRACT_PKG: init_gt_variables(+)');
2440: END IF;
2441:
2442: gt_extract_rep_line_num.delete;

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

2610: GT_TAX_RATE_CODE_NAME.DELETE;
2611: gt_tax_rate_code_description.delete;
2612:
2613: IF (g_level_procedure >= g_current_runtime_level ) THEN
2614: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.init_gt_variables.END',
2615: 'ZX_AP_EXTRACT_PKG: init_gt_variables(-)');
2616: END IF;
2617:
2618: END init_gt_variables;

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

2638:
2639: BEGIN
2640:
2641: IF (g_level_procedure >= g_current_runtime_level ) THEN
2642: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.insert_tax_info.BEGIN',
2643: 'ZX_AP_EXTRACT_PKG: insert_tax_info(+)');
2644: END IF;
2645:
2646: l_count := GT_TRX_ID.COUNT;

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

2646: l_count := GT_TRX_ID.COUNT;
2647:
2648:
2649: IF (g_level_procedure >= g_current_runtime_level ) THEN
2650: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.insert_tax_info',
2651: ' Record Count = ' ||to_char(GT_TRX_ID.COUNT));
2652: END IF;
2653:
2654: FORALL i IN 1 .. l_count

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

3021: )
3022: RETURNING detail_tax_line_id bulk collect into GT_DETAIL_TAX_LINE_ID ;
3023:
3024: IF (g_level_procedure >= g_current_runtime_level ) THEN
3025: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.insert_tax_info',
3026: 'Number of Tax Lines successfully inserted = '||TO_CHAR(l_count));
3027:
3028: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.INSERT_TAX_INFO.END',
3029: 'ZX_AP_EXTRACT_PKG: INIT_GT_VARIABLES(-)');

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

3024: IF (g_level_procedure >= g_current_runtime_level ) THEN
3025: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.insert_tax_info',
3026: 'Number of Tax Lines successfully inserted = '||TO_CHAR(l_count));
3027:
3028: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.INSERT_TAX_INFO.END',
3029: 'ZX_AP_EXTRACT_PKG: INIT_GT_VARIABLES(-)');
3030: END IF;
3031:
3032: EXCEPTION

Line 3039: FND_LOG.STRING(g_level_unexpected,

3035: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
3036: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','populate_tax_data- '|| g_error_buffer);
3037: FND_MSG_PUB.Add;
3038: IF (g_level_unexpected >= g_current_runtime_level ) THEN
3039: FND_LOG.STRING(g_level_unexpected,
3040: 'ZX.TRL.ZX_AP_EXTRACT_PKG.INSERT_TAX_INFO',
3041: g_error_buffer);
3042: END IF;
3043:

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

3070:
3071: BEGIN
3072:
3073: IF (g_level_procedure >= g_current_runtime_level ) THEN
3074: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.assign_global_parameTERS.BEGIN',
3075: 'ZX_AP_EXTRACT_PKG: assign_global_parametERS(+)');
3076: END IF;
3077:
3078: g_reporting_level := p_trl_global_variables_rec.reporting_level;

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

3182:
3183:
3184:
3185: IF (g_level_procedure >= g_current_runtime_level ) THEN
3186: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.assign_global_parameters.END',
3187: 'ZX_AP_EXTRACT_PKG: assign_global_parameters(-)');
3188: END IF;
3189:
3190: END assign_global_parameters;

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

3209:
3210: BEGIN
3211:
3212: IF (g_level_procedure >= g_current_runtime_level ) THEN
3213: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.FILTER_VALIDATED.BEGIN',
3214: 'ZX_AP_EXTRACT_PKG: FILTER_VALIDATED(+)');
3215: END IF;
3216:
3217: IF g_accounting_status <> 'ACCOUNTED' THEN

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

3251: 'N') = 'Y');
3252: END IF;
3253:
3254: IF ( g_level_statement>= g_current_runtime_level ) THEN
3255: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_AP_EXTRACT_PKG',
3256: ' Deleted Count : Filter_Validated : '||to_char(sql%ROWCOUNT) ); --Bug 5347188
3257: END IF;
3258:
3259: IF (g_level_procedure >= g_current_runtime_level ) THEN

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

3256: ' Deleted Count : Filter_Validated : '||to_char(sql%ROWCOUNT) ); --Bug 5347188
3257: END IF;
3258:
3259: IF (g_level_procedure >= g_current_runtime_level ) THEN
3260: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.FILTER_VALIDATED.BEGIN',
3261: 'ZX_AP_EXTRACT_PKG: FILTER_VALIDATED(-)');
3262: END IF;
3263:
3264: EXCEPTION

Line 3271: FND_LOG.STRING(g_level_unexpected,

3267: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
3268: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','filter_validated- '|| g_error_buffer);
3269: FND_MSG_PUB.Add;
3270: IF (g_level_unexpected >= g_current_runtime_level ) THEN
3271: FND_LOG.STRING(g_level_unexpected,
3272: 'ZX.TRL.ZX_AP_EXTRACT_PKG.filter_validated',
3273: g_error_buffer);
3274: END IF;
3275: g_retcode := 2;