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_PCSPS_PENSIONPAY dependencies on HR_UTILITY

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

151: p_inputs(8).name := 'ASSIGNMENT_ACTION_ID';
152: p_inputs(8).value := c_action_ids_row.ASSIGNMENT_ACTION_ID;
153: END IF;
154: CLOSE c_action_ids;
155: hr_utility.trace(' PAYROLL_ACTION_ID '|| c_action_ids_row.PAYROLL_ACTION_ID);
156: hr_utility.trace(' ASSIGNMENT_ACTION_ID '||c_action_ids_row.ASSIGNMENT_ACTION_ID);
157: hr_utility.trace(' p_assignment_id '||p_assignment_id);
158: hr_utility.trace('**Date earned '|| fnd_date.date_to_canonical(p_effective_date));
159: hr_utility.trace(' p_payroll_id '||p_payroll_id);

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

152: p_inputs(8).value := c_action_ids_row.ASSIGNMENT_ACTION_ID;
153: END IF;
154: CLOSE c_action_ids;
155: hr_utility.trace(' PAYROLL_ACTION_ID '|| c_action_ids_row.PAYROLL_ACTION_ID);
156: hr_utility.trace(' ASSIGNMENT_ACTION_ID '||c_action_ids_row.ASSIGNMENT_ACTION_ID);
157: hr_utility.trace(' p_assignment_id '||p_assignment_id);
158: hr_utility.trace('**Date earned '|| fnd_date.date_to_canonical(p_effective_date));
159: hr_utility.trace(' p_payroll_id '||p_payroll_id);
160:

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

153: END IF;
154: CLOSE c_action_ids;
155: hr_utility.trace(' PAYROLL_ACTION_ID '|| c_action_ids_row.PAYROLL_ACTION_ID);
156: hr_utility.trace(' ASSIGNMENT_ACTION_ID '||c_action_ids_row.ASSIGNMENT_ACTION_ID);
157: hr_utility.trace(' p_assignment_id '||p_assignment_id);
158: hr_utility.trace('**Date earned '|| fnd_date.date_to_canonical(p_effective_date));
159: hr_utility.trace(' p_payroll_id '||p_payroll_id);
160:
161: -- 6666135 Begin

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

154: CLOSE c_action_ids;
155: hr_utility.trace(' PAYROLL_ACTION_ID '|| c_action_ids_row.PAYROLL_ACTION_ID);
156: hr_utility.trace(' ASSIGNMENT_ACTION_ID '||c_action_ids_row.ASSIGNMENT_ACTION_ID);
157: hr_utility.trace(' p_assignment_id '||p_assignment_id);
158: hr_utility.trace('**Date earned '|| fnd_date.date_to_canonical(p_effective_date));
159: hr_utility.trace(' p_payroll_id '||p_payroll_id);
160:
161: -- 6666135 Begin
162: FOR I in 1..Formula_Tab.COUNT

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

155: hr_utility.trace(' PAYROLL_ACTION_ID '|| c_action_ids_row.PAYROLL_ACTION_ID);
156: hr_utility.trace(' ASSIGNMENT_ACTION_ID '||c_action_ids_row.ASSIGNMENT_ACTION_ID);
157: hr_utility.trace(' p_assignment_id '||p_assignment_id);
158: hr_utility.trace('**Date earned '|| fnd_date.date_to_canonical(p_effective_date));
159: hr_utility.trace(' p_payroll_id '||p_payroll_id);
160:
161: -- 6666135 Begin
162: FOR I in 1..Formula_Tab.COUNT
163: LOOP

Line 164: hr_utility.trace(' For Formula_Tab Formula'||Formula_Tab(I).Formula_name);

160:
161: -- 6666135 Begin
162: FOR I in 1..Formula_Tab.COUNT
163: LOOP
164: hr_utility.trace(' For Formula_Tab Formula'||Formula_Tab(I).Formula_name);
165: p_inputs(5).name := 'ELEMENT_TYPE_ID';
166: p_inputs(5).value := Formula_Tab(I).Element_type_id;
167: p_inputs(6).name := 'ELEMENT_ENTRY_ID';
168: p_inputs(6).value := Formula_Tab(I).Element_entry_id;

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

170:
171: OPEN c_pqp_formula_id(Formula_Tab(I).Formula_name);
172: Fetch c_pqp_formula_id into v_formula_id;
173: if c_pqp_formula_id%NOTFOUND then
174: hr_utility.set_location('Formula -'||Formula_Tab(I).Formula_name||'- Not Present/effective in Table',11);
175: l_warning_msg := 'Formula -'||Formula_Tab(I).Formula_name||'- Not Present or effective for Assignment '||p_assignment_number||' On '||p_effective_date;
176: fnd_file.put_line (fnd_file.LOG, l_warning_msg);
177: fnd_file.put_line(FND_FILE.OUTPUT, l_warning_msg);
178: raise_application_error(-20001,' Invalid Formula ');

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

178: raise_application_error(-20001,' Invalid Formula ');
179: end if;
180: Close c_pqp_formula_id;
181: if v_formula_id is not null then
182: hr_utility.trace(' Inside RUN_USER_FORMULA '||Formula_Tab(I).Formula_name);
183: ff_exec.init_formula(v_formula_id, p_effective_date , l_inputs, l_outputs);
184: --6666135 End
185: --Assigning the contexts to the input variables
186: IF l_inputs.count > 0 and p_inputs.count > 0

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

198: END LOOP;
199: END IF;
200: FOR i IN l_inputs.first..l_inputs.last
201: LOOP
202: hr_utility.trace(' i= '||i||' name '||l_inputs(i).name ||' value '||l_inputs(i).value);
203: END LOOP;
204: --executing the formula
205: ff_exec.run_formula(l_inputs,l_outputs);
206: hr_utility.trace(' calculated value from User formula '||l_outputs(1).value);

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

202: hr_utility.trace(' i= '||i||' name '||l_inputs(i).name ||' value '||l_inputs(i).value);
203: END LOOP;
204: --executing the formula
205: ff_exec.run_formula(l_inputs,l_outputs);
206: hr_utility.trace(' calculated value from User formula '||l_outputs(1).value);
207: fnd_file.put_line(FND_FILE.OUTPUT,' ------ Formula '||Formula_Tab(I).Formula_name||' value '||l_outputs(1).value);
208: n_sum_formula_val := n_sum_formula_val+ nvl(l_outputs(1).value,0);
209: End if; --formula id not null check 6666135
210: END LOOP;

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

207: fnd_file.put_line(FND_FILE.OUTPUT,' ------ Formula '||Formula_Tab(I).Formula_name||' value '||l_outputs(1).value);
208: n_sum_formula_val := n_sum_formula_val+ nvl(l_outputs(1).value,0);
209: End if; --formula id not null check 6666135
210: END LOOP;
211: hr_utility.trace(' Total value from all User formulas '||n_sum_formula_val);
212: --IF n_sum_formula_val > 0
213: /* IF (n_sum_formula_val + p_historic_value) >= 0 --For BugFix 8238736
214: THEN --if the formula returns value greater than 0 6666135
215: OPEN c_additional_pension(p_assignment_id

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

215: OPEN c_additional_pension(p_assignment_id
216: ,p_effective_date);
217: FETCH c_additional_pension INTO c_additional_pension_row;
218: IF c_additional_pension%NOTFOUND then
219: hr_utility.trace(' Inserting seeded element with value'||n_sum_formula_val);
220: OPEN c_seeded_element_det;
221: FETCH c_seeded_element_det into c_seeded_element_det_row;
222: if c_seeded_element_det%NOTFOUND then
223: hr_utility.set_location(' Seeded Element is not linked ',11);

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

219: hr_utility.trace(' Inserting seeded element with value'||n_sum_formula_val);
220: OPEN c_seeded_element_det;
221: FETCH c_seeded_element_det into c_seeded_element_det_row;
222: if c_seeded_element_det%NOTFOUND then
223: hr_utility.set_location(' Seeded Element is not linked ',11);
224: l_warning_msg := 'Seeded Element is not linked to the Payroll of Assignment '||p_assignment_number||' On '||p_effective_date;
225: fnd_file.put_line (fnd_file.LOG, l_warning_msg);
226: Raise Skip_formula;
227: end if;

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

240: p_input_value_id1 => c_seeded_element_det_row.input_value_id,
241: p_entry_value1 => to_char(n_sum_formula_val)
242: );
243: ELSE
244: hr_utility.trace(' calling for correction of seeded element '||n_sum_formula_val);
245: --6666135 End
246: hr_entry_api.update_element_entry (p_dt_update_mode =>'CORRECTION',
247: p_session_date => p_effective_date,
248: p_check_for_update =>'N',

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

256: CLOSE c_additional_pension;
257:
258: END IF; -- formula returned value greater than zero
259: */
260: hr_utility.trace(' formula completed');
261:
262: return n_sum_formula_val;
263: Exception
264: When Skip_formula then

Line 268: hr_utility.trace(sqlerrm);

264: When Skip_formula then
265: --seeded element is not linked to Payroll so skipping
266: Null;
267: When others then
268: hr_utility.trace(sqlerrm);
269: Raise;
270: --6666135 End
271: END RUN_USER_FORMULA;
272:

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

489: --6813970 end
490:
491: -- main
492: BEGIN
493: -- hr_utility.trace_on(null,'gag');
494: hr_utility.set_location('Entering: ' || l_proc, 10);
495: BEGIN
496: insert into fnd_sessions (SESSION_ID, EFFECTIVE_DATE)
497: values(userenv('sessionid'), trunc(SYSDATE));

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

490:
491: -- main
492: BEGIN
493: -- hr_utility.trace_on(null,'gag');
494: hr_utility.set_location('Entering: ' || l_proc, 10);
495: BEGIN
496: insert into fnd_sessions (SESSION_ID, EFFECTIVE_DATE)
497: values(userenv('sessionid'), trunc(SYSDATE));
498: EXCEPTION

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

496: insert into fnd_sessions (SESSION_ID, EFFECTIVE_DATE)
497: values(userenv('sessionid'), trunc(SYSDATE));
498: EXCEPTION
499: WHEN others THEN
500: hr_utility.trace('SESSION ALREADY EXISTS :'|| sqlerrm);
501: Raise;
502: END;
503: v_eff_start_date := fnd_date.canonical_to_date(p_effective_start_dt);
504: --calculation of pension end date for the year

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

521: AND to_date('31/03/'||to_char(v_eff_start_date,'YYYY'),'dd/mm/yyyy'))
522: AND (v_eff_end_date BETWEEN to_date('01/01/'||to_char(v_eff_start_date,'YYYY'),'dd/mm/yyyy')
523: AND to_date('31/03/'||to_char(v_eff_start_date,'YYYY'),'dd/mm/yyyy')))
524: THEN
525: hr_utility.set_location('Start date and End date are in the same pension year ',6);
526: ELSE
527: fnd_file.put_line (fnd_file.LOG, 'Start date and End date should fall in the same pension year.');
528: hr_utility.set_location('Start date and End date should fall in the same tax year',8);
529: v_eff_start_date := Null; -- to exit the program

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

524: THEN
525: hr_utility.set_location('Start date and End date are in the same pension year ',6);
526: ELSE
527: fnd_file.put_line (fnd_file.LOG, 'Start date and End date should fall in the same pension year.');
528: hr_utility.set_location('Start date and End date should fall in the same tax year',8);
529: v_eff_start_date := Null; -- to exit the program
530: END IF;
531: END IF;
532: --6813970 begin

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

549: loop
550: j_formula_count := j_formula_count+1;
551: Formula_Element_Tab(j_formula_count).Element_name := substr(I.PCV_INFORMATION1,1,instr(I.PCV_INFORMATION1,'|')-1);
552: Formula_Element_Tab(j_formula_count).Formula_name := substr(I.PCV_INFORMATION1,instr(I.PCV_INFORMATION1,'|')+1);
553: hr_utility.trace(' Element_name '||j_formula_count|| Formula_Element_Tab(j_formula_count).Element_name);
554: hr_utility.trace(' Formula_name '||j_formula_count|| Formula_Element_Tab(j_formula_count).Formula_name);
555: end loop;
556: --6666135 End
557:

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

550: j_formula_count := j_formula_count+1;
551: Formula_Element_Tab(j_formula_count).Element_name := substr(I.PCV_INFORMATION1,1,instr(I.PCV_INFORMATION1,'|')-1);
552: Formula_Element_Tab(j_formula_count).Formula_name := substr(I.PCV_INFORMATION1,instr(I.PCV_INFORMATION1,'|')+1);
553: hr_utility.trace(' Element_name '||j_formula_count|| Formula_Element_Tab(j_formula_count).Element_name);
554: hr_utility.trace(' Formula_name '||j_formula_count|| Formula_Element_Tab(j_formula_count).Formula_name);
555: end loop;
556: --6666135 End
557:
558: v_eff_end_date_corr := v_eff_end_date;

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

555: end loop;
556: --6666135 End
557:
558: v_eff_end_date_corr := v_eff_end_date;
559: hr_utility.set_location('Effective Start Date: ' || p_effective_start_dt,1);
560: hr_utility.set_location('Effective End Date: ' || p_effective_end_dt,2);
561: hr_utility.set_location('Calculated End Date: ' || v_eff_end_date_corr, 3);
562: hr_utility.set_location('Calculated Start Date: ' || v_eff_start_date, 3);
563: hr_utility.set_location('p_assignment_set_id: ' || p_assignment_set_id, 3);

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

556: --6666135 End
557:
558: v_eff_end_date_corr := v_eff_end_date;
559: hr_utility.set_location('Effective Start Date: ' || p_effective_start_dt,1);
560: hr_utility.set_location('Effective End Date: ' || p_effective_end_dt,2);
561: hr_utility.set_location('Calculated End Date: ' || v_eff_end_date_corr, 3);
562: hr_utility.set_location('Calculated Start Date: ' || v_eff_start_date, 3);
563: hr_utility.set_location('p_assignment_set_id: ' || p_assignment_set_id, 3);
564: hr_utility.set_location('p_assignment_number: ' || p_assignment_number, 3);

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

557:
558: v_eff_end_date_corr := v_eff_end_date;
559: hr_utility.set_location('Effective Start Date: ' || p_effective_start_dt,1);
560: hr_utility.set_location('Effective End Date: ' || p_effective_end_dt,2);
561: hr_utility.set_location('Calculated End Date: ' || v_eff_end_date_corr, 3);
562: hr_utility.set_location('Calculated Start Date: ' || v_eff_start_date, 3);
563: hr_utility.set_location('p_assignment_set_id: ' || p_assignment_set_id, 3);
564: hr_utility.set_location('p_assignment_number: ' || p_assignment_number, 3);
565: hr_utility.set_location('p_employee_no: ' || p_employee_no, 3);

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

558: v_eff_end_date_corr := v_eff_end_date;
559: hr_utility.set_location('Effective Start Date: ' || p_effective_start_dt,1);
560: hr_utility.set_location('Effective End Date: ' || p_effective_end_dt,2);
561: hr_utility.set_location('Calculated End Date: ' || v_eff_end_date_corr, 3);
562: hr_utility.set_location('Calculated Start Date: ' || v_eff_start_date, 3);
563: hr_utility.set_location('p_assignment_set_id: ' || p_assignment_set_id, 3);
564: hr_utility.set_location('p_assignment_number: ' || p_assignment_number, 3);
565: hr_utility.set_location('p_employee_no: ' || p_employee_no, 3);
566: hr_utility.set_location('p_payroll_id: ' || p_payroll_id, 3);

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

559: hr_utility.set_location('Effective Start Date: ' || p_effective_start_dt,1);
560: hr_utility.set_location('Effective End Date: ' || p_effective_end_dt,2);
561: hr_utility.set_location('Calculated End Date: ' || v_eff_end_date_corr, 3);
562: hr_utility.set_location('Calculated Start Date: ' || v_eff_start_date, 3);
563: hr_utility.set_location('p_assignment_set_id: ' || p_assignment_set_id, 3);
564: hr_utility.set_location('p_assignment_number: ' || p_assignment_number, 3);
565: hr_utility.set_location('p_employee_no: ' || p_employee_no, 3);
566: hr_utility.set_location('p_payroll_id: ' || p_payroll_id, 3);
567: hr_utility.set_location('p_business_group_id: ' || p_business_group_id, 3);

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

560: hr_utility.set_location('Effective End Date: ' || p_effective_end_dt,2);
561: hr_utility.set_location('Calculated End Date: ' || v_eff_end_date_corr, 3);
562: hr_utility.set_location('Calculated Start Date: ' || v_eff_start_date, 3);
563: hr_utility.set_location('p_assignment_set_id: ' || p_assignment_set_id, 3);
564: hr_utility.set_location('p_assignment_number: ' || p_assignment_number, 3);
565: hr_utility.set_location('p_employee_no: ' || p_employee_no, 3);
566: hr_utility.set_location('p_payroll_id: ' || p_payroll_id, 3);
567: hr_utility.set_location('p_business_group_id: ' || p_business_group_id, 3);
568: hr_utility.set_location('p_mode: ' || p_mode, 3);

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

561: hr_utility.set_location('Calculated End Date: ' || v_eff_end_date_corr, 3);
562: hr_utility.set_location('Calculated Start Date: ' || v_eff_start_date, 3);
563: hr_utility.set_location('p_assignment_set_id: ' || p_assignment_set_id, 3);
564: hr_utility.set_location('p_assignment_number: ' || p_assignment_number, 3);
565: hr_utility.set_location('p_employee_no: ' || p_employee_no, 3);
566: hr_utility.set_location('p_payroll_id: ' || p_payroll_id, 3);
567: hr_utility.set_location('p_business_group_id: ' || p_business_group_id, 3);
568: hr_utility.set_location('p_mode: ' || p_mode, 3);
569: IF p_mode = 'Reprocess'

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

562: hr_utility.set_location('Calculated Start Date: ' || v_eff_start_date, 3);
563: hr_utility.set_location('p_assignment_set_id: ' || p_assignment_set_id, 3);
564: hr_utility.set_location('p_assignment_number: ' || p_assignment_number, 3);
565: hr_utility.set_location('p_employee_no: ' || p_employee_no, 3);
566: hr_utility.set_location('p_payroll_id: ' || p_payroll_id, 3);
567: hr_utility.set_location('p_business_group_id: ' || p_business_group_id, 3);
568: hr_utility.set_location('p_mode: ' || p_mode, 3);
569: IF p_mode = 'Reprocess'
570: THEN

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

563: hr_utility.set_location('p_assignment_set_id: ' || p_assignment_set_id, 3);
564: hr_utility.set_location('p_assignment_number: ' || p_assignment_number, 3);
565: hr_utility.set_location('p_employee_no: ' || p_employee_no, 3);
566: hr_utility.set_location('p_payroll_id: ' || p_payroll_id, 3);
567: hr_utility.set_location('p_business_group_id: ' || p_business_group_id, 3);
568: hr_utility.set_location('p_mode: ' || p_mode, 3);
569: IF p_mode = 'Reprocess'
570: THEN
571: l_mode := 'Y';

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

564: hr_utility.set_location('p_assignment_number: ' || p_assignment_number, 3);
565: hr_utility.set_location('p_employee_no: ' || p_employee_no, 3);
566: hr_utility.set_location('p_payroll_id: ' || p_payroll_id, 3);
567: hr_utility.set_location('p_business_group_id: ' || p_business_group_id, 3);
568: hr_utility.set_location('p_mode: ' || p_mode, 3);
569: IF p_mode = 'Reprocess'
570: THEN
571: l_mode := 'Y';
572: ELSIF p_mode = 'Incomplete'

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

573: THEN
574: l_mode := 'I';
575: END IF;
576: --
577: hr_utility.set_location('l_mode: ' || l_mode, 3);
578: FOR c_all_assignments in c_all_valid_assignment
579: LOOP
580: Begin
581: hr_utility.set_location('Inside valid Assignments'||c_all_assignments.assignment_id,20);

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

577: hr_utility.set_location('l_mode: ' || l_mode, 3);
578: FOR c_all_assignments in c_all_valid_assignment
579: LOOP
580: Begin
581: hr_utility.set_location('Inside valid Assignments'||c_all_assignments.assignment_id,20);
582:
583: if nvl(n_prev_assignment_id,'0.000') = c_all_assignments.assignment_id then
584: raise skip_assignment;
585: end if;

Line 631: hr_utility.trace('after future date cursor:'||max_future_date);

627: IF max_future_date is not NULL THEN
628: b_pqp_found := TRUE;
629: END IF;
630: CLOSE c_future_date;
631: hr_utility.trace('after future date cursor:'||max_future_date);
632: IF b_pqp_found THEN
633: OPEN c_pqp_assignment(c_all_assignments.assignment_id);
634: FETCH c_pqp_assignment INTO c_pqp_assignment_row;
635: hr_utility.trace('c_pqp_assignment cursor:'||c_pqp_assignment_row.lgps_process_flag);

Line 635: hr_utility.trace('c_pqp_assignment cursor:'||c_pqp_assignment_row.lgps_process_flag);

631: hr_utility.trace('after future date cursor:'||max_future_date);
632: IF b_pqp_found THEN
633: OPEN c_pqp_assignment(c_all_assignments.assignment_id);
634: FETCH c_pqp_assignment INTO c_pqp_assignment_row;
635: hr_utility.trace('c_pqp_assignment cursor:'||c_pqp_assignment_row.lgps_process_flag);
636: IF c_pqp_assignment%found
637: then
638: b_pqp_assignment_found := TRUE;
639: END IF;

Line 641: hr_utility.trace('l_mode:'||l_mode);

637: then
638: b_pqp_assignment_found := TRUE;
639: END IF;
640: CLOSE c_pqp_assignment;
641: hr_utility.trace('l_mode:'||l_mode);
642: hr_utility.trace('p_mode:'||p_mode);
643: IF b_pqp_assignment_found THEN
644: IF ((p_mode = 'Start of the Year' and nvl(c_pqp_assignment_row.lgps_process_flag,'Y') in ('Y','P','I','U'))
645: or l_mode in ('Y','I')

Line 642: hr_utility.trace('p_mode:'||p_mode);

638: b_pqp_assignment_found := TRUE;
639: END IF;
640: CLOSE c_pqp_assignment;
641: hr_utility.trace('l_mode:'||l_mode);
642: hr_utility.trace('p_mode:'||p_mode);
643: IF b_pqp_assignment_found THEN
644: IF ((p_mode = 'Start of the Year' and nvl(c_pqp_assignment_row.lgps_process_flag,'Y') in ('Y','P','I','U'))
645: or l_mode in ('Y','I')
646: or nvl(c_pqp_assignment_row.lgps_process_flag,'New Hires') = p_mode) THEN

Line 651: hr_utility.trace('Skip assignment else part:'||p_mode||'-'||c_pqp_assignment_row.lgps_process_flag);

647: v_max_date := Greatest(c_pqp_assignment_row.EFFECTIVE_START_DATE, v_eff_start_date);
648: n_object_version_no := c_pqp_assignment_row.object_version_number;
649: ElSE
650:
651: hr_utility.trace('Skip assignment else part:'||p_mode||'-'||c_pqp_assignment_row.lgps_process_flag);
652: Raise skip_assignment;
653: END IF;
654:
655: v_assignment_eff_date := Greatest(c_pqp_assignment_row.EFFECTIVE_START_DATE, v_assignment_eff_date);

Line 662: hr_utility.trace('Skip assignment raised because of IF b_pqp_assignment_found is NULL AND l_mode is not null THEN');

658:
659: IF b_pqp_assignment_found is NULL AND l_mode is not null THEN
660: --No records in PQP_ASSIGNMENT_ATTRIBUTES_F table matching mode - reprocess or incomplete.
661:
662: hr_utility.trace('Skip assignment raised because of IF b_pqp_assignment_found is NULL AND l_mode is not null THEN');
663: raise skip_assignment;
664: END IF;
665: hr_utility.trace('c1_all_element cusror:'||c_all_assignments.assignment_id);
666: OPEN c1_all_element(c_all_assignments.assignment_id);

Line 665: hr_utility.trace('c1_all_element cusror:'||c_all_assignments.assignment_id);

661:
662: hr_utility.trace('Skip assignment raised because of IF b_pqp_assignment_found is NULL AND l_mode is not null THEN');
663: raise skip_assignment;
664: END IF;
665: hr_utility.trace('c1_all_element cusror:'||c_all_assignments.assignment_id);
666: OPEN c1_all_element(c_all_assignments.assignment_id);
667: LOOP
668: BEGIN
669: hr_utility.set_location('Inside valid Elements for the Assignment'||c_all_assignments.assignment_id,20);

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

665: hr_utility.trace('c1_all_element cusror:'||c_all_assignments.assignment_id);
666: OPEN c1_all_element(c_all_assignments.assignment_id);
667: LOOP
668: BEGIN
669: hr_utility.set_location('Inside valid Elements for the Assignment'||c_all_assignments.assignment_id,20);
670: FETCH c1_all_element into c1_all_element_data;
671: IF c1_all_element%NOTFOUND
672: THEN
673: CLOSE c1_all_element;

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

672: THEN
673: CLOSE c1_all_element;
674: EXIT;
675: END IF;
676: hr_utility.set_location('Checking for Historic rate type',25);
677: b_element_present := TRUE;
678:
679: l_ELEMENT_NAME := null;
680:

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

727: -- ELSIF c2_PQP_UK_RATE_TYPE_data.EEI_INFORMATION1 = 'PQP_LGPS_PENSION_PAY'
728: IF c2_PQP_UK_RATE_TYPE_data.EEI_INFORMATION1 = 'PQP_PCSPS_PENSION_PAY'
729: THEN
730: --7369484 End
731: hr_utility.set_location('Historic Rate Type present for Element '||c1_all_element_data.element_type_id,26);
732: -- 7369484 Begin
733: b_rate_type := TRUE;
734: b_eng_rate := TRUE;
735: IF b_scot_rate = TRUE

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

743: OPEN c3_pqp_lgps_pension_pay(c1_all_element_data.element_type_id);
744: FETCH c3_pqp_lgps_pension_pay INTO c3_pqp_lgps_pension_pay_data;
745: IF c3_pqp_lgps_pension_pay%NOTFOUND
746: THEN
747: hr_utility.set_location('Pay Value Not Present',27);
748: IF l_ELEMENT_NAME IS NULL THEN
749: l_warning_msg := 'PQP_PCSPS_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;
750: fnd_file.put_line (fnd_file.LOG, l_warning_msg);
751: END IF;

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

750: fnd_file.put_line (fnd_file.LOG, l_warning_msg);
751: END IF;
752: ELSE
753: b_input_value_present := TRUE;
754: hr_utility.set_location('Pay Value Present',28);
755: END IF;
756: CLOSE c2_PQP_UK_RATE_TYPE;
757: CLOSE c3_pqp_lgps_pension_pay;
758: EXCEPTION

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

776: v_mode := 'UPDATE_CHANGE_INSERT';
777: ELSE
778: v_mode := 'UPDATE';
779: END IF;
780: hr_utility.set_location('Mode for update v_mode: ' || v_mode, 3);
781: --6813970 begin
782: -- IF (not b_element_present) or (not b_rate_type)
783: -- THEN
784: -- l_warning_msg := 'PQP_PCSPS_MISSING_RATE_INFO: Historic Rate - Rate Type "PCSPS Pensionable Pay" not set for elements against Assignment '||c_all_assignments.assignment_number;

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

787: l_warning_msg := 'PQP_PCSPS_MISSING_RATE_INFO: Neither Historic Rate - Rate Type "PCSPS Pensionable Pay" nor User defined formula set for elements against Assignment '||c_all_assignments.assignment_number;
788: --6813970 end
789: fnd_file.put_line (fnd_file.LOG, l_warning_msg);
790: l_lgps_process_flag := 'I';
791: hr_utility.set_location('Calling API to update LGPS Process Flag I',35);
792: pqp_aat_api.update_assignment_attribute
793: (p_validate => false
794: ,p_effective_date => v_assignment_eff_date --v_eff_start_date
795: ,p_datetrack_mode => v_mode

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

842: l_warning_msg := 'PQP_PCSPS_MISSING_RATE_INFO: Neither Historic Rate - Rate Type "PCSPS Pensionable Pay" nor User defined formula set for elements against Assignment '||c_all_assignments.assignment_number;
843: --6813970 end
844: fnd_file.put_line (fnd_file.LOG, l_warning_msg);
845: l_lgps_process_flag := 'I';
846: hr_utility.set_location('Calling API to insert LGPS Process Flag I',355);
847: pqp_aat_api.create_assignment_attribute
848: (p_effective_date => v_assignment_eff_date
849: ,p_business_group_id => p_business_group_id
850: ,p_assignment_id => c_all_assignments.assignment_id

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

880: k_aasgn_form_count := 0; --to skip processing of user defined formulae --6813970
881: b_input_value_present := FALSE; --to make the LGPS process flag as Incomplete.
882: End;
883: END IF;
884: hr_utility.set_location('Calculated Pensionable Pay'||l_lgps_pensionable_pay,40);
885:
886: ---- To calculate the value from user defined formula and add it to the value from historic rates function
887: --6813970 begin
888: -- IF b_rate_type

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

895: END IF;
896: IF k_aasgn_form_count > 0 then
897:
898:
899: hr_utility.set_location(' Calling RUN_USER_FORMULA ',25);
900: -- Call the formula to calculate the additional pension pay
901: /* Bug fix 8238736 Start
902: c_formula_pension_value :=
903: (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);

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

903: (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);
904: */
905: 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));
906: -- Bug fix 8238736 End
907: hr_utility.set_location(' formula returned value '||c_formula_pension_value,40);
908:
909: --IF nvl(c_formula_pension_value,0) >= 0 -- equal to condition is added for bug 6857280
910: IF ( (nvl(c_formula_pension_value,0) + NVL(l_lgps_pensionable_pay,0)) >=0 ) -- BugFix 8238736
911: THEN

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

910: IF ( (nvl(c_formula_pension_value,0) + NVL(l_lgps_pensionable_pay,0)) >=0 ) -- BugFix 8238736
911: THEN
912: l_lgps_pensionable_pay := NVL(l_lgps_pensionable_pay,0) + c_formula_pension_value;
913: END IF;
914: hr_utility.set_location('After adding additional Pension Value'||l_lgps_pensionable_pay,42);
915:
916:
917: END IF; --check for presence of formula in configuration value screen
918:

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

923: fnd_file.put_line(FND_FILE.OUTPUT, '-----------------------------Total value '||nvl(l_lgps_pensionable_pay,0));
924: l_lgps_process_flag := 'P';
925: IF b_pqp_found
926: THEN
927: hr_utility.trace(' updating the Contractual pay for effective date '||v_max_date|| ' mode '||v_mode||' OVN '||n_object_version_no);
928: pqp_aat_api.update_assignment_attribute
929: (p_validate => false
930: ,p_effective_date => v_assignment_eff_date --v_eff_start_date
931: ,p_datetrack_mode => v_mode

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

958: );
959: END LOOP;
960:
961: Else
962: hr_utility.set_location('Inserting the Contractual pay for effective date'||v_assignment_eff_date,555);
963: pqp_aat_api.create_assignment_attribute
964: (p_effective_date => v_assignment_eff_date
965: ,p_business_group_id => p_business_group_id
966: ,p_assignment_id => c_all_assignments.assignment_id

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

972: ,p_lgps_pensionable_pay => l_lgps_pensionable_pay
973: );
974: END IF; -- b_pqp_found
975: END IF; -- check for l_lgps_pensionable_pay
976: hr_utility.set_location('After updating Process flag to P'||c_all_assignments.assignment_id,45);
977: Raise skip_assignment;
978: END IF; --rate type entered
979:
980:

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

981: IF b_pqp_found THEN
982: IF (not b_input_value_present)
983: THEN
984: l_lgps_process_flag := 'I';
985: hr_utility.set_location('Calling API to update LGPS Process Flag I',30);
986: pqp_aat_api.update_assignment_attribute
987: (p_validate => false
988: ,p_effective_date => v_assignment_eff_date --v_eff_start_date
989: ,p_datetrack_mode => v_mode

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

1017: Else
1018: IF (not b_input_value_present)
1019: THEN
1020: l_lgps_process_flag := 'I';
1021: hr_utility.set_location('Calling API to insert LGPS Process Flag I',305);
1022: pqp_aat_api.create_assignment_attribute
1023: (p_effective_date => v_assignment_eff_date
1024: ,p_business_group_id => p_business_group_id
1025: ,p_assignment_id => c_all_assignments.assignment_id

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

1033: END IF;
1034:
1035: Exception
1036: when skip_assignment then
1037: hr_utility.set_location('Skipped Assignment'||c_all_assignments.assignment_id,45);
1038: END;
1039: END LOOP; --loop for all valid assignments
1040: COMMIT;
1041: hr_utility.set_location('Leaving: ' || l_proc, 100);

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

1037: hr_utility.set_location('Skipped Assignment'||c_all_assignments.assignment_id,45);
1038: END;
1039: END LOOP; --loop for all valid assignments
1040: COMMIT;
1041: hr_utility.set_location('Leaving: ' || l_proc, 100);
1042: -- hr_utility.trace_off;
1043: END DERIVE_PENSIONABLE_PAY;
1044: ---------------------------------------------------------------------
1045: /* This section of code is ued by the formula functions

Line 1042: -- hr_utility.trace_off;

1038: END;
1039: END LOOP; --loop for all valid assignments
1040: COMMIT;
1041: hr_utility.set_location('Leaving: ' || l_proc, 100);
1042: -- hr_utility.trace_off;
1043: END DERIVE_PENSIONABLE_PAY;
1044: ---------------------------------------------------------------------
1045: /* This section of code is ued by the formula functions
1046: which inturn will be call from the pension element fast formula */