DBA Data[Home] [Help]

APPS.PON_EVAL_TEAM_UTIL_PVT dependencies on PON_AUCTION_PKG

Line 423: pon_auction_pkg.set_session_language(NULL, l_language_code);

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

Line 431: l_doc_type := pon_auction_pkg.getMessage('PON_AUCTION', '_' || l_msg_suffix);

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

Line 529: pon_auction_pkg.unset_session_language;

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:

Line 825: pon_auction_pkg.set_session_language(NULL, l_language_code);

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

Line 894: pon_auction_pkg.unset_session_language;

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:

Line 997: pon_auction_pkg.set_session_language(NULL, l_language_code);

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:

Line 1000: l_doc_type := pon_auction_pkg.getMessage('PON_AUCTION', '_'||l_msg_suffix);

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

Line 1092: pon_auction_pkg.unset_session_language;

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;

Line 1173: pon_auction_pkg.set_session_language(NULL, l_language_code);

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

Line 1190: pon_auction_pkg.unset_session_language;

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: