219: p_creation_date DATE,
220: p_created_by NUMBER,
221: p_last_update_login NUMBER)
222: IS
223: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
224:
225: BEGIN
226: FND_MSG_PUB.Initialize;
227:
251: p_last_update_login);
252:
253: x_return_status := l_return_status;
254: EXCEPTION
255: WHEN FND_API.G_EXC_ERROR THEN
256:
257: x_return_status := FND_API.G_RET_STS_ERROR;
258:
259: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
253: x_return_status := l_return_status;
254: EXCEPTION
255: WHEN FND_API.G_EXC_ERROR THEN
256:
257: x_return_status := FND_API.G_RET_STS_ERROR;
258:
259: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
260:
261: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
255: WHEN FND_API.G_EXC_ERROR THEN
256:
257: x_return_status := FND_API.G_RET_STS_ERROR;
258:
259: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
260:
261: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
262:
263: WHEN OTHERS THEN
257: x_return_status := FND_API.G_RET_STS_ERROR;
258:
259: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
260:
261: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
262:
263: WHEN OTHERS THEN
264: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
265: THEN
268: , 'insert_supplier_row'
269: );
270: END IF;
271:
272: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
273:
274: END insert_supplier_row;
275:
276: PROCEDURE insert_supplier_row(p_supplier_rec IN MTL_PULL_SEQ_SUPPLIERS%ROWTYPE)
294: p_creation_date => l_supplier_rec.creation_date,
295: p_created_by => l_supplier_rec.created_by,
296: p_last_update_login => l_supplier_rec.last_update_login);
297:
298: if l_return_status = FND_API.G_RET_STS_ERROR
299: Then
300: Raise FND_API.G_EXC_ERROR;
301: End if;
302:
296: p_last_update_login => l_supplier_rec.last_update_login);
297:
298: if l_return_status = FND_API.G_RET_STS_ERROR
299: Then
300: Raise FND_API.G_EXC_ERROR;
301: End if;
302:
303: if l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
304: Then
299: Then
300: Raise FND_API.G_EXC_ERROR;
301: End if;
302:
303: if l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
304: Then
305: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
306: End If;
307:
301: End if;
302:
303: if l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
304: Then
305: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
306: End If;
307:
308: EXCEPTION
309: WHEN FND_API.G_EXC_ERROR THEN
305: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
306: End If;
307:
308: EXCEPTION
309: WHEN FND_API.G_EXC_ERROR THEN
310:
311: Raise FND_API.G_EXC_ERROR;
312:
313: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
307:
308: EXCEPTION
309: WHEN FND_API.G_EXC_ERROR THEN
310:
311: Raise FND_API.G_EXC_ERROR;
312:
313: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
314:
315: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
309: WHEN FND_API.G_EXC_ERROR THEN
310:
311: Raise FND_API.G_EXC_ERROR;
312:
313: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
314:
315: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
316:
317: WHEN OTHERS THEN
311: Raise FND_API.G_EXC_ERROR;
312:
313: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
314:
315: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
316:
317: WHEN OTHERS THEN
318:
319: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
323: , 'insert_supplier_row'
324: );
325: END IF;
326:
327: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
328:
329: END insert_supplier_row;
330:
331: --------------------------
340: p_last_update_date DATE,
341: p_last_updated_by NUMBER,
342: p_last_update_login NUMBER)
343: IS
344: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
345: BEGIN
346: FND_MSG_PUB.Initialize;
347:
348: mydebug('Updating MTL_PULL_SEQ_SUPPLIERS table.');
364: x_return_status := l_return_status;
365:
366: EXCEPTION
367:
368: WHEN FND_API.G_EXC_ERROR THEN
369:
370: x_return_status := FND_API.G_RET_STS_ERROR;
371:
372: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
366: EXCEPTION
367:
368: WHEN FND_API.G_EXC_ERROR THEN
369:
370: x_return_status := FND_API.G_RET_STS_ERROR;
371:
372: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
373:
374: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
368: WHEN FND_API.G_EXC_ERROR THEN
369:
370: x_return_status := FND_API.G_RET_STS_ERROR;
371:
372: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
373:
374: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
375:
376: WHEN OTHERS THEN
370: x_return_status := FND_API.G_RET_STS_ERROR;
371:
372: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
373:
374: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
375:
376: WHEN OTHERS THEN
377:
378: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
382: , 'update_supplier_row'
383: );
384: END IF;
385:
386: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
387:
388: END update_supplier_row;
389:
390: PROCEDURE update_supplier_row(p_supplier_rec IN MTL_PULL_SEQ_SUPPLIERS%ROWTYPE)
404: p_last_update_date => l_supplier_rec.last_update_date,
405: p_last_updated_by => l_supplier_rec.last_updated_by,
406: p_last_update_login => l_supplier_rec.last_update_login);
407:
408: if l_return_status = FND_API.G_RET_STS_ERROR
409: Then
410: Raise FND_API.G_EXC_ERROR;
411: End if;
412:
406: p_last_update_login => l_supplier_rec.last_update_login);
407:
408: if l_return_status = FND_API.G_RET_STS_ERROR
409: Then
410: Raise FND_API.G_EXC_ERROR;
411: End if;
412:
413: if l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
414: Then
409: Then
410: Raise FND_API.G_EXC_ERROR;
411: End if;
412:
413: if l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
414: Then
415: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
416: End If;
417:
411: End if;
412:
413: if l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
414: Then
415: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
416: End If;
417:
418: EXCEPTION
419:
416: End If;
417:
418: EXCEPTION
419:
420: WHEN FND_API.G_EXC_ERROR THEN
421:
422: Raise FND_API.G_EXC_ERROR;
423:
424: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
418: EXCEPTION
419:
420: WHEN FND_API.G_EXC_ERROR THEN
421:
422: Raise FND_API.G_EXC_ERROR;
423:
424: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
425:
426: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
420: WHEN FND_API.G_EXC_ERROR THEN
421:
422: Raise FND_API.G_EXC_ERROR;
423:
424: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
425:
426: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
427:
428: WHEN OTHERS THEN
422: Raise FND_API.G_EXC_ERROR;
423:
424: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
425:
426: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
427:
428: WHEN OTHERS THEN
429:
430: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
433: ( G_PKG_NAME
434: , 'update_supplier_row'
435: );
436: END IF;
437: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
438: END update_supplier_row;
439:
440: --------------------------
441: --Delete Supplier row
444: PROCEDURE delete_supplier_row(x_return_status OUT NOCOPY VARCHAR2,
445: p_pull_sequence_id NUMBER,
446: p_supplier_id NUMBER)
447: IS
448: l_return_status varchar2(1) := FND_API.G_RET_STS_ERROR;
449: BEGIN
450: FND_MSG_PUB.Initialize;
451:
452: mydebug('In procedure delete_supplier_row.');
455: WHERE pull_sequence_id = p_pull_sequence_id
456: AND supplier_id = p_supplier_id;
457:
458: if (SQL%NOTFOUND) then
459: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
460: else
461: l_return_status := FND_API.G_RET_STS_SUCCESS;
462: end if;
463:
457:
458: if (SQL%NOTFOUND) then
459: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
460: else
461: l_return_status := FND_API.G_RET_STS_SUCCESS;
462: end if;
463:
464: x_return_status := l_return_status;
465:
466: EXCEPTION
467:
468: WHEN OTHERS THEN
469:
470: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
471: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
472: THEN
473: FND_MSG_PUB.Add_Exc_Msg
474: ( G_PKG_NAME
572: lr_inv_item c_inv_item%rowtype;
573: --lr_pull_seq_data c_pull_seq_data%rowtype;
574: lr_pull_seq_calc c_pull_seq_calc%rowtype;
575:
576: l_ret_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
577: l_org_code varchar2(3);
578: l_item_name varchar2(200);
579: l_calculate_kanban_flag number;
580: l_loc_name varchar2(200);
730: ,mkps.inventory_item_id
731: ,mkps.organization_id
732: ,mkps.subinventory_name
733: ,mkps.locator_id
734: ,decode(p_pull_seq_rec.source_type,null,mkps.source_type,FND_API.G_MISS_NUM,null,p_pull_seq_rec.source_type)
735: ,decode(p_pull_seq_rec.supplier_id,null,mkps.supplier_id,FND_API.G_MISS_NUM,null,p_pull_seq_rec.supplier_id)
736: ,decode(p_pull_seq_rec.supplier_site_id,null,mkps.supplier_site_id,FND_API.G_MISS_NUM,null,p_pull_seq_rec.supplier_site_id)
737: ,decode(p_pull_seq_rec.source_organization_id,null,mkps.source_organization_id,FND_API.G_MISS_NUM,null,p_pull_seq_rec.source_organization_id)
738: ,decode(p_pull_seq_rec.source_subinventory,null,mkps.source_subinventory,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.source_subinventory)
731: ,mkps.organization_id
732: ,mkps.subinventory_name
733: ,mkps.locator_id
734: ,decode(p_pull_seq_rec.source_type,null,mkps.source_type,FND_API.G_MISS_NUM,null,p_pull_seq_rec.source_type)
735: ,decode(p_pull_seq_rec.supplier_id,null,mkps.supplier_id,FND_API.G_MISS_NUM,null,p_pull_seq_rec.supplier_id)
736: ,decode(p_pull_seq_rec.supplier_site_id,null,mkps.supplier_site_id,FND_API.G_MISS_NUM,null,p_pull_seq_rec.supplier_site_id)
737: ,decode(p_pull_seq_rec.source_organization_id,null,mkps.source_organization_id,FND_API.G_MISS_NUM,null,p_pull_seq_rec.source_organization_id)
738: ,decode(p_pull_seq_rec.source_subinventory,null,mkps.source_subinventory,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.source_subinventory)
739: ,decode(p_pull_seq_rec.source_locator_id,null,mkps.source_locator_id,FND_API.G_MISS_NUM,null,p_pull_seq_rec.source_locator_id)
732: ,mkps.subinventory_name
733: ,mkps.locator_id
734: ,decode(p_pull_seq_rec.source_type,null,mkps.source_type,FND_API.G_MISS_NUM,null,p_pull_seq_rec.source_type)
735: ,decode(p_pull_seq_rec.supplier_id,null,mkps.supplier_id,FND_API.G_MISS_NUM,null,p_pull_seq_rec.supplier_id)
736: ,decode(p_pull_seq_rec.supplier_site_id,null,mkps.supplier_site_id,FND_API.G_MISS_NUM,null,p_pull_seq_rec.supplier_site_id)
737: ,decode(p_pull_seq_rec.source_organization_id,null,mkps.source_organization_id,FND_API.G_MISS_NUM,null,p_pull_seq_rec.source_organization_id)
738: ,decode(p_pull_seq_rec.source_subinventory,null,mkps.source_subinventory,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.source_subinventory)
739: ,decode(p_pull_seq_rec.source_locator_id,null,mkps.source_locator_id,FND_API.G_MISS_NUM,null,p_pull_seq_rec.source_locator_id)
740: ,decode(p_pull_seq_rec.wip_line_id,null,mkps.wip_line_id,FND_API.G_MISS_NUM,null,p_pull_seq_rec.wip_line_id)
733: ,mkps.locator_id
734: ,decode(p_pull_seq_rec.source_type,null,mkps.source_type,FND_API.G_MISS_NUM,null,p_pull_seq_rec.source_type)
735: ,decode(p_pull_seq_rec.supplier_id,null,mkps.supplier_id,FND_API.G_MISS_NUM,null,p_pull_seq_rec.supplier_id)
736: ,decode(p_pull_seq_rec.supplier_site_id,null,mkps.supplier_site_id,FND_API.G_MISS_NUM,null,p_pull_seq_rec.supplier_site_id)
737: ,decode(p_pull_seq_rec.source_organization_id,null,mkps.source_organization_id,FND_API.G_MISS_NUM,null,p_pull_seq_rec.source_organization_id)
738: ,decode(p_pull_seq_rec.source_subinventory,null,mkps.source_subinventory,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.source_subinventory)
739: ,decode(p_pull_seq_rec.source_locator_id,null,mkps.source_locator_id,FND_API.G_MISS_NUM,null,p_pull_seq_rec.source_locator_id)
740: ,decode(p_pull_seq_rec.wip_line_id,null,mkps.wip_line_id,FND_API.G_MISS_NUM,null,p_pull_seq_rec.wip_line_id)
741: ,decode(p_pull_seq_rec.replenishment_lead_time,null,mkps.replenishment_lead_time,FND_API.G_MISS_NUM,null,p_pull_seq_rec.replenishment_lead_time)
734: ,decode(p_pull_seq_rec.source_type,null,mkps.source_type,FND_API.G_MISS_NUM,null,p_pull_seq_rec.source_type)
735: ,decode(p_pull_seq_rec.supplier_id,null,mkps.supplier_id,FND_API.G_MISS_NUM,null,p_pull_seq_rec.supplier_id)
736: ,decode(p_pull_seq_rec.supplier_site_id,null,mkps.supplier_site_id,FND_API.G_MISS_NUM,null,p_pull_seq_rec.supplier_site_id)
737: ,decode(p_pull_seq_rec.source_organization_id,null,mkps.source_organization_id,FND_API.G_MISS_NUM,null,p_pull_seq_rec.source_organization_id)
738: ,decode(p_pull_seq_rec.source_subinventory,null,mkps.source_subinventory,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.source_subinventory)
739: ,decode(p_pull_seq_rec.source_locator_id,null,mkps.source_locator_id,FND_API.G_MISS_NUM,null,p_pull_seq_rec.source_locator_id)
740: ,decode(p_pull_seq_rec.wip_line_id,null,mkps.wip_line_id,FND_API.G_MISS_NUM,null,p_pull_seq_rec.wip_line_id)
741: ,decode(p_pull_seq_rec.replenishment_lead_time,null,mkps.replenishment_lead_time,FND_API.G_MISS_NUM,null,p_pull_seq_rec.replenishment_lead_time)
742: ,decode(p_pull_seq_rec.calculate_kanban_flag,null,mkps.calculate_kanban_flag,FND_API.G_MISS_NUM,null,p_pull_seq_rec.calculate_kanban_flag)
735: ,decode(p_pull_seq_rec.supplier_id,null,mkps.supplier_id,FND_API.G_MISS_NUM,null,p_pull_seq_rec.supplier_id)
736: ,decode(p_pull_seq_rec.supplier_site_id,null,mkps.supplier_site_id,FND_API.G_MISS_NUM,null,p_pull_seq_rec.supplier_site_id)
737: ,decode(p_pull_seq_rec.source_organization_id,null,mkps.source_organization_id,FND_API.G_MISS_NUM,null,p_pull_seq_rec.source_organization_id)
738: ,decode(p_pull_seq_rec.source_subinventory,null,mkps.source_subinventory,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.source_subinventory)
739: ,decode(p_pull_seq_rec.source_locator_id,null,mkps.source_locator_id,FND_API.G_MISS_NUM,null,p_pull_seq_rec.source_locator_id)
740: ,decode(p_pull_seq_rec.wip_line_id,null,mkps.wip_line_id,FND_API.G_MISS_NUM,null,p_pull_seq_rec.wip_line_id)
741: ,decode(p_pull_seq_rec.replenishment_lead_time,null,mkps.replenishment_lead_time,FND_API.G_MISS_NUM,null,p_pull_seq_rec.replenishment_lead_time)
742: ,decode(p_pull_seq_rec.calculate_kanban_flag,null,mkps.calculate_kanban_flag,FND_API.G_MISS_NUM,null,p_pull_seq_rec.calculate_kanban_flag)
743: ,decode(p_pull_seq_rec.kanban_size,null,mkps.kanban_size,FND_API.G_MISS_NUM,null,p_pull_seq_rec.kanban_size)
736: ,decode(p_pull_seq_rec.supplier_site_id,null,mkps.supplier_site_id,FND_API.G_MISS_NUM,null,p_pull_seq_rec.supplier_site_id)
737: ,decode(p_pull_seq_rec.source_organization_id,null,mkps.source_organization_id,FND_API.G_MISS_NUM,null,p_pull_seq_rec.source_organization_id)
738: ,decode(p_pull_seq_rec.source_subinventory,null,mkps.source_subinventory,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.source_subinventory)
739: ,decode(p_pull_seq_rec.source_locator_id,null,mkps.source_locator_id,FND_API.G_MISS_NUM,null,p_pull_seq_rec.source_locator_id)
740: ,decode(p_pull_seq_rec.wip_line_id,null,mkps.wip_line_id,FND_API.G_MISS_NUM,null,p_pull_seq_rec.wip_line_id)
741: ,decode(p_pull_seq_rec.replenishment_lead_time,null,mkps.replenishment_lead_time,FND_API.G_MISS_NUM,null,p_pull_seq_rec.replenishment_lead_time)
742: ,decode(p_pull_seq_rec.calculate_kanban_flag,null,mkps.calculate_kanban_flag,FND_API.G_MISS_NUM,null,p_pull_seq_rec.calculate_kanban_flag)
743: ,decode(p_pull_seq_rec.kanban_size,null,mkps.kanban_size,FND_API.G_MISS_NUM,null,p_pull_seq_rec.kanban_size)
744: ,decode(p_pull_seq_rec.fixed_lot_multiplier,null,mkps.fixed_lot_multiplier,FND_API.G_MISS_NUM,null,p_pull_seq_rec.fixed_lot_multiplier)
737: ,decode(p_pull_seq_rec.source_organization_id,null,mkps.source_organization_id,FND_API.G_MISS_NUM,null,p_pull_seq_rec.source_organization_id)
738: ,decode(p_pull_seq_rec.source_subinventory,null,mkps.source_subinventory,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.source_subinventory)
739: ,decode(p_pull_seq_rec.source_locator_id,null,mkps.source_locator_id,FND_API.G_MISS_NUM,null,p_pull_seq_rec.source_locator_id)
740: ,decode(p_pull_seq_rec.wip_line_id,null,mkps.wip_line_id,FND_API.G_MISS_NUM,null,p_pull_seq_rec.wip_line_id)
741: ,decode(p_pull_seq_rec.replenishment_lead_time,null,mkps.replenishment_lead_time,FND_API.G_MISS_NUM,null,p_pull_seq_rec.replenishment_lead_time)
742: ,decode(p_pull_seq_rec.calculate_kanban_flag,null,mkps.calculate_kanban_flag,FND_API.G_MISS_NUM,null,p_pull_seq_rec.calculate_kanban_flag)
743: ,decode(p_pull_seq_rec.kanban_size,null,mkps.kanban_size,FND_API.G_MISS_NUM,null,p_pull_seq_rec.kanban_size)
744: ,decode(p_pull_seq_rec.fixed_lot_multiplier,null,mkps.fixed_lot_multiplier,FND_API.G_MISS_NUM,null,p_pull_seq_rec.fixed_lot_multiplier)
745: ,decode(p_pull_seq_rec.safety_stock_days,null,mkps.safety_stock_days,FND_API.G_MISS_NUM,null,p_pull_seq_rec.safety_stock_days)
738: ,decode(p_pull_seq_rec.source_subinventory,null,mkps.source_subinventory,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.source_subinventory)
739: ,decode(p_pull_seq_rec.source_locator_id,null,mkps.source_locator_id,FND_API.G_MISS_NUM,null,p_pull_seq_rec.source_locator_id)
740: ,decode(p_pull_seq_rec.wip_line_id,null,mkps.wip_line_id,FND_API.G_MISS_NUM,null,p_pull_seq_rec.wip_line_id)
741: ,decode(p_pull_seq_rec.replenishment_lead_time,null,mkps.replenishment_lead_time,FND_API.G_MISS_NUM,null,p_pull_seq_rec.replenishment_lead_time)
742: ,decode(p_pull_seq_rec.calculate_kanban_flag,null,mkps.calculate_kanban_flag,FND_API.G_MISS_NUM,null,p_pull_seq_rec.calculate_kanban_flag)
743: ,decode(p_pull_seq_rec.kanban_size,null,mkps.kanban_size,FND_API.G_MISS_NUM,null,p_pull_seq_rec.kanban_size)
744: ,decode(p_pull_seq_rec.fixed_lot_multiplier,null,mkps.fixed_lot_multiplier,FND_API.G_MISS_NUM,null,p_pull_seq_rec.fixed_lot_multiplier)
745: ,decode(p_pull_seq_rec.safety_stock_days,null,mkps.safety_stock_days,FND_API.G_MISS_NUM,null,p_pull_seq_rec.safety_stock_days)
746: ,decode(p_pull_seq_rec.number_of_cards,null,mkps.number_of_cards,FND_API.G_MISS_NUM,null,p_pull_seq_rec.number_of_cards)
739: ,decode(p_pull_seq_rec.source_locator_id,null,mkps.source_locator_id,FND_API.G_MISS_NUM,null,p_pull_seq_rec.source_locator_id)
740: ,decode(p_pull_seq_rec.wip_line_id,null,mkps.wip_line_id,FND_API.G_MISS_NUM,null,p_pull_seq_rec.wip_line_id)
741: ,decode(p_pull_seq_rec.replenishment_lead_time,null,mkps.replenishment_lead_time,FND_API.G_MISS_NUM,null,p_pull_seq_rec.replenishment_lead_time)
742: ,decode(p_pull_seq_rec.calculate_kanban_flag,null,mkps.calculate_kanban_flag,FND_API.G_MISS_NUM,null,p_pull_seq_rec.calculate_kanban_flag)
743: ,decode(p_pull_seq_rec.kanban_size,null,mkps.kanban_size,FND_API.G_MISS_NUM,null,p_pull_seq_rec.kanban_size)
744: ,decode(p_pull_seq_rec.fixed_lot_multiplier,null,mkps.fixed_lot_multiplier,FND_API.G_MISS_NUM,null,p_pull_seq_rec.fixed_lot_multiplier)
745: ,decode(p_pull_seq_rec.safety_stock_days,null,mkps.safety_stock_days,FND_API.G_MISS_NUM,null,p_pull_seq_rec.safety_stock_days)
746: ,decode(p_pull_seq_rec.number_of_cards,null,mkps.number_of_cards,FND_API.G_MISS_NUM,null,p_pull_seq_rec.number_of_cards)
747: ,decode(p_pull_seq_rec.minimum_order_quantity,null,mkps.minimum_order_quantity,FND_API.G_MISS_NUM,null,p_pull_seq_rec.minimum_order_quantity)
740: ,decode(p_pull_seq_rec.wip_line_id,null,mkps.wip_line_id,FND_API.G_MISS_NUM,null,p_pull_seq_rec.wip_line_id)
741: ,decode(p_pull_seq_rec.replenishment_lead_time,null,mkps.replenishment_lead_time,FND_API.G_MISS_NUM,null,p_pull_seq_rec.replenishment_lead_time)
742: ,decode(p_pull_seq_rec.calculate_kanban_flag,null,mkps.calculate_kanban_flag,FND_API.G_MISS_NUM,null,p_pull_seq_rec.calculate_kanban_flag)
743: ,decode(p_pull_seq_rec.kanban_size,null,mkps.kanban_size,FND_API.G_MISS_NUM,null,p_pull_seq_rec.kanban_size)
744: ,decode(p_pull_seq_rec.fixed_lot_multiplier,null,mkps.fixed_lot_multiplier,FND_API.G_MISS_NUM,null,p_pull_seq_rec.fixed_lot_multiplier)
745: ,decode(p_pull_seq_rec.safety_stock_days,null,mkps.safety_stock_days,FND_API.G_MISS_NUM,null,p_pull_seq_rec.safety_stock_days)
746: ,decode(p_pull_seq_rec.number_of_cards,null,mkps.number_of_cards,FND_API.G_MISS_NUM,null,p_pull_seq_rec.number_of_cards)
747: ,decode(p_pull_seq_rec.minimum_order_quantity,null,mkps.minimum_order_quantity,FND_API.G_MISS_NUM,null,p_pull_seq_rec.minimum_order_quantity)
748: ,decode(p_pull_seq_rec.aggregation_type,null,mkps.aggregation_type,FND_API.G_MISS_NUM,null,p_pull_seq_rec.aggregation_type)
741: ,decode(p_pull_seq_rec.replenishment_lead_time,null,mkps.replenishment_lead_time,FND_API.G_MISS_NUM,null,p_pull_seq_rec.replenishment_lead_time)
742: ,decode(p_pull_seq_rec.calculate_kanban_flag,null,mkps.calculate_kanban_flag,FND_API.G_MISS_NUM,null,p_pull_seq_rec.calculate_kanban_flag)
743: ,decode(p_pull_seq_rec.kanban_size,null,mkps.kanban_size,FND_API.G_MISS_NUM,null,p_pull_seq_rec.kanban_size)
744: ,decode(p_pull_seq_rec.fixed_lot_multiplier,null,mkps.fixed_lot_multiplier,FND_API.G_MISS_NUM,null,p_pull_seq_rec.fixed_lot_multiplier)
745: ,decode(p_pull_seq_rec.safety_stock_days,null,mkps.safety_stock_days,FND_API.G_MISS_NUM,null,p_pull_seq_rec.safety_stock_days)
746: ,decode(p_pull_seq_rec.number_of_cards,null,mkps.number_of_cards,FND_API.G_MISS_NUM,null,p_pull_seq_rec.number_of_cards)
747: ,decode(p_pull_seq_rec.minimum_order_quantity,null,mkps.minimum_order_quantity,FND_API.G_MISS_NUM,null,p_pull_seq_rec.minimum_order_quantity)
748: ,decode(p_pull_seq_rec.aggregation_type,null,mkps.aggregation_type,FND_API.G_MISS_NUM,null,p_pull_seq_rec.aggregation_type)
749: ,decode(p_pull_seq_rec.allocation_percent,null,mkps.allocation_percent,FND_API.G_MISS_NUM,null,p_pull_seq_rec.allocation_percent)
742: ,decode(p_pull_seq_rec.calculate_kanban_flag,null,mkps.calculate_kanban_flag,FND_API.G_MISS_NUM,null,p_pull_seq_rec.calculate_kanban_flag)
743: ,decode(p_pull_seq_rec.kanban_size,null,mkps.kanban_size,FND_API.G_MISS_NUM,null,p_pull_seq_rec.kanban_size)
744: ,decode(p_pull_seq_rec.fixed_lot_multiplier,null,mkps.fixed_lot_multiplier,FND_API.G_MISS_NUM,null,p_pull_seq_rec.fixed_lot_multiplier)
745: ,decode(p_pull_seq_rec.safety_stock_days,null,mkps.safety_stock_days,FND_API.G_MISS_NUM,null,p_pull_seq_rec.safety_stock_days)
746: ,decode(p_pull_seq_rec.number_of_cards,null,mkps.number_of_cards,FND_API.G_MISS_NUM,null,p_pull_seq_rec.number_of_cards)
747: ,decode(p_pull_seq_rec.minimum_order_quantity,null,mkps.minimum_order_quantity,FND_API.G_MISS_NUM,null,p_pull_seq_rec.minimum_order_quantity)
748: ,decode(p_pull_seq_rec.aggregation_type,null,mkps.aggregation_type,FND_API.G_MISS_NUM,null,p_pull_seq_rec.aggregation_type)
749: ,decode(p_pull_seq_rec.allocation_percent,null,mkps.allocation_percent,FND_API.G_MISS_NUM,null,p_pull_seq_rec.allocation_percent)
750: ,decode(p_pull_seq_rec.release_kanban_flag,null,mkps.release_kanban_flag,FND_API.G_MISS_NUM,null,p_pull_seq_rec.release_kanban_flag)
743: ,decode(p_pull_seq_rec.kanban_size,null,mkps.kanban_size,FND_API.G_MISS_NUM,null,p_pull_seq_rec.kanban_size)
744: ,decode(p_pull_seq_rec.fixed_lot_multiplier,null,mkps.fixed_lot_multiplier,FND_API.G_MISS_NUM,null,p_pull_seq_rec.fixed_lot_multiplier)
745: ,decode(p_pull_seq_rec.safety_stock_days,null,mkps.safety_stock_days,FND_API.G_MISS_NUM,null,p_pull_seq_rec.safety_stock_days)
746: ,decode(p_pull_seq_rec.number_of_cards,null,mkps.number_of_cards,FND_API.G_MISS_NUM,null,p_pull_seq_rec.number_of_cards)
747: ,decode(p_pull_seq_rec.minimum_order_quantity,null,mkps.minimum_order_quantity,FND_API.G_MISS_NUM,null,p_pull_seq_rec.minimum_order_quantity)
748: ,decode(p_pull_seq_rec.aggregation_type,null,mkps.aggregation_type,FND_API.G_MISS_NUM,null,p_pull_seq_rec.aggregation_type)
749: ,decode(p_pull_seq_rec.allocation_percent,null,mkps.allocation_percent,FND_API.G_MISS_NUM,null,p_pull_seq_rec.allocation_percent)
750: ,decode(p_pull_seq_rec.release_kanban_flag,null,mkps.release_kanban_flag,FND_API.G_MISS_NUM,null,p_pull_seq_rec.release_kanban_flag)
751: ,decode(p_pull_seq_rec.attribute_category,null,mkps.attribute_category,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.attribute_category)
744: ,decode(p_pull_seq_rec.fixed_lot_multiplier,null,mkps.fixed_lot_multiplier,FND_API.G_MISS_NUM,null,p_pull_seq_rec.fixed_lot_multiplier)
745: ,decode(p_pull_seq_rec.safety_stock_days,null,mkps.safety_stock_days,FND_API.G_MISS_NUM,null,p_pull_seq_rec.safety_stock_days)
746: ,decode(p_pull_seq_rec.number_of_cards,null,mkps.number_of_cards,FND_API.G_MISS_NUM,null,p_pull_seq_rec.number_of_cards)
747: ,decode(p_pull_seq_rec.minimum_order_quantity,null,mkps.minimum_order_quantity,FND_API.G_MISS_NUM,null,p_pull_seq_rec.minimum_order_quantity)
748: ,decode(p_pull_seq_rec.aggregation_type,null,mkps.aggregation_type,FND_API.G_MISS_NUM,null,p_pull_seq_rec.aggregation_type)
749: ,decode(p_pull_seq_rec.allocation_percent,null,mkps.allocation_percent,FND_API.G_MISS_NUM,null,p_pull_seq_rec.allocation_percent)
750: ,decode(p_pull_seq_rec.release_kanban_flag,null,mkps.release_kanban_flag,FND_API.G_MISS_NUM,null,p_pull_seq_rec.release_kanban_flag)
751: ,decode(p_pull_seq_rec.attribute_category,null,mkps.attribute_category,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.attribute_category)
752: ,decode(p_pull_seq_rec.attribute1,null,mkps.attribute1,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.attribute1)
745: ,decode(p_pull_seq_rec.safety_stock_days,null,mkps.safety_stock_days,FND_API.G_MISS_NUM,null,p_pull_seq_rec.safety_stock_days)
746: ,decode(p_pull_seq_rec.number_of_cards,null,mkps.number_of_cards,FND_API.G_MISS_NUM,null,p_pull_seq_rec.number_of_cards)
747: ,decode(p_pull_seq_rec.minimum_order_quantity,null,mkps.minimum_order_quantity,FND_API.G_MISS_NUM,null,p_pull_seq_rec.minimum_order_quantity)
748: ,decode(p_pull_seq_rec.aggregation_type,null,mkps.aggregation_type,FND_API.G_MISS_NUM,null,p_pull_seq_rec.aggregation_type)
749: ,decode(p_pull_seq_rec.allocation_percent,null,mkps.allocation_percent,FND_API.G_MISS_NUM,null,p_pull_seq_rec.allocation_percent)
750: ,decode(p_pull_seq_rec.release_kanban_flag,null,mkps.release_kanban_flag,FND_API.G_MISS_NUM,null,p_pull_seq_rec.release_kanban_flag)
751: ,decode(p_pull_seq_rec.attribute_category,null,mkps.attribute_category,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.attribute_category)
752: ,decode(p_pull_seq_rec.attribute1,null,mkps.attribute1,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.attribute1)
753: ,decode(p_pull_seq_rec.attribute2,null,mkps.attribute2,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.attribute2)
746: ,decode(p_pull_seq_rec.number_of_cards,null,mkps.number_of_cards,FND_API.G_MISS_NUM,null,p_pull_seq_rec.number_of_cards)
747: ,decode(p_pull_seq_rec.minimum_order_quantity,null,mkps.minimum_order_quantity,FND_API.G_MISS_NUM,null,p_pull_seq_rec.minimum_order_quantity)
748: ,decode(p_pull_seq_rec.aggregation_type,null,mkps.aggregation_type,FND_API.G_MISS_NUM,null,p_pull_seq_rec.aggregation_type)
749: ,decode(p_pull_seq_rec.allocation_percent,null,mkps.allocation_percent,FND_API.G_MISS_NUM,null,p_pull_seq_rec.allocation_percent)
750: ,decode(p_pull_seq_rec.release_kanban_flag,null,mkps.release_kanban_flag,FND_API.G_MISS_NUM,null,p_pull_seq_rec.release_kanban_flag)
751: ,decode(p_pull_seq_rec.attribute_category,null,mkps.attribute_category,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.attribute_category)
752: ,decode(p_pull_seq_rec.attribute1,null,mkps.attribute1,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.attribute1)
753: ,decode(p_pull_seq_rec.attribute2,null,mkps.attribute2,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.attribute2)
754: ,decode(p_pull_seq_rec.attribute3,null,mkps.attribute3,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.attribute3)
747: ,decode(p_pull_seq_rec.minimum_order_quantity,null,mkps.minimum_order_quantity,FND_API.G_MISS_NUM,null,p_pull_seq_rec.minimum_order_quantity)
748: ,decode(p_pull_seq_rec.aggregation_type,null,mkps.aggregation_type,FND_API.G_MISS_NUM,null,p_pull_seq_rec.aggregation_type)
749: ,decode(p_pull_seq_rec.allocation_percent,null,mkps.allocation_percent,FND_API.G_MISS_NUM,null,p_pull_seq_rec.allocation_percent)
750: ,decode(p_pull_seq_rec.release_kanban_flag,null,mkps.release_kanban_flag,FND_API.G_MISS_NUM,null,p_pull_seq_rec.release_kanban_flag)
751: ,decode(p_pull_seq_rec.attribute_category,null,mkps.attribute_category,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.attribute_category)
752: ,decode(p_pull_seq_rec.attribute1,null,mkps.attribute1,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.attribute1)
753: ,decode(p_pull_seq_rec.attribute2,null,mkps.attribute2,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.attribute2)
754: ,decode(p_pull_seq_rec.attribute3,null,mkps.attribute3,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.attribute3)
755: ,decode(p_pull_seq_rec.attribute4,null,mkps.attribute4,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.attribute4)
748: ,decode(p_pull_seq_rec.aggregation_type,null,mkps.aggregation_type,FND_API.G_MISS_NUM,null,p_pull_seq_rec.aggregation_type)
749: ,decode(p_pull_seq_rec.allocation_percent,null,mkps.allocation_percent,FND_API.G_MISS_NUM,null,p_pull_seq_rec.allocation_percent)
750: ,decode(p_pull_seq_rec.release_kanban_flag,null,mkps.release_kanban_flag,FND_API.G_MISS_NUM,null,p_pull_seq_rec.release_kanban_flag)
751: ,decode(p_pull_seq_rec.attribute_category,null,mkps.attribute_category,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.attribute_category)
752: ,decode(p_pull_seq_rec.attribute1,null,mkps.attribute1,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.attribute1)
753: ,decode(p_pull_seq_rec.attribute2,null,mkps.attribute2,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.attribute2)
754: ,decode(p_pull_seq_rec.attribute3,null,mkps.attribute3,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.attribute3)
755: ,decode(p_pull_seq_rec.attribute4,null,mkps.attribute4,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.attribute4)
756: ,decode(p_pull_seq_rec.attribute5,null,mkps.attribute5,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.attribute5)
749: ,decode(p_pull_seq_rec.allocation_percent,null,mkps.allocation_percent,FND_API.G_MISS_NUM,null,p_pull_seq_rec.allocation_percent)
750: ,decode(p_pull_seq_rec.release_kanban_flag,null,mkps.release_kanban_flag,FND_API.G_MISS_NUM,null,p_pull_seq_rec.release_kanban_flag)
751: ,decode(p_pull_seq_rec.attribute_category,null,mkps.attribute_category,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.attribute_category)
752: ,decode(p_pull_seq_rec.attribute1,null,mkps.attribute1,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.attribute1)
753: ,decode(p_pull_seq_rec.attribute2,null,mkps.attribute2,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.attribute2)
754: ,decode(p_pull_seq_rec.attribute3,null,mkps.attribute3,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.attribute3)
755: ,decode(p_pull_seq_rec.attribute4,null,mkps.attribute4,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.attribute4)
756: ,decode(p_pull_seq_rec.attribute5,null,mkps.attribute5,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.attribute5)
757: ,decode(p_pull_seq_rec.attribute6,null,mkps.attribute6,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.attribute6)
750: ,decode(p_pull_seq_rec.release_kanban_flag,null,mkps.release_kanban_flag,FND_API.G_MISS_NUM,null,p_pull_seq_rec.release_kanban_flag)
751: ,decode(p_pull_seq_rec.attribute_category,null,mkps.attribute_category,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.attribute_category)
752: ,decode(p_pull_seq_rec.attribute1,null,mkps.attribute1,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.attribute1)
753: ,decode(p_pull_seq_rec.attribute2,null,mkps.attribute2,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.attribute2)
754: ,decode(p_pull_seq_rec.attribute3,null,mkps.attribute3,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.attribute3)
755: ,decode(p_pull_seq_rec.attribute4,null,mkps.attribute4,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.attribute4)
756: ,decode(p_pull_seq_rec.attribute5,null,mkps.attribute5,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.attribute5)
757: ,decode(p_pull_seq_rec.attribute6,null,mkps.attribute6,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.attribute6)
758: ,decode(p_pull_seq_rec.attribute7,null,mkps.attribute7,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.attribute7)
751: ,decode(p_pull_seq_rec.attribute_category,null,mkps.attribute_category,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.attribute_category)
752: ,decode(p_pull_seq_rec.attribute1,null,mkps.attribute1,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.attribute1)
753: ,decode(p_pull_seq_rec.attribute2,null,mkps.attribute2,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.attribute2)
754: ,decode(p_pull_seq_rec.attribute3,null,mkps.attribute3,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.attribute3)
755: ,decode(p_pull_seq_rec.attribute4,null,mkps.attribute4,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.attribute4)
756: ,decode(p_pull_seq_rec.attribute5,null,mkps.attribute5,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.attribute5)
757: ,decode(p_pull_seq_rec.attribute6,null,mkps.attribute6,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.attribute6)
758: ,decode(p_pull_seq_rec.attribute7,null,mkps.attribute7,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.attribute7)
759: ,decode(p_pull_seq_rec.attribute8,null,mkps.attribute8,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.attribute8)
752: ,decode(p_pull_seq_rec.attribute1,null,mkps.attribute1,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.attribute1)
753: ,decode(p_pull_seq_rec.attribute2,null,mkps.attribute2,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.attribute2)
754: ,decode(p_pull_seq_rec.attribute3,null,mkps.attribute3,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.attribute3)
755: ,decode(p_pull_seq_rec.attribute4,null,mkps.attribute4,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.attribute4)
756: ,decode(p_pull_seq_rec.attribute5,null,mkps.attribute5,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.attribute5)
757: ,decode(p_pull_seq_rec.attribute6,null,mkps.attribute6,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.attribute6)
758: ,decode(p_pull_seq_rec.attribute7,null,mkps.attribute7,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.attribute7)
759: ,decode(p_pull_seq_rec.attribute8,null,mkps.attribute8,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.attribute8)
760: ,decode(p_pull_seq_rec.attribute9,null,mkps.attribute9,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.attribute9)
753: ,decode(p_pull_seq_rec.attribute2,null,mkps.attribute2,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.attribute2)
754: ,decode(p_pull_seq_rec.attribute3,null,mkps.attribute3,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.attribute3)
755: ,decode(p_pull_seq_rec.attribute4,null,mkps.attribute4,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.attribute4)
756: ,decode(p_pull_seq_rec.attribute5,null,mkps.attribute5,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.attribute5)
757: ,decode(p_pull_seq_rec.attribute6,null,mkps.attribute6,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.attribute6)
758: ,decode(p_pull_seq_rec.attribute7,null,mkps.attribute7,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.attribute7)
759: ,decode(p_pull_seq_rec.attribute8,null,mkps.attribute8,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.attribute8)
760: ,decode(p_pull_seq_rec.attribute9,null,mkps.attribute9,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.attribute9)
761: ,decode(p_pull_seq_rec.attribute10,null,mkps.attribute10,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.attribute10)
754: ,decode(p_pull_seq_rec.attribute3,null,mkps.attribute3,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.attribute3)
755: ,decode(p_pull_seq_rec.attribute4,null,mkps.attribute4,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.attribute4)
756: ,decode(p_pull_seq_rec.attribute5,null,mkps.attribute5,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.attribute5)
757: ,decode(p_pull_seq_rec.attribute6,null,mkps.attribute6,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.attribute6)
758: ,decode(p_pull_seq_rec.attribute7,null,mkps.attribute7,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.attribute7)
759: ,decode(p_pull_seq_rec.attribute8,null,mkps.attribute8,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.attribute8)
760: ,decode(p_pull_seq_rec.attribute9,null,mkps.attribute9,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.attribute9)
761: ,decode(p_pull_seq_rec.attribute10,null,mkps.attribute10,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.attribute10)
762: ,decode(p_pull_seq_rec.attribute11,null,mkps.attribute11,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.attribute11)
755: ,decode(p_pull_seq_rec.attribute4,null,mkps.attribute4,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.attribute4)
756: ,decode(p_pull_seq_rec.attribute5,null,mkps.attribute5,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.attribute5)
757: ,decode(p_pull_seq_rec.attribute6,null,mkps.attribute6,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.attribute6)
758: ,decode(p_pull_seq_rec.attribute7,null,mkps.attribute7,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.attribute7)
759: ,decode(p_pull_seq_rec.attribute8,null,mkps.attribute8,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.attribute8)
760: ,decode(p_pull_seq_rec.attribute9,null,mkps.attribute9,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.attribute9)
761: ,decode(p_pull_seq_rec.attribute10,null,mkps.attribute10,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.attribute10)
762: ,decode(p_pull_seq_rec.attribute11,null,mkps.attribute11,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.attribute11)
763: ,decode(p_pull_seq_rec.attribute12,null,mkps.attribute12,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.attribute12)
756: ,decode(p_pull_seq_rec.attribute5,null,mkps.attribute5,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.attribute5)
757: ,decode(p_pull_seq_rec.attribute6,null,mkps.attribute6,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.attribute6)
758: ,decode(p_pull_seq_rec.attribute7,null,mkps.attribute7,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.attribute7)
759: ,decode(p_pull_seq_rec.attribute8,null,mkps.attribute8,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.attribute8)
760: ,decode(p_pull_seq_rec.attribute9,null,mkps.attribute9,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.attribute9)
761: ,decode(p_pull_seq_rec.attribute10,null,mkps.attribute10,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.attribute10)
762: ,decode(p_pull_seq_rec.attribute11,null,mkps.attribute11,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.attribute11)
763: ,decode(p_pull_seq_rec.attribute12,null,mkps.attribute12,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.attribute12)
764: ,decode(p_pull_seq_rec.attribute13,null,mkps.attribute13,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.attribute13)
757: ,decode(p_pull_seq_rec.attribute6,null,mkps.attribute6,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.attribute6)
758: ,decode(p_pull_seq_rec.attribute7,null,mkps.attribute7,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.attribute7)
759: ,decode(p_pull_seq_rec.attribute8,null,mkps.attribute8,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.attribute8)
760: ,decode(p_pull_seq_rec.attribute9,null,mkps.attribute9,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.attribute9)
761: ,decode(p_pull_seq_rec.attribute10,null,mkps.attribute10,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.attribute10)
762: ,decode(p_pull_seq_rec.attribute11,null,mkps.attribute11,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.attribute11)
763: ,decode(p_pull_seq_rec.attribute12,null,mkps.attribute12,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.attribute12)
764: ,decode(p_pull_seq_rec.attribute13,null,mkps.attribute13,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.attribute13)
765: ,decode(p_pull_seq_rec.attribute14,null,mkps.attribute14,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.attribute14)
758: ,decode(p_pull_seq_rec.attribute7,null,mkps.attribute7,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.attribute7)
759: ,decode(p_pull_seq_rec.attribute8,null,mkps.attribute8,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.attribute8)
760: ,decode(p_pull_seq_rec.attribute9,null,mkps.attribute9,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.attribute9)
761: ,decode(p_pull_seq_rec.attribute10,null,mkps.attribute10,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.attribute10)
762: ,decode(p_pull_seq_rec.attribute11,null,mkps.attribute11,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.attribute11)
763: ,decode(p_pull_seq_rec.attribute12,null,mkps.attribute12,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.attribute12)
764: ,decode(p_pull_seq_rec.attribute13,null,mkps.attribute13,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.attribute13)
765: ,decode(p_pull_seq_rec.attribute14,null,mkps.attribute14,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.attribute14)
766: ,decode(p_pull_seq_rec.attribute15,null,mkps.attribute15,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.attribute15)
759: ,decode(p_pull_seq_rec.attribute8,null,mkps.attribute8,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.attribute8)
760: ,decode(p_pull_seq_rec.attribute9,null,mkps.attribute9,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.attribute9)
761: ,decode(p_pull_seq_rec.attribute10,null,mkps.attribute10,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.attribute10)
762: ,decode(p_pull_seq_rec.attribute11,null,mkps.attribute11,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.attribute11)
763: ,decode(p_pull_seq_rec.attribute12,null,mkps.attribute12,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.attribute12)
764: ,decode(p_pull_seq_rec.attribute13,null,mkps.attribute13,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.attribute13)
765: ,decode(p_pull_seq_rec.attribute14,null,mkps.attribute14,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.attribute14)
766: ,decode(p_pull_seq_rec.attribute15,null,mkps.attribute15,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.attribute15)
767: ,decode(p_pull_seq_rec.auto_request,null,mkps.auto_request,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.auto_request)
760: ,decode(p_pull_seq_rec.attribute9,null,mkps.attribute9,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.attribute9)
761: ,decode(p_pull_seq_rec.attribute10,null,mkps.attribute10,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.attribute10)
762: ,decode(p_pull_seq_rec.attribute11,null,mkps.attribute11,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.attribute11)
763: ,decode(p_pull_seq_rec.attribute12,null,mkps.attribute12,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.attribute12)
764: ,decode(p_pull_seq_rec.attribute13,null,mkps.attribute13,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.attribute13)
765: ,decode(p_pull_seq_rec.attribute14,null,mkps.attribute14,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.attribute14)
766: ,decode(p_pull_seq_rec.attribute15,null,mkps.attribute15,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.attribute15)
767: ,decode(p_pull_seq_rec.auto_request,null,mkps.auto_request,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.auto_request)
768: ,decode(p_pull_seq_rec.auto_allocate_flag,null,mkps.auto_allocate_flag,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.auto_allocate_flag)
761: ,decode(p_pull_seq_rec.attribute10,null,mkps.attribute10,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.attribute10)
762: ,decode(p_pull_seq_rec.attribute11,null,mkps.attribute11,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.attribute11)
763: ,decode(p_pull_seq_rec.attribute12,null,mkps.attribute12,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.attribute12)
764: ,decode(p_pull_seq_rec.attribute13,null,mkps.attribute13,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.attribute13)
765: ,decode(p_pull_seq_rec.attribute14,null,mkps.attribute14,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.attribute14)
766: ,decode(p_pull_seq_rec.attribute15,null,mkps.attribute15,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.attribute15)
767: ,decode(p_pull_seq_rec.auto_request,null,mkps.auto_request,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.auto_request)
768: ,decode(p_pull_seq_rec.auto_allocate_flag,null,mkps.auto_allocate_flag,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.auto_allocate_flag)
769: ,decode(p_pull_seq_rec.replenishment_type,null,mkps.replenishment_type,FND_API.G_MISS_NUM,null,p_pull_seq_rec.replenishment_type)
762: ,decode(p_pull_seq_rec.attribute11,null,mkps.attribute11,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.attribute11)
763: ,decode(p_pull_seq_rec.attribute12,null,mkps.attribute12,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.attribute12)
764: ,decode(p_pull_seq_rec.attribute13,null,mkps.attribute13,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.attribute13)
765: ,decode(p_pull_seq_rec.attribute14,null,mkps.attribute14,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.attribute14)
766: ,decode(p_pull_seq_rec.attribute15,null,mkps.attribute15,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.attribute15)
767: ,decode(p_pull_seq_rec.auto_request,null,mkps.auto_request,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.auto_request)
768: ,decode(p_pull_seq_rec.auto_allocate_flag,null,mkps.auto_allocate_flag,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.auto_allocate_flag)
769: ,decode(p_pull_seq_rec.replenishment_type,null,mkps.replenishment_type,FND_API.G_MISS_NUM,null,p_pull_seq_rec.replenishment_type)
770: ,decode(p_pull_seq_rec.consolidation,null,mkps.consolidation,FND_API.G_MISS_NUM,null,p_pull_seq_rec.consolidation)
763: ,decode(p_pull_seq_rec.attribute12,null,mkps.attribute12,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.attribute12)
764: ,decode(p_pull_seq_rec.attribute13,null,mkps.attribute13,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.attribute13)
765: ,decode(p_pull_seq_rec.attribute14,null,mkps.attribute14,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.attribute14)
766: ,decode(p_pull_seq_rec.attribute15,null,mkps.attribute15,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.attribute15)
767: ,decode(p_pull_seq_rec.auto_request,null,mkps.auto_request,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.auto_request)
768: ,decode(p_pull_seq_rec.auto_allocate_flag,null,mkps.auto_allocate_flag,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.auto_allocate_flag)
769: ,decode(p_pull_seq_rec.replenishment_type,null,mkps.replenishment_type,FND_API.G_MISS_NUM,null,p_pull_seq_rec.replenishment_type)
770: ,decode(p_pull_seq_rec.consolidation,null,mkps.consolidation,FND_API.G_MISS_NUM,null,p_pull_seq_rec.consolidation)
771: ,decode(p_pull_seq_rec.consolidation_group,null,mkps.consolidation_group,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.consolidation_group)
764: ,decode(p_pull_seq_rec.attribute13,null,mkps.attribute13,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.attribute13)
765: ,decode(p_pull_seq_rec.attribute14,null,mkps.attribute14,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.attribute14)
766: ,decode(p_pull_seq_rec.attribute15,null,mkps.attribute15,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.attribute15)
767: ,decode(p_pull_seq_rec.auto_request,null,mkps.auto_request,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.auto_request)
768: ,decode(p_pull_seq_rec.auto_allocate_flag,null,mkps.auto_allocate_flag,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.auto_allocate_flag)
769: ,decode(p_pull_seq_rec.replenishment_type,null,mkps.replenishment_type,FND_API.G_MISS_NUM,null,p_pull_seq_rec.replenishment_type)
770: ,decode(p_pull_seq_rec.consolidation,null,mkps.consolidation,FND_API.G_MISS_NUM,null,p_pull_seq_rec.consolidation)
771: ,decode(p_pull_seq_rec.consolidation_group,null,mkps.consolidation_group,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.consolidation_group)
772: ,decode(p_pull_seq_rec.future_card_size,null,mkps.future_card_size,FND_API.G_MISS_NUM,null,p_pull_seq_rec.future_card_size)
765: ,decode(p_pull_seq_rec.attribute14,null,mkps.attribute14,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.attribute14)
766: ,decode(p_pull_seq_rec.attribute15,null,mkps.attribute15,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.attribute15)
767: ,decode(p_pull_seq_rec.auto_request,null,mkps.auto_request,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.auto_request)
768: ,decode(p_pull_seq_rec.auto_allocate_flag,null,mkps.auto_allocate_flag,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.auto_allocate_flag)
769: ,decode(p_pull_seq_rec.replenishment_type,null,mkps.replenishment_type,FND_API.G_MISS_NUM,null,p_pull_seq_rec.replenishment_type)
770: ,decode(p_pull_seq_rec.consolidation,null,mkps.consolidation,FND_API.G_MISS_NUM,null,p_pull_seq_rec.consolidation)
771: ,decode(p_pull_seq_rec.consolidation_group,null,mkps.consolidation_group,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.consolidation_group)
772: ,decode(p_pull_seq_rec.future_card_size,null,mkps.future_card_size,FND_API.G_MISS_NUM,null,p_pull_seq_rec.future_card_size)
773: ,decode(p_pull_seq_rec.future_no_of_cards,null,mkps.future_no_of_cards,FND_API.G_MISS_NUM,null,p_pull_seq_rec.future_no_of_cards)
766: ,decode(p_pull_seq_rec.attribute15,null,mkps.attribute15,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.attribute15)
767: ,decode(p_pull_seq_rec.auto_request,null,mkps.auto_request,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.auto_request)
768: ,decode(p_pull_seq_rec.auto_allocate_flag,null,mkps.auto_allocate_flag,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.auto_allocate_flag)
769: ,decode(p_pull_seq_rec.replenishment_type,null,mkps.replenishment_type,FND_API.G_MISS_NUM,null,p_pull_seq_rec.replenishment_type)
770: ,decode(p_pull_seq_rec.consolidation,null,mkps.consolidation,FND_API.G_MISS_NUM,null,p_pull_seq_rec.consolidation)
771: ,decode(p_pull_seq_rec.consolidation_group,null,mkps.consolidation_group,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.consolidation_group)
772: ,decode(p_pull_seq_rec.future_card_size,null,mkps.future_card_size,FND_API.G_MISS_NUM,null,p_pull_seq_rec.future_card_size)
773: ,decode(p_pull_seq_rec.future_no_of_cards,null,mkps.future_no_of_cards,FND_API.G_MISS_NUM,null,p_pull_seq_rec.future_no_of_cards)
774: ,decode(p_pull_seq_rec.planning_effectivity,null,mkps.planning_effectivity,FND_API.G_MISS_DATE,null,p_pull_seq_rec.planning_effectivity)
767: ,decode(p_pull_seq_rec.auto_request,null,mkps.auto_request,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.auto_request)
768: ,decode(p_pull_seq_rec.auto_allocate_flag,null,mkps.auto_allocate_flag,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.auto_allocate_flag)
769: ,decode(p_pull_seq_rec.replenishment_type,null,mkps.replenishment_type,FND_API.G_MISS_NUM,null,p_pull_seq_rec.replenishment_type)
770: ,decode(p_pull_seq_rec.consolidation,null,mkps.consolidation,FND_API.G_MISS_NUM,null,p_pull_seq_rec.consolidation)
771: ,decode(p_pull_seq_rec.consolidation_group,null,mkps.consolidation_group,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.consolidation_group)
772: ,decode(p_pull_seq_rec.future_card_size,null,mkps.future_card_size,FND_API.G_MISS_NUM,null,p_pull_seq_rec.future_card_size)
773: ,decode(p_pull_seq_rec.future_no_of_cards,null,mkps.future_no_of_cards,FND_API.G_MISS_NUM,null,p_pull_seq_rec.future_no_of_cards)
774: ,decode(p_pull_seq_rec.planning_effectivity,null,mkps.planning_effectivity,FND_API.G_MISS_DATE,null,p_pull_seq_rec.planning_effectivity)
775: ,decode(p_pull_seq_rec.avg_dependent_demand,null,mkps.avg_dependent_demand,FND_API.G_MISS_NUM,null,p_pull_seq_rec.avg_dependent_demand)
768: ,decode(p_pull_seq_rec.auto_allocate_flag,null,mkps.auto_allocate_flag,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.auto_allocate_flag)
769: ,decode(p_pull_seq_rec.replenishment_type,null,mkps.replenishment_type,FND_API.G_MISS_NUM,null,p_pull_seq_rec.replenishment_type)
770: ,decode(p_pull_seq_rec.consolidation,null,mkps.consolidation,FND_API.G_MISS_NUM,null,p_pull_seq_rec.consolidation)
771: ,decode(p_pull_seq_rec.consolidation_group,null,mkps.consolidation_group,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.consolidation_group)
772: ,decode(p_pull_seq_rec.future_card_size,null,mkps.future_card_size,FND_API.G_MISS_NUM,null,p_pull_seq_rec.future_card_size)
773: ,decode(p_pull_seq_rec.future_no_of_cards,null,mkps.future_no_of_cards,FND_API.G_MISS_NUM,null,p_pull_seq_rec.future_no_of_cards)
774: ,decode(p_pull_seq_rec.planning_effectivity,null,mkps.planning_effectivity,FND_API.G_MISS_DATE,null,p_pull_seq_rec.planning_effectivity)
775: ,decode(p_pull_seq_rec.avg_dependent_demand,null,mkps.avg_dependent_demand,FND_API.G_MISS_NUM,null,p_pull_seq_rec.avg_dependent_demand)
776: ,decode(p_pull_seq_rec.avg_independent_demand,null,mkps.avg_independent_demand,FND_API.G_MISS_NUM,null,p_pull_seq_rec.avg_independent_demand)
769: ,decode(p_pull_seq_rec.replenishment_type,null,mkps.replenishment_type,FND_API.G_MISS_NUM,null,p_pull_seq_rec.replenishment_type)
770: ,decode(p_pull_seq_rec.consolidation,null,mkps.consolidation,FND_API.G_MISS_NUM,null,p_pull_seq_rec.consolidation)
771: ,decode(p_pull_seq_rec.consolidation_group,null,mkps.consolidation_group,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.consolidation_group)
772: ,decode(p_pull_seq_rec.future_card_size,null,mkps.future_card_size,FND_API.G_MISS_NUM,null,p_pull_seq_rec.future_card_size)
773: ,decode(p_pull_seq_rec.future_no_of_cards,null,mkps.future_no_of_cards,FND_API.G_MISS_NUM,null,p_pull_seq_rec.future_no_of_cards)
774: ,decode(p_pull_seq_rec.planning_effectivity,null,mkps.planning_effectivity,FND_API.G_MISS_DATE,null,p_pull_seq_rec.planning_effectivity)
775: ,decode(p_pull_seq_rec.avg_dependent_demand,null,mkps.avg_dependent_demand,FND_API.G_MISS_NUM,null,p_pull_seq_rec.avg_dependent_demand)
776: ,decode(p_pull_seq_rec.avg_independent_demand,null,mkps.avg_independent_demand,FND_API.G_MISS_NUM,null,p_pull_seq_rec.avg_independent_demand)
777: ,mkps.kanban_size
770: ,decode(p_pull_seq_rec.consolidation,null,mkps.consolidation,FND_API.G_MISS_NUM,null,p_pull_seq_rec.consolidation)
771: ,decode(p_pull_seq_rec.consolidation_group,null,mkps.consolidation_group,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.consolidation_group)
772: ,decode(p_pull_seq_rec.future_card_size,null,mkps.future_card_size,FND_API.G_MISS_NUM,null,p_pull_seq_rec.future_card_size)
773: ,decode(p_pull_seq_rec.future_no_of_cards,null,mkps.future_no_of_cards,FND_API.G_MISS_NUM,null,p_pull_seq_rec.future_no_of_cards)
774: ,decode(p_pull_seq_rec.planning_effectivity,null,mkps.planning_effectivity,FND_API.G_MISS_DATE,null,p_pull_seq_rec.planning_effectivity)
775: ,decode(p_pull_seq_rec.avg_dependent_demand,null,mkps.avg_dependent_demand,FND_API.G_MISS_NUM,null,p_pull_seq_rec.avg_dependent_demand)
776: ,decode(p_pull_seq_rec.avg_independent_demand,null,mkps.avg_independent_demand,FND_API.G_MISS_NUM,null,p_pull_seq_rec.avg_independent_demand)
777: ,mkps.kanban_size
778: ,mkps.number_of_cards
771: ,decode(p_pull_seq_rec.consolidation_group,null,mkps.consolidation_group,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.consolidation_group)
772: ,decode(p_pull_seq_rec.future_card_size,null,mkps.future_card_size,FND_API.G_MISS_NUM,null,p_pull_seq_rec.future_card_size)
773: ,decode(p_pull_seq_rec.future_no_of_cards,null,mkps.future_no_of_cards,FND_API.G_MISS_NUM,null,p_pull_seq_rec.future_no_of_cards)
774: ,decode(p_pull_seq_rec.planning_effectivity,null,mkps.planning_effectivity,FND_API.G_MISS_DATE,null,p_pull_seq_rec.planning_effectivity)
775: ,decode(p_pull_seq_rec.avg_dependent_demand,null,mkps.avg_dependent_demand,FND_API.G_MISS_NUM,null,p_pull_seq_rec.avg_dependent_demand)
776: ,decode(p_pull_seq_rec.avg_independent_demand,null,mkps.avg_independent_demand,FND_API.G_MISS_NUM,null,p_pull_seq_rec.avg_independent_demand)
777: ,mkps.kanban_size
778: ,mkps.number_of_cards
779: INTO
772: ,decode(p_pull_seq_rec.future_card_size,null,mkps.future_card_size,FND_API.G_MISS_NUM,null,p_pull_seq_rec.future_card_size)
773: ,decode(p_pull_seq_rec.future_no_of_cards,null,mkps.future_no_of_cards,FND_API.G_MISS_NUM,null,p_pull_seq_rec.future_no_of_cards)
774: ,decode(p_pull_seq_rec.planning_effectivity,null,mkps.planning_effectivity,FND_API.G_MISS_DATE,null,p_pull_seq_rec.planning_effectivity)
775: ,decode(p_pull_seq_rec.avg_dependent_demand,null,mkps.avg_dependent_demand,FND_API.G_MISS_NUM,null,p_pull_seq_rec.avg_dependent_demand)
776: ,decode(p_pull_seq_rec.avg_independent_demand,null,mkps.avg_independent_demand,FND_API.G_MISS_NUM,null,p_pull_seq_rec.avg_independent_demand)
777: ,mkps.kanban_size
778: ,mkps.number_of_cards
779: INTO
780: p_pull_seq_rec.pull_sequence_id
1211: if p_pull_seq_rec.wip_line_id is null then
1212: -- Fix bug 12651974, wip_line_id must not be null if wip_line_code is not null
1213: -- wip_line_id can be null for production pull sequence given that it is not
1214: -- mandatory for production pull sequence to have wip line. In addition,
1215: -- during pull sequence update, p_pull_seq_rec.wip_line_code is set to FND_API.G_MISS_CHAR
1216: -- when it is null
1217: if p_pull_seq_rec.wip_line_code <> FND_API.G_MISS_CHAR and p_pull_seq_rec.wip_line_code is not null then
1218: FND_MESSAGE.SET_NAME('FLM','FLM_ATTRIBUTE_INVALID');
1219: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Wip Line Code');
1213: -- wip_line_id can be null for production pull sequence given that it is not
1214: -- mandatory for production pull sequence to have wip line. In addition,
1215: -- during pull sequence update, p_pull_seq_rec.wip_line_code is set to FND_API.G_MISS_CHAR
1216: -- when it is null
1217: if p_pull_seq_rec.wip_line_code <> FND_API.G_MISS_CHAR and p_pull_seq_rec.wip_line_code is not null then
1218: FND_MESSAGE.SET_NAME('FLM','FLM_ATTRIBUTE_INVALID');
1219: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Wip Line Code');
1220: x_error_msg := x_error_msg||FND_CONST.NEWLINE||FND_MESSAGE.GET;
1221: end if;
1487: end if;
1488: end if; -- l_transaction_type in add or change
1489:
1490: if x_error_msg is NOT NULL THEN
1491: x_ret_status := FND_API.G_RET_STS_ERROR;
1492: else
1493: x_ret_status := l_ret_status;
1494: end if;
1495:
1495:
1496: mydebug('Exiting validate_pull_sequence procedure.');
1497: EXCEPTION
1498: WHEN OTHERS THEN
1499: x_ret_status := FND_API.G_RET_STS_ERROR;
1500: x_error_msg := 'Error in validate_pull_sequence procedure:' ||FND_CONST.NEWLINE||SQLERRM;
1501: end validate_pull_sequence;
1502:
1503: -----------------------
1512: r_pull_seq_rec flm_ekanban_pub.pull_sequence_rec_type;
1513: r_supplier_rec flm_ekanban_pub.kanban_supplier_rec_type;
1514: t_supplier_tbl flm_ekanban_pub.kanban_supplier_tbl_type;
1515: l_transaction_type NUMBER;
1516: l_ret_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1517: l_error_msg VARCHAR2(4000);
1518: l_counter NUMBER := 0;
1519: l_count NUMBER := 0;
1520: l_supp_tab_count NUMBER;
1624: ,p_commit_flag => 'N'
1625: ,x_ret_status => l_ret_status
1626: ,x_error_msg => l_error_msg);
1627:
1628: if l_ret_status = FND_API.G_RET_STS_SUCCESS then
1629: p_pull_sequence_tbl(i).pull_sequence_id := r_pull_seq_rec.pull_sequence_id;
1630: p_pull_sequence_tbl(i).process_status := FLM_KANBAN_MASSLOAD.COMPLETED;
1631: fnd_file.put_line(fnd_file.log,' Pull Sequence details with Interface Id : '|| p_pull_sequence_tbl(i).interface_id ||
1632: ' was processed successfully . ');
1632: ' was processed successfully . ');
1633: /* elsif l_ret_status = 'W' then
1634: p_pull_sequence_tbl(i).process_status := FLM_KANBAN_MASSLOAD.WARNING;
1635: p_pull_sequence_tbl(i).error_text := l_error_msg;*/
1636: elsif l_ret_status = FND_API.G_RET_STS_ERROR then
1637: p_pull_sequence_tbl(i).process_status := FLM_KANBAN_MASSLOAD.ERROR;
1638: p_pull_sequence_tbl(i).error_text := l_error_msg;
1639: fnd_file.put_line(fnd_file.log,' Pull Sequence details with Interface Id : '|| p_pull_sequence_tbl(i).interface_id ||
1640: ' failed due to following : '|| l_error_msg );
1644: fnd_file.put_line(fnd_file.log,' Pull Sequence details with Interface Id : '|| p_pull_sequence_tbl(i).interface_id ||
1645: ' failed due to following : '|| l_error_msg );
1646: end if;
1647:
1648: IF l_ret_status <> FND_API.G_RET_STS_SUCCESS THEN
1649: l_count := l_count+1 ;
1650: END IF;
1651:
1652: END LOOP;
1651:
1652: END LOOP;
1653:
1654: IF l_count > 0 THEN
1655: x_ret_status := FND_API.G_RET_STS_ERROR;
1656: ELSE
1657: x_ret_status := FND_API.G_RET_STS_SUCCESS;
1658: END IF;
1659:
1653:
1654: IF l_count > 0 THEN
1655: x_ret_status := FND_API.G_RET_STS_ERROR;
1656: ELSE
1657: x_ret_status := FND_API.G_RET_STS_SUCCESS;
1658: END IF;
1659:
1660: mydebug('Exiting process_ps procedure.');
1661: EXCEPTION
1659:
1660: mydebug('Exiting process_ps procedure.');
1661: EXCEPTION
1662: WHEN OTHERS THEN
1663: x_ret_status := FND_API.G_RET_STS_ERROR;
1664:
1665: END process_ps;
1666:
1667: -- Private procedure
2193: ,MKC.locator_id
2194: ,MKC.kanban_card_type
2195: ,MKC.kanban_size
2196: ,MKC.source_type
2197: ,DECODE(r_kanban_card_rec.supply_status,NULL,MKC.supply_status,FND_API.G_MISS_NUM,NULL,r_kanban_card_rec.supply_status)
2198: ,DECODE(r_kanban_card_rec.card_status,NULL,MKC.card_status,FND_API.G_MISS_NUM,NULL,r_kanban_card_rec.card_status)
2199: ,MKC.creation_date
2200: ,MKC.created_by
2201: ,DECODE(r_kanban_card_rec.supplier_id,NULL,MKC.supplier_id,FND_API.G_MISS_NUM,NULL,r_kanban_card_rec.supplier_id)
2194: ,MKC.kanban_card_type
2195: ,MKC.kanban_size
2196: ,MKC.source_type
2197: ,DECODE(r_kanban_card_rec.supply_status,NULL,MKC.supply_status,FND_API.G_MISS_NUM,NULL,r_kanban_card_rec.supply_status)
2198: ,DECODE(r_kanban_card_rec.card_status,NULL,MKC.card_status,FND_API.G_MISS_NUM,NULL,r_kanban_card_rec.card_status)
2199: ,MKC.creation_date
2200: ,MKC.created_by
2201: ,DECODE(r_kanban_card_rec.supplier_id,NULL,MKC.supplier_id,FND_API.G_MISS_NUM,NULL,r_kanban_card_rec.supplier_id)
2202: ,DECODE(r_kanban_card_rec.supplier_site_id,NULL,MKC.supplier_site_id,FND_API.G_MISS_NUM,NULL,r_kanban_card_rec.supplier_site_id)
2197: ,DECODE(r_kanban_card_rec.supply_status,NULL,MKC.supply_status,FND_API.G_MISS_NUM,NULL,r_kanban_card_rec.supply_status)
2198: ,DECODE(r_kanban_card_rec.card_status,NULL,MKC.card_status,FND_API.G_MISS_NUM,NULL,r_kanban_card_rec.card_status)
2199: ,MKC.creation_date
2200: ,MKC.created_by
2201: ,DECODE(r_kanban_card_rec.supplier_id,NULL,MKC.supplier_id,FND_API.G_MISS_NUM,NULL,r_kanban_card_rec.supplier_id)
2202: ,DECODE(r_kanban_card_rec.supplier_site_id,NULL,MKC.supplier_site_id,FND_API.G_MISS_NUM,NULL,r_kanban_card_rec.supplier_site_id)
2203: ,DECODE(r_kanban_card_rec.source_organization_id,NULL,MKC.source_organization_id,FND_API.G_MISS_NUM,NULL,r_kanban_card_rec.source_organization_id)
2204: ,DECODE(r_kanban_card_rec.source_subinventory,NULL,MKC.source_subinventory,FND_API.G_MISS_CHAR,NULL,r_kanban_card_rec.source_subinventory)
2205: ,DECODE(r_kanban_card_rec.source_locator_id,NULL,MKC.source_locator_id,FND_API.G_MISS_NUM,NULL,r_kanban_card_rec.source_locator_id)
2198: ,DECODE(r_kanban_card_rec.card_status,NULL,MKC.card_status,FND_API.G_MISS_NUM,NULL,r_kanban_card_rec.card_status)
2199: ,MKC.creation_date
2200: ,MKC.created_by
2201: ,DECODE(r_kanban_card_rec.supplier_id,NULL,MKC.supplier_id,FND_API.G_MISS_NUM,NULL,r_kanban_card_rec.supplier_id)
2202: ,DECODE(r_kanban_card_rec.supplier_site_id,NULL,MKC.supplier_site_id,FND_API.G_MISS_NUM,NULL,r_kanban_card_rec.supplier_site_id)
2203: ,DECODE(r_kanban_card_rec.source_organization_id,NULL,MKC.source_organization_id,FND_API.G_MISS_NUM,NULL,r_kanban_card_rec.source_organization_id)
2204: ,DECODE(r_kanban_card_rec.source_subinventory,NULL,MKC.source_subinventory,FND_API.G_MISS_CHAR,NULL,r_kanban_card_rec.source_subinventory)
2205: ,DECODE(r_kanban_card_rec.source_locator_id,NULL,MKC.source_locator_id,FND_API.G_MISS_NUM,NULL,r_kanban_card_rec.source_locator_id)
2206: ,MKC.current_replnsh_cycle_id
2199: ,MKC.creation_date
2200: ,MKC.created_by
2201: ,DECODE(r_kanban_card_rec.supplier_id,NULL,MKC.supplier_id,FND_API.G_MISS_NUM,NULL,r_kanban_card_rec.supplier_id)
2202: ,DECODE(r_kanban_card_rec.supplier_site_id,NULL,MKC.supplier_site_id,FND_API.G_MISS_NUM,NULL,r_kanban_card_rec.supplier_site_id)
2203: ,DECODE(r_kanban_card_rec.source_organization_id,NULL,MKC.source_organization_id,FND_API.G_MISS_NUM,NULL,r_kanban_card_rec.source_organization_id)
2204: ,DECODE(r_kanban_card_rec.source_subinventory,NULL,MKC.source_subinventory,FND_API.G_MISS_CHAR,NULL,r_kanban_card_rec.source_subinventory)
2205: ,DECODE(r_kanban_card_rec.source_locator_id,NULL,MKC.source_locator_id,FND_API.G_MISS_NUM,NULL,r_kanban_card_rec.source_locator_id)
2206: ,MKC.current_replnsh_cycle_id
2207: ,DECODE(r_kanban_card_rec.kanban_error_code,NULL,MKC.error_code,FND_API.G_MISS_NUM,NULL,r_kanban_card_rec.kanban_error_code)
2200: ,MKC.created_by
2201: ,DECODE(r_kanban_card_rec.supplier_id,NULL,MKC.supplier_id,FND_API.G_MISS_NUM,NULL,r_kanban_card_rec.supplier_id)
2202: ,DECODE(r_kanban_card_rec.supplier_site_id,NULL,MKC.supplier_site_id,FND_API.G_MISS_NUM,NULL,r_kanban_card_rec.supplier_site_id)
2203: ,DECODE(r_kanban_card_rec.source_organization_id,NULL,MKC.source_organization_id,FND_API.G_MISS_NUM,NULL,r_kanban_card_rec.source_organization_id)
2204: ,DECODE(r_kanban_card_rec.source_subinventory,NULL,MKC.source_subinventory,FND_API.G_MISS_CHAR,NULL,r_kanban_card_rec.source_subinventory)
2205: ,DECODE(r_kanban_card_rec.source_locator_id,NULL,MKC.source_locator_id,FND_API.G_MISS_NUM,NULL,r_kanban_card_rec.source_locator_id)
2206: ,MKC.current_replnsh_cycle_id
2207: ,DECODE(r_kanban_card_rec.kanban_error_code,NULL,MKC.error_code,FND_API.G_MISS_NUM,NULL,r_kanban_card_rec.kanban_error_code)
2208: ,DECODE(r_kanban_card_rec.wip_line_id,NULL,MKC.wip_line_id,FND_API.G_MISS_NUM,NULL,r_kanban_card_rec.wip_line_id)
2201: ,DECODE(r_kanban_card_rec.supplier_id,NULL,MKC.supplier_id,FND_API.G_MISS_NUM,NULL,r_kanban_card_rec.supplier_id)
2202: ,DECODE(r_kanban_card_rec.supplier_site_id,NULL,MKC.supplier_site_id,FND_API.G_MISS_NUM,NULL,r_kanban_card_rec.supplier_site_id)
2203: ,DECODE(r_kanban_card_rec.source_organization_id,NULL,MKC.source_organization_id,FND_API.G_MISS_NUM,NULL,r_kanban_card_rec.source_organization_id)
2204: ,DECODE(r_kanban_card_rec.source_subinventory,NULL,MKC.source_subinventory,FND_API.G_MISS_CHAR,NULL,r_kanban_card_rec.source_subinventory)
2205: ,DECODE(r_kanban_card_rec.source_locator_id,NULL,MKC.source_locator_id,FND_API.G_MISS_NUM,NULL,r_kanban_card_rec.source_locator_id)
2206: ,MKC.current_replnsh_cycle_id
2207: ,DECODE(r_kanban_card_rec.kanban_error_code,NULL,MKC.error_code,FND_API.G_MISS_NUM,NULL,r_kanban_card_rec.kanban_error_code)
2208: ,DECODE(r_kanban_card_rec.wip_line_id,NULL,MKC.wip_line_id,FND_API.G_MISS_NUM,NULL,r_kanban_card_rec.wip_line_id)
2209: ,MKC.replenishment_count
2203: ,DECODE(r_kanban_card_rec.source_organization_id,NULL,MKC.source_organization_id,FND_API.G_MISS_NUM,NULL,r_kanban_card_rec.source_organization_id)
2204: ,DECODE(r_kanban_card_rec.source_subinventory,NULL,MKC.source_subinventory,FND_API.G_MISS_CHAR,NULL,r_kanban_card_rec.source_subinventory)
2205: ,DECODE(r_kanban_card_rec.source_locator_id,NULL,MKC.source_locator_id,FND_API.G_MISS_NUM,NULL,r_kanban_card_rec.source_locator_id)
2206: ,MKC.current_replnsh_cycle_id
2207: ,DECODE(r_kanban_card_rec.kanban_error_code,NULL,MKC.error_code,FND_API.G_MISS_NUM,NULL,r_kanban_card_rec.kanban_error_code)
2208: ,DECODE(r_kanban_card_rec.wip_line_id,NULL,MKC.wip_line_id,FND_API.G_MISS_NUM,NULL,r_kanban_card_rec.wip_line_id)
2209: ,MKC.replenishment_count
2210: ,DECODE(r_kanban_card_rec.max_replenishments,NULL,MKC.max_replenishments,FND_API.G_MISS_NUM,NULL,r_kanban_card_rec.max_replenishments)
2211: ,DECODE(r_kanban_card_rec.disable_date,NULL,MKC.disable_date,FND_API.G_MISS_DATE,NULL,r_kanban_card_rec.disable_date)
2204: ,DECODE(r_kanban_card_rec.source_subinventory,NULL,MKC.source_subinventory,FND_API.G_MISS_CHAR,NULL,r_kanban_card_rec.source_subinventory)
2205: ,DECODE(r_kanban_card_rec.source_locator_id,NULL,MKC.source_locator_id,FND_API.G_MISS_NUM,NULL,r_kanban_card_rec.source_locator_id)
2206: ,MKC.current_replnsh_cycle_id
2207: ,DECODE(r_kanban_card_rec.kanban_error_code,NULL,MKC.error_code,FND_API.G_MISS_NUM,NULL,r_kanban_card_rec.kanban_error_code)
2208: ,DECODE(r_kanban_card_rec.wip_line_id,NULL,MKC.wip_line_id,FND_API.G_MISS_NUM,NULL,r_kanban_card_rec.wip_line_id)
2209: ,MKC.replenishment_count
2210: ,DECODE(r_kanban_card_rec.max_replenishments,NULL,MKC.max_replenishments,FND_API.G_MISS_NUM,NULL,r_kanban_card_rec.max_replenishments)
2211: ,DECODE(r_kanban_card_rec.disable_date,NULL,MKC.disable_date,FND_API.G_MISS_DATE,NULL,r_kanban_card_rec.disable_date)
2212: ,DECODE(r_kanban_card_rec.replacement_flag,NULL,MKC.replacement_flag,FND_API.G_MISS_NUM,NULL,r_kanban_card_rec.replacement_flag)
2206: ,MKC.current_replnsh_cycle_id
2207: ,DECODE(r_kanban_card_rec.kanban_error_code,NULL,MKC.error_code,FND_API.G_MISS_NUM,NULL,r_kanban_card_rec.kanban_error_code)
2208: ,DECODE(r_kanban_card_rec.wip_line_id,NULL,MKC.wip_line_id,FND_API.G_MISS_NUM,NULL,r_kanban_card_rec.wip_line_id)
2209: ,MKC.replenishment_count
2210: ,DECODE(r_kanban_card_rec.max_replenishments,NULL,MKC.max_replenishments,FND_API.G_MISS_NUM,NULL,r_kanban_card_rec.max_replenishments)
2211: ,DECODE(r_kanban_card_rec.disable_date,NULL,MKC.disable_date,FND_API.G_MISS_DATE,NULL,r_kanban_card_rec.disable_date)
2212: ,DECODE(r_kanban_card_rec.replacement_flag,NULL,MKC.replacement_flag,FND_API.G_MISS_NUM,NULL,r_kanban_card_rec.replacement_flag)
2213: ,DECODE(r_kanban_card_rec.attribute_category,NULL,MKC.attribute_category,FND_API.G_MISS_CHAR,NULL,r_kanban_card_rec.attribute_category)
2214: ,DECODE(r_kanban_card_rec.attribute1,NULL,MKC.attribute1,FND_API.G_MISS_CHAR,NULL,r_kanban_card_rec.attribute1)
2207: ,DECODE(r_kanban_card_rec.kanban_error_code,NULL,MKC.error_code,FND_API.G_MISS_NUM,NULL,r_kanban_card_rec.kanban_error_code)
2208: ,DECODE(r_kanban_card_rec.wip_line_id,NULL,MKC.wip_line_id,FND_API.G_MISS_NUM,NULL,r_kanban_card_rec.wip_line_id)
2209: ,MKC.replenishment_count
2210: ,DECODE(r_kanban_card_rec.max_replenishments,NULL,MKC.max_replenishments,FND_API.G_MISS_NUM,NULL,r_kanban_card_rec.max_replenishments)
2211: ,DECODE(r_kanban_card_rec.disable_date,NULL,MKC.disable_date,FND_API.G_MISS_DATE,NULL,r_kanban_card_rec.disable_date)
2212: ,DECODE(r_kanban_card_rec.replacement_flag,NULL,MKC.replacement_flag,FND_API.G_MISS_NUM,NULL,r_kanban_card_rec.replacement_flag)
2213: ,DECODE(r_kanban_card_rec.attribute_category,NULL,MKC.attribute_category,FND_API.G_MISS_CHAR,NULL,r_kanban_card_rec.attribute_category)
2214: ,DECODE(r_kanban_card_rec.attribute1,NULL,MKC.attribute1,FND_API.G_MISS_CHAR,NULL,r_kanban_card_rec.attribute1)
2215: ,DECODE(r_kanban_card_rec.attribute2,NULL,MKC.attribute2,FND_API.G_MISS_CHAR,NULL,r_kanban_card_rec.attribute2)
2208: ,DECODE(r_kanban_card_rec.wip_line_id,NULL,MKC.wip_line_id,FND_API.G_MISS_NUM,NULL,r_kanban_card_rec.wip_line_id)
2209: ,MKC.replenishment_count
2210: ,DECODE(r_kanban_card_rec.max_replenishments,NULL,MKC.max_replenishments,FND_API.G_MISS_NUM,NULL,r_kanban_card_rec.max_replenishments)
2211: ,DECODE(r_kanban_card_rec.disable_date,NULL,MKC.disable_date,FND_API.G_MISS_DATE,NULL,r_kanban_card_rec.disable_date)
2212: ,DECODE(r_kanban_card_rec.replacement_flag,NULL,MKC.replacement_flag,FND_API.G_MISS_NUM,NULL,r_kanban_card_rec.replacement_flag)
2213: ,DECODE(r_kanban_card_rec.attribute_category,NULL,MKC.attribute_category,FND_API.G_MISS_CHAR,NULL,r_kanban_card_rec.attribute_category)
2214: ,DECODE(r_kanban_card_rec.attribute1,NULL,MKC.attribute1,FND_API.G_MISS_CHAR,NULL,r_kanban_card_rec.attribute1)
2215: ,DECODE(r_kanban_card_rec.attribute2,NULL,MKC.attribute2,FND_API.G_MISS_CHAR,NULL,r_kanban_card_rec.attribute2)
2216: ,DECODE(r_kanban_card_rec.attribute3,NULL,MKC.attribute3,FND_API.G_MISS_CHAR,NULL,r_kanban_card_rec.attribute3)
2209: ,MKC.replenishment_count
2210: ,DECODE(r_kanban_card_rec.max_replenishments,NULL,MKC.max_replenishments,FND_API.G_MISS_NUM,NULL,r_kanban_card_rec.max_replenishments)
2211: ,DECODE(r_kanban_card_rec.disable_date,NULL,MKC.disable_date,FND_API.G_MISS_DATE,NULL,r_kanban_card_rec.disable_date)
2212: ,DECODE(r_kanban_card_rec.replacement_flag,NULL,MKC.replacement_flag,FND_API.G_MISS_NUM,NULL,r_kanban_card_rec.replacement_flag)
2213: ,DECODE(r_kanban_card_rec.attribute_category,NULL,MKC.attribute_category,FND_API.G_MISS_CHAR,NULL,r_kanban_card_rec.attribute_category)
2214: ,DECODE(r_kanban_card_rec.attribute1,NULL,MKC.attribute1,FND_API.G_MISS_CHAR,NULL,r_kanban_card_rec.attribute1)
2215: ,DECODE(r_kanban_card_rec.attribute2,NULL,MKC.attribute2,FND_API.G_MISS_CHAR,NULL,r_kanban_card_rec.attribute2)
2216: ,DECODE(r_kanban_card_rec.attribute3,NULL,MKC.attribute3,FND_API.G_MISS_CHAR,NULL,r_kanban_card_rec.attribute3)
2217: ,DECODE(r_kanban_card_rec.attribute4,NULL,MKC.attribute4,FND_API.G_MISS_CHAR,NULL,r_kanban_card_rec.attribute4)
2210: ,DECODE(r_kanban_card_rec.max_replenishments,NULL,MKC.max_replenishments,FND_API.G_MISS_NUM,NULL,r_kanban_card_rec.max_replenishments)
2211: ,DECODE(r_kanban_card_rec.disable_date,NULL,MKC.disable_date,FND_API.G_MISS_DATE,NULL,r_kanban_card_rec.disable_date)
2212: ,DECODE(r_kanban_card_rec.replacement_flag,NULL,MKC.replacement_flag,FND_API.G_MISS_NUM,NULL,r_kanban_card_rec.replacement_flag)
2213: ,DECODE(r_kanban_card_rec.attribute_category,NULL,MKC.attribute_category,FND_API.G_MISS_CHAR,NULL,r_kanban_card_rec.attribute_category)
2214: ,DECODE(r_kanban_card_rec.attribute1,NULL,MKC.attribute1,FND_API.G_MISS_CHAR,NULL,r_kanban_card_rec.attribute1)
2215: ,DECODE(r_kanban_card_rec.attribute2,NULL,MKC.attribute2,FND_API.G_MISS_CHAR,NULL,r_kanban_card_rec.attribute2)
2216: ,DECODE(r_kanban_card_rec.attribute3,NULL,MKC.attribute3,FND_API.G_MISS_CHAR,NULL,r_kanban_card_rec.attribute3)
2217: ,DECODE(r_kanban_card_rec.attribute4,NULL,MKC.attribute4,FND_API.G_MISS_CHAR,NULL,r_kanban_card_rec.attribute4)
2218: ,DECODE(r_kanban_card_rec.attribute5,NULL,MKC.attribute5,FND_API.G_MISS_CHAR,NULL,r_kanban_card_rec.attribute5)
2211: ,DECODE(r_kanban_card_rec.disable_date,NULL,MKC.disable_date,FND_API.G_MISS_DATE,NULL,r_kanban_card_rec.disable_date)
2212: ,DECODE(r_kanban_card_rec.replacement_flag,NULL,MKC.replacement_flag,FND_API.G_MISS_NUM,NULL,r_kanban_card_rec.replacement_flag)
2213: ,DECODE(r_kanban_card_rec.attribute_category,NULL,MKC.attribute_category,FND_API.G_MISS_CHAR,NULL,r_kanban_card_rec.attribute_category)
2214: ,DECODE(r_kanban_card_rec.attribute1,NULL,MKC.attribute1,FND_API.G_MISS_CHAR,NULL,r_kanban_card_rec.attribute1)
2215: ,DECODE(r_kanban_card_rec.attribute2,NULL,MKC.attribute2,FND_API.G_MISS_CHAR,NULL,r_kanban_card_rec.attribute2)
2216: ,DECODE(r_kanban_card_rec.attribute3,NULL,MKC.attribute3,FND_API.G_MISS_CHAR,NULL,r_kanban_card_rec.attribute3)
2217: ,DECODE(r_kanban_card_rec.attribute4,NULL,MKC.attribute4,FND_API.G_MISS_CHAR,NULL,r_kanban_card_rec.attribute4)
2218: ,DECODE(r_kanban_card_rec.attribute5,NULL,MKC.attribute5,FND_API.G_MISS_CHAR,NULL,r_kanban_card_rec.attribute5)
2219: ,DECODE(r_kanban_card_rec.attribute6,NULL,MKC.attribute6,FND_API.G_MISS_CHAR,NULL,r_kanban_card_rec.attribute6)
2212: ,DECODE(r_kanban_card_rec.replacement_flag,NULL,MKC.replacement_flag,FND_API.G_MISS_NUM,NULL,r_kanban_card_rec.replacement_flag)
2213: ,DECODE(r_kanban_card_rec.attribute_category,NULL,MKC.attribute_category,FND_API.G_MISS_CHAR,NULL,r_kanban_card_rec.attribute_category)
2214: ,DECODE(r_kanban_card_rec.attribute1,NULL,MKC.attribute1,FND_API.G_MISS_CHAR,NULL,r_kanban_card_rec.attribute1)
2215: ,DECODE(r_kanban_card_rec.attribute2,NULL,MKC.attribute2,FND_API.G_MISS_CHAR,NULL,r_kanban_card_rec.attribute2)
2216: ,DECODE(r_kanban_card_rec.attribute3,NULL,MKC.attribute3,FND_API.G_MISS_CHAR,NULL,r_kanban_card_rec.attribute3)
2217: ,DECODE(r_kanban_card_rec.attribute4,NULL,MKC.attribute4,FND_API.G_MISS_CHAR,NULL,r_kanban_card_rec.attribute4)
2218: ,DECODE(r_kanban_card_rec.attribute5,NULL,MKC.attribute5,FND_API.G_MISS_CHAR,NULL,r_kanban_card_rec.attribute5)
2219: ,DECODE(r_kanban_card_rec.attribute6,NULL,MKC.attribute6,FND_API.G_MISS_CHAR,NULL,r_kanban_card_rec.attribute6)
2220: ,DECODE(r_kanban_card_rec.attribute7,NULL,MKC.attribute7,FND_API.G_MISS_CHAR,NULL,r_kanban_card_rec.attribute7)
2213: ,DECODE(r_kanban_card_rec.attribute_category,NULL,MKC.attribute_category,FND_API.G_MISS_CHAR,NULL,r_kanban_card_rec.attribute_category)
2214: ,DECODE(r_kanban_card_rec.attribute1,NULL,MKC.attribute1,FND_API.G_MISS_CHAR,NULL,r_kanban_card_rec.attribute1)
2215: ,DECODE(r_kanban_card_rec.attribute2,NULL,MKC.attribute2,FND_API.G_MISS_CHAR,NULL,r_kanban_card_rec.attribute2)
2216: ,DECODE(r_kanban_card_rec.attribute3,NULL,MKC.attribute3,FND_API.G_MISS_CHAR,NULL,r_kanban_card_rec.attribute3)
2217: ,DECODE(r_kanban_card_rec.attribute4,NULL,MKC.attribute4,FND_API.G_MISS_CHAR,NULL,r_kanban_card_rec.attribute4)
2218: ,DECODE(r_kanban_card_rec.attribute5,NULL,MKC.attribute5,FND_API.G_MISS_CHAR,NULL,r_kanban_card_rec.attribute5)
2219: ,DECODE(r_kanban_card_rec.attribute6,NULL,MKC.attribute6,FND_API.G_MISS_CHAR,NULL,r_kanban_card_rec.attribute6)
2220: ,DECODE(r_kanban_card_rec.attribute7,NULL,MKC.attribute7,FND_API.G_MISS_CHAR,NULL,r_kanban_card_rec.attribute7)
2221: ,DECODE(r_kanban_card_rec.attribute8,NULL,MKC.attribute8,FND_API.G_MISS_CHAR,NULL,r_kanban_card_rec.attribute8)
2214: ,DECODE(r_kanban_card_rec.attribute1,NULL,MKC.attribute1,FND_API.G_MISS_CHAR,NULL,r_kanban_card_rec.attribute1)
2215: ,DECODE(r_kanban_card_rec.attribute2,NULL,MKC.attribute2,FND_API.G_MISS_CHAR,NULL,r_kanban_card_rec.attribute2)
2216: ,DECODE(r_kanban_card_rec.attribute3,NULL,MKC.attribute3,FND_API.G_MISS_CHAR,NULL,r_kanban_card_rec.attribute3)
2217: ,DECODE(r_kanban_card_rec.attribute4,NULL,MKC.attribute4,FND_API.G_MISS_CHAR,NULL,r_kanban_card_rec.attribute4)
2218: ,DECODE(r_kanban_card_rec.attribute5,NULL,MKC.attribute5,FND_API.G_MISS_CHAR,NULL,r_kanban_card_rec.attribute5)
2219: ,DECODE(r_kanban_card_rec.attribute6,NULL,MKC.attribute6,FND_API.G_MISS_CHAR,NULL,r_kanban_card_rec.attribute6)
2220: ,DECODE(r_kanban_card_rec.attribute7,NULL,MKC.attribute7,FND_API.G_MISS_CHAR,NULL,r_kanban_card_rec.attribute7)
2221: ,DECODE(r_kanban_card_rec.attribute8,NULL,MKC.attribute8,FND_API.G_MISS_CHAR,NULL,r_kanban_card_rec.attribute8)
2222: ,DECODE(r_kanban_card_rec.attribute9,NULL,MKC.attribute9,FND_API.G_MISS_CHAR,NULL,r_kanban_card_rec.attribute9)
2215: ,DECODE(r_kanban_card_rec.attribute2,NULL,MKC.attribute2,FND_API.G_MISS_CHAR,NULL,r_kanban_card_rec.attribute2)
2216: ,DECODE(r_kanban_card_rec.attribute3,NULL,MKC.attribute3,FND_API.G_MISS_CHAR,NULL,r_kanban_card_rec.attribute3)
2217: ,DECODE(r_kanban_card_rec.attribute4,NULL,MKC.attribute4,FND_API.G_MISS_CHAR,NULL,r_kanban_card_rec.attribute4)
2218: ,DECODE(r_kanban_card_rec.attribute5,NULL,MKC.attribute5,FND_API.G_MISS_CHAR,NULL,r_kanban_card_rec.attribute5)
2219: ,DECODE(r_kanban_card_rec.attribute6,NULL,MKC.attribute6,FND_API.G_MISS_CHAR,NULL,r_kanban_card_rec.attribute6)
2220: ,DECODE(r_kanban_card_rec.attribute7,NULL,MKC.attribute7,FND_API.G_MISS_CHAR,NULL,r_kanban_card_rec.attribute7)
2221: ,DECODE(r_kanban_card_rec.attribute8,NULL,MKC.attribute8,FND_API.G_MISS_CHAR,NULL,r_kanban_card_rec.attribute8)
2222: ,DECODE(r_kanban_card_rec.attribute9,NULL,MKC.attribute9,FND_API.G_MISS_CHAR,NULL,r_kanban_card_rec.attribute9)
2223: ,DECODE(r_kanban_card_rec.attribute10,NULL,MKC.attribute10,FND_API.G_MISS_CHAR,NULL,r_kanban_card_rec.attribute10)
2216: ,DECODE(r_kanban_card_rec.attribute3,NULL,MKC.attribute3,FND_API.G_MISS_CHAR,NULL,r_kanban_card_rec.attribute3)
2217: ,DECODE(r_kanban_card_rec.attribute4,NULL,MKC.attribute4,FND_API.G_MISS_CHAR,NULL,r_kanban_card_rec.attribute4)
2218: ,DECODE(r_kanban_card_rec.attribute5,NULL,MKC.attribute5,FND_API.G_MISS_CHAR,NULL,r_kanban_card_rec.attribute5)
2219: ,DECODE(r_kanban_card_rec.attribute6,NULL,MKC.attribute6,FND_API.G_MISS_CHAR,NULL,r_kanban_card_rec.attribute6)
2220: ,DECODE(r_kanban_card_rec.attribute7,NULL,MKC.attribute7,FND_API.G_MISS_CHAR,NULL,r_kanban_card_rec.attribute7)
2221: ,DECODE(r_kanban_card_rec.attribute8,NULL,MKC.attribute8,FND_API.G_MISS_CHAR,NULL,r_kanban_card_rec.attribute8)
2222: ,DECODE(r_kanban_card_rec.attribute9,NULL,MKC.attribute9,FND_API.G_MISS_CHAR,NULL,r_kanban_card_rec.attribute9)
2223: ,DECODE(r_kanban_card_rec.attribute10,NULL,MKC.attribute10,FND_API.G_MISS_CHAR,NULL,r_kanban_card_rec.attribute10)
2224: ,DECODE(r_kanban_card_rec.attribute11,NULL,MKC.attribute11,FND_API.G_MISS_CHAR,NULL,r_kanban_card_rec.attribute11)
2217: ,DECODE(r_kanban_card_rec.attribute4,NULL,MKC.attribute4,FND_API.G_MISS_CHAR,NULL,r_kanban_card_rec.attribute4)
2218: ,DECODE(r_kanban_card_rec.attribute5,NULL,MKC.attribute5,FND_API.G_MISS_CHAR,NULL,r_kanban_card_rec.attribute5)
2219: ,DECODE(r_kanban_card_rec.attribute6,NULL,MKC.attribute6,FND_API.G_MISS_CHAR,NULL,r_kanban_card_rec.attribute6)
2220: ,DECODE(r_kanban_card_rec.attribute7,NULL,MKC.attribute7,FND_API.G_MISS_CHAR,NULL,r_kanban_card_rec.attribute7)
2221: ,DECODE(r_kanban_card_rec.attribute8,NULL,MKC.attribute8,FND_API.G_MISS_CHAR,NULL,r_kanban_card_rec.attribute8)
2222: ,DECODE(r_kanban_card_rec.attribute9,NULL,MKC.attribute9,FND_API.G_MISS_CHAR,NULL,r_kanban_card_rec.attribute9)
2223: ,DECODE(r_kanban_card_rec.attribute10,NULL,MKC.attribute10,FND_API.G_MISS_CHAR,NULL,r_kanban_card_rec.attribute10)
2224: ,DECODE(r_kanban_card_rec.attribute11,NULL,MKC.attribute11,FND_API.G_MISS_CHAR,NULL,r_kanban_card_rec.attribute11)
2225: ,DECODE(r_kanban_card_rec.attribute12,NULL,MKC.attribute12,FND_API.G_MISS_CHAR,NULL,r_kanban_card_rec.attribute12)
2218: ,DECODE(r_kanban_card_rec.attribute5,NULL,MKC.attribute5,FND_API.G_MISS_CHAR,NULL,r_kanban_card_rec.attribute5)
2219: ,DECODE(r_kanban_card_rec.attribute6,NULL,MKC.attribute6,FND_API.G_MISS_CHAR,NULL,r_kanban_card_rec.attribute6)
2220: ,DECODE(r_kanban_card_rec.attribute7,NULL,MKC.attribute7,FND_API.G_MISS_CHAR,NULL,r_kanban_card_rec.attribute7)
2221: ,DECODE(r_kanban_card_rec.attribute8,NULL,MKC.attribute8,FND_API.G_MISS_CHAR,NULL,r_kanban_card_rec.attribute8)
2222: ,DECODE(r_kanban_card_rec.attribute9,NULL,MKC.attribute9,FND_API.G_MISS_CHAR,NULL,r_kanban_card_rec.attribute9)
2223: ,DECODE(r_kanban_card_rec.attribute10,NULL,MKC.attribute10,FND_API.G_MISS_CHAR,NULL,r_kanban_card_rec.attribute10)
2224: ,DECODE(r_kanban_card_rec.attribute11,NULL,MKC.attribute11,FND_API.G_MISS_CHAR,NULL,r_kanban_card_rec.attribute11)
2225: ,DECODE(r_kanban_card_rec.attribute12,NULL,MKC.attribute12,FND_API.G_MISS_CHAR,NULL,r_kanban_card_rec.attribute12)
2226: ,DECODE(r_kanban_card_rec.attribute13,NULL,MKC.attribute13,FND_API.G_MISS_CHAR,NULL,r_kanban_card_rec.attribute13)
2219: ,DECODE(r_kanban_card_rec.attribute6,NULL,MKC.attribute6,FND_API.G_MISS_CHAR,NULL,r_kanban_card_rec.attribute6)
2220: ,DECODE(r_kanban_card_rec.attribute7,NULL,MKC.attribute7,FND_API.G_MISS_CHAR,NULL,r_kanban_card_rec.attribute7)
2221: ,DECODE(r_kanban_card_rec.attribute8,NULL,MKC.attribute8,FND_API.G_MISS_CHAR,NULL,r_kanban_card_rec.attribute8)
2222: ,DECODE(r_kanban_card_rec.attribute9,NULL,MKC.attribute9,FND_API.G_MISS_CHAR,NULL,r_kanban_card_rec.attribute9)
2223: ,DECODE(r_kanban_card_rec.attribute10,NULL,MKC.attribute10,FND_API.G_MISS_CHAR,NULL,r_kanban_card_rec.attribute10)
2224: ,DECODE(r_kanban_card_rec.attribute11,NULL,MKC.attribute11,FND_API.G_MISS_CHAR,NULL,r_kanban_card_rec.attribute11)
2225: ,DECODE(r_kanban_card_rec.attribute12,NULL,MKC.attribute12,FND_API.G_MISS_CHAR,NULL,r_kanban_card_rec.attribute12)
2226: ,DECODE(r_kanban_card_rec.attribute13,NULL,MKC.attribute13,FND_API.G_MISS_CHAR,NULL,r_kanban_card_rec.attribute13)
2227: ,DECODE(r_kanban_card_rec.attribute14,NULL,MKC.attribute14,FND_API.G_MISS_CHAR,NULL,r_kanban_card_rec.attribute14)
2220: ,DECODE(r_kanban_card_rec.attribute7,NULL,MKC.attribute7,FND_API.G_MISS_CHAR,NULL,r_kanban_card_rec.attribute7)
2221: ,DECODE(r_kanban_card_rec.attribute8,NULL,MKC.attribute8,FND_API.G_MISS_CHAR,NULL,r_kanban_card_rec.attribute8)
2222: ,DECODE(r_kanban_card_rec.attribute9,NULL,MKC.attribute9,FND_API.G_MISS_CHAR,NULL,r_kanban_card_rec.attribute9)
2223: ,DECODE(r_kanban_card_rec.attribute10,NULL,MKC.attribute10,FND_API.G_MISS_CHAR,NULL,r_kanban_card_rec.attribute10)
2224: ,DECODE(r_kanban_card_rec.attribute11,NULL,MKC.attribute11,FND_API.G_MISS_CHAR,NULL,r_kanban_card_rec.attribute11)
2225: ,DECODE(r_kanban_card_rec.attribute12,NULL,MKC.attribute12,FND_API.G_MISS_CHAR,NULL,r_kanban_card_rec.attribute12)
2226: ,DECODE(r_kanban_card_rec.attribute13,NULL,MKC.attribute13,FND_API.G_MISS_CHAR,NULL,r_kanban_card_rec.attribute13)
2227: ,DECODE(r_kanban_card_rec.attribute14,NULL,MKC.attribute14,FND_API.G_MISS_CHAR,NULL,r_kanban_card_rec.attribute14)
2228: ,DECODE(r_kanban_card_rec.attribute15,NULL,MKC.attribute15,FND_API.G_MISS_CHAR,NULL,r_kanban_card_rec.attribute15)
2221: ,DECODE(r_kanban_card_rec.attribute8,NULL,MKC.attribute8,FND_API.G_MISS_CHAR,NULL,r_kanban_card_rec.attribute8)
2222: ,DECODE(r_kanban_card_rec.attribute9,NULL,MKC.attribute9,FND_API.G_MISS_CHAR,NULL,r_kanban_card_rec.attribute9)
2223: ,DECODE(r_kanban_card_rec.attribute10,NULL,MKC.attribute10,FND_API.G_MISS_CHAR,NULL,r_kanban_card_rec.attribute10)
2224: ,DECODE(r_kanban_card_rec.attribute11,NULL,MKC.attribute11,FND_API.G_MISS_CHAR,NULL,r_kanban_card_rec.attribute11)
2225: ,DECODE(r_kanban_card_rec.attribute12,NULL,MKC.attribute12,FND_API.G_MISS_CHAR,NULL,r_kanban_card_rec.attribute12)
2226: ,DECODE(r_kanban_card_rec.attribute13,NULL,MKC.attribute13,FND_API.G_MISS_CHAR,NULL,r_kanban_card_rec.attribute13)
2227: ,DECODE(r_kanban_card_rec.attribute14,NULL,MKC.attribute14,FND_API.G_MISS_CHAR,NULL,r_kanban_card_rec.attribute14)
2228: ,DECODE(r_kanban_card_rec.attribute15,NULL,MKC.attribute15,FND_API.G_MISS_CHAR,NULL,r_kanban_card_rec.attribute15)
2229: ,MKC.last_print_date
2222: ,DECODE(r_kanban_card_rec.attribute9,NULL,MKC.attribute9,FND_API.G_MISS_CHAR,NULL,r_kanban_card_rec.attribute9)
2223: ,DECODE(r_kanban_card_rec.attribute10,NULL,MKC.attribute10,FND_API.G_MISS_CHAR,NULL,r_kanban_card_rec.attribute10)
2224: ,DECODE(r_kanban_card_rec.attribute11,NULL,MKC.attribute11,FND_API.G_MISS_CHAR,NULL,r_kanban_card_rec.attribute11)
2225: ,DECODE(r_kanban_card_rec.attribute12,NULL,MKC.attribute12,FND_API.G_MISS_CHAR,NULL,r_kanban_card_rec.attribute12)
2226: ,DECODE(r_kanban_card_rec.attribute13,NULL,MKC.attribute13,FND_API.G_MISS_CHAR,NULL,r_kanban_card_rec.attribute13)
2227: ,DECODE(r_kanban_card_rec.attribute14,NULL,MKC.attribute14,FND_API.G_MISS_CHAR,NULL,r_kanban_card_rec.attribute14)
2228: ,DECODE(r_kanban_card_rec.attribute15,NULL,MKC.attribute15,FND_API.G_MISS_CHAR,NULL,r_kanban_card_rec.attribute15)
2229: ,MKC.last_print_date
2230: INTO r_kanban_card_rec.kanban_card_id
2223: ,DECODE(r_kanban_card_rec.attribute10,NULL,MKC.attribute10,FND_API.G_MISS_CHAR,NULL,r_kanban_card_rec.attribute10)
2224: ,DECODE(r_kanban_card_rec.attribute11,NULL,MKC.attribute11,FND_API.G_MISS_CHAR,NULL,r_kanban_card_rec.attribute11)
2225: ,DECODE(r_kanban_card_rec.attribute12,NULL,MKC.attribute12,FND_API.G_MISS_CHAR,NULL,r_kanban_card_rec.attribute12)
2226: ,DECODE(r_kanban_card_rec.attribute13,NULL,MKC.attribute13,FND_API.G_MISS_CHAR,NULL,r_kanban_card_rec.attribute13)
2227: ,DECODE(r_kanban_card_rec.attribute14,NULL,MKC.attribute14,FND_API.G_MISS_CHAR,NULL,r_kanban_card_rec.attribute14)
2228: ,DECODE(r_kanban_card_rec.attribute15,NULL,MKC.attribute15,FND_API.G_MISS_CHAR,NULL,r_kanban_card_rec.attribute15)
2229: ,MKC.last_print_date
2230: INTO r_kanban_card_rec.kanban_card_id
2231: ,r_kanban_card_rec.kanban_card_number
2224: ,DECODE(r_kanban_card_rec.attribute11,NULL,MKC.attribute11,FND_API.G_MISS_CHAR,NULL,r_kanban_card_rec.attribute11)
2225: ,DECODE(r_kanban_card_rec.attribute12,NULL,MKC.attribute12,FND_API.G_MISS_CHAR,NULL,r_kanban_card_rec.attribute12)
2226: ,DECODE(r_kanban_card_rec.attribute13,NULL,MKC.attribute13,FND_API.G_MISS_CHAR,NULL,r_kanban_card_rec.attribute13)
2227: ,DECODE(r_kanban_card_rec.attribute14,NULL,MKC.attribute14,FND_API.G_MISS_CHAR,NULL,r_kanban_card_rec.attribute14)
2228: ,DECODE(r_kanban_card_rec.attribute15,NULL,MKC.attribute15,FND_API.G_MISS_CHAR,NULL,r_kanban_card_rec.attribute15)
2229: ,MKC.last_print_date
2230: INTO r_kanban_card_rec.kanban_card_id
2231: ,r_kanban_card_rec.kanban_card_number
2232: ,r_kanban_card_rec.pull_sequence_id
2480: END IF;--end if for source type
2481: -- Validate wip line id only if source type is production
2482: IF r_kanban_card_rec.source_type = inv_kanban_pvt.g_source_type_production THEN
2483: IF r_kanban_card_rec.wip_line_id IS NULL AND lr_pullseq_info.wip_line_id IS NULL THEN
2484: IF r_kanban_card_rec.wip_line_code IS NOT NULL AND r_kanban_card_rec.wip_line_code <> FND_API.G_MISS_CHAR THEN
2485: r_kanban_card_rec.wip_line_id := FLM_KANBAN_PUB.default_wip_line_id(p_wip_line_code => r_kanban_card_rec.wip_line_code
2486: ,p_org_id => r_kanban_card_rec.organization_id
2487: );
2488: IF r_kanban_card_rec.wip_line_id IS NULL THEN
2536: END IF;
2537:
2538: END IF;
2539: IF p_error_text IS NOT NULL THEN -- Validation failed
2540: x_ret_status := FND_API.G_RET_STS_ERROR;
2541: ELSE
2542: x_ret_status := FND_API.G_RET_STS_SUCCESS;
2543: END IF;
2544: p_kanban_card_rec := r_kanban_card_rec;
2538: END IF;
2539: IF p_error_text IS NOT NULL THEN -- Validation failed
2540: x_ret_status := FND_API.G_RET_STS_ERROR;
2541: ELSE
2542: x_ret_status := FND_API.G_RET_STS_SUCCESS;
2543: END IF;
2544: p_kanban_card_rec := r_kanban_card_rec;
2545: mydebug('End Procedure validate_kanban_cards');
2546: EXCEPTION
2545: mydebug('End Procedure validate_kanban_cards');
2546: EXCEPTION
2547: WHEN OTHERS THEN
2548: p_kanban_card_rec := r_kanban_card_rec;
2549: x_ret_status := FND_API.G_RET_STS_ERROR;
2550: p_error_text := p_error_text || SQLERRM;
2551: END validate_kanban_cards;
2552:
2553: -----------------------------------
2571: l_supply_status NUMBER;
2572: l_card_status NUMBER;
2573: l_supplier_id NUMBER;
2574: l_supp_site_id NUMBER;
2575: l_ret_status VARCHAR2(10):=FND_API.G_RET_STS_SUCCESS;
2576: l_ret_msg_code NUMBER;
2577: l_error_msg VARCHAR2(2000);
2578: l_count NUMBER;
2579: l_Current_Replnsh_Cycle_Id Number := null;
2597: x_supplier_site_id => l_supp_site_id,
2598: x_retcode => l_ret_status,
2599: x_err_msg => l_error_msg
2600: );
2601: IF l_ret_status <> FND_API.G_RET_STS_SUCCESS THEN
2602: Raise FND_API.G_EXC_ERROR;
2603: END IF;
2604:
2605:
2598: x_retcode => l_ret_status,
2599: x_err_msg => l_error_msg
2600: );
2601: IF l_ret_status <> FND_API.G_RET_STS_SUCCESS THEN
2602: Raise FND_API.G_EXC_ERROR;
2603: END IF;
2604:
2605:
2606: IF r_kanban_card_rec.supply_status IS NULL THEN
2661:
2662: fnd_message.set_name ('FLM', 'FLM_ATTRIBUTE_EXISTS');
2663: fnd_message.set_token ('ATTRIBUTE', 'Kanban Card Number');
2664: l_error_msg := FND_MESSAGE.GET;
2665: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
2666: exception
2667: when others then
2668: null;
2669: end;
2729: p_replacement_flag => r_kanban_card_rec.replacement_flag);
2730:
2731:
2732:
2733: IF l_ret_status = FND_API.G_RET_STS_ERROR THEN
2734: Raise FND_API.G_EXC_ERROR;
2735: END IF;
2736: IF l_ret_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2737: mydebug('Unexpected error after INV_kanban_PVT.create_kanban_cards');
2730:
2731:
2732:
2733: IF l_ret_status = FND_API.G_RET_STS_ERROR THEN
2734: Raise FND_API.G_EXC_ERROR;
2735: END IF;
2736: IF l_ret_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2737: mydebug('Unexpected error after INV_kanban_PVT.create_kanban_cards');
2738: l_error_msg := 'Unexpected error after INV_kanban_PVT.create_kanban_cards ';
2732:
2733: IF l_ret_status = FND_API.G_RET_STS_ERROR THEN
2734: Raise FND_API.G_EXC_ERROR;
2735: END IF;
2736: IF l_ret_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2737: mydebug('Unexpected error after INV_kanban_PVT.create_kanban_cards');
2738: l_error_msg := 'Unexpected error after INV_kanban_PVT.create_kanban_cards ';
2739: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
2740: END IF;
2735: END IF;
2736: IF l_ret_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2737: mydebug('Unexpected error after INV_kanban_PVT.create_kanban_cards');
2738: l_error_msg := 'Unexpected error after INV_kanban_PVT.create_kanban_cards ';
2739: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
2740: END IF;
2741: -- r_kanban_card_rec.kanban_card_id := l_kanban_card_ids(1);
2742:
2743: ELSIF p_transaction_type = FLM_KANBAN_MASSLOAD.KANBAN_CHANGE THEN
2750: WHERE MTC.kanban_card_id = r_kanban_card_rec.kanban_card_id;
2751:
2752: IF (SQL%NOTFOUND) THEN
2753: l_error_msg := 'Eror while fetching Card Details ';
2754: Raise FND_API.G_EXC_ERROR;
2755: END IF;
2756:
2757: mydebug('Calling FLM_KANBANCARD_PUB.UPDATE_CARD');
2758: FLM_KANBANCARD_PUB.UPDATE_CARD(p_kanban_card_id => r_kanban_card_rec.kanban_card_id,
2822: P_VERIFY => 'N',
2823: X_RETCODE => l_ret_status,
2824: X_RET_MSG_CODE => l_ret_msg_code,
2825: X_ERR_MSG => l_error_msg);
2826: IF l_ret_status <> FND_API.G_RET_STS_SUCCESS THEN
2827: x_err_msg := l_error_msg;
2828: END IF;
2829:
2830: ELSIF p_transaction_type = FLM_KANBAN_MASSLOAD.KANBAN_DELETE THEN
2830: ELSIF p_transaction_type = FLM_KANBAN_MASSLOAD.KANBAN_DELETE THEN
2831: mydebug('Transaction Type DELETE');
2832: INV_KanbanCard_PKG.delete_row(x_return_status => l_ret_status,
2833: p_kanban_card_id => r_kanban_card_rec.kanban_card_id);
2834: IF l_ret_status = FND_API.G_RET_STS_ERROR THEN
2835: x_err_msg := ' Error While Deleting the kanban card.'||SQLERRM;
2836: END IF;
2837: END IF;
2838: p_kanban_card_rec := r_kanban_card_rec;
2837: END IF;
2838: p_kanban_card_rec := r_kanban_card_rec;
2839: x_ret_status := l_ret_status;
2840: EXCEPTION
2841: WHEN FND_API.G_EXC_ERROR THEN
2842: p_kanban_card_rec := r_kanban_card_rec;
2843: x_ret_status := FND_API.G_RET_STS_ERROR;
2844: x_err_msg := 'error in process_kanban_cards procedure '||l_error_msg||SQLERRM;
2845: invkbcgn.print_error;
2839: x_ret_status := l_ret_status;
2840: EXCEPTION
2841: WHEN FND_API.G_EXC_ERROR THEN
2842: p_kanban_card_rec := r_kanban_card_rec;
2843: x_ret_status := FND_API.G_RET_STS_ERROR;
2844: x_err_msg := 'error in process_kanban_cards procedure '||l_error_msg||SQLERRM;
2845: invkbcgn.print_error;
2846: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2847: p_kanban_card_rec := r_kanban_card_rec;
2842: p_kanban_card_rec := r_kanban_card_rec;
2843: x_ret_status := FND_API.G_RET_STS_ERROR;
2844: x_err_msg := 'error in process_kanban_cards procedure '||l_error_msg||SQLERRM;
2845: invkbcgn.print_error;
2846: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2847: p_kanban_card_rec := r_kanban_card_rec;
2848: x_ret_status := FND_API.G_RET_STS_UNEXP_ERROR;
2849: x_err_msg := ' Error in process_kanban_cards procedure '||l_error_msg||SQLERRM;
2850: invkbcgn.print_error;
2844: x_err_msg := 'error in process_kanban_cards procedure '||l_error_msg||SQLERRM;
2845: invkbcgn.print_error;
2846: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2847: p_kanban_card_rec := r_kanban_card_rec;
2848: x_ret_status := FND_API.G_RET_STS_UNEXP_ERROR;
2849: x_err_msg := ' Error in process_kanban_cards procedure '||l_error_msg||SQLERRM;
2850: invkbcgn.print_error;
2851: WHEN OTHERS THEN
2852: p_kanban_card_rec := r_kanban_card_rec;
2850: invkbcgn.print_error;
2851: WHEN OTHERS THEN
2852: p_kanban_card_rec := r_kanban_card_rec;
2853: x_err_msg := 'Unexpected error in process_kanban_cards procedure '||SQLERRM;
2854: x_ret_status := FND_API.G_RET_STS_UNEXP_ERROR;
2855: invkbcgn.print_error;
2856: END process_kanban_cards;
2857:
2858: ------------------------------------------------------------------------
2919: )
2920: IS
2921: r_kanban_card_rec flm_ekanban_pub.kanban_card_rec_type;
2922: l_release_kanban_flag NUMBER;
2923: l_ret_status VARCHAR2(1):= FND_API.G_RET_STS_SUCCESS;
2924: l_err_msg VARCHAR2(2000);
2925: BEGIN
2926: mydebug('In Procedure FLM_KANBAN_PUB.process_cards');
2927: mydebug('Assigning values to record type variable ');
2989: ,p_release_kanban_flag => l_release_kanban_flag
2990: ,p_error_text => l_err_msg
2991: ,x_ret_status => l_ret_status
2992: );
2993: IF l_ret_status = FND_API.G_RET_STS_ERROR THEN
2994: x_ret_status := l_ret_status;
2995: x_err_msg := l_err_msg;
2996: return;
2997: ELSE
3002: ,p_transaction_type => p_transaction_type
3003: ,x_ret_status => l_ret_status
3004: ,x_err_msg => l_err_msg
3005: );
3006: IF l_ret_status IN (FND_API.G_RET_STS_ERROR,FND_API.G_RET_STS_UNEXP_ERROR) THEN
3007: x_ret_status := l_ret_status;
3008: x_err_msg := l_err_msg;
3009: return;
3010: ELSIF l_ret_status = 'W' THEN /*Bug#14378439: Setting x_err_mesg to error message, but ensuring that no return happens*/
3042: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME
3043: ,'process_cards'
3044: );
3045: END IF;
3046: x_ret_status := FND_API.G_RET_STS_UNEXP_ERROR;
3047: END process_cards;
3048:
3049: PROCEDURE process_cards(p_kanban_card_rec IN OUT NOCOPY flm_ekanban_pub.kanban_card_rec_type
3050: ,p_transaction_type IN NUMBER
3204: ,x_ret_status => l_ret_status
3205: ,x_err_msg => l_err_msg
3206: );
3207:
3208: IF l_ret_status = FND_API.G_RET_STS_ERROR THEN
3209: p_card_int_tbl(i).process_status := FLM_KANBAN_MASSLOAD.ERROR;
3210: p_card_int_tbl(i).error_text := l_err_msg;
3211: fnd_file.put_line(fnd_file.log,' Kanban card details with Interface Id : '|| p_card_int_tbl(i).interface_id ||
3212: ' failed due to following : '|| l_err_msg );
3209: p_card_int_tbl(i).process_status := FLM_KANBAN_MASSLOAD.ERROR;
3210: p_card_int_tbl(i).error_text := l_err_msg;
3211: fnd_file.put_line(fnd_file.log,' Kanban card details with Interface Id : '|| p_card_int_tbl(i).interface_id ||
3212: ' failed due to following : '|| l_err_msg );
3213: ELSIF l_ret_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3214: p_card_int_tbl(i).process_status := FLM_KANBAN_MASSLOAD.ERROR;
3215: p_card_int_tbl(i).error_text := l_err_msg ;
3216: fnd_file.put_line(fnd_file.log,' Kanban card details with Interface Id : '|| p_card_int_tbl(i).interface_id ||
3217: ' failed due to following : '|| l_err_msg );
3214: p_card_int_tbl(i).process_status := FLM_KANBAN_MASSLOAD.ERROR;
3215: p_card_int_tbl(i).error_text := l_err_msg ;
3216: fnd_file.put_line(fnd_file.log,' Kanban card details with Interface Id : '|| p_card_int_tbl(i).interface_id ||
3217: ' failed due to following : '|| l_err_msg );
3218: ELSIF l_ret_status = FND_API.G_RET_STS_SUCCESS THEN
3219: p_card_int_tbl(i).process_status := FLM_KANBAN_MASSLOAD.COMPLETED;
3220: p_card_int_tbl(i).kanban_card_id := r_kanban_card_rec.kanban_card_id;
3221: mydebug('Kanban Card Id : '|| p_card_int_tbl(i).kanban_card_id);
3222: fnd_file.put_line(fnd_file.log,' Kanban card details with Interface Id : '|| p_card_int_tbl(i).interface_id ||
3226: p_card_int_tbl(i).kanban_card_id := r_kanban_card_rec.kanban_card_id;
3227: fnd_file.put_line(fnd_file.log,' Kanban card details with Interface Id : '|| p_card_int_tbl(i).interface_id ||
3228: ' had following warnings : '|| l_err_msg );
3229: END IF;
3230: IF l_ret_status not in (FND_API.G_RET_STS_SUCCESS,'W') THEN
3231: l_count := l_count + 1;
3232: END IF;
3233: END LOOP;
3234: IF l_count > 0 THEN
3231: l_count := l_count + 1;
3232: END IF;
3233: END LOOP;
3234: IF l_count > 0 THEN
3235: x_ret_status := FND_API.G_RET_STS_ERROR;
3236: ELSE
3237: x_ret_status := FND_API.G_RET_STS_SUCCESS;
3238: END IF;
3239: mydebug('END process_kc Procedure');
3233: END LOOP;
3234: IF l_count > 0 THEN
3235: x_ret_status := FND_API.G_RET_STS_ERROR;
3236: ELSE
3237: x_ret_status := FND_API.G_RET_STS_SUCCESS;
3238: END IF;
3239: mydebug('END process_kc Procedure');
3240:
3241: EXCEPTION
3239: mydebug('END process_kc Procedure');
3240:
3241: EXCEPTION
3242: WHEN OTHERS THEN
3243: x_ret_status := FND_API.G_RET_STS_ERROR;
3244: END process_kc;
3245:
3246: --------------------------------------------
3247: -- Pull sequence UI to call this procedure
3391: ,x_error_msg => l_error_msg);
3392: mydebug('l_ret_status='||l_ret_status);
3393:
3394: -- Insert/Update/Delete pull sequences
3395: if l_ret_status = FND_API.G_RET_STS_SUCCESS then
3396:
3397: mydebug('Assigning validated record values.');
3398: --Assign the validated record
3399: l_pull_sequence_rec.pull_sequence_id := r_pull_seq_rec.pull_sequence_id;
3543: p_avg_independent_demand =>l_pull_sequence_rec.avg_independent_demand);
3544:
3545: mydebug('l_ret_status='||l_ret_status);
3546:
3547: IF l_ret_status = FND_API.G_RET_STS_ERROR THEN
3548: l_error_msg := 'Error in INV_PullSequence_PKG.Insert_Row';
3549: ELSIF l_ret_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3550: l_error_msg := FND_MSG_PUB.Get(FND_MSG_PUB.G_LAST, FND_API.G_FALSE);
3551: END IF;
3545: mydebug('l_ret_status='||l_ret_status);
3546:
3547: IF l_ret_status = FND_API.G_RET_STS_ERROR THEN
3548: l_error_msg := 'Error in INV_PullSequence_PKG.Insert_Row';
3549: ELSIF l_ret_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3550: l_error_msg := FND_MSG_PUB.Get(FND_MSG_PUB.G_LAST, FND_API.G_FALSE);
3551: END IF;
3552:
3553: elsif p_transaction_type = FLM_KANBAN_MASSLOAD.KANBAN_CHANGE then
3546:
3547: IF l_ret_status = FND_API.G_RET_STS_ERROR THEN
3548: l_error_msg := 'Error in INV_PullSequence_PKG.Insert_Row';
3549: ELSIF l_ret_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3550: l_error_msg := FND_MSG_PUB.Get(FND_MSG_PUB.G_LAST, FND_API.G_FALSE);
3551: END IF;
3552:
3553: elsif p_transaction_type = FLM_KANBAN_MASSLOAD.KANBAN_CHANGE then
3554: -- update pull sequence
3619: p_avg_independent_demand =>l_pull_sequence_rec.avg_independent_demand);
3620:
3621: mydebug('l_ret_status='||l_ret_status);
3622:
3623: IF l_ret_status = FND_API.G_RET_STS_SUCCESS THEN
3624: -- Set replacement flag on cards when pull seq is updated.
3625: UPDATE MTL_KANBAN_CARDS
3626: SET replacement_flag = 1
3627: WHERE source_type <> l_pull_sequence_rec.source_type
3629: AND source_locator_id <> l_pull_sequence_rec.source_locator_id
3630: AND wip_line_id <> l_pull_sequence_rec.wip_line_id
3631: AND pull_sequence_id = l_pull_sequence_rec.pull_sequence_id;
3632:
3633: ELSIF l_ret_status = FND_API.G_RET_STS_ERROR THEN
3634: l_error_msg := 'Error in INV_PullSequence_PKG.Update_Row';
3635: ELSE
3636: l_error_msg := FND_MSG_PUB.Get(FND_MSG_PUB.G_LAST, FND_API.G_FALSE);
3637: END IF;
3632:
3633: ELSIF l_ret_status = FND_API.G_RET_STS_ERROR THEN
3634: l_error_msg := 'Error in INV_PullSequence_PKG.Update_Row';
3635: ELSE
3636: l_error_msg := FND_MSG_PUB.Get(FND_MSG_PUB.G_LAST, FND_API.G_FALSE);
3637: END IF;
3638:
3639: elsif p_transaction_type = FLM_KANBAN_MASSLOAD.KANBAN_DELETE then
3640: -- delete pull sequence
3644: ,p_Pull_sequence_Id => l_pull_sequence_rec.pull_sequence_id);
3645:
3646: mydebug('l_ret_status='||l_ret_status);
3647:
3648: IF l_ret_status = FND_API.G_RET_STS_ERROR THEN
3649: l_error_msg := fnd_message.get;
3650: ELSIF l_ret_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3651: l_error_msg := FND_MSG_PUB.Get(FND_MSG_PUB.G_LAST, FND_API.G_FALSE);
3652: END IF;
3646: mydebug('l_ret_status='||l_ret_status);
3647:
3648: IF l_ret_status = FND_API.G_RET_STS_ERROR THEN
3649: l_error_msg := fnd_message.get;
3650: ELSIF l_ret_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3651: l_error_msg := FND_MSG_PUB.Get(FND_MSG_PUB.G_LAST, FND_API.G_FALSE);
3652: END IF;
3653:
3654: end if;
3647:
3648: IF l_ret_status = FND_API.G_RET_STS_ERROR THEN
3649: l_error_msg := fnd_message.get;
3650: ELSIF l_ret_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3651: l_error_msg := FND_MSG_PUB.Get(FND_MSG_PUB.G_LAST, FND_API.G_FALSE);
3652: END IF;
3653:
3654: end if;
3655:
3666: EXCEPTION
3667:
3668: WHEN OTHERS THEN
3669:
3670: x_ret_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3671: x_error_msg := 'Unexpected error in process_pull_sequence procedure:'||SQLERRM;
3672: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3673: THEN
3674: FND_MSG_PUB.Add_Exc_Msg
3685: ,p_organization_id IN NUMBER
3686: ,x_ret_status OUT NOCOPY VARCHAR2
3687: ,x_error_msg OUT NOCOPY VARCHAR2)
3688: IS
3689: l_ret_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
3690: l_transaction_type NUMBER;
3691: l_pullseq_id NUMBER;
3692: l_supplier_count Number; --Bug 12533212
3693: l_sourcing_percentage NUMBER; --Bug 12419603
3834:
3835: end if; -- l_transaction_type IN add or change
3836:
3837: if x_error_msg is NOT NULL THEN
3838: x_ret_status := FND_API.G_RET_STS_ERROR;
3839: else
3840: x_ret_status := l_ret_status;
3841: end if;
3842: mydebug('Exiting validate_suppliers procedure');
3841: end if;
3842: mydebug('Exiting validate_suppliers procedure');
3843: EXCEPTION
3844: WHEN OTHERS THEN
3845: x_ret_status := FND_API.G_RET_STS_ERROR;
3846: x_error_msg := 'Error in validate_suppliers procedure:' ||FND_CONST.NEWLINE||SQLERRM;
3847: END validate_suppliers;
3848:
3849: --------------------------------------------
3949: ,p_transaction_type => p_transaction_type
3950: ,x_ret_status => l_ret_status
3951: ,x_error_msg => l_error_msg);
3952:
3953: if l_ret_status = FND_API.G_RET_STS_SUCCESS and
3954: p_transaction_type IN (FLM_KANBAN_MASSLOAD.KANBAN_ADD,FLM_KANBAN_MASSLOAD.KANBAN_CHANGE)
3955: then
3956: -- Fix bug 12402610
3957: -- when updating pull sequence, if source_type is null, derive the source_type from mtl_kanban_pull_sequences table
3997: ,p_transaction_type => p_supplier_tbl(i).transaction_type
3998: ,x_ret_status => l_ret_status
3999: ,x_error_msg => l_error_msg);
4000:
4001: if l_ret_status = FND_API.G_RET_STS_ERROR then
4002: x_ret_status := l_ret_status;
4003: x_error_msg := l_error_msg;
4004: ROLLBACK TO SAVEPOINT A;
4005: exit;
4006: end if;
4007:
4008: END LOOP;
4009:
4010: if l_ret_status = FND_API.G_RET_STS_SUCCESS then
4011: mydebug('Calling FLM_MULTIPLE_SUPPLIERS.multiple_supplier_kanban_cards procedure.');
4012: --multiple supplier API..
4013: FLM_MULTIPLE_SUPPLIERS.multiple_supplier_kanban_cards(p_pull_seq_id => p_pull_sequence_rec.pull_sequence_id,
4014: x_retcode => l_ret_status,
4018: mydebug('l_ret_status='||l_ret_status);
4019: mydebug('l_error_msg='||l_error_msg);
4020:
4021: -- Nullify supplier details at pull sequence if multiple suppliers are used
4022: if l_ret_status = FND_API.G_RET_STS_SUCCESS then
4023: UPDATE mtl_kanban_pull_sequences
4024: SET supplier_id = null
4025: ,supplier_site_id = null
4026: WHERE pull_sequence_id = p_pull_sequence_rec.pull_sequence_id;
4029: elsif p_pull_sequence_rec.source_type IN (inv_kanban_pvt.G_Source_Type_InterOrg,
4030: inv_kanban_pvt.G_Source_Type_IntraOrg,
4031: inv_kanban_pvt.G_Source_Type_Production) then
4032: if l_supplier_count > 0 then
4033: l_ret_status := FND_API.G_RET_STS_ERROR;
4034: FND_MESSAGE.SET_NAME('FLM','FLM_NO_SUPPLIERS_REQUIRED');
4035: l_error_msg := x_error_msg || FND_CONST.NEWLINE||FND_MESSAGE.GET;
4036: end if;
4037:
4038: end if;
4039: end if;
4040:
4041: -- call api to generate cards
4042: IF l_generate_cards = 'Y' and l_ret_status = FND_API.G_RET_STS_SUCCESS THEN
4043: mydebug('Calling INVKBCGN.create_kanban_cards procedure.');
4044:
4045: INVKBCGN.create_kanban_cards(
4046: errbuf => l_error_msg
4071: mydebug('l_error_msg='||l_error_msg);
4072:
4073: -- set l_ret_status based on l_ret_code of INVKBCGN.create_kanban_cards
4074: IF l_ret_code <> 1 THEN
4075: l_ret_status := FND_API.G_RET_STS_ERROR;
4076: ELSE
4077: l_ret_status := FND_API.G_RET_STS_SUCCESS;
4078: END IF;
4079:
4073: -- set l_ret_status based on l_ret_code of INVKBCGN.create_kanban_cards
4074: IF l_ret_code <> 1 THEN
4075: l_ret_status := FND_API.G_RET_STS_ERROR;
4076: ELSE
4077: l_ret_status := FND_API.G_RET_STS_SUCCESS;
4078: END IF;
4079:
4080: END IF;
4081:
4078: END IF;
4079:
4080: END IF;
4081:
4082: if l_ret_status = FND_API.G_RET_STS_ERROR then
4083: ROLLBACK TO SAVEPOINT A;
4084: end if;
4085:
4086: x_ret_status := l_ret_status;
4085:
4086: x_ret_status := l_ret_status;
4087: x_error_msg := l_error_msg;
4088:
4089: if p_commit_flag = 'Y' and l_ret_status = FND_API.G_RET_STS_SUCCESS then
4090: COMMIT;
4091: end if;
4092:
4093: EXCEPTION
4091: end if;
4092:
4093: EXCEPTION
4094: WHEN OTHERS THEN
4095: x_ret_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4096: x_error_msg := 'Unexpected error in process_pull_sequence Public API procedure:'||SQLERRM;
4097: mydebug(x_error_msg);
4098: ROLLBACK TO SAVEPOINT A;
4099: END process_pull_sequence;
4160: mydebug('l_ret_status='||l_ret_status);
4161: mydebug('l_error_msg='||l_error_msg);
4162:
4163: -- Inser/Update/Delete supplier
4164: if l_ret_status = FND_API.G_RET_STS_SUCCESS then
4165:
4166: v_supplier_rec.pull_sequence_id := r_supplier_rec.pull_sequence_id;
4167: v_supplier_rec.organization_id := r_supplier_rec.organization_id;
4168: v_supplier_rec.supplier_id := r_supplier_rec.supplier_id;
4193: ,p_supplier_id => v_supplier_rec.supplier_id); --Fix bug 12419603
4194:
4195: end if;
4196:
4197: IF l_ret_status = FND_API.G_RET_STS_ERROR THEN
4198: Raise FND_API.G_EXC_ERROR;
4199: END IF;
4200:
4201: IF l_ret_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4194:
4195: end if;
4196:
4197: IF l_ret_status = FND_API.G_RET_STS_ERROR THEN
4198: Raise FND_API.G_EXC_ERROR;
4199: END IF;
4200:
4201: IF l_ret_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4202: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
4197: IF l_ret_status = FND_API.G_RET_STS_ERROR THEN
4198: Raise FND_API.G_EXC_ERROR;
4199: END IF;
4200:
4201: IF l_ret_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4202: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
4203: END IF;
4204: end if;
4205:
4198: Raise FND_API.G_EXC_ERROR;
4199: END IF;
4200:
4201: IF l_ret_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4202: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
4203: END IF;
4204: end if;
4205:
4206: x_ret_status := l_ret_status;
4206: x_ret_status := l_ret_status;
4207: x_error_msg := l_error_msg;
4208: EXCEPTION
4209:
4210: WHEN FND_API.G_EXC_ERROR THEN
4211:
4212: x_ret_status := FND_API.G_RET_STS_ERROR;
4213: x_error_msg := 'Execution error in process_suppliers procedure:'||SQLERRM;
4214: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4208: EXCEPTION
4209:
4210: WHEN FND_API.G_EXC_ERROR THEN
4211:
4212: x_ret_status := FND_API.G_RET_STS_ERROR;
4213: x_error_msg := 'Execution error in process_suppliers procedure:'||SQLERRM;
4214: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4215:
4216: x_ret_status := FND_API.G_RET_STS_UNEXP_ERROR;
4210: WHEN FND_API.G_EXC_ERROR THEN
4211:
4212: x_ret_status := FND_API.G_RET_STS_ERROR;
4213: x_error_msg := 'Execution error in process_suppliers procedure:'||SQLERRM;
4214: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4215:
4216: x_ret_status := FND_API.G_RET_STS_UNEXP_ERROR;
4217: x_error_msg := 'Unexpected error in process_suppliers procedure:'||SQLERRM;
4218: WHEN OTHERS THEN
4212: x_ret_status := FND_API.G_RET_STS_ERROR;
4213: x_error_msg := 'Execution error in process_suppliers procedure:'||SQLERRM;
4214: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4215:
4216: x_ret_status := FND_API.G_RET_STS_UNEXP_ERROR;
4217: x_error_msg := 'Unexpected error in process_suppliers procedure:'||SQLERRM;
4218: WHEN OTHERS THEN
4219:
4220: x_ret_status := FND_API.G_RET_STS_UNEXP_ERROR;
4216: x_ret_status := FND_API.G_RET_STS_UNEXP_ERROR;
4217: x_error_msg := 'Unexpected error in process_suppliers procedure:'||SQLERRM;
4218: WHEN OTHERS THEN
4219:
4220: x_ret_status := FND_API.G_RET_STS_UNEXP_ERROR;
4221: x_error_msg := 'Unexpected error in process_suppliers procedure:'||SQLERRM;
4222: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4223: THEN
4224: FND_MSG_PUB.Add_Exc_Msg
4254: IF p_kanban_card_tbl.COUNT > 0 THEN
4255: process_kc(p_kanban_card_tbl, l_ret_status2);
4256: END IF;
4257:
4258: IF l_ret_status1 = FND_API.G_RET_STS_ERROR OR l_ret_status2 = FND_API.G_RET_STS_ERROR THEN
4259: x_ret_status := FND_API.G_RET_STS_ERROR;
4260: ELSE
4261: x_ret_status := FND_API.G_RET_STS_SUCCESS;
4262: END IF;
4255: process_kc(p_kanban_card_tbl, l_ret_status2);
4256: END IF;
4257:
4258: IF l_ret_status1 = FND_API.G_RET_STS_ERROR OR l_ret_status2 = FND_API.G_RET_STS_ERROR THEN
4259: x_ret_status := FND_API.G_RET_STS_ERROR;
4260: ELSE
4261: x_ret_status := FND_API.G_RET_STS_SUCCESS;
4262: END IF;
4263:
4257:
4258: IF l_ret_status1 = FND_API.G_RET_STS_ERROR OR l_ret_status2 = FND_API.G_RET_STS_ERROR THEN
4259: x_ret_status := FND_API.G_RET_STS_ERROR;
4260: ELSE
4261: x_ret_status := FND_API.G_RET_STS_SUCCESS;
4262: END IF;
4263:
4264: END process_kanban;
4265: