eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQH_GSP_POST_PROCESS dependencies on HR_UTILITY

Line 9: g_debug boolean := hr_utility.debug_enabled;

5: /**************************************************************************/
6: /**************************Call_PP_From_Assignments************************/
7: /**************************************************************************/
8:
9: g_debug boolean := hr_utility.debug_enabled;
10:
11: Function dt_del_mode
12: (P_EFFECTIVE_DATE IN DATE
13: ,P_BASE_TABLE_NAME IN VARCHAR2

Line 24: g_debug := hr_utility.debug_enabled;

20: l_delete_next_change Boolean;
21: --
22: Begin
23: --
24: g_debug := hr_utility.debug_enabled;
25: if g_debug then
26: hr_utility.set_location(' DT Mode ',10);
27: hr_utility.set_location(' P_Effective_Date ' || P_Effective_Date, 20);
28: hr_utility.set_location(' P_BASE_TABLE_NAME ' || P_BASE_TABLE_NAME,30);

Line 26: hr_utility.set_location(' DT Mode ',10);

22: Begin
23: --
24: g_debug := hr_utility.debug_enabled;
25: if g_debug then
26: hr_utility.set_location(' DT Mode ',10);
27: hr_utility.set_location(' P_Effective_Date ' || P_Effective_Date, 20);
28: hr_utility.set_location(' P_BASE_TABLE_NAME ' || P_BASE_TABLE_NAME,30);
29: hr_utility.set_location(' P_BASE_KEY_COLUMN ' || P_BASE_KEY_COLUMN, 40);
30: hr_utility.set_location(' P_BASE_KEY_VALUE ' || P_BASE_KEY_VALUE, 50);

Line 27: hr_utility.set_location(' P_Effective_Date ' || P_Effective_Date, 20);

23: --
24: g_debug := hr_utility.debug_enabled;
25: if g_debug then
26: hr_utility.set_location(' DT Mode ',10);
27: hr_utility.set_location(' P_Effective_Date ' || P_Effective_Date, 20);
28: hr_utility.set_location(' P_BASE_TABLE_NAME ' || P_BASE_TABLE_NAME,30);
29: hr_utility.set_location(' P_BASE_KEY_COLUMN ' || P_BASE_KEY_COLUMN, 40);
30: hr_utility.set_location(' P_BASE_KEY_VALUE ' || P_BASE_KEY_VALUE, 50);
31: End If;

Line 28: hr_utility.set_location(' P_BASE_TABLE_NAME ' || P_BASE_TABLE_NAME,30);

24: g_debug := hr_utility.debug_enabled;
25: if g_debug then
26: hr_utility.set_location(' DT Mode ',10);
27: hr_utility.set_location(' P_Effective_Date ' || P_Effective_Date, 20);
28: hr_utility.set_location(' P_BASE_TABLE_NAME ' || P_BASE_TABLE_NAME,30);
29: hr_utility.set_location(' P_BASE_KEY_COLUMN ' || P_BASE_KEY_COLUMN, 40);
30: hr_utility.set_location(' P_BASE_KEY_VALUE ' || P_BASE_KEY_VALUE, 50);
31: End If;
32:

Line 29: hr_utility.set_location(' P_BASE_KEY_COLUMN ' || P_BASE_KEY_COLUMN, 40);

25: if g_debug then
26: hr_utility.set_location(' DT Mode ',10);
27: hr_utility.set_location(' P_Effective_Date ' || P_Effective_Date, 20);
28: hr_utility.set_location(' P_BASE_TABLE_NAME ' || P_BASE_TABLE_NAME,30);
29: hr_utility.set_location(' P_BASE_KEY_COLUMN ' || P_BASE_KEY_COLUMN, 40);
30: hr_utility.set_location(' P_BASE_KEY_VALUE ' || P_BASE_KEY_VALUE, 50);
31: End If;
32:
33: dt_api.find_dt_del_modes

Line 30: hr_utility.set_location(' P_BASE_KEY_VALUE ' || P_BASE_KEY_VALUE, 50);

26: hr_utility.set_location(' DT Mode ',10);
27: hr_utility.set_location(' P_Effective_Date ' || P_Effective_Date, 20);
28: hr_utility.set_location(' P_BASE_TABLE_NAME ' || P_BASE_TABLE_NAME,30);
29: hr_utility.set_location(' P_BASE_KEY_COLUMN ' || P_BASE_KEY_COLUMN, 40);
30: hr_utility.set_location(' P_BASE_KEY_VALUE ' || P_BASE_KEY_VALUE, 50);
31: End If;
32:
33: dt_api.find_dt_del_modes
34: (p_effective_date => p_effective_date

Line 69: g_debug := hr_utility.debug_enabled;

65: L_UPDATE_OVERRIDE Boolean;
66: L_UPDATE_CHANGE_INSERT Boolean;
67:
68: Begin
69: g_debug := hr_utility.debug_enabled;
70: if g_debug then
71: hr_utility.set_location(' DT Mode ',10);
72: hr_utility.set_location(' P_Effective_Date ' || P_Effective_Date, 20);
73: hr_utility.set_location(' P_BASE_TABLE_NAME ' || P_BASE_TABLE_NAME,30);

Line 71: hr_utility.set_location(' DT Mode ',10);

67:
68: Begin
69: g_debug := hr_utility.debug_enabled;
70: if g_debug then
71: hr_utility.set_location(' DT Mode ',10);
72: hr_utility.set_location(' P_Effective_Date ' || P_Effective_Date, 20);
73: hr_utility.set_location(' P_BASE_TABLE_NAME ' || P_BASE_TABLE_NAME,30);
74: hr_utility.set_location(' P_BASE_KEY_COLUMN ' || P_BASE_KEY_COLUMN, 40);
75: hr_utility.set_location(' P_BASE_KEY_VALUE ' || P_BASE_KEY_VALUE, 50);

Line 72: hr_utility.set_location(' P_Effective_Date ' || P_Effective_Date, 20);

68: Begin
69: g_debug := hr_utility.debug_enabled;
70: if g_debug then
71: hr_utility.set_location(' DT Mode ',10);
72: hr_utility.set_location(' P_Effective_Date ' || P_Effective_Date, 20);
73: hr_utility.set_location(' P_BASE_TABLE_NAME ' || P_BASE_TABLE_NAME,30);
74: hr_utility.set_location(' P_BASE_KEY_COLUMN ' || P_BASE_KEY_COLUMN, 40);
75: hr_utility.set_location(' P_BASE_KEY_VALUE ' || P_BASE_KEY_VALUE, 50);
76: End If;

Line 73: hr_utility.set_location(' P_BASE_TABLE_NAME ' || P_BASE_TABLE_NAME,30);

69: g_debug := hr_utility.debug_enabled;
70: if g_debug then
71: hr_utility.set_location(' DT Mode ',10);
72: hr_utility.set_location(' P_Effective_Date ' || P_Effective_Date, 20);
73: hr_utility.set_location(' P_BASE_TABLE_NAME ' || P_BASE_TABLE_NAME,30);
74: hr_utility.set_location(' P_BASE_KEY_COLUMN ' || P_BASE_KEY_COLUMN, 40);
75: hr_utility.set_location(' P_BASE_KEY_VALUE ' || P_BASE_KEY_VALUE, 50);
76: End If;
77:

Line 74: hr_utility.set_location(' P_BASE_KEY_COLUMN ' || P_BASE_KEY_COLUMN, 40);

70: if g_debug then
71: hr_utility.set_location(' DT Mode ',10);
72: hr_utility.set_location(' P_Effective_Date ' || P_Effective_Date, 20);
73: hr_utility.set_location(' P_BASE_TABLE_NAME ' || P_BASE_TABLE_NAME,30);
74: hr_utility.set_location(' P_BASE_KEY_COLUMN ' || P_BASE_KEY_COLUMN, 40);
75: hr_utility.set_location(' P_BASE_KEY_VALUE ' || P_BASE_KEY_VALUE, 50);
76: End If;
77:
78: Dt_Api.FIND_DT_UPD_MODES

Line 75: hr_utility.set_location(' P_BASE_KEY_VALUE ' || P_BASE_KEY_VALUE, 50);

71: hr_utility.set_location(' DT Mode ',10);
72: hr_utility.set_location(' P_Effective_Date ' || P_Effective_Date, 20);
73: hr_utility.set_location(' P_BASE_TABLE_NAME ' || P_BASE_TABLE_NAME,30);
74: hr_utility.set_location(' P_BASE_KEY_COLUMN ' || P_BASE_KEY_COLUMN, 40);
75: hr_utility.set_location(' P_BASE_KEY_VALUE ' || P_BASE_KEY_VALUE, 50);
76: End If;
77:
78: Dt_Api.FIND_DT_UPD_MODES
79: (P_EFFECTIVE_DATE => P_Effective_Date

Line 243: g_debug := hr_utility.debug_enabled;

239: -- Bug 15928934
240:
241: Begin
242:
243: g_debug := hr_utility.debug_enabled;
244:
245: /* Initialize the Process Log */
246: Savepoint Assgt_Enrolment;
247:

Line 249: hr_utility.set_location(' Inside Asgt Call ', 10);

245: /* Initialize the Process Log */
246: Savepoint Assgt_Enrolment;
247:
248: if g_debug then
249: hr_utility.set_location(' Inside Asgt Call ', 10);
250: End If;
251:
252:
253: -- Bug 15928934

Line 314: hr_utility.set_location(' leaving Asgt Call ', 20);

310: Fetch Strtd_Le_Exits into l_Le_Exists;
311: if Strtd_Le_Exits%FOUND then
312: /* open Life Event already exists for the person */
313: if g_debug then
314: hr_utility.set_location(' leaving Asgt Call ', 20);
315: End If;
316: Close Strtd_Le_Exits;
317: If pqh_process_batch_log.g_module_cd = 'PQH_GSP_ASSIGN_ENTL' Then
318: fnd_message.set_name('PQH','PQH_GSP_LE_STRT');

Line 350: hr_utility.set_location(' Completed Override Eligibility ', 30);

346: ,P_Date_track_Mode => P_Date_Track_Mode
347: ,P_Elig_Per_Elctbl_Chc_Id => l_Elig_per_Elctbl_Chc_Id);
348:
349: if g_debug then
350: hr_utility.set_location(' Completed Override Eligibility ', 30);
351: End If;
352:
353:
354: If L_Update_Salary_Cd <> 'NO_UPDATE' and l_Elig_per_Elctbl_Chc_Id is NOT NULL Then

Line 364: hr_utility.set_location(' Completed Salary Update ', 40);

360: ,P_Prv_Sal_Chg_Dt => l_Lst_Rt_Chg_Dt);
361: End If;
362:
363: if g_debug then
364: hr_utility.set_location(' Completed Salary Update ', 40);
365: End If;
366:
367: /* Log the Entry in Process Log as Complete */
368:

Line 453: g_debug := hr_utility.debug_enabled;

449: l_VOIDD_DT Date;
450:
451: Begin
452:
453: g_debug := hr_utility.debug_enabled;
454: pqh_process_batch_log.g_module_cd := 'PQH_GSP_BENMNGLE';
455:
456: if P_Elig_per_Elctbl_Chc_Id = NULL then
457: fnd_message.set_name('PQH','PQH_GSP_DFLT_SLCT_ERR');

Line 471: hr_utility.set_location(' Inside Benmngle call ', 10);

467: Fetch Pgm_Dtl into L_UPdate_Salary_Cd;
468: Close Pgm_Dtl;
469:
470: if g_debug then
471: hr_utility.set_location(' Inside Benmngle call ', 10);
472: End If;
473:
474: /* Update the Assignment Record with the new grade , Step */
475:

Line 481: hr_utility.set_location(' Completed Asgt Update ', 30);

477: (P_Elig_Per_Elctbl_Chc_Id => P_Elig_per_Elctbl_Chc_Id
478: ,P_Effective_Date => P_Effective_Date);
479:
480: if g_debug then
481: hr_utility.set_location(' Completed Asgt Update ', 30);
482: End If;
483:
484: /* Update the Salary */
485:

Line 493: hr_utility.set_location(' Completed Sal Update ', 40);

489: ,P_Effective_Date => P_Effective_Date);
490: End If;
491:
492: if g_debug then
493: hr_utility.set_location(' Completed Sal Update ', 40);
494: End If;
495:
496: Ben_Person_Life_Event_api.UPDATE_PERSON_LIFE_EVENT
497: (P_PER_IN_LER_ID => l_PER_IN_LER_ID

Line 506: hr_utility.set_location(' Completed PIL Update ', 20);

502: ,P_OBJECT_VERSION_NUMBER => L_Pil_Ovn
503: ,P_EFFECTIVE_DATE => P_Effective_Date);
504:
505: if g_debug then
506: hr_utility.set_location(' Completed PIL Update ', 20);
507: End if;
508:
509: pqh_process_batch_log.g_module_cd := NULL;
510: Exception

Line 593: g_debug := hr_utility.debug_enabled;

589: l_business_group_id Number;
590:
591: Begin
592:
593: g_debug := hr_utility.debug_enabled;
594:
595: L_Effective_Date := Fnd_Date.CANONICAL_TO_DATE(P_Effective_Date);
596: l_business_group_id := hr_General.get_Business_group_id;
597:

Line 598: hr_utility.set_location(' Entering ', 10);

594:
595: L_Effective_Date := Fnd_Date.CANONICAL_TO_DATE(P_Effective_Date);
596: l_business_group_id := hr_General.get_Business_group_id;
597:
598: hr_utility.set_location(' Entering ', 10);
599: hr_utility.set_location(' L_Effective_Date'||L_Effective_Date, 20);
600:
601:
602: L_Concurrent_Req_Id := fnd_global.conc_request_id;

Line 599: hr_utility.set_location(' L_Effective_Date'||L_Effective_Date, 20);

595: L_Effective_Date := Fnd_Date.CANONICAL_TO_DATE(P_Effective_Date);
596: l_business_group_id := hr_General.get_Business_group_id;
597:
598: hr_utility.set_location(' Entering ', 10);
599: hr_utility.set_location(' L_Effective_Date'||L_Effective_Date, 20);
600:
601:
602: L_Concurrent_Req_Id := fnd_global.conc_request_id;
603:

Line 635: hr_utility.set_location(' leaving Asgt Call ', 20);

631: and Ler.Effective_End_Date;
632:
633: If l_Cnt > 0 then
634: if g_debug then
635: hr_utility.set_location(' leaving Asgt Call ', 20);
636: End If;
637: Else
638:
639: l_assignment_id := Asgt_Rec.assignment_id;

Line 669: hr_utility.set_location('L_date_track_mode:'||L_DATE_TRACK_MODE,90);

665: (P_EFFECTIVE_DATE => L_Effective_Date
666: ,P_BASE_TABLE_NAME => 'PER_ALL_ASSIGNMENTS_F'
667: ,P_BASE_KEY_COLUMN => 'ASSIGNMENT_ID'
668: ,P_BASE_KEY_VALUE => L_Assignment_id);
669: hr_utility.set_location('L_date_track_mode:'||L_DATE_TRACK_MODE,90);
670: IF l_date_track_mode = 'CORRECTION' OR l_date_track_mode = 'UPDATE' THEN
671: Hr_Assignment_Api.Update_Emp_Asg_Criteria
672: (p_effective_date => L_Effective_Date
673: ,p_datetrack_update_mode => L_Date_Track_Mode

Line 725: hr_utility.set_location('Erro:'|| l_Error_Exists,120);

721: ,p_module_cd => 'PQH_GSP_BATCH_ENRL'
722: ,p_message_type_cd => 'E'
723: ,p_message_text => Nvl(fnd_Message.get,sqlerrm)
724: ,P_Effective_Date => L_Effective_Date);
725: hr_utility.set_location('Erro:'|| l_Error_Exists,120);
726: End;
727: End Loop;
728:
729: If L_Error_Exists = 'N' Then

Line 739: hr_utility.set_location('Some Error:'|| SQLERRM,120);

735: fnd_Message.Set_Token('MODULE',Hr_general.Decode_lookup('PQH_PROCESS_LOG_TREE','PQH_GSP_BATCH_ENRL'));
736: fnd_file.put_line(fnd_file.log,Fnd_Message.get);
737: l_conc_status := fnd_concurrent.set_completion_status(status => 'ERROR'
738: ,message=>SQLERRM);
739: hr_utility.set_location('Some Error:'|| SQLERRM,120);
740: End If;
741: hr_utility.set_location(' Leaving ', 10);
742: PQH_PROCESS_BATCH_LOG.END_LOG;
743: Commit;

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

737: l_conc_status := fnd_concurrent.set_completion_status(status => 'ERROR'
738: ,message=>SQLERRM);
739: hr_utility.set_location('Some Error:'|| SQLERRM,120);
740: End If;
741: hr_utility.set_location(' Leaving ', 10);
742: PQH_PROCESS_BATCH_LOG.END_LOG;
743: Commit;
744: End Call_PP_For_Batch_Enrl;
745:

Line 1062: g_debug := hr_utility.debug_enabled;

1058: l_max_lf_evt_date Date;
1059:
1060: Begin
1061:
1062: g_debug := hr_utility.debug_enabled;
1063:
1064: Open Person_Info;
1065: Fetch Person_Info Into L_Person_Id, L_BG_Id , L_Grade_Id, L_pay_basis_id, l_Pgm_Id, l_New_Enrlmt_Dt;
1066: Close Person_Info;

Line 1069: hr_utility.set_location(' Inside Override Eligibility ', 10);

1065: Fetch Person_Info Into L_Person_Id, L_BG_Id , L_Grade_Id, L_pay_basis_id, l_Pgm_Id, l_New_Enrlmt_Dt;
1066: Close Person_Info;
1067:
1068: if g_debug then
1069: hr_utility.set_location(' Inside Override Eligibility ', 10);
1070: End if;
1071:
1072: If L_Grade_Id is NULL then
1073: /* Grade Not defined for the assignment

Line 1138: hr_utility.set_location(' Pgm_Id : ' || l_Pgm_Id, 20);

1134:
1135:
1136:
1137: if g_debug then
1138: hr_utility.set_location(' Pgm_Id : ' || l_Pgm_Id, 20);
1139: hr_utility.set_location(' Grade Id : ' || L_Grade_Id, 30);
1140: End if;
1141:
1142: Open Ben_Grd_Dtls(l_Pgm_Id, L_Grade_Id);

Line 1139: hr_utility.set_location(' Grade Id : ' || L_Grade_Id, 30);

1135:
1136:
1137: if g_debug then
1138: hr_utility.set_location(' Pgm_Id : ' || l_Pgm_Id, 20);
1139: hr_utility.set_location(' Grade Id : ' || L_Grade_Id, 30);
1140: End if;
1141:
1142: Open Ben_Grd_Dtls(l_Pgm_Id, L_Grade_Id);
1143: Fetch Ben_Grd_Dtls into L_Pl_id, l_plip_Id , l_Prog_style, L_Update_Salary_Cd, l_Dflt_Element_typ_Id;

Line 1162: hr_utility.set_location(' Enrollment Exists 1 .. leaving ' || l_Prog_style, 40);

1158: End If;
1159:
1160: If l_Prog_style = 'PQH_GSP_GP' and l_PL_Id = Nvl(L_Curr_Pl_Id, -999) and nvl(l_prev_assgt_id,p_assignment_id) = p_assignment_id Then --4125962
1161: if g_debug then
1162: hr_utility.set_location(' Enrollment Exists 1 .. leaving ' || l_Prog_style, 40);
1163: End if;
1164: P_Elig_Per_Elctbl_Chc_Id := NULL;
1165: Return;
1166: End If;

Line 1218: hr_utility.set_location(' l_Pgm_Id ' || l_Pgm_Id, 50);

1214: Open Opt_Bas_rt(l_Opt_Id);
1215: Fetch Opt_Bas_Rt into l_ACTY_BASE_RT_ID, l_Rt_Typ_cd, l_Entr_Ann_Val_Flag;
1216: Close Opt_Bas_Rt;
1217: if g_debug then
1218: hr_utility.set_location(' l_Pgm_Id ' || l_Pgm_Id, 50);
1219: hr_utility.set_location(' L_Pl_id ' || L_Pl_id, 60);
1220: hr_utility.set_location(' l_Oipl_Id ' || l_Oipl_Id, 70);
1221: hr_utility.set_location(' L_Person_Id ' || L_Person_Id, 80);
1222: End if;

Line 1219: hr_utility.set_location(' L_Pl_id ' || L_Pl_id, 60);

1215: Fetch Opt_Bas_Rt into l_ACTY_BASE_RT_ID, l_Rt_Typ_cd, l_Entr_Ann_Val_Flag;
1216: Close Opt_Bas_Rt;
1217: if g_debug then
1218: hr_utility.set_location(' l_Pgm_Id ' || l_Pgm_Id, 50);
1219: hr_utility.set_location(' L_Pl_id ' || L_Pl_id, 60);
1220: hr_utility.set_location(' l_Oipl_Id ' || l_Oipl_Id, 70);
1221: hr_utility.set_location(' L_Person_Id ' || L_Person_Id, 80);
1222: End if;
1223: If L_PL_Id = Nvl(l_Curr_PL_Id,-999) and l_Oipl_id = Nvl(l_Curr_oipl_Id,-9999) and nvl(l_prev_assgt_id,p_assignment_id) = p_assignment_id Then --4125962

Line 1220: hr_utility.set_location(' l_Oipl_Id ' || l_Oipl_Id, 70);

1216: Close Opt_Bas_Rt;
1217: if g_debug then
1218: hr_utility.set_location(' l_Pgm_Id ' || l_Pgm_Id, 50);
1219: hr_utility.set_location(' L_Pl_id ' || L_Pl_id, 60);
1220: hr_utility.set_location(' l_Oipl_Id ' || l_Oipl_Id, 70);
1221: hr_utility.set_location(' L_Person_Id ' || L_Person_Id, 80);
1222: End if;
1223: If L_PL_Id = Nvl(l_Curr_PL_Id,-999) and l_Oipl_id = Nvl(l_Curr_oipl_Id,-9999) and nvl(l_prev_assgt_id,p_assignment_id) = p_assignment_id Then --4125962
1224:

Line 1221: hr_utility.set_location(' L_Person_Id ' || L_Person_Id, 80);

1217: if g_debug then
1218: hr_utility.set_location(' l_Pgm_Id ' || l_Pgm_Id, 50);
1219: hr_utility.set_location(' L_Pl_id ' || L_Pl_id, 60);
1220: hr_utility.set_location(' l_Oipl_Id ' || l_Oipl_Id, 70);
1221: hr_utility.set_location(' L_Person_Id ' || L_Person_Id, 80);
1222: End if;
1223: If L_PL_Id = Nvl(l_Curr_PL_Id,-999) and l_Oipl_id = Nvl(l_Curr_oipl_Id,-9999) and nvl(l_prev_assgt_id,p_assignment_id) = p_assignment_id Then --4125962
1224:
1225: --8886934

Line 1226: hr_utility.set_location(' l_sp_max_date ' || l_sp_max_date, 81);

1222: End if;
1223: If L_PL_Id = Nvl(l_Curr_PL_Id,-999) and l_Oipl_id = Nvl(l_Curr_oipl_Id,-9999) and nvl(l_prev_assgt_id,p_assignment_id) = p_assignment_id Then --4125962
1224:
1225: --8886934
1226: hr_utility.set_location(' l_sp_max_date ' || l_sp_max_date, 81);
1227: hr_utility.set_location(' l_max_lf_evt_date ' || l_max_lf_evt_date, 81);
1228: -- 9557105
1229: -- Bug 13532919
1230: /*

Line 1227: hr_utility.set_location(' l_max_lf_evt_date ' || l_max_lf_evt_date, 81);

1223: If L_PL_Id = Nvl(l_Curr_PL_Id,-999) and l_Oipl_id = Nvl(l_Curr_oipl_Id,-9999) and nvl(l_prev_assgt_id,p_assignment_id) = p_assignment_id Then --4125962
1224:
1225: --8886934
1226: hr_utility.set_location(' l_sp_max_date ' || l_sp_max_date, 81);
1227: hr_utility.set_location(' l_max_lf_evt_date ' || l_max_lf_evt_date, 81);
1228: -- 9557105
1229: -- Bug 13532919
1230: /*
1231: hr_utility.set_location(' Enrollment Exists 2 .. leaving ' || l_Prog_style, 90);

Line 1231: hr_utility.set_location(' Enrollment Exists 2 .. leaving ' || l_Prog_style, 90);

1227: hr_utility.set_location(' l_max_lf_evt_date ' || l_max_lf_evt_date, 81);
1228: -- 9557105
1229: -- Bug 13532919
1230: /*
1231: hr_utility.set_location(' Enrollment Exists 2 .. leaving ' || l_Prog_style, 90);
1232:
1233: P_Elig_Per_Elctbl_Chc_Id := NULL;
1234: Return;
1235:

Line 1254: hr_utility.set_location(' p_effective_date ' || p_effective_date, 80);

1250:
1251: l_sal_value1 :=l_rate_value*l_annual_factor;
1252: l_sal_value2 :=l_sal_proposal*l_annual_factor;
1253:
1254: hr_utility.set_location(' p_effective_date ' || p_effective_date, 80);
1255: hr_utility.set_location(' L_Person_Id ' || L_Person_Id, 80);
1256: hr_utility.set_location(' p_assignment_id ' || p_assignment_id, 80);
1257: hr_utility.set_location(' l_rate_value ' || l_rate_value, 80);
1258: hr_utility.set_location(' l_sal_proposal ' || l_sal_proposal, 80);

Line 1255: hr_utility.set_location(' L_Person_Id ' || L_Person_Id, 80);

1251: l_sal_value1 :=l_rate_value*l_annual_factor;
1252: l_sal_value2 :=l_sal_proposal*l_annual_factor;
1253:
1254: hr_utility.set_location(' p_effective_date ' || p_effective_date, 80);
1255: hr_utility.set_location(' L_Person_Id ' || L_Person_Id, 80);
1256: hr_utility.set_location(' p_assignment_id ' || p_assignment_id, 80);
1257: hr_utility.set_location(' l_rate_value ' || l_rate_value, 80);
1258: hr_utility.set_location(' l_sal_proposal ' || l_sal_proposal, 80);
1259: hr_utility.set_location(' l_sal_value2 ' || l_sal_value2, 80);

Line 1256: hr_utility.set_location(' p_assignment_id ' || p_assignment_id, 80);

1252: l_sal_value2 :=l_sal_proposal*l_annual_factor;
1253:
1254: hr_utility.set_location(' p_effective_date ' || p_effective_date, 80);
1255: hr_utility.set_location(' L_Person_Id ' || L_Person_Id, 80);
1256: hr_utility.set_location(' p_assignment_id ' || p_assignment_id, 80);
1257: hr_utility.set_location(' l_rate_value ' || l_rate_value, 80);
1258: hr_utility.set_location(' l_sal_proposal ' || l_sal_proposal, 80);
1259: hr_utility.set_location(' l_sal_value2 ' || l_sal_value2, 80);
1260: hr_utility.set_location(' l_sal_value1 ' || l_sal_value1, 80);

Line 1257: hr_utility.set_location(' l_rate_value ' || l_rate_value, 80);

1253:
1254: hr_utility.set_location(' p_effective_date ' || p_effective_date, 80);
1255: hr_utility.set_location(' L_Person_Id ' || L_Person_Id, 80);
1256: hr_utility.set_location(' p_assignment_id ' || p_assignment_id, 80);
1257: hr_utility.set_location(' l_rate_value ' || l_rate_value, 80);
1258: hr_utility.set_location(' l_sal_proposal ' || l_sal_proposal, 80);
1259: hr_utility.set_location(' l_sal_value2 ' || l_sal_value2, 80);
1260: hr_utility.set_location(' l_sal_value1 ' || l_sal_value1, 80);
1261: hr_utility.set_location(' l_annual_factor ' || l_annual_factor, 80);

Line 1258: hr_utility.set_location(' l_sal_proposal ' || l_sal_proposal, 80);

1254: hr_utility.set_location(' p_effective_date ' || p_effective_date, 80);
1255: hr_utility.set_location(' L_Person_Id ' || L_Person_Id, 80);
1256: hr_utility.set_location(' p_assignment_id ' || p_assignment_id, 80);
1257: hr_utility.set_location(' l_rate_value ' || l_rate_value, 80);
1258: hr_utility.set_location(' l_sal_proposal ' || l_sal_proposal, 80);
1259: hr_utility.set_location(' l_sal_value2 ' || l_sal_value2, 80);
1260: hr_utility.set_location(' l_sal_value1 ' || l_sal_value1, 80);
1261: hr_utility.set_location(' l_annual_factor ' || l_annual_factor, 80);
1262:

Line 1259: hr_utility.set_location(' l_sal_value2 ' || l_sal_value2, 80);

1255: hr_utility.set_location(' L_Person_Id ' || L_Person_Id, 80);
1256: hr_utility.set_location(' p_assignment_id ' || p_assignment_id, 80);
1257: hr_utility.set_location(' l_rate_value ' || l_rate_value, 80);
1258: hr_utility.set_location(' l_sal_proposal ' || l_sal_proposal, 80);
1259: hr_utility.set_location(' l_sal_value2 ' || l_sal_value2, 80);
1260: hr_utility.set_location(' l_sal_value1 ' || l_sal_value1, 80);
1261: hr_utility.set_location(' l_annual_factor ' || l_annual_factor, 80);
1262:
1263: l_rate_value := Pqh_Gsp_Utility.PGM_TO_BASIS_CONVERSION

Line 1260: hr_utility.set_location(' l_sal_value1 ' || l_sal_value1, 80);

1256: hr_utility.set_location(' p_assignment_id ' || p_assignment_id, 80);
1257: hr_utility.set_location(' l_rate_value ' || l_rate_value, 80);
1258: hr_utility.set_location(' l_sal_proposal ' || l_sal_proposal, 80);
1259: hr_utility.set_location(' l_sal_value2 ' || l_sal_value2, 80);
1260: hr_utility.set_location(' l_sal_value1 ' || l_sal_value1, 80);
1261: hr_utility.set_location(' l_annual_factor ' || l_annual_factor, 80);
1262:
1263: l_rate_value := Pqh_Gsp_Utility.PGM_TO_BASIS_CONVERSION
1264: (P_Pgm_Id => l_Pgm_Id

Line 1261: hr_utility.set_location(' l_annual_factor ' || l_annual_factor, 80);

1257: hr_utility.set_location(' l_rate_value ' || l_rate_value, 80);
1258: hr_utility.set_location(' l_sal_proposal ' || l_sal_proposal, 80);
1259: hr_utility.set_location(' l_sal_value2 ' || l_sal_value2, 80);
1260: hr_utility.set_location(' l_sal_value1 ' || l_sal_value1, 80);
1261: hr_utility.set_location(' l_annual_factor ' || l_annual_factor, 80);
1262:
1263: l_rate_value := Pqh_Gsp_Utility.PGM_TO_BASIS_CONVERSION
1264: (P_Pgm_Id => l_Pgm_Id
1265: ,P_EFFECTIVE_DATE => P_Effective_Date

Line 1270: hr_utility.set_location(' l_rate_value ' || l_rate_value, 81);

1266: ,P_AMOUNT => l_rate_value
1267: ,P_ASSIGNMENT_ID => p_assignment_id);
1268:
1269:
1270: hr_utility.set_location(' l_rate_value ' || l_rate_value, 81);
1271: hr_utility.set_location(' l_sal_proposal ' || l_sal_proposal, 81);
1272:
1273: if l_rate_value=l_sal_proposal then
1274:

Line 1271: hr_utility.set_location(' l_sal_proposal ' || l_sal_proposal, 81);

1267: ,P_ASSIGNMENT_ID => p_assignment_id);
1268:
1269:
1270: hr_utility.set_location(' l_rate_value ' || l_rate_value, 81);
1271: hr_utility.set_location(' l_sal_proposal ' || l_sal_proposal, 81);
1272:
1273: if l_rate_value=l_sal_proposal then
1274:
1275: if g_debug then

Line 1276: hr_utility.set_location(' Enrollment Exists 2 .. leaving ' || l_Prog_style, 90);

1272:
1273: if l_rate_value=l_sal_proposal then
1274:
1275: if g_debug then
1276: hr_utility.set_location(' Enrollment Exists 2 .. leaving ' || l_Prog_style, 90);
1277: End If;
1278: P_Elig_Per_Elctbl_Chc_Id := NULL;
1279: Return;
1280: End If;

Line 1324: hr_utility.set_location(' Created Potential Life Event records ', 100);

1320: ,P_OBJECT_VERSION_NUMBER => l_Ptnl_Ovn
1321: ,P_EFFECTIVE_DATE => l_New_Enrlmt_Dt);
1322:
1323: if g_debug then
1324: hr_utility.set_location(' Created Potential Life Event records ', 100);
1325: hr_utility.set_location(' L_PTNL_LER_FOR_PER_ID : ' || L_PTNL_LER_FOR_PER_ID, 110);
1326: End If;
1327:
1328: /* Create Life Event for the Above created Potential Life Event */

Line 1325: hr_utility.set_location(' L_PTNL_LER_FOR_PER_ID : ' || L_PTNL_LER_FOR_PER_ID, 110);

1321: ,P_EFFECTIVE_DATE => l_New_Enrlmt_Dt);
1322:
1323: if g_debug then
1324: hr_utility.set_location(' Created Potential Life Event records ', 100);
1325: hr_utility.set_location(' L_PTNL_LER_FOR_PER_ID : ' || L_PTNL_LER_FOR_PER_ID, 110);
1326: End If;
1327:
1328: /* Create Life Event for the Above created Potential Life Event */
1329: Ben_Person_Life_Event_api.CREATE_PERSON_LIFE_EVENT_PERF

Line 1344: hr_utility.set_location(' Created PIL ', 120);

1340: ,P_OBJECT_VERSION_NUMBER => L_Pil_Ovn
1341: ,P_EFFECTIVE_DATE => l_New_Enrlmt_Dt);
1342:
1343: if g_debug then
1344: hr_utility.set_location(' Created PIL ', 120);
1345: hr_utility.set_location(' l_PER_IN_LER_ID : ' || l_PER_IN_LER_ID, 130);
1346: End If;
1347:
1348: /* Create Electable Choice Records */

Line 1345: hr_utility.set_location(' l_PER_IN_LER_ID : ' || l_PER_IN_LER_ID, 130);

1341: ,P_EFFECTIVE_DATE => l_New_Enrlmt_Dt);
1342:
1343: if g_debug then
1344: hr_utility.set_location(' Created PIL ', 120);
1345: hr_utility.set_location(' l_PER_IN_LER_ID : ' || l_PER_IN_LER_ID, 130);
1346: End If;
1347:
1348: /* Create Electable Choice Records */
1349: /* For Grade */

Line 1352: hr_utility.set_location(' Attempting to create Elig_per ', 140);

1348: /* Create Electable Choice Records */
1349: /* For Grade */
1350:
1351: if g_debug then
1352: hr_utility.set_location(' Attempting to create Elig_per ', 140);
1353: hr_utility.set_location(' Business_Group_Id :' || l_Bg_Id, 150);
1354: end if;
1355: -- sgoyal plan year period should be in place now, please give it a try
1356: /*

Line 1353: hr_utility.set_location(' Business_Group_Id :' || l_Bg_Id, 150);

1349: /* For Grade */
1350:
1351: if g_debug then
1352: hr_utility.set_location(' Attempting to create Elig_per ', 140);
1353: hr_utility.set_location(' Business_Group_Id :' || l_Bg_Id, 150);
1354: end if;
1355: -- sgoyal plan year period should be in place now, please give it a try
1356: /*
1357: Open Yr_prd(L_Pl_Id, l_Bg_Id);

Line 1389: hr_utility.set_location(' Created Elig_per ', 160);

1385:
1386: L_Rt_Elig_Per_Elctbl_Chc_Id := L_Elig_Per_Elctbl_Chc_Id;
1387:
1388: if g_debug then
1389: hr_utility.set_location(' Created Elig_per ', 160);
1390: hr_utility.set_location(' L_Elig_Per_Elctbl_Chc_Id : ' || L_Elig_Per_Elctbl_Chc_Id, 170);
1391: End If;
1392:
1393: If l_Prog_style in ('PQH_GSP_SP','PQH_GSP_GSP','MINSALINCR','MINSTEP','NOSTEP') Then

Line 1390: hr_utility.set_location(' L_Elig_Per_Elctbl_Chc_Id : ' || L_Elig_Per_Elctbl_Chc_Id, 170);

1386: L_Rt_Elig_Per_Elctbl_Chc_Id := L_Elig_Per_Elctbl_Chc_Id;
1387:
1388: if g_debug then
1389: hr_utility.set_location(' Created Elig_per ', 160);
1390: hr_utility.set_location(' L_Elig_Per_Elctbl_Chc_Id : ' || L_Elig_Per_Elctbl_Chc_Id, 170);
1391: End If;
1392:
1393: If l_Prog_style in ('PQH_GSP_SP','PQH_GSP_GSP','MINSALINCR','MINSTEP','NOSTEP') Then
1394:

Line 1425: hr_utility.set_location('L_Update_Salary_Cd :' || L_Update_Salary_Cd, 180);

1421: fnd_message.raise_error;
1422: End If;
1423: If P_Called_From <> 'BM' Then
1424: if g_debug then
1425: hr_utility.set_location('L_Update_Salary_Cd :' || L_Update_Salary_Cd, 180);
1426: End If;
1427: If L_Update_Salary_Cd in ('SALARY_BASIS','SALARY_ELEMENT') Then
1428:
1429: /* Not Batch Mode and Salary Update is Set for the Grade ladder */

Line 1431: hr_utility.set_location(' Determine Rates ', 190);

1427: If L_Update_Salary_Cd in ('SALARY_BASIS','SALARY_ELEMENT') Then
1428:
1429: /* Not Batch Mode and Salary Update is Set for the Grade ladder */
1430: if g_debug then
1431: hr_utility.set_location(' Determine Rates ', 190);
1432: End If;
1433:
1434: ben_env_object.init(p_business_group_id => l_Bg_Id,
1435: p_effective_date => l_New_Enrlmt_Dt,

Line 1453: hr_utility.set_location(' Determined Rates ', 200);

1449: ,p_elig_per_elctbl_chc_id => L_Rt_Elig_Per_Elctbl_Chc_Id);
1450: End If;
1451:
1452: if g_debug then
1453: hr_utility.set_location(' Determined Rates ', 200);
1454: End if;
1455:
1456: Else
1457:

Line 1480: hr_utility.set_location(' Close Life Event ', 210);

1476: End If;
1477:
1478: /* Close the person Life Event as Processed */
1479: if g_debug then
1480: hr_utility.set_location(' Close Life Event ', 210);
1481: End if;
1482:
1483: Ben_Person_Life_Event_api.UPDATE_PERSON_LIFE_EVENT
1484: (P_PER_IN_LER_ID => l_PER_IN_LER_ID

Line 1493: hr_utility.set_location(' Closed Life Event ', 220);

1489: ,P_OBJECT_VERSION_NUMBER => L_Pil_Ovn
1490: ,P_EFFECTIVE_DATE => l_New_Enrlmt_Dt);
1491:
1492: if g_debug then
1493: hr_utility.set_location(' Closed Life Event ', 220);
1494: End If;
1495:
1496: P_Elig_Per_Elctbl_Chc_Id := L_Rt_Elig_Per_Elctbl_Chc_Id;
1497: Exception

Line 1535: g_debug := hr_utility.debug_enabled;

1531: L_DPNT_ACTN_WARNING Boolean;
1532: L_BNF_ACTN_WARNING Boolean;
1533: L_CTFN_ACTN_WARNING Boolean;
1534: begin
1535: g_debug := hr_utility.debug_enabled;
1536:
1537: For Enrl_Rec in Enrolment
1538: Loop
1539:

Line 1721: hr_utility.set_location('Starting end dating prev payment',5);

1717: Begin
1718: --
1719: -- Find the current per_in_ler and person_id.
1720: --
1721: hr_utility.set_location('Starting end dating prev payment',5);
1722: hr_utility.set_location('Elctbl chc = '||to_char(P_Elig_per_Elctbl_Chc_Id),5);
1723: hr_utility.set_location('le occrd dt = '||to_char(p_effective_date,'dd-mon-yyyy'),5);
1724: Open csr_curr_le;
1725: Fetch csr_curr_le into l_curr_per_in_ler_id, l_person_id;

Line 1722: hr_utility.set_location('Elctbl chc = '||to_char(P_Elig_per_Elctbl_Chc_Id),5);

1718: --
1719: -- Find the current per_in_ler and person_id.
1720: --
1721: hr_utility.set_location('Starting end dating prev payment',5);
1722: hr_utility.set_location('Elctbl chc = '||to_char(P_Elig_per_Elctbl_Chc_Id),5);
1723: hr_utility.set_location('le occrd dt = '||to_char(p_effective_date,'dd-mon-yyyy'),5);
1724: Open csr_curr_le;
1725: Fetch csr_curr_le into l_curr_per_in_ler_id, l_person_id;
1726: If csr_curr_le%found then

Line 1723: hr_utility.set_location('le occrd dt = '||to_char(p_effective_date,'dd-mon-yyyy'),5);

1719: -- Find the current per_in_ler and person_id.
1720: --
1721: hr_utility.set_location('Starting end dating prev payment',5);
1722: hr_utility.set_location('Elctbl chc = '||to_char(P_Elig_per_Elctbl_Chc_Id),5);
1723: hr_utility.set_location('le occrd dt = '||to_char(p_effective_date,'dd-mon-yyyy'),5);
1724: Open csr_curr_le;
1725: Fetch csr_curr_le into l_curr_per_in_ler_id, l_person_id;
1726: If csr_curr_le%found then
1727: -- Found current life event and person id.

Line 1732: hr_utility.set_location('Found current life event and person id = '||to_char(l_curr_per_in_ler_id),5);

1728: Close csr_curr_le;
1729: --
1730: -- Find when the salary change was made for the last GSP run.
1731: --
1732: hr_utility.set_location('Found current life event and person id = '||to_char(l_curr_per_in_ler_id),5);
1733: Open csr_prev_le;
1734: Fetch csr_prev_le into l_Last_Per_In_ler_Id;
1735: Close csr_prev_le;
1736: If l_Last_Per_In_ler_Id is not null then

Line 1739: hr_utility.set_location('Found previous per_in_ler = '||to_char(l_Last_Per_In_ler_Id),5);

1735: Close csr_prev_le;
1736: If l_Last_Per_In_ler_Id is not null then
1737: --
1738: --
1739: hr_utility.set_location('Found previous per_in_ler = '||to_char(l_Last_Per_In_ler_Id),5);
1740: -- Get the grade ladder, sal change date and rate value for the prev run.
1741: --
1742: Open csr_prev_sal;
1743: Fetch csr_prev_sal into l_prev_grade_ladder_id,l_prev_sal_change_dt,l_prev_sal;

Line 1746: hr_utility.set_location('No Previous ladder',10);

1742: Open csr_prev_sal;
1743: Fetch csr_prev_sal into l_prev_grade_ladder_id,l_prev_sal_change_dt,l_prev_sal;
1744: If csr_prev_sal%notfound then
1745: --
1746: hr_utility.set_location('No Previous ladder',10);
1747: Close csr_prev_sal;
1748: Else
1749: Close csr_prev_sal;
1750: --

Line 1751: hr_utility.set_location('Found previous ladder',5);

1747: Close csr_prev_sal;
1748: Else
1749: Close csr_prev_sal;
1750: --
1751: hr_utility.set_location('Found previous ladder',5);
1752: -- Find the max rate change date. Ignore rate change date for current change.
1753: --
1754: Open csr_max_rt_change;
1755: Fetch csr_max_rt_change into l_max_rt_change_dt;

Line 1761: hr_utility.set_location('Last sal change happened just bef current',5);

1757: --
1758: If (l_prev_sal_change_dt <= p_current_rate_change_dt AND
1759: l_prev_sal_change_dt = l_max_rt_change_dt) then
1760: --
1761: hr_utility.set_location('Last sal change happened just bef current',5);
1762: --
1763: -- Get the grade ladder salary update details
1764: --
1765: OPen Pgm_Dtl(l_prev_grade_ladder_id,l_prev_sal_change_dt);

Line 1772: hr_utility.set_location('Sal Element used to pay previously',5);

1768:
1769: If L_Update_Salary_Cd = 'SALARY_ELEMENT' AND
1770: l_prev_sal is not null Then
1771: --
1772: hr_utility.set_location('Sal Element used to pay previously',5);
1773: If L_DFLT_INPUT_VALUE_ID is NULL or L_DFLT_ELEMENT_TYPE_ID is NULL Then
1774: fnd_message.set_name('PQH','PQH_GSP_DFLY_ELMNT_NOT_LNKD');
1775: fnd_message.raise_error;
1776: End If;

Line 1781: hr_utility.set_location('Found previous element entry',5);

1777: --
1778: Open Elmt_Entry(p_Assignment_Id, p_Business_Group_Id, l_prev_sal_change_dt);
1779: Fetch Elmt_Entry into L_Element_Entry_ID, L_Ele_Ovn;
1780: If Elmt_Entry%Found Then
1781: hr_utility.set_location('Found previous element entry',5);
1782:
1783: If l_prev_sal_change_dt = p_current_rate_change_dt then
1784: --
1785: hr_utility.set_location('Zap element entry',5);

Line 1785: hr_utility.set_location('Zap element entry',5);

1781: hr_utility.set_location('Found previous element entry',5);
1782:
1783: If l_prev_sal_change_dt = p_current_rate_change_dt then
1784: --
1785: hr_utility.set_location('Zap element entry',5);
1786: --
1787: hr_entry_api.delete_element_entry
1788: ('ZAP'
1789: ,p_current_rate_change_dt

Line 1820: hr_utility.set_location('Sal Basis used to pay previously',5);

1816: --
1817: ElsIf L_Update_Salary_Cd = 'SALARY_BASIS' AND
1818: l_prev_sal is not null Then
1819: --
1820: hr_utility.set_location('Sal Basis used to pay previously',5);
1821: -- End date salary proposal
1822: Open Proposal_Dtls(p_assignment_Id,l_prev_sal_change_dt);
1823: Fetch proposal_Dtls into l_Del_Proposal_Id, l_Del_Proposal_Ovn,l_proposal_date_to; -- bug 6856664
1824: Close Proposal_Dtls;

Line 1828: hr_utility.set_location('Found previous pay proposal',5);

1824: Close Proposal_Dtls;
1825: --
1826: if l_Del_Proposal_Id is Not NULL then
1827: --
1828: hr_utility.set_location('Found previous pay proposal',5);
1829: Open csr_prev_sp_element;
1830: Fetch csr_prev_sp_element into L_Element_Entry_ID;
1831: If csr_prev_sp_element%notfound then
1832: hr_utility.set_location('Cannot find sal proposal element ! ',5);

Line 1832: hr_utility.set_location('Cannot find sal proposal element ! ',5);

1828: hr_utility.set_location('Found previous pay proposal',5);
1829: Open csr_prev_sp_element;
1830: Fetch csr_prev_sp_element into L_Element_Entry_ID;
1831: If csr_prev_sp_element%notfound then
1832: hr_utility.set_location('Cannot find sal proposal element ! ',5);
1833: end if;
1834: Close csr_prev_sp_element;
1835:
1836: -- Previous change happened on same date as current change.

Line 1840: hr_utility.set_location('previous proposal date same as curr change date',5);

1836: -- Previous change happened on same date as current change.
1837: --
1838: If l_prev_sal_change_dt = p_current_rate_change_dt then
1839: --
1840: hr_utility.set_location('previous proposal date same as curr change date',5);
1841: Hr_Maintain_Proposal_Api.DELETE_SALARY_PROPOSAL
1842: (P_PAY_PROPOSAL_ID => l_Del_proposal_Id
1843: ,P_BUSINESS_GROUP_ID => p_business_Group_Id
1844: ,P_OBJECT_VERSION_NUMBER => l_Del_Proposal_Ovn

Line 1848: hr_utility.set_location('Zap element entry',5);

1844: ,P_OBJECT_VERSION_NUMBER => l_Del_Proposal_Ovn
1845: ,P_SALARY_WARNING => l_Del_Warn);
1846: --
1847: /**
1848: hr_utility.set_location('Zap element entry',5);
1849: --
1850: hr_entry_api.delete_element_entry
1851: ('ZAP'
1852: ,p_current_rate_change_dt - 1

Line 1861: hr_utility.set_location('previous proposal date before curr change date',5);

1857: --
1858: -- End date Salary proposal
1859: --
1860: --
1861: hr_utility.set_location('previous proposal date before curr change date',5);
1862: --
1863: hr_maintain_proposal_api.update_salary_proposal(
1864: p_validate => false,
1865: p_pay_proposal_id => l_Del_proposal_Id,

Line 1873: hr_utility.set_location('End dating element entry',5);

1869: p_proposed_salary_warning => l_proposed_salary_warning,
1870: p_approved_warning => l_approved_warning,
1871: p_payroll_warning => l_payroll_warning);
1872: --
1873: hr_utility.set_location('End dating element entry',5);
1874: --
1875: /* bug 6914468 and bug 6880958
1876: commenting this part as the deleting or end dating of element entries
1877: will be taken care by the Sal admin api's

Line 1890: hr_utility.set_location('Do nothing',99);

1886: End if; --if l_Del_Proposal_Id is Not NULL then
1887: --
1888: End if; -- L_Update_Salary_Cd = 'SALARY_ELEMENT'
1889: Else
1890: hr_utility.set_location('Do nothing',99);
1891: hr_utility.set_location('Prev Salary change date ='||to_char(l_prev_sal_change_dt,'dd/mm/yyyy'),99);
1892: hr_utility.set_location('Last Salary change date ='||to_char(l_max_rt_change_dt,'dd/mm/yyyy'),99);
1893: End if; --If (l_prev_sal_change_dt <= p_current_rate_change_dt AND
1894: End if; --If csr_prev_sal%notfound then

Line 1891: hr_utility.set_location('Prev Salary change date ='||to_char(l_prev_sal_change_dt,'dd/mm/yyyy'),99);

1887: --
1888: End if; -- L_Update_Salary_Cd = 'SALARY_ELEMENT'
1889: Else
1890: hr_utility.set_location('Do nothing',99);
1891: hr_utility.set_location('Prev Salary change date ='||to_char(l_prev_sal_change_dt,'dd/mm/yyyy'),99);
1892: hr_utility.set_location('Last Salary change date ='||to_char(l_max_rt_change_dt,'dd/mm/yyyy'),99);
1893: End if; --If (l_prev_sal_change_dt <= p_current_rate_change_dt AND
1894: End if; --If csr_prev_sal%notfound then
1895: --

Line 1892: hr_utility.set_location('Last Salary change date ='||to_char(l_max_rt_change_dt,'dd/mm/yyyy'),99);

1888: End if; -- L_Update_Salary_Cd = 'SALARY_ELEMENT'
1889: Else
1890: hr_utility.set_location('Do nothing',99);
1891: hr_utility.set_location('Prev Salary change date ='||to_char(l_prev_sal_change_dt,'dd/mm/yyyy'),99);
1892: hr_utility.set_location('Last Salary change date ='||to_char(l_max_rt_change_dt,'dd/mm/yyyy'),99);
1893: End if; --If (l_prev_sal_change_dt <= p_current_rate_change_dt AND
1894: End if; --If csr_prev_sal%notfound then
1895: --
1896: Else

Line 1899: hr_utility.set_location('No previous salary change by GSP',10);

1895: --
1896: Else
1897: -- No other salary change happened through GSP.
1898: -- Do nothing.
1899: hr_utility.set_location('No previous salary change by GSP',10);
1900: End if; -- If csr_prev_le%found then
1901: Else
1902: hr_utility.set_location('Error: No Person and Per in ler',10);
1903: Close csr_curr_le;

Line 1902: hr_utility.set_location('Error: No Person and Per in ler',10);

1898: -- Do nothing.
1899: hr_utility.set_location('No previous salary change by GSP',10);
1900: End if; -- If csr_prev_le%found then
1901: Else
1902: hr_utility.set_location('Error: No Person and Per in ler',10);
1903: Close csr_curr_le;
1904: End if; --csr_curr_le%found
1905: --
1906: End; -- Change by SR

Line 2072: g_debug := hr_utility.debug_enabled;

2068: -- bug 6880958 for updateoverride mode
2069: --
2070: Begin
2071:
2072: g_debug := hr_utility.debug_enabled;
2073:
2074: --
2075: -- Get enrollment details for the current change.
2076: --

Line 2077: hr_utility.set_location(' p_Effective_date :' || p_Effective_date, 30);

2073:
2074: --
2075: -- Get enrollment details for the current change.
2076: --
2077: hr_utility.set_location(' p_Effective_date :' || p_Effective_date, 30);
2078:
2079: Open Enroll_Info;
2080: Fetch Enroll_Info into L_Enroll_Info;
2081: Close Enroll_Info;

Line 2084: hr_utility.set_location(' Inside Salary Update: Elec_id :' || P_Elig_Per_Elctbl_Chc_Id, 10);

2080: Fetch Enroll_Info into L_Enroll_Info;
2081: Close Enroll_Info;
2082:
2083: if g_debug then
2084: hr_utility.set_location(' Inside Salary Update: Elec_id :' || P_Elig_Per_Elctbl_Chc_Id, 10);
2085: hr_utility.set_location(' L_Enroll_Info.Business_Group_Id :' || L_Enroll_Info.Business_Group_Id, 20);
2086: hr_utility.set_location(' L_Enroll_Info.OVN :' || L_Enroll_Info.Object_version_number, 30);
2087: End If;
2088:

Line 2085: hr_utility.set_location(' L_Enroll_Info.Business_Group_Id :' || L_Enroll_Info.Business_Group_Id, 20);

2081: Close Enroll_Info;
2082:
2083: if g_debug then
2084: hr_utility.set_location(' Inside Salary Update: Elec_id :' || P_Elig_Per_Elctbl_Chc_Id, 10);
2085: hr_utility.set_location(' L_Enroll_Info.Business_Group_Id :' || L_Enroll_Info.Business_Group_Id, 20);
2086: hr_utility.set_location(' L_Enroll_Info.OVN :' || L_Enroll_Info.Object_version_number, 30);
2087: End If;
2088:
2089: --

Line 2086: hr_utility.set_location(' L_Enroll_Info.OVN :' || L_Enroll_Info.Object_version_number, 30);

2082:
2083: if g_debug then
2084: hr_utility.set_location(' Inside Salary Update: Elec_id :' || P_Elig_Per_Elctbl_Chc_Id, 10);
2085: hr_utility.set_location(' L_Enroll_Info.Business_Group_Id :' || L_Enroll_Info.Business_Group_Id, 20);
2086: hr_utility.set_location(' L_Enroll_Info.OVN :' || L_Enroll_Info.Object_version_number, 30);
2087: End If;
2088:
2089: --
2090: -- Get the grade ladder salary update details

Line 2137: hr_utility.set_location(' L_Change_Dt:' || L_Change_Dt, 30);

2133: -- If P_Dt_Mode = 'CORRECTION' and P_Called_From = 'A' Then
2134: If P_Called_From = 'A' Then
2135: -- If there is a salary proposal that was created either on current date
2136: -- or during last GSP run,
2137: hr_utility.set_location(' L_Change_Dt:' || L_Change_Dt, 30);
2138:
2139: If L_Change_Dt is NOT NULL then
2140: --
2141: -- Get the last pay proposal creation date.

Line 2150: hr_utility.set_location(' P_Prv_Sal_Chg_Dt :' || P_Prv_Sal_Chg_Dt, 31);

2146: --
2147: -- If pay proposal already exists as of current date, then delete
2148: -- i.e. If Correction
2149: --
2150: hr_utility.set_location(' P_Prv_Sal_Chg_Dt :' || P_Prv_Sal_Chg_Dt, 31);
2151: hr_utility.set_location(' L_Enroll_Info.RT_Strt_Dt :' || L_Enroll_Info.RT_Strt_Dt, 32);
2152:
2153: If ((L_Change_Dt = L_Enroll_Info.RT_Strt_Dt) or
2154: (L_Change_Dt = P_Prv_Sal_Chg_Dt)) Then

Line 2151: hr_utility.set_location(' L_Enroll_Info.RT_Strt_Dt :' || L_Enroll_Info.RT_Strt_Dt, 32);

2147: -- If pay proposal already exists as of current date, then delete
2148: -- i.e. If Correction
2149: --
2150: hr_utility.set_location(' P_Prv_Sal_Chg_Dt :' || P_Prv_Sal_Chg_Dt, 31);
2151: hr_utility.set_location(' L_Enroll_Info.RT_Strt_Dt :' || L_Enroll_Info.RT_Strt_Dt, 32);
2152:
2153: If ((L_Change_Dt = L_Enroll_Info.RT_Strt_Dt) or
2154: (L_Change_Dt = P_Prv_Sal_Chg_Dt)) Then
2155:

Line 2173: hr_utility.set_location(' P_Dt_Mode :' || P_Dt_Mode, 1);

2169: --
2170: -- fix for bug 6880958 starts here .. deleting all the pay proposals as we are performing
2171: -- update replace operation.
2172: --
2173: hr_utility.set_location(' P_Dt_Mode :' || P_Dt_Mode, 1);
2174: hr_utility.set_location(' L_Enroll_Info.Assignment_Id :' || L_Enroll_Info.Assignment_Id, 2);
2175:
2176: if P_Dt_Mode = 'UPDATE_OVERRIDE' THEN
2177:

Line 2174: hr_utility.set_location(' L_Enroll_Info.Assignment_Id :' || L_Enroll_Info.Assignment_Id, 2);

2170: -- fix for bug 6880958 starts here .. deleting all the pay proposals as we are performing
2171: -- update replace operation.
2172: --
2173: hr_utility.set_location(' P_Dt_Mode :' || P_Dt_Mode, 1);
2174: hr_utility.set_location(' L_Enroll_Info.Assignment_Id :' || L_Enroll_Info.Assignment_Id, 2);
2175:
2176: if P_Dt_Mode = 'UPDATE_OVERRIDE' THEN
2177:
2178: open csr_count_pay_det(L_Enroll_Info.Assignment_Id);

Line 2190: hr_utility.set_location(' l_change_date :' || l_change_date, 10);

2186: OPEN next_change_date(L_Enroll_Info.Assignment_Id) ;
2187: FETCH next_change_date INTO l_change_date,l_Del_Proposal_Id, l_Del_Proposal_Ovn;
2188: EXIT WHEN next_change_date%NOTFOUND;
2189:
2190: hr_utility.set_location(' l_change_date :' || l_change_date, 10);
2191: hr_utility.set_location(' l_Del_Proposal_Id :' || l_Del_Proposal_Id, 20);
2192: hr_utility.set_location(' l_Del_Proposal_Ovn :' || l_Del_Proposal_Ovn, 30);
2193:
2194: -- NOW DELETE ALL THE PROPOSALS AS WE ARE PERFORMING A UPDATE REPLACE OPERATION

Line 2191: hr_utility.set_location(' l_Del_Proposal_Id :' || l_Del_Proposal_Id, 20);

2187: FETCH next_change_date INTO l_change_date,l_Del_Proposal_Id, l_Del_Proposal_Ovn;
2188: EXIT WHEN next_change_date%NOTFOUND;
2189:
2190: hr_utility.set_location(' l_change_date :' || l_change_date, 10);
2191: hr_utility.set_location(' l_Del_Proposal_Id :' || l_Del_Proposal_Id, 20);
2192: hr_utility.set_location(' l_Del_Proposal_Ovn :' || l_Del_Proposal_Ovn, 30);
2193:
2194: -- NOW DELETE ALL THE PROPOSALS AS WE ARE PERFORMING A UPDATE REPLACE OPERATION
2195:

Line 2192: hr_utility.set_location(' l_Del_Proposal_Ovn :' || l_Del_Proposal_Ovn, 30);

2188: EXIT WHEN next_change_date%NOTFOUND;
2189:
2190: hr_utility.set_location(' l_change_date :' || l_change_date, 10);
2191: hr_utility.set_location(' l_Del_Proposal_Id :' || l_Del_Proposal_Id, 20);
2192: hr_utility.set_location(' l_Del_Proposal_Ovn :' || l_Del_Proposal_Ovn, 30);
2193:
2194: -- NOW DELETE ALL THE PROPOSALS AS WE ARE PERFORMING A UPDATE REPLACE OPERATION
2195:
2196: Hr_Maintain_Proposal_Api.DELETE_SALARY_PROPOSAL

Line 2202: hr_utility.set_location(' after calling delete Proposal ' || l_Del_Proposal_Id, 20);

2198: ,P_BUSINESS_GROUP_ID => L_Enroll_Info.Business_Group_Id
2199: ,P_OBJECT_VERSION_NUMBER => l_Del_Proposal_Ovn
2200: ,P_SALARY_WARNING => l_Del_Warn);
2201: --
2202: hr_utility.set_location(' after calling delete Proposal ' || l_Del_Proposal_Id, 20);
2203:
2204:
2205: CLOSE next_change_date;
2206:

Line 2222: hr_utility.set_location(' Max Element entry date: ' ||L_entry_date,1);

2218: from pay_element_entries_f
2219: where assignment_id=L_Enroll_Info.Assignment_Id
2220: and creator_type='SP';
2221:
2222: hr_utility.set_location(' Max Element entry date: ' ||L_entry_date,1);
2223: --
2224: -- fix for bug 6880958 ends..
2225:
2226: hr_utility.set_location('Calling end_prev_gsp_payment 0',99);

Line 2226: hr_utility.set_location('Calling end_prev_gsp_payment 0',99);

2222: hr_utility.set_location(' Max Element entry date: ' ||L_entry_date,1);
2223: --
2224: -- fix for bug 6880958 ends..
2225:
2226: hr_utility.set_location('Calling end_prev_gsp_payment 0',99);
2227: end_prev_gsp_payment(
2228: p_assignment_id => L_Enroll_Info.Assignment_Id
2229: ,p_business_group_id => L_Enroll_Info.Business_Group_Id
2230: ,P_Effective_Date => p_effective_date

Line 2233: hr_utility.set_location('After end_prev_gsp_payment 0',99);

2229: ,p_business_group_id => L_Enroll_Info.Business_Group_Id
2230: ,P_Effective_Date => p_effective_date
2231: ,P_Elig_per_Elctbl_Chc_Id => P_Elig_per_Elctbl_Chc_Id
2232: ,p_current_rate_change_dt => L_Enroll_Info.RT_Strt_Dt);
2233: hr_utility.set_location('After end_prev_gsp_payment 0',99);
2234: --
2235: End if;
2236: --
2237: Else

Line 2238: hr_utility.set_location('Calling end_prev_gsp_payment 1',99);

2234: --
2235: End if;
2236: --
2237: Else
2238: hr_utility.set_location('Calling end_prev_gsp_payment 1',99);
2239: end_prev_gsp_payment(
2240: p_assignment_id => L_Enroll_Info.Assignment_Id
2241: ,p_business_group_id => L_Enroll_Info.Business_Group_Id
2242: ,P_Effective_Date => p_effective_date

Line 2245: hr_utility.set_location('After end_prev_gsp_payment 1',99);

2241: ,p_business_group_id => L_Enroll_Info.Business_Group_Id
2242: ,P_Effective_Date => p_effective_date
2243: ,P_Elig_per_Elctbl_Chc_Id => P_Elig_per_Elctbl_Chc_Id
2244: ,p_current_rate_change_dt => L_Enroll_Info.RT_Strt_Dt);
2245: hr_utility.set_location('After end_prev_gsp_payment 1',99);
2246:
2247: End If;
2248:
2249: --

Line 2350: hr_utility.set_location('Sal = '||to_char(L_Salary)||',DT_Mode = '||L_DATE_TRACK_MODE,99);

2346: (P_EFFECTIVE_DATE => L_Enroll_Info.RT_Strt_Dt
2347: ,P_BASE_TABLE_NAME => 'PAY_ELEMENT_ENTRIES_F'
2348: ,P_BASE_KEY_COLUMN => 'ELEMENT_ENTRY_ID'
2349: ,P_BASE_KEY_VALUE => L_Element_Entry_ID);
2350: hr_utility.set_location('Sal = '||to_char(L_Salary)||',DT_Mode = '||L_DATE_TRACK_MODE,99);
2351:
2352: Pay_Element_Entry_Api.UPDATE_ELEMENT_ENTRY
2353: (P_DATETRACK_UPDATE_MODE => L_DATE_TRACK_MODE
2354: ,P_EFFECTIVE_DATE => L_Enroll_Info.RT_Strt_Dt

Line 2370: hr_utility.set_location('Calling end_prev_gsp_payment 2',99);

2366: -- If the element entry is not found for current element, it maybe due to 2 reasons
2367: -- 1) old grade ladder used a diff element, in which case we have to end date that element
2368: -- 2) old grade ladder used salary basis, in which case we have to end date the proposal.
2369:
2370: hr_utility.set_location('Calling end_prev_gsp_payment 2',99);
2371: end_prev_gsp_payment(
2372: p_assignment_id => L_Enroll_Info.Assignment_Id
2373: ,p_business_group_id => L_Enroll_Info.Business_Group_Id
2374: ,P_Effective_Date => p_effective_date

Line 2377: hr_utility.set_location('After end_prev_gsp_payment 2',99);

2373: ,p_business_group_id => L_Enroll_Info.Business_Group_Id
2374: ,P_Effective_Date => p_effective_date
2375: ,P_Elig_per_Elctbl_Chc_Id => P_Elig_per_Elctbl_Chc_Id
2376: ,p_current_rate_change_dt => L_Enroll_Info.RT_Strt_Dt);
2377: hr_utility.set_location('After end_prev_gsp_payment 2',99);
2378:
2379: Pay_Element_Entry_Api.CREATE_ELEMENT_ENTRY
2380: (P_EFFECTIVE_DATE => L_Enroll_Info.RT_Strt_Dt
2381: ,P_BUSINESS_GROUP_ID => L_Enroll_Info.Business_Group_Id

Line 2511: hr_utility.set_location(' Inside Update_Assgmt_Info ', 10);

2507: l_Asgt_Grdldr_Id Per_all_Assignments_F.Grade_Ladder_Pgm_Id%TYPE;
2508: Begin
2509:
2510: if g_debug then
2511: hr_utility.set_location(' Inside Update_Assgmt_Info ', 10);
2512: End If;
2513:
2514: Open Enrlmt_Dtls;
2515: Fetch Enrlmt_Dtls into l_pl_Id , l_Pgm_Id ,l_Oipl_id , L_Business_group_Id, l_Enrt_Cvg_Strt_Dt,

Line 2534: hr_utility.set_location(' L_DATE_TRACK_MODE : ' || L_DATE_TRACK_MODE, 20);

2530: ,P_BASE_KEY_COLUMN => 'ASSIGNMENT_ID'
2531: ,P_BASE_KEY_VALUE => L_Assignment_id);
2532:
2533: if g_debug then
2534: hr_utility.set_location(' L_DATE_TRACK_MODE : ' || L_DATE_TRACK_MODE, 20);
2535: End If;
2536:
2537: If Nvl(l_DFLT_STEP_CD,'XX') = 'NOSTEP' Then
2538: Open Plcmt_Dtls(l_Assignment_Id, l_Enrt_Cvg_Strt_Dt);

Line 2627: hr_utility.set_location(' Leaving Assigmt Updates ', 30);

2623: End If;
2624: Close Step_Dtls;
2625:
2626: if g_debug then
2627: hr_utility.set_location(' Leaving Assigmt Updates ', 30);
2628: End If;
2629:
2630: End If;
2631: Exception

Line 2635: hr_utility.set_location(' Error ', 40);

2631: Exception
2632: When Others then
2633:
2634: if g_debug then
2635: hr_utility.set_location(' Error ', 40);
2636: End if;
2637:
2638: Raise;
2639: End Update_Assgmt_Info;

Line 2731: hr_utility.set_location(' Inside Apprival UI Call ' , 10);

2727: Loop
2728: Begin
2729:
2730: if g_debug then
2731: hr_utility.set_location(' Inside Apprival UI Call ' , 10);
2732: hr_utility.set_location(' Elctbl_Chc_Id : ' || Elctbl_Rec.ELIG_PER_ELCTBL_CHC_ID, 20);
2733: End if;
2734:
2735: Savepoint Start_Enrlmnt;

Line 2732: hr_utility.set_location(' Elctbl_Chc_Id : ' || Elctbl_Rec.ELIG_PER_ELCTBL_CHC_ID, 20);

2728: Begin
2729:
2730: if g_debug then
2731: hr_utility.set_location(' Inside Apprival UI Call ' , 10);
2732: hr_utility.set_location(' Elctbl_Chc_Id : ' || Elctbl_Rec.ELIG_PER_ELCTBL_CHC_ID, 20);
2733: End if;
2734:
2735: Savepoint Start_Enrlmnt;
2736: /* Start Enrollment process */

Line 2751: hr_utility.set_location(' Approve ', 30);

2747: If Elctbl_Rec.Approval_Status_Cd = 'PQH_GSP_A' Then
2748:
2749: /* Update Employee Salary */
2750: if g_debug then
2751: hr_utility.set_location(' Approve ', 30);
2752: end if;
2753:
2754: pqh_gsp_Post_Process.Update_Assgmt_Info
2755: (P_ELIG_PER_ELCTBL_CHC_ID => Elctbl_Rec.ELIG_PER_ELCTBL_CHC_ID

Line 2759: hr_utility.set_location(' Update Salary ', 40);

2755: (P_ELIG_PER_ELCTBL_CHC_ID => Elctbl_Rec.ELIG_PER_ELCTBL_CHC_ID
2756: ,P_Effective_Date => Elctbl_Rec.Enrt_Cvg_Strt_Dt);
2757:
2758: if g_debug then
2759: hr_utility.set_location(' Update Salary ', 40);
2760: End If;
2761:
2762: /* If Update_Salary_Cd is NO_UPDATE -- Salary Updateis not required.
2763: Hence will not make a call to Salary Update */

Line 2814: hr_utility.set_location(' Error in AUI ', 50);

2810: Rollback to Start_Enrlmnt;
2811: l_Error_Exists := 'Y';
2812: -- l_Error_Message := Fnd_Message.Get;
2813: if g_debug then
2814: hr_utility.set_location(' Error in AUI ', 50);
2815: hr_utility.set_location(' Error : ' || l_Error_Message, 60);
2816: End If;
2817:
2818: Pqh_Gsp_process_Log.Log_process_Dtls

Line 2815: hr_utility.set_location(' Error : ' || l_Error_Message, 60);

2811: l_Error_Exists := 'Y';
2812: -- l_Error_Message := Fnd_Message.Get;
2813: if g_debug then
2814: hr_utility.set_location(' Error in AUI ', 50);
2815: hr_utility.set_location(' Error : ' || l_Error_Message, 60);
2816: End If;
2817:
2818: Pqh_Gsp_process_Log.Log_process_Dtls
2819: (P_Master_txn_Id => L_Concurrent_Req_Id

Line 2981: hr_utility.set_location(' Entering get_persons_gl_and_grade', 10);

2977: l_grade_plip ben_plip_f.plip_id%type := NULL;
2978: --
2979: Begin
2980: --
2981: hr_utility.set_location(' Entering get_persons_gl_and_grade', 10);
2982: p_persons_pgm_id := NULL;
2983: p_persons_plip_id := NULL;
2984: p_prog_style := NULL;
2985: --

Line 2995: hr_utility.set_location(' No grade ladder on assignment', 20);

2991: --
2992: -- No grade ladder on assignment.
2993: If l_asg_gl is null then
2994: --
2995: hr_utility.set_location(' No grade ladder on assignment', 20);
2996: Open csr_get_default_gl;
2997: Fetch csr_get_default_gl into l_def_gl,l_dflt_step_cd;
2998: Close csr_get_default_gl;
2999: --

Line 3002: hr_utility.set_location(' Default GL found: '||to_char(l_def_gl), 30);

2998: Close csr_get_default_gl;
2999: --
3000: If l_def_gl IS NOT NULL then
3001: -- Default found. check if the persons grade belongs to the default GL.
3002: hr_utility.set_location(' Default GL found: '||to_char(l_def_gl), 30);
3003: If l_asg_grade IS NOT NULL then
3004: -- Find the plan corresponding to the grade and check if it belongs to the pgm.
3005: hr_utility.set_location('Assignment has grade:'||to_char(l_asg_grade), 40);
3006: Open csr_grade_pl(l_asg_grade);

Line 3005: hr_utility.set_location('Assignment has grade:'||to_char(l_asg_grade), 40);

3001: -- Default found. check if the persons grade belongs to the default GL.
3002: hr_utility.set_location(' Default GL found: '||to_char(l_def_gl), 30);
3003: If l_asg_grade IS NOT NULL then
3004: -- Find the plan corresponding to the grade and check if it belongs to the pgm.
3005: hr_utility.set_location('Assignment has grade:'||to_char(l_asg_grade), 40);
3006: Open csr_grade_pl(l_asg_grade);
3007: Fetch csr_grade_pl into l_grade_pl;
3008: Close csr_grade_pl;
3009: -- Find the plip for the plan

Line 3012: hr_utility.set_location('Found plan for grade:'||to_char(l_grade_pl), 50);

3008: Close csr_grade_pl;
3009: -- Find the plip for the plan
3010: If l_grade_pl is not null then
3011: --
3012: hr_utility.set_location('Found plan for grade:'||to_char(l_grade_pl), 50);
3013: Open csr_grade_plip (p_pgm_id => l_def_gl,p_pl_id => l_grade_pl);
3014: Fetch csr_grade_plip into l_grade_plip;
3015: Close csr_grade_plip;
3016: --

Line 3019: hr_utility.set_location('plip for grade is linked to default GL', 60);

3015: Close csr_grade_plip;
3016: --
3017: If l_grade_plip is not null then
3018: --
3019: hr_utility.set_location('plip for grade is linked to default GL', 60);
3020: p_persons_pgm_id := l_def_gl;
3021: p_persons_plip_id := l_grade_plip;
3022: p_prog_style := l_dflt_step_cd;
3023: --

Line 3032: hr_utility.set_location('Person has grade ladder on assignment:'||to_char(l_asg_gl), 70);

3028: End if; /** l_def_gl IS NOT NULL **/
3029: --
3030: Else
3031: -- Persons assignment has a grade ladder.
3032: hr_utility.set_location('Person has grade ladder on assignment:'||to_char(l_asg_gl), 70);
3033: p_persons_pgm_id := l_asg_gl;
3034:
3035: If l_asg_grade is not null then
3036: -- Find the plan corresponding to the grade and check if it belongs to the pgm.

Line 3037: hr_utility.set_location('Assignment has grade:'||to_char(l_asg_grade), 80);

3033: p_persons_pgm_id := l_asg_gl;
3034:
3035: If l_asg_grade is not null then
3036: -- Find the plan corresponding to the grade and check if it belongs to the pgm.
3037: hr_utility.set_location('Assignment has grade:'||to_char(l_asg_grade), 80);
3038: Open csr_grade_pl(l_asg_grade);
3039: Fetch csr_grade_pl into l_grade_pl;
3040: Close csr_grade_pl;
3041: -- Find the plip for the plan

Line 3044: hr_utility.set_location('Found plan for grade:'|| to_char(l_grade_pl), 90);

3040: Close csr_grade_pl;
3041: -- Find the plip for the plan
3042: If l_grade_pl is not null then
3043: --
3044: hr_utility.set_location('Found plan for grade:'|| to_char(l_grade_pl), 90);
3045: Open csr_grade_plip (p_pgm_id => l_asg_gl,p_pl_id => l_grade_pl);
3046: Fetch csr_grade_plip into l_grade_plip;
3047: Close csr_grade_plip;
3048: --

Line 3051: hr_utility.set_location('plip for grade found:'|| to_char(l_grade_plip),100);

3047: Close csr_grade_plip;
3048: --
3049: If l_grade_plip is not null then
3050: --
3051: hr_utility.set_location('plip for grade found:'|| to_char(l_grade_plip),100);
3052: p_persons_plip_id := l_grade_plip;
3053: --
3054: Open csr_pgm_details(p_pgm_id => l_asg_gl);
3055: Fetch csr_pgm_details into l_dflt_step_cd;

Line 3066: hr_utility.set_location('Leaving get_persons_gl_and_grade',110);

3062: End if; /** If l_asg_grade is not null then **/
3063: --
3064: End if; /** If l_asg_gl is null then **/
3065: --
3066: hr_utility.set_location('Leaving get_persons_gl_and_grade',110);
3067: --
3068: End get_persons_gl_and_grade;
3069:
3070: /**************************************************************************/

Line 3261: g_debug := hr_utility.debug_enabled;

3257:
3258:
3259: Begin
3260:
3261: g_debug := hr_utility.debug_enabled;
3262: if g_debug then
3263: hr_utility.set_location(' Entering pqh_gsp_post_process.gsp_rate_sync ', 5);
3264: hr_utility.set_location(' Assgt_Id : ' || p_assignment_id, 10);
3265: hr_utility.set_location(' Person Id : ' || p_person_id, 20);

Line 3263: hr_utility.set_location(' Entering pqh_gsp_post_process.gsp_rate_sync ', 5);

3259: Begin
3260:
3261: g_debug := hr_utility.debug_enabled;
3262: if g_debug then
3263: hr_utility.set_location(' Entering pqh_gsp_post_process.gsp_rate_sync ', 5);
3264: hr_utility.set_location(' Assgt_Id : ' || p_assignment_id, 10);
3265: hr_utility.set_location(' Person Id : ' || p_person_id, 20);
3266: hr_utility.set_location(' Per_In_Ler_Id : ' || p_per_in_ler_id, 30);
3267: hr_utility.set_location(' Effective_Date : ' || P_Effective_Date, 40);

Line 3264: hr_utility.set_location(' Assgt_Id : ' || p_assignment_id, 10);

3260:
3261: g_debug := hr_utility.debug_enabled;
3262: if g_debug then
3263: hr_utility.set_location(' Entering pqh_gsp_post_process.gsp_rate_sync ', 5);
3264: hr_utility.set_location(' Assgt_Id : ' || p_assignment_id, 10);
3265: hr_utility.set_location(' Person Id : ' || p_person_id, 20);
3266: hr_utility.set_location(' Per_In_Ler_Id : ' || p_per_in_ler_id, 30);
3267: hr_utility.set_location(' Effective_Date : ' || P_Effective_Date, 40);
3268: End if;

Line 3265: hr_utility.set_location(' Person Id : ' || p_person_id, 20);

3261: g_debug := hr_utility.debug_enabled;
3262: if g_debug then
3263: hr_utility.set_location(' Entering pqh_gsp_post_process.gsp_rate_sync ', 5);
3264: hr_utility.set_location(' Assgt_Id : ' || p_assignment_id, 10);
3265: hr_utility.set_location(' Person Id : ' || p_person_id, 20);
3266: hr_utility.set_location(' Per_In_Ler_Id : ' || p_per_in_ler_id, 30);
3267: hr_utility.set_location(' Effective_Date : ' || P_Effective_Date, 40);
3268: End if;
3269:

Line 3266: hr_utility.set_location(' Per_In_Ler_Id : ' || p_per_in_ler_id, 30);

3262: if g_debug then
3263: hr_utility.set_location(' Entering pqh_gsp_post_process.gsp_rate_sync ', 5);
3264: hr_utility.set_location(' Assgt_Id : ' || p_assignment_id, 10);
3265: hr_utility.set_location(' Person Id : ' || p_person_id, 20);
3266: hr_utility.set_location(' Per_In_Ler_Id : ' || p_per_in_ler_id, 30);
3267: hr_utility.set_location(' Effective_Date : ' || P_Effective_Date, 40);
3268: End if;
3269:
3270: open per_in_ler_dtls;

Line 3267: hr_utility.set_location(' Effective_Date : ' || P_Effective_Date, 40);

3263: hr_utility.set_location(' Entering pqh_gsp_post_process.gsp_rate_sync ', 5);
3264: hr_utility.set_location(' Assgt_Id : ' || p_assignment_id, 10);
3265: hr_utility.set_location(' Person Id : ' || p_person_id, 20);
3266: hr_utility.set_location(' Per_In_Ler_Id : ' || p_per_in_ler_id, 30);
3267: hr_utility.set_location(' Effective_Date : ' || P_Effective_Date, 40);
3268: End if;
3269:
3270: open per_in_ler_dtls;
3271: fetch per_in_ler_dtls into L_Lee_Rsn_Id,l_Pgm_Id,l_bg_id;

Line 3274: hr_utility.set_location(' Ler_Id : ' || L_Lee_Rsn_Id, 50);

3270: open per_in_ler_dtls;
3271: fetch per_in_ler_dtls into L_Lee_Rsn_Id,l_Pgm_Id,l_bg_id;
3272: close per_in_ler_dtls;
3273: if g_debug then
3274: hr_utility.set_location(' Ler_Id : ' || L_Lee_Rsn_Id, 50);
3275: hr_utility.set_location(' Pgm Id : ' || l_pgm_id, 60);
3276: hr_utility.set_location(' bg_Id : ' || l_bg_id, 70);
3277: End if;
3278:

Line 3275: hr_utility.set_location(' Pgm Id : ' || l_pgm_id, 60);

3271: fetch per_in_ler_dtls into L_Lee_Rsn_Id,l_Pgm_Id,l_bg_id;
3272: close per_in_ler_dtls;
3273: if g_debug then
3274: hr_utility.set_location(' Ler_Id : ' || L_Lee_Rsn_Id, 50);
3275: hr_utility.set_location(' Pgm Id : ' || l_pgm_id, 60);
3276: hr_utility.set_location(' bg_Id : ' || l_bg_id, 70);
3277: End if;
3278:
3279: Open Person_Info;

Line 3276: hr_utility.set_location(' bg_Id : ' || l_bg_id, 70);

3272: close per_in_ler_dtls;
3273: if g_debug then
3274: hr_utility.set_location(' Ler_Id : ' || L_Lee_Rsn_Id, 50);
3275: hr_utility.set_location(' Pgm Id : ' || l_pgm_id, 60);
3276: hr_utility.set_location(' bg_Id : ' || l_bg_id, 70);
3277: End if;
3278:
3279: Open Person_Info;
3280: Fetch Person_Info Into L_BG_Id , L_Grade_Id, L_pay_basis_id, l_Pgm_Id;

Line 3284: hr_utility.set_location(' Pgm_Id : ' || l_Pgm_Id, 20);

3280: Fetch Person_Info Into L_BG_Id , L_Grade_Id, L_pay_basis_id, l_Pgm_Id;
3281: Close Person_Info;
3282:
3283: if g_debug then
3284: hr_utility.set_location(' Pgm_Id : ' || l_Pgm_Id, 20);
3285: hr_utility.set_location(' Pay_basis_Id : ' || l_pay_basis_id, 80);
3286: hr_utility.set_location(' Grade Id : ' || l_grade_id, 90);
3287: hr_utility.set_location(' bg_Id : ' || l_bg_id, 100);
3288: End if;

Line 3285: hr_utility.set_location(' Pay_basis_Id : ' || l_pay_basis_id, 80);

3281: Close Person_Info;
3282:
3283: if g_debug then
3284: hr_utility.set_location(' Pgm_Id : ' || l_Pgm_Id, 20);
3285: hr_utility.set_location(' Pay_basis_Id : ' || l_pay_basis_id, 80);
3286: hr_utility.set_location(' Grade Id : ' || l_grade_id, 90);
3287: hr_utility.set_location(' bg_Id : ' || l_bg_id, 100);
3288: End if;
3289:

Line 3286: hr_utility.set_location(' Grade Id : ' || l_grade_id, 90);

3282:
3283: if g_debug then
3284: hr_utility.set_location(' Pgm_Id : ' || l_Pgm_Id, 20);
3285: hr_utility.set_location(' Pay_basis_Id : ' || l_pay_basis_id, 80);
3286: hr_utility.set_location(' Grade Id : ' || l_grade_id, 90);
3287: hr_utility.set_location(' bg_Id : ' || l_bg_id, 100);
3288: End if;
3289:
3290: Open Ben_Grd_Dtls(l_Pgm_Id, L_Grade_Id);

Line 3287: hr_utility.set_location(' bg_Id : ' || l_bg_id, 100);

3283: if g_debug then
3284: hr_utility.set_location(' Pgm_Id : ' || l_Pgm_Id, 20);
3285: hr_utility.set_location(' Pay_basis_Id : ' || l_pay_basis_id, 80);
3286: hr_utility.set_location(' Grade Id : ' || l_grade_id, 90);
3287: hr_utility.set_location(' bg_Id : ' || l_bg_id, 100);
3288: End if;
3289:
3290: Open Ben_Grd_Dtls(l_Pgm_Id, L_Grade_Id);
3291: Fetch Ben_Grd_Dtls into L_Pl_id, l_plip_Id , l_Prog_style, L_Update_Salary_Cd, l_Dflt_Element_typ_Id;

Line 3362: hr_utility.set_location(' l_Pgm_Id ' || l_Pgm_Id, 50);

3358: Open Opt_Bas_rt(l_Opt_Id);
3359: Fetch Opt_Bas_Rt into l_ACTY_BASE_RT_ID, l_Rt_Typ_cd, l_Entr_Ann_Val_Flag;
3360: Close Opt_Bas_Rt;
3361: if g_debug then
3362: hr_utility.set_location(' l_Pgm_Id ' || l_Pgm_Id, 50);
3363: hr_utility.set_location(' L_Pl_id ' || L_Pl_id, 60);
3364: hr_utility.set_location(' l_Oipl_Id ' || l_Oipl_Id, 70);
3365: hr_utility.set_location(' L_Person_Id ' || p_Person_Id, 80);
3366: End if;

Line 3363: hr_utility.set_location(' L_Pl_id ' || L_Pl_id, 60);

3359: Fetch Opt_Bas_Rt into l_ACTY_BASE_RT_ID, l_Rt_Typ_cd, l_Entr_Ann_Val_Flag;
3360: Close Opt_Bas_Rt;
3361: if g_debug then
3362: hr_utility.set_location(' l_Pgm_Id ' || l_Pgm_Id, 50);
3363: hr_utility.set_location(' L_Pl_id ' || L_Pl_id, 60);
3364: hr_utility.set_location(' l_Oipl_Id ' || l_Oipl_Id, 70);
3365: hr_utility.set_location(' L_Person_Id ' || p_Person_Id, 80);
3366: End if;
3367: Else

Line 3364: hr_utility.set_location(' l_Oipl_Id ' || l_Oipl_Id, 70);

3360: Close Opt_Bas_Rt;
3361: if g_debug then
3362: hr_utility.set_location(' l_Pgm_Id ' || l_Pgm_Id, 50);
3363: hr_utility.set_location(' L_Pl_id ' || L_Pl_id, 60);
3364: hr_utility.set_location(' l_Oipl_Id ' || l_Oipl_Id, 70);
3365: hr_utility.set_location(' L_Person_Id ' || p_Person_Id, 80);
3366: End if;
3367: Else
3368:

Line 3365: hr_utility.set_location(' L_Person_Id ' || p_Person_Id, 80);

3361: if g_debug then
3362: hr_utility.set_location(' l_Pgm_Id ' || l_Pgm_Id, 50);
3363: hr_utility.set_location(' L_Pl_id ' || L_Pl_id, 60);
3364: hr_utility.set_location(' l_Oipl_Id ' || l_Oipl_Id, 70);
3365: hr_utility.set_location(' L_Person_Id ' || p_Person_Id, 80);
3366: End if;
3367: Else
3368:
3369: L_Elctbl_Flag := 'Y';

Line 3385: hr_utility.set_location(' Attempting to create Elig_per ', 140);

3381: /* Create Electable Choice Records */
3382: /* For Grade */
3383:
3384: if g_debug then
3385: hr_utility.set_location(' Attempting to create Elig_per ', 140);
3386: hr_utility.set_location(' Business_Group_Id :' || l_Bg_Id, 150);
3387: end if;
3388:
3389: Open Yr_Prd;

Line 3386: hr_utility.set_location(' Business_Group_Id :' || l_Bg_Id, 150);

3382: /* For Grade */
3383:
3384: if g_debug then
3385: hr_utility.set_location(' Attempting to create Elig_per ', 140);
3386: hr_utility.set_location(' Business_Group_Id :' || l_Bg_Id, 150);
3387: end if;
3388:
3389: Open Yr_Prd;
3390: Fetch Yr_Prd into l_Yr_Perd_Id;

Line 3420: hr_utility.set_location(' Created Elig_per for PLIP', 160);

3416: L_Rt_Elig_Per_Elctbl_Chc_Id := L_Elig_Per_Elctbl_Chc_Id;
3417:
3418:
3419: if g_debug then
3420: hr_utility.set_location(' Created Elig_per for PLIP', 160);
3421: hr_utility.set_location(' L_Elig_Per_Elctbl_Chc_Id : ' || L_Elig_Per_Elctbl_Chc_Id, 170);
3422: End If;
3423:
3424: elsif l_Prog_style in ('PQH_GSP_SP','PQH_GSP_GSP','MINSALINCR','MINSTEP','NOSTEP') Then

Line 3421: hr_utility.set_location(' L_Elig_Per_Elctbl_Chc_Id : ' || L_Elig_Per_Elctbl_Chc_Id, 170);

3417:
3418:
3419: if g_debug then
3420: hr_utility.set_location(' Created Elig_per for PLIP', 160);
3421: hr_utility.set_location(' L_Elig_Per_Elctbl_Chc_Id : ' || L_Elig_Per_Elctbl_Chc_Id, 170);
3422: End If;
3423:
3424: elsif l_Prog_style in ('PQH_GSP_SP','PQH_GSP_GSP','MINSALINCR','MINSTEP','NOSTEP') Then
3425:

Line 3450: hr_utility.set_location(' Created Elig_per for OIPL', 160);

3446: ,P_EFFECTIVE_DATE => P_Effective_Date);
3447:
3448: L_Rt_Elig_Per_Elctbl_Chc_Id := L_Oipl_Elig_Per_Elctbl_Chc_Id;
3449: if g_debug then
3450: hr_utility.set_location(' Created Elig_per for OIPL', 160);
3451: hr_utility.set_location(' L_Elig_Per_Elctbl_Chc_Id : ' || L_Elig_Per_Elctbl_Chc_Id, 170);
3452: End If;
3453:
3454: End If;

Line 3451: hr_utility.set_location(' L_Elig_Per_Elctbl_Chc_Id : ' || L_Elig_Per_Elctbl_Chc_Id, 170);

3447:
3448: L_Rt_Elig_Per_Elctbl_Chc_Id := L_Oipl_Elig_Per_Elctbl_Chc_Id;
3449: if g_debug then
3450: hr_utility.set_location(' Created Elig_per for OIPL', 160);
3451: hr_utility.set_location(' L_Elig_Per_Elctbl_Chc_Id : ' || L_Elig_Per_Elctbl_Chc_Id, 170);
3452: End If;
3453:
3454: End If;
3455: If L_Update_Salary_Cd is NULL Then

Line 3460: hr_utility.set_location(' Determine Rates ', 190);

3456: fnd_message.set_name('PQH','PQH_GSP_POSTSTYL_NOT_SET');
3457: fnd_message.raise_error;
3458: End If;
3459: if g_debug then
3460: hr_utility.set_location(' Determine Rates ', 190);
3461: End If;
3462:
3463: ben_env_object.init(p_business_group_id => l_Bg_Id,
3464: p_effective_date => P_Effective_Date,

Line 3645: g_debug := hr_utility.debug_enabled;

3641: l_gl_ann_factor ben_pgm_extra_info.pgi_information5%TYPE;
3642:
3643: Begin
3644:
3645: g_debug := hr_utility.debug_enabled;
3646: if g_debug then
3647: hr_utility.set_location(' Entering pqh_gsp_post_process.update_rate_sync_salary ', 5);
3648: hr_utility.set_location(' Per_In_Ler_Id : ' || p_per_in_ler_id, 10);
3649: hr_utility.set_location(' Effective_Date : ' || P_Effective_Date, 20);

Line 3647: hr_utility.set_location(' Entering pqh_gsp_post_process.update_rate_sync_salary ', 5);

3643: Begin
3644:
3645: g_debug := hr_utility.debug_enabled;
3646: if g_debug then
3647: hr_utility.set_location(' Entering pqh_gsp_post_process.update_rate_sync_salary ', 5);
3648: hr_utility.set_location(' Per_In_Ler_Id : ' || p_per_in_ler_id, 10);
3649: hr_utility.set_location(' Effective_Date : ' || P_Effective_Date, 20);
3650: End if;
3651:

Line 3648: hr_utility.set_location(' Per_In_Ler_Id : ' || p_per_in_ler_id, 10);

3644:
3645: g_debug := hr_utility.debug_enabled;
3646: if g_debug then
3647: hr_utility.set_location(' Entering pqh_gsp_post_process.update_rate_sync_salary ', 5);
3648: hr_utility.set_location(' Per_In_Ler_Id : ' || p_per_in_ler_id, 10);
3649: hr_utility.set_location(' Effective_Date : ' || P_Effective_Date, 20);
3650: End if;
3651:
3652:

Line 3649: hr_utility.set_location(' Effective_Date : ' || P_Effective_Date, 20);

3645: g_debug := hr_utility.debug_enabled;
3646: if g_debug then
3647: hr_utility.set_location(' Entering pqh_gsp_post_process.update_rate_sync_salary ', 5);
3648: hr_utility.set_location(' Per_In_Ler_Id : ' || p_per_in_ler_id, 10);
3649: hr_utility.set_location(' Effective_Date : ' || P_Effective_Date, 20);
3650: End if;
3651:
3652:
3653: for i in csr_elct_chcs loop

Line 3678: hr_utility.set_location(' Inside Salary Update: Elec_id :' ||l_def_elct_chc_id , 10);

3674: Fetch Enroll_Info into L_Enroll_Info;
3675: Close Enroll_Info;
3676:
3677: if g_debug then
3678: hr_utility.set_location(' Inside Salary Update: Elec_id :' ||l_def_elct_chc_id , 10);
3679: hr_utility.set_location(' L_Enroll_Info.Business_Group_Id :' || L_Enroll_Info.Business_Group_Id, 20);
3680: hr_utility.set_location(' L_Enroll_Info.OVN :' || L_Enroll_Info.Object_version_number, 30);
3681: End If;
3682:

Line 3679: hr_utility.set_location(' L_Enroll_Info.Business_Group_Id :' || L_Enroll_Info.Business_Group_Id, 20);

3675: Close Enroll_Info;
3676:
3677: if g_debug then
3678: hr_utility.set_location(' Inside Salary Update: Elec_id :' ||l_def_elct_chc_id , 10);
3679: hr_utility.set_location(' L_Enroll_Info.Business_Group_Id :' || L_Enroll_Info.Business_Group_Id, 20);
3680: hr_utility.set_location(' L_Enroll_Info.OVN :' || L_Enroll_Info.Object_version_number, 30);
3681: End If;
3682:
3683: open csr_pil_dtls;

Line 3680: hr_utility.set_location(' L_Enroll_Info.OVN :' || L_Enroll_Info.Object_version_number, 30);

3676:
3677: if g_debug then
3678: hr_utility.set_location(' Inside Salary Update: Elec_id :' ||l_def_elct_chc_id , 10);
3679: hr_utility.set_location(' L_Enroll_Info.Business_Group_Id :' || L_Enroll_Info.Business_Group_Id, 20);
3680: hr_utility.set_location(' L_Enroll_Info.OVN :' || L_Enroll_Info.Object_version_number, 30);
3681: End If;
3682:
3683: open csr_pil_dtls;
3684: fetch csr_pil_dtls into l_per_in_ler_ovn, l_PTNL_LER_FOR_PER_ID;

Line 3717: hr_utility.set_location('l_gl_ann_factor is:' ||l_gl_ann_factor , 40);

3713:
3714:
3715: l_gl_ann_factor := pqh_gsp_utility.get_gl_ann_factor(p_pgm_id => l_pgm_id);
3716:
3717: hr_utility.set_location('l_gl_ann_factor is:' ||l_gl_ann_factor , 40);
3718:
3719: if l_gl_ann_factor is not null then
3720:
3721: l_ANN_VAL :=L_Enroll_Info.Val *to_number(l_gl_ann_factor);

Line 3927: hr_utility.set_location(' Entering call_from_webadi',10);

3923: Where Elig_per_Elctbl_Chc_Id = P_Elig_Per_Elctbl_Chc_id;
3924:
3925: Begin
3926: if g_debug then
3927: hr_utility.set_location(' Entering call_from_webadi',10);
3928: hr_utility.set_location(' P_Elig_Per_Elctbl_Chc_id ' || P_Elig_Per_Elctbl_Chc_id, 20);
3929: hr_utility.set_location(' P_PROGRESSION_DATE ' || P_PROGRESSION_DATE,30);
3930: hr_utility.set_location(' P_Sal_Chg_Dt ' || P_Sal_Chg_Dt, 40);
3931: hr_utility.set_location(' p_assignment_id ' || p_assignment_id, 50);

Line 3928: hr_utility.set_location(' P_Elig_Per_Elctbl_Chc_id ' || P_Elig_Per_Elctbl_Chc_id, 20);

3924:
3925: Begin
3926: if g_debug then
3927: hr_utility.set_location(' Entering call_from_webadi',10);
3928: hr_utility.set_location(' P_Elig_Per_Elctbl_Chc_id ' || P_Elig_Per_Elctbl_Chc_id, 20);
3929: hr_utility.set_location(' P_PROGRESSION_DATE ' || P_PROGRESSION_DATE,30);
3930: hr_utility.set_location(' P_Sal_Chg_Dt ' || P_Sal_Chg_Dt, 40);
3931: hr_utility.set_location(' p_assignment_id ' || p_assignment_id, 50);
3932: hr_utility.set_location(' p_proposed_rank ' || p_proposed_rank, 60);

Line 3929: hr_utility.set_location(' P_PROGRESSION_DATE ' || P_PROGRESSION_DATE,30);

3925: Begin
3926: if g_debug then
3927: hr_utility.set_location(' Entering call_from_webadi',10);
3928: hr_utility.set_location(' P_Elig_Per_Elctbl_Chc_id ' || P_Elig_Per_Elctbl_Chc_id, 20);
3929: hr_utility.set_location(' P_PROGRESSION_DATE ' || P_PROGRESSION_DATE,30);
3930: hr_utility.set_location(' P_Sal_Chg_Dt ' || P_Sal_Chg_Dt, 40);
3931: hr_utility.set_location(' p_assignment_id ' || p_assignment_id, 50);
3932: hr_utility.set_location(' p_proposed_rank ' || p_proposed_rank, 60);
3933: hr_utility.set_location(' p_life_event_dt ' || p_life_event_dt,70);

Line 3930: hr_utility.set_location(' P_Sal_Chg_Dt ' || P_Sal_Chg_Dt, 40);

3926: if g_debug then
3927: hr_utility.set_location(' Entering call_from_webadi',10);
3928: hr_utility.set_location(' P_Elig_Per_Elctbl_Chc_id ' || P_Elig_Per_Elctbl_Chc_id, 20);
3929: hr_utility.set_location(' P_PROGRESSION_DATE ' || P_PROGRESSION_DATE,30);
3930: hr_utility.set_location(' P_Sal_Chg_Dt ' || P_Sal_Chg_Dt, 40);
3931: hr_utility.set_location(' p_assignment_id ' || p_assignment_id, 50);
3932: hr_utility.set_location(' p_proposed_rank ' || p_proposed_rank, 60);
3933: hr_utility.set_location(' p_life_event_dt ' || p_life_event_dt,70);
3934: hr_utility.set_location(' p_grade_ladder_id ' || p_grade_ladder_id, 80);

Line 3931: hr_utility.set_location(' p_assignment_id ' || p_assignment_id, 50);

3927: hr_utility.set_location(' Entering call_from_webadi',10);
3928: hr_utility.set_location(' P_Elig_Per_Elctbl_Chc_id ' || P_Elig_Per_Elctbl_Chc_id, 20);
3929: hr_utility.set_location(' P_PROGRESSION_DATE ' || P_PROGRESSION_DATE,30);
3930: hr_utility.set_location(' P_Sal_Chg_Dt ' || P_Sal_Chg_Dt, 40);
3931: hr_utility.set_location(' p_assignment_id ' || p_assignment_id, 50);
3932: hr_utility.set_location(' p_proposed_rank ' || p_proposed_rank, 60);
3933: hr_utility.set_location(' p_life_event_dt ' || p_life_event_dt,70);
3934: hr_utility.set_location(' p_grade_ladder_id ' || p_grade_ladder_id, 80);
3935: hr_utility.set_location(' p_pl_id ' || p_pl_id, 90);

Line 3932: hr_utility.set_location(' p_proposed_rank ' || p_proposed_rank, 60);

3928: hr_utility.set_location(' P_Elig_Per_Elctbl_Chc_id ' || P_Elig_Per_Elctbl_Chc_id, 20);
3929: hr_utility.set_location(' P_PROGRESSION_DATE ' || P_PROGRESSION_DATE,30);
3930: hr_utility.set_location(' P_Sal_Chg_Dt ' || P_Sal_Chg_Dt, 40);
3931: hr_utility.set_location(' p_assignment_id ' || p_assignment_id, 50);
3932: hr_utility.set_location(' p_proposed_rank ' || p_proposed_rank, 60);
3933: hr_utility.set_location(' p_life_event_dt ' || p_life_event_dt,70);
3934: hr_utility.set_location(' p_grade_ladder_id ' || p_grade_ladder_id, 80);
3935: hr_utility.set_location(' p_pl_id ' || p_pl_id, 90);
3936: hr_utility.set_location(' p_oipl_id ' || p_oipl_id, 100);

Line 3933: hr_utility.set_location(' p_life_event_dt ' || p_life_event_dt,70);

3929: hr_utility.set_location(' P_PROGRESSION_DATE ' || P_PROGRESSION_DATE,30);
3930: hr_utility.set_location(' P_Sal_Chg_Dt ' || P_Sal_Chg_Dt, 40);
3931: hr_utility.set_location(' p_assignment_id ' || p_assignment_id, 50);
3932: hr_utility.set_location(' p_proposed_rank ' || p_proposed_rank, 60);
3933: hr_utility.set_location(' p_life_event_dt ' || p_life_event_dt,70);
3934: hr_utility.set_location(' p_grade_ladder_id ' || p_grade_ladder_id, 80);
3935: hr_utility.set_location(' p_pl_id ' || p_pl_id, 90);
3936: hr_utility.set_location(' p_oipl_id ' || p_oipl_id, 100);
3937: End If;

Line 3934: hr_utility.set_location(' p_grade_ladder_id ' || p_grade_ladder_id, 80);

3930: hr_utility.set_location(' P_Sal_Chg_Dt ' || P_Sal_Chg_Dt, 40);
3931: hr_utility.set_location(' p_assignment_id ' || p_assignment_id, 50);
3932: hr_utility.set_location(' p_proposed_rank ' || p_proposed_rank, 60);
3933: hr_utility.set_location(' p_life_event_dt ' || p_life_event_dt,70);
3934: hr_utility.set_location(' p_grade_ladder_id ' || p_grade_ladder_id, 80);
3935: hr_utility.set_location(' p_pl_id ' || p_pl_id, 90);
3936: hr_utility.set_location(' p_oipl_id ' || p_oipl_id, 100);
3937: End If;
3938:

Line 3935: hr_utility.set_location(' p_pl_id ' || p_pl_id, 90);

3931: hr_utility.set_location(' p_assignment_id ' || p_assignment_id, 50);
3932: hr_utility.set_location(' p_proposed_rank ' || p_proposed_rank, 60);
3933: hr_utility.set_location(' p_life_event_dt ' || p_life_event_dt,70);
3934: hr_utility.set_location(' p_grade_ladder_id ' || p_grade_ladder_id, 80);
3935: hr_utility.set_location(' p_pl_id ' || p_pl_id, 90);
3936: hr_utility.set_location(' p_oipl_id ' || p_oipl_id, 100);
3937: End If;
3938:
3939: if p_progression_date < p_life_event_dt then

Line 3936: hr_utility.set_location(' p_oipl_id ' || p_oipl_id, 100);

3932: hr_utility.set_location(' p_proposed_rank ' || p_proposed_rank, 60);
3933: hr_utility.set_location(' p_life_event_dt ' || p_life_event_dt,70);
3934: hr_utility.set_location(' p_grade_ladder_id ' || p_grade_ladder_id, 80);
3935: hr_utility.set_location(' p_pl_id ' || p_pl_id, 90);
3936: hr_utility.set_location(' p_oipl_id ' || p_oipl_id, 100);
3937: End If;
3938:
3939: if p_progression_date < p_life_event_dt then
3940: fnd_message.set_name('PQH','PQH_GSP_APPRVL_PRGS_DT_CHK_ERR');

Line 3968: hr_utility.set_location(' Leaving call_from_webadi',10);

3964: Update Ben_Enrt_Rt
3965: Set Rt_Strt_Dt = P_Sal_Chg_Dt
3966: Where Enrt_Rt_Id = L_Enrt_Rt_Id;
3967: End If;
3968: hr_utility.set_location(' Leaving call_from_webadi',10);
3969: commit;
3970: exception when others then
3971: rollback;
3972: raise;