572: EXIT WHEN default_value_csr%NOTFOUND;
573: l_count := l_count + 1;
574: end loop;
575: if( l_count = 0 ) then
576: FND_MESSAGE.SET_NAME('FND', 'FLEX-DFLT NO SQL ROWS');
577: FND_MESSAGE.SET_TOKEN('SEGMENT_NAME', v_segments.segment_name(j));
578: FND_MESSAGE.SET_TOKEN('APPLICATION_SHORT_NAME', 'INV');
579: FND_MESSAGE.SET_TOKEN('FLEXFIELD_NAME', p_attributes_name);
580: FND_MESSAGE.SET_TOKEN('SQL_STRING', v_segments.default_value(j));
573: l_count := l_count + 1;
574: end loop;
575: if( l_count = 0 ) then
576: FND_MESSAGE.SET_NAME('FND', 'FLEX-DFLT NO SQL ROWS');
577: FND_MESSAGE.SET_TOKEN('SEGMENT_NAME', v_segments.segment_name(j));
578: FND_MESSAGE.SET_TOKEN('APPLICATION_SHORT_NAME', 'INV');
579: FND_MESSAGE.SET_TOKEN('FLEXFIELD_NAME', p_attributes_name);
580: FND_MESSAGE.SET_TOKEN('SQL_STRING', v_segments.default_value(j));
581: FND_MSG_PUB.ADD;
574: end loop;
575: if( l_count = 0 ) then
576: FND_MESSAGE.SET_NAME('FND', 'FLEX-DFLT NO SQL ROWS');
577: FND_MESSAGE.SET_TOKEN('SEGMENT_NAME', v_segments.segment_name(j));
578: FND_MESSAGE.SET_TOKEN('APPLICATION_SHORT_NAME', 'INV');
579: FND_MESSAGE.SET_TOKEN('FLEXFIELD_NAME', p_attributes_name);
580: FND_MESSAGE.SET_TOKEN('SQL_STRING', v_segments.default_value(j));
581: FND_MSG_PUB.ADD;
582: elsif( l_count > 1 ) then
575: if( l_count = 0 ) then
576: FND_MESSAGE.SET_NAME('FND', 'FLEX-DFLT NO SQL ROWS');
577: FND_MESSAGE.SET_TOKEN('SEGMENT_NAME', v_segments.segment_name(j));
578: FND_MESSAGE.SET_TOKEN('APPLICATION_SHORT_NAME', 'INV');
579: FND_MESSAGE.SET_TOKEN('FLEXFIELD_NAME', p_attributes_name);
580: FND_MESSAGE.SET_TOKEN('SQL_STRING', v_segments.default_value(j));
581: FND_MSG_PUB.ADD;
582: elsif( l_count > 1 ) then
583: FND_MESSAGE.SET_NAME('FND', 'FLEX-DFLT MULTIPLE SQL ROWS');
576: FND_MESSAGE.SET_NAME('FND', 'FLEX-DFLT NO SQL ROWS');
577: FND_MESSAGE.SET_TOKEN('SEGMENT_NAME', v_segments.segment_name(j));
578: FND_MESSAGE.SET_TOKEN('APPLICATION_SHORT_NAME', 'INV');
579: FND_MESSAGE.SET_TOKEN('FLEXFIELD_NAME', p_attributes_name);
580: FND_MESSAGE.SET_TOKEN('SQL_STRING', v_segments.default_value(j));
581: FND_MSG_PUB.ADD;
582: elsif( l_count > 1 ) then
583: FND_MESSAGE.SET_NAME('FND', 'FLEX-DFLT MULTIPLE SQL ROWS');
584: FND_MESSAGE.SET_TOKEN('SQLSTR', v_segments.default_value(j));
579: FND_MESSAGE.SET_TOKEN('FLEXFIELD_NAME', p_attributes_name);
580: FND_MESSAGE.SET_TOKEN('SQL_STRING', v_segments.default_value(j));
581: FND_MSG_PUB.ADD;
582: elsif( l_count > 1 ) then
583: FND_MESSAGE.SET_NAME('FND', 'FLEX-DFLT MULTIPLE SQL ROWS');
584: FND_MESSAGE.SET_TOKEN('SQLSTR', v_segments.default_value(j));
585: end if;
586: else
587: x_attributes_default(v_rec_index).COLUMN_VALUE := v_segments.default_value(j);
580: FND_MESSAGE.SET_TOKEN('SQL_STRING', v_segments.default_value(j));
581: FND_MSG_PUB.ADD;
582: elsif( l_count > 1 ) then
583: FND_MESSAGE.SET_NAME('FND', 'FLEX-DFLT MULTIPLE SQL ROWS');
584: FND_MESSAGE.SET_TOKEN('SQLSTR', v_segments.default_value(j));
585: end if;
586: else
587: x_attributes_default(v_rec_index).COLUMN_VALUE := v_segments.default_value(j);
588: end if;
621: EXIT WHEN default_value_csr%NOTFOUND;
622: l_count := l_count + 1;
623: end loop;
624: if( l_count = 0 ) then
625: FND_MESSAGE.SET_NAME('FND', 'FLEX-DFLT NO SQL ROWS');
626: FND_MESSAGE.SET_TOKEN('SEGMENT_NAME', v_segments.segment_name(j));
627: FND_MESSAGE.SET_TOKEN('APPLICATION_SHORT_NAME', 'INV');
628: FND_MESSAGE.SET_TOKEN('FLEXFIELD_NAME', p_attributes_name);
629: FND_MESSAGE.SET_TOKEN('SQL_STRING', v_segments.default_value(j));
622: l_count := l_count + 1;
623: end loop;
624: if( l_count = 0 ) then
625: FND_MESSAGE.SET_NAME('FND', 'FLEX-DFLT NO SQL ROWS');
626: FND_MESSAGE.SET_TOKEN('SEGMENT_NAME', v_segments.segment_name(j));
627: FND_MESSAGE.SET_TOKEN('APPLICATION_SHORT_NAME', 'INV');
628: FND_MESSAGE.SET_TOKEN('FLEXFIELD_NAME', p_attributes_name);
629: FND_MESSAGE.SET_TOKEN('SQL_STRING', v_segments.default_value(j));
630: FND_MSG_PUB.ADD;
623: end loop;
624: if( l_count = 0 ) then
625: FND_MESSAGE.SET_NAME('FND', 'FLEX-DFLT NO SQL ROWS');
626: FND_MESSAGE.SET_TOKEN('SEGMENT_NAME', v_segments.segment_name(j));
627: FND_MESSAGE.SET_TOKEN('APPLICATION_SHORT_NAME', 'INV');
628: FND_MESSAGE.SET_TOKEN('FLEXFIELD_NAME', p_attributes_name);
629: FND_MESSAGE.SET_TOKEN('SQL_STRING', v_segments.default_value(j));
630: FND_MSG_PUB.ADD;
631: elsif( l_count > 1 ) then
624: if( l_count = 0 ) then
625: FND_MESSAGE.SET_NAME('FND', 'FLEX-DFLT NO SQL ROWS');
626: FND_MESSAGE.SET_TOKEN('SEGMENT_NAME', v_segments.segment_name(j));
627: FND_MESSAGE.SET_TOKEN('APPLICATION_SHORT_NAME', 'INV');
628: FND_MESSAGE.SET_TOKEN('FLEXFIELD_NAME', p_attributes_name);
629: FND_MESSAGE.SET_TOKEN('SQL_STRING', v_segments.default_value(j));
630: FND_MSG_PUB.ADD;
631: elsif( l_count > 1 ) then
632: FND_MESSAGE.SET_NAME('FND', 'FLEX-DFLT MULTIPLE SQL ROWS');
625: FND_MESSAGE.SET_NAME('FND', 'FLEX-DFLT NO SQL ROWS');
626: FND_MESSAGE.SET_TOKEN('SEGMENT_NAME', v_segments.segment_name(j));
627: FND_MESSAGE.SET_TOKEN('APPLICATION_SHORT_NAME', 'INV');
628: FND_MESSAGE.SET_TOKEN('FLEXFIELD_NAME', p_attributes_name);
629: FND_MESSAGE.SET_TOKEN('SQL_STRING', v_segments.default_value(j));
630: FND_MSG_PUB.ADD;
631: elsif( l_count > 1 ) then
632: FND_MESSAGE.SET_NAME('FND', 'FLEX-DFLT MULTIPLE SQL ROWS');
633: FND_MESSAGE.SET_TOKEN('SQLSTR', v_segments.default_value(j));
628: FND_MESSAGE.SET_TOKEN('FLEXFIELD_NAME', p_attributes_name);
629: FND_MESSAGE.SET_TOKEN('SQL_STRING', v_segments.default_value(j));
630: FND_MSG_PUB.ADD;
631: elsif( l_count > 1 ) then
632: FND_MESSAGE.SET_NAME('FND', 'FLEX-DFLT MULTIPLE SQL ROWS');
633: FND_MESSAGE.SET_TOKEN('SQLSTR', v_segments.default_value(j));
634: end if;
635: else
636: x_attributes_default(v_rec_index).COLUMN_VALUE := v_segments.default_value(j);
629: FND_MESSAGE.SET_TOKEN('SQL_STRING', v_segments.default_value(j));
630: FND_MSG_PUB.ADD;
631: elsif( l_count > 1 ) then
632: FND_MESSAGE.SET_NAME('FND', 'FLEX-DFLT MULTIPLE SQL ROWS');
633: FND_MESSAGE.SET_TOKEN('SQLSTR', v_segments.default_value(j));
634: end if;
635: else
636: x_attributes_default(v_rec_index).COLUMN_VALUE := v_segments.default_value(j);
637: end if;
644: IF(x_attributes_default(v_rec_index).COLUMN_VALUE IS NULL) THEN
645: IF (l_debug = 1) THEN
646: inv_log_util.trace('error inv_lot_sel_default_required', 'LOTSERATTR');
647: END IF;
648: fnd_message.set_name('INV', 'INV_LOT_SEL_DEFAULT_REQUIRED');
649: fnd_message.set_token('ATTRNAME',p_attributes_name);
650: fnd_message.set_token('CONTEXTCODE', v_contexts.context_code(i));
651: fnd_message.set_token('SEGMENT', v_segments.application_column_name(j));
652: fnd_msg_pub.add;
645: IF (l_debug = 1) THEN
646: inv_log_util.trace('error inv_lot_sel_default_required', 'LOTSERATTR');
647: END IF;
648: fnd_message.set_name('INV', 'INV_LOT_SEL_DEFAULT_REQUIRED');
649: fnd_message.set_token('ATTRNAME',p_attributes_name);
650: fnd_message.set_token('CONTEXTCODE', v_contexts.context_code(i));
651: fnd_message.set_token('SEGMENT', v_segments.application_column_name(j));
652: fnd_msg_pub.add;
653: END IF;
646: inv_log_util.trace('error inv_lot_sel_default_required', 'LOTSERATTR');
647: END IF;
648: fnd_message.set_name('INV', 'INV_LOT_SEL_DEFAULT_REQUIRED');
649: fnd_message.set_token('ATTRNAME',p_attributes_name);
650: fnd_message.set_token('CONTEXTCODE', v_contexts.context_code(i));
651: fnd_message.set_token('SEGMENT', v_segments.application_column_name(j));
652: fnd_msg_pub.add;
653: END IF;
654: END IF;
647: END IF;
648: fnd_message.set_name('INV', 'INV_LOT_SEL_DEFAULT_REQUIRED');
649: fnd_message.set_token('ATTRNAME',p_attributes_name);
650: fnd_message.set_token('CONTEXTCODE', v_contexts.context_code(i));
651: fnd_message.set_token('SEGMENT', v_segments.application_column_name(j));
652: fnd_msg_pub.add;
653: END IF;
654: END IF;
655: END IF; -- segment is enabled
1885: x_concatenated_values := fnd_flex_descval.concatenated_values;
1886: ELSE
1887:
1888: x_concatenated_values := null;
1889: FND_MESSAGE.SET_NAME('INV', 'INV_FND_GENERIC_MSG');
1890: FND_MESSAGE.SET_TOKEN('MSG', fnd_flex_descval.error_message);
1891: FND_MSG_PUB.ADD;
1892: raise fnd_api.g_exc_unexpected_error;
1893: END IF;
1886: ELSE
1887:
1888: x_concatenated_values := null;
1889: FND_MESSAGE.SET_NAME('INV', 'INV_FND_GENERIC_MSG');
1890: FND_MESSAGE.SET_TOKEN('MSG', fnd_flex_descval.error_message);
1891: FND_MSG_PUB.ADD;
1892: raise fnd_api.g_exc_unexpected_error;
1893: END IF;
1894: debug('after getting x_concatenated_values ' || x_concatenated_values, 'GET_INV_SERIAL_ATTR', 9);