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 ZX_AR_EXTRACT_PKG

Line 1: PACKAGE BODY ZX_AR_EXTRACT_PKG AS

1: PACKAGE BODY ZX_AR_EXTRACT_PKG AS
2: /* $Header: zxrirextractpvtb.pls 120.60.12010000.3 2008/12/03 18:22:22 bibeura ship $ */
3:
4: -----------------------------------------
5: --Private Methods Declarations

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

443:
444: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
445: g_retcode := P_TRL_GLOBAL_VARIABLES_REC.RETCODE;
446: IF (g_level_procedure >= g_current_runtime_level ) THEN
447: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.insert_tax_data.BEGIN',
448: 'ZX_AR_EXTRACT_PKG: insert_tax_data(+)');
449: END IF;
450:
451: assign_ar_global_variables(

Line 448: 'ZX_AR_EXTRACT_PKG: insert_tax_data(+)');

444: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
445: g_retcode := P_TRL_GLOBAL_VARIABLES_REC.RETCODE;
446: IF (g_level_procedure >= g_current_runtime_level ) THEN
447: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.insert_tax_data.BEGIN',
448: 'ZX_AR_EXTRACT_PKG: insert_tax_data(+)');
449: END IF;
450:
451: assign_ar_global_variables(
452: P_TRL_GLOBAL_VARIABLES_REC => P_TRL_GLOBAL_VARIABLES_REC

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

464: P_TRL_GLOBAL_VARIABLES_REC.EXTRACT_REPORT_LINE_NUMBER := G_EXTRACT_REPORT_LINE_NUMBER;
465: P_TRL_GLOBAL_VARIABLES_REC.RETCODE := g_retcode;
466:
467: IF (g_level_procedure >= g_current_runtime_level ) THEN
468: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.insert_tax_data.END',
469: 'ZX_AR_EXTRACT_PKG: insert_tax_data(-)');
470: END IF;
471:
472:

Line 469: 'ZX_AR_EXTRACT_PKG: insert_tax_data(-)');

465: P_TRL_GLOBAL_VARIABLES_REC.RETCODE := g_retcode;
466:
467: IF (g_level_procedure >= g_current_runtime_level ) THEN
468: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.insert_tax_data.END',
469: 'ZX_AR_EXTRACT_PKG: insert_tax_data(-)');
470: END IF;
471:
472:
473: EXCEPTION

Line 494: | This procedure of the ZX_AR_EXTRACT_PKG, takes the input parameters |

490: | PROCEDURE |
491: | build_sql |
492: | |
493: | DESCRIPTION |
494: | This procedure of the ZX_AR_EXTRACT_PKG, takes the input parameters |
495: | and builds a dynamic SQL statement based on the parameters, and |
496: | supplies it as an output parameter. |
497: | |
498: | SCOPE - Public |

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

716: BEGIN
717:
718:
719: IF (g_level_procedure >= g_current_runtime_level ) THEN
720: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.build_sql.BEGIN',
721: 'ZX_AR_EXTRACT_PKG: build_sql(+)');
722: END IF;
723:
724: --

Line 721: 'ZX_AR_EXTRACT_PKG: build_sql(+)');

717:
718:
719: IF (g_level_procedure >= g_current_runtime_level ) THEN
720: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.build_sql.BEGIN',
721: 'ZX_AR_EXTRACT_PKG: build_sql(+)');
722: END IF;
723:
724: --
725: -- determine which table to use based on MRC sob type

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

791: p_pred_type =>'AUTO');
792:
793:
794: IF (g_level_procedure >= g_current_runtime_level ) THEN
795: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.build_sql',
796: 'After FND_MO_REPORTING_API.INITIALIZE Call : ');
797: END IF;
798:
799: -- Check with Kripa --skorrapa

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

800:
801:
802: l_fnd_mo_org_stg := FND_MO_REPORTING_API.GET_PREDICATE('ZX_DET',NULL,L_REPORTING_CONTEXT_VAL);
803: IF (g_level_procedure >= g_current_runtime_level ) THEN
804: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.build_sql',
805: 'After FND_MO_REPORTING_API.GET_PREDICATE Call = '||l_fnd_mo_org_stg);
806: END IF;
807:
808: l_internal_org_stg:= REPLACE(l_fnd_mo_org_stg,'ORG_ID','INTERNAL_ORGANIZATION_ID');

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

807:
808: l_internal_org_stg:= REPLACE(l_fnd_mo_org_stg,'ORG_ID','INTERNAL_ORGANIZATION_ID');
809:
810: IF (g_level_procedure >= g_current_runtime_level ) THEN
811: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.build_sql',
812: 'l_internal_org_stg = '||l_internal_org_stg);
813: END IF;
814:
815:

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

841: END IF;
842: END IF;
843:
844: IF (g_level_procedure >= g_current_runtime_level ) THEN
845: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.build_sql',
846: 'L_WHERE_REPORTING_CONTEXT_TRXH : '||L_WHERE_REPORTING_CONTEXT_TRXH);
847: END IF;
848:
849: --New parameter code

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

1339: L_WHERE_TRX_CLASS_ADJ_TAX := ' AND 1 = 2 ';
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: 'G_INCLUDE_AR_ADJ_TRX_CLASS : '||G_INCLUDE_AR_ADJ_TRX_CLASS);
1345: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.build_sql',
1346: 'L_WHERE_TRX_CLASS_ADJ_FINCHRG : '||L_WHERE_TRX_CLASS_ADJ_FINCHRG);
1347: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.build_sql',

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

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: 'G_INCLUDE_AR_ADJ_TRX_CLASS : '||G_INCLUDE_AR_ADJ_TRX_CLASS);
1345: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.build_sql',
1346: 'L_WHERE_TRX_CLASS_ADJ_FINCHRG : '||L_WHERE_TRX_CLASS_ADJ_FINCHRG);
1347: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.build_sql',
1348: 'L_WHERE_TRX_CLASS_ADJ_TAX : '||L_WHERE_TRX_CLASS_ADJ_TAX);
1349: END IF;

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

