249: END IF;
250:
251: IF fnd_api.to_boolean (p_init_msg_list)
252: THEN
253: fnd_msg_pub.initialize;
254: END IF;
255:
256:
257:
264: )
265: THEN
266: null;
267: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_EVENT');
268: fnd_msg_pub.add;
269: RAISE fnd_api.g_exc_unexpected_error;
270: END IF;
271:
272: OPEN c_wf_processs_id;
282:
283: IF c_task_details%NOTFOUND
284: THEN
285: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_ID');
286: fnd_msg_pub.add;
287: RAISE fnd_api.g_exc_unexpected_error;
288: END IF;
289:
290: CLOSE c_task_details;
398: OR p_new_assignee_id IS NULL)
399: THEN
400: null ;
401: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_ASSIGNEE_DETAILS');
402: fnd_msg_pub.add;
403: ELSE
404: l_new_assigned_user_name := jtf_rs_resource_pub.get_wf_role( p_new_assignee_id );
405:
406: if l_new_assigned_user_name is null then
451: OR p_old_assignee_id IS NULL)
452: THEN
453: null ;
454: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_ASSIGNEE_DETAILS');
455: fnd_msg_pub.add;
456: ELSIF ( p_old_assignee_code IS NULL
457: OR p_old_assignee_id IS NULL)
458: THEN
459:
457: OR p_old_assignee_id IS NULL)
458: THEN
459:
460: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_ASSIGNEE_DETAILS');
461: fnd_msg_pub.add;
462: ELSE
463: l_new_assigned_user_name := jtf_rs_resource_pub.get_wf_role( p_new_assignee_id );
464:
465: if l_new_assigned_user_name is null then
525: IF ( p_old_assignee_code IS NULL
526: OR p_old_assignee_id IS NULL)
527: THEN
528: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_ASSIGNEE_DETAILS');
529: fnd_msg_pub.add;
530: ELSE
531:
532: l_old_assigned_user_name := jtf_rs_resource_pub.get_wf_role( p_old_assignee_id );
533:
563: IF ( p_old_owner_code IS NULL
564: OR p_old_owner_id IS NULL)
565: THEN
566: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_OWNER_DETAILS');
567: fnd_msg_pub.add;
568: ELSIF ( p_new_owner_code IS NULL
569: OR p_new_owner_id IS NULL)
570: THEN
571: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_OWNER_DETAILS');
568: ELSIF ( p_new_owner_code IS NULL
569: OR p_new_owner_id IS NULL)
570: THEN
571: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_OWNER_DETAILS');
572: fnd_msg_pub.add;
573: ELSE
574:
575: l_new_assigned_user_name := jtf_rs_resource_pub.get_wf_role( p_new_owner_id );
576: if l_new_assigned_user_name is null then
648:
649: END LOOP;
650: ELSE
651: fnd_message.set_name ('JTF', 'JTF_TASK_NO_ATTRIBUTES_PASSED');
652: fnd_msg_pub.add;
653: END IF;
654:
655: wf_engine.setitemattrtext (
656: itemtype => 'JTFTASK',
672: COMMIT WORK;
673: END IF;
674:
675:
676: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
677:
678: EXCEPTION
679: WHEN fnd_api.g_exc_unexpected_error
680: THEN
680: THEN
681:
682: ROLLBACK TO start_task_workflow;
683: x_return_status := fnd_api.g_ret_sts_unexp_error;
684: fnd_msg_pub.count_and_get (
685: p_count => x_msg_count,
686: p_data => x_msg_data
687: );
688: WHEN OTHERS
694: if (l_errname is not null) then
695: fnd_message.set_name('FND', 'WF_ERROR');
696: fnd_message.set_token('ERROR_MESSAGE', l_errmsg);
697: fnd_message.set_token('ERROR_STACK', l_errstack);
698: fnd_msg_pub.add;
699: end if;
700:
701: ---fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
702: ---fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
700:
701: ---fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
702: ---fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
703: x_return_status := fnd_api.g_ret_sts_unexp_error;
704: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
705: END;
706:
707:
708: PROCEDURE abort_task_workflow (
754: END IF;
755:
756: IF fnd_api.to_boolean (p_init_msg_list)
757: THEN
758: fnd_msg_pub.initialize;
759: END IF;
760:
761:
762: l_itemkey := TO_CHAR (p_task_id) || '-' || TO_CHAR (p_wf_process_id);
784:
785: IF c_task_details%NOTFOUND
786: THEN
787: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_ID');
788: fnd_msg_pub.add;
789: END IF;
790:
791: CLOSE c_task_details;
792:
841: EXCEPTION
842: when wf_not_active then
843: ROLLBACK TO abort_task_workflow ;
844: fnd_message.set_name('JTF','Workflow is not active ');
845: fnd_msg_pub.add ;
846: x_return_status := fnd_api.g_ret_sts_unexp_error;
847: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
848: WHEN OTHERS
849: THEN
843: ROLLBACK TO abort_task_workflow ;
844: fnd_message.set_name('JTF','Workflow is not active ');
845: fnd_msg_pub.add ;
846: x_return_status := fnd_api.g_ret_sts_unexp_error;
847: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
848: WHEN OTHERS
849: THEN
850: ROLLBACK TO abort_task_workflow ;
851: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
850: ROLLBACK TO abort_task_workflow ;
851: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
852: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
853: x_return_status := fnd_api.g_ret_sts_unexp_error;
854: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
855:
856:
857: END;
858: