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

242:
243:
244: /*===========================================================================
245: -- PROCEDURE:
246: -- update_rcv_supply
247: --
248: -- DESCRIPTION:
249: -- This PL/SQL procedure is used to Update RCV_SUPPLY for secondary_quantity
250: -- and secondary_unit_of_measure

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

245: -- PROCEDURE:
246: -- update_rcv_supply
247: --
248: -- DESCRIPTION:
249: -- This PL/SQL procedure is used to Update RCV_SUPPLY for secondary_quantity
250: -- and secondary_unit_of_measure
251: --
252: -- PARAMETERS:
253: -- None

Line 256: -- update_rcv_supply;

252: -- PARAMETERS:
253: -- None
254: --
255: -- SYNOPSIS:
256: -- update_rcv_supply;
257: --
258: -- HISTORY
259: -- P. Bamb 10-May-2005 Created
260: --=========================================================================== */

Line 261: PROCEDURE update_rcv_supply IS

257: --
258: -- HISTORY
259: -- P. Bamb 10-May-2005 Created
260: --=========================================================================== */
261: PROCEDURE update_rcv_supply IS
262:
263: CURSOR cr_get_supply IS
264: SELECT rs.rowid,
265: rs.quantity,

Line 280: FROM rcv_supply rs ,

276: rs.po_line_location_id ,
277: rs.shipment_header_id ,
278: rs.shipment_line_id ,
279: rs.rcv_transaction_id
280: FROM rcv_supply rs ,
281: mtl_system_items_b msi,
282: mtl_parameters mp
283: WHERE nvl(rs.quantity,0) <> 0
284: AND rs.secondary_quantity is null

Line 293: rcv_supply_data_err EXCEPTION;

289: AND mp.process_enabled_flag = 'Y';
290:
291: l_secondary_unit_of_measure VARCHAR2(25);
292: l_secondary_quantity NUMBER;
293: rcv_supply_data_err EXCEPTION;
294:
295: cr_rec cr_get_supply%ROWTYPE;
296: l_errm VARCHAR2(2000);
297:

Line 319: raise rcv_supply_data_err;

315: to_unit => NULL,
316: from_name => cr_rec.unit_of_measure ,
317: to_name => l_secondary_unit_of_measure ); --Bug# 5584581
318: IF l_secondary_quantity <=0 THEN
319: raise rcv_supply_data_err;
320: End If;
321:
322: UPDATE rcv_supply
323: SET secondary_quantity = l_secondary_quantity,

Line 322: UPDATE rcv_supply

318: IF l_secondary_quantity <=0 THEN
319: raise rcv_supply_data_err;
320: End If;
321:
322: UPDATE rcv_supply
323: SET secondary_quantity = l_secondary_quantity,
324: secondary_unit_of_measure = l_secondary_unit_of_measure
325: WHERE rowid = cr_rec.rowid;
326:

Line 328: WHEN rcv_supply_data_err Then

324: secondary_unit_of_measure = l_secondary_unit_of_measure
325: WHERE rowid = cr_rec.rowid;
326:
327: EXCEPTION
328: WHEN rcv_supply_data_err Then
329: insert into gml_po_mig_errors
330: (migration_type,po_header_id,po_line_id,line_location_id,
331: transaction_id, shipment_header_id,shipment_line_id,
332: column_name,table_name,error_message,

Line 336: 'SECONDARY_QUANTITY','RCV_SUPPLY',

332: column_name,table_name,error_message,
333: creation_date,last_update_date)
334: values ('CONVERGENCE',cr_rec.po_header_id,cr_rec.po_line_id,cr_rec.po_line_location_id,
335: cr_rec.rcv_transaction_id, cr_rec.shipment_header_id, cr_rec.shipment_line_id,
336: 'SECONDARY_QUANTITY','RCV_SUPPLY',
337: 'ERROR DERIVING SECONDARY_QUANTITY FROM QUANTITY',sysdate,sysdate);
338: WHEN OTHERS Then
339: l_errm := sqlerrm;
340: insert into gml_po_mig_errors

Line 347: 'SECONDARY_QUANTITY','RCV_SUPPLY',

343: column_name,table_name,error_message,
344: creation_date,last_update_date)
345: values ('CONVERGENCE',cr_rec.po_header_id,cr_rec.po_line_id,cr_rec.po_line_location_id,
346: cr_rec.rcv_transaction_id, cr_rec.shipment_header_id, cr_rec.shipment_line_id,
347: 'SECONDARY_QUANTITY','RCV_SUPPLY',
348: 'WHEN OTHERS IN DERIVING SECONDARY_QUANTITY FROM QUANTITY-'||substr(l_errm,1,1925),sysdate,sysdate);
349: END;
350: END LOOP;
351: Commit;

Line 353: END Update_rcv_supply;

349: END;
350: END LOOP;
351: Commit;
352:
353: END Update_rcv_supply;
354:
355: /*===========================================================================
356: -- PROCEDURE:
357: -- update_rcv_lots_supply