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.HR_ELC_CONSTITUENCYS_API dependencies on HR_API

Line 74: hr_api.mandatory_arg_error

70: -- Check that p_election_id, p_business_group_id, p_constituency_id are not null.
71: --
72: hr_utility.set_location('Entering mandatory arg check', 20);
73: --
74: hr_api.mandatory_arg_error
75: (p_api_name => l_proc,
76: p_argument => 'election_id',
77: p_argument_value => p_election_id);
78: --

Line 79: hr_api.mandatory_arg_error

75: (p_api_name => l_proc,
76: p_argument => 'election_id',
77: p_argument_value => p_election_id);
78: --
79: hr_api.mandatory_arg_error
80: (p_api_name => l_proc,
81: p_argument => 'business_group_id',
82: p_argument_value => p_business_group_id);
83: --

Line 84: hr_api.mandatory_arg_error

80: (p_api_name => l_proc,
81: p_argument => 'business_group_id',
82: p_argument_value => p_business_group_id);
83: --
84: hr_api.mandatory_arg_error
85: (p_api_name => l_proc,
86: p_argument => 'constituency_id',
87: p_argument_value => p_constituency_id);
88: --

Line 89: hr_api.mandatory_arg_error

85: (p_api_name => l_proc,
86: p_argument => 'constituency_id',
87: p_argument_value => p_constituency_id);
88: --
89: hr_api.mandatory_arg_error
90: (p_api_name => l_proc,
91: p_argument => 'effective_date',
92: p_argument_value => p_effective_date);
93: --

Line 138: when hr_api.cannot_find_prog_unit then

134: ,p_attribute29 => p_attribute29
135: ,p_attribute30 => p_attribute30
136: );
137: exception
138: when hr_api.cannot_find_prog_unit then
139: hr_api.cannot_find_prog_unit_error
140: (p_module_name => 'CREATE_ELECTION_CONSTITUENCY'
141: ,p_hook_type => 'BP'
142: );

Line 139: hr_api.cannot_find_prog_unit_error

135: ,p_attribute30 => p_attribute30
136: );
137: exception
138: when hr_api.cannot_find_prog_unit then
139: hr_api.cannot_find_prog_unit_error
140: (p_module_name => 'CREATE_ELECTION_CONSTITUENCY'
141: ,p_hook_type => 'BP'
142: );
143:

Line 233: when hr_api.cannot_find_prog_unit then

229: ,p_object_version_number => l_object_version_number
230: );
231:
232: exception
233: when hr_api.cannot_find_prog_unit then
234: hr_api.cannot_find_prog_unit_error
235: (p_module_name => 'CREATE_ELECTION_CONSTITUENCY'
236: ,p_hook_type => 'AP'
237: );

Line 234: hr_api.cannot_find_prog_unit_error

230: );
231:
232: exception
233: when hr_api.cannot_find_prog_unit then
234: hr_api.cannot_find_prog_unit_error
235: (p_module_name => 'CREATE_ELECTION_CONSTITUENCY'
236: ,p_hook_type => 'AP'
237: );
238: end;

Line 243: raise hr_api.validate_enabled;

239: --
240: -- When in validation only mode raise the Validate_Enabled exception
241: --
242: if p_validate then
243: raise hr_api.validate_enabled;
244: end if;
245: --
246: -- Set all output arguments
247: --

Line 253: when hr_api.validate_enabled then

249: p_object_version_number := l_object_version_number;
250: --
251: hr_utility.set_location(' Leaving:'||l_proc, 70);
252: exception
253: when hr_api.validate_enabled then
254: --
255: -- As the Validate_Enabled exception has been raised
256: -- we must rollback to the savepoint
257: --

Line 292: ,p_election_id in number default hr_api.g_number

288: procedure update_election_constituency
289: (p_validate in boolean default false
290: ,p_effective_date in date
291: ,p_election_constituency_id in out nocopy number
292: ,p_election_id in number default hr_api.g_number
293: ,p_business_group_id in number default hr_api.g_number
294: ,p_constituency_id in number default hr_api.g_number
295: ,p_attribute_category in varchar2 default hr_api.g_varchar2
296: ,p_attribute1 in varchar2 default hr_api.g_varchar2

Line 293: ,p_business_group_id in number default hr_api.g_number

289: (p_validate in boolean default false
290: ,p_effective_date in date
291: ,p_election_constituency_id in out nocopy number
292: ,p_election_id in number default hr_api.g_number
293: ,p_business_group_id in number default hr_api.g_number
294: ,p_constituency_id in number default hr_api.g_number
295: ,p_attribute_category in varchar2 default hr_api.g_varchar2
296: ,p_attribute1 in varchar2 default hr_api.g_varchar2
297: ,p_attribute2 in varchar2 default hr_api.g_varchar2

Line 294: ,p_constituency_id in number default hr_api.g_number

290: ,p_effective_date in date
291: ,p_election_constituency_id in out nocopy number
292: ,p_election_id in number default hr_api.g_number
293: ,p_business_group_id in number default hr_api.g_number
294: ,p_constituency_id in number default hr_api.g_number
295: ,p_attribute_category in varchar2 default hr_api.g_varchar2
296: ,p_attribute1 in varchar2 default hr_api.g_varchar2
297: ,p_attribute2 in varchar2 default hr_api.g_varchar2
298: ,p_attribute3 in varchar2 default hr_api.g_varchar2

Line 295: ,p_attribute_category in varchar2 default hr_api.g_varchar2

291: ,p_election_constituency_id in out nocopy number
292: ,p_election_id in number default hr_api.g_number
293: ,p_business_group_id in number default hr_api.g_number
294: ,p_constituency_id in number default hr_api.g_number
295: ,p_attribute_category in varchar2 default hr_api.g_varchar2
296: ,p_attribute1 in varchar2 default hr_api.g_varchar2
297: ,p_attribute2 in varchar2 default hr_api.g_varchar2
298: ,p_attribute3 in varchar2 default hr_api.g_varchar2
299: ,p_attribute4 in varchar2 default hr_api.g_varchar2

Line 296: ,p_attribute1 in varchar2 default hr_api.g_varchar2

292: ,p_election_id in number default hr_api.g_number
293: ,p_business_group_id in number default hr_api.g_number
294: ,p_constituency_id in number default hr_api.g_number
295: ,p_attribute_category in varchar2 default hr_api.g_varchar2
296: ,p_attribute1 in varchar2 default hr_api.g_varchar2
297: ,p_attribute2 in varchar2 default hr_api.g_varchar2
298: ,p_attribute3 in varchar2 default hr_api.g_varchar2
299: ,p_attribute4 in varchar2 default hr_api.g_varchar2
300: ,p_attribute5 in varchar2 default hr_api.g_varchar2

Line 297: ,p_attribute2 in varchar2 default hr_api.g_varchar2

293: ,p_business_group_id in number default hr_api.g_number
294: ,p_constituency_id in number default hr_api.g_number
295: ,p_attribute_category in varchar2 default hr_api.g_varchar2
296: ,p_attribute1 in varchar2 default hr_api.g_varchar2
297: ,p_attribute2 in varchar2 default hr_api.g_varchar2
298: ,p_attribute3 in varchar2 default hr_api.g_varchar2
299: ,p_attribute4 in varchar2 default hr_api.g_varchar2
300: ,p_attribute5 in varchar2 default hr_api.g_varchar2
301: ,p_attribute6 in varchar2 default hr_api.g_varchar2

Line 298: ,p_attribute3 in varchar2 default hr_api.g_varchar2

294: ,p_constituency_id in number default hr_api.g_number
295: ,p_attribute_category in varchar2 default hr_api.g_varchar2
296: ,p_attribute1 in varchar2 default hr_api.g_varchar2
297: ,p_attribute2 in varchar2 default hr_api.g_varchar2
298: ,p_attribute3 in varchar2 default hr_api.g_varchar2
299: ,p_attribute4 in varchar2 default hr_api.g_varchar2
300: ,p_attribute5 in varchar2 default hr_api.g_varchar2
301: ,p_attribute6 in varchar2 default hr_api.g_varchar2
302: ,p_attribute7 in varchar2 default hr_api.g_varchar2

Line 299: ,p_attribute4 in varchar2 default hr_api.g_varchar2

295: ,p_attribute_category in varchar2 default hr_api.g_varchar2
296: ,p_attribute1 in varchar2 default hr_api.g_varchar2
297: ,p_attribute2 in varchar2 default hr_api.g_varchar2
298: ,p_attribute3 in varchar2 default hr_api.g_varchar2
299: ,p_attribute4 in varchar2 default hr_api.g_varchar2
300: ,p_attribute5 in varchar2 default hr_api.g_varchar2
301: ,p_attribute6 in varchar2 default hr_api.g_varchar2
302: ,p_attribute7 in varchar2 default hr_api.g_varchar2
303: ,p_attribute8 in varchar2 default hr_api.g_varchar2

Line 300: ,p_attribute5 in varchar2 default hr_api.g_varchar2

296: ,p_attribute1 in varchar2 default hr_api.g_varchar2
297: ,p_attribute2 in varchar2 default hr_api.g_varchar2
298: ,p_attribute3 in varchar2 default hr_api.g_varchar2
299: ,p_attribute4 in varchar2 default hr_api.g_varchar2
300: ,p_attribute5 in varchar2 default hr_api.g_varchar2
301: ,p_attribute6 in varchar2 default hr_api.g_varchar2
302: ,p_attribute7 in varchar2 default hr_api.g_varchar2
303: ,p_attribute8 in varchar2 default hr_api.g_varchar2
304: ,p_attribute9 in varchar2 default hr_api.g_varchar2

Line 301: ,p_attribute6 in varchar2 default hr_api.g_varchar2

297: ,p_attribute2 in varchar2 default hr_api.g_varchar2
298: ,p_attribute3 in varchar2 default hr_api.g_varchar2
299: ,p_attribute4 in varchar2 default hr_api.g_varchar2
300: ,p_attribute5 in varchar2 default hr_api.g_varchar2
301: ,p_attribute6 in varchar2 default hr_api.g_varchar2
302: ,p_attribute7 in varchar2 default hr_api.g_varchar2
303: ,p_attribute8 in varchar2 default hr_api.g_varchar2
304: ,p_attribute9 in varchar2 default hr_api.g_varchar2
305: ,p_attribute10 in varchar2 default hr_api.g_varchar2

Line 302: ,p_attribute7 in varchar2 default hr_api.g_varchar2

298: ,p_attribute3 in varchar2 default hr_api.g_varchar2
299: ,p_attribute4 in varchar2 default hr_api.g_varchar2
300: ,p_attribute5 in varchar2 default hr_api.g_varchar2
301: ,p_attribute6 in varchar2 default hr_api.g_varchar2
302: ,p_attribute7 in varchar2 default hr_api.g_varchar2
303: ,p_attribute8 in varchar2 default hr_api.g_varchar2
304: ,p_attribute9 in varchar2 default hr_api.g_varchar2
305: ,p_attribute10 in varchar2 default hr_api.g_varchar2
306: ,p_attribute11 in varchar2 default hr_api.g_varchar2

Line 303: ,p_attribute8 in varchar2 default hr_api.g_varchar2

299: ,p_attribute4 in varchar2 default hr_api.g_varchar2
300: ,p_attribute5 in varchar2 default hr_api.g_varchar2
301: ,p_attribute6 in varchar2 default hr_api.g_varchar2
302: ,p_attribute7 in varchar2 default hr_api.g_varchar2
303: ,p_attribute8 in varchar2 default hr_api.g_varchar2
304: ,p_attribute9 in varchar2 default hr_api.g_varchar2
305: ,p_attribute10 in varchar2 default hr_api.g_varchar2
306: ,p_attribute11 in varchar2 default hr_api.g_varchar2
307: ,p_attribute12 in varchar2 default hr_api.g_varchar2

Line 304: ,p_attribute9 in varchar2 default hr_api.g_varchar2

300: ,p_attribute5 in varchar2 default hr_api.g_varchar2
301: ,p_attribute6 in varchar2 default hr_api.g_varchar2
302: ,p_attribute7 in varchar2 default hr_api.g_varchar2
303: ,p_attribute8 in varchar2 default hr_api.g_varchar2
304: ,p_attribute9 in varchar2 default hr_api.g_varchar2
305: ,p_attribute10 in varchar2 default hr_api.g_varchar2
306: ,p_attribute11 in varchar2 default hr_api.g_varchar2
307: ,p_attribute12 in varchar2 default hr_api.g_varchar2
308: ,p_attribute13 in varchar2 default hr_api.g_varchar2

Line 305: ,p_attribute10 in varchar2 default hr_api.g_varchar2

301: ,p_attribute6 in varchar2 default hr_api.g_varchar2
302: ,p_attribute7 in varchar2 default hr_api.g_varchar2
303: ,p_attribute8 in varchar2 default hr_api.g_varchar2
304: ,p_attribute9 in varchar2 default hr_api.g_varchar2
305: ,p_attribute10 in varchar2 default hr_api.g_varchar2
306: ,p_attribute11 in varchar2 default hr_api.g_varchar2
307: ,p_attribute12 in varchar2 default hr_api.g_varchar2
308: ,p_attribute13 in varchar2 default hr_api.g_varchar2
309: ,p_attribute14 in varchar2 default hr_api.g_varchar2

Line 306: ,p_attribute11 in varchar2 default hr_api.g_varchar2

302: ,p_attribute7 in varchar2 default hr_api.g_varchar2
303: ,p_attribute8 in varchar2 default hr_api.g_varchar2
304: ,p_attribute9 in varchar2 default hr_api.g_varchar2
305: ,p_attribute10 in varchar2 default hr_api.g_varchar2
306: ,p_attribute11 in varchar2 default hr_api.g_varchar2
307: ,p_attribute12 in varchar2 default hr_api.g_varchar2
308: ,p_attribute13 in varchar2 default hr_api.g_varchar2
309: ,p_attribute14 in varchar2 default hr_api.g_varchar2
310: ,p_attribute15 in varchar2 default hr_api.g_varchar2

Line 307: ,p_attribute12 in varchar2 default hr_api.g_varchar2

303: ,p_attribute8 in varchar2 default hr_api.g_varchar2
304: ,p_attribute9 in varchar2 default hr_api.g_varchar2
305: ,p_attribute10 in varchar2 default hr_api.g_varchar2
306: ,p_attribute11 in varchar2 default hr_api.g_varchar2
307: ,p_attribute12 in varchar2 default hr_api.g_varchar2
308: ,p_attribute13 in varchar2 default hr_api.g_varchar2
309: ,p_attribute14 in varchar2 default hr_api.g_varchar2
310: ,p_attribute15 in varchar2 default hr_api.g_varchar2
311: ,p_attribute16 in varchar2 default hr_api.g_varchar2

Line 308: ,p_attribute13 in varchar2 default hr_api.g_varchar2

304: ,p_attribute9 in varchar2 default hr_api.g_varchar2
305: ,p_attribute10 in varchar2 default hr_api.g_varchar2
306: ,p_attribute11 in varchar2 default hr_api.g_varchar2
307: ,p_attribute12 in varchar2 default hr_api.g_varchar2
308: ,p_attribute13 in varchar2 default hr_api.g_varchar2
309: ,p_attribute14 in varchar2 default hr_api.g_varchar2
310: ,p_attribute15 in varchar2 default hr_api.g_varchar2
311: ,p_attribute16 in varchar2 default hr_api.g_varchar2
312: ,p_attribute17 in varchar2 default hr_api.g_varchar2

Line 309: ,p_attribute14 in varchar2 default hr_api.g_varchar2

305: ,p_attribute10 in varchar2 default hr_api.g_varchar2
306: ,p_attribute11 in varchar2 default hr_api.g_varchar2
307: ,p_attribute12 in varchar2 default hr_api.g_varchar2
308: ,p_attribute13 in varchar2 default hr_api.g_varchar2
309: ,p_attribute14 in varchar2 default hr_api.g_varchar2
310: ,p_attribute15 in varchar2 default hr_api.g_varchar2
311: ,p_attribute16 in varchar2 default hr_api.g_varchar2
312: ,p_attribute17 in varchar2 default hr_api.g_varchar2
313: ,p_attribute18 in varchar2 default hr_api.g_varchar2

Line 310: ,p_attribute15 in varchar2 default hr_api.g_varchar2

306: ,p_attribute11 in varchar2 default hr_api.g_varchar2
307: ,p_attribute12 in varchar2 default hr_api.g_varchar2
308: ,p_attribute13 in varchar2 default hr_api.g_varchar2
309: ,p_attribute14 in varchar2 default hr_api.g_varchar2
310: ,p_attribute15 in varchar2 default hr_api.g_varchar2
311: ,p_attribute16 in varchar2 default hr_api.g_varchar2
312: ,p_attribute17 in varchar2 default hr_api.g_varchar2
313: ,p_attribute18 in varchar2 default hr_api.g_varchar2
314: ,p_attribute19 in varchar2 default hr_api.g_varchar2

Line 311: ,p_attribute16 in varchar2 default hr_api.g_varchar2

307: ,p_attribute12 in varchar2 default hr_api.g_varchar2
308: ,p_attribute13 in varchar2 default hr_api.g_varchar2
309: ,p_attribute14 in varchar2 default hr_api.g_varchar2
310: ,p_attribute15 in varchar2 default hr_api.g_varchar2
311: ,p_attribute16 in varchar2 default hr_api.g_varchar2
312: ,p_attribute17 in varchar2 default hr_api.g_varchar2
313: ,p_attribute18 in varchar2 default hr_api.g_varchar2
314: ,p_attribute19 in varchar2 default hr_api.g_varchar2
315: ,p_attribute20 in varchar2 default hr_api.g_varchar2

Line 312: ,p_attribute17 in varchar2 default hr_api.g_varchar2

308: ,p_attribute13 in varchar2 default hr_api.g_varchar2
309: ,p_attribute14 in varchar2 default hr_api.g_varchar2
310: ,p_attribute15 in varchar2 default hr_api.g_varchar2
311: ,p_attribute16 in varchar2 default hr_api.g_varchar2
312: ,p_attribute17 in varchar2 default hr_api.g_varchar2
313: ,p_attribute18 in varchar2 default hr_api.g_varchar2
314: ,p_attribute19 in varchar2 default hr_api.g_varchar2
315: ,p_attribute20 in varchar2 default hr_api.g_varchar2
316: ,p_attribute21 in varchar2 default hr_api.g_varchar2

Line 313: ,p_attribute18 in varchar2 default hr_api.g_varchar2

309: ,p_attribute14 in varchar2 default hr_api.g_varchar2
310: ,p_attribute15 in varchar2 default hr_api.g_varchar2
311: ,p_attribute16 in varchar2 default hr_api.g_varchar2
312: ,p_attribute17 in varchar2 default hr_api.g_varchar2
313: ,p_attribute18 in varchar2 default hr_api.g_varchar2
314: ,p_attribute19 in varchar2 default hr_api.g_varchar2
315: ,p_attribute20 in varchar2 default hr_api.g_varchar2
316: ,p_attribute21 in varchar2 default hr_api.g_varchar2
317: ,p_attribute22 in varchar2 default hr_api.g_varchar2

Line 314: ,p_attribute19 in varchar2 default hr_api.g_varchar2

310: ,p_attribute15 in varchar2 default hr_api.g_varchar2
311: ,p_attribute16 in varchar2 default hr_api.g_varchar2
312: ,p_attribute17 in varchar2 default hr_api.g_varchar2
313: ,p_attribute18 in varchar2 default hr_api.g_varchar2
314: ,p_attribute19 in varchar2 default hr_api.g_varchar2
315: ,p_attribute20 in varchar2 default hr_api.g_varchar2
316: ,p_attribute21 in varchar2 default hr_api.g_varchar2
317: ,p_attribute22 in varchar2 default hr_api.g_varchar2
318: ,p_attribute23 in varchar2 default hr_api.g_varchar2

Line 315: ,p_attribute20 in varchar2 default hr_api.g_varchar2

311: ,p_attribute16 in varchar2 default hr_api.g_varchar2
312: ,p_attribute17 in varchar2 default hr_api.g_varchar2
313: ,p_attribute18 in varchar2 default hr_api.g_varchar2
314: ,p_attribute19 in varchar2 default hr_api.g_varchar2
315: ,p_attribute20 in varchar2 default hr_api.g_varchar2
316: ,p_attribute21 in varchar2 default hr_api.g_varchar2
317: ,p_attribute22 in varchar2 default hr_api.g_varchar2
318: ,p_attribute23 in varchar2 default hr_api.g_varchar2
319: ,p_attribute24 in varchar2 default hr_api.g_varchar2

Line 316: ,p_attribute21 in varchar2 default hr_api.g_varchar2

312: ,p_attribute17 in varchar2 default hr_api.g_varchar2
313: ,p_attribute18 in varchar2 default hr_api.g_varchar2
314: ,p_attribute19 in varchar2 default hr_api.g_varchar2
315: ,p_attribute20 in varchar2 default hr_api.g_varchar2
316: ,p_attribute21 in varchar2 default hr_api.g_varchar2
317: ,p_attribute22 in varchar2 default hr_api.g_varchar2
318: ,p_attribute23 in varchar2 default hr_api.g_varchar2
319: ,p_attribute24 in varchar2 default hr_api.g_varchar2
320: ,p_attribute25 in varchar2 default hr_api.g_varchar2

Line 317: ,p_attribute22 in varchar2 default hr_api.g_varchar2

313: ,p_attribute18 in varchar2 default hr_api.g_varchar2
314: ,p_attribute19 in varchar2 default hr_api.g_varchar2
315: ,p_attribute20 in varchar2 default hr_api.g_varchar2
316: ,p_attribute21 in varchar2 default hr_api.g_varchar2
317: ,p_attribute22 in varchar2 default hr_api.g_varchar2
318: ,p_attribute23 in varchar2 default hr_api.g_varchar2
319: ,p_attribute24 in varchar2 default hr_api.g_varchar2
320: ,p_attribute25 in varchar2 default hr_api.g_varchar2
321: ,p_attribute26 in varchar2 default hr_api.g_varchar2

Line 318: ,p_attribute23 in varchar2 default hr_api.g_varchar2

314: ,p_attribute19 in varchar2 default hr_api.g_varchar2
315: ,p_attribute20 in varchar2 default hr_api.g_varchar2
316: ,p_attribute21 in varchar2 default hr_api.g_varchar2
317: ,p_attribute22 in varchar2 default hr_api.g_varchar2
318: ,p_attribute23 in varchar2 default hr_api.g_varchar2
319: ,p_attribute24 in varchar2 default hr_api.g_varchar2
320: ,p_attribute25 in varchar2 default hr_api.g_varchar2
321: ,p_attribute26 in varchar2 default hr_api.g_varchar2
322: ,p_attribute27 in varchar2 default hr_api.g_varchar2

Line 319: ,p_attribute24 in varchar2 default hr_api.g_varchar2

315: ,p_attribute20 in varchar2 default hr_api.g_varchar2
316: ,p_attribute21 in varchar2 default hr_api.g_varchar2
317: ,p_attribute22 in varchar2 default hr_api.g_varchar2
318: ,p_attribute23 in varchar2 default hr_api.g_varchar2
319: ,p_attribute24 in varchar2 default hr_api.g_varchar2
320: ,p_attribute25 in varchar2 default hr_api.g_varchar2
321: ,p_attribute26 in varchar2 default hr_api.g_varchar2
322: ,p_attribute27 in varchar2 default hr_api.g_varchar2
323: ,p_attribute28 in varchar2 default hr_api.g_varchar2

Line 320: ,p_attribute25 in varchar2 default hr_api.g_varchar2

316: ,p_attribute21 in varchar2 default hr_api.g_varchar2
317: ,p_attribute22 in varchar2 default hr_api.g_varchar2
318: ,p_attribute23 in varchar2 default hr_api.g_varchar2
319: ,p_attribute24 in varchar2 default hr_api.g_varchar2
320: ,p_attribute25 in varchar2 default hr_api.g_varchar2
321: ,p_attribute26 in varchar2 default hr_api.g_varchar2
322: ,p_attribute27 in varchar2 default hr_api.g_varchar2
323: ,p_attribute28 in varchar2 default hr_api.g_varchar2
324: ,p_attribute29 in varchar2 default hr_api.g_varchar2

Line 321: ,p_attribute26 in varchar2 default hr_api.g_varchar2

317: ,p_attribute22 in varchar2 default hr_api.g_varchar2
318: ,p_attribute23 in varchar2 default hr_api.g_varchar2
319: ,p_attribute24 in varchar2 default hr_api.g_varchar2
320: ,p_attribute25 in varchar2 default hr_api.g_varchar2
321: ,p_attribute26 in varchar2 default hr_api.g_varchar2
322: ,p_attribute27 in varchar2 default hr_api.g_varchar2
323: ,p_attribute28 in varchar2 default hr_api.g_varchar2
324: ,p_attribute29 in varchar2 default hr_api.g_varchar2
325: ,p_attribute30 in varchar2 default hr_api.g_varchar2

Line 322: ,p_attribute27 in varchar2 default hr_api.g_varchar2

318: ,p_attribute23 in varchar2 default hr_api.g_varchar2
319: ,p_attribute24 in varchar2 default hr_api.g_varchar2
320: ,p_attribute25 in varchar2 default hr_api.g_varchar2
321: ,p_attribute26 in varchar2 default hr_api.g_varchar2
322: ,p_attribute27 in varchar2 default hr_api.g_varchar2
323: ,p_attribute28 in varchar2 default hr_api.g_varchar2
324: ,p_attribute29 in varchar2 default hr_api.g_varchar2
325: ,p_attribute30 in varchar2 default hr_api.g_varchar2
326: ,p_object_version_number in out nocopy number

Line 323: ,p_attribute28 in varchar2 default hr_api.g_varchar2

319: ,p_attribute24 in varchar2 default hr_api.g_varchar2
320: ,p_attribute25 in varchar2 default hr_api.g_varchar2
321: ,p_attribute26 in varchar2 default hr_api.g_varchar2
322: ,p_attribute27 in varchar2 default hr_api.g_varchar2
323: ,p_attribute28 in varchar2 default hr_api.g_varchar2
324: ,p_attribute29 in varchar2 default hr_api.g_varchar2
325: ,p_attribute30 in varchar2 default hr_api.g_varchar2
326: ,p_object_version_number in out nocopy number
327: ) is

Line 324: ,p_attribute29 in varchar2 default hr_api.g_varchar2

320: ,p_attribute25 in varchar2 default hr_api.g_varchar2
321: ,p_attribute26 in varchar2 default hr_api.g_varchar2
322: ,p_attribute27 in varchar2 default hr_api.g_varchar2
323: ,p_attribute28 in varchar2 default hr_api.g_varchar2
324: ,p_attribute29 in varchar2 default hr_api.g_varchar2
325: ,p_attribute30 in varchar2 default hr_api.g_varchar2
326: ,p_object_version_number in out nocopy number
327: ) is
328: --

Line 325: ,p_attribute30 in varchar2 default hr_api.g_varchar2

321: ,p_attribute26 in varchar2 default hr_api.g_varchar2
322: ,p_attribute27 in varchar2 default hr_api.g_varchar2
323: ,p_attribute28 in varchar2 default hr_api.g_varchar2
324: ,p_attribute29 in varchar2 default hr_api.g_varchar2
325: ,p_attribute30 in varchar2 default hr_api.g_varchar2
326: ,p_object_version_number in out nocopy number
327: ) is
328: --
329: -- Declare cursors and local variables

Line 350: hr_api.mandatory_arg_error

346: -- Check that p_constituency_id, p_business_group_id, election_id are not null.
347: --
348: hr_utility.set_location('Entering mandatory arg check', 20);
349: --
350: hr_api.mandatory_arg_error
351: (p_api_name => l_proc,
352: p_argument => 'constituency_id',
353: p_argument_value => p_constituency_id);
354: --

Line 355: hr_api.mandatory_arg_error

351: (p_api_name => l_proc,
352: p_argument => 'constituency_id',
353: p_argument_value => p_constituency_id);
354: --
355: hr_api.mandatory_arg_error
356: (p_api_name => l_proc,
357: p_argument => 'business_group_id',
358: p_argument_value => p_business_group_id);
359: --

Line 360: hr_api.mandatory_arg_error

356: (p_api_name => l_proc,
357: p_argument => 'business_group_id',
358: p_argument_value => p_business_group_id);
359: --
360: hr_api.mandatory_arg_error
361: (p_api_name => l_proc,
362: p_argument => 'effective_date',
363: p_argument_value => p_effective_date);
364: --

Line 365: hr_api.mandatory_arg_error

361: (p_api_name => l_proc,
362: p_argument => 'effective_date',
363: p_argument_value => p_effective_date);
364: --
365: hr_api.mandatory_arg_error
366: (p_api_name => l_proc,
367: p_argument => 'election_id',
368: p_argument_value => p_election_id);
369: --

Line 416: when hr_api.cannot_find_prog_unit then

412: ,p_attribute30 => p_attribute30
413: ,p_object_version_number => p_object_version_number
414: );
415: exception
416: when hr_api.cannot_find_prog_unit then
417: hr_api.cannot_find_prog_unit_error
418: (p_module_name => 'UPDATE_ELECTION_CONSTITUENCY'
419: ,p_hook_type => 'BP'
420: );

Line 417: hr_api.cannot_find_prog_unit_error

413: ,p_object_version_number => p_object_version_number
414: );
415: exception
416: when hr_api.cannot_find_prog_unit then
417: hr_api.cannot_find_prog_unit_error
418: (p_module_name => 'UPDATE_ELECTION_CONSTITUENCY'
419: ,p_hook_type => 'BP'
420: );
421:

Line 515: when hr_api.cannot_find_prog_unit then

511: ,p_object_version_number => p_object_version_number
512: );
513:
514: exception
515: when hr_api.cannot_find_prog_unit then
516: hr_api.cannot_find_prog_unit_error
517: (p_module_name => 'UPDATE_ELECTION_CONSTITUENCY'
518: ,p_hook_type => 'AP'
519: );

Line 516: hr_api.cannot_find_prog_unit_error

512: );
513:
514: exception
515: when hr_api.cannot_find_prog_unit then
516: hr_api.cannot_find_prog_unit_error
517: (p_module_name => 'UPDATE_ELECTION_CONSTITUENCY'
518: ,p_hook_type => 'AP'
519: );
520: end;

Line 525: raise hr_api.validate_enabled;

521: --
522: -- When in validation only mode raise the Validate_Enabled exception
523: --
524: if p_validate then
525: raise hr_api.validate_enabled;
526: end if;
527: --
528: --
529: hr_utility.set_location(' Leaving:'||l_proc, 70);

Line 531: when hr_api.validate_enabled then

527: --
528: --
529: hr_utility.set_location(' Leaving:'||l_proc, 70);
530: exception
531: when hr_api.validate_enabled then
532: --
533: -- As the Validate_Enabled exception has been raised
534: -- we must rollback to the savepoint
535: --

Line 592: hr_api.mandatory_arg_error

588: hr_utility.set_location(l_proc, 20);
589: --
590: -- Process Logic
591: --
592: hr_api.mandatory_arg_error
593: (p_api_name => l_proc
594: ,p_argument => 'election_constituency_id'
595: ,p_argument_value => p_election_constituency_id
596: );

Line 616: when hr_api.cannot_find_prog_unit then

612: p_election_constituency_id => p_election_constituency_id
613: ,p_object_version_number => l_object_version_number
614: );
615: exception
616: when hr_api.cannot_find_prog_unit then
617: hr_api.cannot_find_prog_unit_error
618: (p_module_name => 'delete_election_constituency'
619: ,p_hook_type => 'BP'
620: );

Line 617: hr_api.cannot_find_prog_unit_error

613: ,p_object_version_number => l_object_version_number
614: );
615: exception
616: when hr_api.cannot_find_prog_unit then
617: hr_api.cannot_find_prog_unit_error
618: (p_module_name => 'delete_election_constituency'
619: ,p_hook_type => 'BP'
620: );
621: --

Line 643: when hr_api.cannot_find_prog_unit then

639: (p_election_constituency_id => p_election_constituency_id
640: ,p_object_version_number => l_object_version_number
641: );
642: exception
643: when hr_api.cannot_find_prog_unit then
644: hr_api.cannot_find_prog_unit_error
645: (p_module_name => 'delete_election_constituency'
646: ,p_hook_type => 'AP'
647: );

Line 644: hr_api.cannot_find_prog_unit_error

640: ,p_object_version_number => l_object_version_number
641: );
642: exception
643: when hr_api.cannot_find_prog_unit then
644: hr_api.cannot_find_prog_unit_error
645: (p_module_name => 'delete_election_constituency'
646: ,p_hook_type => 'AP'
647: );
648: --

Line 658: raise hr_api.validate_enabled;

654: --
655: -- When in validation only mode raise the Validate_Enabled exception
656: --
657: if p_validate then
658: raise hr_api.validate_enabled;
659: end if;
660: --
661: hr_utility.set_location(' Leaving:'||l_proc, 70);
662: --

Line 665: when hr_api.validate_enabled then

661: hr_utility.set_location(' Leaving:'||l_proc, 70);
662: --
663: exception
664: --
665: when hr_api.validate_enabled then
666: --
667: -- As the Validate_Enabled exception has been raised
668: -- we must rollback to the savepoint
669: --