DBA Data[Home] [Help]

APPS.BEN_EXT_CRIT_CMBN_API dependencies on HR_API

Line 60: when hr_api.cannot_find_prog_unit then

56: ,p_legislation_code => p_legislation_code
57: ,p_effective_date => trunc(p_effective_date)
58: );
59: exception
60: when hr_api.cannot_find_prog_unit then
61: hr_api.cannot_find_prog_unit_error
62: (
63: p_module_name => 'CREATE_EXT_CRIT_CMBN'
64: ,p_hook_type => 'BP'

Line 61: hr_api.cannot_find_prog_unit_error

57: ,p_effective_date => trunc(p_effective_date)
58: );
59: exception
60: when hr_api.cannot_find_prog_unit then
61: hr_api.cannot_find_prog_unit_error
62: (
63: p_module_name => 'CREATE_EXT_CRIT_CMBN'
64: ,p_hook_type => 'BP'
65: );

Line 103: when hr_api.cannot_find_prog_unit then

99: ,p_object_version_number => l_object_version_number
100: ,p_effective_date => trunc(p_effective_date)
101: );
102: exception
103: when hr_api.cannot_find_prog_unit then
104: hr_api.cannot_find_prog_unit_error
105: (p_module_name => 'CREATE_EXT_CRIT_CMBN'
106: ,p_hook_type => 'AP'
107: );

Line 104: hr_api.cannot_find_prog_unit_error

100: ,p_effective_date => trunc(p_effective_date)
101: );
102: exception
103: when hr_api.cannot_find_prog_unit then
104: hr_api.cannot_find_prog_unit_error
105: (p_module_name => 'CREATE_EXT_CRIT_CMBN'
106: ,p_hook_type => 'AP'
107: );
108: --

Line 118: raise hr_api.validate_enabled;

114: --
115: -- When in validation only mode raise the Validate_Enabled exception
116: --
117: if p_validate then
118: raise hr_api.validate_enabled;
119: end if;
120: --
121: -- Set all output arguments
122: --

Line 130: when hr_api.validate_enabled then

126: hr_utility.set_location(' Leaving:'||l_proc, 70);
127: --
128: exception
129: --
130: when hr_api.validate_enabled then
131: --
132: -- As the Validate_Enabled exception has been raised
133: -- we must rollback to the savepoint
134: --

Line 163: ,p_crit_typ_cd in varchar2 default hr_api.g_varchar2

159: --
160: procedure update_EXT_CRIT_CMBN
161: (p_validate in boolean default false
162: ,p_ext_crit_cmbn_id in number
163: ,p_crit_typ_cd in varchar2 default hr_api.g_varchar2
164: ,p_oper_cd in varchar2 default hr_api.g_varchar2
165: ,p_val_1 in varchar2 default hr_api.g_varchar2
166: ,p_val_2 in varchar2 default hr_api.g_varchar2
167: ,p_ext_crit_val_id in number default hr_api.g_number

Line 164: ,p_oper_cd in varchar2 default hr_api.g_varchar2

160: procedure update_EXT_CRIT_CMBN
161: (p_validate in boolean default false
162: ,p_ext_crit_cmbn_id in number
163: ,p_crit_typ_cd in varchar2 default hr_api.g_varchar2
164: ,p_oper_cd in varchar2 default hr_api.g_varchar2
165: ,p_val_1 in varchar2 default hr_api.g_varchar2
166: ,p_val_2 in varchar2 default hr_api.g_varchar2
167: ,p_ext_crit_val_id in number default hr_api.g_number
168: ,p_business_group_id in number default hr_api.g_number

Line 165: ,p_val_1 in varchar2 default hr_api.g_varchar2

161: (p_validate in boolean default false
162: ,p_ext_crit_cmbn_id in number
163: ,p_crit_typ_cd in varchar2 default hr_api.g_varchar2
164: ,p_oper_cd in varchar2 default hr_api.g_varchar2
165: ,p_val_1 in varchar2 default hr_api.g_varchar2
166: ,p_val_2 in varchar2 default hr_api.g_varchar2
167: ,p_ext_crit_val_id in number default hr_api.g_number
168: ,p_business_group_id in number default hr_api.g_number
169: ,p_legislation_code in varchar2 default hr_api.g_varchar2

Line 166: ,p_val_2 in varchar2 default hr_api.g_varchar2

162: ,p_ext_crit_cmbn_id in number
163: ,p_crit_typ_cd in varchar2 default hr_api.g_varchar2
164: ,p_oper_cd in varchar2 default hr_api.g_varchar2
165: ,p_val_1 in varchar2 default hr_api.g_varchar2
166: ,p_val_2 in varchar2 default hr_api.g_varchar2
167: ,p_ext_crit_val_id in number default hr_api.g_number
168: ,p_business_group_id in number default hr_api.g_number
169: ,p_legislation_code in varchar2 default hr_api.g_varchar2
170: ,p_object_version_number in out nocopy number

Line 167: ,p_ext_crit_val_id in number default hr_api.g_number

163: ,p_crit_typ_cd in varchar2 default hr_api.g_varchar2
164: ,p_oper_cd in varchar2 default hr_api.g_varchar2
165: ,p_val_1 in varchar2 default hr_api.g_varchar2
166: ,p_val_2 in varchar2 default hr_api.g_varchar2
167: ,p_ext_crit_val_id in number default hr_api.g_number
168: ,p_business_group_id in number default hr_api.g_number
169: ,p_legislation_code in varchar2 default hr_api.g_varchar2
170: ,p_object_version_number in out nocopy number
171: ,p_effective_date in date

Line 168: ,p_business_group_id in number default hr_api.g_number

164: ,p_oper_cd in varchar2 default hr_api.g_varchar2
165: ,p_val_1 in varchar2 default hr_api.g_varchar2
166: ,p_val_2 in varchar2 default hr_api.g_varchar2
167: ,p_ext_crit_val_id in number default hr_api.g_number
168: ,p_business_group_id in number default hr_api.g_number
169: ,p_legislation_code in varchar2 default hr_api.g_varchar2
170: ,p_object_version_number in out nocopy number
171: ,p_effective_date in date
172: ) is

Line 169: ,p_legislation_code in varchar2 default hr_api.g_varchar2

165: ,p_val_1 in varchar2 default hr_api.g_varchar2
166: ,p_val_2 in varchar2 default hr_api.g_varchar2
167: ,p_ext_crit_val_id in number default hr_api.g_number
168: ,p_business_group_id in number default hr_api.g_number
169: ,p_legislation_code in varchar2 default hr_api.g_varchar2
170: ,p_object_version_number in out nocopy number
171: ,p_effective_date in date
172: ) is
173: --

Line 211: when hr_api.cannot_find_prog_unit then

207: ,p_object_version_number => p_object_version_number
208: ,p_effective_date => trunc(p_effective_date)
209: );
210: exception
211: when hr_api.cannot_find_prog_unit then
212: hr_api.cannot_find_prog_unit_error
213: (p_module_name => 'UPDATE_EXT_CRIT_CMBN'
214: ,p_hook_type => 'BP'
215: );

Line 212: hr_api.cannot_find_prog_unit_error

208: ,p_effective_date => trunc(p_effective_date)
209: );
210: exception
211: when hr_api.cannot_find_prog_unit then
212: hr_api.cannot_find_prog_unit_error
213: (p_module_name => 'UPDATE_EXT_CRIT_CMBN'
214: ,p_hook_type => 'BP'
215: );
216: --

Line 253: when hr_api.cannot_find_prog_unit then

249: ,p_object_version_number => l_object_version_number
250: ,p_effective_date => trunc(p_effective_date)
251: );
252: exception
253: when hr_api.cannot_find_prog_unit then
254: hr_api.cannot_find_prog_unit_error
255: (p_module_name => 'UPDATE_EXT_CRIT_CMBN'
256: ,p_hook_type => 'AP'
257: );

Line 254: hr_api.cannot_find_prog_unit_error

250: ,p_effective_date => trunc(p_effective_date)
251: );
252: exception
253: when hr_api.cannot_find_prog_unit then
254: hr_api.cannot_find_prog_unit_error
255: (p_module_name => 'UPDATE_EXT_CRIT_CMBN'
256: ,p_hook_type => 'AP'
257: );
258: --

Line 268: raise hr_api.validate_enabled;

264: --
265: -- When in validation only mode raise the Validate_Enabled exception
266: --
267: if p_validate then
268: raise hr_api.validate_enabled;
269: end if;
270: --
271: -- Set all output arguments
272: --

Line 279: when hr_api.validate_enabled then

275: hr_utility.set_location(' Leaving:'||l_proc, 70);
276: --
277: exception
278: --
279: when hr_api.validate_enabled then
280: --
281: -- As the Validate_Enabled exception has been raised
282: -- we must rollback to the savepoint
283: --

Line 346: when hr_api.cannot_find_prog_unit then

342: ,p_object_version_number => p_object_version_number
343: ,p_effective_date => trunc(p_effective_date)
344: );
345: exception
346: when hr_api.cannot_find_prog_unit then
347: hr_api.cannot_find_prog_unit_error
348: (p_module_name => 'DELETE_EXT_CRIT_CMBN'
349: ,p_hook_type => 'BP'
350: );

Line 347: hr_api.cannot_find_prog_unit_error

343: ,p_effective_date => trunc(p_effective_date)
344: );
345: exception
346: when hr_api.cannot_find_prog_unit then
347: hr_api.cannot_find_prog_unit_error
348: (p_module_name => 'DELETE_EXT_CRIT_CMBN'
349: ,p_hook_type => 'BP'
350: );
351: --

Line 376: when hr_api.cannot_find_prog_unit then

372: ,p_object_version_number => l_object_version_number
373: ,p_effective_date => trunc(p_effective_date)
374: );
375: exception
376: when hr_api.cannot_find_prog_unit then
377: hr_api.cannot_find_prog_unit_error
378: (p_module_name => 'DELETE_EXT_CRIT_CMBN'
379: ,p_hook_type => 'AP'
380: );

Line 377: hr_api.cannot_find_prog_unit_error

373: ,p_effective_date => trunc(p_effective_date)
374: );
375: exception
376: when hr_api.cannot_find_prog_unit then
377: hr_api.cannot_find_prog_unit_error
378: (p_module_name => 'DELETE_EXT_CRIT_CMBN'
379: ,p_hook_type => 'AP'
380: );
381: --

Line 391: raise hr_api.validate_enabled;

387: --
388: -- When in validation only mode raise the Validate_Enabled exception
389: --
390: if p_validate then
391: raise hr_api.validate_enabled;
392: end if;
393: --
394: hr_utility.set_location(' Leaving:'||l_proc, 70);
395: --

Line 398: when hr_api.validate_enabled then

394: hr_utility.set_location(' Leaving:'||l_proc, 70);
395: --
396: exception
397: --
398: when hr_api.validate_enabled then
399: --
400: -- As the Validate_Enabled exception has been raised
401: -- we must rollback to the savepoint
402: --