DBA Data[Home] [Help]

APPS.PON_EVAL_TEAM_UTIL_PVT dependencies on FND_MESSAGE

Line 438: fnd_message.set_name('PON', 'PON_SM_ET_UPDATE_SUB');

434: INTO l_member_user_name
435: FROM fnd_user
436: WHERE user_id = p_member_user_id;
437:
438: fnd_message.set_name('PON', 'PON_SM_ET_UPDATE_SUB');
439: fnd_message.set_token('DOC_TYPE', l_doc_type);
440: fnd_message.set_token('DOC_NUMBER', l_doc_number);
441: fnd_message.set_token('AUCTION_TITLE', l_auction_title);
442: l_et_update_subject := fnd_message.get;

Line 439: fnd_message.set_token('DOC_TYPE', l_doc_type);

435: FROM fnd_user
436: WHERE user_id = p_member_user_id;
437:
438: fnd_message.set_name('PON', 'PON_SM_ET_UPDATE_SUB');
439: fnd_message.set_token('DOC_TYPE', l_doc_type);
440: fnd_message.set_token('DOC_NUMBER', l_doc_number);
441: fnd_message.set_token('AUCTION_TITLE', l_auction_title);
442: l_et_update_subject := fnd_message.get;
443:

Line 440: fnd_message.set_token('DOC_NUMBER', l_doc_number);

436: WHERE user_id = p_member_user_id;
437:
438: fnd_message.set_name('PON', 'PON_SM_ET_UPDATE_SUB');
439: fnd_message.set_token('DOC_TYPE', l_doc_type);
440: fnd_message.set_token('DOC_NUMBER', l_doc_number);
441: fnd_message.set_token('AUCTION_TITLE', l_auction_title);
442: l_et_update_subject := fnd_message.get;
443:
444: l_neg_summary_url := pon_wf_utl_pkg.get_dest_page_url

Line 441: fnd_message.set_token('AUCTION_TITLE', l_auction_title);

437:
438: fnd_message.set_name('PON', 'PON_SM_ET_UPDATE_SUB');
439: fnd_message.set_token('DOC_TYPE', l_doc_type);
440: fnd_message.set_token('DOC_NUMBER', l_doc_number);
441: fnd_message.set_token('AUCTION_TITLE', l_auction_title);
442: l_et_update_subject := fnd_message.get;
443:
444: l_neg_summary_url := pon_wf_utl_pkg.get_dest_page_url
445: ( p_dest_func => 'PON_NEG_SUMMARY',

Line 442: l_et_update_subject := fnd_message.get;

438: fnd_message.set_name('PON', 'PON_SM_ET_UPDATE_SUB');
439: fnd_message.set_token('DOC_TYPE', l_doc_type);
440: fnd_message.set_token('DOC_NUMBER', l_doc_number);
441: fnd_message.set_token('AUCTION_TITLE', l_auction_title);
442: l_et_update_subject := fnd_message.get;
443:
444: l_neg_summary_url := pon_wf_utl_pkg.get_dest_page_url
445: ( p_dest_func => 'PON_NEG_SUMMARY',
446: p_notif_performer => 'BUYER'

Line 843: fnd_message.set_name('PON', l_msg_name);

839: ELSE
840: l_msg_name := l_msg_name || '_TB';
841: END IF;
842:
843: fnd_message.set_name('PON', l_msg_name);
844: fnd_message.set_token
845: ( 'TEAM_MEMBER',
846: get_display_name_for_user(l_team_members_rec.user_id)
847: );

Line 844: fnd_message.set_token

840: l_msg_name := l_msg_name || '_TB';
841: END IF;
842:
843: fnd_message.set_name('PON', l_msg_name);
844: fnd_message.set_token
845: ( 'TEAM_MEMBER',
846: get_display_name_for_user(l_team_members_rec.user_id)
847: );
848: fnd_message.set_token('DOC_TYPE', l_doc_type);

Line 848: fnd_message.set_token('DOC_TYPE', l_doc_type);

844: fnd_message.set_token
845: ( 'TEAM_MEMBER',
846: get_display_name_for_user(l_team_members_rec.user_id)
847: );
848: fnd_message.set_token('DOC_TYPE', l_doc_type);
849: fnd_message.set_token('DOC_NUMBER', l_doc_number);
850: fnd_message.set_token('TEAM_NAME', l_team_members_rec.team_name);
851: fnd_message.set_token('SECTIONS', l_team_members_rec.sections);
852:

Line 849: fnd_message.set_token('DOC_NUMBER', l_doc_number);

845: ( 'TEAM_MEMBER',
846: get_display_name_for_user(l_team_members_rec.user_id)
847: );
848: fnd_message.set_token('DOC_TYPE', l_doc_type);
849: fnd_message.set_token('DOC_NUMBER', l_doc_number);
850: fnd_message.set_token('TEAM_NAME', l_team_members_rec.team_name);
851: fnd_message.set_token('SECTIONS', l_team_members_rec.sections);
852:
853: IF (p_display_type = 'text/html') THEN

Line 850: fnd_message.set_token('TEAM_NAME', l_team_members_rec.team_name);

846: get_display_name_for_user(l_team_members_rec.user_id)
847: );
848: fnd_message.set_token('DOC_TYPE', l_doc_type);
849: fnd_message.set_token('DOC_NUMBER', l_doc_number);
850: fnd_message.set_token('TEAM_NAME', l_team_members_rec.team_name);
851: fnd_message.set_token('SECTIONS', l_team_members_rec.sections);
852:
853: IF (p_display_type = 'text/html') THEN
854: fnd_message.set_token('NEG_SUMMARY_URL', l_neg_summary_url);

Line 851: fnd_message.set_token('SECTIONS', l_team_members_rec.sections);

847: );
848: fnd_message.set_token('DOC_TYPE', l_doc_type);
849: fnd_message.set_token('DOC_NUMBER', l_doc_number);
850: fnd_message.set_token('TEAM_NAME', l_team_members_rec.team_name);
851: fnd_message.set_token('SECTIONS', l_team_members_rec.sections);
852:
853: IF (p_display_type = 'text/html') THEN
854: fnd_message.set_token('NEG_SUMMARY_URL', l_neg_summary_url);
855: END IF;

Line 854: fnd_message.set_token('NEG_SUMMARY_URL', l_neg_summary_url);

850: fnd_message.set_token('TEAM_NAME', l_team_members_rec.team_name);
851: fnd_message.set_token('SECTIONS', l_team_members_rec.sections);
852:
853: IF (p_display_type = 'text/html') THEN
854: fnd_message.set_token('NEG_SUMMARY_URL', l_neg_summary_url);
855: END IF;
856:
857: l_document := l_document || fnd_message.get;
858:

Line 857: l_document := l_document || fnd_message.get;

853: IF (p_display_type = 'text/html') THEN
854: fnd_message.set_token('NEG_SUMMARY_URL', l_neg_summary_url);
855: END IF;
856:
857: l_document := l_document || fnd_message.get;
858:
859: END LOOP;
860:
861: FOR i IN 1..l_team_sections_tbl.COUNT LOOP

Line 877: fnd_message.set_name('PON', l_msg_name);

873: ELSE
874: l_msg_name := l_msg_name || '_TB';
875: END IF;
876:
877: fnd_message.set_name('PON', l_msg_name);
878:
879: fnd_message.set_token('TEAM_NAME', l_team_sections_rec.team_name);
880: fnd_message.set_token('SECTIONS', l_team_sections_rec.sections);
881: fnd_message.set_token('DOC_TYPE', l_doc_type);

Line 879: fnd_message.set_token('TEAM_NAME', l_team_sections_rec.team_name);

875: END IF;
876:
877: fnd_message.set_name('PON', l_msg_name);
878:
879: fnd_message.set_token('TEAM_NAME', l_team_sections_rec.team_name);
880: fnd_message.set_token('SECTIONS', l_team_sections_rec.sections);
881: fnd_message.set_token('DOC_TYPE', l_doc_type);
882: fnd_message.set_token('DOC_NUMBER', l_doc_number);
883:

Line 880: fnd_message.set_token('SECTIONS', l_team_sections_rec.sections);

876:
877: fnd_message.set_name('PON', l_msg_name);
878:
879: fnd_message.set_token('TEAM_NAME', l_team_sections_rec.team_name);
880: fnd_message.set_token('SECTIONS', l_team_sections_rec.sections);
881: fnd_message.set_token('DOC_TYPE', l_doc_type);
882: fnd_message.set_token('DOC_NUMBER', l_doc_number);
883:
884: IF (p_display_type = 'text/html') THEN

Line 881: fnd_message.set_token('DOC_TYPE', l_doc_type);

877: fnd_message.set_name('PON', l_msg_name);
878:
879: fnd_message.set_token('TEAM_NAME', l_team_sections_rec.team_name);
880: fnd_message.set_token('SECTIONS', l_team_sections_rec.sections);
881: fnd_message.set_token('DOC_TYPE', l_doc_type);
882: fnd_message.set_token('DOC_NUMBER', l_doc_number);
883:
884: IF (p_display_type = 'text/html') THEN
885: fnd_message.set_token('NEG_SUMMARY_URL', l_neg_summary_url);

Line 882: fnd_message.set_token('DOC_NUMBER', l_doc_number);

878:
879: fnd_message.set_token('TEAM_NAME', l_team_sections_rec.team_name);
880: fnd_message.set_token('SECTIONS', l_team_sections_rec.sections);
881: fnd_message.set_token('DOC_TYPE', l_doc_type);
882: fnd_message.set_token('DOC_NUMBER', l_doc_number);
883:
884: IF (p_display_type = 'text/html') THEN
885: fnd_message.set_token('NEG_SUMMARY_URL', l_neg_summary_url);
886: END IF;

Line 885: fnd_message.set_token('NEG_SUMMARY_URL', l_neg_summary_url);

881: fnd_message.set_token('DOC_TYPE', l_doc_type);
882: fnd_message.set_token('DOC_NUMBER', l_doc_number);
883:
884: IF (p_display_type = 'text/html') THEN
885: fnd_message.set_token('NEG_SUMMARY_URL', l_neg_summary_url);
886: END IF;
887:
888: l_document := l_document || fnd_message.get;
889:

Line 888: l_document := l_document || fnd_message.get;

884: IF (p_display_type = 'text/html') THEN
885: fnd_message.set_token('NEG_SUMMARY_URL', l_neg_summary_url);
886: END IF;
887:
888: l_document := l_document || fnd_message.get;
889:
890: END LOOP;
891:
892: wf_notification.WriteToClob(x_document, l_document);

Line 1002: fnd_message.set_name('PON', 'PON_SM_EVAL_UPDATE_SCORER_SUB');

998:
999:
1000: l_doc_type := pon_auction_pkg.getMessage('PON_AUCTION', '_'||l_msg_suffix);
1001:
1002: fnd_message.set_name('PON', 'PON_SM_EVAL_UPDATE_SCORER_SUB');
1003: fnd_message.set_token('DOC_TYPE', l_doc_type);
1004: fnd_message.set_token('DOC_NUMBER', l_doc_number);
1005: fnd_message.set_token('AUCTION_TITLE', l_auction_title);
1006: l_eval_update_sub := fnd_message.get;

Line 1003: fnd_message.set_token('DOC_TYPE', l_doc_type);

999:
1000: l_doc_type := pon_auction_pkg.getMessage('PON_AUCTION', '_'||l_msg_suffix);
1001:
1002: fnd_message.set_name('PON', 'PON_SM_EVAL_UPDATE_SCORER_SUB');
1003: fnd_message.set_token('DOC_TYPE', l_doc_type);
1004: fnd_message.set_token('DOC_NUMBER', l_doc_number);
1005: fnd_message.set_token('AUCTION_TITLE', l_auction_title);
1006: l_eval_update_sub := fnd_message.get;
1007:

Line 1004: fnd_message.set_token('DOC_NUMBER', l_doc_number);

1000: l_doc_type := pon_auction_pkg.getMessage('PON_AUCTION', '_'||l_msg_suffix);
1001:
1002: fnd_message.set_name('PON', 'PON_SM_EVAL_UPDATE_SCORER_SUB');
1003: fnd_message.set_token('DOC_TYPE', l_doc_type);
1004: fnd_message.set_token('DOC_NUMBER', l_doc_number);
1005: fnd_message.set_token('AUCTION_TITLE', l_auction_title);
1006: l_eval_update_sub := fnd_message.get;
1007:
1008: l_neg_summary_url := pon_wf_utl_pkg.get_dest_page_url

Line 1005: fnd_message.set_token('AUCTION_TITLE', l_auction_title);

1001:
1002: fnd_message.set_name('PON', 'PON_SM_EVAL_UPDATE_SCORER_SUB');
1003: fnd_message.set_token('DOC_TYPE', l_doc_type);
1004: fnd_message.set_token('DOC_NUMBER', l_doc_number);
1005: fnd_message.set_token('AUCTION_TITLE', l_auction_title);
1006: l_eval_update_sub := fnd_message.get;
1007:
1008: l_neg_summary_url := pon_wf_utl_pkg.get_dest_page_url
1009: ( p_dest_func => 'PON_NEG_SUMMARY',

Line 1006: l_eval_update_sub := fnd_message.get;

1002: fnd_message.set_name('PON', 'PON_SM_EVAL_UPDATE_SCORER_SUB');
1003: fnd_message.set_token('DOC_TYPE', l_doc_type);
1004: fnd_message.set_token('DOC_NUMBER', l_doc_number);
1005: fnd_message.set_token('AUCTION_TITLE', l_auction_title);
1006: l_eval_update_sub := fnd_message.get;
1007:
1008: l_neg_summary_url := pon_wf_utl_pkg.get_dest_page_url
1009: ( p_dest_func => 'PON_NEG_SUMMARY',
1010: p_notif_performer => 'BUYER'

Line 1176: fnd_message.set_name('PON', 'PON_SM_EVAL_UPDATE_SCORER_HB');

1172: pon_profile_util_pkg.get_wf_language(l_scorer_user_name, l_language_code);
1173: pon_auction_pkg.set_session_language(NULL, l_language_code);
1174:
1175: IF (p_display_type = 'text/html') THEN
1176: fnd_message.set_name('PON', 'PON_SM_EVAL_UPDATE_SCORER_HB');
1177: ELSE
1178: fnd_message.set_name('PON', 'PON_SM_EVAL_UPDATE_SCORER_TB');
1179: END IF;
1180:

Line 1178: fnd_message.set_name('PON', 'PON_SM_EVAL_UPDATE_SCORER_TB');

1174:
1175: IF (p_display_type = 'text/html') THEN
1176: fnd_message.set_name('PON', 'PON_SM_EVAL_UPDATE_SCORER_HB');
1177: ELSE
1178: fnd_message.set_name('PON', 'PON_SM_EVAL_UPDATE_SCORER_TB');
1179: END IF;
1180:
1181: fnd_message.set_token('TEAM_MEMBER', l_team_member);
1182: fnd_message.set_token('DOC_TYPE', l_doc_type);

Line 1181: fnd_message.set_token('TEAM_MEMBER', l_team_member);

1177: ELSE
1178: fnd_message.set_name('PON', 'PON_SM_EVAL_UPDATE_SCORER_TB');
1179: END IF;
1180:
1181: fnd_message.set_token('TEAM_MEMBER', l_team_member);
1182: fnd_message.set_token('DOC_TYPE', l_doc_type);
1183: fnd_message.set_token('DOC_NUMBER', l_doc_number);
1184: fnd_message.set_token('AUCTION_TITLE', l_auction_title);
1185: fnd_message.set_token('NEG_SUMMARY_URL', l_neg_summary_url);

Line 1182: fnd_message.set_token('DOC_TYPE', l_doc_type);

1178: fnd_message.set_name('PON', 'PON_SM_EVAL_UPDATE_SCORER_TB');
1179: END IF;
1180:
1181: fnd_message.set_token('TEAM_MEMBER', l_team_member);
1182: fnd_message.set_token('DOC_TYPE', l_doc_type);
1183: fnd_message.set_token('DOC_NUMBER', l_doc_number);
1184: fnd_message.set_token('AUCTION_TITLE', l_auction_title);
1185: fnd_message.set_token('NEG_SUMMARY_URL', l_neg_summary_url);
1186: l_document := fnd_message.get;

Line 1183: fnd_message.set_token('DOC_NUMBER', l_doc_number);

1179: END IF;
1180:
1181: fnd_message.set_token('TEAM_MEMBER', l_team_member);
1182: fnd_message.set_token('DOC_TYPE', l_doc_type);
1183: fnd_message.set_token('DOC_NUMBER', l_doc_number);
1184: fnd_message.set_token('AUCTION_TITLE', l_auction_title);
1185: fnd_message.set_token('NEG_SUMMARY_URL', l_neg_summary_url);
1186: l_document := fnd_message.get;
1187:

Line 1184: fnd_message.set_token('AUCTION_TITLE', l_auction_title);

1180:
1181: fnd_message.set_token('TEAM_MEMBER', l_team_member);
1182: fnd_message.set_token('DOC_TYPE', l_doc_type);
1183: fnd_message.set_token('DOC_NUMBER', l_doc_number);
1184: fnd_message.set_token('AUCTION_TITLE', l_auction_title);
1185: fnd_message.set_token('NEG_SUMMARY_URL', l_neg_summary_url);
1186: l_document := fnd_message.get;
1187:
1188: wf_notification.WriteToClob(x_document, l_document);

Line 1185: fnd_message.set_token('NEG_SUMMARY_URL', l_neg_summary_url);

1181: fnd_message.set_token('TEAM_MEMBER', l_team_member);
1182: fnd_message.set_token('DOC_TYPE', l_doc_type);
1183: fnd_message.set_token('DOC_NUMBER', l_doc_number);
1184: fnd_message.set_token('AUCTION_TITLE', l_auction_title);
1185: fnd_message.set_token('NEG_SUMMARY_URL', l_neg_summary_url);
1186: l_document := fnd_message.get;
1187:
1188: wf_notification.WriteToClob(x_document, l_document);
1189:

Line 1186: l_document := fnd_message.get;

1182: fnd_message.set_token('DOC_TYPE', l_doc_type);
1183: fnd_message.set_token('DOC_NUMBER', l_doc_number);
1184: fnd_message.set_token('AUCTION_TITLE', l_auction_title);
1185: fnd_message.set_token('NEG_SUMMARY_URL', l_neg_summary_url);
1186: l_document := fnd_message.get;
1187:
1188: wf_notification.WriteToClob(x_document, l_document);
1189:
1190: pon_auction_pkg.unset_session_language;