DBA Data[Home] [Help]

APPS.GHR_COMPL_AGENCY_COSTS_API dependencies on HR_API

Line 59: when hr_api.cannot_find_prog_unit then

55: ,p_cost_date => p_cost_date
56: ,p_description => p_description
57: );
58: exception
59: when hr_api.cannot_find_prog_unit then
60: hr_api.cannot_find_prog_unit_error
61: (p_module_name => 'CREATE_AGENCY_COSTS'
62: ,p_hook_type => 'BP'
63: );

Line 60: hr_api.cannot_find_prog_unit_error

56: ,p_description => p_description
57: );
58: exception
59: when hr_api.cannot_find_prog_unit then
60: hr_api.cannot_find_prog_unit_error
61: (p_module_name => 'CREATE_AGENCY_COSTS'
62: ,p_hook_type => 'BP'
63: );
64: end;

Line 106: when hr_api.cannot_find_prog_unit then

102: ,p_compl_agency_cost_id => l_compl_agency_cost_id
103: ,p_object_version_number => l_object_version_number
104: );
105: exception
106: when hr_api.cannot_find_prog_unit then
107: hr_api.cannot_find_prog_unit_error
108: (p_module_name => 'CREATE_AGENCY_COSTS'
109: ,p_hook_type => 'AP'
110: );

Line 107: hr_api.cannot_find_prog_unit_error

103: ,p_object_version_number => l_object_version_number
104: );
105: exception
106: when hr_api.cannot_find_prog_unit then
107: hr_api.cannot_find_prog_unit_error
108: (p_module_name => 'CREATE_AGENCY_COSTS'
109: ,p_hook_type => 'AP'
110: );
111: end;

Line 116: raise hr_api.validate_enabled;

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

Line 126: when hr_api.validate_enabled then

122: p_object_version_number := l_object_version_number;
123: --
124: hr_utility.set_location(' Leaving:'||l_proc, 70);
125: exception
126: when hr_api.validate_enabled then
127: --
128: -- As the Validate_Enabled exception has been raised
129: -- we must rollback to the savepoint
130: --

Line 160: ,p_complaint_id in number default hr_api.g_number

156: procedure update_agency_costs
157: (p_validate in boolean default false
158: ,p_effective_date in date
159: ,p_compl_agency_cost_id in number
160: ,p_complaint_id in number default hr_api.g_number
161: ,p_phase in varchar2 default hr_api.g_varchar2
162: ,p_stage in varchar2 default hr_api.g_varchar2
163: ,p_category in varchar2 default hr_api.g_varchar2
164: ,p_amount in number default hr_api.g_number

Line 161: ,p_phase in varchar2 default hr_api.g_varchar2

157: (p_validate in boolean default false
158: ,p_effective_date in date
159: ,p_compl_agency_cost_id in number
160: ,p_complaint_id in number default hr_api.g_number
161: ,p_phase in varchar2 default hr_api.g_varchar2
162: ,p_stage in varchar2 default hr_api.g_varchar2
163: ,p_category in varchar2 default hr_api.g_varchar2
164: ,p_amount in number default hr_api.g_number
165: ,p_cost_date in date default hr_api.g_date

Line 162: ,p_stage in varchar2 default hr_api.g_varchar2

158: ,p_effective_date in date
159: ,p_compl_agency_cost_id in number
160: ,p_complaint_id in number default hr_api.g_number
161: ,p_phase in varchar2 default hr_api.g_varchar2
162: ,p_stage in varchar2 default hr_api.g_varchar2
163: ,p_category in varchar2 default hr_api.g_varchar2
164: ,p_amount in number default hr_api.g_number
165: ,p_cost_date in date default hr_api.g_date
166: ,p_description in varchar2 default hr_api.g_varchar2

Line 163: ,p_category in varchar2 default hr_api.g_varchar2

159: ,p_compl_agency_cost_id in number
160: ,p_complaint_id in number default hr_api.g_number
161: ,p_phase in varchar2 default hr_api.g_varchar2
162: ,p_stage in varchar2 default hr_api.g_varchar2
163: ,p_category in varchar2 default hr_api.g_varchar2
164: ,p_amount in number default hr_api.g_number
165: ,p_cost_date in date default hr_api.g_date
166: ,p_description in varchar2 default hr_api.g_varchar2
167: ,p_object_version_number in out nocopy number

Line 164: ,p_amount in number default hr_api.g_number

160: ,p_complaint_id in number default hr_api.g_number
161: ,p_phase in varchar2 default hr_api.g_varchar2
162: ,p_stage in varchar2 default hr_api.g_varchar2
163: ,p_category in varchar2 default hr_api.g_varchar2
164: ,p_amount in number default hr_api.g_number
165: ,p_cost_date in date default hr_api.g_date
166: ,p_description in varchar2 default hr_api.g_varchar2
167: ,p_object_version_number in out nocopy number
168: )

Line 165: ,p_cost_date in date default hr_api.g_date

161: ,p_phase in varchar2 default hr_api.g_varchar2
162: ,p_stage in varchar2 default hr_api.g_varchar2
163: ,p_category in varchar2 default hr_api.g_varchar2
164: ,p_amount in number default hr_api.g_number
165: ,p_cost_date in date default hr_api.g_date
166: ,p_description in varchar2 default hr_api.g_varchar2
167: ,p_object_version_number in out nocopy number
168: )
169:

Line 166: ,p_description in varchar2 default hr_api.g_varchar2

162: ,p_stage in varchar2 default hr_api.g_varchar2
163: ,p_category in varchar2 default hr_api.g_varchar2
164: ,p_amount in number default hr_api.g_number
165: ,p_cost_date in date default hr_api.g_date
166: ,p_description in varchar2 default hr_api.g_varchar2
167: ,p_object_version_number in out nocopy number
168: )
169:
170: is

Line 203: when hr_api.cannot_find_prog_unit then

199: ,p_compl_agency_cost_id => p_compl_agency_cost_id
200: ,p_object_version_number => p_object_version_number
201: );
202: exception
203: when hr_api.cannot_find_prog_unit then
204: hr_api.cannot_find_prog_unit_error
205: (p_module_name => 'UPDATE_AGENCY_COSTS'
206: ,p_hook_type => 'BP'
207: );

Line 204: hr_api.cannot_find_prog_unit_error

200: ,p_object_version_number => p_object_version_number
201: );
202: exception
203: when hr_api.cannot_find_prog_unit then
204: hr_api.cannot_find_prog_unit_error
205: (p_module_name => 'UPDATE_AGENCY_COSTS'
206: ,p_hook_type => 'BP'
207: );
208: end;

Line 247: when hr_api.cannot_find_prog_unit then

243: ,p_compl_agency_cost_id => p_compl_agency_cost_id
244: ,p_object_version_number => l_object_version_number
245: );
246: exception
247: when hr_api.cannot_find_prog_unit then
248: hr_api.cannot_find_prog_unit_error
249: (p_module_name => 'UPDATE_AGENCY_COSTS'
250: ,p_hook_type => 'AP'
251: );

Line 248: hr_api.cannot_find_prog_unit_error

244: ,p_object_version_number => l_object_version_number
245: );
246: exception
247: when hr_api.cannot_find_prog_unit then
248: hr_api.cannot_find_prog_unit_error
249: (p_module_name => 'UPDATE_AGENCY_COSTS'
250: ,p_hook_type => 'AP'
251: );
252: end;

Line 257: raise hr_api.validate_enabled;

253: --
254: -- When in validation only mode raise the Validate_Enabled exception
255: --
256: if p_validate then
257: raise hr_api.validate_enabled;
258: end if;
259: --
260: -- Set all output arguments
261: --

Line 266: when hr_api.validate_enabled then

262: p_object_version_number := l_object_version_number;
263: --
264: hr_utility.set_location(' Leaving:'||l_proc, 70);
265: exception
266: when hr_api.validate_enabled then
267: --
268: -- As the Validate_Enabled exception has been raised
269: -- we must rollback to the savepoint
270: --

Line 326: when hr_api.cannot_find_prog_unit then

322: (p_compl_agency_cost_id => p_compl_agency_cost_id
323: ,p_object_version_number => p_object_version_number
324: );
325: exception
326: when hr_api.cannot_find_prog_unit then
327: hr_api.cannot_find_prog_unit_error
328: (p_module_name => 'DELETE_AGENCY_COSTS'
329: ,p_hook_type => 'BP'
330: );

Line 327: hr_api.cannot_find_prog_unit_error

323: ,p_object_version_number => p_object_version_number
324: );
325: exception
326: when hr_api.cannot_find_prog_unit then
327: hr_api.cannot_find_prog_unit_error
328: (p_module_name => 'DELETE_AGENCY_COSTS'
329: ,p_hook_type => 'BP'
330: );
331: end;

Line 351: when hr_api.cannot_find_prog_unit then

347: (p_compl_agency_cost_id => p_compl_agency_cost_id
348: ,p_object_version_number => p_object_version_number
349: );
350: exception
351: when hr_api.cannot_find_prog_unit then
352: hr_api.cannot_find_prog_unit_error
353: (p_module_name => 'DELETE_AGENCY_COSTS'
354: ,p_hook_type => 'AP'
355: );

Line 352: hr_api.cannot_find_prog_unit_error

348: ,p_object_version_number => p_object_version_number
349: );
350: exception
351: when hr_api.cannot_find_prog_unit then
352: hr_api.cannot_find_prog_unit_error
353: (p_module_name => 'DELETE_AGENCY_COSTS'
354: ,p_hook_type => 'AP'
355: );
356: end;

Line 361: raise hr_api.validate_enabled;

357: --
358: -- When in validation only mode raise the Validate_Enabled exception
359: --
360: if p_validate then
361: raise hr_api.validate_enabled;
362: end if;
363: --
364: hr_utility.set_location(' Leaving:'||l_proc, 11);
365: exception

Line 366: when hr_api.validate_enabled then

362: end if;
363: --
364: hr_utility.set_location(' Leaving:'||l_proc, 11);
365: exception
366: when hr_api.validate_enabled then
367: -- we must rollback to the savepoint
368: --
369: ROLLBACK TO delete_agency_costs;
370: --