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

Line 42: hr_utility.set_location('Entering:'||l_proc, 5);

38: ) is
39: l_proc varchar2(72) := g_package||'chk_prtt_enrt_rslt_id';
40: l_api_updating boolean;
41: Begin
42: hr_utility.set_location('Entering:'||l_proc, 5);
43: l_api_updating := ben_pen_shd.api_updating
44: (p_effective_date => p_effective_date,
45: p_prtt_enrt_rslt_id => p_prtt_enrt_rslt_id,
46: p_object_version_number => p_object_version_number);

Line 68: hr_utility.set_location('Leaving:'||l_proc, 10);

64: --
65: end if;
66: --
67: end if;
68: hr_utility.set_location('Leaving:'||l_proc, 10);
69: End chk_prtt_enrt_rslt_id;
70: --
71: -- ----------------------------------------------------------------------------
72: -- |------< chk_enrt_ovridn_flag >------|

Line 106: hr_utility.set_location('Entering:'||l_proc, 5);

102: l_proc varchar2(72) := g_package||'chk_enrt_ovridn_flag';
103: l_api_updating boolean;
104: Begin
105: --
106: hr_utility.set_location('Entering:'||l_proc, 5);
107: --
108: l_api_updating := ben_pen_shd.api_updating
109: (p_prtt_enrt_rslt_id => p_prtt_enrt_rslt_id,
110: p_effective_date => p_effective_date,

Line 137: hr_utility.set_location('Leaving:'||l_proc,10);

133: end if;
134: --
135: end if;
136: --
137: hr_utility.set_location('Leaving:'||l_proc,10);
138: --
139: end chk_enrt_ovridn_flag;
140: --
141: -- ----------------------------------------------------------------------------

Line 176: hr_utility.set_location('Entering:'||l_proc, 5);

172: l_proc varchar2(72) := g_package||'chk_no_lngr_elig_flag';
173: l_api_updating boolean;
174: Begin
175: --
176: hr_utility.set_location('Entering:'||l_proc, 5);
177: --
178: l_api_updating := ben_pen_shd.api_updating
179: (p_prtt_enrt_rslt_id => p_prtt_enrt_rslt_id,
180: p_effective_date => p_effective_date,

Line 207: hr_utility.set_location('Leaving:'||l_proc,10);

203: end if;
204: --
205: end if;
206: --
207: hr_utility.set_location('Leaving:'||l_proc,10);
208: --
209: end chk_no_lngr_elig_flag;
210: --
211: --

Line 248: hr_utility.set_location('Entering:'||l_proc, 5);

244: l_api_updating boolean;
245: --
246: Begin
247: --
248: hr_utility.set_location('Entering:'||l_proc, 5);
249: --
250: l_api_updating := ben_pen_shd.api_updating
251: (p_prtt_enrt_rslt_id => p_prtt_enrt_rslt_id,
252: p_effective_date => p_effective_date,

Line 277: hr_utility.set_location('Leaving:'||l_proc,10);

273: fnd_message.raise_error;
274: end if;
275: --
276: end if;
277: hr_utility.set_location('Leaving:'||l_proc,10);
278: end chk_enrt_mthd_cd;
279: --
280: -- ----------------------------------------------------------------------------
281: -- |------< chk_uom >------|

Line 320: hr_utility.set_location('Entering:'||l_proc, 5);

316: from fnd_currencies_tl
317: where currency_code = p_uom ;
318: Begin
319: --
320: hr_utility.set_location('Entering:'||l_proc, 5);
321: --
322: l_api_updating := ben_pen_shd.api_updating
323: (p_prtt_enrt_rslt_id => p_prtt_enrt_rslt_id,
324: p_effective_date => p_effective_date,

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

347: close c1;
348: --
349: end if;
350: --
351: hr_utility.set_location('Leaving:'||l_proc,10);
352: --
353: end chk_uom ;
354: --
355: -- ----------------------------------------------------------------------------

Line 391: hr_utility.set_location('Entering:'||l_proc, 5);

387: l_api_updating boolean;
388: --
389: Begin
390: --
391: hr_utility.set_location('Entering:'||l_proc, 5);
392: --
393: l_api_updating := ben_pen_shd.api_updating
394: (p_prtt_enrt_rslt_id => p_prtt_enrt_rslt_id,
395: p_effective_date => p_effective_date,

Line 421: hr_utility.set_location('Leaving:'||l_proc,10);

417: end if;
418: --
419: end if;
420: --
421: hr_utility.set_location('Leaving:'||l_proc,10);
422: --
423: end chk_prtt_is_cvrd_flag;
424: --
425: -- ----------------------------------------------------------------------------

Line 461: hr_utility.set_location('Entering:'||l_proc, 5);

457: l_api_updating boolean;
458: --
459: Begin
460: --
461: hr_utility.set_location('Entering:'||l_proc, 5);
462: --
463: l_api_updating := ben_pen_shd.api_updating
464: (p_prtt_enrt_rslt_id => p_prtt_enrt_rslt_id,
465: p_effective_date => p_effective_date,

Line 491: hr_utility.set_location('Leaving:'||l_proc,10);

487: end if;
488: --
489: end if;
490: --
491: hr_utility.set_location('Leaving:'||l_proc,10);
492: --
493: end chk_sspndd_flag;
494: --
495: -- ----------------------------------------------------------------------------

Line 531: hr_utility.set_location('Entering:'||l_proc, 5);

527: l_api_updating boolean;
528: --
529: Begin
530: --
531: hr_utility.set_location('Entering:'||l_proc, 5);
532: --
533: l_api_updating := ben_pen_shd.api_updating
534: (p_prtt_enrt_rslt_id => p_prtt_enrt_rslt_id,
535: p_effective_date => p_effective_date,

Line 561: hr_utility.set_location('Leaving:'||l_proc,10);

557: end if;
558: --
559: end if;
560: --
561: hr_utility.set_location('Leaving:'||l_proc,10);
562: --
563: end chk_comp_lvl_cd;
564: --
565: -- --------------------------------------------------------------------------

Line 601: hr_utility.set_location('Entering:'||l_proc, 5);

597: l_api_updating boolean;
598: --
599: Begin
600: --
601: hr_utility.set_location('Entering:'||l_proc, 5);
602: --
603: l_api_updating := ben_pen_shd.api_updating
604: (p_prtt_enrt_rslt_id => p_prtt_enrt_rslt_id,
605: p_effective_date => p_effective_date,

Line 629: hr_utility.set_location('Leaving:'||l_proc,10);

625: fnd_message.set_token('TYPE','BEN_NNMNTRY_UOM');
626: fnd_message.raise_error;
627: end if;
628: end if;
629: hr_utility.set_location('Leaving:'||l_proc,10);
630: --
631: end chk_bnft_nnmntry_uom;
632: --
633: -- --------------------------------------------------------------------------

Line 669: hr_utility.set_location('Entering:'||l_proc, 5);

665: l_api_updating boolean;
666: --
667: Begin
668: --
669: hr_utility.set_location('Entering:'||l_proc, 5);
670: --
671: l_api_updating := ben_pen_shd.api_updating
672: (p_prtt_enrt_rslt_id => p_prtt_enrt_rslt_id,
673: p_effective_date => p_effective_date,

Line 698: hr_utility.set_location('Leaving:'||l_proc,10);

694: fnd_message.raise_error;
695: end if;
696: --
697: end if;
698: hr_utility.set_location('Leaving:'||l_proc,10);
699:
700: end chk_bnft_typ_cd;
701: --
702: -- --------------------------------------------------------------------------

Line 738: hr_utility.set_location('Entering:'||l_proc, 5);

734: l_api_updating boolean;
735: --
736: Begin
737: --
738: hr_utility.set_location('Entering:'||l_proc, 5);
739: --
740: l_api_updating := ben_pen_shd.api_updating
741: (p_prtt_enrt_rslt_id => p_prtt_enrt_rslt_id,
742: p_effective_date => p_effective_date,

Line 767: hr_utility.set_location('Leaving:'||l_proc,10);

763: fnd_message.raise_error;
764: end if;
765: --
766: end if;
767: hr_utility.set_location('Leaving:'||l_proc,10);
768:
769: end chk_prtt_enrt_rslt_stat_cd;
770: --
771: --

Line 809: hr_utility.set_location('Entering:'||l_proc, 5);

805: l_api_updating boolean;
806: --
807: Begin
808: --
809: hr_utility.set_location('Entering:'||l_proc, 5);
810: --
811: l_api_updating := ben_pen_shd.api_updating
812: (p_prtt_enrt_rslt_id => p_prtt_enrt_rslt_id,
813: p_effective_date => p_effective_date,

Line 836: hr_utility.set_location('Leaving:'||l_proc,10);

832: fnd_message.set_token('TYPE','BEN_OVRID_RSN');
833: fnd_message.raise_error;
834: end if;
835: end if;
836: hr_utility.set_location('Leaving:'||l_proc,10);
837: end chk_enrt_ovrid_rsn_cd;
838: --
839: -- ---------------------------------------------------------------------------
840: -- |------------------------< crt_ordr_warning >----------------------------|

Line 1023: hr_utility.set_location ('Entering:' || l_proc, 5);

1019: l_message fnd_new_messages.message_name%TYPE := 'BEN_92430_CRT_ORD_WARNING';
1020: l_cobra_pgm BOOLEAN := FALSE;
1021: --
1022: BEGIN
1023: hr_utility.set_location ('Entering:' || l_proc, 5);
1024: --
1025: hr_utility.set_location ('Checking court order at PEN level', 12);
1026: --
1027: ben_cobj_cache.get_pl_dets (p_business_group_id => p_business_group_id,

Line 1025: hr_utility.set_location ('Checking court order at PEN level', 12);

1021: --
1022: BEGIN
1023: hr_utility.set_location ('Entering:' || l_proc, 5);
1024: --
1025: hr_utility.set_location ('Checking court order at PEN level', 12);
1026: --
1027: ben_cobj_cache.get_pl_dets (p_business_group_id => p_business_group_id,
1028: p_effective_date => p_effective_date,
1029: p_pl_id => p_pl_id,

Line 1070: hr_utility.set_location ('Level = ' || l_level, 40);

1066: --
1067: --
1068: -- Retrieve designation code
1069: --
1070: hr_utility.set_location ('Level = ' || l_level, 40);
1071:
1072: IF l_level = 'PGM'
1073: THEN
1074: --

Line 1100: hr_utility.set_location ('dsgn code = ' || l_code, 40);

1096: l_code := NULL;
1097: --
1098: END IF;
1099: --
1100: hr_utility.set_location ('dsgn code = ' || l_code, 40);
1101: --
1102: IF l_code IS NOT NULL AND
1103: NOT l_cobra_pgm
1104: THEN

Line 1107: hr_utility.set_location ('ACE p_prtt_enrt_rslt_id = ' || p_prtt_enrt_rslt_id, 9999 );

1103: NOT l_cobra_pgm
1104: THEN
1105: --
1106: /*
1107: hr_utility.set_location ('ACE p_prtt_enrt_rslt_id = ' || p_prtt_enrt_rslt_id, 9999 );
1108: hr_utility.set_location ('ACE p_effective_date = ' || p_effective_date, 9999 );
1109: hr_utility.set_location ('ACE p_business_group_id = ' || p_business_group_id, 9999 );
1110: hr_utility.set_location ('ACE p_enrt_cvg_strt_dt = ' || p_enrt_cvg_strt_dt, 9999 );
1111: */

Line 1108: hr_utility.set_location ('ACE p_effective_date = ' || p_effective_date, 9999 );

1104: THEN
1105: --
1106: /*
1107: hr_utility.set_location ('ACE p_prtt_enrt_rslt_id = ' || p_prtt_enrt_rslt_id, 9999 );
1108: hr_utility.set_location ('ACE p_effective_date = ' || p_effective_date, 9999 );
1109: hr_utility.set_location ('ACE p_business_group_id = ' || p_business_group_id, 9999 );
1110: hr_utility.set_location ('ACE p_enrt_cvg_strt_dt = ' || p_enrt_cvg_strt_dt, 9999 );
1111: */
1112: --

Line 1109: hr_utility.set_location ('ACE p_business_group_id = ' || p_business_group_id, 9999 );

1105: --
1106: /*
1107: hr_utility.set_location ('ACE p_prtt_enrt_rslt_id = ' || p_prtt_enrt_rslt_id, 9999 );
1108: hr_utility.set_location ('ACE p_effective_date = ' || p_effective_date, 9999 );
1109: hr_utility.set_location ('ACE p_business_group_id = ' || p_business_group_id, 9999 );
1110: hr_utility.set_location ('ACE p_enrt_cvg_strt_dt = ' || p_enrt_cvg_strt_dt, 9999 );
1111: */
1112: --
1113: OPEN c_lf_evt_ocrd_dt;

Line 1110: hr_utility.set_location ('ACE p_enrt_cvg_strt_dt = ' || p_enrt_cvg_strt_dt, 9999 );

1106: /*
1107: hr_utility.set_location ('ACE p_prtt_enrt_rslt_id = ' || p_prtt_enrt_rslt_id, 9999 );
1108: hr_utility.set_location ('ACE p_effective_date = ' || p_effective_date, 9999 );
1109: hr_utility.set_location ('ACE p_business_group_id = ' || p_business_group_id, 9999 );
1110: hr_utility.set_location ('ACE p_enrt_cvg_strt_dt = ' || p_enrt_cvg_strt_dt, 9999 );
1111: */
1112: --
1113: OPEN c_lf_evt_ocrd_dt;
1114: --

Line 1131: hr_utility.set_location ('ACE l_name = ' || l_name, 9999);

1127: --
1128: EXIT WHEN c_crt_ordr%NOTFOUND;
1129: --
1130: /*
1131: hr_utility.set_location ('ACE l_name = ' || l_name, 9999);
1132: hr_utility.set_location ('ACE l_dpnt_id = ' || l_dpnt_id, 9999);
1133: hr_utility.set_location ('ACE l_benefit_name = ' || l_benefit_name, 9999);
1134: hr_utility.set_location ('ACE l_lf_evt_ocrd_dt = ' || l_lf_evt_ocrd_dt, 9999 );
1135: hr_utility.set_location ('ACE l_crt_ordr_typ_cd = ' || l_crt_ordr_typ_cd, 9999 );

Line 1132: hr_utility.set_location ('ACE l_dpnt_id = ' || l_dpnt_id, 9999);

1128: EXIT WHEN c_crt_ordr%NOTFOUND;
1129: --
1130: /*
1131: hr_utility.set_location ('ACE l_name = ' || l_name, 9999);
1132: hr_utility.set_location ('ACE l_dpnt_id = ' || l_dpnt_id, 9999);
1133: hr_utility.set_location ('ACE l_benefit_name = ' || l_benefit_name, 9999);
1134: hr_utility.set_location ('ACE l_lf_evt_ocrd_dt = ' || l_lf_evt_ocrd_dt, 9999 );
1135: hr_utility.set_location ('ACE l_crt_ordr_typ_cd = ' || l_crt_ordr_typ_cd, 9999 );
1136: */

Line 1133: hr_utility.set_location ('ACE l_benefit_name = ' || l_benefit_name, 9999);

1129: --
1130: /*
1131: hr_utility.set_location ('ACE l_name = ' || l_name, 9999);
1132: hr_utility.set_location ('ACE l_dpnt_id = ' || l_dpnt_id, 9999);
1133: hr_utility.set_location ('ACE l_benefit_name = ' || l_benefit_name, 9999);
1134: hr_utility.set_location ('ACE l_lf_evt_ocrd_dt = ' || l_lf_evt_ocrd_dt, 9999 );
1135: hr_utility.set_location ('ACE l_crt_ordr_typ_cd = ' || l_crt_ordr_typ_cd, 9999 );
1136: */
1137: hr_utility.set_location('Found Court Order', 9999);

Line 1134: hr_utility.set_location ('ACE l_lf_evt_ocrd_dt = ' || l_lf_evt_ocrd_dt, 9999 );

1130: /*
1131: hr_utility.set_location ('ACE l_name = ' || l_name, 9999);
1132: hr_utility.set_location ('ACE l_dpnt_id = ' || l_dpnt_id, 9999);
1133: hr_utility.set_location ('ACE l_benefit_name = ' || l_benefit_name, 9999);
1134: hr_utility.set_location ('ACE l_lf_evt_ocrd_dt = ' || l_lf_evt_ocrd_dt, 9999 );
1135: hr_utility.set_location ('ACE l_crt_ordr_typ_cd = ' || l_crt_ordr_typ_cd, 9999 );
1136: */
1137: hr_utility.set_location('Found Court Order', 9999);
1138: --

Line 1135: hr_utility.set_location ('ACE l_crt_ordr_typ_cd = ' || l_crt_ordr_typ_cd, 9999 );

1131: hr_utility.set_location ('ACE l_name = ' || l_name, 9999);
1132: hr_utility.set_location ('ACE l_dpnt_id = ' || l_dpnt_id, 9999);
1133: hr_utility.set_location ('ACE l_benefit_name = ' || l_benefit_name, 9999);
1134: hr_utility.set_location ('ACE l_lf_evt_ocrd_dt = ' || l_lf_evt_ocrd_dt, 9999 );
1135: hr_utility.set_location ('ACE l_crt_ordr_typ_cd = ' || l_crt_ordr_typ_cd, 9999 );
1136: */
1137: hr_utility.set_location('Found Court Order', 9999);
1138: --
1139: OPEN c_elig_dpnt;

Line 1137: hr_utility.set_location('Found Court Order', 9999);

1133: hr_utility.set_location ('ACE l_benefit_name = ' || l_benefit_name, 9999);
1134: hr_utility.set_location ('ACE l_lf_evt_ocrd_dt = ' || l_lf_evt_ocrd_dt, 9999 );
1135: hr_utility.set_location ('ACE l_crt_ordr_typ_cd = ' || l_crt_ordr_typ_cd, 9999 );
1136: */
1137: hr_utility.set_location('Found Court Order', 9999);
1138: --
1139: OPEN c_elig_dpnt;
1140: --
1141: FETCH c_elig_dpnt INTO l_dummy;

Line 1146: hr_utility.set_location ('C_ELIG_DPNT Not Found', 9999);

1142: --
1143: IF c_elig_dpnt%NOTFOUND
1144: THEN
1145: --
1146: hr_utility.set_location ('C_ELIG_DPNT Not Found', 9999);
1147: --
1148: l_crt_ordr_meaning := hr_general.decode_lookup
1149: (p_lookup_type => 'BEN_CRT_ORDR_TYP',
1150: p_lookup_code => l_crt_ordr_typ_cd

Line 1174: hr_utility.set_location ('Leaving:' || l_proc, 10);

1170: END IF;
1171: --
1172: END IF;
1173: --
1174: hr_utility.set_location ('Leaving:' || l_proc, 10);
1175: --
1176: END crt_ordr_warning;
1177: --
1178: --

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

1206: l_jurisdiction_code varchar2(30);
1207: l_elig_per_elctbl_chc_id number;
1208: -- 3427367
1209: begin
1210: hr_utility.set_location ('Entering '||l_proc,10);
1211: --
1212: -- Call formula initialise routine
1213: --
1214: -- 3427367

Line 1242: hr_utility.set_location ('Leaving '||l_proc,50);

1238: --
1239: l_return := to_number(l_outputs(l_outputs.first).value);
1240:
1241: return l_return;
1242: hr_utility.set_location ('Leaving '||l_proc,50);
1243: exception
1244: when others then
1245: hr_utility.set_location ('Fail in '||l_proc|| ' step in '||
1246: to_char(l_step),999);

Line 1245: hr_utility.set_location ('Fail in '||l_proc|| ' step in '||

1241: return l_return;
1242: hr_utility.set_location ('Leaving '||l_proc,50);
1243: exception
1244: when others then
1245: hr_utility.set_location ('Fail in '||l_proc|| ' step in '||
1246: to_char(l_step),999);
1247: raise;
1248: end;
1249: --

Line 1282: hr_utility.set_location ('Entering '||l_proc,70);

1278: l_jurisdiction_code varchar2(30);
1279: l_elig_per_elctbl_chc_id number;
1280: -- 3427367
1281: begin
1282: hr_utility.set_location ('Entering '||l_proc,70);
1283: --
1284: -- Call formula initialise routine
1285: --
1286: -- 3427367

Line 1314: hr_utility.set_location ('Leaving '||l_proc,70);

1310: --
1311: l_return := to_number(l_outputs(l_outputs.first).value);
1312:
1313: return l_return;
1314: hr_utility.set_location ('Leaving '||l_proc,70);
1315: exception
1316: when others then
1317: hr_utility.set_location ('Fail in '||l_proc || ' step in ' ||
1318: to_char(l_step),999);

Line 1317: hr_utility.set_location ('Fail in '||l_proc || ' step in ' ||

1313: return l_return;
1314: hr_utility.set_location ('Leaving '||l_proc,70);
1315: exception
1316: when others then
1317: hr_utility.set_location ('Fail in '||l_proc || ' step in ' ||
1318: to_char(l_step),999);
1319: raise;
1320: end;
1321: --

Line 1339: hr_utility.set_location('Entering get_opts_and_cvg ',1234);

1335: l_max_opts number := 0; -- number(8) := 0; bug 2649163
1336: l_tot_amt_no_interim number := 0;
1337: l_max_amt_no_interim number := 0;
1338: begin
1339: hr_utility.set_location('Entering get_opts_and_cvg ',1234);
1340: hr_utility.set_location(' p_enrt_cnt '||p_enrt_cnt,1234);
1341: for i in 1..p_enrt_cnt loop
1342: l_tot_amt := 0;
1343: l_tot_opts := 0;

Line 1340: hr_utility.set_location(' p_enrt_cnt '||p_enrt_cnt,1234);

1336: l_tot_amt_no_interim number := 0;
1337: l_max_amt_no_interim number := 0;
1338: begin
1339: hr_utility.set_location('Entering get_opts_and_cvg ',1234);
1340: hr_utility.set_location(' p_enrt_cnt '||p_enrt_cnt,1234);
1341: for i in 1..p_enrt_cnt loop
1342: l_tot_amt := 0;
1343: l_tot_opts := 0;
1344: l_tot_amt_no_interim := 0 ;

Line 1350: hr_utility.set_location(' j '||j,1234);

1346: if (p_enrt_tbl(i).enrt_cvg_strt_dt between
1347: p_enrt_tbl(j).enrt_cvg_strt_dt and
1348: nvl(p_enrt_tbl(j).enrt_cvg_thru_dt,hr_api.g_eot)
1349: ) then
1350: hr_utility.set_location(' j '||j,1234);
1351: if (p_enrt_tbl(j).calc_interm = 1) then
1352: if (nvl(p_enrt_tbl(j).SSPNDD_FLAG, 'X') <> 'Y') then
1353: hr_utility.set_location(' l_tot_amt before '||l_tot_amt,1234);
1354: l_tot_amt := l_tot_amt+nvl(p_enrt_tbl(j).bnft_amt,0);

Line 1353: hr_utility.set_location(' l_tot_amt before '||l_tot_amt,1234);

1349: ) then
1350: hr_utility.set_location(' j '||j,1234);
1351: if (p_enrt_tbl(j).calc_interm = 1) then
1352: if (nvl(p_enrt_tbl(j).SSPNDD_FLAG, 'X') <> 'Y') then
1353: hr_utility.set_location(' l_tot_amt before '||l_tot_amt,1234);
1354: l_tot_amt := l_tot_amt+nvl(p_enrt_tbl(j).bnft_amt,0);
1355: hr_utility.set_location(' l_tot_amt after '||l_tot_amt,1234);
1356: end if;
1357: else

Line 1355: hr_utility.set_location(' l_tot_amt after '||l_tot_amt,1234);

1351: if (p_enrt_tbl(j).calc_interm = 1) then
1352: if (nvl(p_enrt_tbl(j).SSPNDD_FLAG, 'X') <> 'Y') then
1353: hr_utility.set_location(' l_tot_amt before '||l_tot_amt,1234);
1354: l_tot_amt := l_tot_amt+nvl(p_enrt_tbl(j).bnft_amt,0);
1355: hr_utility.set_location(' l_tot_amt after '||l_tot_amt,1234);
1356: end if;
1357: else
1358: if p_enrt_tbl(j).interim_flag = 'N' then
1359: hr_utility.set_location(' interim_flag before '||l_tot_amt,1234);

Line 1359: hr_utility.set_location(' interim_flag before '||l_tot_amt,1234);

1355: hr_utility.set_location(' l_tot_amt after '||l_tot_amt,1234);
1356: end if;
1357: else
1358: if p_enrt_tbl(j).interim_flag = 'N' then
1359: hr_utility.set_location(' interim_flag before '||l_tot_amt,1234);
1360: l_tot_amt := l_tot_amt + nvl(p_enrt_tbl(j).bnft_amt,0);
1361: hr_utility.set_location(' interim_flag after '||l_tot_amt,1234);
1362: end if;
1363: end if;

Line 1361: hr_utility.set_location(' interim_flag after '||l_tot_amt,1234);

1357: else
1358: if p_enrt_tbl(j).interim_flag = 'N' then
1359: hr_utility.set_location(' interim_flag before '||l_tot_amt,1234);
1360: l_tot_amt := l_tot_amt + nvl(p_enrt_tbl(j).bnft_amt,0);
1361: hr_utility.set_location(' interim_flag after '||l_tot_amt,1234);
1362: end if;
1363: end if;
1364: if (p_enrt_tbl(j).interim_flag = 'N') then
1365: l_tot_opts := l_tot_opts + 1;

Line 1370: hr_utility.set_location(' before l_max_amt '||l_max_amt,1234);

1366: l_tot_amt_no_interim:=l_tot_amt_no_interim+nvl(p_enrt_tbl(j).bnft_amt,0);
1367: end if;
1368: end if;
1369: end loop;
1370: hr_utility.set_location(' before l_max_amt '||l_max_amt,1234);
1371: l_max_amt := greatest(l_tot_amt, l_max_amt);
1372: l_max_opts := greatest(l_max_opts,l_tot_opts);
1373: l_max_amt_no_interim := greatest(l_max_amt_no_interim,l_tot_amt_no_interim);
1374: hr_utility.set_location(' after l_max_amt '||l_max_amt,1234);

Line 1374: hr_utility.set_location(' after l_max_amt '||l_max_amt,1234);

1370: hr_utility.set_location(' before l_max_amt '||l_max_amt,1234);
1371: l_max_amt := greatest(l_tot_amt, l_max_amt);
1372: l_max_opts := greatest(l_max_opts,l_tot_opts);
1373: l_max_amt_no_interim := greatest(l_max_amt_no_interim,l_tot_amt_no_interim);
1374: hr_utility.set_location(' after l_max_amt '||l_max_amt,1234);
1375: end loop;
1376: hr_utility.set_location(' before p_tot_amt '||p_tot_amt,1234);
1377: p_tot_amt := l_max_amt;
1378: p_tot_opts := l_max_opts;

Line 1376: hr_utility.set_location(' before p_tot_amt '||p_tot_amt,1234);

1372: l_max_opts := greatest(l_max_opts,l_tot_opts);
1373: l_max_amt_no_interim := greatest(l_max_amt_no_interim,l_tot_amt_no_interim);
1374: hr_utility.set_location(' after l_max_amt '||l_max_amt,1234);
1375: end loop;
1376: hr_utility.set_location(' before p_tot_amt '||p_tot_amt,1234);
1377: p_tot_amt := l_max_amt;
1378: p_tot_opts := l_max_opts;
1379: --p_tot_amt_no_interim := l_tot_amt_no_interim;
1380: hr_utility.set_location(' after p_tot_amt '||p_tot_amt,1234);

Line 1380: hr_utility.set_location(' after p_tot_amt '||p_tot_amt,1234);

1376: hr_utility.set_location(' before p_tot_amt '||p_tot_amt,1234);
1377: p_tot_amt := l_max_amt;
1378: p_tot_opts := l_max_opts;
1379: --p_tot_amt_no_interim := l_tot_amt_no_interim;
1380: hr_utility.set_location(' after p_tot_amt '||p_tot_amt,1234);
1381: end get_opts_and_cvg;
1382: --
1383: -- ----------------------------------------------------------------------------
1384: -- |-------------------------------------------------------|

Line 1411: hr_utility.set_location('i INSIDE p_enrt_tbl(i).pl_id'||p_enrt_tbl(i).pl_id,111);

1407: p_dpnt_cvd_by_othr_apls_flag := 'N';
1408: --
1409: for i in 1..p_enrt_cnt loop
1410: /*
1411: hr_utility.set_location('i INSIDE p_enrt_tbl(i).pl_id'||p_enrt_tbl(i).pl_id,111);
1412: hr_utility.set_location('i INSIDE p_enrt_tbl(i).pl_id'||p_enrt_tbl(i).pl_id,111);
1413: hr_utility.set_location('i INSIDE SSPNDD_FLAG'||p_enrt_tbl(i).SSPNDD_FLAG,111);
1414: hr_utility.set_location('i INSIDE Bnft I'||p_enrt_tbl(i).bnft_amt,111);
1415: */

Line 1412: hr_utility.set_location('i INSIDE p_enrt_tbl(i).pl_id'||p_enrt_tbl(i).pl_id,111);

1408: --
1409: for i in 1..p_enrt_cnt loop
1410: /*
1411: hr_utility.set_location('i INSIDE p_enrt_tbl(i).pl_id'||p_enrt_tbl(i).pl_id,111);
1412: hr_utility.set_location('i INSIDE p_enrt_tbl(i).pl_id'||p_enrt_tbl(i).pl_id,111);
1413: hr_utility.set_location('i INSIDE SSPNDD_FLAG'||p_enrt_tbl(i).SSPNDD_FLAG,111);
1414: hr_utility.set_location('i INSIDE Bnft I'||p_enrt_tbl(i).bnft_amt,111);
1415: */
1416: l_tot_amt := 0;

Line 1413: hr_utility.set_location('i INSIDE SSPNDD_FLAG'||p_enrt_tbl(i).SSPNDD_FLAG,111);

1409: for i in 1..p_enrt_cnt loop
1410: /*
1411: hr_utility.set_location('i INSIDE p_enrt_tbl(i).pl_id'||p_enrt_tbl(i).pl_id,111);
1412: hr_utility.set_location('i INSIDE p_enrt_tbl(i).pl_id'||p_enrt_tbl(i).pl_id,111);
1413: hr_utility.set_location('i INSIDE SSPNDD_FLAG'||p_enrt_tbl(i).SSPNDD_FLAG,111);
1414: hr_utility.set_location('i INSIDE Bnft I'||p_enrt_tbl(i).bnft_amt,111);
1415: */
1416: l_tot_amt := 0;
1417: l_tot_pls := 0;

Line 1414: hr_utility.set_location('i INSIDE Bnft I'||p_enrt_tbl(i).bnft_amt,111);

1410: /*
1411: hr_utility.set_location('i INSIDE p_enrt_tbl(i).pl_id'||p_enrt_tbl(i).pl_id,111);
1412: hr_utility.set_location('i INSIDE p_enrt_tbl(i).pl_id'||p_enrt_tbl(i).pl_id,111);
1413: hr_utility.set_location('i INSIDE SSPNDD_FLAG'||p_enrt_tbl(i).SSPNDD_FLAG,111);
1414: hr_utility.set_location('i INSIDE Bnft I'||p_enrt_tbl(i).bnft_amt,111);
1415: */
1416: l_tot_amt := 0;
1417: l_tot_pls := 0;
1418: l_tot_amt_no_interim := 0 ;

Line 1423: hr_utility.set_location('J INSIDE p_enrt_tbl(j).pl_id'||p_enrt_tbl(j).pl_id,111);

1419: --l_pl_tbl.delete;
1420: --l_cnt := 0;
1421: for j in 1..p_enrt_cnt loop
1422: --
1423: hr_utility.set_location('J INSIDE p_enrt_tbl(j).pl_id'||p_enrt_tbl(j).pl_id,111);
1424: hr_utility.set_location('J INSIDE p_enrt_tbl(i).pl_id'||p_enrt_tbl(i).pl_id,111);
1425: hr_utility.set_location('J INSIDE SSPNDD_FLAG'||p_enrt_tbl(j).SSPNDD_FLAG,111);
1426: hr_utility.set_location('i INSIDE Bnft J '||p_enrt_tbl(j).bnft_amt,111);
1427: hr_utility.set_location('i INSIDE interim J'||p_enrt_tbl(j).interim_flag,111);

Line 1424: hr_utility.set_location('J INSIDE p_enrt_tbl(i).pl_id'||p_enrt_tbl(i).pl_id,111);

1420: --l_cnt := 0;
1421: for j in 1..p_enrt_cnt loop
1422: --
1423: hr_utility.set_location('J INSIDE p_enrt_tbl(j).pl_id'||p_enrt_tbl(j).pl_id,111);
1424: hr_utility.set_location('J INSIDE p_enrt_tbl(i).pl_id'||p_enrt_tbl(i).pl_id,111);
1425: hr_utility.set_location('J INSIDE SSPNDD_FLAG'||p_enrt_tbl(j).SSPNDD_FLAG,111);
1426: hr_utility.set_location('i INSIDE Bnft J '||p_enrt_tbl(j).bnft_amt,111);
1427: hr_utility.set_location('i INSIDE interim J'||p_enrt_tbl(j).interim_flag,111);
1428: --

Line 1425: hr_utility.set_location('J INSIDE SSPNDD_FLAG'||p_enrt_tbl(j).SSPNDD_FLAG,111);

1421: for j in 1..p_enrt_cnt loop
1422: --
1423: hr_utility.set_location('J INSIDE p_enrt_tbl(j).pl_id'||p_enrt_tbl(j).pl_id,111);
1424: hr_utility.set_location('J INSIDE p_enrt_tbl(i).pl_id'||p_enrt_tbl(i).pl_id,111);
1425: hr_utility.set_location('J INSIDE SSPNDD_FLAG'||p_enrt_tbl(j).SSPNDD_FLAG,111);
1426: hr_utility.set_location('i INSIDE Bnft J '||p_enrt_tbl(j).bnft_amt,111);
1427: hr_utility.set_location('i INSIDE interim J'||p_enrt_tbl(j).interim_flag,111);
1428: --
1429: if (p_enrt_tbl(i).enrt_cvg_strt_dt between

Line 1426: hr_utility.set_location('i INSIDE Bnft J '||p_enrt_tbl(j).bnft_amt,111);

1422: --
1423: hr_utility.set_location('J INSIDE p_enrt_tbl(j).pl_id'||p_enrt_tbl(j).pl_id,111);
1424: hr_utility.set_location('J INSIDE p_enrt_tbl(i).pl_id'||p_enrt_tbl(i).pl_id,111);
1425: hr_utility.set_location('J INSIDE SSPNDD_FLAG'||p_enrt_tbl(j).SSPNDD_FLAG,111);
1426: hr_utility.set_location('i INSIDE Bnft J '||p_enrt_tbl(j).bnft_amt,111);
1427: hr_utility.set_location('i INSIDE interim J'||p_enrt_tbl(j).interim_flag,111);
1428: --
1429: if (p_enrt_tbl(i).enrt_cvg_strt_dt between
1430: p_enrt_tbl(j).enrt_cvg_strt_dt and

Line 1427: hr_utility.set_location('i INSIDE interim J'||p_enrt_tbl(j).interim_flag,111);

1423: hr_utility.set_location('J INSIDE p_enrt_tbl(j).pl_id'||p_enrt_tbl(j).pl_id,111);
1424: hr_utility.set_location('J INSIDE p_enrt_tbl(i).pl_id'||p_enrt_tbl(i).pl_id,111);
1425: hr_utility.set_location('J INSIDE SSPNDD_FLAG'||p_enrt_tbl(j).SSPNDD_FLAG,111);
1426: hr_utility.set_location('i INSIDE Bnft J '||p_enrt_tbl(j).bnft_amt,111);
1427: hr_utility.set_location('i INSIDE interim J'||p_enrt_tbl(j).interim_flag,111);
1428: --
1429: if (p_enrt_tbl(i).enrt_cvg_strt_dt between
1430: p_enrt_tbl(j).enrt_cvg_strt_dt and
1431: nvl(p_enrt_tbl(j).enrt_cvg_thru_dt,hr_api.g_eot)

Line 1435: hr_utility.set_location('INSIDE p_enrt_tbl(j).pl_id'||p_enrt_tbl(j).pl_id,111);

1431: nvl(p_enrt_tbl(j).enrt_cvg_thru_dt,hr_api.g_eot)
1432: ) then
1433: --
1434: /*
1435: hr_utility.set_location('INSIDE p_enrt_tbl(j).pl_id'||p_enrt_tbl(j).pl_id,111);
1436: hr_utility.set_location('INSIDE p_enrt_tbl(i).pl_id'||p_enrt_tbl(i).pl_id,111);
1437: hr_utility.set_location('INSIDE SSPNDD_FLAG'||p_enrt_tbl(j).SSPNDD_FLAG,111);
1438: hr_utility.set_location('INSIDE calc_inter'||p_enrt_tbl(j).calc_interm,111);
1439: */

Line 1436: hr_utility.set_location('INSIDE p_enrt_tbl(i).pl_id'||p_enrt_tbl(i).pl_id,111);

1432: ) then
1433: --
1434: /*
1435: hr_utility.set_location('INSIDE p_enrt_tbl(j).pl_id'||p_enrt_tbl(j).pl_id,111);
1436: hr_utility.set_location('INSIDE p_enrt_tbl(i).pl_id'||p_enrt_tbl(i).pl_id,111);
1437: hr_utility.set_location('INSIDE SSPNDD_FLAG'||p_enrt_tbl(j).SSPNDD_FLAG,111);
1438: hr_utility.set_location('INSIDE calc_inter'||p_enrt_tbl(j).calc_interm,111);
1439: */
1440: --

Line 1437: hr_utility.set_location('INSIDE SSPNDD_FLAG'||p_enrt_tbl(j).SSPNDD_FLAG,111);

1433: --
1434: /*
1435: hr_utility.set_location('INSIDE p_enrt_tbl(j).pl_id'||p_enrt_tbl(j).pl_id,111);
1436: hr_utility.set_location('INSIDE p_enrt_tbl(i).pl_id'||p_enrt_tbl(i).pl_id,111);
1437: hr_utility.set_location('INSIDE SSPNDD_FLAG'||p_enrt_tbl(j).SSPNDD_FLAG,111);
1438: hr_utility.set_location('INSIDE calc_inter'||p_enrt_tbl(j).calc_interm,111);
1439: */
1440: --
1441: if (p_enrt_tbl(j).calc_interm = 1) then

Line 1438: hr_utility.set_location('INSIDE calc_inter'||p_enrt_tbl(j).calc_interm,111);

1434: /*
1435: hr_utility.set_location('INSIDE p_enrt_tbl(j).pl_id'||p_enrt_tbl(j).pl_id,111);
1436: hr_utility.set_location('INSIDE p_enrt_tbl(i).pl_id'||p_enrt_tbl(i).pl_id,111);
1437: hr_utility.set_location('INSIDE SSPNDD_FLAG'||p_enrt_tbl(j).SSPNDD_FLAG,111);
1438: hr_utility.set_location('INSIDE calc_inter'||p_enrt_tbl(j).calc_interm,111);
1439: */
1440: --
1441: if (p_enrt_tbl(j).calc_interm = 1) then
1442: if (nvl(p_enrt_tbl(j).SSPNDD_FLAG, 'X') <> 'Y') then

Line 1462: hr_utility.set_location('p_enrt_tbl(j).pl_id'||p_enrt_tbl(j).pl_id,111);

1458: -- end loop;
1459: -- if (l_not_found) then
1460: --
1461: /*
1462: hr_utility.set_location('p_enrt_tbl(j).pl_id'||p_enrt_tbl(j).pl_id,111);
1463: hr_utility.set_location('p_enrt_tbl(i).pl_id'||p_enrt_tbl(i).pl_id,111);
1464: hr_utility.set_location('enrt_tbl(j).bnft_amt'||nvl(p_enrt_tbl(j).bnft_amt,0),111);
1465: hr_utility.set_location('l_tot_amt_no_interim'||l_tot_amt_no_interim,111);
1466: */

Line 1463: hr_utility.set_location('p_enrt_tbl(i).pl_id'||p_enrt_tbl(i).pl_id,111);

1459: -- if (l_not_found) then
1460: --
1461: /*
1462: hr_utility.set_location('p_enrt_tbl(j).pl_id'||p_enrt_tbl(j).pl_id,111);
1463: hr_utility.set_location('p_enrt_tbl(i).pl_id'||p_enrt_tbl(i).pl_id,111);
1464: hr_utility.set_location('enrt_tbl(j).bnft_amt'||nvl(p_enrt_tbl(j).bnft_amt,0),111);
1465: hr_utility.set_location('l_tot_amt_no_interim'||l_tot_amt_no_interim,111);
1466: */
1467: --

Line 1464: hr_utility.set_location('enrt_tbl(j).bnft_amt'||nvl(p_enrt_tbl(j).bnft_amt,0),111);

1460: --
1461: /*
1462: hr_utility.set_location('p_enrt_tbl(j).pl_id'||p_enrt_tbl(j).pl_id,111);
1463: hr_utility.set_location('p_enrt_tbl(i).pl_id'||p_enrt_tbl(i).pl_id,111);
1464: hr_utility.set_location('enrt_tbl(j).bnft_amt'||nvl(p_enrt_tbl(j).bnft_amt,0),111);
1465: hr_utility.set_location('l_tot_amt_no_interim'||l_tot_amt_no_interim,111);
1466: */
1467: --
1468: l_tot_pls := l_tot_pls + 1;

Line 1465: hr_utility.set_location('l_tot_amt_no_interim'||l_tot_amt_no_interim,111);

1461: /*
1462: hr_utility.set_location('p_enrt_tbl(j).pl_id'||p_enrt_tbl(j).pl_id,111);
1463: hr_utility.set_location('p_enrt_tbl(i).pl_id'||p_enrt_tbl(i).pl_id,111);
1464: hr_utility.set_location('enrt_tbl(j).bnft_amt'||nvl(p_enrt_tbl(j).bnft_amt,0),111);
1465: hr_utility.set_location('l_tot_amt_no_interim'||l_tot_amt_no_interim,111);
1466: */
1467: --
1468: l_tot_pls := l_tot_pls + 1;
1469: l_tot_amt_no_interim:=l_tot_amt_no_interim+nvl(p_enrt_tbl(j).bnft_amt,0);

Line 1684: hr_utility.set_location('Entering:'||l_proc,5);

1680: -- Store all comp. object into PL/SQL table g_enrt_tbl, and all the
1681: -- interim records prtt_enrt_rslt_id into l_interim_tbl PL/SQL table.
1682: --
1683: l_step := 5;
1684: hr_utility.set_location('Entering:'||l_proc,5);
1685: --
1686: -- Initialize globle variable.
1687: --
1688: l_interim_tbl.delete;

Line 2107: hr_utility.set_location('Before g_pl_tbl(i).tot_cvg_amt '||g_pl_tbl(i).tot_cvg_amt,1234);

2103: l_enrt_tbl(l_enrt_cnt) := g_enrt_tbl(j);
2104: end if;
2105: end loop;
2106: If (l_enrt_cnt > 0) then
2107: hr_utility.set_location('Before g_pl_tbl(i).tot_cvg_amt '||g_pl_tbl(i).tot_cvg_amt,1234);
2108: get_opts_and_cvg
2109: (p_enrt_tbl => l_enrt_tbl
2110: ,p_enrt_cnt => l_enrt_cnt
2111: ,p_tot_amt => g_pl_tbl(i).tot_cvg_amt

Line 2114: hr_utility.set_location('After g_pl_tbl(i).tot_cvg_amt '||g_pl_tbl(i).tot_cvg_amt,1234);

2110: ,p_enrt_cnt => l_enrt_cnt
2111: ,p_tot_amt => g_pl_tbl(i).tot_cvg_amt
2112: ,p_tot_opts => g_pl_tbl(i).tot_opt_enrld
2113: );
2114: hr_utility.set_location('After g_pl_tbl(i).tot_cvg_amt '||g_pl_tbl(i).tot_cvg_amt,1234);
2115: end if;
2116: --
2117: end loop;
2118: --

Line 2148: hr_utility.set_location('After get_pls_and_cvg 1'||g_ptip_tbl(i).tot_cvg_amt,111);

2144: ,p_tot_pls => g_ptip_tbl(i).tot_pl_enrld
2145: ,p_dpnt_cvd_by_othr_apls_flag => g_ptip_tbl(i).dpnt_cvd_by_othr_apls_flag
2146: ,p_tot_amt_no_interim => g_ptip_tbl(i).tot_cvg_amt_no_interim
2147: );
2148: hr_utility.set_location('After get_pls_and_cvg 1'||g_ptip_tbl(i).tot_cvg_amt,111);
2149: hr_utility.set_location('After tot_cvg_no_interim'||g_ptip_tbl(i).tot_cvg_amt_no_interim,111);
2150:
2151: End if;
2152: end loop;

Line 2149: hr_utility.set_location('After tot_cvg_no_interim'||g_ptip_tbl(i).tot_cvg_amt_no_interim,111);

2145: ,p_dpnt_cvd_by_othr_apls_flag => g_ptip_tbl(i).dpnt_cvd_by_othr_apls_flag
2146: ,p_tot_amt_no_interim => g_ptip_tbl(i).tot_cvg_amt_no_interim
2147: );
2148: hr_utility.set_location('After get_pls_and_cvg 1'||g_ptip_tbl(i).tot_cvg_amt,111);
2149: hr_utility.set_location('After tot_cvg_no_interim'||g_ptip_tbl(i).tot_cvg_amt_no_interim,111);
2150:
2151: End if;
2152: end loop;
2153: --

Line 2210: hr_utility.set_location('AfterPLTYP get_pls_and_cvg 2'||g_pl_typ_tbl(i).tot_cvg_amt,111);

2206: ,p_tot_pls => g_pl_typ_tbl(i).tot_pl_enrld
2207: ,p_dpnt_cvd_by_othr_apls_flag => g_pl_typ_tbl(i).dpnt_cvd_by_othr_apls_flag
2208: ,p_tot_amt_no_interim => g_pl_typ_tbl(i).tot_cvg_amt_no_interim
2209: );
2210: hr_utility.set_location('AfterPLTYP get_pls_and_cvg 2'||g_pl_typ_tbl(i).tot_cvg_amt,111);
2211: hr_utility.set_location('After tot_cvg_no_interim'||g_pl_typ_tbl(i).tot_cvg_amt_no_interim,111);
2212: End if;
2213: end loop;
2214: --

Line 2211: hr_utility.set_location('After tot_cvg_no_interim'||g_pl_typ_tbl(i).tot_cvg_amt_no_interim,111);

2207: ,p_dpnt_cvd_by_othr_apls_flag => g_pl_typ_tbl(i).dpnt_cvd_by_othr_apls_flag
2208: ,p_tot_amt_no_interim => g_pl_typ_tbl(i).tot_cvg_amt_no_interim
2209: );
2210: hr_utility.set_location('AfterPLTYP get_pls_and_cvg 2'||g_pl_typ_tbl(i).tot_cvg_amt,111);
2211: hr_utility.set_location('After tot_cvg_no_interim'||g_pl_typ_tbl(i).tot_cvg_amt_no_interim,111);
2212: End if;
2213: end loop;
2214: --
2215: l_step := 100;

Line 2217: hr_utility.set_location('Leaving:'||l_proc,500);

2213: end loop;
2214: --
2215: l_step := 100;
2216: --
2217: hr_utility.set_location('Leaving:'||l_proc,500);
2218: Exception
2219: when others then
2220: hr_utility.set_location('Fail in '|| l_proc|| ' at step ' ||
2221: to_char(l_step), 999);

Line 2220: hr_utility.set_location('Fail in '|| l_proc|| ' at step ' ||

2216: --
2217: hr_utility.set_location('Leaving:'||l_proc,500);
2218: Exception
2219: when others then
2220: hr_utility.set_location('Fail in '|| l_proc|| ' at step ' ||
2221: to_char(l_step), 999);
2222: if g_c_pgm%isopen then
2223: close g_c_pgm;
2224: end if;

Line 2376: hr_utility.set_location('Entering - '||l_proc, 5);

2372:
2373: --
2374: Begin
2375: --
2376: hr_utility.set_location('Entering - '||l_proc, 5);
2377: --
2378: --
2379: if p_oipl_post_edit_rl is not null or
2380: p_pl_post_edit_rl is not null or

Line 2402: hr_utility.set_location('l_state.assignment_id '|| l_state.assignment_id , 5);

2398: end if;
2399: --
2400: end if;
2401:
2402: hr_utility.set_location('l_state.assignment_id '|| l_state.assignment_id , 5);
2403:
2404: if p_oipl_post_edit_rl is not null then
2405: --
2406: l_rule_returns :=

Line 2493: hr_utility.set_location('Leaving - '||l_proc, 10);

2489: p_proc => l_proc,
2490: p_rule_id => p_ptip_post_edit_rl);
2491: end if;
2492: --
2493: hr_utility.set_location('Leaving - '||l_proc, 10);
2494: --
2495: End Chk_post_elcn_rl;
2496: --
2497: -- ----------------------------------------------------------------------------

Line 2543: hr_utility.set_location('Entering - '||l_proc, 5);

2539: ;
2540: l_dump number(15);
2541: l_proc varchar2(80) := g_package || '.chk_mndtry_comp_obj';
2542: Begin
2543: hr_utility.set_location('Entering - '||l_proc, 5);
2544:
2545: -- Check that mandatory options are enrolled in.
2546: -- These are options that you MUST be enrolled in, IF you are
2547: -- enrolled in the plan at all.

Line 2556: hr_utility.set_location('Leaving - '||l_proc, 10);

2552: fnd_message.set_name('BEN', 'BEN_91962_MNDTRY_OBJ_NOT_ENRLD');
2553: fnd_message.raise_error;
2554: End if;
2555: close c1;
2556: hr_utility.set_location('Leaving - '||l_proc, 10);
2557: End;
2558: --
2559: --
2560: -- ----------------------------------------------------------------------------

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

2614: e_no_pt exception;
2615: e_no_pen exception;
2616: l_proc varchar2(80) := g_package||'.manage_per_type_usages';
2617: begin
2618: hr_utility.set_location('Entering '||l_proc,10);
2619: -- Get participant person type id
2620: for r_pt in c_pt loop
2621: l_person_type_id := r_pt.person_type_id;
2622: end loop;

Line 2647: hr_utility.set_location('counts prn : '||l_pen.count || ' PTU :' || l_ptu.count,90);

2643: for r_ptu in c_ptu loop
2644: l_ptu(l_ptu.count+1) := r_ptu;
2645: end loop;
2646:
2647: hr_utility.set_location('counts prn : '||l_pen.count || ' PTU :' || l_ptu.count,90);
2648: if l_pen.count = 0 then
2649: -- if there is no enrollment result,
2650: -- 2899702 check for per type usage if both 0
2651: -- no need to process person type usage records

Line 2666: hr_utility.set_location('Leaving betwen '||l_proc,90);

2662: ,p_effective_start_date => l_esd
2663: ,p_effective_end_date => l_eed);
2664: end loop; -- zap person type usage loop
2665: end if ;
2666: hr_utility.set_location('Leaving betwen '||l_proc,90);
2667:
2668: return;
2669: end if;
2670:

Line 2730: hr_utility.set_location('Leaving '||l_proc,90);

2726: ,p_effective_end_date => l_eed);
2727: end if;
2728: end if;
2729: end loop; -- create person type usage loop
2730: hr_utility.set_location('Leaving '||l_proc,90);
2731: exception
2732: when e_no_pt then
2733: hr_utility.set_location('Leaving '||l_proc||' No person type found.',100);
2734: raise;

Line 2733: hr_utility.set_location('Leaving '||l_proc||' No person type found.',100);

2729: end loop; -- create person type usage loop
2730: hr_utility.set_location('Leaving '||l_proc,90);
2731: exception
2732: when e_no_pt then
2733: hr_utility.set_location('Leaving '||l_proc||' No person type found.',100);
2734: raise;
2735: when e_no_pen then
2736: hr_utility.set_location('Leaving '||l_proc||' No enrollments found.',110);
2737: raise;

Line 2736: hr_utility.set_location('Leaving '||l_proc||' No enrollments found.',110);

2732: when e_no_pt then
2733: hr_utility.set_location('Leaving '||l_proc||' No person type found.',100);
2734: raise;
2735: when e_no_pen then
2736: hr_utility.set_location('Leaving '||l_proc||' No enrollments found.',110);
2737: raise;
2738: when others then
2739: hr_utility.set_location('Leaving '||l_proc||' When others fired.',120);
2740: raise;

Line 2739: hr_utility.set_location('Leaving '||l_proc||' When others fired.',120);

2735: when e_no_pen then
2736: hr_utility.set_location('Leaving '||l_proc||' No enrollments found.',110);
2737: raise;
2738: when others then
2739: hr_utility.set_location('Leaving '||l_proc||' When others fired.',120);
2740: raise;
2741: End;
2742: --
2743: -- ----------------------------------------------------------------------------

Line 2803: hr_utility.set_location('Entering' || l_proc,5);

2799: l_step integer;
2800: l_datetrack_mode varchar2(30);
2801: --
2802: Begin
2803: hr_utility.set_location('Entering' || l_proc,5);
2804: --
2805: -- C1 is cursor is pull out all suspended plan with in program that user
2806: -- specified and cursor c2 is cursor to pull out all options are not suspended
2807: -- within the plan.

Line 2838: hr_utility.set_location('Leaving' || l_proc,10);

2834: ,p_effective_date => p_effective_date
2835: );
2836: End loop;
2837: End loop;
2838: hr_utility.set_location('Leaving' || l_proc,10);
2839: Exception
2840: when others then
2841: hr_utility.set_location('Fail at '||l_proc||' step - '||
2842: to_char(l_step),999);

Line 2841: hr_utility.set_location('Fail at '||l_proc||' step - '||

2837: End loop;
2838: hr_utility.set_location('Leaving' || l_proc,10);
2839: Exception
2840: when others then
2841: hr_utility.set_location('Fail at '||l_proc||' step - '||
2842: to_char(l_step),999);
2843: raise;
2844: End;
2845: --

Line 2967: hr_utility.set_location(l_proc,5);

2963: l_erl varchar2(30);
2964:
2965: --
2966: begin
2967: hr_utility.set_location(l_proc,5);
2968: --
2969: -- suspended all suspended saving plan's options.
2970: --
2971: l_step := 5;

Line 2994: hr_utility.set_location('l_assignment_id is :-'||l_assignment_id ,1234);

2990: fnd_message.raise_error;
2991: end if;
2992: close c_paf;
2993: --
2994: hr_utility.set_location('l_assignment_id is :-'||l_assignment_id ,1234);
2995: -- Cache all comp objects belong to a specified person_id for a
2996: -- specified program or all program dependent on p_chk_all_pgm_flg,
2997: -- If Yes, then all program will be cached, otherwise, only the pgm_id
2998: -- is specified.

Line 3019: hr_utility.set_location('Get the plan name and option name.:-' ,1234);

3015: and g_ptip_tbl(i).dpnt_cvd_by_othr_apls_flag = 'N') then
3016: --
3017: --bug #2162121
3018: --
3019: hr_utility.set_location('Get the plan name and option name.:-' ,1234);
3020: l_ptip_tbl_ct := nvl(g_ptip_tbl(i).tot_pl_enrld, 0); -- nvl(g_ptip_tbl.count, 0); Bug 2390734
3021: -- -- This change is made so that the error message for 92968 displays names of only
3022: -- those compensation objects, that the person is being enrolled in.
3023: if l_ptip_tbl_ct > 0 then

Line 3040: hr_utility.set_location (l_plan_name|| 'l_plan_name :1 : ',1235);

3036: fetch c_pl_name into l_plan_name;
3037: close c_pl_name;
3038:
3039: -- l_plan_opt_names := l_plan_opt_names ||l_plan_name;
3040: hr_utility.set_location (l_plan_name|| 'l_plan_name :1 : ',1235);
3041:
3042: if g_enrt_tbl(i2).oipl_id is not null then
3043: --
3044: l_option_name := null;

Line 3050: hr_utility.set_location (l_option_name|| 'l_option_name',1235);

3046: fetch c_opt_name into l_option_name;
3047: close c_opt_name;
3048:
3049: l_plan_name := l_plan_name ||l_option_name;
3050: hr_utility.set_location (l_option_name|| 'l_option_name',1235);
3051: --
3052: end if ;
3053:
3054: if l_plan_opt_names is null then

Line 3062: hr_utility.set_location (l_plan_opt_names|| 'l_plan_opt_names',1235);

3058: end if;
3059:
3060: end if; --g_ptip_tbl(i).ptip_id = g_enrt_tbl(i2).ptip_id
3061:
3062: hr_utility.set_location (l_plan_opt_names|| 'l_plan_opt_names',1235);
3063:
3064: end loop;
3065: end if; --l_ptip_tbl_ct > 0
3066:

Line 3131: hr_utility.set_location('g_tot_ee_lf_ins_amt '||g_tot_ee_lf_ins_amt,111);

3127: (g_ptip_tbl(i).use_to_sum_ee_lf_ins_flag = 'Y') then
3128: g_tot_ee_lf_ins_amt := g_tot_ee_lf_ins_amt + g_ptip_tbl(i).tot_cvg_amt;
3129: g_tot_ee_lf_ins_amt_no := g_tot_ee_lf_ins_amt_no + g_ptip_tbl(i).tot_cvg_amt_no_interim;
3130: end if;
3131: hr_utility.set_location('g_tot_ee_lf_ins_amt '||g_tot_ee_lf_ins_amt,111);
3132: hr_utility.set_location('g_tot_ee_lf_ins_amt_no '||g_tot_ee_lf_ins_amt_no,111);
3133: end loop;
3134: --
3135: -- Check for spouse and dependent coverage limitations.

Line 3132: hr_utility.set_location('g_tot_ee_lf_ins_amt_no '||g_tot_ee_lf_ins_amt_no,111);

3128: g_tot_ee_lf_ins_amt := g_tot_ee_lf_ins_amt + g_ptip_tbl(i).tot_cvg_amt;
3129: g_tot_ee_lf_ins_amt_no := g_tot_ee_lf_ins_amt_no + g_ptip_tbl(i).tot_cvg_amt_no_interim;
3130: end if;
3131: hr_utility.set_location('g_tot_ee_lf_ins_amt '||g_tot_ee_lf_ins_amt,111);
3132: hr_utility.set_location('g_tot_ee_lf_ins_amt_no '||g_tot_ee_lf_ins_amt_no,111);
3133: end loop;
3134: --
3135: -- Check for spouse and dependent coverage limitations.
3136: --

Line 3155: hr_utility.set_location('g_tot_sps_lf_ins_amt'||g_tot_sps_lf_ins_amt,111);

3151: g_mx_dpnt_pct_prtt_lf := g_pgm_rec.MX_DPNT_PCT_PRTT_LF_AMT;
3152: end if;
3153: end if;
3154: --
3155: hr_utility.set_location('g_tot_sps_lf_ins_amt'||g_tot_sps_lf_ins_amt,111);
3156: hr_utility.set_location('g_tot_dpnt_lf_ins_amt'||g_tot_dpnt_lf_ins_amt,111);
3157: hr_utility.set_location('g_tot_sps_lf_ins_amt_no'||g_tot_sps_lf_ins_amt_no,111);
3158: hr_utility.set_location('g_tot_dpnt_lf_ins_amt_no'||g_tot_dpnt_lf_ins_amt_no,111);
3159: --

Line 3156: hr_utility.set_location('g_tot_dpnt_lf_ins_amt'||g_tot_dpnt_lf_ins_amt,111);

3152: end if;
3153: end if;
3154: --
3155: hr_utility.set_location('g_tot_sps_lf_ins_amt'||g_tot_sps_lf_ins_amt,111);
3156: hr_utility.set_location('g_tot_dpnt_lf_ins_amt'||g_tot_dpnt_lf_ins_amt,111);
3157: hr_utility.set_location('g_tot_sps_lf_ins_amt_no'||g_tot_sps_lf_ins_amt_no,111);
3158: hr_utility.set_location('g_tot_dpnt_lf_ins_amt_no'||g_tot_dpnt_lf_ins_amt_no,111);
3159: --
3160: l_step := 40;

Line 3157: hr_utility.set_location('g_tot_sps_lf_ins_amt_no'||g_tot_sps_lf_ins_amt_no,111);

3153: end if;
3154: --
3155: hr_utility.set_location('g_tot_sps_lf_ins_amt'||g_tot_sps_lf_ins_amt,111);
3156: hr_utility.set_location('g_tot_dpnt_lf_ins_amt'||g_tot_dpnt_lf_ins_amt,111);
3157: hr_utility.set_location('g_tot_sps_lf_ins_amt_no'||g_tot_sps_lf_ins_amt_no,111);
3158: hr_utility.set_location('g_tot_dpnt_lf_ins_amt_no'||g_tot_dpnt_lf_ins_amt_no,111);
3159: --
3160: l_step := 40;
3161: if (((g_mx_dpnt_pct_prtt_lf * g_tot_ee_lf_ins_amt)/100)

Line 3158: hr_utility.set_location('g_tot_dpnt_lf_ins_amt_no'||g_tot_dpnt_lf_ins_amt_no,111);

3154: --
3155: hr_utility.set_location('g_tot_sps_lf_ins_amt'||g_tot_sps_lf_ins_amt,111);
3156: hr_utility.set_location('g_tot_dpnt_lf_ins_amt'||g_tot_dpnt_lf_ins_amt,111);
3157: hr_utility.set_location('g_tot_sps_lf_ins_amt_no'||g_tot_sps_lf_ins_amt_no,111);
3158: hr_utility.set_location('g_tot_dpnt_lf_ins_amt_no'||g_tot_dpnt_lf_ins_amt_no,111);
3159: --
3160: l_step := 40;
3161: if (((g_mx_dpnt_pct_prtt_lf * g_tot_ee_lf_ins_amt)/100)
3162: < g_tot_dpnt_lf_ins_amt) then

Line 3207: hr_utility.set_location('pl_typ_id='||to_char(g_pl_typ_tbl(i).pl_typ_id),99);

3203: for i in 1..g_pl_typ_cnt loop
3204: --
3205: -- Plan type enrollment limitation (Max and Min).
3206: --
3207: hr_utility.set_location('pl_typ_id='||to_char(g_pl_typ_tbl(i).pl_typ_id),99);
3208: hr_utility.set_location('val='||to_char(g_pl_typ_tbl(i).tot_pl_enrld)||
3209: ' min='||to_char(g_pl_typ_tbl(i).mn_enrl_rqd_num)||
3210: ' max='||to_char(g_pl_typ_tbl(i).mx_enrl_alwd_num)
3211: , 101);

Line 3208: hr_utility.set_location('val='||to_char(g_pl_typ_tbl(i).tot_pl_enrld)||

3204: --
3205: -- Plan type enrollment limitation (Max and Min).
3206: --
3207: hr_utility.set_location('pl_typ_id='||to_char(g_pl_typ_tbl(i).pl_typ_id),99);
3208: hr_utility.set_location('val='||to_char(g_pl_typ_tbl(i).tot_pl_enrld)||
3209: ' min='||to_char(g_pl_typ_tbl(i).mn_enrl_rqd_num)||
3210: ' max='||to_char(g_pl_typ_tbl(i).mx_enrl_alwd_num)
3211: , 101);
3212: if (g_pl_typ_tbl(i).tot_pl_enrld > g_pl_typ_tbl(i).mx_enrl_alwd_num

Line 3293: hr_utility.set_location('l_chk_pln_cvg_lmts='|| 'TRUE' ,99);

3289: --
3290: IF (g_enrt_tbl (j).pl_id = g_pl_tbl (i).pl_id
3291: AND g_enrt_tbl (j).prtt_enrt_rslt_id IS NOT NULL
3292: ) THEN
3293: hr_utility.set_location('l_chk_pln_cvg_lmts='|| 'TRUE' ,99);
3294: l_chk_pln_cvg_lmts := TRUE;
3295: EXIT;
3296: END IF;
3297: END LOOP;

Line 3299: hr_utility.set_location('g_pl_tbl(i).tot_cvg_amt='||g_pl_tbl(i).tot_cvg_amt,99);

3295: EXIT;
3296: END IF;
3297: END LOOP;
3298: --
3299: hr_utility.set_location('g_pl_tbl(i).tot_cvg_amt='||g_pl_tbl(i).tot_cvg_amt,99);
3300: hr_utility.set_location('g_pl_tbl(i).mx_cvg_alwd_amt='||g_pl_tbl(i).mx_cvg_alwd_amt,99);
3301: hr_utility.set_location('g_pl_tbl(i).mx_cvg_wcfn_amt='||g_pl_tbl(i).mx_cvg_wcfn_amt,99);
3302: --
3303: IF (l_chk_pln_cvg_lmts) THEN

Line 3300: hr_utility.set_location('g_pl_tbl(i).mx_cvg_alwd_amt='||g_pl_tbl(i).mx_cvg_alwd_amt,99);

3296: END IF;
3297: END LOOP;
3298: --
3299: hr_utility.set_location('g_pl_tbl(i).tot_cvg_amt='||g_pl_tbl(i).tot_cvg_amt,99);
3300: hr_utility.set_location('g_pl_tbl(i).mx_cvg_alwd_amt='||g_pl_tbl(i).mx_cvg_alwd_amt,99);
3301: hr_utility.set_location('g_pl_tbl(i).mx_cvg_wcfn_amt='||g_pl_tbl(i).mx_cvg_wcfn_amt,99);
3302: --
3303: IF (l_chk_pln_cvg_lmts) THEN
3304: -- Bug: 3949327 changes end;

Line 3301: hr_utility.set_location('g_pl_tbl(i).mx_cvg_wcfn_amt='||g_pl_tbl(i).mx_cvg_wcfn_amt,99);

3297: END LOOP;
3298: --
3299: hr_utility.set_location('g_pl_tbl(i).tot_cvg_amt='||g_pl_tbl(i).tot_cvg_amt,99);
3300: hr_utility.set_location('g_pl_tbl(i).mx_cvg_alwd_amt='||g_pl_tbl(i).mx_cvg_alwd_amt,99);
3301: hr_utility.set_location('g_pl_tbl(i).mx_cvg_wcfn_amt='||g_pl_tbl(i).mx_cvg_wcfn_amt,99);
3302: --
3303: IF (l_chk_pln_cvg_lmts) THEN
3304: -- Bug: 3949327 changes end;
3305: -- Check min coverage amount.

Line 3606: hr_utility.set_location (l_proc, 10);

3602: ,p_pgm_id => p_pgm_id
3603: ,p_business_group_id => p_business_group_id
3604: ,p_effective_date => p_effective_date
3605: );
3606: hr_utility.set_location (l_proc, 10);
3607: Exception
3608: when others then
3609: hr_utility.set_location('Fail at '||l_proc||' step - '||
3610: to_char(l_step),999);

Line 3609: hr_utility.set_location('Fail at '||l_proc||' step - '||

3605: );
3606: hr_utility.set_location (l_proc, 10);
3607: Exception
3608: when others then
3609: hr_utility.set_location('Fail at '||l_proc||' step - '||
3610: to_char(l_step),999);
3611: raise;
3612: end;
3613: --

Line 3632: hr_utility.set_location('Entering:'||l_proc, 5);

3628: l_message_name varchar2(500) := 'BEN_94592_RT_STRT_GT_END_DT';
3629: --
3630: Begin
3631: --
3632: hr_utility.set_location('Entering:'||l_proc, 5);
3633: --
3634: if p_enrt_cvg_strt_dt > p_enrt_cvg_thru_dt then
3635: benutils.write(p_text=>fnd_message.get);
3636: ben_warnings.load_warning

Line 3645: hr_utility.set_location('Leaving:'||l_proc,10);

3641: ,p_person_id => p_person_id
3642: );
3643: end if;
3644: --
3645: hr_utility.set_location('Leaving:'||l_proc,10);
3646: --
3647: end chk_cvg_strt_end_dt;
3648: --
3649: ----Bug#5088571*/

Line 3695: hr_utility.set_location('Entering:'||l_proc, 5);

3691: l_integrity_error Exception;
3692: l_table_name all_tables.table_name%TYPE;
3693: --
3694: Begin
3695: hr_utility.set_location('Entering:'||l_proc, 5);
3696: --
3697: -- Ensure that the p_datetrack_mode argument is not null
3698: --
3699: hr_api.mandatory_arg_error

Line 3773: hr_utility.set_location(' Leaving:'||l_proc, 10);

3769: Raise l_integrity_error;
3770: End If;
3771: End If;
3772: --
3773: hr_utility.set_location(' Leaving:'||l_proc, 10);
3774: Exception
3775: When l_integrity_error Then
3776: --
3777: -- A referential integrity check was violated therefore

Line 3840: hr_utility.set_location('Entering:'||l_proc, 5);

3836: l_rows_exist Exception;
3837: l_table_name all_tables.table_name%TYPE;
3838:
3839: Begin
3840: hr_utility.set_location('Entering:'||l_proc, 5);
3841: --
3842: -- Ensure that the p_datetrack_mode argument is not null
3843: --
3844: hr_api.mandatory_arg_error

Line 3925: hr_utility.set_location(' Leaving:'||l_proc, 10);

3921: Raise l_rows_exist;
3922: End If;
3923: End If;
3924: --
3925: hr_utility.set_location(' Leaving:'||l_proc, 10);
3926: Exception
3927: When l_rows_exist Then
3928: --
3929: -- A referential integrity check was violated therefore

Line 3958: hr_utility.set_location('Entering:'||l_proc, 5);

3954: --
3955: l_proc varchar2(72) := g_package||'insert_validate';
3956: --
3957: Begin
3958: hr_utility.set_location('Entering:'||l_proc, 5);
3959: --
3960: -- Call context sensitive validate bgp cache routine
3961: --
3962: ben_batch_dt_api.batch_validate_bgp_id

Line 4076: hr_utility.set_location(' Leaving:'||l_proc, 10);

4072: (p_enrt_cvg_strt_dt => p_rec.enrt_cvg_strt_dt,
4073: p_enrt_cvg_thru_dt => p_rec.enrt_cvg_thru_dt,
4074: p_person_id => p_rec.person_id);*/
4075: --
4076: hr_utility.set_location(' Leaving:'||l_proc, 10);
4077: End insert_validate;
4078: --
4079: -- ----------------------------------------------------------------------------
4080: -- |---------------------------< update_validate >----------------------------|

Line 4092: hr_utility.set_location('Entering:'||l_proc, 5);

4088: --
4089: l_proc varchar2(72) := g_package||'update_validate';
4090: --
4091: Begin
4092: hr_utility.set_location('Entering:'||l_proc, 5);
4093: --
4094: -- Call context sensitive validate bgp cache routine
4095: --
4096: ben_batch_dt_api.batch_validate_bgp_id

Line 4222: hr_utility.set_location(' Leaving:'||l_proc, 10);

4218: (p_enrt_cvg_strt_dt => p_rec.enrt_cvg_strt_dt,
4219: p_enrt_cvg_thru_dt => p_rec.enrt_cvg_thru_dt,
4220: p_person_id => p_rec.person_id);*/
4221: --
4222: hr_utility.set_location(' Leaving:'||l_proc, 10);
4223: End update_validate;
4224: --
4225: -- ----------------------------------------------------------------------------
4226: -- |---------------------------< delete_validate >----------------------------|

Line 4238: hr_utility.set_location('Entering:'||l_proc, 5);

4234: --
4235: l_proc varchar2(72) := g_package||'delete_validate';
4236: --
4237: Begin
4238: hr_utility.set_location('Entering:'||l_proc, 5);
4239: --
4240: -- Call all supporting business operations
4241: --
4242: dt_delete_validate

Line 4249: hr_utility.set_location(' Leaving:'||l_proc, 10);

4245: p_validation_end_date => p_validation_end_date,
4246: p_effective_date => p_effective_date, -- Added for bug 3646239
4247: p_prtt_enrt_rslt_id => p_rec.prtt_enrt_rslt_id);
4248: --
4249: hr_utility.set_location(' Leaving:'||l_proc, 10);
4250: End delete_validate;
4251: --
4252: --
4253: -- ---------------------------------------------------------------------------

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

4272: l_proc varchar2(72) := g_package||'return_legislation_code';
4273: --
4274: begin
4275: --
4276: hr_utility.set_location('Entering:'|| l_proc, 10);
4277: --
4278: -- Ensure that all the mandatory parameter are not null
4279: --
4280: hr_api.mandatory_arg_error(p_api_name => l_proc,

Line 4301: hr_utility.set_location(' Leaving:'|| l_proc, 20);

4297: end if;
4298: --
4299: close csr_leg_code;
4300: --
4301: hr_utility.set_location(' Leaving:'|| l_proc, 20);
4302: --
4303: return l_legislation_code;
4304: --
4305: end return_legislation_code;