82: EXCEPTION
83: WHEN NO_DATA_FOUND THEN
84: RETURN TRUE;
85: WHEN OTHERS THEN
86: fnd_message.set_name('INV', 'INV_KANBAN_CARD_NUM_EXISTS');
87: fnd_message.set_token('CARD_NUMBER', p_kanban_card_number);
88: RETURN FALSE;
89: END check_unique;
90:
83: WHEN NO_DATA_FOUND THEN
84: RETURN TRUE;
85: WHEN OTHERS THEN
86: fnd_message.set_name('INV', 'INV_KANBAN_CARD_NUM_EXISTS');
87: fnd_message.set_token('CARD_NUMBER', p_kanban_card_number);
88: RETURN FALSE;
89: END check_unique;
90:
91: FUNCTION query_row(p_kanban_card_id IN NUMBER)
214: BEGIN
215: /*
216: If p_card_status = INV_Kanban_PVT.G_Card_Status_Cancel
217: Then
218: FND_MESSAGE.SET_NAME('INV','INV_NO_ACT_ALLOW_CANCEL_CARD');
219: Return False;
220: Elsif p_card_status = INV_Kanban_PVT.G_Card_Status_Hold
221: Then
222: FND_MESSAGE.SET_NAME('INV','INV_NO_ACT_ALLOW_HOLD_CARD');
218: FND_MESSAGE.SET_NAME('INV','INV_NO_ACT_ALLOW_CANCEL_CARD');
219: Return False;
220: Elsif p_card_status = INV_Kanban_PVT.G_Card_Status_Hold
221: Then
222: FND_MESSAGE.SET_NAME('INV','INV_NO_ACT_ALLOW_HOLD_CARD');
223: Return False;
224: Else
225: */
226: l_result := fnd_api.to_boolean(g_supply_status_change_tbl(cell(p_to_supply_status, p_from_supply_status)));
239: AND a.lookup_code = p_from_supply_status
240: AND b.lookup_type = 'MTL_KANBAN_SUPPLY_STATUS'
241: AND b.lookup_code = p_to_supply_status;
242:
243: fnd_message.set_name('INV', 'INV_SUPPLY_STATUS_NOT_ALLOWED');
244: fnd_message.set_token('SUPPLY_STATUS_FROM', l_supply_status_from);
245: fnd_message.set_token('SUPPLY_STATUS_TO', l_supply_status_to);
246: EXCEPTION
247: WHEN OTHERS THEN
240: AND b.lookup_type = 'MTL_KANBAN_SUPPLY_STATUS'
241: AND b.lookup_code = p_to_supply_status;
242:
243: fnd_message.set_name('INV', 'INV_SUPPLY_STATUS_NOT_ALLOWED');
244: fnd_message.set_token('SUPPLY_STATUS_FROM', l_supply_status_from);
245: fnd_message.set_token('SUPPLY_STATUS_TO', l_supply_status_to);
246: EXCEPTION
247: WHEN OTHERS THEN
248: NULL;
241: AND b.lookup_code = p_to_supply_status;
242:
243: fnd_message.set_name('INV', 'INV_SUPPLY_STATUS_NOT_ALLOWED');
244: fnd_message.set_token('SUPPLY_STATUS_FROM', l_supply_status_from);
245: fnd_message.set_token('SUPPLY_STATUS_TO', l_supply_status_to);
246: EXCEPTION
247: WHEN OTHERS THEN
248: NULL;
249: END;
812: FETCH get_current_row INTO recinfo;
813:
814: IF (get_current_row%NOTFOUND) THEN
815: CLOSE get_current_row;
816: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
817: app_exception.raise_exception;
818: END IF;
819:
820: CLOSE get_current_row;
918: RAISE record_changed;
919: END IF;
920: EXCEPTION
921: WHEN record_changed THEN
922: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
923: app_exception.raise_exception;
924: WHEN OTHERS THEN
925: RAISE;
926: END lock_row;