DBA Data[Home] [Help]

APPS.BEN_XER_BUS dependencies on HR_API

Line 39: hr_api.mandatory_arg_error

35: hr_utility.set_location('Entering:'|| l_proc, 10);
36: --
37: -- Ensure that all the mandatory parameter are not null
38: --
39: hr_api.mandatory_arg_error
40: (p_api_name => l_proc
41: ,p_argument => 'ext_data_elmt_in_rcd_id'
42: ,p_argument_value => p_ext_data_elmt_in_rcd_id
43: );

Line 62: hr_api.set_security_group_id

58: close csr_sec_grp;
59: --
60: -- Set the security_group_id in CLIENT_INFO
61: --
62: hr_api.set_security_group_id
63: (p_security_group_id => l_security_group_id
64: );
65: --
66: hr_utility.set_location(' Leaving:'|| l_proc, 20);

Line 112: and nvl(p_ext_data_elmt_in_rcd_id,hr_api.g_number)

108: (p_ext_data_elmt_in_rcd_id => p_ext_data_elmt_in_rcd_id,
109: p_object_version_number => p_object_version_number);
110: --
111: if (l_api_updating
112: and nvl(p_ext_data_elmt_in_rcd_id,hr_api.g_number)
113: <> ben_xer_shd.g_old_rec.ext_data_elmt_in_rcd_id) then
114: --
115: -- raise error as PK has changed
116: --

Line 184: and nvl(p_ext_rcd_id,hr_api.g_number)

180: (p_ext_data_elmt_in_rcd_id => p_ext_data_elmt_in_rcd_id,
181: p_object_version_number => p_object_version_number);
182: --
183: if (l_api_updating
184: and nvl(p_ext_rcd_id,hr_api.g_number)
185: <> nvl(ben_xer_shd.g_old_rec.ext_rcd_id,hr_api.g_number)
186: or not l_api_updating) then
187: --
188: -- check if ext_rcd_id value exists in ben_ext_rcd table

Line 185: <> nvl(ben_xer_shd.g_old_rec.ext_rcd_id,hr_api.g_number)

181: p_object_version_number => p_object_version_number);
182: --
183: if (l_api_updating
184: and nvl(p_ext_rcd_id,hr_api.g_number)
185: <> nvl(ben_xer_shd.g_old_rec.ext_rcd_id,hr_api.g_number)
186: or not l_api_updating) then
187: --
188: -- check if ext_rcd_id value exists in ben_ext_rcd table
189: --

Line 259: and nvl(p_ext_data_elmt_id,hr_api.g_number)

255: (p_ext_data_elmt_in_rcd_id => p_ext_data_elmt_in_rcd_id,
256: p_object_version_number => p_object_version_number);
257: --
258: if (l_api_updating
259: and nvl(p_ext_data_elmt_id,hr_api.g_number)
260: <> nvl(ben_xer_shd.g_old_rec.ext_data_elmt_id,hr_api.g_number)
261: or not l_api_updating) then
262: --
263: -- check if ext_data_elmt_id value exists in ben_ext_data_elmt table

Line 260: <> nvl(ben_xer_shd.g_old_rec.ext_data_elmt_id,hr_api.g_number)

256: p_object_version_number => p_object_version_number);
257: --
258: if (l_api_updating
259: and nvl(p_ext_data_elmt_id,hr_api.g_number)
260: <> nvl(ben_xer_shd.g_old_rec.ext_data_elmt_id,hr_api.g_number)
261: or not l_api_updating) then
262: --
263: -- check if ext_data_elmt_id value exists in ben_ext_data_elmt table
264: --

Line 497: <> nvl(ben_xer_shd.g_old_rec.sprs_cd,hr_api.g_varchar2)

493: p_object_version_number => p_object_version_number);
494: --
495: if (l_api_updating
496: and p_sprs_cd
497: <> nvl(ben_xer_shd.g_old_rec.sprs_cd,hr_api.g_varchar2)
498: or not l_api_updating)
499: and p_sprs_cd is not null then
500: --
501: -- check if value of lookup falls within lookup type.

Line 504: if hr_api.not_exists_in_hr_lookups

500: --
501: -- check if value of lookup falls within lookup type.
502: --
503: if p_business_group_id is not null then
504: if hr_api.not_exists_in_hr_lookups
505: (p_lookup_type => 'BEN_EXT_SPRS',
506: p_lookup_code => p_sprs_cd,
507: p_effective_date => p_effective_date) then
508: --

Line 519: if hr_api.not_exists_in_hrstanlookups

515: fnd_message.raise_error;
516: --
517: end if;
518: else
519: if hr_api.not_exists_in_hrstanlookups
520: (p_lookup_type => 'BEN_EXT_SPRS',
521: p_lookup_code => p_sprs_cd,
522: p_effective_date => p_effective_date) then
523: --

Line 588: <> nvl(ben_xer_shd.g_old_rec.rqd_flag,hr_api.g_varchar2)

584: p_object_version_number => p_object_version_number);
585: --
586: if (l_api_updating
587: and p_rqd_flag
588: <> nvl(ben_xer_shd.g_old_rec.rqd_flag,hr_api.g_varchar2)
589: or not l_api_updating) then
590: --
591: -- check if value of lookup falls within lookup type.
592: --

Line 595: if hr_api.not_exists_in_hr_lookups

591: -- check if value of lookup falls within lookup type.
592: --
593: --
594: if p_business_group_id is not null then
595: if hr_api.not_exists_in_hr_lookups
596: (p_lookup_type => 'YES_NO',
597: p_lookup_code => p_rqd_flag,
598: p_effective_date => p_effective_date) then
599: --

Line 610: if hr_api.not_exists_in_hrstanlookups

606: fnd_message.raise_error;
607: --
608: end if;
609: else
610: if hr_api.not_exists_in_hrstanlookups
611: (p_lookup_type => 'YES_NO',
612: p_lookup_code => p_rqd_flag,
613: p_effective_date => p_effective_date) then
614: --

Line 678: <> nvl(ben_xer_shd.g_old_rec.any_or_all_cd,hr_api.g_varchar2)

674: p_object_version_number => p_object_version_number);
675: --
676: if (l_api_updating
677: and p_any_or_all_cd
678: <> nvl(ben_xer_shd.g_old_rec.any_or_all_cd,hr_api.g_varchar2)
679: or not l_api_updating)
680: and p_any_or_all_cd is not null then
681: --
682: -- check if value of lookup falls within lookup type.

Line 685: if hr_api.not_exists_in_hr_lookups

681: --
682: -- check if value of lookup falls within lookup type.
683: --
684: if p_business_group_id is not null then
685: if hr_api.not_exists_in_hr_lookups
686: (p_lookup_type => 'BEN_EXT_ANY_OR_ALL',
687: p_lookup_code => p_any_or_all_cd,
688: p_effective_date => p_effective_date) then
689: --

Line 699: if hr_api.not_exists_in_hrstanlookups

695: fnd_message.raise_error;
696: --
697: end if;
698: else
699: if hr_api.not_exists_in_hrstanlookups
700: (p_lookup_type => 'BEN_EXT_ANY_OR_ALL',
701: p_lookup_code => p_any_or_all_cd,
702: p_effective_date => p_effective_date) then
703: --

Line 766: <> nvl(ben_xer_shd.g_old_rec.hide_flag,hr_api.g_varchar2)

762: p_object_version_number => p_object_version_number);
763: --
764: if (l_api_updating
765: and p_hide_flag
766: <> nvl(ben_xer_shd.g_old_rec.hide_flag,hr_api.g_varchar2)
767: or not l_api_updating) then
768: --
769: -- check if value of lookup falls within lookup type.
770: --

Line 773: if hr_api.not_exists_in_hr_lookups

769: -- check if value of lookup falls within lookup type.
770: --
771: --
772: if p_business_group_id is not null then
773: if hr_api.not_exists_in_hr_lookups
774: (p_lookup_type => 'YES_NO',
775: p_lookup_code => p_hide_flag,
776: p_effective_date => p_effective_date) then
777: --

Line 787: if hr_api.not_exists_in_hrstanlookups

783: fnd_message.raise_error;
784: --
785: end if;
786: else
787: if hr_api.not_exists_in_hrstanlookups
788: (p_lookup_type => 'YES_NO',
789: p_lookup_code => p_hide_flag,
790: p_effective_date => p_effective_date) then
791: --

Line 906: <> nvl(ben_xer_shd.g_old_rec.ext_data_elmt_id,hr_api.g_number)

902: p_object_version_number => p_object_version_number);
903: --
904: if (l_api_updating
905: and p_ext_data_elmt_id
906: <> nvl(ben_xer_shd.g_old_rec.ext_data_elmt_id,hr_api.g_number)
907: or not l_api_updating)
908: and p_ext_data_elmt_id is not null then
909: --
910: open c1;

Line 1121: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate bus_grp

1117: chk_startup_action(True
1118: ,p_rec.business_group_id
1119: ,p_rec.legislation_code);
1120: IF hr_startup_data_api_support.g_startup_mode NOT IN ('GENERIC','STARTUP') THEN
1121: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate bus_grp
1122: END IF;
1123: --
1124: chk_ext_data_elmt_in_rcd_id
1125: (p_ext_data_elmt_in_rcd_id => p_rec.ext_data_elmt_in_rcd_id,

Line 1211: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate bus_grp

1207: chk_startup_action(False
1208: ,p_rec.business_group_id
1209: ,p_rec.legislation_code);
1210: IF hr_startup_data_api_support.g_startup_mode NOT IN ('GENERIC','STARTUP') THEN
1211: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate bus_grp
1212: END IF;
1213: --
1214: chk_ext_data_elmt_in_rcd_id
1215: (p_ext_data_elmt_in_rcd_id => p_rec.ext_data_elmt_in_rcd_id,

Line 1334: hr_api.mandatory_arg_error(p_api_name => l_proc,

1330: hr_utility.set_location('Entering:'|| l_proc, 10);
1331: --
1332: -- Ensure that all the mandatory parameter are not null
1333: --
1334: hr_api.mandatory_arg_error(p_api_name => l_proc,
1335: p_argument => 'ext_data_elmt_in_rcd_id',
1336: p_argument_value => p_ext_data_elmt_in_rcd_id);
1337: --
1338: open csr_leg_code;