eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ZX_MIGRATE_AR_TAX_DEF dependencies on ARP_UTIL_TAX

Line 106: arp_util_tax.debug('b: create_tax_classifications');

102: PROCEDURE migrate_ar_tax_code_setup (p_tax_id NUMBER) AS
103: BEGIN
104:
105:
106: arp_util_tax.debug('b: create_tax_classifications');
107: create_tax_classifications (p_tax_id);
108: arp_util_tax.debug('a: create_tax_classifications');
109:
110: arp_util_tax.debug('b: migrate_ar_vat_tax');

Line 108: arp_util_tax.debug('a: create_tax_classifications');

104:
105:
106: arp_util_tax.debug('b: create_tax_classifications');
107: create_tax_classifications (p_tax_id);
108: arp_util_tax.debug('a: create_tax_classifications');
109:
110: arp_util_tax.debug('b: migrate_ar_vat_tax');
111: migrate_ar_vat_tax (p_tax_id);
112: arp_util_tax.debug('a: migrate_ar_vat_tax');

Line 110: arp_util_tax.debug('b: migrate_ar_vat_tax');

106: arp_util_tax.debug('b: create_tax_classifications');
107: create_tax_classifications (p_tax_id);
108: arp_util_tax.debug('a: create_tax_classifications');
109:
110: arp_util_tax.debug('b: migrate_ar_vat_tax');
111: migrate_ar_vat_tax (p_tax_id);
112: arp_util_tax.debug('a: migrate_ar_vat_tax');
113:
114: /* Bug 4710118 : To Ensure that atleast one rate code gets created with default_rate_flag = 'Y' for a particular

Line 112: arp_util_tax.debug('a: migrate_ar_vat_tax');

108: arp_util_tax.debug('a: create_tax_classifications');
109:
110: arp_util_tax.debug('b: migrate_ar_vat_tax');
111: migrate_ar_vat_tax (p_tax_id);
112: arp_util_tax.debug('a: migrate_ar_vat_tax');
113:
114: /* Bug 4710118 : To Ensure that atleast one rate code gets created with default_rate_flag = 'Y' for a particular
115: Combination of regime , tax , status and Content Owner */
116:

Line 143: arp_util_tax.debug('b: create_zx_status');

139: and rates2.rate_type_code <> 'RECOVERY'
140: and rates2.default_rate_flag = 'Y' );
141:
142:
143: arp_util_tax.debug('b: create_zx_status');
144: create_zx_status (p_tax_id);
145: arp_util_tax.debug('a: create_zx_status');
146:
147: arp_util_tax.debug('b: update_criteria_results');

Line 145: arp_util_tax.debug('a: create_zx_status');

141:
142:
143: arp_util_tax.debug('b: create_zx_status');
144: create_zx_status (p_tax_id);
145: arp_util_tax.debug('a: create_zx_status');
146:
147: arp_util_tax.debug('b: update_criteria_results');
148: --update_criteria_results;
149: arp_util_tax.debug('a: update_criteria_results');

Line 147: arp_util_tax.debug('b: update_criteria_results');

143: arp_util_tax.debug('b: create_zx_status');
144: create_zx_status (p_tax_id);
145: arp_util_tax.debug('a: create_zx_status');
146:
147: arp_util_tax.debug('b: update_criteria_results');
148: --update_criteria_results;
149: arp_util_tax.debug('a: update_criteria_results');
150:
151: arp_util_tax.debug('b: create_zx_taxes');

Line 149: arp_util_tax.debug('a: update_criteria_results');

145: arp_util_tax.debug('a: create_zx_status');
146:
147: arp_util_tax.debug('b: update_criteria_results');
148: --update_criteria_results;
149: arp_util_tax.debug('a: update_criteria_results');
150:
151: arp_util_tax.debug('b: create_zx_taxes');
152: create_zx_taxes (p_tax_id);
153: arp_util_tax.debug('a: create_zx_taxes');

Line 151: arp_util_tax.debug('b: create_zx_taxes');

147: arp_util_tax.debug('b: update_criteria_results');
148: --update_criteria_results;
149: arp_util_tax.debug('a: update_criteria_results');
150:
151: arp_util_tax.debug('b: create_zx_taxes');
152: create_zx_taxes (p_tax_id);
153: arp_util_tax.debug('a: create_zx_taxes');
154:
155: arp_util_tax.debug('b: create_zx_regimes');

Line 153: arp_util_tax.debug('a: create_zx_taxes');

149: arp_util_tax.debug('a: update_criteria_results');
150:
151: arp_util_tax.debug('b: create_zx_taxes');
152: create_zx_taxes (p_tax_id);
153: arp_util_tax.debug('a: create_zx_taxes');
154:
155: arp_util_tax.debug('b: create_zx_regimes');
156: --create_zx_regimes (p_tax_id);
157: arp_util_tax.debug('a: create_zx_regimes');

Line 155: arp_util_tax.debug('b: create_zx_regimes');

151: arp_util_tax.debug('b: create_zx_taxes');
152: create_zx_taxes (p_tax_id);
153: arp_util_tax.debug('a: create_zx_taxes');
154:
155: arp_util_tax.debug('b: create_zx_regimes');
156: --create_zx_regimes (p_tax_id);
157: arp_util_tax.debug('a: create_zx_regimes');
158:
159: arp_util_tax.debug('b: migrate_fnd_lookups');

Line 157: arp_util_tax.debug('a: create_zx_regimes');

153: arp_util_tax.debug('a: create_zx_taxes');
154:
155: arp_util_tax.debug('b: create_zx_regimes');
156: --create_zx_regimes (p_tax_id);
157: arp_util_tax.debug('a: create_zx_regimes');
158:
159: arp_util_tax.debug('b: migrate_fnd_lookups');
160: migrate_fnd_lookups;
161: arp_util_tax.debug('a: migrate_fnd_lookups');

Line 159: arp_util_tax.debug('b: migrate_fnd_lookups');

155: arp_util_tax.debug('b: create_zx_regimes');
156: --create_zx_regimes (p_tax_id);
157: arp_util_tax.debug('a: create_zx_regimes');
158:
159: arp_util_tax.debug('b: migrate_fnd_lookups');
160: migrate_fnd_lookups;
161: arp_util_tax.debug('a: migrate_fnd_lookups');
162:
163: arp_util_tax.debug('b: migrate_profile');

Line 161: arp_util_tax.debug('a: migrate_fnd_lookups');

157: arp_util_tax.debug('a: create_zx_regimes');
158:
159: arp_util_tax.debug('b: migrate_fnd_lookups');
160: migrate_fnd_lookups;
161: arp_util_tax.debug('a: migrate_fnd_lookups');
162:
163: arp_util_tax.debug('b: migrate_profile');
164: migrate_profile;
165: arp_util_tax.debug('a: migrate_profile');

Line 163: arp_util_tax.debug('b: migrate_profile');

159: arp_util_tax.debug('b: migrate_fnd_lookups');
160: migrate_fnd_lookups;
161: arp_util_tax.debug('a: migrate_fnd_lookups');
162:
163: arp_util_tax.debug('b: migrate_profile');
164: migrate_profile;
165: arp_util_tax.debug('a: migrate_profile');
166:
167: --Bug # 4215331

Line 165: arp_util_tax.debug('a: migrate_profile');

161: arp_util_tax.debug('a: migrate_fnd_lookups');
162:
163: arp_util_tax.debug('b: migrate_profile');
164: migrate_profile;
165: arp_util_tax.debug('a: migrate_profile');
166:
167: --Bug # 4215331
168: IF p_tax_id IS NULL THEN
169: -- backward_updation should not be called from pre-migration

Line 171: arp_util_tax.debug('b: backward_updation');

167: --Bug # 4215331
168: IF p_tax_id IS NULL THEN
169: -- backward_updation should not be called from pre-migration
170: -- synch logic. For details, refer to procedure body.
171: arp_util_tax.debug('b: backward_updation');
172: backward_updation;
173: arp_util_tax.debug('a: backward_updation');
174: END IF;
175:

Line 173: arp_util_tax.debug('a: backward_updation');

169: -- backward_updation should not be called from pre-migration
170: -- synch logic. For details, refer to procedure body.
171: arp_util_tax.debug('b: backward_updation');
172: backward_updation;
173: arp_util_tax.debug('a: backward_updation');
174: END IF;
175:
176: arp_util_tax.debug('b: migrate_loc_tax_code');
177: migrate_loc_tax_code (p_tax_id);

Line 176: arp_util_tax.debug('b: migrate_loc_tax_code');

172: backward_updation;
173: arp_util_tax.debug('a: backward_updation');
174: END IF;
175:
176: arp_util_tax.debug('b: migrate_loc_tax_code');
177: migrate_loc_tax_code (p_tax_id);
178: arp_util_tax.debug('a: migrate_loc_tax_code');
179:
180: arp_util_tax.debug('b: migrate_vnd_tax_code');

Line 178: arp_util_tax.debug('a: migrate_loc_tax_code');

174: END IF;
175:
176: arp_util_tax.debug('b: migrate_loc_tax_code');
177: migrate_loc_tax_code (p_tax_id);
178: arp_util_tax.debug('a: migrate_loc_tax_code');
179:
180: arp_util_tax.debug('b: migrate_vnd_tax_code');
181: migrate_vnd_tax_code (p_tax_id);
182: arp_util_tax.debug('a: migrate_vnd_tax_code');

Line 180: arp_util_tax.debug('b: migrate_vnd_tax_code');

176: arp_util_tax.debug('b: migrate_loc_tax_code');
177: migrate_loc_tax_code (p_tax_id);
178: arp_util_tax.debug('a: migrate_loc_tax_code');
179:
180: arp_util_tax.debug('b: migrate_vnd_tax_code');
181: migrate_vnd_tax_code (p_tax_id);
182: arp_util_tax.debug('a: migrate_vnd_tax_code');
183:
184: arp_util_tax.debug('b: stamp_exe_exc_flag');

Line 182: arp_util_tax.debug('a: migrate_vnd_tax_code');

178: arp_util_tax.debug('a: migrate_loc_tax_code');
179:
180: arp_util_tax.debug('b: migrate_vnd_tax_code');
181: migrate_vnd_tax_code (p_tax_id);
182: arp_util_tax.debug('a: migrate_vnd_tax_code');
183:
184: arp_util_tax.debug('b: stamp_exe_exc_flag');
185: stm_exmpt_excpt_flg;
186: arp_util_tax.debug('b: stamp_exe_exc_flag');

Line 184: arp_util_tax.debug('b: stamp_exe_exc_flag');

180: arp_util_tax.debug('b: migrate_vnd_tax_code');
181: migrate_vnd_tax_code (p_tax_id);
182: arp_util_tax.debug('a: migrate_vnd_tax_code');
183:
184: arp_util_tax.debug('b: stamp_exe_exc_flag');
185: stm_exmpt_excpt_flg;
186: arp_util_tax.debug('b: stamp_exe_exc_flag');
187:
188: arp_util_tax.debug('b: populate_mls_tables');

Line 186: arp_util_tax.debug('b: stamp_exe_exc_flag');

182: arp_util_tax.debug('a: migrate_vnd_tax_code');
183:
184: arp_util_tax.debug('b: stamp_exe_exc_flag');
185: stm_exmpt_excpt_flg;
186: arp_util_tax.debug('b: stamp_exe_exc_flag');
187:
188: arp_util_tax.debug('b: populate_mls_tables');
189: populate_mls_tables;
190: arp_util_tax.debug('a: populate_mls_tables');

Line 188: arp_util_tax.debug('b: populate_mls_tables');

184: arp_util_tax.debug('b: stamp_exe_exc_flag');
185: stm_exmpt_excpt_flg;
186: arp_util_tax.debug('b: stamp_exe_exc_flag');
187:
188: arp_util_tax.debug('b: populate_mls_tables');
189: populate_mls_tables;
190: arp_util_tax.debug('a: populate_mls_tables');
191:
192:

Line 190: arp_util_tax.debug('a: populate_mls_tables');

186: arp_util_tax.debug('b: stamp_exe_exc_flag');
187:
188: arp_util_tax.debug('b: populate_mls_tables');
189: populate_mls_tables;
190: arp_util_tax.debug('a: populate_mls_tables');
191:
192:
193: EXCEPTION
194: WHEN OTHERS THEN

Line 195: arp_util_tax.debug('E: migrate_ar_tax_code_setup : ' || sqlcode || ' : ' || sqlerrm);

191:
192:
193: EXCEPTION
194: WHEN OTHERS THEN
195: arp_util_tax.debug('E: migrate_ar_tax_code_setup : ' || sqlcode || ' : ' || sqlerrm);
196:
197: END;
198:
199: /*===========================================================================+

Line 1090: arp_util_tax.debug('***');

1086: denorm_tbl(i) := loc_str_rec;
1087:
1088: -- ****** DEBUG ******
1089: FOR k in 1..denorm_tbl.count LOOP
1090: arp_util_tax.debug('***');
1091: arp_util_tax.debug('country_code: ' || denorm_tbl(k).country_code);
1092: arp_util_tax.debug('id_flex_num : ' || denorm_tbl(k).id_flex_num);
1093: arp_util_tax.debug('seg_att_type1: ' || denorm_tbl(k).seg_att_type1);
1094: arp_util_tax.debug('seg_att_type2: ' || denorm_tbl(k).seg_att_type2);

Line 1091: arp_util_tax.debug('country_code: ' || denorm_tbl(k).country_code);

1087:
1088: -- ****** DEBUG ******
1089: FOR k in 1..denorm_tbl.count LOOP
1090: arp_util_tax.debug('***');
1091: arp_util_tax.debug('country_code: ' || denorm_tbl(k).country_code);
1092: arp_util_tax.debug('id_flex_num : ' || denorm_tbl(k).id_flex_num);
1093: arp_util_tax.debug('seg_att_type1: ' || denorm_tbl(k).seg_att_type1);
1094: arp_util_tax.debug('seg_att_type2: ' || denorm_tbl(k).seg_att_type2);
1095: arp_util_tax.debug('seg_att_type3: ' || denorm_tbl(k).seg_att_type3);

Line 1092: arp_util_tax.debug('id_flex_num : ' || denorm_tbl(k).id_flex_num);

1088: -- ****** DEBUG ******
1089: FOR k in 1..denorm_tbl.count LOOP
1090: arp_util_tax.debug('***');
1091: arp_util_tax.debug('country_code: ' || denorm_tbl(k).country_code);
1092: arp_util_tax.debug('id_flex_num : ' || denorm_tbl(k).id_flex_num);
1093: arp_util_tax.debug('seg_att_type1: ' || denorm_tbl(k).seg_att_type1);
1094: arp_util_tax.debug('seg_att_type2: ' || denorm_tbl(k).seg_att_type2);
1095: arp_util_tax.debug('seg_att_type3: ' || denorm_tbl(k).seg_att_type3);
1096: arp_util_tax.debug('seg_att_type4: ' || denorm_tbl(k).seg_att_type4);

Line 1093: arp_util_tax.debug('seg_att_type1: ' || denorm_tbl(k).seg_att_type1);

1089: FOR k in 1..denorm_tbl.count LOOP
1090: arp_util_tax.debug('***');
1091: arp_util_tax.debug('country_code: ' || denorm_tbl(k).country_code);
1092: arp_util_tax.debug('id_flex_num : ' || denorm_tbl(k).id_flex_num);
1093: arp_util_tax.debug('seg_att_type1: ' || denorm_tbl(k).seg_att_type1);
1094: arp_util_tax.debug('seg_att_type2: ' || denorm_tbl(k).seg_att_type2);
1095: arp_util_tax.debug('seg_att_type3: ' || denorm_tbl(k).seg_att_type3);
1096: arp_util_tax.debug('seg_att_type4: ' || denorm_tbl(k).seg_att_type4);
1097: arp_util_tax.debug('seg_att_type5: ' || denorm_tbl(k).seg_att_type5);

Line 1094: arp_util_tax.debug('seg_att_type2: ' || denorm_tbl(k).seg_att_type2);

1090: arp_util_tax.debug('***');
1091: arp_util_tax.debug('country_code: ' || denorm_tbl(k).country_code);
1092: arp_util_tax.debug('id_flex_num : ' || denorm_tbl(k).id_flex_num);
1093: arp_util_tax.debug('seg_att_type1: ' || denorm_tbl(k).seg_att_type1);
1094: arp_util_tax.debug('seg_att_type2: ' || denorm_tbl(k).seg_att_type2);
1095: arp_util_tax.debug('seg_att_type3: ' || denorm_tbl(k).seg_att_type3);
1096: arp_util_tax.debug('seg_att_type4: ' || denorm_tbl(k).seg_att_type4);
1097: arp_util_tax.debug('seg_att_type5: ' || denorm_tbl(k).seg_att_type5);
1098: arp_util_tax.debug('seg_att_type6: ' || denorm_tbl(k).seg_att_type6);

Line 1095: arp_util_tax.debug('seg_att_type3: ' || denorm_tbl(k).seg_att_type3);

1091: arp_util_tax.debug('country_code: ' || denorm_tbl(k).country_code);
1092: arp_util_tax.debug('id_flex_num : ' || denorm_tbl(k).id_flex_num);
1093: arp_util_tax.debug('seg_att_type1: ' || denorm_tbl(k).seg_att_type1);
1094: arp_util_tax.debug('seg_att_type2: ' || denorm_tbl(k).seg_att_type2);
1095: arp_util_tax.debug('seg_att_type3: ' || denorm_tbl(k).seg_att_type3);
1096: arp_util_tax.debug('seg_att_type4: ' || denorm_tbl(k).seg_att_type4);
1097: arp_util_tax.debug('seg_att_type5: ' || denorm_tbl(k).seg_att_type5);
1098: arp_util_tax.debug('seg_att_type6: ' || denorm_tbl(k).seg_att_type6);
1099: arp_util_tax.debug('seg_att_type7: ' || denorm_tbl(k).seg_att_type7);

Line 1096: arp_util_tax.debug('seg_att_type4: ' || denorm_tbl(k).seg_att_type4);

1092: arp_util_tax.debug('id_flex_num : ' || denorm_tbl(k).id_flex_num);
1093: arp_util_tax.debug('seg_att_type1: ' || denorm_tbl(k).seg_att_type1);
1094: arp_util_tax.debug('seg_att_type2: ' || denorm_tbl(k).seg_att_type2);
1095: arp_util_tax.debug('seg_att_type3: ' || denorm_tbl(k).seg_att_type3);
1096: arp_util_tax.debug('seg_att_type4: ' || denorm_tbl(k).seg_att_type4);
1097: arp_util_tax.debug('seg_att_type5: ' || denorm_tbl(k).seg_att_type5);
1098: arp_util_tax.debug('seg_att_type6: ' || denorm_tbl(k).seg_att_type6);
1099: arp_util_tax.debug('seg_att_type7: ' || denorm_tbl(k).seg_att_type7);
1100: arp_util_tax.debug('seg_att_type8: ' || denorm_tbl(k).seg_att_type8);

Line 1097: arp_util_tax.debug('seg_att_type5: ' || denorm_tbl(k).seg_att_type5);

1093: arp_util_tax.debug('seg_att_type1: ' || denorm_tbl(k).seg_att_type1);
1094: arp_util_tax.debug('seg_att_type2: ' || denorm_tbl(k).seg_att_type2);
1095: arp_util_tax.debug('seg_att_type3: ' || denorm_tbl(k).seg_att_type3);
1096: arp_util_tax.debug('seg_att_type4: ' || denorm_tbl(k).seg_att_type4);
1097: arp_util_tax.debug('seg_att_type5: ' || denorm_tbl(k).seg_att_type5);
1098: arp_util_tax.debug('seg_att_type6: ' || denorm_tbl(k).seg_att_type6);
1099: arp_util_tax.debug('seg_att_type7: ' || denorm_tbl(k).seg_att_type7);
1100: arp_util_tax.debug('seg_att_type8: ' || denorm_tbl(k).seg_att_type8);
1101: arp_util_tax.debug('seg_att_type9: ' || denorm_tbl(k).seg_att_type9);

Line 1098: arp_util_tax.debug('seg_att_type6: ' || denorm_tbl(k).seg_att_type6);

1094: arp_util_tax.debug('seg_att_type2: ' || denorm_tbl(k).seg_att_type2);
1095: arp_util_tax.debug('seg_att_type3: ' || denorm_tbl(k).seg_att_type3);
1096: arp_util_tax.debug('seg_att_type4: ' || denorm_tbl(k).seg_att_type4);
1097: arp_util_tax.debug('seg_att_type5: ' || denorm_tbl(k).seg_att_type5);
1098: arp_util_tax.debug('seg_att_type6: ' || denorm_tbl(k).seg_att_type6);
1099: arp_util_tax.debug('seg_att_type7: ' || denorm_tbl(k).seg_att_type7);
1100: arp_util_tax.debug('seg_att_type8: ' || denorm_tbl(k).seg_att_type8);
1101: arp_util_tax.debug('seg_att_type9: ' || denorm_tbl(k).seg_att_type9);
1102: arp_util_tax.debug('seg_att_type10: ' || denorm_tbl(k).seg_att_type10);

Line 1099: arp_util_tax.debug('seg_att_type7: ' || denorm_tbl(k).seg_att_type7);

1095: arp_util_tax.debug('seg_att_type3: ' || denorm_tbl(k).seg_att_type3);
1096: arp_util_tax.debug('seg_att_type4: ' || denorm_tbl(k).seg_att_type4);
1097: arp_util_tax.debug('seg_att_type5: ' || denorm_tbl(k).seg_att_type5);
1098: arp_util_tax.debug('seg_att_type6: ' || denorm_tbl(k).seg_att_type6);
1099: arp_util_tax.debug('seg_att_type7: ' || denorm_tbl(k).seg_att_type7);
1100: arp_util_tax.debug('seg_att_type8: ' || denorm_tbl(k).seg_att_type8);
1101: arp_util_tax.debug('seg_att_type9: ' || denorm_tbl(k).seg_att_type9);
1102: arp_util_tax.debug('seg_att_type10: ' || denorm_tbl(k).seg_att_type10);
1103: arp_util_tax.debug('tax_curr_code : ' || denorm_tbl(k).tax_currency_code);

Line 1100: arp_util_tax.debug('seg_att_type8: ' || denorm_tbl(k).seg_att_type8);

1096: arp_util_tax.debug('seg_att_type4: ' || denorm_tbl(k).seg_att_type4);
1097: arp_util_tax.debug('seg_att_type5: ' || denorm_tbl(k).seg_att_type5);
1098: arp_util_tax.debug('seg_att_type6: ' || denorm_tbl(k).seg_att_type6);
1099: arp_util_tax.debug('seg_att_type7: ' || denorm_tbl(k).seg_att_type7);
1100: arp_util_tax.debug('seg_att_type8: ' || denorm_tbl(k).seg_att_type8);
1101: arp_util_tax.debug('seg_att_type9: ' || denorm_tbl(k).seg_att_type9);
1102: arp_util_tax.debug('seg_att_type10: ' || denorm_tbl(k).seg_att_type10);
1103: arp_util_tax.debug('tax_curr_code : ' || denorm_tbl(k).tax_currency_code);
1104: arp_util_tax.debug('tax_precision : ' || denorm_tbl(k).tax_precision);

Line 1101: arp_util_tax.debug('seg_att_type9: ' || denorm_tbl(k).seg_att_type9);

1097: arp_util_tax.debug('seg_att_type5: ' || denorm_tbl(k).seg_att_type5);
1098: arp_util_tax.debug('seg_att_type6: ' || denorm_tbl(k).seg_att_type6);
1099: arp_util_tax.debug('seg_att_type7: ' || denorm_tbl(k).seg_att_type7);
1100: arp_util_tax.debug('seg_att_type8: ' || denorm_tbl(k).seg_att_type8);
1101: arp_util_tax.debug('seg_att_type9: ' || denorm_tbl(k).seg_att_type9);
1102: arp_util_tax.debug('seg_att_type10: ' || denorm_tbl(k).seg_att_type10);
1103: arp_util_tax.debug('tax_curr_code : ' || denorm_tbl(k).tax_currency_code);
1104: arp_util_tax.debug('tax_precision : ' || denorm_tbl(k).tax_precision);
1105: arp_util_tax.debug('tax_man : ' || denorm_tbl(k).tax_mau);

Line 1102: arp_util_tax.debug('seg_att_type10: ' || denorm_tbl(k).seg_att_type10);

1098: arp_util_tax.debug('seg_att_type6: ' || denorm_tbl(k).seg_att_type6);
1099: arp_util_tax.debug('seg_att_type7: ' || denorm_tbl(k).seg_att_type7);
1100: arp_util_tax.debug('seg_att_type8: ' || denorm_tbl(k).seg_att_type8);
1101: arp_util_tax.debug('seg_att_type9: ' || denorm_tbl(k).seg_att_type9);
1102: arp_util_tax.debug('seg_att_type10: ' || denorm_tbl(k).seg_att_type10);
1103: arp_util_tax.debug('tax_curr_code : ' || denorm_tbl(k).tax_currency_code);
1104: arp_util_tax.debug('tax_precision : ' || denorm_tbl(k).tax_precision);
1105: arp_util_tax.debug('tax_man : ' || denorm_tbl(k).tax_mau);
1106: arp_util_tax.debug('rounding_rule : ' || denorm_tbl(k).rounding_rule_code);

Line 1103: arp_util_tax.debug('tax_curr_code : ' || denorm_tbl(k).tax_currency_code);

1099: arp_util_tax.debug('seg_att_type7: ' || denorm_tbl(k).seg_att_type7);
1100: arp_util_tax.debug('seg_att_type8: ' || denorm_tbl(k).seg_att_type8);
1101: arp_util_tax.debug('seg_att_type9: ' || denorm_tbl(k).seg_att_type9);
1102: arp_util_tax.debug('seg_att_type10: ' || denorm_tbl(k).seg_att_type10);
1103: arp_util_tax.debug('tax_curr_code : ' || denorm_tbl(k).tax_currency_code);
1104: arp_util_tax.debug('tax_precision : ' || denorm_tbl(k).tax_precision);
1105: arp_util_tax.debug('tax_man : ' || denorm_tbl(k).tax_mau);
1106: arp_util_tax.debug('rounding_rule : ' || denorm_tbl(k).rounding_rule_code);
1107: arp_util_tax.debug('allow_rounding_over : ' || denorm_tbl(k).allow_rounding_override);

Line 1104: arp_util_tax.debug('tax_precision : ' || denorm_tbl(k).tax_precision);

1100: arp_util_tax.debug('seg_att_type8: ' || denorm_tbl(k).seg_att_type8);
1101: arp_util_tax.debug('seg_att_type9: ' || denorm_tbl(k).seg_att_type9);
1102: arp_util_tax.debug('seg_att_type10: ' || denorm_tbl(k).seg_att_type10);
1103: arp_util_tax.debug('tax_curr_code : ' || denorm_tbl(k).tax_currency_code);
1104: arp_util_tax.debug('tax_precision : ' || denorm_tbl(k).tax_precision);
1105: arp_util_tax.debug('tax_man : ' || denorm_tbl(k).tax_mau);
1106: arp_util_tax.debug('rounding_rule : ' || denorm_tbl(k).rounding_rule_code);
1107: arp_util_tax.debug('allow_rounding_over : ' || denorm_tbl(k).allow_rounding_override);
1108: arp_util_tax.debug('org_id : ' || denorm_tbl(k).org_id);

Line 1105: arp_util_tax.debug('tax_man : ' || denorm_tbl(k).tax_mau);

1101: arp_util_tax.debug('seg_att_type9: ' || denorm_tbl(k).seg_att_type9);
1102: arp_util_tax.debug('seg_att_type10: ' || denorm_tbl(k).seg_att_type10);
1103: arp_util_tax.debug('tax_curr_code : ' || denorm_tbl(k).tax_currency_code);
1104: arp_util_tax.debug('tax_precision : ' || denorm_tbl(k).tax_precision);
1105: arp_util_tax.debug('tax_man : ' || denorm_tbl(k).tax_mau);
1106: arp_util_tax.debug('rounding_rule : ' || denorm_tbl(k).rounding_rule_code);
1107: arp_util_tax.debug('allow_rounding_over : ' || denorm_tbl(k).allow_rounding_override);
1108: arp_util_tax.debug('org_id : ' || denorm_tbl(k).org_id);
1109: arp_util_tax.debug('tax_acct_id : ' || denorm_tbl(k).tax_account_id);

Line 1106: arp_util_tax.debug('rounding_rule : ' || denorm_tbl(k).rounding_rule_code);

1102: arp_util_tax.debug('seg_att_type10: ' || denorm_tbl(k).seg_att_type10);
1103: arp_util_tax.debug('tax_curr_code : ' || denorm_tbl(k).tax_currency_code);
1104: arp_util_tax.debug('tax_precision : ' || denorm_tbl(k).tax_precision);
1105: arp_util_tax.debug('tax_man : ' || denorm_tbl(k).tax_mau);
1106: arp_util_tax.debug('rounding_rule : ' || denorm_tbl(k).rounding_rule_code);
1107: arp_util_tax.debug('allow_rounding_over : ' || denorm_tbl(k).allow_rounding_override);
1108: arp_util_tax.debug('org_id : ' || denorm_tbl(k).org_id);
1109: arp_util_tax.debug('tax_acct_id : ' || denorm_tbl(k).tax_account_id);
1110: arp_util_tax.debug('seg_name1 : ' || denorm_tbl(k).seg_name1);

Line 1107: arp_util_tax.debug('allow_rounding_over : ' || denorm_tbl(k).allow_rounding_override);

1103: arp_util_tax.debug('tax_curr_code : ' || denorm_tbl(k).tax_currency_code);
1104: arp_util_tax.debug('tax_precision : ' || denorm_tbl(k).tax_precision);
1105: arp_util_tax.debug('tax_man : ' || denorm_tbl(k).tax_mau);
1106: arp_util_tax.debug('rounding_rule : ' || denorm_tbl(k).rounding_rule_code);
1107: arp_util_tax.debug('allow_rounding_over : ' || denorm_tbl(k).allow_rounding_override);
1108: arp_util_tax.debug('org_id : ' || denorm_tbl(k).org_id);
1109: arp_util_tax.debug('tax_acct_id : ' || denorm_tbl(k).tax_account_id);
1110: arp_util_tax.debug('seg_name1 : ' || denorm_tbl(k).seg_name1);
1111: arp_util_tax.debug('seg_name2 : ' || denorm_tbl(k).seg_name2);

Line 1108: arp_util_tax.debug('org_id : ' || denorm_tbl(k).org_id);

1104: arp_util_tax.debug('tax_precision : ' || denorm_tbl(k).tax_precision);
1105: arp_util_tax.debug('tax_man : ' || denorm_tbl(k).tax_mau);
1106: arp_util_tax.debug('rounding_rule : ' || denorm_tbl(k).rounding_rule_code);
1107: arp_util_tax.debug('allow_rounding_over : ' || denorm_tbl(k).allow_rounding_override);
1108: arp_util_tax.debug('org_id : ' || denorm_tbl(k).org_id);
1109: arp_util_tax.debug('tax_acct_id : ' || denorm_tbl(k).tax_account_id);
1110: arp_util_tax.debug('seg_name1 : ' || denorm_tbl(k).seg_name1);
1111: arp_util_tax.debug('seg_name2 : ' || denorm_tbl(k).seg_name2);
1112: arp_util_tax.debug('seg_name3 : ' || denorm_tbl(k).seg_name3);

Line 1109: arp_util_tax.debug('tax_acct_id : ' || denorm_tbl(k).tax_account_id);

1105: arp_util_tax.debug('tax_man : ' || denorm_tbl(k).tax_mau);
1106: arp_util_tax.debug('rounding_rule : ' || denorm_tbl(k).rounding_rule_code);
1107: arp_util_tax.debug('allow_rounding_over : ' || denorm_tbl(k).allow_rounding_override);
1108: arp_util_tax.debug('org_id : ' || denorm_tbl(k).org_id);
1109: arp_util_tax.debug('tax_acct_id : ' || denorm_tbl(k).tax_account_id);
1110: arp_util_tax.debug('seg_name1 : ' || denorm_tbl(k).seg_name1);
1111: arp_util_tax.debug('seg_name2 : ' || denorm_tbl(k).seg_name2);
1112: arp_util_tax.debug('seg_name3 : ' || denorm_tbl(k).seg_name3);
1113: arp_util_tax.debug('seg_name4 : ' || denorm_tbl(k).seg_name4);

Line 1110: arp_util_tax.debug('seg_name1 : ' || denorm_tbl(k).seg_name1);

1106: arp_util_tax.debug('rounding_rule : ' || denorm_tbl(k).rounding_rule_code);
1107: arp_util_tax.debug('allow_rounding_over : ' || denorm_tbl(k).allow_rounding_override);
1108: arp_util_tax.debug('org_id : ' || denorm_tbl(k).org_id);
1109: arp_util_tax.debug('tax_acct_id : ' || denorm_tbl(k).tax_account_id);
1110: arp_util_tax.debug('seg_name1 : ' || denorm_tbl(k).seg_name1);
1111: arp_util_tax.debug('seg_name2 : ' || denorm_tbl(k).seg_name2);
1112: arp_util_tax.debug('seg_name3 : ' || denorm_tbl(k).seg_name3);
1113: arp_util_tax.debug('seg_name4 : ' || denorm_tbl(k).seg_name4);
1114: arp_util_tax.debug('seg_name5 : ' || denorm_tbl(k).seg_name5);

Line 1111: arp_util_tax.debug('seg_name2 : ' || denorm_tbl(k).seg_name2);

1107: arp_util_tax.debug('allow_rounding_over : ' || denorm_tbl(k).allow_rounding_override);
1108: arp_util_tax.debug('org_id : ' || denorm_tbl(k).org_id);
1109: arp_util_tax.debug('tax_acct_id : ' || denorm_tbl(k).tax_account_id);
1110: arp_util_tax.debug('seg_name1 : ' || denorm_tbl(k).seg_name1);
1111: arp_util_tax.debug('seg_name2 : ' || denorm_tbl(k).seg_name2);
1112: arp_util_tax.debug('seg_name3 : ' || denorm_tbl(k).seg_name3);
1113: arp_util_tax.debug('seg_name4 : ' || denorm_tbl(k).seg_name4);
1114: arp_util_tax.debug('seg_name5 : ' || denorm_tbl(k).seg_name5);
1115: arp_util_tax.debug('seg_name6 : ' || denorm_tbl(k).seg_name6);

Line 1112: arp_util_tax.debug('seg_name3 : ' || denorm_tbl(k).seg_name3);

1108: arp_util_tax.debug('org_id : ' || denorm_tbl(k).org_id);
1109: arp_util_tax.debug('tax_acct_id : ' || denorm_tbl(k).tax_account_id);
1110: arp_util_tax.debug('seg_name1 : ' || denorm_tbl(k).seg_name1);
1111: arp_util_tax.debug('seg_name2 : ' || denorm_tbl(k).seg_name2);
1112: arp_util_tax.debug('seg_name3 : ' || denorm_tbl(k).seg_name3);
1113: arp_util_tax.debug('seg_name4 : ' || denorm_tbl(k).seg_name4);
1114: arp_util_tax.debug('seg_name5 : ' || denorm_tbl(k).seg_name5);
1115: arp_util_tax.debug('seg_name6 : ' || denorm_tbl(k).seg_name6);
1116: arp_util_tax.debug('seg_name7 : ' || denorm_tbl(k).seg_name7);

Line 1113: arp_util_tax.debug('seg_name4 : ' || denorm_tbl(k).seg_name4);

1109: arp_util_tax.debug('tax_acct_id : ' || denorm_tbl(k).tax_account_id);
1110: arp_util_tax.debug('seg_name1 : ' || denorm_tbl(k).seg_name1);
1111: arp_util_tax.debug('seg_name2 : ' || denorm_tbl(k).seg_name2);
1112: arp_util_tax.debug('seg_name3 : ' || denorm_tbl(k).seg_name3);
1113: arp_util_tax.debug('seg_name4 : ' || denorm_tbl(k).seg_name4);
1114: arp_util_tax.debug('seg_name5 : ' || denorm_tbl(k).seg_name5);
1115: arp_util_tax.debug('seg_name6 : ' || denorm_tbl(k).seg_name6);
1116: arp_util_tax.debug('seg_name7 : ' || denorm_tbl(k).seg_name7);
1117: arp_util_tax.debug('seg_name8 : ' || denorm_tbl(k).seg_name8);

Line 1114: arp_util_tax.debug('seg_name5 : ' || denorm_tbl(k).seg_name5);

1110: arp_util_tax.debug('seg_name1 : ' || denorm_tbl(k).seg_name1);
1111: arp_util_tax.debug('seg_name2 : ' || denorm_tbl(k).seg_name2);
1112: arp_util_tax.debug('seg_name3 : ' || denorm_tbl(k).seg_name3);
1113: arp_util_tax.debug('seg_name4 : ' || denorm_tbl(k).seg_name4);
1114: arp_util_tax.debug('seg_name5 : ' || denorm_tbl(k).seg_name5);
1115: arp_util_tax.debug('seg_name6 : ' || denorm_tbl(k).seg_name6);
1116: arp_util_tax.debug('seg_name7 : ' || denorm_tbl(k).seg_name7);
1117: arp_util_tax.debug('seg_name8 : ' || denorm_tbl(k).seg_name8);
1118: arp_util_tax.debug('seg_name9 : ' || denorm_tbl(k).seg_name9);

Line 1115: arp_util_tax.debug('seg_name6 : ' || denorm_tbl(k).seg_name6);

1111: arp_util_tax.debug('seg_name2 : ' || denorm_tbl(k).seg_name2);
1112: arp_util_tax.debug('seg_name3 : ' || denorm_tbl(k).seg_name3);
1113: arp_util_tax.debug('seg_name4 : ' || denorm_tbl(k).seg_name4);
1114: arp_util_tax.debug('seg_name5 : ' || denorm_tbl(k).seg_name5);
1115: arp_util_tax.debug('seg_name6 : ' || denorm_tbl(k).seg_name6);
1116: arp_util_tax.debug('seg_name7 : ' || denorm_tbl(k).seg_name7);
1117: arp_util_tax.debug('seg_name8 : ' || denorm_tbl(k).seg_name8);
1118: arp_util_tax.debug('seg_name9 : ' || denorm_tbl(k).seg_name9);
1119: arp_util_tax.debug('seg_name10 : ' || denorm_tbl(k).seg_name10);

Line 1116: arp_util_tax.debug('seg_name7 : ' || denorm_tbl(k).seg_name7);

1112: arp_util_tax.debug('seg_name3 : ' || denorm_tbl(k).seg_name3);
1113: arp_util_tax.debug('seg_name4 : ' || denorm_tbl(k).seg_name4);
1114: arp_util_tax.debug('seg_name5 : ' || denorm_tbl(k).seg_name5);
1115: arp_util_tax.debug('seg_name6 : ' || denorm_tbl(k).seg_name6);
1116: arp_util_tax.debug('seg_name7 : ' || denorm_tbl(k).seg_name7);
1117: arp_util_tax.debug('seg_name8 : ' || denorm_tbl(k).seg_name8);
1118: arp_util_tax.debug('seg_name9 : ' || denorm_tbl(k).seg_name9);
1119: arp_util_tax.debug('seg_name10 : ' || denorm_tbl(k).seg_name10);
1120: arp_util_tax.debug('appl_col_name1 : ' || denorm_tbl(k).appl_col_name1);

Line 1117: arp_util_tax.debug('seg_name8 : ' || denorm_tbl(k).seg_name8);

1113: arp_util_tax.debug('seg_name4 : ' || denorm_tbl(k).seg_name4);
1114: arp_util_tax.debug('seg_name5 : ' || denorm_tbl(k).seg_name5);
1115: arp_util_tax.debug('seg_name6 : ' || denorm_tbl(k).seg_name6);
1116: arp_util_tax.debug('seg_name7 : ' || denorm_tbl(k).seg_name7);
1117: arp_util_tax.debug('seg_name8 : ' || denorm_tbl(k).seg_name8);
1118: arp_util_tax.debug('seg_name9 : ' || denorm_tbl(k).seg_name9);
1119: arp_util_tax.debug('seg_name10 : ' || denorm_tbl(k).seg_name10);
1120: arp_util_tax.debug('appl_col_name1 : ' || denorm_tbl(k).appl_col_name1);
1121: arp_util_tax.debug('appl_col_name2 : ' || denorm_tbl(k).appl_col_name2);

Line 1118: arp_util_tax.debug('seg_name9 : ' || denorm_tbl(k).seg_name9);

1114: arp_util_tax.debug('seg_name5 : ' || denorm_tbl(k).seg_name5);
1115: arp_util_tax.debug('seg_name6 : ' || denorm_tbl(k).seg_name6);
1116: arp_util_tax.debug('seg_name7 : ' || denorm_tbl(k).seg_name7);
1117: arp_util_tax.debug('seg_name8 : ' || denorm_tbl(k).seg_name8);
1118: arp_util_tax.debug('seg_name9 : ' || denorm_tbl(k).seg_name9);
1119: arp_util_tax.debug('seg_name10 : ' || denorm_tbl(k).seg_name10);
1120: arp_util_tax.debug('appl_col_name1 : ' || denorm_tbl(k).appl_col_name1);
1121: arp_util_tax.debug('appl_col_name2 : ' || denorm_tbl(k).appl_col_name2);
1122: arp_util_tax.debug('appl_col_name3 : ' || denorm_tbl(k).appl_col_name3);

Line 1119: arp_util_tax.debug('seg_name10 : ' || denorm_tbl(k).seg_name10);

1115: arp_util_tax.debug('seg_name6 : ' || denorm_tbl(k).seg_name6);
1116: arp_util_tax.debug('seg_name7 : ' || denorm_tbl(k).seg_name7);
1117: arp_util_tax.debug('seg_name8 : ' || denorm_tbl(k).seg_name8);
1118: arp_util_tax.debug('seg_name9 : ' || denorm_tbl(k).seg_name9);
1119: arp_util_tax.debug('seg_name10 : ' || denorm_tbl(k).seg_name10);
1120: arp_util_tax.debug('appl_col_name1 : ' || denorm_tbl(k).appl_col_name1);
1121: arp_util_tax.debug('appl_col_name2 : ' || denorm_tbl(k).appl_col_name2);
1122: arp_util_tax.debug('appl_col_name3 : ' || denorm_tbl(k).appl_col_name3);
1123: arp_util_tax.debug('appl_col_name4 : ' || denorm_tbl(k).appl_col_name4);

Line 1120: arp_util_tax.debug('appl_col_name1 : ' || denorm_tbl(k).appl_col_name1);

1116: arp_util_tax.debug('seg_name7 : ' || denorm_tbl(k).seg_name7);
1117: arp_util_tax.debug('seg_name8 : ' || denorm_tbl(k).seg_name8);
1118: arp_util_tax.debug('seg_name9 : ' || denorm_tbl(k).seg_name9);
1119: arp_util_tax.debug('seg_name10 : ' || denorm_tbl(k).seg_name10);
1120: arp_util_tax.debug('appl_col_name1 : ' || denorm_tbl(k).appl_col_name1);
1121: arp_util_tax.debug('appl_col_name2 : ' || denorm_tbl(k).appl_col_name2);
1122: arp_util_tax.debug('appl_col_name3 : ' || denorm_tbl(k).appl_col_name3);
1123: arp_util_tax.debug('appl_col_name4 : ' || denorm_tbl(k).appl_col_name4);
1124: arp_util_tax.debug('appl_col_name5 : ' || denorm_tbl(k).appl_col_name5);

Line 1121: arp_util_tax.debug('appl_col_name2 : ' || denorm_tbl(k).appl_col_name2);

1117: arp_util_tax.debug('seg_name8 : ' || denorm_tbl(k).seg_name8);
1118: arp_util_tax.debug('seg_name9 : ' || denorm_tbl(k).seg_name9);
1119: arp_util_tax.debug('seg_name10 : ' || denorm_tbl(k).seg_name10);
1120: arp_util_tax.debug('appl_col_name1 : ' || denorm_tbl(k).appl_col_name1);
1121: arp_util_tax.debug('appl_col_name2 : ' || denorm_tbl(k).appl_col_name2);
1122: arp_util_tax.debug('appl_col_name3 : ' || denorm_tbl(k).appl_col_name3);
1123: arp_util_tax.debug('appl_col_name4 : ' || denorm_tbl(k).appl_col_name4);
1124: arp_util_tax.debug('appl_col_name5 : ' || denorm_tbl(k).appl_col_name5);
1125: arp_util_tax.debug('appl_col_name6 : ' || denorm_tbl(k).appl_col_name6);

Line 1122: arp_util_tax.debug('appl_col_name3 : ' || denorm_tbl(k).appl_col_name3);

1118: arp_util_tax.debug('seg_name9 : ' || denorm_tbl(k).seg_name9);
1119: arp_util_tax.debug('seg_name10 : ' || denorm_tbl(k).seg_name10);
1120: arp_util_tax.debug('appl_col_name1 : ' || denorm_tbl(k).appl_col_name1);
1121: arp_util_tax.debug('appl_col_name2 : ' || denorm_tbl(k).appl_col_name2);
1122: arp_util_tax.debug('appl_col_name3 : ' || denorm_tbl(k).appl_col_name3);
1123: arp_util_tax.debug('appl_col_name4 : ' || denorm_tbl(k).appl_col_name4);
1124: arp_util_tax.debug('appl_col_name5 : ' || denorm_tbl(k).appl_col_name5);
1125: arp_util_tax.debug('appl_col_name6 : ' || denorm_tbl(k).appl_col_name6);
1126: arp_util_tax.debug('appl_col_name7 : ' || denorm_tbl(k).appl_col_name7);

Line 1123: arp_util_tax.debug('appl_col_name4 : ' || denorm_tbl(k).appl_col_name4);

1119: arp_util_tax.debug('seg_name10 : ' || denorm_tbl(k).seg_name10);
1120: arp_util_tax.debug('appl_col_name1 : ' || denorm_tbl(k).appl_col_name1);
1121: arp_util_tax.debug('appl_col_name2 : ' || denorm_tbl(k).appl_col_name2);
1122: arp_util_tax.debug('appl_col_name3 : ' || denorm_tbl(k).appl_col_name3);
1123: arp_util_tax.debug('appl_col_name4 : ' || denorm_tbl(k).appl_col_name4);
1124: arp_util_tax.debug('appl_col_name5 : ' || denorm_tbl(k).appl_col_name5);
1125: arp_util_tax.debug('appl_col_name6 : ' || denorm_tbl(k).appl_col_name6);
1126: arp_util_tax.debug('appl_col_name7 : ' || denorm_tbl(k).appl_col_name7);
1127: arp_util_tax.debug('appl_col_name8 : ' || denorm_tbl(k).appl_col_name8);

Line 1124: arp_util_tax.debug('appl_col_name5 : ' || denorm_tbl(k).appl_col_name5);

1120: arp_util_tax.debug('appl_col_name1 : ' || denorm_tbl(k).appl_col_name1);
1121: arp_util_tax.debug('appl_col_name2 : ' || denorm_tbl(k).appl_col_name2);
1122: arp_util_tax.debug('appl_col_name3 : ' || denorm_tbl(k).appl_col_name3);
1123: arp_util_tax.debug('appl_col_name4 : ' || denorm_tbl(k).appl_col_name4);
1124: arp_util_tax.debug('appl_col_name5 : ' || denorm_tbl(k).appl_col_name5);
1125: arp_util_tax.debug('appl_col_name6 : ' || denorm_tbl(k).appl_col_name6);
1126: arp_util_tax.debug('appl_col_name7 : ' || denorm_tbl(k).appl_col_name7);
1127: arp_util_tax.debug('appl_col_name8 : ' || denorm_tbl(k).appl_col_name8);
1128: arp_util_tax.debug('appl_col_name9 : ' || denorm_tbl(k).appl_col_name9);

Line 1125: arp_util_tax.debug('appl_col_name6 : ' || denorm_tbl(k).appl_col_name6);

1121: arp_util_tax.debug('appl_col_name2 : ' || denorm_tbl(k).appl_col_name2);
1122: arp_util_tax.debug('appl_col_name3 : ' || denorm_tbl(k).appl_col_name3);
1123: arp_util_tax.debug('appl_col_name4 : ' || denorm_tbl(k).appl_col_name4);
1124: arp_util_tax.debug('appl_col_name5 : ' || denorm_tbl(k).appl_col_name5);
1125: arp_util_tax.debug('appl_col_name6 : ' || denorm_tbl(k).appl_col_name6);
1126: arp_util_tax.debug('appl_col_name7 : ' || denorm_tbl(k).appl_col_name7);
1127: arp_util_tax.debug('appl_col_name8 : ' || denorm_tbl(k).appl_col_name8);
1128: arp_util_tax.debug('appl_col_name9 : ' || denorm_tbl(k).appl_col_name9);
1129: arp_util_tax.debug('appl_col_name10 : ' || denorm_tbl(k).appl_col_name10);

Line 1126: arp_util_tax.debug('appl_col_name7 : ' || denorm_tbl(k).appl_col_name7);

1122: arp_util_tax.debug('appl_col_name3 : ' || denorm_tbl(k).appl_col_name3);
1123: arp_util_tax.debug('appl_col_name4 : ' || denorm_tbl(k).appl_col_name4);
1124: arp_util_tax.debug('appl_col_name5 : ' || denorm_tbl(k).appl_col_name5);
1125: arp_util_tax.debug('appl_col_name6 : ' || denorm_tbl(k).appl_col_name6);
1126: arp_util_tax.debug('appl_col_name7 : ' || denorm_tbl(k).appl_col_name7);
1127: arp_util_tax.debug('appl_col_name8 : ' || denorm_tbl(k).appl_col_name8);
1128: arp_util_tax.debug('appl_col_name9 : ' || denorm_tbl(k).appl_col_name9);
1129: arp_util_tax.debug('appl_col_name10 : ' || denorm_tbl(k).appl_col_name10);
1130: arp_util_tax.debug('tax_acct_src_tax : ' || denorm_tbl(k).tax_acct_src_tax);

Line 1127: arp_util_tax.debug('appl_col_name8 : ' || denorm_tbl(k).appl_col_name8);

1123: arp_util_tax.debug('appl_col_name4 : ' || denorm_tbl(k).appl_col_name4);
1124: arp_util_tax.debug('appl_col_name5 : ' || denorm_tbl(k).appl_col_name5);
1125: arp_util_tax.debug('appl_col_name6 : ' || denorm_tbl(k).appl_col_name6);
1126: arp_util_tax.debug('appl_col_name7 : ' || denorm_tbl(k).appl_col_name7);
1127: arp_util_tax.debug('appl_col_name8 : ' || denorm_tbl(k).appl_col_name8);
1128: arp_util_tax.debug('appl_col_name9 : ' || denorm_tbl(k).appl_col_name9);
1129: arp_util_tax.debug('appl_col_name10 : ' || denorm_tbl(k).appl_col_name10);
1130: arp_util_tax.debug('tax_acct_src_tax : ' || denorm_tbl(k).tax_acct_src_tax);
1131: arp_util_tax.debug('exmpt_src_tax : ' || denorm_tbl(k).exmpt_src_tax);

Line 1128: arp_util_tax.debug('appl_col_name9 : ' || denorm_tbl(k).appl_col_name9);

1124: arp_util_tax.debug('appl_col_name5 : ' || denorm_tbl(k).appl_col_name5);
1125: arp_util_tax.debug('appl_col_name6 : ' || denorm_tbl(k).appl_col_name6);
1126: arp_util_tax.debug('appl_col_name7 : ' || denorm_tbl(k).appl_col_name7);
1127: arp_util_tax.debug('appl_col_name8 : ' || denorm_tbl(k).appl_col_name8);
1128: arp_util_tax.debug('appl_col_name9 : ' || denorm_tbl(k).appl_col_name9);
1129: arp_util_tax.debug('appl_col_name10 : ' || denorm_tbl(k).appl_col_name10);
1130: arp_util_tax.debug('tax_acct_src_tax : ' || denorm_tbl(k).tax_acct_src_tax);
1131: arp_util_tax.debug('exmpt_src_tax : ' || denorm_tbl(k).exmpt_src_tax);
1132: arp_util_tax.debug('tax_acc_src_str : ' || denorm_tbl(k).tax_acc_src_str);

Line 1129: arp_util_tax.debug('appl_col_name10 : ' || denorm_tbl(k).appl_col_name10);

1125: arp_util_tax.debug('appl_col_name6 : ' || denorm_tbl(k).appl_col_name6);
1126: arp_util_tax.debug('appl_col_name7 : ' || denorm_tbl(k).appl_col_name7);
1127: arp_util_tax.debug('appl_col_name8 : ' || denorm_tbl(k).appl_col_name8);
1128: arp_util_tax.debug('appl_col_name9 : ' || denorm_tbl(k).appl_col_name9);
1129: arp_util_tax.debug('appl_col_name10 : ' || denorm_tbl(k).appl_col_name10);
1130: arp_util_tax.debug('tax_acct_src_tax : ' || denorm_tbl(k).tax_acct_src_tax);
1131: arp_util_tax.debug('exmpt_src_tax : ' || denorm_tbl(k).exmpt_src_tax);
1132: arp_util_tax.debug('tax_acc_src_str : ' || denorm_tbl(k).tax_acc_src_str);
1133: arp_util_tax.debug('exmpt_src_str : ' || denorm_tbl(k).exmpt_src_str);

Line 1130: arp_util_tax.debug('tax_acct_src_tax : ' || denorm_tbl(k).tax_acct_src_tax);

1126: arp_util_tax.debug('appl_col_name7 : ' || denorm_tbl(k).appl_col_name7);
1127: arp_util_tax.debug('appl_col_name8 : ' || denorm_tbl(k).appl_col_name8);
1128: arp_util_tax.debug('appl_col_name9 : ' || denorm_tbl(k).appl_col_name9);
1129: arp_util_tax.debug('appl_col_name10 : ' || denorm_tbl(k).appl_col_name10);
1130: arp_util_tax.debug('tax_acct_src_tax : ' || denorm_tbl(k).tax_acct_src_tax);
1131: arp_util_tax.debug('exmpt_src_tax : ' || denorm_tbl(k).exmpt_src_tax);
1132: arp_util_tax.debug('tax_acc_src_str : ' || denorm_tbl(k).tax_acc_src_str);
1133: arp_util_tax.debug('exmpt_src_str : ' || denorm_tbl(k).exmpt_src_str);
1134: END LOOP;

Line 1131: arp_util_tax.debug('exmpt_src_tax : ' || denorm_tbl(k).exmpt_src_tax);

1127: arp_util_tax.debug('appl_col_name8 : ' || denorm_tbl(k).appl_col_name8);
1128: arp_util_tax.debug('appl_col_name9 : ' || denorm_tbl(k).appl_col_name9);
1129: arp_util_tax.debug('appl_col_name10 : ' || denorm_tbl(k).appl_col_name10);
1130: arp_util_tax.debug('tax_acct_src_tax : ' || denorm_tbl(k).tax_acct_src_tax);
1131: arp_util_tax.debug('exmpt_src_tax : ' || denorm_tbl(k).exmpt_src_tax);
1132: arp_util_tax.debug('tax_acc_src_str : ' || denorm_tbl(k).tax_acc_src_str);
1133: arp_util_tax.debug('exmpt_src_str : ' || denorm_tbl(k).exmpt_src_str);
1134: END LOOP;
1135: arp_util_tax.debug(' ');

Line 1132: arp_util_tax.debug('tax_acc_src_str : ' || denorm_tbl(k).tax_acc_src_str);

1128: arp_util_tax.debug('appl_col_name9 : ' || denorm_tbl(k).appl_col_name9);
1129: arp_util_tax.debug('appl_col_name10 : ' || denorm_tbl(k).appl_col_name10);
1130: arp_util_tax.debug('tax_acct_src_tax : ' || denorm_tbl(k).tax_acct_src_tax);
1131: arp_util_tax.debug('exmpt_src_tax : ' || denorm_tbl(k).exmpt_src_tax);
1132: arp_util_tax.debug('tax_acc_src_str : ' || denorm_tbl(k).tax_acc_src_str);
1133: arp_util_tax.debug('exmpt_src_str : ' || denorm_tbl(k).exmpt_src_str);
1134: END LOOP;
1135: arp_util_tax.debug(' ');
1136: IF denorm_err_tbl.count > 0 THEN

Line 1133: arp_util_tax.debug('exmpt_src_str : ' || denorm_tbl(k).exmpt_src_str);

1129: arp_util_tax.debug('appl_col_name10 : ' || denorm_tbl(k).appl_col_name10);
1130: arp_util_tax.debug('tax_acct_src_tax : ' || denorm_tbl(k).tax_acct_src_tax);
1131: arp_util_tax.debug('exmpt_src_tax : ' || denorm_tbl(k).exmpt_src_tax);
1132: arp_util_tax.debug('tax_acc_src_str : ' || denorm_tbl(k).tax_acc_src_str);
1133: arp_util_tax.debug('exmpt_src_str : ' || denorm_tbl(k).exmpt_src_str);
1134: END LOOP;
1135: arp_util_tax.debug(' ');
1136: IF denorm_err_tbl.count > 0 THEN
1137: arp_util_tax.debug('*** ORGANZATION MERGED RECORDS ***');

Line 1135: arp_util_tax.debug(' ');

1131: arp_util_tax.debug('exmpt_src_tax : ' || denorm_tbl(k).exmpt_src_tax);
1132: arp_util_tax.debug('tax_acc_src_str : ' || denorm_tbl(k).tax_acc_src_str);
1133: arp_util_tax.debug('exmpt_src_str : ' || denorm_tbl(k).exmpt_src_str);
1134: END LOOP;
1135: arp_util_tax.debug(' ');
1136: IF denorm_err_tbl.count > 0 THEN
1137: arp_util_tax.debug('*** ORGANZATION MERGED RECORDS ***');
1138: FOR k in 1..denorm_err_tbl.count LOOP
1139: arp_util_tax.debug(denorm_err_tbl(k).country_code);

Line 1137: arp_util_tax.debug('* ORGANZATION MERGED RECORDS *');

1133: arp_util_tax.debug('exmpt_src_str : ' || denorm_tbl(k).exmpt_src_str);
1134: END LOOP;
1135: arp_util_tax.debug(' ');
1136: IF denorm_err_tbl.count > 0 THEN
1137: arp_util_tax.debug('*** ORGANZATION MERGED RECORDS ***');
1138: FOR k in 1..denorm_err_tbl.count LOOP
1139: arp_util_tax.debug(denorm_err_tbl(k).country_code);
1140: arp_util_tax.debug(denorm_err_tbl(k).id_flex_num);
1141: arp_util_tax.debug(denorm_err_tbl(k).tax_currency_code);

Line 1139: arp_util_tax.debug(denorm_err_tbl(k).country_code);

1135: arp_util_tax.debug(' ');
1136: IF denorm_err_tbl.count > 0 THEN
1137: arp_util_tax.debug('*** ORGANZATION MERGED RECORDS ***');
1138: FOR k in 1..denorm_err_tbl.count LOOP
1139: arp_util_tax.debug(denorm_err_tbl(k).country_code);
1140: arp_util_tax.debug(denorm_err_tbl(k).id_flex_num);
1141: arp_util_tax.debug(denorm_err_tbl(k).tax_currency_code);
1142: arp_util_tax.debug(denorm_err_tbl(k).tax_precision);
1143: arp_util_tax.debug(denorm_err_tbl(k).tax_mau);

Line 1140: arp_util_tax.debug(denorm_err_tbl(k).id_flex_num);

1136: IF denorm_err_tbl.count > 0 THEN
1137: arp_util_tax.debug('*** ORGANZATION MERGED RECORDS ***');
1138: FOR k in 1..denorm_err_tbl.count LOOP
1139: arp_util_tax.debug(denorm_err_tbl(k).country_code);
1140: arp_util_tax.debug(denorm_err_tbl(k).id_flex_num);
1141: arp_util_tax.debug(denorm_err_tbl(k).tax_currency_code);
1142: arp_util_tax.debug(denorm_err_tbl(k).tax_precision);
1143: arp_util_tax.debug(denorm_err_tbl(k).tax_mau);
1144: arp_util_tax.debug(denorm_err_tbl(k).rounding_rule_code);

Line 1141: arp_util_tax.debug(denorm_err_tbl(k).tax_currency_code);

1137: arp_util_tax.debug('*** ORGANZATION MERGED RECORDS ***');
1138: FOR k in 1..denorm_err_tbl.count LOOP
1139: arp_util_tax.debug(denorm_err_tbl(k).country_code);
1140: arp_util_tax.debug(denorm_err_tbl(k).id_flex_num);
1141: arp_util_tax.debug(denorm_err_tbl(k).tax_currency_code);
1142: arp_util_tax.debug(denorm_err_tbl(k).tax_precision);
1143: arp_util_tax.debug(denorm_err_tbl(k).tax_mau);
1144: arp_util_tax.debug(denorm_err_tbl(k).rounding_rule_code);
1145: arp_util_tax.debug(denorm_err_tbl(k).allow_rounding_override);

Line 1142: arp_util_tax.debug(denorm_err_tbl(k).tax_precision);

1138: FOR k in 1..denorm_err_tbl.count LOOP
1139: arp_util_tax.debug(denorm_err_tbl(k).country_code);
1140: arp_util_tax.debug(denorm_err_tbl(k).id_flex_num);
1141: arp_util_tax.debug(denorm_err_tbl(k).tax_currency_code);
1142: arp_util_tax.debug(denorm_err_tbl(k).tax_precision);
1143: arp_util_tax.debug(denorm_err_tbl(k).tax_mau);
1144: arp_util_tax.debug(denorm_err_tbl(k).rounding_rule_code);
1145: arp_util_tax.debug(denorm_err_tbl(k).allow_rounding_override);
1146: arp_util_tax.debug(denorm_err_tbl(k).org_id);

Line 1143: arp_util_tax.debug(denorm_err_tbl(k).tax_mau);

1139: arp_util_tax.debug(denorm_err_tbl(k).country_code);
1140: arp_util_tax.debug(denorm_err_tbl(k).id_flex_num);
1141: arp_util_tax.debug(denorm_err_tbl(k).tax_currency_code);
1142: arp_util_tax.debug(denorm_err_tbl(k).tax_precision);
1143: arp_util_tax.debug(denorm_err_tbl(k).tax_mau);
1144: arp_util_tax.debug(denorm_err_tbl(k).rounding_rule_code);
1145: arp_util_tax.debug(denorm_err_tbl(k).allow_rounding_override);
1146: arp_util_tax.debug(denorm_err_tbl(k).org_id);
1147: -- arp_util_tax.debug(denorm_tbl(k).tax_account_id); -- Bug 5028254

Line 1144: arp_util_tax.debug(denorm_err_tbl(k).rounding_rule_code);

1140: arp_util_tax.debug(denorm_err_tbl(k).id_flex_num);
1141: arp_util_tax.debug(denorm_err_tbl(k).tax_currency_code);
1142: arp_util_tax.debug(denorm_err_tbl(k).tax_precision);
1143: arp_util_tax.debug(denorm_err_tbl(k).tax_mau);
1144: arp_util_tax.debug(denorm_err_tbl(k).rounding_rule_code);
1145: arp_util_tax.debug(denorm_err_tbl(k).allow_rounding_override);
1146: arp_util_tax.debug(denorm_err_tbl(k).org_id);
1147: -- arp_util_tax.debug(denorm_tbl(k).tax_account_id); -- Bug 5028254
1148: END LOOP;

Line 1145: arp_util_tax.debug(denorm_err_tbl(k).allow_rounding_override);

1141: arp_util_tax.debug(denorm_err_tbl(k).tax_currency_code);
1142: arp_util_tax.debug(denorm_err_tbl(k).tax_precision);
1143: arp_util_tax.debug(denorm_err_tbl(k).tax_mau);
1144: arp_util_tax.debug(denorm_err_tbl(k).rounding_rule_code);
1145: arp_util_tax.debug(denorm_err_tbl(k).allow_rounding_override);
1146: arp_util_tax.debug(denorm_err_tbl(k).org_id);
1147: -- arp_util_tax.debug(denorm_tbl(k).tax_account_id); -- Bug 5028254
1148: END LOOP;
1149: ELSE

Line 1146: arp_util_tax.debug(denorm_err_tbl(k).org_id);

1142: arp_util_tax.debug(denorm_err_tbl(k).tax_precision);
1143: arp_util_tax.debug(denorm_err_tbl(k).tax_mau);
1144: arp_util_tax.debug(denorm_err_tbl(k).rounding_rule_code);
1145: arp_util_tax.debug(denorm_err_tbl(k).allow_rounding_override);
1146: arp_util_tax.debug(denorm_err_tbl(k).org_id);
1147: -- arp_util_tax.debug(denorm_tbl(k).tax_account_id); -- Bug 5028254
1148: END LOOP;
1149: ELSE
1150: arp_util_tax.debug('*** NO ORGANZATION MERGED RECORDS ***');

Line 1147: -- arp_util_tax.debug(denorm_tbl(k).tax_account_id); -- Bug 5028254

1143: arp_util_tax.debug(denorm_err_tbl(k).tax_mau);
1144: arp_util_tax.debug(denorm_err_tbl(k).rounding_rule_code);
1145: arp_util_tax.debug(denorm_err_tbl(k).allow_rounding_override);
1146: arp_util_tax.debug(denorm_err_tbl(k).org_id);
1147: -- arp_util_tax.debug(denorm_tbl(k).tax_account_id); -- Bug 5028254
1148: END LOOP;
1149: ELSE
1150: arp_util_tax.debug('*** NO ORGANZATION MERGED RECORDS ***');
1151: END IF;

Line 1150: arp_util_tax.debug('* NO ORGANZATION MERGED RECORDS *');

1146: arp_util_tax.debug(denorm_err_tbl(k).org_id);
1147: -- arp_util_tax.debug(denorm_tbl(k).tax_account_id); -- Bug 5028254
1148: END LOOP;
1149: ELSE
1150: arp_util_tax.debug('*** NO ORGANZATION MERGED RECORDS ***');
1151: END IF;
1152: -- ****** DEBUG ******
1153:
1154: /*SELECT min(start_date)

Line 6017: arp_util_tax.debug('migrate_ar_vat_tax(-)');

6013: AND zrt.language = avtt.language
6014: AND zrt.source_lang = avtt.source_lang);*/
6015:
6016: IF PG_DEBUG = 'Y' THEN
6017: arp_util_tax.debug('migrate_ar_vat_tax(-)');
6018: END IF;
6019:
6020: EXCEPTION
6021: WHEN OTHERS THEN

Line 6023: arp_util_tax.debug('EXCEPTION: migrate_ar_vat_tax ');

6019:
6020: EXCEPTION
6021: WHEN OTHERS THEN
6022: IF PG_DEBUG = 'Y' THEN
6023: arp_util_tax.debug('EXCEPTION: migrate_ar_vat_tax ');
6024: arp_util_tax.debug(sqlcode || ' : ' || sqlerrm);
6025: arp_util_tax.debug('migrate_ar_vat_tax(-)');
6026: END IF;
6027: --app_exception.raise_exception;

Line 6024: arp_util_tax.debug(sqlcode || ' : ' || sqlerrm);

6020: EXCEPTION
6021: WHEN OTHERS THEN
6022: IF PG_DEBUG = 'Y' THEN
6023: arp_util_tax.debug('EXCEPTION: migrate_ar_vat_tax ');
6024: arp_util_tax.debug(sqlcode || ' : ' || sqlerrm);
6025: arp_util_tax.debug('migrate_ar_vat_tax(-)');
6026: END IF;
6027: --app_exception.raise_exception;
6028:

Line 6025: arp_util_tax.debug('migrate_ar_vat_tax(-)');

6021: WHEN OTHERS THEN
6022: IF PG_DEBUG = 'Y' THEN
6023: arp_util_tax.debug('EXCEPTION: migrate_ar_vat_tax ');
6024: arp_util_tax.debug(sqlcode || ' : ' || sqlerrm);
6025: arp_util_tax.debug('migrate_ar_vat_tax(-)');
6026: END IF;
6027: --app_exception.raise_exception;
6028:
6029: END;

Line 6107: arp_util_tax.debug('is_synch_needed.loc_str_id: No data found');

6103:
6104: END IF;
6105: EXCEPTION
6106: WHEN NO_DATA_FOUND THEN
6107: arp_util_tax.debug('is_synch_needed.loc_str_id: No data found');
6108: WHEN OTHERS THEN
6109: arp_util_tax.debug('is_synch_needed.loc_str_id: Others');
6110: END;
6111:

Line 6109: arp_util_tax.debug('is_synch_needed.loc_str_id: Others');

6105: EXCEPTION
6106: WHEN NO_DATA_FOUND THEN
6107: arp_util_tax.debug('is_synch_needed.loc_str_id: No data found');
6108: WHEN OTHERS THEN
6109: arp_util_tax.debug('is_synch_needed.loc_str_id: Others');
6110: END;
6111:
6112: IF l_location_str_id IS NOT NULL THEN
6113: BEGIN

Line 6126: arp_util_tax.debug('is_synch_needed.l_tax_regime_code: No data found');

6122: '@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@'
6123: ),'@'),'-999'));
6124: EXCEPTION
6125: WHEN NO_DATA_FOUND THEN
6126: arp_util_tax.debug('is_synch_needed.l_tax_regime_code: No data found');
6127: WHEN OTHERS THEN
6128: arp_util_tax.debug('is_synch_needed.l_tax_regime_code: Others');
6129: END;
6130: IF l_tax_regime_code IS NOT NULL THEN

Line 6128: arp_util_tax.debug('is_synch_needed.l_tax_regime_code: Others');

6124: EXCEPTION
6125: WHEN NO_DATA_FOUND THEN
6126: arp_util_tax.debug('is_synch_needed.l_tax_regime_code: No data found');
6127: WHEN OTHERS THEN
6128: arp_util_tax.debug('is_synch_needed.l_tax_regime_code: Others');
6129: END;
6130: IF l_tax_regime_code IS NOT NULL THEN
6131: BEGIN
6132: SELECT ztb.tax

Line 6143: arp_util_tax.debug('is_synch_needed.l_tax: No data found');

6139: AND ztb.tax = 'LOCATION'
6140: AND ztb.tax_regime_code = l_tax_regime_code;
6141: EXCEPTION
6142: WHEN NO_DATA_FOUND THEN
6143: arp_util_tax.debug('is_synch_needed.l_tax: No data found');
6144: WHEN OTHERS THEN
6145: arp_util_tax.debug('is_synch_needed.l_tax: Others');
6146: END;
6147: IF l_tax IS NOT NULL THEN

Line 6145: arp_util_tax.debug('is_synch_needed.l_tax: Others');

6141: EXCEPTION
6142: WHEN NO_DATA_FOUND THEN
6143: arp_util_tax.debug('is_synch_needed.l_tax: No data found');
6144: WHEN OTHERS THEN
6145: arp_util_tax.debug('is_synch_needed.l_tax: Others');
6146: END;
6147: IF l_tax IS NOT NULL THEN
6148: RETURN FALSE; --Regime exists PLUS tax exists for CO --NO SYNCH--
6149: ELSE

Line 6853: --arp_util_tax.debug('1:');

6849:
6850: END IF;
6851:
6852:
6853: --arp_util_tax.debug('1:');
6854:
6855: /*
6856: -- LTE handling
6857: INSERT INTO ZX_STATUS_B_TMP

Line 6991: --arp_util_tax.debug('2:');

6987: AR_SYS_OP.TAX_USE_LOC_EXC_RATE_FLAG
6988: );
6989: */
6990:
6991: --arp_util_tax.debug('2:');
6992:
6993: -- Unused JATW_GOVERNMENT_TAX_TYPE global flexfield atttribute handling
6994: IF L_JATW_USED = 'Y' THEN
6995: IF L_MULTI_ORG_FLAG = 'Y' THEN

Line 7303: arp_util_tax.debug('3:');

7299: END IF;
7300: END IF;
7301: --End of JATW_GOVERNMENT_TAX_TYPE lookup code
7302:
7303: arp_util_tax.debug('3:');
7304: /*
7305: INSERT INTO ZX_STATUS_TL
7306: (
7307: TAX_STATUS_ID,

Line 8835: arp_util_tax.debug('Failed to update zx_taxes_b due to exception in migrate_profile for org:'

8831: and party_type_code='OU')
8832: and record_type_code='MIGRATED';
8833:
8834: EXCEPTION WHEN OTHERS THEN
8835: arp_util_tax.debug('Failed to update zx_taxes_b due to exception in migrate_profile for org:'
8836: ||l_org_id(i)||sqlerrm);
8837: END;
8838:
8839: BEGIN

Line 8849: arp_util_tax.debug('Failed to update zx_status_b due to exception in migrate_profile for org:'

8845: and party_type_code='OU')
8846: and record_type_code='MIGRATED';
8847:
8848: EXCEPTION WHEN OTHERS THEN
8849: arp_util_tax.debug('Failed to update zx_status_b due to exception in migrate_profile for org:'
8850: ||l_org_id(i)||sqlerrm);
8851: END;
8852:
8853: END LOOP; -- end l_org_id.count LOOP

Line 8949: arp_util_tax.debug('sel ar_vat_tax_all_b');

8945: IN ('JL.AR.ARXSUVAT.AR_VAT_TAX',
8946: 'JL.BR.ARXSUVAT.Tax Information', -- Bug 4868971
8947: 'JL.CO.ARXSUVAT.AR_VAT_TAX');
8948:
8949: arp_util_tax.debug('sel ar_vat_tax_all_b');
8950:
8951: forall i in 1..lc_rate_code_id.last
8952: update ar_vat_tax_all_b
8953: set tax_regime_code = lc_tax_regime_code(i),

Line 8960: arp_util_tax.debug('upd ar_vat_all_b');

8956: where vat_tax_id = lc_rate_code_id(i);
8957: -- YK:9/17/2004: May need limit clause as per performance team's
8958: -- guideline.
8959:
8960: arp_util_tax.debug('upd ar_vat_all_b');
8961:
8962: EXCEPTION
8963: WHEN OTHERS THEN
8964: NULL;

Line 9257: arp_util_tax.debug('Exception: is_update_needed_for_tax');

9253: RETURN TRUE; -- p_tax_id IS NULL
9254: END IF;
9255: EXCEPTION
9256: WHEN OTHERS THEN
9257: arp_util_tax.debug('Exception: is_update_needed_for_tax');
9258: END;
9259:
9260: /*===========================================================================+
9261: | PROCEDURE

Line 10378: arp_util_tax.debug('e:pkg_condt:lte_used:'||sqlcode || ' : ' || sqlerrm);

10374: EXCEPTION
10375: WHEN no_data_found THEN
10376: NULL;
10377: WHEN others THEN
10378: arp_util_tax.debug('e:pkg_condt:lte_used:'||sqlcode || ' : ' || sqlerrm);
10379: END;*/
10380:
10381: -- Check if JATW is used
10382: BEGIN

Line 10391: arp_util_tax.debug('e:pkg_const:jatw_used:'||sqlcode || ' : ' || sqlerrm);

10387: EXCEPTION
10388: WHEN no_data_found THEN
10389: NULL;
10390: WHEN others THEN
10391: arp_util_tax.debug('e:pkg_const:jatw_used:'||sqlcode || ' : ' || sqlerrm);
10392: END;
10393:
10394: -- Check MIN START DATE
10395: BEGIN

Line 10401: arp_util_tax.debug('e:pkg_const:l_min_start_date:'||sqlcode || ' : ' || sqlerrm);

10397: INTO L_MIN_START_DATE
10398: FROM ar_vat_tax_all_b;
10399: EXCEPTION
10400: WHEN OTHERS THEN
10401: arp_util_tax.debug('e:pkg_const:l_min_start_date:'||sqlcode || ' : ' || sqlerrm);
10402: END;
10403:
10404:
10405: BEGIN

Line 10414: arp_util_tax.debug('MO: Operating Units site level profile option value not set , resulted in Null Org Id');

10410:
10411: FND_PROFILE.GET('ORG_ID',L_ORG_ID);
10412:
10413: IF L_ORG_ID IS NULL THEN
10414: arp_util_tax.debug('MO: Operating Units site level profile option value not set , resulted in Null Org Id');
10415: END IF;
10416: ELSE
10417: L_ORG_ID := NULL;
10418: END IF;

Line 10423: arp_util_tax.debug('Exception in constructor of AR TAX DEFINITION'||sqlerrm);

10419:
10420:
10421: EXCEPTION
10422: WHEN OTHERS THEN
10423: arp_util_tax.debug('Exception in constructor of AR TAX DEFINITION'||sqlerrm);
10424: END;
10425:
10426: BEGIN
10427: MO_GLOBAL.INIT('ZX');

Line 10429: arp_util_tax.debug('Exception in MO_GLOBAL.init');

10425:
10426: BEGIN
10427: MO_GLOBAL.INIT('ZX');
10428: EXCEPTION WHEN OTHERS THEN
10429: arp_util_tax.debug('Exception in MO_GLOBAL.init');
10430: END;
10431:
10432:
10433: END;