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_APPROVAL_PKG dependencies on PON_AUCTION_PKG

Line 515: PON_AUCTION_PKG.SET_SESSION_LANGUAGE(null,l_language_code);

511: module => g_module_prefix || 'SUBMIT_FOR_APPROVAL',
512: message => '1. Calling SET_SESSION_LANGUAGE with l_language_code : ' || l_language_code);
513: END IF; --}
514:
515: PON_AUCTION_PKG.SET_SESSION_LANGUAGE(null,l_language_code);
516:
517: select to_char(PON_AUCTION_WF_APPROVALS_S.NEXTVAL)
518: into l_seq from sys.dual;
519:

Line 636: l_msg_suffix := PON_AUCTION_PKG.GET_MESSAGE_SUFFIX (l_doctype_group_name);

632: aname => 'IS_FEDERAL',
633: avalue => l_is_federal);
634: -- End of Federal Code changes
635:
636: l_msg_suffix := PON_AUCTION_PKG.GET_MESSAGE_SUFFIX (l_doctype_group_name);
637:
638: wf_engine.SetItemAttrText (itemtype => l_itemType,
639: itemkey => l_itemKey,
640: aname => 'MSG_SUFFIX',

Line 643: l_timezone := PON_AUCTION_PKG.Get_Time_Zone(l_auction_contact_id);

639: itemkey => l_itemKey,
640: aname => 'MSG_SUFFIX',
641: avalue => l_msg_suffix);
642: -- Get the user's timezone
643: l_timezone := PON_AUCTION_PKG.Get_Time_Zone(l_auction_contact_id);
644:
645: l_oex_timezone := PON_AUCTION_PKG.Get_Oex_Time_Zone;
646:
647: if (l_timezone is null or l_timezone = '' ) then

Line 645: l_oex_timezone := PON_AUCTION_PKG.Get_Oex_Time_Zone;

641: avalue => l_msg_suffix);
642: -- Get the user's timezone
643: l_timezone := PON_AUCTION_PKG.Get_Time_Zone(l_auction_contact_id);
644:
645: l_oex_timezone := PON_AUCTION_PKG.Get_Oex_Time_Zone;
646:
647: if (l_timezone is null or l_timezone = '' ) then
648: l_timezone := l_oex_timezone;
649: end if;

Line 663: l_timezone_disp := PON_AUCTION_PKG.Get_TimeZone_Description(l_timezone, l_language_code);

659: l_preview_date_in_tz := l_preview_date;
660: l_timezone := l_oex_timezone;
661: END IF;
662:
663: l_timezone_disp := PON_AUCTION_PKG.Get_TimeZone_Description(l_timezone, l_language_code);
664:
665: wf_engine.SetItemAttrText (itemtype => l_itemType,
666: itemkey => l_itemKey,
667: aname => 'TIMEZONE',

Line 686: avalue => PON_AUCTION_PKG.getMessage('PON_AUC_PREVIEW_DATE_NOTSPEC',l_msg_suffix));

682:
683: wf_engine.SetItemAttrText (itemtype => l_itemtype,
684: itemkey => l_itemkey,
685: aname => 'PREVIEW_DATE_NOTSPECIFIED',
686: avalue => PON_AUCTION_PKG.getMessage('PON_AUC_PREVIEW_DATE_NOTSPEC',l_msg_suffix));
687: ELSE
688: l_timezone1_disp := l_timezone_disp;
689:
690: wf_engine.SetItemAttrDate (itemtype => l_itemtype,

Line 715: avalue => PON_AUCTION_PKG.getMessage('PON_AUC_OPEN_IMM_AFTER_PUB',l_msg_suffix));

711: if (l_open_auction_now_flag = 'Y') then
712: wf_engine.SetItemAttrText (itemtype => l_itemType,
713: itemkey => l_itemKey,
714: aname => 'OPEN_IMMEDIATELY',
715: avalue => PON_AUCTION_PKG.getMessage('PON_AUC_OPEN_IMM_AFTER_PUB',l_msg_suffix));
716:
717: wf_engine.SetItemAttrText (itemtype => l_itemType,
718: itemkey => l_itemKey,
719: aname => 'O_TIMEZONE',

Line 813: PON_AUCTION_PKG.UNSET_SESSION_LANGUAGE;

809: approval_status = 'INPROCESS'
810: WHERE auction_header_id = p_auction_header_id;
811:
812: --bug 7602688
813: PON_AUCTION_PKG.UNSET_SESSION_LANGUAGE;
814:
815: end SUBMIT_FOR_APPROVAL;
816:
817: PROCEDURE StartUserApprovalProcess(itemtype in varchar2,

Line 1019: -- PON_AUCTION_PKG.SET_SESSION_LANGUAGE(null,l_language_code);

1015: END IF; --}
1016:
1017: -- bug 7602688 session language for workflow is already set in submit_for_approval procedure.
1018: -- this process is called from 'sourcingapproval' workflow only. so no need to set again.
1019: -- PON_AUCTION_PKG.SET_SESSION_LANGUAGE(null,l_language_code);
1020:
1021: --Bug 6472383 : If the Negotiation Preview date is mentioned as 'Not Specified', i.e. if the value of
1022: -- l_preview_date_nspec is not null, we need to replace it with the string specific to recipient's language
1023: IF (l_preview_date_nspec is not null) THEN

Line 1024: l_preview_date_nspec := PON_AUCTION_PKG.getMessage('PON_AUC_PREVIEW_DATE_NOTSPEC',l_msg_suffix);

1020:
1021: --Bug 6472383 : If the Negotiation Preview date is mentioned as 'Not Specified', i.e. if the value of
1022: -- l_preview_date_nspec is not null, we need to replace it with the string specific to recipient's language
1023: IF (l_preview_date_nspec is not null) THEN
1024: l_preview_date_nspec := PON_AUCTION_PKG.getMessage('PON_AUC_PREVIEW_DATE_NOTSPEC',l_msg_suffix);
1025: END IF;
1026:
1027: l_itemKey := itemkey || '_' || r1.user_id;
1028:

Line 1178: l_timezone := PON_AUCTION_PKG.Get_Time_Zone(r1.user_name);

1174: itemkey => l_itemKey,
1175: aname => 'ORIGIN_USER_NAME',
1176: avalue => fnd_global.user_name);
1177:
1178: l_timezone := PON_AUCTION_PKG.Get_Time_Zone(r1.user_name);
1179:
1180: l_oex_timezone := PON_AUCTION_PKG.Get_Oex_Time_Zone;
1181:
1182: if (l_timezone is null) then

Line 1180: l_oex_timezone := PON_AUCTION_PKG.Get_Oex_Time_Zone;

1176: avalue => fnd_global.user_name);
1177:
1178: l_timezone := PON_AUCTION_PKG.Get_Time_Zone(r1.user_name);
1179:
1180: l_oex_timezone := PON_AUCTION_PKG.Get_Oex_Time_Zone;
1181:
1182: if (l_timezone is null) then
1183: l_timezone := l_oex_timezone;
1184: end if;

Line 1186: l_timezone_disp := PON_AUCTION_PKG.Get_TimeZone_Description(l_timezone, l_language_code);

1182: if (l_timezone is null) then
1183: l_timezone := l_oex_timezone;
1184: end if;
1185:
1186: l_timezone_disp := PON_AUCTION_PKG.Get_TimeZone_Description(l_timezone, l_language_code);
1187:
1188: wf_engine.SetItemAttrText (itemtype => l_itemType,
1189: itemkey => l_itemKey,
1190: aname => 'TIMEZONE',

Line 1204: avalue => PON_AUCTION_PKG.getMessage('PON_AUC_OPEN_IMM_AFTER_PUB',l_msg_suffix));

1200: if (r1.open_auction_now_flag = 'Y') then
1201: wf_engine.SetItemAttrText (itemtype => l_itemType,
1202: itemkey => l_itemKey,
1203: aname => 'OPEN_IMMEDIATELY',
1204: avalue => PON_AUCTION_PKG.getMessage('PON_AUC_OPEN_IMM_AFTER_PUB',l_msg_suffix));
1205:
1206: wf_engine.SetItemAttrText (itemtype => l_itemType,
1207: itemkey => l_itemKey,
1208: aname => 'O_TIMEZONE',

Line 1269: --PON_AUCTION_PKG.SET_SESSION_LANGUAGE(null,l_creator_session_lang_code);

1265: end loop;
1266:
1267: /* Reset to creator's language */
1268: -- bug 7602688
1269: --PON_AUCTION_PKG.SET_SESSION_LANGUAGE(null,l_creator_session_lang_code);
1270:
1271: end StartUserApprovalProcess;
1272:
1273:

Line 1674: l_oex_timezone := PON_AUCTION_PKG.Get_Oex_Time_Zone;

1670: and object_type_code = 'NEGOTIATION'
1671: and action_type = 'APPROVE';
1672:
1673: PON_PROFILE_UTIL_PKG.GET_WF_LANGUAGE(l_user_id,l_language_code);
1674: l_oex_timezone := PON_AUCTION_PKG.Get_Oex_Time_Zone;
1675:
1676: -- Get the user's time zone
1677: l_timezone := PON_AUCTION_PKG.Get_Time_Zone(l_auction_contact_id);
1678:

Line 1677: l_timezone := PON_AUCTION_PKG.Get_Time_Zone(l_auction_contact_id);

1673: PON_PROFILE_UTIL_PKG.GET_WF_LANGUAGE(l_user_id,l_language_code);
1674: l_oex_timezone := PON_AUCTION_PKG.Get_Oex_Time_Zone;
1675:
1676: -- Get the user's time zone
1677: l_timezone := PON_AUCTION_PKG.Get_Time_Zone(l_auction_contact_id);
1678:
1679: if (l_timezone is null or l_timezone = '') then
1680: l_timezone := l_oex_timezone;
1681: end if;

Line 1694: l_timezone_disp := PON_AUCTION_PKG.Get_TimeZone_Description(l_timezone, l_language_code);

1690: l_timezone := l_oex_timezone;
1691: END IF;
1692:
1693: -- Set the dates based on the user's time zone
1694: l_timezone_disp := PON_AUCTION_PKG.Get_TimeZone_Description(l_timezone, l_language_code);
1695:
1696: wf_engine.SetItemAttrDate (itemtype => itemType,
1697: itemkey => itemKey,
1698: aname => 'APPROVE_DATE',

Line 1799: l_oex_timezone := PON_AUCTION_PKG.Get_Oex_Time_Zone;

1795: and object_type_code = 'NEGOTIATION'
1796: and action_type = 'REJECT';
1797:
1798: PON_PROFILE_UTIL_PKG.GET_WF_LANGUAGE(l_user_id,l_language_code);
1799: l_oex_timezone := PON_AUCTION_PKG.Get_Oex_Time_Zone;
1800:
1801: -- Get the user's time zone
1802: l_timezone := PON_AUCTION_PKG.Get_Time_Zone(l_auction_contact_id);
1803:

Line 1802: l_timezone := PON_AUCTION_PKG.Get_Time_Zone(l_auction_contact_id);

1798: PON_PROFILE_UTIL_PKG.GET_WF_LANGUAGE(l_user_id,l_language_code);
1799: l_oex_timezone := PON_AUCTION_PKG.Get_Oex_Time_Zone;
1800:
1801: -- Get the user's time zone
1802: l_timezone := PON_AUCTION_PKG.Get_Time_Zone(l_auction_contact_id);
1803:
1804: if (l_timezone is null or l_timezone = '') then
1805: l_timezone := l_oex_timezone;
1806: end if;

Line 1819: l_timezone_disp := PON_AUCTION_PKG.Get_TimeZone_Description(l_timezone, l_language_code);

1815: l_timezone := l_oex_timezone;
1816: END IF;
1817:
1818: -- Set the dates based on the user's time zone
1819: l_timezone_disp := PON_AUCTION_PKG.Get_TimeZone_Description(l_timezone, l_language_code);
1820:
1821: wf_engine.SetItemAttrDate (itemtype => itemType,
1822: itemkey => itemKey,
1823: aname => 'REJECT_DATE',

Line 2039: avalue => PON_AUCTION_PKG.getMessage('PON_AMEND_APPR_REQ_SUBJECT',p_msg_suffix,'AMENDMENT_NUMBER', p_amendment_number, 'ORIG_NUMBER', p_orig_document_number, 'AUCTION_TITLE', p_auction_title));

2035: if (p_amendment_number is not null and p_amendment_number > 0) then
2036: wf_engine.SetItemAttrText (itemtype => p_itemType,
2037: itemkey => p_itemKey,
2038: aname => 'REQUEST_FOR_APPROVALS_SUBJECT',
2039: avalue => PON_AUCTION_PKG.getMessage('PON_AMEND_APPR_REQ_SUBJECT',p_msg_suffix,'AMENDMENT_NUMBER', p_amendment_number, 'ORIG_NUMBER', p_orig_document_number, 'AUCTION_TITLE', p_auction_title));
2040:
2041: wf_engine.SetItemAttrText (itemtype => p_itemType,
2042: itemkey => p_itemKey,
2043: aname => 'PON_AUC_APPR_REMINDER_SUB',

Line 2044: avalue => PON_AUCTION_PKG.getMessage('PON_AMEND_APPR_REMINDER_SUB',p_msg_suffix,'AMENDMENT_NUMBER', p_amendment_number, 'ORIG_NUMBER', p_orig_document_number));

2040:
2041: wf_engine.SetItemAttrText (itemtype => p_itemType,
2042: itemkey => p_itemKey,
2043: aname => 'PON_AUC_APPR_REMINDER_SUB',
2044: avalue => PON_AUCTION_PKG.getMessage('PON_AMEND_APPR_REMINDER_SUB',p_msg_suffix,'AMENDMENT_NUMBER', p_amendment_number, 'ORIG_NUMBER', p_orig_document_number));
2045:
2046: --added for eric test,begin
2047: wf_engine.SetItemAttrText (itemtype => p_itemType,
2048: itemkey => p_itemKey,

Line 2050: avalue => 'EMD '||PON_AUCTION_PKG.getMessage('PON_AMEND_APPR_REQ_SUBJECT',p_msg_suffix,'AMENDMENT_NUMBER', p_amendment_number, 'ORIG_NUMBER', p_orig_document_number, 'AUCTION_TITLE', p_auction_title));

2046: --added for eric test,begin
2047: wf_engine.SetItemAttrText (itemtype => p_itemType,
2048: itemkey => p_itemKey,
2049: aname => 'EMD_REQ_FOR_APPROVALS_SUBJECT',
2050: avalue => 'EMD '||PON_AUCTION_PKG.getMessage('PON_AMEND_APPR_REQ_SUBJECT',p_msg_suffix,'AMENDMENT_NUMBER', p_amendment_number, 'ORIG_NUMBER', p_orig_document_number, 'AUCTION_TITLE', p_auction_title));
2051:
2052: wf_engine.SetItemAttrText (itemtype => p_itemType,
2053: itemkey => p_itemKey,
2054: aname => 'EMD_PON_AUC_APPR_REMINDER_SUB',

Line 2055: avalue => 'EMD '||PON_AUCTION_PKG.getMessage('PON_AMEND_APPR_REMINDER_SUB',p_msg_suffix,'AMENDMENT_NUMBER', p_amendment_number, 'ORIG_NUMBER', p_orig_document_number));

2051:
2052: wf_engine.SetItemAttrText (itemtype => p_itemType,
2053: itemkey => p_itemKey,
2054: aname => 'EMD_PON_AUC_APPR_REMINDER_SUB',
2055: avalue => 'EMD '||PON_AUCTION_PKG.getMessage('PON_AMEND_APPR_REMINDER_SUB',p_msg_suffix,'AMENDMENT_NUMBER', p_amendment_number, 'ORIG_NUMBER', p_orig_document_number));
2056:
2057: --added for eric test,end
2058:
2059:

Line 2063: avalue => PON_AUCTION_PKG.getMessage('PON_AMEND_APPR_APPRD_SUBJECT',p_msg_suffix, 'AMENDMENT_NUMBER', p_amendment_number, 'ORIG_NUMBER',p_orig_document_number, 'AUCTION_TITLE', p_auction_title));

2059:
2060: wf_engine.SetItemAttrText (itemtype => p_itemType,
2061: itemkey => p_itemKey,
2062: aname => 'DOC_APPROVED_MAIL_SUBJECT',
2063: avalue => PON_AUCTION_PKG.getMessage('PON_AMEND_APPR_APPRD_SUBJECT',p_msg_suffix, 'AMENDMENT_NUMBER', p_amendment_number, 'ORIG_NUMBER',p_orig_document_number, 'AUCTION_TITLE', p_auction_title));
2064:
2065: wf_engine.SetItemAttrText (itemtype => p_itemType,
2066: itemkey => p_itemKey,
2067: aname => 'DOC_REJECTED_MAIL_SUBJECT',

Line 2068: avalue => PON_AUCTION_PKG.getMessage('PON_AMEND_APPR_REJ_SUBJECT', p_msg_suffix, 'AMENDMENT_NUMBER', p_amendment_number, 'ORIG_NUMBER',p_orig_document_number, 'AUCTION_TITLE', p_auction_title));

2064:
2065: wf_engine.SetItemAttrText (itemtype => p_itemType,
2066: itemkey => p_itemKey,
2067: aname => 'DOC_REJECTED_MAIL_SUBJECT',
2068: avalue => PON_AUCTION_PKG.getMessage('PON_AMEND_APPR_REJ_SUBJECT', p_msg_suffix, 'AMENDMENT_NUMBER', p_amendment_number, 'ORIG_NUMBER',p_orig_document_number, 'AUCTION_TITLE', p_auction_title));
2069:
2070: else
2071: wf_engine.SetItemAttrText (itemtype => p_itemType,
2072: itemkey => p_itemKey,

Line 2074: avalue => PON_AUCTION_PKG.getMessage('PON_AUC_APPR_REQ_SUBJECT',p_msg_suffix,'DOC_NUMBER', p_doc_number, 'AUCTION_TITLE', p_auction_title));

2070: else
2071: wf_engine.SetItemAttrText (itemtype => p_itemType,
2072: itemkey => p_itemKey,
2073: aname => 'REQUEST_FOR_APPROVALS_SUBJECT',
2074: avalue => PON_AUCTION_PKG.getMessage('PON_AUC_APPR_REQ_SUBJECT',p_msg_suffix,'DOC_NUMBER', p_doc_number, 'AUCTION_TITLE', p_auction_title));
2075:
2076:
2077: wf_engine.SetItemAttrText (itemtype => p_itemType,
2078: itemkey => p_itemKey,

Line 2080: avalue => PON_AUCTION_PKG.getMessage('PON_AUC_APPR_REMINDER_SUB',p_msg_suffix,'DOC_NUMBER', p_doc_number));

2076:
2077: wf_engine.SetItemAttrText (itemtype => p_itemType,
2078: itemkey => p_itemKey,
2079: aname => 'PON_AUC_APPR_REMINDER_SUB',
2080: avalue => PON_AUCTION_PKG.getMessage('PON_AUC_APPR_REMINDER_SUB',p_msg_suffix,'DOC_NUMBER', p_doc_number));
2081:
2082:
2083: --added for eric test,begin
2084: wf_engine.SetItemAttrText (itemtype => p_itemType,

Line 2087: avalue => 'EMD '||PON_AUCTION_PKG.getMessage('PON_AUC_APPR_REQ_SUBJECT',p_msg_suffix,'DOC_NUMBER', p_doc_number, 'AUCTION_TITLE', p_auction_title));

2083: --added for eric test,begin
2084: wf_engine.SetItemAttrText (itemtype => p_itemType,
2085: itemkey => p_itemKey,
2086: aname => 'EMD_REQ_FOR_APPROVALS_SUBJECT',
2087: avalue => 'EMD '||PON_AUCTION_PKG.getMessage('PON_AUC_APPR_REQ_SUBJECT',p_msg_suffix,'DOC_NUMBER', p_doc_number, 'AUCTION_TITLE', p_auction_title));
2088:
2089: wf_engine.SetItemAttrText (itemtype => p_itemType,
2090: itemkey => p_itemKey,
2091: aname => 'EMD_PON_AUC_APPR_REMINDER_SUB',

Line 2092: avalue => 'EMD '|| PON_AUCTION_PKG.getMessage('PON_AUC_APPR_REMINDER_SUB',p_msg_suffix,'DOC_NUMBER', p_doc_number));

2088:
2089: wf_engine.SetItemAttrText (itemtype => p_itemType,
2090: itemkey => p_itemKey,
2091: aname => 'EMD_PON_AUC_APPR_REMINDER_SUB',
2092: avalue => 'EMD '|| PON_AUCTION_PKG.getMessage('PON_AUC_APPR_REMINDER_SUB',p_msg_suffix,'DOC_NUMBER', p_doc_number));
2093:
2094: --added for eric test,end
2095:
2096:

Line 2100: avalue => PON_AUCTION_PKG.getMessage('PON_AUC_APPR_APPRD_SUBJECT',p_msg_suffix, 'DOC_NUMBER',p_doc_number, 'AUCTION_TITLE', p_auction_title));

2096:
2097: wf_engine.SetItemAttrText (itemtype => p_itemType,
2098: itemkey => p_itemKey,
2099: aname => 'DOC_APPROVED_MAIL_SUBJECT',
2100: avalue => PON_AUCTION_PKG.getMessage('PON_AUC_APPR_APPRD_SUBJECT',p_msg_suffix, 'DOC_NUMBER',p_doc_number, 'AUCTION_TITLE', p_auction_title));
2101:
2102: wf_engine.SetItemAttrText (itemtype => p_itemType,
2103: itemkey => p_itemKey,
2104: aname => 'DOC_REJECTED_MAIL_SUBJECT',

Line 2105: avalue => PON_AUCTION_PKG.getMessage('PON_AUC_APPR_REJ_SUBJECT', p_msg_suffix,'DOC_NUMBER',p_doc_number, 'AUCTION_TITLE', p_auction_title));

2101:
2102: wf_engine.SetItemAttrText (itemtype => p_itemType,
2103: itemkey => p_itemKey,
2104: aname => 'DOC_REJECTED_MAIL_SUBJECT',
2105: avalue => PON_AUCTION_PKG.getMessage('PON_AUC_APPR_REJ_SUBJECT', p_msg_suffix,'DOC_NUMBER',p_doc_number, 'AUCTION_TITLE', p_auction_title));
2106: end if;
2107:
2108: END SET_NOTIFICATION_SUBJECT;
2109:

Line 2304: --PON_AUCTION_PKG.SET_SESSION_LANGUAGE(NULL,l_language_code);

2300: END IF; --}
2301:
2302: -- bug 7602688 session language for workflow is already set in submit_for_approval procedure.
2303: -- this process is called from 'sourcingapproval' workflow only. so no need to set again.
2304: --PON_AUCTION_PKG.SET_SESSION_LANGUAGE(NULL,l_language_code);
2305:
2306: --Bug 6472383 : If the Negotiation Preview date is mentioned as 'Not Specified', i.e. if the value of
2307: -- l_preview_date_nspec is not null, we need to replace it with the string specific to recipient's language
2308: IF (l_preview_date_nspec IS NOT NULL)

Line 2310: l_preview_date_nspec := PON_AUCTION_PKG.getMessage('PON_AUC_PREVIEW_DATE_NOTSPEC',l_msg_suffix);

2306: --Bug 6472383 : If the Negotiation Preview date is mentioned as 'Not Specified', i.e. if the value of
2307: -- l_preview_date_nspec is not null, we need to replace it with the string specific to recipient's language
2308: IF (l_preview_date_nspec IS NOT NULL)
2309: THEN
2310: l_preview_date_nspec := PON_AUCTION_PKG.getMessage('PON_AUC_PREVIEW_DATE_NOTSPEC',l_msg_suffix);
2311: END IF;
2312:
2313: l_itemKey := itemkey || '_EMD_' || r1.user_id;
2314:

Line 2455: l_timezone := PON_AUCTION_PKG.Get_Time_Zone(r1.user_name);

2451: , itemkey => l_itemKey
2452: , aname => 'ORIGIN_USER_NAME'
2453: , avalue => fnd_global.user_name);
2454:
2455: l_timezone := PON_AUCTION_PKG.Get_Time_Zone(r1.user_name);
2456:
2457: l_oex_timezone := PON_AUCTION_PKG.Get_Oex_Time_Zone;
2458:
2459: IF (l_timezone IS NULL)

Line 2457: l_oex_timezone := PON_AUCTION_PKG.Get_Oex_Time_Zone;

2453: , avalue => fnd_global.user_name);
2454:
2455: l_timezone := PON_AUCTION_PKG.Get_Time_Zone(r1.user_name);
2456:
2457: l_oex_timezone := PON_AUCTION_PKG.Get_Oex_Time_Zone;
2458:
2459: IF (l_timezone IS NULL)
2460: THEN
2461: l_timezone := l_oex_timezone;

Line 2464: l_timezone_disp := PON_AUCTION_PKG.Get_TimeZone_Description(l_timezone,l_language_code);

2460: THEN
2461: l_timezone := l_oex_timezone;
2462: END IF;
2463:
2464: l_timezone_disp := PON_AUCTION_PKG.Get_TimeZone_Description(l_timezone,l_language_code);
2465:
2466: wf_engine.SetItemAttrText( itemtype => l_itemType
2467: , itemkey => l_itemKey
2468: , aname => 'TIMEZONE'

Line 2487: , avalue => PON_AUCTION_PKG.getMessage('PON_AUC_OPEN_IMM_AFTER_PUB'

2483: THEN
2484: wf_engine.SetItemAttrText( itemtype => l_itemType
2485: , itemkey => l_itemKey
2486: , aname => 'OPEN_IMMEDIATELY'
2487: , avalue => PON_AUCTION_PKG.getMessage('PON_AUC_OPEN_IMM_AFTER_PUB'
2488: ,l_msg_suffix));
2489:
2490: wf_engine.SetItemAttrText( itemtype => l_itemType
2491: , itemkey => l_itemKey

Line 2543: --PON_AUCTION_PKG.SET_SESSION_LANGUAGE(NULL,l_creator_session_lang_code);

2539: END LOOP;
2540:
2541: /* Reset to creator's language */
2542: -- 7602688
2543: --PON_AUCTION_PKG.SET_SESSION_LANGUAGE(NULL,l_creator_session_lang_code);
2544: END StartEmdApprovalProcess;
2545:
2546: --PROCEDURE Emd_User_Approved is ADDED FOR ERIC TEST ONLY
2547: PROCEDURE Emd_User_Approved