[Home] [Help]
737: FND_MSG_PUB.Add;
738: l_return_status := FND_API.G_RET_STS_ERROR;
739: ELSE
740:
741: l_kanban_card_rec := INV_KanbanCard_PKG.Query_Row
742: ( p_Kanban_Card_id => p_kanban_Card_Id);
743:
744: --Bug 3288422 fix. Preventing replenishment 1) If lock cannot be
745: --acquired on the kanban_card_record 2) if the card is in hold
770: FND_MSG_PUB.ADD;
771:
772: --Bug 3288422 fix.
773: ELSE
774: IF INV_KanbanCard_PKG.Supply_Status_Change_OK
775: (l_kanban_card_rec.supply_status,
776: p_supply_status,
777: l_kanban_card_rec.card_status)
778: THEN
802: l_kanban_card_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
803: l_kanban_card_rec.replenish_quantity := p_replenish_quantity;
804: l_kanban_card_rec.need_by_date := p_need_by_date;
805: l_kanban_card_rec.source_wip_entity_id := p_source_wip_entity_id;
806: mydebug('calling INV_KanbanCard_PKG.Update_Row');
807: INV_KanbanCard_PKG.Update_Row(l_kanban_card_rec);
808: END IF;
809: ELSE
810: mydebug('Supply status change not OK');
803: l_kanban_card_rec.replenish_quantity := p_replenish_quantity;
804: l_kanban_card_rec.need_by_date := p_need_by_date;
805: l_kanban_card_rec.source_wip_entity_id := p_source_wip_entity_id;
806: mydebug('calling INV_KanbanCard_PKG.Update_Row');
807: INV_KanbanCard_PKG.Update_Row(l_kanban_card_rec);
808: END IF;
809: ELSE
810: mydebug('Supply status change not OK');
811: If l_kanban_card_rec.card_status in
815: FND_MESSAGE.SET_TOKEN('CARD_NUMBER',l_kanban_card_rec.kanban_card_number);
816: End If;
817: l_return_status := FND_API.G_RET_STS_ERROR;
818: FND_MSG_PUB.Add;
819: END IF;--IF INV_KanbanCard_PKG.Supply_Status_Change_OK
820: END IF;--IF l_return_status = FND_API.g_ret_sts_error
821: END IF;--IF p_Kanban_Card_Id is NULL THEN
822:
823: IF l_return_status = FND_API.g_ret_sts_error THEN
1454: IS
1455: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1456: BEGIN
1457:
1458: INV_KanbanCard_PKG.Delete_Cards_For_Pull_Seq(p_pull_sequence_id);
1459:
1460: END Delete_Kanban_Cards;
1461: --
1462: --
1560:
1561: l_Kanban_Card_Id := NULL;
1562: l_Kanban_Card_Number := NULL;
1563:
1564: INV_KanbanCard_PKG.Insert_Row(
1565: X_Return_Status => l_Return_Status,
1566: P_Kanban_Card_Id => l_Kanban_Card_Id,
1567: P_Kanban_Card_Number => l_Kanban_Card_Number,
1568: P_Pull_Sequence_Id => p_Pull_Sequence_Rec.Pull_Sequence_Id,
3448:
3449: l_Kanban_Card_Rec.Kanban_card_Id :=
3450: l_Kanban_card_Tbl(l_Card_Count).Kanban_card_Id;
3451: l_kanban_card_rec :=
3452: INV_KanbanCard_PKG.Query_Row( p_Kanban_Card_id =>
3453: l_Kanban_card_Tbl(l_Card_Count).Kanban_card_Id);
3454: l_kanban_card_rec.document_type :=
3455: l_Kanban_card_Tbl(l_Card_Count).document_type;
3456: l_kanban_card_rec.document_header_id :=
3457: l_Kanban_card_Tbl(l_Card_Count).document_header_id;
3458: l_kanban_card_rec.document_detail_id :=
3459: l_Kanban_card_Tbl(l_Card_Count).document_detail_id;
3460:
3461: INV_KanbanCard_PKG.Insert_Activity_For_Card(l_Kanban_Card_Rec);
3462:
3463: End Loop;
3464: Else
3465:
3560: BEGIN
3561:
3562: for kanban_cards_ids in get_kanban_card_ids
3563: LOOP
3564: l_kanban_card_rec := inv_kanbancard_pkg.query_row(kanban_cards_ids.kanban_card_id);
3565: inv_kanbancard_pkg.update_card_status
3566: (p_kanban_card_rec =>l_kanban_card_rec,
3567: p_card_status => p_card_status);
3568: END LOOP;
3561:
3562: for kanban_cards_ids in get_kanban_card_ids
3563: LOOP
3564: l_kanban_card_rec := inv_kanbancard_pkg.query_row(kanban_cards_ids.kanban_card_id);
3565: inv_kanbancard_pkg.update_card_status
3566: (p_kanban_card_rec =>l_kanban_card_rec,
3567: p_card_status => p_card_status);
3568: END LOOP;
3569: