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