2962: l_r VARCHAR2(2000);
2963: BEGIN
2964:
2965: -- DEFINE ID COLUMNS
2966: fnd_flex_descval.set_context_value(p_attribute_category);
2967: fnd_flex_descval.set_column_value('ATTRIBUTE1', p_attribute1);
2968: fnd_flex_descval.set_column_value('ATTRIBUTE2', p_attribute2);
2969: fnd_flex_descval.set_column_value('ATTRIBUTE3', p_attribute3);
2970: fnd_flex_descval.set_column_value('ATTRIBUTE4', p_attribute4);
2963: BEGIN
2964:
2965: -- DEFINE ID COLUMNS
2966: fnd_flex_descval.set_context_value(p_attribute_category);
2967: fnd_flex_descval.set_column_value('ATTRIBUTE1', p_attribute1);
2968: fnd_flex_descval.set_column_value('ATTRIBUTE2', p_attribute2);
2969: fnd_flex_descval.set_column_value('ATTRIBUTE3', p_attribute3);
2970: fnd_flex_descval.set_column_value('ATTRIBUTE4', p_attribute4);
2971: fnd_flex_descval.set_column_value('ATTRIBUTE5', p_attribute5);
2964:
2965: -- DEFINE ID COLUMNS
2966: fnd_flex_descval.set_context_value(p_attribute_category);
2967: fnd_flex_descval.set_column_value('ATTRIBUTE1', p_attribute1);
2968: fnd_flex_descval.set_column_value('ATTRIBUTE2', p_attribute2);
2969: fnd_flex_descval.set_column_value('ATTRIBUTE3', p_attribute3);
2970: fnd_flex_descval.set_column_value('ATTRIBUTE4', p_attribute4);
2971: fnd_flex_descval.set_column_value('ATTRIBUTE5', p_attribute5);
2972: fnd_flex_descval.set_column_value('ATTRIBUTE6', p_attribute6);
2965: -- DEFINE ID COLUMNS
2966: fnd_flex_descval.set_context_value(p_attribute_category);
2967: fnd_flex_descval.set_column_value('ATTRIBUTE1', p_attribute1);
2968: fnd_flex_descval.set_column_value('ATTRIBUTE2', p_attribute2);
2969: fnd_flex_descval.set_column_value('ATTRIBUTE3', p_attribute3);
2970: fnd_flex_descval.set_column_value('ATTRIBUTE4', p_attribute4);
2971: fnd_flex_descval.set_column_value('ATTRIBUTE5', p_attribute5);
2972: fnd_flex_descval.set_column_value('ATTRIBUTE6', p_attribute6);
2973: fnd_flex_descval.set_column_value('ATTRIBUTE7', p_attribute7);
2966: fnd_flex_descval.set_context_value(p_attribute_category);
2967: fnd_flex_descval.set_column_value('ATTRIBUTE1', p_attribute1);
2968: fnd_flex_descval.set_column_value('ATTRIBUTE2', p_attribute2);
2969: fnd_flex_descval.set_column_value('ATTRIBUTE3', p_attribute3);
2970: fnd_flex_descval.set_column_value('ATTRIBUTE4', p_attribute4);
2971: fnd_flex_descval.set_column_value('ATTRIBUTE5', p_attribute5);
2972: fnd_flex_descval.set_column_value('ATTRIBUTE6', p_attribute6);
2973: fnd_flex_descval.set_column_value('ATTRIBUTE7', p_attribute7);
2974: fnd_flex_descval.set_column_value('ATTRIBUTE8', p_attribute8);
2967: fnd_flex_descval.set_column_value('ATTRIBUTE1', p_attribute1);
2968: fnd_flex_descval.set_column_value('ATTRIBUTE2', p_attribute2);
2969: fnd_flex_descval.set_column_value('ATTRIBUTE3', p_attribute3);
2970: fnd_flex_descval.set_column_value('ATTRIBUTE4', p_attribute4);
2971: fnd_flex_descval.set_column_value('ATTRIBUTE5', p_attribute5);
2972: fnd_flex_descval.set_column_value('ATTRIBUTE6', p_attribute6);
2973: fnd_flex_descval.set_column_value('ATTRIBUTE7', p_attribute7);
2974: fnd_flex_descval.set_column_value('ATTRIBUTE8', p_attribute8);
2975: fnd_flex_descval.set_column_value('ATTRIBUTE9', p_attribute9);
2968: fnd_flex_descval.set_column_value('ATTRIBUTE2', p_attribute2);
2969: fnd_flex_descval.set_column_value('ATTRIBUTE3', p_attribute3);
2970: fnd_flex_descval.set_column_value('ATTRIBUTE4', p_attribute4);
2971: fnd_flex_descval.set_column_value('ATTRIBUTE5', p_attribute5);
2972: fnd_flex_descval.set_column_value('ATTRIBUTE6', p_attribute6);
2973: fnd_flex_descval.set_column_value('ATTRIBUTE7', p_attribute7);
2974: fnd_flex_descval.set_column_value('ATTRIBUTE8', p_attribute8);
2975: fnd_flex_descval.set_column_value('ATTRIBUTE9', p_attribute9);
2976: fnd_flex_descval.set_column_value('ATTRIBUTE10', p_attribute10);
2969: fnd_flex_descval.set_column_value('ATTRIBUTE3', p_attribute3);
2970: fnd_flex_descval.set_column_value('ATTRIBUTE4', p_attribute4);
2971: fnd_flex_descval.set_column_value('ATTRIBUTE5', p_attribute5);
2972: fnd_flex_descval.set_column_value('ATTRIBUTE6', p_attribute6);
2973: fnd_flex_descval.set_column_value('ATTRIBUTE7', p_attribute7);
2974: fnd_flex_descval.set_column_value('ATTRIBUTE8', p_attribute8);
2975: fnd_flex_descval.set_column_value('ATTRIBUTE9', p_attribute9);
2976: fnd_flex_descval.set_column_value('ATTRIBUTE10', p_attribute10);
2977:
2970: fnd_flex_descval.set_column_value('ATTRIBUTE4', p_attribute4);
2971: fnd_flex_descval.set_column_value('ATTRIBUTE5', p_attribute5);
2972: fnd_flex_descval.set_column_value('ATTRIBUTE6', p_attribute6);
2973: fnd_flex_descval.set_column_value('ATTRIBUTE7', p_attribute7);
2974: fnd_flex_descval.set_column_value('ATTRIBUTE8', p_attribute8);
2975: fnd_flex_descval.set_column_value('ATTRIBUTE9', p_attribute9);
2976: fnd_flex_descval.set_column_value('ATTRIBUTE10', p_attribute10);
2977:
2978: -- VALIDATE
2971: fnd_flex_descval.set_column_value('ATTRIBUTE5', p_attribute5);
2972: fnd_flex_descval.set_column_value('ATTRIBUTE6', p_attribute6);
2973: fnd_flex_descval.set_column_value('ATTRIBUTE7', p_attribute7);
2974: fnd_flex_descval.set_column_value('ATTRIBUTE8', p_attribute8);
2975: fnd_flex_descval.set_column_value('ATTRIBUTE9', p_attribute9);
2976: fnd_flex_descval.set_column_value('ATTRIBUTE10', p_attribute10);
2977:
2978: -- VALIDATE
2979: IF (fnd_flex_descval.validate_desccols( 'PA',p_desc_flex_name)) then
2972: fnd_flex_descval.set_column_value('ATTRIBUTE6', p_attribute6);
2973: fnd_flex_descval.set_column_value('ATTRIBUTE7', p_attribute7);
2974: fnd_flex_descval.set_column_value('ATTRIBUTE8', p_attribute8);
2975: fnd_flex_descval.set_column_value('ATTRIBUTE9', p_attribute9);
2976: fnd_flex_descval.set_column_value('ATTRIBUTE10', p_attribute10);
2977:
2978: -- VALIDATE
2979: IF (fnd_flex_descval.validate_desccols( 'PA',p_desc_flex_name)) then
2980: p_RETURN_msg := 'VALID: ' || fnd_flex_descval.concatenated_ids;
2975: fnd_flex_descval.set_column_value('ATTRIBUTE9', p_attribute9);
2976: fnd_flex_descval.set_column_value('ATTRIBUTE10', p_attribute10);
2977:
2978: -- VALIDATE
2979: IF (fnd_flex_descval.validate_desccols( 'PA',p_desc_flex_name)) then
2980: p_RETURN_msg := 'VALID: ' || fnd_flex_descval.concatenated_ids;
2981: p_valid_status := 'Y';
2982: ELSE
2983: p_RETURN_msg := 'INVALID: ' || fnd_flex_descval.error_message;
2976: fnd_flex_descval.set_column_value('ATTRIBUTE10', p_attribute10);
2977:
2978: -- VALIDATE
2979: IF (fnd_flex_descval.validate_desccols( 'PA',p_desc_flex_name)) then
2980: p_RETURN_msg := 'VALID: ' || fnd_flex_descval.concatenated_ids;
2981: p_valid_status := 'Y';
2982: ELSE
2983: p_RETURN_msg := 'INVALID: ' || fnd_flex_descval.error_message;
2984: p_valid_status := 'N';
2979: IF (fnd_flex_descval.validate_desccols( 'PA',p_desc_flex_name)) then
2980: p_RETURN_msg := 'VALID: ' || fnd_flex_descval.concatenated_ids;
2981: p_valid_status := 'Y';
2982: ELSE
2983: p_RETURN_msg := 'INVALID: ' || fnd_flex_descval.error_message;
2984: p_valid_status := 'N';
2985: END IF;
2986:
2987: --handling exceptions