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 349: PON_AUCTION_PKG.SET_SESSION_LANGUAGE(null,l_language_code);

345: module => g_module_prefix || 'SUBMIT_FOR_APPROVAL',
346: message => '1. Calling SET_SESSION_LANGUAGE with l_language_code : ' || l_language_code);
347: END IF; --}
348:
349: PON_AUCTION_PKG.SET_SESSION_LANGUAGE(null,l_language_code);
350:
351: select to_char(PON_AUCTION_WF_APPROVALS_S.NEXTVAL)
352: into l_seq from sys.dual;
353:

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

443: from pon_auction_headers_all auh, pon_auc_doctypes dt
444: where auh.auction_header_id = p_auction_header_id
445: and auh.doctype_id = dt.doctype_id;
446:
447: l_msg_suffix := PON_AUCTION_PKG.GET_MESSAGE_SUFFIX (l_doctype_group_name);
448:
449: wf_engine.SetItemAttrText (itemtype => l_itemType,
450: itemkey => l_itemKey,
451: aname => 'MSG_SUFFIX',

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

450: itemkey => l_itemKey,
451: aname => 'MSG_SUFFIX',
452: avalue => l_msg_suffix);
453: -- Get the user's timezone
454: l_timezone := PON_AUCTION_PKG.Get_Time_Zone(l_auction_contact_id);
455:
456: l_oex_timezone := PON_AUCTION_PKG.Get_Oex_Time_Zone;
457:
458: if (l_timezone is null or l_timezone = '' ) then

Line 456: l_oex_timezone := PON_AUCTION_PKG.Get_Oex_Time_Zone;

452: avalue => l_msg_suffix);
453: -- Get the user's timezone
454: l_timezone := PON_AUCTION_PKG.Get_Time_Zone(l_auction_contact_id);
455:
456: l_oex_timezone := PON_AUCTION_PKG.Get_Oex_Time_Zone;
457:
458: if (l_timezone is null or l_timezone = '' ) then
459: l_timezone := l_oex_timezone;
460: end if;

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

470: l_preview_date_in_tz := l_preview_date;
471: l_timezone := l_oex_timezone;
472: END IF;
473:
474: l_timezone_disp := PON_AUCTION_PKG.Get_TimeZone_Description(l_timezone, l_language_code);
475:
476: wf_engine.SetItemAttrText (itemtype => l_itemType,
477: itemkey => l_itemKey,
478: aname => 'TIMEZONE',

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

493:
494: wf_engine.SetItemAttrText (itemtype => l_itemtype,
495: itemkey => l_itemkey,
496: aname => 'PREVIEW_DATE_NOTSPECIFIED',
497: avalue => PON_AUCTION_PKG.getMessage('PON_AUC_PREVIEW_DATE_NOTSPEC',l_msg_suffix));
498: ELSE
499: l_timezone1_disp := l_timezone_disp;
500:
501: wf_engine.SetItemAttrDate (itemtype => l_itemtype,

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

522: if (l_open_auction_now_flag = 'Y') then
523: wf_engine.SetItemAttrText (itemtype => l_itemType,
524: itemkey => l_itemKey,
525: aname => 'OPEN_IMMEDIATELY',
526: avalue => PON_AUCTION_PKG.getMessage('PON_AUC_OPEN_IMM_AFTER_PUB',l_msg_suffix));
527:
528: wf_engine.SetItemAttrText (itemtype => l_itemType,
529: itemkey => l_itemKey,
530: aname => 'O_TIMEZONE',

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

782: module => g_module_prefix || 'StartUserApprovalProcess',
783: message => '1. Calling SET_SESSION_LANGUAGE with l_language_code : ' || l_language_code);
784: END IF; --}
785:
786: PON_AUCTION_PKG.SET_SESSION_LANGUAGE(null,l_language_code);
787:
788: --Bug 6472383 : If the Negotiation Preview date is mentioned as 'Not Specified', i.e. if the value of
789: -- l_preview_date_nspec is not null, we need to replace it with the string specific to recipient's language
790: IF (l_preview_date_nspec is not null) THEN

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

787:
788: --Bug 6472383 : If the Negotiation Preview date is mentioned as 'Not Specified', i.e. if the value of
789: -- l_preview_date_nspec is not null, we need to replace it with the string specific to recipient's language
790: IF (l_preview_date_nspec is not null) THEN
791: l_preview_date_nspec := PON_AUCTION_PKG.getMessage('PON_AUC_PREVIEW_DATE_NOTSPEC',l_msg_suffix);
792: END IF;
793:
794: l_itemKey := itemkey || '_' || r1.user_id;
795:

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

936: itemkey => l_itemKey,
937: aname => 'ORIGIN_USER_NAME',
938: avalue => fnd_global.user_name);
939:
940: l_timezone := PON_AUCTION_PKG.Get_Time_Zone(r1.user_name);
941:
942: l_oex_timezone := PON_AUCTION_PKG.Get_Oex_Time_Zone;
943:
944: if (l_timezone is null) then

Line 942: l_oex_timezone := PON_AUCTION_PKG.Get_Oex_Time_Zone;

938: avalue => fnd_global.user_name);
939:
940: l_timezone := PON_AUCTION_PKG.Get_Time_Zone(r1.user_name);
941:
942: l_oex_timezone := PON_AUCTION_PKG.Get_Oex_Time_Zone;
943:
944: if (l_timezone is null) then
945: l_timezone := l_oex_timezone;
946: end if;

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

944: if (l_timezone is null) then
945: l_timezone := l_oex_timezone;
946: end if;
947:
948: l_timezone_disp := PON_AUCTION_PKG.Get_TimeZone_Description(l_timezone, l_language_code);
949:
950: wf_engine.SetItemAttrText (itemtype => l_itemType,
951: itemkey => l_itemKey,
952: aname => 'TIMEZONE',

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

962: if (r1.open_auction_now_flag = 'Y') then
963: wf_engine.SetItemAttrText (itemtype => l_itemType,
964: itemkey => l_itemKey,
965: aname => 'OPEN_IMMEDIATELY',
966: avalue => PON_AUCTION_PKG.getMessage('PON_AUC_OPEN_IMM_AFTER_PUB',l_msg_suffix));
967:
968: wf_engine.SetItemAttrText (itemtype => l_itemType,
969: itemkey => l_itemKey,
970: aname => 'O_TIMEZONE',

Line 1013: PON_AUCTION_PKG.SET_SESSION_LANGUAGE(null,l_creator_session_lang_code);

1009: itemKey => l_itemKey );
1010: end loop;
1011:
1012: /* Reset to creator's language */
1013: PON_AUCTION_PKG.SET_SESSION_LANGUAGE(null,l_creator_session_lang_code);
1014:
1015: end StartUserApprovalProcess;
1016:
1017:

Line 1246: l_oex_timezone := PON_AUCTION_PKG.Get_Oex_Time_Zone;

1242: and object_type_code = 'NEGOTIATION'
1243: and action_type = 'APPROVE';
1244:
1245: PON_PROFILE_UTIL_PKG.GET_WF_LANGUAGE(l_user_id,l_language_code);
1246: l_oex_timezone := PON_AUCTION_PKG.Get_Oex_Time_Zone;
1247:
1248: -- Get the user's time zone
1249: l_timezone := PON_AUCTION_PKG.Get_Time_Zone(l_auction_contact_id);
1250:

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

1245: PON_PROFILE_UTIL_PKG.GET_WF_LANGUAGE(l_user_id,l_language_code);
1246: l_oex_timezone := PON_AUCTION_PKG.Get_Oex_Time_Zone;
1247:
1248: -- Get the user's time zone
1249: l_timezone := PON_AUCTION_PKG.Get_Time_Zone(l_auction_contact_id);
1250:
1251: if (l_timezone is null or l_timezone = '') then
1252: l_timezone := l_oex_timezone;
1253: end if;

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

1262: l_timezone := l_oex_timezone;
1263: END IF;
1264:
1265: -- Set the dates based on the user's time zone
1266: l_timezone_disp := PON_AUCTION_PKG.Get_TimeZone_Description(l_timezone, l_language_code);
1267:
1268: wf_engine.SetItemAttrDate (itemtype => itemType,
1269: itemkey => itemKey,
1270: aname => 'APPROVE_DATE',

Line 1345: l_oex_timezone := PON_AUCTION_PKG.Get_Oex_Time_Zone;

1341: and object_type_code = 'NEGOTIATION'
1342: and action_type = 'REJECT';
1343:
1344: PON_PROFILE_UTIL_PKG.GET_WF_LANGUAGE(l_user_id,l_language_code);
1345: l_oex_timezone := PON_AUCTION_PKG.Get_Oex_Time_Zone;
1346:
1347: -- Get the user's time zone
1348: l_timezone := PON_AUCTION_PKG.Get_Time_Zone(l_auction_contact_id);
1349:

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

1344: PON_PROFILE_UTIL_PKG.GET_WF_LANGUAGE(l_user_id,l_language_code);
1345: l_oex_timezone := PON_AUCTION_PKG.Get_Oex_Time_Zone;
1346:
1347: -- Get the user's time zone
1348: l_timezone := PON_AUCTION_PKG.Get_Time_Zone(l_auction_contact_id);
1349:
1350: if (l_timezone is null or l_timezone = '') then
1351: l_timezone := l_oex_timezone;
1352: end if;

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

1361: l_timezone := l_oex_timezone;
1362: END IF;
1363:
1364: -- Set the dates based on the user's time zone
1365: l_timezone_disp := PON_AUCTION_PKG.Get_TimeZone_Description(l_timezone, l_language_code);
1366:
1367: wf_engine.SetItemAttrDate (itemtype => itemType,
1368: itemkey => itemKey,
1369: aname => 'REJECT_DATE',

Line 1486: 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));

1482: if (p_amendment_number is not null and p_amendment_number > 0) then
1483: wf_engine.SetItemAttrText (itemtype => p_itemType,
1484: itemkey => p_itemKey,
1485: aname => 'REQUEST_FOR_APPROVALS_SUBJECT',
1486: 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));
1487:
1488: wf_engine.SetItemAttrText (itemtype => p_itemType,
1489: itemkey => p_itemKey,
1490: aname => 'PON_AUC_APPR_REMINDER_SUB',

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

1487:
1488: wf_engine.SetItemAttrText (itemtype => p_itemType,
1489: itemkey => p_itemKey,
1490: aname => 'PON_AUC_APPR_REMINDER_SUB',
1491: avalue => PON_AUCTION_PKG.getMessage('PON_AMEND_APPR_REMINDER_SUB',p_msg_suffix,'AMENDMENT_NUMBER', p_amendment_number, 'ORIG_NUMBER', p_orig_document_number));
1492:
1493: wf_engine.SetItemAttrText (itemtype => p_itemType,
1494: itemkey => p_itemKey,
1495: aname => 'DOC_APPROVED_MAIL_SUBJECT',

Line 1496: 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));

1492:
1493: wf_engine.SetItemAttrText (itemtype => p_itemType,
1494: itemkey => p_itemKey,
1495: aname => 'DOC_APPROVED_MAIL_SUBJECT',
1496: 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));
1497:
1498: wf_engine.SetItemAttrText (itemtype => p_itemType,
1499: itemkey => p_itemKey,
1500: aname => 'DOC_REJECTED_MAIL_SUBJECT',

Line 1501: 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));

1497:
1498: wf_engine.SetItemAttrText (itemtype => p_itemType,
1499: itemkey => p_itemKey,
1500: aname => 'DOC_REJECTED_MAIL_SUBJECT',
1501: 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));
1502:
1503: else
1504: wf_engine.SetItemAttrText (itemtype => p_itemType,
1505: itemkey => p_itemKey,

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

1503: else
1504: wf_engine.SetItemAttrText (itemtype => p_itemType,
1505: itemkey => p_itemKey,
1506: aname => 'REQUEST_FOR_APPROVALS_SUBJECT',
1507: avalue => PON_AUCTION_PKG.getMessage('PON_AUC_APPR_REQ_SUBJECT',p_msg_suffix,'DOC_NUMBER', p_doc_number, 'AUCTION_TITLE', p_auction_title));
1508:
1509:
1510: wf_engine.SetItemAttrText (itemtype => p_itemType,
1511: itemkey => p_itemKey,

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

1509:
1510: wf_engine.SetItemAttrText (itemtype => p_itemType,
1511: itemkey => p_itemKey,
1512: aname => 'PON_AUC_APPR_REMINDER_SUB',
1513: avalue => PON_AUCTION_PKG.getMessage('PON_AUC_APPR_REMINDER_SUB',p_msg_suffix,'DOC_NUMBER', p_doc_number));
1514:
1515:
1516: wf_engine.SetItemAttrText (itemtype => p_itemType,
1517: itemkey => p_itemKey,

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

1515:
1516: wf_engine.SetItemAttrText (itemtype => p_itemType,
1517: itemkey => p_itemKey,
1518: aname => 'DOC_APPROVED_MAIL_SUBJECT',
1519: avalue => PON_AUCTION_PKG.getMessage('PON_AUC_APPR_APPRD_SUBJECT',p_msg_suffix, 'DOC_NUMBER',p_doc_number, 'AUCTION_TITLE', p_auction_title));
1520:
1521: wf_engine.SetItemAttrText (itemtype => p_itemType,
1522: itemkey => p_itemKey,
1523: aname => 'DOC_REJECTED_MAIL_SUBJECT',

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

1520:
1521: wf_engine.SetItemAttrText (itemtype => p_itemType,
1522: itemkey => p_itemKey,
1523: aname => 'DOC_REJECTED_MAIL_SUBJECT',
1524: avalue => PON_AUCTION_PKG.getMessage('PON_AUC_APPR_REJ_SUBJECT', p_msg_suffix,'DOC_NUMBER',p_doc_number, 'AUCTION_TITLE', p_auction_title));
1525: end if;
1526:
1527: END SET_NOTIFICATION_SUBJECT;
1528: