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;
349: END;
350:
351: -- raise error if the update location profile option is turned off and
352: -- the address has been validated before
353: l_allow_update_std := nvl(fnd_profile.value('HZ_UPDATE_STD_ADDRESS'), 'Y');
354: IF(l_allow_update_std = 'N' AND
355: l_date_validated IS NOT NULL AND
356: l_validation_status_code IS NOT NULL)
357: THEN