APPS.PER_PER_BUS1 dependencies on HR_UTILITY

Line 9: g_debug boolean := hr_utility.debug_enabled;

5: -- | Private Global Definitions |
6: -- ----------------------------------------------------------------------------
7: --
8: g_package varchar2(33) := ' per_per_bus1.'; -- Global package name
9: g_debug boolean := hr_utility.debug_enabled;
10: --
11: procedure df_update_validate
12: (p_rec in per_per_shd.g_rec_type) is
13: --

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

13: --
14: l_proc varchar2(72) := g_package||'df_update_validate';
15: --
16: begin
17: hr_utility.set_location('Entering:'||l_proc, 10);
18: --
19: if nvl(per_per_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
20: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
21: nvl(per_per_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>

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

82: -- so we must call the flex stub
83: per_per_flex.df(p_rec => p_rec);
84: end if;
85: --
86: hr_utility.set_location(' Leaving:'||l_proc, 10);
87: end df_update_validate;
88: --
89: -- ---------------------------------------------------------------------------
90: -- |------------------< chk_unsupported_attributes >-----------------------|

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

105: l_api_updating boolean;
106: l_exists varchar2(1);
107: --
108: begin
109: hr_utility.set_location('Entering:'|| l_proc, 10);
110: --
111: -- Check mandatory parameters have been set
112: --
113: hr_api.mandatory_arg_error

Line 126: hr_utility.set_location('Entering:'|| l_proc, 20);

122: (p_person_id => p_person_id
123: ,p_effective_date => p_effective_date
124: ,p_object_version_number => p_object_version_number
125: );
126: hr_utility.set_location('Entering:'|| l_proc, 20);
127: --
128: if (l_api_updating and nvl(per_per_shd.g_old_rec.fast_path_employee, hr_api.g_varchar2)
129: <> nvl(p_fast_path_employee, hr_api.g_varchar2))
130: or

Line 147: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

143: -- Check if any of the unsupported attributes are set
144: --
145: if p_fast_path_employee is not null then
146: --
147: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
148: hr_utility.set_message_token('PROCEDURE', l_proc);
149: hr_utility.set_message_token('STEP', 'Fast Path Employee Null Check');
150: hr_utility.raise_error;
151: --

Line 148: hr_utility.set_message_token('PROCEDURE', l_proc);

144: --
145: if p_fast_path_employee is not null then
146: --
147: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
148: hr_utility.set_message_token('PROCEDURE', l_proc);
149: hr_utility.set_message_token('STEP', 'Fast Path Employee Null Check');
150: hr_utility.raise_error;
151: --
152: end if;

Line 149: hr_utility.set_message_token('STEP', 'Fast Path Employee Null Check');

145: if p_fast_path_employee is not null then
146: --
147: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
148: hr_utility.set_message_token('PROCEDURE', l_proc);
149: hr_utility.set_message_token('STEP', 'Fast Path Employee Null Check');
150: hr_utility.raise_error;
151: --
152: end if;
153: --

Line 150: hr_utility.raise_error;

146: --
147: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
148: hr_utility.set_message_token('PROCEDURE', l_proc);
149: hr_utility.set_message_token('STEP', 'Fast Path Employee Null Check');
150: hr_utility.raise_error;
151: --
152: end if;
153: --
154: if p_order_name is not null then

Line 156: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

152: end if;
153: --
154: if p_order_name is not null then
155: --
156: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
157: hr_utility.set_message_token('PROCEDURE', l_proc);
158: hr_utility.set_message_token('STEP', 'Order Name Null Check');
159: hr_utility.raise_error;
160: --

Line 157: hr_utility.set_message_token('PROCEDURE', l_proc);

153: --
154: if p_order_name is not null then
155: --
156: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
157: hr_utility.set_message_token('PROCEDURE', l_proc);
158: hr_utility.set_message_token('STEP', 'Order Name Null Check');
159: hr_utility.raise_error;
160: --
161: end if;

Line 158: hr_utility.set_message_token('STEP', 'Order Name Null Check');

154: if p_order_name is not null then
155: --
156: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
157: hr_utility.set_message_token('PROCEDURE', l_proc);
158: hr_utility.set_message_token('STEP', 'Order Name Null Check');
159: hr_utility.raise_error;
160: --
161: end if;
162: --

Line 159: hr_utility.raise_error;

155: --
156: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
157: hr_utility.set_message_token('PROCEDURE', l_proc);
158: hr_utility.set_message_token('STEP', 'Order Name Null Check');
159: hr_utility.raise_error;
160: --
161: end if;
162: --
163: if p_projected_start_date is not null then

Line 165: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

161: end if;
162: --
163: if p_projected_start_date is not null then
164: --
165: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
166: hr_utility.set_message_token('PROCEDURE', l_proc);
167: hr_utility.set_message_token('STEP', 'Projected Start Date Null Check');
168: hr_utility.raise_error;
169: --

Line 166: hr_utility.set_message_token('PROCEDURE', l_proc);

162: --
163: if p_projected_start_date is not null then
164: --
165: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
166: hr_utility.set_message_token('PROCEDURE', l_proc);
167: hr_utility.set_message_token('STEP', 'Projected Start Date Null Check');
168: hr_utility.raise_error;
169: --
170: end if;

Line 167: hr_utility.set_message_token('STEP', 'Projected Start Date Null Check');

163: if p_projected_start_date is not null then
164: --
165: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
166: hr_utility.set_message_token('PROCEDURE', l_proc);
167: hr_utility.set_message_token('STEP', 'Projected Start Date Null Check');
168: hr_utility.raise_error;
169: --
170: end if;
171: --

Line 168: hr_utility.raise_error;

164: --
165: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
166: hr_utility.set_message_token('PROCEDURE', l_proc);
167: hr_utility.set_message_token('STEP', 'Projected Start Date Null Check');
168: hr_utility.raise_error;
169: --
170: end if;
171: --
172: if p_rehire_authorizor is not null then

Line 174: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

170: end if;
171: --
172: if p_rehire_authorizor is not null then
173: --
174: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
175: hr_utility.set_message_token('PROCEDURE', l_proc);
176: hr_utility.set_message_token('STEP', 'Rehire Authorizor Null Check');
177: hr_utility.raise_error;
178: --

Line 175: hr_utility.set_message_token('PROCEDURE', l_proc);

171: --
172: if p_rehire_authorizor is not null then
173: --
174: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
175: hr_utility.set_message_token('PROCEDURE', l_proc);
176: hr_utility.set_message_token('STEP', 'Rehire Authorizor Null Check');
177: hr_utility.raise_error;
178: --
179: end if;

Line 176: hr_utility.set_message_token('STEP', 'Rehire Authorizor Null Check');

172: if p_rehire_authorizor is not null then
173: --
174: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
175: hr_utility.set_message_token('PROCEDURE', l_proc);
176: hr_utility.set_message_token('STEP', 'Rehire Authorizor Null Check');
177: hr_utility.raise_error;
178: --
179: end if;
180: --

Line 177: hr_utility.raise_error;

173: --
174: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
175: hr_utility.set_message_token('PROCEDURE', l_proc);
176: hr_utility.set_message_token('STEP', 'Rehire Authorizor Null Check');
177: hr_utility.raise_error;
178: --
179: end if;
180: --
181: hr_utility.set_location(l_proc, 30);

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

177: hr_utility.raise_error;
178: --
179: end if;
180: --
181: hr_utility.set_location(l_proc, 30);
182: --
183: end if;
184: --
185: hr_utility.set_location(' Leaving:'|| l_proc, 40);

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

181: hr_utility.set_location(l_proc, 30);
182: --
183: end if;
184: --
185: hr_utility.set_location(' Leaving:'|| l_proc, 40);
186: end chk_unsupported_attributes;
187: --
188: -- ---------------------------------------------------------------------------
189: -- |----------------< chk_correspondence_language >--------------------------|

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

206: from fnd_languages
207: where p_correspondence_language = language_code;
208: --
209: begin
210: hr_utility.set_location('Entering:'|| l_proc, 10);
211: --
212: -- Check mandatory parameters have been set
213: --
214: hr_api.mandatory_arg_error

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

223: (p_person_id => p_person_id
224: ,p_effective_date => p_effective_date
225: ,p_object_version_number => p_object_version_number
226: );
227: hr_utility.set_location(l_proc, 20);
228: --
229: if ((l_api_updating and
230: nvl(per_per_shd.g_old_rec.correspondence_language, hr_api.g_varchar2)
231: <> nvl(p_correspondence_language, hr_api.g_varchar2)) or

Line 247: hr_utility.set_message(801, 'PER_????_PER_INV_COR_LANG');

243: if C_Sel1%NOTFOUND
244: then
245: --
246: close C_Sel1;
247: hr_utility.set_message(801, 'PER_????_PER_INV_COR_LANG');
248: hr_utility.raise_error;
249: --
250: end if;
251: close C_Sel1;

Line 248: hr_utility.raise_error;

244: then
245: --
246: close C_Sel1;
247: hr_utility.set_message(801, 'PER_????_PER_INV_COR_LANG');
248: hr_utility.raise_error;
249: --
250: end if;
251: close C_Sel1;
252: end if;

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

250: end if;
251: close C_Sel1;
252: end if;
253: end if;
254: hr_utility.set_location('Leaving '||l_proc,30);
255: exception
256: when app_exception.application_exception then
257: if hr_multi_message.exception_add
258: (p_associated_column1 => 'PER_ALL_PEOPLE_F.CORRESPONDENCE_LANGUAGE'

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

257: if hr_multi_message.exception_add
258: (p_associated_column1 => 'PER_ALL_PEOPLE_F.CORRESPONDENCE_LANGUAGE'
259: )
260: then
261: hr_utility.set_location(' Leaving:'||l_proc, 40);
262: raise;
263: end if;
264: hr_utility.set_location(' Leaving:'||l_proc,50);
265: end chk_correspondence_language;

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

260: then
261: hr_utility.set_location(' Leaving:'||l_proc, 40);
262: raise;
263: end if;
264: hr_utility.set_location(' Leaving:'||l_proc,50);
265: end chk_correspondence_language;
266: --
267: -- ---------------------------------------------------------------------------
268: -- |----------------< chk_coord_ben_med_cvg_dates >--------------------------|

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

276: --
277: l_proc varchar2(72) := g_package||'chk_coord_ben_med_cvg_dates';
278: --
279: begin
280: hr_utility.set_location('Entering:'|| l_proc, 10);
281: --
282: -- Make sure that the coverage start date is before the coverage end date.
283: --
284: if p_coord_ben_med_cvg_strt_dt is not null or

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

298: --
299: end if;
300: --
301: end if;
302: hr_utility.set_location('Leaving '||l_proc,30);
303: exception
304: when app_exception.application_exception then
305: if hr_multi_message.exception_add
306: (p_associated_column1 => 'PER_ALL_PEOPLE_F.COORD_BEN_MED_CVG_STRT_DT'

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

305: if hr_multi_message.exception_add
306: (p_associated_column1 => 'PER_ALL_PEOPLE_F.COORD_BEN_MED_CVG_STRT_DT'
307: ,p_associated_column2 => 'PER_ALL_PEOPLE_F.COORD_BEN_MED_CVG_END_DT'
308: ) then
309: hr_utility.set_location(' Leaving:'||l_proc, 40);
310: raise;
311: end if;
312: hr_utility.set_location(' Leaving:'||l_proc,50);
313: end;

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

308: ) then
309: hr_utility.set_location(' Leaving:'||l_proc, 40);
310: raise;
311: end if;
312: hr_utility.set_location(' Leaving:'||l_proc,50);
313: end;
314: --
315: -- ---------------------------------------------------------------------------
316: -- |------------------------< chk_other_coverages >--------------------------|

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

328: l_proc varchar2(72) := g_package||'chk_other_coverages';
329: --
330: begin
331: --
332: hr_utility.set_location('Entering:'|| l_proc, 10);
333: --
334: -- Check that the ben_no_cvg_flag is set accordingly based on the value
335: -- of the covered under medicare flag.
336: --

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

351: end if;
352: --
353: end if;
354: end if;
355: hr_utility.set_location('Leaving '||l_proc,30);
356: exception
357: when app_exception.application_exception then
358: if hr_multi_message.exception_add
359: (p_associated_column1 => 'PER_ALL_PEOPLE_F.COORD_BEN_MED_INSR_CRR_NAME'

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

360: ,p_associated_column2 => 'PER_ALL_PEOPLE_F.COORD_BEN_MED_CVG_END_DT'
361: ,p_associated_column3 => 'PER_ALL_PEOPLE_F.COORD_BEN_NO_CVG_FLAG'
362: ,p_associated_column4 => 'PER_ALL_PEOPLE_F.ATTRIBUTE10'
363: ) then
364: hr_utility.set_location(' Leaving:'||l_proc, 40);
365: raise;
366: end if;
367: hr_utility.set_location(' Leaving:'||l_proc,50);
368: end;

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

363: ) then
364: hr_utility.set_location(' Leaving:'||l_proc, 40);
365: raise;
366: end if;
367: hr_utility.set_location(' Leaving:'||l_proc,50);
368: end;
369: -- ---------------------------------------------------------------------------
370: -- |----------------< chk_fte_capacity >--------------------------|
371: -- ---------------------------------------------------------------------------

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

382: l_api_updating boolean;
383: l_exists varchar2(1);
384: --
385: begin
386: hr_utility.set_location('Entering:'|| l_proc, 10);
387: --
388: -- Check mandatory parameters have been set
389: --
390: hr_api.mandatory_arg_error

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

399: (p_person_id => p_person_id
400: ,p_effective_date => p_effective_date
401: ,p_object_version_number => p_object_version_number
402: );
403: hr_utility.set_location(l_proc, 20);
404: --
405: if ((l_api_updating and
406: nvl(per_per_shd.g_old_rec.fte_capacity, hr_api.g_number)
407: <> nvl(p_fte_capacity, hr_api.g_number)) or

Line 421: hr_utility.set_message(801, 'HR_51856_EMP_FTE_VALUE');

417: if p_fte_capacity < 0 OR
418: p_fte_capacity > 100
419: then
420: --Changes done for Bug 7201892
421: hr_utility.set_message(801, 'HR_51856_EMP_FTE_VALUE');
422: hr_utility.raise_error;
423: --
424: end if;
425: end if;

Line 422: hr_utility.raise_error;

418: p_fte_capacity > 100
419: then
420: --Changes done for Bug 7201892
421: hr_utility.set_message(801, 'HR_51856_EMP_FTE_VALUE');
422: hr_utility.raise_error;
423: --
424: end if;
425: end if;
426: end if;

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

423: --
424: end if;
425: end if;
426: end if;
427: hr_utility.set_location('Leaving '||l_proc,30);
428: exception
429: when app_exception.application_exception then
430: if hr_multi_message.exception_add
431: (p_associated_column1 => 'PER_ALL_PEOPLE_F.FTE_CAPACITY'

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

429: when app_exception.application_exception then
430: if hr_multi_message.exception_add
431: (p_associated_column1 => 'PER_ALL_PEOPLE_F.FTE_CAPACITY'
432: ) then
433: hr_utility.set_location(' Leaving:'||l_proc, 40);
434: raise;
435: end if;
436: hr_utility.set_location(' Leaving:'||l_proc,50);
437: end chk_fte_capacity;

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

432: ) then
433: hr_utility.set_location(' Leaving:'||l_proc, 40);
434: raise;
435: end if;
436: hr_utility.set_location(' Leaving:'||l_proc,50);
437: end chk_fte_capacity;
438: --
439: -- ---------------------------------------------------------------------------
440: -- |----------------< chk_coord_ben_med_details >----------------------------|

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

453: l_proc varchar2(72) := g_package||'chk_coord_ben_med_details';
454: --
455: begin
456: --
457: hr_utility.set_location('Entering:'|| l_proc, 10);
458: --
459: -- Check if the correct attributes have been set
460: -- If any of the attributes have been set for benefits coverage then at
461: -- minimum the insurance carrier name must be set.

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

481: --
482: end if;
483: end if;
484: --
485: hr_utility.set_location('Leaving '||l_proc,30);
486: exception
487: when app_exception.application_exception then
488: if hr_multi_message.exception_add
489: (p_associated_column1 => 'PER_ALL_PEOPLE_F.COORD_BEN_MED_INSR_CRR_NAME'

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

487: when app_exception.application_exception then
488: if hr_multi_message.exception_add
489: (p_associated_column1 => 'PER_ALL_PEOPLE_F.COORD_BEN_MED_INSR_CRR_NAME'
490: ) then
491: hr_utility.set_location(' Leaving:'||l_proc, 40);
492: raise;
493: end if;
494: hr_utility.set_location(' Leaving:'||l_proc,50);
495: --

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

490: ) then
491: hr_utility.set_location(' Leaving:'||l_proc, 40);
492: raise;
493: end if;
494: hr_utility.set_location(' Leaving:'||l_proc,50);
495: --
496: end;
497: -- ---------------------------------------------------------------------------
498: -- |-----------------< chk_BACKGROUND_CHECK_STATUS >-----------------------|

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

512: l_api_updating boolean;
513: l_exists varchar2(1);
514: --
515: begin
516: hr_utility.set_location('Entering:'|| l_proc, 10);
517: --
518: -- Check mandatory parameters have been set
519: --
520: hr_api.mandatory_arg_error

Line 545: hr_utility.set_location('Entering:'|| l_proc, 20);

541: (p_person_id => p_person_id
542: ,p_effective_date => p_effective_date
543: ,p_object_version_number => p_object_version_number
544: );
545: hr_utility.set_location('Entering:'|| l_proc, 20);
546: --
547: if ((l_api_updating and
548: nvl(per_per_shd.g_old_rec.BACKGROUND_CHECK_STATUS, hr_api.g_varchar2)
549: <> nvl(p_BACKGROUND_CHECK_STATUS, hr_api.g_varchar2)) or

Line 571: hr_utility.set_message(801, 'PER_52083_PER_INV_BK_CH_ST');

567: ,p_lookup_code => p_BACKGROUND_CHECK_STATUS
568: )
569: then
570: --
571: hr_utility.set_message(801, 'PER_52083_PER_INV_BK_CH_ST');
572: hr_utility.raise_error;
573: --
574: end if;
575: --

Line 572: hr_utility.raise_error;

568: )
569: then
570: --
571: hr_utility.set_message(801, 'PER_52083_PER_INV_BK_CH_ST');
572: hr_utility.raise_error;
573: --
574: end if;
575: --
576: end if;

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

573: --
574: end if;
575: --
576: end if;
577: hr_utility.set_location(l_proc, 30);
578: --
579: end if;
580: --
581: hr_utility.set_location(' Leaving:'|| l_proc, 40);

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

577: hr_utility.set_location(l_proc, 30);
578: --
579: end if;
580: --
581: hr_utility.set_location(' Leaving:'|| l_proc, 40);
582: exception
583: when app_exception.application_exception then
584: if hr_multi_message.exception_add
585: (p_associated_column1 => 'PER_ALL_PEOPLE_F.BACKGROUND_CHECK_STATUS'

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

583: when app_exception.application_exception then
584: if hr_multi_message.exception_add
585: (p_associated_column1 => 'PER_ALL_PEOPLE_F.BACKGROUND_CHECK_STATUS'
586: ) then
587: hr_utility.set_location(' Leaving:'||l_proc, 50);
588: raise;
589: end if;
590: hr_utility.set_location(' Leaving:'||l_proc,60);
591: end chk_BACKGROUND_CHECK_STATUS;

Line 590: hr_utility.set_location(' Leaving:'||l_proc,60);

586: ) then
587: hr_utility.set_location(' Leaving:'||l_proc, 50);
588: raise;
589: end if;
590: hr_utility.set_location(' Leaving:'||l_proc,60);
591: end chk_BACKGROUND_CHECK_STATUS;
592: --
593: -- ---------------------------------------------------------------------------
594: -- |--------------------------< chk_blood_type >---------------------------|

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

608: l_api_updating boolean;
609: l_exists varchar2(1);
610: --
611: begin
612: hr_utility.set_location('Entering:'|| l_proc, 10);
613: --
614: -- Check mandatory parameters have been set
615: --
616: hr_api.mandatory_arg_error

Line 641: hr_utility.set_location('Entering:'|| l_proc, 20);

637: (p_person_id => p_person_id
638: ,p_effective_date => p_effective_date
639: ,p_object_version_number => p_object_version_number
640: );
641: hr_utility.set_location('Entering:'|| l_proc, 20);
642: --
643: if ((l_api_updating and
644: nvl(per_per_shd.g_old_rec.blood_type, hr_api.g_varchar2)
645: <> nvl(p_blood_type, hr_api.g_varchar2)) or

Line 667: hr_utility.set_message(800, 'PER_52111_PER_INV_BL_TYPE');

663: ,p_lookup_code => p_blood_type
664: )
665: then
666: --
667: hr_utility.set_message(800, 'PER_52111_PER_INV_BL_TYPE');
668: hr_utility.raise_error;
669: --
670: end if;
671: --

Line 668: hr_utility.raise_error;

664: )
665: then
666: --
667: hr_utility.set_message(800, 'PER_52111_PER_INV_BL_TYPE');
668: hr_utility.raise_error;
669: --
670: end if;
671: --
672: end if;

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

669: --
670: end if;
671: --
672: end if;
673: hr_utility.set_location(l_proc, 30);
674: --
675: end if;
676: --
677: hr_utility.set_location(' Leaving:'|| l_proc, 40);

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

673: hr_utility.set_location(l_proc, 30);
674: --
675: end if;
676: --
677: hr_utility.set_location(' Leaving:'|| l_proc, 40);
678: exception
679: when app_exception.application_exception then
680: if hr_multi_message.exception_add
681: (p_associated_column1 => 'PER_ALL_PEOPLE_F.BLOOD_TYPE'

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

679: when app_exception.application_exception then
680: if hr_multi_message.exception_add
681: (p_associated_column1 => 'PER_ALL_PEOPLE_F.BLOOD_TYPE'
682: ) then
683: hr_utility.set_location(' Leaving:'||l_proc, 50);
684: raise;
685: end if;
686: hr_utility.set_location(' Leaving:'||l_proc,60);
687: end chk_blood_type;

Line 686: hr_utility.set_location(' Leaving:'||l_proc,60);

682: ) then
683: hr_utility.set_location(' Leaving:'||l_proc, 50);
684: raise;
685: end if;
686: hr_utility.set_location(' Leaving:'||l_proc,60);
687: end chk_blood_type;
688: --
689: -- ---------------------------------------------------------------------------
690: -- |-----------------< chk_student_status >-----------------------|

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

704: l_api_updating boolean;
705: l_exists varchar2(1);
706: --
707: begin
708: hr_utility.set_location('Entering:'|| l_proc, 10);
709: --
710: -- Check mandatory parameters have been set
711: --
712: hr_api.mandatory_arg_error

Line 737: hr_utility.set_location('Entering:'|| l_proc, 20);

733: (p_person_id => p_person_id
734: ,p_effective_date => p_effective_date
735: ,p_object_version_number => p_object_version_number
736: );
737: hr_utility.set_location('Entering:'|| l_proc, 20);
738: --
739: if ((l_api_updating and
740: nvl(per_per_shd.g_old_rec.student_status, hr_api.g_varchar2)
741: <> nvl(p_student_status, hr_api.g_varchar2)) or

Line 763: hr_utility.set_message(800, 'PER_52112_PER_INV_STUD_STAT');

759: ,p_lookup_code => p_student_status
760: )
761: then
762: --
763: hr_utility.set_message(800, 'PER_52112_PER_INV_STUD_STAT');
764: hr_utility.raise_error;
765: --
766: end if;
767: --

Line 764: hr_utility.raise_error;

760: )
761: then
762: --
763: hr_utility.set_message(800, 'PER_52112_PER_INV_STUD_STAT');
764: hr_utility.raise_error;
765: --
766: end if;
767: --
768: end if;

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

765: --
766: end if;
767: --
768: end if;
769: hr_utility.set_location(l_proc, 30);
770: --
771: end if;
772: --
773: hr_utility.set_location(' Leaving:'|| l_proc, 40);

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

769: hr_utility.set_location(l_proc, 30);
770: --
771: end if;
772: --
773: hr_utility.set_location(' Leaving:'|| l_proc, 40);
774: exception
775: when app_exception.application_exception then
776: if hr_multi_message.exception_add
777: (p_associated_column1 => 'PER_ALL_PEOPLE_F.STUDENT_STATUS'

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

775: when app_exception.application_exception then
776: if hr_multi_message.exception_add
777: (p_associated_column1 => 'PER_ALL_PEOPLE_F.STUDENT_STATUS'
778: ) then
779: hr_utility.set_location(' Leaving:'||l_proc,50);
780: raise;
781: end if;
782: hr_utility.set_location(' Leaving:'||l_proc,60);
783: end chk_student_status;

Line 782: hr_utility.set_location(' Leaving:'||l_proc,60);

778: ) then
779: hr_utility.set_location(' Leaving:'||l_proc,50);
780: raise;
781: end if;
782: hr_utility.set_location(' Leaving:'||l_proc,60);
783: end chk_student_status;
784: --
785: -- ---------------------------------------------------------------------------
786: -- |-------------------------< chk_work_schedule >-------------------------|

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

800: l_api_updating boolean;
801: l_exists varchar2(1);
802: --
803: begin
804: hr_utility.set_location('Entering:'|| l_proc, 10);
805: --
806: -- Check mandatory parameters have been set
807: --
808: hr_api.mandatory_arg_error

Line 833: hr_utility.set_location('Entering:'|| l_proc, 20);

829: (p_person_id => p_person_id
830: ,p_effective_date => p_effective_date
831: ,p_object_version_number => p_object_version_number
832: );
833: hr_utility.set_location('Entering:'|| l_proc, 20);
834: --
835: if ((l_api_updating and
836: nvl(per_per_shd.g_old_rec.work_schedule, hr_api.g_varchar2)
837: <> nvl(p_work_schedule, hr_api.g_varchar2)) or

Line 859: hr_utility.set_message(800, 'PER_52113_PER_INV_WK_SCHD');

855: ,p_lookup_code => p_work_schedule
856: )
857: then
858: --
859: hr_utility.set_message(800, 'PER_52113_PER_INV_WK_SCHD');
860: hr_utility.raise_error;
861: --
862: end if;
863: --

Line 860: hr_utility.raise_error;

856: )
857: then
858: --
859: hr_utility.set_message(800, 'PER_52113_PER_INV_WK_SCHD');
860: hr_utility.raise_error;
861: --
862: end if;
863: --
864: end if;

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

861: --
862: end if;
863: --
864: end if;
865: hr_utility.set_location(l_proc, 30);
866: --
867: end if;
868: --
869: hr_utility.set_location(' Leaving:'|| l_proc, 40);

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

865: hr_utility.set_location(l_proc, 30);
866: --
867: end if;
868: --
869: hr_utility.set_location(' Leaving:'|| l_proc, 40);
870: exception
871: when app_exception.application_exception then
872: if hr_multi_message.exception_add
873: (p_associated_column1 => 'PER_ALL_PEOPLE_F.WORK_SCHEDULE'

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

871: when app_exception.application_exception then
872: if hr_multi_message.exception_add
873: (p_associated_column1 => 'PER_ALL_PEOPLE_F.WORK_SCHEDULE'
874: ) then
875: hr_utility.set_location(' Leaving:'||l_proc, 50);
876: raise;
877: end if;
878: hr_utility.set_location(' Leaving:'||l_proc,60);
879: end chk_work_schedule;

Line 878: hr_utility.set_location(' Leaving:'||l_proc,60);

874: ) then
875: hr_utility.set_location(' Leaving:'||l_proc, 50);
876: raise;
877: end if;
878: hr_utility.set_location(' Leaving:'||l_proc,60);
879: end chk_work_schedule;
880: --
881: -- ---------------------------------------------------------------------------
882: -- |-------------------< chk_rehire_recommendation >-----------------------|

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

896: l_api_updating boolean;
897: l_exists varchar2(1);
898: --
899: begin
900: hr_utility.set_location('Entering:'|| l_proc, 10);
901: --
902: -- Check mandatory parameters have been set
903: --
904: hr_api.mandatory_arg_error

Line 929: hr_utility.set_location('Entering:'|| l_proc, 20);

925: (p_person_id => p_person_id
926: ,p_effective_date => p_effective_date
927: ,p_object_version_number => p_object_version_number
928: );
929: hr_utility.set_location('Entering:'|| l_proc, 20);
930: --
931: if ((l_api_updating and
932: nvl(per_per_shd.g_old_rec.rehire_recommendation, hr_api.g_varchar2)
933: <> nvl(p_rehire_recommendation, hr_api.g_varchar2)) or

Line 955: hr_utility.set_message(800, 'PER_52114_PER_INV_REH_REC');

951: ,p_lookup_code => p_rehire_recommendation
952: )
953: then
954: --
955: hr_utility.set_message(800, 'PER_52114_PER_INV_REH_REC');
956: hr_utility.raise_error;
957: --
958: end if;
959: --

Line 956: hr_utility.raise_error;

952: )
953: then
954: --
955: hr_utility.set_message(800, 'PER_52114_PER_INV_REH_REC');
956: hr_utility.raise_error;
957: --
958: end if;
959: --
960: end if;

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

957: --
958: end if;
959: --
960: end if;
961: hr_utility.set_location(l_proc, 30);
962: --
963: end if;
964: --
965: hr_utility.set_location(' Leaving:'|| l_proc, 40);

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

961: hr_utility.set_location(l_proc, 30);
962: --
963: end if;
964: --
965: hr_utility.set_location(' Leaving:'|| l_proc, 40);
966: exception
967: when app_exception.application_exception then
968: if hr_multi_message.exception_add
969: (p_associated_column1 => 'PER_ALL_PEOPLE_F.REHIRE_RECOMMENDATION'

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

967: when app_exception.application_exception then
968: if hr_multi_message.exception_add
969: (p_associated_column1 => 'PER_ALL_PEOPLE_F.REHIRE_RECOMMENDATION'
970: ) then
971: hr_utility.set_location(' Leaving:'||l_proc, 50);
972: raise;
973: end if;
974: hr_utility.set_location(' Leaving:'||l_proc,60);
975: end chk_rehire_recommendation;

Line 974: hr_utility.set_location(' Leaving:'||l_proc,60);

970: ) then
971: hr_utility.set_location(' Leaving:'||l_proc, 50);
972: raise;
973: end if;
974: hr_utility.set_location(' Leaving:'||l_proc,60);
975: end chk_rehire_recommendation;
976: -- ----------------------------------------------------------------------------
977: -- |----------------------< chk_benefit_group_id >----------------------------|
978: -- ----------------------------------------------------------------------------

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

1020: l_proc varchar2(72) := g_package||'chk_benefit_group_id';
1021: l_benefit_group_id number;
1022: --
1023: begin
1024: hr_utility.set_location('Entering:'|| l_proc, 10);
1025: --
1026: -- Check mandatory parameters have been set
1027: --
1028: hr_api.mandatory_arg_error

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

1029: (p_api_name => l_proc
1030: ,p_argument => 'effective_date'
1031: ,p_argument_value => p_effective_date
1032: );
1033: hr_utility.set_location(l_proc, 20);
1034: --
1035: if p_benefit_group_id is NOT NULL then
1036: open csr_chk_benefit_group_id;
1037: fetch csr_chk_benefit_group_id into l_benefit_group_id;

Line 1040: hr_utility.set_message(800, 'PER_52385_BEN_GROUP_ID');

1036: open csr_chk_benefit_group_id;
1037: fetch csr_chk_benefit_group_id into l_benefit_group_id;
1038: if csr_chk_benefit_group_id%NOTFOUND then
1039: close csr_chk_benefit_group_id;
1040: hr_utility.set_message(800, 'PER_52385_BEN_GROUP_ID');
1041: hr_utility.raise_error;
1042: end if;
1043: close csr_chk_benefit_group_id;
1044: --

Line 1041: hr_utility.raise_error;

1037: fetch csr_chk_benefit_group_id into l_benefit_group_id;
1038: if csr_chk_benefit_group_id%NOTFOUND then
1039: close csr_chk_benefit_group_id;
1040: hr_utility.set_message(800, 'PER_52385_BEN_GROUP_ID');
1041: hr_utility.raise_error;
1042: end if;
1043: close csr_chk_benefit_group_id;
1044: --
1045: end if;

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

1043: close csr_chk_benefit_group_id;
1044: --
1045: end if;
1046: --
1047: hr_utility.set_location(' Leaving:'||l_proc, 30);
1048: --
1049: exception
1050: when app_exception.application_exception then
1051: if hr_multi_message.exception_add

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

1050: when app_exception.application_exception then
1051: if hr_multi_message.exception_add
1052: (p_associated_column1 => 'PER_ALL_PEOPLE_F.BENEFIT_GROUP_ID'
1053: ) then
1054: hr_utility.set_location(' Leaving:'||l_proc, 40);
1055: raise;
1056: end if;
1057: hr_utility.set_location(' Leaving:'||l_proc,50);
1058: end chk_benefit_group_id;

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

1053: ) then
1054: hr_utility.set_location(' Leaving:'||l_proc, 40);
1055: raise;
1056: end if;
1057: hr_utility.set_location(' Leaving:'||l_proc,50);
1058: end chk_benefit_group_id;
1059: --
1060: -- ----------------------------------------------------------------------------
1061: -- |----------------------< chk_date_death_and_rcpt_cert >--------------------|

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

1101: l_proc varchar2(72) := g_package||'chk_date_death_and_rcpt_cert';
1102: --
1103: begin
1104: --
1105: hr_utility.set_location('Entering:'|| l_proc,5);
1106: --
1107: if p_receipt_of_death_cert_date is NOT NULL then
1108: if p_date_of_death is NULL then
1109: hr_utility.set_message(800,'PER_52424_DATE_DEATH_RCPT_CERT');

Line 1109: hr_utility.set_message(800,'PER_52424_DATE_DEATH_RCPT_CERT');

1105: hr_utility.set_location('Entering:'|| l_proc,5);
1106: --
1107: if p_receipt_of_death_cert_date is NOT NULL then
1108: if p_date_of_death is NULL then
1109: hr_utility.set_message(800,'PER_52424_DATE_DEATH_RCPT_CERT');
1110: hr_multi_message.add
1111: (p_associated_column1 => 'PER_ALL_PEOPLE_F.RECEIPT_OF_DEATH_CERT_DATE'
1112: ,p_associated_column2 => 'PER_ALL_PEOPLE_F.DATE_OF_DEATH'
1113: );

Line 1115: hr_utility.set_message(800,'PER_52962_CERT_DTE_LT_DOD');

1111: (p_associated_column1 => 'PER_ALL_PEOPLE_F.RECEIPT_OF_DEATH_CERT_DATE'
1112: ,p_associated_column2 => 'PER_ALL_PEOPLE_F.DATE_OF_DEATH'
1113: );
1114: elsif p_receipt_of_death_cert_date <= nvl(p_date_of_death, hr_api.g_date) then
1115: hr_utility.set_message(800,'PER_52962_CERT_DTE_LT_DOD');
1116: hr_multi_message.add
1117: (p_associated_column1 => 'PER_ALL_PEOPLE_F.RECEIPT_OF_DEATH_CERT_DATE'
1118: ,p_associated_column2 => 'PER_ALL_PEOPLE_F.DATE_OF_DEATH'
1119: );

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

1119: );
1120: end if;
1121: end if;
1122: --
1123: hr_utility.set_location(' Leaving:'||l_proc, 10);
1124: --
1125: end chk_date_death_and_rcpt_cert;
1126:
1127: -- ----------------------------------------------------------------------------

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

1168: l_proc varchar2(72) := g_package||'chk_birth_adoption_date';
1169: --
1170: begin
1171: --
1172: hr_utility.set_location('Entering:'|| l_proc,5);
1173: --
1174: if p_dpdnt_adoption_date is NOT NULL then
1175: if p_date_of_birth IS NULL then
1176: hr_utility.set_message(800,'PER_52425_DATE_BIRTH_ADOPTION');

Line 1176: hr_utility.set_message(800,'PER_52425_DATE_BIRTH_ADOPTION');

1172: hr_utility.set_location('Entering:'|| l_proc,5);
1173: --
1174: if p_dpdnt_adoption_date is NOT NULL then
1175: if p_date_of_birth IS NULL then
1176: hr_utility.set_message(800,'PER_52425_DATE_BIRTH_ADOPTION');
1177: hr_multi_message.add
1178: (p_associated_column1 => 'PER_ALL_PEOPLE_F.DPDNT_ADOPTION_DATE'
1179: ,p_associated_column2 => 'PER_ALL_PEOPLE_F.DATE_OF_BIRTH'
1180: );

Line 1185: hr_utility.set_message(800,'PER_52961_ADOPT_LT_DOB');

1181:
1182: -- bug fix : 2164967 begins
1183:
1184: elsif p_dpdnt_adoption_date < nvl(p_date_of_birth, hr_api.g_date) then
1185: hr_utility.set_message(800,'PER_52961_ADOPT_LT_DOB');
1186: hr_multi_message.add
1187: (p_associated_column1 => 'PER_ALL_PEOPLE_F.DPDNT_ADOPTION_DATE'
1188: ,p_associated_column2 => 'PER_ALL_PEOPLE_F.DATE_OF_BIRTH'
1189: );

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

1192:
1193: end if;
1194: end if;
1195: --
1196: hr_utility.set_location(' Leaving:'||l_proc, 10);
1197: --
1198: end chk_birth_adoption_date;
1199: --
1200: -- ----------------------------------------------------------------------------

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

1246: where contact_person_id=p_person_id;
1247: --fix for bug 4262496 ends here.
1248: begin
1249: --
1250: hr_utility.set_location('Entering:'|| l_proc,5);
1251: if hr_multi_message.no_exclusive_error
1252: (p_check_column1 => 'PER_ALL_PEOPLE_F.DATE_OF_BIRTH'
1253: ,p_check_column2 => 'PER_ALL_PEOPLE_F.DATE_OF_DEATH'
1254: ) then

Line 1257: hr_utility.set_message(800,'PER_52963_DOD_LT_DOB');

1253: ,p_check_column2 => 'PER_ALL_PEOPLE_F.DATE_OF_DEATH'
1254: ) then
1255: if p_date_of_death is NOT NULL then
1256: if p_date_of_death < nvl(p_date_of_birth, hr_api.g_date) then --fix for bug 4262496.
1257: hr_utility.set_message(800,'PER_52963_DOD_LT_DOB');
1258: hr_utility.raise_error;
1259: end if;
1260: end if;
1261: --fix for bug 4262496 starts here.

Line 1258: hr_utility.raise_error;

1254: ) then
1255: if p_date_of_death is NOT NULL then
1256: if p_date_of_death < nvl(p_date_of_birth, hr_api.g_date) then --fix for bug 4262496.
1257: hr_utility.set_message(800,'PER_52963_DOD_LT_DOB');
1258: hr_utility.raise_error;
1259: end if;
1260: end if;
1261: --fix for bug 4262496 starts here.
1262: open csr_chk_sd;

Line 1267: hr_utility.set_message(800,'HR_449686_RELATION_EXISTS');

1263: loop
1264: fetch csr_chk_sd into l_con_start_date;
1265: exit when csr_chk_sd%notfound ;
1266: if p_date_of_death < l_con_start_date then
1267: hr_utility.set_message(800,'HR_449686_RELATION_EXISTS');
1268: hr_utility.raise_error;
1269:
1270: end if;
1271: end loop;

Line 1268: hr_utility.raise_error;

1264: fetch csr_chk_sd into l_con_start_date;
1265: exit when csr_chk_sd%notfound ;
1266: if p_date_of_death < l_con_start_date then
1267: hr_utility.set_message(800,'HR_449686_RELATION_EXISTS');
1268: hr_utility.raise_error;
1269:
1270: end if;
1271: end loop;
1272: close csr_chk_sd;

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

1272: close csr_chk_sd;
1273: --fix for bug 4262496 ends here.
1274: end if;
1275: --
1276: hr_utility.set_location(' Leaving:'||l_proc, 10);
1277: --
1278: exception
1279: when app_exception.application_exception then
1280: if hr_multi_message.exception_add

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

1280: if hr_multi_message.exception_add
1281: (p_associated_column1 => 'PER_ALL_PEOPLE_F.DATE_OF_BIRTH'
1282: ,p_associated_column2 => 'PER_ALL_PEOPLE_F.DATE_OF_DEATH'
1283: ) then
1284: hr_utility.set_location(' Leaving:'||l_proc, 20);
1285: raise;
1286: end if;
1287: hr_utility.set_location(' Leaving:'||l_proc,30);
1288: end chk_date_of_death;

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

1283: ) then
1284: hr_utility.set_location(' Leaving:'||l_proc, 20);
1285: raise;
1286: end if;
1287: hr_utility.set_location(' Leaving:'||l_proc,30);
1288: end chk_date_of_death;
1289: --
1290: -- ---------------------------------------------------------------------------
1291: -- |-----------------< chk_rd_flag >----------------------------------------|

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

1338: l_proc varchar2(72) := g_package||'chk_rd_flag';
1339: l_exists varchar2(1);
1340: --
1341: begin
1342: hr_utility.set_location('Entering:'|| l_proc, 10);
1343: --
1344: -- Check mandatory parameters have been set
1345: --
1346: hr_api.mandatory_arg_error

Line 1363: hr_utility.set_location('Entering:'|| l_proc, 20);

1359: (p_api_name => l_proc
1360: ,p_argument => 'validation_end_date'
1361: ,p_argument_value => p_validation_end_date
1362: );
1363: hr_utility.set_location('Entering:'|| l_proc, 20);
1364: --
1365: -- Check if registered_disabled_flag is set.
1366: --
1367: if p_registered_disabled_flag is not null then

Line 1383: hr_utility.set_message(800, 'PER_52386_REG_DISABLED');

1379: ,p_lookup_code => p_registered_disabled_flag
1380: )
1381: then
1382: --
1383: hr_utility.set_message(800, 'PER_52386_REG_DISABLED');
1384: hr_utility.raise_error;
1385: --
1386: end if;
1387: --

Line 1384: hr_utility.raise_error;

1380: )
1381: then
1382: --
1383: hr_utility.set_message(800, 'PER_52386_REG_DISABLED');
1384: hr_utility.raise_error;
1385: --
1386: end if;
1387: --
1388: end if;

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

1385: --
1386: end if;
1387: --
1388: end if;
1389: hr_utility.set_location(l_proc, 30);
1390: --
1391: --
1392: hr_utility.set_location(' Leaving:'|| l_proc, 40);
1393: exception

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

1388: end if;
1389: hr_utility.set_location(l_proc, 30);
1390: --
1391: --
1392: hr_utility.set_location(' Leaving:'|| l_proc, 40);
1393: exception
1394: when app_exception.application_exception then
1395: if hr_multi_message.exception_add
1396: (p_associated_column1 => 'PER_ALL_PEOPLE_F.REGISTERED_DISABLED_FLAG'

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

1394: when app_exception.application_exception then
1395: if hr_multi_message.exception_add
1396: (p_associated_column1 => 'PER_ALL_PEOPLE_F.REGISTERED_DISABLED_FLAG'
1397: ) then
1398: hr_utility.set_location(' Leaving:'||l_proc, 50);
1399: raise;
1400: end if;
1401: hr_utility.set_location(' Leaving:'||l_proc,60);
1402: end chk_rd_flag;

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

1397: ) then
1398: hr_utility.set_location(' Leaving:'||l_proc, 50);
1399: raise;
1400: end if;
1401: hr_utility.set_location(' Leaving:'||l_proc,60);
1402: end chk_rd_flag;
1403: --
1404: -- ---------------------------------------------------------------------------
1405: -- |-------------------------< chk_uses_tobacco >---------------------------|

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

1452: l_proc varchar2(72) := g_package||'chk_uses_tobacco';
1453: l_exists varchar2(1);
1454: --
1455: begin
1456: hr_utility.set_location('Entering:'|| l_proc, 10);
1457: --
1458: -- Check mandatory parameters have been set
1459: --
1460: hr_api.mandatory_arg_error

Line 1477: hr_utility.set_location('Entering:'|| l_proc, 20);

1473: (p_api_name => l_proc
1474: ,p_argument => 'validation_end_date'
1475: ,p_argument_value => p_validation_end_date
1476: );
1477: hr_utility.set_location('Entering:'|| l_proc, 20);
1478: --
1479: -- Check if uses_tobacco_flag is set.
1480: --
1481: if p_uses_tobacco_flag is not null then

Line 1497: hr_utility.set_message(800, 'PER_52388_USES_TOBACCO_F');

1493: ,p_lookup_code => p_uses_tobacco_flag
1494: )
1495: then
1496: --
1497: hr_utility.set_message(800, 'PER_52388_USES_TOBACCO_F');
1498: hr_utility.raise_error;
1499: --
1500: end if;
1501: --

Line 1498: hr_utility.raise_error;

1494: )
1495: then
1496: --
1497: hr_utility.set_message(800, 'PER_52388_USES_TOBACCO_F');
1498: hr_utility.raise_error;
1499: --
1500: end if;
1501: --
1502: end if;

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

1499: --
1500: end if;
1501: --
1502: end if;
1503: hr_utility.set_location(l_proc, 30);
1504: --
1505: --
1506: hr_utility.set_location(' Leaving:'|| l_proc, 40);
1507: exception

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

1502: end if;
1503: hr_utility.set_location(l_proc, 30);
1504: --
1505: --
1506: hr_utility.set_location(' Leaving:'|| l_proc, 40);
1507: exception
1508: when app_exception.application_exception then
1509: if hr_multi_message.exception_add
1510: (p_associated_column1 => 'PER_ALL_PEOPLE_F.USES_TOBACCO_FLAG'

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

1508: when app_exception.application_exception then
1509: if hr_multi_message.exception_add
1510: (p_associated_column1 => 'PER_ALL_PEOPLE_F.USES_TOBACCO_FLAG'
1511: ) then
1512: hr_utility.set_location(' Leaving:'||l_proc, 50);
1513: raise;
1514: end if;
1515: hr_utility.set_location(' Leaving:'||l_proc,60);
1516: end chk_uses_tobacco;

Line 1515: hr_utility.set_location(' Leaving:'||l_proc,60);

1511: ) then
1512: hr_utility.set_location(' Leaving:'||l_proc, 50);
1513: raise;
1514: end if;
1515: hr_utility.set_location(' Leaving:'||l_proc,60);
1516: end chk_uses_tobacco;
1517: --
1518: end per_per_bus1;