APPS.RCV_GML_CONV_MIG dependencies on RCV_SUPPLY

Line 28: --Call proc to update secondary unit of measure and secondary quantity in rcv_supply.

24:
25: --Call proc to update lots with the latest migrated lot number in rcv_lot_Transactions.
26: Update_rcv_lot_transactions;
27:
28: --Call proc to update secondary unit of measure and secondary quantity in rcv_supply.
29: Update_rcv_supply;
30:
31: --Call proc to update lots with migrated lot number in rcv_lots_supply.
32: Update_rcv_lots_supply;

Line 29: Update_rcv_supply;

25: --Call proc to update lots with the latest migrated lot number in rcv_lot_Transactions.
26: Update_rcv_lot_transactions;
27:
28: --Call proc to update secondary unit of measure and secondary quantity in rcv_supply.
29: Update_rcv_supply;
30:
31: --Call proc to update lots with migrated lot number in rcv_lots_supply.
32: Update_rcv_lots_supply;
33:

Line 360: -- update_rcv_supply

356:
357:
358: /*===========================================================================
359: -- PROCEDURE:
360: -- update_rcv_supply
361: --
362: -- DESCRIPTION:
363: -- This PL/SQL procedure is used to Update RCV_SUPPLY for secondary_quantity
364: -- and secondary_unit_of_measure

Line 363: -- This PL/SQL procedure is used to Update RCV_SUPPLY for secondary_quantity

359: -- PROCEDURE:
360: -- update_rcv_supply
361: --
362: -- DESCRIPTION:
363: -- This PL/SQL procedure is used to Update RCV_SUPPLY for secondary_quantity
364: -- and secondary_unit_of_measure
365: --
366: -- PARAMETERS:
367: -- None

Line 370: -- update_rcv_supply;

366: -- PARAMETERS:
367: -- None
368: --
369: -- SYNOPSIS:
370: -- update_rcv_supply;
371: --
372: -- HISTORY
373: -- P. Bamb 10-May-2005 Created
374: --=========================================================================== */

Line 375: PROCEDURE update_rcv_supply IS

371: --
372: -- HISTORY
373: -- P. Bamb 10-May-2005 Created
374: --=========================================================================== */
375: PROCEDURE update_rcv_supply IS
376:
377: CURSOR cr_get_supply IS
378: SELECT rs.rowid,
379: rs.quantity,

Line 394: FROM rcv_supply rs ,

390: rs.po_line_location_id ,
391: rs.shipment_header_id ,
392: rs.shipment_line_id ,
393: rs.rcv_transaction_id
394: FROM rcv_supply rs ,
395: mtl_system_items_b msi,
396: mtl_parameters mp
397: WHERE nvl(rs.quantity,0) <> 0
398: AND rs.secondary_quantity is null

Line 407: rcv_supply_data_err EXCEPTION;

403: AND mp.process_enabled_flag = 'Y';
404:
405: l_secondary_unit_of_measure VARCHAR2(25);
406: l_secondary_quantity NUMBER;
407: rcv_supply_data_err EXCEPTION;
408:
409: cr_rec cr_get_supply%ROWTYPE;
410: l_errm VARCHAR2(2000);
411:

Line 433: raise rcv_supply_data_err;

429: to_unit => NULL,
430: from_name => cr_rec.unit_of_measure ,
431: to_name => l_secondary_unit_of_measure ); --Bug# 5584581
432: IF l_secondary_quantity <=0 THEN
433: raise rcv_supply_data_err;
434: End If;
435:
436: UPDATE rcv_supply
437: SET secondary_quantity = l_secondary_quantity,

Line 436: UPDATE rcv_supply

432: IF l_secondary_quantity <=0 THEN
433: raise rcv_supply_data_err;
434: End If;
435:
436: UPDATE rcv_supply
437: SET secondary_quantity = l_secondary_quantity,
438: secondary_unit_of_measure = l_secondary_unit_of_measure
439: WHERE rowid = cr_rec.rowid;
440:

Line 442: WHEN rcv_supply_data_err Then

438: secondary_unit_of_measure = l_secondary_unit_of_measure
439: WHERE rowid = cr_rec.rowid;
440:
441: EXCEPTION
442: WHEN rcv_supply_data_err Then
443: insert into gml_po_mig_errors
444: (migration_type,po_header_id,po_line_id,line_location_id,
445: transaction_id, shipment_header_id,shipment_line_id,
446: column_name,table_name,error_message,

Line 450: 'SECONDARY_QUANTITY','RCV_SUPPLY',

446: column_name,table_name,error_message,
447: creation_date,last_update_date)
448: values ('CONVERGENCE',cr_rec.po_header_id,cr_rec.po_line_id,cr_rec.po_line_location_id,
449: cr_rec.rcv_transaction_id, cr_rec.shipment_header_id, cr_rec.shipment_line_id,
450: 'SECONDARY_QUANTITY','RCV_SUPPLY',
451: 'ERROR DERIVING SECONDARY_QUANTITY FROM QUANTITY',sysdate,sysdate);
452: WHEN OTHERS Then
453: l_errm := sqlerrm;
454: insert into gml_po_mig_errors

Line 461: 'SECONDARY_QUANTITY','RCV_SUPPLY',

457: column_name,table_name,error_message,
458: creation_date,last_update_date)
459: values ('CONVERGENCE',cr_rec.po_header_id,cr_rec.po_line_id,cr_rec.po_line_location_id,
460: cr_rec.rcv_transaction_id, cr_rec.shipment_header_id, cr_rec.shipment_line_id,
461: 'SECONDARY_QUANTITY','RCV_SUPPLY',
462: 'WHEN OTHERS IN DERIVING SECONDARY_QUANTITY FROM QUANTITY-'||substr(l_errm,1,1925),sysdate,sysdate);
463: END;
464: END LOOP;
465: Commit;

Line 467: END Update_rcv_supply;

463: END;
464: END LOOP;
465: Commit;
466:
467: END Update_rcv_supply;
468:
469: /*===========================================================================
470: -- PROCEDURE:
471: -- update_rcv_lots_supply