247: last_update_login, creation_date,created_by,org_id,cart_id';
248:
249:
250:
251: select icx_cart_line_distributions_s.nextval into v_distribution_id from sys.dual;
252:
253: /* code was commented out to take care of Bind vars logic ***/
254:
255:
348: FND_MESSAGE.SET_NAME('ICX','ICX_LINE_NUMBER');
349: FND_MESSAGE.SET_TOKEN('LINE_NUM_TOKEN',l_cart_line_number);
350: l_err_num := SQLCODE;
351: l_error_message := SQLERRM;
352: select substr(l_error_message,12,512) into l_err_mesg from dual;
353: l_err_mesg := FND_MESSAGE.GET || ': ' || l_err_mesg;
354: FND_MESSAGE.SET_NAME('PO','PO_ZMVOR_DISTRIBUTION');
355: l_err_mesg := '(' || FND_MESSAGE.GET || ' ' || l_dist_num || ') ' || l_err_mesg;
356: icx_util.add_error(l_err_mesg);
548: l_err_num := SQLCODE;
549: l_error_message := SQLERRM;
550: FND_MESSAGE.SET_NAME('ICX','ICX_LINE_NUMBER');
551: FND_MESSAGE.SET_TOKEN('LINE_NUM_TOKEN',l_cart_line_number);
552: select substr(l_error_message,12,512) into l_err_mesg from dual;
553: l_err_mesg := FND_MESSAGE.GET || ': ' || l_err_mesg;
554: FND_MESSAGE.SET_NAME('PO','PO_ZMVOR_DISTRIBUTION');
555: l_err_mesg := '(' || FND_MESSAGE.GET || ' ' || v_line_number || ') ' || l_err_mesg;
556: icx_util.add_error(l_err_mesg);