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 1004: arp_util_tax.debug('***');

1000: denorm_tbl(i) := loc_str_rec;
1001:
1002: -- ****** DEBUG ******
1003: FOR k in 1..denorm_tbl.count LOOP
1004: arp_util_tax.debug('***');
1005: arp_util_tax.debug('country_code: ' || denorm_tbl(k).country_code);
1006: arp_util_tax.debug('id_flex_num : ' || denorm_tbl(k).id_flex_num);
1007: arp_util_tax.debug('seg_att_type1: ' || denorm_tbl(k).seg_att_type1);
1008: arp_util_tax.debug('seg_att_type2: ' || denorm_tbl(k).seg_att_type2);

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

1001:
1002: -- ****** DEBUG ******
1003: FOR k in 1..denorm_tbl.count LOOP
1004: arp_util_tax.debug('***');
1005: arp_util_tax.debug('country_code: ' || denorm_tbl(k).country_code);
1006: arp_util_tax.debug('id_flex_num : ' || denorm_tbl(k).id_flex_num);
1007: arp_util_tax.debug('seg_att_type1: ' || denorm_tbl(k).seg_att_type1);
1008: arp_util_tax.debug('seg_att_type2: ' || denorm_tbl(k).seg_att_type2);
1009: arp_util_tax.debug('seg_att_type3: ' || denorm_tbl(k).seg_att_type3);

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

1002: -- ****** DEBUG ******
1003: FOR k in 1..denorm_tbl.count LOOP
1004: arp_util_tax.debug('***');
1005: arp_util_tax.debug('country_code: ' || denorm_tbl(k).country_code);
1006: arp_util_tax.debug('id_flex_num : ' || denorm_tbl(k).id_flex_num);
1007: arp_util_tax.debug('seg_att_type1: ' || denorm_tbl(k).seg_att_type1);
1008: arp_util_tax.debug('seg_att_type2: ' || denorm_tbl(k).seg_att_type2);
1009: arp_util_tax.debug('seg_att_type3: ' || denorm_tbl(k).seg_att_type3);
1010: arp_util_tax.debug('seg_att_type4: ' || denorm_tbl(k).seg_att_type4);

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

1003: FOR k in 1..denorm_tbl.count LOOP
1004: arp_util_tax.debug('***');
1005: arp_util_tax.debug('country_code: ' || denorm_tbl(k).country_code);
1006: arp_util_tax.debug('id_flex_num : ' || denorm_tbl(k).id_flex_num);
1007: arp_util_tax.debug('seg_att_type1: ' || denorm_tbl(k).seg_att_type1);
1008: arp_util_tax.debug('seg_att_type2: ' || denorm_tbl(k).seg_att_type2);
1009: arp_util_tax.debug('seg_att_type3: ' || denorm_tbl(k).seg_att_type3);
1010: arp_util_tax.debug('seg_att_type4: ' || denorm_tbl(k).seg_att_type4);
1011: arp_util_tax.debug('seg_att_type5: ' || denorm_tbl(k).seg_att_type5);

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

1004: arp_util_tax.debug('***');
1005: arp_util_tax.debug('country_code: ' || denorm_tbl(k).country_code);
1006: arp_util_tax.debug('id_flex_num : ' || denorm_tbl(k).id_flex_num);
1007: arp_util_tax.debug('seg_att_type1: ' || denorm_tbl(k).seg_att_type1);
1008: arp_util_tax.debug('seg_att_type2: ' || denorm_tbl(k).seg_att_type2);
1009: arp_util_tax.debug('seg_att_type3: ' || denorm_tbl(k).seg_att_type3);
1010: arp_util_tax.debug('seg_att_type4: ' || denorm_tbl(k).seg_att_type4);
1011: arp_util_tax.debug('seg_att_type5: ' || denorm_tbl(k).seg_att_type5);
1012: arp_util_tax.debug('seg_att_type6: ' || denorm_tbl(k).seg_att_type6);

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

1005: arp_util_tax.debug('country_code: ' || denorm_tbl(k).country_code);
1006: arp_util_tax.debug('id_flex_num : ' || denorm_tbl(k).id_flex_num);
1007: arp_util_tax.debug('seg_att_type1: ' || denorm_tbl(k).seg_att_type1);
1008: arp_util_tax.debug('seg_att_type2: ' || denorm_tbl(k).seg_att_type2);
1009: arp_util_tax.debug('seg_att_type3: ' || denorm_tbl(k).seg_att_type3);
1010: arp_util_tax.debug('seg_att_type4: ' || denorm_tbl(k).seg_att_type4);
1011: arp_util_tax.debug('seg_att_type5: ' || denorm_tbl(k).seg_att_type5);
1012: arp_util_tax.debug('seg_att_type6: ' || denorm_tbl(k).seg_att_type6);
1013: arp_util_tax.debug('seg_att_type7: ' || denorm_tbl(k).seg_att_type7);

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

1006: arp_util_tax.debug('id_flex_num : ' || denorm_tbl(k).id_flex_num);
1007: arp_util_tax.debug('seg_att_type1: ' || denorm_tbl(k).seg_att_type1);
1008: arp_util_tax.debug('seg_att_type2: ' || denorm_tbl(k).seg_att_type2);
1009: arp_util_tax.debug('seg_att_type3: ' || denorm_tbl(k).seg_att_type3);
1010: arp_util_tax.debug('seg_att_type4: ' || denorm_tbl(k).seg_att_type4);
1011: arp_util_tax.debug('seg_att_type5: ' || denorm_tbl(k).seg_att_type5);
1012: arp_util_tax.debug('seg_att_type6: ' || denorm_tbl(k).seg_att_type6);
1013: arp_util_tax.debug('seg_att_type7: ' || denorm_tbl(k).seg_att_type7);
1014: arp_util_tax.debug('seg_att_type8: ' || denorm_tbl(k).seg_att_type8);

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

1007: arp_util_tax.debug('seg_att_type1: ' || denorm_tbl(k).seg_att_type1);
1008: arp_util_tax.debug('seg_att_type2: ' || denorm_tbl(k).seg_att_type2);
1009: arp_util_tax.debug('seg_att_type3: ' || denorm_tbl(k).seg_att_type3);
1010: arp_util_tax.debug('seg_att_type4: ' || denorm_tbl(k).seg_att_type4);
1011: arp_util_tax.debug('seg_att_type5: ' || denorm_tbl(k).seg_att_type5);
1012: arp_util_tax.debug('seg_att_type6: ' || denorm_tbl(k).seg_att_type6);
1013: arp_util_tax.debug('seg_att_type7: ' || denorm_tbl(k).seg_att_type7);
1014: arp_util_tax.debug('seg_att_type8: ' || denorm_tbl(k).seg_att_type8);
1015: arp_util_tax.debug('seg_att_type9: ' || denorm_tbl(k).seg_att_type9);

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

1008: arp_util_tax.debug('seg_att_type2: ' || denorm_tbl(k).seg_att_type2);
1009: arp_util_tax.debug('seg_att_type3: ' || denorm_tbl(k).seg_att_type3);
1010: arp_util_tax.debug('seg_att_type4: ' || denorm_tbl(k).seg_att_type4);
1011: arp_util_tax.debug('seg_att_type5: ' || denorm_tbl(k).seg_att_type5);
1012: arp_util_tax.debug('seg_att_type6: ' || denorm_tbl(k).seg_att_type6);
1013: arp_util_tax.debug('seg_att_type7: ' || denorm_tbl(k).seg_att_type7);
1014: arp_util_tax.debug('seg_att_type8: ' || denorm_tbl(k).seg_att_type8);
1015: arp_util_tax.debug('seg_att_type9: ' || denorm_tbl(k).seg_att_type9);
1016: arp_util_tax.debug('seg_att_type10: ' || denorm_tbl(k).seg_att_type10);

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

1009: arp_util_tax.debug('seg_att_type3: ' || denorm_tbl(k).seg_att_type3);
1010: arp_util_tax.debug('seg_att_type4: ' || denorm_tbl(k).seg_att_type4);
1011: arp_util_tax.debug('seg_att_type5: ' || denorm_tbl(k).seg_att_type5);
1012: arp_util_tax.debug('seg_att_type6: ' || denorm_tbl(k).seg_att_type6);
1013: arp_util_tax.debug('seg_att_type7: ' || denorm_tbl(k).seg_att_type7);
1014: arp_util_tax.debug('seg_att_type8: ' || denorm_tbl(k).seg_att_type8);
1015: arp_util_tax.debug('seg_att_type9: ' || denorm_tbl(k).seg_att_type9);
1016: arp_util_tax.debug('seg_att_type10: ' || denorm_tbl(k).seg_att_type10);
1017: arp_util_tax.debug('tax_curr_code : ' || denorm_tbl(k).tax_currency_code);

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

1010: arp_util_tax.debug('seg_att_type4: ' || denorm_tbl(k).seg_att_type4);
1011: arp_util_tax.debug('seg_att_type5: ' || denorm_tbl(k).seg_att_type5);
1012: arp_util_tax.debug('seg_att_type6: ' || denorm_tbl(k).seg_att_type6);
1013: arp_util_tax.debug('seg_att_type7: ' || denorm_tbl(k).seg_att_type7);
1014: arp_util_tax.debug('seg_att_type8: ' || denorm_tbl(k).seg_att_type8);
1015: arp_util_tax.debug('seg_att_type9: ' || denorm_tbl(k).seg_att_type9);
1016: arp_util_tax.debug('seg_att_type10: ' || denorm_tbl(k).seg_att_type10);
1017: arp_util_tax.debug('tax_curr_code : ' || denorm_tbl(k).tax_currency_code);
1018: arp_util_tax.debug('tax_precision : ' || denorm_tbl(k).tax_precision);

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

1011: arp_util_tax.debug('seg_att_type5: ' || denorm_tbl(k).seg_att_type5);
1012: arp_util_tax.debug('seg_att_type6: ' || denorm_tbl(k).seg_att_type6);
1013: arp_util_tax.debug('seg_att_type7: ' || denorm_tbl(k).seg_att_type7);
1014: arp_util_tax.debug('seg_att_type8: ' || denorm_tbl(k).seg_att_type8);
1015: arp_util_tax.debug('seg_att_type9: ' || denorm_tbl(k).seg_att_type9);
1016: arp_util_tax.debug('seg_att_type10: ' || denorm_tbl(k).seg_att_type10);
1017: arp_util_tax.debug('tax_curr_code : ' || denorm_tbl(k).tax_currency_code);
1018: arp_util_tax.debug('tax_precision : ' || denorm_tbl(k).tax_precision);
1019: arp_util_tax.debug('tax_man : ' || denorm_tbl(k).tax_mau);

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

1012: arp_util_tax.debug('seg_att_type6: ' || denorm_tbl(k).seg_att_type6);
1013: arp_util_tax.debug('seg_att_type7: ' || denorm_tbl(k).seg_att_type7);
1014: arp_util_tax.debug('seg_att_type8: ' || denorm_tbl(k).seg_att_type8);
1015: arp_util_tax.debug('seg_att_type9: ' || denorm_tbl(k).seg_att_type9);
1016: arp_util_tax.debug('seg_att_type10: ' || denorm_tbl(k).seg_att_type10);
1017: arp_util_tax.debug('tax_curr_code : ' || denorm_tbl(k).tax_currency_code);
1018: arp_util_tax.debug('tax_precision : ' || denorm_tbl(k).tax_precision);
1019: arp_util_tax.debug('tax_man : ' || denorm_tbl(k).tax_mau);
1020: arp_util_tax.debug('rounding_rule : ' || denorm_tbl(k).rounding_rule_code);

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

1013: arp_util_tax.debug('seg_att_type7: ' || denorm_tbl(k).seg_att_type7);
1014: arp_util_tax.debug('seg_att_type8: ' || denorm_tbl(k).seg_att_type8);
1015: arp_util_tax.debug('seg_att_type9: ' || denorm_tbl(k).seg_att_type9);
1016: arp_util_tax.debug('seg_att_type10: ' || denorm_tbl(k).seg_att_type10);
1017: arp_util_tax.debug('tax_curr_code : ' || denorm_tbl(k).tax_currency_code);
1018: arp_util_tax.debug('tax_precision : ' || denorm_tbl(k).tax_precision);
1019: arp_util_tax.debug('tax_man : ' || denorm_tbl(k).tax_mau);
1020: arp_util_tax.debug('rounding_rule : ' || denorm_tbl(k).rounding_rule_code);
1021: arp_util_tax.debug('allow_rounding_over : ' || denorm_tbl(k).allow_rounding_override);

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

1014: arp_util_tax.debug('seg_att_type8: ' || denorm_tbl(k).seg_att_type8);
1015: arp_util_tax.debug('seg_att_type9: ' || denorm_tbl(k).seg_att_type9);
1016: arp_util_tax.debug('seg_att_type10: ' || denorm_tbl(k).seg_att_type10);
1017: arp_util_tax.debug('tax_curr_code : ' || denorm_tbl(k).tax_currency_code);
1018: arp_util_tax.debug('tax_precision : ' || denorm_tbl(k).tax_precision);
1019: arp_util_tax.debug('tax_man : ' || denorm_tbl(k).tax_mau);
1020: arp_util_tax.debug('rounding_rule : ' || denorm_tbl(k).rounding_rule_code);
1021: arp_util_tax.debug('allow_rounding_over : ' || denorm_tbl(k).allow_rounding_override);
1022: arp_util_tax.debug('org_id : ' || denorm_tbl(k).org_id);

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

1015: arp_util_tax.debug('seg_att_type9: ' || denorm_tbl(k).seg_att_type9);
1016: arp_util_tax.debug('seg_att_type10: ' || denorm_tbl(k).seg_att_type10);
1017: arp_util_tax.debug('tax_curr_code : ' || denorm_tbl(k).tax_currency_code);
1018: arp_util_tax.debug('tax_precision : ' || denorm_tbl(k).tax_precision);
1019: arp_util_tax.debug('tax_man : ' || denorm_tbl(k).tax_mau);
1020: arp_util_tax.debug('rounding_rule : ' || denorm_tbl(k).rounding_rule_code);
1021: arp_util_tax.debug('allow_rounding_over : ' || denorm_tbl(k).allow_rounding_override);
1022: arp_util_tax.debug('org_id : ' || denorm_tbl(k).org_id);
1023: arp_util_tax.debug('tax_acct_id : ' || denorm_tbl(k).tax_account_id);

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

1016: arp_util_tax.debug('seg_att_type10: ' || denorm_tbl(k).seg_att_type10);
1017: arp_util_tax.debug('tax_curr_code : ' || denorm_tbl(k).tax_currency_code);
1018: arp_util_tax.debug('tax_precision : ' || denorm_tbl(k).tax_precision);
1019: arp_util_tax.debug('tax_man : ' || denorm_tbl(k).tax_mau);
1020: arp_util_tax.debug('rounding_rule : ' || denorm_tbl(k).rounding_rule_code);
1021: arp_util_tax.debug('allow_rounding_over : ' || denorm_tbl(k).allow_rounding_override);
1022: arp_util_tax.debug('org_id : ' || denorm_tbl(k).org_id);
1023: arp_util_tax.debug('tax_acct_id : ' || denorm_tbl(k).tax_account_id);
1024: arp_util_tax.debug('seg_name1 : ' || denorm_tbl(k).seg_name1);

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

1017: arp_util_tax.debug('tax_curr_code : ' || denorm_tbl(k).tax_currency_code);
1018: arp_util_tax.debug('tax_precision : ' || denorm_tbl(k).tax_precision);
1019: arp_util_tax.debug('tax_man : ' || denorm_tbl(k).tax_mau);
1020: arp_util_tax.debug('rounding_rule : ' || denorm_tbl(k).rounding_rule_code);
1021: arp_util_tax.debug('allow_rounding_over : ' || denorm_tbl(k).allow_rounding_override);
1022: arp_util_tax.debug('org_id : ' || denorm_tbl(k).org_id);
1023: arp_util_tax.debug('tax_acct_id : ' || denorm_tbl(k).tax_account_id);
1024: arp_util_tax.debug('seg_name1 : ' || denorm_tbl(k).seg_name1);
1025: arp_util_tax.debug('seg_name2 : ' || denorm_tbl(k).seg_name2);

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

1018: arp_util_tax.debug('tax_precision : ' || denorm_tbl(k).tax_precision);
1019: arp_util_tax.debug('tax_man : ' || denorm_tbl(k).tax_mau);
1020: arp_util_tax.debug('rounding_rule : ' || denorm_tbl(k).rounding_rule_code);
1021: arp_util_tax.debug('allow_rounding_over : ' || denorm_tbl(k).allow_rounding_override);
1022: arp_util_tax.debug('org_id : ' || denorm_tbl(k).org_id);
1023: arp_util_tax.debug('tax_acct_id : ' || denorm_tbl(k).tax_account_id);
1024: arp_util_tax.debug('seg_name1 : ' || denorm_tbl(k).seg_name1);
1025: arp_util_tax.debug('seg_name2 : ' || denorm_tbl(k).seg_name2);
1026: arp_util_tax.debug('seg_name3 : ' || denorm_tbl(k).seg_name3);

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

1019: arp_util_tax.debug('tax_man : ' || denorm_tbl(k).tax_mau);
1020: arp_util_tax.debug('rounding_rule : ' || denorm_tbl(k).rounding_rule_code);
1021: arp_util_tax.debug('allow_rounding_over : ' || denorm_tbl(k).allow_rounding_override);
1022: arp_util_tax.debug('org_id : ' || denorm_tbl(k).org_id);
1023: arp_util_tax.debug('tax_acct_id : ' || denorm_tbl(k).tax_account_id);
1024: arp_util_tax.debug('seg_name1 : ' || denorm_tbl(k).seg_name1);
1025: arp_util_tax.debug('seg_name2 : ' || denorm_tbl(k).seg_name2);
1026: arp_util_tax.debug('seg_name3 : ' || denorm_tbl(k).seg_name3);
1027: arp_util_tax.debug('seg_name4 : ' || denorm_tbl(k).seg_name4);

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

1020: arp_util_tax.debug('rounding_rule : ' || denorm_tbl(k).rounding_rule_code);
1021: arp_util_tax.debug('allow_rounding_over : ' || denorm_tbl(k).allow_rounding_override);
1022: arp_util_tax.debug('org_id : ' || denorm_tbl(k).org_id);
1023: arp_util_tax.debug('tax_acct_id : ' || denorm_tbl(k).tax_account_id);
1024: arp_util_tax.debug('seg_name1 : ' || denorm_tbl(k).seg_name1);
1025: arp_util_tax.debug('seg_name2 : ' || denorm_tbl(k).seg_name2);
1026: arp_util_tax.debug('seg_name3 : ' || denorm_tbl(k).seg_name3);
1027: arp_util_tax.debug('seg_name4 : ' || denorm_tbl(k).seg_name4);
1028: arp_util_tax.debug('seg_name5 : ' || denorm_tbl(k).seg_name5);

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

1021: arp_util_tax.debug('allow_rounding_over : ' || denorm_tbl(k).allow_rounding_override);
1022: arp_util_tax.debug('org_id : ' || denorm_tbl(k).org_id);
1023: arp_util_tax.debug('tax_acct_id : ' || denorm_tbl(k).tax_account_id);
1024: arp_util_tax.debug('seg_name1 : ' || denorm_tbl(k).seg_name1);
1025: arp_util_tax.debug('seg_name2 : ' || denorm_tbl(k).seg_name2);
1026: arp_util_tax.debug('seg_name3 : ' || denorm_tbl(k).seg_name3);
1027: arp_util_tax.debug('seg_name4 : ' || denorm_tbl(k).seg_name4);
1028: arp_util_tax.debug('seg_name5 : ' || denorm_tbl(k).seg_name5);
1029: arp_util_tax.debug('seg_name6 : ' || denorm_tbl(k).seg_name6);

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

1022: arp_util_tax.debug('org_id : ' || denorm_tbl(k).org_id);
1023: arp_util_tax.debug('tax_acct_id : ' || denorm_tbl(k).tax_account_id);
1024: arp_util_tax.debug('seg_name1 : ' || denorm_tbl(k).seg_name1);
1025: arp_util_tax.debug('seg_name2 : ' || denorm_tbl(k).seg_name2);
1026: arp_util_tax.debug('seg_name3 : ' || denorm_tbl(k).seg_name3);
1027: arp_util_tax.debug('seg_name4 : ' || denorm_tbl(k).seg_name4);
1028: arp_util_tax.debug('seg_name5 : ' || denorm_tbl(k).seg_name5);
1029: arp_util_tax.debug('seg_name6 : ' || denorm_tbl(k).seg_name6);
1030: arp_util_tax.debug('seg_name7 : ' || denorm_tbl(k).seg_name7);

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

1023: arp_util_tax.debug('tax_acct_id : ' || denorm_tbl(k).tax_account_id);
1024: arp_util_tax.debug('seg_name1 : ' || denorm_tbl(k).seg_name1);
1025: arp_util_tax.debug('seg_name2 : ' || denorm_tbl(k).seg_name2);
1026: arp_util_tax.debug('seg_name3 : ' || denorm_tbl(k).seg_name3);
1027: arp_util_tax.debug('seg_name4 : ' || denorm_tbl(k).seg_name4);
1028: arp_util_tax.debug('seg_name5 : ' || denorm_tbl(k).seg_name5);
1029: arp_util_tax.debug('seg_name6 : ' || denorm_tbl(k).seg_name6);
1030: arp_util_tax.debug('seg_name7 : ' || denorm_tbl(k).seg_name7);
1031: arp_util_tax.debug('seg_name8 : ' || denorm_tbl(k).seg_name8);

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

1024: arp_util_tax.debug('seg_name1 : ' || denorm_tbl(k).seg_name1);
1025: arp_util_tax.debug('seg_name2 : ' || denorm_tbl(k).seg_name2);
1026: arp_util_tax.debug('seg_name3 : ' || denorm_tbl(k).seg_name3);
1027: arp_util_tax.debug('seg_name4 : ' || denorm_tbl(k).seg_name4);
1028: arp_util_tax.debug('seg_name5 : ' || denorm_tbl(k).seg_name5);
1029: arp_util_tax.debug('seg_name6 : ' || denorm_tbl(k).seg_name6);
1030: arp_util_tax.debug('seg_name7 : ' || denorm_tbl(k).seg_name7);
1031: arp_util_tax.debug('seg_name8 : ' || denorm_tbl(k).seg_name8);
1032: arp_util_tax.debug('seg_name9 : ' || denorm_tbl(k).seg_name9);

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

1025: arp_util_tax.debug('seg_name2 : ' || denorm_tbl(k).seg_name2);
1026: arp_util_tax.debug('seg_name3 : ' || denorm_tbl(k).seg_name3);
1027: arp_util_tax.debug('seg_name4 : ' || denorm_tbl(k).seg_name4);
1028: arp_util_tax.debug('seg_name5 : ' || denorm_tbl(k).seg_name5);
1029: arp_util_tax.debug('seg_name6 : ' || denorm_tbl(k).seg_name6);
1030: arp_util_tax.debug('seg_name7 : ' || denorm_tbl(k).seg_name7);
1031: arp_util_tax.debug('seg_name8 : ' || denorm_tbl(k).seg_name8);
1032: arp_util_tax.debug('seg_name9 : ' || denorm_tbl(k).seg_name9);
1033: arp_util_tax.debug('seg_name10 : ' || denorm_tbl(k).seg_name10);

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

1026: arp_util_tax.debug('seg_name3 : ' || denorm_tbl(k).seg_name3);
1027: arp_util_tax.debug('seg_name4 : ' || denorm_tbl(k).seg_name4);
1028: arp_util_tax.debug('seg_name5 : ' || denorm_tbl(k).seg_name5);
1029: arp_util_tax.debug('seg_name6 : ' || denorm_tbl(k).seg_name6);
1030: arp_util_tax.debug('seg_name7 : ' || denorm_tbl(k).seg_name7);
1031: arp_util_tax.debug('seg_name8 : ' || denorm_tbl(k).seg_name8);
1032: arp_util_tax.debug('seg_name9 : ' || denorm_tbl(k).seg_name9);
1033: arp_util_tax.debug('seg_name10 : ' || denorm_tbl(k).seg_name10);
1034: arp_util_tax.debug('appl_col_name1 : ' || denorm_tbl(k).appl_col_name1);

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

1027: arp_util_tax.debug('seg_name4 : ' || denorm_tbl(k).seg_name4);
1028: arp_util_tax.debug('seg_name5 : ' || denorm_tbl(k).seg_name5);
1029: arp_util_tax.debug('seg_name6 : ' || denorm_tbl(k).seg_name6);
1030: arp_util_tax.debug('seg_name7 : ' || denorm_tbl(k).seg_name7);
1031: arp_util_tax.debug('seg_name8 : ' || denorm_tbl(k).seg_name8);
1032: arp_util_tax.debug('seg_name9 : ' || denorm_tbl(k).seg_name9);
1033: arp_util_tax.debug('seg_name10 : ' || denorm_tbl(k).seg_name10);
1034: arp_util_tax.debug('appl_col_name1 : ' || denorm_tbl(k).appl_col_name1);
1035: arp_util_tax.debug('appl_col_name2 : ' || denorm_tbl(k).appl_col_name2);

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

1028: arp_util_tax.debug('seg_name5 : ' || denorm_tbl(k).seg_name5);
1029: arp_util_tax.debug('seg_name6 : ' || denorm_tbl(k).seg_name6);
1030: arp_util_tax.debug('seg_name7 : ' || denorm_tbl(k).seg_name7);
1031: arp_util_tax.debug('seg_name8 : ' || denorm_tbl(k).seg_name8);
1032: arp_util_tax.debug('seg_name9 : ' || denorm_tbl(k).seg_name9);
1033: arp_util_tax.debug('seg_name10 : ' || denorm_tbl(k).seg_name10);
1034: arp_util_tax.debug('appl_col_name1 : ' || denorm_tbl(k).appl_col_name1);
1035: arp_util_tax.debug('appl_col_name2 : ' || denorm_tbl(k).appl_col_name2);
1036: arp_util_tax.debug('appl_col_name3 : ' || denorm_tbl(k).appl_col_name3);

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

1029: arp_util_tax.debug('seg_name6 : ' || denorm_tbl(k).seg_name6);
1030: arp_util_tax.debug('seg_name7 : ' || denorm_tbl(k).seg_name7);
1031: arp_util_tax.debug('seg_name8 : ' || denorm_tbl(k).seg_name8);
1032: arp_util_tax.debug('seg_name9 : ' || denorm_tbl(k).seg_name9);
1033: arp_util_tax.debug('seg_name10 : ' || denorm_tbl(k).seg_name10);
1034: arp_util_tax.debug('appl_col_name1 : ' || denorm_tbl(k).appl_col_name1);
1035: arp_util_tax.debug('appl_col_name2 : ' || denorm_tbl(k).appl_col_name2);
1036: arp_util_tax.debug('appl_col_name3 : ' || denorm_tbl(k).appl_col_name3);
1037: arp_util_tax.debug('appl_col_name4 : ' || denorm_tbl(k).appl_col_name4);

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

1030: arp_util_tax.debug('seg_name7 : ' || denorm_tbl(k).seg_name7);
1031: arp_util_tax.debug('seg_name8 : ' || denorm_tbl(k).seg_name8);
1032: arp_util_tax.debug('seg_name9 : ' || denorm_tbl(k).seg_name9);
1033: arp_util_tax.debug('seg_name10 : ' || denorm_tbl(k).seg_name10);
1034: arp_util_tax.debug('appl_col_name1 : ' || denorm_tbl(k).appl_col_name1);
1035: arp_util_tax.debug('appl_col_name2 : ' || denorm_tbl(k).appl_col_name2);
1036: arp_util_tax.debug('appl_col_name3 : ' || denorm_tbl(k).appl_col_name3);
1037: arp_util_tax.debug('appl_col_name4 : ' || denorm_tbl(k).appl_col_name4);
1038: arp_util_tax.debug('appl_col_name5 : ' || denorm_tbl(k).appl_col_name5);

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

1031: arp_util_tax.debug('seg_name8 : ' || denorm_tbl(k).seg_name8);
1032: arp_util_tax.debug('seg_name9 : ' || denorm_tbl(k).seg_name9);
1033: arp_util_tax.debug('seg_name10 : ' || denorm_tbl(k).seg_name10);
1034: arp_util_tax.debug('appl_col_name1 : ' || denorm_tbl(k).appl_col_name1);
1035: arp_util_tax.debug('appl_col_name2 : ' || denorm_tbl(k).appl_col_name2);
1036: arp_util_tax.debug('appl_col_name3 : ' || denorm_tbl(k).appl_col_name3);
1037: arp_util_tax.debug('appl_col_name4 : ' || denorm_tbl(k).appl_col_name4);
1038: arp_util_tax.debug('appl_col_name5 : ' || denorm_tbl(k).appl_col_name5);
1039: arp_util_tax.debug('appl_col_name6 : ' || denorm_tbl(k).appl_col_name6);

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

1032: arp_util_tax.debug('seg_name9 : ' || denorm_tbl(k).seg_name9);
1033: arp_util_tax.debug('seg_name10 : ' || denorm_tbl(k).seg_name10);
1034: arp_util_tax.debug('appl_col_name1 : ' || denorm_tbl(k).appl_col_name1);
1035: arp_util_tax.debug('appl_col_name2 : ' || denorm_tbl(k).appl_col_name2);
1036: arp_util_tax.debug('appl_col_name3 : ' || denorm_tbl(k).appl_col_name3);
1037: arp_util_tax.debug('appl_col_name4 : ' || denorm_tbl(k).appl_col_name4);
1038: arp_util_tax.debug('appl_col_name5 : ' || denorm_tbl(k).appl_col_name5);
1039: arp_util_tax.debug('appl_col_name6 : ' || denorm_tbl(k).appl_col_name6);
1040: arp_util_tax.debug('appl_col_name7 : ' || denorm_tbl(k).appl_col_name7);

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

1033: arp_util_tax.debug('seg_name10 : ' || denorm_tbl(k).seg_name10);
1034: arp_util_tax.debug('appl_col_name1 : ' || denorm_tbl(k).appl_col_name1);
1035: arp_util_tax.debug('appl_col_name2 : ' || denorm_tbl(k).appl_col_name2);
1036: arp_util_tax.debug('appl_col_name3 : ' || denorm_tbl(k).appl_col_name3);
1037: arp_util_tax.debug('appl_col_name4 : ' || denorm_tbl(k).appl_col_name4);
1038: arp_util_tax.debug('appl_col_name5 : ' || denorm_tbl(k).appl_col_name5);
1039: arp_util_tax.debug('appl_col_name6 : ' || denorm_tbl(k).appl_col_name6);
1040: arp_util_tax.debug('appl_col_name7 : ' || denorm_tbl(k).appl_col_name7);
1041: arp_util_tax.debug('appl_col_name8 : ' || denorm_tbl(k).appl_col_name8);

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

1034: arp_util_tax.debug('appl_col_name1 : ' || denorm_tbl(k).appl_col_name1);
1035: arp_util_tax.debug('appl_col_name2 : ' || denorm_tbl(k).appl_col_name2);
1036: arp_util_tax.debug('appl_col_name3 : ' || denorm_tbl(k).appl_col_name3);
1037: arp_util_tax.debug('appl_col_name4 : ' || denorm_tbl(k).appl_col_name4);
1038: arp_util_tax.debug('appl_col_name5 : ' || denorm_tbl(k).appl_col_name5);
1039: arp_util_tax.debug('appl_col_name6 : ' || denorm_tbl(k).appl_col_name6);
1040: arp_util_tax.debug('appl_col_name7 : ' || denorm_tbl(k).appl_col_name7);
1041: arp_util_tax.debug('appl_col_name8 : ' || denorm_tbl(k).appl_col_name8);
1042: arp_util_tax.debug('appl_col_name9 : ' || denorm_tbl(k).appl_col_name9);

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

1035: arp_util_tax.debug('appl_col_name2 : ' || denorm_tbl(k).appl_col_name2);
1036: arp_util_tax.debug('appl_col_name3 : ' || denorm_tbl(k).appl_col_name3);
1037: arp_util_tax.debug('appl_col_name4 : ' || denorm_tbl(k).appl_col_name4);
1038: arp_util_tax.debug('appl_col_name5 : ' || denorm_tbl(k).appl_col_name5);
1039: arp_util_tax.debug('appl_col_name6 : ' || denorm_tbl(k).appl_col_name6);
1040: arp_util_tax.debug('appl_col_name7 : ' || denorm_tbl(k).appl_col_name7);
1041: arp_util_tax.debug('appl_col_name8 : ' || denorm_tbl(k).appl_col_name8);
1042: arp_util_tax.debug('appl_col_name9 : ' || denorm_tbl(k).appl_col_name9);
1043: arp_util_tax.debug('appl_col_name10 : ' || denorm_tbl(k).appl_col_name10);

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

1036: arp_util_tax.debug('appl_col_name3 : ' || denorm_tbl(k).appl_col_name3);
1037: arp_util_tax.debug('appl_col_name4 : ' || denorm_tbl(k).appl_col_name4);
1038: arp_util_tax.debug('appl_col_name5 : ' || denorm_tbl(k).appl_col_name5);
1039: arp_util_tax.debug('appl_col_name6 : ' || denorm_tbl(k).appl_col_name6);
1040: arp_util_tax.debug('appl_col_name7 : ' || denorm_tbl(k).appl_col_name7);
1041: arp_util_tax.debug('appl_col_name8 : ' || denorm_tbl(k).appl_col_name8);
1042: arp_util_tax.debug('appl_col_name9 : ' || denorm_tbl(k).appl_col_name9);
1043: arp_util_tax.debug('appl_col_name10 : ' || denorm_tbl(k).appl_col_name10);
1044: arp_util_tax.debug('tax_acct_src_tax : ' || denorm_tbl(k).tax_acct_src_tax);

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

1037: arp_util_tax.debug('appl_col_name4 : ' || denorm_tbl(k).appl_col_name4);
1038: arp_util_tax.debug('appl_col_name5 : ' || denorm_tbl(k).appl_col_name5);
1039: arp_util_tax.debug('appl_col_name6 : ' || denorm_tbl(k).appl_col_name6);
1040: arp_util_tax.debug('appl_col_name7 : ' || denorm_tbl(k).appl_col_name7);
1041: arp_util_tax.debug('appl_col_name8 : ' || denorm_tbl(k).appl_col_name8);
1042: arp_util_tax.debug('appl_col_name9 : ' || denorm_tbl(k).appl_col_name9);
1043: arp_util_tax.debug('appl_col_name10 : ' || denorm_tbl(k).appl_col_name10);
1044: arp_util_tax.debug('tax_acct_src_tax : ' || denorm_tbl(k).tax_acct_src_tax);
1045: arp_util_tax.debug('exmpt_src_tax : ' || denorm_tbl(k).exmpt_src_tax);

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

1038: arp_util_tax.debug('appl_col_name5 : ' || denorm_tbl(k).appl_col_name5);
1039: arp_util_tax.debug('appl_col_name6 : ' || denorm_tbl(k).appl_col_name6);
1040: arp_util_tax.debug('appl_col_name7 : ' || denorm_tbl(k).appl_col_name7);
1041: arp_util_tax.debug('appl_col_name8 : ' || denorm_tbl(k).appl_col_name8);
1042: arp_util_tax.debug('appl_col_name9 : ' || denorm_tbl(k).appl_col_name9);
1043: arp_util_tax.debug('appl_col_name10 : ' || denorm_tbl(k).appl_col_name10);
1044: arp_util_tax.debug('tax_acct_src_tax : ' || denorm_tbl(k).tax_acct_src_tax);
1045: arp_util_tax.debug('exmpt_src_tax : ' || denorm_tbl(k).exmpt_src_tax);
1046: arp_util_tax.debug('tax_acc_src_str : ' || denorm_tbl(k).tax_acc_src_str);

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

1039: arp_util_tax.debug('appl_col_name6 : ' || denorm_tbl(k).appl_col_name6);
1040: arp_util_tax.debug('appl_col_name7 : ' || denorm_tbl(k).appl_col_name7);
1041: arp_util_tax.debug('appl_col_name8 : ' || denorm_tbl(k).appl_col_name8);
1042: arp_util_tax.debug('appl_col_name9 : ' || denorm_tbl(k).appl_col_name9);
1043: arp_util_tax.debug('appl_col_name10 : ' || denorm_tbl(k).appl_col_name10);
1044: arp_util_tax.debug('tax_acct_src_tax : ' || denorm_tbl(k).tax_acct_src_tax);
1045: arp_util_tax.debug('exmpt_src_tax : ' || denorm_tbl(k).exmpt_src_tax);
1046: arp_util_tax.debug('tax_acc_src_str : ' || denorm_tbl(k).tax_acc_src_str);
1047: arp_util_tax.debug('exmpt_src_str : ' || denorm_tbl(k).exmpt_src_str);

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

1040: arp_util_tax.debug('appl_col_name7 : ' || denorm_tbl(k).appl_col_name7);
1041: arp_util_tax.debug('appl_col_name8 : ' || denorm_tbl(k).appl_col_name8);
1042: arp_util_tax.debug('appl_col_name9 : ' || denorm_tbl(k).appl_col_name9);
1043: arp_util_tax.debug('appl_col_name10 : ' || denorm_tbl(k).appl_col_name10);
1044: arp_util_tax.debug('tax_acct_src_tax : ' || denorm_tbl(k).tax_acct_src_tax);
1045: arp_util_tax.debug('exmpt_src_tax : ' || denorm_tbl(k).exmpt_src_tax);
1046: arp_util_tax.debug('tax_acc_src_str : ' || denorm_tbl(k).tax_acc_src_str);
1047: arp_util_tax.debug('exmpt_src_str : ' || denorm_tbl(k).exmpt_src_str);
1048: END LOOP;

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

1041: arp_util_tax.debug('appl_col_name8 : ' || denorm_tbl(k).appl_col_name8);
1042: arp_util_tax.debug('appl_col_name9 : ' || denorm_tbl(k).appl_col_name9);
1043: arp_util_tax.debug('appl_col_name10 : ' || denorm_tbl(k).appl_col_name10);
1044: arp_util_tax.debug('tax_acct_src_tax : ' || denorm_tbl(k).tax_acct_src_tax);
1045: arp_util_tax.debug('exmpt_src_tax : ' || denorm_tbl(k).exmpt_src_tax);
1046: arp_util_tax.debug('tax_acc_src_str : ' || denorm_tbl(k).tax_acc_src_str);
1047: arp_util_tax.debug('exmpt_src_str : ' || denorm_tbl(k).exmpt_src_str);
1048: END LOOP;
1049: arp_util_tax.debug(' ');

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

1042: arp_util_tax.debug('appl_col_name9 : ' || denorm_tbl(k).appl_col_name9);
1043: arp_util_tax.debug('appl_col_name10 : ' || denorm_tbl(k).appl_col_name10);
1044: arp_util_tax.debug('tax_acct_src_tax : ' || denorm_tbl(k).tax_acct_src_tax);
1045: arp_util_tax.debug('exmpt_src_tax : ' || denorm_tbl(k).exmpt_src_tax);
1046: arp_util_tax.debug('tax_acc_src_str : ' || denorm_tbl(k).tax_acc_src_str);
1047: arp_util_tax.debug('exmpt_src_str : ' || denorm_tbl(k).exmpt_src_str);
1048: END LOOP;
1049: arp_util_tax.debug(' ');
1050: IF denorm_err_tbl.count > 0 THEN

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

1043: arp_util_tax.debug('appl_col_name10 : ' || denorm_tbl(k).appl_col_name10);
1044: arp_util_tax.debug('tax_acct_src_tax : ' || denorm_tbl(k).tax_acct_src_tax);
1045: arp_util_tax.debug('exmpt_src_tax : ' || denorm_tbl(k).exmpt_src_tax);
1046: arp_util_tax.debug('tax_acc_src_str : ' || denorm_tbl(k).tax_acc_src_str);
1047: arp_util_tax.debug('exmpt_src_str : ' || denorm_tbl(k).exmpt_src_str);
1048: END LOOP;
1049: arp_util_tax.debug(' ');
1050: IF denorm_err_tbl.count > 0 THEN
1051: arp_util_tax.debug('*** ORGANZATION MERGED RECORDS ***');

Line 1049: arp_util_tax.debug(' ');

1045: arp_util_tax.debug('exmpt_src_tax : ' || denorm_tbl(k).exmpt_src_tax);
1046: arp_util_tax.debug('tax_acc_src_str : ' || denorm_tbl(k).tax_acc_src_str);
1047: arp_util_tax.debug('exmpt_src_str : ' || denorm_tbl(k).exmpt_src_str);
1048: END LOOP;
1049: arp_util_tax.debug(' ');
1050: IF denorm_err_tbl.count > 0 THEN
1051: arp_util_tax.debug('*** ORGANZATION MERGED RECORDS ***');
1052: FOR k in 1..denorm_err_tbl.count LOOP
1053: arp_util_tax.debug(denorm_err_tbl(k).country_code);

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

1047: arp_util_tax.debug('exmpt_src_str : ' || denorm_tbl(k).exmpt_src_str);
1048: END LOOP;
1049: arp_util_tax.debug(' ');
1050: IF denorm_err_tbl.count > 0 THEN
1051: arp_util_tax.debug('*** ORGANZATION MERGED RECORDS ***');
1052: FOR k in 1..denorm_err_tbl.count LOOP
1053: arp_util_tax.debug(denorm_err_tbl(k).country_code);
1054: arp_util_tax.debug(denorm_err_tbl(k).id_flex_num);
1055: arp_util_tax.debug(denorm_err_tbl(k).tax_currency_code);

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

1049: arp_util_tax.debug(' ');
1050: IF denorm_err_tbl.count > 0 THEN
1051: arp_util_tax.debug('*** ORGANZATION MERGED RECORDS ***');
1052: FOR k in 1..denorm_err_tbl.count LOOP
1053: arp_util_tax.debug(denorm_err_tbl(k).country_code);
1054: arp_util_tax.debug(denorm_err_tbl(k).id_flex_num);
1055: arp_util_tax.debug(denorm_err_tbl(k).tax_currency_code);
1056: arp_util_tax.debug(denorm_err_tbl(k).tax_precision);
1057: arp_util_tax.debug(denorm_err_tbl(k).tax_mau);

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

1050: IF denorm_err_tbl.count > 0 THEN
1051: arp_util_tax.debug('*** ORGANZATION MERGED RECORDS ***');
1052: FOR k in 1..denorm_err_tbl.count LOOP
1053: arp_util_tax.debug(denorm_err_tbl(k).country_code);
1054: arp_util_tax.debug(denorm_err_tbl(k).id_flex_num);
1055: arp_util_tax.debug(denorm_err_tbl(k).tax_currency_code);
1056: arp_util_tax.debug(denorm_err_tbl(k).tax_precision);
1057: arp_util_tax.debug(denorm_err_tbl(k).tax_mau);
1058: arp_util_tax.debug(denorm_err_tbl(k).rounding_rule_code);

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

1051: arp_util_tax.debug('*** ORGANZATION MERGED RECORDS ***');
1052: FOR k in 1..denorm_err_tbl.count LOOP
1053: arp_util_tax.debug(denorm_err_tbl(k).country_code);
1054: arp_util_tax.debug(denorm_err_tbl(k).id_flex_num);
1055: arp_util_tax.debug(denorm_err_tbl(k).tax_currency_code);
1056: arp_util_tax.debug(denorm_err_tbl(k).tax_precision);
1057: arp_util_tax.debug(denorm_err_tbl(k).tax_mau);
1058: arp_util_tax.debug(denorm_err_tbl(k).rounding_rule_code);
1059: arp_util_tax.debug(denorm_err_tbl(k).allow_rounding_override);

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

1052: FOR k in 1..denorm_err_tbl.count LOOP
1053: arp_util_tax.debug(denorm_err_tbl(k).country_code);
1054: arp_util_tax.debug(denorm_err_tbl(k).id_flex_num);
1055: arp_util_tax.debug(denorm_err_tbl(k).tax_currency_code);
1056: arp_util_tax.debug(denorm_err_tbl(k).tax_precision);
1057: arp_util_tax.debug(denorm_err_tbl(k).tax_mau);
1058: arp_util_tax.debug(denorm_err_tbl(k).rounding_rule_code);
1059: arp_util_tax.debug(denorm_err_tbl(k).allow_rounding_override);
1060: arp_util_tax.debug(denorm_err_tbl(k).org_id);

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

1053: arp_util_tax.debug(denorm_err_tbl(k).country_code);
1054: arp_util_tax.debug(denorm_err_tbl(k).id_flex_num);
1055: arp_util_tax.debug(denorm_err_tbl(k).tax_currency_code);
1056: arp_util_tax.debug(denorm_err_tbl(k).tax_precision);
1057: arp_util_tax.debug(denorm_err_tbl(k).tax_mau);
1058: arp_util_tax.debug(denorm_err_tbl(k).rounding_rule_code);
1059: arp_util_tax.debug(denorm_err_tbl(k).allow_rounding_override);
1060: arp_util_tax.debug(denorm_err_tbl(k).org_id);
1061: -- arp_util_tax.debug(denorm_tbl(k).tax_account_id); -- Bug 5028254

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

1054: arp_util_tax.debug(denorm_err_tbl(k).id_flex_num);
1055: arp_util_tax.debug(denorm_err_tbl(k).tax_currency_code);
1056: arp_util_tax.debug(denorm_err_tbl(k).tax_precision);
1057: arp_util_tax.debug(denorm_err_tbl(k).tax_mau);
1058: arp_util_tax.debug(denorm_err_tbl(k).rounding_rule_code);
1059: arp_util_tax.debug(denorm_err_tbl(k).allow_rounding_override);
1060: arp_util_tax.debug(denorm_err_tbl(k).org_id);
1061: -- arp_util_tax.debug(denorm_tbl(k).tax_account_id); -- Bug 5028254
1062: END LOOP;

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

1055: arp_util_tax.debug(denorm_err_tbl(k).tax_currency_code);
1056: arp_util_tax.debug(denorm_err_tbl(k).tax_precision);
1057: arp_util_tax.debug(denorm_err_tbl(k).tax_mau);
1058: arp_util_tax.debug(denorm_err_tbl(k).rounding_rule_code);
1059: arp_util_tax.debug(denorm_err_tbl(k).allow_rounding_override);
1060: arp_util_tax.debug(denorm_err_tbl(k).org_id);
1061: -- arp_util_tax.debug(denorm_tbl(k).tax_account_id); -- Bug 5028254
1062: END LOOP;
1063: ELSE

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

1056: arp_util_tax.debug(denorm_err_tbl(k).tax_precision);
1057: arp_util_tax.debug(denorm_err_tbl(k).tax_mau);
1058: arp_util_tax.debug(denorm_err_tbl(k).rounding_rule_code);
1059: arp_util_tax.debug(denorm_err_tbl(k).allow_rounding_override);
1060: arp_util_tax.debug(denorm_err_tbl(k).org_id);
1061: -- arp_util_tax.debug(denorm_tbl(k).tax_account_id); -- Bug 5028254
1062: END LOOP;
1063: ELSE
1064: arp_util_tax.debug('*** NO ORGANZATION MERGED RECORDS ***');

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

1057: arp_util_tax.debug(denorm_err_tbl(k).tax_mau);
1058: arp_util_tax.debug(denorm_err_tbl(k).rounding_rule_code);
1059: arp_util_tax.debug(denorm_err_tbl(k).allow_rounding_override);
1060: arp_util_tax.debug(denorm_err_tbl(k).org_id);
1061: -- arp_util_tax.debug(denorm_tbl(k).tax_account_id); -- Bug 5028254
1062: END LOOP;
1063: ELSE
1064: arp_util_tax.debug('*** NO ORGANZATION MERGED RECORDS ***');
1065: END IF;

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

1060: arp_util_tax.debug(denorm_err_tbl(k).org_id);
1061: -- arp_util_tax.debug(denorm_tbl(k).tax_account_id); -- Bug 5028254
1062: END LOOP;
1063: ELSE
1064: arp_util_tax.debug('*** NO ORGANZATION MERGED RECORDS ***');
1065: END IF;
1066: -- ****** DEBUG ******
1067:
1068: /*SELECT min(start_date)

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

6001: AND zrt.language = avtt.language
6002: AND zrt.source_lang = avtt.source_lang);*/
6003:
6004: IF PG_DEBUG = 'Y' THEN
6005: arp_util_tax.debug('migrate_ar_vat_tax(-)');
6006: END IF;
6007:
6008: EXCEPTION
6009: WHEN OTHERS THEN

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

6007:
6008: EXCEPTION
6009: WHEN OTHERS THEN
6010: IF PG_DEBUG = 'Y' THEN
6011: arp_util_tax.debug('EXCEPTION: migrate_ar_vat_tax ');
6012: arp_util_tax.debug(sqlcode || ' : ' || sqlerrm);
6013: arp_util_tax.debug('migrate_ar_vat_tax(-)');
6014: END IF;
6015: --app_exception.raise_exception;

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

6008: EXCEPTION
6009: WHEN OTHERS THEN
6010: IF PG_DEBUG = 'Y' THEN
6011: arp_util_tax.debug('EXCEPTION: migrate_ar_vat_tax ');
6012: arp_util_tax.debug(sqlcode || ' : ' || sqlerrm);
6013: arp_util_tax.debug('migrate_ar_vat_tax(-)');
6014: END IF;
6015: --app_exception.raise_exception;
6016:

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

6009: WHEN OTHERS THEN
6010: IF PG_DEBUG = 'Y' THEN
6011: arp_util_tax.debug('EXCEPTION: migrate_ar_vat_tax ');
6012: arp_util_tax.debug(sqlcode || ' : ' || sqlerrm);
6013: arp_util_tax.debug('migrate_ar_vat_tax(-)');
6014: END IF;
6015: --app_exception.raise_exception;
6016:
6017: END;

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

6091:
6092: END IF;
6093: EXCEPTION
6094: WHEN NO_DATA_FOUND THEN
6095: arp_util_tax.debug('is_synch_needed.loc_str_id: No data found');
6096: WHEN OTHERS THEN
6097: arp_util_tax.debug('is_synch_needed.loc_str_id: Others');
6098: END;
6099:

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

6093: EXCEPTION
6094: WHEN NO_DATA_FOUND THEN
6095: arp_util_tax.debug('is_synch_needed.loc_str_id: No data found');
6096: WHEN OTHERS THEN
6097: arp_util_tax.debug('is_synch_needed.loc_str_id: Others');
6098: END;
6099:
6100: IF l_location_str_id IS NOT NULL THEN
6101: BEGIN

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

6110: '@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@'
6111: ),'@'),'-999'));
6112: EXCEPTION
6113: WHEN NO_DATA_FOUND THEN
6114: arp_util_tax.debug('is_synch_needed.l_tax_regime_code: No data found');
6115: WHEN OTHERS THEN
6116: arp_util_tax.debug('is_synch_needed.l_tax_regime_code: Others');
6117: END;
6118: IF l_tax_regime_code IS NOT NULL THEN

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

6112: EXCEPTION
6113: WHEN NO_DATA_FOUND THEN
6114: arp_util_tax.debug('is_synch_needed.l_tax_regime_code: No data found');
6115: WHEN OTHERS THEN
6116: arp_util_tax.debug('is_synch_needed.l_tax_regime_code: Others');
6117: END;
6118: IF l_tax_regime_code IS NOT NULL THEN
6119: BEGIN
6120: SELECT ztb.tax

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

6127: AND ztb.tax = 'LOCATION'
6128: AND ztb.tax_regime_code = l_tax_regime_code;
6129: EXCEPTION
6130: WHEN NO_DATA_FOUND THEN
6131: arp_util_tax.debug('is_synch_needed.l_tax: No data found');
6132: WHEN OTHERS THEN
6133: arp_util_tax.debug('is_synch_needed.l_tax: Others');
6134: END;
6135: IF l_tax IS NOT NULL THEN

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

6129: EXCEPTION
6130: WHEN NO_DATA_FOUND THEN
6131: arp_util_tax.debug('is_synch_needed.l_tax: No data found');
6132: WHEN OTHERS THEN
6133: arp_util_tax.debug('is_synch_needed.l_tax: Others');
6134: END;
6135: IF l_tax IS NOT NULL THEN
6136: RETURN FALSE; --Regime exists PLUS tax exists for CO --NO SYNCH--
6137: ELSE

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

6837:
6838: END IF;
6839:
6840:
6841: --arp_util_tax.debug('1:');
6842:
6843: /*
6844: -- LTE handling
6845: INSERT INTO ZX_STATUS_B_TMP

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

6975: AR_SYS_OP.TAX_USE_LOC_EXC_RATE_FLAG
6976: );
6977: */
6978:
6979: --arp_util_tax.debug('2:');
6980:
6981: -- Unused JATW_GOVERNMENT_TAX_TYPE global flexfield atttribute handling
6982: IF L_JATW_USED = 'Y' THEN
6983: IF L_MULTI_ORG_FLAG = 'Y' THEN

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

7287: END IF;
7288: END IF;
7289: --End of JATW_GOVERNMENT_TAX_TYPE lookup code
7290:
7291: arp_util_tax.debug('3:');
7292: /*
7293: INSERT INTO ZX_STATUS_TL
7294: (
7295: TAX_STATUS_ID,

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

8819: and party_type_code='OU')
8820: and record_type_code='MIGRATED';
8821:
8822: EXCEPTION WHEN OTHERS THEN
8823: arp_util_tax.debug('Failed to update zx_taxes_b due to exception in migrate_profile for org:'
8824: ||l_org_id(i)||sqlerrm);
8825: END;
8826:
8827: BEGIN

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

8833: and party_type_code='OU')
8834: and record_type_code='MIGRATED';
8835:
8836: EXCEPTION WHEN OTHERS THEN
8837: arp_util_tax.debug('Failed to update zx_status_b due to exception in migrate_profile for org:'
8838: ||l_org_id(i)||sqlerrm);
8839: END;
8840:
8841: END LOOP; -- end l_org_id.count LOOP

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

8933: IN ('JL.AR.ARXSUVAT.AR_VAT_TAX',
8934: 'JL.BR.ARXSUVAT.Tax Information', -- Bug 4868971
8935: 'JL.CO.ARXSUVAT.AR_VAT_TAX');
8936:
8937: arp_util_tax.debug('sel ar_vat_tax_all_b');
8938:
8939: forall i in 1..lc_rate_code_id.last
8940: update ar_vat_tax_all_b
8941: set tax_regime_code = lc_tax_regime_code(i),

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

8944: where vat_tax_id = lc_rate_code_id(i);
8945: -- YK:9/17/2004: May need limit clause as per performance team's
8946: -- guideline.
8947:
8948: arp_util_tax.debug('upd ar_vat_all_b');
8949:
8950: EXCEPTION
8951: WHEN OTHERS THEN
8952: NULL;

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

9241: RETURN TRUE; -- p_tax_id IS NULL
9242: END IF;
9243: EXCEPTION
9244: WHEN OTHERS THEN
9245: arp_util_tax.debug('Exception: is_update_needed_for_tax');
9246: END;
9247:
9248: /*===========================================================================+
9249: | PROCEDURE

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

10365: EXCEPTION
10366: WHEN no_data_found THEN
10367: NULL;
10368: WHEN others THEN
10369: arp_util_tax.debug('e:pkg_condt:lte_used:'||sqlcode || ' : ' || sqlerrm);
10370: END;*/
10371:
10372: -- Check if JATW is used
10373: BEGIN

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

10378: EXCEPTION
10379: WHEN no_data_found THEN
10380: NULL;
10381: WHEN others THEN
10382: arp_util_tax.debug('e:pkg_const:jatw_used:'||sqlcode || ' : ' || sqlerrm);
10383: END;
10384:
10385: -- Check MIN START DATE
10386: BEGIN

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

10388: INTO L_MIN_START_DATE
10389: FROM ar_vat_tax_all_b;
10390: EXCEPTION
10391: WHEN OTHERS THEN
10392: arp_util_tax.debug('e:pkg_const:l_min_start_date:'||sqlcode || ' : ' || sqlerrm);
10393: END;
10394:
10395:
10396: BEGIN

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

10401:
10402: FND_PROFILE.GET('ORG_ID',L_ORG_ID);
10403:
10404: IF L_ORG_ID IS NULL THEN
10405: arp_util_tax.debug('MO: Operating Units site level profile option value not set , resulted in Null Org Id');
10406: END IF;
10407: ELSE
10408: L_ORG_ID := NULL;
10409: END IF;

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

10410:
10411:
10412: EXCEPTION
10413: WHEN OTHERS THEN
10414: arp_util_tax.debug('Exception in constructor of AR TAX DEFINITION'||sqlerrm);
10415: END;
10416:
10417: BEGIN
10418: MO_GLOBAL.INIT('ZX');

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

10416:
10417: BEGIN
10418: MO_GLOBAL.INIT('ZX');
10419: EXCEPTION WHEN OTHERS THEN
10420: arp_util_tax.debug('Exception in MO_GLOBAL.init');
10421: END;
10422:
10423:
10424: END;