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.PQH_GSP_STAGE_TO_HR dependencies on HR_UTILITY

Line 21: hr_utility.set_location('issue in updating PT',10);

17: where copy_entity_txn_id = p_copy_entity_txn_id
18: and table_alias = 'PLN';
19: exception
20: when others then
21: hr_utility.set_location('issue in updating PT',10);
22: raise;
23: end;
24: end update_lept_data;
25:

Line 40: hr_utility.set_location('issue in lookup ',10);

36: ,'PLAN','GSP_PT');
37: return l_name ;
38: exception
39: when others then
40: hr_utility.set_location('issue in lookup ',10);
41: raise;
42: end get_le_pt_name;
43:
44: function create_life_event (p_business_group_id in number

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

52: l_effective_start_date date;
53: l_effective_end_date date;
54: l_object_version_number number;
55: begin
56: hr_utility.set_location('Entering:'|| l_proc, 10);
57: ben_Life_Event_Reason_api.create_Life_Event_Reason(
58: p_ler_id => l_ler_id
59: ,p_effective_start_date => l_effective_start_date
60: ,p_effective_end_date => l_effective_end_date

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

82: l_effective_start_date date;
83: l_effective_end_date date;
84: l_object_version_number number;
85: begin
86: hr_utility.set_location('Entering:'|| l_proc, 10);
87: ben_plan_type_api.create_plan_type(
88: p_pl_typ_id => l_pl_typ_id
89: ,p_effective_start_date => l_effective_start_date
90: ,p_effective_end_date => l_effective_end_date

Line 133: hr_utility.set_location('life event '||substr(l_ler_name,1,40),10);

129: where effective_end_date = hr_general.end_of_time
130: and business_group_id = p_business_group_id
131: and typ_cd ='GSP'
132: and lf_evt_oper_cd ='PROG';
133: hr_utility.set_location('life event '||substr(l_ler_name,1,40),10);
134:
135: if l_effective_start_date <> l_start_of_time then
136: l_status := 'WRONG-DATE-PROG-LE' ;
137: end if ;

Line 141: hr_utility.set_location('No life event of GSP prog type exists',20);

137: end if ;
138:
139: exception
140: when no_data_found then
141: hr_utility.set_location('No life event of GSP prog type exists',20);
142: l_le_pt_name := get_le_pt_name ('PROG');
143: l_ler_id := create_life_event (p_business_group_id,p_copy_entity_txn_id,'PROG',l_le_pt_name) ;
144: l_prog_le_created_flag := 'Y';
145: when too_many_rows then

Line 146: hr_utility.set_location('2 life event of GSP prog type exists',20);

142: l_le_pt_name := get_le_pt_name ('PROG');
143: l_ler_id := create_life_event (p_business_group_id,p_copy_entity_txn_id,'PROG',l_le_pt_name) ;
144: l_prog_le_created_flag := 'Y';
145: when too_many_rows then
146: hr_utility.set_location('2 life event of GSP prog type exists',20);
147: l_status := 'MANY-PROG-LE';
148: when others then
149: hr_utility.set_location('issue in Getting GSP PROG LE',20);
150: l_status := 'PROG-LE-ERR';

Line 149: hr_utility.set_location('issue in Getting GSP PROG LE',20);

145: when too_many_rows then
146: hr_utility.set_location('2 life event of GSP prog type exists',20);
147: l_status := 'MANY-PROG-LE';
148: when others then
149: hr_utility.set_location('issue in Getting GSP PROG LE',20);
150: l_status := 'PROG-LE-ERR';
151: end;
152:
153: if l_status is null then

Line 162: hr_utility.set_location('life event '||substr(l_ler_name,1,40),10);

158: where effective_end_date = hr_general.end_of_time
159: and business_group_id = p_business_group_id
160: and typ_cd ='GSP'
161: and lf_evt_oper_cd ='SYNC';
162: hr_utility.set_location('life event '||substr(l_ler_name,1,40),10);
163:
164: if l_effective_start_date <> l_start_of_time then
165: l_status := 'WRONG-DATE-SYNC-LE' ;
166: end if ;

Line 170: hr_utility.set_location('No life event of GSP sync type exists',20);

166: end if ;
167:
168: exception
169: when no_data_found then
170: hr_utility.set_location('No life event of GSP sync type exists',20);
171: l_le_pt_name := get_le_pt_name ('SYNC');
172: l_ler_id := create_life_event (p_business_group_id,p_copy_entity_txn_id,'SYNC',l_le_pt_name) ;
173: l_sync_le_created_flag := 'Y';
174: when too_many_rows then

Line 175: hr_utility.set_location('2 life event of GSP sync type exists',20);

171: l_le_pt_name := get_le_pt_name ('SYNC');
172: l_ler_id := create_life_event (p_business_group_id,p_copy_entity_txn_id,'SYNC',l_le_pt_name) ;
173: l_sync_le_created_flag := 'Y';
174: when too_many_rows then
175: hr_utility.set_location('2 life event of GSP sync type exists',20);
176: l_status := 'MANY-SYNC-LE';
177: when others then
178: hr_utility.set_location('issue in Getting GSP SYNC LE',20);
179: l_status := 'SYNC-LE-ERR';

Line 178: hr_utility.set_location('issue in Getting GSP SYNC LE',20);

174: when too_many_rows then
175: hr_utility.set_location('2 life event of GSP sync type exists',20);
176: l_status := 'MANY-SYNC-LE';
177: when others then
178: hr_utility.set_location('issue in Getting GSP SYNC LE',20);
179: l_status := 'SYNC-LE-ERR';
180: end;
181: end if;
182:

Line 192: hr_utility.set_location('pl_typ name '||substr(l_pt_name,1,40),10);

188: where effective_end_date = hr_general.end_of_time
189: and business_group_id = p_business_group_id
190: and opt_typ_cd ='GSP'
191: and pl_typ_stat_cd ='A';
192: hr_utility.set_location('pl_typ name '||substr(l_pt_name,1,40),10);
193:
194: if l_effective_start_date <> l_start_of_time then
195: l_status := 'WRONG-DATE-PT' ;
196: end if ;

Line 200: hr_utility.set_location('No PT of GSP ',20);

196: end if ;
197:
198: exception
199: when no_data_found then
200: hr_utility.set_location('No PT of GSP ',20);
201: l_le_pt_name := get_le_pt_name ('PLAN');
202: l_pt_id := create_plan_type (p_business_group_id,p_copy_entity_txn_id,l_le_pt_name);
203: l_plan_tp_created_flag := 'Y';
204: when too_many_rows then

Line 205: hr_utility.set_location('many PT of GSP ',20);

201: l_le_pt_name := get_le_pt_name ('PLAN');
202: l_pt_id := create_plan_type (p_business_group_id,p_copy_entity_txn_id,l_le_pt_name);
203: l_plan_tp_created_flag := 'Y';
204: when too_many_rows then
205: hr_utility.set_location('many PT of GSP ',20);
206: l_status := 'MANY-PT';
207: when others then
208: hr_utility.set_location('issue in Getting GSP PT ',20);
209: l_status := 'PT-ERR';

Line 208: hr_utility.set_location('issue in Getting GSP PT ',20);

204: when too_many_rows then
205: hr_utility.set_location('many PT of GSP ',20);
206: l_status := 'MANY-PT';
207: when others then
208: hr_utility.set_location('issue in Getting GSP PT ',20);
209: l_status := 'PT-ERR';
210: end;
211: end if;
212:

Line 214: hr_utility.set_location('setup is fine, update staging area',10);

210: end;
211: end if;
212:
213: if l_status is null then
214: hr_utility.set_location('setup is fine, update staging area',10);
215: update_lept_data(p_copy_entity_txn_id => p_copy_entity_txn_id,
216: p_le_id => l_ler_id,
217: p_pt_id => l_pt_id);
218: p_prog_le_created_flag := l_prog_le_created_flag;

Line 223: hr_utility.set_location('control goes back with status'||l_status,10);

219: p_sync_le_created_flag := l_sync_le_created_flag;
220: p_plan_tp_created_flag := l_plan_tp_created_flag;
221: else
222: p_status := l_status;
223: hr_utility.set_location('control goes back with status'||l_status,10);
224: end if;
225:
226: end setup_check;
227:

Line 245: hr_utility.set_location('deleting step '||l_step_id,10);

241: l_step_id := step_rec.step_id;
242: l_step_ovn := step_rec.object_version_number;
243: l_step_esd := step_rec.effective_start_date;
244: l_step_eed := step_rec.effective_end_date;
245: hr_utility.set_location('deleting step '||l_step_id,10);
246: hr_utility.set_location('ovn '||l_step_ovn,15);
247: hr_grade_step_api.delete_grade_step
248: (p_validate => FALSE
249: ,p_effective_date => p_effective_date

Line 246: hr_utility.set_location('ovn '||l_step_ovn,15);

242: l_step_ovn := step_rec.object_version_number;
243: l_step_esd := step_rec.effective_start_date;
244: l_step_eed := step_rec.effective_end_date;
245: hr_utility.set_location('deleting step '||l_step_id,10);
246: hr_utility.set_location('ovn '||l_step_ovn,15);
247: hr_grade_step_api.delete_grade_step
248: (p_validate => FALSE
249: ,p_effective_date => p_effective_date
250: ,p_datetrack_mode => 'DELETE'

Line 256: hr_utility.set_location('delete step complete'||l_step_id,20);

252: ,p_object_version_number => l_step_ovn
253: ,p_effective_start_date => l_step_esd
254: ,p_effective_end_date => l_step_eed
255: );
256: hr_utility.set_location('delete step complete'||l_step_id,20);
257: end loop;
258: exception
259: when others then
260: hr_utility.set_location('steps could not be deleted',40);

Line 260: hr_utility.set_location('steps could not be deleted',40);

256: hr_utility.set_location('delete step complete'||l_step_id,20);
257: end loop;
258: exception
259: when others then
260: hr_utility.set_location('steps could not be deleted',40);
261: raise;
262: end delete_steps;
263:
264: procedure delete_grade_spine(p_grade_spine_id in number,

Line 271: hr_utility.set_location('inside dele grade spine',10);

267: l_gs_ovn number;
268: l_gs_esd date;
269: l_gs_eed date;
270: begin
271: hr_utility.set_location('inside dele grade spine',10);
272: begin
273: select object_version_number,effective_start_date,effective_end_date
274: into l_gs_ovn,l_gs_esd,l_gs_eed
275: from per_grade_spines_f

Line 280: hr_utility.set_location('issues in selecting grade spine',20);

276: where grade_spine_id = p_grade_spine_id
277: and p_effective_date between effective_start_date and effective_end_date;
278: exception
279: when others then
280: hr_utility.set_location('issues in selecting grade spine',20);
281: raise;
282: end;
283: hr_utility.set_location('grade spine id is'||p_grade_spine_id,10);
284: hr_utility.set_location('grade spine ovn is'||l_gs_ovn,15);

Line 283: hr_utility.set_location('grade spine id is'||p_grade_spine_id,10);

279: when others then
280: hr_utility.set_location('issues in selecting grade spine',20);
281: raise;
282: end;
283: hr_utility.set_location('grade spine id is'||p_grade_spine_id,10);
284: hr_utility.set_location('grade spine ovn is'||l_gs_ovn,15);
285: hr_grade_scale_api.delete_grade_scale
286: (p_validate => FALSE
287: ,p_effective_date => p_effective_date

Line 284: hr_utility.set_location('grade spine ovn is'||l_gs_ovn,15);

280: hr_utility.set_location('issues in selecting grade spine',20);
281: raise;
282: end;
283: hr_utility.set_location('grade spine id is'||p_grade_spine_id,10);
284: hr_utility.set_location('grade spine ovn is'||l_gs_ovn,15);
285: hr_grade_scale_api.delete_grade_scale
286: (p_validate => FALSE
287: ,p_effective_date => p_effective_date
288: ,p_datetrack_mode => P_Date_track_mode

Line 296: hr_utility.set_location('issues in deleting grade spine',40);

292: ,p_effective_end_date => l_gs_eed
293: );
294: exception
295: when others then
296: hr_utility.set_location('issues in deleting grade spine',40);
297: raise;
298: end delete_grade_spine;
299:
300: Procedure Delete_Step (p_copy_entity_txn_id in number,

Line 490: hr_utility.set_location('Invalid Step Id .. ',10);

486:
487: Open Csr_Step_Dtl(Oipl_Rec.Step_id);
488: Fetch Csr_Step_Dtl into l_Effective_Start_Date, l_Effective_End_Date, l_Step_Ovn;
489: If Csr_Step_Dtl%NOTFOUND Then
490: hr_utility.set_location('Invalid Step Id .. ',10);
491: Close Csr_Step_Dtl;
492: Return;
493: End If;
494: Close Csr_Step_Dtl;

Line 495: hr_utility.set_location('Effective Date.. ' || l_Effective_Date,10);

491: Close Csr_Step_Dtl;
492: Return;
493: End If;
494: Close Csr_Step_Dtl;
495: hr_utility.set_location('Effective Date.. ' || l_Effective_Date,10);
496: hr_grade_step_api.delete_grade_step
497: (p_validate => FALSE
498: ,p_effective_date => L_effective_date
499: ,p_datetrack_mode => L_DateTrack_Mode

Line 571: hr_utility.set_location('Delete HR Rate' || Hr_Rate_Rec.Information1 ,20);

567:
568: For Hr_Rate_rec in Csr_Hr_Rt(Rt_Rec.Rt_Id)
569: Loop
570:
571: hr_utility.set_location('Delete HR Rate' || Hr_Rate_Rec.Information1 ,20);
572: If Hr_Rate_Rec.Information1 is NOT NULL then
573:
574: l_Hr_Rt_Ovn := Hr_rate_Rec.Information298;
575:

Line 595: hr_utility.set_location('Delete HR Rate Name ' || l_Rate_Id ,10);

591: Open Rt_Nam_Dtl (Rt_Rec.Rt_id);
592: Fetch Rt_Nam_Dtl into l_rate_Id, l_Rate_type, L_rate_Ovn;
593: Close Rt_Nam_Dtl;
594:
595: hr_utility.set_location('Delete HR Rate Name ' || l_Rate_Id ,10);
596: If l_Rate_Id is NOT NULL Then
597:
598: hr_rate_api.DELETE_RATE
599: (P_EFFECTIVE_DATE => P_Effective_Date

Line 666: hr_utility.set_location('Entering: delete_option',5);

662: --
663: --
664: Begin
665: --
666: hr_utility.set_location('Entering: delete_option',5);
667: --
668: -- Select all the deleted opt rows.
669: --
670: For del_opt_rec in csr_delete_opt loop

Line 697: hr_utility.set_location('Going to Delete Progression Points' || l_Point_Id ,10);

693: Open Csr_Spinal_Point (l_point_Id);
694: Fetch Csr_Spinal_Point Into l_parent_Spine_id, l_Point_Ovn;
695: Close Csr_Spinal_Point;
696:
697: hr_utility.set_location('Going to Delete Progression Points' || l_Point_Id ,10);
698:
699: hr_progression_point_api.Delete_Progression_point
700: (P_SPINAL_POINT_ID => l_Point_Id,
701: P_OBJECT_VERSION_NUMBER => l_Point_Ovn);

Line 703: hr_utility.set_location('Progression Points deleted' || l_Point_Id ,20);

699: hr_progression_point_api.Delete_Progression_point
700: (P_SPINAL_POINT_ID => l_Point_Id,
701: P_OBJECT_VERSION_NUMBER => l_Point_Ovn);
702:
703: hr_utility.set_location('Progression Points deleted' || l_Point_Id ,20);
704:
705: Select Count(Spinal_Point_Id) into L_Spinal_Cnt
706: From Per_Spinal_Points
707: where Parent_Spine_Id = l_Parent_Spine_Id;

Line 715: hr_utility.set_location('PARENT SPINE TO delete' || l_Parent_Spine_Id ,30);

711: Open Csr_Parent_Spine (l_Parent_Spine_Id);
712: Fetch Csr_Parent_Spine Into l_Prnt_Ovn;
713: Close Csr_Parent_Spine ;
714:
715: hr_utility.set_location('PARENT SPINE TO delete' || l_Parent_Spine_Id ,30);
716:
717: hr_pay_scale_api.DELETE_PAY_SCALE
718: (P_PARENT_SPINE_ID => l_Parent_Spine_Id
719: ,P_OBJECT_VERSION_NUMBER => l_Prnt_Ovn);

Line 721: hr_utility.set_location('PARENT SPINE deleted' || l_Parent_Spine_Id ,30);

717: hr_pay_scale_api.DELETE_PAY_SCALE
718: (P_PARENT_SPINE_ID => l_Parent_Spine_Id
719: ,P_OBJECT_VERSION_NUMBER => l_Prnt_Ovn);
720:
721: hr_utility.set_location('PARENT SPINE deleted' || l_Parent_Spine_Id ,30);
722:
723: End If;
724: --
725: End if; -- Csr_ste

Line 732: hr_utility.set_location('Leaving: delete_option',10);

728: End If;
729:
730: End loop;
731: --
732: hr_utility.set_location('Leaving: delete_option',10);
733: --
734: Return 'SUCCESS';
735: --
736: Exception

Line 738: hr_utility.set_location('Exception raised: delete_option',99);

734: Return 'SUCCESS';
735: --
736: Exception
737: When Others Then
738: hr_utility.set_location('Exception raised: delete_option',99);
739: Hr_Utility.Set_Location(Nvl(fnd_message.get,sqlerrm),100);
740: Return 'FAILURE';
741: End;
742:

Line 739: Hr_Utility.Set_Location(Nvl(fnd_message.get,sqlerrm),100);

735: --
736: Exception
737: When Others Then
738: hr_utility.set_location('Exception raised: delete_option',99);
739: Hr_Utility.Set_Location(Nvl(fnd_message.get,sqlerrm),100);
740: Return 'FAILURE';
741: End;
742:
743: Function get_payrate(p_frequency in varchar2 default null,

Line 749: hr_utility.set_location('either freq or scale has to be there ',10);

745: p_scale_id in number default null) return number is
746: l_rate_id number;
747: begin
748: if p_frequency is null and p_scale_id is null then
749: hr_utility.set_location('either freq or scale has to be there ',10);
750: elsif p_frequency is not null then
751: begin
752: select rt.rate_id
753: into l_rate_id

Line 760: hr_utility.set_location('rate exists for freq '||l_rate_id,22);

756: and rt.rate_type ='G'
757: and rt.business_group_id = p_business_group_id
758: and lkp.lookup_type = 'PQH_GSP_GEN_PAY_RATE_NAME'
759: and rt.name = lkp.meaning;
760: hr_utility.set_location('rate exists for freq '||l_rate_id,22);
761: exception
762: when no_data_found then
763: hr_utility.set_location('no pay rate exists for freq '||p_frequency,25);
764: return l_rate_id;

Line 763: hr_utility.set_location('no pay rate exists for freq '||p_frequency,25);

759: and rt.name = lkp.meaning;
760: hr_utility.set_location('rate exists for freq '||l_rate_id,22);
761: exception
762: when no_data_found then
763: hr_utility.set_location('no pay rate exists for freq '||p_frequency,25);
764: return l_rate_id;
765: when others then
766: hr_utility.set_location('issues in selecting freq payrate ',30);
767: raise;

Line 766: hr_utility.set_location('issues in selecting freq payrate ',30);

762: when no_data_found then
763: hr_utility.set_location('no pay rate exists for freq '||p_frequency,25);
764: return l_rate_id;
765: when others then
766: hr_utility.set_location('issues in selecting freq payrate ',30);
767: raise;
768: end;
769: elsif p_scale_id is not null then
770: begin

Line 778: hr_utility.set_location('rate exists for scl '||l_rate_id,22);

774: where rt.parent_spine_id = scl.parent_spine_id
775: and scl.parent_spine_id = p_scale_id
776: and rt.rate_type ='SP'
777: and rt.name = scl.name;
778: hr_utility.set_location('rate exists for scl '||l_rate_id,22);
779: exception
780: when no_data_found then
781: hr_utility.set_location('no pay rate exists for scl '||p_scale_id,25);
782: return l_rate_id;

Line 781: hr_utility.set_location('no pay rate exists for scl '||p_scale_id,25);

777: and rt.name = scl.name;
778: hr_utility.set_location('rate exists for scl '||l_rate_id,22);
779: exception
780: when no_data_found then
781: hr_utility.set_location('no pay rate exists for scl '||p_scale_id,25);
782: return l_rate_id;
783: when others then
784: hr_utility.set_location('issues in selecting scl payrate ',30);
785: raise;

Line 784: hr_utility.set_location('issues in selecting scl payrate ',30);

780: when no_data_found then
781: hr_utility.set_location('no pay rate exists for scl '||p_scale_id,25);
782: return l_rate_id;
783: when others then
784: hr_utility.set_location('issues in selecting scl payrate ',30);
785: raise;
786: end;
787: end if;
788: return l_rate_id;

Line 823: hr_utility.set_location('inside stage_to_payrate',10);

819: and table_alias = 'OPT'
820: and (information256 = p_scl_cer_id or information255 = p_scale_id);
821: l_ovn number;
822: begin
823: hr_utility.set_location('inside stage_to_payrate',10);
824: hr_utility.set_location('gl_freq is '||p_gl_frequency,10);
825: hr_utility.set_location('bg is '||p_business_group_id,10);
826: hr_utility.set_location('inside stage_to_payrate',10);
827: if p_gl_frequency is not null then

Line 824: hr_utility.set_location('gl_freq is '||p_gl_frequency,10);

820: and (information256 = p_scl_cer_id or information255 = p_scale_id);
821: l_ovn number;
822: begin
823: hr_utility.set_location('inside stage_to_payrate',10);
824: hr_utility.set_location('gl_freq is '||p_gl_frequency,10);
825: hr_utility.set_location('bg is '||p_business_group_id,10);
826: hr_utility.set_location('inside stage_to_payrate',10);
827: if p_gl_frequency is not null then
828: l_grd_payrate_id := get_payrate(p_frequency => p_gl_frequency,

Line 825: hr_utility.set_location('bg is '||p_business_group_id,10);

821: l_ovn number;
822: begin
823: hr_utility.set_location('inside stage_to_payrate',10);
824: hr_utility.set_location('gl_freq is '||p_gl_frequency,10);
825: hr_utility.set_location('bg is '||p_business_group_id,10);
826: hr_utility.set_location('inside stage_to_payrate',10);
827: if p_gl_frequency is not null then
828: l_grd_payrate_id := get_payrate(p_frequency => p_gl_frequency,
829: p_business_group_id => p_business_group_id);

Line 826: hr_utility.set_location('inside stage_to_payrate',10);

822: begin
823: hr_utility.set_location('inside stage_to_payrate',10);
824: hr_utility.set_location('gl_freq is '||p_gl_frequency,10);
825: hr_utility.set_location('bg is '||p_business_group_id,10);
826: hr_utility.set_location('inside stage_to_payrate',10);
827: if p_gl_frequency is not null then
828: l_grd_payrate_id := get_payrate(p_frequency => p_gl_frequency,
829: p_business_group_id => p_business_group_id);
830: if l_grd_payrate_id is null then

Line 831: hr_utility.set_location('create grd payrate',20);

827: if p_gl_frequency is not null then
828: l_grd_payrate_id := get_payrate(p_frequency => p_gl_frequency,
829: p_business_group_id => p_business_group_id);
830: if l_grd_payrate_id is null then
831: hr_utility.set_location('create grd payrate',20);
832: pqh_gsp_utility.create_pay_rate
833: (p_business_group_id => p_business_group_id,
834: p_ldr_period_code => p_gl_frequency,
835: p_rate_id => l_grd_payrate_id,

Line 838: hr_utility.set_location('grd payrate is:'||l_grd_payrate_id,30);

834: p_ldr_period_code => p_gl_frequency,
835: p_rate_id => l_grd_payrate_id,
836: p_ovn => l_ovn);
837: end if;
838: hr_utility.set_location('grd payrate is:'||l_grd_payrate_id,30);
839: begin
840: update ben_copy_entity_results
841: set information293 = l_grd_payrate_id
842: where copy_entity_txn_id = p_copy_entity_txn_id

Line 846: hr_utility.set_location('num of hrrs updated'||sql%rowcount,20);

842: where copy_entity_txn_id = p_copy_entity_txn_id
843: and table_alias = 'HRRATE'
844: and information277 is not null
845: and information293 is null;
846: hr_utility.set_location('num of hrrs updated'||sql%rowcount,20);
847: exception
848: when others then
849: hr_utility.set_location('issues in updating hrrate',50);
850: raise;

Line 849: hr_utility.set_location('issues in updating hrrate',50);

845: and information293 is null;
846: hr_utility.set_location('num of hrrs updated'||sql%rowcount,20);
847: exception
848: when others then
849: hr_utility.set_location('issues in updating hrrate',50);
850: raise;
851: end;
852: hr_utility.set_location('grd hrrate rows updated',30);
853: end if;

Line 852: hr_utility.set_location('grd hrrate rows updated',30);

848: when others then
849: hr_utility.set_location('issues in updating hrrate',50);
850: raise;
851: end;
852: hr_utility.set_location('grd hrrate rows updated',30);
853: end if;
854: for i in c1 loop
855: if i.information1 is not null then
856: l_scl_payrate_id := get_payrate(p_scale_id => i.information1,

Line 859: hr_utility.set_location('create scl payrate',20);

855: if i.information1 is not null then
856: l_scl_payrate_id := get_payrate(p_scale_id => i.information1,
857: p_business_group_id => p_business_group_id);
858: if l_scl_payrate_id is null then
859: hr_utility.set_location('create scl payrate',20);
860: pqh_gsp_utility.create_pay_rate
861: (p_business_group_id => p_business_group_id,
862: p_scale_id => i.information1,
863: p_rate_name => i.information98,

Line 867: hr_utility.set_location('scl payrate is:'||l_scl_payrate_id,20);

863: p_rate_name => i.information98,
864: p_rate_id => l_scl_payrate_id,
865: p_ovn => l_ovn);
866: end if;
867: hr_utility.set_location('scl payrate is:'||l_scl_payrate_id,20);
868: hr_utility.set_location('scl cer is:'||i.copy_entity_result_id,25);
869: for j in c2(i.copy_entity_result_id, i.information1) loop
870: -- get all the points for the scale
871: hr_utility.set_location('pt cer is:'||j.copy_entity_result_id,28);

Line 868: hr_utility.set_location('scl cer is:'||i.copy_entity_result_id,25);

864: p_rate_id => l_scl_payrate_id,
865: p_ovn => l_ovn);
866: end if;
867: hr_utility.set_location('scl payrate is:'||l_scl_payrate_id,20);
868: hr_utility.set_location('scl cer is:'||i.copy_entity_result_id,25);
869: for j in c2(i.copy_entity_result_id, i.information1) loop
870: -- get all the points for the scale
871: hr_utility.set_location('pt cer is:'||j.copy_entity_result_id,28);
872: begin

Line 871: hr_utility.set_location('pt cer is:'||j.copy_entity_result_id,28);

867: hr_utility.set_location('scl payrate is:'||l_scl_payrate_id,20);
868: hr_utility.set_location('scl cer is:'||i.copy_entity_result_id,25);
869: for j in c2(i.copy_entity_result_id, i.information1) loop
870: -- get all the points for the scale
871: hr_utility.set_location('pt cer is:'||j.copy_entity_result_id,28);
872: begin
873: update ben_copy_entity_results
874: set information293 = l_scl_payrate_id
875: where copy_entity_txn_id = p_copy_entity_txn_id

Line 879: hr_utility.set_location('num of hrrs updated'||sql%rowcount,20);

875: where copy_entity_txn_id = p_copy_entity_txn_id
876: and table_alias = 'HRRATE'
877: and information278 = j.copy_entity_result_id
878: and information293 is null;
879: hr_utility.set_location('num of hrrs updated'||sql%rowcount,20);
880: exception
881: when others then
882: hr_utility.set_location('issues in updating hrrate',50);
883: raise;

Line 882: hr_utility.set_location('issues in updating hrrate',50);

878: and information293 is null;
879: hr_utility.set_location('num of hrrs updated'||sql%rowcount,20);
880: exception
881: when others then
882: hr_utility.set_location('issues in updating hrrate',50);
883: raise;
884: end;
885: end loop;
886: else

Line 887: hr_utility.set_location('scl id is:'||i.information1,20);

883: raise;
884: end;
885: end loop;
886: else
887: hr_utility.set_location('scl id is:'||i.information1,20);
888: end if;
889: end loop;
890: hr_utility.set_location('pt hrrate rows updated',30);
891: end stage_to_prate;

Line 890: hr_utility.set_location('pt hrrate rows updated',30);

886: else
887: hr_utility.set_location('scl id is:'||i.information1,20);
888: end if;
889: end loop;
890: hr_utility.set_location('pt hrrate rows updated',30);
891: end stage_to_prate;
892: procedure pt_writeback(p_copy_entity_txn_id in number,
893: p_point_id in number,
894: p_point_cer_id in number) is

Line 896: hr_utility.set_location('pt writeback start for pt :'||p_point_id,10);

892: procedure pt_writeback(p_copy_entity_txn_id in number,
893: p_point_id in number,
894: p_point_cer_id in number) is
895: begin
896: hr_utility.set_location('pt writeback start for pt :'||p_point_id,10);
897: hr_utility.set_location('pt cer:'||p_point_cer_id,10);
898: begin
899: -- opt row is updated with point id
900: update ben_copy_entity_results

Line 897: hr_utility.set_location('pt cer:'||p_point_cer_id,10);

893: p_point_id in number,
894: p_point_cer_id in number) is
895: begin
896: hr_utility.set_location('pt writeback start for pt :'||p_point_id,10);
897: hr_utility.set_location('pt cer:'||p_point_cer_id,10);
898: begin
899: -- opt row is updated with point id
900: update ben_copy_entity_results
901: set information257 = p_point_id

Line 905: hr_utility.set_location('num of opt updated'||sql%rowcount,20);

901: set information257 = p_point_id
902: where copy_entity_txn_id = p_copy_entity_txn_id
903: and table_alias ='OPT'
904: and copy_entity_result_id = p_point_cer_id;
905: hr_utility.set_location('num of opt updated'||sql%rowcount,20);
906: exception
907: when others then
908: hr_utility.set_location('issues in updating pt to opt',10);
909: raise;

Line 908: hr_utility.set_location('issues in updating pt to opt',10);

904: and copy_entity_result_id = p_point_cer_id;
905: hr_utility.set_location('num of opt updated'||sql%rowcount,20);
906: exception
907: when others then
908: hr_utility.set_location('issues in updating pt to opt',10);
909: raise;
910: end;
911: begin
912: -- oipl rows are to be updated with point id

Line 918: hr_utility.set_location('num of oipl updated'||sql%rowcount,20);

914: set information256 = p_point_id
915: where table_alias = 'COP'
916: and copy_entity_txn_id = p_copy_entity_txn_id
917: and information262 = p_point_cer_id;
918: hr_utility.set_location('num of oipl updated'||sql%rowcount,20);
919: exception
920: when others then
921: hr_utility.set_location('issues in updating pt to oipl ',20);
922: raise;

Line 921: hr_utility.set_location('issues in updating pt to oipl ',20);

917: and information262 = p_point_cer_id;
918: hr_utility.set_location('num of oipl updated'||sql%rowcount,20);
919: exception
920: when others then
921: hr_utility.set_location('issues in updating pt to oipl ',20);
922: raise;
923: end;
924: begin
925: -- hrrate rows are to be updated with point id

Line 931: hr_utility.set_location('num of hrrs updated'||sql%rowcount,20);

927: set information276 = p_point_id
928: where table_alias = 'HRRATE'
929: and copy_entity_txn_id = p_copy_entity_txn_id
930: and information278 = p_point_cer_id;
931: hr_utility.set_location('num of hrrs updated'||sql%rowcount,20);
932: exception
933: when others then
934: hr_utility.set_location('issues in updating pt to hrrate ',30);
935: raise;

Line 934: hr_utility.set_location('issues in updating pt to hrrate ',30);

930: and information278 = p_point_cer_id;
931: hr_utility.set_location('num of hrrs updated'||sql%rowcount,20);
932: exception
933: when others then
934: hr_utility.set_location('issues in updating pt to hrrate ',30);
935: raise;
936: end;
937: end pt_writeback;
938: procedure step_writeback(p_copy_entity_txn_id in number,

Line 944: hr_utility.set_location('step writeback start for step :'||p_step_id,10);

940: p_step_cer_id in number,
941: p_effective_date in date) is
942: l_oipl_id number;
943: begin
944: hr_utility.set_location('step writeback start for step :'||p_step_id,10);
945: hr_utility.set_location('step cer:'||p_step_cer_id,10);
946: begin
947: l_oipl_id := pqh_gsp_hr_to_stage.get_oipl_for_step(p_step_id => p_step_id,
948: p_effective_date => p_effective_date);

Line 945: hr_utility.set_location('step cer:'||p_step_cer_id,10);

941: p_effective_date in date) is
942: l_oipl_id number;
943: begin
944: hr_utility.set_location('step writeback start for step :'||p_step_id,10);
945: hr_utility.set_location('step cer:'||p_step_cer_id,10);
946: begin
947: l_oipl_id := pqh_gsp_hr_to_stage.get_oipl_for_step(p_step_id => p_step_id,
948: p_effective_date => p_effective_date);
949: exception

Line 969: hr_utility.set_location('num of oipl updated'||sql%rowcount,20);

965: information1 = nvl(information1,l_oipl_id)
966: where copy_entity_txn_id = p_copy_entity_txn_id
967: and table_alias ='COP'
968: and copy_entity_result_id = p_step_cer_id;
969: hr_utility.set_location('num of oipl updated'||sql%rowcount,20);
970: exception
971: when others then
972: hr_utility.set_location('issues in updating step to cop',10);
973: raise;

Line 972: hr_utility.set_location('issues in updating step to cop',10);

968: and copy_entity_result_id = p_step_cer_id;
969: hr_utility.set_location('num of oipl updated'||sql%rowcount,20);
970: exception
971: when others then
972: hr_utility.set_location('issues in updating step to cop',10);
973: raise;
974: end;
975: end step_writeback;
976: procedure hrr_writeback(p_grade_cer_id in number,

Line 989: hr_utility.set_location('num of abrs updated'||sql%rowcount,20);

985: where copy_entity_txn_id = p_copy_entity_txn_id
986: and table_alias ='ABR'
987: and (information277 is null or information277 = p_grade_cer_id)
988: and (information278 is null or information278 = p_point_cer_id);
989: hr_utility.set_location('num of abrs updated'||sql%rowcount,20);
990: exception
991: when others then
992: hr_utility.set_location('issues in updating hrrate to abr',10);
993: raise;

Line 992: hr_utility.set_location('issues in updating hrrate to abr',10);

988: and (information278 is null or information278 = p_point_cer_id);
989: hr_utility.set_location('num of abrs updated'||sql%rowcount,20);
990: exception
991: when others then
992: hr_utility.set_location('issues in updating hrrate to abr',10);
993: raise;
994: end;
995: end hrr_writeback;
996: procedure grd_sp_writeback(p_plip_cer_id in number,

Line 1007: hr_utility.set_location('num of plips updated'||sql%rowcount,20);

1003: set information280 = p_grade_spine_id
1004: where copy_entity_txn_id = p_copy_entity_txn_id
1005: and table_alias ='CPP'
1006: and copy_entity_result_id = p_plip_cer_id;
1007: hr_utility.set_location('num of plips updated'||sql%rowcount,20);
1008: exception
1009: when others then
1010: hr_utility.set_location('issues in updating gs to plip',10);
1011: raise;

Line 1010: hr_utility.set_location('issues in updating gs to plip',10);

1006: and copy_entity_result_id = p_plip_cer_id;
1007: hr_utility.set_location('num of plips updated'||sql%rowcount,20);
1008: exception
1009: when others then
1010: hr_utility.set_location('issues in updating gs to plip',10);
1011: raise;
1012: end;
1013: begin
1014: -- oipl row is updated with grade spine id

Line 1020: hr_utility.set_location('num of oipls updated'||sql%rowcount,20);

1016: set information255 = p_grade_spine_id
1017: where copy_entity_txn_id = p_copy_entity_txn_id
1018: and table_alias ='COP'
1019: and gs_parent_entity_result_id = p_plip_cer_id;
1020: hr_utility.set_location('num of oipls updated'||sql%rowcount,20);
1021: exception
1022: when others then
1023: hr_utility.set_location('issues in updating gs to oipl',10);
1024: raise;

Line 1023: hr_utility.set_location('issues in updating gs to oipl',10);

1019: and gs_parent_entity_result_id = p_plip_cer_id;
1020: hr_utility.set_location('num of oipls updated'||sql%rowcount,20);
1021: exception
1022: when others then
1023: hr_utility.set_location('issues in updating gs to oipl',10);
1024: raise;
1025: end;
1026: end grd_sp_writeback;
1027: procedure scl_writeback(p_copy_entity_txn_id in number,

Line 1038: hr_utility.set_location('num of scales updated'||sql%rowcount,20);

1034: set information1 = p_scale_id
1035: where copy_entity_txn_id = p_copy_entity_txn_id
1036: and table_alias ='SCALE'
1037: and copy_entity_result_id = p_scale_cer_id;
1038: hr_utility.set_location('num of scales updated'||sql%rowcount,20);
1039: exception
1040: when others then
1041: hr_utility.set_location('issues in updating sclid to scl',5);
1042: raise;

Line 1041: hr_utility.set_location('issues in updating sclid to scl',5);

1037: and copy_entity_result_id = p_scale_cer_id;
1038: hr_utility.set_location('num of scales updated'||sql%rowcount,20);
1039: exception
1040: when others then
1041: hr_utility.set_location('issues in updating sclid to scl',5);
1042: raise;
1043: end;
1044: begin
1045: -- plip row is updated with Scale id

Line 1051: hr_utility.set_location('num of plips updated'||sql%rowcount,20);

1047: set information255 = p_scale_id
1048: where copy_entity_txn_id = p_copy_entity_txn_id
1049: and table_alias ='CPP'
1050: and information258 = p_scale_cer_id;
1051: hr_utility.set_location('num of plips updated'||sql%rowcount,20);
1052: exception
1053: when others then
1054: hr_utility.set_location('issues in updating scl to plip',10);
1055: raise;

Line 1054: hr_utility.set_location('issues in updating scl to plip',10);

1050: and information258 = p_scale_cer_id;
1051: hr_utility.set_location('num of plips updated'||sql%rowcount,20);
1052: exception
1053: when others then
1054: hr_utility.set_location('issues in updating scl to plip',10);
1055: raise;
1056: end;
1057: begin
1058: -- opt rows are to be updated with Scale id

Line 1064: hr_utility.set_location('num of opts updated'||sql%rowcount,20);

1060: set information255 = p_scale_id
1061: where table_alias = 'OPT'
1062: and copy_entity_txn_id = p_copy_entity_txn_id
1063: and information256 = p_scale_cer_id;
1064: hr_utility.set_location('num of opts updated'||sql%rowcount,20);
1065: exception
1066: when others then
1067: hr_utility.set_location('issues in updating scl to opt ',20);
1068: raise;

Line 1067: hr_utility.set_location('issues in updating scl to opt ',20);

1063: and information256 = p_scale_cer_id;
1064: hr_utility.set_location('num of opts updated'||sql%rowcount,20);
1065: exception
1066: when others then
1067: hr_utility.set_location('issues in updating scl to opt ',20);
1068: raise;
1069: end;
1070: begin
1071: -- oipl rows are to be updated with Scale id

Line 1077: hr_utility.set_location('num of plips updated'||sql%rowcount,20);

1073: set information260 = p_scale_id
1074: where table_alias = 'COP'
1075: and copy_entity_txn_id = p_copy_entity_txn_id
1076: and information259 = p_scale_cer_id;
1077: hr_utility.set_location('num of plips updated'||sql%rowcount,20);
1078: exception
1079: when others then
1080: hr_utility.set_location('issues in updating scl to oipl ',30);
1081: raise;

Line 1080: hr_utility.set_location('issues in updating scl to oipl ',30);

1076: and information259 = p_scale_cer_id;
1077: hr_utility.set_location('num of plips updated'||sql%rowcount,20);
1078: exception
1079: when others then
1080: hr_utility.set_location('issues in updating scl to oipl ',30);
1081: raise;
1082: end;
1083: end scl_writeback;
1084: procedure grd_writeback(p_copy_entity_txn_id in number,

Line 1088: hr_utility.set_location('writing back grd '||p_grade_id,10);

1084: procedure grd_writeback(p_copy_entity_txn_id in number,
1085: p_grade_id in number,
1086: p_grade_cer_id in number) is
1087: begin
1088: hr_utility.set_location('writing back grd '||p_grade_id,10);
1089: hr_utility.set_location('writing back grdcer '||p_grade_cer_id,10);
1090: begin
1091: -- plip row is updated with Grade id
1092: update ben_copy_entity_results

Line 1089: hr_utility.set_location('writing back grdcer '||p_grade_cer_id,10);

1085: p_grade_id in number,
1086: p_grade_cer_id in number) is
1087: begin
1088: hr_utility.set_location('writing back grd '||p_grade_id,10);
1089: hr_utility.set_location('writing back grdcer '||p_grade_cer_id,10);
1090: begin
1091: -- plip row is updated with Grade id
1092: update ben_copy_entity_results
1093: set information253 = p_grade_id

Line 1097: hr_utility.set_location('num of plips updated'||sql%rowcount,20);

1093: set information253 = p_grade_id
1094: where copy_entity_txn_id = p_copy_entity_txn_id
1095: and table_alias = 'CPP'
1096: and information252 = p_grade_cer_id;
1097: hr_utility.set_location('num of plips updated'||sql%rowcount,20);
1098: exception
1099: when others then
1100: hr_utility.set_location('issues in updating grd to plip',10);
1101: raise;

Line 1100: hr_utility.set_location('issues in updating grd to plip',10);

1096: and information252 = p_grade_cer_id;
1097: hr_utility.set_location('num of plips updated'||sql%rowcount,20);
1098: exception
1099: when others then
1100: hr_utility.set_location('issues in updating grd to plip',10);
1101: raise;
1102: end;
1103: begin
1104: -- plan row is updated with Grade id

Line 1109: hr_utility.set_location('num of pl updated'||sql%rowcount,20);

1105: update ben_copy_entity_results
1106: set information223 = p_grade_id,
1107: information294 = p_grade_id
1108: where copy_entity_result_id = p_grade_cer_id;
1109: hr_utility.set_location('num of pl updated'||sql%rowcount,20);
1110: exception
1111: when others then
1112: hr_utility.set_location('issues in updating grd to pl',10);
1113: raise;

Line 1112: hr_utility.set_location('issues in updating grd to pl',10);

1108: where copy_entity_result_id = p_grade_cer_id;
1109: hr_utility.set_location('num of pl updated'||sql%rowcount,20);
1110: exception
1111: when others then
1112: hr_utility.set_location('issues in updating grd to pl',10);
1113: raise;
1114: end;
1115: begin
1116: -- hrrate row is to be updated with Grade id

Line 1122: hr_utility.set_location('num of hrate updated'||sql%rowcount,20);

1118: set information255 = p_grade_id
1119: where table_alias = 'HRRATE'
1120: and copy_entity_txn_id = p_copy_entity_txn_id
1121: and information277 = p_grade_cer_id;
1122: hr_utility.set_location('num of hrate updated'||sql%rowcount,20);
1123: exception
1124: when others then
1125: hr_utility.set_location('issues in updating grd to hrrate',20);
1126: raise;

Line 1125: hr_utility.set_location('issues in updating grd to hrrate',20);

1121: and information277 = p_grade_cer_id;
1122: hr_utility.set_location('num of hrate updated'||sql%rowcount,20);
1123: exception
1124: when others then
1125: hr_utility.set_location('issues in updating grd to hrrate',20);
1126: raise;
1127: end;
1128: end grd_writeback;
1129: function get_max_grd_seq(p_business_group_id in number) return number is

Line 1139: hr_utility.set_location('no grd found ',10);

1135: l_max_seq := nvl(l_max_seq,0) +1;
1136: return l_max_seq;
1137: exception
1138: when no_data_found then
1139: hr_utility.set_location('no grd found ',10);
1140: return 0;
1141: when others then
1142: hr_utility.set_location('issues in getting max grd seq',20);
1143: raise;

Line 1142: hr_utility.set_location('issues in getting max grd seq',20);

1138: when no_data_found then
1139: hr_utility.set_location('no grd found ',10);
1140: return 0;
1141: when others then
1142: hr_utility.set_location('issues in getting max grd seq',20);
1143: raise;
1144: end get_max_grd_seq;
1145: function get_bg_for_cet(p_copy_entity_txn_id in number) return number is
1146: l_bg_id number;

Line 1155: hr_utility.set_location('CET doesnot exist'||p_copy_entity_txn_id,10);

1151: where copy_entity_txn_id = p_copy_entity_txn_id;
1152: return l_bg_id;
1153: exception
1154: when no_data_found then
1155: hr_utility.set_location('CET doesnot exist'||p_copy_entity_txn_id,10);
1156: raise;
1157: when others then
1158: hr_utility.set_location('issues in getting bg for CET ',20);
1159: raise;

Line 1158: hr_utility.set_location('issues in getting bg for CET ',20);

1154: when no_data_found then
1155: hr_utility.set_location('CET doesnot exist'||p_copy_entity_txn_id,10);
1156: raise;
1157: when others then
1158: hr_utility.set_location('issues in getting bg for CET ',20);
1159: raise;
1160: end get_bg_for_cet;
1161: function get_grd_segment(p_grade_id in number,
1162: p_grade_definition_id in number) return varchar2 is

Line 1178: hr_utility.set_location('inside pre-push',1);

1174: l_return varchar2(30);
1175: l_effective_date date;
1176: l_Del_Dt_Mode Varchar2(30);
1177: begin
1178: hr_utility.set_location('inside pre-push',1);
1179: If P_Date_Track_Mode = 'UPDATE_OVERRIDE' Then
1180: l_Del_Dt_Mode := 'DELETE';
1181: Else
1182: l_Del_Dt_Mode := 'ZAP';

Line 1198: hr_utility.set_location('effective date set',1);

1194: insert into fnd_sessions(session_id,effective_date) values(userenv('sessionid'), p_effective_date);
1195: when others then
1196: raise;
1197: end;
1198: hr_utility.set_location('effective date set',1);
1199: begin
1200: update ben_copy_entity_results
1201: set dml_operation = 'DELETE'
1202: where copy_entity_txn_id = p_copy_entity_txn_id

Line 1205: hr_utility.set_location('num of unlinks updated'||sql%rowcount,2);

1201: set dml_operation = 'DELETE'
1202: where copy_entity_txn_id = p_copy_entity_txn_id
1203: and table_alias in ('COP','OPT','CPP','HRRATE','ABR')
1204: and information104 = 'UNLINK';
1205: hr_utility.set_location('num of unlinks updated'||sql%rowcount,2);
1206: exception
1207: when others then
1208: hr_utility.set_location('issues in marking recs for delete',1);
1209: raise;

Line 1208: hr_utility.set_location('issues in marking recs for delete',1);

1204: and information104 = 'UNLINK';
1205: hr_utility.set_location('num of unlinks updated'||sql%rowcount,2);
1206: exception
1207: when others then
1208: hr_utility.set_location('issues in marking recs for delete',1);
1209: raise;
1210: end;
1211: hr_utility.set_location('calling delete obj',1);
1212:

Line 1211: hr_utility.set_location('calling delete obj',1);

1207: when others then
1208: hr_utility.set_location('issues in marking recs for delete',1);
1209: raise;
1210: end;
1211: hr_utility.set_location('calling delete obj',1);
1212:
1213: -- Delete HR Steps if any found. This will inturn Delete the OIPLs
1214:
1215:

Line 1273: hr_utility.set_location('leaving pre-push',100);

1269: p_effective_date => p_effective_date,
1270: p_business_group_id => p_business_group_id);
1271:
1272: END IF;
1273: hr_utility.set_location('leaving pre-push',100);
1274: end pre_push_data;
1275:
1276: procedure post_push_data(p_copy_entity_txn_id in number,
1277: p_effective_date in date,

Line 1282: hr_utility.set_location('inside post_data_push',10);

1278: p_business_group_id in number,
1279: p_business_area in varchar2 default 'PQH_GSP_TASK_LIST') is
1280: l_message_text varchar2(2000);
1281: begin
1282: hr_utility.set_location('inside post_data_push',10);
1283: /* l_message_text := 'cet id'||p_copy_entity_txn_id
1284: ||'business_group_id is '||p_business_group_id
1285: ||'effdt is '||to_char(p_effective_date,'dd-mm-RRRR')
1286: ||'bus area is '||p_business_area;

Line 1299: hr_utility.set_location('leaving post_data_push',10);

1295: pqh_gsp_hr_to_stage.update_gsp_control_rec
1296: (p_copy_entity_txn_id => p_copy_entity_txn_id,
1297: p_effective_date => p_effective_date,
1298: p_business_area => p_business_area);
1299: hr_utility.set_location('leaving post_data_push',10);
1300: end post_push_data;
1301: procedure gsp_data_push(p_copy_entity_txn_id in number,
1302: p_effective_date in date,
1303: p_business_group_id in number,

Line 1312: hr_utility.set_location('inside gsp_data_push',10);

1308: l_gl_name varchar2(80);
1309: l_datetrack_mode varchar2(30);
1310: l_continue varchar2(30) := 'Y';
1311: begin
1312: hr_utility.set_location('inside gsp_data_push',10);
1313: if p_datetrack_mode = 'CORR' then
1314: l_datetrack_mode := 'CORRECTION';
1315: elsif p_datetrack_mode = 'UPDATE' then
1316: l_datetrack_mode := 'UPDATE_OVERRIDE';

Line 1318: hr_utility.set_location('invalid dt mode passed',10);

1314: l_datetrack_mode := 'CORRECTION';
1315: elsif p_datetrack_mode = 'UPDATE' then
1316: l_datetrack_mode := 'UPDATE_OVERRIDE';
1317: else
1318: hr_utility.set_location('invalid dt mode passed',10);
1319: l_continue := 'N';
1320: end if;
1321: if l_continue = 'Y' then
1322: hr_utility.set_location('dt_mode set',10);

Line 1322: hr_utility.set_location('dt_mode set',10);

1318: hr_utility.set_location('invalid dt mode passed',10);
1319: l_continue := 'N';
1320: end if;
1321: if l_continue = 'Y' then
1322: hr_utility.set_location('dt_mode set',10);
1323: begin
1324: hr_utility.set_location('going for pgm datapull',20);
1325: select information50,information41,substr(information5,1,80)
1326: into l_gl_currency,l_gl_freq,l_gl_name

Line 1324: hr_utility.set_location('going for pgm datapull',20);

1320: end if;
1321: if l_continue = 'Y' then
1322: hr_utility.set_location('dt_mode set',10);
1323: begin
1324: hr_utility.set_location('going for pgm datapull',20);
1325: select information50,information41,substr(information5,1,80)
1326: into l_gl_currency,l_gl_freq,l_gl_name
1327: from ben_copy_entity_results
1328: where copy_entity_txn_id = p_copy_entity_txn_id

Line 1331: hr_utility.set_location('curr and freq of pgm fetched',10);

1327: from ben_copy_entity_results
1328: where copy_entity_txn_id = p_copy_entity_txn_id
1329: and result_type_cd ='DISPLAY'
1330: and table_alias = 'PGM';
1331: hr_utility.set_location('curr and freq of pgm fetched',10);
1332: exception
1333: when others then
1334: hr_utility.set_location('issues in selecting pgm row ',10);
1335: raise;

Line 1334: hr_utility.set_location('issues in selecting pgm row ',10);

1330: and table_alias = 'PGM';
1331: hr_utility.set_location('curr and freq of pgm fetched',10);
1332: exception
1333: when others then
1334: hr_utility.set_location('issues in selecting pgm row ',10);
1335: raise;
1336: end;
1337: end if;
1338: if l_continue = 'Y' then

Line 1350: hr_utility.set_location('pre push done ',20);

1346: p_effective_date => p_effective_date,
1347: p_business_group_id => p_business_group_id,
1348: P_Date_Track_Mode => l_datetrack_mode);
1349:
1350: hr_utility.set_location('pre push done ',20);
1351:
1352: stage_to_hr(p_copy_entity_txn_id => p_copy_entity_txn_id,
1353: p_effective_date => p_effective_date,
1354: p_business_group_id => p_business_group_id,

Line 1361: hr_utility.set_location('data pushed to hr ',20);

1357: p_gl_name => l_gl_name,
1358: p_datetrack_mode => l_datetrack_mode,
1359: p_business_area => p_business_area);
1360:
1361: hr_utility.set_location('data pushed to hr ',20);
1362:
1363: pqh_gsp_stage_to_ben.cre_update_elig_prfl(
1364: p_copy_entity_txn_id => p_copy_entity_txn_id
1365: ,p_effective_date => p_effective_date

Line 1368: hr_utility.set_location('Elpros created/updated',20);

1364: p_copy_entity_txn_id => p_copy_entity_txn_id
1365: ,p_effective_date => p_effective_date
1366: ,p_business_group_id => p_business_group_id);
1367:
1368: hr_utility.set_location('Elpros created/updated',20);
1369:
1370: pqh_gsp_stage_to_ben.stage_to_ben
1371: (p_copy_entity_txn_id => p_copy_entity_txn_id,
1372: p_effective_date => p_effective_date,

Line 1377: hr_utility.set_location('data pushed to ben ',20);

1373: p_business_group_id => p_business_group_id,
1374: p_datetrack_mode => l_datetrack_mode,
1375: p_business_area => p_business_area);
1376:
1377: hr_utility.set_location('data pushed to ben ',20);
1378:
1379: post_push_data(p_copy_entity_txn_id => p_copy_entity_txn_id,
1380: p_effective_date => p_effective_date,
1381: p_business_group_id => p_business_group_id,

Line 1384: hr_utility.set_location('post data push done ',40);

1380: p_effective_date => p_effective_date,
1381: p_business_group_id => p_business_group_id,
1382: p_business_area => p_business_area);
1383:
1384: hr_utility.set_location('post data push done ',40);
1385:
1386: begin
1387:
1388: update pqh_copy_entity_txns

Line 1398: hr_utility.set_location('txn stat chg to comp',40);

1394: Delete from Ben_Copy_Entity_Results
1395: where Copy_Entity_Txn_Id = p_copy_entity_txn_id
1396: and Table_Alias Not In ('PQH_GSP_TASK_LIST','PQH_CORPS_TASK_LIST');
1397:
1398: hr_utility.set_location('txn stat chg to comp',40);
1399: exception
1400: when others then
1401: hr_utility.set_location('issues in updating cet row ',10);
1402: raise;

Line 1401: hr_utility.set_location('issues in updating cet row ',10);

1397:
1398: hr_utility.set_location('txn stat chg to comp',40);
1399: exception
1400: when others then
1401: hr_utility.set_location('issues in updating cet row ',10);
1402: raise;
1403: end;
1404: PQH_PROCESS_BATCH_LOG.END_LOG;
1405: exception

Line 1407: hr_utility.set_location('issues in writing data ',10);

1403: end;
1404: PQH_PROCESS_BATCH_LOG.END_LOG;
1405: exception
1406: when others then
1407: hr_utility.set_location('issues in writing data ',10);
1408: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS
1409: (P_MASTER_TXN_ID => p_copy_entity_txn_id,
1410: P_TXN_ID => p_copy_entity_txn_id,
1411: p_context => 'GSP_DATA_PUSH',

Line 1449: hr_utility.set_location('inside '||l_proc,10);

1445: */
1446: l_proc varchar2(61) := 'stage_to_hr' ;
1447: l_effective_date date := p_effective_date;
1448: begin
1449: hr_utility.set_location('inside '||l_proc,10);
1450: hr_utility.set_location('cet is '||p_copy_entity_txn_id,1);
1451: hr_utility.set_location('bg is '||p_business_group_id,2);
1452: hr_utility.set_location('curr is '||p_gl_currency,3);
1453: hr_utility.set_location('dt mode is '||p_datetrack_mode,4);

Line 1450: hr_utility.set_location('cet is '||p_copy_entity_txn_id,1);

1446: l_proc varchar2(61) := 'stage_to_hr' ;
1447: l_effective_date date := p_effective_date;
1448: begin
1449: hr_utility.set_location('inside '||l_proc,10);
1450: hr_utility.set_location('cet is '||p_copy_entity_txn_id,1);
1451: hr_utility.set_location('bg is '||p_business_group_id,2);
1452: hr_utility.set_location('curr is '||p_gl_currency,3);
1453: hr_utility.set_location('dt mode is '||p_datetrack_mode,4);
1454: stage_to_grade(p_copy_entity_txn_id => p_copy_entity_txn_id,

Line 1451: hr_utility.set_location('bg is '||p_business_group_id,2);

1447: l_effective_date date := p_effective_date;
1448: begin
1449: hr_utility.set_location('inside '||l_proc,10);
1450: hr_utility.set_location('cet is '||p_copy_entity_txn_id,1);
1451: hr_utility.set_location('bg is '||p_business_group_id,2);
1452: hr_utility.set_location('curr is '||p_gl_currency,3);
1453: hr_utility.set_location('dt mode is '||p_datetrack_mode,4);
1454: stage_to_grade(p_copy_entity_txn_id => p_copy_entity_txn_id,
1455: p_effective_date => l_effective_date,

Line 1452: hr_utility.set_location('curr is '||p_gl_currency,3);

1448: begin
1449: hr_utility.set_location('inside '||l_proc,10);
1450: hr_utility.set_location('cet is '||p_copy_entity_txn_id,1);
1451: hr_utility.set_location('bg is '||p_business_group_id,2);
1452: hr_utility.set_location('curr is '||p_gl_currency,3);
1453: hr_utility.set_location('dt mode is '||p_datetrack_mode,4);
1454: stage_to_grade(p_copy_entity_txn_id => p_copy_entity_txn_id,
1455: p_effective_date => l_effective_date,
1456: p_business_group_id => p_business_group_id);

Line 1453: hr_utility.set_location('dt mode is '||p_datetrack_mode,4);

1449: hr_utility.set_location('inside '||l_proc,10);
1450: hr_utility.set_location('cet is '||p_copy_entity_txn_id,1);
1451: hr_utility.set_location('bg is '||p_business_group_id,2);
1452: hr_utility.set_location('curr is '||p_gl_currency,3);
1453: hr_utility.set_location('dt mode is '||p_datetrack_mode,4);
1454: stage_to_grade(p_copy_entity_txn_id => p_copy_entity_txn_id,
1455: p_effective_date => l_effective_date,
1456: p_business_group_id => p_business_group_id);
1457: hr_utility.set_location('grade row checked for update',30);

Line 1457: hr_utility.set_location('grade row checked for update',30);

1453: hr_utility.set_location('dt mode is '||p_datetrack_mode,4);
1454: stage_to_grade(p_copy_entity_txn_id => p_copy_entity_txn_id,
1455: p_effective_date => l_effective_date,
1456: p_business_group_id => p_business_group_id);
1457: hr_utility.set_location('grade row checked for update',30);
1458: stage_to_scale(p_copy_entity_txn_id => p_copy_entity_txn_id,
1459: p_effective_date => l_effective_date,
1460: p_business_group_id => p_business_group_id,
1461: p_business_area => p_business_area);

Line 1462: hr_utility.set_location('Scale row updated',40);

1458: stage_to_scale(p_copy_entity_txn_id => p_copy_entity_txn_id,
1459: p_effective_date => l_effective_date,
1460: p_business_group_id => p_business_group_id,
1461: p_business_area => p_business_area);
1462: hr_utility.set_location('Scale row updated',40);
1463: stage_to_prate(p_copy_entity_txn_id => p_copy_entity_txn_id,
1464: p_effective_date => l_effective_date,
1465: p_business_group_id => p_business_group_id,
1466: p_gl_frequency => p_gl_frequency);

Line 1467: hr_utility.set_location('pay rates created if any reqd',41);

1463: stage_to_prate(p_copy_entity_txn_id => p_copy_entity_txn_id,
1464: p_effective_date => l_effective_date,
1465: p_business_group_id => p_business_group_id,
1466: p_gl_frequency => p_gl_frequency);
1467: hr_utility.set_location('pay rates created if any reqd',41);
1468: stage_to_grd_sp(p_copy_entity_txn_id => p_copy_entity_txn_id,
1469: p_effective_date => l_effective_date,
1470: p_business_group_id => p_business_group_id,
1471: p_datetrack_mode => p_datetrack_mode);

Line 1472: hr_utility.set_location('grade spine row updated',40);

1468: stage_to_grd_sp(p_copy_entity_txn_id => p_copy_entity_txn_id,
1469: p_effective_date => l_effective_date,
1470: p_business_group_id => p_business_group_id,
1471: p_datetrack_mode => p_datetrack_mode);
1472: hr_utility.set_location('grade spine row updated',40);
1473: stage_to_point(p_copy_entity_txn_id => p_copy_entity_txn_id,
1474: p_effective_date => l_effective_date,
1475: p_business_group_id => p_business_group_id,
1476: p_business_area => p_business_area);

Line 1477: hr_utility.set_location('option row updated',50);

1473: stage_to_point(p_copy_entity_txn_id => p_copy_entity_txn_id,
1474: p_effective_date => l_effective_date,
1475: p_business_group_id => p_business_group_id,
1476: p_business_area => p_business_area);
1477: hr_utility.set_location('option row updated',50);
1478: stage_to_step(p_copy_entity_txn_id => p_copy_entity_txn_id,
1479: p_effective_date => l_effective_date,
1480: p_business_group_id => p_business_group_id,
1481: p_datetrack_mode => p_datetrack_mode);

Line 1482: hr_utility.set_location('oipl row updated',60);

1478: stage_to_step(p_copy_entity_txn_id => p_copy_entity_txn_id,
1479: p_effective_date => l_effective_date,
1480: p_business_group_id => p_business_group_id,
1481: p_datetrack_mode => p_datetrack_mode);
1482: hr_utility.set_location('oipl row updated',60);
1483: stage_to_hrate(p_copy_entity_txn_id => p_copy_entity_txn_id,
1484: p_effective_date => l_effective_date,
1485: p_gl_currency => p_gl_currency,
1486: p_business_group_id => p_business_group_id,

Line 1488: hr_utility.set_location('Hrate row updated',70);

1484: p_effective_date => l_effective_date,
1485: p_gl_currency => p_gl_currency,
1486: p_business_group_id => p_business_group_id,
1487: p_datetrack_mode => p_datetrack_mode);
1488: hr_utility.set_location('Hrate row updated',70);
1489: exception
1490: when others then
1491: hr_utility.set_location('error encountered',420);
1492: raise;

Line 1491: hr_utility.set_location('error encountered',420);

1487: p_datetrack_mode => p_datetrack_mode);
1488: hr_utility.set_location('Hrate row updated',70);
1489: exception
1490: when others then
1491: hr_utility.set_location('error encountered',420);
1492: raise;
1493: end stage_to_hr;
1494: function get_grd_spine(p_grade_id in number,
1495: p_scale_id in number,

Line 1506: hr_utility.set_location('grade_spine id is '||l_grade_spine_id,35);

1502: into l_grade_spine_id,l_parent_spine_id
1503: from per_grade_spines_f
1504: where grade_id = p_grade_id
1505: and p_effective_date between effective_start_date and effective_end_date;
1506: hr_utility.set_location('grade_spine id is '||l_grade_spine_id,35);
1507: exception
1508: when no_data_found then
1509: hr_utility.set_location('grade is not attached to any scale ',40);
1510: when others then

Line 1509: hr_utility.set_location('grade is not attached to any scale ',40);

1505: and p_effective_date between effective_start_date and effective_end_date;
1506: hr_utility.set_location('grade_spine id is '||l_grade_spine_id,35);
1507: exception
1508: when no_data_found then
1509: hr_utility.set_location('grade is not attached to any scale ',40);
1510: when others then
1511: hr_utility.set_location('issues in getting grade_spine ',50);
1512: raise;
1513: end;

Line 1511: hr_utility.set_location('issues in getting grade_spine ',50);

1507: exception
1508: when no_data_found then
1509: hr_utility.set_location('grade is not attached to any scale ',40);
1510: when others then
1511: hr_utility.set_location('issues in getting grade_spine ',50);
1512: raise;
1513: end;
1514: if l_grade_spine_id is null then
1515: -- grade spine doesnot exist, return null to create new

Line 1516: hr_utility.set_location('grade spine doesnot exist',50);

1512: raise;
1513: end;
1514: if l_grade_spine_id is null then
1515: -- grade spine doesnot exist, return null to create new
1516: hr_utility.set_location('grade spine doesnot exist',50);
1517: return l_grade_spine_id;
1518: else
1519: if l_parent_spine_id = p_scale_id then
1520: -- grade is linked to same scale in db use the same grade spine

Line 1521: hr_utility.set_location('grade is linked to same scale ',50);

1517: return l_grade_spine_id;
1518: else
1519: if l_parent_spine_id = p_scale_id then
1520: -- grade is linked to same scale in db use the same grade spine
1521: hr_utility.set_location('grade is linked to same scale ',50);
1522: return l_grade_spine_id;
1523: else
1524: -- grade is linked to different scale in db , we have to delete this grade spine
1525: -- and steps before create this one.

Line 1526: hr_utility.set_location('grade is linked to diff scale ',50);

1522: return l_grade_spine_id;
1523: else
1524: -- grade is linked to different scale in db , we have to delete this grade spine
1525: -- and steps before create this one.
1526: hr_utility.set_location('grade is linked to diff scale ',50);
1527: /* delete_steps(p_grade_spine_id => l_grade_spine_id,
1528: p_effective_date => p_effective_date);
1529: delete_grade_spine(p_grade_spine_id => l_grade_spine_id,
1530: p_effective_date => p_effective_date); */

Line 1561: hr_utility.set_location('inside '||l_proc,10);

1557: l_dt_mode varchar2(30);
1558: l_object varchar2(80);
1559:
1560: begin
1561: hr_utility.set_location('inside '||l_proc,10);
1562: for grd_spine in csr_gsps loop
1563: l_ceiling_step_id := grd_spine.information259;
1564: l_starting_step := grd_spine.information228;
1565: l_gs_ovn := grd_spine.information281;

Line 1575: hr_utility.set_location('scale was created but deleted',10);

1571: from ben_copy_entity_results
1572: where copy_entity_result_id = grd_spine.information258;
1573: exception
1574: when others then
1575: hr_utility.set_location('scale was created but deleted',10);
1576: end;
1577: else
1578: l_scale_id := grd_spine.information255;
1579: end if;

Line 1596: hr_utility.set_location('going for cr ',30);

1592: end if;
1593: if l_grade_spine_id is null
1594: and grd_spine.information253 is not null
1595: and grd_spine.information255 is not null then
1596: hr_utility.set_location('going for cr ',30);
1597: hr_utility.set_location('grade is '||grd_spine.information253,30);
1598: hr_utility.set_location('scale is '||grd_spine.information255,30);
1599: hr_utility.set_location('ceiling step is '||l_ceiling_step_id,30);
1600: -- HM: Start code for BugId: 3928277

Line 1597: hr_utility.set_location('grade is '||grd_spine.information253,30);

1593: if l_grade_spine_id is null
1594: and grd_spine.information253 is not null
1595: and grd_spine.information255 is not null then
1596: hr_utility.set_location('going for cr ',30);
1597: hr_utility.set_location('grade is '||grd_spine.information253,30);
1598: hr_utility.set_location('scale is '||grd_spine.information255,30);
1599: hr_utility.set_location('ceiling step is '||l_ceiling_step_id,30);
1600: -- HM: Start code for BugId: 3928277
1601: -- If the payscale linked to grade is changed create grade spine as of effective date

Line 1598: hr_utility.set_location('scale is '||grd_spine.information255,30);

1594: and grd_spine.information253 is not null
1595: and grd_spine.information255 is not null then
1596: hr_utility.set_location('going for cr ',30);
1597: hr_utility.set_location('grade is '||grd_spine.information253,30);
1598: hr_utility.set_location('scale is '||grd_spine.information255,30);
1599: hr_utility.set_location('ceiling step is '||l_ceiling_step_id,30);
1600: -- HM: Start code for BugId: 3928277
1601: -- If the payscale linked to grade is changed create grade spine as of effective date
1602: begin

Line 1599: hr_utility.set_location('ceiling step is '||l_ceiling_step_id,30);

1595: and grd_spine.information255 is not null then
1596: hr_utility.set_location('going for cr ',30);
1597: hr_utility.set_location('grade is '||grd_spine.information253,30);
1598: hr_utility.set_location('scale is '||grd_spine.information255,30);
1599: hr_utility.set_location('ceiling step is '||l_ceiling_step_id,30);
1600: -- HM: Start code for BugId: 3928277
1601: -- If the payscale linked to grade is changed create grade spine as of effective date
1602: begin
1603: select grade_id

Line 1611: hr_utility.set_location('new payscale attached ',30);

1607: and rownum < 2 ;
1608: l_grd_effstdt := p_effective_date;
1609: exception
1610: when no_data_found then
1611: hr_utility.set_location('new payscale attached ',30);
1612: l_grd_effstdt := null; -- ggnanagu 115.48
1613: end;
1614: -- End code for BugId: 3928277
1615:

Line 1643: hr_utility.set_location('grd_spine exists,ceiling step updated',10);

1639: ,p_object_version_number => l_gs_ovn
1640: ,p_starting_step => l_starting_step
1641: );
1642: elsif l_grade_spine_id is not null and grd_spine.information103 in ('Y','B','S') then
1643: hr_utility.set_location('grd_spine exists,ceiling step updated',10);
1644: begin
1645: hr_utility.set_location('going for upd',30);
1646: l_db_ovn := pqh_gsp_stage_to_ben.get_ovn
1647: (p_table_name => 'PER_GRADE_SPINES_F',

Line 1645: hr_utility.set_location('going for upd',30);

1641: );
1642: elsif l_grade_spine_id is not null and grd_spine.information103 in ('Y','B','S') then
1643: hr_utility.set_location('grd_spine exists,ceiling step updated',10);
1644: begin
1645: hr_utility.set_location('going for upd',30);
1646: l_db_ovn := pqh_gsp_stage_to_ben.get_ovn
1647: (p_table_name => 'PER_GRADE_SPINES_F',
1648: p_key_column_name => 'GRADE_SPINE_ID',
1649: p_key_column_value => l_grade_spine_id,

Line 1651: hr_utility.set_location(' l_db_ovn is '||l_db_ovn,30);

1647: (p_table_name => 'PER_GRADE_SPINES_F',
1648: p_key_column_name => 'GRADE_SPINE_ID',
1649: p_key_column_value => l_grade_spine_id,
1650: p_effective_date => p_effective_date);
1651: hr_utility.set_location(' l_db_ovn is '||l_db_ovn,30);
1652: hr_utility.set_location(' l_gs_ovn is '||l_gs_ovn,30);
1653: if l_db_ovn <> l_gs_ovn then
1654: l_object := hr_general.decode_lookup('PQH_GSP_OBJECT_TYPE','GSPINE');
1655: fnd_message.set_name('PQH','PQH_GSP_OBJ_OVN_INVALID');

Line 1652: hr_utility.set_location(' l_gs_ovn is '||l_gs_ovn,30);

1648: p_key_column_name => 'GRADE_SPINE_ID',
1649: p_key_column_value => l_grade_spine_id,
1650: p_effective_date => p_effective_date);
1651: hr_utility.set_location(' l_db_ovn is '||l_db_ovn,30);
1652: hr_utility.set_location(' l_gs_ovn is '||l_gs_ovn,30);
1653: if l_db_ovn <> l_gs_ovn then
1654: l_object := hr_general.decode_lookup('PQH_GSP_OBJECT_TYPE','GSPINE');
1655: fnd_message.set_name('PQH','PQH_GSP_OBJ_OVN_INVALID');
1656: fnd_message.set_token('OBJECT ',l_object);

Line 1669: hr_utility.set_location('l_dt_mode is'||l_dt_mode,30);

1665: p_effective_date => p_effective_date);
1666: else
1667: l_dt_mode := p_datetrack_mode;
1668: end if;
1669: hr_utility.set_location('l_dt_mode is'||l_dt_mode,30);
1670: hr_grade_scale_api.update_grade_scale
1671: (
1672: p_effective_date => p_effective_date --l_grd_effstdt
1673: ,p_datetrack_mode => l_dt_mode

Line 1687: hr_utility.set_location('issue in update grade scale'||l_ceiling_step_id,23);

1683: );
1684: end if ;
1685: exception
1686: when others then
1687: hr_utility.set_location('issue in update grade scale'||l_ceiling_step_id,23);
1688: hr_utility.set_location('for grd_sp '||l_grade_spine_id,23);
1689: raise;
1690: end;
1691:

Line 1688: hr_utility.set_location('for grd_sp '||l_grade_spine_id,23);

1684: end if ;
1685: exception
1686: when others then
1687: hr_utility.set_location('issue in update grade scale'||l_ceiling_step_id,23);
1688: hr_utility.set_location('for grd_sp '||l_grade_spine_id,23);
1689: raise;
1690: end;
1691:
1692: /* if(grd_spine.information103 in ('Y','B')) then

Line 1699: hr_utility.set_location('num of grd_sps updated'||sql%rowcount,20);

1695: update per_grade_spines_f
1696: set ceiling_step_id = l_ceiling_step_id
1697: where grade_spine_id = l_grade_spine_id
1698: and p_effective_date between effective_start_date and effective_end_date;
1699: hr_utility.set_location('num of grd_sps updated'||sql%rowcount,20);
1700: exception
1701: when others then
1702: hr_utility.set_location('issue in upd ceil step'||l_ceiling_step_id,23);
1703: hr_utility.set_location('for grd_sp '||l_grade_spine_id,23);

Line 1702: hr_utility.set_location('issue in upd ceil step'||l_ceiling_step_id,23);

1698: and p_effective_date between effective_start_date and effective_end_date;
1699: hr_utility.set_location('num of grd_sps updated'||sql%rowcount,20);
1700: exception
1701: when others then
1702: hr_utility.set_location('issue in upd ceil step'||l_ceiling_step_id,23);
1703: hr_utility.set_location('for grd_sp '||l_grade_spine_id,23);
1704: raise;
1705: end;
1706: end if;

Line 1703: hr_utility.set_location('for grd_sp '||l_grade_spine_id,23);

1699: hr_utility.set_location('num of grd_sps updated'||sql%rowcount,20);
1700: exception
1701: when others then
1702: hr_utility.set_location('issue in upd ceil step'||l_ceiling_step_id,23);
1703: hr_utility.set_location('for grd_sp '||l_grade_spine_id,23);
1704: raise;
1705: end;
1706: end if;
1707: end if;

Line 1709: hr_utility.set_location('grd_spine exists,starting step updated',10);

1705: end;
1706: end if;
1707: end if;
1708: if (grd_spine.information103 in ('S','B')) then
1709: hr_utility.set_location('grd_spine exists,starting step updated',10);
1710: if grd_spine.information228 is not null then
1711: begin
1712: update per_grade_spines_f
1713: set starting_step = l_starting_step

Line 1716: hr_utility.set_location('num of grd_sps updated'||sql%rowcount,20);

1712: update per_grade_spines_f
1713: set starting_step = l_starting_step
1714: where grade_spine_id = l_grade_spine_id
1715: and p_effective_date between effective_start_date and effective_end_date;
1716: hr_utility.set_location('num of grd_sps updated'||sql%rowcount,20);
1717: exception
1718: when others then
1719: hr_utility.set_location('issue in upd ceil step'||l_ceiling_step_id,23);
1720: hr_utility.set_location('for grd_sp '||l_grade_spine_id,23);

Line 1719: hr_utility.set_location('issue in upd ceil step'||l_ceiling_step_id,23);

1715: and p_effective_date between effective_start_date and effective_end_date;
1716: hr_utility.set_location('num of grd_sps updated'||sql%rowcount,20);
1717: exception
1718: when others then
1719: hr_utility.set_location('issue in upd ceil step'||l_ceiling_step_id,23);
1720: hr_utility.set_location('for grd_sp '||l_grade_spine_id,23);
1721: raise;
1722: end;
1723: end if;

Line 1720: hr_utility.set_location('for grd_sp '||l_grade_spine_id,23);

1716: hr_utility.set_location('num of grd_sps updated'||sql%rowcount,20);
1717: exception
1718: when others then
1719: hr_utility.set_location('issue in upd ceil step'||l_ceiling_step_id,23);
1720: hr_utility.set_location('for grd_sp '||l_grade_spine_id,23);
1721: raise;
1722: end;
1723: end if;
1724: end if;

Line 1727: hr_utility.set_location('grd_spine exists,no ceiling step changed',10);

1723: end if;
1724: end if;
1725: */
1726: elsif l_grade_spine_id is not null then
1727: hr_utility.set_location('grd_spine exists,no ceiling step changed',10);
1728: elsif l_grade_spine_id is null and l_scale_id is null and grd_spine.information258 is null then
1729: hr_utility.set_location('scale is not attached ',10);
1730: /* else
1731: l_message_text := 'grade spine is'||l_grade_spine_id

Line 1729: hr_utility.set_location('scale is not attached ',10);

1725: */
1726: elsif l_grade_spine_id is not null then
1727: hr_utility.set_location('grd_spine exists,no ceiling step changed',10);
1728: elsif l_grade_spine_id is null and l_scale_id is null and grd_spine.information258 is null then
1729: hr_utility.set_location('scale is not attached ',10);
1730: /* else
1731: l_message_text := 'grade spine is'||l_grade_spine_id
1732: ||' grade is'||l_grade_id
1733: ||' pl_cer_id is'||grd_spine.information252

Line 1749: hr_utility.set_location('gs writeback'||l_grade_spine_id,60);

1745: P_MESSAGE_TEXT => l_message_text,
1746: p_effective_date => p_effective_date); */
1747: end if;
1748: if l_grade_spine_id is not null then
1749: hr_utility.set_location('gs writeback'||l_grade_spine_id,60);
1750: grd_sp_writeback(p_plip_cer_id => grd_spine.copy_entity_result_id,
1751: p_grade_spine_id => l_grade_spine_id,
1752: p_copy_entity_txn_id => p_copy_entity_txn_id);
1753: hr_utility.set_location('grade spine done'||l_grade_spine_id,80);

Line 1753: hr_utility.set_location('grade spine done'||l_grade_spine_id,80);

1749: hr_utility.set_location('gs writeback'||l_grade_spine_id,60);
1750: grd_sp_writeback(p_plip_cer_id => grd_spine.copy_entity_result_id,
1751: p_grade_spine_id => l_grade_spine_id,
1752: p_copy_entity_txn_id => p_copy_entity_txn_id);
1753: hr_utility.set_location('grade spine done'||l_grade_spine_id,80);
1754: end if;
1755: end loop;
1756: hr_utility.set_location('out of gs loop'||l_proc,200);
1757: exception

Line 1756: hr_utility.set_location('out of gs loop'||l_proc,200);

1752: p_copy_entity_txn_id => p_copy_entity_txn_id);
1753: hr_utility.set_location('grade spine done'||l_grade_spine_id,80);
1754: end if;
1755: end loop;
1756: hr_utility.set_location('out of gs loop'||l_proc,200);
1757: exception
1758: when others then
1759: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS
1760: (P_MASTER_TXN_ID => p_copy_entity_txn_id,

Line 1788: hr_utility.set_location('inside '||l_proc,10);

1784: and table_alias = 'OPT'
1785: and dml_operation in ('INSERT','UPDATE','UPD_INS')
1786: order by information253 desc; -- do highest seq. first
1787: begin
1788: hr_utility.set_location('inside '||l_proc,10);
1789: for point_rec in csr_points loop
1790: l_point_id := point_rec.information257;
1791: l_point_ovn := point_rec.information254;
1792: if point_rec.information255 is null and point_rec.information256 is not null then

Line 1800: hr_utility.set_location('scale created but removed',10);

1796: from ben_copy_entity_results
1797: where copy_entity_result_id = point_rec.information256;
1798: exception
1799: when others then
1800: hr_utility.set_location('scale created but removed',10);
1801: end;
1802: elsif point_rec.information255 is not null then
1803: l_scale_id := point_rec.information255;
1804: end if;

Line 1808: hr_utility.set_location('going for ins',20);

1804: end if;
1805: if point_rec.dml_operation ='INSERT'
1806: and point_rec.information257 is null
1807: and l_scale_id is not null then
1808: hr_utility.set_location('going for ins',20);
1809: if p_business_area = 'PQH_CORPS_TASK_LIST' then
1810: pqh_cpd_hr_to_stage.create_point(p_point_id => l_point_id,
1811: p_point_ovn => l_point_ovn,
1812: p_information_category => point_rec.information101,

Line 1834: hr_utility.set_location('ins done '||l_point_id,22);

1830: ,p_spinal_point_id => l_point_id
1831: ,p_object_version_number => l_point_ovn
1832: );
1833: end if;
1834: hr_utility.set_location('ins done '||l_point_id,22);
1835: pt_writeback(p_copy_entity_txn_id => p_copy_entity_txn_id,
1836: p_point_id => l_point_id,
1837: p_point_cer_id => point_rec.copy_entity_result_id);
1838: hr_utility.set_location('wrt_back done '||l_point_id,25);

Line 1838: hr_utility.set_location('wrt_back done '||l_point_id,25);

1834: hr_utility.set_location('ins done '||l_point_id,22);
1835: pt_writeback(p_copy_entity_txn_id => p_copy_entity_txn_id,
1836: p_point_id => l_point_id,
1837: p_point_cer_id => point_rec.copy_entity_result_id);
1838: hr_utility.set_location('wrt_back done '||l_point_id,25);
1839: elsif point_rec.dml_operation in ('UPDATE','UPD_INS')
1840: and point_rec.information257 is not null
1841: and point_rec.information255 is not null then
1842: hr_utility.set_location('going for upd',30);

Line 1842: hr_utility.set_location('going for upd',30);

1838: hr_utility.set_location('wrt_back done '||l_point_id,25);
1839: elsif point_rec.dml_operation in ('UPDATE','UPD_INS')
1840: and point_rec.information257 is not null
1841: and point_rec.information255 is not null then
1842: hr_utility.set_location('going for upd',30);
1843: l_db_ovn := pqh_gsp_stage_to_ben.get_ovn
1844: (p_table_name => 'PER_SPINAL_POINTS',
1845: p_key_column_name => 'SPINAL_POINT_ID',
1846: p_key_column_value => l_point_id);

Line 1847: hr_utility.set_location(' ovn is '||l_db_ovn,30);

1843: l_db_ovn := pqh_gsp_stage_to_ben.get_ovn
1844: (p_table_name => 'PER_SPINAL_POINTS',
1845: p_key_column_name => 'SPINAL_POINT_ID',
1846: p_key_column_value => l_point_id);
1847: hr_utility.set_location(' ovn is '||l_db_ovn,30);
1848: if l_db_ovn <> l_point_ovn then
1849: l_object := hr_general.decode_lookup('PQH_GSP_OBJECT_TYPE','POINT');
1850: fnd_message.set_name('PQH','PQH_GSP_OBJ_OVN_INVALID');
1851: fnd_message.set_token('OBJECT ',l_object);

Line 1880: hr_utility.set_location('upd done ',32);

1876: ,p_spinal_point_id => l_point_id
1877: ,p_object_version_number => l_point_ovn
1878: );
1879: end if;
1880: hr_utility.set_location('upd done ',32);
1881: end if;
1882: else
1883: l_message_text := 'invalid dml_oper is '||point_rec.dml_operation
1884: ||' point id is '||l_point_id

Line 1900: hr_utility.set_location('leaving '||l_proc,100);

1896: P_MESSAGE_TEXT => l_message_text,
1897: p_effective_date => p_effective_date);
1898: end if;
1899: end loop;
1900: hr_utility.set_location('leaving '||l_proc,100);
1901: exception
1902: when others then
1903: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS
1904: (P_MASTER_TXN_ID => p_copy_entity_txn_id,

Line 1931: hr_utility.set_location('inside'||l_proc,10);

1927: where copy_entity_txn_id = p_copy_entity_txn_id
1928: and table_alias = 'PLN'
1929: and dml_operation in ('INSERT','UPDATE','UPD_INS');
1930: begin
1931: hr_utility.set_location('inside'||l_proc,10);
1932: for grd_rec in csr_grades loop
1933: l_ovn := grd_rec.information222;
1934: l_grade_id := grd_rec.information223;
1935: if grd_rec.dml_operation = 'INSERT'

Line 1939: hr_utility.set_location('new grade is being created'||l_proc,20);

1935: if grd_rec.dml_operation = 'INSERT'
1936: and l_grade_id is null
1937: and grd_rec.information221 is not null
1938: and grd_rec.information5 is not null then
1939: hr_utility.set_location('new grade is being created'||l_proc,20);
1940: if l_grd_seq is null then
1941: l_grd_seq := get_max_grd_seq(p_business_group_id => p_business_group_id);
1942: else
1943: l_grd_seq := l_grd_seq + 1;

Line 1946: hr_utility.set_location('grade name'||substr(grd_rec.information5,1,45),20);

1942: else
1943: l_grd_seq := l_grd_seq + 1;
1944: end if;
1945: begin
1946: hr_utility.set_location('grade name'||substr(grd_rec.information5,1,45),20);
1947: hr_utility.set_location('grade seq'||l_grd_seq,20);
1948: hr_utility.set_location('date from'||to_char(grd_rec.information307,'DD/MM/RRRR'),20);
1949: hr_utility.set_location('date to'||to_char(grd_rec.information308,'DD/MM/RRRR'),20);
1950: hr_grade_api.create_grade(p_business_group_id => p_business_group_id

Line 1947: hr_utility.set_location('grade seq'||l_grd_seq,20);

1943: l_grd_seq := l_grd_seq + 1;
1944: end if;
1945: begin
1946: hr_utility.set_location('grade name'||substr(grd_rec.information5,1,45),20);
1947: hr_utility.set_location('grade seq'||l_grd_seq,20);
1948: hr_utility.set_location('date from'||to_char(grd_rec.information307,'DD/MM/RRRR'),20);
1949: hr_utility.set_location('date to'||to_char(grd_rec.information308,'DD/MM/RRRR'),20);
1950: hr_grade_api.create_grade(p_business_group_id => p_business_group_id
1951: ,p_date_from => grd_rec.information307

Line 1948: hr_utility.set_location('date from'||to_char(grd_rec.information307,'DD/MM/RRRR'),20);

1944: end if;
1945: begin
1946: hr_utility.set_location('grade name'||substr(grd_rec.information5,1,45),20);
1947: hr_utility.set_location('grade seq'||l_grd_seq,20);
1948: hr_utility.set_location('date from'||to_char(grd_rec.information307,'DD/MM/RRRR'),20);
1949: hr_utility.set_location('date to'||to_char(grd_rec.information308,'DD/MM/RRRR'),20);
1950: hr_grade_api.create_grade(p_business_group_id => p_business_group_id
1951: ,p_date_from => grd_rec.information307
1952: ,p_sequence => l_grd_seq

Line 1949: hr_utility.set_location('date to'||to_char(grd_rec.information308,'DD/MM/RRRR'),20);

1945: begin
1946: hr_utility.set_location('grade name'||substr(grd_rec.information5,1,45),20);
1947: hr_utility.set_location('grade seq'||l_grd_seq,20);
1948: hr_utility.set_location('date from'||to_char(grd_rec.information307,'DD/MM/RRRR'),20);
1949: hr_utility.set_location('date to'||to_char(grd_rec.information308,'DD/MM/RRRR'),20);
1950: hr_grade_api.create_grade(p_business_group_id => p_business_group_id
1951: ,p_date_from => grd_rec.information307
1952: ,p_sequence => l_grd_seq
1953: ,p_effective_date => p_effective_date

Line 1960: hr_utility.set_location('grade id'||l_grade_id,20);

1956: ,p_grade_id => l_grade_id
1957: ,p_object_version_number => l_ovn
1958: ,p_grade_definition_id => grd_rec.information221
1959: ,p_name => grd_rec.information5);
1960: hr_utility.set_location('grade id'||l_grade_id,20);
1961: exception
1962: when others then
1963: hr_utility.set_location('issues in creating grade'||grd_rec.information5,30);
1964: raise;

Line 1963: hr_utility.set_location('issues in creating grade'||grd_rec.information5,30);

1959: ,p_name => grd_rec.information5);
1960: hr_utility.set_location('grade id'||l_grade_id,20);
1961: exception
1962: when others then
1963: hr_utility.set_location('issues in creating grade'||grd_rec.information5,30);
1964: raise;
1965: end;
1966: hr_utility.set_location('grade id is '||l_grade_id,30);
1967: hr_utility.set_location('grade cer id is '||grd_rec.copy_entity_result_id,30);

Line 1966: hr_utility.set_location('grade id is '||l_grade_id,30);

1962: when others then
1963: hr_utility.set_location('issues in creating grade'||grd_rec.information5,30);
1964: raise;
1965: end;
1966: hr_utility.set_location('grade id is '||l_grade_id,30);
1967: hr_utility.set_location('grade cer id is '||grd_rec.copy_entity_result_id,30);
1968: grd_writeback(p_copy_entity_txn_id => p_copy_entity_txn_id,
1969: p_grade_id => l_grade_id,
1970: p_grade_cer_id => grd_rec.copy_entity_result_id);

Line 1967: hr_utility.set_location('grade cer id is '||grd_rec.copy_entity_result_id,30);

1963: hr_utility.set_location('issues in creating grade'||grd_rec.information5,30);
1964: raise;
1965: end;
1966: hr_utility.set_location('grade id is '||l_grade_id,30);
1967: hr_utility.set_location('grade cer id is '||grd_rec.copy_entity_result_id,30);
1968: grd_writeback(p_copy_entity_txn_id => p_copy_entity_txn_id,
1969: p_grade_id => l_grade_id,
1970: p_grade_cer_id => grd_rec.copy_entity_result_id);
1971: hr_utility.set_location('grade writeback comp '||l_grade_id,40);

Line 1971: hr_utility.set_location('grade writeback comp '||l_grade_id,40);

1967: hr_utility.set_location('grade cer id is '||grd_rec.copy_entity_result_id,30);
1968: grd_writeback(p_copy_entity_txn_id => p_copy_entity_txn_id,
1969: p_grade_id => l_grade_id,
1970: p_grade_cer_id => grd_rec.copy_entity_result_id);
1971: hr_utility.set_location('grade writeback comp '||l_grade_id,40);
1972: elsif grd_rec.dml_operation in ('UPDATE','UPD_INS')
1973: and l_ovn is not null
1974: and grd_rec.information221 is not null
1975: and grd_rec.information5 is not null

Line 1977: hr_utility.set_location('grade is being updated'||l_grade_id,60);

1973: and l_ovn is not null
1974: and grd_rec.information221 is not null
1975: and grd_rec.information5 is not null
1976: and l_grade_id is not null then
1977: hr_utility.set_location('grade is being updated'||l_grade_id,60);
1978: hr_utility.set_location('grade ovn'||grd_rec.information222,60);
1979: l_concat_segments := get_grd_segment(p_grade_id => l_grade_id,
1980: p_grade_definition_id => grd_rec.information221);
1981: hr_utility.set_location('con seg is'||substr(l_concat_segments,1,55),61);

Line 1978: hr_utility.set_location('grade ovn'||grd_rec.information222,60);

1974: and grd_rec.information221 is not null
1975: and grd_rec.information5 is not null
1976: and l_grade_id is not null then
1977: hr_utility.set_location('grade is being updated'||l_grade_id,60);
1978: hr_utility.set_location('grade ovn'||grd_rec.information222,60);
1979: l_concat_segments := get_grd_segment(p_grade_id => l_grade_id,
1980: p_grade_definition_id => grd_rec.information221);
1981: hr_utility.set_location('con seg is'||substr(l_concat_segments,1,55),61);
1982: l_db_ovn := pqh_gsp_stage_to_ben.get_ovn

Line 1981: hr_utility.set_location('con seg is'||substr(l_concat_segments,1,55),61);

1977: hr_utility.set_location('grade is being updated'||l_grade_id,60);
1978: hr_utility.set_location('grade ovn'||grd_rec.information222,60);
1979: l_concat_segments := get_grd_segment(p_grade_id => l_grade_id,
1980: p_grade_definition_id => grd_rec.information221);
1981: hr_utility.set_location('con seg is'||substr(l_concat_segments,1,55),61);
1982: l_db_ovn := pqh_gsp_stage_to_ben.get_ovn
1983: (p_table_name => 'PER_GRADES',
1984: p_key_column_name => 'GRADE_ID',
1985: p_key_column_value => l_grade_id);

Line 1986: hr_utility.set_location(' ovn is '||l_db_ovn,30);

1982: l_db_ovn := pqh_gsp_stage_to_ben.get_ovn
1983: (p_table_name => 'PER_GRADES',
1984: p_key_column_name => 'GRADE_ID',
1985: p_key_column_value => l_grade_id);
1986: hr_utility.set_location(' ovn is '||l_db_ovn,30);
1987: if l_db_ovn <> l_ovn then
1988: l_object := hr_general.decode_lookup('PQH_GSP_OBJECT_TYPE','GRADE');
1989: fnd_message.set_name('PQH','PQH_GSP_OBJ_OVN_INVALID');
1990: fnd_message.set_token('OBJECT ',l_object);

Line 2006: hr_utility.set_location('issues in updating grade'||l_grade_id,70);

2002: ,p_grade_definition_id => grd_rec.information221
2003: ,p_name => grd_rec.information5);
2004: exception
2005: when others then
2006: hr_utility.set_location('issues in updating grade'||l_grade_id,70);
2007: hr_utility.set_location('grade ovn'||l_ovn,75);
2008: hr_utility.set_location('grade name'||substr(grd_rec.information5,1,45),78);
2009: raise;
2010: end;

Line 2007: hr_utility.set_location('grade ovn'||l_ovn,75);

2003: ,p_name => grd_rec.information5);
2004: exception
2005: when others then
2006: hr_utility.set_location('issues in updating grade'||l_grade_id,70);
2007: hr_utility.set_location('grade ovn'||l_ovn,75);
2008: hr_utility.set_location('grade name'||substr(grd_rec.information5,1,45),78);
2009: raise;
2010: end;
2011: end if;

Line 2008: hr_utility.set_location('grade name'||substr(grd_rec.information5,1,45),78);

2004: exception
2005: when others then
2006: hr_utility.set_location('issues in updating grade'||l_grade_id,70);
2007: hr_utility.set_location('grade ovn'||l_ovn,75);
2008: hr_utility.set_location('grade name'||substr(grd_rec.information5,1,45),78);
2009: raise;
2010: end;
2011: end if;
2012: else

Line 2028: hr_utility.set_location('leaving '||l_proc,100);

2024: P_MESSAGE_TEXT => l_message_text,
2025: p_effective_date => p_effective_date);
2026: end if;
2027: end loop;
2028: hr_utility.set_location('leaving '||l_proc,100);
2029: exception
2030: when others then
2031: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS
2032: (P_MASTER_TXN_ID => p_copy_entity_txn_id,

Line 2062: hr_utility.set_location('inside '||l_proc,10);

2058: where copy_entity_txn_id = p_copy_entity_txn_id
2059: and table_alias = 'COP'
2060: and dml_operation = 'INSERT';
2061: begin
2062: hr_utility.set_location('inside '||l_proc,10);
2063: for step_rec in csr_steps loop
2064: l_step_id := step_rec.information253;
2065: l_step_ovn := step_rec.information254;
2066: if step_rec.information255 is null then

Line 2087: hr_utility.set_location('going for ins',20);

2083: and step_rec.information253 is null
2084: and step_rec.information104 = 'LINK'
2085: and l_grd_sp_id is not null
2086: and l_point_id is not null then
2087: hr_utility.set_location('going for ins',20);
2088: hr_utility.set_location('sequence '||step_rec.information263,20);
2089: hr_utility.set_location('point id is '||l_point_id,20);
2090: hr_utility.set_location('grade spine'||l_grd_sp_id,20);
2091: --DN: Start code for BugId: 3242976

Line 2088: hr_utility.set_location('sequence '||step_rec.information263,20);

2084: and step_rec.information104 = 'LINK'
2085: and l_grd_sp_id is not null
2086: and l_point_id is not null then
2087: hr_utility.set_location('going for ins',20);
2088: hr_utility.set_location('sequence '||step_rec.information263,20);
2089: hr_utility.set_location('point id is '||l_point_id,20);
2090: hr_utility.set_location('grade spine'||l_grd_sp_id,20);
2091: --DN: Start code for BugId: 3242976
2092: -- Create step as of grade spine start date

Line 2089: hr_utility.set_location('point id is '||l_point_id,20);

2085: and l_grd_sp_id is not null
2086: and l_point_id is not null then
2087: hr_utility.set_location('going for ins',20);
2088: hr_utility.set_location('sequence '||step_rec.information263,20);
2089: hr_utility.set_location('point id is '||l_point_id,20);
2090: hr_utility.set_location('grade spine'||l_grd_sp_id,20);
2091: --DN: Start code for BugId: 3242976
2092: -- Create step as of grade spine start date
2093: begin

Line 2090: hr_utility.set_location('grade spine'||l_grd_sp_id,20);

2086: and l_point_id is not null then
2087: hr_utility.set_location('going for ins',20);
2088: hr_utility.set_location('sequence '||step_rec.information263,20);
2089: hr_utility.set_location('point id is '||l_point_id,20);
2090: hr_utility.set_location('grade spine'||l_grd_sp_id,20);
2091: --DN: Start code for BugId: 3242976
2092: -- Create step as of grade spine start date
2093: begin
2094: SELECT pgs.EFFECTIVE_START_DATE

Line 2116: hr_utility.set_location('ins done '||l_step_id,22);

2112: ,p_spinal_point_id => l_point_id
2113: ,p_step_id => l_step_id
2114: ,p_object_version_number => l_step_ovn
2115: );
2116: hr_utility.set_location('ins done '||l_step_id,22);
2117: step_writeback(p_copy_entity_txn_id => p_copy_entity_txn_id,
2118: p_step_id => l_step_id,
2119: p_step_cer_id => step_rec.copy_entity_result_id,
2120: p_effective_date => p_effective_date);

Line 2121: hr_utility.set_location('step_writeback done',22);

2117: step_writeback(p_copy_entity_txn_id => p_copy_entity_txn_id,
2118: p_step_id => l_step_id,
2119: p_step_cer_id => step_rec.copy_entity_result_id,
2120: p_effective_date => p_effective_date);
2121: hr_utility.set_location('step_writeback done',22);
2122: if nvl(step_rec.information98,'N') = 'Y' and l_step_id is not null then
2123: hr_utility.set_location('ceiling step, update grd_sp',23);
2124: begin
2125: update per_grade_spines_f

Line 2123: hr_utility.set_location('ceiling step, update grd_sp',23);

2119: p_step_cer_id => step_rec.copy_entity_result_id,
2120: p_effective_date => p_effective_date);
2121: hr_utility.set_location('step_writeback done',22);
2122: if nvl(step_rec.information98,'N') = 'Y' and l_step_id is not null then
2123: hr_utility.set_location('ceiling step, update grd_sp',23);
2124: begin
2125: update per_grade_spines_f
2126: set ceiling_step_id = l_step_id
2127: where grade_spine_id = l_grd_sp_id

Line 2129: hr_utility.set_location('num of grd_sps updated'||sql%rowcount,20);

2125: update per_grade_spines_f
2126: set ceiling_step_id = l_step_id
2127: where grade_spine_id = l_grd_sp_id
2128: and p_effective_date between effective_start_date and effective_end_date;
2129: hr_utility.set_location('num of grd_sps updated'||sql%rowcount,20);
2130: exception
2131: when others then
2132: hr_utility.set_location('issue in upd ceil step'||l_step_id,23);
2133: hr_utility.set_location('for grd_sp '||l_grd_sp_id,23);

Line 2132: hr_utility.set_location('issue in upd ceil step'||l_step_id,23);

2128: and p_effective_date between effective_start_date and effective_end_date;
2129: hr_utility.set_location('num of grd_sps updated'||sql%rowcount,20);
2130: exception
2131: when others then
2132: hr_utility.set_location('issue in upd ceil step'||l_step_id,23);
2133: hr_utility.set_location('for grd_sp '||l_grd_sp_id,23);
2134: raise;
2135: end;
2136: else

Line 2133: hr_utility.set_location('for grd_sp '||l_grd_sp_id,23);

2129: hr_utility.set_location('num of grd_sps updated'||sql%rowcount,20);
2130: exception
2131: when others then
2132: hr_utility.set_location('issue in upd ceil step'||l_step_id,23);
2133: hr_utility.set_location('for grd_sp '||l_grd_sp_id,23);
2134: raise;
2135: end;
2136: else
2137: hr_utility.set_location('not a ceiling step',24);

Line 2137: hr_utility.set_location('not a ceiling step',24);

2133: hr_utility.set_location('for grd_sp '||l_grd_sp_id,23);
2134: raise;
2135: end;
2136: else
2137: hr_utility.set_location('not a ceiling step',24);
2138: end if;
2139: else
2140: l_message_text := 'invalid operation '||step_rec.dml_operation
2141: ||' step id is '||step_rec.information253

Line 2155: hr_utility.set_location('leaving '||l_proc,100);

2151: P_MESSAGE_TEXT => l_message_text,
2152: p_effective_date => p_effective_date);
2153: end if;
2154: end loop;
2155: hr_utility.set_location('leaving '||l_proc,100);
2156: exception
2157: when others then
2158: hr_utility.set_location('issues with steps '||l_proc,420);
2159: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS

Line 2158: hr_utility.set_location('issues with steps '||l_proc,420);

2154: end loop;
2155: hr_utility.set_location('leaving '||l_proc,100);
2156: exception
2157: when others then
2158: hr_utility.set_location('issues with steps '||l_proc,420);
2159: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS
2160: (P_MASTER_TXN_ID => p_copy_entity_txn_id,
2161: P_TXN_ID => p_copy_entity_txn_id,
2162: P_MODULE_CD => 'PQH_GSP_STGBEN',

Line 2186: hr_utility.set_location('inside'||l_proc,10);

2182: where copy_entity_txn_id = p_copy_entity_txn_id
2183: and table_alias ='SCALE'
2184: and dml_operation in ('INSERT','UPDATE');
2185: begin
2186: hr_utility.set_location('inside'||l_proc,10);
2187: for scl_rec in csr_scales loop
2188: l_scale_ovn := scl_rec.information254;
2189: l_scale_id := scl_rec.information1;
2190: if scl_rec.dml_operation = 'INSERT'

Line 2193: hr_utility.set_location('new scale is being created'||l_proc,20);

2189: l_scale_id := scl_rec.information1;
2190: if scl_rec.dml_operation = 'INSERT'
2191: and l_scale_id is null
2192: and scl_rec.information98 is not null then
2193: hr_utility.set_location('new scale is being created'||l_proc,20);
2194: hr_utility.set_location('incr_fre'||scl_rec.information253,20);
2195: hr_utility.set_location('incr_per'||scl_rec.information99,20);
2196: hr_utility.set_location('scale_id'||l_scale_id,20);
2197: hr_utility.set_location('scl_ovn'||l_scale_ovn,20);

Line 2194: hr_utility.set_location('incr_fre'||scl_rec.information253,20);

2190: if scl_rec.dml_operation = 'INSERT'
2191: and l_scale_id is null
2192: and scl_rec.information98 is not null then
2193: hr_utility.set_location('new scale is being created'||l_proc,20);
2194: hr_utility.set_location('incr_fre'||scl_rec.information253,20);
2195: hr_utility.set_location('incr_per'||scl_rec.information99,20);
2196: hr_utility.set_location('scale_id'||l_scale_id,20);
2197: hr_utility.set_location('scl_ovn'||l_scale_ovn,20);
2198: hr_utility.set_location('bus_area is'||p_business_area,20);

Line 2195: hr_utility.set_location('incr_per'||scl_rec.information99,20);

2191: and l_scale_id is null
2192: and scl_rec.information98 is not null then
2193: hr_utility.set_location('new scale is being created'||l_proc,20);
2194: hr_utility.set_location('incr_fre'||scl_rec.information253,20);
2195: hr_utility.set_location('incr_per'||scl_rec.information99,20);
2196: hr_utility.set_location('scale_id'||l_scale_id,20);
2197: hr_utility.set_location('scl_ovn'||l_scale_ovn,20);
2198: hr_utility.set_location('bus_area is'||p_business_area,20);
2199: if p_business_area = 'PQH_CORPS_TASK_LIST' then

Line 2196: hr_utility.set_location('scale_id'||l_scale_id,20);

2192: and scl_rec.information98 is not null then
2193: hr_utility.set_location('new scale is being created'||l_proc,20);
2194: hr_utility.set_location('incr_fre'||scl_rec.information253,20);
2195: hr_utility.set_location('incr_per'||scl_rec.information99,20);
2196: hr_utility.set_location('scale_id'||l_scale_id,20);
2197: hr_utility.set_location('scl_ovn'||l_scale_ovn,20);
2198: hr_utility.set_location('bus_area is'||p_business_area,20);
2199: if p_business_area = 'PQH_CORPS_TASK_LIST' then
2200: pqh_cpd_hr_to_stage.create_scale(p_scale_id => l_scale_id,

Line 2197: hr_utility.set_location('scl_ovn'||l_scale_ovn,20);

2193: hr_utility.set_location('new scale is being created'||l_proc,20);
2194: hr_utility.set_location('incr_fre'||scl_rec.information253,20);
2195: hr_utility.set_location('incr_per'||scl_rec.information99,20);
2196: hr_utility.set_location('scale_id'||l_scale_id,20);
2197: hr_utility.set_location('scl_ovn'||l_scale_ovn,20);
2198: hr_utility.set_location('bus_area is'||p_business_area,20);
2199: if p_business_area = 'PQH_CORPS_TASK_LIST' then
2200: pqh_cpd_hr_to_stage.create_scale(p_scale_id => l_scale_id,
2201: p_scale_ovn => l_scale_ovn,

Line 2198: hr_utility.set_location('bus_area is'||p_business_area,20);

2194: hr_utility.set_location('incr_fre'||scl_rec.information253,20);
2195: hr_utility.set_location('incr_per'||scl_rec.information99,20);
2196: hr_utility.set_location('scale_id'||l_scale_id,20);
2197: hr_utility.set_location('scl_ovn'||l_scale_ovn,20);
2198: hr_utility.set_location('bus_area is'||p_business_area,20);
2199: if p_business_area = 'PQH_CORPS_TASK_LIST' then
2200: pqh_cpd_hr_to_stage.create_scale(p_scale_id => l_scale_id,
2201: p_scale_ovn => l_scale_ovn,
2202: p_information_category => scl_rec.information101,

Line 2223: hr_utility.set_location('issues in creating scale'||scl_rec.information98,30);

2219: ,p_object_version_number => l_scale_ovn
2220: ) ;
2221: exception
2222: when others then
2223: hr_utility.set_location('issues in creating scale'||scl_rec.information98,30);
2224: raise;
2225: end;
2226: end if;
2227: hr_utility.set_location('scale id is '||l_scale_id,30);

Line 2227: hr_utility.set_location('scale id is '||l_scale_id,30);

2223: hr_utility.set_location('issues in creating scale'||scl_rec.information98,30);
2224: raise;
2225: end;
2226: end if;
2227: hr_utility.set_location('scale id is '||l_scale_id,30);
2228: scl_writeback(p_copy_entity_txn_id => p_copy_entity_txn_id,
2229: p_scale_id => l_scale_id,
2230: p_scale_cer_id => scl_rec.copy_entity_result_id);
2231: hr_utility.set_location('scale writeback comp'||l_scale_id,40);

Line 2231: hr_utility.set_location('scale writeback comp'||l_scale_id,40);

2227: hr_utility.set_location('scale id is '||l_scale_id,30);
2228: scl_writeback(p_copy_entity_txn_id => p_copy_entity_txn_id,
2229: p_scale_id => l_scale_id,
2230: p_scale_cer_id => scl_rec.copy_entity_result_id);
2231: hr_utility.set_location('scale writeback comp'||l_scale_id,40);
2232: elsif scl_rec.dml_operation ='UPDATE' and l_scale_id is not null
2233: and scl_rec.information98 is not null and l_scale_ovn is not null then
2234: hr_utility.set_location('scale is being updated'||l_proc,60);
2235: l_db_ovn := pqh_gsp_stage_to_ben.get_ovn

Line 2234: hr_utility.set_location('scale is being updated'||l_proc,60);

2230: p_scale_cer_id => scl_rec.copy_entity_result_id);
2231: hr_utility.set_location('scale writeback comp'||l_scale_id,40);
2232: elsif scl_rec.dml_operation ='UPDATE' and l_scale_id is not null
2233: and scl_rec.information98 is not null and l_scale_ovn is not null then
2234: hr_utility.set_location('scale is being updated'||l_proc,60);
2235: l_db_ovn := pqh_gsp_stage_to_ben.get_ovn
2236: (p_table_name => 'PER_PARENT_SPINES',
2237: p_key_column_name => 'PARENT_SPINE_ID',
2238: p_key_column_value => l_scale_id);

Line 2239: hr_utility.set_location(' ovn is '||l_db_ovn,30);

2235: l_db_ovn := pqh_gsp_stage_to_ben.get_ovn
2236: (p_table_name => 'PER_PARENT_SPINES',
2237: p_key_column_name => 'PARENT_SPINE_ID',
2238: p_key_column_value => l_scale_id);
2239: hr_utility.set_location(' ovn is '||l_db_ovn,30);
2240: if l_db_ovn <> l_scale_ovn then
2241: l_object := hr_general.decode_lookup('PQH_GSP_OBJECT_TYPE','SCALE');
2242: fnd_message.set_name('PQH','PQH_GSP_OBJ_OVN_INVALID');
2243: fnd_message.set_token('OBJECT ',l_object);

Line 2269: hr_utility.set_location('issues in updating scale'||l_scale_id,70);

2265: ,p_object_version_number => l_scale_ovn
2266: ) ;
2267: exception
2268: when others then
2269: hr_utility.set_location('issues in updating scale'||l_scale_id,70);
2270: hr_utility.set_location('scale ovn'||l_scale_ovn,75);
2271: hr_utility.set_location('scale name'||substr(scl_rec.information98,1,45),78);
2272: raise;
2273: end;

Line 2270: hr_utility.set_location('scale ovn'||l_scale_ovn,75);

2266: ) ;
2267: exception
2268: when others then
2269: hr_utility.set_location('issues in updating scale'||l_scale_id,70);
2270: hr_utility.set_location('scale ovn'||l_scale_ovn,75);
2271: hr_utility.set_location('scale name'||substr(scl_rec.information98,1,45),78);
2272: raise;
2273: end;
2274: end if;

Line 2271: hr_utility.set_location('scale name'||substr(scl_rec.information98,1,45),78);

2267: exception
2268: when others then
2269: hr_utility.set_location('issues in updating scale'||l_scale_id,70);
2270: hr_utility.set_location('scale ovn'||l_scale_ovn,75);
2271: hr_utility.set_location('scale name'||substr(scl_rec.information98,1,45),78);
2272: raise;
2273: end;
2274: end if;
2275: end if;

Line 2291: hr_utility.set_location('leaving '||l_proc,420);

2287: P_MESSAGE_TEXT => l_message_text,
2288: p_effective_date => p_effective_date);
2289: end if;
2290: end loop;
2291: hr_utility.set_location('leaving '||l_proc,420);
2292: exception
2293: when others then
2294: hr_utility.set_location('issue in scale writing'||l_proc,520);
2295: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS

Line 2294: hr_utility.set_location('issue in scale writing'||l_proc,520);

2290: end loop;
2291: hr_utility.set_location('leaving '||l_proc,420);
2292: exception
2293: when others then
2294: hr_utility.set_location('issue in scale writing'||l_proc,520);
2295: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS
2296: (P_MASTER_TXN_ID => p_copy_entity_txn_id,
2297: P_TXN_ID => p_copy_entity_txn_id,
2298: P_MODULE_CD => 'PQH_GSP_STGBEN',

Line 2336: hr_utility.set_location('inside hr rate ',10);

2332: and table_alias = 'HRRATE'
2333: and dml_operation in ('INSERT','UPDATE')
2334: order by INFORMATION277,INFORMATION278,INFORMATION2;
2335: begin
2336: hr_utility.set_location('inside hr rate ',10);
2337: for hrr_rec in csr_hrr loop
2338: hr_utility.set_location('hrrate cer is'||hrr_rec.information1,15);
2339: if hrr_rec.information1 is null then
2340: if (hrr_rec.information277 is null or hrr_rec.information277 = l_old_grd_cer_id)

Line 2338: hr_utility.set_location('hrrate cer is'||hrr_rec.information1,15);

2334: order by INFORMATION277,INFORMATION278,INFORMATION2;
2335: begin
2336: hr_utility.set_location('inside hr rate ',10);
2337: for hrr_rec in csr_hrr loop
2338: hr_utility.set_location('hrrate cer is'||hrr_rec.information1,15);
2339: if hrr_rec.information1 is null then
2340: if (hrr_rec.information277 is null or hrr_rec.information277 = l_old_grd_cer_id)
2341: and (hrr_rec.information278 is null or hrr_rec.information278 = l_old_pnt_cer_id) then
2342: hr_utility.set_location('reusing prev row pk and ovn',16);

Line 2342: hr_utility.set_location('reusing prev row pk and ovn',16);

2338: hr_utility.set_location('hrrate cer is'||hrr_rec.information1,15);
2339: if hrr_rec.information1 is null then
2340: if (hrr_rec.information277 is null or hrr_rec.information277 = l_old_grd_cer_id)
2341: and (hrr_rec.information278 is null or hrr_rec.information278 = l_old_pnt_cer_id) then
2342: hr_utility.set_location('reusing prev row pk and ovn',16);
2343: hr_utility.set_location('grd cer is'||hrr_rec.information277,16);
2344: hr_utility.set_location('pnt cer is'||hrr_rec.information278,16);
2345: hr_utility.set_location('old grd cer is'||l_old_grd_cer_id,16);
2346: hr_utility.set_location('old pnt cer is'||l_old_pnt_cer_id,16);

Line 2343: hr_utility.set_location('grd cer is'||hrr_rec.information277,16);

2339: if hrr_rec.information1 is null then
2340: if (hrr_rec.information277 is null or hrr_rec.information277 = l_old_grd_cer_id)
2341: and (hrr_rec.information278 is null or hrr_rec.information278 = l_old_pnt_cer_id) then
2342: hr_utility.set_location('reusing prev row pk and ovn',16);
2343: hr_utility.set_location('grd cer is'||hrr_rec.information277,16);
2344: hr_utility.set_location('pnt cer is'||hrr_rec.information278,16);
2345: hr_utility.set_location('old grd cer is'||l_old_grd_cer_id,16);
2346: hr_utility.set_location('old pnt cer is'||l_old_pnt_cer_id,16);
2347: l_hrrate_id := l_old_hrr_id; -- previous row created id can be used

Line 2344: hr_utility.set_location('pnt cer is'||hrr_rec.information278,16);

2340: if (hrr_rec.information277 is null or hrr_rec.information277 = l_old_grd_cer_id)
2341: and (hrr_rec.information278 is null or hrr_rec.information278 = l_old_pnt_cer_id) then
2342: hr_utility.set_location('reusing prev row pk and ovn',16);
2343: hr_utility.set_location('grd cer is'||hrr_rec.information277,16);
2344: hr_utility.set_location('pnt cer is'||hrr_rec.information278,16);
2345: hr_utility.set_location('old grd cer is'||l_old_grd_cer_id,16);
2346: hr_utility.set_location('old pnt cer is'||l_old_pnt_cer_id,16);
2347: l_hrrate_id := l_old_hrr_id; -- previous row created id can be used
2348: l_hrr_ovn := l_old_hrr_ovn;

Line 2345: hr_utility.set_location('old grd cer is'||l_old_grd_cer_id,16);

2341: and (hrr_rec.information278 is null or hrr_rec.information278 = l_old_pnt_cer_id) then
2342: hr_utility.set_location('reusing prev row pk and ovn',16);
2343: hr_utility.set_location('grd cer is'||hrr_rec.information277,16);
2344: hr_utility.set_location('pnt cer is'||hrr_rec.information278,16);
2345: hr_utility.set_location('old grd cer is'||l_old_grd_cer_id,16);
2346: hr_utility.set_location('old pnt cer is'||l_old_pnt_cer_id,16);
2347: l_hrrate_id := l_old_hrr_id; -- previous row created id can be used
2348: l_hrr_ovn := l_old_hrr_ovn;
2349: else

Line 2346: hr_utility.set_location('old pnt cer is'||l_old_pnt_cer_id,16);

2342: hr_utility.set_location('reusing prev row pk and ovn',16);
2343: hr_utility.set_location('grd cer is'||hrr_rec.information277,16);
2344: hr_utility.set_location('pnt cer is'||hrr_rec.information278,16);
2345: hr_utility.set_location('old grd cer is'||l_old_grd_cer_id,16);
2346: hr_utility.set_location('old pnt cer is'||l_old_pnt_cer_id,16);
2347: l_hrrate_id := l_old_hrr_id; -- previous row created id can be used
2348: l_hrr_ovn := l_old_hrr_ovn;
2349: else
2350: l_hrrate_id := hrr_rec.information1;

Line 2358: hr_utility.set_location('hrr effdt is'||to_char(l_effective_date,'DD/MM/RRRR'),15);

2354: l_hrrate_id := hrr_rec.information1;
2355: l_hrr_ovn := hrr_rec.information298;
2356: end if;
2357: l_effective_date := hrr_rec.information2;
2358: hr_utility.set_location('hrr effdt is'||to_char(l_effective_date,'DD/MM/RRRR'),15);
2359: l_payrate_id := hrr_rec.information293;
2360: if hrr_rec.dml_operation = 'INSERT'
2361: and nvl(hrr_rec.datetrack_mode,'CORRECTION') <> 'UPDATE_REPLACE' then
2362: l_dml_operation := 'INSERT';

Line 2370: hr_utility.set_location('opt cer id is '||hrr_rec.INFORMATION278,3);

2366: l_dml_operation := 'UPDATE';
2367: else
2368: l_dml_operation := '';
2369: end if;
2370: hr_utility.set_location('opt cer id is '||hrr_rec.INFORMATION278,3);
2371: hr_utility.set_location('pl cer id is '||hrr_rec.INFORMATION277,3);
2372: if hrr_rec.INFORMATION277 is not null and hrr_rec.INFORMATION255 is null then
2373: hr_utility.set_location('going for getting pl_id ',3);
2374: begin

Line 2371: hr_utility.set_location('pl cer id is '||hrr_rec.INFORMATION277,3);

2367: else
2368: l_dml_operation := '';
2369: end if;
2370: hr_utility.set_location('opt cer id is '||hrr_rec.INFORMATION278,3);
2371: hr_utility.set_location('pl cer id is '||hrr_rec.INFORMATION277,3);
2372: if hrr_rec.INFORMATION277 is not null and hrr_rec.INFORMATION255 is null then
2373: hr_utility.set_location('going for getting pl_id ',3);
2374: begin
2375: select information223

Line 2373: hr_utility.set_location('going for getting pl_id ',3);

2369: end if;
2370: hr_utility.set_location('opt cer id is '||hrr_rec.INFORMATION278,3);
2371: hr_utility.set_location('pl cer id is '||hrr_rec.INFORMATION277,3);
2372: if hrr_rec.INFORMATION277 is not null and hrr_rec.INFORMATION255 is null then
2373: hr_utility.set_location('going for getting pl_id ',3);
2374: begin
2375: select information223
2376: into l_grd_sp_id
2377: from ben_copy_entity_results

Line 2391: hr_utility.set_location('going for getting opt_id ',3);

2387: elsif hrr_rec.INFORMATION276 is not null then
2388: l_grd_sp_id := hrr_rec.INFORMATION276;
2389: l_rate_type := 'SP';
2390: elsif hrr_rec.INFORMATION278 is not null and hrr_rec.INFORMATION276 is null then
2391: hr_utility.set_location('going for getting opt_id ',3);
2392: begin
2393: select information257
2394: into l_grd_sp_id
2395: from ben_copy_entity_results

Line 2404: hr_utility.set_location('pl id is '||hrr_rec.INFORMATION255,3);

2400: end;
2401: l_rate_type := 'SP';
2402: else
2403: l_grd_sp_id := null;
2404: hr_utility.set_location('pl id is '||hrr_rec.INFORMATION255,3);
2405: hr_utility.set_location('pl cer id is '||hrr_rec.INFORMATION277,3);
2406: hr_utility.set_location('opt id is '||hrr_rec.INFORMATION276,3);
2407: hr_utility.set_location('opt cer id is '||hrr_rec.INFORMATION278,3);
2408: end if;

Line 2405: hr_utility.set_location('pl cer id is '||hrr_rec.INFORMATION277,3);

2401: l_rate_type := 'SP';
2402: else
2403: l_grd_sp_id := null;
2404: hr_utility.set_location('pl id is '||hrr_rec.INFORMATION255,3);
2405: hr_utility.set_location('pl cer id is '||hrr_rec.INFORMATION277,3);
2406: hr_utility.set_location('opt id is '||hrr_rec.INFORMATION276,3);
2407: hr_utility.set_location('opt cer id is '||hrr_rec.INFORMATION278,3);
2408: end if;
2409: hr_utility.set_location('grade or point id '||l_grd_sp_id,20);

Line 2406: hr_utility.set_location('opt id is '||hrr_rec.INFORMATION276,3);

2402: else
2403: l_grd_sp_id := null;
2404: hr_utility.set_location('pl id is '||hrr_rec.INFORMATION255,3);
2405: hr_utility.set_location('pl cer id is '||hrr_rec.INFORMATION277,3);
2406: hr_utility.set_location('opt id is '||hrr_rec.INFORMATION276,3);
2407: hr_utility.set_location('opt cer id is '||hrr_rec.INFORMATION278,3);
2408: end if;
2409: hr_utility.set_location('grade or point id '||l_grd_sp_id,20);
2410: if l_dml_operation = 'INSERT'

Line 2407: hr_utility.set_location('opt cer id is '||hrr_rec.INFORMATION278,3);

2403: l_grd_sp_id := null;
2404: hr_utility.set_location('pl id is '||hrr_rec.INFORMATION255,3);
2405: hr_utility.set_location('pl cer id is '||hrr_rec.INFORMATION277,3);
2406: hr_utility.set_location('opt id is '||hrr_rec.INFORMATION276,3);
2407: hr_utility.set_location('opt cer id is '||hrr_rec.INFORMATION278,3);
2408: end if;
2409: hr_utility.set_location('grade or point id '||l_grd_sp_id,20);
2410: if l_dml_operation = 'INSERT'
2411: and l_hrrate_id is null

Line 2409: hr_utility.set_location('grade or point id '||l_grd_sp_id,20);

2405: hr_utility.set_location('pl cer id is '||hrr_rec.INFORMATION277,3);
2406: hr_utility.set_location('opt id is '||hrr_rec.INFORMATION276,3);
2407: hr_utility.set_location('opt cer id is '||hrr_rec.INFORMATION278,3);
2408: end if;
2409: hr_utility.set_location('grade or point id '||l_grd_sp_id,20);
2410: if l_dml_operation = 'INSERT'
2411: and l_hrrate_id is null
2412: and l_grd_sp_id is not null
2413: and l_payrate_id is not null then

Line 2414: hr_utility.set_location('new hrrate is being created'||l_proc,20);

2410: if l_dml_operation = 'INSERT'
2411: and l_hrrate_id is null
2412: and l_grd_sp_id is not null
2413: and l_payrate_id is not null then
2414: hr_utility.set_location('new hrrate is being created'||l_proc,20);
2415: hr_utility.set_location('grade or point id '||l_grd_sp_id,20);
2416: hr_utility.set_location('value'||hrr_rec.information297,20);
2417: hr_utility.set_location('pay rate id'||l_payrate_id,20);
2418: hr_utility.set_location('hrr_ovn'||l_hrr_ovn,20);

Line 2415: hr_utility.set_location('grade or point id '||l_grd_sp_id,20);

2411: and l_hrrate_id is null
2412: and l_grd_sp_id is not null
2413: and l_payrate_id is not null then
2414: hr_utility.set_location('new hrrate is being created'||l_proc,20);
2415: hr_utility.set_location('grade or point id '||l_grd_sp_id,20);
2416: hr_utility.set_location('value'||hrr_rec.information297,20);
2417: hr_utility.set_location('pay rate id'||l_payrate_id,20);
2418: hr_utility.set_location('hrr_ovn'||l_hrr_ovn,20);
2419: begin

Line 2416: hr_utility.set_location('value'||hrr_rec.information297,20);

2412: and l_grd_sp_id is not null
2413: and l_payrate_id is not null then
2414: hr_utility.set_location('new hrrate is being created'||l_proc,20);
2415: hr_utility.set_location('grade or point id '||l_grd_sp_id,20);
2416: hr_utility.set_location('value'||hrr_rec.information297,20);
2417: hr_utility.set_location('pay rate id'||l_payrate_id,20);
2418: hr_utility.set_location('hrr_ovn'||l_hrr_ovn,20);
2419: begin
2420: hr_rate_values_api.create_rate_value

Line 2417: hr_utility.set_location('pay rate id'||l_payrate_id,20);

2413: and l_payrate_id is not null then
2414: hr_utility.set_location('new hrrate is being created'||l_proc,20);
2415: hr_utility.set_location('grade or point id '||l_grd_sp_id,20);
2416: hr_utility.set_location('value'||hrr_rec.information297,20);
2417: hr_utility.set_location('pay rate id'||l_payrate_id,20);
2418: hr_utility.set_location('hrr_ovn'||l_hrr_ovn,20);
2419: begin
2420: hr_rate_values_api.create_rate_value
2421: (p_effective_date => l_effective_date

Line 2418: hr_utility.set_location('hrr_ovn'||l_hrr_ovn,20);

2414: hr_utility.set_location('new hrrate is being created'||l_proc,20);
2415: hr_utility.set_location('grade or point id '||l_grd_sp_id,20);
2416: hr_utility.set_location('value'||hrr_rec.information297,20);
2417: hr_utility.set_location('pay rate id'||l_payrate_id,20);
2418: hr_utility.set_location('hrr_ovn'||l_hrr_ovn,20);
2419: begin
2420: hr_rate_values_api.create_rate_value
2421: (p_effective_date => l_effective_date
2422: ,p_business_group_id => p_business_group_id

Line 2437: hr_utility.set_location('grade or point id '||l_grd_sp_id,20);

2433: ,p_effective_start_date => l_hrr_esd
2434: ,p_effective_end_date => l_hrr_eed);
2435: exception
2436: when others then
2437: hr_utility.set_location('grade or point id '||l_grd_sp_id,20);
2438: raise;
2439: end;
2440: hr_utility.set_location('hrrate id is '||l_hrrate_id,30);
2441: hrr_writeback(p_grade_cer_id => hrr_rec.information277,

Line 2440: hr_utility.set_location('hrrate id is '||l_hrrate_id,30);

2436: when others then
2437: hr_utility.set_location('grade or point id '||l_grd_sp_id,20);
2438: raise;
2439: end;
2440: hr_utility.set_location('hrrate id is '||l_hrrate_id,30);
2441: hrr_writeback(p_grade_cer_id => hrr_rec.information277,
2442: p_point_cer_id => hrr_rec.information278,
2443: p_copy_entity_txn_id => p_copy_entity_txn_id,
2444: p_hrrate_id => l_hrrate_id);

Line 2445: hr_utility.set_location('hrrate wrtback comp '||l_hrrate_id,30);

2441: hrr_writeback(p_grade_cer_id => hrr_rec.information277,
2442: p_point_cer_id => hrr_rec.information278,
2443: p_copy_entity_txn_id => p_copy_entity_txn_id,
2444: p_hrrate_id => l_hrrate_id);
2445: hr_utility.set_location('hrrate wrtback comp '||l_hrrate_id,30);
2446: elsif l_dml_operation ='UPDATE'
2447: and l_hrrate_id is not null
2448: and l_grd_sp_id is not null
2449: and l_hrr_ovn is not null

Line 2451: hr_utility.set_location('hrrate is being updated'||l_proc,60);

2447: and l_hrrate_id is not null
2448: and l_grd_sp_id is not null
2449: and l_hrr_ovn is not null
2450: and l_payrate_id is not null then
2451: hr_utility.set_location('hrrate is being updated'||l_proc,60);
2452: hr_utility.set_location('grade or point id '||l_grd_sp_id,20);
2453: hr_utility.set_location('value'||hrr_rec.information297,20);
2454: hr_utility.set_location('pay rate id'||l_payrate_id,20);
2455: hr_utility.set_location('hrr_ovn'||l_hrr_ovn,20);

Line 2452: hr_utility.set_location('grade or point id '||l_grd_sp_id,20);

2448: and l_grd_sp_id is not null
2449: and l_hrr_ovn is not null
2450: and l_payrate_id is not null then
2451: hr_utility.set_location('hrrate is being updated'||l_proc,60);
2452: hr_utility.set_location('grade or point id '||l_grd_sp_id,20);
2453: hr_utility.set_location('value'||hrr_rec.information297,20);
2454: hr_utility.set_location('pay rate id'||l_payrate_id,20);
2455: hr_utility.set_location('hrr_ovn'||l_hrr_ovn,20);
2456: if hrr_rec.datetrack_mode <> 'CORRECTION' then

Line 2453: hr_utility.set_location('value'||hrr_rec.information297,20);

2449: and l_hrr_ovn is not null
2450: and l_payrate_id is not null then
2451: hr_utility.set_location('hrrate is being updated'||l_proc,60);
2452: hr_utility.set_location('grade or point id '||l_grd_sp_id,20);
2453: hr_utility.set_location('value'||hrr_rec.information297,20);
2454: hr_utility.set_location('pay rate id'||l_payrate_id,20);
2455: hr_utility.set_location('hrr_ovn'||l_hrr_ovn,20);
2456: if hrr_rec.datetrack_mode <> 'CORRECTION' then
2457: l_dt_mode := pqh_gsp_stage_to_ben.get_update_mode

Line 2454: hr_utility.set_location('pay rate id'||l_payrate_id,20);

2450: and l_payrate_id is not null then
2451: hr_utility.set_location('hrrate is being updated'||l_proc,60);
2452: hr_utility.set_location('grade or point id '||l_grd_sp_id,20);
2453: hr_utility.set_location('value'||hrr_rec.information297,20);
2454: hr_utility.set_location('pay rate id'||l_payrate_id,20);
2455: hr_utility.set_location('hrr_ovn'||l_hrr_ovn,20);
2456: if hrr_rec.datetrack_mode <> 'CORRECTION' then
2457: l_dt_mode := pqh_gsp_stage_to_ben.get_update_mode
2458: (p_table_name => 'PAY_GRADE_RULES_F',

Line 2455: hr_utility.set_location('hrr_ovn'||l_hrr_ovn,20);

2451: hr_utility.set_location('hrrate is being updated'||l_proc,60);
2452: hr_utility.set_location('grade or point id '||l_grd_sp_id,20);
2453: hr_utility.set_location('value'||hrr_rec.information297,20);
2454: hr_utility.set_location('pay rate id'||l_payrate_id,20);
2455: hr_utility.set_location('hrr_ovn'||l_hrr_ovn,20);
2456: if hrr_rec.datetrack_mode <> 'CORRECTION' then
2457: l_dt_mode := pqh_gsp_stage_to_ben.get_update_mode
2458: (p_table_name => 'PAY_GRADE_RULES_F',
2459: p_key_column_name => 'GRADE_RULE_ID',

Line 2465: hr_utility.set_location(' dt mode is '||l_dt_mode,30);

2461: p_effective_date => l_effective_date);
2462: else
2463: l_dt_mode := hrr_rec.datetrack_mode;
2464: end if;
2465: hr_utility.set_location(' dt mode is '||l_dt_mode,30);
2466: l_db_ovn := pqh_gsp_stage_to_ben.get_ovn
2467: (p_table_name => 'PAY_GRADE_RULES_F',
2468: p_key_column_name => 'GRADE_RULE_ID',
2469: p_key_column_value => l_hrrate_id,

Line 2471: hr_utility.set_location(' ovn is '||l_db_ovn,30);

2467: (p_table_name => 'PAY_GRADE_RULES_F',
2468: p_key_column_name => 'GRADE_RULE_ID',
2469: p_key_column_value => l_hrrate_id,
2470: p_effective_date => l_effective_date);
2471: hr_utility.set_location(' ovn is '||l_db_ovn,30);
2472: if l_db_ovn <> l_hrr_ovn then
2473: l_object := hr_general.decode_lookup('PQH_GSP_OBJECT_TYPE','HRRATE');
2474: fnd_message.set_name('PQH','PQH_GSP_OBJ_OVN_INVALID');
2475: fnd_message.set_token('OBJECT ',l_object);

Line 2494: hr_utility.set_location('grade or point id '||l_grd_sp_id,20);

2490: ,p_effective_start_date => l_hrr_esd
2491: ,p_effective_end_date => l_hrr_eed);
2492: exception
2493: when others then
2494: hr_utility.set_location('grade or point id '||l_grd_sp_id,20);
2495: raise;
2496: end;
2497: end if;
2498: hr_utility.set_location('hrrate id is '||l_hrrate_id,30);

Line 2498: hr_utility.set_location('hrrate id is '||l_hrrate_id,30);

2494: hr_utility.set_location('grade or point id '||l_grd_sp_id,20);
2495: raise;
2496: end;
2497: end if;
2498: hr_utility.set_location('hrrate id is '||l_hrrate_id,30);
2499: else
2500: l_message_text := 'invalid operation '||l_dml_operation
2501: ||' hrrate id is '||l_hrrate_id
2502: ||' grade or point id '||l_grd_sp_id

Line 2521: hr_utility.set_location('leaving hr rate ',420);

2517: l_old_hrr_ovn := l_hrr_ovn;
2518: l_old_grd_cer_id := hrr_rec.information277;
2519: l_old_pnt_cer_id := hrr_rec.information278;
2520: end loop;
2521: hr_utility.set_location('leaving hr rate ',420);
2522: exception
2523: when others then
2524: PQH_GSP_PROCESS_LOG.LOG_PROCESS_DTLS
2525: (P_MASTER_TXN_ID => p_copy_entity_txn_id,