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

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

450: G_TRX_CLASS VARCHAR2(30);
451: G_CHART_OF_ACCOUNTS_ID number;
452:
453: g_current_runtime_level NUMBER;
454: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
455: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
456: g_level_event CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
457: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
458: g_error_buffer VARCHAR2(200);

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

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

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

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

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

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

Line 486: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

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

Line 489: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.INSERT_TAX_DATA.BEGIN',

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

Line 508: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.INSERT_TAX_DATA.END',

504: -- assign the output global variable
505: P_TRL_GLOBAL_VARIABLES_REC.EXTRACT_REPORT_LINE_NUMBER := G_EXTRACT_REPORT_LINE_NUMBER;
506:
507: IF (g_level_procedure >= g_current_runtime_level ) THEN
508: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.INSERT_TAX_DATA.END',
509: 'ZX_AR_ACTG_EXTRACT_PKG: INSERT_TAX_DATA(-)');
510: END IF;
511:
512:

Line 520: FND_LOG.STRING(g_level_unexpected,

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

Line 739: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.BUILD_SQL.BEGIN',

735: BEGIN
736:
737:
738: IF (g_level_procedure >= g_current_runtime_level ) THEN
739: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.BUILD_SQL.BEGIN',
740: 'ZX_AR_ACTG_EXTRACT_PKG: BUILD_SQL(+)');
741: END IF;
742:
743: --

Line 814: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.BUILD_SQL',

810: p_pred_type =>'AUTO');
811:
812:
813: IF (g_level_procedure >= g_current_runtime_level ) THEN
814: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.BUILD_SQL',
815: 'After FND_MO_REPORTING_API.INITIALIZE Call : ');
816: END IF;
817:
818: -- Check with Kripa --skorrapa

Line 823: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.BUILD_SQL',

819:
820:
821: l_fnd_mo_org_stg := FND_MO_REPORTING_API.GET_PREDICATE('ZX_DET',NULL,L_REPORTING_CONTEXT_VAL);
822: IF (g_level_procedure >= g_current_runtime_level ) THEN
823: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.BUILD_SQL',
824: 'After FND_MO_REPORTING_API.GET_PREDICATE Call = '||l_fnd_mo_org_stg);
825: END IF;
826:
827: l_internal_org_stg:= REPLACE(l_fnd_mo_org_stg,'ORG_ID','INTERNAL_ORGANIZATION_ID');

Line 830: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.BUILD_SQL',

826:
827: l_internal_org_stg:= REPLACE(l_fnd_mo_org_stg,'ORG_ID','INTERNAL_ORGANIZATION_ID');
828:
829: IF (g_level_procedure >= g_current_runtime_level ) THEN
830: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.BUILD_SQL',
831: 'l_internal_org_stg = '||l_internal_org_stg);
832: END IF;
833:
834:

Line 855: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.BUILD_SQL',

851: FND_MO_REPORTING_API.GET_PREDICATE('TH',NULL,L_REPORTING_CONTEXT_VAL);
852: END IF;
853:
854: IF (g_level_procedure >= g_current_runtime_level ) THEN
855: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.BUILD_SQL',
856: 'L_WHERE_REPORTING_CONTEXT_TRXH : '||L_WHERE_REPORTING_CONTEXT_TRXH);
857: END IF;
858:
859: --New parameter code

Line 1315: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.BUILD_SQL',

1311: -- Invoices, On account credit and debit memos:
1312: -- CONDITIONALLY EXECUTE
1313:
1314: IF (g_level_procedure >= g_current_runtime_level ) THEN
1315: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.BUILD_SQL',
1316: 'Dynamic SQL Statement Sarts Here:');
1317: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.BUILD_SQL',
1318: 'G_INCLUDE_AR_INV_TRX_CLASS : '||G_INCLUDE_AR_INV_TRX_CLASS);
1319: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.BUILD_SQL',

Line 1317: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.BUILD_SQL',

1313:
1314: IF (g_level_procedure >= g_current_runtime_level ) THEN
1315: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.BUILD_SQL',
1316: 'Dynamic SQL Statement Sarts Here:');
1317: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.BUILD_SQL',
1318: 'G_INCLUDE_AR_INV_TRX_CLASS : '||G_INCLUDE_AR_INV_TRX_CLASS);
1319: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.BUILD_SQL',
1320: 'G_REGISTER_TYPE : '||G_REGISTER_TYPE);
1321: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.BUILD_SQL',

Line 1319: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.BUILD_SQL',

1315: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.BUILD_SQL',
1316: 'Dynamic SQL Statement Sarts Here:');
1317: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.BUILD_SQL',
1318: 'G_INCLUDE_AR_INV_TRX_CLASS : '||G_INCLUDE_AR_INV_TRX_CLASS);
1319: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.BUILD_SQL',
1320: 'G_REGISTER_TYPE : '||G_REGISTER_TYPE);
1321: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.BUILD_SQL',
1322: 'G_SUMMARY_LEVEL : '||G_SUMMARY_LEVEL);
1323: END IF;

Line 1321: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.BUILD_SQL',

1317: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.BUILD_SQL',
1318: 'G_INCLUDE_AR_INV_TRX_CLASS : '||G_INCLUDE_AR_INV_TRX_CLASS);
1319: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.BUILD_SQL',
1320: 'G_REGISTER_TYPE : '||G_REGISTER_TYPE);
1321: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.BUILD_SQL',
1322: 'G_SUMMARY_LEVEL : '||G_SUMMARY_LEVEL);
1323: END IF;
1324:
1325:

Line 1336: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.BUILD_SQL',

1332: -- THEN
1333: IF UPPER(G_SUMMARY_LEVEL) = 'TRANSACTION' THEN
1334:
1335: IF (g_level_procedure >= g_current_runtime_level ) THEN
1336: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.BUILD_SQL',
1337: 'SQL-1 For Invoice, Credit Memo, Debit Memo: Header Level');
1338: END IF;
1339:
1340: L_COLUMN_LIST_AR_INV :=

Line 1776: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.BUILD_SQL',

1772: ELSIF UPPER(G_SUMMARY_LEVEL) = 'TRANSACTION_LINE' THEN
1773: -- apai commented : needs to be removed AND NVL(G_TRX_CLASS,'INV') IN ('INV','CM','DM') THEN
1774:
1775: IF (g_level_procedure >= g_current_runtime_level ) THEN
1776: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.BUILD_SQL',
1777: 'SQL-2 For Invoice, Credit Memo, Debit Memo: Line Level');
1778: END IF;
1779:
1780:

Line 2243: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.BUILD_SQL',

2239: -- Matrix reporting is not supported at transaction distribution level
2240:
2241:
2242: IF (g_level_procedure >= g_current_runtime_level ) THEN
2243: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.BUILD_SQL',
2244: 'SQL-3 For Invoice, Credit Memo, Debit Memo: Distribution Level');
2245: END IF;
2246:
2247: L_COLUMN_LIST_AR_INV :=

Line 2553: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.BUILD_SQL',

2549: UPPER(G_SUMMARY_LEVEL) = 'TRANSACTION_LINE')
2550: THEN
2551:
2552: IF (g_level_procedure >= g_current_runtime_level ) THEN
2553: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.BUILD_SQL',
2554: 'SQL-4 For AR Applications : Header or Line Level');
2555: END IF;
2556:
2557: L_COLUMN_LIST_AR_APP :=

Line 3026: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.BUILD_SQL',

3022:
3023: ELSIF UPPER(G_SUMMARY_LEVEL) = 'TRANSACTION_DISTRIBUTION' THEN
3024:
3025: IF (g_level_procedure >= g_current_runtime_level ) THEN
3026: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.BUILD_SQL',
3027: 'SQL-5 For AR Applications : Distribution Level');
3028: END IF;
3029:
3030: L_COLUMN_LIST_AR_APP :=

Line 3374: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.BUILD_SQL',

3370: UPPER(G_SUMMARY_LEVEL) = 'TRANSACTION_LINE')
3371: THEN
3372:
3373: IF (g_level_procedure >= g_current_runtime_level ) THEN
3374: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.BUILD_SQL',
3375: 'SQL-6 For AR Adjustments : Header or Line Level');
3376: END IF;
3377:
3378: L_COLUMN_LIST_AR_ADJ :=

Line 3830: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.BUILD_SQL',

3826: -- Matrix reporting is not supported at distribution level.
3827:
3828:
3829: IF (g_level_procedure >= g_current_runtime_level ) THEN
3830: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.BUILD_SQL',
3831: 'SQL-7 For AR Adjustments : Distributions Level');
3832: END IF;
3833:
3834:

Line 4156: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.BUILD_SQL',

4152: UPPER(G_SUMMARY_LEVEL) = 'TRANSACTION_LINE')
4153: THEN
4154:
4155: IF (g_level_procedure >= g_current_runtime_level ) THEN
4156: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.BUILD_SQL',
4157: 'SQL-8 For AR Misc Cash Receipts : Header or Line Level');
4158: END IF;
4159:
4160: L_COLUMN_LIST_AR_MISC :=

Line 4441: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.BUILD_SQL',

4437: ELSIF UPPER(G_SUMMARY_LEVEL) = 'TRANSACTION_DISTRIBUTION' THEN
4438: -- apai commented : needs to be removed AND NVL(G_TRX_CLASS,'MISC_CASH_RECEIPT') = ('MISC_CASH_RECEIPT') THEN
4439:
4440: IF (g_level_procedure >= g_current_runtime_level ) THEN
4441: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.BUILD_SQL',
4442: 'SQL-9 For AR Misc Cash Receipts : Distributions Level');
4443: END IF;
4444:
4445:

Line 4739: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.BUILD_SQL',

4735: UPPER(G_SUMMARY_LEVEL) = 'TRANSACTION_LINE')
4736: THEN
4737:
4738: IF (g_level_procedure >= g_current_runtime_level ) THEN
4739: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.BUILD_SQL',
4740: 'SQL-10 For AR Bills Receivables : Header or Line Level');
4741: END IF;
4742:
4743: L_COLUMN_LIST_AR_BR :=

Line 5183: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.BUILD_SQL',

5179: ELSIF UPPER(G_SUMMARY_LEVEL) = 'TRANSACTION_DISTRIBUTION' THEN
5180: -- apai commented : needs to be removed AND NVL(G_TRX_CLASS,'BR' ) = 'BR' THEN
5181:
5182: IF (g_level_procedure >= g_current_runtime_level ) THEN
5183: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.BUILD_SQL',
5184: 'SQL-11 For AR Bills Receivables : Distributions Level');
5185: END IF;
5186:
5187: L_COLUMN_LIST_AR_BR :=

Line 5490: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.BUILD_SQL.END',

5486: END IF; -- G_TRX_CLASS IS NULL
5487:
5488:
5489: IF (g_level_procedure >= g_current_runtime_level ) THEN
5490: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.BUILD_SQL.END',
5491: 'ZX_AR_ACTG_EXTRACT_PKG: BUILD_SQL(-)');
5492: END IF;
5493:
5494: EXCEPTION

Line 5501: FND_LOG.STRING(g_level_unexpected,

5497: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
5498: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','BUILD_SQL- '|| g_error_buffer);
5499: FND_MSG_PUB.Add;
5500: IF (g_level_unexpected >= g_current_runtime_level ) THEN
5501: FND_LOG.STRING(g_level_unexpected,
5502: 'ZX.TRL.ZX_EXTRACT_PKG.BUILD_SQL',
5503: g_error_buffer);
5504: END IF;
5505: g_retcode := 2;

Line 5551: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO.BEGIN',

5547: l_sql11 varchar2(3500);
5548: BEGIN
5549:
5550: IF (g_level_procedure >= g_current_runtime_level ) THEN
5551: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO.BEGIN',
5552: 'ZX_AR_ACTG_EXTRACT_PKG: FETCH_AR_TRX_INFO(+)');
5553: END IF;
5554:
5555: -- Since the driving SQL statement for AR exceeds 32000 characters which

Line 5616: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO',

5612: l_where_clause_ar_br ;
5613: -- END IF ;
5614:
5615: IF (g_level_procedure >= g_current_runtime_level ) THEN
5616: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO',
5617: 'l_sql_statement_tbl : ');
5618: END IF;
5619: /*
5620: -- l_sql1 := substr(l_sql_statement_ar_1,1,3000);

Line 5623: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'l_sql_statement_tbl1 : '||l_sql1);

5619: /*
5620: -- l_sql1 := substr(l_sql_statement_ar_1,1,3000);
5621: IF (g_level_procedure >= g_current_runtime_level ) THEN
5622: l_sql1 := substr(l_sql_statement_ar_1,1,3000);
5623: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'l_sql_statement_tbl1 : '||l_sql1);
5624: l_sql2 := substr(l_sql_statement_ar_1,3001,3000);
5625: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'l_sql_statement_tbl2 : '||l_sql2);
5626: l_sql3 := substr(l_sql_statement_ar_1,6001,3000);
5627: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'l_sql_statement_tbl3 : '||l_sql3);

Line 5625: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'l_sql_statement_tbl2 : '||l_sql2);

5621: IF (g_level_procedure >= g_current_runtime_level ) THEN
5622: l_sql1 := substr(l_sql_statement_ar_1,1,3000);
5623: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'l_sql_statement_tbl1 : '||l_sql1);
5624: l_sql2 := substr(l_sql_statement_ar_1,3001,3000);
5625: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'l_sql_statement_tbl2 : '||l_sql2);
5626: l_sql3 := substr(l_sql_statement_ar_1,6001,3000);
5627: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'l_sql_statement_tbl3 : '||l_sql3);
5628: l_sql4 := substr(l_sql_statement_ar_1,9001,3000);
5629: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'l_sql_statement_tbl4 : '||l_sql4);

Line 5627: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'l_sql_statement_tbl3 : '||l_sql3);

5623: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'l_sql_statement_tbl1 : '||l_sql1);
5624: l_sql2 := substr(l_sql_statement_ar_1,3001,3000);
5625: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'l_sql_statement_tbl2 : '||l_sql2);
5626: l_sql3 := substr(l_sql_statement_ar_1,6001,3000);
5627: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'l_sql_statement_tbl3 : '||l_sql3);
5628: l_sql4 := substr(l_sql_statement_ar_1,9001,3000);
5629: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'l_sql_statement_tbl4 : '||l_sql4);
5630: l_sql5 := substr(l_sql_statement_ar_1,12001,3000);
5631: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'l_sql_statement_tbl5 : '||l_sql5);

Line 5629: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'l_sql_statement_tbl4 : '||l_sql4);

5625: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'l_sql_statement_tbl2 : '||l_sql2);
5626: l_sql3 := substr(l_sql_statement_ar_1,6001,3000);
5627: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'l_sql_statement_tbl3 : '||l_sql3);
5628: l_sql4 := substr(l_sql_statement_ar_1,9001,3000);
5629: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'l_sql_statement_tbl4 : '||l_sql4);
5630: l_sql5 := substr(l_sql_statement_ar_1,12001,3000);
5631: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'l_sql_statement_tbl5 : '||l_sql5);
5632: l_sql6 := substr(l_sql_statement_ar_1,15001,3000);
5633: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'l_sql_statement_tbl6 : '||l_sql6);

Line 5631: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'l_sql_statement_tbl5 : '||l_sql5);

5627: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'l_sql_statement_tbl3 : '||l_sql3);
5628: l_sql4 := substr(l_sql_statement_ar_1,9001,3000);
5629: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'l_sql_statement_tbl4 : '||l_sql4);
5630: l_sql5 := substr(l_sql_statement_ar_1,12001,3000);
5631: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'l_sql_statement_tbl5 : '||l_sql5);
5632: l_sql6 := substr(l_sql_statement_ar_1,15001,3000);
5633: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'l_sql_statement_tbl6 : '||l_sql6);
5634: l_sql7 := substr(l_sql_statement_ar_1,18001,3000);
5635: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'l_sql_statement_tbl7 : '||l_sql7);

Line 5633: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'l_sql_statement_tbl6 : '||l_sql6);

5629: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'l_sql_statement_tbl4 : '||l_sql4);
5630: l_sql5 := substr(l_sql_statement_ar_1,12001,3000);
5631: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'l_sql_statement_tbl5 : '||l_sql5);
5632: l_sql6 := substr(l_sql_statement_ar_1,15001,3000);
5633: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'l_sql_statement_tbl6 : '||l_sql6);
5634: l_sql7 := substr(l_sql_statement_ar_1,18001,3000);
5635: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'l_sql_statement_tbl7 : '||l_sql7);
5636: l_sql8 := substr(l_sql_statement_ar_1,21001,3000);
5637: END IF;

Line 5635: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'l_sql_statement_tbl7 : '||l_sql7);

5631: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'l_sql_statement_tbl5 : '||l_sql5);
5632: l_sql6 := substr(l_sql_statement_ar_1,15001,3000);
5633: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'l_sql_statement_tbl6 : '||l_sql6);
5634: l_sql7 := substr(l_sql_statement_ar_1,18001,3000);
5635: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'l_sql_statement_tbl7 : '||l_sql7);
5636: l_sql8 := substr(l_sql_statement_ar_1,21001,3000);
5637: END IF;
5638:
5639: IF (g_level_procedure >= g_current_runtime_level ) THEN

Line 5641: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'l_sql_statement_tbl1 : '||l_sql1);

5637: END IF;
5638:
5639: IF (g_level_procedure >= g_current_runtime_level ) THEN
5640: l_sql1 := substr(l_sql_statement_ar_3,1,3000);
5641: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'l_sql_statement_tbl1 : '||l_sql1);
5642: l_sql2 := substr(l_sql_statement_ar_3,3001,3000);
5643: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'l_sql_statement_tbl2 : '||l_sql2);
5644: l_sql3 := substr(l_sql_statement_ar_3,6001,3000);
5645: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'l_sql_statement_tbl3 : '||l_sql3);

Line 5643: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'l_sql_statement_tbl2 : '||l_sql2);

5639: IF (g_level_procedure >= g_current_runtime_level ) THEN
5640: l_sql1 := substr(l_sql_statement_ar_3,1,3000);
5641: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'l_sql_statement_tbl1 : '||l_sql1);
5642: l_sql2 := substr(l_sql_statement_ar_3,3001,3000);
5643: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'l_sql_statement_tbl2 : '||l_sql2);
5644: l_sql3 := substr(l_sql_statement_ar_3,6001,3000);
5645: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'l_sql_statement_tbl3 : '||l_sql3);
5646: l_sql4 := substr(l_sql_statement_ar_3,9001,3000);
5647: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'l_sql_statement_tbl4 : '||l_sql4);

Line 5645: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'l_sql_statement_tbl3 : '||l_sql3);

5641: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'l_sql_statement_tbl1 : '||l_sql1);
5642: l_sql2 := substr(l_sql_statement_ar_3,3001,3000);
5643: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'l_sql_statement_tbl2 : '||l_sql2);
5644: l_sql3 := substr(l_sql_statement_ar_3,6001,3000);
5645: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'l_sql_statement_tbl3 : '||l_sql3);
5646: l_sql4 := substr(l_sql_statement_ar_3,9001,3000);
5647: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'l_sql_statement_tbl4 : '||l_sql4);
5648: l_sql5 := substr(l_sql_statement_ar_3,12001,3000);
5649: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'l_sql_statement_tbl5 : '||l_sql5);

Line 5647: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'l_sql_statement_tbl4 : '||l_sql4);

5643: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'l_sql_statement_tbl2 : '||l_sql2);
5644: l_sql3 := substr(l_sql_statement_ar_3,6001,3000);
5645: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'l_sql_statement_tbl3 : '||l_sql3);
5646: l_sql4 := substr(l_sql_statement_ar_3,9001,3000);
5647: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'l_sql_statement_tbl4 : '||l_sql4);
5648: l_sql5 := substr(l_sql_statement_ar_3,12001,3000);
5649: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'l_sql_statement_tbl5 : '||l_sql5);
5650: l_sql6 := substr(l_sql_statement_ar_3,15001,3000);
5651: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'l_sql_statement_tbl6 : '||l_sql6);

Line 5649: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'l_sql_statement_tbl5 : '||l_sql5);

5645: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'l_sql_statement_tbl3 : '||l_sql3);
5646: l_sql4 := substr(l_sql_statement_ar_3,9001,3000);
5647: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'l_sql_statement_tbl4 : '||l_sql4);
5648: l_sql5 := substr(l_sql_statement_ar_3,12001,3000);
5649: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'l_sql_statement_tbl5 : '||l_sql5);
5650: l_sql6 := substr(l_sql_statement_ar_3,15001,3000);
5651: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'l_sql_statement_tbl6 : '||l_sql6);
5652: l_sql7 := substr(l_sql_statement_ar_3,18001,3000);
5653: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'l_sql_statement_tbl7 : '||l_sql7);

Line 5651: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'l_sql_statement_tbl6 : '||l_sql6);

5647: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'l_sql_statement_tbl4 : '||l_sql4);
5648: l_sql5 := substr(l_sql_statement_ar_3,12001,3000);
5649: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'l_sql_statement_tbl5 : '||l_sql5);
5650: l_sql6 := substr(l_sql_statement_ar_3,15001,3000);
5651: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'l_sql_statement_tbl6 : '||l_sql6);
5652: l_sql7 := substr(l_sql_statement_ar_3,18001,3000);
5653: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'l_sql_statement_tbl7 : '||l_sql7);
5654: l_sql8 := substr(l_sql_statement_ar_3,21001,3000);
5655: END IF;

Line 5653: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'l_sql_statement_tbl7 : '||l_sql7);

5649: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'l_sql_statement_tbl5 : '||l_sql5);
5650: l_sql6 := substr(l_sql_statement_ar_3,15001,3000);
5651: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'l_sql_statement_tbl6 : '||l_sql6);
5652: l_sql7 := substr(l_sql_statement_ar_3,18001,3000);
5653: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'l_sql_statement_tbl7 : '||l_sql7);
5654: l_sql8 := substr(l_sql_statement_ar_3,21001,3000);
5655: END IF;
5656:
5657: IF (g_level_procedure >= g_current_runtime_level ) THEN

Line 5659: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'l_sql_statement_tbl1 : '||l_sql1);

5655: END IF;
5656:
5657: IF (g_level_procedure >= g_current_runtime_level ) THEN
5658: l_sql1 := substr(l_sql_statement_ar_4,1,3000);
5659: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'l_sql_statement_tbl1 : '||l_sql1);
5660: l_sql2 := substr(l_sql_statement_ar_4,3001,3000);
5661: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'l_sql_statement_tbl2 : '||l_sql2);
5662: l_sql3 := substr(l_sql_statement_ar_4,6001,3000);
5663: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'l_sql_statement_tbl3 : '||l_sql3);

Line 5661: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'l_sql_statement_tbl2 : '||l_sql2);

5657: IF (g_level_procedure >= g_current_runtime_level ) THEN
5658: l_sql1 := substr(l_sql_statement_ar_4,1,3000);
5659: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'l_sql_statement_tbl1 : '||l_sql1);
5660: l_sql2 := substr(l_sql_statement_ar_4,3001,3000);
5661: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'l_sql_statement_tbl2 : '||l_sql2);
5662: l_sql3 := substr(l_sql_statement_ar_4,6001,3000);
5663: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'l_sql_statement_tbl3 : '||l_sql3);
5664: l_sql4 := substr(l_sql_statement_ar_4,9001,3000);
5665: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'l_sql_statement_tbl4 : '||l_sql4);

Line 5663: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'l_sql_statement_tbl3 : '||l_sql3);

5659: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'l_sql_statement_tbl1 : '||l_sql1);
5660: l_sql2 := substr(l_sql_statement_ar_4,3001,3000);
5661: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'l_sql_statement_tbl2 : '||l_sql2);
5662: l_sql3 := substr(l_sql_statement_ar_4,6001,3000);
5663: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'l_sql_statement_tbl3 : '||l_sql3);
5664: l_sql4 := substr(l_sql_statement_ar_4,9001,3000);
5665: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'l_sql_statement_tbl4 : '||l_sql4);
5666: l_sql5 := substr(l_sql_statement_ar_4,12001,3000);
5667: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'l_sql_statement_tbl5 : '||l_sql5);

Line 5665: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'l_sql_statement_tbl4 : '||l_sql4);

5661: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'l_sql_statement_tbl2 : '||l_sql2);
5662: l_sql3 := substr(l_sql_statement_ar_4,6001,3000);
5663: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'l_sql_statement_tbl3 : '||l_sql3);
5664: l_sql4 := substr(l_sql_statement_ar_4,9001,3000);
5665: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'l_sql_statement_tbl4 : '||l_sql4);
5666: l_sql5 := substr(l_sql_statement_ar_4,12001,3000);
5667: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'l_sql_statement_tbl5 : '||l_sql5);
5668: l_sql6 := substr(l_sql_statement_ar_4,15001,3000);
5669: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'l_sql_statement_tbl6 : '||l_sql6);

Line 5667: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'l_sql_statement_tbl5 : '||l_sql5);

5663: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'l_sql_statement_tbl3 : '||l_sql3);
5664: l_sql4 := substr(l_sql_statement_ar_4,9001,3000);
5665: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'l_sql_statement_tbl4 : '||l_sql4);
5666: l_sql5 := substr(l_sql_statement_ar_4,12001,3000);
5667: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'l_sql_statement_tbl5 : '||l_sql5);
5668: l_sql6 := substr(l_sql_statement_ar_4,15001,3000);
5669: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'l_sql_statement_tbl6 : '||l_sql6);
5670: l_sql7 := substr(l_sql_statement_ar_4,18001,3000);
5671: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'l_sql_statement_tbl7 : '||l_sql7);

Line 5669: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'l_sql_statement_tbl6 : '||l_sql6);

5665: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'l_sql_statement_tbl4 : '||l_sql4);
5666: l_sql5 := substr(l_sql_statement_ar_4,12001,3000);
5667: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'l_sql_statement_tbl5 : '||l_sql5);
5668: l_sql6 := substr(l_sql_statement_ar_4,15001,3000);
5669: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'l_sql_statement_tbl6 : '||l_sql6);
5670: l_sql7 := substr(l_sql_statement_ar_4,18001,3000);
5671: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'l_sql_statement_tbl7 : '||l_sql7);
5672: l_sql8 := substr(l_sql_statement_ar_4,21001,3000);
5673: END IF;

Line 5671: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'l_sql_statement_tbl7 : '||l_sql7);

5667: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'l_sql_statement_tbl5 : '||l_sql5);
5668: l_sql6 := substr(l_sql_statement_ar_4,15001,3000);
5669: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'l_sql_statement_tbl6 : '||l_sql6);
5670: l_sql7 := substr(l_sql_statement_ar_4,18001,3000);
5671: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'l_sql_statement_tbl7 : '||l_sql7);
5672: l_sql8 := substr(l_sql_statement_ar_4,21001,3000);
5673: END IF;
5674: IF (g_level_procedure >= g_current_runtime_level ) THEN
5675: l_sql1 := substr(l_sql_statement_ar_5,1,3000);

Line 5676: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'l_sql_statement_tbl1 : '||l_sql1);

5672: l_sql8 := substr(l_sql_statement_ar_4,21001,3000);
5673: END IF;
5674: IF (g_level_procedure >= g_current_runtime_level ) THEN
5675: l_sql1 := substr(l_sql_statement_ar_5,1,3000);
5676: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'l_sql_statement_tbl1 : '||l_sql1);
5677: l_sql2 := substr(l_sql_statement_ar_5,3001,3000);
5678: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'l_sql_statement_tbl2 : '||l_sql2);
5679: l_sql3 := substr(l_sql_statement_ar_5,6001,3000);
5680: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'l_sql_statement_tbl3 : '||l_sql3);

Line 5678: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'l_sql_statement_tbl2 : '||l_sql2);

5674: IF (g_level_procedure >= g_current_runtime_level ) THEN
5675: l_sql1 := substr(l_sql_statement_ar_5,1,3000);
5676: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'l_sql_statement_tbl1 : '||l_sql1);
5677: l_sql2 := substr(l_sql_statement_ar_5,3001,3000);
5678: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'l_sql_statement_tbl2 : '||l_sql2);
5679: l_sql3 := substr(l_sql_statement_ar_5,6001,3000);
5680: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'l_sql_statement_tbl3 : '||l_sql3);
5681: l_sql4 := substr(l_sql_statement_ar_5,9001,3000);
5682: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'l_sql_statement_tbl4 : '||l_sql4);

Line 5680: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'l_sql_statement_tbl3 : '||l_sql3);

5676: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'l_sql_statement_tbl1 : '||l_sql1);
5677: l_sql2 := substr(l_sql_statement_ar_5,3001,3000);
5678: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'l_sql_statement_tbl2 : '||l_sql2);
5679: l_sql3 := substr(l_sql_statement_ar_5,6001,3000);
5680: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'l_sql_statement_tbl3 : '||l_sql3);
5681: l_sql4 := substr(l_sql_statement_ar_5,9001,3000);
5682: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'l_sql_statement_tbl4 : '||l_sql4);
5683: l_sql5 := substr(l_sql_statement_ar_5,12001,3000);
5684: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'l_sql_statement_tbl5 : '||l_sql5);

Line 5682: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'l_sql_statement_tbl4 : '||l_sql4);

5678: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'l_sql_statement_tbl2 : '||l_sql2);
5679: l_sql3 := substr(l_sql_statement_ar_5,6001,3000);
5680: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'l_sql_statement_tbl3 : '||l_sql3);
5681: l_sql4 := substr(l_sql_statement_ar_5,9001,3000);
5682: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'l_sql_statement_tbl4 : '||l_sql4);
5683: l_sql5 := substr(l_sql_statement_ar_5,12001,3000);
5684: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'l_sql_statement_tbl5 : '||l_sql5);
5685: l_sql6 := substr(l_sql_statement_ar_5,15001,3000);
5686: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'l_sql_statement_tbl6 : '||l_sql6);

Line 5684: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'l_sql_statement_tbl5 : '||l_sql5);

5680: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'l_sql_statement_tbl3 : '||l_sql3);
5681: l_sql4 := substr(l_sql_statement_ar_5,9001,3000);
5682: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'l_sql_statement_tbl4 : '||l_sql4);
5683: l_sql5 := substr(l_sql_statement_ar_5,12001,3000);
5684: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'l_sql_statement_tbl5 : '||l_sql5);
5685: l_sql6 := substr(l_sql_statement_ar_5,15001,3000);
5686: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'l_sql_statement_tbl6 : '||l_sql6);
5687: l_sql7 := substr(l_sql_statement_ar_5,18001,3000);
5688: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'l_sql_statement_tbl7 : '||l_sql7);

Line 5686: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'l_sql_statement_tbl6 : '||l_sql6);

5682: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'l_sql_statement_tbl4 : '||l_sql4);
5683: l_sql5 := substr(l_sql_statement_ar_5,12001,3000);
5684: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'l_sql_statement_tbl5 : '||l_sql5);
5685: l_sql6 := substr(l_sql_statement_ar_5,15001,3000);
5686: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'l_sql_statement_tbl6 : '||l_sql6);
5687: l_sql7 := substr(l_sql_statement_ar_5,18001,3000);
5688: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'l_sql_statement_tbl7 : '||l_sql7);
5689: l_sql8 := substr(l_sql_statement_ar_4,21001,3000);
5690: END IF;

Line 5688: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'l_sql_statement_tbl7 : '||l_sql7);

5684: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'l_sql_statement_tbl5 : '||l_sql5);
5685: l_sql6 := substr(l_sql_statement_ar_5,15001,3000);
5686: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'l_sql_statement_tbl6 : '||l_sql6);
5687: l_sql7 := substr(l_sql_statement_ar_5,18001,3000);
5688: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'l_sql_statement_tbl7 : '||l_sql7);
5689: l_sql8 := substr(l_sql_statement_ar_4,21001,3000);
5690: END IF;
5691: */
5692: l_sql_statement_tbl(1) := l_sql_statement_ar_1; --AR_INV

Line 5707: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO.END',

5703: END IF;
5704: END LOOP;
5705:
5706: IF (g_level_procedure >= g_current_runtime_level ) THEN
5707: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO.END',
5708: 'ZX_AR_ACTG_EXTRACT_PKG: FETCH_AR_TRX_INFO(-)');
5709: END IF;
5710:
5711:

Line 5743: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.EXECUTE_DYNAMIC_SQL_STRG.BEGIN',

5739:
5740:
5741:
5742: IF (g_level_procedure >= g_current_runtime_level ) THEN
5743: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.EXECUTE_DYNAMIC_SQL_STRG.BEGIN',
5744: 'ZX_AR_ACTG_EXTRACT_PKG: EXECUTE_DYNAMIC_SQL_STRG(+)');
5745: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.EXECUTE_DYNAMIC_SQL_STRG',
5746: 'OPEN zx_rep_detail_csr : ');
5747:

Line 5745: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.EXECUTE_DYNAMIC_SQL_STRG',

5741:
5742: IF (g_level_procedure >= g_current_runtime_level ) THEN
5743: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.EXECUTE_DYNAMIC_SQL_STRG.BEGIN',
5744: 'ZX_AR_ACTG_EXTRACT_PKG: EXECUTE_DYNAMIC_SQL_STRG(+)');
5745: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.EXECUTE_DYNAMIC_SQL_STRG',
5746: 'OPEN zx_rep_detail_csr : ');
5747:
5748: END IF;
5749:

Line 6083: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'l_sql_statement_tbl1 : '||l_sql1);

6079: ZX_LINE.TAX_ONLY_LINE_FLAG ';
6080:
6081: IF (g_level_procedure >= g_current_runtime_level ) THEN
6082: l_sql1 := substr(p_statement,1,3000);
6083: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'l_sql_statement_tbl1 : '||l_sql1);
6084: l_sql2 := substr(p_statement,3001,3000);
6085: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'l_sql_statement_tbl2 : '||l_sql2);
6086: l_sql3 := substr(p_statement,6001,3000);
6087: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'l_sql_statement_tbl3 : '||l_sql3);

Line 6085: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'l_sql_statement_tbl2 : '||l_sql2);

6081: IF (g_level_procedure >= g_current_runtime_level ) THEN
6082: l_sql1 := substr(p_statement,1,3000);
6083: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'l_sql_statement_tbl1 : '||l_sql1);
6084: l_sql2 := substr(p_statement,3001,3000);
6085: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'l_sql_statement_tbl2 : '||l_sql2);
6086: l_sql3 := substr(p_statement,6001,3000);
6087: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'l_sql_statement_tbl3 : '||l_sql3);
6088: l_sql4 := substr(p_statement,9001,3000);
6089: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'l_sql_statement_tbl4 : '||l_sql4);

Line 6087: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'l_sql_statement_tbl3 : '||l_sql3);

6083: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'l_sql_statement_tbl1 : '||l_sql1);
6084: l_sql2 := substr(p_statement,3001,3000);
6085: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'l_sql_statement_tbl2 : '||l_sql2);
6086: l_sql3 := substr(p_statement,6001,3000);
6087: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'l_sql_statement_tbl3 : '||l_sql3);
6088: l_sql4 := substr(p_statement,9001,3000);
6089: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'l_sql_statement_tbl4 : '||l_sql4);
6090: l_sql5 := substr(p_statement,12001,3000);
6091: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'l_sql_statement_tbl5 : '||l_sql5);

Line 6089: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'l_sql_statement_tbl4 : '||l_sql4);

6085: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'l_sql_statement_tbl2 : '||l_sql2);
6086: l_sql3 := substr(p_statement,6001,3000);
6087: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'l_sql_statement_tbl3 : '||l_sql3);
6088: l_sql4 := substr(p_statement,9001,3000);
6089: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'l_sql_statement_tbl4 : '||l_sql4);
6090: l_sql5 := substr(p_statement,12001,3000);
6091: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'l_sql_statement_tbl5 : '||l_sql5);
6092: l_sql6 := substr(p_statement,15001,3000);
6093: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'l_sql_statement_tbl6 : '||l_sql6);

Line 6091: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'l_sql_statement_tbl5 : '||l_sql5);

6087: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'l_sql_statement_tbl3 : '||l_sql3);
6088: l_sql4 := substr(p_statement,9001,3000);
6089: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'l_sql_statement_tbl4 : '||l_sql4);
6090: l_sql5 := substr(p_statement,12001,3000);
6091: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'l_sql_statement_tbl5 : '||l_sql5);
6092: l_sql6 := substr(p_statement,15001,3000);
6093: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'l_sql_statement_tbl6 : '||l_sql6);
6094: l_sql7 := substr(p_statement,18001,3000);
6095: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'l_sql_statement_tbl7 : '||l_sql7);

Line 6093: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'l_sql_statement_tbl6 : '||l_sql6);

6089: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'l_sql_statement_tbl4 : '||l_sql4);
6090: l_sql5 := substr(p_statement,12001,3000);
6091: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'l_sql_statement_tbl5 : '||l_sql5);
6092: l_sql6 := substr(p_statement,15001,3000);
6093: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'l_sql_statement_tbl6 : '||l_sql6);
6094: l_sql7 := substr(p_statement,18001,3000);
6095: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'l_sql_statement_tbl7 : '||l_sql7);
6096: l_sql8 := substr(p_statement,21001,3000);
6097: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'G_LEDGER_ID : '||to_char(G_LEDGER_ID));

Line 6095: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'l_sql_statement_tbl7 : '||l_sql7);

6091: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'l_sql_statement_tbl5 : '||l_sql5);
6092: l_sql6 := substr(p_statement,15001,3000);
6093: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'l_sql_statement_tbl6 : '||l_sql6);
6094: l_sql7 := substr(p_statement,18001,3000);
6095: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'l_sql_statement_tbl7 : '||l_sql7);
6096: l_sql8 := substr(p_statement,21001,3000);
6097: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'G_LEDGER_ID : '||to_char(G_LEDGER_ID));
6098: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'G_LEGAL_ENTITY_ID : '||G_LEGAL_ENTITY_ID);
6099: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'G_BATCH_NAME : '||G_BATCH_NAME);

Line 6097: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'G_LEDGER_ID : '||to_char(G_LEDGER_ID));

6093: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'l_sql_statement_tbl6 : '||l_sql6);
6094: l_sql7 := substr(p_statement,18001,3000);
6095: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'l_sql_statement_tbl7 : '||l_sql7);
6096: l_sql8 := substr(p_statement,21001,3000);
6097: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'G_LEDGER_ID : '||to_char(G_LEDGER_ID));
6098: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'G_LEGAL_ENTITY_ID : '||G_LEGAL_ENTITY_ID);
6099: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'G_BATCH_NAME : '||G_BATCH_NAME);
6100: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'G_TRX_NUMBER_LOW : '||G_TRX_NUMBER_LOW);
6101: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'G_TRX_NUMBER_HIGH : '||G_TRX_NUMBER_HIGH);

Line 6098: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'G_LEGAL_ENTITY_ID : '||G_LEGAL_ENTITY_ID);

6094: l_sql7 := substr(p_statement,18001,3000);
6095: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'l_sql_statement_tbl7 : '||l_sql7);
6096: l_sql8 := substr(p_statement,21001,3000);
6097: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'G_LEDGER_ID : '||to_char(G_LEDGER_ID));
6098: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'G_LEGAL_ENTITY_ID : '||G_LEGAL_ENTITY_ID);
6099: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'G_BATCH_NAME : '||G_BATCH_NAME);
6100: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'G_TRX_NUMBER_LOW : '||G_TRX_NUMBER_LOW);
6101: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'G_TRX_NUMBER_HIGH : '||G_TRX_NUMBER_HIGH);
6102: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'G_TRX_DATE_LOW : '||G_TRX_DATE_LOW);

Line 6099: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'G_BATCH_NAME : '||G_BATCH_NAME);

6095: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'l_sql_statement_tbl7 : '||l_sql7);
6096: l_sql8 := substr(p_statement,21001,3000);
6097: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'G_LEDGER_ID : '||to_char(G_LEDGER_ID));
6098: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'G_LEGAL_ENTITY_ID : '||G_LEGAL_ENTITY_ID);
6099: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'G_BATCH_NAME : '||G_BATCH_NAME);
6100: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'G_TRX_NUMBER_LOW : '||G_TRX_NUMBER_LOW);
6101: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'G_TRX_NUMBER_HIGH : '||G_TRX_NUMBER_HIGH);
6102: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'G_TRX_DATE_LOW : '||G_TRX_DATE_LOW);
6103: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'G_TRX_DATE_HIGH : '||G_TRX_DATE_HIGH);

Line 6100: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'G_TRX_NUMBER_LOW : '||G_TRX_NUMBER_LOW);

6096: l_sql8 := substr(p_statement,21001,3000);
6097: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'G_LEDGER_ID : '||to_char(G_LEDGER_ID));
6098: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'G_LEGAL_ENTITY_ID : '||G_LEGAL_ENTITY_ID);
6099: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'G_BATCH_NAME : '||G_BATCH_NAME);
6100: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'G_TRX_NUMBER_LOW : '||G_TRX_NUMBER_LOW);
6101: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'G_TRX_NUMBER_HIGH : '||G_TRX_NUMBER_HIGH);
6102: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'G_TRX_DATE_LOW : '||G_TRX_DATE_LOW);
6103: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'G_TRX_DATE_HIGH : '||G_TRX_DATE_HIGH);
6104: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'G_GL_DATE_LOW : '||G_GL_DATE_LOW);

Line 6101: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'G_TRX_NUMBER_HIGH : '||G_TRX_NUMBER_HIGH);

6097: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'G_LEDGER_ID : '||to_char(G_LEDGER_ID));
6098: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'G_LEGAL_ENTITY_ID : '||G_LEGAL_ENTITY_ID);
6099: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'G_BATCH_NAME : '||G_BATCH_NAME);
6100: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'G_TRX_NUMBER_LOW : '||G_TRX_NUMBER_LOW);
6101: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'G_TRX_NUMBER_HIGH : '||G_TRX_NUMBER_HIGH);
6102: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'G_TRX_DATE_LOW : '||G_TRX_DATE_LOW);
6103: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'G_TRX_DATE_HIGH : '||G_TRX_DATE_HIGH);
6104: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'G_GL_DATE_LOW : '||G_GL_DATE_LOW);
6105: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'G_GL_DATE_HIGH : '||G_GL_DATE_HIGH);

Line 6102: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'G_TRX_DATE_LOW : '||G_TRX_DATE_LOW);

6098: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'G_LEGAL_ENTITY_ID : '||G_LEGAL_ENTITY_ID);
6099: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'G_BATCH_NAME : '||G_BATCH_NAME);
6100: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'G_TRX_NUMBER_LOW : '||G_TRX_NUMBER_LOW);
6101: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'G_TRX_NUMBER_HIGH : '||G_TRX_NUMBER_HIGH);
6102: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'G_TRX_DATE_LOW : '||G_TRX_DATE_LOW);
6103: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'G_TRX_DATE_HIGH : '||G_TRX_DATE_HIGH);
6104: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'G_GL_DATE_LOW : '||G_GL_DATE_LOW);
6105: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'G_GL_DATE_HIGH : '||G_GL_DATE_HIGH);
6106: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'G_DOCUMENT_SUB_TYPE : '||G_DOCUMENT_SUB_TYPE);

Line 6103: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'G_TRX_DATE_HIGH : '||G_TRX_DATE_HIGH);

6099: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'G_BATCH_NAME : '||G_BATCH_NAME);
6100: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'G_TRX_NUMBER_LOW : '||G_TRX_NUMBER_LOW);
6101: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'G_TRX_NUMBER_HIGH : '||G_TRX_NUMBER_HIGH);
6102: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'G_TRX_DATE_LOW : '||G_TRX_DATE_LOW);
6103: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'G_TRX_DATE_HIGH : '||G_TRX_DATE_HIGH);
6104: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'G_GL_DATE_LOW : '||G_GL_DATE_LOW);
6105: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'G_GL_DATE_HIGH : '||G_GL_DATE_HIGH);
6106: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'G_DOCUMENT_SUB_TYPE : '||G_DOCUMENT_SUB_TYPE);
6107:

Line 6104: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'G_GL_DATE_LOW : '||G_GL_DATE_LOW);

6100: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'G_TRX_NUMBER_LOW : '||G_TRX_NUMBER_LOW);
6101: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'G_TRX_NUMBER_HIGH : '||G_TRX_NUMBER_HIGH);
6102: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'G_TRX_DATE_LOW : '||G_TRX_DATE_LOW);
6103: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'G_TRX_DATE_HIGH : '||G_TRX_DATE_HIGH);
6104: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'G_GL_DATE_LOW : '||G_GL_DATE_LOW);
6105: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'G_GL_DATE_HIGH : '||G_GL_DATE_HIGH);
6106: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'G_DOCUMENT_SUB_TYPE : '||G_DOCUMENT_SUB_TYPE);
6107:
6108: END IF;

Line 6105: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'G_GL_DATE_HIGH : '||G_GL_DATE_HIGH);

6101: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'G_TRX_NUMBER_HIGH : '||G_TRX_NUMBER_HIGH);
6102: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'G_TRX_DATE_LOW : '||G_TRX_DATE_LOW);
6103: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'G_TRX_DATE_HIGH : '||G_TRX_DATE_HIGH);
6104: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'G_GL_DATE_LOW : '||G_GL_DATE_LOW);
6105: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'G_GL_DATE_HIGH : '||G_GL_DATE_HIGH);
6106: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'G_DOCUMENT_SUB_TYPE : '||G_DOCUMENT_SUB_TYPE);
6107:
6108: END IF;
6109:

Line 6106: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'G_DOCUMENT_SUB_TYPE : '||G_DOCUMENT_SUB_TYPE);

6102: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'G_TRX_DATE_LOW : '||G_TRX_DATE_LOW);
6103: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'G_TRX_DATE_HIGH : '||G_TRX_DATE_HIGH);
6104: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'G_GL_DATE_LOW : '||G_GL_DATE_LOW);
6105: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'G_GL_DATE_HIGH : '||G_GL_DATE_HIGH);
6106: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.FETCH_AR_TRX_INFO SQL', 'G_DOCUMENT_SUB_TYPE : '||G_DOCUMENT_SUB_TYPE);
6107:
6108: END IF;
6109:
6110:

Line 6152: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.EXECUTE_DYNAMIC_SQL_STRG',

6148:
6149:
6150:
6151: IF (g_level_procedure >= g_current_runtime_level ) THEN
6152: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.EXECUTE_DYNAMIC_SQL_STRG',
6153: 'After Using Clause of zx_rep_detail_csr : ');
6154:
6155: END IF;
6156: IF zx_rep_detail_csr%NOTFOUND THEN

Line 6159: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.EXECUTE_DYNAMIC_SQL_STRG',

6155: END IF;
6156: IF zx_rep_detail_csr%NOTFOUND THEN
6157:
6158: IF (g_level_procedure >= g_current_runtime_level ) THEN
6159: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.EXECUTE_DYNAMIC_SQL_STRG',
6160: 'End of fetch zx_rep_detail_csr : ');
6161:
6162: END IF;
6163: END If;

Line 6186: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.EXECUTE_DYNAMIC_SQL_STRG',

6182:
6183: -- insert when fetch up to 1000 rows
6184: --
6185: IF (g_level_procedure >= g_current_runtime_level ) THEN
6186: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.EXECUTE_DYNAMIC_SQL_STRG',
6187: 'FETCH zx_rep_detail_csr : ');
6188: END IF;
6189:
6190: LOOP

Line 6412: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.EXECUTE_DYNAMIC_SQL_STRG',

6408: -- gt_program_id(i),
6409: -- gt_program_login_id(i);
6410:
6411: IF (g_level_procedure >= g_current_runtime_level ) THEN
6412: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.EXECUTE_DYNAMIC_SQL_STRG',
6413: 'After FETCH zx_rep_detail_csr : '||to_char(gt_ledger_id.count));
6414: END IF;
6415:
6416: IF zx_rep_detail_csr%NOTFOUND THEN

Line 6419: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.EXECUTE_DYNAMIC_SQL_STRG',

6415:
6416: IF zx_rep_detail_csr%NOTFOUND THEN
6417:
6418: IF (g_level_procedure >= g_current_runtime_level ) THEN
6419: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.EXECUTE_DYNAMIC_SQL_STRG',
6420: 'End of FETCH zx_rep_detail_csr : ');
6421:
6422: END IF;
6423: end if;

Line 6460: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.EXECUTE_DYNAMIC_SQL_STRG.END',

6456: END LOOP;
6457:
6458:
6459: IF (g_level_procedure >= g_current_runtime_level ) THEN
6460: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.EXECUTE_DYNAMIC_SQL_STRG.END',
6461: 'ZX_AR_ACTG_EXTRACT_PKG: EXECUTE_DYNAMIC_SQL_STRG(-)');
6462: END IF;
6463:
6464: EXCEPTION

Line 6471: FND_LOG.STRING(g_level_unexpected,

6467: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
6468: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','EXECUTE_DYNAMIC_SQL_STRG- '|| g_error_buffer);
6469: FND_MSG_PUB.Add;
6470: IF (g_level_unexpected >= g_current_runtime_level ) THEN
6471: FND_LOG.STRING(g_level_unexpected,
6472: 'ZX.TRL.ZX_EXTRACT_PKG.EXECUTE_DYNAMIC_SQL_STRG - Numeric error',
6473: g_error_buffer);
6474: END IF;
6475:

Line 6483: FND_LOG.STRING(g_level_unexpected,

6479: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
6480: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','EXECUTE_DYNAMIC_SQL_STRG- '|| g_error_buffer);
6481: FND_MSG_PUB.Add;
6482: IF (g_level_unexpected >= g_current_runtime_level ) THEN
6483: FND_LOG.STRING(g_level_unexpected,
6484: 'ZX.TRL.ZX_EXTRACT_PKG.EXECUTE_DYNAMIC_SQL_STRG-No data',
6485: g_error_buffer);
6486: END IF;
6487:

Line 6494: FND_LOG.STRING(g_level_unexpected,

6490: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
6491: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','EXECUTE_DYNAMIC_SQL_STRG- '|| g_error_buffer);
6492: FND_MSG_PUB.Add;
6493: IF (g_level_unexpected >= g_current_runtime_level ) THEN
6494: FND_LOG.STRING(g_level_unexpected,
6495: 'ZX.TRL.ZX_EXTRACT_PKG.EXECUTE_DYNAMIC_SQL_STRG',
6496: g_error_buffer);
6497: END IF;
6498:

Line 6534: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.INSERT_AR_TRX_INFO.BEGIN',

6530:
6531: BEGIN
6532:
6533: IF (g_level_procedure >= g_current_runtime_level ) THEN
6534: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.INSERT_AR_TRX_INFO.BEGIN',
6535: 'ZX_AR_ACTG_EXTRACT_PKG: INSERT_AR_TRX_INFO(+)');
6536: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.INSERT_AR_TRX_INFO',
6537: 'Rows fetched : '||to_char(GT_LEDGER_ID.COUNT));
6538: END IF;

Line 6536: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.INSERT_AR_TRX_INFO',

6532:
6533: IF (g_level_procedure >= g_current_runtime_level ) THEN
6534: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.INSERT_AR_TRX_INFO.BEGIN',
6535: 'ZX_AR_ACTG_EXTRACT_PKG: INSERT_AR_TRX_INFO(+)');
6536: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.INSERT_AR_TRX_INFO',
6537: 'Rows fetched : '||to_char(GT_LEDGER_ID.COUNT));
6538: END IF;
6539:
6540: l_count := NVL(GT_LEDGER_ID.COUNT, 0);

Line 7088: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.INSERT_AR_TRX_INFO',

7084: GT_TAX_AMT_INCLUDED_FLAG(i),
7085: GT_TAX_ONLY_LINE_FLAG(i));
7086: */
7087: IF (g_level_procedure >= g_current_runtime_level ) THEN
7088: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.INSERT_AR_TRX_INFO',
7089: 'Number of AR rows successfully inserted = '||TO_CHAR(NVL(GT_LEDGER_ID.COUNT, 0)));
7090: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.INSERT_AR_TRX_INFO.END',
7091: 'ZX_AR_ACTG_EXTRACT_PKG: INSERT_AR_TRX_INFO(-)');
7092: END IF;

Line 7090: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.INSERT_AR_TRX_INFO.END',

7086: */
7087: IF (g_level_procedure >= g_current_runtime_level ) THEN
7088: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.INSERT_AR_TRX_INFO',
7089: 'Number of AR rows successfully inserted = '||TO_CHAR(NVL(GT_LEDGER_ID.COUNT, 0)));
7090: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.INSERT_AR_TRX_INFO.END',
7091: 'ZX_AR_ACTG_EXTRACT_PKG: INSERT_AR_TRX_INFO(-)');
7092: END IF;
7093: FORALL i IN 1 .. l_count
7094: INSERT INTO ZX_REP_ACTG_EXT_T(

Line 7175: FND_LOG.STRING(g_level_unexpected,

7171: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
7172: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','INSERT_AR_TRX_INFO- '|| g_error_buffer);
7173: FND_MSG_PUB.Add;
7174: IF (g_level_unexpected >= g_current_runtime_level ) THEN
7175: FND_LOG.STRING(g_level_unexpected,
7176: 'ZX.TRL.ZX_EXTRACT_PKG.INSERT_AR_TRX_INFO',
7177: g_error_buffer);
7178: END IF;
7179: g_retcode := 2;

Line 7654: FND_LOG.STRING(g_level_unexpected,

7650: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
7651: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','INIT_AR_GT_TABLES- '|| g_error_buffer);
7652: FND_MSG_PUB.Add;
7653: IF (g_level_unexpected >= g_current_runtime_level ) THEN
7654: FND_LOG.STRING(g_level_unexpected,
7655: 'ZX.TRL.ZX_EXTRACT_PKG.INIT_AR_GT_TABLES',
7656: g_error_buffer);
7657: END IF;
7658:

Line 7689: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.ASSIGN_AR_GLOBAL_VARIABLES.BEGIN',

7685:
7686:
7687:
7688: IF (g_level_procedure >= g_current_runtime_level ) THEN
7689: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.ASSIGN_AR_GLOBAL_VARIABLES.BEGIN',
7690: 'ZX_AR_ACTG_EXTRACT_PKG:ASSIGN_AR_GLOBAL_VARIABLES(+)');
7691: END IF;
7692:
7693: G_REPORTING_LEVEL := P_TRL_GLOBAL_VARIABLES_REC.REPORTING_LEVEL;

Line 7801: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.ASSIGN_AR_GLOBAL_VARIABLES.END',

7797: G_TRX_CLASS := NULL;
7798:
7799:
7800: IF (g_level_procedure >= g_current_runtime_level ) THEN
7801: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.ASSIGN_AR_GLOBAL_VARIABLES.END',
7802: 'ZX_AR_ACTG_EXTRACT_PKG:ASSIGN_AR_GLOBAL_VARIABLES(-)');
7803: END IF;
7804: EXCEPTION
7805: WHEN OTHERS THEN

Line 7811: FND_LOG.STRING(g_level_unexpected,

7807: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
7808: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','ASSIGN_AR_GLOBAL_VARIABLES- '|| g_error_buffer);
7809: FND_MSG_PUB.Add;
7810: IF (g_level_unexpected >= g_current_runtime_level ) THEN
7811: FND_LOG.STRING(g_level_unexpected,
7812: 'ZX.TRL.ZX_EXTRACT_PKG.ASSIGN_AR_GLOBAL_VARIABLES',
7813: g_error_buffer);
7814: END IF;
7815: