DBA Data[Home] [Help]

APPS.IRC_IAS_BUS dependencies on HR_UTILITY

Line 41: hr_utility.set_location('Entering:'|| l_proc, 10);

37: l_proc varchar2(72) := g_package||'set_security_group_id';
38: --
39: begin
40: --
41: hr_utility.set_location('Entering:'|| l_proc, 10);
42: --
43: -- Ensure that all the mandatory parameter are not null
44: --
45: open csr_sec_grp;

Line 70: hr_utility.set_location(' Leaving:'|| l_proc, 20);

66: (p_security_group_id => l_security_group_id
67: );
68: end if;
69: --
70: hr_utility.set_location(' Leaving:'|| l_proc, 20);
71: --
72: end set_security_group_id;
73: --
74: -- ---------------------------------------------------------------------------

Line 101: hr_utility.set_location('Entering:'|| l_proc, 10);

97: l_proc varchar2(72) := g_package||'return_legislation_code';
98: --
99: Begin
100: --
101: hr_utility.set_location('Entering:'|| l_proc, 10);
102: --
103: -- Ensure that all the mandatory parameter are not null
104: --
105: --

Line 114: hr_utility.set_location(l_proc, 20);

110: -- call to this function. Just return the value in the global
111: -- variable.
112: --
113: l_legislation_code := irc_ias_bus.g_legislation_code;
114: hr_utility.set_location(l_proc, 20);
115: else
116: --
117: -- The ID is different to the last call to this function
118: -- or this is the first call to this function.

Line 131: hr_utility.set_location(l_proc,30);

127: close csr_leg_code;
128: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
129: fnd_message.raise_error;
130: end if;
131: hr_utility.set_location(l_proc,30);
132: --
133: -- Set the global variables so the values are
134: -- available for the next call to this function.
135: --

Line 140: hr_utility.set_location(' Leaving:'|| l_proc, 40);

136: close csr_leg_code;
137: irc_ias_bus.g_assignment_status_id := p_assignment_status_id;
138: irc_ias_bus.g_legislation_code := l_legislation_code;
139: end if;
140: hr_utility.set_location(' Leaving:'|| l_proc, 40);
141: return l_legislation_code;
142: end return_legislation_code;
143: --
144: -- ----------------------------------------------------------------------------

Line 245: hr_utility.set_location('Entering:'|| l_proc, 10);

241: and paaf2.assignment_type = 'A');
242: --
243: begin
244: --
245: hr_utility.set_location('Entering:'|| l_proc, 10);
246: --
247: hr_api.mandatory_arg_error
248: (p_api_name => l_proc
249: ,p_argument => 'assignment_id'

Line 254: hr_utility.set_location(l_proc,20);

250: ,p_argument_value => p_assignment_id
251: );
252: --
253: --
254: hr_utility.set_location(l_proc,20);
255: --
256: open csr_applicant_assignment;
257: fetch csr_applicant_assignment Into l_assignment_id;
258: --

Line 261: hr_utility.set_location(l_proc,30);

257: fetch csr_applicant_assignment Into l_assignment_id;
258: --
259: if csr_applicant_assignment%notfound then
260: --
261: hr_utility.set_location(l_proc,30);
262: --
263: open csr_emp_applicant_assignment;
264: fetch csr_emp_applicant_assignment Into l_assignment_id;
265: --

Line 267: hr_utility.set_location(l_proc,40);

263: open csr_emp_applicant_assignment;
264: fetch csr_emp_applicant_assignment Into l_assignment_id;
265: --
266: if csr_emp_applicant_assignment%notfound then
267: hr_utility.set_location(l_proc,40);
268: close csr_emp_applicant_assignment;
269: close csr_applicant_assignment;
270: fnd_message.set_name ('PER', 'IRC_412006_ASG_NOT_APPL');
271: fnd_message.raise_error;

Line 279: hr_utility.set_location(' Leaving:'|| l_proc, 50);

275: end if;
276: --
277: close csr_applicant_assignment;
278: --
279: hr_utility.set_location(' Leaving:'|| l_proc, 50);
280: --
281: exception
282: when app_exception.application_exception then
283: if hr_multi_message.exception_add

Line 286: hr_utility.set_location(' Leaving:'|| l_proc, 60);

282: when app_exception.application_exception then
283: if hr_multi_message.exception_add
284: (p_associated_column1 => 'IRC_ASSIGNMENT_STATUSES.ASSIGNMENT_ID'
285: ) then
286: hr_utility.set_location(' Leaving:'|| l_proc, 60);
287: raise;
288: end if;
289: hr_utility.set_location(' Leaving:'|| l_proc, 70);
290: --

Line 289: hr_utility.set_location(' Leaving:'|| l_proc, 70);

285: ) then
286: hr_utility.set_location(' Leaving:'|| l_proc, 60);
287: raise;
288: end if;
289: hr_utility.set_location(' Leaving:'|| l_proc, 70);
290: --
291: end chk_assignment_id;
292: --
293: -- ----------------------------------------------------------------------------

Line 331: hr_utility.set_location('Entering:'|| l_proc, 10);

327: from PER_ASSIGNMENT_STATUS_TYPES
328: where ASSIGNMENT_STATUS_TYPE_ID = P_ASG_STATUS_TYPE_ID;
329: --
330: begin
331: hr_utility.set_location('Entering:'|| l_proc, 10);
332: hr_api.mandatory_arg_error
333: (p_api_name => l_proc
334: ,p_argument => 'ASSIGNMENT_STATUS_TYPE_ID'
335: ,p_argument_value => p_asg_status_type_id

Line 340: hr_utility.set_location(l_proc,20);

336: );
337: --
338: open csr_exists;
339: fetch csr_exists into l_asg_status_type_id;
340: hr_utility.set_location(l_proc,20);
341: if csr_exists%notfound then
342: close csr_exists;
343: fnd_message.set_name ('PER','IRC_412007_REC_ASG_BAD');
344: fnd_message.raise_error;

Line 348: hr_utility.set_location(' Leaving:'|| l_proc, 30);

344: fnd_message.raise_error;
345: end if;
346: close csr_exists;
347: --
348: hr_utility.set_location(' Leaving:'|| l_proc, 30);
349: --
350: exception
351: when app_exception.application_exception then
352: if hr_multi_message.exception_add

Line 356: hr_utility.set_location(' Leaving:'|| l_proc, 50);

352: if hr_multi_message.exception_add
353: (p_associated_column1=>
354: 'IRC_ASSIGNMENT_STATUSES.ASSIGNMENT_STATUS_TYPE_ID'
355: ) then
356: hr_utility.set_location(' Leaving:'|| l_proc, 50);
357: raise;
358: end if;
359: hr_utility.set_location(' Leaving:'|| l_proc, 60);
360: end chk_assignment_status_type_id;

Line 359: hr_utility.set_location(' Leaving:'|| l_proc, 60);

355: ) then
356: hr_utility.set_location(' Leaving:'|| l_proc, 50);
357: raise;
358: end if;
359: hr_utility.set_location(' Leaving:'|| l_proc, 60);
360: end chk_assignment_status_type_id;
361: --
362: -- ----------------------------------------------------------------------------
363: -- |---------------------------< insert_validate >----------------------------|

Line 372: hr_utility.set_location('Entering:'||l_proc, 5);

368: --
369: l_proc varchar2(72) := g_package||'insert_validate';
370: --
371: Begin
372: hr_utility.set_location('Entering:'||l_proc, 5);
373: chk_assignment_id
374: (p_assignment_id => p_rec.assignment_id
375: );
376: hr_utility.set_location(l_proc,10);

Line 376: hr_utility.set_location(l_proc,10);

372: hr_utility.set_location('Entering:'||l_proc, 5);
373: chk_assignment_id
374: (p_assignment_id => p_rec.assignment_id
375: );
376: hr_utility.set_location(l_proc,10);
377: chk_assignment_status_type_id
378: (p_asg_status_type_id => p_rec.assignment_status_type_id
379: );
380: -- As this table does not have a mandatory business_group_id

Line 384: hr_utility.set_location(l_proc, 20);

380: -- As this table does not have a mandatory business_group_id
381: -- column, ensure client_info is populated by calling the
382: -- irc_ias_bus.set_security_group_id procedure
383: --
384: hr_utility.set_location(l_proc, 20);
385: irc_ias_bus.set_security_group_id
386: (p_assignment_id => p_rec.assignment_id
387: ,p_associated_column1 => irc_ias_shd.g_tab_nam||'.ASSIGNMENT_ID'
388: );

Line 389: hr_utility.set_location(' Leaving:'||l_proc, 30);

385: irc_ias_bus.set_security_group_id
386: (p_assignment_id => p_rec.assignment_id
387: ,p_associated_column1 => irc_ias_shd.g_tab_nam||'.ASSIGNMENT_ID'
388: );
389: hr_utility.set_location(' Leaving:'||l_proc, 30);
390: End insert_validate;
391: --
392: -- ----------------------------------------------------------------------------
393: -- |---------------------------< update_validate >----------------------------|

Line 402: hr_utility.set_location('Entering:'||l_proc, 5);

398: --
399: l_proc varchar2(72) := g_package||'update_validate';
400: --
401: Begin
402: hr_utility.set_location('Entering:'||l_proc, 5);
403: --
404: -- Call all supporting business operations
405: --
406: --

Line 407: hr_utility.set_location('Entering:'||l_proc, 15);

403: --
404: -- Call all supporting business operations
405: --
406: --
407: hr_utility.set_location('Entering:'||l_proc, 15);
408: --
409: chk_non_updateable_args
410: (p_rec => p_rec
411: );

Line 413: hr_utility.set_location('Entering:'||l_proc, 20);

409: chk_non_updateable_args
410: (p_rec => p_rec
411: );
412: --
413: hr_utility.set_location('Entering:'||l_proc, 20);
414: --
415: chk_assignment_status_type_id
416: (p_asg_status_type_id => p_rec.assignment_status_type_id
417: );

Line 421: hr_utility.set_location(' Leaving:'||l_proc, 30);

417: );
418: --
419: --
420: --
421: hr_utility.set_location(' Leaving:'||l_proc, 30);
422: End update_validate;
423: --
424: -- ----------------------------------------------------------------------------
425: -- |---------------------------< delete_validate >----------------------------|

Line 434: hr_utility.set_location('Entering:'||l_proc, 5);

430: --
431: l_proc varchar2(72) := g_package||'delete_validate';
432: --
433: Begin
434: hr_utility.set_location('Entering:'||l_proc, 5);
435: --
436: -- Call all supporting business operations
437: --
438: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 438: hr_utility.set_location(' Leaving:'||l_proc, 10);

434: hr_utility.set_location('Entering:'||l_proc, 5);
435: --
436: -- Call all supporting business operations
437: --
438: hr_utility.set_location(' Leaving:'||l_proc, 10);
439: End delete_validate;
440: --
441: end irc_ias_bus;