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 HR_UTILITY

Line 137: hr_utility.trace(' PAYROLL_ACTION_ID '|| c_action_ids_row.PAYROLL_ACTION_ID);

133: p_inputs(6).name := 'ASSIGNMENT_ACTION_ID';
134: p_inputs(6).value := c_action_ids_row.ASSIGNMENT_ACTION_ID;
135: END IF;
136: CLOSE c_action_ids;
137: hr_utility.trace(' PAYROLL_ACTION_ID '|| c_action_ids_row.PAYROLL_ACTION_ID);
138: hr_utility.trace(' ASSIGNMENT_ACTION_ID '||c_action_ids_row.ASSIGNMENT_ACTION_ID);
139: hr_utility.trace(' p_assignment_id '||p_assignment_id);
140: hr_utility.trace('**Date earned '|| fnd_date.date_to_canonical(p_effective_date));
141: hr_utility.trace(' p_payroll_id '||p_payroll_id);

Line 138: hr_utility.trace(' ASSIGNMENT_ACTION_ID '||c_action_ids_row.ASSIGNMENT_ACTION_ID);

134: p_inputs(6).value := c_action_ids_row.ASSIGNMENT_ACTION_ID;
135: END IF;
136: CLOSE c_action_ids;
137: hr_utility.trace(' PAYROLL_ACTION_ID '|| c_action_ids_row.PAYROLL_ACTION_ID);
138: hr_utility.trace(' ASSIGNMENT_ACTION_ID '||c_action_ids_row.ASSIGNMENT_ACTION_ID);
139: hr_utility.trace(' p_assignment_id '||p_assignment_id);
140: hr_utility.trace('**Date earned '|| fnd_date.date_to_canonical(p_effective_date));
141: hr_utility.trace(' p_payroll_id '||p_payroll_id);
142:

Line 139: hr_utility.trace(' p_assignment_id '||p_assignment_id);

135: END IF;
136: CLOSE c_action_ids;
137: hr_utility.trace(' PAYROLL_ACTION_ID '|| c_action_ids_row.PAYROLL_ACTION_ID);
138: hr_utility.trace(' ASSIGNMENT_ACTION_ID '||c_action_ids_row.ASSIGNMENT_ACTION_ID);
139: hr_utility.trace(' p_assignment_id '||p_assignment_id);
140: hr_utility.trace('**Date earned '|| fnd_date.date_to_canonical(p_effective_date));
141: hr_utility.trace(' p_payroll_id '||p_payroll_id);
142:
143: -- 6666135 Begin

Line 140: hr_utility.trace('**Date earned '|| fnd_date.date_to_canonical(p_effective_date));

136: CLOSE c_action_ids;
137: hr_utility.trace(' PAYROLL_ACTION_ID '|| c_action_ids_row.PAYROLL_ACTION_ID);
138: hr_utility.trace(' ASSIGNMENT_ACTION_ID '||c_action_ids_row.ASSIGNMENT_ACTION_ID);
139: hr_utility.trace(' p_assignment_id '||p_assignment_id);
140: hr_utility.trace('**Date earned '|| fnd_date.date_to_canonical(p_effective_date));
141: hr_utility.trace(' p_payroll_id '||p_payroll_id);
142:
143: -- 6666135 Begin
144: FOR I in 1..Formula_Tab.COUNT

Line 141: hr_utility.trace(' p_payroll_id '||p_payroll_id);

137: hr_utility.trace(' PAYROLL_ACTION_ID '|| c_action_ids_row.PAYROLL_ACTION_ID);
138: hr_utility.trace(' ASSIGNMENT_ACTION_ID '||c_action_ids_row.ASSIGNMENT_ACTION_ID);
139: hr_utility.trace(' p_assignment_id '||p_assignment_id);
140: hr_utility.trace('**Date earned '|| fnd_date.date_to_canonical(p_effective_date));
141: hr_utility.trace(' p_payroll_id '||p_payroll_id);
142:
143: -- 6666135 Begin
144: FOR I in 1..Formula_Tab.COUNT
145: LOOP

Line 147: hr_utility.trace(' For Formula_Tab '||Formula_Tab(I));

143: -- 6666135 Begin
144: FOR I in 1..Formula_Tab.COUNT
145: LOOP
146: v_formula_id := Null;
147: hr_utility.trace(' For Formula_Tab '||Formula_Tab(I));
148: OPEN c_pqp_formula_id(Formula_Tab(I));
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);

Line 151: hr_utility.set_location('Formula -'||Formula_Tab(I)||'- Not Present/effective in Table',11);

147: hr_utility.trace(' For Formula_Tab '||Formula_Tab(I));
148: OPEN c_pqp_formula_id(Formula_Tab(I));
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 ');

Line 159: hr_utility.trace(' Inside RUN_USER_FORMULA '||Formula_Tab(I));

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
159: hr_utility.trace(' Inside RUN_USER_FORMULA '||Formula_Tab(I));
160: ff_exec.init_formula(v_formula_id, p_effective_date , l_inputs, l_outputs);
161: --6666135 End
162: --Assigning the contexts to the input variables
163: IF l_inputs.count > 0 and p_inputs.count > 0

Line 179: hr_utility.trace(' i= '||i||' name '||l_inputs(i).name ||' value '||l_inputs(i).value);

175: END LOOP;
176: END IF;
177: FOR i IN l_inputs.first..l_inputs.last
178: LOOP
179: hr_utility.trace(' i= '||i||' name '||l_inputs(i).name ||' value '||l_inputs(i).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);

Line 183: hr_utility.trace(' calculated value from User formula '||l_outputs(1).value);

179: hr_utility.trace(' i= '||i||' name '||l_inputs(i).name ||' value '||l_inputs(i).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;

Line 188: hr_utility.trace(' Total value from all User formulas '||n_sum_formula_val);

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);
189: --IF n_sum_formula_val > 0
190: IF (n_sum_formula_val + p_historic_value) >= 0 --For BugFix 8238736
191: THEN --if the formula returns value greater than 0 6666135
192: OPEN c_additional_pension(p_assignment_id

Line 196: hr_utility.trace(' Inserting seeded element with value'||n_sum_formula_val);

192: OPEN c_additional_pension(p_assignment_id
193: ,p_effective_date);
194: FETCH c_additional_pension INTO c_additional_pension_row;
195: IF c_additional_pension%NOTFOUND then
196: hr_utility.trace(' Inserting seeded element with value'||n_sum_formula_val);
197: OPEN c_seeded_element_det;
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);

Line 200: hr_utility.set_location(' Seeded Element is not linked ',11);

196: hr_utility.trace(' Inserting seeded element with value'||n_sum_formula_val);
197: OPEN c_seeded_element_det;
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;

Line 221: hr_utility.trace(' calling for correction of seeded element '||n_sum_formula_val);

217: p_input_value_id1 => c_seeded_element_det_row.input_value_id,
218: p_entry_value1 => to_char(n_sum_formula_val)
219: );
220: ELSE
221: hr_utility.trace(' calling for correction of seeded element '||n_sum_formula_val);
222: --6666135 End
223: hr_entry_api.update_element_entry (p_dt_update_mode =>'CORRECTION',
224: p_session_date => p_effective_date,
225: p_check_for_update =>'N',

Line 235: hr_utility.trace(' formula completed');

231:
232: END IF; --Seeded element present or not
233: CLOSE c_additional_pension;
234: END IF; -- formula returned value greater than zero
235: hr_utility.trace(' formula completed');
236: return n_sum_formula_val;
237: Exception
238: When Skip_formula then
239: --seeded element is not linked to Payroll so skipping

Line 242: hr_utility.trace(sqlerrm);

238: When Skip_formula then
239: --seeded element is not linked to Payroll so skipping
240: Null;
241: When others then
242: hr_utility.trace(sqlerrm);
243: Raise;
244: --6666135 End
245: END RUN_USER_FORMULA;
246:

Line 453: -- hr_utility.trace_on(null,'gag');

449: --7369484 End
450:
451: -- main
452: BEGIN
453: -- hr_utility.trace_on(null,'gag');
454: hr_utility.set_location('Entering: ' || l_proc, 10);
455: BEGIN
456: insert into fnd_sessions (SESSION_ID, EFFECTIVE_DATE)
457: values(userenv('sessionid'), trunc(SYSDATE));

Line 454: hr_utility.set_location('Entering: ' || l_proc, 10);

450:
451: -- main
452: BEGIN
453: -- hr_utility.trace_on(null,'gag');
454: hr_utility.set_location('Entering: ' || l_proc, 10);
455: BEGIN
456: insert into fnd_sessions (SESSION_ID, EFFECTIVE_DATE)
457: values(userenv('sessionid'), trunc(SYSDATE));
458: EXCEPTION

Line 460: hr_utility.trace('SESSION ALREADY EXISTS :'|| sqlerrm);

456: insert into fnd_sessions (SESSION_ID, EFFECTIVE_DATE)
457: values(userenv('sessionid'), trunc(SYSDATE));
458: EXCEPTION
459: WHEN others THEN
460: hr_utility.trace('SESSION ALREADY EXISTS :'|| sqlerrm);
461: Raise;
462: END;
463: v_eff_start_date := fnd_date.canonical_to_date(p_effective_start_dt);
464: --calculation of pension end date for the year

Line 485: hr_utility.set_location('Start date and End date are in the same pension year ',6);

481: AND to_date('31/03/'||to_char(v_eff_start_date,'YYYY'),'dd/mm/yyyy'))
482: AND (v_eff_end_date BETWEEN to_date('01/01/'||to_char(v_eff_start_date,'YYYY'),'dd/mm/yyyy')
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

Line 488: hr_utility.set_location('Start date and End date should fall in the same tax year',8);

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;
492: --6813970 begin

Line 513: hr_utility.trace(' Element_name '||j_formula_count|| Formula_Element_Tab(j_formula_count).Element_name);

509: loop
510: j_formula_count := j_formula_count+1;
511: Formula_Element_Tab(j_formula_count).Element_name := substr(I.PCV_INFORMATION1,1,instr(I.PCV_INFORMATION1,'|')-1);
512: Formula_Element_Tab(j_formula_count).Formula_name := substr(I.PCV_INFORMATION1,instr(I.PCV_INFORMATION1,'|')+1);
513: hr_utility.trace(' Element_name '||j_formula_count|| Formula_Element_Tab(j_formula_count).Element_name);
514: hr_utility.trace(' Formula_name '||j_formula_count|| Formula_Element_Tab(j_formula_count).Formula_name);
515: end loop;
516: --6666135 End
517:

Line 514: hr_utility.trace(' Formula_name '||j_formula_count|| Formula_Element_Tab(j_formula_count).Formula_name);

510: j_formula_count := j_formula_count+1;
511: Formula_Element_Tab(j_formula_count).Element_name := substr(I.PCV_INFORMATION1,1,instr(I.PCV_INFORMATION1,'|')-1);
512: Formula_Element_Tab(j_formula_count).Formula_name := substr(I.PCV_INFORMATION1,instr(I.PCV_INFORMATION1,'|')+1);
513: hr_utility.trace(' Element_name '||j_formula_count|| Formula_Element_Tab(j_formula_count).Element_name);
514: hr_utility.trace(' Formula_name '||j_formula_count|| Formula_Element_Tab(j_formula_count).Formula_name);
515: end loop;
516: --6666135 End
517:
518: v_eff_end_date_corr := v_eff_end_date;

Line 519: hr_utility.set_location('Effective Start Date: ' || p_effective_start_dt,1);

515: end loop;
516: --6666135 End
517:
518: v_eff_end_date_corr := v_eff_end_date;
519: hr_utility.set_location('Effective Start Date: ' || p_effective_start_dt,1);
520: hr_utility.set_location('Effective End Date: ' || p_effective_end_dt,2);
521: hr_utility.set_location('Calculated End Date: ' || v_eff_end_date_corr, 3);
522: hr_utility.set_location('Calculated Start Date: ' || v_eff_start_date, 3);
523: hr_utility.set_location('p_assignment_set_id: ' || p_assignment_set_id, 3);

Line 520: hr_utility.set_location('Effective End Date: ' || p_effective_end_dt,2);

516: --6666135 End
517:
518: v_eff_end_date_corr := v_eff_end_date;
519: hr_utility.set_location('Effective Start Date: ' || p_effective_start_dt,1);
520: hr_utility.set_location('Effective End Date: ' || p_effective_end_dt,2);
521: hr_utility.set_location('Calculated End Date: ' || v_eff_end_date_corr, 3);
522: hr_utility.set_location('Calculated Start Date: ' || v_eff_start_date, 3);
523: hr_utility.set_location('p_assignment_set_id: ' || p_assignment_set_id, 3);
524: hr_utility.set_location('p_assignment_number: ' || p_assignment_number, 3);

Line 521: hr_utility.set_location('Calculated End Date: ' || v_eff_end_date_corr, 3);

517:
518: v_eff_end_date_corr := v_eff_end_date;
519: hr_utility.set_location('Effective Start Date: ' || p_effective_start_dt,1);
520: hr_utility.set_location('Effective End Date: ' || p_effective_end_dt,2);
521: hr_utility.set_location('Calculated End Date: ' || v_eff_end_date_corr, 3);
522: hr_utility.set_location('Calculated Start Date: ' || v_eff_start_date, 3);
523: hr_utility.set_location('p_assignment_set_id: ' || p_assignment_set_id, 3);
524: hr_utility.set_location('p_assignment_number: ' || p_assignment_number, 3);
525: hr_utility.set_location('p_employee_no: ' || p_employee_no, 3);

Line 522: hr_utility.set_location('Calculated Start Date: ' || v_eff_start_date, 3);

518: v_eff_end_date_corr := v_eff_end_date;
519: hr_utility.set_location('Effective Start Date: ' || p_effective_start_dt,1);
520: hr_utility.set_location('Effective End Date: ' || p_effective_end_dt,2);
521: hr_utility.set_location('Calculated End Date: ' || v_eff_end_date_corr, 3);
522: hr_utility.set_location('Calculated Start Date: ' || v_eff_start_date, 3);
523: hr_utility.set_location('p_assignment_set_id: ' || p_assignment_set_id, 3);
524: hr_utility.set_location('p_assignment_number: ' || p_assignment_number, 3);
525: hr_utility.set_location('p_employee_no: ' || p_employee_no, 3);
526: hr_utility.set_location('p_payroll_id: ' || p_payroll_id, 3);

Line 523: hr_utility.set_location('p_assignment_set_id: ' || p_assignment_set_id, 3);

519: hr_utility.set_location('Effective Start Date: ' || p_effective_start_dt,1);
520: hr_utility.set_location('Effective End Date: ' || p_effective_end_dt,2);
521: hr_utility.set_location('Calculated End Date: ' || v_eff_end_date_corr, 3);
522: hr_utility.set_location('Calculated Start Date: ' || v_eff_start_date, 3);
523: hr_utility.set_location('p_assignment_set_id: ' || p_assignment_set_id, 3);
524: hr_utility.set_location('p_assignment_number: ' || p_assignment_number, 3);
525: hr_utility.set_location('p_employee_no: ' || p_employee_no, 3);
526: hr_utility.set_location('p_payroll_id: ' || p_payroll_id, 3);
527: hr_utility.set_location('p_business_group_id: ' || p_business_group_id, 3);

Line 524: hr_utility.set_location('p_assignment_number: ' || p_assignment_number, 3);

520: hr_utility.set_location('Effective End Date: ' || p_effective_end_dt,2);
521: hr_utility.set_location('Calculated End Date: ' || v_eff_end_date_corr, 3);
522: hr_utility.set_location('Calculated Start Date: ' || v_eff_start_date, 3);
523: hr_utility.set_location('p_assignment_set_id: ' || p_assignment_set_id, 3);
524: hr_utility.set_location('p_assignment_number: ' || p_assignment_number, 3);
525: hr_utility.set_location('p_employee_no: ' || p_employee_no, 3);
526: hr_utility.set_location('p_payroll_id: ' || p_payroll_id, 3);
527: hr_utility.set_location('p_business_group_id: ' || p_business_group_id, 3);
528: hr_utility.set_location('p_mode: ' || p_mode, 3);

Line 525: hr_utility.set_location('p_employee_no: ' || p_employee_no, 3);

521: hr_utility.set_location('Calculated End Date: ' || v_eff_end_date_corr, 3);
522: hr_utility.set_location('Calculated Start Date: ' || v_eff_start_date, 3);
523: hr_utility.set_location('p_assignment_set_id: ' || p_assignment_set_id, 3);
524: hr_utility.set_location('p_assignment_number: ' || p_assignment_number, 3);
525: hr_utility.set_location('p_employee_no: ' || p_employee_no, 3);
526: hr_utility.set_location('p_payroll_id: ' || p_payroll_id, 3);
527: hr_utility.set_location('p_business_group_id: ' || p_business_group_id, 3);
528: hr_utility.set_location('p_mode: ' || p_mode, 3);
529: IF p_mode = 'Reprocess'

Line 526: hr_utility.set_location('p_payroll_id: ' || p_payroll_id, 3);

522: hr_utility.set_location('Calculated Start Date: ' || v_eff_start_date, 3);
523: hr_utility.set_location('p_assignment_set_id: ' || p_assignment_set_id, 3);
524: hr_utility.set_location('p_assignment_number: ' || p_assignment_number, 3);
525: hr_utility.set_location('p_employee_no: ' || p_employee_no, 3);
526: hr_utility.set_location('p_payroll_id: ' || p_payroll_id, 3);
527: hr_utility.set_location('p_business_group_id: ' || p_business_group_id, 3);
528: hr_utility.set_location('p_mode: ' || p_mode, 3);
529: IF p_mode = 'Reprocess'
530: THEN

Line 527: hr_utility.set_location('p_business_group_id: ' || p_business_group_id, 3);

523: hr_utility.set_location('p_assignment_set_id: ' || p_assignment_set_id, 3);
524: hr_utility.set_location('p_assignment_number: ' || p_assignment_number, 3);
525: hr_utility.set_location('p_employee_no: ' || p_employee_no, 3);
526: hr_utility.set_location('p_payroll_id: ' || p_payroll_id, 3);
527: hr_utility.set_location('p_business_group_id: ' || p_business_group_id, 3);
528: hr_utility.set_location('p_mode: ' || p_mode, 3);
529: IF p_mode = 'Reprocess'
530: THEN
531: l_mode := 'Y';

Line 528: hr_utility.set_location('p_mode: ' || p_mode, 3);

524: hr_utility.set_location('p_assignment_number: ' || p_assignment_number, 3);
525: hr_utility.set_location('p_employee_no: ' || p_employee_no, 3);
526: hr_utility.set_location('p_payroll_id: ' || p_payroll_id, 3);
527: hr_utility.set_location('p_business_group_id: ' || p_business_group_id, 3);
528: hr_utility.set_location('p_mode: ' || p_mode, 3);
529: IF p_mode = 'Reprocess'
530: THEN
531: l_mode := 'Y';
532: ELSIF p_mode = 'Incomplete'

Line 537: hr_utility.set_location('l_mode: ' || l_mode, 3);

533: THEN
534: l_mode := 'I';
535: END IF;
536: --
537: hr_utility.set_location('l_mode: ' || l_mode, 3);
538: FOR c_all_assignments in c_all_valid_assignment
539: LOOP
540: Begin
541: hr_utility.set_location('Inside valid Assignments'||c_all_assignments.assignment_id,20);

Line 541: hr_utility.set_location('Inside valid Assignments'||c_all_assignments.assignment_id,20);

537: hr_utility.set_location('l_mode: ' || l_mode, 3);
538: FOR c_all_assignments in c_all_valid_assignment
539: LOOP
540: Begin
541: hr_utility.set_location('Inside valid Assignments'||c_all_assignments.assignment_id,20);
542:
543: if nvl(n_prev_assignment_id,'0.000') = c_all_assignments.assignment_id then
544: raise skip_assignment;
545: end if;

Line 621: hr_utility.set_location('Inside valid Elements for the Assignment'||c_all_assignments.assignment_id,20);

617:
618: OPEN c1_all_element(c_all_assignments.assignment_id);
619: LOOP
620: BEGIN
621: hr_utility.set_location('Inside valid Elements for the Assignment'||c_all_assignments.assignment_id,20);
622: FETCH c1_all_element into c1_all_element_data;
623: IF c1_all_element%NOTFOUND
624: THEN
625: CLOSE c1_all_element;

Line 628: hr_utility.set_location('Checking for Historic rate type',25);

624: THEN
625: CLOSE c1_all_element;
626: EXIT;
627: END IF;
628: hr_utility.set_location('Checking for Historic rate type',25);
629: b_element_present := TRUE;
630:
631: l_ELEMENT_NAME := null;
632:

Line 666: hr_utility.set_location('Historic Rate Type present for Element '||c1_all_element_data.element_type_id,26);

662: END IF;
663: ELSIF c2_PQP_UK_RATE_TYPE_data.EEI_INFORMATION1 = 'PQP_LGPS_SCOTLAND_PENSION_PAY'
664: THEN
665: -- 7369484 End
666: hr_utility.set_location('Historic Rate Type present for Element '||c1_all_element_data.element_type_id,26);
667: b_rate_type := TRUE;
668: -- 7369484 Begin
669: b_scot_rate := TRUE;
670: IF b_eng_rate = TRUE

Line 682: hr_utility.set_location('Pay Value Not Present',27);

678: OPEN c3_pqp_lgps_pension_pay(c1_all_element_data.element_type_id);
679: FETCH c3_pqp_lgps_pension_pay INTO c3_pqp_lgps_pension_pay_data;
680: IF c3_pqp_lgps_pension_pay%NOTFOUND
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;

Line 689: hr_utility.set_location('Pay Value Present',28);

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);
690: END IF;
691: CLOSE c2_PQP_UK_RATE_TYPE;
692: CLOSE c3_pqp_lgps_pension_pay;
693: EXCEPTION

Line 717: hr_utility.set_location('Mode for update v_mode: ' || v_mode, 3);

713: v_mode := 'UPDATE_CHANGE_INSERT';
714: ELSE
715: v_mode := 'UPDATE';
716: END IF;
717: hr_utility.set_location('Mode for update v_mode: ' || v_mode, 3);
718: --6813970 begin
719: -- IF (not b_element_present) or (not b_rate_type)
720: -- THEN
721: -- l_warning_msg := 'PQP_LGPS_MISSING_RATE_INFO: Historic Rate - Rate Type "LGPS Pensionable Pay" not set for elements against Assignment '||c_all_assignments.assignment_number;

Line 728: hr_utility.set_location('Calling API to update LGPS Process Flag I',35);

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
731: ,p_effective_date => v_assignment_eff_date --v_eff_start_date
732: ,p_datetrack_mode => v_mode

Line 783: hr_utility.set_location('Calling API to insert LGPS Process Flag I',355);

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
786: ,p_business_group_id => p_business_group_id
787: ,p_assignment_id => c_all_assignments.assignment_id

Line 821: hr_utility.set_location('Calculated Pensionable Pay'||l_lgps_pensionable_pay,40);

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;
820: END IF;
821: hr_utility.set_location('Calculated Pensionable Pay'||l_lgps_pensionable_pay,40);
822:
823: ---- To calculate the value from user defined formula and add it to the value from historic rates function
824: --6813970 begin
825: -- IF b_rate_type

Line 835: hr_utility.set_location(' Calling RUN_USER_FORMULA ',25);

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);
836: -- Call the formula to calculate the additional pension pay
837: /* Bug fix 8238736 Start
838: c_formula_pension_value := RUN_USER_FORMULA(c_all_assignments.assignment_id , v_assignment_eff_date , p_business_group_id , c_all_assignments.payroll_id, Formula_Tab , c_all_assignments.assignment_number);
839: */

Line 842: hr_utility.set_location(' formula returned value '||c_formula_pension_value,40);

838: c_formula_pension_value := RUN_USER_FORMULA(c_all_assignments.assignment_id , v_assignment_eff_date , p_business_group_id , c_all_assignments.payroll_id, Formula_Tab , c_all_assignments.assignment_number);
839: */
840: c_formula_pension_value := RUN_USER_FORMULA(c_all_assignments.assignment_id , v_assignment_eff_date , p_business_group_id , c_all_assignments.payroll_id, Formula_Tab , c_all_assignments.assignment_number, nvl(l_lgps_pensionable_pay,0));
841: -- Bug fix 8238736 End
842: hr_utility.set_location(' formula returned value '||c_formula_pension_value,40);
843:
844: --IF nvl(c_formula_pension_value,0) >= 0 -- equal to condition is added for bug 6857280
845: IF ( (nvl(c_formula_pension_value,0) + NVL(l_lgps_pensionable_pay,0)) >=0 ) -- BugFix 8238736
846: THEN

Line 849: hr_utility.set_location('After adding additional Pension Value'||l_lgps_pensionable_pay,42);

845: IF ( (nvl(c_formula_pension_value,0) + NVL(l_lgps_pensionable_pay,0)) >=0 ) -- BugFix 8238736
846: THEN
847: l_lgps_pensionable_pay := NVL(l_lgps_pensionable_pay,0) + c_formula_pension_value;
848: END IF;
849: hr_utility.set_location('After adding additional Pension Value'||l_lgps_pensionable_pay,42);
850:
851: END IF; --check for presence of formula in configuration value screen
852:
853: IF c_formula_pension_value is not null or l_lgps_pensionable_pay is not null

Line 860: hr_utility.trace(' updating the Contractual pay for effective date '||v_max_date|| ' mode '||v_mode||' OVN '||n_object_version_no);

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);
861: pqp_aat_api.update_assignment_attribute
862: (p_validate => false
863: ,p_effective_date => v_assignment_eff_date --v_eff_start_date
864: ,p_datetrack_mode => v_mode

Line 895: hr_utility.set_location('Inserting the Contractual pay for effective date'||v_assignment_eff_date,555);

891: );
892: END LOOP;
893:
894: Else
895: hr_utility.set_location('Inserting the Contractual pay for effective date'||v_assignment_eff_date,555);
896: pqp_aat_api.create_assignment_attribute
897: (p_effective_date => v_assignment_eff_date
898: ,p_business_group_id => p_business_group_id
899: ,p_assignment_id => c_all_assignments.assignment_id

Line 909: hr_utility.set_location('After updating Process flag to P'||c_all_assignments.assignment_id,45);

905: ,p_lgps_pensionable_pay => l_lgps_pensionable_pay
906: );
907: END IF; -- b_pqp_found
908: END IF; -- check for l_lgps_pensionable_pay
909: hr_utility.set_location('After updating Process flag to P'||c_all_assignments.assignment_id,45);
910: Raise skip_assignment;
911: END IF; --rate type entered
912:
913:

Line 918: hr_utility.set_location('Calling API to update LGPS Process Flag I',30);

914: IF b_pqp_found THEN
915: IF (not b_input_value_present)
916: THEN
917: l_lgps_process_flag := 'I';
918: hr_utility.set_location('Calling API to update LGPS Process Flag I',30);
919: pqp_aat_api.update_assignment_attribute
920: (p_validate => false
921: ,p_effective_date => v_assignment_eff_date --v_eff_start_date
922: ,p_datetrack_mode => v_mode

Line 954: hr_utility.set_location('Calling API to insert LGPS Process Flag I',305);

950: Else
951: IF (not b_input_value_present)
952: THEN
953: l_lgps_process_flag := 'I';
954: hr_utility.set_location('Calling API to insert LGPS Process Flag I',305);
955: pqp_aat_api.create_assignment_attribute
956: (p_effective_date => v_assignment_eff_date
957: ,p_business_group_id => p_business_group_id
958: ,p_assignment_id => c_all_assignments.assignment_id

Line 970: hr_utility.set_location('Skipped Assignment'||c_all_assignments.assignment_id,45);

966: END IF;
967:
968: Exception
969: when skip_assignment then
970: hr_utility.set_location('Skipped Assignment'||c_all_assignments.assignment_id,45);
971: END;
972: END LOOP; --loop for all valid assignments
973: COMMIT;
974: hr_utility.set_location('Leaving: ' || l_proc, 100);

Line 974: hr_utility.set_location('Leaving: ' || l_proc, 100);

970: hr_utility.set_location('Skipped Assignment'||c_all_assignments.assignment_id,45);
971: END;
972: END LOOP; --loop for all valid assignments
973: COMMIT;
974: hr_utility.set_location('Leaving: ' || l_proc, 100);
975: END DERIVE_PENSIONABLE_PAY;
976: ---------------------------------------------------------------------
977: /* This section of code is ued by the formula functions
978: which inturn will be call from the pension element fast formula */