[Home] [Help]
50: g_currency_code VARCHAR2(15);
51: l_accounting_segment VARCHAR2(25);
52:
53: g_current_runtime_level NUMBER ;
54: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
55: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
56: g_level_event CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
57: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
58: g_error_buffer VARCHAR2(100);
51: l_accounting_segment VARCHAR2(25);
52:
53: g_current_runtime_level NUMBER ;
54: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
55: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
56: g_level_event CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
57: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
58: g_error_buffer VARCHAR2(100);
59:
52:
53: g_current_runtime_level NUMBER ;
54: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
55: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
56: g_level_event CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
57: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
58: g_error_buffer VARCHAR2(100);
59:
60: PG_DEBUG VARCHAR2(1) := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
53: g_current_runtime_level NUMBER ;
54: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
55: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
56: g_level_event CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
57: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
58: g_error_buffer VARCHAR2(100);
59:
60: PG_DEBUG VARCHAR2(1) := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
61:
373: P_GL_OR_TRX_DATE_FILTER IN VARCHAR2 DEFAULT 'N') --Bug 5396444
374: IS
375: l_trl_global_variables_rec TRL_GLOBAL_VARIABLES_REC_TYPE;
376: BEGIN
377: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
378: -- g_current_runtime_level := 1;
379: -- g_level_procedure := 2;
380: IF (g_level_procedure >= g_current_runtime_level ) THEN
381: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.populate_tax_data.BEGIN',
377: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
378: -- g_current_runtime_level := 1;
379: -- g_level_procedure := 2;
380: IF (g_level_procedure >= g_current_runtime_level ) THEN
381: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.populate_tax_data.BEGIN',
382: 'ZX_EXTRACT_PKG:populate_tax_data(+)');
383: END IF;
384:
385: -- Initialize the parameters:
509: fnd_client_info.set_currency_context(p_ledger_id);
510: END IF;
511:
512: IF (g_level_procedure >= g_current_runtime_level ) THEN
513: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.populate_tax_data',
514: 'Return Code Check '||to_char(l_trl_global_variables_rec.retcode));
515: END IF;
516:
517: IF validate_parameters(l_trl_global_variables_rec) THEN
519: extract_rep_context_info(l_trl_global_variables_rec);
520: END IF;
521:
522: IF (g_level_procedure >= g_current_runtime_level ) THEN
523: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.populate_tax_data',
524: 'ZX.TRL.ZX_EXTRACT_PKG.EXTRACT_TAX_INFO Call');
525: END IF;
526:
527: IF l_trl_global_variables_rec.retcode <> 2 THEN
527: IF l_trl_global_variables_rec.retcode <> 2 THEN
528: extract_tax_info(g_ledger_type, l_trl_global_variables_rec);
529: END IF;
530: IF (g_level_procedure >= g_current_runtime_level ) THEN
531: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.populate_tax_data',
532: 'extract_additional_info call : '||to_char(l_trl_global_variables_rec.retcode));
533: END IF;
534: -- IF l_trl_global_variables_rec.retcode <> 2 THEN
535: extract_additional_info(g_ledger_type, l_trl_global_variables_rec) ;
556: END IF;
557: END IF;
558:
559: IF (g_level_procedure >= g_current_runtime_level ) THEN
560: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.Return Code ',
561: 'ZX_EXTRACT_PKG:populate_tax_data' ||to_char(l_trl_global_variables_rec.retcode));
562: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.populate_tax_data.END',
563: 'ZX_EXTRACT_PKG:populate_tax_data(-)');
564: END IF;
558:
559: IF (g_level_procedure >= g_current_runtime_level ) THEN
560: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.Return Code ',
561: 'ZX_EXTRACT_PKG:populate_tax_data' ||to_char(l_trl_global_variables_rec.retcode));
562: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.populate_tax_data.END',
563: 'ZX_EXTRACT_PKG:populate_tax_data(-)');
564: END IF;
565:
566: EXCEPTION
569: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
570: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','populate_tax_data- '|| g_error_buffer);
571: FND_MSG_PUB.Add;
572: IF (g_level_unexpected >= g_current_runtime_level ) THEN
573: FND_LOG.STRING(g_level_unexpected,
574: 'ZX.TRL.ZX_EXTRACT_PKG.populate_tax_data',
575: g_error_buffer);
576: END IF;
577:
722: BEGIN
723:
724:
725: IF (g_level_procedure >= g_current_runtime_level ) THEN
726: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE.BEGIN',
727: 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE(+)');
728:
729: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
730: 'P_REPORTING_LEVEL = '||P_REPORTING_LEVEL);
725: IF (g_level_procedure >= g_current_runtime_level ) THEN
726: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE.BEGIN',
727: 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE(+)');
728:
729: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
730: 'P_REPORTING_LEVEL = '||P_REPORTING_LEVEL);
731:
732:
733: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
729: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
730: 'P_REPORTING_LEVEL = '||P_REPORTING_LEVEL);
731:
732:
733: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
734: 'P_REPORTING_CONTEXT = '||P_REPORTING_CONTEXT);
735: /* apai
736: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
737: 'P_LEGAL_ENTITY_LEVEL = '||P_LEGAL_ENTITY_LEVEL);
732:
733: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
734: 'P_REPORTING_CONTEXT = '||P_REPORTING_CONTEXT);
735: /* apai
736: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
737: 'P_LEGAL_ENTITY_LEVEL = '||P_LEGAL_ENTITY_LEVEL);
738: */
739: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
740: 'P_LEGAL_ENTITY_ID = '||P_LEGAL_ENTITY_ID);
735: /* apai
736: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
737: 'P_LEGAL_ENTITY_LEVEL = '||P_LEGAL_ENTITY_LEVEL);
738: */
739: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
740: 'P_LEGAL_ENTITY_ID = '||P_LEGAL_ENTITY_ID);
741: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
742: 'P_SUMMARY_LEVEL = '||P_SUMMARY_LEVEL);
743: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
737: 'P_LEGAL_ENTITY_LEVEL = '||P_LEGAL_ENTITY_LEVEL);
738: */
739: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
740: 'P_LEGAL_ENTITY_ID = '||P_LEGAL_ENTITY_ID);
741: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
742: 'P_SUMMARY_LEVEL = '||P_SUMMARY_LEVEL);
743: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
744: 'P_LEDGER_ID = '||P_LEDGER_ID);
745: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
739: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
740: 'P_LEGAL_ENTITY_ID = '||P_LEGAL_ENTITY_ID);
741: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
742: 'P_SUMMARY_LEVEL = '||P_SUMMARY_LEVEL);
743: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
744: 'P_LEDGER_ID = '||P_LEDGER_ID);
745: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
746: 'P_REGISTER_TYPE = '||P_REGISTER_TYPE);
747: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
741: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
742: 'P_SUMMARY_LEVEL = '||P_SUMMARY_LEVEL);
743: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
744: 'P_LEDGER_ID = '||P_LEDGER_ID);
745: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
746: 'P_REGISTER_TYPE = '||P_REGISTER_TYPE);
747: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
748: 'P_PRODUCT = '||P_PRODUCT);
749: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
743: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
744: 'P_LEDGER_ID = '||P_LEDGER_ID);
745: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
746: 'P_REGISTER_TYPE = '||P_REGISTER_TYPE);
747: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
748: 'P_PRODUCT = '||P_PRODUCT);
749: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
750: 'P_MATRIX_REPORT = '||P_MATRIX_REPORT);
751: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
745: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
746: 'P_REGISTER_TYPE = '||P_REGISTER_TYPE);
747: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
748: 'P_PRODUCT = '||P_PRODUCT);
749: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
750: 'P_MATRIX_REPORT = '||P_MATRIX_REPORT);
751: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
752: 'P_CURRENCY_CODE_LOW = '||P_CURRENCY_CODE_LOW);
753: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
747: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
748: 'P_PRODUCT = '||P_PRODUCT);
749: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
750: 'P_MATRIX_REPORT = '||P_MATRIX_REPORT);
751: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
752: 'P_CURRENCY_CODE_LOW = '||P_CURRENCY_CODE_LOW);
753: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
754: 'P_CURRENCY_CODE_HIGH = '||P_CURRENCY_CODE_HIGH);
755: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
749: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
750: 'P_MATRIX_REPORT = '||P_MATRIX_REPORT);
751: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
752: 'P_CURRENCY_CODE_LOW = '||P_CURRENCY_CODE_LOW);
753: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
754: 'P_CURRENCY_CODE_HIGH = '||P_CURRENCY_CODE_HIGH);
755: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
756: 'P_INCLUDE_AP_STD_TRX_CLASS = '||P_INCLUDE_AP_STD_TRX_CLASS);
757: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
751: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
752: 'P_CURRENCY_CODE_LOW = '||P_CURRENCY_CODE_LOW);
753: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
754: 'P_CURRENCY_CODE_HIGH = '||P_CURRENCY_CODE_HIGH);
755: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
756: 'P_INCLUDE_AP_STD_TRX_CLASS = '||P_INCLUDE_AP_STD_TRX_CLASS);
757: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
758: 'P_INCLUDE_AP_DM_TRX_CLASS = '||P_INCLUDE_AP_DM_TRX_CLASS);
759: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
753: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
754: 'P_CURRENCY_CODE_HIGH = '||P_CURRENCY_CODE_HIGH);
755: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
756: 'P_INCLUDE_AP_STD_TRX_CLASS = '||P_INCLUDE_AP_STD_TRX_CLASS);
757: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
758: 'P_INCLUDE_AP_DM_TRX_CLASS = '||P_INCLUDE_AP_DM_TRX_CLASS);
759: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
760: 'P_INCLUDE_AP_CM_TRX_CLASS = '||P_INCLUDE_AP_CM_TRX_CLASS);
761: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
755: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
756: 'P_INCLUDE_AP_STD_TRX_CLASS = '||P_INCLUDE_AP_STD_TRX_CLASS);
757: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
758: 'P_INCLUDE_AP_DM_TRX_CLASS = '||P_INCLUDE_AP_DM_TRX_CLASS);
759: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
760: 'P_INCLUDE_AP_CM_TRX_CLASS = '||P_INCLUDE_AP_CM_TRX_CLASS);
761: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
762: 'P_INCLUDE_AP_PREP_TRX_CLASS = '||P_INCLUDE_AP_PREP_TRX_CLASS);
763: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
757: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
758: 'P_INCLUDE_AP_DM_TRX_CLASS = '||P_INCLUDE_AP_DM_TRX_CLASS);
759: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
760: 'P_INCLUDE_AP_CM_TRX_CLASS = '||P_INCLUDE_AP_CM_TRX_CLASS);
761: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
762: 'P_INCLUDE_AP_PREP_TRX_CLASS = '||P_INCLUDE_AP_PREP_TRX_CLASS);
763: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
764: 'P_INCLUDE_AP_MIX_TRX_CLASS = '||P_INCLUDE_AP_MIX_TRX_CLASS);
765: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
759: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
760: 'P_INCLUDE_AP_CM_TRX_CLASS = '||P_INCLUDE_AP_CM_TRX_CLASS);
761: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
762: 'P_INCLUDE_AP_PREP_TRX_CLASS = '||P_INCLUDE_AP_PREP_TRX_CLASS);
763: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
764: 'P_INCLUDE_AP_MIX_TRX_CLASS = '||P_INCLUDE_AP_MIX_TRX_CLASS);
765: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
766: 'P_INCLUDE_AP_EXP_TRX_CLASS = '||P_INCLUDE_AP_EXP_TRX_CLASS);
767: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
761: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
762: 'P_INCLUDE_AP_PREP_TRX_CLASS = '||P_INCLUDE_AP_PREP_TRX_CLASS);
763: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
764: 'P_INCLUDE_AP_MIX_TRX_CLASS = '||P_INCLUDE_AP_MIX_TRX_CLASS);
765: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
766: 'P_INCLUDE_AP_EXP_TRX_CLASS = '||P_INCLUDE_AP_EXP_TRX_CLASS);
767: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
768: 'P_INCLUDE_AP_INT_TRX_CLASS = '||P_INCLUDE_AP_INT_TRX_CLASS);
769: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
763: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
764: 'P_INCLUDE_AP_MIX_TRX_CLASS = '||P_INCLUDE_AP_MIX_TRX_CLASS);
765: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
766: 'P_INCLUDE_AP_EXP_TRX_CLASS = '||P_INCLUDE_AP_EXP_TRX_CLASS);
767: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
768: 'P_INCLUDE_AP_INT_TRX_CLASS = '||P_INCLUDE_AP_INT_TRX_CLASS);
769: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
770: 'P_INCLUDE_AR_INV_TRX_CLASS = '||P_INCLUDE_AR_INV_TRX_CLASS);
771: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
765: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
766: 'P_INCLUDE_AP_EXP_TRX_CLASS = '||P_INCLUDE_AP_EXP_TRX_CLASS);
767: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
768: 'P_INCLUDE_AP_INT_TRX_CLASS = '||P_INCLUDE_AP_INT_TRX_CLASS);
769: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
770: 'P_INCLUDE_AR_INV_TRX_CLASS = '||P_INCLUDE_AR_INV_TRX_CLASS);
771: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
772: 'P_INCLUDE_AR_APPL_TRX_CLASS = '||P_INCLUDE_AR_APPL_TRX_CLASS);
773: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
767: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
768: 'P_INCLUDE_AP_INT_TRX_CLASS = '||P_INCLUDE_AP_INT_TRX_CLASS);
769: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
770: 'P_INCLUDE_AR_INV_TRX_CLASS = '||P_INCLUDE_AR_INV_TRX_CLASS);
771: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
772: 'P_INCLUDE_AR_APPL_TRX_CLASS = '||P_INCLUDE_AR_APPL_TRX_CLASS);
773: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
774: 'P_INCLUDE_AR_ADJ_TRX_CLASS = '||P_INCLUDE_AR_ADJ_TRX_CLASS);
775: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
769: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
770: 'P_INCLUDE_AR_INV_TRX_CLASS = '||P_INCLUDE_AR_INV_TRX_CLASS);
771: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
772: 'P_INCLUDE_AR_APPL_TRX_CLASS = '||P_INCLUDE_AR_APPL_TRX_CLASS);
773: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
774: 'P_INCLUDE_AR_ADJ_TRX_CLASS = '||P_INCLUDE_AR_ADJ_TRX_CLASS);
775: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
776: 'P_INCLUDE_AR_MISC_TRX_CLASS = '||P_INCLUDE_AR_MISC_TRX_CLASS);
777: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
771: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
772: 'P_INCLUDE_AR_APPL_TRX_CLASS = '||P_INCLUDE_AR_APPL_TRX_CLASS);
773: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
774: 'P_INCLUDE_AR_ADJ_TRX_CLASS = '||P_INCLUDE_AR_ADJ_TRX_CLASS);
775: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
776: 'P_INCLUDE_AR_MISC_TRX_CLASS = '||P_INCLUDE_AR_MISC_TRX_CLASS);
777: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
778: 'P_INCLUDE_AR_BR_TRX_CLASS = '||P_INCLUDE_AR_BR_TRX_CLASS);
779: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
773: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
774: 'P_INCLUDE_AR_ADJ_TRX_CLASS = '||P_INCLUDE_AR_ADJ_TRX_CLASS);
775: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
776: 'P_INCLUDE_AR_MISC_TRX_CLASS = '||P_INCLUDE_AR_MISC_TRX_CLASS);
777: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
778: 'P_INCLUDE_AR_BR_TRX_CLASS = '||P_INCLUDE_AR_BR_TRX_CLASS);
779: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
780: 'P_INCLUDE_GL_MANUAL_LINES = '||P_INCLUDE_GL_MANUAL_LINES);
781: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
775: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
776: 'P_INCLUDE_AR_MISC_TRX_CLASS = '||P_INCLUDE_AR_MISC_TRX_CLASS);
777: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
778: 'P_INCLUDE_AR_BR_TRX_CLASS = '||P_INCLUDE_AR_BR_TRX_CLASS);
779: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
780: 'P_INCLUDE_GL_MANUAL_LINES = '||P_INCLUDE_GL_MANUAL_LINES);
781: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
782: 'P_THIRD_PARTY_REP_LEVEL = '||P_THIRD_PARTY_REP_LEVEL);
783: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
777: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
778: 'P_INCLUDE_AR_BR_TRX_CLASS = '||P_INCLUDE_AR_BR_TRX_CLASS);
779: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
780: 'P_INCLUDE_GL_MANUAL_LINES = '||P_INCLUDE_GL_MANUAL_LINES);
781: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
782: 'P_THIRD_PARTY_REP_LEVEL = '||P_THIRD_PARTY_REP_LEVEL);
783: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
784: 'P_FIRST_PARTY_TAX_REG_NUM = '||P_FIRST_PARTY_TAX_REG_NUM);
785: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
779: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
780: 'P_INCLUDE_GL_MANUAL_LINES = '||P_INCLUDE_GL_MANUAL_LINES);
781: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
782: 'P_THIRD_PARTY_REP_LEVEL = '||P_THIRD_PARTY_REP_LEVEL);
783: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
784: 'P_FIRST_PARTY_TAX_REG_NUM = '||P_FIRST_PARTY_TAX_REG_NUM);
785: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
786: 'P_TRX_NUMBER_LOW = '||P_TRX_NUMBER_LOW);
787: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
781: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
782: 'P_THIRD_PARTY_REP_LEVEL = '||P_THIRD_PARTY_REP_LEVEL);
783: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
784: 'P_FIRST_PARTY_TAX_REG_NUM = '||P_FIRST_PARTY_TAX_REG_NUM);
785: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
786: 'P_TRX_NUMBER_LOW = '||P_TRX_NUMBER_LOW);
787: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
788: 'P_TRX_NUMBER_HIGH = '||P_TRX_NUMBER_HIGH);
789: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
783: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
784: 'P_FIRST_PARTY_TAX_REG_NUM = '||P_FIRST_PARTY_TAX_REG_NUM);
785: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
786: 'P_TRX_NUMBER_LOW = '||P_TRX_NUMBER_LOW);
787: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
788: 'P_TRX_NUMBER_HIGH = '||P_TRX_NUMBER_HIGH);
789: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
790: 'P_AR_TRX_PRINTING_STATUS = '||P_AR_TRX_PRINTING_STATUS);
791: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
785: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
786: 'P_TRX_NUMBER_LOW = '||P_TRX_NUMBER_LOW);
787: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
788: 'P_TRX_NUMBER_HIGH = '||P_TRX_NUMBER_HIGH);
789: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
790: 'P_AR_TRX_PRINTING_STATUS = '||P_AR_TRX_PRINTING_STATUS);
791: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
792: 'P_AR_EXEMPTION_STATUS = '||P_AR_EXEMPTION_STATUS);
793: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
787: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
788: 'P_TRX_NUMBER_HIGH = '||P_TRX_NUMBER_HIGH);
789: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
790: 'P_AR_TRX_PRINTING_STATUS = '||P_AR_TRX_PRINTING_STATUS);
791: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
792: 'P_AR_EXEMPTION_STATUS = '||P_AR_EXEMPTION_STATUS);
793: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
794: 'P_GL_DATE_LOW = '||P_GL_DATE_LOW);
795: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
789: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
790: 'P_AR_TRX_PRINTING_STATUS = '||P_AR_TRX_PRINTING_STATUS);
791: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
792: 'P_AR_EXEMPTION_STATUS = '||P_AR_EXEMPTION_STATUS);
793: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
794: 'P_GL_DATE_LOW = '||P_GL_DATE_LOW);
795: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
796: 'P_GL_DATE_HIGH = '||P_GL_DATE_HIGH);
797: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
791: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
792: 'P_AR_EXEMPTION_STATUS = '||P_AR_EXEMPTION_STATUS);
793: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
794: 'P_GL_DATE_LOW = '||P_GL_DATE_LOW);
795: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
796: 'P_GL_DATE_HIGH = '||P_GL_DATE_HIGH);
797: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
798: 'P_TRX_DATE_LOW = '||P_TRX_DATE_LOW);
799: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
793: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
794: 'P_GL_DATE_LOW = '||P_GL_DATE_LOW);
795: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
796: 'P_GL_DATE_HIGH = '||P_GL_DATE_HIGH);
797: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
798: 'P_TRX_DATE_LOW = '||P_TRX_DATE_LOW);
799: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
800: 'P_TRX_DATE_HIGH = '||P_TRX_DATE_HIGH);
801: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
795: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
796: 'P_GL_DATE_HIGH = '||P_GL_DATE_HIGH);
797: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
798: 'P_TRX_DATE_LOW = '||P_TRX_DATE_LOW);
799: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
800: 'P_TRX_DATE_HIGH = '||P_TRX_DATE_HIGH);
801: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
802: 'P_GL_PERIOD_NAME_LOW = '||P_GL_PERIOD_NAME_LOW);
803: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
797: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
798: 'P_TRX_DATE_LOW = '||P_TRX_DATE_LOW);
799: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
800: 'P_TRX_DATE_HIGH = '||P_TRX_DATE_HIGH);
801: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
802: 'P_GL_PERIOD_NAME_LOW = '||P_GL_PERIOD_NAME_LOW);
803: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
804: 'P_GL_PERIOD_NAME_HIGH = '||P_GL_PERIOD_NAME_HIGH);
805: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
799: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
800: 'P_TRX_DATE_HIGH = '||P_TRX_DATE_HIGH);
801: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
802: 'P_GL_PERIOD_NAME_LOW = '||P_GL_PERIOD_NAME_LOW);
803: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
804: 'P_GL_PERIOD_NAME_HIGH = '||P_GL_PERIOD_NAME_HIGH);
805: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
806: 'P_TRX_DATE_PERIOD_NAME_LOW = '||P_TRX_DATE_PERIOD_NAME_LOW);
807: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
801: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
802: 'P_GL_PERIOD_NAME_LOW = '||P_GL_PERIOD_NAME_LOW);
803: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
804: 'P_GL_PERIOD_NAME_HIGH = '||P_GL_PERIOD_NAME_HIGH);
805: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
806: 'P_TRX_DATE_PERIOD_NAME_LOW = '||P_TRX_DATE_PERIOD_NAME_LOW);
807: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
808: 'P_TRX_DATE_PERIOD_NAME_HIGH = '||P_TRX_DATE_PERIOD_NAME_HIGH);
809: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
803: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
804: 'P_GL_PERIOD_NAME_HIGH = '||P_GL_PERIOD_NAME_HIGH);
805: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
806: 'P_TRX_DATE_PERIOD_NAME_LOW = '||P_TRX_DATE_PERIOD_NAME_LOW);
807: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
808: 'P_TRX_DATE_PERIOD_NAME_HIGH = '||P_TRX_DATE_PERIOD_NAME_HIGH);
809: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
810: 'P_TAX_JURISDICTION_CODE = '||P_TAX_JURISDICTION_CODE);
811: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
805: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
806: 'P_TRX_DATE_PERIOD_NAME_LOW = '||P_TRX_DATE_PERIOD_NAME_LOW);
807: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
808: 'P_TRX_DATE_PERIOD_NAME_HIGH = '||P_TRX_DATE_PERIOD_NAME_HIGH);
809: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
810: 'P_TAX_JURISDICTION_CODE = '||P_TAX_JURISDICTION_CODE);
811: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
812: 'P_TAX_REGIME_CODE = '||P_TAX_REGIME_CODE);
813: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
807: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
808: 'P_TRX_DATE_PERIOD_NAME_HIGH = '||P_TRX_DATE_PERIOD_NAME_HIGH);
809: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
810: 'P_TAX_JURISDICTION_CODE = '||P_TAX_JURISDICTION_CODE);
811: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
812: 'P_TAX_REGIME_CODE = '||P_TAX_REGIME_CODE);
813: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
814: 'P_TAX = '||P_TAX);
815: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
809: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
810: 'P_TAX_JURISDICTION_CODE = '||P_TAX_JURISDICTION_CODE);
811: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
812: 'P_TAX_REGIME_CODE = '||P_TAX_REGIME_CODE);
813: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
814: 'P_TAX = '||P_TAX);
815: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
816: 'P_TAX_STATUS_CODE = '||P_TAX_STATUS_CODE);
817: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
811: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
812: 'P_TAX_REGIME_CODE = '||P_TAX_REGIME_CODE);
813: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
814: 'P_TAX = '||P_TAX);
815: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
816: 'P_TAX_STATUS_CODE = '||P_TAX_STATUS_CODE);
817: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
818: 'P_TAX_RATE_CODE_LOW = '||P_TAX_RATE_CODE_LOW);
819: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
813: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
814: 'P_TAX = '||P_TAX);
815: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
816: 'P_TAX_STATUS_CODE = '||P_TAX_STATUS_CODE);
817: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
818: 'P_TAX_RATE_CODE_LOW = '||P_TAX_RATE_CODE_LOW);
819: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
820: 'P_TAX_RATE_CODE_HIGH = '||P_TAX_RATE_CODE_HIGH);
821: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
815: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
816: 'P_TAX_STATUS_CODE = '||P_TAX_STATUS_CODE);
817: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
818: 'P_TAX_RATE_CODE_LOW = '||P_TAX_RATE_CODE_LOW);
819: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
820: 'P_TAX_RATE_CODE_HIGH = '||P_TAX_RATE_CODE_HIGH);
821: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
822: 'P_TAX_TYPE_CODE_LOW = '||P_TAX_TYPE_CODE_LOW);
823: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
817: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
818: 'P_TAX_RATE_CODE_LOW = '||P_TAX_RATE_CODE_LOW);
819: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
820: 'P_TAX_RATE_CODE_HIGH = '||P_TAX_RATE_CODE_HIGH);
821: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
822: 'P_TAX_TYPE_CODE_LOW = '||P_TAX_TYPE_CODE_LOW);
823: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
824: 'P_TAX_TYPE_CODE_HIGH = '||P_TAX_TYPE_CODE_HIGH);
825: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
819: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
820: 'P_TAX_RATE_CODE_HIGH = '||P_TAX_RATE_CODE_HIGH);
821: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
822: 'P_TAX_TYPE_CODE_LOW = '||P_TAX_TYPE_CODE_LOW);
823: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
824: 'P_TAX_TYPE_CODE_HIGH = '||P_TAX_TYPE_CODE_HIGH);
825: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
826: 'P_DOCUMENT_SUB_TYPE = '||P_DOCUMENT_SUB_TYPE);
827: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
821: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
822: 'P_TAX_TYPE_CODE_LOW = '||P_TAX_TYPE_CODE_LOW);
823: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
824: 'P_TAX_TYPE_CODE_HIGH = '||P_TAX_TYPE_CODE_HIGH);
825: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
826: 'P_DOCUMENT_SUB_TYPE = '||P_DOCUMENT_SUB_TYPE);
827: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
828: 'P_TRX_BUSINESS_CATEGORY = '||P_TRX_BUSINESS_CATEGORY);
829: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
823: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
824: 'P_TAX_TYPE_CODE_HIGH = '||P_TAX_TYPE_CODE_HIGH);
825: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
826: 'P_DOCUMENT_SUB_TYPE = '||P_DOCUMENT_SUB_TYPE);
827: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
828: 'P_TRX_BUSINESS_CATEGORY = '||P_TRX_BUSINESS_CATEGORY);
829: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
830: 'P_TAX_INVOICE_DATE_LOW = '||P_TAX_INVOICE_DATE_LOW);
831: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
825: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
826: 'P_DOCUMENT_SUB_TYPE = '||P_DOCUMENT_SUB_TYPE);
827: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
828: 'P_TRX_BUSINESS_CATEGORY = '||P_TRX_BUSINESS_CATEGORY);
829: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
830: 'P_TAX_INVOICE_DATE_LOW = '||P_TAX_INVOICE_DATE_LOW);
831: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
832: 'P_TAX_INVOICE_DATE_HIGH = '||P_TAX_INVOICE_DATE_HIGH);
833: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
827: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
828: 'P_TRX_BUSINESS_CATEGORY = '||P_TRX_BUSINESS_CATEGORY);
829: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
830: 'P_TAX_INVOICE_DATE_LOW = '||P_TAX_INVOICE_DATE_LOW);
831: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
832: 'P_TAX_INVOICE_DATE_HIGH = '||P_TAX_INVOICE_DATE_HIGH);
833: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
834: 'P_POSTING_STATUS = '||P_POSTING_STATUS);
835: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
829: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
830: 'P_TAX_INVOICE_DATE_LOW = '||P_TAX_INVOICE_DATE_LOW);
831: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
832: 'P_TAX_INVOICE_DATE_HIGH = '||P_TAX_INVOICE_DATE_HIGH);
833: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
834: 'P_POSTING_STATUS = '||P_POSTING_STATUS);
835: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
836: 'P_ACCOUNTING_STATUS = '||P_ACCOUNTING_STATUS);
837: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
831: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
832: 'P_TAX_INVOICE_DATE_HIGH = '||P_TAX_INVOICE_DATE_HIGH);
833: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
834: 'P_POSTING_STATUS = '||P_POSTING_STATUS);
835: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
836: 'P_ACCOUNTING_STATUS = '||P_ACCOUNTING_STATUS);
837: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
838: 'P_REPORTED_STATUS = '||P_REPORTED_STATUS);
839: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
833: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
834: 'P_POSTING_STATUS = '||P_POSTING_STATUS);
835: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
836: 'P_ACCOUNTING_STATUS = '||P_ACCOUNTING_STATUS);
837: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
838: 'P_REPORTED_STATUS = '||P_REPORTED_STATUS);
839: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
840: 'P_EXTRACT_ACCTED_TAX_LINES = '||P_EXTRACT_ACCTED_TAX_LINES);
841: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
835: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
836: 'P_ACCOUNTING_STATUS = '||P_ACCOUNTING_STATUS);
837: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
838: 'P_REPORTED_STATUS = '||P_REPORTED_STATUS);
839: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
840: 'P_EXTRACT_ACCTED_TAX_LINES = '||P_EXTRACT_ACCTED_TAX_LINES);
841: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
842: 'P_INCLUDE_ACCOUNTING_SEGMENTS = '||P_INCLUDE_ACCOUNTING_SEGMENTS);
843: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
837: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
838: 'P_REPORTED_STATUS = '||P_REPORTED_STATUS);
839: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
840: 'P_EXTRACT_ACCTED_TAX_LINES = '||P_EXTRACT_ACCTED_TAX_LINES);
841: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
842: 'P_INCLUDE_ACCOUNTING_SEGMENTS = '||P_INCLUDE_ACCOUNTING_SEGMENTS);
843: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
844: 'P_BALANCING_SEGMENT_LOW = '||P_BALANCING_SEGMENT_LOW);
845: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
839: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
840: 'P_EXTRACT_ACCTED_TAX_LINES = '||P_EXTRACT_ACCTED_TAX_LINES);
841: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
842: 'P_INCLUDE_ACCOUNTING_SEGMENTS = '||P_INCLUDE_ACCOUNTING_SEGMENTS);
843: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
844: 'P_BALANCING_SEGMENT_LOW = '||P_BALANCING_SEGMENT_LOW);
845: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
846: 'P_BALANCING_SEGMENT_HIGH = '||P_BALANCING_SEGMENT_HIGH);
847: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
841: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
842: 'P_INCLUDE_ACCOUNTING_SEGMENTS = '||P_INCLUDE_ACCOUNTING_SEGMENTS);
843: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
844: 'P_BALANCING_SEGMENT_LOW = '||P_BALANCING_SEGMENT_LOW);
845: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
846: 'P_BALANCING_SEGMENT_HIGH = '||P_BALANCING_SEGMENT_HIGH);
847: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
848: 'P_INCLUDE_DISCOUNTS = '||P_INCLUDE_DISCOUNTS);
849: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
843: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
844: 'P_BALANCING_SEGMENT_LOW = '||P_BALANCING_SEGMENT_LOW);
845: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
846: 'P_BALANCING_SEGMENT_HIGH = '||P_BALANCING_SEGMENT_HIGH);
847: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
848: 'P_INCLUDE_DISCOUNTS = '||P_INCLUDE_DISCOUNTS);
849: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
850: 'P_EXTRACT_STARTING_LINE_NUM = '||P_EXTRACT_STARTING_LINE_NUM);
851: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
845: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
846: 'P_BALANCING_SEGMENT_HIGH = '||P_BALANCING_SEGMENT_HIGH);
847: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
848: 'P_INCLUDE_DISCOUNTS = '||P_INCLUDE_DISCOUNTS);
849: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
850: 'P_EXTRACT_STARTING_LINE_NUM = '||P_EXTRACT_STARTING_LINE_NUM);
851: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
852: 'P_REQUEST_ID = '||P_REQUEST_ID);
853: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
847: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
848: 'P_INCLUDE_DISCOUNTS = '||P_INCLUDE_DISCOUNTS);
849: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
850: 'P_EXTRACT_STARTING_LINE_NUM = '||P_EXTRACT_STARTING_LINE_NUM);
851: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
852: 'P_REQUEST_ID = '||P_REQUEST_ID);
853: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
854: 'P_REPORT_NAME = '||P_REPORT_NAME);
855: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
849: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
850: 'P_EXTRACT_STARTING_LINE_NUM = '||P_EXTRACT_STARTING_LINE_NUM);
851: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
852: 'P_REQUEST_ID = '||P_REQUEST_ID);
853: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
854: 'P_REPORT_NAME = '||P_REPORT_NAME);
855: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
856: 'P_VAT_TRANSACTION_TYPE_CODE = '||P_VAT_TRANSACTION_TYPE_CODE);
857: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
851: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
852: 'P_REQUEST_ID = '||P_REQUEST_ID);
853: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
854: 'P_REPORT_NAME = '||P_REPORT_NAME);
855: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
856: 'P_VAT_TRANSACTION_TYPE_CODE = '||P_VAT_TRANSACTION_TYPE_CODE);
857: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
858: 'P_INCLUDE_FULLY_NR_TAX_FLAG = '||P_INCLUDE_FULLY_NR_TAX_FLAG);
859: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
853: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
854: 'P_REPORT_NAME = '||P_REPORT_NAME);
855: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
856: 'P_VAT_TRANSACTION_TYPE_CODE = '||P_VAT_TRANSACTION_TYPE_CODE);
857: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
858: 'P_INCLUDE_FULLY_NR_TAX_FLAG = '||P_INCLUDE_FULLY_NR_TAX_FLAG);
859: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
860: 'P_MUNICIPAL_TAX_TYPE_CODE_LOW = '||P_MUNICIPAL_TAX_TYPE_CODE_LOW);
861: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
855: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
856: 'P_VAT_TRANSACTION_TYPE_CODE = '||P_VAT_TRANSACTION_TYPE_CODE);
857: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
858: 'P_INCLUDE_FULLY_NR_TAX_FLAG = '||P_INCLUDE_FULLY_NR_TAX_FLAG);
859: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
860: 'P_MUNICIPAL_TAX_TYPE_CODE_LOW = '||P_MUNICIPAL_TAX_TYPE_CODE_LOW);
861: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
862: 'P_MUNICIPAL_TAX_TYPE_CODE_HIGH = '||P_MUNICIPAL_TAX_TYPE_CODE_HIGH);
863: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
857: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
858: 'P_INCLUDE_FULLY_NR_TAX_FLAG = '||P_INCLUDE_FULLY_NR_TAX_FLAG);
859: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
860: 'P_MUNICIPAL_TAX_TYPE_CODE_LOW = '||P_MUNICIPAL_TAX_TYPE_CODE_LOW);
861: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
862: 'P_MUNICIPAL_TAX_TYPE_CODE_HIGH = '||P_MUNICIPAL_TAX_TYPE_CODE_HIGH);
863: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
864: 'P_PROVINCIAL_TAX_TYPE_CODE_LOW = '||P_PROV_TAX_TYPE_CODE_LOW);
865: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
859: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
860: 'P_MUNICIPAL_TAX_TYPE_CODE_LOW = '||P_MUNICIPAL_TAX_TYPE_CODE_LOW);
861: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
862: 'P_MUNICIPAL_TAX_TYPE_CODE_HIGH = '||P_MUNICIPAL_TAX_TYPE_CODE_HIGH);
863: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
864: 'P_PROVINCIAL_TAX_TYPE_CODE_LOW = '||P_PROV_TAX_TYPE_CODE_LOW);
865: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
866: 'P_PROVINCIAL_TAX_TYPE__CODE_HIGH = '||P_PROV_TAX_TYPE_CODE_HIGH);
867: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
861: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
862: 'P_MUNICIPAL_TAX_TYPE_CODE_HIGH = '||P_MUNICIPAL_TAX_TYPE_CODE_HIGH);
863: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
864: 'P_PROVINCIAL_TAX_TYPE_CODE_LOW = '||P_PROV_TAX_TYPE_CODE_LOW);
865: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
866: 'P_PROVINCIAL_TAX_TYPE__CODE_HIGH = '||P_PROV_TAX_TYPE_CODE_HIGH);
867: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
868: 'P_EXCISE_TAX_TYPE_CODE_LOW = '||P_EXCISE_TAX_TYPE_CODE_LOW);
869: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
863: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
864: 'P_PROVINCIAL_TAX_TYPE_CODE_LOW = '||P_PROV_TAX_TYPE_CODE_LOW);
865: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
866: 'P_PROVINCIAL_TAX_TYPE__CODE_HIGH = '||P_PROV_TAX_TYPE_CODE_HIGH);
867: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
868: 'P_EXCISE_TAX_TYPE_CODE_LOW = '||P_EXCISE_TAX_TYPE_CODE_LOW);
869: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
870: 'P_EXCISE_TAX_TYPE_CODE_HIGH = '||P_EXCISE_TAX_TYPE_CODE_HIGH);
871: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
865: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
866: 'P_PROVINCIAL_TAX_TYPE__CODE_HIGH = '||P_PROV_TAX_TYPE_CODE_HIGH);
867: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
868: 'P_EXCISE_TAX_TYPE_CODE_LOW = '||P_EXCISE_TAX_TYPE_CODE_LOW);
869: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
870: 'P_EXCISE_TAX_TYPE_CODE_HIGH = '||P_EXCISE_TAX_TYPE_CODE_HIGH);
871: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
872: 'P_NON_TAXABLE_TAX_TYPE_CODE = '||P_NON_TAXABLE_TAX_TYPE_CODE);
873: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
867: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
868: 'P_EXCISE_TAX_TYPE_CODE_LOW = '||P_EXCISE_TAX_TYPE_CODE_LOW);
869: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
870: 'P_EXCISE_TAX_TYPE_CODE_HIGH = '||P_EXCISE_TAX_TYPE_CODE_HIGH);
871: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
872: 'P_NON_TAXABLE_TAX_TYPE_CODE = '||P_NON_TAXABLE_TAX_TYPE_CODE);
873: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
874: 'P_PERCEPTION_TAX_TYPE_CODE_LOW = '||P_PER_TAX_TYPE_CODE_LOW);
875: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
869: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
870: 'P_EXCISE_TAX_TYPE_CODE_HIGH = '||P_EXCISE_TAX_TYPE_CODE_HIGH);
871: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
872: 'P_NON_TAXABLE_TAX_TYPE_CODE = '||P_NON_TAXABLE_TAX_TYPE_CODE);
873: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
874: 'P_PERCEPTION_TAX_TYPE_CODE_LOW = '||P_PER_TAX_TYPE_CODE_LOW);
875: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
876: 'P_PERCEPTION_TAX_TYPE_CODE_HIGH = '||P_PER_TAX_TYPE_CODE_HIGH);
877: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
871: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
872: 'P_NON_TAXABLE_TAX_TYPE_CODE = '||P_NON_TAXABLE_TAX_TYPE_CODE);
873: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
874: 'P_PERCEPTION_TAX_TYPE_CODE_LOW = '||P_PER_TAX_TYPE_CODE_LOW);
875: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
876: 'P_PERCEPTION_TAX_TYPE_CODE_HIGH = '||P_PER_TAX_TYPE_CODE_HIGH);
877: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
878: 'P_FED_PER_TAX_TYPE_CODE_LOW = '||P_FED_PER_TAX_TYPE_CODE_LOW);
879: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
873: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
874: 'P_PERCEPTION_TAX_TYPE_CODE_LOW = '||P_PER_TAX_TYPE_CODE_LOW);
875: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
876: 'P_PERCEPTION_TAX_TYPE_CODE_HIGH = '||P_PER_TAX_TYPE_CODE_HIGH);
877: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
878: 'P_FED_PER_TAX_TYPE_CODE_LOW = '||P_FED_PER_TAX_TYPE_CODE_LOW);
879: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
880: 'P_FED_PER_TAX_TYPE_CODE_HIGH = '||P_FED_PER_TAX_TYPE_CODE_HIGH);
881: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
875: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
876: 'P_PERCEPTION_TAX_TYPE_CODE_HIGH = '||P_PER_TAX_TYPE_CODE_HIGH);
877: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
878: 'P_FED_PER_TAX_TYPE_CODE_LOW = '||P_FED_PER_TAX_TYPE_CODE_LOW);
879: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
880: 'P_FED_PER_TAX_TYPE_CODE_HIGH = '||P_FED_PER_TAX_TYPE_CODE_HIGH);
881: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
882: 'P_VAT_TAX_TYPE_CODE = '||P_VAT_TAX_TYPE_CODE);
883: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
877: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
878: 'P_FED_PER_TAX_TYPE_CODE_LOW = '||P_FED_PER_TAX_TYPE_CODE_LOW);
879: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
880: 'P_FED_PER_TAX_TYPE_CODE_HIGH = '||P_FED_PER_TAX_TYPE_CODE_HIGH);
881: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
882: 'P_VAT_TAX_TYPE_CODE = '||P_VAT_TAX_TYPE_CODE);
883: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
884: 'P_EXCISE_TAX = '||P_EXCISE_TAX);
885: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
879: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
880: 'P_FED_PER_TAX_TYPE_CODE_HIGH = '||P_FED_PER_TAX_TYPE_CODE_HIGH);
881: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
882: 'P_VAT_TAX_TYPE_CODE = '||P_VAT_TAX_TYPE_CODE);
883: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
884: 'P_EXCISE_TAX = '||P_EXCISE_TAX);
885: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
886: 'P_VAT_ADDITIONAL_TAX = '||P_VAT_ADDITIONAL_TAX);
887: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
881: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
882: 'P_VAT_TAX_TYPE_CODE = '||P_VAT_TAX_TYPE_CODE);
883: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
884: 'P_EXCISE_TAX = '||P_EXCISE_TAX);
885: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
886: 'P_VAT_ADDITIONAL_TAX = '||P_VAT_ADDITIONAL_TAX);
887: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
888: 'P_VAT_NON_TAXABLE_TAX = '||P_VAT_NON_TAXABLE_TAX);
889: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
883: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
884: 'P_EXCISE_TAX = '||P_EXCISE_TAX);
885: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
886: 'P_VAT_ADDITIONAL_TAX = '||P_VAT_ADDITIONAL_TAX);
887: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
888: 'P_VAT_NON_TAXABLE_TAX = '||P_VAT_NON_TAXABLE_TAX);
889: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
890: 'P_VAT_NOT_TAX = '||P_VAT_NOT_TAX);
891: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
885: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
886: 'P_VAT_ADDITIONAL_TAX = '||P_VAT_ADDITIONAL_TAX);
887: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
888: 'P_VAT_NON_TAXABLE_TAX = '||P_VAT_NON_TAXABLE_TAX);
889: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
890: 'P_VAT_NOT_TAX = '||P_VAT_NOT_TAX);
891: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
892: 'P_VAT_PERCEPTION_TAX = '||P_VAT_PERCEPTION_TAX);
893: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
887: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
888: 'P_VAT_NON_TAXABLE_TAX = '||P_VAT_NON_TAXABLE_TAX);
889: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
890: 'P_VAT_NOT_TAX = '||P_VAT_NOT_TAX);
891: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
892: 'P_VAT_PERCEPTION_TAX = '||P_VAT_PERCEPTION_TAX);
893: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
894: 'P_VAT_TAX = '||P_VAT_TAX);
895: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
889: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
890: 'P_VAT_NOT_TAX = '||P_VAT_NOT_TAX);
891: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
892: 'P_VAT_PERCEPTION_TAX = '||P_VAT_PERCEPTION_TAX);
893: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
894: 'P_VAT_TAX = '||P_VAT_TAX);
895: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
896: 'P_INC_SELF_WD_TAX = '||P_INC_SELF_WD_TAX);
897: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
891: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
892: 'P_VAT_PERCEPTION_TAX = '||P_VAT_PERCEPTION_TAX);
893: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
894: 'P_VAT_TAX = '||P_VAT_TAX);
895: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
896: 'P_INC_SELF_WD_TAX = '||P_INC_SELF_WD_TAX);
897: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
898: 'P_EXCLUDING_TRX_LETTER = '||P_EXCLUDING_TRX_LETTER);
899: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
893: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
894: 'P_VAT_TAX = '||P_VAT_TAX);
895: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
896: 'P_INC_SELF_WD_TAX = '||P_INC_SELF_WD_TAX);
897: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
898: 'P_EXCLUDING_TRX_LETTER = '||P_EXCLUDING_TRX_LETTER);
899: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
900: 'P_TRX_LETTER_LOW = '||P_TRX_LETTER_LOW);
901: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
895: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
896: 'P_INC_SELF_WD_TAX = '||P_INC_SELF_WD_TAX);
897: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
898: 'P_EXCLUDING_TRX_LETTER = '||P_EXCLUDING_TRX_LETTER);
899: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
900: 'P_TRX_LETTER_LOW = '||P_TRX_LETTER_LOW);
901: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
902: 'P_TRX_LETTER_HIGH = '||P_TRX_LETTER_HIGH);
903: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
897: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
898: 'P_EXCLUDING_TRX_LETTER = '||P_EXCLUDING_TRX_LETTER);
899: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
900: 'P_TRX_LETTER_LOW = '||P_TRX_LETTER_LOW);
901: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
902: 'P_TRX_LETTER_HIGH = '||P_TRX_LETTER_HIGH);
903: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
904: 'P_INCLUDE_REFERENCED_SOURCE = '||P_INCLUDE_REFERENCED_SOURCE);
905: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
899: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
900: 'P_TRX_LETTER_LOW = '||P_TRX_LETTER_LOW);
901: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
902: 'P_TRX_LETTER_HIGH = '||P_TRX_LETTER_HIGH);
903: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
904: 'P_INCLUDE_REFERENCED_SOURCE = '||P_INCLUDE_REFERENCED_SOURCE);
905: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
906: 'P_PARTY_NAME = '||P_PARTY_NAME);
907: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
901: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
902: 'P_TRX_LETTER_HIGH = '||P_TRX_LETTER_HIGH);
903: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
904: 'P_INCLUDE_REFERENCED_SOURCE = '||P_INCLUDE_REFERENCED_SOURCE);
905: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
906: 'P_PARTY_NAME = '||P_PARTY_NAME);
907: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
908: 'P_BATCH_NAME = '||P_BATCH_NAME);
909: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
903: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
904: 'P_INCLUDE_REFERENCED_SOURCE = '||P_INCLUDE_REFERENCED_SOURCE);
905: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
906: 'P_PARTY_NAME = '||P_PARTY_NAME);
907: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
908: 'P_BATCH_NAME = '||P_BATCH_NAME);
909: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
910: 'P_BATCH_SOURCE_ID = '||P_BATCH_SOURCE_ID);
911: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
905: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
906: 'P_PARTY_NAME = '||P_PARTY_NAME);
907: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
908: 'P_BATCH_NAME = '||P_BATCH_NAME);
909: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
910: 'P_BATCH_SOURCE_ID = '||P_BATCH_SOURCE_ID);
911: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
912: 'P_ADJUSTED_DOC_FROM = '||P_ADJUSTED_DOC_FROM);
913: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
907: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
908: 'P_BATCH_NAME = '||P_BATCH_NAME);
909: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
910: 'P_BATCH_SOURCE_ID = '||P_BATCH_SOURCE_ID);
911: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
912: 'P_ADJUSTED_DOC_FROM = '||P_ADJUSTED_DOC_FROM);
913: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
914: 'P_ADJUSTED_DOC_TO = '||P_ADJUSTED_DOC_TO);
915: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
909: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
910: 'P_BATCH_SOURCE_ID = '||P_BATCH_SOURCE_ID);
911: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
912: 'P_ADJUSTED_DOC_FROM = '||P_ADJUSTED_DOC_FROM);
913: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
914: 'P_ADJUSTED_DOC_TO = '||P_ADJUSTED_DOC_TO);
915: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
916: 'P_STANDARD_VAT_TAX_RATE = '||P_STANDARD_VAT_TAX_RATE);
917: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
911: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
912: 'P_ADJUSTED_DOC_FROM = '||P_ADJUSTED_DOC_FROM);
913: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
914: 'P_ADJUSTED_DOC_TO = '||P_ADJUSTED_DOC_TO);
915: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
916: 'P_STANDARD_VAT_TAX_RATE = '||P_STANDARD_VAT_TAX_RATE);
917: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
918: 'P_MUNICIPAL_TAX = '||P_MUNICIPAL_TAX);
919: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
913: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
914: 'P_ADJUSTED_DOC_TO = '||P_ADJUSTED_DOC_TO);
915: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
916: 'P_STANDARD_VAT_TAX_RATE = '||P_STANDARD_VAT_TAX_RATE);
917: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
918: 'P_MUNICIPAL_TAX = '||P_MUNICIPAL_TAX);
919: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
920: 'P_PROVINCIAL_TAX = '||P_PROVINCIAL_TAX);
921: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
915: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
916: 'P_STANDARD_VAT_TAX_RATE = '||P_STANDARD_VAT_TAX_RATE);
917: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
918: 'P_MUNICIPAL_TAX = '||P_MUNICIPAL_TAX);
919: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
920: 'P_PROVINCIAL_TAX = '||P_PROVINCIAL_TAX);
921: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
922: 'P_TAX_ACCOUNT_LOW = '||P_TAX_ACCOUNT_LOW);
923: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
917: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
918: 'P_MUNICIPAL_TAX = '||P_MUNICIPAL_TAX);
919: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
920: 'P_PROVINCIAL_TAX = '||P_PROVINCIAL_TAX);
921: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
922: 'P_TAX_ACCOUNT_LOW = '||P_TAX_ACCOUNT_LOW);
923: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
924: 'P_TAX_ACCOUNT_HIGH = '||P_TAX_ACCOUNT_HIGH);
925: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
919: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
920: 'P_PROVINCIAL_TAX = '||P_PROVINCIAL_TAX);
921: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
922: 'P_TAX_ACCOUNT_LOW = '||P_TAX_ACCOUNT_LOW);
923: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
924: 'P_TAX_ACCOUNT_HIGH = '||P_TAX_ACCOUNT_HIGH);
925: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
926: 'P_EXP_CERT_DATE_FROM = '||P_EXP_CERT_DATE_FROM);
927: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
921: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
922: 'P_TAX_ACCOUNT_LOW = '||P_TAX_ACCOUNT_LOW);
923: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
924: 'P_TAX_ACCOUNT_HIGH = '||P_TAX_ACCOUNT_HIGH);
925: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
926: 'P_EXP_CERT_DATE_FROM = '||P_EXP_CERT_DATE_FROM);
927: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
928: 'P_EXP_CERT_DATE_TO = '||P_EXP_CERT_DATE_TO);
929: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
923: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
924: 'P_TAX_ACCOUNT_HIGH = '||P_TAX_ACCOUNT_HIGH);
925: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
926: 'P_EXP_CERT_DATE_FROM = '||P_EXP_CERT_DATE_FROM);
927: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
928: 'P_EXP_CERT_DATE_TO = '||P_EXP_CERT_DATE_TO);
929: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
930: 'P_EXP_METHOD = '||P_EXP_METHOD);
931: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
925: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
926: 'P_EXP_CERT_DATE_FROM = '||P_EXP_CERT_DATE_FROM);
927: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
928: 'P_EXP_CERT_DATE_TO = '||P_EXP_CERT_DATE_TO);
929: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
930: 'P_EXP_METHOD = '||P_EXP_METHOD);
931: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
932: 'P_TRX_NUMBER_LOW = '||P_TRX_NUMBER_LOW);
933: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
927: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
928: 'P_EXP_CERT_DATE_TO = '||P_EXP_CERT_DATE_TO);
929: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
930: 'P_EXP_METHOD = '||P_EXP_METHOD);
931: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
932: 'P_TRX_NUMBER_LOW = '||P_TRX_NUMBER_LOW);
933: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
934: 'P_TRX_NUMBER_HIGH = '||P_TRX_NUMBER_HIGH);
935: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
929: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
930: 'P_EXP_METHOD = '||P_EXP_METHOD);
931: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
932: 'P_TRX_NUMBER_LOW = '||P_TRX_NUMBER_LOW);
933: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
934: 'P_TRX_NUMBER_HIGH = '||P_TRX_NUMBER_HIGH);
935: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
936: 'P_PRINT_COMPANY_INFO = '||P_PRINT_COMPANY_INFO);
937: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
931: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
932: 'P_TRX_NUMBER_LOW = '||P_TRX_NUMBER_LOW);
933: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
934: 'P_TRX_NUMBER_HIGH = '||P_TRX_NUMBER_HIGH);
935: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
936: 'P_PRINT_COMPANY_INFO = '||P_PRINT_COMPANY_INFO);
937: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
938: 'P_ORDER_BY = '||P_ORDER_BY);
939: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
933: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
934: 'P_TRX_NUMBER_HIGH = '||P_TRX_NUMBER_HIGH);
935: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
936: 'P_PRINT_COMPANY_INFO = '||P_PRINT_COMPANY_INFO);
937: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
938: 'P_ORDER_BY = '||P_ORDER_BY);
939: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
940: 'P_ERRBUF = '||P_ERRBUF);
941: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
935: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
936: 'P_PRINT_COMPANY_INFO = '||P_PRINT_COMPANY_INFO);
937: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
938: 'P_ORDER_BY = '||P_ORDER_BY);
939: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
940: 'P_ERRBUF = '||P_ERRBUF);
941: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
942: 'P_RETCODE = '||P_RETCODE);
943: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
937: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
938: 'P_ORDER_BY = '||P_ORDER_BY);
939: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
940: 'P_ERRBUF = '||P_ERRBUF);
941: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
942: 'P_RETCODE = '||P_RETCODE);
943: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
944: 'P_TAXABLE_ACCOUNT_LOW = '||P_TAXABLE_ACCOUNT_LOW);
945: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
939: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
940: 'P_ERRBUF = '||P_ERRBUF);
941: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
942: 'P_RETCODE = '||P_RETCODE);
943: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
944: 'P_TAXABLE_ACCOUNT_LOW = '||P_TAXABLE_ACCOUNT_LOW);
945: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
946: 'P_TAXABLE_ACCOUNT_HIGH = '||P_TAXABLE_ACCOUNT_HIGH);
947: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
941: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
942: 'P_RETCODE = '||P_RETCODE);
943: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
944: 'P_TAXABLE_ACCOUNT_LOW = '||P_TAXABLE_ACCOUNT_LOW);
945: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
946: 'P_TAXABLE_ACCOUNT_HIGH = '||P_TAXABLE_ACCOUNT_HIGH);
947: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
948: 'P_GL_OR_TRX_DATE_FILTER = '||P_GL_OR_TRX_DATE_FILTER); --Bug 5396444
949: END IF;
943: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
944: 'P_TAXABLE_ACCOUNT_LOW = '||P_TAXABLE_ACCOUNT_LOW);
945: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
946: 'P_TAXABLE_ACCOUNT_HIGH = '||P_TAXABLE_ACCOUNT_HIGH);
947: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
948: 'P_GL_OR_TRX_DATE_FILTER = '||P_GL_OR_TRX_DATE_FILTER); --Bug 5396444
949: END IF;
950:
951: P_TRL_GLOBAL_VARIABLES_REC.REPORTING_LEVEL := P_REPORTING_LEVEL;
1080: NULL;
1081: END;
1082: l_length_errbuf := least(l_length_errbuf,2000);
1083: IF (g_level_procedure >= g_current_runtime_level ) THEN
1084: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1085: 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE(-)');
1086: END IF;
1087: P_ERRBUF := NULL;
1088:
1087: P_ERRBUF := NULL;
1088:
1089:
1090: IF (g_level_procedure >= g_current_runtime_level ) THEN
1091: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE.END',
1092: 'Length of errbuf : '||to_char(l_length_errbuf));
1093: END IF;
1094:
1095: EXCEPTION
1098: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
1099: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','initialize- '|| g_error_buffer);
1100: FND_MSG_PUB.Add;
1101: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1102: FND_LOG.STRING(g_level_unexpected,
1103: 'ZX.TRL.ZX_EXTRACT_PKG.initialize',
1104: 'initialize Check : ');
1105: FND_LOG.STRING(g_level_unexpected,
1106: 'ZX.TRL.ZX_EXTRACT_PKG.initialize', g_error_buffer);
1101: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1102: FND_LOG.STRING(g_level_unexpected,
1103: 'ZX.TRL.ZX_EXTRACT_PKG.initialize',
1104: 'initialize Check : ');
1105: FND_LOG.STRING(g_level_unexpected,
1106: 'ZX.TRL.ZX_EXTRACT_PKG.initialize', g_error_buffer);
1107: END IF;
1108: APPEND_ERRBUF(g_error_buffer);
1109: P_TRL_GLOBAL_VARIABLES_REC.RETCODE := 2;
1147:
1148: BEGIN
1149:
1150: IF (g_level_procedure >= g_current_runtime_level ) THEN
1151: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.derive_dependent_parameters.BEGIN',
1152: 'ZX.TRL.ZX_EXTRACT_PKG.derive_dependent_parameters(+)');
1153: END IF;
1154:
1155:
1157: IF p_trl_global_variables_rec.reporting_level = '1000' THEN
1158: g_ledger_id := p_trl_global_variables_rec.reporting_context;
1159: l_legal_entity_id := p_trl_global_variables_rec.legal_entity_id;
1160: IF (g_level_procedure >= g_current_runtime_level ) THEN
1161: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.derive_dependent_parameters 1000',
1162: 'g_ledger_id : ' || to_char(g_ledger_id) ||
1163: 'l_legal_entity_id : ' || to_char(l_legal_entity_id));
1164: END IF;
1165: ELSIF p_trl_global_variables_rec.reporting_level = '2000' THEN
1165: ELSIF p_trl_global_variables_rec.reporting_level = '2000' THEN
1166: l_legal_entity_id := p_trl_global_variables_rec.reporting_context;
1167: p_trl_global_variables_rec.legal_entity_id := l_legal_entity_id;
1168: IF (g_level_procedure >= g_current_runtime_level ) THEN
1169: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.derive_dependent_parameters 2000',
1170: 'l_legal_entity_id : ' || to_char(l_legal_entity_id));
1171: END IF;
1172:
1173: ELSIF p_trl_global_variables_rec.reporting_level = '3000' THEN
1175: l_legal_entity_id := XLE_UTILITIES_GRP.GET_DefaultLegalContext_OU(l_operating_unit_id);
1176: p_trl_global_variables_rec.legal_entity_id := l_legal_entity_id;
1177:
1178: IF (g_level_procedure >= g_current_runtime_level ) THEN
1179: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.derive_dependent_parameters 3000',
1180: 'l_operating_unit_id : ' || to_char(l_operating_unit_id) ||
1181: 'l_legal_entity_id : ' || to_char(l_legal_entity_id));
1182: END IF;
1183:
1188: g_ledger_id ,
1189: l_ledger_name );
1190: END IF;
1191: IF (g_level_procedure >= g_current_runtime_level ) THEN
1192: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.derive_dependent_parameters 3000.2',
1193: 'l_operating_unit_id : ' || to_char(l_operating_unit_id) ||
1194: 'g_ledger_id : ' || to_char(g_ledger_id) ||
1195: 'l_ledger_name : ' || to_char(l_ledger_name));
1196: END IF;
1223: IF NVL(g_ledger_type,'R') IN ('R','N') THEN
1224: p_trl_global_variables_rec.reporting_ledger_id := nvl(p_trl_global_variables_rec.ledger_id,g_ledger_id);
1225: p_trl_global_variables_rec.accounting_status := 'ACCOUNTED';
1226: IF (g_level_procedure >= g_current_runtime_level ) THEN
1227: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.derive_dependent_parameters',
1228: 'g_ledger_type and Reporting Ledger = '||g_ledger_type||'-'
1229: ||to_char(p_trl_global_variables_rec.reporting_ledger_id));
1230: END IF;
1231: END IF;
1234:
1235:
1236:
1237: IF (g_level_procedure >= g_current_runtime_level ) THEN
1238: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.derive_dependent_parameters',
1239: 'Accounting_status = '||p_trl_global_variables_rec.accounting_status);
1240: END IF;
1241:
1242:
1253:
1254: p_trl_global_variables_rec.ledger_id := g_ledger_id;
1255:
1256: IF (g_level_procedure >= g_current_runtime_level ) THEN
1257: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.derive_dependent_parameters',
1258: 'g_ledger_type = '||g_ledger_type||'-'||to_char(g_ledger_id));
1259: END IF;
1260:
1261:
1267: P_TRL_GLOBAL_VARIABLES_REC.func_currency_code;
1268: CLOSE chart_of_acc_id;
1269:
1270: IF (g_level_procedure >= g_current_runtime_level ) THEN
1271: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.derive_dependent_parameters',
1272: 'Chart of Accounts ID =' ||to_char(P_TRL_GLOBAL_VARIABLES_REC.chart_of_accounts_id));
1273: END IF;
1274:
1275: --derive P_GL_DATE_LOW/HIGH from P_GL_PERIOD_NAME_LOW/HIGH
1287:
1288: END IF;
1289:
1290: IF (g_level_procedure >= g_current_runtime_level ) THEN
1291: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.derive_dependent_parameters',
1292: ' p_trl_global_variables_rec.gl_period_name_low =' ||to_char(p_trl_global_variables_rec.gl_date_low));
1293: END IF;
1294:
1295:
1305:
1306: END IF;
1307:
1308: IF (g_level_procedure >= g_current_runtime_level ) THEN
1309: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.derive_dependent_parameters',
1310: ' p_trl_global_variables_rec.gl_period_name_high =' ||to_char(p_trl_global_variables_rec.gl_date_high));
1311: END IF;
1312:
1313: EXCEPTION
1316: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
1317: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','populate_tax_data- '|| g_error_buffer);
1318: FND_MSG_PUB.Add;
1319: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1320: FND_LOG.STRING(g_level_unexpected,
1321: 'ZX.TRL.ZX_EXTRACT_PKG.derive_dependent_parameters',
1322: 'Period Name Low and High parameter has error :');
1323: FND_LOG.STRING(g_level_unexpected,
1324: 'ZX.TRL.ZX_EXTRACT_PKG.derive_dependent_parameters',
1319: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1320: FND_LOG.STRING(g_level_unexpected,
1321: 'ZX.TRL.ZX_EXTRACT_PKG.derive_dependent_parameters',
1322: 'Period Name Low and High parameter has error :');
1323: FND_LOG.STRING(g_level_unexpected,
1324: 'ZX.TRL.ZX_EXTRACT_PKG.derive_dependent_parameters',
1325: g_error_buffer);
1326: END IF;
1327: APPEND_ERRBUF(g_error_buffer);
1364: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
1365: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','populate_tax_data- '|| g_error_buffer);
1366: FND_MSG_PUB.Add;
1367: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1368: FND_LOG.STRING(g_level_unexpected,
1369: 'ZX.TRL.ZX_EXTRACT_PKG.derive_dependent_parameters',
1370: 'Transaction Date Low and High parameter has error :');
1371: FND_LOG.STRING(g_level_unexpected,
1372: 'ZX.TRL.ZX_EXTRACT_PKG.derive_dependent_parameters',
1367: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1368: FND_LOG.STRING(g_level_unexpected,
1369: 'ZX.TRL.ZX_EXTRACT_PKG.derive_dependent_parameters',
1370: 'Transaction Date Low and High parameter has error :');
1371: FND_LOG.STRING(g_level_unexpected,
1372: 'ZX.TRL.ZX_EXTRACT_PKG.derive_dependent_parameters',
1373: g_error_buffer);
1374: END IF;
1375: APPEND_ERRBUF(g_error_buffer);
1376: P_TRL_GLOBAL_VARIABLES_REC.RETCODE := 2;
1377: END;
1378:
1379: IF (g_level_procedure >= g_current_runtime_level ) THEN
1380: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.derive_dependent_parameters.END',
1381: 'ZX.TRL.ZX_EXTRACT_PKG.derive_dependent_parameters(-)');
1382: END IF;
1383:
1384: EXCEPTION
1387: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
1388: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','derive_dependent_parameters- '|| g_error_buffer);
1389: FND_MSG_PUB.Add;
1390: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1391: FND_LOG.STRING(g_level_unexpected,
1392: 'ZX.TRL.ZX_EXTRACT_PKG.derive_dependent_parameters',
1393: 'Multi Org Utility : mo_utils.get_ledger_info :');
1394: FND_LOG.STRING(g_level_unexpected,
1395: 'ZX.TRL.ZX_EXTRACT_PKG.derive_dependent_parameters',
1390: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1391: FND_LOG.STRING(g_level_unexpected,
1392: 'ZX.TRL.ZX_EXTRACT_PKG.derive_dependent_parameters',
1393: 'Multi Org Utility : mo_utils.get_ledger_info :');
1394: FND_LOG.STRING(g_level_unexpected,
1395: 'ZX.TRL.ZX_EXTRACT_PKG.derive_dependent_parameters',
1396: g_error_buffer);
1397: END IF;
1398: APPEND_ERRBUF(g_error_buffer);
1434: WHERE request_id = P_TRL_GLOBAL_VARIABLES_REC.REQUEST_ID;
1435:
1436: IF l_count > 0 THEN
1437: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1438: FND_LOG.STRING(g_level_unexpected,
1439: 'ZX.TRL.ZX_EXTRACT_PKG.validate_parameters',
1440: 'Duplicate request ID :');
1441: FND_LOG.STRING(g_level_unexpected,
1442: 'ZX.TRL.ZX_EXTRACT_PKG.validate_parameters',
1437: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1438: FND_LOG.STRING(g_level_unexpected,
1439: 'ZX.TRL.ZX_EXTRACT_PKG.validate_parameters',
1440: 'Duplicate request ID :');
1441: FND_LOG.STRING(g_level_unexpected,
1442: 'ZX.TRL.ZX_EXTRACT_PKG.validate_parameters',
1443: g_error_buffer);
1444: END IF;
1445:
1454: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
1455: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','derive_dependent_parameters- '|| g_error_buffer);
1456: FND_MSG_PUB.Add;
1457: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1458: FND_LOG.STRING(g_level_unexpected,
1459: 'ZX.TRL.ZX_EXTRACT_PKG.validate_parameters',
1460: 'Request ID Duplicate check :');
1461: FND_LOG.STRING(g_level_unexpected,
1462: 'ZX.TRL.ZX_EXTRACT_PKG.validate_parameters',
1457: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1458: FND_LOG.STRING(g_level_unexpected,
1459: 'ZX.TRL.ZX_EXTRACT_PKG.validate_parameters',
1460: 'Request ID Duplicate check :');
1461: FND_LOG.STRING(g_level_unexpected,
1462: 'ZX.TRL.ZX_EXTRACT_PKG.validate_parameters',
1463: g_error_buffer);
1464: END IF;
1465: APPEND_ERRBUF(g_error_buffer);
1504: */
1505: BEGIN
1506:
1507: IF (g_level_procedure >= g_current_runtime_level ) THEN
1508: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.extract_rep_context_info.BEGIN',
1509: 'ZX.TRL.ZX_EXTRACT_PKG.extract_rep_context_info(+)');
1510: END IF;
1511:
1512: -- get the structure of address location dff
1517: pr_flexfield,
1518: pr_flexinfo);
1519:
1520: IF (g_level_procedure >= g_current_runtime_level ) THEN
1521: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.extract_rep_context_info.BEGIN',
1522: 'pr_flexfield :');
1523: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.extract_rep_context_info',
1524: 'p_trl_global_variables_rec.legal_entity_id : p_trl_global_variables_rec.legal_entity_id');
1525:
1519:
1520: IF (g_level_procedure >= g_current_runtime_level ) THEN
1521: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.extract_rep_context_info.BEGIN',
1522: 'pr_flexfield :');
1523: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.extract_rep_context_info',
1524: 'p_trl_global_variables_rec.legal_entity_id : p_trl_global_variables_rec.legal_entity_id');
1525:
1526: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.extract_rep_context_info',
1527: 'Before call to insert_rep_context_itf');
1522: 'pr_flexfield :');
1523: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.extract_rep_context_info',
1524: 'p_trl_global_variables_rec.legal_entity_id : p_trl_global_variables_rec.legal_entity_id');
1525:
1526: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.extract_rep_context_info',
1527: 'Before call to insert_rep_context_itf');
1528:
1529: END IF;
1530:
1537: /* apai
1538: ELSIF p_trl_global_variables_rec.reporting_level = '1000' THEN
1539:
1540: IF (g_level_procedure >= g_current_runtime_level ) THEN
1541: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.extract_rep_context_info.BEGIN',
1542: 'ZX.TRL.ZX_EXTRACT_PKG.extract_rep_context_info : Call to insert_rep_context_itf');
1543: END IF;
1544:
1545: BEGIN
1562: -- FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
1563: -- FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','populate_tax_data- '|| g_error_buffer);
1564: -- FND_MSG_PUB.Add;
1565: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1566: FND_LOG.STRING(g_level_unexpected,
1567: 'ZX.TRL.ZX_EXTRACT_PKG.extract_rep_context_info',
1568: g_error_buffer);
1569: END IF;
1570:
1587: l_operating_unit_id);
1588: END IF; -- reporting level
1589: */
1590: IF (g_level_procedure >= g_current_runtime_level ) THEN
1591: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.extract_rep_context_info.END',
1592: 'ZX.TRL.ZX_EXTRACT_PKG.extract_rep_context_info(-)');
1593: END IF;
1594:
1595: EXCEPTION
1598: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
1599: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','populate_tax_data- '|| g_error_buffer);
1600: FND_MSG_PUB.Add;
1601: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1602: FND_LOG.STRING(g_level_unexpected,
1603: 'ZX.TRL.ZX_EXTRACT_PKG.extract_rep_context_info',
1604: g_error_buffer);
1605: END IF;
1606: APPEND_ERRBUF(g_error_buffer);
1631:
1632: BEGIN
1633:
1634: IF (g_level_procedure >= g_current_runtime_level ) THEN
1635: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.EXTRACT_TAX_INFO.BEGIN',
1636: 'ZX_EXTRACT_PKG:EXTRACT_TAX_INFO(+)');
1637: END IF;
1638: -- Need to remove this code since the accounting and non accounting apis are merged
1639: /*
1719:
1720:
1721:
1722: IF (g_level_procedure >= g_current_runtime_level ) THEN
1723: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.extract_tax_info.END',
1724: 'ZX_EXTRACT_PKG:extract_tax_info(-)');
1725: END IF;
1726:
1727: EXCEPTION
1730: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
1731: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','populate_tax_data- '|| g_error_buffer);
1732: FND_MSG_PUB.Add;
1733: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1734: FND_LOG.STRING(g_level_unexpected,
1735: 'ZX.TRL.ZX_EXTRACT_PKG.extract_tax_info',
1736: g_error_buffer);
1737: END IF;
1738: APPEND_ERRBUF(g_error_buffer);
1791:
1792: BEGIN
1793:
1794: IF (g_level_procedure >= g_current_runtime_level ) THEN
1795: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.extract_additional_info.BEGIN',
1796: 'ZX_EXTRACT_PKG:extract_additional_info(+)');
1797: END IF;
1798:
1799: BEGIN
1821: FETCH rep_context_cursor INTO l_rep_context_id_rec;
1822: EXIT WHEN rep_context_cursor%NOTFOUND;
1823: rep_context_id_tab(i) := l_rep_context_id_rec;
1824: IF (g_level_procedure >= g_current_runtime_level ) THEN
1825: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.extract_additional_info',
1826: 'rep_context_id_tab(i)'||to_char(rep_context_id_tab(i).rep_context_id));
1827: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.extract_additional_info',
1828: 'l_rep_context_id_rec :'||to_char(l_rep_context_id_rec.rep_context_id));
1829: END IF;
1823: rep_context_id_tab(i) := l_rep_context_id_rec;
1824: IF (g_level_procedure >= g_current_runtime_level ) THEN
1825: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.extract_additional_info',
1826: 'rep_context_id_tab(i)'||to_char(rep_context_id_tab(i).rep_context_id));
1827: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.extract_additional_info',
1828: 'l_rep_context_id_rec :'||to_char(l_rep_context_id_rec.rep_context_id));
1829: END IF;
1830: i := i + 1;
1831:
1841: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
1842: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','extract_additional_info- '|| g_error_buffer);
1843: FND_MSG_PUB.Add;
1844: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1845: FND_LOG.STRING(g_level_unexpected,
1846: 'ZX.TRL.ZX_EXTRACT_PKG.extract_additional_info',
1847: g_error_buffer);
1848: END IF;
1849:
1885: END IF;
1886:
1887: -- Call to JX populate Plug-in APIs
1888: IF (g_level_procedure >= g_current_runtime_level ) THEN
1889: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.extract_additional_info',
1890: 'AR JX product Call: Return Code : '||to_char(L_AR_RETCODE));
1891: END IF;
1892:
1893: -- ZX_JL_EXTRACT_PKG.populate_jl_ar(P_TRL_GLOBAL_VARIABLES_REC);
1911: END IF;
1912: END IF;
1913:
1914: IF (g_level_procedure >= g_current_runtime_level ) THEN
1915: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.extract_additional_info',
1916: 'AP JX product Call: Return Code : '||to_char(L_AP_RETCODE));
1917: END IF;
1918: IF P_TRL_GLOBAL_VARIABLES_REC.PRODUCT = 'AP' OR
1919: P_TRL_GLOBAL_VARIABLES_REC.PRODUCT = 'ALL'
1918: IF P_TRL_GLOBAL_VARIABLES_REC.PRODUCT = 'AP' OR
1919: P_TRL_GLOBAL_VARIABLES_REC.PRODUCT = 'ALL'
1920: THEN
1921: IF (g_level_procedure >= g_current_runtime_level ) THEN
1922: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.extract_additional_info',
1923: 'AP JL product Call: Return Code : '||P_TRL_GLOBAL_VARIABLES_REC.PRODUCT);
1924: END IF;
1925:
1926: IF L_AP_RETCODE <> 2 THEN
1924: END IF;
1925:
1926: IF L_AP_RETCODE <> 2 THEN
1927: IF (g_level_procedure >= g_current_runtime_level ) THEN
1928: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.extract_additional_info',
1929: 'AP JL product Call: Return Code : '||to_char(L_AP_RETCODE));
1930: END IF;
1931:
1932: IF SUBSTR(P_TRL_GLOBAL_VARIABLES_REC.REPORT_NAME,3,2) IN ('SG','TW','ZX')
1938: ZX_JE_EXTRACT_PKG.populate_je_ap(P_TRL_GLOBAL_VARIABLES_REC);
1939: ELSIF SUBSTR(P_TRL_GLOBAL_VARIABLES_REC.REPORT_NAME,3,2) IN ('AR','CL','CO')
1940: THEN
1941: IF (g_level_procedure >= g_current_runtime_level ) THEN
1942: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.extract_additional_info',
1943: 'AP JL product Call: Return Code : '||'populate_jl_ap');
1944: END IF;
1945:
1946: ZX_JL_EXTRACT_PKG.populate_jl_ap(P_TRL_GLOBAL_VARIABLES_REC);
1971: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
1972: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','populate_tax_data- '|| g_error_buffer);
1973: FND_MSG_PUB.Add;
1974: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1975: FND_LOG.STRING(g_level_unexpected,
1976: 'ZX.TRL.ZX_EXTRACT_PKG.extract_additional_info',
1977: g_error_buffer);
1978: END IF;
1979: APPEND_ERRBUF(g_error_buffer);
2356:
2357: BEGIN
2358:
2359: IF (g_level_procedure >= g_current_runtime_level ) THEN
2360: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf.BEGIN',
2361: 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf(+)');
2362: END IF;
2363:
2364: IF p_trl_global_variables_rec.summary_level = 'TRANSACTION_DISTRIBUTION' THEN
2379: END IF;
2380:
2381: --Bug 5438409
2382: IF (g_level_statement >= g_current_runtime_level ) THEN
2383: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
2384: 'l_rep_context_lvl_mng : '||l_rep_context_lvl_mng);
2385: END IF;
2386:
2387: /* apai
2420: l_legal_contact_job_title;
2421: CLOSE c_legal_contact_info;
2422:
2423: IF (g_level_statement >= g_current_runtime_level ) THEN
2424: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
2425: 'l_rep_context_name : '|| l_rep_context_name);
2426: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
2427: 'l_activity_code : '|| l_activity_code);
2428: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
2422:
2423: IF (g_level_statement >= g_current_runtime_level ) THEN
2424: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
2425: 'l_rep_context_name : '|| l_rep_context_name);
2426: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
2427: 'l_activity_code : '|| l_activity_code);
2428: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
2429: 'l_sub_activity_code : '|| l_sub_activity_code);
2430: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
2424: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
2425: 'l_rep_context_name : '|| l_rep_context_name);
2426: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
2427: 'l_activity_code : '|| l_activity_code);
2428: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
2429: 'l_sub_activity_code : '|| l_sub_activity_code);
2430: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
2431: 'l_taxpayer_id : '|| l_taxpayer_id);
2432: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
2426: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
2427: 'l_activity_code : '|| l_activity_code);
2428: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
2429: 'l_sub_activity_code : '|| l_sub_activity_code);
2430: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
2431: 'l_taxpayer_id : '|| l_taxpayer_id);
2432: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
2433: 'l_rep_context_loc_id : '|| l_rep_context_loc_id);
2434: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
2428: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
2429: 'l_sub_activity_code : '|| l_sub_activity_code);
2430: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
2431: 'l_taxpayer_id : '|| l_taxpayer_id);
2432: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
2433: 'l_rep_context_loc_id : '|| l_rep_context_loc_id);
2434: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
2435: 'g_rep_context_address1 : '|| g_rep_context_address1);
2436: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
2430: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
2431: 'l_taxpayer_id : '|| l_taxpayer_id);
2432: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
2433: 'l_rep_context_loc_id : '|| l_rep_context_loc_id);
2434: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
2435: 'g_rep_context_address1 : '|| g_rep_context_address1);
2436: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
2437: 'g_rep_context_city : '|| g_rep_context_city);
2438:
2432: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
2433: 'l_rep_context_loc_id : '|| l_rep_context_loc_id);
2434: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
2435: 'g_rep_context_address1 : '|| g_rep_context_address1);
2436: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
2437: 'g_rep_context_city : '|| g_rep_context_city);
2438:
2439: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
2440: 'l_style : '|| l_style);
2435: 'g_rep_context_address1 : '|| g_rep_context_address1);
2436: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
2437: 'g_rep_context_city : '|| g_rep_context_city);
2438:
2439: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
2440: 'l_style : '|| l_style);
2441: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
2442: 'l_legal_contact_party_name : '|| l_legal_contact_party_name);
2443: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
2437: 'g_rep_context_city : '|| g_rep_context_city);
2438:
2439: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
2440: 'l_style : '|| l_style);
2441: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
2442: 'l_legal_contact_party_name : '|| l_legal_contact_party_name);
2443: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
2444: 'l_legal_contact_title : '|| l_legal_contact_title);
2445: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
2439: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
2440: 'l_style : '|| l_style);
2441: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
2442: 'l_legal_contact_party_name : '|| l_legal_contact_party_name);
2443: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
2444: 'l_legal_contact_title : '|| l_legal_contact_title);
2445: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
2446: 'l_legal_contact_party_num : '|| l_legal_contact_party_num);
2447:
2441: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
2442: 'l_legal_contact_party_name : '|| l_legal_contact_party_name);
2443: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
2444: 'l_legal_contact_title : '|| l_legal_contact_title);
2445: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
2446: 'l_legal_contact_party_num : '|| l_legal_contact_party_num);
2447:
2448: END IF;
2449:
2455: l_legal_auth_name ;
2456: CLOSE c_legal_auth_info;
2457:
2458: IF (g_level_statement >= g_current_runtime_level ) THEN
2459: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
2460: 'l_legal_auth_address_line2 : '|| l_legal_auth_address_line2);
2461: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
2462: 'l_legal_auth_address_line3 : '|| l_legal_auth_address_line3);
2463: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
2457:
2458: IF (g_level_statement >= g_current_runtime_level ) THEN
2459: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
2460: 'l_legal_auth_address_line2 : '|| l_legal_auth_address_line2);
2461: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
2462: 'l_legal_auth_address_line3 : '|| l_legal_auth_address_line3);
2463: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
2464: 'l_legal_auth_city : '|| l_legal_auth_city);
2465: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
2459: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
2460: 'l_legal_auth_address_line2 : '|| l_legal_auth_address_line2);
2461: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
2462: 'l_legal_auth_address_line3 : '|| l_legal_auth_address_line3);
2463: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
2464: 'l_legal_auth_city : '|| l_legal_auth_city);
2465: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
2466: 'l_legal_auth_name : '|| l_legal_auth_name);
2467:
2461: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
2462: 'l_legal_auth_address_line3 : '|| l_legal_auth_address_line3);
2463: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
2464: 'l_legal_auth_city : '|| l_legal_auth_city);
2465: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
2466: 'l_legal_auth_name : '|| l_legal_auth_name);
2467:
2468: END IF;
2469:
2502: END IF;
2503: */
2504:
2505: IF (g_level_procedure >= g_current_runtime_level ) THEN
2506: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
2507: 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf: After c_loc_rec cursor ');
2508: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
2509: 'p_rep_entity_id :'||to_char(p_rep_entity_id));
2510: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
2504:
2505: IF (g_level_procedure >= g_current_runtime_level ) THEN
2506: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
2507: 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf: After c_loc_rec cursor ');
2508: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
2509: 'p_rep_entity_id :'||to_char(p_rep_entity_id));
2510: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
2511: 'g_rep_context_city :'||g_rep_context_city);
2512: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
2506: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
2507: 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf: After c_loc_rec cursor ');
2508: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
2509: 'p_rep_entity_id :'||to_char(p_rep_entity_id));
2510: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
2511: 'g_rep_context_city :'||g_rep_context_city);
2512: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
2513: 'g_rep_context_address1 :'||g_rep_context_address1);
2514: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
2508: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
2509: 'p_rep_entity_id :'||to_char(p_rep_entity_id));
2510: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
2511: 'g_rep_context_city :'||g_rep_context_city);
2512: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
2513: 'g_rep_context_address1 :'||g_rep_context_address1);
2514: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
2515: 'l_rep_context_name :'||l_rep_context_name);
2516: END IF;
2510: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
2511: 'g_rep_context_city :'||g_rep_context_city);
2512: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
2513: 'g_rep_context_address1 :'||g_rep_context_address1);
2514: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
2515: 'l_rep_context_name :'||l_rep_context_name);
2516: END IF;
2517:
2518: -- populate the legal entity address fields :
2558: SELECT zx_rep_context_t_s.nextval
2559: INTO l_rep_context_id FROM dual;
2560:
2561: IF (g_level_procedure >= g_current_runtime_level ) THEN
2562: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
2563: 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf: Insert statement begins ');
2564: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
2565: 'p_rep_entity_id :'||to_char(p_rep_entity_id));
2566: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
2560:
2561: IF (g_level_procedure >= g_current_runtime_level ) THEN
2562: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
2563: 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf: Insert statement begins ');
2564: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
2565: 'p_rep_entity_id :'||to_char(p_rep_entity_id));
2566: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
2567: 'rep_context_id :'||to_char(l_rep_context_id));
2568: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
2562: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
2563: 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf: Insert statement begins ');
2564: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
2565: 'p_rep_entity_id :'||to_char(p_rep_entity_id));
2566: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
2567: 'rep_context_id :'||to_char(l_rep_context_id));
2568: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
2569: 'l_rep_context_city :'||l_rep_context_city);
2570: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
2564: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
2565: 'p_rep_entity_id :'||to_char(p_rep_entity_id));
2566: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
2567: 'rep_context_id :'||to_char(l_rep_context_id));
2568: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
2569: 'l_rep_context_city :'||l_rep_context_city);
2570: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
2571: 'l_rep_context_address1 :'||l_rep_context_address1);
2572: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
2566: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
2567: 'rep_context_id :'||to_char(l_rep_context_id));
2568: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
2569: 'l_rep_context_city :'||l_rep_context_city);
2570: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
2571: 'l_rep_context_address1 :'||l_rep_context_address1);
2572: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
2573: 'HQ Tax Registration Nbr : l_org_information2 :'||l_org_information2);
2574: END IF;
2568: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
2569: 'l_rep_context_city :'||l_rep_context_city);
2570: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
2571: 'l_rep_context_address1 :'||l_rep_context_address1);
2572: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
2573: 'HQ Tax Registration Nbr : l_org_information2 :'||l_org_information2);
2574: END IF;
2575:
2576: Begin
2659: g_last_update_login);
2660:
2661: l_rowcount := SQL%ROWCOUNT;
2662: IF (g_level_unexpected >= g_current_runtime_level ) THEN
2663: FND_LOG.STRING(g_level_unexpected,
2664: 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
2665: 'Rows Inserted in Rep context table :'||to_char(l_rowcount));
2666: END IF;
2667:
2667:
2668: IF l_rowcount = 0 THEN
2669: P_TRL_GLOBAL_VARIABLES_REC.RETCODE := 2;
2670: IF (g_level_unexpected >= g_current_runtime_level ) THEN
2671: FND_LOG.STRING(g_level_unexpected,
2672: 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
2673: 'P_TRL_GLOBAL_VARIABLES_REC.RETCODE'||to_char(P_TRL_GLOBAL_VARIABLES_REC.RETCODE));
2674: END IF;
2675:
2682: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
2683: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','insert_rep_context_itf- '|| g_error_buffer);
2684: FND_MSG_PUB.Add;
2685: IF (g_level_unexpected >= g_current_runtime_level ) THEN
2686: FND_LOG.STRING(g_level_unexpected,
2687: 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
2688: g_error_buffer);
2689: END IF;
2690: APPEND_ERRBUF(g_error_buffer);
2692:
2693: END;
2694:
2695: IF (g_level_procedure >= g_current_runtime_level ) THEN
2696: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf.END',
2697: 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf(-)');
2698: END IF;
2699:
2700: END insert_rep_context_itf ;
2720:
2721: BEGIN
2722:
2723: IF (g_level_procedure >= g_current_runtime_level ) THEN
2724: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.location_value.BEGIN',
2725: 'ZX.TRL.ZX_EXTRACT_PKG.location_value(+)');
2726: END IF;
2727:
2728: l_column := p_column;
2750: l_column_value := g_rep_context_phone_number;
2751: END IF;
2752:
2753: IF (g_level_procedure >= g_current_runtime_level ) THEN
2754: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.location_value.END',
2755: 'ZX.TRL.ZX_EXTRACT_PKG.location_value(-)'||l_column_value);
2756: END IF;
2757:
2758: RETURN l_column_value;
2763: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
2764: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','location_value- '|| g_error_buffer);
2765: FND_MSG_PUB.Add;
2766: IF (g_level_unexpected >= g_current_runtime_level ) THEN
2767: FND_LOG.STRING(g_level_unexpected, 'ZX.TRL.ZX_EXTRACT_PKG.location_value',
2768: g_error_buffer);
2769: END IF;
2770: APPEND_ERRBUF(g_error_buffer);
2771: --P_TRL_GLOBAL_VARIABLES_REC.RETCODE := 2;
2814:
2815: -- Get the context information from 'Address Location' Descriptive Flexfield
2816: -- Select the context value which matches p_org_loc_rec.style
2817: IF (g_level_procedure >= g_current_runtime_level ) THEN
2818: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.get_location_column.BEGIN',
2819: 'ZX.TRL.ZX_EXTRACT_PKG.get_location_column(+)');
2820: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.get_location_column',
2821: 'P_CLASSIFICATION = '||p_classification);
2822: END IF;
2816: -- Select the context value which matches p_org_loc_rec.style
2817: IF (g_level_procedure >= g_current_runtime_level ) THEN
2818: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.get_location_column.BEGIN',
2819: 'ZX.TRL.ZX_EXTRACT_PKG.get_location_column(+)');
2820: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.get_location_column',
2821: 'P_CLASSIFICATION = '||p_classification);
2822: END IF;
2823:
2824: fnd_dflex.get_contexts(pr_flexfield, pr_contexts);
2827: FOR i IN 1 .. pr_contexts.ncontexts LOOP
2828: IF(pr_contexts.is_enabled(i)) THEN
2829: IF pr_contexts.context_code(i) = l_style then
2830: IF (g_level_procedure >= g_current_runtime_level ) THEN
2831: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.get_location_column',
2832: 'pr_contexts.context_code= '||pr_contexts.context_code(i)||'-'||
2833: pr_contexts.context_description(i));
2834: END IF;
2835: l_context := i;
2857: END LOOP;
2858:
2859: IF l_column is NULL then
2860: IF (g_level_procedure >= g_current_runtime_level ) THEN
2861: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.get_location_column',
2862: 'No column which matches the value of p_classification: '||p_classification);
2863: END IF;
2864: return NULL;
2865: END IF;
2864: return NULL;
2865: END IF;
2866:
2867: IF (g_level_procedure >= g_current_runtime_level ) THEN
2868: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.get_location_column.END',
2869: 'ZX.TRL.ZX_EXTRACT_PKG.get_location_column(-)');
2870: END IF;
2871:
2872: RETURN l_column;
2877: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
2878: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','get_location_column- '|| g_error_buffer);
2879: FND_MSG_PUB.Add;
2880: IF (g_level_unexpected >= g_current_runtime_level ) THEN
2881: FND_LOG.STRING(g_level_unexpected,
2882: 'ZX.TRL.ZX_EXTRACT_PKG.get_location_column',
2883: g_error_buffer);
2884: END IF;
2885: APPEND_ERRBUF(g_error_buffer);
3197:
3198: BEGIN
3199:
3200: IF (g_level_procedure >= g_current_runtime_level ) THEN
3201: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.get_rep_context_id(+)',
3202: 'Legal Entity ID :'||to_char(p_legal_id));
3203: END IF;
3204:
3205: OPEN legal_rep_context_cur (p_request_id);
3206: --p_legal_id);
3207: FETCH legal_rep_context_cur into l_rep_context_id;
3208:
3209: IF (g_level_procedure >= g_current_runtime_level ) THEN
3210: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.get_rep_context_id(-)',
3211: 'l_rep_context_id :'||to_char(l_rep_context_id));
3212: END IF;
3213:
3214: IF legal_rep_context_cur%ISOPEN then
3526: l_counter_end NUMBER := 0 ;
3527:
3528: BEGIN
3529: x_return_status := FND_API.G_RET_STS_SUCCESS;
3530: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
3531: IF (g_level_procedure >= g_current_runtime_level ) THEN
3532: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.zx_upd_legal_reporting_status.BEGIN',
3533: 'ZX_EXTRACT_PKG:zx_upd_legal_reporting_status(+)');
3534: END IF;
3528: BEGIN
3529: x_return_status := FND_API.G_RET_STS_SUCCESS;
3530: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
3531: IF (g_level_procedure >= g_current_runtime_level ) THEN
3532: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.zx_upd_legal_reporting_status.BEGIN',
3533: 'ZX_EXTRACT_PKG:zx_upd_legal_reporting_status(+)');
3534: END IF;
3535:
3536: l_count := p_application_id_tbl.COUNT ;
3571:
3572: END LOOP ;
3573:
3574: IF (g_level_procedure >= g_current_runtime_level ) THEN
3575: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.zx_upd_legal_reporting_status.END',
3576: 'ZX_EXTRACT_PKG:zx_upd_legal_reporting_status(-)');
3577: END IF;
3578:
3579: EXCEPTION
3578:
3579: EXCEPTION
3580: WHEN OTHERS THEN
3581: IF (g_level_unexpected >= g_current_runtime_level ) THEN
3582: FND_LOG.STRING(g_level_unexpected,
3583: 'ZX.TRL.ZX_EXTRACT_PKG.zx_upd_legal_reporting_status',
3584: sqlerrm);
3585: END IF;
3586: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3600: | |
3601: +=========================================================================*/
3602:
3603: BEGIN
3604: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
3605:
3606: IF (g_level_procedure >= g_current_runtime_level ) THEN
3607:
3608: select substr(text,5,70) into l_version_info from user_source
3610: and text like '%Header:%'
3611: and type = 'PACKAGE BODY'
3612: and line < 10;
3613:
3614: FND_LOG.STRING(g_level_procedure, 'ZX_EXTRACT_PKG version info :',
3615: l_version_info);
3616: FND_LOG.STRING(g_level_procedure, 'ZX_EXTRACT_PKG version info :',
3617: 'g_current_runtime_level :'||to_char(g_current_runtime_level));
3618: FND_LOG.STRING(g_level_procedure, 'ZX_EXTRACT_PKG version info :',
3612: and line < 10;
3613:
3614: FND_LOG.STRING(g_level_procedure, 'ZX_EXTRACT_PKG version info :',
3615: l_version_info);
3616: FND_LOG.STRING(g_level_procedure, 'ZX_EXTRACT_PKG version info :',
3617: 'g_current_runtime_level :'||to_char(g_current_runtime_level));
3618: FND_LOG.STRING(g_level_procedure, 'ZX_EXTRACT_PKG version info :',
3619: 'g_level_procedure :'||to_char(g_level_procedure));
3620: FND_LOG.STRING(g_level_procedure, 'ZX_EXTRACT_PKG version info :',
3614: FND_LOG.STRING(g_level_procedure, 'ZX_EXTRACT_PKG version info :',
3615: l_version_info);
3616: FND_LOG.STRING(g_level_procedure, 'ZX_EXTRACT_PKG version info :',
3617: 'g_current_runtime_level :'||to_char(g_current_runtime_level));
3618: FND_LOG.STRING(g_level_procedure, 'ZX_EXTRACT_PKG version info :',
3619: 'g_level_procedure :'||to_char(g_level_procedure));
3620: FND_LOG.STRING(g_level_procedure, 'ZX_EXTRACT_PKG version info :',
3621: 'g_level_statement :'||to_char(g_level_statement));
3622:
3616: FND_LOG.STRING(g_level_procedure, 'ZX_EXTRACT_PKG version info :',
3617: 'g_current_runtime_level :'||to_char(g_current_runtime_level));
3618: FND_LOG.STRING(g_level_procedure, 'ZX_EXTRACT_PKG version info :',
3619: 'g_level_procedure :'||to_char(g_level_procedure));
3620: FND_LOG.STRING(g_level_procedure, 'ZX_EXTRACT_PKG version info :',
3621: 'g_level_statement :'||to_char(g_level_statement));
3622:
3623: END IF;
3624:
3631: and text like '%Header:%'
3632: and type = 'PACKAGE BODY'
3633: and line < 10;
3634:
3635: FND_LOG.STRING(g_level_procedure, 'ZX_AR_EXTRACT_PKG version info :',
3636: l_version_info);
3637: END IF;
3638:
3639: l_version_info := NULL;
3647: and text like '%Header:%'
3648: and type = 'PACKAGE BODY'
3649: and line < 10;
3650:
3651: FND_LOG.STRING(g_level_procedure, 'ZX_AP_EXTRACT_PKG version info :',
3652: l_version_info);
3653: END IF;
3654:
3655: l_version_info := NULL;
3661: and text like '%Header:%'
3662: and type = 'PACKAGE BODY'
3663: and line < 10;
3664:
3665: FND_LOG.STRING(g_level_procedure, 'ZX_AR_POPULATE_PKG version info :',
3666: l_version_info);
3667: END IF;
3668:
3669: l_version_info := NULL;
3675: and text like '%Header:%'
3676: and type = 'PACKAGE BODY'
3677: and line < 10;
3678:
3679: FND_LOG.STRING(g_level_procedure, 'ZX_AP_POPULATE_PKG version info :',
3680: l_version_info);
3681: END IF;
3682:
3683: l_version_info := NULL;
3689: and text like '%Header:%'
3690: and type = 'PACKAGE BODY'
3691: and line < 10;
3692:
3693: FND_LOG.STRING(g_level_procedure, 'ZX_GL_EXTRACT_PKG version info :',
3694: l_version_info);
3695: END IF;
3696:
3697: l_version_info := NULL;