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.PQP_GB_LGPS_PENSIONPAY dependencies on FND_FILE

Line 142: fnd_file.put_line (fnd_file.LOG, l_warning_msg);

138: Fetch c_pqp_formula_id into v_formula_id;
139: if c_pqp_formula_id%NOTFOUND then
140: hr_utility.set_location('Formula -'||Formula_Tab(I)||'- Not Present/effective in Table',11);
141: l_warning_msg := 'Formula -'||Formula_Tab(I)||'- Not Present or effective for Assignment '||p_assignment_number||' On '||p_effective_date;
142: fnd_file.put_line (fnd_file.LOG, l_warning_msg);
143: fnd_file.put_line(FND_FILE.OUTPUT, l_warning_msg);
144: raise_application_error(-20001,' Invalid Formula ');
145: end if;
146: Close c_pqp_formula_id;

Line 143: fnd_file.put_line(FND_FILE.OUTPUT, l_warning_msg);

139: if c_pqp_formula_id%NOTFOUND then
140: hr_utility.set_location('Formula -'||Formula_Tab(I)||'- Not Present/effective in Table',11);
141: l_warning_msg := 'Formula -'||Formula_Tab(I)||'- Not Present or effective for Assignment '||p_assignment_number||' On '||p_effective_date;
142: fnd_file.put_line (fnd_file.LOG, l_warning_msg);
143: fnd_file.put_line(FND_FILE.OUTPUT, l_warning_msg);
144: raise_application_error(-20001,' Invalid Formula ');
145: end if;
146: Close c_pqp_formula_id;
147: if v_formula_id is not null then

Line 173: fnd_file.put_line(FND_FILE.OUTPUT,' ------ Formula '||Formula_Tab(I)||' value '||l_outputs(1).value);

169: END LOOP;
170: --executing the formula
171: ff_exec.run_formula(l_inputs,l_outputs);
172: hr_utility.trace(' calculated value from User formula '||l_outputs(1).value);
173: fnd_file.put_line(FND_FILE.OUTPUT,' ------ Formula '||Formula_Tab(I)||' value '||l_outputs(1).value);
174: n_sum_formula_val := n_sum_formula_val+ nvl(l_outputs(1).value,0);
175: End if; --formula id not null check 6666135
176: END LOOP;
177: hr_utility.trace(' Total value from all User formulas '||n_sum_formula_val);

Line 190: fnd_file.put_line (fnd_file.LOG, l_warning_msg);

186: FETCH c_seeded_element_det into c_seeded_element_det_row;
187: if c_seeded_element_det%NOTFOUND then
188: hr_utility.set_location(' Seeded Element is not linked ',11);
189: l_warning_msg := 'Seeded Element is not linked to the Payroll of Assignment '||p_assignment_number||' On '||p_effective_date;
190: fnd_file.put_line (fnd_file.LOG, l_warning_msg);
191: Raise Skip_formula;
192: end if;
193: CLOSE c_seeded_element_det;
194: v_eff_start_date := p_effective_date;

Line 468: fnd_file.put_line (fnd_file.LOG, 'Start date and End date should fall in the same pension year.');

464: AND to_date('31/03/'||to_char(v_eff_start_date,'YYYY'),'dd/mm/yyyy')))
465: THEN
466: hr_utility.set_location('Start date and End date are in the same pension year ',6);
467: ELSE
468: fnd_file.put_line (fnd_file.LOG, 'Start date and End date should fall in the same pension year.');
469: hr_utility.set_location('Start date and End date should fall in the same tax year',8);
470: v_eff_start_date := Null; -- to exit the program
471: END IF;
472: END IF;

Line 481: fnd_file.put_line (fnd_file.LOG, ' Assignment set id entered '||p_assignment_set_id||' is not valid');

477: ,p_formula_id => l_formula_id
478: ,p_tab_asg_set_amnds => l_tab_asg_set_amnds
479: );
480: If l_formula_id is null and l_tab_asg_set_amnds.count = 0 then
481: fnd_file.put_line (fnd_file.LOG, ' Assignment set id entered '||p_assignment_set_id||' is not valid');
482: v_eff_start_date := Null; -- to exit the program
483: end if;
484: End if;
485: --6813970 end

Line 639: fnd_file.put_line (fnd_file.LOG,'Assignment can not have both Types of RATE TYPE attached. Assignment Number : '||c_all_assignments.assignment_number);

635: THEN
636: b_scot_rate := TRUE;
637: IF b_eng_rate = TRUE
638: THEN
639: fnd_file.put_line (fnd_file.LOG,'Assignment can not have both Types of RATE TYPE attached. Assignment Number : '||c_all_assignments.assignment_number);
640: CLOSE c1_all_element;
641: CLOSE c2_PQP_UK_RATE_TYPE;
642: RAISE skip_assignment;
643: END IF;

Line 653: fnd_file.put_line (fnd_file.LOG,'Assignment can not have both Types of RATE TYPE attached. Assignment Number : '||c_all_assignments.assignment_number);

649: b_rate_type := TRUE;
650: b_eng_rate := TRUE;
651: IF b_scot_rate = TRUE
652: THEN
653: fnd_file.put_line (fnd_file.LOG,'Assignment can not have both Types of RATE TYPE attached. Assignment Number : '||c_all_assignments.assignment_number);
654: CLOSE c1_all_element;
655: CLOSE c2_PQP_UK_RATE_TYPE;
656: RAISE skip_assignment;
657: END IF;

Line 666: fnd_file.put_line (fnd_file.LOG, l_warning_msg);

662: THEN
663: hr_utility.set_location('Pay Value Not Present',27);
664: IF l_ELEMENT_NAME IS NULL THEN
665: l_warning_msg := 'PQP_LGPS_MISSING_HISTORIC_RATE_INFO: Historic Rate - Element Attribution information missing for Element '||c1_all_element_data.Element_name||' in Assignment '||c_all_assignments.assignment_number;
666: fnd_file.put_line (fnd_file.LOG, l_warning_msg);
667: END IF;
668: ELSE
669: b_input_value_present := TRUE;
670: hr_utility.set_location('Pay Value Present',28);

Line 705: fnd_file.put_line (fnd_file.LOG, l_warning_msg);

701: IF ((not b_element_present) or (not b_rate_type)) and k_aasgn_form_count = 0
702: THEN
703: l_warning_msg := 'PQP_LGPS_MISSING_RATE_INFO: Neither Historic Rate - Rate Type "LGPS Pensionable Pay" nor User defined formula set for elements against Assignment '||c_all_assignments.assignment_number;
704: --6813970 end
705: fnd_file.put_line (fnd_file.LOG, l_warning_msg);
706: l_lgps_process_flag := 'I';
707: hr_utility.set_location('Calling API to update LGPS Process Flag I',35);
708: pqp_aat_api.update_assignment_attribute
709: (p_validate => false

Line 744: fnd_file.put_line (fnd_file.LOG, l_warning_msg);

740: ----------
741: ELSE
742: IF l_mode is null then
743: l_warning_msg := 'Cannot process Assignment : '||c_all_assignments.assignment_number||' Future changes present in table pqp_assignment_attributes_f ';
744: fnd_file.put_line (fnd_file.LOG, l_warning_msg);
745: END IF;
746: raise skip_assignment;
747: END IF; --b_pqp_assignment_found
748:

Line 760: fnd_file.put_line (fnd_file.LOG, l_warning_msg);

756: IF ((not b_element_present) or (not b_rate_type)) and k_aasgn_form_count = 0
757: THEN
758: l_warning_msg := 'PQP_LGPS_MISSING_RATE_INFO: Neither Historic Rate - Rate Type "LGPS Pensionable Pay" nor User defined formula set for elements against Assignment '||c_all_assignments.assignment_number;
759: --6813970 end
760: fnd_file.put_line (fnd_file.LOG, l_warning_msg);
761: l_lgps_process_flag := 'I';
762: hr_utility.set_location('Calling API to insert LGPS Process Flag I',355);
763: pqp_aat_api.create_assignment_attribute
764: (p_effective_date => v_assignment_eff_date

Line 793: fnd_file.put_line (fnd_file.LOG, l_warning_msg);

789: ,p_rate_type_or_element => 'R');
790: Exception
791: when others then
792: l_warning_msg := 'Cannot process Assignment : '||c_all_assignments.assignment_number||' Historic Rate calculations failed. Please check the error message ';
793: fnd_file.put_line (fnd_file.LOG, l_warning_msg);
794: fnd_file.put_line (fnd_file.LOG,'*** -ERROR- '||SQLCODE||' - '||SQLERRM);
795: b_rate_type := FALSE; --to skip processing of user defined formulae
796: k_aasgn_form_count := 0; --to skip processing of user defined formulae --6813970
797: b_input_value_present := FALSE; --to make the LGPS process flag as Incomplete.

Line 794: fnd_file.put_line (fnd_file.LOG,'*** -ERROR- '||SQLCODE||' - '||SQLERRM);

790: Exception
791: when others then
792: l_warning_msg := 'Cannot process Assignment : '||c_all_assignments.assignment_number||' Historic Rate calculations failed. Please check the error message ';
793: fnd_file.put_line (fnd_file.LOG, l_warning_msg);
794: fnd_file.put_line (fnd_file.LOG,'*** -ERROR- '||SQLCODE||' - '||SQLERRM);
795: b_rate_type := FALSE; --to skip processing of user defined formulae
796: k_aasgn_form_count := 0; --to skip processing of user defined formulae --6813970
797: b_input_value_present := FALSE; --to make the LGPS process flag as Incomplete.
798: End;

Line 810: fnd_file.put_line(FND_FILE.OUTPUT, ' Assignment '||c_all_assignments.assignment_number ||' Historic rate value '||nvl(l_lgps_pensionable_pay,0));

806: IF b_rate_type or k_aasgn_form_count > 0
807: THEN -- Rate type defined for atleast one element
808: --6813970 end
809: IF b_input_value_present or k_aasgn_form_count > 0 then -- if b_input_value_present is true then Historic rates funciton will return value; if k_aasgn_form_count > 0 means user defined formula is attached
810: fnd_file.put_line(FND_FILE.OUTPUT, ' Assignment '||c_all_assignments.assignment_number ||' Historic rate value '||nvl(l_lgps_pensionable_pay,0));
811: END IF;
812: IF k_aasgn_form_count > 0 then
813:
814: hr_utility.set_location(' Calling RUN_USER_FORMULA ',25);

Line 830: fnd_file.put_line(FND_FILE.OUTPUT, '-----------------------------Total value '||nvl(l_lgps_pensionable_pay,0));

826:
827: IF c_formula_pension_value is not null or l_lgps_pensionable_pay is not null
828: THEN
829: l_lgps_pensionable_pay := round(l_lgps_pensionable_pay,2);
830: fnd_file.put_line(FND_FILE.OUTPUT, '-----------------------------Total value '||nvl(l_lgps_pensionable_pay,0));
831: l_lgps_process_flag := 'P';
832: IF b_pqp_found
833: THEN
834: hr_utility.trace(' updating the Contractual pay for effective date '||v_max_date|| ' mode '||v_mode||' OVN '||n_object_version_no);