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

Line 173: hr_utility.set_location(' Entering: ben_ppf_trigger', 10);

169: ,dep_appl_id =>805
170: ,status => l_status
171: ,industry => l_industry);
172:
173: hr_utility.set_location(' Entering: ben_ppf_trigger', 10);
174: l_changed := FALSE;
175: --bug 2215549
176: if p_effective_date is not null then
177: --

Line 194: hr_utility.set_location(' ben_ppf_trigger', 20);

190: open get_system_date;
191: fetch get_system_date into l_system_date;
192: close get_system_date;
193:
194: hr_utility.set_location(' ben_ppf_trigger', 20);
195: hr_utility.set_location('sess '||l_session_date, 20);
196: hr_utility.set_location('PERSON '||p_new.person_id, 20);
197: hr_utility.set_location('BG '||p_new.business_group_id, 20);
198: open get_ler(l_status);

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

191: fetch get_system_date into l_system_date;
192: close get_system_date;
193:
194: hr_utility.set_location(' ben_ppf_trigger', 20);
195: hr_utility.set_location('sess '||l_session_date, 20);
196: hr_utility.set_location('PERSON '||p_new.person_id, 20);
197: hr_utility.set_location('BG '||p_new.business_group_id, 20);
198: open get_ler(l_status);
199: loop

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

192: close get_system_date;
193:
194: hr_utility.set_location(' ben_ppf_trigger', 20);
195: hr_utility.set_location('sess '||l_session_date, 20);
196: hr_utility.set_location('PERSON '||p_new.person_id, 20);
197: hr_utility.set_location('BG '||p_new.business_group_id, 20);
198: open get_ler(l_status);
199: loop
200: fetch get_ler into l_ler_id,l_typ_cd,l_ocrd_dt_cd;

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

193:
194: hr_utility.set_location(' ben_ppf_trigger', 20);
195: hr_utility.set_location('sess '||l_session_date, 20);
196: hr_utility.set_location('PERSON '||p_new.person_id, 20);
197: hr_utility.set_location('BG '||p_new.business_group_id, 20);
198: open get_ler(l_status);
199: loop
200: fetch get_ler into l_ler_id,l_typ_cd,l_ocrd_dt_cd;
201: exit when get_ler%notfound;

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

205: loop
206: 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;
207: exit when get_ler_col%NOTFOUND;
208:
209: hr_utility.set_location('LER '||l_ler_id, 20);
210: hr_utility.set_location('COLUMN '||l_column, 20);
211: hr_utility.set_location('NEWVAL '||l_new_val, 20);
212: hr_utility.set_location('OLDVAL '||l_old_val, 20);
213: hr_utility.set_location('TYPE '||l_type, 20);

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

206: 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;
207: exit when get_ler_col%NOTFOUND;
208:
209: hr_utility.set_location('LER '||l_ler_id, 20);
210: hr_utility.set_location('COLUMN '||l_column, 20);
211: hr_utility.set_location('NEWVAL '||l_new_val, 20);
212: hr_utility.set_location('OLDVAL '||l_old_val, 20);
213: hr_utility.set_location('TYPE '||l_type, 20);
214: hr_utility.set_location(' l_per_info_chg_cs_ler_rl '|| l_per_info_chg_cs_ler_rl, 20);

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

207: exit when get_ler_col%NOTFOUND;
208:
209: hr_utility.set_location('LER '||l_ler_id, 20);
210: hr_utility.set_location('COLUMN '||l_column, 20);
211: hr_utility.set_location('NEWVAL '||l_new_val, 20);
212: hr_utility.set_location('OLDVAL '||l_old_val, 20);
213: hr_utility.set_location('TYPE '||l_type, 20);
214: hr_utility.set_location(' l_per_info_chg_cs_ler_rl '|| l_per_info_chg_cs_ler_rl, 20);
215: hr_utility.set_location('l_rule_overrides_flag '||l_rule_overrides_flag, 20);

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

208:
209: hr_utility.set_location('LER '||l_ler_id, 20);
210: hr_utility.set_location('COLUMN '||l_column, 20);
211: hr_utility.set_location('NEWVAL '||l_new_val, 20);
212: hr_utility.set_location('OLDVAL '||l_old_val, 20);
213: hr_utility.set_location('TYPE '||l_type, 20);
214: hr_utility.set_location(' l_per_info_chg_cs_ler_rl '|| l_per_info_chg_cs_ler_rl, 20);
215: hr_utility.set_location('l_rule_overrides_flag '||l_rule_overrides_flag, 20);
216: hr_utility.set_location('l_chg_mandatory_cd '||l_chg_mandatory_cd, 20);

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

209: hr_utility.set_location('LER '||l_ler_id, 20);
210: hr_utility.set_location('COLUMN '||l_column, 20);
211: hr_utility.set_location('NEWVAL '||l_new_val, 20);
212: hr_utility.set_location('OLDVAL '||l_old_val, 20);
213: hr_utility.set_location('TYPE '||l_type, 20);
214: hr_utility.set_location(' l_per_info_chg_cs_ler_rl '|| l_per_info_chg_cs_ler_rl, 20);
215: hr_utility.set_location('l_rule_overrides_flag '||l_rule_overrides_flag, 20);
216: hr_utility.set_location('l_chg_mandatory_cd '||l_chg_mandatory_cd, 20);
217:

Line 214: hr_utility.set_location(' l_per_info_chg_cs_ler_rl '|| l_per_info_chg_cs_ler_rl, 20);

210: hr_utility.set_location('COLUMN '||l_column, 20);
211: hr_utility.set_location('NEWVAL '||l_new_val, 20);
212: hr_utility.set_location('OLDVAL '||l_old_val, 20);
213: hr_utility.set_location('TYPE '||l_type, 20);
214: hr_utility.set_location(' l_per_info_chg_cs_ler_rl '|| l_per_info_chg_cs_ler_rl, 20);
215: hr_utility.set_location('l_rule_overrides_flag '||l_rule_overrides_flag, 20);
216: hr_utility.set_location('l_chg_mandatory_cd '||l_chg_mandatory_cd, 20);
217:
218:

Line 215: hr_utility.set_location('l_rule_overrides_flag '||l_rule_overrides_flag, 20);

211: hr_utility.set_location('NEWVAL '||l_new_val, 20);
212: hr_utility.set_location('OLDVAL '||l_old_val, 20);
213: hr_utility.set_location('TYPE '||l_type, 20);
214: hr_utility.set_location(' l_per_info_chg_cs_ler_rl '|| l_per_info_chg_cs_ler_rl, 20);
215: hr_utility.set_location('l_rule_overrides_flag '||l_rule_overrides_flag, 20);
216: hr_utility.set_location('l_chg_mandatory_cd '||l_chg_mandatory_cd, 20);
217:
218:
219: l_changed := TRUE;

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

212: hr_utility.set_location('OLDVAL '||l_old_val, 20);
213: hr_utility.set_location('TYPE '||l_type, 20);
214: hr_utility.set_location(' l_per_info_chg_cs_ler_rl '|| l_per_info_chg_cs_ler_rl, 20);
215: hr_utility.set_location('l_rule_overrides_flag '||l_rule_overrides_flag, 20);
216: hr_utility.set_location('l_chg_mandatory_cd '||l_chg_mandatory_cd, 20);
217:
218:
219: l_changed := TRUE;
220: if get_ler_col%ROWCOUNT = 1 then

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

217:
218:
219: l_changed := TRUE;
220: if get_ler_col%ROWCOUNT = 1 then
221: hr_utility.set_location('rowcount 1 ', 20);
222: l_changed := TRUE;
223: end if;
224:
225: hr_utility.set_location(' ben_ppf_trigger', 50);

Line 225: hr_utility.set_location(' ben_ppf_trigger', 50);

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

Line 518: hr_utility.set_location(' ben_ppf_trigger'|| ' l_rule_output = ' || l_rule_output, 9999);

514: p_ret_val => l_rule_output);
515: --
516: end if;
517: --
518: hr_utility.set_location(' ben_ppf_trigger'|| ' l_rule_output = ' || l_rule_output, 9999);
519: --
520: if l_column = 'DATE_OF_BIRTH' then
521: l_changed := (benutils.column_changed(p_old.date_of_birth
522: ,p_new.date_of_birth,l_new_val) AND

Line 526: hr_utility.set_location('NEW DOB'||p_new.date_of_birth, 50);

522: ,p_new.date_of_birth,l_new_val) AND
523: benutils.column_changed(p_new.date_of_birth
524: ,p_old.date_of_birth,l_old_val) AND
525: (l_changed));
526: hr_utility.set_location('NEW DOB'||p_new.date_of_birth, 50);
527: hr_utility.set_location('OLD DOB'||p_old.date_of_birth, 50);
528: hr_utility.set_location(' ben_ppf_trigger', 60);
529: end if;
530: --

Line 527: hr_utility.set_location('OLD DOB'||p_old.date_of_birth, 50);

523: benutils.column_changed(p_new.date_of_birth
524: ,p_old.date_of_birth,l_old_val) AND
525: (l_changed));
526: hr_utility.set_location('NEW DOB'||p_new.date_of_birth, 50);
527: hr_utility.set_location('OLD DOB'||p_old.date_of_birth, 50);
528: hr_utility.set_location(' ben_ppf_trigger', 60);
529: end if;
530: --
531: if l_column = 'DATE_OF_DEATH' then

Line 528: hr_utility.set_location(' ben_ppf_trigger', 60);

524: ,p_old.date_of_birth,l_old_val) AND
525: (l_changed));
526: hr_utility.set_location('NEW DOB'||p_new.date_of_birth, 50);
527: hr_utility.set_location('OLD DOB'||p_old.date_of_birth, 50);
528: hr_utility.set_location(' ben_ppf_trigger', 60);
529: end if;
530: --
531: if l_column = 'DATE_OF_DEATH' then
532: l_changed := (benutils.column_changed(p_old.date_of_death

Line 549: hr_utility.set_location(' ben_ppf_trigger', 70);

545: else
546: l_lf_evt_ocrd_date := p_new.date_of_death;
547: end if;
548: end if;
549: hr_utility.set_location(' ben_ppf_trigger', 70);
550: end if;
551:
552: if l_column = 'MARITAL_STATUS' then
553: l_changed := (benutils.column_changed(p_old.marital_status

Line 558: hr_utility.set_location(' ben_ppf_trigger', 90);

554: ,p_new.marital_status,l_new_val) AND
555: benutils.column_changed(p_new.marital_status
556: ,p_old.marital_status,l_old_val) AND
557: (l_changed));
558: hr_utility.set_location(' ben_ppf_trigger', 90);
559: hr_utility.set_location('NEW MS'||p_new.marital_status, 50);
560: hr_utility.set_location('OLD MS'||p_old.marital_status, 50);
561: end if;
562: --

Line 559: hr_utility.set_location('NEW MS'||p_new.marital_status, 50);

555: benutils.column_changed(p_new.marital_status
556: ,p_old.marital_status,l_old_val) AND
557: (l_changed));
558: hr_utility.set_location(' ben_ppf_trigger', 90);
559: hr_utility.set_location('NEW MS'||p_new.marital_status, 50);
560: hr_utility.set_location('OLD MS'||p_old.marital_status, 50);
561: end if;
562: --
563: if l_column = 'ON_MILITARY_SERVICE' then

Line 560: hr_utility.set_location('OLD MS'||p_old.marital_status, 50);

556: ,p_old.marital_status,l_old_val) AND
557: (l_changed));
558: hr_utility.set_location(' ben_ppf_trigger', 90);
559: hr_utility.set_location('NEW MS'||p_new.marital_status, 50);
560: hr_utility.set_location('OLD MS'||p_old.marital_status, 50);
561: end if;
562: --
563: if l_column = 'ON_MILITARY_SERVICE' then
564: l_changed := (benutils.column_changed(p_old.on_military_service

Line 569: hr_utility.set_location(' ben_ppf_trigger', 100);

565: ,p_new.on_military_service,l_new_val) AND
566: benutils.column_changed(p_new.on_military_service
567: ,p_old.on_military_service,l_old_val) AND
568: (l_changed));
569: hr_utility.set_location(' ben_ppf_trigger', 100);
570: end if;
571: --
572: if l_column = 'REGISTERED_DISABLED_FLAG' then
573: l_changed := (benutils.column_changed(p_old.registered_disabled_flag

Line 578: hr_utility.set_location(' ben_ppf_trigger', 110);

574: ,p_new.registered_disabled_flag,l_new_val) AND
575: benutils.column_changed(p_new.registered_disabled_flag
576: ,p_old.registered_disabled_flag,l_old_val) AND
577: (l_changed));
578: hr_utility.set_location(' ben_ppf_trigger', 110);
579: end if;
580: --
581: if l_column = 'SEX' then
582: l_changed := (benutils.column_changed(p_old.sex

Line 587: hr_utility.set_location(' ben_ppf_trigger', 120);

583: ,p_new.sex,l_new_val) AND
584: benutils.column_changed(p_new.sex
585: ,p_old.sex,l_old_val) AND
586: (l_changed));
587: hr_utility.set_location(' ben_ppf_trigger', 120);
588: end if;
589: --
590: if l_column = 'STUDENT_STATUS' then
591: l_changed := (benutils.column_changed(p_old.student_status

Line 596: hr_utility.set_location(' ben_ppf_trigger', 130);

592: ,p_new.student_status,l_new_val) AND
593: benutils.column_changed(p_new.student_status
594: ,p_old.student_status,l_old_val) AND
595: (l_changed));
596: hr_utility.set_location(' ben_ppf_trigger', 130);
597: end if;
598: --
599: if l_column = 'COORD_BEN_MED_PLN_NO' then
600: l_changed := (benutils.column_changed(p_old.coord_ben_med_pln_no

Line 605: hr_utility.set_location(' ben_ppf_trigger', 140);

601: ,p_new.coord_ben_med_pln_no,l_new_val) AND
602: benutils.column_changed(p_new.coord_ben_med_pln_no
603: ,p_old.coord_ben_med_pln_no,l_old_val) AND
604: (l_changed));
605: hr_utility.set_location(' ben_ppf_trigger', 140);
606: end if;
607: --
608: if l_column = 'COORD_BEN_NO_CVG_FLAG' then
609: l_changed := (benutils.column_changed(p_old.coord_ben_no_cvg_flag

Line 614: hr_utility.set_location(' ben_ppf_trigger', 150);

610: ,p_new.coord_ben_no_cvg_flag,l_new_val) AND
611: benutils.column_changed(p_new.coord_ben_no_cvg_flag
612: ,p_old.coord_ben_no_cvg_flag,l_old_val) AND
613: (l_changed));
614: hr_utility.set_location(' ben_ppf_trigger', 150);
615: end if;
616: --
617: if l_column = 'USES_TOBACCO_FLAG' then
618: l_changed := (benutils.column_changed(p_old.uses_tobacco_flag

Line 623: hr_utility.set_location(' ben_ppf_trigger', 160);

619: ,p_new.uses_tobacco_flag,l_new_val) AND
620: benutils.column_changed(p_new.uses_tobacco_flag
621: ,p_old.uses_tobacco_flag,l_old_val) AND
622: (l_changed));
623: hr_utility.set_location(' ben_ppf_trigger', 160);
624: end if;
625: --
626: if l_column = 'BENEFIT_GROUP_ID' then
627: l_changed := (benutils.column_changed(p_old.benefit_group_id

Line 632: hr_utility.set_location(' ben_ppf_trigger', 170);

628: ,p_new.benefit_group_id,l_new_val) AND
629: benutils.column_changed(p_new.benefit_group_id
630: ,p_old.benefit_group_id,l_old_val) AND
631: (l_changed));
632: hr_utility.set_location(' ben_ppf_trigger', 170);
633: end if;
634: --
635: if l_column = 'PER_INFORMATION10' then
636: l_changed := (benutils.column_changed(p_old.per_information10

Line 641: hr_utility.set_location(' ben_ppf_trigger',180);

637: ,p_new.per_information10,l_new_val) AND
638: benutils.column_changed(p_new.per_information10
639: ,p_old.per_information10,l_old_val) AND
640: (l_changed));
641: hr_utility.set_location(' ben_ppf_trigger',180);
642: end if;
643: --
644: if l_column = 'DPDNT_VLNTRY_SVCE_FLAG' then
645: hr_utility.set_location(' ben_ppf_trigger', 190);

Line 645: hr_utility.set_location(' ben_ppf_trigger', 190);

641: hr_utility.set_location(' ben_ppf_trigger',180);
642: end if;
643: --
644: if l_column = 'DPDNT_VLNTRY_SVCE_FLAG' then
645: hr_utility.set_location(' ben_ppf_trigger', 190);
646: l_changed := (benutils.column_changed(p_old.dpdnt_vlntry_svce_flag
647: ,p_new.dpdnt_vlntry_svce_flag,l_new_val) AND
648: benutils.column_changed(p_new.dpdnt_vlntry_svce_flag
649: ,p_old.dpdnt_vlntry_svce_flag,l_old_val) AND

Line 651: hr_utility.set_location(' ben_ppf_trigger', 190);

647: ,p_new.dpdnt_vlntry_svce_flag,l_new_val) AND
648: benutils.column_changed(p_new.dpdnt_vlntry_svce_flag
649: ,p_old.dpdnt_vlntry_svce_flag,l_old_val) AND
650: (l_changed));
651: hr_utility.set_location(' ben_ppf_trigger', 190);
652: end if;
653: --
654: if l_column = 'RECEIPT_OF_DEATH_CERT_DATE' then
655: l_changed := (benutils.column_changed(p_old.receipt_of_death_cert_date

Line 660: hr_utility.set_location(' ben_ppf_trigger', 200);

656: ,p_new.receipt_of_death_cert_date,l_new_val) AND
657: benutils.column_changed(p_new.receipt_of_death_cert_date
658: ,p_old.receipt_of_death_cert_date,l_old_val) AND
659: (l_changed));
660: hr_utility.set_location(' ben_ppf_trigger', 200);
661: end if;
662: --
663: if l_column = 'ATTRIBUTE1' then
664: l_changed := (benutils.column_changed(p_old.attribute1

Line 669: hr_utility.set_location(' ben_ppf_trigger', 210);

665: ,p_new.attribute1,l_new_val) AND
666: benutils.column_changed(p_new.attribute1
667: ,p_old.attribute1,l_old_val) AND
668: (l_changed));
669: hr_utility.set_location(' ben_ppf_trigger', 210);
670: hr_utility.set_location('NEW A1'||p_new.attribute1, 50);
671: hr_utility.set_location('OLD A1'||p_old.attribute1, 50);
672: end if;
673: --

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

666: benutils.column_changed(p_new.attribute1
667: ,p_old.attribute1,l_old_val) AND
668: (l_changed));
669: hr_utility.set_location(' ben_ppf_trigger', 210);
670: hr_utility.set_location('NEW A1'||p_new.attribute1, 50);
671: hr_utility.set_location('OLD A1'||p_old.attribute1, 50);
672: end if;
673: --
674: if l_column = 'ATTRIBUTE2' then

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

667: ,p_old.attribute1,l_old_val) AND
668: (l_changed));
669: hr_utility.set_location(' ben_ppf_trigger', 210);
670: hr_utility.set_location('NEW A1'||p_new.attribute1, 50);
671: hr_utility.set_location('OLD A1'||p_old.attribute1, 50);
672: end if;
673: --
674: if l_column = 'ATTRIBUTE2' then
675: l_changed := (benutils.column_changed(p_old.attribute2

Line 680: hr_utility.set_location(' ben_ppf_trigger', 220);

676: ,p_new.attribute2,l_new_val) AND
677: benutils.column_changed(p_new.attribute2
678: ,p_old.attribute2,l_old_val) AND
679: (l_changed));
680: hr_utility.set_location(' ben_ppf_trigger', 220);
681: end if;
682: --
683: if l_column = 'ATTRIBUTE3' then
684: l_changed := (benutils.column_changed(p_old.attribute3

Line 689: hr_utility.set_location(' ben_ppf_trigger', 230);

685: ,p_new.attribute3,l_new_val) AND
686: benutils.column_changed(p_new.attribute3
687: ,p_old.attribute3,l_old_val) AND
688: (l_changed));
689: hr_utility.set_location(' ben_ppf_trigger', 230);
690: end if;
691: --
692: if l_column = 'ATTRIBUTE4' then
693: l_changed := (benutils.column_changed(p_old.attribute4

Line 698: hr_utility.set_location(' ben_ppf_trigger', 240);

694: ,p_new.attribute4,l_new_val) AND
695: benutils.column_changed(p_new.attribute4
696: ,p_old.attribute4,l_old_val) AND
697: (l_changed));
698: hr_utility.set_location(' ben_ppf_trigger', 240);
699: end if;
700: --
701: if l_column = 'ATTRIBUTE5' then
702: l_changed := (benutils.column_changed(p_old.attribute5

Line 707: hr_utility.set_location(' ben_ppf_trigger', 250);

703: ,p_new.attribute5,l_new_val) AND
704: benutils.column_changed(p_new.attribute5
705: ,p_old.attribute5,l_old_val) AND
706: (l_changed));
707: hr_utility.set_location(' ben_ppf_trigger', 250);
708: end if;
709: --
710: if l_column = 'ATTRIBUTE6' then
711: l_changed := (benutils.column_changed(p_old.attribute6

Line 716: hr_utility.set_location(' ben_ppf_trigger', 260);

712: ,p_new.attribute6,l_new_val) AND
713: benutils.column_changed(p_new.attribute6
714: ,p_old.attribute6,l_old_val) AND
715: (l_changed));
716: hr_utility.set_location(' ben_ppf_trigger', 260);
717: end if;
718: --
719: if l_column = 'ATTRIBUTE7' then
720: l_changed := (benutils.column_changed(p_old.attribute7

Line 725: hr_utility.set_location(' ben_ppf_trigger', 270);

721: ,p_new.attribute7,l_new_val) AND
722: benutils.column_changed(p_new.attribute7
723: ,p_old.attribute7,l_old_val) AND
724: (l_changed));
725: hr_utility.set_location(' ben_ppf_trigger', 270);
726: end if;
727: --
728: if l_column = 'ATTRIBUTE8' then
729: l_changed := (benutils.column_changed(p_old.attribute8

Line 734: hr_utility.set_location(' ben_ppf_trigger', 280);

730: ,p_new.attribute8,l_new_val) AND
731: benutils.column_changed(p_new.attribute8
732: ,p_old.attribute8,l_old_val) AND
733: (l_changed));
734: hr_utility.set_location(' ben_ppf_trigger', 280);
735: end if;
736: --
737: if l_column = 'ATTRIBUTE9' then
738: l_changed := (benutils.column_changed(p_old.attribute9

Line 743: hr_utility.set_location(' ben_ppf_trigger', 290);

739: ,p_new.attribute9,l_new_val) AND
740: benutils.column_changed(p_new.attribute9
741: ,p_old.attribute9,l_old_val) AND
742: (l_changed));
743: hr_utility.set_location(' ben_ppf_trigger', 290);
744: end if;
745: --
746: if l_column = 'ATTRIBUTE10' then
747: l_changed := (benutils.column_changed(p_old.attribute10

Line 752: hr_utility.set_location(' ben_ppf_trigger', 300);

748: ,p_new.attribute10,l_new_val) AND
749: benutils.column_changed(p_new.attribute10
750: ,p_old.attribute10,l_old_val) AND
751: (l_changed));
752: hr_utility.set_location(' ben_ppf_trigger', 300);
753: end if;
754: --
755: if l_column = 'ATTRIBUTE11' then
756: l_changed := (benutils.column_changed(p_old.attribute11

Line 761: hr_utility.set_location(' ben_ppf_trigger', 310);

757: ,p_new.attribute11,l_new_val) AND
758: benutils.column_changed(p_new.attribute11
759: ,p_old.attribute11,l_old_val) AND
760: (l_changed));
761: hr_utility.set_location(' ben_ppf_trigger', 310);
762: end if;
763: --
764: if l_column = 'ATTRIBUTE12' then
765: l_changed := (benutils.column_changed(p_old.attribute12

Line 770: hr_utility.set_location(' ben_ppf_trigger', 320);

766: ,p_new.attribute12,l_new_val) AND
767: benutils.column_changed(p_new.attribute12
768: ,p_old.attribute12,l_old_val) AND
769: (l_changed));
770: hr_utility.set_location(' ben_ppf_trigger', 320);
771: end if;
772: --
773: if l_column = 'ATTRIBUTE13' then
774: l_changed := (benutils.column_changed(p_old.attribute13

Line 779: hr_utility.set_location(' ben_ppf_trigger', 330);

775: ,p_new.attribute13,l_new_val) AND
776: benutils.column_changed(p_new.attribute13
777: ,p_old.attribute13,l_old_val) AND
778: (l_changed));
779: hr_utility.set_location(' ben_ppf_trigger', 330);
780: end if;
781: --
782: if l_column = 'ATTRIBUTE14' then
783: l_changed := (benutils.column_changed(p_old.attribute14

Line 788: hr_utility.set_location(' ben_ppf_trigger', 340);

784: ,p_new.attribute14,l_new_val) AND
785: benutils.column_changed(p_new.attribute14
786: ,p_old.attribute14,l_old_val) AND
787: (l_changed));
788: hr_utility.set_location(' ben_ppf_trigger', 340);
789: end if;
790: --
791: if l_column = 'ATTRIBUTE15' then
792: l_changed := (benutils.column_changed(p_old.attribute15

Line 797: hr_utility.set_location(' ben_ppf_trigger', 350);

793: ,p_new.attribute15,l_new_val) AND
794: benutils.column_changed(p_new.attribute15
795: ,p_old.attribute15,l_old_val) AND
796: (l_changed));
797: hr_utility.set_location(' ben_ppf_trigger', 350);
798: end if;
799: --
800: if l_column = 'ATTRIBUTE16' then
801: l_changed := (benutils.column_changed(p_old.attribute16

Line 806: hr_utility.set_location(' ben_ppf_trigger', 360);

802: ,p_new.attribute16,l_new_val) AND
803: benutils.column_changed(p_new.attribute16
804: ,p_old.attribute16,l_old_val) AND
805: (l_changed));
806: hr_utility.set_location(' ben_ppf_trigger', 360);
807: end if;
808: --
809: if l_column = 'ATTRIBUTE17' then
810: l_changed := (benutils.column_changed(p_old.attribute17

Line 815: hr_utility.set_location(' ben_ppf_trigger', 370);

811: ,p_new.attribute17,l_new_val) AND
812: benutils.column_changed(p_new.attribute17
813: ,p_old.attribute17,l_old_val) AND
814: (l_changed));
815: hr_utility.set_location(' ben_ppf_trigger', 370);
816: end if;
817: --
818: if l_column = 'ATTRIBUTE18' then
819: l_changed := (benutils.column_changed(p_old.attribute18

Line 824: hr_utility.set_location(' ben_ppf_trigger', 380);

820: ,p_new.attribute18,l_new_val) AND
821: benutils.column_changed(p_new.attribute18
822: ,p_old.attribute18,l_old_val) AND
823: (l_changed));
824: hr_utility.set_location(' ben_ppf_trigger', 380);
825: end if;
826: --
827: if l_column = 'ATTRIBUTE19' then
828: l_changed := (benutils.column_changed(p_old.attribute19

Line 833: hr_utility.set_location(' ben_ppf_trigger', 390);

829: ,p_new.attribute19,l_new_val) AND
830: benutils.column_changed(p_new.attribute19
831: ,p_old.attribute19,l_old_val) AND
832: (l_changed));
833: hr_utility.set_location(' ben_ppf_trigger', 390);
834: end if;
835: --
836: if l_column = 'ATTRIBUTE20' then
837: l_changed := (benutils.column_changed(p_old.attribute20

Line 842: hr_utility.set_location(' ben_ppf_trigger', 400);

838: ,p_new.attribute20,l_new_val) AND
839: benutils.column_changed(p_new.attribute20
840: ,p_old.attribute20,l_old_val) AND
841: (l_changed));
842: hr_utility.set_location(' ben_ppf_trigger', 400);
843: end if;
844: --
845: if l_column = 'ATTRIBUTE21' then
846: l_changed := (benutils.column_changed(p_old.attribute21

Line 851: hr_utility.set_location(' ben_ppf_trigger', 410);

847: ,p_new.attribute21,l_new_val) AND
848: benutils.column_changed(p_new.attribute21
849: ,p_old.attribute21,l_old_val) AND
850: (l_changed));
851: hr_utility.set_location(' ben_ppf_trigger', 410);
852: end if;
853: --
854: if l_column = 'ATTRIBUTE22' then
855: l_changed := (benutils.column_changed(p_old.attribute22

Line 860: hr_utility.set_location(' ben_ppf_trigger', 420);

856: ,p_new.attribute22,l_new_val) AND
857: benutils.column_changed(p_new.attribute22
858: ,p_old.attribute22,l_old_val) AND
859: (l_changed));
860: hr_utility.set_location(' ben_ppf_trigger', 420);
861: end if;
862: --
863: if l_column = 'ATTRIBUTE23' then
864: l_changed := (benutils.column_changed(p_old.attribute23

Line 869: hr_utility.set_location(' ben_ppf_trigger', 430);

865: ,p_new.attribute23,l_new_val) AND
866: benutils.column_changed(p_new.attribute23
867: ,p_old.attribute23,l_old_val) AND
868: (l_changed));
869: hr_utility.set_location(' ben_ppf_trigger', 430);
870: end if;
871: --
872: if l_column = 'ATTRIBUTE24' then
873: l_changed := (benutils.column_changed(p_old.attribute24

Line 878: hr_utility.set_location(' ben_ppf_trigger', 440);

874: ,p_new.attribute24,l_new_val) AND
875: benutils.column_changed(p_new.attribute24
876: ,p_old.attribute24,l_old_val) AND
877: (l_changed));
878: hr_utility.set_location(' ben_ppf_trigger', 440);
879: end if;
880: --
881: if l_column = 'ATTRIBUTE25' then
882: l_changed := (benutils.column_changed(p_old.attribute25

Line 887: hr_utility.set_location(' ben_ppf_trigger', 450);

883: ,p_new.attribute25,l_new_val) AND
884: benutils.column_changed(p_new.attribute25
885: ,p_old.attribute25,l_old_val) AND
886: (l_changed));
887: hr_utility.set_location(' ben_ppf_trigger', 450);
888: end if;
889: --
890: if l_column = 'ATTRIBUTE26' then
891: l_changed := (benutils.column_changed(p_old.attribute26

Line 896: hr_utility.set_location(' ben_ppf_trigger', 460);

892: ,p_new.attribute26,l_new_val) AND
893: benutils.column_changed(p_new.attribute26
894: ,p_old.attribute26,l_old_val) AND
895: (l_changed));
896: hr_utility.set_location(' ben_ppf_trigger', 460);
897: end if;
898: --
899: if l_column = 'ATTRIBUTE27' then
900: l_changed := (benutils.column_changed(p_old.attribute27

Line 905: hr_utility.set_location(' ben_ppf_trigger', 470);

901: ,p_new.attribute27,l_new_val) AND
902: benutils.column_changed(p_new.attribute27
903: ,p_old.attribute27,l_old_val) AND
904: (l_changed));
905: hr_utility.set_location(' ben_ppf_trigger', 470);
906: end if;
907: --
908: if l_column = 'ATTRIBUTE28' then
909: l_changed := (benutils.column_changed(p_old.attribute28

Line 914: hr_utility.set_location(' ben_ppf_trigger', 480);

910: ,p_new.attribute28,l_new_val) AND
911: benutils.column_changed(p_new.attribute28
912: ,p_old.attribute28,l_old_val) AND
913: (l_changed));
914: hr_utility.set_location(' ben_ppf_trigger', 480);
915: end if;
916: --
917: if l_column = 'ATTRIBUTE29' then
918: l_changed := (benutils.column_changed(p_old.attribute29

Line 923: hr_utility.set_location(' ben_ppf_trigger', 490);

919: ,p_new.attribute29,l_new_val) AND
920: benutils.column_changed(p_new.attribute29
921: ,p_old.attribute29,l_old_val) AND
922: (l_changed));
923: hr_utility.set_location(' ben_ppf_trigger', 490);
924: end if;
925: --
926: if l_column = 'ATTRIBUTE30' then
927: l_changed := (benutils.column_changed(p_old.attribute30

Line 932: hr_utility.set_location(' ben_ppf_trigger', 500);

928: ,p_new.attribute30,l_new_val) AND
929: benutils.column_changed(p_new.attribute30
930: ,p_old.attribute30,l_old_val) AND
931: (l_changed));
932: hr_utility.set_location(' ben_ppf_trigger', 500);
933: end if;
934: --
935: --
936: -- Checking the rule output and the rule override flag.

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

941: l_changed := TRUE ;
942: elsif l_rule_output = 'Y' and l_rule_overrides_flag = 'N' then
943: l_changed := l_changed AND TRUE;
944: elsif l_rule_output = 'N' then
945: hr_utility.set_location(' Rule output is N, so we should not trigger LE', 20.01);
946: l_changed := FALSE;
947: end if;
948:
949: hr_utility.set_location('After the rule Check ',20.05);

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

945: hr_utility.set_location(' Rule output is N, so we should not trigger LE', 20.01);
946: l_changed := FALSE;
947: end if;
948:
949: hr_utility.set_location('After the rule Check ',20.05);
950: if l_changed then
951: hr_utility.set_location(' l_change TRUE l_rule_overrides_flag '||l_rule_overrides_flag, 20.1);
952: else
953: hr_utility.set_location(' l_change FALSE l_rule_overrides_flag '||l_rule_overrides_flag, 20.1);

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

947: end if;
948:
949: hr_utility.set_location('After the rule Check ',20.05);
950: if l_changed then
951: hr_utility.set_location(' l_change TRUE l_rule_overrides_flag '||l_rule_overrides_flag, 20.1);
952: else
953: hr_utility.set_location(' l_change FALSE l_rule_overrides_flag '||l_rule_overrides_flag, 20.1);
954: end if;
955: -- Check for Column Mandatory Change

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

949: hr_utility.set_location('After the rule Check ',20.05);
950: if l_changed then
951: hr_utility.set_location(' l_change TRUE l_rule_overrides_flag '||l_rule_overrides_flag, 20.1);
952: else
953: hr_utility.set_location(' l_change FALSE l_rule_overrides_flag '||l_rule_overrides_flag, 20.1);
954: end if;
955: -- Check for Column Mandatory Change
956: -- If column change is mandatory and data change has failed then dont trigger
957: -- If column change is non-mandatory and the data change has passed, then trigger.

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

956: -- If column change is mandatory and data change has failed then dont trigger
957: -- If column change is non-mandatory and the data change has passed, then trigger.
958:
959: if l_chg_mandatory_cd = 'Y' and not l_changed then
960: hr_utility.set_location('Found Mandatory and its failed ', 20.1);
961: l_changed := FALSE;
962: l_trigger := FALSE;
963: exit;
964: elsif l_chg_mandatory_cd = 'Y' and l_changed then

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

961: l_changed := FALSE;
962: l_trigger := FALSE;
963: exit;
964: elsif l_chg_mandatory_cd = 'Y' and l_changed then
965: hr_utility.set_location('Found Mandatory and its passed ', 20.1);
966: l_changed := TRUE;
967: -- exit; */
968: elsif l_chg_mandatory_cd = 'N' and l_changed then
969: hr_utility.set_location('Found First Non-Mandatory and its passed ', 20.1);

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

965: hr_utility.set_location('Found Mandatory and its passed ', 20.1);
966: l_changed := TRUE;
967: -- exit; */
968: elsif l_chg_mandatory_cd = 'N' and l_changed then
969: hr_utility.set_location('Found First Non-Mandatory and its passed ', 20.1);
970: l_changed := TRUE;
971: l_trigger := TRUE;
972: exit;
973: end if;

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

970: l_changed := TRUE;
971: l_trigger := TRUE;
972: exit;
973: end if;
974: hr_utility.set_location('After the Mandatory code check ',20.05);
975: if l_changed then
976: hr_utility.set_location(' l_change TRUE ', 20.1);
977: else
978: hr_utility.set_location(' l_change FALSE ', 20.1);

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

972: exit;
973: end if;
974: hr_utility.set_location('After the Mandatory code check ',20.05);
975: if l_changed then
976: hr_utility.set_location(' l_change TRUE ', 20.1);
977: else
978: hr_utility.set_location(' l_change FALSE ', 20.1);
979: end if;
980: --

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

974: hr_utility.set_location('After the Mandatory code check ',20.05);
975: if l_changed then
976: hr_utility.set_location(' l_change TRUE ', 20.1);
977: else
978: hr_utility.set_location(' l_change FALSE ', 20.1);
979: end if;
980: --
981: /* if not l_changed then
982: exit;

Line 986: hr_utility.set_location(' ben_ppf_trigger', 30);

982: exit;
983: end if;
984: */
985: end loop;
986: hr_utility.set_location(' ben_ppf_trigger', 30);
987: l_ptnl_id := 0;
988: l_ovn :=null;
989: if l_trigger then
990: --

Line 1020: hr_utility.set_location(' Entering: ben_ppf_trigger5', 60);

1016: -- If an already existing life event of this
1017: -- type exists do nothing.
1018: --
1019: if le_exists%notfound then
1020: hr_utility.set_location(' Entering: ben_ppf_trigger5', 60);
1021: ben_create_ptnl_ler_for_per.create_ptnl_ler_event
1022: --ben_ptnl_ler_for_per_api.create_ptnl_ler_for_per
1023: (p_validate => false
1024: ,p_ptnl_ler_for_per_id => l_ptnl_id

Line 1038: hr_utility.set_location(' Entering: ben_ppf_trigger5-rp', 65);

1034: ,p_dtctd_dt => l_effective_start_date);
1035: end if;
1036: close le_exists;
1037: elsif l_type = 'R' then
1038: hr_utility.set_location(' Entering: ben_ppf_trigger5-rp', 65);
1039: --
1040: -- Related Life event has occured for Participant contacts
1041: --
1042: open get_contacts(p_new.person_id);

Line 1052: hr_utility.set_location(' Entering: ben_ppf_trigger5', 60);

1048: --
1049: -- If potential life event does not already exist
1050: -- create it.
1051: if le_exists%notfound then
1052: hr_utility.set_location(' Entering: ben_ppf_trigger5', 60);
1053:
1054: ben_create_ptnl_ler_for_per.create_ptnl_ler_event
1055: ---ben_ptnl_ler_for_per_api.create_ptnl_ler_for_per
1056: (p_validate => false

Line 1078: hr_utility.set_location(' ben_ppf_trigger', 40);

1074: end if;
1075: --
1076: -- reset the variables.
1077: --
1078: hr_utility.set_location(' ben_ppf_trigger', 40);
1079: l_changed := FALSE;
1080: l_trigger := TRUE;
1081: l_ovn := NULL;
1082: -- l_effective_start_date := p_new.effective_start_date;

Line 1086: hr_utility.set_location(' ben_ppf_trigger', 180);

1082: -- l_effective_start_date := p_new.effective_start_date;
1083: end if;
1084: close get_ler_col;
1085: end loop;
1086: hr_utility.set_location(' ben_ppf_trigger', 180);
1087: close get_ler;
1088: hr_utility.set_location(' Leaving: ben_ppf_trigger', 200);
1089:
1090: end;

Line 1088: hr_utility.set_location(' Leaving: ben_ppf_trigger', 200);

1084: close get_ler_col;
1085: end loop;
1086: hr_utility.set_location(' ben_ppf_trigger', 180);
1087: close get_ler;
1088: hr_utility.set_location(' Leaving: ben_ppf_trigger', 200);
1089:
1090: end;
1091: end ben_ppf_ler;