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_SG_CPFLINE_BALANCES dependencies on HR_UTILITY

Line 137: hr_utility.set_location(l_proc_name || ' Start of balance_amount',60);

133: begin
134: l_package := ' pay_sg_cpfline.';
135: l_proc_name := l_package || 'balance_amount';
136: if g_debug then
137: hr_utility.set_location(l_proc_name || ' Start of balance_amount',60);
138: end if;
139: --
140: if g_cpf_with_bal_value is null then
141: open balance_amount ;

Line 158: hr_utility.set_location(l_proc_name || ' End of balance_amount',60);

154: end if;
155: --
156: if g_debug then
157:
158: hr_utility.set_location(l_proc_name || ' End of balance_amount',60);
159: end if;
160: --
161: if p_balance_name = 'CPF Withheld' then
162: return g_cpf_with_bal_value;

Line 220: g_debug := hr_utility.debug_enabled;

216: l_stat_type_total number;
217: begin
218: l_package := ' pay_sg_cpfline.';
219: l_proc_name := l_package || 'stat type count';
220: g_debug := hr_utility.debug_enabled;
221: --
222: if g_debug then
223: hr_utility.set_location(l_proc_name || ' Start of stat_type_amount',50);
224: end if;

Line 223: hr_utility.set_location(l_proc_name || ' Start of stat_type_amount',50);

219: l_proc_name := l_package || 'stat type count';
220: g_debug := hr_utility.debug_enabled;
221: --
222: if g_debug then
223: hr_utility.set_location(l_proc_name || ' Start of stat_type_amount',50);
224: end if;
225: --
226: if p_stat_type = 'AV1' then
227: l_stat_type_total := balance_amount ( p_payroll_action_id , 'CPF Withheld')+

Line 250: hr_utility.set_location(l_proc_name || ' End of stat_type_amount',50);

246: l_stat_type_total := balance_amount ( p_payroll_action_id, 'Balance Total');
247: end if;
248: --
249: if g_debug then
250: hr_utility.set_location(l_proc_name || ' End of stat_type_amount',50);
251: end if;
252: --
253: return l_stat_type_total;
254: end stat_type_amount;

Line 271: hr_utility.set_location(l_proc_name || ' Start of stat_type_count',70);

267: begin
268: l_package := ' pay_sg_cpfline.';
269: l_proc_name := l_package || 'stat type count';
270: if g_debug then
271: hr_utility.set_location(l_proc_name || ' Start of stat_type_count',70);
272: end if;
273: ----------------------------------------------------------------------------------------------
274: -- Bug: 3298317 - Employee Count calculated based on distinct CPF number - action_information1
275: ----------------------------------------------------------------------------------------------

Line 339: hr_utility.set_location(l_proc_name || ' End of stat_type_count',70);

335: and to_number(pai.action_information11) > 0;
336: end if;
337: --
338: if g_debug then
339: hr_utility.set_location(l_proc_name || ' End of stat_type_count',70);
340: end if;
341: --
342: return l_count;
343: end stat_type_count;

Line 541: hr_utility.set_location(l_proc_name || ' Start of get_balance_value',80);

537: l_wp :='N';
538: l_sg :='N';
539:
540: if g_debug then
541: hr_utility.set_location(l_proc_name || ' Start of get_balance_value',80);
542: end if;
543: --
544: if p_employee_type = 'NEW' and global_exist_emp = true then
545: t_dup_emp_rec.delete;

Line 744: hr_utility.set_location(l_proc_name || ' MF Section',80);

740: t_dup_emp_rec(l_dup_counter).mf_record_status := 'M';
741: end if;
742: --
743: if g_debug then
744: hr_utility.set_location(l_proc_name || ' MF Section',80);
745: hr_utility.set_location(l_proc_name || ' p_balance_name '||p_balance_name,80);
746: hr_utility.set_location(l_proc_name || ' Employee '||t_dup_emp_rec(l_counter).cpf_acc_number,80);
747: hr_utility.set_location(l_proc_name || ' balance_value '||mf_tot_bal,80);
748: hr_utility.set_location(l_proc_name || ' Asact id '||to_char(t_dup_emp_rec(l_counter).assignment_action_id),80);

Line 745: hr_utility.set_location(l_proc_name || ' p_balance_name '||p_balance_name,80);

741: end if;
742: --
743: if g_debug then
744: hr_utility.set_location(l_proc_name || ' MF Section',80);
745: hr_utility.set_location(l_proc_name || ' p_balance_name '||p_balance_name,80);
746: hr_utility.set_location(l_proc_name || ' Employee '||t_dup_emp_rec(l_counter).cpf_acc_number,80);
747: hr_utility.set_location(l_proc_name || ' balance_value '||mf_tot_bal,80);
748: hr_utility.set_location(l_proc_name || ' Asact id '||to_char(t_dup_emp_rec(l_counter).assignment_action_id),80);
749: end if;

Line 746: hr_utility.set_location(l_proc_name || ' Employee '||t_dup_emp_rec(l_counter).cpf_acc_number,80);

742: --
743: if g_debug then
744: hr_utility.set_location(l_proc_name || ' MF Section',80);
745: hr_utility.set_location(l_proc_name || ' p_balance_name '||p_balance_name,80);
746: hr_utility.set_location(l_proc_name || ' Employee '||t_dup_emp_rec(l_counter).cpf_acc_number,80);
747: hr_utility.set_location(l_proc_name || ' balance_value '||mf_tot_bal,80);
748: hr_utility.set_location(l_proc_name || ' Asact id '||to_char(t_dup_emp_rec(l_counter).assignment_action_id),80);
749: end if;
750: end if;

Line 747: hr_utility.set_location(l_proc_name || ' balance_value '||mf_tot_bal,80);

743: if g_debug then
744: hr_utility.set_location(l_proc_name || ' MF Section',80);
745: hr_utility.set_location(l_proc_name || ' p_balance_name '||p_balance_name,80);
746: hr_utility.set_location(l_proc_name || ' Employee '||t_dup_emp_rec(l_counter).cpf_acc_number,80);
747: hr_utility.set_location(l_proc_name || ' balance_value '||mf_tot_bal,80);
748: hr_utility.set_location(l_proc_name || ' Asact id '||to_char(t_dup_emp_rec(l_counter).assignment_action_id),80);
749: end if;
750: end if;
751: end if;

Line 748: hr_utility.set_location(l_proc_name || ' Asact id '||to_char(t_dup_emp_rec(l_counter).assignment_action_id),80);

744: hr_utility.set_location(l_proc_name || ' MF Section',80);
745: hr_utility.set_location(l_proc_name || ' p_balance_name '||p_balance_name,80);
746: hr_utility.set_location(l_proc_name || ' Employee '||t_dup_emp_rec(l_counter).cpf_acc_number,80);
747: hr_utility.set_location(l_proc_name || ' balance_value '||mf_tot_bal,80);
748: hr_utility.set_location(l_proc_name || ' Asact id '||to_char(t_dup_emp_rec(l_counter).assignment_action_id),80);
749: end if;
750: end if;
751: end if;
752: ------------------------------------------------------

Line 785: hr_utility.set_location(l_proc_name || ' CTL Section',80);

781: t_dup_emp_rec(l_dup_counter).cl_record_status := 'C';
782: end if;
783: --
784: if g_debug then
785: hr_utility.set_location(l_proc_name || ' CTL Section',80);
786: hr_utility.set_location(l_proc_name || ' p_balance_name '||p_balance_name,80);
787: hr_utility.set_location(l_proc_name || ' Employee '||t_dup_emp_rec(l_counter).cpf_acc_number,80);
788: hr_utility.set_location(l_proc_name || ' balance_value '||ctl_tot_bal,80);
789: hr_utility.set_location(l_proc_name || ' Asact id '||to_char(t_dup_emp_rec(l_counter).assignment_action_id),80);

Line 786: hr_utility.set_location(l_proc_name || ' p_balance_name '||p_balance_name,80);

782: end if;
783: --
784: if g_debug then
785: hr_utility.set_location(l_proc_name || ' CTL Section',80);
786: hr_utility.set_location(l_proc_name || ' p_balance_name '||p_balance_name,80);
787: hr_utility.set_location(l_proc_name || ' Employee '||t_dup_emp_rec(l_counter).cpf_acc_number,80);
788: hr_utility.set_location(l_proc_name || ' balance_value '||ctl_tot_bal,80);
789: hr_utility.set_location(l_proc_name || ' Asact id '||to_char(t_dup_emp_rec(l_counter).assignment_action_id),80);
790: end if;

Line 787: hr_utility.set_location(l_proc_name || ' Employee '||t_dup_emp_rec(l_counter).cpf_acc_number,80);

783: --
784: if g_debug then
785: hr_utility.set_location(l_proc_name || ' CTL Section',80);
786: hr_utility.set_location(l_proc_name || ' p_balance_name '||p_balance_name,80);
787: hr_utility.set_location(l_proc_name || ' Employee '||t_dup_emp_rec(l_counter).cpf_acc_number,80);
788: hr_utility.set_location(l_proc_name || ' balance_value '||ctl_tot_bal,80);
789: hr_utility.set_location(l_proc_name || ' Asact id '||to_char(t_dup_emp_rec(l_counter).assignment_action_id),80);
790: end if;
791: --

Line 788: hr_utility.set_location(l_proc_name || ' balance_value '||ctl_tot_bal,80);

784: if g_debug then
785: hr_utility.set_location(l_proc_name || ' CTL Section',80);
786: hr_utility.set_location(l_proc_name || ' p_balance_name '||p_balance_name,80);
787: hr_utility.set_location(l_proc_name || ' Employee '||t_dup_emp_rec(l_counter).cpf_acc_number,80);
788: hr_utility.set_location(l_proc_name || ' balance_value '||ctl_tot_bal,80);
789: hr_utility.set_location(l_proc_name || ' Asact id '||to_char(t_dup_emp_rec(l_counter).assignment_action_id),80);
790: end if;
791: --
792: end if;

Line 789: hr_utility.set_location(l_proc_name || ' Asact id '||to_char(t_dup_emp_rec(l_counter).assignment_action_id),80);

785: hr_utility.set_location(l_proc_name || ' CTL Section',80);
786: hr_utility.set_location(l_proc_name || ' p_balance_name '||p_balance_name,80);
787: hr_utility.set_location(l_proc_name || ' Employee '||t_dup_emp_rec(l_counter).cpf_acc_number,80);
788: hr_utility.set_location(l_proc_name || ' balance_value '||ctl_tot_bal,80);
789: hr_utility.set_location(l_proc_name || ' Asact id '||to_char(t_dup_emp_rec(l_counter).assignment_action_id),80);
790: end if;
791: --
792: end if;
793: end if;

Line 824: hr_utility.set_location(l_proc_name || ' End of get_balance_value',80);

820: return tot_bal ;
821: end if;
822: --
823: if g_debug then
824: hr_utility.set_location(l_proc_name || ' End of get_balance_value',80);
825: end if;
826: -- hr_utility.trace_off;
827: end get_balance_value;
828:

Line 826: -- hr_utility.trace_off;

822: --
823: if g_debug then
824: hr_utility.set_location(l_proc_name || ' End of get_balance_value',80);
825: end if;
826: -- hr_utility.trace_off;
827: end get_balance_value;
828:
829: end pay_sg_cpfline_balances;