APPS.HZ_LOCATION_V2PUB dependencies on FND_PROFILE

Line 91: IF fnd_profile.value('HZ_API_FILE_DEBUG_ON') = 'Y' OR

87: BEGIN
88: g_debug_count := g_debug_count + 1;
89:
90: IF g_debug_count = 1 THEN
91: IF fnd_profile.value('HZ_API_FILE_DEBUG_ON') = 'Y' OR
92: fnd_profile.value('HZ_API_DBMS_DEBUG_ON') = 'Y'
93: THEN
94: hz_utility_v2pub.enable_debug;
95: g_debug := TRUE;

Line 92: fnd_profile.value('HZ_API_DBMS_DEBUG_ON') = 'Y'

88: g_debug_count := g_debug_count + 1;
89:
90: IF g_debug_count = 1 THEN
91: IF fnd_profile.value('HZ_API_FILE_DEBUG_ON') = 'Y' OR
92: fnd_profile.value('HZ_API_DBMS_DEBUG_ON') = 'Y'
93: THEN
94: hz_utility_v2pub.enable_debug;
95: g_debug := TRUE;
96: END IF;

Line 561: l_allow_update_std := nvl(fnd_profile.value('HZ_UPDATE_STD_ADDRESS'), 'Y');

557:
558: -- ACNG
559: -- raise error if the update location profile option is turned off and
560: -- the address has been validated before
561: l_allow_update_std := nvl(fnd_profile.value('HZ_UPDATE_STD_ADDRESS'), 'Y');
562: IF(l_allow_update_std = 'N' AND
563: l_date_validated IS NOT NULL AND
564: l_validation_status_code IS NOT NULL) THEN
565: FND_MESSAGE.SET_NAME('AR', 'HZ_LOC_NO_UPDATE');

Line 1117: IF NVL(FND_PROFILE.VALUE('HZ_API_ERR_ON_OBSOLETE_COLUMN'), 'Y') = 'Y' THEN

1113: RAISE FND_API.G_EXC_ERROR;
1114: END IF;
1115:
1116: -- report error on obsolete columns based on profile
1117: IF NVL(FND_PROFILE.VALUE('HZ_API_ERR_ON_OBSOLETE_COLUMN'), 'Y') = 'Y' THEN
1118: check_obsolete_columns (
1119: p_create_update_flag => 'C',
1120: p_location_rec => l_location_rec,
1121: x_return_status => x_return_status

Line 1506: IF NVL(fnd_profile.value('HZ_DSS_ENABLED'), 'N') = 'Y' THEN

1502: -- IN A NUTSHELL THE DSS CHECK THAT IS NEEDED IN THE LOCATION API, FOR SECURING
1503: -- THE HZ_LOCATIONS ENTITY WAS INADVERTENTLY MISSED DURING THE CODING PHASE OF
1504: -- THE DSS PROJECT
1505:
1506: IF NVL(fnd_profile.value('HZ_DSS_ENABLED'), 'N') = 'Y' THEN
1507:
1508: OPEN c_standalone_location;
1509: FETCH c_standalone_location INTO l_dummy;
1510: IF c_standalone_location%FOUND THEN

Line 1644: IF NVL(FND_PROFILE.VALUE('HZ_API_ERR_ON_OBSOLETE_COLUMN'), 'Y') = 'Y' THEN

1640: end if;
1641: end if;
1642:
1643: -- report error on obsolete columns based on profile
1644: IF NVL(FND_PROFILE.VALUE('HZ_API_ERR_ON_OBSOLETE_COLUMN'), 'Y') = 'Y' THEN
1645: check_obsolete_columns (
1646: p_create_update_flag => 'U',
1647: p_location_rec => l_location_rec,
1648: p_old_location_rec => l_old_location_rec,