50: g_currency_code VARCHAR2(15);
51: l_accounting_segment VARCHAR2(25);
52:
53: g_current_runtime_level NUMBER ;
54: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
55: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
56: g_level_event CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
57: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
58: g_error_buffer VARCHAR2(100);
51: l_accounting_segment VARCHAR2(25);
52:
53: g_current_runtime_level NUMBER ;
54: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
55: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
56: g_level_event CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
57: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
58: g_error_buffer VARCHAR2(100);
59:
52:
53: g_current_runtime_level NUMBER ;
54: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
55: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
56: g_level_event CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
57: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
58: g_error_buffer VARCHAR2(100);
59:
60: PG_DEBUG VARCHAR2(1) := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
53: g_current_runtime_level NUMBER ;
54: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
55: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
56: g_level_event CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
57: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
58: g_error_buffer VARCHAR2(100);
59:
60: PG_DEBUG VARCHAR2(1) := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
61:
375: P_ESL_EU_ADDL_CODE2 IN VARCHAR2 DEFAULT NULL,
376: P_ESL_SITE_CODE IN VARCHAR2 DEFAULT NULL)
377: IS
378: BEGIN
379: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
380: -- calling the implemented method with the parameters
381: populate_tax_data (
382: p_reporting_level => p_reporting_level,
383: p_reporting_context => p_reporting_context,
649: l_start_time DATE; -- bug 10370545
650: l_end_time DATE; -- bug 10370545
651: l_total_time VARCHAR2(10); -- bug 10370545
652: BEGIN
653: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
654:
655: -- bug 10370545 Starts
656: BEGIN
657: IF (nvl(P_REQUEST_ID,-1) <> -1) THEN
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:
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
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;
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
946: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
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:
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);
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:
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
1553: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
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);
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;
1563: APPEND_ERRBUF(g_error_buffer);
1564: P_TRL_GLOBAL_VARIABLES_REC.RETCODE := 2;
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
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:
1785: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
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',
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);
1795: END IF;
1796: APPEND_ERRBUF(g_error_buffer);
1832: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
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',
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);
1842: END IF;
1843: APPEND_ERRBUF(g_error_buffer);
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
1855: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
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',
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);
1865: END IF;
1866: APPEND_ERRBUF(g_error_buffer);
1902: WHERE request_id = P_TRL_GLOBAL_VARIABLES_REC.REQUEST_ID;
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',
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);
1912: END IF;
1913:
1921: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
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',
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);
1931: END IF;
1932: APPEND_ERRBUF(g_error_buffer);
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
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
2029: -- FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
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:
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
2065: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
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);
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: /*
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
2197: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
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);
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
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:
2307: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
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:
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);
2432: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
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);
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
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',
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',
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
3118: g_last_update_login);
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:
3126:
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:
3141: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
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);
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 ;
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;
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;
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;
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;
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;
3336: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
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);
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
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: /*
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
4022: l_counter_end NUMBER := 0 ;
4023:
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;
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 ;
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
4074:
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;
4416: | |
4417: +=========================================================================*/
4418:
4419: BEGIN
4420: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
4421:
4422: IF (g_level_procedure >= g_current_runtime_level ) THEN
4423:
4424: l_version_info := NULL;
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
4444: and text like '%Header:%'
4445: and type = 'PACKAGE BODY'
4446: and line < 10;
4447:
4448: FND_LOG.STRING(g_level_procedure, 'ZX_AR_EXTRACT_PKG version info :',
4449: l_version_info);
4450: END IF;
4451:
4452: IF (g_level_procedure >= g_current_runtime_level ) THEN
4455: where name = 'ZX_AP_EXTRACT_PKG'
4456: and text like '%Header:%'
4457: and type = 'PACKAGE BODY'
4458: and line < 10;
4459: FND_LOG.STRING(g_level_procedure, 'ZX_AP_EXTRACT_PKG version info :',
4460: l_version_info);
4461: END IF;
4462:
4463: IF (g_level_procedure >= g_current_runtime_level ) THEN
4466: where name = 'ZX_AR_POPULATE_PKG'
4467: and text like '%Header:%'
4468: and type = 'PACKAGE BODY'
4469: and line < 10;
4470: FND_LOG.STRING(g_level_procedure, 'ZX_AR_POPULATE_PKG version info :',
4471: l_version_info);
4472: END IF;
4473:
4474: IF (g_level_procedure >= g_current_runtime_level ) THEN
4477: where name = 'ZX_AP_POPULATE_PKG'
4478: and text like '%Header:%'
4479: and type = 'PACKAGE BODY'
4480: and line < 10;
4481: FND_LOG.STRING(g_level_procedure, 'ZX_AP_POPULATE_PKG version info :',
4482: l_version_info);
4483: END IF;
4484:
4485: IF (g_level_procedure >= g_current_runtime_level ) THEN
4488: where name = 'ZX_GL_EXTRACT_PKG'
4489: and text like '%Header:%'
4490: and type = 'PACKAGE BODY'
4491: and line < 10;
4492: FND_LOG.STRING(g_level_procedure, 'ZX_GL_EXTRACT_PKG version info :',
4493: l_version_info);
4494: END IF;
4495:
4496: -- END;