62: begin
63:
64: FND_MESSAGE.SET_NAME('ICX', 'ICX_CART_RMV_ALL');
65: htp.p('function giveWarning() {
66: if (confirm(''' || icx_util.replace_quotes(FND_MESSAGE.GET) || ''')) {
67: return true;
68: } else {
69: return false;
70: }
88:
89: htp.htmlOpen;
90: htp.headOpen;
91: icx_admin_sig.toolbar(language_code => v_lang);
92: icx_util.copyright;
93: js.scriptOpen;
94:
95: htp.p('function help_window() {
96: help_win = window.open(''/OA_DOC/' || v_lang || '/awe' || '/icxhlprq.htm'', "help_win","resizable=yes,scrollbars=yes,toolbar=yes,width=450,height=250");
102: htp.headClose;
103: htp.bodyOpen('/OA_MEDIA/' || v_lang || '/ICXBCKGR.jpg');
104:
105: FND_MESSAGE.SET_NAME('ICX', 'ICX_DATA_INCORRECT');
106: icx_util.add_error(FND_MESSAGE.GET);
107: icx_util.error_page_print;
108: -- htp.p(FND_MESSAGE.GET);
109:
110:
103: htp.bodyOpen('/OA_MEDIA/' || v_lang || '/ICXBCKGR.jpg');
104:
105: FND_MESSAGE.SET_NAME('ICX', 'ICX_DATA_INCORRECT');
106: icx_util.add_error(FND_MESSAGE.GET);
107: icx_util.error_page_print;
108: -- htp.p(FND_MESSAGE.GET);
109:
110:
111: htp.bodyClose;
183: /*
184: var po_num = "" + parent.my_cart_header.ICX_RESERVED_PO_NUM;
185: alert(po_num);
186: if (po_num <> "") {
187: alert("' || icx_util.replace_quotes(FND_MESSAGE.GET) || '");
188: //alert("Can not reserve more than one PO # for a single requisition.");
189: return;
190: }
191:
236: FND_MESSAGE.SET_NAME('RG', 'RG_DELETE_ROW');
237: v_message := FND_MESSAGE.GET;
238:
239: htp.p('function remove(number) {
240: if (confirm("' || icx_util.replace_quotes(v_message) || '") ) {
241: //dc parent.removeItem(number);
242: document.LINE.cartLineId.value = number;
243: document.LINE.cartLineAction.value = "DELETE";
244: document.LINE.submit();
283:
284: htp.p('function save_order() {
285:
286: // if (parent.frames[0].document.LINE.itemCount.value == 0) {
287: // alert("' || icx_util.replace_quotes(v_empty_cart_msg) || '");
288: // } else {
289:
290: // if (confirm("' || icx_util.replace_quotes(v_confirm_text) || '")) {
291: parent.frames[0].document.KEVIN.user_action.value = "SAVE";
286: // if (parent.frames[0].document.LINE.itemCount.value == 0) {
287: // alert("' || icx_util.replace_quotes(v_empty_cart_msg) || '");
288: // } else {
289:
290: // if (confirm("' || icx_util.replace_quotes(v_confirm_text) || '")) {
291: parent.frames[0].document.KEVIN.user_action.value = "SAVE";
292: parent.frames[0].document.KEVIN.submit();
293: // }
294: // }
300:
301: htp.p('function modify_order() {
302:
303: // if (parent.frames[0].document.LINE.itemCount.value == 0) {
304: // alert("' || icx_util.replace_quotes(v_empty_cart_msg) || '");
305: // } else {
306:
307: parent.frames[0].document.KEVIN.user_action.value = "MODIFY";
308: parent.frames[0].document.KEVIN.submit();
310: }');
311:
312: htp.p('function get_po_modify_order() {
313: // if (parent.frames[0].document.LINE.itemCount.value == 0) {
314: // alert ("' || icx_util.replace_quotes(v_empty_cart_msg) || '");
315: // } else {
316: parent.frames[0].document.KEVIN.user_action.value = "GET_PO_MODIFY";
317: parent.frames[0].document.KEVIN.submit();
318: // }
323: v_confirm_text := FND_MESSAGE.GET;
324: htp.p('function submit_order() {
325:
326: if (parent.frames[0].document.LINE.itemCount.value == 0) {
327: alert("' || icx_util.replace_quotes(v_empty_cart_msg) || '");
328: } else {
329:
330: if (confirm("' || icx_util.replace_quotes(v_confirm_text) || '")) {
331: parent.frames[0].document.KEVIN.user_action.value = "PLACE ORDER";
326: if (parent.frames[0].document.LINE.itemCount.value == 0) {
327: alert("' || icx_util.replace_quotes(v_empty_cart_msg) || '");
328: } else {
329:
330: if (confirm("' || icx_util.replace_quotes(v_confirm_text) || '")) {
331: parent.frames[0].document.KEVIN.user_action.value = "PLACE ORDER";
332: parent.frames[0].document.KEVIN.submit();
333: }
334: }
338: v_confirm_text := FND_MESSAGE.GET;
339: htp.p('function delete_saved_cart() {
340:
341: // if (parent.frames[0].document.LINE.itemCount.value == 0) {
342: // alert("' || icx_util.replace_quotes(v_empty_cart_msg) || '");
343: // } else {
344:
345: if (confirm("' || icx_util.replace_quotes(v_confirm_text) || '")) {
346: parent.frames[0].document.KEVIN.user_action.value = "CANCEL";
341: // if (parent.frames[0].document.LINE.itemCount.value == 0) {
342: // alert("' || icx_util.replace_quotes(v_empty_cart_msg) || '");
343: // } else {
344:
345: if (confirm("' || icx_util.replace_quotes(v_confirm_text) || '")) {
346: parent.frames[0].document.KEVIN.user_action.value = "CANCEL";
347: parent.frames[0].document.KEVIN.submit();
348: }
349: // }
458: v_vendor_LOV_flag in out varchar2,
459: v_location_LOV_flag in out varchar2,
460: p_ext_price_total out number) is
461: ------------------------------------------------------------
462: l_values icx_util.char240_table;
463: l_value varchar2(240);
464: l_language_code varchar2(30);
465: l_multirow_color varchar2(30);
466: l_colspan number;
463: l_value varchar2(240);
464: l_language_code varchar2(30);
465: l_multirow_color varchar2(30);
466: l_colspan number;
467: c_prompts ICX_UTIL.g_prompts_table;
468: c_title varchar2(45);
469: l_org_id_pos number;
470: l_loc_id_pos number;
471: l_spin_pos number;
480:
481: begin
482:
483: l_language_code := icx_sec.getID(icx_sec.pv_language_code);
484: l_multirow_color := icx_util.get_color('TABLE_DATA_MULTIROW');
485: -- icx_util.getprompts(601, 'ICX_SHOPPING_CART_LINES_R', c_title, c_prompts);
486: icx_util.getprompts(601, 'ICX_LOV', c_title, c_prompts);
487:
488: for r in 0..ak_query_pkg.g_results_table.LAST loop
481: begin
482:
483: l_language_code := icx_sec.getID(icx_sec.pv_language_code);
484: l_multirow_color := icx_util.get_color('TABLE_DATA_MULTIROW');
485: -- icx_util.getprompts(601, 'ICX_SHOPPING_CART_LINES_R', c_title, c_prompts);
486: icx_util.getprompts(601, 'ICX_LOV', c_title, c_prompts);
487:
488: for r in 0..ak_query_pkg.g_results_table.LAST loop
489:
482:
483: l_language_code := icx_sec.getID(icx_sec.pv_language_code);
484: l_multirow_color := icx_util.get_color('TABLE_DATA_MULTIROW');
485: -- icx_util.getprompts(601, 'ICX_SHOPPING_CART_LINES_R', c_title, c_prompts);
486: icx_util.getprompts(601, 'ICX_LOV', c_title, c_prompts);
487:
488: for r in 0..ak_query_pkg.g_results_table.LAST loop
489:
490: icx_util.transfer_Row_To_Column(ak_query_pkg.g_results_table(r),l_values);
486: icx_util.getprompts(601, 'ICX_LOV', c_title, c_prompts);
487:
488: for r in 0..ak_query_pkg.g_results_table.LAST loop
489:
490: icx_util.transfer_Row_To_Column(ak_query_pkg.g_results_table(r),l_values);
491:
492: for i in 0..ak_query_pkg.g_items_table.LAST loop
493:
494: if ak_query_pkg.g_items_table(i).node_display_flag = 'Y'
568: || '''; return true">
569: || l_language_code
570: -- || '/FNDIDELR.gif HEIGHT=18 WIDTH=18 BORDER=no>',
571: || '/FNDIDELR.gif HEIGHT=18 WIDTH=18 BORDER=no ALT="'
572: || icx_util.replace_alt_quotes(ak_query_pkg.g_items_table(i).attribute_label_long)
573: || '">',
574: crowspan => 2,
575: -- add by Mary
576: calign => ak_query_pkg.g_items_table(i).horizontal_alignment);
585: || '''; return true">
586: || l_language_code
587: -- || '/FNDISPLT.gif HEIGHT=18 WIDTH=18 BORDER=no>',
588: || '/FNDISPLT.gif HEIGHT=18 WIDTH=18 BORDER=no ALT="'
589: || icx_util.replace_alt_quotes(ak_query_pkg.g_items_table(i).attribute_label_long)
590: || '">',
591: crowspan => 2,
592: -- add by Mary
593: calign => ak_query_pkg.g_items_table(i).horizontal_alignment);
598: href="javascript:accountDist('
599: || l_values(p_cart_line_id_value)
600: -- || ')">
601: || ')" onMouseOver="window.status='''
602: || icx_util.replace_onmouseover_quotes(ak_query_pkg.g_items_table(i).attribute_label_long)
603: || '''; return true">
604: || l_language_code
605: -- || '/FNDIMADS.gif HEIGHT=16 WIDTH=16 BORDER=no>',
606: || '/FNDISPLT.gif HEIGHT=16 WIDTH=16 BORDER=no ALT="'
603: || '''; return true">
604: || l_language_code
605: -- || '/FNDIMADS.gif HEIGHT=16 WIDTH=16 BORDER=no>',
606: || '/FNDISPLT.gif HEIGHT=16 WIDTH=16 BORDER=no ALT="'
607: || icx_util.replace_alt_quotes(ak_query_pkg.g_items_table(i).attribute_label_long)
608: || '">',
609: crowspan => 2,
610: -- add by Mary
611: calign => ak_query_pkg.g_items_table(i).horizontal_alignment);--
620: || pk
621: || ''' ,'''' , '''
622: || v_dcdname
623: ||''')" onMouseOver="window.status='''
624: || icx_util.replace_onmouseover_quotes(ak_query_pkg.g_items_table(i).attribute_label_long)
625: || '''; return true">
626: || l_language_code
627: || '/FNDIATTE.gif HEIGHT=16 WIDTH=16 BORDER=no ALT="'
628: || icx_util.replace_alt_quotes(ak_query_pkg.g_items_table(i).attribute_label_long)
624: || icx_util.replace_onmouseover_quotes(ak_query_pkg.g_items_table(i).attribute_label_long)
625: || '''; return true">
626: || l_language_code
627: || '/FNDIATTE.gif HEIGHT=16 WIDTH=16 BORDER=no ALT="'
628: || icx_util.replace_alt_quotes(ak_query_pkg.g_items_table(i).attribute_label_long)
629: || '">',
630: crowspan => 2,
631: -- add by Mary
632: calign => ak_query_pkg.g_items_table(i).horizontal_alignment);
637: || ''' ,'''' , '''
638: ||v_dcdname
639: -- ||''')">
640: ||''')" onMouseOver="window.status='''
641: || icx_util.replace_onmouseover_quotes(ak_query_pkg.g_items_table(i).attribute_label_long)
642: || '''; return true">
643: || l_language_code
644: || '/FNDIATT.gif HEIGHT=16 WIDTH=16 BORDER=no ALT="'
645: || icx_util.replace_alt_quotes(ak_query_pkg.g_items_table(i).attribute_label_long)
641: || icx_util.replace_onmouseover_quotes(ak_query_pkg.g_items_table(i).attribute_label_long)
642: || '''; return true">
643: || l_language_code
644: || '/FNDIATT.gif HEIGHT=16 WIDTH=16 BORDER=no ALT="'
645: || icx_util.replace_alt_quotes(ak_query_pkg.g_items_table(i).attribute_label_long)
646: || '">',
647: crowspan => 2,
648: -- add by Mary
649: calign => ak_query_pkg.g_items_table(i).horizontal_alignment);
704:
705: htp.tableData(cvalue => htf.anchor('javascript:PRE_LOV1(''178'',''ICX_SUGGESTED_VENDOR_NAME'',''601'',''ICX_SHOPPING_CART_LINES_R'',''LOVFIELDS'',''my_order1'','''','''','''
706: || to_char(l_pos) || ''',''' || to_char(l_pos + 1) || ''',''' || to_char(l_pos + 2) || ''',''' || to_char(l_pos + 3) || ''')',htf.img('/OA_MEDIA/'
707: ||l_language_code||'/FNDILOV.gif','LEFT',c_title,'','BORDER=0 WIDTH=22 HEIGHT=22'),'','onMouseOver="window.status='''
708: || icx_util.replace_onMouseOver_quotes(c_title) ||''';return true"'), crowspan => 2);
709:
710: elsif ak_query_pkg.g_items_table(i).attribute_code = 'ICX_DELIVER_TO_LOCATION_L' then -- must be location LOV
711:
712: htp.tableData(cvalue => htf.anchor('javascript:PRE_LOV2(''178'',''ICX_DELIVER_TO_LOCATION_L'',''601'',''ICX_SHOPPING_CART_LINES_R'',''LOVFIELDS'',''my_order1'','''','''',''' ||
710: elsif ak_query_pkg.g_items_table(i).attribute_code = 'ICX_DELIVER_TO_LOCATION_L' then -- must be location LOV
711:
712: htp.tableData(cvalue => htf.anchor('javascript:PRE_LOV2(''178'',''ICX_DELIVER_TO_LOCATION_L'',''601'',''ICX_SHOPPING_CART_LINES_R'',''LOVFIELDS'',''my_order1'','''','''',''' ||
713: to_char(l_org_id_pos) || ''',''' || to_char(l_loc_id_pos) || ''',''' || to_char(l_pos) || ''')',htf.img('/OA_MEDIA/'||l_language_code||
714: '/FNDILOV.gif','LEFT',c_title,'','BORDER=0 WIDTH=22 HEIGHT=22'),'','onMouseOver="window.status='''|| icx_util.replace_onMouseOver_quotes(c_title) ||''';return true"'), crowspan => 2);
715:
716: -- user has LOV
717: elsif ak_query_pkg.g_items_table(i).lov_attribute_code is not NULL and
718: ak_query_pkg.g_items_table(i).lov_region_code is not NULL and
725:
726: htp.tableData(cvalue => htf.anchor('javascript:PRE_LOV0(''178'',''' || ak_query_pkg.g_items_table(i).attribute_code ||
727: ''',''601'',''ICX_SHOPPING_CART_LINES_R'',''LOVFIELDS'',''my_order1'','''','''',''' || to_char(l_pos) || ''')',htf.img('/OA_MEDIA/'||
728: l_language_code||'/FNDILOV.gif','LEFT',c_title,'','BORDER=0 WIDTH=22 HEIGHT=22'),'','onMouseOver="window.status='''||
729: icx_util.replace_onMouseOver_quotes(c_title) || ''';return true"'), crowspan => 2);
730:
731: end if;
732:
733: l_pos := l_pos + 1;