eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQH_TXN_JOB_REQUIREMENTS_API dependencies on HR_API

Line 111: when hr_api.cannot_find_prog_unit then

107: ,p_attribute20 => p_attribute20
108: ,p_comments => p_comments
109: );
110: exception
111: when hr_api.cannot_find_prog_unit then
112: hr_api.cannot_find_prog_unit_error
113: (p_module_name => 'CREATE_TXN_JOB_REQUIREMENT'
114: ,p_hook_type => 'BP'
115: );

Line 112: hr_api.cannot_find_prog_unit_error

108: ,p_comments => p_comments
109: );
110: exception
111: when hr_api.cannot_find_prog_unit then
112: hr_api.cannot_find_prog_unit_error
113: (p_module_name => 'CREATE_TXN_JOB_REQUIREMENT'
114: ,p_hook_type => 'BP'
115: );
116: end;

Line 210: when hr_api.cannot_find_prog_unit then

206: ,p_attribute20 => p_attribute20
207: ,p_comments => p_comments
208: );
209: exception
210: when hr_api.cannot_find_prog_unit then
211: hr_api.cannot_find_prog_unit_error
212: (p_module_name => 'CREATE_TXN_JOB_REQUIREMENT'
213: ,p_hook_type => 'AP'
214: );

Line 211: hr_api.cannot_find_prog_unit_error

207: ,p_comments => p_comments
208: );
209: exception
210: when hr_api.cannot_find_prog_unit then
211: hr_api.cannot_find_prog_unit_error
212: (p_module_name => 'CREATE_TXN_JOB_REQUIREMENT'
213: ,p_hook_type => 'AP'
214: );
215: end;

Line 220: raise hr_api.validate_enabled;

216: --
217: -- When in validation only mode raise the Validate_Enabled exception
218: --
219: if p_validate then
220: raise hr_api.validate_enabled;
221: end if;
222: --
223: -- Set all output arguments
224: --

Line 230: when hr_api.validate_enabled then

226: p_object_version_number := l_object_version_number;
227: --
228: hr_utility.set_location(' Leaving:'||l_proc, 70);
229: exception
230: when hr_api.validate_enabled then
231: --
232: -- As the Validate_Enabled exception has been raised
233: -- we must rollback to the savepoint
234: --

Line 264: ,p_business_group_id in number default hr_api.g_number

260: (p_validate in boolean default false
261: ,p_effective_date in date
262: ,p_txn_job_requirement_id in number
263: ,p_object_version_number in out nocopy number
264: ,p_business_group_id in number default hr_api.g_number
265: ,p_analysis_criteria_id in number default hr_api.g_number
266: ,p_position_transaction_id in number default hr_api.g_number
267: ,p_job_requirement_id in number default hr_api.g_number
268: ,p_date_from in date default hr_api.g_date

Line 265: ,p_analysis_criteria_id in number default hr_api.g_number

261: ,p_effective_date in date
262: ,p_txn_job_requirement_id in number
263: ,p_object_version_number in out nocopy number
264: ,p_business_group_id in number default hr_api.g_number
265: ,p_analysis_criteria_id in number default hr_api.g_number
266: ,p_position_transaction_id in number default hr_api.g_number
267: ,p_job_requirement_id in number default hr_api.g_number
268: ,p_date_from in date default hr_api.g_date
269: ,p_date_to in date default hr_api.g_date

Line 266: ,p_position_transaction_id in number default hr_api.g_number

262: ,p_txn_job_requirement_id in number
263: ,p_object_version_number in out nocopy number
264: ,p_business_group_id in number default hr_api.g_number
265: ,p_analysis_criteria_id in number default hr_api.g_number
266: ,p_position_transaction_id in number default hr_api.g_number
267: ,p_job_requirement_id in number default hr_api.g_number
268: ,p_date_from in date default hr_api.g_date
269: ,p_date_to in date default hr_api.g_date
270: ,p_essential in varchar2 default hr_api.g_varchar2

Line 267: ,p_job_requirement_id in number default hr_api.g_number

263: ,p_object_version_number in out nocopy number
264: ,p_business_group_id in number default hr_api.g_number
265: ,p_analysis_criteria_id in number default hr_api.g_number
266: ,p_position_transaction_id in number default hr_api.g_number
267: ,p_job_requirement_id in number default hr_api.g_number
268: ,p_date_from in date default hr_api.g_date
269: ,p_date_to in date default hr_api.g_date
270: ,p_essential in varchar2 default hr_api.g_varchar2
271: ,p_job_id in number default hr_api.g_number

Line 268: ,p_date_from in date default hr_api.g_date

264: ,p_business_group_id in number default hr_api.g_number
265: ,p_analysis_criteria_id in number default hr_api.g_number
266: ,p_position_transaction_id in number default hr_api.g_number
267: ,p_job_requirement_id in number default hr_api.g_number
268: ,p_date_from in date default hr_api.g_date
269: ,p_date_to in date default hr_api.g_date
270: ,p_essential in varchar2 default hr_api.g_varchar2
271: ,p_job_id in number default hr_api.g_number
272: ,p_request_id in number default hr_api.g_number

Line 269: ,p_date_to in date default hr_api.g_date

265: ,p_analysis_criteria_id in number default hr_api.g_number
266: ,p_position_transaction_id in number default hr_api.g_number
267: ,p_job_requirement_id in number default hr_api.g_number
268: ,p_date_from in date default hr_api.g_date
269: ,p_date_to in date default hr_api.g_date
270: ,p_essential in varchar2 default hr_api.g_varchar2
271: ,p_job_id in number default hr_api.g_number
272: ,p_request_id in number default hr_api.g_number
273: ,p_program_application_id in number default hr_api.g_number

Line 270: ,p_essential in varchar2 default hr_api.g_varchar2

266: ,p_position_transaction_id in number default hr_api.g_number
267: ,p_job_requirement_id in number default hr_api.g_number
268: ,p_date_from in date default hr_api.g_date
269: ,p_date_to in date default hr_api.g_date
270: ,p_essential in varchar2 default hr_api.g_varchar2
271: ,p_job_id in number default hr_api.g_number
272: ,p_request_id in number default hr_api.g_number
273: ,p_program_application_id in number default hr_api.g_number
274: ,p_program_id in number default hr_api.g_number

Line 271: ,p_job_id in number default hr_api.g_number

267: ,p_job_requirement_id in number default hr_api.g_number
268: ,p_date_from in date default hr_api.g_date
269: ,p_date_to in date default hr_api.g_date
270: ,p_essential in varchar2 default hr_api.g_varchar2
271: ,p_job_id in number default hr_api.g_number
272: ,p_request_id in number default hr_api.g_number
273: ,p_program_application_id in number default hr_api.g_number
274: ,p_program_id in number default hr_api.g_number
275: ,p_program_update_date in date default hr_api.g_date

Line 272: ,p_request_id in number default hr_api.g_number

268: ,p_date_from in date default hr_api.g_date
269: ,p_date_to in date default hr_api.g_date
270: ,p_essential in varchar2 default hr_api.g_varchar2
271: ,p_job_id in number default hr_api.g_number
272: ,p_request_id in number default hr_api.g_number
273: ,p_program_application_id in number default hr_api.g_number
274: ,p_program_id in number default hr_api.g_number
275: ,p_program_update_date in date default hr_api.g_date
276: ,p_attribute_category in varchar2 default hr_api.g_varchar2

Line 273: ,p_program_application_id in number default hr_api.g_number

269: ,p_date_to in date default hr_api.g_date
270: ,p_essential in varchar2 default hr_api.g_varchar2
271: ,p_job_id in number default hr_api.g_number
272: ,p_request_id in number default hr_api.g_number
273: ,p_program_application_id in number default hr_api.g_number
274: ,p_program_id in number default hr_api.g_number
275: ,p_program_update_date in date default hr_api.g_date
276: ,p_attribute_category in varchar2 default hr_api.g_varchar2
277: ,p_attribute1 in varchar2 default hr_api.g_varchar2

Line 274: ,p_program_id in number default hr_api.g_number

270: ,p_essential in varchar2 default hr_api.g_varchar2
271: ,p_job_id in number default hr_api.g_number
272: ,p_request_id in number default hr_api.g_number
273: ,p_program_application_id in number default hr_api.g_number
274: ,p_program_id in number default hr_api.g_number
275: ,p_program_update_date in date default hr_api.g_date
276: ,p_attribute_category in varchar2 default hr_api.g_varchar2
277: ,p_attribute1 in varchar2 default hr_api.g_varchar2
278: ,p_attribute2 in varchar2 default hr_api.g_varchar2

Line 275: ,p_program_update_date in date default hr_api.g_date

271: ,p_job_id in number default hr_api.g_number
272: ,p_request_id in number default hr_api.g_number
273: ,p_program_application_id in number default hr_api.g_number
274: ,p_program_id in number default hr_api.g_number
275: ,p_program_update_date in date default hr_api.g_date
276: ,p_attribute_category in varchar2 default hr_api.g_varchar2
277: ,p_attribute1 in varchar2 default hr_api.g_varchar2
278: ,p_attribute2 in varchar2 default hr_api.g_varchar2
279: ,p_attribute3 in varchar2 default hr_api.g_varchar2

Line 276: ,p_attribute_category in varchar2 default hr_api.g_varchar2

272: ,p_request_id in number default hr_api.g_number
273: ,p_program_application_id in number default hr_api.g_number
274: ,p_program_id in number default hr_api.g_number
275: ,p_program_update_date in date default hr_api.g_date
276: ,p_attribute_category in varchar2 default hr_api.g_varchar2
277: ,p_attribute1 in varchar2 default hr_api.g_varchar2
278: ,p_attribute2 in varchar2 default hr_api.g_varchar2
279: ,p_attribute3 in varchar2 default hr_api.g_varchar2
280: ,p_attribute4 in varchar2 default hr_api.g_varchar2

Line 277: ,p_attribute1 in varchar2 default hr_api.g_varchar2

273: ,p_program_application_id in number default hr_api.g_number
274: ,p_program_id in number default hr_api.g_number
275: ,p_program_update_date in date default hr_api.g_date
276: ,p_attribute_category in varchar2 default hr_api.g_varchar2
277: ,p_attribute1 in varchar2 default hr_api.g_varchar2
278: ,p_attribute2 in varchar2 default hr_api.g_varchar2
279: ,p_attribute3 in varchar2 default hr_api.g_varchar2
280: ,p_attribute4 in varchar2 default hr_api.g_varchar2
281: ,p_attribute5 in varchar2 default hr_api.g_varchar2

Line 278: ,p_attribute2 in varchar2 default hr_api.g_varchar2

274: ,p_program_id in number default hr_api.g_number
275: ,p_program_update_date in date default hr_api.g_date
276: ,p_attribute_category in varchar2 default hr_api.g_varchar2
277: ,p_attribute1 in varchar2 default hr_api.g_varchar2
278: ,p_attribute2 in varchar2 default hr_api.g_varchar2
279: ,p_attribute3 in varchar2 default hr_api.g_varchar2
280: ,p_attribute4 in varchar2 default hr_api.g_varchar2
281: ,p_attribute5 in varchar2 default hr_api.g_varchar2
282: ,p_attribute6 in varchar2 default hr_api.g_varchar2

Line 279: ,p_attribute3 in varchar2 default hr_api.g_varchar2

275: ,p_program_update_date in date default hr_api.g_date
276: ,p_attribute_category in varchar2 default hr_api.g_varchar2
277: ,p_attribute1 in varchar2 default hr_api.g_varchar2
278: ,p_attribute2 in varchar2 default hr_api.g_varchar2
279: ,p_attribute3 in varchar2 default hr_api.g_varchar2
280: ,p_attribute4 in varchar2 default hr_api.g_varchar2
281: ,p_attribute5 in varchar2 default hr_api.g_varchar2
282: ,p_attribute6 in varchar2 default hr_api.g_varchar2
283: ,p_attribute7 in varchar2 default hr_api.g_varchar2

Line 280: ,p_attribute4 in varchar2 default hr_api.g_varchar2

276: ,p_attribute_category in varchar2 default hr_api.g_varchar2
277: ,p_attribute1 in varchar2 default hr_api.g_varchar2
278: ,p_attribute2 in varchar2 default hr_api.g_varchar2
279: ,p_attribute3 in varchar2 default hr_api.g_varchar2
280: ,p_attribute4 in varchar2 default hr_api.g_varchar2
281: ,p_attribute5 in varchar2 default hr_api.g_varchar2
282: ,p_attribute6 in varchar2 default hr_api.g_varchar2
283: ,p_attribute7 in varchar2 default hr_api.g_varchar2
284: ,p_attribute8 in varchar2 default hr_api.g_varchar2

Line 281: ,p_attribute5 in varchar2 default hr_api.g_varchar2

277: ,p_attribute1 in varchar2 default hr_api.g_varchar2
278: ,p_attribute2 in varchar2 default hr_api.g_varchar2
279: ,p_attribute3 in varchar2 default hr_api.g_varchar2
280: ,p_attribute4 in varchar2 default hr_api.g_varchar2
281: ,p_attribute5 in varchar2 default hr_api.g_varchar2
282: ,p_attribute6 in varchar2 default hr_api.g_varchar2
283: ,p_attribute7 in varchar2 default hr_api.g_varchar2
284: ,p_attribute8 in varchar2 default hr_api.g_varchar2
285: ,p_attribute9 in varchar2 default hr_api.g_varchar2

Line 282: ,p_attribute6 in varchar2 default hr_api.g_varchar2

278: ,p_attribute2 in varchar2 default hr_api.g_varchar2
279: ,p_attribute3 in varchar2 default hr_api.g_varchar2
280: ,p_attribute4 in varchar2 default hr_api.g_varchar2
281: ,p_attribute5 in varchar2 default hr_api.g_varchar2
282: ,p_attribute6 in varchar2 default hr_api.g_varchar2
283: ,p_attribute7 in varchar2 default hr_api.g_varchar2
284: ,p_attribute8 in varchar2 default hr_api.g_varchar2
285: ,p_attribute9 in varchar2 default hr_api.g_varchar2
286: ,p_attribute10 in varchar2 default hr_api.g_varchar2

Line 283: ,p_attribute7 in varchar2 default hr_api.g_varchar2

279: ,p_attribute3 in varchar2 default hr_api.g_varchar2
280: ,p_attribute4 in varchar2 default hr_api.g_varchar2
281: ,p_attribute5 in varchar2 default hr_api.g_varchar2
282: ,p_attribute6 in varchar2 default hr_api.g_varchar2
283: ,p_attribute7 in varchar2 default hr_api.g_varchar2
284: ,p_attribute8 in varchar2 default hr_api.g_varchar2
285: ,p_attribute9 in varchar2 default hr_api.g_varchar2
286: ,p_attribute10 in varchar2 default hr_api.g_varchar2
287: ,p_attribute11 in varchar2 default hr_api.g_varchar2

Line 284: ,p_attribute8 in varchar2 default hr_api.g_varchar2

280: ,p_attribute4 in varchar2 default hr_api.g_varchar2
281: ,p_attribute5 in varchar2 default hr_api.g_varchar2
282: ,p_attribute6 in varchar2 default hr_api.g_varchar2
283: ,p_attribute7 in varchar2 default hr_api.g_varchar2
284: ,p_attribute8 in varchar2 default hr_api.g_varchar2
285: ,p_attribute9 in varchar2 default hr_api.g_varchar2
286: ,p_attribute10 in varchar2 default hr_api.g_varchar2
287: ,p_attribute11 in varchar2 default hr_api.g_varchar2
288: ,p_attribute12 in varchar2 default hr_api.g_varchar2

Line 285: ,p_attribute9 in varchar2 default hr_api.g_varchar2

281: ,p_attribute5 in varchar2 default hr_api.g_varchar2
282: ,p_attribute6 in varchar2 default hr_api.g_varchar2
283: ,p_attribute7 in varchar2 default hr_api.g_varchar2
284: ,p_attribute8 in varchar2 default hr_api.g_varchar2
285: ,p_attribute9 in varchar2 default hr_api.g_varchar2
286: ,p_attribute10 in varchar2 default hr_api.g_varchar2
287: ,p_attribute11 in varchar2 default hr_api.g_varchar2
288: ,p_attribute12 in varchar2 default hr_api.g_varchar2
289: ,p_attribute13 in varchar2 default hr_api.g_varchar2

Line 286: ,p_attribute10 in varchar2 default hr_api.g_varchar2

282: ,p_attribute6 in varchar2 default hr_api.g_varchar2
283: ,p_attribute7 in varchar2 default hr_api.g_varchar2
284: ,p_attribute8 in varchar2 default hr_api.g_varchar2
285: ,p_attribute9 in varchar2 default hr_api.g_varchar2
286: ,p_attribute10 in varchar2 default hr_api.g_varchar2
287: ,p_attribute11 in varchar2 default hr_api.g_varchar2
288: ,p_attribute12 in varchar2 default hr_api.g_varchar2
289: ,p_attribute13 in varchar2 default hr_api.g_varchar2
290: ,p_attribute14 in varchar2 default hr_api.g_varchar2

Line 287: ,p_attribute11 in varchar2 default hr_api.g_varchar2

283: ,p_attribute7 in varchar2 default hr_api.g_varchar2
284: ,p_attribute8 in varchar2 default hr_api.g_varchar2
285: ,p_attribute9 in varchar2 default hr_api.g_varchar2
286: ,p_attribute10 in varchar2 default hr_api.g_varchar2
287: ,p_attribute11 in varchar2 default hr_api.g_varchar2
288: ,p_attribute12 in varchar2 default hr_api.g_varchar2
289: ,p_attribute13 in varchar2 default hr_api.g_varchar2
290: ,p_attribute14 in varchar2 default hr_api.g_varchar2
291: ,p_attribute15 in varchar2 default hr_api.g_varchar2

Line 288: ,p_attribute12 in varchar2 default hr_api.g_varchar2

284: ,p_attribute8 in varchar2 default hr_api.g_varchar2
285: ,p_attribute9 in varchar2 default hr_api.g_varchar2
286: ,p_attribute10 in varchar2 default hr_api.g_varchar2
287: ,p_attribute11 in varchar2 default hr_api.g_varchar2
288: ,p_attribute12 in varchar2 default hr_api.g_varchar2
289: ,p_attribute13 in varchar2 default hr_api.g_varchar2
290: ,p_attribute14 in varchar2 default hr_api.g_varchar2
291: ,p_attribute15 in varchar2 default hr_api.g_varchar2
292: ,p_attribute16 in varchar2 default hr_api.g_varchar2

Line 289: ,p_attribute13 in varchar2 default hr_api.g_varchar2

285: ,p_attribute9 in varchar2 default hr_api.g_varchar2
286: ,p_attribute10 in varchar2 default hr_api.g_varchar2
287: ,p_attribute11 in varchar2 default hr_api.g_varchar2
288: ,p_attribute12 in varchar2 default hr_api.g_varchar2
289: ,p_attribute13 in varchar2 default hr_api.g_varchar2
290: ,p_attribute14 in varchar2 default hr_api.g_varchar2
291: ,p_attribute15 in varchar2 default hr_api.g_varchar2
292: ,p_attribute16 in varchar2 default hr_api.g_varchar2
293: ,p_attribute17 in varchar2 default hr_api.g_varchar2

Line 290: ,p_attribute14 in varchar2 default hr_api.g_varchar2

286: ,p_attribute10 in varchar2 default hr_api.g_varchar2
287: ,p_attribute11 in varchar2 default hr_api.g_varchar2
288: ,p_attribute12 in varchar2 default hr_api.g_varchar2
289: ,p_attribute13 in varchar2 default hr_api.g_varchar2
290: ,p_attribute14 in varchar2 default hr_api.g_varchar2
291: ,p_attribute15 in varchar2 default hr_api.g_varchar2
292: ,p_attribute16 in varchar2 default hr_api.g_varchar2
293: ,p_attribute17 in varchar2 default hr_api.g_varchar2
294: ,p_attribute18 in varchar2 default hr_api.g_varchar2

Line 291: ,p_attribute15 in varchar2 default hr_api.g_varchar2

287: ,p_attribute11 in varchar2 default hr_api.g_varchar2
288: ,p_attribute12 in varchar2 default hr_api.g_varchar2
289: ,p_attribute13 in varchar2 default hr_api.g_varchar2
290: ,p_attribute14 in varchar2 default hr_api.g_varchar2
291: ,p_attribute15 in varchar2 default hr_api.g_varchar2
292: ,p_attribute16 in varchar2 default hr_api.g_varchar2
293: ,p_attribute17 in varchar2 default hr_api.g_varchar2
294: ,p_attribute18 in varchar2 default hr_api.g_varchar2
295: ,p_attribute19 in varchar2 default hr_api.g_varchar2

Line 292: ,p_attribute16 in varchar2 default hr_api.g_varchar2

288: ,p_attribute12 in varchar2 default hr_api.g_varchar2
289: ,p_attribute13 in varchar2 default hr_api.g_varchar2
290: ,p_attribute14 in varchar2 default hr_api.g_varchar2
291: ,p_attribute15 in varchar2 default hr_api.g_varchar2
292: ,p_attribute16 in varchar2 default hr_api.g_varchar2
293: ,p_attribute17 in varchar2 default hr_api.g_varchar2
294: ,p_attribute18 in varchar2 default hr_api.g_varchar2
295: ,p_attribute19 in varchar2 default hr_api.g_varchar2
296: ,p_attribute20 in varchar2 default hr_api.g_varchar2

Line 293: ,p_attribute17 in varchar2 default hr_api.g_varchar2

289: ,p_attribute13 in varchar2 default hr_api.g_varchar2
290: ,p_attribute14 in varchar2 default hr_api.g_varchar2
291: ,p_attribute15 in varchar2 default hr_api.g_varchar2
292: ,p_attribute16 in varchar2 default hr_api.g_varchar2
293: ,p_attribute17 in varchar2 default hr_api.g_varchar2
294: ,p_attribute18 in varchar2 default hr_api.g_varchar2
295: ,p_attribute19 in varchar2 default hr_api.g_varchar2
296: ,p_attribute20 in varchar2 default hr_api.g_varchar2
297: ,p_comments in varchar2 default hr_api.g_varchar2

Line 294: ,p_attribute18 in varchar2 default hr_api.g_varchar2

290: ,p_attribute14 in varchar2 default hr_api.g_varchar2
291: ,p_attribute15 in varchar2 default hr_api.g_varchar2
292: ,p_attribute16 in varchar2 default hr_api.g_varchar2
293: ,p_attribute17 in varchar2 default hr_api.g_varchar2
294: ,p_attribute18 in varchar2 default hr_api.g_varchar2
295: ,p_attribute19 in varchar2 default hr_api.g_varchar2
296: ,p_attribute20 in varchar2 default hr_api.g_varchar2
297: ,p_comments in varchar2 default hr_api.g_varchar2
298: ) is

Line 295: ,p_attribute19 in varchar2 default hr_api.g_varchar2

291: ,p_attribute15 in varchar2 default hr_api.g_varchar2
292: ,p_attribute16 in varchar2 default hr_api.g_varchar2
293: ,p_attribute17 in varchar2 default hr_api.g_varchar2
294: ,p_attribute18 in varchar2 default hr_api.g_varchar2
295: ,p_attribute19 in varchar2 default hr_api.g_varchar2
296: ,p_attribute20 in varchar2 default hr_api.g_varchar2
297: ,p_comments in varchar2 default hr_api.g_varchar2
298: ) is
299: --

Line 296: ,p_attribute20 in varchar2 default hr_api.g_varchar2

292: ,p_attribute16 in varchar2 default hr_api.g_varchar2
293: ,p_attribute17 in varchar2 default hr_api.g_varchar2
294: ,p_attribute18 in varchar2 default hr_api.g_varchar2
295: ,p_attribute19 in varchar2 default hr_api.g_varchar2
296: ,p_attribute20 in varchar2 default hr_api.g_varchar2
297: ,p_comments in varchar2 default hr_api.g_varchar2
298: ) is
299: --
300: -- Declare cursors and local variables

Line 297: ,p_comments in varchar2 default hr_api.g_varchar2

293: ,p_attribute17 in varchar2 default hr_api.g_varchar2
294: ,p_attribute18 in varchar2 default hr_api.g_varchar2
295: ,p_attribute19 in varchar2 default hr_api.g_varchar2
296: ,p_attribute20 in varchar2 default hr_api.g_varchar2
297: ,p_comments in varchar2 default hr_api.g_varchar2
298: ) is
299: --
300: -- Declare cursors and local variables
301: --

Line 359: when hr_api.cannot_find_prog_unit then

355: ,p_txn_job_requirement_id => p_txn_job_requirement_id
356: ,p_object_version_number => p_object_version_number
357: );
358: exception
359: when hr_api.cannot_find_prog_unit then
360: hr_api.cannot_find_prog_unit_error
361: (p_module_name => 'UPDATE_TXN_JOB_REQUIREMENT'
362: ,p_hook_type => 'BP'
363: );

Line 360: hr_api.cannot_find_prog_unit_error

356: ,p_object_version_number => p_object_version_number
357: );
358: exception
359: when hr_api.cannot_find_prog_unit then
360: hr_api.cannot_find_prog_unit_error
361: (p_module_name => 'UPDATE_TXN_JOB_REQUIREMENT'
362: ,p_hook_type => 'BP'
363: );
364: end;

Line 458: when hr_api.cannot_find_prog_unit then

454: ,p_attribute20 => p_attribute20
455: ,p_comments => p_comments
456: );
457: exception
458: when hr_api.cannot_find_prog_unit then
459: hr_api.cannot_find_prog_unit_error
460: (p_module_name => 'UPDATE_TXN_JOB_REQUIREMENT'
461: ,p_hook_type => 'AP'
462: );

Line 459: hr_api.cannot_find_prog_unit_error

455: ,p_comments => p_comments
456: );
457: exception
458: when hr_api.cannot_find_prog_unit then
459: hr_api.cannot_find_prog_unit_error
460: (p_module_name => 'UPDATE_TXN_JOB_REQUIREMENT'
461: ,p_hook_type => 'AP'
462: );
463: end;

Line 468: raise hr_api.validate_enabled;

464: --
465: -- When in validation only mode raise the Validate_Enabled exception
466: --
467: if p_validate then
468: raise hr_api.validate_enabled;
469: end if;
470: --
471: -- Set all output arguments
472: --

Line 477: when hr_api.validate_enabled then

473: p_object_version_number := l_object_version_number;
474: --
475: hr_utility.set_location(' Leaving:'||l_proc, 70);
476: exception
477: when hr_api.validate_enabled then
478: --
479: -- As the Validate_Enabled exception has been raised
480: -- we must rollback to the savepoint
481: --

Line 536: when hr_api.cannot_find_prog_unit then

532: ,p_txn_job_requirement_id => p_txn_job_requirement_id
533: ,p_object_version_number => l_object_version_number
534: );
535: exception
536: when hr_api.cannot_find_prog_unit then
537: hr_api.cannot_find_prog_unit_error
538: (p_module_name => 'DELETE_TXN_JOB_REQUIREMENT'
539: ,p_hook_type => 'BP'
540: );

Line 537: hr_api.cannot_find_prog_unit_error

533: ,p_object_version_number => l_object_version_number
534: );
535: exception
536: when hr_api.cannot_find_prog_unit then
537: hr_api.cannot_find_prog_unit_error
538: (p_module_name => 'DELETE_TXN_JOB_REQUIREMENT'
539: ,p_hook_type => 'BP'
540: );
541: end;

Line 567: when hr_api.cannot_find_prog_unit then

563: ,p_txn_job_requirement_id => p_txn_job_requirement_id
564: ,p_object_version_number => l_object_version_number
565: );
566: exception
567: when hr_api.cannot_find_prog_unit then
568: hr_api.cannot_find_prog_unit_error
569: (p_module_name => 'DELETE_TXN_JOB_REQUIREMENT'
570: ,p_hook_type => 'AP'
571: );

Line 568: hr_api.cannot_find_prog_unit_error

564: ,p_object_version_number => l_object_version_number
565: );
566: exception
567: when hr_api.cannot_find_prog_unit then
568: hr_api.cannot_find_prog_unit_error
569: (p_module_name => 'DELETE_TXN_JOB_REQUIREMENT'
570: ,p_hook_type => 'AP'
571: );
572: end;

Line 577: raise hr_api.validate_enabled;

573: --
574: -- When in validation only mode raise the Validate_Enabled exception
575: --
576: if p_validate then
577: raise hr_api.validate_enabled;
578: end if;
579: --
580: -- Set all output arguments
581: --

Line 585: when hr_api.validate_enabled then

581: --
582: --
583: hr_utility.set_location(' Leaving:'||l_proc, 70);
584: exception
585: when hr_api.validate_enabled then
586: --
587: -- As the Validate_Enabled exception has been raised
588: -- we must rollback to the savepoint
589: --