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.FND_FLEX_KEYVAL dependencies on FND_FLEX_SERVER

Line 28: value_vals FND_FLEX_SERVER1.ValueArray;

24: -- PRIVATE GLOBAL VARIABLES
25: --
26:
27: nvalidated NUMBER;
28: value_vals FND_FLEX_SERVER1.ValueArray;
29: value_svals FND_FLEX_SERVER1.ValueArray;
30: value_ids FND_FLEX_SERVER1.ValueIdArray;
31: value_descs FND_FLEX_SERVER1.ValueDescArray;
32: value_desclens FND_FLEX_SERVER1.NumberArray;

Line 29: value_svals FND_FLEX_SERVER1.ValueArray;

25: --
26:
27: nvalidated NUMBER;
28: value_vals FND_FLEX_SERVER1.ValueArray;
29: value_svals FND_FLEX_SERVER1.ValueArray;
30: value_ids FND_FLEX_SERVER1.ValueIdArray;
31: value_descs FND_FLEX_SERVER1.ValueDescArray;
32: value_desclens FND_FLEX_SERVER1.NumberArray;
33: cc_cols FND_FLEX_SERVER1.TabColArray;

Line 30: value_ids FND_FLEX_SERVER1.ValueIdArray;

26:
27: nvalidated NUMBER;
28: value_vals FND_FLEX_SERVER1.ValueArray;
29: value_svals FND_FLEX_SERVER1.ValueArray;
30: value_ids FND_FLEX_SERVER1.ValueIdArray;
31: value_descs FND_FLEX_SERVER1.ValueDescArray;
32: value_desclens FND_FLEX_SERVER1.NumberArray;
33: cc_cols FND_FLEX_SERVER1.TabColArray;
34: cc_coltypes FND_FLEX_SERVER1.CharArray;

Line 31: value_descs FND_FLEX_SERVER1.ValueDescArray;

27: nvalidated NUMBER;
28: value_vals FND_FLEX_SERVER1.ValueArray;
29: value_svals FND_FLEX_SERVER1.ValueArray;
30: value_ids FND_FLEX_SERVER1.ValueIdArray;
31: value_descs FND_FLEX_SERVER1.ValueDescArray;
32: value_desclens FND_FLEX_SERVER1.NumberArray;
33: cc_cols FND_FLEX_SERVER1.TabColArray;
34: cc_coltypes FND_FLEX_SERVER1.CharArray;
35: segtypes FND_FLEX_SERVER1.SegFormats;

Line 32: value_desclens FND_FLEX_SERVER1.NumberArray;

28: value_vals FND_FLEX_SERVER1.ValueArray;
29: value_svals FND_FLEX_SERVER1.ValueArray;
30: value_ids FND_FLEX_SERVER1.ValueIdArray;
31: value_descs FND_FLEX_SERVER1.ValueDescArray;
32: value_desclens FND_FLEX_SERVER1.NumberArray;
33: cc_cols FND_FLEX_SERVER1.TabColArray;
34: cc_coltypes FND_FLEX_SERVER1.CharArray;
35: segtypes FND_FLEX_SERVER1.SegFormats;
36: disp_segs FND_FLEX_SERVER1.DisplayedSegs;

Line 33: cc_cols FND_FLEX_SERVER1.TabColArray;

29: value_svals FND_FLEX_SERVER1.ValueArray;
30: value_ids FND_FLEX_SERVER1.ValueIdArray;
31: value_descs FND_FLEX_SERVER1.ValueDescArray;
32: value_desclens FND_FLEX_SERVER1.NumberArray;
33: cc_cols FND_FLEX_SERVER1.TabColArray;
34: cc_coltypes FND_FLEX_SERVER1.CharArray;
35: segtypes FND_FLEX_SERVER1.SegFormats;
36: disp_segs FND_FLEX_SERVER1.DisplayedSegs;
37: derv FND_FLEX_SERVER1.DerivedVals;

Line 34: cc_coltypes FND_FLEX_SERVER1.CharArray;

30: value_ids FND_FLEX_SERVER1.ValueIdArray;
31: value_descs FND_FLEX_SERVER1.ValueDescArray;
32: value_desclens FND_FLEX_SERVER1.NumberArray;
33: cc_cols FND_FLEX_SERVER1.TabColArray;
34: cc_coltypes FND_FLEX_SERVER1.CharArray;
35: segtypes FND_FLEX_SERVER1.SegFormats;
36: disp_segs FND_FLEX_SERVER1.DisplayedSegs;
37: derv FND_FLEX_SERVER1.DerivedVals;
38: tbl_derv FND_FLEX_SERVER1.DerivedVals;

Line 35: segtypes FND_FLEX_SERVER1.SegFormats;

31: value_descs FND_FLEX_SERVER1.ValueDescArray;
32: value_desclens FND_FLEX_SERVER1.NumberArray;
33: cc_cols FND_FLEX_SERVER1.TabColArray;
34: cc_coltypes FND_FLEX_SERVER1.CharArray;
35: segtypes FND_FLEX_SERVER1.SegFormats;
36: disp_segs FND_FLEX_SERVER1.DisplayedSegs;
37: derv FND_FLEX_SERVER1.DerivedVals;
38: tbl_derv FND_FLEX_SERVER1.DerivedVals;
39: drv_quals FND_FLEX_SERVER1.Qualifiers;

Line 36: disp_segs FND_FLEX_SERVER1.DisplayedSegs;

32: value_desclens FND_FLEX_SERVER1.NumberArray;
33: cc_cols FND_FLEX_SERVER1.TabColArray;
34: cc_coltypes FND_FLEX_SERVER1.CharArray;
35: segtypes FND_FLEX_SERVER1.SegFormats;
36: disp_segs FND_FLEX_SERVER1.DisplayedSegs;
37: derv FND_FLEX_SERVER1.DerivedVals;
38: tbl_derv FND_FLEX_SERVER1.DerivedVals;
39: drv_quals FND_FLEX_SERVER1.Qualifiers;
40: tbl_quals FND_FLEX_SERVER1.Qualifiers;

Line 37: derv FND_FLEX_SERVER1.DerivedVals;

33: cc_cols FND_FLEX_SERVER1.TabColArray;
34: cc_coltypes FND_FLEX_SERVER1.CharArray;
35: segtypes FND_FLEX_SERVER1.SegFormats;
36: disp_segs FND_FLEX_SERVER1.DisplayedSegs;
37: derv FND_FLEX_SERVER1.DerivedVals;
38: tbl_derv FND_FLEX_SERVER1.DerivedVals;
39: drv_quals FND_FLEX_SERVER1.Qualifiers;
40: tbl_quals FND_FLEX_SERVER1.Qualifiers;
41: n_xcol_vals NUMBER;

Line 38: tbl_derv FND_FLEX_SERVER1.DerivedVals;

34: cc_coltypes FND_FLEX_SERVER1.CharArray;
35: segtypes FND_FLEX_SERVER1.SegFormats;
36: disp_segs FND_FLEX_SERVER1.DisplayedSegs;
37: derv FND_FLEX_SERVER1.DerivedVals;
38: tbl_derv FND_FLEX_SERVER1.DerivedVals;
39: drv_quals FND_FLEX_SERVER1.Qualifiers;
40: tbl_quals FND_FLEX_SERVER1.Qualifiers;
41: n_xcol_vals NUMBER;
42: xcol_vals FND_FLEX_SERVER1.StringArray;

Line 39: drv_quals FND_FLEX_SERVER1.Qualifiers;

35: segtypes FND_FLEX_SERVER1.SegFormats;
36: disp_segs FND_FLEX_SERVER1.DisplayedSegs;
37: derv FND_FLEX_SERVER1.DerivedVals;
38: tbl_derv FND_FLEX_SERVER1.DerivedVals;
39: drv_quals FND_FLEX_SERVER1.Qualifiers;
40: tbl_quals FND_FLEX_SERVER1.Qualifiers;
41: n_xcol_vals NUMBER;
42: xcol_vals FND_FLEX_SERVER1.StringArray;
43: ccid NUMBER;

Line 40: tbl_quals FND_FLEX_SERVER1.Qualifiers;

36: disp_segs FND_FLEX_SERVER1.DisplayedSegs;
37: derv FND_FLEX_SERVER1.DerivedVals;
38: tbl_derv FND_FLEX_SERVER1.DerivedVals;
39: drv_quals FND_FLEX_SERVER1.Qualifiers;
40: tbl_quals FND_FLEX_SERVER1.Qualifiers;
41: n_xcol_vals NUMBER;
42: xcol_vals FND_FLEX_SERVER1.StringArray;
43: ccid NUMBER;
44: delim VARCHAR2(1);

Line 42: xcol_vals FND_FLEX_SERVER1.StringArray;

38: tbl_derv FND_FLEX_SERVER1.DerivedVals;
39: drv_quals FND_FLEX_SERVER1.Qualifiers;
40: tbl_quals FND_FLEX_SERVER1.Qualifiers;
41: n_xcol_vals NUMBER;
42: xcol_vals FND_FLEX_SERVER1.StringArray;
43: ccid NUMBER;
44: delim VARCHAR2(1);
45: err_segn NUMBER;
46: err_msg VARCHAR2(2000);

Line 149: FND_FLEX_SERVER.validation_engine(resp_apid, uresp_id, userid,

145: FND_MESSAGE.set_token('FUNCTNAME', operation);
146: goto cleanup_and_return;
147: end if;
148:
149: FND_FLEX_SERVER.validation_engine(resp_apid, uresp_id, userid,
150: appl_short_name, key_flex_code,
151: select_comb_from_view, structure_number,
152: validation_date, vrule, data_set, invoking_mode,
153: validate_mode, dins_flag, 'Y', required_flag, nulls_ok,

Line 165: sta_valid := (valid_stat = FND_FLEX_SERVER1.VV_VALID);

161:
162: -- Set status flags. Secured also set if any segment is secured and there
163: -- is some other error.
164: --
165: sta_valid := (valid_stat = FND_FLEX_SERVER1.VV_VALID);
166: sta_secured := ((valid_stat = FND_FLEX_SERVER1.VV_SECURED) or
167: (INSTR(segcodes, FND_FLEX_SERVER1.FF_VSECURED) > 0));
168: sta_value_err := (valid_stat = FND_FLEX_SERVER1.VV_VALUES);
169: sta_unsupported_err := (valid_stat = FND_FLEX_SERVER1.VV_UNSUPPORTED);

Line 166: sta_secured := ((valid_stat = FND_FLEX_SERVER1.VV_SECURED) or

162: -- Set status flags. Secured also set if any segment is secured and there
163: -- is some other error.
164: --
165: sta_valid := (valid_stat = FND_FLEX_SERVER1.VV_VALID);
166: sta_secured := ((valid_stat = FND_FLEX_SERVER1.VV_SECURED) or
167: (INSTR(segcodes, FND_FLEX_SERVER1.FF_VSECURED) > 0));
168: sta_value_err := (valid_stat = FND_FLEX_SERVER1.VV_VALUES);
169: sta_unsupported_err := (valid_stat = FND_FLEX_SERVER1.VV_UNSUPPORTED);
170: sta_serious_err := (valid_stat = FND_FLEX_SERVER1.VV_ERROR);

Line 167: (INSTR(segcodes, FND_FLEX_SERVER1.FF_VSECURED) > 0));

163: -- is some other error.
164: --
165: sta_valid := (valid_stat = FND_FLEX_SERVER1.VV_VALID);
166: sta_secured := ((valid_stat = FND_FLEX_SERVER1.VV_SECURED) or
167: (INSTR(segcodes, FND_FLEX_SERVER1.FF_VSECURED) > 0));
168: sta_value_err := (valid_stat = FND_FLEX_SERVER1.VV_VALUES);
169: sta_unsupported_err := (valid_stat = FND_FLEX_SERVER1.VV_UNSUPPORTED);
170: sta_serious_err := (valid_stat = FND_FLEX_SERVER1.VV_ERROR);
171:

Line 168: sta_value_err := (valid_stat = FND_FLEX_SERVER1.VV_VALUES);

164: --
165: sta_valid := (valid_stat = FND_FLEX_SERVER1.VV_VALID);
166: sta_secured := ((valid_stat = FND_FLEX_SERVER1.VV_SECURED) or
167: (INSTR(segcodes, FND_FLEX_SERVER1.FF_VSECURED) > 0));
168: sta_value_err := (valid_stat = FND_FLEX_SERVER1.VV_VALUES);
169: sta_unsupported_err := (valid_stat = FND_FLEX_SERVER1.VV_UNSUPPORTED);
170: sta_serious_err := (valid_stat = FND_FLEX_SERVER1.VV_ERROR);
171:
172: -- Get message if not valid.

Line 169: sta_unsupported_err := (valid_stat = FND_FLEX_SERVER1.VV_UNSUPPORTED);

165: sta_valid := (valid_stat = FND_FLEX_SERVER1.VV_VALID);
166: sta_secured := ((valid_stat = FND_FLEX_SERVER1.VV_SECURED) or
167: (INSTR(segcodes, FND_FLEX_SERVER1.FF_VSECURED) > 0));
168: sta_value_err := (valid_stat = FND_FLEX_SERVER1.VV_VALUES);
169: sta_unsupported_err := (valid_stat = FND_FLEX_SERVER1.VV_UNSUPPORTED);
170: sta_serious_err := (valid_stat = FND_FLEX_SERVER1.VV_ERROR);
171:
172: -- Get message if not valid.
173: -- Erase only the combination_id, and table columns if just checking

Line 170: sta_serious_err := (valid_stat = FND_FLEX_SERVER1.VV_ERROR);

166: sta_secured := ((valid_stat = FND_FLEX_SERVER1.VV_SECURED) or
167: (INSTR(segcodes, FND_FLEX_SERVER1.FF_VSECURED) > 0));
168: sta_value_err := (valid_stat = FND_FLEX_SERVER1.VV_VALUES);
169: sta_unsupported_err := (valid_stat = FND_FLEX_SERVER1.VV_UNSUPPORTED);
170: sta_serious_err := (valid_stat = FND_FLEX_SERVER1.VV_ERROR);
171:
172: -- Get message if not valid.
173: -- Erase only the combination_id, and table columns if just checking
174: -- segments, otherwise erase everything but the status and error message.

Line 242: FND_FLEX_SERVER.validation_engine(resp_apid, uresp_id, userid,

238: FND_MESSAGE.set_name('FND', 'FLEX-BAD SECURITY');
239: goto cleanup_and_return;
240: end if;
241:
242: FND_FLEX_SERVER.validation_engine(resp_apid, uresp_id, userid,
243: appl_short_name, key_flex_code,
244: select_comb_from_view, structure_number,
245: NULL, vrule, data_set, 'L', 'FULL', 'N', q_security, 'N', 'N',
246: displayable, NULL, 'V', NULL, NULL, NULL, get_columns,

Line 256: sta_valid := ((valid_stat = FND_FLEX_SERVER1.VV_VALID) or

252:
253: -- Set validation status flags.
254: -- Also valid if secured, but not enforcing it.
255: --
256: sta_valid := ((valid_stat = FND_FLEX_SERVER1.VV_VALID) or
257: ((valid_stat = FND_FLEX_SERVER1.VV_SECURED) and
258: (q_security <> 'Y')));
259: sta_secured := ((valid_stat = FND_FLEX_SERVER1.VV_SECURED) or
260: (INSTR(segcodes, FND_FLEX_SERVER1.FF_VSECURED) > 0));

Line 257: ((valid_stat = FND_FLEX_SERVER1.VV_SECURED) and

253: -- Set validation status flags.
254: -- Also valid if secured, but not enforcing it.
255: --
256: sta_valid := ((valid_stat = FND_FLEX_SERVER1.VV_VALID) or
257: ((valid_stat = FND_FLEX_SERVER1.VV_SECURED) and
258: (q_security <> 'Y')));
259: sta_secured := ((valid_stat = FND_FLEX_SERVER1.VV_SECURED) or
260: (INSTR(segcodes, FND_FLEX_SERVER1.FF_VSECURED) > 0));
261: sta_value_err := (valid_stat = FND_FLEX_SERVER1.VV_VALUES);

Line 259: sta_secured := ((valid_stat = FND_FLEX_SERVER1.VV_SECURED) or

255: --
256: sta_valid := ((valid_stat = FND_FLEX_SERVER1.VV_VALID) or
257: ((valid_stat = FND_FLEX_SERVER1.VV_SECURED) and
258: (q_security <> 'Y')));
259: sta_secured := ((valid_stat = FND_FLEX_SERVER1.VV_SECURED) or
260: (INSTR(segcodes, FND_FLEX_SERVER1.FF_VSECURED) > 0));
261: sta_value_err := (valid_stat = FND_FLEX_SERVER1.VV_VALUES);
262: sta_unsupported_err := (valid_stat = FND_FLEX_SERVER1.VV_UNSUPPORTED);
263: sta_serious_err := (valid_stat = FND_FLEX_SERVER1.VV_ERROR);

Line 260: (INSTR(segcodes, FND_FLEX_SERVER1.FF_VSECURED) > 0));

256: sta_valid := ((valid_stat = FND_FLEX_SERVER1.VV_VALID) or
257: ((valid_stat = FND_FLEX_SERVER1.VV_SECURED) and
258: (q_security <> 'Y')));
259: sta_secured := ((valid_stat = FND_FLEX_SERVER1.VV_SECURED) or
260: (INSTR(segcodes, FND_FLEX_SERVER1.FF_VSECURED) > 0));
261: sta_value_err := (valid_stat = FND_FLEX_SERVER1.VV_VALUES);
262: sta_unsupported_err := (valid_stat = FND_FLEX_SERVER1.VV_UNSUPPORTED);
263: sta_serious_err := (valid_stat = FND_FLEX_SERVER1.VV_ERROR);
264:

Line 261: sta_value_err := (valid_stat = FND_FLEX_SERVER1.VV_VALUES);

257: ((valid_stat = FND_FLEX_SERVER1.VV_SECURED) and
258: (q_security <> 'Y')));
259: sta_secured := ((valid_stat = FND_FLEX_SERVER1.VV_SECURED) or
260: (INSTR(segcodes, FND_FLEX_SERVER1.FF_VSECURED) > 0));
261: sta_value_err := (valid_stat = FND_FLEX_SERVER1.VV_VALUES);
262: sta_unsupported_err := (valid_stat = FND_FLEX_SERVER1.VV_UNSUPPORTED);
263: sta_serious_err := (valid_stat = FND_FLEX_SERVER1.VV_ERROR);
264:
265: -- Get message and erase all but error if not valid

Line 262: sta_unsupported_err := (valid_stat = FND_FLEX_SERVER1.VV_UNSUPPORTED);

258: (q_security <> 'Y')));
259: sta_secured := ((valid_stat = FND_FLEX_SERVER1.VV_SECURED) or
260: (INSTR(segcodes, FND_FLEX_SERVER1.FF_VSECURED) > 0));
261: sta_value_err := (valid_stat = FND_FLEX_SERVER1.VV_VALUES);
262: sta_unsupported_err := (valid_stat = FND_FLEX_SERVER1.VV_UNSUPPORTED);
263: sta_serious_err := (valid_stat = FND_FLEX_SERVER1.VV_ERROR);
264:
265: -- Get message and erase all but error if not valid
266: --

Line 263: sta_serious_err := (valid_stat = FND_FLEX_SERVER1.VV_ERROR);

259: sta_secured := ((valid_stat = FND_FLEX_SERVER1.VV_SECURED) or
260: (INSTR(segcodes, FND_FLEX_SERVER1.FF_VSECURED) > 0));
261: sta_value_err := (valid_stat = FND_FLEX_SERVER1.VV_VALUES);
262: sta_unsupported_err := (valid_stat = FND_FLEX_SERVER1.VV_UNSUPPORTED);
263: sta_serious_err := (valid_stat = FND_FLEX_SERVER1.VV_ERROR);
264:
265: -- Get message and erase all but error if not valid
266: --
267: <>

Line 349: return(FND_FLEX_SERVER.concatenate_values(nvalidated, value_vals,

345:
346: FUNCTION concatenated_values RETURN VARCHAR2 IS
347: BEGIN
348: IF (sta_valid) THEN
349: return(FND_FLEX_SERVER.concatenate_values(nvalidated, value_vals,
350: disp_segs, delim));
351: ELSE
352: raise_application_error
353: (-20001, ('Developer Error: KVL.concatenated_values should not ' ||

Line 362: return(FND_FLEX_SERVER.concatenate_ids(nvalidated, value_ids, delim));

358:
359: FUNCTION concatenated_ids RETURN VARCHAR2 IS
360: BEGIN
361: IF (sta_valid) THEN
362: return(FND_FLEX_SERVER.concatenate_ids(nvalidated, value_ids, delim));
363: ELSE
364: raise_application_error
365: (-20001, ('Developer Error: KVL.concatenated_ids should not ' ||
366: 'be called if validation fails.'));

Line 374: return(FND_FLEX_SERVER.concatenate_descriptions(nvalidated,

370:
371: FUNCTION concatenated_descriptions RETURN VARCHAR2 IS
372: BEGIN
373: IF (sta_valid) THEN
374: return(FND_FLEX_SERVER.concatenate_descriptions(nvalidated,
375: value_descs, disp_segs, value_desclens, delim));
376: ELSE
377: raise_application_error
378: (-20001, ('Developer Error: KVL.concatenated_descriptions should not '||

Line 464: return(SUBSTR(segcodes, segnum, 1) = FND_FLEX_SERVER1.FF_VVALID);

460:
461: FUNCTION segment_valid(segnum IN NUMBER) RETURN BOOLEAN IS
462: BEGIN
463: if((segcodes is not null) and (segnum between 1 and LENGTH(segcodes))) then
464: return(SUBSTR(segcodes, segnum, 1) = FND_FLEX_SERVER1.FF_VVALID);
465: end if;
466: return(FALSE);
467: END segment_valid;
468:

Line 560: if(FND_FLEX_SERVER1.init_globals = FALSE) then

556: BEGIN
557: --
558: -- Initialize messages, debugging, and number of sql strings
559: --
560: if(FND_FLEX_SERVER1.init_globals = FALSE) then
561: return(FALSE);
562: end if;
563:
564: --