59: /*PROCEDURE enable_debug IS
60:
61: BEGIN
62:
63: IF FND_PROFILE.value( 'HZ_API_FILE_DEBUG_ON' ) = 'Y' OR
64: FND_PROFILE.value( 'HZ_API_DBMS_DEBUG_ON' ) = 'Y'
65: THEN
66: HZ_UTILITY_V2PUB.enable_debug;
67: G_DEBUG := TRUE;
60:
61: BEGIN
62:
63: IF FND_PROFILE.value( 'HZ_API_FILE_DEBUG_ON' ) = 'Y' OR
64: FND_PROFILE.value( 'HZ_API_DBMS_DEBUG_ON' ) = 'Y'
65: THEN
66: HZ_UTILITY_V2PUB.enable_debug;
67: G_DEBUG := TRUE;
68: END IF;
351: END;
352:
353: -- raise error if the update location profile option is turned off and
354: -- the address has been validated before
355: l_allow_update_std := nvl(fnd_profile.value('HZ_UPDATE_STD_ADDRESS'), 'Y');
356: IF(l_allow_update_std = 'N' AND
357: l_date_validated IS NOT NULL AND
358: l_validation_status_code IS NOT NULL)
359: THEN