[Home] [Help]
1: PACKAGE BODY ZX_EXTRACT_PKG AS
2: /* $Header: zxriextractwpkgb.pls 120.43.12010000.2 2008/11/12 12:58:45 spasala ship $ */
3:
4: C_LINES_PER_INSERT CONSTANT NUMBER := 1000;
5:
86: p_value3 VARCHAR2 DEFAULT NULL );
87:
88: PROCEDURE EXTRACT_TAX_INFO (
89: p_ledger_type IN VARCHAR2,
90: P_TRL_GLOBAL_VARIABLES_REC IN OUT NOCOPY ZX_EXTRACT_PKG.TRL_GLOBAL_VARIABLES_REC_TYPE);
91:
92: PROCEDURE extract_rep_context_info(
93: P_TRL_GLOBAL_VARIABLES_REC IN OUT NOCOPY ZX_EXTRACT_PKG.TRL_GLOBAL_VARIABLES_REC_TYPE);
94:
89: p_ledger_type IN VARCHAR2,
90: P_TRL_GLOBAL_VARIABLES_REC IN OUT NOCOPY ZX_EXTRACT_PKG.TRL_GLOBAL_VARIABLES_REC_TYPE);
91:
92: PROCEDURE extract_rep_context_info(
93: P_TRL_GLOBAL_VARIABLES_REC IN OUT NOCOPY ZX_EXTRACT_PKG.TRL_GLOBAL_VARIABLES_REC_TYPE);
94:
95: FUNCTION validate_parameters (
96: P_TRL_GLOBAL_VARIABLES_REC IN OUT NOCOPY ZX_EXTRACT_PKG.TRL_GLOBAL_VARIABLES_REC_TYPE
97: ) return boolean;
92: PROCEDURE extract_rep_context_info(
93: P_TRL_GLOBAL_VARIABLES_REC IN OUT NOCOPY ZX_EXTRACT_PKG.TRL_GLOBAL_VARIABLES_REC_TYPE);
94:
95: FUNCTION validate_parameters (
96: P_TRL_GLOBAL_VARIABLES_REC IN OUT NOCOPY ZX_EXTRACT_PKG.TRL_GLOBAL_VARIABLES_REC_TYPE
97: ) return boolean;
98:
99: PROCEDURE extract_additional_info (
100: P_ledger_type IN VARCHAR2,
97: ) return boolean;
98:
99: PROCEDURE extract_additional_info (
100: P_ledger_type IN VARCHAR2,
101: P_TRL_GLOBAL_VARIABLES_REC IN OUT NOCOPY ZX_EXTRACT_PKG.TRL_GLOBAL_VARIABLES_REC_TYPE);
102:
103: PROCEDURE derive_dependent_parameters (
104: P_TRL_GLOBAL_VARIABLES_REC IN OUT NOCOPY ZX_EXTRACT_PKG.TRL_GLOBAL_VARIABLES_REC_TYPE);
105:
100: P_ledger_type IN VARCHAR2,
101: P_TRL_GLOBAL_VARIABLES_REC IN OUT NOCOPY ZX_EXTRACT_PKG.TRL_GLOBAL_VARIABLES_REC_TYPE);
102:
103: PROCEDURE derive_dependent_parameters (
104: P_TRL_GLOBAL_VARIABLES_REC IN OUT NOCOPY ZX_EXTRACT_PKG.TRL_GLOBAL_VARIABLES_REC_TYPE);
105:
106: PROCEDURE cleanup (
107: P_TRL_GLOBAL_VARIABLES_REC IN OUT NOCOPY ZX_EXTRACT_PKG.TRL_GLOBAL_VARIABLES_REC_TYPE);
108:
103: PROCEDURE derive_dependent_parameters (
104: P_TRL_GLOBAL_VARIABLES_REC IN OUT NOCOPY ZX_EXTRACT_PKG.TRL_GLOBAL_VARIABLES_REC_TYPE);
105:
106: PROCEDURE cleanup (
107: P_TRL_GLOBAL_VARIABLES_REC IN OUT NOCOPY ZX_EXTRACT_PKG.TRL_GLOBAL_VARIABLES_REC_TYPE);
108:
109: PROCEDURE delete_all(p_request_id in number );
110:
111: /*PROCEDURE build_gbl_lookup_table; */
118:
119: FUNCTION convert_string(p_string IN VARCHAR2) return varchar2;
120:
121: PROCEDURE insert_rep_context_itf(
122: P_TRL_GLOBAL_VARIABLES_REC IN OUT NOCOPY ZX_EXTRACT_PKG.TRL_GLOBAL_VARIABLES_REC_TYPE,
123: p_rep_entity_id IN NUMBER );
124:
125: PROCEDURE initialize(
126: P_TRL_GLOBAL_VARIABLES_REC IN OUT NOCOPY ZX_EXTRACT_PKG.TRL_GLOBAL_VARIABLES_REC_TYPE,
122: P_TRL_GLOBAL_VARIABLES_REC IN OUT NOCOPY ZX_EXTRACT_PKG.TRL_GLOBAL_VARIABLES_REC_TYPE,
123: p_rep_entity_id IN NUMBER );
124:
125: PROCEDURE initialize(
126: P_TRL_GLOBAL_VARIABLES_REC IN OUT NOCOPY ZX_EXTRACT_PKG.TRL_GLOBAL_VARIABLES_REC_TYPE,
127: P_REPORTING_LEVEL IN VARCHAR2,
128: P_REPORTING_CONTEXT IN VARCHAR2,
129: -- apai P_LEGAL_ENTITY_LEVEL IN VARCHAR2,
130: P_LEGAL_ENTITY_ID IN NUMBER , -- apai COMPANY_NAME
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:
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:
386:
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
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
528: extract_tax_info(g_ledger_type, l_trl_global_variables_rec);
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;
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;
565:
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
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
567: WHEN OTHERS THEN
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:
578: P_RETCODE := l_trl_global_variables_rec.retcode;
589: | INITIALIZE |
590: | |
591: | DESCRIPTION |
592: | This procedure initializes the parameters for procedure |
593: | ZX_EXTRACT_PKG.populate_tax_data, and writes the values of parameters |
594: | passed in debug file and p_errbuf. |
595: | |
596: | Called from ZX_EXTRACT_PKG.populate_tax_data |
597: | |
592: | This procedure initializes the parameters for procedure |
593: | ZX_EXTRACT_PKG.populate_tax_data, and writes the values of parameters |
594: | passed in debug file and p_errbuf. |
595: | |
596: | Called from ZX_EXTRACT_PKG.populate_tax_data |
597: | |
598: | SCOPE - Private |
599: | |
600: | NOTES |
604: | |
605: +===========================================================================*/
606:
607: PROCEDURE initialize(
608: P_TRL_GLOBAL_VARIABLES_REC IN OUT NOCOPY ZX_EXTRACT_PKG.TRL_GLOBAL_VARIABLES_REC_TYPE,
609: P_REPORTING_LEVEL IN VARCHAR2,
610: P_REPORTING_CONTEXT IN VARCHAR2,
611: -- P_LEGAL_ENTITY_LEVEL IN VARCHAR2,
612: P_LEGAL_ENTITY_ID IN NUMBER , -- apai COMPANY_NAME
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);
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);
731:
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:
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:
1089:
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
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);
1107: END IF;
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;
1110:
1115: | derive_dependent_parameters |
1116: | |
1117: | DESCRIPTION |
1118: | This procedure derives the dependent parameters |
1119: | for procedure ZX_EXTRACT_PKG.POPULATE |
1120: | |
1121: | Called from ZX_EXTRACT_PKG.POPULATE |
1122: | |
1123: | SCOPE - Private |
1117: | DESCRIPTION |
1118: | This procedure derives the dependent parameters |
1119: | for procedure ZX_EXTRACT_PKG.POPULATE |
1120: | |
1121: | Called from ZX_EXTRACT_PKG.POPULATE |
1122: | |
1123: | SCOPE - Private |
1124: | |
1125: +===========================================================================*/
1124: | |
1125: +===========================================================================*/
1126:
1127: PROCEDURE derive_dependent_parameters (
1128: P_TRL_GLOBAL_VARIABLES_REC IN OUT NOCOPY ZX_EXTRACT_PKG.TRL_GLOBAL_VARIABLES_REC_TYPE)
1129: IS
1130: l_operating_unit_id NUMBER;
1131: l_ledger_name GL_LEDGERS.Name%TYPE;
1132: l_primary_ledger_id NUMBER(15);
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:
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:
1156:
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
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',
1325: g_error_buffer);
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);
1328: P_TRL_GLOBAL_VARIABLES_REC.RETCODE := 2;
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',
1373: g_error_buffer);
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;
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
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
1385: WHEN OTHERS THEN
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',
1396: g_error_buffer);
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);
1399: P_TRL_GLOBAL_VARIABLES_REC.RETCODE := 2;
1404: | VALIDATE_PARAMETERS |
1405: | |
1406: | DESCRIPTION |
1407: | This procedure validates the parameters supplied by the user in the |
1408: | ZX_EXTRACT_PKG.POPULATE and gives error message if he parameter |
1409: | values passed are invalid. |
1410: | |
1411: | Called from ZX_EXTRACT_PKG.POPULATE |
1412: | |
1407: | This procedure validates the parameters supplied by the user in the |
1408: | ZX_EXTRACT_PKG.POPULATE and gives error message if he parameter |
1409: | values passed are invalid. |
1410: | |
1411: | Called from ZX_EXTRACT_PKG.POPULATE |
1412: | |
1413: | SCOPE - Private |
1414: | |
1415: | NOTES |
1419: | |
1420: +===========================================================================*/
1421:
1422: FUNCTION VALIDATE_PARAMETERS (
1423: P_TRL_GLOBAL_VARIABLES_REC IN OUT NOCOPY ZX_EXTRACT_PKG.TRL_GLOBAL_VARIABLES_REC_TYPE)
1424: RETURN BOOLEAN IS
1425:
1426: C_ORDER_BY VARCHAR2(30);
1427: l_count NUMBER;
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',
1443: g_error_buffer);
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:
1446: END IF;
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',
1463: g_error_buffer);
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);
1466: P_TRL_GLOBAL_VARIABLES_REC.RETCODE := 2;
1473: | extract_rep_context_info |
1474: | |
1475: | description |
1476: | this PROCEDURE gets the reporting context for the header record |
1477: | called FROM the constructor of zx_extract_pkg |
1478: | |
1479: | scope - private |
1480: | |
1481: | notes |
1483: | |
1484: +===========================================================================*/
1485:
1486: PROCEDURE extract_rep_context_info (
1487: p_trl_global_variables_rec IN OUT NOCOPY ZX_EXTRACT_PKG.trl_global_variables_rec_type)
1488: IS
1489: l_operating_unit_id NUMBER;
1490: l_reporting_context_org_id NUMBER(15);
1491: l_reporting_context_tax_reg_no VARCHAR2(60);
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
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
1513:
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
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
1546: -- IF g_ledger_type = 'R' THEN
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:
1571: P_TRL_GLOBAL_VARIABLES_REC.RETCODE := 2;
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
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
1596: WHEN OTHERS THEN
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);
1607: P_TRL_GLOBAL_VARIABLES_REC.RETCODE := 2;
1613: | PROCEDURE |
1614: | extract_tax_info |
1615: | |
1616: | DESCRIPTION |
1617: | Called from ZX_EXTRACT_PKG.populate_tax_data |
1618: | |
1619: | SCOPE - Private |
1620: | |
1621: | NOTES |
1625: +===========================================================================*/
1626:
1627: PROCEDURE EXTRACT_TAX_INFO(
1628: p_ledger_type IN VARCHAR2,
1629: P_TRL_GLOBAL_VARIABLES_REC IN OUT NOCOPY ZX_EXTRACT_PKG.TRL_GLOBAL_VARIABLES_REC_TYPE)
1630: IS
1631:
1632: BEGIN
1633:
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: /*
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: /*
1640: IF P_TRL_GLOBAL_VARIABLES_REC.EXTRACT_ACCTED_TAX_LINES = 'Y' OR
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
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
1728: WHEN OTHERS THEN
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);
1739: P_TRL_GLOBAL_VARIABLES_REC.RETCODE := 2;
1747: | DESCRIPTION |
1748: | This procedure populates Additional information in |
1749: | zx_rep_context_t |
1750: | |
1751: | Called from ZX_EXTRACT_PKG.POPULATE |
1752: | |
1753: | MODIFICATION HISTORY |
1754: | 08-Feb-2005 Srinivasa Rao Korrapati Created |
1755: +===========================================================================*/
1755: +===========================================================================*/
1756:
1757: PROCEDURE extract_additional_info(
1758: p_ledger_type IN VARCHAR2,
1759: P_TRL_GLOBAL_VARIABLES_REC IN OUT NOCOPY ZX_EXTRACT_PKG.TRL_GLOBAL_VARIABLES_REC_TYPE)
1760: IS
1761:
1762:
1763: /*CURSOR rep_context_cursor(
1783: FROM zx_rep_context_t rep_context
1784: WHERE rep_context.request_id = c_request_id;
1785:
1786:
1787: l_rep_context_id_rec zx_extract_pkg.rep_context_id_rectype;
1788: i BINARY_INTEGER;
1789: l_org_id NUMBER;
1790: l_ledger_id NUMBER;
1791:
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
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
1800: -- IF p_ledger_type = 'R' THEN
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:
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:
1850: END;
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);
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);
1980: P_TRL_GLOBAL_VARIABLES_REC.RETCODE := 2;
1990: | This procedure deletes the records from AR_TAX_EXTRACT_DCL_IF |
1991: | which do not have any child records in AR_TAX_EXTRACT_SUB_ITF |
1992: | for the given request_id |
1993: | |
1994: | Called from ZX_EXTRACT_PKG.POPULATE |
1995: | |
1996: | SCOPE - Private |
1997: | |
1998: | NOTES |
2001: | |
2002: +===========================================================================*/
2003:
2004: PROCEDURE CLEANUP (
2005: P_TRL_GLOBAL_VARIABLES_REC IN OUT NOCOPY ZX_EXTRACT_PKG.TRL_GLOBAL_VARIABLES_REC_TYPE
2006: ) IS
2007:
2008: j number := 0;
2009: l_declarer_id number;
2098:
2099: EXCEPTION
2100: WHEN OTHERS THEN
2101: STACK_ERROR('FND','SQL_PLSQL_ERROR','ERRNO',SQLCODE,'REASON',SQLERRM,
2102: 'ROUTINE','ZX_EXTRACT_PKG.CLEANUP');
2103: L_MSG := FND_MESSAGE.GET;
2104:
2105: END;
2106:
2133: | and AR_TAX_EXTRACT_SUB_ITF for a given request_id. This procedure |
2134: | is called from the procedure populate if some fatal error condition |
2135: | occurs and error_code is set to 2 |
2136: | |
2137: | Called from ZX_EXTRACT_PKG.POPULATE |
2138: | |
2139: | SCOPE - Private |
2140: | |
2141: | NOTES |
2183: | 08-Feb-2005 Srinivasa Rao Korrapati Created |
2184: +===========================================================================*/
2185:
2186: PROCEDURE insert_rep_context_itf(
2187: p_trl_global_variables_rec IN OUT NOCOPY zx_extract_pkg.trl_global_variables_rec_type,
2188: p_rep_entity_id IN NUMBER)
2189: IS
2190:
2191: l_style HR_LOCATIONS_ALL.style%TYPE;
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
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
2365: l_extract_summary_code := 'D';
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',
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',
2511: 'g_rep_context_city :'||g_rep_context_city);
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',
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',
2567: 'rep_context_id :'||to_char(l_rep_context_id));
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
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:
2668: IF l_rowcount = 0 THEN
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:
2676: END IF;
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);
2691: P_TRL_GLOBAL_VARIABLES_REC.RETCODE := 2;
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 ;
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 ;
2701:
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;
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;
2729: IF l_column = 'TOWN_OR_CITY' THEN
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;
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;
2759:
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;
2783: | For example, if the location style is US then the column REGION1 |
2784: | is used to store COUNTY information, but if the style is CN the |
2785: | same column may store PROVINCE information. |
2786: | |
2787: | Called from ZX_EXTRACT_PKG.POPULATE_TAX_DATA() |
2788: | |
2789: | SCOPE - Private |
2790: | |
2791: | NOTES |
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;
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;
2823:
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;
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;
2873:
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);
2886: --P_TRL_GLOBAL_VARIABLES_REC.RETCODE := 2;
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
3440: 'TAXABLE4_ENTERED_CR',
3441: 'TAXABLE4_ENTERED_DR') );
3442:
3443: Begin
3444: -- arp_util_tax.debug('ZX_EXTRACT_PKG.USE_MATRIX_REPORT: Product = '||
3445: -- P_PRODUCT );
3446:
3447: l_use_matrix_rep := 'N';
3448:
3462: return l_use_matrix_rep;
3463: exception
3464: when no_data_found then
3465: IF PG_DEBUG = 'Y' THEN
3466: arp_util_tax.debug('ZX_EXTRACT_PKG.UE_MATRIX_REP : NO_DATA_FOUND ');
3467: END IF;
3468: if use_matrix_flag_csr_ap%isopen then
3469: close use_matrix_flag_csr_ap;
3470: end if;
3473: end if;
3474: return ('N');
3475: when others then
3476: IF PG_DEBUG = 'Y' THEN
3477: arp_util_tax.debug('ZX_EXTRACT_PKG.UE_MATRIX_REP: '||SQLCODE
3478: ||' ; '||SQLERRM);
3479: END IF;
3480: if use_matrix_flag_csr_ap%isopen then
3481: close use_matrix_flag_csr_ap;
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 ;
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 ;
3537:
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
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
3580: WHEN OTHERS THEN
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;
3587: app_exception.raise_exception;
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
3609: where name = 'ZX_EXTRACT_PKG'
3610: and text like '%Header:%'
3611: and type = 'PACKAGE BODY'
3612: and line < 10;
3613:
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:
3697: l_version_info := NULL;
3698:
3699: -- END;
3700:
3701: END ZX_EXTRACT_PKG;