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_CMR_BUS dependencies on HR_UTILITY

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

45: l_legislation_code varchar2(150);
46: --
47: begin
48: --
49: hr_utility.set_location('Entering:'|| l_proc, 10);
50: --
51: -- Ensure that all the mandatory parameter are not null
52: --
53: hr_api.mandatory_arg_error

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

85: --
86: hr_api.set_legislation_context(l_legislation_code);
87: end if;
88: --
89: hr_utility.set_location(' Leaving:'|| l_proc, 20);
90: --
91: end set_security_group_id;
92: --
93: -- ---------------------------------------------------------------------------

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

120: l_proc varchar2(72) := g_package||'return_legislation_code';
121: --
122: Begin
123: --
124: hr_utility.set_location('Entering:'|| l_proc, 10);
125: --
126: -- Ensure that all the mandatory parameter are not null
127: --
128: hr_api.mandatory_arg_error

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

138: -- call to this function. Just return the value in the global
139: -- variable.
140: --
141: l_legislation_code := irc_cmr_bus.g_legislation_code;
142: hr_utility.set_location(l_proc, 20);
143: else
144: --
145: -- The ID is different to the last call to this function
146: -- or this is the first call to this function.

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

155: close csr_leg_code;
156: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
157: fnd_message.raise_error;
158: end if;
159: hr_utility.set_location(l_proc,30);
160: --
161: -- Set the global variables so the values are
162: -- available for the next call to this function.
163: --

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

164: close csr_leg_code;
165: irc_cmr_bus.g_communication_recipient_id := p_communication_recipient_id;
166: irc_cmr_bus.g_legislation_code := l_legislation_code;
167: end if;
168: hr_utility.set_location(' Leaving:'|| l_proc, 40);
169: return l_legislation_code;
170: end return_legislation_code;
171: --
172: -- ----------------------------------------------------------------------------

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

286: where communication_topic_id = p_communication_object_id;
287: --
288: Begin
289: --
290: hr_utility.set_location(' Entering:'||l_proc,10);
291: --
292: hr_api.mandatory_arg_error
293: (p_api_name => l_proc
294: ,p_argument => 'COMMUNICATION_OBJECT_TYPE'

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

294: ,p_argument => 'COMMUNICATION_OBJECT_TYPE'
295: ,p_argument_value => p_communication_object_type
296: );
297: --
298: hr_utility.set_location(' Entering:'||l_proc,20);
299: --
300: hr_api.mandatory_arg_error
301: (p_api_name => l_proc
302: ,p_argument => 'COMMUNICATION_OBJECT_ID'

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

306: if p_communication_object_type = 'TOPIC' then
307: open csr_comm_topic;
308: fetch csr_comm_topic into l_comm_object_id;
309: --
310: hr_utility.set_location(l_proc,30);
311: --
312: if csr_comm_topic%notfound then
313: close csr_comm_topic;
314: fnd_message.set_name('PER','IRC_412393_BAD_COMM_OBJ_ID');

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

314: fnd_message.set_name('PER','IRC_412393_BAD_COMM_OBJ_ID');
315: fnd_message.raise_error;
316: end if;
317: --
318: hr_utility.set_location(l_proc,40);
319: --
320: close csr_comm_topic;
321: end if;
322: exception

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

325: (p_associated_column1 => 'IRC_COMM_RECIPIENTS.COMMUNICATION_OBJECT_TYPE'
326: ,p_associated_column2 => 'IRC_COMM_RECIPIENTS.COMMUNICATION_OBJECT_ID'
327: ) then
328: --
329: hr_utility.set_location(' Leaving:'||l_proc,50);
330: --
331: raise;
332: end if;
333: --

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

330: --
331: raise;
332: end if;
333: --
334: hr_utility.set_location(' Leaving:'||l_proc,60);
335: --
336: End chk_communication_object;
337: --
338: -- ----------------------------------------------------------------------------

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

379: and recipient_id = p_recipient_id;
380: --
381: Begin
382: --
383: hr_utility.set_location(' Entering:'||l_proc,10);
384: --
385: hr_api.mandatory_arg_error
386: (p_api_name => l_proc
387: ,p_argument => 'RECIPIENT_TYPE'

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

387: ,p_argument => 'RECIPIENT_TYPE'
388: ,p_argument_value => p_recipient_type
389: );
390: --
391: hr_utility.set_location(' Entering:'||l_proc,20);
392: --
393: hr_api.mandatory_arg_error
394: (p_api_name => l_proc
395: ,p_argument => 'RECIPIENT_ID'

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

399: if p_recipient_type = 'PERSON' then
400: open csr_recipient_person;
401: fetch csr_recipient_person into l_recipient_id;
402: --
403: hr_utility.set_location(l_proc,30);
404: --
405: if csr_recipient_person%notfound then
406: close csr_recipient_person;
407: fnd_message.set_name('PER','IRC_412394_BAD_RECIPIENT_ID');

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

407: fnd_message.set_name('PER','IRC_412394_BAD_RECIPIENT_ID');
408: fnd_message.raise_error;
409: end if;
410: --
411: hr_utility.set_location(l_proc,40);
412: --
413: close csr_recipient_person;
414: end if;
415: if p_recipient_type = 'AGENCY' then

Line 419: hr_utility.set_location(l_proc,50);

415: if p_recipient_type = 'AGENCY' then
416: open csr_recipient_agency;
417: fetch csr_recipient_agency into l_recipient_id;
418: --
419: hr_utility.set_location(l_proc,50);
420: --
421: if csr_recipient_agency%notfound then
422: close csr_recipient_agency;
423: fnd_message.set_name('PER','IRC_412395_BAD_RECIPIENT_ID');

Line 427: hr_utility.set_location(l_proc,60);

423: fnd_message.set_name('PER','IRC_412395_BAD_RECIPIENT_ID');
424: fnd_message.raise_error;
425: end if;
426: --
427: hr_utility.set_location(l_proc,60);
428: --
429: close csr_recipient_agency;
430: end if;
431: open csr_recipient;

Line 434: hr_utility.set_location(l_proc,70);

430: end if;
431: open csr_recipient;
432: fetch csr_recipient into l_recipient_id;
433: --
434: hr_utility.set_location(l_proc,70);
435: --
436: if csr_recipient%found then
437: close csr_recipient;
438: fnd_message.set_name('PER','IRC_412396_ALREADY_RECIPIENT');

Line 442: hr_utility.set_location(l_proc,80);

438: fnd_message.set_name('PER','IRC_412396_ALREADY_RECIPIENT');
439: fnd_message.raise_error;
440: end if;
441: --
442: hr_utility.set_location(l_proc,80);
443: --
444: close csr_recipient;
445: --
446: exception

Line 453: hr_utility.set_location(' Leaving:'||l_proc,90);

449: (p_associated_column1 => 'IRC_COMM_RECIPIENTS.RECIPIENT_TYPE'
450: ,p_associated_column2 => 'IRC_COMM_RECIPIENTS.RECIPIENT_ID'
451: ) then
452: --
453: hr_utility.set_location(' Leaving:'||l_proc,90);
454: --
455: raise;
456: end if;
457: --

Line 458: hr_utility.set_location(' Leaving:'||l_proc,100);

454: --
455: raise;
456: end if;
457: --
458: hr_utility.set_location(' Leaving:'||l_proc,100);
459: --
460: End chk_recipient;
461: --
462: -- ----------------------------------------------------------------------------

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

483: --
484: --
485: Begin
486: --
487: hr_utility.set_location(' Entering:'||l_proc,10);
488: --
489: hr_api.mandatory_arg_error
490: (p_api_name => l_proc
491: ,p_argument => 'MESSAGE_POST_DATE'

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

503: (p_associated_column1 => 'IRC_COMM_RECIPIENTS.START_DATE_ACTIVE'
504: ,p_associated_column2 => 'IRC_COMM_RECIPIENTS.END_DATE_ACTIVE'
505: ) then
506: --
507: hr_utility.set_location(' Leaving:'||l_proc,20);
508: --
509: raise;
510: end if;
511: --

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

508: --
509: raise;
510: end if;
511: --
512: hr_utility.set_location(' Leaving:'||l_proc,30);
513: --
514: End chk_active_dates;
515: --
516: -- ----------------------------------------------------------------------------

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

524: --
525: --
526: Begin
527: --
528: hr_utility.set_location(' Entering:'||l_proc,10);
529: --
530: if p_primary_flag <> 'Y' and p_primary_flag <> 'N' then
531: --
532: -- raise error

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

530: if p_primary_flag <> 'Y' and p_primary_flag <> 'N' then
531: --
532: -- raise error
533: --
534: hr_utility.set_location('Leaving: '|| l_proc, 20);
535: hr_utility.set_message(800,'IRC_412398_INVALID_PRIMARY_FLAG');
536: hr_utility.raise_error;
537: end if;
538: --

Line 535: hr_utility.set_message(800,'IRC_412398_INVALID_PRIMARY_FLAG');

531: --
532: -- raise error
533: --
534: hr_utility.set_location('Leaving: '|| l_proc, 20);
535: hr_utility.set_message(800,'IRC_412398_INVALID_PRIMARY_FLAG');
536: hr_utility.raise_error;
537: end if;
538: --
539: exception

Line 536: hr_utility.raise_error;

532: -- raise error
533: --
534: hr_utility.set_location('Leaving: '|| l_proc, 20);
535: hr_utility.set_message(800,'IRC_412398_INVALID_PRIMARY_FLAG');
536: hr_utility.raise_error;
537: end if;
538: --
539: exception
540: when app_exception.application_exception then

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

541: if hr_multi_message.exception_add
542: (p_associated_column1 => 'IRC_COMM_RECIPIENTS.PRIMARY_FLAG'
543: ) then
544: --
545: hr_utility.set_location(' Leaving:'||l_proc,30);
546: --
547: raise;
548: end if;
549: --

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

546: --
547: raise;
548: end if;
549: --
550: hr_utility.set_location(' Leaving:'||l_proc,40);
551: --
552: End chk_primary_flag;
553: --
554: -- ----------------------------------------------------------------------------

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

561: --
562: l_proc varchar2(72) := g_package||'insert_validate';
563: --
564: Begin
565: hr_utility.set_location('Entering:'||l_proc, 5);
566: --
567: -- Call all supporting business operations
568: --
569: --

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

579: chk_communication_object
580: (p_communication_object_type => p_rec.communication_object_type
581: ,p_communication_object_id => p_rec.communication_object_id);
582: --
583: hr_utility.set_location(' Leaving:'||l_proc, 10);
584: --
585: chk_recipient
586: (p_recipient_type => p_rec.recipient_type
587: ,p_recipient_id => p_rec.recipient_id

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

587: ,p_recipient_id => p_rec.recipient_id
588: ,p_communication_object_type => p_rec.communication_object_type
589: ,p_communication_object_id => p_rec.communication_object_id);
590: --
591: hr_utility.set_location(' Leaving:'||l_proc, 20);
592: --
593: chk_active_dates
594: (p_start_date_active => p_rec.start_date_active
595: ,p_end_date_active => p_rec.end_date_active);

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

593: chk_active_dates
594: (p_start_date_active => p_rec.start_date_active
595: ,p_end_date_active => p_rec.end_date_active);
596: --
597: hr_utility.set_location(' Leaving:'||l_proc, 30);
598: --
599: chk_primary_flag(p_rec.primary_flag);
600: --
601: hr_utility.set_location(' Leaving:'||l_proc, 40);

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

597: hr_utility.set_location(' Leaving:'||l_proc, 30);
598: --
599: chk_primary_flag(p_rec.primary_flag);
600: --
601: hr_utility.set_location(' Leaving:'||l_proc, 40);
602: --
603: End insert_validate;
604: --
605: -- ----------------------------------------------------------------------------

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

612: --
613: l_proc varchar2(72) := g_package||'update_validate';
614: --
615: Begin
616: hr_utility.set_location('Entering:'||l_proc, 5);
617: --
618: -- Call all supporting business operations
619: --
620: --

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

631: (p_effective_date => p_effective_date
632: ,p_rec => p_rec
633: );
634: --
635: hr_utility.set_location(' Leaving:'||l_proc, 10);
636: --
637: chk_communication_object
638: (p_communication_object_type => p_rec.communication_object_type
639: ,p_communication_object_id => p_rec.communication_object_id);

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

637: chk_communication_object
638: (p_communication_object_type => p_rec.communication_object_type
639: ,p_communication_object_id => p_rec.communication_object_id);
640: --
641: hr_utility.set_location(' Leaving:'||l_proc, 20);
642: --
643: chk_recipient
644: (p_recipient_type => p_rec.recipient_type
645: ,p_recipient_id => p_rec.recipient_id

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

645: ,p_recipient_id => p_rec.recipient_id
646: ,p_communication_object_type => p_rec.communication_object_type
647: ,p_communication_object_id => p_rec.communication_object_id);
648: --
649: hr_utility.set_location(' Leaving:'||l_proc, 30);
650: --
651: chk_active_dates
652: (p_start_date_active => p_rec.start_date_active
653: ,p_end_date_active => p_rec.end_date_active);

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

651: chk_active_dates
652: (p_start_date_active => p_rec.start_date_active
653: ,p_end_date_active => p_rec.end_date_active);
654: --
655: hr_utility.set_location(' Leaving:'||l_proc, 40);
656: --
657: chk_primary_flag(p_rec.primary_flag);
658: --
659: hr_utility.set_location(' Leaving:'||l_proc, 50);

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

655: hr_utility.set_location(' Leaving:'||l_proc, 40);
656: --
657: chk_primary_flag(p_rec.primary_flag);
658: --
659: hr_utility.set_location(' Leaving:'||l_proc, 50);
660: --
661: End update_validate;
662: --
663: -- ----------------------------------------------------------------------------

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

669: --
670: l_proc varchar2(72) := g_package||'delete_validate';
671: --
672: Begin
673: hr_utility.set_location('Entering:'||l_proc, 5);
674: --
675: -- Call all supporting business operations
676: --
677: hr_utility.set_location(' Leaving:'||l_proc, 10);

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

673: hr_utility.set_location('Entering:'||l_proc, 5);
674: --
675: -- Call all supporting business operations
676: --
677: hr_utility.set_location(' Leaving:'||l_proc, 10);
678: End delete_validate;
679: --
680: end irc_cmr_bus;