APPS.GMD_FOR_SEC1 dependencies on FND_GLOBAL

Line 57: SELECT fnd_global.resp_id INTO x_resp_id FROM dual;

53: v_resp_id NUMBER;
54: BEGIN
55:
56: x_return_status := 'S';
57: SELECT fnd_global.resp_id INTO x_resp_id FROM dual;
58: SELECT fnd_global.user_id INTO x_user_id FROM dual;
59:
60: SELECT responsibility_id INTO v_resp_id
61: FROM fnd_responsibility

Line 58: SELECT fnd_global.user_id INTO x_user_id FROM dual;

54: BEGIN
55:
56: x_return_status := 'S';
57: SELECT fnd_global.resp_id INTO x_resp_id FROM dual;
58: SELECT fnd_global.user_id INTO x_user_id FROM dual;
59:
60: SELECT responsibility_id INTO v_resp_id
61: FROM fnd_responsibility
62: WHERE responsibility_key = 'GMD_SECURITY_PROFILE_MGR';

Line 64: fnd_global.apps_initialize (2060, v_resp_id , 552);

60: SELECT responsibility_id INTO v_resp_id
61: FROM fnd_responsibility
62: WHERE responsibility_key = 'GMD_SECURITY_PROFILE_MGR';
63:
64: fnd_global.apps_initialize (2060, v_resp_id , 552);
65:
66: --
67: -- GMD_SECURITY_PROFILE table updated when called from GMDFMSCP form , Formula Id is always NULL
68: --

Line 195: fnd_global.apps_initialize (x_user_id, x_resp_id , 552);

191: AND NVL(other_organization_id, -1) = NVL(before_sec_prof_rec.other_organization_id, -1)
192: AND formula_id = p_formula_id ;
193: END IF;
194: END IF;
195: fnd_global.apps_initialize (x_user_id, x_resp_id , 552);
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

Line 201: fnd_global.apps_initialize (x_user_id, x_resp_id , 552);

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);
205:

Line 207: fnd_global.apps_initialize (x_user_id, x_resp_id , 552);

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);
211:

Line 213: fnd_global.apps_initialize (x_user_id, x_resp_id , 552);

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);
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;