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

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

337: g_retcode VARCHAR2(30);
338:
339: g_extract_line_num NUMBER :=1;
340:
341: -- Declare global varibles for FND log messages
342:
343: g_current_runtime_level NUMBER;
344: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
345: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;

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

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

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

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

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

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

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

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

Line 375: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

371: )
372: IS
373:
374: BEGIN
375: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
376:
377: g_retcode := p_trl_global_variables_rec.retcode;
378: IF (g_level_procedure >= g_current_runtime_level ) THEN
379: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_EXTRACT_PKG.INSERT_TAX_DATA.BEGIN',

Line 379: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_EXTRACT_PKG.INSERT_TAX_DATA.BEGIN',

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

Line 397: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_EXTRACT_PKG.INSERT_TAX_DATA.END',

393:
394: p_trl_global_variables_rec.retcode := g_retcode;
395:
396: IF (g_level_procedure >= g_current_runtime_level ) THEN
397: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_EXTRACT_PKG.INSERT_TAX_DATA.END',
398: 'ZX_AP_ACTG_EXTRACT_PKG: INSERT_TAX_DATA(-)');
399: END IF;
400:
401: EXCEPTION

Line 408: FND_LOG.STRING(g_level_unexpected,

404: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
405: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','insert_tax_data- '|| g_error_buffer);
406: FND_MSG_PUB.Add;
407: IF (g_level_unexpected >= g_current_runtime_level ) THEN
408: FND_LOG.STRING(g_level_unexpected,
409: 'ZX.TRL.ZX_AP_ACTG_EXTRACT_PKG.insert_tax_data',
410: g_error_buffer);
411: END IF;
412: p_trl_global_variables_rec.retcode := 2;

Line 520: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_EXTRACT_PKG.BUILD_SQL.BEGIN',

516:
517: BEGIN
518:
519: IF (g_level_procedure >= g_current_runtime_level ) THEN
520: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_EXTRACT_PKG.BUILD_SQL.BEGIN',
521: 'ZX_AP_ACTG_EXTRACT_PKG: BUILD_SQL(+)');
522: END IF;
523:
524:

Line 539: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_EXTRACT_PKG.BUILD_SQL',

535: FND_MO_REPORTING_API.INITIALIZE(G_REPORTING_LEVEL,G_REPORTING_CONTEXT,'AUTO');
536:
537: l_fnd_mo_org_stg := FND_MO_REPORTING_API.GET_PREDICATE('ZX_DET',NULL,L_REPORTING_CONTEXT_VAL);
538: IF (g_level_procedure >= g_current_runtime_level ) THEN
539: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_EXTRACT_PKG.BUILD_SQL',
540: 'l_fnd_mo_org_stg = '||l_fnd_mo_org_stg);
541: END IF;
542:
543: /* l_string_len := LENGTH(l_fnd_mo_org_stg);

Line 548: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_EXTRACT_PKG.BUILD_SQL',

544: l_equal_pos := instr(l_fnd_mo_org_stg,'=');
545: -- l_org_len := l_string_len - 19;
546: l_get_org_id := substr(l_fnd_mo_org_stg,l_equal_pos,l_string_len);
547: IF (g_level_procedure >= g_current_runtime_level ) THEN
548: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_EXTRACT_PKG.BUILD_SQL',
549: 'l_fnd_mo_org_stg = '||l_get_org_id||' Pos '||to_char(l_equal_pos)||' Len '||to_char(l_string_len));
550: END IF; */
551: l_internal_org_stg:= replace (l_fnd_mo_org_stg,'ORG_ID','INTERNAL_ORGANIZATION_ID');
552:

Line 554: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_EXTRACT_PKG.BUILD_SQL',

550: END IF; */
551: l_internal_org_stg:= replace (l_fnd_mo_org_stg,'ORG_ID','INTERNAL_ORGANIZATION_ID');
552:
553: IF (g_level_procedure >= g_current_runtime_level ) THEN
554: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_EXTRACT_PKG.BUILD_SQL',
555: 'l_internal_org_stg = '||l_internal_org_stg);
556: END IF;
557:
558: --L_WHERE_REPORT_CONTEXT := 'AND ZX_DET.INTERNAL_ORGANIZATION_ID '||l_get_org_id;

Line 562: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_EXTRACT_PKG.BUILD_SQL',

558: --L_WHERE_REPORT_CONTEXT := 'AND ZX_DET.INTERNAL_ORGANIZATION_ID '||l_get_org_id;
559: L_WHERE_REPORT_CONTEXT := l_internal_org_stg;
560:
561: IF (g_level_procedure >= g_current_runtime_level ) THEN
562: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_EXTRACT_PKG.BUILD_SQL',
563: 'L_WHERE_REPORT_CONTEXT = '||L_WHERE_REPORT_CONTEXT);
564: END IF;
565:
566: -- New Parameter code

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

790: L_WHERE_TRX_CLASS := L_WHERE_TRX_CLASS;
791: END IF;
792:
793: IF (g_level_procedure >= g_current_runtime_level ) THEN
794: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.BUILD_SQL',
795: 'L_WHERE_TRX_CLASS = '||to_char(length(nvl(L_WHERE_TRX_CLASS,0))));
796: END IF;
797:
798:

Line 848: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_EXTRACT_PKG.BUILD_SQL',

844:
845: IF g_summary_level = 'TRANSACTION' THEN
846:
847: IF (g_level_procedure >= g_current_runtime_level ) THEN
848: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_EXTRACT_PKG.BUILD_SQL',
849: 'SQL-1 For Invoice, Credit Memo, Debit Memo: Header Level');
850: END IF;
851:
852: l_sql_statement :=

Line 1236: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_EXTRACT_PKG.BUILD_SQL',

1232:
1233: ELSIF G_SUMMARY_LEVEL = 'TRANSACTION_DISTRIBUTION' THEN
1234:
1235: IF (g_level_procedure >= g_current_runtime_level ) THEN
1236: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_EXTRACT_PKG.BUILD_SQL',
1237: 'SQL-2 For Invoice, Credit Memo, Debit Memo: Distribution Level');
1238: END IF;
1239:
1240: l_sql_statement :=

Line 1482: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_EXTRACT_PKG.BUILD_SQL',

1478:
1479: IF G_SUMMARY_LEVEL = 'TRANSACTION_LINE' THEN
1480:
1481: IF (g_level_procedure >= g_current_runtime_level ) THEN
1482: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_EXTRACT_PKG.BUILD_SQL',
1483: 'SQL-3 For Invoice, Credit Memo, Debit Memo: Line Level');
1484: END IF;
1485:
1486: l_sql_statement :=

Line 1898: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_EXTRACT_PKG.BUILD_SQL.BEGIN',

1894:
1895: END IF; -- summary level
1896:
1897: IF (g_level_procedure >= g_current_runtime_level ) THEN
1898: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_EXTRACT_PKG.BUILD_SQL.BEGIN',
1899: 'ZX_AP_ACTG_EXTRACT_PKG: BUILD_SQL(-)');
1900: END IF;
1901:
1902: EXCEPTION

Line 1909: FND_LOG.STRING(g_level_unexpected,

1905: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
1906: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','build_sql- '|| g_error_buffer);
1907: FND_MSG_PUB.Add;
1908: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1909: FND_LOG.STRING(g_level_unexpected,
1910: 'ZX.TRL.ZX_AP_ACTG_EXTRACT_PKG.build_sql',
1911: g_error_buffer);
1912: END IF;
1913: g_retcode := 2;

Line 1949: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_EXTRACT_PKG.EXECUTE_SQL_STMT.BEGIN',

1945:
1946: BEGIN
1947:
1948: IF (g_level_procedure >= g_current_runtime_level ) THEN
1949: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_EXTRACT_PKG.EXECUTE_SQL_STMT.BEGIN',
1950: 'ZX_AP_ACTG_EXTRACT_PKG: EXECUTE_SQL_STMT(+)');
1951: END IF;
1952:
1953:

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

1955: -- l_sql_statement_tbl(2) := G_COLUMN_LIST_TRX_DIST_LVL; --AP Distribution level
1956: -- l_sql_statement_tbl(3) := G_COLUMN_LIST_TRX_LINE_LVL; --AP Line level
1957:
1958: IF (g_level_procedure >= g_current_runtime_level ) THEN
1959: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'Dynamic sql statement : '||g_summary_level);
1960: l_sql1 := substr(g_sql_statement,1,3000);
1961: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'g_sql_statement : '||l_sql1);
1962: l_sql2 := substr(g_sql_statement,3001,3000);
1963: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'g_sql_statement : '||l_sql2);

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

1957:
1958: IF (g_level_procedure >= g_current_runtime_level ) THEN
1959: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'Dynamic sql statement : '||g_summary_level);
1960: l_sql1 := substr(g_sql_statement,1,3000);
1961: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'g_sql_statement : '||l_sql1);
1962: l_sql2 := substr(g_sql_statement,3001,3000);
1963: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'g_sql_statement : '||l_sql2);
1964: l_sql3 := substr(g_sql_statement,6001,3000);
1965: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'g_sql_statement : '||l_sql3);

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

1959: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'Dynamic sql statement : '||g_summary_level);
1960: l_sql1 := substr(g_sql_statement,1,3000);
1961: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'g_sql_statement : '||l_sql1);
1962: l_sql2 := substr(g_sql_statement,3001,3000);
1963: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'g_sql_statement : '||l_sql2);
1964: l_sql3 := substr(g_sql_statement,6001,3000);
1965: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'g_sql_statement : '||l_sql3);
1966: l_sql4 := substr(g_sql_statement,9001,3000);
1967: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'g_sql_statement : '||l_sql4);

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

1961: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'g_sql_statement : '||l_sql1);
1962: l_sql2 := substr(g_sql_statement,3001,3000);
1963: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'g_sql_statement : '||l_sql2);
1964: l_sql3 := substr(g_sql_statement,6001,3000);
1965: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'g_sql_statement : '||l_sql3);
1966: l_sql4 := substr(g_sql_statement,9001,3000);
1967: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'g_sql_statement : '||l_sql4);
1968: l_sql5 := substr(g_sql_statement,12001,3000);
1969: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'g_sql_statement : '||l_sql5);

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

1963: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'g_sql_statement : '||l_sql2);
1964: l_sql3 := substr(g_sql_statement,6001,3000);
1965: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'g_sql_statement : '||l_sql3);
1966: l_sql4 := substr(g_sql_statement,9001,3000);
1967: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'g_sql_statement : '||l_sql4);
1968: l_sql5 := substr(g_sql_statement,12001,3000);
1969: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'g_sql_statement : '||l_sql5);
1970: l_sql6 := substr(g_sql_statement,15001,3000);
1971: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'g_sql_statement : '||l_sql6);

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

1965: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'g_sql_statement : '||l_sql3);
1966: l_sql4 := substr(g_sql_statement,9001,3000);
1967: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'g_sql_statement : '||l_sql4);
1968: l_sql5 := substr(g_sql_statement,12001,3000);
1969: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'g_sql_statement : '||l_sql5);
1970: l_sql6 := substr(g_sql_statement,15001,3000);
1971: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'g_sql_statement : '||l_sql6);
1972: l_sql7 := substr(g_sql_statement,18001,3000);
1973: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'g_sql_statement : '||l_sql7);

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

1967: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'g_sql_statement : '||l_sql4);
1968: l_sql5 := substr(g_sql_statement,12001,3000);
1969: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'g_sql_statement : '||l_sql5);
1970: l_sql6 := substr(g_sql_statement,15001,3000);
1971: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'g_sql_statement : '||l_sql6);
1972: l_sql7 := substr(g_sql_statement,18001,3000);
1973: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'g_sql_statement : '||l_sql7);
1974: l_sql8 := substr(g_sql_statement,21001,3000);
1975: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'g_sql_statement : '||l_sql8);

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

1969: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'g_sql_statement : '||l_sql5);
1970: l_sql6 := substr(g_sql_statement,15001,3000);
1971: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'g_sql_statement : '||l_sql6);
1972: l_sql7 := substr(g_sql_statement,18001,3000);
1973: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'g_sql_statement : '||l_sql7);
1974: l_sql8 := substr(g_sql_statement,21001,3000);
1975: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'g_sql_statement : '||l_sql8);
1976: END IF;
1977:

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

1971: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'g_sql_statement : '||l_sql6);
1972: l_sql7 := substr(g_sql_statement,18001,3000);
1973: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'g_sql_statement : '||l_sql7);
1974: l_sql8 := substr(g_sql_statement,21001,3000);
1975: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'g_sql_statement : '||l_sql8);
1976: END IF;
1977:
1978:
1979:

Line 1990: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_EXTRACT_PKG.execute_sql_stmt.END',

1986: COMMIT;
1987: END LOOP; */
1988:
1989: IF (g_level_procedure >= g_current_runtime_level ) THEN
1990: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_EXTRACT_PKG.execute_sql_stmt.END',
1991: 'ZX_AP_ACTG_EXTRACT_PKG: execute_sql_stmt(-)');
1992: END IF;
1993:
1994: EXCEPTION

Line 2001: FND_LOG.STRING(g_level_unexpected,

1997: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
1998: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','execute_sql_stmt- '|| g_error_buffer);
1999: FND_MSG_PUB.Add;
2000: IF (g_level_unexpected >= g_current_runtime_level ) THEN
2001: FND_LOG.STRING(g_level_unexpected,
2002: 'ZX.TRL.ZX_AP_ACTG_EXTRACT_PKG.execute_sql_stmt',
2003: g_error_buffer);
2004: END IF;
2005: g_retcode := 2;

Line 2035: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_EXTRACT_PKG.fetch_tax_info.BEGIN',

2031: l_str varchar2(32000);
2032: BEGIN
2033:
2034: IF (g_level_procedure >= g_current_runtime_level ) THEN
2035: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_EXTRACT_PKG.fetch_tax_info.BEGIN',
2036: 'ZX_AP_ACTG_EXTRACT_PKG: fetch_tax_info(+)');
2037: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_EXTRACT_PKG.fetch_tax_info',
2038: 'Open cursor');
2039: END IF;

Line 2037: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_EXTRACT_PKG.fetch_tax_info',

2033:
2034: IF (g_level_procedure >= g_current_runtime_level ) THEN
2035: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_EXTRACT_PKG.fetch_tax_info.BEGIN',
2036: 'ZX_AP_ACTG_EXTRACT_PKG: fetch_tax_info(+)');
2037: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_EXTRACT_PKG.fetch_tax_info',
2038: 'Open cursor');
2039: END IF;
2040:
2041: OPEN zx_rep_detail_csr FOR p_statement

Line 2073: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_EXTRACT_PKG.FETCH_TAX_INFO',

2069: g_ledger_id;
2070: -- g_trading_partner_id;
2071:
2072: IF (g_level_procedure >= g_current_runtime_level ) THEN
2073: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_EXTRACT_PKG.FETCH_TAX_INFO',
2074: 'After USING Clause Call :');
2075: END IF;
2076:
2077: i := 1;

Line 2285: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_EXTRACT_PKG.fetch_tax_info',

2281: -- gt_program_id(i),
2282: -- gt_program_login_id(i);
2283:
2284: IF (g_level_procedure >= g_current_runtime_level ) THEN
2285: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_EXTRACT_PKG.fetch_tax_info',
2286: 'Before insert Call :' ||to_char(GT_TRX_ID.count));
2287: END IF;
2288:
2289: IF zx_rep_detail_csr%FOUND THEN

Line 2291: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_EXTRACT_PKG.fetch_tax_info',

2287: END IF;
2288:
2289: IF zx_rep_detail_csr%FOUND THEN
2290: IF (g_level_procedure >= g_current_runtime_level ) THEN
2291: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_EXTRACT_PKG.fetch_tax_info',
2292: 'zx_rep_detail_csr Found :' );
2293: END IF;
2294:
2295: -- populate EXTRACT_REPORT_LINE_NUMBER

Line 2305: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_EXTRACT_PKG.FETCH_TAX_INFO',

2301: insert_tax_info;
2302: COMMIT;
2303:
2304: IF (g_level_procedure >= g_current_runtime_level ) THEN
2305: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_EXTRACT_PKG.FETCH_TAX_INFO',
2306: 'After insert_tax_info Call :' );
2307: END IF;
2308: i := 1;
2309: init_gt_variables;

Line 2315: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_EXTRACT_PKG.FETCH_TAX_INFO',

2311: i := i + 1;
2312: END IF;
2313: ELSE
2314: IF (g_level_procedure >= g_current_runtime_level ) THEN
2315: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_EXTRACT_PKG.FETCH_TAX_INFO',
2316: 'Before INSERT_TAX_INFO 2 Call :' );
2317: END IF;
2318:
2319: -- total rows fetched less than 1000

Line 2326: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_EXTRACT_PKG.FETCH_TAX_INFO',

2322: insert_tax_info;
2323: COMMIT;
2324:
2325: IF (g_level_procedure >= g_current_runtime_level ) THEN
2326: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_EXTRACT_PKG.FETCH_TAX_INFO',
2327: 'After INSERT_TAX_INFO 2 :' );
2328: END IF;
2329:
2330: CLOSE zx_rep_detail_csr;

Line 2336: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_EXTRACT_PKG.fetch_tax_info.END',

2332: END IF;
2333: END LOOP;
2334:
2335: IF (g_level_procedure >= g_current_runtime_level ) THEN
2336: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_EXTRACT_PKG.fetch_tax_info.END',
2337: 'ZX_AP_ACTG_EXTRACT_PKG: fetch_tax_info(-)');
2338: END IF;
2339:
2340: EXCEPTION

Line 2347: FND_LOG.STRING(g_level_unexpected,

2343: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
2344: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','populate_tax_data- '|| g_error_buffer);
2345: FND_MSG_PUB.Add;
2346: IF (g_level_unexpected >= g_current_runtime_level ) THEN
2347: FND_LOG.STRING(g_level_unexpected,
2348: 'ZX.TRL.ZX_AP_ACTG_EXTRACT_PKG.fetch_tax_info',
2349: g_error_buffer);
2350: END IF;
2351:

Line 2377: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_EXTRACT_PKG.init_gt_variables.BEGIN',

2373:
2374: BEGIN
2375:
2376: IF (g_level_procedure >= g_current_runtime_level ) THEN
2377: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_EXTRACT_PKG.init_gt_variables.BEGIN',
2378: 'ZX_AP_ACTG_EXTRACT_PKG: init_gt_variables(+)');
2379: END IF;
2380:
2381: gt_extract_rep_line_num.delete;

Line 2570: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_EXTRACT_PKG.init_gt_variables.END',

2566: gt_program_login_id.delete;
2567: */
2568:
2569: IF (g_level_procedure >= g_current_runtime_level ) THEN
2570: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_EXTRACT_PKG.init_gt_variables.END',
2571: 'ZX_AP_ACTG_EXTRACT_PKG: init_gt_variables(-)');
2572: END IF;
2573:
2574: END init_gt_variables;

Line 2598: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_EXTRACT_PKG.insert_tax_info.BEGIN',

2594:
2595: BEGIN
2596:
2597: IF (g_level_procedure >= g_current_runtime_level ) THEN
2598: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_EXTRACT_PKG.insert_tax_info.BEGIN',
2599: 'ZX_AP_ACTG_EXTRACT_PKG: insert_tax_info(+)');
2600: END IF;
2601:
2602: l_count := GT_TRX_ID.COUNT;

Line 2606: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_EXTRACT_PKG.insert_tax_info',

2602: l_count := GT_TRX_ID.COUNT;
2603:
2604:
2605: IF (g_level_procedure >= g_current_runtime_level ) THEN
2606: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_EXTRACT_PKG.insert_tax_info',
2607: ' Record Count = ' ||to_char(GT_TRX_ID.COUNT));
2608: END IF;
2609:
2610: FORALL i IN 1 .. l_count

Line 3019: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_EXTRACT_PKG.insert_tax_info',

3015: -- gt_program_id(i),
3016: -- gt_program_login_id(i));
3017:
3018: IF (g_level_procedure >= g_current_runtime_level ) THEN
3019: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_EXTRACT_PKG.insert_tax_info',
3020: 'Number of Tax Lines successfully inserted = '||TO_CHAR(l_count));
3021:
3022: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_EXTRACT_PKG.INSERT_TAX_INFO.END',
3023: 'ZX_AP_ACTG_EXTRACT_PKG: INIT_GT_VARIABLES(-)');

Line 3022: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_EXTRACT_PKG.INSERT_TAX_INFO.END',

3018: IF (g_level_procedure >= g_current_runtime_level ) THEN
3019: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_EXTRACT_PKG.insert_tax_info',
3020: 'Number of Tax Lines successfully inserted = '||TO_CHAR(l_count));
3021:
3022: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_EXTRACT_PKG.INSERT_TAX_INFO.END',
3023: 'ZX_AP_ACTG_EXTRACT_PKG: INIT_GT_VARIABLES(-)');
3024: END IF;
3025:
3026: EXCEPTION

Line 3033: FND_LOG.STRING(g_level_unexpected,

3029: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
3030: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','populate_tax_data- '|| g_error_buffer);
3031: FND_MSG_PUB.Add;
3032: IF (g_level_unexpected >= g_current_runtime_level ) THEN
3033: FND_LOG.STRING(g_level_unexpected,
3034: 'ZX.TRL.ZX_AP_ACTG_EXTRACT_PKG.INSERT_TAX_INFO',
3035: g_error_buffer);
3036: END IF;
3037:

Line 3068: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_EXTRACT_PKG.assign_global_parameTERS.BEGIN',

3064:
3065: BEGIN
3066:
3067: IF (g_level_procedure >= g_current_runtime_level ) THEN
3068: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_EXTRACT_PKG.assign_global_parameTERS.BEGIN',
3069: 'ZX_AP_ACTG_EXTRACT_PKG: assign_global_parametERS(+)');
3070: END IF;
3071:
3072: g_reporting_level := p_trl_global_variables_rec.reporting_level;

Line 3171: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_EXTRACT_PKG.assign_global_parameters.END',

3167: g_retcode := p_trl_global_variables_rec.retcode;
3168:
3169:
3170: IF (g_level_procedure >= g_current_runtime_level ) THEN
3171: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_ACTG_EXTRACT_PKG.assign_global_parameters.END',
3172: 'ZX_AP_ACTG_EXTRACT_PKG: assign_global_parameters(-)');
3173: END IF;
3174:
3175: END assign_global_parameters;