APPS.CSM_PARTY_EVENT_PKG dependencies on FND_API

Line 68: x_return_status := FND_API.G_RET_STS_SUCCESS;

64: l_err_msg VARCHAR2(4000);
65: l_ret_status VARCHAR2(4000);
66:
67: BEGIN
68: x_return_status := FND_API.G_RET_STS_SUCCESS;
69: p_error_msg := 'Entering CSM_PARTY_EVENT_PKG.PARTY_ACC_I' || ' for party_id ' || to_char(p_party_id);
70:
71: CSM_ACC_PKG.Insert_Acc
72: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name1

Line 89: IF l_ret_status <> FND_API.G_RET_STS_SUCCESS THEN

85: p_error_msg => l_err_msg,
86: x_return_status => l_ret_status
87: );
88:
89: IF l_ret_status <> FND_API.G_RET_STS_SUCCESS THEN
90: csm_util_pkg.LOG(l_err_msg, 'CSM_PARTY_EVENT_PKG.PARTY_ACC_I', FND_LOG.LEVEL_ERROR);
91: END IF;
92: END IF;
93:

Line 97: x_return_status := FND_API.G_RET_STS_ERROR;

93:
94: p_error_msg := 'Leaving CSM_PARTY_EVENT_PKG.PARTY_ACC_I' || ' for party_id ' || to_char(p_party_id);
95: EXCEPTION
96: WHEN others THEN
97: x_return_status := FND_API.G_RET_STS_ERROR;
98: p_error_msg := ' FAILED PARTY_ACC_I:' || to_char(p_party_id);
99: CSM_UTIL_PKG.LOG( p_error_msg, 'CSM_PARTY_EVENT_PKG.PARTY_ACC_I', FND_LOG.LEVEL_EXCEPTION);
100: RAISE;
101:

Line 157: x_return_status := FND_API.G_RET_STS_SUCCESS;

153: WHERE party_id = l_party_id
154: AND user_id = l_user_id;
155:
156: BEGIN
157: x_return_status := FND_API.G_RET_STS_SUCCESS;
158: p_error_msg := 'Entering CSM_PARTY_EVENT_PKG.PARTY_ACC_D' || ' for party_id ' || to_char(p_party_id);
159:
160: OPEN c_get_party_count(p_party_id, p_user_id) ;
161: FETCH c_get_party_count INTO l_count ;

Line 182: IF l_ret_status <> FND_API.G_RET_STS_SUCCESS THEN

178: p_error_msg => l_err_msg,
179: x_return_status => l_ret_status
180: );
181:
182: IF l_ret_status <> FND_API.G_RET_STS_SUCCESS THEN
183: csm_util_pkg.LOG(l_err_msg, 'CSM_PARTY_EVENT_PKG.PARTY_ACC_D', FND_LOG.LEVEL_ERROR);
184: END IF;
185: END IF;
186: ELSIF l_count = 1 THEN

Line 211: IF l_ret_status <> FND_API.G_RET_STS_SUCCESS THEN

207: p_error_msg => l_err_msg,
208: x_return_status => l_ret_status
209: );
210:
211: IF l_ret_status <> FND_API.G_RET_STS_SUCCESS THEN
212: csm_util_pkg.LOG(l_err_msg, 'CSM_PARTY_EVENT_PKG.PARTY_ACC_D', FND_LOG.LEVEL_ERROR);
213: END IF;
214: END IF;
215: END IF;

Line 221: x_return_status := FND_API.G_RET_STS_ERROR;

217: -- commented the above..as such cases should not occur
218: p_error_msg := 'Leaving CSM_PARTY_EVENT_PKG.PARTY_ACC_D' || ' for party_id ' || to_char(p_party_id);
219: EXCEPTION
220: WHEN others THEN
221: x_return_status := FND_API.G_RET_STS_ERROR;
222: p_error_msg := ' FAILED PARTY_ACC_D:' || to_char(p_party_id);
223: CSM_UTIL_PKG.LOG( p_error_msg, 'CSM_PARTY_EVENT_PKG.PARTY_ACC_D', FND_LOG.LEVEL_EXCEPTION);
224: RAISE;
225: