9: l_message varchar2(1000);
10:
11: begin
12:
13: fnd_message.set_name('ICX','ICX_OPEN_QUERY');
14: l_message := icx_util.replace_quotes(fnd_message.get);
15:
16: if p_lines_now = 1
17: then
10:
11: begin
12:
13: fnd_message.set_name('ICX','ICX_OPEN_QUERY');
14: l_message := icx_util.replace_quotes(fnd_message.get);
15:
16: if p_lines_now = 1
17: then
18: htp.p('function submitFunction() {
323: from AK_REGIONS_VL
324: where REGION_CODE = p_region_code
325: and REGION_APPLICATION_ID = p_region_appl_id;
326:
327: fnd_message.set_name('ICX','ICX_FIND_TEXT');
328: fnd_message.set_token('REGION_TOKEN',l_page_title);
329: l_message := fnd_message.get;
330:
331: htp.tableOpen('BORDER=0');
324: where REGION_CODE = p_region_code
325: and REGION_APPLICATION_ID = p_region_appl_id;
326:
327: fnd_message.set_name('ICX','ICX_FIND_TEXT');
328: fnd_message.set_token('REGION_TOKEN',l_page_title);
329: l_message := fnd_message.get;
330:
331: htp.tableOpen('BORDER=0');
332: htp.tableRowOpen;
325: and REGION_APPLICATION_ID = p_region_appl_id;
326:
327: fnd_message.set_name('ICX','ICX_FIND_TEXT');
328: fnd_message.set_token('REGION_TOKEN',l_page_title);
329: l_message := fnd_message.get;
330:
331: htp.tableOpen('BORDER=0');
332: htp.tableRowOpen;
333:
523:
524: -- htp.p('Debug 0');
525: htp.p('');
526: htp.p('
524: -- htp.p('Debug 0');
525: htp.p('
526: htp.p('
596: js.scriptClose;
597: htp.headClose;
598: htp.bodyOpen('', 'BGCOLOR="#CCCCFF" onLoad="parent.parent.winOpen(''nav'', ''item_search''); open(''/OA_HTML/' || l_language || '/ICXBLUE.htm'', ''k_buttons'')"' );
599:
600: fnd_message.set_name('ICX','ICX_REQS_FIND');
601: htp.p(htf.bold(FND_MESSAGE.GET));
602: icx_on_utilities.findForm(p_region_appl_id => 601,
603: p_region_code => 'ICX_PO_SUPPL_SEARCH_ITEMS_R',
604: p_goto_url => 'ICX_REQ_SEARCH.displayItem',
597: htp.headClose;
598: htp.bodyOpen('', 'BGCOLOR="#CCCCFF" onLoad="parent.parent.winOpen(''nav'', ''item_search''); open(''/OA_HTML/' || l_language || '/ICXBLUE.htm'', ''k_buttons'')"' );
599:
600: fnd_message.set_name('ICX','ICX_REQS_FIND');
601: htp.p(htf.bold(FND_MESSAGE.GET));
602: icx_on_utilities.findForm(p_region_appl_id => 601,
603: p_region_code => 'ICX_PO_SUPPL_SEARCH_ITEMS_R',
604: p_goto_url => 'ICX_REQ_SEARCH.displayItem',
605: p_goto_target => 'data',
681: fetch get_current_total into l_total_price;
682: close get_current_total;
683: end if;
684:
685: FND_MESSAGE.SET_NAME('ICX','ICX_ITEM_ADD_NEW');
686: FND_MESSAGE.SET_TOKEN('ITEM_QUANTITY',l_rows_added);
687: l_message := FND_MESSAGE.GET;
688: if l_rows_updated > 0 then
689: FND_MESSAGE.SET_NAME('ICX','ICX_ITEM_ADD_UPDATE');
682: close get_current_total;
683: end if;
684:
685: FND_MESSAGE.SET_NAME('ICX','ICX_ITEM_ADD_NEW');
686: FND_MESSAGE.SET_TOKEN('ITEM_QUANTITY',l_rows_added);
687: l_message := FND_MESSAGE.GET;
688: if l_rows_updated > 0 then
689: FND_MESSAGE.SET_NAME('ICX','ICX_ITEM_ADD_UPDATE');
690: FND_MESSAGE.SET_TOKEN('ITEM_QUANTITY',l_rows_updated);
683: end if;
684:
685: FND_MESSAGE.SET_NAME('ICX','ICX_ITEM_ADD_NEW');
686: FND_MESSAGE.SET_TOKEN('ITEM_QUANTITY',l_rows_added);
687: l_message := FND_MESSAGE.GET;
688: if l_rows_updated > 0 then
689: FND_MESSAGE.SET_NAME('ICX','ICX_ITEM_ADD_UPDATE');
690: FND_MESSAGE.SET_TOKEN('ITEM_QUANTITY',l_rows_updated);
691: if l_rows_added > 0 then
685: FND_MESSAGE.SET_NAME('ICX','ICX_ITEM_ADD_NEW');
686: FND_MESSAGE.SET_TOKEN('ITEM_QUANTITY',l_rows_added);
687: l_message := FND_MESSAGE.GET;
688: if l_rows_updated > 0 then
689: FND_MESSAGE.SET_NAME('ICX','ICX_ITEM_ADD_UPDATE');
690: FND_MESSAGE.SET_TOKEN('ITEM_QUANTITY',l_rows_updated);
691: if l_rows_added > 0 then
692: l_message := l_message || '
' || FND_MESSAGE.GET;
693: else
686: FND_MESSAGE.SET_TOKEN('ITEM_QUANTITY',l_rows_added);
687: l_message := FND_MESSAGE.GET;
688: if l_rows_updated > 0 then
689: FND_MESSAGE.SET_NAME('ICX','ICX_ITEM_ADD_UPDATE');
690: FND_MESSAGE.SET_TOKEN('ITEM_QUANTITY',l_rows_updated);
691: if l_rows_added > 0 then
692: l_message := l_message || '
' || FND_MESSAGE.GET;
693: else
694: l_message := FND_MESSAGE.GET;
688: if l_rows_updated > 0 then
689: FND_MESSAGE.SET_NAME('ICX','ICX_ITEM_ADD_UPDATE');
690: FND_MESSAGE.SET_TOKEN('ITEM_QUANTITY',l_rows_updated);
691: if l_rows_added > 0 then
692: l_message := l_message || '
' || FND_MESSAGE.GET;
693: else
694: l_message := FND_MESSAGE.GET;
695: end if;
696: end if;
690: FND_MESSAGE.SET_TOKEN('ITEM_QUANTITY',l_rows_updated);
691: if l_rows_added > 0 then
692: l_message := l_message || '
' || FND_MESSAGE.GET;
693: else
694: l_message := FND_MESSAGE.GET;
695: end if;
696: end if;
697:
698: if l_total_price > 0 then
696: end if;
697:
698: if l_total_price > 0 then
699: ICX_REQ_NAVIGATION.get_currency(l_dest_org_id,l_currency,l_money_precision,l_fmt_mask);
700: FND_MESSAGE.SET_NAME('ICX','ICX_ITEM_ADD_TOTAL');
701: FND_MESSAGE.SET_TOKEN('CURRENCY_CODE',l_currency);
702: FND_MESSAGE.SET_TOKEN('REQUISITION_TOTAL',to_char(l_total_price,fnd_currency.get_format_mask(l_currency,30)));
703: l_message := l_message || '
' || FND_MESSAGE.GET;
704:
697:
698: if l_total_price > 0 then
699: ICX_REQ_NAVIGATION.get_currency(l_dest_org_id,l_currency,l_money_precision,l_fmt_mask);
700: FND_MESSAGE.SET_NAME('ICX','ICX_ITEM_ADD_TOTAL');
701: FND_MESSAGE.SET_TOKEN('CURRENCY_CODE',l_currency);
702: FND_MESSAGE.SET_TOKEN('REQUISITION_TOTAL',to_char(l_total_price,fnd_currency.get_format_mask(l_currency,30)));
703: l_message := l_message || '
' || FND_MESSAGE.GET;
704:
705: FND_MESSAGE.SET_NAME('ICX','ICX_ITEM_ADD_RETURN_CURRENT');
698: if l_total_price > 0 then
699: ICX_REQ_NAVIGATION.get_currency(l_dest_org_id,l_currency,l_money_precision,l_fmt_mask);
700: FND_MESSAGE.SET_NAME('ICX','ICX_ITEM_ADD_TOTAL');
701: FND_MESSAGE.SET_TOKEN('CURRENCY_CODE',l_currency);
702: FND_MESSAGE.SET_TOKEN('REQUISITION_TOTAL',to_char(l_total_price,fnd_currency.get_format_mask(l_currency,30)));
703: l_message := l_message || '
' || FND_MESSAGE.GET;
704:
705: FND_MESSAGE.SET_NAME('ICX','ICX_ITEM_ADD_RETURN_CURRENT');
706: l_href1 := FND_MESSAGE.GET;
699: ICX_REQ_NAVIGATION.get_currency(l_dest_org_id,l_currency,l_money_precision,l_fmt_mask);
700: FND_MESSAGE.SET_NAME('ICX','ICX_ITEM_ADD_TOTAL');
701: FND_MESSAGE.SET_TOKEN('CURRENCY_CODE',l_currency);
702: FND_MESSAGE.SET_TOKEN('REQUISITION_TOTAL',to_char(l_total_price,fnd_currency.get_format_mask(l_currency,30)));
703: l_message := l_message || '
' || FND_MESSAGE.GET;
704:
705: FND_MESSAGE.SET_NAME('ICX','ICX_ITEM_ADD_RETURN_CURRENT');
706: l_href1 := FND_MESSAGE.GET;
707: FND_MESSAGE.SET_NAME('ICX','ICX_ITEM_ADD_RETURN_NEXT');
701: FND_MESSAGE.SET_TOKEN('CURRENCY_CODE',l_currency);
702: FND_MESSAGE.SET_TOKEN('REQUISITION_TOTAL',to_char(l_total_price,fnd_currency.get_format_mask(l_currency,30)));
703: l_message := l_message || '
' || FND_MESSAGE.GET;
704:
705: FND_MESSAGE.SET_NAME('ICX','ICX_ITEM_ADD_RETURN_CURRENT');
706: l_href1 := FND_MESSAGE.GET;
707: FND_MESSAGE.SET_NAME('ICX','ICX_ITEM_ADD_RETURN_NEXT');
708: l_href2 := FND_MESSAGE.GET;
709: l_messg := '
' || '
710: '&c_1=' || c_1 || '&i_1=' || i_1 ||Line 707: FND_MESSAGE.SET_NAME('ICX','ICX_ITEM_ADD_RETURN_NEXT'); |