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 ZX_CORE_REP_EXTRACT_PKG

Line 1: PACKAGE BODY ZX_CORE_REP_EXTRACT_PKG AS

1: PACKAGE BODY ZX_CORE_REP_EXTRACT_PKG AS
2: /* $Header: zxricoreplugpvtb.pls 120.12.12010000.3 2008/11/12 12:43:21 spasala ship $ */
3:
4:
5: -----------------------------------------

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

160: -- g_level_statement := FND_LOG.LEVEL_STATEMENT;
161: -- g_level_procedure := FND_LOG.LEVEL_PROCEDURE;
162:
163: IF (g_level_procedure >= g_current_runtime_level ) THEN
164: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP.BEGIN',
165: 'ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP(+)');
166: END IF;
167:
168: p_request_id := P_TRL_GLOBAL_VARIABLES_REC.REQUEST_ID;

Line 165: 'ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP(+)');

161: -- g_level_procedure := FND_LOG.LEVEL_PROCEDURE;
162:
163: IF (g_level_procedure >= g_current_runtime_level ) THEN
164: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP.BEGIN',
165: 'ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP(+)');
166: END IF;
167:
168: p_request_id := P_TRL_GLOBAL_VARIABLES_REC.REQUEST_ID;
169: p_report_name := P_TRL_GLOBAL_VARIABLES_REC.REPORT_NAME;

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

170: p_legal_entity_id := P_TRL_GLOBAL_VARIABLES_REC.LEGAL_ENTITY_ID;
171: p_product := P_TRL_GLOBAL_VARIABLES_REC.PRODUCT;
172:
173: IF (g_level_statement >= g_current_runtime_level ) THEN
174: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP',
175: 'p_report_name : '||P_REPORT_NAME);
176: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP',
177: 'p_request_id : '||p_request_id);
178: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP',

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

172:
173: IF (g_level_statement >= g_current_runtime_level ) THEN
174: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP',
175: 'p_report_name : '||P_REPORT_NAME);
176: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP',
177: 'p_request_id : '||p_request_id);
178: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP',
179: 'p_legal_entity_id : '||p_legal_entity_id);
180: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP',

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

174: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP',
175: 'p_report_name : '||P_REPORT_NAME);
176: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP',
177: 'p_request_id : '||p_request_id);
178: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP',
179: 'p_legal_entity_id : '||p_legal_entity_id);
180: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP',
181: 'p_product : '||p_product);
182: END IF;

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

176: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP',
177: 'p_request_id : '||p_request_id);
178: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP',
179: 'p_legal_entity_id : '||p_legal_entity_id);
180: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP',
181: 'p_product : '||p_product);
182: END IF;
183:
184:

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

210: AND ah.release_lookup_code IS NULL )
211: AND dtl.request_id = p_request_id);
212:
213: IF (g_level_statement >= g_current_runtime_level ) THEN
214: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP',
215: 'Insertion for Hold , ext.attribute1 : '||to_char(SQL%ROWCOUNT) );
216: END IF;
217:
218: --Bug 5251425 : To get the C_TRX_CURRENCY_DESC ( ext.attribute9) and the C_BATCH_NAME ( ext.attribute8 ) for the Invoice .

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

245: AND dtl.tax_rate_id = rates.tax_rate_id(+)
246: AND acc.TAX_ACCOUNT_ENTITY_ID(+) = rates.tax_rate_id;
247:
248: IF (g_level_statement >= g_current_runtime_level ) THEN
249: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP',
250: 'Count fetched : '||to_char(nvl(l_detail_tax_line_id_tbl.count,0)) );
251: END IF;
252: --Get details for C_MATCH
253:

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

257: l_match_tbl
258: );
259:
260: IF (g_level_statement >= g_current_runtime_level ) THEN
261: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP',
262: 'Before insertion into zx_rep_trx_jx_ext_t for report '||p_report_name );
263: END IF;
264:
265: FORALL i IN nvl(l_detail_tax_line_id_tbl.FIRST,1)..nvl(l_detail_tax_line_id_tbl.LAST,0)

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

298: EXCEPTION
299: WHEN OTHERS THEN
300: -- NULL ;
301: IF (g_level_statement >= g_current_runtime_level ) THEN
302: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP',
303: 'Error Message for report '||p_report_name ||' : '||substrb(SQLERRM,1,120) );
304: END IF;
305: END;
306: END IF;

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

310: OPEN establishment_id_csr (p_legal_entity_id);
311: FETCH establishment_id_csr INTO l_establishment_id;
312:
313: IF (g_level_statement >= g_current_runtime_level ) THEN
314: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP',
315: 'l_establishment_id : '||l_establishment_id);
316: END IF;
317:
318: -- ------------------------------------------------ --

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

346: AND rep_code.reporting_code_char_value <> dtl.billing_tp_country
347: AND dtl.request_id = p_request_id;
348:
349: IF (g_level_statement >= g_current_runtime_level ) THEN
350: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP',
351: 'Count fetched : '||to_char(nvl(l_detail_tax_line_id_tbl.count,0)) );
352: END IF;
353:
354: -- Note : Need to add xle_associations_v view to the above query for establishment_id join

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

361: l_territory_short_name_tbl,
362: l_alternate_territory_name_tbl);
363:
364: IF (g_level_statement >= g_current_runtime_level ) THEN
365: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP',
366: 'After getting the territory info.' );
367: END IF;
368:
369: GET_ORG_VAT_NUM ( l_detail_tax_line_id_tbl,

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

370: l_establishment_id,
371: l_org_vat_num_tbl);
372:
373: IF (g_level_statement >= g_current_runtime_level ) THEN
374: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP',
375: 'After getting the org_vat_num' );
376: END IF;
377:
378:

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

385: l_created_by_tbl
386: );
387:
388: IF (g_level_statement >= g_current_runtime_level ) THEN
389: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP',
390: 'After getting the created_by for invoice' );
391: END IF;
392:
393:

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

397: l_ou_desc_tbl
398: );
399:
400: IF (g_level_statement >= g_current_runtime_level ) THEN
401: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP',
402: 'After getting the OU Description.' );
403: END IF;
404:
405:

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

431: sysdate,
432: fnd_global.login_id);
433:
434: IF (g_level_statement >= g_current_runtime_level ) THEN
435: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP',
436: 'After insertion into zx_rep_trx_jx_ext_t for report '||p_report_name );
437: END IF;
438:
439: -- Delete Unwanted lines from Detail ITF

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

444: FROM zx_rep_trx_jx_ext_t ext
445: WHERE ext.detail_tax_line_id = itf.detail_tax_line_id);
446:
447: IF (g_level_statement >= g_current_runtime_level ) THEN
448: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP',
449: 'After deletion from zx_rep_trx_detail_t : '||to_char(SQL%ROWCOUNT) );
450: END IF;
451: END IF ;
452:

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

453: EXCEPTION
454: WHEN OTHERS THEN
455: NULL;
456: IF (g_level_statement >= g_current_runtime_level ) THEN
457: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP',
458: 'Error Message for report '||p_report_name ||' : '||substrb(SQLERRM,1,120) );
459: END IF;
460:
461: END;

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

474: FROM zx_rep_trx_detail_t dtl
475: WHERE dtl.request_id = p_request_id;
476:
477: IF (g_level_statement >= g_current_runtime_level ) THEN
478: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP',
479: 'Count fetched : '||to_char(nvl(l_detail_tax_line_id_tbl.count,0)) );
480: END IF;
481:
482: adjustment_tax_code(

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

484: l_tax_rate_code_tbl,
485: l_adj_tax_code_tbl);
486:
487: IF (g_level_statement >= g_current_runtime_level ) THEN
488: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP',
489: 'After getting adjustment tax code for Italy, Poland, Portugal countries');
490: END IF;
491:
492: FORALL i in l_detail_tax_line_id_tbl.first..l_detail_tax_line_id_tbl.last

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

508: sysdate,
509: fnd_global.login_id);
510:
511: IF (g_level_statement >= g_current_runtime_level ) THEN
512: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP',
513: 'After insertion into zx_rep_trx_jx_ext_t ');
514: END IF;
515:
516: EXCEPTION

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

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

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

524: END IF;
525:
526: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
527: IF (g_level_procedure >= g_current_runtime_level ) THEN
528: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP.BEGIN',
529: 'ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP(-)');
530: END IF;
531: null;
532:

Line 529: 'ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP(-)');

525:
526: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
527: IF (g_level_procedure >= g_current_runtime_level ) THEN
528: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP.BEGIN',
529: 'ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP(-)');
530: END IF;
531: null;
532:
533: END populate_core_ap;

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

557: WHEN OTHERS THEN
558: p_territory_short_name_tbl(i) := NULL ;
559: p_alternate_territory_name_tbl(i) := NULL ;
560: IF ( g_level_statement>= g_current_runtime_level ) THEN
561: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP',
562: 'Error Message : '||substrb(SQLERRM,1,120) );
563: END IF;
564: END;
565: END LOOP;

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

597: EXCEPTION
598: WHEN OTHERS THEN
599: p_org_vat_num_tbl(i) := NULL ;
600: IF ( g_level_statement>= g_current_runtime_level ) THEN
601: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP',
602: 'Error Message : '||substrb(SQLERRM,1,120) );
603: END IF;
604: END ;
605: END LOOP;

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

629: EXCEPTION
630: WHEN OTHERS THEN
631: p_adj_tax_code_tbl(i) := NULL ;
632: IF ( g_level_statement>= g_current_runtime_level ) THEN
633: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP',
634: 'Error Message : '||substrb(SQLERRM,1,120) );
635: END IF;
636: END ;
637: END LOOP;

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

697: EXCEPTION
698: WHEN OTHERS THEN
699: p_created_by_tbl(i) := NULL ;
700: IF ( g_level_statement>= g_current_runtime_level ) THEN
701: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
702: 'Error Message : '||substrb(SQLERRM,1,120) );
703: END IF;
704: END;
705: END LOOP;

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

726: EXCEPTION
727: WHEN OTHERS THEN
728: p_ou_desc_tbl(i) := NULL ;
729: IF ( g_level_statement>= g_current_runtime_level ) THEN
730: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
731: 'Error Message : '||substrb(SQLERRM,1,120) );
732: END IF;
733: END;
734: END LOOP;

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

763: EXCEPTION
764: WHEN OTHERS THEN
765: p_match_tbl(i) := null;
766: IF ( g_level_statement>= g_current_runtime_level ) THEN
767: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
768: 'Error Message : '||substrb(SQLERRM,1,120) );
769: END IF;
770: END;
771: END LOOP;

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

816: l_amount_recvd_tbl(p_trx_id_tbl(i)) := 0;
817: l_tax_amount_rcvd_tbl(p_trx_id_tbl(i)) := 0;
818:
819: IF ( g_level_statement>= g_current_runtime_level ) THEN
820: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
821: 'Error Message : '||substrb(SQLERRM,1,120) );
822: END IF;
823: END ;
824: p_amount_received_tbl(i) := l_amount_recvd_tbl(p_trx_id_tbl(i));

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

940: -- END IF;
941: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
942:
943: IF (g_level_procedure >= g_current_runtime_level ) THEN
944: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP.BEGIN',
945: 'ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR(+)');
946: END IF;
947:
948:

Line 945: 'ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR(+)');

941: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
942:
943: IF (g_level_procedure >= g_current_runtime_level ) THEN
944: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP.BEGIN',
945: 'ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR(+)');
946: END IF;
947:
948:
949: -- Get necessary parameters from TRL Global Variables

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

952: P_REQUEST_ID := P_TRL_GLOBAL_VARIABLES_REC.REQUEST_ID;
953: prev_event_class_mapping_id := 0;
954:
955: IF (g_level_statement >= g_current_runtime_level ) THEN
956: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
957: 'p_report_name : '||P_REPORT_NAME);
958: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
959: 'p_request_id : '||p_request_id);
960: END IF;

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

954:
955: IF (g_level_statement >= g_current_runtime_level ) THEN
956: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
957: 'p_report_name : '||P_REPORT_NAME);
958: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
959: 'p_request_id : '||p_request_id);
960: END IF;
961:
962: IF P_REPORT_NAME = 'ARXSTR' THEN

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

1001: */
1002: END;
1003:
1004: IF ( g_level_statement>= g_current_runtime_level ) THEN
1005: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
1006: 'Count fetched : '||to_char(nvl(l_detail_tax_line_id_tbl.count,0)) );
1007: END IF;
1008:
1009: FOR i in 1..l_trx_id_tbl.last LOOP

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

1042: l_state_tbl(i),
1043: l_geo_val_found);
1044:
1045: IF ( g_level_statement>= g_current_runtime_level ) THEN
1046: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
1047: 'l_geo_val_found : '||arp_trx_util.boolean_to_varchar2(l_geo_val_found));
1048: END IF;
1049:
1050: IF l_geo_val_found THEN

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

1071: FROM ZX_EVNT_CLS_MAPPINGS zxevntclsmap
1072: WHERE zxevntclsmap.event_class_mapping_id = l_event_class_mapping_id_tbl(i);
1073:
1074: IF ( g_level_statement>= g_current_runtime_level ) THEN
1075: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
1076: 'Rows fetched from ZX_EVNT_CLS_MAPPINGS : '||to_char(SQL%ROWCOUNT) );
1077: END IF;
1078: EXCEPTION
1079: WHEN OTHERS THEN

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

1078: EXCEPTION
1079: WHEN OTHERS THEN
1080: null;
1081: IF ( g_level_statement>= g_current_runtime_level ) THEN
1082: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
1083: 'Error Message ZX_EVNT_CLS_MAPPINGS : '||substrb(SQLERRM,1,120) );
1084: END IF;
1085: /*
1086: IF PG_DEBUG = 'Y' THEN

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

1093:
1094: BEGIN
1095:
1096: IF ( g_level_statement>= g_current_runtime_level ) THEN
1097: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
1098: 'Before call to ZX_TCM_GEO_JUR_PKG.populate_loc_geography_info ');
1099: END IF;
1100:
1101: ZX_TCM_GEO_JUR_PKG.populate_loc_geography_info

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

1109: EXCEPTION
1110: WHEN OTHERS THEN
1111: null;
1112: IF ( g_level_statement>= g_current_runtime_level ) THEN
1113: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
1114: 'Error Message : ZX_TCM_GEO_JUR_PKG.populate_loc_geography_info : '||substrb(SQLERRM,1,120) );
1115: END IF;
1116: /*
1117: IF PG_DEBUG = 'Y' THEN

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

1130: l_state_tbl(i),
1131: l_geo_val_found);
1132:
1133: IF ( g_level_statement>= g_current_runtime_level ) THEN
1134: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
1135: 'Retrieved geo_value for STATE : '||l_state_tbl(i) ||' l_geo_val_found : '||arp_trx_util.boolean_to_varchar2(l_geo_val_found));
1136: END IF;
1137:
1138: END IF;

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

1146: l_county_tbl(i),
1147: l_geo_val_found);
1148:
1149: IF ( g_level_statement>= g_current_runtime_level ) THEN
1150: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
1151: 'Retrieved geo_value for COUNTY : '||l_county_tbl(i) ||' l_geo_val_found : '||arp_trx_util.boolean_to_varchar2(l_geo_val_found));
1152: END IF;
1153:
1154: RETRIEVE_GEO_VALUE(l_event_class_mapping_id_tbl(i),

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

1161: l_city_tbl(i),
1162: l_geo_val_found);
1163:
1164: IF ( g_level_statement>= g_current_runtime_level ) THEN
1165: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
1166: 'Retrieved geo_value for CITY : '||l_city_tbl(i) ||' l_geo_val_found : '||arp_trx_util.boolean_to_varchar2(l_geo_val_found));
1167: END IF;
1168:
1169:

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

1194: sysdate,
1195: fnd_global.login_id);
1196:
1197: IF ( g_level_statement>= g_current_runtime_level ) THEN
1198: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
1199: 'After insertion into zx_rep_trx_jx_ext_t ');
1200: END IF;
1201:
1202: -- Delete Unwanted lines from Detail ITF

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

1208: FROM zx_rep_trx_jx_ext_t ext
1209: WHERE ext.detail_tax_line_id = itf.detail_tax_line_id);
1210:
1211: IF ( g_level_statement>= g_current_runtime_level ) THEN
1212: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
1213: 'After deletion from zx_rep_trx_detail_t : '||to_char(SQL%ROWCOUNT) );
1214: END IF;
1215:
1216: EXCEPTION

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

1216: EXCEPTION
1217: WHEN OTHERS THEN
1218: null;
1219: IF ( g_level_statement>= g_current_runtime_level ) THEN
1220: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
1221: 'Error Message for report '||p_report_name ||' : '||substrb(SQLERRM,1,120) );
1222: END IF;
1223: /*
1224: IF PG_DEBUG = 'Y' THEN

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

1239: where gl.set_of_books_id = ar.set_of_books_id;
1240: */
1241:
1242: IF ( g_level_statement>= g_current_runtime_level ) THEN
1243: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
1244: 'P_TRL_GLOBAL_VARIABLES_REC.GL_DATE_LOW : '||P_TRL_GLOBAL_VARIABLES_REC.GL_DATE_LOW);
1245: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
1246: 'P_TRL_GLOBAL_VARIABLES_REC.GL_DATE_HIGH : '||P_TRL_GLOBAL_VARIABLES_REC.GL_DATE_HIGH);
1247: END IF;

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

1241:
1242: IF ( g_level_statement>= g_current_runtime_level ) THEN
1243: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
1244: 'P_TRL_GLOBAL_VARIABLES_REC.GL_DATE_LOW : '||P_TRL_GLOBAL_VARIABLES_REC.GL_DATE_LOW);
1245: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
1246: 'P_TRL_GLOBAL_VARIABLES_REC.GL_DATE_HIGH : '||P_TRL_GLOBAL_VARIABLES_REC.GL_DATE_HIGH);
1247: END IF;
1248: select gl.period_name
1249: into l_period_from

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

1265: and gl.application_id = 222
1266: and rownum = 1;
1267:
1268: IF ( g_level_statement>= g_current_runtime_level ) THEN
1269: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
1270: 'P_TRL_GLOBAL_VARIABLES_REC.GL_DATE_HIGH : '||P_TRL_GLOBAL_VARIABLES_REC.GL_DATE_HIGH);
1271: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
1272: 'P_TRL_GLOBAL_VARIABLES_REC.GL_DATE_LOW : '||P_TRL_GLOBAL_VARIABLES_REC.GL_DATE_LOW);
1273: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',

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

1267:
1268: IF ( g_level_statement>= g_current_runtime_level ) THEN
1269: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
1270: 'P_TRL_GLOBAL_VARIABLES_REC.GL_DATE_HIGH : '||P_TRL_GLOBAL_VARIABLES_REC.GL_DATE_HIGH);
1271: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
1272: 'P_TRL_GLOBAL_VARIABLES_REC.GL_DATE_LOW : '||P_TRL_GLOBAL_VARIABLES_REC.GL_DATE_LOW);
1273: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
1274: 'l_set_of_books_id : '||l_set_of_books_id);
1275: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',

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

1269: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
1270: 'P_TRL_GLOBAL_VARIABLES_REC.GL_DATE_HIGH : '||P_TRL_GLOBAL_VARIABLES_REC.GL_DATE_HIGH);
1271: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
1272: 'P_TRL_GLOBAL_VARIABLES_REC.GL_DATE_LOW : '||P_TRL_GLOBAL_VARIABLES_REC.GL_DATE_LOW);
1273: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
1274: 'l_set_of_books_id : '||l_set_of_books_id);
1275: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
1276: 'l_period_from : '||l_period_from);
1277: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',

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

1271: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
1272: 'P_TRL_GLOBAL_VARIABLES_REC.GL_DATE_LOW : '||P_TRL_GLOBAL_VARIABLES_REC.GL_DATE_LOW);
1273: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
1274: 'l_set_of_books_id : '||l_set_of_books_id);
1275: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
1276: 'l_period_from : '||l_period_from);
1277: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
1278: 'l_period_to : '||l_period_to);
1279: END IF;

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

1273: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
1274: 'l_set_of_books_id : '||l_set_of_books_id);
1275: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
1276: 'l_period_from : '||l_period_from);
1277: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
1278: 'l_period_to : '||l_period_to);
1279: END IF;
1280: EXCEPTION WHEN OTHERS THEN
1281: NULL ;

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

1279: END IF;
1280: EXCEPTION WHEN OTHERS THEN
1281: NULL ;
1282: IF ( g_level_statement>= g_current_runtime_level ) THEN
1283: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
1284: 'Error Message for report '||p_report_name ||' : '||substrb(SQLERRM,1,120) );
1285: END IF;
1286: END ;
1287:

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

1303: -- from gl_sets_of_books gl, ar_system_parameters ar
1304: -- where gl.set_of_books_id = ar.set_of_books_id;
1305:
1306: IF ( g_level_statement>= g_current_runtime_level ) THEN
1307: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
1308: 'Before calling fa_rx_flex_pkg.flex_sql to get balancing segment ' );
1309: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
1310: 'l_CHART_OF_ACCOUNTS_ID : '||l_CHART_OF_ACCOUNTS_ID);
1311: END IF;

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

1305:
1306: IF ( g_level_statement>= g_current_runtime_level ) THEN
1307: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
1308: 'Before calling fa_rx_flex_pkg.flex_sql to get balancing segment ' );
1309: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
1310: 'l_CHART_OF_ACCOUNTS_ID : '||l_CHART_OF_ACCOUNTS_ID);
1311: END IF;
1312:
1313: l_balancing_segment := fa_rx_flex_pkg.flex_sql

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

1322:
1323: SELECT to_number(SubStr(l_balancing_segment,8)) INTO L_SEG_NUM FROM dual;
1324:
1325: IF ( g_level_statement>= g_current_runtime_level ) THEN
1326: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
1327: 'l_balancing_segment : '||l_balancing_segment);
1328: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
1329: 'L_SEG_NUM : '||L_SEG_NUM);
1330: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',

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

1324:
1325: IF ( g_level_statement>= g_current_runtime_level ) THEN
1326: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
1327: 'l_balancing_segment : '||l_balancing_segment);
1328: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
1329: 'L_SEG_NUM : '||L_SEG_NUM);
1330: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
1331: 'Before calling fnd_flex_apis.get_segment_info to get the Balancing Seg prompt' );
1332: END IF;

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

1326: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
1327: 'l_balancing_segment : '||l_balancing_segment);
1328: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
1329: 'L_SEG_NUM : '||L_SEG_NUM);
1330: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
1331: 'Before calling fnd_flex_apis.get_segment_info to get the Balancing Seg prompt' );
1332: END IF;
1333:
1334: l_bool := apps.fnd_flex_apis.get_segment_info(

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

1342: x_value_set_name => l_value_set_name
1343: );
1344:
1345: IF ( g_level_statement>= g_current_runtime_level ) THEN
1346: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
1347: 'l_prompt : '||l_prompt);
1348: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
1349: 'l_seg_name : '||l_seg_name);
1350: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',

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

1344:
1345: IF ( g_level_statement>= g_current_runtime_level ) THEN
1346: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
1347: 'l_prompt : '||l_prompt);
1348: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
1349: 'l_seg_name : '||l_seg_name);
1350: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
1351: 'l_value_set_name : '||l_value_set_name);
1352: END IF;

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

1346: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
1347: 'l_prompt : '||l_prompt);
1348: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
1349: 'l_seg_name : '||l_seg_name);
1350: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
1351: 'l_value_set_name : '||l_value_set_name);
1352: END IF;
1353:
1354: SELECT

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

1367: WHERE det.request_id = p_request_id
1368: AND det.DETAIL_TAX_LINE_ID = ACT.DETAIL_TAX_LINE_ID(+);
1369:
1370: IF ( g_level_statement>= g_current_runtime_level ) THEN
1371: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
1372: 'Count fetched : '||to_char(nvl(l_detail_tax_line_id_tbl.count,0)) );
1373: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
1374: 'Before calling ARP_STANDARD.gl_activity to get the gl_activity value.' );
1375: END IF;

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

1369:
1370: IF ( g_level_statement>= g_current_runtime_level ) THEN
1371: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
1372: 'Count fetched : '||to_char(nvl(l_detail_tax_line_id_tbl.count,0)) );
1373: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
1374: 'Before calling ARP_STANDARD.gl_activity to get the gl_activity value.' );
1375: END IF;
1376:
1377: FOR i IN 1..nvl(l_detail_tax_line_id_tbl.COUNT,0)

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

1395: l_period_net_cr_tbl(i));
1396:
1397: t_gl_activity_tbl(L_CCID_TBL(i)) := l_period_net_dr_tbl(i) - l_period_net_cr_tbl(i);
1398: IF ( g_level_statement>= g_current_runtime_level ) THEN
1399: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
1400: 'l_period_net_dr_tbl : '||to_char(l_period_net_dr_tbl(i))||'-'||to_char(l_period_net_cr_tbl(i)));
1401: END IF;
1402:
1403:

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

1434: fnd_global.login_id
1435: );
1436:
1437: IF ( g_level_statement>= g_current_runtime_level ) THEN
1438: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
1439: 'After insertion into zx_rep_trx_jx_ext_t ');
1440: END IF;
1441:
1442: EXCEPTION WHEN OTHERS THEN

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

1441:
1442: EXCEPTION WHEN OTHERS THEN
1443: -- NULL ;
1444: IF ( g_level_statement>= g_current_runtime_level ) THEN
1445: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
1446: 'Error Message for report '||p_report_name ||' : '||substrb(SQLERRM,1,120) );
1447: END IF;
1448: END;
1449:

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

1464: dtl.trx_id = cash.applied_customer_trx_id
1465: AND dtl.request_id = p_request_id ;
1466:
1467: IF ( g_level_statement>= g_current_runtime_level ) THEN
1468: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
1469: 'Count fetched : '||to_char(nvl(l_detail_tax_line_id_tbl.count,0)) );
1470:
1471: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
1472: 'Before Call to GET_RECEIVED_AMOUNTS procedure ' );

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

1467: IF ( g_level_statement>= g_current_runtime_level ) THEN
1468: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
1469: 'Count fetched : '||to_char(nvl(l_detail_tax_line_id_tbl.count,0)) );
1470:
1471: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
1472: 'Before Call to GET_RECEIVED_AMOUNTS procedure ' );
1473: END IF;
1474:
1475:

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

1503: sysdate,
1504: fnd_global.login_id);
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: 'After insertion into zx_rep_trx_jx_ext_t ');
1509: END IF;
1510:
1511:

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

1514: EXCEPTION
1515: WHEN OTHERS THEN
1516: -- null;
1517: IF ( g_level_statement>= g_current_runtime_level ) THEN
1518: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
1519: 'Error Message for report '||p_report_name ||' : '||substrb(SQLERRM,1,120) );
1520: END IF;
1521: /*
1522: IF PG_DEBUG = 'Y' THEN

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

1524: arp_standard.debug('ZX_XX_EXTRACT_PKG.populate_us_sales_tax_rep_ext.'||p_report_name || '.'||l_err_msg);
1525: END IF;
1526: */
1527: IF (g_level_procedure >= g_current_runtime_level ) THEN
1528: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR.BEGIN',
1529: 'ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR(-)');
1530: END IF;
1531:
1532: END POPULATE_CORE_AR;

Line 1529: 'ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR(-)');

1525: END IF;
1526: */
1527: IF (g_level_procedure >= g_current_runtime_level ) THEN
1528: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR.BEGIN',
1529: 'ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR(-)');
1530: END IF;
1531:
1532: END POPULATE_CORE_AR;
1533:

Line 1534: END ZX_CORE_REP_EXTRACT_PKG;

1530: END IF;
1531:
1532: END POPULATE_CORE_AR;
1533:
1534: END ZX_CORE_REP_EXTRACT_PKG;