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_IE_EOY_INCOMELEVY_REPORT dependencies on FND_FILE

Line 84: fnd_file.put_line(fnd_file.LOG,'Entering get_asg_set_details');

80:
81: --
82: BEGIN
83: --
84: fnd_file.put_line(fnd_file.LOG,'Entering get_asg_set_details');
85: -- Check whether the assignment set id has a criteria
86: -- if a formula id is attached or check whether this
87: -- is an amendments only
88: l_formula_id := NULL;

Line 91: fnd_file.put_line(fnd_file.LOG,' after csr_get_asg_set_info ');

87: -- is an amendments only
88: l_formula_id := NULL;
89: OPEN csr_get_asg_set_info(p_assignment_set_id);
90: FETCH csr_get_asg_set_info INTO l_formula_id;
91: fnd_file.put_line(fnd_file.LOG,' after csr_get_asg_set_info ');
92: fnd_file.put_line(fnd_file.LOG,' l_formula_id '|| l_formula_id);
93: IF csr_get_asg_set_info%FOUND
94: THEN
95: -- Criteria exists check for formula id

Line 92: fnd_file.put_line(fnd_file.LOG,' l_formula_id '|| l_formula_id);

88: l_formula_id := NULL;
89: OPEN csr_get_asg_set_info(p_assignment_set_id);
90: FETCH csr_get_asg_set_info INTO l_formula_id;
91: fnd_file.put_line(fnd_file.LOG,' after csr_get_asg_set_info ');
92: fnd_file.put_line(fnd_file.LOG,' l_formula_id '|| l_formula_id);
93: IF csr_get_asg_set_info%FOUND
94: THEN
95: -- Criteria exists check for formula id
96: IF l_formula_id IS NULL

Line 104: fnd_file.put_line(fnd_file.LOG,' before csr_get_asg_amd ');

100: hr_utility.raise_error;
101: END IF; -- End if of formula id is null check ...
102: END IF; -- End if of asg criteria row found check ...
103: CLOSE csr_get_asg_set_info;
104: fnd_file.put_line(fnd_file.LOG,' before csr_get_asg_amd ');
105: OPEN csr_get_asg_amnd(p_assignment_set_id);
106: LOOP
107: FETCH csr_get_asg_amnd INTO l_asg_set_amnds;
108: EXIT WHEN csr_get_asg_amnd%NOTFOUND;

Line 111: fnd_file.put_line(fnd_file.LOG,' l_asg_set_amnds.assignment_id '|| l_asg_set_amnds.assignment_id);

107: FETCH csr_get_asg_amnd INTO l_asg_set_amnds;
108: EXIT WHEN csr_get_asg_amnd%NOTFOUND;
109: l_tab_asg_set_amnds(l_asg_set_amnds.assignment_id) :=
110: l_asg_set_amnds.include_or_exclude;
111: fnd_file.put_line(fnd_file.LOG,' l_asg_set_amnds.assignment_id '|| l_asg_set_amnds.assignment_id);
112: fnd_file.put_line(fnd_file.LOG,' l_asg_set_amnds.include_or_exclude '|| l_asg_set_amnds.include_or_exclude);
113: END LOOP;
114: CLOSE csr_get_asg_amnd;
115: p_formula_id := l_formula_id;

Line 112: fnd_file.put_line(fnd_file.LOG,' l_asg_set_amnds.include_or_exclude '|| l_asg_set_amnds.include_or_exclude);

108: EXIT WHEN csr_get_asg_amnd%NOTFOUND;
109: l_tab_asg_set_amnds(l_asg_set_amnds.assignment_id) :=
110: l_asg_set_amnds.include_or_exclude;
111: fnd_file.put_line(fnd_file.LOG,' l_asg_set_amnds.assignment_id '|| l_asg_set_amnds.assignment_id);
112: fnd_file.put_line(fnd_file.LOG,' l_asg_set_amnds.include_or_exclude '|| l_asg_set_amnds.include_or_exclude);
113: END LOOP;
114: CLOSE csr_get_asg_amnd;
115: p_formula_id := l_formula_id;
116: p_tab_asg_set_amnds := l_tab_asg_set_amnds;

Line 120: fnd_file.put_line(fnd_file.LOG,'..'||'SQL-ERRM :'||SQLERRM);

116: p_tab_asg_set_amnds := l_tab_asg_set_amnds;
117: EXCEPTION
118: WHEN OTHERS
119: THEN
120: fnd_file.put_line(fnd_file.LOG,'..'||'SQL-ERRM :'||SQLERRM);
121: END get_asg_set_details;
122:
123:
124:

Line 149: fnd_file.put_line(fnd_file.LOG,'Entering chk_is_asg_in_asg_set');

145: l_outputs ff_exec.outputs_t;
146: --
147: BEGIN
148: --
149: fnd_file.put_line(fnd_file.LOG,'Entering chk_is_asg_in_asg_set');
150: l_include_flag := 'N';
151: l_tab_asg_set_amnds := p_tab_asg_set_amnds;
152: -- Check whether the assignment exists in the collection
153: -- first as the static assignment set overrides the

Line 157: fnd_file.put_line(fnd_file.LOG,'Entered assignment ammendents if block');

153: -- first as the static assignment set overrides the
154: -- criteria one
155: IF l_tab_asg_set_amnds.EXISTS(p_assignment_id)
156: THEN
157: fnd_file.put_line(fnd_file.LOG,'Entered assignment ammendents if block');
158: -- Check whether to include or exclude
159: IF l_tab_asg_set_amnds(p_assignment_id) = 'I'
160: THEN
161: l_include_flag := 'Y';

Line 172: fnd_file.put_line(fnd_file.LOG,'Entered assignment criteria block');

168: -- assignment does not exist in assignment set amendments
169: -- check whether a formula criteria exists for this
170: -- assignment set
171: -- Initialize the formula
172: fnd_file.put_line(fnd_file.LOG,'Entered assignment criteria block');
173: ff_exec.init_formula(p_formula_id => p_formula_id
174: ,p_effective_date => p_effective_date
175: ,p_inputs => l_inputs
176: ,p_outputs => l_outputs

Line 178: fnd_file.put_line(fnd_file.LOG,'formula initialized');

174: ,p_effective_date => p_effective_date
175: ,p_inputs => l_inputs
176: ,p_outputs => l_outputs
177: );
178: fnd_file.put_line(fnd_file.LOG,'formula initialized');
179: -- Set the inputs first
180: -- Loop through them to set the contexts
181: FOR i IN l_inputs.FIRST .. l_inputs.LAST
182: LOOP

Line 192: fnd_file.put_line(fnd_file.LOG,' before formaula run');

188: l_inputs(i).VALUE := fnd_date.date_to_canonical(p_effective_date);
189: END IF;
190: END LOOP;
191: -- Run the formula
192: fnd_file.put_line(fnd_file.LOG,' before formaula run');
193:
194:
195: ff_exec.run_formula(l_inputs, l_outputs);
196:

Line 198: fnd_file.put_line(fnd_file.LOG,' aftre formaula run');

194:
195: ff_exec.run_formula(l_inputs, l_outputs);
196:
197:
198: fnd_file.put_line(fnd_file.LOG,' aftre formaula run');
199: -- Check whether the assignment has to be included
200: -- by checking the output flag
201:
202:

Line 203: fnd_file.put_line(fnd_file.LOG,' before outputs for run');

199: -- Check whether the assignment has to be included
200: -- by checking the output flag
201:
202:
203: fnd_file.put_line(fnd_file.LOG,' before outputs for run');
204: FOR i IN l_outputs.FIRST .. l_outputs.LAST
205: LOOP
206: IF l_outputs(i).NAME = 'INCLUDE_FLAG'
207: THEN

Line 215: fnd_file.put_line(fnd_file.LOG,'p_assignment_id'||p_assignment_id);

211: ELSIF l_outputs(i).VALUE = 'N'
212: THEN
213: l_include_flag := 'N';
214: END IF;
215: fnd_file.put_line(fnd_file.LOG,'p_assignment_id'||p_assignment_id);
216: fnd_file.put_line(fnd_file.LOG,'l_include_flag'||l_include_flag);
217: EXIT;
218: END IF;
219:

Line 216: fnd_file.put_line(fnd_file.LOG,'l_include_flag'||l_include_flag);

212: THEN
213: l_include_flag := 'N';
214: END IF;
215: fnd_file.put_line(fnd_file.LOG,'p_assignment_id'||p_assignment_id);
216: fnd_file.put_line(fnd_file.LOG,'l_include_flag'||l_include_flag);
217: EXIT;
218: END IF;
219:
220: END LOOP;

Line 227: fnd_file.put_line(fnd_file.LOG,'..'||'SQL-ERRM :'||SQLERRM);

223: RETURN l_include_flag;
224: EXCEPTION
225: WHEN OTHERS
226: THEN
227: fnd_file.put_line(fnd_file.LOG,'..'||'SQL-ERRM :'||SQLERRM);
228: END chk_is_asg_in_asg_set;
229:
230:
231:

Line 608: fnd_file.put_line(fnd_file.LOG,'after get_asg_set_details' );

604: ,p_formula_id => l_formula_id
605: ,p_tab_asg_set_amnds => l_tab_asg_set_amnds
606:
607: );
608: fnd_file.put_line(fnd_file.LOG,'after get_asg_set_details' );
609:
610:
611: fnd_file.put_line(fnd_file.LOG,'till date ' || to_date('30/04'||'/'||to_char(cp_end_date,'yyyy'),'dd/mm/yyyy') );
612: for p60 in c_p60_records( cp_start_date,

Line 611: fnd_file.put_line(fnd_file.LOG,'till date ' || to_date('30/04'||'/'||to_char(cp_end_date,'yyyy'),'dd/mm/yyyy') );

607: );
608: fnd_file.put_line(fnd_file.LOG,'after get_asg_set_details' );
609:
610:
611: fnd_file.put_line(fnd_file.LOG,'till date ' || to_date('30/04'||'/'||to_char(cp_end_date,'yyyy'),'dd/mm/yyyy') );
612: for p60 in c_p60_records( cp_start_date,
613: cp_effective_date,
614: cp_end_date,
615: p_business_group_id,

Line 623: fnd_file.put_line(fnd_file.LOG,'assignment_id'||p60.assignment_id);

619: p_sort_order) LOOP
620:
621:
622: /*6876894*/
623: fnd_file.put_line(fnd_file.LOG,'assignment_id'||p60.assignment_id);
624: l_gross_pay_till_apr :=0;
625: l_gross_pay_adjust_till_apr :=0;
626: l_bik_prsi_taxable_till_apr :=0;
627: l_income_levy_till_apr :=0;

Line 651: fnd_file.put_line(fnd_file.LOG,'l_include_flag'||l_include_flag);

647: ,p_formula_id => l_formula_id
648: ,p_tab_asg_set_amnds => l_tab_asg_set_amnds
649: ,p_effective_date => cp_effective_date
650: );
651: fnd_file.put_line(fnd_file.LOG,'l_include_flag'||l_include_flag);
652: if l_include_flag = 'N' then
653: l_flag:='N';
654: end if;
655: end if;

Line 657: fnd_file.put_line(fnd_file.LOG,'p60.ppsn' || p60.ppsn);

653: l_flag:='N';
654: end if;
655: end if;
656:
657: fnd_file.put_line(fnd_file.LOG,'p60.ppsn' || p60.ppsn);
658: fnd_file.put_line(fnd_file.LOG,'p60.assignment_id' || p60.assignment_id);
659: fnd_file.put_line(fnd_file.LOG,'p60.person_id' || p60.person_id);
660: OPEN cur_assignment_action_till_apr(p60.assignment_id);
661: FETCH cur_assignment_action_till_apr into l_assignment_action_till_apr;

Line 658: fnd_file.put_line(fnd_file.LOG,'p60.assignment_id' || p60.assignment_id);

654: end if;
655: end if;
656:
657: fnd_file.put_line(fnd_file.LOG,'p60.ppsn' || p60.ppsn);
658: fnd_file.put_line(fnd_file.LOG,'p60.assignment_id' || p60.assignment_id);
659: fnd_file.put_line(fnd_file.LOG,'p60.person_id' || p60.person_id);
660: OPEN cur_assignment_action_till_apr(p60.assignment_id);
661: FETCH cur_assignment_action_till_apr into l_assignment_action_till_apr;
662: CLOSE cur_assignment_action_till_apr;

Line 659: fnd_file.put_line(fnd_file.LOG,'p60.person_id' || p60.person_id);

655: end if;
656:
657: fnd_file.put_line(fnd_file.LOG,'p60.ppsn' || p60.ppsn);
658: fnd_file.put_line(fnd_file.LOG,'p60.assignment_id' || p60.assignment_id);
659: fnd_file.put_line(fnd_file.LOG,'p60.person_id' || p60.person_id);
660: OPEN cur_assignment_action_till_apr(p60.assignment_id);
661: FETCH cur_assignment_action_till_apr into l_assignment_action_till_apr;
662: CLOSE cur_assignment_action_till_apr;
663:

Line 664: fnd_file.put_line(fnd_file.LOG,'l_assignment_action_till_apr'|| l_assignment_action_till_apr);

660: OPEN cur_assignment_action_till_apr(p60.assignment_id);
661: FETCH cur_assignment_action_till_apr into l_assignment_action_till_apr;
662: CLOSE cur_assignment_action_till_apr;
663:
664: fnd_file.put_line(fnd_file.LOG,'l_assignment_action_till_apr'|| l_assignment_action_till_apr);
665: fnd_file.put_line(fnd_file.LOG,'cp_end_date'|| to_char(cp_end_date));
666: /* 10180910 start moved up out of year check of 2009*/
667: OPEN cur_paye_ref(p60.assignment_id,p60.person_id);
668: FETCH cur_paye_ref INTO l_paye_ref;

Line 665: fnd_file.put_line(fnd_file.LOG,'cp_end_date'|| to_char(cp_end_date));

661: FETCH cur_assignment_action_till_apr into l_assignment_action_till_apr;
662: CLOSE cur_assignment_action_till_apr;
663:
664: fnd_file.put_line(fnd_file.LOG,'l_assignment_action_till_apr'|| l_assignment_action_till_apr);
665: fnd_file.put_line(fnd_file.LOG,'cp_end_date'|| to_char(cp_end_date));
666: /* 10180910 start moved up out of year check of 2009*/
667: OPEN cur_paye_ref(p60.assignment_id,p60.person_id);
668: FETCH cur_paye_ref INTO l_paye_ref;
669: CLOSE cur_paye_ref;

Line 671: fnd_file.put_line(fnd_file.LOG,'l_paye_ref'|| l_paye_ref);

667: OPEN cur_paye_ref(p60.assignment_id,p60.person_id);
668: FETCH cur_paye_ref INTO l_paye_ref;
669: CLOSE cur_paye_ref;
670:
671: fnd_file.put_line(fnd_file.LOG,'l_paye_ref'|| l_paye_ref);
672:
673: OPEN csr_get_org_email(l_paye_ref);
674: FETCH csr_get_org_email INTO l_email;
675: CLOSE csr_get_org_email;

Line 677: fnd_file.put_line(fnd_file.LOG,'l_email'|| l_email);

673: OPEN csr_get_org_email(l_paye_ref);
674: FETCH csr_get_org_email INTO l_email;
675: CLOSE csr_get_org_email;
676:
677: fnd_file.put_line(fnd_file.LOG,'l_email'|| l_email);
678: /* 10180910 end */
679: IF to_char(cp_end_date,'YYYY') = '2009' THEN -- 10180910
680: OPEN cur_assignment_action(p60.assignment_id);
681: FETCH cur_assignment_action into l_assignment_action;

Line 684: fnd_file.put_line(fnd_file.LOG,'l_assignment_action'|| l_assignment_action);

680: OPEN cur_assignment_action(p60.assignment_id);
681: FETCH cur_assignment_action into l_assignment_action;
682: CLOSE cur_assignment_action;
683:
684: fnd_file.put_line(fnd_file.LOG,'l_assignment_action'|| l_assignment_action);
685: /*
686: OPEN cur_paye_ref(p60.assignment_id,p60.person_id);
687: FETCH cur_paye_ref INTO l_paye_ref;
688: CLOSE cur_paye_ref;

Line 690: fnd_file.put_line(fnd_file.LOG,'l_paye_ref'|| l_paye_ref);

686: OPEN cur_paye_ref(p60.assignment_id,p60.person_id);
687: FETCH cur_paye_ref INTO l_paye_ref;
688: CLOSE cur_paye_ref;
689:
690: fnd_file.put_line(fnd_file.LOG,'l_paye_ref'|| l_paye_ref);
691:
692: OPEN csr_get_org_email(l_paye_ref);
693: FETCH csr_get_org_email INTO l_email;
694: CLOSE csr_get_org_email;

Line 696: fnd_file.put_line(fnd_file.LOG,'l_email'|| l_email); */

692: OPEN csr_get_org_email(l_paye_ref);
693: FETCH csr_get_org_email INTO l_email;
694: CLOSE csr_get_org_email;
695:
696: fnd_file.put_line(fnd_file.LOG,'l_email'|| l_email); */
697: l_ppsn_override:=null;
698: OPEN csr_ppsn_override(p60.assignment_id);
699: FETCH csr_ppsn_override INTO l_ppsn_override;
700: IF csr_ppsn_override%NOTFOUND THEN

Line 705: fnd_file.put_line(fnd_file.LOG,'l_ppsn_override'|| l_ppsn_override);

701: l_ppsn_override:=null;
702: END IF;
703: CLOSE csr_ppsn_override;
704:
705: fnd_file.put_line(fnd_file.LOG,'l_ppsn_override'|| l_ppsn_override);
706:
707: OPEN c_get_periods_of_service(p60.person_id,p60.assignment_id,l_paye_ref);
708: FETCH c_get_periods_of_service INTO l_prev_period_service_id;
709: CLOSE c_get_periods_of_service;

Line 711: fnd_file.put_line(fnd_file.LOG,'l_prev_period_service_id'|| l_prev_period_service_id);

707: OPEN c_get_periods_of_service(p60.person_id,p60.assignment_id,l_paye_ref);
708: FETCH c_get_periods_of_service INTO l_prev_period_service_id;
709: CLOSE c_get_periods_of_service;
710:
711: fnd_file.put_line(fnd_file.LOG,'l_prev_period_service_id'|| l_prev_period_service_id);
712: /* 9560108 */
713: --
714: IF l_ppsn_override IS NOT NULL THEN
715: OPEN c_get_max_aact_PPSN(l_prev_period_service_id,l_ppsn_override,p60.person_id);

Line 725: fnd_file.put_line(fnd_file.LOG,'l_prev_asg_action_till_apr'|| l_prev_asg_action_till_apr);

721: CLOSE c_get_max_aact;
722: END IF;
723: --
724:
725: fnd_file.put_line(fnd_file.LOG,'l_prev_asg_action_till_apr'|| l_prev_asg_action_till_apr);
726:
727: IF l_ppsn_override is null THEN
728: OPEN cur_defined_balance_id('IE Gross Income','_PER_PAYE_REF_YTD');
729:

Line 750: fnd_file.put_line(fnd_file.LOG,'l_balance_value_till_apr'|| l_balance_value_till_apr);

746: ELSE
747: l_balance_value_till_apr:=0;
748: END IF;
749:
750: fnd_file.put_line(fnd_file.LOG,'l_balance_value_till_apr'|| l_balance_value_till_apr);
751: IF l_prev_asg_action_till_apr is not null and l_assignment_action_till_apr is not null THEN
752: l_pre_bal_value_till_apr := PAY_BALANCE_PKG.GET_VALUE(l_defined_balance_id,
753: l_prev_asg_action_till_apr,
754: l_paye_ref,

Line 761: fnd_file.put_line(fnd_file.LOG,'l_pre_bal_value_till_apr'|| l_pre_bal_value_till_apr);

757: null,
758: null,
759: null);
760: END IF;
761: fnd_file.put_line(fnd_file.LOG,'l_pre_bal_value_till_apr'|| l_pre_bal_value_till_apr);
762: l_balance_value_till_apr:=l_balance_value_till_apr-l_pre_bal_value_till_apr;
763: fnd_file.put_line(fnd_file.LOG,'l_balance_value_till_apr'|| l_balance_value_till_apr);
764: l_gross_pay_till_apr:=l_balance_value_till_apr;
765: fnd_file.put_line(fnd_file.LOG,'l_gross_pay_till_apr'|| l_gross_pay_till_apr);

Line 763: fnd_file.put_line(fnd_file.LOG,'l_balance_value_till_apr'|| l_balance_value_till_apr);

759: null);
760: END IF;
761: fnd_file.put_line(fnd_file.LOG,'l_pre_bal_value_till_apr'|| l_pre_bal_value_till_apr);
762: l_balance_value_till_apr:=l_balance_value_till_apr-l_pre_bal_value_till_apr;
763: fnd_file.put_line(fnd_file.LOG,'l_balance_value_till_apr'|| l_balance_value_till_apr);
764: l_gross_pay_till_apr:=l_balance_value_till_apr;
765: fnd_file.put_line(fnd_file.LOG,'l_gross_pay_till_apr'|| l_gross_pay_till_apr);
766: l_defined_balance_id:=null;
767: l_balance_value_till_apr:=0;

Line 765: fnd_file.put_line(fnd_file.LOG,'l_gross_pay_till_apr'|| l_gross_pay_till_apr);

761: fnd_file.put_line(fnd_file.LOG,'l_pre_bal_value_till_apr'|| l_pre_bal_value_till_apr);
762: l_balance_value_till_apr:=l_balance_value_till_apr-l_pre_bal_value_till_apr;
763: fnd_file.put_line(fnd_file.LOG,'l_balance_value_till_apr'|| l_balance_value_till_apr);
764: l_gross_pay_till_apr:=l_balance_value_till_apr;
765: fnd_file.put_line(fnd_file.LOG,'l_gross_pay_till_apr'|| l_gross_pay_till_apr);
766: l_defined_balance_id:=null;
767: l_balance_value_till_apr:=0;
768:
769: IF l_ppsn_override is null THEN

Line 792: fnd_file.put_line(fnd_file.LOG,'l_balance_value_till_apr'|| l_balance_value_till_apr);

788: ELSE
789: l_balance_value_till_apr:=0;
790: END IF;
791:
792: fnd_file.put_line(fnd_file.LOG,'l_balance_value_till_apr'|| l_balance_value_till_apr);
793:
794: IF l_prev_asg_action_till_apr is not null and l_assignment_action_till_apr is not null THEN
795: l_pre_bal_value_till_apr := PAY_BALANCE_PKG.GET_VALUE(l_defined_balance_id,
796: l_prev_asg_action_till_apr,

Line 804: fnd_file.put_line(fnd_file.LOG,'l_pre_bal_value_till_apr'|| l_pre_bal_value_till_apr);

800: null,
801: null,
802: null);
803: END IF;
804: fnd_file.put_line(fnd_file.LOG,'l_pre_bal_value_till_apr'|| l_pre_bal_value_till_apr);
805: l_balance_value_till_apr:=l_balance_value_till_apr-l_pre_bal_value_till_apr;
806: fnd_file.put_line(fnd_file.LOG,'l_balance_value_till_apr'|| l_balance_value_till_apr);
807:
808: l_gross_pay_adjust_till_apr:=l_balance_value_till_apr;

Line 806: fnd_file.put_line(fnd_file.LOG,'l_balance_value_till_apr'|| l_balance_value_till_apr);

802: null);
803: END IF;
804: fnd_file.put_line(fnd_file.LOG,'l_pre_bal_value_till_apr'|| l_pre_bal_value_till_apr);
805: l_balance_value_till_apr:=l_balance_value_till_apr-l_pre_bal_value_till_apr;
806: fnd_file.put_line(fnd_file.LOG,'l_balance_value_till_apr'|| l_balance_value_till_apr);
807:
808: l_gross_pay_adjust_till_apr:=l_balance_value_till_apr;
809: fnd_file.put_line(fnd_file.LOG,'l_gross_pay_adjust_till_apr'|| l_gross_pay_adjust_till_apr);
810: l_defined_balance_id:=null;

Line 809: fnd_file.put_line(fnd_file.LOG,'l_gross_pay_adjust_till_apr'|| l_gross_pay_adjust_till_apr);

805: l_balance_value_till_apr:=l_balance_value_till_apr-l_pre_bal_value_till_apr;
806: fnd_file.put_line(fnd_file.LOG,'l_balance_value_till_apr'|| l_balance_value_till_apr);
807:
808: l_gross_pay_adjust_till_apr:=l_balance_value_till_apr;
809: fnd_file.put_line(fnd_file.LOG,'l_gross_pay_adjust_till_apr'|| l_gross_pay_adjust_till_apr);
810: l_defined_balance_id:=null;
811: l_balance_value_till_apr:=0;
812:
813: IF l_ppsn_override is null THEN

Line 836: fnd_file.put_line(fnd_file.LOG,'l_balance_value_till_apr'|| l_balance_value_till_apr);

832: ELSE
833: l_balance_value_till_apr:=0;
834: END IF;
835:
836: fnd_file.put_line(fnd_file.LOG,'l_balance_value_till_apr'|| l_balance_value_till_apr);
837:
838: IF l_prev_asg_action_till_apr is not null and l_assignment_action_till_apr is not null THEN
839: l_pre_bal_value_till_apr := PAY_BALANCE_PKG.GET_VALUE(l_defined_balance_id,
840: l_prev_asg_action_till_apr,

Line 848: fnd_file.put_line(fnd_file.LOG,'l_pre_bal_value_till_apr'|| l_pre_bal_value_till_apr);

844: null,
845: null,
846: null);
847: END IF;
848: fnd_file.put_line(fnd_file.LOG,'l_pre_bal_value_till_apr'|| l_pre_bal_value_till_apr);
849: l_balance_value_till_apr:=l_balance_value_till_apr-l_pre_bal_value_till_apr;
850: fnd_file.put_line(fnd_file.LOG,'l_balance_value_till_apr'|| l_balance_value_till_apr);
851:
852: l_bik_prsi_taxable_till_apr:=l_balance_value_till_apr;

Line 850: fnd_file.put_line(fnd_file.LOG,'l_balance_value_till_apr'|| l_balance_value_till_apr);

846: null);
847: END IF;
848: fnd_file.put_line(fnd_file.LOG,'l_pre_bal_value_till_apr'|| l_pre_bal_value_till_apr);
849: l_balance_value_till_apr:=l_balance_value_till_apr-l_pre_bal_value_till_apr;
850: fnd_file.put_line(fnd_file.LOG,'l_balance_value_till_apr'|| l_balance_value_till_apr);
851:
852: l_bik_prsi_taxable_till_apr:=l_balance_value_till_apr;
853: fnd_file.put_line(fnd_file.LOG,'l_bik_prsi_taxable_till_apr'|| l_bik_prsi_taxable_till_apr);
854: l_defined_balance_id:=null;

Line 853: fnd_file.put_line(fnd_file.LOG,'l_bik_prsi_taxable_till_apr'|| l_bik_prsi_taxable_till_apr);

849: l_balance_value_till_apr:=l_balance_value_till_apr-l_pre_bal_value_till_apr;
850: fnd_file.put_line(fnd_file.LOG,'l_balance_value_till_apr'|| l_balance_value_till_apr);
851:
852: l_bik_prsi_taxable_till_apr:=l_balance_value_till_apr;
853: fnd_file.put_line(fnd_file.LOG,'l_bik_prsi_taxable_till_apr'|| l_bik_prsi_taxable_till_apr);
854: l_defined_balance_id:=null;
855: l_balance_value_till_apr:=0;
856:
857: IF l_ppsn_override is null THEN

Line 880: fnd_file.put_line(fnd_file.LOG,'l_balance_value_till_apr'|| l_balance_value_till_apr);

876: ELSE
877: l_balance_value_till_apr:=0;
878: END IF;
879:
880: fnd_file.put_line(fnd_file.LOG,'l_balance_value_till_apr'|| l_balance_value_till_apr);
881:
882: IF l_prev_asg_action_till_apr is not null and l_assignment_action_till_apr is not null THEN
883: l_pre_bal_value_till_apr := PAY_BALANCE_PKG.GET_VALUE(l_defined_balance_id,
884: l_prev_asg_action_till_apr,

Line 892: fnd_file.put_line(fnd_file.LOG,'l_pre_bal_value_till_apr'|| l_pre_bal_value_till_apr);

888: null,
889: null,
890: null);
891: END IF;
892: fnd_file.put_line(fnd_file.LOG,'l_pre_bal_value_till_apr'|| l_pre_bal_value_till_apr);
893: l_balance_value_till_apr:=l_balance_value_till_apr-l_pre_bal_value_till_apr;
894: fnd_file.put_line(fnd_file.LOG,'l_balance_value_till_apr'|| l_balance_value_till_apr);
895:
896: l_income_levy_till_apr:=l_balance_value_till_apr;

Line 894: fnd_file.put_line(fnd_file.LOG,'l_balance_value_till_apr'|| l_balance_value_till_apr);

890: null);
891: END IF;
892: fnd_file.put_line(fnd_file.LOG,'l_pre_bal_value_till_apr'|| l_pre_bal_value_till_apr);
893: l_balance_value_till_apr:=l_balance_value_till_apr-l_pre_bal_value_till_apr;
894: fnd_file.put_line(fnd_file.LOG,'l_balance_value_till_apr'|| l_balance_value_till_apr);
895:
896: l_income_levy_till_apr:=l_balance_value_till_apr;
897: fnd_file.put_line(fnd_file.LOG,'l_income_levy_till_apr'|| l_income_levy_till_apr);
898: l_defined_balance_id:=null;

Line 897: fnd_file.put_line(fnd_file.LOG,'l_income_levy_till_apr'|| l_income_levy_till_apr);

893: l_balance_value_till_apr:=l_balance_value_till_apr-l_pre_bal_value_till_apr;
894: fnd_file.put_line(fnd_file.LOG,'l_balance_value_till_apr'|| l_balance_value_till_apr);
895:
896: l_income_levy_till_apr:=l_balance_value_till_apr;
897: fnd_file.put_line(fnd_file.LOG,'l_income_levy_till_apr'|| l_income_levy_till_apr);
898: l_defined_balance_id:=null;
899: l_balance_value_till_apr:=0;
900:
901: /* knadhan the assignment action passed is the till end of year as recaluclated balance is fed in 53 week calculation*/

Line 925: fnd_file.put_line(fnd_file.LOG,'l_balance_value_till_apr'|| l_balance_value_till_apr);

921: ELSE
922: l_balance_value_till_apr:=0;
923: END IF;
924:
925: fnd_file.put_line(fnd_file.LOG,'l_balance_value_till_apr'|| l_balance_value_till_apr);
926:
927: IF l_prev_asg_action_till_apr is not null and l_assignment_action_till_apr is not null THEN
928: l_pre_bal_value_till_apr := PAY_BALANCE_PKG.GET_VALUE(l_defined_balance_id,
929: l_prev_asg_action_till_apr,

Line 937: fnd_file.put_line(fnd_file.LOG,'l_pre_bal_value_till_apr'|| l_pre_bal_value_till_apr);

933: null,
934: null,
935: null);
936: END IF;
937: fnd_file.put_line(fnd_file.LOG,'l_pre_bal_value_till_apr'|| l_pre_bal_value_till_apr);
938: l_balance_value_till_apr:=l_balance_value_till_apr-l_pre_bal_value_till_apr;
939: fnd_file.put_line(fnd_file.LOG,'l_balance_value_till_apr'|| l_balance_value_till_apr);
940: l_income_levy_till_apr:=l_income_levy_till_apr+l_balance_value_till_apr;
941:

Line 939: fnd_file.put_line(fnd_file.LOG,'l_balance_value_till_apr'|| l_balance_value_till_apr);

935: null);
936: END IF;
937: fnd_file.put_line(fnd_file.LOG,'l_pre_bal_value_till_apr'|| l_pre_bal_value_till_apr);
938: l_balance_value_till_apr:=l_balance_value_till_apr-l_pre_bal_value_till_apr;
939: fnd_file.put_line(fnd_file.LOG,'l_balance_value_till_apr'|| l_balance_value_till_apr);
940: l_income_levy_till_apr:=l_income_levy_till_apr+l_balance_value_till_apr;
941:
942: l_gross_pay_total_till_apr :=l_gross_pay_till_apr + l_gross_pay_adjust_till_apr + l_bik_prsi_taxable_till_apr;
943:

Line 946: fnd_file.put_line(fnd_file.LOG,'l_income_levy_till_apr'|| l_income_levy_till_apr);

942: l_gross_pay_total_till_apr :=l_gross_pay_till_apr + l_gross_pay_adjust_till_apr + l_bik_prsi_taxable_till_apr;
943:
944: l_gross_pay_frm_may := p60.total_gross_pay - l_gross_pay_total_till_apr;
945: l_income_levy_frm_may := p60.total_income_levy - l_income_levy_till_apr;
946: fnd_file.put_line(fnd_file.LOG,'l_income_levy_till_apr'|| l_income_levy_till_apr);
947:
948: fnd_file.put_line(fnd_file.LOG,'p60.total_gross_pay'|| p60.total_gross_pay);
949: fnd_file.put_line(fnd_file.LOG,'l_gross_pay_total_till_apr'|| l_gross_pay_total_till_apr);
950: fnd_file.put_line(fnd_file.LOG,'l_gross_pay_frm_may'|| l_gross_pay_frm_may);

Line 948: fnd_file.put_line(fnd_file.LOG,'p60.total_gross_pay'|| p60.total_gross_pay);

944: l_gross_pay_frm_may := p60.total_gross_pay - l_gross_pay_total_till_apr;
945: l_income_levy_frm_may := p60.total_income_levy - l_income_levy_till_apr;
946: fnd_file.put_line(fnd_file.LOG,'l_income_levy_till_apr'|| l_income_levy_till_apr);
947:
948: fnd_file.put_line(fnd_file.LOG,'p60.total_gross_pay'|| p60.total_gross_pay);
949: fnd_file.put_line(fnd_file.LOG,'l_gross_pay_total_till_apr'|| l_gross_pay_total_till_apr);
950: fnd_file.put_line(fnd_file.LOG,'l_gross_pay_frm_may'|| l_gross_pay_frm_may);
951:
952: fnd_file.put_line(fnd_file.LOG,'p60.total_income_levy'|| p60.total_income_levy);

Line 949: fnd_file.put_line(fnd_file.LOG,'l_gross_pay_total_till_apr'|| l_gross_pay_total_till_apr);

945: l_income_levy_frm_may := p60.total_income_levy - l_income_levy_till_apr;
946: fnd_file.put_line(fnd_file.LOG,'l_income_levy_till_apr'|| l_income_levy_till_apr);
947:
948: fnd_file.put_line(fnd_file.LOG,'p60.total_gross_pay'|| p60.total_gross_pay);
949: fnd_file.put_line(fnd_file.LOG,'l_gross_pay_total_till_apr'|| l_gross_pay_total_till_apr);
950: fnd_file.put_line(fnd_file.LOG,'l_gross_pay_frm_may'|| l_gross_pay_frm_may);
951:
952: fnd_file.put_line(fnd_file.LOG,'p60.total_income_levy'|| p60.total_income_levy);
953: fnd_file.put_line(fnd_file.LOG,'l_income_levy_till_apr'|| l_income_levy_till_apr);

Line 950: fnd_file.put_line(fnd_file.LOG,'l_gross_pay_frm_may'|| l_gross_pay_frm_may);

946: fnd_file.put_line(fnd_file.LOG,'l_income_levy_till_apr'|| l_income_levy_till_apr);
947:
948: fnd_file.put_line(fnd_file.LOG,'p60.total_gross_pay'|| p60.total_gross_pay);
949: fnd_file.put_line(fnd_file.LOG,'l_gross_pay_total_till_apr'|| l_gross_pay_total_till_apr);
950: fnd_file.put_line(fnd_file.LOG,'l_gross_pay_frm_may'|| l_gross_pay_frm_may);
951:
952: fnd_file.put_line(fnd_file.LOG,'p60.total_income_levy'|| p60.total_income_levy);
953: fnd_file.put_line(fnd_file.LOG,'l_income_levy_till_apr'|| l_income_levy_till_apr);
954: fnd_file.put_line(fnd_file.LOG,'l_income_levy_frm_may'|| l_income_levy_frm_may);

Line 952: fnd_file.put_line(fnd_file.LOG,'p60.total_income_levy'|| p60.total_income_levy);

948: fnd_file.put_line(fnd_file.LOG,'p60.total_gross_pay'|| p60.total_gross_pay);
949: fnd_file.put_line(fnd_file.LOG,'l_gross_pay_total_till_apr'|| l_gross_pay_total_till_apr);
950: fnd_file.put_line(fnd_file.LOG,'l_gross_pay_frm_may'|| l_gross_pay_frm_may);
951:
952: fnd_file.put_line(fnd_file.LOG,'p60.total_income_levy'|| p60.total_income_levy);
953: fnd_file.put_line(fnd_file.LOG,'l_income_levy_till_apr'|| l_income_levy_till_apr);
954: fnd_file.put_line(fnd_file.LOG,'l_income_levy_frm_may'|| l_income_levy_frm_may);
955: ELSE
956: l_gross_pay_total_till_apr :=0;

Line 953: fnd_file.put_line(fnd_file.LOG,'l_income_levy_till_apr'|| l_income_levy_till_apr);

949: fnd_file.put_line(fnd_file.LOG,'l_gross_pay_total_till_apr'|| l_gross_pay_total_till_apr);
950: fnd_file.put_line(fnd_file.LOG,'l_gross_pay_frm_may'|| l_gross_pay_frm_may);
951:
952: fnd_file.put_line(fnd_file.LOG,'p60.total_income_levy'|| p60.total_income_levy);
953: fnd_file.put_line(fnd_file.LOG,'l_income_levy_till_apr'|| l_income_levy_till_apr);
954: fnd_file.put_line(fnd_file.LOG,'l_income_levy_frm_may'|| l_income_levy_frm_may);
955: ELSE
956: l_gross_pay_total_till_apr :=0;
957: l_income_levy_till_apr :=0;

Line 954: fnd_file.put_line(fnd_file.LOG,'l_income_levy_frm_may'|| l_income_levy_frm_may);

950: fnd_file.put_line(fnd_file.LOG,'l_gross_pay_frm_may'|| l_gross_pay_frm_may);
951:
952: fnd_file.put_line(fnd_file.LOG,'p60.total_income_levy'|| p60.total_income_levy);
953: fnd_file.put_line(fnd_file.LOG,'l_income_levy_till_apr'|| l_income_levy_till_apr);
954: fnd_file.put_line(fnd_file.LOG,'l_income_levy_frm_may'|| l_income_levy_frm_may);
955: ELSE
956: l_gross_pay_total_till_apr :=0;
957: l_income_levy_till_apr :=0;
958: l_gross_pay_frm_may :=0;

Line 960: fnd_file.put_line(fnd_file.LOG,'entered else for assignment_id' || p60.assignment_id);

956: l_gross_pay_total_till_apr :=0;
957: l_income_levy_till_apr :=0;
958: l_gross_pay_frm_may :=0;
959: l_income_levy_frm_may :=0;
960: fnd_file.put_line(fnd_file.LOG,'entered else for assignment_id' || p60.assignment_id);
961: fnd_file.put_line(fnd_file.LOG,'l_flag' || l_flag);
962: END IF; -- 10180910
963:
964: IF(l_flag='Y') THEN

Line 961: fnd_file.put_line(fnd_file.LOG,'l_flag' || l_flag);

957: l_income_levy_till_apr :=0;
958: l_gross_pay_frm_may :=0;
959: l_income_levy_frm_may :=0;
960: fnd_file.put_line(fnd_file.LOG,'entered else for assignment_id' || p60.assignment_id);
961: fnd_file.put_line(fnd_file.LOG,'l_flag' || l_flag);
962: END IF; -- 10180910
963:
964: IF(l_flag='Y') THEN
965:

Line 968: fnd_file.put_line(fnd_file.LOG,'P60 Location id not null' || p60.asg_location_id);

964: IF(l_flag='Y') THEN
965:
966: /* 10277535 start */
967: IF p60.asg_location_id IS NOT NULL THEN
968: fnd_file.put_line(fnd_file.LOG,'P60 Location id not null' || p60.asg_location_id);
969: OPEN csr_asg_empr_location(p60.asg_location_id);
970: FETCH csr_asg_empr_location INTO r_asg_empr_location;
971: CLOSE csr_asg_empr_location;
972:

Line 977: fnd_file.put_line(fnd_file.LOG,'P60 Address lines set');

973: l_er_address_line1 := test_XML(r_asg_empr_location.address_line1);
974: l_er_address_line2 := test_XML(r_asg_empr_location.address_line2);
975: l_er_address_line3 := test_XML(r_asg_empr_location.address_line3);
976: l_er_loc_name := test_XML(r_asg_empr_location.Location_name);
977: fnd_file.put_line(fnd_file.LOG,'P60 Address lines set');
978: ELSE
979: l_er_address_line1 := test_XML(p60.address_line1);
980: l_er_address_line2 := test_XML(p60.address_line2);
981: l_er_address_line3 := test_XML(p60.address_line3);

Line 983: fnd_file.put_line(fnd_file.LOG,'P60 Location id is null');

979: l_er_address_line1 := test_XML(p60.address_line1);
980: l_er_address_line2 := test_XML(p60.address_line2);
981: l_er_address_line3 := test_XML(p60.address_line3);
982: l_er_loc_name := test_XML(p60.Location_name);
983: fnd_file.put_line(fnd_file.LOG,'P60 Location id is null');
984: END IF;
985:
986: /* 10277535 end */
987: fnd_file.put_line(fnd_file.LOG,'entered if check for assignment_id' || p60.assignment_id);

Line 987: fnd_file.put_line(fnd_file.LOG,'entered if check for assignment_id' || p60.assignment_id);

983: fnd_file.put_line(fnd_file.LOG,'P60 Location id is null');
984: END IF;
985:
986: /* 10277535 end */
987: fnd_file.put_line(fnd_file.LOG,'entered if check for assignment_id' || p60.assignment_id);
988: vXMLTable(vCtr).xmlstring := '';
989: vXMLTable(vCtr).xmlstring := vXMLTable(vCtr).xmlstring || ''|| test_XML(p60.surname) ||'';
990: vXMLTable(vCtr).xmlstring := vXMLTable(vCtr).xmlstring || ''|| test_XML(p60.first_name) ||'';
991: vXMLTable(vCtr).xmlstring := vXMLTable(vCtr).xmlstring || ''|| p60.ppsn ||'';