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 130: hr_utility.set_location(l_proc_name || ' Start of balance_amount',60);

126: begin
127: l_package := ' pay_sg_cpfline.';
128: l_proc_name := l_package || 'balance_amount';
129: if g_debug then
130: hr_utility.set_location(l_proc_name || ' Start of balance_amount',60);
131: end if;
132: --
133: if g_cpf_with_bal_value is null then
134: open balance_amount ;

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

146: close balance_amount;
147: end if;
148: --
149: if g_debug then
150: hr_utility.set_location(l_proc_name || ' End of balance_amount',60);
151: end if;
152: --
153: if p_balance_name = 'CPF Withheld' then
154: return g_cpf_with_bal_value;

Line 212: g_debug := hr_utility.debug_enabled;

208: l_stat_type_total number;
209: begin
210: l_package := ' pay_sg_cpfline.';
211: l_proc_name := l_package || 'stat type count';
212: g_debug := hr_utility.debug_enabled;
213: --
214: if g_debug then
215: hr_utility.set_location(l_proc_name || ' Start of stat_type_amount',50);
216: end if;

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

211: l_proc_name := l_package || 'stat type count';
212: g_debug := hr_utility.debug_enabled;
213: --
214: if g_debug then
215: hr_utility.set_location(l_proc_name || ' Start of stat_type_amount',50);
216: end if;
217: --
218: if p_stat_type = 'AV1' then
219: l_stat_type_total := balance_amount ( p_payroll_action_id , 'CPF Withheld')+

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

238: l_stat_type_total := balance_amount ( p_payroll_action_id, 'Balance Total');
239: end if;
240: --
241: if g_debug then
242: hr_utility.set_location(l_proc_name || ' End of stat_type_amount',50);
243: end if;
244: --
245: return l_stat_type_total;
246: end stat_type_amount;

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

259: begin
260: l_package := ' pay_sg_cpfline.';
261: l_proc_name := l_package || 'stat type count';
262: if g_debug then
263: hr_utility.set_location(l_proc_name || ' Start of stat_type_count',70);
264: end if;
265: ----------------------------------------------------------------------------------------------
266: -- Bug: 3298317 - Employee Count calculated based on distinct CPF number - action_information1
267: ----------------------------------------------------------------------------------------------

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

327: and to_number(pai.action_information11) > 0;
328: end if;
329: --
330: if g_debug then
331: hr_utility.set_location(l_proc_name || ' End of stat_type_count',70);
332: end if;
333: --
334: return l_count;
335: end stat_type_count;

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

529: l_wp :='N';
530: l_sg :='N';
531:
532: if g_debug then
533: hr_utility.set_location(l_proc_name || ' Start of get_balance_value',80);
534: end if;
535: --
536: if p_employee_type = 'NEW' and global_exist_emp = true then
537: t_dup_emp_rec.delete;

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

732: t_dup_emp_rec(l_dup_counter).mf_record_status := 'M';
733: end if;
734: --
735: if g_debug then
736: hr_utility.set_location(l_proc_name || ' MF Section',80);
737: hr_utility.set_location(l_proc_name || ' p_balance_name '||p_balance_name,80);
738: hr_utility.set_location(l_proc_name || ' Employee '||t_dup_emp_rec(l_counter).cpf_acc_number,80);
739: hr_utility.set_location(l_proc_name || ' balance_value '||mf_tot_bal,80);
740: hr_utility.set_location(l_proc_name || ' Asact id '||to_char(t_dup_emp_rec(l_counter).assignment_action_id),80);

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

733: end if;
734: --
735: if g_debug then
736: hr_utility.set_location(l_proc_name || ' MF Section',80);
737: hr_utility.set_location(l_proc_name || ' p_balance_name '||p_balance_name,80);
738: hr_utility.set_location(l_proc_name || ' Employee '||t_dup_emp_rec(l_counter).cpf_acc_number,80);
739: hr_utility.set_location(l_proc_name || ' balance_value '||mf_tot_bal,80);
740: hr_utility.set_location(l_proc_name || ' Asact id '||to_char(t_dup_emp_rec(l_counter).assignment_action_id),80);
741: end if;

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

734: --
735: if g_debug then
736: hr_utility.set_location(l_proc_name || ' MF Section',80);
737: hr_utility.set_location(l_proc_name || ' p_balance_name '||p_balance_name,80);
738: hr_utility.set_location(l_proc_name || ' Employee '||t_dup_emp_rec(l_counter).cpf_acc_number,80);
739: hr_utility.set_location(l_proc_name || ' balance_value '||mf_tot_bal,80);
740: hr_utility.set_location(l_proc_name || ' Asact id '||to_char(t_dup_emp_rec(l_counter).assignment_action_id),80);
741: end if;
742: end if;

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

735: if g_debug then
736: hr_utility.set_location(l_proc_name || ' MF Section',80);
737: hr_utility.set_location(l_proc_name || ' p_balance_name '||p_balance_name,80);
738: hr_utility.set_location(l_proc_name || ' Employee '||t_dup_emp_rec(l_counter).cpf_acc_number,80);
739: hr_utility.set_location(l_proc_name || ' balance_value '||mf_tot_bal,80);
740: hr_utility.set_location(l_proc_name || ' Asact id '||to_char(t_dup_emp_rec(l_counter).assignment_action_id),80);
741: end if;
742: end if;
743: end if;

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

736: hr_utility.set_location(l_proc_name || ' MF Section',80);
737: hr_utility.set_location(l_proc_name || ' p_balance_name '||p_balance_name,80);
738: hr_utility.set_location(l_proc_name || ' Employee '||t_dup_emp_rec(l_counter).cpf_acc_number,80);
739: hr_utility.set_location(l_proc_name || ' balance_value '||mf_tot_bal,80);
740: hr_utility.set_location(l_proc_name || ' Asact id '||to_char(t_dup_emp_rec(l_counter).assignment_action_id),80);
741: end if;
742: end if;
743: end if;
744: ------------------------------------------------------

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

773: t_dup_emp_rec(l_dup_counter).cl_record_status := 'C';
774: end if;
775: --
776: if g_debug then
777: hr_utility.set_location(l_proc_name || ' CTL Section',80);
778: hr_utility.set_location(l_proc_name || ' p_balance_name '||p_balance_name,80);
779: hr_utility.set_location(l_proc_name || ' Employee '||t_dup_emp_rec(l_counter).cpf_acc_number,80);
780: hr_utility.set_location(l_proc_name || ' balance_value '||ctl_tot_bal,80);
781: hr_utility.set_location(l_proc_name || ' Asact id '||to_char(t_dup_emp_rec(l_counter).assignment_action_id),80);

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

774: end if;
775: --
776: if g_debug then
777: hr_utility.set_location(l_proc_name || ' CTL Section',80);
778: hr_utility.set_location(l_proc_name || ' p_balance_name '||p_balance_name,80);
779: hr_utility.set_location(l_proc_name || ' Employee '||t_dup_emp_rec(l_counter).cpf_acc_number,80);
780: hr_utility.set_location(l_proc_name || ' balance_value '||ctl_tot_bal,80);
781: hr_utility.set_location(l_proc_name || ' Asact id '||to_char(t_dup_emp_rec(l_counter).assignment_action_id),80);
782: end if;

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

775: --
776: if g_debug then
777: hr_utility.set_location(l_proc_name || ' CTL Section',80);
778: hr_utility.set_location(l_proc_name || ' p_balance_name '||p_balance_name,80);
779: hr_utility.set_location(l_proc_name || ' Employee '||t_dup_emp_rec(l_counter).cpf_acc_number,80);
780: hr_utility.set_location(l_proc_name || ' balance_value '||ctl_tot_bal,80);
781: hr_utility.set_location(l_proc_name || ' Asact id '||to_char(t_dup_emp_rec(l_counter).assignment_action_id),80);
782: end if;
783: --

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

776: if g_debug then
777: hr_utility.set_location(l_proc_name || ' CTL Section',80);
778: hr_utility.set_location(l_proc_name || ' p_balance_name '||p_balance_name,80);
779: hr_utility.set_location(l_proc_name || ' Employee '||t_dup_emp_rec(l_counter).cpf_acc_number,80);
780: hr_utility.set_location(l_proc_name || ' balance_value '||ctl_tot_bal,80);
781: hr_utility.set_location(l_proc_name || ' Asact id '||to_char(t_dup_emp_rec(l_counter).assignment_action_id),80);
782: end if;
783: --
784: end if;

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

777: hr_utility.set_location(l_proc_name || ' CTL Section',80);
778: hr_utility.set_location(l_proc_name || ' p_balance_name '||p_balance_name,80);
779: hr_utility.set_location(l_proc_name || ' Employee '||t_dup_emp_rec(l_counter).cpf_acc_number,80);
780: hr_utility.set_location(l_proc_name || ' balance_value '||ctl_tot_bal,80);
781: hr_utility.set_location(l_proc_name || ' Asact id '||to_char(t_dup_emp_rec(l_counter).assignment_action_id),80);
782: end if;
783: --
784: end if;
785: end if;

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

812: return tot_bal ;
813: end if;
814: --
815: if g_debug then
816: hr_utility.set_location(l_proc_name || ' End of get_balance_value',80);
817: end if;
818: -- hr_utility.trace_off;
819: end get_balance_value;
820:

Line 818: -- hr_utility.trace_off;

814: --
815: if g_debug then
816: hr_utility.set_location(l_proc_name || ' End of get_balance_value',80);
817: end if;
818: -- hr_utility.trace_off;
819: end get_balance_value;
820:
821: end pay_sg_cpfline_balances;