eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FLM_KANBAN_PUB dependencies on FND_API

Line 223: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

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:

Line 255: WHEN FND_API.G_EXC_ERROR THEN

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

Line 257: x_return_status := FND_API.G_RET_STS_ERROR;

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;

Line 259: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 261: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 272: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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)

Line 298: if l_return_status = FND_API.G_RET_STS_ERROR

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:

Line 300: Raise FND_API.G_EXC_ERROR;

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

Line 303: if l_return_status = FND_API.G_RET_STS_UNEXP_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
305: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
306: End If;
307:

Line 305: Raise FND_API.G_EXC_UNEXPECTED_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:
308: EXCEPTION
309: WHEN FND_API.G_EXC_ERROR THEN

Line 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

Line 311: Raise FND_API.G_EXC_ERROR;

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;

Line 313: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 315: Raise FND_API.G_EXC_UNEXPECTED_ERROR;

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)

Line 327: Raise FND_API.G_EXC_UNEXPECTED_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: --------------------------

Line 344: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

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.');

Line 368: WHEN FND_API.G_EXC_ERROR THEN

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

Line 370: x_return_status := FND_API.G_RET_STS_ERROR;

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;

Line 372: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 374: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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)

Line 386: x_return_status := FND_API.G_RET_STS_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)

Line 408: if l_return_status = FND_API.G_RET_STS_ERROR

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:

Line 410: Raise FND_API.G_EXC_ERROR;

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

Line 413: if l_return_status = FND_API.G_RET_STS_UNEXP_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
415: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
416: End If;
417:

Line 415: Raise FND_API.G_EXC_UNEXPECTED_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:
418: EXCEPTION
419:

Line 420: WHEN FND_API.G_EXC_ERROR THEN

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

Line 422: Raise FND_API.G_EXC_ERROR;

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;

Line 424: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 426: Raise FND_API.G_EXC_UNEXPECTED_ERROR;

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)

Line 437: Raise FND_API.G_EXC_UNEXPECTED_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

Line 448: l_return_status varchar2(1) := FND_API.G_RET_STS_ERROR;

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.');

Line 459: Raise FND_API.G_EXC_UNEXPECTED_ERROR;

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:

Line 461: l_return_status := FND_API.G_RET_STS_SUCCESS;

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:

Line 470: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 576: l_ret_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

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);

Line 734: ,decode(p_pull_seq_rec.source_type,null,mkps.source_type,FND_API.G_MISS_NUM,null,p_pull_seq_rec.source_type)

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)

Line 735: ,decode(p_pull_seq_rec.supplier_id,null,mkps.supplier_id,FND_API.G_MISS_NUM,null,p_pull_seq_rec.supplier_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)
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)

Line 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)

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)

Line 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)

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)

Line 738: ,decode(p_pull_seq_rec.source_subinventory,null,mkps.source_subinventory,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.source_subinventory)

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)

Line 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)

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)

Line 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)

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)

Line 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)

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)

Line 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)

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)

Line 743: ,decode(p_pull_seq_rec.kanban_size,null,mkps.kanban_size,FND_API.G_MISS_NUM,null,p_pull_seq_rec.kanban_size)

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)

Line 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)

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)

Line 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)

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)

Line 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)

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)

Line 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)

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)

Line 748: ,decode(p_pull_seq_rec.aggregation_type,null,mkps.aggregation_type,FND_API.G_MISS_NUM,null,p_pull_seq_rec.aggregation_type)

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)

Line 749: ,decode(p_pull_seq_rec.allocation_percent,null,mkps.allocation_percent,FND_API.G_MISS_NUM,null,p_pull_seq_rec.allocation_percent)

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)

Line 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)

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)

Line 751: ,decode(p_pull_seq_rec.attribute_category,null,mkps.attribute_category,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.attribute_category)

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)

Line 752: ,decode(p_pull_seq_rec.attribute1,null,mkps.attribute1,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.attribute1)

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)

Line 753: ,decode(p_pull_seq_rec.attribute2,null,mkps.attribute2,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.attribute2)

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)

Line 754: ,decode(p_pull_seq_rec.attribute3,null,mkps.attribute3,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.attribute3)

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)

Line 755: ,decode(p_pull_seq_rec.attribute4,null,mkps.attribute4,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.attribute4)

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)

Line 756: ,decode(p_pull_seq_rec.attribute5,null,mkps.attribute5,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.attribute5)

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)

Line 757: ,decode(p_pull_seq_rec.attribute6,null,mkps.attribute6,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.attribute6)

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)

Line 758: ,decode(p_pull_seq_rec.attribute7,null,mkps.attribute7,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.attribute7)

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)

Line 759: ,decode(p_pull_seq_rec.attribute8,null,mkps.attribute8,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.attribute8)

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)

Line 760: ,decode(p_pull_seq_rec.attribute9,null,mkps.attribute9,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.attribute9)

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)

Line 761: ,decode(p_pull_seq_rec.attribute10,null,mkps.attribute10,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.attribute10)

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)

Line 762: ,decode(p_pull_seq_rec.attribute11,null,mkps.attribute11,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.attribute11)

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)

Line 763: ,decode(p_pull_seq_rec.attribute12,null,mkps.attribute12,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.attribute12)

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)

Line 764: ,decode(p_pull_seq_rec.attribute13,null,mkps.attribute13,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.attribute13)

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)

Line 765: ,decode(p_pull_seq_rec.attribute14,null,mkps.attribute14,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.attribute14)

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)

Line 766: ,decode(p_pull_seq_rec.attribute15,null,mkps.attribute15,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.attribute15)

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)

Line 767: ,decode(p_pull_seq_rec.auto_request,null,mkps.auto_request,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.auto_request)

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)

Line 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)

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)

Line 769: ,decode(p_pull_seq_rec.replenishment_type,null,mkps.replenishment_type,FND_API.G_MISS_NUM,null,p_pull_seq_rec.replenishment_type)

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)

Line 770: ,decode(p_pull_seq_rec.consolidation,null,mkps.consolidation,FND_API.G_MISS_NUM,null,p_pull_seq_rec.consolidation)

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)

Line 771: ,decode(p_pull_seq_rec.consolidation_group,null,mkps.consolidation_group,FND_API.G_MISS_CHAR,null,p_pull_seq_rec.consolidation_group)

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)

Line 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)

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)

Line 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)

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

Line 774: ,decode(p_pull_seq_rec.planning_effectivity,null,mkps.planning_effectivity,FND_API.G_MISS_DATE,null,p_pull_seq_rec.planning_effectivity)

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

Line 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)

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

Line 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)

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

Line 1215: -- during pull sequence update, p_pull_seq_rec.wip_line_code is set to FND_API.G_MISS_CHAR

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');

Line 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

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;

Line 1491: x_ret_status := FND_API.G_RET_STS_ERROR;

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:

Line 1499: x_ret_status := FND_API.G_RET_STS_ERROR;

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: -----------------------

Line 1516: l_ret_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

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;

Line 1628: if l_ret_status = FND_API.G_RET_STS_SUCCESS then

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 . ');

Line 1636: elsif l_ret_status = FND_API.G_RET_STS_ERROR then

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 );

Line 1648: IF l_ret_status <> FND_API.G_RET_STS_SUCCESS THEN

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;

Line 1655: x_ret_status := FND_API.G_RET_STS_ERROR;

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:

Line 1657: x_ret_status := FND_API.G_RET_STS_SUCCESS;

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

Line 1663: x_ret_status := FND_API.G_RET_STS_ERROR;

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

Line 2197: ,DECODE(r_kanban_card_rec.supply_status,NULL,MKC.supply_status,FND_API.G_MISS_NUM,NULL,r_kanban_card_rec.supply_status)

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)

Line 2198: ,DECODE(r_kanban_card_rec.card_status,NULL,MKC.card_status,FND_API.G_MISS_NUM,NULL,r_kanban_card_rec.card_status)

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)

Line 2201: ,DECODE(r_kanban_card_rec.supplier_id,NULL,MKC.supplier_id,FND_API.G_MISS_NUM,NULL,r_kanban_card_rec.supplier_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)

Line 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)

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

Line 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)

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)

Line 2204: ,DECODE(r_kanban_card_rec.source_subinventory,NULL,MKC.source_subinventory,FND_API.G_MISS_CHAR,NULL,r_kanban_card_rec.source_subinventory)

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)

Line 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)

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

Line 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)

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)

Line 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)

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)

Line 2210: ,DECODE(r_kanban_card_rec.max_replenishments,NULL,MKC.max_replenishments,FND_API.G_MISS_NUM,NULL,r_kanban_card_rec.max_replenishments)

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)

Line 2211: ,DECODE(r_kanban_card_rec.disable_date,NULL,MKC.disable_date,FND_API.G_MISS_DATE,NULL,r_kanban_card_rec.disable_date)

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)

Line 2212: ,DECODE(r_kanban_card_rec.replacement_flag,NULL,MKC.replacement_flag,FND_API.G_MISS_NUM,NULL,r_kanban_card_rec.replacement_flag)

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)

Line 2213: ,DECODE(r_kanban_card_rec.attribute_category,NULL,MKC.attribute_category,FND_API.G_MISS_CHAR,NULL,r_kanban_card_rec.attribute_category)

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)

Line 2214: ,DECODE(r_kanban_card_rec.attribute1,NULL,MKC.attribute1,FND_API.G_MISS_CHAR,NULL,r_kanban_card_rec.attribute1)

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)

Line 2215: ,DECODE(r_kanban_card_rec.attribute2,NULL,MKC.attribute2,FND_API.G_MISS_CHAR,NULL,r_kanban_card_rec.attribute2)

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)

Line 2216: ,DECODE(r_kanban_card_rec.attribute3,NULL,MKC.attribute3,FND_API.G_MISS_CHAR,NULL,r_kanban_card_rec.attribute3)

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)

Line 2217: ,DECODE(r_kanban_card_rec.attribute4,NULL,MKC.attribute4,FND_API.G_MISS_CHAR,NULL,r_kanban_card_rec.attribute4)

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)

Line 2218: ,DECODE(r_kanban_card_rec.attribute5,NULL,MKC.attribute5,FND_API.G_MISS_CHAR,NULL,r_kanban_card_rec.attribute5)

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)

Line 2219: ,DECODE(r_kanban_card_rec.attribute6,NULL,MKC.attribute6,FND_API.G_MISS_CHAR,NULL,r_kanban_card_rec.attribute6)

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)

Line 2220: ,DECODE(r_kanban_card_rec.attribute7,NULL,MKC.attribute7,FND_API.G_MISS_CHAR,NULL,r_kanban_card_rec.attribute7)

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)

Line 2221: ,DECODE(r_kanban_card_rec.attribute8,NULL,MKC.attribute8,FND_API.G_MISS_CHAR,NULL,r_kanban_card_rec.attribute8)

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)

Line 2222: ,DECODE(r_kanban_card_rec.attribute9,NULL,MKC.attribute9,FND_API.G_MISS_CHAR,NULL,r_kanban_card_rec.attribute9)

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)

Line 2223: ,DECODE(r_kanban_card_rec.attribute10,NULL,MKC.attribute10,FND_API.G_MISS_CHAR,NULL,r_kanban_card_rec.attribute10)

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)

Line 2224: ,DECODE(r_kanban_card_rec.attribute11,NULL,MKC.attribute11,FND_API.G_MISS_CHAR,NULL,r_kanban_card_rec.attribute11)

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)

Line 2225: ,DECODE(r_kanban_card_rec.attribute12,NULL,MKC.attribute12,FND_API.G_MISS_CHAR,NULL,r_kanban_card_rec.attribute12)

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

Line 2226: ,DECODE(r_kanban_card_rec.attribute13,NULL,MKC.attribute13,FND_API.G_MISS_CHAR,NULL,r_kanban_card_rec.attribute13)

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

Line 2227: ,DECODE(r_kanban_card_rec.attribute14,NULL,MKC.attribute14,FND_API.G_MISS_CHAR,NULL,r_kanban_card_rec.attribute14)

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

Line 2228: ,DECODE(r_kanban_card_rec.attribute15,NULL,MKC.attribute15,FND_API.G_MISS_CHAR,NULL,r_kanban_card_rec.attribute15)

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

Line 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

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

Line 2540: x_ret_status := FND_API.G_RET_STS_ERROR;

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;

Line 2542: x_ret_status := FND_API.G_RET_STS_SUCCESS;

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

Line 2549: x_ret_status := FND_API.G_RET_STS_ERROR;

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: -----------------------------------

Line 2575: l_ret_status VARCHAR2(10):=FND_API.G_RET_STS_SUCCESS;

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;

Line 2601: IF l_ret_status <> FND_API.G_RET_STS_SUCCESS THEN

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:

Line 2602: Raise FND_API.G_EXC_ERROR;

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

Line 2665: Raise FND_API.G_EXC_UNEXPECTED_ERROR;

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;

Line 2733: IF l_ret_status = FND_API.G_RET_STS_ERROR THEN

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');

Line 2734: Raise FND_API.G_EXC_ERROR;

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 ';

Line 2736: IF l_ret_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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;

Line 2739: Raise FND_API.G_EXC_UNEXPECTED_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;
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

Line 2754: Raise FND_API.G_EXC_ERROR;

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,

Line 2826: IF l_ret_status <> FND_API.G_RET_STS_SUCCESS THEN

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

Line 2834: IF l_ret_status = FND_API.G_RET_STS_ERROR 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;

Line 2841: WHEN FND_API.G_EXC_ERROR THEN

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;

Line 2843: x_ret_status := FND_API.G_RET_STS_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;

Line 2846: WHEN FND_API.G_EXC_UNEXPECTED_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;
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;

Line 2848: x_ret_status := FND_API.G_RET_STS_UNEXP_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;

Line 2854: x_ret_status := FND_API.G_RET_STS_UNEXP_ERROR;

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: ------------------------------------------------------------------------

Line 2923: l_ret_status VARCHAR2(1):= FND_API.G_RET_STS_SUCCESS;

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 ');

Line 2993: IF l_ret_status = FND_API.G_RET_STS_ERROR THEN

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

Line 3006: IF l_ret_status IN (FND_API.G_RET_STS_ERROR,FND_API.G_RET_STS_UNEXP_ERROR) THEN

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*/

Line 3046: x_ret_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 3208: IF l_ret_status = FND_API.G_RET_STS_ERROR THEN

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 );

Line 3213: ELSIF l_ret_status = FND_API.G_RET_STS_UNEXP_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 );
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 );

Line 3218: ELSIF l_ret_status = FND_API.G_RET_STS_SUCCESS 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 );
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 ||

Line 3230: IF l_ret_status not in (FND_API.G_RET_STS_SUCCESS,'W') THEN

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

Line 3235: x_ret_status := FND_API.G_RET_STS_ERROR;

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');

Line 3237: x_ret_status := FND_API.G_RET_STS_SUCCESS;

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

Line 3243: x_ret_status := FND_API.G_RET_STS_ERROR;

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

Line 3395: if l_ret_status = FND_API.G_RET_STS_SUCCESS then

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;

Line 3547: IF l_ret_status = FND_API.G_RET_STS_ERROR THEN

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;

Line 3549: ELSIF l_ret_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

Line 3550: l_error_msg := FND_MSG_PUB.Get(FND_MSG_PUB.G_LAST, FND_API.G_FALSE);

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

Line 3623: IF l_ret_status = FND_API.G_RET_STS_SUCCESS THEN

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

Line 3633: ELSIF l_ret_status = FND_API.G_RET_STS_ERROR THEN

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;

Line 3636: l_error_msg := FND_MSG_PUB.Get(FND_MSG_PUB.G_LAST, FND_API.G_FALSE);

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

Line 3648: IF l_ret_status = FND_API.G_RET_STS_ERROR THEN

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;

Line 3650: ELSIF l_ret_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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;

Line 3651: l_error_msg := FND_MSG_PUB.Get(FND_MSG_PUB.G_LAST, FND_API.G_FALSE);

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:

Line 3670: x_ret_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 3689: l_ret_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

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

Line 3838: x_ret_status := FND_API.G_RET_STS_ERROR;

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');

Line 3845: x_ret_status := FND_API.G_RET_STS_ERROR;

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: --------------------------------------------

Line 3953: if l_ret_status = FND_API.G_RET_STS_SUCCESS and

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

Line 4001: if l_ret_status = FND_API.G_RET_STS_ERROR then

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;

Line 4010: if l_ret_status = FND_API.G_RET_STS_SUCCESS then

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,

Line 4022: if l_ret_status = FND_API.G_RET_STS_SUCCESS then

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;

Line 4033: l_ret_status := FND_API.G_RET_STS_ERROR;

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:

Line 4042: IF l_generate_cards = 'Y' and l_ret_status = FND_API.G_RET_STS_SUCCESS THEN

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

Line 4075: l_ret_status := FND_API.G_RET_STS_ERROR;

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:

Line 4077: l_ret_status := FND_API.G_RET_STS_SUCCESS;

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:

Line 4082: if l_ret_status = FND_API.G_RET_STS_ERROR then

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;

Line 4089: if p_commit_flag = 'Y' and l_ret_status = FND_API.G_RET_STS_SUCCESS then

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

Line 4095: x_ret_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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;

Line 4164: if l_ret_status = FND_API.G_RET_STS_SUCCESS then

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;

Line 4197: IF l_ret_status = FND_API.G_RET_STS_ERROR THEN

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

Line 4198: Raise FND_API.G_EXC_ERROR;

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;

Line 4201: IF l_ret_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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:

Line 4202: Raise FND_API.G_EXC_UNEXPECTED_ERROR;

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;

Line 4210: WHEN FND_API.G_EXC_ERROR THEN

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

Line 4212: x_ret_status := FND_API.G_RET_STS_ERROR;

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;

Line 4214: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 4216: x_ret_status := FND_API.G_RET_STS_UNEXP_ERROR;

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;

Line 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

Line 4258: IF l_ret_status1 = FND_API.G_RET_STS_ERROR OR l_ret_status2 = FND_API.G_RET_STS_ERROR THEN

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;

Line 4259: x_ret_status := FND_API.G_RET_STS_ERROR;

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:

Line 4261: x_ret_status := FND_API.G_RET_STS_SUCCESS;

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: