50:
51:
52: BEGIN
53:
54: dbms_output.put_line ('Update_Card_Status');
55:
56:
57: IF p_document_type = 'PO' THEN
58:
143: CLOSE Kanban_req_line;
144:
145:
146: ELSE
147: dbms_output.put_line ('Invalid document type passed');
148:
149: END IF;
150:
151:
148:
149: END IF;
150:
151:
152: dbms_output.put_line ('End Update_Card_Status');
153:
154: EXCEPTION
155:
156: WHEN OTHERS THEN
178:
179:
180: BEGIN
181:
182: dbms_output.put_line ('Start Update_Card_Status_Full ');
183:
184: INV_KANBAN_PVT.UPDATE_CARD_SUPPLY_STATUS
185: (p_kanban_return_status,
186: p_kanban_card_ID,
185: (p_kanban_return_status,
186: p_kanban_card_ID,
187: INV_KANBAN_PVT.G_SUPPLY_STATUS_FULL);
188:
189: dbms_output.put_line ('End Update_Card_Status_Full ');
190:
191: EXCEPTION
192:
193: WHEN OTHERS THEN