APPS.ZX_MIGRATE_TAX_DEF dependencies on ARP_UTIL_TAX

Line 43: arp_util_tax.debug('Migrate_Ap_Tax_Codes_Setup(+)');

39:
40: PROCEDURE Migrate_Ap_Tax_Codes_Setup is
41: BEGIN
42: IF PG_DEBUG = 'Y' THEN
43: arp_util_tax.debug('Migrate_Ap_Tax_Codes_Setup(+)');
44: END IF;
45: SavePoint Ap_Tax_Setup;
46:
47: BEGIN

Line 48: arp_util_tax.debug('b:Migrate FND LOOKUPS');

44: END IF;
45: SavePoint Ap_Tax_Setup;
46:
47: BEGIN
48: arp_util_tax.debug('b:Migrate FND LOOKUPS');
49: BEGIN
50: migrate_fnd_lookups;
51: EXCEPTION
52: WHEN OTHERS THEN

Line 53: arp_util_tax.debug('Exception encountered in migrate_fnd_lookups:'||sqlerrm);

49: BEGIN
50: migrate_fnd_lookups;
51: EXCEPTION
52: WHEN OTHERS THEN
53: arp_util_tax.debug('Exception encountered in migrate_fnd_lookups:'||sqlerrm);
54: END;
55: arp_util_tax.debug('a:Migrate FND LOOKUPS');
56:
57: --BugFix 3557681

Line 55: arp_util_tax.debug('a:Migrate FND LOOKUPS');

51: EXCEPTION
52: WHEN OTHERS THEN
53: arp_util_tax.debug('Exception encountered in migrate_fnd_lookups:'||sqlerrm);
54: END;
55: arp_util_tax.debug('a:Migrate FND LOOKUPS');
56:
57: --BugFix 3557681
58: arp_util_tax.debug('b:Create Tax Classifications');
59: BEGIN

Line 58: arp_util_tax.debug('b:Create Tax Classifications');

54: END;
55: arp_util_tax.debug('a:Migrate FND LOOKUPS');
56:
57: --BugFix 3557681
58: arp_util_tax.debug('b:Create Tax Classifications');
59: BEGIN
60: Create_Tax_Classifications;
61: EXCEPTION
62: WHEN OTHERS THEN

Line 63: arp_util_tax.debug('Exception encountered in Create Tax Classifications:'||sqlerrm);

59: BEGIN
60: Create_Tax_Classifications;
61: EXCEPTION
62: WHEN OTHERS THEN
63: arp_util_tax.debug('Exception encountered in Create Tax Classifications:'||sqlerrm);
64: END;
65: arp_util_tax.debug('a:Create Tax Classifications');
66:
67: arp_util_tax.debug('b:Migrate Normal Tax Codes');

Line 65: arp_util_tax.debug('a:Create Tax Classifications');

61: EXCEPTION
62: WHEN OTHERS THEN
63: arp_util_tax.debug('Exception encountered in Create Tax Classifications:'||sqlerrm);
64: END;
65: arp_util_tax.debug('a:Create Tax Classifications');
66:
67: arp_util_tax.debug('b:Migrate Normal Tax Codes');
68: BEGIN
69: migrate_normal_tax_codes;

Line 67: arp_util_tax.debug('b:Migrate Normal Tax Codes');

63: arp_util_tax.debug('Exception encountered in Create Tax Classifications:'||sqlerrm);
64: END;
65: arp_util_tax.debug('a:Create Tax Classifications');
66:
67: arp_util_tax.debug('b:Migrate Normal Tax Codes');
68: BEGIN
69: migrate_normal_tax_codes;
70: EXCEPTION
71: WHEN OTHERS THEN

Line 72: arp_util_tax.debug('Exception encountered in migrate_normal_tax_codes:' ||sqlerrm);

68: BEGIN
69: migrate_normal_tax_codes;
70: EXCEPTION
71: WHEN OTHERS THEN
72: arp_util_tax.debug('Exception encountered in migrate_normal_tax_codes:' ||sqlerrm);
73: END;
74:
75: arp_util_tax.debug('a:Migrate Normal Tax Codes');
76:

Line 75: arp_util_tax.debug('a:Migrate Normal Tax Codes');

71: WHEN OTHERS THEN
72: arp_util_tax.debug('Exception encountered in migrate_normal_tax_codes:' ||sqlerrm);
73: END;
74:
75: arp_util_tax.debug('a:Migrate Normal Tax Codes');
76:
77:
78: arp_util_tax.debug('b:Migrate Disabled Tax Codes');
79: BEGIN

Line 78: arp_util_tax.debug('b:Migrate Disabled Tax Codes');

74:
75: arp_util_tax.debug('a:Migrate Normal Tax Codes');
76:
77:
78: arp_util_tax.debug('b:Migrate Disabled Tax Codes');
79: BEGIN
80: migrate_disabled_tax_codes; --Bug Fix 4580573
81: EXCEPTION
82: WHEN OTHERS THEN

Line 83: arp_util_tax.debug('Exception encountered in migrate_disabled_tax_codes:' ||sqlerrm);

79: BEGIN
80: migrate_disabled_tax_codes; --Bug Fix 4580573
81: EXCEPTION
82: WHEN OTHERS THEN
83: arp_util_tax.debug('Exception encountered in migrate_disabled_tax_codes:' ||sqlerrm);
84: END;
85:
86: arp_util_tax.debug('b:Migrate Disabled Tax Codes');
87:

Line 86: arp_util_tax.debug('b:Migrate Disabled Tax Codes');

82: WHEN OTHERS THEN
83: arp_util_tax.debug('Exception encountered in migrate_disabled_tax_codes:' ||sqlerrm);
84: END;
85:
86: arp_util_tax.debug('b:Migrate Disabled Tax Codes');
87:
88: arp_util_tax.debug('b:Migrate Assign Offset Tax Codes');
89: BEGIN
90: migrate_assign_offset_codes;

Line 88: arp_util_tax.debug('b:Migrate Assign Offset Tax Codes');

84: END;
85:
86: arp_util_tax.debug('b:Migrate Disabled Tax Codes');
87:
88: arp_util_tax.debug('b:Migrate Assign Offset Tax Codes');
89: BEGIN
90: migrate_assign_offset_codes;
91: EXCEPTION
92: WHEN OTHERS THEN

Line 93: arp_util_tax.debug('Exception encountered in migrate_assign_offset_codes:' ||sqlerrm);

89: BEGIN
90: migrate_assign_offset_codes;
91: EXCEPTION
92: WHEN OTHERS THEN
93: arp_util_tax.debug('Exception encountered in migrate_assign_offset_codes:' ||sqlerrm);
94: END;
95: arp_util_tax.debug('a:Migrate Assign Offset Tax Codes');
96:
97: arp_util_tax.debug('b:Migrate Un Assign Offset Tax Codes');

Line 95: arp_util_tax.debug('a:Migrate Assign Offset Tax Codes');

91: EXCEPTION
92: WHEN OTHERS THEN
93: arp_util_tax.debug('Exception encountered in migrate_assign_offset_codes:' ||sqlerrm);
94: END;
95: arp_util_tax.debug('a:Migrate Assign Offset Tax Codes');
96:
97: arp_util_tax.debug('b:Migrate Un Assign Offset Tax Codes');
98: BEGIN
99: migrate_unassign_offset_codes;

Line 97: arp_util_tax.debug('b:Migrate Un Assign Offset Tax Codes');

93: arp_util_tax.debug('Exception encountered in migrate_assign_offset_codes:' ||sqlerrm);
94: END;
95: arp_util_tax.debug('a:Migrate Assign Offset Tax Codes');
96:
97: arp_util_tax.debug('b:Migrate Un Assign Offset Tax Codes');
98: BEGIN
99: migrate_unassign_offset_codes;
100: EXCEPTION
101: WHEN OTHERS THEN

Line 102: arp_util_tax.debug('Exception encountered in migrate_unassign_offset_codes:' ||sqlerrm);

98: BEGIN
99: migrate_unassign_offset_codes;
100: EXCEPTION
101: WHEN OTHERS THEN
102: arp_util_tax.debug('Exception encountered in migrate_unassign_offset_codes:' ||sqlerrm);
103: END;
104:
105: arp_util_tax.debug('a:Migrate Un Assign Offset Tax Codes');
106:

Line 105: arp_util_tax.debug('a:Migrate Un Assign Offset Tax Codes');

