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

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

162: ,status => l_status
163: ,industry => l_industry);
164:
165: begin
166: hr_utility.set_location(' Entering: ben_abv_trigger', 10);
167: l_changed := FALSE;
168: If p_effective_date is not null then
169: l_session_date := p_effective_date ;
170: else

Line 184: hr_utility.set_location('ASSIGNMENT_ID'||p_new.assignment_id,10);

180: close get_system_date;
181: l_effective_start_date := l_session_date;
182: -- l_lf_evt_ocrd_date := l_session_date;
183: --
184: hr_utility.set_location('ASSIGNMENT_ID'||p_new.assignment_id,10);
185: hr_utility.set_location('BUSINESS_GROUP_ID'||p_new.assignment_id,10);
186: hr_utility.set_location('VALUE'||p_new.assignment_id,10);
187: hr_utility.set_location('ASSIGNMENT_BUDGET_VALUE_ID'||p_new.assignment_id,10);
188: hr_utility.set_location('EFFECTIVE_START_DATE'||p_new.assignment_id,10);

Line 185: hr_utility.set_location('BUSINESS_GROUP_ID'||p_new.assignment_id,10);

181: l_effective_start_date := l_session_date;
182: -- l_lf_evt_ocrd_date := l_session_date;
183: --
184: hr_utility.set_location('ASSIGNMENT_ID'||p_new.assignment_id,10);
185: hr_utility.set_location('BUSINESS_GROUP_ID'||p_new.assignment_id,10);
186: hr_utility.set_location('VALUE'||p_new.assignment_id,10);
187: hr_utility.set_location('ASSIGNMENT_BUDGET_VALUE_ID'||p_new.assignment_id,10);
188: hr_utility.set_location('EFFECTIVE_START_DATE'||p_new.assignment_id,10);
189: hr_utility.set_location('EFFECTIVE_END_DATE'||p_new.assignment_id,10);

Line 186: hr_utility.set_location('VALUE'||p_new.assignment_id,10);

182: -- l_lf_evt_ocrd_date := l_session_date;
183: --
184: hr_utility.set_location('ASSIGNMENT_ID'||p_new.assignment_id,10);
185: hr_utility.set_location('BUSINESS_GROUP_ID'||p_new.assignment_id,10);
186: hr_utility.set_location('VALUE'||p_new.assignment_id,10);
187: hr_utility.set_location('ASSIGNMENT_BUDGET_VALUE_ID'||p_new.assignment_id,10);
188: hr_utility.set_location('EFFECTIVE_START_DATE'||p_new.assignment_id,10);
189: hr_utility.set_location('EFFECTIVE_END_DATE'||p_new.assignment_id,10);
190: hr_utility.set_location('sess '||l_session_date, 20);

Line 187: hr_utility.set_location('ASSIGNMENT_BUDGET_VALUE_ID'||p_new.assignment_id,10);

183: --
184: hr_utility.set_location('ASSIGNMENT_ID'||p_new.assignment_id,10);
185: hr_utility.set_location('BUSINESS_GROUP_ID'||p_new.assignment_id,10);
186: hr_utility.set_location('VALUE'||p_new.assignment_id,10);
187: hr_utility.set_location('ASSIGNMENT_BUDGET_VALUE_ID'||p_new.assignment_id,10);
188: hr_utility.set_location('EFFECTIVE_START_DATE'||p_new.assignment_id,10);
189: hr_utility.set_location('EFFECTIVE_END_DATE'||p_new.assignment_id,10);
190: hr_utility.set_location('sess '||l_session_date, 20);
191: hr_utility.set_location('PERSON '||l_person_id, 20);

Line 188: hr_utility.set_location('EFFECTIVE_START_DATE'||p_new.assignment_id,10);

184: hr_utility.set_location('ASSIGNMENT_ID'||p_new.assignment_id,10);
185: hr_utility.set_location('BUSINESS_GROUP_ID'||p_new.assignment_id,10);
186: hr_utility.set_location('VALUE'||p_new.assignment_id,10);
187: hr_utility.set_location('ASSIGNMENT_BUDGET_VALUE_ID'||p_new.assignment_id,10);
188: hr_utility.set_location('EFFECTIVE_START_DATE'||p_new.assignment_id,10);
189: hr_utility.set_location('EFFECTIVE_END_DATE'||p_new.assignment_id,10);
190: hr_utility.set_location('sess '||l_session_date, 20);
191: hr_utility.set_location('PERSON '||l_person_id, 20);
192: hr_utility.set_location('BG '||p_new.business_group_id, 20);

Line 189: hr_utility.set_location('EFFECTIVE_END_DATE'||p_new.assignment_id,10);

185: hr_utility.set_location('BUSINESS_GROUP_ID'||p_new.assignment_id,10);
186: hr_utility.set_location('VALUE'||p_new.assignment_id,10);
187: hr_utility.set_location('ASSIGNMENT_BUDGET_VALUE_ID'||p_new.assignment_id,10);
188: hr_utility.set_location('EFFECTIVE_START_DATE'||p_new.assignment_id,10);
189: hr_utility.set_location('EFFECTIVE_END_DATE'||p_new.assignment_id,10);
190: hr_utility.set_location('sess '||l_session_date, 20);
191: hr_utility.set_location('PERSON '||l_person_id, 20);
192: hr_utility.set_location('BG '||p_new.business_group_id, 20);
193: --

Line 190: hr_utility.set_location('sess '||l_session_date, 20);

186: hr_utility.set_location('VALUE'||p_new.assignment_id,10);
187: hr_utility.set_location('ASSIGNMENT_BUDGET_VALUE_ID'||p_new.assignment_id,10);
188: hr_utility.set_location('EFFECTIVE_START_DATE'||p_new.assignment_id,10);
189: hr_utility.set_location('EFFECTIVE_END_DATE'||p_new.assignment_id,10);
190: hr_utility.set_location('sess '||l_session_date, 20);
191: hr_utility.set_location('PERSON '||l_person_id, 20);
192: hr_utility.set_location('BG '||p_new.business_group_id, 20);
193: --
194: open get_ler(l_status);

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

187: hr_utility.set_location('ASSIGNMENT_BUDGET_VALUE_ID'||p_new.assignment_id,10);
188: hr_utility.set_location('EFFECTIVE_START_DATE'||p_new.assignment_id,10);
189: hr_utility.set_location('EFFECTIVE_END_DATE'||p_new.assignment_id,10);
190: hr_utility.set_location('sess '||l_session_date, 20);
191: hr_utility.set_location('PERSON '||l_person_id, 20);
192: hr_utility.set_location('BG '||p_new.business_group_id, 20);
193: --
194: open get_ler(l_status);
195: loop

Line 192: hr_utility.set_location('BG '||p_new.business_group_id, 20);

188: hr_utility.set_location('EFFECTIVE_START_DATE'||p_new.assignment_id,10);
189: hr_utility.set_location('EFFECTIVE_END_DATE'||p_new.assignment_id,10);
190: hr_utility.set_location('sess '||l_session_date, 20);
191: hr_utility.set_location('PERSON '||l_person_id, 20);
192: hr_utility.set_location('BG '||p_new.business_group_id, 20);
193: --
194: open get_ler(l_status);
195: loop
196: fetch get_ler into l_ler_id,l_typ_cd, l_ocrd_dt_cd;

Line 220: hr_utility.set_location('LER '||l_ler_id, 20);

216: 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;
217: exit when get_ler_col%NOTFOUND;
218: --
219:
220: hr_utility.set_location('LER '||l_ler_id, 20);
221: hr_utility.set_location('COLUMN '||l_column, 20);
222: hr_utility.set_location('NEWVAL '||l_new_val, 20);
223: l_changed := TRUE;
224: if get_ler_col%ROWCOUNT = 1 then

Line 221: hr_utility.set_location('COLUMN '||l_column, 20);

217: exit when get_ler_col%NOTFOUND;
218: --
219:
220: hr_utility.set_location('LER '||l_ler_id, 20);
221: hr_utility.set_location('COLUMN '||l_column, 20);
222: hr_utility.set_location('NEWVAL '||l_new_val, 20);
223: l_changed := TRUE;
224: if get_ler_col%ROWCOUNT = 1 then
225: l_changed := TRUE;

Line 222: hr_utility.set_location('NEWVAL '||l_new_val, 20);

218: --
219:
220: hr_utility.set_location('LER '||l_ler_id, 20);
221: hr_utility.set_location('COLUMN '||l_column, 20);
222: hr_utility.set_location('NEWVAL '||l_new_val, 20);
223: l_changed := TRUE;
224: if get_ler_col%ROWCOUNT = 1 then
225: l_changed := TRUE;
226: hr_utility.set_location('rowcount 1 ', 20);

Line 226: hr_utility.set_location('rowcount 1 ', 20);

222: hr_utility.set_location('NEWVAL '||l_new_val, 20);
223: l_changed := TRUE;
224: if get_ler_col%ROWCOUNT = 1 then
225: l_changed := TRUE;
226: hr_utility.set_location('rowcount 1 ', 20);
227: end if;
228: hr_utility.set_location(' ben_abv_trigger', 20);
229: -- hr_utility.set_location('New'||p_new.person_type_id, 20);
230: -- hr_utility.set_location('New'||p_old.person_type_id, 20);

Line 228: hr_utility.set_location(' ben_abv_trigger', 20);

224: if get_ler_col%ROWCOUNT = 1 then
225: l_changed := TRUE;
226: hr_utility.set_location('rowcount 1 ', 20);
227: end if;
228: hr_utility.set_location(' ben_abv_trigger', 20);
229: -- hr_utility.set_location('New'||p_new.person_type_id, 20);
230: -- hr_utility.set_location('New'||p_old.person_type_id, 20);
231: hr_utility.set_location(' ben_abv_trigger', 20);
232: --

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

225: l_changed := TRUE;
226: hr_utility.set_location('rowcount 1 ', 20);
227: end if;
228: hr_utility.set_location(' ben_abv_trigger', 20);
229: -- hr_utility.set_location('New'||p_new.person_type_id, 20);
230: -- hr_utility.set_location('New'||p_old.person_type_id, 20);
231: hr_utility.set_location(' ben_abv_trigger', 20);
232: --
233: -- Call the formula here to evaluate per_info_chg_cs_ler_rl.

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

226: hr_utility.set_location('rowcount 1 ', 20);
227: end if;
228: hr_utility.set_location(' ben_abv_trigger', 20);
229: -- hr_utility.set_location('New'||p_new.person_type_id, 20);
230: -- hr_utility.set_location('New'||p_old.person_type_id, 20);
231: hr_utility.set_location(' ben_abv_trigger', 20);
232: --
233: -- Call the formula here to evaluate per_info_chg_cs_ler_rl.
234: -- If it returns Y, then see the applicability of the data

Line 231: hr_utility.set_location(' ben_abv_trigger', 20);

227: end if;
228: hr_utility.set_location(' ben_abv_trigger', 20);
229: -- hr_utility.set_location('New'||p_new.person_type_id, 20);
230: -- hr_utility.set_location('New'||p_old.person_type_id, 20);
231: hr_utility.set_location(' ben_abv_trigger', 20);
232: --
233: -- Call the formula here to evaluate per_info_chg_cs_ler_rl.
234: -- If it returns Y, then see the applicability of the data
235: -- changes based on new and old values.

Line 295: hr_utility.set_location(' ben_abv_trigger', 30);

291: benutils.column_changed(p_new.value
292: ,p_old.value,l_old_val) AND
293: (l_changed));
294: end if;
295: hr_utility.set_location(' ben_abv_trigger', 30);
296: --
297: if l_column = 'ASSIGNMENT_BUDGET_VALUE_ID' then
298: l_changed := (benutils.column_changed(p_old.assignment_budget_value_id
299: ,p_new.assignment_budget_value_id,l_new_val) AND

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

312: l_changed := TRUE ;
313: elsif l_rule_output = 'Y' and l_rule_overrides_flag = 'N' then
314: l_changed := l_changed AND TRUE;
315: elsif l_rule_output = 'N' then
316: hr_utility.set_location(' Rule output is N, so we should not trigger LE', 20.01);
317: l_changed := FALSE;
318: end if;
319:
320: hr_utility.set_location('After the rule Check ',20.05);

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

316: hr_utility.set_location(' Rule output is N, so we should not trigger LE', 20.01);
317: l_changed := FALSE;
318: end if;
319:
320: hr_utility.set_location('After the rule Check ',20.05);
321: if l_changed then
322: hr_utility.set_location(' l_change TRUE l_rule_overrides_flag '||l_rule_overrides_flag, 20.1);
323: else
324: hr_utility.set_location(' l_change FALSE l_rule_overrides_flag '||l_rule_overrides_flag, 20.1);

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

318: end if;
319:
320: hr_utility.set_location('After the rule Check ',20.05);
321: if l_changed then
322: hr_utility.set_location(' l_change TRUE l_rule_overrides_flag '||l_rule_overrides_flag, 20.1);
323: else
324: hr_utility.set_location(' l_change FALSE l_rule_overrides_flag '||l_rule_overrides_flag, 20.1);
325: end if;
326: -- Check for Column Mandatory Change

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

320: hr_utility.set_location('After the rule Check ',20.05);
321: if l_changed then
322: hr_utility.set_location(' l_change TRUE l_rule_overrides_flag '||l_rule_overrides_flag, 20.1);
323: else
324: hr_utility.set_location(' l_change FALSE l_rule_overrides_flag '||l_rule_overrides_flag, 20.1);
325: end if;
326: -- Check for Column Mandatory Change
327: -- If column change is mandatory and data change has failed then dont trigger
328: -- If column change is non-mandatory and the data change has passed, then trigger.

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

327: -- If column change is mandatory and data change has failed then dont trigger
328: -- If column change is non-mandatory and the data change has passed, then trigger.
329:
330: if l_chg_mandatory_cd = 'Y' and not l_changed then
331: hr_utility.set_location('Found Mandatory and its failed ', 20.1);
332: l_changed := FALSE;
333: l_trigger := FALSE;
334: exit;
335: elsif l_chg_mandatory_cd = 'Y' and l_changed then

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

332: l_changed := FALSE;
333: l_trigger := FALSE;
334: exit;
335: elsif l_chg_mandatory_cd = 'Y' and l_changed then
336: hr_utility.set_location('Found Mandatory and its passed ', 20.1);
337: l_changed := TRUE;
338: -- exit; */
339: elsif l_chg_mandatory_cd = 'N' and l_changed then
340: hr_utility.set_location('Found First Non-Mandatory and its passed ', 20.1);

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

336: hr_utility.set_location('Found Mandatory and its passed ', 20.1);
337: l_changed := TRUE;
338: -- exit; */
339: elsif l_chg_mandatory_cd = 'N' and l_changed then
340: hr_utility.set_location('Found First Non-Mandatory and its passed ', 20.1);
341: l_changed := TRUE;
342: l_trigger := TRUE;
343: exit;
344: end if;

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

342: l_trigger := TRUE;
343: exit;
344: end if;
345:
346: hr_utility.set_location('After the Mandatory code check ',20.05);
347: if l_changed then
348: hr_utility.set_location(' l_change TRUE ', 20.1);
349: else
350: hr_utility.set_location(' l_change FALSE ', 20.1);

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

344: end if;
345:
346: hr_utility.set_location('After the Mandatory code check ',20.05);
347: if l_changed then
348: hr_utility.set_location(' l_change TRUE ', 20.1);
349: else
350: hr_utility.set_location(' l_change FALSE ', 20.1);
351: end if;
352: --

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

346: hr_utility.set_location('After the Mandatory code check ',20.05);
347: if l_changed then
348: hr_utility.set_location(' l_change TRUE ', 20.1);
349: else
350: hr_utility.set_location(' l_change FALSE ', 20.1);
351: end if;
352: --
353: /* if not l_changed then
354: exit;

Line 356: hr_utility.set_location(' ben_abv_trigger', 40);

352: --
353: /* if not l_changed then
354: exit;
355: end if; */
356: hr_utility.set_location(' ben_abv_trigger', 40);
357: end loop;
358: hr_utility.set_location(' ben_abv_trigger', 50);
359: l_ptnl_id := 0;
360: l_ovn :=null;

Line 358: hr_utility.set_location(' ben_abv_trigger', 50);

354: exit;
355: end if; */
356: hr_utility.set_location(' ben_abv_trigger', 40);
357: end loop;
358: hr_utility.set_location(' ben_abv_trigger', 50);
359: l_ptnl_id := 0;
360: l_ovn :=null;
361: if l_trigger then
362: if l_type = 'P' then

Line 366: hr_utility.set_location(' Entering: ben_abv_trigger5', 60);

362: if l_type = 'P' then
363: open le_exists(l_person_id,l_ler_id,l_lf_evt_ocrd_date);
364: fetch le_exists into l_le_exists;
365: if le_exists%notfound then
366: hr_utility.set_location(' Entering: ben_abv_trigger5', 60);
367:
368: ben_create_ptnl_ler_for_per.create_ptnl_ler_event
369: --ben_ptnl_ler_for_per_api.create_ptnl_ler_for_per
370: (p_validate => false

Line 385: hr_utility.set_location(' Entering: ben_abv_trigger5-', 65);

381: ,p_dtctd_dt => l_effective_start_date);
382: end if;
383: close le_exists;
384: elsif l_type = 'R' then
385: hr_utility.set_location(' Entering: ben_abv_trigger5-', 65);
386: open get_contacts(l_person_id);
387: loop
388: fetch get_contacts into l_hld_person_id;
389: exit when get_contacts%notfound;

Line 393: hr_utility.set_location(' Entering: ben_abv_trigger5', 60);

389: exit when get_contacts%notfound;
390: open le_exists(l_hld_person_id,l_ler_id,l_lf_evt_ocrd_date);
391: fetch le_exists into l_le_exists;
392: if le_exists%notfound then
393: hr_utility.set_location(' Entering: ben_abv_trigger5', 60);
394:
395: ben_create_ptnl_ler_for_per.create_ptnl_ler_event
396: --ben_ptnl_ler_for_per_api.create_ptnl_ler_for_per
397: (p_validate => false

Line 424: hr_utility.set_location(' ben_abv_trigger', 40);

420: end if;
421: --
422: -- reset the variables.
423: --
424: hr_utility.set_location(' ben_abv_trigger', 40);
425: l_changed := FALSE;
426: l_trigger := TRUE;
427: l_ovn := NULL;
428: l_effective_start_date := l_session_date;

Line 433: hr_utility.set_location(' ben_abv_trigger', 50);

429: -- l_lf_evt_ocrd_date := l_session_date;
430: end if;
431: close get_ler_col;
432: end loop;
433: hr_utility.set_location(' ben_abv_trigger', 50);
434: close get_ler;
435: hr_utility.set_location(' leaving ben_abv_trigger', 70);
436: exception
437: when others then

Line 435: hr_utility.set_location(' leaving ben_abv_trigger', 70);

431: close get_ler_col;
432: end loop;
433: hr_utility.set_location(' ben_abv_trigger', 50);
434: close get_ler;
435: hr_utility.set_location(' leaving ben_abv_trigger', 70);
436: exception
437: when others then
438: hr_utility.set_location(sqlerrm, 70);
439: raise;

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

434: close get_ler;
435: hr_utility.set_location(' leaving ben_abv_trigger', 70);
436: exception
437: when others then
438: hr_utility.set_location(sqlerrm, 70);
439: raise;
440: end;
441:
442: end;