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.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 234: hr_utility.set_location('Entering:'|| l_proc, 10);

230: where assignment_id = p_assignment_id;
231: --
232: begin
233: --
234: hr_utility.set_location('Entering:'|| l_proc, 10);
235: --
236: hr_api.mandatory_arg_error
237: (p_api_name => l_proc
238: ,p_argument => 'assignment_id'

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

239: ,p_argument_value => p_assignment_id
240: );
241: --
242: --
243: hr_utility.set_location(l_proc,20);
244: --
245: open csr_applicant_assignment;
246: fetch csr_applicant_assignment Into l_assignment_id;
247: --

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

246: fetch csr_applicant_assignment Into l_assignment_id;
247: --
248: if csr_applicant_assignment%notfound then
249: --
250: hr_utility.set_location(l_proc,30);
251: --
252: close csr_applicant_assignment;
253: fnd_message.set_name ('PER', 'IRC_412006_ASG_NOT_APPL');
254: fnd_message.raise_error;

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

255: end if;
256: --
257: close csr_applicant_assignment;
258: --
259: hr_utility.set_location(' Leaving:'|| l_proc, 50);
260: --
261: exception
262: when app_exception.application_exception then
263: if hr_multi_message.exception_add

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

262: when app_exception.application_exception then
263: if hr_multi_message.exception_add
264: (p_associated_column1 => 'IRC_ASSIGNMENT_STATUSES.ASSIGNMENT_ID'
265: ) then
266: hr_utility.set_location(' Leaving:'|| l_proc, 60);
267: raise;
268: end if;
269: hr_utility.set_location(' Leaving:'|| l_proc, 70);
270: --

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

265: ) then
266: hr_utility.set_location(' Leaving:'|| l_proc, 60);
267: raise;
268: end if;
269: hr_utility.set_location(' Leaving:'|| l_proc, 70);
270: --
271: end chk_assignment_id;
272: --
273:

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

301: --
302:
303: begin
304: --
305: hr_utility.set_location('Entering:'|| l_proc, 10);
306: --
307: --
308: --
309: hr_utility.set_location(l_proc,20);

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

305: hr_utility.set_location('Entering:'|| l_proc, 10);
306: --
307: --
308: --
309: hr_utility.set_location(l_proc,20);
310: --
311:
312: --
313: if lengthb(p_comments)>500 then

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

311:
312: --
313: if lengthb(p_comments)>500 then
314: --
315: hr_utility.set_location(l_proc,30);
316: --
317: --- this message has to be changed to the new message
318: fnd_message.set_name ('PER', 'IRC_412599_COMMENT_LEN_EROOR');
319: fnd_message.raise_error;

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

319: fnd_message.raise_error;
320: end if;
321: --
322: --
323: hr_utility.set_location(' Leaving:'|| l_proc, 50);
324: --
325: exception
326: when app_exception.application_exception then
327: if hr_multi_message.exception_add

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

326: when app_exception.application_exception then
327: if hr_multi_message.exception_add
328: (p_associated_column1 => 'IRC_ASSIGNMENT_STATUSES.ASSIGNMENT_ID'
329: ) then
330: hr_utility.set_location(' Leaving:'|| l_proc, 60);
331: raise;
332: end if;
333: hr_utility.set_location(' Leaving:'|| l_proc, 70);
334: --

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

329: ) then
330: hr_utility.set_location(' Leaving:'|| l_proc, 60);
331: raise;
332: end if;
333: hr_utility.set_location(' Leaving:'|| l_proc, 70);
334: --
335: end chk_comments;
336:
337:

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

373: from PER_ASSIGNMENT_STATUS_TYPES
374: where ASSIGNMENT_STATUS_TYPE_ID = P_ASG_STATUS_TYPE_ID;
375: --
376: begin
377: hr_utility.set_location('Entering:'|| l_proc, 10);
378: hr_api.mandatory_arg_error
379: (p_api_name => l_proc
380: ,p_argument => 'ASSIGNMENT_STATUS_TYPE_ID'
381: ,p_argument_value => p_asg_status_type_id

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

382: );
383: --
384: open csr_exists;
385: fetch csr_exists into l_asg_status_type_id;
386: hr_utility.set_location(l_proc,20);
387: if csr_exists%notfound then
388: close csr_exists;
389: fnd_message.set_name ('PER','IRC_412007_REC_ASG_BAD');
390: fnd_message.raise_error;

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

