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

Line 5: g_debug boolean := hr_utility.debug_enabled;

1: Package Body BEN_CWB_WS_IMPORT_PKG as
2: /* $Header: bencwbwsim.pkb 120.23.12020000.3 2013/03/01 11:16:00 sgnanama ship $ */
3:
4: g_package Varchar2(30) := 'BEN_CWB_WS_IMPORT_PKG.';
5: g_debug boolean := hr_utility.debug_enabled;
6: TYPE g_iterface_seq_type is varray(6) of number;
7:
8: /*
9: This procedure is used by worksheet when rank is updated to

Line 45: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');

41: ,p_aei_information4 => p_level_number
42: ,p_assignment_extra_info_id => p_assignment_extra_info_id
43: ,p_object_version_number => p_object_version_number);
44: else
45: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
46: hr_utility.raise_error;
47: end if;
48:
49: end insert_new_rank;

Line 46: hr_utility.raise_error;

42: ,p_assignment_extra_info_id => p_assignment_extra_info_id
43: ,p_object_version_number => p_object_version_number);
44: else
45: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
46: hr_utility.raise_error;
47: end if;
48:
49: end insert_new_rank;
50: --

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

88:
89: BEGIN
90:
91: if g_debug then
92: hr_utility.set_location('Entering '||l_proc,10);
93: hr_utility.set_location('P_GROUP_PER_IN_LER_ID '||P_GROUP_PER_IN_LER_ID,20);
94: hr_utility.set_location('P_RANK '||P_RANK,30);
95: hr_utility.set_location('P_USER_ID '||P_USER_ID,35);
96: end if;

Line 93: hr_utility.set_location('P_GROUP_PER_IN_LER_ID '||P_GROUP_PER_IN_LER_ID,20);

89: BEGIN
90:
91: if g_debug then
92: hr_utility.set_location('Entering '||l_proc,10);
93: hr_utility.set_location('P_GROUP_PER_IN_LER_ID '||P_GROUP_PER_IN_LER_ID,20);
94: hr_utility.set_location('P_RANK '||P_RANK,30);
95: hr_utility.set_location('P_USER_ID '||P_USER_ID,35);
96: end if;
97:

Line 94: hr_utility.set_location('P_RANK '||P_RANK,30);

90:
91: if g_debug then
92: hr_utility.set_location('Entering '||l_proc,10);
93: hr_utility.set_location('P_GROUP_PER_IN_LER_ID '||P_GROUP_PER_IN_LER_ID,20);
94: hr_utility.set_location('P_RANK '||P_RANK,30);
95: hr_utility.set_location('P_USER_ID '||P_USER_ID,35);
96: end if;
97:
98: Open Csr_Assignment_ID;

Line 95: hr_utility.set_location('P_USER_ID '||P_USER_ID,35);

91: if g_debug then
92: hr_utility.set_location('Entering '||l_proc,10);
93: hr_utility.set_location('P_GROUP_PER_IN_LER_ID '||P_GROUP_PER_IN_LER_ID,20);
94: hr_utility.set_location('P_RANK '||P_RANK,30);
95: hr_utility.set_location('P_USER_ID '||P_USER_ID,35);
96: end if;
97:
98: Open Csr_Assignment_ID;
99: Fetch Csr_Assignment_ID into l_assignment_Id, l_lvl_num;

Line 103: hr_utility.set_location('l_assignment_Id '||l_assignment_Id,70);

99: Fetch Csr_Assignment_ID into l_assignment_Id, l_lvl_num;
100: Close Csr_Assignment_ID;
101:
102: if g_debug then
103: hr_utility.set_location('l_assignment_Id '||l_assignment_Id,70);
104: end if;
105:
106:
107: IF (l_assignment_Id IS NOT NULL) THEN

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

131:
132: END IF;
133:
134: if g_debug then
135: hr_utility.set_location('Leaving '||l_proc,100);
136: end if;
137:
138: END UPDATE_RANK;
139:

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

186: l_ws_rt_start_date DATE;
187: BEGIN
188:
189: if g_debug then
190: hr_utility.set_location('Entering '||l_proc,10);
191: hr_utility.set_location('P_PERSON_RATE_ID '||P_PERSON_RATE_ID,20);
192: hr_utility.set_location('P_WS_VAL '||l_WS_VAL,30);
193: hr_utility.set_location('P_USER_ID '||P_USER_ID,36);
194: end if;

Line 191: hr_utility.set_location('P_PERSON_RATE_ID '||P_PERSON_RATE_ID,20);

187: BEGIN
188:
189: if g_debug then
190: hr_utility.set_location('Entering '||l_proc,10);
191: hr_utility.set_location('P_PERSON_RATE_ID '||P_PERSON_RATE_ID,20);
192: hr_utility.set_location('P_WS_VAL '||l_WS_VAL,30);
193: hr_utility.set_location('P_USER_ID '||P_USER_ID,36);
194: end if;
195:

Line 192: hr_utility.set_location('P_WS_VAL '||l_WS_VAL,30);

188:
189: if g_debug then
190: hr_utility.set_location('Entering '||l_proc,10);
191: hr_utility.set_location('P_PERSON_RATE_ID '||P_PERSON_RATE_ID,20);
192: hr_utility.set_location('P_WS_VAL '||l_WS_VAL,30);
193: hr_utility.set_location('P_USER_ID '||P_USER_ID,36);
194: end if;
195:
196: IF (P_USER_ID IS NOT NULL) THEN

Line 193: hr_utility.set_location('P_USER_ID '||P_USER_ID,36);

189: if g_debug then
190: hr_utility.set_location('Entering '||l_proc,10);
191: hr_utility.set_location('P_PERSON_RATE_ID '||P_PERSON_RATE_ID,20);
192: hr_utility.set_location('P_WS_VAL '||l_WS_VAL,30);
193: hr_utility.set_location('P_USER_ID '||P_USER_ID,36);
194: end if;
195:
196: IF (P_USER_ID IS NOT NULL) THEN
197: l_USER_ID := BEN_CWB_WEBADI_UTILS.decrypt(P_USER_ID);

Line 198: hr_utility.set_location('l_USER_ID :'||l_USER_ID,45);

194: end if;
195:
196: IF (P_USER_ID IS NOT NULL) THEN
197: l_USER_ID := BEN_CWB_WEBADI_UTILS.decrypt(P_USER_ID);
198: hr_utility.set_location('l_USER_ID :'||l_USER_ID,45);
199: END IF;
200:
201: Open Csr_Person_Id(l_USER_ID);
202: Fetch Csr_Person_Id into l_person_id;

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

235: End if;
236: Close Csr_PlRt_Dtls;
237:
238: if g_debug then
239: hr_utility.set_location('Leaving '||l_proc,100);
240: end if;
241:
242: return l_diff;
243:

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

279: l_ovn Number;
280: l_lf_evt_ocrd_dt Date;
281: BEGIN
282:
283: hr_utility.set_location('Entering :'||l_proc,10);
284:
285: If P_PERSON_RATE_ID IS NOT NULL then
286: l_rate_id := P_PERSON_RATE_ID;
287: Elsif P_OPT1_PERSON_RATE_ID IS NOT NULL then

Line 297: hr_utility.set_location('l_rate_id :'||l_rate_id,20);

293: Elsif P_OPT4_PERSON_RATE_ID IS NOT NULL then
294: l_rate_id := P_OPT4_PERSON_RATE_ID;
295: End if;
296:
297: hr_utility.set_location('l_rate_id :'||l_rate_id,20);
298:
299: Open csr_person_rate_info(l_rate_id);
300: Fetch csr_person_rate_info into l_group_pl_id,l_lf_evt_ocrd_dt;
301: Close csr_person_rate_info;

Line 303: hr_utility.set_location('l_group_pl_id :'||l_group_pl_id,50);

299: Open csr_person_rate_info(l_rate_id);
300: Fetch csr_person_rate_info into l_group_pl_id,l_lf_evt_ocrd_dt;
301: Close csr_person_rate_info;
302:
303: hr_utility.set_location('l_group_pl_id :'||l_group_pl_id,50);
304: hr_utility.set_location('l_lf_evt_ocrd_dt :'||l_lf_evt_ocrd_dt,60);
305:
306:
307: Open csr_person_tasks_info(l_group_pl_id,l_lf_evt_ocrd_dt );

Line 304: hr_utility.set_location('l_lf_evt_ocrd_dt :'||l_lf_evt_ocrd_dt,60);

300: Fetch csr_person_rate_info into l_group_pl_id,l_lf_evt_ocrd_dt;
301: Close csr_person_rate_info;
302:
303: hr_utility.set_location('l_group_pl_id :'||l_group_pl_id,50);
304: hr_utility.set_location('l_lf_evt_ocrd_dt :'||l_lf_evt_ocrd_dt,60);
305:
306:
307: Open csr_person_tasks_info(l_group_pl_id,l_lf_evt_ocrd_dt );
308: Fetch csr_person_tasks_info into l_status_cd,l_ovn;

Line 311: hr_utility.set_location('l_status_cd :'||l_status_cd,70);

307: Open csr_person_tasks_info(l_group_pl_id,l_lf_evt_ocrd_dt );
308: Fetch csr_person_tasks_info into l_status_cd,l_ovn;
309: Close csr_person_tasks_info;
310:
311: hr_utility.set_location('l_status_cd :'||l_status_cd,70);
312: hr_utility.set_location('l_ovn :'||l_ovn,80);
313:
314: If l_status_cd = 'NS' then
315: BEN_CWB_PERSON_TASKS_API.update_person_task

Line 312: hr_utility.set_location('l_ovn :'||l_ovn,80);

308: Fetch csr_person_tasks_info into l_status_cd,l_ovn;
309: Close csr_person_tasks_info;
310:
311: hr_utility.set_location('l_status_cd :'||l_status_cd,70);
312: hr_utility.set_location('l_ovn :'||l_ovn,80);
313:
314: If l_status_cd = 'NS' then
315: BEN_CWB_PERSON_TASKS_API.update_person_task
316: ( p_group_per_in_ler_id => P_SEC_MGR_LER_ID

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

322: ,p_object_version_number => l_ovn
323: );
324: End If;
325:
326: hr_utility.set_location('Leaving :'||l_proc,100);
327:
328: END REFRESH_PERSON_TASKS;
329:
330: --

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

350:
351:
352: BEGIN
353:
354: hr_utility.set_location('Entering :'||l_proc,10);
355:
356: If P_PERSON_RATE_ID IS NOT NULL then
357: l_rate_id := P_PERSON_RATE_ID;
358: Elsif P_OPT1_PERSON_RATE_ID IS NOT NULL then

Line 368: hr_utility.set_location('l_rate_id :'||l_rate_id,20);

364: Elsif P_OPT4_PERSON_RATE_ID IS NOT NULL then
365: l_rate_id := P_OPT4_PERSON_RATE_ID;
366: End if;
367:
368: hr_utility.set_location('l_rate_id :'||l_rate_id,20);
369:
370: Open csr_group_per_in_ler_id(l_rate_id);
371: Fetch csr_group_per_in_ler_id into l_group_per_in_ler_id;
372: Close csr_group_per_in_ler_id;

Line 374: hr_utility.set_location('l_group_per_in_ler_id :'||l_group_per_in_ler_id,40);

370: Open csr_group_per_in_ler_id(l_rate_id);
371: Fetch csr_group_per_in_ler_id into l_group_per_in_ler_id;
372: Close csr_group_per_in_ler_id;
373:
374: hr_utility.set_location('l_group_per_in_ler_id :'||l_group_per_in_ler_id,40);
375: hr_utility.set_location('Leaving :'||l_proc,100);
376:
377: return l_group_per_in_ler_id;
378:

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

371: Fetch csr_group_per_in_ler_id into l_group_per_in_ler_id;
372: Close csr_group_per_in_ler_id;
373:
374: hr_utility.set_location('l_group_per_in_ler_id :'||l_group_per_in_ler_id,40);
375: hr_utility.set_location('Leaving :'||l_proc,100);
376:
377: return l_group_per_in_ler_id;
378:
379: End get_group_per_in_ler_id;

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

461: AND bcwg.cwb_wksht_grp_id = bcpt.task_id
462: AND bcwg.wksht_grp_cd = 'COMP';
463:
464: BEGIN
465: hr_utility.set_location('Entering :'||l_proc,10);
466:
467: l_group_per_in_ler_id := get_group_per_in_ler_id (P_PERSON_RATE_ID =>P_PERSON_RATE_ID
468: ,P_OPT1_PERSON_RATE_ID => P_OPT1_PERSON_RATE_ID
469: ,P_OPT2_PERSON_RATE_ID => P_OPT2_PERSON_RATE_ID

Line 473: hr_utility.set_location('l_group_per_in_ler_id :'||l_group_per_in_ler_id,40);

469: ,P_OPT2_PERSON_RATE_ID => P_OPT2_PERSON_RATE_ID
470: ,P_OPT3_PERSON_RATE_ID => P_OPT3_PERSON_RATE_ID
471: ,P_OPT4_PERSON_RATE_ID => P_OPT4_PERSON_RATE_ID);
472:
473: hr_utility.set_location('l_group_per_in_ler_id :'||l_group_per_in_ler_id,40);
474:
475: Open csr_PP_STAT_CD(l_group_per_in_ler_id);
476: Fetch csr_PP_STAT_CD into l_pp_stat_cd;
477: Close csr_PP_STAT_CD;

Line 479: hr_utility.set_location('l_pp_stat_cd :'||l_pp_stat_cd,50);

475: Open csr_PP_STAT_CD(l_group_per_in_ler_id);
476: Fetch csr_PP_STAT_CD into l_pp_stat_cd;
477: Close csr_PP_STAT_CD;
478:
479: hr_utility.set_location('l_pp_stat_cd :'||l_pp_stat_cd,50);
480:
481: if l_pp_stat_cd IS NOT NULL then
482: hr_utility.set_message(805,'BEN_93752_CWB_PROCESSES_EMP');
483: hr_utility.raise_error;

Line 482: hr_utility.set_message(805,'BEN_93752_CWB_PROCESSES_EMP');

478:
479: hr_utility.set_location('l_pp_stat_cd :'||l_pp_stat_cd,50);
480:
481: if l_pp_stat_cd IS NOT NULL then
482: hr_utility.set_message(805,'BEN_93752_CWB_PROCESSES_EMP');
483: hr_utility.raise_error;
484: End if;
485:
486: -- added by kmg for fixing bug#6830922

Line 483: hr_utility.raise_error;

479: hr_utility.set_location('l_pp_stat_cd :'||l_pp_stat_cd,50);
480:
481: if l_pp_stat_cd IS NOT NULL then
482: hr_utility.set_message(805,'BEN_93752_CWB_PROCESSES_EMP');
483: hr_utility.raise_error;
484: End if;
485:
486: -- added by kmg for fixing bug#6830922
487: OPEN csr_ws_stat_cd(p_mgr_per_in_ler_id);

Line 491: hr_utility.set_message(805,'BEN_94711_CWB_WS_SUBMITTED');

487: OPEN csr_ws_stat_cd(p_mgr_per_in_ler_id);
488: FETCH csr_ws_stat_cd INTO l_submit_cd;
489: CLOSE csr_ws_stat_cd;
490: IF NVL(l_submit_cd,'NS') = 'SU' THEN
491: hr_utility.set_message(805,'BEN_94711_CWB_WS_SUBMITTED');
492: hr_utility.raise_error;
493: END IF;
494:
495: FOR l_task_access IN c_task_access LOOP

Line 492: hr_utility.raise_error;

488: FETCH csr_ws_stat_cd INTO l_submit_cd;
489: CLOSE csr_ws_stat_cd;
490: IF NVL(l_submit_cd,'NS') = 'SU' THEN
491: hr_utility.set_message(805,'BEN_94711_CWB_WS_SUBMITTED');
492: hr_utility.raise_error;
493: END IF;
494:
495: FOR l_task_access IN c_task_access LOOP
496: IF nvl(l_task_access.accesscd,'UP') <> 'UP' THEN

Line 497: hr_utility.set_message(805,'BEN_92788_TASK_INACCESSIBLE');

493: END IF;
494:
495: FOR l_task_access IN c_task_access LOOP
496: IF nvl(l_task_access.accesscd,'UP') <> 'UP' THEN
497: hr_utility.set_message(805,'BEN_92788_TASK_INACCESSIBLE');
498: hr_utility.raise_error;
499: END IF;
500: END LOOP;
501:

Line 498: hr_utility.raise_error;

494:
495: FOR l_task_access IN c_task_access LOOP
496: IF nvl(l_task_access.accesscd,'UP') <> 'UP' THEN
497: hr_utility.set_message(805,'BEN_92788_TASK_INACCESSIBLE');
498: hr_utility.raise_error;
499: END IF;
500: END LOOP;
501:
502: hr_utility.trace('P_EMP_PER_IN_LER_ID:'||p_emp_per_in_ler_id); -- bug: 8996634

Line 502: hr_utility.trace('P_EMP_PER_IN_LER_ID:'||p_emp_per_in_ler_id); -- bug: 8996634

498: hr_utility.raise_error;
499: END IF;
500: END LOOP;
501:
502: hr_utility.trace('P_EMP_PER_IN_LER_ID:'||p_emp_per_in_ler_id); -- bug: 8996634
503: hr_utility.trace('P_MGR_PER_IN_LER_ID:'||p_mgr_per_in_ler_id);
504: IF p_emp_per_in_ler_id IS NOT NULL AND p_mgr_per_in_ler_id IS NOT NULL THEN
505: OPEN csr_chk_hrchy(p_mgr_per_in_ler_id,p_emp_per_in_ler_id);
506: FETCH csr_chk_hrchy INTO l_chk_hrchy;

Line 503: hr_utility.trace('P_MGR_PER_IN_LER_ID:'||p_mgr_per_in_ler_id);

499: END IF;
500: END LOOP;
501:
502: hr_utility.trace('P_EMP_PER_IN_LER_ID:'||p_emp_per_in_ler_id); -- bug: 8996634
503: hr_utility.trace('P_MGR_PER_IN_LER_ID:'||p_mgr_per_in_ler_id);
504: IF p_emp_per_in_ler_id IS NOT NULL AND p_mgr_per_in_ler_id IS NOT NULL THEN
505: OPEN csr_chk_hrchy(p_mgr_per_in_ler_id,p_emp_per_in_ler_id);
506: FETCH csr_chk_hrchy INTO l_chk_hrchy;
507: hr_utility.trace('Inside the loop:'||l_CHK_HRCHY);

Line 507: hr_utility.trace('Inside the loop:'||l_CHK_HRCHY);

503: hr_utility.trace('P_MGR_PER_IN_LER_ID:'||p_mgr_per_in_ler_id);
504: IF p_emp_per_in_ler_id IS NOT NULL AND p_mgr_per_in_ler_id IS NOT NULL THEN
505: OPEN csr_chk_hrchy(p_mgr_per_in_ler_id,p_emp_per_in_ler_id);
506: FETCH csr_chk_hrchy INTO l_chk_hrchy;
507: hr_utility.trace('Inside the loop:'||l_CHK_HRCHY);
508: CLOSE csr_chk_hrchy;
509: IF NVL(l_chk_hrchy,'N') = 'N' THEN
510: --- Create a new error message for this case
511: hr_utility.trace('KMG_CHANGES: NOT IN HIERARCHY, RAISE ERROR');

Line 511: hr_utility.trace('KMG_CHANGES: NOT IN HIERARCHY, RAISE ERROR');

507: hr_utility.trace('Inside the loop:'||l_CHK_HRCHY);
508: CLOSE csr_chk_hrchy;
509: IF NVL(l_chk_hrchy,'N') = 'N' THEN
510: --- Create a new error message for this case
511: hr_utility.trace('KMG_CHANGES: NOT IN HIERARCHY, RAISE ERROR');
512: hr_utility.set_message(805,'BEN_94723_CWB_EMP_NOT_HRCHY');
513: hr_utility.raise_error;
514: END IF;
515: END IF;

Line 512: hr_utility.set_message(805,'BEN_94723_CWB_EMP_NOT_HRCHY');

508: CLOSE csr_chk_hrchy;
509: IF NVL(l_chk_hrchy,'N') = 'N' THEN
510: --- Create a new error message for this case
511: hr_utility.trace('KMG_CHANGES: NOT IN HIERARCHY, RAISE ERROR');
512: hr_utility.set_message(805,'BEN_94723_CWB_EMP_NOT_HRCHY');
513: hr_utility.raise_error;
514: END IF;
515: END IF;
516:

Line 513: hr_utility.raise_error;

509: IF NVL(l_chk_hrchy,'N') = 'N' THEN
510: --- Create a new error message for this case
511: hr_utility.trace('KMG_CHANGES: NOT IN HIERARCHY, RAISE ERROR');
512: hr_utility.set_message(805,'BEN_94723_CWB_EMP_NOT_HRCHY');
513: hr_utility.raise_error;
514: END IF;
515: END IF;
516:
517: hr_utility.set_location('Leaving :'||l_proc,200);

Line 517: hr_utility.set_location('Leaving :'||l_proc,200);

513: hr_utility.raise_error;
514: END IF;
515: END IF;
516:
517: hr_utility.set_location('Leaving :'||l_proc,200);
518: END chk_processed_emp;
519:
520:
521:

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

575: l_person_perf Csr_person_perf%ROWTYPE;
576: l_changed varchar2(2) := 'N';
577:
578: Begin
579: hr_utility.set_location('Entering :'||l_proc,10);
580: --If P_PROPOSED_PERFORMANCE_RATING IS NOT NULL Then
581: l_group_per_in_ler_id := get_group_per_in_ler_id (P_PERSON_RATE_ID =>P_PERSON_RATE_ID
582: ,P_OPT1_PERSON_RATE_ID => P_OPT1_PERSON_RATE_ID
583: ,P_OPT2_PERSON_RATE_ID => P_OPT2_PERSON_RATE_ID

Line 587: hr_utility.set_location('l_group_per_in_ler_id :'||l_group_per_in_ler_id,40);

583: ,P_OPT2_PERSON_RATE_ID => P_OPT2_PERSON_RATE_ID
584: ,P_OPT3_PERSON_RATE_ID => P_OPT3_PERSON_RATE_ID
585: ,P_OPT4_PERSON_RATE_ID => P_OPT4_PERSON_RATE_ID);
586:
587: hr_utility.set_location('l_group_per_in_ler_id :'||l_group_per_in_ler_id,40);
588: open c_assgn_perf_rating_prcd(l_group_per_in_ler_id);
589: fetch c_assgn_perf_rating_prcd into l_assgn_perf_rating_prcd;
590: close c_assgn_perf_rating_prcd;
591:

Line 596: hr_utility.set_location('l_person_info.Assignment_id :'||l_person_info.Assignment_id,70);

592: Open csr_person_info(l_group_per_in_ler_id);
593: Fetch csr_person_info into l_person_info;
594: Close csr_person_info;
595:
596: hr_utility.set_location('l_person_info.Assignment_id :'||l_person_info.Assignment_id,70);
597: hr_utility.set_location('l_person_info.Person_id :'||l_person_info.Person_id,80);
598: hr_utility.set_location('l_person_info.business_group_id :'||l_person_info.business_group_id,90);
599: hr_utility.set_location('l_person_info.Person_name :'||l_person_info.Person_name,100);
600:

Line 597: hr_utility.set_location('l_person_info.Person_id :'||l_person_info.Person_id,80);

593: Fetch csr_person_info into l_person_info;
594: Close csr_person_info;
595:
596: hr_utility.set_location('l_person_info.Assignment_id :'||l_person_info.Assignment_id,70);
597: hr_utility.set_location('l_person_info.Person_id :'||l_person_info.Person_id,80);
598: hr_utility.set_location('l_person_info.business_group_id :'||l_person_info.business_group_id,90);
599: hr_utility.set_location('l_person_info.Person_name :'||l_person_info.Person_name,100);
600:
601: Open Csr_pl_dsgn_info(l_group_per_in_ler_id);

Line 598: hr_utility.set_location('l_person_info.business_group_id :'||l_person_info.business_group_id,90);

594: Close csr_person_info;
595:
596: hr_utility.set_location('l_person_info.Assignment_id :'||l_person_info.Assignment_id,70);
597: hr_utility.set_location('l_person_info.Person_id :'||l_person_info.Person_id,80);
598: hr_utility.set_location('l_person_info.business_group_id :'||l_person_info.business_group_id,90);
599: hr_utility.set_location('l_person_info.Person_name :'||l_person_info.Person_name,100);
600:
601: Open Csr_pl_dsgn_info(l_group_per_in_ler_id);
602: Fetch Csr_pl_dsgn_info into l_pl_dsgn_info;

Line 599: hr_utility.set_location('l_person_info.Person_name :'||l_person_info.Person_name,100);

595:
596: hr_utility.set_location('l_person_info.Assignment_id :'||l_person_info.Assignment_id,70);
597: hr_utility.set_location('l_person_info.Person_id :'||l_person_info.Person_id,80);
598: hr_utility.set_location('l_person_info.business_group_id :'||l_person_info.business_group_id,90);
599: hr_utility.set_location('l_person_info.Person_name :'||l_person_info.Person_name,100);
600:
601: Open Csr_pl_dsgn_info(l_group_per_in_ler_id);
602: Fetch Csr_pl_dsgn_info into l_pl_dsgn_info;
603: Close Csr_pl_dsgn_info;

Line 609: hr_utility.set_location('l_pl_dsgn_info.EMP_INTERVIEW_TYP_CD :'||l_pl_dsgn_info.EMP_INTERVIEW_TYP_CD,120);

605: Open Csr_person_perf(l_person_info.Assignment_id, l_pl_dsgn_info.perf_revw_strt_dt, l_pl_dsgn_info.emp_interview_typ_cd);
606: Fetch Csr_person_perf into l_person_perf;
607: Close Csr_person_perf;
608:
609: hr_utility.set_location('l_pl_dsgn_info.EMP_INTERVIEW_TYP_CD :'||l_pl_dsgn_info.EMP_INTERVIEW_TYP_CD,120);
610: hr_utility.set_location('l_pl_dsgn_info.perf_revw_strt_dt :'||l_pl_dsgn_info.perf_revw_strt_dt,130);
611: hr_utility.set_location('P_PROPOSED_PERFORMANCE_RATING :'||P_PROPOSED_PERFORMANCE_RATING,130);
612: hr_utility.set_location('l_person_perf.rating :'||l_person_perf.rating,130);
613:

Line 610: hr_utility.set_location('l_pl_dsgn_info.perf_revw_strt_dt :'||l_pl_dsgn_info.perf_revw_strt_dt,130);

606: Fetch Csr_person_perf into l_person_perf;
607: Close Csr_person_perf;
608:
609: hr_utility.set_location('l_pl_dsgn_info.EMP_INTERVIEW_TYP_CD :'||l_pl_dsgn_info.EMP_INTERVIEW_TYP_CD,120);
610: hr_utility.set_location('l_pl_dsgn_info.perf_revw_strt_dt :'||l_pl_dsgn_info.perf_revw_strt_dt,130);
611: hr_utility.set_location('P_PROPOSED_PERFORMANCE_RATING :'||P_PROPOSED_PERFORMANCE_RATING,130);
612: hr_utility.set_location('l_person_perf.rating :'||l_person_perf.rating,130);
613:
614: --12560928: convert null to -1 before comparing

Line 611: hr_utility.set_location('P_PROPOSED_PERFORMANCE_RATING :'||P_PROPOSED_PERFORMANCE_RATING,130);

607: Close Csr_person_perf;
608:
609: hr_utility.set_location('l_pl_dsgn_info.EMP_INTERVIEW_TYP_CD :'||l_pl_dsgn_info.EMP_INTERVIEW_TYP_CD,120);
610: hr_utility.set_location('l_pl_dsgn_info.perf_revw_strt_dt :'||l_pl_dsgn_info.perf_revw_strt_dt,130);
611: hr_utility.set_location('P_PROPOSED_PERFORMANCE_RATING :'||P_PROPOSED_PERFORMANCE_RATING,130);
612: hr_utility.set_location('l_person_perf.rating :'||l_person_perf.rating,130);
613:
614: --12560928: convert null to -1 before comparing
615: IF(nvl(P_PROPOSED_PERFORMANCE_RATING,-1) <> nvl(l_person_perf.rating,-1)) THEN

Line 612: hr_utility.set_location('l_person_perf.rating :'||l_person_perf.rating,130);

608:
609: hr_utility.set_location('l_pl_dsgn_info.EMP_INTERVIEW_TYP_CD :'||l_pl_dsgn_info.EMP_INTERVIEW_TYP_CD,120);
610: hr_utility.set_location('l_pl_dsgn_info.perf_revw_strt_dt :'||l_pl_dsgn_info.perf_revw_strt_dt,130);
611: hr_utility.set_location('P_PROPOSED_PERFORMANCE_RATING :'||P_PROPOSED_PERFORMANCE_RATING,130);
612: hr_utility.set_location('l_person_perf.rating :'||l_person_perf.rating,130);
613:
614: --12560928: convert null to -1 before comparing
615: IF(nvl(P_PROPOSED_PERFORMANCE_RATING,-1) <> nvl(l_person_perf.rating,-1)) THEN
616: l_changed := 'Y';

Line 624: hr_utility.set_location('calling process_rating ',140);

620:
621: IF(l_assgn_perf_rating_prcd.new_perf_event_id IS NULL
622: AND l_assgn_perf_rating_prcd.new_perf_review_id IS NULL AND l_changed = 'Y') THEN
623:
624: hr_utility.set_location('calling process_rating ',140);
625: ben_cwb_asg_update.process_rating
626: (p_validate_data => 'Y'
627: ,p_assignment_id => l_person_info.Assignment_id
628: ,p_person_id => l_person_info.Person_id

Line 638: hr_utility.set_location('Already processed, so skip calling process_rating ',140);

634: ,p_update_person_id => P_ACTING_PERSON_ID
635: ,p_update_date => Sysdate
636: ,p_group_pl_id => l_pl_dsgn_info.group_pl_id);
637: ELSE
638: hr_utility.set_location('Already processed, so skip calling process_rating ',140);
639: IF(l_changed = 'Y') THEN
640: hr_utility.set_message(805,'BEN_94740_CWB_RATING_PRCSD');
641: hr_utility.raise_error;
642: END IF;

Line 640: hr_utility.set_message(805,'BEN_94740_CWB_RATING_PRCSD');

636: ,p_group_pl_id => l_pl_dsgn_info.group_pl_id);
637: ELSE
638: hr_utility.set_location('Already processed, so skip calling process_rating ',140);
639: IF(l_changed = 'Y') THEN
640: hr_utility.set_message(805,'BEN_94740_CWB_RATING_PRCSD');
641: hr_utility.raise_error;
642: END IF;
643: END IF;
644:

Line 641: hr_utility.raise_error;

637: ELSE
638: hr_utility.set_location('Already processed, so skip calling process_rating ',140);
639: IF(l_changed = 'Y') THEN
640: hr_utility.set_message(805,'BEN_94740_CWB_RATING_PRCSD');
641: hr_utility.raise_error;
642: END IF;
643: END IF;
644:
645: --End If;

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

642: END IF;
643: END IF;
644:
645: --End If;
646: hr_utility.set_location('Leaving :'||l_proc,100);
647: End update_perf_rating;
648:
649:
650: Procedure update_promotions(P_PROPOSED_JOB IN Varchar2

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

736: l_assgn_perf_rating_prcd c_assgn_perf_rating_prcd%ROWTYPE;
737: l_changed varchar2(2) := 'N';
738:
739: Begin
740: hr_utility.set_location('Entering :'||l_proc,10);
741: l_group_per_in_ler_id := get_group_per_in_ler_id (P_PERSON_RATE_ID =>P_PERSON_RATE_ID
742: ,P_OPT1_PERSON_RATE_ID => P_OPT1_PERSON_RATE_ID
743: ,P_OPT2_PERSON_RATE_ID => P_OPT2_PERSON_RATE_ID
744: ,P_OPT3_PERSON_RATE_ID => P_OPT3_PERSON_RATE_ID

Line 747: hr_utility.set_location('l_group_per_in_ler_id :'||l_group_per_in_ler_id,40);

743: ,P_OPT2_PERSON_RATE_ID => P_OPT2_PERSON_RATE_ID
744: ,P_OPT3_PERSON_RATE_ID => P_OPT3_PERSON_RATE_ID
745: ,P_OPT4_PERSON_RATE_ID => P_OPT4_PERSON_RATE_ID);
746:
747: hr_utility.set_location('l_group_per_in_ler_id :'||l_group_per_in_ler_id,40);
748:
749: open c_assgn_perf_rating_prcd(l_group_per_in_ler_id);
750: fetch c_assgn_perf_rating_prcd into l_assgn_perf_rating_prcd;
751: close c_assgn_perf_rating_prcd;

Line 757: hr_utility.set_location('l_person_info.Assignment_id :'||l_person_info.Assignment_id,70);

753: Open csr_person_info(l_group_per_in_ler_id);
754: Fetch csr_person_info into l_person_info;
755: Close csr_person_info;
756:
757: hr_utility.set_location('l_person_info.Assignment_id :'||l_person_info.Assignment_id,70);
758: hr_utility.set_location('l_person_info.Person_id :'||l_person_info.Person_id,80);
759: hr_utility.set_location('l_person_info.business_group_id :'||l_person_info.business_group_id,90);
760: hr_utility.set_location('l_person_info.Person_name :'||l_person_info.Person_name,100);
761:

Line 758: hr_utility.set_location('l_person_info.Person_id :'||l_person_info.Person_id,80);

754: Fetch csr_person_info into l_person_info;
755: Close csr_person_info;
756:
757: hr_utility.set_location('l_person_info.Assignment_id :'||l_person_info.Assignment_id,70);
758: hr_utility.set_location('l_person_info.Person_id :'||l_person_info.Person_id,80);
759: hr_utility.set_location('l_person_info.business_group_id :'||l_person_info.business_group_id,90);
760: hr_utility.set_location('l_person_info.Person_name :'||l_person_info.Person_name,100);
761:
762: Open Csr_pl_dsgn_info(l_group_per_in_ler_id);

Line 759: hr_utility.set_location('l_person_info.business_group_id :'||l_person_info.business_group_id,90);

755: Close csr_person_info;
756:
757: hr_utility.set_location('l_person_info.Assignment_id :'||l_person_info.Assignment_id,70);
758: hr_utility.set_location('l_person_info.Person_id :'||l_person_info.Person_id,80);
759: hr_utility.set_location('l_person_info.business_group_id :'||l_person_info.business_group_id,90);
760: hr_utility.set_location('l_person_info.Person_name :'||l_person_info.Person_name,100);
761:
762: Open Csr_pl_dsgn_info(l_group_per_in_ler_id);
763: Fetch Csr_pl_dsgn_info into l_pl_dsgn_info;

Line 760: hr_utility.set_location('l_person_info.Person_name :'||l_person_info.Person_name,100);

756:
757: hr_utility.set_location('l_person_info.Assignment_id :'||l_person_info.Assignment_id,70);
758: hr_utility.set_location('l_person_info.Person_id :'||l_person_info.Person_id,80);
759: hr_utility.set_location('l_person_info.business_group_id :'||l_person_info.business_group_id,90);
760: hr_utility.set_location('l_person_info.Person_name :'||l_person_info.Person_name,100);
761:
762: Open Csr_pl_dsgn_info(l_group_per_in_ler_id);
763: Fetch Csr_pl_dsgn_info into l_pl_dsgn_info;
764: Close Csr_pl_dsgn_info;

Line 770: hr_utility.set_location('l_pl_dsgn_info.EMP_INTERVIEW_TYP_CD :'||l_pl_dsgn_info.EMP_INTERVIEW_TYP_CD,120);

766: Open Csr_person_asg(l_person_info.Assignment_id, l_pl_dsgn_info.asg_updt_eff_date);
767: Fetch Csr_person_asg into l_person_asg;
768: Close Csr_person_asg;
769:
770: hr_utility.set_location('l_pl_dsgn_info.EMP_INTERVIEW_TYP_CD :'||l_pl_dsgn_info.EMP_INTERVIEW_TYP_CD,120);
771: hr_utility.set_location('l_pl_dsgn_info.ASG_UPDT_EFF_DATE :'||l_pl_dsgn_info.ASG_UPDT_EFF_DATE,130);
772:
773: if(P_PROPOSED_JOB = default_string) then
774: l_job_id := l_person_asg.job_id;

Line 771: hr_utility.set_location('l_pl_dsgn_info.ASG_UPDT_EFF_DATE :'||l_pl_dsgn_info.ASG_UPDT_EFF_DATE,130);

767: Fetch Csr_person_asg into l_person_asg;
768: Close Csr_person_asg;
769:
770: hr_utility.set_location('l_pl_dsgn_info.EMP_INTERVIEW_TYP_CD :'||l_pl_dsgn_info.EMP_INTERVIEW_TYP_CD,120);
771: hr_utility.set_location('l_pl_dsgn_info.ASG_UPDT_EFF_DATE :'||l_pl_dsgn_info.ASG_UPDT_EFF_DATE,130);
772:
773: if(P_PROPOSED_JOB = default_string) then
774: l_job_id := l_person_asg.job_id;
775: else

Line 780: hr_utility.set_location('l_job_id :'|| l_job_id,130);

776: open c_job (l_person_info.business_group_id);
777: fetch c_job into l_job_id;
778: close c_job;
779: end if;
780: hr_utility.set_location('l_job_id :'|| l_job_id,130);
781: if(P_PROPOSED_POSITION = default_string) then
782: l_pos_id := l_person_asg.position_id;
783: else
784: open c_position (l_person_info.business_group_id);

Line 788: hr_utility.set_location('l_pos_id :'|| l_pos_id,130);

784: open c_position (l_person_info.business_group_id);
785: fetch c_position into l_pos_id;
786: close c_position;
787: end if;
788: hr_utility.set_location('l_pos_id :'|| l_pos_id,130);
789: if(P_PROPOSED_GRADE = default_string) then
790: l_grade_id := l_person_asg.grade_id;
791: else
792: open c_grade(l_person_info.business_group_id);

Line 796: hr_utility.set_location('l_grade_id :'|| l_grade_id,130);

792: open c_grade(l_person_info.business_group_id);
793: fetch c_grade into l_grade_id;
794: close c_grade;
795: end if;
796: hr_utility.set_location('l_grade_id :'|| l_grade_id,130);
797: if(P_CHANGE_REASON = default_string) then
798: l_change_reason := l_person_asg.change_reason;
799: end if;
800: --12560928: convert null to -1 before comparing

Line 815: hr_utility.set_message(805,'BEN_93191_PROMO_EFFDT_NOT_DFND');

811: IF(nvl(P_PROPOSED_JOB,-1) <> default_string or nvl(P_PROPOSED_POSITION,-1) <> default_string or
812: nvl(P_PROPOSED_GRADE,-1) <> default_string or nvl(P_CHANGE_REASON,-1) <> default_string ) THEN
813: -- 8925417
814: if(l_pl_dsgn_info.asg_updt_eff_date is null) then
815: hr_utility.set_message(805,'BEN_93191_PROMO_EFFDT_NOT_DFND');
816: hr_utility.raise_error;
817: end if;
818: END IF;
819: hr_utility.set_location('calling process_promotions ',140);

Line 816: hr_utility.raise_error;

812: nvl(P_PROPOSED_GRADE,-1) <> default_string or nvl(P_CHANGE_REASON,-1) <> default_string ) THEN
813: -- 8925417
814: if(l_pl_dsgn_info.asg_updt_eff_date is null) then
815: hr_utility.set_message(805,'BEN_93191_PROMO_EFFDT_NOT_DFND');
816: hr_utility.raise_error;
817: end if;
818: END IF;
819: hr_utility.set_location('calling process_promotions ',140);
820: ben_cwb_asg_update.process_promotions

Line 819: hr_utility.set_location('calling process_promotions ',140);

815: hr_utility.set_message(805,'BEN_93191_PROMO_EFFDT_NOT_DFND');
816: hr_utility.raise_error;
817: end if;
818: END IF;
819: hr_utility.set_location('calling process_promotions ',140);
820: ben_cwb_asg_update.process_promotions
821: (p_validate_data => 'Y'
822: ,p_assignment_id => l_person_info.Assignment_id
823: ,p_person_id => l_person_info.Person_id

Line 867: hr_utility.set_location('Already processed, so skip calling process_promotions ',140);

863: ,p_update_person_id => P_ACTING_PERSON_ID
864: ,p_update_date => Sysdate
865: ,p_group_pl_id => l_pl_dsgn_info.group_pl_id);
866: ELSE
867: hr_utility.set_location('Already processed, so skip calling process_promotions ',140);
868: IF(l_changed = 'Y') THEN
869: hr_utility.set_message(805,'BEN_94741_CWB_ASSGMT_PRCSD');
870: hr_utility.raise_error;
871: END IF;

Line 869: hr_utility.set_message(805,'BEN_94741_CWB_ASSGMT_PRCSD');

865: ,p_group_pl_id => l_pl_dsgn_info.group_pl_id);
866: ELSE
867: hr_utility.set_location('Already processed, so skip calling process_promotions ',140);
868: IF(l_changed = 'Y') THEN
869: hr_utility.set_message(805,'BEN_94741_CWB_ASSGMT_PRCSD');
870: hr_utility.raise_error;
871: END IF;
872: END IF;
873:

Line 870: hr_utility.raise_error;

866: ELSE
867: hr_utility.set_location('Already processed, so skip calling process_promotions ',140);
868: IF(l_changed = 'Y') THEN
869: hr_utility.set_message(805,'BEN_94741_CWB_ASSGMT_PRCSD');
870: hr_utility.raise_error;
871: END IF;
872: END IF;
873:
874: --End If;

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

871: END IF;
872: END IF;
873:
874: --End If;
875: hr_utility.set_location('Leaving :'||l_proc,100);
876: End update_promotions;
877:
878: --
879: procedure update_other_rates (P_PERSON_RATE_ID IN NUMBER

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

929:
930: BEGIN
931:
932: if g_debug then
933: hr_utility.set_location('Entering '||l_proc,10);
934: hr_utility.set_location('P_PERSON_RATE_ID '||P_PERSON_RATE_ID,20);
935: end if;
936:
937: for l_upd_rec in Csr_PlRt_Dtls loop

Line 934: hr_utility.set_location('P_PERSON_RATE_ID '||P_PERSON_RATE_ID,20);

930: BEGIN
931:
932: if g_debug then
933: hr_utility.set_location('Entering '||l_proc,10);
934: hr_utility.set_location('P_PERSON_RATE_ID '||P_PERSON_RATE_ID,20);
935: end if;
936:
937: for l_upd_rec in Csr_PlRt_Dtls loop
938: p_final_values(1) := l_upd_rec.STAT_SAL_VAL;

Line 947: hr_utility.set_location(l_proc,20);

943: p_final_values(6) := l_upd_rec.MISC3_VAL;
944: end loop;
945:
946: if g_debug then
947: hr_utility.set_location(l_proc,20);
948: end if;
949:
950: for l_upd_rec in Csr_PlRt_Dtls loop
951: for l_is_read_only in csr_is_read_only(p_interface_seq(1),p_interface_seq(2),p_interface_seq(3),

Line 969: hr_utility.set_location(l_proc,30);

965: p_final_values(6) := round_number( check_number_col_avble(l_upd_rec.MISC3_VAL,p_values(6) ), l_upd_rec.m3_rndg_cd );
966: END IF;
967: end loop;
968: if g_debug then
969: hr_utility.set_location(l_proc,30);
970: end if;
971: BEN_CWB_PERSON_RATES_API.update_person_rate
972: ( p_group_per_in_ler_id => l_upd_rec.GROUP_PER_IN_LER_ID
973: ,p_pl_id => l_upd_rec.PL_ID

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

985: );
986: end loop;
987:
988: if g_debug then
989: hr_utility.set_location('Leaving '||l_proc,100);
990: end if;
991:
992: END update_other_rates;
993:

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

1443:
1444: BEGIN
1445:
1446: If g_debug then
1447: hr_utility.set_location('Entering '||l_proc,10);
1448: End if;
1449:
1450: --Clear message
1451: hr_utility.clear_message;

Line 1451: hr_utility.clear_message;

1447: hr_utility.set_location('Entering '||l_proc,10);
1448: End if;
1449:
1450: --Clear message
1451: hr_utility.clear_message;
1452:
1453: -- Issue Savepoint
1454: savepoint update_data;
1455: --

Line 1467: hr_utility.set_message(805,'BEN_CWB_PL_OPT_NOT_EXISTS');

1463: AND P_P_OPT2_PERSON_RATE_ID IS NULL
1464: AND P_P_OPT3_PERSON_RATE_ID IS NULL
1465: AND P_P_OPT4_PERSON_RATE_ID IS NULL) THEN
1466:
1467: hr_utility.set_message(805,'BEN_CWB_PL_OPT_NOT_EXISTS');
1468: hr_utility.raise_error;
1469: END IF;
1470:
1471: IF (P_PL_PERSON_RATE_ID IS NOT NULL) THEN

Line 1468: hr_utility.raise_error;

1464: AND P_P_OPT3_PERSON_RATE_ID IS NULL
1465: AND P_P_OPT4_PERSON_RATE_ID IS NULL) THEN
1466:
1467: hr_utility.set_message(805,'BEN_CWB_PL_OPT_NOT_EXISTS');
1468: hr_utility.raise_error;
1469: END IF;
1470:
1471: IF (P_PL_PERSON_RATE_ID IS NOT NULL) THEN
1472: l_PL_PERSON_RATE_ID := BEN_CWB_WEBADI_UTILS.decrypt(P_PL_PERSON_RATE_ID);

Line 1474: hr_utility.set_location('l_PL_PERSON_RATE_ID :'||l_PL_PERSON_RATE_ID,20);

1470:
1471: IF (P_PL_PERSON_RATE_ID IS NOT NULL) THEN
1472: l_PL_PERSON_RATE_ID := BEN_CWB_WEBADI_UTILS.decrypt(P_PL_PERSON_RATE_ID);
1473: If g_debug then
1474: hr_utility.set_location('l_PL_PERSON_RATE_ID :'||l_PL_PERSON_RATE_ID,20);
1475: End if;
1476: END IF;
1477:
1478: IF (P_P_OPT1_PERSON_RATE_ID IS NOT NULL) THEN

Line 1481: hr_utility.set_location('l_OPT1_PERSON_RATE_ID :'||l_OPT1_PERSON_RATE_ID,30);

1477:
1478: IF (P_P_OPT1_PERSON_RATE_ID IS NOT NULL) THEN
1479: l_OPT1_PERSON_RATE_ID := BEN_CWB_WEBADI_UTILS.decrypt(P_P_OPT1_PERSON_RATE_ID);
1480: If g_debug then
1481: hr_utility.set_location('l_OPT1_PERSON_RATE_ID :'||l_OPT1_PERSON_RATE_ID,30);
1482: End if;
1483: END IF;
1484:
1485: IF (P_P_OPT2_PERSON_RATE_ID IS NOT NULL) THEN

Line 1488: hr_utility.set_location('l_OPT2_PERSON_RATE_ID :'||l_OPT2_PERSON_RATE_ID,40);

1484:
1485: IF (P_P_OPT2_PERSON_RATE_ID IS NOT NULL) THEN
1486: l_OPT2_PERSON_RATE_ID := BEN_CWB_WEBADI_UTILS.decrypt(P_P_OPT2_PERSON_RATE_ID);
1487: If g_debug then
1488: hr_utility.set_location('l_OPT2_PERSON_RATE_ID :'||l_OPT2_PERSON_RATE_ID,40);
1489: End if;
1490: END IF;
1491:
1492: IF (P_P_OPT3_PERSON_RATE_ID IS NOT NULL) THEN

Line 1495: hr_utility.set_location('l_OPT3_PERSON_RATE_ID :'||l_OPT3_PERSON_RATE_ID,50);

1491:
1492: IF (P_P_OPT3_PERSON_RATE_ID IS NOT NULL) THEN
1493: l_OPT3_PERSON_RATE_ID := BEN_CWB_WEBADI_UTILS.decrypt(P_P_OPT3_PERSON_RATE_ID);
1494: If g_debug then
1495: hr_utility.set_location('l_OPT3_PERSON_RATE_ID :'||l_OPT3_PERSON_RATE_ID,50);
1496: End if;
1497: END IF;
1498:
1499: IF (P_P_OPT4_PERSON_RATE_ID IS NOT NULL) THEN

Line 1502: hr_utility.set_location('l_OPT4_PERSON_RATE_ID :'||l_OPT4_PERSON_RATE_ID,60);

1498:
1499: IF (P_P_OPT4_PERSON_RATE_ID IS NOT NULL) THEN
1500: l_OPT4_PERSON_RATE_ID := BEN_CWB_WEBADI_UTILS.decrypt(P_P_OPT4_PERSON_RATE_ID);
1501: If g_debug then
1502: hr_utility.set_location('l_OPT4_PERSON_RATE_ID :'||l_OPT4_PERSON_RATE_ID,60);
1503: End if;
1504: END IF;
1505:
1506: IF (P_TASK_ID IS NOT NULL) THEN

Line 1509: hr_utility.set_location('l_TASK_ID :'||l_TASK_ID,65);

1505:
1506: IF (P_TASK_ID IS NOT NULL) THEN
1507: l_TASK_ID := BEN_CWB_WEBADI_UTILS.decrypt(P_TASK_ID);
1508: If g_debug then
1509: hr_utility.set_location('l_TASK_ID :'||l_TASK_ID,65);
1510: End if;
1511: END IF;
1512:
1513: IF (P_SEC_MGR_LER_ID IS NOT NULL) THEN

Line 1516: hr_utility.set_location('l_SEC_MGR_LER_ID :'||l_SEC_MGR_LER_ID,67);

1512:
1513: IF (P_SEC_MGR_LER_ID IS NOT NULL) THEN
1514: l_SEC_MGR_LER_ID := BEN_CWB_WEBADI_UTILS.decrypt(P_SEC_MGR_LER_ID);
1515: If g_debug then
1516: hr_utility.set_location('l_SEC_MGR_LER_ID :'||l_SEC_MGR_LER_ID,67);
1517: End if;
1518: END IF;
1519:
1520: IF (P_ACTING_PERSON_ID IS NOT NULL) THEN

Line 1523: hr_utility.set_location('P_ACTING_PERSON_ID :'||l_ACTING_PERSON_ID,68);

1519:
1520: IF (P_ACTING_PERSON_ID IS NOT NULL) THEN
1521: l_ACTING_PERSON_ID := BEN_CWB_WEBADI_UTILS.decrypt(P_ACTING_PERSON_ID);
1522: If g_debug then
1523: hr_utility.set_location('P_ACTING_PERSON_ID :'||l_ACTING_PERSON_ID,68);
1524: End if;
1525: END IF;
1526:
1527: -- Using hexadecimal to store the upload column availability information.

Line 1534: hr_utility.set_location('p_download_switch (Decrypted) :'||l_decrypt_switch,69);

1530: l_decrypt_switch := BEN_CWB_WEBADI_UTILS.decrypt(p_download_switch);
1531: l_download_switch := lpad(ben_cwb_webadi_utils.int2bin(ben_cwb_webadi_utils.hex2int(substr(l_decrypt_switch,1,7))),28,0);
1532: l_download_switch := nvl(l_download_switch || lpad(nvl(ben_cwb_webadi_utils.int2bin(ben_cwb_webadi_utils.hex2int(substr(rtrim(l_decrypt_switch),8,14))),'0'),28,0),'0');
1533: if g_debug then
1534: hr_utility.set_location('p_download_switch (Decrypted) :'||l_decrypt_switch,69);
1535: End if;
1536: l_download_switch := REPLACE(REPLACE(l_download_switch,'1','2'),'0','1');
1537: l_download_switch := substr(l_download_switch,2);
1538: if g_debug then

Line 1539: hr_utility.set_location('l_final_download_Switch :'||l_download_switch,70);

1535: End if;
1536: l_download_switch := REPLACE(REPLACE(l_download_switch,'1','2'),'0','1');
1537: l_download_switch := substr(l_download_switch,2);
1538: if g_debug then
1539: hr_utility.set_location('l_final_download_Switch :'||l_download_switch,70);
1540: End if;
1541: END IF;
1542:
1543: If g_debug then

Line 1544: hr_utility.set_location('P_PL_WS_VAL : '||P_PL_WS_VAL,75);

1540: End if;
1541: END IF;
1542:
1543: If g_debug then
1544: hr_utility.set_location('P_PL_WS_VAL : '||P_PL_WS_VAL,75);
1545: hr_utility.set_location('P_OPT1_WS_VAL : '||P_OPT1_WS_VAL,80);
1546: hr_utility.set_location('P_OPT2_WS_VAL : '||P_OPT2_WS_VAL,90);
1547: hr_utility.set_location('P_OPT3_WS_VAL : '||P_OPT3_WS_VAL,100);
1548: hr_utility.set_location('P_OPT4_WS_VAL : '||P_OPT4_WS_VAL,110);

Line 1545: hr_utility.set_location('P_OPT1_WS_VAL : '||P_OPT1_WS_VAL,80);

1541: END IF;
1542:
1543: If g_debug then
1544: hr_utility.set_location('P_PL_WS_VAL : '||P_PL_WS_VAL,75);
1545: hr_utility.set_location('P_OPT1_WS_VAL : '||P_OPT1_WS_VAL,80);
1546: hr_utility.set_location('P_OPT2_WS_VAL : '||P_OPT2_WS_VAL,90);
1547: hr_utility.set_location('P_OPT3_WS_VAL : '||P_OPT3_WS_VAL,100);
1548: hr_utility.set_location('P_OPT4_WS_VAL : '||P_OPT4_WS_VAL,110);
1549: End if;

Line 1546: hr_utility.set_location('P_OPT2_WS_VAL : '||P_OPT2_WS_VAL,90);

1542:
1543: If g_debug then
1544: hr_utility.set_location('P_PL_WS_VAL : '||P_PL_WS_VAL,75);
1545: hr_utility.set_location('P_OPT1_WS_VAL : '||P_OPT1_WS_VAL,80);
1546: hr_utility.set_location('P_OPT2_WS_VAL : '||P_OPT2_WS_VAL,90);
1547: hr_utility.set_location('P_OPT3_WS_VAL : '||P_OPT3_WS_VAL,100);
1548: hr_utility.set_location('P_OPT4_WS_VAL : '||P_OPT4_WS_VAL,110);
1549: End if;
1550:

Line 1547: hr_utility.set_location('P_OPT3_WS_VAL : '||P_OPT3_WS_VAL,100);

1543: If g_debug then
1544: hr_utility.set_location('P_PL_WS_VAL : '||P_PL_WS_VAL,75);
1545: hr_utility.set_location('P_OPT1_WS_VAL : '||P_OPT1_WS_VAL,80);
1546: hr_utility.set_location('P_OPT2_WS_VAL : '||P_OPT2_WS_VAL,90);
1547: hr_utility.set_location('P_OPT3_WS_VAL : '||P_OPT3_WS_VAL,100);
1548: hr_utility.set_location('P_OPT4_WS_VAL : '||P_OPT4_WS_VAL,110);
1549: End if;
1550:
1551:

Line 1548: hr_utility.set_location('P_OPT4_WS_VAL : '||P_OPT4_WS_VAL,110);

1544: hr_utility.set_location('P_PL_WS_VAL : '||P_PL_WS_VAL,75);
1545: hr_utility.set_location('P_OPT1_WS_VAL : '||P_OPT1_WS_VAL,80);
1546: hr_utility.set_location('P_OPT2_WS_VAL : '||P_OPT2_WS_VAL,90);
1547: hr_utility.set_location('P_OPT3_WS_VAL : '||P_OPT3_WS_VAL,100);
1548: hr_utility.set_location('P_OPT4_WS_VAL : '||P_OPT4_WS_VAL,110);
1549: End if;
1550:
1551:
1552: l_group_per_in_ler_id := get_group_per_in_ler_id(l_PL_PERSON_RATE_ID,

Line 1570: hr_utility.set_location('l_group_per_in_ler_id : '||l_group_per_in_ler_id,111);

1566: ,P_EMP_PER_IN_LER_ID => l_group_per_in_ler_id -- bug: 8996634
1567: ,P_MGR_PER_IN_LER_ID => l_SEC_MGR_LER_ID);
1568:
1569: If g_debug then
1570: hr_utility.set_location('l_group_per_in_ler_id : '||l_group_per_in_ler_id,111);
1571: End if;
1572:
1573: l_interfac_code := null;
1574: l_base_layout_code := null;

Line 1580: hr_utility.set_location('l_interfac_code : '||l_interfac_code,112);

1576: FOR l_custom_integrator in csr_custom_integrator (l_get_group_plan_info.group_pl_id, l_get_group_plan_info.lf_evt_ocrd_dt) loop
1577: l_interfac_code := l_custom_integrator.intf;
1578: l_base_layout_code := l_custom_integrator.base_layout;
1579: If g_debug then
1580: hr_utility.set_location('l_interfac_code : '||l_interfac_code,112);
1581: hr_utility.set_location('l_base_layout_code : '||l_base_layout_code,113);
1582: end if;
1583: END LOOP;
1584: END LOOP;

Line 1581: hr_utility.set_location('l_base_layout_code : '||l_base_layout_code,113);

1577: l_interfac_code := l_custom_integrator.intf;
1578: l_base_layout_code := l_custom_integrator.base_layout;
1579: If g_debug then
1580: hr_utility.set_location('l_interfac_code : '||l_interfac_code,112);
1581: hr_utility.set_location('l_base_layout_code : '||l_base_layout_code,113);
1582: end if;
1583: END LOOP;
1584: END LOOP;
1585:

Line 1594: hr_utility.set_location('No Options Exists',120);

1590: AND l_OPT3_PERSON_RATE_ID IS NULL
1591: AND l_OPT4_PERSON_RATE_ID IS NULL ) THEN
1592:
1593: If g_debug then
1594: hr_utility.set_location('No Options Exists',120);
1595: end if;
1596:
1597: IF(substr(l_DOWNLOAD_SWITCH,1,1) = '2') THEN
1598: l_diff := UPDATE_WS_AMOUNT(P_PERSON_RATE_ID => l_PL_PERSON_RATE_ID

Line 1603: hr_utility.set_location('Updated Plan WS Amt Sucessfully',130);

1599: ,P_WS_VAL => P_PL_WS_VAL
1600: ,P_USER_ID => P_USER_ID
1601: ,P_WS_RT_START_DATE =>P_PL_RT_START_DATE );
1602: If g_debug then
1603: hr_utility.set_location('Updated Plan WS Amt Sucessfully',130);
1604: End if;
1605: End If;
1606:
1607: -- ER: ability to update other rates

Line 1616: hr_utility.set_location('Updated Plan Other Rates Sucessfully',130);

1612: P_PL_MISC1_VAL,P_PL_MISC2_VAL,P_PL_MISC3_VAL)
1613: ,p_interface_code => l_interfac_code
1614: ,p_base_layout_code => l_base_layout_code );
1615: If g_debug then
1616: hr_utility.set_location('Updated Plan Other Rates Sucessfully',130);
1617: End if;
1618: End If;
1619:
1620: ELSE

Line 1624: hr_utility.set_location('Options Exists',140);

1620: ELSE
1621: -- Update Option Record with Modified Option Worksheet Amount
1622:
1623: If g_debug then
1624: hr_utility.set_location('Options Exists',140);
1625: end if;
1626:
1627: -- Plan :
1628: -- If Option Rates exists for a Plan

Line 1636: hr_utility.set_location('l_pl_ws_val :'||l_pl_ws_val,150);

1632: Fetch Csr_get_pl_ws_val into l_pl_ws_val;
1633: Close Csr_get_pl_ws_val;
1634:
1635: If g_debug then
1636: hr_utility.set_location('l_pl_ws_val :'||l_pl_ws_val,150);
1637: end if;
1638:
1639: IF (l_pl_ws_val <> P_PL_WS_VAL) THEN
1640: hr_utility.set_message(805,'BEN_7830_CWB_NOT_UPD_PL_WSVAL');

Line 1640: hr_utility.set_message(805,'BEN_7830_CWB_NOT_UPD_PL_WSVAL');

1636: hr_utility.set_location('l_pl_ws_val :'||l_pl_ws_val,150);
1637: end if;
1638:
1639: IF (l_pl_ws_val <> P_PL_WS_VAL) THEN
1640: hr_utility.set_message(805,'BEN_7830_CWB_NOT_UPD_PL_WSVAL');
1641: hr_utility.raise_error;
1642: END IF;
1643:
1644: -- Plan level : bug 14022949: update other rates at plan level for plan with options

Line 1641: hr_utility.raise_error;

1637: end if;
1638:
1639: IF (l_pl_ws_val <> P_PL_WS_VAL) THEN
1640: hr_utility.set_message(805,'BEN_7830_CWB_NOT_UPD_PL_WSVAL');
1641: hr_utility.raise_error;
1642: END IF;
1643:
1644: -- Plan level : bug 14022949: update other rates at plan level for plan with options
1645: IF(l_PL_PERSON_RATE_ID IS NOT NULL AND substr(l_DOWNLOAD_SWITCH,39,1) = '2') THEN

Line 1653: hr_utility.set_location('Updated Plan Other Rates Sucessfully',130);

1649: P_PL_MISC1_VAL,P_PL_MISC2_VAL,P_PL_MISC3_VAL)
1650: ,p_interface_code => l_interfac_code
1651: ,p_base_layout_code => l_base_layout_code );
1652: If g_debug then
1653: hr_utility.set_location('Updated Plan Other Rates Sucessfully',130);
1654: End if;
1655: End If;
1656:
1657: -- Option 1 :

Line 1675: hr_utility.set_location('Updated Option1 WS Amt Sucessfully',160);

1671: ,P_WS_RT_START_DATE => P_PL_RT_START_DATE);
1672: end if;
1673:
1674: If g_debug then
1675: hr_utility.set_location('Updated Option1 WS Amt Sucessfully',160);
1676: end if;
1677:
1678: END IF;
1679:

Line 1689: hr_utility.set_location('Updated Option 1 Other Rates Sucessfully',130);

1685: P_OPT1_MISC1_VAL,P_OPT1_MISC2_VAL,P_OPT1_MISC3_VAL)
1686: ,p_interface_code => l_interfac_code
1687: ,p_base_layout_code => l_base_layout_code );
1688: If g_debug then
1689: hr_utility.set_location('Updated Option 1 Other Rates Sucessfully',130);
1690: End if;
1691: END IF;
1692:
1693: -- Option 2 :

Line 1710: hr_utility.set_location('Updated Option2 WS Amt Sucessfully',170);

1706: ,P_WS_RT_START_DATE => P_PL_RT_START_DATE);
1707: end if;
1708:
1709: If g_debug then
1710: hr_utility.set_location('Updated Option2 WS Amt Sucessfully',170);
1711: end if;
1712:
1713: END IF;
1714:

Line 1724: hr_utility.set_location('Updated Option 2 Other Rates Sucessfully',130);

1720: P_OPT2_MISC1_VAL,P_OPT2_MISC2_VAL,P_OPT2_MISC3_VAL)
1721: ,p_interface_code => l_interfac_code
1722: ,p_base_layout_code => l_base_layout_code );
1723: If g_debug then
1724: hr_utility.set_location('Updated Option 2 Other Rates Sucessfully',130);
1725: End if;
1726: END IF;
1727:
1728: -- Option 3 :

Line 1745: hr_utility.set_location('Updated Option3 WS Amt Sucessfully',180);

1741: ,P_WS_RT_START_DATE => P_PL_RT_START_DATE);
1742: end if;
1743:
1744: If g_debug then
1745: hr_utility.set_location('Updated Option3 WS Amt Sucessfully',180);
1746: end if;
1747:
1748:
1749: END IF;

Line 1760: hr_utility.set_location('Updated Option 3 Other Rates Sucessfully',130);

1756: P_OPT3_MISC1_VAL,P_OPT3_MISC2_VAL,P_OPT3_MISC3_VAL)
1757: ,p_interface_code => l_interfac_code
1758: ,p_base_layout_code => l_base_layout_code );
1759: If g_debug then
1760: hr_utility.set_location('Updated Option 3 Other Rates Sucessfully',130);
1761: End if;
1762: END IF;
1763:
1764: -- Option 4 :

Line 1781: hr_utility.set_location('Updated Option4 WS Amt Sucessfully',190);

1777: ,P_WS_RT_START_DATE => P_PL_RT_START_DATE);
1778: end if;
1779:
1780: If g_debug then
1781: hr_utility.set_location('Updated Option4 WS Amt Sucessfully',190);
1782: end if;
1783:
1784:
1785: END IF;

Line 1796: hr_utility.set_location('Updated Option 4 Other Rates Sucessfully',130);

1792: P_OPT4_MISC1_VAL,P_OPT4_MISC2_VAL,P_OPT4_MISC3_VAL)
1793: ,p_interface_code => l_interfac_code
1794: ,p_base_layout_code => l_base_layout_code );
1795: If g_debug then
1796: hr_utility.set_location('Updated Option 4 Other Rates Sucessfully',130);
1797: End if;
1798: END IF;
1799:
1800: END IF;

Line 1803: hr_utility.set_location('Updated Worksheet Amount Sucessfully ',200);

1799:
1800: END IF;
1801:
1802: If g_debug then
1803: hr_utility.set_location('Updated Worksheet Amount Sucessfully ',200);
1804: End if;
1805:
1806:
1807: -- Update Rank

Line 1816: hr_utility.set_location('Updated Rank Sucessfully ',220);

1812: UPDATE_RANK(P_GROUP_PER_IN_LER_ID => l_group_per_in_ler_id
1813: ,P_RANK => P_RANK
1814: ,P_USER_ID => l_ACTING_PERSON_ID);
1815: If g_debug then
1816: hr_utility.set_location('Updated Rank Sucessfully ',220);
1817: End if;
1818:
1819: END IF;
1820:

Line 1824: hr_utility.set_location('save_pl_sql_tab Sucessfully ',230);

1820:
1821: BEN_CWB_SUMMARY_PKG.save_pl_sql_tab;
1822:
1823: If g_debug then
1824: hr_utility.set_location('save_pl_sql_tab Sucessfully ',230);
1825: End if;
1826:
1827: -- Proposed Performance Rating
1828:

Line 1838: hr_utility.set_location('Updated Proposed Performance Rating Sucessfully ',240);

1834: ,P_OPT2_PERSON_RATE_ID => l_OPT2_PERSON_RATE_ID
1835: ,P_OPT3_PERSON_RATE_ID => l_OPT3_PERSON_RATE_ID
1836: ,P_OPT4_PERSON_RATE_ID => l_OPT4_PERSON_RATE_ID);
1837: If g_debug then
1838: hr_utility.set_location('Updated Proposed Performance Rating Sucessfully ',240);
1839: End if;
1840: END IF;
1841:
1842: IF(substr(l_DOWNLOAD_SWITCH,38,1) = '2') THEN

Line 1855: hr_utility.set_location('Updated Proposed Promotion Sucessfully ',240);

1851: ,P_OPT3_PERSON_RATE_ID => l_OPT3_PERSON_RATE_ID
1852: ,P_OPT4_PERSON_RATE_ID => l_OPT4_PERSON_RATE_ID);
1853:
1854: If g_debug then
1855: hr_utility.set_location('Updated Proposed Promotion Sucessfully ',240);
1856: End if;
1857: END IF;
1858:
1859: -- Update Person Tasks Table

Line 1869: hr_utility.set_location('Update Person Tasks Table Sucessfully ',250);

1865: ,P_TASK_ID => l_TASK_ID
1866: ,P_SEC_MGR_LER_ID => l_SEC_MGR_LER_ID );
1867:
1868: If g_debug then
1869: hr_utility.set_location('Update Person Tasks Table Sucessfully ',250);
1870: End if;
1871:
1872: -- Update the CPI Flex
1873: -- Update CPI Flex

Line 1997: hr_utility.set_location('Upload CPI Attribute1',251);

1993: IF(l_is_read_only.interface_seq_num = '200' AND l_is_read_only.read_only = 'N') THEN
1994: IF(substr(l_DOWNLOAD_SWITCH,8,1) = '2') THEN
1995: l_cpi_attribute1 := check_varchar_col_avble(l_cpi_attribute1 ,p_cpi_attribute1);
1996: If g_debug then
1997: hr_utility.set_location('Upload CPI Attribute1',251);
1998: End if;
1999: END IF;
2000: END IF;
2001: IF(l_is_read_only.interface_seq_num = '201' AND l_is_read_only.read_only = 'N') THEN

Line 2005: hr_utility.set_location('Upload CPI Attribute2',252);

2001: IF(l_is_read_only.interface_seq_num = '201' AND l_is_read_only.read_only = 'N') THEN
2002: IF(substr(l_DOWNLOAD_SWITCH,9,1) = '2') THEN
2003: l_cpi_attribute2 := check_varchar_col_avble(l_cpi_attribute2 ,p_cpi_attribute2);
2004: If g_debug then
2005: hr_utility.set_location('Upload CPI Attribute2',252);
2006: End if;
2007: END IF;
2008: END IF;
2009: IF(l_is_read_only.interface_seq_num = '202' AND l_is_read_only.read_only = 'N') THEN

Line 2013: hr_utility.set_location('Upload CPI Attribute3',253);

2009: IF(l_is_read_only.interface_seq_num = '202' AND l_is_read_only.read_only = 'N') THEN
2010: IF(substr(l_DOWNLOAD_SWITCH,10,1) = '2') THEN
2011: l_cpi_attribute3 := check_varchar_col_avble(l_cpi_attribute3 ,p_cpi_attribute3);
2012: If g_debug then
2013: hr_utility.set_location('Upload CPI Attribute3',253);
2014: End if;
2015: END IF;
2016: END IF;
2017: IF(l_is_read_only.interface_seq_num = '203' AND l_is_read_only.read_only = 'N') THEN

Line 2021: hr_utility.set_location('Upload CPI Attribute4',254);

2017: IF(l_is_read_only.interface_seq_num = '203' AND l_is_read_only.read_only = 'N') THEN
2018: IF(substr(l_DOWNLOAD_SWITCH,11,1) = '2') THEN
2019: l_cpi_attribute4 := check_varchar_col_avble(l_cpi_attribute4 ,p_cpi_attribute4);
2020: If g_debug then
2021: hr_utility.set_location('Upload CPI Attribute4',254);
2022: End if;
2023: END IF;
2024: END IF;
2025: IF(l_is_read_only.interface_seq_num = '204' AND l_is_read_only.read_only = 'N') THEN

Line 2029: hr_utility.set_location('Upload CPI Attribute5',255);

2025: IF(l_is_read_only.interface_seq_num = '204' AND l_is_read_only.read_only = 'N') THEN
2026: IF(substr(l_DOWNLOAD_SWITCH,12,1) = '2') THEN
2027: l_cpi_attribute5 := check_varchar_col_avble(l_cpi_attribute5 ,p_cpi_attribute5);
2028: If g_debug then
2029: hr_utility.set_location('Upload CPI Attribute5',255);
2030: End if;
2031: END IF;
2032: END IF;
2033: IF(l_is_read_only.interface_seq_num = '205' AND l_is_read_only.read_only = 'N') THEN

Line 2037: hr_utility.set_location('Upload CPI Attribute6',256);

2033: IF(l_is_read_only.interface_seq_num = '205' AND l_is_read_only.read_only = 'N') THEN
2034: IF(substr(l_DOWNLOAD_SWITCH,13,1) = '2') THEN
2035: l_cpi_attribute6 := check_varchar_col_avble(l_cpi_attribute6 ,p_cpi_attribute6);
2036: If g_debug then
2037: hr_utility.set_location('Upload CPI Attribute6',256);
2038: End if;
2039: END IF;
2040: END IF;
2041: IF(l_is_read_only.interface_seq_num = '206' AND l_is_read_only.read_only = 'N') THEN

Line 2045: hr_utility.set_location('Upload CPI Attribute7',257);

2041: IF(l_is_read_only.interface_seq_num = '206' AND l_is_read_only.read_only = 'N') THEN
2042: IF(substr(l_DOWNLOAD_SWITCH,14,1) = '2') THEN
2043: l_cpi_attribute7 := check_varchar_col_avble(l_cpi_attribute7 ,p_cpi_attribute7);
2044: If g_debug then
2045: hr_utility.set_location('Upload CPI Attribute7',257);
2046: End if;
2047: END IF;
2048: END IF;
2049: IF(l_is_read_only.interface_seq_num = '207' AND l_is_read_only.read_only = 'N') THEN

Line 2053: hr_utility.set_location('Upload CPI Attribute8',258);

2049: IF(l_is_read_only.interface_seq_num = '207' AND l_is_read_only.read_only = 'N') THEN
2050: IF(substr(l_DOWNLOAD_SWITCH,15,1) = '2') THEN
2051: l_cpi_attribute8 := check_varchar_col_avble(l_cpi_attribute8 ,p_cpi_attribute8);
2052: If g_debug then
2053: hr_utility.set_location('Upload CPI Attribute8',258);
2054: End if;
2055: END IF;
2056: END IF;
2057: IF(l_is_read_only.interface_seq_num = '208' AND l_is_read_only.read_only = 'N') THEN

Line 2061: hr_utility.set_location('Upload CPI Attribute9',259);

2057: IF(l_is_read_only.interface_seq_num = '208' AND l_is_read_only.read_only = 'N') THEN
2058: IF(substr(l_DOWNLOAD_SWITCH,16,1) = '2') THEN
2059: l_cpi_attribute9 := check_varchar_col_avble(l_cpi_attribute9 ,p_cpi_attribute9);
2060: If g_debug then
2061: hr_utility.set_location('Upload CPI Attribute9',259);
2062: End if;
2063: END IF;
2064: END IF;
2065: IF(l_is_read_only.interface_seq_num = '209' AND l_is_read_only.read_only = 'N') THEN

Line 2069: hr_utility.set_location('Upload CPI Attribute10',260);

2065: IF(l_is_read_only.interface_seq_num = '209' AND l_is_read_only.read_only = 'N') THEN
2066: IF(substr(l_DOWNLOAD_SWITCH,17,1) = '2') THEN
2067: l_cpi_attribute10 := check_varchar_col_avble(l_cpi_attribute10 ,p_cpi_attribute10);
2068: If g_debug then
2069: hr_utility.set_location('Upload CPI Attribute10',260);
2070: End if;
2071: END IF;
2072: END IF;
2073: IF(l_is_read_only.interface_seq_num = '210' AND l_is_read_only.read_only = 'N') THEN

Line 2077: hr_utility.set_location('Upload CPI Attribute11',261);

2073: IF(l_is_read_only.interface_seq_num = '210' AND l_is_read_only.read_only = 'N') THEN
2074: IF(substr(l_DOWNLOAD_SWITCH,18,1) = '2') THEN
2075: l_cpi_attribute11 := check_varchar_col_avble(l_cpi_attribute11 ,p_cpi_attribute11);
2076: If g_debug then
2077: hr_utility.set_location('Upload CPI Attribute11',261);
2078: End if;
2079: END IF;
2080: END IF;
2081: IF(l_is_read_only.interface_seq_num = '211' AND l_is_read_only.read_only = 'N') THEN

Line 2085: hr_utility.set_location('Upload CPI Attribute12',262);

2081: IF(l_is_read_only.interface_seq_num = '211' AND l_is_read_only.read_only = 'N') THEN
2082: IF(substr(l_DOWNLOAD_SWITCH,19,1) = '2') THEN
2083: l_cpi_attribute12 := check_varchar_col_avble(l_cpi_attribute12 ,p_cpi_attribute12);
2084: If g_debug then
2085: hr_utility.set_location('Upload CPI Attribute12',262);
2086: End if;
2087: END IF;
2088: END IF;
2089: IF(l_is_read_only.interface_seq_num = '212' AND l_is_read_only.read_only = 'N') THEN

Line 2093: hr_utility.set_location('Upload CPI Attribute13',263);

2089: IF(l_is_read_only.interface_seq_num = '212' AND l_is_read_only.read_only = 'N') THEN
2090: IF(substr(l_DOWNLOAD_SWITCH,20,1) = '2') THEN
2091: l_cpi_attribute13 := check_varchar_col_avble(l_cpi_attribute13 ,p_cpi_attribute13);
2092: If g_debug then
2093: hr_utility.set_location('Upload CPI Attribute13',263);
2094: End if;
2095: END IF;
2096: END IF;
2097: IF(l_is_read_only.interface_seq_num = '213' AND l_is_read_only.read_only = 'N') THEN

Line 2101: hr_utility.set_location('Upload CPI Attribute14',264);

2097: IF(l_is_read_only.interface_seq_num = '213' AND l_is_read_only.read_only = 'N') THEN
2098: IF(substr(l_DOWNLOAD_SWITCH,21,1) = '2') THEN
2099: l_cpi_attribute14 := check_varchar_col_avble(l_cpi_attribute14 ,p_cpi_attribute14);
2100: If g_debug then
2101: hr_utility.set_location('Upload CPI Attribute14',264);
2102: End if;
2103: END IF;
2104: END IF;
2105: IF(l_is_read_only.interface_seq_num = '214' AND l_is_read_only.read_only = 'N') THEN

Line 2109: hr_utility.set_location('Upload CPI Attribute15',265);

2105: IF(l_is_read_only.interface_seq_num = '214' AND l_is_read_only.read_only = 'N') THEN
2106: IF(substr(l_DOWNLOAD_SWITCH,22,1) = '2') THEN
2107: l_cpi_attribute15 := check_varchar_col_avble(l_cpi_attribute15 ,p_cpi_attribute15);
2108: If g_debug then
2109: hr_utility.set_location('Upload CPI Attribute15',265);
2110: End if;
2111: END IF;
2112: END IF;
2113: IF(l_is_read_only.interface_seq_num = '215' AND l_is_read_only.read_only = 'N') THEN

Line 2117: hr_utility.set_location('Upload CPI Attribute16',266);

2113: IF(l_is_read_only.interface_seq_num = '215' AND l_is_read_only.read_only = 'N') THEN
2114: IF(substr(l_DOWNLOAD_SWITCH,23,1) = '2') THEN
2115: l_cpi_attribute16 := check_varchar_col_avble(l_cpi_attribute16 ,p_cpi_attribute16);
2116: If g_debug then
2117: hr_utility.set_location('Upload CPI Attribute16',266);
2118: End if;
2119: END IF;
2120: END IF;
2121: IF(l_is_read_only.interface_seq_num = '216' AND l_is_read_only.read_only = 'N') THEN

Line 2125: hr_utility.set_location('Upload CPI Attribute17',267);

2121: IF(l_is_read_only.interface_seq_num = '216' AND l_is_read_only.read_only = 'N') THEN
2122: IF(substr(l_DOWNLOAD_SWITCH,24,1) = '2') THEN
2123: l_cpi_attribute17 := check_varchar_col_avble(l_cpi_attribute17 ,p_cpi_attribute17);
2124: If g_debug then
2125: hr_utility.set_location('Upload CPI Attribute17',267);
2126: End if;
2127: END IF;
2128: END IF;
2129: IF(l_is_read_only.interface_seq_num = '217' AND l_is_read_only.read_only = 'N') THEN

Line 2133: hr_utility.set_location('Upload CPI Attribute18',268);

2129: IF(l_is_read_only.interface_seq_num = '217' AND l_is_read_only.read_only = 'N') THEN
2130: IF(substr(l_DOWNLOAD_SWITCH,25,1) = '2') THEN
2131: l_cpi_attribute18 := check_varchar_col_avble(l_cpi_attribute18 ,p_cpi_attribute18);
2132: If g_debug then
2133: hr_utility.set_location('Upload CPI Attribute18',268);
2134: End if;
2135: END IF;
2136: END IF;
2137: IF(l_is_read_only.interface_seq_num = '218' AND l_is_read_only.read_only = 'N') THEN

Line 2141: hr_utility.set_location('Upload CPI Attribute19',269);

2137: IF(l_is_read_only.interface_seq_num = '218' AND l_is_read_only.read_only = 'N') THEN
2138: IF(substr(l_DOWNLOAD_SWITCH,26,1) = '2') THEN
2139: l_cpi_attribute19 := check_varchar_col_avble(l_cpi_attribute19 ,p_cpi_attribute19);
2140: If g_debug then
2141: hr_utility.set_location('Upload CPI Attribute19',269);
2142: End if;
2143: END IF;
2144: END IF;
2145: IF(l_is_read_only.interface_seq_num = '219' AND l_is_read_only.read_only = 'N') THEN

Line 2149: hr_utility.set_location('Upload CPI Attribute20',270);

2145: IF(l_is_read_only.interface_seq_num = '219' AND l_is_read_only.read_only = 'N') THEN
2146: IF(substr(l_DOWNLOAD_SWITCH,27,1) = '2') THEN
2147: l_cpi_attribute20 := check_varchar_col_avble(l_cpi_attribute20 ,p_cpi_attribute20);
2148: If g_debug then
2149: hr_utility.set_location('Upload CPI Attribute20',270);
2150: End if;
2151: END IF;
2152: END IF;
2153: IF(l_is_read_only.interface_seq_num = '220' AND l_is_read_only.read_only = 'N') THEN

Line 2157: hr_utility.set_location('Upload CPI Attribute21',271);

2153: IF(l_is_read_only.interface_seq_num = '220' AND l_is_read_only.read_only = 'N') THEN
2154: IF(substr(l_DOWNLOAD_SWITCH,28,1) = '2') THEN
2155: l_cpi_attribute21 := check_varchar_col_avble(l_cpi_attribute21 ,p_cpi_attribute21);
2156: If g_debug then
2157: hr_utility.set_location('Upload CPI Attribute21',271);
2158: End if;
2159: END IF;
2160: END IF;
2161: IF(l_is_read_only.interface_seq_num = '221' AND l_is_read_only.read_only = 'N') THEN

Line 2165: hr_utility.set_location('Upload CPI Attribute22',272);

2161: IF(l_is_read_only.interface_seq_num = '221' AND l_is_read_only.read_only = 'N') THEN
2162: IF(substr(l_DOWNLOAD_SWITCH,29,1) = '2') THEN
2163: l_cpi_attribute22 := check_varchar_col_avble(l_cpi_attribute22 ,p_cpi_attribute22);
2164: If g_debug then
2165: hr_utility.set_location('Upload CPI Attribute22',272);
2166: End if;
2167: END IF;
2168: END IF;
2169: IF(l_is_read_only.interface_seq_num = '222' AND l_is_read_only.read_only = 'N') THEN

Line 2173: hr_utility.set_location('Upload CPI Attribute23',273);

2169: IF(l_is_read_only.interface_seq_num = '222' AND l_is_read_only.read_only = 'N') THEN
2170: IF(substr(l_DOWNLOAD_SWITCH,30,1) = '2') THEN
2171: l_cpi_attribute23 := check_varchar_col_avble(l_cpi_attribute23 ,p_cpi_attribute23);
2172: If g_debug then
2173: hr_utility.set_location('Upload CPI Attribute23',273);
2174: End if;
2175: END IF;
2176: END IF;
2177: IF(l_is_read_only.interface_seq_num = '223' AND l_is_read_only.read_only = 'N') THEN

Line 2181: hr_utility.set_location('Upload CPI Attribute24',274);

2177: IF(l_is_read_only.interface_seq_num = '223' AND l_is_read_only.read_only = 'N') THEN
2178: IF(substr(l_DOWNLOAD_SWITCH,31,1) = '2') THEN
2179: l_cpi_attribute24 := check_varchar_col_avble(l_cpi_attribute24 ,p_cpi_attribute24);
2180: If g_debug then
2181: hr_utility.set_location('Upload CPI Attribute24',274);
2182: End if;
2183: END IF;
2184: END IF;
2185: IF(l_is_read_only.interface_seq_num = '224' AND l_is_read_only.read_only = 'N') THEN

Line 2189: hr_utility.set_location('Upload CPI Attribute25',275);

2185: IF(l_is_read_only.interface_seq_num = '224' AND l_is_read_only.read_only = 'N') THEN
2186: IF(substr(l_DOWNLOAD_SWITCH,32,1) = '2') THEN
2187: l_cpi_attribute25 := check_varchar_col_avble(l_cpi_attribute25 ,p_cpi_attribute25);
2188: If g_debug then
2189: hr_utility.set_location('Upload CPI Attribute25',275);
2190: End if;
2191: END IF;
2192: END IF;
2193: IF(l_is_read_only.interface_seq_num = '225' AND l_is_read_only.read_only = 'N') THEN

Line 2197: hr_utility.set_location('Upload CPI Attribute26',276);

2193: IF(l_is_read_only.interface_seq_num = '225' AND l_is_read_only.read_only = 'N') THEN
2194: IF(substr(l_DOWNLOAD_SWITCH,33,1) = '2') THEN
2195: l_cpi_attribute26 := check_varchar_col_avble(l_cpi_attribute26 ,p_cpi_attribute26);
2196: If g_debug then
2197: hr_utility.set_location('Upload CPI Attribute26',276);
2198: End if;
2199: END IF;
2200: END IF;
2201: IF(l_is_read_only.interface_seq_num = '226' AND l_is_read_only.read_only = 'N') THEN

Line 2205: hr_utility.set_location('Upload CPI Attribute27',277);

2201: IF(l_is_read_only.interface_seq_num = '226' AND l_is_read_only.read_only = 'N') THEN
2202: IF(substr(l_DOWNLOAD_SWITCH,34,1) = '2') THEN
2203: l_cpi_attribute27 := check_varchar_col_avble(l_cpi_attribute27 ,p_cpi_attribute27);
2204: If g_debug then
2205: hr_utility.set_location('Upload CPI Attribute27',277);
2206: End if;
2207: END IF;
2208: END IF;
2209: IF(l_is_read_only.interface_seq_num = '227' AND l_is_read_only.read_only = 'N') THEN

Line 2213: hr_utility.set_location('Upload CPI Attribute28',278);

2209: IF(l_is_read_only.interface_seq_num = '227' AND l_is_read_only.read_only = 'N') THEN
2210: IF(substr(l_DOWNLOAD_SWITCH,35,1) = '2') THEN
2211: l_cpi_attribute28 := check_varchar_col_avble(l_cpi_attribute28 ,p_cpi_attribute28);
2212: If g_debug then
2213: hr_utility.set_location('Upload CPI Attribute28',278);
2214: End if;
2215: END IF;
2216: END IF;
2217: IF(l_is_read_only.interface_seq_num = '228' AND l_is_read_only.read_only = 'N') THEN

Line 2221: hr_utility.set_location('Upload CPI Attribute29',279);

2217: IF(l_is_read_only.interface_seq_num = '228' AND l_is_read_only.read_only = 'N') THEN
2218: IF(substr(l_DOWNLOAD_SWITCH,36,1) = '2') THEN
2219: l_cpi_attribute29 := check_varchar_col_avble(l_cpi_attribute29 ,p_cpi_attribute29);
2220: If g_debug then
2221: hr_utility.set_location('Upload CPI Attribute29',279);
2222: End if;
2223: END IF;
2224: END IF;
2225: IF(l_is_read_only.interface_seq_num = '229' AND l_is_read_only.read_only = 'N') THEN

Line 2229: hr_utility.set_location('Upload CPI Attribute30',280);

2225: IF(l_is_read_only.interface_seq_num = '229' AND l_is_read_only.read_only = 'N') THEN
2226: IF(substr(l_DOWNLOAD_SWITCH,37,1) = '2') THEN
2227: l_cpi_attribute30 := check_varchar_col_avble(l_cpi_attribute30 ,p_cpi_attribute30);
2228: If g_debug then
2229: hr_utility.set_location('Upload CPI Attribute30',280);
2230: End if;
2231: END IF;
2232: END IF;
2233:

Line 2291: hr_utility.set_location('Updated CPI Flex Rating Sucessfully ',281);

2287: ,P_CUSTOM_SEGMENT19 => l_CUSTOM_SEGMENT19
2288: ,P_CUSTOM_SEGMENT20 => l_CUSTOM_SEGMENT20
2289: ,P_OBJECT_VERSION_NUMBER => L_OVN);
2290: If g_debug then
2291: hr_utility.set_location('Updated CPI Flex Rating Sucessfully ',281);
2292: End if;
2293:
2294: --
2295: -- Call the routine for dynamic calculations.

Line 2309: hr_utility.set_location('Leaving '||l_proc,290);

2305: ,p_raise_error => true);
2306: --
2307:
2308: If g_debug then
2309: hr_utility.set_location('Leaving '||l_proc,290);
2310: End if;
2311:
2312: EXCEPTION
2313: WHEN Others THEN

Line 2315: hr_utility.set_location('sqlerrm:'||substr(sqlerrm,1,50), 300);

2311:
2312: EXCEPTION
2313: WHEN Others THEN
2314: if g_debug then
2315: hr_utility.set_location('sqlerrm:'||substr(sqlerrm,1,50), 300);
2316: hr_utility.set_location('sqlerrm:'||substr(sqlerrm,51,100), 301);
2317: hr_utility.set_location('sqlerrm:'||substr(sqlerrm,101,150), 302);
2318: end if;
2319:

Line 2316: hr_utility.set_location('sqlerrm:'||substr(sqlerrm,51,100), 301);

2312: EXCEPTION
2313: WHEN Others THEN
2314: if g_debug then
2315: hr_utility.set_location('sqlerrm:'||substr(sqlerrm,1,50), 300);
2316: hr_utility.set_location('sqlerrm:'||substr(sqlerrm,51,100), 301);
2317: hr_utility.set_location('sqlerrm:'||substr(sqlerrm,101,150), 302);
2318: end if;
2319:
2320: Rollback to Update_data;

Line 2317: hr_utility.set_location('sqlerrm:'||substr(sqlerrm,101,150), 302);

2313: WHEN Others THEN
2314: if g_debug then
2315: hr_utility.set_location('sqlerrm:'||substr(sqlerrm,1,50), 300);
2316: hr_utility.set_location('sqlerrm:'||substr(sqlerrm,51,100), 301);
2317: hr_utility.set_location('sqlerrm:'||substr(sqlerrm,101,150), 302);
2318: end if;
2319:
2320: Rollback to Update_data;
2321: