[Home] [Help]
419:
420: BEGIN
421:
422: pon_profile_util_pkg.get_wf_language(p_member_user_id, l_language_code);
423: pon_auction_pkg.set_session_language(NULL, l_language_code);
424:
425:
426: OPEN c_auction_details;
427: FETCH c_auction_details
427: FETCH c_auction_details
428: INTO l_doc_number, l_auction_title, l_preparer_tp_name, l_msg_suffix;
429: CLOSE c_auction_details;
430:
431: l_doc_type := pon_auction_pkg.getMessage('PON_AUCTION', '_' || l_msg_suffix);
432:
433: SELECT user_name
434: INTO l_member_user_name
435: FROM fnd_user
525: wf_engine.StartProcess(itemtype => l_itemtype,
526: itemkey => l_itemkey);
527:
528:
529: pon_auction_pkg.unset_session_language;
530:
531: END send_eval_team_update_notif;
532:
533:
821:
822: -- 3. Construct the message body based on the above 2 lists
823:
824: pon_profile_util_pkg.get_wf_language(l_member_user_id, l_language_code);
825: pon_auction_pkg.set_session_language(NULL, l_language_code);
826:
827: FOR i IN 1..l_team_members_tbl.COUNT LOOP
828:
829: l_team_members_rec := l_team_members_tbl(i);
890: END LOOP;
891:
892: wf_notification.WriteToClob(x_document, l_document);
893:
894: pon_auction_pkg.unset_session_language;
895:
896: END gen_eval_team_update_body;
897:
898:
993: FOR i IN 1..l_notify_tbl.COUNT LOOP
994:
995: pon_profile_util_pkg.get_wf_language(l_notify_tbl(i).scorer_user_name,
996: l_language_code);
997: pon_auction_pkg.set_session_language(NULL, l_language_code);
998:
999:
1000: l_doc_type := pon_auction_pkg.getMessage('PON_AUCTION', '_'||l_msg_suffix);
1001:
996: l_language_code);
997: pon_auction_pkg.set_session_language(NULL, l_language_code);
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);
1088: wf_engine.StartProcess(itemtype => l_itemtype,
1089: itemkey => l_itemkey);
1090:
1091:
1092: pon_auction_pkg.unset_session_language;
1093:
1094: END LOOP;
1095:
1096: END send_eval_update_scorer_notif;
1169: END IF;
1170:
1171:
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
1186: l_document := fnd_message.get;
1187:
1188: wf_notification.WriteToClob(x_document, l_document);
1189:
1190: pon_auction_pkg.unset_session_language;
1191:
1192: END gen_eval_update_scorer_body;
1193:
1194: