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 574: l_allow_update_std := nvl(fnd_profile.value('HZ_UPDATE_STD_ADDRESS'), 'Y');

570:
571: -- ACNG
572: -- raise error if the update location profile option is turned off and
573: -- the address has been validated before
574: l_allow_update_std := nvl(fnd_profile.value('HZ_UPDATE_STD_ADDRESS'), 'Y');
575: IF(l_allow_update_std = 'N' AND
576: l_date_validated IS NOT NULL AND
577: l_validation_status_code IS NOT NULL) THEN
578: FND_MESSAGE.SET_NAME('AR', 'HZ_LOC_NO_UPDATE');

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

1126: RAISE FND_API.G_EXC_ERROR;
1127: END IF;
1128:
1129: -- report error on obsolete columns based on profile
1130: IF NVL(FND_PROFILE.VALUE('HZ_API_ERR_ON_OBSOLETE_COLUMN'), 'Y') = 'Y' THEN
1131: check_obsolete_columns (
1132: p_create_update_flag => 'C',
1133: p_location_rec => l_location_rec,
1134: x_return_status => x_return_status

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

1515: -- IN A NUTSHELL THE DSS CHECK THAT IS NEEDED IN THE LOCATION API, FOR SECURING
1516: -- THE HZ_LOCATIONS ENTITY WAS INADVERTENTLY MISSED DURING THE CODING PHASE OF
1517: -- THE DSS PROJECT
1518:
1519: IF NVL(fnd_profile.value('HZ_DSS_ENABLED'), 'N') = 'Y' THEN
1520:
1521: OPEN c_standalone_location;
1522: FETCH c_standalone_location INTO l_dummy;
1523: IF c_standalone_location%FOUND THEN

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

1672: end if;
1673: end if;
1674:
1675: -- report error on obsolete columns based on profile
1676: IF NVL(FND_PROFILE.VALUE('HZ_API_ERR_ON_OBSOLETE_COLUMN'), 'Y') = 'Y' THEN
1677: check_obsolete_columns (
1678: p_create_update_flag => 'U',
1679: p_location_rec => l_location_rec,
1680: p_old_location_rec => l_old_location_rec,