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

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

111: p_amount_received_tbl OUT NOCOPY NUMERIC2_TBL,
112: p_tax_received_tbl OUT NOCOPY NUMERIC1_TBL
113: );
114:
115: -- Declare global varibles for FND log messages
116:
117: g_current_runtime_level NUMBER;
118: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
119: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;

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

114:
115: -- Declare global varibles for FND log messages
116:
117: g_current_runtime_level NUMBER;
118: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
119: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
120: g_level_event CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
121: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
122: g_error_buffer VARCHAR2(100);

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

115: -- Declare global varibles for FND log messages
116:
117: g_current_runtime_level NUMBER;
118: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
119: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
120: g_level_event CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
121: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
122: g_error_buffer VARCHAR2(100);
123:

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

116:
117: g_current_runtime_level NUMBER;
118: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
119: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
120: g_level_event CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
121: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
122: g_error_buffer VARCHAR2(100);
123:
124: -- Public APIs

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

117: g_current_runtime_level NUMBER;
118: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
119: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
120: g_level_event CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
121: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
122: g_error_buffer VARCHAR2(100);
123:
124: -- Public APIs
125:

Line 169: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

165: AND xle_etb.main_establishment_flag = 'Y';
166:
167: BEGIN
168:
169: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
170: -- g_level_statement := FND_LOG.LEVEL_STATEMENT;
171: -- g_level_procedure := FND_LOG.LEVEL_PROCEDURE;
172:
173: IF (g_level_procedure >= g_current_runtime_level ) THEN

Line 170: -- g_level_statement := FND_LOG.LEVEL_STATEMENT;

166:
167: BEGIN
168:
169: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
170: -- g_level_statement := FND_LOG.LEVEL_STATEMENT;
171: -- g_level_procedure := FND_LOG.LEVEL_PROCEDURE;
172:
173: IF (g_level_procedure >= g_current_runtime_level ) THEN
174: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP.BEGIN',

Line 171: -- g_level_procedure := FND_LOG.LEVEL_PROCEDURE;

167: BEGIN
168:
169: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
170: -- g_level_statement := FND_LOG.LEVEL_STATEMENT;
171: -- g_level_procedure := FND_LOG.LEVEL_PROCEDURE;
172:
173: IF (g_level_procedure >= g_current_runtime_level ) THEN
174: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP.BEGIN',
175: 'ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP(+)');

Line 174: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP.BEGIN',

170: -- g_level_statement := FND_LOG.LEVEL_STATEMENT;
171: -- g_level_procedure := FND_LOG.LEVEL_PROCEDURE;
172:
173: IF (g_level_procedure >= g_current_runtime_level ) THEN
174: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP.BEGIN',
175: 'ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP(+)');
176: END IF;
177:
178: p_request_id := P_TRL_GLOBAL_VARIABLES_REC.REQUEST_ID;

Line 185: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP',

181: p_product := P_TRL_GLOBAL_VARIABLES_REC.PRODUCT;
182: P_POSTING_STATUS := P_TRL_GLOBAL_VARIABLES_REC.POSTING_STATUS;
183:
184: IF (g_level_statement >= g_current_runtime_level ) THEN
185: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP',
186: 'p_report_name : '||P_REPORT_NAME);
187: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP',
188: 'p_request_id : '||p_request_id);
189: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP',

Line 187: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP',

183:
184: IF (g_level_statement >= g_current_runtime_level ) THEN
185: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP',
186: 'p_report_name : '||P_REPORT_NAME);
187: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP',
188: 'p_request_id : '||p_request_id);
189: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP',
190: 'p_legal_entity_id : '||p_legal_entity_id);
191: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP',

Line 189: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP',

185: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP',
186: 'p_report_name : '||P_REPORT_NAME);
187: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP',
188: 'p_request_id : '||p_request_id);
189: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP',
190: 'p_legal_entity_id : '||p_legal_entity_id);
191: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP',
192: 'p_product : '||p_product);
193: END IF;

Line 191: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP',

187: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP',
188: 'p_request_id : '||p_request_id);
189: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP',
190: 'p_legal_entity_id : '||p_legal_entity_id);
191: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP',
192: 'p_product : '||p_product);
193: END IF;
194:
195:

Line 239: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP',

235: where dist1.invoice_distribution_id = temp.taxable_item_source_id
236: AND NVL(dist1.historical_flag,'N') = 'Y');
237:
238: IF (g_level_statement >= g_current_runtime_level ) THEN
239: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP',
240: 'Updated Taxable Amount for prepayment Applications for '||to_char(SQL%ROWCOUNT)||' records.');
241: END IF;
242:
243: -- Upgraded prepay applications new code replaces SLA based queries --

Line 285: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP',

281: AND NVL(dist1.historical_flag,'N') = 'Y');
282:
283: END IF;
284: IF (g_level_statement >= g_current_runtime_level ) THEN
285: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP',
286: 'Updated Taxable Amount for Upgraded prepayment Applications for '||to_char(SQL%ROWCOUNT)||' records.');
287: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP',
288: 'Reporting_Ledger_id : '||to_char(p_trl_global_variables_rec.reporting_ledger_id) );
289: END IF;

Line 287: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP',

283: END IF;
284: IF (g_level_statement >= g_current_runtime_level ) THEN
285: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP',
286: 'Updated Taxable Amount for Upgraded prepayment Applications for '||to_char(SQL%ROWCOUNT)||' records.');
287: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP',
288: 'Reporting_Ledger_id : '||to_char(p_trl_global_variables_rec.reporting_ledger_id) );
289: END IF;
290:
291: --- Upgraded Prepay Applications --

Line 321: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP',

317: AND ah.release_lookup_code IS NULL )
318: AND dtl.request_id = p_request_id);
319:
320: IF (g_level_statement >= g_current_runtime_level ) THEN
321: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP',
322: 'Insertion for Hold , ext.attribute1 : '||to_char(SQL%ROWCOUNT) );
323: END IF;
324:
325: --Bug 5251425 : To get the C_TRX_CURRENCY_DESC ( ext.attribute9) and the C_BATCH_NAME ( ext.attribute8 ) for the Invoice .

Line 356: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP',

352: AND dtl.tax_rate_id = rates.tax_rate_id(+)
353: AND acc.TAX_ACCOUNT_ENTITY_ID(+) = rates.tax_rate_id;
354:
355: IF (g_level_statement >= g_current_runtime_level ) THEN
356: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP',
357: 'Count fetched : '||to_char(nvl(l_detail_tax_line_id_tbl.count,0)) );
358: END IF;
359: --Get details for C_MATCH
360:

Line 368: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP',

364: l_match_tbl
365: );
366:
367: IF (g_level_statement >= g_current_runtime_level ) THEN
368: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP',
369: 'Before insertion into zx_rep_trx_jx_ext_t for report '||p_report_name );
370: END IF;
371:
372: FORALL i IN nvl(l_detail_tax_line_id_tbl.FIRST,1)..nvl(l_detail_tax_line_id_tbl.LAST,0)

Line 406: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP',

402: fnd_global.login_id,
403: p_request_id
404: );
405: IF (g_level_statement >= g_current_runtime_level ) THEN
406: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP',
407: 'Update for ERV/IPV , ext.numeric1 : ' );
408: END IF;
409:
410: DELETE FROM zx_rep_actg_ext_t acct1

Line 424: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP',

420: acct2.actg_source_id,acct2.detail_tax_line_id
421: HAVING COUNT( DISTINCT acct2.actg_ext_line_id) >=2);
422:
423: IF (g_level_statement >= g_current_runtime_level ) THEN
424: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP',
425: 'Deleted duplicate rows from zx_rep_actg_ext_t: '||to_char(SQL%ROWCOUNT) );
426: END IF;
427:
428: update zx_rep_actg_ext_t act

Line 440: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP',

436: where act.request_id = p_request_id
437: and act.period_name is null;
438:
439: IF (g_level_statement >= g_current_runtime_level ) THEN
440: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP',
441: 'After Updating period name on zx_rep_actg_ext_t table ');
442: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP',
443: 'Number of rows updated: '||to_char(SQL%ROWCOUNT));
444: END IF;

Line 442: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP',

438:
439: IF (g_level_statement >= g_current_runtime_level ) THEN
440: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP',
441: 'After Updating period name on zx_rep_actg_ext_t table ');
442: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP',
443: 'Number of rows updated: '||to_char(SQL%ROWCOUNT));
444: END IF;
445:
446: UPDATE zx_rep_trx_jx_ext_t ext

Line 484: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP',

480: )
481: where ext.request_id = p_request_id;
482:
483: IF (g_level_statement >= g_current_runtime_level ) THEN
484: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP',
485: 'Number of rows updated in table zx_rep_trx_jx_ext_t: '||to_char(SQL%ROWCOUNT) );
486: END IF;
487:
488: UPDATE zx_rep_trx_detail_t dtl

Line 511: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP',

507: WHERE REC_NREC_TAX_DIST_ID = DTL.ACTG_SOURCE_ID
508: );
509:
510: IF (g_level_statement >= g_current_runtime_level ) THEN
511: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP',
512: 'Number of rows updated to Amt as 0 in table zx_rep_trx_detail_t: '||to_char(SQL%ROWCOUNT));
513: END IF;
514:
515: EXCEPTION

Line 518: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP',

514:
515: EXCEPTION
516: WHEN OTHERS THEN
517: IF (g_level_statement >= g_current_runtime_level ) THEN
518: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP',
519: 'Error Message for report '||p_report_name ||' : '||substrb(SQLERRM,1,120) );
520: END IF;
521: END;
522: END IF;

Line 527: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP',

523:
524: IF P_REPORT_NAME = 'JGVAT' THEN
525: BEGIN
526: IF (g_level_statement >= g_current_runtime_level ) THEN
527: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP',
528: 'Report Name: JGVAT ' );
529: END IF;
530:
531: DELETE FROM zx_rep_actg_ext_t acct1

Line 545: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP',

541: acct2.actg_source_id,acct2.detail_tax_line_id
542: HAVING COUNT( DISTINCT acct2.actg_ext_line_id) >=2);
543:
544: IF (g_level_statement >= g_current_runtime_level ) THEN
545: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP',
546: 'Deleted duplicate rows from zx_rep_actg_ext_t: '||to_char(SQL%ROWCOUNT) );
547: END IF;
548:
549:

Line 552: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP',

548:
549:
550: IF p_trl_global_variables_rec.reporting_ledger_id IS NOT NULL THEN
551: IF (g_level_statement >= g_current_runtime_level ) THEN
552: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP',
553: 'Update zx_rep_trx_detail_t.taxable_amt_funcl_curr for IPV issue' );
554: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP',
555: 'Reporting_ledger_id : '||to_char(p_trl_global_variables_rec.reporting_ledger_id) );
556: END IF;

Line 554: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP',

550: IF p_trl_global_variables_rec.reporting_ledger_id IS NOT NULL THEN
551: IF (g_level_statement >= g_current_runtime_level ) THEN
552: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP',
553: 'Update zx_rep_trx_detail_t.taxable_amt_funcl_curr for IPV issue' );
554: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP',
555: 'Reporting_ledger_id : '||to_char(p_trl_global_variables_rec.reporting_ledger_id) );
556: END IF;
557:
558: UPDATE zx_rep_trx_detail_t dtl1

Line 626: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP',

622: AND dtl1.application_id = 200
623: and dtl1.ref_doc_application_id = 201;
624:
625: IF (g_level_statement >= g_current_runtime_level ) THEN
626: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP',
627: 'Number of rows updated : '||to_char(SQL%ROWCOUNT) );
628: END IF;
629: ELSE
630:

Line 632: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP',

628: END IF;
629: ELSE
630:
631: IF (g_level_statement >= g_current_runtime_level ) THEN
632: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP',
633: 'Update zx_rep_trx_detail_t.taxable_amt_funcl_curr with AP Dist base_amount' );
634: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP',
635: 'Primar ledger id : '||to_char(p_trl_global_variables_rec.ledger_id) );
636: END IF;

Line 634: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP',

630:
631: IF (g_level_statement >= g_current_runtime_level ) THEN
632: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP',
633: 'Update zx_rep_trx_detail_t.taxable_amt_funcl_curr with AP Dist base_amount' );
634: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP',
635: 'Primar ledger id : '||to_char(p_trl_global_variables_rec.ledger_id) );
636: END IF;
637:
638: UPDATE zx_rep_trx_detail_t dtl1

Line 671: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP',

667: AND dtl1.application_id = 200
668: AND dtl1.ref_doc_application_id = 201;
669:
670: IF (g_level_statement >= g_current_runtime_level ) THEN
671: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP',
672: 'Update zx_rep_trx_detail_t.taxable_amt_funcl_curr with AP Dist base_amount' );
673: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP',
674: 'Primar ledger id : '||to_char(p_trl_global_variables_rec.ledger_id) );
675: END IF;

Line 673: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP',

669:
670: IF (g_level_statement >= g_current_runtime_level ) THEN
671: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP',
672: 'Update zx_rep_trx_detail_t.taxable_amt_funcl_curr with AP Dist base_amount' );
673: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP',
674: 'Primar ledger id : '||to_char(p_trl_global_variables_rec.ledger_id) );
675: END IF;
676:
677:

Line 698: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP',

694: AND DTL.OFFSET_TAX_RATE_CODE IS NULL
695: AND DTL.APPLICATION_ID = 200;
696:
697: IF (g_level_statement >= g_current_runtime_level ) THEN
698: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP',
699: 'Number of rows updated For Recovery Rate: '||to_char(SQL%ROWCOUNT) );
700: END IF;
701:
702: -- Bug 12814237, This is for the migrated AP invoices where in 11i 2 tax distributions

Line 723: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP',

719: AND ZX_DIST1.rec_nrec_tax_amt <> 0
720: );
721:
722: IF (g_level_statement >= g_current_runtime_level ) THEN
723: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP',
724: 'Number of rows updated For Recovery Rate - 2: '||to_char(SQL%ROWCOUNT) );
725: END IF;
726:
727:

Line 732: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP',

728:
729: EXCEPTION
730: WHEN OTHERS THEN
731: IF (g_level_statement >= g_current_runtime_level ) THEN
732: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP',
733: 'Error Message for report '||p_report_name ||' : '||substrb(SQLERRM,1,120) );
734: END IF;
735: END;
736: END IF; /* end of condition if report_name = 'JGVAT' */

Line 744: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP',

740: OPEN establishment_id_csr (p_legal_entity_id);
741: FETCH establishment_id_csr INTO l_establishment_id;
742:
743: IF (g_level_statement >= g_current_runtime_level ) THEN
744: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP',
745: 'l_establishment_id : '||l_establishment_id);
746: END IF;
747:
748: -- ------------------------------------------------ --

Line 787: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP',

783: and code.reporting_code_char_value = dtl.billing_tp_country
784: );
785:
786: IF (g_level_statement >= g_current_runtime_level ) THEN
787: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP',
788: 'Count fetched : '||to_char(nvl(l_detail_tax_line_id_tbl.count,0)) );
789: END IF;
790:
791: -- Note : Need to add xle_associations_v view to the above query for establishment_id join

Line 802: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP',

798: l_territory_short_name_tbl,
799: l_alternate_territory_name_tbl);
800:
801: IF (g_level_statement >= g_current_runtime_level ) THEN
802: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP',
803: 'After getting the territory info.' );
804: END IF;
805:
806: GET_ORG_VAT_NUM ( l_detail_tax_line_id_tbl,

Line 811: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP',

807: l_establishment_id,
808: l_org_vat_num_tbl);
809:
810: IF (g_level_statement >= g_current_runtime_level ) THEN
811: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP',
812: 'After getting the org_vat_num' );
813: END IF;
814:
815:

Line 826: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP',

822: l_created_by_tbl
823: );
824:
825: IF (g_level_statement >= g_current_runtime_level ) THEN
826: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP',
827: 'After getting the created_by for invoice' );
828: END IF;
829:
830:

Line 838: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP',

834: l_ou_desc_tbl
835: );
836:
837: IF (g_level_statement >= g_current_runtime_level ) THEN
838: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP',
839: 'After getting the OU Description.' );
840: END IF;
841:
842:

Line 874: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP',

870: fnd_global.login_id,
871: p_request_id);
872:
873: IF (g_level_statement >= g_current_runtime_level ) THEN
874: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP',
875: 'After insertion into zx_rep_trx_jx_ext_t for report '||p_report_name );
876: END IF;
877:
878: END IF ;

Line 888: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP',

884: FROM zx_rep_trx_jx_ext_t ext
885: WHERE ext.detail_tax_line_id = itf.detail_tax_line_id);
886:
887: IF (g_level_statement >= g_current_runtime_level ) THEN
888: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP',
889: 'After deletion from zx_rep_trx_detail_t : '||to_char(SQL%ROWCOUNT) );
890: END IF;
891:
892: EXCEPTION

Line 896: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP',

892: EXCEPTION
893: WHEN OTHERS THEN
894: NULL;
895: IF (g_level_statement >= g_current_runtime_level ) THEN
896: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP',
897: 'Error Message for report '||p_report_name ||' : '||substrb(SQLERRM,1,120) );
898: END IF;
899:
900: END;

Line 913: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_CORE_AP',

909: WHERE request_id = p_request_id
910: AND NVL(gl_transfer_flag,'N') <>'Y';
911:
912: IF ( g_level_statement>= g_current_runtime_level ) THEN
913: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_CORE_AP',
914: 'No of Unposted transactions deleted from zx_rep_actg_ext_t: '|| sql%rowcount);
915: END IF;
916:
917: DELETE FROM zx_rep_trx_detail_t dtl

Line 923: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_CORE_AP',

919: AND NOT EXISTS (SELECT 1 FROM zx_rep_actg_ext_t act
920: WHERE act.detail_tax_line_id = dtl.detail_tax_line_id) ;
921:
922: IF ( g_level_statement>= g_current_runtime_level ) THEN
923: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_CORE_AP',
924: 'No of rows deleted from zx_rep_trx_detail_t: '|| sql%rowcount);
925: END IF;
926: ELSIF P_POSTING_STATUS = 'NOT_TRANSFERRED' THEN
927: DELETE FROM zx_rep_actg_ext_t

Line 931: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_CORE_AP',

927: DELETE FROM zx_rep_actg_ext_t
928: WHERE request_id = p_request_id
929: AND NVL(gl_transfer_flag,'N') = 'Y';
930: IF ( g_level_statement>= g_current_runtime_level ) THEN
931: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_CORE_AP',
932: 'No of Unposted transactions deleted from zx_rep_actg_ext_t: '|| sql%rowcount);
933: END IF;
934: DELETE FROM zx_rep_trx_detail_t dtl
935: WHERE dtl.request_id = p_request_id

Line 941: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_CORE_AP',

937: AND NOT EXISTS (SELECT 1 FROM zx_rep_actg_ext_t act
938: WHERE act.detail_tax_line_id = dtl.detail_tax_line_id);
939:
940: IF ( g_level_statement>= g_current_runtime_level ) THEN
941: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_CORE_AP',
942: 'No of rows deleted from zx_rep_trx_detail_t: '|| sql%rowcount);
943: END IF;
944: END IF; /* END P_POSTING_STATUS */
945:

Line 961: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP',

957: acct2.actg_source_id,acct2.detail_tax_line_id
958: HAVING COUNT( DISTINCT acct2.actg_ext_line_id) >=2);
959:
960: IF (g_level_statement >= g_current_runtime_level ) THEN
961: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP',
962: 'For Primary Ledger Deleted duplicate rows from zx_rep_actg_ext_t: '||to_char(SQL%ROWCOUNT) );
963: END IF;
964: END IF; -- Primary Ledger Id --
965:

Line 984: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP',

980: FROM zx_rep_trx_detail_t dtl
981: WHERE dtl.request_id = p_request_id;
982:
983: IF (g_level_statement >= g_current_runtime_level ) THEN
984: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP',
985: 'Count fetched : '||to_char(nvl(l_detail_tax_line_id_tbl.count,0)) );
986: END IF;
987:
988: adjustment_tax_code(

Line 994: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP',

990: l_tax_rate_code_tbl,
991: l_adj_tax_code_tbl);
992:
993: IF (g_level_statement >= g_current_runtime_level ) THEN
994: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP',
995: 'After getting adjustment tax code for Italy, Poland, Portugal countries');
996: END IF;
997:
998: FORALL i in l_detail_tax_line_id_tbl.first..l_detail_tax_line_id_tbl.last

Line 1020: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP',

1016: fnd_global.login_id,
1017: p_request_id);
1018:
1019: IF (g_level_statement >= g_current_runtime_level ) THEN
1020: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP',
1021: 'After insertion into zx_rep_trx_jx_ext_t ');
1022: END IF;
1023:
1024: EXCEPTION

Line 1028: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP',

1024: EXCEPTION
1025: WHEN OTHERS THEN
1026: NULL;
1027: IF (g_level_statement >= g_current_runtime_level ) THEN
1028: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP',
1029: 'Error Message for report '||p_report_name ||' : '||substrb(SQLERRM,1,120) );
1030: END IF;
1031: END;
1032: END IF;

Line 1034: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1030: END IF;
1031: END;
1032: END IF;
1033: END IF;
1034: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1035: IF (g_level_procedure >= g_current_runtime_level ) THEN
1036: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP.BEGIN',
1037: 'ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP(-)');
1038: END IF;

Line 1036: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP.BEGIN',

1032: END IF;
1033: END IF;
1034: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1035: IF (g_level_procedure >= g_current_runtime_level ) THEN
1036: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP.BEGIN',
1037: 'ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP(-)');
1038: END IF;
1039: null;
1040:

Line 1069: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP',

1065: WHEN OTHERS THEN
1066: p_territory_short_name_tbl(i) := NULL ;
1067: p_alternate_territory_name_tbl(i) := NULL ;
1068: IF ( g_level_statement>= g_current_runtime_level ) THEN
1069: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP',
1070: 'Error Message : '||substrb(SQLERRM,1,120) );
1071: END IF;
1072: END;
1073: END LOOP;

Line 1109: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP',

1105: EXCEPTION
1106: WHEN OTHERS THEN
1107: p_org_vat_num_tbl(i) := NULL ;
1108: IF ( g_level_statement>= g_current_runtime_level ) THEN
1109: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP',
1110: 'Error Message : '||substrb(SQLERRM,1,120) );
1111: END IF;
1112: END ;
1113: END LOOP;

Line 1141: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP',

1137: EXCEPTION
1138: WHEN OTHERS THEN
1139: p_adj_tax_code_tbl(i) := NULL ;
1140: IF ( g_level_statement>= g_current_runtime_level ) THEN
1141: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP',
1142: 'Error Message : '||substrb(SQLERRM,1,120) );
1143: END IF;
1144: END ;
1145: END LOOP;

Line 1209: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',

1205: EXCEPTION
1206: WHEN OTHERS THEN
1207: p_created_by_tbl(i) := NULL ;
1208: IF ( g_level_statement>= g_current_runtime_level ) THEN
1209: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
1210: 'Error Message : '||substrb(SQLERRM,1,120) );
1211: END IF;
1212: END;
1213: END LOOP;

Line 1238: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',

1234: EXCEPTION
1235: WHEN OTHERS THEN
1236: p_ou_desc_tbl(i) := NULL ;
1237: IF ( g_level_statement>= g_current_runtime_level ) THEN
1238: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
1239: 'Error Message : '||substrb(SQLERRM,1,120) );
1240: END IF;
1241: END;
1242: END LOOP;

Line 1275: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',

1271: EXCEPTION
1272: WHEN OTHERS THEN
1273: p_match_tbl(i) := null;
1274: IF ( g_level_statement>= g_current_runtime_level ) THEN
1275: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
1276: 'Error Message : '||substrb(SQLERRM,1,120) );
1277: END IF;
1278: END;
1279: END LOOP;

Line 1330: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',

1326: l_amount_recvd_tbl(p_trx_id_tbl(i)) := 0;
1327: l_tax_amount_rcvd_tbl(p_trx_id_tbl(i)) := 0;
1328:
1329: IF ( g_level_statement>= g_current_runtime_level ) THEN
1330: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
1331: 'Error Message : '||substrb(SQLERRM,1,120) );
1332: END IF;
1333: END ;
1334: p_amount_received_tbl(i) := l_amount_recvd_tbl(p_trx_id_tbl(i));

Line 1490: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1486: -- IF PG_DEBUG = 'Y' THEN
1487: --
1488: -- arp_standard.debug('ZX.plsql.ZX_XX_EXTRACT_PKG.populate_tax_juris_for_usstr(+) ');
1489: -- END IF;
1490: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1491:
1492: IF (g_level_procedure >= g_current_runtime_level ) THEN
1493: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP.BEGIN',
1494: 'ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR(+)');

Line 1493: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP.BEGIN',

1489: -- END IF;
1490: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1491:
1492: IF (g_level_procedure >= g_current_runtime_level ) THEN
1493: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP.BEGIN',
1494: 'ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR(+)');
1495: END IF;
1496:
1497:

Line 1507: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',

1503:
1504: prev_event_class_mapping_id := 0;
1505:
1506: IF (g_level_statement >= g_current_runtime_level ) THEN
1507: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
1508: 'p_report_name : '||P_REPORT_NAME);
1509: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
1510: 'p_request_id : '||p_request_id);
1511: END IF;

Line 1509: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',

1505:
1506: IF (g_level_statement >= g_current_runtime_level ) THEN
1507: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
1508: 'p_report_name : '||P_REPORT_NAME);
1509: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
1510: 'p_request_id : '||p_request_id);
1511: END IF;
1512:
1513: --Bug 9031051

Line 1517: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',

1513: --Bug 9031051
1514:
1515: IF P_REPORT_NAME = 'ZXXEUSL' THEN
1516: IF (g_level_statement >= g_current_runtime_level ) THEN
1517: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
1518: 'P_TRL_GLOBAL_VARIABLES_REC.ESL_EU_GOODS: '||P_TRL_GLOBAL_VARIABLES_REC.ESL_EU_GOODS );
1519: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
1520: 'P_TRL_GLOBAL_VARIABLES_REC.ESL_EU_SERVICES: '||P_TRL_GLOBAL_VARIABLES_REC.ESL_EU_SERVICES );
1521: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',

Line 1519: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',

1515: IF P_REPORT_NAME = 'ZXXEUSL' THEN
1516: IF (g_level_statement >= g_current_runtime_level ) THEN
1517: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
1518: 'P_TRL_GLOBAL_VARIABLES_REC.ESL_EU_GOODS: '||P_TRL_GLOBAL_VARIABLES_REC.ESL_EU_GOODS );
1519: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
1520: 'P_TRL_GLOBAL_VARIABLES_REC.ESL_EU_SERVICES: '||P_TRL_GLOBAL_VARIABLES_REC.ESL_EU_SERVICES );
1521: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
1522: 'P_TRL_GLOBAL_VARIABLES_REC.ESL_EU_ADDL_CODE1: '||P_TRL_GLOBAL_VARIABLES_REC.ESL_EU_ADDL_CODE1 );
1523: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',

Line 1521: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',

1517: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
1518: 'P_TRL_GLOBAL_VARIABLES_REC.ESL_EU_GOODS: '||P_TRL_GLOBAL_VARIABLES_REC.ESL_EU_GOODS );
1519: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
1520: 'P_TRL_GLOBAL_VARIABLES_REC.ESL_EU_SERVICES: '||P_TRL_GLOBAL_VARIABLES_REC.ESL_EU_SERVICES );
1521: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
1522: 'P_TRL_GLOBAL_VARIABLES_REC.ESL_EU_ADDL_CODE1: '||P_TRL_GLOBAL_VARIABLES_REC.ESL_EU_ADDL_CODE1 );
1523: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
1524: 'P_TRL_GLOBAL_VARIABLES_REC.ESL_EU_ADDL_CODE2: '||P_TRL_GLOBAL_VARIABLES_REC.ESL_EU_ADDL_CODE2 );
1525: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',

Line 1523: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',

1519: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
1520: 'P_TRL_GLOBAL_VARIABLES_REC.ESL_EU_SERVICES: '||P_TRL_GLOBAL_VARIABLES_REC.ESL_EU_SERVICES );
1521: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
1522: 'P_TRL_GLOBAL_VARIABLES_REC.ESL_EU_ADDL_CODE1: '||P_TRL_GLOBAL_VARIABLES_REC.ESL_EU_ADDL_CODE1 );
1523: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
1524: 'P_TRL_GLOBAL_VARIABLES_REC.ESL_EU_ADDL_CODE2: '||P_TRL_GLOBAL_VARIABLES_REC.ESL_EU_ADDL_CODE2 );
1525: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
1526: 'P_TRL_GLOBAL_VARIABLES_REC.ESL_EU_TRX_TYPE: '||P_TRL_GLOBAL_VARIABLES_REC.ESL_EU_TRX_TYPE);
1527: END IF;

Line 1525: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',

1521: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
1522: 'P_TRL_GLOBAL_VARIABLES_REC.ESL_EU_ADDL_CODE1: '||P_TRL_GLOBAL_VARIABLES_REC.ESL_EU_ADDL_CODE1 );
1523: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
1524: 'P_TRL_GLOBAL_VARIABLES_REC.ESL_EU_ADDL_CODE2: '||P_TRL_GLOBAL_VARIABLES_REC.ESL_EU_ADDL_CODE2 );
1525: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
1526: 'P_TRL_GLOBAL_VARIABLES_REC.ESL_EU_TRX_TYPE: '||P_TRL_GLOBAL_VARIABLES_REC.ESL_EU_TRX_TYPE);
1527: END IF;
1528:
1529: IF P_TRL_GLOBAL_VARIABLES_REC.ESL_EU_GOODS IS NULL

Line 1536: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',

1532: AND P_TRL_GLOBAL_VARIABLES_REC.ESL_EU_ADDL_CODE2 IS NULL
1533: THEN
1534:
1535: IF (g_level_statement >= g_current_runtime_level ) THEN
1536: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
1537: ' All Reporting codes parameters are NULL. Atleast one reporting code should be passed to '||
1538: ' TRL to filter data. Otherwise the extracted data will be deleted from TRL temp tables: ');
1539: END IF;
1540: ELSE

Line 1588: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',

1584: and dtl.EVENT_CLASS_CODE ='ADJ';
1585: ***/
1586: EXCEPTION WHEN OTHERS THEN
1587: IF ( g_level_statement>= g_current_runtime_level ) THEN
1588: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
1589: 'Error in updating tax line id zx_rep_trx_detail_t: Error Message : '||substrb(SQLERRM,1,120) );
1590: END IF;
1591: END;
1592:

Line 1689: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',

1685:
1686: EXCEPTION
1687: WHEN OTHERS THEN
1688: IF ( g_level_statement>= g_current_runtime_level ) THEN
1689: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
1690: 'Error in fetching data from zx_rep_detail_t: Error Message : '||substrb(SQLERRM,1,120) );
1691: END IF;
1692: END;
1693:

Line 1695: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',

1691: END IF;
1692: END;
1693:
1694: IF ( g_level_statement>= g_current_runtime_level ) THEN
1695: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
1696: 'Count fetched : '||to_char(nvl(l_detail_tax_line_id_tbl.count,0)) );
1697: END IF;
1698:
1699: FOR i in 1..Nvl(l_detail_tax_line_id_tbl.last,0) LOOP

Line 1702: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',

1698:
1699: FOR i in 1..Nvl(l_detail_tax_line_id_tbl.last,0) LOOP
1700:
1701: IF ( g_level_statement>= g_current_runtime_level ) THEN
1702: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
1703: 'In l_detail_tax_line_id_tbl Loop'||to_char(l_detail_tax_line_id_tbl(i)));
1704: END IF;
1705:
1706: IF l_adj_trx_id_tbl(i) IS NOT NULL THEN

Line 1709: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',

1705:
1706: IF l_adj_trx_id_tbl(i) IS NOT NULL THEN
1707:
1708: IF ( g_level_statement>= g_current_runtime_level ) THEN
1709: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
1710: 'Debug: l_trx_id_tbl(i) IS NOT NULL '||to_char(l_trx_id_tbl(i)) );
1711: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
1712: 'Debug: l_org_id_tbl(i) IS NOT NULL '||to_char(l_org_id_tbl(i)) );
1713: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',

Line 1711: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',

1707:
1708: IF ( g_level_statement>= g_current_runtime_level ) THEN
1709: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
1710: 'Debug: l_trx_id_tbl(i) IS NOT NULL '||to_char(l_trx_id_tbl(i)) );
1711: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
1712: 'Debug: l_org_id_tbl(i) IS NOT NULL '||to_char(l_org_id_tbl(i)) );
1713: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
1714: 'Debug: l_adj_trx_id_tbl(i) IS NOT NULL '||to_char(l_adj_trx_id_tbl(i)) );
1715: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',

Line 1713: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',

1709: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
1710: 'Debug: l_trx_id_tbl(i) IS NOT NULL '||to_char(l_trx_id_tbl(i)) );
1711: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
1712: 'Debug: l_org_id_tbl(i) IS NOT NULL '||to_char(l_org_id_tbl(i)) );
1713: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
1714: 'Debug: l_adj_trx_id_tbl(i) IS NOT NULL '||to_char(l_adj_trx_id_tbl(i)) );
1715: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
1716: 'Debug: l_adj_trx_line_id_tbl(i) IS NOT NULL '||to_char(l_adj_trx_line_id_tbl(i)) );
1717: END IF;

Line 1715: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',

1711: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
1712: 'Debug: l_org_id_tbl(i) IS NOT NULL '||to_char(l_org_id_tbl(i)) );
1713: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
1714: 'Debug: l_adj_trx_id_tbl(i) IS NOT NULL '||to_char(l_adj_trx_id_tbl(i)) );
1715: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
1716: 'Debug: l_adj_trx_line_id_tbl(i) IS NOT NULL '||to_char(l_adj_trx_line_id_tbl(i)) );
1717: END IF;
1718: -- To avoid repopulating the data for same item line
1719: IF (i = 1 OR l_trx_id_tbl(i) <> l_trx_id_tbl(i-1)

Line 1741: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',

1737: AND ROWNUM = 1;
1738: EXCEPTION
1739: WHEN OTHERS THEN
1740: IF (g_level_statement>= g_current_runtime_level ) THEN
1741: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
1742: 'Error in fetching data from ZX_LINES_DET_FACTORS for adjusted doc tax invoice date and gl date. Error Message : '
1743: ||substrb(SQLERRM,1,120) );
1744: END IF;
1745: END;

Line 1788: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',

1784:
1785: l_adj_trx_class_mng_tbl(i) := l_meaning;
1786: ELSE -- Do not repopulate the existing data
1787: IF ( g_level_statement>= g_current_runtime_level ) THEN
1788: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
1789: 'Debug: Not repopulating the data');
1790: END IF;
1791: IF ( g_level_statement>= g_current_runtime_level ) THEN
1792: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',

Line 1792: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',

1788: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
1789: 'Debug: Not repopulating the data');
1790: END IF;
1791: IF ( g_level_statement>= g_current_runtime_level ) THEN
1792: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
1793: 'Debug: l_adj_trx_id_tbl(i) IS NOT NULL '||to_char(l_adj_trx_id_tbl(i))||' '||to_char(l_adj_trx_line_id_tbl(i)) );
1794: END IF;
1795: l_adj_tax_invoice_tbl(i) := l_adj_tax_invoice_tbl(i-1);
1796: l_adj_gl_date_tbl(i) := l_adj_gl_date_tbl(i-1);

Line 1808: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',

1804: IF (i = 1 OR l_trx_id_tbl(i) <> l_trx_id_tbl(i-1)
1805: OR Nvl(l_adj_trx_line_id_tbl(i),l_trx_line_id_tbl(i)) <> Nvl(l_adj_trx_line_id_tbl(i-1),l_trx_line_id_tbl(i-1))) THEN
1806: --Code for populating the functional amount
1807: IF ( g_level_statement>= g_current_runtime_level ) THEN
1808: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
1809: 'Debug: Populating functional amount' );
1810: END IF;
1811:
1812: BEGIN

Line 1816: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',

1812: BEGIN
1813:
1814: IF l_event_class_code_tbl(i) = 'ADJ' THEN
1815: IF (g_level_statement>= g_current_runtime_level ) THEN
1816: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
1817: 'Debug: Populating functional amount ADJ - l_adj_trx_line_id_tbl : '||to_char(l_adj_trx_line_id_tbl(i) ));
1818: END IF;
1819:
1820: SELECT sum(nvl(ACCTD_AMOUNT_CR,0) - nvl(ACCTD_AMOUNT_DR,0))

Line 1829: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',

1825: AND ref_customer_trx_line_id = l_adj_trx_line_id_tbl(i)
1826: AND org_id = l_org_id_tbl(i);
1827:
1828: IF (g_level_statement>= g_current_runtime_level ) THEN
1829: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
1830: 'Debug: After Populating functional amount ADJ : '||to_char(l_func_curr_line_amt_tbl(i) ));
1831: END IF;
1832: ELSIF l_event_class_code_tbl(i) IN ('EDISC', 'UNEDISC') THEN
1833: IF (g_level_statement>= g_current_runtime_level ) THEN

Line 1834: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',

1830: 'Debug: After Populating functional amount ADJ : '||to_char(l_func_curr_line_amt_tbl(i) ));
1831: END IF;
1832: ELSIF l_event_class_code_tbl(i) IN ('EDISC', 'UNEDISC') THEN
1833: IF (g_level_statement>= g_current_runtime_level ) THEN
1834: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
1835: 'Debug: Populating functional amount Discounts - l_adj_trx_line_id_tbl : '||to_char(l_adj_trx_line_id_tbl(i) ));
1836: END IF;
1837:
1838: SELECT sum(nvl(ACCTD_AMOUNT_CR,0) - nvl(ACCTD_AMOUNT_DR,0))

Line 1848: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',

1844: AND ref_customer_trx_line_id = l_adj_trx_line_id_tbl(i)
1845: AND org_id = l_org_id_tbl(i);
1846:
1847: IF (g_level_statement>= g_current_runtime_level ) THEN
1848: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
1849: 'Debug: After Populating functional amount for Discount :'||to_char(l_func_curr_line_amt_tbl(i) ));
1850: END IF;
1851:
1852: ZX_AP_POPULATE_PKG.lookup_desc_meaning(

Line 1860: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',

1856: l_description);
1857: l_disc_class_mng_tbl(i) := l_meaning;
1858:
1859: IF (g_level_statement>= g_current_runtime_level ) THEN
1860: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
1861: 'Debug: After Populating class meaning for Discounts :'||to_char(l_disc_class_mng_tbl(i) ));
1862: END IF;
1863:
1864: BEGIN

Line 1874: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',

1870: AND applied_customer_trx_id = l_adj_trx_id_tbl(i)
1871: AND org_id = l_org_id_tbl(i) ;
1872:
1873: IF (g_level_statement>= g_current_runtime_level ) THEN
1874: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
1875: 'Debug: After Populating apply date for discount :'||l_disc_apply_date_tbl(i));
1876: END IF;
1877: EXCEPTION
1878: WHEN OTHERS THEN

Line 1881: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',

1877: EXCEPTION
1878: WHEN OTHERS THEN
1879: l_disc_apply_date_tbl(i) := NULL;
1880: IF (g_level_statement>= g_current_runtime_level ) THEN
1881: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
1882: 'Debug: In Exception setting Apply date to NULL');
1883: END IF;
1884: END;
1885: ELSE

Line 1894: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',

1890: AND customer_trx_line_id = l_trx_line_id_tbl(i)
1891: AND org_id = l_org_id_tbl(i);
1892:
1893: IF (g_level_statement>= g_current_runtime_level ) THEN
1894: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
1895: 'Debug: Populating functional amount for Transactions :'||to_char(l_func_curr_line_amt_tbl(i) ));
1896: END IF;
1897: END IF;
1898:

Line 1902: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',

1898:
1899: EXCEPTION
1900: WHEN OTHERS THEN
1901: IF (g_level_statement>= g_current_runtime_level ) THEN
1902: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
1903: 'Error in fetching data from ra_cust_trx_line_gl_dist_all for functional amount. Error Message : '
1904: ||substrb(SQLERRM,1,120) );
1905: END IF;
1906: END;

Line 1986: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',

1982:
1983: /*
1984: --Code for populating country code
1985: IF ( g_level_statement>= g_current_runtime_level ) THEN
1986: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
1987: 'Debug: Populating country code from tax reg num' );
1988: END IF;
1989:
1990: IF l_ship_to_site_tax_reg_num_tbl(i) is not null THEN

Line 2048: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',

2044: l_bill_to_tax_reg_num_tbl(i)),1,2));
2045: EXCEPTION
2046: WHEN OTHERS THEN
2047: IF (g_level_statement>= g_current_runtime_level ) THEN
2048: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
2049: 'Error in comparing the country code from the reg num. Error Message : '
2050: ||substrb(SQLERRM,1,120) );
2051: END IF;
2052: END;

Line 2103: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',

2099: l_bill_to_tax_reg_num_tbl(i)),3);
2100: END IF; */
2101: ELSE
2102: IF ( g_level_statement>= g_current_runtime_level ) THEN
2103: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
2104: 'Debug: Not repopulating country code' );
2105: END IF;
2106:
2107:

Line 2121: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',

2117: END IF;
2118: END LOOP;
2119:
2120: IF ( g_level_statement>= g_current_runtime_level ) THEN
2121: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
2122: ' Inserting Data into ZX_REP_TRX_JX_EXT_T ' );
2123: END IF;
2124:
2125: FORALL i in nvl(l_detail_tax_line_id_tbl.first,1)..nvl(l_detail_tax_line_id_tbl.last,0)

Line 2169: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',

2165: fnd_global.login_id,
2166: P_REQUEST_ID);
2167:
2168: IF ( g_level_statement>= g_current_runtime_level ) THEN
2169: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
2170: 'After insertion into zx_rep_trx_jx_ext_t ');
2171: END IF;
2172:
2173:

Line 2181: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',

2177: FROM zx_rep_trx_jx_ext_t ext
2178: WHERE ext.detail_tax_line_id = dtl.detail_tax_line_id);
2179:
2180: IF ( g_level_statement>= g_current_runtime_level ) THEN
2181: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
2182: 'After deleting data from zx_rep_trx_detail_t ' ||to_char(SQL%ROWCOUNT));
2183: END IF;
2184: END IF; -- Reporting codes parameters NULL check --
2185: END IF; -- report_name

Line 2190: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_CORE_AR',

2186: --End Bug 9031051
2187:
2188: IF P_REPORT_NAME = 'RXZXPFTR' THEN
2189: IF ( g_level_statement>= g_current_runtime_level ) THEN
2190: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_CORE_AR',
2191: 'P_REPORT_NAME: '||P_REPORT_NAME );
2192: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_CORE_AR',
2193: 'P_POSTING_STATUS : '|| P_POSTING_STATUS );
2194: END IF;

Line 2192: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_CORE_AR',

2188: IF P_REPORT_NAME = 'RXZXPFTR' THEN
2189: IF ( g_level_statement>= g_current_runtime_level ) THEN
2190: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_CORE_AR',
2191: 'P_REPORT_NAME: '||P_REPORT_NAME );
2192: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_CORE_AR',
2193: 'P_POSTING_STATUS : '|| P_POSTING_STATUS );
2194: END IF;
2195:
2196: IF P_TRL_GLOBAL_VARIABLES_REC.SUMMARY_LEVEL = 'TRANSACTION_DISTRIBUTION' THEN

Line 2203: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_CORE_AR',

2199: WHERE request_id = p_request_id
2200: AND NVL(gl_transfer_flag,'N') <>'Y';
2201:
2202: IF ( g_level_statement>= g_current_runtime_level ) THEN
2203: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_CORE_AR',
2204: 'No of Unposted transactions deleted from zx_rep_actg_ext_t: '|| sql%rowcount);
2205: END IF;
2206:
2207: DELETE FROM zx_rep_trx_detail_t dtl

Line 2213: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_CORE_AR',

2209: AND NOT EXISTS (SELECT 1 FROM zx_rep_actg_ext_t act
2210: WHERE act.detail_tax_line_id = dtl.detail_tax_line_id) ;
2211:
2212: IF ( g_level_statement>= g_current_runtime_level ) THEN
2213: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_CORE_AR',
2214: 'No of rows deleted from zx_rep_trx_detail_t: '|| sql%rowcount);
2215: END IF;
2216: ELSIF P_POSTING_STATUS = 'NOT_TRANSFERRED' THEN
2217: DELETE FROM zx_rep_actg_ext_t

Line 2221: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_CORE_AR',

2217: DELETE FROM zx_rep_actg_ext_t
2218: WHERE request_id = p_request_id
2219: AND NVL(gl_transfer_flag,'N') = 'Y';
2220: IF ( g_level_statement>= g_current_runtime_level ) THEN
2221: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_CORE_AR',
2222: 'No of posted transactions deleted from zx_rep_actg_ext_t: '|| sql%rowcount);
2223: END IF;
2224: DELETE FROM zx_rep_trx_detail_t dtl
2225: WHERE dtl.request_id = p_request_id

Line 2231: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_CORE_AR',

2227: AND NOT EXISTS (SELECT 1 FROM zx_rep_actg_ext_t act
2228: WHERE act.detail_tax_line_id = dtl.detail_tax_line_id);
2229:
2230: IF ( g_level_statement>= g_current_runtime_level ) THEN
2231: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_CORE_AR',
2232: 'No of rows deleted from zx_rep_trx_detail_t: '|| sql%rowcount);
2233: END IF;
2234: END IF;
2235: END IF; -- Summary Level --

Line 2279: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',

2275: */
2276: END;
2277:
2278: IF ( g_level_statement>= g_current_runtime_level ) THEN
2279: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
2280: 'Count fetched : '||to_char(nvl(l_detail_tax_line_id_tbl.count,0)) );
2281: END IF;
2282:
2283: FOR i in 1..l_trx_id_tbl.last LOOP

Line 2320: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',

2316: l_state_tbl(i),
2317: l_geo_val_found);
2318:
2319: IF ( g_level_statement>= g_current_runtime_level ) THEN
2320: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
2321: 'l_geo_val_found : '||arp_trx_util.boolean_to_varchar2(l_geo_val_found));
2322: END IF;
2323:
2324: IF l_geo_val_found THEN

Line 2349: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',

2345: FROM ZX_EVNT_CLS_MAPPINGS zxevntclsmap
2346: WHERE zxevntclsmap.event_class_mapping_id = l_event_class_mapping_id_tbl(i);
2347:
2348: IF ( g_level_statement>= g_current_runtime_level ) THEN
2349: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
2350: 'Rows fetched from ZX_EVNT_CLS_MAPPINGS : '||to_char(SQL%ROWCOUNT) );
2351: END IF;
2352: EXCEPTION
2353: WHEN OTHERS THEN

Line 2356: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',

2352: EXCEPTION
2353: WHEN OTHERS THEN
2354: null;
2355: IF ( g_level_statement>= g_current_runtime_level ) THEN
2356: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
2357: 'Error Message ZX_EVNT_CLS_MAPPINGS : '||substrb(SQLERRM,1,120) );
2358: END IF;
2359: /*
2360: IF PG_DEBUG = 'Y' THEN

Line 2371: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',

2367:
2368: BEGIN
2369:
2370: IF ( g_level_statement>= g_current_runtime_level ) THEN
2371: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
2372: 'Before call to ZX_TCM_GEO_JUR_PKG.populate_loc_geography_info ');
2373: END IF;
2374:
2375: ZX_TCM_GEO_JUR_PKG.populate_loc_geography_info

Line 2387: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',

2383: EXCEPTION
2384: WHEN OTHERS THEN
2385: null;
2386: IF ( g_level_statement>= g_current_runtime_level ) THEN
2387: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
2388: 'Error Message : ZX_TCM_GEO_JUR_PKG.populate_loc_geography_info : '||substrb(SQLERRM,1,120) );
2389: END IF;
2390: /*
2391: IF PG_DEBUG = 'Y' THEN

Line 2408: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',

2404: l_state_tbl(i),
2405: l_geo_val_found);
2406:
2407: IF ( g_level_statement>= g_current_runtime_level ) THEN
2408: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
2409: 'Retrieved geo_value for STATE : '||l_state_tbl(i) ||' l_geo_val_found : '||arp_trx_util.boolean_to_varchar2(l_geo_val_found));
2410: END IF;
2411:
2412: END IF;

Line 2424: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',

2420: l_county_tbl(i),
2421: l_geo_val_found);
2422:
2423: IF ( g_level_statement>= g_current_runtime_level ) THEN
2424: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
2425: 'Retrieved geo_value for COUNTY : '||l_county_tbl(i) ||' l_geo_val_found : '||arp_trx_util.boolean_to_varchar2(l_geo_val_found));
2426: END IF;
2427:
2428: RETRIEVE_GEO_VALUE(l_event_class_mapping_id_tbl(i),

Line 2439: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',

2435: l_city_tbl(i),
2436: l_geo_val_found);
2437:
2438: IF ( g_level_statement>= g_current_runtime_level ) THEN
2439: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
2440: 'Retrieved geo_value for CITY : '||l_city_tbl(i) ||' l_geo_val_found : '||arp_trx_util.boolean_to_varchar2(l_geo_val_found));
2441: END IF;
2442:
2443:

Line 2474: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',

2470: fnd_global.login_id,
2471: p_request_id);
2472:
2473: IF ( g_level_statement>= g_current_runtime_level ) THEN
2474: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
2475: 'After insertion into zx_rep_trx_jx_ext_t ');
2476: END IF;
2477:
2478: -- Delete Unwanted lines from Detail ITF

Line 2488: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',

2484: FROM zx_rep_trx_jx_ext_t ext
2485: WHERE ext.detail_tax_line_id = itf.detail_tax_line_id);
2486:
2487: IF ( g_level_statement>= g_current_runtime_level ) THEN
2488: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
2489: 'After deletion from zx_rep_trx_detail_t : '||to_char(SQL%ROWCOUNT) );
2490: END IF;
2491:
2492: EXCEPTION

Line 2496: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',

2492: EXCEPTION
2493: WHEN OTHERS THEN
2494: null;
2495: IF ( g_level_statement>= g_current_runtime_level ) THEN
2496: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
2497: 'Error Message for report '||p_report_name ||' : '||substrb(SQLERRM,1,120) );
2498: END IF;
2499: /*
2500: IF PG_DEBUG = 'Y' THEN

Line 2523: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',

2519: */
2520:
2521: -- Introduced for the bug#7638536 ---
2522: IF ( g_level_statement>= g_current_runtime_level ) THEN
2523: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
2524: 'P_POSTING_STATUS: '||P_POSTING_STATUS);
2525: END IF;
2526:
2527:

Line 2553: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',

2549:
2550:
2551:
2552: IF ( g_level_statement>= g_current_runtime_level ) THEN
2553: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
2554: 'P_TRL_GLOBAL_VARIABLES_REC.GL_DATE_LOW : '||P_TRL_GLOBAL_VARIABLES_REC.GL_DATE_LOW);
2555: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
2556: 'P_TRL_GLOBAL_VARIABLES_REC.GL_DATE_HIGH : '||P_TRL_GLOBAL_VARIABLES_REC.GL_DATE_HIGH);
2557: END IF;

Line 2555: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',

2551:
2552: IF ( g_level_statement>= g_current_runtime_level ) THEN
2553: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
2554: 'P_TRL_GLOBAL_VARIABLES_REC.GL_DATE_LOW : '||P_TRL_GLOBAL_VARIABLES_REC.GL_DATE_LOW);
2555: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
2556: 'P_TRL_GLOBAL_VARIABLES_REC.GL_DATE_HIGH : '||P_TRL_GLOBAL_VARIABLES_REC.GL_DATE_HIGH);
2557: END IF;
2558: select gl.period_name
2559: into l_period_from

Line 2589: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',

2585: and gl.application_id = 222
2586: and rownum = 1;
2587: */
2588: IF ( g_level_statement>= g_current_runtime_level ) THEN
2589: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
2590: 'P_TRL_GLOBAL_VARIABLES_REC.GL_DATE_HIGH : '||P_TRL_GLOBAL_VARIABLES_REC.GL_DATE_HIGH);
2591: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
2592: 'P_TRL_GLOBAL_VARIABLES_REC.GL_DATE_LOW : '||P_TRL_GLOBAL_VARIABLES_REC.GL_DATE_LOW);
2593: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',

Line 2591: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',

2587: */
2588: IF ( g_level_statement>= g_current_runtime_level ) THEN
2589: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
2590: 'P_TRL_GLOBAL_VARIABLES_REC.GL_DATE_HIGH : '||P_TRL_GLOBAL_VARIABLES_REC.GL_DATE_HIGH);
2591: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
2592: 'P_TRL_GLOBAL_VARIABLES_REC.GL_DATE_LOW : '||P_TRL_GLOBAL_VARIABLES_REC.GL_DATE_LOW);
2593: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
2594: 'l_set_of_books_id : '||l_set_of_books_id);
2595: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',

Line 2593: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',

2589: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
2590: 'P_TRL_GLOBAL_VARIABLES_REC.GL_DATE_HIGH : '||P_TRL_GLOBAL_VARIABLES_REC.GL_DATE_HIGH);
2591: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
2592: 'P_TRL_GLOBAL_VARIABLES_REC.GL_DATE_LOW : '||P_TRL_GLOBAL_VARIABLES_REC.GL_DATE_LOW);
2593: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
2594: 'l_set_of_books_id : '||l_set_of_books_id);
2595: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
2596: 'l_period_from : '||l_period_from);
2597: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR', 'l_period_to : '||l_end_period_tbl(1));

Line 2595: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',

2591: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
2592: 'P_TRL_GLOBAL_VARIABLES_REC.GL_DATE_LOW : '||P_TRL_GLOBAL_VARIABLES_REC.GL_DATE_LOW);
2593: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
2594: 'l_set_of_books_id : '||l_set_of_books_id);
2595: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
2596: 'l_period_from : '||l_period_from);
2597: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR', 'l_period_to : '||l_end_period_tbl(1));
2598: END IF;
2599: EXCEPTION WHEN OTHERS THEN

Line 2597: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR', 'l_period_to : '||l_end_period_tbl(1));

2593: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
2594: 'l_set_of_books_id : '||l_set_of_books_id);
2595: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
2596: 'l_period_from : '||l_period_from);
2597: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR', 'l_period_to : '||l_end_period_tbl(1));
2598: END IF;
2599: EXCEPTION WHEN OTHERS THEN
2600: NULL ;
2601: IF ( g_level_statement>= g_current_runtime_level ) THEN

Line 2602: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',

2598: END IF;
2599: EXCEPTION WHEN OTHERS THEN
2600: NULL ;
2601: IF ( g_level_statement>= g_current_runtime_level ) THEN
2602: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
2603: 'Error Message for report '||p_report_name ||' : '||substrb(SQLERRM,1,120) );
2604: END IF;
2605: END ;
2606:

Line 2626: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',

2622: -- from gl_sets_of_books gl, ar_system_parameters ar
2623: -- where gl.set_of_books_id = ar.set_of_books_id;
2624:
2625: IF ( g_level_statement>= g_current_runtime_level ) THEN
2626: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
2627: 'Before calling fa_rx_flex_pkg.flex_sql to get balancing segment ' );
2628: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
2629: 'l_CHART_OF_ACCOUNTS_ID : '||l_CHART_OF_ACCOUNTS_ID);
2630: END IF;

Line 2628: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',

2624:
2625: IF ( g_level_statement>= g_current_runtime_level ) THEN
2626: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
2627: 'Before calling fa_rx_flex_pkg.flex_sql to get balancing segment ' );
2628: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
2629: 'l_CHART_OF_ACCOUNTS_ID : '||l_CHART_OF_ACCOUNTS_ID);
2630: END IF;
2631:
2632: l_balancing_segment := fa_rx_flex_pkg.flex_sql

Line 2645: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',

2641:
2642: SELECT to_number(SubStr(l_balancing_segment,8)) INTO L_SEG_NUM FROM dual;
2643:
2644: IF ( g_level_statement>= g_current_runtime_level ) THEN
2645: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
2646: 'l_balancing_segment : '||l_balancing_segment);
2647: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
2648: 'L_SEG_NUM : '||L_SEG_NUM);
2649: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',

Line 2647: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',

2643:
2644: IF ( g_level_statement>= g_current_runtime_level ) THEN
2645: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
2646: 'l_balancing_segment : '||l_balancing_segment);
2647: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
2648: 'L_SEG_NUM : '||L_SEG_NUM);
2649: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
2650: 'Before calling fnd_flex_apis.get_segment_info to get the Balancing Seg prompt' );
2651: END IF;

Line 2649: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',

2645: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
2646: 'l_balancing_segment : '||l_balancing_segment);
2647: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
2648: 'L_SEG_NUM : '||L_SEG_NUM);
2649: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
2650: 'Before calling fnd_flex_apis.get_segment_info to get the Balancing Seg prompt' );
2651: END IF;
2652:
2653: l_bool := fnd_flex_apis.get_segment_info(

Line 2665: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',

2661: x_value_set_name => l_value_set_name
2662: );
2663:
2664: IF ( g_level_statement>= g_current_runtime_level ) THEN
2665: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
2666: 'l_prompt : '||l_prompt);
2667: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
2668: 'l_seg_name : '||l_seg_name);
2669: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',

Line 2667: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',

2663:
2664: IF ( g_level_statement>= g_current_runtime_level ) THEN
2665: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
2666: 'l_prompt : '||l_prompt);
2667: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
2668: 'l_seg_name : '||l_seg_name);
2669: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
2670: 'l_value_set_name : '||l_value_set_name);
2671: END IF;

Line 2669: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',

2665: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
2666: 'l_prompt : '||l_prompt);
2667: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
2668: 'l_seg_name : '||l_seg_name);
2669: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
2670: 'l_value_set_name : '||l_value_set_name);
2671: END IF;
2672:
2673: SELECT

Line 2690: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',

2686: WHERE det.request_id = p_request_id
2687: AND det.DETAIL_TAX_LINE_ID = ACT.DETAIL_TAX_LINE_ID(+);
2688:
2689: IF ( g_level_statement>= g_current_runtime_level ) THEN
2690: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
2691: 'Count fetched : '||to_char(nvl(l_detail_tax_line_id_tbl.count,0)) );
2692: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
2693: 'Before calling ARP_STANDARD.gl_activity to get the gl_activity value.' );
2694: END IF;

Line 2692: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',

2688:
2689: IF ( g_level_statement>= g_current_runtime_level ) THEN
2690: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
2691: 'Count fetched : '||to_char(nvl(l_detail_tax_line_id_tbl.count,0)) );
2692: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
2693: 'Before calling ARP_STANDARD.gl_activity to get the gl_activity value.' );
2694: END IF;
2695:
2696: FOR i IN 1..nvl(l_detail_tax_line_id_tbl.COUNT,0)

Line 2718: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',

2714: l_period_net_cr_tbl(i));
2715:
2716: t_gl_activity_tbl(L_CCID_TBL(i)) := l_period_net_dr_tbl(i) - l_period_net_cr_tbl(i);
2717: IF ( g_level_statement>= g_current_runtime_level ) THEN
2718: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
2719: 'l_period_net_dr_tbl : '||to_char(l_period_net_dr_tbl(i))||'-'||to_char(l_period_net_cr_tbl(i)));
2720: END IF;
2721:
2722:

Line 2759: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',

2755: p_request_id
2756: );
2757:
2758: IF ( g_level_statement>= g_current_runtime_level ) THEN
2759: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
2760: 'After insertion into zx_rep_trx_jx_ext_t ');
2761: END IF;
2762:
2763: EXCEPTION WHEN OTHERS THEN

Line 2766: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',

2762:
2763: EXCEPTION WHEN OTHERS THEN
2764: -- NULL ;
2765: IF ( g_level_statement>= g_current_runtime_level ) THEN
2766: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
2767: 'Error Message for report '||p_report_name ||' : '||substrb(SQLERRM,1,120) );
2768: END IF;
2769: END;
2770:

Line 2793: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',

2789: AND cash.application_type = 'CASH';
2790:
2791:
2792: IF ( g_level_statement>= g_current_runtime_level ) THEN
2793: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
2794: 'Count fetched : '||to_char(nvl(l_detail_tax_line_id_tbl.count,0)) );
2795:
2796: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
2797: 'Before Call to GET_RECEIVED_AMOUNTS procedure ' );

Line 2796: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',

2792: IF ( g_level_statement>= g_current_runtime_level ) THEN
2793: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
2794: 'Count fetched : '||to_char(nvl(l_detail_tax_line_id_tbl.count,0)) );
2795:
2796: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
2797: 'Before Call to GET_RECEIVED_AMOUNTS procedure ' );
2798: END IF;
2799:
2800:

Line 2834: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',

2830: fnd_global.login_id,
2831: p_request_id);
2832:
2833: IF ( g_level_statement>= g_current_runtime_level ) THEN
2834: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
2835: 'After insertion into zx_rep_trx_jx_ext_t ');
2836: END IF;
2837:
2838: DELETE FROM zx_rep_trx_detail_t dtl

Line 2845: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',

2841: FROM zx_rep_trx_jx_ext_t ext
2842: WHERE ext.detail_tax_line_id = dtl.detail_tax_line_id);
2843:
2844: IF ( g_level_statement>= g_current_runtime_level ) THEN
2845: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
2846: 'After deleting data from zx_rep_trx_detail_t ' ||to_char(SQL%ROWCOUNT));
2847: END IF;
2848:
2849: END IF ;

Line 2855: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',

2851: EXCEPTION
2852: WHEN OTHERS THEN
2853: -- null;
2854: IF ( g_level_statement>= g_current_runtime_level ) THEN
2855: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
2856: 'Error Message for report '||p_report_name ||' : '||substrb(SQLERRM,1,120) );
2857: END IF;
2858: /*
2859: IF PG_DEBUG = 'Y' THEN

Line 2865: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR.BEGIN',

2861: arp_standard.debug('ZX_XX_EXTRACT_PKG.populate_us_sales_tax_rep_ext.'||p_report_name || '.'||l_err_msg);
2862: END IF;
2863: */
2864: IF (g_level_procedure >= g_current_runtime_level ) THEN
2865: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR.BEGIN',
2866: 'ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR(-)');
2867: END IF;
2868:
2869: END POPULATE_CORE_AR;