DBA Data[Home] [Help]

APPS.CSP_PICK_SL_UTIL dependencies on CSP_PICKLIST_SERIAL_LOTS

Line 158: FROM CSP_Picklist_Serial_Lots

154:
155: BEGIN
156: -- validate whether the px_picklist_serial_lot_id exists.
157: SELECT picklist_serial_lot_id INTO l_check_existence
158: FROM CSP_Picklist_Serial_Lots
159: WHERE picklist_serial_lot_id = px_picklist_serial_lot_id
160: AND picklist_line_id = p_picklist_line_id;
161:
162: EXCEPTION

Line 173: fnd_message.set_token('TABLE', 'csp_picklist_serial_lots', TRUE);

169: WHEN OTHERS THEN
170: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
171: fnd_message.set_token('ERR_FIELD', 'px_picklist_serial_lot_id', TRUE);
172: fnd_message.set_token('ROUTINE', l_api_name, TRUE);
173: fnd_message.set_token('TABLE', 'csp_picklist_serial_lots', TRUE);
174: FND_MSG_PUB.ADD;
175: RAISE EXCP_USER_DEFINED;
176: END;
177: END IF;