APPS.CN_PAYMENT_SECURITY_PVT dependencies on FND_PROFILE

Line 919: IF NVL (fnd_profile.VALUE ('CN_CHK_WKSHT_STATUS'), 'Y') = 'Y'

915: RAISE fnd_api.g_exc_error;
916: END IF;
917:
918: --Added for R12 payment security check end.
919: IF NVL (fnd_profile.VALUE ('CN_CHK_WKSHT_STATUS'), 'Y') = 'Y'
920: THEN
921: -- all worksheet should be 'APPROVED' if profile = 'Y'
922: BEGIN
923: SELECT 1

Line 1304: IF NVL (fnd_profile.VALUE ('CN_CHK_WKSHT_STATUS'), 'Y') = 'Y'

1300: RAISE fnd_api.g_exc_error;
1301: END IF;
1302: END IF;
1303: --fix for the Bug 7415126
1304: IF NVL (fnd_profile.VALUE ('CN_CHK_WKSHT_STATUS'), 'Y') = 'Y'
1305: THEN
1306: --Added for R12 payment security check end.
1307: IF l_payrun_status <> 'UNPAID' OR l_worksheet_rec.worksheet_status <> 'UNPAID'
1308: THEN

Line 1441: IF NVL (fnd_profile.VALUE ('CN_CHK_WKSHT_STATUS'), 'Y') = 'Y'

1437: RAISE fnd_api.g_exc_error;
1438: END IF;
1439: END IF;
1440:
1441: IF NVL (fnd_profile.VALUE ('CN_CHK_WKSHT_STATUS'), 'Y') = 'Y'
1442: THEN
1443:
1444: --Added for R12 payment security check end.
1445: --- commented by fred