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 153: fnd_file.put_line (fnd_file.LOG, l_warning_msg);

149: Fetch c_pqp_formula_id into v_formula_id;
150: if c_pqp_formula_id%NOTFOUND then
151: hr_utility.set_location('Formula -'||Formula_Tab(I)||'- Not Present/effective in Table',11);
152: l_warning_msg := 'Formula -'||Formula_Tab(I)||'- Not Present or effective for Assignment '||p_assignment_number||' On '||p_effective_date;
153: fnd_file.put_line (fnd_file.LOG, l_warning_msg);
154: fnd_file.put_line(FND_FILE.OUTPUT, l_warning_msg);
155: raise_application_error(-20001,' Invalid Formula ');
156: end if;
157: Close c_pqp_formula_id;

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

150: if c_pqp_formula_id%NOTFOUND then
151: hr_utility.set_location('Formula -'||Formula_Tab(I)||'- Not Present/effective in Table',11);
152: l_warning_msg := 'Formula -'||Formula_Tab(I)||'- Not Present or effective for Assignment '||p_assignment_number||' On '||p_effective_date;
153: fnd_file.put_line (fnd_file.LOG, l_warning_msg);
154: fnd_file.put_line(FND_FILE.OUTPUT, l_warning_msg);
155: raise_application_error(-20001,' Invalid Formula ');
156: end if;
157: Close c_pqp_formula_id;
158: if v_formula_id is not null then

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

180: END LOOP;
181: --executing the formula
182: ff_exec.run_formula(l_inputs,l_outputs);
183: hr_utility.trace(' calculated value from User formula '||l_outputs(1).value);
184: fnd_file.put_line(FND_FILE.OUTPUT,' ------ Formula '||Formula_Tab(I)||' value '||l_outputs(1).value);
185: n_sum_formula_val := n_sum_formula_val+ nvl(l_outputs(1).value,0);
186: End if; --formula id not null check 6666135
187: END LOOP;
188: hr_utility.trace(' Total value from all User formulas '||n_sum_formula_val);

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

198: FETCH c_seeded_element_det into c_seeded_element_det_row;
199: if c_seeded_element_det%NOTFOUND then
200: hr_utility.set_location(' Seeded Element is not linked ',11);
201: l_warning_msg := 'Seeded Element is not linked to the Payroll of Assignment '||p_assignment_number||' On '||p_effective_date;
202: fnd_file.put_line (fnd_file.LOG, l_warning_msg);
203: Raise Skip_formula;
204: end if;
205: CLOSE c_seeded_element_det;
206: v_eff_start_date := p_effective_date;

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

477: AND to_date('31/03/'||to_char(v_eff_start_date,'YYYY'),'dd/mm/yyyy')))
478: THEN
479: hr_utility.set_location('Start date and End date are in the same pension year ',6);
480: ELSE
481: fnd_file.put_line (fnd_file.LOG, 'Start date and End date should fall in the same pension year.');
482: hr_utility.set_location('Start date and End date should fall in the same tax year',8);
483: v_eff_start_date := Null; -- to exit the program
484: END IF;
485: END IF;

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

490: ,p_formula_id => l_formula_id
491: ,p_tab_asg_set_amnds => l_tab_asg_set_amnds
492: );
493: If l_formula_id is null and l_tab_asg_set_amnds.count = 0 then
494: fnd_file.put_line (fnd_file.LOG, ' Assignment set id entered '||p_assignment_set_id||' is not valid');
495: v_eff_start_date := Null; -- to exit the program
496: end if;
497: End if;
498: --6813970 end

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

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

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

662: b_rate_type := TRUE;
663: b_eng_rate := TRUE;
664: IF b_scot_rate = TRUE
665: THEN
666: fnd_file.put_line (fnd_file.LOG,'Assignment can not have both Types of RATE TYPE attached. Assignment Number : '||c_all_assignments.assignment_number);
667: CLOSE c1_all_element;
668: CLOSE c2_PQP_UK_RATE_TYPE;
669: RAISE skip_assignment;
670: END IF;

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

675: THEN
676: hr_utility.set_location('Pay Value Not Present',27);
677: IF l_ELEMENT_NAME IS NULL THEN
678: 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;
679: fnd_file.put_line (fnd_file.LOG, l_warning_msg);
680: END IF;
681: ELSE
682: b_input_value_present := TRUE;
683: hr_utility.set_location('Pay Value Present',28);

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

714: IF ((not b_element_present) or (not b_rate_type)) and k_aasgn_form_count = 0
715: THEN
716: 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;
717: --6813970 end
718: fnd_file.put_line (fnd_file.LOG, l_warning_msg);
719: l_lgps_process_flag := 'I';
720: hr_utility.set_location('Calling API to update LGPS Process Flag I',35);
721: pqp_aat_api.update_assignment_attribute
722: (p_validate => false

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

753: ----------
754: ELSE
755: IF l_mode is null then
756: l_warning_msg := 'Cannot process Assignment : '||c_all_assignments.assignment_number||' Future changes present in table pqp_assignment_attributes_f ';
757: fnd_file.put_line (fnd_file.LOG, l_warning_msg);
758: END IF;
759: raise skip_assignment;
760: END IF; --b_pqp_assignment_found
761:

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

769: IF ((not b_element_present) or (not b_rate_type)) and k_aasgn_form_count = 0
770: THEN
771: 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;
772: --6813970 end
773: fnd_file.put_line (fnd_file.LOG, l_warning_msg);
774: l_lgps_process_flag := 'I';
775: hr_utility.set_location('Calling API to insert LGPS Process Flag I',355);
776: pqp_aat_api.create_assignment_attribute
777: (p_effective_date => v_assignment_eff_date

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

802: ,p_rate_type_or_element => 'R');
803: Exception
804: when others then
805: l_warning_msg := 'Cannot process Assignment : '||c_all_assignments.assignment_number||' Historic Rate calculations failed. Please check the error message ';
806: fnd_file.put_line (fnd_file.LOG, l_warning_msg);
807: fnd_file.put_line (fnd_file.LOG,'*** -ERROR- '||SQLCODE||' - '||SQLERRM);
808: b_rate_type := FALSE; --to skip processing of user defined formulae
809: k_aasgn_form_count := 0; --to skip processing of user defined formulae --6813970
810: b_input_value_present := FALSE; --to make the LGPS process flag as Incomplete.

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

803: Exception
804: when others then
805: l_warning_msg := 'Cannot process Assignment : '||c_all_assignments.assignment_number||' Historic Rate calculations failed. Please check the error message ';
806: fnd_file.put_line (fnd_file.LOG, l_warning_msg);
807: fnd_file.put_line (fnd_file.LOG,'*** -ERROR- '||SQLCODE||' - '||SQLERRM);
808: b_rate_type := FALSE; --to skip processing of user defined formulae
809: k_aasgn_form_count := 0; --to skip processing of user defined formulae --6813970
810: b_input_value_present := FALSE; --to make the LGPS process flag as Incomplete.
811: End;

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

819: IF b_rate_type or k_aasgn_form_count > 0
820: THEN -- Rate type defined for atleast one element
821: --6813970 end
822: 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
823: fnd_file.put_line(FND_FILE.OUTPUT, ' Assignment '||c_all_assignments.assignment_number ||' Historic rate value '||nvl(l_lgps_pensionable_pay,0));
824: END IF;
825: IF k_aasgn_form_count > 0 then
826:
827: hr_utility.set_location(' Calling RUN_USER_FORMULA ',25);

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

844:
845: IF c_formula_pension_value is not null or l_lgps_pensionable_pay is not null
846: THEN
847: l_lgps_pensionable_pay := round(l_lgps_pensionable_pay,2);
848: fnd_file.put_line(FND_FILE.OUTPUT, '-----------------------------Total value '||nvl(l_lgps_pensionable_pay,0));
849: l_lgps_process_flag := 'P';
850: IF b_pqp_found
851: THEN
852: hr_utility.trace(' updating the Contractual pay for effective date '||v_max_date|| ' mode '||v_mode||' OVN '||n_object_version_no);