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 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 439: -- hr_utility.trace_on(null,'gag');

435: --7369484 End
436:
437: -- main
438: BEGIN
439: -- hr_utility.trace_on(null,'gag');
440: hr_utility.set_location('Entering: ' || l_proc, 10);
441: BEGIN
442: insert into fnd_sessions (SESSION_ID, EFFECTIVE_DATE)
443: values(userenv('sessionid'), trunc(SYSDATE));

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

436:
437: -- main
438: BEGIN
439: -- hr_utility.trace_on(null,'gag');
440: hr_utility.set_location('Entering: ' || l_proc, 10);
441: BEGIN
442: insert into fnd_sessions (SESSION_ID, EFFECTIVE_DATE)
443: values(userenv('sessionid'), trunc(SYSDATE));
444: EXCEPTION

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

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

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

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

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

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

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

495: loop
496: j_formula_count := j_formula_count+1;
497: Formula_Element_Tab(j_formula_count).Element_name := substr(I.PCV_INFORMATION1,1,instr(I.PCV_INFORMATION1,'|')-1);
498: Formula_Element_Tab(j_formula_count).Formula_name := substr(I.PCV_INFORMATION1,instr(I.PCV_INFORMATION1,'|')+1);
499: hr_utility.trace(' Element_name '||j_formula_count|| Formula_Element_Tab(j_formula_count).Element_name);
500: hr_utility.trace(' Formula_name '||j_formula_count|| Formula_Element_Tab(j_formula_count).Formula_name);
501: end loop;
502: --6666135 End
503:

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

496: j_formula_count := j_formula_count+1;
497: Formula_Element_Tab(j_formula_count).Element_name := substr(I.PCV_INFORMATION1,1,instr(I.PCV_INFORMATION1,'|')-1);
498: Formula_Element_Tab(j_formula_count).Formula_name := substr(I.PCV_INFORMATION1,instr(I.PCV_INFORMATION1,'|')+1);
499: hr_utility.trace(' Element_name '||j_formula_count|| Formula_Element_Tab(j_formula_count).Element_name);
500: hr_utility.trace(' Formula_name '||j_formula_count|| Formula_Element_Tab(j_formula_count).Formula_name);
501: end loop;
502: --6666135 End
503:
504: v_eff_end_date_corr := v_eff_end_date;

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

501: end loop;
502: --6666135 End
503:
504: v_eff_end_date_corr := v_eff_end_date;
505: hr_utility.set_location('Effective Start Date: ' || p_effective_start_dt,1);
506: hr_utility.set_location('Effective End Date: ' || p_effective_end_dt,2);
507: hr_utility.set_location('Calculated End Date: ' || v_eff_end_date_corr, 3);
508: hr_utility.set_location('Calculated Start Date: ' || v_eff_start_date, 3);
509: hr_utility.set_location('p_assignment_set_id: ' || p_assignment_set_id, 3);

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

502: --6666135 End
503:
504: v_eff_end_date_corr := v_eff_end_date;
505: hr_utility.set_location('Effective Start Date: ' || p_effective_start_dt,1);
506: hr_utility.set_location('Effective End Date: ' || p_effective_end_dt,2);
507: hr_utility.set_location('Calculated End Date: ' || v_eff_end_date_corr, 3);
508: hr_utility.set_location('Calculated Start Date: ' || v_eff_start_date, 3);
509: hr_utility.set_location('p_assignment_set_id: ' || p_assignment_set_id, 3);
510: hr_utility.set_location('p_assignment_number: ' || p_assignment_number, 3);

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

503:
504: v_eff_end_date_corr := v_eff_end_date;
505: hr_utility.set_location('Effective Start Date: ' || p_effective_start_dt,1);
506: hr_utility.set_location('Effective End Date: ' || p_effective_end_dt,2);
507: hr_utility.set_location('Calculated End Date: ' || v_eff_end_date_corr, 3);
508: hr_utility.set_location('Calculated Start Date: ' || v_eff_start_date, 3);
509: hr_utility.set_location('p_assignment_set_id: ' || p_assignment_set_id, 3);
510: hr_utility.set_location('p_assignment_number: ' || p_assignment_number, 3);
511: hr_utility.set_location('p_employee_no: ' || p_employee_no, 3);

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

504: v_eff_end_date_corr := v_eff_end_date;
505: hr_utility.set_location('Effective Start Date: ' || p_effective_start_dt,1);
506: hr_utility.set_location('Effective End Date: ' || p_effective_end_dt,2);
507: hr_utility.set_location('Calculated End Date: ' || v_eff_end_date_corr, 3);
508: hr_utility.set_location('Calculated Start Date: ' || v_eff_start_date, 3);
509: hr_utility.set_location('p_assignment_set_id: ' || p_assignment_set_id, 3);
510: hr_utility.set_location('p_assignment_number: ' || p_assignment_number, 3);
511: hr_utility.set_location('p_employee_no: ' || p_employee_no, 3);
512: hr_utility.set_location('p_payroll_id: ' || p_payroll_id, 3);

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

505: hr_utility.set_location('Effective Start Date: ' || p_effective_start_dt,1);
506: hr_utility.set_location('Effective End Date: ' || p_effective_end_dt,2);
507: hr_utility.set_location('Calculated End Date: ' || v_eff_end_date_corr, 3);
508: hr_utility.set_location('Calculated Start Date: ' || v_eff_start_date, 3);
509: hr_utility.set_location('p_assignment_set_id: ' || p_assignment_set_id, 3);
510: hr_utility.set_location('p_assignment_number: ' || p_assignment_number, 3);
511: hr_utility.set_location('p_employee_no: ' || p_employee_no, 3);
512: hr_utility.set_location('p_payroll_id: ' || p_payroll_id, 3);
513: hr_utility.set_location('p_business_group_id: ' || p_business_group_id, 3);

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

506: hr_utility.set_location('Effective End Date: ' || p_effective_end_dt,2);
507: hr_utility.set_location('Calculated End Date: ' || v_eff_end_date_corr, 3);
508: hr_utility.set_location('Calculated Start Date: ' || v_eff_start_date, 3);
509: hr_utility.set_location('p_assignment_set_id: ' || p_assignment_set_id, 3);
510: hr_utility.set_location('p_assignment_number: ' || p_assignment_number, 3);
511: hr_utility.set_location('p_employee_no: ' || p_employee_no, 3);
512: hr_utility.set_location('p_payroll_id: ' || p_payroll_id, 3);
513: hr_utility.set_location('p_business_group_id: ' || p_business_group_id, 3);
514: hr_utility.set_location('p_mode: ' || p_mode, 3);

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

507: hr_utility.set_location('Calculated End Date: ' || v_eff_end_date_corr, 3);
508: hr_utility.set_location('Calculated Start Date: ' || v_eff_start_date, 3);
509: hr_utility.set_location('p_assignment_set_id: ' || p_assignment_set_id, 3);
510: hr_utility.set_location('p_assignment_number: ' || p_assignment_number, 3);
511: hr_utility.set_location('p_employee_no: ' || p_employee_no, 3);
512: hr_utility.set_location('p_payroll_id: ' || p_payroll_id, 3);
513: hr_utility.set_location('p_business_group_id: ' || p_business_group_id, 3);
514: hr_utility.set_location('p_mode: ' || p_mode, 3);
515: IF p_mode = 'Reprocess'

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

508: hr_utility.set_location('Calculated Start Date: ' || v_eff_start_date, 3);
509: hr_utility.set_location('p_assignment_set_id: ' || p_assignment_set_id, 3);
510: hr_utility.set_location('p_assignment_number: ' || p_assignment_number, 3);
511: hr_utility.set_location('p_employee_no: ' || p_employee_no, 3);
512: hr_utility.set_location('p_payroll_id: ' || p_payroll_id, 3);
513: hr_utility.set_location('p_business_group_id: ' || p_business_group_id, 3);
514: hr_utility.set_location('p_mode: ' || p_mode, 3);
515: IF p_mode = 'Reprocess'
516: THEN

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

509: hr_utility.set_location('p_assignment_set_id: ' || p_assignment_set_id, 3);
510: hr_utility.set_location('p_assignment_number: ' || p_assignment_number, 3);
511: hr_utility.set_location('p_employee_no: ' || p_employee_no, 3);
512: hr_utility.set_location('p_payroll_id: ' || p_payroll_id, 3);
513: hr_utility.set_location('p_business_group_id: ' || p_business_group_id, 3);
514: hr_utility.set_location('p_mode: ' || p_mode, 3);
515: IF p_mode = 'Reprocess'
516: THEN
517: l_mode := 'Y';

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

510: hr_utility.set_location('p_assignment_number: ' || p_assignment_number, 3);
511: hr_utility.set_location('p_employee_no: ' || p_employee_no, 3);
512: hr_utility.set_location('p_payroll_id: ' || p_payroll_id, 3);
513: hr_utility.set_location('p_business_group_id: ' || p_business_group_id, 3);
514: hr_utility.set_location('p_mode: ' || p_mode, 3);
515: IF p_mode = 'Reprocess'
516: THEN
517: l_mode := 'Y';
518: ELSIF p_mode = 'Incomplete'

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

519: THEN
520: l_mode := 'I';
521: END IF;
522: --
523: hr_utility.set_location('l_mode: ' || l_mode, 3);
524: FOR c_all_assignments in c_all_valid_assignment
525: LOOP
526: Begin
527: hr_utility.set_location('Inside valid Assignments'||c_all_assignments.assignment_id,20);

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

523: hr_utility.set_location('l_mode: ' || l_mode, 3);
524: FOR c_all_assignments in c_all_valid_assignment
525: LOOP
526: Begin
527: hr_utility.set_location('Inside valid Assignments'||c_all_assignments.assignment_id,20);
528:
529: if nvl(n_prev_assignment_id,'0.000') = c_all_assignments.assignment_id then
530: raise skip_assignment;
531: end if;

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

603:
604: OPEN c1_all_element(c_all_assignments.assignment_id);
605: LOOP
606: BEGIN
607: hr_utility.set_location('Inside valid Elements for the Assignment'||c_all_assignments.assignment_id,20);
608: FETCH c1_all_element into c1_all_element_data;
609: IF c1_all_element%NOTFOUND
610: THEN
611: CLOSE c1_all_element;

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

610: THEN
611: CLOSE c1_all_element;
612: EXIT;
613: END IF;
614: hr_utility.set_location('Checking for Historic rate type',25);
615: b_element_present := TRUE;
616:
617: l_ELEMENT_NAME := null;
618:

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

648: END IF;
649: ELSIF c2_PQP_UK_RATE_TYPE_data.EEI_INFORMATION1 = 'PQP_LGPS_SCOTLAND_PENSION_PAY'
650: THEN
651: -- 7369484 End
652: hr_utility.set_location('Historic Rate Type present for Element '||c1_all_element_data.element_type_id,26);
653: b_rate_type := TRUE;
654: -- 7369484 Begin
655: b_scot_rate := TRUE;
656: IF b_eng_rate = TRUE

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

664: OPEN c3_pqp_lgps_pension_pay(c1_all_element_data.element_type_id);
665: FETCH c3_pqp_lgps_pension_pay INTO c3_pqp_lgps_pension_pay_data;
666: IF c3_pqp_lgps_pension_pay%NOTFOUND
667: THEN
668: hr_utility.set_location('Pay Value Not Present',27);
669: IF l_ELEMENT_NAME IS NULL THEN
670: l_warning_msg := 'PQP_LGPS_MISSING_HISTORIC_RATE_INFO: Historic Rate - Element Attribution information missing for Element '||c1_all_element_data.Element_name||' in Assignment '||c_all_assignments.assignment_number;
671: fnd_file.put_line (fnd_file.LOG, l_warning_msg);
672: END IF;

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

671: fnd_file.put_line (fnd_file.LOG, l_warning_msg);
672: END IF;
673: ELSE
674: b_input_value_present := TRUE;
675: hr_utility.set_location('Pay Value Present',28);
676: END IF;
677: CLOSE c2_PQP_UK_RATE_TYPE;
678: CLOSE c3_pqp_lgps_pension_pay;
679: EXCEPTION

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

699: v_mode := 'UPDATE_CHANGE_INSERT';
700: ELSE
701: v_mode := 'UPDATE';
702: END IF;
703: hr_utility.set_location('Mode for update v_mode: ' || v_mode, 3);
704: --6813970 begin
705: -- IF (not b_element_present) or (not b_rate_type)
706: -- THEN
707: -- 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 714: hr_utility.set_location('Calling API to update LGPS Process Flag I',35);

710: l_warning_msg := 'PQP_LGPS_MISSING_RATE_INFO: Neither Historic Rate - Rate Type "LGPS Scotland Pensionable Pay" nor User defined formula set for elements against Assignment '||c_all_assignments.assignment_number;
711: --6813970 end
712: fnd_file.put_line (fnd_file.LOG, l_warning_msg);
713: l_lgps_process_flag := 'I';
714: hr_utility.set_location('Calling API to update LGPS Process Flag I',35);
715: pqp_aat_api.update_assignment_attribute
716: (p_validate => false
717: ,p_effective_date => v_assignment_eff_date --v_eff_start_date
718: ,p_datetrack_mode => v_mode

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

765: l_warning_msg := 'PQP_LGPS_MISSING_RATE_INFO: Neither Historic Rate - Rate Type "LGPS Scotland Pensionable Pay" nor User defined formula set for elements against Assignment '||c_all_assignments.assignment_number;
766: --6813970 end
767: fnd_file.put_line (fnd_file.LOG, l_warning_msg);
768: l_lgps_process_flag := 'I';
769: hr_utility.set_location('Calling API to insert LGPS Process Flag I',355);
770: pqp_aat_api.create_assignment_attribute
771: (p_effective_date => v_assignment_eff_date
772: ,p_business_group_id => p_business_group_id
773: ,p_assignment_id => c_all_assignments.assignment_id

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

803: k_aasgn_form_count := 0; --to skip processing of user defined formulae --6813970
804: b_input_value_present := FALSE; --to make the LGPS process flag as Incomplete.
805: End;
806: END IF;
807: hr_utility.set_location('Calculated Pensionable Pay'||l_lgps_pensionable_pay,40);
808:
809: ---- To calculate the value from user defined formula and add it to the value from historic rates function
810: --6813970 begin
811: -- IF b_rate_type

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

817: fnd_file.put_line(FND_FILE.OUTPUT, ' Assignment '||c_all_assignments.assignment_number ||' Historic rate value '||nvl(l_lgps_pensionable_pay,0));
818: END IF;
819: IF k_aasgn_form_count > 0 then
820:
821: hr_utility.set_location(' Calling RUN_USER_FORMULA ',25);
822: -- Call the formula to calculate the additional pension pay
823: 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);
824: hr_utility.set_location(' formula returned value '||c_formula_pension_value,40);
825:

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

820:
821: hr_utility.set_location(' Calling RUN_USER_FORMULA ',25);
822: -- Call the formula to calculate the additional pension pay
823: 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);
824: hr_utility.set_location(' formula returned value '||c_formula_pension_value,40);
825:
826: IF nvl(c_formula_pension_value,0) >= 0 -- equal to condition is added for bug 6857280
827: THEN
828: l_lgps_pensionable_pay := NVL(l_lgps_pensionable_pay,0) + c_formula_pension_value;

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

826: IF nvl(c_formula_pension_value,0) >= 0 -- equal to condition is added for bug 6857280
827: THEN
828: l_lgps_pensionable_pay := NVL(l_lgps_pensionable_pay,0) + c_formula_pension_value;
829: END IF;
830: hr_utility.set_location('After adding additional Pension Value'||l_lgps_pensionable_pay,42);
831:
832: END IF; --check for presence of formula in configuration value screen
833:
834: IF c_formula_pension_value is not null or l_lgps_pensionable_pay is not null

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

837: fnd_file.put_line(FND_FILE.OUTPUT, '-----------------------------Total value '||nvl(l_lgps_pensionable_pay,0));
838: l_lgps_process_flag := 'P';
839: IF b_pqp_found
840: THEN
841: hr_utility.trace(' updating the Contractual pay for effective date '||v_max_date|| ' mode '||v_mode||' OVN '||n_object_version_no);
842: pqp_aat_api.update_assignment_attribute
843: (p_validate => false
844: ,p_effective_date => v_assignment_eff_date --v_eff_start_date
845: ,p_datetrack_mode => v_mode

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

872: );
873: END LOOP;
874:
875: Else
876: hr_utility.set_location('Inserting the Contractual pay for effective date'||v_assignment_eff_date,555);
877: pqp_aat_api.create_assignment_attribute
878: (p_effective_date => v_assignment_eff_date
879: ,p_business_group_id => p_business_group_id
880: ,p_assignment_id => c_all_assignments.assignment_id

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

886: ,p_lgps_pensionable_pay => l_lgps_pensionable_pay
887: );
888: END IF; -- b_pqp_found
889: END IF; -- check for l_lgps_pensionable_pay
890: hr_utility.set_location('After updating Process flag to P'||c_all_assignments.assignment_id,45);
891: Raise skip_assignment;
892: END IF; --rate type entered
893:
894:

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

895: IF b_pqp_found THEN
896: IF (not b_input_value_present)
897: THEN
898: l_lgps_process_flag := 'I';
899: hr_utility.set_location('Calling API to update LGPS Process Flag I',30);
900: pqp_aat_api.update_assignment_attribute
901: (p_validate => false
902: ,p_effective_date => v_assignment_eff_date --v_eff_start_date
903: ,p_datetrack_mode => v_mode

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

931: Else
932: IF (not b_input_value_present)
933: THEN
934: l_lgps_process_flag := 'I';
935: hr_utility.set_location('Calling API to insert LGPS Process Flag I',305);
936: pqp_aat_api.create_assignment_attribute
937: (p_effective_date => v_assignment_eff_date
938: ,p_business_group_id => p_business_group_id
939: ,p_assignment_id => c_all_assignments.assignment_id

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

947: END IF;
948:
949: Exception
950: when skip_assignment then
951: hr_utility.set_location('Skipped Assignment'||c_all_assignments.assignment_id,45);
952: END;
953: END LOOP; --loop for all valid assignments
954: COMMIT;
955: hr_utility.set_location('Leaving: ' || l_proc, 100);

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

951: hr_utility.set_location('Skipped Assignment'||c_all_assignments.assignment_id,45);
952: END;
953: END LOOP; --loop for all valid assignments
954: COMMIT;
955: hr_utility.set_location('Leaving: ' || l_proc, 100);
956: END DERIVE_PENSIONABLE_PAY;
957: ---------------------------------------------------------------------
958: /* This section of code is ued by the formula functions
959: which inturn will be call from the pension element fast formula */