DBA Data[Home] [Help]

APPS.GHR_NOAC_REMARKS_API dependencies on HR_API

Line 68: when hr_api.cannot_find_prog_unit then

64: ,p_date_to => p_date_to
65: ,p_effective_date => trunc(p_effective_date)
66: );
67: exception
68: when hr_api.cannot_find_prog_unit then
69: hr_api.cannot_find_prog_unit_error
70: (
71: p_module_name => 'CREATE_noac_remarks'
72: ,p_hook_type => 'BP'

Line 69: hr_api.cannot_find_prog_unit_error

65: ,p_effective_date => trunc(p_effective_date)
66: );
67: exception
68: when hr_api.cannot_find_prog_unit then
69: hr_api.cannot_find_prog_unit_error
70: (
71: p_module_name => 'CREATE_noac_remarks'
72: ,p_hook_type => 'BP'
73: );

Line 109: when hr_api.cannot_find_prog_unit then

105: ,p_object_version_number => l_object_version_number
106: ,p_effective_date => trunc(p_effective_date)
107: );
108: exception
109: when hr_api.cannot_find_prog_unit then
110: hr_api.cannot_find_prog_unit_error
111: (p_module_name => 'CREATE_noac_remarks'
112: ,p_hook_type => 'AP'
113: );

Line 110: hr_api.cannot_find_prog_unit_error

106: ,p_effective_date => trunc(p_effective_date)
107: );
108: exception
109: when hr_api.cannot_find_prog_unit then
110: hr_api.cannot_find_prog_unit_error
111: (p_module_name => 'CREATE_noac_remarks'
112: ,p_hook_type => 'AP'
113: );
114: --

Line 124: raise hr_api.validate_enabled;

120: --
121: -- When in validation only mode raise the Validate_Enabled exception
122: --
123: if p_validate then
124: raise hr_api.validate_enabled;
125: end if;
126: --
127: -- Set all output arguments
128: --

Line 136: when hr_api.validate_enabled then

132: hr_utility.set_location(' Leaving:'||l_proc, 70);
133: --
134: exception
135: --
136: when hr_api.validate_enabled then
137: --
138: -- As the Validate_Enabled exception has been raised
139: -- we must rollback to the savepoint
140: --

Line 168: ,p_nature_of_action_id in number default hr_api.g_number

164: --
165: procedure update_noac_remarks
166: (p_validate in boolean default false
167: ,p_noac_remark_id in number
168: ,p_nature_of_action_id in number default hr_api.g_number
169: ,p_remark_id in number default hr_api.g_number
170: ,p_required_flag in varchar2 default hr_api.g_varchar2
171: ,p_enabled_flag in varchar2 default hr_api.g_varchar2
172: ,p_date_from in date default hr_api.g_date

Line 169: ,p_remark_id in number default hr_api.g_number

165: procedure update_noac_remarks
166: (p_validate in boolean default false
167: ,p_noac_remark_id in number
168: ,p_nature_of_action_id in number default hr_api.g_number
169: ,p_remark_id in number default hr_api.g_number
170: ,p_required_flag in varchar2 default hr_api.g_varchar2
171: ,p_enabled_flag in varchar2 default hr_api.g_varchar2
172: ,p_date_from in date default hr_api.g_date
173: ,p_date_to in date default hr_api.g_date

Line 170: ,p_required_flag in varchar2 default hr_api.g_varchar2

166: (p_validate in boolean default false
167: ,p_noac_remark_id in number
168: ,p_nature_of_action_id in number default hr_api.g_number
169: ,p_remark_id in number default hr_api.g_number
170: ,p_required_flag in varchar2 default hr_api.g_varchar2
171: ,p_enabled_flag in varchar2 default hr_api.g_varchar2
172: ,p_date_from in date default hr_api.g_date
173: ,p_date_to in date default hr_api.g_date
174: ,p_object_version_number in out NOCOPY number

Line 171: ,p_enabled_flag in varchar2 default hr_api.g_varchar2

167: ,p_noac_remark_id in number
168: ,p_nature_of_action_id in number default hr_api.g_number
169: ,p_remark_id in number default hr_api.g_number
170: ,p_required_flag in varchar2 default hr_api.g_varchar2
171: ,p_enabled_flag in varchar2 default hr_api.g_varchar2
172: ,p_date_from in date default hr_api.g_date
173: ,p_date_to in date default hr_api.g_date
174: ,p_object_version_number in out NOCOPY number
175: ,p_effective_date in date

Line 172: ,p_date_from in date default hr_api.g_date

168: ,p_nature_of_action_id in number default hr_api.g_number
169: ,p_remark_id in number default hr_api.g_number
170: ,p_required_flag in varchar2 default hr_api.g_varchar2
171: ,p_enabled_flag in varchar2 default hr_api.g_varchar2
172: ,p_date_from in date default hr_api.g_date
173: ,p_date_to in date default hr_api.g_date
174: ,p_object_version_number in out NOCOPY number
175: ,p_effective_date in date
176: ) is

Line 173: ,p_date_to in date default hr_api.g_date

169: ,p_remark_id in number default hr_api.g_number
170: ,p_required_flag in varchar2 default hr_api.g_varchar2
171: ,p_enabled_flag in varchar2 default hr_api.g_varchar2
172: ,p_date_from in date default hr_api.g_date
173: ,p_date_to in date default hr_api.g_date
174: ,p_object_version_number in out NOCOPY number
175: ,p_effective_date in date
176: ) is
177: --

Line 227: when hr_api.cannot_find_prog_unit then

223: ,p_object_version_number => p_object_version_number
224: ,p_effective_date => trunc(p_effective_date)
225: );
226: exception
227: when hr_api.cannot_find_prog_unit then
228: p_object_version_number := l_obj_version_number;
229: hr_api.cannot_find_prog_unit_error
230: (p_module_name => 'UPDATE_noac_remarks'
231: ,p_hook_type => 'BP'

Line 229: hr_api.cannot_find_prog_unit_error

225: );
226: exception
227: when hr_api.cannot_find_prog_unit then
228: p_object_version_number := l_obj_version_number;
229: hr_api.cannot_find_prog_unit_error
230: (p_module_name => 'UPDATE_noac_remarks'
231: ,p_hook_type => 'BP'
232: );
233: --

Line 268: when hr_api.cannot_find_prog_unit then

264: ,p_object_version_number => l_object_version_number
265: ,p_effective_date => trunc(p_effective_date)
266: );
267: exception
268: when hr_api.cannot_find_prog_unit then
269: p_object_version_number := l_obj_version_number;
270: hr_api.cannot_find_prog_unit_error
271: (p_module_name => 'UPDATE_noac_remarks'
272: ,p_hook_type => 'AP'

Line 270: hr_api.cannot_find_prog_unit_error

266: );
267: exception
268: when hr_api.cannot_find_prog_unit then
269: p_object_version_number := l_obj_version_number;
270: hr_api.cannot_find_prog_unit_error
271: (p_module_name => 'UPDATE_noac_remarks'
272: ,p_hook_type => 'AP'
273: );
274: --

Line 284: raise hr_api.validate_enabled;

280: --
281: -- When in validation only mode raise the Validate_Enabled exception
282: --
283: if p_validate then
284: raise hr_api.validate_enabled;
285: end if;
286: --
287: -- Set all output arguments
288: --

Line 295: when hr_api.validate_enabled then

291: hr_utility.set_location(' Leaving:'||l_proc, 70);
292: --
293: exception
294: --
295: when hr_api.validate_enabled then
296: --
297: -- As the Validate_Enabled exception has been raised
298: -- we must rollback to the savepoint
299: --

Line 363: when hr_api.cannot_find_prog_unit then

359: ,p_object_version_number => p_object_version_number
360: ,p_effective_date => trunc(p_effective_date)
361: );
362: exception
363: when hr_api.cannot_find_prog_unit then
364: p_object_version_number := l_obj_version_number;
365: hr_api.cannot_find_prog_unit_error
366: (p_module_name => 'DELETE_noac_remarks'
367: ,p_hook_type => 'BP'

Line 365: hr_api.cannot_find_prog_unit_error

361: );
362: exception
363: when hr_api.cannot_find_prog_unit then
364: p_object_version_number := l_obj_version_number;
365: hr_api.cannot_find_prog_unit_error
366: (p_module_name => 'DELETE_noac_remarks'
367: ,p_hook_type => 'BP'
368: );
369: --

Line 392: when hr_api.cannot_find_prog_unit then

388: ,p_object_version_number => l_object_version_number
389: ,p_effective_date => trunc(p_effective_date)
390: );
391: exception
392: when hr_api.cannot_find_prog_unit then
393: p_object_version_number := l_obj_version_number;
394: hr_api.cannot_find_prog_unit_error
395: (p_module_name => 'DELETE_noac_remarks'
396: ,p_hook_type => 'AP'

Line 394: hr_api.cannot_find_prog_unit_error

390: );
391: exception
392: when hr_api.cannot_find_prog_unit then
393: p_object_version_number := l_obj_version_number;
394: hr_api.cannot_find_prog_unit_error
395: (p_module_name => 'DELETE_noac_remarks'
396: ,p_hook_type => 'AP'
397: );
398: --

Line 408: raise hr_api.validate_enabled;

404: --
405: -- When in validation only mode raise the Validate_Enabled exception
406: --
407: if p_validate then
408: raise hr_api.validate_enabled;
409: end if;
410: --
411: hr_utility.set_location(' Leaving:'||l_proc, 70);
412: --

Line 415: when hr_api.validate_enabled then

411: hr_utility.set_location(' Leaving:'||l_proc, 70);
412: --
413: exception
414: --
415: when hr_api.validate_enabled then
416: --
417: -- As the Validate_Enabled exception has been raised
418: -- we must rollback to the savepoint
419: --