40: l_api_updating boolean;
41: --
42: Begin
43: --
44: hr_utility.set_location('Entering:'||l_proc, 5);
45: --
46: l_api_updating := ben_pum_shd.api_updating
47: (p_pop_up_messages_id => p_pop_up_messages_id,
48: p_object_version_number => p_object_version_number);
68: end if;
69: --
70: end if;
71: --
72: hr_utility.set_location('Leaving:'||l_proc, 10);
73: --
74: End chk_pop_up_messages_id;
75: --
76: -- ----------------------------------------------------------------------------
108: l_api_updating boolean;
109: --
110: Begin
111: --
112: hr_utility.set_location('Entering:'||l_proc, 5);
113: --
114: l_api_updating := ben_pum_shd.api_updating
115: (p_pop_up_messages_id => p_pop_up_messages_id,
116: p_object_version_number => p_object_version_number);
138: end if;
139: --
140: end if;
141: --
142: hr_utility.set_location('Leaving:'||l_proc,10);
143: --
144: end chk_no_formula_flag;
145: --
146: -- ----------------------------------------------------------------------------
195: and ff.effective_end_date;
196: --
197: Begin
198: --
199: hr_utility.set_location('Entering:'||l_proc, 5);
200: --
201: l_api_updating := ben_pum_shd.api_updating
202: (p_pop_up_messages_id => p_pop_up_messages_id,
203: p_object_version_number => p_object_version_number);
232: close c1;
233: --
234: end if;
235: --
236: hr_utility.set_location('Leaving:'||l_proc,10);
237: --
238: end chk_formula_id;
239: --
240: --
257: /* ff.application_id = 810 */
258: --
259: Begin
260: --
261: hr_utility.set_location('Entering:'||l_proc, 5);
262: --
263: l_api_updating := ben_pum_shd.api_updating
264: (p_pop_up_messages_id => p_pop_up_messages_id,
265: p_object_version_number => p_object_version_number);
283: close c1;
284: --
285: -- raise error
286: --
287: hr_utility.set_message(801,'FUNCTION_DOES_NOT_EXIST');
288: hr_utility.raise_error;
289: --
290: end if;
291: --
284: --
285: -- raise error
286: --
287: hr_utility.set_message(801,'FUNCTION_DOES_NOT_EXIST');
288: hr_utility.raise_error;
289: --
290: end if;
291: --
292: close c1;
292: close c1;
293: --
294: end if;
295: --
296: hr_utility.set_location('Leaving:'||l_proc,10);
297: --
298: end chk_function_name;
299: --
300:
317: /* ff.application_id = 810 */
318: --
319: Begin
320: --
321: hr_utility.set_location('Entering:'||l_proc, 5);
322: --
323: l_api_updating := ben_pum_shd.api_updating
324: (p_pop_up_messages_id => p_pop_up_messages_id,
325: p_object_version_number => p_object_version_number);
343: close c1;
344: --
345: -- raise error
346: --
347: hr_utility.set_message(801,'MESSAGE_DOES_NOT_EXIST');
348: hr_utility.raise_error;
349: --
350: end if;
351: --
344: --
345: -- raise error
346: --
347: hr_utility.set_message(801,'MESSAGE_DOES_NOT_EXIST');
348: hr_utility.raise_error;
349: --
350: end if;
351: --
352: close c1;
352: close c1;
353: --
354: end if;
355: --
356: hr_utility.set_location('Leaving:'||l_proc,10);
357: --
358: end chk_message;
359:
360: -- ----------------------------------------------------------------------------
373: l_api_updating boolean;
374: --
375: Begin
376: --
377: hr_utility.set_location('Entering:'||l_proc, 5);
378: --
379: l_api_updating := ben_pum_shd.api_updating
380: (p_pop_up_messages_id => p_pop_up_messages_id,
381: p_object_version_number => p_object_version_number);
394: p_effective_date => p_effective_date) then
395: --
396: -- raise error as does not exist as lookup
397: --
398: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
399: hr_utility.raise_error;
400: --
401: end if;
402: --
395: --
396: -- raise error as does not exist as lookup
397: --
398: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
399: hr_utility.raise_error;
400: --
401: end if;
402: --
403: end if;
401: end if;
402: --
403: end if;
404: --
405: hr_utility.set_location('Leaving:'||l_proc,10);
406: --
407: end chk_block_name;
408: --
409: -- ----------------------------------------------------------------------------
422: l_api_updating boolean;
423: --
424: Begin
425: --
426: hr_utility.set_location('Entering:'||l_proc, 5);
427: --
428: l_api_updating := ben_pum_shd.api_updating
429: (p_pop_up_messages_id => p_pop_up_messages_id,
430: p_object_version_number => p_object_version_number);
443: p_effective_date => p_effective_date) then
444: --
445: -- raise error as does not exist as lookup
446: --
447: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
448: hr_utility.raise_error;
449: --
450: end if;
451: --
444: --
445: -- raise error as does not exist as lookup
446: --
447: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
448: hr_utility.raise_error;
449: --
450: end if;
451: --
452: end if;
450: end if;
451: --
452: end if;
453: --
454: hr_utility.set_location('Leaving:'||l_proc,10);
455: --
456: end chk_field_name;
457: --
458: -- ----------------------------------------------------------------------------
471: l_api_updating boolean;
472: --
473: Begin
474: --
475: hr_utility.set_location('Entering:'||l_proc, 5);
476: --
477: l_api_updating := ben_pum_shd.api_updating
478: (p_pop_up_messages_id => p_pop_up_messages_id,
479: p_object_version_number => p_object_version_number);
492: p_effective_date => p_effective_date) then
493: --
494: -- raise error as does not exist as lookup
495: --
496: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
497: hr_utility.raise_error;
498: --
499: end if;
500: --
493: --
494: -- raise error as does not exist as lookup
495: --
496: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
497: hr_utility.raise_error;
498: --
499: end if;
500: --
501: end if;
499: end if;
500: --
501: end if;
502: --
503: hr_utility.set_location('Leaving:'||l_proc,10);
504: --
505: end chk_event_name;
506: --
507: -- ----------------------------------------------------------------------------
520: l_api_updating boolean;
521: --
522: Begin
523: --
524: hr_utility.set_location('Entering:'||l_proc, 5);
525: --
526: l_api_updating := ben_pum_shd.api_updating
527: (p_pop_up_messages_id => p_pop_up_messages_id,
528: p_object_version_number => p_object_version_number);
541: p_effective_date => p_effective_date) then
542: --
543: -- raise error as does not exist as lookup
544: --
545: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
546: hr_utility.raise_error;
547: --
548: end if;
549: --
542: --
543: -- raise error as does not exist as lookup
544: --
545: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
546: hr_utility.raise_error;
547: --
548: end if;
549: --
550: end if;
548: end if;
549: --
550: end if;
551: --
552: hr_utility.set_location('Leaving:'||l_proc,10);
553: --
554: end chk_message_type;
555: --
556: -- ----------------------------------------------------------------------------
567: l_api_updating boolean;
568: --
569: Begin
570: --
571: hr_utility.set_location('Entering:'||l_proc, 5);
572: --
573: l_api_updating := ben_pum_shd.api_updating
574: (p_pop_up_messages_id => p_pop_up_messages_id,
575: p_object_version_number => p_object_version_number);
578: then
579: --
580: -- raise error as does not exist as lookup
581: --
582: -- hr_utility.set_message(801,'BEN_9?????_START_END_DATE');
583: -- changed the Message Name -- by -- ssarkar
584:
585: hr_utility.set_message(801,'BEN_92503_END_DT_GRTR_STRT_DT');
586: hr_utility.raise_error;
581: --
582: -- hr_utility.set_message(801,'BEN_9?????_START_END_DATE');
583: -- changed the Message Name -- by -- ssarkar
584:
585: hr_utility.set_message(801,'BEN_92503_END_DT_GRTR_STRT_DT');
586: hr_utility.raise_error;
587: --
588: end if;
589: --
582: -- hr_utility.set_message(801,'BEN_9?????_START_END_DATE');
583: -- changed the Message Name -- by -- ssarkar
584:
585: hr_utility.set_message(801,'BEN_92503_END_DT_GRTR_STRT_DT');
586: hr_utility.raise_error;
587: --
588: end if;
589: --
590: hr_utility.set_location('Leaving:'||l_proc,10);
586: hr_utility.raise_error;
587: --
588: end if;
589: --
590: hr_utility.set_location('Leaving:'||l_proc,10);
591: --
592: end chk_start_end_date;
593:
594: -- ---------------------------< Bug 3881942 >---------------------------------
612: l_proc varchar2(72) := g_package||'chk_blk_fld_evnt';
613: --
614: Begin
615: --
616: hr_utility.set_location('Entering:'||l_proc,5);
617:
618: --
619: if ( p_event_name in ('ON-COMMIT','KEY-EXIT','WHEN-NEW-FORM-INSTANCE') )
620: and (p_block_name is not null or p_field_name is not null)
630: fnd_message.set_token('EVENT',hr_general.decode_lookup('BEN_EVENT',p_event_name));
631: fnd_message.raise_error;
632: end if;
633: --
634: hr_utility.set_location('Leaving'||l_proc,10);
635: end chk_blk_fld_evnt ;
636: --
637: --
638:
660: and lower(pum.pop_name) = lower(p_pop_name);
661: --
662: Begin
663: --
664: hr_utility.set_location('Entering:'||l_proc, 5);
665: --
666: l_api_updating := ben_pum_shd.api_updating
667: (p_pop_up_messages_id => p_pop_up_messages_id,
668: p_object_version_number => p_object_version_number);
691: close c1;
692: --
693: end if;
694: --
695: hr_utility.set_location('Leaving:'||l_proc,10);
696: --
697: end chk_pop_name;
698: --
699: --
705: --
706: l_proc varchar2(72) := g_package||'insert_validate';
707: --
708: Begin
709: hr_utility.set_location('Entering:'||l_proc, 5);
710: --
711: -- Call all supporting business operations
712: --
713: --
787: p_effective_date => p_effective_date,
788: p_business_group_id => p_rec.business_group_id,
789: p_object_version_number => p_rec.object_version_number);
790: -- Validate Bus Grp
791: hr_utility.set_location(' Leaving:'||l_proc, 10);
792: End insert_validate;
793: --
794: -- ----------------------------------------------------------------------------
795: -- |---------------------------< update_validate >----------------------------|
799: --
800: l_proc varchar2(72) := g_package||'update_validate';
801: --
802: Begin
803: hr_utility.set_location('Entering:'||l_proc, 5);
804: --
805: -- Call all supporting business operations
806: --
807: --
881: p_effective_date => p_effective_date,
882: p_business_group_id => p_rec.business_group_id,
883: p_object_version_number => p_rec.object_version_number);
884: --
885: hr_utility.set_location(' Leaving:'||l_proc, 10);
886: End update_validate;
887: --
888: -- ----------------------------------------------------------------------------
889: -- |---------------------------< delete_validate >----------------------------|
893: --
894: l_proc varchar2(72) := g_package||'delete_validate';
895: --
896: Begin
897: hr_utility.set_location('Entering:'||l_proc, 5);
898: --
899: -- Call all supporting business operations
900: --
901: hr_utility.set_location(' Leaving:'||l_proc, 10);
897: hr_utility.set_location('Entering:'||l_proc, 5);
898: --
899: -- Call all supporting business operations
900: --
901: hr_utility.set_location(' Leaving:'||l_proc, 10);
902: End delete_validate;
903: --
904: --
905: -- ---------------------------------------------------------------------------
924: l_proc varchar2(72) := g_package||'return_legislation_code';
925: --
926: begin
927: --
928: hr_utility.set_location('Entering:'|| l_proc, 10);
929: --
930: -- Ensure that all the mandatory parameter are not null
931: --
932: hr_api.mandatory_arg_error(p_api_name => l_proc,
942: close csr_leg_code;
943: --
944: -- The primary key is invalid therefore we must error
945: --
946: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
947: hr_utility.raise_error;
948: --
949: end if;
950: --
943: --
944: -- The primary key is invalid therefore we must error
945: --
946: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
947: hr_utility.raise_error;
948: --
949: end if;
950: --
951: close csr_leg_code;
949: end if;
950: --
951: close csr_leg_code;
952: --
953: hr_utility.set_location(' Leaving:'|| l_proc, 20);
954: --
955: return l_legislation_code;
956: --
957: end return_legislation_code;