DBA Data[Home] [Help]

APPS.INV_LOT_SEL_ATTR dependencies on FND_MESSAGE

Line 576: FND_MESSAGE.SET_NAME('FND', 'FLEX-DFLT NO SQL ROWS');

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));

Line 577: FND_MESSAGE.SET_TOKEN('SEGMENT_NAME', v_segments.segment_name(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;

Line 578: FND_MESSAGE.SET_TOKEN('APPLICATION_SHORT_NAME', 'INV');

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

Line 579: FND_MESSAGE.SET_TOKEN('FLEXFIELD_NAME', p_attributes_name);

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');

Line 580: FND_MESSAGE.SET_TOKEN('SQL_STRING', v_segments.default_value(j));

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));

Line 583: FND_MESSAGE.SET_NAME('FND', 'FLEX-DFLT MULTIPLE SQL ROWS');

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);

Line 584: FND_MESSAGE.SET_TOKEN('SQLSTR', 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;

Line 625: FND_MESSAGE.SET_NAME('FND', 'FLEX-DFLT NO SQL ROWS');

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));

Line 626: FND_MESSAGE.SET_TOKEN('SEGMENT_NAME', v_segments.segment_name(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;

Line 627: FND_MESSAGE.SET_TOKEN('APPLICATION_SHORT_NAME', 'INV');

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

Line 628: FND_MESSAGE.SET_TOKEN('FLEXFIELD_NAME', p_attributes_name);

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');

Line 629: FND_MESSAGE.SET_TOKEN('SQL_STRING', v_segments.default_value(j));

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));

Line 632: FND_MESSAGE.SET_NAME('FND', 'FLEX-DFLT MULTIPLE SQL ROWS');

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);

Line 633: FND_MESSAGE.SET_TOKEN('SQLSTR', 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;

Line 648: fnd_message.set_name('INV', 'INV_LOT_SEL_DEFAULT_REQUIRED');

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;

Line 649: fnd_message.set_token('ATTRNAME',p_attributes_name);

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;

Line 650: fnd_message.set_token('CONTEXTCODE', v_contexts.context_code(i));

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;

Line 651: fnd_message.set_token('SEGMENT', v_segments.application_column_name(j));

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

Line 1889: FND_MESSAGE.SET_NAME('INV', 'INV_FND_GENERIC_MSG');

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;

Line 1890: FND_MESSAGE.SET_TOKEN('MSG', fnd_flex_descval.error_message);

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);