DBA Data[Home] [Help]

APPS.ICX_CAT dependencies on HTP

Line 15: htp.htmlOpen;

11: begin
12: if icx_sec.validateSession then
13: icx_util.getPrompts(601,'ICX_RELATED_CATEGORIES_R',l_title,l_prompts);
14:
15: htp.htmlOpen;
16: htp.headOpen;
17: icx_util.copyright;
18: htp.title(l_title);
19: htp.headClose;

Line 16: htp.headOpen;

12: if icx_sec.validateSession then
13: icx_util.getPrompts(601,'ICX_RELATED_CATEGORIES_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:

Line 18: htp.title(l_title);

14:
15: htp.htmlOpen;
16: htp.headOpen;
17: icx_util.copyright;
18: htp.title(l_title);
19: htp.headClose;
20:
21: htp.p('
22:

Line 19: htp.headClose;

15: htp.htmlOpen;
16: htp.headOpen;
17: icx_util.copyright;
18: htp.title(l_title);
19: htp.headClose;
20:
21: htp.p('
22:
23:

Line 21: htp.p('

17: icx_util.copyright;
18: htp.title(l_title);
19: htp.headClose;
20:
21: htp.p('
22:
23:
24: ');
25:

Line 27: htp.p('');

23:
24: ');
25:
26:
27: htp.p('');
28: FND_MESSAGE.SET_NAME('ICX','ICX_BROWSER');
29: htp.p(FND_MESSAGE.Get);
30: htp.p('');
31: htp.p('in Main');

Line 29: htp.p(FND_MESSAGE.Get);

25:
26:
27: htp.p('');
28: FND_MESSAGE.SET_NAME('ICX','ICX_BROWSER');
29: htp.p(FND_MESSAGE.Get);
30: htp.p('');
31: htp.p('in Main');
32: htp.htmlClose;
33: end if; -- validateSession

Line 30: htp.p('');

26:
27: htp.p('');
28: FND_MESSAGE.SET_NAME('ICX','ICX_BROWSER');
29: htp.p(FND_MESSAGE.Get);
30: htp.p('');
31: htp.p('in Main');
32: htp.htmlClose;
33: end if; -- validateSession
34:

Line 31: htp.p('in Main');

27: htp.p('');
28: FND_MESSAGE.SET_NAME('ICX','ICX_BROWSER');
29: htp.p(FND_MESSAGE.Get);
30: htp.p('');
31: htp.p('in Main');
32: htp.htmlClose;
33: end if; -- validateSession
34:
35: end main;

Line 32: htp.htmlClose;

28: FND_MESSAGE.SET_NAME('ICX','ICX_BROWSER');
29: htp.p(FND_MESSAGE.Get);
30: htp.p('');
31: htp.p('in Main');
32: htp.htmlClose;
33: end if; -- validateSession
34:
35: end main;
36:

Line 80: htp.htmlOpen;

76: l_language := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
77: icx_util.getPrompts(601,'ICX_RELATED_CATEGORIES_R',l_title,l_prompts);
78: icx_util.getPrompts(178,'ICX_LOV',lov_title,lov_prompts);
79:
80: htp.htmlOpen;
81: htp.headOpen;
82: icx_util.copyright;
83:
84: htp.title(l_title);

Line 81: htp.headOpen;

77: icx_util.getPrompts(601,'ICX_RELATED_CATEGORIES_R',l_title,l_prompts);
78: icx_util.getPrompts(178,'ICX_LOV',lov_title,lov_prompts);
79:
80: htp.htmlOpen;
81: htp.headOpen;
82: icx_util.copyright;
83:
84: htp.title(l_title);
85:

Line 84: htp.title(l_title);

80: htp.htmlOpen;
81: htp.headOpen;
82: icx_util.copyright;
83:
84: htp.title(l_title);
85:
86: js.scriptOpen;
87: icx_admin_sig.help_win_script('/OA_HTML/'||l_language||'/ICXHLMCH.htm');
88: icx_util.LOVScript;

Line 92: htp.p('function autoquery() {

88: icx_util.LOVScript;
89: js.null_alert;
90: js.equal_alert;
91:
92: htp.p('function autoquery() {
93: parent.tail.document.Tail.p_category_set_id.value = document.Category.ICX_CATEGORY_SET_ID.options[document.Category.ICX_CATEGORY_SET_ID.selectedIndex].value
94: parent.tail.document.Tail.p_category_id.value = document.Category.ICX_CATEGORY_ID.value
95: parent.tail.document.Tail.p_category_name.value = document.Category.ICX_CATEGORY.value
96: parent.tail.document.Tail.submit()

Line 99: htp.p('function set_changed() {

95: parent.tail.document.Tail.p_category_name.value = document.Category.ICX_CATEGORY.value
96: parent.tail.document.Tail.submit()
97: }');
98:
99: htp.p('function set_changed() {
100: document.Category.ICX_CATEGORY_ID.value = ""
101: document.Category.ICX_CATEGORY.value = ""
102: document.Category.ICX_RELATED_CATEGORY_ID.value = ""
103: document.Category.ICX_RELATED_CATEGORY.value = ""

Line 110: htp.p('function cat_changed() {

106: parent.tail.document.Tail.p_category_name.value = ""
107: parent.tail.document.Tail.submit()
108: }');
109:
110: htp.p('function cat_changed() {
111: document.Category.ICX_CATEGORY_ID.value = ""
112: parent.tail.document.Tail.p_category_set_id.value = document.Category.ICX_CATEGORY_SET_ID.options[document.Category.ICX_CATEGORY_SET_ID.selectedIndex].value
113: parent.tail.document.Tail.p_category_id.value = ""
114: parent.tail.document.Tail.p_category_name.value = document.Category.ICX_CATEGORY.value

Line 118: htp.p('function pre_cat_LOV() {

114: parent.tail.document.Tail.p_category_name.value = document.Category.ICX_CATEGORY.value
115: parent.tail.document.Tail.submit()
116: }');
117:
118: htp.p('function pre_cat_LOV() {
119: var l_where = "CATEGORY_SET_ID=" + document.Category.ICX_CATEGORY_SET_ID.options[document.Category.ICX_CATEGORY_SET_ID.selectedIndex].value
120: LOV(''178'',''ICX_CATEGORY'',''601'',''ICX_RELATED_CATEGORIES_R'',''Category'',''header'','''',l_where)
121: }');
122:

Line 123: htp.p('function post_cat_LOV(cat_id, cat_name) {

119: var l_where = "CATEGORY_SET_ID=" + document.Category.ICX_CATEGORY_SET_ID.options[document.Category.ICX_CATEGORY_SET_ID.selectedIndex].value
120: LOV(''178'',''ICX_CATEGORY'',''601'',''ICX_RELATED_CATEGORIES_R'',''Category'',''header'','''',l_where)
121: }');
122:
123: htp.p('function post_cat_LOV(cat_id, cat_name) {
124: parent.tail.document.Tail.p_category_set_id.value = document.Category.ICX_CATEGORY_SET_ID.options[document.Category.ICX_CATEGORY_SET_ID.selectedIndex].value
125: parent.tail.document.Tail.p_category_id.value = cat_id
126: parent.tail.document.Tail.p_category_name.value = cat_name
127: parent.tail.document.Tail.submit()

Line 131: htp.p('function pre_rel_cat_LOV() {

127: parent.tail.document.Tail.submit()
128: }');
129:
130: FND_MESSAGE.SET_NAME('ICX','ICX_CAT_BEFORE');
131: htp.p('function pre_rel_cat_LOV() {
132: if (!null_alert(document.Category.ICX_CATEGORY.value,"'||icx_util.replace_quotes(FND_MESSAGE.Get)||'")) {
133: var l_where = "CATEGORY_SET_ID=" + document.Category.ICX_CATEGORY_SET_ID.options[document.Category.ICX_CATEGORY_SET_ID.selectedIndex].value
134: LOV(''178'',''ICX_RELATED_CATEGORY'',''601'',''ICX_RELATED_CATEGORIES_R'',''Category'',''header'','''',l_where)
135: }

Line 143: htp.p('function cat_submit() {

139: -- var l_where = "CATEGORY_SET_ID=" + document.Category.ICX_CATEGORY_SET_ID.options[document.Category.ICX_CATEGORY_SET_ID.selectedIndex].value + "^@~^and^@~^CONCATENATED_SEGMENTS<>''" + document.Category.ICX_CATEGORY.value + "''"
140:
141:
142: FND_MESSAGE.SET_NAME('ICX','ICX_NOT_NULL');
143: htp.p('function cat_submit() {
144: if (!null_alert(document.Category.ICX_CATEGORY.value,"'||icx_util.replace_quotes(l_prompts(4))||' '||icx_util.replace_quotes(FND_MESSAGE.Get)||'")) {
145: if (document.Category.ICX_RELATION.options[document.Category.ICX_RELATION.selectedIndex].value != "TOP") {');
146: FND_MESSAGE.SET_NAME('ICX','ICX_NOT_NULL');
147: htp.p(' if (!null_alert(document.Category.ICX_RELATED_CATEGORY.value,"'||icx_util.replace_quotes(l_prompts(7))||' '||icx_util.replace_quotes(FND_MESSAGE.Get)||'")) {');

Line 147: htp.p(' if (!null_alert(document.Category.ICX_RELATED_CATEGORY.value,"'||icx_util.replace_quotes(l_prompts(7))||' '||icx_util.replace_quotes(FND_MESSAGE.Get)||'")) {');

143: htp.p('function cat_submit() {
144: if (!null_alert(document.Category.ICX_CATEGORY.value,"'||icx_util.replace_quotes(l_prompts(4))||' '||icx_util.replace_quotes(FND_MESSAGE.Get)||'")) {
145: if (document.Category.ICX_RELATION.options[document.Category.ICX_RELATION.selectedIndex].value != "TOP") {');
146: FND_MESSAGE.SET_NAME('ICX','ICX_NOT_NULL');
147: htp.p(' if (!null_alert(document.Category.ICX_RELATED_CATEGORY.value,"'||icx_util.replace_quotes(l_prompts(7))||' '||icx_util.replace_quotes(FND_MESSAGE.Get)||'")) {');
148: FND_MESSAGE.SET_NAME('ICX','ICX_CAT_PARENT');
149: htp.p(' if (!equal_alert(document.Category.ICX_CATEGORY.value,document.Category.ICX_RELATED_CATEGORY.value,"'||icx_util.replace_quotes(FND_MESSAGE.Get)||'")) {
150: document.Category.submit()
151: }

Line 149: htp.p(' if (!equal_alert(document.Category.ICX_CATEGORY.value,document.Category.ICX_RELATED_CATEGORY.value,"'||icx_util.replace_quotes(FND_MESSAGE.Get)||'")) {

145: if (document.Category.ICX_RELATION.options[document.Category.ICX_RELATION.selectedIndex].value != "TOP") {');
146: FND_MESSAGE.SET_NAME('ICX','ICX_NOT_NULL');
147: htp.p(' if (!null_alert(document.Category.ICX_RELATED_CATEGORY.value,"'||icx_util.replace_quotes(l_prompts(7))||' '||icx_util.replace_quotes(FND_MESSAGE.Get)||'")) {');
148: FND_MESSAGE.SET_NAME('ICX','ICX_CAT_PARENT');
149: htp.p(' if (!equal_alert(document.Category.ICX_CATEGORY.value,document.Category.ICX_RELATED_CATEGORY.value,"'||icx_util.replace_quotes(FND_MESSAGE.Get)||'")) {
150: document.Category.submit()
151: }
152: }
153: } else {

Line 160: htp.headClose;

156: }
157: }');
158:
159: js.scriptClose;
160: htp.headClose;
161: htp.bodyOpen(icx_admin_sig.background);
162: icx_admin_sig.toolbar(language_code => l_language);
163:
164: htp.formOpen(l_agent||'/icx_cat.cat_insert','POST','','','NAME="Category"');

Line 161: htp.bodyOpen(icx_admin_sig.background);

157: }');
158:
159: js.scriptClose;
160: htp.headClose;
161: htp.bodyOpen(icx_admin_sig.background);
162: icx_admin_sig.toolbar(language_code => l_language);
163:
164: htp.formOpen(l_agent||'/icx_cat.cat_insert','POST','','','NAME="Category"');
165:

Line 164: htp.formOpen(l_agent||'/icx_cat.cat_insert','POST','','','NAME="Category"');

160: htp.headClose;
161: htp.bodyOpen(icx_admin_sig.background);
162: icx_admin_sig.toolbar(language_code => l_language);
163:
164: htp.formOpen(l_agent||'/icx_cat.cat_insert','POST','','','NAME="Category"');
165:
166: htp.tableOpen;
167: htp.tableRowOpen;
168: htp.tableData('

'||l_title||'

');

Line 166: htp.tableOpen;

162: icx_admin_sig.toolbar(language_code => l_language);
163:
164: htp.formOpen(l_agent||'/icx_cat.cat_insert','POST','','','NAME="Category"');
165:
166: htp.tableOpen;
167: htp.tableRowOpen;
168: htp.tableData('

'||l_title||'

');
169: htp.tableRowClose;
170: htp.tableClose;

Line 167: htp.tableRowOpen;

163:
164: htp.formOpen(l_agent||'/icx_cat.cat_insert','POST','','','NAME="Category"');
165:
166: htp.tableOpen;
167: htp.tableRowOpen;
168: htp.tableData('

'||l_title||'

');
169: htp.tableRowClose;
170: htp.tableClose;
171:

Line 168: htp.tableData('

'||l_title||'

');

164: htp.formOpen(l_agent||'/icx_cat.cat_insert','POST','','','NAME="Category"');
165:
166: htp.tableOpen;
167: htp.tableRowOpen;
168: htp.tableData('

'||l_title||'

');
169: htp.tableRowClose;
170: htp.tableClose;
171:
172: htp.tableOpen;

Line 169: htp.tableRowClose;

165:
166: htp.tableOpen;
167: htp.tableRowOpen;
168: htp.tableData('

'||l_title||'

');
169: htp.tableRowClose;
170: htp.tableClose;
171:
172: htp.tableOpen;
173:

Line 170: htp.tableClose;

166: htp.tableOpen;
167: htp.tableRowOpen;
168: htp.tableData('

'||l_title||'

');
169: htp.tableRowClose;
170: htp.tableClose;
171:
172: htp.tableOpen;
173:
174: -- Category Set poplist

Line 172: htp.tableOpen;

168: htp.tableData('

'||l_title||'

');
169: htp.tableRowClose;
170: htp.tableClose;
171:
172: htp.tableOpen;
173:
174: -- Category Set poplist
175: htp.tableRowOpen;
176: htp.tableData(l_prompts(2),'RIGHT');

Line 175: htp.tableRowOpen;

171:
172: htp.tableOpen;
173:
174: -- Category Set poplist
175: htp.tableRowOpen;
176: htp.tableData(l_prompts(2),'RIGHT');
177: htp.p(''||htf.formSelectOpen('ICX_CATEGORY_SET_ID','','','onchange="set_changed()"'));
178: open category_sets;
179: loop

Line 176: htp.tableData(l_prompts(2),'RIGHT');

172: htp.tableOpen;
173:
174: -- Category Set poplist
175: htp.tableRowOpen;
176: htp.tableData(l_prompts(2),'RIGHT');
177: htp.p(''||htf.formSelectOpen('ICX_CATEGORY_SET_ID','','','onchange="set_changed()"'));
178: open category_sets;
179: loop
180: fetch category_sets into temp_cat_set_id, temp_cat_set;

Line 177: htp.p(''||htf.formSelectOpen('ICX_CATEGORY_SET_ID','','','onchange="set_changed()"'));

173:
174: -- Category Set poplist
175: htp.tableRowOpen;
176: htp.tableData(l_prompts(2),'RIGHT');
177: htp.p(''||htf.formSelectOpen('ICX_CATEGORY_SET_ID','','','onchange="set_changed()"'));
178: open category_sets;
179: loop
180: fetch category_sets into temp_cat_set_id, temp_cat_set;
181: exit when category_sets%NOTFOUND;

Line 183: htp.formSelectOption(temp_cat_set,'SELECTED','VALUE="'||temp_cat_set_id||'"');

179: loop
180: fetch category_sets into temp_cat_set_id, temp_cat_set;
181: exit when category_sets%NOTFOUND;
182: if temp_cat_set_id = p_category_set_id then
183: htp.formSelectOption(temp_cat_set,'SELECTED','VALUE="'||temp_cat_set_id||'"');
184: else
185: htp.formSelectOption(temp_cat_set,'','VALUE="'||temp_cat_set_id||'"');
186: end if;
187: end loop;

Line 185: htp.formSelectOption(temp_cat_set,'','VALUE="'||temp_cat_set_id||'"');

181: exit when category_sets%NOTFOUND;
182: if temp_cat_set_id = p_category_set_id then
183: htp.formSelectOption(temp_cat_set,'SELECTED','VALUE="'||temp_cat_set_id||'"');
184: else
185: htp.formSelectOption(temp_cat_set,'','VALUE="'||temp_cat_set_id||'"');
186: end if;
187: end loop;
188: close category_sets;
189: htp.p(htf.formSelectClose||'');

Line 189: htp.p(htf.formSelectClose||'');

185: htp.formSelectOption(temp_cat_set,'','VALUE="'||temp_cat_set_id||'"');
186: end if;
187: end loop;
188: close category_sets;
189: htp.p(htf.formSelectClose||'');
190:
191: -- Category text field
192: htp.formHidden('ICX_CATEGORY_ID',p_category_id);
193: htp.tableData(l_prompts(4),'RIGHT');

Line 192: htp.formHidden('ICX_CATEGORY_ID',p_category_id);

188: close category_sets;
189: htp.p(htf.formSelectClose||'');
190:
191: -- Category text field
192: htp.formHidden('ICX_CATEGORY_ID',p_category_id);
193: htp.tableData(l_prompts(4),'RIGHT');
194: htp.tableData(htf.formText('ICX_CATEGORY',30,81,p_category,'onchange="cat_changed()"'));
195: htp.tableData(htf.anchor('javascript:pre_cat_LOV()',htf.img('/OA_MEDIA/'||l_language||'/FNDILOV.gif','CENTER',icx_util.replace_alt_quotes(lov_title),'','BORDER=0 WIDTH=23 HEIGHT=21'),'','onMouseOver="window.status='''||
196: icx_util.replace_onMouseOver_quotes(lov_title)||''';return true"'));

Line 193: htp.tableData(l_prompts(4),'RIGHT');

189: htp.p(htf.formSelectClose||'');
190:
191: -- Category text field
192: htp.formHidden('ICX_CATEGORY_ID',p_category_id);
193: htp.tableData(l_prompts(4),'RIGHT');
194: htp.tableData(htf.formText('ICX_CATEGORY',30,81,p_category,'onchange="cat_changed()"'));
195: htp.tableData(htf.anchor('javascript:pre_cat_LOV()',htf.img('/OA_MEDIA/'||l_language||'/FNDILOV.gif','CENTER',icx_util.replace_alt_quotes(lov_title),'','BORDER=0 WIDTH=23 HEIGHT=21'),'','onMouseOver="window.status='''||
196: icx_util.replace_onMouseOver_quotes(lov_title)||''';return true"'));
197: htp.tableRowClose;

Line 194: htp.tableData(htf.formText('ICX_CATEGORY',30,81,p_category,'onchange="cat_changed()"'));

190:
191: -- Category text field
192: htp.formHidden('ICX_CATEGORY_ID',p_category_id);
193: htp.tableData(l_prompts(4),'RIGHT');
194: htp.tableData(htf.formText('ICX_CATEGORY',30,81,p_category,'onchange="cat_changed()"'));
195: htp.tableData(htf.anchor('javascript:pre_cat_LOV()',htf.img('/OA_MEDIA/'||l_language||'/FNDILOV.gif','CENTER',icx_util.replace_alt_quotes(lov_title),'','BORDER=0 WIDTH=23 HEIGHT=21'),'','onMouseOver="window.status='''||
196: icx_util.replace_onMouseOver_quotes(lov_title)||''';return true"'));
197: htp.tableRowClose;
198:

Line 195: htp.tableData(htf.anchor('javascript:pre_cat_LOV()',htf.img('/OA_MEDIA/'||l_language||'/FNDILOV.gif','CENTER',icx_util.replace_alt_quotes(lov_title),'','BORDER=0 WIDTH=23 HEIGHT=21'),'','onMouseOver="window.status='''||

191: -- Category text field
192: htp.formHidden('ICX_CATEGORY_ID',p_category_id);
193: htp.tableData(l_prompts(4),'RIGHT');
194: htp.tableData(htf.formText('ICX_CATEGORY',30,81,p_category,'onchange="cat_changed()"'));
195: htp.tableData(htf.anchor('javascript:pre_cat_LOV()',htf.img('/OA_MEDIA/'||l_language||'/FNDILOV.gif','CENTER',icx_util.replace_alt_quotes(lov_title),'','BORDER=0 WIDTH=23 HEIGHT=21'),'','onMouseOver="window.status='''||
196: icx_util.replace_onMouseOver_quotes(lov_title)||''';return true"'));
197: htp.tableRowClose;
198:
199: -- Relation poplist

Line 197: htp.tableRowClose;

193: htp.tableData(l_prompts(4),'RIGHT');
194: htp.tableData(htf.formText('ICX_CATEGORY',30,81,p_category,'onchange="cat_changed()"'));
195: htp.tableData(htf.anchor('javascript:pre_cat_LOV()',htf.img('/OA_MEDIA/'||l_language||'/FNDILOV.gif','CENTER',icx_util.replace_alt_quotes(lov_title),'','BORDER=0 WIDTH=23 HEIGHT=21'),'','onMouseOver="window.status='''||
196: icx_util.replace_onMouseOver_quotes(lov_title)||''';return true"'));
197: htp.tableRowClose;
198:
199: -- Relation poplist
200: htp.tableRowOpen;
201: htp.tableData(l_prompts(5),'RIGHT');

Line 200: htp.tableRowOpen;

196: icx_util.replace_onMouseOver_quotes(lov_title)||''';return true"'));
197: htp.tableRowClose;
198:
199: -- Relation poplist
200: htp.tableRowOpen;
201: htp.tableData(l_prompts(5),'RIGHT');
202: htp.p(''||htf.formSelectOpen('ICX_RELATION'));
203: open relations;
204: loop

Line 201: htp.tableData(l_prompts(5),'RIGHT');

197: htp.tableRowClose;
198:
199: -- Relation poplist
200: htp.tableRowOpen;
201: htp.tableData(l_prompts(5),'RIGHT');
202: htp.p(''||htf.formSelectOpen('ICX_RELATION'));
203: open relations;
204: loop
205: fetch relations into temp_relation_code, temp_relation;

Line 202: htp.p(''||htf.formSelectOpen('ICX_RELATION'));

198:
199: -- Relation poplist
200: htp.tableRowOpen;
201: htp.tableData(l_prompts(5),'RIGHT');
202: htp.p(''||htf.formSelectOpen('ICX_RELATION'));
203: open relations;
204: loop
205: fetch relations into temp_relation_code, temp_relation;
206: exit when relations%NOTFOUND;

Line 207: htp.formSelectOption(temp_relation,'','VALUE="'||temp_relation_code||'"');

203: open relations;
204: loop
205: fetch relations into temp_relation_code, temp_relation;
206: exit when relations%NOTFOUND;
207: htp.formSelectOption(temp_relation,'','VALUE="'||temp_relation_code||'"');
208: end loop;
209: close relations;
210: htp.p(htf.formSelectClose||'');
211:

Line 210: htp.p(htf.formSelectClose||'');

206: exit when relations%NOTFOUND;
207: htp.formSelectOption(temp_relation,'','VALUE="'||temp_relation_code||'"');
208: end loop;
209: close relations;
210: htp.p(htf.formSelectClose||'');
211:
212: -- Related Category text field
213: htp.formHidden('ICX_RELATED_CATEGORY_ID');
214: htp.tableData(l_prompts(7),'RIGHT');

Line 213: htp.formHidden('ICX_RELATED_CATEGORY_ID');

209: close relations;
210: htp.p(htf.formSelectClose||'');
211:
212: -- Related Category text field
213: htp.formHidden('ICX_RELATED_CATEGORY_ID');
214: htp.tableData(l_prompts(7),'RIGHT');
215: htp.tableData(htf.formText('ICX_RELATED_CATEGORY',30,81,'','onchange="document.Category.ICX_RELATED_CATEGORY_ID.value = ''''"'));
216: htp.tableData(htf.anchor('javascript:pre_rel_cat_LOV()',htf.img('/OA_MEDIA/'||l_language||
217: '/FNDILOV.gif','CENTER',icx_util.replace_alt_quotes(lov_title),'','BORDER=0 WIDTH=23 HEIGHT=21'),'','onMouseOver="window.status='''||icx_util.replace_onMouseOver_quotes(lov_title)||''';return true"'));

Line 214: htp.tableData(l_prompts(7),'RIGHT');

210: htp.p(htf.formSelectClose||'');
211:
212: -- Related Category text field
213: htp.formHidden('ICX_RELATED_CATEGORY_ID');
214: htp.tableData(l_prompts(7),'RIGHT');
215: htp.tableData(htf.formText('ICX_RELATED_CATEGORY',30,81,'','onchange="document.Category.ICX_RELATED_CATEGORY_ID.value = ''''"'));
216: htp.tableData(htf.anchor('javascript:pre_rel_cat_LOV()',htf.img('/OA_MEDIA/'||l_language||
217: '/FNDILOV.gif','CENTER',icx_util.replace_alt_quotes(lov_title),'','BORDER=0 WIDTH=23 HEIGHT=21'),'','onMouseOver="window.status='''||icx_util.replace_onMouseOver_quotes(lov_title)||''';return true"'));
218: htp.tableRowClose;

Line 215: htp.tableData(htf.formText('ICX_RELATED_CATEGORY',30,81,'','onchange="document.Category.ICX_RELATED_CATEGORY_ID.value = ''''"'));

211:
212: -- Related Category text field
213: htp.formHidden('ICX_RELATED_CATEGORY_ID');
214: htp.tableData(l_prompts(7),'RIGHT');
215: htp.tableData(htf.formText('ICX_RELATED_CATEGORY',30,81,'','onchange="document.Category.ICX_RELATED_CATEGORY_ID.value = ''''"'));
216: htp.tableData(htf.anchor('javascript:pre_rel_cat_LOV()',htf.img('/OA_MEDIA/'||l_language||
217: '/FNDILOV.gif','CENTER',icx_util.replace_alt_quotes(lov_title),'','BORDER=0 WIDTH=23 HEIGHT=21'),'','onMouseOver="window.status='''||icx_util.replace_onMouseOver_quotes(lov_title)||''';return true"'));
218: htp.tableRowClose;
219: htp.tableClose;

Line 216: htp.tableData(htf.anchor('javascript:pre_rel_cat_LOV()',htf.img('/OA_MEDIA/'||l_language||

212: -- Related Category text field
213: htp.formHidden('ICX_RELATED_CATEGORY_ID');
214: htp.tableData(l_prompts(7),'RIGHT');
215: htp.tableData(htf.formText('ICX_RELATED_CATEGORY',30,81,'','onchange="document.Category.ICX_RELATED_CATEGORY_ID.value = ''''"'));
216: htp.tableData(htf.anchor('javascript:pre_rel_cat_LOV()',htf.img('/OA_MEDIA/'||l_language||
217: '/FNDILOV.gif','CENTER',icx_util.replace_alt_quotes(lov_title),'','BORDER=0 WIDTH=23 HEIGHT=21'),'','onMouseOver="window.status='''||icx_util.replace_onMouseOver_quotes(lov_title)||''';return true"'));
218: htp.tableRowClose;
219: htp.tableClose;
220:

Line 218: htp.tableRowClose;

214: htp.tableData(l_prompts(7),'RIGHT');
215: htp.tableData(htf.formText('ICX_RELATED_CATEGORY',30,81,'','onchange="document.Category.ICX_RELATED_CATEGORY_ID.value = ''''"'));
216: htp.tableData(htf.anchor('javascript:pre_rel_cat_LOV()',htf.img('/OA_MEDIA/'||l_language||
217: '/FNDILOV.gif','CENTER',icx_util.replace_alt_quotes(lov_title),'','BORDER=0 WIDTH=23 HEIGHT=21'),'','onMouseOver="window.status='''||icx_util.replace_onMouseOver_quotes(lov_title)||''';return true"'));
218: htp.tableRowClose;
219: htp.tableClose;
220:
221:
222: -- Write submit and clear buttons

Line 219: htp.tableClose;

215: htp.tableData(htf.formText('ICX_RELATED_CATEGORY',30,81,'','onchange="document.Category.ICX_RELATED_CATEGORY_ID.value = ''''"'));
216: htp.tableData(htf.anchor('javascript:pre_rel_cat_LOV()',htf.img('/OA_MEDIA/'||l_language||
217: '/FNDILOV.gif','CENTER',icx_util.replace_alt_quotes(lov_title),'','BORDER=0 WIDTH=23 HEIGHT=21'),'','onMouseOver="window.status='''||icx_util.replace_onMouseOver_quotes(lov_title)||''';return true"'));
218: htp.tableRowClose;
219: htp.tableClose;
220:
221:
222: -- Write submit and clear buttons
223: htp.tableOpen;

Line 223: htp.tableOpen;

219: htp.tableClose;
220:
221:
222: -- Write submit and clear buttons
223: htp.tableOpen;
224: htp.tableRowOpen;
225: icx_util.DynamicButton(l_prompts(8),'FNDBSBMT.gif',l_prompts(8),'javascript:cat_submit()',l_language,FALSE);
226: if (instr(c_browser, 'MSIE') = 0) then
227: icx_util.DynamicButton(l_prompts(9),'FNDBCLR.gif',l_prompts(9),'javascript:document.Category.reset()',l_language,FALSE);

Line 224: htp.tableRowOpen;

220:
221:
222: -- Write submit and clear buttons
223: htp.tableOpen;
224: htp.tableRowOpen;
225: icx_util.DynamicButton(l_prompts(8),'FNDBSBMT.gif',l_prompts(8),'javascript:cat_submit()',l_language,FALSE);
226: if (instr(c_browser, 'MSIE') = 0) then
227: icx_util.DynamicButton(l_prompts(9),'FNDBCLR.gif',l_prompts(9),'javascript:document.Category.reset()',l_language,FALSE);
228: end if;

Line 229: htp.tableRowClose;

225: icx_util.DynamicButton(l_prompts(8),'FNDBSBMT.gif',l_prompts(8),'javascript:cat_submit()',l_language,FALSE);
226: if (instr(c_browser, 'MSIE') = 0) then
227: icx_util.DynamicButton(l_prompts(9),'FNDBCLR.gif',l_prompts(9),'javascript:document.Category.reset()',l_language,FALSE);
228: end if;
229: htp.tableRowClose;
230: htp.tableClose;
231:
232:
233: -- Query relationships if screen is being repainted after a commit

Line 230: htp.tableClose;

226: if (instr(c_browser, 'MSIE') = 0) then
227: icx_util.DynamicButton(l_prompts(9),'FNDBCLR.gif',l_prompts(9),'javascript:document.Category.reset()',l_language,FALSE);
228: end if;
229: htp.tableRowClose;
230: htp.tableClose;
231:
232:
233: -- Query relationships if screen is being repainted after a commit
234: if p_query_flag = 'T' then

Line 235: htp.p('');
238: end if;
239:

Line 236: htp.p('autoquery()');

232:
233: -- Query relationships if screen is being repainted after a commit
234: if p_query_flag = 'T' then
235: htp.p('');
238: end if;
239:
240:

Line 237: htp.p('');

233: -- Query relationships if screen is being repainted after a commit
234: if p_query_flag = 'T' then
235: htp.p('');
238: end if;
239:
240:
241: htp.formClose;

Line 241: htp.formClose;

237: htp.p('');
238: end if;
239:
240:
241: htp.formClose;
242: icx_sig.footer;
243: htp.bodyClose;
244: htp.htmlClose;
245:

Line 243: htp.bodyClose;

239:
240:
241: htp.formClose;
242: icx_sig.footer;
243: htp.bodyClose;
244: htp.htmlClose;
245:
246: end if; -- ValidateSession
247:

Line 244: htp.htmlClose;

240:
241: htp.formClose;
242: icx_sig.footer;
243: htp.bodyClose;
244: htp.htmlClose;
245:
246: end if; -- ValidateSession
247:
248: exception

Line 297: htp.htmlOpen;

293: icx_util.error_page_setup;
294: l_language := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
295: icx_util.getPrompts(601,'ICX_RELATED_CATEGORIES_DISP_R',l_title,l_prompts);
296:
297: htp.htmlOpen;
298: htp.headOpen;
299: icx_util.copyright;
300: js.scriptOpen;
301:

Line 298: htp.headOpen;

294: l_language := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
295: icx_util.getPrompts(601,'ICX_RELATED_CATEGORIES_DISP_R',l_title,l_prompts);
296:
297: htp.htmlOpen;
298: htp.headOpen;
299: icx_util.copyright;
300: js.scriptOpen;
301:
302: -- Javascript function to handle CD buttons

Line 303: htp.p('function rows(start_num, end_num) {

299: icx_util.copyright;
300: js.scriptOpen;
301:
302: -- Javascript function to handle CD buttons
303: htp.p('function rows(start_num, end_num) {
304: document.Tail.p_start_row.value = start_num
305: document.Tail.p_end_row.value = end_num
306: document.Tail.submit()
307: }');

Line 311: htp.p('function delete_relation(cat, related_cat, cat_set_id, cat_id, related_cat_id) {

307: }');
308:
309: -- javascript function to confirm delete of relationship
310: FND_MESSAGE.Set_name('ICX','ICX_DELETE');
311: htp.p('function delete_relation(cat, related_cat, cat_set_id, cat_id, related_cat_id) {
312: if (confirm("'||icx_util.replace_quotes(FND_MESSAGE.Get)||': " + cat + " - " + related_cat)) {
313: open('''||l_agent||'/ICX_CAT.cat_delete?icx_category_set_id='' + cat_set_id + ''&icx_category_id='' + cat_id + ''&icx_related_category_id='' + related_cat_id,''tail'')
314: }
315: }');

Line 318: htp.headClose;

314: }
315: }');
316:
317: js.scriptClose;
318: htp.headClose;
319:
320: htp.bodyOpen(icx_admin_sig.background);
321:
322: htp.formOpen(l_agent||'/icx_cat.cat_tail','POST','','','NAME="Tail"');

Line 320: htp.bodyOpen(icx_admin_sig.background);

316:
317: js.scriptClose;
318: htp.headClose;
319:
320: htp.bodyOpen(icx_admin_sig.background);
321:
322: htp.formOpen(l_agent||'/icx_cat.cat_tail','POST','','','NAME="Tail"');
323:
324: htp.formHidden('p_category_set_id',p_category_set_id);

Line 322: htp.formOpen(l_agent||'/icx_cat.cat_tail','POST','','','NAME="Tail"');

318: htp.headClose;
319:
320: htp.bodyOpen(icx_admin_sig.background);
321:
322: htp.formOpen(l_agent||'/icx_cat.cat_tail','POST','','','NAME="Tail"');
323:
324: htp.formHidden('p_category_set_id',p_category_set_id);
325: htp.formHidden('p_category_id',p_category_id);
326: htp.formHidden('p_category_name',p_category_name);

Line 324: htp.formHidden('p_category_set_id',p_category_set_id);

320: htp.bodyOpen(icx_admin_sig.background);
321:
322: htp.formOpen(l_agent||'/icx_cat.cat_tail','POST','','','NAME="Tail"');
323:
324: htp.formHidden('p_category_set_id',p_category_set_id);
325: htp.formHidden('p_category_id',p_category_id);
326: htp.formHidden('p_category_name',p_category_name);
327: htp.formHidden('p_start_row',p_start_row);
328: htp.formHidden('p_end_row',p_end_row);

Line 325: htp.formHidden('p_category_id',p_category_id);

321:
322: htp.formOpen(l_agent||'/icx_cat.cat_tail','POST','','','NAME="Tail"');
323:
324: htp.formHidden('p_category_set_id',p_category_set_id);
325: htp.formHidden('p_category_id',p_category_id);
326: htp.formHidden('p_category_name',p_category_name);
327: htp.formHidden('p_start_row',p_start_row);
328: htp.formHidden('p_end_row',p_end_row);
329:

Line 326: htp.formHidden('p_category_name',p_category_name);

322: htp.formOpen(l_agent||'/icx_cat.cat_tail','POST','','','NAME="Tail"');
323:
324: htp.formHidden('p_category_set_id',p_category_set_id);
325: htp.formHidden('p_category_id',p_category_id);
326: htp.formHidden('p_category_name',p_category_name);
327: htp.formHidden('p_start_row',p_start_row);
328: htp.formHidden('p_end_row',p_end_row);
329:
330:

Line 327: htp.formHidden('p_start_row',p_start_row);

323:
324: htp.formHidden('p_category_set_id',p_category_set_id);
325: htp.formHidden('p_category_id',p_category_id);
326: htp.formHidden('p_category_name',p_category_name);
327: htp.formHidden('p_start_row',p_start_row);
328: htp.formHidden('p_end_row',p_end_row);
329:
330:
331: -- if p_category_id is null then check that p_category_name is valid

Line 328: htp.formHidden('p_end_row',p_end_row);

324: htp.formHidden('p_category_set_id',p_category_set_id);
325: htp.formHidden('p_category_id',p_category_id);
326: htp.formHidden('p_category_name',p_category_name);
327: htp.formHidden('p_start_row',p_start_row);
328: htp.formHidden('p_end_row',p_end_row);
329:
330:
331: -- if p_category_id is null then check that p_category_name is valid
332: if p_category_id is null then

Line 434: htp.tableOpen('BORDER=1');

430: end if; -- CD Buttons
431:
432:
433: -- display table header
434: htp.tableOpen('BORDER=1');
435: htp.p('');
436: for k in ak_query_pkg.g_items_table.FIRST..ak_query_pkg.g_items_table.LAST loop
437: if ak_query_pkg.g_items_table(k).secured_column = 'F' and
438: ak_query_pkg.g_items_table(k).node_display_flag = 'Y' then

Line 435: htp.p('');

431:
432:
433: -- display table header
434: htp.tableOpen('BORDER=1');
435: htp.p('');
436: for k in ak_query_pkg.g_items_table.FIRST..ak_query_pkg.g_items_table.LAST loop
437: if ak_query_pkg.g_items_table(k).secured_column = 'F' and
438: ak_query_pkg.g_items_table(k).node_display_flag = 'Y' then
439: htp.tableData(htf.strong(ak_query_pkg.g_items_table(k).attribute_label_long),'LEFT');

Line 439: htp.tableData(htf.strong(ak_query_pkg.g_items_table(k).attribute_label_long),'LEFT');

435: htp.p('');
436: for k in ak_query_pkg.g_items_table.FIRST..ak_query_pkg.g_items_table.LAST loop
437: if ak_query_pkg.g_items_table(k).secured_column = 'F' and
438: ak_query_pkg.g_items_table(k).node_display_flag = 'Y' then
439: htp.tableData(htf.strong(ak_query_pkg.g_items_table(k).attribute_label_long),'LEFT');
440: end if;
441: end loop;
442: htp.tableRowClose;
443:

Line 442: htp.tableRowClose;

438: ak_query_pkg.g_items_table(k).node_display_flag = 'Y' then
439: htp.tableData(htf.strong(ak_query_pkg.g_items_table(k).attribute_label_long),'LEFT');
440: end if;
441: end loop;
442: htp.tableRowClose;
443:
444: end if; -- CD Buttons and table header
445:
446:

Line 452: htp.p('');

448: icx_util.transfer_Row_To_Column(ak_query_pkg.g_results_table(i-1), l_result_row_table);
449:
450:
451: -- display one row of data
452: htp.p('');
453: for k in ak_query_pkg.g_items_table.FIRST..ak_query_pkg.g_items_table.LAST loop
454: if ak_query_pkg.g_items_table(k).secured_column = 'F' and
455: ak_query_pkg.g_items_table(k).node_display_flag = 'Y' then
456:

Line 466: htp.tableData('
');

462: end if;
463: end loop;
464: -- dont display related category if relationship is TOP
465: if l_result_row_table(ak_query_pkg.g_items_table(temp_relation_item).value_id) = 'TOP' then
466: htp.tableData('
');
467: else
468: htp.p(icx_on_utilities.formatData(icx_on_utilities.formatText(l_result_row_table(ak_query_pkg.g_items_table(k).value_id),
469: ak_query_pkg.g_items_table(k).bold,ak_query_pkg.g_items_table(k).italic),ak_query_pkg.g_items_table(k).horizontal_alignment,ak_query_pkg.g_items_table(k).vertical_alignment));
470: end if;

Line 468: htp.p(icx_on_utilities.formatData(icx_on_utilities.formatText(l_result_row_table(ak_query_pkg.g_items_table(k).value_id),

464: -- dont display related category if relationship is TOP
465: if l_result_row_table(ak_query_pkg.g_items_table(temp_relation_item).value_id) = 'TOP' then
466: htp.tableData('
');
467: else
468: htp.p(icx_on_utilities.formatData(icx_on_utilities.formatText(l_result_row_table(ak_query_pkg.g_items_table(k).value_id),
469: ak_query_pkg.g_items_table(k).bold,ak_query_pkg.g_items_table(k).italic),ak_query_pkg.g_items_table(k).horizontal_alignment,ak_query_pkg.g_items_table(k).vertical_alignment));
470: end if;
471: else
472: htp.p(icx_on_utilities.formatData(icx_on_utilities.formatText(l_result_row_table(ak_query_pkg.g_items_table(k).value_id),

Line 472: htp.p(icx_on_utilities.formatData(icx_on_utilities.formatText(l_result_row_table(ak_query_pkg.g_items_table(k).value_id),

468: htp.p(icx_on_utilities.formatData(icx_on_utilities.formatText(l_result_row_table(ak_query_pkg.g_items_table(k).value_id),
469: ak_query_pkg.g_items_table(k).bold,ak_query_pkg.g_items_table(k).italic),ak_query_pkg.g_items_table(k).horizontal_alignment,ak_query_pkg.g_items_table(k).vertical_alignment));
470: end if;
471: else
472: htp.p(icx_on_utilities.formatData(icx_on_utilities.formatText(l_result_row_table(ak_query_pkg.g_items_table(k).value_id),
473: ak_query_pkg.g_items_table(k).bold,ak_query_pkg.g_items_table(k).italic),ak_query_pkg.g_items_table(k).horizontal_alignment,ak_query_pkg.g_items_table(k).vertical_alignment));
474: end if;
475: end if;
476:

Line 498: htp.tableData(htf.anchor('javascript:delete_relation('''||icx_util.replace_quotes(temp_cat)||''','''||icx_util.replace_quotes(temp_related_cat)||''','''||temp_cat_set_id||''','''||temp_cat_id||''','''||temp_related_cat_id||

494: temp_related_cat_id := l_result_row_table(ak_query_pkg.g_items_table(k).value_id);
495: end if;
496:
497: end loop;
498: htp.tableData(htf.anchor('javascript:delete_relation('''||icx_util.replace_quotes(temp_cat)||''','''||icx_util.replace_quotes(temp_related_cat)||''','''||temp_cat_set_id||''','''||temp_cat_id||''','''||temp_related_cat_id||
499: ''')',htf.img('/OA_MEDIA/'||l_language||'/FNDIDELR.gif','CENTER',icx_util.replace_alt_quotes(l_prompts(6)),'','BORDER=0 WIDTH=16 HEIGHT=17'),'','onMouseOver="window.status='''||icx_util.replace_onMouseOver_quotes(l_prompts(6))||
500: ''';return true"'));
501:
502: htp.tableRowClose;

Line 502: htp.tableRowClose;

498: htp.tableData(htf.anchor('javascript:delete_relation('''||icx_util.replace_quotes(temp_cat)||''','''||icx_util.replace_quotes(temp_related_cat)||''','''||temp_cat_set_id||''','''||temp_cat_id||''','''||temp_related_cat_id||
499: ''')',htf.img('/OA_MEDIA/'||l_language||'/FNDIDELR.gif','CENTER',icx_util.replace_alt_quotes(l_prompts(6)),'','BORDER=0 WIDTH=16 HEIGHT=17'),'','onMouseOver="window.status='''||icx_util.replace_onMouseOver_quotes(l_prompts(6))||
500: ''';return true"'));
501:
502: htp.tableRowClose;
503:
504: end loop; -- Display data
505:
506: htp.tableClose;

Line 506: htp.tableClose;

502: htp.tableRowClose;
503:
504: end loop; -- Display data
505:
506: htp.tableClose;
507:
508:
509: -- print button set if appropriate
510: if (l_total_rows > l_query_size) and not

Line 529: htp.p('

'||fnd_message.get||'

');

525: -- display message if no rows were returned by query
526: if j = 0 then
527: fnd_message.set_name('ICX','ICX_CAT_NO_RELATION');
528: fnd_message.set_token('CATEGORY',p_category_name);
529: htp.p('

'||fnd_message.get||'

');
530: end if;
531:
532: else
533:

Line 538: htp.p('

'||FND_MESSAGE.Get||'

');

534: if p_category_id is not null or p_category_name is not null then
535: -- display message that category name is not valid
536: FND_MESSAGE.SET_NAME('ICX','ICX_INVALID_ENTRY');
537: FND_MESSAGE.SET_TOKEN('INVALID_TOKEN',p_category_name);
538: htp.p('

'||FND_MESSAGE.Get||'

');
539: end if;
540:
541: end if; -- l_count = 1
542:

Line 544: htp.formClose;

540:
541: end if; -- l_count = 1
542:
543:
544: htp.formClose;
545: htp.bodyClose;
546: htp.htmlClose;
547:
548: end if; -- ValidateSession

Line 545: htp.bodyClose;

541: end if; -- l_count = 1
542:
543:
544: htp.formClose;
545: htp.bodyClose;
546: htp.htmlClose;
547:
548: end if; -- ValidateSession
549:

Line 546: htp.htmlClose;

542:
543:
544: htp.formClose;
545: htp.bodyClose;
546: htp.htmlClose;
547:
548: end if; -- ValidateSession
549:
550: exception