153: from icx_pages
154: where user_id = icx_sec.g_user_id;
155: exception
156: when no_data_found then 157: htp.p(SQLERRM); 158: end;
159:
160: begin
161: select main_region_id
Line 167: htp.p(SQLERRM);
163: from icx_pages
164: where page_id = p_page_id;
165: exception
166: when no_data_found then 167: htp.p(SQLERRM); 168: end;
169:
170: select icx_pages_s.nextval
171: into l_to_page_id
Line 261: htp.p(SQLERRM);
257: where page_id = p_page_id;
258:
259: exception
260: when others then 261: htp.p(SQLERRM); 262: end;
263:
264:
265: -- ***********************************************
Line 314: htp.p(SQLERRM);
310: from icx_pages
311: where page_id = p_page_id;
312: exception
313: when no_data_found then 314: htp.p(SQLERRM); 315: end;
316:
317: begin
318: select page_id
Line 324: htp.p(SQLERRM);
320: from icx_sessions
321: where session_id = icx_sec.g_session_id;
322: exception
323: when no_data_found then 324: htp.p(SQLERRM); 325: end;
326:
327: deletePagePrivate(l_main_region_id); -- deletes all child regions
328:
Line 373: htp.p(SQLERRM);
369: where page_type = 'MAIN'
370: and user_id = icx_sec.g_user_id;
371: exception
372: when no_data_found then 373: htp.p(SQLERRM); 374: end;
375:
376: update icx_sessions
377: set page_id = l_main_page_id
Line 425: htp.p(SQLERRM);
421: from icx_sessions
422: where session_id = icx_sec.g_session_id;
423: exception
424: when no_data_found then 425: htp.p(SQLERRM); 426: end;
427: end if;
428:
429: begin
Line 437: htp.p(SQLERRM);
433: where page_id = l_page_id
434: and language = userenv('LANG');
435: exception
436: when no_data_found then 437: htp.p(SQLERRM); 438: end;
439:
440: fnd_message.set_name('ICX','ICX_LOGIN_CUSTOMIZE');
441: l_toolbar.title := fnd_message.get;
Line 463: htp.p(SQLERRM);
459: end if;
460:
461: exception
462: when others then 463: htp.p(SQLERRM); 464:
465: end Customize;
466:
467:
Line 490: htp.p(SQLERRM);
486: from icx_pages
487: where page_id = p_page_id;
488: exception
489: when NO_DATA_FOUND then 490: htp.p(SQLERRM); 491: end;
492:
493: l_agent := FND_WEB_CONFIG.WEB_SERVER || icx_plug_utilities.getPLSQLagent;
494:
563: end if;
564:
565: exception
566: when others then 567: htp.p(SQLERRM); 568: end displayCustomize;
569:
570:
571: ------------------------------------------------------------------------------
Line 599: htp.p('');
595: --select HSECS into start_time from V$TIMER;
596:
597: if icx_cabo.g_base_href is null
598: then 599: htp.p(''); 600: else
601: htp.p('');
602: end if;
603:
Line 601: htp.p('');
597: if icx_cabo.g_base_href is null
598: then
599: htp.p('');
600: else 601: htp.p(''); 602: end if;
603:
604:
605: htp.p('');
664:
665: end if;
666:
667: icx_admin_sig.help_win_script('ICXPHP', null, 'FND'); 668: htp.p(''); 669:
670: if p_mode = DISPLAY_PORTLETS then
671: htp.p('
');
672: else
Line 671: htp.p('');
667: icx_admin_sig.help_win_script('ICXPHP', null, 'FND');
668: htp.p('');
669:
670: if p_mode = DISPLAY_PORTLETS then 671: htp.p(''); 672: else
673: htp.p('
');
674: end if;
675:
Line 673: htp.p('');
669:
670: if p_mode = DISPLAY_PORTLETS then
671: htp.p('
');
672: else 673: htp.p(''); 674: end if;
675:
676: --insert into icx_testing values ('made it to render');
677: --commit;
Line 681: htp.formOpen(curl => 'XXX',
677: --commit;
678:
679: if p_mode = DISPLAY_PORTLETS then -- render page in plsql mode + draw form for kiosk mode
680: 681: htp.formOpen(curl => 'XXX', 682: cattributes => 'NAME="functionwindowfocus"');
683: htp.formHidden('X','FALSE');
684: htp.formClose;
685:
Line 683: htp.formHidden('X','FALSE');
679: if p_mode = DISPLAY_PORTLETS then -- render page in plsql mode + draw form for kiosk mode
680:
681: htp.formOpen(curl => 'XXX',
682: cattributes => 'NAME="functionwindowfocus"'); 683: htp.formHidden('X','FALSE'); 684: htp.formClose;
685:
686: update icx_sessions
687: set page_id = p_page_id
Line 705: --htp.p('Elapsed Time = '|| TO_CHAR(end_time - start_time));
701:
702: htp.p('');
703:
704: --select HSECS into end_time from V$TIMER; 705: --htp.p('Elapsed Time = '|| TO_CHAR(end_time - start_time)); 706:
707: end if;
708:
709: end render;
Line 778: htp.p('');
774:
775: --insert into icx_testing values ('rendering region id ' || to_char(p_region.region_id));
776: --insert into icx_testing values ('rendering region page id' || to_char(p_page_id));
777: 778: htp.p(''); 779:
780: -- REGION IS SPLIT HORIZONTALLY, SO DRAW ROWS FOR EACH CHILD
781: -- AND THEN CALL RENDERREGION FOR EACH CHILD
782: ------------------------------------------------------------
Line 797: htp.p('
');
799: for i in 1..l_region_list.count
800: loop
801: htp.p('
');
Line 801: htp.p('
');
797: htp.p('
');
799: for i in 1..l_region_list.count
800: loop 801: htp.p('
');
807: end if;
808:
809:
810: -- REGION IS SPLIT VERTICALLY, SO DRAW CELLS FOR EACH CHILD
Line 815: htp.p('
');
817: htp.tableRowOpen;
818: l_region_list := icx_api_region.get_child_region_list(p_region.region_id);
819: for i in 1..l_region_list.count
Line 817: htp.tableRowOpen;
813: elsif (p_region.split_mode = ICX_API_REGION.REGION_VERTICAL_SPLIT) then
814:
815: htp.p('
'); 817: htp.tableRowOpen; 818: l_region_list := icx_api_region.get_child_region_list(p_region.region_id);
819: for i in 1..l_region_list.count
820: loop
821: htp.p('
');
Line 821: htp.p('
');
817: htp.tableRowOpen;
818: l_region_list := icx_api_region.get_child_region_list(p_region.region_id);
819: for i in 1..l_region_list.count
820: loop 821: htp.p('
');
840: end if;
841: 842: htp.p('&'||'nbsp;'); 843:
844: -- the parameter p_mode for showconfigurelinks should be obsoleted.
845:
846: if (p_region.parent_region_id = ICX_API_REGION.MAIN_REGION) then
872: );
873:
874: exception
875: when others then 876: htp.p(SQLERRM); 877: end;
878: end loop;
879:
880: if (p_region.parent_region_id = ICX_API_REGION.MAIN_REGION) then
Line 881: htp.p('
');
877: end;
878: end loop;
879:
880: if (p_region.parent_region_id = ICX_API_REGION.MAIN_REGION) then 881: htp.p(''); 882: htp.p('
');
883: end if;
884:
885:
Line 882: htp.p('
');
878: end loop;
879:
880: if (p_region.parent_region_id = ICX_API_REGION.MAIN_REGION) then
881: htp.p('
'); 882: htp.p('
');
883: end if;
884:
885:
886: -- IF WE ARE DISPLAYING THE PORTLETS
Line 905: htp.p('
901: begin
902:
903: --select HSECS into l_start from V$TIMER;
904: 905: htp.p('
');
910:
911: --insert into icx_testing values ('v portlet name ====> ' || rec.portlet_name);
912:
Line 918: htp.p('
');
914: || rec.web_html_call
915: || '(:session_id, :plug_id, :display_name); end;'
916: using in icx_sec.g_session_id, in rec.plug_id, in rec.portlet_name;
917: 918: htp.p('
');
919:
920: htp.p('
');
921: htp.tableRowOpen;
922: htp.p('
');
916: using in icx_sec.g_session_id, in rec.plug_id, in rec.portlet_name;
917:
918: htp.p('
'); 924: htp.tableRowClose; 925: htp.tableClose;
926:
927: --select HSECS - l_start into l_start from V$TIMER;
928:
Line 925: htp.tableClose;
921: htp.tableRowOpen;
922: htp.p('
');
924: htp.tableRowClose; 925: htp.tableClose; 926:
927: --select HSECS - l_start into l_start from V$TIMER;
928:
929: --htp.p('Execution Time: '||to_char(l_start));
Line 929: --htp.p('Execution Time: '||to_char(l_start));
925: htp.tableClose;
926:
927: --select HSECS - l_start into l_start from V$TIMER;
928: 929: --htp.p('Execution Time: '||to_char(l_start)); 930:
931: exception
932: when others then
933: htp.p(SQLERRM);
Line 933: htp.p(SQLERRM);
929: --htp.p('Execution Time: '||to_char(l_start));
930:
931: exception
932: when others then 933: htp.p(SQLERRM); 934: end;
935: end loop;
936:
937:
Line 942: htp.p('');
938: end if; --p_mode DISPLAY_PORTLETS or DISPLAY_PORTLETS_EDIT
939:
940: end if; -- draw content
941: 942: htp.p(''); 943:
944: end renderregion;
945:
946:
Line 988: htp.p(l_str);
984: l_str := l_str || '';
985:
986: end if;
987: 988: htp.p(l_str); 989:
990: end showconfigurelinks;
991:
992:
Line 1026: htp.htmlOpen;
1022: -- Get the region properties
1023: l_region := icx_api_region.get_region(p_region_id);
1024:
1025: -- HTML Open 1026: htp.htmlOpen; 1027:
1028: -- HTML Header Open
1029: htp.headOpen;
1030: htp.p('');
Line 1029: htp.headOpen;
1025: -- HTML Open
1026: htp.htmlOpen;
1027:
1028: -- HTML Header Open 1029: htp.headOpen; 1030: htp.p('');
1031: --htp.title('EditRegion');
1032:
1033: -- Javascript Functions
1037: {
1038: self.close();
1039: } ');
1040: 1041: htp.p (' function applySubmit(url) 1042: {
1043: var v_region_id = document.editregionform.p_region_id.value;
1044: var v_border = document.editregionform.p_region_border.options[document.editregionform.p_region_border.selectedIndex].value;
1045: var v_width = document.editregionform.p_region_width.value;
Line 1060: htp.headClose;
1056: ');
1057: icx_javascript.close_script;
1058:
1059: -- HTML Head Close 1060: htp.headClose; 1061:
1062: -- Construct the Button and the Button list
1063: l_button1 := icxui_api_button.create_button( p_button_name => wf_core.translate('APPLY'),
1064: p_button_url => 'javascript:applySubmit('''||l_agent||'OracleConfigure.save_editregion'||''')');
Line 1077: htp.p('');
1073: p_subheader_text => wf_core.translate('REGION_PROPERTIES'),
1074: p_buttons => l_button_list);
1075:
1076: -- HTML Body Open 1077: htp.p(''); 1078:
1079: htp.centerOpen;
1080:
1081: -- Form Open
Line 1079: htp.centerOpen;
1075:
1076: -- HTML Body Open
1077: htp.p('
');
1078: 1079: htp.centerOpen; 1080:
1081: -- Form Open
1082: htp.formOpen(curl => l_agent||'OracleConfigure.draw_editregion',
1083: cmethod => 'POST',
Line 1082: htp.formOpen(curl => l_agent||'OracleConfigure.draw_editregion',
Line 1090: htp.formHidden(cname => 'p_region_id', cvalue => p_region_id);
1086:
1087:
1088: -- Hidden Form Elements
1089: htp.formHidden(cname => 'p_action'); 1090: htp.formHidden(cname => 'p_region_id', cvalue => p_region_id); 1091: htp.formHidden(cname => 'p_screen', cvalue => 'editregion');
1092: htp.formHidden(cname => 'p_page_id', cvalue => p_page_id);
1093:
1094: -- Draw the Dialog Title Bar
Line 1091: htp.formHidden(cname => 'p_screen', cvalue => 'editregion');
1087:
1088: -- Hidden Form Elements
1089: htp.formHidden(cname => 'p_action');
1090: htp.formHidden(cname => 'p_region_id', cvalue => p_region_id); 1091: htp.formHidden(cname => 'p_screen', cvalue => 'editregion'); 1092: htp.formHidden(cname => 'p_page_id', cvalue => p_page_id);
1093:
1094: -- Draw the Dialog Title Bar
1095: l_dialog.open_dialog;
Line 1092: htp.formHidden(cname => 'p_page_id', cvalue => p_page_id);
1088: -- Hidden Form Elements
1089: htp.formHidden(cname => 'p_action');
1090: htp.formHidden(cname => 'p_region_id', cvalue => p_region_id);
1091: htp.formHidden(cname => 'p_screen', cvalue => 'editregion'); 1092: htp.formHidden(cname => 'p_page_id', cvalue => p_page_id); 1093:
1094: -- Draw the Dialog Title Bar
1095: l_dialog.open_dialog;
1096:
Line 1098: -- htp.tableRowOpen;
1094: -- Draw the Dialog Title Bar
1095: l_dialog.open_dialog;
1096:
1097: -- TABLE FOR THE FORM ELEMENTS 1098: -- htp.tableRowOpen; 1099: -- wwutl_htp.tableDataOpen;
1100: htp.tableOpen(cattributes=>'cellspacing="0" cellpadding="0" border="0" width="80%"');
1101: -- Width
1102: htp.tableRowOpen;
Line 1099: -- wwutl_htp.tableDataOpen;
1095: l_dialog.open_dialog;
1096:
1097: -- TABLE FOR THE FORM ELEMENTS
1098: -- htp.tableRowOpen; 1099: -- wwutl_htp.tableDataOpen; 1100: htp.tableOpen(cattributes=>'cellspacing="0" cellpadding="0" border="0" width="80%"');
1101: -- Width
1102: htp.tableRowOpen;
1103: htp.tableData(wf_core.translate('WIDTH'),
Line 1100: htp.tableOpen(cattributes=>'cellspacing="0" cellpadding="0" border="0" width="80%"');
1096:
1097: -- TABLE FOR THE FORM ELEMENTS
1098: -- htp.tableRowOpen;
1099: -- wwutl_htp.tableDataOpen; 1100: htp.tableOpen(cattributes=>'cellspacing="0" cellpadding="0" border="0" width="80%"'); 1101: -- Width
1102: htp.tableRowOpen;
1103: htp.tableData(wf_core.translate('WIDTH'),
1104: cattributes => 'VALIGN="MIDDLE"');
1113: -- border
1114: fnd_message.set_name('ICX','ICX_SHOW_BORDER');
1115: l_prompt := fnd_message.get;
1116: 1117: htp.tableRowOpen; 1118: htp.tableData(l_prompt,
1119: cattributes => 'VALIGN="MIDDLE"');
1120:
1121: -- The Drop Down List of Region Alignments
Line 1118: htp.tableData(l_prompt,
1114: fnd_message.set_name('ICX','ICX_SHOW_BORDER');
1115: l_prompt := fnd_message.get;
1116:
1117: htp.tableRowOpen; 1118: htp.tableData(l_prompt, 1119: cattributes => 'VALIGN="MIDDLE"');
1120:
1121: -- The Drop Down List of Region Alignments
1122: htp.p('
');
Line 1122: htp.p('
');
1118: htp.tableData(l_prompt,
1119: cattributes => 'VALIGN="MIDDLE"');
1120:
1121: -- The Drop Down List of Region Alignments 1122: htp.p('
');
1123: htp.formSelectOpen(cname => 'p_region_border');
1124: htp.fontOpen(cface => 'arial,helvetica', csize => '-1');
1125:
1126: if l_region.border = 'Y' then
Line 1123: htp.formSelectOpen(cname => 'p_region_border');
1119: cattributes => 'VALIGN="MIDDLE"');
1120:
1121: -- The Drop Down List of Region Alignments
1122: htp.p('
1137: end if;
1138: htp.p(wf_core.translate('WFMON_NO'));
1139: htp.p('');
1140: htp.fontClose; 1141: htp.formSelectClose; 1142: htp.p('');
1143: htp.tableRowClose;
1144:
1145: -- CLOSE THE TABLE FOR THE FORM ELEMENTS
Line 1142: htp.p('');
1138: htp.p(wf_core.translate('WFMON_NO'));
1139: htp.p('');
1140: htp.fontClose;
1141: htp.formSelectClose; 1142: htp.p(''); 1143: htp.tableRowClose;
1144:
1145: -- CLOSE THE TABLE FOR THE FORM ELEMENTS
1146: htp.tableClose;
Line 1143: htp.tableRowClose;
1139: htp.p('');
1140: htp.fontClose;
1141: htp.formSelectClose;
1142: htp.p(''); 1143: htp.tableRowClose; 1144:
1145: -- CLOSE THE TABLE FOR THE FORM ELEMENTS
1146: htp.tableClose;
1147:
Line 1146: htp.tableClose;
1142: htp.p('');
1143: htp.tableRowClose;
1144:
1145: -- CLOSE THE TABLE FOR THE FORM ELEMENTS 1146: htp.tableClose; 1147:
1148: -- Draw the dialog footer
1149: l_dialog.close_dialog;
1150:
Line 1152: htp.formClose;
1148: -- Draw the dialog footer
1149: l_dialog.close_dialog;
1150:
1151: -- CLOSE FORM 1152: htp.formClose; 1153: htp.centerClose;
1154:
1155: -- Close Body
1156: htp.bodyClose;
Line 1153: htp.centerClose;
1149: l_dialog.close_dialog;
1150:
1151: -- CLOSE FORM
1152: htp.formClose; 1153: htp.centerClose; 1154:
1155: -- Close Body
1156: htp.bodyClose;
1157:
Line 1156: htp.bodyClose;
1152: htp.formClose;
1153: htp.centerClose;
1154:
1155: -- Close Body 1156: htp.bodyClose; 1157:
1158: -- Close HTML
1159: htp.htmlClose;
1160: end if;
Line 1159: htp.htmlClose;
1155: -- Close Body
1156: htp.bodyClose;
1157:
1158: -- Close HTML 1159: htp.htmlClose; 1160: end if;
1161: end;
1162:
1163: -- ***********************************************
Line 1195: htp.p(SQLERRM);
1191: l_width_num := to_number(p_region_width);
1192: exception
1193: when VALUE_ERROR then
1194: -- Display error message 1195: htp.p(SQLERRM); 1196:
1197: -- Return to the screen
1198: OracleConfigure.displayCustomize(p_page_id);
1199:
Line 1214: htp.p(SQLERRM);
1210: begin
1211: icx_api_region.edit_region(l_region);
1212: exception
1213: when OTHERS then 1214: htp.p(SQLERRM); 1215: end;
1216:
1217: end if;
1218:
Line 1244: htp.p(SQLERRM);
1240: begin
1241: icx_api_region.split_region(p_region_id, p_split_mode);
1242: exception
1243: when OTHERS then 1244: htp.p(SQLERRM); 1245: end;
1246:
1247: OracleConfigure.displayCustomize(p_page_id);
1248:
Line 1270: htp.p(SQLERRM);
1266: begin
1267: icx_api_region.delete_region(p_region_id);
1268: exception
1269: when OTHERS then 1270: htp.p(SQLERRM); 1271: end;
1272:
1273: OracleConfigure.displayCustomize(p_page_id);
1274:
Line 1313: htp.p(SQLERRM);
1309: and ipp.entry_sequence = fme.entry_sequence
1310: and fff.function_id = fme.function_id;
1311: exception
1312: when no_data_found then 1313: htp.p(SQLERRM); 1314: end;
1315:
1316: if l_plug_name is null then
1317: begin
Line 1327: htp.p(SQLERRM);
1323: and b.MENU_ID = -1
1324: and b.ENTRY_SEQUENCE = a.FUNCTION_ID;
1325: exception
1326: when no_data_found then 1327: htp.p(SQLERRM); 1328: end;
1329: end if;
1330:
1331: htp.htmlOpen;