101: WHEN OTHERS THEN
102: arp_util_tax.debug('Exception encountered in migrate_unassign_offset_codes:' ||sqlerrm);
103: END;
104:
105: arp_util_tax.debug('a:Migrate Un Assign Offset Tax Codes');
106:
107: /* Bug 4710118 : To Ensure that atleast one rate code gets created with default_rate_flag = 'Y' for a particular
108: Combination of regime , tax , status and Content Owner */
109: /* Bug 5199954 To Ensure that atleast one rate code gets created with default_rate_flag = 'Y' for a particular

Line 112: arp_util_tax.debug('b:Stamp Default Rate Flag');

108: Combination of regime , tax , status and Content Owner */
109: /* Bug 5199954 To Ensure that atleast one rate code gets created with default_rate_flag = 'Y' for a particular
110: Combination of regime , tax , status and Content Owner for a recovery rate */
111:
112: arp_util_tax.debug('b:Stamp Default Rate Flag');
113: BEGIN
114: stamp_default_rate_flag;
115: EXCEPTION
116: WHEN OTHERS THEN

Line 117: arp_util_tax.debug('Exception encountered in default rate flag updation logic in rates'||sqlerrm);

113: BEGIN
114: stamp_default_rate_flag;
115: EXCEPTION
116: WHEN OTHERS THEN
117: arp_util_tax.debug('Exception encountered in default rate flag updation logic in rates'||sqlerrm);
118: END;
119:
120: arp_util_tax.debug('b:Create Status');
121: BEGIN

Line 120: arp_util_tax.debug('b:Create Status');

116: WHEN OTHERS THEN
117: arp_util_tax.debug('Exception encountered in default rate flag updation logic in rates'||sqlerrm);
118: END;
119:
120: arp_util_tax.debug('b:Create Status');
121: BEGIN
122: create_zx_statuses;
123: EXCEPTION
124: WHEN OTHERS THEN

Line 125: arp_util_tax.debug('Exception encountered in create_zx_statuses'||sqlerrm);

121: BEGIN
122: create_zx_statuses;
123: EXCEPTION
124: WHEN OTHERS THEN
125: arp_util_tax.debug('Exception encountered in create_zx_statuses'||sqlerrm);
126: END;
127: arp_util_tax.debug('a:Create Status');
128:
129: arp_util_tax.debug('b:Create Taxes');

Line 127: arp_util_tax.debug('a:Create Status');

123: EXCEPTION
124: WHEN OTHERS THEN
125: arp_util_tax.debug('Exception encountered in create_zx_statuses'||sqlerrm);
126: END;
127: arp_util_tax.debug('a:Create Status');
128:
129: arp_util_tax.debug('b:Create Taxes');
130: BEGIN
131: create_zx_taxes;

Line 129: arp_util_tax.debug('b:Create Taxes');

125: arp_util_tax.debug('Exception encountered in create_zx_statuses'||sqlerrm);
126: END;
127: arp_util_tax.debug('a:Create Status');
128:
129: arp_util_tax.debug('b:Create Taxes');
130: BEGIN
131: create_zx_taxes;
132: EXCEPTION
133: WHEN OTHERS THEN

Line 134: arp_util_tax.debug('Exception encountered in create_zx_taxes'||sqlerrm);

130: BEGIN
131: create_zx_taxes;
132: EXCEPTION
133: WHEN OTHERS THEN
134: arp_util_tax.debug('Exception encountered in create_zx_taxes'||sqlerrm);
135: END;
136: arp_util_tax.debug('a:Create Taxes');
137:
138: -- Added for Bug : 4622937 : For Adhoc Recovery Rate Creation .

Line 136: arp_util_tax.debug('a:Create Taxes');

132: EXCEPTION
133: WHEN OTHERS THEN
134: arp_util_tax.debug('Exception encountered in create_zx_taxes'||sqlerrm);
135: END;
136: arp_util_tax.debug('a:Create Taxes');
137:
138: -- Added for Bug : 4622937 : For Adhoc Recovery Rate Creation .
139: arp_util_tax.debug('b:Create_Adhoc_Recovery_Rates');
140: BEGIN

Line 139: arp_util_tax.debug('b:Create_Adhoc_Recovery_Rates');

135: END;
136: arp_util_tax.debug('a:Create Taxes');
137:
138: -- Added for Bug : 4622937 : For Adhoc Recovery Rate Creation .
139: arp_util_tax.debug('b:Create_Adhoc_Recovery_Rates');
140: BEGIN
141: Create_Adhoc_Recovery_Rates;
142: EXCEPTION
143: WHEN OTHERS THEN

Line 144: arp_util_tax.debug('Exception encountered in Create_Adhoc_Recovery_Rates'||sqlerrm);

140: BEGIN
141: Create_Adhoc_Recovery_Rates;
142: EXCEPTION
143: WHEN OTHERS THEN
144: arp_util_tax.debug('Exception encountered in Create_Adhoc_Recovery_Rates'||sqlerrm);
145: END;
146: arp_util_tax.debug('a:Create_Adhoc_Recovery_Rates');
147:
148: arp_util_tax.debug('b:Migrate Recovery Rates Rules');

Line 146: arp_util_tax.debug('a:Create_Adhoc_Recovery_Rates');

142: EXCEPTION
143: WHEN OTHERS THEN
144: arp_util_tax.debug('Exception encountered in Create_Adhoc_Recovery_Rates'||sqlerrm);
145: END;
146: arp_util_tax.debug('a:Create_Adhoc_Recovery_Rates');
147:
148: arp_util_tax.debug('b:Migrate Recovery Rates Rules');
149: BEGIN
150: migrate_recovery_rates_rules;

Line 148: arp_util_tax.debug('b:Migrate Recovery Rates Rules');

144: arp_util_tax.debug('Exception encountered in Create_Adhoc_Recovery_Rates'||sqlerrm);
145: END;
146: arp_util_tax.debug('a:Create_Adhoc_Recovery_Rates');
147:
148: arp_util_tax.debug('b:Migrate Recovery Rates Rules');
149: BEGIN
150: migrate_recovery_rates_rules;
151: EXCEPTION
152: WHEN OTHERS THEN

Line 153: arp_util_tax.debug('Exception encountered in migrate_recovery logic '||sqlerrm);

149: BEGIN
150: migrate_recovery_rates_rules;
151: EXCEPTION
152: WHEN OTHERS THEN
153: arp_util_tax.debug('Exception encountered in migrate_recovery logic '||sqlerrm);
154: END;
155: arp_util_tax.debug('a:Migrate Recovery Rates Rules');
156:
157: arp_util_tax.debug('b:Create Tax Accounts');

Line 155: arp_util_tax.debug('a:Migrate Recovery Rates Rules');

151: EXCEPTION
152: WHEN OTHERS THEN
153: arp_util_tax.debug('Exception encountered in migrate_recovery logic '||sqlerrm);
154: END;
155: arp_util_tax.debug('a:Migrate Recovery Rates Rules');
156:
157: arp_util_tax.debug('b:Create Tax Accounts');
158: BEGIN
159: create_tax_accounts;

Line 157: arp_util_tax.debug('b:Create Tax Accounts');

153: arp_util_tax.debug('Exception encountered in migrate_recovery logic '||sqlerrm);
154: END;
155: arp_util_tax.debug('a:Migrate Recovery Rates Rules');
156:
157: arp_util_tax.debug('b:Create Tax Accounts');
158: BEGIN
159: create_tax_accounts;
160: EXCEPTION
161: WHEN OTHERS THEN

Line 162: arp_util_tax.debug('Exception encountered in create_tax_accounts'||sqlerrm);

158: BEGIN
159: create_tax_accounts;
160: EXCEPTION
161: WHEN OTHERS THEN
162: arp_util_tax.debug('Exception encountered in create_tax_accounts'||sqlerrm);
163: END;
164: arp_util_tax.debug('a:Create Tax Accounts');
165:
166: arp_util_tax.debug('b:Create Templates');

Line 164: arp_util_tax.debug('a:Create Tax Accounts');

160: EXCEPTION
161: WHEN OTHERS THEN
162: arp_util_tax.debug('Exception encountered in create_tax_accounts'||sqlerrm);
163: END;
164: arp_util_tax.debug('a:Create Tax Accounts');
165:
166: arp_util_tax.debug('b:Create Templates');
167: BEGIN
168: create_templates;

Line 166: arp_util_tax.debug('b:Create Templates');

162: arp_util_tax.debug('Exception encountered in create_tax_accounts'||sqlerrm);
163: END;
164: arp_util_tax.debug('a:Create Tax Accounts');
165:
166: arp_util_tax.debug('b:Create Templates');
167: BEGIN
168: create_templates;
169: EXCEPTION
170: WHEN OTHERS THEN

Line 171: arp_util_tax.debug('Exception encountered in create_templates'||sqlerrm);

167: BEGIN
168: create_templates;
169: EXCEPTION
170: WHEN OTHERS THEN
171: arp_util_tax.debug('Exception encountered in create_templates'||sqlerrm);
172: END;
173: arp_util_tax.debug('a:Create Templates');
174:
175: arp_util_tax.debug('b:Create Condition Groups');

Line 173: arp_util_tax.debug('a:Create Templates');

169: EXCEPTION
170: WHEN OTHERS THEN
171: arp_util_tax.debug('Exception encountered in create_templates'||sqlerrm);
172: END;
173: arp_util_tax.debug('a:Create Templates');
174:
175: arp_util_tax.debug('b:Create Condition Groups');
176: BEGIN
177: create_condition_groups;

Line 175: arp_util_tax.debug('b:Create Condition Groups');

171: arp_util_tax.debug('Exception encountered in create_templates'||sqlerrm);
172: END;
173: arp_util_tax.debug('a:Create Templates');
174:
175: arp_util_tax.debug('b:Create Condition Groups');
176: BEGIN
177: create_condition_groups;
178: EXCEPTION
179: WHEN OTHERS THEN

Line 180: arp_util_tax.debug('Exception encountered in create_condition_groups'||sqlerrm);

176: BEGIN
177: create_condition_groups;
178: EXCEPTION
179: WHEN OTHERS THEN
180: arp_util_tax.debug('Exception encountered in create_condition_groups'||sqlerrm);
181: END;
182: arp_util_tax.debug('a:Create Condition Groups');
183:
184: arp_util_tax.debug('b:Create Rules');

Line 182: arp_util_tax.debug('a:Create Condition Groups');

178: EXCEPTION
179: WHEN OTHERS THEN
180: arp_util_tax.debug('Exception encountered in create_condition_groups'||sqlerrm);
181: END;
182: arp_util_tax.debug('a:Create Condition Groups');
183:
184: arp_util_tax.debug('b:Create Rules');
185: BEGIN
186: create_rules;

Line 184: arp_util_tax.debug('b:Create Rules');

180: arp_util_tax.debug('Exception encountered in create_condition_groups'||sqlerrm);
181: END;
182: arp_util_tax.debug('a:Create Condition Groups');
183:
184: arp_util_tax.debug('b:Create Rules');
185: BEGIN
186: create_rules;
187: EXCEPTION
188: WHEN OTHERS THEN

Line 189: arp_util_tax.debug('Exception encountered in create_rules'||sqlerrm);

185: BEGIN
186: create_rules;
187: EXCEPTION
188: WHEN OTHERS THEN
189: arp_util_tax.debug('Exception encountered in create_rules'||sqlerrm);
190: END;
191: arp_util_tax.debug('a:Create Rules');
192:
193: arp_util_tax.debug('b:Migrate Recovery Rates');

Line 191: arp_util_tax.debug('a:Create Rules');

187: EXCEPTION
188: WHEN OTHERS THEN
189: arp_util_tax.debug('Exception encountered in create_rules'||sqlerrm);
190: END;
191: arp_util_tax.debug('a:Create Rules');
192:
193: arp_util_tax.debug('b:Migrate Recovery Rates');
194: BEGIN
195: migrate_recovery_rates; --Bug Fix 553303

Line 193: arp_util_tax.debug('b:Migrate Recovery Rates');

189: arp_util_tax.debug('Exception encountered in create_rules'||sqlerrm);
190: END;
191: arp_util_tax.debug('a:Create Rules');
192:
193: arp_util_tax.debug('b:Migrate Recovery Rates');
194: BEGIN
195: migrate_recovery_rates; --Bug Fix 553303
196: EXCEPTION
197: WHEN OTHERS THEN

Line 198: arp_util_tax.debug('Exception encountered in migrate_recovery logic '||sqlerrm);

194: BEGIN
195: migrate_recovery_rates; --Bug Fix 553303
196: EXCEPTION
197: WHEN OTHERS THEN
198: arp_util_tax.debug('Exception encountered in migrate_recovery logic '||sqlerrm);
199: END;
200: arp_util_tax.debug('a:Migrate Recovery Rates');
201: --Bug 12837833
202: --Tail End Processing

Line 200: arp_util_tax.debug('a:Migrate Recovery Rates');

196: EXCEPTION
197: WHEN OTHERS THEN
198: arp_util_tax.debug('Exception encountered in migrate_recovery logic '||sqlerrm);
199: END;
200: arp_util_tax.debug('a:Migrate Recovery Rates');
201: --Bug 12837833
202: --Tail End Processing
203: BEGIN
204: UPDATE ZX_TAXES_B_TMP TAXES

Line 220: arp_util_tax.debug('Exception encountered in Tail End Processing '||sqlerrm);

216: AND ZX_RATES.CONTENT_OWNER_ID = TAXES.CONTENT_OWNER_ID)
217: AND TAXES.RECORD_TYPE_CODE = 'MIGRATED';
218: EXCEPTION
219: WHEN OTHERS THEN
220: arp_util_tax.debug('Exception encountered in Tail End Processing '||sqlerrm);
221: END;
222: EXCEPTION
223: WHEN OTHERS THEN
224: arp_util_tax.debug('ERROR: '||sqlerrm);

Line 224: arp_util_tax.debug('ERROR: '||sqlerrm);

220: arp_util_tax.debug('Exception encountered in Tail End Processing '||sqlerrm);
221: END;
222: EXCEPTION
223: WHEN OTHERS THEN
224: arp_util_tax.debug('ERROR: '||sqlerrm);
225: END;
226: IF PG_DEBUG = 'Y' THEN
227: arp_util_tax.debug('Migrate_Ap_Tax_Codes_Setup(-)');
228: END IF;

Line 227: arp_util_tax.debug('Migrate_Ap_Tax_Codes_Setup(-)');

223: WHEN OTHERS THEN
224: arp_util_tax.debug('ERROR: '||sqlerrm);
225: END;
226: IF PG_DEBUG = 'Y' THEN
227: arp_util_tax.debug('Migrate_Ap_Tax_Codes_Setup(-)');
228: END IF;
229: EXCEPTION
230: WHEN OTHERS THEN
231: IF PG_DEBUG = 'Y' THEN

Line 232: arp_util_tax.debug('EXCEPTION: Migrate_ap_tax_codes_setup ');

228: END IF;
229: EXCEPTION
230: WHEN OTHERS THEN
231: IF PG_DEBUG = 'Y' THEN
232: arp_util_tax.debug('EXCEPTION: Migrate_ap_tax_codes_setup ');
233: arp_util_tax.debug(sqlerrm);
234: arp_util_tax.debug('Migrate_Ap_Tax_Codes_Setup(-)');
235: END IF;
236: RollBack To Ap_Tax_Setup;

Line 233: arp_util_tax.debug(sqlerrm);

229: EXCEPTION
230: WHEN OTHERS THEN
231: IF PG_DEBUG = 'Y' THEN
232: arp_util_tax.debug('EXCEPTION: Migrate_ap_tax_codes_setup ');
233: arp_util_tax.debug(sqlerrm);
234: arp_util_tax.debug('Migrate_Ap_Tax_Codes_Setup(-)');
235: END IF;
236: RollBack To Ap_Tax_Setup;
237: --app_exception.raise_exception;

Line 234: arp_util_tax.debug('Migrate_Ap_Tax_Codes_Setup(-)');

230: WHEN OTHERS THEN
231: IF PG_DEBUG = 'Y' THEN
232: arp_util_tax.debug('EXCEPTION: Migrate_ap_tax_codes_setup ');
233: arp_util_tax.debug(sqlerrm);
234: arp_util_tax.debug('Migrate_Ap_Tax_Codes_Setup(-)');
235: END IF;
236: RollBack To Ap_Tax_Setup;
237: --app_exception.raise_exception;
238: END migrate_ap_tax_codes_setup;

Line 269: arp_util_tax.debug('Migrate_fnd_lookups(+)');

265: l_cnt PLS_INTEGER := 0;
266:
267: BEGIN
268: IF PG_DEBUG = 'Y' THEN
269: arp_util_tax.debug('Migrate_fnd_lookups(+)');
270: END IF;
271: /* For VAT_TRANSACTION_TYPE Lookup */
272:
273: /*SELECT count(vat_transaction_type)

Line 360: arp_util_tax.debug('EXCEPTION: Migrate_fnd_lookups : JEBE_VAT_TRANS_TYPE');

356: and lookup_code = ap_lookups.lookup_code);
357: EXCEPTION
358: WHEN OTHERS THEN
359: IF PG_DEBUG = 'Y' THEN
360: arp_util_tax.debug('EXCEPTION: Migrate_fnd_lookups : JEBE_VAT_TRANS_TYPE');
361: arp_util_tax.debug(sqlerrm);
362: arp_util_tax.debug('Migrate_fnd_lookups(-)');
363: END IF;
364: END ;

Line 361: arp_util_tax.debug(sqlerrm);

357: EXCEPTION
358: WHEN OTHERS THEN
359: IF PG_DEBUG = 'Y' THEN
360: arp_util_tax.debug('EXCEPTION: Migrate_fnd_lookups : JEBE_VAT_TRANS_TYPE');
361: arp_util_tax.debug(sqlerrm);
362: arp_util_tax.debug('Migrate_fnd_lookups(-)');
363: END IF;
364: END ;
365:

Line 362: arp_util_tax.debug('Migrate_fnd_lookups(-)');

358: WHEN OTHERS THEN
359: IF PG_DEBUG = 'Y' THEN
360: arp_util_tax.debug('EXCEPTION: Migrate_fnd_lookups : JEBE_VAT_TRANS_TYPE');
361: arp_util_tax.debug(sqlerrm);
362: arp_util_tax.debug('Migrate_fnd_lookups(-)');
363: END IF;
364: END ;
365:
366: --END IF;

Line 463: arp_util_tax.debug('Migrate_fnd_lookups(-)');

459:
460: --END IF;
461:
462: IF PG_DEBUG = 'Y' THEN
463: arp_util_tax.debug('Migrate_fnd_lookups(-)');
464: END IF;
465:
466:
467:

Line 471: arp_util_tax.debug('EXCEPTION: Migrate_fnd_lookups ');

467:
468: EXCEPTION
469: WHEN OTHERS THEN
470: IF PG_DEBUG = 'Y' THEN
471: arp_util_tax.debug('EXCEPTION: Migrate_fnd_lookups ');
472: arp_util_tax.debug(sqlerrm);
473: arp_util_tax.debug('Migrate_fnd_lookups(-)');
474: END IF;
475: --app_exception.raise_exception;

Line 472: arp_util_tax.debug(sqlerrm);

468: EXCEPTION
469: WHEN OTHERS THEN
470: IF PG_DEBUG = 'Y' THEN
471: arp_util_tax.debug('EXCEPTION: Migrate_fnd_lookups ');
472: arp_util_tax.debug(sqlerrm);
473: arp_util_tax.debug('Migrate_fnd_lookups(-)');
474: END IF;
475: --app_exception.raise_exception;
476:

Line 473: arp_util_tax.debug('Migrate_fnd_lookups(-)');

469: WHEN OTHERS THEN
470: IF PG_DEBUG = 'Y' THEN
471: arp_util_tax.debug('EXCEPTION: Migrate_fnd_lookups ');
472: arp_util_tax.debug(sqlerrm);
473: arp_util_tax.debug('Migrate_fnd_lookups(-)');
474: END IF;
475: --app_exception.raise_exception;
476:
477: END migrate_fnd_lookups;

Line 503: arp_util_tax.debug('Create_Tax_Classifications(+)');

499:
500: PROCEDURE Create_Tax_Classifications(p_tax_id IN NUMBER DEFAULT NULL) IS
501: BEGIN
502: IF PG_DEBUG = 'Y' THEN
503: arp_util_tax.debug('Create_Tax_Classifications(+)');
504: END IF;
505:
506: /* For AP and AR LookupType */
507:

Line 954: arp_util_tax.debug('Create_Tax_Classifications(-)');

950: AND SOURCE = 'AP'
951: );
952:
953: IF PG_DEBUG = 'Y' THEN
954: arp_util_tax.debug('Create_Tax_Classifications(-)');
955: END IF;
956:
957: EXCEPTION
958: WHEN OTHERS THEN

Line 960: arp_util_tax.debug('EXCEPTION: Migrate_ap_tax_codes_setup ');

956:
957: EXCEPTION
958: WHEN OTHERS THEN
959: IF PG_DEBUG = 'Y' THEN
960: arp_util_tax.debug('EXCEPTION: Migrate_ap_tax_codes_setup ');
961: arp_util_tax.debug(sqlerrm);
962: arp_util_tax.debug('Create_Tax_Classifications(-)');
963: END IF;
964:

Line 961: arp_util_tax.debug(sqlerrm);

957: EXCEPTION
958: WHEN OTHERS THEN
959: IF PG_DEBUG = 'Y' THEN
960: arp_util_tax.debug('EXCEPTION: Migrate_ap_tax_codes_setup ');
961: arp_util_tax.debug(sqlerrm);
962: arp_util_tax.debug('Create_Tax_Classifications(-)');
963: END IF;
964:
965: END Create_Tax_Classifications;

Line 962: arp_util_tax.debug('Create_Tax_Classifications(-)');

958: WHEN OTHERS THEN
959: IF PG_DEBUG = 'Y' THEN
960: arp_util_tax.debug('EXCEPTION: Migrate_ap_tax_codes_setup ');
961: arp_util_tax.debug(sqlerrm);
962: arp_util_tax.debug('Create_Tax_Classifications(-)');
963: END IF;
964:
965: END Create_Tax_Classifications;
966:

Line 1001: arp_util_tax.debug('Migrate_Normal_Tax_Codes(+)');

997: UNION ALL
998: Normal codes with offset and with recovery rates,recovery rules.
999: */
1000: IF PG_DEBUG = 'Y' THEN
1001: arp_util_tax.debug('Migrate_Normal_Tax_Codes(+)');
1002: END IF;
1003:
1004: --BugFix 3605729
1005: IF ID_CLASH = 'Y' THEN

Line 2750: arp_util_tax.debug('Migrate_Normal_Tax_Codes(-)');

2746: where T.TAX_RATE_ID = RATES.TAX_RATE_ID
2747: and T.LANGUAGE = L.LANGUAGE_CODE);
2748:
2749: IF PG_DEBUG = 'Y' THEN
2750: arp_util_tax.debug('Migrate_Normal_Tax_Codes(-)');
2751: END IF;
2752:
2753:
2754: EXCEPTION

Line 2757: arp_util_tax.debug('EXCEPTION: Migrate_normal_tax_codes ');

2753:
2754: EXCEPTION
2755: WHEN OTHERS THEN
2756: IF PG_DEBUG = 'Y' THEN
2757: arp_util_tax.debug('EXCEPTION: Migrate_normal_tax_codes ');
2758: arp_util_tax.debug(sqlerrm);
2759: arp_util_tax.debug('Migrate_Normal_Tax_Codes(-)');
2760: END IF;
2761: --app_exception.raise_exception;

Line 2758: arp_util_tax.debug(sqlerrm);

2754: EXCEPTION
2755: WHEN OTHERS THEN
2756: IF PG_DEBUG = 'Y' THEN
2757: arp_util_tax.debug('EXCEPTION: Migrate_normal_tax_codes ');
2758: arp_util_tax.debug(sqlerrm);
2759: arp_util_tax.debug('Migrate_Normal_Tax_Codes(-)');
2760: END IF;
2761: --app_exception.raise_exception;
2762:

Line 2759: arp_util_tax.debug('Migrate_Normal_Tax_Codes(-)');

2755: WHEN OTHERS THEN
2756: IF PG_DEBUG = 'Y' THEN
2757: arp_util_tax.debug('EXCEPTION: Migrate_normal_tax_codes ');
2758: arp_util_tax.debug(sqlerrm);
2759: arp_util_tax.debug('Migrate_Normal_Tax_Codes(-)');
2760: END IF;
2761: --app_exception.raise_exception;
2762:
2763:

Line 2801: arp_util_tax.debug('Migrate_Assign_Offset_Codes(+)');

2797: PROCEDURE migrate_assign_offset_codes(p_tax_id IN NUMBER DEFAULT NULL) IS
2798: BEGIN
2799:
2800: IF PG_DEBUG = 'Y' THEN
2801: arp_util_tax.debug('Migrate_Assign_Offset_Codes(+)');
2802: END IF;
2803:
2804: --BugFix 3605729
2805: IF ID_CLASH = 'Y' THEN

Line 4112: arp_util_tax.debug('Migrate_Assign_Offset_Codes(-)');

4108: where T.TAX_RATE_ID = RATES.TAX_RATE_ID
4109: and T.LANGUAGE = L.LANGUAGE_CODE);
4110:
4111: IF PG_DEBUG = 'Y' THEN
4112: arp_util_tax.debug('Migrate_Assign_Offset_Codes(-)');
4113: END IF;
4114:
4115:
4116: EXCEPTION

Line 4119: arp_util_tax.debug('EXCEPTION: Migrate_assign_offset_codes ');

4115:
4116: EXCEPTION
4117: WHEN OTHERS THEN
4118: IF PG_DEBUG = 'Y' THEN
4119: arp_util_tax.debug('EXCEPTION: Migrate_assign_offset_codes ');
4120: arp_util_tax.debug(sqlerrm);
4121: arp_util_tax.debug('Migrate_Assign_Offset_Codes(-)');
4122: END IF;
4123: --app_exception.raise_exception;

Line 4120: arp_util_tax.debug(sqlerrm);

4116: EXCEPTION
4117: WHEN OTHERS THEN
4118: IF PG_DEBUG = 'Y' THEN
4119: arp_util_tax.debug('EXCEPTION: Migrate_assign_offset_codes ');
4120: arp_util_tax.debug(sqlerrm);
4121: arp_util_tax.debug('Migrate_Assign_Offset_Codes(-)');
4122: END IF;
4123: --app_exception.raise_exception;
4124:

Line 4121: arp_util_tax.debug('Migrate_Assign_Offset_Codes(-)');

4117: WHEN OTHERS THEN
4118: IF PG_DEBUG = 'Y' THEN
4119: arp_util_tax.debug('EXCEPTION: Migrate_assign_offset_codes ');
4120: arp_util_tax.debug(sqlerrm);
4121: arp_util_tax.debug('Migrate_Assign_Offset_Codes(-)');
4122: END IF;
4123: --app_exception.raise_exception;
4124:
4125: END migrate_assign_offset_codes;

Line 4159: arp_util_tax.debug('Migrate_UnAssign_Offset_Codes(+)');

4155: PROCEDURE migrate_unassign_offset_codes(p_tax_id IN NUMBER DEFAULT NULL) IS
4156: BEGIN
4157:
4158: IF PG_DEBUG = 'Y' THEN
4159: arp_util_tax.debug('Migrate_UnAssign_Offset_Codes(+)');
4160: END IF;
4161:
4162: --BugFix 3605729
4163: IF ID_CLASH = 'Y' THEN

Line 5461: arp_util_tax.debug('Migrate_UnAssign_Offset_Codes(-)');

5457: where T.TAX_RATE_ID = RATES.TAX_RATE_ID
5458: and T.LANGUAGE = L.LANGUAGE_CODE);
5459:
5460: IF PG_DEBUG = 'Y' THEN
5461: arp_util_tax.debug('Migrate_UnAssign_Offset_Codes(-)');
5462: END IF;
5463:
5464:
5465: EXCEPTION

Line 5468: arp_util_tax.debug('EXCEPTION: Migrate_unassign_offset_codes ');

5464:
5465: EXCEPTION
5466: WHEN OTHERS THEN
5467: IF PG_DEBUG = 'Y' THEN
5468: arp_util_tax.debug('EXCEPTION: Migrate_unassign_offset_codes ');
5469: arp_util_tax.debug(sqlerrm);
5470: arp_util_tax.debug('Migrate_UnAssign_Offset_Codes(-)');
5471: END IF;
5472: --app_exception.raise_exception;

Line 5469: arp_util_tax.debug(sqlerrm);

5465: EXCEPTION
5466: WHEN OTHERS THEN
5467: IF PG_DEBUG = 'Y' THEN
5468: arp_util_tax.debug('EXCEPTION: Migrate_unassign_offset_codes ');
5469: arp_util_tax.debug(sqlerrm);
5470: arp_util_tax.debug('Migrate_UnAssign_Offset_Codes(-)');
5471: END IF;
5472: --app_exception.raise_exception;
5473: END migrate_unassign_offset_codes;

Line 5470: arp_util_tax.debug('Migrate_UnAssign_Offset_Codes(-)');

5466: WHEN OTHERS THEN
5467: IF PG_DEBUG = 'Y' THEN
5468: arp_util_tax.debug('EXCEPTION: Migrate_unassign_offset_codes ');
5469: arp_util_tax.debug(sqlerrm);
5470: arp_util_tax.debug('Migrate_UnAssign_Offset_Codes(-)');
5471: END IF;
5472: --app_exception.raise_exception;
5473: END migrate_unassign_offset_codes;
5474:

Line 5507: arp_util_tax.debug('Migrate_Recovery_Rates(+)');

5503: PROCEDURE migrate_recovery_rates(p_tax_id IN NUMBER DEFAULT NULL) IS
5504: BEGIN
5505:
5506: IF PG_DEBUG = 'Y' THEN
5507: arp_util_tax.debug('Migrate_Recovery_Rates(+)');
5508: END IF;
5509:
5510: --For Default Recovery Rates.
5511: BEGIN

Line 5714: arp_util_tax.debug('EXCEPTION: Migrate_recovery_rates - Default Recovery Rates ');

5710: and rates.DEFAULT_REC_RATE_CODE = cursor_rec.DEFAULT_REC_RATE_CODE ;*/
5711: EXCEPTION
5712: WHEN OTHERS THEN
5713: IF PG_DEBUG = 'Y' THEN
5714: arp_util_tax.debug('EXCEPTION: Migrate_recovery_rates - Default Recovery Rates ');
5715: arp_util_tax.debug(cursor_rec.CONTENT_OWNER_ID||'-'||cursor_rec.TAX_REGIME_CODE||'-'||cursor_rec.TAX||'-'||cursor_rec.CONTENT_OWNER_ID||'-'||cursor_rec.DEFAULT_REC_RATE_CODE||'-'||sqlerrm);
5716: END IF;
5717: END;
5718: end loop;

Line 5715: arp_util_tax.debug(cursor_rec.CONTENT_OWNER_ID||'-'||cursor_rec.TAX_REGIME_CODE||'-'||cursor_rec.TAX||'-'||cursor_rec.CONTENT_OWNER_ID||'-'||cursor_rec.DEFAULT_REC_RATE_CODE||'-'||sqlerrm);

5711: EXCEPTION
5712: WHEN OTHERS THEN
5713: IF PG_DEBUG = 'Y' THEN
5714: arp_util_tax.debug('EXCEPTION: Migrate_recovery_rates - Default Recovery Rates ');
5715: arp_util_tax.debug(cursor_rec.CONTENT_OWNER_ID||'-'||cursor_rec.TAX_REGIME_CODE||'-'||cursor_rec.TAX||'-'||cursor_rec.CONTENT_OWNER_ID||'-'||cursor_rec.DEFAULT_REC_RATE_CODE||'-'||sqlerrm);
5716: END IF;
5717: END;
5718: end loop;
5719: end;

Line 5768: arp_util_tax.debug('Migrate_Recovery_Rates(-)');

5764: NULL;
5765: END;
5766:
5767: IF PG_DEBUG = 'Y' THEN
5768: arp_util_tax.debug('Migrate_Recovery_Rates(-)');
5769: END IF;
5770:
5771: EXCEPTION
5772: WHEN OTHERS THEN

Line 5774: arp_util_tax.debug('EXCEPTION: Migrate_recovery_rates ');

5770:
5771: EXCEPTION
5772: WHEN OTHERS THEN
5773: IF PG_DEBUG = 'Y' THEN
5774: arp_util_tax.debug('EXCEPTION: Migrate_recovery_rates ');
5775: arp_util_tax.debug(sqlerrm);
5776: arp_util_tax.debug('Migrate_Recovery_Rates(-)');
5777: END IF;
5778: --app_exception.raise_exception;

Line 5775: arp_util_tax.debug(sqlerrm);

5771: EXCEPTION
5772: WHEN OTHERS THEN
5773: IF PG_DEBUG = 'Y' THEN
5774: arp_util_tax.debug('EXCEPTION: Migrate_recovery_rates ');
5775: arp_util_tax.debug(sqlerrm);
5776: arp_util_tax.debug('Migrate_Recovery_Rates(-)');
5777: END IF;
5778: --app_exception.raise_exception;
5779: END migrate_recovery_rates;

Line 5776: arp_util_tax.debug('Migrate_Recovery_Rates(-)');

5772: WHEN OTHERS THEN
5773: IF PG_DEBUG = 'Y' THEN
5774: arp_util_tax.debug('EXCEPTION: Migrate_recovery_rates ');
5775: arp_util_tax.debug(sqlerrm);
5776: arp_util_tax.debug('Migrate_Recovery_Rates(-)');
5777: END IF;
5778: --app_exception.raise_exception;
5779: END migrate_recovery_rates;
5780:

Line 5811: arp_util_tax.debug('Migrate_Recovery_Rates_Rules(+)');

5807: PROCEDURE migrate_recovery_rates_rules IS
5808: BEGIN
5809:
5810: IF PG_DEBUG = 'Y' THEN
5811: arp_util_tax.debug('Migrate_Recovery_Rates_Rules(+)');
5812: END IF;
5813:
5814: --For Tax Recovery Rules associated Recovery Rates.
5815: BEGIN

Line 5966: arp_util_tax.debug('Migrate_Recovery_Rates_Rules(-)');

5962: null;
5963: end;
5964:
5965: IF PG_DEBUG = 'Y' THEN
5966: arp_util_tax.debug('Migrate_Recovery_Rates_Rules(-)');
5967: END IF;
5968:
5969: EXCEPTION
5970: WHEN OTHERS THEN

Line 5972: arp_util_tax.debug('EXCEPTION: Migrate_recovery_rates_Rules ');

5968:
5969: EXCEPTION
5970: WHEN OTHERS THEN
5971: IF PG_DEBUG = 'Y' THEN
5972: arp_util_tax.debug('EXCEPTION: Migrate_recovery_rates_Rules ');
5973: arp_util_tax.debug(sqlerrm);
5974: arp_util_tax.debug('Migrate_Recovery_Rates_Rules(-)');
5975: END IF;
5976: --app_exception.raise_exception;

Line 5973: arp_util_tax.debug(sqlerrm);

5969: EXCEPTION
5970: WHEN OTHERS THEN
5971: IF PG_DEBUG = 'Y' THEN
5972: arp_util_tax.debug('EXCEPTION: Migrate_recovery_rates_Rules ');
5973: arp_util_tax.debug(sqlerrm);
5974: arp_util_tax.debug('Migrate_Recovery_Rates_Rules(-)');
5975: END IF;
5976: --app_exception.raise_exception;
5977: END migrate_recovery_rates_rules;

Line 5974: arp_util_tax.debug('Migrate_Recovery_Rates_Rules(-)');

5970: WHEN OTHERS THEN
5971: IF PG_DEBUG = 'Y' THEN
5972: arp_util_tax.debug('EXCEPTION: Migrate_recovery_rates_Rules ');
5973: arp_util_tax.debug(sqlerrm);
5974: arp_util_tax.debug('Migrate_Recovery_Rates_Rules(-)');
5975: END IF;
5976: --app_exception.raise_exception;
5977: END migrate_recovery_rates_rules;
5978:

Line 6006: arp_util_tax.debug('Create_Adhoc_Revocery_Rates(+)');

6002: PROCEDURE Create_Adhoc_Recovery_Rates IS
6003: BEGIN
6004:
6005: IF PG_DEBUG = 'Y' THEN
6006: arp_util_tax.debug('Create_Adhoc_Revocery_Rates(+)');
6007: END IF;
6008:
6009: -- For adhoc Recovery Rate creation.
6010: BEGIN

Line 6139: arp_util_tax.debug('EXCEPTION: Create_Adhoc_Recovery_Rates-insert into ZX_RATES_B ');

6135: ) );
6136: EXCEPTION
6137: WHEN OTHERS THEN
6138: IF PG_DEBUG = 'Y' THEN
6139: arp_util_tax.debug('EXCEPTION: Create_Adhoc_Recovery_Rates-insert into ZX_RATES_B ');
6140: arp_util_tax.debug(sqlerrm);
6141: END IF;
6142: END;
6143:

Line 6140: arp_util_tax.debug(sqlerrm);

6136: EXCEPTION
6137: WHEN OTHERS THEN
6138: IF PG_DEBUG = 'Y' THEN
6139: arp_util_tax.debug('EXCEPTION: Create_Adhoc_Recovery_Rates-insert into ZX_RATES_B ');
6140: arp_util_tax.debug(sqlerrm);
6141: END IF;
6142: END;
6143:
6144: -- inserting into ZX_RATES_TL

Line 6184: arp_util_tax.debug('Create_Adhoc_Revocery_Rates(-)');

6180: where T.TAX_RATE_ID = RATES.TAX_RATE_ID
6181: and T.LANGUAGE = L.LANGUAGE_CODE);
6182:
6183: IF PG_DEBUG = 'Y' THEN
6184: arp_util_tax.debug('Create_Adhoc_Revocery_Rates(-)');
6185: END IF;
6186:
6187: EXCEPTION
6188: WHEN OTHERS THEN

Line 6190: arp_util_tax.debug('EXCEPTION: Create_Adhoc_Recovery_Rates ');

6186:
6187: EXCEPTION
6188: WHEN OTHERS THEN
6189: IF PG_DEBUG = 'Y' THEN
6190: arp_util_tax.debug('EXCEPTION: Create_Adhoc_Recovery_Rates ');
6191: arp_util_tax.debug(sqlerrm);
6192: arp_util_tax.debug('Create_Adhoc_Recovery_Rates(-)');
6193: END IF;
6194:

Line 6191: arp_util_tax.debug(sqlerrm);

6187: EXCEPTION
6188: WHEN OTHERS THEN
6189: IF PG_DEBUG = 'Y' THEN
6190: arp_util_tax.debug('EXCEPTION: Create_Adhoc_Recovery_Rates ');
6191: arp_util_tax.debug(sqlerrm);
6192: arp_util_tax.debug('Create_Adhoc_Recovery_Rates(-)');
6193: END IF;
6194:
6195: END Create_Adhoc_Recovery_Rates;

Line 6192: arp_util_tax.debug('Create_Adhoc_Recovery_Rates(-)');

6188: WHEN OTHERS THEN
6189: IF PG_DEBUG = 'Y' THEN
6190: arp_util_tax.debug('EXCEPTION: Create_Adhoc_Recovery_Rates ');
6191: arp_util_tax.debug(sqlerrm);
6192: arp_util_tax.debug('Create_Adhoc_Recovery_Rates(-)');
6193: END IF;
6194:
6195: END Create_Adhoc_Recovery_Rates;
6196:

Line 6227: arp_util_tax.debug('create_zx_statuses (+)');

6223: NumRec Number(10);
6224: BEGIN
6225:
6226: IF PG_DEBUG = 'Y' THEN
6227: arp_util_tax.debug('create_zx_statuses (+)');
6228: END IF;
6229:
6230: BEGIN
6231:

Line 6348: arp_util_tax.debug('Statuses For Unused JATW_GOVERNMENT_TAX_TYPE.. ');

6344: NULL;
6345: END;
6346:
6347: IF PG_DEBUG = 'Y' THEN
6348: arp_util_tax.debug('Statuses For Unused JATW_GOVERNMENT_TAX_TYPE.. ');
6349: END IF;
6350:
6351: BEGIN
6352: NumRec := 0;

Line 6361: arp_util_tax.debug('EXCEPTION: ' || sqlerrm);

6357: WHERE global_attribute_category = 'JA.TW.APXTADTC.TAX_CODES'
6358: and global_attribute1 is not null;
6359: EXCEPTION
6360: WHEN OTHERS THEN
6361: arp_util_tax.debug('EXCEPTION: ' || sqlerrm);
6362: END;
6363:
6364: IF NumRec > 0 THEN
6365: IF L_MULTI_ORG_FLAG = 'Y'

Line 6744: arp_util_tax.debug('create_zx_statuses (-)');

6740: NULL;
6741: END;
6742:
6743: IF PG_DEBUG = 'Y' THEN
6744: arp_util_tax.debug('create_zx_statuses (-)');
6745: END IF;
6746:
6747:
6748: EXCEPTION

Line 6751: arp_util_tax.debug('EXCEPTION: Create_zx_statuses ');

6747:
6748: EXCEPTION
6749: WHEN OTHERS THEN
6750: IF PG_DEBUG = 'Y' THEN
6751: arp_util_tax.debug('EXCEPTION: Create_zx_statuses ');
6752: arp_util_tax.debug(sqlerrm);
6753: arp_util_tax.debug('create_zx_statuses (-)');
6754: END IF;
6755: --app_exception.raise_exception;

Line 6752: arp_util_tax.debug(sqlerrm);

6748: EXCEPTION
6749: WHEN OTHERS THEN
6750: IF PG_DEBUG = 'Y' THEN
6751: arp_util_tax.debug('EXCEPTION: Create_zx_statuses ');
6752: arp_util_tax.debug(sqlerrm);
6753: arp_util_tax.debug('create_zx_statuses (-)');
6754: END IF;
6755: --app_exception.raise_exception;
6756: END create_zx_statuses;

Line 6753: arp_util_tax.debug('create_zx_statuses (-)');

6749: WHEN OTHERS THEN
6750: IF PG_DEBUG = 'Y' THEN
6751: arp_util_tax.debug('EXCEPTION: Create_zx_statuses ');
6752: arp_util_tax.debug(sqlerrm);
6753: arp_util_tax.debug('create_zx_statuses (-)');
6754: END IF;
6755: --app_exception.raise_exception;
6756: END create_zx_statuses;
6757:

Line 6788: arp_util_tax.debug('create_zx_taxes(+)');

6784: PROCEDURE create_zx_taxes(p_tax_id IN NUMBER DEFAULT NULL) IS
6785: BEGIN
6786:
6787: IF PG_DEBUG = 'Y' THEN
6788: arp_util_tax.debug('create_zx_taxes(+)');
6789: END IF;
6790: BEGIN
6791:
6792: IF L_MULTI_ORG_FLAG = 'Y'

Line 8738: arp_util_tax.debug('create_zx_taxes(-)');

8734: NULL;
8735: END;
8736:
8737: IF PG_DEBUG = 'Y' THEN
8738: arp_util_tax.debug('create_zx_taxes(-)');
8739: END IF;
8740:
8741:
8742: EXCEPTION

Line 8745: arp_util_tax.debug('EXCEPTION: Create_zx_taxes ');

8741:
8742: EXCEPTION
8743: WHEN OTHERS THEN
8744: IF PG_DEBUG = 'Y' THEN
8745: arp_util_tax.debug('EXCEPTION: Create_zx_taxes ');
8746: arp_util_tax.debug(sqlerrm);
8747: arp_util_tax.debug('create_zx_taxes(-)');
8748: END IF;
8749: --app_exception.raise_exception;

Line 8746: arp_util_tax.debug(sqlerrm);

8742: EXCEPTION
8743: WHEN OTHERS THEN
8744: IF PG_DEBUG = 'Y' THEN
8745: arp_util_tax.debug('EXCEPTION: Create_zx_taxes ');
8746: arp_util_tax.debug(sqlerrm);
8747: arp_util_tax.debug('create_zx_taxes(-)');
8748: END IF;
8749: --app_exception.raise_exception;
8750: END create_zx_taxes;

Line 8747: arp_util_tax.debug('create_zx_taxes(-)');

8743: WHEN OTHERS THEN
8744: IF PG_DEBUG = 'Y' THEN
8745: arp_util_tax.debug('EXCEPTION: Create_zx_taxes ');
8746: arp_util_tax.debug(sqlerrm);
8747: arp_util_tax.debug('create_zx_taxes(-)');
8748: END IF;
8749: --app_exception.raise_exception;
8750: END create_zx_taxes;
8751:

Line 8780: arp_util_tax.debug('create_templates(+)');

8776: PROCEDURE create_templates IS
8777: BEGIN
8778:
8779: IF PG_DEBUG = 'Y' THEN
8780: arp_util_tax.debug('create_templates(+)');
8781: END IF;
8782:
8783: INSERT INTO ZX_DET_FACTOR_TEMPL_B
8784: (

Line 8951: arp_util_tax.debug('create_templates(-)');

8947: )
8948: );
8949:
8950: IF PG_DEBUG = 'Y' THEN
8951: arp_util_tax.debug('create_templates(-)');
8952: END IF;
8953:
8954:
8955: EXCEPTION

Line 8958: arp_util_tax.debug('EXCEPTION: Create_zx_templates ');

8954:
8955: EXCEPTION
8956: WHEN OTHERS THEN
8957: IF PG_DEBUG = 'Y' THEN
8958: arp_util_tax.debug('EXCEPTION: Create_zx_templates ');
8959: arp_util_tax.debug(sqlerrm);
8960: arp_util_tax.debug('create_templates(-)');
8961: END IF;
8962: --app_exception.raise_exception;

Line 8959: arp_util_tax.debug(sqlerrm);

8955: EXCEPTION
8956: WHEN OTHERS THEN
8957: IF PG_DEBUG = 'Y' THEN
8958: arp_util_tax.debug('EXCEPTION: Create_zx_templates ');
8959: arp_util_tax.debug(sqlerrm);
8960: arp_util_tax.debug('create_templates(-)');
8961: END IF;
8962: --app_exception.raise_exception;
8963: END create_templates;

Line 8960: arp_util_tax.debug('create_templates(-)');

8956: WHEN OTHERS THEN
8957: IF PG_DEBUG = 'Y' THEN
8958: arp_util_tax.debug('EXCEPTION: Create_zx_templates ');
8959: arp_util_tax.debug(sqlerrm);
8960: arp_util_tax.debug('create_templates(-)');
8961: END IF;
8962: --app_exception.raise_exception;
8963: END create_templates;
8964:

Line 8994: arp_util_tax.debug('create_condition_groups(+)');

8990: PROCEDURE create_condition_groups(p_rate_id IN NUMBER DEFAULT NULL) IS
8991: BEGIN
8992:
8993: IF PG_DEBUG = 'Y' THEN
8994: arp_util_tax.debug('create_condition_groups(+)');
8995: END IF;
8996:
8997: INSERT INTO ZX_conditions
8998: (

Line 9703: arp_util_tax.debug('create_condition_groups(-)');

9699: where T.CONDITION_GROUP_ID = B.CONDITION_GROUP_ID
9700: and T.LANGUAGE = L.LANGUAGE_CODE);
9701:
9702: IF PG_DEBUG = 'Y' THEN
9703: arp_util_tax.debug('create_condition_groups(-)');
9704: END IF;
9705:
9706: EXCEPTION
9707: WHEN OTHERS THEN

Line 9709: arp_util_tax.debug('EXCEPTION: Create_condition_groups ');

9705:
9706: EXCEPTION
9707: WHEN OTHERS THEN
9708: IF PG_DEBUG = 'Y' THEN
9709: arp_util_tax.debug('EXCEPTION: Create_condition_groups ');
9710: arp_util_tax.debug(sqlerrm);
9711: arp_util_tax.debug('create_condition_groups(-)');
9712: END IF;
9713: --app_exception.raise_exception;

Line 9710: arp_util_tax.debug(sqlerrm);

9706: EXCEPTION
9707: WHEN OTHERS THEN
9708: IF PG_DEBUG = 'Y' THEN
9709: arp_util_tax.debug('EXCEPTION: Create_condition_groups ');
9710: arp_util_tax.debug(sqlerrm);
9711: arp_util_tax.debug('create_condition_groups(-)');
9712: END IF;
9713: --app_exception.raise_exception;
9714: END create_condition_groups;

Line 9711: arp_util_tax.debug('create_condition_groups(-)');

9707: WHEN OTHERS THEN
9708: IF PG_DEBUG = 'Y' THEN
9709: arp_util_tax.debug('EXCEPTION: Create_condition_groups ');
9710: arp_util_tax.debug(sqlerrm);
9711: arp_util_tax.debug('create_condition_groups(-)');
9712: END IF;
9713: --app_exception.raise_exception;
9714: END create_condition_groups;
9715:

Line 9744: arp_util_tax.debug('create_rules(+)');

9740: PROCEDURE create_rules(p_tax_id IN NUMBER DEFAULT NULL) IS
9741: BEGIN
9742:
9743: IF PG_DEBUG = 'Y' THEN
9744: arp_util_tax.debug('create_rules(+)');
9745: END IF;
9746:
9747: IF L_MULTI_ORG_FLAG = 'Y'
9748: THEN

Line 10341: arp_util_tax.debug('create_rules(-)');

10337: );
10338:
10339: END IF;
10340: IF PG_DEBUG = 'Y' THEN
10341: arp_util_tax.debug('create_rules(-)');
10342: END IF;
10343:
10344: EXCEPTION
10345: WHEN OTHERS THEN

Line 10347: arp_util_tax.debug('EXCEPTION: Create_rules ');

10343:
10344: EXCEPTION
10345: WHEN OTHERS THEN
10346: IF PG_DEBUG = 'Y' THEN
10347: arp_util_tax.debug('EXCEPTION: Create_rules ');
10348: arp_util_tax.debug(sqlerrm);
10349: arp_util_tax.debug('create_rules(-)');
10350: END IF;
10351: --app_exception.raise_exception;

Line 10348: arp_util_tax.debug(sqlerrm);

10344: EXCEPTION
10345: WHEN OTHERS THEN
10346: IF PG_DEBUG = 'Y' THEN
10347: arp_util_tax.debug('EXCEPTION: Create_rules ');
10348: arp_util_tax.debug(sqlerrm);
10349: arp_util_tax.debug('create_rules(-)');
10350: END IF;
10351: --app_exception.raise_exception;
10352: END create_rules;

Line 10349: arp_util_tax.debug('create_rules(-)');

10345: WHEN OTHERS THEN
10346: IF PG_DEBUG = 'Y' THEN
10347: arp_util_tax.debug('EXCEPTION: Create_rules ');
10348: arp_util_tax.debug(sqlerrm);
10349: arp_util_tax.debug('create_rules(-)');
10350: END IF;
10351: --app_exception.raise_exception;
10352: END create_rules;
10353:

Line 10448: arp_util_tax.debug('Create Tax Accounts(+)');

10444: v_current_ac_id ZX_ACCOUNTS.TAX_ACCOUNT_CCID%TYPE;
10445:
10446:
10447: BEGIN
10448: arp_util_tax.debug('Create Tax Accounts(+)');
10449:
10450: v_max_ac_count := 0;
10451: v_current_ac_count := 0;
10452: v_count := 0;

Line 10645: arp_util_tax.debug('Create Tax Accounts(-)');

10641: WHERE accounts.TAX_ACCOUNT_ENTITY_CODE = 'TAXES' and
10642: accounts.TAX_ACCOUNT_ENTITY_ID = pg_max_tax_id_tab(j)
10643: )
10644: );
10645: arp_util_tax.debug('Create Tax Accounts(-)');
10646:
10647: END ;
10648:
10649: /*===========================================================================+

Line 10743: arp_util_tax.debug('Migrate_Disabled_Tax_Codes');

10739:
10740:
10741: BEGIN
10742: IF PG_DEBUG = 'Y' THEN
10743: arp_util_tax.debug('Migrate_Disabled_Tax_Codes');
10744: END IF;
10745:
10746: BEGIN
10747: SELECT sysdate-999999 into l_min_start_date from dual;

Line 10760: arp_util_tax.debug('Failed to open the tax_id_csr in migrate_disabled_tax_codes');

10756: FETCH tax_id_csr
10757: BULK COLLECT INTO tax_id_tab;
10758:
10759: EXCEPTION WHEN OTHERS THEN
10760: arp_util_tax.debug('Failed to open the tax_id_csr in migrate_disabled_tax_codes');
10761: END;
10762:
10763:
10764:

Line 11623: arp_util_tax.debug('Encountered error in the ID clash insert for disabled tax codes'||sqlerrm);

11619: where source_id = nvl(p_tax_id,codes.tax_id)
11620: ) ;
11621: END IF;
11622: EXCEPTION WHEN OTHERS THEN
11623: arp_util_tax.debug('Encountered error in the ID clash insert for disabled tax codes'||sqlerrm);
11624: END ;
11625: END IF;
11626:
11627:

Line 12486: arp_util_tax.debug('Caught an error in the non id clash portion for the disabled tax codes'||sqlerrm);

12482:
12483: END IF;
12484:
12485: EXCEPTION WHEN OTHERS THEN
12486: arp_util_tax.debug('Caught an error in the non id clash portion for the disabled tax codes'||sqlerrm);
12487: END;
12488:
12489: END LOOP;
12490:

Line 12920: arp_util_tax.debug('Caught an error in the id clash portion for the disabled tax codes

12916: AND not exists (select 1 from zx_rates_b
12917: where source_id = nvl(p_tax_id,codes.tax_id)
12918: ) ;
12919: EXCEPTION WHEN OTHERS THEN
12920: arp_util_tax.debug('Caught an error in the id clash portion for the disabled tax codes
12921: with no date overlap'||sqlerrm);
12922: END;
12923: ELSE
12924: BEGIN

Line 13345: arp_util_tax.debug('Caught an error in the id clash portion for the disabled tax codes

13341: AND not exists (select 1 from zx_rates_b
13342: where source_id = nvl(p_tax_id,codes.tax_id)
13343: ) ;
13344: EXCEPTION WHEN OTHERS THEN
13345: arp_util_tax.debug('Caught an error in the id clash portion for the disabled tax codes
13346: with no date overlap'||sqlerrm);
13347: END;
13348:
13349:

Line 14211: arp_util_tax.debug('Caught an error in the non id clash portion for the disabled tax codes

14207:
14208: END IF;
14209:
14210: EXCEPTION WHEN OTHERS THEN
14211: arp_util_tax.debug('Caught an error in the non id clash portion for the disabled tax codes
14212: with no date overlap'||sqlerrm);
14213: END;
14214:
14215:

Line 14258: arp_util_tax.debug('Migrate_Normal_Tax_Codes(-)');

14254: where T.TAX_RATE_ID = RATES.TAX_RATE_ID
14255: and T.LANGUAGE = L.LANGUAGE_CODE);
14256:
14257: IF PG_DEBUG = 'Y' THEN
14258: arp_util_tax.debug('Migrate_Normal_Tax_Codes(-)');
14259: END IF;
14260:
14261:
14262: EXCEPTION

Line 14265: arp_util_tax.debug('EXCEPTION: Migrate_disabled_tax_codes ');

14261:
14262: EXCEPTION
14263: WHEN OTHERS THEN
14264: IF PG_DEBUG = 'Y' THEN
14265: arp_util_tax.debug('EXCEPTION: Migrate_disabled_tax_codes ');
14266: arp_util_tax.debug(sqlerrm);
14267: arp_util_tax.debug('Migrate_disabled_Tax_Codes(-)');
14268: END IF;
14269: --app_exception.raise_exception;

Line 14266: arp_util_tax.debug(sqlerrm);

14262: EXCEPTION
14263: WHEN OTHERS THEN
14264: IF PG_DEBUG = 'Y' THEN
14265: arp_util_tax.debug('EXCEPTION: Migrate_disabled_tax_codes ');
14266: arp_util_tax.debug(sqlerrm);
14267: arp_util_tax.debug('Migrate_disabled_Tax_Codes(-)');
14268: END IF;
14269: --app_exception.raise_exception;
14270:

Line 14267: arp_util_tax.debug('Migrate_disabled_Tax_Codes(-)');

14263: WHEN OTHERS THEN
14264: IF PG_DEBUG = 'Y' THEN
14265: arp_util_tax.debug('EXCEPTION: Migrate_disabled_tax_codes ');
14266: arp_util_tax.debug(sqlerrm);
14267: arp_util_tax.debug('Migrate_disabled_Tax_Codes(-)');
14268: END IF;
14269: --app_exception.raise_exception;
14270:
14271:

Line 14375: arp_util_tax.debug('No data found exception encountered for tax definition in constructor :'||sqlerrm);

14371: ar_vat_tax_all_b
14372: where tax_id = vat_tax_id);
14373: EXCEPTION
14374: WHEN no_data_found THEN
14375: arp_util_tax.debug('No data found exception encountered for tax definition in constructor :'||sqlerrm);
14376:
14377: WHEN others THEN
14378: arp_util_tax.debug('Exception in Constructor for AP tax definition :'||sqlerrm);
14379: END;

Line 14378: arp_util_tax.debug('Exception in Constructor for AP tax definition :'||sqlerrm);

14374: WHEN no_data_found THEN
14375: arp_util_tax.debug('No data found exception encountered for tax definition in constructor :'||sqlerrm);
14376:
14377: WHEN others THEN
14378: arp_util_tax.debug('Exception in Constructor for AP tax definition :'||sqlerrm);
14379: END;
14380:
14381: BEGIN
14382:

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

14387:
14388: FND_PROFILE.GET('ORG_ID',L_ORG_ID);
14389:
14390: IF L_ORG_ID IS NULL THEN
14391: arp_util_tax.debug('MO: Operating Units site level profile option value not set , resulted in Null Org Id');
14392: END IF;
14393: ELSE
14394: L_ORG_ID := NULL;
14395: END IF;

Line 14399: arp_util_tax.debug('No data found exception encountered for tax definition in constructor :'||sqlerrm);

14395: END IF;
14396:
14397: EXCEPTION
14398: WHEN no_data_found THEN
14399: arp_util_tax.debug('No data found exception encountered for tax definition in constructor :'||sqlerrm);
14400:
14401: WHEN others THEN
14402: arp_util_tax.debug('Exception in Constructor for AP tax definition :'||sqlerrm);
14403: END;

Line 14402: arp_util_tax.debug('Exception in Constructor for AP tax definition :'||sqlerrm);

14398: WHEN no_data_found THEN
14399: arp_util_tax.debug('No data found exception encountered for tax definition in constructor :'||sqlerrm);
14400:
14401: WHEN others THEN
14402: arp_util_tax.debug('Exception in Constructor for AP tax definition :'||sqlerrm);
14403: END;
14404: BEGIN
14405: MO_GLOBAL.INIT('ZX');
14406: EXCEPTION WHEN OTHERS THEN

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

14403: END;
14404: BEGIN
14405: MO_GLOBAL.INIT('ZX');
14406: EXCEPTION WHEN OTHERS THEN
14407: arp_util_tax.debug('Exception in MO_GLOBAL.init');
14408: END;
14409:
14410:
14411: