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.PAY_IP_RUN_BALANCE_UPGRADE dependencies on HR_UTILITY

Line 80: hr_utility.trace('Entering ' || gv_package_name || lv_procedure_name);

76:
77: BEGIN
78:
79: lv_procedure_name := '.qualify_balance';
80: hr_utility.trace('Entering ' || gv_package_name || lv_procedure_name);
81: lv_qualified := 'N';
82:
83: open c_primary_balance(p_object_id);
84: fetch c_primary_balance into lv_qualified ;

Line 88: hr_utility.trace('Leaving ' || gv_package_name || lv_procedure_name);

84: fetch c_primary_balance into lv_qualified ;
85: close c_primary_balance;
86:
87: p_qualified := lv_qualified;
88: hr_utility.trace('Leaving ' || gv_package_name || lv_procedure_name);
89:
90: exception
91: when others then
92: hr_utility.set_location(gv_package_name || lv_procedure_name, 200);

Line 92: hr_utility.set_location(gv_package_name || lv_procedure_name, 200);

88: hr_utility.trace('Leaving ' || gv_package_name || lv_procedure_name);
89:
90: exception
91: when others then
92: hr_utility.set_location(gv_package_name || lv_procedure_name, 200);
93: hr_utility.trace('ERROR:' || sqlcode ||'-'|| substr(sqlerrm,1,80));
94: raise;
95: END qualify_balance;
96:

Line 93: hr_utility.trace('ERROR:' || sqlcode ||'-'|| substr(sqlerrm,1,80));

89:
90: exception
91: when others then
92: hr_utility.set_location(gv_package_name || lv_procedure_name, 200);
93: hr_utility.trace('ERROR:' || sqlcode ||'-'|| substr(sqlerrm,1,80));
94: raise;
95: END qualify_balance;
96:
97:

Line 171: hr_utility.trace('Entering ' || gv_package_name || lv_procedure_name);

167:
168: ltt_business_group numeric_data_table;
169: BEGIN
170: lv_procedure_name := '.upgrade_balance';
171: hr_utility.trace('Entering ' || gv_package_name || lv_procedure_name);
172:
173: hr_utility.set_location(gv_package_name || lv_procedure_name, 10);
174:
175: open c_primary_balance(p_object_id);

Line 173: hr_utility.set_location(gv_package_name || lv_procedure_name, 10);

169: BEGIN
170: lv_procedure_name := '.upgrade_balance';
171: hr_utility.trace('Entering ' || gv_package_name || lv_procedure_name);
172:
173: hr_utility.set_location(gv_package_name || lv_procedure_name, 10);
174:
175: open c_primary_balance(p_object_id);
176: fetch c_primary_balance into ln_balance_type_id, lv_classification_name,
177: l_effective_date,ln_business_grp_id;

Line 179: hr_utility.trace('Primary balance type id = '|| ln_balance_type_id);

175: open c_primary_balance(p_object_id);
176: fetch c_primary_balance into ln_balance_type_id, lv_classification_name,
177: l_effective_date,ln_business_grp_id;
178: close c_primary_balance;
179: hr_utility.trace('Primary balance type id = '|| ln_balance_type_id);
180:
181: open c_legislation_code(p_object_id);
182: fetch c_legislation_code into lv_legislation_code ;
183: close c_legislation_code;

Line 184: hr_utility.trace('lv_legislation_code = '|| lv_legislation_code);

180:
181: open c_legislation_code(p_object_id);
182: fetch c_legislation_code into lv_legislation_code ;
183: close c_legislation_code;
184: hr_utility.trace('lv_legislation_code = '|| lv_legislation_code);
185:
186: open c_get_taxunit_flag(lv_legislation_code);
187: fetch c_get_taxunit_flag into lv_taxunit_flag ;
188: close c_get_taxunit_flag;

Line 204: hr_utility.trace('Balance Category Updated to Earnings for primary balance ' || ln_balance_type_id);

200: WHERE CATEGORY_NAME = 'Earnings'
201: AND legislation_code = lv_legislation_code)
202: where balance_type_id = ln_balance_type_id;
203:
204: hr_utility.trace('Balance Category Updated to Earnings for primary balance ' || ln_balance_type_id);
205:
206: elsif lv_classification_name in ('Tax Deductions'
207: ,'Pre-Tax Deductions'
208: ,'Involuntary Deductions'

Line 218: hr_utility.trace('Balance Category Updated to Deductions for primary balance ' || ln_balance_type_id);

214: WHERE CATEGORY_NAME = 'Deductions'
215: AND legislation_code = lv_legislation_code)
216: where balance_type_id = ln_balance_type_id;
217:
218: hr_utility.trace('Balance Category Updated to Deductions for primary balance ' || ln_balance_type_id);
219: end if;
220: /* End of updation of balance category*/
221:
222: if(lv_taxunit_flag = 'Y') then

Line 235: hr_utility.trace('ln_bal_dim_id = '|| ln_bal_dim_id);

231:
232: open c_get_bal_dim_id(lv_legislation_code,'_ASG_TU_RUN');
233: fetch c_get_bal_dim_id into ln_bal_dim_id ;
234: close c_get_bal_dim_id;
235: hr_utility.trace('ln_bal_dim_id = '|| ln_bal_dim_id);
236:
237: /* Insert defined balance for _ASG_TU_RUN */
238: pay_defined_balances_pkg.insert_row
239: (x_rowid => lv_rowid

Line 248: hr_utility.trace('Inserted defined balance for _ASG_TU_RUN ' || ln_def_balance_id);

244: ,x_balance_dimension_id => ln_bal_dim_id
245: ,x_force_latest_balance_flag => null
246: ,x_legislation_subgroup => null);
247:
248: hr_utility.trace('Inserted defined balance for _ASG_TU_RUN ' || ln_def_balance_id);
249:
250: else
251: update pay_defined_balances
252: set save_run_balance = 'Y'

Line 255: hr_utility.trace('Save run balance updated for defined balance ' || ln_def_balance_id);

251: update pay_defined_balances
252: set save_run_balance = 'Y'
253: where defined_balance_id = ln_def_balance_id ;
254:
255: hr_utility.trace('Save run balance updated for defined balance ' || ln_def_balance_id);
256:
257: end if;
258:
259:

Line 271: hr_utility.trace('Save run balance updated for defined balance ' || ln_def_balance_id);

267: update pay_defined_balances
268: set save_run_balance = 'Y'
269: where defined_balance_id = ln_def_balance_id ;
270:
271: hr_utility.trace('Save run balance updated for defined balance ' || ln_def_balance_id);
272:
273: end if;
274:
275: hr_utility.trace('Leaving ' || gv_package_name || lv_procedure_name);

Line 275: hr_utility.trace('Leaving ' || gv_package_name || lv_procedure_name);

271: hr_utility.trace('Save run balance updated for defined balance ' || ln_def_balance_id);
272:
273: end if;
274:
275: hr_utility.trace('Leaving ' || gv_package_name || lv_procedure_name);
276: exception
277: when others then
278: hr_utility.set_location(gv_package_name || lv_procedure_name, 200);
279: hr_utility.trace('ERROR:' || sqlcode ||'-'|| substr(sqlerrm,1,80));

Line 278: hr_utility.set_location(gv_package_name || lv_procedure_name, 200);

274:
275: hr_utility.trace('Leaving ' || gv_package_name || lv_procedure_name);
276: exception
277: when others then
278: hr_utility.set_location(gv_package_name || lv_procedure_name, 200);
279: hr_utility.trace('ERROR:' || sqlcode ||'-'|| substr(sqlerrm,1,80));
280: raise;
281: END upgrade_balance;
282:

Line 279: hr_utility.trace('ERROR:' || sqlcode ||'-'|| substr(sqlerrm,1,80));

275: hr_utility.trace('Leaving ' || gv_package_name || lv_procedure_name);
276: exception
277: when others then
278: hr_utility.set_location(gv_package_name || lv_procedure_name, 200);
279: hr_utility.trace('ERROR:' || sqlcode ||'-'|| substr(sqlerrm,1,80));
280: raise;
281: END upgrade_balance;
282:
283: BEGIN