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

Line 164: hr_utility.set_location(' Entering: ben_ppr_trigger', 10);

160: ,dep_appl_id =>805
161: ,status => l_status
162: ,industry => l_industry);
163:
164: hr_utility.set_location(' Entering: ben_ppr_trigger', 10);
165: l_changed := FALSE;
166:
167: --
168: If p_effective_date is not null then

Line 178: hr_utility.set_location('p_new.review_date is'||p_new.review_date, 999);

174: end if;
175:
176:
177: --
178: hr_utility.set_location('p_new.review_date is'||p_new.review_date, 999);
179: hr_utility.set_location('l_session_date is'||l_session_date, 999);
180: --
181: l_effective_start_date := l_session_date;
182: --

Line 179: hr_utility.set_location('l_session_date is'||l_session_date, 999);

175:
176:
177: --
178: hr_utility.set_location('p_new.review_date is'||p_new.review_date, 999);
179: hr_utility.set_location('l_session_date is'||l_session_date, 999);
180: --
181: l_effective_start_date := l_session_date;
182: --
183: hr_utility.set_location(' ben_ppr_trigger', 20);

Line 183: hr_utility.set_location(' ben_ppr_trigger', 20);

179: hr_utility.set_location('l_session_date is'||l_session_date, 999);
180: --
181: l_effective_start_date := l_session_date;
182: --
183: hr_utility.set_location(' ben_ppr_trigger', 20);
184: hr_utility.set_location('sess '||l_session_date, 20);
185: hr_utility.set_location('PERSON '||p_new.person_id, 20);
186: hr_utility.set_location('BG '||p_new.business_group_id, 20);
187:

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

180: --
181: l_effective_start_date := l_session_date;
182: --
183: hr_utility.set_location(' ben_ppr_trigger', 20);
184: hr_utility.set_location('sess '||l_session_date, 20);
185: hr_utility.set_location('PERSON '||p_new.person_id, 20);
186: hr_utility.set_location('BG '||p_new.business_group_id, 20);
187:
188: open get_ler(l_status);

Line 185: hr_utility.set_location('PERSON '||p_new.person_id, 20);

181: l_effective_start_date := l_session_date;
182: --
183: hr_utility.set_location(' ben_ppr_trigger', 20);
184: hr_utility.set_location('sess '||l_session_date, 20);
185: hr_utility.set_location('PERSON '||p_new.person_id, 20);
186: hr_utility.set_location('BG '||p_new.business_group_id, 20);
187:
188: open get_ler(l_status);
189: loop

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

182: --
183: hr_utility.set_location(' ben_ppr_trigger', 20);
184: hr_utility.set_location('sess '||l_session_date, 20);
185: hr_utility.set_location('PERSON '||p_new.person_id, 20);
186: hr_utility.set_location('BG '||p_new.business_group_id, 20);
187:
188: open get_ler(l_status);
189: loop
190: fetch get_ler into l_ler_id,l_typ_cd, l_ocrd_dt_cd;

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

212: loop
213: 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;
214: exit when get_ler_col%NOTFOUND;
215:
216: hr_utility.set_location('LER '||l_ler_id, 20);
217: hr_utility.set_location('COLUMN '||l_column, 20);
218: hr_utility.set_location('NEWVAL '||l_new_val, 20);
219: hr_utility.set_location('OLDVAL '||l_old_val, 20);
220: hr_utility.set_location('TYPE '||l_type, 20);

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

213: 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;
214: exit when get_ler_col%NOTFOUND;
215:
216: hr_utility.set_location('LER '||l_ler_id, 20);
217: hr_utility.set_location('COLUMN '||l_column, 20);
218: hr_utility.set_location('NEWVAL '||l_new_val, 20);
219: hr_utility.set_location('OLDVAL '||l_old_val, 20);
220: hr_utility.set_location('TYPE '||l_type, 20);
221:

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

214: exit when get_ler_col%NOTFOUND;
215:
216: hr_utility.set_location('LER '||l_ler_id, 20);
217: hr_utility.set_location('COLUMN '||l_column, 20);
218: hr_utility.set_location('NEWVAL '||l_new_val, 20);
219: hr_utility.set_location('OLDVAL '||l_old_val, 20);
220: hr_utility.set_location('TYPE '||l_type, 20);
221:
222: l_changed := TRUE;

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

215:
216: hr_utility.set_location('LER '||l_ler_id, 20);
217: hr_utility.set_location('COLUMN '||l_column, 20);
218: hr_utility.set_location('NEWVAL '||l_new_val, 20);
219: hr_utility.set_location('OLDVAL '||l_old_val, 20);
220: hr_utility.set_location('TYPE '||l_type, 20);
221:
222: l_changed := TRUE;
223: if get_ler_col%ROWCOUNT = 1 then

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

216: hr_utility.set_location('LER '||l_ler_id, 20);
217: hr_utility.set_location('COLUMN '||l_column, 20);
218: hr_utility.set_location('NEWVAL '||l_new_val, 20);
219: hr_utility.set_location('OLDVAL '||l_old_val, 20);
220: hr_utility.set_location('TYPE '||l_type, 20);
221:
222: l_changed := TRUE;
223: if get_ler_col%ROWCOUNT = 1 then
224: hr_utility.set_location('rowcount 1 ', 20);

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

220: hr_utility.set_location('TYPE '||l_type, 20);
221:
222: l_changed := TRUE;
223: if get_ler_col%ROWCOUNT = 1 then
224: hr_utility.set_location('rowcount 1 ', 20);
225: l_changed := TRUE;
226: end if;
227: hr_utility.set_location(' ben_ppr_trigger', 50);
228: -- Call the formula here to evaluate per_info_chg_cs_ler_rl.

Line 227: hr_utility.set_location(' ben_ppr_trigger', 50);

223: if get_ler_col%ROWCOUNT = 1 then
224: hr_utility.set_location('rowcount 1 ', 20);
225: l_changed := TRUE;
226: end if;
227: hr_utility.set_location(' ben_ppr_trigger', 50);
228: -- Call the formula here to evaluate per_info_chg_cs_ler_rl.
229: -- If it returns Y, then see the applicability of the data
230: -- changes based on new and old values.
231: --

Line 502: hr_utility.set_location(' ben_ppr_trigger'|| ' l_rule_output = ' || l_rule_output, 9999);

498: p_ret_val => l_rule_output);
499: --
500: end if;
501: --
502: hr_utility.set_location(' ben_ppr_trigger'|| ' l_rule_output = ' || l_rule_output, 9999);
503:
504: --
505:
506: if l_column = 'REVIEW_DATE' then

Line 521: hr_utility.set_location('NEW DOB'||p_new.performance_rating, 50);

517: ,p_new.performance_rating,l_new_val) AND
518: benutils.column_changed(p_new.performance_rating
519: ,p_old.performance_rating,l_old_val) AND
520: (l_changed));
521: hr_utility.set_location('NEW DOB'||p_new.performance_rating, 50);
522: hr_utility.set_location('OLD DOB'||p_old.performance_rating, 50);
523: hr_utility.set_location(' ben_ppr_trigger', 60);
524: end if;
525: --

Line 522: hr_utility.set_location('OLD DOB'||p_old.performance_rating, 50);

518: benutils.column_changed(p_new.performance_rating
519: ,p_old.performance_rating,l_old_val) AND
520: (l_changed));
521: hr_utility.set_location('NEW DOB'||p_new.performance_rating, 50);
522: hr_utility.set_location('OLD DOB'||p_old.performance_rating, 50);
523: hr_utility.set_location(' ben_ppr_trigger', 60);
524: end if;
525: --
526: if l_column = 'EVENT_ID' then

Line 523: hr_utility.set_location(' ben_ppr_trigger', 60);

519: ,p_old.performance_rating,l_old_val) AND
520: (l_changed));
521: hr_utility.set_location('NEW DOB'||p_new.performance_rating, 50);
522: hr_utility.set_location('OLD DOB'||p_old.performance_rating, 50);
523: hr_utility.set_location(' ben_ppr_trigger', 60);
524: end if;
525: --
526: if l_column = 'EVENT_ID' then
527: --

Line 569: hr_utility.set_location(' ben_ppr_trigger', 210);

565: ,p_new.attribute1,l_new_val) AND
566: benutils.column_changed(p_new.attribute1
567: ,p_old.attribute1,l_old_val) AND
568: (l_changed));
569: hr_utility.set_location(' ben_ppr_trigger', 210);
570: hr_utility.set_location('NEW A1'||p_new.attribute1, 50);
571: hr_utility.set_location('OLD A1'||p_old.attribute1, 50);
572: end if;
573: --

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

566: benutils.column_changed(p_new.attribute1
567: ,p_old.attribute1,l_old_val) AND
568: (l_changed));
569: hr_utility.set_location(' ben_ppr_trigger', 210);
570: hr_utility.set_location('NEW A1'||p_new.attribute1, 50);
571: hr_utility.set_location('OLD A1'||p_old.attribute1, 50);
572: end if;
573: --
574: if l_column = 'ATTRIBUTE2' then

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

567: ,p_old.attribute1,l_old_val) AND
568: (l_changed));
569: hr_utility.set_location(' ben_ppr_trigger', 210);
570: hr_utility.set_location('NEW A1'||p_new.attribute1, 50);
571: hr_utility.set_location('OLD A1'||p_old.attribute1, 50);
572: end if;
573: --
574: if l_column = 'ATTRIBUTE2' then
575: l_changed := (benutils.column_changed(p_old.attribute2

Line 580: hr_utility.set_location(' ben_ppr_trigger', 220);

576: ,p_new.attribute2,l_new_val) AND
577: benutils.column_changed(p_new.attribute2
578: ,p_old.attribute2,l_old_val) AND
579: (l_changed));
580: hr_utility.set_location(' ben_ppr_trigger', 220);
581: end if;
582: --
583: if l_column = 'ATTRIBUTE3' then
584: l_changed := (benutils.column_changed(p_old.attribute3

Line 589: hr_utility.set_location(' ben_ppr_trigger', 230);

585: ,p_new.attribute3,l_new_val) AND
586: benutils.column_changed(p_new.attribute3
587: ,p_old.attribute3,l_old_val) AND
588: (l_changed));
589: hr_utility.set_location(' ben_ppr_trigger', 230);
590: end if;
591: --
592: if l_column = 'ATTRIBUTE4' then
593: l_changed := (benutils.column_changed(p_old.attribute4

Line 598: hr_utility.set_location(' ben_ppr_trigger', 240);

594: ,p_new.attribute4,l_new_val) AND
595: benutils.column_changed(p_new.attribute4
596: ,p_old.attribute4,l_old_val) AND
597: (l_changed));
598: hr_utility.set_location(' ben_ppr_trigger', 240);
599: end if;
600: --
601: if l_column = 'ATTRIBUTE5' then
602: l_changed := (benutils.column_changed(p_old.attribute5

Line 607: hr_utility.set_location(' ben_ppr_trigger', 250);

603: ,p_new.attribute5,l_new_val) AND
604: benutils.column_changed(p_new.attribute5
605: ,p_old.attribute5,l_old_val) AND
606: (l_changed));
607: hr_utility.set_location(' ben_ppr_trigger', 250);
608: end if;
609: --
610: if l_column = 'ATTRIBUTE6' then
611: l_changed := (benutils.column_changed(p_old.attribute6

Line 616: hr_utility.set_location(' ben_ppr_trigger', 260);

612: ,p_new.attribute6,l_new_val) AND
613: benutils.column_changed(p_new.attribute6
614: ,p_old.attribute6,l_old_val) AND
615: (l_changed));
616: hr_utility.set_location(' ben_ppr_trigger', 260);
617: end if;
618: --
619: if l_column = 'ATTRIBUTE7' then
620: l_changed := (benutils.column_changed(p_old.attribute7

Line 625: hr_utility.set_location(' ben_ppr_trigger', 270);

621: ,p_new.attribute7,l_new_val) AND
622: benutils.column_changed(p_new.attribute7
623: ,p_old.attribute7,l_old_val) AND
624: (l_changed));
625: hr_utility.set_location(' ben_ppr_trigger', 270);
626: end if;
627: --
628: if l_column = 'ATTRIBUTE8' then
629: l_changed := (benutils.column_changed(p_old.attribute8

Line 634: hr_utility.set_location(' ben_ppr_trigger', 280);

630: ,p_new.attribute8,l_new_val) AND
631: benutils.column_changed(p_new.attribute8
632: ,p_old.attribute8,l_old_val) AND
633: (l_changed));
634: hr_utility.set_location(' ben_ppr_trigger', 280);
635: end if;
636: --
637: if l_column = 'ATTRIBUTE9' then
638: l_changed := (benutils.column_changed(p_old.attribute9

Line 643: hr_utility.set_location(' ben_ppr_trigger', 290);

639: ,p_new.attribute9,l_new_val) AND
640: benutils.column_changed(p_new.attribute9
641: ,p_old.attribute9,l_old_val) AND
642: (l_changed));
643: hr_utility.set_location(' ben_ppr_trigger', 290);
644: end if;
645: --
646: if l_column = 'ATTRIBUTE10' then
647: l_changed := (benutils.column_changed(p_old.attribute10

Line 652: hr_utility.set_location(' ben_ppr_trigger', 300);

648: ,p_new.attribute10,l_new_val) AND
649: benutils.column_changed(p_new.attribute10
650: ,p_old.attribute10,l_old_val) AND
651: (l_changed));
652: hr_utility.set_location(' ben_ppr_trigger', 300);
653: end if;
654: --
655: if l_column = 'ATTRIBUTE11' then
656: l_changed := (benutils.column_changed(p_old.attribute11

Line 661: hr_utility.set_location(' ben_ppr_trigger', 310);

657: ,p_new.attribute11,l_new_val) AND
658: benutils.column_changed(p_new.attribute11
659: ,p_old.attribute11,l_old_val) AND
660: (l_changed));
661: hr_utility.set_location(' ben_ppr_trigger', 310);
662: end if;
663: --
664: if l_column = 'ATTRIBUTE12' then
665: l_changed := (benutils.column_changed(p_old.attribute12

Line 670: hr_utility.set_location(' ben_ppr_trigger', 320);

666: ,p_new.attribute12,l_new_val) AND
667: benutils.column_changed(p_new.attribute12
668: ,p_old.attribute12,l_old_val) AND
669: (l_changed));
670: hr_utility.set_location(' ben_ppr_trigger', 320);
671: end if;
672: --
673: if l_column = 'ATTRIBUTE13' then
674: l_changed := (benutils.column_changed(p_old.attribute13

Line 679: hr_utility.set_location(' ben_ppr_trigger', 330);

675: ,p_new.attribute13,l_new_val) AND
676: benutils.column_changed(p_new.attribute13
677: ,p_old.attribute13,l_old_val) AND
678: (l_changed));
679: hr_utility.set_location(' ben_ppr_trigger', 330);
680: end if;
681: --
682: if l_column = 'ATTRIBUTE14' then
683: l_changed := (benutils.column_changed(p_old.attribute14

Line 688: hr_utility.set_location(' ben_ppr_trigger', 340);

684: ,p_new.attribute14,l_new_val) AND
685: benutils.column_changed(p_new.attribute14
686: ,p_old.attribute14,l_old_val) AND
687: (l_changed));
688: hr_utility.set_location(' ben_ppr_trigger', 340);
689: end if;
690: --
691: if l_column = 'ATTRIBUTE15' then
692: l_changed := (benutils.column_changed(p_old.attribute15

Line 697: hr_utility.set_location(' ben_ppr_trigger', 350);

693: ,p_new.attribute15,l_new_val) AND
694: benutils.column_changed(p_new.attribute15
695: ,p_old.attribute15,l_old_val) AND
696: (l_changed));
697: hr_utility.set_location(' ben_ppr_trigger', 350);
698: end if;
699: --
700: if l_column = 'ATTRIBUTE16' then
701: l_changed := (benutils.column_changed(p_old.attribute16

Line 706: hr_utility.set_location(' ben_ppr_trigger', 360);

702: ,p_new.attribute16,l_new_val) AND
703: benutils.column_changed(p_new.attribute16
704: ,p_old.attribute16,l_old_val) AND
705: (l_changed));
706: hr_utility.set_location(' ben_ppr_trigger', 360);
707: end if;
708: --
709: if l_column = 'ATTRIBUTE17' then
710: l_changed := (benutils.column_changed(p_old.attribute17

Line 715: hr_utility.set_location(' ben_ppr_trigger', 370);

711: ,p_new.attribute17,l_new_val) AND
712: benutils.column_changed(p_new.attribute17
713: ,p_old.attribute17,l_old_val) AND
714: (l_changed));
715: hr_utility.set_location(' ben_ppr_trigger', 370);
716: end if;
717: --
718: if l_column = 'ATTRIBUTE18' then
719: l_changed := (benutils.column_changed(p_old.attribute18

Line 724: hr_utility.set_location(' ben_ppr_trigger', 380);

720: ,p_new.attribute18,l_new_val) AND
721: benutils.column_changed(p_new.attribute18
722: ,p_old.attribute18,l_old_val) AND
723: (l_changed));
724: hr_utility.set_location(' ben_ppr_trigger', 380);
725: end if;
726: --
727: if l_column = 'ATTRIBUTE19' then
728: l_changed := (benutils.column_changed(p_old.attribute19

Line 733: hr_utility.set_location(' ben_ppr_trigger', 390);

729: ,p_new.attribute19,l_new_val) AND
730: benutils.column_changed(p_new.attribute19
731: ,p_old.attribute19,l_old_val) AND
732: (l_changed));
733: hr_utility.set_location(' ben_ppr_trigger', 390);
734: end if;
735: --
736: if l_column = 'ATTRIBUTE20' then
737: l_changed := (benutils.column_changed(p_old.attribute20

Line 742: hr_utility.set_location(' ben_ppr_trigger', 400);

738: ,p_new.attribute20,l_new_val) AND
739: benutils.column_changed(p_new.attribute20
740: ,p_old.attribute20,l_old_val) AND
741: (l_changed));
742: hr_utility.set_location(' ben_ppr_trigger', 400);
743: end if;
744: --
745:
746: if l_column = 'ATTRIBUTE21' then

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

834: elsif l_rule_output = 'Y' and l_rule_overrides_flag = 'N' then
835: l_changed := l_changed AND TRUE;
836: elsif l_rule_output = 'N' then
837: l_changed := FALSE;
838: hr_utility.set_location(' Rule output is N, so we should not trigger LE', 20.01);
839: end if;
840:
841: hr_utility.set_location('After the rule Check ',20.05);
842: if l_changed then

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

837: l_changed := FALSE;
838: hr_utility.set_location(' Rule output is N, so we should not trigger LE', 20.01);
839: end if;
840:
841: hr_utility.set_location('After the rule Check ',20.05);
842: if l_changed then
843: hr_utility.set_location(' l_change TRUE l_rule_overrides_flag '||l_rule_overrides_flag, 20.1);
844: else
845: hr_utility.set_location(' l_change FALSE l_rule_overrides_flag '||l_rule_overrides_flag, 20.1);

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

839: end if;
840:
841: hr_utility.set_location('After the rule Check ',20.05);
842: if l_changed then
843: hr_utility.set_location(' l_change TRUE l_rule_overrides_flag '||l_rule_overrides_flag, 20.1);
844: else
845: hr_utility.set_location(' l_change FALSE l_rule_overrides_flag '||l_rule_overrides_flag, 20.1);
846: end if;
847: -- Check for Column Mandatory Change

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

841: hr_utility.set_location('After the rule Check ',20.05);
842: if l_changed then
843: hr_utility.set_location(' l_change TRUE l_rule_overrides_flag '||l_rule_overrides_flag, 20.1);
844: else
845: hr_utility.set_location(' l_change FALSE l_rule_overrides_flag '||l_rule_overrides_flag, 20.1);
846: end if;
847: -- Check for Column Mandatory Change
848: -- If column change is mandatory and data change has failed then dont trigger
849: -- If column change is non-mandatory and the data change has passed, then trigger.

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

848: -- If column change is mandatory and data change has failed then dont trigger
849: -- If column change is non-mandatory and the data change has passed, then trigger.
850:
851: if l_chg_mandatory_cd = 'Y' and not l_changed then
852: hr_utility.set_location('Found Mandatory and its failed ', 20.1);
853: l_changed := FALSE;
854: l_trigger := FALSE;
855: exit;
856: elsif l_chg_mandatory_cd = 'Y' and l_changed then

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

853: l_changed := FALSE;
854: l_trigger := FALSE;
855: exit;
856: elsif l_chg_mandatory_cd = 'Y' and l_changed then
857: hr_utility.set_location('Found Mandatory and its passed ', 20.1);
858: l_changed := TRUE;
859: -- exit; */
860: elsif l_chg_mandatory_cd = 'N' and l_changed then
861: hr_utility.set_location('Found First Non-Mandatory and its passed ', 20.1);

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

857: hr_utility.set_location('Found Mandatory and its passed ', 20.1);
858: l_changed := TRUE;
859: -- exit; */
860: elsif l_chg_mandatory_cd = 'N' and l_changed then
861: hr_utility.set_location('Found First Non-Mandatory and its passed ', 20.1);
862: l_changed := TRUE;
863: l_trigger := TRUE;
864: exit;
865: end if;

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

863: l_trigger := TRUE;
864: exit;
865: end if;
866:
867: hr_utility.set_location('After the Mandatory code check ',20.05);
868: if l_changed then
869: hr_utility.set_location(' l_change TRUE ', 20.1);
870: else
871: hr_utility.set_location(' l_change FALSE ', 20.1);

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

865: end if;
866:
867: hr_utility.set_location('After the Mandatory code check ',20.05);
868: if l_changed then
869: hr_utility.set_location(' l_change TRUE ', 20.1);
870: else
871: hr_utility.set_location(' l_change FALSE ', 20.1);
872: end if;
873: --

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

867: hr_utility.set_location('After the Mandatory code check ',20.05);
868: if l_changed then
869: hr_utility.set_location(' l_change TRUE ', 20.1);
870: else
871: hr_utility.set_location(' l_change FALSE ', 20.1);
872: end if;
873: --
874: /* if not l_changed then
875: exit;

Line 878: hr_utility.set_location(' ben_ppr_trigger', 30);

874: /* if not l_changed then
875: exit;
876: end if; */
877: end loop;
878: hr_utility.set_location(' ben_ppr_trigger', 30);
879: l_ptnl_id := 0;
880: l_ovn :=null;
881: if l_trigger then
882:

Line 889: hr_utility.set_location('l_lf_evt_ocrd_date is '||l_lf_evt_ocrd_date, 987);

885: if l_type = 'P' then
886: --
887: -- Life event has occured for Participant
888: --
889: hr_utility.set_location('l_lf_evt_ocrd_date is '||l_lf_evt_ocrd_date, 987);
890: open le_exists(p_new.person_id,l_ler_id,l_lf_evt_ocrd_date);
891: fetch le_exists into l_le_exists;
892: --
893: -- If an already existing life event of this

Line 898: hr_utility.set_location(' Entering: ben_ppr_trigger5', 60);

894: -- type exists do nothing.
895: --
896:
897: if le_exists%notfound then
898: hr_utility.set_location(' Entering: ben_ppr_trigger5', 60);
899: ben_create_ptnl_ler_for_per.create_ptnl_ler_event
900: --ben_ptnl_ler_for_per_api.create_ptnl_ler_for_per
901: (p_validate => false
902: ,p_ptnl_ler_for_per_id => l_ptnl_id

Line 916: hr_utility.set_location(' Entering: ben_ppr_trigger5-rp', 65);

912: ,p_dtctd_dt => l_lf_evt_ocrd_date);
913: end if;
914: close le_exists;
915: elsif l_type = 'R' then
916: hr_utility.set_location(' Entering: ben_ppr_trigger5-rp', 65);
917: --
918: -- Related Life event has occured for Participant contacts
919: --
920: open get_contacts(p_new.person_id);

Line 930: hr_utility.set_location(' Entering: ben_ppr_trigger5', 60);

926: --
927: -- If potential life event does not already exist
928: -- create it.
929: if le_exists%notfound then
930: hr_utility.set_location(' Entering: ben_ppr_trigger5', 60);
931: ben_create_ptnl_ler_for_per.create_ptnl_ler_event
932: --ben_ptnl_ler_for_per_api.create_ptnl_ler_for_per
933: (p_validate => false
934: ,p_ptnl_ler_for_per_id => l_ptnl_id

Line 955: hr_utility.set_location(' ben_ppr_trigger', 40);

951: end if;
952: --
953: -- reset the variables.
954: --
955: hr_utility.set_location(' ben_ppr_trigger', 40);
956: l_changed := FALSE;
957: l_trigger := TRUE;
958: l_ovn := NULL;
959:

Line 963: hr_utility.set_location(' ben_ppr_trigger', 180);

959:
960: end if;
961: close get_ler_col;
962: end loop;
963: hr_utility.set_location(' ben_ppr_trigger', 180);
964: close get_ler;
965: hr_utility.set_location(' Leaving: ben_ppr_trigger', 200);
966:
967: end;

Line 965: hr_utility.set_location(' Leaving: ben_ppr_trigger', 200);

961: close get_ler_col;
962: end loop;
963: hr_utility.set_location(' ben_ppr_trigger', 180);
964: close get_ler;
965: hr_utility.set_location(' Leaving: ben_ppr_trigger', 200);
966:
967: end;
968: end ben_ppr_ler;