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_SCOTLAND_LGPS_PENSIONPY 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 487: fnd_file.put_line (fnd_file.LOG, 'Start date and End date should fall in the same pension year.');

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

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

496: ,p_formula_id => l_formula_id
497: ,p_tab_asg_set_amnds => l_tab_asg_set_amnds
498: );
499: If l_formula_id is null and l_tab_asg_set_amnds.count = 0 then
500: fnd_file.put_line (fnd_file.LOG, ' Assignment set id entered '||p_assignment_set_id||' is not valid');
501: v_eff_start_date := Null; -- to exit the program
502: end if;
503: End if;
504: --6813970 end

Line 658: 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: THEN
655: b_eng_rate := TRUE;
656: IF b_scot_rate = TRUE
657: THEN
658: fnd_file.put_line (fnd_file.LOG,'Assignment can not have both Types of RATE TYPE attached. Assignment Number : '||c_all_assignments.assignment_number);
659: CLOSE c1_all_element;
660: CLOSE c2_PQP_UK_RATE_TYPE;
661: RAISE skip_assignment;
662: END IF;

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

668: -- 7369484 Begin
669: b_scot_rate := TRUE;
670: IF b_eng_rate = TRUE
671: THEN
672: fnd_file.put_line (fnd_file.LOG,'Assignment can not have both Types of RATE TYPE attached. Assignment Number : '||c_all_assignments.assignment_number);
673: CLOSE c1_all_element;
674: CLOSE c2_PQP_UK_RATE_TYPE;
675: RAISE skip_assignment;
676: END IF;

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

681: THEN
682: hr_utility.set_location('Pay Value Not Present',27);
683: IF l_ELEMENT_NAME IS NULL THEN
684: 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;
685: fnd_file.put_line (fnd_file.LOG, l_warning_msg);
686: END IF;
687: ELSE
688: b_input_value_present := TRUE;
689: hr_utility.set_location('Pay Value Present',28);

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

722: IF ((not b_element_present) or (not b_rate_type)) and k_aasgn_form_count = 0
723: THEN
724: l_warning_msg := 'PQP_LGPS_MISSING_RATE_INFO: Neither Historic Rate - Rate Type "LGPS Scotland Pensionable Pay" nor User defined formula set for elements against Assignment '||c_all_assignments.assignment_number;
725: --6813970 end
726: fnd_file.put_line (fnd_file.LOG, l_warning_msg);
727: l_lgps_process_flag := 'I';
728: hr_utility.set_location('Calling API to update LGPS Process Flag I',35);
729: pqp_aat_api.update_assignment_attribute
730: (p_validate => false

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

761: ----------
762: ELSE
763: IF l_mode is null then
764: l_warning_msg := 'Cannot process Assignment : '||c_all_assignments.assignment_number||' Future changes present in table pqp_assignment_attributes_f ';
765: fnd_file.put_line (fnd_file.LOG, l_warning_msg);
766: END IF;
767: raise skip_assignment;
768: END IF; --b_pqp_assignment_found
769:

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

777: IF ((not b_element_present) or (not b_rate_type)) and k_aasgn_form_count = 0
778: THEN
779: l_warning_msg := 'PQP_LGPS_MISSING_RATE_INFO: Neither Historic Rate - Rate Type "LGPS Scotland Pensionable Pay" nor User defined formula set for elements against Assignment '||c_all_assignments.assignment_number;
780: --6813970 end
781: fnd_file.put_line (fnd_file.LOG, l_warning_msg);
782: l_lgps_process_flag := 'I';
783: hr_utility.set_location('Calling API to insert LGPS Process Flag I',355);
784: pqp_aat_api.create_assignment_attribute
785: (p_effective_date => v_assignment_eff_date

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

810: ,p_rate_type_or_element => 'R');
811: Exception
812: when others then
813: l_warning_msg := 'Cannot process Assignment : '||c_all_assignments.assignment_number||' Historic Rate calculations failed. Please check the error message ';
814: fnd_file.put_line (fnd_file.LOG, l_warning_msg);
815: fnd_file.put_line (fnd_file.LOG,'*** -ERROR- '||SQLCODE||' - '||SQLERRM);
816: b_rate_type := FALSE; --to skip processing of user defined formulae
817: k_aasgn_form_count := 0; --to skip processing of user defined formulae --6813970
818: b_input_value_present := FALSE; --to make the LGPS process flag as Incomplete.

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

811: Exception
812: when others then
813: l_warning_msg := 'Cannot process Assignment : '||c_all_assignments.assignment_number||' Historic Rate calculations failed. Please check the error message ';
814: fnd_file.put_line (fnd_file.LOG, l_warning_msg);
815: fnd_file.put_line (fnd_file.LOG,'*** -ERROR- '||SQLCODE||' - '||SQLERRM);
816: b_rate_type := FALSE; --to skip processing of user defined formulae
817: k_aasgn_form_count := 0; --to skip processing of user defined formulae --6813970
818: b_input_value_present := FALSE; --to make the LGPS process flag as Incomplete.
819: End;

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

827: IF b_rate_type or k_aasgn_form_count > 0
828: THEN -- Rate type defined for atleast one element
829: --6813970 end
830: 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
831: fnd_file.put_line(FND_FILE.OUTPUT, ' Assignment '||c_all_assignments.assignment_number ||' Historic rate value '||nvl(l_lgps_pensionable_pay,0));
832: END IF;
833: IF k_aasgn_form_count > 0 then
834:
835: hr_utility.set_location(' Calling RUN_USER_FORMULA ',25);

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

852:
853: IF c_formula_pension_value is not null or l_lgps_pensionable_pay is not null
854: THEN
855: l_lgps_pensionable_pay := floor(l_lgps_pensionable_pay);
856: fnd_file.put_line(FND_FILE.OUTPUT, '-----------------------------Total value '||nvl(l_lgps_pensionable_pay,0));
857: l_lgps_process_flag := 'P';
858: IF b_pqp_found
859: THEN
860: hr_utility.trace(' updating the Contractual pay for effective date '||v_max_date|| ' mode '||v_mode||' OVN '||n_object_version_no);