DBA Data[Home] [Help]

APPS.CSP_PC_FORM_PICKLINES dependencies on MTL_UNITS_OF_MEASURE

Line 285: from mtl_units_of_measure

281: ELSE
282: -- validate the UOM code
283: BEGIN
284: select UOM_CODE into l_check_var
285: from mtl_units_of_measure
286: where UOM_CODE = p_uom_code;
287: EXCEPTION
288: WHEN NO_DATA_FOUND THEN
289: fnd_message.set_name('INV', 'INV_UOM_NOTFOUND');

Line 297: fnd_message.set_token('TABLE', 'MTL_UNITS_OF_MEASURE', FALSE);

293: WHEN OTHERS THEN
294: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
295: fnd_message.set_token('ERR_FIELD', 'p_line_id', FALSE);
296: fnd_message.set_token('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);
297: fnd_message.set_token('TABLE', 'MTL_UNITS_OF_MEASURE', FALSE);
298: FND_MSG_PUB.ADD;
299: RAISE EXCP_USER_DEFINED;
300: END;
301: END IF;

Line 444: from mtl_units_of_measure

440: IF nvl(p_uom_code, fnd_api.g_miss_char) <> fnd_api.g_miss_char THEN
441: -- validate the UOM code
442: BEGIN
443: select UOM_CODE into l_check_var
444: from mtl_units_of_measure
445: where UOM_CODE = p_uom_code;
446: EXCEPTION
447: WHEN NO_DATA_FOUND THEN
448: fnd_message.set_name('INV', 'INV_UOM_NOTFOUND');

Line 456: fnd_message.set_token('TABLE', 'MTL_UNITS_OF_MEASURE', FALSE);

452: WHEN OTHERS THEN
453: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
454: fnd_message.set_token('ERR_FIELD', 'p_line_id', FALSE);
455: fnd_message.set_token('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);
456: fnd_message.set_token('TABLE', 'MTL_UNITS_OF_MEASURE', FALSE);
457: FND_MSG_PUB.ADD;
458: RAISE EXCP_USER_DEFINED;
459: END;
460: END IF;