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.

[Home] [Help]

APPS.PO_DOCUMENT_CHECKS_PVT dependencies on FND_PROFILE

Line 1959: --(NVL(FND_PROFILE.VALUE('PO_CLM_ENABLE_FPDS_REPORTING'),'N') = 'Y') THEN

1955: -- For PAR, FPDS-NG (CAR) is not applicable. Therefore, the related validations needs to be skipped.
1956: -- BELOW CODE FOR FPDS-NG PROJECT
1957: IF (l_is_clm_doc = 'Y' AND l_draft_type <> 'PAR' ) AND
1958: -- CLM Controls Project changes
1959: --(NVL(FND_PROFILE.VALUE('PO_CLM_ENABLE_FPDS_REPORTING'),'N') = 'Y') THEN
1960: (NVL(PO_CORE_S.retrieveOptionValue(p_org_id => l_org_id,
1961: p_option_column => PO_CORE_S.g_FPDS_REPORTING_COL)
1962: ,'N') = 'Y') THEN
1963: BEGIN

Line 4202: TRUNC(NVL(POH.end_date + nvl(FND_PROFILE.VALUE('PO_REL_CREATE_TOLERANCE'),0), SYSDATE + 1)); -- bug3199869

4198: WHERE POR.po_header_id = POH.po_header_id
4199: AND POR.po_release_id = p_document_id
4200: AND POR.approved_date IS NULL -- bug3199869
4201: AND TRUNC(SYSDATE) > -- bug3199869
4202: TRUNC(NVL(POH.end_date + nvl(FND_PROFILE.VALUE('PO_REL_CREATE_TOLERANCE'),0), SYSDATE + 1)); -- bug3199869
4203:
4204: --Increment the p_sequence with number of errors reported in last query
4205: p_sequence := p_sequence + SQL%ROWCOUNT;
4206: ----------------------------------------

Line 8705: AND ( (NVL(FND_PROFILE.VALUE('ALLOW_REFERENCING_CPA_UNDER_AMENDMENT'),'N') = 'Y'

8701: AND POC.type_lookup_code = 'CONTRACT'
8702: /* R12 GCPA
8703: + If Profile ALLOW_REFERENCING_CPA_UNDER_AMENDMENT is Y, then we can refer any Contract Which is approved Once
8704: + Else Contract should be in APPROVED state */
8705: AND ( (NVL(FND_PROFILE.VALUE('ALLOW_REFERENCING_CPA_UNDER_AMENDMENT'),'N') = 'Y'
8706: AND POC.Approved_Date Is Null
8707: )
8708: or ( NVL(FND_PROFILE.VALUE('ALLOW_REFERENCING_CPA_UNDER_AMENDMENT'),'N') = 'N'
8709: and nvl(POC.APPROVED_FLAG,'N') <> 'Y')

Line 8708: or ( NVL(FND_PROFILE.VALUE('ALLOW_REFERENCING_CPA_UNDER_AMENDMENT'),'N') = 'N'

8704: + Else Contract should be in APPROVED state */
8705: AND ( (NVL(FND_PROFILE.VALUE('ALLOW_REFERENCING_CPA_UNDER_AMENDMENT'),'N') = 'Y'
8706: AND POC.Approved_Date Is Null
8707: )
8708: or ( NVL(FND_PROFILE.VALUE('ALLOW_REFERENCING_CPA_UNDER_AMENDMENT'),'N') = 'N'
8709: and nvl(POC.APPROVED_FLAG,'N') <> 'Y')
8710: )
8711: AND NVL(POC.user_hold_flag, 'N') <> 'Y'; --< Bug 3422733 >
8712:

Line 9658: fnd_profile.get(PO_PROFILES.PO_VMI_DISPLAY_WARNING,l_po_vmi_display_warning);

9654: -- Check 22: If the profile option PO_VMI_DISPLAY_WARNING is on,
9655: -- display a warning if the item has a VMI relationship.
9656:
9657: -- Flag indicating if profile PO_VMI_DISPLAY_WARNING is on
9658: fnd_profile.get(PO_PROFILES.PO_VMI_DISPLAY_WARNING,l_po_vmi_display_warning);
9659:
9660: IF (l_po_vmi_display_warning = 'Y') THEN
9661:
9662: l_textline := FND_MESSAGE.get_string('PO', 'PO_SUB_VMI_ASL_EXISTS');

Line 12113: > NVL ( TRUNC(POL2.expiration_date) , TRUNC(POH2.end_date+ nvl(FND_PROFILE.VALUE('PO_REL_CREATE_TOLERANCE'),0)))

12109: -- Bug #13550798: Submit Date cannot be later then effective to date of Source Document
12110: /* AND (NVL(TRUNC(POL.start_date), TRUNC(POH.creation_date))
12111: > NVL ( TRUNC(POL2.expiration_date) , TRUNC(POH2.end_date))); */
12112: AND TRUNC(sysdate)
12113: > NVL ( TRUNC(POL2.expiration_date) , TRUNC(POH2.end_date+ nvl(FND_PROFILE.VALUE('PO_REL_CREATE_TOLERANCE'),0)))
12114: AND Nvl(PLL.approved_flag,'N') <> 'Y'; --Bug 16493253
12115:
12116: --Increment the p_sequence with number of errors reported in last query
12117: p_sequence := p_sequence + SQL%ROWCOUNT;

Line 13069: > TRUNC(POH2.end_date+ nvl(FND_PROFILE.VALUE('PO_REL_CREATE_TOLERANCE'),0))

13065: AND POH2.global_agreement_flag = 'Y'
13066: AND Nvl(pol.cancel_flag,'N') = 'N'
13067: AND Nvl(pol.closed_code,'OPEN') <> 'FINALLY CLOSED'
13068: AND TRUNC(sysdate)
13069: > TRUNC(POH2.end_date+ nvl(FND_PROFILE.VALUE('PO_REL_CREATE_TOLERANCE'),0))
13070: AND Nvl(PLL.approved_flag, 'N') <> 'Y';
13071:
13072: x_sequence := x_sequence + SQL%ROWCOUNT;
13073: /* Bug 13550798 - End */

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

22132: END;
22133:
22134: l_ko_sign_required := PO_CORE_S.retrieveOptionValue(p_org_id => l_org_id,
22135: p_option_column => PO_CORE_S.g_KO_SIGNATURE_REQD_COL);
22136: --NVL(FND_PROFILE.VALUE('PO_CLM_KO_SIGNATURE_REQD'),'N');
22137: --We need to check the profile determine if the ko signature is required.
22138: IF l_ko_sign_required <> 'Y' THEN
22139: -- if Contract officer signature is not required, then there is no warrant check.
22140: PO_DEBUG.debug_stmt(l_log_head , l_progress, 'Contracting Officer signature is not required');

Line 26600: l_user_currency := FND_PROFILE.VALUE_SPECIFIC('ICX_PREFERRED_CURRENCY', p_user_id);

26596:
26597: IF ( (l_changed_amt > l_doc_threshold_amount AND l_doc_threshold_amount > 0 )AND
26598: (p_contract_rec.contract_id is NULL)
26599: )THEN
26600: l_user_currency := FND_PROFILE.VALUE_SPECIFIC('ICX_PREFERRED_CURRENCY', p_user_id);
26601: l_limit_amount := TO_CHAR(l_doc_threshold_amount, FND_CURRENCY.GET_FORMAT_MASK(l_user_currency ,60)) || ' ' || l_user_currency;
26602: INSERT INTO po_online_report_text_gt
26603: (online_report_id
26604: ,last_updated_by