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.GML_PO_SYNCH dependencies on PO_BPOS_DTL

Line 2447: UPDATE po_bpos_dtl

2443: raise_application_error(-20001, err_msg);
2444: END;
2445:
2446: BEGIN
2447: UPDATE po_bpos_dtl
2448: SET amount_purchased = nvl(amount_purchased,0) + nvl(int_rec.extended_price,0),
2449: qty_purchased = nvl(qty_purchased,0) + nvl(int_rec.order_qty1,0),
2450: last_update_date = nvl(int_rec.last_update_date, SYSDATE),
2451: last_updated_by = nvl(int_rec.last_updated_by, 0),

Line 2458: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error updating po_bpos_dtl');

2454: AND line_id = v_bpo_line_id;
2455: EXCEPTION
2456: WHEN OTHERS THEN
2457: FND_FILE.NEW_LINE(FND_FILE.LOG, 1 );
2458: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error updating po_bpos_dtl');
2459: FND_FILE.NEW_LINE(FND_FILE.LOG, 1 );
2460: err_num := SQLCODE;
2461: err_msg := SUBSTRB (SQLERRM, 1, 100);
2462: FND_FILE.PUT_LINE(FND_FILE.LOG, err_msg);

Line 2952: UPDATE po_bpos_dtl

2948: raise_application_error(-20001, err_msg);
2949: END;
2950:
2951: BEGIN
2952: UPDATE po_bpos_dtl
2953: SET amount_purchased = amount_purchased -
2954: nvl(int_rec.extended_price,0),
2955: qty_purchased = qty_purchased -
2956: nvl(int_rec.order_qty1,0),

Line 2965: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error updating po_bpos_dtl');

2961: AND line_id = v_bpo_line_id; /* Bug 1854280 Pushkar Upakare */
2962: EXCEPTION
2963: WHEN OTHERS THEN
2964: FND_FILE.NEW_LINE(FND_FILE.LOG, 1 );
2965: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error updating po_bpos_dtl');
2966: FND_FILE.NEW_LINE(FND_FILE.LOG, 1 );
2967: err_num := SQLCODE;
2968: err_msg := SUBSTRB (SQLERRM, 1, 100);
2969: FND_FILE.PUT_LINE(FND_FILE.LOG, err_msg);

Line 3395: UPDATE po_bpos_dtl

3391:
3392: /* T. Ricci 11/10/98 removed trans_cnt = trans_cnt + 1 from update*/
3393:
3394: BEGIN
3395: UPDATE po_bpos_dtl
3396: SET amount_purchased =
3397: amount_purchased - nvl(v_old_extended_price,0) +
3398: nvl(int_rec.extended_price,0),
3399: qty_purchased =

Line 3410: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error updating po_bpos_dtl');

3406: AND line_id = v_bpo_line_id; /* Bug 1854280 Pushkar Upakare */
3407: EXCEPTION
3408: WHEN OTHERS THEN
3409: FND_FILE.NEW_LINE(FND_FILE.LOG, 1 );
3410: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error updating po_bpos_dtl');
3411: FND_FILE.NEW_LINE(FND_FILE.LOG, 1 );
3412: err_num := SQLCODE;
3413: err_msg := SUBSTRB (SQLERRM, 1, 100);
3414: FND_FILE.PUT_LINE(FND_FILE.LOG, err_msg);