1343: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.build_sql',
1344: 'G_INCLUDE_AR_ADJ_TRX_CLASS : '||G_INCLUDE_AR_ADJ_TRX_CLASS);
1345: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.build_sql',
1346: 'L_WHERE_TRX_CLASS_ADJ_FINCHRG : '||L_WHERE_TRX_CLASS_ADJ_FINCHRG);
1347: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.build_sql',
1348: 'L_WHERE_TRX_CLASS_ADJ_TAX : '||L_WHERE_TRX_CLASS_ADJ_TAX);
1349: END IF;
1350:
1351: -- New paraneter code

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

1391: L_WHERE_ACCOUNTING_STATUS_BR := ' AND 1=1 ';
1392: --L_WHERE_ACCOUNTING_STATUS_CM_REC := ' AND 1 = 1 ';
1393:
1394: IF (g_level_procedure >= g_current_runtime_level ) THEN
1395: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.build_sql',
1396: 'L_WHERE_ACCOUNTING_STATUS_TRX : '||L_WHERE_ACCOUNTING_STATUS_TRX);
1397: END IF;
1398:
1399: END IF;

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

1433: L_WHERE_GL_FLEX := ' AND 1=1 ';
1434: END IF;
1435:
1436: IF (g_level_procedure >= g_current_runtime_level ) THEN
1437: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.build_sql',
1438: 'L_WHERE_GL_FLEX :'||L_WHERE_GL_FLEX);
1439: END IF;
1440:
1441:

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

1519: -- CONDITIONALLY EXECUTE
1520:
1521:
1522: IF (g_level_procedure >= g_current_runtime_level ) THEN
1523: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.build_sql',
1524: 'Dynamic SQL Statement Sarts Here:');
1525: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.build_sql',
1526: 'G_INCLUDE_AR_INV_TRX_CLASS : '||G_INCLUDE_AR_INV_TRX_CLASS);
1527: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.build_sql',

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

1521:
1522: IF (g_level_procedure >= g_current_runtime_level ) THEN
1523: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.build_sql',
1524: 'Dynamic SQL Statement Sarts Here:');
1525: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.build_sql',
1526: 'G_INCLUDE_AR_INV_TRX_CLASS : '||G_INCLUDE_AR_INV_TRX_CLASS);
1527: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.build_sql',
1528: 'G_REGISTER_TYPE : '||G_REGISTER_TYPE);
1529: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.build_sql',

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

1523: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.build_sql',
1524: 'Dynamic SQL Statement Sarts Here:');
1525: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.build_sql',
1526: 'G_INCLUDE_AR_INV_TRX_CLASS : '||G_INCLUDE_AR_INV_TRX_CLASS);
1527: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.build_sql',
1528: 'G_REGISTER_TYPE : '||G_REGISTER_TYPE);
1529: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.build_sql',
1530: 'G_SUMMARY_LEVEL : '||G_SUMMARY_LEVEL);
1531: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.build_sql',

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

1525: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.build_sql',
1526: 'G_INCLUDE_AR_INV_TRX_CLASS : '||G_INCLUDE_AR_INV_TRX_CLASS);
1527: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.build_sql',
1528: 'G_REGISTER_TYPE : '||G_REGISTER_TYPE);
1529: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.build_sql',
1530: 'G_SUMMARY_LEVEL : '||G_SUMMARY_LEVEL);
1531: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.build_sql',
1532: 'G_ACCOUNTING_STATUS : '||G_ACCOUNTING_STATUS);
1533: END IF;

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

1527: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.build_sql',
1528: 'G_REGISTER_TYPE : '||G_REGISTER_TYPE);
1529: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.build_sql',
1530: 'G_SUMMARY_LEVEL : '||G_SUMMARY_LEVEL);
1531: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.build_sql',
1532: 'G_ACCOUNTING_STATUS : '||G_ACCOUNTING_STATUS);
1533: END IF;
1534:
1535:

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

1543: IF UPPER(G_SUMMARY_LEVEL) = 'TRANSACTION' THEN
1544: IF (G_ACCOUNTING_STATUS = 'UNACCOUNTED') OR
1545: ( G_GL_DATE_LOW IS NULL AND G_GL_DATE_HIGH IS NULL) THEN
1546: IF (g_level_procedure >= g_current_runtime_level ) THEN
1547: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.build_sql',
1548: 'SQL-1 For Invoice, Credit Memo, Debit Memo: Header Level');
1549: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.build_sql',
1550: 'G_ACCOUNTING_STATUS : '||G_ACCOUNTING_STATUS);
1551: END IF;

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

1545: ( G_GL_DATE_LOW IS NULL AND G_GL_DATE_HIGH IS NULL) THEN
1546: IF (g_level_procedure >= g_current_runtime_level ) THEN
1547: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.build_sql',
1548: 'SQL-1 For Invoice, Credit Memo, Debit Memo: Header Level');
1549: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.build_sql',
1550: 'G_ACCOUNTING_STATUS : '||G_ACCOUNTING_STATUS);
1551: END IF;
1552:
1553:

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

1962: (NVL(G_ACCOUNTING_STATUS,'BOTH') = 'BOTH' AND NVL(G_INCLUDE_ACCOUNTING_SEGMENTS,'N')='Y'))
1963: OR (G_GL_DATE_LOW IS NOT NULL OR G_GL_DATE_HIGH IS NOT NULL) THEN
1964:
1965: IF (g_level_procedure >= g_current_runtime_level ) THEN
1966: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.build_sql',
1967: 'SQL-1-1 For Invoice, Credit Memo, Debit Memo: Header Level - Accounted');
1968: END IF;
1969:
1970:

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

2387: G_ACCOUNTING_STATUS <> 'ACCOUNTED') THEN
2388: -- (NVL(G_ACCOUNTING_STATUS,'BOTH') = 'BOTH' AND NVL(G_INCLUDE_ACCOUNTING_SEGMENTS,'N')='N'))
2389:
2390: IF (g_level_procedure >= g_current_runtime_level ) THEN
2391: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.build_sql',
2392: 'SQL-2 For Invoice, Credit Memo, Debit Memo: Line Level');
2393: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.build_sql',
2394: 'G_ACCOUNTING_STATUS : '||G_ACCOUNTING_STATUS);
2395: END IF;

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

2389:
2390: IF (g_level_procedure >= g_current_runtime_level ) THEN
2391: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.build_sql',
2392: 'SQL-2 For Invoice, Credit Memo, Debit Memo: Line Level');
2393: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.build_sql',
2394: 'G_ACCOUNTING_STATUS : '||G_ACCOUNTING_STATUS);
2395: END IF;
2396:
2397:

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

2836: (NVL(G_ACCOUNTING_STATUS,'BOTH') = 'BOTH' AND NVL(G_INCLUDE_ACCOUNTING_SEGMENTS,'N')='Y'))
2837: OR (G_GL_DATE_LOW IS NOT NULL OR G_GL_DATE_HIGH IS NOT NULL) THEN
2838:
2839: IF (g_level_procedure >= g_current_runtime_level ) THEN
2840: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.build_sql',
2841: 'SQL-2-1 For Invoice, Credit Memo, Debit Memo: Line Level: Accounting');
2842: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.build_sql',
2843: 'G_ACCOUNTING_STATUS : '||G_ACCOUNTING_STATUS);
2844: END IF;

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

2838:
2839: IF (g_level_procedure >= g_current_runtime_level ) THEN
2840: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.build_sql',
2841: 'SQL-2-1 For Invoice, Credit Memo, Debit Memo: Line Level: Accounting');
2842: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.build_sql',
2843: 'G_ACCOUNTING_STATUS : '||G_ACCOUNTING_STATUS);
2844: END IF;
2845:
2846:

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

3288: -- Matrix reporting is not supported at transaction distribution level
3289:
3290:
3291: IF (g_level_procedure >= g_current_runtime_level ) THEN
3292: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.build_sql',
3293: 'SQL-3 For Invoice, Credit Memo, Debit Memo: Distribution Level');
3294: END IF;
3295:
3296: L_COLUMN_LIST_AR_INV :=

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

3584: UPPER(G_SUMMARY_LEVEL) = 'TRANSACTION_LINE')
3585: THEN
3586:
3587: IF (g_level_procedure >= g_current_runtime_level ) THEN
3588: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.build_sql',
3589: 'SQL-4 For AR Applications : Header or Line Level');
3590: END IF;
3591:
3592: L_COLUMN_LIST_AR_APP :=

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

4370: ELSIF UPPER(G_SUMMARY_LEVEL) = 'TRANSACTION_DISTRIBUTION' THEN
4371:
4372: IF G_REPORT_NAME = 'ZXXVATRN' THEN
4373: IF (g_level_procedure >= g_current_runtime_level ) THEN
4374: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.build_sql',
4375: 'SQL-5 For AR Applications :Reconciliation Report: Distribution Level');
4376: END IF;
4377:
4378: L_COLUMN_LIST_AR_APP :=

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

4661: || L_WHERE_ACCOUNTING_STATUS_APP;
4662:
4663: ELSE
4664: IF (g_level_procedure >= g_current_runtime_level ) THEN
4665: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.build_sql',
4666: 'SQL-5 For AR Applications : Distribution Level');
4667: END IF;
4668:
4669: L_COLUMN_LIST_AR_APP :=

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

4974: UPPER(G_SUMMARY_LEVEL) = 'TRANSACTION_LINE')
4975: THEN
4976:
4977: IF (g_level_procedure >= g_current_runtime_level ) THEN
4978: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.build_sql',
4979: 'SQL-6 For AR Adjustments : Header or Line Level');
4980: END IF;
4981: /*
4982: L_COLUMN_LIST_AR_ADJ :=

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

5675: ELSIF UPPER(G_SUMMARY_LEVEL) = 'TRANSACTION_DISTRIBUTION' THEN
5676:
5677: IF G_REPORT_NAME = 'ZXXVATRN' THEN
5678: IF (g_level_procedure >= g_current_runtime_level ) THEN
5679: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.build_sql',
5680: 'SQL-7 For AR Adjustments - Reconciliation : Distributions Level');
5681: END IF;
5682:
5683:

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

5945: || L_WHERE_ACCOUNTING_STATUS_ADJ;
5946:
5947: ELSE
5948: IF (g_level_procedure >= g_current_runtime_level ) THEN
5949: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.build_sql',
5950: 'SQL-7 For AR Adjustments : Distributions Level');
5951: END IF;
5952:
5953:

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

6233: UPPER(G_SUMMARY_LEVEL) = 'TRANSACTION_LINE')
6234: THEN
6235:
6236: IF (g_level_procedure >= g_current_runtime_level ) THEN
6237: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.build_sql',
6238: 'SQL-8 For AR Misc Cash Receipts : Header or Line Level');
6239: END IF;
6240:
6241: L_COLUMN_LIST_AR_MISC :=

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

6506: ELSIF UPPER(G_SUMMARY_LEVEL) = 'TRANSACTION_DISTRIBUTION' THEN
6507: -- apai commented : needs to be removed AND NVL(G_TRX_CLASS,'MISC_CASH_RECEIPT') = ('MISC_CASH_RECEIPT') THEN
6508:
6509: IF (g_level_procedure >= g_current_runtime_level ) THEN
6510: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.build_sql',
6511: 'SQL-9 For AR Misc Cash Receipts : Distributions Level');
6512: END IF;
6513:
6514: L_COLUMN_LIST_AR_MISC :=

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

7024: UPPER(G_SUMMARY_LEVEL) = 'TRANSACTION_LINE')
7025: THEN
7026:
7027: IF (g_level_procedure >= g_current_runtime_level ) THEN
7028: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.build_sql',
7029: 'SQL-10 For AR Bills Receivables : Header or Line Level');
7030: END IF;
7031:
7032: L_COLUMN_LIST_AR_BR :=

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

7429: ELSIF UPPER(G_SUMMARY_LEVEL) = 'TRANSACTION_DISTRIBUTION' THEN
7430: -- apai commented : needs to be removed AND NVL(G_TRX_CLASS,'BR' ) = 'BR' THEN
7431:
7432: IF (g_level_procedure >= g_current_runtime_level ) THEN
7433: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.build_sql',
7434: 'SQL-11 For AR Bills Receivables : Distributions Level');
7435: END IF;
7436:
7437: L_COLUMN_LIST_AR_BR :=

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

7716: END IF; -- G_TRX_CLASS IS NULL
7717:
7718:
7719: IF (g_level_procedure >= g_current_runtime_level ) THEN
7720: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.build_sql.END',
7721: 'ZX_AR_EXTRACT_PKG: build_sql(-)');
7722: END IF;
7723:
7724: EXCEPTION

Line 7721: 'ZX_AR_EXTRACT_PKG: build_sql(-)');

7717:
7718:
7719: IF (g_level_procedure >= g_current_runtime_level ) THEN
7720: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.build_sql.END',
7721: 'ZX_AR_EXTRACT_PKG: build_sql(-)');
7722: END IF;
7723:
7724: EXCEPTION
7725: WHEN OTHERS THEN

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

7777: l_sql11 varchar2(3500);
7778: BEGIN
7779:
7780: IF (g_level_procedure >= g_current_runtime_level ) THEN
7781: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info.BEGIN',
7782: 'ZX_AR_EXTRACT_PKG: fetch_ar_trx_info(+)');
7783: END IF;
7784:
7785: -- Since the driving SQL statement for AR exceeds 32000 characters which

Line 7782: 'ZX_AR_EXTRACT_PKG: fetch_ar_trx_info(+)');

7778: BEGIN
7779:
7780: IF (g_level_procedure >= g_current_runtime_level ) THEN
7781: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info.BEGIN',
7782: 'ZX_AR_EXTRACT_PKG: fetch_ar_trx_info(+)');
7783: END IF;
7784:
7785: -- Since the driving SQL statement for AR exceeds 32000 characters which
7786: -- is the maximum length of varchar2 field, the query will be executed

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

7842: l_where_clause_ar_br ;
7843: -- END IF ;
7844:
7845: IF (g_level_procedure >= g_current_runtime_level ) THEN
7846: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info',
7847: 'l_sql_statement_tbl : ');
7848: END IF;
7849: /*
7850: -- l_sql1 := substr(l_sql_statement_ar_1,1,3000);

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

7849: /*
7850: -- l_sql1 := substr(l_sql_statement_ar_1,1,3000);
7851: IF (g_level_procedure >= g_current_runtime_level ) THEN
7852: l_sql1 := substr(l_sql_statement_ar_1,1,3000);
7853: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl1 : '||l_sql1);
7854: l_sql2 := substr(l_sql_statement_ar_1,3001,3000);
7855: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl2 : '||l_sql2);
7856: l_sql3 := substr(l_sql_statement_ar_1,6001,3000);
7857: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl3 : '||l_sql3);

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

7851: IF (g_level_procedure >= g_current_runtime_level ) THEN
7852: l_sql1 := substr(l_sql_statement_ar_1,1,3000);
7853: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl1 : '||l_sql1);
7854: l_sql2 := substr(l_sql_statement_ar_1,3001,3000);
7855: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl2 : '||l_sql2);
7856: l_sql3 := substr(l_sql_statement_ar_1,6001,3000);
7857: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl3 : '||l_sql3);
7858: l_sql4 := substr(l_sql_statement_ar_1,9001,3000);
7859: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl4 : '||l_sql4);

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

7853: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl1 : '||l_sql1);
7854: l_sql2 := substr(l_sql_statement_ar_1,3001,3000);
7855: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl2 : '||l_sql2);
7856: l_sql3 := substr(l_sql_statement_ar_1,6001,3000);
7857: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl3 : '||l_sql3);
7858: l_sql4 := substr(l_sql_statement_ar_1,9001,3000);
7859: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl4 : '||l_sql4);
7860: l_sql5 := substr(l_sql_statement_ar_1,12001,3000);
7861: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl5 : '||l_sql5);

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

7855: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl2 : '||l_sql2);
7856: l_sql3 := substr(l_sql_statement_ar_1,6001,3000);
7857: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl3 : '||l_sql3);
7858: l_sql4 := substr(l_sql_statement_ar_1,9001,3000);
7859: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl4 : '||l_sql4);
7860: l_sql5 := substr(l_sql_statement_ar_1,12001,3000);
7861: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl5 : '||l_sql5);
7862: l_sql6 := substr(l_sql_statement_ar_1,15001,3000);
7863: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl6 : '||l_sql6);

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

7857: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl3 : '||l_sql3);
7858: l_sql4 := substr(l_sql_statement_ar_1,9001,3000);
7859: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl4 : '||l_sql4);
7860: l_sql5 := substr(l_sql_statement_ar_1,12001,3000);
7861: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl5 : '||l_sql5);
7862: l_sql6 := substr(l_sql_statement_ar_1,15001,3000);
7863: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl6 : '||l_sql6);
7864: l_sql7 := substr(l_sql_statement_ar_1,18001,3000);
7865: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl7 : '||l_sql7);

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

7859: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl4 : '||l_sql4);
7860: l_sql5 := substr(l_sql_statement_ar_1,12001,3000);
7861: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl5 : '||l_sql5);
7862: l_sql6 := substr(l_sql_statement_ar_1,15001,3000);
7863: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl6 : '||l_sql6);
7864: l_sql7 := substr(l_sql_statement_ar_1,18001,3000);
7865: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl7 : '||l_sql7);
7866: l_sql8 := substr(l_sql_statement_ar_1,21001,3000);
7867: END IF;

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

7861: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl5 : '||l_sql5);
7862: l_sql6 := substr(l_sql_statement_ar_1,15001,3000);
7863: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl6 : '||l_sql6);
7864: l_sql7 := substr(l_sql_statement_ar_1,18001,3000);
7865: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl7 : '||l_sql7);
7866: l_sql8 := substr(l_sql_statement_ar_1,21001,3000);
7867: END IF;
7868:
7869: IF (g_level_procedure >= g_current_runtime_level ) THEN

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

7914: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl5 : '||l_sql5);
7915: l_sql6 := substr(l_sql_statement_ar_5,15001,3000);
7916: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl6 : '||l_sql6);
7917: l_sql7 := substr(l_sql_statement_ar_5,18001,3000);
7918: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl7 : '||l_sql7);
7919: l_sql8 := substr(l_sql_statement_ar_4,21001,3000);
7920: END IF;
7921: */
7922: l_sql_statement_tbl(1) := l_sql_statement_ar_1; --AR_INV

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

7933: END IF;
7934: END LOOP;
7935:
7936: IF (g_level_procedure >= g_current_runtime_level ) THEN
7937: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info.END',
7938: 'ZX_AR_EXTRACT_PKG: fetch_ar_trx_info(-)');
7939: END IF;
7940:
7941:

Line 7938: 'ZX_AR_EXTRACT_PKG: fetch_ar_trx_info(-)');

7934: END LOOP;
7935:
7936: IF (g_level_procedure >= g_current_runtime_level ) THEN
7937: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info.END',
7938: 'ZX_AR_EXTRACT_PKG: fetch_ar_trx_info(-)');
7939: END IF;
7940:
7941:
7942: END fetch_ar_trx_info;

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

7970:
7971:
7972:
7973: IF (g_level_procedure >= g_current_runtime_level ) THEN
7974: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg.BEGIN',
7975: 'ZX_AR_EXTRACT_PKG: execute_dynamic_sql_strg(+)');
7976: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg',
7977: 'OPEN zx_rep_detail_csr : ');
7978:

Line 7975: 'ZX_AR_EXTRACT_PKG: execute_dynamic_sql_strg(+)');

7971:
7972:
7973: IF (g_level_procedure >= g_current_runtime_level ) THEN
7974: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg.BEGIN',
7975: 'ZX_AR_EXTRACT_PKG: execute_dynamic_sql_strg(+)');
7976: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg',
7977: 'OPEN zx_rep_detail_csr : ');
7978:
7979: END IF;

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

7972:
7973: IF (g_level_procedure >= g_current_runtime_level ) THEN
7974: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg.BEGIN',
7975: 'ZX_AR_EXTRACT_PKG: execute_dynamic_sql_strg(+)');
7976: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg',
7977: 'OPEN zx_rep_detail_csr : ');
7978:
7979: END IF;
7980:

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

7979: END IF;
7980:
7981: IF (g_level_procedure >= g_current_runtime_level ) THEN
7982: l_sql1 := substr(p_statement,1,3000);
7983: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl1 : '||l_sql1);
7984: l_sql2 := substr(p_statement,3001,3000);
7985: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl2 : '||l_sql2);
7986: l_sql3 := substr(p_statement,6001,3000);
7987: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl3 : '||l_sql3);

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

7981: IF (g_level_procedure >= g_current_runtime_level ) THEN
7982: l_sql1 := substr(p_statement,1,3000);
7983: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl1 : '||l_sql1);
7984: l_sql2 := substr(p_statement,3001,3000);
7985: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl2 : '||l_sql2);
7986: l_sql3 := substr(p_statement,6001,3000);
7987: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl3 : '||l_sql3);
7988: l_sql4 := substr(p_statement,9001,3000);
7989: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl4 : '||l_sql4);

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

7983: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl1 : '||l_sql1);
7984: l_sql2 := substr(p_statement,3001,3000);
7985: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl2 : '||l_sql2);
7986: l_sql3 := substr(p_statement,6001,3000);
7987: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl3 : '||l_sql3);
7988: l_sql4 := substr(p_statement,9001,3000);
7989: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl4 : '||l_sql4);
7990: l_sql5 := substr(p_statement,12001,3000);
7991: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl5 : '||l_sql5);

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

7985: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl2 : '||l_sql2);
7986: l_sql3 := substr(p_statement,6001,3000);
7987: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl3 : '||l_sql3);
7988: l_sql4 := substr(p_statement,9001,3000);
7989: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl4 : '||l_sql4);
7990: l_sql5 := substr(p_statement,12001,3000);
7991: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl5 : '||l_sql5);
7992: l_sql6 := substr(p_statement,15001,3000);
7993: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl6 : '||l_sql6);

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

7987: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl3 : '||l_sql3);
7988: l_sql4 := substr(p_statement,9001,3000);
7989: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl4 : '||l_sql4);
7990: l_sql5 := substr(p_statement,12001,3000);
7991: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl5 : '||l_sql5);
7992: l_sql6 := substr(p_statement,15001,3000);
7993: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl6 : '||l_sql6);
7994: l_sql7 := substr(p_statement,18001,3000);
7995: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl7 : '||l_sql7);

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

7989: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl4 : '||l_sql4);
7990: l_sql5 := substr(p_statement,12001,3000);
7991: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl5 : '||l_sql5);
7992: l_sql6 := substr(p_statement,15001,3000);
7993: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl6 : '||l_sql6);
7994: l_sql7 := substr(p_statement,18001,3000);
7995: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl7 : '||l_sql7);
7996: l_sql8 := substr(p_statement,21001,3000);
7997: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'G_LEDGER_ID : '||to_char(G_LEDGER_ID));

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

7991: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl5 : '||l_sql5);
7992: l_sql6 := substr(p_statement,15001,3000);
7993: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl6 : '||l_sql6);
7994: l_sql7 := substr(p_statement,18001,3000);
7995: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl7 : '||l_sql7);
7996: l_sql8 := substr(p_statement,21001,3000);
7997: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'G_LEDGER_ID : '||to_char(G_LEDGER_ID));
7998: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'G_LEGAL_ENTITY_ID : '||G_LEGAL_ENTITY_ID);
7999: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'G_BATCH_NAME : '||G_BATCH_NAME);

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

7993: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl6 : '||l_sql6);
7994: l_sql7 := substr(p_statement,18001,3000);
7995: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl7 : '||l_sql7);
7996: l_sql8 := substr(p_statement,21001,3000);
7997: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'G_LEDGER_ID : '||to_char(G_LEDGER_ID));
7998: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'G_LEGAL_ENTITY_ID : '||G_LEGAL_ENTITY_ID);
7999: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'G_BATCH_NAME : '||G_BATCH_NAME);
8000: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'G_TRX_NUMBER_LOW : '||G_TRX_NUMBER_LOW);
8001: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'G_TRX_NUMBER_HIGH : '||G_TRX_NUMBER_HIGH);

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

7994: l_sql7 := substr(p_statement,18001,3000);
7995: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl7 : '||l_sql7);
7996: l_sql8 := substr(p_statement,21001,3000);
7997: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'G_LEDGER_ID : '||to_char(G_LEDGER_ID));
7998: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'G_LEGAL_ENTITY_ID : '||G_LEGAL_ENTITY_ID);
7999: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'G_BATCH_NAME : '||G_BATCH_NAME);
8000: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'G_TRX_NUMBER_LOW : '||G_TRX_NUMBER_LOW);
8001: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'G_TRX_NUMBER_HIGH : '||G_TRX_NUMBER_HIGH);
8002: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'G_TRX_DATE_LOW : '||G_TRX_DATE_LOW);

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

7995: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'l_sql_statement_tbl7 : '||l_sql7);
7996: l_sql8 := substr(p_statement,21001,3000);
7997: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'G_LEDGER_ID : '||to_char(G_LEDGER_ID));
7998: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'G_LEGAL_ENTITY_ID : '||G_LEGAL_ENTITY_ID);
7999: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'G_BATCH_NAME : '||G_BATCH_NAME);
8000: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'G_TRX_NUMBER_LOW : '||G_TRX_NUMBER_LOW);
8001: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'G_TRX_NUMBER_HIGH : '||G_TRX_NUMBER_HIGH);
8002: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'G_TRX_DATE_LOW : '||G_TRX_DATE_LOW);
8003: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'G_TRX_DATE_HIGH : '||G_TRX_DATE_HIGH);

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

7996: l_sql8 := substr(p_statement,21001,3000);
7997: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'G_LEDGER_ID : '||to_char(G_LEDGER_ID));
7998: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'G_LEGAL_ENTITY_ID : '||G_LEGAL_ENTITY_ID);
7999: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'G_BATCH_NAME : '||G_BATCH_NAME);
8000: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'G_TRX_NUMBER_LOW : '||G_TRX_NUMBER_LOW);
8001: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'G_TRX_NUMBER_HIGH : '||G_TRX_NUMBER_HIGH);
8002: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'G_TRX_DATE_LOW : '||G_TRX_DATE_LOW);
8003: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'G_TRX_DATE_HIGH : '||G_TRX_DATE_HIGH);
8004: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'G_GL_DATE_LOW : '||G_GL_DATE_LOW);

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

7997: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'G_LEDGER_ID : '||to_char(G_LEDGER_ID));
7998: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'G_LEGAL_ENTITY_ID : '||G_LEGAL_ENTITY_ID);
7999: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'G_BATCH_NAME : '||G_BATCH_NAME);
8000: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'G_TRX_NUMBER_LOW : '||G_TRX_NUMBER_LOW);
8001: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'G_TRX_NUMBER_HIGH : '||G_TRX_NUMBER_HIGH);
8002: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'G_TRX_DATE_LOW : '||G_TRX_DATE_LOW);
8003: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'G_TRX_DATE_HIGH : '||G_TRX_DATE_HIGH);
8004: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'G_GL_DATE_LOW : '||G_GL_DATE_LOW);
8005: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'G_GL_DATE_HIGH : '||G_GL_DATE_HIGH);

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

7998: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'G_LEGAL_ENTITY_ID : '||G_LEGAL_ENTITY_ID);
7999: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'G_BATCH_NAME : '||G_BATCH_NAME);
8000: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'G_TRX_NUMBER_LOW : '||G_TRX_NUMBER_LOW);
8001: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'G_TRX_NUMBER_HIGH : '||G_TRX_NUMBER_HIGH);
8002: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'G_TRX_DATE_LOW : '||G_TRX_DATE_LOW);
8003: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'G_TRX_DATE_HIGH : '||G_TRX_DATE_HIGH);
8004: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'G_GL_DATE_LOW : '||G_GL_DATE_LOW);
8005: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'G_GL_DATE_HIGH : '||G_GL_DATE_HIGH);
8006: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'G_DOCUMENT_SUB_TYPE : '||G_DOCUMENT_SUB_TYPE);

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

7999: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'G_BATCH_NAME : '||G_BATCH_NAME);
8000: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'G_TRX_NUMBER_LOW : '||G_TRX_NUMBER_LOW);
8001: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'G_TRX_NUMBER_HIGH : '||G_TRX_NUMBER_HIGH);
8002: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'G_TRX_DATE_LOW : '||G_TRX_DATE_LOW);
8003: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'G_TRX_DATE_HIGH : '||G_TRX_DATE_HIGH);
8004: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'G_GL_DATE_LOW : '||G_GL_DATE_LOW);
8005: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'G_GL_DATE_HIGH : '||G_GL_DATE_HIGH);
8006: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'G_DOCUMENT_SUB_TYPE : '||G_DOCUMENT_SUB_TYPE);
8007:

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

8000: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'G_TRX_NUMBER_LOW : '||G_TRX_NUMBER_LOW);
8001: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'G_TRX_NUMBER_HIGH : '||G_TRX_NUMBER_HIGH);
8002: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'G_TRX_DATE_LOW : '||G_TRX_DATE_LOW);
8003: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'G_TRX_DATE_HIGH : '||G_TRX_DATE_HIGH);
8004: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'G_GL_DATE_LOW : '||G_GL_DATE_LOW);
8005: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'G_GL_DATE_HIGH : '||G_GL_DATE_HIGH);
8006: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'G_DOCUMENT_SUB_TYPE : '||G_DOCUMENT_SUB_TYPE);
8007:
8008: END IF;

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

8001: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'G_TRX_NUMBER_HIGH : '||G_TRX_NUMBER_HIGH);
8002: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'G_TRX_DATE_LOW : '||G_TRX_DATE_LOW);
8003: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'G_TRX_DATE_HIGH : '||G_TRX_DATE_HIGH);
8004: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'G_GL_DATE_LOW : '||G_GL_DATE_LOW);
8005: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'G_GL_DATE_HIGH : '||G_GL_DATE_HIGH);
8006: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'G_DOCUMENT_SUB_TYPE : '||G_DOCUMENT_SUB_TYPE);
8007:
8008: END IF;
8009:

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

8002: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'G_TRX_DATE_LOW : '||G_TRX_DATE_LOW);
8003: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'G_TRX_DATE_HIGH : '||G_TRX_DATE_HIGH);
8004: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'G_GL_DATE_LOW : '||G_GL_DATE_LOW);
8005: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'G_GL_DATE_HIGH : '||G_GL_DATE_HIGH);
8006: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.fetch_ar_trx_info SQL', 'G_DOCUMENT_SUB_TYPE : '||G_DOCUMENT_SUB_TYPE);
8007:
8008: END IF;
8009:
8010:

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

8048: G_EXCISE_TAX;
8049:
8050:
8051: IF (g_level_procedure >= g_current_runtime_level ) THEN
8052: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg',
8053: 'After Using Clause of zx_rep_detail_csr : ');
8054:
8055: END IF;
8056: IF zx_rep_detail_csr%NOTFOUND THEN

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

8055: END IF;
8056: IF zx_rep_detail_csr%NOTFOUND THEN
8057:
8058: IF (g_level_procedure >= g_current_runtime_level ) THEN
8059: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg',
8060: 'End of fetch zx_rep_detail_csr : ');
8061:
8062: END IF;
8063: END If;

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

8076:
8077: -- insert when fetch up to 1000 rows
8078: --
8079: IF (g_level_procedure >= g_current_runtime_level ) THEN
8080: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg',
8081: 'FETCH zx_rep_detail_csr : ');
8082: END IF;
8083:
8084: LOOP

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

8279:
8280:
8281: IF zx_rep_detail_csr%NOTFOUND THEN
8282: IF (g_level_procedure >= g_current_runtime_level ) THEN
8283: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg',
8284: 'End of FETCH zx_rep_detail_csr : ');
8285: END IF;
8286: END IF;
8287: IF zx_rep_detail_csr%FOUND THEN

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

8317: END LOOP;
8318:
8319: IF total_rec = 0 THEN
8320: IF (g_level_procedure >= g_current_runtime_level ) THEN
8321: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.insert_ar_trx_info',
8322: 'No Data found for the product AR (OR) Verify Parameters');
8323: g_retcode := 2;
8324: END IF;
8325: END IF;

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

8325: END IF;
8326:
8327:
8328: IF (g_level_procedure >= g_current_runtime_level ) THEN
8329: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg.END',
8330: 'ZX_AR_EXTRACT_PKG: execute_dynamic_sql_strg(-)');
8331: END IF;
8332:
8333: EXCEPTION

Line 8330: 'ZX_AR_EXTRACT_PKG: execute_dynamic_sql_strg(-)');

8326:
8327:
8328: IF (g_level_procedure >= g_current_runtime_level ) THEN
8329: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg.END',
8330: 'ZX_AR_EXTRACT_PKG: execute_dynamic_sql_strg(-)');
8331: END IF;
8332:
8333: EXCEPTION
8334: WHEN VALUE_ERROR THEN

Line 8381: | This procedure inserts AR data into ZX_AR_EXTRACT_PKG_SUB_ITF table |

8377: | insert_ar_trx_info |
8378: | name changed from INSERT_AR_SUB_ITF |
8379: | (rewrite from INSERT_SQL_AR) |
8380: | DESCRIPTION |
8381: | This procedure inserts AR data into ZX_AR_EXTRACT_PKG_SUB_ITF table |
8382: | |
8383: | SCOPE - Private |
8384: | |
8385: | NOTES |

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

8397:
8398: BEGIN
8399:
8400: IF (g_level_procedure >= g_current_runtime_level ) THEN
8401: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.insert_ar_trx_info.BEGIN',
8402: 'ZX_AR_EXTRACT_PKG: insert_ar_trx_info(+)');
8403: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.insert_ar_trx_info',
8404: 'Rows fetched : '||to_char(GT_LEDGER_ID.COUNT));
8405: END IF;

Line 8402: 'ZX_AR_EXTRACT_PKG: insert_ar_trx_info(+)');

8398: BEGIN
8399:
8400: IF (g_level_procedure >= g_current_runtime_level ) THEN
8401: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.insert_ar_trx_info.BEGIN',
8402: 'ZX_AR_EXTRACT_PKG: insert_ar_trx_info(+)');
8403: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.insert_ar_trx_info',
8404: 'Rows fetched : '||to_char(GT_LEDGER_ID.COUNT));
8405: END IF;
8406:

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

8399:
8400: IF (g_level_procedure >= g_current_runtime_level ) THEN
8401: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.insert_ar_trx_info.BEGIN',
8402: 'ZX_AR_EXTRACT_PKG: insert_ar_trx_info(+)');
8403: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.insert_ar_trx_info',
8404: 'Rows fetched : '||to_char(GT_LEDGER_ID.COUNT));
8405: END IF;
8406:
8407: l_count := NVL(GT_LEDGER_ID.COUNT, 0);

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

8821: GT_OFFSET_TAX_RATE(i),
8822: GT_OFFSET_FLAG(i));
8823:
8824: IF (g_level_procedure >= g_current_runtime_level ) THEN
8825: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.insert_ar_trx_info',
8826: 'Number of AR rows successfully inserted = '||TO_CHAR(NVL(GT_LEDGER_ID.COUNT, 0)));
8827: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.insert_ar_trx_info.END',
8828: 'ZX_AR_EXTRACT_PKG: insert_ar_trx_info(-)');
8829: END IF;

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

8823:
8824: IF (g_level_procedure >= g_current_runtime_level ) THEN
8825: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.insert_ar_trx_info',
8826: 'Number of AR rows successfully inserted = '||TO_CHAR(NVL(GT_LEDGER_ID.COUNT, 0)));
8827: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.insert_ar_trx_info.END',
8828: 'ZX_AR_EXTRACT_PKG: insert_ar_trx_info(-)');
8829: END IF;
8830:
8831: EXCEPTION

Line 8828: 'ZX_AR_EXTRACT_PKG: insert_ar_trx_info(-)');

8824: IF (g_level_procedure >= g_current_runtime_level ) THEN
8825: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.insert_ar_trx_info',
8826: 'Number of AR rows successfully inserted = '||TO_CHAR(NVL(GT_LEDGER_ID.COUNT, 0)));
8827: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.insert_ar_trx_info.END',
8828: 'ZX_AR_EXTRACT_PKG: insert_ar_trx_info(-)');
8829: END IF;
8830:
8831: EXCEPTION
8832: WHEN OTHERS THEN

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

9099:
9100:
9101:
9102: IF (g_level_procedure >= g_current_runtime_level ) THEN
9103: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.assign_ar_global_variables.BEGIN',
9104: 'ZX_AR_EXTRACT_PKG:assign_ar_global_variables(+)');
9105: END IF;
9106:
9107: G_REPORTING_LEVEL := P_TRL_GLOBAL_VARIABLES_REC.REPORTING_LEVEL;

Line 9104: 'ZX_AR_EXTRACT_PKG:assign_ar_global_variables(+)');

9100:
9101:
9102: IF (g_level_procedure >= g_current_runtime_level ) THEN
9103: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.assign_ar_global_variables.BEGIN',
9104: 'ZX_AR_EXTRACT_PKG:assign_ar_global_variables(+)');
9105: END IF;
9106:
9107: G_REPORTING_LEVEL := P_TRL_GLOBAL_VARIABLES_REC.REPORTING_LEVEL;
9108: G_REPORTING_CONTEXT := P_TRL_GLOBAL_VARIABLES_REC.REPORTING_CONTEXT;

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

9215: G_EXTRACT_REPORT_LINE_NUMBER := 1;
9216: G_TRX_CLASS := NULL;
9217:
9218: IF (g_level_procedure >= g_current_runtime_level ) THEN
9219: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.build_sql',
9220: 'Getting the rep_context_id ');
9221: END IF ;
9222:
9223: --G_REP_CONTEXT_ID := ZX_EXTRACT_PKG.GET_REP_CONTEXT_ID(P_TRL_GLOBAL_VARIABLES_REC.LEGAL_ENTITY_ID,

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

9223: --G_REP_CONTEXT_ID := ZX_EXTRACT_PKG.GET_REP_CONTEXT_ID(P_TRL_GLOBAL_VARIABLES_REC.LEGAL_ENTITY_ID,
9224: -- P_TRL_GLOBAL_VARIABLES_REC.request_id);
9225:
9226: IF (g_level_procedure >= g_current_runtime_level ) THEN
9227: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.build_sql',
9228: ' G_REP_CONTEXT_ID fetched is : '||G_REP_CONTEXT_ID);
9229: END IF ;
9230:
9231: IF (g_level_procedure >= g_current_runtime_level ) THEN

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

9228: ' G_REP_CONTEXT_ID fetched is : '||G_REP_CONTEXT_ID);
9229: END IF ;
9230:
9231: IF (g_level_procedure >= g_current_runtime_level ) THEN
9232: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.assign_ar_global_variables.END',
9233: 'ZX_AR_EXTRACT_PKG:assign_ar_global_variables(-)');
9234: END IF;
9235: EXCEPTION
9236: WHEN OTHERS THEN

Line 9233: 'ZX_AR_EXTRACT_PKG:assign_ar_global_variables(-)');

9229: END IF ;
9230:
9231: IF (g_level_procedure >= g_current_runtime_level ) THEN
9232: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.assign_ar_global_variables.END',
9233: 'ZX_AR_EXTRACT_PKG:assign_ar_global_variables(-)');
9234: END IF;
9235: EXCEPTION
9236: WHEN OTHERS THEN
9237: g_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);

Line 9250: END ZX_AR_EXTRACT_PKG;

9246: g_retcode := 2;
9247:
9248: END assign_ar_global_variables;
9249:
9250: END ZX_AR_EXTRACT_PKG;