APPS.PO_DOCUMENT_CHECKS_PVT dependencies on FND_PROFILE

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

6057: AND POC.type_lookup_code = 'CONTRACT'
6058: /* R12 GCPA
6059: + If Profile ALLOW_REFERENCING_CPA_UNDER_AMENDMENT is Y, then we can refer any Contract Which is approved Once
6060: + Else Contract should be in APPROVED state */
6061: AND ( (NVL(FND_PROFILE.VALUE('ALLOW_REFERENCING_CPA_UNDER_AMENDMENT'),'N') = 'Y'
6062: AND POC.Approved_Date Is Null
6063: )
6064: or ( NVL(FND_PROFILE.VALUE('ALLOW_REFERENCING_CPA_UNDER_AMENDMENT'),'N') = 'N'
6065: and nvl(POC.APPROVED_FLAG,'N') <> 'Y')

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

6060: + Else Contract should be in APPROVED state */
6061: AND ( (NVL(FND_PROFILE.VALUE('ALLOW_REFERENCING_CPA_UNDER_AMENDMENT'),'N') = 'Y'
6062: AND POC.Approved_Date Is Null
6063: )
6064: or ( NVL(FND_PROFILE.VALUE('ALLOW_REFERENCING_CPA_UNDER_AMENDMENT'),'N') = 'N'
6065: and nvl(POC.APPROVED_FLAG,'N') <> 'Y')
6066: )
6067: AND NVL(POC.user_hold_flag, 'N') <> 'Y'; --< Bug 3422733 >
6068:

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

6987: -- Check 22: If the profile option PO_VMI_DISPLAY_WARNING is on,
6988: -- display a warning if the item has a VMI relationship.
6989:
6990: -- Flag indicating if profile PO_VMI_DISPLAY_WARNING is on
6991: fnd_profile.get(PO_PROFILES.PO_VMI_DISPLAY_WARNING,l_po_vmi_display_warning);
6992:
6993: IF (l_po_vmi_display_warning = 'Y') THEN
6994:
6995: l_textline := FND_MESSAGE.get_string('PO', 'PO_SUB_VMI_ASL_EXISTS');