DBA Data[Home] [Help]

APPS.CSP_PC_FORM_PICKHEADERS dependencies on MTL_PARAMETERS

Line 171: from mtl_parameters

167: RAISE EXCP_USER_DEFINED;
168: ELSE
169: BEGIN
170: select organization_id into l_check_existence
171: from mtl_parameters
172: where organization_id = p_organization_id;
173: EXCEPTION
174: WHEN NO_DATA_FOUND THEN
175: FND_MESSAGE.SET_NAME ('INV', 'INVALID ORGANIZATION');

Line 267: from mtl_parameters

263: --validation of organization_id
264: IF nvl(p_organization_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN
265: BEGIN
266: select organization_id into l_check_existence
267: from mtl_parameters
268: where organization_id = p_organization_id;
269: EXCEPTION
270: WHEN NO_DATA_FOUND THEN
271: FND_MESSAGE.SET_NAME ('INV', 'INVALID ORGANIZATION');

Line 278: fnd_message.set_token('TABLE', 'MTL_PARAMETERS', FALSE);

274: WHEN OTHERS THEN
275: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
276: fnd_message.set_token('ERR_FIELD', 'p_organization_id', FALSE);
277: fnd_message.set_token('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);
278: fnd_message.set_token('TABLE', 'MTL_PARAMETERS', FALSE);
279: FND_MSG_PUB.ADD;
280: RAISE EXCP_USER_DEFINED;
281: END;
282: END IF;