DBA Data[Home] [Help]

APPS.FLM_RECEIPT_PUB dependencies on INV_KANBAN_PVT

Line 168: IF l_kanban_details_rec.card_status <> INV_KANBAN_PVT.G_Card_Status_Active THEN

164: END IF;
165:
166:
167: -- Validate card status for 'Active'
168: IF l_kanban_details_rec.card_status <> INV_KANBAN_PVT.G_Card_Status_Active THEN
169:
170: x_ret_status := FND_API.G_RET_STS_ERROR;
171:
172: fnd_message.set_name('FLM', 'FLM_INVALID_CARD_STATUS');

Line 178: IF l_kanban_details_rec.source_type NOT IN (INV_KANBAN_PVT.G_Source_Type_InterOrg, INV_KANBAN_PVT.G_Source_Type_Supplier) THEN

174:
175: END IF;
176:
177: -- Validate source type for supplier / inter org
178: IF l_kanban_details_rec.source_type NOT IN (INV_KANBAN_PVT.G_Source_Type_InterOrg, INV_KANBAN_PVT.G_Source_Type_Supplier) THEN
179:
180: x_ret_status := FND_API.G_RET_STS_ERROR;
181:
182: fnd_message.set_name('FLM', 'FLM_RCV_SRC_TYPE_ERR');

Line 188: IF TRUNC(l_kanban_details_rec.supply_status) <> INV_KANBAN_PVT.G_Supply_Status_InProcess THEN

184:
185: END IF;
186:
187: -- Validate supply status for In Process
188: IF TRUNC(l_kanban_details_rec.supply_status) <> INV_KANBAN_PVT.G_Supply_Status_InProcess THEN
189:
190: x_ret_status := FND_API.G_RET_STS_ERROR;
191:
192: fnd_message.set_name('FLM', 'FLM_INVALID_KANBAN_STATUS');

Line 214: IF l_kanban_details_rec.source_type = INV_KANBAN_PVT.G_Source_Type_Supplier THEN

210:
211: END IF;
212:
213:
214: IF l_kanban_details_rec.source_type = INV_KANBAN_PVT.G_Source_Type_Supplier THEN
215:
216: OPEN c_po_details(p_kanban_card_id);
217: FETCH c_po_details INTO l_po_details_rec;
218: CLOSE c_po_details;

Line 246: ELSIF l_kanban_details_rec.source_type = INV_KANBAN_PVT.G_Source_Type_InterOrg THEN

242: - l_po_details_rec.quantity_delivered;
243:
244: END IF;
245:
246: ELSIF l_kanban_details_rec.source_type = INV_KANBAN_PVT.G_Source_Type_InterOrg THEN
247:
248: OPEN c_ship_totals(p_kanban_card_id);
249: FETCH c_ship_totals INTO l_ship_totals_rec;
250: CLOSE c_ship_totals;

Line 1465: IF l_source_type = INV_KANBAN_PVT.G_Source_Type_Supplier THEN

1461: OPEN c_get_kanban_source_type(p_kanban_card_id);
1462: FETCH c_get_kanban_source_type INTO l_source_type;
1463: CLOSE c_get_kanban_source_type;
1464:
1465: IF l_source_type = INV_KANBAN_PVT.G_Source_Type_Supplier THEN
1466:
1467: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1468: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1469: l_log_module || '.receive_supplier',

Line 1488: ELSIF l_source_type = INV_KANBAN_PVT.G_Source_Type_InterOrg THEN

1484: 'x_ret_status = ' || x_ret_status || ', ' ||
1485: 'x_err_msg = ' || x_err_msg);
1486: END IF;
1487:
1488: ELSIF l_source_type = INV_KANBAN_PVT.G_Source_Type_InterOrg THEN
1489:
1490: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1491: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1492: l_log_module || '.receive_interorg',