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

Line 285: FND_MESSAGE.set_name('FND', 'FLEX-CONCAT LEN > IAPFLEN');

281:
282: -- Limit concatenated segment length for compatibility with client
283: --
284: if(LENGTHB(concat_segs) > MAX_CATSEG_LEN) then
285: FND_MESSAGE.set_name('FND', 'FLEX-CONCAT LEN > IAPFLEN');
286: FND_MESSAGE.set_token('MAXFLDLEN', to_char(MAX_CATSEG_LEN));
287: goto return_error;
288: end if;
289:

Line 286: FND_MESSAGE.set_token('MAXFLDLEN', to_char(MAX_CATSEG_LEN));

282: -- Limit concatenated segment length for compatibility with client
283: --
284: if(LENGTHB(concat_segs) > MAX_CATSEG_LEN) then
285: FND_MESSAGE.set_name('FND', 'FLEX-CONCAT LEN > IAPFLEN');
286: FND_MESSAGE.set_token('MAXFLDLEN', to_char(MAX_CATSEG_LEN));
287: goto return_error;
288: end if;
289:
290: -- First check that operation makes sense

Line 294: FND_MESSAGE.set_name('FND', 'FLEX-SSV BAD INVOKE');

290: -- First check that operation makes sense
291: --
292: if((invoking_mode is null) or
293: (invoking_mode NOT IN ('V', 'P', 'L', 'C', 'D'))) then
294: FND_MESSAGE.set_name('FND', 'FLEX-SSV BAD INVOKE');
295: goto return_error;
296: end if;
297:
298: -- Set validation flags.

Line 403: FND_MESSAGE.set_name('FND', 'FLEX-TOO MANY SEGS');

399: if(nsegs > MAX_NSEGS) then
400: if (l_context_Segment_included and (nsegs = MAX_NSEGS + 1)) then
401: NULL;
402: else
403: FND_MESSAGE.set_name('FND', 'FLEX-TOO MANY SEGS');
404: FND_MESSAGE.set_token('NSEGS', MAX_NSEGS);
405: goto return_error;
406: end if;
407: END IF;

Line 404: FND_MESSAGE.set_token('NSEGS', MAX_NSEGS);

400: if (l_context_Segment_included and (nsegs = MAX_NSEGS + 1)) then
401: NULL;
402: else
403: FND_MESSAGE.set_name('FND', 'FLEX-TOO MANY SEGS');
404: FND_MESSAGE.set_token('NSEGS', MAX_NSEGS);
405: goto return_error;
406: end if;
407: END IF;
408:

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

463: return;
464:
465: EXCEPTION
466: WHEN OTHERS then
467: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
468: FND_MESSAGE.set_token('MSG','descval_engine() exception: ' || SQLERRM);
469: v_status := FND_FLEX_SERVER1.VV_ERROR;
470: return;
471: END descval_engine;

Line 468: FND_MESSAGE.set_token('MSG','descval_engine() exception: ' || SQLERRM);

464:
465: EXCEPTION
466: WHEN OTHERS then
467: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
468: FND_MESSAGE.set_token('MSG','descval_engine() exception: ' || SQLERRM);
469: v_status := FND_FLEX_SERVER1.VV_ERROR;
470: return;
471: END descval_engine;
472:

Line 483: /* Returns TRUE if all ok, or FALSE and sets FND_MESSAGE on error. */

479: /* concatenated ids rather than the individual segment fields. */
480: /* Returns segment ids for all enabled segments whether or not they */
481: /* are displayed in the order that they are displayed within each */
482: /* context. */
483: /* Returns TRUE if all ok, or FALSE and sets FND_MESSAGE on error. */
484: /* ------------------------------------------------------------------------ */
485:
486: FUNCTION find_descsegs(dflex_info IN FND_FLEX_SERVER1.DescFlexInfo,
487: row_id IN ROWID,

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

517: return(read_segment_cols(dflex_info, row_id, effective_table,
518: vflags, nsegs_out, segs_out));
519: EXCEPTION
520: WHEN OTHERS then
521: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
522: FND_MESSAGE.set_token('MSG','find_descsegs() exception: ' || SQLERRM);
523: return(FALSE);
524:
525: END find_descsegs;

Line 522: FND_MESSAGE.set_token('MSG','find_descsegs() exception: ' || SQLERRM);

518: vflags, nsegs_out, segs_out));
519: EXCEPTION
520: WHEN OTHERS then
521: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
522: FND_MESSAGE.set_token('MSG','find_descsegs() exception: ' || SQLERRM);
523: return(FALSE);
524:
525: END find_descsegs;
526:

Line 531: /* Returns TRUE on success or FALSE and sets FND_MESSAGE on error. */

527: /* ------------------------------------------------------------------------ */
528: /* Reads concatenated segment ids from data field in the particular */
529: /* row of the specified table. Breaks up concatenated segments into */
530: /* a string array for return. */
531: /* Returns TRUE on success or FALSE and sets FND_MESSAGE on error. */
532: /* ------------------------------------------------------------------------ */
533:
534: FUNCTION read_datafield(dflex_info IN FND_FLEX_SERVER1.DescFlexInfo,
535: row_id IN ROWID,

Line 562: FND_MESSAGE.set_name('FND', 'FLEX-DFF ROW NOT FOUND');

558: --
559: rstat := FND_FLEX_SERVER1.x_dsql_select_one(concat_segids);
560: if(rstat <> 1) then
561: if(rstat = 0) then
562: FND_MESSAGE.set_name('FND', 'FLEX-DFF ROW NOT FOUND');
563: FND_MESSAGE.set_token('TABLE', table_name);
564: FND_MESSAGE.set_token('ROWID', ROWIDTOCHAR(row_id));
565: elsif(rstat = -2) then
566: FND_MESSAGE.set_name('FND', 'FLEX-DFF BAD DATAFIELD');

Line 563: FND_MESSAGE.set_token('TABLE', table_name);

559: rstat := FND_FLEX_SERVER1.x_dsql_select_one(concat_segids);
560: if(rstat <> 1) then
561: if(rstat = 0) then
562: FND_MESSAGE.set_name('FND', 'FLEX-DFF ROW NOT FOUND');
563: FND_MESSAGE.set_token('TABLE', table_name);
564: FND_MESSAGE.set_token('ROWID', ROWIDTOCHAR(row_id));
565: elsif(rstat = -2) then
566: FND_MESSAGE.set_name('FND', 'FLEX-DFF BAD DATAFIELD');
567: FND_MESSAGE.set_token('TABLE', table_name);

Line 564: FND_MESSAGE.set_token('ROWID', ROWIDTOCHAR(row_id));

560: if(rstat <> 1) then
561: if(rstat = 0) then
562: FND_MESSAGE.set_name('FND', 'FLEX-DFF ROW NOT FOUND');
563: FND_MESSAGE.set_token('TABLE', table_name);
564: FND_MESSAGE.set_token('ROWID', ROWIDTOCHAR(row_id));
565: elsif(rstat = -2) then
566: FND_MESSAGE.set_name('FND', 'FLEX-DFF BAD DATAFIELD');
567: FND_MESSAGE.set_token('TABLE', table_name);
568: FND_MESSAGE.set_token('DATAFIELD', datafield);

Line 566: FND_MESSAGE.set_name('FND', 'FLEX-DFF BAD DATAFIELD');

562: FND_MESSAGE.set_name('FND', 'FLEX-DFF ROW NOT FOUND');
563: FND_MESSAGE.set_token('TABLE', table_name);
564: FND_MESSAGE.set_token('ROWID', ROWIDTOCHAR(row_id));
565: elsif(rstat = -2) then
566: FND_MESSAGE.set_name('FND', 'FLEX-DFF BAD DATAFIELD');
567: FND_MESSAGE.set_token('TABLE', table_name);
568: FND_MESSAGE.set_token('DATAFIELD', datafield);
569: else
570: null;

Line 567: FND_MESSAGE.set_token('TABLE', table_name);

563: FND_MESSAGE.set_token('TABLE', table_name);
564: FND_MESSAGE.set_token('ROWID', ROWIDTOCHAR(row_id));
565: elsif(rstat = -2) then
566: FND_MESSAGE.set_name('FND', 'FLEX-DFF BAD DATAFIELD');
567: FND_MESSAGE.set_token('TABLE', table_name);
568: FND_MESSAGE.set_token('DATAFIELD', datafield);
569: else
570: null;
571: end if;

Line 568: FND_MESSAGE.set_token('DATAFIELD', datafield);

564: FND_MESSAGE.set_token('ROWID', ROWIDTOCHAR(row_id));
565: elsif(rstat = -2) then
566: FND_MESSAGE.set_name('FND', 'FLEX-DFF BAD DATAFIELD');
567: FND_MESSAGE.set_token('TABLE', table_name);
568: FND_MESSAGE.set_token('DATAFIELD', datafield);
569: else
570: null;
571: end if;
572: return(FALSE);

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

577: return(TRUE);
578:
579: EXCEPTION
580: WHEN OTHERS then
581: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
582: FND_MESSAGE.set_token('MSG','read_datafield() exception: '||SQLERRM);
583: return(FALSE);
584:
585: END read_datafield;

Line 582: FND_MESSAGE.set_token('MSG','read_datafield() exception: '||SQLERRM);

578:
579: EXCEPTION
580: WHEN OTHERS then
581: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
582: FND_MESSAGE.set_token('MSG','read_datafield() exception: '||SQLERRM);
583: return(FALSE);
584:
585: END read_datafield;
586:

Line 592: /* Returns TRUE on success or FALSE and sets FND_MESSAGE on error. */

588: /* Reads segment ids from individual attribute columns in the row */
589: /* of the effective table specified. Validates the context in the */
590: /* process to determine which columns to use for context-sensitive */
591: /* segments. Looks up the context value from table. */
592: /* Returns TRUE on success or FALSE and sets FND_MESSAGE on error. */
593: /* ------------------------------------------------------------------------ */
594:
595: FUNCTION read_segment_cols(dflex_info IN FND_FLEX_SERVER1.DescFlexInfo,
596: row_id IN ROWID,

Line 647: FND_MESSAGE.set_name('FND', 'FLEX-DFF ROW NOT FOUND');

643:
644: rstat := FND_FLEX_SERVER1.x_dsql_select_one(context);
645: if(rstat <> 1) then
646: if(rstat = 0) then
647: FND_MESSAGE.set_name('FND', 'FLEX-DFF ROW NOT FOUND');
648: FND_MESSAGE.set_token('TABLE', table_name);
649: FND_MESSAGE.set_token('ROWID', ROWIDTOCHAR(row_id));
650: elsif(rstat = -2) then
651: FND_MESSAGE.set_name('FND', 'FLEX-DFF BAD SEGCOLS');

Line 648: FND_MESSAGE.set_token('TABLE', table_name);

644: rstat := FND_FLEX_SERVER1.x_dsql_select_one(context);
645: if(rstat <> 1) then
646: if(rstat = 0) then
647: FND_MESSAGE.set_name('FND', 'FLEX-DFF ROW NOT FOUND');
648: FND_MESSAGE.set_token('TABLE', table_name);
649: FND_MESSAGE.set_token('ROWID', ROWIDTOCHAR(row_id));
650: elsif(rstat = -2) then
651: FND_MESSAGE.set_name('FND', 'FLEX-DFF BAD SEGCOLS');
652: FND_MESSAGE.set_token('TABLE', table_name);

Line 649: FND_MESSAGE.set_token('ROWID', ROWIDTOCHAR(row_id));

645: if(rstat <> 1) then
646: if(rstat = 0) then
647: FND_MESSAGE.set_name('FND', 'FLEX-DFF ROW NOT FOUND');
648: FND_MESSAGE.set_token('TABLE', table_name);
649: FND_MESSAGE.set_token('ROWID', ROWIDTOCHAR(row_id));
650: elsif(rstat = -2) then
651: FND_MESSAGE.set_name('FND', 'FLEX-DFF BAD SEGCOLS');
652: FND_MESSAGE.set_token('TABLE', table_name);
653: else

Line 651: FND_MESSAGE.set_name('FND', 'FLEX-DFF BAD SEGCOLS');

647: FND_MESSAGE.set_name('FND', 'FLEX-DFF ROW NOT FOUND');
648: FND_MESSAGE.set_token('TABLE', table_name);
649: FND_MESSAGE.set_token('ROWID', ROWIDTOCHAR(row_id));
650: elsif(rstat = -2) then
651: FND_MESSAGE.set_name('FND', 'FLEX-DFF BAD SEGCOLS');
652: FND_MESSAGE.set_token('TABLE', table_name);
653: else
654: null;
655: end if;

Line 652: FND_MESSAGE.set_token('TABLE', table_name);

648: FND_MESSAGE.set_token('TABLE', table_name);
649: FND_MESSAGE.set_token('ROWID', ROWIDTOCHAR(row_id));
650: elsif(rstat = -2) then
651: FND_MESSAGE.set_name('FND', 'FLEX-DFF BAD SEGCOLS');
652: FND_MESSAGE.set_token('TABLE', table_name);
653: else
654: null;
655: end if;
656: return(FALSE);

Line 694: FND_MESSAGE.set_name('FND', 'FLEX-DFF ROW NOT FOUND');

690: --
691: rstat := FND_FLEX_SERVER1.x_dsql_select(ncols, segs);
692: if(rstat <> 1) then
693: if(rstat = 0) then
694: FND_MESSAGE.set_name('FND', 'FLEX-DFF ROW NOT FOUND');
695: FND_MESSAGE.set_token('TABLE', table_name);
696: FND_MESSAGE.set_token('ROWID', ROWIDTOCHAR(row_id));
697: elsif(rstat = -2) then
698: FND_MESSAGE.set_name('FND', 'FLEX-DFF BAD SEGCOLS');

Line 695: FND_MESSAGE.set_token('TABLE', table_name);

691: rstat := FND_FLEX_SERVER1.x_dsql_select(ncols, segs);
692: if(rstat <> 1) then
693: if(rstat = 0) then
694: FND_MESSAGE.set_name('FND', 'FLEX-DFF ROW NOT FOUND');
695: FND_MESSAGE.set_token('TABLE', table_name);
696: FND_MESSAGE.set_token('ROWID', ROWIDTOCHAR(row_id));
697: elsif(rstat = -2) then
698: FND_MESSAGE.set_name('FND', 'FLEX-DFF BAD SEGCOLS');
699: FND_MESSAGE.set_token('TABLE', table_name);

Line 696: FND_MESSAGE.set_token('ROWID', ROWIDTOCHAR(row_id));

692: if(rstat <> 1) then
693: if(rstat = 0) then
694: FND_MESSAGE.set_name('FND', 'FLEX-DFF ROW NOT FOUND');
695: FND_MESSAGE.set_token('TABLE', table_name);
696: FND_MESSAGE.set_token('ROWID', ROWIDTOCHAR(row_id));
697: elsif(rstat = -2) then
698: FND_MESSAGE.set_name('FND', 'FLEX-DFF BAD SEGCOLS');
699: FND_MESSAGE.set_token('TABLE', table_name);
700: else

Line 698: FND_MESSAGE.set_name('FND', 'FLEX-DFF BAD SEGCOLS');

694: FND_MESSAGE.set_name('FND', 'FLEX-DFF ROW NOT FOUND');
695: FND_MESSAGE.set_token('TABLE', table_name);
696: FND_MESSAGE.set_token('ROWID', ROWIDTOCHAR(row_id));
697: elsif(rstat = -2) then
698: FND_MESSAGE.set_name('FND', 'FLEX-DFF BAD SEGCOLS');
699: FND_MESSAGE.set_token('TABLE', table_name);
700: else
701: null;
702: end if;

Line 699: FND_MESSAGE.set_token('TABLE', table_name);

695: FND_MESSAGE.set_token('TABLE', table_name);
696: FND_MESSAGE.set_token('ROWID', ROWIDTOCHAR(row_id));
697: elsif(rstat = -2) then
698: FND_MESSAGE.set_name('FND', 'FLEX-DFF BAD SEGCOLS');
699: FND_MESSAGE.set_token('TABLE', table_name);
700: else
701: null;
702: end if;
703: return(FALSE);

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

707: return(TRUE);
708:
709: EXCEPTION
710: WHEN OTHERS then
711: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
712: FND_MESSAGE.set_token('MSG','read_segment_cols() exception: '||SQLERRM);
713: return(FALSE);
714:
715: END read_segment_cols;

Line 712: FND_MESSAGE.set_token('MSG','read_segment_cols() exception: '||SQLERRM);

708:
709: EXCEPTION
710: WHEN OTHERS then
711: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
712: FND_MESSAGE.set_token('MSG','read_segment_cols() exception: '||SQLERRM);
713: return(FALSE);
714:
715: END read_segment_cols;
716:

Line 726: /* Returns TRUE if all ok, or FALSE and sets FND_MESSAGE on error. */

722: /* for all enabled segments even if they are not displayed. Returns */
723: /* global context segment columns first, then the context segment */
724: /* column, then the columns of the context-sensitive segments. */
725: /* Also returns a number indicating the context segment number. */
726: /* Returns TRUE if all ok, or FALSE and sets FND_MESSAGE on error. */
727: /* ------------------------------------------------------------------------ */
728:
729: FUNCTION get_desc_cols(dff_info IN FND_FLEX_SERVER1.DescFlexInfo,
730: context IN VARCHAR2,

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

872: return(TRUE);
873:
874: EXCEPTION
875: WHEN OTHERS then
876: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
877: FND_MESSAGE.set_token('MSG','get_desc_cols() exception: ' || SQLERRM);
878: return(FALSE);
879:
880: END get_desc_cols;

Line 877: FND_MESSAGE.set_token('MSG','get_desc_cols() exception: ' || SQLERRM);

873:
874: EXCEPTION
875: WHEN OTHERS then
876: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
877: FND_MESSAGE.set_token('MSG','get_desc_cols() exception: ' || SQLERRM);
878: return(FALSE);
879:
880: END get_desc_cols;
881:

Line 889: /* Returns TRUE if all ok, or FALSE and sets FND_MESSAGE on error. */

885: /* data types do not match those expected from the segment columns. */
886: /* Returns segment ids for all enabled segments whether or not they */
887: /* are displayed in the order that they are displayed within each */
888: /* context. */
889: /* Returns TRUE if all ok, or FALSE and sets FND_MESSAGE on error. */
890: /* ------------------------------------------------------------------------ */
891:
892: FUNCTION get_descsegs(dff_info IN FND_FLEX_SERVER1.DescFlexInfo,
893: coldef IN FND_FLEX_SERVER1.ColumnDefinitions,

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

967: return(TRUE);
968:
969: EXCEPTION
970: WHEN OTHERS then
971: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
972: FND_MESSAGE.set_token('MSG','get_descsegs() exception: ' || SQLERRM);
973: return(FALSE);
974:
975: END get_descsegs;

Line 972: FND_MESSAGE.set_token('MSG','get_descsegs() exception: ' || SQLERRM);

968:
969: EXCEPTION
970: WHEN OTHERS then
971: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
972: FND_MESSAGE.set_token('MSG','get_descsegs() exception: ' || SQLERRM);
973: return(FALSE);
974:
975: END get_descsegs;
976:

Line 985: /* Returns TRUE if all ok, or FALSE and sets FND_MESSAGE on error. */

981: /* Converts the column value stored in the generic character */
982: /* representation into the representation required for a segment */
983: /* with the indicated value set format and size. */
984: /* Performs case-insensitive column name comparison. */
985: /* Returns TRUE if all ok, or FALSE and sets FND_MESSAGE on error. */
986: /* ----------------------------------------------------------------------- */
987:
988: FUNCTION get_column_value(colvals IN FND_FLEX_SERVER1.ColumnValues,
989: colname IN VARCHAR2,

Line 1021: FND_MESSAGE.set_name('FND', 'FLEX-DFF COLUMN UNDEFINED');

1017:
1018: -- Error if column not defined
1019: --
1020: if(valindex = 0) then
1021: FND_MESSAGE.set_name('FND', 'FLEX-DFF COLUMN UNDEFINED');
1022: FND_MESSAGE.set_token('COLNAME', colname);
1023: FND_MESSAGE.set_token('COLTYPE', coltype);
1024: return(FALSE);
1025: end if;

Line 1022: FND_MESSAGE.set_token('COLNAME', colname);

1018: -- Error if column not defined
1019: --
1020: if(valindex = 0) then
1021: FND_MESSAGE.set_name('FND', 'FLEX-DFF COLUMN UNDEFINED');
1022: FND_MESSAGE.set_token('COLNAME', colname);
1023: FND_MESSAGE.set_token('COLTYPE', coltype);
1024: return(FALSE);
1025: end if;
1026:

Line 1023: FND_MESSAGE.set_token('COLTYPE', coltype);

1019: --
1020: if(valindex = 0) then
1021: FND_MESSAGE.set_name('FND', 'FLEX-DFF COLUMN UNDEFINED');
1022: FND_MESSAGE.set_token('COLNAME', colname);
1023: FND_MESSAGE.set_token('COLTYPE', coltype);
1024: return(FALSE);
1025: end if;
1026:
1027: -- Convert format of data to that desired for the value set.

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

1060: return(TRUE);
1061:
1062: EXCEPTION
1063: WHEN OTHERS then
1064: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
1065: FND_MESSAGE.set_token('MSG','get_column_value() exception: ' || SQLERRM);
1066: return(FALSE);
1067:
1068: END get_column_value;

Line 1065: FND_MESSAGE.set_token('MSG','get_column_value() exception: ' || SQLERRM);

1061:
1062: EXCEPTION
1063: WHEN OTHERS then
1064: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
1065: FND_MESSAGE.set_token('MSG','get_column_value() exception: ' || SQLERRM);
1066: return(FALSE);
1067:
1068: END get_column_value;
1069:

Line 1075: /* Returns error code and sets FND_MESSAGE on error, or returns */

1071: /* Validates all segments for a given descriptive flexfield. */
1072: /* Includes segments from the global context, the context segment */
1073: /* and the segments for the particular context. */
1074: /* Input all segments in an array. */
1075: /* Returns error code and sets FND_MESSAGE on error, or returns */
1076: /* VV_VALID if all ok. */
1077: /* ----------------------------------------------------------------------- */
1078:
1079: FUNCTION

Line 1171: global_error_msg := FND_MESSAGE.GET_ENCODED;

1167: -- overwritten by context validation.
1168: --
1169: if(global_return_code <> FND_FLEX_SERVER1.VV_VALID) then
1170: if(global_error_segnum is not null) then
1171: global_error_msg := FND_MESSAGE.GET_ENCODED;
1172: end if;
1173: if(not (((global_return_code = FND_FLEX_SERVER1.VV_SECURED) and
1174: (not global_vflags.stop_on_security)) OR
1175: ((global_return_code = FND_FLEX_SERVER1.VV_VALUES) and

Line 1228: FND_MESSAGE.set_name('FND', 'FLEX-MISSING CONCAT VALUES');

1224: segs(context_segnum) IS NOT NULL)) then
1225: if(nsegs_in < context_segnum) then
1226: if(vflags.exact_nsegs_required and
1227: not ((nsegs_in = 0) and (context_segnum = 1))) then
1228: FND_MESSAGE.set_name('FND', 'FLEX-MISSING CONCAT VALUES');
1229: error_segnum := global_segs.nvalidated + 1;
1230: return_code := FND_FLEX_SERVER1.VV_ERROR;
1231: goto return_values;
1232: else

Line 1342: FND_MESSAGE.SET_ENCODED(global_error_msg);

1338: return(return_code);
1339:
1340: <>
1341: errsegn := global_error_segnum;
1342: FND_MESSAGE.SET_ENCODED(global_error_msg);
1343: return(global_return_code);
1344:
1345: EXCEPTION
1346: WHEN OTHERS then

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

1343: return(global_return_code);
1344:
1345: EXCEPTION
1346: WHEN OTHERS then
1347: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
1348: FND_MESSAGE.set_token('MSG','validate_descsegs() exception: '||SQLERRM);
1349: return(FND_FLEX_SERVER1.VV_ERROR);
1350:
1351: END validate_descsegs;

Line 1348: FND_MESSAGE.set_token('MSG','validate_descsegs() exception: '||SQLERRM);

1344:
1345: EXCEPTION
1346: WHEN OTHERS then
1347: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
1348: FND_MESSAGE.set_token('MSG','validate_descsegs() exception: '||SQLERRM);
1349: return(FND_FLEX_SERVER1.VV_ERROR);
1350:
1351: END validate_descsegs;
1352:

Line 1358: /* 0 segments. Returns error code and sets FND_MESSAGE with error */

1354: /* Validates the context-sensitive segments of the descriptive */
1355: /* for the context of the given name returning a validated context */
1356: /* structure and error segment number relative to this context */
1357: /* as output. If context name is NULL, returns a valid context with */
1358: /* 0 segments. Returns error code and sets FND_MESSAGE with error */
1359: /* or returns FND_FLEX_SERVER1.VV_VALID if ok. */
1360: /* ----------------------------------------------------------------------- */
1361:
1362: FUNCTION

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

1446: return(FND_FLEX_SERVER1.VV_ERROR);
1447:
1448: EXCEPTION
1449: WHEN OTHERS then
1450: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
1451: FND_MESSAGE.set_token('MSG', 'validate_context_segs() exception: '
1452: || SQLERRM);
1453: return(FND_FLEX_SERVER1.VV_ERROR);
1454:

Line 1451: FND_MESSAGE.set_token('MSG', 'validate_context_segs() exception: '

1447:
1448: EXCEPTION
1449: WHEN OTHERS then
1450: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
1451: FND_MESSAGE.set_token('MSG', 'validate_context_segs() exception: '
1452: || SQLERRM);
1453: return(FND_FLEX_SERVER1.VV_ERROR);
1454:
1455: END validate_context_segs;

Line 1459: /* flexfield. Returns an error code and sets FND_MESSAGE on error */

1455: END validate_context_segs;
1456:
1457: /* ----------------------------------------------------------------------- */
1458: /* Validates the context value for the specified descriptive */
1459: /* flexfield. Returns an error code and sets FND_MESSAGE on error */
1460: /* or returns FND_FLEX_SERVER1.VV_VALID and a ValidatedSegmentArray */
1461: /* with only one segment if valid. */
1462: /* Note: Unlike regular value validation, validation must always */
1463: /* stop if the context segment is invalid because the remaining */

Line 1533: FND_MESSAGE.set_name('FND', 'FLEX-VALUE TOO LONG');

1529: end if;
1530:
1531: if((context_segval is not null) and
1532: (LENGTHB(context_segval) > l_max_lengthb)) then
1533: FND_MESSAGE.set_name('FND', 'FLEX-VALUE TOO LONG');
1534: FND_MESSAGE.set_token('VALUE', context_segval || '...');
1535: FND_MESSAGE.set_token('LENGTH', to_char(l_max_lengthb));
1536: vcode := FND_FLEX_SERVER1.FF_VFORMAT;
1537: goto return_status;

Line 1534: FND_MESSAGE.set_token('VALUE', context_segval || '...');

1530:
1531: if((context_segval is not null) and
1532: (LENGTHB(context_segval) > l_max_lengthb)) then
1533: FND_MESSAGE.set_name('FND', 'FLEX-VALUE TOO LONG');
1534: FND_MESSAGE.set_token('VALUE', context_segval || '...');
1535: FND_MESSAGE.set_token('LENGTH', to_char(l_max_lengthb));
1536: vcode := FND_FLEX_SERVER1.FF_VFORMAT;
1537: goto return_status;
1538: end if;

Line 1535: FND_MESSAGE.set_token('LENGTH', to_char(l_max_lengthb));

1531: if((context_segval is not null) and
1532: (LENGTHB(context_segval) > l_max_lengthb)) then
1533: FND_MESSAGE.set_name('FND', 'FLEX-VALUE TOO LONG');
1534: FND_MESSAGE.set_token('VALUE', context_segval || '...');
1535: FND_MESSAGE.set_token('LENGTH', to_char(l_max_lengthb));
1536: vcode := FND_FLEX_SERVER1.FF_VFORMAT;
1537: goto return_status;
1538: end if;
1539:

Line 1599: FND_MESSAGE.set_name('FND', 'FLEX-MISSING CONTEXT VALUE');

1595: vcode := FND_FLEX_SERVER1.FF_VVALID;
1596: else
1597: vcode := FND_FLEX_SERVER1.FF_VREQUIRED;
1598: if(vflags.message_on_null) then
1599: FND_MESSAGE.set_name('FND', 'FLEX-MISSING CONTEXT VALUE');
1600: FND_MESSAGE.set_token('FLEXFIELD', dff_info.name);
1601: -- FND_MESSAGE.set_name('FND', 'FLEX-NULL SEGMENT');
1602: end if;
1603: end if;

Line 1600: FND_MESSAGE.set_token('FLEXFIELD', dff_info.name);

1596: else
1597: vcode := FND_FLEX_SERVER1.FF_VREQUIRED;
1598: if(vflags.message_on_null) then
1599: FND_MESSAGE.set_name('FND', 'FLEX-MISSING CONTEXT VALUE');
1600: FND_MESSAGE.set_token('FLEXFIELD', dff_info.name);
1601: -- FND_MESSAGE.set_name('FND', 'FLEX-NULL SEGMENT');
1602: end if;
1603: end if;
1604: end if;

Line 1601: -- FND_MESSAGE.set_name('FND', 'FLEX-NULL SEGMENT');

1597: vcode := FND_FLEX_SERVER1.FF_VREQUIRED;
1598: if(vflags.message_on_null) then
1599: FND_MESSAGE.set_name('FND', 'FLEX-MISSING CONTEXT VALUE');
1600: FND_MESSAGE.set_token('FLEXFIELD', dff_info.name);
1601: -- FND_MESSAGE.set_name('FND', 'FLEX-NULL SEGMENT');
1602: end if;
1603: end if;
1604: end if;
1605:

Line 1623: FND_MESSAGE.set_name('FND', 'FLEX-CONTEXT NOT FOUND');

1619: return(FND_FLEX_SERVER1.VV_VALID);
1620: elsif(vcode = FND_FLEX_SERVER1.FF_VERROR) then
1621: return(FND_FLEX_SERVER1.VV_ERROR);
1622: else
1623: FND_MESSAGE.set_name('FND', 'FLEX-CONTEXT NOT FOUND');
1624: FND_MESSAGE.set_token('VALUE', context_segval);
1625: FND_MESSAGE.set_token('DFF', dff_info.name);
1626: return(FND_FLEX_SERVER1.VV_VALUES);
1627: end if;

Line 1624: FND_MESSAGE.set_token('VALUE', context_segval);

1620: elsif(vcode = FND_FLEX_SERVER1.FF_VERROR) then
1621: return(FND_FLEX_SERVER1.VV_ERROR);
1622: else
1623: FND_MESSAGE.set_name('FND', 'FLEX-CONTEXT NOT FOUND');
1624: FND_MESSAGE.set_token('VALUE', context_segval);
1625: FND_MESSAGE.set_token('DFF', dff_info.name);
1626: return(FND_FLEX_SERVER1.VV_VALUES);
1627: end if;
1628:

Line 1625: FND_MESSAGE.set_token('DFF', dff_info.name);

1621: return(FND_FLEX_SERVER1.VV_ERROR);
1622: else
1623: FND_MESSAGE.set_name('FND', 'FLEX-CONTEXT NOT FOUND');
1624: FND_MESSAGE.set_token('VALUE', context_segval);
1625: FND_MESSAGE.set_token('DFF', dff_info.name);
1626: return(FND_FLEX_SERVER1.VV_VALUES);
1627: end if;
1628:
1629: return(FND_FLEX_SERVER1.VV_ERROR);

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

1629: return(FND_FLEX_SERVER1.VV_ERROR);
1630:
1631: EXCEPTION
1632: WHEN OTHERS then
1633: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
1634: FND_MESSAGE.set_token('MSG', 'validate_context() exception: '||SQLERRM);
1635: return(FND_FLEX_SERVER1.VV_ERROR);
1636:
1637: END validate_context;

Line 1634: FND_MESSAGE.set_token('MSG', 'validate_context() exception: '||SQLERRM);

1630:
1631: EXCEPTION
1632: WHEN OTHERS then
1633: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
1634: FND_MESSAGE.set_token('MSG', 'validate_context() exception: '||SQLERRM);
1635: return(FND_FLEX_SERVER1.VV_ERROR);
1636:
1637: END validate_context;
1638:

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

1675: return(TRUE);
1676:
1677: EXCEPTION
1678: WHEN OTHERS then
1679: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
1680: FND_MESSAGE.set_token('MSG','append_vsegarray() exception: '||SQLERRM);
1681: return(FALSE);
1682:
1683: END append_vsegarray;

Line 1680: FND_MESSAGE.set_token('MSG','append_vsegarray() exception: '||SQLERRM);

1676:
1677: EXCEPTION
1678: WHEN OTHERS then
1679: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
1680: FND_MESSAGE.set_token('MSG','append_vsegarray() exception: '||SQLERRM);
1681: return(FALSE);
1682:
1683: END append_vsegarray;
1684:

Line 1727: /* Otherwise sets error message in FND_MESSAGE and returns */

1723: /* with the context segment input. If only one value matches that, */
1724: /* that context is returned. Otherwise the context is not found. */
1725: /* */
1726: /* Returns value validation code FND_FLEX_SERVER1.FF_VALID if ok. */
1727: /* Otherwise sets error message in FND_MESSAGE and returns */
1728: /* FF_VVALUES if not found or FF_VERROR on error. */
1729: /* ----------------------------------------------------------------------- */
1730:
1731: FUNCTION find_context_value(appl_id IN VARCHAR2,

Line 1802: -- FND_MESSAGE.set_name('FND', 'FLEX-CONTEXT NOT FOUND');

1798: vcode := FND_FLEX_SERVER1.FF_CTXTNOSEG;
1799: -- IF(vcode = FND_FLEX_SERVER1.FF_CTXTNOSEG) THEN
1800: return(FND_FLEX_SERVER1.FF_CTXTNOSEG);
1801: -- ELSE
1802: -- FND_MESSAGE.set_name('FND', 'FLEX-CONTEXT NOT FOUND');
1803: -- FND_MESSAGE.set_token('VALUE', seg_in);
1804: -- FND_MESSAGE.set_token('DFF', dflex_name);
1805: -- return(FND_FLEX_SERVER1.FF_VNOTFOUND);
1806: -- END IF;

Line 1803: -- FND_MESSAGE.set_token('VALUE', seg_in);

1799: -- IF(vcode = FND_FLEX_SERVER1.FF_CTXTNOSEG) THEN
1800: return(FND_FLEX_SERVER1.FF_CTXTNOSEG);
1801: -- ELSE
1802: -- FND_MESSAGE.set_name('FND', 'FLEX-CONTEXT NOT FOUND');
1803: -- FND_MESSAGE.set_token('VALUE', seg_in);
1804: -- FND_MESSAGE.set_token('DFF', dflex_name);
1805: -- return(FND_FLEX_SERVER1.FF_VNOTFOUND);
1806: -- END IF;
1807: WHEN OTHERS then

Line 1804: -- FND_MESSAGE.set_token('DFF', dflex_name);

1800: return(FND_FLEX_SERVER1.FF_CTXTNOSEG);
1801: -- ELSE
1802: -- FND_MESSAGE.set_name('FND', 'FLEX-CONTEXT NOT FOUND');
1803: -- FND_MESSAGE.set_token('VALUE', seg_in);
1804: -- FND_MESSAGE.set_token('DFF', dflex_name);
1805: -- return(FND_FLEX_SERVER1.FF_VNOTFOUND);
1806: -- END IF;
1807: WHEN OTHERS then
1808: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');

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

1804: -- FND_MESSAGE.set_token('DFF', dflex_name);
1805: -- return(FND_FLEX_SERVER1.FF_VNOTFOUND);
1806: -- END IF;
1807: WHEN OTHERS then
1808: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
1809: FND_MESSAGE.set_token('MSG','find_context_value() exception: '||SQLERRM);
1810: return(FND_FLEX_SERVER1.FF_VERROR);
1811:
1812: END find_context_value;

Line 1809: FND_MESSAGE.set_token('MSG','find_context_value() exception: '||SQLERRM);

1805: -- return(FND_FLEX_SERVER1.FF_VNOTFOUND);
1806: -- END IF;
1807: WHEN OTHERS then
1808: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
1809: FND_MESSAGE.set_token('MSG','find_context_value() exception: '||SQLERRM);
1810: return(FND_FLEX_SERVER1.FF_VERROR);
1811:
1812: END find_context_value;
1813:

Line 1817: /* Returns TRUE if OK or FALSE and sets FND_MESSAGE if error. */

1813:
1814: /* ----------------------------------------------------------------------- */
1815: /* Gets the name of the global context for the specified flexfield. */
1816: /* Error if the global context name is not enabled. */
1817: /* Returns TRUE if OK or FALSE and sets FND_MESSAGE if error. */
1818: /* ----------------------------------------------------------------------- */
1819:
1820: FUNCTION get_global_context(appl_id IN NUMBER,
1821: dflex_name IN VARCHAR2,

Line 1860: FND_MESSAGE.set_name('FND', 'FLEX-NO ENABLED GLOBAL CONTEXT');

1856: return(TRUE);
1857:
1858: EXCEPTION
1859: WHEN NO_DATA_FOUND then
1860: FND_MESSAGE.set_name('FND', 'FLEX-NO ENABLED GLOBAL CONTEXT');
1861: return(FALSE);
1862: WHEN TOO_MANY_ROWS then
1863: FND_MESSAGE.set_name('FND', 'FLEX-DUPLICATE GLOBAL CONTEXTS');
1864: FND_MESSAGE.set_token('APID', appl_id);

Line 1863: FND_MESSAGE.set_name('FND', 'FLEX-DUPLICATE GLOBAL CONTEXTS');

1859: WHEN NO_DATA_FOUND then
1860: FND_MESSAGE.set_name('FND', 'FLEX-NO ENABLED GLOBAL CONTEXT');
1861: return(FALSE);
1862: WHEN TOO_MANY_ROWS then
1863: FND_MESSAGE.set_name('FND', 'FLEX-DUPLICATE GLOBAL CONTEXTS');
1864: FND_MESSAGE.set_token('APID', appl_id);
1865: FND_MESSAGE.set_token('NAME', dflex_name);
1866: return(FALSE);
1867: WHEN OTHERS then

Line 1864: FND_MESSAGE.set_token('APID', appl_id);

1860: FND_MESSAGE.set_name('FND', 'FLEX-NO ENABLED GLOBAL CONTEXT');
1861: return(FALSE);
1862: WHEN TOO_MANY_ROWS then
1863: FND_MESSAGE.set_name('FND', 'FLEX-DUPLICATE GLOBAL CONTEXTS');
1864: FND_MESSAGE.set_token('APID', appl_id);
1865: FND_MESSAGE.set_token('NAME', dflex_name);
1866: return(FALSE);
1867: WHEN OTHERS then
1868: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');

Line 1865: FND_MESSAGE.set_token('NAME', dflex_name);

1861: return(FALSE);
1862: WHEN TOO_MANY_ROWS then
1863: FND_MESSAGE.set_name('FND', 'FLEX-DUPLICATE GLOBAL CONTEXTS');
1864: FND_MESSAGE.set_token('APID', appl_id);
1865: FND_MESSAGE.set_token('NAME', dflex_name);
1866: return(FALSE);
1867: WHEN OTHERS then
1868: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
1869: FND_MESSAGE.set_token('MSG','get_global_context() exception: '||SQLERRM);

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

1864: FND_MESSAGE.set_token('APID', appl_id);
1865: FND_MESSAGE.set_token('NAME', dflex_name);
1866: return(FALSE);
1867: WHEN OTHERS then
1868: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
1869: FND_MESSAGE.set_token('MSG','get_global_context() exception: '||SQLERRM);
1870: return(FALSE);
1871: END get_global_context;
1872:

Line 1869: FND_MESSAGE.set_token('MSG','get_global_context() exception: '||SQLERRM);

1865: FND_MESSAGE.set_token('NAME', dflex_name);
1866: return(FALSE);
1867: WHEN OTHERS then
1868: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
1869: FND_MESSAGE.set_token('MSG','get_global_context() exception: '||SQLERRM);
1870: return(FALSE);
1871: END get_global_context;
1872:
1873: /* ----------------------------------------------------------------------- */