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

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

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

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

Line 644: 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: THEN
641: b_eng_rate := TRUE;
642: IF b_scot_rate = TRUE
643: THEN
644: fnd_file.put_line (fnd_file.LOG,'Assignment can not have both Types of RATE TYPE attached. Assignment Number : '||c_all_assignments.assignment_number);
645: CLOSE c1_all_element;
646: CLOSE c2_PQP_UK_RATE_TYPE;
647: RAISE skip_assignment;
648: END IF;

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: -- 7369484 Begin
655: b_scot_rate := TRUE;
656: IF b_eng_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 671: fnd_file.put_line (fnd_file.LOG, l_warning_msg);

667: THEN
668: hr_utility.set_location('Pay Value Not Present',27);
669: IF l_ELEMENT_NAME IS NULL THEN
670: 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;
671: fnd_file.put_line (fnd_file.LOG, l_warning_msg);
672: END IF;
673: ELSE
674: b_input_value_present := TRUE;
675: hr_utility.set_location('Pay Value Present',28);

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

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

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

747: ----------
748: ELSE
749: IF l_mode is null then
750: l_warning_msg := 'Cannot process Assignment : '||c_all_assignments.assignment_number||' Future changes present in table pqp_assignment_attributes_f ';
751: fnd_file.put_line (fnd_file.LOG, l_warning_msg);
752: END IF;
753: raise skip_assignment;
754: END IF; --b_pqp_assignment_found
755:

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

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

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

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

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

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

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

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

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

833:
834: IF c_formula_pension_value is not null or l_lgps_pensionable_pay is not null
835: THEN
836: l_lgps_pensionable_pay := floor(l_lgps_pensionable_pay);
837: fnd_file.put_line(FND_FILE.OUTPUT, '-----------------------------Total value '||nvl(l_lgps_pensionable_pay,0));
838: l_lgps_process_flag := 'P';
839: IF b_pqp_found
840: THEN
841: hr_utility.trace(' updating the Contractual pay for effective date '||v_max_date|| ' mode '||v_mode||' OVN '||n_object_version_no);