390: fnd_message.raise_error;
391: end if;
392: close csr_exists;
393: --
394: hr_utility.set_location(' Leaving:'|| l_proc, 30);
395: --
396: exception
397: when app_exception.application_exception then
398: if hr_multi_message.exception_add

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

398: if hr_multi_message.exception_add
399: (p_associated_column1=>
400: 'IRC_ASSIGNMENT_STATUSES.ASSIGNMENT_STATUS_TYPE_ID'
401: ) then
402: hr_utility.set_location(' Leaving:'|| l_proc, 50);
403: raise;
404: end if;
405: hr_utility.set_location(' Leaving:'|| l_proc, 60);
406: end chk_assignment_status_type_id;

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

401: ) then
402: hr_utility.set_location(' Leaving:'|| l_proc, 50);
403: raise;
404: end if;
405: hr_utility.set_location(' Leaving:'|| l_proc, 60);
406: end chk_assignment_status_type_id;
407: --
408: -- ----------------------------------------------------------------------------
409: -- |---------------------------< insert_validate >----------------------------|

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

414: --
415: l_proc varchar2(72) := g_package||'insert_validate';
416: --
417: Begin
418: hr_utility.set_location('Entering:'||l_proc, 5);
419: chk_assignment_id
420: (p_assignment_id => p_rec.assignment_id
421: );
422: hr_utility.set_location(l_proc,10);

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

418: hr_utility.set_location('Entering:'||l_proc, 5);
419: chk_assignment_id
420: (p_assignment_id => p_rec.assignment_id
421: );
422: hr_utility.set_location(l_proc,10);
423: chk_assignment_status_type_id
424: (p_asg_status_type_id => p_rec.assignment_status_type_id
425: );
426: -- As this table does not have a mandatory business_group_id

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

426: -- As this table does not have a mandatory business_group_id
427: -- column, ensure client_info is populated by calling the
428: -- irc_ias_bus.set_security_group_id procedure
429: --
430: hr_utility.set_location(l_proc, 20);
431: irc_ias_bus.set_security_group_id
432: (p_assignment_id => p_rec.assignment_id
433: ,p_associated_column1 => irc_ias_shd.g_tab_nam||'.ASSIGNMENT_ID'
434: );

Line 435: hr_utility.set_location(l_proc, 25);

431: irc_ias_bus.set_security_group_id
432: (p_assignment_id => p_rec.assignment_id
433: ,p_associated_column1 => irc_ias_shd.g_tab_nam||'.ASSIGNMENT_ID'
434: );
435: hr_utility.set_location(l_proc, 25);
436:
437: chk_comments(p_comments => p_rec.status_change_comments);
438:
439:

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

436:
437: chk_comments(p_comments => p_rec.status_change_comments);
438:
439:
440: hr_utility.set_location(' Leaving:'||l_proc, 30);
441: End insert_validate;
442: --
443: -- ----------------------------------------------------------------------------
444: -- |---------------------------< update_validate >----------------------------|

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

449: --
450: l_proc varchar2(72) := g_package||'update_validate';
451: --
452: Begin
453: hr_utility.set_location('Entering:'||l_proc, 5);
454: --
455: -- Call all supporting business operations
456: --
457: --

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

454: --
455: -- Call all supporting business operations
456: --
457: --
458: hr_utility.set_location('Entering:'||l_proc, 15);
459: --
460: chk_non_updateable_args
461: (p_rec => p_rec
462: );

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

460: chk_non_updateable_args
461: (p_rec => p_rec
462: );
463: --
464: hr_utility.set_location('Entering:'||l_proc, 20);
465: --
466: chk_assignment_status_type_id
467: (p_asg_status_type_id => p_rec.assignment_status_type_id
468: );

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

469: --
470: --
471: chk_comments(p_comments => p_rec.status_change_comments);
472: --
473: hr_utility.set_location(' Leaving:'||l_proc, 30);
474: End update_validate;
475: --
476: -- ----------------------------------------------------------------------------
477: -- |---------------------------< delete_validate >----------------------------|

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

482: --
483: l_proc varchar2(72) := g_package||'delete_validate';
484: --
485: Begin
486: hr_utility.set_location('Entering:'||l_proc, 5);
487: --
488: -- Call all supporting business operations
489: --
490: hr_utility.set_location(' Leaving:'||l_proc, 10);

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

486: hr_utility.set_location('Entering:'||l_proc, 5);
487: --
488: -- Call all supporting business operations
489: --
490: hr_utility.set_location(' Leaving:'||l_proc, 10);
491: End delete_validate;
492: --
493: end irc_ias_bus;