DBA Data[Home] [Help]

APPS.WF_MESSAGES_VL_PUB dependencies on WF_CORE

Line 243: Wf_Core.Context('wf_messages_vl_pub',

239: END IF;
240:
241: EXCEPTION
242: WHEN OTHERS THEN
243: Wf_Core.Context('wf_messages_vl_pub',
244: 'fetch_messages',
245: p_item_type,
246: p_name);
247:

Line 283: ' -- '||UPPER(wf_core.translate ('WFITD_UNDEFINED'))||'';

279: */
280: IF (l_wf_messages_vl_tbl.count < 1) THEN
281:
282: l_display_name := p_internal_name||' '||
283: ' -- '||UPPER(wf_core.translate ('WFITD_UNDEFINED'))||'';
284:
285: ELSE
286:
287: l_display_name := l_wf_messages_vl_tbl(1).display_name;

Line 295: Wf_Core.Context('wf_messages_pub',

291: p_display_name := l_display_name;
292:
293: EXCEPTION
294: WHEN OTHERS THEN
295: Wf_Core.Context('wf_messages_pub',
296: 'fetch_message_display',
297: p_internal_name);
298:
299: END fetch_message_display;

Line 337: wf_core.translate('WFITD_MESSAGES'),

333: /*
334: ** Create the the messages title. Indent it to the level specified
335: */
336: wf_item_definition_util_pub.draw_summary_section_title(
337: wf_core.translate('WFITD_MESSAGES'),
338: p_indent_level);
339:
340: /*
341: ** Print out all message display names in the pl*sql table

Line 420: Wf_Core.Context('wf_messages_vl_pub', 'draw_message_list');

416: END LOOP;
417:
418: EXCEPTION
419: WHEN OTHERS THEN
420: Wf_Core.Context('wf_messages_vl_pub', 'draw_message_list');
421: wf_item_definition.Error;
422:
423: END draw_message_list;
424:

Line 449: wf_core.translate('WFITD_MESSAGE_ATTRS'),

445: /*
446: ** Create the the messages title. Indent it to the level specified
447: */
448: wf_item_definition_util_pub.draw_summary_section_title(
449: wf_core.translate('WFITD_MESSAGE_ATTRS'),
450: p_indent_level);
451:
452: /*
453: ** Print out all message display names in the pl*sql table

Line 480: Wf_Core.Context('wf_messages_vl_pub', 'draw_message_attr_list');

476: END LOOP;
477:
478: EXCEPTION
479: WHEN OTHERS THEN
480: Wf_Core.Context('wf_messages_vl_pub', 'draw_message_attr_list');
481: wf_item_definition.Error;
482:
483: END draw_message_attr_list;
484:

Line 523: wf_core.translate('WFITD_MESSAGE_DETAILS'),

519: /*
520: ** Draw the section title for the Message detail section
521: */
522: wf_item_definition_util_pub.draw_detail_section_title (
523: wf_core.translate('WFITD_MESSAGE_DETAILS'),
524: 0);
525:
526: /*
527: ** Print out all item attribute display names in the pl*sql table

Line 547: wf_core.translate('WFITD_MESSAGE_NAME'),

543: wf_item_definition_util_pub.create_details_hotlink_target (
544: 'MESSAGE',
545: p_wf_messages_vl_tbl(l_message_record_num).name,
546: p_wf_messages_vl_tbl(l_message_record_num).display_name,
547: wf_core.translate('WFITD_MESSAGE_NAME'),
548: 0);
549:
550: /*
551: ** Create the internal name row in the table.

Line 554: wf_core.translate('WFITD_INTERNAL_NAME'),

550: /*
551: ** Create the internal name row in the table.
552: */
553: wf_item_definition_util_pub.draw_detail_prompt_value_pair (
554: wf_core.translate('WFITD_INTERNAL_NAME'),
555: p_wf_messages_vl_tbl(l_message_record_num).name);
556:
557: /*
558: ** Create the description row in the table

Line 561: wf_core.translate('DESCRIPTION'),

557: /*
558: ** Create the description row in the table
559: */
560: wf_item_definition_util_pub.draw_detail_prompt_value_pair (
561: wf_core.translate('DESCRIPTION'),
562: p_wf_messages_vl_tbl(l_message_record_num).description);
563:
564:
565: IF (p_wf_messages_vl_tbl(l_message_record_num).default_priority < 34) THEN

Line 566: pri := wf_core.translate('HIGH');

562: p_wf_messages_vl_tbl(l_message_record_num).description);
563:
564:
565: IF (p_wf_messages_vl_tbl(l_message_record_num).default_priority < 34) THEN
566: pri := wf_core.translate('HIGH');
567:
568: ELSIF (p_wf_messages_vl_tbl(l_message_record_num).default_priority > 66) THEN
569: pri := wf_core.translate('LOW');
570:

Line 569: pri := wf_core.translate('LOW');

565: IF (p_wf_messages_vl_tbl(l_message_record_num).default_priority < 34) THEN
566: pri := wf_core.translate('HIGH');
567:
568: ELSIF (p_wf_messages_vl_tbl(l_message_record_num).default_priority > 66) THEN
569: pri := wf_core.translate('LOW');
570:
571: ELSE
572:
573: pri := wf_core.translate('MEDIUM');

Line 573: pri := wf_core.translate('MEDIUM');

569: pri := wf_core.translate('LOW');
570:
571: ELSE
572:
573: pri := wf_core.translate('MEDIUM');
574:
575: END IF;
576:
577: /*

Line 581: wf_core.translate('PRIORITY'), pri);

577: /*
578: ** Create the priority row in the table
579: */
580: wf_item_definition_util_pub.draw_detail_prompt_value_pair (
581: wf_core.translate('PRIORITY'), pri);
582:
583: /*
584: ** Create the Subject row in the table
585: */

Line 587: wf_core.translate('SUBJECT'),

583: /*
584: ** Create the Subject row in the table
585: */
586: wf_item_definition_util_pub.draw_detail_prompt_value_pair (
587: wf_core.translate('SUBJECT'),
588: p_wf_messages_vl_tbl(l_message_record_num).subject);
589:
590: /*
591: ** Create the html body row in the table

Line 594: wf_core.translate('WFITD_HTML_BODY'),

590: /*
591: ** Create the html body row in the table
592: */
593: wf_item_definition_util_pub.draw_detail_prompt_value_pair (
594: wf_core.translate('WFITD_HTML_BODY'),
595: p_wf_messages_vl_tbl(l_message_record_num).html_body);
596:
597: /*
598: ** Create the text body row in the table

Line 601: wf_core.translate('WFITD_TEXT_BODY'),

597: /*
598: ** Create the text body row in the table
599: */
600: wf_item_definition_util_pub.draw_detail_prompt_value_pair (
601: wf_core.translate('WFITD_TEXT_BODY'),
602: p_wf_messages_vl_tbl(l_message_record_num).body);
603:
604: /*
605: ** Call function to print the read/write/execute roles

Line 765: wf_core.translate('WFITD_MESSAGE_DETAILS'),

761: /*
762: ** Draw the section title for the Message detail section
763: */
764: wf_item_definition_util_pub.draw_detail_section_title (
765: wf_core.translate('WFITD_MESSAGE_DETAILS'),
766: 0);
767:
768: END IF;
769:

Line 789: Wf_Core.Context('wf_messages_vl_pub', 'draw_message_details');

785: END LOOP;
786:
787: EXCEPTION
788: WHEN OTHERS THEN
789: Wf_Core.Context('wf_messages_vl_pub', 'draw_message_details');
790: wf_item_definition.Error;
791:
792: END draw_message_details;
793:

Line 822: wf_core.translate('WFITD_MESSAGE_ATTR_DETAILS'),

818: */
819: IF (p_indent_level <> -1) THEN
820:
821: wf_item_definition_util_pub.draw_detail_section_title (
822: wf_core.translate('WFITD_MESSAGE_ATTR_DETAILS'),
823: 0);
824:
825: END IF;
826:

Line 851: wf_core.translate('WFITD_MESSAGE_ATTR_NAME'),

847: 'MESSAGE_ATTR',
848: p_wf_message_attr_vl_tbl(l_record_num).message_name||':'||
849: p_wf_message_attr_vl_tbl(l_record_num).name,
850: p_wf_message_attr_vl_tbl(l_record_num).display_name,
851: wf_core.translate('WFITD_MESSAGE_ATTR_NAME'),
852: 0);
853:
854: /*
855: ** Create the internal name row in the table.

Line 858: wf_core.translate('WFITD_INTERNAL_NAME'),

854: /*
855: ** Create the internal name row in the table.
856: */
857: wf_item_definition_util_pub.draw_detail_prompt_value_pair (
858: wf_core.translate('WFITD_INTERNAL_NAME'),
859: p_wf_message_attr_vl_tbl(l_record_num).name);
860:
861: /*
862: ** Create the message display name row in the table.

Line 865: wf_core.translate('WFITD_MESSAGE_NAME'),

861: /*
862: ** Create the message display name row in the table.
863: */
864: wf_item_definition_util_pub.draw_detail_prompt_value_pair (
865: wf_core.translate('WFITD_MESSAGE_NAME'),
866: p_wf_message_attr_vl_tbl(l_record_num).message_display_name);
867:
868: ELSE
869:

Line 874: wf_core.translate('WFITD_RESULT_DISPLAY_NAME'),

870: /*
871: ** Create the attribute display name row in the table.
872: */
873: wf_item_definition_util_pub.draw_detail_prompt_value_pair (
874: wf_core.translate('WFITD_RESULT_DISPLAY_NAME'),
875: p_wf_message_attr_vl_tbl(l_record_num).display_name);
876:
877: END IF;
878:

Line 883: wf_core.translate('DESCRIPTION'),

879: /*
880: ** Create the description row in the table
881: */
882: wf_item_definition_util_pub.draw_detail_prompt_value_pair (
883: wf_core.translate('DESCRIPTION'),
884: p_wf_message_attr_vl_tbl(l_record_num).description);
885:
886: /*
887: ** Create the attribute type row in the table

Line 890: wf_core.translate('WFITD_ATTRIBUTE_TYPE'),

886: /*
887: ** Create the attribute type row in the table
888: */
889: wf_item_definition_util_pub.draw_detail_prompt_value_pair (
890: wf_core.translate('WFITD_ATTRIBUTE_TYPE'),
891: wf_core.translate('WFITD_ATTR_TYPE_'||
892: p_wf_message_attr_vl_tbl(l_record_num).type));
893:
894: /*

Line 891: wf_core.translate('WFITD_ATTR_TYPE_'||

887: ** Create the attribute type row in the table
888: */
889: wf_item_definition_util_pub.draw_detail_prompt_value_pair (
890: wf_core.translate('WFITD_ATTRIBUTE_TYPE'),
891: wf_core.translate('WFITD_ATTR_TYPE_'||
892: p_wf_message_attr_vl_tbl(l_record_num).type));
893:
894: /*
895: ** Create the length/format/lookup type row in the table.

Line 904: wf_core.translate('LENGTH'),

900: */
901: IF (p_wf_message_attr_vl_tbl(l_record_num).type = 'VARCHAR2') THEN
902:
903: wf_item_definition_util_pub.draw_detail_prompt_value_pair (
904: wf_core.translate('LENGTH'),
905: p_wf_message_attr_vl_tbl(l_record_num).format);
906:
907: ELSIF (p_wf_message_attr_vl_tbl(l_record_num).type IN ('NUMBER', 'DATE')) THEN
908:

Line 910: wf_core.translate('FORMAT'),

906:
907: ELSIF (p_wf_message_attr_vl_tbl(l_record_num).type IN ('NUMBER', 'DATE')) THEN
908:
909: wf_item_definition_util_pub.draw_detail_prompt_value_pair (
910: wf_core.translate('FORMAT'),
911: p_wf_message_attr_vl_tbl(l_record_num).format);
912:
913: ELSIF (p_wf_message_attr_vl_tbl(l_record_num).type = 'LOOKUP') THEN
914:

Line 916: wf_core.translate('LOOKUP'),

912:
913: ELSIF (p_wf_message_attr_vl_tbl(l_record_num).type = 'LOOKUP') THEN
914:
915: wf_item_definition_util_pub.draw_detail_prompt_value_pair (
916: wf_core.translate('LOOKUP'),
917: p_wf_message_attr_vl_tbl(l_record_num).lookup_type_display_name);
918:
919: ELSIF (p_wf_message_attr_vl_tbl(l_record_num).type IN ('URL','DOCUMENT')) THEN
920: /*

Line 925: (wf_core.translate('WFITD_FRAME_TARGET'), wf_core.translate('WFITD_TOP'));

921: ** If it is URL or DOCUMENT, indicate where the resulting page should be displayed
922: */
923: IF (NVL(p_wf_message_attr_vl_tbl(l_record_num).format, '_top') = '_top') THEN
924: wf_item_definition_util_pub.draw_detail_prompt_value_pair
925: (wf_core.translate('WFITD_FRAME_TARGET'), wf_core.translate('WFITD_TOP'));
926: ELSIF (p_wf_message_attr_vl_tbl(l_record_num).format = '_blank') THEN
927: wf_item_definition_util_pub.draw_detail_prompt_value_pair
928: (wf_core.translate('WFITD_FRAME_TARGET'), wf_core.translate('WFITD_BLANK'));
929: ELSIF (p_wf_message_attr_vl_tbl(l_record_num).format = '_self') THEN

Line 928: (wf_core.translate('WFITD_FRAME_TARGET'), wf_core.translate('WFITD_BLANK'));

924: wf_item_definition_util_pub.draw_detail_prompt_value_pair
925: (wf_core.translate('WFITD_FRAME_TARGET'), wf_core.translate('WFITD_TOP'));
926: ELSIF (p_wf_message_attr_vl_tbl(l_record_num).format = '_blank') THEN
927: wf_item_definition_util_pub.draw_detail_prompt_value_pair
928: (wf_core.translate('WFITD_FRAME_TARGET'), wf_core.translate('WFITD_BLANK'));
929: ELSIF (p_wf_message_attr_vl_tbl(l_record_num).format = '_self') THEN
930: wf_item_definition_util_pub.draw_detail_prompt_value_pair
931: (wf_core.translate('WFITD_FRAME_TARGET'), wf_core.translate('WFITD_SELF'));
932: ELSIF (p_wf_message_attr_vl_tbl(l_record_num).format = '_parent') THEN

Line 931: (wf_core.translate('WFITD_FRAME_TARGET'), wf_core.translate('WFITD_SELF'));

927: wf_item_definition_util_pub.draw_detail_prompt_value_pair
928: (wf_core.translate('WFITD_FRAME_TARGET'), wf_core.translate('WFITD_BLANK'));
929: ELSIF (p_wf_message_attr_vl_tbl(l_record_num).format = '_self') THEN
930: wf_item_definition_util_pub.draw_detail_prompt_value_pair
931: (wf_core.translate('WFITD_FRAME_TARGET'), wf_core.translate('WFITD_SELF'));
932: ELSIF (p_wf_message_attr_vl_tbl(l_record_num).format = '_parent') THEN
933: wf_item_definition_util_pub.draw_detail_prompt_value_pair
934: (wf_core.translate('WFITD_FRAME_TARGET'), wf_core.translate('WFITD_PARENT'));
935: END IF;

Line 934: (wf_core.translate('WFITD_FRAME_TARGET'), wf_core.translate('WFITD_PARENT'));

930: wf_item_definition_util_pub.draw_detail_prompt_value_pair
931: (wf_core.translate('WFITD_FRAME_TARGET'), wf_core.translate('WFITD_SELF'));
932: ELSIF (p_wf_message_attr_vl_tbl(l_record_num).format = '_parent') THEN
933: wf_item_definition_util_pub.draw_detail_prompt_value_pair
934: (wf_core.translate('WFITD_FRAME_TARGET'), wf_core.translate('WFITD_PARENT'));
935: END IF;
936:
937: /*
938: ** If the message attribute is a send, then display the attachment

Line 944: wf_core.translate('WFITD_ATTACH'),

940: */
941: IF p_wf_message_attr_vl_tbl(l_record_num).subtype = 'SEND' THEN
942: IF NVL(p_wf_message_attr_vl_tbl(l_record_num).attach, 'N') = 'Y' THEN
943: wf_item_definition_util_pub.draw_detail_prompt_value_pair (
944: wf_core.translate('WFITD_ATTACH'),
945: wf_core.translate('WFITD_YES'));
946: ELSE
947: wf_item_definition_util_pub.draw_detail_prompt_value_pair (
948: wf_core.translate('WFITD_ATTACH'),

Line 945: wf_core.translate('WFITD_YES'));

941: IF p_wf_message_attr_vl_tbl(l_record_num).subtype = 'SEND' THEN
942: IF NVL(p_wf_message_attr_vl_tbl(l_record_num).attach, 'N') = 'Y' THEN
943: wf_item_definition_util_pub.draw_detail_prompt_value_pair (
944: wf_core.translate('WFITD_ATTACH'),
945: wf_core.translate('WFITD_YES'));
946: ELSE
947: wf_item_definition_util_pub.draw_detail_prompt_value_pair (
948: wf_core.translate('WFITD_ATTACH'),
949: wf_core.translate('WFITD_NO'));

Line 948: wf_core.translate('WFITD_ATTACH'),

944: wf_core.translate('WFITD_ATTACH'),
945: wf_core.translate('WFITD_YES'));
946: ELSE
947: wf_item_definition_util_pub.draw_detail_prompt_value_pair (
948: wf_core.translate('WFITD_ATTACH'),
949: wf_core.translate('WFITD_NO'));
950: END iF;
951:
952: END IF;

Line 949: wf_core.translate('WFITD_NO'));

945: wf_core.translate('WFITD_YES'));
946: ELSE
947: wf_item_definition_util_pub.draw_detail_prompt_value_pair (
948: wf_core.translate('WFITD_ATTACH'),
949: wf_core.translate('WFITD_NO'));
950: END iF;
951:
952: END IF;
953: END IF;

Line 961: wf_core.translate('WFITD_SOURCE'),

957: */
958: IF (p_indent_level <> -1) THEN
959:
960: wf_item_definition_util_pub.draw_detail_prompt_value_pair (
961: wf_core.translate('WFITD_SOURCE'),
962: wf_core.translate('WFITD_MSG_SOURCE_TYPE_'||
963: p_wf_message_attr_vl_tbl(l_record_num).subtype));
964:
965: END IF;

Line 962: wf_core.translate('WFITD_MSG_SOURCE_TYPE_'||

958: IF (p_indent_level <> -1) THEN
959:
960: wf_item_definition_util_pub.draw_detail_prompt_value_pair (
961: wf_core.translate('WFITD_SOURCE'),
962: wf_core.translate('WFITD_MSG_SOURCE_TYPE_'||
963: p_wf_message_attr_vl_tbl(l_record_num).subtype));
964:
965: END IF;
966:

Line 971: wf_core.translate('WFITD_DEFAULT_TYPE'),

967: /*
968: ** Create the default type row
969: */
970: wf_item_definition_util_pub.draw_detail_prompt_value_pair (
971: wf_core.translate('WFITD_DEFAULT_TYPE'),
972: wf_core.translate('WFITD_DEFAULT_TYPE_'||
973: p_wf_message_attr_vl_tbl(l_record_num).value_type));
974:
975: /*

Line 972: wf_core.translate('WFITD_DEFAULT_TYPE_'||

968: ** Create the default type row
969: */
970: wf_item_definition_util_pub.draw_detail_prompt_value_pair (
971: wf_core.translate('WFITD_DEFAULT_TYPE'),
972: wf_core.translate('WFITD_DEFAULT_TYPE_'||
973: p_wf_message_attr_vl_tbl(l_record_num).value_type));
974:
975: /*
976: ** If the default value is a constant then show the default value type

Line 987: wf_core.translate('WFITD_DEFAULT_VALUE'),

983: ** Create the default item attribute row in the table. This is based on the
984: ** p_wf_message_attr_vl_tbl(l_record_num).attr_default_display_name
985: */
986: wf_item_definition_util_pub.draw_detail_prompt_value_pair (
987: wf_core.translate('WFITD_DEFAULT_VALUE'),
988: p_wf_message_attr_vl_tbl(l_record_num).attr_default_display_name);
989:
990:
991: /*

Line 999: wf_core.translate('WFITD_DEFAULT_VALUE'),

995: */
996: ELSIF (p_wf_message_attr_vl_tbl(l_record_num).type = 'LOOKUP') THEN
997:
998: wf_item_definition_util_pub.draw_detail_prompt_value_pair (
999: wf_core.translate('WFITD_DEFAULT_VALUE'),
1000: p_wf_message_attr_vl_tbl(l_record_num).lookup_code_display_name);
1001:
1002: /*
1003: ** If this is any other attribute type then

Line 1010: wf_core.translate('WFITD_DEFAULT_VALUE'),

1006: */
1007: ELSE
1008:
1009: wf_item_definition_util_pub.draw_detail_prompt_value_pair (
1010: wf_core.translate('WFITD_DEFAULT_VALUE'),
1011: NVL(p_wf_message_attr_vl_tbl(l_record_num).text_default,
1012: NVL(TO_CHAR(p_wf_message_attr_vl_tbl(l_record_num).number_default),
1013: TO_CHAR(p_wf_message_attr_vl_tbl(l_record_num).date_default))));
1014:

Line 1036: Wf_Core.Context('wf_messages_vl_pub', 'draw_message_attr_details');

1032: END LOOP;
1033:
1034: EXCEPTION
1035: WHEN OTHERS THEN
1036: Wf_Core.Context('wf_messages_vl_pub', 'draw_message_attr_details');
1037: wf_item_definition.Error;
1038:
1039: END draw_message_attr_details;
1040: