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 4159: fnd_flex_descval.set_column_value(

4155: END IF;
4156:
4157: IF p_attributes_tbl.EXISTS(SUBSTR(l_segments_dr.application_column_name(i)
4158: , INSTR(l_segments_dr.application_column_name(i), 'ATTRIBUTE') + 9)) THEN
4159: fnd_flex_descval.set_column_value(
4160: l_segments_dr.application_column_name(i)
4161: , p_attributes_tbl(SUBSTR(l_segments_dr.application_column_name(i)
4162: , INSTR(l_segments_dr.application_column_name(i), 'ATTRIBUTE') + 9))
4163: );

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

4161: , p_attributes_tbl(SUBSTR(l_segments_dr.application_column_name(i)
4162: , INSTR(l_segments_dr.application_column_name(i), 'ATTRIBUTE') + 9))
4163: );
4164: ELSE
4165: fnd_flex_descval.set_column_value(l_segments_dr.application_column_name(i), l_null_char_val);
4166: END IF;
4167:
4168: --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)));
4169: v_index := v_index + 1;

Line 4168: --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)));

4164: ELSE
4165: fnd_flex_descval.set_column_value(l_segments_dr.application_column_name(i), l_null_char_val);
4166: END IF;
4167:
4168: --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)));
4169: v_index := v_index + 1;
4170: END LOOP;
4171:
4172: IF l_enabled_seg_name.COUNT > 0 THEN

Line 4188: fnd_flex_descval.set_context_value(l_context);

4184: /*Get the context for the item passed */
4185: IF p_attribute_category IS NOT NULL THEN
4186: l_context := p_attribute_category;
4187: /* Set flex context for validation of the value set */
4188: fnd_flex_descval.set_context_value(l_context);
4189:
4190: IF g_debug = 1 THEN
4191: print_debug('The value of INV context is ' || l_context, 9);
4192: END IF;

Line 4226: fnd_flex_descval.set_column_value(

4222: END IF;
4223:
4224: IF p_attributes_tbl.EXISTS(SUBSTR(l_segments_dr.application_column_name(i)
4225: , INSTR(l_segments_dr.application_column_name(i), 'ATTRIBUTE') + 9)) THEN
4226: fnd_flex_descval.set_column_value(
4227: l_segments_dr.application_column_name(i)
4228: , p_attributes_tbl(SUBSTR(l_segments_dr.application_column_name(i)
4229: , INSTR(l_segments_dr.application_column_name(i), 'ATTRIBUTE') + 9))
4230: );

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

4228: , p_attributes_tbl(SUBSTR(l_segments_dr.application_column_name(i)
4229: , INSTR(l_segments_dr.application_column_name(i), 'ATTRIBUTE') + 9))
4230: );
4231: ELSE
4232: fnd_flex_descval.set_column_value(l_segments_dr.application_column_name(i), l_null_char_val);
4233: END IF;
4234:
4235: v_index := v_index + 1;
4236: END LOOP;

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

4264: v_index1 := p_attributes_tbl.NEXT(v_index1);
4265: l_chk_flag := 0;
4266: END LOOP;*/
4267: END IF;
4268: /*Make a call to FND_FLEX_DESCVAL.validate_desccols */
4269: IF (l_global_nsegments > 0 AND p_attribute_Category IS NULL ) THEN
4270: l_context := l_contexts_dr.context_code(l_global_context);
4271: fnd_flex_descval.set_context_value(l_context);
4272: end if;

Line 4271: fnd_flex_descval.set_context_value(l_context);

4267: END IF;
4268: /*Make a call to FND_FLEX_DESCVAL.validate_desccols */
4269: IF (l_global_nsegments > 0 AND p_attribute_Category IS NULL ) THEN
4270: l_context := l_contexts_dr.context_code(l_global_context);
4271: fnd_flex_descval.set_context_value(l_context);
4272: end if;
4273: IF( l_global_nsegments > 0 OR p_attribute_category IS NOT NULL ) then
4274: IF fnd_flex_descval.validate_desccols(appl_short_name => 'INV', desc_flex_name => 'MTL_LOT_NUMBERS', values_or_ids => 'I'
4275: , validation_date => SYSDATE) THEN

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

4270: l_context := l_contexts_dr.context_code(l_global_context);
4271: fnd_flex_descval.set_context_value(l_context);
4272: end if;
4273: IF( l_global_nsegments > 0 OR p_attribute_category IS NOT NULL ) then
4274: IF fnd_flex_descval.validate_desccols(appl_short_name => 'INV', desc_flex_name => 'MTL_LOT_NUMBERS', values_or_ids => 'I'
4275: , validation_date => SYSDATE) THEN
4276: IF g_debug = 1 THEN
4277: print_debug('Value set validation successful', 9);
4278: END IF;

Line 4281: error_segment := fnd_flex_descval.error_segment;

4277: print_debug('Value set validation successful', 9);
4278: END IF;
4279: ELSE
4280: IF g_debug = 1 THEN
4281: error_segment := fnd_flex_descval.error_segment;
4282: print_debug('Value set validation failed for segment ' || error_segment, 9);
4283: RAISE errors_received;
4284: END IF;
4285: END IF;

Line 4346: error_msg := fnd_flex_descval.error_message;

4342: END IF; /* If wms_is installed */
4343: EXCEPTION
4344: WHEN errors_received THEN
4345: x_return_status := g_ret_sts_error;
4346: error_msg := fnd_flex_descval.error_message;
4347: s := 1;
4348: e := 200;
4349:
4350: --print_debug('Here are the error messages: ',9);

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

7973: print_debug('The column type is ' || NVL(lot_dff(j).column_type, NULL), 9);
7974: END IF;
7975:
7976: IF lot_dff(j).column_type = 'VARCHAR2' THEN
7977: fnd_flex_descval.set_column_value(lot_dff(j).column_name, lot_dff(j).column_value);
7978: ELSIF lot_dff(j).column_type = 'NUMBER' THEN
7979: fnd_flex_descval.set_column_value(lot_dff(j).column_name, TO_NUMBER(lot_dff(j).column_value));
7980: ELSIF lot_dff(j).column_type = 'DATE' THEN
7981: fnd_flex_descval.set_column_value(lot_dff(j).column_name, fnd_date.canonical_to_date(lot_dff(j).column_value));

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

7975:
7976: IF lot_dff(j).column_type = 'VARCHAR2' THEN
7977: fnd_flex_descval.set_column_value(lot_dff(j).column_name, lot_dff(j).column_value);
7978: ELSIF lot_dff(j).column_type = 'NUMBER' THEN
7979: fnd_flex_descval.set_column_value(lot_dff(j).column_name, TO_NUMBER(lot_dff(j).column_value));
7980: ELSIF lot_dff(j).column_type = 'DATE' THEN
7981: fnd_flex_descval.set_column_value(lot_dff(j).column_name, fnd_date.canonical_to_date(lot_dff(j).column_value));
7982: END IF;
7983:

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

7977: fnd_flex_descval.set_column_value(lot_dff(j).column_name, lot_dff(j).column_value);
7978: ELSIF lot_dff(j).column_type = 'NUMBER' THEN
7979: fnd_flex_descval.set_column_value(lot_dff(j).column_name, TO_NUMBER(lot_dff(j).column_value));
7980: ELSIF lot_dff(j).column_type = 'DATE' THEN
7981: fnd_flex_descval.set_column_value(lot_dff(j).column_name, fnd_date.canonical_to_date(lot_dff(j).column_value));
7982: END IF;
7983:
7984: IF lot_dff(j).column_value IS NOT NULL THEN
7985: l_value_not_null_flag := 1;

Line 8050: fnd_flex_descval.set_context_value(l_context);

8046: if( l_contexts_dr.is_enabled(i) AND l_context IS NOT NULL AND
8047: UPPER(l_contexts_dr.context_code(i)) = UPPER(l_context)) THEN
8048: l_context_enabled := TRUE;
8049: /* Set flex context for validation of the value set */
8050: fnd_flex_descval.set_context_value(l_context);
8051: /* Prepare the context_r type */
8052: l_context_r.flexfield := l_dflex_r;
8053: l_context_r.context_code := l_context;
8054: fnd_dflex.get_segments(CONTEXT => l_context_r, segments => l_segments_dr, enabled_only => TRUE);

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

8065: print_debug('The segment is ' || UPPER(l_segments_dr.application_column_name(i)), 9);
8066: END IF;
8067:
8068: IF lot_dff(j).column_type = 'VARCHAR2' THEN
8069: fnd_flex_descval.set_column_value(lot_dff(j).column_name, lot_dff(j).column_value);
8070: ELSIF lot_dff(j).column_type = 'NUMBER' THEN
8071: fnd_flex_descval.set_column_value(lot_dff(j).column_name, TO_NUMBER(lot_dff(j).column_value));
8072: ELSIF lot_dff(j).column_type = 'DATE' THEN
8073: fnd_flex_descval.set_column_value(lot_dff(j).column_name,

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

8067:
8068: IF lot_dff(j).column_type = 'VARCHAR2' THEN
8069: fnd_flex_descval.set_column_value(lot_dff(j).column_name, lot_dff(j).column_value);
8070: ELSIF lot_dff(j).column_type = 'NUMBER' THEN
8071: fnd_flex_descval.set_column_value(lot_dff(j).column_name, TO_NUMBER(lot_dff(j).column_value));
8072: ELSIF lot_dff(j).column_type = 'DATE' THEN
8073: fnd_flex_descval.set_column_value(lot_dff(j).column_name,
8074: fnd_date.canonical_to_date(lot_dff(j).column_value));
8075: END IF;

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

8069: fnd_flex_descval.set_column_value(lot_dff(j).column_name, lot_dff(j).column_value);
8070: ELSIF lot_dff(j).column_type = 'NUMBER' THEN
8071: fnd_flex_descval.set_column_value(lot_dff(j).column_name, TO_NUMBER(lot_dff(j).column_value));
8072: ELSIF lot_dff(j).column_type = 'DATE' THEN
8073: fnd_flex_descval.set_column_value(lot_dff(j).column_name,
8074: fnd_date.canonical_to_date(lot_dff(j).column_value));
8075: END IF;
8076:
8077: IF lot_dff(j).column_value IS NOT NULL THEN

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

8099: END LOOP;
8100: END IF;
8101: END LOOP;
8102: IF l_context IS NOT NULL AND l_context_enabled = TRUE AND l_global_nsegments > 0 then
8103: IF fnd_flex_descval.validate_desccols(appl_short_name => 'INV', desc_flex_name => 'Lot Attributes', values_or_ids => 'I'
8104: , validation_date => SYSDATE) THEN
8105: IF g_debug = 1 THEN
8106: print_debug('Value set validation successful', 9);
8107: print_debug('Program LOT_DFF_VALIDATE has completed succcessfuly', 9);

Line 8111: error_segment := fnd_flex_descval.error_segment;

8107: print_debug('Program LOT_DFF_VALIDATE has completed succcessfuly', 9);
8108: END IF;
8109: ELSE
8110: IF g_debug = 1 THEN
8111: error_segment := fnd_flex_descval.error_segment;
8112: print_debug('Value set validation failed for segment ' || error_segment, 9);
8113: RAISE errors_received;
8114: END IF;
8115: END IF;

Line 8135: error_msg := fnd_flex_descval.error_message;

8131: IF g_debug = 1 THEN
8132: print_debug('Program LOT_DFF_VALIDATE has completed with errors_received', 9);
8133: END IF;
8134:
8135: error_msg := fnd_flex_descval.error_message;
8136: s := 1;
8137: e := 200;
8138:
8139: --print_debug('Here are the error messages: ',9);