421: fetch get_current_total into l_total_price;
422: close get_current_total;
423: end if;
424:
425: FND_MESSAGE.SET_NAME('ICX','ICX_ITEM_ADD_NEW');
426: FND_MESSAGE.SET_TOKEN('ITEM_QUANTITY',l_rows_added);
427: l_message := FND_MESSAGE.GET;
428: if l_rows_updated > 0 then
429: FND_MESSAGE.SET_NAME('ICX','ICX_ITEM_ADD_UPDATE');
422: close get_current_total;
423: end if;
424:
425: FND_MESSAGE.SET_NAME('ICX','ICX_ITEM_ADD_NEW');
426: FND_MESSAGE.SET_TOKEN('ITEM_QUANTITY',l_rows_added);
427: l_message := FND_MESSAGE.GET;
428: if l_rows_updated > 0 then
429: FND_MESSAGE.SET_NAME('ICX','ICX_ITEM_ADD_UPDATE');
430: FND_MESSAGE.SET_TOKEN('ITEM_QUANTITY',l_rows_updated);
423: end if;
424:
425: FND_MESSAGE.SET_NAME('ICX','ICX_ITEM_ADD_NEW');
426: FND_MESSAGE.SET_TOKEN('ITEM_QUANTITY',l_rows_added);
427: l_message := FND_MESSAGE.GET;
428: if l_rows_updated > 0 then
429: FND_MESSAGE.SET_NAME('ICX','ICX_ITEM_ADD_UPDATE');
430: FND_MESSAGE.SET_TOKEN('ITEM_QUANTITY',l_rows_updated);
431: if l_rows_added > 0 then
425: FND_MESSAGE.SET_NAME('ICX','ICX_ITEM_ADD_NEW');
426: FND_MESSAGE.SET_TOKEN('ITEM_QUANTITY',l_rows_added);
427: l_message := FND_MESSAGE.GET;
428: if l_rows_updated > 0 then
429: FND_MESSAGE.SET_NAME('ICX','ICX_ITEM_ADD_UPDATE');
430: FND_MESSAGE.SET_TOKEN('ITEM_QUANTITY',l_rows_updated);
431: if l_rows_added > 0 then
432: l_message := l_message || '
' || FND_MESSAGE.GET;
433: else
426: FND_MESSAGE.SET_TOKEN('ITEM_QUANTITY',l_rows_added);
427: l_message := FND_MESSAGE.GET;
428: if l_rows_updated > 0 then
429: FND_MESSAGE.SET_NAME('ICX','ICX_ITEM_ADD_UPDATE');
430: FND_MESSAGE.SET_TOKEN('ITEM_QUANTITY',l_rows_updated);
431: if l_rows_added > 0 then
432: l_message := l_message || '
' || FND_MESSAGE.GET;
433: else
434: l_message := FND_MESSAGE.GET;
428: if l_rows_updated > 0 then
429: FND_MESSAGE.SET_NAME('ICX','ICX_ITEM_ADD_UPDATE');
430: FND_MESSAGE.SET_TOKEN('ITEM_QUANTITY',l_rows_updated);
431: if l_rows_added > 0 then
432: l_message := l_message || '
' || FND_MESSAGE.GET;
433: else
434: l_message := FND_MESSAGE.GET;
435: end if;
436: end if;
430: FND_MESSAGE.SET_TOKEN('ITEM_QUANTITY',l_rows_updated);
431: if l_rows_added > 0 then
432: l_message := l_message || '
' || FND_MESSAGE.GET;
433: else
434: l_message := FND_MESSAGE.GET;
435: end if;
436: end if;
437:
438: if l_total_price > 0 then
436: end if;
437:
438: if l_total_price > 0 then
439: ICX_REQ_NAVIGATION.get_currency(l_dest_org_id,l_currency,l_money_precision,l_fmt_mask);
440: FND_MESSAGE.SET_NAME('ICX','ICX_ITEM_ADD_TOTAL');
441: FND_MESSAGE.SET_TOKEN('CURRENCY_CODE',l_currency);
442: FND_MESSAGE.SET_TOKEN('REQUISITION_TOTAL',to_char(l_total_price,fnd_currency.get_format_mask(l_currency,30)));
443: l_message := l_message || '
' || FND_MESSAGE.GET;
444:
437:
438: if l_total_price > 0 then
439: ICX_REQ_NAVIGATION.get_currency(l_dest_org_id,l_currency,l_money_precision,l_fmt_mask);
440: FND_MESSAGE.SET_NAME('ICX','ICX_ITEM_ADD_TOTAL');
441: FND_MESSAGE.SET_TOKEN('CURRENCY_CODE',l_currency);
442: FND_MESSAGE.SET_TOKEN('REQUISITION_TOTAL',to_char(l_total_price,fnd_currency.get_format_mask(l_currency,30)));
443: l_message := l_message || '
' || FND_MESSAGE.GET;
444:
445: l_message := l_message || '
';
438: if l_total_price > 0 then
439: ICX_REQ_NAVIGATION.get_currency(l_dest_org_id,l_currency,l_money_precision,l_fmt_mask);
440: FND_MESSAGE.SET_NAME('ICX','ICX_ITEM_ADD_TOTAL');
441: FND_MESSAGE.SET_TOKEN('CURRENCY_CODE',l_currency);
442: FND_MESSAGE.SET_TOKEN('REQUISITION_TOTAL',to_char(l_total_price,fnd_currency.get_format_mask(l_currency,30)));
443: l_message := l_message || '
' || FND_MESSAGE.GET;
444:
445: l_message := l_message || '
';
446: FND_MESSAGE.SET_NAME('ICX','ICX_ITEM_CATEGORY');
439: ICX_REQ_NAVIGATION.get_currency(l_dest_org_id,l_currency,l_money_precision,l_fmt_mask);
440: FND_MESSAGE.SET_NAME('ICX','ICX_ITEM_ADD_TOTAL');
441: FND_MESSAGE.SET_TOKEN('CURRENCY_CODE',l_currency);
442: FND_MESSAGE.SET_TOKEN('REQUISITION_TOTAL',to_char(l_total_price,fnd_currency.get_format_mask(l_currency,30)));
443: l_message := l_message || '
' || FND_MESSAGE.GET;
444:
445: l_message := l_message || '
';
446: FND_MESSAGE.SET_NAME('ICX','ICX_ITEM_CATEGORY');
447: l_messg := FND_MESSAGE.GET || ' ' || p_cat_name;
442: FND_MESSAGE.SET_TOKEN('REQUISITION_TOTAL',to_char(l_total_price,fnd_currency.get_format_mask(l_currency,30)));
443: l_message := l_message || '
' || FND_MESSAGE.GET;
444:
445: l_message := l_message || '
';
446: FND_MESSAGE.SET_NAME('ICX','ICX_ITEM_CATEGORY');
447: l_messg := FND_MESSAGE.GET || ' ' || p_cat_name;
448: FND_MESSAGE.SET_NAME('ICX','ICX_ITEM_ADD_SOURCE');
449: FND_MESSAGE.SET_TOKEN('SOURCE_NAME',l_messg);
450: l_message := l_message || FND_MESSAGE.GET;
443: l_message := l_message || '
' || FND_MESSAGE.GET;
444:
445: l_message := l_message || '
';
446: FND_MESSAGE.SET_NAME('ICX','ICX_ITEM_CATEGORY');
447: l_messg := FND_MESSAGE.GET || ' ' || p_cat_name;
448: FND_MESSAGE.SET_NAME('ICX','ICX_ITEM_ADD_SOURCE');
449: FND_MESSAGE.SET_TOKEN('SOURCE_NAME',l_messg);
450: l_message := l_message || FND_MESSAGE.GET;
451:
444:
445: l_message := l_message || '
';
446: FND_MESSAGE.SET_NAME('ICX','ICX_ITEM_CATEGORY');
447: l_messg := FND_MESSAGE.GET || ' ' || p_cat_name;
448: FND_MESSAGE.SET_NAME('ICX','ICX_ITEM_ADD_SOURCE');
449: FND_MESSAGE.SET_TOKEN('SOURCE_NAME',l_messg);
450: l_message := l_message || FND_MESSAGE.GET;
451:
452: FND_MESSAGE.SET_NAME('ICX','ICX_ITEM_ADD_RETURN_CURRENT');
445: l_message := l_message || '
';
446: FND_MESSAGE.SET_NAME('ICX','ICX_ITEM_CATEGORY');
447: l_messg := FND_MESSAGE.GET || ' ' || p_cat_name;
448: FND_MESSAGE.SET_NAME('ICX','ICX_ITEM_ADD_SOURCE');
449: FND_MESSAGE.SET_TOKEN('SOURCE_NAME',l_messg);
450: l_message := l_message || FND_MESSAGE.GET;
451:
452: FND_MESSAGE.SET_NAME('ICX','ICX_ITEM_ADD_RETURN_CURRENT');
453: l_href1 := FND_MESSAGE.GET;
446: FND_MESSAGE.SET_NAME('ICX','ICX_ITEM_CATEGORY');
447: l_messg := FND_MESSAGE.GET || ' ' || p_cat_name;
448: FND_MESSAGE.SET_NAME('ICX','ICX_ITEM_ADD_SOURCE');
449: FND_MESSAGE.SET_TOKEN('SOURCE_NAME',l_messg);
450: l_message := l_message || FND_MESSAGE.GET;
451:
452: FND_MESSAGE.SET_NAME('ICX','ICX_ITEM_ADD_RETURN_CURRENT');
453: l_href1 := FND_MESSAGE.GET;
454: FND_MESSAGE.SET_NAME('ICX','ICX_ITEM_ADD_RETURN_NEXT');
448: FND_MESSAGE.SET_NAME('ICX','ICX_ITEM_ADD_SOURCE');
449: FND_MESSAGE.SET_TOKEN('SOURCE_NAME',l_messg);
450: l_message := l_message || FND_MESSAGE.GET;
451:
452: FND_MESSAGE.SET_NAME('ICX','ICX_ITEM_ADD_RETURN_CURRENT');
453: l_href1 := FND_MESSAGE.GET;
454: FND_MESSAGE.SET_NAME('ICX','ICX_ITEM_ADD_RETURN_NEXT');
455: l_href2 := FND_MESSAGE.GET;
456: l_messg := '
' || ' 457: '/ICX_REQ_CATEGORIES.catalog_items?p_start_row=' || p_start_row || '&p_end_row=' || p_end_row || '&p_where=' || p_where || '">' || l_href1 || ' |
' || '' || l_href1 || ' |
' || '' || l_href1 || ' | |||
' || '' || l_return_to_next_message || ' | |||
' || '' || l_return_to_next_message || ' |
789: p_target => 'parent',
790: p_row_count => p_total_rows);
791: htp.p('');
792: htp.p('
790: p_row_count => p_total_rows);
791: htp.p('
792: htp.p('
936: end if;
937:
938: if ak_query_pkg.g_results_table.COUNT = 0 then
939: htp.bodyOpen('','BGCOLOR="#CCFFCC" onLoad="parent.parent.parent.winOpen(''nav'', ''catalog'')"');
940: fnd_message.set_name('EC','ICX_NO_RECORDS_FOUND');
941: fnd_message.set_token('NAME_OF_REGION_TOKEN',c_title);
942: htp.p('
937:
938: if ak_query_pkg.g_results_table.COUNT = 0 then
939: htp.bodyOpen('','BGCOLOR="#CCFFCC" onLoad="parent.parent.parent.winOpen(''nav'', ''catalog'')"');
940: fnd_message.set_name('EC','ICX_NO_RECORDS_FOUND');
941: fnd_message.set_token('NAME_OF_REGION_TOKEN',c_title);
942: htp.p('
938: if ak_query_pkg.g_results_table.COUNT = 0 then
939: htp.bodyOpen('','BGCOLOR="#CCFFCC" onLoad="parent.parent.parent.winOpen(''nav'', ''catalog'')"');
940: fnd_message.set_name('EC','ICX_NO_RECORDS_FOUND');
941: fnd_message.set_token('NAME_OF_REGION_TOKEN',c_title);
942: htp.p(''||fnd_message.get||'
');
943: htp.bodyClose;
944: return;
945: end if;
946: