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

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

192: ,dep_appl_id =>805
193: ,status => l_status
194: ,industry => l_industry);
195:
196: hr_utility.set_location(' Entering: ben_qua_trigger', 10);
197: l_changed := FALSE;
198:
199: --
200:

Line 249: hr_utility.set_location(' greatest dt '||l_greatest_date, 987);

245: --
246: l_effective_start_date := greatest ( l_effective_start_date, l_person_date);
247: --
248:
249: hr_utility.set_location(' greatest dt '||l_greatest_date, 987);
250:
251: --
252: hr_utility.set_location(' ben_qua_trigger', 20);
253: hr_utility.set_location('sess '||l_session_date, 20);

Line 252: hr_utility.set_location(' ben_qua_trigger', 20);

248:
249: hr_utility.set_location(' greatest dt '||l_greatest_date, 987);
250:
251: --
252: hr_utility.set_location(' ben_qua_trigger', 20);
253: hr_utility.set_location('sess '||l_session_date, 20);
254: hr_utility.set_location('status '||l_status, 20);
255: --
256: open get_ler(l_status);

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

249: hr_utility.set_location(' greatest dt '||l_greatest_date, 987);
250:
251: --
252: hr_utility.set_location(' ben_qua_trigger', 20);
253: hr_utility.set_location('sess '||l_session_date, 20);
254: hr_utility.set_location('status '||l_status, 20);
255: --
256: open get_ler(l_status);
257: loop

Line 254: hr_utility.set_location('status '||l_status, 20);

250:
251: --
252: hr_utility.set_location(' ben_qua_trigger', 20);
253: hr_utility.set_location('sess '||l_session_date, 20);
254: hr_utility.set_location('status '||l_status, 20);
255: --
256: open get_ler(l_status);
257: loop
258: fetch get_ler into l_ler_id,l_typ_cd, l_ocrd_dt_cd;

Line 262: hr_utility.set_location(' ler_id '||l_ler_id, 96);

258: fetch get_ler into l_ler_id,l_typ_cd, l_ocrd_dt_cd;
259: exit when get_ler%notfound;
260: l_trigger := TRUE;
261:
262: hr_utility.set_location(' ler_id '||l_ler_id, 96);
263:
264: if l_ocrd_dt_cd is null then
265: --bug 2850744
266: -- life event occured date is the greater of the person's esd and the start date entered

Line 280: hr_utility.set_location(' returned_date is '||l_lf_evt_ocrd_date, 96);

276: ,p_lf_evt_ocrd_dt => p_new.start_date
277: ,p_returned_date => l_lf_evt_ocrd_date
278: );
279: end if;
280: hr_utility.set_location(' returned_date is '||l_lf_evt_ocrd_date, 96);
281: --
282: open get_ler_col(l_ler_id);
283: loop
284: 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 287: hr_utility.set_location('LER '||l_ler_id, 20);

283: loop
284: 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;
285: exit when get_ler_col%NOTFOUND;
286:
287: hr_utility.set_location('LER '||l_ler_id, 20);
288: hr_utility.set_location('COLUMN '||l_column, 20);
289: hr_utility.set_location('NEWVAL '||l_new_val, 20);
290: hr_utility.set_location('OLDVAL '||l_old_val, 20);
291: hr_utility.set_location('TYPE '||l_type, 20);

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

284: 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;
285: exit when get_ler_col%NOTFOUND;
286:
287: hr_utility.set_location('LER '||l_ler_id, 20);
288: hr_utility.set_location('COLUMN '||l_column, 20);
289: hr_utility.set_location('NEWVAL '||l_new_val, 20);
290: hr_utility.set_location('OLDVAL '||l_old_val, 20);
291: hr_utility.set_location('TYPE '||l_type, 20);
292:

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

285: exit when get_ler_col%NOTFOUND;
286:
287: hr_utility.set_location('LER '||l_ler_id, 20);
288: hr_utility.set_location('COLUMN '||l_column, 20);
289: hr_utility.set_location('NEWVAL '||l_new_val, 20);
290: hr_utility.set_location('OLDVAL '||l_old_val, 20);
291: hr_utility.set_location('TYPE '||l_type, 20);
292:
293: l_changed := TRUE;

Line 290: hr_utility.set_location('OLDVAL '||l_old_val, 20);

286:
287: hr_utility.set_location('LER '||l_ler_id, 20);
288: hr_utility.set_location('COLUMN '||l_column, 20);
289: hr_utility.set_location('NEWVAL '||l_new_val, 20);
290: hr_utility.set_location('OLDVAL '||l_old_val, 20);
291: hr_utility.set_location('TYPE '||l_type, 20);
292:
293: l_changed := TRUE;
294: if get_ler_col%ROWCOUNT = 1 then

Line 291: hr_utility.set_location('TYPE '||l_type, 20);

287: hr_utility.set_location('LER '||l_ler_id, 20);
288: hr_utility.set_location('COLUMN '||l_column, 20);
289: hr_utility.set_location('NEWVAL '||l_new_val, 20);
290: hr_utility.set_location('OLDVAL '||l_old_val, 20);
291: hr_utility.set_location('TYPE '||l_type, 20);
292:
293: l_changed := TRUE;
294: if get_ler_col%ROWCOUNT = 1 then
295: hr_utility.set_location('rowcount 1 ', 20);

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

291: hr_utility.set_location('TYPE '||l_type, 20);
292:
293: l_changed := TRUE;
294: if get_ler_col%ROWCOUNT = 1 then
295: hr_utility.set_location('rowcount 1 ', 20);
296: l_changed := TRUE;
297: end if;
298: hr_utility.set_location(' ben_qua_trigger', 50);
299: -- Call the formula here to evaluate per_info_chg_cs_ler_rl.

Line 298: hr_utility.set_location(' ben_qua_trigger', 50);

294: if get_ler_col%ROWCOUNT = 1 then
295: hr_utility.set_location('rowcount 1 ', 20);
296: l_changed := TRUE;
297: end if;
298: hr_utility.set_location(' ben_qua_trigger', 50);
299: -- Call the formula here to evaluate per_info_chg_cs_ler_rl.
300: -- If it returns Y, then see the applicability of the data
301: -- changes based on new and old values.
302: --

Line 519: hr_utility.set_location(' ben_qua_trigger'|| ' l_rule_output = ' || l_rule_output, 9999);

515: p_ret_val => l_rule_output);
516: --
517: end if;
518: --
519: hr_utility.set_location(' ben_qua_trigger'|| ' l_rule_output = ' || l_rule_output, 9999);
520:
521:
522: if l_column = 'START_DATE' then
523: hr_utility.set_location('Old Start Date '||p_old.start_date,10);

Line 523: hr_utility.set_location('Old Start Date '||p_old.start_date,10);

519: hr_utility.set_location(' ben_qua_trigger'|| ' l_rule_output = ' || l_rule_output, 9999);
520:
521:
522: if l_column = 'START_DATE' then
523: hr_utility.set_location('Old Start Date '||p_old.start_date,10);
524: hr_utility.set_location('New Start Date '||p_new.start_date,10);
525: l_changed := (benutils.column_changed(p_old.start_date
526: ,p_new.start_date,l_new_val) AND
527: benutils.column_changed(p_new.start_date

Line 524: hr_utility.set_location('New Start Date '||p_new.start_date,10);

520:
521:
522: if l_column = 'START_DATE' then
523: hr_utility.set_location('Old Start Date '||p_old.start_date,10);
524: hr_utility.set_location('New Start Date '||p_new.start_date,10);
525: l_changed := (benutils.column_changed(p_old.start_date
526: ,p_new.start_date,l_new_val) AND
527: benutils.column_changed(p_new.start_date
528: ,p_old.start_date,l_old_val) AND

Line 563: hr_utility.set_location('NEW DOB'||p_new.qualification_type_id, 50);

559: ,p_new.qualification_type_id,l_new_val) AND
560: benutils.column_changed(p_new.qualification_type_id
561: ,p_old.qualification_type_id,l_old_val) AND
562: (l_changed));
563: hr_utility.set_location('NEW DOB'||p_new.qualification_type_id, 50);
564: hr_utility.set_location('OLD DOB'||p_old.qualification_type_id, 50);
565: hr_utility.set_location(' ben_qua_trigger', 60);
566: end if;
567: --

Line 564: hr_utility.set_location('OLD DOB'||p_old.qualification_type_id, 50);

560: benutils.column_changed(p_new.qualification_type_id
561: ,p_old.qualification_type_id,l_old_val) AND
562: (l_changed));
563: hr_utility.set_location('NEW DOB'||p_new.qualification_type_id, 50);
564: hr_utility.set_location('OLD DOB'||p_old.qualification_type_id, 50);
565: hr_utility.set_location(' ben_qua_trigger', 60);
566: end if;
567: --
568: if l_column = 'TITLE' then

Line 565: hr_utility.set_location(' ben_qua_trigger', 60);

561: ,p_old.qualification_type_id,l_old_val) AND
562: (l_changed));
563: hr_utility.set_location('NEW DOB'||p_new.qualification_type_id, 50);
564: hr_utility.set_location('OLD DOB'||p_old.qualification_type_id, 50);
565: hr_utility.set_location(' ben_qua_trigger', 60);
566: end if;
567: --
568: if l_column = 'TITLE' then
569: l_changed := (benutils.column_changed(p_old.title

Line 583: hr_utility.set_location(' ben_qua_trigger', 210);

579: ,p_new.attribute1,l_new_val) AND
580: benutils.column_changed(p_new.attribute1
581: ,p_old.attribute1,l_old_val) AND
582: (l_changed));
583: hr_utility.set_location(' ben_qua_trigger', 210);
584: hr_utility.set_location('NEW A1'||p_new.attribute1, 50);
585: hr_utility.set_location('OLD A1'||p_old.attribute1, 50);
586: end if;
587: --

Line 584: hr_utility.set_location('NEW A1'||p_new.attribute1, 50);

580: benutils.column_changed(p_new.attribute1
581: ,p_old.attribute1,l_old_val) AND
582: (l_changed));
583: hr_utility.set_location(' ben_qua_trigger', 210);
584: hr_utility.set_location('NEW A1'||p_new.attribute1, 50);
585: hr_utility.set_location('OLD A1'||p_old.attribute1, 50);
586: end if;
587: --
588: if l_column = 'ATTRIBUTE2' then

Line 585: hr_utility.set_location('OLD A1'||p_old.attribute1, 50);

581: ,p_old.attribute1,l_old_val) AND
582: (l_changed));
583: hr_utility.set_location(' ben_qua_trigger', 210);
584: hr_utility.set_location('NEW A1'||p_new.attribute1, 50);
585: hr_utility.set_location('OLD A1'||p_old.attribute1, 50);
586: end if;
587: --
588: if l_column = 'ATTRIBUTE2' then
589: l_changed := (benutils.column_changed(p_old.attribute2

Line 594: hr_utility.set_location(' ben_qua_trigger', 220);

590: ,p_new.attribute2,l_new_val) AND
591: benutils.column_changed(p_new.attribute2
592: ,p_old.attribute2,l_old_val) AND
593: (l_changed));
594: hr_utility.set_location(' ben_qua_trigger', 220);
595: end if;
596: --
597: if l_column = 'ATTRIBUTE3' then
598: l_changed := (benutils.column_changed(p_old.attribute3

Line 603: hr_utility.set_location(' ben_qua_trigger', 230);

599: ,p_new.attribute3,l_new_val) AND
600: benutils.column_changed(p_new.attribute3
601: ,p_old.attribute3,l_old_val) AND
602: (l_changed));
603: hr_utility.set_location(' ben_qua_trigger', 230);
604: end if;
605: --
606: if l_column = 'ATTRIBUTE4' then
607: l_changed := (benutils.column_changed(p_old.attribute4

Line 612: hr_utility.set_location(' ben_qua_trigger', 240);

608: ,p_new.attribute4,l_new_val) AND
609: benutils.column_changed(p_new.attribute4
610: ,p_old.attribute4,l_old_val) AND
611: (l_changed));
612: hr_utility.set_location(' ben_qua_trigger', 240);
613: end if;
614: --
615: if l_column = 'ATTRIBUTE5' then
616: l_changed := (benutils.column_changed(p_old.attribute5

Line 621: hr_utility.set_location(' ben_qua_trigger', 250);

617: ,p_new.attribute5,l_new_val) AND
618: benutils.column_changed(p_new.attribute5
619: ,p_old.attribute5,l_old_val) AND
620: (l_changed));
621: hr_utility.set_location(' ben_qua_trigger', 250);
622: end if;
623: --
624: if l_column = 'ATTRIBUTE6' then
625: l_changed := (benutils.column_changed(p_old.attribute6

Line 630: hr_utility.set_location(' ben_qua_trigger', 260);

626: ,p_new.attribute6,l_new_val) AND
627: benutils.column_changed(p_new.attribute6
628: ,p_old.attribute6,l_old_val) AND
629: (l_changed));
630: hr_utility.set_location(' ben_qua_trigger', 260);
631: end if;
632: --
633: if l_column = 'ATTRIBUTE7' then
634: l_changed := (benutils.column_changed(p_old.attribute7

Line 639: hr_utility.set_location(' ben_qua_trigger', 270);

635: ,p_new.attribute7,l_new_val) AND
636: benutils.column_changed(p_new.attribute7
637: ,p_old.attribute7,l_old_val) AND
638: (l_changed));
639: hr_utility.set_location(' ben_qua_trigger', 270);
640: end if;
641: --
642: if l_column = 'ATTRIBUTE8' then
643: l_changed := (benutils.column_changed(p_old.attribute8

Line 648: hr_utility.set_location(' ben_qua_trigger', 280);

644: ,p_new.attribute8,l_new_val) AND
645: benutils.column_changed(p_new.attribute8
646: ,p_old.attribute8,l_old_val) AND
647: (l_changed));
648: hr_utility.set_location(' ben_qua_trigger', 280);
649: end if;
650: --
651: if l_column = 'ATTRIBUTE9' then
652: l_changed := (benutils.column_changed(p_old.attribute9

Line 657: hr_utility.set_location(' ben_qua_trigger', 290);

653: ,p_new.attribute9,l_new_val) AND
654: benutils.column_changed(p_new.attribute9
655: ,p_old.attribute9,l_old_val) AND
656: (l_changed));
657: hr_utility.set_location(' ben_qua_trigger', 290);
658: end if;
659: --
660: if l_column = 'ATTRIBUTE10' then
661: l_changed := (benutils.column_changed(p_old.attribute10

Line 666: hr_utility.set_location(' ben_qua_trigger', 300);

662: ,p_new.attribute10,l_new_val) AND
663: benutils.column_changed(p_new.attribute10
664: ,p_old.attribute10,l_old_val) AND
665: (l_changed));
666: hr_utility.set_location(' ben_qua_trigger', 300);
667: end if;
668: --
669: if l_column = 'ATTRIBUTE11' then
670: l_changed := (benutils.column_changed(p_old.attribute11

Line 675: hr_utility.set_location(' ben_qua_trigger', 310);

671: ,p_new.attribute11,l_new_val) AND
672: benutils.column_changed(p_new.attribute11
673: ,p_old.attribute11,l_old_val) AND
674: (l_changed));
675: hr_utility.set_location(' ben_qua_trigger', 310);
676: end if;
677: --
678: if l_column = 'ATTRIBUTE12' then
679: l_changed := (benutils.column_changed(p_old.attribute12

Line 684: hr_utility.set_location(' ben_qua_trigger', 320);

680: ,p_new.attribute12,l_new_val) AND
681: benutils.column_changed(p_new.attribute12
682: ,p_old.attribute12,l_old_val) AND
683: (l_changed));
684: hr_utility.set_location(' ben_qua_trigger', 320);
685: end if;
686: --
687: if l_column = 'ATTRIBUTE13' then
688: l_changed := (benutils.column_changed(p_old.attribute13

Line 693: hr_utility.set_location(' ben_qua_trigger', 330);

689: ,p_new.attribute13,l_new_val) AND
690: benutils.column_changed(p_new.attribute13
691: ,p_old.attribute13,l_old_val) AND
692: (l_changed));
693: hr_utility.set_location(' ben_qua_trigger', 330);
694: end if;
695: --
696: if l_column = 'ATTRIBUTE14' then
697: l_changed := (benutils.column_changed(p_old.attribute14

Line 702: hr_utility.set_location(' ben_qua_trigger', 340);

698: ,p_new.attribute14,l_new_val) AND
699: benutils.column_changed(p_new.attribute14
700: ,p_old.attribute14,l_old_val) AND
701: (l_changed));
702: hr_utility.set_location(' ben_qua_trigger', 340);
703: end if;
704: --
705: if l_column = 'ATTRIBUTE15' then
706: l_changed := (benutils.column_changed(p_old.attribute15

Line 711: hr_utility.set_location(' ben_qua_trigger', 350);

707: ,p_new.attribute15,l_new_val) AND
708: benutils.column_changed(p_new.attribute15
709: ,p_old.attribute15,l_old_val) AND
710: (l_changed));
711: hr_utility.set_location(' ben_qua_trigger', 350);
712: end if;
713: --
714: if l_column = 'ATTRIBUTE16' then
715: l_changed := (benutils.column_changed(p_old.attribute16

Line 720: hr_utility.set_location(' ben_qua_trigger', 360);

716: ,p_new.attribute16,l_new_val) AND
717: benutils.column_changed(p_new.attribute16
718: ,p_old.attribute16,l_old_val) AND
719: (l_changed));
720: hr_utility.set_location(' ben_qua_trigger', 360);
721: end if;
722: --
723: if l_column = 'ATTRIBUTE17' then
724: l_changed := (benutils.column_changed(p_old.attribute17

Line 729: hr_utility.set_location(' ben_qua_trigger', 370);

725: ,p_new.attribute17,l_new_val) AND
726: benutils.column_changed(p_new.attribute17
727: ,p_old.attribute17,l_old_val) AND
728: (l_changed));
729: hr_utility.set_location(' ben_qua_trigger', 370);
730: end if;
731: --
732: if l_column = 'ATTRIBUTE18' then
733: l_changed := (benutils.column_changed(p_old.attribute18

Line 738: hr_utility.set_location(' ben_qua_trigger', 380);

734: ,p_new.attribute18,l_new_val) AND
735: benutils.column_changed(p_new.attribute18
736: ,p_old.attribute18,l_old_val) AND
737: (l_changed));
738: hr_utility.set_location(' ben_qua_trigger', 380);
739: end if;
740: --
741: if l_column = 'ATTRIBUTE19' then
742: l_changed := (benutils.column_changed(p_old.attribute19

Line 747: hr_utility.set_location(' ben_qua_trigger', 390);

743: ,p_new.attribute19,l_new_val) AND
744: benutils.column_changed(p_new.attribute19
745: ,p_old.attribute19,l_old_val) AND
746: (l_changed));
747: hr_utility.set_location(' ben_qua_trigger', 390);
748: end if;
749: --
750: if l_column = 'ATTRIBUTE20' then
751: l_changed := (benutils.column_changed(p_old.attribute20

Line 756: hr_utility.set_location(' ben_qua_trigger', 400);

752: ,p_new.attribute20,l_new_val) AND
753: benutils.column_changed(p_new.attribute20
754: ,p_old.attribute20,l_old_val) AND
755: (l_changed));
756: hr_utility.set_location(' ben_qua_trigger', 400);
757: end if;
758: --
759: --
760: --

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

766: l_changed := TRUE ;
767: elsif l_rule_output = 'Y' and l_rule_overrides_flag = 'N' then
768: l_changed := l_changed AND TRUE;
769: elsif l_rule_output = 'N' then
770: hr_utility.set_location(' Rule output is N, so we should not trigger LE', 20.01);
771: l_changed := FALSE;
772: end if;
773:
774: hr_utility.set_location('After the rule Check ',20.05);

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

770: hr_utility.set_location(' Rule output is N, so we should not trigger LE', 20.01);
771: l_changed := FALSE;
772: end if;
773:
774: hr_utility.set_location('After the rule Check ',20.05);
775: if l_changed then
776: hr_utility.set_location(' l_change TRUE l_rule_overrides_flag '||l_rule_overrides_flag, 20.1);
777: else
778: hr_utility.set_location(' l_change FALSE l_rule_overrides_flag '||l_rule_overrides_flag, 20.1);

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

772: end if;
773:
774: hr_utility.set_location('After the rule Check ',20.05);
775: if l_changed then
776: hr_utility.set_location(' l_change TRUE l_rule_overrides_flag '||l_rule_overrides_flag, 20.1);
777: else
778: hr_utility.set_location(' l_change FALSE l_rule_overrides_flag '||l_rule_overrides_flag, 20.1);
779: end if;
780: -- Check for Column Mandatory Change

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

774: hr_utility.set_location('After the rule Check ',20.05);
775: if l_changed then
776: hr_utility.set_location(' l_change TRUE l_rule_overrides_flag '||l_rule_overrides_flag, 20.1);
777: else
778: hr_utility.set_location(' l_change FALSE l_rule_overrides_flag '||l_rule_overrides_flag, 20.1);
779: end if;
780: -- Check for Column Mandatory Change
781: -- If column change is mandatory and data change has failed then dont trigger
782: -- If column change is non-mandatory and the data change has passed, then trigger.

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

781: -- If column change is mandatory and data change has failed then dont trigger
782: -- If column change is non-mandatory and the data change has passed, then trigger.
783:
784: if l_chg_mandatory_cd = 'Y' and not l_changed then
785: hr_utility.set_location('Found Mandatory and its failed ', 20.1);
786: l_changed := FALSE;
787: l_trigger := FALSE;
788: exit;
789: elsif l_chg_mandatory_cd = 'Y' and l_changed then

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

786: l_changed := FALSE;
787: l_trigger := FALSE;
788: exit;
789: elsif l_chg_mandatory_cd = 'Y' and l_changed then
790: hr_utility.set_location('Found Mandatory and its passed ', 20.1);
791: l_changed := TRUE;
792: -- exit; */
793: elsif l_chg_mandatory_cd = 'N' and l_changed then
794: hr_utility.set_location('Found First Non-Mandatory and its passed ', 20.1);

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

790: hr_utility.set_location('Found Mandatory and its passed ', 20.1);
791: l_changed := TRUE;
792: -- exit; */
793: elsif l_chg_mandatory_cd = 'N' and l_changed then
794: hr_utility.set_location('Found First Non-Mandatory and its passed ', 20.1);
795: l_changed := TRUE;
796: l_trigger := TRUE;
797: exit;
798: end if;

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

796: l_trigger := TRUE;
797: exit;
798: end if;
799:
800: hr_utility.set_location('After the Mandatory code check ',20.05);
801: if l_changed then
802: hr_utility.set_location(' l_change TRUE ', 20.1);
803: else
804: hr_utility.set_location(' l_change FALSE ', 20.1);

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

798: end if;
799:
800: hr_utility.set_location('After the Mandatory code check ',20.05);
801: if l_changed then
802: hr_utility.set_location(' l_change TRUE ', 20.1);
803: else
804: hr_utility.set_location(' l_change FALSE ', 20.1);
805: end if;
806: --

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

800: hr_utility.set_location('After the Mandatory code check ',20.05);
801: if l_changed then
802: hr_utility.set_location(' l_change TRUE ', 20.1);
803: else
804: hr_utility.set_location(' l_change FALSE ', 20.1);
805: end if;
806: --
807: /* if not l_changed then
808: exit;

Line 811: hr_utility.set_location(' ben_qua_trigger', 30);

807: /* if not l_changed then
808: exit;
809: end if; */
810: end loop;
811: hr_utility.set_location(' ben_qua_trigger', 30);
812: l_ptnl_id := 0;
813: l_ovn :=null;
814: if l_trigger then
815: --

Line 828: hr_utility.set_location(' Entering: ben_qua_trigger5', 60);

824: -- type exists do nothing.
825: --
826: if le_exists%notfound then
827: --
828: hr_utility.set_location(' Entering: ben_qua_trigger5', 60);
829: ben_create_ptnl_ler_for_per.create_ptnl_ler_event
830: --ben_ptnl_ler_for_per_api.create_ptnl_ler_for_per
831: (p_validate => false
832: ,p_ptnl_ler_for_per_id => l_ptnl_id

Line 846: hr_utility.set_location(' Entering: ben_qua_trigger5-rp', 65);

842: ,p_dtctd_dt => l_lf_evt_ocrd_date);
843: end if;
844: close le_exists;
845: elsif l_type = 'R' then
846: hr_utility.set_location(' Entering: ben_qua_trigger5-rp', 65);
847: --
848: -- Related Life event has occured for Participant contacts
849: --
850: open get_contacts(l_person_id); -- p_new.person_id);

Line 860: hr_utility.set_location(' Entering: ben_qua_trigger5', 60);

856: --
857: -- If potential life event does not already exist
858: -- create it.
859: if le_exists%notfound then
860: hr_utility.set_location(' Entering: ben_qua_trigger5', 60);
861:
862: ben_create_ptnl_ler_for_per.create_ptnl_ler_event
863: --ben_ptnl_ler_for_per_api.create_ptnl_ler_for_per
864: (p_validate => false

Line 886: hr_utility.set_location(' ben_qua_trigger', 40);

882: end if;
883: --
884: -- reset the variables.
885: --
886: hr_utility.set_location(' ben_qua_trigger', 40);
887: l_changed := FALSE;
888: l_trigger := TRUE;
889: l_ovn := NULL;
890:

Line 894: hr_utility.set_location(' ben_qua_trigger', 180);

890:
891: end if;
892: close get_ler_col;
893: end loop;
894: hr_utility.set_location(' ben_qua_trigger', 180);
895: close get_ler;
896: hr_utility.set_location(' Leaving: ben_qua_trigger', 200);
897:
898: end;

Line 896: hr_utility.set_location(' Leaving: ben_qua_trigger', 200);

892: close get_ler_col;
893: end loop;
894: hr_utility.set_location(' ben_qua_trigger', 180);
895: close get_ler;
896: hr_utility.set_location(' Leaving: ben_qua_trigger', 200);
897:
898: end;
899: end ben_qua_ler;