APPS.ICX_REQ_SUBMIT dependencies on DUAL

Line 18: select icx_req_cart_errors_s.nextval into l_error_id from dual;

14: begin
15:
16: l_shopper_id := icx_sec.getID(icx_sec.PV_WEB_USER_ID);
17:
18: select icx_req_cart_errors_s.nextval into l_error_id from dual;
19:
20: /* append new message to the error table for redisplay */
21: insert into icx_req_cart_errors
22: (error_id,cart_id,distribution_num,cart_line_id,last_updated_by,last_update_date,last_update_login,creation_date,created_by,error_text)

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

27: when others then
28: l_err_num := SQLCODE;
29: l_error_message := SQLERRM;
30:
31: select substr(l_error_message,12,512) into l_err_mesg from dual;
32: icx_util.add_error(l_err_mesg);
33: end;
34:
35:

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

2271: exception
2272: WHEN OTHERS THEN
2273: l_err_num := SQLCODE;
2274: l_error_message := SQLERRM;
2275: select substr(l_error_message,12,512) into l_err_mesg from dual;
2276: icx_util.add_error(l_err_mesg);
2277: storeerror(v_cart_id,l_err_mesg);
2278: l_err_loadinterface := 'Y';
2279:

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

2370: become_top(icx_cart_id, emergency, 'CE');
2371: when OTHERS then
2372: l_err_num := SQLCODE;
2373: l_error_message := SQLERRM;
2374: select substr(l_error_message,12,512) into l_err_mesg from dual;
2375: icx_util.add_error(l_err_mesg);
2376: storeerror(v_cart_id,l_err_mesg);
2377: icx_util.error_page_print;
2378: return;