DBA Data[Home] [Help]

APPS.IRC_IPC_BUS dependencies on HR_UTILITY

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

48: --
49: l_proc varchar2(72) := g_package || 'chk_ddf';
50: --
51: begin
52: hr_utility.set_location('Entering:'||l_proc,10);
53: --
54: if ((p_rec.posting_content_id is not null) and (
55: nvl(irc_ipc_shd.g_old_rec.ipc_information_category, hr_api.g_varchar2) <>
56: nvl(p_rec.ipc_information_category, hr_api.g_varchar2) or

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

187: ,p_attribute30_value => p_rec.ipc_information30
188: );
189: end if;
190: --
191: hr_utility.set_location(' Leaving:'||l_proc,20);
192: end chk_ddf;
193: --
194: -- ----------------------------------------------------------------------------
195: -- |------------------------------< chk_df >----------------------------------|

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

225: --
226: l_proc varchar2(72) := g_package || 'chk_df';
227: --
228: begin
229: hr_utility.set_location('Entering:'||l_proc,10);
230: --
231: if ((p_rec.posting_content_id is not null) and (
232: nvl(irc_ipc_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
233: nvl(p_rec.attribute_category, hr_api.g_varchar2) or

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

364: ,p_attribute30_value => p_rec.attribute30
365: );
366: end if;
367: --
368: hr_utility.set_location(' Leaving:'||l_proc,20);
369: end chk_df;
370: --
371: -- ----------------------------------------------------------------------------
372: -- |-----------------------< chk_non_updateable_args >------------------------|

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

455: is
456: l_proc varchar2(72) := g_package || 'chk_display_manager_info';
457: l_api_updating boolean;
458: begin
459: hr_utility.set_location('Entering:'||l_proc, 10);
460: l_api_updating := irc_ipc_shd.api_updating
461: (p_posting_content_id => p_posting_content_id
462: ,p_object_version_number => p_object_version_number);
463: --

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

460: l_api_updating := irc_ipc_shd.api_updating
461: (p_posting_content_id => p_posting_content_id
462: ,p_object_version_number => p_object_version_number);
463: --
464: hr_utility.set_location(l_proc,20);
465: if ((l_api_updating
466: and
467: irc_ipc_shd.g_old_rec.display_manager_info <>
468: nvl(p_display_manager_info, hr_api.g_varchar2))

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

467: irc_ipc_shd.g_old_rec.display_manager_info <>
468: nvl(p_display_manager_info, hr_api.g_varchar2))
469: or
470: (NOT l_api_updating)) then
471: hr_utility.set_location(l_proc,30);
472: hr_api.mandatory_arg_error
473: (p_api_name => l_proc
474: ,p_argument => 'display_manager_info'
475: ,p_argument_value => p_display_manager_info

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

473: (p_api_name => l_proc
474: ,p_argument => 'display_manager_info'
475: ,p_argument_value => p_display_manager_info
476: );
477: hr_utility.set_location(l_proc,40);
478: if (p_display_manager_info not in ('Y','N'))
479: then
480: fnd_message.set_name('PER','IRC_412027_IPC_MAN_INFO_INV');
481: fnd_message.raise_error;

Line 484: hr_utility.set_location(' Leaving:'||l_proc,45);

480: fnd_message.set_name('PER','IRC_412027_IPC_MAN_INFO_INV');
481: fnd_message.raise_error;
482: end if;
483: end if;
484: hr_utility.set_location(' Leaving:'||l_proc,45);
485: exception
486: when app_exception.application_exception then
487: if hr_multi_message.exception_add
488: (p_associated_column1 => 'IRC_POSTING_CONTENTS.DISPLAY_MANAGER_INFO'

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

486: when app_exception.application_exception then
487: if hr_multi_message.exception_add
488: (p_associated_column1 => 'IRC_POSTING_CONTENTS.DISPLAY_MANAGER_INFO'
489: )then
490: hr_utility.set_location(' Leaving:'||l_proc, 50);
491: raise;
492: end if;
493: hr_utility.set_location(' Leaving:'||l_proc,60);
494: end chk_display_manager_info;

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

489: )then
490: hr_utility.set_location(' Leaving:'||l_proc, 50);
491: raise;
492: end if;
493: hr_utility.set_location(' Leaving:'||l_proc,60);
494: end chk_display_manager_info;
495: --
496: -- ----------------------------------------------------------------------------
497: -- |-----------------------< chk_display_recruiter_info >----------------------|

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

530: is
531: l_proc varchar2(72) := g_package || 'chk_display_recruiter_info';
532: l_api_updating boolean;
533: begin
534: hr_utility.set_location('Entering:'||l_proc, 5);
535: l_api_updating := irc_ipc_shd.api_updating
536: (p_posting_content_id => p_posting_content_id
537: ,p_object_version_number => p_object_version_number);
538: --

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

535: l_api_updating := irc_ipc_shd.api_updating
536: (p_posting_content_id => p_posting_content_id
537: ,p_object_version_number => p_object_version_number);
538: --
539: hr_utility.set_location(l_proc,20);
540: if ((l_api_updating
541: and
542: irc_ipc_shd.g_old_rec.display_recruiter_info <>
543: nvl(p_display_recruiter_info, hr_api.g_varchar2))

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

542: irc_ipc_shd.g_old_rec.display_recruiter_info <>
543: nvl(p_display_recruiter_info, hr_api.g_varchar2))
544: or
545: (NOT l_api_updating)) then
546: hr_utility.set_location(l_proc,30);
547: hr_api.mandatory_arg_error
548: (p_api_name => l_proc
549: ,p_argument => 'display_recruiter_info'
550: ,p_argument_value => p_display_recruiter_info

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

548: (p_api_name => l_proc
549: ,p_argument => 'display_recruiter_info'
550: ,p_argument_value => p_display_recruiter_info
551: );
552: hr_utility.set_location(l_proc,40);
553: if (p_display_recruiter_info not in ('Y','N'))
554: then
555: fnd_message.set_name('PER','IRC_412028_IPC_REC_INFO_INV');
556: fnd_message.raise_error;

Line 559: hr_utility.set_location(' Leaving:'||l_proc,45);

555: fnd_message.set_name('PER','IRC_412028_IPC_REC_INFO_INV');
556: fnd_message.raise_error;
557: end if;
558: end if;
559: hr_utility.set_location(' Leaving:'||l_proc,45);
560: exception
561: when app_exception.application_exception then
562: if hr_multi_message.exception_add
563: (p_associated_column1 => 'IRC_POSTING_CONTENTS.DISPLAY_RECRUITER_INFO'

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

561: when app_exception.application_exception then
562: if hr_multi_message.exception_add
563: (p_associated_column1 => 'IRC_POSTING_CONTENTS.DISPLAY_RECRUITER_INFO'
564: )then
565: hr_utility.set_location(' Leaving:'||l_proc, 50);
566: raise;
567: end if;
568: hr_utility.set_location(' Leaving:'||l_proc,60);
569: end chk_display_recruiter_info;

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

564: )then
565: hr_utility.set_location(' Leaving:'||l_proc, 50);
566: raise;
567: end if;
568: hr_utility.set_location(' Leaving:'||l_proc,60);
569: end chk_display_recruiter_info;
570: --
571: -- ----------------------------------------------------------------------------
572: -- |--------------------------< chk_posting_content_delete >------------------|

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

607: where vac.primary_posting_id = p_posting_content_id;
608: --
609: begin
610: --
611: hr_utility.set_location('Entering:'||l_proc,10);
612: --
613: -- check if referenced records exist in the PER_ALL_VACANCIES table.
614: --
615: open csr_posting_content;

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

613: -- check if referenced records exist in the PER_ALL_VACANCIES table.
614: --
615: open csr_posting_content;
616: fetch csr_posting_content into l_posting_content;
617: hr_utility.set_location(l_proc,20);
618: if csr_posting_content%found then
619: --
620: -- raise error as child records exist.
621: --

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

623: fnd_message.set_name('PER','IRC_412209_VAC_POSTING_EXISTS');
624: fnd_message.raise_error;
625: end if;
626: close csr_posting_content;
627: hr_utility.set_location(l_proc,30);
628: exception
629: when app_exception.application_exception then
630: if hr_multi_message.exception_add
631: (p_associated_column1 => 'IRC_POSTING_CONTENTS.POSTING_CONTENT_ID'

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

629: when app_exception.application_exception then
630: if hr_multi_message.exception_add
631: (p_associated_column1 => 'IRC_POSTING_CONTENTS.POSTING_CONTENT_ID'
632: )then
633: hr_utility.set_location(l_proc,40);
634: raise;
635: end if;
636: hr_utility.set_location(' Leaving:'||l_proc,50);
637: --

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

632: )then
633: hr_utility.set_location(l_proc,40);
634: raise;
635: end if;
636: hr_utility.set_location(' Leaving:'||l_proc,50);
637: --
638: end chk_posting_content_delete;
639: --
640: -- ----------------------------------------------------------------------------

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

646: --
647: l_proc varchar2(72) := g_package||'insert_validate';
648: --
649: Begin
650: hr_utility.set_location('Entering:'||l_proc, 5);
651: irc_ipc_bus.chk_display_manager_info
652: (
653: p_display_manager_info => p_rec.display_manager_info
654: ,p_posting_content_id => p_rec.posting_content_id

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

653: p_display_manager_info => p_rec.display_manager_info
654: ,p_posting_content_id => p_rec.posting_content_id
655: ,p_object_version_number => p_rec.object_version_number
656: );
657: hr_utility.set_location(l_proc, 10);
658: irc_ipc_bus.chk_display_recruiter_info
659: (
660: p_display_recruiter_info => p_rec.display_recruiter_info
661: ,p_posting_content_id => p_rec.posting_content_id

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

660: p_display_recruiter_info => p_rec.display_recruiter_info
661: ,p_posting_content_id => p_rec.posting_content_id
662: ,p_object_version_number => p_rec.object_version_number
663: );
664: hr_utility.set_location(l_proc, 20);
665: irc_ipc_bus.chk_df(p_rec);
666: hr_utility.set_location(l_proc, 30);
667: irc_ipc_bus.chk_ddf(p_rec);
668: --

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

662: ,p_object_version_number => p_rec.object_version_number
663: );
664: hr_utility.set_location(l_proc, 20);
665: irc_ipc_bus.chk_df(p_rec);
666: hr_utility.set_location(l_proc, 30);
667: irc_ipc_bus.chk_ddf(p_rec);
668: --
669: hr_utility.set_location(' Leaving:'||l_proc, 40);
670: End insert_validate;

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

665: irc_ipc_bus.chk_df(p_rec);
666: hr_utility.set_location(l_proc, 30);
667: irc_ipc_bus.chk_ddf(p_rec);
668: --
669: hr_utility.set_location(' Leaving:'||l_proc, 40);
670: End insert_validate;
671: --
672: -- ----------------------------------------------------------------------------
673: -- |---------------------------< update_validate >----------------------------|

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

678: --
679: l_proc varchar2(72) := g_package||'update_validate';
680: --
681: Begin
682: hr_utility.set_location('Entering:'||l_proc, 5);
683: --
684: chk_non_updateable_args
685: (p_rec => p_rec
686: );

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

683: --
684: chk_non_updateable_args
685: (p_rec => p_rec
686: );
687: hr_utility.set_location('Entering:'||l_proc, 10);
688: irc_ipc_bus.chk_display_manager_info
689: (
690: p_display_manager_info => p_rec.display_manager_info
691: ,p_posting_content_id => p_rec.posting_content_id

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

690: p_display_manager_info => p_rec.display_manager_info
691: ,p_posting_content_id => p_rec.posting_content_id
692: ,p_object_version_number => p_rec.object_version_number
693: );
694: hr_utility.set_location(l_proc, 20);
695: irc_ipc_bus.chk_display_recruiter_info
696: (
697: p_display_recruiter_info => p_rec.display_recruiter_info
698: ,p_posting_content_id => p_rec.posting_content_id

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

697: p_display_recruiter_info => p_rec.display_recruiter_info
698: ,p_posting_content_id => p_rec.posting_content_id
699: ,p_object_version_number => p_rec.object_version_number
700: );
701: hr_utility.set_location(l_proc,30);
702: irc_ipc_bus.chk_df(p_rec);
703: hr_utility.set_location(l_proc,40);
704: irc_ipc_bus.chk_ddf(p_rec);
705: --

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

699: ,p_object_version_number => p_rec.object_version_number
700: );
701: hr_utility.set_location(l_proc,30);
702: irc_ipc_bus.chk_df(p_rec);
703: hr_utility.set_location(l_proc,40);
704: irc_ipc_bus.chk_ddf(p_rec);
705: --
706: hr_utility.set_location(' Leaving:'||l_proc, 50);
707: End update_validate;

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

702: irc_ipc_bus.chk_df(p_rec);
703: hr_utility.set_location(l_proc,40);
704: irc_ipc_bus.chk_ddf(p_rec);
705: --
706: hr_utility.set_location(' Leaving:'||l_proc, 50);
707: End update_validate;
708: --
709: -- ----------------------------------------------------------------------------
710: -- |---------------------------< delete_validate >----------------------------|

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

715: --
716: l_proc varchar2(72) := g_package||'delete_validate';
717: --
718: Begin
719: hr_utility.set_location('Entering:'||l_proc, 5);
720: --
721: -- Call all supporting business operations
722: --
723: if(p_rec.posting_content_id is not null) then

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

724: irc_ipc_bus.chk_posting_content_delete
725: (p_posting_content_id => p_rec.posting_content_id
726: );
727: end if;
728: hr_utility.set_location(' Leaving:'||l_proc, 10);
729: End delete_validate;
730: --
731: end irc_ipc_bus;