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

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

40: l_api_updating boolean;
41: --
42: Begin
43: --
44: hr_utility.set_location('Entering:'||l_proc, 5);
45: --
46: l_api_updating := ben_yrp_shd.api_updating
47: (p_yr_perd_id => p_yr_perd_id,
48: p_object_version_number => p_object_version_number);

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

68: end if;
69: --
70: end if;
71: --
72: hr_utility.set_location('Leaving:'||l_proc, 10);
73: --
74: End chk_yr_perd_id;
75:
76: --

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

109: l_api_updating boolean;
110: --
111: Begin
112: --
113: hr_utility.set_location('Entering:'||l_proc, 5);
114: --
115: l_api_updating := ben_yrp_shd.api_updating
116: (p_yr_perd_id => p_yr_perd_id,
117: p_object_version_number => p_object_version_number);

Line 134: hr_utility.set_message(801, 'BEN_INVALID_BEN_PERD_TYP_CD');

130: p_effective_date => p_effective_date) then
131: --
132: -- raise error as does not exist as lookup
133: --
134: hr_utility.set_message(801, 'BEN_INVALID_BEN_PERD_TYP_CD');
135: hr_utility.set_message_token('BEN_PERD_TYP_CD' , p_perd_typ_cd);
136: hr_utility.raise_error;
137: --
138: end if;

Line 135: hr_utility.set_message_token('BEN_PERD_TYP_CD' , p_perd_typ_cd);

131: --
132: -- raise error as does not exist as lookup
133: --
134: hr_utility.set_message(801, 'BEN_INVALID_BEN_PERD_TYP_CD');
135: hr_utility.set_message_token('BEN_PERD_TYP_CD' , p_perd_typ_cd);
136: hr_utility.raise_error;
137: --
138: end if;
139: --

Line 136: hr_utility.raise_error;

132: -- raise error as does not exist as lookup
133: --
134: hr_utility.set_message(801, 'BEN_INVALID_BEN_PERD_TYP_CD');
135: hr_utility.set_message_token('BEN_PERD_TYP_CD' , p_perd_typ_cd);
136: hr_utility.raise_error;
137: --
138: end if;
139: --
140: end if;

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

138: end if;
139: --
140: end if;
141: --
142: hr_utility.set_location('Leaving:'||l_proc,10);
143: --
144: end chk_perd_typ_cd;
145:
146: --

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

179: l_api_updating boolean;
180: --
181: Begin
182: --
183: hr_utility.set_location('Entering:'||l_proc, 5);
184: --
185: l_api_updating := ben_yrp_shd.api_updating
186: (p_yr_perd_id => p_yr_perd_id,
187: p_object_version_number => p_object_version_number);

Line 204: hr_utility.set_message(801, 'BEN_INVALID_PERD_TM_UOM_CD');

200: p_effective_date => p_effective_date) then
201: --
202: -- raise error as does not exist as lookup
203: --
204: hr_utility.set_message(801, 'BEN_INVALID_PERD_TM_UOM_CD');
205: hr_utility.set_message_token('PERD_TM_UOM_CD' , p_perd_tm_uom_cd);
206: hr_utility.raise_error;
207: --
208: end if;

Line 205: hr_utility.set_message_token('PERD_TM_UOM_CD' , p_perd_tm_uom_cd);

201: --
202: -- raise error as does not exist as lookup
203: --
204: hr_utility.set_message(801, 'BEN_INVALID_PERD_TM_UOM_CD');
205: hr_utility.set_message_token('PERD_TM_UOM_CD' , p_perd_tm_uom_cd);
206: hr_utility.raise_error;
207: --
208: end if;
209: --

Line 206: hr_utility.raise_error;

202: -- raise error as does not exist as lookup
203: --
204: hr_utility.set_message(801, 'BEN_INVALID_PERD_TM_UOM_CD');
205: hr_utility.set_message_token('PERD_TM_UOM_CD' , p_perd_tm_uom_cd);
206: hr_utility.raise_error;
207: --
208: end if;
209: --
210: end if;

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

208: end if;
209: --
210: end if;
211: --
212: hr_utility.set_location('Leaving:'||l_proc,10);
213: --
214: end chk_perd_tm_uom_cd;
215: --
216: -- ----------------------------------------------------------------------------

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

254: and end_date = p_end_date
255: and business_group_id = p_business_group_id;
256: --
257: Begin
258: hr_utility.set_location('Entering:'||l_proc, 5);
259: --
260: open c1;
261: fetch c1 into l_dummy;
262: if c1%found then

Line 268: hr_utility.set_location('Leaving:'||l_proc, 15);

264: fnd_message.set_name('BEN','BEN_92130_START_END_DT_UNIQUE');
265: fnd_message.raise_error;
266: end if;
267: --
268: hr_utility.set_location('Leaving:'||l_proc, 15);
269: End chk_start_and_end_dt_unique;
270: --
271: -- ----------------------------------------------------------------------------
272: --

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

302: l_proc varchar2(72) := g_package||'chk_strt_end_dt_perd_typ';
303: --
304: Begin
305: --
306: hr_utility.set_location('Entering:'||l_proc, 5);
307:
308: if (P_start_date is null) or (p_end_date is null) then
309: --
310: -- raise error Start/End Date is null

Line 312: hr_utility.set_message(805,'BEN_93610_STRT_END_NULL');

308: if (P_start_date is null) or (p_end_date is null) then
309: --
310: -- raise error Start/End Date is null
311: --
312: hr_utility.set_message(805,'BEN_93610_STRT_END_NULL');
313: hr_utility.raise_error;
314: elsif (p_start_date > p_end_date) then
315: --
316: -- raise error Start Date must precede End date

Line 313: hr_utility.raise_error;

309: --
310: -- raise error Start/End Date is null
311: --
312: hr_utility.set_message(805,'BEN_93610_STRT_END_NULL');
313: hr_utility.raise_error;
314: elsif (p_start_date > p_end_date) then
315: --
316: -- raise error Start Date must precede End date
317: --

Line 318: hr_utility.set_message(805,'BEN_93611_STRT_NOT_PRCD_END');

314: elsif (p_start_date > p_end_date) then
315: --
316: -- raise error Start Date must precede End date
317: --
318: hr_utility.set_message(805,'BEN_93611_STRT_NOT_PRCD_END');
319: hr_utility.set_message_token('START_DATE',to_char(p_start_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
320: hr_utility.set_message_token('END_DATE',to_char(p_end_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
321: hr_utility.raise_error;
322:

Line 319: hr_utility.set_message_token('START_DATE',to_char(p_start_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));

315: --
316: -- raise error Start Date must precede End date
317: --
318: hr_utility.set_message(805,'BEN_93611_STRT_NOT_PRCD_END');
319: hr_utility.set_message_token('START_DATE',to_char(p_start_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
320: hr_utility.set_message_token('END_DATE',to_char(p_end_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
321: hr_utility.raise_error;
322:
323: elsif(p_end_date > add_months(p_start_date,12)-1 ) then

Line 320: hr_utility.set_message_token('END_DATE',to_char(p_end_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));

316: -- raise error Start Date must precede End date
317: --
318: hr_utility.set_message(805,'BEN_93611_STRT_NOT_PRCD_END');
319: hr_utility.set_message_token('START_DATE',to_char(p_start_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
320: hr_utility.set_message_token('END_DATE',to_char(p_end_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
321: hr_utility.raise_error;
322:
323: elsif(p_end_date > add_months(p_start_date,12)-1 ) then
324: --

Line 321: hr_utility.raise_error;

317: --
318: hr_utility.set_message(805,'BEN_93611_STRT_NOT_PRCD_END');
319: hr_utility.set_message_token('START_DATE',to_char(p_start_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
320: hr_utility.set_message_token('END_DATE',to_char(p_end_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
321: hr_utility.raise_error;
322:
323: elsif(p_end_date > add_months(p_start_date,12)-1 ) then
324: --
325: -- Raise error Date range between end data nad start date is

Line 328: hr_utility.set_message(805,'BEN_93612_DT_RANG_GT_YR');

324: --
325: -- Raise error Date range between end data nad start date is
326: -- greater than 1 year.
327: --
328: hr_utility.set_message(805,'BEN_93612_DT_RANG_GT_YR');
329: hr_utility.set_message_token('START_DATE',to_char(p_start_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
330: hr_utility.set_message_token('END_DATE',to_char(p_end_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
331: hr_utility.raise_error;
332: elsif to_char(p_start_date, 'DDMM') = '0101' and

Line 329: hr_utility.set_message_token('START_DATE',to_char(p_start_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));

325: -- Raise error Date range between end data nad start date is
326: -- greater than 1 year.
327: --
328: hr_utility.set_message(805,'BEN_93612_DT_RANG_GT_YR');
329: hr_utility.set_message_token('START_DATE',to_char(p_start_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
330: hr_utility.set_message_token('END_DATE',to_char(p_end_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
331: hr_utility.raise_error;
332: elsif to_char(p_start_date, 'DDMM') = '0101' and
333: to_char(p_end_date, 'DDMM') = '3112' and

Line 330: hr_utility.set_message_token('END_DATE',to_char(p_end_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));

326: -- greater than 1 year.
327: --
328: hr_utility.set_message(805,'BEN_93612_DT_RANG_GT_YR');
329: hr_utility.set_message_token('START_DATE',to_char(p_start_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
330: hr_utility.set_message_token('END_DATE',to_char(p_end_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
331: hr_utility.raise_error;
332: elsif to_char(p_start_date, 'DDMM') = '0101' and
333: to_char(p_end_date, 'DDMM') = '3112' and
334: p_perd_typ_cd <> 'CLNDR' then

Line 331: hr_utility.raise_error;

327: --
328: hr_utility.set_message(805,'BEN_93612_DT_RANG_GT_YR');
329: hr_utility.set_message_token('START_DATE',to_char(p_start_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
330: hr_utility.set_message_token('END_DATE',to_char(p_end_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
331: hr_utility.raise_error;
332: elsif to_char(p_start_date, 'DDMM') = '0101' and
333: to_char(p_end_date, 'DDMM') = '3112' and
334: p_perd_typ_cd <> 'CLNDR' then
335: --

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

348: fnd_message.raise_error;
349: --
350: end if;
351: --
352: hr_utility.set_location('Leaving:'||l_proc, 10);
353: --
354: End chk_strt_end_dt_perd_typ;
355:
356: -- ----------------------------------------------------------------------------

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

384: l_proc varchar2(72) := g_package||'chk_Lmt_strt_end_perd_typ_uom';
385: --
386: Begin
387: --
388: hr_utility.set_location('Entering:'|| l_proc, 5);
389:
390: if ((P_lmtn_yr_strt_dt is not null) and (p_lmtn_yr_end_dt is null) or
391: (P_lmtn_yr_strt_dt is null) and (p_lmtn_yr_end_dt is not null) ) then
392: --

Line 395: hr_utility.set_message(801,'BEN_INVALID_LMT_STRT_END_DT');

391: (P_lmtn_yr_strt_dt is null) and (p_lmtn_yr_end_dt is not null) ) then
392: --
393: -- raise error Limitation year's End Date can not be null if start date is not null
394: --
395: hr_utility.set_message(801,'BEN_INVALID_LMT_STRT_END_DT');
396: hr_utility.set_message_token('ERR_MSG',
397: 'lmtn_Start/End_dt is mandatory (if other is not null');
398: hr_utility.set_message_token('LMT_YR_STRT_DT',p_lmtn_yr_strt_dt);
399: hr_utility.set_message_token('LMT_YR_END_DT',p_lmtn_yr_end_dt);

Line 396: hr_utility.set_message_token('ERR_MSG',

392: --
393: -- raise error Limitation year's End Date can not be null if start date is not null
394: --
395: hr_utility.set_message(801,'BEN_INVALID_LMT_STRT_END_DT');
396: hr_utility.set_message_token('ERR_MSG',
397: 'lmtn_Start/End_dt is mandatory (if other is not null');
398: hr_utility.set_message_token('LMT_YR_STRT_DT',p_lmtn_yr_strt_dt);
399: hr_utility.set_message_token('LMT_YR_END_DT',p_lmtn_yr_end_dt);
400: hr_utility.raise_error;

Line 398: hr_utility.set_message_token('LMT_YR_STRT_DT',p_lmtn_yr_strt_dt);

394: --
395: hr_utility.set_message(801,'BEN_INVALID_LMT_STRT_END_DT');
396: hr_utility.set_message_token('ERR_MSG',
397: 'lmtn_Start/End_dt is mandatory (if other is not null');
398: hr_utility.set_message_token('LMT_YR_STRT_DT',p_lmtn_yr_strt_dt);
399: hr_utility.set_message_token('LMT_YR_END_DT',p_lmtn_yr_end_dt);
400: hr_utility.raise_error;
401: elsif (p_lmtn_yr_strt_dt is not null and p_lmtn_yr_strt_dt > p_lmtn_yr_end_dt) then
402: --

Line 399: hr_utility.set_message_token('LMT_YR_END_DT',p_lmtn_yr_end_dt);

395: hr_utility.set_message(801,'BEN_INVALID_LMT_STRT_END_DT');
396: hr_utility.set_message_token('ERR_MSG',
397: 'lmtn_Start/End_dt is mandatory (if other is not null');
398: hr_utility.set_message_token('LMT_YR_STRT_DT',p_lmtn_yr_strt_dt);
399: hr_utility.set_message_token('LMT_YR_END_DT',p_lmtn_yr_end_dt);
400: hr_utility.raise_error;
401: elsif (p_lmtn_yr_strt_dt is not null and p_lmtn_yr_strt_dt > p_lmtn_yr_end_dt) then
402: --
403: -- raise error if limitation year Start Date not null then it must precede End date

Line 400: hr_utility.raise_error;

396: hr_utility.set_message_token('ERR_MSG',
397: 'lmtn_Start/End_dt is mandatory (if other is not null');
398: hr_utility.set_message_token('LMT_YR_STRT_DT',p_lmtn_yr_strt_dt);
399: hr_utility.set_message_token('LMT_YR_END_DT',p_lmtn_yr_end_dt);
400: hr_utility.raise_error;
401: elsif (p_lmtn_yr_strt_dt is not null and p_lmtn_yr_strt_dt > p_lmtn_yr_end_dt) then
402: --
403: -- raise error if limitation year Start Date not null then it must precede End date
404: --

Line 405: hr_utility.set_message(801,'BEN_INVALID_LMT_STRT_END_DT');

401: elsif (p_lmtn_yr_strt_dt is not null and p_lmtn_yr_strt_dt > p_lmtn_yr_end_dt) then
402: --
403: -- raise error if limitation year Start Date not null then it must precede End date
404: --
405: hr_utility.set_message(801,'BEN_INVALID_LMT_STRT_END_DT');
406: hr_utility.set_message_token('ERR_MSG',
407: 'If Limitaiton Year start date is not null, then it must precede End date');
408: hr_utility.set_message_token('LMT_YR_STRT_DT',p_lmtn_yr_strt_dt);
409: hr_utility.set_message_token('LMT_YR_END_DT',p_lmtn_yr_end_dt);

Line 406: hr_utility.set_message_token('ERR_MSG',

402: --
403: -- raise error if limitation year Start Date not null then it must precede End date
404: --
405: hr_utility.set_message(801,'BEN_INVALID_LMT_STRT_END_DT');
406: hr_utility.set_message_token('ERR_MSG',
407: 'If Limitaiton Year start date is not null, then it must precede End date');
408: hr_utility.set_message_token('LMT_YR_STRT_DT',p_lmtn_yr_strt_dt);
409: hr_utility.set_message_token('LMT_YR_END_DT',p_lmtn_yr_end_dt);
410: hr_utility.raise_error;

Line 408: hr_utility.set_message_token('LMT_YR_STRT_DT',p_lmtn_yr_strt_dt);

404: --
405: hr_utility.set_message(801,'BEN_INVALID_LMT_STRT_END_DT');
406: hr_utility.set_message_token('ERR_MSG',
407: 'If Limitaiton Year start date is not null, then it must precede End date');
408: hr_utility.set_message_token('LMT_YR_STRT_DT',p_lmtn_yr_strt_dt);
409: hr_utility.set_message_token('LMT_YR_END_DT',p_lmtn_yr_end_dt);
410: hr_utility.raise_error;
411:
412: hr_utility.raise_error;

Line 409: hr_utility.set_message_token('LMT_YR_END_DT',p_lmtn_yr_end_dt);

405: hr_utility.set_message(801,'BEN_INVALID_LMT_STRT_END_DT');
406: hr_utility.set_message_token('ERR_MSG',
407: 'If Limitaiton Year start date is not null, then it must precede End date');
408: hr_utility.set_message_token('LMT_YR_STRT_DT',p_lmtn_yr_strt_dt);
409: hr_utility.set_message_token('LMT_YR_END_DT',p_lmtn_yr_end_dt);
410: hr_utility.raise_error;
411:
412: hr_utility.raise_error;
413: elsif(upper(nvl(p_perd_typ_cd,'***')) = 'CAL' and

Line 410: hr_utility.raise_error;

406: hr_utility.set_message_token('ERR_MSG',
407: 'If Limitaiton Year start date is not null, then it must precede End date');
408: hr_utility.set_message_token('LMT_YR_STRT_DT',p_lmtn_yr_strt_dt);
409: hr_utility.set_message_token('LMT_YR_END_DT',p_lmtn_yr_end_dt);
410: hr_utility.raise_error;
411:
412: hr_utility.raise_error;
413: elsif(upper(nvl(p_perd_typ_cd,'***')) = 'CAL' and
414: ( p_perds_in_yr_num is null or p_perd_tm_uom_cd is null) ) then

Line 412: hr_utility.raise_error;

408: hr_utility.set_message_token('LMT_YR_STRT_DT',p_lmtn_yr_strt_dt);
409: hr_utility.set_message_token('LMT_YR_END_DT',p_lmtn_yr_end_dt);
410: hr_utility.raise_error;
411:
412: hr_utility.raise_error;
413: elsif(upper(nvl(p_perd_typ_cd,'***')) = 'CAL' and
414: ( p_perds_in_yr_num is null or p_perd_tm_uom_cd is null) ) then
415: --
416: -- Raise Error if Perd_typ_cd is Calendar year, then perds_in_yr_num, and perd_tm_uom fields

Line 419: hr_utility.set_message(801,'BEN_INVALID_PERD_TYP_UOM');

415: --
416: -- Raise Error if Perd_typ_cd is Calendar year, then perds_in_yr_num, and perd_tm_uom fields
417: -- will become mandatory fields.
418: --
419: hr_utility.set_message(801,'BEN_INVALID_PERD_TYP_UOM');
420: hr_utility.set_message_token('ERR_MSG',
421: 'perd_tm_uom_cd and perds_in_yr_num are mandatory fields if perd_typ_cd = Cal yr');
422: hr_utility.set_message_token('PERD_TYP_CD', p_perd_typ_cd);
423: hr_utility.set_message_token('PERDS_IN_YR_NUM', to_char(p_perds_in_yr_num) );

Line 420: hr_utility.set_message_token('ERR_MSG',

416: -- Raise Error if Perd_typ_cd is Calendar year, then perds_in_yr_num, and perd_tm_uom fields
417: -- will become mandatory fields.
418: --
419: hr_utility.set_message(801,'BEN_INVALID_PERD_TYP_UOM');
420: hr_utility.set_message_token('ERR_MSG',
421: 'perd_tm_uom_cd and perds_in_yr_num are mandatory fields if perd_typ_cd = Cal yr');
422: hr_utility.set_message_token('PERD_TYP_CD', p_perd_typ_cd);
423: hr_utility.set_message_token('PERDS_IN_YR_NUM', to_char(p_perds_in_yr_num) );
424: hr_utility.set_message_token('PERD_TM_UOM_CD', p_perd_tm_uom_cd);

Line 422: hr_utility.set_message_token('PERD_TYP_CD', p_perd_typ_cd);

418: --
419: hr_utility.set_message(801,'BEN_INVALID_PERD_TYP_UOM');
420: hr_utility.set_message_token('ERR_MSG',
421: 'perd_tm_uom_cd and perds_in_yr_num are mandatory fields if perd_typ_cd = Cal yr');
422: hr_utility.set_message_token('PERD_TYP_CD', p_perd_typ_cd);
423: hr_utility.set_message_token('PERDS_IN_YR_NUM', to_char(p_perds_in_yr_num) );
424: hr_utility.set_message_token('PERD_TM_UOM_CD', p_perd_tm_uom_cd);
425:
426: hr_utility.raise_error;

Line 423: hr_utility.set_message_token('PERDS_IN_YR_NUM', to_char(p_perds_in_yr_num) );

419: hr_utility.set_message(801,'BEN_INVALID_PERD_TYP_UOM');
420: hr_utility.set_message_token('ERR_MSG',
421: 'perd_tm_uom_cd and perds_in_yr_num are mandatory fields if perd_typ_cd = Cal yr');
422: hr_utility.set_message_token('PERD_TYP_CD', p_perd_typ_cd);
423: hr_utility.set_message_token('PERDS_IN_YR_NUM', to_char(p_perds_in_yr_num) );
424: hr_utility.set_message_token('PERD_TM_UOM_CD', p_perd_tm_uom_cd);
425:
426: hr_utility.raise_error;
427: end if;

Line 424: hr_utility.set_message_token('PERD_TM_UOM_CD', p_perd_tm_uom_cd);

420: hr_utility.set_message_token('ERR_MSG',
421: 'perd_tm_uom_cd and perds_in_yr_num are mandatory fields if perd_typ_cd = Cal yr');
422: hr_utility.set_message_token('PERD_TYP_CD', p_perd_typ_cd);
423: hr_utility.set_message_token('PERDS_IN_YR_NUM', to_char(p_perds_in_yr_num) );
424: hr_utility.set_message_token('PERD_TM_UOM_CD', p_perd_tm_uom_cd);
425:
426: hr_utility.raise_error;
427: end if;
428: --

Line 426: hr_utility.raise_error;

422: hr_utility.set_message_token('PERD_TYP_CD', p_perd_typ_cd);
423: hr_utility.set_message_token('PERDS_IN_YR_NUM', to_char(p_perds_in_yr_num) );
424: hr_utility.set_message_token('PERD_TM_UOM_CD', p_perd_tm_uom_cd);
425:
426: hr_utility.raise_error;
427: end if;
428: --
429: hr_utility.set_location('Leaving:'||l_proc, 10);
430: --

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

425:
426: hr_utility.raise_error;
427: end if;
428: --
429: hr_utility.set_location('Leaving:'||l_proc, 10);
430: --
431:
432: End chk_Lmt_strt_end_perd_typ_uom;
433:

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

440: --
441: l_proc varchar2(72) := g_package||'insert_validate';
442: --
443: Begin
444: hr_utility.set_location('Entering:'||l_proc, 5);
445: --
446: -- Call all supporting business operations
447: --
448: --

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

484:
485: --
486:
487:
488: hr_utility.set_location(' Leaving:'||l_proc, 10);
489: End insert_validate;
490: --
491: -- ----------------------------------------------------------------------------
492: -- |---------------------------< update_validate >----------------------------|

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

496: --
497: l_proc varchar2(72) := g_package||'update_validate';
498: --
499: Begin
500: hr_utility.set_location('Entering:'||l_proc, 5);
501: --
502: -- Call all supporting business operations
503: --
504: --

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

537: p_perd_typ_cd => p_rec.perd_typ_cd,
538: p_perds_in_yr_num => p_rec.perds_in_yr_num,
539: p_perd_tm_uom_cd => p_rec.perd_tm_uom_cd);
540: --
541: hr_utility.set_location(' Leaving:'||l_proc, 10);
542: End update_validate;
543: --
544: -- ----------------------------------------------------------------------------
545: -- |---------------------------< delete_validate >----------------------------|

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

571: --
572: l_wthn_yr_perd c_wthn_yr_perd%rowtype ;
573: --
574: Begin
575: hr_utility.set_location('Entering:'||l_proc, 5);
576: --
577: -- Call all supporting business operations
578: --
579: open c_popl_yr_exists ;

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

608: fnd_message.raise_error;
609: end if ;
610: close c_wthn_yr_perd ;
611: --
612: hr_utility.set_location(' Leaving:'||l_proc, 10);
613: End delete_validate;
614: --
615: --
616: -- ---------------------------------------------------------------------------

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

635: l_proc varchar2(72) := g_package||'return_legislation_code';
636: --
637: begin
638: --
639: hr_utility.set_location('Entering:'|| l_proc, 10);
640: --
641: -- Ensure that all the mandatory parameter are not null
642: --
643: hr_api.mandatory_arg_error(p_api_name => l_proc,

Line 657: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');

653: close csr_leg_code;
654: --
655: -- The primary key is invalid therefore we must error
656: --
657: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
658: hr_utility.raise_error;
659: --
660: end if;
661: --

Line 658: hr_utility.raise_error;

654: --
655: -- The primary key is invalid therefore we must error
656: --
657: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
658: hr_utility.raise_error;
659: --
660: end if;
661: --
662: close csr_leg_code;

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

660: end if;
661: --
662: close csr_leg_code;
663: --
664: hr_utility.set_location(' Leaving:'|| l_proc, 20);
665: --
666: return l_legislation_code;
667: --
668: end return_legislation_code;