24: ');
25:
26:
27: htp.p('
28: FND_MESSAGE.SET_NAME('ICX','ICX_BROWSER');
29: htp.p(FND_MESSAGE.Get);
30: htp.p('
31:
32: htp.htmlClose;
25:
26:
27: htp.p('
28: FND_MESSAGE.SET_NAME('ICX','ICX_BROWSER');
29: htp.p(FND_MESSAGE.Get);
30: htp.p('
31:
32: htp.htmlClose;
33: end if; -- validateSession
100: parent.tail.document.Tail.p_template.value = template_name
101: parent.tail.document.Tail.submit()
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: }
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
111: -- with the spaces in the template name
112: -- var l_where = "EXPRESS_NAME<>''" + document.Template.ICX_TEMPLATE1.value + "''"
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');
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');
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');
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()
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: }
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: }
125: }
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 {
268: document.Tail.submit()
269: }');
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: }
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:
458:
459:
460: -- display message if no rows were returned by query
461: if j = 0 then
462: fnd_message.set_name('ICX','ICX_TMP_NO_RELATION');
463: fnd_message.set_token('TEMPLATE',p_template);
464: htp.p('
459:
460: -- display message if no rows were returned by query
461: if j = 0 then
462: fnd_message.set_name('ICX','ICX_TMP_NO_RELATION');
463: fnd_message.set_token('TEMPLATE',p_template);
464: htp.p('
460: -- display message if no rows were returned by query
461: if j = 0 then
462: fnd_message.set_name('ICX','ICX_TMP_NO_RELATION');
463: fnd_message.set_token('TEMPLATE',p_template);
464: htp.p(''||fnd_message.get||'
');
465: end if;
466:
467:
468: else -- p_template is not valid
467:
468: else -- p_template is not valid
469: if p_template is not null then
470: -- display message that category name is not valid
471: FND_MESSAGE.SET_NAME('ICX','ICX_INVALID_ENTRY');
472: FND_MESSAGE.SET_TOKEN('INVALID_TOKEN',p_template);
473: htp.p('
468: else -- p_template is not valid
469: if p_template is not null then
470: -- display message that category name is not valid
471: FND_MESSAGE.SET_NAME('ICX','ICX_INVALID_ENTRY');
472: FND_MESSAGE.SET_TOKEN('INVALID_TOKEN',p_template);
473: htp.p('
469: if p_template is not null then
470: -- display message that category name is not valid
471: FND_MESSAGE.SET_NAME('ICX','ICX_INVALID_ENTRY');
472: FND_MESSAGE.SET_TOKEN('INVALID_TOKEN',p_template);
473: htp.p(''||FND_MESSAGE.Get||'
474: end if;');
475:
476: end if;
477:
486: when others then
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;