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

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

148: end if;
149: --
150: -- End of Bug 3320133
151:
152: hr_utility.set_location(' Entering: ben_eev_trigger', 10);
153:
154: l_bool :=fnd_installation.get(appl_id => 805
155: ,dep_appl_id =>805
156: ,status => l_status

Line 180: hr_utility.set_location('DR system date '||l_lf_evt_ocrd_date, 20);

176: exit when get_ler%notfound;
177: l_trigger := TRUE;
178: if (l_ocrd_dt_cd = 'DR') and (l_system_date > l_session_date) then
179: l_lf_evt_ocrd_date := l_system_date;
180: hr_utility.set_location('DR system date '||l_lf_evt_ocrd_date, 20);
181: else
182: l_lf_evt_ocrd_date := l_session_date;
183: hr_utility.set_location('session date '||l_lf_evt_ocrd_date, 20);
184: end if;

Line 183: hr_utility.set_location('session date '||l_lf_evt_ocrd_date, 20);

179: l_lf_evt_ocrd_date := l_system_date;
180: hr_utility.set_location('DR system date '||l_lf_evt_ocrd_date, 20);
181: else
182: l_lf_evt_ocrd_date := l_session_date;
183: hr_utility.set_location('session date '||l_lf_evt_ocrd_date, 20);
184: end if;
185: open get_ler_col(l_ler_id);
186: loop
187: fetch get_ler_col into l_column,l_new_val, l_old_val, l_type, l_per_info_chg_cs_ler_rl, l_rule_overrides_flag, l_chg_mandatory_cd;

Line 193: hr_utility.set_location(' ben_eev_trigger', 20);

189: l_changed := TRUE;
190: if get_ler_col%ROWCOUNT = 1 then
191: l_changed := TRUE;
192: end if;
193: hr_utility.set_location(' ben_eev_trigger', 20);
194: -- hr_utility.set_location('New'||p_new.person_type_id, 20);
195: -- hr_utility.set_location('New'||p_old.person_type_id, 20);
196: hr_utility.set_location(' ben_eev_trigger', 20);
197: --

Line 194: -- hr_utility.set_location('New'||p_new.person_type_id, 20);

190: if get_ler_col%ROWCOUNT = 1 then
191: l_changed := TRUE;
192: end if;
193: hr_utility.set_location(' ben_eev_trigger', 20);
194: -- hr_utility.set_location('New'||p_new.person_type_id, 20);
195: -- hr_utility.set_location('New'||p_old.person_type_id, 20);
196: hr_utility.set_location(' ben_eev_trigger', 20);
197: --
198: -- Call the formula here to evaluate per_info_chg_cs_ler_rl.

Line 195: -- hr_utility.set_location('New'||p_old.person_type_id, 20);

191: l_changed := TRUE;
192: end if;
193: hr_utility.set_location(' ben_eev_trigger', 20);
194: -- hr_utility.set_location('New'||p_new.person_type_id, 20);
195: -- hr_utility.set_location('New'||p_old.person_type_id, 20);
196: hr_utility.set_location(' ben_eev_trigger', 20);
197: --
198: -- Call the formula here to evaluate per_info_chg_cs_ler_rl.
199: -- If it returns Y, then see the applicability of the data

Line 196: hr_utility.set_location(' ben_eev_trigger', 20);

192: end if;
193: hr_utility.set_location(' ben_eev_trigger', 20);
194: -- hr_utility.set_location('New'||p_new.person_type_id, 20);
195: -- hr_utility.set_location('New'||p_old.person_type_id, 20);
196: hr_utility.set_location(' ben_eev_trigger', 20);
197: --
198: -- Call the formula here to evaluate per_info_chg_cs_ler_rl.
199: -- If it returns Y, then see the applicability of the data
200: -- changes based on new and old values.

Line 228: hr_utility.set_location(' ben_eev_trigger', 30);

224: benutils.column_changed(p_new.screen_entry_value
225: ,p_old.screen_entry_value,l_old_val) AND
226: (l_changed));
227: end if;
228: hr_utility.set_location(' ben_eev_trigger', 30);
229: --
230:
231: --
232: -- Checking the rule output and the rule override flag.

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

237: l_changed := TRUE ;
238: elsif l_rule_output = 'Y' and l_rule_overrides_flag = 'N' then
239: l_changed := l_changed AND TRUE;
240: elsif l_rule_output = 'N' then
241: hr_utility.set_location(' Rule output is N, so we should not trigger LE', 20.01);
242: l_changed := FALSE;
243: end if;
244:
245: hr_utility.set_location('After the rule Check ',20.05);

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

241: hr_utility.set_location(' Rule output is N, so we should not trigger LE', 20.01);
242: l_changed := FALSE;
243: end if;
244:
245: hr_utility.set_location('After the rule Check ',20.05);
246: if l_changed then
247: hr_utility.set_location(' l_change TRUE l_rule_overrides_flag '||l_rule_overrides_flag, 20.1);
248: else
249: hr_utility.set_location(' l_change FALSE l_rule_overrides_flag '||l_rule_overrides_flag, 20.1);

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

243: end if;
244:
245: hr_utility.set_location('After the rule Check ',20.05);
246: if l_changed then
247: hr_utility.set_location(' l_change TRUE l_rule_overrides_flag '||l_rule_overrides_flag, 20.1);
248: else
249: hr_utility.set_location(' l_change FALSE l_rule_overrides_flag '||l_rule_overrides_flag, 20.1);
250: end if;
251: -- Check for Column Mandatory Change

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

245: hr_utility.set_location('After the rule Check ',20.05);
246: if l_changed then
247: hr_utility.set_location(' l_change TRUE l_rule_overrides_flag '||l_rule_overrides_flag, 20.1);
248: else
249: hr_utility.set_location(' l_change FALSE l_rule_overrides_flag '||l_rule_overrides_flag, 20.1);
250: end if;
251: -- Check for Column Mandatory Change
252: -- If column change is mandatory and data change has failed then dont trigger
253: -- If column change is non-mandatory and the data change has passed, then trigger.

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

252: -- If column change is mandatory and data change has failed then dont trigger
253: -- If column change is non-mandatory and the data change has passed, then trigger.
254:
255: if l_chg_mandatory_cd = 'Y' and not l_changed then
256: hr_utility.set_location('Found Mandatory and its failed ', 20.1);
257: l_changed := FALSE;
258: l_trigger := FALSE;
259: exit;
260: elsif l_chg_mandatory_cd = 'Y' and l_changed then

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

257: l_changed := FALSE;
258: l_trigger := FALSE;
259: exit;
260: elsif l_chg_mandatory_cd = 'Y' and l_changed then
261: hr_utility.set_location('Found Mandatory and its passed ', 20.1);
262: l_changed := TRUE;
263: -- exit; */
264: elsif l_chg_mandatory_cd = 'N' and l_changed then
265: hr_utility.set_location('Found First Non-Mandatory and its passed ', 20.1);

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

261: hr_utility.set_location('Found Mandatory and its passed ', 20.1);
262: l_changed := TRUE;
263: -- exit; */
264: elsif l_chg_mandatory_cd = 'N' and l_changed then
265: hr_utility.set_location('Found First Non-Mandatory and its passed ', 20.1);
266: l_changed := TRUE;
267: l_trigger := TRUE;
268: exit;
269: end if;

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

268: exit;
269: end if;
270:
271:
272: hr_utility.set_location('After the Mandatory code check ',20.05);
273: if l_changed then
274: hr_utility.set_location(' l_change TRUE ', 20.1);
275: else
276: hr_utility.set_location(' l_change FALSE ', 20.1);

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

270:
271:
272: hr_utility.set_location('After the Mandatory code check ',20.05);
273: if l_changed then
274: hr_utility.set_location(' l_change TRUE ', 20.1);
275: else
276: hr_utility.set_location(' l_change FALSE ', 20.1);
277: end if;
278: --

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

272: hr_utility.set_location('After the Mandatory code check ',20.05);
273: if l_changed then
274: hr_utility.set_location(' l_change TRUE ', 20.1);
275: else
276: hr_utility.set_location(' l_change FALSE ', 20.1);
277: end if;
278: --
279: /* if not l_changed then
280: exit;

Line 284: hr_utility.set_location(' ben_eev_trigger', 50);

280: exit;
281: end if; */
282: --
283: end loop;
284: hr_utility.set_location(' ben_eev_trigger', 50);
285: l_ptnl_id := 0;
286: l_ovn :=null;
287: if l_trigger then
288: if l_type = 'P' then

Line 292: hr_utility.set_location(' Entering: ben_eev_trigger5', 60);

288: if l_type = 'P' then
289: open le_exists(l_person_id,l_ler_id,l_lf_evt_ocrd_date);
290: fetch le_exists into l_le_exists;
291: if le_exists%notfound then
292: hr_utility.set_location(' Entering: ben_eev_trigger5', 60);
293:
294: ben_create_ptnl_ler_for_per.create_ptnl_ler_event
295: -- ben_ptnl_ler_for_per_api.create_ptnl_ler_for_per
296: (p_validate => false

Line 311: hr_utility.set_location(' Entering: ben_eev_trigger5-', 65);

307: ,p_dtctd_dt => l_effective_start_date);
308: end if;
309: close le_exists;
310: elsif l_type = 'R' then
311: hr_utility.set_location(' Entering: ben_eev_trigger5-', 65);
312: open get_contacts(l_person_id);
313: loop
314: fetch get_contacts into l_hld_person_id;
315: exit when get_contacts%notfound;

Line 319: hr_utility.set_location(' Entering: ben_eev_trigger5', 60);

315: exit when get_contacts%notfound;
316: open le_exists(l_hld_person_id,l_ler_id,l_lf_evt_ocrd_date);
317: fetch le_exists into l_le_exists;
318: if le_exists%notfound then
319: hr_utility.set_location(' Entering: ben_eev_trigger5', 60);
320: ben_create_ptnl_ler_for_per.create_ptnl_ler_event
321: -- ben_ptnl_ler_for_per_api.create_ptnl_ler_for_per
322: (p_validate => false
323: ,p_ptnl_ler_for_per_id => l_ptnl_id

Line 345: hr_utility.set_location(' ben_eev_trigger', 40);

341: end if;
342: --
343: -- reset the variables.
344: --
345: hr_utility.set_location(' ben_eev_trigger', 40);
346: l_changed := FALSE;
347: l_trigger := TRUE;
348: l_ovn := NULL;
349: l_effective_start_date := l_session_date;

Line 354: hr_utility.set_location(' ben_eev_trigger', 50);

350: -- l_lf_evt_ocrd_date := l_session_date;
351: end if;
352: close get_ler_col;
353: end loop;
354: hr_utility.set_location(' ben_eev_trigger', 50);
355: close get_ler;
356: hr_utility.set_location(' leaving ben_eev_trigger', 70);
357: exception
358: when others then

Line 356: hr_utility.set_location(' leaving ben_eev_trigger', 70);

352: close get_ler_col;
353: end loop;
354: hr_utility.set_location(' ben_eev_trigger', 50);
355: close get_ler;
356: hr_utility.set_location(' leaving ben_eev_trigger', 70);
357: exception
358: when others then
359: hr_utility.set_location(sqlerrm, 70);
360: raise;

Line 359: hr_utility.set_location(sqlerrm, 70);

355: close get_ler;
356: hr_utility.set_location(' leaving ben_eev_trigger', 70);
357: exception
358: when others then
359: hr_utility.set_location(sqlerrm, 70);
360: raise;
361: end;
362: end ben_eev_ler;