eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
5: 6: procedure main is 7: 8: l_title varchar2(80); 9: l_prompts icx_util.g_prompts_table; 10: 11: begin 12: if icx_sec.validateSession then 13: icx_util.getPrompts(601,'ICX_RELATED_TEMPLATES_R',l_title,l_prompts);
9: l_prompts icx_util.g_prompts_table; 10: 11: begin 12: if icx_sec.validateSession then 13: icx_util.getPrompts(601,'ICX_RELATED_TEMPLATES_R',l_title,l_prompts); 14: 15: htp.htmlOpen; 16: htp.headOpen; 17: icx_util.copyright;
13: icx_util.getPrompts(601,'ICX_RELATED_TEMPLATES_R',l_title,l_prompts); 14: 15: htp.htmlOpen; 16: htp.headOpen; 17: icx_util.copyright; 18: htp.title(l_title); 19: htp.headClose; 20: 21: htp.p('
51: l_agent varchar2(100) := owa_util.get_cgi_env('SCRIPT_NAME'); 52: l_language varchar2(30); 53: i number; 54: l_title varchar2(80); 55: l_prompts icx_util.g_prompts_table; 56: lov_title varchar2(80); 57: lov_prompts icx_util.g_prompts_table; 58: err_num number; 59: err_mesg varchar2(512);
53: i number; 54: l_title varchar2(80); 55: l_prompts icx_util.g_prompts_table; 56: lov_title varchar2(80); 57: lov_prompts icx_util.g_prompts_table; 58: err_num number; 59: err_mesg varchar2(512); 60: temp_text varchar2(2000); 61: temp_relation_code varchar2(30);
62: temp_relation varchar2(80); 63: 64: begin 65: if icx_sec.validateSession then 66: icx_util.error_page_setup; 67: l_language := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE); 68: icx_util.getPrompts(601,'ICX_RELATED_TEMPLATES_R',l_title,l_prompts); 69: icx_util.getPrompts(601,'ICX_LOV',lov_title,lov_prompts); 70:
64: begin 65: if icx_sec.validateSession then 66: icx_util.error_page_setup; 67: l_language := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE); 68: icx_util.getPrompts(601,'ICX_RELATED_TEMPLATES_R',l_title,l_prompts); 69: icx_util.getPrompts(601,'ICX_LOV',lov_title,lov_prompts); 70: 71: htp.htmlOpen; 72: htp.headOpen;
65: if icx_sec.validateSession then 66: icx_util.error_page_setup; 67: l_language := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE); 68: icx_util.getPrompts(601,'ICX_RELATED_TEMPLATES_R',l_title,l_prompts); 69: icx_util.getPrompts(601,'ICX_LOV',lov_title,lov_prompts); 70: 71: htp.htmlOpen; 72: htp.headOpen; 73: icx_util.copyright;
69: icx_util.getPrompts(601,'ICX_LOV',lov_title,lov_prompts); 70: 71: htp.htmlOpen; 72: htp.headOpen; 73: icx_util.copyright; 74: 75: htp.title(l_title); 76: 77: js.scriptOpen;
74: 75: htp.title(l_title); 76: 77: js.scriptOpen; 78: icx_util.LOVScript; 79: icx_admin_sig.help_win_script('/OA_HTML/'||l_language||'/ICXHLMTH.htm'); 80: 81: js.null_alert; 82: js.equal_alert;
102: }'); 103: 104: FND_MESSAGE.SET_NAME('ICX','ICX_TMP_BEFORE'); 105: htp.p('function pre_rel_template_LOV() { 106: if (!null_alert(document.Template.ICX_TEMPLATE1.value,"'||icx_util.replace_quotes(FND_MESSAGE.Get)||'")) { 107: LOV(''178'',''ICX_RELATED_TEMPLATE'',''601'',''ICX_RELATED_TEMPLATES_R'',''Template'',''header'','''','''') 108: } 109: }'); 110: -- remove manual where clause for now because html can not deal
113: 114: 115: FND_MESSAGE.SET_NAME('ICX','ICX_NOT_NULL'); 116: htp.p('function template_submit() { 117: if (!null_alert(document.Template.ICX_TEMPLATE1.value,"'||icx_util.replace_quotes(l_prompts(1))||' '||icx_util.replace_quotes(FND_MESSAGE.Get)||'")) { 118: if (document.Template.ICX_RELATION.options[document.Template.ICX_RELATION.selectedIndex].value != "TOP") {'); 119: FND_MESSAGE.SET_NAME('ICX','ICX_NOT_NULL'); 120: htp.p(' if (!null_alert(document.Template.ICX_RELATED_TEMPLATE.value,"'||icx_util.replace_quotes(l_prompts(2))||' '||icx_util.replace_quotes(FND_MESSAGE.Get)||'")) {'); 121: FND_MESSAGE.SET_NAME('ICX','ICX_CAT_PARENT');
116: htp.p('function template_submit() { 117: if (!null_alert(document.Template.ICX_TEMPLATE1.value,"'||icx_util.replace_quotes(l_prompts(1))||' '||icx_util.replace_quotes(FND_MESSAGE.Get)||'")) { 118: if (document.Template.ICX_RELATION.options[document.Template.ICX_RELATION.selectedIndex].value != "TOP") {'); 119: FND_MESSAGE.SET_NAME('ICX','ICX_NOT_NULL'); 120: htp.p(' if (!null_alert(document.Template.ICX_RELATED_TEMPLATE.value,"'||icx_util.replace_quotes(l_prompts(2))||' '||icx_util.replace_quotes(FND_MESSAGE.Get)||'")) {'); 121: FND_MESSAGE.SET_NAME('ICX','ICX_CAT_PARENT'); 122: htp.p(' if (!equal_alert(document.Template.ICX_TEMPLATE1.value,document.Template.ICX_RELATED_TEMPLATE.value,"'||icx_util.replace_quotes(FND_MESSAGE.Get)||'")) { 123: document.Template.submit() 124: }
118: if (document.Template.ICX_RELATION.options[document.Template.ICX_RELATION.selectedIndex].value != "TOP") {'); 119: FND_MESSAGE.SET_NAME('ICX','ICX_NOT_NULL'); 120: htp.p(' if (!null_alert(document.Template.ICX_RELATED_TEMPLATE.value,"'||icx_util.replace_quotes(l_prompts(2))||' '||icx_util.replace_quotes(FND_MESSAGE.Get)||'")) {'); 121: FND_MESSAGE.SET_NAME('ICX','ICX_CAT_PARENT'); 122: htp.p(' if (!equal_alert(document.Template.ICX_TEMPLATE1.value,document.Template.ICX_RELATED_TEMPLATE.value,"'||icx_util.replace_quotes(FND_MESSAGE.Get)||'")) { 123: document.Template.submit() 124: } 125: } 126: } else {
152: 153: -- Template text field 154: htp.tableData(l_prompts(1),'RIGHT'); 155: htp.tableData(htf.formText('ICX_TEMPLATE1',30,81,p_template,'onchange="template_changed()"')); 156: htp.tableData(htf.anchor('javascript:pre_template_LOV()',htf.img('/OA_MEDIA/'||l_language||'/FNDILOV.gif','CENTER',icx_util.replace_alt_quotes(lov_title), 157: '','BORDER=0 WIDTH=23 HEIGHT=21'),'','onMouseOver="window.status='''||icx_util.replace_onMouseOver_quotes(lov_title)||''';return true"')); 158: htp.tableRowClose; 159: 160: -- Relation poplist
153: -- Template text field 154: htp.tableData(l_prompts(1),'RIGHT'); 155: htp.tableData(htf.formText('ICX_TEMPLATE1',30,81,p_template,'onchange="template_changed()"')); 156: htp.tableData(htf.anchor('javascript:pre_template_LOV()',htf.img('/OA_MEDIA/'||l_language||'/FNDILOV.gif','CENTER',icx_util.replace_alt_quotes(lov_title), 157: '','BORDER=0 WIDTH=23 HEIGHT=21'),'','onMouseOver="window.status='''||icx_util.replace_onMouseOver_quotes(lov_title)||''';return true"')); 158: htp.tableRowClose; 159: 160: -- Relation poplist 161: htp.tableRowOpen;
172: 173: -- Related Category text field 174: htp.tableData(l_prompts(2),'RIGHT'); 175: htp.tableData(htf.formText('ICX_RELATED_TEMPLATE',30,81,'')); 176: htp.tableData(htf.anchor('javascript:pre_rel_template_LOV()',htf.img('/OA_MEDIA/'||l_language||'/FNDILOV.gif','CENTER',icx_util.replace_alt_quotes(lov_title), 177: '','BORDER=0 WIDTH=23 HEIGHT=21'),'','onMouseOver="window.status='''||icx_util.replace_onMouseOver_quotes(lov_title)||''';return true"')); 178: htp.tableRowClose; 179: htp.tableClose; 180:
173: -- Related Category text field 174: htp.tableData(l_prompts(2),'RIGHT'); 175: htp.tableData(htf.formText('ICX_RELATED_TEMPLATE',30,81,'')); 176: htp.tableData(htf.anchor('javascript:pre_rel_template_LOV()',htf.img('/OA_MEDIA/'||l_language||'/FNDILOV.gif','CENTER',icx_util.replace_alt_quotes(lov_title), 177: '','BORDER=0 WIDTH=23 HEIGHT=21'),'','onMouseOver="window.status='''||icx_util.replace_onMouseOver_quotes(lov_title)||''';return true"')); 178: htp.tableRowClose; 179: htp.tableClose; 180: 181:
181: 182: -- Write submit and clear buttons 183: htp.tableOpen; 184: htp.tableRowOpen; 185: icx_util.DynamicButton(l_prompts(4),'FNDBSBMT.gif',l_prompts(4),'javascript:template_submit()',l_language,FALSE); 186: if (instr(c_browser, 'MSIE') = 0) then 187: icx_util.DynamicButton(l_prompts(5),'FNDBCLR.gif',l_prompts(5),'javascript:document.Template.reset()',l_language,FALSE); 188: end if; 189: htp.tableRowClose;
183: htp.tableOpen; 184: htp.tableRowOpen; 185: icx_util.DynamicButton(l_prompts(4),'FNDBSBMT.gif',l_prompts(4),'javascript:template_submit()',l_language,FALSE); 186: if (instr(c_browser, 'MSIE') = 0) then 187: icx_util.DynamicButton(l_prompts(5),'FNDBCLR.gif',l_prompts(5),'javascript:document.Template.reset()',l_language,FALSE); 188: end if; 189: htp.tableRowClose; 190: htp.tableClose; 191:
209: when others then 210: err_num := SQLCODE; 211: temp_text := SQLERRM; 212: select substr(temp_text,12,512) into err_mesg from dual; 213: icx_util.add_error(err_mesg); 214: icx_admin_sig.error_screen(l_title,l_language); 215: 216: end; -- template_head 217:
224: l_agent varchar2(100) := owa_util.get_cgi_env('SCRIPT_NAME'); 225: l_responsibility_id number := icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID); 226: l_user_id number := icx_sec.getID(icx_sec.PV_WEB_USER_ID); 227: l_title varchar2(80); 228: l_prompts icx_util.g_prompts_table; 229: err_num number; 230: err_mesg varchar2(512); 231: temp_text varchar2(2000); 232: l_language varchar2(30);
229: err_num number; 230: err_mesg varchar2(512); 231: temp_text varchar2(2000); 232: l_language varchar2(30); 233: l_result_row_table icx_util.char240_table; 234: l_total_rows number; 235: l_end_row number; 236: l_query_size number; 237: l_where varchar2(2000);
251: 252: v_index := 1; 253: 254: 255: icx_util.error_page_setup; 256: l_language := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE); 257: icx_util.getPrompts(601,'ICX_RELATED_TEMPLATES_DISP_R',l_title,l_prompts); 258: 259: htp.htmlOpen;
253: 254: 255: icx_util.error_page_setup; 256: l_language := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE); 257: icx_util.getPrompts(601,'ICX_RELATED_TEMPLATES_DISP_R',l_title,l_prompts); 258: 259: htp.htmlOpen; 260: htp.headOpen; 261: icx_util.copyright;
257: icx_util.getPrompts(601,'ICX_RELATED_TEMPLATES_DISP_R',l_title,l_prompts); 258: 259: htp.htmlOpen; 260: htp.headOpen; 261: icx_util.copyright; 262: js.scriptOpen; 263: 264: -- Javascript function to handle CD buttons 265: htp.p('function rows(start_num, end_num) {
270: 271: -- javascript function to confirm delete of relationship 272: FND_MESSAGE.Set_name('ICX','ICX_DELETE'); 273: htp.p('function delete_relation(template, related_template, html_template, html_related_template) { 274: if (confirm("'||icx_util.replace_onMouseOver_quotes(FND_MESSAGE.Get)||': " + template + " - " + related_template)) { 275: open('''||l_agent||'/ICX_TEMPLATE_HEIRARCHY.template_delete?icx_template1='' + html_template + ''&icx_related_template='' + html_related_template,''tail'') 276: } 277: }'); 278:
376: 377: 378: -- display table header 379: htp.tableOpen('BORDER=1'); 380: htp.p(''); 381: for k in ak_query_pkg.g_items_table.FIRST..ak_query_pkg.g_items_table.LAST loop 382: if ak_query_pkg.g_items_table(k).secured_column = 'F' and 383: ak_query_pkg.g_items_table(k).node_display_flag = 'Y' then 384: htp.tableData(htf.strong(ak_query_pkg.g_items_table(k).attribute_label_long),'LEFT'); Line 393: icx_util.transfer_Row_To_Column(ak_query_pkg.g_results_table(i-1), l_result_row_table); 389: end if; -- CD Buttons and table header 390: 391: 392: -- load data for current row into temp pl/sql table 393: icx_util.transfer_Row_To_Column(ak_query_pkg.g_results_table(i-1), l_result_row_table); 394: 395: 396: -- display one row of data 397: htp.p(''); Line 397: htp.p(''); 393: icx_util.transfer_Row_To_Column(ak_query_pkg.g_results_table(i-1), l_result_row_table); 394: 395: 396: -- display one row of data 397: htp.p(''); 398: for k in ak_query_pkg.g_items_table.FIRST..ak_query_pkg.g_items_table.LAST loop 399: if ak_query_pkg.g_items_table(k).secured_column = 'F' and 400: ak_query_pkg.g_items_table(k).node_display_flag = 'Y' then 401: Line 432: htp.tableData(htf.anchor('javascript:delete_relation('''||icx_util.replace_quotes(temp_template)||''','''||icx_util.replace_quotes(temp_related_template)||''', 428: end if; 429: 430: end loop; 431: 432: htp.tableData(htf.anchor('javascript:delete_relation('''||icx_util.replace_quotes(temp_template)||''','''||icx_util.replace_quotes(temp_related_template)||''', 433: '''||replace(icx_util.replace_quotes(temp_template),' ','@~$')||''','''||replace(icx_util.replace_quotes(temp_related_template),' ','@~$')||''')', 434: htf.img('/OA_MEDIA/'||l_language||'/FNDIDELR.gif','CENTER',icx_util.replace_alt_quotes(l_prompts(6)),'', 435: 'BORDER=0 WIDTH=16 HEIGHT=17'),'','onMouseOver="window.status='''||icx_util.replace_onMouseOver_quotes(l_prompts(6))||''';return true"')); 436: Line 433: '''||replace(icx_util.replace_quotes(temp_template),' ','@~$')||''','''||replace(icx_util.replace_quotes(temp_related_template),' ','@~$')||''')', 429: 430: end loop; 431: 432: htp.tableData(htf.anchor('javascript:delete_relation('''||icx_util.replace_quotes(temp_template)||''','''||icx_util.replace_quotes(temp_related_template)||''', 433: '''||replace(icx_util.replace_quotes(temp_template),' ','@~$')||''','''||replace(icx_util.replace_quotes(temp_related_template),' ','@~$')||''')', 434: htf.img('/OA_MEDIA/'||l_language||'/FNDIDELR.gif','CENTER',icx_util.replace_alt_quotes(l_prompts(6)),'', 435: 'BORDER=0 WIDTH=16 HEIGHT=17'),'','onMouseOver="window.status='''||icx_util.replace_onMouseOver_quotes(l_prompts(6))||''';return true"')); 436: 437: htp.tableRowClose; Line 434: htf.img('/OA_MEDIA/'||l_language||'/FNDIDELR.gif','CENTER',icx_util.replace_alt_quotes(l_prompts(6)),'', 430: end loop; 431: 432: htp.tableData(htf.anchor('javascript:delete_relation('''||icx_util.replace_quotes(temp_template)||''','''||icx_util.replace_quotes(temp_related_template)||''', 433: '''||replace(icx_util.replace_quotes(temp_template),' ','@~$')||''','''||replace(icx_util.replace_quotes(temp_related_template),' ','@~$')||''')', 434: htf.img('/OA_MEDIA/'||l_language||'/FNDIDELR.gif','CENTER',icx_util.replace_alt_quotes(l_prompts(6)),'', 435: 'BORDER=0 WIDTH=16 HEIGHT=17'),'','onMouseOver="window.status='''||icx_util.replace_onMouseOver_quotes(l_prompts(6))||''';return true"')); 436: 437: htp.tableRowClose; 438: Line 435: 'BORDER=0 WIDTH=16 HEIGHT=17'),'','onMouseOver="window.status='''||icx_util.replace_onMouseOver_quotes(l_prompts(6))||''';return true"')); 431: 432: htp.tableData(htf.anchor('javascript:delete_relation('''||icx_util.replace_quotes(temp_template)||''','''||icx_util.replace_quotes(temp_related_template)||''', 433: '''||replace(icx_util.replace_quotes(temp_template),' ','@~$')||''','''||replace(icx_util.replace_quotes(temp_related_template),' ','@~$')||''')', 434: htf.img('/OA_MEDIA/'||l_language||'/FNDIDELR.gif','CENTER',icx_util.replace_alt_quotes(l_prompts(6)),'', 435: 'BORDER=0 WIDTH=16 HEIGHT=17'),'','onMouseOver="window.status='''||icx_util.replace_onMouseOver_quotes(l_prompts(6))||''';return true"')); 436: 437: htp.tableRowClose; 438: 439: end loop; -- Display data Line 491: icx_util.add_error(err_mesg); 487: err_num := SQLCODE; 488: temp_text := SQLERRM; 489: select substr(temp_text,12,512) into err_mesg from dual; 490: fnd_message.set_name('ICX','ICX_ERROR'); 491: icx_util.add_error(err_mesg); 492: icx_admin_sig.error_screen(l_title,l_language); 493: 494: end template_tail; 495: Line 510: icx_util.error_page_setup; 506: 507: 508: begin 509: if icx_sec.validateSession then 510: icx_util.error_page_setup; 511: 512: -- insert top relation for this category if needed 513: if icx_relation = 'TOP' then 514: Line 585: icx_util.error_page_setup; 581: 582: 583: begin 584: if icx_sec.validateSession then 585: icx_util.error_page_setup; 586: 587: 588: -- delete relation 589:
389: end if; -- CD Buttons and table header 390: 391: 392: -- load data for current row into temp pl/sql table 393: icx_util.transfer_Row_To_Column(ak_query_pkg.g_results_table(i-1), l_result_row_table); 394: 395: 396: -- display one row of data 397: htp.p('
393: icx_util.transfer_Row_To_Column(ak_query_pkg.g_results_table(i-1), l_result_row_table); 394: 395: 396: -- display one row of data 397: htp.p(''); 398: for k in ak_query_pkg.g_items_table.FIRST..ak_query_pkg.g_items_table.LAST loop 399: if ak_query_pkg.g_items_table(k).secured_column = 'F' and 400: ak_query_pkg.g_items_table(k).node_display_flag = 'Y' then 401: Line 432: htp.tableData(htf.anchor('javascript:delete_relation('''||icx_util.replace_quotes(temp_template)||''','''||icx_util.replace_quotes(temp_related_template)||''', 428: end if; 429: 430: end loop; 431: 432: htp.tableData(htf.anchor('javascript:delete_relation('''||icx_util.replace_quotes(temp_template)||''','''||icx_util.replace_quotes(temp_related_template)||''', 433: '''||replace(icx_util.replace_quotes(temp_template),' ','@~$')||''','''||replace(icx_util.replace_quotes(temp_related_template),' ','@~$')||''')', 434: htf.img('/OA_MEDIA/'||l_language||'/FNDIDELR.gif','CENTER',icx_util.replace_alt_quotes(l_prompts(6)),'', 435: 'BORDER=0 WIDTH=16 HEIGHT=17'),'','onMouseOver="window.status='''||icx_util.replace_onMouseOver_quotes(l_prompts(6))||''';return true"')); 436: Line 433: '''||replace(icx_util.replace_quotes(temp_template),' ','@~$')||''','''||replace(icx_util.replace_quotes(temp_related_template),' ','@~$')||''')', 429: 430: end loop; 431: 432: htp.tableData(htf.anchor('javascript:delete_relation('''||icx_util.replace_quotes(temp_template)||''','''||icx_util.replace_quotes(temp_related_template)||''', 433: '''||replace(icx_util.replace_quotes(temp_template),' ','@~$')||''','''||replace(icx_util.replace_quotes(temp_related_template),' ','@~$')||''')', 434: htf.img('/OA_MEDIA/'||l_language||'/FNDIDELR.gif','CENTER',icx_util.replace_alt_quotes(l_prompts(6)),'', 435: 'BORDER=0 WIDTH=16 HEIGHT=17'),'','onMouseOver="window.status='''||icx_util.replace_onMouseOver_quotes(l_prompts(6))||''';return true"')); 436: 437: htp.tableRowClose; Line 434: htf.img('/OA_MEDIA/'||l_language||'/FNDIDELR.gif','CENTER',icx_util.replace_alt_quotes(l_prompts(6)),'', 430: end loop; 431: 432: htp.tableData(htf.anchor('javascript:delete_relation('''||icx_util.replace_quotes(temp_template)||''','''||icx_util.replace_quotes(temp_related_template)||''', 433: '''||replace(icx_util.replace_quotes(temp_template),' ','@~$')||''','''||replace(icx_util.replace_quotes(temp_related_template),' ','@~$')||''')', 434: htf.img('/OA_MEDIA/'||l_language||'/FNDIDELR.gif','CENTER',icx_util.replace_alt_quotes(l_prompts(6)),'', 435: 'BORDER=0 WIDTH=16 HEIGHT=17'),'','onMouseOver="window.status='''||icx_util.replace_onMouseOver_quotes(l_prompts(6))||''';return true"')); 436: 437: htp.tableRowClose; 438: Line 435: 'BORDER=0 WIDTH=16 HEIGHT=17'),'','onMouseOver="window.status='''||icx_util.replace_onMouseOver_quotes(l_prompts(6))||''';return true"')); 431: 432: htp.tableData(htf.anchor('javascript:delete_relation('''||icx_util.replace_quotes(temp_template)||''','''||icx_util.replace_quotes(temp_related_template)||''', 433: '''||replace(icx_util.replace_quotes(temp_template),' ','@~$')||''','''||replace(icx_util.replace_quotes(temp_related_template),' ','@~$')||''')', 434: htf.img('/OA_MEDIA/'||l_language||'/FNDIDELR.gif','CENTER',icx_util.replace_alt_quotes(l_prompts(6)),'', 435: 'BORDER=0 WIDTH=16 HEIGHT=17'),'','onMouseOver="window.status='''||icx_util.replace_onMouseOver_quotes(l_prompts(6))||''';return true"')); 436: 437: htp.tableRowClose; 438: 439: end loop; -- Display data Line 491: icx_util.add_error(err_mesg); 487: err_num := SQLCODE; 488: temp_text := SQLERRM; 489: select substr(temp_text,12,512) into err_mesg from dual; 490: fnd_message.set_name('ICX','ICX_ERROR'); 491: icx_util.add_error(err_mesg); 492: icx_admin_sig.error_screen(l_title,l_language); 493: 494: end template_tail; 495: Line 510: icx_util.error_page_setup; 506: 507: 508: begin 509: if icx_sec.validateSession then 510: icx_util.error_page_setup; 511: 512: -- insert top relation for this category if needed 513: if icx_relation = 'TOP' then 514: Line 585: icx_util.error_page_setup; 581: 582: 583: begin 584: if icx_sec.validateSession then 585: icx_util.error_page_setup; 586: 587: 588: -- delete relation 589:
428: end if; 429: 430: end loop; 431: 432: htp.tableData(htf.anchor('javascript:delete_relation('''||icx_util.replace_quotes(temp_template)||''','''||icx_util.replace_quotes(temp_related_template)||''', 433: '''||replace(icx_util.replace_quotes(temp_template),' ','@~$')||''','''||replace(icx_util.replace_quotes(temp_related_template),' ','@~$')||''')', 434: htf.img('/OA_MEDIA/'||l_language||'/FNDIDELR.gif','CENTER',icx_util.replace_alt_quotes(l_prompts(6)),'', 435: 'BORDER=0 WIDTH=16 HEIGHT=17'),'','onMouseOver="window.status='''||icx_util.replace_onMouseOver_quotes(l_prompts(6))||''';return true"')); 436:
429: 430: end loop; 431: 432: htp.tableData(htf.anchor('javascript:delete_relation('''||icx_util.replace_quotes(temp_template)||''','''||icx_util.replace_quotes(temp_related_template)||''', 433: '''||replace(icx_util.replace_quotes(temp_template),' ','@~$')||''','''||replace(icx_util.replace_quotes(temp_related_template),' ','@~$')||''')', 434: htf.img('/OA_MEDIA/'||l_language||'/FNDIDELR.gif','CENTER',icx_util.replace_alt_quotes(l_prompts(6)),'', 435: 'BORDER=0 WIDTH=16 HEIGHT=17'),'','onMouseOver="window.status='''||icx_util.replace_onMouseOver_quotes(l_prompts(6))||''';return true"')); 436: 437: htp.tableRowClose;
430: end loop; 431: 432: htp.tableData(htf.anchor('javascript:delete_relation('''||icx_util.replace_quotes(temp_template)||''','''||icx_util.replace_quotes(temp_related_template)||''', 433: '''||replace(icx_util.replace_quotes(temp_template),' ','@~$')||''','''||replace(icx_util.replace_quotes(temp_related_template),' ','@~$')||''')', 434: htf.img('/OA_MEDIA/'||l_language||'/FNDIDELR.gif','CENTER',icx_util.replace_alt_quotes(l_prompts(6)),'', 435: 'BORDER=0 WIDTH=16 HEIGHT=17'),'','onMouseOver="window.status='''||icx_util.replace_onMouseOver_quotes(l_prompts(6))||''';return true"')); 436: 437: htp.tableRowClose; 438:
431: 432: htp.tableData(htf.anchor('javascript:delete_relation('''||icx_util.replace_quotes(temp_template)||''','''||icx_util.replace_quotes(temp_related_template)||''', 433: '''||replace(icx_util.replace_quotes(temp_template),' ','@~$')||''','''||replace(icx_util.replace_quotes(temp_related_template),' ','@~$')||''')', 434: htf.img('/OA_MEDIA/'||l_language||'/FNDIDELR.gif','CENTER',icx_util.replace_alt_quotes(l_prompts(6)),'', 435: 'BORDER=0 WIDTH=16 HEIGHT=17'),'','onMouseOver="window.status='''||icx_util.replace_onMouseOver_quotes(l_prompts(6))||''';return true"')); 436: 437: htp.tableRowClose; 438: 439: end loop; -- Display data
487: err_num := SQLCODE; 488: temp_text := SQLERRM; 489: select substr(temp_text,12,512) into err_mesg from dual; 490: fnd_message.set_name('ICX','ICX_ERROR'); 491: icx_util.add_error(err_mesg); 492: icx_admin_sig.error_screen(l_title,l_language); 493: 494: end template_tail; 495:
506: 507: 508: begin 509: if icx_sec.validateSession then 510: icx_util.error_page_setup; 511: 512: -- insert top relation for this category if needed 513: if icx_relation = 'TOP' then 514:
581: 582: 583: begin 584: if icx_sec.validateSession then 585: icx_util.error_page_setup; 586: 587: 588: -- delete relation 589: