[Home] [Help]
1: PACKAGE BODY ZX_EXTRACT_PKG AS
2: /* $Header: zxriextractwpkgb.pls 120.68 2011/11/24 11:51:52 srajapar 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
703: END;
704:
705: -- bug 10370545 Ends
706: IF (g_level_procedure >= g_current_runtime_level ) THEN
707: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.populate_tax_data.BEGIN',
708: 'ZX_EXTRACT_PKG:populate_tax_data(+): '||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
709: END IF;
710:
711:
704:
705: -- bug 10370545 Ends
706: IF (g_level_procedure >= g_current_runtime_level ) THEN
707: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.populate_tax_data.BEGIN',
708: 'ZX_EXTRACT_PKG:populate_tax_data(+): '||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
709: END IF;
710:
711:
712: -- Initialize the parameters:
842:
843: derive_dependent_parameters(l_trl_global_variables_rec);
844:
845: IF (g_level_procedure >= g_current_runtime_level ) THEN
846: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.populate_tax_data',
847: 'l_trl_global_variables_rec.gl_date_high : '|| to_char(l_trl_global_variables_rec.gl_date_high,
848: 'DD-MM-YYYY HH24:MI:SS'));
849: END IF;
850:
852: fnd_client_info.set_currency_context(p_ledger_id);
853: END IF;
854:
855: IF (g_level_procedure >= g_current_runtime_level ) THEN
856: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.populate_tax_data',
857: 'Return Code Check '||to_char(l_trl_global_variables_rec.retcode));
858: END IF;
859:
860: IF validate_parameters(l_trl_global_variables_rec) THEN
862: extract_rep_context_info(l_trl_global_variables_rec);
863: END IF;
864:
865: IF (g_level_procedure >= g_current_runtime_level ) THEN
866: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.populate_tax_data',
867: 'ZX.TRL.ZX_EXTRACT_PKG.EXTRACT_TAX_INFO Call');
868: END IF;
869:
870: IF l_trl_global_variables_rec.retcode <> 2 THEN
863: END IF;
864:
865: IF (g_level_procedure >= g_current_runtime_level ) THEN
866: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.populate_tax_data',
867: 'ZX.TRL.ZX_EXTRACT_PKG.EXTRACT_TAX_INFO Call');
868: END IF;
869:
870: IF l_trl_global_variables_rec.retcode <> 2 THEN
871: extract_tax_info(g_ledger_type, l_trl_global_variables_rec);
870: IF l_trl_global_variables_rec.retcode <> 2 THEN
871: extract_tax_info(g_ledger_type, l_trl_global_variables_rec);
872: END IF;
873: IF (g_level_procedure >= g_current_runtime_level ) THEN
874: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.populate_tax_data',
875: 'extract_additional_info call : '||to_char(l_trl_global_variables_rec.retcode));
876: END IF;
877: -- IF l_trl_global_variables_rec.retcode <> 2 THEN
878: extract_additional_info(g_ledger_type, l_trl_global_variables_rec) ;
933:
934: -- bug 10370545 Ends
935:
936: IF (g_level_procedure >= g_current_runtime_level ) THEN
937: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.Return Code ',
938: 'ZX_EXTRACT_PKG:populate_tax_data' ||to_char(l_trl_global_variables_rec.retcode));
939: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.populate_tax_data.END',
940: 'ZX_EXTRACT_PKG:populate_tax_data(-)'||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
941: END IF;
934: -- bug 10370545 Ends
935:
936: IF (g_level_procedure >= g_current_runtime_level ) THEN
937: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.Return Code ',
938: 'ZX_EXTRACT_PKG:populate_tax_data' ||to_char(l_trl_global_variables_rec.retcode));
939: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.populate_tax_data.END',
940: 'ZX_EXTRACT_PKG:populate_tax_data(-)'||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
941: END IF;
942:
935:
936: IF (g_level_procedure >= g_current_runtime_level ) THEN
937: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.Return Code ',
938: 'ZX_EXTRACT_PKG:populate_tax_data' ||to_char(l_trl_global_variables_rec.retcode));
939: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.populate_tax_data.END',
940: 'ZX_EXTRACT_PKG:populate_tax_data(-)'||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
941: END IF;
942:
943: EXCEPTION
936: IF (g_level_procedure >= g_current_runtime_level ) THEN
937: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.Return Code ',
938: 'ZX_EXTRACT_PKG:populate_tax_data' ||to_char(l_trl_global_variables_rec.retcode));
939: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.populate_tax_data.END',
940: 'ZX_EXTRACT_PKG:populate_tax_data(-)'||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
941: END IF;
942:
943: EXCEPTION
944: WHEN OTHERS THEN
947: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','populate_tax_data- '|| g_error_buffer);
948: FND_MSG_PUB.Add;
949: IF (g_level_unexpected >= g_current_runtime_level ) THEN
950: FND_LOG.STRING(g_level_unexpected,
951: 'ZX.TRL.ZX_EXTRACT_PKG.populate_tax_data',
952: g_error_buffer);
953: END IF;
954:
955: P_RETCODE := l_trl_global_variables_rec.retcode;
966: | INITIALIZE |
967: | |
968: | DESCRIPTION |
969: | This procedure initializes the parameters for procedure |
970: | ZX_EXTRACT_PKG.populate_tax_data, and writes the values of parameters |
971: | passed in debug file and p_errbuf. |
972: | |
973: | Called from ZX_EXTRACT_PKG.populate_tax_data |
974: | |
969: | This procedure initializes the parameters for procedure |
970: | ZX_EXTRACT_PKG.populate_tax_data, and writes the values of parameters |
971: | passed in debug file and p_errbuf. |
972: | |
973: | Called from ZX_EXTRACT_PKG.populate_tax_data |
974: | |
975: | SCOPE - Private |
976: | |
977: | NOTES |
981: | |
982: +===========================================================================*/
983:
984: PROCEDURE initialize(
985: P_TRL_GLOBAL_VARIABLES_REC IN OUT NOCOPY ZX_EXTRACT_PKG.TRL_GLOBAL_VARIABLES_REC_TYPE,
986: P_REPORTING_LEVEL IN VARCHAR2,
987: P_REPORTING_CONTEXT IN VARCHAR2,
988: -- apai P_LEGAL_ENTITY_LEVEL IN VARCHAR2,
989: P_LEGAL_ENTITY_ID IN NUMBER , -- apai COMPANY_NAME
1109: BEGIN
1110:
1111:
1112: IF (g_level_procedure >= g_current_runtime_level ) THEN
1113: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE.BEGIN',
1114: 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE(+)');
1115:
1116: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1117: 'P_REPORTING_LEVEL = '||P_REPORTING_LEVEL);
1110:
1111:
1112: IF (g_level_procedure >= g_current_runtime_level ) THEN
1113: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE.BEGIN',
1114: 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE(+)');
1115:
1116: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1117: 'P_REPORTING_LEVEL = '||P_REPORTING_LEVEL);
1118:
1112: IF (g_level_procedure >= g_current_runtime_level ) THEN
1113: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE.BEGIN',
1114: 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE(+)');
1115:
1116: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1117: 'P_REPORTING_LEVEL = '||P_REPORTING_LEVEL);
1118:
1119:
1120: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1116: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1117: 'P_REPORTING_LEVEL = '||P_REPORTING_LEVEL);
1118:
1119:
1120: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1121: 'P_REPORTING_CONTEXT = '||P_REPORTING_CONTEXT);
1122: /* apai
1123: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1124: 'P_LEGAL_ENTITY_LEVEL = '||P_LEGAL_ENTITY_LEVEL);
1119:
1120: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1121: 'P_REPORTING_CONTEXT = '||P_REPORTING_CONTEXT);
1122: /* apai
1123: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1124: 'P_LEGAL_ENTITY_LEVEL = '||P_LEGAL_ENTITY_LEVEL);
1125: */
1126: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1127: 'P_LEGAL_ENTITY_ID = '||P_LEGAL_ENTITY_ID);
1122: /* apai
1123: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1124: 'P_LEGAL_ENTITY_LEVEL = '||P_LEGAL_ENTITY_LEVEL);
1125: */
1126: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1127: 'P_LEGAL_ENTITY_ID = '||P_LEGAL_ENTITY_ID);
1128: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1129: 'P_SUMMARY_LEVEL = '||P_SUMMARY_LEVEL);
1130: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1124: 'P_LEGAL_ENTITY_LEVEL = '||P_LEGAL_ENTITY_LEVEL);
1125: */
1126: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1127: 'P_LEGAL_ENTITY_ID = '||P_LEGAL_ENTITY_ID);
1128: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1129: 'P_SUMMARY_LEVEL = '||P_SUMMARY_LEVEL);
1130: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1131: 'P_LEDGER_ID = '||P_LEDGER_ID);
1132: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1126: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1127: 'P_LEGAL_ENTITY_ID = '||P_LEGAL_ENTITY_ID);
1128: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1129: 'P_SUMMARY_LEVEL = '||P_SUMMARY_LEVEL);
1130: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1131: 'P_LEDGER_ID = '||P_LEDGER_ID);
1132: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1133: 'P_REGISTER_TYPE = '||P_REGISTER_TYPE);
1134: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1128: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1129: 'P_SUMMARY_LEVEL = '||P_SUMMARY_LEVEL);
1130: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1131: 'P_LEDGER_ID = '||P_LEDGER_ID);
1132: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1133: 'P_REGISTER_TYPE = '||P_REGISTER_TYPE);
1134: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1135: 'P_PRODUCT = '||P_PRODUCT);
1136: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1130: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1131: 'P_LEDGER_ID = '||P_LEDGER_ID);
1132: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1133: 'P_REGISTER_TYPE = '||P_REGISTER_TYPE);
1134: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1135: 'P_PRODUCT = '||P_PRODUCT);
1136: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1137: 'P_MATRIX_REPORT = '||P_MATRIX_REPORT);
1138: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1132: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1133: 'P_REGISTER_TYPE = '||P_REGISTER_TYPE);
1134: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1135: 'P_PRODUCT = '||P_PRODUCT);
1136: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1137: 'P_MATRIX_REPORT = '||P_MATRIX_REPORT);
1138: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1139: 'P_CURRENCY_CODE_LOW = '||P_CURRENCY_CODE_LOW);
1140: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1134: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1135: 'P_PRODUCT = '||P_PRODUCT);
1136: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1137: 'P_MATRIX_REPORT = '||P_MATRIX_REPORT);
1138: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1139: 'P_CURRENCY_CODE_LOW = '||P_CURRENCY_CODE_LOW);
1140: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1141: 'P_CURRENCY_CODE_HIGH = '||P_CURRENCY_CODE_HIGH);
1142: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1136: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1137: 'P_MATRIX_REPORT = '||P_MATRIX_REPORT);
1138: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1139: 'P_CURRENCY_CODE_LOW = '||P_CURRENCY_CODE_LOW);
1140: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1141: 'P_CURRENCY_CODE_HIGH = '||P_CURRENCY_CODE_HIGH);
1142: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1143: 'P_INCLUDE_AP_STD_TRX_CLASS = '||P_INCLUDE_AP_STD_TRX_CLASS);
1144: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1138: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1139: 'P_CURRENCY_CODE_LOW = '||P_CURRENCY_CODE_LOW);
1140: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1141: 'P_CURRENCY_CODE_HIGH = '||P_CURRENCY_CODE_HIGH);
1142: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1143: 'P_INCLUDE_AP_STD_TRX_CLASS = '||P_INCLUDE_AP_STD_TRX_CLASS);
1144: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1145: 'P_INCLUDE_AP_DM_TRX_CLASS = '||P_INCLUDE_AP_DM_TRX_CLASS);
1146: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1140: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1141: 'P_CURRENCY_CODE_HIGH = '||P_CURRENCY_CODE_HIGH);
1142: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1143: 'P_INCLUDE_AP_STD_TRX_CLASS = '||P_INCLUDE_AP_STD_TRX_CLASS);
1144: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1145: 'P_INCLUDE_AP_DM_TRX_CLASS = '||P_INCLUDE_AP_DM_TRX_CLASS);
1146: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1147: 'P_INCLUDE_AP_CM_TRX_CLASS = '||P_INCLUDE_AP_CM_TRX_CLASS);
1148: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1142: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1143: 'P_INCLUDE_AP_STD_TRX_CLASS = '||P_INCLUDE_AP_STD_TRX_CLASS);
1144: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1145: 'P_INCLUDE_AP_DM_TRX_CLASS = '||P_INCLUDE_AP_DM_TRX_CLASS);
1146: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1147: 'P_INCLUDE_AP_CM_TRX_CLASS = '||P_INCLUDE_AP_CM_TRX_CLASS);
1148: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1149: 'P_INCLUDE_AP_PREP_TRX_CLASS = '||P_INCLUDE_AP_PREP_TRX_CLASS);
1150: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1144: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1145: 'P_INCLUDE_AP_DM_TRX_CLASS = '||P_INCLUDE_AP_DM_TRX_CLASS);
1146: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1147: 'P_INCLUDE_AP_CM_TRX_CLASS = '||P_INCLUDE_AP_CM_TRX_CLASS);
1148: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1149: 'P_INCLUDE_AP_PREP_TRX_CLASS = '||P_INCLUDE_AP_PREP_TRX_CLASS);
1150: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1151: 'P_INCLUDE_AP_MIX_TRX_CLASS = '||P_INCLUDE_AP_MIX_TRX_CLASS);
1152: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1146: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1147: 'P_INCLUDE_AP_CM_TRX_CLASS = '||P_INCLUDE_AP_CM_TRX_CLASS);
1148: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1149: 'P_INCLUDE_AP_PREP_TRX_CLASS = '||P_INCLUDE_AP_PREP_TRX_CLASS);
1150: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1151: 'P_INCLUDE_AP_MIX_TRX_CLASS = '||P_INCLUDE_AP_MIX_TRX_CLASS);
1152: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1153: 'P_INCLUDE_AP_EXP_TRX_CLASS = '||P_INCLUDE_AP_EXP_TRX_CLASS);
1154: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1148: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1149: 'P_INCLUDE_AP_PREP_TRX_CLASS = '||P_INCLUDE_AP_PREP_TRX_CLASS);
1150: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1151: 'P_INCLUDE_AP_MIX_TRX_CLASS = '||P_INCLUDE_AP_MIX_TRX_CLASS);
1152: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1153: 'P_INCLUDE_AP_EXP_TRX_CLASS = '||P_INCLUDE_AP_EXP_TRX_CLASS);
1154: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1155: 'P_INCLUDE_AP_INT_TRX_CLASS = '||P_INCLUDE_AP_INT_TRX_CLASS);
1156: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1150: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1151: 'P_INCLUDE_AP_MIX_TRX_CLASS = '||P_INCLUDE_AP_MIX_TRX_CLASS);
1152: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1153: 'P_INCLUDE_AP_EXP_TRX_CLASS = '||P_INCLUDE_AP_EXP_TRX_CLASS);
1154: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1155: 'P_INCLUDE_AP_INT_TRX_CLASS = '||P_INCLUDE_AP_INT_TRX_CLASS);
1156: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1157: 'P_INCLUDE_AR_INV_TRX_CLASS = '||P_INCLUDE_AR_INV_TRX_CLASS);
1158: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1152: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1153: 'P_INCLUDE_AP_EXP_TRX_CLASS = '||P_INCLUDE_AP_EXP_TRX_CLASS);
1154: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1155: 'P_INCLUDE_AP_INT_TRX_CLASS = '||P_INCLUDE_AP_INT_TRX_CLASS);
1156: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1157: 'P_INCLUDE_AR_INV_TRX_CLASS = '||P_INCLUDE_AR_INV_TRX_CLASS);
1158: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1159: 'P_INCLUDE_AR_APPL_TRX_CLASS = '||P_INCLUDE_AR_APPL_TRX_CLASS);
1160: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1154: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1155: 'P_INCLUDE_AP_INT_TRX_CLASS = '||P_INCLUDE_AP_INT_TRX_CLASS);
1156: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1157: 'P_INCLUDE_AR_INV_TRX_CLASS = '||P_INCLUDE_AR_INV_TRX_CLASS);
1158: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1159: 'P_INCLUDE_AR_APPL_TRX_CLASS = '||P_INCLUDE_AR_APPL_TRX_CLASS);
1160: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1161: 'P_INCLUDE_AR_ADJ_TRX_CLASS = '||P_INCLUDE_AR_ADJ_TRX_CLASS);
1162: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1156: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1157: 'P_INCLUDE_AR_INV_TRX_CLASS = '||P_INCLUDE_AR_INV_TRX_CLASS);
1158: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1159: 'P_INCLUDE_AR_APPL_TRX_CLASS = '||P_INCLUDE_AR_APPL_TRX_CLASS);
1160: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1161: 'P_INCLUDE_AR_ADJ_TRX_CLASS = '||P_INCLUDE_AR_ADJ_TRX_CLASS);
1162: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1163: 'P_INCLUDE_AR_MISC_TRX_CLASS = '||P_INCLUDE_AR_MISC_TRX_CLASS);
1164: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1158: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1159: 'P_INCLUDE_AR_APPL_TRX_CLASS = '||P_INCLUDE_AR_APPL_TRX_CLASS);
1160: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1161: 'P_INCLUDE_AR_ADJ_TRX_CLASS = '||P_INCLUDE_AR_ADJ_TRX_CLASS);
1162: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1163: 'P_INCLUDE_AR_MISC_TRX_CLASS = '||P_INCLUDE_AR_MISC_TRX_CLASS);
1164: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1165: 'P_INCLUDE_AR_BR_TRX_CLASS = '||P_INCLUDE_AR_BR_TRX_CLASS);
1166: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1160: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1161: 'P_INCLUDE_AR_ADJ_TRX_CLASS = '||P_INCLUDE_AR_ADJ_TRX_CLASS);
1162: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1163: 'P_INCLUDE_AR_MISC_TRX_CLASS = '||P_INCLUDE_AR_MISC_TRX_CLASS);
1164: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1165: 'P_INCLUDE_AR_BR_TRX_CLASS = '||P_INCLUDE_AR_BR_TRX_CLASS);
1166: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1167: 'P_INCLUDE_GL_MANUAL_LINES = '||P_INCLUDE_GL_MANUAL_LINES);
1168: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1162: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1163: 'P_INCLUDE_AR_MISC_TRX_CLASS = '||P_INCLUDE_AR_MISC_TRX_CLASS);
1164: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1165: 'P_INCLUDE_AR_BR_TRX_CLASS = '||P_INCLUDE_AR_BR_TRX_CLASS);
1166: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1167: 'P_INCLUDE_GL_MANUAL_LINES = '||P_INCLUDE_GL_MANUAL_LINES);
1168: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1169: 'P_THIRD_PARTY_REP_LEVEL = '||P_THIRD_PARTY_REP_LEVEL);
1170: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1164: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1165: 'P_INCLUDE_AR_BR_TRX_CLASS = '||P_INCLUDE_AR_BR_TRX_CLASS);
1166: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1167: 'P_INCLUDE_GL_MANUAL_LINES = '||P_INCLUDE_GL_MANUAL_LINES);
1168: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1169: 'P_THIRD_PARTY_REP_LEVEL = '||P_THIRD_PARTY_REP_LEVEL);
1170: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1171: 'P_FIRST_PARTY_TAX_REG_NUM = '||P_FIRST_PARTY_TAX_REG_NUM);
1172: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1166: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1167: 'P_INCLUDE_GL_MANUAL_LINES = '||P_INCLUDE_GL_MANUAL_LINES);
1168: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1169: 'P_THIRD_PARTY_REP_LEVEL = '||P_THIRD_PARTY_REP_LEVEL);
1170: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1171: 'P_FIRST_PARTY_TAX_REG_NUM = '||P_FIRST_PARTY_TAX_REG_NUM);
1172: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1173: 'P_TRX_NUMBER_LOW = '||P_TRX_NUMBER_LOW);
1174: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1168: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1169: 'P_THIRD_PARTY_REP_LEVEL = '||P_THIRD_PARTY_REP_LEVEL);
1170: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1171: 'P_FIRST_PARTY_TAX_REG_NUM = '||P_FIRST_PARTY_TAX_REG_NUM);
1172: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1173: 'P_TRX_NUMBER_LOW = '||P_TRX_NUMBER_LOW);
1174: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1175: 'P_TRX_NUMBER_HIGH = '||P_TRX_NUMBER_HIGH);
1176: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1170: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1171: 'P_FIRST_PARTY_TAX_REG_NUM = '||P_FIRST_PARTY_TAX_REG_NUM);
1172: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1173: 'P_TRX_NUMBER_LOW = '||P_TRX_NUMBER_LOW);
1174: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1175: 'P_TRX_NUMBER_HIGH = '||P_TRX_NUMBER_HIGH);
1176: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1177: 'P_AR_TRX_PRINTING_STATUS = '||P_AR_TRX_PRINTING_STATUS);
1178: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1172: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1173: 'P_TRX_NUMBER_LOW = '||P_TRX_NUMBER_LOW);
1174: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1175: 'P_TRX_NUMBER_HIGH = '||P_TRX_NUMBER_HIGH);
1176: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1177: 'P_AR_TRX_PRINTING_STATUS = '||P_AR_TRX_PRINTING_STATUS);
1178: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1179: 'P_AR_EXEMPTION_STATUS = '||P_AR_EXEMPTION_STATUS);
1180: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1174: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1175: 'P_TRX_NUMBER_HIGH = '||P_TRX_NUMBER_HIGH);
1176: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1177: 'P_AR_TRX_PRINTING_STATUS = '||P_AR_TRX_PRINTING_STATUS);
1178: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1179: 'P_AR_EXEMPTION_STATUS = '||P_AR_EXEMPTION_STATUS);
1180: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1181: 'P_GL_DATE_LOW = '||P_GL_DATE_LOW);
1182: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1176: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1177: 'P_AR_TRX_PRINTING_STATUS = '||P_AR_TRX_PRINTING_STATUS);
1178: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1179: 'P_AR_EXEMPTION_STATUS = '||P_AR_EXEMPTION_STATUS);
1180: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1181: 'P_GL_DATE_LOW = '||P_GL_DATE_LOW);
1182: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1183: 'P_GL_DATE_HIGH = '||P_GL_DATE_HIGH);
1184: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1178: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1179: 'P_AR_EXEMPTION_STATUS = '||P_AR_EXEMPTION_STATUS);
1180: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1181: 'P_GL_DATE_LOW = '||P_GL_DATE_LOW);
1182: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1183: 'P_GL_DATE_HIGH = '||P_GL_DATE_HIGH);
1184: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1185: 'P_TRX_DATE_LOW = '||P_TRX_DATE_LOW);
1186: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1180: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1181: 'P_GL_DATE_LOW = '||P_GL_DATE_LOW);
1182: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1183: 'P_GL_DATE_HIGH = '||P_GL_DATE_HIGH);
1184: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1185: 'P_TRX_DATE_LOW = '||P_TRX_DATE_LOW);
1186: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1187: 'P_TRX_DATE_HIGH = '||P_TRX_DATE_HIGH);
1188: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1182: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1183: 'P_GL_DATE_HIGH = '||P_GL_DATE_HIGH);
1184: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1185: 'P_TRX_DATE_LOW = '||P_TRX_DATE_LOW);
1186: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1187: 'P_TRX_DATE_HIGH = '||P_TRX_DATE_HIGH);
1188: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1189: 'P_GL_PERIOD_NAME_LOW = '||P_GL_PERIOD_NAME_LOW);
1190: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1184: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1185: 'P_TRX_DATE_LOW = '||P_TRX_DATE_LOW);
1186: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1187: 'P_TRX_DATE_HIGH = '||P_TRX_DATE_HIGH);
1188: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1189: 'P_GL_PERIOD_NAME_LOW = '||P_GL_PERIOD_NAME_LOW);
1190: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1191: 'P_GL_PERIOD_NAME_HIGH = '||P_GL_PERIOD_NAME_HIGH);
1192: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1186: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1187: 'P_TRX_DATE_HIGH = '||P_TRX_DATE_HIGH);
1188: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1189: 'P_GL_PERIOD_NAME_LOW = '||P_GL_PERIOD_NAME_LOW);
1190: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1191: 'P_GL_PERIOD_NAME_HIGH = '||P_GL_PERIOD_NAME_HIGH);
1192: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1193: 'P_TRX_DATE_PERIOD_NAME_LOW = '||P_TRX_DATE_PERIOD_NAME_LOW);
1194: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1188: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1189: 'P_GL_PERIOD_NAME_LOW = '||P_GL_PERIOD_NAME_LOW);
1190: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1191: 'P_GL_PERIOD_NAME_HIGH = '||P_GL_PERIOD_NAME_HIGH);
1192: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1193: 'P_TRX_DATE_PERIOD_NAME_LOW = '||P_TRX_DATE_PERIOD_NAME_LOW);
1194: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1195: 'P_TRX_DATE_PERIOD_NAME_HIGH = '||P_TRX_DATE_PERIOD_NAME_HIGH);
1196: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1190: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1191: 'P_GL_PERIOD_NAME_HIGH = '||P_GL_PERIOD_NAME_HIGH);
1192: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1193: 'P_TRX_DATE_PERIOD_NAME_LOW = '||P_TRX_DATE_PERIOD_NAME_LOW);
1194: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1195: 'P_TRX_DATE_PERIOD_NAME_HIGH = '||P_TRX_DATE_PERIOD_NAME_HIGH);
1196: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1197: 'P_TAX_JURISDICTION_CODE = '||P_TAX_JURISDICTION_CODE);
1198: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1192: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1193: 'P_TRX_DATE_PERIOD_NAME_LOW = '||P_TRX_DATE_PERIOD_NAME_LOW);
1194: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1195: 'P_TRX_DATE_PERIOD_NAME_HIGH = '||P_TRX_DATE_PERIOD_NAME_HIGH);
1196: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1197: 'P_TAX_JURISDICTION_CODE = '||P_TAX_JURISDICTION_CODE);
1198: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1199: 'P_TAX_REGIME_CODE = '||P_TAX_REGIME_CODE);
1200: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1194: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1195: 'P_TRX_DATE_PERIOD_NAME_HIGH = '||P_TRX_DATE_PERIOD_NAME_HIGH);
1196: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1197: 'P_TAX_JURISDICTION_CODE = '||P_TAX_JURISDICTION_CODE);
1198: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1199: 'P_TAX_REGIME_CODE = '||P_TAX_REGIME_CODE);
1200: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1201: 'P_TAX = '||P_TAX);
1202: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1196: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1197: 'P_TAX_JURISDICTION_CODE = '||P_TAX_JURISDICTION_CODE);
1198: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1199: 'P_TAX_REGIME_CODE = '||P_TAX_REGIME_CODE);
1200: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1201: 'P_TAX = '||P_TAX);
1202: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1203: 'P_TAX_STATUS_CODE = '||P_TAX_STATUS_CODE);
1204: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1198: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1199: 'P_TAX_REGIME_CODE = '||P_TAX_REGIME_CODE);
1200: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1201: 'P_TAX = '||P_TAX);
1202: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1203: 'P_TAX_STATUS_CODE = '||P_TAX_STATUS_CODE);
1204: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1205: 'P_TAX_RATE_CODE_LOW = '||P_TAX_RATE_CODE_LOW);
1206: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1200: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1201: 'P_TAX = '||P_TAX);
1202: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1203: 'P_TAX_STATUS_CODE = '||P_TAX_STATUS_CODE);
1204: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1205: 'P_TAX_RATE_CODE_LOW = '||P_TAX_RATE_CODE_LOW);
1206: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1207: 'P_TAX_RATE_CODE_HIGH = '||P_TAX_RATE_CODE_HIGH);
1208: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1202: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1203: 'P_TAX_STATUS_CODE = '||P_TAX_STATUS_CODE);
1204: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1205: 'P_TAX_RATE_CODE_LOW = '||P_TAX_RATE_CODE_LOW);
1206: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1207: 'P_TAX_RATE_CODE_HIGH = '||P_TAX_RATE_CODE_HIGH);
1208: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1209: 'P_TAX_TYPE_CODE_LOW = '||P_TAX_TYPE_CODE_LOW);
1210: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1204: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1205: 'P_TAX_RATE_CODE_LOW = '||P_TAX_RATE_CODE_LOW);
1206: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1207: 'P_TAX_RATE_CODE_HIGH = '||P_TAX_RATE_CODE_HIGH);
1208: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1209: 'P_TAX_TYPE_CODE_LOW = '||P_TAX_TYPE_CODE_LOW);
1210: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1211: 'P_TAX_TYPE_CODE_HIGH = '||P_TAX_TYPE_CODE_HIGH);
1212: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1206: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1207: 'P_TAX_RATE_CODE_HIGH = '||P_TAX_RATE_CODE_HIGH);
1208: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1209: 'P_TAX_TYPE_CODE_LOW = '||P_TAX_TYPE_CODE_LOW);
1210: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1211: 'P_TAX_TYPE_CODE_HIGH = '||P_TAX_TYPE_CODE_HIGH);
1212: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1213: 'P_DOCUMENT_SUB_TYPE = '||P_DOCUMENT_SUB_TYPE);
1214: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1208: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1209: 'P_TAX_TYPE_CODE_LOW = '||P_TAX_TYPE_CODE_LOW);
1210: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1211: 'P_TAX_TYPE_CODE_HIGH = '||P_TAX_TYPE_CODE_HIGH);
1212: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1213: 'P_DOCUMENT_SUB_TYPE = '||P_DOCUMENT_SUB_TYPE);
1214: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1215: 'P_TRX_BUSINESS_CATEGORY = '||P_TRX_BUSINESS_CATEGORY);
1216: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1210: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1211: 'P_TAX_TYPE_CODE_HIGH = '||P_TAX_TYPE_CODE_HIGH);
1212: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1213: 'P_DOCUMENT_SUB_TYPE = '||P_DOCUMENT_SUB_TYPE);
1214: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1215: 'P_TRX_BUSINESS_CATEGORY = '||P_TRX_BUSINESS_CATEGORY);
1216: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1217: 'P_TAX_INVOICE_DATE_LOW = '||P_TAX_INVOICE_DATE_LOW);
1218: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1212: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1213: 'P_DOCUMENT_SUB_TYPE = '||P_DOCUMENT_SUB_TYPE);
1214: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1215: 'P_TRX_BUSINESS_CATEGORY = '||P_TRX_BUSINESS_CATEGORY);
1216: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1217: 'P_TAX_INVOICE_DATE_LOW = '||P_TAX_INVOICE_DATE_LOW);
1218: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1219: 'P_TAX_INVOICE_DATE_HIGH = '||P_TAX_INVOICE_DATE_HIGH);
1220: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1214: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1215: 'P_TRX_BUSINESS_CATEGORY = '||P_TRX_BUSINESS_CATEGORY);
1216: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1217: 'P_TAX_INVOICE_DATE_LOW = '||P_TAX_INVOICE_DATE_LOW);
1218: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1219: 'P_TAX_INVOICE_DATE_HIGH = '||P_TAX_INVOICE_DATE_HIGH);
1220: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1221: 'P_POSTING_STATUS = '||P_POSTING_STATUS);
1222: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1216: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1217: 'P_TAX_INVOICE_DATE_LOW = '||P_TAX_INVOICE_DATE_LOW);
1218: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1219: 'P_TAX_INVOICE_DATE_HIGH = '||P_TAX_INVOICE_DATE_HIGH);
1220: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1221: 'P_POSTING_STATUS = '||P_POSTING_STATUS);
1222: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1223: 'P_ACCOUNTING_STATUS = '||P_ACCOUNTING_STATUS);
1224: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1218: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1219: 'P_TAX_INVOICE_DATE_HIGH = '||P_TAX_INVOICE_DATE_HIGH);
1220: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1221: 'P_POSTING_STATUS = '||P_POSTING_STATUS);
1222: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1223: 'P_ACCOUNTING_STATUS = '||P_ACCOUNTING_STATUS);
1224: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1225: 'P_REPORTED_STATUS = '||P_REPORTED_STATUS);
1226: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1220: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1221: 'P_POSTING_STATUS = '||P_POSTING_STATUS);
1222: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1223: 'P_ACCOUNTING_STATUS = '||P_ACCOUNTING_STATUS);
1224: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1225: 'P_REPORTED_STATUS = '||P_REPORTED_STATUS);
1226: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1227: 'P_EXTRACT_ACCTED_TAX_LINES = '||P_EXTRACT_ACCTED_TAX_LINES);
1228: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1222: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1223: 'P_ACCOUNTING_STATUS = '||P_ACCOUNTING_STATUS);
1224: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1225: 'P_REPORTED_STATUS = '||P_REPORTED_STATUS);
1226: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1227: 'P_EXTRACT_ACCTED_TAX_LINES = '||P_EXTRACT_ACCTED_TAX_LINES);
1228: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1229: 'P_INCLUDE_ACCOUNTING_SEGMENTS = '||P_INCLUDE_ACCOUNTING_SEGMENTS);
1230: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1224: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1225: 'P_REPORTED_STATUS = '||P_REPORTED_STATUS);
1226: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1227: 'P_EXTRACT_ACCTED_TAX_LINES = '||P_EXTRACT_ACCTED_TAX_LINES);
1228: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1229: 'P_INCLUDE_ACCOUNTING_SEGMENTS = '||P_INCLUDE_ACCOUNTING_SEGMENTS);
1230: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1231: 'P_BALANCING_SEGMENT_LOW = '||P_BALANCING_SEGMENT_LOW);
1232: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1226: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1227: 'P_EXTRACT_ACCTED_TAX_LINES = '||P_EXTRACT_ACCTED_TAX_LINES);
1228: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1229: 'P_INCLUDE_ACCOUNTING_SEGMENTS = '||P_INCLUDE_ACCOUNTING_SEGMENTS);
1230: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1231: 'P_BALANCING_SEGMENT_LOW = '||P_BALANCING_SEGMENT_LOW);
1232: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1233: 'P_BALANCING_SEGMENT_HIGH = '||P_BALANCING_SEGMENT_HIGH);
1234: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1228: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1229: 'P_INCLUDE_ACCOUNTING_SEGMENTS = '||P_INCLUDE_ACCOUNTING_SEGMENTS);
1230: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1231: 'P_BALANCING_SEGMENT_LOW = '||P_BALANCING_SEGMENT_LOW);
1232: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1233: 'P_BALANCING_SEGMENT_HIGH = '||P_BALANCING_SEGMENT_HIGH);
1234: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1235: 'P_INCLUDE_DISCOUNTS = '||P_INCLUDE_DISCOUNTS);
1236: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1230: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1231: 'P_BALANCING_SEGMENT_LOW = '||P_BALANCING_SEGMENT_LOW);
1232: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1233: 'P_BALANCING_SEGMENT_HIGH = '||P_BALANCING_SEGMENT_HIGH);
1234: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1235: 'P_INCLUDE_DISCOUNTS = '||P_INCLUDE_DISCOUNTS);
1236: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1237: 'P_EXTRACT_STARTING_LINE_NUM = '||P_EXTRACT_STARTING_LINE_NUM);
1238: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1232: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1233: 'P_BALANCING_SEGMENT_HIGH = '||P_BALANCING_SEGMENT_HIGH);
1234: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1235: 'P_INCLUDE_DISCOUNTS = '||P_INCLUDE_DISCOUNTS);
1236: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1237: 'P_EXTRACT_STARTING_LINE_NUM = '||P_EXTRACT_STARTING_LINE_NUM);
1238: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1239: 'P_REQUEST_ID = '||P_REQUEST_ID);
1240: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1234: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1235: 'P_INCLUDE_DISCOUNTS = '||P_INCLUDE_DISCOUNTS);
1236: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1237: 'P_EXTRACT_STARTING_LINE_NUM = '||P_EXTRACT_STARTING_LINE_NUM);
1238: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1239: 'P_REQUEST_ID = '||P_REQUEST_ID);
1240: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1241: 'P_REPORT_NAME = '||P_REPORT_NAME);
1242: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1236: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1237: 'P_EXTRACT_STARTING_LINE_NUM = '||P_EXTRACT_STARTING_LINE_NUM);
1238: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1239: 'P_REQUEST_ID = '||P_REQUEST_ID);
1240: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1241: 'P_REPORT_NAME = '||P_REPORT_NAME);
1242: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1243: 'P_VAT_TRANSACTION_TYPE_CODE = '||P_VAT_TRANSACTION_TYPE_CODE);
1244: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1238: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1239: 'P_REQUEST_ID = '||P_REQUEST_ID);
1240: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1241: 'P_REPORT_NAME = '||P_REPORT_NAME);
1242: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1243: 'P_VAT_TRANSACTION_TYPE_CODE = '||P_VAT_TRANSACTION_TYPE_CODE);
1244: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1245: 'P_INCLUDE_FULLY_NR_TAX_FLAG = '||P_INCLUDE_FULLY_NR_TAX_FLAG);
1246: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1240: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1241: 'P_REPORT_NAME = '||P_REPORT_NAME);
1242: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1243: 'P_VAT_TRANSACTION_TYPE_CODE = '||P_VAT_TRANSACTION_TYPE_CODE);
1244: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1245: 'P_INCLUDE_FULLY_NR_TAX_FLAG = '||P_INCLUDE_FULLY_NR_TAX_FLAG);
1246: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1247: 'P_MUNICIPAL_TAX_TYPE_CODE_LOW = '||P_MUNICIPAL_TAX_TYPE_CODE_LOW);
1248: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1242: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1243: 'P_VAT_TRANSACTION_TYPE_CODE = '||P_VAT_TRANSACTION_TYPE_CODE);
1244: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1245: 'P_INCLUDE_FULLY_NR_TAX_FLAG = '||P_INCLUDE_FULLY_NR_TAX_FLAG);
1246: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1247: 'P_MUNICIPAL_TAX_TYPE_CODE_LOW = '||P_MUNICIPAL_TAX_TYPE_CODE_LOW);
1248: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1249: 'P_MUNICIPAL_TAX_TYPE_CODE_HIGH = '||P_MUNICIPAL_TAX_TYPE_CODE_HIGH);
1250: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1244: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1245: 'P_INCLUDE_FULLY_NR_TAX_FLAG = '||P_INCLUDE_FULLY_NR_TAX_FLAG);
1246: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1247: 'P_MUNICIPAL_TAX_TYPE_CODE_LOW = '||P_MUNICIPAL_TAX_TYPE_CODE_LOW);
1248: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1249: 'P_MUNICIPAL_TAX_TYPE_CODE_HIGH = '||P_MUNICIPAL_TAX_TYPE_CODE_HIGH);
1250: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1251: 'P_PROVINCIAL_TAX_TYPE_CODE_LOW = '||P_PROV_TAX_TYPE_CODE_LOW);
1252: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1246: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1247: 'P_MUNICIPAL_TAX_TYPE_CODE_LOW = '||P_MUNICIPAL_TAX_TYPE_CODE_LOW);
1248: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1249: 'P_MUNICIPAL_TAX_TYPE_CODE_HIGH = '||P_MUNICIPAL_TAX_TYPE_CODE_HIGH);
1250: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1251: 'P_PROVINCIAL_TAX_TYPE_CODE_LOW = '||P_PROV_TAX_TYPE_CODE_LOW);
1252: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1253: 'P_PROVINCIAL_TAX_TYPE__CODE_HIGH = '||P_PROV_TAX_TYPE_CODE_HIGH);
1254: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1248: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1249: 'P_MUNICIPAL_TAX_TYPE_CODE_HIGH = '||P_MUNICIPAL_TAX_TYPE_CODE_HIGH);
1250: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1251: 'P_PROVINCIAL_TAX_TYPE_CODE_LOW = '||P_PROV_TAX_TYPE_CODE_LOW);
1252: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1253: 'P_PROVINCIAL_TAX_TYPE__CODE_HIGH = '||P_PROV_TAX_TYPE_CODE_HIGH);
1254: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1255: 'P_EXCISE_TAX_TYPE_CODE_LOW = '||P_EXCISE_TAX_TYPE_CODE_LOW);
1256: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1250: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1251: 'P_PROVINCIAL_TAX_TYPE_CODE_LOW = '||P_PROV_TAX_TYPE_CODE_LOW);
1252: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1253: 'P_PROVINCIAL_TAX_TYPE__CODE_HIGH = '||P_PROV_TAX_TYPE_CODE_HIGH);
1254: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1255: 'P_EXCISE_TAX_TYPE_CODE_LOW = '||P_EXCISE_TAX_TYPE_CODE_LOW);
1256: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1257: 'P_EXCISE_TAX_TYPE_CODE_HIGH = '||P_EXCISE_TAX_TYPE_CODE_HIGH);
1258: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1252: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1253: 'P_PROVINCIAL_TAX_TYPE__CODE_HIGH = '||P_PROV_TAX_TYPE_CODE_HIGH);
1254: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1255: 'P_EXCISE_TAX_TYPE_CODE_LOW = '||P_EXCISE_TAX_TYPE_CODE_LOW);
1256: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1257: 'P_EXCISE_TAX_TYPE_CODE_HIGH = '||P_EXCISE_TAX_TYPE_CODE_HIGH);
1258: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1259: 'P_NON_TAXABLE_TAX_TYPE_CODE = '||P_NON_TAXABLE_TAX_TYPE_CODE);
1260: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1254: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1255: 'P_EXCISE_TAX_TYPE_CODE_LOW = '||P_EXCISE_TAX_TYPE_CODE_LOW);
1256: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1257: 'P_EXCISE_TAX_TYPE_CODE_HIGH = '||P_EXCISE_TAX_TYPE_CODE_HIGH);
1258: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1259: 'P_NON_TAXABLE_TAX_TYPE_CODE = '||P_NON_TAXABLE_TAX_TYPE_CODE);
1260: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1261: 'P_PERCEPTION_TAX_TYPE_CODE_LOW = '||P_PER_TAX_TYPE_CODE_LOW);
1262: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1256: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1257: 'P_EXCISE_TAX_TYPE_CODE_HIGH = '||P_EXCISE_TAX_TYPE_CODE_HIGH);
1258: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1259: 'P_NON_TAXABLE_TAX_TYPE_CODE = '||P_NON_TAXABLE_TAX_TYPE_CODE);
1260: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1261: 'P_PERCEPTION_TAX_TYPE_CODE_LOW = '||P_PER_TAX_TYPE_CODE_LOW);
1262: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1263: 'P_PERCEPTION_TAX_TYPE_CODE_HIGH = '||P_PER_TAX_TYPE_CODE_HIGH);
1264: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1258: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1259: 'P_NON_TAXABLE_TAX_TYPE_CODE = '||P_NON_TAXABLE_TAX_TYPE_CODE);
1260: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1261: 'P_PERCEPTION_TAX_TYPE_CODE_LOW = '||P_PER_TAX_TYPE_CODE_LOW);
1262: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1263: 'P_PERCEPTION_TAX_TYPE_CODE_HIGH = '||P_PER_TAX_TYPE_CODE_HIGH);
1264: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1265: 'P_FED_PER_TAX_TYPE_CODE_LOW = '||P_FED_PER_TAX_TYPE_CODE_LOW);
1266: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1260: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1261: 'P_PERCEPTION_TAX_TYPE_CODE_LOW = '||P_PER_TAX_TYPE_CODE_LOW);
1262: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1263: 'P_PERCEPTION_TAX_TYPE_CODE_HIGH = '||P_PER_TAX_TYPE_CODE_HIGH);
1264: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1265: 'P_FED_PER_TAX_TYPE_CODE_LOW = '||P_FED_PER_TAX_TYPE_CODE_LOW);
1266: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1267: 'P_FED_PER_TAX_TYPE_CODE_HIGH = '||P_FED_PER_TAX_TYPE_CODE_HIGH);
1268: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1262: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1263: 'P_PERCEPTION_TAX_TYPE_CODE_HIGH = '||P_PER_TAX_TYPE_CODE_HIGH);
1264: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1265: 'P_FED_PER_TAX_TYPE_CODE_LOW = '||P_FED_PER_TAX_TYPE_CODE_LOW);
1266: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1267: 'P_FED_PER_TAX_TYPE_CODE_HIGH = '||P_FED_PER_TAX_TYPE_CODE_HIGH);
1268: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1269: 'P_VAT_TAX_TYPE_CODE = '||P_VAT_TAX_TYPE_CODE);
1270: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1264: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1265: 'P_FED_PER_TAX_TYPE_CODE_LOW = '||P_FED_PER_TAX_TYPE_CODE_LOW);
1266: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1267: 'P_FED_PER_TAX_TYPE_CODE_HIGH = '||P_FED_PER_TAX_TYPE_CODE_HIGH);
1268: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1269: 'P_VAT_TAX_TYPE_CODE = '||P_VAT_TAX_TYPE_CODE);
1270: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1271: 'P_EXCISE_TAX = '||P_EXCISE_TAX);
1272: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1266: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1267: 'P_FED_PER_TAX_TYPE_CODE_HIGH = '||P_FED_PER_TAX_TYPE_CODE_HIGH);
1268: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1269: 'P_VAT_TAX_TYPE_CODE = '||P_VAT_TAX_TYPE_CODE);
1270: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1271: 'P_EXCISE_TAX = '||P_EXCISE_TAX);
1272: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1273: 'P_VAT_ADDITIONAL_TAX = '||P_VAT_ADDITIONAL_TAX);
1274: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1268: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1269: 'P_VAT_TAX_TYPE_CODE = '||P_VAT_TAX_TYPE_CODE);
1270: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1271: 'P_EXCISE_TAX = '||P_EXCISE_TAX);
1272: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1273: 'P_VAT_ADDITIONAL_TAX = '||P_VAT_ADDITIONAL_TAX);
1274: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1275: 'P_VAT_NON_TAXABLE_TAX = '||P_VAT_NON_TAXABLE_TAX);
1276: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1270: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1271: 'P_EXCISE_TAX = '||P_EXCISE_TAX);
1272: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1273: 'P_VAT_ADDITIONAL_TAX = '||P_VAT_ADDITIONAL_TAX);
1274: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1275: 'P_VAT_NON_TAXABLE_TAX = '||P_VAT_NON_TAXABLE_TAX);
1276: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1277: 'P_VAT_NOT_TAX = '||P_VAT_NOT_TAX);
1278: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1272: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1273: 'P_VAT_ADDITIONAL_TAX = '||P_VAT_ADDITIONAL_TAX);
1274: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1275: 'P_VAT_NON_TAXABLE_TAX = '||P_VAT_NON_TAXABLE_TAX);
1276: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1277: 'P_VAT_NOT_TAX = '||P_VAT_NOT_TAX);
1278: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1279: 'P_VAT_PERCEPTION_TAX = '||P_VAT_PERCEPTION_TAX);
1280: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1274: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1275: 'P_VAT_NON_TAXABLE_TAX = '||P_VAT_NON_TAXABLE_TAX);
1276: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1277: 'P_VAT_NOT_TAX = '||P_VAT_NOT_TAX);
1278: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1279: 'P_VAT_PERCEPTION_TAX = '||P_VAT_PERCEPTION_TAX);
1280: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1281: 'P_VAT_TAX = '||P_VAT_TAX);
1282: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1276: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1277: 'P_VAT_NOT_TAX = '||P_VAT_NOT_TAX);
1278: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1279: 'P_VAT_PERCEPTION_TAX = '||P_VAT_PERCEPTION_TAX);
1280: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1281: 'P_VAT_TAX = '||P_VAT_TAX);
1282: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1283: 'P_INC_SELF_WD_TAX = '||P_INC_SELF_WD_TAX);
1284: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1278: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1279: 'P_VAT_PERCEPTION_TAX = '||P_VAT_PERCEPTION_TAX);
1280: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1281: 'P_VAT_TAX = '||P_VAT_TAX);
1282: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1283: 'P_INC_SELF_WD_TAX = '||P_INC_SELF_WD_TAX);
1284: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1285: 'P_EXCLUDING_TRX_LETTER = '||P_EXCLUDING_TRX_LETTER);
1286: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1280: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1281: 'P_VAT_TAX = '||P_VAT_TAX);
1282: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1283: 'P_INC_SELF_WD_TAX = '||P_INC_SELF_WD_TAX);
1284: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1285: 'P_EXCLUDING_TRX_LETTER = '||P_EXCLUDING_TRX_LETTER);
1286: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1287: 'P_TRX_LETTER_LOW = '||P_TRX_LETTER_LOW);
1288: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1282: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1283: 'P_INC_SELF_WD_TAX = '||P_INC_SELF_WD_TAX);
1284: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1285: 'P_EXCLUDING_TRX_LETTER = '||P_EXCLUDING_TRX_LETTER);
1286: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1287: 'P_TRX_LETTER_LOW = '||P_TRX_LETTER_LOW);
1288: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1289: 'P_TRX_LETTER_HIGH = '||P_TRX_LETTER_HIGH);
1290: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1284: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1285: 'P_EXCLUDING_TRX_LETTER = '||P_EXCLUDING_TRX_LETTER);
1286: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1287: 'P_TRX_LETTER_LOW = '||P_TRX_LETTER_LOW);
1288: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1289: 'P_TRX_LETTER_HIGH = '||P_TRX_LETTER_HIGH);
1290: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1291: 'P_INCLUDE_REFERENCED_SOURCE = '||P_INCLUDE_REFERENCED_SOURCE);
1292: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1286: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1287: 'P_TRX_LETTER_LOW = '||P_TRX_LETTER_LOW);
1288: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1289: 'P_TRX_LETTER_HIGH = '||P_TRX_LETTER_HIGH);
1290: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1291: 'P_INCLUDE_REFERENCED_SOURCE = '||P_INCLUDE_REFERENCED_SOURCE);
1292: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1293: 'P_PARTY_NAME = '||P_PARTY_NAME);
1294: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1288: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1289: 'P_TRX_LETTER_HIGH = '||P_TRX_LETTER_HIGH);
1290: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1291: 'P_INCLUDE_REFERENCED_SOURCE = '||P_INCLUDE_REFERENCED_SOURCE);
1292: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1293: 'P_PARTY_NAME = '||P_PARTY_NAME);
1294: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1295: 'P_BATCH_NAME = '||P_BATCH_NAME);
1296: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1290: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1291: 'P_INCLUDE_REFERENCED_SOURCE = '||P_INCLUDE_REFERENCED_SOURCE);
1292: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1293: 'P_PARTY_NAME = '||P_PARTY_NAME);
1294: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1295: 'P_BATCH_NAME = '||P_BATCH_NAME);
1296: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1297: 'P_BATCH_SOURCE_ID = '||P_BATCH_SOURCE_ID);
1298: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1292: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1293: 'P_PARTY_NAME = '||P_PARTY_NAME);
1294: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1295: 'P_BATCH_NAME = '||P_BATCH_NAME);
1296: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1297: 'P_BATCH_SOURCE_ID = '||P_BATCH_SOURCE_ID);
1298: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1299: 'P_ADJUSTED_DOC_FROM = '||P_ADJUSTED_DOC_FROM);
1300: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1294: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1295: 'P_BATCH_NAME = '||P_BATCH_NAME);
1296: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1297: 'P_BATCH_SOURCE_ID = '||P_BATCH_SOURCE_ID);
1298: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1299: 'P_ADJUSTED_DOC_FROM = '||P_ADJUSTED_DOC_FROM);
1300: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1301: 'P_ADJUSTED_DOC_TO = '||P_ADJUSTED_DOC_TO);
1302: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1296: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1297: 'P_BATCH_SOURCE_ID = '||P_BATCH_SOURCE_ID);
1298: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1299: 'P_ADJUSTED_DOC_FROM = '||P_ADJUSTED_DOC_FROM);
1300: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1301: 'P_ADJUSTED_DOC_TO = '||P_ADJUSTED_DOC_TO);
1302: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1303: 'P_STANDARD_VAT_TAX_RATE = '||P_STANDARD_VAT_TAX_RATE);
1304: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1298: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1299: 'P_ADJUSTED_DOC_FROM = '||P_ADJUSTED_DOC_FROM);
1300: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1301: 'P_ADJUSTED_DOC_TO = '||P_ADJUSTED_DOC_TO);
1302: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1303: 'P_STANDARD_VAT_TAX_RATE = '||P_STANDARD_VAT_TAX_RATE);
1304: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1305: 'P_MUNICIPAL_TAX = '||P_MUNICIPAL_TAX);
1306: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1300: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1301: 'P_ADJUSTED_DOC_TO = '||P_ADJUSTED_DOC_TO);
1302: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1303: 'P_STANDARD_VAT_TAX_RATE = '||P_STANDARD_VAT_TAX_RATE);
1304: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1305: 'P_MUNICIPAL_TAX = '||P_MUNICIPAL_TAX);
1306: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1307: 'P_PROVINCIAL_TAX = '||P_PROVINCIAL_TAX);
1308: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1302: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1303: 'P_STANDARD_VAT_TAX_RATE = '||P_STANDARD_VAT_TAX_RATE);
1304: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1305: 'P_MUNICIPAL_TAX = '||P_MUNICIPAL_TAX);
1306: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1307: 'P_PROVINCIAL_TAX = '||P_PROVINCIAL_TAX);
1308: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1309: 'P_TAX_ACCOUNT_LOW = '||P_TAX_ACCOUNT_LOW);
1310: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1304: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1305: 'P_MUNICIPAL_TAX = '||P_MUNICIPAL_TAX);
1306: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1307: 'P_PROVINCIAL_TAX = '||P_PROVINCIAL_TAX);
1308: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1309: 'P_TAX_ACCOUNT_LOW = '||P_TAX_ACCOUNT_LOW);
1310: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1311: 'P_TAX_ACCOUNT_HIGH = '||P_TAX_ACCOUNT_HIGH);
1312: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1306: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1307: 'P_PROVINCIAL_TAX = '||P_PROVINCIAL_TAX);
1308: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1309: 'P_TAX_ACCOUNT_LOW = '||P_TAX_ACCOUNT_LOW);
1310: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1311: 'P_TAX_ACCOUNT_HIGH = '||P_TAX_ACCOUNT_HIGH);
1312: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1313: 'P_EXP_CERT_DATE_FROM = '||P_EXP_CERT_DATE_FROM);
1314: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1308: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1309: 'P_TAX_ACCOUNT_LOW = '||P_TAX_ACCOUNT_LOW);
1310: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1311: 'P_TAX_ACCOUNT_HIGH = '||P_TAX_ACCOUNT_HIGH);
1312: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1313: 'P_EXP_CERT_DATE_FROM = '||P_EXP_CERT_DATE_FROM);
1314: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1315: 'P_EXP_CERT_DATE_TO = '||P_EXP_CERT_DATE_TO);
1316: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1310: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1311: 'P_TAX_ACCOUNT_HIGH = '||P_TAX_ACCOUNT_HIGH);
1312: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1313: 'P_EXP_CERT_DATE_FROM = '||P_EXP_CERT_DATE_FROM);
1314: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1315: 'P_EXP_CERT_DATE_TO = '||P_EXP_CERT_DATE_TO);
1316: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1317: 'P_EXP_METHOD = '||P_EXP_METHOD);
1318: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1312: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1313: 'P_EXP_CERT_DATE_FROM = '||P_EXP_CERT_DATE_FROM);
1314: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1315: 'P_EXP_CERT_DATE_TO = '||P_EXP_CERT_DATE_TO);
1316: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1317: 'P_EXP_METHOD = '||P_EXP_METHOD);
1318: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1319: 'P_TRX_NUMBER_LOW = '||P_TRX_NUMBER_LOW);
1320: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1314: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1315: 'P_EXP_CERT_DATE_TO = '||P_EXP_CERT_DATE_TO);
1316: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1317: 'P_EXP_METHOD = '||P_EXP_METHOD);
1318: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1319: 'P_TRX_NUMBER_LOW = '||P_TRX_NUMBER_LOW);
1320: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1321: 'P_TRX_NUMBER_HIGH = '||P_TRX_NUMBER_HIGH);
1322: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1316: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1317: 'P_EXP_METHOD = '||P_EXP_METHOD);
1318: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1319: 'P_TRX_NUMBER_LOW = '||P_TRX_NUMBER_LOW);
1320: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1321: 'P_TRX_NUMBER_HIGH = '||P_TRX_NUMBER_HIGH);
1322: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1323: 'P_PRINT_COMPANY_INFO = '||P_PRINT_COMPANY_INFO);
1324: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1318: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1319: 'P_TRX_NUMBER_LOW = '||P_TRX_NUMBER_LOW);
1320: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1321: 'P_TRX_NUMBER_HIGH = '||P_TRX_NUMBER_HIGH);
1322: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1323: 'P_PRINT_COMPANY_INFO = '||P_PRINT_COMPANY_INFO);
1324: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1325: 'P_ORDER_BY = '||P_ORDER_BY);
1326: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1320: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1321: 'P_TRX_NUMBER_HIGH = '||P_TRX_NUMBER_HIGH);
1322: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1323: 'P_PRINT_COMPANY_INFO = '||P_PRINT_COMPANY_INFO);
1324: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1325: 'P_ORDER_BY = '||P_ORDER_BY);
1326: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1327: 'P_ERRBUF = '||P_ERRBUF);
1328: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1322: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1323: 'P_PRINT_COMPANY_INFO = '||P_PRINT_COMPANY_INFO);
1324: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1325: 'P_ORDER_BY = '||P_ORDER_BY);
1326: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1327: 'P_ERRBUF = '||P_ERRBUF);
1328: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1329: 'P_RETCODE = '||P_RETCODE);
1330: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1324: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1325: 'P_ORDER_BY = '||P_ORDER_BY);
1326: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1327: 'P_ERRBUF = '||P_ERRBUF);
1328: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1329: 'P_RETCODE = '||P_RETCODE);
1330: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1331: 'P_TAXABLE_ACCOUNT_LOW = '||P_TAXABLE_ACCOUNT_LOW);
1332: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1326: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1327: 'P_ERRBUF = '||P_ERRBUF);
1328: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1329: 'P_RETCODE = '||P_RETCODE);
1330: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1331: 'P_TAXABLE_ACCOUNT_LOW = '||P_TAXABLE_ACCOUNT_LOW);
1332: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1333: 'P_TAXABLE_ACCOUNT_HIGH = '||P_TAXABLE_ACCOUNT_HIGH);
1334: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1328: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1329: 'P_RETCODE = '||P_RETCODE);
1330: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1331: 'P_TAXABLE_ACCOUNT_LOW = '||P_TAXABLE_ACCOUNT_LOW);
1332: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1333: 'P_TAXABLE_ACCOUNT_HIGH = '||P_TAXABLE_ACCOUNT_HIGH);
1334: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1335: 'P_GL_OR_TRX_DATE_FILTER = '||P_GL_OR_TRX_DATE_FILTER); --Bug 5396444
1336: --Bug 9031051
1330: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1331: 'P_TAXABLE_ACCOUNT_LOW = '||P_TAXABLE_ACCOUNT_LOW);
1332: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1333: 'P_TAXABLE_ACCOUNT_HIGH = '||P_TAXABLE_ACCOUNT_HIGH);
1334: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1335: 'P_GL_OR_TRX_DATE_FILTER = '||P_GL_OR_TRX_DATE_FILTER); --Bug 5396444
1336: --Bug 9031051
1337: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1338: 'P_ESL_DEFAULT_TAX_DATE = '||P_ESL_DEFAULT_TAX_DATE);
1333: 'P_TAXABLE_ACCOUNT_HIGH = '||P_TAXABLE_ACCOUNT_HIGH);
1334: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1335: 'P_GL_OR_TRX_DATE_FILTER = '||P_GL_OR_TRX_DATE_FILTER); --Bug 5396444
1336: --Bug 9031051
1337: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1338: 'P_ESL_DEFAULT_TAX_DATE = '||P_ESL_DEFAULT_TAX_DATE);
1339: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1340: 'P_ESL_OUT_OF_PERIOD_ADJ = '||P_ESL_OUT_OF_PERIOD_ADJ);
1341: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1335: 'P_GL_OR_TRX_DATE_FILTER = '||P_GL_OR_TRX_DATE_FILTER); --Bug 5396444
1336: --Bug 9031051
1337: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1338: 'P_ESL_DEFAULT_TAX_DATE = '||P_ESL_DEFAULT_TAX_DATE);
1339: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1340: 'P_ESL_OUT_OF_PERIOD_ADJ = '||P_ESL_OUT_OF_PERIOD_ADJ);
1341: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1342: 'P_ESL_EU_TRX_TYPE = '||P_ESL_EU_TRX_TYPE);
1343: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1337: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1338: 'P_ESL_DEFAULT_TAX_DATE = '||P_ESL_DEFAULT_TAX_DATE);
1339: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1340: 'P_ESL_OUT_OF_PERIOD_ADJ = '||P_ESL_OUT_OF_PERIOD_ADJ);
1341: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1342: 'P_ESL_EU_TRX_TYPE = '||P_ESL_EU_TRX_TYPE);
1343: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1344: 'P_ESL_EU_GOODS = '||P_ESL_EU_GOODS);
1345: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1339: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1340: 'P_ESL_OUT_OF_PERIOD_ADJ = '||P_ESL_OUT_OF_PERIOD_ADJ);
1341: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1342: 'P_ESL_EU_TRX_TYPE = '||P_ESL_EU_TRX_TYPE);
1343: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1344: 'P_ESL_EU_GOODS = '||P_ESL_EU_GOODS);
1345: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1346: 'P_ESL_EU_SERVICES = '||P_ESL_EU_SERVICES);
1347: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1341: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1342: 'P_ESL_EU_TRX_TYPE = '||P_ESL_EU_TRX_TYPE);
1343: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1344: 'P_ESL_EU_GOODS = '||P_ESL_EU_GOODS);
1345: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1346: 'P_ESL_EU_SERVICES = '||P_ESL_EU_SERVICES);
1347: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1348: 'P_ESL_EU_ADDL_CODE1 = '||P_ESL_EU_ADDL_CODE1);
1349: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1343: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1344: 'P_ESL_EU_GOODS = '||P_ESL_EU_GOODS);
1345: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1346: 'P_ESL_EU_SERVICES = '||P_ESL_EU_SERVICES);
1347: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1348: 'P_ESL_EU_ADDL_CODE1 = '||P_ESL_EU_ADDL_CODE1);
1349: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1350: 'P_ESL_EU_ADDL_CODE2 = '||P_ESL_EU_ADDL_CODE2);
1351: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1345: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1346: 'P_ESL_EU_SERVICES = '||P_ESL_EU_SERVICES);
1347: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1348: 'P_ESL_EU_ADDL_CODE1 = '||P_ESL_EU_ADDL_CODE1);
1349: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1350: 'P_ESL_EU_ADDL_CODE2 = '||P_ESL_EU_ADDL_CODE2);
1351: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1352: 'P_ESL_SITE_CODE = '||P_ESL_SITE_CODE);
1353: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1347: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1348: 'P_ESL_EU_ADDL_CODE1 = '||P_ESL_EU_ADDL_CODE1);
1349: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1350: 'P_ESL_EU_ADDL_CODE2 = '||P_ESL_EU_ADDL_CODE2);
1351: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1352: 'P_ESL_SITE_CODE = '||P_ESL_SITE_CODE);
1353: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1354: 'P_USE_PARALLEL_HINT = '||P_USE_PARALLEL_HINT);
1355:
1349: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1350: 'P_ESL_EU_ADDL_CODE2 = '||P_ESL_EU_ADDL_CODE2);
1351: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1352: 'P_ESL_SITE_CODE = '||P_ESL_SITE_CODE);
1353: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1354: 'P_USE_PARALLEL_HINT = '||P_USE_PARALLEL_HINT);
1355:
1356: END IF;
1357:
1535: NULL;
1536: END;
1537: l_length_errbuf := least(l_length_errbuf,2000);
1538: IF (g_level_procedure >= g_current_runtime_level ) THEN
1539: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1540: 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE(-)');
1541: END IF;
1542: P_ERRBUF := NULL;
1543:
1536: END;
1537: l_length_errbuf := least(l_length_errbuf,2000);
1538: IF (g_level_procedure >= g_current_runtime_level ) THEN
1539: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1540: 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE(-)');
1541: END IF;
1542: P_ERRBUF := NULL;
1543:
1544:
1542: P_ERRBUF := NULL;
1543:
1544:
1545: IF (g_level_procedure >= g_current_runtime_level ) THEN
1546: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE.END',
1547: 'Length of errbuf : '||to_char(l_length_errbuf));
1548: END IF;
1549:
1550: EXCEPTION
1554: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','initialize- '|| g_error_buffer);
1555: FND_MSG_PUB.Add;
1556: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1557: FND_LOG.STRING(g_level_unexpected,
1558: 'ZX.TRL.ZX_EXTRACT_PKG.initialize',
1559: 'initialize Check : ');
1560: FND_LOG.STRING(g_level_unexpected,
1561: 'ZX.TRL.ZX_EXTRACT_PKG.initialize', g_error_buffer);
1562: END IF;
1557: FND_LOG.STRING(g_level_unexpected,
1558: 'ZX.TRL.ZX_EXTRACT_PKG.initialize',
1559: 'initialize Check : ');
1560: FND_LOG.STRING(g_level_unexpected,
1561: 'ZX.TRL.ZX_EXTRACT_PKG.initialize', g_error_buffer);
1562: END IF;
1563: APPEND_ERRBUF(g_error_buffer);
1564: P_TRL_GLOBAL_VARIABLES_REC.RETCODE := 2;
1565:
1570: | derive_dependent_parameters |
1571: | |
1572: | DESCRIPTION |
1573: | This procedure derives the dependent parameters |
1574: | for procedure ZX_EXTRACT_PKG.POPULATE |
1575: | |
1576: | Called from ZX_EXTRACT_PKG.POPULATE |
1577: | |
1578: | SCOPE - Private |
1572: | DESCRIPTION |
1573: | This procedure derives the dependent parameters |
1574: | for procedure ZX_EXTRACT_PKG.POPULATE |
1575: | |
1576: | Called from ZX_EXTRACT_PKG.POPULATE |
1577: | |
1578: | SCOPE - Private |
1579: | |
1580: +===========================================================================*/
1579: | |
1580: +===========================================================================*/
1581:
1582: PROCEDURE derive_dependent_parameters (
1583: P_TRL_GLOBAL_VARIABLES_REC IN OUT NOCOPY ZX_EXTRACT_PKG.TRL_GLOBAL_VARIABLES_REC_TYPE)
1584: IS
1585: l_operating_unit_id NUMBER;
1586: l_ledger_name GL_LEDGERS.Name%TYPE;
1587: l_primary_ledger_id NUMBER(15);
1602:
1603: BEGIN
1604:
1605: IF (g_level_procedure >= g_current_runtime_level ) THEN
1606: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.derive_dependent_parameters.BEGIN',
1607: 'ZX.TRL.ZX_EXTRACT_PKG.derive_dependent_parameters(+)');
1608: END IF;
1609:
1610: IF p_trl_global_variables_rec.reporting_level = '1000' THEN
1603: BEGIN
1604:
1605: IF (g_level_procedure >= g_current_runtime_level ) THEN
1606: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.derive_dependent_parameters.BEGIN',
1607: 'ZX.TRL.ZX_EXTRACT_PKG.derive_dependent_parameters(+)');
1608: END IF;
1609:
1610: IF p_trl_global_variables_rec.reporting_level = '1000' THEN
1611: g_ledger_id := p_trl_global_variables_rec.reporting_context;
1610: IF p_trl_global_variables_rec.reporting_level = '1000' THEN
1611: g_ledger_id := p_trl_global_variables_rec.reporting_context;
1612: l_legal_entity_id := p_trl_global_variables_rec.legal_entity_id;
1613: IF (g_level_procedure >= g_current_runtime_level ) THEN
1614: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.derive_dependent_parameters 1000',
1615: 'g_ledger_id : ' || to_char(g_ledger_id) ||
1616: 'l_legal_entity_id : ' || to_char(l_legal_entity_id));
1617: END IF;
1618: ELSIF p_trl_global_variables_rec.reporting_level = '2000' THEN
1618: ELSIF p_trl_global_variables_rec.reporting_level = '2000' THEN
1619: l_legal_entity_id := p_trl_global_variables_rec.reporting_context;
1620: p_trl_global_variables_rec.legal_entity_id := l_legal_entity_id;
1621: IF (g_level_procedure >= g_current_runtime_level ) THEN
1622: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.derive_dependent_parameters 2000',
1623: 'l_legal_entity_id : ' || to_char(l_legal_entity_id));
1624: END IF;
1625:
1626: ELSIF p_trl_global_variables_rec.reporting_level = '3000' THEN
1628: l_legal_entity_id := XLE_UTILITIES_GRP.GET_DefaultLegalContext_OU(l_operating_unit_id);
1629: p_trl_global_variables_rec.legal_entity_id := l_legal_entity_id;
1630:
1631: IF (g_level_procedure >= g_current_runtime_level ) THEN
1632: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.derive_dependent_parameters 3000',
1633: 'l_operating_unit_id : ' || to_char(l_operating_unit_id) ||
1634: 'l_legal_entity_id : ' || to_char(l_legal_entity_id));
1635: END IF;
1636:
1641: g_ledger_id ,
1642: l_ledger_name );
1643: END IF;
1644: IF (g_level_procedure >= g_current_runtime_level ) THEN
1645: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.derive_dependent_parameters 3000.2',
1646: 'l_operating_unit_id : ' || to_char(l_operating_unit_id) ||
1647: 'g_ledger_id : ' || to_char(g_ledger_id) ||
1648: 'l_ledger_name : ' || to_char(l_ledger_name));
1649: END IF;
1652:
1653: IF P_TRL_GLOBAL_VARIABLES_REC.POSTING_STATUS IN ('POSTED','TRANSFERRED') THEN
1654: p_trl_global_variables_rec.accounting_status := 'ACCOUNTED';
1655: IF (g_level_procedure >= g_current_runtime_level ) THEN
1656: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.INITIALIZE',
1657: 'p_trl_global_variables_rec.accounting_status = '||p_trl_global_variables_rec.accounting_status);
1658: END IF;
1659: END IF;
1660:
1680: IF NVL(g_ledger_type,'R') IN ('R','N') THEN
1681: p_trl_global_variables_rec.reporting_ledger_id := nvl(p_trl_global_variables_rec.ledger_id,g_ledger_id);
1682: p_trl_global_variables_rec.accounting_status := 'ACCOUNTED';
1683: IF (g_level_procedure >= g_current_runtime_level ) THEN
1684: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.derive_dependent_parameters',
1685: 'g_ledger_type and Reporting Ledger = '||g_ledger_type||'-'
1686: ||to_char(p_trl_global_variables_rec.reporting_ledger_id));
1687: END IF;
1688: END IF;
1689: END IF;
1690: END IF;
1691:
1692: IF (g_level_procedure >= g_current_runtime_level ) THEN
1693: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.derive_dependent_parameters',
1694: 'Accounting_status = '||p_trl_global_variables_rec.accounting_status);
1695: END IF;
1696:
1697:
1708:
1709: p_trl_global_variables_rec.ledger_id := g_ledger_id;
1710:
1711: IF (g_level_procedure >= g_current_runtime_level ) THEN
1712: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.derive_dependent_parameters',
1713: 'g_ledger_type = '||g_ledger_type||'-'||to_char(g_ledger_id));
1714: END IF;
1715:
1716: IF l_ledger_category <> 'PRIMARY' THEN
1732: CLOSE chart_of_acc_id;
1733: END IF;
1734:
1735: IF (g_level_procedure >= g_current_runtime_level ) THEN
1736: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.derive_dependent_parameters',
1737: 'Ledger Category =' ||l_ledger_category);
1738: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.derive_dependent_parameters',
1739: 'Chart of Accounts ID =' ||to_char(P_TRL_GLOBAL_VARIABLES_REC.chart_of_accounts_id));
1740: END IF;
1734:
1735: IF (g_level_procedure >= g_current_runtime_level ) THEN
1736: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.derive_dependent_parameters',
1737: 'Ledger Category =' ||l_ledger_category);
1738: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.derive_dependent_parameters',
1739: 'Chart of Accounts ID =' ||to_char(P_TRL_GLOBAL_VARIABLES_REC.chart_of_accounts_id));
1740: END IF;
1741:
1742: --derive P_GL_DATE_LOW/HIGH from P_GL_PERIOD_NAME_LOW/HIGH
1755:
1756: END IF;
1757:
1758: IF (g_level_procedure >= g_current_runtime_level ) THEN
1759: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.derive_dependent_parameters',
1760: ' p_trl_global_variables_rec.gl_period_name_low =' ||to_char(p_trl_global_variables_rec.gl_date_low));
1761: END IF;
1762:
1763:
1773:
1774: END IF;
1775:
1776: IF (g_level_procedure >= g_current_runtime_level ) THEN
1777: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.derive_dependent_parameters',
1778: ' p_trl_global_variables_rec.gl_period_name_high ='
1779: ||to_char(p_trl_global_variables_rec.gl_date_high,'DD-MON-YYYY HH24:MI:SS'));
1780: END IF;
1781:
1786: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','populate_tax_data- '|| g_error_buffer);
1787: FND_MSG_PUB.Add;
1788: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1789: FND_LOG.STRING(g_level_unexpected,
1790: 'ZX.TRL.ZX_EXTRACT_PKG.derive_dependent_parameters',
1791: 'Period Name Low and High parameter has error :');
1792: FND_LOG.STRING(g_level_unexpected,
1793: 'ZX.TRL.ZX_EXTRACT_PKG.derive_dependent_parameters',
1794: g_error_buffer);
1789: FND_LOG.STRING(g_level_unexpected,
1790: 'ZX.TRL.ZX_EXTRACT_PKG.derive_dependent_parameters',
1791: 'Period Name Low and High parameter has error :');
1792: FND_LOG.STRING(g_level_unexpected,
1793: 'ZX.TRL.ZX_EXTRACT_PKG.derive_dependent_parameters',
1794: g_error_buffer);
1795: END IF;
1796: APPEND_ERRBUF(g_error_buffer);
1797: P_TRL_GLOBAL_VARIABLES_REC.RETCODE := 2;
1833: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','populate_tax_data- '|| g_error_buffer);
1834: FND_MSG_PUB.Add;
1835: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1836: FND_LOG.STRING(g_level_unexpected,
1837: 'ZX.TRL.ZX_EXTRACT_PKG.derive_dependent_parameters',
1838: 'Transaction Date Low and High parameter has error :');
1839: FND_LOG.STRING(g_level_unexpected,
1840: 'ZX.TRL.ZX_EXTRACT_PKG.derive_dependent_parameters',
1841: g_error_buffer);
1836: FND_LOG.STRING(g_level_unexpected,
1837: 'ZX.TRL.ZX_EXTRACT_PKG.derive_dependent_parameters',
1838: 'Transaction Date Low and High parameter has error :');
1839: FND_LOG.STRING(g_level_unexpected,
1840: 'ZX.TRL.ZX_EXTRACT_PKG.derive_dependent_parameters',
1841: g_error_buffer);
1842: END IF;
1843: APPEND_ERRBUF(g_error_buffer);
1844: P_TRL_GLOBAL_VARIABLES_REC.RETCODE := 2;
1844: P_TRL_GLOBAL_VARIABLES_REC.RETCODE := 2;
1845: END;
1846:
1847: IF (g_level_procedure >= g_current_runtime_level ) THEN
1848: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.derive_dependent_parameters.END',
1849: 'ZX.TRL.ZX_EXTRACT_PKG.derive_dependent_parameters(-)');
1850: END IF;
1851:
1852: EXCEPTION
1845: END;
1846:
1847: IF (g_level_procedure >= g_current_runtime_level ) THEN
1848: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.derive_dependent_parameters.END',
1849: 'ZX.TRL.ZX_EXTRACT_PKG.derive_dependent_parameters(-)');
1850: END IF;
1851:
1852: EXCEPTION
1853: WHEN OTHERS THEN
1856: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','derive_dependent_parameters- '|| g_error_buffer);
1857: FND_MSG_PUB.Add;
1858: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1859: FND_LOG.STRING(g_level_unexpected,
1860: 'ZX.TRL.ZX_EXTRACT_PKG.derive_dependent_parameters',
1861: 'Multi Org Utility : mo_utils.get_ledger_info :');
1862: FND_LOG.STRING(g_level_unexpected,
1863: 'ZX.TRL.ZX_EXTRACT_PKG.derive_dependent_parameters',
1864: g_error_buffer);
1859: FND_LOG.STRING(g_level_unexpected,
1860: 'ZX.TRL.ZX_EXTRACT_PKG.derive_dependent_parameters',
1861: 'Multi Org Utility : mo_utils.get_ledger_info :');
1862: FND_LOG.STRING(g_level_unexpected,
1863: 'ZX.TRL.ZX_EXTRACT_PKG.derive_dependent_parameters',
1864: g_error_buffer);
1865: END IF;
1866: APPEND_ERRBUF(g_error_buffer);
1867: P_TRL_GLOBAL_VARIABLES_REC.RETCODE := 2;
1872: | VALIDATE_PARAMETERS |
1873: | |
1874: | DESCRIPTION |
1875: | This procedure validates the parameters supplied by the user in the |
1876: | ZX_EXTRACT_PKG.POPULATE and gives error message if he parameter |
1877: | values passed are invalid. |
1878: | |
1879: | Called from ZX_EXTRACT_PKG.POPULATE |
1880: | |
1875: | This procedure validates the parameters supplied by the user in the |
1876: | ZX_EXTRACT_PKG.POPULATE and gives error message if he parameter |
1877: | values passed are invalid. |
1878: | |
1879: | Called from ZX_EXTRACT_PKG.POPULATE |
1880: | |
1881: | SCOPE - Private |
1882: | |
1883: | NOTES |
1887: | |
1888: +===========================================================================*/
1889:
1890: FUNCTION VALIDATE_PARAMETERS (
1891: P_TRL_GLOBAL_VARIABLES_REC IN OUT NOCOPY ZX_EXTRACT_PKG.TRL_GLOBAL_VARIABLES_REC_TYPE)
1892: RETURN BOOLEAN IS
1893:
1894: C_ORDER_BY VARCHAR2(30);
1895: l_count NUMBER;
1903:
1904: IF l_count > 0 THEN
1905: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1906: FND_LOG.STRING(g_level_unexpected,
1907: 'ZX.TRL.ZX_EXTRACT_PKG.validate_parameters',
1908: 'Duplicate request ID :');
1909: FND_LOG.STRING(g_level_unexpected,
1910: 'ZX.TRL.ZX_EXTRACT_PKG.validate_parameters',
1911: g_error_buffer);
1906: FND_LOG.STRING(g_level_unexpected,
1907: 'ZX.TRL.ZX_EXTRACT_PKG.validate_parameters',
1908: 'Duplicate request ID :');
1909: FND_LOG.STRING(g_level_unexpected,
1910: 'ZX.TRL.ZX_EXTRACT_PKG.validate_parameters',
1911: g_error_buffer);
1912: END IF;
1913:
1914: END IF;
1922: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','derive_dependent_parameters- '|| g_error_buffer);
1923: FND_MSG_PUB.Add;
1924: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1925: FND_LOG.STRING(g_level_unexpected,
1926: 'ZX.TRL.ZX_EXTRACT_PKG.validate_parameters',
1927: 'Request ID Duplicate check :');
1928: FND_LOG.STRING(g_level_unexpected,
1929: 'ZX.TRL.ZX_EXTRACT_PKG.validate_parameters',
1930: g_error_buffer);
1925: FND_LOG.STRING(g_level_unexpected,
1926: 'ZX.TRL.ZX_EXTRACT_PKG.validate_parameters',
1927: 'Request ID Duplicate check :');
1928: FND_LOG.STRING(g_level_unexpected,
1929: 'ZX.TRL.ZX_EXTRACT_PKG.validate_parameters',
1930: g_error_buffer);
1931: END IF;
1932: APPEND_ERRBUF(g_error_buffer);
1933: P_TRL_GLOBAL_VARIABLES_REC.RETCODE := 2;
1940: | extract_rep_context_info |
1941: | |
1942: | description |
1943: | this PROCEDURE gets the reporting context for the header record |
1944: | called FROM the constructor of zx_extract_pkg |
1945: | |
1946: | scope - private |
1947: | |
1948: | notes |
1950: | |
1951: +===========================================================================*/
1952:
1953: PROCEDURE extract_rep_context_info (
1954: p_trl_global_variables_rec IN OUT NOCOPY ZX_EXTRACT_PKG.trl_global_variables_rec_type)
1955: IS
1956: l_operating_unit_id NUMBER;
1957: l_reporting_context_org_id NUMBER(15);
1958: l_reporting_context_tax_reg_no VARCHAR2(60);
1971: */
1972: BEGIN
1973:
1974: IF (g_level_procedure >= g_current_runtime_level ) THEN
1975: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.extract_rep_context_info.BEGIN',
1976: 'ZX.TRL.ZX_EXTRACT_PKG.extract_rep_context_info(+)');
1977: END IF;
1978:
1979: -- get the structure of address location dff
1972: BEGIN
1973:
1974: IF (g_level_procedure >= g_current_runtime_level ) THEN
1975: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.extract_rep_context_info.BEGIN',
1976: 'ZX.TRL.ZX_EXTRACT_PKG.extract_rep_context_info(+)');
1977: END IF;
1978:
1979: -- get the structure of address location dff
1980:
1984: pr_flexfield,
1985: pr_flexinfo);
1986:
1987: IF (g_level_procedure >= g_current_runtime_level ) THEN
1988: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.extract_rep_context_info.BEGIN',
1989: 'pr_flexfield :');
1990: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.extract_rep_context_info',
1991: 'p_trl_global_variables_rec.legal_entity_id : p_trl_global_variables_rec.legal_entity_id');
1992:
1986:
1987: IF (g_level_procedure >= g_current_runtime_level ) THEN
1988: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.extract_rep_context_info.BEGIN',
1989: 'pr_flexfield :');
1990: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.extract_rep_context_info',
1991: 'p_trl_global_variables_rec.legal_entity_id : p_trl_global_variables_rec.legal_entity_id');
1992:
1993: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.extract_rep_context_info',
1994: 'Before call to insert_rep_context_itf');
1989: 'pr_flexfield :');
1990: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.extract_rep_context_info',
1991: 'p_trl_global_variables_rec.legal_entity_id : p_trl_global_variables_rec.legal_entity_id');
1992:
1993: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.extract_rep_context_info',
1994: 'Before call to insert_rep_context_itf');
1995:
1996: END IF;
1997:
2004: /* apai
2005: ELSIF p_trl_global_variables_rec.reporting_level = '1000' THEN
2006:
2007: IF (g_level_procedure >= g_current_runtime_level ) THEN
2008: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.extract_rep_context_info.BEGIN',
2009: 'ZX.TRL.ZX_EXTRACT_PKG.extract_rep_context_info : Call to insert_rep_context_itf');
2010: END IF;
2011:
2012: BEGIN
2005: ELSIF p_trl_global_variables_rec.reporting_level = '1000' THEN
2006:
2007: IF (g_level_procedure >= g_current_runtime_level ) THEN
2008: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.extract_rep_context_info.BEGIN',
2009: 'ZX.TRL.ZX_EXTRACT_PKG.extract_rep_context_info : Call to insert_rep_context_itf');
2010: END IF;
2011:
2012: BEGIN
2013: -- IF g_ledger_type = 'R' THEN
2030: -- FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','populate_tax_data- '|| g_error_buffer);
2031: -- FND_MSG_PUB.Add;
2032: IF (g_level_unexpected >= g_current_runtime_level ) THEN
2033: FND_LOG.STRING(g_level_unexpected,
2034: 'ZX.TRL.ZX_EXTRACT_PKG.extract_rep_context_info',
2035: g_error_buffer);
2036: END IF;
2037:
2038: P_TRL_GLOBAL_VARIABLES_REC.RETCODE := 2;
2054: l_operating_unit_id);
2055: END IF; -- reporting level
2056: */
2057: IF (g_level_procedure >= g_current_runtime_level ) THEN
2058: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.extract_rep_context_info.END',
2059: 'ZX.TRL.ZX_EXTRACT_PKG.extract_rep_context_info(-)');
2060: END IF;
2061:
2062: EXCEPTION
2055: END IF; -- reporting level
2056: */
2057: IF (g_level_procedure >= g_current_runtime_level ) THEN
2058: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.extract_rep_context_info.END',
2059: 'ZX.TRL.ZX_EXTRACT_PKG.extract_rep_context_info(-)');
2060: END IF;
2061:
2062: EXCEPTION
2063: WHEN OTHERS THEN
2066: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','populate_tax_data- '|| g_error_buffer);
2067: FND_MSG_PUB.Add;
2068: IF (g_level_unexpected >= g_current_runtime_level ) THEN
2069: FND_LOG.STRING(g_level_unexpected,
2070: 'ZX.TRL.ZX_EXTRACT_PKG.extract_rep_context_info',
2071: g_error_buffer);
2072: END IF;
2073: APPEND_ERRBUF(g_error_buffer);
2074: P_TRL_GLOBAL_VARIABLES_REC.RETCODE := 2;
2080: | PROCEDURE |
2081: | extract_tax_info |
2082: | |
2083: | DESCRIPTION |
2084: | Called from ZX_EXTRACT_PKG.populate_tax_data |
2085: | |
2086: | SCOPE - Private |
2087: | |
2088: | NOTES |
2092: +===========================================================================*/
2093:
2094: PROCEDURE EXTRACT_TAX_INFO(
2095: p_ledger_type IN VARCHAR2,
2096: P_TRL_GLOBAL_VARIABLES_REC IN OUT NOCOPY ZX_EXTRACT_PKG.TRL_GLOBAL_VARIABLES_REC_TYPE)
2097: IS
2098:
2099: BEGIN
2100:
2098:
2099: BEGIN
2100:
2101: IF (g_level_procedure >= g_current_runtime_level ) THEN
2102: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.EXTRACT_TAX_INFO.BEGIN',
2103: 'ZX_EXTRACT_PKG:EXTRACT_TAX_INFO(+)');
2104: END IF;
2105: -- Need to remove this code since the accounting and non accounting apis are merged
2106: /*
2099: BEGIN
2100:
2101: IF (g_level_procedure >= g_current_runtime_level ) THEN
2102: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.EXTRACT_TAX_INFO.BEGIN',
2103: 'ZX_EXTRACT_PKG:EXTRACT_TAX_INFO(+)');
2104: END IF;
2105: -- Need to remove this code since the accounting and non accounting apis are merged
2106: /*
2107: IF P_TRL_GLOBAL_VARIABLES_REC.EXTRACT_ACCTED_TAX_LINES = 'Y' OR
2186:
2187:
2188:
2189: IF (g_level_procedure >= g_current_runtime_level ) THEN
2190: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.extract_tax_info.END',
2191: 'ZX_EXTRACT_PKG:extract_tax_info(-)');
2192: END IF;
2193:
2194: EXCEPTION
2187:
2188:
2189: IF (g_level_procedure >= g_current_runtime_level ) THEN
2190: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.extract_tax_info.END',
2191: 'ZX_EXTRACT_PKG:extract_tax_info(-)');
2192: END IF;
2193:
2194: EXCEPTION
2195: WHEN OTHERS THEN
2198: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','populate_tax_data- '|| g_error_buffer);
2199: FND_MSG_PUB.Add;
2200: IF (g_level_unexpected >= g_current_runtime_level ) THEN
2201: FND_LOG.STRING(g_level_unexpected,
2202: 'ZX.TRL.ZX_EXTRACT_PKG.extract_tax_info',
2203: g_error_buffer);
2204: END IF;
2205: APPEND_ERRBUF(g_error_buffer);
2206: P_TRL_GLOBAL_VARIABLES_REC.RETCODE := 2;
2214: | DESCRIPTION |
2215: | This procedure populates Additional information in |
2216: | zx_rep_context_t |
2217: | |
2218: | Called from ZX_EXTRACT_PKG.POPULATE |
2219: | |
2220: | MODIFICATION HISTORY |
2221: | 08-Feb-2005 Srinivasa Rao Korrapati Created |
2222: +===========================================================================*/
2222: +===========================================================================*/
2223:
2224: PROCEDURE extract_additional_info(
2225: p_ledger_type IN VARCHAR2,
2226: P_TRL_GLOBAL_VARIABLES_REC IN OUT NOCOPY ZX_EXTRACT_PKG.TRL_GLOBAL_VARIABLES_REC_TYPE)
2227: IS
2228:
2229:
2230: /*CURSOR rep_context_cursor(
2249: rep_context.rep_entity_id
2250: FROM zx_rep_context_t rep_context
2251: WHERE rep_context.request_id = c_request_id;
2252:
2253: l_rep_context_id_rec zx_extract_pkg.rep_context_id_rectype;
2254: i BINARY_INTEGER;
2255: l_org_id NUMBER;
2256: l_ledger_id NUMBER;
2257:
2257:
2258: BEGIN
2259:
2260: IF (g_level_procedure >= g_current_runtime_level ) THEN
2261: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.extract_additional_info.BEGIN',
2262: 'ZX_EXTRACT_PKG:extract_additional_info(+)');
2263: END IF;
2264:
2265: BEGIN
2258: BEGIN
2259:
2260: IF (g_level_procedure >= g_current_runtime_level ) THEN
2261: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.extract_additional_info.BEGIN',
2262: 'ZX_EXTRACT_PKG:extract_additional_info(+)');
2263: END IF;
2264:
2265: BEGIN
2266: -- IF p_ledger_type = 'R' THEN
2287: FETCH rep_context_cursor INTO l_rep_context_id_rec;
2288: EXIT WHEN rep_context_cursor%NOTFOUND;
2289: rep_context_id_tab(i) := l_rep_context_id_rec;
2290: IF (g_level_procedure >= g_current_runtime_level ) THEN
2291: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.extract_additional_info',
2292: 'rep_context_id_tab(i)'||to_char(rep_context_id_tab(i).rep_context_id));
2293: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.extract_additional_info',
2294: 'l_rep_context_id_rec :'||to_char(l_rep_context_id_rec.rep_context_id));
2295: END IF;
2289: rep_context_id_tab(i) := l_rep_context_id_rec;
2290: IF (g_level_procedure >= g_current_runtime_level ) THEN
2291: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.extract_additional_info',
2292: 'rep_context_id_tab(i)'||to_char(rep_context_id_tab(i).rep_context_id));
2293: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.extract_additional_info',
2294: 'l_rep_context_id_rec :'||to_char(l_rep_context_id_rec.rep_context_id));
2295: END IF;
2296: i := i + 1;
2297:
2308: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','extract_additional_info- '|| g_error_buffer);
2309: FND_MSG_PUB.Add;
2310: IF (g_level_unexpected >= g_current_runtime_level ) THEN
2311: FND_LOG.STRING(g_level_unexpected,
2312: 'ZX.TRL.ZX_EXTRACT_PKG.extract_additional_info',
2313: g_error_buffer);
2314: END IF;
2315:
2316: END;
2351: END IF;
2352:
2353: -- Call to JX populate Plug-in APIs
2354: IF (g_level_procedure >= g_current_runtime_level ) THEN
2355: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.extract_additional_info',
2356: 'AR JX product Call: Return Code : '||to_char(L_AR_RETCODE));
2357: END IF;
2358:
2359: -- ZX_JL_EXTRACT_PKG.populate_jl_ar(P_TRL_GLOBAL_VARIABLES_REC);
2375: END IF;
2376: END IF;
2377:
2378: IF (g_level_procedure >= g_current_runtime_level ) THEN
2379: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.extract_additional_info',
2380: 'AP JX product Call: Return Code : '||to_char(L_AP_RETCODE));
2381: END IF;
2382: IF P_TRL_GLOBAL_VARIABLES_REC.PRODUCT = 'AP' OR
2383: P_TRL_GLOBAL_VARIABLES_REC.PRODUCT = 'ALL'
2382: IF P_TRL_GLOBAL_VARIABLES_REC.PRODUCT = 'AP' OR
2383: P_TRL_GLOBAL_VARIABLES_REC.PRODUCT = 'ALL'
2384: THEN
2385: IF (g_level_procedure >= g_current_runtime_level ) THEN
2386: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.extract_additional_info',
2387: 'AP JL product Call: Return Code : '||P_TRL_GLOBAL_VARIABLES_REC.PRODUCT);
2388: END IF;
2389:
2390: IF L_AP_RETCODE <> 2 THEN
2388: END IF;
2389:
2390: IF L_AP_RETCODE <> 2 THEN
2391: IF (g_level_procedure >= g_current_runtime_level ) THEN
2392: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.extract_additional_info',
2393: 'AP JL product Call: Return Code : '||to_char(L_AP_RETCODE));
2394: END IF;
2395: IF P_TRL_GLOBAL_VARIABLES_REC.REPORT_NAME = 'RXZXPFTR' THEN
2396: ZX_CORE_REP_EXTRACT_PKG.populate_core_ap(P_TRL_GLOBAL_VARIABLES_REC);
2401: -- This is to update recovery rate and IPV amounts --
2402: ZX_CORE_REP_EXTRACT_PKG.populate_core_ap(P_TRL_GLOBAL_VARIABLES_REC);
2403: ELSIF SUBSTR(P_TRL_GLOBAL_VARIABLES_REC.REPORT_NAME,3,2) IN ('AR','CL','CO') THEN
2404: IF (g_level_procedure >= g_current_runtime_level ) THEN
2405: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.extract_additional_info',
2406: 'AP JL product Call: Return Code : '||'populate_jl_ap');
2407: END IF;
2408:
2409: ZX_JL_EXTRACT_PKG.populate_jl_ap(P_TRL_GLOBAL_VARIABLES_REC);
2433: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','populate_tax_data- '|| g_error_buffer);
2434: FND_MSG_PUB.Add;
2435: IF (g_level_unexpected >= g_current_runtime_level ) THEN
2436: FND_LOG.STRING(g_level_unexpected,
2437: 'ZX.TRL.ZX_EXTRACT_PKG.extract_additional_info',
2438: g_error_buffer);
2439: END IF;
2440: APPEND_ERRBUF(g_error_buffer);
2441: P_TRL_GLOBAL_VARIABLES_REC.RETCODE := 2;
2451: | This procedure deletes the records from AR_TAX_EXTRACT_DCL_IF |
2452: | which do not have any child records in AR_TAX_EXTRACT_SUB_ITF |
2453: | for the given request_id |
2454: | |
2455: | Called from ZX_EXTRACT_PKG.POPULATE |
2456: | |
2457: | SCOPE - Private |
2458: | |
2459: | NOTES |
2462: | |
2463: +===========================================================================*/
2464:
2465: PROCEDURE CLEANUP (
2466: P_TRL_GLOBAL_VARIABLES_REC IN OUT NOCOPY ZX_EXTRACT_PKG.TRL_GLOBAL_VARIABLES_REC_TYPE
2467: ) IS
2468:
2469: j number := 0;
2470: l_declarer_id number;
2559:
2560: EXCEPTION
2561: WHEN OTHERS THEN
2562: STACK_ERROR('FND','SQL_PLSQL_ERROR','ERRNO',SQLCODE,'REASON',SQLERRM,
2563: 'ROUTINE','ZX_EXTRACT_PKG.CLEANUP');
2564: L_MSG := FND_MESSAGE.GET;
2565:
2566: END;
2567:
2594: | and AR_TAX_EXTRACT_SUB_ITF for a given request_id. This procedure |
2595: | is called from the procedure populate if some fatal error condition |
2596: | occurs and error_code is set to 2 |
2597: | |
2598: | Called from ZX_EXTRACT_PKG.POPULATE |
2599: | |
2600: | SCOPE - Private |
2601: | |
2602: | NOTES |
2644: | 08-Feb-2005 Srinivasa Rao Korrapati Created |
2645: +===========================================================================*/
2646:
2647: PROCEDURE insert_rep_context_itf(
2648: p_trl_global_variables_rec IN OUT NOCOPY zx_extract_pkg.trl_global_variables_rec_type,
2649: p_rep_entity_id IN NUMBER)
2650: IS
2651:
2652: l_style HR_LOCATIONS_ALL.style%TYPE;
2816:
2817: BEGIN
2818:
2819: IF (g_level_procedure >= g_current_runtime_level ) THEN
2820: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf.BEGIN',
2821: 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf(+)');
2822: END IF;
2823:
2824: IF p_trl_global_variables_rec.summary_level = 'TRANSACTION_DISTRIBUTION' THEN
2817: BEGIN
2818:
2819: IF (g_level_procedure >= g_current_runtime_level ) THEN
2820: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf.BEGIN',
2821: 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf(+)');
2822: END IF;
2823:
2824: IF p_trl_global_variables_rec.summary_level = 'TRANSACTION_DISTRIBUTION' THEN
2825: l_extract_summary_code := 'D';
2839: END IF;
2840:
2841: --Bug 5438409
2842: IF (g_level_statement >= g_current_runtime_level ) THEN
2843: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
2844: 'l_rep_context_lvl_mng : '||l_rep_context_lvl_mng);
2845: END IF;
2846:
2847: /* apai
2880: l_legal_contact_job_title;
2881: CLOSE c_legal_contact_info;
2882:
2883: IF (g_level_statement >= g_current_runtime_level ) THEN
2884: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
2885: 'l_rep_context_name : '|| l_rep_context_name);
2886: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
2887: 'l_activity_code : '|| l_activity_code);
2888: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
2882:
2883: IF (g_level_statement >= g_current_runtime_level ) THEN
2884: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
2885: 'l_rep_context_name : '|| l_rep_context_name);
2886: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
2887: 'l_activity_code : '|| l_activity_code);
2888: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
2889: 'l_sub_activity_code : '|| l_sub_activity_code);
2890: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
2884: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
2885: 'l_rep_context_name : '|| l_rep_context_name);
2886: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
2887: 'l_activity_code : '|| l_activity_code);
2888: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
2889: 'l_sub_activity_code : '|| l_sub_activity_code);
2890: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
2891: 'l_taxpayer_id : '|| l_taxpayer_id);
2892: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
2886: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
2887: 'l_activity_code : '|| l_activity_code);
2888: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
2889: 'l_sub_activity_code : '|| l_sub_activity_code);
2890: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
2891: 'l_taxpayer_id : '|| l_taxpayer_id);
2892: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
2893: 'l_rep_context_loc_id : '|| l_rep_context_loc_id);
2894: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
2888: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
2889: 'l_sub_activity_code : '|| l_sub_activity_code);
2890: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
2891: 'l_taxpayer_id : '|| l_taxpayer_id);
2892: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
2893: 'l_rep_context_loc_id : '|| l_rep_context_loc_id);
2894: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
2895: 'g_rep_context_address1 : '|| g_rep_context_address1);
2896: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
2890: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
2891: 'l_taxpayer_id : '|| l_taxpayer_id);
2892: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
2893: 'l_rep_context_loc_id : '|| l_rep_context_loc_id);
2894: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
2895: 'g_rep_context_address1 : '|| g_rep_context_address1);
2896: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
2897: 'g_rep_context_city : '|| g_rep_context_city);
2898:
2892: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
2893: 'l_rep_context_loc_id : '|| l_rep_context_loc_id);
2894: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
2895: 'g_rep_context_address1 : '|| g_rep_context_address1);
2896: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
2897: 'g_rep_context_city : '|| g_rep_context_city);
2898:
2899: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
2900: 'l_style : '|| l_style);
2895: 'g_rep_context_address1 : '|| g_rep_context_address1);
2896: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
2897: 'g_rep_context_city : '|| g_rep_context_city);
2898:
2899: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
2900: 'l_style : '|| l_style);
2901: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
2902: 'l_legal_contact_party_name : '|| l_legal_contact_party_name);
2903: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
2897: 'g_rep_context_city : '|| g_rep_context_city);
2898:
2899: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
2900: 'l_style : '|| l_style);
2901: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
2902: 'l_legal_contact_party_name : '|| l_legal_contact_party_name);
2903: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
2904: 'l_legal_contact_title : '|| l_legal_contact_title);
2905: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
2899: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
2900: 'l_style : '|| l_style);
2901: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
2902: 'l_legal_contact_party_name : '|| l_legal_contact_party_name);
2903: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
2904: 'l_legal_contact_title : '|| l_legal_contact_title);
2905: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
2906: 'l_legal_contact_party_num : '|| l_legal_contact_party_num);
2907:
2901: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
2902: 'l_legal_contact_party_name : '|| l_legal_contact_party_name);
2903: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
2904: 'l_legal_contact_title : '|| l_legal_contact_title);
2905: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
2906: 'l_legal_contact_party_num : '|| l_legal_contact_party_num);
2907:
2908: END IF;
2909:
2915: l_legal_auth_name ;
2916: CLOSE c_legal_auth_info;
2917:
2918: IF (g_level_statement >= g_current_runtime_level ) THEN
2919: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
2920: 'l_legal_auth_address_line2 : '|| l_legal_auth_address_line2);
2921: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
2922: 'l_legal_auth_address_line3 : '|| l_legal_auth_address_line3);
2923: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
2917:
2918: IF (g_level_statement >= g_current_runtime_level ) THEN
2919: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
2920: 'l_legal_auth_address_line2 : '|| l_legal_auth_address_line2);
2921: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
2922: 'l_legal_auth_address_line3 : '|| l_legal_auth_address_line3);
2923: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
2924: 'l_legal_auth_city : '|| l_legal_auth_city);
2925: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
2919: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
2920: 'l_legal_auth_address_line2 : '|| l_legal_auth_address_line2);
2921: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
2922: 'l_legal_auth_address_line3 : '|| l_legal_auth_address_line3);
2923: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
2924: 'l_legal_auth_city : '|| l_legal_auth_city);
2925: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
2926: 'l_legal_auth_name : '|| l_legal_auth_name);
2927: END IF;
2921: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
2922: 'l_legal_auth_address_line3 : '|| l_legal_auth_address_line3);
2923: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
2924: 'l_legal_auth_city : '|| l_legal_auth_city);
2925: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
2926: 'l_legal_auth_name : '|| l_legal_auth_name);
2927: END IF;
2928:
2929: /* apai
2961: END IF;
2962: */
2963:
2964: IF (g_level_procedure >= g_current_runtime_level ) THEN
2965: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
2966: 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf: After c_loc_rec cursor ');
2967: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
2968: 'p_rep_entity_id :'||to_char(p_rep_entity_id));
2969: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
2962: */
2963:
2964: IF (g_level_procedure >= g_current_runtime_level ) THEN
2965: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
2966: 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf: After c_loc_rec cursor ');
2967: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
2968: 'p_rep_entity_id :'||to_char(p_rep_entity_id));
2969: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
2970: 'g_rep_context_city :'||g_rep_context_city);
2963:
2964: IF (g_level_procedure >= g_current_runtime_level ) THEN
2965: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
2966: 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf: After c_loc_rec cursor ');
2967: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
2968: 'p_rep_entity_id :'||to_char(p_rep_entity_id));
2969: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
2970: 'g_rep_context_city :'||g_rep_context_city);
2971: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
2965: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
2966: 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf: After c_loc_rec cursor ');
2967: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
2968: 'p_rep_entity_id :'||to_char(p_rep_entity_id));
2969: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
2970: 'g_rep_context_city :'||g_rep_context_city);
2971: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
2972: 'g_rep_context_address1 :'||g_rep_context_address1);
2973: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
2967: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
2968: 'p_rep_entity_id :'||to_char(p_rep_entity_id));
2969: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
2970: 'g_rep_context_city :'||g_rep_context_city);
2971: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
2972: 'g_rep_context_address1 :'||g_rep_context_address1);
2973: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
2974: 'l_rep_context_name :'||l_rep_context_name);
2975: END IF;
2969: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
2970: 'g_rep_context_city :'||g_rep_context_city);
2971: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
2972: 'g_rep_context_address1 :'||g_rep_context_address1);
2973: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
2974: 'l_rep_context_name :'||l_rep_context_name);
2975: END IF;
2976:
2977: -- populate the legal entity address fields :
3017: SELECT zx_rep_context_t_s.nextval
3018: INTO l_rep_context_id FROM dual;
3019:
3020: IF (g_level_procedure >= g_current_runtime_level ) THEN
3021: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
3022: 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf: Insert statement begins ');
3023: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
3024: 'p_rep_entity_id :'||to_char(p_rep_entity_id));
3025: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
3018: INTO l_rep_context_id FROM dual;
3019:
3020: IF (g_level_procedure >= g_current_runtime_level ) THEN
3021: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
3022: 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf: Insert statement begins ');
3023: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
3024: 'p_rep_entity_id :'||to_char(p_rep_entity_id));
3025: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
3026: 'rep_context_id :'||to_char(l_rep_context_id));
3019:
3020: IF (g_level_procedure >= g_current_runtime_level ) THEN
3021: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
3022: 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf: Insert statement begins ');
3023: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
3024: 'p_rep_entity_id :'||to_char(p_rep_entity_id));
3025: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
3026: 'rep_context_id :'||to_char(l_rep_context_id));
3027: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
3021: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
3022: 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf: Insert statement begins ');
3023: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
3024: 'p_rep_entity_id :'||to_char(p_rep_entity_id));
3025: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
3026: 'rep_context_id :'||to_char(l_rep_context_id));
3027: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
3028: 'l_rep_context_city :'||l_rep_context_city);
3029: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
3023: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
3024: 'p_rep_entity_id :'||to_char(p_rep_entity_id));
3025: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
3026: 'rep_context_id :'||to_char(l_rep_context_id));
3027: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
3028: 'l_rep_context_city :'||l_rep_context_city);
3029: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
3030: 'l_rep_context_address1 :'||l_rep_context_address1);
3031: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
3025: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
3026: 'rep_context_id :'||to_char(l_rep_context_id));
3027: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
3028: 'l_rep_context_city :'||l_rep_context_city);
3029: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
3030: 'l_rep_context_address1 :'||l_rep_context_address1);
3031: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
3032: 'HQ Tax Registration Nbr : l_org_information2 :'||l_org_information2);
3033: END IF;
3027: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
3028: 'l_rep_context_city :'||l_rep_context_city);
3029: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
3030: 'l_rep_context_address1 :'||l_rep_context_address1);
3031: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
3032: 'HQ Tax Registration Nbr : l_org_information2 :'||l_org_information2);
3033: END IF;
3034:
3035: Begin
3119:
3120: l_rowcount := SQL%ROWCOUNT;
3121: IF (g_level_unexpected >= g_current_runtime_level ) THEN
3122: FND_LOG.STRING(g_level_unexpected,
3123: 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
3124: 'Rows Inserted in Rep context table :'||to_char(l_rowcount));
3125: END IF;
3126:
3127: IF l_rowcount = 0 THEN
3127: IF l_rowcount = 0 THEN
3128: P_TRL_GLOBAL_VARIABLES_REC.RETCODE := 2;
3129: IF (g_level_unexpected >= g_current_runtime_level ) THEN
3130: FND_LOG.STRING(g_level_unexpected,
3131: 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
3132: 'P_TRL_GLOBAL_VARIABLES_REC.RETCODE'||to_char(P_TRL_GLOBAL_VARIABLES_REC.RETCODE));
3133: END IF;
3134:
3135: END IF;
3142: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','insert_rep_context_itf- '|| g_error_buffer);
3143: FND_MSG_PUB.Add;
3144: IF (g_level_unexpected >= g_current_runtime_level ) THEN
3145: FND_LOG.STRING(g_level_unexpected,
3146: 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf',
3147: g_error_buffer);
3148: END IF;
3149: APPEND_ERRBUF(g_error_buffer);
3150: P_TRL_GLOBAL_VARIABLES_REC.RETCODE := 2;
3151:
3152: END;
3153:
3154: IF (g_level_procedure >= g_current_runtime_level ) THEN
3155: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf.END',
3156: 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf(-)');
3157: END IF;
3158:
3159: END insert_rep_context_itf ;
3152: END;
3153:
3154: IF (g_level_procedure >= g_current_runtime_level ) THEN
3155: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf.END',
3156: 'ZX.TRL.ZX_EXTRACT_PKG.insert_rep_context_itf(-)');
3157: END IF;
3158:
3159: END insert_rep_context_itf ;
3160:
3179:
3180: BEGIN
3181:
3182: IF (g_level_procedure >= g_current_runtime_level ) THEN
3183: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.location_value.BEGIN',
3184: 'ZX.TRL.ZX_EXTRACT_PKG.location_value(+)');
3185: END IF;
3186:
3187: l_column := p_column;
3180: BEGIN
3181:
3182: IF (g_level_procedure >= g_current_runtime_level ) THEN
3183: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.location_value.BEGIN',
3184: 'ZX.TRL.ZX_EXTRACT_PKG.location_value(+)');
3185: END IF;
3186:
3187: l_column := p_column;
3188: IF l_column = 'TOWN_OR_CITY' THEN
3209: l_column_value := g_rep_context_phone_number;
3210: END IF;
3211:
3212: IF (g_level_procedure >= g_current_runtime_level ) THEN
3213: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.location_value.END',
3214: 'ZX.TRL.ZX_EXTRACT_PKG.location_value(-)'||l_column_value);
3215: END IF;
3216:
3217: RETURN l_column_value;
3210: END IF;
3211:
3212: IF (g_level_procedure >= g_current_runtime_level ) THEN
3213: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.location_value.END',
3214: 'ZX.TRL.ZX_EXTRACT_PKG.location_value(-)'||l_column_value);
3215: END IF;
3216:
3217: RETURN l_column_value;
3218:
3222: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
3223: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','location_value- '|| g_error_buffer);
3224: FND_MSG_PUB.Add;
3225: IF (g_level_unexpected >= g_current_runtime_level ) THEN
3226: FND_LOG.STRING(g_level_unexpected, 'ZX.TRL.ZX_EXTRACT_PKG.location_value',
3227: g_error_buffer);
3228: END IF;
3229: APPEND_ERRBUF(g_error_buffer);
3230: --P_TRL_GLOBAL_VARIABLES_REC.RETCODE := 2;
3242: | For example, if the location style is US then the column REGION1 |
3243: | is used to store COUNTY information, but if the style is CN the |
3244: | same column may store PROVINCE information. |
3245: | |
3246: | Called from ZX_EXTRACT_PKG.POPULATE_TAX_DATA() |
3247: | |
3248: | SCOPE - Private |
3249: | |
3250: | NOTES |
3273:
3274: -- Get the context information from 'Address Location' Descriptive Flexfield
3275: -- Select the context value which matches p_org_loc_rec.style
3276: IF (g_level_procedure >= g_current_runtime_level ) THEN
3277: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.get_location_column.BEGIN',
3278: 'ZX.TRL.ZX_EXTRACT_PKG.get_location_column(+)');
3279: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.get_location_column',
3280: 'P_CLASSIFICATION = '||p_classification);
3281: END IF;
3274: -- Get the context information from 'Address Location' Descriptive Flexfield
3275: -- Select the context value which matches p_org_loc_rec.style
3276: IF (g_level_procedure >= g_current_runtime_level ) THEN
3277: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.get_location_column.BEGIN',
3278: 'ZX.TRL.ZX_EXTRACT_PKG.get_location_column(+)');
3279: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.get_location_column',
3280: 'P_CLASSIFICATION = '||p_classification);
3281: END IF;
3282:
3275: -- Select the context value which matches p_org_loc_rec.style
3276: IF (g_level_procedure >= g_current_runtime_level ) THEN
3277: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.get_location_column.BEGIN',
3278: 'ZX.TRL.ZX_EXTRACT_PKG.get_location_column(+)');
3279: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.get_location_column',
3280: 'P_CLASSIFICATION = '||p_classification);
3281: END IF;
3282:
3283: fnd_dflex.get_contexts(pr_flexfield, pr_contexts);
3286: FOR i IN 1 .. pr_contexts.ncontexts LOOP
3287: IF(pr_contexts.is_enabled(i)) THEN
3288: IF pr_contexts.context_code(i) = l_style then
3289: IF (g_level_procedure >= g_current_runtime_level ) THEN
3290: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.get_location_column',
3291: 'pr_contexts.context_code= '||pr_contexts.context_code(i)||'-'||
3292: pr_contexts.context_description(i));
3293: END IF;
3294: l_context := i;
3316: END LOOP;
3317:
3318: IF l_column is NULL then
3319: IF (g_level_procedure >= g_current_runtime_level ) THEN
3320: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.get_location_column',
3321: 'No column which matches the value of p_classification: '||p_classification);
3322: END IF;
3323: return NULL;
3324: END IF;
3323: return NULL;
3324: END IF;
3325:
3326: IF (g_level_procedure >= g_current_runtime_level ) THEN
3327: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.get_location_column.END',
3328: 'ZX.TRL.ZX_EXTRACT_PKG.get_location_column(-)');
3329: END IF;
3330:
3331: RETURN l_column;
3324: END IF;
3325:
3326: IF (g_level_procedure >= g_current_runtime_level ) THEN
3327: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.get_location_column.END',
3328: 'ZX.TRL.ZX_EXTRACT_PKG.get_location_column(-)');
3329: END IF;
3330:
3331: RETURN l_column;
3332:
3337: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','get_location_column- '|| g_error_buffer);
3338: FND_MSG_PUB.Add;
3339: IF (g_level_unexpected >= g_current_runtime_level ) THEN
3340: FND_LOG.STRING(g_level_unexpected,
3341: 'ZX.TRL.ZX_EXTRACT_PKG.get_location_column',
3342: g_error_buffer);
3343: END IF;
3344: APPEND_ERRBUF(g_error_buffer);
3345: --P_TRL_GLOBAL_VARIABLES_REC.RETCODE := 2;
3485: PROCEDURE PURGE(p_request_id in number) is
3486: num_rows_deleted number := 0;
3487: BEGIN
3488: IF (g_level_procedure >= g_current_runtime_level ) THEN
3489: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.PURGE.BEGIN',
3490: 'ZX.TRL.ZX_EXTRACT_PKG.BEGIN(+)');
3491: END IF;
3492:
3493: IF (g_level_procedure >= g_current_runtime_level ) THEN
3486: num_rows_deleted number := 0;
3487: BEGIN
3488: IF (g_level_procedure >= g_current_runtime_level ) THEN
3489: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.PURGE.BEGIN',
3490: 'ZX.TRL.ZX_EXTRACT_PKG.BEGIN(+)');
3491: END IF;
3492:
3493: IF (g_level_procedure >= g_current_runtime_level ) THEN
3494: select count(*) into num_rows_deleted
3493: IF (g_level_procedure >= g_current_runtime_level ) THEN
3494: select count(*) into num_rows_deleted
3495: from zx_rep_trx_detail_t
3496: where request_id = p_request_id;
3497: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.get_location_column',
3498: 'Num of Rows in zx_rep_trx_detail_t :'||num_rows_deleted);
3499: select count(*) into num_rows_deleted
3500: from ZX_REP_ACTG_EXT_T
3501: where request_id = p_request_id;
3498: 'Num of Rows in zx_rep_trx_detail_t :'||num_rows_deleted);
3499: select count(*) into num_rows_deleted
3500: from ZX_REP_ACTG_EXT_T
3501: where request_id = p_request_id;
3502: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.get_location_column',
3503: 'Num of Rows in ZX_REP_ACTG_EXT_T :'||num_rows_deleted);
3504: select count(*) into num_rows_deleted
3505: from ZX_REP_TRX_JX_EXT_T
3506: where request_id = p_request_id;
3503: 'Num of Rows in ZX_REP_ACTG_EXT_T :'||num_rows_deleted);
3504: select count(*) into num_rows_deleted
3505: from ZX_REP_TRX_JX_EXT_T
3506: where request_id = p_request_id;
3507: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.get_location_column',
3508: 'Num of Rows in ZX_REP_TRX_JX_EXT_T :'||num_rows_deleted);
3509: select count(*) into num_rows_deleted
3510: from ZX_REP_CONTEXT_T
3511: where request_id = p_request_id;
3508: 'Num of Rows in ZX_REP_TRX_JX_EXT_T :'||num_rows_deleted);
3509: select count(*) into num_rows_deleted
3510: from ZX_REP_CONTEXT_T
3511: where request_id = p_request_id;
3512: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.get_location_column',
3513: 'Num of Rows in ZX_REP_CONTEXT_T :'||num_rows_deleted);
3514: END IF;
3515:
3516: IF PG_DEBUG = 'N' THEN
3518: delete from ZX_REP_TRX_JX_EXT_T where request_id = p_request_id;
3519: delete from ZX_REP_TRX_DETAIL_T where request_id = p_request_id;
3520: delete from ZX_REP_CONTEXT_T where request_id = p_request_id;
3521: IF (g_level_procedure >= g_current_runtime_level ) THEN
3522: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.PURGE.END',
3523: 'In Delete when PG_DEBUG = N ');
3524: END IF;
3525: END IF;
3526:
3524: END IF;
3525: END IF;
3526:
3527: IF (g_level_procedure >= g_current_runtime_level ) THEN
3528: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.PURGE.END',
3529: 'ZX.TRL.ZX_EXTRACT_PKG.PURGE(-)');
3530: END IF;
3531:
3532: /*
3525: END IF;
3526:
3527: IF (g_level_procedure >= g_current_runtime_level ) THEN
3528: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.PURGE.END',
3529: 'ZX.TRL.ZX_EXTRACT_PKG.PURGE(-)');
3530: END IF;
3531:
3532: /*
3533: delete from ar_tax_extr_sub_com_ext com_ext where com_ext.extract_line_id
3693:
3694: BEGIN
3695:
3696: IF (g_level_procedure >= g_current_runtime_level ) THEN
3697: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.get_rep_context_id(+)',
3698: 'Legal Entity ID :'||to_char(p_legal_id));
3699: END IF;
3700:
3701: OPEN legal_rep_context_cur (p_request_id);
3702: --p_legal_id);
3703: FETCH legal_rep_context_cur into l_rep_context_id;
3704:
3705: IF (g_level_procedure >= g_current_runtime_level ) THEN
3706: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.get_rep_context_id(-)',
3707: 'l_rep_context_id :'||to_char(l_rep_context_id));
3708: END IF;
3709:
3710: IF legal_rep_context_cur%ISOPEN then
3936: 'TAXABLE4_ENTERED_CR',
3937: 'TAXABLE4_ENTERED_DR') );
3938:
3939: Begin
3940: -- arp_util_tax.debug('ZX_EXTRACT_PKG.USE_MATRIX_REPORT: Product = '||
3941: -- P_PRODUCT );
3942:
3943: l_use_matrix_rep := 'N';
3944:
3958: return l_use_matrix_rep;
3959: exception
3960: when no_data_found then
3961: IF PG_DEBUG = 'Y' THEN
3962: arp_util_tax.debug('ZX_EXTRACT_PKG.UE_MATRIX_REP : NO_DATA_FOUND ');
3963: END IF;
3964: if use_matrix_flag_csr_ap%isopen then
3965: close use_matrix_flag_csr_ap;
3966: end if;
3969: end if;
3970: return ('N');
3971: when others then
3972: IF PG_DEBUG = 'Y' THEN
3973: arp_util_tax.debug('ZX_EXTRACT_PKG.UE_MATRIX_REP: '||SQLCODE
3974: ||' ; '||SQLERRM);
3975: END IF;
3976: if use_matrix_flag_csr_ap%isopen then
3977: close use_matrix_flag_csr_ap;
4024: BEGIN
4025: x_return_status := FND_API.G_RET_STS_SUCCESS;
4026: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
4027: IF (g_level_procedure >= g_current_runtime_level ) THEN
4028: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.zx_upd_legal_reporting_status.BEGIN',
4029: 'ZX_EXTRACT_PKG:zx_upd_legal_reporting_status(+)');
4030: END IF;
4031:
4032: l_count := p_application_id_tbl.COUNT ;
4025: x_return_status := FND_API.G_RET_STS_SUCCESS;
4026: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
4027: IF (g_level_procedure >= g_current_runtime_level ) THEN
4028: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.zx_upd_legal_reporting_status.BEGIN',
4029: 'ZX_EXTRACT_PKG:zx_upd_legal_reporting_status(+)');
4030: END IF;
4031:
4032: l_count := p_application_id_tbl.COUNT ;
4033:
4067:
4068: END LOOP ;
4069:
4070: IF (g_level_procedure >= g_current_runtime_level ) THEN
4071: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.zx_upd_legal_reporting_status.END',
4072: 'ZX_EXTRACT_PKG:zx_upd_legal_reporting_status(-)');
4073: END IF;
4074:
4075: EXCEPTION
4068: END LOOP ;
4069:
4070: IF (g_level_procedure >= g_current_runtime_level ) THEN
4071: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.zx_upd_legal_reporting_status.END',
4072: 'ZX_EXTRACT_PKG:zx_upd_legal_reporting_status(-)');
4073: END IF;
4074:
4075: EXCEPTION
4076: WHEN OTHERS THEN
4075: EXCEPTION
4076: WHEN OTHERS THEN
4077: IF (g_level_unexpected >= g_current_runtime_level ) THEN
4078: FND_LOG.STRING(g_level_unexpected,
4079: 'ZX.TRL.ZX_EXTRACT_PKG.zx_upd_legal_reporting_status',
4080: sqlerrm);
4081: END IF;
4082: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4083: app_exception.raise_exception;
4422: IF (g_level_procedure >= g_current_runtime_level ) THEN
4423:
4424: l_version_info := NULL;
4425: select substr(text,5,70) into l_version_info from user_source
4426: where name = 'ZX_EXTRACT_PKG'
4427: and text like '%Header:%'
4428: and type = 'PACKAGE BODY'
4429: and line < 10;
4430: FND_LOG.STRING(g_level_procedure, 'ZX_EXTRACT_PKG version info :',
4426: where name = 'ZX_EXTRACT_PKG'
4427: and text like '%Header:%'
4428: and type = 'PACKAGE BODY'
4429: and line < 10;
4430: FND_LOG.STRING(g_level_procedure, 'ZX_EXTRACT_PKG version info :',
4431: l_version_info);
4432: FND_LOG.STRING(g_level_procedure, 'ZX_EXTRACT_PKG version info :',
4433: 'g_current_runtime_level :'||to_char(g_current_runtime_level));
4434: FND_LOG.STRING(g_level_procedure, 'ZX_EXTRACT_PKG version info :',
4428: and type = 'PACKAGE BODY'
4429: and line < 10;
4430: FND_LOG.STRING(g_level_procedure, 'ZX_EXTRACT_PKG version info :',
4431: l_version_info);
4432: FND_LOG.STRING(g_level_procedure, 'ZX_EXTRACT_PKG version info :',
4433: 'g_current_runtime_level :'||to_char(g_current_runtime_level));
4434: FND_LOG.STRING(g_level_procedure, 'ZX_EXTRACT_PKG version info :',
4435: 'g_level_procedure :'||to_char(g_level_procedure));
4436: FND_LOG.STRING(g_level_procedure, 'ZX_EXTRACT_PKG version info :',
4430: FND_LOG.STRING(g_level_procedure, 'ZX_EXTRACT_PKG version info :',
4431: l_version_info);
4432: FND_LOG.STRING(g_level_procedure, 'ZX_EXTRACT_PKG version info :',
4433: 'g_current_runtime_level :'||to_char(g_current_runtime_level));
4434: FND_LOG.STRING(g_level_procedure, 'ZX_EXTRACT_PKG version info :',
4435: 'g_level_procedure :'||to_char(g_level_procedure));
4436: FND_LOG.STRING(g_level_procedure, 'ZX_EXTRACT_PKG version info :',
4437: 'g_level_statement :'||to_char(g_level_statement));
4438: END IF;
4432: FND_LOG.STRING(g_level_procedure, 'ZX_EXTRACT_PKG version info :',
4433: 'g_current_runtime_level :'||to_char(g_current_runtime_level));
4434: FND_LOG.STRING(g_level_procedure, 'ZX_EXTRACT_PKG version info :',
4435: 'g_level_procedure :'||to_char(g_level_procedure));
4436: FND_LOG.STRING(g_level_procedure, 'ZX_EXTRACT_PKG version info :',
4437: 'g_level_statement :'||to_char(g_level_statement));
4438: END IF;
4439:
4440: IF (g_level_procedure >= g_current_runtime_level ) THEN
4494: END IF;
4495:
4496: -- END;
4497:
4498: END ZX_EXTRACT_PKG;