APPS.PAY_NL_WAGE_REPORT_PKG dependencies on HR_UTILITY

Line 99: hr_utility.set_location(' Leaving: range code',110);

95: sqlstr := 'select 1 '||
96: '/* ERROR - Employer Details Fetch failed with: '||
97: sqlerrm(sqlcode)||' */ '||
98: 'from dual where to_char(:payroll_action_id) = dummy';
99: hr_utility.set_location(' Leaving: range code',110);
100: END archive_range_code;
101: --------------------------------------------------------------------------------
102: -- get_defined_balance_id pay_nl_wage_report_pkg.get_defined_balance_id
103: --------------------------------------------------------------------------------

Line 2681: --hr_utility.trace_on(null,'NL_WR');

2677: l_prev_corr_bal NUMBER;
2678: --
2679: --
2680: BEGIN
2681: --hr_utility.trace_on(null,'NL_WR');
2682: --Fnd_file.put_line(FND_FILE.LOG,' Entering deinit code ');
2683: /*Delete all data archived for the current payroll_action_id - to handle assignment level retry*/
2684: DELETE pay_action_information
2685: WHERE action_context_id = p_actid

Line 2744: hr_utility.set_location(sqlerrm(sqlcode),110);

2740: EXCEPTION
2741: WHEN OTHERS THEN
2742: -- Return cursor that selects no rows
2743: --Fnd_file.put_line(FND_FILE.LOG,'## SQLERR ' || sqlerrm(sqlcode));
2744: hr_utility.set_location(sqlerrm(sqlcode),110);
2745: END archive_deinit_code_yearly;
2746: --------------------------------------------------------------------------------
2747: -- DEINITIALIZE_CODE pay_nl_wage_report_pkg.archive_deinit_code
2748: --------------------------------------------------------------------------------

Line 3039: --hr_utility.trace_on(null,'NL_WR');

3035: l_prev_end_date DATE;
3036: l_prev_corr_bal NUMBER;
3037: --
3038: BEGIN
3039: --hr_utility.trace_on(null,'NL_WR');
3040: --Fnd_file.put_line(FND_FILE.LOG,' Entering deinit code ');
3041: /*Delete all data archived for the current payroll_action_id - to handle assignment level retry*/
3042: DELETE pay_action_information
3043: WHERE action_context_id = p_actid

Line 4277: hr_utility.set_location(sqlerrm(sqlcode),110);

4273: EXCEPTION
4274: WHEN OTHERS THEN
4275: -- Return cursor that selects no rows
4276: --Fnd_file.put_line(FND_FILE.LOG,'## SQLERR ' || sqlerrm(sqlcode));
4277: hr_utility.set_location(sqlerrm(sqlcode),110);
4278: END archive_deinit_code;
4279: --------------------------------------------------------------------------------
4280: -- ACTION_CREATION_CODE
4281: --------------------------------------------------------------------------------

Line 4611: --hr_utility.trace_on(null,'NL_WR');

4607: l_arc_pactid NUMBER;
4608: --
4609: BEGIN
4610: --
4611: --hr_utility.trace_on(null,'NL_WR');
4612: --
4613: l_arc_pactid := TO_NUMBER(get_parameters(p_actid,'REQUEST_ID'));
4614: --
4615: FOR csr_rec IN csr_assignment_actions(l_arc_pactid) LOOP

Line 8927: --hr_utility.trace_on(null,'NL_WR');

8923: l_seq_no VARCHAR2(15);
8924: --
8925: BEGIN
8926: -- get Employee data
8927: --hr_utility.trace_on(null,'NL_WR');
8928: --
8929: --Fnd_file.put_line(FND_FILE.LOG,' Entering Archive Code for Assignment :'||p_assactid);
8930: select payroll_action_id,assignment_id
8931: into l_pactid, l_assignment_id