[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: );
281: if(p_person_id = -99) then
282: l_fnd_user_name := 'SYSADMIN';
283: else
284: hr_utility.TRACE ('fnd person does not exist ' || p_person_id);
285: wf_core.RAISE ('fnd person does not exist ' || p_person_id);
286: end if;
287: END IF;
288:
289: CLOSE c2;
295: RETURN l_fnd_user_name;
296: EXCEPTION
297: WHEN OTHERS
298: THEN
299: /* wf_core.CONTEXT (g_package,
300: 'get_fnd_user_name',
301: p_person_id,
302: 'Error occured in while getting the fnd_user_name'
303: );
336: hr_utility.TRACE ('p_fnd_user_name : ' || p_fnd_user_name);
337:
338: IF p_fnd_user_name IS NULL THEN
339: hr_utility.TRACE ('p_fnd_user_name is null');
340: wf_core.RAISE ('p_fnd_user_name is null');
341: END IF;
342:
343: OPEN c1;
344: FETCH c1 INTO l_notification_id;
347: hr_utility.TRACE ( 'Notification id not present for the user '
348: || p_fnd_user_name
349: || 'for the item key'
350: || p_item_key);
351: wf_core.RAISE ( 'Notification id is not present for the user '
352: || p_fnd_user_name
353: || ' for the item key'
354: || p_item_key);
355: END IF;
359: hr_utility.set_location ('Exiting ' || g_package || ' : ' || l_proc, 2000);
360: RETURN l_notification_id;
361: EXCEPTION
362: WHEN OTHERS THEN
363: wf_core.CONTEXT (g_package
364: , 'get_current_notification_id'
365: , p_item_key
366: , p_fnd_user_name
367: , 'Error occured in while getting the get_current_notification_id'
398: WHERE n.notification_id = l_notification_id;
399: EXCEPTION
400: WHEN NO_DATA_FOUND
401: THEN
402: wf_core.token ('NID',
403: wf_notification.getsubject (l_notification_id)
404: );
405: wf_core.RAISE ('WFNTF_NID');
406: END;
401: THEN
402: wf_core.token ('NID',
403: wf_notification.getsubject (l_notification_id)
404: );
405: wf_core.RAISE ('WFNTF_NID');
406: END;
407:
408: IF (l_status = 'OPEN')
409: THEN
413: END IF;
414: EXCEPTION
415: WHEN OTHERS
416: THEN
417: wf_core.CONTEXT (g_package,
418: 'ntf_closed',
419: itemtype,
420: itemkey,
421: TO_CHAR (actid),
624: );
625: EXCEPTION
626: WHEN OTHERS
627: THEN
628: wf_core.get_error (l_err_name, l_err_msg, l_err_stack);
629:
630: IF (l_err_name IS NOT NULL)
631: THEN
632: hr_utility.TRACE ( 'Following Workflow error has occured'
639: fnd_message.set_token ('ERR_STACK',
640: SUBSTRB (l_err_stack, 25000),
641: FALSE
642: );
643: wf_core.CLEAR;
644: fnd_message.raise_error;
645: ELSE
646: hr_utility.TRACE
647: ( 'A general error has occured while creating the workflow process '
725: );
726: EXCEPTION
727: WHEN OTHERS
728: THEN
729: wf_core.get_error (l_err_name, l_err_msg, l_err_stack);
730:
731: IF (l_err_name IS NOT NULL)
732: THEN
733: hr_utility.TRACE ( 'Following Workflow error has occured'
740: fnd_message.set_token ('ERR_STACK',
741: SUBSTRB (l_err_stack, 25000),
742: FALSE
743: );
744: wf_core.CLEAR;
745: fnd_message.raise_error;
746: ELSE
747: hr_utility.TRACE
748: ( 'A general error has occured while starting the workflow process '
882: RETURN;
883: EXCEPTION
884: WHEN OTHERS
885: THEN
886: wf_core.CONTEXT (g_package,
887: 'which_message',
888: itemtype,
889: itemkey,
890: TO_CHAR (actid),
914: RETURN;
915: EXCEPTION
916: WHEN OTHERS
917: THEN
918: wf_core.CONTEXT (g_package,
919: 'is_notification_sent',
920: itemtype,
921: itemkey,
922: TO_CHAR (actid),