APPS.GHR_COMPLAINANT_APPEALS_API dependencies on HR_API

Line 105: when hr_api.cannot_find_prog_unit then

101: ,p_agency_recvd_rfr_dec => p_agency_recvd_rfr_dec
102: ,p_rfr_decision_forwd_to_org => p_rfr_decision_forwd_to_org
103: );
104: exception
105: when hr_api.cannot_find_prog_unit then
106: hr_api.cannot_find_prog_unit_error
107: (p_module_name => 'create_complainant_appeal'
108: ,p_hook_type => 'BP'
109: );

Line 106: hr_api.cannot_find_prog_unit_error

102: ,p_rfr_decision_forwd_to_org => p_rfr_decision_forwd_to_org
103: );
104: exception
105: when hr_api.cannot_find_prog_unit then
106: hr_api.cannot_find_prog_unit_error
107: (p_module_name => 'create_complainant_appeal'
108: ,p_hook_type => 'BP'
109: );
110: end;

Line 200: when hr_api.cannot_find_prog_unit then

196: ,p_compl_appeal_id => l_compl_appeal_id
197: ,p_object_version_number => l_object_version_number
198: );
199: exception
200: when hr_api.cannot_find_prog_unit then
201: hr_api.cannot_find_prog_unit_error
202: (p_module_name => 'create_complainant_appeal'
203: ,p_hook_type => 'AP'
204: );

Line 201: hr_api.cannot_find_prog_unit_error

197: ,p_object_version_number => l_object_version_number
198: );
199: exception
200: when hr_api.cannot_find_prog_unit then
201: hr_api.cannot_find_prog_unit_error
202: (p_module_name => 'create_complainant_appeal'
203: ,p_hook_type => 'AP'
204: );
205: end;

Line 210: raise hr_api.validate_enabled;

206: --
207: -- When in validation only mode raise the Validate_Enabled exception
208: --
209: if p_validate then
210: raise hr_api.validate_enabled;
211: end if;
212: --
213: -- Set all output arguments
214: --

Line 220: when hr_api.validate_enabled then

216: p_object_version_number := l_object_version_number;
217: --
218: hr_utility.set_location(' Leaving:'||l_proc, 70);
219: exception
220: when hr_api.validate_enabled then
221: --
222: -- As the Validate_Enabled exception has been raised
223: -- we must rollback to the savepoint
224: --

Line 254: ,p_complaint_id in number default hr_api.g_number

250: (p_validate in boolean default false
251: ,p_effective_date in date
252: ,p_compl_appeal_id in number
253: ,p_object_version_number in out nocopy number
254: ,p_complaint_id in number default hr_api.g_number
255: ,p_appeal_date in date default hr_api.g_date
256: ,p_appealed_to in varchar2 default hr_api.g_varchar2
257: ,p_reason_for_appeal in varchar2 default hr_api.g_varchar2
258: ,p_source_decision_date in date default hr_api.g_date

Line 255: ,p_appeal_date in date default hr_api.g_date

251: ,p_effective_date in date
252: ,p_compl_appeal_id in number
253: ,p_object_version_number in out nocopy number
254: ,p_complaint_id in number default hr_api.g_number
255: ,p_appeal_date in date default hr_api.g_date
256: ,p_appealed_to in varchar2 default hr_api.g_varchar2
257: ,p_reason_for_appeal in varchar2 default hr_api.g_varchar2
258: ,p_source_decision_date in date default hr_api.g_date
259: ,p_docket_num in varchar2 default hr_api.g_varchar2

Line 256: ,p_appealed_to in varchar2 default hr_api.g_varchar2

252: ,p_compl_appeal_id in number
253: ,p_object_version_number in out nocopy number
254: ,p_complaint_id in number default hr_api.g_number
255: ,p_appeal_date in date default hr_api.g_date
256: ,p_appealed_to in varchar2 default hr_api.g_varchar2
257: ,p_reason_for_appeal in varchar2 default hr_api.g_varchar2
258: ,p_source_decision_date in date default hr_api.g_date
259: ,p_docket_num in varchar2 default hr_api.g_varchar2
260: ,p_org_notified_of_appeal in date default hr_api.g_date

Line 257: ,p_reason_for_appeal in varchar2 default hr_api.g_varchar2

253: ,p_object_version_number in out nocopy number
254: ,p_complaint_id in number default hr_api.g_number
255: ,p_appeal_date in date default hr_api.g_date
256: ,p_appealed_to in varchar2 default hr_api.g_varchar2
257: ,p_reason_for_appeal in varchar2 default hr_api.g_varchar2
258: ,p_source_decision_date in date default hr_api.g_date
259: ,p_docket_num in varchar2 default hr_api.g_varchar2
260: ,p_org_notified_of_appeal in date default hr_api.g_date
261: ,p_agency_recvd_req_for_files in date default hr_api.g_date

Line 258: ,p_source_decision_date in date default hr_api.g_date

254: ,p_complaint_id in number default hr_api.g_number
255: ,p_appeal_date in date default hr_api.g_date
256: ,p_appealed_to in varchar2 default hr_api.g_varchar2
257: ,p_reason_for_appeal in varchar2 default hr_api.g_varchar2
258: ,p_source_decision_date in date default hr_api.g_date
259: ,p_docket_num in varchar2 default hr_api.g_varchar2
260: ,p_org_notified_of_appeal in date default hr_api.g_date
261: ,p_agency_recvd_req_for_files in date default hr_api.g_date
262: ,p_files_due in date default hr_api.g_date

Line 259: ,p_docket_num in varchar2 default hr_api.g_varchar2

255: ,p_appeal_date in date default hr_api.g_date
256: ,p_appealed_to in varchar2 default hr_api.g_varchar2
257: ,p_reason_for_appeal in varchar2 default hr_api.g_varchar2
258: ,p_source_decision_date in date default hr_api.g_date
259: ,p_docket_num in varchar2 default hr_api.g_varchar2
260: ,p_org_notified_of_appeal in date default hr_api.g_date
261: ,p_agency_recvd_req_for_files in date default hr_api.g_date
262: ,p_files_due in date default hr_api.g_date
263: ,p_files_forwd in date default hr_api.g_date

Line 260: ,p_org_notified_of_appeal in date default hr_api.g_date

256: ,p_appealed_to in varchar2 default hr_api.g_varchar2
257: ,p_reason_for_appeal in varchar2 default hr_api.g_varchar2
258: ,p_source_decision_date in date default hr_api.g_date
259: ,p_docket_num in varchar2 default hr_api.g_varchar2
260: ,p_org_notified_of_appeal in date default hr_api.g_date
261: ,p_agency_recvd_req_for_files in date default hr_api.g_date
262: ,p_files_due in date default hr_api.g_date
263: ,p_files_forwd in date default hr_api.g_date
264: ,p_agcy_recvd_appellant_brief in date default hr_api.g_date

Line 261: ,p_agency_recvd_req_for_files in date default hr_api.g_date

257: ,p_reason_for_appeal in varchar2 default hr_api.g_varchar2
258: ,p_source_decision_date in date default hr_api.g_date
259: ,p_docket_num in varchar2 default hr_api.g_varchar2
260: ,p_org_notified_of_appeal in date default hr_api.g_date
261: ,p_agency_recvd_req_for_files in date default hr_api.g_date
262: ,p_files_due in date default hr_api.g_date
263: ,p_files_forwd in date default hr_api.g_date
264: ,p_agcy_recvd_appellant_brief in date default hr_api.g_date
265: ,p_agency_brief_due in date default hr_api.g_date

Line 262: ,p_files_due in date default hr_api.g_date

258: ,p_source_decision_date in date default hr_api.g_date
259: ,p_docket_num in varchar2 default hr_api.g_varchar2
260: ,p_org_notified_of_appeal in date default hr_api.g_date
261: ,p_agency_recvd_req_for_files in date default hr_api.g_date
262: ,p_files_due in date default hr_api.g_date
263: ,p_files_forwd in date default hr_api.g_date
264: ,p_agcy_recvd_appellant_brief in date default hr_api.g_date
265: ,p_agency_brief_due in date default hr_api.g_date
266: ,p_appellant_brief_forwd_org in date default hr_api.g_date

Line 263: ,p_files_forwd in date default hr_api.g_date

259: ,p_docket_num in varchar2 default hr_api.g_varchar2
260: ,p_org_notified_of_appeal in date default hr_api.g_date
261: ,p_agency_recvd_req_for_files in date default hr_api.g_date
262: ,p_files_due in date default hr_api.g_date
263: ,p_files_forwd in date default hr_api.g_date
264: ,p_agcy_recvd_appellant_brief in date default hr_api.g_date
265: ,p_agency_brief_due in date default hr_api.g_date
266: ,p_appellant_brief_forwd_org in date default hr_api.g_date
267: ,p_org_forwd_brief_to_agency in date default hr_api.g_date

Line 264: ,p_agcy_recvd_appellant_brief in date default hr_api.g_date

260: ,p_org_notified_of_appeal in date default hr_api.g_date
261: ,p_agency_recvd_req_for_files in date default hr_api.g_date
262: ,p_files_due in date default hr_api.g_date
263: ,p_files_forwd in date default hr_api.g_date
264: ,p_agcy_recvd_appellant_brief in date default hr_api.g_date
265: ,p_agency_brief_due in date default hr_api.g_date
266: ,p_appellant_brief_forwd_org in date default hr_api.g_date
267: ,p_org_forwd_brief_to_agency in date default hr_api.g_date
268: ,p_agency_brief_forwd in date default hr_api.g_date

Line 265: ,p_agency_brief_due in date default hr_api.g_date

261: ,p_agency_recvd_req_for_files in date default hr_api.g_date
262: ,p_files_due in date default hr_api.g_date
263: ,p_files_forwd in date default hr_api.g_date
264: ,p_agcy_recvd_appellant_brief in date default hr_api.g_date
265: ,p_agency_brief_due in date default hr_api.g_date
266: ,p_appellant_brief_forwd_org in date default hr_api.g_date
267: ,p_org_forwd_brief_to_agency in date default hr_api.g_date
268: ,p_agency_brief_forwd in date default hr_api.g_date
269: ,p_decision_date in date default hr_api.g_date

Line 266: ,p_appellant_brief_forwd_org in date default hr_api.g_date

262: ,p_files_due in date default hr_api.g_date
263: ,p_files_forwd in date default hr_api.g_date
264: ,p_agcy_recvd_appellant_brief in date default hr_api.g_date
265: ,p_agency_brief_due in date default hr_api.g_date
266: ,p_appellant_brief_forwd_org in date default hr_api.g_date
267: ,p_org_forwd_brief_to_agency in date default hr_api.g_date
268: ,p_agency_brief_forwd in date default hr_api.g_date
269: ,p_decision_date in date default hr_api.g_date
270: ,p_dec_recvd_by_agency in date default hr_api.g_date

Line 267: ,p_org_forwd_brief_to_agency in date default hr_api.g_date

263: ,p_files_forwd in date default hr_api.g_date
264: ,p_agcy_recvd_appellant_brief in date default hr_api.g_date
265: ,p_agency_brief_due in date default hr_api.g_date
266: ,p_appellant_brief_forwd_org in date default hr_api.g_date
267: ,p_org_forwd_brief_to_agency in date default hr_api.g_date
268: ,p_agency_brief_forwd in date default hr_api.g_date
269: ,p_decision_date in date default hr_api.g_date
270: ,p_dec_recvd_by_agency in date default hr_api.g_date
271: ,p_decision in varchar2 default hr_api.g_varchar2

Line 268: ,p_agency_brief_forwd in date default hr_api.g_date

264: ,p_agcy_recvd_appellant_brief in date default hr_api.g_date
265: ,p_agency_brief_due in date default hr_api.g_date
266: ,p_appellant_brief_forwd_org in date default hr_api.g_date
267: ,p_org_forwd_brief_to_agency in date default hr_api.g_date
268: ,p_agency_brief_forwd in date default hr_api.g_date
269: ,p_decision_date in date default hr_api.g_date
270: ,p_dec_recvd_by_agency in date default hr_api.g_date
271: ,p_decision in varchar2 default hr_api.g_varchar2
272: ,p_dec_forwd_to_org in date default hr_api.g_date

Line 269: ,p_decision_date in date default hr_api.g_date

265: ,p_agency_brief_due in date default hr_api.g_date
266: ,p_appellant_brief_forwd_org in date default hr_api.g_date
267: ,p_org_forwd_brief_to_agency in date default hr_api.g_date
268: ,p_agency_brief_forwd in date default hr_api.g_date
269: ,p_decision_date in date default hr_api.g_date
270: ,p_dec_recvd_by_agency in date default hr_api.g_date
271: ,p_decision in varchar2 default hr_api.g_varchar2
272: ,p_dec_forwd_to_org in date default hr_api.g_date
273: ,p_agency_rfr_suspense in date default hr_api.g_date

Line 270: ,p_dec_recvd_by_agency in date default hr_api.g_date

266: ,p_appellant_brief_forwd_org in date default hr_api.g_date
267: ,p_org_forwd_brief_to_agency in date default hr_api.g_date
268: ,p_agency_brief_forwd in date default hr_api.g_date
269: ,p_decision_date in date default hr_api.g_date
270: ,p_dec_recvd_by_agency in date default hr_api.g_date
271: ,p_decision in varchar2 default hr_api.g_varchar2
272: ,p_dec_forwd_to_org in date default hr_api.g_date
273: ,p_agency_rfr_suspense in date default hr_api.g_date
274: ,p_request_for_rfr in date default hr_api.g_date

Line 271: ,p_decision in varchar2 default hr_api.g_varchar2

267: ,p_org_forwd_brief_to_agency in date default hr_api.g_date
268: ,p_agency_brief_forwd in date default hr_api.g_date
269: ,p_decision_date in date default hr_api.g_date
270: ,p_dec_recvd_by_agency in date default hr_api.g_date
271: ,p_decision in varchar2 default hr_api.g_varchar2
272: ,p_dec_forwd_to_org in date default hr_api.g_date
273: ,p_agency_rfr_suspense in date default hr_api.g_date
274: ,p_request_for_rfr in date default hr_api.g_date
275: ,p_rfr_docket_num in varchar2 default hr_api.g_varchar2

Line 272: ,p_dec_forwd_to_org in date default hr_api.g_date

268: ,p_agency_brief_forwd in date default hr_api.g_date
269: ,p_decision_date in date default hr_api.g_date
270: ,p_dec_recvd_by_agency in date default hr_api.g_date
271: ,p_decision in varchar2 default hr_api.g_varchar2
272: ,p_dec_forwd_to_org in date default hr_api.g_date
273: ,p_agency_rfr_suspense in date default hr_api.g_date
274: ,p_request_for_rfr in date default hr_api.g_date
275: ,p_rfr_docket_num in varchar2 default hr_api.g_varchar2
276: ,p_rfr_requested_by in varchar2 default hr_api.g_varchar2

Line 273: ,p_agency_rfr_suspense in date default hr_api.g_date

269: ,p_decision_date in date default hr_api.g_date
270: ,p_dec_recvd_by_agency in date default hr_api.g_date
271: ,p_decision in varchar2 default hr_api.g_varchar2
272: ,p_dec_forwd_to_org in date default hr_api.g_date
273: ,p_agency_rfr_suspense in date default hr_api.g_date
274: ,p_request_for_rfr in date default hr_api.g_date
275: ,p_rfr_docket_num in varchar2 default hr_api.g_varchar2
276: ,p_rfr_requested_by in varchar2 default hr_api.g_varchar2
277: ,p_agency_rfr_due in date default hr_api.g_date

Line 274: ,p_request_for_rfr in date default hr_api.g_date

270: ,p_dec_recvd_by_agency in date default hr_api.g_date
271: ,p_decision in varchar2 default hr_api.g_varchar2
272: ,p_dec_forwd_to_org in date default hr_api.g_date
273: ,p_agency_rfr_suspense in date default hr_api.g_date
274: ,p_request_for_rfr in date default hr_api.g_date
275: ,p_rfr_docket_num in varchar2 default hr_api.g_varchar2
276: ,p_rfr_requested_by in varchar2 default hr_api.g_varchar2
277: ,p_agency_rfr_due in date default hr_api.g_date
278: ,p_rfr_forwd_to_org in date default hr_api.g_date

Line 275: ,p_rfr_docket_num in varchar2 default hr_api.g_varchar2

271: ,p_decision in varchar2 default hr_api.g_varchar2
272: ,p_dec_forwd_to_org in date default hr_api.g_date
273: ,p_agency_rfr_suspense in date default hr_api.g_date
274: ,p_request_for_rfr in date default hr_api.g_date
275: ,p_rfr_docket_num in varchar2 default hr_api.g_varchar2
276: ,p_rfr_requested_by in varchar2 default hr_api.g_varchar2
277: ,p_agency_rfr_due in date default hr_api.g_date
278: ,p_rfr_forwd_to_org in date default hr_api.g_date
279: ,p_org_forwd_rfr_to_agency in date default hr_api.g_date

Line 276: ,p_rfr_requested_by in varchar2 default hr_api.g_varchar2

272: ,p_dec_forwd_to_org in date default hr_api.g_date
273: ,p_agency_rfr_suspense in date default hr_api.g_date
274: ,p_request_for_rfr in date default hr_api.g_date
275: ,p_rfr_docket_num in varchar2 default hr_api.g_varchar2
276: ,p_rfr_requested_by in varchar2 default hr_api.g_varchar2
277: ,p_agency_rfr_due in date default hr_api.g_date
278: ,p_rfr_forwd_to_org in date default hr_api.g_date
279: ,p_org_forwd_rfr_to_agency in date default hr_api.g_date
280: ,p_agency_forwd_rfr_ofo in date default hr_api.g_date

Line 277: ,p_agency_rfr_due in date default hr_api.g_date

273: ,p_agency_rfr_suspense in date default hr_api.g_date
274: ,p_request_for_rfr in date default hr_api.g_date
275: ,p_rfr_docket_num in varchar2 default hr_api.g_varchar2
276: ,p_rfr_requested_by in varchar2 default hr_api.g_varchar2
277: ,p_agency_rfr_due in date default hr_api.g_date
278: ,p_rfr_forwd_to_org in date default hr_api.g_date
279: ,p_org_forwd_rfr_to_agency in date default hr_api.g_date
280: ,p_agency_forwd_rfr_ofo in date default hr_api.g_date
281: ,p_rfr_decision in varchar2 default hr_api.g_varchar2

Line 278: ,p_rfr_forwd_to_org in date default hr_api.g_date

274: ,p_request_for_rfr in date default hr_api.g_date
275: ,p_rfr_docket_num in varchar2 default hr_api.g_varchar2
276: ,p_rfr_requested_by in varchar2 default hr_api.g_varchar2
277: ,p_agency_rfr_due in date default hr_api.g_date
278: ,p_rfr_forwd_to_org in date default hr_api.g_date
279: ,p_org_forwd_rfr_to_agency in date default hr_api.g_date
280: ,p_agency_forwd_rfr_ofo in date default hr_api.g_date
281: ,p_rfr_decision in varchar2 default hr_api.g_varchar2
282: ,p_rfr_decision_date in date default hr_api.g_date

Line 279: ,p_org_forwd_rfr_to_agency in date default hr_api.g_date

275: ,p_rfr_docket_num in varchar2 default hr_api.g_varchar2
276: ,p_rfr_requested_by in varchar2 default hr_api.g_varchar2
277: ,p_agency_rfr_due in date default hr_api.g_date
278: ,p_rfr_forwd_to_org in date default hr_api.g_date
279: ,p_org_forwd_rfr_to_agency in date default hr_api.g_date
280: ,p_agency_forwd_rfr_ofo in date default hr_api.g_date
281: ,p_rfr_decision in varchar2 default hr_api.g_varchar2
282: ,p_rfr_decision_date in date default hr_api.g_date
283: ,p_agency_recvd_rfr_dec in date default hr_api.g_date

Line 280: ,p_agency_forwd_rfr_ofo in date default hr_api.g_date

276: ,p_rfr_requested_by in varchar2 default hr_api.g_varchar2
277: ,p_agency_rfr_due in date default hr_api.g_date
278: ,p_rfr_forwd_to_org in date default hr_api.g_date
279: ,p_org_forwd_rfr_to_agency in date default hr_api.g_date
280: ,p_agency_forwd_rfr_ofo in date default hr_api.g_date
281: ,p_rfr_decision in varchar2 default hr_api.g_varchar2
282: ,p_rfr_decision_date in date default hr_api.g_date
283: ,p_agency_recvd_rfr_dec in date default hr_api.g_date
284: ,p_rfr_decision_forwd_to_org in date default hr_api.g_date

Line 281: ,p_rfr_decision in varchar2 default hr_api.g_varchar2

277: ,p_agency_rfr_due in date default hr_api.g_date
278: ,p_rfr_forwd_to_org in date default hr_api.g_date
279: ,p_org_forwd_rfr_to_agency in date default hr_api.g_date
280: ,p_agency_forwd_rfr_ofo in date default hr_api.g_date
281: ,p_rfr_decision in varchar2 default hr_api.g_varchar2
282: ,p_rfr_decision_date in date default hr_api.g_date
283: ,p_agency_recvd_rfr_dec in date default hr_api.g_date
284: ,p_rfr_decision_forwd_to_org in date default hr_api.g_date
285: )

Line 282: ,p_rfr_decision_date in date default hr_api.g_date

278: ,p_rfr_forwd_to_org in date default hr_api.g_date
279: ,p_org_forwd_rfr_to_agency in date default hr_api.g_date
280: ,p_agency_forwd_rfr_ofo in date default hr_api.g_date
281: ,p_rfr_decision in varchar2 default hr_api.g_varchar2
282: ,p_rfr_decision_date in date default hr_api.g_date
283: ,p_agency_recvd_rfr_dec in date default hr_api.g_date
284: ,p_rfr_decision_forwd_to_org in date default hr_api.g_date
285: )
286:

Line 283: ,p_agency_recvd_rfr_dec in date default hr_api.g_date

279: ,p_org_forwd_rfr_to_agency in date default hr_api.g_date
280: ,p_agency_forwd_rfr_ofo in date default hr_api.g_date
281: ,p_rfr_decision in varchar2 default hr_api.g_varchar2
282: ,p_rfr_decision_date in date default hr_api.g_date
283: ,p_agency_recvd_rfr_dec in date default hr_api.g_date
284: ,p_rfr_decision_forwd_to_org in date default hr_api.g_date
285: )
286:
287: is

Line 284: ,p_rfr_decision_forwd_to_org in date default hr_api.g_date

280: ,p_agency_forwd_rfr_ofo in date default hr_api.g_date
281: ,p_rfr_decision in varchar2 default hr_api.g_varchar2
282: ,p_rfr_decision_date in date default hr_api.g_date
283: ,p_agency_recvd_rfr_dec in date default hr_api.g_date
284: ,p_rfr_decision_forwd_to_org in date default hr_api.g_date
285: )
286:
287: is
288: l_proc varchar2(72) := g_package||'update_complaint_appeal';

Line 341: when hr_api.cannot_find_prog_unit then

337: ,p_compl_appeal_id => p_compl_appeal_id
338: ,p_object_version_number => p_object_version_number
339: );
340: exception
341: when hr_api.cannot_find_prog_unit then
342: hr_api.cannot_find_prog_unit_error
343: (p_module_name => 'update_complainant_appeal'
344: ,p_hook_type => 'BP'
345: );

Line 342: hr_api.cannot_find_prog_unit_error

338: ,p_object_version_number => p_object_version_number
339: );
340: exception
341: when hr_api.cannot_find_prog_unit then
342: hr_api.cannot_find_prog_unit_error
343: (p_module_name => 'update_complainant_appeal'
344: ,p_hook_type => 'BP'
345: );
346: end;

Line 431: when hr_api.cannot_find_prog_unit then

427: ,p_compl_appeal_id => p_compl_appeal_id
428: ,p_object_version_number => l_object_version_number
429: );
430: exception
431: when hr_api.cannot_find_prog_unit then
432: hr_api.cannot_find_prog_unit_error
433: (p_module_name => 'update_complainant_appeal'
434: ,p_hook_type => 'AP'
435: );

Line 432: hr_api.cannot_find_prog_unit_error

428: ,p_object_version_number => l_object_version_number
429: );
430: exception
431: when hr_api.cannot_find_prog_unit then
432: hr_api.cannot_find_prog_unit_error
433: (p_module_name => 'update_complainant_appeal'
434: ,p_hook_type => 'AP'
435: );
436: end;

Line 441: raise hr_api.validate_enabled;

437: --
438: -- When in validation only mode raise the Validate_Enabled exception
439: --
440: if p_validate then
441: raise hr_api.validate_enabled;
442: end if;
443: --
444: -- Set all output arguments
445: --

Line 451: when hr_api.validate_enabled then

447: p_object_version_number := l_object_version_number;
448: --
449: hr_utility.set_location(' Leaving:'||l_proc, 70);
450: exception
451: when hr_api.validate_enabled then
452: --
453: -- As the Validate_Enabled exception has been raised
454: -- we must rollback to the savepoint
455: --

Line 510: when hr_api.cannot_find_prog_unit then

506: (p_compl_appeal_id => p_compl_appeal_id
507: ,p_object_version_number => p_object_version_number
508: );
509: exception
510: when hr_api.cannot_find_prog_unit then
511: hr_api.cannot_find_prog_unit_error
512: (p_module_name => 'delete_complainant_appeal'
513: ,p_hook_type => 'BP'
514: );

Line 511: hr_api.cannot_find_prog_unit_error

507: ,p_object_version_number => p_object_version_number
508: );
509: exception
510: when hr_api.cannot_find_prog_unit then
511: hr_api.cannot_find_prog_unit_error
512: (p_module_name => 'delete_complainant_appeal'
513: ,p_hook_type => 'BP'
514: );
515: end;

Line 534: when hr_api.cannot_find_prog_unit then

530: (p_compl_appeal_id => p_compl_appeal_id
531: ,p_object_version_number => p_object_version_number
532: );
533: exception
534: when hr_api.cannot_find_prog_unit then
535: hr_api.cannot_find_prog_unit_error
536: (p_module_name => 'delete_complainant_appeal'
537: ,p_hook_type => 'AP'
538: );

Line 535: hr_api.cannot_find_prog_unit_error

531: ,p_object_version_number => p_object_version_number
532: );
533: exception
534: when hr_api.cannot_find_prog_unit then
535: hr_api.cannot_find_prog_unit_error
536: (p_module_name => 'delete_complainant_appeal'
537: ,p_hook_type => 'AP'
538: );
539: end;

Line 545: raise hr_api.validate_enabled;

541: --
542: -- When in validation only mode raise the Validate_Enabled exception
543: --
544: if p_validate then
545: raise hr_api.validate_enabled;
546: end if;
547: --
548: hr_utility.set_location(' Leaving:'||l_proc, 11);
549: exception

Line 550: when hr_api.validate_enabled then

546: end if;
547: --
548: hr_utility.set_location(' Leaving:'||l_proc, 11);
549: exception
550: when hr_api.validate_enabled then
551: -- we must rollback to the savepoint
552: --
553: ROLLBACK TO delete_complainant_appeal;
554: --