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.INV_LOT_API_PUB dependencies on FND_FLEX_DESCVAL

Line 4000: fnd_flex_descval.set_column_value(

3996: END IF;
3997:
3998: IF p_attributes_tbl.EXISTS(SUBSTR(l_segments_dr.application_column_name(i)
3999: , INSTR(l_segments_dr.application_column_name(i), 'ATTRIBUTE') + 9)) THEN
4000: fnd_flex_descval.set_column_value(
4001: l_segments_dr.application_column_name(i)
4002: , p_attributes_tbl(SUBSTR(l_segments_dr.application_column_name(i)
4003: , INSTR(l_segments_dr.application_column_name(i), 'ATTRIBUTE') + 9))
4004: );

Line 4006: fnd_flex_descval.set_column_value(l_segments_dr.application_column_name(i), l_null_char_val);

4002: , p_attributes_tbl(SUBSTR(l_segments_dr.application_column_name(i)
4003: , INSTR(l_segments_dr.application_column_name(i), 'ATTRIBUTE') + 9))
4004: );
4005: ELSE
4006: fnd_flex_descval.set_column_value(l_segments_dr.application_column_name(i), l_null_char_val);
4007: END IF;
4008:
4009: --fnd_flex_descval.set_column_value(l_segments_dr.application_column_name(i),p_attributes_tbl(SUBSTR(l_segments_dr.application_column_name(i),INSTR(l_segments_dr.application_column_name(i),'ATTRIBUTE')+9)));
4010: v_index := v_index + 1;

Line 4009: --fnd_flex_descval.set_column_value(l_segments_dr.application_column_name(i),p_attributes_tbl(SUBSTR(l_segments_dr.application_column_name(i),INSTR(l_segments_dr.application_column_name(i),'ATTRIBUTE')+9)));

4005: ELSE
4006: fnd_flex_descval.set_column_value(l_segments_dr.application_column_name(i), l_null_char_val);
4007: END IF;
4008:
4009: --fnd_flex_descval.set_column_value(l_segments_dr.application_column_name(i),p_attributes_tbl(SUBSTR(l_segments_dr.application_column_name(i),INSTR(l_segments_dr.application_column_name(i),'ATTRIBUTE')+9)));
4010: v_index := v_index + 1;
4011: END LOOP;
4012:
4013: IF l_enabled_seg_name.COUNT > 0 THEN

Line 4029: fnd_flex_descval.set_context_value(l_context);

4025: /*Get the context for the item passed */
4026: IF p_attribute_category IS NOT NULL THEN
4027: l_context := p_attribute_category;
4028: /* Set flex context for validation of the value set */
4029: fnd_flex_descval.set_context_value(l_context);
4030:
4031: IF g_debug = 1 THEN
4032: print_debug('The value of INV context is ' || l_context, 9);
4033: END IF;

Line 4067: fnd_flex_descval.set_column_value(

4063: END IF;
4064:
4065: IF p_attributes_tbl.EXISTS(SUBSTR(l_segments_dr.application_column_name(i)
4066: , INSTR(l_segments_dr.application_column_name(i), 'ATTRIBUTE') + 9)) THEN
4067: fnd_flex_descval.set_column_value(
4068: l_segments_dr.application_column_name(i)
4069: , p_attributes_tbl(SUBSTR(l_segments_dr.application_column_name(i)
4070: , INSTR(l_segments_dr.application_column_name(i), 'ATTRIBUTE') + 9))
4071: );

Line 4073: fnd_flex_descval.set_column_value(l_segments_dr.application_column_name(i), l_null_char_val);

4069: , p_attributes_tbl(SUBSTR(l_segments_dr.application_column_name(i)
4070: , INSTR(l_segments_dr.application_column_name(i), 'ATTRIBUTE') + 9))
4071: );
4072: ELSE
4073: fnd_flex_descval.set_column_value(l_segments_dr.application_column_name(i), l_null_char_val);
4074: END IF;
4075:
4076: v_index := v_index + 1;
4077: END LOOP;

Line 4109: /Make a call to FND_FLEX_DESCVAL.validate_desccols /

4105: v_index1 := p_attributes_tbl.NEXT(v_index1);
4106: l_chk_flag := 0;
4107: END LOOP;*/
4108: END IF;
4109: /*Make a call to FND_FLEX_DESCVAL.validate_desccols */
4110: IF (l_global_nsegments > 0 AND p_attribute_Category IS NULL ) THEN
4111: l_context := l_contexts_dr.context_code(l_global_context);
4112: fnd_flex_descval.set_context_value(l_context);
4113: end if;

Line 4112: fnd_flex_descval.set_context_value(l_context);

4108: END IF;
4109: /*Make a call to FND_FLEX_DESCVAL.validate_desccols */
4110: IF (l_global_nsegments > 0 AND p_attribute_Category IS NULL ) THEN
4111: l_context := l_contexts_dr.context_code(l_global_context);
4112: fnd_flex_descval.set_context_value(l_context);
4113: end if;
4114: IF( l_global_nsegments > 0 OR p_attribute_category IS NOT NULL ) then
4115: IF fnd_flex_descval.validate_desccols(appl_short_name => 'INV', desc_flex_name => 'MTL_LOT_NUMBERS', values_or_ids => 'I'
4116: , validation_date => SYSDATE) THEN

Line 4115: IF fnd_flex_descval.validate_desccols(appl_short_name => 'INV', desc_flex_name => 'MTL_LOT_NUMBERS', values_or_ids => 'I'

4111: l_context := l_contexts_dr.context_code(l_global_context);
4112: fnd_flex_descval.set_context_value(l_context);
4113: end if;
4114: IF( l_global_nsegments > 0 OR p_attribute_category IS NOT NULL ) then
4115: IF fnd_flex_descval.validate_desccols(appl_short_name => 'INV', desc_flex_name => 'MTL_LOT_NUMBERS', values_or_ids => 'I'
4116: , validation_date => SYSDATE) THEN
4117: IF g_debug = 1 THEN
4118: print_debug('Value set validation successful', 9);
4119: END IF;

Line 4122: error_segment := fnd_flex_descval.error_segment;

4118: print_debug('Value set validation successful', 9);
4119: END IF;
4120: ELSE
4121: IF g_debug = 1 THEN
4122: error_segment := fnd_flex_descval.error_segment;
4123: print_debug('Value set validation failed for segment ' || error_segment, 9);
4124: RAISE errors_received;
4125: END IF;
4126: END IF;

Line 4187: error_msg := fnd_flex_descval.error_message;

4183: END IF; /* If wms_is installed */
4184: EXCEPTION
4185: WHEN errors_received THEN
4186: x_return_status := g_ret_sts_error;
4187: error_msg := fnd_flex_descval.error_message;
4188: s := 1;
4189: e := 200;
4190:
4191: --print_debug('Here are the error messages: ',9);

Line 7624: fnd_flex_descval.set_column_value(lot_dff(j).column_name, lot_dff(j).column_value);

7620: print_debug('The column type is ' || NVL(lot_dff(j).column_type, NULL), 9);
7621: END IF;
7622:
7623: IF lot_dff(j).column_type = 'VARCHAR2' THEN
7624: fnd_flex_descval.set_column_value(lot_dff(j).column_name, lot_dff(j).column_value);
7625: ELSIF lot_dff(j).column_type = 'NUMBER' THEN
7626: fnd_flex_descval.set_column_value(lot_dff(j).column_name, TO_NUMBER(lot_dff(j).column_value));
7627: ELSIF lot_dff(j).column_type = 'DATE' THEN
7628: fnd_flex_descval.set_column_value(lot_dff(j).column_name, fnd_date.canonical_to_date(lot_dff(j).column_value));

Line 7626: fnd_flex_descval.set_column_value(lot_dff(j).column_name, TO_NUMBER(lot_dff(j).column_value));

7622:
7623: IF lot_dff(j).column_type = 'VARCHAR2' THEN
7624: fnd_flex_descval.set_column_value(lot_dff(j).column_name, lot_dff(j).column_value);
7625: ELSIF lot_dff(j).column_type = 'NUMBER' THEN
7626: fnd_flex_descval.set_column_value(lot_dff(j).column_name, TO_NUMBER(lot_dff(j).column_value));
7627: ELSIF lot_dff(j).column_type = 'DATE' THEN
7628: fnd_flex_descval.set_column_value(lot_dff(j).column_name, fnd_date.canonical_to_date(lot_dff(j).column_value));
7629: END IF;
7630:

Line 7628: fnd_flex_descval.set_column_value(lot_dff(j).column_name, fnd_date.canonical_to_date(lot_dff(j).column_value));

7624: fnd_flex_descval.set_column_value(lot_dff(j).column_name, lot_dff(j).column_value);
7625: ELSIF lot_dff(j).column_type = 'NUMBER' THEN
7626: fnd_flex_descval.set_column_value(lot_dff(j).column_name, TO_NUMBER(lot_dff(j).column_value));
7627: ELSIF lot_dff(j).column_type = 'DATE' THEN
7628: fnd_flex_descval.set_column_value(lot_dff(j).column_name, fnd_date.canonical_to_date(lot_dff(j).column_value));
7629: END IF;
7630:
7631: IF lot_dff(j).column_value IS NOT NULL THEN
7632: l_value_not_null_flag := 1;

Line 7697: fnd_flex_descval.set_context_value(l_context);

7693: if( l_contexts_dr.is_enabled(i) AND l_context IS NOT NULL AND
7694: UPPER(l_contexts_dr.context_code(i)) = UPPER(l_context)) THEN
7695: l_context_enabled := TRUE;
7696: /* Set flex context for validation of the value set */
7697: fnd_flex_descval.set_context_value(l_context);
7698: /* Prepare the context_r type */
7699: l_context_r.flexfield := l_dflex_r;
7700: l_context_r.context_code := l_context;
7701: fnd_dflex.get_segments(CONTEXT => l_context_r, segments => l_segments_dr, enabled_only => TRUE);

Line 7716: fnd_flex_descval.set_column_value(lot_dff(j).column_name, lot_dff(j).column_value);

7712: print_debug('The segment is ' || UPPER(l_segments_dr.application_column_name(i)), 9);
7713: END IF;
7714:
7715: IF lot_dff(j).column_type = 'VARCHAR2' THEN
7716: fnd_flex_descval.set_column_value(lot_dff(j).column_name, lot_dff(j).column_value);
7717: ELSIF lot_dff(j).column_type = 'NUMBER' THEN
7718: fnd_flex_descval.set_column_value(lot_dff(j).column_name, TO_NUMBER(lot_dff(j).column_value));
7719: ELSIF lot_dff(j).column_type = 'DATE' THEN
7720: fnd_flex_descval.set_column_value(lot_dff(j).column_name,

Line 7718: fnd_flex_descval.set_column_value(lot_dff(j).column_name, TO_NUMBER(lot_dff(j).column_value));

7714:
7715: IF lot_dff(j).column_type = 'VARCHAR2' THEN
7716: fnd_flex_descval.set_column_value(lot_dff(j).column_name, lot_dff(j).column_value);
7717: ELSIF lot_dff(j).column_type = 'NUMBER' THEN
7718: fnd_flex_descval.set_column_value(lot_dff(j).column_name, TO_NUMBER(lot_dff(j).column_value));
7719: ELSIF lot_dff(j).column_type = 'DATE' THEN
7720: fnd_flex_descval.set_column_value(lot_dff(j).column_name,
7721: fnd_date.canonical_to_date(lot_dff(j).column_value));
7722: END IF;

Line 7720: fnd_flex_descval.set_column_value(lot_dff(j).column_name,

7716: fnd_flex_descval.set_column_value(lot_dff(j).column_name, lot_dff(j).column_value);
7717: ELSIF lot_dff(j).column_type = 'NUMBER' THEN
7718: fnd_flex_descval.set_column_value(lot_dff(j).column_name, TO_NUMBER(lot_dff(j).column_value));
7719: ELSIF lot_dff(j).column_type = 'DATE' THEN
7720: fnd_flex_descval.set_column_value(lot_dff(j).column_name,
7721: fnd_date.canonical_to_date(lot_dff(j).column_value));
7722: END IF;
7723:
7724: IF lot_dff(j).column_value IS NOT NULL THEN

Line 7750: IF fnd_flex_descval.validate_desccols(appl_short_name => 'INV', desc_flex_name => 'Lot Attributes', values_or_ids => 'I'

7746: END LOOP;
7747: END IF;
7748: END LOOP;
7749: IF l_context IS NOT NULL AND l_context_enabled = TRUE AND l_global_nsegments > 0 then
7750: IF fnd_flex_descval.validate_desccols(appl_short_name => 'INV', desc_flex_name => 'Lot Attributes', values_or_ids => 'I'
7751: , validation_date => SYSDATE) THEN
7752: IF g_debug = 1 THEN
7753: print_debug('Value set validation successful', 9);
7754: print_debug('Program LOT_DFF_VALIDATE has completed succcessfuly', 9);

Line 7758: error_segment := fnd_flex_descval.error_segment;

7754: print_debug('Program LOT_DFF_VALIDATE has completed succcessfuly', 9);
7755: END IF;
7756: ELSE
7757: IF g_debug = 1 THEN
7758: error_segment := fnd_flex_descval.error_segment;
7759: print_debug('Value set validation failed for segment ' || error_segment, 9);
7760: RAISE errors_received;
7761: END IF;
7762: END IF;

Line 7782: error_msg := fnd_flex_descval.error_message;

7778: IF g_debug = 1 THEN
7779: print_debug('Program LOT_DFF_VALIDATE has completed with errors_received', 9);
7780: END IF;
7781:
7782: error_msg := fnd_flex_descval.error_message;
7783: s := 1;
7784: e := 200;
7785:
7786: --print_debug('Here are the error messages: ',9);