[Home] [Help]
47: (p_pop_up_messages_id => p_pop_up_messages_id,
48: p_object_version_number => p_object_version_number);
49: --
50: if (l_api_updating
51: and nvl(p_pop_up_messages_id,hr_api.g_number)
52: <> ben_pum_shd.g_old_rec.pop_up_messages_id) then
53: --
54: -- raise error as PK has changed
55: --
116: p_object_version_number => p_object_version_number);
117: --
118: if (l_api_updating
119: and p_no_formula_flag
120: <> nvl(ben_pum_shd.g_old_rec.no_formula_flag,hr_api.g_varchar2)
121: or not l_api_updating)
122: and p_no_formula_flag is not null then
123: --
124: -- check if value of lookup falls within lookup type.
122: and p_no_formula_flag is not null then
123: --
124: -- check if value of lookup falls within lookup type.
125: --
126: if hr_api.not_exists_in_hr_lookups
127: (p_lookup_type => 'YES_NO',
128: p_lookup_code => p_no_formula_flag,
129: p_effective_date => p_effective_date) then
130: --
202: (p_pop_up_messages_id => p_pop_up_messages_id,
203: p_object_version_number => p_object_version_number);
204: --
205: if (l_api_updating
206: and nvl(p_formula_id,hr_api.g_number)
207: <> ben_pum_shd.g_old_rec.formula_id
208: or not l_api_updating)
209: and p_formula_id is not null then
210: --
264: (p_pop_up_messages_id => p_pop_up_messages_id,
265: p_object_version_number => p_object_version_number);
266: --
267: if (l_api_updating
268: and nvl(p_function_name,hr_api.g_varchar2)
269: <> ben_pum_shd.g_old_rec.function_name
270: or not l_api_updating)
271: and p_function_name is not null then
272: --
324: (p_pop_up_messages_id => p_pop_up_messages_id,
325: p_object_version_number => p_object_version_number);
326: --
327: if (l_api_updating
328: and nvl(p_message,hr_api.g_varchar2)
329: <> ben_pum_shd.g_old_rec.message
330: or not l_api_updating)
331: and p_message is not null then
332: --
381: p_object_version_number => p_object_version_number);
382: --
383: if (l_api_updating
384: and p_block_name
385: <> nvl(ben_pum_shd.g_old_rec.block_name,hr_api.g_varchar2)
386: or not l_api_updating)
387: and p_block_name is not null then
388: --
389: -- check if value of lookup falls within lookup type.
387: and p_block_name is not null then
388: --
389: -- check if value of lookup falls within lookup type.
390: --
391: if hr_api.not_exists_in_hr_lookups
392: (p_lookup_type => 'BEN_BLOCK',
393: p_lookup_code => p_block_name,
394: p_effective_date => p_effective_date) then
395: --
430: p_object_version_number => p_object_version_number);
431: --
432: if (l_api_updating
433: and p_field_name
434: <> nvl(ben_pum_shd.g_old_rec.field_name,hr_api.g_varchar2)
435: or not l_api_updating)
436: and p_field_name is not null then
437: --
438: -- check if value of lookup falls within lookup type.
436: and p_field_name is not null then
437: --
438: -- check if value of lookup falls within lookup type.
439: --
440: if hr_api.not_exists_in_hr_lookups
441: (p_lookup_type => 'BEN_FIELD',
442: p_lookup_code => p_field_name,
443: p_effective_date => p_effective_date) then
444: --
479: p_object_version_number => p_object_version_number);
480: --
481: if (l_api_updating
482: and p_event_name
483: <> nvl(ben_pum_shd.g_old_rec.event_name,hr_api.g_varchar2)
484: or not l_api_updating)
485: and p_event_name is not null then
486: --
487: -- check if value of lookup falls within lookup type.
485: and p_event_name is not null then
486: --
487: -- check if value of lookup falls within lookup type.
488: --
489: if hr_api.not_exists_in_hr_lookups
490: (p_lookup_type => 'BEN_EVENT',
491: p_lookup_code => p_event_name,
492: p_effective_date => p_effective_date) then
493: --
528: p_object_version_number => p_object_version_number);
529: --
530: if (l_api_updating
531: and p_message_type
532: <> nvl(ben_pum_shd.g_old_rec.message_type,hr_api.g_varchar2)
533: or not l_api_updating)
534: and p_message_type is not null then
535: --
536: -- check if value of lookup falls within lookup type.
534: and p_message_type is not null then
535: --
536: -- check if value of lookup falls within lookup type.
537: --
538: if hr_api.not_exists_in_hr_lookups
539: (p_lookup_type => 'BEN_MESSAGE_TYP',
540: p_lookup_code => p_message_type,
541: p_effective_date => p_effective_date) then
542: --
667: (p_pop_up_messages_id => p_pop_up_messages_id,
668: p_object_version_number => p_object_version_number);
669: --
670: if (l_api_updating
671: and nvl(p_pop_name,hr_api.g_varchar2)
672: <> ben_pum_shd.g_old_rec.pop_name
673: or not l_api_updating) then
674: --
675: -- Check if pop name is unique.
710: --
711: -- Call all supporting business operations
712: --
713: --
714: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
715: --
716: chk_pop_up_messages_id
717: (p_pop_up_messages_id => p_rec.pop_up_messages_id,
718: p_object_version_number => p_rec.object_version_number);
804: --
805: -- Call all supporting business operations
806: --
807: --
808: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
809: --
810: chk_pop_up_messages_id
811: (p_pop_up_messages_id => p_rec.pop_up_messages_id,
812: p_object_version_number => p_rec.object_version_number);
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,
933: p_argument => 'pop_up_messages_id',
934: p_argument_value => p_pop_up_messages_id);
935: --
936: open csr_leg_code;