APPS.JTF_TASK_WF_SUBSCRIBE_PVT dependencies on FND_API

Line 33: IF NOT(x_return_status = fnd_api.g_ret_sts_success) THEN

29: END IF;
30: END IF;
31: END IF;
32:
33: IF NOT(x_return_status = fnd_api.g_ret_sts_success) THEN
34: wf_core.CONTEXT('jtf_task_wf_subscribe_pvt', 'create_task_notif_subs', p_event.event_name, p_subscription_guid);
35: wf_event.seterrorinfo(p_event, 'WARNING');
36: RETURN 'WARNING';
37: END IF;

Line 140: IF NOT(x_return_status = fnd_api.g_ret_sts_success) THEN

136: END IF;
137: END IF;
138: END IF;
139:
140: IF NOT(x_return_status = fnd_api.g_ret_sts_success) THEN
141: wf_core.CONTEXT('jtf_task_wf_subscribe_pvt', 'update_task_notif_subs', p_event.event_name, p_subscription_guid);
142: wf_event.seterrorinfo(p_event, 'WARNING');
143: RETURN 'WARNING';
144: END IF;

Line 184: IF NOT(x_return_status = fnd_api.g_ret_sts_success) THEN

180: END IF;
181: END IF;
182: END IF;
183:
184: IF NOT(x_return_status = fnd_api.g_ret_sts_success) THEN
185: wf_core.CONTEXT('jtf_task_wf_subscribe_pvt', 'delete_task_notif_subs', p_event.event_name, p_subscription_guid);
186: wf_event.seterrorinfo(p_event, 'WARNING');
187: RETURN 'WARNING';
188: END IF;

Line 232: IF NOT(x_return_status = fnd_api.g_ret_sts_success) THEN

228: );
229: END IF;
230: END IF;
231:
232: IF NOT(x_return_status = fnd_api.g_ret_sts_success) THEN
233: wf_core.CONTEXT('jtf_task_wf_subscribe_pvt', 'create_assg_notif_subs', p_event.event_name, p_subscription_guid);
234: wf_event.seterrorinfo(p_event, 'WARNING');
235: RETURN 'WARNING';
236: END IF;

Line 277: IF (NVL(l_resource_id, 0) <> fnd_api.g_miss_num AND NVL(l_resource_id, 0) <> NVL(l_orig_resource_id, 0))

273: END IF;
274:
275: IF (l_assignee_role_db IS NOT NULL) THEN
276: IF (l_enable_workflow = 'Y') THEN
277: IF (NVL(l_resource_id, 0) <> fnd_api.g_miss_num AND NVL(l_resource_id, 0) <> NVL(l_orig_resource_id, 0))
278: OR (NVL(l_resource_type_code, fnd_api.g_miss_char) <> NVL(l_orig_resource_type_code, fnd_api.g_miss_char)) THEN
279: IF (jtf_task_wf_util.do_notification(l_task_id)) THEN
280: IF (l_assignee_role_db = 'OWNER') THEN
281: jtf_task_wf_util.create_notification(

Line 278: OR (NVL(l_resource_type_code, fnd_api.g_miss_char) <> NVL(l_orig_resource_type_code, fnd_api.g_miss_char)) THEN

274:
275: IF (l_assignee_role_db IS NOT NULL) THEN
276: IF (l_enable_workflow = 'Y') THEN
277: IF (NVL(l_resource_id, 0) <> fnd_api.g_miss_num AND NVL(l_resource_id, 0) <> NVL(l_orig_resource_id, 0))
278: OR (NVL(l_resource_type_code, fnd_api.g_miss_char) <> NVL(l_orig_resource_type_code, fnd_api.g_miss_char)) THEN
279: IF (jtf_task_wf_util.do_notification(l_task_id)) THEN
280: IF (l_assignee_role_db = 'OWNER') THEN
281: jtf_task_wf_util.create_notification(
282: p_event => 'CHANGE_OWNER'

Line 310: IF NOT(x_return_status = fnd_api.g_ret_sts_success) THEN

306: END IF;
307: END IF;
308: END IF;
309:
310: IF NOT(x_return_status = fnd_api.g_ret_sts_success) THEN
311: wf_core.CONTEXT('jtf_task_wf_subscribe_pvt', 'update_assg_notif_subs', p_event.event_name, p_subscription_guid);
312: wf_event.seterrorinfo(p_event, 'WARNING');
313: RETURN 'WARNING';
314: END IF;

Line 360: IF NOT(x_return_status = fnd_api.g_ret_sts_success) THEN

356: );
357: END IF;
358: END IF;
359:
360: IF NOT(x_return_status = fnd_api.g_ret_sts_success) THEN
361: wf_core.CONTEXT('jtf_task_wf_subscribe_pvt', 'delete_assg_notif_subs', p_event.event_name, p_subscription_guid);
362: wf_event.seterrorinfo(p_event, 'WARNING');
363: RETURN 'WARNING';
364: END IF;

Line 380: l_old_param := fnd_api.g_miss_char;

376: l_old_param VARCHAR2(4000) := p_old_param;
377: l_new_param VARCHAR2(4000) := p_new_param;
378: BEGIN
379: IF (l_old_param IS NULL) THEN
380: l_old_param := fnd_api.g_miss_char;
381: END IF;
382:
383: IF (l_new_param IS NULL) THEN
384: l_new_param := fnd_api.g_miss_char;

Line 384: l_new_param := fnd_api.g_miss_char;

380: l_old_param := fnd_api.g_miss_char;
381: END IF;
382:
383: IF (l_new_param IS NULL) THEN
384: l_new_param := fnd_api.g_miss_char;
385: END IF;
386:
387: RETURN(l_old_param <> l_new_param);
388: END compare_old_new_param;