DBA Data[Home] [Help]

APPS.IRC_NOTIFICATION_HELPER_PKG dependencies on HR_UTILITY

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

494: l_personId number;
495: l_eventName varchar2(30);
496: PRAGMA AUTONOMOUS_TRANSACTION;
497: begin
498: hr_utility.set_location('Entering:'|| g_package||'.'||l_proc, 10);
499: l_assignmentId := p_assignmentId;
500: l_personId := p_personId;
501: l_eventName := p_eventName;
502: l_eventData := params;

Line 541: hr_utility.set_location('All mandatory values not available', 20);

537: (l_eventName = 'CANDREG' and l_personId is null) or
538: (l_eventName = 'UPDCANDREF' and l_personId is null) or
539: (l_eventName <> 'CANDREG' and l_eventName <> 'UPDCANDREF' and l_assignmentId is null) )
540: then
541: hr_utility.set_location('All mandatory values not available', 20);
542: else
543: hr_utility.set_location('Raise event here', 40);
544: select IRC_NOTIFICATION_EVENT_KEY_S.nextval into l_eventKey from dual;
545: hr_utility.set_location('Event Key : '|| l_eventKey, 50);

Line 543: hr_utility.set_location('Raise event here', 40);

539: (l_eventName <> 'CANDREG' and l_eventName <> 'UPDCANDREF' and l_assignmentId is null) )
540: then
541: hr_utility.set_location('All mandatory values not available', 20);
542: else
543: hr_utility.set_location('Raise event here', 40);
544: select IRC_NOTIFICATION_EVENT_KEY_S.nextval into l_eventKey from dual;
545: hr_utility.set_location('Event Key : '|| l_eventKey, 50);
546: wf_event.raise( p_event_name => 'oracle.apps.per.irc.common.notifications'
547: , p_event_key => l_eventKey

Line 545: hr_utility.set_location('Event Key : '|| l_eventKey, 50);

541: hr_utility.set_location('All mandatory values not available', 20);
542: else
543: hr_utility.set_location('Raise event here', 40);
544: select IRC_NOTIFICATION_EVENT_KEY_S.nextval into l_eventKey from dual;
545: hr_utility.set_location('Event Key : '|| l_eventKey, 50);
546: wf_event.raise( p_event_name => 'oracle.apps.per.irc.common.notifications'
547: , p_event_key => l_eventKey
548: , p_event_data => l_eventData);
549: commit;

Line 551: hr_utility.set_location('Success - Exiting:'|| g_package||'.'||l_proc, 80);

547: , p_event_key => l_eventKey
548: , p_event_data => l_eventData);
549: commit;
550: end if;
551: hr_utility.set_location('Success - Exiting:'|| g_package||'.'||l_proc, 80);
552: exception
553: when others then
554: hr_utility.set_location('Error - Exiting:'|| g_package||'.'||l_proc, 100);
555: end raiseNotifyEvent;

Line 554: hr_utility.set_location('Error - Exiting:'|| g_package||'.'||l_proc, 100);

550: end if;
551: hr_utility.set_location('Success - Exiting:'|| g_package||'.'||l_proc, 80);
552: exception
553: when others then
554: hr_utility.set_location('Error - Exiting:'|| g_package||'.'||l_proc, 100);
555: end raiseNotifyEvent;
556: --
557: END irc_notification_helper_pkg;