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