eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PON_AUCTION_PKG dependencies on PON_PROFILE_UTIL_PKG

Line 561: PON_PROFILE_UTIL_PKG.GET_WF_LANGUAGE(x_user_name,x_language_code);

557: x_newpreviewtime := x_preview_date;
558: x_timezone := x_oex_timezone;
559: END IF;
560:
561: PON_PROFILE_UTIL_PKG.GET_WF_LANGUAGE(x_user_name,x_language_code);
562: ELSE -- auction_contact_id is null -- Bug 3824928: added this
563:
564: --
565: -- Get the auctioneer's time zone

Line 592: PON_PROFILE_UTIL_PKG.GET_WF_LANGUAGE(x_auctioneer_user_name,x_language_code);

588: x_newpreviewtime := x_preview_date;
589: x_timezone := x_oex_timezone;
590: END IF;
591: -- Get the auctioneer's language
592: PON_PROFILE_UTIL_PKG.GET_WF_LANGUAGE(x_auctioneer_user_name,x_language_code);
593:
594: -- add requested supplier info if specified
595: if (bidder.requested_supplier_contact_id is not null) then --{
596: wf_engine.SetItemAttrText (itemtype => x_itemtype,

Line 1006: PON_PROFILE_UTIL_PKG.GET_WF_LANGUAGE(p_trading_partner_contact_name,x_language_code);

1002: -- Get the auctioneer's language code so that the c1_auction_info
1003: -- has right value for x_language_code
1004: --
1005: IF p_trading_partner_contact_name is not null THEN
1006: PON_PROFILE_UTIL_PKG.GET_WF_LANGUAGE(p_trading_partner_contact_name,x_language_code);
1007: END IF;
1008:
1009: x_progress := '010';
1010:

Line 1658: PON_PROFILE_UTIL_PKG.GET_WF_LANGUAGE(p_bid_tp_contact_name,x_language_code);

1654: -- Get the bidder's language code so that the c1_bid_info
1655: -- has right value for x_language_code
1656: --
1657: IF p_bid_tp_contact_name is not null THEN
1658: PON_PROFILE_UTIL_PKG.GET_WF_LANGUAGE(p_bid_tp_contact_name,x_language_code);
1659: END IF;
1660:
1661: -- Set the userenv language so the message token (attribute) values that we retrieve using the
1662: -- getMessage call return the message in the correct language => x_language_code

Line 2218: PON_PROFILE_UTIL_PKG.GET_WF_LANGUAGE(p_bid_tp_contact_name,x_language_code);

2214: -- Get the bidder's language code so that the c1_bid_info
2215: -- has right value for x_language_code
2216: --
2217: IF p_bid_tp_contact_name is not null THEN
2218: PON_PROFILE_UTIL_PKG.GET_WF_LANGUAGE(p_bid_tp_contact_name,x_language_code);
2219: END IF;
2220:
2221: -- Set the userenv language so the message token (attribute) values that we retrieve using the
2222: -- getMessage call return the message in the correct language => x_language_code

Line 3420: PON_PROFILE_UTIL_PKG.GET_WF_LANGUAGE(x_bidder_username,x_language_code);

3416: avalue => x_bidder_username);
3417:
3418:
3419: IF x_bidder_username is not null THEN
3420: PON_PROFILE_UTIL_PKG.GET_WF_LANGUAGE(x_bidder_username,x_language_code);
3421: END IF;
3422:
3423: -- Bug 3824928 Added code below
3424: begin

Line 3817: PON_PROFILE_UTIL_PKG.GET_WF_PREFERENCES(x_auctioneer_user_name,x_language_code,x_territory_code);

3813: INTO x_auctioneer_user_name;
3814: CLOSE c_user_name;
3815:
3816: IF x_auctioneer_user_name is not null THEN
3817: PON_PROFILE_UTIL_PKG.GET_WF_PREFERENCES(x_auctioneer_user_name,x_language_code,x_territory_code);
3818: END IF;
3819:
3820: -- Bug 3824928: Store the auctioneer's language and territory in new
3821: -- variables so that they can be used later.

Line 3912: PON_PROFILE_UTIL_PKG.GET_WF_PREFERENCES(x_user_name ,x_language_code,x_territory_code);

3908:
3909: -- Get NLS_LANGUAGE and NLS_TERRITORY for the user corresponding to additional contact
3910:
3911: IF x_user_name is not null THEN
3912: PON_PROFILE_UTIL_PKG.GET_WF_PREFERENCES(x_user_name ,x_language_code,x_territory_code);
3913: END IF;
3914:
3915: x_progress := '021';
3916:

Line 5284: /* In the PON_PROFILE_UTIL_PKG there is a three var input fn.*/

5280: MSG varchar2(2000) := NULL;
5281: MSGDATA varchar2(2000) := NULL;
5282:
5283: BEGIN
5284: /* In the PON_PROFILE_UTIL_PKG there is a three var input fn.*/
5285: MSG := PON_PROFILE_UTIL_PKG.get_string(appin,namein,langin);
5286: FOR i in 1 .. MsgTokens.COUNT LOOP
5287: MSGDATA := MSGDATA||'N'||chr(0)||MsgTokens(i)||chr(0)||MsgTokenValues(i)||chr(0);
5288: END LOOP;

Line 5285: MSG := PON_PROFILE_UTIL_PKG.get_string(appin,namein,langin);

5281: MSGDATA varchar2(2000) := NULL;
5282:
5283: BEGIN
5284: /* In the PON_PROFILE_UTIL_PKG there is a three var input fn.*/
5285: MSG := PON_PROFILE_UTIL_PKG.get_string(appin,namein,langin);
5286: FOR i in 1 .. MsgTokens.COUNT LOOP
5287: MSGDATA := MSGDATA||'N'||chr(0)||MsgTokens(i)||chr(0)||MsgTokenValues(i)||chr(0);
5288: END LOOP;
5289: return sub_token(MSG, MSGDATA);

Line 5353: PON_PROFILE_UTIL_PKG.GET_WF_LANGUAGE(x_user_name,x_language_code);

5349: and rownum=1;
5350:
5351: END;
5352: IF x_user_name is not null THEN
5353: PON_PROFILE_UTIL_PKG.GET_WF_LANGUAGE(x_user_name,x_language_code);
5354: END IF;
5355:
5356:
5357: --

Line 5466: PON_PROFILE_UTIL_PKG.GET_WF_LANGUAGE(x_user_name,x_language_code);

5462: and rownum=1;
5463:
5464: END;
5465: IF x_user_name is not null THEN
5466: PON_PROFILE_UTIL_PKG.GET_WF_LANGUAGE(x_user_name,x_language_code);
5467: END IF;
5468:
5469: --
5470: -- First, see what activity (if any) the workflow is on

Line 5559: --message := PON_PROFILE_UTIL_PKG.GET_STRING(PON_AUCTION_PKG.OperationId, 'PON', msg, PON_AUCTION_PKG.SessionLanguage);

5555: BEGIN
5556: BEGIN
5557:
5558: -- In ERP only three arguements.
5559: --message := PON_PROFILE_UTIL_PKG.GET_STRING(PON_AUCTION_PKG.OperationId, 'PON', msg, PON_AUCTION_PKG.SessionLanguage);
5560: message := PON_PROFILE_UTIL_PKG.GET_STRING('PON', msg, PON_AUCTION_PKG.SessionLanguage);
5561:
5562: if (message is null) then
5563: message := fnd_message.get_string('PON', msg);

Line 5560: message := PON_PROFILE_UTIL_PKG.GET_STRING('PON', msg, PON_AUCTION_PKG.SessionLanguage);

5556: BEGIN
5557:
5558: -- In ERP only three arguements.
5559: --message := PON_PROFILE_UTIL_PKG.GET_STRING(PON_AUCTION_PKG.OperationId, 'PON', msg, PON_AUCTION_PKG.SessionLanguage);
5560: message := PON_PROFILE_UTIL_PKG.GET_STRING('PON', msg, PON_AUCTION_PKG.SessionLanguage);
5561:
5562: if (message is null) then
5563: message := fnd_message.get_string('PON', msg);
5564: end if;

Line 6168: PON_PROFILE_UTIL_PKG.GET_WF_LANGUAGE(bidder.user_name,x_language_code);

6164: FOR bidder IN bidders LOOP
6165:
6166: if (member_user(bidder.user_name)) then
6167:
6168: PON_PROFILE_UTIL_PKG.GET_WF_LANGUAGE(bidder.user_name,x_language_code);
6169: x_trading_partner_contact_id := bidder.person_party_id;
6170:
6171: -- Get the timezone for the user
6172: x_timezone := Get_Time_Zone(bidder.person_party_id);

Line 6209: PON_PROFILE_UTIL_PKG.GET_WF_LANGUAGE(x_profile_user,x_language_code);

6205: elsif (additional_bidder(bidder.user_name, x_doc_number, x_tp_contact_name, x_profile_user)) then
6206: -- Bug 3824928: logic here will handle additional contact users
6207: -- associated to a trading partner contact id or not.
6208:
6209: PON_PROFILE_UTIL_PKG.GET_WF_LANGUAGE(x_profile_user,x_language_code);
6210:
6211: select trading_partner_name, decode(vendor_site_code, '-1', null, vendor_site_code) vendor_site_code, nvl(vendor_site_id, -1) vendor_site_id
6212: into x_bidder_tp_name, x_vendor_site_code, x_vendor_site_id
6213: from pon_bidding_parties

Line 6695: PON_PROFILE_UTIL_PKG.GET_WF_PREFERENCES(x_auctioneer_user_name,x_language_code,x_territory_code);

6691:
6692: x_msg_suffix := GET_MESSAGE_SUFFIX (x_doctype_group_name);
6693:
6694: IF x_auctioneer_user_name is not null THEN
6695: PON_PROFILE_UTIL_PKG.GET_WF_PREFERENCES(x_auctioneer_user_name,x_language_code,x_territory_code);
6696: END IF;
6697:
6698: select NLS_LANGUAGE into x_nls_language
6699: from fnd_languages

Line 6724: PON_PROFILE_UTIL_PKG.GET_WF_PREFERENCES(x_auctioneer_user_name,x_language_code,x_territory_code);

6720:
6721: x_oex_timezone := Get_Oex_Time_Zone;
6722:
6723: -- Get the auctioneer's language
6724: PON_PROFILE_UTIL_PKG.GET_WF_PREFERENCES(x_auctioneer_user_name,x_language_code,x_territory_code);
6725: for bidder in newInvitees loop
6726:
6727: -- Bug 3824928: Removed unnecessary statements from this version
6728:

Line 6759: PON_PROFILE_UTIL_PKG.GET_WF_PREFERENCES(x_user_name,x_language_code,x_territory_code);

6755: -- Set bidder specific attributes
6756:
6757: -- Bug 3824928: calling get_wf_preferences instead of get_wf_language
6758:
6759: PON_PROFILE_UTIL_PKG.GET_WF_PREFERENCES(x_user_name,x_language_code,x_territory_code);
6760:
6761: --
6762: -- Get the user's time zone
6763: --

Line 8487: PON_PROFILE_UTIL_PKG.GET_WF_LANGUAGE(bidder.my_user_name,x_language_code);

8483: x_member_flag :='Y';
8484: x_process_name :='REMIND_MEMBERS_PROCESS';
8485: -- Bug 3824928: Trading partner contact id can be null
8486: IF bidder.trading_partner_contact_id is not null then -- {
8487: PON_PROFILE_UTIL_PKG.GET_WF_LANGUAGE(bidder.my_user_name,x_language_code);
8488:
8489:
8490: BEGIN
8491: SELECT person_party_id

Line 8534: PON_PROFILE_UTIL_PKG.GET_WF_LANGUAGE(x_auctioneer_user_name,x_language_code);

8530: -- itemkey => x_wf_item_key,
8531: -- aname => 'PREPARER_TP_CONTACT_NAME');
8532: x_auctioneer_user_name := x_auction_tp_contact_name;
8533:
8534: PON_PROFILE_UTIL_PKG.GET_WF_LANGUAGE(x_auctioneer_user_name,x_language_code);
8535:
8536: -- get auctioneer's timezone
8537: x_timezone := Get_Time_Zone(x_auctioneer_user_name);
8538:

Line 9530: PON_PROFILE_UTIL_PKG.RETRIEVE_PARTY_PREF_COVER(

9526: x_price_break_response := 'NONE';
9527: else
9528:
9529: BEGIN
9530: PON_PROFILE_UTIL_PKG.RETRIEVE_PARTY_PREF_COVER(
9531: p_party_id => p_tp_id,
9532: p_app_short_name => 'PON',
9533: p_pref_name => 'PRICE_BREAK_RESPONSE_TYPE',
9534: x_pref_value => x_price_break_response,

Line 9937: PON_PROFILE_UTIL_PKG.GET_WF_LANGUAGE (p_user_id, l_lang_code);

9933: -- Get the recipient user's language preference
9934: -- And set the session language so messages are
9935: -- retrieved in that language.
9936: IF p_user_id IS NOT NULL THEN
9937: PON_PROFILE_UTIL_PKG.GET_WF_LANGUAGE (p_user_id, l_lang_code);
9938:
9939: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
9940: FND_LOG.string(log_level => FND_LOG.level_statement,
9941: module => g_module_prefix || 'SEND_TASK_ASSIGN_NOTIF',

Line 10335: PON_PROFILE_UTIL_PKG.GET_WF_LANGUAGE (l_tp_contact_usr_id, l_lang_code);

10331: -- Get the recipient user's language preference
10332: -- And set the session language so messages are
10333: -- retrieved in that language.
10334: IF l_tp_contact_usr_id IS NOT NULL THEN
10335: PON_PROFILE_UTIL_PKG.GET_WF_LANGUAGE (l_tp_contact_usr_id, l_lang_code);
10336:
10337: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
10338: FND_LOG.string(log_level => FND_LOG.level_statement,
10339: module => g_module_prefix || 'SEND_TASK_COMPL_NOTIF',

Line 10699: PON_PROFILE_UTIL_PKG.GET_WF_LANGUAGE(l_auctioneer_user_name,l_lang_code);

10695: END IF;
10696:
10697: l_progress := '020';
10698:
10699: PON_PROFILE_UTIL_PKG.GET_WF_LANGUAGE(l_auctioneer_user_name,l_lang_code);
10700:
10701: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
10702: FND_LOG.string(log_level => FND_LOG.level_statement,
10703: module => g_module_prefix ||l_module_name,

Line 11869: PON_PROFILE_UTIL_PKG.GET_WF_PREFERENCES(l_user_name ,x_language_code,x_territory_code);

11865: --
11866: -- Subject should be retrieved from seed message
11867: --
11868: IF l_user_name is not null THEN
11869: PON_PROFILE_UTIL_PKG.GET_WF_PREFERENCES(l_user_name ,x_language_code,x_territory_code);
11870: END IF;
11871:
11872: IF (x_language_code is not null) THEN
11873: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{