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 584: PON_PROFILE_UTIL_PKG.GET_WF_LANGUAGE(x_user_name,x_language_code);

580: x_newpreviewtime := x_preview_date;
581: x_timezone := x_oex_timezone;
582: END IF;
583:
584: PON_PROFILE_UTIL_PKG.GET_WF_LANGUAGE(x_user_name,x_language_code);
585: ELSE -- auction_contact_id is null -- Bug 3824928: added this
586:
587: --
588: -- Get the auctioneer's time zone

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

611: x_newpreviewtime := x_preview_date;
612: x_timezone := x_oex_timezone;
613: END IF;
614: -- Get the auctioneer's language
615: PON_PROFILE_UTIL_PKG.GET_WF_LANGUAGE(x_auctioneer_user_name,x_language_code);
616:
617: -- add requested supplier info if specified
618: if (bidder.requested_supplier_contact_id is not null) then --{
619: wf_engine.SetItemAttrText (itemtype => x_itemtype,

Line 1140: PON_PROFILE_UTIL_PKG.GET_WF_LANGUAGE(p_emd_admin_name,x_language_code);

1136: -- Get the bidder's language code so that the c1_bid_info
1137: -- has right value for x_language_code
1138: --
1139: IF p_emd_admin_name is not null THEN
1140: PON_PROFILE_UTIL_PKG.GET_WF_LANGUAGE(p_emd_admin_name,x_language_code);
1141: END IF;
1142:
1143: -- Set the userenv language so the message token (attribute) values that we retrieve using the
1144: -- getMessage call return the message in the correct language => x_language_code

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

1447: -- Get the auctioneer's language code so that the c1_auction_info
1448: -- has right value for x_language_code
1449: --
1450: IF p_trading_partner_contact_name is not null THEN
1451: PON_PROFILE_UTIL_PKG.GET_WF_LANGUAGE(p_trading_partner_contact_name,x_language_code);
1452: END IF;
1453:
1454: x_progress := '010';
1455:

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

2116: -- Get the bidder's language code so that the c1_bid_info
2117: -- has right value for x_language_code
2118: --
2119: IF p_bid_tp_contact_name is not null THEN
2120: PON_PROFILE_UTIL_PKG.GET_WF_LANGUAGE(p_bid_tp_contact_name,x_language_code);
2121: END IF;
2122:
2123: -- Set the userenv language so the message token (attribute) values that we retrieve using the
2124: -- getMessage call return the message in the correct language => x_language_code

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

2694: -- Get the bidder's language code so that the c1_bid_info
2695: -- has right value for x_language_code
2696: --
2697: IF p_bid_tp_contact_name is not null THEN
2698: PON_PROFILE_UTIL_PKG.GET_WF_LANGUAGE(p_bid_tp_contact_name,x_language_code);
2699: END IF;
2700:
2701: -- Set the userenv language so the message token (attribute) values that we retrieve using the
2702: -- getMessage call return the message in the correct language => x_language_code

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

3937: avalue => x_bidder_username);
3938:
3939:
3940: IF x_bidder_username is not null THEN
3941: PON_PROFILE_UTIL_PKG.GET_WF_LANGUAGE(x_bidder_username,x_language_code);
3942: END IF;
3943:
3944: -- Bug 3824928 Added code below
3945: begin

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

4379: INTO x_auctioneer_user_name;
4380: CLOSE c_user_name;
4381:
4382: IF x_auctioneer_user_name is not null THEN
4383: PON_PROFILE_UTIL_PKG.GET_WF_PREFERENCES(x_auctioneer_user_name,x_language_code,x_territory_code);
4384: END IF;
4385:
4386: -- Bug 3824928: Store the auctioneer's language and territory in new
4387: -- variables so that they can be used later.

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

4481:
4482: -- Get NLS_LANGUAGE and NLS_TERRITORY for the user corresponding to additional contact
4483:
4484: IF x_user_name is not null THEN
4485: PON_PROFILE_UTIL_PKG.GET_WF_PREFERENCES(x_user_name ,x_language_code,x_territory_code);
4486: END IF;
4487:
4488: x_progress := '021';
4489:

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

5876: MSG varchar2(2000) := NULL;
5877: MSGDATA varchar2(2000) := NULL;
5878:
5879: BEGIN
5880: /* In the PON_PROFILE_UTIL_PKG there is a three var input fn.*/
5881: MSG := PON_PROFILE_UTIL_PKG.get_string(appin,namein,langin);
5882: FOR i in 1 .. MsgTokens.COUNT LOOP
5883: MSGDATA := MSGDATA||'N'||chr(0)||MsgTokens(i)||chr(0)||MsgTokenValues(i)||chr(0);
5884: END LOOP;

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

5877: MSGDATA varchar2(2000) := NULL;
5878:
5879: BEGIN
5880: /* In the PON_PROFILE_UTIL_PKG there is a three var input fn.*/
5881: MSG := PON_PROFILE_UTIL_PKG.get_string(appin,namein,langin);
5882: FOR i in 1 .. MsgTokens.COUNT LOOP
5883: MSGDATA := MSGDATA||'N'||chr(0)||MsgTokens(i)||chr(0)||MsgTokenValues(i)||chr(0);
5884: END LOOP;
5885: return sub_token(MSG, MSGDATA);

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

5945: and rownum=1;
5946:
5947: END;
5948: IF x_user_name is not null THEN
5949: PON_PROFILE_UTIL_PKG.GET_WF_LANGUAGE(x_user_name,x_language_code);
5950: END IF;
5951:
5952:
5953: --

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

6058: and rownum=1;
6059:
6060: END;
6061: IF x_user_name is not null THEN
6062: PON_PROFILE_UTIL_PKG.GET_WF_LANGUAGE(x_user_name,x_language_code);
6063: END IF;
6064:
6065: --
6066: -- First, see what activity (if any) the workflow is on

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

6151: BEGIN
6152: BEGIN
6153:
6154: -- In ERP only three arguements.
6155: --message := PON_PROFILE_UTIL_PKG.GET_STRING(PON_AUCTION_PKG.OperationId, 'PON', msg, PON_AUCTION_PKG.SessionLanguage);
6156: message := PON_PROFILE_UTIL_PKG.GET_STRING('PON', msg, PON_AUCTION_PKG.SessionLanguage);
6157:
6158: if (message is null) then
6159: message := fnd_message.get_string('PON', msg);

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

6152: BEGIN
6153:
6154: -- In ERP only three arguements.
6155: --message := PON_PROFILE_UTIL_PKG.GET_STRING(PON_AUCTION_PKG.OperationId, 'PON', msg, PON_AUCTION_PKG.SessionLanguage);
6156: message := PON_PROFILE_UTIL_PKG.GET_STRING('PON', msg, PON_AUCTION_PKG.SessionLanguage);
6157:
6158: if (message is null) then
6159: message := fnd_message.get_string('PON', msg);
6160: end if;

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

6760: FOR bidder IN bidders LOOP
6761:
6762: if (member_user(bidder.user_name)) then
6763:
6764: PON_PROFILE_UTIL_PKG.GET_WF_LANGUAGE(bidder.user_name,x_language_code);
6765: x_trading_partner_contact_id := bidder.person_party_id;
6766:
6767: -- Get the timezone for the user
6768: x_timezone := Get_Time_Zone(bidder.person_party_id);

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

6801: elsif (additional_bidder(bidder.user_name, x_doc_number, x_tp_contact_name, x_profile_user)) then
6802: -- Bug 3824928: logic here will handle additional contact users
6803: -- associated to a trading partner contact id or not.
6804:
6805: PON_PROFILE_UTIL_PKG.GET_WF_LANGUAGE(x_profile_user,x_language_code);
6806:
6807: select trading_partner_name, decode(vendor_site_code, '-1', null, vendor_site_code) vendor_site_code, nvl(vendor_site_id, -1) vendor_site_id
6808: into x_bidder_tp_name, x_vendor_site_code, x_vendor_site_id
6809: from pon_bidding_parties

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

7300:
7301: x_msg_suffix := GET_MESSAGE_SUFFIX (x_doctype_group_name);
7302:
7303: IF x_auctioneer_user_name is not null THEN
7304: PON_PROFILE_UTIL_PKG.GET_WF_PREFERENCES(x_auctioneer_user_name,x_language_code,x_territory_code);
7305: END IF;
7306:
7307: select NLS_LANGUAGE into x_nls_language
7308: from fnd_languages

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

7329:
7330: x_oex_timezone := Get_Oex_Time_Zone;
7331:
7332: -- Get the auctioneer's language
7333: PON_PROFILE_UTIL_PKG.GET_WF_PREFERENCES(x_auctioneer_user_name,x_language_code,x_territory_code);
7334: for bidder in newInvitees loop
7335:
7336: -- Bug 3824928: Removed unnecessary statements from this version
7337:

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

7370: -- Set bidder specific attributes
7371:
7372: -- Bug 3824928: calling get_wf_preferences instead of get_wf_language
7373:
7374: PON_PROFILE_UTIL_PKG.GET_WF_PREFERENCES(x_user_name,x_language_code,x_territory_code);
7375:
7376: --
7377: -- Get the user's time zone
7378: --

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

9195: x_member_flag :='Y';
9196: x_process_name :='REMIND_MEMBERS_PROCESS';
9197: -- Bug 3824928: Trading partner contact id can be null
9198: IF bidder.trading_partner_contact_id is not null then -- {
9199: PON_PROFILE_UTIL_PKG.GET_WF_LANGUAGE(bidder.my_user_name,x_language_code);
9200:
9201:
9202: BEGIN
9203: SELECT person_party_id

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

9242: -- itemkey => x_wf_item_key,
9243: -- aname => 'PREPARER_TP_CONTACT_NAME');
9244: x_auctioneer_user_name := x_auction_tp_contact_name;
9245:
9246: PON_PROFILE_UTIL_PKG.GET_WF_LANGUAGE(x_auctioneer_user_name,x_language_code);
9247:
9248: -- get auctioneer's timezone
9249: x_timezone := Get_Time_Zone(x_auctioneer_user_name);
9250:

Line 10366: PON_PROFILE_UTIL_PKG.RETRIEVE_PARTY_PREF_COVER(

10362: x_price_break_response := 'NONE';
10363: else
10364:
10365: BEGIN
10366: PON_PROFILE_UTIL_PKG.RETRIEVE_PARTY_PREF_COVER(
10367: p_party_id => p_tp_id,
10368: p_app_short_name => 'PON',
10369: p_pref_name => 'PRICE_BREAK_RESPONSE_TYPE',
10370: x_pref_value => x_price_break_response,

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

10769: -- Get the recipient user's language preference
10770: -- And set the session language so messages are
10771: -- retrieved in that language.
10772: IF p_user_id IS NOT NULL THEN
10773: PON_PROFILE_UTIL_PKG.GET_WF_LANGUAGE (p_user_id, l_lang_code);
10774:
10775: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
10776: FND_LOG.string(log_level => FND_LOG.level_statement,
10777: module => g_module_prefix || 'SEND_TASK_ASSIGN_NOTIF',

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

11167: -- Get the recipient user's language preference
11168: -- And set the session language so messages are
11169: -- retrieved in that language.
11170: IF l_tp_contact_usr_id IS NOT NULL THEN
11171: PON_PROFILE_UTIL_PKG.GET_WF_LANGUAGE (l_tp_contact_usr_id, l_lang_code);
11172:
11173: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
11174: FND_LOG.string(log_level => FND_LOG.level_statement,
11175: module => g_module_prefix || 'SEND_TASK_COMPL_NOTIF',

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

11531: END IF;
11532:
11533: l_progress := '020';
11534:
11535: PON_PROFILE_UTIL_PKG.GET_WF_LANGUAGE(l_auctioneer_user_name,l_lang_code);
11536:
11537: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
11538: FND_LOG.string(log_level => FND_LOG.level_statement,
11539: module => g_module_prefix ||l_module_name,

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

12720: --
12721: -- Subject should be retrieved from seed message
12722: --
12723: IF l_user_name is not null THEN
12724: PON_PROFILE_UTIL_PKG.GET_WF_PREFERENCES(l_user_name ,x_language_code,x_territory_code);
12725: END IF;
12726:
12727: IF (x_language_code is not null) THEN
12728: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{