96: --===============================
97: IF l_debug_level > 0 THEN
98: oe_debug_pub.add('About to set the context');
99: END IF;
100: FND_FLEX_DESCVAL.set_context_value(p_context);
101: IF l_debug_level > 0 THEN
102: oe_debug_pub.add('set the context success');
103: END IF;
104:
109:
110: IF l_debug_level > 0 THEN
111: oe_debug_pub.add('About to set the column values');
112: END IF;
113: fnd_flex_descval.set_column_value('ATTRIBUTE1',p_attribute1);
114: fnd_flex_descval.set_column_value('ATTRIBUTE2',p_attribute2);
115: fnd_flex_descval.set_column_value('ATTRIBUTE3',p_attribute3);
116: fnd_flex_descval.set_column_value('ATTRIBUTE4',p_attribute4);
117: fnd_flex_descval.set_column_value('ATTRIBUTE5',p_attribute5);
110: IF l_debug_level > 0 THEN
111: oe_debug_pub.add('About to set the column values');
112: END IF;
113: fnd_flex_descval.set_column_value('ATTRIBUTE1',p_attribute1);
114: fnd_flex_descval.set_column_value('ATTRIBUTE2',p_attribute2);
115: fnd_flex_descval.set_column_value('ATTRIBUTE3',p_attribute3);
116: fnd_flex_descval.set_column_value('ATTRIBUTE4',p_attribute4);
117: fnd_flex_descval.set_column_value('ATTRIBUTE5',p_attribute5);
118: fnd_flex_descval.set_column_value('ATTRIBUTE6',p_attribute6);
111: oe_debug_pub.add('About to set the column values');
112: END IF;
113: fnd_flex_descval.set_column_value('ATTRIBUTE1',p_attribute1);
114: fnd_flex_descval.set_column_value('ATTRIBUTE2',p_attribute2);
115: fnd_flex_descval.set_column_value('ATTRIBUTE3',p_attribute3);
116: fnd_flex_descval.set_column_value('ATTRIBUTE4',p_attribute4);
117: fnd_flex_descval.set_column_value('ATTRIBUTE5',p_attribute5);
118: fnd_flex_descval.set_column_value('ATTRIBUTE6',p_attribute6);
119: fnd_flex_descval.set_column_value('ATTRIBUTE7',p_attribute7);
112: END IF;
113: fnd_flex_descval.set_column_value('ATTRIBUTE1',p_attribute1);
114: fnd_flex_descval.set_column_value('ATTRIBUTE2',p_attribute2);
115: fnd_flex_descval.set_column_value('ATTRIBUTE3',p_attribute3);
116: fnd_flex_descval.set_column_value('ATTRIBUTE4',p_attribute4);
117: fnd_flex_descval.set_column_value('ATTRIBUTE5',p_attribute5);
118: fnd_flex_descval.set_column_value('ATTRIBUTE6',p_attribute6);
119: fnd_flex_descval.set_column_value('ATTRIBUTE7',p_attribute7);
120: fnd_flex_descval.set_column_value('ATTRIBUTE8',p_attribute8);
113: fnd_flex_descval.set_column_value('ATTRIBUTE1',p_attribute1);
114: fnd_flex_descval.set_column_value('ATTRIBUTE2',p_attribute2);
115: fnd_flex_descval.set_column_value('ATTRIBUTE3',p_attribute3);
116: fnd_flex_descval.set_column_value('ATTRIBUTE4',p_attribute4);
117: fnd_flex_descval.set_column_value('ATTRIBUTE5',p_attribute5);
118: fnd_flex_descval.set_column_value('ATTRIBUTE6',p_attribute6);
119: fnd_flex_descval.set_column_value('ATTRIBUTE7',p_attribute7);
120: fnd_flex_descval.set_column_value('ATTRIBUTE8',p_attribute8);
121: fnd_flex_descval.set_column_value('ATTRIBUTE9',p_attribute9);
114: fnd_flex_descval.set_column_value('ATTRIBUTE2',p_attribute2);
115: fnd_flex_descval.set_column_value('ATTRIBUTE3',p_attribute3);
116: fnd_flex_descval.set_column_value('ATTRIBUTE4',p_attribute4);
117: fnd_flex_descval.set_column_value('ATTRIBUTE5',p_attribute5);
118: fnd_flex_descval.set_column_value('ATTRIBUTE6',p_attribute6);
119: fnd_flex_descval.set_column_value('ATTRIBUTE7',p_attribute7);
120: fnd_flex_descval.set_column_value('ATTRIBUTE8',p_attribute8);
121: fnd_flex_descval.set_column_value('ATTRIBUTE9',p_attribute9);
122: fnd_flex_descval.set_column_value('ATTRIBUTE10',p_attribute10);
115: fnd_flex_descval.set_column_value('ATTRIBUTE3',p_attribute3);
116: fnd_flex_descval.set_column_value('ATTRIBUTE4',p_attribute4);
117: fnd_flex_descval.set_column_value('ATTRIBUTE5',p_attribute5);
118: fnd_flex_descval.set_column_value('ATTRIBUTE6',p_attribute6);
119: fnd_flex_descval.set_column_value('ATTRIBUTE7',p_attribute7);
120: fnd_flex_descval.set_column_value('ATTRIBUTE8',p_attribute8);
121: fnd_flex_descval.set_column_value('ATTRIBUTE9',p_attribute9);
122: fnd_flex_descval.set_column_value('ATTRIBUTE10',p_attribute10);
123: fnd_flex_descval.set_column_value('ATTRIBUTE11',p_attribute11);
116: fnd_flex_descval.set_column_value('ATTRIBUTE4',p_attribute4);
117: fnd_flex_descval.set_column_value('ATTRIBUTE5',p_attribute5);
118: fnd_flex_descval.set_column_value('ATTRIBUTE6',p_attribute6);
119: fnd_flex_descval.set_column_value('ATTRIBUTE7',p_attribute7);
120: fnd_flex_descval.set_column_value('ATTRIBUTE8',p_attribute8);
121: fnd_flex_descval.set_column_value('ATTRIBUTE9',p_attribute9);
122: fnd_flex_descval.set_column_value('ATTRIBUTE10',p_attribute10);
123: fnd_flex_descval.set_column_value('ATTRIBUTE11',p_attribute11);
124: fnd_flex_descval.set_column_value('ATTRIBUTE12',p_attribute12);
117: fnd_flex_descval.set_column_value('ATTRIBUTE5',p_attribute5);
118: fnd_flex_descval.set_column_value('ATTRIBUTE6',p_attribute6);
119: fnd_flex_descval.set_column_value('ATTRIBUTE7',p_attribute7);
120: fnd_flex_descval.set_column_value('ATTRIBUTE8',p_attribute8);
121: fnd_flex_descval.set_column_value('ATTRIBUTE9',p_attribute9);
122: fnd_flex_descval.set_column_value('ATTRIBUTE10',p_attribute10);
123: fnd_flex_descval.set_column_value('ATTRIBUTE11',p_attribute11);
124: fnd_flex_descval.set_column_value('ATTRIBUTE12',p_attribute12);
125: fnd_flex_descval.set_column_value('ATTRIBUTE13',p_attribute13);
118: fnd_flex_descval.set_column_value('ATTRIBUTE6',p_attribute6);
119: fnd_flex_descval.set_column_value('ATTRIBUTE7',p_attribute7);
120: fnd_flex_descval.set_column_value('ATTRIBUTE8',p_attribute8);
121: fnd_flex_descval.set_column_value('ATTRIBUTE9',p_attribute9);
122: fnd_flex_descval.set_column_value('ATTRIBUTE10',p_attribute10);
123: fnd_flex_descval.set_column_value('ATTRIBUTE11',p_attribute11);
124: fnd_flex_descval.set_column_value('ATTRIBUTE12',p_attribute12);
125: fnd_flex_descval.set_column_value('ATTRIBUTE13',p_attribute13);
126: fnd_flex_descval.set_column_value('ATTRIBUTE14',p_attribute14);
119: fnd_flex_descval.set_column_value('ATTRIBUTE7',p_attribute7);
120: fnd_flex_descval.set_column_value('ATTRIBUTE8',p_attribute8);
121: fnd_flex_descval.set_column_value('ATTRIBUTE9',p_attribute9);
122: fnd_flex_descval.set_column_value('ATTRIBUTE10',p_attribute10);
123: fnd_flex_descval.set_column_value('ATTRIBUTE11',p_attribute11);
124: fnd_flex_descval.set_column_value('ATTRIBUTE12',p_attribute12);
125: fnd_flex_descval.set_column_value('ATTRIBUTE13',p_attribute13);
126: fnd_flex_descval.set_column_value('ATTRIBUTE14',p_attribute14);
127: fnd_flex_descval.set_column_value('ATTRIBUTE15',p_attribute15);
120: fnd_flex_descval.set_column_value('ATTRIBUTE8',p_attribute8);
121: fnd_flex_descval.set_column_value('ATTRIBUTE9',p_attribute9);
122: fnd_flex_descval.set_column_value('ATTRIBUTE10',p_attribute10);
123: fnd_flex_descval.set_column_value('ATTRIBUTE11',p_attribute11);
124: fnd_flex_descval.set_column_value('ATTRIBUTE12',p_attribute12);
125: fnd_flex_descval.set_column_value('ATTRIBUTE13',p_attribute13);
126: fnd_flex_descval.set_column_value('ATTRIBUTE14',p_attribute14);
127: fnd_flex_descval.set_column_value('ATTRIBUTE15',p_attribute15);
128: fnd_flex_descval.set_column_value('ATTRIBUTE16',p_attribute16);
121: fnd_flex_descval.set_column_value('ATTRIBUTE9',p_attribute9);
122: fnd_flex_descval.set_column_value('ATTRIBUTE10',p_attribute10);
123: fnd_flex_descval.set_column_value('ATTRIBUTE11',p_attribute11);
124: fnd_flex_descval.set_column_value('ATTRIBUTE12',p_attribute12);
125: fnd_flex_descval.set_column_value('ATTRIBUTE13',p_attribute13);
126: fnd_flex_descval.set_column_value('ATTRIBUTE14',p_attribute14);
127: fnd_flex_descval.set_column_value('ATTRIBUTE15',p_attribute15);
128: fnd_flex_descval.set_column_value('ATTRIBUTE16',p_attribute16);
129: fnd_flex_descval.set_column_value('ATTRIBUTE17',p_attribute17);
122: fnd_flex_descval.set_column_value('ATTRIBUTE10',p_attribute10);
123: fnd_flex_descval.set_column_value('ATTRIBUTE11',p_attribute11);
124: fnd_flex_descval.set_column_value('ATTRIBUTE12',p_attribute12);
125: fnd_flex_descval.set_column_value('ATTRIBUTE13',p_attribute13);
126: fnd_flex_descval.set_column_value('ATTRIBUTE14',p_attribute14);
127: fnd_flex_descval.set_column_value('ATTRIBUTE15',p_attribute15);
128: fnd_flex_descval.set_column_value('ATTRIBUTE16',p_attribute16);
129: fnd_flex_descval.set_column_value('ATTRIBUTE17',p_attribute17);
130: fnd_flex_descval.set_column_value('ATTRIBUTE18',p_attribute18);
123: fnd_flex_descval.set_column_value('ATTRIBUTE11',p_attribute11);
124: fnd_flex_descval.set_column_value('ATTRIBUTE12',p_attribute12);
125: fnd_flex_descval.set_column_value('ATTRIBUTE13',p_attribute13);
126: fnd_flex_descval.set_column_value('ATTRIBUTE14',p_attribute14);
127: fnd_flex_descval.set_column_value('ATTRIBUTE15',p_attribute15);
128: fnd_flex_descval.set_column_value('ATTRIBUTE16',p_attribute16);
129: fnd_flex_descval.set_column_value('ATTRIBUTE17',p_attribute17);
130: fnd_flex_descval.set_column_value('ATTRIBUTE18',p_attribute18);
131: fnd_flex_descval.set_column_value('ATTRIBUTE19',p_attribute19);
124: fnd_flex_descval.set_column_value('ATTRIBUTE12',p_attribute12);
125: fnd_flex_descval.set_column_value('ATTRIBUTE13',p_attribute13);
126: fnd_flex_descval.set_column_value('ATTRIBUTE14',p_attribute14);
127: fnd_flex_descval.set_column_value('ATTRIBUTE15',p_attribute15);
128: fnd_flex_descval.set_column_value('ATTRIBUTE16',p_attribute16);
129: fnd_flex_descval.set_column_value('ATTRIBUTE17',p_attribute17);
130: fnd_flex_descval.set_column_value('ATTRIBUTE18',p_attribute18);
131: fnd_flex_descval.set_column_value('ATTRIBUTE19',p_attribute19);
132: fnd_flex_descval.set_column_value('ATTRIBUTE20',p_attribute20);
125: fnd_flex_descval.set_column_value('ATTRIBUTE13',p_attribute13);
126: fnd_flex_descval.set_column_value('ATTRIBUTE14',p_attribute14);
127: fnd_flex_descval.set_column_value('ATTRIBUTE15',p_attribute15);
128: fnd_flex_descval.set_column_value('ATTRIBUTE16',p_attribute16);
129: fnd_flex_descval.set_column_value('ATTRIBUTE17',p_attribute17);
130: fnd_flex_descval.set_column_value('ATTRIBUTE18',p_attribute18);
131: fnd_flex_descval.set_column_value('ATTRIBUTE19',p_attribute19);
132: fnd_flex_descval.set_column_value('ATTRIBUTE20',p_attribute20);
133: IF l_debug_level > 0 THEN
126: fnd_flex_descval.set_column_value('ATTRIBUTE14',p_attribute14);
127: fnd_flex_descval.set_column_value('ATTRIBUTE15',p_attribute15);
128: fnd_flex_descval.set_column_value('ATTRIBUTE16',p_attribute16);
129: fnd_flex_descval.set_column_value('ATTRIBUTE17',p_attribute17);
130: fnd_flex_descval.set_column_value('ATTRIBUTE18',p_attribute18);
131: fnd_flex_descval.set_column_value('ATTRIBUTE19',p_attribute19);
132: fnd_flex_descval.set_column_value('ATTRIBUTE20',p_attribute20);
133: IF l_debug_level > 0 THEN
134: oe_debug_pub.add('set the column values - success');
127: fnd_flex_descval.set_column_value('ATTRIBUTE15',p_attribute15);
128: fnd_flex_descval.set_column_value('ATTRIBUTE16',p_attribute16);
129: fnd_flex_descval.set_column_value('ATTRIBUTE17',p_attribute17);
130: fnd_flex_descval.set_column_value('ATTRIBUTE18',p_attribute18);
131: fnd_flex_descval.set_column_value('ATTRIBUTE19',p_attribute19);
132: fnd_flex_descval.set_column_value('ATTRIBUTE20',p_attribute20);
133: IF l_debug_level > 0 THEN
134: oe_debug_pub.add('set the column values - success');
135: END IF;
128: fnd_flex_descval.set_column_value('ATTRIBUTE16',p_attribute16);
129: fnd_flex_descval.set_column_value('ATTRIBUTE17',p_attribute17);
130: fnd_flex_descval.set_column_value('ATTRIBUTE18',p_attribute18);
131: fnd_flex_descval.set_column_value('ATTRIBUTE19',p_attribute19);
132: fnd_flex_descval.set_column_value('ATTRIBUTE20',p_attribute20);
133: IF l_debug_level > 0 THEN
134: oe_debug_pub.add('set the column values - success');
135: END IF;
136:
135: END IF;
136:
137: IF l_debug_level > 0 THEN
138: oe_debug_pub.add('***********************************************');
139: oe_debug_pub.add('Calling FND_FLEX_DESCVAL.validate_desccols with:');
140: oe_debug_pub.add('appl_short_name = ' || p_appl_short_name);
141: oe_debug_pub.add('desc_flex_name = ' || p_desc_flex_name);
142: oe_debug_pub.add('values_or_ids = ' || p_values_or_ids);
143: oe_debug_pub.add('validation_date = ' || p_validation_date);
143: oe_debug_pub.add('validation_date = ' || p_validation_date);
144: oe_debug_pub.add('***********************************************');
145: END IF;
146:
147: g_valid_structure := FND_FLEX_DESCVAL.validate_desccols(
148: p_appl_short_name,
149: p_desc_flex_name,
150: p_values_or_ids,
151: p_validation_date);
171: IF l_debug_level > 0 THEN
172: oe_debug_pub.add('segment number = '||p_segment_number);
173: END IF;
174:
175: l_val_desc := FND_FLEX_DESCVAL.segment_description(p_segment_number);
176:
177: IF l_debug_level > 0 THEN
178: oe_debug_pub.add('description = '||l_val_desc);
179: END IF;
179: END IF;
180:
181: ELSIF (p_value = 'V' AND g_valid_structure) THEN
182:
183: l_val_desc := FND_FLEX_DESCVAL.segment_value(p_segment_number);
184:
185: IF l_debug_level > 0 THEN
186: oe_debug_pub.add('value = '||l_val_desc);
187: END IF;