eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.EAM_ASSET_ATTR_IMPORT_PVT dependencies on FND_FLEX_DESCVAL

Line 488: FND_FLEX_DESCVAL.set_context_value(attr_group.attribute_category);

484: END IF;
485: */
486:
487: -- Initialize the server side flex validation API with context value
488: FND_FLEX_DESCVAL.set_context_value(attr_group.attribute_category);
489:
490: FOR num_v_attr_col IN 1..20
491: LOOP
492: fnd_flex_descval.set_column_value('C_ATTRIBUTE' || TO_CHAR(num_v_attr_col), '');

Line 492: fnd_flex_descval.set_column_value('C_ATTRIBUTE' || TO_CHAR(num_v_attr_col), '');

488: FND_FLEX_DESCVAL.set_context_value(attr_group.attribute_category);
489:
490: FOR num_v_attr_col IN 1..20
491: LOOP
492: fnd_flex_descval.set_column_value('C_ATTRIBUTE' || TO_CHAR(num_v_attr_col), '');
493: END LOOP;
494: FOR num_nd_attr_col IN 1..10
495: LOOP
496: fnd_flex_descval.set_column_value('N_ATTRIBUTE' || TO_CHAR(num_nd_attr_col), TO_NUMBER(NULL));

Line 496: fnd_flex_descval.set_column_value('N_ATTRIBUTE' || TO_CHAR(num_nd_attr_col), TO_NUMBER(NULL));

492: fnd_flex_descval.set_column_value('C_ATTRIBUTE' || TO_CHAR(num_v_attr_col), '');
493: END LOOP;
494: FOR num_nd_attr_col IN 1..10
495: LOOP
496: fnd_flex_descval.set_column_value('N_ATTRIBUTE' || TO_CHAR(num_nd_attr_col), TO_NUMBER(NULL));
497: fnd_flex_descval.set_column_value('D_ATTRIBUTE' || TO_CHAR(num_nd_attr_col), TO_DATE(NULL));
498: END LOOP;
499:
500: -- Open loop for all attributes for an attribute group of an asset number

Line 497: fnd_flex_descval.set_column_value('D_ATTRIBUTE' || TO_CHAR(num_nd_attr_col), TO_DATE(NULL));

493: END LOOP;
494: FOR num_nd_attr_col IN 1..10
495: LOOP
496: fnd_flex_descval.set_column_value('N_ATTRIBUTE' || TO_CHAR(num_nd_attr_col), TO_NUMBER(NULL));
497: fnd_flex_descval.set_column_value('D_ATTRIBUTE' || TO_CHAR(num_nd_attr_col), TO_DATE(NULL));
498: END LOOP;
499:
500: -- Open loop for all attributes for an attribute group of an asset number
501: FOR attr IN attr_cur

Line 536: fnd_flex_descval.set_column_value(attr.application_column_name,

532:
533: IF (attr.line_type = 1) THEN
534: l_c_attribute(p_num) := attr.attribute_varchar2_value;
535:
536: fnd_flex_descval.set_column_value(attr.application_column_name,
537: attr.attribute_varchar2_value);
538: ELSIF (attr.line_type = 2) THEN
539: l_n_attribute(p_num) := attr.attribute_number_value;
540: fnd_flex_descval.set_column_value(attr.application_column_name,

Line 540: fnd_flex_descval.set_column_value(attr.application_column_name,

536: fnd_flex_descval.set_column_value(attr.application_column_name,
537: attr.attribute_varchar2_value);
538: ELSIF (attr.line_type = 2) THEN
539: l_n_attribute(p_num) := attr.attribute_number_value;
540: fnd_flex_descval.set_column_value(attr.application_column_name,
541: TO_NUMBER(attr.attribute_number_value));
542:
543: ELSIF (attr.line_type = 3) THEN
544: l_d_attribute(p_num) := attr.attribute_date_value;

Line 546: fnd_flex_descval.set_column_value(attr.application_column_name,

542:
543: ELSIF (attr.line_type = 3) THEN
544: l_d_attribute(p_num) := attr.attribute_date_value;
545: -- Bug # 3373134
546: fnd_flex_descval.set_column_value(attr.application_column_name,
547: TO_DATE(TO_CHAR(attr.attribute_date_value, 'yyyy-mm-dd'),'yyyy-mm-dd'));
548: END IF;
549:
550: END LOOP; -- End loop for attributes

Line 595: fnd_flex_descval.set_column_value(missing_attr.application_column_name,

591:
592: -- 2002-01-11: chrng: Fixed bug 2181053.
593: -- Have to rely on the naming of the column to determine its type
594: IF (SUBSTR(missing_attr.application_column_name, 1, 1) = 'C') THEN
595: fnd_flex_descval.set_column_value(missing_attr.application_column_name,
596: l_miss_attr_value);
597: ELSIF (SUBSTR(missing_attr.application_column_name, 1, 1) = 'N') THEN
598: fnd_flex_descval.set_column_value(missing_attr.application_column_name,
599: TO_NUMBER(l_miss_attr_value));

Line 598: fnd_flex_descval.set_column_value(missing_attr.application_column_name,

594: IF (SUBSTR(missing_attr.application_column_name, 1, 1) = 'C') THEN
595: fnd_flex_descval.set_column_value(missing_attr.application_column_name,
596: l_miss_attr_value);
597: ELSIF (SUBSTR(missing_attr.application_column_name, 1, 1) = 'N') THEN
598: fnd_flex_descval.set_column_value(missing_attr.application_column_name,
599: TO_NUMBER(l_miss_attr_value));
600: -- Bug # 3373134
601: ELSIF (SUBSTR(missing_attr.application_column_name, 1, 1) = 'D') THEN
602: fnd_flex_descval.set_column_value(missing_attr.application_column_name,

Line 602: fnd_flex_descval.set_column_value(missing_attr.application_column_name,

598: fnd_flex_descval.set_column_value(missing_attr.application_column_name,
599: TO_NUMBER(l_miss_attr_value));
600: -- Bug # 3373134
601: ELSIF (SUBSTR(missing_attr.application_column_name, 1, 1) = 'D') THEN
602: fnd_flex_descval.set_column_value(missing_attr.application_column_name,
603: TO_DATE(l_miss_attr_value, 'yyyy-mm-dd'));
604: END IF;
605:
606: END LOOP;

Line 616: IF (NOT FND_FLEX_DESCVAL.validate_desccols(l_application_code,

612:
613: END IF; -- End if UPDATE mode
614:
615: -- Call to validate descriptive flex values using value sets
616: IF (NOT FND_FLEX_DESCVAL.validate_desccols(l_application_code,
617: l_descriptive_flexfield_name,
618: 'I',
619: SYSDATE)) THEN
620:

Line 625: meavi.error_message = FND_FLEX_DESCVAL.error_message

621: -- Value Set validation failed, mark rows as error
622: UPDATE mtl_eam_attr_val_interface meavi
623: SET meavi.process_status = 'E',
624: meavi.error_number = 9999,
625: meavi.error_message = FND_FLEX_DESCVAL.error_message
626: WHERE meavi.interface_header_id = p_interface_header_id
627: AND meavi.application_id = attr_group.application_id
628: AND meavi.descriptive_flexfield_name = attr_group.descriptive_flexfield_name
629: AND meavi.attribute_category = attr_group.attribute_category

Line 636: -- l_concatenated_segments := FND_FLEX_DESCVAL.concatenated_ids;

632: l_stmt_generated := 'E';
633:
634: -- ELSE
635: -- commented the following by sraval as this statement raises exception
636: -- l_concatenated_segments := FND_FLEX_DESCVAL.concatenated_ids;
637:
638: END IF; -- end value valid
639:
640: