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 2041: FND_MESSAGE.SET_NAME('INV', 'INV_FND_GENERIC_MSG');

2037: x_concatenated_values := fnd_flex_descval.concatenated_values;
2038: ELSE
2039:
2040: x_concatenated_values := null;
2041: FND_MESSAGE.SET_NAME('INV', 'INV_FND_GENERIC_MSG');
2042: FND_MESSAGE.SET_TOKEN('MSG', fnd_flex_descval.error_message);
2043: FND_MSG_PUB.ADD;
2044: raise fnd_api.g_exc_unexpected_error;
2045: END IF;

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

2038: ELSE
2039:
2040: x_concatenated_values := null;
2041: FND_MESSAGE.SET_NAME('INV', 'INV_FND_GENERIC_MSG');
2042: FND_MESSAGE.SET_TOKEN('MSG', fnd_flex_descval.error_message);
2043: FND_MSG_PUB.ADD;
2044: raise fnd_api.g_exc_unexpected_error;
2045: END IF;
2046: debug('after getting x_concatenated_values ' || x_concatenated_values, 'GET_INV_SERIAL_ATTR', 9);

Line 2276: fnd_message.set_name('INV', 'INV_LOT_GEN_ERROR');

2272: ROLLBACK TO lock_lot_records;
2273: IF SQLCODE = -54 THEN
2274: -- item with same prefix / same item currently locked in MSI
2275: debug('Item with same prefix currently locked in Master or Organization items form',l_module_name,9);
2276: fnd_message.set_name('INV', 'INV_LOT_GEN_ERROR');
2277: fnd_msg_pub.ADD;
2278: END IF;
2279: x_return_status := fnd_api.g_ret_sts_error;
2280: RETURN FALSE;