DBA Data[Home] [Help]

APPS.ICX_REQ_CATEGORIES dependencies on FND_MESSAGE

Line 425: FND_MESSAGE.SET_NAME('ICX','ICX_ITEM_ADD_NEW');

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');

Line 426: FND_MESSAGE.SET_TOKEN('ITEM_QUANTITY',l_rows_added);

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);

Line 427: l_message := FND_MESSAGE.GET;

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

Line 429: FND_MESSAGE.SET_NAME('ICX','ICX_ITEM_ADD_UPDATE');

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

Line 430: FND_MESSAGE.SET_TOKEN('ITEM_QUANTITY',l_rows_updated);

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;

Line 432: l_message := 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;

Line 434: l_message := FND_MESSAGE.GET;

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

Line 440: FND_MESSAGE.SET_NAME('ICX','ICX_ITEM_ADD_TOTAL');

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:

Line 441: FND_MESSAGE.SET_TOKEN('CURRENCY_CODE',l_currency);

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 || '


';

Line 442: FND_MESSAGE.SET_TOKEN('REQUISITION_TOTAL',to_char(l_total_price,fnd_currency.get_format_mask(l_currency,30)));

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');

Line 443: l_message := l_message || '

' || FND_MESSAGE.GET;

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;

Line 446: FND_MESSAGE.SET_NAME('ICX','ICX_ITEM_CATEGORY');

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;

Line 447: l_messg := FND_MESSAGE.GET || ' ' || p_cat_name;

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:

Line 448: FND_MESSAGE.SET_NAME('ICX','ICX_ITEM_ADD_SOURCE');

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');

Line 449: FND_MESSAGE.SET_TOKEN('SOURCE_NAME',l_messg);

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;

Line 450: l_message := l_message || 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');

Line 452: FND_MESSAGE.SET_NAME('ICX','ICX_ITEM_ADD_RETURN_CURRENT');

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 := '';

Line 454: FND_MESSAGE.SET_NAME('ICX','ICX_ITEM_ADD_RETURN_NEXT');

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 || '
';
458:

Line 455: l_href2 := 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 := '




' || '' || l_href1 || '
';
458:
459: /* find next set start row and next set end row */

Line 477: FND_MESSAGE.SET_NAME('ICX','ICX_REVIEW_ORDER');

473:
474: end if;
475:
476: -- MESSAGE NEEDS TO BE SWITCHED TO REVIEW MY ORDER
477: FND_MESSAGE.SET_NAME('ICX','ICX_REVIEW_ORDER');
478: l_return_to_next_message := FND_MESSAGE.GET;
479: l_messg := l_messg || '

';
480:
481:

Line 478: l_return_to_next_message := FND_MESSAGE.GET;

474: end if;
475:
476: -- MESSAGE NEEDS TO BE SWITCHED TO REVIEW MY ORDER
477: FND_MESSAGE.SET_NAME('ICX','ICX_REVIEW_ORDER');
478: l_return_to_next_message := FND_MESSAGE.GET;
479: l_messg := l_messg || '

';
480:
481:
482: l_messg := l_messg || '



' || '' || l_href1 || '



' || '' || l_return_to_next_message || '



' || '' || l_return_to_next_message || '
';

Line 793: FND_MESSAGE.SET_NAME('ICX','ICX_ADD_TO_ORDER');

789: p_target => 'parent',
790: p_row_count => p_total_rows);
791: htp.p('');
792: htp.p('');
793: FND_MESSAGE.SET_NAME('ICX','ICX_ADD_TO_ORDER');
794: icx_util.DynamicButton(P_ButtonText => FND_MESSAGE.GET,
795: P_ImageFileName => 'FNDBNEW.gif',
796: P_OnMouseOverText => FND_MESSAGE.GET,
797: P_HyperTextCall => 'javascript:parent.frames[0].su

Line 794: icx_util.DynamicButton(P_ButtonText => FND_MESSAGE.GET,

790: p_row_count => p_total_rows);
791: htp.p('');
792: htp.p('');
793: FND_MESSAGE.SET_NAME('ICX','ICX_ADD_TO_ORDER');
794: icx_util.DynamicButton(P_ButtonText => FND_MESSAGE.GET,
795: P_ImageFileName => 'FNDBNEW.gif',
796: P_OnMouseOverText => FND_MESSAGE.GET,
797: P_HyperTextCall => 'javascript:parent.frames[0].su
798: bmit()',

Line 796: P_OnMouseOverText => FND_MESSAGE.GET,

792: htp.p('');
793: FND_MESSAGE.SET_NAME('ICX','ICX_ADD_TO_ORDER');
794: icx_util.DynamicButton(P_ButtonText => FND_MESSAGE.GET,
795: P_ImageFileName => 'FNDBNEW.gif',
796: P_OnMouseOverText => FND_MESSAGE.GET,
797: P_HyperTextCall => 'javascript:parent.frames[0].su
798: bmit()',
799: P_LanguageCode => v_lang,
800: P_JavaScriptFlag => FALSE);

Line 940: fnd_message.set_name('EC','ICX_NO_RECORDS_FOUND');

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('

'||fnd_message.get||'

');
943: htp.bodyClose;
944: return;

Line 941: fnd_message.set_token('NAME_OF_REGION_TOKEN',c_title);

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('

'||fnd_message.get||'

');
943: htp.bodyClose;
944: return;
945: end if;

Line 942: htp.p('

'||fnd_message.get||'

');

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: