DBA Data[Home] [Help]

APPS.IRC_VACANCY_CONSIDERATIONS_API dependencies on HR_UTILITY

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

76: 'get_email_message_body';
77: l_apps_fwk_agent VARCHAR2(2000);
78: --
79: begin
80: hr_utility.set_location('Entering:'|| l_proc, 10);
81: --
82: -- Obtain all the data for use in the message.
83: --
84: --Commented for Bug 6004149

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

159: || '
' || l_brief_description_v2||'
'
160: || l_message_conc ;
161:
162: RETURN l_whole_message;
163: hr_utility.set_location('Leaving:'|| l_proc, 100);
164: end get_email_message_body;
165: --
166: -- ----------------------------------------------------------------------------
167: -- |----------------------< GET_TEXT_MESSAGE_BODY >--------------------------|

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

233: 'get_text_message_body';
234: l_apps_fwk_agent VARCHAR2(2000);
235: --
236: begin
237: hr_utility.set_location('Entering:'|| l_proc, 10);
238: --
239: -- Obtain all the data for use in the message.
240: --
241: --Commented for Bug 6004149

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

311: || '\n' || l_brief_description_v2||'\n\n'
312: || l_message_conc ;
313:
314: RETURN l_whole_message;
315: hr_utility.set_location('Leaving:'|| l_proc, 100);
316: end get_text_message_body;
317:
318: -- ----------------------------------------------------------------------------
319: -- |--------------------------< NOTIFY_SEEKER_IF_REQUIRED >-------------------|

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

349: and ra.posting_content_id = pctl.posting_content_id
350: and userenv('LANG') = pctl.language
351: and rownum = 1;
352: begin
353: hr_utility.set_location('Entering:'|| l_proc, 10);
354: --
355: -- An email only need to be sent under certain conditions
356: --
357: if p_consideration_status = 'PURSUE' and p_validate_only = FALSE then

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

378: , p_effective_date => p_effective_date)
379: );
380: end if;
381: --
382: hr_utility.set_location('Leaving:'|| l_proc, 100);
383: exception
384: when others then
385: -- Let the calling code handle any errors
386: raise;

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

408: l_object_version_number number;
409: l_effective_date date;
410: --
411: begin
412: hr_utility.set_location('Entering:'|| l_proc, 10);
413: --
414: -- Issue a savepoint
415: --
416: savepoint create_vacancy_consideration;

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

486: --
487: p_object_version_number := l_object_version_number;
488: p_vacancy_consideration_id := l_vacancy_consideration_id;
489: --
490: hr_utility.set_location(' Leaving:'||l_proc, 70);
491: exception
492: when hr_api.validate_enabled then
493: --
494: -- As the Validate_Enabled exception has been raised

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

501: -- when validation only mode is being used.)
502: --
503: p_object_version_number := null;
504: p_vacancy_consideration_id := null;
505: hr_utility.set_location(' Leaving:'||l_proc, 80);
506: when others then
507: --
508: -- A validation or unexpected error has occured
509: --

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

512: -- Reset IN OUT parameters and set OUT parameters
513: --
514: p_object_version_number := null;
515: p_vacancy_consideration_id := null;
516: hr_utility.set_location(' Leaving:'||l_proc, 90);
517: raise;
518: end CREATE_VACANCY_CONSIDERATION;
519: --
520: -- ----------------------------------------------------------------------------

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

544: from irc_vacancy_considerations
545: where vacancy_consideration_id = p_vacancy_consideration_id;
546: --
547: begin
548: hr_utility.set_location('Entering:'|| l_proc, 10);
549: --
550: -- Issue a savepoint
551: --
552: savepoint update_vacancy_consideration;

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

623: -- Set all output arguments
624: --
625: p_object_version_number := l_object_version_number;
626: --
627: hr_utility.set_location(' Leaving:'||l_proc, 70);
628: exception
629: when hr_api.validate_enabled then
630: --
631: -- As the Validate_Enabled exception has been raised

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

637: -- (Any key or derived arguments must be set to null
638: -- when validation only mode is being used.)
639: --
640: p_object_version_number := l_object_version_number;
641: hr_utility.set_location(' Leaving:'||l_proc, 80);
642: when others then
643: --
644: -- A validation or unexpected error has occured
645: --

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

647: --
648: -- Reset IN OUT parameters and set OUT parameters
649: --
650: p_object_version_number := l_object_version_number;
651: hr_utility.set_location(' Leaving:'||l_proc, 90);
652: raise;
653: end UPDATE_VACANCY_CONSIDERATION;
654: --
655: -- ----------------------------------------------------------------------------

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

666: --
667: l_proc varchar2(72) := g_package||
668: 'delete_vacancy_consideration';
669: begin
670: hr_utility.set_location('Entering:'|| l_proc, 10);
671: --
672: -- Issue a savepoint
673: --
674: savepoint delete_vacancy_consideration;

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

719: --
720: -- Set all output arguments
721: --
722: --
723: hr_utility.set_location(' Leaving:'||l_proc, 70);
724: exception
725: when hr_api.validate_enabled then
726: --
727: -- As the Validate_Enabled exception has been raised

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

732: -- Only set output warning arguments
733: -- (Any key or derived arguments must be set to null
734: -- when validation only mode is being used.)
735: --
736: hr_utility.set_location(' Leaving:'||l_proc, 80);
737: when others then
738: --
739: -- A validation or unexpected error has occured
740: --

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

738: --
739: -- A validation or unexpected error has occured
740: --
741: rollback to DELETE_VACANCY_CONSIDERATION;
742: hr_utility.set_location(' Leaving:'||l_proc, 90);
743: raise;
744: end DELETE_VACANCY_CONSIDERATION;
745: --
746: end IRC_VACANCY_CONSIDERATIONS_API;