164: -- Make a copy of v_items_table b/c it will be overwritten by the second
165: -- exec_query;
166: v_items_table := ak_query_pkg.g_items_table;
167: 168: htp.htmlOpen; 169: htp.headOpen;
170: icx_util.copyright;
171: htp.title(c_title);
172:
188: FND_MESSAGE.SET_NAME('ICX', 'ICX_REQUIRED');
189:
190: icx_util.LOVScript;
191: 192: htp.p('function imClicked() { 193:
194: var check_desc = false;
195: var check_quan = false;
196: var check_price = false;
Line 228: htp.bodyOpen('','BGCOLOR="#FFCCFF" onLoad="parent.parent.winOpen(''nav'', ''special_order'')"');
224:
225: -- FND_MESSAGE.SET_NAME('ICX', 'ICX_REQUIRED');
226: js.scriptClose;
227: 228: htp.bodyOpen('','BGCOLOR="#FFCCFF" onLoad="parent.parent.winOpen(''nav'', ''special_order'')"'); 229:
230: /* Table approach is used here to create a blank space at the beginning
231: of the text. Otherwise the text will run into the left end of the
232: browser. All the prompt will have tables associated with it.
Line 237: htp.tableOpen;
233: */
234:
235: /* Print the help text on the top */
236: FND_MESSAGE.SET_NAME('ICX', 'ICX_SELECT_CATG_ENT'); 237: htp.tableOpen; 238: htp.tableRowOpen('BORDER = 0');
239: htp.tableData(cvalue => ' ');
240: htp.p('
' || FND_MESSAGE.GET || '
');
241: htp.tableRowClose;
Line 238: htp.tableRowOpen('BORDER = 0');
234:
235: /* Print the help text on the top */
236: FND_MESSAGE.SET_NAME('ICX', 'ICX_SELECT_CATG_ENT');
237: htp.tableOpen; 238: htp.tableRowOpen('BORDER = 0'); 239: htp.tableData(cvalue => ' ');
240: htp.p('
' || FND_MESSAGE.GET || '
');
241: htp.tableRowClose;
242: htp.tableClose;
Line 239: htp.tableData(cvalue => ' ');
235: /* Print the help text on the top */
236: FND_MESSAGE.SET_NAME('ICX', 'ICX_SELECT_CATG_ENT');
237: htp.tableOpen;
238: htp.tableRowOpen('BORDER = 0'); 239: htp.tableData(cvalue => ' '); 240: htp.p('
'); 241: htp.tableRowClose; 242: htp.tableClose;
243:
244: /* Print error message text if there are errors in the order */
245: IF v_error_flag = 'Y' THEN
');
241: htp.tableRowClose; 242: htp.tableClose; 243:
244: /* Print error message text if there are errors in the order */
245: IF v_error_flag = 'Y' THEN
246: htp.tableOpen;
Line 246: htp.tableOpen;
242: htp.tableClose;
243:
244: /* Print error message text if there are errors in the order */
245: IF v_error_flag = 'Y' THEN 246: htp.tableOpen; 247: htp.tableRowOpen('BORDER = 0');
248: htp.tableData(cvalue => ' ');
249: htp.p('
' || htf.bold(v_error_text)|| '
');
250: htp.tableRowClose;
Line 247: htp.tableRowOpen('BORDER = 0');
243:
244: /* Print error message text if there are errors in the order */
245: IF v_error_flag = 'Y' THEN
246: htp.tableOpen; 247: htp.tableRowOpen('BORDER = 0'); 248: htp.tableData(cvalue => ' ');
249: htp.p('
' || htf.bold(v_error_text)|| '
');
250: htp.tableRowClose;
251: htp.tableClose;
Line 248: htp.tableData(cvalue => ' ');
244: /* Print error message text if there are errors in the order */
245: IF v_error_flag = 'Y' THEN
246: htp.tableOpen;
247: htp.tableRowOpen('BORDER = 0'); 248: htp.tableData(cvalue => ' '); 249: htp.p('
' || htf.bold(v_error_text)|| '
');
250: htp.tableRowClose;
251: htp.tableClose;
252: END IF;
Line 249: htp.p('
' || htf.bold(v_error_text)|| '
');
245: IF v_error_flag = 'Y' THEN
246: htp.tableOpen;
247: htp.tableRowOpen('BORDER = 0');
248: htp.tableData(cvalue => ' '); 249: htp.p('
' || htf.bold(v_error_text)|| '
');
250: htp.tableRowClose;
251: htp.tableClose;
252: END IF;
253:
');
250: htp.tableRowClose; 251: htp.tableClose; 252: END IF;
253:
254: /* Print items added and order total amount */
255: IF (to_number(v_rows_inserted) > 0 ) THEN
');
273:
274: htp.formHidden('n_org', n_org); 275: htp.formHidden('cartId', ''); 276:
277: htp.tableOpen('BORDER=0');
278:
279: IF v_items_table.count > 0 THEN
Line 277: htp.tableOpen('BORDER=0');
273:
274: htp.formHidden('n_org', n_org);
275: htp.formHidden('cartId', '');
276: 277: htp.tableOpen('BORDER=0'); 278:
279: IF v_items_table.count > 0 THEN
280: FOR i IN v_items_table.FIRST .. v_items_table.LAST LOOP
281:
Line 362: htp.tableRowOpen;
358: v_items_table(i).attribute_code = 'ICX_SUGGESTED_VENDOR_SITE' or
359: v_items_table(i).attribute_code = 'ICX_SUGGESTED_VENDOR_CONTACT')
360: ) THEN
361: 362: htp.tableRowOpen; 363:
364: --Special handling to load up default values.
365: IF v_items_table(i).attribute_code = 'ICX_CATEGORY_ID' THEN
366: v_value := v_default_cat_id;
Line 404: -- htp.p('
');
400: v_items_table(i).attribute_code = 'ICX_SUGGESTED_VENDOR_NAME' AND
401: v_vendor_on_flag <> 'Y'))) OR
402: v_items_table(i).attribute_code = 'ICX_CATEGORY_ID' OR
403: v_items_table(i).attribute_code = 'ICX_LINE_TYPE_ID' THEN 404: -- htp.p('
');
405: htp.p('' );
406:
407: ELSIF v_items_table(i).update_flag = 'Y' OR
408: v_items_table(i).attribute_code = 'ICX_ITEM_DESCRIPTION' or
Line 405: htp.p('' );
401: v_vendor_on_flag <> 'Y'))) OR
402: v_items_table(i).attribute_code = 'ICX_CATEGORY_ID' OR
403: v_items_table(i).attribute_code = 'ICX_LINE_TYPE_ID' THEN
404: -- htp.p('
'); 405: htp.p('' ); 406:
407: ELSIF v_items_table(i).update_flag = 'Y' OR
408: v_items_table(i).attribute_code = 'ICX_ITEM_DESCRIPTION' or
409: v_items_table(i).attribute_code = 'ICX_QTY_V' or
Line 416: htp.p('
' || v_items_table(i).attribute_label_long || '
');
412: v_items_table(i).attribute_code = 'ICX_CATEGORY_NAME' or
413: (v_items_table(i).attribute_code = 'ICX_SUGGESTED_VENDOR_NAME'
414: AND v_vendor_on_flag = 'Y') THEN
415: 416: htp.p('
' || v_items_table(i).attribute_label_long || '
');
417:
418: /* IF Category or Unit of measure is a pop list, display
419: SELECT list box */
420: IF v_items_table(i).attribute_code = 'ICX_CATEGORY_NAME' AND
Line 443: htp.tableData((htf.formSelectOpen(v_items_table(i).attribute_code) || v_select_text || htf.formSelectClose), 'LEFT');
475: AND UPPER(v_items_table(i).item_style) = 'TEXT') THEN
476: htp.tableData(icx_util.LOVButton(178,'ICX_UNIT_OF_MEASUREMENT', 601, 'ICX_REQ_SPECIAL_ORDER', 'one_time', 'data'), CATTRIBUTES => 'ALIGN="LEFT" width=200');
477: ELSIF v_items_table(i).attribute_code = 'ICX_SUGGESTED_VENDOR_NAME'
478: AND v_vendor_on_flag = 'Y' THEN 479: htp.tableData(icx_util.LOVButton(178,'ICX_SUGGESTED_VENDOR_NAME', 601, 'ICX_REQ_SPECIAL_ORDER', 'one_time', 'data'), CATTRIBUTES => 'ALIGN="LEFT" width=200'); 480: ELSIF v_items_table(i).lov_attribute_code is not NULL AND
481: v_items_table(i).lov_region_code is not NULL AND
482: v_items_table(i).attribute_code <> 'ICX_SUGGESTED_VENDOR_PHONE' AND
483: v_items_table(i).attribute_code <> 'ICX_SUGGESTED_VENDOR_CONTACT' AND
Line 490: htp.tableData(icx_util.LOVButton(178,v_items_table(i).attribute_code, 601, 'ICX_REQ_SPECIAL_ORDER','one_time','data'), CATTRIBUTES => 'ALIGN="LEFT" width=200');
486: v_items_table(i).node_display_flag = 'Y' AND
487: v_items_table(i).update_flag = 'Y' AND
488: v_items_table(i).item_style <> 'HIDDEN' AND
489: v_items_table(i).item_style <> 'POPLIST' THEN 490: htp.tableData(icx_util.LOVButton(178,v_items_table(i).attribute_code, 601, 'ICX_REQ_SPECIAL_ORDER','one_time','data'), CATTRIBUTES => 'ALIGN="LEFT" width=200'); 491:
492: END IF;
493: htp.tableRowClose;
494: END IF;
Line 493: htp.tableRowClose;
489: v_items_table(i).item_style <> 'POPLIST' THEN
490: htp.tableData(icx_util.LOVButton(178,v_items_table(i).attribute_code, 601, 'ICX_REQ_SPECIAL_ORDER','one_time','data'), CATTRIBUTES => 'ALIGN="LEFT" width=200');
491:
492: END IF; 493: htp.tableRowClose; 494: END IF;
495:
496: END LOOP;
497: END IF; /* table count > 0 */
522:
523: htp.p('');
524:
525: htp.bodyClose; 526: htp.htmlClose; 527:
528: END IF; /* if validate session */
529: EXCEPTION
530:
Line 532: htp.p('Error in Special Order ' || substr(SQLERRM, 1, 512));
528: END IF; /* if validate session */
529: EXCEPTION
530:
531: WHEN OTHERS THEN 532: htp.p('Error in Special Order ' || substr(SQLERRM, 1, 512)); 533: -- icx_util.add_error(substr(SQLERRM, 12, 512));
534: -- icx_util.error_page_print;
535:
536: