[Home] [Help]
114: l_proc VARCHAR2(72) := g_package||'get_email_message_body';
115: l_apps_fwk_agent VARCHAR2(2000);
116: --
117: begin
118: hr_utility.set_location('Entering:'|| l_proc, 10);
119: --
120: -- Obtain all the data for use in the message.
121: --
122: --Commented for Bug 6004149
197: || l_message_conc ;
198: --
199: RETURN l_whole_message;
200: --
201: hr_utility.set_location('Leaving:'|| l_proc, 100);
202: end get_email_message_body;
203: --
204: -- ----------------------------------------------------------------------------
205: -- |----------------------< GET_TEXT_MESSAGE_BODY >---------------------------|
268: l_proc VARCHAR2(72) := g_package||'get_text_message_body';
269: l_apps_fwk_agent VARCHAR2(2000);
270: --
271: begin
272: hr_utility.set_location('Entering:'|| l_proc, 10);
273: --
274: -- Obtain all the data for use in the message.
275: --
276: --Commented for Bug 6004149
344: || l_message_conc ;
345: --
346: RETURN l_whole_message;
347: --
348: hr_utility.set_location('Leaving:'|| l_proc, 100);
349: end get_text_message_body;
350:
351: -- ----------------------------------------------------------------------------
352: -- |--------------------------< NOTIFY_SEEKER_IF_REQUIRED >-------------------|
398: from fnd_user usr
399: where usr.user_name = p_user_name;
400: --- End Added for 14500909
401: begin
402: hr_utility.set_location('Entering:'|| l_proc, 10);
403: --
404: -- An email only need to be sent under certain conditions
405: --
406: if p_consideration_status = 'PURSUE' and p_validate_only = FALSE then
451: );
452: end if;
453: end if;
454: --
455: hr_utility.set_location('Leaving:'|| l_proc, 100);
456: exception
457: when others then
458: -- Let the calling code handle any errors
459: DBMS_SESSION.SET_NLS('NLS_LANGUAGE',''''||l_dft_lang||'''');
482: l_object_version_number number;
483: l_effective_date date;
484: --
485: begin
486: hr_utility.set_location('Entering:'|| l_proc, 10);
487: --
488: -- Issue a savepoint
489: --
490: savepoint create_vacancy_consideration;
560: --
561: p_object_version_number := l_object_version_number;
562: p_vacancy_consideration_id := l_vacancy_consideration_id;
563: --
564: hr_utility.set_location(' Leaving:'||l_proc, 70);
565: exception
566: when hr_api.validate_enabled then
567: --
568: -- As the Validate_Enabled exception has been raised
575: -- when validation only mode is being used.)
576: --
577: p_object_version_number := null;
578: p_vacancy_consideration_id := null;
579: hr_utility.set_location(' Leaving:'||l_proc, 80);
580: when others then
581: --
582: -- A validation or unexpected error has occured
583: --
586: -- Reset IN OUT parameters and set OUT parameters
587: --
588: p_object_version_number := null;
589: p_vacancy_consideration_id := null;
590: hr_utility.set_location(' Leaving:'||l_proc, 90);
591: raise;
592: end CREATE_VACANCY_CONSIDERATION;
593: --
594: -- ----------------------------------------------------------------------------
618: from irc_vacancy_considerations
619: where vacancy_consideration_id = p_vacancy_consideration_id;
620: --
621: begin
622: hr_utility.set_location('Entering:'|| l_proc, 10);
623: --
624: -- Issue a savepoint
625: --
626: savepoint update_vacancy_consideration;
697: -- Set all output arguments
698: --
699: p_object_version_number := l_object_version_number;
700: --
701: hr_utility.set_location(' Leaving:'||l_proc, 70);
702: exception
703: when hr_api.validate_enabled then
704: --
705: -- As the Validate_Enabled exception has been raised
711: -- (Any key or derived arguments must be set to null
712: -- when validation only mode is being used.)
713: --
714: p_object_version_number := l_object_version_number;
715: hr_utility.set_location(' Leaving:'||l_proc, 80);
716: when others then
717: --
718: -- A validation or unexpected error has occured
719: --
721: --
722: -- Reset IN OUT parameters and set OUT parameters
723: --
724: p_object_version_number := l_object_version_number;
725: hr_utility.set_location(' Leaving:'||l_proc, 90);
726: raise;
727: end UPDATE_VACANCY_CONSIDERATION;
728: --
729: -- ----------------------------------------------------------------------------
740: --
741: l_proc varchar2(72) := g_package||
742: 'delete_vacancy_consideration';
743: begin
744: hr_utility.set_location('Entering:'|| l_proc, 10);
745: --
746: -- Issue a savepoint
747: --
748: savepoint delete_vacancy_consideration;
793: --
794: -- Set all output arguments
795: --
796: --
797: hr_utility.set_location(' Leaving:'||l_proc, 70);
798: exception
799: when hr_api.validate_enabled then
800: --
801: -- As the Validate_Enabled exception has been raised
806: -- Only set output warning arguments
807: -- (Any key or derived arguments must be set to null
808: -- when validation only mode is being used.)
809: --
810: hr_utility.set_location(' Leaving:'||l_proc, 80);
811: when others then
812: --
813: -- A validation or unexpected error has occured
814: --
812: --
813: -- A validation or unexpected error has occured
814: --
815: rollback to DELETE_VACANCY_CONSIDERATION;
816: hr_utility.set_location(' Leaving:'||l_proc, 90);
817: raise;
818: end DELETE_VACANCY_CONSIDERATION;
819: --
820: end IRC_VACANCY_CONSIDERATIONS_API;