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 412: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;

408: G_ACCOUNTING_STATUS VARCHAR2(30);
409: G_REPORTED_STATUS VARCHAR2(30);
410:
411: g_current_runtime_level NUMBER;
412: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
413: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
414: g_level_event CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
415: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
416: g_error_buffer VARCHAR2(200);

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

409: G_REPORTED_STATUS VARCHAR2(30);
410:
411: g_current_runtime_level NUMBER;
412: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
413: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
414: g_level_event CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
415: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
416: g_error_buffer VARCHAR2(200);
417: g_retcode NUMBER := 0;

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

410:
411: g_current_runtime_level NUMBER;
412: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
413: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
414: g_level_event CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
415: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
416: g_error_buffer VARCHAR2(200);
417: g_retcode NUMBER := 0;
418:

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

411: g_current_runtime_level NUMBER;
412: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
413: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
414: g_level_event CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
415: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
416: g_error_buffer VARCHAR2(200);
417: g_retcode NUMBER := 0;
418:
419: /*===========================================================================+

Line 444: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

440: ) IS
441:
442: 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(+)');

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 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 480: FND_LOG.STRING(g_level_unexpected,

476: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
477: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','insert_tax_data- '|| g_error_buffer);
478: FND_MSG_PUB.Add;
479: IF (g_level_unexpected >= g_current_runtime_level ) THEN
480: FND_LOG.STRING(g_level_unexpected,
481: 'ZX.TRL.ZX_EXTRACT_PKG.insert_tax_data',
482: g_error_buffer);
483: END IF;
484: P_TRL_GLOBAL_VARIABLES_REC.RETCODE := 2;

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 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 7731: FND_LOG.STRING(g_level_unexpected,

7727: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
7728: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','build_sql- '|| g_error_buffer);
7729: FND_MSG_PUB.Add;
7730: IF (g_level_unexpected >= g_current_runtime_level ) THEN
7731: FND_LOG.STRING(g_level_unexpected,
7732: 'ZX.TRL.ZX_EXTRACT_PKG.build_sql',
7733: g_error_buffer);
7734: END IF;
7735: g_retcode := 2;

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 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 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 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 8340: FND_LOG.STRING(g_level_unexpected,

8336: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
8337: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','execute_dynamic_sql_strg- '|| g_error_buffer);
8338: FND_MSG_PUB.Add;
8339: IF (g_level_unexpected >= g_current_runtime_level ) THEN
8340: FND_LOG.STRING(g_level_unexpected,
8341: 'ZX.TRL.ZX_EXTRACT_PKG.execute_dynamic_sql_strg - Numeric error',
8342: g_error_buffer);
8343: END IF;
8344: g_retcode := 2;

Line 8353: FND_LOG.STRING(g_level_unexpected,

8349: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
8350: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','execute_dynamic_sql_strg- '|| g_error_buffer);
8351: FND_MSG_PUB.Add;
8352: IF (g_level_unexpected >= g_current_runtime_level ) THEN
8353: FND_LOG.STRING(g_level_unexpected,
8354: 'ZX.TRL.ZX_EXTRACT_PKG.execute_dynamic_sql_strg-No data',
8355: g_error_buffer);
8356: END IF;
8357: g_retcode := 2;

Line 8365: FND_LOG.STRING(g_level_unexpected,

8361: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
8362: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','execute_dynamic_sql_strg- '|| g_error_buffer);
8363: FND_MSG_PUB.Add;
8364: IF (g_level_unexpected >= g_current_runtime_level ) THEN
8365: FND_LOG.STRING(g_level_unexpected,
8366: 'ZX.TRL.ZX_EXTRACT_PKG.execute_dynamic_sql_strg',
8367: g_error_buffer);
8368: END IF;
8369:

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 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 8838: FND_LOG.STRING(g_level_unexpected,

8834: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
8835: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','insert_ar_trx_info- '|| g_error_buffer);
8836: FND_MSG_PUB.Add;
8837: IF (g_level_unexpected >= g_current_runtime_level ) THEN
8838: FND_LOG.STRING(g_level_unexpected,
8839: 'ZX.TRL.ZX_EXTRACT_PKG.insert_ar_trx_info',
8840: g_error_buffer);
8841: END IF;
8842: g_retcode := 2;

Line 9068: FND_LOG.STRING(g_level_unexpected,

9064: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
9065: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','init_ar_gt_tables- '|| g_error_buffer);
9066: FND_MSG_PUB.Add;
9067: IF (g_level_unexpected >= g_current_runtime_level ) THEN
9068: FND_LOG.STRING(g_level_unexpected,
9069: 'ZX.TRL.ZX_EXTRACT_PKG.init_ar_gt_tables',
9070: g_error_buffer);
9071: END IF;
9072: g_retcode := 2;

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 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 9242: FND_LOG.STRING(g_level_unexpected,

9238: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
9239: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','assign_ar_global_variables- '|| g_error_buffer);
9240: FND_MSG_PUB.Add;
9241: IF (g_level_unexpected >= g_current_runtime_level ) THEN
9242: FND_LOG.STRING(g_level_unexpected,
9243: 'ZX.TRL.ZX_EXTRACT_PKG.assign_ar_global_variables',
9244: g_error_buffer);
9245: END IF;
9246: g_retcode := 2;