74: -- v_url_req := fnd_message.get;
75: fnd_message.set_name('ICX', 'ICX_WEB_EMAIL_REQUIRED');
76: v_email_req := fnd_message.get;
77:
78: htp.htmlOpen;
79: -- show copyright in source
80: icx_util.copyright;
81: htp.headOpen;
82: htp.title(v_title);
77:
78: htp.htmlOpen;
79: -- show copyright in source
80: icx_util.copyright;
81: htp.headOpen;
82: htp.title(v_title);
83: htp.p('');
126: htp.headClose;
127:
128: -- Display logo, toolbar
121: document.define_param.WebEmail.value = document.define_param.WebEmail.defaultValue;
122: } ');
123:
124: htp.p('// done hiding from old browsers -->');
125: htp.p('');
126: htp.headClose;
127:
128: -- Display logo, toolbar
129:
122: } ');
123:
124: htp.p('// done hiding from old browsers -->');
125: htp.p('');
126: htp.headClose;
127:
128: -- Display logo, toolbar
129:
130: icx_admin_sig.toolbar(v_language);
128: -- Display logo, toolbar
129:
130: icx_admin_sig.toolbar(v_language);
131:
132: htp.header(2, v_title);
133: htp.para;
134: htp.formOpen('icx_setup.update_parameters', 'POST', '','', 'NAME="define_param" ');
135: htp.tableOpen;
136: htp.tableRowOpen;
129:
130: icx_admin_sig.toolbar(v_language);
131:
132: htp.header(2, v_title);
133: htp.para;
134: htp.formOpen('icx_setup.update_parameters', 'POST', '','', 'NAME="define_param" ');
135: htp.tableOpen;
136: htp.tableRowOpen;
137: htp.tableData(v_lines_page, 'RIGHT');
130: icx_admin_sig.toolbar(v_language);
131:
132: htp.header(2, v_title);
133: htp.para;
134: htp.formOpen('icx_setup.update_parameters', 'POST', '','', 'NAME="define_param" ');
135: htp.tableOpen;
136: htp.tableRowOpen;
137: htp.tableData(v_lines_page, 'RIGHT');
138: htp.tableData(htf.formText('QuerySet', 10, 10, v_query_set));
131:
132: htp.header(2, v_title);
133: htp.para;
134: htp.formOpen('icx_setup.update_parameters', 'POST', '','', 'NAME="define_param" ');
135: htp.tableOpen;
136: htp.tableRowOpen;
137: htp.tableData(v_lines_page, 'RIGHT');
138: htp.tableData(htf.formText('QuerySet', 10, 10, v_query_set));
139: htp.tableRowClose;
132: htp.header(2, v_title);
133: htp.para;
134: htp.formOpen('icx_setup.update_parameters', 'POST', '','', 'NAME="define_param" ');
135: htp.tableOpen;
136: htp.tableRowOpen;
137: htp.tableData(v_lines_page, 'RIGHT');
138: htp.tableData(htf.formText('QuerySet', 10, 10, v_query_set));
139: htp.tableRowClose;
140:
133: htp.para;
134: htp.formOpen('icx_setup.update_parameters', 'POST', '','', 'NAME="define_param" ');
135: htp.tableOpen;
136: htp.tableRowOpen;
137: htp.tableData(v_lines_page, 'RIGHT');
138: htp.tableData(htf.formText('QuerySet', 10, 10, v_query_set));
139: htp.tableRowClose;
140:
141: htp.tableRowOpen;
134: htp.formOpen('icx_setup.update_parameters', 'POST', '','', 'NAME="define_param" ');
135: htp.tableOpen;
136: htp.tableRowOpen;
137: htp.tableData(v_lines_page, 'RIGHT');
138: htp.tableData(htf.formText('QuerySet', 10, 10, v_query_set));
139: htp.tableRowClose;
140:
141: htp.tableRowOpen;
142: htp.tableData(v_max_rows_returned, 'RIGHT');
135: htp.tableOpen;
136: htp.tableRowOpen;
137: htp.tableData(v_lines_page, 'RIGHT');
138: htp.tableData(htf.formText('QuerySet', 10, 10, v_query_set));
139: htp.tableRowClose;
140:
141: htp.tableRowOpen;
142: htp.tableData(v_max_rows_returned, 'RIGHT');
143: htp.tableData(htf.formText('MaxRows', 10, 10, v_max_rows));
137: htp.tableData(v_lines_page, 'RIGHT');
138: htp.tableData(htf.formText('QuerySet', 10, 10, v_query_set));
139: htp.tableRowClose;
140:
141: htp.tableRowOpen;
142: htp.tableData(v_max_rows_returned, 'RIGHT');
143: htp.tableData(htf.formText('MaxRows', 10, 10, v_max_rows));
144: htp.tableRowClose;
145:
138: htp.tableData(htf.formText('QuerySet', 10, 10, v_query_set));
139: htp.tableRowClose;
140:
141: htp.tableRowOpen;
142: htp.tableData(v_max_rows_returned, 'RIGHT');
143: htp.tableData(htf.formText('MaxRows', 10, 10, v_max_rows));
144: htp.tableRowClose;
145:
146: htp.tableRowOpen;
139: htp.tableRowClose;
140:
141: htp.tableRowOpen;
142: htp.tableData(v_max_rows_returned, 'RIGHT');
143: htp.tableData(htf.formText('MaxRows', 10, 10, v_max_rows));
144: htp.tableRowClose;
145:
146: htp.tableRowOpen;
147: htp.tableData(v_start_url, 'RIGHT');
140:
141: htp.tableRowOpen;
142: htp.tableData(v_max_rows_returned, 'RIGHT');
143: htp.tableData(htf.formText('MaxRows', 10, 10, v_max_rows));
144: htp.tableRowClose;
145:
146: htp.tableRowOpen;
147: htp.tableData(v_start_url, 'RIGHT');
148: htp.tableData(htf.formText('HomeUrl', 45, 240, icx_util.replace_alt_quotes(v_home_url)));
142: htp.tableData(v_max_rows_returned, 'RIGHT');
143: htp.tableData(htf.formText('MaxRows', 10, 10, v_max_rows));
144: htp.tableRowClose;
145:
146: htp.tableRowOpen;
147: htp.tableData(v_start_url, 'RIGHT');
148: htp.tableData(htf.formText('HomeUrl', 45, 240, icx_util.replace_alt_quotes(v_home_url)));
149: htp.tableRowClose;
150:
143: htp.tableData(htf.formText('MaxRows', 10, 10, v_max_rows));
144: htp.tableRowClose;
145:
146: htp.tableRowOpen;
147: htp.tableData(v_start_url, 'RIGHT');
148: htp.tableData(htf.formText('HomeUrl', 45, 240, icx_util.replace_alt_quotes(v_home_url)));
149: htp.tableRowClose;
150:
151: htp.tableRowOpen;
144: htp.tableRowClose;
145:
146: htp.tableRowOpen;
147: htp.tableData(v_start_url, 'RIGHT');
148: htp.tableData(htf.formText('HomeUrl', 45, 240, icx_util.replace_alt_quotes(v_home_url)));
149: htp.tableRowClose;
150:
151: htp.tableRowOpen;
152: htp.tableData(v_web_email, 'RIGHT');
145:
146: htp.tableRowOpen;
147: htp.tableData(v_start_url, 'RIGHT');
148: htp.tableData(htf.formText('HomeUrl', 45, 240, icx_util.replace_alt_quotes(v_home_url)));
149: htp.tableRowClose;
150:
151: htp.tableRowOpen;
152: htp.tableData(v_web_email, 'RIGHT');
153: htp.tableData(htf.formText('WebEmail', 45, 80, icx_util.replace_alt_quotes(v_webmaster_email)));
147: htp.tableData(v_start_url, 'RIGHT');
148: htp.tableData(htf.formText('HomeUrl', 45, 240, icx_util.replace_alt_quotes(v_home_url)));
149: htp.tableRowClose;
150:
151: htp.tableRowOpen;
152: htp.tableData(v_web_email, 'RIGHT');
153: htp.tableData(htf.formText('WebEmail', 45, 80, icx_util.replace_alt_quotes(v_webmaster_email)));
154: htp.tableRowClose;
155:
148: htp.tableData(htf.formText('HomeUrl', 45, 240, icx_util.replace_alt_quotes(v_home_url)));
149: htp.tableRowClose;
150:
151: htp.tableRowOpen;
152: htp.tableData(v_web_email, 'RIGHT');
153: htp.tableData(htf.formText('WebEmail', 45, 80, icx_util.replace_alt_quotes(v_webmaster_email)));
154: htp.tableRowClose;
155:
156: htp.tableClose;
149: htp.tableRowClose;
150:
151: htp.tableRowOpen;
152: htp.tableData(v_web_email, 'RIGHT');
153: htp.tableData(htf.formText('WebEmail', 45, 80, icx_util.replace_alt_quotes(v_webmaster_email)));
154: htp.tableRowClose;
155:
156: htp.tableClose;
157: -- keep the web user id in a hidden field for last_updated_by
150:
151: htp.tableRowOpen;
152: htp.tableData(v_web_email, 'RIGHT');
153: htp.tableData(htf.formText('WebEmail', 45, 80, icx_util.replace_alt_quotes(v_webmaster_email)));
154: htp.tableRowClose;
155:
156: htp.tableClose;
157: -- keep the web user id in a hidden field for last_updated_by
158: htp.formHidden('WebUser', icx_util.replace_alt_quotes(v_web_user));
152: htp.tableData(v_web_email, 'RIGHT');
153: htp.tableData(htf.formText('WebEmail', 45, 80, icx_util.replace_alt_quotes(v_webmaster_email)));
154: htp.tableRowClose;
155:
156: htp.tableClose;
157: -- keep the web user id in a hidden field for last_updated_by
158: htp.formHidden('WebUser', icx_util.replace_alt_quotes(v_web_user));
159:
160: htp.formClose;
154: htp.tableRowClose;
155:
156: htp.tableClose;
157: -- keep the web user id in a hidden field for last_updated_by
158: htp.formHidden('WebUser', icx_util.replace_alt_quotes(v_web_user));
159:
160: htp.formClose;
161:
162: l_save_url := 'javascript:update_param('''||icx_util.replace_onMouseOver_quotes(v_set_req)||''','''||icx_util.replace_onMouseOver_quotes(v_email_req)||''')';
156: htp.tableClose;
157: -- keep the web user id in a hidden field for last_updated_by
158: htp.formHidden('WebUser', icx_util.replace_alt_quotes(v_web_user));
159:
160: htp.formClose;
161:
162: l_save_url := 'javascript:update_param('''||icx_util.replace_onMouseOver_quotes(v_set_req)||''','''||icx_util.replace_onMouseOver_quotes(v_email_req)||''')';
163:
164: icx_util.DynamicButton(P_ButtonText => v_save_label,
167: P_HyperTextCall => l_save_url,
168: P_LanguageCode => v_language,
169: P_JavaScriptFlag => FALSE);
170:
171: htp.tableRowClose;
172: htp.tableClose;
173:
174: htp.bodyClose;
175: icx_sig.footer;
168: P_LanguageCode => v_language,
169: P_JavaScriptFlag => FALSE);
170:
171: htp.tableRowClose;
172: htp.tableClose;
173:
174: htp.bodyClose;
175: icx_sig.footer;
176: htp.htmlClose;
170:
171: htp.tableRowClose;
172: htp.tableClose;
173:
174: htp.bodyClose;
175: icx_sig.footer;
176: htp.htmlClose;
177:
178: end if;
172: htp.tableClose;
173:
174: htp.bodyClose;
175: icx_sig.footer;
176: htp.htmlClose;
177:
178: end if;
179:
180: exception
178: end if;
179:
180: exception
181: when OTHERS then
182: htp.p(sqlerrm);
183:
184: end get_parameters;
185:
186: PROCEDURE update_parameters(QuerySet in number,