[Home] [Help]
253: | standard uom conversion |
254: | 28-JAN-99 T.Ricci check dualum_ind before calling |
255: | GMICUOM.icuomcv and remove nvl on |
256: | item_um2 before insert to |
257: | po_rels_schBUG#809339 |
258: | 15-MAY-2001 PKU Bug 1776328 - Contract dates for BPO|
259: | are same on OPM and APPS side |
260: | 04-JUN-2001 PKU Bug 1811587 - Contract dates for BPO|
261: | are same on OPM after update on |
743:
744: /* T.Ricci 5/12/98 removed user_class and added new who columns*/
745:
746: BEGIN
747: INSERT INTO po_rels_sch
748: (
749: bpoline_id,
750: agreed_dlvdate,
751: line_status,
798: );
799: EXCEPTION
800: WHEN OTHERS THEN
801: FND_FILE.NEW_LINE(FND_FILE.LOG, 1 );
802: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error inserting into po_rels_sch');
803: FND_FILE.NEW_LINE(FND_FILE.LOG, 1 );
804: err_num := SQLCODE;
805: err_msg := SUBSTRB (SQLERRM, 1, 100);
806: FND_FILE.PUT_LINE(FND_FILE.LOG, err_msg);
932: raise_application_error(-20001, err_msg);
933: END;
934:
935: BEGIN
936: UPDATE po_rels_sch
937: SET agreed_dlvdate = nvl(int_rec.agreed_dlvdate, sysdate),
938: line_status = 1, /*line_status,*/
939: order_qty1 = nvl(int_rec.order_qty1,0),
940: order_qty2 = nvl(v_order2, 0),
957: WHERE bpoline_id = v_bpo_line_id;
958: EXCEPTION
959: WHEN OTHERS THEN
960: FND_FILE.NEW_LINE(FND_FILE.LOG, 1 );
961: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error updating po_rels_sch');
962: FND_FILE.NEW_LINE(FND_FILE.LOG, 1 );
963: err_num := SQLCODE;
964: err_msg := SUBSTRB (SQLERRM, 1, 100);
965: FND_FILE.PUT_LINE(FND_FILE.LOG, err_msg);