[Home] [Help]
2422: /* BEGIN - Bug 1854280 Pushkar Upakare */
2423: IF int_rec.transaction_type = 'PLANNED' THEN
2424:
2425: BEGIN
2426: UPDATE po_bpos_hdr
2427: SET amount_purchased = nvl(amount_purchased,0) + nvl(int_rec.extended_price,0),
2428: activity_ind = 1,
2429: rel_count = nvl(rel_count,0) + 1,
2430: last_update_date = nvl(int_rec.last_update_date, SYSDATE),
2433: WHERE bpo_id = v_bpo_id;
2434: EXCEPTION
2435: WHEN OTHERS THEN
2436: FND_FILE.NEW_LINE(FND_FILE.LOG, 1 );
2437: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error updating po_bpos_hdr');
2438: FND_FILE.NEW_LINE(FND_FILE.LOG, 1 );
2439: err_num := SQLCODE;
2440: err_msg := SUBSTRB (SQLERRM, 1, 100);
2441: FND_FILE.PUT_LINE(FND_FILE.LOG, err_msg);
2926: IF int_rec.transaction_type = 'PLANNED' THEN
2927: IF int_rec.cancellation_code IS NOT NULL THEN /* Cancel*/
2928:
2929: BEGIN
2930: UPDATE po_bpos_hdr
2931: SET amount_purchased = amount_purchased -
2932: nvl(int_rec.extended_price,0),
2933: activity_ind = 1,
2934: rel_count = rel_count + 1,
2938: WHERE bpo_id = v_bpo_id;
2939: EXCEPTION
2940: WHEN OTHERS THEN
2941: FND_FILE.NEW_LINE(FND_FILE.LOG, 1 );
2942: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error updating po_bpos_hdr');
2943: FND_FILE.NEW_LINE(FND_FILE.LOG, 1 );
2944: err_num := SQLCODE;
2945: err_msg := SUBSTRB (SQLERRM, 1, 100);
2946: FND_FILE.PUT_LINE(FND_FILE.LOG, err_msg);
3366:
3367: IF int_rec.transaction_type = 'PLANNED' THEN
3368:
3369: BEGIN
3370: UPDATE po_bpos_hdr
3371: SET amount_purchased =
3372: amount_purchased - nvl(v_old_extended_price,0) +
3373: nvl(int_rec.extended_price,0),
3374: activity_ind = 1,
3379: WHERE bpo_id = v_bpo_id;
3380: EXCEPTION
3381: WHEN OTHERS THEN
3382: FND_FILE.NEW_LINE(FND_FILE.LOG, 1 );
3383: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error updating po_bpos_hdr');
3384: FND_FILE.NEW_LINE(FND_FILE.LOG, 1 );
3385: err_num := SQLCODE;
3386: err_msg := SUBSTRB (SQLERRM, 1, 100);
3387: FND_FILE.PUT_LINE(FND_FILE.LOG, err_msg);