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.PO_REQAPPROVAL_INIT1 dependencies on FND_MESSAGE

Line 1193: DECODE(TYPE_LOOKUP_CODE, 'BLANKET',FND_MESSAGE.GET_STRING('POS','POS_POTYPE_BLKT'),

1189: /* Added logic to derive the doc display name */
1190: --CONTERMS FPJ Extracting Contract Terms value in this Query as well
1191: IF l_is_mod = 'N' THEN -- Mod Project
1192: SELECT revision_num,
1193: DECODE(TYPE_LOOKUP_CODE, 'BLANKET',FND_MESSAGE.GET_STRING('POS','POS_POTYPE_BLKT'),
1194: 'CONTRACT',FND_MESSAGE.GET_STRING('POS','POS_POTYPE_CNTR'),
1195: 'STANDARD',FND_MESSAGE.GET_STRING('POS','POS_POTYPE_STD'),
1196: 'PLANNED',FND_MESSAGE.GET_STRING('POS','POS_POTYPE_PLND')),
1197: NVL(CONTERMS_EXIST_FLAG,'N'), --

Line 1194: 'CONTRACT',FND_MESSAGE.GET_STRING('POS','POS_POTYPE_CNTR'),

1190: --CONTERMS FPJ Extracting Contract Terms value in this Query as well
1191: IF l_is_mod = 'N' THEN -- Mod Project
1192: SELECT revision_num,
1193: DECODE(TYPE_LOOKUP_CODE, 'BLANKET',FND_MESSAGE.GET_STRING('POS','POS_POTYPE_BLKT'),
1194: 'CONTRACT',FND_MESSAGE.GET_STRING('POS','POS_POTYPE_CNTR'),
1195: 'STANDARD',FND_MESSAGE.GET_STRING('POS','POS_POTYPE_STD'),
1196: 'PLANNED',FND_MESSAGE.GET_STRING('POS','POS_POTYPE_PLND')),
1197: NVL(CONTERMS_EXIST_FLAG,'N'), --
1198: segment1 -- Bug 3284628

Line 1195: 'STANDARD',FND_MESSAGE.GET_STRING('POS','POS_POTYPE_STD'),

1191: IF l_is_mod = 'N' THEN -- Mod Project
1192: SELECT revision_num,
1193: DECODE(TYPE_LOOKUP_CODE, 'BLANKET',FND_MESSAGE.GET_STRING('POS','POS_POTYPE_BLKT'),
1194: 'CONTRACT',FND_MESSAGE.GET_STRING('POS','POS_POTYPE_CNTR'),
1195: 'STANDARD',FND_MESSAGE.GET_STRING('POS','POS_POTYPE_STD'),
1196: 'PLANNED',FND_MESSAGE.GET_STRING('POS','POS_POTYPE_PLND')),
1197: NVL(CONTERMS_EXIST_FLAG,'N'), --
1198: segment1 -- Bug 3284628
1199: INTO l_revision_num,

Line 1196: 'PLANNED',FND_MESSAGE.GET_STRING('POS','POS_POTYPE_PLND')),

1192: SELECT revision_num,
1193: DECODE(TYPE_LOOKUP_CODE, 'BLANKET',FND_MESSAGE.GET_STRING('POS','POS_POTYPE_BLKT'),
1194: 'CONTRACT',FND_MESSAGE.GET_STRING('POS','POS_POTYPE_CNTR'),
1195: 'STANDARD',FND_MESSAGE.GET_STRING('POS','POS_POTYPE_STD'),
1196: 'PLANNED',FND_MESSAGE.GET_STRING('POS','POS_POTYPE_PLND')),
1197: NVL(CONTERMS_EXIST_FLAG,'N'), --
1198: segment1 -- Bug 3284628
1199: INTO l_revision_num,
1200: l_doc_display_name,

Line 1207: FND_MESSAGE.GET_STRING('PO','PO_MODIFICATION'),

1203: FROM po_headers
1204: WHERE po_header_id = DocumentID;
1205: ELSE -- Mod Project
1206: SELECT 0,
1207: FND_MESSAGE.GET_STRING('PO','PO_MODIFICATION'),
1208: NVL(CONTERMS_EXIST_FLAG,'N'),
1209: segment1
1210: INTO l_revision_num,
1211: l_doc_display_name,

Line 1225: l_doc_display_name := FND_MESSAGE.GET_STRING('PO','PO_GA_TYPE');

1221: --
1222: /* FPI GA Start */
1223: IF l_ga_flag = 'Y' AND l_draft_type IS NULL --l_is_mod = 'N' -- Mod Project
1224: THEN
1225: l_doc_display_name := FND_MESSAGE.GET_STRING('PO','PO_GA_TYPE');
1226: END IF;
1227: /* FPI GA End */
1228: elsif (DocumentTypeCode = 'RELEASE') THEN
1229: -- Bug 3859714. Workflow attribute WITH_TERMS should be set to 'N' for

Line 1235: DECODE(POR.release_type, 'BLANKET', FND_MESSAGE.GET_STRING('POS','POS_POTYPE_BLKTR'), 'SCHEDULED',FND_MESSAGE.GET_STRING('POS','POS_POTYPE_PLNDR')),

1231: l_conterms_exist_flag := 'N';
1232: /* bug 2115200 */
1233: SELECT POR.revision_num,
1234: POR.release_num,
1235: DECODE(POR.release_type, 'BLANKET', FND_MESSAGE.GET_STRING('POS','POS_POTYPE_BLKTR'), 'SCHEDULED',FND_MESSAGE.GET_STRING('POS','POS_POTYPE_PLNDR')),
1236: POH.segment1 -- Bug 3284628
1237: INTO l_revision_num,
1238: l_release_num,
1239: l_doc_display_name,

Line 1523: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => l_itemtype, itemkey => l_itemkey, aname => 'EMAIL_TEXT_WITH_PDF', avalue=>FND_MESSAGE.GET_STRING('PO','PO_PDF_EMAIL_TEXT'));

1519: IF PO_COMMUNICATION_PVT.PO_COMMUNICATION_PROFILE = 'T'
1520: OR l_ame_transaction_type is not NULL THEN -- PO AME Project
1521: PO_WF_UTIL_PKG.SetItemAttrText (itemtype => l_itemtype, itemkey => l_itemkey, aname => 'WITH_TERMS', avalue =>l_conterms_exist_flag);
1522: PO_WF_UTIL_PKG.SetItemAttrText (itemtype => l_itemtype, itemkey => l_itemkey, aname => 'LANGUAGE_CODE', avalue =>userenv('LANG'));
1523: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => l_itemtype, itemkey => l_itemkey, aname => 'EMAIL_TEXT_WITH_PDF', avalue=>FND_MESSAGE.GET_STRING('PO','PO_PDF_EMAIL_TEXT'));
1524: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => l_itemtype, itemkey => l_itemkey, aname => 'PO_PDF_ERROR', avalue=>FND_MESSAGE.GET_STRING('PO','PO_PDF_ERROR'));
1525: PO_WF_UTIL_PKG.SetItemAttrText (itemtype => l_itemtype, itemkey => l_itemkey, aname => 'PDF_ATTACHMENT_BUYER', avalue => 'PLSQLBLOB:PO_COMMUNICATION_PVT.PDF_ATTACH_APP/'|| l_itemtype||':'||l_itemkey);
1526: -- Bug 3851357. Replaced PDF_ATTACH_SUPP with PDF_ATTACH so that the procedure
1527: -- PO_COMMUNICATION_PKG.PDF_ATTACH is consistently called for all Approval PDF

Line 1524: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => l_itemtype, itemkey => l_itemkey, aname => 'PO_PDF_ERROR', avalue=>FND_MESSAGE.GET_STRING('PO','PO_PDF_ERROR'));

1520: OR l_ame_transaction_type is not NULL THEN -- PO AME Project
1521: PO_WF_UTIL_PKG.SetItemAttrText (itemtype => l_itemtype, itemkey => l_itemkey, aname => 'WITH_TERMS', avalue =>l_conterms_exist_flag);
1522: PO_WF_UTIL_PKG.SetItemAttrText (itemtype => l_itemtype, itemkey => l_itemkey, aname => 'LANGUAGE_CODE', avalue =>userenv('LANG'));
1523: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => l_itemtype, itemkey => l_itemkey, aname => 'EMAIL_TEXT_WITH_PDF', avalue=>FND_MESSAGE.GET_STRING('PO','PO_PDF_EMAIL_TEXT'));
1524: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => l_itemtype, itemkey => l_itemkey, aname => 'PO_PDF_ERROR', avalue=>FND_MESSAGE.GET_STRING('PO','PO_PDF_ERROR'));
1525: PO_WF_UTIL_PKG.SetItemAttrText (itemtype => l_itemtype, itemkey => l_itemkey, aname => 'PDF_ATTACHMENT_BUYER', avalue => 'PLSQLBLOB:PO_COMMUNICATION_PVT.PDF_ATTACH_APP/'|| l_itemtype||':'||l_itemkey);
1526: -- Bug 3851357. Replaced PDF_ATTACH_SUPP with PDF_ATTACH so that the procedure
1527: -- PO_COMMUNICATION_PKG.PDF_ATTACH is consistently called for all Approval PDF
1528: -- supplier notifications

Line 2015: fnd_message.set_name ('PO','PO_WF_NOTIF_REQUIRES_APPROVAL');

2011: ** "requires your approval". If the user enters an invalid forward-to
2012: ** then this messages gets nulled-out and the "Invalid Forward-to"
2013: ** message gets a value (see notification: Approve Requisition).
2014: */
2015: fnd_message.set_name ('PO','PO_WF_NOTIF_REQUIRES_APPROVAL');
2016: l_error_msg := fnd_message.get;
2017: wf_engine.SetItemAttrText ( itemtype => itemType, itemkey => itemkey, aname => 'REQUIRES_APPROVAL_MSG' , avalue => l_error_msg);
2018: wf_engine.SetItemAttrText ( itemtype => itemType, itemkey => itemkey, aname => 'WRONG_FORWARD_TO_MSG' , avalue => '');
2019: /* Get the orignial authorization status from the document

Line 2016: l_error_msg := fnd_message.get;

2012: ** then this messages gets nulled-out and the "Invalid Forward-to"
2013: ** message gets a value (see notification: Approve Requisition).
2014: */
2015: fnd_message.set_name ('PO','PO_WF_NOTIF_REQUIRES_APPROVAL');
2016: l_error_msg := fnd_message.get;
2017: wf_engine.SetItemAttrText ( itemtype => itemType, itemkey => itemkey, aname => 'REQUIRES_APPROVAL_MSG' , avalue => l_error_msg);
2018: wf_engine.SetItemAttrText ( itemtype => itemType, itemkey => itemkey, aname => 'WRONG_FORWARD_TO_MSG' , avalue => '');
2019: /* Get the orignial authorization status from the document
2020: ** This has to be done here as we set the document status to

Line 2100: fnd_message.set_name ('PO','PO_WF_NOTIF_REQUIRES_REVIEW');

2096: --Bug 6164753
2097:
2098: /* PO AME Project :Start
2099: Setting requires review message */
2100: fnd_message.set_name ('PO','PO_WF_NOTIF_REQUIRES_REVIEW');
2101: l_review_msg := fnd_message.get;
2102: PO_WF_UTIL_PKG.SetItemAttrText( itemtype => itemType, itemkey => itemkey, aname => 'REQUIRES_REVIEW_MSG' , avalue => l_review_msg);
2103: /* PO AME Project :End */
2104:

Line 2101: l_review_msg := fnd_message.get;

2097:
2098: /* PO AME Project :Start
2099: Setting requires review message */
2100: fnd_message.set_name ('PO','PO_WF_NOTIF_REQUIRES_REVIEW');
2101: l_review_msg := fnd_message.get;
2102: PO_WF_UTIL_PKG.SetItemAttrText( itemtype => itemType, itemkey => itemkey, aname => 'REQUIRES_REVIEW_MSG' , avalue => l_review_msg);
2103: /* PO AME Project :End */
2104:
2105: resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';

Line 4578: l_no_rate_msg := fnd_message.get_string('PO', 'PO_WF_NOTIF_NO_RATE');

4574: /* DEBUG */
4575: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
4576: END IF;
4577: x_amount_for_subject := p_req_amount_disp || ' ' || p_function_currency;
4578: l_no_rate_msg := fnd_message.get_string('PO', 'PO_WF_NOTIF_NO_RATE');
4579: l_no_rate_msg := REPLACE (l_no_rate_msg, 'CURRENCY', l_approval_currency);
4580: x_amount_for_header := p_req_amount_disp || ' ' || p_function_currency;
4581: x_amount_for_header := x_amount_for_header || ' (' || l_no_rate_msg || ')';
4582: x_amount_for_tax := p_tax_amount_disp || ' ' || p_function_currency;

Line 4797: l_mipr_type_disp := fnd_message.get_string('ICX','ICX_CLM_MIPR') || l_clm_mipr_type;

4793: --
4794: wf_engine.SetItemAttrText ( itemtype => itemtype, itemkey => itemkey, aname => 'CLOSED_CODE_DISP', avalue => l_closed_code);
4795: --
4796: IF l_clm_mipr_type IS NOT NULL THEN
4797: l_mipr_type_disp := fnd_message.get_string('ICX','ICX_CLM_MIPR') || l_clm_mipr_type;
4798: wf_engine.SetItemAttrText ( itemtype => itemtype, itemkey => itemkey, aname => 'DOCUMENT_TYPE_DISP', avalue => l_mipr_type_disp);
4799: ELSE
4800: IF(l_is_amendment_approval <> 'Y') THEN
4801: wf_engine.SetItemAttrText ( itemtype => itemtype, itemkey => itemkey, aname => 'DOCUMENT_TYPE_DISP', avalue => l_doc_type_disp);

Line 4805: avalue => fnd_message.get_string('PO','PO_DOC_REQ_AMENDMENT'));

4801: wf_engine.SetItemAttrText ( itemtype => itemtype, itemkey => itemkey, aname => 'DOCUMENT_TYPE_DISP', avalue => l_doc_type_disp);
4802: ELSE
4803: --Bug # 13626231
4804: wf_engine.SetItemAttrText ( itemtype => itemtype, itemkey => itemkey, aname => 'DOCUMENT_TYPE_DISP',
4805: avalue => fnd_message.get_string('PO','PO_DOC_REQ_AMENDMENT'));
4806: END IF;
4807: END IF;
4808:
4809: --

Line 7589: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemtype, itemkey => itemkey, aname => 'ACCEPTANCE_RESULT', avalue => fnd_message.get_string('PO','PO_WF_NOTIF_ACCEPTED') );

7585: aname => 'ACCEPTANCE_TYPE',
7586: avalue => 'Accepted' );
7587: END IF; */
7588: IF (x_acceptance_result IS NULL) THEN
7589: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemtype, itemkey => itemkey, aname => 'ACCEPTANCE_RESULT', avalue => fnd_message.get_string('PO','PO_WF_NOTIF_ACCEPTED') );
7590: END IF;
7591: IF (SUBSTR(x_supp_user_name, 1, 6) = 'email:') THEN
7592: --Get the username and store that in the supplier_user_name.
7593: x_supp_user_name := PO_ChangeOrderWF_PVT.getEmailResponderUserName(x_supp_user_name, l_ntf_role_name);

Line 8397: l_note := fnd_message.get_string('ICX', 'ICX_POR_NOTIF_TIMEOUT');

8393: END IF;
8394: END IF;
8395: END IF;
8396: IF l_note IS NULL THEN
8397: l_note := fnd_message.get_string('ICX', 'ICX_POR_NOTIF_TIMEOUT');
8398: END IF;
8399: IF l_rowid IS NOT NULL THEN
8400: -- SQL What : Update the No action in the action history.
8401: -- Sql Why : To maintain the NO ACTION message in approver language.