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_ABS_LER dependencies on HR_UTILITY

Line 65: hr_utility.set_location('Entering: ' || l_proc_name, 5);

61: l_proc_name Constant Varchar2(150) :='gb_abs_life_event_rule';
62: --
63: begin
64: --
65: hr_utility.set_location('Entering: ' || l_proc_name, 5);
66: hr_utility.set_location('Absence event type: ' || p_absence_event_type, 5);
67: --
68: if p_absence_event_type = 'START' then
69: --

Line 66: hr_utility.set_location('Absence event type: ' || p_absence_event_type, 5);

62: --
63: begin
64: --
65: hr_utility.set_location('Entering: ' || l_proc_name, 5);
66: hr_utility.set_location('Absence event type: ' || p_absence_event_type, 5);
67: --
68: if p_absence_event_type = 'START' then
69: --
70: --Check that there is a difference between the old and new values of

Line 74: hr_utility.set_location('Absence Event Type = START', 10);

70: --Check that there is a difference between the old and new values of
71: --start date.
72:
73: --
74: hr_utility.set_location('Absence Event Type = START', 10);
75: l_look_up_check := HR_GENERAL.DECODE_LOOKUP('PQP_GAP_ABSENCE_TYPES_LIST',p_new_abs_attendance_type_id);
76: --
77: if l_look_up_check is not null then
78: --

Line 90: hr_utility.set_location('End Absence Start Date Section:' || l_ret_val, 20);

86: --
87: end if;
88:
89: --End Absence Start Date Section
90: hr_utility.set_location('End Absence Start Date Section:' || l_ret_val, 20);
91: --
92: --Begin Absence Information 1 - Start Date Fraction Section
93: --Check that there is a difference between the old and new values of
94: --ABS_INFORMATION1.

Line 108: hr_utility.set_location('End of Absence Information 1 Section:' || l_ret_val, 30);

104: --
105: end if;
106:
107: --End Absence Information 1
108: hr_utility.set_location('End of Absence Information 1 Section:' || l_ret_val, 30);
109: --
110: --Begin Absence Information 2 - End Date Fraction Section
111: --Check that there is a difference between the old and new values of
112: --ABS_INFORMATION2.

Line 126: hr_utility.set_location('End of Absence Information 2 Section:' || l_ret_val, 40);

122: --
123: end if;
124:
125: --End Absence Information 2
126: hr_utility.set_location('End of Absence Information 2 Section:' || l_ret_val, 40);
127:
128:
129: --
130: --Check that there is a difference between the old and new values of

Line 145: hr_utility.set_location('End of Pension Rate start date section:' || l_ret_val, 50);

141: --
142: end if;
143:
144: --End Absence Information 4 i.e. Pension start date
145: hr_utility.set_location('End of Pension Rate start date section:' || l_ret_val, 50);
146:
147: --Check that there is a difference between the old and new values of
148: --INFORMATION5(Pension rate end date) .
149:

Line 162: hr_utility.set_location('End of Pension Rate end date section:' || l_ret_val, 60);

158: --
159: end if;
160:
161: --End Absence Information 5 i.e. Pension end date
162: hr_utility.set_location('End of Pension Rate end date section:' || l_ret_val, 60);
163: --
164: --Check that there is a difference between the old and new values of
165: --INFORMATION6(Pension rate) .
166:

Line 179: hr_utility.set_location('End of Pension Rate section:' || l_ret_val, 70);

175: --
176: end if;
177:
178: --End Absence Information 2 - End Date Fraction Section
179: hr_utility.set_location('End of Pension Rate section:' || l_ret_val, 70);
180: --
181: end if; --End for checking lookup exist
182: --
183: elsif p_absence_event_type = 'END' then

Line 193: hr_utility.set_location('Absence Event Type = END', 80);

189: --to be setup. To prevent a absence start change from being logged on a
190: --delete, an additional check is introduced to ensure that new value is not
191: --equal to the default.
192: --
193: hr_utility.set_location('Absence Event Type = END', 80);
194: l_look_up_check := HR_GENERAL.DECODE_LOOKUP('PQP_GAP_ABSENCE_TYPES_LIST',p_new_abs_attendance_type_id);
195: --
196: if l_look_up_check is not null then
197: --(

Line 219: hr_utility.set_location('Absence Event Type = DELETE', 90);

215: --to be setup. To prevent a absence start change from being logged on a
216: --delete, an additional check is introduced to ensure that new value is not
217: --equal to the default.
218: --
219: hr_utility.set_location('Absence Event Type = DELETE', 90);
220: l_look_up_check := HR_GENERAL.DECODE_LOOKUP('PQP_GAP_ABSENCE_TYPES_LIST',p_old_abs_attendance_type_id);
221:
222: if l_look_up_check is not null then
223: --

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

235: --
236: end if;
237: --
238: p_ret_val := l_ret_val;
239: hr_utility.set_location('Leaving: ' || l_proc_name, 100);
240: --
241: end gb_abs_life_event_rule;
242: --
243: procedure ler_chk(p_old IN g_abs_ler_rec

Line 419: --hr_utility.trace_on(null, 'dax');

415: l_leg_code VARCHAR2(10);
416: --
417: begin
418: --
419: --hr_utility.trace_on(null, 'dax');
420: benutils.set_data_migrator_mode; -- Bug 3320133
421: --
422: if hr_general.g_data_migrator_mode in ( 'Y','P') then
423: --

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

429: ,dep_appl_id =>805
430: ,status => l_status
431: ,industry => l_industry);
432:
433: hr_utility.set_location(' Entering: ben_abs_trigger', 10);
434: l_changed := FALSE;
435: --
436: If p_effective_date is not null then
437: --

Line 459: hr_utility.set_location('l_effective_date:'||l_effective_date, 20);

455: fetch get_session_date into l_effective_date;
456: --
457: close get_session_date;
458:
459: hr_utility.set_location('l_effective_date:'||l_effective_date, 20);
460:
461: --
462: open get_system_date;
463: --

Line 469: hr_utility.set_location(' ben_abs_trigger', 20);

465: --
466: close get_system_date;
467: --
468: l_effective_start_date := l_session_date;
469: hr_utility.set_location(' ben_abs_trigger', 20);
470: --
471: --
472: hr_utility.set_location(' l_system_date:'||to_char(l_system_date), 20);
473: hr_utility.set_location(' l_session_date:'||to_char(l_session_date,'dd-mon-rr hh24:mi:ss'), 20);

Line 472: hr_utility.set_location(' l_system_date:'||to_char(l_system_date), 20);

468: l_effective_start_date := l_session_date;
469: hr_utility.set_location(' ben_abs_trigger', 20);
470: --
471: --
472: hr_utility.set_location(' l_system_date:'||to_char(l_system_date), 20);
473: hr_utility.set_location(' l_session_date:'||to_char(l_session_date,'dd-mon-rr hh24:mi:ss'), 20);
474: hr_utility.set_location(' new abs id:'||to_char(p_new.absence_attendance_id), 20);
475: hr_utility.set_location(' old abs id:'||to_char(p_old.absence_attendance_id), 20);
476: --

Line 473: hr_utility.set_location(' l_session_date:'||to_char(l_session_date,'dd-mon-rr hh24:mi:ss'), 20);

469: hr_utility.set_location(' ben_abs_trigger', 20);
470: --
471: --
472: hr_utility.set_location(' l_system_date:'||to_char(l_system_date), 20);
473: hr_utility.set_location(' l_session_date:'||to_char(l_session_date,'dd-mon-rr hh24:mi:ss'), 20);
474: hr_utility.set_location(' new abs id:'||to_char(p_new.absence_attendance_id), 20);
475: hr_utility.set_location(' old abs id:'||to_char(p_old.absence_attendance_id), 20);
476: --
477: open get_ler;

Line 474: hr_utility.set_location(' new abs id:'||to_char(p_new.absence_attendance_id), 20);

470: --
471: --
472: hr_utility.set_location(' l_system_date:'||to_char(l_system_date), 20);
473: hr_utility.set_location(' l_session_date:'||to_char(l_session_date,'dd-mon-rr hh24:mi:ss'), 20);
474: hr_utility.set_location(' new abs id:'||to_char(p_new.absence_attendance_id), 20);
475: hr_utility.set_location(' old abs id:'||to_char(p_old.absence_attendance_id), 20);
476: --
477: open get_ler;
478: --

Line 475: hr_utility.set_location(' old abs id:'||to_char(p_old.absence_attendance_id), 20);

471: --
472: hr_utility.set_location(' l_system_date:'||to_char(l_system_date), 20);
473: hr_utility.set_location(' l_session_date:'||to_char(l_session_date,'dd-mon-rr hh24:mi:ss'), 20);
474: hr_utility.set_location(' new abs id:'||to_char(p_new.absence_attendance_id), 20);
475: hr_utility.set_location(' old abs id:'||to_char(p_old.absence_attendance_id), 20);
476: --
477: open get_ler;
478: --
479: loop

Line 482: hr_utility.set_location(' count : '||to_char(get_ler%rowcount), 20);

478: --
479: loop
480: --
481: fetch get_ler into l_ler_id, l_ocrd_dt_cd, l_typ_cd, l_lf_evt_oper_cd;
482: hr_utility.set_location(' count : '||to_char(get_ler%rowcount), 20);
483: exit when get_ler%notfound;
484: --
485: hr_utility.set_location(' lf evt oper cd: '||l_lf_evt_oper_cd, 20);
486: hr_utility.set_location('old start_date: '||to_char(p_old.date_start), 20);

Line 485: hr_utility.set_location(' lf evt oper cd: '||l_lf_evt_oper_cd, 20);

481: fetch get_ler into l_ler_id, l_ocrd_dt_cd, l_typ_cd, l_lf_evt_oper_cd;
482: hr_utility.set_location(' count : '||to_char(get_ler%rowcount), 20);
483: exit when get_ler%notfound;
484: --
485: hr_utility.set_location(' lf evt oper cd: '||l_lf_evt_oper_cd, 20);
486: hr_utility.set_location('old start_date: '||to_char(p_old.date_start), 20);
487: hr_utility.set_location('new start_date: '||to_char(p_new.date_start), 20);
488: hr_utility.set_location('old end_date: '||to_char(p_old.date_end), 20);
489: hr_utility.set_location('new end_date: '||to_char(p_new.date_end), 20);

Line 486: hr_utility.set_location('old start_date: '||to_char(p_old.date_start), 20);

482: hr_utility.set_location(' count : '||to_char(get_ler%rowcount), 20);
483: exit when get_ler%notfound;
484: --
485: hr_utility.set_location(' lf evt oper cd: '||l_lf_evt_oper_cd, 20);
486: hr_utility.set_location('old start_date: '||to_char(p_old.date_start), 20);
487: hr_utility.set_location('new start_date: '||to_char(p_new.date_start), 20);
488: hr_utility.set_location('old end_date: '||to_char(p_old.date_end), 20);
489: hr_utility.set_location('new end_date: '||to_char(p_new.date_end), 20);
490: if l_typ_cd <> 'ABS' or

Line 487: hr_utility.set_location('new start_date: '||to_char(p_new.date_start), 20);

483: exit when get_ler%notfound;
484: --
485: hr_utility.set_location(' lf evt oper cd: '||l_lf_evt_oper_cd, 20);
486: hr_utility.set_location('old start_date: '||to_char(p_old.date_start), 20);
487: hr_utility.set_location('new start_date: '||to_char(p_new.date_start), 20);
488: hr_utility.set_location('old end_date: '||to_char(p_old.date_end), 20);
489: hr_utility.set_location('new end_date: '||to_char(p_new.date_end), 20);
490: if l_typ_cd <> 'ABS' or
491: (l_typ_cd = 'ABS' and

Line 488: hr_utility.set_location('old end_date: '||to_char(p_old.date_end), 20);

484: --
485: hr_utility.set_location(' lf evt oper cd: '||l_lf_evt_oper_cd, 20);
486: hr_utility.set_location('old start_date: '||to_char(p_old.date_start), 20);
487: hr_utility.set_location('new start_date: '||to_char(p_new.date_start), 20);
488: hr_utility.set_location('old end_date: '||to_char(p_old.date_end), 20);
489: hr_utility.set_location('new end_date: '||to_char(p_new.date_end), 20);
490: if l_typ_cd <> 'ABS' or
491: (l_typ_cd = 'ABS' and
492: -- This is to stop triggering START/END LEs in case of Delete

Line 489: hr_utility.set_location('new end_date: '||to_char(p_new.date_end), 20);

485: hr_utility.set_location(' lf evt oper cd: '||l_lf_evt_oper_cd, 20);
486: hr_utility.set_location('old start_date: '||to_char(p_old.date_start), 20);
487: hr_utility.set_location('new start_date: '||to_char(p_new.date_start), 20);
488: hr_utility.set_location('old end_date: '||to_char(p_old.date_end), 20);
489: hr_utility.set_location('new end_date: '||to_char(p_new.date_end), 20);
490: if l_typ_cd <> 'ABS' or
491: (l_typ_cd = 'ABS' and
492: -- This is to stop triggering START/END LEs in case of Delete
493: ((p_new.absence_attendance_id is null and

Line 520: hr_utility.set_location('l_date_start'||l_date_start, 30);

516: l_date_start := nvl(p_new.date_start,l_session_date);
517: l_date_end := nvl(p_new.date_end,l_session_date);
518: end if;
519: --
520: hr_utility.set_location('l_date_start'||l_date_start, 30);
521: hr_utility.set_location('l_date_end'||l_date_end, 30);
522: --
523: if l_ocrd_dt_cd is null then
524: --

Line 521: hr_utility.set_location('l_date_end'||l_date_end, 30);

517: l_date_end := nvl(p_new.date_end,l_session_date);
518: end if;
519: --
520: hr_utility.set_location('l_date_start'||l_date_start, 30);
521: hr_utility.set_location('l_date_end'||l_date_end, 30);
522: --
523: if l_ocrd_dt_cd is null then
524: --
525: l_lf_evt_ocrd_date := l_date_start;

Line 552: hr_utility.set_location(' l_column'||l_column, 50);

548: l_type,
549: l_per_info_chg_cs_ler_rl,l_rule_overrides_flag, l_chg_mandatory_cd;
550: exit when get_ler_col%NOTFOUND;
551: --
552: hr_utility.set_location(' l_column'||l_column, 50);
553: hr_utility.set_location(' l_new_val'||l_new_val, 50);
554: hr_utility.set_location(' l_old_val'||l_old_val, 50);
555: hr_utility.set_location(' l_type'||l_type, 50);
556: hr_utility.set_location(' l_ler_id'||l_ler_id, 50);

Line 553: hr_utility.set_location(' l_new_val'||l_new_val, 50);

549: l_per_info_chg_cs_ler_rl,l_rule_overrides_flag, l_chg_mandatory_cd;
550: exit when get_ler_col%NOTFOUND;
551: --
552: hr_utility.set_location(' l_column'||l_column, 50);
553: hr_utility.set_location(' l_new_val'||l_new_val, 50);
554: hr_utility.set_location(' l_old_val'||l_old_val, 50);
555: hr_utility.set_location(' l_type'||l_type, 50);
556: hr_utility.set_location(' l_ler_id'||l_ler_id, 50);
557: --

Line 554: hr_utility.set_location(' l_old_val'||l_old_val, 50);

550: exit when get_ler_col%NOTFOUND;
551: --
552: hr_utility.set_location(' l_column'||l_column, 50);
553: hr_utility.set_location(' l_new_val'||l_new_val, 50);
554: hr_utility.set_location(' l_old_val'||l_old_val, 50);
555: hr_utility.set_location(' l_type'||l_type, 50);
556: hr_utility.set_location(' l_ler_id'||l_ler_id, 50);
557: --
558: if get_ler_col%ROWCOUNT = 1 then

Line 555: hr_utility.set_location(' l_type'||l_type, 50);

551: --
552: hr_utility.set_location(' l_column'||l_column, 50);
553: hr_utility.set_location(' l_new_val'||l_new_val, 50);
554: hr_utility.set_location(' l_old_val'||l_old_val, 50);
555: hr_utility.set_location(' l_type'||l_type, 50);
556: hr_utility.set_location(' l_ler_id'||l_ler_id, 50);
557: --
558: if get_ler_col%ROWCOUNT = 1 then
559: --

Line 556: hr_utility.set_location(' l_ler_id'||l_ler_id, 50);

552: hr_utility.set_location(' l_column'||l_column, 50);
553: hr_utility.set_location(' l_new_val'||l_new_val, 50);
554: hr_utility.set_location(' l_old_val'||l_old_val, 50);
555: hr_utility.set_location(' l_type'||l_type, 50);
556: hr_utility.set_location(' l_ler_id'||l_ler_id, 50);
557: --
558: if get_ler_col%ROWCOUNT = 1 then
559: --
560: l_changed := TRUE;

Line 564: hr_utility.set_location(' ben_abs_trigger', 51);

560: l_changed := TRUE;
561: --
562: end if;
563: --
564: hr_utility.set_location(' ben_abs_trigger', 51);
565: --
566: -- Call the formula here to evaluate per_info_chg_cs_ler_rl.
567: -- If it returns Y, then see the applicability of the data
568: -- changes based on new and old values.

Line 942: hr_utility.set_location(' Inside Date start ben_abs_trigger', 52);

938: end if;
939: --
940: if l_column = 'DATE_START' then
941: --
942: hr_utility.set_location(' Inside Date start ben_abs_trigger', 52);
943: l_changed :=
944: (benutils.column_changed
945: (p_old.date_start,
946: p_new.date_start,

Line 1034: hr_utility.set_location(' ben_abs_trigger', 30);

1030: */
1031: --
1032: end if;
1033: --
1034: hr_utility.set_location(' ben_abs_trigger', 30);
1035: --
1036: l_ptnl_id := 0;
1037: l_ovn :=null;
1038:

Line 1045: hr_utility.set_location('l_rule_output = '|| l_rule_output, 20.01);

1041: -- Whether the rule is mandatory or not, rule output should return 'Y'
1042: -- Rule Mandatory flag is just to override the column data change.
1043:
1044:
1045: hr_utility.set_location('l_rule_output = '|| l_rule_output, 20.01);
1046:
1047:
1048: if l_rule_output = 'Y' and l_rule_overrides_flag = 'Y' then
1049: l_changed := TRUE ;

Line 1054: hr_utility.set_location(' Rule output is N, so we should not trigger LE', 20.01);

1050: elsif l_rule_output = 'Y' and l_rule_overrides_flag = 'N' then
1051: l_changed := l_changed AND TRUE;
1052: elsif l_rule_output = 'N' then
1053: l_changed := FALSE;
1054: hr_utility.set_location(' Rule output is N, so we should not trigger LE', 20.01);
1055: end if;
1056:
1057: hr_utility.set_location('After the rule Check ',20.05);
1058: if l_changed then

Line 1057: hr_utility.set_location('After the rule Check ',20.05);

1053: l_changed := FALSE;
1054: hr_utility.set_location(' Rule output is N, so we should not trigger LE', 20.01);
1055: end if;
1056:
1057: hr_utility.set_location('After the rule Check ',20.05);
1058: if l_changed then
1059: hr_utility.set_location(' l_change TRUE l_rule_overrides_flag '||l_rule_overrides_flag, 20.1);
1060: else
1061: hr_utility.set_location(' l_change FALSE l_rule_overrides_flag '||l_rule_overrides_flag, 20.1);

Line 1059: hr_utility.set_location(' l_change TRUE l_rule_overrides_flag '||l_rule_overrides_flag, 20.1);

1055: end if;
1056:
1057: hr_utility.set_location('After the rule Check ',20.05);
1058: if l_changed then
1059: hr_utility.set_location(' l_change TRUE l_rule_overrides_flag '||l_rule_overrides_flag, 20.1);
1060: else
1061: hr_utility.set_location(' l_change FALSE l_rule_overrides_flag '||l_rule_overrides_flag, 20.1);
1062: end if;
1063: -- Check for Column Mandatory Change

Line 1061: hr_utility.set_location(' l_change FALSE l_rule_overrides_flag '||l_rule_overrides_flag, 20.1);

1057: hr_utility.set_location('After the rule Check ',20.05);
1058: if l_changed then
1059: hr_utility.set_location(' l_change TRUE l_rule_overrides_flag '||l_rule_overrides_flag, 20.1);
1060: else
1061: hr_utility.set_location(' l_change FALSE l_rule_overrides_flag '||l_rule_overrides_flag, 20.1);
1062: end if;
1063: -- Check for Column Mandatory Change
1064: -- If column change is mandatory and data change has failed then dont trigger
1065: -- If column change is non-mandatory and the data change has passed, then trigger.

Line 1068: hr_utility.set_location('Found Mandatory and its failed ', 20.1);

1064: -- If column change is mandatory and data change has failed then dont trigger
1065: -- If column change is non-mandatory and the data change has passed, then trigger.
1066:
1067: if l_chg_mandatory_cd = 'Y' and not l_changed then
1068: hr_utility.set_location('Found Mandatory and its failed ', 20.1);
1069: l_changed := FALSE;
1070: l_trigger := FALSE;
1071: exit;
1072: elsif l_chg_mandatory_cd = 'Y' and l_changed then

Line 1073: hr_utility.set_location('Found Mandatory and its passed ', 20.1);

1069: l_changed := FALSE;
1070: l_trigger := FALSE;
1071: exit;
1072: elsif l_chg_mandatory_cd = 'Y' and l_changed then
1073: hr_utility.set_location('Found Mandatory and its passed ', 20.1);
1074: l_changed := TRUE;
1075: l_trigger := TRUE;
1076: -- exit; */
1077: elsif l_chg_mandatory_cd = 'N' and l_changed then

Line 1078: hr_utility.set_location('Found First Non-Mandatory and its passed ', 20.1);

1074: l_changed := TRUE;
1075: l_trigger := TRUE;
1076: -- exit; */
1077: elsif l_chg_mandatory_cd = 'N' and l_changed then
1078: hr_utility.set_location('Found First Non-Mandatory and its passed ', 20.1);
1079: l_changed := TRUE;
1080: l_trigger := TRUE;
1081: exit;
1082: end if;

Line 1084: hr_utility.set_location('After the Mandatory code check ',20.05);

1080: l_trigger := TRUE;
1081: exit;
1082: end if;
1083:
1084: hr_utility.set_location('After the Mandatory code check ',20.05);
1085: if l_changed then
1086: hr_utility.set_location(' l_change TRUE ', 20.1);
1087: else
1088: hr_utility.set_location(' l_change FALSE ', 20.1);

Line 1086: hr_utility.set_location(' l_change TRUE ', 20.1);

1082: end if;
1083:
1084: hr_utility.set_location('After the Mandatory code check ',20.05);
1085: if l_changed then
1086: hr_utility.set_location(' l_change TRUE ', 20.1);
1087: else
1088: hr_utility.set_location(' l_change FALSE ', 20.1);
1089: end if;
1090: --

Line 1088: hr_utility.set_location(' l_change FALSE ', 20.1);

1084: hr_utility.set_location('After the Mandatory code check ',20.05);
1085: if l_changed then
1086: hr_utility.set_location(' l_change TRUE ', 20.1);
1087: else
1088: hr_utility.set_location(' l_change FALSE ', 20.1);
1089: end if;
1090: --
1091:
1092:

Line 1111: hr_utility.set_location(' Entering: ben_abs_trigger5', 60);

1107: fetch le_exists into l_le_exists;
1108: --
1109: if le_exists%notfound then
1110: --
1111: hr_utility.set_location(' Entering: ben_abs_trigger5', 60);
1112: --
1113: ben_create_ptnl_ler_for_per.create_ptnl_ler_event
1114: --ben_ptnl_ler_for_per_api.create_ptnl_ler_for_per
1115: (p_validate => false

Line 1136: hr_utility.set_location(' Entering: ben_abs_trigger5-', 65);

1132: close le_exists;
1133: --
1134: elsif l_type = 'R' then
1135: --
1136: hr_utility.set_location(' Entering: ben_abs_trigger5-', 65);
1137: --
1138: open get_contacts(nvl(p_new.person_id,p_old.person_id));
1139: --
1140: loop

Line 1151: hr_utility.set_location('Entering: ben_abs_trigger5', 60);

1147: fetch le_exists into l_le_exists;
1148: --
1149: if le_exists%notfound then
1150: --
1151: hr_utility.set_location('Entering: ben_abs_trigger5', 60);
1152: --
1153: ben_create_ptnl_ler_for_per.create_ptnl_ler_event
1154: --ben_ptnl_ler_for_per_api.create_ptnl_ler_for_per
1155: (p_validate => false

Line 1183: hr_utility.set_location(' ben_abs_trigger', 40);

1179: end if;
1180: --
1181: -- reset the variables.
1182: --
1183: hr_utility.set_location(' ben_abs_trigger', 40);
1184: --
1185: l_changed := FALSE;
1186: l_ovn := NULL;
1187: l_effective_start_date := l_session_date;

Line 1199: hr_utility.set_location(' ben_abs_trigger', 50);

1195: end if;
1196: --
1197: end loop;
1198: --
1199: hr_utility.set_location(' ben_abs_trigger', 50);
1200: --
1201: close get_ler;
1202: --
1203: hr_utility.set_location(' leaving ben_abs_trigger', 70);

Line 1203: hr_utility.set_location(' leaving ben_abs_trigger', 70);

1199: hr_utility.set_location(' ben_abs_trigger', 50);
1200: --
1201: close get_ler;
1202: --
1203: hr_utility.set_location(' leaving ben_abs_trigger', 70);
1204: -- hr_utility.trace_off;
1205: end;
1206: --
1207: end ben_abs_ler;

Line 1204: -- hr_utility.trace_off;

1200: --
1201: close get_ler;
1202: --
1203: hr_utility.set_location(' leaving ben_abs_trigger', 70);
1204: -- hr_utility.trace_off;
1205: end;
1206: --
1207: end ben_abs_ler;
1208: