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_PROFILE

Line 4: g_po_wf_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('PO_SET_DEBUG_WORKFLOW_ON'),'N');

1: PACKAGE BODY po_reqapproval_init1 AS
2: /* $Header: POXWPA1B.pls 120.141.12020000.8 2013/03/31 10:32:55 vpeddi ship $ */
3: -- Read the profile option that enables/disables the debug log
4: g_po_wf_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('PO_SET_DEBUG_WORKFLOW_ON'),'N');
5: -- Read the profile option that determines whether the promise date will be defaulted with need-by date or not
6: g_default_promise_date VARCHAR2(1) := NVL(FND_PROFILE.VALUE('POS_DEFAULT_PROMISE_DATE_ACK'),'N');
7: g_document_subtype PO_HEADERS_ALL.TYPE_LOOKUP_CODE%TYPE;
8: --Bug#3497033

Line 6: g_default_promise_date VARCHAR2(1) := NVL(FND_PROFILE.VALUE('POS_DEFAULT_PROMISE_DATE_ACK'),'N');

2: /* $Header: POXWPA1B.pls 120.141.12020000.8 2013/03/31 10:32:55 vpeddi ship $ */
3: -- Read the profile option that enables/disables the debug log
4: g_po_wf_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('PO_SET_DEBUG_WORKFLOW_ON'),'N');
5: -- Read the profile option that determines whether the promise date will be defaulted with need-by date or not
6: g_default_promise_date VARCHAR2(1) := NVL(FND_PROFILE.VALUE('POS_DEFAULT_PROMISE_DATE_ACK'),'N');
7: g_document_subtype PO_HEADERS_ALL.TYPE_LOOKUP_CODE%TYPE;
8: --Bug#3497033
9: --g_currency_format_mask declared to pass in as the second parameter
10: --in FND_CURRENCY.GET_FORMAT_MASK

Line 938: FND_PROFILE.GET('PO_SECONDRY_EMAIL_ADD', EmailAddProfile);

934: --
935: -- Initialize workflow item attributes
936: --
937: /* get the profile option value for the second Email Address */
938: FND_PROFILE.GET('PO_SECONDRY_EMAIL_ADD', EmailAddProfile);
939: IF NVL(ActionOriginatedFrom, 'Approval') = 'POS_DATE_CHG' THEN
940: -- Mod Project
941: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'WEB_SUPPLIER_REQUEST', avalue => 'Y');
942: END IF;

Line 1300: --NVL(FND_PROFILE.VALUE('PO_CLM_KO_SIGNATURE_REQD'),'N');

1296: FROM po_headers_all
1297: WHERE po_header_id = DocumentID;
1298: l_ko_sign_required := PO_CORE_S.retrieveOptionValue(p_org_id => l_org_id,
1299: p_option_column => PO_CORE_S.g_KO_SIGNATURE_REQD_COL);
1300: --NVL(FND_PROFILE.VALUE('PO_CLM_KO_SIGNATURE_REQD'),'N');
1301: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'KO_SIGNATURE_PROFILE', avalue => l_ko_sign_required);
1302: end if;
1303: IF DraftID = -1 THEN
1304: BEGIN

Line 1574: x_progress := 'PO_REQAPPROVAL_INIT1.Start_WF_Process: Before call to FND_PROFILE';

1570: PO_CHORD_WF6.Set_Wf_Agreement_Tol(l_itemtype, l_itemkey , DocumentSubtype);
1571: ELSIF DocumentTypeCode = 'RELEASE' THEN
1572: PO_CHORD_WF6.Set_Wf_Release_Tol(l_itemtype, l_itemkey , DocumentSubtype);
1573: END IF;
1574: x_progress := 'PO_REQAPPROVAL_INIT1.Start_WF_Process: Before call to FND_PROFILE';
1575: IF (g_po_wf_debug = 'Y') THEN
1576: PO_WF_DEBUG_PKG.insert_debug(l_itemtype,l_itemkey,x_progress);
1577: END IF;
1578: /* Get the USER_ID and the RESPONSIBLITY_ID for the current forms session.

Line 1782: l_printer := fnd_profile.value('PRINTER');

1778: the internal user name of the owner in wf_users. To pass it as
1779: "PER:person_id" has been disallowed by WF. */
1780: owner => x_username); -- Bug 2148872 }
1781: -- Context Setting revamp (begin)
1782: l_printer := fnd_profile.value('PRINTER');
1783: l_conc_copies := to_number(fnd_profile.value('CONC_COPIES'));
1784: l_conc_save_output := fnd_profile.value('CONC_SAVE_OUTPUT');
1785: /* changed the call from wf_engine.setiteattrtext to
1786: po_wf_util_pkg.setitemattrtext because the later handles

Line 1783: l_conc_copies := to_number(fnd_profile.value('CONC_COPIES'));

1779: "PER:person_id" has been disallowed by WF. */
1780: owner => x_username); -- Bug 2148872 }
1781: -- Context Setting revamp (begin)
1782: l_printer := fnd_profile.value('PRINTER');
1783: l_conc_copies := to_number(fnd_profile.value('CONC_COPIES'));
1784: l_conc_save_output := fnd_profile.value('CONC_SAVE_OUTPUT');
1785: /* changed the call from wf_engine.setiteattrtext to
1786: po_wf_util_pkg.setitemattrtext because the later handles
1787: attrbute not found exception. req change order wf also

Line 1784: l_conc_save_output := fnd_profile.value('CONC_SAVE_OUTPUT');

1780: owner => x_username); -- Bug 2148872 }
1781: -- Context Setting revamp (begin)
1782: l_printer := fnd_profile.value('PRINTER');
1783: l_conc_copies := to_number(fnd_profile.value('CONC_COPIES'));
1784: l_conc_save_output := fnd_profile.value('CONC_SAVE_OUTPUT');
1785: /* changed the call from wf_engine.setiteattrtext to
1786: po_wf_util_pkg.setitemattrtext because the later handles
1787: attrbute not found exception. req change order wf also
1788: uses these procedures and does not have the preparer_printer

Line 1965: IF (fnd_profile.value('POR_SSP4_INSTALLED') = 'Y' AND l_document_type = 'REQUISITION' AND po_core_s.get_product_install_status('ICX') = 'I') THEN

1961: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemType, itemkey => itemkey, aname => 'OPEN_FORM_COMMAND' , avalue => l_open_form);
1962: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemType, itemkey => itemkey, aname => 'VIEW_DOC_URL' , avalue => l_view_po_url);
1963: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemType, itemkey => itemkey, aname => 'EDIT_DOC_URL' , avalue => l_edit_po_url);
1964: END IF;
1965: IF (fnd_profile.value('POR_SSP4_INSTALLED') = 'Y' AND l_document_type = 'REQUISITION' AND po_core_s.get_product_install_status('ICX') = 'I') THEN
1966: --Bug#3147435
1967: --Set the values for workflow attribute
1968: --VIEW_REQ_DTLS_URL and EDIT_REQ_URL
1969: l_view_req_dtls_url := 'JSP:/OA_HTML/OA.jsp?OAFunc=ICX_POR_LAUNCH_IP' || '&' || 'porMode=viewReq' || '&' || 'porReqHeaderId=' || TO_CHAR(l_document_id) || '&' ||

Line 1976: is_clm_enabled := NVL(FND_PROFILE.VALUE('POR_IS_CLM_ENABLED'),'N');

1972: l_resubmit_url := 'JSP:/OA_HTML/OA.jsp?OAFunc=ICX_POR_LAUNCH_IP' || '&' || 'porMode=resubmitReq' || '&' || 'porReqHeaderId=' || TO_CHAR(l_document_id) || '&' || '_OrgId=' || TO_CHAR(x_orgid);
1973: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemType, itemkey => itemkey, aname => 'VIEW_REQ_DTLS_URL', avalue => l_view_req_dtls_url);
1974: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemType, itemkey => itemkey, aname => 'EDIT_REQ_URL', avalue => l_edit_req_url);
1975: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemType, itemkey => itemkey, aname => 'RESUBMIT_REQ_URL', avalue => l_resubmit_url);
1976: is_clm_enabled := NVL(FND_PROFILE.VALUE('POR_IS_CLM_ENABLED'),'N');
1977: IF is_clm_enabled = 'Y' THEN
1978: l_conf_header_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype, itemkey => itemkey, aname => 'CONFORMED_HEADER_ID');
1979: l_imp_amendment_url := 'JSP:/OA_HTML/OA.jsp?OAFunc=ICX_POR_LAUNCH_IP' || '&' ||
1980: 'porMode=implementAmendment' || '&' || 'porReqHeaderId=' || TO_CHAR(l_document_id) || '&' || '_OrgId=' ||

Line 2094: l_external_url := fnd_profile.value('POS_EXTERNAL_URL');

2090: wf_engine.SetItemAttrText(itemtype => itemtype, itemkey => itemkey, aname => 'PO_LINES_DETAILS', avalue => 'PLSQLCLOB:PO_WF_PO_NOTIFICATION.GET_PO_LINES_DETAILS/'|| itemtype||':'|| itemkey);
2091: wf_engine.SetItemAttrText(itemtype => itemtype, itemkey => itemkey, aname => 'ACTION_HISTORY', avalue => 'PLSQL:PO_WF_PO_NOTIFICATION.GET_ACTION_HISTORY/'|| itemtype||':'|| itemkey);
2092: END IF;
2093: --Bug 6164753
2094: l_external_url := fnd_profile.value('POS_EXTERNAL_URL');
2095: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemtype, itemkey => itemkey, aname => '#WFM_HTMLAGENT', avalue => l_external_url);
2096: --Bug 6164753
2097:
2098: /* PO AME Project :Start

Line 4361: fnd_profile.get('PO_WORKFLOW_APPROVAL_MODE', l_approval_mode);

4357: IF (funcmode <> wf_engine.eng_run) THEN
4358: resultout := wf_engine.eng_null;
4359: RETURN;
4360: END IF;
4361: fnd_profile.get('PO_WORKFLOW_APPROVAL_MODE', l_approval_mode);
4362: /* Bug 678291 by dkfchan
4363: ** if the approval mode is background, set the result to 'BACKGROUD'
4364: ** Removed the original method which set the WF_ENGINE.THRESHOLD to -1.
4365: ** This fix depends on the change poxwfrqa.wft and poxwfpoa.wft also.

Line 4530: l_approval_currency := FND_PROFILE.VALUE_SPECIFIC('ICX_PREFERRED_CURRENCY', l_user_id);

4526: IF (g_po_wf_debug = 'Y') THEN
4527: /* DEBUG */
4528: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
4529: END IF;
4530: l_approval_currency := FND_PROFILE.VALUE_SPECIFIC('ICX_PREFERRED_CURRENCY', l_user_id);
4531: END IF;
4532: IF (l_approval_currency = p_function_currency OR l_approver_user_name IS NULL OR l_rate_type IS NULL OR l_approval_currency IS NULL) THEN
4533: x_amount_for_subject := p_total_amount_disp || ' ' || p_function_currency;
4534: x_amount_for_header := p_req_amount_disp || ' ' || p_function_currency;

Line 5777: fnd_profile.get

5773: )
5774: ;
5775: END IF;
5776: -- Get the profile option report_quantity_precision
5777: fnd_profile.get
5778: (
5779: 'REPORT_QUANTITY_PRECISION', l_qty_precision
5780: )
5781: ;

Line 5794: FND_PROFILE.GET

5790: l_qty_precision := '2';
5791: END IF;
5792: -- Get the user id for the current user. This information
5793: -- is used when sending concurrent request.
5794: FND_PROFILE.GET
5795: (
5796: 'USER_ID', l_user_id
5797: )
5798: ;

Line 6073: fnd_profile.get

6069: )
6070: ;
6071: END IF;
6072: -- Get the profile option report_quantity_precision
6073: fnd_profile.get
6074: (
6075: 'REPORT_QUANTITY_PRECISION', l_qty_precision
6076: )
6077: ;

Line 6080: FND_PROFILE.GET

6076: )
6077: ;
6078: -- Get the user id for the current user. This information
6079: -- is used when sending concurrent request.
6080: FND_PROFILE.GET
6081: (
6082: 'USER_ID', l_user_id
6083: )
6084: ;

Line 6310: l_set_lang := fnd_request.set_options('NO', 'NO', NULL,NULL, NULL, FND_PROFILE.VALUE('ICX_NUMERIC_CHARACTERS'));

6306: --Bug#3528330 used the procedure po_communication_profile() to check for the
6307: --PO output format option instead of checking for the installation of
6308: --XDO product
6309: --Bug5080617 Pass the parameters P_PO_TEMPLATE_CODE and P_CONTRACT_TEMPLATE_CODE as null
6310: l_set_lang := fnd_request.set_options('NO', 'NO', NULL,NULL, NULL, FND_PROFILE.VALUE('ICX_NUMERIC_CHARACTERS'));
6311: IF
6312: (
6313: PO_COMMUNICATION_PVT.PO_COMMUNICATION_PROFILE = 'T' AND g_document_subtype <>'PLANNED'
6314: )

Line 6373: l_set_lang := fnd_request.set_options('NO', 'NO', NULL,NULL, NULL, FND_PROFILE.VALUE('ICX_NUMERIC_CHARACTERS'));

6369: (
6370: po_moac_utils_pvt.get_current_org_id
6371: )
6372: ;
6373: l_set_lang := fnd_request.set_options('NO', 'NO', NULL,NULL, NULL, FND_PROFILE.VALUE('ICX_NUMERIC_CHARACTERS'));
6374: --
6375: l_request_id := fnd_request.submit_request
6376: (
6377: 'PO', 'POXPPO', NULL, NULL, false, 'P_REPORT_TYPE=R', 'P_TEST_FLAG=N',

Line 6495: l_set_lang := fnd_request.set_options('NO', 'NO', NULL,NULL, NULL, FND_PROFILE.VALUE('ICX_NUMERIC_CHARACTERS'));

6491: po_moac_utils_pvt.get_current_org_id
6492: )
6493: ;
6494: --
6495: l_set_lang := fnd_request.set_options('NO', 'NO', NULL,NULL, NULL, FND_PROFILE.VALUE('ICX_NUMERIC_CHARACTERS'));
6496: l_request_id := fnd_request.submit_request
6497: (
6498: 'PO', 'POXPPO', NULL, NULL, false, 'P_REPORT_TYPE=R', 'P_TEST_FLAG=N', 'P_PO_NUM_FROM=' || p_doc_num,
6499: 'P_PO_NUM_TO=' || p_doc_num, 'P_USER_ID=' || p_user_id, 'P_QTY_PRECISION=' || p_qty_precision,

Line 6618: l_set_lang := fnd_request.set_options('NO', 'NO', NULL,NULL, NULL, FND_PROFILE.VALUE('ICX_NUMERIC_CHARACTERS'));

6614: (
6615: po_moac_utils_pvt.get_current_org_id
6616: )
6617: ;
6618: l_set_lang := fnd_request.set_options('NO', 'NO', NULL,NULL, NULL, FND_PROFILE.VALUE('ICX_NUMERIC_CHARACTERS'));
6619: --
6620: l_request_id := fnd_request.submit_request
6621: (
6622: 'PO', 'POXPPO', NULL, NULL, false, 'P_REPORT_TYPE=R',

Line 6741: l_set_lang := fnd_request.set_options('NO', 'NO', NULL,NULL, NULL, FND_PROFILE.VALUE('ICX_NUMERIC_CHARACTERS'));

6737: (
6738: po_moac_utils_pvt.get_current_org_id
6739: )
6740: ;
6741: l_set_lang := fnd_request.set_options('NO', 'NO', NULL,NULL, NULL, FND_PROFILE.VALUE('ICX_NUMERIC_CHARACTERS'));
6742: --
6743: l_request_id := fnd_request.submit_request
6744: (
6745: 'PO', 'POXPPO', NULL, NULL, false, 'P_REPORT_TYPE=R', 'P_TEST_FLAG=N',

Line 7902: --Fnd_Profile.Get('USER_ID',X_User_Id);

7898: X_Application_Id NUMBER;
7899: -- Bug 4290541 End
7900: BEGIN
7901: -- Bug 4290541 Start
7902: --Fnd_Profile.Get('USER_ID',X_User_Id);
7903: --Fnd_Profile.Get('RESP_ID',X_Responsibility_Id);
7904: --Fnd_Profile.Get('RESP_APPL_ID',X_Application_Id);
7905: -- Bug 4290541 End
7906: -- Context Setting Revamp

Line 7903: --Fnd_Profile.Get('RESP_ID',X_Responsibility_Id);

7899: -- Bug 4290541 End
7900: BEGIN
7901: -- Bug 4290541 Start
7902: --Fnd_Profile.Get('USER_ID',X_User_Id);
7903: --Fnd_Profile.Get('RESP_ID',X_Responsibility_Id);
7904: --Fnd_Profile.Get('RESP_APPL_ID',X_Application_Id);
7905: -- Bug 4290541 End
7906: -- Context Setting Revamp
7907: X_User_Id := fnd_global.user_id;

Line 7904: --Fnd_Profile.Get('RESP_APPL_ID',X_Application_Id);

7900: BEGIN
7901: -- Bug 4290541 Start
7902: --Fnd_Profile.Get('USER_ID',X_User_Id);
7903: --Fnd_Profile.Get('RESP_ID',X_Responsibility_Id);
7904: --Fnd_Profile.Get('RESP_APPL_ID',X_Application_Id);
7905: -- Bug 4290541 End
7906: -- Context Setting Revamp
7907: X_User_Id := fnd_global.user_id;
7908: X_Responsibility_Id := fnd_global.resp_id;