DBA Data[Home] [Help]

APPS.INV_SERIAL_NUMBER_PUB dependencies on FND_FLEX_DESCVAL

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

3505: x_msg_count := 0;
3506: x_msg_data := NULL;
3507: ELSE --IF ( (l_enabled_attributes = 0 ) OR ( l_context_value is null)) then
3508: IF (l_debug = 1) THEN
3509: invtrace('VALIDATE_UPDATE_SERIAL_ATT:Calling fnd_flex_descval.set_context_value...');
3510: END IF;
3511:
3512: fnd_flex_descval.set_context_value(l_context_value);
3513:

Line 3512: fnd_flex_descval.set_context_value(l_context_value);

3508: IF (l_debug = 1) THEN
3509: invtrace('VALIDATE_UPDATE_SERIAL_ATT:Calling fnd_flex_descval.set_context_value...');
3510: END IF;
3511:
3512: fnd_flex_descval.set_context_value(l_context_value);
3513:
3514: IF (l_debug = 1) THEN
3515: invtrace('VALIDATE_UPDATE_SERIAL_ATT:Calling fnd_flex_descval.clear_column_values...');
3516: END IF;

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

3511:
3512: fnd_flex_descval.set_context_value(l_context_value);
3513:
3514: IF (l_debug = 1) THEN
3515: invtrace('VALIDATE_UPDATE_SERIAL_ATT:Calling fnd_flex_descval.clear_column_values...');
3516: END IF;
3517:
3518: fnd_flex_descval.clear_column_values;
3519:

Line 3518: fnd_flex_descval.clear_column_values;

3514: IF (l_debug = 1) THEN
3515: invtrace('VALIDATE_UPDATE_SERIAL_ATT:Calling fnd_flex_descval.clear_column_values...');
3516: END IF;
3517:
3518: fnd_flex_descval.clear_column_values;
3519:
3520: IF (l_debug = 1) THEN
3521: invtrace('VALIDATE_UPDATE_SERIAL_ATT:Calling fnd_flex_descval.set_column_values SERIAL_ATTRIBUTE_CATEGORY='||l_context_value);
3522: END IF;

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

3517:
3518: fnd_flex_descval.clear_column_values;
3519:
3520: IF (l_debug = 1) THEN
3521: invtrace('VALIDATE_UPDATE_SERIAL_ATT:Calling fnd_flex_descval.set_column_values SERIAL_ATTRIBUTE_CATEGORY='||l_context_value);
3522: END IF;
3523:
3524: fnd_flex_descval.set_column_value('SERIAL_ATTRIBUTE_CATEGORY', l_context_value);
3525:

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

3520: IF (l_debug = 1) THEN
3521: invtrace('VALIDATE_UPDATE_SERIAL_ATT:Calling fnd_flex_descval.set_column_values SERIAL_ATTRIBUTE_CATEGORY='||l_context_value);
3522: END IF;
3523:
3524: fnd_flex_descval.set_column_value('SERIAL_ATTRIBUTE_CATEGORY', l_context_value);
3525:
3526: -- Setting the Values for Validating
3527: IF (l_debug = 1) THEN
3528: invtrace('VALIDATE_UPDATE_SERIAL_ATT:g_serial_attributes_tbl.COUNT='||g_serial_attributes_tbl.COUNT);

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

3557: IF g_serial_attributes_tbl(k).column_type = 'DATE' THEN
3558: IF (l_debug = 1) THEN
3559: invtrace('VALIDATE_UPDATE_SERIAL_ATT:set_column_value='||g_serial_attributes_tbl(k).column_value);
3560: END IF;
3561: fnd_flex_descval.set_column_value(g_serial_attributes_tbl(k).column_name,
3562: fnd_date.canonical_to_date(fnd_date.date_to_canonical(g_serial_attributes_tbl(k).column_value)));
3563: END IF;
3564:
3565: IF g_serial_attributes_tbl(k).column_type = 'NUMBER' THEN

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

3565: IF g_serial_attributes_tbl(k).column_type = 'NUMBER' THEN
3566: IF (l_debug = 1) THEN
3567: invtrace('VALIDATE_UPDATE_SERIAL_ATT:set_column_value='||g_serial_attributes_tbl(k).column_value);
3568: END IF;
3569: fnd_flex_descval.set_column_value(g_serial_attributes_tbl(k).column_name,
3570: To_number(g_serial_attributes_tbl(k).column_value));
3571: END IF;
3572:
3573: IF g_serial_attributes_tbl(k).column_type = 'VARCHAR2' THEN

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

3573: IF g_serial_attributes_tbl(k).column_type = 'VARCHAR2' THEN
3574: IF (l_debug = 1) THEN
3575: invtrace('VALIDATE_UPDATE_SERIAL_ATT:set_column_value='||g_serial_attributes_tbl(k).column_value);
3576: END IF;
3577: fnd_flex_descval.set_column_value(g_serial_attributes_tbl(k).column_name,
3578: g_serial_attributes_tbl(k).column_value);
3579: END IF;
3580:
3581: IF (v_segments.is_required(j)) THEN

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

3599: END LOOP;
3600: -- Call the validating routine for Lot Attributes.
3601:
3602: IF (l_debug = 1) THEN
3603: invtrace('VALIDATE_UPDATE_SERIAL_ATT:Calling fnd_flex_descval.validate_desccols...');
3604: END IF;
3605: l_status := fnd_flex_descval.validate_desccols(appl_short_name => 'INV',
3606: desc_flex_name => l_attributes_name);
3607: IF l_status = TRUE then

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

3601:
3602: IF (l_debug = 1) THEN
3603: invtrace('VALIDATE_UPDATE_SERIAL_ATT:Calling fnd_flex_descval.validate_desccols...');
3604: END IF;
3605: l_status := fnd_flex_descval.validate_desccols(appl_short_name => 'INV',
3606: desc_flex_name => l_attributes_name);
3607: IF l_status = TRUE then
3608: IF (l_debug = 1) THEN
3609: invtrace('VALIDATE_UPDATE_SERIAL_ATT:l_status is TRUE');

Line 3618: x_msg_data := fnd_flex_descval.error_message;

3614: invtrace('VALIDATE_UPDATE_SERIAL_ATT:l_status is FALSE');
3615: END IF;
3616: l_validation_status := 'N';
3617: x_return_status := FND_API.G_RET_STS_ERROR ;
3618: x_msg_data := fnd_flex_descval.error_message;
3619: fnd_message.set_name('INV', 'GENERIC');
3620: fnd_message.set_token('MSGBODY', x_msg_data );
3621: fnd_msg_pub.ADD;
3622: x_msg_count := nvl(x_msg_count,0) + 1 ;