DBA Data[Home] [Help]

APPS.BEN_DT_TRGR_HANDLE dependencies on HR_UTILITY

Line 8: g_debug boolean := hr_utility.debug_enabled;

4: -- Package Variables
5: --
6: g_package varchar2(33) := ' ben_dt_trgr_handle.';
7: --
8: g_debug boolean := hr_utility.debug_enabled;
9: --
10: --
11: procedure person(p_rowid in VARCHAR2
12: ,p_business_group_id in NUMBER

Line 141: g_debug := hr_utility.debug_enabled;

137: benutils.set_data_migrator_mode;
138: --
139: -- Bug : 3320133
140: --
141: g_debug := hr_utility.debug_enabled;
142: if hr_general.g_data_migrator_mode not in ( 'Y','P') then
143: if g_debug then
144: hr_utility.set_location('Entering: '|| l_proc, 10);
145: hr_utility.set_location('p_mar_stat: '||p_marital_status||' '||l_proc, 10);

Line 144: hr_utility.set_location('Entering: '|| l_proc, 10);

140: --
141: g_debug := hr_utility.debug_enabled;
142: if hr_general.g_data_migrator_mode not in ( 'Y','P') then
143: if g_debug then
144: hr_utility.set_location('Entering: '|| l_proc, 10);
145: hr_utility.set_location('p_mar_stat: '||p_marital_status||' '||l_proc, 10);
146: hr_utility.set_location('p_per_esd: '||p_effective_start_date||' '||l_proc, 10);
147: hr_utility.set_location('rowid: '||p_rowid||' '||l_proc, 10);
148: end if;

Line 145: hr_utility.set_location('p_mar_stat: '||p_marital_status||' '||l_proc, 10);

141: g_debug := hr_utility.debug_enabled;
142: if hr_general.g_data_migrator_mode not in ( 'Y','P') then
143: if g_debug then
144: hr_utility.set_location('Entering: '|| l_proc, 10);
145: hr_utility.set_location('p_mar_stat: '||p_marital_status||' '||l_proc, 10);
146: hr_utility.set_location('p_per_esd: '||p_effective_start_date||' '||l_proc, 10);
147: hr_utility.set_location('rowid: '||p_rowid||' '||l_proc, 10);
148: end if;
149: --

Line 146: hr_utility.set_location('p_per_esd: '||p_effective_start_date||' '||l_proc, 10);

142: if hr_general.g_data_migrator_mode not in ( 'Y','P') then
143: if g_debug then
144: hr_utility.set_location('Entering: '|| l_proc, 10);
145: hr_utility.set_location('p_mar_stat: '||p_marital_status||' '||l_proc, 10);
146: hr_utility.set_location('p_per_esd: '||p_effective_start_date||' '||l_proc, 10);
147: hr_utility.set_location('rowid: '||p_rowid||' '||l_proc, 10);
148: end if;
149: --
150: ben_assignment_internal.copy_empasg_to_benasg

Line 147: hr_utility.set_location('rowid: '||p_rowid||' '||l_proc, 10);

143: if g_debug then
144: hr_utility.set_location('Entering: '|| l_proc, 10);
145: hr_utility.set_location('p_mar_stat: '||p_marital_status||' '||l_proc, 10);
146: hr_utility.set_location('p_per_esd: '||p_effective_start_date||' '||l_proc, 10);
147: hr_utility.set_location('rowid: '||p_rowid||' '||l_proc, 10);
148: end if;
149: --
150: ben_assignment_internal.copy_empasg_to_benasg
151: (p_person_id => p_person_id

Line 218: hr_utility.set_location('Leaving:'|| l_proc, 100);

214: --Bug 2215549 added p_effective_start_date parameter
215: --
216: ben_ppf_ler.ler_chk(l_old_rec,l_new_rec,p_effective_start_date );
217: if g_debug then
218: hr_utility.set_location('Leaving:'|| l_proc, 100);
219: end if;
220: end if;
221:
222: end person;

Line 348: g_debug := hr_utility.debug_enabled;

344: benutils.set_data_migrator_mode;
345: --
346: -- Bug : 3320133
347: --
348: g_debug := hr_utility.debug_enabled;
349: if hr_general.g_data_migrator_mode not in ( 'Y','P') then
350: if g_debug then
351: hr_utility.set_location('Entering: '|| l_proc, 10);
352: hr_utility.set_location('p_mar_stat: '||p_marital_status||' '||l_proc, 10);

Line 351: hr_utility.set_location('Entering: '|| l_proc, 10);

347: --
348: g_debug := hr_utility.debug_enabled;
349: if hr_general.g_data_migrator_mode not in ( 'Y','P') then
350: if g_debug then
351: hr_utility.set_location('Entering: '|| l_proc, 10);
352: hr_utility.set_location('p_mar_stat: '||p_marital_status||' '||l_proc, 10);
353: hr_utility.set_location('p_per_esd: '||p_effective_start_date||' '||l_proc, 10);
354: hr_utility.set_location('rowid: '||p_rowid||' '||l_proc, 10);
355: end if;

Line 352: hr_utility.set_location('p_mar_stat: '||p_marital_status||' '||l_proc, 10);

348: g_debug := hr_utility.debug_enabled;
349: if hr_general.g_data_migrator_mode not in ( 'Y','P') then
350: if g_debug then
351: hr_utility.set_location('Entering: '|| l_proc, 10);
352: hr_utility.set_location('p_mar_stat: '||p_marital_status||' '||l_proc, 10);
353: hr_utility.set_location('p_per_esd: '||p_effective_start_date||' '||l_proc, 10);
354: hr_utility.set_location('rowid: '||p_rowid||' '||l_proc, 10);
355: end if;
356:

Line 353: hr_utility.set_location('p_per_esd: '||p_effective_start_date||' '||l_proc, 10);

349: if hr_general.g_data_migrator_mode not in ( 'Y','P') then
350: if g_debug then
351: hr_utility.set_location('Entering: '|| l_proc, 10);
352: hr_utility.set_location('p_mar_stat: '||p_marital_status||' '||l_proc, 10);
353: hr_utility.set_location('p_per_esd: '||p_effective_start_date||' '||l_proc, 10);
354: hr_utility.set_location('rowid: '||p_rowid||' '||l_proc, 10);
355: end if;
356:
357: --

Line 354: hr_utility.set_location('rowid: '||p_rowid||' '||l_proc, 10);

350: if g_debug then
351: hr_utility.set_location('Entering: '|| l_proc, 10);
352: hr_utility.set_location('p_mar_stat: '||p_marital_status||' '||l_proc, 10);
353: hr_utility.set_location('p_per_esd: '||p_effective_start_date||' '||l_proc, 10);
354: hr_utility.set_location('rowid: '||p_rowid||' '||l_proc, 10);
355: end if;
356:
357: --
358: ben_assignment_internal.copy_empasg_to_benasg

Line 425: hr_utility.set_location('Leaving:'|| l_proc, 100);

421: l_new_rec.attribute30 := p_attribute30;
422: l_new_rec.person_id := p_person_id;
423: ben_ppf_ler.ler_chk(l_old_rec,l_new_rec,p_effective_start_date );
424: if g_debug then
425: hr_utility.set_location('Leaving:'|| l_proc, 100);
426: end if;
427: end if;
428:
429:

Line 560: g_debug := hr_utility.debug_enabled;

556: where rowid = p_rowid;
557: --
558: begin
559: --
560: g_debug := hr_utility.debug_enabled;
561: if hr_general.g_data_migrator_mode not in ( 'Y','P') then
562: if g_debug then
563: hr_utility.set_location('Entering:'|| l_proc, 10);
564: hr_utility.set_location('p_per_esd: '||p_effective_start_date||' '||l_proc, 10);

Line 563: hr_utility.set_location('Entering:'|| l_proc, 10);

559: --
560: g_debug := hr_utility.debug_enabled;
561: if hr_general.g_data_migrator_mode not in ( 'Y','P') then
562: if g_debug then
563: hr_utility.set_location('Entering:'|| l_proc, 10);
564: hr_utility.set_location('p_per_esd: '||p_effective_start_date||' '||l_proc, 10);
565: hr_utility.set_location('rowid: '||p_rowid||' '||l_proc, 10);
566: end if;
567: --

Line 564: hr_utility.set_location('p_per_esd: '||p_effective_start_date||' '||l_proc, 10);

560: g_debug := hr_utility.debug_enabled;
561: if hr_general.g_data_migrator_mode not in ( 'Y','P') then
562: if g_debug then
563: hr_utility.set_location('Entering:'|| l_proc, 10);
564: hr_utility.set_location('p_per_esd: '||p_effective_start_date||' '||l_proc, 10);
565: hr_utility.set_location('rowid: '||p_rowid||' '||l_proc, 10);
566: end if;
567: --
568: --Start of bug 10152981

Line 565: hr_utility.set_location('rowid: '||p_rowid||' '||l_proc, 10);

561: if hr_general.g_data_migrator_mode not in ( 'Y','P') then
562: if g_debug then
563: hr_utility.set_location('Entering:'|| l_proc, 10);
564: hr_utility.set_location('p_per_esd: '||p_effective_start_date||' '||l_proc, 10);
565: hr_utility.set_location('rowid: '||p_rowid||' '||l_proc, 10);
566: end if;
567: --
568: --Start of bug 10152981
569: /*

Line 703: hr_utility.set_location('Leaving:'|| l_proc, 100);

699:
700: --ben_asg_ler.ler_chk(l_old_rec,l_new_rec,p_effective_start_date); --ud commented
701: -- Bug# 12664112
702: if g_debug then
703: hr_utility.set_location('Leaving:'|| l_proc, 100);
704: end if;
705: end if;
706: --
707: end assignment;

Line 734: g_debug := hr_utility.debug_enabled;

730: l_old_rec ben_ptu_ler.g_ptu_ler_rec;
731: l_new_rec ben_ptu_ler.g_ptu_ler_rec;
732: --
733: begin
734: g_debug := hr_utility.debug_enabled;
735: if g_debug then
736: hr_utility.set_location('MUPPET',10);
737: end if;
738: --

Line 736: hr_utility.set_location('MUPPET',10);

732: --
733: begin
734: g_debug := hr_utility.debug_enabled;
735: if g_debug then
736: hr_utility.set_location('MUPPET',10);
737: end if;
738: --
739: if hr_general.g_data_migrator_mode not in ( 'Y','P') then
740: if g_debug then

Line 741: hr_utility.set_location('Entering:'|| l_proc, 10);

737: end if;
738: --
739: if hr_general.g_data_migrator_mode not in ( 'Y','P') then
740: if g_debug then
741: hr_utility.set_location('Entering:'|| l_proc, 10);
742: end if;
743: -- get old record
744: open get_old_ptu(p_rowid);
745: fetch get_old_ptu into l_old_rec;

Line 758: hr_utility.set_location('Leaving:'|| l_proc, 100);

754: -- l_new_rec.effective_end_date := p_effective_end_date;
755: --
756: ben_ptu_ler.ler_chk(l_old_rec,l_new_rec);
757: if g_debug then
758: hr_utility.set_location('Leaving:'|| l_proc, 100);
759: end if;
760: end if;
761: end person_type_usages;
762: */

Line 843: g_debug := hr_utility.debug_enabled;

839: --
840: begin
841: --
842:
843: g_debug := hr_utility.debug_enabled;
844: if hr_general.g_data_migrator_mode not in ( 'Y','P') then
845: if g_debug then
846: hr_utility.set_location('Entering:'|| l_proc, 10);
847: end if;

Line 846: hr_utility.set_location('Entering:'|| l_proc, 10);

842:
843: g_debug := hr_utility.debug_enabled;
844: if hr_general.g_data_migrator_mode not in ( 'Y','P') then
845: if g_debug then
846: hr_utility.set_location('Entering:'|| l_proc, 10);
847: end if;
848: --
849: -- Only create a benefit assignment if the actual termination date
850: -- is not null. When the hr apis are called to terminate an employee, we

Line 854: hr_utility.set_location('p_pds_old_atd: '|| p_pds_old_atd, 10);

850: -- is not null. When the hr apis are called to terminate an employee, we
851: -- do not want the benefit assignment created twice.
852: --
853: if g_debug then
854: hr_utility.set_location('p_pds_old_atd: '|| p_pds_old_atd, 10);
855: end if;
856: --
857: if (p_pds_old_atd is null and
858: p_pds_atd is not null) then

Line 896: hr_utility.set_location('To cancel ptu s for reverse termination : ', 1010);

892:
893: begin
894:
895: if g_debug then
896: hr_utility.set_location('To cancel ptu s for reverse termination : ', 1010);
897: end if;
898: if p_pds_atd is null and
899: p_pds_old_atd is not null
900: then

Line 902: hr_utility.set_location('Cancel ptu s for reverse termination Started : ', 1011);

898: if p_pds_atd is null and
899: p_pds_old_atd is not null
900: then
901: if g_debug then
902: hr_utility.set_location('Cancel ptu s for reverse termination Started : ', 1011);
903: end if;
904:
905: for l_ptu_index in c1_revterm_ptu
906: loop

Line 908: hr_utility.set_location('Cancel ptu s for contact_id : '||l_ptu_index.person_id

904:
905: for l_ptu_index in c1_revterm_ptu
906: loop
907: if g_debug then
908: hr_utility.set_location('Cancel ptu s for contact_id : '||l_ptu_index.person_id
909: ||' Of Type : '||l_ptu_index.system_person_type, 1012);
910: end if;
911: hr_per_type_usage_internal.cancel_person_type_usage
912: ( p_effective_date =>(p_pds_old_atd+1)

Line 919: hr_utility.set_location('Cancel ptu s for reverse termination Completed Normal: ', 1013);

915: );
916:
917: end loop;
918: if g_debug then
919: hr_utility.set_location('Cancel ptu s for reverse termination Completed Normal: ', 1013);
920: end if;
921:
922: end if;
923: exception when others then

Line 925: hr_utility.set_location('Cancel ptu s for reverse termination Completed with Exception: ', 1014);

921:
922: end if;
923: exception when others then
924: if g_debug then
925: hr_utility.set_location('Cancel ptu s for reverse termination Completed with Exception: ', 1014);
926: end if;
927: raise;
928: end;
929:

Line 943: hr_utility.set_location('Number of records:'|| l_num_recs, 10);

939: --
940: close c1;
941: --
942: if g_debug then
943: hr_utility.set_location('Number of records:'|| l_num_recs, 10);
944: end if;
945: --
946: if l_num_recs > 1 then
947: --

Line 953: hr_utility.set_location('Assignment not being deleted', 10);

949: --
950: l_delete_benass := false;
951: --
952: if g_debug then
953: hr_utility.set_location('Assignment not being deleted', 10);
954: end if;
955: --
956: else
957: --

Line 962: hr_utility.set_location('ATD'||p_pds_atd, 10);

958: -- Check if what we are updating has been nullified, in other words a
959: -- reverse termination.
960: --
961: if g_debug then
962: hr_utility.set_location('ATD'||p_pds_atd, 10);
963: end if;
964: --
965: if p_pds_atd is null and
966: p_pds_old_atd is not null -- Bug 1854968

Line 970: hr_utility.set_location('Assignment being deleted', 10);

966: p_pds_old_atd is not null -- Bug 1854968
967: then
968: --
969: if g_debug then
970: hr_utility.set_location('Assignment being deleted', 10);
971: end if;
972: l_delete_benass := true;
973: --
974: end if;

Line 1029: hr_utility.set_location('Leaving:'|| l_proc, 100);

1025: --
1026: end if;
1027: --
1028: if g_debug then
1029: hr_utility.set_location('Leaving:'|| l_proc, 100);
1030: end if;
1031: end if;
1032: --
1033: end periods_of_service;

Line 1068: g_debug := hr_utility.debug_enabled;

1064: --
1065: begin
1066:
1067: --
1068: g_debug := hr_utility.debug_enabled;
1069: if hr_general.g_data_migrator_mode not in ( 'Y','P') then
1070: if g_debug then
1071: hr_utility.set_location('Entering:'|| l_proc, 10);
1072: end if;

Line 1071: hr_utility.set_location('Entering:'|| l_proc, 10);

1067: --
1068: g_debug := hr_utility.debug_enabled;
1069: if hr_general.g_data_migrator_mode not in ( 'Y','P') then
1070: if g_debug then
1071: hr_utility.set_location('Entering:'|| l_proc, 10);
1072: end if;
1073: -- get old record
1074: open get_old_pbb(p_rowid);
1075: fetch get_old_pbb into l_old_rec;

Line 1087: hr_utility.set_location('Leaving:'|| l_proc, 100);

1083: l_new_rec.bnfts_bal_id := p_bnfts_bal_id;
1084: --
1085: ben_pbb_ler.ler_chk(l_old_rec,l_new_rec,p_effective_start_date );
1086: if g_debug then
1087: hr_utility.set_location('Leaving:'|| l_proc, 100);
1088: end if;
1089: end if;
1090: --
1091: end bnfts_bal;

Line 1123: g_debug := hr_utility.debug_enabled;

1119: l_old_rec ben_pbb_ler.g_pbb_ler_rec;
1120: l_new_rec ben_pbb_ler.g_pbb_ler_rec;
1121: begin
1122: --
1123: g_debug := hr_utility.debug_enabled;
1124: if hr_general.g_data_migrator_mode not in ( 'Y','P') then
1125: if g_debug then
1126: hr_utility.set_location('Entering:'|| l_proc, 10);
1127: end if;

Line 1126: hr_utility.set_location('Entering:'|| l_proc, 10);

1122: --
1123: g_debug := hr_utility.debug_enabled;
1124: if hr_general.g_data_migrator_mode not in ( 'Y','P') then
1125: if g_debug then
1126: hr_utility.set_location('Entering:'|| l_proc, 10);
1127: end if;
1128: -- get old record
1129: open get_old_pbb(p_rowid);
1130: fetch get_old_pbb into l_old_rec;

Line 1144: hr_utility.set_location('Leaving:'|| l_proc, 100);

1140: l_new_rec.per_bnfts_bal_id := p_bnfts_bal_id;
1141: --
1142: ben_pbb_ler.ler_chk(l_old_rec,l_new_rec,p_effective_start_date );
1143: if g_debug then
1144: hr_utility.set_location('Leaving:'|| l_proc, 100);
1145: end if;
1146: end if;
1147: --
1148: end bnfts_bal;

Line 1188: g_debug := hr_utility.debug_enabled;

1184: l_new_rec ben_ecd_ler.g_ecd_ler_rec;
1185: --
1186: begin
1187: --
1188: g_debug := hr_utility.debug_enabled;
1189: if hr_general.g_data_migrator_mode not in ( 'Y','P') then
1190: if g_debug then
1191: hr_utility.set_location('Entering:'|| l_proc, 10);
1192: end if;

Line 1191: hr_utility.set_location('Entering:'|| l_proc, 10);

1187: --
1188: g_debug := hr_utility.debug_enabled;
1189: if hr_general.g_data_migrator_mode not in ( 'Y','P') then
1190: if g_debug then
1191: hr_utility.set_location('Entering:'|| l_proc, 10);
1192: end if;
1193: -- get old record
1194: open get_old_ecd(p_rowid);
1195: fetch get_old_ecd into l_old_rec;

Line 1210: hr_utility.set_location('Leaving:'|| l_proc, 100);

1206: l_new_rec.ovrdn_thru_dt := p_ovrdn_thru_dt;
1207: --
1208: ben_ecd_ler.ler_chk(l_old_rec,l_new_rec,p_effective_start_date );
1209: if g_debug then
1210: hr_utility.set_location('Leaving:'|| l_proc, 100);
1211: end if;
1212: end if;
1213: --
1214: end elig_cvrd_dpnt;

Line 1254: g_debug := hr_utility.debug_enabled;

1250: --
1251: begin
1252: --
1253: --
1254: g_debug := hr_utility.debug_enabled;
1255: if hr_general.g_data_migrator_mode not in ( 'Y','P') then
1256: if g_debug then
1257: hr_utility.set_location('Entering:'|| l_proc, 10);
1258: end if;

Line 1257: hr_utility.set_location('Entering:'|| l_proc, 10);

1253: --
1254: g_debug := hr_utility.debug_enabled;
1255: if hr_general.g_data_migrator_mode not in ( 'Y','P') then
1256: if g_debug then
1257: hr_utility.set_location('Entering:'|| l_proc, 10);
1258: end if;
1259: -- get old record
1260: open get_old_ecd(p_rowid);
1261: fetch get_old_ecd into l_old_rec;

Line 1278: hr_utility.set_location('Leaving:'|| l_proc, 100);

1274: -- 9999 l_new_rec.elig_cvrd_dpnt_id := l_old_rec.elig_cvrd_dpnt_id;
1275: --
1276: ben_ecd_ler.ler_chk(l_old_rec,l_new_rec,p_effective_start_date );
1277: if g_debug then
1278: hr_utility.set_location('Leaving:'|| l_proc, 100);
1279: end if;
1280: end if;
1281: --
1282: end elig_cvrd_dpnt;

Line 1319: g_debug := hr_utility.debug_enabled;

1315: --
1316: begin
1317: --
1318: --
1319: g_debug := hr_utility.debug_enabled;
1320: if hr_general.g_data_migrator_mode not in ( 'Y','P') then
1321: if g_debug then
1322: hr_utility.set_location('Entering:'|| l_proc, 10);
1323: end if;

Line 1322: hr_utility.set_location('Entering:'|| l_proc, 10);

1318: --
1319: g_debug := hr_utility.debug_enabled;
1320: if hr_general.g_data_migrator_mode not in ( 'Y','P') then
1321: if g_debug then
1322: hr_utility.set_location('Entering:'|| l_proc, 10);
1323: end if;
1324: -- get old record
1325: open get_old_pen(p_rowid);
1326: fetch get_old_pen into l_old_rec;

Line 1339: hr_utility.set_location('Leaving:'|| l_proc, 100);

1335: l_new_rec.effective_end_date := p_effective_end_date;
1336: --
1337: ben_pen_ler.ler_chk(l_old_rec,l_new_rec,p_effective_start_date);
1338: if g_debug then
1339: hr_utility.set_location('Leaving:'|| l_proc, 100);
1340: end if;
1341: end if;
1342: --
1343: end prtt_enrt_rslt;

Line 1379: g_debug := hr_utility.debug_enabled;

1375: l_new_rec ben_pen_ler.g_pen_ler_rec;
1376: --
1377: begin
1378: --
1379: g_debug := hr_utility.debug_enabled;
1380: if hr_general.g_data_migrator_mode not in ( 'Y','P') then
1381: if g_debug then
1382: hr_utility.set_location('Entering:'|| l_proc, 10);
1383: end if;

Line 1382: hr_utility.set_location('Entering:'|| l_proc, 10);

1378: --
1379: g_debug := hr_utility.debug_enabled;
1380: if hr_general.g_data_migrator_mode not in ( 'Y','P') then
1381: if g_debug then
1382: hr_utility.set_location('Entering:'|| l_proc, 10);
1383: end if;
1384: -- get old record
1385: open get_old_pen(p_rowid);
1386: fetch get_old_pen into l_old_rec;

Line 1401: hr_utility.set_location('Leaving:'|| l_proc, 100);

1397: l_new_rec.PRTT_ENRT_RSLT_ID := p_PRTT_ENRT_RSLT_ID;
1398: --
1399: ben_pen_ler.ler_chk(l_old_rec,l_new_rec,p_effective_start_date);
1400: if g_debug then
1401: hr_utility.set_location('Leaving:'|| l_proc, 100);
1402: end if;
1403: end if;
1404: --
1405: end prtt_enrt_rslt;

Line 1428: hr_utility.set_location('Entering:'|| l_proc, 10);

1424: l_new_rec ben_eev_ler.g_eev_ler_rec;
1425: --
1426: begin
1427: if g_debug then
1428: hr_utility.set_location('Entering:'|| l_proc, 10);
1429: end if;
1430: -- get old record
1431: open get_old_eev(p_rowid);
1432: fetch get_old_eev into l_old_rec;

Line 1440: hr_utility.set_location('Leaving:'|| l_proc, 100);

1436: l_new_rec.screen_entry_value := p_screen_entry_value;
1437: --
1438: ben_eev_ler.ler_chk(l_old_rec,l_new_rec);
1439: if g_debug then
1440: hr_utility.set_location('Leaving:'|| l_proc, 100);
1441: end if;
1442: end elem_entry_values: ******************/
1443:
1444: /*******procedure asgn_budget_values

Line 1472: g_debug := hr_utility.debug_enabled;

1468: l_old_rec ben_abv_ler.g_abv_ler_rec;
1469: l_new_rec ben_abv_ler.g_abv_ler_rec;
1470: --
1471: begin
1472: g_debug := hr_utility.debug_enabled;
1473: if g_debug then
1474: hr_utility.set_location('Entering:'|| l_proc, 10);
1475: end if;
1476: -- get old record

Line 1474: hr_utility.set_location('Entering:'|| l_proc, 10);

1470: --
1471: begin
1472: g_debug := hr_utility.debug_enabled;
1473: if g_debug then
1474: hr_utility.set_location('Entering:'|| l_proc, 10);
1475: end if;
1476: -- get old record
1477: open get_old_abv(p_rowid);
1478: fetch get_old_abv into l_old_rec;

Line 1490: hr_utility.set_location('Leaving:'|| l_proc, 100);

1486: l_new_rec.effective_end_date := p_effective_end_date; ******
1487: --
1488: ben_abv_ler.ler_chk(l_old_rec,l_new_rec);
1489: if g_debug then
1490: hr_utility.set_location('Leaving:'|| l_proc, 100);
1491: end if;
1492: end asgn_budget_values;
1493: ********************************/
1494: