DBA Data[Home] [Help]

APPS.CUG_WF_EMAIL_UTIL dependencies on FND_API

Line 27: X_RETURN_STATUS VARCHAR2(80):= FND_API.G_RET_STS_SUCCESS;

23: lv_itemkey VARCHAR2(240);
24: lv_task_number VARCHAR2(30);
25: lv_incident_number VARCHAR2(64);
26: lv_release_resource_type VARCHAR2(80);
27: X_RETURN_STATUS VARCHAR2(80):= FND_API.G_RET_STS_SUCCESS;
28:
29: lv_task_id NUMBER := 0;
30: lv_task_type_id NUMBER := 0;
31: lv_incident_id NUMBER := 0;

Line 76: IF (X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS ) THEN

72:
73:
74:
75:
76: IF (X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS ) THEN
77: RESULTOUT := 'COMPLETE:';
78: return;
79: END IF;
80:

Line 95: IF (X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS ) THEN

91: ,lv_incident_number
92: ,X_RETURN_STATUS );
93:
94:
95: IF (X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS ) THEN
96: RESULTOUT := 'COMPLETE:';
97: return;
98: END IF;
99:

Line 116: IF (X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS ) THEN

112: , X_RETURN_STATUS );
113:
114:
115:
116: IF (X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS ) THEN
117: RESULTOUT := 'COMPLETE:';
118: return;
119: END IF;
120: RESULTOUT := 'COMPLETE:';

Line 234: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR ;

230: CLOSE c_all_task_attrs;
231:
232: EXCEPTION
233: WHEN NO_DATA_FOUND THEN
234: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR ;
235: END Get_Task_Attrs_Details;
236:
237:
238:

Line 440: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR ;

436: AVALUE => lv_incident_address );
437:
438: EXCEPTION
439: WHEN NO_DATA_FOUND THEN
440: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR ;
441: End Get_Incident_Addr_Details;
442:
443: PROCEDURE Get_SR_Attrs_Details (
444: ITEMTYPE IN VARCHAR2

Line 596: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR ;

592: CLOSE c_all_sr_attrs_details;
593: return;
594: EXCEPTION
595: WHEN NO_DATA_FOUND THEN
596: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR ;
597: return;
598: End Get_SR_Attrs_Details;
599:
600: PROCEDURE Set_Reminder_Interval

Line 851: x_return_status := fnd_api.g_ret_sts_success ;

847: WF_CORE.context('CUG_WF_EMAIL_UTIL', 'Set_Email_Status:profile_not_set', itemtype, itemkey, actid, funcmode );
848: RAISE;
849: end;
850:
851: x_return_status := fnd_api.g_ret_sts_success ;
852:
853: -- Update the status in the
854:
855: jtf_tasks_pub.update_task (

Line 857: p_init_msg_list => fnd_api.g_false ,

853: -- Update the status in the
854:
855: jtf_tasks_pub.update_task (
856: p_api_version => 1.0,
857: p_init_msg_list => fnd_api.g_false ,
858: p_commit => fnd_api.g_true,
859: p_object_version_number => lv_object_version_number ,
860: p_task_id => lv_task_id ,
861: p_task_status_id => lv_task_status_id ,

Line 858: p_commit => fnd_api.g_true,

854:
855: jtf_tasks_pub.update_task (
856: p_api_version => 1.0,
857: p_init_msg_list => fnd_api.g_false ,
858: p_commit => fnd_api.g_true,
859: p_object_version_number => lv_object_version_number ,
860: p_task_id => lv_task_id ,
861: p_task_status_id => lv_task_status_id ,
862: x_return_status => x_return_status ,

Line 866: IF NOT (x_return_status <> fnd_api.g_ret_sts_success ) THEN

862: x_return_status => x_return_status ,
863: x_msg_count => x_msg_count ,
864: x_msg_data => x_msg_data );
865:
866: IF NOT (x_return_status <> fnd_api.g_ret_sts_success ) THEN
867: WF_CORE.context('CUG_WF_EMAIL_UTIL', 'Set_Email_Status:update_task', itemtype, itemkey, actid, funcmode );
868: END IF;
869:
870: RESULTOUT := 'COMPLETE:';