DBA Data[Home] [Help]

APPS.JTF_TASK_WORKFLOW_PKG dependencies on FND_API

Line 168: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,

164: end;
165:
166: PROCEDURE start_task_workflow (
167: p_api_version IN NUMBER,
168: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
169: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
170: p_task_id IN NUMBER,
171: p_old_assignee_code IN VARCHAR2 DEFAULT NULL,
172: p_old_assignee_id IN NUMBER DEFAULT NULL,

Line 169: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,

165:
166: PROCEDURE start_task_workflow (
167: p_api_version IN NUMBER,
168: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
169: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
170: p_task_id IN NUMBER,
171: p_old_assignee_code IN VARCHAR2 DEFAULT NULL,
172: p_old_assignee_id IN NUMBER DEFAULT NULL,
173: p_new_assignee_code IN VARCHAR2 DEFAULT NULL,

Line 239: x_return_status := fnd_api.g_ret_sts_success;

235:
236:
237:
238: SAVEPOINT start_task_workflow;
239: x_return_status := fnd_api.g_ret_sts_success;
240:
241: IF NOT fnd_api.compatible_api_call (
242: l_api_version,
243: p_api_version,

Line 241: IF NOT fnd_api.compatible_api_call (

237:
238: SAVEPOINT start_task_workflow;
239: x_return_status := fnd_api.g_ret_sts_success;
240:
241: IF NOT fnd_api.compatible_api_call (
242: l_api_version,
243: p_api_version,
244: l_api_name,
245: g_pkg_name

Line 248: RAISE fnd_api.g_exc_unexpected_error;

244: l_api_name,
245: g_pkg_name
246: )
247: THEN
248: RAISE fnd_api.g_exc_unexpected_error;
249: END IF;
250:
251: IF fnd_api.to_boolean (p_init_msg_list)
252: THEN

Line 251: IF fnd_api.to_boolean (p_init_msg_list)

247: THEN
248: RAISE fnd_api.g_exc_unexpected_error;
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:

Line 269: RAISE fnd_api.g_exc_unexpected_error;

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;
273: FETCH c_wf_processs_id INTO l_wf_process_id;

Line 287: RAISE fnd_api.g_exc_unexpected_error;

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;
291: wf_engine.createprocess (

Line 371: raise fnd_api.g_exc_unexpected_error;

367: ----
368: l_owner_user_name := jtf_rs_resource_pub.get_wf_role( l_owner_id );
369:
370: if l_owner_user_name is null then
371: raise fnd_api.g_exc_unexpected_error;
372: end if ;
373:
374: wf_engine.setitemattrtext (
375: itemtype => 'JTFTASK',

Line 407: raise fnd_api.g_exc_unexpected_error;

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
407: raise fnd_api.g_exc_unexpected_error;
408: end if ;
409:
410:
411:

Line 466: raise fnd_api.g_exc_unexpected_error;

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
466: raise fnd_api.g_exc_unexpected_error;
467: end if ;
468: l_old_assigned_user_name := jtf_rs_resource_pub.get_wf_role( p_old_assignee_id );
469: if l_old_assigned_user_name is null then
470: raise fnd_api.g_exc_unexpected_error;

Line 470: raise fnd_api.g_exc_unexpected_error;

466: raise fnd_api.g_exc_unexpected_error;
467: end if ;
468: l_old_assigned_user_name := jtf_rs_resource_pub.get_wf_role( p_old_assignee_id );
469: if l_old_assigned_user_name is null then
470: raise fnd_api.g_exc_unexpected_error;
471: end if ;
472:
473:
474: wf_engine.setitemattrtext (

Line 535: raise fnd_api.g_exc_unexpected_error;

531:
532: l_old_assigned_user_name := jtf_rs_resource_pub.get_wf_role( p_old_assignee_id );
533:
534: if l_old_assigned_user_name is null then
535: raise fnd_api.g_exc_unexpected_error;
536: end if ;
537: wf_engine.setitemattrtext (
538: itemtype => 'JTFTASK',
539: itemkey => l_itemkey,

Line 577: raise fnd_api.g_exc_unexpected_error;

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
577: raise fnd_api.g_exc_unexpected_error;
578: end if ;
579:
580: l_old_assigned_user_name := jtf_rs_resource_pub.get_wf_role( p_old_owner_id );
581: if l_old_assigned_user_name is null then

Line 582: raise fnd_api.g_exc_unexpected_error;

578: end if ;
579:
580: l_old_assigned_user_name := jtf_rs_resource_pub.get_wf_role( p_old_owner_id );
581: if l_old_assigned_user_name is null then
582: raise fnd_api.g_exc_unexpected_error;
583: end if ;
584: wf_engine.setitemattrtext (
585: itemtype => 'JTFTASK',
586: itemkey => l_itemkey,

Line 670: IF fnd_api.to_boolean (p_commit)

666: itemtype => 'JTFTASK',
667: itemkey => l_itemkey
668: );
669:
670: IF fnd_api.to_boolean (p_commit)
671: THEN
672: COMMIT WORK;
673: END IF;
674:

Line 679: WHEN fnd_api.g_exc_unexpected_error

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
681:
682: ROLLBACK TO start_task_workflow;
683: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 683: x_return_status := fnd_api.g_ret_sts_unexp_error;

679: WHEN fnd_api.g_exc_unexpected_error
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: );

Line 703: x_return_status := fnd_api.g_ret_sts_unexp_error;

699: end if;
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:

Line 710: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,

706:
707:
708: PROCEDURE abort_task_workflow (
709: p_api_version IN NUMBER,
710: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
711: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
712: p_task_id IN NUMBER,
713: p_wf_process_id IN NUMBER,
714: p_user_code IN VARCHAR2,

Line 711: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,

707:
708: PROCEDURE abort_task_workflow (
709: p_api_version IN NUMBER,
710: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
711: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
712: p_task_id IN NUMBER,
713: p_wf_process_id IN NUMBER,
714: p_user_code IN VARCHAR2,
715: p_user_id IN NUMBER,

Line 744: x_return_status := fnd_api.g_ret_sts_success;

740: wf_not_active EXCEPTION;
741: BEGIN
742: SAVEPOINT abort_task_workflow;
743:
744: x_return_status := fnd_api.g_ret_sts_success;
745:
746: IF NOT fnd_api.compatible_api_call (
747: l_api_version,
748: p_api_version,

Line 746: IF NOT fnd_api.compatible_api_call (

742: SAVEPOINT abort_task_workflow;
743:
744: x_return_status := fnd_api.g_ret_sts_success;
745:
746: IF NOT fnd_api.compatible_api_call (
747: l_api_version,
748: p_api_version,
749: l_api_name,
750: g_pkg_name

Line 753: RAISE fnd_api.g_exc_unexpected_error;

749: l_api_name,
750: g_pkg_name
751: )
752: THEN
753: RAISE fnd_api.g_exc_unexpected_error;
754: END IF;
755:
756: IF fnd_api.to_boolean (p_init_msg_list)
757: THEN

Line 756: IF fnd_api.to_boolean (p_init_msg_list)

752: THEN
753: RAISE fnd_api.g_exc_unexpected_error;
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:

Line 775: raise fnd_api.g_exc_unexpected_error;

771: END IF;
772:
773: l_aborted_by_user_name := jtf_rs_resource_pub.get_wf_role( p_user_id );
774: if l_aborted_by_user_name is null then
775: raise fnd_api.g_exc_unexpected_error;
776: end if ;
777:
778: OPEN c_task_details;
779: FETCH c_task_details INTO l_task_name,

Line 795: raise fnd_api.g_exc_unexpected_error;

791: CLOSE c_task_details;
792:
793: l_task_owner_name := jtf_rs_resource_pub.get_wf_role( l_owner_id );
794: if l_task_owner_name is null then
795: raise fnd_api.g_exc_unexpected_error;
796: end if ;
797:
798:
799: wf_engine.abortprocess (

Line 846: x_return_status := fnd_api.g_ret_sts_unexp_error;

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
850: ROLLBACK TO abort_task_workflow ;

Line 853: x_return_status := fnd_api.g_ret_sts_unexp_error;

849: THEN
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;