DBA Data[Home] [Help]

APPS.GMD_FOR_SEC1 dependencies on FND_API

Line 6: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

2: /* $Header: GMDFSPRB.pls 120.1 2005/07/26 14:02:58 txdaniel noship $ */
3:
4: PROCEDURE sec_prof_form(
5: p_api_version IN NUMBER,
6: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
7: before_sec_prof_rec IN gmd_security_profiles%ROWTYPE,
8: sec_prof_rec IN gmd_security_profiles%ROWTYPE,
9: p_formula_id IN NUMBER,
10: p_db_action_ind IN VARCHAR2,

Line 200: WHEN FND_API.G_EXC_ERROR THEN

196: /*standard call to get msge cnt, and if cnt is 1, get mesg info*/
197: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
198:
199: EXCEPTION
200: WHEN FND_API.G_EXC_ERROR THEN
201: fnd_global.apps_initialize (x_user_id, x_resp_id , 552);
202: X_return_code := SQLCODE;
203: x_return_status := FND_API.G_RET_STS_ERROR;
204: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);

Line 203: x_return_status := FND_API.G_RET_STS_ERROR;

199: EXCEPTION
200: WHEN FND_API.G_EXC_ERROR THEN
201: fnd_global.apps_initialize (x_user_id, x_resp_id , 552);
202: X_return_code := SQLCODE;
203: x_return_status := FND_API.G_RET_STS_ERROR;
204: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
205:
206: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
207: fnd_global.apps_initialize (x_user_id, x_resp_id , 552);

Line 206: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

202: X_return_code := SQLCODE;
203: x_return_status := FND_API.G_RET_STS_ERROR;
204: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
205:
206: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
207: fnd_global.apps_initialize (x_user_id, x_resp_id , 552);
208: X_return_code := SQLCODE;
209: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
210: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);

Line 209: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

205:
206: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
207: fnd_global.apps_initialize (x_user_id, x_resp_id , 552);
208: X_return_code := SQLCODE;
209: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
210: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
211:
212: WHEN OTHERS THEN
213: fnd_global.apps_initialize (x_user_id, x_resp_id , 552);

Line 214: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

210: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
211:
212: WHEN OTHERS THEN
213: fnd_global.apps_initialize (x_user_id, x_resp_id , 552);
214: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
215: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
216: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
217: FND_MSG_PUB.ADD;
218: FND_MSG_PUB.COUNT_AND_GET (P_count => x_msg_count,