DBA Data[Home] [Help]

APPS.INV_SERIAL_NUMBER_PUB dependencies on FND_FLEX_DESCVAL

Line 3874: invtrace('VALIDATE_UPDATE_SERIAL_ATT:Calling fnd_flex_descval.set_context_value...');

3870: x_msg_count := 0;
3871: x_msg_data := NULL;
3872: ELSE --IF ( (l_enabled_attributes = 0 ) OR ( l_context_value is null)) then
3873: IF (l_debug = 1) THEN
3874: invtrace('VALIDATE_UPDATE_SERIAL_ATT:Calling fnd_flex_descval.set_context_value...');
3875: END IF;
3876:
3877: fnd_flex_descval.set_context_value(l_context_value);
3878:

Line 3877: fnd_flex_descval.set_context_value(l_context_value);

3873: IF (l_debug = 1) THEN
3874: invtrace('VALIDATE_UPDATE_SERIAL_ATT:Calling fnd_flex_descval.set_context_value...');
3875: END IF;
3876:
3877: fnd_flex_descval.set_context_value(l_context_value);
3878:
3879: IF (l_debug = 1) THEN
3880: invtrace('VALIDATE_UPDATE_SERIAL_ATT:Calling fnd_flex_descval.clear_column_values...');
3881: END IF;

Line 3880: invtrace('VALIDATE_UPDATE_SERIAL_ATT:Calling fnd_flex_descval.clear_column_values...');

3876:
3877: fnd_flex_descval.set_context_value(l_context_value);
3878:
3879: IF (l_debug = 1) THEN
3880: invtrace('VALIDATE_UPDATE_SERIAL_ATT:Calling fnd_flex_descval.clear_column_values...');
3881: END IF;
3882:
3883: fnd_flex_descval.clear_column_values;
3884:

Line 3883: fnd_flex_descval.clear_column_values;

3879: IF (l_debug = 1) THEN
3880: invtrace('VALIDATE_UPDATE_SERIAL_ATT:Calling fnd_flex_descval.clear_column_values...');
3881: END IF;
3882:
3883: fnd_flex_descval.clear_column_values;
3884:
3885: IF (l_debug = 1) THEN
3886: invtrace('VALIDATE_UPDATE_SERIAL_ATT:Calling fnd_flex_descval.set_column_values SERIAL_ATTRIBUTE_CATEGORY='||l_context_value);
3887: END IF;

Line 3886: invtrace('VALIDATE_UPDATE_SERIAL_ATT:Calling fnd_flex_descval.set_column_values SERIAL_ATTRIBUTE_CATEGORY='||l_context_value);

3882:
3883: fnd_flex_descval.clear_column_values;
3884:
3885: IF (l_debug = 1) THEN
3886: invtrace('VALIDATE_UPDATE_SERIAL_ATT:Calling fnd_flex_descval.set_column_values SERIAL_ATTRIBUTE_CATEGORY='||l_context_value);
3887: END IF;
3888:
3889: fnd_flex_descval.set_column_value('SERIAL_ATTRIBUTE_CATEGORY', l_context_value);
3890:

Line 3889: fnd_flex_descval.set_column_value('SERIAL_ATTRIBUTE_CATEGORY', l_context_value);

3885: IF (l_debug = 1) THEN
3886: invtrace('VALIDATE_UPDATE_SERIAL_ATT:Calling fnd_flex_descval.set_column_values SERIAL_ATTRIBUTE_CATEGORY='||l_context_value);
3887: END IF;
3888:
3889: fnd_flex_descval.set_column_value('SERIAL_ATTRIBUTE_CATEGORY', l_context_value);
3890:
3891: -- Setting the Values for Validating
3892: IF (l_debug = 1) THEN
3893: invtrace('VALIDATE_UPDATE_SERIAL_ATT:g_serial_attributes_tbl.COUNT='||g_serial_attributes_tbl.COUNT);

Line 3926: fnd_flex_descval.set_column_value(g_serial_attributes_tbl(k).column_name,

3922: IF g_serial_attributes_tbl(k).column_type = 'DATE' THEN
3923: IF (l_debug = 1) THEN
3924: invtrace('VALIDATE_UPDATE_SERIAL_ATT:set_column_value='||g_serial_attributes_tbl(k).column_value);
3925: END IF;
3926: fnd_flex_descval.set_column_value(g_serial_attributes_tbl(k).column_name,
3927: fnd_date.canonical_to_date(fnd_date.date_to_canonical(g_serial_attributes_tbl(k).column_value)));
3928: END IF;
3929:
3930: IF g_serial_attributes_tbl(k).column_type = 'NUMBER' THEN

Line 3934: fnd_flex_descval.set_column_value(g_serial_attributes_tbl(k).column_name,

3930: IF g_serial_attributes_tbl(k).column_type = 'NUMBER' THEN
3931: IF (l_debug = 1) THEN
3932: invtrace('VALIDATE_UPDATE_SERIAL_ATT:set_column_value='||g_serial_attributes_tbl(k).column_value);
3933: END IF;
3934: fnd_flex_descval.set_column_value(g_serial_attributes_tbl(k).column_name,
3935: To_number(g_serial_attributes_tbl(k).column_value));
3936: END IF;
3937:
3938: IF g_serial_attributes_tbl(k).column_type = 'VARCHAR2' THEN

Line 3942: fnd_flex_descval.set_column_value(g_serial_attributes_tbl(k).column_name,

3938: IF g_serial_attributes_tbl(k).column_type = 'VARCHAR2' THEN
3939: IF (l_debug = 1) THEN
3940: invtrace('VALIDATE_UPDATE_SERIAL_ATT:set_column_value='||g_serial_attributes_tbl(k).column_value);
3941: END IF;
3942: fnd_flex_descval.set_column_value(g_serial_attributes_tbl(k).column_name,
3943: g_serial_attributes_tbl(k).column_value);
3944: END IF;
3945:
3946: IF (v_segments.is_required(j)) THEN

Line 3968: invtrace('VALIDATE_UPDATE_SERIAL_ATT:Calling fnd_flex_descval.validate_desccols...');

3964: END LOOP;
3965: -- Call the validating routine for Lot Attributes.
3966:
3967: IF (l_debug = 1) THEN
3968: invtrace('VALIDATE_UPDATE_SERIAL_ATT:Calling fnd_flex_descval.validate_desccols...');
3969: END IF;
3970: l_status := fnd_flex_descval.validate_desccols(appl_short_name => 'INV',
3971: desc_flex_name => l_attributes_name);
3972: IF l_status = TRUE then

Line 3970: l_status := fnd_flex_descval.validate_desccols(appl_short_name => 'INV',

3966:
3967: IF (l_debug = 1) THEN
3968: invtrace('VALIDATE_UPDATE_SERIAL_ATT:Calling fnd_flex_descval.validate_desccols...');
3969: END IF;
3970: l_status := fnd_flex_descval.validate_desccols(appl_short_name => 'INV',
3971: desc_flex_name => l_attributes_name);
3972: IF l_status = TRUE then
3973: IF (l_debug = 1) THEN
3974: invtrace('VALIDATE_UPDATE_SERIAL_ATT:l_status is TRUE');

Line 3983: x_msg_data := fnd_flex_descval.error_message;

3979: invtrace('VALIDATE_UPDATE_SERIAL_ATT:l_status is FALSE');
3980: END IF;
3981: l_validation_status := 'N';
3982: x_return_status := FND_API.G_RET_STS_ERROR ;
3983: x_msg_data := fnd_flex_descval.error_message;
3984: fnd_message.set_name('INV', 'GENERIC');
3985: fnd_message.set_token('MSGBODY', x_msg_data );
3986: fnd_msg_pub.ADD;
3987: x_msg_count := nvl(x_msg_count,0) + 1 ;