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

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

450: G_ESL_EU_SITE_REPORTED VARCHAR2(15);
451: G_USE_PARALLEL_HINT VARCHAR2(10);
452:
453: g_current_runtime_level NUMBER;
454: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
455: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
456: g_level_event CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
457: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
458: g_error_buffer VARCHAR2(200);

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

451: G_USE_PARALLEL_HINT VARCHAR2(10);
452:
453: g_current_runtime_level NUMBER;
454: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
455: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
456: g_level_event CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
457: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
458: g_error_buffer VARCHAR2(200);
459: g_retcode NUMBER := 0;

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

452:
453: g_current_runtime_level NUMBER;
454: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
455: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
456: g_level_event CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
457: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
458: g_error_buffer VARCHAR2(200);
459: g_retcode NUMBER := 0;
460:

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

453: g_current_runtime_level NUMBER;
454: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
455: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
456: g_level_event CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
457: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
458: g_error_buffer VARCHAR2(200);
459: g_retcode NUMBER := 0;
460:
461: /*===========================================================================+

Line 486: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

482: ) IS
483:
484: BEGIN
485:
486: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
487: g_retcode := P_TRL_GLOBAL_VARIABLES_REC.RETCODE;
488: IF (g_level_procedure >= g_current_runtime_level ) THEN
489: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.insert_tax_data.BEGIN',
490: 'ZX_AR_EXTRACT_PKG: insert_tax_data(+)');

Line 489: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.insert_tax_data.BEGIN',

485:
486: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
487: g_retcode := P_TRL_GLOBAL_VARIABLES_REC.RETCODE;
488: IF (g_level_procedure >= g_current_runtime_level ) THEN
489: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.insert_tax_data.BEGIN',
490: 'ZX_AR_EXTRACT_PKG: insert_tax_data(+)');
491: END IF;
492:
493: assign_ar_global_variables(

Line 510: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.insert_tax_data.END',

506: P_TRL_GLOBAL_VARIABLES_REC.EXTRACT_REPORT_LINE_NUMBER := G_EXTRACT_REPORT_LINE_NUMBER;
507: P_TRL_GLOBAL_VARIABLES_REC.RETCODE := g_retcode;
508:
509: IF (g_level_procedure >= g_current_runtime_level ) THEN
510: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.insert_tax_data.END',
511: 'ZX_AR_EXTRACT_PKG: insert_tax_data(-)');
512: END IF;
513:
514:

Line 522: FND_LOG.STRING(g_level_unexpected,

518: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
519: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','insert_tax_data- '|| g_error_buffer);
520: FND_MSG_PUB.Add;
521: IF (g_level_unexpected >= g_current_runtime_level ) THEN
522: FND_LOG.STRING(g_level_unexpected,
523: 'ZX.TRL.ZX_AR_EXTRACT_PKG.insert_tax_data',
524: g_error_buffer);
525: END IF;
526: P_TRL_GLOBAL_VARIABLES_REC.RETCODE := 2;

Line 794: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.build_sql.BEGIN',

790: BEGIN
791:
792:
793: IF (g_level_procedure >= g_current_runtime_level ) THEN
794: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.build_sql.BEGIN',
795: 'ZX_AR_EXTRACT_PKG: build_sql(+)');
796: END IF;
797:
798: --

Line 865: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.build_sql',

861: p_pred_type =>'AUTO');
862:
863:
864: IF (g_level_procedure >= g_current_runtime_level ) THEN
865: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.build_sql',
866: 'After FND_MO_REPORTING_API.INITIALIZE Call : ');
867: END IF;
868:
869: -- Check with Kripa --skorrapa

Line 873: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.build_sql',

869: -- Check with Kripa --skorrapa
870:
871: l_fnd_mo_org_stg := FND_MO_REPORTING_API.GET_PREDICATE('ZX_DET',NULL,L_REPORTING_CONTEXT_VAL);
872: IF (g_level_procedure >= g_current_runtime_level ) THEN
873: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.build_sql',
874: 'After FND_MO_REPORTING_API.GET_PREDICATE Call = '||l_fnd_mo_org_stg);
875: END IF;
876:
877: IF instr(l_fnd_mo_org_stg,'ORG_ID') = 0 THEN

Line 885: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.build_sql',

881: END IF;
882:
883:
884: IF (g_level_procedure >= g_current_runtime_level ) THEN
885: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.build_sql',
886: 'l_internal_org_stg = '||l_internal_org_stg);
887: END IF;
888:
889:

Line 953: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.build_sql',

949: --L_WHERE_REPORTED_STATUS_NO_TAX
950:
951: END IF;
952: IF (g_level_procedure >= g_current_runtime_level ) THEN
953: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.build_sql',
954: 'L_WHERE_REPORTING_CONTEXT_TRXH : '||L_WHERE_REPORTING_CONTEXT_TRXH);
955: END IF;
956:
957: --New parameter code

Line 1258: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.build_sql',

1254: L_WHERE_TAX_INVOICE_DATE_APP := ' AND :G_TAX_INVOICE_DATE_LOW IS NULL AND :G_TAX_INVOICE_DATE_HIGH IS NOT NULL ';
1255: END IF;
1256:
1257: IF (g_level_procedure >= g_current_runtime_level ) THEN
1258: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.build_sql',
1259: 'L_WHERE_TAX_INVOICE_DATE_ADJ : '|| L_WHERE_TAX_INVOICE_DATE_ADJ);
1260: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.build_sql',
1261: 'L_WHERE_TAX_INVOICE_DATE_APP : '|| L_WHERE_TAX_INVOICE_DATE_APP);
1262: END IF;

Line 1260: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.build_sql',

1256:
1257: IF (g_level_procedure >= g_current_runtime_level ) THEN
1258: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.build_sql',
1259: 'L_WHERE_TAX_INVOICE_DATE_ADJ : '|| L_WHERE_TAX_INVOICE_DATE_ADJ);
1260: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.build_sql',
1261: 'L_WHERE_TAX_INVOICE_DATE_APP : '|| L_WHERE_TAX_INVOICE_DATE_APP);
1262: END IF;
1263: --End Bug 9031051
1264:

Line 1296: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.build_sql',

1292: L_WHERE_TAX_JURIS_CODE_ADJ := ' AND DECODE(:g_tax_jurisdiction_code,NULL,NULL) IS NULL ';
1293: END IF;
1294:
1295: IF (g_level_procedure >= g_current_runtime_level ) THEN
1296: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.build_sql',
1297: 'L_WHERE_TAX_JURIS_CODE_ADJ : '|| L_WHERE_TAX_JURIS_CODE_ADJ);
1298: END IF;
1299:
1300: IF G_TAX_REGIME_CODE IS NOT NULL THEN

Line 1313: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.build_sql',

1309: L_WHERE_TAX_REGIME_CODE_ADJ := ' AND DECODE(:G_TAX_REGIME_CODE,NULL,NULL) IS NULL ';
1310: END IF;
1311:
1312: IF (g_level_procedure >= g_current_runtime_level ) THEN
1313: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.build_sql',
1314: 'L_WHERE_TAX_REGIME_CODE_ADJ : '|| L_WHERE_TAX_REGIME_CODE_ADJ);
1315: END IF;
1316:
1317: IF G_TAX IS NOT NULL THEN

Line 1328: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.build_sql',

1324: L_WHERE_TAX_ADJ := ' AND DECODE(:G_TAX,NULL,NULL) IS NULL ';
1325: END IF;
1326:
1327: IF (g_level_procedure >= g_current_runtime_level ) THEN
1328: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.build_sql',
1329: 'L_WHERE_TAX_ADJ : '|| L_WHERE_TAX_ADJ);
1330: END IF;
1331:
1332: IF G_TAX_STATUS_CODE IS NOT NULL THEN

Line 1343: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.build_sql',

1339: L_WHERE_TAX_STATUS_CODE_ADJ := ' AND DECODE(:G_TAX_STATUS_CODE,NULL,NULL) IS NULL ';
1340: END IF;
1341:
1342: IF (g_level_procedure >= g_current_runtime_level ) THEN
1343: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.build_sql',
1344: 'L_WHERE_TAX_STATUS_CODE_ADJ : '||L_WHERE_TAX_STATUS_CODE_ADJ);
1345: END IF;
1346:
1347: IF g_tax_rate_code_low IS NOT NULL AND g_tax_rate_code_high IS NOT NULL THEN

Line 1366: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.build_sql',

1362: ' AND DECODE(:G_TAX_RATE_CODE_HIGH,NULL,NULL) IS NULL ';
1363: END IF;
1364:
1365: IF (g_level_procedure >= g_current_runtime_level ) THEN
1366: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.build_sql',
1367: 'L_WHERE_TAX_RATE_CODE_OTH : '||L_WHERE_TAX_RATE_CODE_OTH);
1368: END IF;
1369:
1370: IF g_tax_type_code_low IS NOT NULL AND g_tax_type_code_high IS NOT NULL THEN

Line 1384: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.build_sql',

1380: L_WHERE_TAX_TYPE_CODE_ADJ := ' AND DECODE(:G_TAX_TYPE_CODE_LOW,NULL,NULL) IS NULL '||
1381: ' AND DECODE(:G_TAX_TYPE_CODE_HIGH,NULL,NULL) IS NULL ';
1382: END IF;
1383: IF (g_level_procedure >= g_current_runtime_level ) THEN
1384: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.build_sql',
1385: 'L_WHERE_TAX_TYPE_CODE_ADJ : '||L_WHERE_TAX_TYPE_CODE_ADJ);
1386: END IF;
1387:
1388: /* IF G_TAX_RATE_CODE IS NOT NULL THEN

Line 1493: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.build_sql',

1489: AND DECODE(:G_CURRENCY_CODE_HIGH,NULL,NULL) IS NULL ';
1490: END IF;
1491:
1492: IF (g_level_procedure >= g_current_runtime_level ) THEN
1493: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.build_sql',
1494: 'L_WHERE_CURRENCY_CODE_ADJ : '|| L_WHERE_CURRENCY_CODE_ADJ);
1495: END IF;
1496:
1497: -- Check this with kripa

Line 1610: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.build_sql',

1606: L_WHERE_TRX_CLASS_ADJ_TAX := ' AND 1 = 2 ';
1607: END IF;
1608:
1609: IF (g_level_procedure >= g_current_runtime_level ) THEN
1610: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.build_sql',
1611: 'G_INCLUDE_AR_ADJ_TRX_CLASS : '||G_INCLUDE_AR_ADJ_TRX_CLASS);
1612: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.build_sql',
1613: 'L_WHERE_TRX_CLASS_ADJ_FINCHRG : '||L_WHERE_TRX_CLASS_ADJ_FINCHRG);
1614: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.build_sql',

Line 1612: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.build_sql',

1608:
1609: IF (g_level_procedure >= g_current_runtime_level ) THEN
1610: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.build_sql',
1611: 'G_INCLUDE_AR_ADJ_TRX_CLASS : '||G_INCLUDE_AR_ADJ_TRX_CLASS);
1612: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.build_sql',
1613: 'L_WHERE_TRX_CLASS_ADJ_FINCHRG : '||L_WHERE_TRX_CLASS_ADJ_FINCHRG);
1614: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.build_sql',
1615: 'L_WHERE_TRX_CLASS_ADJ_TAX : '||L_WHERE_TRX_CLASS_ADJ_TAX);
1616: END IF;

Line 1614: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.build_sql',

1610: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.build_sql',
1611: 'G_INCLUDE_AR_ADJ_TRX_CLASS : '||G_INCLUDE_AR_ADJ_TRX_CLASS);
1612: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.build_sql',
1613: 'L_WHERE_TRX_CLASS_ADJ_FINCHRG : '||L_WHERE_TRX_CLASS_ADJ_FINCHRG);
1614: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.build_sql',
1615: 'L_WHERE_TRX_CLASS_ADJ_TAX : '||L_WHERE_TRX_CLASS_ADJ_TAX);
1616: END IF;
1617:
1618: -- New paraneter code

Line 1670: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.build_sql',

1666: L_WHERE_ACCOUNTING_STATUS_BR := ' AND 1=1 ';
1667: --L_WHERE_ACCOUNTING_STATUS_CM_REC := ' AND 1 = 1 ';
1668:
1669: IF (g_level_procedure >= g_current_runtime_level ) THEN
1670: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.build_sql',
1671: 'L_WHERE_ACCOUNTING_STATUS_TRX : '||L_WHERE_ACCOUNTING_STATUS_TRX);
1672: END IF;
1673:
1674: END IF;

Line 1710: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.build_sql',

1706: L_WHERE_GL_FLEX := ' AND 1=1 ';
1707: END IF;
1708:
1709: IF (g_level_procedure >= g_current_runtime_level ) THEN
1710: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.build_sql',
1711: 'L_WHERE_GL_FLEX :'||L_WHERE_GL_FLEX);
1712: END IF;
1713:
1714:

Line 1796: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.build_sql',

1792: -- CONDITIONALLY EXECUTE
1793:
1794:
1795: IF (g_level_procedure >= g_current_runtime_level ) THEN
1796: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.build_sql',
1797: 'Dynamic SQL Statement Sarts Here:');
1798: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.build_sql',
1799: 'G_INCLUDE_AR_INV_TRX_CLASS : '||G_INCLUDE_AR_INV_TRX_CLASS);
1800: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.build_sql',

Line 1798: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.build_sql',

1794:
1795: IF (g_level_procedure >= g_current_runtime_level ) THEN
1796: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.build_sql',
1797: 'Dynamic SQL Statement Sarts Here:');
1798: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.build_sql',
1799: 'G_INCLUDE_AR_INV_TRX_CLASS : '||G_INCLUDE_AR_INV_TRX_CLASS);
1800: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.build_sql',
1801: 'G_REGISTER_TYPE : '||G_REGISTER_TYPE);
1802: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.build_sql',

Line 1800: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.build_sql',

1796: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.build_sql',
1797: 'Dynamic SQL Statement Sarts Here:');
1798: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.build_sql',
1799: 'G_INCLUDE_AR_INV_TRX_CLASS : '||G_INCLUDE_AR_INV_TRX_CLASS);
1800: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.build_sql',
1801: 'G_REGISTER_TYPE : '||G_REGISTER_TYPE);
1802: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.build_sql',
1803: 'G_SUMMARY_LEVEL : '||G_SUMMARY_LEVEL);
1804: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.build_sql',

Line 1802: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.build_sql',

1798: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.build_sql',
1799: 'G_INCLUDE_AR_INV_TRX_CLASS : '||G_INCLUDE_AR_INV_TRX_CLASS);
1800: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.build_sql',
1801: 'G_REGISTER_TYPE : '||G_REGISTER_TYPE);
1802: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.build_sql',
1803: 'G_SUMMARY_LEVEL : '||G_SUMMARY_LEVEL);
1804: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.build_sql',
1805: 'G_ACCOUNTING_STATUS : '||G_ACCOUNTING_STATUS);
1806: END IF;

Line 1804: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.build_sql',

1800: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.build_sql',
1801: 'G_REGISTER_TYPE : '||G_REGISTER_TYPE);
1802: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.build_sql',
1803: 'G_SUMMARY_LEVEL : '||G_SUMMARY_LEVEL);
1804: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.build_sql',
1805: 'G_ACCOUNTING_STATUS : '||G_ACCOUNTING_STATUS);
1806: END IF;
1807:
1808:

Line 1820: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.build_sql',

1816: IF UPPER(G_SUMMARY_LEVEL) = 'TRANSACTION' THEN
1817: IF (G_ACCOUNTING_STATUS = 'UNACCOUNTED') OR
1818: (G_GL_DATE_LOW IS NULL AND G_GL_DATE_HIGH IS NULL) THEN
1819: IF (g_level_procedure >= g_current_runtime_level ) THEN
1820: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.build_sql',
1821: 'SQL-1 For Invoice, Credit Memo, Debit Memo: Header Level');
1822: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.build_sql',
1823: 'G_ACCOUNTING_STATUS : '||G_ACCOUNTING_STATUS);
1824: END IF;

Line 1822: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.build_sql',

1818: (G_GL_DATE_LOW IS NULL AND G_GL_DATE_HIGH IS NULL) THEN
1819: IF (g_level_procedure >= g_current_runtime_level ) THEN
1820: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.build_sql',
1821: 'SQL-1 For Invoice, Credit Memo, Debit Memo: Header Level');
1822: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.build_sql',
1823: 'G_ACCOUNTING_STATUS : '||G_ACCOUNTING_STATUS);
1824: END IF;
1825:
1826:

Line 2212: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.build_sql',

2208: (NVL(G_ACCOUNTING_STATUS,'BOTH') = 'BOTH' AND NVL(G_INCLUDE_ACCOUNTING_SEGMENTS,'N')='Y'))
2209: OR (G_GL_DATE_LOW IS NOT NULL OR G_GL_DATE_HIGH IS NOT NULL) THEN
2210:
2211: IF (g_level_procedure >= g_current_runtime_level ) THEN
2212: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.build_sql',
2213: 'SQL-1-1 For Invoice, Credit Memo, Debit Memo: Header Level - Accounted');
2214: END IF;
2215:
2216: L_COLUMN_LIST_AR_INV :=

Line 2613: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.build_sql',

2609: G_ACCOUNTING_STATUS <> 'ACCOUNTED') THEN
2610: -- (NVL(G_ACCOUNTING_STATUS,'BOTH') = 'BOTH' AND NVL(G_INCLUDE_ACCOUNTING_SEGMENTS,'N')='N'))
2611:
2612: IF (g_level_procedure >= g_current_runtime_level ) THEN
2613: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.build_sql',
2614: 'SQL-2 For Invoice, Credit Memo, Debit Memo: Line Level');
2615: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.build_sql',
2616: 'G_ACCOUNTING_STATUS : '||G_ACCOUNTING_STATUS);
2617: END IF;

Line 2615: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.build_sql',

2611:
2612: IF (g_level_procedure >= g_current_runtime_level ) THEN
2613: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.build_sql',
2614: 'SQL-2 For Invoice, Credit Memo, Debit Memo: Line Level');
2615: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.build_sql',
2616: 'G_ACCOUNTING_STATUS : '||G_ACCOUNTING_STATUS);
2617: END IF;
2618:
2619: L_COLUMN_LIST_AR_INV :=

Line 2859: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.build_sql',

2855: OR (G_GL_DATE_LOW IS NOT NULL OR G_GL_DATE_HIGH IS NOT NULL)
2856: OR (G_REPORT_NAME = 'JLARTDFF') THEN
2857:
2858: IF (g_level_procedure >= g_current_runtime_level ) THEN
2859: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.build_sql',
2860: 'SQL-2-1 For Invoice, Credit Memo, Debit Memo: Line Level: Accounting');
2861: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.build_sql',
2862: 'G_ACCOUNTING_STATUS : '||G_ACCOUNTING_STATUS);
2863: END IF;

Line 2861: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.build_sql',

2857:
2858: IF (g_level_procedure >= g_current_runtime_level ) THEN
2859: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.build_sql',
2860: 'SQL-2-1 For Invoice, Credit Memo, Debit Memo: Line Level: Accounting');
2861: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.build_sql',
2862: 'G_ACCOUNTING_STATUS : '||G_ACCOUNTING_STATUS);
2863: END IF;
2864:
2865: L_COLUMN_LIST_AR_INV :=

Line 3106: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.build_sql',

3102: -- Matrix reporting is not supported at transaction distribution level
3103:
3104:
3105: IF (g_level_procedure >= g_current_runtime_level ) THEN
3106: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.build_sql',
3107: 'SQL-3 For Invoice, Credit Memo, Debit Memo: Distribution Level');
3108: END IF;
3109:
3110: L_COLUMN_LIST_AR_INV :=

Line 3381: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.build_sql',

3377: UPPER(G_SUMMARY_LEVEL) = 'TRANSACTION_LINE')
3378: THEN
3379:
3380: IF (g_level_procedure >= g_current_runtime_level ) THEN
3381: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.build_sql',
3382: 'SQL-4 For AR Applications : Header or Line Level');
3383: END IF;
3384:
3385: L_COLUMN_LIST_AR_APP :=

Line 4178: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.build_sql',

4174: ELSIF UPPER(G_SUMMARY_LEVEL) = 'TRANSACTION_DISTRIBUTION' THEN
4175:
4176: IF G_REPORT_NAME = 'ZXXVATRN' THEN
4177: IF (g_level_procedure >= g_current_runtime_level ) THEN
4178: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.build_sql',
4179: 'SQL-5 For AR Applications :Reconciliation Report: Distribution Level');
4180: END IF;
4181:
4182: L_COLUMN_LIST_AR_APP :=

Line 4471: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.build_sql',

4467: || L_WHERE_ACCOUNTING_STATUS_APP;
4468:
4469: ELSE
4470: IF (g_level_procedure >= g_current_runtime_level ) THEN
4471: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.build_sql',
4472: 'SQL-5-1 For AR Applications : Distribution Level');
4473: END IF;
4474:
4475: L_COLUMN_LIST_AR_APP :=

Line 4790: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.build_sql',

4786:
4787: THEN
4788:
4789: IF (g_level_procedure >= g_current_runtime_level ) THEN
4790: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.build_sql',
4791: 'SQL-6-1 For AR Adjustments : Header or Line Level');
4792: END IF;
4793:
4794: L_COLUMN_LIST_AR_ADJ :=

Line 5116: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.build_sql',

5112: ELSIF UPPER(G_SUMMARY_LEVEL) = 'TRANSACTION_DISTRIBUTION' THEN
5113:
5114: -- IF G_REPORT_NAME = 'ZXXVATRN' THEN
5115: IF (g_level_procedure >= g_current_runtime_level ) THEN
5116: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.build_sql',
5117: 'SQL-7-1 For AR Adjustments - Distributions Level');
5118: END IF;
5119:
5120:

Line 5389: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.build_sql',

5385: || L_WHERE_ACCOUNTING_STATUS_ADJ;
5386:
5387: /*ELSE
5388: IF (g_level_procedure >= g_current_runtime_level ) THEN
5389: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.build_sql',
5390: 'SQL-7-1-1 For AR Adjustments : Distributions Level');
5391: END IF;
5392:
5393:

Line 5669: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.build_sql',

5665:
5666: --Bug 9031051
5667: /* IF G_ESL_EU_TRX_TYPE IS NOT NULL AND G_INCLUDE_AR_INV_TRX_CLASS = 'Y' THEN
5668: IF (g_level_procedure >= g_current_runtime_level ) THEN
5669: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.build_sql',
5670: 'SQL-6-2 For AR Adjustments EU VAT');
5671: END IF;
5672:
5673: L_COLUMN_LIST_AR_ADJ :=

Line 5996: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.build_sql',

5992: UPPER(G_SUMMARY_LEVEL) = 'TRANSACTION_LINE')
5993: THEN
5994:
5995: IF (g_level_procedure >= g_current_runtime_level ) THEN
5996: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.build_sql',
5997: 'SQL-8 For AR Misc Cash Receipts : Header or Line Level');
5998: END IF;
5999:
6000: L_COLUMN_LIST_AR_MISC :=

Line 6270: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.build_sql',

6266: ELSIF UPPER(G_SUMMARY_LEVEL) = 'TRANSACTION_DISTRIBUTION' THEN
6267: -- apai commented : needs to be removed AND NVL(G_TRX_CLASS,'MISC_CASH_RECEIPT') = ('MISC_CASH_RECEIPT') THEN
6268:
6269: IF (g_level_procedure >= g_current_runtime_level ) THEN
6270: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.build_sql',
6271: 'SQL-9 For AR Misc Cash Receipts : Distributions Level');
6272: END IF;
6273:
6274: L_COLUMN_LIST_AR_MISC :=

Line 6789: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.build_sql',

6785: UPPER(G_SUMMARY_LEVEL) = 'TRANSACTION_LINE')
6786: THEN
6787:
6788: IF (g_level_procedure >= g_current_runtime_level ) THEN
6789: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.build_sql',
6790: 'SQL-10 For AR Bills Receivables : Header or Line Level');
6791: END IF;
6792:
6793: L_COLUMN_LIST_AR_BR :=

Line 7194: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.build_sql',

7190: ELSIF UPPER(G_SUMMARY_LEVEL) = 'TRANSACTION_DISTRIBUTION' THEN
7191: -- apai commented : needs to be removed AND NVL(G_TRX_CLASS,'BR' ) = 'BR' THEN
7192:
7193: IF (g_level_procedure >= g_current_runtime_level ) THEN
7194: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.build_sql',
7195: 'SQL-11 For AR Bills Receivables : Distributions Level');
7196: END IF;
7197:
7198: L_COLUMN_LIST_AR_BR :=

Line 7481: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.build_sql',

7477: END IF; -- G_TRX_CLASS IS NULL
7478:
7479:
7480: IF (g_level_procedure >= g_current_runtime_level ) THEN
7481: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.build_sql',
7482: 'SQL-12 For No Tax code CMs: Header or Line Level');
7483: END IF;
7484:
7485:

Line 7730: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.build_sql.END',

7726: END IF;
7727:
7728:
7729: IF (g_level_procedure >= g_current_runtime_level ) THEN
7730: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.build_sql.END',
7731: 'ZX_AR_EXTRACT_PKG: build_sql(-)');
7732: END IF;
7733:
7734: EXCEPTION

Line 7741: FND_LOG.STRING(g_level_unexpected,

7737: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
7738: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','build_sql- '|| g_error_buffer);
7739: FND_MSG_PUB.Add;
7740: IF (g_level_unexpected >= g_current_runtime_level ) THEN
7741: FND_LOG.STRING(g_level_unexpected,
7742: 'ZX.TRL.ZX_AR_EXTRACT_PKG.build_sql',
7743: g_error_buffer);
7744: END IF;
7745: g_retcode := 2;

Line 7792: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info.BEGIN',

7788: l_sql11 VARCHAR2(3500);
7789: BEGIN
7790:
7791: IF (g_level_procedure >= g_current_runtime_level ) THEN
7792: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info.BEGIN',
7793: 'ZX_AR_EXTRACT_PKG: fetch_ar_trx_info(+)');
7794: END IF;
7795:
7796: -- Since the driving SQL statement for AR exceeds 32000 characters which

Line 7862: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info',

7858: l_where_clause_ar_inv_no_tax ;
7859: -- END IF ;
7860:
7861: IF (g_level_procedure >= g_current_runtime_level ) THEN
7862: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info',
7863: 'l_sql_statement_tbl : ');
7864: END IF;
7865: /*
7866: -- l_sql1 := substr(l_sql_statement_ar_1,1,3000);

Line 7869: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl1 : '||l_sql1);

7865: /*
7866: -- l_sql1 := substr(l_sql_statement_ar_1,1,3000);
7867: IF (g_level_procedure >= g_current_runtime_level ) THEN
7868: l_sql1 := substr(l_sql_statement_ar_1,1,3000);
7869: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl1 : '||l_sql1);
7870: l_sql2 := substr(l_sql_statement_ar_1,3001,3000);
7871: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl2 : '||l_sql2);
7872: l_sql3 := substr(l_sql_statement_ar_1,6001,3000);
7873: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl3 : '||l_sql3);

Line 7871: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl2 : '||l_sql2);

7867: IF (g_level_procedure >= g_current_runtime_level ) THEN
7868: l_sql1 := substr(l_sql_statement_ar_1,1,3000);
7869: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl1 : '||l_sql1);
7870: l_sql2 := substr(l_sql_statement_ar_1,3001,3000);
7871: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl2 : '||l_sql2);
7872: l_sql3 := substr(l_sql_statement_ar_1,6001,3000);
7873: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl3 : '||l_sql3);
7874: l_sql4 := substr(l_sql_statement_ar_1,9001,3000);
7875: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl4 : '||l_sql4);

Line 7873: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl3 : '||l_sql3);

7869: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl1 : '||l_sql1);
7870: l_sql2 := substr(l_sql_statement_ar_1,3001,3000);
7871: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl2 : '||l_sql2);
7872: l_sql3 := substr(l_sql_statement_ar_1,6001,3000);
7873: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl3 : '||l_sql3);
7874: l_sql4 := substr(l_sql_statement_ar_1,9001,3000);
7875: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl4 : '||l_sql4);
7876: l_sql5 := substr(l_sql_statement_ar_1,12001,3000);
7877: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl5 : '||l_sql5);

Line 7875: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl4 : '||l_sql4);

7871: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl2 : '||l_sql2);
7872: l_sql3 := substr(l_sql_statement_ar_1,6001,3000);
7873: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl3 : '||l_sql3);
7874: l_sql4 := substr(l_sql_statement_ar_1,9001,3000);
7875: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl4 : '||l_sql4);
7876: l_sql5 := substr(l_sql_statement_ar_1,12001,3000);
7877: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl5 : '||l_sql5);
7878: l_sql6 := substr(l_sql_statement_ar_1,15001,3000);
7879: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl6 : '||l_sql6);

Line 7877: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl5 : '||l_sql5);

7873: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl3 : '||l_sql3);
7874: l_sql4 := substr(l_sql_statement_ar_1,9001,3000);
7875: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl4 : '||l_sql4);
7876: l_sql5 := substr(l_sql_statement_ar_1,12001,3000);
7877: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl5 : '||l_sql5);
7878: l_sql6 := substr(l_sql_statement_ar_1,15001,3000);
7879: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl6 : '||l_sql6);
7880: l_sql7 := substr(l_sql_statement_ar_1,18001,3000);
7881: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl7 : '||l_sql7);

Line 7879: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl6 : '||l_sql6);

7875: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl4 : '||l_sql4);
7876: l_sql5 := substr(l_sql_statement_ar_1,12001,3000);
7877: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl5 : '||l_sql5);
7878: l_sql6 := substr(l_sql_statement_ar_1,15001,3000);
7879: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl6 : '||l_sql6);
7880: l_sql7 := substr(l_sql_statement_ar_1,18001,3000);
7881: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl7 : '||l_sql7);
7882: l_sql8 := substr(l_sql_statement_ar_1,21001,3000);
7883: END IF;

Line 7881: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl7 : '||l_sql7);

7877: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl5 : '||l_sql5);
7878: l_sql6 := substr(l_sql_statement_ar_1,15001,3000);
7879: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl6 : '||l_sql6);
7880: l_sql7 := substr(l_sql_statement_ar_1,18001,3000);
7881: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl7 : '||l_sql7);
7882: l_sql8 := substr(l_sql_statement_ar_1,21001,3000);
7883: END IF;
7884:
7885: IF (g_level_procedure >= g_current_runtime_level ) THEN

Line 7887: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl1 : '||l_sql1);

7883: END IF;
7884:
7885: IF (g_level_procedure >= g_current_runtime_level ) THEN
7886: l_sql1 := substr(l_sql_statement_ar_3,1,3000);
7887: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl1 : '||l_sql1);
7888: l_sql2 := substr(l_sql_statement_ar_3,3001,3000);
7889: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl2 : '||l_sql2);
7890: l_sql3 := substr(l_sql_statement_ar_3,6001,3000);
7891: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl3 : '||l_sql3);

Line 7889: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl2 : '||l_sql2);

7885: IF (g_level_procedure >= g_current_runtime_level ) THEN
7886: l_sql1 := substr(l_sql_statement_ar_3,1,3000);
7887: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl1 : '||l_sql1);
7888: l_sql2 := substr(l_sql_statement_ar_3,3001,3000);
7889: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl2 : '||l_sql2);
7890: l_sql3 := substr(l_sql_statement_ar_3,6001,3000);
7891: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl3 : '||l_sql3);
7892: l_sql4 := substr(l_sql_statement_ar_3,9001,3000);
7893: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl4 : '||l_sql4);

Line 7891: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl3 : '||l_sql3);

7887: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl1 : '||l_sql1);
7888: l_sql2 := substr(l_sql_statement_ar_3,3001,3000);
7889: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl2 : '||l_sql2);
7890: l_sql3 := substr(l_sql_statement_ar_3,6001,3000);
7891: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl3 : '||l_sql3);
7892: l_sql4 := substr(l_sql_statement_ar_3,9001,3000);
7893: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl4 : '||l_sql4);
7894: l_sql5 := substr(l_sql_statement_ar_3,12001,3000);
7895: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl5 : '||l_sql5);

Line 7893: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl4 : '||l_sql4);

7889: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl2 : '||l_sql2);
7890: l_sql3 := substr(l_sql_statement_ar_3,6001,3000);
7891: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl3 : '||l_sql3);
7892: l_sql4 := substr(l_sql_statement_ar_3,9001,3000);
7893: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl4 : '||l_sql4);
7894: l_sql5 := substr(l_sql_statement_ar_3,12001,3000);
7895: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl5 : '||l_sql5);
7896: l_sql6 := substr(l_sql_statement_ar_3,15001,3000);
7897: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl6 : '||l_sql6);

Line 7895: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl5 : '||l_sql5);

7891: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl3 : '||l_sql3);
7892: l_sql4 := substr(l_sql_statement_ar_3,9001,3000);
7893: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl4 : '||l_sql4);
7894: l_sql5 := substr(l_sql_statement_ar_3,12001,3000);
7895: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl5 : '||l_sql5);
7896: l_sql6 := substr(l_sql_statement_ar_3,15001,3000);
7897: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl6 : '||l_sql6);
7898: l_sql7 := substr(l_sql_statement_ar_3,18001,3000);
7899: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl7 : '||l_sql7);

Line 7897: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl6 : '||l_sql6);

7893: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl4 : '||l_sql4);
7894: l_sql5 := substr(l_sql_statement_ar_3,12001,3000);
7895: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl5 : '||l_sql5);
7896: l_sql6 := substr(l_sql_statement_ar_3,15001,3000);
7897: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl6 : '||l_sql6);
7898: l_sql7 := substr(l_sql_statement_ar_3,18001,3000);
7899: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl7 : '||l_sql7);
7900: l_sql8 := substr(l_sql_statement_ar_3,21001,3000);
7901: END IF;

Line 7899: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl7 : '||l_sql7);

7895: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl5 : '||l_sql5);
7896: l_sql6 := substr(l_sql_statement_ar_3,15001,3000);
7897: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl6 : '||l_sql6);
7898: l_sql7 := substr(l_sql_statement_ar_3,18001,3000);
7899: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl7 : '||l_sql7);
7900: l_sql8 := substr(l_sql_statement_ar_3,21001,3000);
7901: END IF;
7902:
7903: IF (g_level_procedure >= g_current_runtime_level ) THEN

Line 7905: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl1 : '||l_sql1);

7901: END IF;
7902:
7903: IF (g_level_procedure >= g_current_runtime_level ) THEN
7904: l_sql1 := substr(l_sql_statement_ar_4,1,3000);
7905: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl1 : '||l_sql1);
7906: l_sql2 := substr(l_sql_statement_ar_4,3001,3000);
7907: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl2 : '||l_sql2);
7908: l_sql3 := substr(l_sql_statement_ar_4,6001,3000);
7909: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl3 : '||l_sql3);

Line 7907: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl2 : '||l_sql2);

7903: IF (g_level_procedure >= g_current_runtime_level ) THEN
7904: l_sql1 := substr(l_sql_statement_ar_4,1,3000);
7905: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl1 : '||l_sql1);
7906: l_sql2 := substr(l_sql_statement_ar_4,3001,3000);
7907: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl2 : '||l_sql2);
7908: l_sql3 := substr(l_sql_statement_ar_4,6001,3000);
7909: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl3 : '||l_sql3);
7910: l_sql4 := substr(l_sql_statement_ar_4,9001,3000);
7911: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl4 : '||l_sql4);

Line 7909: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl3 : '||l_sql3);

7905: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl1 : '||l_sql1);
7906: l_sql2 := substr(l_sql_statement_ar_4,3001,3000);
7907: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl2 : '||l_sql2);
7908: l_sql3 := substr(l_sql_statement_ar_4,6001,3000);
7909: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl3 : '||l_sql3);
7910: l_sql4 := substr(l_sql_statement_ar_4,9001,3000);
7911: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl4 : '||l_sql4);
7912: l_sql5 := substr(l_sql_statement_ar_4,12001,3000);
7913: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl5 : '||l_sql5);

Line 7911: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl4 : '||l_sql4);

7907: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl2 : '||l_sql2);
7908: l_sql3 := substr(l_sql_statement_ar_4,6001,3000);
7909: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl3 : '||l_sql3);
7910: l_sql4 := substr(l_sql_statement_ar_4,9001,3000);
7911: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl4 : '||l_sql4);
7912: l_sql5 := substr(l_sql_statement_ar_4,12001,3000);
7913: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl5 : '||l_sql5);
7914: l_sql6 := substr(l_sql_statement_ar_4,15001,3000);
7915: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl6 : '||l_sql6);

Line 7913: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl5 : '||l_sql5);

7909: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl3 : '||l_sql3);
7910: l_sql4 := substr(l_sql_statement_ar_4,9001,3000);
7911: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl4 : '||l_sql4);
7912: l_sql5 := substr(l_sql_statement_ar_4,12001,3000);
7913: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl5 : '||l_sql5);
7914: l_sql6 := substr(l_sql_statement_ar_4,15001,3000);
7915: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl6 : '||l_sql6);
7916: l_sql7 := substr(l_sql_statement_ar_4,18001,3000);
7917: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl7 : '||l_sql7);

Line 7915: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl6 : '||l_sql6);

7911: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl4 : '||l_sql4);
7912: l_sql5 := substr(l_sql_statement_ar_4,12001,3000);
7913: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl5 : '||l_sql5);
7914: l_sql6 := substr(l_sql_statement_ar_4,15001,3000);
7915: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl6 : '||l_sql6);
7916: l_sql7 := substr(l_sql_statement_ar_4,18001,3000);
7917: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl7 : '||l_sql7);
7918: l_sql8 := substr(l_sql_statement_ar_4,21001,3000);
7919: END IF;

Line 7917: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl7 : '||l_sql7);

7913: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl5 : '||l_sql5);
7914: l_sql6 := substr(l_sql_statement_ar_4,15001,3000);
7915: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl6 : '||l_sql6);
7916: l_sql7 := substr(l_sql_statement_ar_4,18001,3000);
7917: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl7 : '||l_sql7);
7918: l_sql8 := substr(l_sql_statement_ar_4,21001,3000);
7919: END IF;
7920: IF (g_level_procedure >= g_current_runtime_level ) THEN
7921: l_sql1 := substr(l_sql_statement_ar_5,1,3000);

Line 7922: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl1 : '||l_sql1);

7918: l_sql8 := substr(l_sql_statement_ar_4,21001,3000);
7919: END IF;
7920: IF (g_level_procedure >= g_current_runtime_level ) THEN
7921: l_sql1 := substr(l_sql_statement_ar_5,1,3000);
7922: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl1 : '||l_sql1);
7923: l_sql2 := substr(l_sql_statement_ar_5,3001,3000);
7924: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl2 : '||l_sql2);
7925: l_sql3 := substr(l_sql_statement_ar_5,6001,3000);
7926: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl3 : '||l_sql3);

Line 7924: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl2 : '||l_sql2);

7920: IF (g_level_procedure >= g_current_runtime_level ) THEN
7921: l_sql1 := substr(l_sql_statement_ar_5,1,3000);
7922: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl1 : '||l_sql1);
7923: l_sql2 := substr(l_sql_statement_ar_5,3001,3000);
7924: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl2 : '||l_sql2);
7925: l_sql3 := substr(l_sql_statement_ar_5,6001,3000);
7926: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl3 : '||l_sql3);
7927: l_sql4 := substr(l_sql_statement_ar_5,9001,3000);
7928: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl4 : '||l_sql4);

Line 7926: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl3 : '||l_sql3);

7922: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl1 : '||l_sql1);
7923: l_sql2 := substr(l_sql_statement_ar_5,3001,3000);
7924: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl2 : '||l_sql2);
7925: l_sql3 := substr(l_sql_statement_ar_5,6001,3000);
7926: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl3 : '||l_sql3);
7927: l_sql4 := substr(l_sql_statement_ar_5,9001,3000);
7928: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl4 : '||l_sql4);
7929: l_sql5 := substr(l_sql_statement_ar_5,12001,3000);
7930: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl5 : '||l_sql5);

Line 7928: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl4 : '||l_sql4);

7924: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl2 : '||l_sql2);
7925: l_sql3 := substr(l_sql_statement_ar_5,6001,3000);
7926: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl3 : '||l_sql3);
7927: l_sql4 := substr(l_sql_statement_ar_5,9001,3000);
7928: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl4 : '||l_sql4);
7929: l_sql5 := substr(l_sql_statement_ar_5,12001,3000);
7930: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl5 : '||l_sql5);
7931: l_sql6 := substr(l_sql_statement_ar_5,15001,3000);
7932: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl6 : '||l_sql6);

Line 7930: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl5 : '||l_sql5);

7926: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl3 : '||l_sql3);
7927: l_sql4 := substr(l_sql_statement_ar_5,9001,3000);
7928: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl4 : '||l_sql4);
7929: l_sql5 := substr(l_sql_statement_ar_5,12001,3000);
7930: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl5 : '||l_sql5);
7931: l_sql6 := substr(l_sql_statement_ar_5,15001,3000);
7932: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl6 : '||l_sql6);
7933: l_sql7 := substr(l_sql_statement_ar_5,18001,3000);
7934: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl7 : '||l_sql7);

Line 7932: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl6 : '||l_sql6);

7928: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl4 : '||l_sql4);
7929: l_sql5 := substr(l_sql_statement_ar_5,12001,3000);
7930: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl5 : '||l_sql5);
7931: l_sql6 := substr(l_sql_statement_ar_5,15001,3000);
7932: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl6 : '||l_sql6);
7933: l_sql7 := substr(l_sql_statement_ar_5,18001,3000);
7934: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl7 : '||l_sql7);
7935: l_sql8 := substr(l_sql_statement_ar_4,21001,3000);
7936: END IF;

Line 7934: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl7 : '||l_sql7);

7930: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl5 : '||l_sql5);
7931: l_sql6 := substr(l_sql_statement_ar_5,15001,3000);
7932: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl6 : '||l_sql6);
7933: l_sql7 := substr(l_sql_statement_ar_5,18001,3000);
7934: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl7 : '||l_sql7);
7935: l_sql8 := substr(l_sql_statement_ar_4,21001,3000);
7936: END IF;
7937: */
7938: l_sql_statement_tbl(1) := l_sql_statement_ar_1; --AR_INV

Line 7955: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info.END',

7951: END IF;
7952: END LOOP;
7953:
7954: IF (g_level_procedure >= g_current_runtime_level ) THEN
7955: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info.END',
7956: 'ZX_AR_EXTRACT_PKG: fetch_ar_trx_info(-)');
7957: END IF;
7958:
7959:

Line 7990: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg.BEGIN',

7986: st1 varchar(32000);
7987: BEGIN
7988:
7989: IF (g_level_procedure >= g_current_runtime_level ) THEN
7990: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg.BEGIN',
7991: 'ZX_AR_EXTRACT_PKG: execute_dynamic_sql_strg(+)');
7992: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg',
7993: 'OPEN zx_rep_detail_csr : ');
7994: END IF;

Line 7992: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg',

7988:
7989: IF (g_level_procedure >= g_current_runtime_level ) THEN
7990: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg.BEGIN',
7991: 'ZX_AR_EXTRACT_PKG: execute_dynamic_sql_strg(+)');
7992: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg',
7993: 'OPEN zx_rep_detail_csr : ');
7994: END IF;
7995:
7996: IF (g_level_procedure >= g_current_runtime_level ) THEN

Line 7998: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'l_sql_statement_tbl1 : '||l_sql1);

7994: END IF;
7995:
7996: IF (g_level_procedure >= g_current_runtime_level ) THEN
7997: l_sql1 := substr(p_statement,1,2000);
7998: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'l_sql_statement_tbl1 : '||l_sql1);
7999: l_sql2 := substr(p_statement,2001,2000);
8000: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'l_sql_statement_tbl2 : '||l_sql2);
8001: l_sql3 := substr(p_statement,4001,2000);
8002: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'l_sql_statement_tbl3 : '||l_sql3);

Line 8000: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'l_sql_statement_tbl2 : '||l_sql2);

7996: IF (g_level_procedure >= g_current_runtime_level ) THEN
7997: l_sql1 := substr(p_statement,1,2000);
7998: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'l_sql_statement_tbl1 : '||l_sql1);
7999: l_sql2 := substr(p_statement,2001,2000);
8000: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'l_sql_statement_tbl2 : '||l_sql2);
8001: l_sql3 := substr(p_statement,4001,2000);
8002: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'l_sql_statement_tbl3 : '||l_sql3);
8003: l_sql4 := substr(p_statement,6001,2000);
8004: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'l_sql_statement_tbl4 : '||l_sql4);

Line 8002: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'l_sql_statement_tbl3 : '||l_sql3);

7998: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'l_sql_statement_tbl1 : '||l_sql1);
7999: l_sql2 := substr(p_statement,2001,2000);
8000: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'l_sql_statement_tbl2 : '||l_sql2);
8001: l_sql3 := substr(p_statement,4001,2000);
8002: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'l_sql_statement_tbl3 : '||l_sql3);
8003: l_sql4 := substr(p_statement,6001,2000);
8004: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'l_sql_statement_tbl4 : '||l_sql4);
8005: l_sql5 := substr(p_statement,8001,2000);
8006: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'l_sql_statement_tbl5 : '||l_sql5);

Line 8004: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'l_sql_statement_tbl4 : '||l_sql4);

8000: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'l_sql_statement_tbl2 : '||l_sql2);
8001: l_sql3 := substr(p_statement,4001,2000);
8002: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'l_sql_statement_tbl3 : '||l_sql3);
8003: l_sql4 := substr(p_statement,6001,2000);
8004: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'l_sql_statement_tbl4 : '||l_sql4);
8005: l_sql5 := substr(p_statement,8001,2000);
8006: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'l_sql_statement_tbl5 : '||l_sql5);
8007: l_sql6 := substr(p_statement,10001,2000);
8008: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'l_sql_statement_tbl6 : '||l_sql6);

Line 8006: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'l_sql_statement_tbl5 : '||l_sql5);

8002: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'l_sql_statement_tbl3 : '||l_sql3);
8003: l_sql4 := substr(p_statement,6001,2000);
8004: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'l_sql_statement_tbl4 : '||l_sql4);
8005: l_sql5 := substr(p_statement,8001,2000);
8006: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'l_sql_statement_tbl5 : '||l_sql5);
8007: l_sql6 := substr(p_statement,10001,2000);
8008: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'l_sql_statement_tbl6 : '||l_sql6);
8009: l_sql7 := substr(p_statement,12001,2000);
8010: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'l_sql_statement_tbl7 : '||l_sql7);

Line 8008: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'l_sql_statement_tbl6 : '||l_sql6);

8004: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'l_sql_statement_tbl4 : '||l_sql4);
8005: l_sql5 := substr(p_statement,8001,2000);
8006: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'l_sql_statement_tbl5 : '||l_sql5);
8007: l_sql6 := substr(p_statement,10001,2000);
8008: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'l_sql_statement_tbl6 : '||l_sql6);
8009: l_sql7 := substr(p_statement,12001,2000);
8010: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'l_sql_statement_tbl7 : '||l_sql7);
8011: l_sql8 := substr(p_statement,14001,3000);
8012: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'l_sql_statement_tbl8 : '||l_sql8);

Line 8010: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'l_sql_statement_tbl7 : '||l_sql7);

8006: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'l_sql_statement_tbl5 : '||l_sql5);
8007: l_sql6 := substr(p_statement,10001,2000);
8008: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'l_sql_statement_tbl6 : '||l_sql6);
8009: l_sql7 := substr(p_statement,12001,2000);
8010: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'l_sql_statement_tbl7 : '||l_sql7);
8011: l_sql8 := substr(p_statement,14001,3000);
8012: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'l_sql_statement_tbl8 : '||l_sql8);
8013: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_LEDGER_ID : '||to_char(G_LEDGER_ID));
8014: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_LEGAL_ENTITY_ID : '||G_LEGAL_ENTITY_ID);

Line 8012: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'l_sql_statement_tbl8 : '||l_sql8);

8008: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'l_sql_statement_tbl6 : '||l_sql6);
8009: l_sql7 := substr(p_statement,12001,2000);
8010: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'l_sql_statement_tbl7 : '||l_sql7);
8011: l_sql8 := substr(p_statement,14001,3000);
8012: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'l_sql_statement_tbl8 : '||l_sql8);
8013: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_LEDGER_ID : '||to_char(G_LEDGER_ID));
8014: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_LEGAL_ENTITY_ID : '||G_LEGAL_ENTITY_ID);
8015: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_BATCH_NAME : '||G_BATCH_NAME);
8016: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_TRX_NUMBER_LOW : '||G_TRX_NUMBER_LOW);

Line 8013: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_LEDGER_ID : '||to_char(G_LEDGER_ID));

8009: l_sql7 := substr(p_statement,12001,2000);
8010: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'l_sql_statement_tbl7 : '||l_sql7);
8011: l_sql8 := substr(p_statement,14001,3000);
8012: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'l_sql_statement_tbl8 : '||l_sql8);
8013: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_LEDGER_ID : '||to_char(G_LEDGER_ID));
8014: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_LEGAL_ENTITY_ID : '||G_LEGAL_ENTITY_ID);
8015: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_BATCH_NAME : '||G_BATCH_NAME);
8016: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_TRX_NUMBER_LOW : '||G_TRX_NUMBER_LOW);
8017: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_TRX_NUMBER_HIGH : '||G_TRX_NUMBER_HIGH);

Line 8014: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_LEGAL_ENTITY_ID : '||G_LEGAL_ENTITY_ID);

8010: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'l_sql_statement_tbl7 : '||l_sql7);
8011: l_sql8 := substr(p_statement,14001,3000);
8012: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'l_sql_statement_tbl8 : '||l_sql8);
8013: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_LEDGER_ID : '||to_char(G_LEDGER_ID));
8014: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_LEGAL_ENTITY_ID : '||G_LEGAL_ENTITY_ID);
8015: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_BATCH_NAME : '||G_BATCH_NAME);
8016: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_TRX_NUMBER_LOW : '||G_TRX_NUMBER_LOW);
8017: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_TRX_NUMBER_HIGH : '||G_TRX_NUMBER_HIGH);
8018: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_TRX_DATE_LOW : '||G_TRX_DATE_LOW);

Line 8015: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_BATCH_NAME : '||G_BATCH_NAME);

8011: l_sql8 := substr(p_statement,14001,3000);
8012: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'l_sql_statement_tbl8 : '||l_sql8);
8013: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_LEDGER_ID : '||to_char(G_LEDGER_ID));
8014: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_LEGAL_ENTITY_ID : '||G_LEGAL_ENTITY_ID);
8015: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_BATCH_NAME : '||G_BATCH_NAME);
8016: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_TRX_NUMBER_LOW : '||G_TRX_NUMBER_LOW);
8017: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_TRX_NUMBER_HIGH : '||G_TRX_NUMBER_HIGH);
8018: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_TRX_DATE_LOW : '||G_TRX_DATE_LOW);
8019: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_TRX_DATE_HIGH : '||G_TRX_DATE_HIGH);

Line 8016: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_TRX_NUMBER_LOW : '||G_TRX_NUMBER_LOW);

8012: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'l_sql_statement_tbl8 : '||l_sql8);
8013: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_LEDGER_ID : '||to_char(G_LEDGER_ID));
8014: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_LEGAL_ENTITY_ID : '||G_LEGAL_ENTITY_ID);
8015: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_BATCH_NAME : '||G_BATCH_NAME);
8016: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_TRX_NUMBER_LOW : '||G_TRX_NUMBER_LOW);
8017: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_TRX_NUMBER_HIGH : '||G_TRX_NUMBER_HIGH);
8018: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_TRX_DATE_LOW : '||G_TRX_DATE_LOW);
8019: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_TRX_DATE_HIGH : '||G_TRX_DATE_HIGH);
8020: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_GL_DATE_LOW : '||G_GL_DATE_LOW);

Line 8017: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_TRX_NUMBER_HIGH : '||G_TRX_NUMBER_HIGH);

8013: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_LEDGER_ID : '||to_char(G_LEDGER_ID));
8014: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_LEGAL_ENTITY_ID : '||G_LEGAL_ENTITY_ID);
8015: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_BATCH_NAME : '||G_BATCH_NAME);
8016: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_TRX_NUMBER_LOW : '||G_TRX_NUMBER_LOW);
8017: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_TRX_NUMBER_HIGH : '||G_TRX_NUMBER_HIGH);
8018: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_TRX_DATE_LOW : '||G_TRX_DATE_LOW);
8019: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_TRX_DATE_HIGH : '||G_TRX_DATE_HIGH);
8020: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_GL_DATE_LOW : '||G_GL_DATE_LOW);
8021: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_GL_DATE_HIGH : '||G_GL_DATE_HIGH);

Line 8018: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_TRX_DATE_LOW : '||G_TRX_DATE_LOW);

8014: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_LEGAL_ENTITY_ID : '||G_LEGAL_ENTITY_ID);
8015: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_BATCH_NAME : '||G_BATCH_NAME);
8016: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_TRX_NUMBER_LOW : '||G_TRX_NUMBER_LOW);
8017: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_TRX_NUMBER_HIGH : '||G_TRX_NUMBER_HIGH);
8018: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_TRX_DATE_LOW : '||G_TRX_DATE_LOW);
8019: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_TRX_DATE_HIGH : '||G_TRX_DATE_HIGH);
8020: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_GL_DATE_LOW : '||G_GL_DATE_LOW);
8021: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_GL_DATE_HIGH : '||G_GL_DATE_HIGH);
8022: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_DOCUMENT_SUB_TYPE : '||G_DOCUMENT_SUB_TYPE);

Line 8019: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_TRX_DATE_HIGH : '||G_TRX_DATE_HIGH);

8015: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_BATCH_NAME : '||G_BATCH_NAME);
8016: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_TRX_NUMBER_LOW : '||G_TRX_NUMBER_LOW);
8017: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_TRX_NUMBER_HIGH : '||G_TRX_NUMBER_HIGH);
8018: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_TRX_DATE_LOW : '||G_TRX_DATE_LOW);
8019: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_TRX_DATE_HIGH : '||G_TRX_DATE_HIGH);
8020: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_GL_DATE_LOW : '||G_GL_DATE_LOW);
8021: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_GL_DATE_HIGH : '||G_GL_DATE_HIGH);
8022: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_DOCUMENT_SUB_TYPE : '||G_DOCUMENT_SUB_TYPE);
8023: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_DOCUMENT_SUB_TYPE : '||G_DOCUMENT_SUB_TYPE);

Line 8020: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_GL_DATE_LOW : '||G_GL_DATE_LOW);

8016: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_TRX_NUMBER_LOW : '||G_TRX_NUMBER_LOW);
8017: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_TRX_NUMBER_HIGH : '||G_TRX_NUMBER_HIGH);
8018: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_TRX_DATE_LOW : '||G_TRX_DATE_LOW);
8019: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_TRX_DATE_HIGH : '||G_TRX_DATE_HIGH);
8020: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_GL_DATE_LOW : '||G_GL_DATE_LOW);
8021: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_GL_DATE_HIGH : '||G_GL_DATE_HIGH);
8022: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_DOCUMENT_SUB_TYPE : '||G_DOCUMENT_SUB_TYPE);
8023: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_DOCUMENT_SUB_TYPE : '||G_DOCUMENT_SUB_TYPE);
8024: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_TRX_BUSINESS_CATEGORY, : '||G_TRX_BUSINESS_CATEGORY);

Line 8021: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_GL_DATE_HIGH : '||G_GL_DATE_HIGH);

8017: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_TRX_NUMBER_HIGH : '||G_TRX_NUMBER_HIGH);
8018: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_TRX_DATE_LOW : '||G_TRX_DATE_LOW);
8019: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_TRX_DATE_HIGH : '||G_TRX_DATE_HIGH);
8020: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_GL_DATE_LOW : '||G_GL_DATE_LOW);
8021: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_GL_DATE_HIGH : '||G_GL_DATE_HIGH);
8022: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_DOCUMENT_SUB_TYPE : '||G_DOCUMENT_SUB_TYPE);
8023: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_DOCUMENT_SUB_TYPE : '||G_DOCUMENT_SUB_TYPE);
8024: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_TRX_BUSINESS_CATEGORY, : '||G_TRX_BUSINESS_CATEGORY);
8025: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_TAX_INVOICE_DATE_LOW, : '||G_TAX_INVOICE_DATE_LOW);

Line 8022: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_DOCUMENT_SUB_TYPE : '||G_DOCUMENT_SUB_TYPE);

8018: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_TRX_DATE_LOW : '||G_TRX_DATE_LOW);
8019: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_TRX_DATE_HIGH : '||G_TRX_DATE_HIGH);
8020: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_GL_DATE_LOW : '||G_GL_DATE_LOW);
8021: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_GL_DATE_HIGH : '||G_GL_DATE_HIGH);
8022: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_DOCUMENT_SUB_TYPE : '||G_DOCUMENT_SUB_TYPE);
8023: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_DOCUMENT_SUB_TYPE : '||G_DOCUMENT_SUB_TYPE);
8024: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_TRX_BUSINESS_CATEGORY, : '||G_TRX_BUSINESS_CATEGORY);
8025: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_TAX_INVOICE_DATE_LOW, : '||G_TAX_INVOICE_DATE_LOW);
8026: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_TAX_INVOICE_DATE_HIGH, : '||G_TAX_INVOICE_DATE_HIGH);

Line 8023: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_DOCUMENT_SUB_TYPE : '||G_DOCUMENT_SUB_TYPE);

8019: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_TRX_DATE_HIGH : '||G_TRX_DATE_HIGH);
8020: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_GL_DATE_LOW : '||G_GL_DATE_LOW);
8021: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_GL_DATE_HIGH : '||G_GL_DATE_HIGH);
8022: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_DOCUMENT_SUB_TYPE : '||G_DOCUMENT_SUB_TYPE);
8023: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_DOCUMENT_SUB_TYPE : '||G_DOCUMENT_SUB_TYPE);
8024: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_TRX_BUSINESS_CATEGORY, : '||G_TRX_BUSINESS_CATEGORY);
8025: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_TAX_INVOICE_DATE_LOW, : '||G_TAX_INVOICE_DATE_LOW);
8026: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_TAX_INVOICE_DATE_HIGH, : '||G_TAX_INVOICE_DATE_HIGH);
8027: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_TAX_JURISDICTION_CODE, : '||G_TAX_JURISDICTION_CODE);

Line 8024: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_TRX_BUSINESS_CATEGORY, : '||G_TRX_BUSINESS_CATEGORY);

8020: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_GL_DATE_LOW : '||G_GL_DATE_LOW);
8021: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_GL_DATE_HIGH : '||G_GL_DATE_HIGH);
8022: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_DOCUMENT_SUB_TYPE : '||G_DOCUMENT_SUB_TYPE);
8023: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_DOCUMENT_SUB_TYPE : '||G_DOCUMENT_SUB_TYPE);
8024: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_TRX_BUSINESS_CATEGORY, : '||G_TRX_BUSINESS_CATEGORY);
8025: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_TAX_INVOICE_DATE_LOW, : '||G_TAX_INVOICE_DATE_LOW);
8026: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_TAX_INVOICE_DATE_HIGH, : '||G_TAX_INVOICE_DATE_HIGH);
8027: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_TAX_JURISDICTION_CODE, : '||G_TAX_JURISDICTION_CODE);
8028: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_FIRST_PARTY_TAX_REG_NUM, : '||G_FIRST_PARTY_TAX_REG_NUM);

Line 8025: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_TAX_INVOICE_DATE_LOW, : '||G_TAX_INVOICE_DATE_LOW);

8021: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_GL_DATE_HIGH : '||G_GL_DATE_HIGH);
8022: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_DOCUMENT_SUB_TYPE : '||G_DOCUMENT_SUB_TYPE);
8023: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_DOCUMENT_SUB_TYPE : '||G_DOCUMENT_SUB_TYPE);
8024: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_TRX_BUSINESS_CATEGORY, : '||G_TRX_BUSINESS_CATEGORY);
8025: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_TAX_INVOICE_DATE_LOW, : '||G_TAX_INVOICE_DATE_LOW);
8026: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_TAX_INVOICE_DATE_HIGH, : '||G_TAX_INVOICE_DATE_HIGH);
8027: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_TAX_JURISDICTION_CODE, : '||G_TAX_JURISDICTION_CODE);
8028: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_FIRST_PARTY_TAX_REG_NUM, : '||G_FIRST_PARTY_TAX_REG_NUM);
8029: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_TAX_REGIME_CODE, : '||G_TAX_REGIME_CODE);

Line 8026: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_TAX_INVOICE_DATE_HIGH, : '||G_TAX_INVOICE_DATE_HIGH);

8022: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_DOCUMENT_SUB_TYPE : '||G_DOCUMENT_SUB_TYPE);
8023: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_DOCUMENT_SUB_TYPE : '||G_DOCUMENT_SUB_TYPE);
8024: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_TRX_BUSINESS_CATEGORY, : '||G_TRX_BUSINESS_CATEGORY);
8025: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_TAX_INVOICE_DATE_LOW, : '||G_TAX_INVOICE_DATE_LOW);
8026: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_TAX_INVOICE_DATE_HIGH, : '||G_TAX_INVOICE_DATE_HIGH);
8027: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_TAX_JURISDICTION_CODE, : '||G_TAX_JURISDICTION_CODE);
8028: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_FIRST_PARTY_TAX_REG_NUM, : '||G_FIRST_PARTY_TAX_REG_NUM);
8029: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_TAX_REGIME_CODE, : '||G_TAX_REGIME_CODE);
8030: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_TAX, : '||G_TAX);

Line 8027: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_TAX_JURISDICTION_CODE, : '||G_TAX_JURISDICTION_CODE);

8023: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_DOCUMENT_SUB_TYPE : '||G_DOCUMENT_SUB_TYPE);
8024: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_TRX_BUSINESS_CATEGORY, : '||G_TRX_BUSINESS_CATEGORY);
8025: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_TAX_INVOICE_DATE_LOW, : '||G_TAX_INVOICE_DATE_LOW);
8026: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_TAX_INVOICE_DATE_HIGH, : '||G_TAX_INVOICE_DATE_HIGH);
8027: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_TAX_JURISDICTION_CODE, : '||G_TAX_JURISDICTION_CODE);
8028: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_FIRST_PARTY_TAX_REG_NUM, : '||G_FIRST_PARTY_TAX_REG_NUM);
8029: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_TAX_REGIME_CODE, : '||G_TAX_REGIME_CODE);
8030: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_TAX, : '||G_TAX);
8031: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_TAX_STATUS_CODE, : '||G_TAX_STATUS_CODE);

Line 8028: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_FIRST_PARTY_TAX_REG_NUM, : '||G_FIRST_PARTY_TAX_REG_NUM);

8024: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_TRX_BUSINESS_CATEGORY, : '||G_TRX_BUSINESS_CATEGORY);
8025: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_TAX_INVOICE_DATE_LOW, : '||G_TAX_INVOICE_DATE_LOW);
8026: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_TAX_INVOICE_DATE_HIGH, : '||G_TAX_INVOICE_DATE_HIGH);
8027: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_TAX_JURISDICTION_CODE, : '||G_TAX_JURISDICTION_CODE);
8028: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_FIRST_PARTY_TAX_REG_NUM, : '||G_FIRST_PARTY_TAX_REG_NUM);
8029: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_TAX_REGIME_CODE, : '||G_TAX_REGIME_CODE);
8030: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_TAX, : '||G_TAX);
8031: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_TAX_STATUS_CODE, : '||G_TAX_STATUS_CODE);
8032: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_TAX_RATE_CODE_LOW, : '||G_TAX_RATE_CODE_LOW);

Line 8029: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_TAX_REGIME_CODE, : '||G_TAX_REGIME_CODE);

8025: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_TAX_INVOICE_DATE_LOW, : '||G_TAX_INVOICE_DATE_LOW);
8026: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_TAX_INVOICE_DATE_HIGH, : '||G_TAX_INVOICE_DATE_HIGH);
8027: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_TAX_JURISDICTION_CODE, : '||G_TAX_JURISDICTION_CODE);
8028: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_FIRST_PARTY_TAX_REG_NUM, : '||G_FIRST_PARTY_TAX_REG_NUM);
8029: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_TAX_REGIME_CODE, : '||G_TAX_REGIME_CODE);
8030: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_TAX, : '||G_TAX);
8031: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_TAX_STATUS_CODE, : '||G_TAX_STATUS_CODE);
8032: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_TAX_RATE_CODE_LOW, : '||G_TAX_RATE_CODE_LOW);
8033: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_TAX_RATE_CODE_HIGH, : '||G_TAX_RATE_CODE_HIGH);

Line 8030: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_TAX, : '||G_TAX);

8026: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_TAX_INVOICE_DATE_HIGH, : '||G_TAX_INVOICE_DATE_HIGH);
8027: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_TAX_JURISDICTION_CODE, : '||G_TAX_JURISDICTION_CODE);
8028: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_FIRST_PARTY_TAX_REG_NUM, : '||G_FIRST_PARTY_TAX_REG_NUM);
8029: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_TAX_REGIME_CODE, : '||G_TAX_REGIME_CODE);
8030: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_TAX, : '||G_TAX);
8031: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_TAX_STATUS_CODE, : '||G_TAX_STATUS_CODE);
8032: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_TAX_RATE_CODE_LOW, : '||G_TAX_RATE_CODE_LOW);
8033: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_TAX_RATE_CODE_HIGH, : '||G_TAX_RATE_CODE_HIGH);
8034: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_TAX_TYPE_CODE_LOW, : '||G_TAX_TYPE_CODE_LOW);

Line 8031: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_TAX_STATUS_CODE, : '||G_TAX_STATUS_CODE);

8027: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_TAX_JURISDICTION_CODE, : '||G_TAX_JURISDICTION_CODE);
8028: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_FIRST_PARTY_TAX_REG_NUM, : '||G_FIRST_PARTY_TAX_REG_NUM);
8029: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_TAX_REGIME_CODE, : '||G_TAX_REGIME_CODE);
8030: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_TAX, : '||G_TAX);
8031: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_TAX_STATUS_CODE, : '||G_TAX_STATUS_CODE);
8032: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_TAX_RATE_CODE_LOW, : '||G_TAX_RATE_CODE_LOW);
8033: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_TAX_RATE_CODE_HIGH, : '||G_TAX_RATE_CODE_HIGH);
8034: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_TAX_TYPE_CODE_LOW, : '||G_TAX_TYPE_CODE_LOW);
8035: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_TAX_TYPE_CODE_HIGH, : '||G_TAX_TYPE_CODE_HIGH);

Line 8032: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_TAX_RATE_CODE_LOW, : '||G_TAX_RATE_CODE_LOW);

8028: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_FIRST_PARTY_TAX_REG_NUM, : '||G_FIRST_PARTY_TAX_REG_NUM);
8029: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_TAX_REGIME_CODE, : '||G_TAX_REGIME_CODE);
8030: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_TAX, : '||G_TAX);
8031: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_TAX_STATUS_CODE, : '||G_TAX_STATUS_CODE);
8032: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_TAX_RATE_CODE_LOW, : '||G_TAX_RATE_CODE_LOW);
8033: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_TAX_RATE_CODE_HIGH, : '||G_TAX_RATE_CODE_HIGH);
8034: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_TAX_TYPE_CODE_LOW, : '||G_TAX_TYPE_CODE_LOW);
8035: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_TAX_TYPE_CODE_HIGH, : '||G_TAX_TYPE_CODE_HIGH);
8036: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_CURRENCY_CODE_LOW, : '||G_CURRENCY_CODE_LOW);

Line 8033: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_TAX_RATE_CODE_HIGH, : '||G_TAX_RATE_CODE_HIGH);

8029: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_TAX_REGIME_CODE, : '||G_TAX_REGIME_CODE);
8030: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_TAX, : '||G_TAX);
8031: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_TAX_STATUS_CODE, : '||G_TAX_STATUS_CODE);
8032: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_TAX_RATE_CODE_LOW, : '||G_TAX_RATE_CODE_LOW);
8033: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_TAX_RATE_CODE_HIGH, : '||G_TAX_RATE_CODE_HIGH);
8034: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_TAX_TYPE_CODE_LOW, : '||G_TAX_TYPE_CODE_LOW);
8035: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_TAX_TYPE_CODE_HIGH, : '||G_TAX_TYPE_CODE_HIGH);
8036: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_CURRENCY_CODE_LOW, : '||G_CURRENCY_CODE_LOW);
8037: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_CURRENCY_CODE_HIGH, : '||G_CURRENCY_CODE_HIGH);

Line 8034: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_TAX_TYPE_CODE_LOW, : '||G_TAX_TYPE_CODE_LOW);

8030: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_TAX, : '||G_TAX);
8031: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_TAX_STATUS_CODE, : '||G_TAX_STATUS_CODE);
8032: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_TAX_RATE_CODE_LOW, : '||G_TAX_RATE_CODE_LOW);
8033: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_TAX_RATE_CODE_HIGH, : '||G_TAX_RATE_CODE_HIGH);
8034: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_TAX_TYPE_CODE_LOW, : '||G_TAX_TYPE_CODE_LOW);
8035: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_TAX_TYPE_CODE_HIGH, : '||G_TAX_TYPE_CODE_HIGH);
8036: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_CURRENCY_CODE_LOW, : '||G_CURRENCY_CODE_LOW);
8037: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_CURRENCY_CODE_HIGH, : '||G_CURRENCY_CODE_HIGH);
8038: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_AR_EXEMPTION_STATUS, : '||G_AR_EXEMPTION_STATUS);

Line 8035: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_TAX_TYPE_CODE_HIGH, : '||G_TAX_TYPE_CODE_HIGH);

8031: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_TAX_STATUS_CODE, : '||G_TAX_STATUS_CODE);
8032: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_TAX_RATE_CODE_LOW, : '||G_TAX_RATE_CODE_LOW);
8033: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_TAX_RATE_CODE_HIGH, : '||G_TAX_RATE_CODE_HIGH);
8034: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_TAX_TYPE_CODE_LOW, : '||G_TAX_TYPE_CODE_LOW);
8035: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_TAX_TYPE_CODE_HIGH, : '||G_TAX_TYPE_CODE_HIGH);
8036: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_CURRENCY_CODE_LOW, : '||G_CURRENCY_CODE_LOW);
8037: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_CURRENCY_CODE_HIGH, : '||G_CURRENCY_CODE_HIGH);
8038: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_AR_EXEMPTION_STATUS, : '||G_AR_EXEMPTION_STATUS);
8039: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_VAT_TRANSACTION_TYPE_CODE, : '||G_VAT_TRANSACTION_TYPE_CODE);

Line 8036: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_CURRENCY_CODE_LOW, : '||G_CURRENCY_CODE_LOW);

8032: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_TAX_RATE_CODE_LOW, : '||G_TAX_RATE_CODE_LOW);
8033: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_TAX_RATE_CODE_HIGH, : '||G_TAX_RATE_CODE_HIGH);
8034: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_TAX_TYPE_CODE_LOW, : '||G_TAX_TYPE_CODE_LOW);
8035: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_TAX_TYPE_CODE_HIGH, : '||G_TAX_TYPE_CODE_HIGH);
8036: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_CURRENCY_CODE_LOW, : '||G_CURRENCY_CODE_LOW);
8037: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_CURRENCY_CODE_HIGH, : '||G_CURRENCY_CODE_HIGH);
8038: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_AR_EXEMPTION_STATUS, : '||G_AR_EXEMPTION_STATUS);
8039: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_VAT_TRANSACTION_TYPE_CODE, : '||G_VAT_TRANSACTION_TYPE_CODE);
8040: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_VAT_TAX, : '||G_VAT_TAX);

Line 8037: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_CURRENCY_CODE_HIGH, : '||G_CURRENCY_CODE_HIGH);

8033: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_TAX_RATE_CODE_HIGH, : '||G_TAX_RATE_CODE_HIGH);
8034: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_TAX_TYPE_CODE_LOW, : '||G_TAX_TYPE_CODE_LOW);
8035: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_TAX_TYPE_CODE_HIGH, : '||G_TAX_TYPE_CODE_HIGH);
8036: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_CURRENCY_CODE_LOW, : '||G_CURRENCY_CODE_LOW);
8037: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_CURRENCY_CODE_HIGH, : '||G_CURRENCY_CODE_HIGH);
8038: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_AR_EXEMPTION_STATUS, : '||G_AR_EXEMPTION_STATUS);
8039: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_VAT_TRANSACTION_TYPE_CODE, : '||G_VAT_TRANSACTION_TYPE_CODE);
8040: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_VAT_TAX, : '||G_VAT_TAX);
8041: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_VAT_ADDITIONAL_TAX, : '||G_VAT_ADDITIONAL_TAX);

Line 8038: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_AR_EXEMPTION_STATUS, : '||G_AR_EXEMPTION_STATUS);

8034: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_TAX_TYPE_CODE_LOW, : '||G_TAX_TYPE_CODE_LOW);
8035: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_TAX_TYPE_CODE_HIGH, : '||G_TAX_TYPE_CODE_HIGH);
8036: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_CURRENCY_CODE_LOW, : '||G_CURRENCY_CODE_LOW);
8037: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_CURRENCY_CODE_HIGH, : '||G_CURRENCY_CODE_HIGH);
8038: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_AR_EXEMPTION_STATUS, : '||G_AR_EXEMPTION_STATUS);
8039: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_VAT_TRANSACTION_TYPE_CODE, : '||G_VAT_TRANSACTION_TYPE_CODE);
8040: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_VAT_TAX, : '||G_VAT_TAX);
8041: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_VAT_ADDITIONAL_TAX, : '||G_VAT_ADDITIONAL_TAX);
8042: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_VAT_NON_TAXABLE_TAX, : '||G_VAT_NON_TAXABLE_TAX);

Line 8039: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_VAT_TRANSACTION_TYPE_CODE, : '||G_VAT_TRANSACTION_TYPE_CODE);

8035: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_TAX_TYPE_CODE_HIGH, : '||G_TAX_TYPE_CODE_HIGH);
8036: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_CURRENCY_CODE_LOW, : '||G_CURRENCY_CODE_LOW);
8037: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_CURRENCY_CODE_HIGH, : '||G_CURRENCY_CODE_HIGH);
8038: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_AR_EXEMPTION_STATUS, : '||G_AR_EXEMPTION_STATUS);
8039: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_VAT_TRANSACTION_TYPE_CODE, : '||G_VAT_TRANSACTION_TYPE_CODE);
8040: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_VAT_TAX, : '||G_VAT_TAX);
8041: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_VAT_ADDITIONAL_TAX, : '||G_VAT_ADDITIONAL_TAX);
8042: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_VAT_NON_TAXABLE_TAX, : '||G_VAT_NON_TAXABLE_TAX);
8043: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_VAT_NOT_TAX, : '||G_VAT_NOT_TAX);

Line 8040: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_VAT_TAX, : '||G_VAT_TAX);

8036: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_CURRENCY_CODE_LOW, : '||G_CURRENCY_CODE_LOW);
8037: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_CURRENCY_CODE_HIGH, : '||G_CURRENCY_CODE_HIGH);
8038: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_AR_EXEMPTION_STATUS, : '||G_AR_EXEMPTION_STATUS);
8039: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_VAT_TRANSACTION_TYPE_CODE, : '||G_VAT_TRANSACTION_TYPE_CODE);
8040: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_VAT_TAX, : '||G_VAT_TAX);
8041: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_VAT_ADDITIONAL_TAX, : '||G_VAT_ADDITIONAL_TAX);
8042: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_VAT_NON_TAXABLE_TAX, : '||G_VAT_NON_TAXABLE_TAX);
8043: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_VAT_NOT_TAX, : '||G_VAT_NOT_TAX);
8044: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_VAT_PERCEPTION_TAX, : '||G_VAT_PERCEPTION_TAX);

Line 8041: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_VAT_ADDITIONAL_TAX, : '||G_VAT_ADDITIONAL_TAX);

8037: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_CURRENCY_CODE_HIGH, : '||G_CURRENCY_CODE_HIGH);
8038: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_AR_EXEMPTION_STATUS, : '||G_AR_EXEMPTION_STATUS);
8039: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_VAT_TRANSACTION_TYPE_CODE, : '||G_VAT_TRANSACTION_TYPE_CODE);
8040: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_VAT_TAX, : '||G_VAT_TAX);
8041: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_VAT_ADDITIONAL_TAX, : '||G_VAT_ADDITIONAL_TAX);
8042: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_VAT_NON_TAXABLE_TAX, : '||G_VAT_NON_TAXABLE_TAX);
8043: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_VAT_NOT_TAX, : '||G_VAT_NOT_TAX);
8044: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_VAT_PERCEPTION_TAX, : '||G_VAT_PERCEPTION_TAX);
8045: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_EXCISE_TAX, : '||G_EXCISE_TAX);

Line 8042: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_VAT_NON_TAXABLE_TAX, : '||G_VAT_NON_TAXABLE_TAX);

8038: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_AR_EXEMPTION_STATUS, : '||G_AR_EXEMPTION_STATUS);
8039: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_VAT_TRANSACTION_TYPE_CODE, : '||G_VAT_TRANSACTION_TYPE_CODE);
8040: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_VAT_TAX, : '||G_VAT_TAX);
8041: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_VAT_ADDITIONAL_TAX, : '||G_VAT_ADDITIONAL_TAX);
8042: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_VAT_NON_TAXABLE_TAX, : '||G_VAT_NON_TAXABLE_TAX);
8043: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_VAT_NOT_TAX, : '||G_VAT_NOT_TAX);
8044: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_VAT_PERCEPTION_TAX, : '||G_VAT_PERCEPTION_TAX);
8045: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_EXCISE_TAX, : '||G_EXCISE_TAX);
8046:

Line 8043: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_VAT_NOT_TAX, : '||G_VAT_NOT_TAX);

8039: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_VAT_TRANSACTION_TYPE_CODE, : '||G_VAT_TRANSACTION_TYPE_CODE);
8040: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_VAT_TAX, : '||G_VAT_TAX);
8041: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_VAT_ADDITIONAL_TAX, : '||G_VAT_ADDITIONAL_TAX);
8042: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_VAT_NON_TAXABLE_TAX, : '||G_VAT_NON_TAXABLE_TAX);
8043: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_VAT_NOT_TAX, : '||G_VAT_NOT_TAX);
8044: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_VAT_PERCEPTION_TAX, : '||G_VAT_PERCEPTION_TAX);
8045: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_EXCISE_TAX, : '||G_EXCISE_TAX);
8046:
8047: END IF;

Line 8044: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_VAT_PERCEPTION_TAX, : '||G_VAT_PERCEPTION_TAX);

8040: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_VAT_TAX, : '||G_VAT_TAX);
8041: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_VAT_ADDITIONAL_TAX, : '||G_VAT_ADDITIONAL_TAX);
8042: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_VAT_NON_TAXABLE_TAX, : '||G_VAT_NON_TAXABLE_TAX);
8043: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_VAT_NOT_TAX, : '||G_VAT_NOT_TAX);
8044: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_VAT_PERCEPTION_TAX, : '||G_VAT_PERCEPTION_TAX);
8045: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_EXCISE_TAX, : '||G_EXCISE_TAX);
8046:
8047: END IF;
8048:

Line 8045: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_EXCISE_TAX, : '||G_EXCISE_TAX);

8041: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_VAT_ADDITIONAL_TAX, : '||G_VAT_ADDITIONAL_TAX);
8042: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_VAT_NON_TAXABLE_TAX, : '||G_VAT_NON_TAXABLE_TAX);
8043: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_VAT_NOT_TAX, : '||G_VAT_NOT_TAX);
8044: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_VAT_PERCEPTION_TAX, : '||G_VAT_PERCEPTION_TAX);
8045: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg SQL', 'G_EXCISE_TAX, : '||G_EXCISE_TAX);
8046:
8047: END IF;
8048:
8049:

Line 8091: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg',

8087: G_EXCISE_TAX;
8088:
8089:
8090: IF (g_level_procedure >= g_current_runtime_level ) THEN
8091: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg',
8092: 'After Using Clause of zx_rep_detail_csr : ');
8093:
8094: END IF;
8095: IF zx_rep_detail_csr%NOTFOUND THEN

Line 8098: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg',

8094: END IF;
8095: IF zx_rep_detail_csr%NOTFOUND THEN
8096:
8097: IF (g_level_procedure >= g_current_runtime_level ) THEN
8098: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg',
8099: 'End of fetch zx_rep_detail_csr : ');
8100:
8101: END IF;
8102: END If;

Line 8119: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg',

8115:
8116: -- insert when fetch up to 1000 rows
8117: --
8118: IF (g_level_procedure >= g_current_runtime_level ) THEN
8119: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg',
8120: 'FETCH zx_rep_detail_csr : ');
8121: END IF;
8122:
8123: LOOP

Line 8322: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg',

8318:
8319:
8320: IF zx_rep_detail_csr%NOTFOUND THEN
8321: IF (g_level_procedure >= g_current_runtime_level ) THEN
8322: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg',
8323: 'End of FETCH zx_rep_detail_csr : ');
8324: END IF;
8325: END IF;
8326: IF zx_rep_detail_csr%FOUND THEN

Line 8360: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg',

8356: END LOOP;
8357:
8358: IF total_rec = 0 THEN
8359: IF (g_level_procedure >= g_current_runtime_level ) THEN
8360: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg',
8361: 'No Data found for the product AR (OR) Verify Parameters');
8362: g_retcode := 2;
8363: END IF;
8364: END IF;

Line 8368: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg.END',

8364: END IF;
8365:
8366:
8367: IF (g_level_procedure >= g_current_runtime_level ) THEN
8368: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg.END',
8369: 'ZX_AR_EXTRACT_PKG: execute_dynamic_sql_strg(-)');
8370: END IF;
8371:
8372: EXCEPTION

Line 8383: FND_LOG.STRING(g_level_unexpected,

8379: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
8380: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','execute_dynamic_sql_strg- '|| g_error_buffer);
8381: FND_MSG_PUB.Add;
8382: IF (g_level_unexpected >= g_current_runtime_level ) THEN
8383: FND_LOG.STRING(g_level_unexpected,
8384: 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg - Numeric error',
8385: g_error_buffer);
8386: END IF;
8387: g_retcode := 2;

Line 8399: FND_LOG.STRING(g_level_unexpected,

8395: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
8396: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','execute_dynamic_sql_strg- '|| g_error_buffer);
8397: FND_MSG_PUB.Add;
8398: IF (g_level_unexpected >= g_current_runtime_level ) THEN
8399: FND_LOG.STRING(g_level_unexpected,
8400: 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg-No data',
8401: g_error_buffer);
8402: END IF;
8403: g_retcode := 2;

Line 8415: FND_LOG.STRING(g_level_unexpected,

8411: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
8412: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','execute_dynamic_sql_strg- '|| g_error_buffer);
8413: FND_MSG_PUB.Add;
8414: IF (g_level_unexpected >= g_current_runtime_level ) THEN
8415: FND_LOG.STRING(g_level_unexpected,
8416: 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg',
8417: g_error_buffer);
8418: END IF;
8419:

Line 8451: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.insert_ar_trx_info.BEGIN',

8447:
8448: BEGIN
8449:
8450: IF (g_level_procedure >= g_current_runtime_level ) THEN
8451: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.insert_ar_trx_info.BEGIN',
8452: 'ZX_AR_EXTRACT_PKG: insert_ar_trx_info(+)');
8453: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.insert_ar_trx_info',
8454: 'Rows fetched : '||to_char(GT_LEDGER_ID.COUNT));
8455: END IF;

Line 8453: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.insert_ar_trx_info',

8449:
8450: IF (g_level_procedure >= g_current_runtime_level ) THEN
8451: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.insert_ar_trx_info.BEGIN',
8452: 'ZX_AR_EXTRACT_PKG: insert_ar_trx_info(+)');
8453: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.insert_ar_trx_info',
8454: 'Rows fetched : '||to_char(GT_LEDGER_ID.COUNT));
8455: END IF;
8456:
8457: l_count := NVL(GT_LEDGER_ID.COUNT, 0);

Line 8875: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.insert_ar_trx_info',

8871: GT_OFFSET_TAX_RATE(i),
8872: GT_OFFSET_FLAG(i));
8873:
8874: IF (g_level_procedure >= g_current_runtime_level ) THEN
8875: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.insert_ar_trx_info',
8876: 'Number of AR rows successfully inserted = '||TO_CHAR(NVL(GT_LEDGER_ID.COUNT, 0)));
8877: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.insert_ar_trx_info.END',
8878: 'ZX_AR_EXTRACT_PKG: insert_ar_trx_info(-)');
8879: END IF;

Line 8877: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.insert_ar_trx_info.END',

8873:
8874: IF (g_level_procedure >= g_current_runtime_level ) THEN
8875: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.insert_ar_trx_info',
8876: 'Number of AR rows successfully inserted = '||TO_CHAR(NVL(GT_LEDGER_ID.COUNT, 0)));
8877: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.insert_ar_trx_info.END',
8878: 'ZX_AR_EXTRACT_PKG: insert_ar_trx_info(-)');
8879: END IF;
8880:
8881: EXCEPTION

Line 8888: FND_LOG.STRING(g_level_unexpected,

8884: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
8885: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','insert_ar_trx_info- '|| g_error_buffer);
8886: FND_MSG_PUB.Add;
8887: IF (g_level_unexpected >= g_current_runtime_level ) THEN
8888: FND_LOG.STRING(g_level_unexpected,
8889: 'ZX.TRL.ZX_AR_EXTRACT_PKG.insert_ar_trx_info',
8890: g_error_buffer);
8891: END IF;
8892: g_retcode := 2;

Line 9118: FND_LOG.STRING(g_level_unexpected,

9114: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
9115: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','init_ar_gt_tables- '|| g_error_buffer);
9116: FND_MSG_PUB.Add;
9117: IF (g_level_unexpected >= g_current_runtime_level ) THEN
9118: FND_LOG.STRING(g_level_unexpected,
9119: 'ZX.TRL.ZX_AR_EXTRACT_PKG.init_ar_gt_tables',
9120: g_error_buffer);
9121: END IF;
9122: g_retcode := 2;

Line 9151: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.assign_ar_global_variables.BEGIN',

9147:
9148: BEGIN
9149:
9150: IF (g_level_procedure >= g_current_runtime_level ) THEN
9151: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.assign_ar_global_variables.BEGIN',
9152: 'ZX_AR_EXTRACT_PKG:assign_ar_global_variables(+)');
9153: END IF;
9154:
9155: G_REPORTING_LEVEL := P_TRL_GLOBAL_VARIABLES_REC.REPORTING_LEVEL;

Line 9275: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.assign_ar_global_variables',

9271: G_EXTRACT_REPORT_LINE_NUMBER := 1;
9272: G_TRX_CLASS := NULL;
9273:
9274: IF (g_level_procedure >= g_current_runtime_level ) THEN
9275: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.assign_ar_global_variables',
9276: 'Getting the rep_context_id ');
9277: END IF ;
9278:
9279: -- G_REP_CONTEXT_ID := ZX_EXTRACT_PKG.GET_REP_CONTEXT_ID(P_TRL_GLOBAL_VARIABLES_REC.LEGAL_ENTITY_ID,

Line 9283: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.assign_ar_global_variables',

9279: -- G_REP_CONTEXT_ID := ZX_EXTRACT_PKG.GET_REP_CONTEXT_ID(P_TRL_GLOBAL_VARIABLES_REC.LEGAL_ENTITY_ID,
9280: -- P_TRL_GLOBAL_VARIABLES_REC.request_id);
9281:
9282: IF (g_level_procedure >= g_current_runtime_level ) THEN
9283: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.assign_ar_global_variables',
9284: ' G_REP_CONTEXT_ID fetched is : '||G_REP_CONTEXT_ID);
9285: END IF ;
9286:
9287: IF (g_level_procedure >= g_current_runtime_level ) THEN

Line 9288: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.assign_ar_global_variables.END',

9284: ' G_REP_CONTEXT_ID fetched is : '||G_REP_CONTEXT_ID);
9285: END IF ;
9286:
9287: IF (g_level_procedure >= g_current_runtime_level ) THEN
9288: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.assign_ar_global_variables.END',
9289: 'ZX_AR_EXTRACT_PKG:assign_ar_global_variables(-)');
9290: END IF;
9291: EXCEPTION
9292: WHEN OTHERS THEN

Line 9298: FND_LOG.STRING(g_level_unexpected,

9294: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
9295: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','assign_ar_global_variables- '|| g_error_buffer);
9296: FND_MSG_PUB.Add;
9297: IF (g_level_unexpected >= g_current_runtime_level ) THEN
9298: FND_LOG.STRING(g_level_unexpected,
9299: 'ZX.TRL.ZX_AR_EXTRACT_PKG.assign_ar_global_variables',
9300: g_error_buffer);
9301: END IF;
9302: g_retcode := 2;