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.PER_VGR_BUS dependencies on HR_UTILITY

Line 59: hr_utility.set_location('Entering: '|| l_proc, 1);

55: from per_grades gra
56: where gra.grade_id = p_grade_id;
57: --
58: begin
59: hr_utility.set_location('Entering: '|| l_proc, 1);
60: --
61: -- Check mandatory parameters have been set
62: --
63: hr_api.mandatory_arg_error

Line 74: hr_utility.set_location(l_proc, 2);

70: (p_api_name => l_proc,
71: p_argument => 'business_group_id',
72: p_argument_value => p_business_group_id
73: );
74: hr_utility.set_location(l_proc, 2);
75: --
76: -- Check that the grade ID is linked to a valid grade on per_grades
77: --
78: open csr_valid_gra;

Line 82: hr_utility.set_message(801, 'HR_51082_GRADE_NOT_EXIST');

78: open csr_valid_gra;
79: fetch csr_valid_gra into l_business_group_id;
80: if csr_valid_gra%notfound then
81: close csr_valid_gra;
82: hr_utility.set_message(801, 'HR_51082_GRADE_NOT_EXIST');
83: hr_utility.raise_error;
84: end if;
85: close csr_valid_gra;
86: --

Line 83: hr_utility.raise_error;

79: fetch csr_valid_gra into l_business_group_id;
80: if csr_valid_gra%notfound then
81: close csr_valid_gra;
82: hr_utility.set_message(801, 'HR_51082_GRADE_NOT_EXIST');
83: hr_utility.raise_error;
84: end if;
85: close csr_valid_gra;
86: --
87: hr_utility.set_location(l_proc, 3);

Line 87: hr_utility.set_location(l_proc, 3);

83: hr_utility.raise_error;
84: end if;
85: close csr_valid_gra;
86: --
87: hr_utility.set_location(l_proc, 3);
88: --
89: if l_business_group_id <> p_business_group_id then
90: hr_utility.set_message(801, 'HR_51083_GRADE_INVALID_BG');
91: hr_utility.raise_error;

Line 90: hr_utility.set_message(801, 'HR_51083_GRADE_INVALID_BG');

86: --
87: hr_utility.set_location(l_proc, 3);
88: --
89: if l_business_group_id <> p_business_group_id then
90: hr_utility.set_message(801, 'HR_51083_GRADE_INVALID_BG');
91: hr_utility.raise_error;
92: end if;
93: hr_utility.set_location(' Leaving: '|| l_proc, 4);
94: end chk_grade_id;

Line 91: hr_utility.raise_error;

87: hr_utility.set_location(l_proc, 3);
88: --
89: if l_business_group_id <> p_business_group_id then
90: hr_utility.set_message(801, 'HR_51083_GRADE_INVALID_BG');
91: hr_utility.raise_error;
92: end if;
93: hr_utility.set_location(' Leaving: '|| l_proc, 4);
94: end chk_grade_id;
95: --

Line 93: hr_utility.set_location(' Leaving: '|| l_proc, 4);

89: if l_business_group_id <> p_business_group_id then
90: hr_utility.set_message(801, 'HR_51083_GRADE_INVALID_BG');
91: hr_utility.raise_error;
92: end if;
93: hr_utility.set_location(' Leaving: '|| l_proc, 4);
94: end chk_grade_id;
95: --
96: -- ----------------------------------------------------------------------------
97: -- |---------------------------< chk_date_from >----------------------------|

Line 175: hr_utility.set_location('Entering:'|| l_proc, 1);

171: and p_date_from >= pos.date_effective
172: and p_effective_date between pos.effective_start_date and pos.effective_end_date;
173: --
174: begin
175: hr_utility.set_location('Entering:'|| l_proc, 1);
176: --
177: -- Check mandatory parameters have been set
178: --
179: hr_api.mandatory_arg_error

Line 201: hr_utility.set_location(l_proc, 2);

197: ,p_object_version_number => p_object_version_number);
198: --
199: if ((l_api_updating and per_vgr_shd.g_old_rec.date_from <> p_date_from) or
200: (NOT l_api_updating)) then
201: hr_utility.set_location(l_proc, 2);
202: --
203: -- Check that the date_from value is less than or equal to the date_to
204: -- value for the current record
205: --

Line 207: hr_utility.set_message(801, 'HR_51084_VGR_DATE_LESS');

203: -- Check that the date_from value is less than or equal to the date_to
204: -- value for the current record
205: --
206: if p_date_from > nvl(p_date_to, hr_api.g_eot) then
207: hr_utility.set_message(801, 'HR_51084_VGR_DATE_LESS');
208: hr_utility.raise_error;
209: end if;
210: hr_utility.set_location(l_proc, 3);
211: --

Line 208: hr_utility.raise_error;

204: -- value for the current record
205: --
206: if p_date_from > nvl(p_date_to, hr_api.g_eot) then
207: hr_utility.set_message(801, 'HR_51084_VGR_DATE_LESS');
208: hr_utility.raise_error;
209: end if;
210: hr_utility.set_location(l_proc, 3);
211: --
212: -- Check that date_from is within the range of the date_from and date_to

Line 210: hr_utility.set_location(l_proc, 3);

206: if p_date_from > nvl(p_date_to, hr_api.g_eot) then
207: hr_utility.set_message(801, 'HR_51084_VGR_DATE_LESS');
208: hr_utility.raise_error;
209: end if;
210: hr_utility.set_location(l_proc, 3);
211: --
212: -- Check that date_from is within the range of the date_from and date_to
213: -- on per_grades for p_grade_id
214: --

Line 219: hr_utility.set_message(801, 'HR_51085_VGR_DATE_GRADE');

215: open csr_chk_gra_dates;
216: fetch csr_chk_gra_dates into l_exists;
217: if csr_chk_gra_dates%notfound then
218: close csr_chk_gra_dates;
219: hr_utility.set_message(801, 'HR_51085_VGR_DATE_GRADE');
220: hr_utility.raise_error;
221: end if;
222: close csr_chk_gra_dates;
223: hr_utility.set_location(l_proc, 4);

Line 220: hr_utility.raise_error;

216: fetch csr_chk_gra_dates into l_exists;
217: if csr_chk_gra_dates%notfound then
218: close csr_chk_gra_dates;
219: hr_utility.set_message(801, 'HR_51085_VGR_DATE_GRADE');
220: hr_utility.raise_error;
221: end if;
222: close csr_chk_gra_dates;
223: hr_utility.set_location(l_proc, 4);
224: --

Line 223: hr_utility.set_location(l_proc, 4);

219: hr_utility.set_message(801, 'HR_51085_VGR_DATE_GRADE');
220: hr_utility.raise_error;
221: end if;
222: close csr_chk_gra_dates;
223: hr_utility.set_location(l_proc, 4);
224: --
225: -- Check that date_from is on or later than the date_from on per_jobs_v for
226: -- p_job_id
227: --

Line 233: hr_utility.set_message(801, 'HR_51086_VGR_DATE_JOB');

229: open csr_chk_job_dates;
230: fetch csr_chk_job_dates into l_exists;
231: if csr_chk_job_dates%notfound then
232: close csr_chk_job_dates;
233: hr_utility.set_message(801, 'HR_51086_VGR_DATE_JOB');
234: hr_utility.raise_error;
235: end if;
236: close csr_chk_job_dates;
237: end if;

Line 234: hr_utility.raise_error;

230: fetch csr_chk_job_dates into l_exists;
231: if csr_chk_job_dates%notfound then
232: close csr_chk_job_dates;
233: hr_utility.set_message(801, 'HR_51086_VGR_DATE_JOB');
234: hr_utility.raise_error;
235: end if;
236: close csr_chk_job_dates;
237: end if;
238: hr_utility.set_location(l_proc, 5);

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

234: hr_utility.raise_error;
235: end if;
236: close csr_chk_job_dates;
237: end if;
238: hr_utility.set_location(l_proc, 5);
239: --
240: -- Check that date_from is on or later than the effective_date on
241: -- hr_positions_f p_position_id
242: --

Line 248: hr_utility.set_message(801, 'HR_51087_VGR_DATE_POS');

244: open csr_chk_pos_dates;
245: fetch csr_chk_pos_dates into l_exists;
246: if csr_chk_pos_dates%notfound then
247: close csr_chk_pos_dates;
248: hr_utility.set_message(801, 'HR_51087_VGR_DATE_POS');
249: hr_utility.raise_error;
250: end if;
251: close csr_chk_pos_dates;
252: end if;

Line 249: hr_utility.raise_error;

245: fetch csr_chk_pos_dates into l_exists;
246: if csr_chk_pos_dates%notfound then
247: close csr_chk_pos_dates;
248: hr_utility.set_message(801, 'HR_51087_VGR_DATE_POS');
249: hr_utility.raise_error;
250: end if;
251: close csr_chk_pos_dates;
252: end if;
253: end if;

Line 255: hr_utility.set_location(' Leaving:'|| l_proc, 6);

251: close csr_chk_pos_dates;
252: end if;
253: end if;
254: --
255: hr_utility.set_location(' Leaving:'|| l_proc, 6);
256: end chk_date_from;
257: --
258: -- ----------------------------------------------------------------------------
259: -- |---------------------------< chk_job_or_position_rule >-------------|

Line 297: hr_utility.set_location('Entering: '|| l_proc, 1);

293: l_proc varchar2(72) := g_package||'chk_job_or_position_rule';
294: --
295: --
296: begin
297: hr_utility.set_location('Entering: '|| l_proc, 1);
298: --
299: if p_job_id is not null and p_position_id is not null then
300: hr_utility.set_message(801, 'HR_51088_VGR_JOB_OR_POS');
301: hr_utility.raise_error;

Line 300: hr_utility.set_message(801, 'HR_51088_VGR_JOB_OR_POS');

296: begin
297: hr_utility.set_location('Entering: '|| l_proc, 1);
298: --
299: if p_job_id is not null and p_position_id is not null then
300: hr_utility.set_message(801, 'HR_51088_VGR_JOB_OR_POS');
301: hr_utility.raise_error;
302: elsif p_job_id is null and p_position_id is null then
303: hr_utility.set_message(801, 'HR_51089_VGR_INV_JOB_OR_POS');
304: hr_utility.raise_error;

Line 301: hr_utility.raise_error;

297: hr_utility.set_location('Entering: '|| l_proc, 1);
298: --
299: if p_job_id is not null and p_position_id is not null then
300: hr_utility.set_message(801, 'HR_51088_VGR_JOB_OR_POS');
301: hr_utility.raise_error;
302: elsif p_job_id is null and p_position_id is null then
303: hr_utility.set_message(801, 'HR_51089_VGR_INV_JOB_OR_POS');
304: hr_utility.raise_error;
305: end if;

Line 303: hr_utility.set_message(801, 'HR_51089_VGR_INV_JOB_OR_POS');

299: if p_job_id is not null and p_position_id is not null then
300: hr_utility.set_message(801, 'HR_51088_VGR_JOB_OR_POS');
301: hr_utility.raise_error;
302: elsif p_job_id is null and p_position_id is null then
303: hr_utility.set_message(801, 'HR_51089_VGR_INV_JOB_OR_POS');
304: hr_utility.raise_error;
305: end if;
306: --
307: hr_utility.set_location('Leaving: '|| l_proc, 1);

Line 304: hr_utility.raise_error;

300: hr_utility.set_message(801, 'HR_51088_VGR_JOB_OR_POS');
301: hr_utility.raise_error;
302: elsif p_job_id is null and p_position_id is null then
303: hr_utility.set_message(801, 'HR_51089_VGR_INV_JOB_OR_POS');
304: hr_utility.raise_error;
305: end if;
306: --
307: hr_utility.set_location('Leaving: '|| l_proc, 1);
308: end chk_job_or_position_rule;

Line 307: hr_utility.set_location('Leaving: '|| l_proc, 1);

303: hr_utility.set_message(801, 'HR_51089_VGR_INV_JOB_OR_POS');
304: hr_utility.raise_error;
305: end if;
306: --
307: hr_utility.set_location('Leaving: '|| l_proc, 1);
308: end chk_job_or_position_rule;
309: --
310: -- ----------------------------------------------------------------------------
311: -- |---------------------------< chk_job_id >----------------------------|

Line 376: hr_utility.set_location('Entering: '|| l_proc, 1);

372: );
373: -- Fix For Bug # 6983587 Ends
374: --
375: begin
376: hr_utility.set_location('Entering: '|| l_proc, 1);
377: --
378: --
379: -- Check that the job ID, if it is not null, is linked to a valid job on
380: -- per_jobs_v

Line 399: hr_utility.set_message(801, 'HR_51090_JOB_NOT_EXIST');

395: open csr_valid_job;
396: fetch csr_valid_job into l_business_group_id;
397: if csr_valid_job %notfound then
398: close csr_valid_job;
399: hr_utility.set_message(801, 'HR_51090_JOB_NOT_EXIST');
400: hr_utility.raise_error;
401: end if;
402: close csr_valid_job;
403: --

Line 400: hr_utility.raise_error;

396: fetch csr_valid_job into l_business_group_id;
397: if csr_valid_job %notfound then
398: close csr_valid_job;
399: hr_utility.set_message(801, 'HR_51090_JOB_NOT_EXIST');
400: hr_utility.raise_error;
401: end if;
402: close csr_valid_job;
403: --
404: hr_utility.set_location(l_proc, 2);

Line 404: hr_utility.set_location(l_proc, 2);

400: hr_utility.raise_error;
401: end if;
402: close csr_valid_job;
403: --
404: hr_utility.set_location(l_proc, 2);
405: --
406: if l_business_group_id <> p_business_group_id then
407: hr_utility.set_message(801, 'HR_51091_JOB_INVALID_BG');
408: hr_utility.raise_error;

Line 407: hr_utility.set_message(801, 'HR_51091_JOB_INVALID_BG');

403: --
404: hr_utility.set_location(l_proc, 2);
405: --
406: if l_business_group_id <> p_business_group_id then
407: hr_utility.set_message(801, 'HR_51091_JOB_INVALID_BG');
408: hr_utility.raise_error;
409: end if;
410: --
411: hr_utility.set_location(l_proc, 4);

Line 408: hr_utility.raise_error;

404: hr_utility.set_location(l_proc, 2);
405: --
406: if l_business_group_id <> p_business_group_id then
407: hr_utility.set_message(801, 'HR_51091_JOB_INVALID_BG');
408: hr_utility.raise_error;
409: end if;
410: --
411: hr_utility.set_location(l_proc, 4);
412: --

Line 411: hr_utility.set_location(l_proc, 4);

407: hr_utility.set_message(801, 'HR_51091_JOB_INVALID_BG');
408: hr_utility.raise_error;
409: end if;
410: --
411: hr_utility.set_location(l_proc, 4);
412: --
413: open csr_chk_job_grd_comb;
414: fetch csr_chk_job_grd_comb into l_exists;
415: if csr_chk_job_grd_comb%found then

Line 417: hr_utility.set_message(801, 'HR_51092_VGR_JOB_GRD_COMBO');

413: open csr_chk_job_grd_comb;
414: fetch csr_chk_job_grd_comb into l_exists;
415: if csr_chk_job_grd_comb%found then
416: close csr_chk_job_grd_comb;
417: hr_utility.set_message(801, 'HR_51092_VGR_JOB_GRD_COMBO');
418: hr_utility.raise_error;
419: end if;
420: close csr_chk_job_grd_comb;
421: --

Line 418: hr_utility.raise_error;

414: fetch csr_chk_job_grd_comb into l_exists;
415: if csr_chk_job_grd_comb%found then
416: close csr_chk_job_grd_comb;
417: hr_utility.set_message(801, 'HR_51092_VGR_JOB_GRD_COMBO');
418: hr_utility.raise_error;
419: end if;
420: close csr_chk_job_grd_comb;
421: --
422: end if;

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

419: end if;
420: close csr_chk_job_grd_comb;
421: --
422: end if;
423: hr_utility.set_location(' Leaving: '|| l_proc, 10);
424: end chk_job_id;
425: --
426: -- ----------------------------------------------------------------------------
427: -- |---------------------------< chk_position_id >----------------------------|

Line 496: hr_utility.set_location('Entering: '|| l_proc, 1);

492: -- Fix For Bug # 7516458 Ends
493:
494: --
495: begin
496: hr_utility.set_location('Entering: '|| l_proc, 1);
497: --
498: --
499: hr_api.mandatory_arg_error
500: (p_api_name => l_proc,

Line 519: hr_utility.set_message(801, 'HR_51093_POS_NOT_EXIST');

515: open csr_valid_pos;
516: fetch csr_valid_pos into l_business_group_id;
517: if csr_valid_pos%notfound then
518: close csr_valid_pos;
519: hr_utility.set_message(801, 'HR_51093_POS_NOT_EXIST');
520: hr_utility.raise_error;
521: end if;
522: close csr_valid_pos;
523: --

Line 520: hr_utility.raise_error;

516: fetch csr_valid_pos into l_business_group_id;
517: if csr_valid_pos%notfound then
518: close csr_valid_pos;
519: hr_utility.set_message(801, 'HR_51093_POS_NOT_EXIST');
520: hr_utility.raise_error;
521: end if;
522: close csr_valid_pos;
523: --
524: hr_utility.set_location(l_proc, 2);

Line 524: hr_utility.set_location(l_proc, 2);

520: hr_utility.raise_error;
521: end if;
522: close csr_valid_pos;
523: --
524: hr_utility.set_location(l_proc, 2);
525: --
526: if l_business_group_id <> p_business_group_id then
527: hr_utility.set_message(801, 'HR_51094_POS_INVALID_BG');
528: hr_utility.raise_error;

Line 527: hr_utility.set_message(801, 'HR_51094_POS_INVALID_BG');

523: --
524: hr_utility.set_location(l_proc, 2);
525: --
526: if l_business_group_id <> p_business_group_id then
527: hr_utility.set_message(801, 'HR_51094_POS_INVALID_BG');
528: hr_utility.raise_error;
529: end if;
530: --
531: hr_utility.set_location(l_proc, 3);

Line 528: hr_utility.raise_error;

524: hr_utility.set_location(l_proc, 2);
525: --
526: if l_business_group_id <> p_business_group_id then
527: hr_utility.set_message(801, 'HR_51094_POS_INVALID_BG');
528: hr_utility.raise_error;
529: end if;
530: --
531: hr_utility.set_location(l_proc, 3);
532: --

Line 531: hr_utility.set_location(l_proc, 3);

527: hr_utility.set_message(801, 'HR_51094_POS_INVALID_BG');
528: hr_utility.raise_error;
529: end if;
530: --
531: hr_utility.set_location(l_proc, 3);
532: --
533: open csr_chk_pos_grd_comb;
534: fetch csr_chk_pos_grd_comb into l_exists;
535: if csr_chk_pos_grd_comb%found then

Line 537: hr_utility.set_message(801, 'HR_51095_VGR_POS_GRD_COMBO');

533: open csr_chk_pos_grd_comb;
534: fetch csr_chk_pos_grd_comb into l_exists;
535: if csr_chk_pos_grd_comb%found then
536: CLose csr_chk_pos_grd_comb;
537: hr_utility.set_message(801, 'HR_51095_VGR_POS_GRD_COMBO');
538: hr_utility.raise_error;
539: end if;
540: close csr_chk_pos_grd_comb;
541: --

Line 538: hr_utility.raise_error;

534: fetch csr_chk_pos_grd_comb into l_exists;
535: if csr_chk_pos_grd_comb%found then
536: CLose csr_chk_pos_grd_comb;
537: hr_utility.set_message(801, 'HR_51095_VGR_POS_GRD_COMBO');
538: hr_utility.raise_error;
539: end if;
540: close csr_chk_pos_grd_comb;
541: --
542: end if;

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

539: end if;
540: close csr_chk_pos_grd_comb;
541: --
542: end if;
543: hr_utility.set_location(' Leaving: '|| l_proc, 10);
544: end chk_position_id;
545: --
546: -- ----------------------------------------------------------------------------
547: -- |---------------------------< chk_date_to >----------------------------|

Line 624: hr_utility.set_location('Entering:'|| l_proc, 1);

620: and nvl(p_date_to, hr_api.g_eot) <= nvl(hr_general.get_position_date_end(p_position_id), hr_api.g_eot)
621: and p_effective_date between pos.effective_start_date and pos.effective_end_date;
622: --
623: begin
624: hr_utility.set_location('Entering:'|| l_proc, 1);
625: --
626: -- Check mandatory parameters havu been set
627: --
628: hr_api.mandatory_arg_error

Line 652: hr_utility.set_location(l_proc, 2);

648: if ((l_api_updating and
649: nvl(per_vgr_shd.g_old_rec.date_to, hr_api.g_eot) <>
650: nvl(p_date_to, hr_api.g_eot)) or
651: (NOT l_api_updating)) then
652: hr_utility.set_location(l_proc, 2);
653: --
654: -- Check that the date_from value is greater than or equal to the date_to
655: -- value for the current record
656: --

Line 658: hr_utility.set_message(801, 'HR_51096_VGR_DATE_GREATER');

654: -- Check that the date_from value is greater than or equal to the date_to
655: -- value for the current record
656: --
657: if p_date_from > nvl(p_date_to, hr_api.g_eot) then
658: hr_utility.set_message(801, 'HR_51096_VGR_DATE_GREATER');
659: hr_utility.raise_error;
660: end if;
661: hr_utility.set_location(l_proc, 3);
662: --

Line 659: hr_utility.raise_error;

655: -- value for the current record
656: --
657: if p_date_from > nvl(p_date_to, hr_api.g_eot) then
658: hr_utility.set_message(801, 'HR_51096_VGR_DATE_GREATER');
659: hr_utility.raise_error;
660: end if;
661: hr_utility.set_location(l_proc, 3);
662: --
663: -- Check that date_to is within the range of the date_from and date_to

Line 661: hr_utility.set_location(l_proc, 3);

657: if p_date_from > nvl(p_date_to, hr_api.g_eot) then
658: hr_utility.set_message(801, 'HR_51096_VGR_DATE_GREATER');
659: hr_utility.raise_error;
660: end if;
661: hr_utility.set_location(l_proc, 3);
662: --
663: -- Check that date_to is within the range of the date_from and date_to
664: -- on per_grades for p_grade_id
665: --

Line 670: hr_utility.set_message(801, 'HR_51097_VGR_END_DATE_INVALID');

666: open csr_chk_gra_dates;
667: fetch csr_chk_gra_dates into l_exists;
668: if csr_chk_gra_dates%notfound then
669: close csr_chk_gra_dates;
670: hr_utility.set_message(801, 'HR_51097_VGR_END_DATE_INVALID');
671: hr_utility.raise_error;
672: end if;
673: close csr_chk_gra_dates;
674: hr_utility.set_location(l_proc, 4);

Line 671: hr_utility.raise_error;

667: fetch csr_chk_gra_dates into l_exists;
668: if csr_chk_gra_dates%notfound then
669: close csr_chk_gra_dates;
670: hr_utility.set_message(801, 'HR_51097_VGR_END_DATE_INVALID');
671: hr_utility.raise_error;
672: end if;
673: close csr_chk_gra_dates;
674: hr_utility.set_location(l_proc, 4);
675: --

Line 674: hr_utility.set_location(l_proc, 4);

670: hr_utility.set_message(801, 'HR_51097_VGR_END_DATE_INVALID');
671: hr_utility.raise_error;
672: end if;
673: close csr_chk_gra_dates;
674: hr_utility.set_location(l_proc, 4);
675: --
676: -- Check that date_to is on or earlier than the date_to on per_jobs_v for
677: -- p_job_id
678: --

Line 684: hr_utility.set_message(801, 'HR_51098_VGR_END_DATE_JOB');

680: open csr_chk_job_dates;
681: fetch csr_chk_job_dates into l_exists;
682: if csr_chk_job_dates%notfound then
683: close csr_chk_job_dates;
684: hr_utility.set_message(801, 'HR_51098_VGR_END_DATE_JOB');
685: hr_utility.raise_error;
686: end if;
687: close csr_chk_job_dates;
688: end if;

Line 685: hr_utility.raise_error;

681: fetch csr_chk_job_dates into l_exists;
682: if csr_chk_job_dates%notfound then
683: close csr_chk_job_dates;
684: hr_utility.set_message(801, 'HR_51098_VGR_END_DATE_JOB');
685: hr_utility.raise_error;
686: end if;
687: close csr_chk_job_dates;
688: end if;
689: hr_utility.set_location(l_proc, 5);

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

685: hr_utility.raise_error;
686: end if;
687: close csr_chk_job_dates;
688: end if;
689: hr_utility.set_location(l_proc, 5);
690: --
691: -- Check that date_to is on or later than the end_date on
692: -- hr_positions_f p_position_id
693: --

Line 699: hr_utility.set_message(801, 'HR_51099_VGR_END_DATE_POS');

695: open csr_chk_pos_dates;
696: fetch csr_chk_pos_dates into l_exists;
697: if csr_chk_pos_dates%notfound then
698: close csr_chk_pos_dates;
699: hr_utility.set_message(801, 'HR_51099_VGR_END_DATE_POS');
700: hr_utility.raise_error;
701: end if;
702: close csr_chk_pos_dates;
703: end if;

Line 700: hr_utility.raise_error;

696: fetch csr_chk_pos_dates into l_exists;
697: if csr_chk_pos_dates%notfound then
698: close csr_chk_pos_dates;
699: hr_utility.set_message(801, 'HR_51099_VGR_END_DATE_POS');
700: hr_utility.raise_error;
701: end if;
702: close csr_chk_pos_dates;
703: end if;
704: end if;

Line 706: hr_utility.set_location(' Leaving:'|| l_proc, 6);

702: close csr_chk_pos_dates;
703: end if;
704: end if;
705: --
706: hr_utility.set_location(' Leaving:'|| l_proc, 6);
707: end chk_date_to;
708: -- -----------------------------------------------------------------------
709: -- |------------------------------< chk_df >-----------------------------|
710: -- -----------------------------------------------------------------------

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

737: --
738: l_proc varchar2(72) := g_package||'chk_df';
739: --
740: begin
741: hr_utility.set_location('Entering:'||l_proc, 10);
742: --
743: if ((p_rec.valid_grade_id is not null) and (
744: nvl(per_vgr_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
745: nvl(p_rec.attribute_category, hr_api.g_varchar2) or

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

837: ,p_attribute20_value => p_rec.attribute20
838: );
839: end if;
840: --
841: hr_utility.set_location(' Leaving:'||l_proc, 20);
842:
843: end chk_df;
844: --
845: -- ----------------------------------------------------------------------------

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

850: --
851: l_proc varchar2(72) := g_package||'insert_validate';
852: --
853: Begin
854: hr_utility.set_location('Entering:'||l_proc, 5);
855: --
856: -- Call all supporting business operations. Mapping to the appropriate
857: -- Business Rules in pervga.bru is provided.
858: --

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

860: -- Validate Business Group id
861: --
862: hr_api.validate_bus_grp_id(p_rec.business_group_id);
863: --
864: hr_utility.set_location(l_proc, 10);
865: --
866: -- Validate Grade id
867: --
868: chk_grade_id (p_grade_id => p_rec.grade_id

Line 871: hr_utility.set_location(l_proc, 15);

867: --
868: chk_grade_id (p_grade_id => p_rec.grade_id
869: ,p_business_group_id => p_rec.business_group_id );
870: --
871: hr_utility.set_location(l_proc, 15);
872: --
873: -- Validate that either Position or Job Ids are set
874: --
875: chk_job_or_position_rule

Line 879: hr_utility.set_location(l_proc, 20);

875: chk_job_or_position_rule
876: (p_job_id => p_rec.job_id
877: ,p_position_id => p_rec.position_id);
878: --
879: hr_utility.set_location(l_proc, 20);
880: --
881: -- Validate Job id
882: --
883: chk_job_id (p_job_id => p_rec.job_id

Line 889: hr_utility.set_location(l_proc, 25);

885: ,p_grade_id => p_rec.grade_id
886: ,p_date_from => p_rec.date_from -- Added For Bug # 6983587
887: ,p_date_to => p_rec.date_to); -- Added For Bug 6983587
888: --
889: hr_utility.set_location(l_proc, 25);
890: --
891: -- Validate Position id
892: --
893: chk_position_id (p_position_id => p_rec.position_id

Line 901: hr_utility.set_location(l_proc, 30);

897: ,p_date_from => p_rec.date_from -- Added For Bug # 7516458
898: ,p_date_to => p_rec.date_to); -- Added For Bug 7516458
899:
900: --
901: hr_utility.set_location(l_proc, 30);
902: --
903: -- Validate Date From
904: --
905: chk_date_from

Line 915: hr_utility.set_location(l_proc, 35);

911: ,p_position_id => p_rec.position_id
912: ,p_object_version_number => p_rec.object_version_number
913: ,p_effective_date => p_effective_date); -- Added for Bug# 1760707
914: --
915: hr_utility.set_location(l_proc, 35);
916: --
917: -- Validate Date To
918: --
919: chk_date_to

Line 929: hr_utility.set_location(' Leaving:'||l_proc, 40);

925: ,p_position_id => p_rec.position_id
926: ,p_object_version_number => p_rec.object_version_number
927: ,p_effective_date => p_effective_date); -- Added for Bug# 1760707
928: --
929: hr_utility.set_location(' Leaving:'||l_proc, 40);
930: --
931: -- Call descriptive flexfield validation routines
932: --
933: per_vgr_bus.chk_df(p_rec => p_rec);

Line 935: hr_utility.set_location(' Leaving:'||l_proc, 45);

931: -- Call descriptive flexfield validation routines
932: --
933: per_vgr_bus.chk_df(p_rec => p_rec);
934: --
935: hr_utility.set_location(' Leaving:'||l_proc, 45);
936:
937: End insert_validate;
938: --
939: -- ----------------------------------------------------------------------------

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

944: --
945: l_proc varchar2(72) := g_package||'update_validate';
946: --
947: Begin
948: hr_utility.set_location('Entering:'||l_proc, 5);
949: --
950: -- Call all supporting business operations. Mapping to the
951: -- appropriate Business Rules in per_vgr.bru is provided
952: --

Line 953: hr_utility.set_location(l_proc, 6);

949: --
950: -- Call all supporting business operations. Mapping to the
951: -- appropriate Business Rules in per_vgr.bru is provided
952: --
953: hr_utility.set_location(l_proc, 6);
954: --
955: -- Validate Business Group id
956: --
957: hr_api.validate_bus_grp_id(p_rec.business_group_id);

Line 971: hr_utility.set_location(l_proc, 7);

967: ,p_position_id => p_rec.position_id
968: ,p_object_version_number => p_rec.object_version_number
969: ,p_effective_date => p_effective_date); -- Added for Bug# 1760707
970: --
971: hr_utility.set_location(l_proc, 7);
972: --
973: -- Validate Date To
974: --
975: chk_date_to

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

982: ,p_object_version_number => p_rec.object_version_number
983: ,p_effective_date => p_effective_date ); --Added for Bug#1760707
984: --
985: --
986: hr_utility.set_location(' Leaving:'||l_proc, 10);
987: --
988: -- Call descriptive flexfield validation routines
989: --
990: per_vgr_bus.chk_df(p_rec => p_rec);

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

988: -- Call descriptive flexfield validation routines
989: --
990: per_vgr_bus.chk_df(p_rec => p_rec);
991: --
992: hr_utility.set_location(' Leaving:'||l_proc, 15);
993: End update_validate;
994: --
995: -- ----------------------------------------------------------------------------
996: -- |---------------------------< delete_validate >----------------------------|

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

999: --
1000: l_proc varchar2(72) := g_package||'delete_validate';
1001: --
1002: Begin
1003: hr_utility.set_location('Entering:'||l_proc, 5);
1004: --
1005: -- Call all supporting business operations
1006: --
1007: hr_utility.set_location(' Leaving:'||l_proc, 10);

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

1003: hr_utility.set_location('Entering:'||l_proc, 5);
1004: --
1005: -- Call all supporting business operations
1006: --
1007: hr_utility.set_location(' Leaving:'||l_proc, 10);
1008: End delete_validate;
1009: --
1010: -- ---------------------------------------------------------------------------
1011: -- |---------------------< return_legislation_code >-------------------------|

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

1028: --
1029: l_legislation_code varchar2(150);
1030: l_proc varchar2(72) := g_package||'return_legislation_code';
1031: begin
1032: hr_utility.set_location('Entering:'|| l_proc, 10);
1033: --
1034: -- Ensure that all the mandatory parameter are not null
1035: --
1036: hr_api.mandatory_arg_error(p_api_name => l_proc,

Line 1047: hr_utility.set_location(l_proc, 20);

1043: -- call to this function. Just return the value in the global
1044: -- variable.
1045: --
1046: l_legislation_code := g_legislation_code;
1047: hr_utility.set_location(l_proc, 20);
1048: else
1049: --
1050: -- The ID is different to the last call to this function
1051: -- or this is the first call to this function.

Line 1064: hr_utility.set_location(' Leaving:'|| l_proc, 30);

1060: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
1061: fnd_message.raise_error;
1062: end if;
1063: --
1064: hr_utility.set_location(' Leaving:'|| l_proc, 30);
1065: --
1066: -- Set the global variables so the vlaues are
1067: -- available for the next call to this function
1068: --

Line 1073: hr_utility.set_location('Entering:'|| l_proc, 40);

1069: close csr_leg_code;
1070: g_valid_grade_id := p_valid_grade_id;
1071: g_legislation_code := l_legislation_code;
1072: end if;
1073: hr_utility.set_location('Entering:'|| l_proc, 40);
1074: --
1075: return l_legislation_code;
1076: end return_legislation_code;
1077: --