[Home] [Help]
26: RETURN l_comment;
27: EXCEPTION
28: WHEN OTHERS
29: THEN
30: wf_core.CONTEXT (g_package,
31: 'get_issue_bdgt_ntf_comment',
32: l_transaction_id,
33: 'Error occured in while getting the isssue budget comments'
34: );
56: RETURN l_comment;
57: EXCEPTION
58: WHEN OTHERS
59: THEN
60: wf_core.CONTEXT (g_package,
61: 'get_issue_approve_ntf_comment',
62: l_transaction_id,
63: 'Error occured in while getting the approval comments'
64: );
85: RETURN l_comment;
86: EXCEPTION
87: WHEN OTHERS
88: THEN
89: wf_core.CONTEXT (g_package,
90: 'get_access_ntf_comment',
91: l_transaction_id,
92: 'Error occured in while getting the access comments'
93: );
103: RETURN l_profile_value;
104: EXCEPTION
105: WHEN OTHERS
106: THEN
107: wf_core.CONTEXT (g_package,
108: 'get_profile_value',
109: NAME,
110: 'Error occured in while getting the profile value'
111: );
277:
278: IF c2%NOTFOUND
279: THEN
280: hr_utility.TRACE ('fnd person does not exist ' || p_person_id);
281: wf_core.RAISE ('fnd person does not exist ' || p_person_id);
282: END IF;
283:
284: CLOSE c2;
285:
290: RETURN l_fnd_user_name;
291: EXCEPTION
292: WHEN OTHERS
293: THEN
294: /* wf_core.CONTEXT (g_package,
295: 'get_fnd_user_name',
296: p_person_id,
297: 'Error occured in while getting the fnd_user_name'
298: );
331: hr_utility.TRACE ('p_fnd_user_name : ' || p_fnd_user_name);
332:
333: IF p_fnd_user_name IS NULL THEN
334: hr_utility.TRACE ('p_fnd_user_name is null');
335: wf_core.RAISE ('p_fnd_user_name is null');
336: END IF;
337:
338: OPEN c1;
339: FETCH c1 INTO l_notification_id;
342: hr_utility.TRACE ( 'Notification id not present for the user '
343: || p_fnd_user_name
344: || 'for the item key'
345: || p_item_key);
346: wf_core.RAISE ( 'Notification id is not present for the user '
347: || p_fnd_user_name
348: || ' for the item key'
349: || p_item_key);
350: END IF;
354: hr_utility.set_location ('Exiting ' || g_package || ' : ' || l_proc, 2000);
355: RETURN l_notification_id;
356: EXCEPTION
357: WHEN OTHERS THEN
358: wf_core.CONTEXT (g_package
359: , 'get_current_notification_id'
360: , p_item_key
361: , p_fnd_user_name
362: , 'Error occured in while getting the get_current_notification_id'
393: WHERE n.notification_id = l_notification_id;
394: EXCEPTION
395: WHEN NO_DATA_FOUND
396: THEN
397: wf_core.token ('NID',
398: wf_notification.getsubject (l_notification_id)
399: );
400: wf_core.RAISE ('WFNTF_NID');
401: END;
396: THEN
397: wf_core.token ('NID',
398: wf_notification.getsubject (l_notification_id)
399: );
400: wf_core.RAISE ('WFNTF_NID');
401: END;
402:
403: IF (l_status = 'OPEN')
404: THEN
408: END IF;
409: EXCEPTION
410: WHEN OTHERS
411: THEN
412: wf_core.CONTEXT (g_package,
413: 'ntf_closed',
414: itemtype,
415: itemkey,
416: TO_CHAR (actid),
619: );
620: EXCEPTION
621: WHEN OTHERS
622: THEN
623: wf_core.get_error (l_err_name, l_err_msg, l_err_stack);
624:
625: IF (l_err_name IS NOT NULL)
626: THEN
627: hr_utility.TRACE ( 'Following Workflow error has occured'
634: fnd_message.set_token ('ERR_STACK',
635: SUBSTRB (l_err_stack, 25000),
636: FALSE
637: );
638: wf_core.CLEAR;
639: fnd_message.raise_error;
640: ELSE
641: hr_utility.TRACE
642: ( 'A general error has occured while creating the workflow process '
720: );
721: EXCEPTION
722: WHEN OTHERS
723: THEN
724: wf_core.get_error (l_err_name, l_err_msg, l_err_stack);
725:
726: IF (l_err_name IS NOT NULL)
727: THEN
728: hr_utility.TRACE ( 'Following Workflow error has occured'
735: fnd_message.set_token ('ERR_STACK',
736: SUBSTRB (l_err_stack, 25000),
737: FALSE
738: );
739: wf_core.CLEAR;
740: fnd_message.raise_error;
741: ELSE
742: hr_utility.TRACE
743: ( 'A general error has occured while starting the workflow process '
877: RETURN;
878: EXCEPTION
879: WHEN OTHERS
880: THEN
881: wf_core.CONTEXT (g_package,
882: 'which_message',
883: itemtype,
884: itemkey,
885: TO_CHAR (actid),
909: RETURN;
910: EXCEPTION
911: WHEN OTHERS
912: THEN
913: wf_core.CONTEXT (g_package,
914: 'is_notification_sent',
915: itemtype,
916: itemkey,
917: TO_CHAR (actid),