166: v_index := v_index + 1;
167:
168:
169:
170: htp.hr;
171:
172: -- Cart Header Related Object Navigator
173: -- ^^^^^^^^^^
174: --
181: P_RETURN_CHILDREN => 'F',
182: P_WHERE_BINDS => where_clause_binds);
183:
184: -- Draw cart header.
185: htp.tableOpen( 'border=0' );
186:
187: icx_util.transfer_Row_To_Column( ak_query_pkg.g_results_table(ak_query_pkg.g_results_table.first), y_table) ;
188:
189: /* get org ahead of time */
222: elsif (ak_query_pkg.g_items_table(i).attribute_code =
223: 'ICX_DELIVER_TO_REQUESTOR_ID') then
224: v_requestor_id := y_table(ak_query_pkg.g_items_table(i).value_id);
225: else
226: htp.tableRowOpen;
227: htp.tableData(cvalue => ak_query_pkg.g_items_table(i).attribute_label_long, calign => 'RIGHT', cattributes=>'VALIGN=CENTER');
228: htp.tableData(cvalue => ' ');
229: htp.p('
223: 'ICX_DELIVER_TO_REQUESTOR_ID') then
224: v_requestor_id := y_table(ak_query_pkg.g_items_table(i).value_id);
225: else
226: htp.tableRowOpen;
227: htp.tableData(cvalue => ak_query_pkg.g_items_table(i).attribute_label_long, calign => 'RIGHT', cattributes=>'VALIGN=CENTER');
228: htp.tableData(cvalue => ' ');
229: htp.p('
224: v_requestor_id := y_table(ak_query_pkg.g_items_table(i).value_id);
225: else
226: htp.tableRowOpen;
227: htp.tableData(cvalue => ak_query_pkg.g_items_table(i).attribute_label_long, calign => 'RIGHT', cattributes=>'VALIGN=CENTER');
228: htp.tableData(cvalue => ' ');
229: htp.p('
225: else
226: htp.tableRowOpen;
227: htp.tableData(cvalue => ak_query_pkg.g_items_table(i).attribute_label_long, calign => 'RIGHT', cattributes=>'VALIGN=CENTER');
228: htp.tableData(cvalue => ' ');
229: htp.p('
226: htp.tableRowOpen;
227: htp.tableData(cvalue => ak_query_pkg.g_items_table(i).attribute_label_long, calign => 'RIGHT', cattributes=>'VALIGN=CENTER');
228: htp.tableData(cvalue => ' ');
229: htp.p('
228: htp.tableData(cvalue => ' ');
229: htp.p('
230: htp.p('');
231: if ak_query_pkg.g_items_table(i).italic = 'Y' then
232: htp.p('');
233: end if;
234: htp.p(y_table(ak_query_pkg.g_items_table(i).value_id));
235: if ak_query_pkg.g_items_table(i).italic = 'Y' then
236: htp.p('');
237: end if;
238: htp.p('');
232: htp.p('');
233: end if;
234: htp.p(y_table(ak_query_pkg.g_items_table(i).value_id));
235: if ak_query_pkg.g_items_table(i).italic = 'Y' then
236: htp.p('');
237: end if;
238: htp.p('');
239:
240: htp.tableRowClose;
234: htp.p(y_table(ak_query_pkg.g_items_table(i).value_id));
235: if ak_query_pkg.g_items_table(i).italic = 'Y' then
236: htp.p('');
237: end if;
238: htp.p('');
239:
240: htp.tableRowClose;
241: end if;
242:
236: htp.p('');
237: end if;
238: htp.p('');
239:
240: htp.tableRowClose;
241: end if;
242:
243: else
244: -- this is a regular attribute
247: 'ICX_DELIVER_TO_LOCATION') then
248: open getLoccd(v_location_id);
249: fetch getLoccd into v_location_code;
250: close getLoccd;
251: htp.tableRowOpen;
252: htp.tableData(cvalue => ak_query_pkg.g_items_table(i).attribute_label_long, calign => 'RIGHT', cattributes=>'VALIGN=CENTER');
253: htp.tableData(cvalue => ' ');
254: htp.p('
248: open getLoccd(v_location_id);
249: fetch getLoccd into v_location_code;
250: close getLoccd;
251: htp.tableRowOpen;
252: htp.tableData(cvalue => ak_query_pkg.g_items_table(i).attribute_label_long, calign => 'RIGHT', cattributes=>'VALIGN=CENTER');
253: htp.tableData(cvalue => ' ');
254: htp.p('
249: fetch getLoccd into v_location_code;
250: close getLoccd;
251: htp.tableRowOpen;
252: htp.tableData(cvalue => ak_query_pkg.g_items_table(i).attribute_label_long, calign => 'RIGHT', cattributes=>'VALIGN=CENTER');
253: htp.tableData(cvalue => ' ');
254: htp.p('
250: close getLoccd;
251: htp.tableRowOpen;
252: htp.tableData(cvalue => ak_query_pkg.g_items_table(i).attribute_label_long, calign => 'RIGHT', cattributes=>'VALIGN=CENTER');
253: htp.tableData(cvalue => ' ');
254: htp.p('
252: htp.tableData(cvalue => ak_query_pkg.g_items_table(i).attribute_label_long, calign => 'RIGHT', cattributes=>'VALIGN=CENTER');
253: htp.tableData(cvalue => ' ');
254: htp.p('
255: if ak_query_pkg.g_items_table(i).bold = 'Y' then
256: htp.p('');
257: end if;
258: if ak_query_pkg.g_items_table(i).italic = 'Y' then
259: htp.p('');
260: end if;
261: htp.p(v_location_code);
262: if ak_query_pkg.g_items_table(i).italic = 'Y' then
263: htp.p('');
257: end if;
258: if ak_query_pkg.g_items_table(i).italic = 'Y' then
259: htp.p('');
260: end if;
261: htp.p(v_location_code);
262: if ak_query_pkg.g_items_table(i).italic = 'Y' then
263: htp.p('');
264: end if;
265: if ak_query_pkg.g_items_table(i).bold = 'Y' then
259: htp.p('');
260: end if;
261: htp.p(v_location_code);
262: if ak_query_pkg.g_items_table(i).italic = 'Y' then
263: htp.p('');
264: end if;
265: if ak_query_pkg.g_items_table(i).bold = 'Y' then
266: htp.p('');
267: end if;
262: if ak_query_pkg.g_items_table(i).italic = 'Y' then
263: htp.p('');
264: end if;
265: if ak_query_pkg.g_items_table(i).bold = 'Y' then
266: htp.p('');
267: end if;
268: htp.tableRowClose;
269: elsif(ak_query_pkg.g_items_table(i).attribute_code =
270: 'ICX_DELIVER_TO_REQUESTOR') then
264: end if;
265: if ak_query_pkg.g_items_table(i).bold = 'Y' then
266: htp.p('');
267: end if;
268: htp.tableRowClose;
269: elsif(ak_query_pkg.g_items_table(i).attribute_code =
270: 'ICX_DELIVER_TO_REQUESTOR') then
271: open requestor_name(v_requestor_id);
272: fetch requestor_name into v_requestor_name;
270: 'ICX_DELIVER_TO_REQUESTOR') then
271: open requestor_name(v_requestor_id);
272: fetch requestor_name into v_requestor_name;
273: close requestor_name;
274: htp.tableRowOpen;
275: htp.tableData(cvalue => ak_query_pkg.g_items_table(i).attribute_label_long, calign => 'RIGHT', cattributes=>'VALIGN=CENTER');
276: htp.tableData(cvalue => ' ');
277: htp.p('
271: open requestor_name(v_requestor_id);
272: fetch requestor_name into v_requestor_name;
273: close requestor_name;
274: htp.tableRowOpen;
275: htp.tableData(cvalue => ak_query_pkg.g_items_table(i).attribute_label_long, calign => 'RIGHT', cattributes=>'VALIGN=CENTER');
276: htp.tableData(cvalue => ' ');
277: htp.p('
272: fetch requestor_name into v_requestor_name;
273: close requestor_name;
274: htp.tableRowOpen;
275: htp.tableData(cvalue => ak_query_pkg.g_items_table(i).attribute_label_long, calign => 'RIGHT', cattributes=>'VALIGN=CENTER');
276: htp.tableData(cvalue => ' ');
277: htp.p('
273: close requestor_name;
274: htp.tableRowOpen;
275: htp.tableData(cvalue => ak_query_pkg.g_items_table(i).attribute_label_long, calign => 'RIGHT', cattributes=>'VALIGN=CENTER');
276: htp.tableData(cvalue => ' ');
277: htp.p('
275: htp.tableData(cvalue => ak_query_pkg.g_items_table(i).attribute_label_long, calign => 'RIGHT', cattributes=>'VALIGN=CENTER');
276: htp.tableData(cvalue => ' ');
277: htp.p('
278: if ak_query_pkg.g_items_table(i).bold = 'Y' then
279: htp.p('');
280: end if;
281: if ak_query_pkg.g_items_table(i).italic = 'Y' then
282: htp.p('');
283: end if;
284: htp.p(v_requestor_name);
285: if ak_query_pkg.g_items_table(i).italic = 'Y' then
286: htp.p('');
280: end if;
281: if ak_query_pkg.g_items_table(i).italic = 'Y' then
282: htp.p('');
283: end if;
284: htp.p(v_requestor_name);
285: if ak_query_pkg.g_items_table(i).italic = 'Y' then
286: htp.p('');
287: end if;
288: if ak_query_pkg.g_items_table(i).bold = 'Y' then
282: htp.p('');
283: end if;
284: htp.p(v_requestor_name);
285: if ak_query_pkg.g_items_table(i).italic = 'Y' then
286: htp.p('');
287: end if;
288: if ak_query_pkg.g_items_table(i).bold = 'Y' then
289: htp.p('');
290: end if;
285: if ak_query_pkg.g_items_table(i).italic = 'Y' then
286: htp.p('');
287: end if;
288: if ak_query_pkg.g_items_table(i).bold = 'Y' then
289: htp.p('');
290: end if;
291: htp.tableRowClose;
292: end if;
293:
287: end if;
288: if ak_query_pkg.g_items_table(i).bold = 'Y' then
289: htp.p('');
290: end if;
291: htp.tableRowClose;
292: end if;
293:
294: end if;
295:
296: end if;
297:
298: end loop;
299:
300: htp.tableClose;
301: htp.p('
');
302:
303: -- Cart Lines Related Object Navigator
304: -- ^^^^^^^^^^
297:
298: end loop;
299:
300: htp.tableClose;
301: htp.p('
');
302:
303: -- Cart Lines Related Object Navigator
304: -- ^^^^^^^^^^
305: --
317: -- ICX_REQ_ORDER.ak_mandatory_setup(l_cart_line_id_value,v_vendor_LOV_flag,v_location_LOV_flag);
318:
319: -- Draw cart lines.
320:
321: htp.tableOpen('BORDER=5', cattributes=> 'bgcolor="#F8F8F8"');
322:
323: -- PrintHead
324: htp.p('
320:
334: null;
336: if ak_query_pkg.g_items_table(i).attribute_code = 'ICX_UNIT_PRICE' or
321: htp.tableOpen('BORDER=5', cattributes=> 'bgcolor="#F8F8F8"');
322:
323: -- PrintHead
324: htp.p('');
325:
326: col_no := 0;
327: for i in 0 .. ak_query_pkg.g_items_table.LAST loop
328: if ak_query_pkg.g_items_table(i).node_display_flag = 'Y'
Line 338: htp.tableData(cvalue => ak_query_pkg.g_items_table(i).attribute_label_long || ' (' || v_currency || ')', calign => 'CENTER');
335: else
336: if ak_query_pkg.g_items_table(i).attribute_code = 'ICX_UNIT_PRICE' or
337: ak_query_pkg.g_items_table(i).attribute_code = 'ICX_EXT_PRICE' then
338: htp.tableData(cvalue => ak_query_pkg.g_items_table(i).attribute_label_long || ' (' || v_currency || ')', calign => 'CENTER');
339: else
340: htp.tableData(cvalue => ak_query_pkg.g_items_table(i).attribute_label_long, calign => 'CENTER');
341: end if;
342:
Line 340: htp.tableData(cvalue => ak_query_pkg.g_items_table(i).attribute_label_long, calign => 'CENTER');
337: ak_query_pkg.g_items_table(i).attribute_code = 'ICX_EXT_PRICE' then
338: htp.tableData(cvalue => ak_query_pkg.g_items_table(i).attribute_label_long || ' (' || v_currency || ')', calign => 'CENTER');
339: else
340: htp.tableData(cvalue => ak_query_pkg.g_items_table(i).attribute_label_long, calign => 'CENTER');
341: end if;
342:
343: col_no := col_no + 1;
344: if ak_query_pkg.g_items_table(i).attribute_code = 'ICX_EXT_PRICE'
Line 352: htp.p('
');
348: end if;
349: end if;
350: end if;
351: end loop;
352: htp.p('
357: if ak_query_pkg.g_regions_table(0).total_result_count > 0 then
358: for j in 0 .. ak_query_pkg.g_results_table.last loop
359: icx_util.transfer_Row_To_Column( ak_query_pkg.g_results_table(j), y_table);
360:
361: htp.tableRowOpen;
362: for i in 0 .. ak_query_pkg.g_items_table.LAST loop
363: if ak_query_pkg.g_items_table(i).node_display_flag = 'Y'
364: and ak_query_pkg.g_items_table(i).secured_column = 'F'
365: then
381: l_value := to_char(to_number(l_value),v_money_fmt_mask);
382: end if;
383: end if;
384:
385: htp.tableData(cvalue => icx_on_utilities.formatText(l_value,ak_query_pkg.g_items_table(i).bold,ak_query_pkg.g_items_table(i).italic),
386: calign => ak_query_pkg.g_items_table(i).horizontal_alignment, cattributes => 'VALIGN="'||ak_query_pkg.g_items_table(i).vertical_alignment||'"');
387:
388: end if;
389: end if;
388: end if;
389: end if;
390: end loop;
391:
392: htp.tableRowClose;
393:
394: end loop;
395: end if;
396:
401: --
402: -- Try to place total under extended price
403: --
404:
405: htp.p('');
406:
407: htp.p('
403: --
404:
405: htp.p('
405: htp.p('
409: htp.p('
410: end loop;
411:
412: FND_MESSAGE.SET_NAME('MRP','EC_TOTAL');
413: htp.p('
412: FND_MESSAGE.SET_NAME('MRP','EC_TOTAL');
413: htp.p('
417:
418: -- End PrintTotal
419: end if;
420:
421: htp.tableClose;
422:
423: -- new order button
424: htp.tableOpen('border=0');
425: htp.tableRowOpen;
420:
421: htp.tableClose;
422:
423: -- new order button
424: htp.tableOpen('border=0');
425: htp.tableRowOpen;
426: FND_MESSAGE.SET_NAME('ICX','ICX_REQ_AFTER_SUBMIT');
427: htp.p('
421: htp.tableClose;
422:
423: -- new order button
424: htp.tableOpen('border=0');
425: htp.tableRowOpen;
426: FND_MESSAGE.SET_NAME('ICX','ICX_REQ_AFTER_SUBMIT');
427: htp.p('
423: -- new order button
424: htp.tableOpen('border=0');
425: htp.tableRowOpen;
426: FND_MESSAGE.SET_NAME('ICX','ICX_REQ_AFTER_SUBMIT');
427: htp.p('
424: htp.tableOpen('border=0');
425: htp.tableRowOpen;
426: FND_MESSAGE.SET_NAME('ICX','ICX_REQ_AFTER_SUBMIT');
427: htp.p('
425: htp.tableRowOpen;
426: FND_MESSAGE.SET_NAME('ICX','ICX_REQ_AFTER_SUBMIT');
427: htp.p('
426: FND_MESSAGE.SET_NAME('ICX','ICX_REQ_AFTER_SUBMIT');
427: htp.p('
434: P_OnMouseOverText => FND_MESSAGE.GET,
435: P_HyperTextCall => 'ICX_REQ_NAVIGATION.ic_parent?cart_id=' || icx_call.encrypt2('0') || '&emergency=' || icx_call.encrypt2(p_emergency),
436: P_LanguageCode => v_lang,
437: P_JavaScriptFlag => FALSE);
438: htp.p('');
439:
440: htp.p('
436: P_LanguageCode => v_lang,
437: P_JavaScriptFlag => FALSE);
438: htp.p('
444: P_OnMouseOverText => FND_MESSAGE.GET,
445: P_HyperTextCall => 'OracleApps.DMM',
446: P_LanguageCode => v_lang,
447: P_JavaScriptFlag => FALSE);
448: htp.p('
446: P_LanguageCode => v_lang,
447: P_JavaScriptFlag => FALSE);
448: htp.p('');
449:
450: htp.tableRowClose;
451: htp.tableClose;
452:
453: end display_read_only_my_order;
454:
447: P_JavaScriptFlag => FALSE);
448: htp.p('');
449:
450: htp.tableRowClose;
451: htp.tableClose;
452:
453: end display_read_only_my_order;
454:
455:
478: -- get lang
479: v_lang := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
480: v_cart_id := icx_call.decrypt2(n_cart_id);
481:
482: htp.htmlOpen;
483: htp.headOpen;
484: icx_admin_sig.toolbar(language_code => v_lang);
485: icx_util.copyright;
486: js.scriptOpen;
479: v_lang := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
480: v_cart_id := icx_call.decrypt2(n_cart_id);
481:
482: htp.htmlOpen;
483: htp.headOpen;
484: icx_admin_sig.toolbar(language_code => v_lang);
485: icx_util.copyright;
486: js.scriptOpen;
487:
484: icx_admin_sig.toolbar(language_code => v_lang);
485: icx_util.copyright;
486: js.scriptOpen;
487:
488: htp.p('function help_window() {
489: help_win = window.open(''/OA_DOC/' || v_lang || '/awe' || '/icxhlprq.htm'', "help_win","resizable=yes,scrollbars=yes,toolbar=yes,width=450,height=250");
490: help_win = window.open(''/OA_DOC/' || v_lang || '/awe' || '/icxhlprq.htm'', "help_win","resizable=yes,scrollbars=yes,toolbar=yes,width=450,height=250")}
491: ');
492: js.scriptClose;
491: ');
492: js.scriptClose;
493:
494:
495: htp.headClose;
496: htp.bodyOpen('/OA_MEDIA/' || v_lang || '/ICXBCKGR.jpg');
497:
498: if (user_action = 'PO') then
499: open get_req_num(v_cart_id);
492: js.scriptClose;
493:
494:
495: htp.headClose;
496: htp.bodyOpen('/OA_MEDIA/' || v_lang || '/ICXBCKGR.jpg');
497:
498: if (user_action = 'PO') then
499: open get_req_num(v_cart_id);
500: fetch get_req_num into v_req_num;
');
500: fetch get_req_num into v_req_num;
501: close get_req_num;
502: FND_MESSAGE.SET_NAME('ICX','ICX_REQ_SUBMITTED');
503: FND_MESSAGE.SET_TOKEN('REQ_TOKEN',v_req_num);
504: htp.p('' || FND_MESSAGE.GET || '
');
505:
506: display_read_only_my_order(v_cart_id,v_emergency);
507:
508: -- call procedure to display read only cart
');
507:
508: -- call procedure to display read only cart
509: elsif (user_action = 'SAVE') then
510: FND_MESSAGE.SET_NAME('ICX','ICX_REQ_SAVED_FOR_LATER');
511: htp.p('' || FND_MESSAGE.GET || '
');
512:
513: -- call procedure to display read only cart
514: display_read_only_my_order(v_cart_id,v_emergency);
515:
512:
513: -- call procedure to display read only cart
514: display_read_only_my_order(v_cart_id,v_emergency);
515:
516: htp.comment(user_action);
517: elsif (user_action = 'CANCEL') then
518: FND_MESSAGE.SET_NAME('ICX','ICX_REQ_PREV_CANCEL');
519: htp.p('' || FND_MESSAGE.GET || '
');
520:
');
515:
516: htp.comment(user_action);
517: elsif (user_action = 'CANCEL') then
518: FND_MESSAGE.SET_NAME('ICX','ICX_REQ_PREV_CANCEL');
519: htp.p('' || FND_MESSAGE.GET || '
');
520:
521: htp.tableOpen('border=0');
522: htp.tableRowOpen;
523: FND_MESSAGE.SET_NAME('ICX','ICX_REQ_AFTER_SUBMIT');
517: elsif (user_action = 'CANCEL') then
518: FND_MESSAGE.SET_NAME('ICX','ICX_REQ_PREV_CANCEL');
519: htp.p('' || FND_MESSAGE.GET || '
');
520:
521: htp.tableOpen('border=0');
522: htp.tableRowOpen;
523: FND_MESSAGE.SET_NAME('ICX','ICX_REQ_AFTER_SUBMIT');
524: htp.p('
518: FND_MESSAGE.SET_NAME('ICX','ICX_REQ_PREV_CANCEL');
519: htp.p('' || FND_MESSAGE.GET || '
');
520:
521: htp.tableOpen('border=0');
522: htp.tableRowOpen;
523: FND_MESSAGE.SET_NAME('ICX','ICX_REQ_AFTER_SUBMIT');
524: htp.p('
520:
521: htp.tableOpen('border=0');
522: htp.tableRowOpen;
523: FND_MESSAGE.SET_NAME('ICX','ICX_REQ_AFTER_SUBMIT');
524: htp.p('
521: htp.tableOpen('border=0');
522: htp.tableRowOpen;
523: FND_MESSAGE.SET_NAME('ICX','ICX_REQ_AFTER_SUBMIT');
524: htp.p('
522: htp.tableRowOpen;
523: FND_MESSAGE.SET_NAME('ICX','ICX_REQ_AFTER_SUBMIT');
524: htp.p('
523: FND_MESSAGE.SET_NAME('ICX','ICX_REQ_AFTER_SUBMIT');
524: htp.p('
531: P_OnMouseOverText => FND_MESSAGE.GET,
532: P_HyperTextCall => 'ICX_REQ_NAVIGATION.ic_parent?cart_id=' || icx_call.encrypt2('0') || '&emergency=' || icx_call.encrypt2(v_emergency),
533: P_LanguageCode => v_lang,
534: P_JavaScriptFlag => FALSE);
535: htp.p('');
536: htp.p('
532: P_HyperTextCall => 'ICX_REQ_NAVIGATION.ic_parent?cart_id=' || icx_call.encrypt2('0') || '&emergency=' || icx_call.encrypt2(v_emergency),
533: P_LanguageCode => v_lang,
534: P_JavaScriptFlag => FALSE);
535: htp.p('
540: P_OnMouseOverText => FND_MESSAGE.GET,
541: P_HyperTextCall => 'OracleApps.DMM',
542: P_LanguageCode => v_lang,
543: P_JavaScriptFlag => FALSE);
544: htp.p('
542: P_LanguageCode => v_lang,
543: P_JavaScriptFlag => FALSE);
544: htp.p('');
545:
546: htp.tableRowClose;
547: htp.tableClose;
548:
549: else
550:
543: P_JavaScriptFlag => FALSE);
544: htp.p('');
545:
546: htp.tableRowClose;
547: htp.tableClose;
548:
549: else
550:
551: FND_MESSAGE.SET_NAME('ICX', 'ICX_CART_EXIST');
548:
549: else
550:
551: FND_MESSAGE.SET_NAME('ICX', 'ICX_CART_EXIST');
552: htp.p(' ' || FND_MESSAGE.GET);
553: htp.p('');
554:
555:
556:
549: else
550:
551: FND_MESSAGE.SET_NAME('ICX', 'ICX_CART_EXIST');
552: htp.p('
555:
556:
557: end if;
558:
559: htp.bodyClose;
560: htp.htmlClose;
561: end if;
562:
563: EXCEPTION
556:
557: end if;
558:
559: htp.bodyClose;
560: htp.htmlClose;
561: end if;
562:
563: EXCEPTION
564: when others then
561: end if;
562:
563: EXCEPTION
564: when others then
565: htp.p(SQLERRM);
566:
567:
568: end;
569:
2234: FND_MESSAGE.SET_NAME('ICX','ICX_REQUIRED_FIELD');
2235: FND_MESSAGE.SET_TOKEN('FIELD_NAME_TOKEN',v_error_message);
2236: v_error_message := FND_MESSAGE.GET;
2237:
2238: --htp.p(v_error_message);
2239: --return;
2240:
2241: icx_util.add_error(v_error_message);
2242: storeerror(v_cart_id,v_error_message);