APPS.ICX_REQ_UPDATE_SAVED_CARTS dependencies on ICX_UTIL

Line 53: c_prompts icx_util.g_prompts_table;

49:
50: sess_web_user number(15);
51: c_language varchar2(30);
52: c_title varchar2(80);
53: c_prompts icx_util.g_prompts_table;
54: where_clause varchar2(2000);
55: total_rows number;
56: end_row number;
57: c_query_size number;

Line 62: y_table icx_util.char240_table;

58: i number := 0;
59: r number := 0;
60: display_text varchar2(240);
61: condensed_params varchar2(20);
62: y_table icx_util.char240_table;
63: l_encrypted_where number;
64: g_reg_ind number;
65: c_message varchar2(2000);
66: err_num number;

Line 85: icx_util.getPrompts(601,'ICX_SAVED_CARTS_R',c_title,c_prompts);

81:
82: sess_web_user := icx_sec.getID(icx_sec.PV_WEB_USER_ID);
83: c_language := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
84:
85: icx_util.getPrompts(601,'ICX_SAVED_CARTS_R',c_title,c_prompts);
86: icx_util.error_page_setup;
87:
88: htp.htmlOpen;
89: htp.headOpen;

Line 86: icx_util.error_page_setup;

82: sess_web_user := icx_sec.getID(icx_sec.PV_WEB_USER_ID);
83: c_language := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
84:
85: icx_util.getPrompts(601,'ICX_SAVED_CARTS_R',c_title,c_prompts);
86: icx_util.error_page_setup;
87:
88: htp.htmlOpen;
89: htp.headOpen;
90: icx_util.copyright;

Line 90: icx_util.copyright;

86: icx_util.error_page_setup;
87:
88: htp.htmlOpen;
89: htp.headOpen;
90: icx_util.copyright;
91: js.scriptOpen;
92: htp.p('function help_window() {
93: help_win = window.open(''/OA_DOC/' || c_language || '/awe' || '/icxhlprq.htm'', "help_win","resizable=yes,scrollbars=yes,toolbar=yes,width=450,height=250");
94: help_win = window.open(''/OA_DOC/' || c_language || '/awe' || '/icxhlprq.htm'', "help_win","resizable=yes,scrollbars=yes,toolbar=yes,width=450,height=250")} ');

Line 229: htp.p('');

225: fnd_message.set_token('NAME_OF_REGION_TOKEN',c_title);
226: htp.p('

'||fnd_message.get||'

Line 253: icx_util.transfer_Row_To_Column(ak_query_pkg.g_results_table(r),y_table);

249: htp.tableRowClose;
250: for r in ak_query_pkg.g_results_table.FIRST..ak_query_pkg.g_results_table.LAST loop
251: -- if r >= p_start_row-1 and r <= end_row-1
252: -- then
253: icx_util.transfer_Row_To_Column(ak_query_pkg.g_results_table(r),y_table);
254: htp.tableRowOpen;
255: for i in ak_query_pkg.g_items_table.FIRST..ak_query_pkg.g_items_table.LAST loop
256: if ak_query_pkg.g_items_table(i).secured_column = 'F'
257: and ak_query_pkg.g_items_table(i).node_display_flag = 'Y'

Line 302: htp.tableData(htf.anchor('javascript:delete_saved_cart('''||icx_util.replace_quotes(FND_MESSAGE.GET) ||''','''||condensed_params||''')',

298: FND_MESSAGE.SET_NAME('ICX', 'ICX_DELETE_OBJECT');
299: FND_MESSAGE.SET_TOKEN('OBJECT_TO_DELETE_TOKEN', y_table(l_cart_name_value_id));
300:
301:
302: htp.tableData(htf.anchor('javascript:delete_saved_cart('''||icx_util.replace_quotes(FND_MESSAGE.GET) ||''','''||condensed_params||''')',
303: htf.img('/OA_MEDIA/'||c_language||'/FNDIDELR.gif','CENTER','','','border=no width=17 height=16'),'','onMouseOver="return true"'));
304:
305: else
306: if ak_query_pkg.g_items_table(i).value_id is null then

Line 340: icx_util.add_error(err_mesg);

336: when others then
337: err_num := SQLCODE;
338: c_message := SQLERRM;
339: select substr(c_message,12,512) into err_mesg from dual;
340: icx_util.add_error(err_mesg);
341: icx_admin_sig.error_screen(err_mesg);
342: end displaySavedCarts;
343:
344: