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_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 WHEN OTHERS THEN
52: arp_util_tax.debug('Exception encountered in migrate_fnd_lookups:'||sqlerrm);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

78: EXCEPTION WHEN OTHERS THEN
79: arp_util_tax.debug('Exception encountered in migrate_disabled_tax_codes:' ||sqlerrm);
80: END;
81:
82: arp_util_tax.debug('b:Migrate Disabled Tax Codes');
83:
84: arp_util_tax.debug('b:Migrate Assign Offset Tax Codes');
85: BEGIN
86: migrate_assign_offset_codes;

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

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

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

84: arp_util_tax.debug('b:Migrate Assign Offset Tax Codes');
85: BEGIN
86: migrate_assign_offset_codes;
87: EXCEPTION WHEN OTHERS THEN
88: arp_util_tax.debug('Exception encountered in migrate_assign_offset_codes:' ||sqlerrm);
89: END;
90: arp_util_tax.debug('a:Migrate Assign Offset Tax Codes');
91:
92: arp_util_tax.debug('b:Migrate Un Assign Offset Tax Codes');

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

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

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

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

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

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

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

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

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

102: Combination of regime , tax , status and Content Owner */
103: /* Bug 5199954 To Ensure that atleast one rate code gets created with default_rate_flag = 'Y' for a particular
104: Combination of regime , tax , status and Content Owner for a recovery rate */
105:
106: arp_util_tax.debug('b:Stamp Default Rate Flag');
107: BEGIN
108: stamp_default_rate_flag;
109: EXCEPTION WHEN OTHERS THEN
110: arp_util_tax.debug('Exception encountered in default rate flag updation logic in rates'||sqlerrm);

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

106: arp_util_tax.debug('b:Stamp Default Rate Flag');
107: BEGIN
108: stamp_default_rate_flag;
109: EXCEPTION WHEN OTHERS THEN
110: arp_util_tax.debug('Exception encountered in default rate flag updation logic in rates'||sqlerrm);
111: END;
112:
113: arp_util_tax.debug('b:Create Status');
114: BEGIN

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

109: EXCEPTION WHEN OTHERS THEN
110: arp_util_tax.debug('Exception encountered in default rate flag updation logic in rates'||sqlerrm);
111: END;
112:
113: arp_util_tax.debug('b:Create Status');
114: BEGIN
115: create_zx_statuses;
116: EXCEPTION WHEN OTHERS THEN
117: arp_util_tax.debug('Exception encountered in create_zx_statuses'||sqlerrm);

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

113: arp_util_tax.debug('b:Create Status');
114: BEGIN
115: create_zx_statuses;
116: EXCEPTION WHEN OTHERS THEN
117: arp_util_tax.debug('Exception encountered in create_zx_statuses'||sqlerrm);
118: END;
119:
120:
121: arp_util_tax.debug('a:Create Status');

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

117: arp_util_tax.debug('Exception encountered in create_zx_statuses'||sqlerrm);
118: END;
119:
120:
121: arp_util_tax.debug('a:Create Status');
122:
123:
124: arp_util_tax.debug('b:Create Taxes');
125: BEGIN

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

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

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

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

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

128: arp_util_tax.debug('Exception encountered in create_zx_taxes'||sqlerrm);
129: END;
130:
131:
132: arp_util_tax.debug('a:Create Taxes');
133:
134: -- Added for Bug : 4622937 : For Adhoc Recovery Rate Creation .
135: arp_util_tax.debug('b:Create_Adhoc_Recovery_Rates');
136: BEGIN

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

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

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

135: arp_util_tax.debug('b:Create_Adhoc_Recovery_Rates');
136: BEGIN
137: Create_Adhoc_Recovery_Rates;
138: EXCEPTION WHEN OTHERS THEN
139: arp_util_tax.debug('Exception encountered in Create_Adhoc_Recovery_Rates'||sqlerrm);
140: END;
141:
142: arp_util_tax.debug('a:Create_Adhoc_Recovery_Rates');
143: arp_util_tax.debug('b:Migrate Recovery Rates Rules');

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

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

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

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

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

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

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

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

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

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

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

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

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

154: EXCEPTION WHEN OTHERS THEN
155: arp_util_tax.debug('Exception encountered in create_tax_accounts'||sqlerrm);
156: END;
157:
158: arp_util_tax.debug('a:Create Tax Accounts');
159:
160: arp_util_tax.debug('b:Create Templates');
161: BEGIN
162: create_templates;

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

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

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

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

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

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

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

165: END;
166:
167: arp_util_tax.debug('a:Create Templates');
168:
169: arp_util_tax.debug('b:Create Condition Groups');
170:
171: BEGIN
172: create_condition_groups;
173: EXCEPTION WHEN OTHERS THEN

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

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

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

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

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

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

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

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

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

182: EXCEPTION WHEN OTHERS THEN
183: arp_util_tax.debug('Exception encountered in create_condition_groups'||sqlerrm);
184: END;
185:
186: arp_util_tax.debug('a:Create Rules');
187:
188: arp_util_tax.debug('b:Migrate Recovery Rates');
189: BEGIN
190: migrate_recovery_rates; --Bug Fix 553303

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

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

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

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

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

190: migrate_recovery_rates; --Bug Fix 553303
191: EXCEPTION WHEN OTHERS THEN
192: arp_util_tax.debug('Exception encountered in migrate_recovery logic '||sqlerrm);
193: END;
194: arp_util_tax.debug('a:Migrate Recovery Rates');
195:
196: EXCEPTION
197: WHEN OTHERS THEN
198: arp_util_tax.debug('ERROR: '||sqlerrm);

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

194: arp_util_tax.debug('a:Migrate Recovery Rates');
195:
196: EXCEPTION
197: WHEN OTHERS THEN
198: arp_util_tax.debug('ERROR: '||sqlerrm);
199: END;
200:
201:
202: IF PG_DEBUG = 'Y' THEN

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

199: END;
200:
201:
202: IF PG_DEBUG = 'Y' THEN
203: arp_util_tax.debug('Migrate_Ap_Tax_Codes_Setup(-)');
204: END IF;
205: EXCEPTION
206: WHEN OTHERS THEN
207: IF PG_DEBUG = 'Y' THEN

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

204: END IF;
205: EXCEPTION
206: WHEN OTHERS THEN
207: IF PG_DEBUG = 'Y' THEN
208: arp_util_tax.debug('EXCEPTION: Migrate_ap_tax_codes_setup ');
209: arp_util_tax.debug(sqlerrm);
210: arp_util_tax.debug('Migrate_Ap_Tax_Codes_Setup(-)');
211: END IF;
212: RollBack To Ap_Tax_Setup;

Line 209: arp_util_tax.debug(sqlerrm);

205: EXCEPTION
206: WHEN OTHERS THEN
207: IF PG_DEBUG = 'Y' THEN
208: arp_util_tax.debug('EXCEPTION: Migrate_ap_tax_codes_setup ');
209: arp_util_tax.debug(sqlerrm);
210: arp_util_tax.debug('Migrate_Ap_Tax_Codes_Setup(-)');
211: END IF;
212: RollBack To Ap_Tax_Setup;
213: --app_exception.raise_exception;

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

206: WHEN OTHERS THEN
207: IF PG_DEBUG = 'Y' THEN
208: arp_util_tax.debug('EXCEPTION: Migrate_ap_tax_codes_setup ');
209: arp_util_tax.debug(sqlerrm);
210: arp_util_tax.debug('Migrate_Ap_Tax_Codes_Setup(-)');
211: END IF;
212: RollBack To Ap_Tax_Setup;
213: --app_exception.raise_exception;
214: END migrate_ap_tax_codes_setup;

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

241: l_cnt PLS_INTEGER := 0;
242:
243: BEGIN
244: IF PG_DEBUG = 'Y' THEN
245: arp_util_tax.debug('Migrate_fnd_lookups(+)');
246: END IF;
247: /* For VAT_TRANSACTION_TYPE Lookup */
248:
249: /*SELECT count(vat_transaction_type)

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

332: and lookup_code = ap_lookups.lookup_code);
333: EXCEPTION
334: WHEN OTHERS THEN
335: IF PG_DEBUG = 'Y' THEN
336: arp_util_tax.debug('EXCEPTION: Migrate_fnd_lookups : JEBE_VAT_TRANS_TYPE');
337: arp_util_tax.debug(sqlerrm);
338: arp_util_tax.debug('Migrate_fnd_lookups(-)');
339: END IF;
340: END ;

Line 337: arp_util_tax.debug(sqlerrm);

333: EXCEPTION
334: WHEN OTHERS THEN
335: IF PG_DEBUG = 'Y' THEN
336: arp_util_tax.debug('EXCEPTION: Migrate_fnd_lookups : JEBE_VAT_TRANS_TYPE');
337: arp_util_tax.debug(sqlerrm);
338: arp_util_tax.debug('Migrate_fnd_lookups(-)');
339: END IF;
340: END ;
341:

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

334: WHEN OTHERS THEN
335: IF PG_DEBUG = 'Y' THEN
336: arp_util_tax.debug('EXCEPTION: Migrate_fnd_lookups : JEBE_VAT_TRANS_TYPE');
337: arp_util_tax.debug(sqlerrm);
338: arp_util_tax.debug('Migrate_fnd_lookups(-)');
339: END IF;
340: END ;
341:
342: --END IF;

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

435:
436: --END IF;
437:
438: IF PG_DEBUG = 'Y' THEN
439: arp_util_tax.debug('Migrate_fnd_lookups(-)');
440: END IF;
441:
442:
443:

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

443:
444: EXCEPTION
445: WHEN OTHERS THEN
446: IF PG_DEBUG = 'Y' THEN
447: arp_util_tax.debug('EXCEPTION: Migrate_fnd_lookups ');
448: arp_util_tax.debug(sqlerrm);
449: arp_util_tax.debug('Migrate_fnd_lookups(-)');
450: END IF;
451: --app_exception.raise_exception;

Line 448: arp_util_tax.debug(sqlerrm);

444: EXCEPTION
445: WHEN OTHERS THEN
446: IF PG_DEBUG = 'Y' THEN
447: arp_util_tax.debug('EXCEPTION: Migrate_fnd_lookups ');
448: arp_util_tax.debug(sqlerrm);
449: arp_util_tax.debug('Migrate_fnd_lookups(-)');
450: END IF;
451: --app_exception.raise_exception;
452:

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

445: WHEN OTHERS THEN
446: IF PG_DEBUG = 'Y' THEN
447: arp_util_tax.debug('EXCEPTION: Migrate_fnd_lookups ');
448: arp_util_tax.debug(sqlerrm);
449: arp_util_tax.debug('Migrate_fnd_lookups(-)');
450: END IF;
451: --app_exception.raise_exception;
452:
453: END migrate_fnd_lookups;

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

475:
476: PROCEDURE Create_Tax_Classifications(p_tax_id IN NUMBER DEFAULT NULL) IS
477: BEGIN
478: IF PG_DEBUG = 'Y' THEN
479: arp_util_tax.debug('Create_Tax_Classifications(+)');
480: END IF;
481:
482: /* For AP and AR LookupType */
483:

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

931: AND SOURCE = 'AP'
932: );
933:
934: IF PG_DEBUG = 'Y' THEN
935: arp_util_tax.debug('Create_Tax_Classifications(-)');
936: END IF;
937:
938: EXCEPTION
939: WHEN OTHERS THEN

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

937:
938: EXCEPTION
939: WHEN OTHERS THEN
940: IF PG_DEBUG = 'Y' THEN
941: arp_util_tax.debug('EXCEPTION: Migrate_ap_tax_codes_setup ');
942: arp_util_tax.debug(sqlerrm);
943: arp_util_tax.debug('Create_Tax_Classifications(-)');
944: END IF;
945:

Line 942: arp_util_tax.debug(sqlerrm);

938: EXCEPTION
939: WHEN OTHERS THEN
940: IF PG_DEBUG = 'Y' THEN
941: arp_util_tax.debug('EXCEPTION: Migrate_ap_tax_codes_setup ');
942: arp_util_tax.debug(sqlerrm);
943: arp_util_tax.debug('Create_Tax_Classifications(-)');
944: END IF;
945:
946: END Create_Tax_Classifications;

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

939: WHEN OTHERS THEN
940: IF PG_DEBUG = 'Y' THEN
941: arp_util_tax.debug('EXCEPTION: Migrate_ap_tax_codes_setup ');
942: arp_util_tax.debug(sqlerrm);
943: arp_util_tax.debug('Create_Tax_Classifications(-)');
944: END IF;
945:
946: END Create_Tax_Classifications;
947:

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

978: UNION ALL
979: Normal codes with offset and with recovery rates,recovery rules.
980: */
981: IF PG_DEBUG = 'Y' THEN
982: arp_util_tax.debug('Migrate_Normal_Tax_Codes(+)');
983: END IF;
984:
985: --BugFix 3605729
986: IF ID_CLASH = 'Y' THEN

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

2732: where T.TAX_RATE_ID = RATES.TAX_RATE_ID
2733: and T.LANGUAGE = L.LANGUAGE_CODE);
2734:
2735: IF PG_DEBUG = 'Y' THEN
2736: arp_util_tax.debug('Migrate_Normal_Tax_Codes(-)');
2737: END IF;
2738:
2739:
2740: EXCEPTION

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

2739:
2740: EXCEPTION
2741: WHEN OTHERS THEN
2742: IF PG_DEBUG = 'Y' THEN
2743: arp_util_tax.debug('EXCEPTION: Migrate_normal_tax_codes ');
2744: arp_util_tax.debug(sqlerrm);
2745: arp_util_tax.debug('Migrate_Normal_Tax_Codes(-)');
2746: END IF;
2747: --app_exception.raise_exception;

Line 2744: arp_util_tax.debug(sqlerrm);

2740: EXCEPTION
2741: WHEN OTHERS THEN
2742: IF PG_DEBUG = 'Y' THEN
2743: arp_util_tax.debug('EXCEPTION: Migrate_normal_tax_codes ');
2744: arp_util_tax.debug(sqlerrm);
2745: arp_util_tax.debug('Migrate_Normal_Tax_Codes(-)');
2746: END IF;
2747: --app_exception.raise_exception;
2748:

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

2741: WHEN OTHERS THEN
2742: IF PG_DEBUG = 'Y' THEN
2743: arp_util_tax.debug('EXCEPTION: Migrate_normal_tax_codes ');
2744: arp_util_tax.debug(sqlerrm);
2745: arp_util_tax.debug('Migrate_Normal_Tax_Codes(-)');
2746: END IF;
2747: --app_exception.raise_exception;
2748:
2749:

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

2783: PROCEDURE migrate_assign_offset_codes(p_tax_id IN NUMBER DEFAULT NULL) IS
2784: BEGIN
2785:
2786: IF PG_DEBUG = 'Y' THEN
2787: arp_util_tax.debug('Migrate_Assign_Offset_Codes(+)');
2788: END IF;
2789:
2790: --BugFix 3605729
2791: IF ID_CLASH = 'Y' THEN

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

4086: where T.TAX_RATE_ID = RATES.TAX_RATE_ID
4087: and T.LANGUAGE = L.LANGUAGE_CODE);
4088:
4089: IF PG_DEBUG = 'Y' THEN
4090: arp_util_tax.debug('Migrate_Assign_Offset_Codes(-)');
4091: END IF;
4092:
4093:
4094: EXCEPTION

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

4093:
4094: EXCEPTION
4095: WHEN OTHERS THEN
4096: IF PG_DEBUG = 'Y' THEN
4097: arp_util_tax.debug('EXCEPTION: Migrate_assign_offset_codes ');
4098: arp_util_tax.debug(sqlerrm);
4099: arp_util_tax.debug('Migrate_Assign_Offset_Codes(-)');
4100: END IF;
4101: --app_exception.raise_exception;

Line 4098: arp_util_tax.debug(sqlerrm);

4094: EXCEPTION
4095: WHEN OTHERS THEN
4096: IF PG_DEBUG = 'Y' THEN
4097: arp_util_tax.debug('EXCEPTION: Migrate_assign_offset_codes ');
4098: arp_util_tax.debug(sqlerrm);
4099: arp_util_tax.debug('Migrate_Assign_Offset_Codes(-)');
4100: END IF;
4101: --app_exception.raise_exception;
4102:

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

4095: WHEN OTHERS THEN
4096: IF PG_DEBUG = 'Y' THEN
4097: arp_util_tax.debug('EXCEPTION: Migrate_assign_offset_codes ');
4098: arp_util_tax.debug(sqlerrm);
4099: arp_util_tax.debug('Migrate_Assign_Offset_Codes(-)');
4100: END IF;
4101: --app_exception.raise_exception;
4102:
4103: END migrate_assign_offset_codes;

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

4133: PROCEDURE migrate_unassign_offset_codes(p_tax_id IN NUMBER DEFAULT NULL) IS
4134: BEGIN
4135:
4136: IF PG_DEBUG = 'Y' THEN
4137: arp_util_tax.debug('Migrate_UnAssign_Offset_Codes(+)');
4138: END IF;
4139:
4140: --BugFix 3605729
4141: IF ID_CLASH = 'Y' THEN

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

5427: where T.TAX_RATE_ID = RATES.TAX_RATE_ID
5428: and T.LANGUAGE = L.LANGUAGE_CODE);
5429:
5430: IF PG_DEBUG = 'Y' THEN
5431: arp_util_tax.debug('Migrate_UnAssign_Offset_Codes(-)');
5432: END IF;
5433:
5434:
5435: EXCEPTION

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

5434:
5435: EXCEPTION
5436: WHEN OTHERS THEN
5437: IF PG_DEBUG = 'Y' THEN
5438: arp_util_tax.debug('EXCEPTION: Migrate_unassign_offset_codes ');
5439: arp_util_tax.debug(sqlerrm);
5440: arp_util_tax.debug('Migrate_UnAssign_Offset_Codes(-)');
5441: END IF;
5442: --app_exception.raise_exception;

Line 5439: arp_util_tax.debug(sqlerrm);

5435: EXCEPTION
5436: WHEN OTHERS THEN
5437: IF PG_DEBUG = 'Y' THEN
5438: arp_util_tax.debug('EXCEPTION: Migrate_unassign_offset_codes ');
5439: arp_util_tax.debug(sqlerrm);
5440: arp_util_tax.debug('Migrate_UnAssign_Offset_Codes(-)');
5441: END IF;
5442: --app_exception.raise_exception;
5443: END migrate_unassign_offset_codes;

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

5436: WHEN OTHERS THEN
5437: IF PG_DEBUG = 'Y' THEN
5438: arp_util_tax.debug('EXCEPTION: Migrate_unassign_offset_codes ');
5439: arp_util_tax.debug(sqlerrm);
5440: arp_util_tax.debug('Migrate_UnAssign_Offset_Codes(-)');
5441: END IF;
5442: --app_exception.raise_exception;
5443: END migrate_unassign_offset_codes;
5444:

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

5473: PROCEDURE migrate_recovery_rates(p_tax_id IN NUMBER DEFAULT NULL) IS
5474: BEGIN
5475:
5476: IF PG_DEBUG = 'Y' THEN
5477: arp_util_tax.debug('Migrate_Recovery_Rates(+)');
5478: END IF;
5479:
5480: --For Default Recovery Rates.
5481: BEGIN

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

5679: and rates.DEFAULT_REC_RATE_CODE = cursor_rec.DEFAULT_REC_RATE_CODE ;*/
5680: EXCEPTION
5681: WHEN OTHERS THEN
5682: IF PG_DEBUG = 'Y' THEN
5683: arp_util_tax.debug('EXCEPTION: Migrate_recovery_rates - Default Recovery Rates ');
5684: 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);
5685: END IF;
5686: END;
5687: end loop;

Line 5684: 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);

5680: EXCEPTION
5681: WHEN OTHERS THEN
5682: IF PG_DEBUG = 'Y' THEN
5683: arp_util_tax.debug('EXCEPTION: Migrate_recovery_rates - Default Recovery Rates ');
5684: 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);
5685: END IF;
5686: END;
5687: end loop;
5688: end;

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

5733: NULL;
5734: END;
5735:
5736: IF PG_DEBUG = 'Y' THEN
5737: arp_util_tax.debug('Migrate_Recovery_Rates(-)');
5738: END IF;
5739:
5740: EXCEPTION
5741: WHEN OTHERS THEN

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

5739:
5740: EXCEPTION
5741: WHEN OTHERS THEN
5742: IF PG_DEBUG = 'Y' THEN
5743: arp_util_tax.debug('EXCEPTION: Migrate_recovery_rates ');
5744: arp_util_tax.debug(sqlerrm);
5745: arp_util_tax.debug('Migrate_Recovery_Rates(-)');
5746: END IF;
5747: --app_exception.raise_exception;

Line 5744: arp_util_tax.debug(sqlerrm);

5740: EXCEPTION
5741: WHEN OTHERS THEN
5742: IF PG_DEBUG = 'Y' THEN
5743: arp_util_tax.debug('EXCEPTION: Migrate_recovery_rates ');
5744: arp_util_tax.debug(sqlerrm);
5745: arp_util_tax.debug('Migrate_Recovery_Rates(-)');
5746: END IF;
5747: --app_exception.raise_exception;
5748: END migrate_recovery_rates;

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

5741: WHEN OTHERS THEN
5742: IF PG_DEBUG = 'Y' THEN
5743: arp_util_tax.debug('EXCEPTION: Migrate_recovery_rates ');
5744: arp_util_tax.debug(sqlerrm);
5745: arp_util_tax.debug('Migrate_Recovery_Rates(-)');
5746: END IF;
5747: --app_exception.raise_exception;
5748: END migrate_recovery_rates;
5749:

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

5776: PROCEDURE migrate_recovery_rates_rules IS
5777: BEGIN
5778:
5779: IF PG_DEBUG = 'Y' THEN
5780: arp_util_tax.debug('Migrate_Recovery_Rates_Rules(+)');
5781: END IF;
5782:
5783: --For Tax Recovery Rules associated Recovery Rates.
5784: BEGIN

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

5931: null;
5932: end;
5933:
5934: IF PG_DEBUG = 'Y' THEN
5935: arp_util_tax.debug('Migrate_Recovery_Rates_Rules(-)');
5936: END IF;
5937:
5938: EXCEPTION
5939: WHEN OTHERS THEN

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

5937:
5938: EXCEPTION
5939: WHEN OTHERS THEN
5940: IF PG_DEBUG = 'Y' THEN
5941: arp_util_tax.debug('EXCEPTION: Migrate_recovery_rates_Rules ');
5942: arp_util_tax.debug(sqlerrm);
5943: arp_util_tax.debug('Migrate_Recovery_Rates_Rules(-)');
5944: END IF;
5945: --app_exception.raise_exception;

Line 5942: arp_util_tax.debug(sqlerrm);

5938: EXCEPTION
5939: WHEN OTHERS THEN
5940: IF PG_DEBUG = 'Y' THEN
5941: arp_util_tax.debug('EXCEPTION: Migrate_recovery_rates_Rules ');
5942: arp_util_tax.debug(sqlerrm);
5943: arp_util_tax.debug('Migrate_Recovery_Rates_Rules(-)');
5944: END IF;
5945: --app_exception.raise_exception;
5946: END migrate_recovery_rates_rules;

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

5939: WHEN OTHERS THEN
5940: IF PG_DEBUG = 'Y' THEN
5941: arp_util_tax.debug('EXCEPTION: Migrate_recovery_rates_Rules ');
5942: arp_util_tax.debug(sqlerrm);
5943: arp_util_tax.debug('Migrate_Recovery_Rates_Rules(-)');
5944: END IF;
5945: --app_exception.raise_exception;
5946: END migrate_recovery_rates_rules;
5947:

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

5971: PROCEDURE Create_Adhoc_Recovery_Rates IS
5972: BEGIN
5973:
5974: IF PG_DEBUG = 'Y' THEN
5975: arp_util_tax.debug('Create_Adhoc_Revocery_Rates(+)');
5976: END IF;
5977:
5978: -- For adhoc Recovery Rate creation.
5979: BEGIN

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

6104: ) );
6105: EXCEPTION
6106: WHEN OTHERS THEN
6107: IF PG_DEBUG = 'Y' THEN
6108: arp_util_tax.debug('EXCEPTION: Create_Adhoc_Recovery_Rates-insert into ZX_RATES_B ');
6109: arp_util_tax.debug(sqlerrm);
6110: END IF;
6111: END;
6112:

Line 6109: arp_util_tax.debug(sqlerrm);

6105: EXCEPTION
6106: WHEN OTHERS THEN
6107: IF PG_DEBUG = 'Y' THEN
6108: arp_util_tax.debug('EXCEPTION: Create_Adhoc_Recovery_Rates-insert into ZX_RATES_B ');
6109: arp_util_tax.debug(sqlerrm);
6110: END IF;
6111: END;
6112:
6113: -- inserting into ZX_RATES_TL

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

6149: where T.TAX_RATE_ID = RATES.TAX_RATE_ID
6150: and T.LANGUAGE = L.LANGUAGE_CODE);
6151:
6152: IF PG_DEBUG = 'Y' THEN
6153: arp_util_tax.debug('Create_Adhoc_Revocery_Rates(-)');
6154: END IF;
6155:
6156: EXCEPTION
6157: WHEN OTHERS THEN

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

6155:
6156: EXCEPTION
6157: WHEN OTHERS THEN
6158: IF PG_DEBUG = 'Y' THEN
6159: arp_util_tax.debug('EXCEPTION: Create_Adhoc_Recovery_Rates ');
6160: arp_util_tax.debug(sqlerrm);
6161: arp_util_tax.debug('Create_Adhoc_Recovery_Rates(-)');
6162: END IF;
6163:

Line 6160: arp_util_tax.debug(sqlerrm);

6156: EXCEPTION
6157: WHEN OTHERS THEN
6158: IF PG_DEBUG = 'Y' THEN
6159: arp_util_tax.debug('EXCEPTION: Create_Adhoc_Recovery_Rates ');
6160: arp_util_tax.debug(sqlerrm);
6161: arp_util_tax.debug('Create_Adhoc_Recovery_Rates(-)');
6162: END IF;
6163:
6164: END Create_Adhoc_Recovery_Rates;

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

6157: WHEN OTHERS THEN
6158: IF PG_DEBUG = 'Y' THEN
6159: arp_util_tax.debug('EXCEPTION: Create_Adhoc_Recovery_Rates ');
6160: arp_util_tax.debug(sqlerrm);
6161: arp_util_tax.debug('Create_Adhoc_Recovery_Rates(-)');
6162: END IF;
6163:
6164: END Create_Adhoc_Recovery_Rates;
6165:

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

6192: NumRec Number(10);
6193: BEGIN
6194:
6195: IF PG_DEBUG = 'Y' THEN
6196: arp_util_tax.debug('create_zx_statuses (+)');
6197: END IF;
6198:
6199: BEGIN
6200:

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

6313: NULL;
6314: END;
6315:
6316: IF PG_DEBUG = 'Y' THEN
6317: arp_util_tax.debug('Statuses For Unused JATW_GOVERNMENT_TAX_TYPE.. ');
6318: END IF;
6319:
6320: BEGIN
6321: NumRec := 0;

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

6326: WHERE global_attribute_category = 'JA.TW.APXTADTC.TAX_CODES'
6327: and global_attribute1 is not null;
6328: EXCEPTION
6329: WHEN OTHERS THEN
6330: arp_util_tax.debug('EXCEPTION: ' || sqlerrm);
6331: END;
6332:
6333: IF NumRec > 0 THEN
6334: IF L_MULTI_ORG_FLAG = 'Y'

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

6709: NULL;
6710: END;
6711:
6712: IF PG_DEBUG = 'Y' THEN
6713: arp_util_tax.debug('create_zx_statuses (-)');
6714: END IF;
6715:
6716:
6717: EXCEPTION

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

6716:
6717: EXCEPTION
6718: WHEN OTHERS THEN
6719: IF PG_DEBUG = 'Y' THEN
6720: arp_util_tax.debug('EXCEPTION: Create_zx_statuses ');
6721: arp_util_tax.debug(sqlerrm);
6722: arp_util_tax.debug('create_zx_statuses (-)');
6723: END IF;
6724: --app_exception.raise_exception;

Line 6721: arp_util_tax.debug(sqlerrm);

6717: EXCEPTION
6718: WHEN OTHERS THEN
6719: IF PG_DEBUG = 'Y' THEN
6720: arp_util_tax.debug('EXCEPTION: Create_zx_statuses ');
6721: arp_util_tax.debug(sqlerrm);
6722: arp_util_tax.debug('create_zx_statuses (-)');
6723: END IF;
6724: --app_exception.raise_exception;
6725: END create_zx_statuses;

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

6718: WHEN OTHERS THEN
6719: IF PG_DEBUG = 'Y' THEN
6720: arp_util_tax.debug('EXCEPTION: Create_zx_statuses ');
6721: arp_util_tax.debug(sqlerrm);
6722: arp_util_tax.debug('create_zx_statuses (-)');
6723: END IF;
6724: --app_exception.raise_exception;
6725: END create_zx_statuses;
6726:

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

6753: PROCEDURE create_zx_taxes(p_tax_id IN NUMBER DEFAULT NULL) IS
6754: BEGIN
6755:
6756: IF PG_DEBUG = 'Y' THEN
6757: arp_util_tax.debug('create_zx_taxes(+)');
6758: END IF;
6759: BEGIN
6760:
6761: IF L_MULTI_ORG_FLAG = 'Y'

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

8712: NULL;
8713: END;
8714:
8715: IF PG_DEBUG = 'Y' THEN
8716: arp_util_tax.debug('create_zx_taxes(-)');
8717: END IF;
8718:
8719:
8720: EXCEPTION

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

8719:
8720: EXCEPTION
8721: WHEN OTHERS THEN
8722: IF PG_DEBUG = 'Y' THEN
8723: arp_util_tax.debug('EXCEPTION: Create_zx_taxes ');
8724: arp_util_tax.debug(sqlerrm);
8725: arp_util_tax.debug('create_zx_taxes(-)');
8726: END IF;
8727: --app_exception.raise_exception;

Line 8724: arp_util_tax.debug(sqlerrm);

8720: EXCEPTION
8721: WHEN OTHERS THEN
8722: IF PG_DEBUG = 'Y' THEN
8723: arp_util_tax.debug('EXCEPTION: Create_zx_taxes ');
8724: arp_util_tax.debug(sqlerrm);
8725: arp_util_tax.debug('create_zx_taxes(-)');
8726: END IF;
8727: --app_exception.raise_exception;
8728: END create_zx_taxes;

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

8721: WHEN OTHERS THEN
8722: IF PG_DEBUG = 'Y' THEN
8723: arp_util_tax.debug('EXCEPTION: Create_zx_taxes ');
8724: arp_util_tax.debug(sqlerrm);
8725: arp_util_tax.debug('create_zx_taxes(-)');
8726: END IF;
8727: --app_exception.raise_exception;
8728: END create_zx_taxes;
8729:

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

8754: PROCEDURE create_templates IS
8755: BEGIN
8756:
8757: IF PG_DEBUG = 'Y' THEN
8758: arp_util_tax.debug('create_templates(+)');
8759: END IF;
8760:
8761: INSERT INTO ZX_DET_FACTOR_TEMPL_B
8762: (

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

8922: )
8923: );
8924:
8925: IF PG_DEBUG = 'Y' THEN
8926: arp_util_tax.debug('create_templates(-)');
8927: END IF;
8928:
8929:
8930: EXCEPTION

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

8929:
8930: EXCEPTION
8931: WHEN OTHERS THEN
8932: IF PG_DEBUG = 'Y' THEN
8933: arp_util_tax.debug('EXCEPTION: Create_zx_templates ');
8934: arp_util_tax.debug(sqlerrm);
8935: arp_util_tax.debug('create_templates(-)');
8936: END IF;
8937: --app_exception.raise_exception;

Line 8934: arp_util_tax.debug(sqlerrm);

8930: EXCEPTION
8931: WHEN OTHERS THEN
8932: IF PG_DEBUG = 'Y' THEN
8933: arp_util_tax.debug('EXCEPTION: Create_zx_templates ');
8934: arp_util_tax.debug(sqlerrm);
8935: arp_util_tax.debug('create_templates(-)');
8936: END IF;
8937: --app_exception.raise_exception;
8938: END create_templates;

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

8931: WHEN OTHERS THEN
8932: IF PG_DEBUG = 'Y' THEN
8933: arp_util_tax.debug('EXCEPTION: Create_zx_templates ');
8934: arp_util_tax.debug(sqlerrm);
8935: arp_util_tax.debug('create_templates(-)');
8936: END IF;
8937: --app_exception.raise_exception;
8938: END create_templates;
8939:

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

8965: PROCEDURE create_condition_groups(p_rate_id IN NUMBER DEFAULT NULL) IS
8966: BEGIN
8967:
8968: IF PG_DEBUG = 'Y' THEN
8969: arp_util_tax.debug('create_condition_groups(+)');
8970: END IF;
8971:
8972: INSERT INTO ZX_conditions
8973: (

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

9401: where T.CONDITION_GROUP_ID = B.CONDITION_GROUP_ID
9402: and T.LANGUAGE = L.LANGUAGE_CODE);
9403:
9404: IF PG_DEBUG = 'Y' THEN
9405: arp_util_tax.debug('create_condition_groups(-)');
9406: END IF;
9407:
9408: EXCEPTION
9409: WHEN OTHERS THEN

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

9407:
9408: EXCEPTION
9409: WHEN OTHERS THEN
9410: IF PG_DEBUG = 'Y' THEN
9411: arp_util_tax.debug('EXCEPTION: Create_condition_groups ');
9412: arp_util_tax.debug(sqlerrm);
9413: arp_util_tax.debug('create_condition_groups(-)');
9414: END IF;
9415: --app_exception.raise_exception;

Line 9412: arp_util_tax.debug(sqlerrm);

9408: EXCEPTION
9409: WHEN OTHERS THEN
9410: IF PG_DEBUG = 'Y' THEN
9411: arp_util_tax.debug('EXCEPTION: Create_condition_groups ');
9412: arp_util_tax.debug(sqlerrm);
9413: arp_util_tax.debug('create_condition_groups(-)');
9414: END IF;
9415: --app_exception.raise_exception;
9416: END create_condition_groups;

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

9409: WHEN OTHERS THEN
9410: IF PG_DEBUG = 'Y' THEN
9411: arp_util_tax.debug('EXCEPTION: Create_condition_groups ');
9412: arp_util_tax.debug(sqlerrm);
9413: arp_util_tax.debug('create_condition_groups(-)');
9414: END IF;
9415: --app_exception.raise_exception;
9416: END create_condition_groups;
9417:

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

9442: PROCEDURE create_rules(p_tax_id IN NUMBER DEFAULT NULL) IS
9443: BEGIN
9444:
9445: IF PG_DEBUG = 'Y' THEN
9446: arp_util_tax.debug('create_rules(+)');
9447: END IF;
9448:
9449: IF L_MULTI_ORG_FLAG = 'Y'
9450: THEN

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

10006: );
10007:
10008: END IF;
10009: IF PG_DEBUG = 'Y' THEN
10010: arp_util_tax.debug('create_rules(-)');
10011: END IF;
10012:
10013: EXCEPTION
10014: WHEN OTHERS THEN

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

10012:
10013: EXCEPTION
10014: WHEN OTHERS THEN
10015: IF PG_DEBUG = 'Y' THEN
10016: arp_util_tax.debug('EXCEPTION: Create_rules ');
10017: arp_util_tax.debug(sqlerrm);
10018: arp_util_tax.debug('create_rules(-)');
10019: END IF;
10020: --app_exception.raise_exception;

Line 10017: arp_util_tax.debug(sqlerrm);

10013: EXCEPTION
10014: WHEN OTHERS THEN
10015: IF PG_DEBUG = 'Y' THEN
10016: arp_util_tax.debug('EXCEPTION: Create_rules ');
10017: arp_util_tax.debug(sqlerrm);
10018: arp_util_tax.debug('create_rules(-)');
10019: END IF;
10020: --app_exception.raise_exception;
10021: END create_rules;

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

10014: WHEN OTHERS THEN
10015: IF PG_DEBUG = 'Y' THEN
10016: arp_util_tax.debug('EXCEPTION: Create_rules ');
10017: arp_util_tax.debug(sqlerrm);
10018: arp_util_tax.debug('create_rules(-)');
10019: END IF;
10020: --app_exception.raise_exception;
10021: END create_rules;
10022:

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

10111: v_current_ac_id ZX_ACCOUNTS.TAX_ACCOUNT_CCID%TYPE;
10112:
10113:
10114: BEGIN
10115: arp_util_tax.debug('Create Tax Accounts(+)');
10116:
10117: v_max_ac_count := 0;
10118: v_current_ac_count := 0;
10119: v_count := 0;

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

10308: WHERE accounts.TAX_ACCOUNT_ENTITY_CODE = 'TAXES' and
10309: accounts.TAX_ACCOUNT_ENTITY_ID = pg_max_tax_id_tab(j)
10310: )
10311: );
10312: arp_util_tax.debug('Create Tax Accounts(-)');
10313:
10314: END ;
10315:
10316: /*===========================================================================+

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

10406:
10407:
10408: BEGIN
10409: IF PG_DEBUG = 'Y' THEN
10410: arp_util_tax.debug('Migrate_Disabled_Tax_Codes');
10411: END IF;
10412:
10413: BEGIN
10414: SELECT sysdate-999999 into l_min_start_date from dual;

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

10423: FETCH tax_id_csr
10424: BULK COLLECT INTO tax_id_tab;
10425:
10426: EXCEPTION WHEN OTHERS THEN
10427: arp_util_tax.debug('Failed to open the tax_id_csr in migrate_disabled_tax_codes');
10428: END;
10429:
10430:
10431:

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

11288: where source_id = nvl(p_tax_id,codes.tax_id)
11289: ) ;
11290: END IF;
11291: EXCEPTION WHEN OTHERS THEN
11292: arp_util_tax.debug('Encountered error in the ID clash insert for disabled tax codes'||sqlerrm);
11293: END ;
11294: END IF;
11295:
11296:

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

12153:
12154: END IF;
12155:
12156: EXCEPTION WHEN OTHERS THEN
12157: arp_util_tax.debug('Caught an error in the non id clash portion for the disabled tax codes'||sqlerrm);
12158: END;
12159:
12160: END LOOP;
12161:

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

12588: AND not exists (select 1 from zx_rates_b
12589: where source_id = nvl(p_tax_id,codes.tax_id)
12590: ) ;
12591: EXCEPTION WHEN OTHERS THEN
12592: arp_util_tax.debug('Caught an error in the id clash portion for the disabled tax codes
12593: with no date overlap'||sqlerrm);
12594: END;
12595: ELSE
12596: BEGIN

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

13014: AND not exists (select 1 from zx_rates_b
13015: where source_id = nvl(p_tax_id,codes.tax_id)
13016: ) ;
13017: EXCEPTION WHEN OTHERS THEN
13018: arp_util_tax.debug('Caught an error in the id clash portion for the disabled tax codes
13019: with no date overlap'||sqlerrm);
13020: END;
13021:
13022:

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

13882:
13883: END IF;
13884:
13885: EXCEPTION WHEN OTHERS THEN
13886: arp_util_tax.debug('Caught an error in the non id clash portion for the disabled tax codes
13887: with no date overlap'||sqlerrm);
13888: END;
13889:
13890:

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

13929: where T.TAX_RATE_ID = RATES.TAX_RATE_ID
13930: and T.LANGUAGE = L.LANGUAGE_CODE);
13931:
13932: IF PG_DEBUG = 'Y' THEN
13933: arp_util_tax.debug('Migrate_Normal_Tax_Codes(-)');
13934: END IF;
13935:
13936:
13937: EXCEPTION

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

13936:
13937: EXCEPTION
13938: WHEN OTHERS THEN
13939: IF PG_DEBUG = 'Y' THEN
13940: arp_util_tax.debug('EXCEPTION: Migrate_disabled_tax_codes ');
13941: arp_util_tax.debug(sqlerrm);
13942: arp_util_tax.debug('Migrate_disabled_Tax_Codes(-)');
13943: END IF;
13944: --app_exception.raise_exception;

Line 13941: arp_util_tax.debug(sqlerrm);

13937: EXCEPTION
13938: WHEN OTHERS THEN
13939: IF PG_DEBUG = 'Y' THEN
13940: arp_util_tax.debug('EXCEPTION: Migrate_disabled_tax_codes ');
13941: arp_util_tax.debug(sqlerrm);
13942: arp_util_tax.debug('Migrate_disabled_Tax_Codes(-)');
13943: END IF;
13944: --app_exception.raise_exception;
13945:

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

13938: WHEN OTHERS THEN
13939: IF PG_DEBUG = 'Y' THEN
13940: arp_util_tax.debug('EXCEPTION: Migrate_disabled_tax_codes ');
13941: arp_util_tax.debug(sqlerrm);
13942: arp_util_tax.debug('Migrate_disabled_Tax_Codes(-)');
13943: END IF;
13944: --app_exception.raise_exception;
13945:
13946:

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

14046: ar_vat_tax_all_b
14047: where tax_id = vat_tax_id);
14048: EXCEPTION
14049: WHEN no_data_found THEN
14050: arp_util_tax.debug('No data found exception encountered for tax definition in constructor :'||sqlerrm);
14051:
14052: WHEN others THEN
14053: arp_util_tax.debug('Exception in Constructor for AP tax definition :'||sqlerrm);
14054: END;

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

14049: WHEN no_data_found THEN
14050: arp_util_tax.debug('No data found exception encountered for tax definition in constructor :'||sqlerrm);
14051:
14052: WHEN others THEN
14053: arp_util_tax.debug('Exception in Constructor for AP tax definition :'||sqlerrm);
14054: END;
14055:
14056: BEGIN
14057:

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

14062:
14063: FND_PROFILE.GET('ORG_ID',L_ORG_ID);
14064:
14065: IF L_ORG_ID IS NULL THEN
14066: arp_util_tax.debug('MO: Operating Units site level profile option value not set , resulted in Null Org Id');
14067: END IF;
14068: ELSE
14069: L_ORG_ID := NULL;
14070: END IF;

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

14070: END IF;
14071:
14072: EXCEPTION
14073: WHEN no_data_found THEN
14074: arp_util_tax.debug('No data found exception encountered for tax definition in constructor :'||sqlerrm);
14075:
14076: WHEN others THEN
14077: arp_util_tax.debug('Exception in Constructor for AP tax definition :'||sqlerrm);
14078: END;

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

14073: WHEN no_data_found THEN
14074: arp_util_tax.debug('No data found exception encountered for tax definition in constructor :'||sqlerrm);
14075:
14076: WHEN others THEN
14077: arp_util_tax.debug('Exception in Constructor for AP tax definition :'||sqlerrm);
14078: END;
14079: BEGIN
14080: MO_GLOBAL.INIT('ZX');
14081: EXCEPTION WHEN OTHERS THEN

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

14078: END;
14079: BEGIN
14080: MO_GLOBAL.INIT('ZX');
14081: EXCEPTION WHEN OTHERS THEN
14082: arp_util_tax.debug('Exception in MO_GLOBAL.init');
14083: END;
14084:
14085:
14086: