2027: --
2028: -- The lengthb() function replaced the length() function to handle
2029: -- multibyte characters appropriately.
2030: IF lengthb(x_value) > 240 THEN
2031: fnd_message.set_name('FND', 'FND_PROFILE_OPTION_VAL_TOO_LRG');
2032: fnd_message.set_token('PROFILE_OPTION_NAME', profNameUpper);
2033: fnd_message.set_token('PROFILE_OPTION_VALUE', x_value);
2034: RETURN FALSE;
2035: END IF;
2028: -- The lengthb() function replaced the length() function to handle
2029: -- multibyte characters appropriately.
2030: IF lengthb(x_value) > 240 THEN
2031: fnd_message.set_name('FND', 'FND_PROFILE_OPTION_VAL_TOO_LRG');
2032: fnd_message.set_token('PROFILE_OPTION_NAME', profNameUpper);
2033: fnd_message.set_token('PROFILE_OPTION_VALUE', x_value);
2034: RETURN FALSE;
2035: END IF;
2036:
2029: -- multibyte characters appropriately.
2030: IF lengthb(x_value) > 240 THEN
2031: fnd_message.set_name('FND', 'FND_PROFILE_OPTION_VAL_TOO_LRG');
2032: fnd_message.set_token('PROFILE_OPTION_NAME', profNameUpper);
2033: fnd_message.set_token('PROFILE_OPTION_VALUE', x_value);
2034: RETURN FALSE;
2035: END IF;
2036:
2037: IF (profileRowId IS NULL) THEN