APPS.ORACLEON dependencies on DUAL

Line 107: select substr(l_message,12,512) into l_err_mesg from dual;

103: exception
104: when others then
105: l_err_num := SQLCODE;
106: l_message := SQLERRM;
107: select substr(l_message,12,512) into l_err_mesg from dual;
108: if (abs(l_err_num) between 1800 and 1899)
109: then
110: fnd_message.set_name('ICX','ICX_USE_DATE_FORMAT');
111: l_web_user_date_format := icx_sec.getID(icx_sec.pv_date_format);

Line 145: select substr(l_message,12,512) into l_l_err_mesg from dual;

141: exception
142: when others then
143: l_l_err_num := SQLCODE;
144: l_message := SQLERRM;
145: select substr(l_message,12,512) into l_l_err_mesg from dual;
146: icx_util.add_error(l_l_err_mesg);
147: icx_admin_sig.error_screen(l_l_err_mesg);
148: end;
149:

Line 183: select substr(l_message,12,512) into l_l_err_mesg from dual;

179: exception
180: when others then
181: l_l_err_num := SQLCODE;
182: l_message := SQLERRM;
183: select substr(l_message,12,512) into l_l_err_mesg from dual;
184: icx_util.add_error(l_l_err_mesg);
185: icx_admin_sig.error_screen(l_l_err_mesg);
186: end;
187:

Line 235: select substr(l_message,12,512) into l_l_err_mesg from dual;

231: exception
232: when others then
233: l_l_err_num := SQLCODE;
234: l_message := SQLERRM;
235: select substr(l_message,12,512) into l_l_err_mesg from dual;
236: icx_util.add_error(l_l_err_mesg);
237: icx_admin_sig.error_screen(l_l_err_mesg);
238: end;
239: