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_EXT dependencies on FND_MESSAGE

Line 151: fnd_message.set_encoded(g_cache_value.varchar2_1);

147: ELSE
148: --
149: -- Error message.
150: --
151: fnd_message.set_encoded(g_cache_value.varchar2_1);
152: RETURN(fnd_plsql_cache.CACHE_INVALID);
153: END IF;
154: END IF;
155: RETURN(g_cache_return_code);

Line 177: l_enc_err_msg := fnd_message.get_encoded;

173: p_id_flex_num || '.' ||
174: p_ccid);
175:
176: IF (NOT p_is_valid) THEN
177: l_enc_err_msg := fnd_message.get_encoded;
178: fnd_message.set_encoded(l_enc_err_msg);
179: END IF;
180:
181: fnd_plsql_cache.generic_cache_new_value

Line 178: fnd_message.set_encoded(l_enc_err_msg);

174: p_ccid);
175:
176: IF (NOT p_is_valid) THEN
177: l_enc_err_msg := fnd_message.get_encoded;
178: fnd_message.set_encoded(l_enc_err_msg);
179: END IF;
180:
181: fnd_plsql_cache.generic_cache_new_value
182: (x_value => g_cache_value,

Line 217: PROCEDURE get_from_fnd_message

213: g_encoded_message := '';
214: g_message := '';
215: END init_message;
216:
217: PROCEDURE get_from_fnd_message
218: IS
219: BEGIN
220: IF (NOT g_is_message_get) THEN
221: --

Line 222: -- fnd_message.get_* removes message from stack.

218: IS
219: BEGIN
220: IF (NOT g_is_message_get) THEN
221: --
222: -- fnd_message.get_* removes message from stack.
223: -- put it back.
224: --
225: g_encoded_message := fnd_message.get_encoded;
226: fnd_message.set_encoded(g_encoded_message);

Line 225: g_encoded_message := fnd_message.get_encoded;

221: --
222: -- fnd_message.get_* removes message from stack.
223: -- put it back.
224: --
225: g_encoded_message := fnd_message.get_encoded;
226: fnd_message.set_encoded(g_encoded_message);
227:
228: g_message := fnd_message.get;
229: fnd_message.set_encoded(g_encoded_message);

Line 226: fnd_message.set_encoded(g_encoded_message);

222: -- fnd_message.get_* removes message from stack.
223: -- put it back.
224: --
225: g_encoded_message := fnd_message.get_encoded;
226: fnd_message.set_encoded(g_encoded_message);
227:
228: g_message := fnd_message.get;
229: fnd_message.set_encoded(g_encoded_message);
230:

Line 228: g_message := fnd_message.get;

224: --
225: g_encoded_message := fnd_message.get_encoded;
226: fnd_message.set_encoded(g_encoded_message);
227:
228: g_message := fnd_message.get;
229: fnd_message.set_encoded(g_encoded_message);
230:
231: g_is_message_get := TRUE;
232: END IF;

Line 229: fnd_message.set_encoded(g_encoded_message);

225: g_encoded_message := fnd_message.get_encoded;
226: fnd_message.set_encoded(g_encoded_message);
227:
228: g_message := fnd_message.get;
229: fnd_message.set_encoded(g_encoded_message);
230:
231: g_is_message_get := TRUE;
232: END IF;
233: EXCEPTION

Line 236: END get_from_fnd_message;

232: END IF;
233: EXCEPTION
234: WHEN OTHERS THEN
235: NULL;
236: END get_from_fnd_message;
237:
238: FUNCTION get_message RETURN VARCHAR2
239: IS
240: BEGIN

Line 242: get_from_fnd_message;

238: FUNCTION get_message RETURN VARCHAR2
239: IS
240: BEGIN
241: IF (g_is_failed) THEN
242: get_from_fnd_message;
243: RETURN g_message;
244: END IF;
245: RETURN('');
246: EXCEPTION

Line 255: get_from_fnd_message;

251: FUNCTION get_encoded_message RETURN VARCHAR2
252: IS
253: BEGIN
254: IF (g_is_failed) THEN
255: get_from_fnd_message;
256: RETURN g_encoded_message;
257: END IF;
258: RETURN('');
259: EXCEPTION

Line 295: FND_MESSAGE.raise_error;

291: IF (concat_segs(n_segments, segments, delimiter, catsegs)) then
292: return(catsegs);
293: ELSE
294: set_failed;
295: FND_MESSAGE.raise_error;
296: end if;
297: EXCEPTION
298: WHEN OTHERS THEN
299: set_failed;

Line 370: FND_MESSAGE.set_name('FND', 'FLEX-CANNOT FIND STRUCT DEF');

366: -- (application_short_name) (We should use p_* style, but it is late.)
367: --
368: EXCEPTION
369: WHEN NO_DATA_FOUND then
370: FND_MESSAGE.set_name('FND', 'FLEX-CANNOT FIND STRUCT DEF');
371: FND_MESSAGE.set_token('ROUTINE', 'FND_FLEX_EXT.GET_DELIMITER');
372: FND_MESSAGE.set_token('APPL', application_short_name);
373: FND_MESSAGE.set_token('CODE', key_flex_code);
374: FND_MESSAGE.set_token('NUM', to_char(structure_number));

Line 371: FND_MESSAGE.set_token('ROUTINE', 'FND_FLEX_EXT.GET_DELIMITER');

367: --
368: EXCEPTION
369: WHEN NO_DATA_FOUND then
370: FND_MESSAGE.set_name('FND', 'FLEX-CANNOT FIND STRUCT DEF');
371: FND_MESSAGE.set_token('ROUTINE', 'FND_FLEX_EXT.GET_DELIMITER');
372: FND_MESSAGE.set_token('APPL', application_short_name);
373: FND_MESSAGE.set_token('CODE', key_flex_code);
374: FND_MESSAGE.set_token('NUM', to_char(structure_number));
375: set_failed;

Line 372: FND_MESSAGE.set_token('APPL', application_short_name);

368: EXCEPTION
369: WHEN NO_DATA_FOUND then
370: FND_MESSAGE.set_name('FND', 'FLEX-CANNOT FIND STRUCT DEF');
371: FND_MESSAGE.set_token('ROUTINE', 'FND_FLEX_EXT.GET_DELIMITER');
372: FND_MESSAGE.set_token('APPL', application_short_name);
373: FND_MESSAGE.set_token('CODE', key_flex_code);
374: FND_MESSAGE.set_token('NUM', to_char(structure_number));
375: set_failed;
376: return(NULL);

Line 373: FND_MESSAGE.set_token('CODE', key_flex_code);

369: WHEN NO_DATA_FOUND then
370: FND_MESSAGE.set_name('FND', 'FLEX-CANNOT FIND STRUCT DEF');
371: FND_MESSAGE.set_token('ROUTINE', 'FND_FLEX_EXT.GET_DELIMITER');
372: FND_MESSAGE.set_token('APPL', application_short_name);
373: FND_MESSAGE.set_token('CODE', key_flex_code);
374: FND_MESSAGE.set_token('NUM', to_char(structure_number));
375: set_failed;
376: return(NULL);
377: WHEN TOO_MANY_ROWS then

Line 374: FND_MESSAGE.set_token('NUM', to_char(structure_number));

370: FND_MESSAGE.set_name('FND', 'FLEX-CANNOT FIND STRUCT DEF');
371: FND_MESSAGE.set_token('ROUTINE', 'FND_FLEX_EXT.GET_DELIMITER');
372: FND_MESSAGE.set_token('APPL', application_short_name);
373: FND_MESSAGE.set_token('CODE', key_flex_code);
374: FND_MESSAGE.set_token('NUM', to_char(structure_number));
375: set_failed;
376: return(NULL);
377: WHEN TOO_MANY_ROWS then
378: FND_MESSAGE.set_name('FND', 'FLEX-DUPLICATE STRUCT DEF');

Line 378: FND_MESSAGE.set_name('FND', 'FLEX-DUPLICATE STRUCT DEF');

374: FND_MESSAGE.set_token('NUM', to_char(structure_number));
375: set_failed;
376: return(NULL);
377: WHEN TOO_MANY_ROWS then
378: FND_MESSAGE.set_name('FND', 'FLEX-DUPLICATE STRUCT DEF');
379: FND_MESSAGE.set_token('ROUTINE', 'FND_FLEX_EXT.GET_DELIMITER');
380: FND_MESSAGE.set_token('APPL', application_short_name);
381: FND_MESSAGE.set_token('CODE', key_flex_code);
382: FND_MESSAGE.set_token('NUM', to_char(structure_number));

Line 379: FND_MESSAGE.set_token('ROUTINE', 'FND_FLEX_EXT.GET_DELIMITER');

375: set_failed;
376: return(NULL);
377: WHEN TOO_MANY_ROWS then
378: FND_MESSAGE.set_name('FND', 'FLEX-DUPLICATE STRUCT DEF');
379: FND_MESSAGE.set_token('ROUTINE', 'FND_FLEX_EXT.GET_DELIMITER');
380: FND_MESSAGE.set_token('APPL', application_short_name);
381: FND_MESSAGE.set_token('CODE', key_flex_code);
382: FND_MESSAGE.set_token('NUM', to_char(structure_number));
383: set_failed;

Line 380: FND_MESSAGE.set_token('APPL', application_short_name);

376: return(NULL);
377: WHEN TOO_MANY_ROWS then
378: FND_MESSAGE.set_name('FND', 'FLEX-DUPLICATE STRUCT DEF');
379: FND_MESSAGE.set_token('ROUTINE', 'FND_FLEX_EXT.GET_DELIMITER');
380: FND_MESSAGE.set_token('APPL', application_short_name);
381: FND_MESSAGE.set_token('CODE', key_flex_code);
382: FND_MESSAGE.set_token('NUM', to_char(structure_number));
383: set_failed;
384: return(NULL);

Line 381: FND_MESSAGE.set_token('CODE', key_flex_code);

377: WHEN TOO_MANY_ROWS then
378: FND_MESSAGE.set_name('FND', 'FLEX-DUPLICATE STRUCT DEF');
379: FND_MESSAGE.set_token('ROUTINE', 'FND_FLEX_EXT.GET_DELIMITER');
380: FND_MESSAGE.set_token('APPL', application_short_name);
381: FND_MESSAGE.set_token('CODE', key_flex_code);
382: FND_MESSAGE.set_token('NUM', to_char(structure_number));
383: set_failed;
384: return(NULL);
385: WHEN OTHERS then

Line 382: FND_MESSAGE.set_token('NUM', to_char(structure_number));

378: FND_MESSAGE.set_name('FND', 'FLEX-DUPLICATE STRUCT DEF');
379: FND_MESSAGE.set_token('ROUTINE', 'FND_FLEX_EXT.GET_DELIMITER');
380: FND_MESSAGE.set_token('APPL', application_short_name);
381: FND_MESSAGE.set_token('CODE', key_flex_code);
382: FND_MESSAGE.set_token('NUM', to_char(structure_number));
383: set_failed;
384: return(NULL);
385: WHEN OTHERS then
386: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');

Line 386: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');

382: FND_MESSAGE.set_token('NUM', to_char(structure_number));
383: set_failed;
384: return(NULL);
385: WHEN OTHERS then
386: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
387: FND_MESSAGE.set_token('MSG', 'EXT.get_delimiter() exception: ' || SQLERRM);
388: set_failed;
389: return(NULL);
390: END get_delimiter;

Line 387: FND_MESSAGE.set_token('MSG', 'EXT.get_delimiter() exception: ' || SQLERRM);

383: set_failed;
384: return(NULL);
385: WHEN OTHERS then
386: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
387: FND_MESSAGE.set_token('MSG', 'EXT.get_delimiter() exception: ' || SQLERRM);
388: set_failed;
389: return(NULL);
390: END get_delimiter;
391:

Line 426: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');

422: return(0);
423:
424: EXCEPTION
425: WHEN OTHERS then
426: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
427: FND_MESSAGE.set_token('MSG', 'get_ccid() exception: ' || SQLERRM);
428: set_failed;
429: return(0);
430:

Line 427: FND_MESSAGE.set_token('MSG', 'get_ccid() exception: ' || SQLERRM);

423:
424: EXCEPTION
425: WHEN OTHERS then
426: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
427: FND_MESSAGE.set_token('MSG', 'get_ccid() exception: ' || SQLERRM);
428: set_failed;
429: return(0);
430:
431: END get_ccid;

Line 437: /* on server using FND_MESSAGE if invalid. */

433: /* ------------------------------------------------------------------------ */
434: /* Finds combination_id for given segment values. */
435: /* If validation date is NULL checks all cross-validation rules. */
436: /* Returns TRUE if combination valid, or FALSE and sets error message */
437: /* on server using FND_MESSAGE if invalid. */
438: /* ------------------------------------------------------------------------ */
439: FUNCTION get_combination_id(application_short_name IN VARCHAR2,
440: key_flex_code IN VARCHAR2,
441: structure_number IN NUMBER,

Line 478: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');

474: return(FALSE);
475:
476: EXCEPTION
477: WHEN OTHERS then
478: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
479: FND_MESSAGE.set_token('MSG','get_combination_id() exception: '||SQLERRM);
480: set_failed;
481: return(FALSE);
482:

Line 479: FND_MESSAGE.set_token('MSG','get_combination_id() exception: '||SQLERRM);

475:
476: EXCEPTION
477: WHEN OTHERS then
478: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
479: FND_MESSAGE.set_token('MSG','get_combination_id() exception: '||SQLERRM);
480: set_failed;
481: return(FALSE);
482:
483: END get_combination_id;

Line 519: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');

515: return(FALSE);
516:
517: EXCEPTION
518: WHEN OTHERS then
519: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
520: FND_MESSAGE.set_token('MSG','get_combination_id() exception: '||SQLERRM);
521: set_failed;
522: return(FALSE);
523:

Line 520: FND_MESSAGE.set_token('MSG','get_combination_id() exception: '||SQLERRM);

516:
517: EXCEPTION
518: WHEN OTHERS then
519: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
520: FND_MESSAGE.set_token('MSG','get_combination_id() exception: '||SQLERRM);
521: set_failed;
522: return(FALSE);
523:
524: END get_combination_id;

Line 559: /* returns FALSE and sets error using FND_MESSAGE on the server. */

555:
556: /* ------------------------------------------------------------------------ */
557: /* Returns segment values for the given combination id in the */
558: /* specified flexfield. Returns TRUE if combination found, otherwise */
559: /* returns FALSE and sets error using FND_MESSAGE on the server. */
560: /* Does not check value security rules. */
561: /* Concatenated segment string is NULL if error. */
562: /* ------------------------------------------------------------------------ */
563:

Line 588: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');

584: return(FALSE);
585:
586: EXCEPTION
587: WHEN OTHERS then
588: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
589: FND_MESSAGE.set_token('MSG', 'get_segments() exception: ' || SQLERRM);
590: set_failed;
591: return(FALSE);
592:

Line 589: FND_MESSAGE.set_token('MSG', 'get_segments() exception: ' || SQLERRM);

585:
586: EXCEPTION
587: WHEN OTHERS then
588: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
589: FND_MESSAGE.set_token('MSG', 'get_segments() exception: ' || SQLERRM);
590: set_failed;
591: return(FALSE);
592:
593: END get_segments;

Line 598: /* returns FALSE and sets error using FND_MESSAGE on the server. */

594:
595: /* ------------------------------------------------------------------------ */
596: /* Returns segment values for the given combination id in the */
597: /* specified flexfield. Returns TRUE if combination found, otherwise */
598: /* returns FALSE and sets error using FND_MESSAGE on the server. */
599: /* n_segments is 0 and no elements of segments array are assigned if */
600: /* combination not found or on error. */
601: /* Does not check value security rules. */
602: /* ------------------------------------------------------------------------ */

Line 702: FND_MESSAGE.set_name('FND','FLEX-BAD CCID INPUT');

698:
699: -- Check CCID.
700: --
701: IF ((combination_id IS NULL) OR (combination_id < 0)) THEN
702: FND_MESSAGE.set_name('FND','FLEX-BAD CCID INPUT');
703: FND_MESSAGE.set_token('CCID',to_char(combination_id));
704: GOTO label_failure;
705: END IF;
706:

Line 703: FND_MESSAGE.set_token('CCID',to_char(combination_id));

699: -- Check CCID.
700: --
701: IF ((combination_id IS NULL) OR (combination_id < 0)) THEN
702: FND_MESSAGE.set_name('FND','FLEX-BAD CCID INPUT');
703: FND_MESSAGE.set_token('CCID',to_char(combination_id));
704: GOTO label_failure;
705: END IF;
706:
707: -- Read structure and comb. table information.

Line 758: FND_MESSAGE.set_name('FND', 'FLEX-COMBINATION NOT FOUND');

754: segtypes, 0, tmp_qualcols, 0, tmp_xcolnames, NULL, ccid,
755: value_ids, tbl_derv, drv_quals.sq_values, xcol_vals);
756:
757: if (nfound = 0) then
758: FND_MESSAGE.set_name('FND', 'FLEX-COMBINATION NOT FOUND');
759: FND_MESSAGE.set_token('CCID', combination_id);
760: FND_MESSAGE.set_token('APNM', application_short_name);
761: FND_MESSAGE.set_token('CODE', key_flex_code);
762: FND_MESSAGE.set_token('NUM', structure_number);

Line 759: FND_MESSAGE.set_token('CCID', combination_id);

755: value_ids, tbl_derv, drv_quals.sq_values, xcol_vals);
756:
757: if (nfound = 0) then
758: FND_MESSAGE.set_name('FND', 'FLEX-COMBINATION NOT FOUND');
759: FND_MESSAGE.set_token('CCID', combination_id);
760: FND_MESSAGE.set_token('APNM', application_short_name);
761: FND_MESSAGE.set_token('CODE', key_flex_code);
762: FND_MESSAGE.set_token('NUM', structure_number);
763: end if;

Line 760: FND_MESSAGE.set_token('APNM', application_short_name);

756:
757: if (nfound = 0) then
758: FND_MESSAGE.set_name('FND', 'FLEX-COMBINATION NOT FOUND');
759: FND_MESSAGE.set_token('CCID', combination_id);
760: FND_MESSAGE.set_token('APNM', application_short_name);
761: FND_MESSAGE.set_token('CODE', key_flex_code);
762: FND_MESSAGE.set_token('NUM', structure_number);
763: end if;
764: if (nfound <> 1) THEN

Line 761: FND_MESSAGE.set_token('CODE', key_flex_code);

757: if (nfound = 0) then
758: FND_MESSAGE.set_name('FND', 'FLEX-COMBINATION NOT FOUND');
759: FND_MESSAGE.set_token('CCID', combination_id);
760: FND_MESSAGE.set_token('APNM', application_short_name);
761: FND_MESSAGE.set_token('CODE', key_flex_code);
762: FND_MESSAGE.set_token('NUM', structure_number);
763: end if;
764: if (nfound <> 1) THEN
765: GOTO label_failure;

Line 762: FND_MESSAGE.set_token('NUM', structure_number);

758: FND_MESSAGE.set_name('FND', 'FLEX-COMBINATION NOT FOUND');
759: FND_MESSAGE.set_token('CCID', combination_id);
760: FND_MESSAGE.set_token('APNM', application_short_name);
761: FND_MESSAGE.set_token('CODE', key_flex_code);
762: FND_MESSAGE.set_token('NUM', structure_number);
763: end if;
764: if (nfound <> 1) THEN
765: GOTO label_failure;
766: end if;

Line 854: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');

850: RETURN(FALSE);
851:
852: EXCEPTION
853: WHEN OTHERS then
854: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
855: FND_MESSAGE.set_token('MSG', 'get_segments() exception: ' || SQLERRM);
856: set_failed;
857: return(FALSE);
858:

Line 855: FND_MESSAGE.set_token('MSG', 'get_segments() exception: ' || SQLERRM);

851:
852: EXCEPTION
853: WHEN OTHERS then
854: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
855: FND_MESSAGE.set_token('MSG', 'get_segments() exception: ' || SQLERRM);
856: set_failed;
857: return(FALSE);
858:
859: END get_segments;

Line 867: /* on server using FND_MESSAGE if invalid. */

863: /* If validation date is NULL checks all cross-validation rules. */
864: /* If combination doesn't exist, inserts combination, even if dynamic */
865: /* insert is disabled */
866: /* Returns TRUE if combination valid, or FALSE and sets error message */
867: /* on server using FND_MESSAGE if invalid. */
868: /* ------------------------------------------------------------------------ */
869: FUNCTION get_comb_id_allow_insert(application_short_name IN VARCHAR2,
870: key_flex_code IN VARCHAR2,
871: structure_number IN NUMBER,

Line 919: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');

915: return(FALSE);
916:
917: EXCEPTION
918: WHEN OTHERS then
919: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
920: FND_MESSAGE.set_token('MSG','get_combination_id() exception: '||SQLERRM);
921: set_failed;
922: return(FALSE);
923:

Line 920: FND_MESSAGE.set_token('MSG','get_combination_id() exception: '||SQLERRM);

916:
917: EXCEPTION
918: WHEN OTHERS then
919: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
920: FND_MESSAGE.set_token('MSG','get_combination_id() exception: '||SQLERRM);
921: set_failed;
922: return(FALSE);
923:
924: END get_comb_id_allow_insert;

Line 961: FND_MESSAGE.set_name('FND', 'FLEX-CANT FIND SEGMENTS');

957: disp_segs.segflags(ncols) := (seg.display_flag = 'Y');
958: end loop;
959:
960: if(ncols < 1) then
961: FND_MESSAGE.set_name('FND', 'FLEX-CANT FIND SEGMENTS');
962: FND_MESSAGE.set_token('ROUTINE', 'FND_FLEX_EXT.read_displayedsegs()');
963: FND_MESSAGE.set_token('APPID', to_char(fstruct.application_id));
964: FND_MESSAGE.set_token('CODE', fstruct.id_flex_code);
965: FND_MESSAGE.set_token('NUM', to_char(fstruct.id_flex_num));

Line 962: FND_MESSAGE.set_token('ROUTINE', 'FND_FLEX_EXT.read_displayedsegs()');

958: end loop;
959:
960: if(ncols < 1) then
961: FND_MESSAGE.set_name('FND', 'FLEX-CANT FIND SEGMENTS');
962: FND_MESSAGE.set_token('ROUTINE', 'FND_FLEX_EXT.read_displayedsegs()');
963: FND_MESSAGE.set_token('APPID', to_char(fstruct.application_id));
964: FND_MESSAGE.set_token('CODE', fstruct.id_flex_code);
965: FND_MESSAGE.set_token('NUM', to_char(fstruct.id_flex_num));
966: return(FALSE);

Line 963: FND_MESSAGE.set_token('APPID', to_char(fstruct.application_id));

959:
960: if(ncols < 1) then
961: FND_MESSAGE.set_name('FND', 'FLEX-CANT FIND SEGMENTS');
962: FND_MESSAGE.set_token('ROUTINE', 'FND_FLEX_EXT.read_displayedsegs()');
963: FND_MESSAGE.set_token('APPID', to_char(fstruct.application_id));
964: FND_MESSAGE.set_token('CODE', fstruct.id_flex_code);
965: FND_MESSAGE.set_token('NUM', to_char(fstruct.id_flex_num));
966: return(FALSE);
967: end if;

Line 964: FND_MESSAGE.set_token('CODE', fstruct.id_flex_code);

960: if(ncols < 1) then
961: FND_MESSAGE.set_name('FND', 'FLEX-CANT FIND SEGMENTS');
962: FND_MESSAGE.set_token('ROUTINE', 'FND_FLEX_EXT.read_displayedsegs()');
963: FND_MESSAGE.set_token('APPID', to_char(fstruct.application_id));
964: FND_MESSAGE.set_token('CODE', fstruct.id_flex_code);
965: FND_MESSAGE.set_token('NUM', to_char(fstruct.id_flex_num));
966: return(FALSE);
967: end if;
968:

Line 965: FND_MESSAGE.set_token('NUM', to_char(fstruct.id_flex_num));

961: FND_MESSAGE.set_name('FND', 'FLEX-CANT FIND SEGMENTS');
962: FND_MESSAGE.set_token('ROUTINE', 'FND_FLEX_EXT.read_displayedsegs()');
963: FND_MESSAGE.set_token('APPID', to_char(fstruct.application_id));
964: FND_MESSAGE.set_token('CODE', fstruct.id_flex_code);
965: FND_MESSAGE.set_token('NUM', to_char(fstruct.id_flex_num));
966: return(FALSE);
967: end if;
968:
969: disp_segs.n_segflags := ncols;

Line 975: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');

971: return(TRUE);
972:
973: EXCEPTION
974: WHEN OTHERS then
975: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
976: FND_MESSAGE.set_token('MSG', 'read_displayedsegs() exception: '||SQLERRM);
977: return(FALSE);
978:
979: END read_displayedsegs;

Line 976: FND_MESSAGE.set_token('MSG', 'read_displayedsegs() exception: '||SQLERRM);

972:
973: EXCEPTION
974: WHEN OTHERS then
975: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
976: FND_MESSAGE.set_token('MSG', 'read_displayedsegs() exception: '||SQLERRM);
977: return(FALSE);
978:
979: END read_displayedsegs;
980:

Line 1010: FND_MESSAGE.set_name('FND', 'FLEX-CANNOT FIND STRUCT DEF');

1006: RETURN(true);
1007:
1008: EXCEPTION
1009: WHEN NO_DATA_FOUND then
1010: FND_MESSAGE.set_name('FND', 'FLEX-CANNOT FIND STRUCT DEF');
1011: FND_MESSAGE.set_token('ROUTINE', 'FND_FLEX_EXT.is_allow_id_value_sets');
1012: FND_MESSAGE.set_token('APPL', i_application_short_name);
1013: FND_MESSAGE.set_token('CODE', i_id_flex_code);
1014: FND_MESSAGE.set_token('NUM', null);

Line 1011: FND_MESSAGE.set_token('ROUTINE', 'FND_FLEX_EXT.is_allow_id_value_sets');

1007:
1008: EXCEPTION
1009: WHEN NO_DATA_FOUND then
1010: FND_MESSAGE.set_name('FND', 'FLEX-CANNOT FIND STRUCT DEF');
1011: FND_MESSAGE.set_token('ROUTINE', 'FND_FLEX_EXT.is_allow_id_value_sets');
1012: FND_MESSAGE.set_token('APPL', i_application_short_name);
1013: FND_MESSAGE.set_token('CODE', i_id_flex_code);
1014: FND_MESSAGE.set_token('NUM', null);
1015: return(FALSE);

Line 1012: FND_MESSAGE.set_token('APPL', i_application_short_name);

1008: EXCEPTION
1009: WHEN NO_DATA_FOUND then
1010: FND_MESSAGE.set_name('FND', 'FLEX-CANNOT FIND STRUCT DEF');
1011: FND_MESSAGE.set_token('ROUTINE', 'FND_FLEX_EXT.is_allow_id_value_sets');
1012: FND_MESSAGE.set_token('APPL', i_application_short_name);
1013: FND_MESSAGE.set_token('CODE', i_id_flex_code);
1014: FND_MESSAGE.set_token('NUM', null);
1015: return(FALSE);
1016: WHEN TOO_MANY_ROWS then

Line 1013: FND_MESSAGE.set_token('CODE', i_id_flex_code);

1009: WHEN NO_DATA_FOUND then
1010: FND_MESSAGE.set_name('FND', 'FLEX-CANNOT FIND STRUCT DEF');
1011: FND_MESSAGE.set_token('ROUTINE', 'FND_FLEX_EXT.is_allow_id_value_sets');
1012: FND_MESSAGE.set_token('APPL', i_application_short_name);
1013: FND_MESSAGE.set_token('CODE', i_id_flex_code);
1014: FND_MESSAGE.set_token('NUM', null);
1015: return(FALSE);
1016: WHEN TOO_MANY_ROWS then
1017: FND_MESSAGE.set_name('FND', 'FLEX-DUPLICATE STRUCT DEF');

Line 1014: FND_MESSAGE.set_token('NUM', null);

1010: FND_MESSAGE.set_name('FND', 'FLEX-CANNOT FIND STRUCT DEF');
1011: FND_MESSAGE.set_token('ROUTINE', 'FND_FLEX_EXT.is_allow_id_value_sets');
1012: FND_MESSAGE.set_token('APPL', i_application_short_name);
1013: FND_MESSAGE.set_token('CODE', i_id_flex_code);
1014: FND_MESSAGE.set_token('NUM', null);
1015: return(FALSE);
1016: WHEN TOO_MANY_ROWS then
1017: FND_MESSAGE.set_name('FND', 'FLEX-DUPLICATE STRUCT DEF');
1018: FND_MESSAGE.set_token('ROUTINE', 'FND_FLEX_EXT.is_allow_id_value_sets');

Line 1017: FND_MESSAGE.set_name('FND', 'FLEX-DUPLICATE STRUCT DEF');

1013: FND_MESSAGE.set_token('CODE', i_id_flex_code);
1014: FND_MESSAGE.set_token('NUM', null);
1015: return(FALSE);
1016: WHEN TOO_MANY_ROWS then
1017: FND_MESSAGE.set_name('FND', 'FLEX-DUPLICATE STRUCT DEF');
1018: FND_MESSAGE.set_token('ROUTINE', 'FND_FLEX_EXT.is_allow_id_value_sets');
1019: FND_MESSAGE.set_token('APPL', i_application_short_name);
1020: FND_MESSAGE.set_token('CODE', i_id_flex_code);
1021: FND_MESSAGE.set_token('NUM', null);

Line 1018: FND_MESSAGE.set_token('ROUTINE', 'FND_FLEX_EXT.is_allow_id_value_sets');

1014: FND_MESSAGE.set_token('NUM', null);
1015: return(FALSE);
1016: WHEN TOO_MANY_ROWS then
1017: FND_MESSAGE.set_name('FND', 'FLEX-DUPLICATE STRUCT DEF');
1018: FND_MESSAGE.set_token('ROUTINE', 'FND_FLEX_EXT.is_allow_id_value_sets');
1019: FND_MESSAGE.set_token('APPL', i_application_short_name);
1020: FND_MESSAGE.set_token('CODE', i_id_flex_code);
1021: FND_MESSAGE.set_token('NUM', null);
1022: return(FALSE);

Line 1019: FND_MESSAGE.set_token('APPL', i_application_short_name);

1015: return(FALSE);
1016: WHEN TOO_MANY_ROWS then
1017: FND_MESSAGE.set_name('FND', 'FLEX-DUPLICATE STRUCT DEF');
1018: FND_MESSAGE.set_token('ROUTINE', 'FND_FLEX_EXT.is_allow_id_value_sets');
1019: FND_MESSAGE.set_token('APPL', i_application_short_name);
1020: FND_MESSAGE.set_token('CODE', i_id_flex_code);
1021: FND_MESSAGE.set_token('NUM', null);
1022: return(FALSE);
1023: WHEN others THEN

Line 1020: FND_MESSAGE.set_token('CODE', i_id_flex_code);

1016: WHEN TOO_MANY_ROWS then
1017: FND_MESSAGE.set_name('FND', 'FLEX-DUPLICATE STRUCT DEF');
1018: FND_MESSAGE.set_token('ROUTINE', 'FND_FLEX_EXT.is_allow_id_value_sets');
1019: FND_MESSAGE.set_token('APPL', i_application_short_name);
1020: FND_MESSAGE.set_token('CODE', i_id_flex_code);
1021: FND_MESSAGE.set_token('NUM', null);
1022: return(FALSE);
1023: WHEN others THEN
1024: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');

Line 1021: FND_MESSAGE.set_token('NUM', null);

1017: FND_MESSAGE.set_name('FND', 'FLEX-DUPLICATE STRUCT DEF');
1018: FND_MESSAGE.set_token('ROUTINE', 'FND_FLEX_EXT.is_allow_id_value_sets');
1019: FND_MESSAGE.set_token('APPL', i_application_short_name);
1020: FND_MESSAGE.set_token('CODE', i_id_flex_code);
1021: FND_MESSAGE.set_token('NUM', null);
1022: return(FALSE);
1023: WHEN others THEN
1024: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
1025: FND_MESSAGE.set_token('MSG','is_allow_valuesets() exception: '||SQLERRM);

Line 1024: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');

1020: FND_MESSAGE.set_token('CODE', i_id_flex_code);
1021: FND_MESSAGE.set_token('NUM', null);
1022: return(FALSE);
1023: WHEN others THEN
1024: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
1025: FND_MESSAGE.set_token('MSG','is_allow_valuesets() exception: '||SQLERRM);
1026: return(false);
1027:
1028: END is_allow_id_valuesets;

Line 1025: FND_MESSAGE.set_token('MSG','is_allow_valuesets() exception: '||SQLERRM);

1021: FND_MESSAGE.set_token('NUM', null);
1022: return(FALSE);
1023: WHEN others THEN
1024: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
1025: FND_MESSAGE.set_token('MSG','is_allow_valuesets() exception: '||SQLERRM);
1026: return(false);
1027:
1028: END is_allow_id_valuesets;
1029:

Line 1048: FND_MESSAGE.set_name('FND', 'FLEX-BAD VDATE STRING');

1044: return(TRUE);
1045:
1046: EXCEPTION
1047: WHEN OTHERS then
1048: FND_MESSAGE.set_name('FND', 'FLEX-BAD VDATE STRING');
1049: return(FALSE);
1050:
1051: END convert_vdate;
1052:

Line 1075: FND_MESSAGE.set_name('FND', 'FLEX-BAD SEGMENT ARRAY');

1071: return(TRUE);
1072:
1073: EXCEPTION
1074: WHEN OTHERS then
1075: FND_MESSAGE.set_name('FND', 'FLEX-BAD SEGMENT ARRAY');
1076: return(FALSE);
1077:
1078: END concat_segs;
1079:

Line 1084: /* Returns FALSE and sets FND_MESSAGE on error. */

1080: /* ------------------------------------------------------------------------ */
1081: /* Copies varchar2 string to output and traps exception raised if */
1082: /* the user's output string buffer is not big enough to hold the */
1083: /* input string. */
1084: /* Returns FALSE and sets FND_MESSAGE on error. */
1085: /* ------------------------------------------------------------------------ */
1086: FUNCTION output_string(s IN VARCHAR2,
1087: s_out OUT nocopy VARCHAR2) RETURN BOOLEAN IS
1088: BEGIN

Line 1093: FND_MESSAGE.set_name(NULL, 'FLEX-BUFFER TOO SMALL');

1089: s_out := s;
1090: return(TRUE);
1091: EXCEPTION
1092: WHEN OTHERS then
1093: FND_MESSAGE.set_name(NULL, 'FLEX-BUFFER TOO SMALL');
1094: FND_MESSAGE.set_token('EXCEPTION', SQLERRM);
1095: return(FALSE);
1096: END output_string;
1097:

Line 1094: FND_MESSAGE.set_token('EXCEPTION', SQLERRM);

1090: return(TRUE);
1091: EXCEPTION
1092: WHEN OTHERS then
1093: FND_MESSAGE.set_name(NULL, 'FLEX-BUFFER TOO SMALL');
1094: FND_MESSAGE.set_token('EXCEPTION', SQLERRM);
1095: return(FALSE);
1096: END output_string;
1097:
1098: /* ----------------------------------------------------------------------- */