DBA Data[Home] [Help]

APPS.IRC_NOTIFICATION_HELPER_PKG dependencies on HR_UTILITY

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

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

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

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

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

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

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

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

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

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

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

554: end if;
555: hr_utility.set_location('Success - Exiting:'|| g_package||'.'||l_proc, 80);
556: exception
557: when others then
558: hr_utility.set_location('Error - Exiting:'|| g_package||'.'||l_proc, 100);
559: end raiseNotifyEvent;
560: --
561: END irc_notification_helper_pkg;