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;
38:
38:
39: RETURN 'SUCCESS';
40: EXCEPTION
41: WHEN OTHERS THEN
42: wf_core.CONTEXT('jtf_task_wf_subscribe_pvt', 'create_task_notif_subs', p_event.event_name, p_subscription_guid);
43: wf_event.seterrorinfo(p_event, 'WARNING');
44: RETURN 'WARNING';
45: END create_task_notif_subs;
46:
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;
145:
145:
146: RETURN 'SUCCESS';
147: EXCEPTION
148: WHEN OTHERS THEN
149: wf_core.CONTEXT('jtf_task_wf_subscribe_pvt', 'update_task_notif_subs', p_event.event_name, p_subscription_guid);
150: wf_event.seterrorinfo(p_event, 'WARNING');
151: RETURN 'WARNING';
152: END update_task_notif_subs;
153:
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;
189:
189:
190: RETURN 'SUCCESS';
191: EXCEPTION
192: WHEN OTHERS THEN
193: wf_core.CONTEXT('jtf_task_wf_subscribe_pvt', 'delete_task_notif_subs', p_event.event_name, p_subscription_guid);
194: wf_event.seterrorinfo(p_event, 'WARNING');
195: RETURN 'WARNING';
196: END delete_task_notif_subs;
197:
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;
237:
237:
238: RETURN 'SUCCESS';
239: EXCEPTION
240: WHEN OTHERS THEN
241: wf_core.CONTEXT('jtf_task_wf_subscribe_pvt', 'create_assg_notif_subs', p_event.event_name, p_subscription_guid);
242: wf_event.seterrorinfo(p_event, 'WARNING');
243: RETURN 'WARNING';
244: END create_assg_notif_subs;
245:
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;
315:
315:
316: RETURN 'SUCCESS';
317: EXCEPTION
318: WHEN OTHERS THEN
319: wf_core.CONTEXT('jtf_task_wf_subscribe_pvt', 'update_assg_notif_subs', p_event.event_name, p_subscription_guid);
320: wf_event.seterrorinfo(p_event, 'WARNING');
321: RETURN 'WARNING';
322: END update_assg_notif_subs;
323:
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;
365:
365:
366: RETURN 'SUCCESS';
367: EXCEPTION
368: WHEN OTHERS THEN
369: wf_core.CONTEXT('jtf_task_wf_subscribe_pvt', 'delete_assg_notif_subs', p_event.event_name, p_subscription_guid);
370: wf_event.seterrorinfo(p_event, 'WARNING');
371: RETURN 'WARNING';
372: END delete_assg_notif_subs;
373: