DBA Data[Home] [Help]

APPS.PER_CKL_FYI_NOTIFICATIONS dependencies on HR_UTILITY

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

32: numvalue Wf_Engine.NumTabTyp;
33: --
34: BEGIN
35: l_proc:= 'per_ckl_fyi_notifications.start_wf_process';
36: hr_utility.set_location('Entering: '|| l_proc, 10);
37: --
38: l_item_type := 'HRCKLFYI';
39: l_item_key := 'ChecklistTask:'||p_task_id||':'||CURRENT_TIMESTAMP;
40: l_process := 'CHECKLISTNOTIFIERPROCESS';

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

112: );
113: --
114: COMMIT;
115: --
116: hr_utility.set_location('Leaving: '|| l_proc, 20);
117: --
118: EXCEPTION
119: --
120: WHEN OTHERS THEN

Line 122: hr_utility.set_location('Leaving: '|| l_proc, 30);

118: EXCEPTION
119: --
120: WHEN OTHERS THEN
121: --
122: hr_utility.set_location('Leaving: '|| l_proc, 30);
123: hr_utility.set_location(SQLERRM, 35);
124: RAISE;
125: END start_wf_process;
126: --

Line 123: hr_utility.set_location(SQLERRM, 35);

119: --
120: WHEN OTHERS THEN
121: --
122: hr_utility.set_location('Leaving: '|| l_proc, 30);
123: hr_utility.set_location(SQLERRM, 35);
124: RAISE;
125: END start_wf_process;
126: --
127: PROCEDURE which_notification(itemtype IN VARCHAR2

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

134: l_proc VARCHAR2(50);
135: --
136: BEGIN
137: l_proc:= 'per_ckl_fyi_notifications.which_notification';
138: hr_utility.set_location('Entering: '|| l_proc, 10);
139: --
140: IF funcmode = 'RUN' THEN
141: resultout := Wf_Engine.GetItemAttrText(itemtype => itemtype
142: ,itemkey => itemkey

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

144: ,ignore_notfound => FALSE
145: );
146: END IF;
147: --
148: hr_utility.set_location('Leaving: '|| l_proc, 20);
149: --
150: EXCEPTION
151: --
152: WHEN OTHERS THEN

Line 154: hr_utility.set_location('Leaving: '|| l_proc, 30);

150: EXCEPTION
151: --
152: WHEN OTHERS THEN
153: --
154: hr_utility.set_location('Leaving: '|| l_proc, 30);
155: hr_utility.set_location(SQLERRM, 35);
156: RAISE;
157: END which_notification;
158: --

Line 155: hr_utility.set_location(SQLERRM, 35);

151: --
152: WHEN OTHERS THEN
153: --
154: hr_utility.set_location('Leaving: '|| l_proc, 30);
155: hr_utility.set_location(SQLERRM, 35);
156: RAISE;
157: END which_notification;
158: --
159: END per_ckl_fyi_notifications;