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_CMM_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_cmm_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_cmm_bus.g_communication_message_id := p_communication_message_id;
166: irc_cmm_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 299: hr_utility.set_location(' Entering:'||l_proc,10);

295: --
296: --
297: Begin
298: --
299: hr_utility.set_location(' Entering:'||l_proc,10);
300: --
301: hr_api.mandatory_arg_error
302: (p_api_name => l_proc
303: ,p_argument => 'COMMUNICATION_TOPIC_ID'

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

306: --
307: open csr_topic_id;
308: fetch csr_topic_id into l_topic_id;
309: --
310: hr_utility.set_location(l_proc,20);
311: --
312: if csr_topic_id%notfound then
313: close csr_topic_id;
314: fnd_message.set_name('PER','IRC_412398_BAD_TOPIC_ID');

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

314: fnd_message.set_name('PER','IRC_412398_BAD_TOPIC_ID');
315: fnd_message.raise_error;
316: end if;
317: --
318: hr_utility.set_location(l_proc,30);
319: --
320: close csr_topic_id;
321: --
322: hr_utility.set_location(' Leaving:'||l_proc,40);

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

318: hr_utility.set_location(l_proc,30);
319: --
320: close csr_topic_id;
321: --
322: hr_utility.set_location(' Leaving:'||l_proc,40);
323: --
324: exception
325: when app_exception.application_exception then
326: if hr_multi_message.exception_add

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

326: if hr_multi_message.exception_add
327: (p_associated_column1 => 'IRC_COMM_MESSAGES.COMMUNICATION_TOPIC_ID'
328: ) then
329: --
330: hr_utility.set_location(' Leaving:'||l_proc,50);
331: --
332: raise;
333: end if;
334: --

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

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

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

359: --
360: --
361: Begin
362: --
363: hr_utility.set_location(' Entering:'||l_proc,10);
364: --
365: /*
366: hr_api.mandatory_arg_error
367: (p_api_name => l_proc

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

374: fnd_message.set_name('PER','IRC_412399_LONG_MSG_SUB');
375: fnd_message.raise_error;
376: end if;
377: --
378: hr_utility.set_location(l_proc,20);
379: --
380: exception
381: when app_exception.application_exception then
382: if hr_multi_message.exception_add

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

382: if hr_multi_message.exception_add
383: (p_associated_column1 => 'IRC_COMM_MESSAGES.MESSAGE_SUBJECT'
384: ) then
385: --
386: hr_utility.set_location(' Leaving:'||l_proc,30);
387: --
388: raise;
389: end if;
390: --

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

387: --
388: raise;
389: end if;
390: --
391: hr_utility.set_location(' Leaving:'||l_proc,40);
392: --
393: End chk_message_subject;
394: --
395: -- ----------------------------------------------------------------------------

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

415: --
416: --
417: Begin
418: --
419: hr_utility.set_location(' Entering:'||l_proc,10);
420: --
421: if p_message_body is null or length(p_message_body) = 0 then
422: fnd_message.set_name('PER','IRC_412247_NULL_MSG_BODY');
423: fnd_message.raise_error;

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

427: fnd_message.set_name('PER','IRC_412400_LONG_MSG_BODY');
428: fnd_message.raise_error;
429: end if;
430: --
431: hr_utility.set_location(l_proc,20);
432: --
433: exception
434: when app_exception.application_exception then
435: if hr_multi_message.exception_add

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

435: if hr_multi_message.exception_add
436: (p_associated_column1 => 'IRC_COMM_MESSAGES.MESSAGE_BODY'
437: ) then
438: --
439: hr_utility.set_location(' Leaving:'||l_proc,30);
440: --
441: raise;
442: end if;
443: --

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

440: --
441: raise;
442: end if;
443: --
444: hr_utility.set_location(' Leaving:'||l_proc,40);
445: --
446: End chk_message_body;
447: --
448: -- ----------------------------------------------------------------------------

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

468: --
469: --
470: Begin
471: --
472: hr_utility.set_location(' Entering:'||l_proc,10);
473: --
474: hr_api.mandatory_arg_error
475: (p_api_name => l_proc
476: ,p_argument => 'MESSAGE_POST_DATE'

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

482: if hr_multi_message.exception_add
483: (p_associated_column1 => 'IRC_COMM_MESSAGES.MESSAGE_POST_DATE'
484: ) then
485: --
486: hr_utility.set_location(' Leaving:'||l_proc,20);
487: --
488: raise;
489: end if;
490: --

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

487: --
488: raise;
489: end if;
490: --
491: hr_utility.set_location(' Leaving:'||l_proc,30);
492: --
493: End chk_message_post_date;
494: --
495: -- ----------------------------------------------------------------------------

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

526: where vendor_id = p_sender_id;
527: --
528: Begin
529: --
530: hr_utility.set_location(' Entering:'||l_proc,10);
531: --
532: hr_api.mandatory_arg_error
533: (p_api_name => l_proc
534: ,p_argument => 'SENDER_TYPE'

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

534: ,p_argument => 'SENDER_TYPE'
535: ,p_argument_value => p_sender_type
536: );
537: --
538: hr_utility.set_location(' Entering:'||l_proc,20);
539: --
540: hr_api.mandatory_arg_error
541: (p_api_name => l_proc
542: ,p_argument => 'SENDER_ID'

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

546: if p_sender_type = 'PERSON' then
547: open csr_sender;
548: fetch csr_sender into l_sender_id;
549: --
550: hr_utility.set_location(l_proc,30);
551: --
552: if csr_sender%notfound then
553: close csr_sender;
554: fnd_message.set_name('PER','IRC_412401_BAD_SENDER_ID');

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

554: fnd_message.set_name('PER','IRC_412401_BAD_SENDER_ID');
555: fnd_message.raise_error;
556: end if;
557: --
558: hr_utility.set_location(l_proc,40);
559: --
560: close csr_sender;
561: end if;
562: if p_sender_type = 'VENDOR' then

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

562: if p_sender_type = 'VENDOR' then
563: open csr_sender_agency;
564: fetch csr_sender_agency into l_sender_id;
565: --
566: hr_utility.set_location(l_proc,50);
567: --
568: if csr_sender_agency%notfound then
569: close csr_sender_agency;
570: fnd_message.set_name('PER','IRC_412402_BAD_SENDER_ID');

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

570: fnd_message.set_name('PER','IRC_412402_BAD_SENDER_ID');
571: fnd_message.raise_error;
572: end if;
573: --
574: hr_utility.set_location(l_proc,60);
575: --
576: close csr_sender_agency;
577: end if;
578:

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

582: (p_associated_column1 => 'IRC_COMM_MESSAGES.SENDER_TYPE'
583: ,p_associated_column2 => 'IRC_COMM_MESSAGES.SENDER_ID'
584: ) then
585: --
586: hr_utility.set_location(' Leaving:'||l_proc,70);
587: --
588: raise;
589: end if;
590: --

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

587: --
588: raise;
589: end if;
590: --
591: hr_utility.set_location(' Leaving:'||l_proc,80);
592: --
593: End chk_sender;
594: --
595: -- ----------------------------------------------------------------------------

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

621: where document_id = p_document_id;
622: --
623: Begin
624: --
625: hr_utility.set_location(' Entering:'||l_proc,10);
626: --
627: if p_document_type = 'IRC_DOC' then
628: open csr_document;
629: fetch csr_document into l_document_id;

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

627: if p_document_type = 'IRC_DOC' then
628: open csr_document;
629: fetch csr_document into l_document_id;
630: --
631: hr_utility.set_location(l_proc,20);
632: --
633: if csr_document%notfound then
634: close csr_document;
635: fnd_message.set_name('PER','IRC_412403_BAD_DOC_ID');

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

635: fnd_message.set_name('PER','IRC_412403_BAD_DOC_ID');
636: fnd_message.raise_error;
637: end if;
638: --
639: hr_utility.set_location(l_proc,30);
640: --
641: close csr_document;
642: end if;
643: if (p_document_type is null and p_document_id is null) or

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

642: end if;
643: if (p_document_type is null and p_document_id is null) or
644: (p_document_type is not null and p_document_id is not null) then
645: --it is okay to go ahead
646: hr_utility.set_location(l_proc,30);
647: else
648: fnd_message.set_name('PER','IRC_412404_NULL_DOC_ID');
649: fnd_message.raise_error;
650: end if;

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

654: (p_associated_column1 => 'IRC_COMM_MESSAGES.DOCUMENT_TYPE'
655: ,p_associated_column2 => 'IRC_COMM_MESSAGES.DOCUMENT_ID'
656: ) then
657: --
658: hr_utility.set_location(' Leaving:'||l_proc,40);
659: --
660: raise;
661: end if;
662: --

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

659: --
660: raise;
661: end if;
662: --
663: hr_utility.set_location(' Leaving:'||l_proc,50);
664: --
665: End chk_document;
666: --
667: -- ----------------------------------------------------------------------------

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

675: --
676: --
677: Begin
678: --
679: hr_utility.set_location(' Entering:'||l_proc,10);
680: --
681: if p_deleted_flag <> 'Y' and p_deleted_flag <> 'N' then
682: --
683: -- raise error

Line 685: hr_utility.set_location('Leaving: '|| l_proc, 3);

681: if p_deleted_flag <> 'Y' and p_deleted_flag <> 'N' then
682: --
683: -- raise error
684: --
685: hr_utility.set_location('Leaving: '|| l_proc, 3);
686: hr_utility.set_message(800,'IRC_412421_INVALID_DELETED_FLAG');
687: hr_utility.raise_error;
688: end if;
689: --

Line 686: hr_utility.set_message(800,'IRC_412421_INVALID_DELETED_FLAG');

682: --
683: -- raise error
684: --
685: hr_utility.set_location('Leaving: '|| l_proc, 3);
686: hr_utility.set_message(800,'IRC_412421_INVALID_DELETED_FLAG');
687: hr_utility.raise_error;
688: end if;
689: --
690: exception

Line 687: hr_utility.raise_error;

683: -- raise error
684: --
685: hr_utility.set_location('Leaving: '|| l_proc, 3);
686: hr_utility.set_message(800,'IRC_412421_INVALID_DELETED_FLAG');
687: hr_utility.raise_error;
688: end if;
689: --
690: exception
691: when app_exception.application_exception then

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

692: if hr_multi_message.exception_add
693: (p_associated_column1 => 'IRC_COMM_MESSAGES.DELETED_FLAG'
694: ) then
695: --
696: hr_utility.set_location(' Leaving:'||l_proc,20);
697: --
698: raise;
699: end if;
700: --

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

697: --
698: raise;
699: end if;
700: --
701: hr_utility.set_location(' Leaving:'||l_proc,30);
702: --
703: End chk_deleted_flag;
704: --
705: -- ----------------------------------------------------------------------------

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

712: --
713: l_proc varchar2(72) := g_package||'insert_validate';
714: --
715: Begin
716: hr_utility.set_location('Entering:'||l_proc, 5);
717: --
718: -- Call all supporting business operations
719: --
720: --

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

743: ,p_document_id => p_rec.document_id);
744: --
745: chk_deleted_flag(p_rec.deleted_flag);
746: --
747: hr_utility.set_location(' Leaving:'||l_proc, 10);
748: End insert_validate;
749: --
750: -- ----------------------------------------------------------------------------
751: -- |---------------------------< update_validate >----------------------------|

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

757: --
758: l_proc varchar2(72) := g_package||'update_validate';
759: --
760: Begin
761: hr_utility.set_location('Entering:'||l_proc, 5);
762: --
763: -- Call all supporting business operations
764: --
765: --

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

793: ,p_document_id => p_rec.document_id);
794: --
795: chk_deleted_flag(p_rec.deleted_flag);
796: --
797: hr_utility.set_location(' Leaving:'||l_proc, 10);
798: End update_validate;
799: --
800: -- ----------------------------------------------------------------------------
801: -- |---------------------------< delete_validate >----------------------------|

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

806: --
807: l_proc varchar2(72) := g_package||'delete_validate';
808: --
809: Begin
810: hr_utility.set_location('Entering:'||l_proc, 5);
811: --
812: -- Call all supporting business operations
813: --
814: hr_utility.set_location(' Leaving:'||l_proc, 10);

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

810: hr_utility.set_location('Entering:'||l_proc, 5);
811: --
812: -- Call all supporting business operations
813: --
814: hr_utility.set_location(' Leaving:'||l_proc, 10);
815: End delete_validate;
816: --
817: end irc_cmm_bus;