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.

[Home] [Help]

APPS.PQP_GB_LGPS_PENSIONPAY dependencies on HR_UTILITY

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

122: p_inputs(6).name := 'ASSIGNMENT_ACTION_ID';
123: p_inputs(6).value := c_action_ids_row.ASSIGNMENT_ACTION_ID;
124: END IF;
125: CLOSE c_action_ids;
126: hr_utility.trace(' PAYROLL_ACTION_ID '|| c_action_ids_row.PAYROLL_ACTION_ID);
127: hr_utility.trace(' ASSIGNMENT_ACTION_ID '||c_action_ids_row.ASSIGNMENT_ACTION_ID);
128: hr_utility.trace(' p_assignment_id '||p_assignment_id);
129: hr_utility.trace('**Date earned '|| fnd_date.date_to_canonical(p_effective_date));
130: hr_utility.trace(' p_payroll_id '||p_payroll_id);

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

123: p_inputs(6).value := c_action_ids_row.ASSIGNMENT_ACTION_ID;
124: END IF;
125: CLOSE c_action_ids;
126: hr_utility.trace(' PAYROLL_ACTION_ID '|| c_action_ids_row.PAYROLL_ACTION_ID);
127: hr_utility.trace(' ASSIGNMENT_ACTION_ID '||c_action_ids_row.ASSIGNMENT_ACTION_ID);
128: hr_utility.trace(' p_assignment_id '||p_assignment_id);
129: hr_utility.trace('**Date earned '|| fnd_date.date_to_canonical(p_effective_date));
130: hr_utility.trace(' p_payroll_id '||p_payroll_id);
131:

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

124: END IF;
125: CLOSE c_action_ids;
126: hr_utility.trace(' PAYROLL_ACTION_ID '|| c_action_ids_row.PAYROLL_ACTION_ID);
127: hr_utility.trace(' ASSIGNMENT_ACTION_ID '||c_action_ids_row.ASSIGNMENT_ACTION_ID);
128: hr_utility.trace(' p_assignment_id '||p_assignment_id);
129: hr_utility.trace('**Date earned '|| fnd_date.date_to_canonical(p_effective_date));
130: hr_utility.trace(' p_payroll_id '||p_payroll_id);
131:
132: -- 6666135 Begin

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

125: CLOSE c_action_ids;
126: hr_utility.trace(' PAYROLL_ACTION_ID '|| c_action_ids_row.PAYROLL_ACTION_ID);
127: hr_utility.trace(' ASSIGNMENT_ACTION_ID '||c_action_ids_row.ASSIGNMENT_ACTION_ID);
128: hr_utility.trace(' p_assignment_id '||p_assignment_id);
129: hr_utility.trace('**Date earned '|| fnd_date.date_to_canonical(p_effective_date));
130: hr_utility.trace(' p_payroll_id '||p_payroll_id);
131:
132: -- 6666135 Begin
133: FOR I in 1..Formula_Tab.COUNT

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

126: hr_utility.trace(' PAYROLL_ACTION_ID '|| c_action_ids_row.PAYROLL_ACTION_ID);
127: hr_utility.trace(' ASSIGNMENT_ACTION_ID '||c_action_ids_row.ASSIGNMENT_ACTION_ID);
128: hr_utility.trace(' p_assignment_id '||p_assignment_id);
129: hr_utility.trace('**Date earned '|| fnd_date.date_to_canonical(p_effective_date));
130: hr_utility.trace(' p_payroll_id '||p_payroll_id);
131:
132: -- 6666135 Begin
133: FOR I in 1..Formula_Tab.COUNT
134: LOOP

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

132: -- 6666135 Begin
133: FOR I in 1..Formula_Tab.COUNT
134: LOOP
135: v_formula_id := Null;
136: hr_utility.trace(' For Formula_Tab '||Formula_Tab(I));
137: OPEN c_pqp_formula_id(Formula_Tab(I));
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);

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

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

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

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

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

164: END LOOP;
165: END IF;
166: FOR i IN l_inputs.first..l_inputs.last
167: LOOP
168: hr_utility.trace(' i= '||i||' name '||l_inputs(i).name ||' value '||l_inputs(i).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);

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

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

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

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);
178: IF n_sum_formula_val > 0
179: THEN --if the formula returns value greater than 0 6666135
180: OPEN c_additional_pension(p_assignment_id
181: ,p_effective_date);

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

180: OPEN c_additional_pension(p_assignment_id
181: ,p_effective_date);
182: FETCH c_additional_pension INTO c_additional_pension_row;
183: IF c_additional_pension%NOTFOUND then
184: hr_utility.trace(' Inserting seeded element with value'||n_sum_formula_val);
185: OPEN c_seeded_element_det;
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);

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

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

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

205: p_input_value_id1 => c_seeded_element_det_row.input_value_id,
206: p_entry_value1 => to_char(n_sum_formula_val)
207: );
208: ELSE
209: hr_utility.trace(' calling for correction of seeded element '||n_sum_formula_val);
210: --6666135 End
211: hr_entry_api.update_element_entry (p_dt_update_mode =>'CORRECTION',
212: p_session_date => p_effective_date,
213: p_check_for_update =>'N',

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

219:
220: END IF; --Seeded element present or not
221: CLOSE c_additional_pension;
222: END IF; -- formula returned value greater than zero
223: hr_utility.trace(' formula completed');
224: return n_sum_formula_val;
225: Exception
226: When Skip_formula then
227: --seeded element is not linked to Payroll so skipping

Line 230: hr_utility.trace(sqlerrm);

226: When Skip_formula then
227: --seeded element is not linked to Payroll so skipping
228: Null;
229: When others then
230: hr_utility.trace(sqlerrm);
231: Raise;
232: --6666135 End
233: END RUN_USER_FORMULA;
234:

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

430: --6813970 end
431:
432: -- main
433: BEGIN
434: -- hr_utility.trace_on(null,'gag');
435: hr_utility.set_location('Entering: ' || l_proc, 10);
436: BEGIN
437: insert into fnd_sessions (SESSION_ID, EFFECTIVE_DATE)
438: values(userenv('sessionid'), trunc(SYSDATE));

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

431:
432: -- main
433: BEGIN
434: -- hr_utility.trace_on(null,'gag');
435: hr_utility.set_location('Entering: ' || l_proc, 10);
436: BEGIN
437: insert into fnd_sessions (SESSION_ID, EFFECTIVE_DATE)
438: values(userenv('sessionid'), trunc(SYSDATE));
439: EXCEPTION

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

437: insert into fnd_sessions (SESSION_ID, EFFECTIVE_DATE)
438: values(userenv('sessionid'), trunc(SYSDATE));
439: EXCEPTION
440: WHEN others THEN
441: hr_utility.trace('SESSION ALREADY EXISTS :'|| sqlerrm);
442: Raise;
443: END;
444: v_eff_start_date := fnd_date.canonical_to_date(p_effective_start_dt);
445: --calculation of pension end date for the year

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

462: AND to_date('31/03/'||to_char(v_eff_start_date,'YYYY'),'dd/mm/yyyy'))
463: AND (v_eff_end_date BETWEEN to_date('01/01/'||to_char(v_eff_start_date,'YYYY'),'dd/mm/yyyy')
464: AND to_date('31/03/'||to_char(v_eff_start_date,'YYYY'),'dd/mm/yyyy')))
465: THEN
466: hr_utility.set_location('Start date and End date are in the same pension year ',6);
467: ELSE
468: fnd_file.put_line (fnd_file.LOG, 'Start date and End date should fall in the same pension year.');
469: hr_utility.set_location('Start date and End date should fall in the same tax year',8);
470: v_eff_start_date := Null; -- to exit the program

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

465: THEN
466: hr_utility.set_location('Start date and End date are in the same pension year ',6);
467: ELSE
468: fnd_file.put_line (fnd_file.LOG, 'Start date and End date should fall in the same pension year.');
469: hr_utility.set_location('Start date and End date should fall in the same tax year',8);
470: v_eff_start_date := Null; -- to exit the program
471: END IF;
472: END IF;
473: --6813970 begin

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

490: loop
491: j_formula_count := j_formula_count+1;
492: Formula_Element_Tab(j_formula_count).Element_name := substr(I.PCV_INFORMATION1,1,instr(I.PCV_INFORMATION1,'|')-1);
493: Formula_Element_Tab(j_formula_count).Formula_name := substr(I.PCV_INFORMATION1,instr(I.PCV_INFORMATION1,'|')+1);
494: hr_utility.trace(' Element_name '||j_formula_count|| Formula_Element_Tab(j_formula_count).Element_name);
495: hr_utility.trace(' Formula_name '||j_formula_count|| Formula_Element_Tab(j_formula_count).Formula_name);
496: end loop;
497: --6666135 End
498:

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

491: j_formula_count := j_formula_count+1;
492: Formula_Element_Tab(j_formula_count).Element_name := substr(I.PCV_INFORMATION1,1,instr(I.PCV_INFORMATION1,'|')-1);
493: Formula_Element_Tab(j_formula_count).Formula_name := substr(I.PCV_INFORMATION1,instr(I.PCV_INFORMATION1,'|')+1);
494: hr_utility.trace(' Element_name '||j_formula_count|| Formula_Element_Tab(j_formula_count).Element_name);
495: hr_utility.trace(' Formula_name '||j_formula_count|| Formula_Element_Tab(j_formula_count).Formula_name);
496: end loop;
497: --6666135 End
498:
499: v_eff_end_date_corr := v_eff_end_date;

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

496: end loop;
497: --6666135 End
498:
499: v_eff_end_date_corr := v_eff_end_date;
500: hr_utility.set_location('Effective Start Date: ' || p_effective_start_dt,1);
501: hr_utility.set_location('Effective End Date: ' || p_effective_end_dt,2);
502: hr_utility.set_location('Calculated End Date: ' || v_eff_end_date_corr, 3);
503: hr_utility.set_location('Calculated Start Date: ' || v_eff_start_date, 3);
504: hr_utility.set_location('p_assignment_set_id: ' || p_assignment_set_id, 3);

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

497: --6666135 End
498:
499: v_eff_end_date_corr := v_eff_end_date;
500: hr_utility.set_location('Effective Start Date: ' || p_effective_start_dt,1);
501: hr_utility.set_location('Effective End Date: ' || p_effective_end_dt,2);
502: hr_utility.set_location('Calculated End Date: ' || v_eff_end_date_corr, 3);
503: hr_utility.set_location('Calculated Start Date: ' || v_eff_start_date, 3);
504: hr_utility.set_location('p_assignment_set_id: ' || p_assignment_set_id, 3);
505: hr_utility.set_location('p_assignment_number: ' || p_assignment_number, 3);

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

498:
499: v_eff_end_date_corr := v_eff_end_date;
500: hr_utility.set_location('Effective Start Date: ' || p_effective_start_dt,1);
501: hr_utility.set_location('Effective End Date: ' || p_effective_end_dt,2);
502: hr_utility.set_location('Calculated End Date: ' || v_eff_end_date_corr, 3);
503: hr_utility.set_location('Calculated Start Date: ' || v_eff_start_date, 3);
504: hr_utility.set_location('p_assignment_set_id: ' || p_assignment_set_id, 3);
505: hr_utility.set_location('p_assignment_number: ' || p_assignment_number, 3);
506: hr_utility.set_location('p_employee_no: ' || p_employee_no, 3);

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

499: v_eff_end_date_corr := v_eff_end_date;
500: hr_utility.set_location('Effective Start Date: ' || p_effective_start_dt,1);
501: hr_utility.set_location('Effective End Date: ' || p_effective_end_dt,2);
502: hr_utility.set_location('Calculated End Date: ' || v_eff_end_date_corr, 3);
503: hr_utility.set_location('Calculated Start Date: ' || v_eff_start_date, 3);
504: hr_utility.set_location('p_assignment_set_id: ' || p_assignment_set_id, 3);
505: hr_utility.set_location('p_assignment_number: ' || p_assignment_number, 3);
506: hr_utility.set_location('p_employee_no: ' || p_employee_no, 3);
507: hr_utility.set_location('p_payroll_id: ' || p_payroll_id, 3);

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

500: hr_utility.set_location('Effective Start Date: ' || p_effective_start_dt,1);
501: hr_utility.set_location('Effective End Date: ' || p_effective_end_dt,2);
502: hr_utility.set_location('Calculated End Date: ' || v_eff_end_date_corr, 3);
503: hr_utility.set_location('Calculated Start Date: ' || v_eff_start_date, 3);
504: hr_utility.set_location('p_assignment_set_id: ' || p_assignment_set_id, 3);
505: hr_utility.set_location('p_assignment_number: ' || p_assignment_number, 3);
506: hr_utility.set_location('p_employee_no: ' || p_employee_no, 3);
507: hr_utility.set_location('p_payroll_id: ' || p_payroll_id, 3);
508: hr_utility.set_location('p_business_group_id: ' || p_business_group_id, 3);

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

501: hr_utility.set_location('Effective End Date: ' || p_effective_end_dt,2);
502: hr_utility.set_location('Calculated End Date: ' || v_eff_end_date_corr, 3);
503: hr_utility.set_location('Calculated Start Date: ' || v_eff_start_date, 3);
504: hr_utility.set_location('p_assignment_set_id: ' || p_assignment_set_id, 3);
505: hr_utility.set_location('p_assignment_number: ' || p_assignment_number, 3);
506: hr_utility.set_location('p_employee_no: ' || p_employee_no, 3);
507: hr_utility.set_location('p_payroll_id: ' || p_payroll_id, 3);
508: hr_utility.set_location('p_business_group_id: ' || p_business_group_id, 3);
509: hr_utility.set_location('p_mode: ' || p_mode, 3);

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

502: hr_utility.set_location('Calculated End Date: ' || v_eff_end_date_corr, 3);
503: hr_utility.set_location('Calculated Start Date: ' || v_eff_start_date, 3);
504: hr_utility.set_location('p_assignment_set_id: ' || p_assignment_set_id, 3);
505: hr_utility.set_location('p_assignment_number: ' || p_assignment_number, 3);
506: hr_utility.set_location('p_employee_no: ' || p_employee_no, 3);
507: hr_utility.set_location('p_payroll_id: ' || p_payroll_id, 3);
508: hr_utility.set_location('p_business_group_id: ' || p_business_group_id, 3);
509: hr_utility.set_location('p_mode: ' || p_mode, 3);
510: IF p_mode = 'Reprocess'

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

503: hr_utility.set_location('Calculated Start Date: ' || v_eff_start_date, 3);
504: hr_utility.set_location('p_assignment_set_id: ' || p_assignment_set_id, 3);
505: hr_utility.set_location('p_assignment_number: ' || p_assignment_number, 3);
506: hr_utility.set_location('p_employee_no: ' || p_employee_no, 3);
507: hr_utility.set_location('p_payroll_id: ' || p_payroll_id, 3);
508: hr_utility.set_location('p_business_group_id: ' || p_business_group_id, 3);
509: hr_utility.set_location('p_mode: ' || p_mode, 3);
510: IF p_mode = 'Reprocess'
511: THEN

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

504: hr_utility.set_location('p_assignment_set_id: ' || p_assignment_set_id, 3);
505: hr_utility.set_location('p_assignment_number: ' || p_assignment_number, 3);
506: hr_utility.set_location('p_employee_no: ' || p_employee_no, 3);
507: hr_utility.set_location('p_payroll_id: ' || p_payroll_id, 3);
508: hr_utility.set_location('p_business_group_id: ' || p_business_group_id, 3);
509: hr_utility.set_location('p_mode: ' || p_mode, 3);
510: IF p_mode = 'Reprocess'
511: THEN
512: l_mode := 'Y';

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

505: hr_utility.set_location('p_assignment_number: ' || p_assignment_number, 3);
506: hr_utility.set_location('p_employee_no: ' || p_employee_no, 3);
507: hr_utility.set_location('p_payroll_id: ' || p_payroll_id, 3);
508: hr_utility.set_location('p_business_group_id: ' || p_business_group_id, 3);
509: hr_utility.set_location('p_mode: ' || p_mode, 3);
510: IF p_mode = 'Reprocess'
511: THEN
512: l_mode := 'Y';
513: ELSIF p_mode = 'Incomplete'

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

514: THEN
515: l_mode := 'I';
516: END IF;
517: --
518: hr_utility.set_location('l_mode: ' || l_mode, 3);
519: FOR c_all_assignments in c_all_valid_assignment
520: LOOP
521: Begin
522: hr_utility.set_location('Inside valid Assignments'||c_all_assignments.assignment_id,20);

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

518: hr_utility.set_location('l_mode: ' || l_mode, 3);
519: FOR c_all_assignments in c_all_valid_assignment
520: LOOP
521: Begin
522: hr_utility.set_location('Inside valid Assignments'||c_all_assignments.assignment_id,20);
523:
524: if nvl(n_prev_assignment_id,'0.000') = c_all_assignments.assignment_id then
525: raise skip_assignment;
526: end if;

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

598:
599: OPEN c1_all_element(c_all_assignments.assignment_id);
600: LOOP
601: BEGIN
602: hr_utility.set_location('Inside valid Elements for the Assignment'||c_all_assignments.assignment_id,20);
603: FETCH c1_all_element into c1_all_element_data;
604: IF c1_all_element%NOTFOUND
605: THEN
606: CLOSE c1_all_element;

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

605: THEN
606: CLOSE c1_all_element;
607: EXIT;
608: END IF;
609: hr_utility.set_location('Checking for Historic rate type',25);
610: b_element_present := TRUE;
611:
612: l_ELEMENT_NAME := null;
613:

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

643: END IF;
644: ELSIF c2_PQP_UK_RATE_TYPE_data.EEI_INFORMATION1 = 'PQP_LGPS_PENSION_PAY'
645: THEN
646: --7369484 End
647: hr_utility.set_location('Historic Rate Type present for Element '||c1_all_element_data.element_type_id,26);
648: -- 7369484 Begin
649: b_rate_type := TRUE;
650: b_eng_rate := TRUE;
651: IF b_scot_rate = TRUE

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

659: OPEN c3_pqp_lgps_pension_pay(c1_all_element_data.element_type_id);
660: FETCH c3_pqp_lgps_pension_pay INTO c3_pqp_lgps_pension_pay_data;
661: IF c3_pqp_lgps_pension_pay%NOTFOUND
662: THEN
663: hr_utility.set_location('Pay Value Not Present',27);
664: IF l_ELEMENT_NAME IS NULL THEN
665: 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;
666: fnd_file.put_line (fnd_file.LOG, l_warning_msg);
667: END IF;

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

666: fnd_file.put_line (fnd_file.LOG, l_warning_msg);
667: END IF;
668: ELSE
669: b_input_value_present := TRUE;
670: hr_utility.set_location('Pay Value Present',28);
671: END IF;
672: CLOSE c2_PQP_UK_RATE_TYPE;
673: CLOSE c3_pqp_lgps_pension_pay;
674: EXCEPTION

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

692: v_mode := 'UPDATE_CHANGE_INSERT';
693: ELSE
694: v_mode := 'UPDATE';
695: END IF;
696: hr_utility.set_location('Mode for update v_mode: ' || v_mode, 3);
697: --6813970 begin
698: -- IF (not b_element_present) or (not b_rate_type)
699: -- THEN
700: -- 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 707: hr_utility.set_location('Calling API to update LGPS Process Flag I',35);

703: 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;
704: --6813970 end
705: fnd_file.put_line (fnd_file.LOG, l_warning_msg);
706: l_lgps_process_flag := 'I';
707: hr_utility.set_location('Calling API to update LGPS Process Flag I',35);
708: pqp_aat_api.update_assignment_attribute
709: (p_validate => false
710: ,p_effective_date => v_assignment_eff_date --v_eff_start_date
711: ,p_datetrack_mode => v_mode

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

758: 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;
759: --6813970 end
760: fnd_file.put_line (fnd_file.LOG, l_warning_msg);
761: l_lgps_process_flag := 'I';
762: hr_utility.set_location('Calling API to insert LGPS Process Flag I',355);
763: pqp_aat_api.create_assignment_attribute
764: (p_effective_date => v_assignment_eff_date
765: ,p_business_group_id => p_business_group_id
766: ,p_assignment_id => c_all_assignments.assignment_id

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

796: k_aasgn_form_count := 0; --to skip processing of user defined formulae --6813970
797: b_input_value_present := FALSE; --to make the LGPS process flag as Incomplete.
798: End;
799: END IF;
800: hr_utility.set_location('Calculated Pensionable Pay'||l_lgps_pensionable_pay,40);
801:
802: ---- To calculate the value from user defined formula and add it to the value from historic rates function
803: --6813970 begin
804: -- IF b_rate_type

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

810: fnd_file.put_line(FND_FILE.OUTPUT, ' Assignment '||c_all_assignments.assignment_number ||' Historic rate value '||nvl(l_lgps_pensionable_pay,0));
811: END IF;
812: IF k_aasgn_form_count > 0 then
813:
814: hr_utility.set_location(' Calling RUN_USER_FORMULA ',25);
815: -- Call the formula to calculate the additional pension pay
816: 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);
817: hr_utility.set_location(' formula returned value '||c_formula_pension_value,40);
818:

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

813:
814: hr_utility.set_location(' Calling RUN_USER_FORMULA ',25);
815: -- Call the formula to calculate the additional pension pay
816: 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);
817: hr_utility.set_location(' formula returned value '||c_formula_pension_value,40);
818:
819: IF nvl(c_formula_pension_value,0) >= 0 -- equal to condition is added for bug 6857280
820: THEN
821: l_lgps_pensionable_pay := NVL(l_lgps_pensionable_pay,0) + c_formula_pension_value;

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

819: IF nvl(c_formula_pension_value,0) >= 0 -- equal to condition is added for bug 6857280
820: THEN
821: l_lgps_pensionable_pay := NVL(l_lgps_pensionable_pay,0) + c_formula_pension_value;
822: END IF;
823: hr_utility.set_location('After adding additional Pension Value'||l_lgps_pensionable_pay,42);
824:
825: END IF; --check for presence of formula in configuration value screen
826:
827: IF c_formula_pension_value is not null or l_lgps_pensionable_pay is not null

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

830: fnd_file.put_line(FND_FILE.OUTPUT, '-----------------------------Total value '||nvl(l_lgps_pensionable_pay,0));
831: l_lgps_process_flag := 'P';
832: IF b_pqp_found
833: THEN
834: hr_utility.trace(' updating the Contractual pay for effective date '||v_max_date|| ' mode '||v_mode||' OVN '||n_object_version_no);
835: pqp_aat_api.update_assignment_attribute
836: (p_validate => false
837: ,p_effective_date => v_assignment_eff_date --v_eff_start_date
838: ,p_datetrack_mode => v_mode

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

865: );
866: END LOOP;
867:
868: Else
869: hr_utility.set_location('Inserting the Contractual pay for effective date'||v_assignment_eff_date,555);
870: pqp_aat_api.create_assignment_attribute
871: (p_effective_date => v_assignment_eff_date
872: ,p_business_group_id => p_business_group_id
873: ,p_assignment_id => c_all_assignments.assignment_id

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

879: ,p_lgps_pensionable_pay => l_lgps_pensionable_pay
880: );
881: END IF; -- b_pqp_found
882: END IF; -- check for l_lgps_pensionable_pay
883: hr_utility.set_location('After updating Process flag to P'||c_all_assignments.assignment_id,45);
884: Raise skip_assignment;
885: END IF; --rate type entered
886:
887:

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

888: IF b_pqp_found THEN
889: IF (not b_input_value_present)
890: THEN
891: l_lgps_process_flag := 'I';
892: hr_utility.set_location('Calling API to update LGPS Process Flag I',30);
893: pqp_aat_api.update_assignment_attribute
894: (p_validate => false
895: ,p_effective_date => v_assignment_eff_date --v_eff_start_date
896: ,p_datetrack_mode => v_mode

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

924: Else
925: IF (not b_input_value_present)
926: THEN
927: l_lgps_process_flag := 'I';
928: hr_utility.set_location('Calling API to insert LGPS Process Flag I',305);
929: pqp_aat_api.create_assignment_attribute
930: (p_effective_date => v_assignment_eff_date
931: ,p_business_group_id => p_business_group_id
932: ,p_assignment_id => c_all_assignments.assignment_id

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

940: END IF;
941:
942: Exception
943: when skip_assignment then
944: hr_utility.set_location('Skipped Assignment'||c_all_assignments.assignment_id,45);
945: END;
946: END LOOP; --loop for all valid assignments
947: COMMIT;
948: hr_utility.set_location('Leaving: ' || l_proc, 100);

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

944: hr_utility.set_location('Skipped Assignment'||c_all_assignments.assignment_id,45);
945: END;
946: END LOOP; --loop for all valid assignments
947: COMMIT;
948: hr_utility.set_location('Leaving: ' || l_proc, 100);
949: END DERIVE_PENSIONABLE_PAY;
950: ---------------------------------------------------------------------
951: /* This section of code is ued by the formula functions
952: which inturn will be call from the pension element fast formula */