APPS.ICX_PO_REQ_ACCT2 dependencies on DUAL

Line 304: from sys.dual;

300: close set_of_books;
301:
302: -- bug 689962
303: select po_req_distributions_s.nextval into v_distribution_id
304: from sys.dual;
305: -- end
306:
307: -- Insert the new column in po_req_distribution
308: INSERT INTO po_req_distributions (distribution_id,

Line 407: select substr(l_error_message,12,512) into l_err_mesg from dual;

403: FND_MESSAGE.SET_NAME('ICX','ICX_LINE_NUMBER');
404: FND_MESSAGE.SET_TOKEN('LINE_NUM_TOKEN',l_req_line_number);
405: l_err_num := SQLCODE;
406: l_error_message := SQLERRM;
407: select substr(l_error_message,12,512) into l_err_mesg from dual;
408: l_err_mesg := FND_MESSAGE.GET || ': ' || l_err_mesg;
409: FND_MESSAGE.SET_NAME('PO','PO_ZMVOR_DISTRIBUTION');
410: l_err_mesg := '(' || FND_MESSAGE.GET || ' ' || l_dist_num || ') ' || l_err_mesg;
411: icx_util.add_error(l_err_mesg);

Line 600: select substr(l_error_message,12,512) into l_err_mesg from dual;

596: l_err_num := SQLCODE;
597: l_error_message := SQLERRM;
598: FND_MESSAGE.SET_NAME('ICX','ICX_LINE_NUMBER');
599: FND_MESSAGE.SET_TOKEN('LINE_NUM_TOKEN',l_cart_line_number);
600: select substr(l_error_message,12,512) into l_err_mesg from dual;
601: l_err_mesg := FND_MESSAGE.GET || ': ' || l_err_mesg;
602: FND_MESSAGE.SET_NAME('PO','PO_ZMVOR_DISTRIBUTION');
603: l_err_mesg := '(' || FND_MESSAGE.GET || ' ' || v_line_number || ') ' || l_err_mesg;
604: icx_util.add_error(l_err_mesg);