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 414: FND_MESSAGE.set_name('FND', 'FLEX-TOO MANY SEGS');

410: if ((l_context_Segment_included and (nsegs = MAX_NSEGS + 1)) OR
411: (use_column_def = FALSE)) then
412: NULL;
413: else
414: FND_MESSAGE.set_name('FND', 'FLEX-TOO MANY SEGS');
415: FND_MESSAGE.set_token('NSEGS', MAX_NSEGS);
416: goto return_error;
417: end if;
418: END IF;

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

411: (use_column_def = FALSE)) then
412: NULL;
413: else
414: FND_MESSAGE.set_name('FND', 'FLEX-TOO MANY SEGS');
415: FND_MESSAGE.set_token('NSEGS', MAX_NSEGS);
416: goto return_error;
417: end if;
418: END IF;
419:

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

474: return;
475:
476: EXCEPTION
477: WHEN OTHERS then
478: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
479: FND_MESSAGE.set_token('MSG','descval_engine() exception: ' || SQLERRM);
480: v_status := FND_FLEX_SERVER1.VV_ERROR;
481: return;
482: END descval_engine;

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

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

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

490: /* concatenated ids rather than the individual segment fields. */
491: /* Returns segment ids for all enabled segments whether or not they */
492: /* are displayed in the order that they are displayed within each */
493: /* context. */
494: /* Returns TRUE if all ok, or FALSE and sets FND_MESSAGE on error. */
495: /* ------------------------------------------------------------------------ */
496:
497: FUNCTION find_descsegs(dflex_info IN FND_FLEX_SERVER1.DescFlexInfo,
498: row_id IN ROWID,

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

528: return(read_segment_cols(dflex_info, row_id, effective_table,
529: vflags, nsegs_out, segs_out));
530: EXCEPTION
531: WHEN OTHERS then
532: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
533: FND_MESSAGE.set_token('MSG','find_descsegs() exception: ' || SQLERRM);
534: return(FALSE);
535:
536: END find_descsegs;

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

529: vflags, nsegs_out, segs_out));
530: EXCEPTION
531: WHEN OTHERS then
532: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
533: FND_MESSAGE.set_token('MSG','find_descsegs() exception: ' || SQLERRM);
534: return(FALSE);
535:
536: END find_descsegs;
537:

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

538: /* ------------------------------------------------------------------------ */
539: /* Reads concatenated segment ids from data field in the particular */
540: /* row of the specified table. Breaks up concatenated segments into */
541: /* a string array for return. */
542: /* Returns TRUE on success or FALSE and sets FND_MESSAGE on error. */
543: /* ------------------------------------------------------------------------ */
544:
545: FUNCTION read_datafield(dflex_info IN FND_FLEX_SERVER1.DescFlexInfo,
546: row_id IN ROWID,

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

569: --
570: rstat := FND_FLEX_SERVER1.x_dsql_select_one(concat_segids);
571: if(rstat <> 1) then
572: if(rstat = 0) then
573: FND_MESSAGE.set_name('FND', 'FLEX-DFF ROW NOT FOUND');
574: FND_MESSAGE.set_token('TABLE', table_name);
575: FND_MESSAGE.set_token('ROWID', ROWIDTOCHAR(row_id));
576: elsif(rstat = -2) then
577: FND_MESSAGE.set_name('FND', 'FLEX-DFF BAD DATAFIELD');

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

570: rstat := FND_FLEX_SERVER1.x_dsql_select_one(concat_segids);
571: if(rstat <> 1) then
572: if(rstat = 0) then
573: FND_MESSAGE.set_name('FND', 'FLEX-DFF ROW NOT FOUND');
574: FND_MESSAGE.set_token('TABLE', table_name);
575: FND_MESSAGE.set_token('ROWID', ROWIDTOCHAR(row_id));
576: elsif(rstat = -2) then
577: FND_MESSAGE.set_name('FND', 'FLEX-DFF BAD DATAFIELD');
578: FND_MESSAGE.set_token('TABLE', table_name);

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

571: if(rstat <> 1) then
572: if(rstat = 0) then
573: FND_MESSAGE.set_name('FND', 'FLEX-DFF ROW NOT FOUND');
574: FND_MESSAGE.set_token('TABLE', table_name);
575: FND_MESSAGE.set_token('ROWID', ROWIDTOCHAR(row_id));
576: elsif(rstat = -2) then
577: FND_MESSAGE.set_name('FND', 'FLEX-DFF BAD DATAFIELD');
578: FND_MESSAGE.set_token('TABLE', table_name);
579: FND_MESSAGE.set_token('DATAFIELD', datafield);

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

573: FND_MESSAGE.set_name('FND', 'FLEX-DFF ROW NOT FOUND');
574: FND_MESSAGE.set_token('TABLE', table_name);
575: FND_MESSAGE.set_token('ROWID', ROWIDTOCHAR(row_id));
576: elsif(rstat = -2) then
577: FND_MESSAGE.set_name('FND', 'FLEX-DFF BAD DATAFIELD');
578: FND_MESSAGE.set_token('TABLE', table_name);
579: FND_MESSAGE.set_token('DATAFIELD', datafield);
580: else
581: null;

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

574: FND_MESSAGE.set_token('TABLE', table_name);
575: FND_MESSAGE.set_token('ROWID', ROWIDTOCHAR(row_id));
576: elsif(rstat = -2) then
577: FND_MESSAGE.set_name('FND', 'FLEX-DFF BAD DATAFIELD');
578: FND_MESSAGE.set_token('TABLE', table_name);
579: FND_MESSAGE.set_token('DATAFIELD', datafield);
580: else
581: null;
582: end if;

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

575: FND_MESSAGE.set_token('ROWID', ROWIDTOCHAR(row_id));
576: elsif(rstat = -2) then
577: FND_MESSAGE.set_name('FND', 'FLEX-DFF BAD DATAFIELD');
578: FND_MESSAGE.set_token('TABLE', table_name);
579: FND_MESSAGE.set_token('DATAFIELD', datafield);
580: else
581: null;
582: end if;
583: return(FALSE);

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

588: return(TRUE);
589:
590: EXCEPTION
591: WHEN OTHERS then
592: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
593: FND_MESSAGE.set_token('MSG','read_datafield() exception: '||SQLERRM);
594: return(FALSE);
595:
596: END read_datafield;

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

589:
590: EXCEPTION
591: WHEN OTHERS then
592: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
593: FND_MESSAGE.set_token('MSG','read_datafield() exception: '||SQLERRM);
594: return(FALSE);
595:
596: END read_datafield;
597:

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

599: /* Reads segment ids from individual attribute columns in the row */
600: /* of the effective table specified. Validates the context in the */
601: /* process to determine which columns to use for context-sensitive */
602: /* segments. Looks up the context value from table. */
603: /* Returns TRUE on success or FALSE and sets FND_MESSAGE on error. */
604: /* ------------------------------------------------------------------------ */
605:
606: FUNCTION read_segment_cols(dflex_info IN FND_FLEX_SERVER1.DescFlexInfo,
607: row_id IN ROWID,

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

654:
655: rstat := FND_FLEX_SERVER1.x_dsql_select_one(context);
656: if(rstat <> 1) then
657: if(rstat = 0) then
658: FND_MESSAGE.set_name('FND', 'FLEX-DFF ROW NOT FOUND');
659: FND_MESSAGE.set_token('TABLE', table_name);
660: FND_MESSAGE.set_token('ROWID', ROWIDTOCHAR(row_id));
661: elsif(rstat = -2) then
662: FND_MESSAGE.set_name('FND', 'FLEX-DFF BAD SEGCOLS');

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

655: rstat := FND_FLEX_SERVER1.x_dsql_select_one(context);
656: if(rstat <> 1) then
657: if(rstat = 0) then
658: FND_MESSAGE.set_name('FND', 'FLEX-DFF ROW NOT FOUND');
659: FND_MESSAGE.set_token('TABLE', table_name);
660: FND_MESSAGE.set_token('ROWID', ROWIDTOCHAR(row_id));
661: elsif(rstat = -2) then
662: FND_MESSAGE.set_name('FND', 'FLEX-DFF BAD SEGCOLS');
663: FND_MESSAGE.set_token('TABLE', table_name);

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

656: if(rstat <> 1) then
657: if(rstat = 0) then
658: FND_MESSAGE.set_name('FND', 'FLEX-DFF ROW NOT FOUND');
659: FND_MESSAGE.set_token('TABLE', table_name);
660: FND_MESSAGE.set_token('ROWID', ROWIDTOCHAR(row_id));
661: elsif(rstat = -2) then
662: FND_MESSAGE.set_name('FND', 'FLEX-DFF BAD SEGCOLS');
663: FND_MESSAGE.set_token('TABLE', table_name);
664: else

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

658: FND_MESSAGE.set_name('FND', 'FLEX-DFF ROW NOT FOUND');
659: FND_MESSAGE.set_token('TABLE', table_name);
660: FND_MESSAGE.set_token('ROWID', ROWIDTOCHAR(row_id));
661: elsif(rstat = -2) then
662: FND_MESSAGE.set_name('FND', 'FLEX-DFF BAD SEGCOLS');
663: FND_MESSAGE.set_token('TABLE', table_name);
664: else
665: null;
666: end if;

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

659: FND_MESSAGE.set_token('TABLE', table_name);
660: FND_MESSAGE.set_token('ROWID', ROWIDTOCHAR(row_id));
661: elsif(rstat = -2) then
662: FND_MESSAGE.set_name('FND', 'FLEX-DFF BAD SEGCOLS');
663: FND_MESSAGE.set_token('TABLE', table_name);
664: else
665: null;
666: end if;
667: return(FALSE);

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

701: --
702: rstat := FND_FLEX_SERVER1.x_dsql_select(ncols, segs);
703: if(rstat <> 1) then
704: if(rstat = 0) then
705: FND_MESSAGE.set_name('FND', 'FLEX-DFF ROW NOT FOUND');
706: FND_MESSAGE.set_token('TABLE', table_name);
707: FND_MESSAGE.set_token('ROWID', ROWIDTOCHAR(row_id));
708: elsif(rstat = -2) then
709: FND_MESSAGE.set_name('FND', 'FLEX-DFF BAD SEGCOLS');

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

702: rstat := FND_FLEX_SERVER1.x_dsql_select(ncols, segs);
703: if(rstat <> 1) then
704: if(rstat = 0) then
705: FND_MESSAGE.set_name('FND', 'FLEX-DFF ROW NOT FOUND');
706: FND_MESSAGE.set_token('TABLE', table_name);
707: FND_MESSAGE.set_token('ROWID', ROWIDTOCHAR(row_id));
708: elsif(rstat = -2) then
709: FND_MESSAGE.set_name('FND', 'FLEX-DFF BAD SEGCOLS');
710: FND_MESSAGE.set_token('TABLE', table_name);

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

703: if(rstat <> 1) then
704: if(rstat = 0) then
705: FND_MESSAGE.set_name('FND', 'FLEX-DFF ROW NOT FOUND');
706: FND_MESSAGE.set_token('TABLE', table_name);
707: FND_MESSAGE.set_token('ROWID', ROWIDTOCHAR(row_id));
708: elsif(rstat = -2) then
709: FND_MESSAGE.set_name('FND', 'FLEX-DFF BAD SEGCOLS');
710: FND_MESSAGE.set_token('TABLE', table_name);
711: else

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

705: FND_MESSAGE.set_name('FND', 'FLEX-DFF ROW NOT FOUND');
706: FND_MESSAGE.set_token('TABLE', table_name);
707: FND_MESSAGE.set_token('ROWID', ROWIDTOCHAR(row_id));
708: elsif(rstat = -2) then
709: FND_MESSAGE.set_name('FND', 'FLEX-DFF BAD SEGCOLS');
710: FND_MESSAGE.set_token('TABLE', table_name);
711: else
712: null;
713: end if;

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

706: FND_MESSAGE.set_token('TABLE', table_name);
707: FND_MESSAGE.set_token('ROWID', ROWIDTOCHAR(row_id));
708: elsif(rstat = -2) then
709: FND_MESSAGE.set_name('FND', 'FLEX-DFF BAD SEGCOLS');
710: FND_MESSAGE.set_token('TABLE', table_name);
711: else
712: null;
713: end if;
714: return(FALSE);

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

718: return(TRUE);
719:
720: EXCEPTION
721: WHEN OTHERS then
722: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
723: FND_MESSAGE.set_token('MSG','read_segment_cols() exception: '||SQLERRM);
724: return(FALSE);
725:
726: END read_segment_cols;

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

719:
720: EXCEPTION
721: WHEN OTHERS then
722: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
723: FND_MESSAGE.set_token('MSG','read_segment_cols() exception: '||SQLERRM);
724: return(FALSE);
725:
726: END read_segment_cols;
727:

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

733: /* for all enabled segments even if they are not displayed. Returns */
734: /* global context segment columns first, then the context segment */
735: /* column, then the columns of the context-sensitive segments. */
736: /* Also returns a number indicating the context segment number. */
737: /* Returns TRUE if all ok, or FALSE and sets FND_MESSAGE on error. */
738: /* ------------------------------------------------------------------------ */
739:
740: FUNCTION get_desc_cols(dff_info IN FND_FLEX_SERVER1.DescFlexInfo,
741: context IN VARCHAR2,

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

883: return(TRUE);
884:
885: EXCEPTION
886: WHEN OTHERS then
887: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
888: FND_MESSAGE.set_token('MSG','get_desc_cols() exception: ' || SQLERRM);
889: return(FALSE);
890:
891: END get_desc_cols;

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

884:
885: EXCEPTION
886: WHEN OTHERS then
887: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
888: FND_MESSAGE.set_token('MSG','get_desc_cols() exception: ' || SQLERRM);
889: return(FALSE);
890:
891: END get_desc_cols;
892:

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

896: /* data types do not match those expected from the segment columns. */
897: /* Returns segment ids for all enabled segments whether or not they */
898: /* are displayed in the order that they are displayed within each */
899: /* context. */
900: /* Returns TRUE if all ok, or FALSE and sets FND_MESSAGE on error. */
901: /* ------------------------------------------------------------------------ */
902:
903: FUNCTION get_descsegs(dff_info IN FND_FLEX_SERVER1.DescFlexInfo,
904: coldef IN FND_FLEX_SERVER1.ColumnDefinitions,

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

978: return(TRUE);
979:
980: EXCEPTION
981: WHEN OTHERS then
982: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
983: FND_MESSAGE.set_token('MSG','get_descsegs() exception: ' || SQLERRM);
984: return(FALSE);
985:
986: END get_descsegs;

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

979:
980: EXCEPTION
981: WHEN OTHERS then
982: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
983: FND_MESSAGE.set_token('MSG','get_descsegs() exception: ' || SQLERRM);
984: return(FALSE);
985:
986: END get_descsegs;
987:

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

992: /* Converts the column value stored in the generic character */
993: /* representation into the representation required for a segment */
994: /* with the indicated value set format and size. */
995: /* Performs case-insensitive column name comparison. */
996: /* Returns TRUE if all ok, or FALSE and sets FND_MESSAGE on error. */
997: /* ----------------------------------------------------------------------- */
998:
999: FUNCTION get_column_value(colvals IN FND_FLEX_SERVER1.ColumnValues,
1000: colname IN VARCHAR2,

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

1028:
1029: -- Error if column not defined
1030: --
1031: if(valindex = 0) then
1032: FND_MESSAGE.set_name('FND', 'FLEX-DFF COLUMN UNDEFINED');
1033: FND_MESSAGE.set_token('COLNAME', colname);
1034: FND_MESSAGE.set_token('COLTYPE', coltype);
1035: return(FALSE);
1036: end if;

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

1029: -- Error if column not defined
1030: --
1031: if(valindex = 0) then
1032: FND_MESSAGE.set_name('FND', 'FLEX-DFF COLUMN UNDEFINED');
1033: FND_MESSAGE.set_token('COLNAME', colname);
1034: FND_MESSAGE.set_token('COLTYPE', coltype);
1035: return(FALSE);
1036: end if;
1037:

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

1030: --
1031: if(valindex = 0) then
1032: FND_MESSAGE.set_name('FND', 'FLEX-DFF COLUMN UNDEFINED');
1033: FND_MESSAGE.set_token('COLNAME', colname);
1034: FND_MESSAGE.set_token('COLTYPE', coltype);
1035: return(FALSE);
1036: end if;
1037:
1038: -- Convert format of data to that desired for the value set.

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

1071: return(TRUE);
1072:
1073: EXCEPTION
1074: WHEN OTHERS then
1075: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
1076: FND_MESSAGE.set_token('MSG','get_column_value() exception: ' || SQLERRM);
1077: return(FALSE);
1078:
1079: END get_column_value;

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

1072:
1073: EXCEPTION
1074: WHEN OTHERS then
1075: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
1076: FND_MESSAGE.set_token('MSG','get_column_value() exception: ' || SQLERRM);
1077: return(FALSE);
1078:
1079: END get_column_value;
1080:

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

1082: /* Validates all segments for a given descriptive flexfield. */
1083: /* Includes segments from the global context, the context segment */
1084: /* and the segments for the particular context. */
1085: /* Input all segments in an array. */
1086: /* Returns error code and sets FND_MESSAGE on error, or returns */
1087: /* VV_VALID if all ok. */
1088: /* ----------------------------------------------------------------------- */
1089:
1090: FUNCTION

Line 1182: global_error_msg := FND_MESSAGE.GET_ENCODED;

1178: -- overwritten by context validation.
1179: --
1180: if(global_return_code <> FND_FLEX_SERVER1.VV_VALID) then
1181: if(global_error_segnum is not null) then
1182: global_error_msg := FND_MESSAGE.GET_ENCODED;
1183: end if;
1184: if(not (((global_return_code = FND_FLEX_SERVER1.VV_SECURED) and
1185: (not global_vflags.stop_on_security)) OR
1186: ((global_return_code = FND_FLEX_SERVER1.VV_VALUES) and

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

1235: segs(context_segnum) IS NOT NULL)) then
1236: if(nsegs_in < context_segnum) then
1237: if(vflags.exact_nsegs_required and
1238: not ((nsegs_in = 0) and (context_segnum = 1))) then
1239: FND_MESSAGE.set_name('FND', 'FLEX-MISSING CONCAT VALUES');
1240: error_segnum := global_segs.nvalidated + 1;
1241: return_code := FND_FLEX_SERVER1.VV_ERROR;
1242: goto return_values;
1243: else

Line 1353: FND_MESSAGE.SET_ENCODED(global_error_msg);

1349: return(return_code);
1350:
1351: <>
1352: errsegn := global_error_segnum;
1353: FND_MESSAGE.SET_ENCODED(global_error_msg);
1354: return(global_return_code);
1355:
1356: EXCEPTION
1357: WHEN OTHERS then

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

1354: return(global_return_code);
1355:
1356: EXCEPTION
1357: WHEN OTHERS then
1358: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
1359: FND_MESSAGE.set_token('MSG','validate_descsegs() exception: '||SQLERRM);
1360: return(FND_FLEX_SERVER1.VV_ERROR);
1361:
1362: END validate_descsegs;

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

1355:
1356: EXCEPTION
1357: WHEN OTHERS then
1358: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
1359: FND_MESSAGE.set_token('MSG','validate_descsegs() exception: '||SQLERRM);
1360: return(FND_FLEX_SERVER1.VV_ERROR);
1361:
1362: END validate_descsegs;
1363:

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

1365: /* Validates the context-sensitive segments of the descriptive */
1366: /* for the context of the given name returning a validated context */
1367: /* structure and error segment number relative to this context */
1368: /* as output. If context name is NULL, returns a valid context with */
1369: /* 0 segments. Returns error code and sets FND_MESSAGE with error */
1370: /* or returns FND_FLEX_SERVER1.VV_VALID if ok. */
1371: /* ----------------------------------------------------------------------- */
1372:
1373: FUNCTION

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

1457: return(FND_FLEX_SERVER1.VV_ERROR);
1458:
1459: EXCEPTION
1460: WHEN OTHERS then
1461: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
1462: FND_MESSAGE.set_token('MSG', 'validate_context_segs() exception: '
1463: || SQLERRM);
1464: return(FND_FLEX_SERVER1.VV_ERROR);
1465:

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

1458:
1459: EXCEPTION
1460: WHEN OTHERS then
1461: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
1462: FND_MESSAGE.set_token('MSG', 'validate_context_segs() exception: '
1463: || SQLERRM);
1464: return(FND_FLEX_SERVER1.VV_ERROR);
1465:
1466: END validate_context_segs;

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

1466: END validate_context_segs;
1467:
1468: /* ----------------------------------------------------------------------- */
1469: /* Validates the context value for the specified descriptive */
1470: /* flexfield. Returns an error code and sets FND_MESSAGE on error */
1471: /* or returns FND_FLEX_SERVER1.VV_VALID and a ValidatedSegmentArray */
1472: /* with only one segment if valid. */
1473: /* Note: Unlike regular value validation, validation must always */
1474: /* stop if the context segment is invalid because the remaining */

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

1540: end if;
1541:
1542: if((context_segval is not null) and
1543: (LENGTHB(context_segval) > l_max_lengthb)) then
1544: FND_MESSAGE.set_name('FND', 'FLEX-VALUE TOO LONG');
1545: FND_MESSAGE.set_token('VALUE', context_segval || '...');
1546: FND_MESSAGE.set_token('LENGTH', to_char(l_max_lengthb));
1547: vcode := FND_FLEX_SERVER1.FF_VFORMAT;
1548: goto return_status;

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

1541:
1542: if((context_segval is not null) and
1543: (LENGTHB(context_segval) > l_max_lengthb)) then
1544: FND_MESSAGE.set_name('FND', 'FLEX-VALUE TOO LONG');
1545: FND_MESSAGE.set_token('VALUE', context_segval || '...');
1546: FND_MESSAGE.set_token('LENGTH', to_char(l_max_lengthb));
1547: vcode := FND_FLEX_SERVER1.FF_VFORMAT;
1548: goto return_status;
1549: end if;

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

1542: if((context_segval is not null) and
1543: (LENGTHB(context_segval) > l_max_lengthb)) then
1544: FND_MESSAGE.set_name('FND', 'FLEX-VALUE TOO LONG');
1545: FND_MESSAGE.set_token('VALUE', context_segval || '...');
1546: FND_MESSAGE.set_token('LENGTH', to_char(l_max_lengthb));
1547: vcode := FND_FLEX_SERVER1.FF_VFORMAT;
1548: goto return_status;
1549: end if;
1550:

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

1606: vcode := FND_FLEX_SERVER1.FF_VVALID;
1607: else
1608: vcode := FND_FLEX_SERVER1.FF_VREQUIRED;
1609: if(vflags.message_on_null) then
1610: FND_MESSAGE.set_name('FND', 'FLEX-MISSING CONTEXT VALUE');
1611: FND_MESSAGE.set_token('FLEXFIELD', dff_info.name);
1612: -- FND_MESSAGE.set_name('FND', 'FLEX-NULL SEGMENT');
1613: end if;
1614: end if;

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

1607: else
1608: vcode := FND_FLEX_SERVER1.FF_VREQUIRED;
1609: if(vflags.message_on_null) then
1610: FND_MESSAGE.set_name('FND', 'FLEX-MISSING CONTEXT VALUE');
1611: FND_MESSAGE.set_token('FLEXFIELD', dff_info.name);
1612: -- FND_MESSAGE.set_name('FND', 'FLEX-NULL SEGMENT');
1613: end if;
1614: end if;
1615: end if;

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

1608: vcode := FND_FLEX_SERVER1.FF_VREQUIRED;
1609: if(vflags.message_on_null) then
1610: FND_MESSAGE.set_name('FND', 'FLEX-MISSING CONTEXT VALUE');
1611: FND_MESSAGE.set_token('FLEXFIELD', dff_info.name);
1612: -- FND_MESSAGE.set_name('FND', 'FLEX-NULL SEGMENT');
1613: end if;
1614: end if;
1615: end if;
1616:

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

1630: return(FND_FLEX_SERVER1.VV_VALID);
1631: elsif(vcode = FND_FLEX_SERVER1.FF_VERROR) then
1632: return(FND_FLEX_SERVER1.VV_ERROR);
1633: else
1634: FND_MESSAGE.set_name('FND', 'FLEX-CONTEXT NOT FOUND');
1635: FND_MESSAGE.set_token('VALUE', context_segval);
1636: FND_MESSAGE.set_token('DFF', dff_info.name);
1637: return(FND_FLEX_SERVER1.VV_VALUES);
1638: end if;

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

1631: elsif(vcode = FND_FLEX_SERVER1.FF_VERROR) then
1632: return(FND_FLEX_SERVER1.VV_ERROR);
1633: else
1634: FND_MESSAGE.set_name('FND', 'FLEX-CONTEXT NOT FOUND');
1635: FND_MESSAGE.set_token('VALUE', context_segval);
1636: FND_MESSAGE.set_token('DFF', dff_info.name);
1637: return(FND_FLEX_SERVER1.VV_VALUES);
1638: end if;
1639:

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

1632: return(FND_FLEX_SERVER1.VV_ERROR);
1633: else
1634: FND_MESSAGE.set_name('FND', 'FLEX-CONTEXT NOT FOUND');
1635: FND_MESSAGE.set_token('VALUE', context_segval);
1636: FND_MESSAGE.set_token('DFF', dff_info.name);
1637: return(FND_FLEX_SERVER1.VV_VALUES);
1638: end if;
1639:
1640: return(FND_FLEX_SERVER1.VV_ERROR);

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

1640: return(FND_FLEX_SERVER1.VV_ERROR);
1641:
1642: EXCEPTION
1643: WHEN OTHERS then
1644: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
1645: FND_MESSAGE.set_token('MSG', 'validate_context() exception: '||SQLERRM);
1646: return(FND_FLEX_SERVER1.VV_ERROR);
1647:
1648: END validate_context;

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

1641:
1642: EXCEPTION
1643: WHEN OTHERS then
1644: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
1645: FND_MESSAGE.set_token('MSG', 'validate_context() exception: '||SQLERRM);
1646: return(FND_FLEX_SERVER1.VV_ERROR);
1647:
1648: END validate_context;
1649:

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

1686: return(TRUE);
1687:
1688: EXCEPTION
1689: WHEN OTHERS then
1690: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
1691: FND_MESSAGE.set_token('MSG','append_vsegarray() exception: '||SQLERRM);
1692: return(FALSE);
1693:
1694: END append_vsegarray;

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

1687:
1688: EXCEPTION
1689: WHEN OTHERS then
1690: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
1691: FND_MESSAGE.set_token('MSG','append_vsegarray() exception: '||SQLERRM);
1692: return(FALSE);
1693:
1694: END append_vsegarray;
1695:

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

1734: /* with the context segment input. If only one value matches that, */
1735: /* that context is returned. Otherwise the context is not found. */
1736: /* */
1737: /* Returns value validation code FND_FLEX_SERVER1.FF_VALID if ok. */
1738: /* Otherwise sets error message in FND_MESSAGE and returns */
1739: /* FF_VVALUES if not found or FF_VERROR on error. */
1740: /* ----------------------------------------------------------------------- */
1741:
1742: FUNCTION find_context_value(appl_id IN VARCHAR2,

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

1809: vcode := FND_FLEX_SERVER1.FF_CTXTNOSEG;
1810: -- IF(vcode = FND_FLEX_SERVER1.FF_CTXTNOSEG) THEN
1811: return(FND_FLEX_SERVER1.FF_CTXTNOSEG);
1812: -- ELSE
1813: -- FND_MESSAGE.set_name('FND', 'FLEX-CONTEXT NOT FOUND');
1814: -- FND_MESSAGE.set_token('VALUE', seg_in);
1815: -- FND_MESSAGE.set_token('DFF', dflex_name);
1816: -- return(FND_FLEX_SERVER1.FF_VNOTFOUND);
1817: -- END IF;

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

1810: -- IF(vcode = FND_FLEX_SERVER1.FF_CTXTNOSEG) THEN
1811: return(FND_FLEX_SERVER1.FF_CTXTNOSEG);
1812: -- ELSE
1813: -- FND_MESSAGE.set_name('FND', 'FLEX-CONTEXT NOT FOUND');
1814: -- FND_MESSAGE.set_token('VALUE', seg_in);
1815: -- FND_MESSAGE.set_token('DFF', dflex_name);
1816: -- return(FND_FLEX_SERVER1.FF_VNOTFOUND);
1817: -- END IF;
1818: WHEN OTHERS then

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

1811: return(FND_FLEX_SERVER1.FF_CTXTNOSEG);
1812: -- ELSE
1813: -- FND_MESSAGE.set_name('FND', 'FLEX-CONTEXT NOT FOUND');
1814: -- FND_MESSAGE.set_token('VALUE', seg_in);
1815: -- FND_MESSAGE.set_token('DFF', dflex_name);
1816: -- return(FND_FLEX_SERVER1.FF_VNOTFOUND);
1817: -- END IF;
1818: WHEN OTHERS then
1819: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');

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

1815: -- FND_MESSAGE.set_token('DFF', dflex_name);
1816: -- return(FND_FLEX_SERVER1.FF_VNOTFOUND);
1817: -- END IF;
1818: WHEN OTHERS then
1819: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
1820: FND_MESSAGE.set_token('MSG','find_context_value() exception: '||SQLERRM);
1821: return(FND_FLEX_SERVER1.FF_VERROR);
1822:
1823: END find_context_value;

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

1816: -- return(FND_FLEX_SERVER1.FF_VNOTFOUND);
1817: -- END IF;
1818: WHEN OTHERS then
1819: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
1820: FND_MESSAGE.set_token('MSG','find_context_value() exception: '||SQLERRM);
1821: return(FND_FLEX_SERVER1.FF_VERROR);
1822:
1823: END find_context_value;
1824:

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

1824:
1825: /* ----------------------------------------------------------------------- */
1826: /* Gets the name of the global context for the specified flexfield. */
1827: /* Error if the global context name is not enabled. */
1828: /* Returns TRUE if OK or FALSE and sets FND_MESSAGE if error. */
1829: /* ----------------------------------------------------------------------- */
1830:
1831: FUNCTION get_global_context(appl_id IN NUMBER,
1832: dflex_name IN VARCHAR2,

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

1867: return(TRUE);
1868:
1869: EXCEPTION
1870: WHEN NO_DATA_FOUND then
1871: FND_MESSAGE.set_name('FND', 'FLEX-NO ENABLED GLOBAL CONTEXT');
1872: return(FALSE);
1873: WHEN TOO_MANY_ROWS then
1874: FND_MESSAGE.set_name('FND', 'FLEX-DUPLICATE GLOBAL CONTEXTS');
1875: FND_MESSAGE.set_token('APID', appl_id);

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

1870: WHEN NO_DATA_FOUND then
1871: FND_MESSAGE.set_name('FND', 'FLEX-NO ENABLED GLOBAL CONTEXT');
1872: return(FALSE);
1873: WHEN TOO_MANY_ROWS then
1874: FND_MESSAGE.set_name('FND', 'FLEX-DUPLICATE GLOBAL CONTEXTS');
1875: FND_MESSAGE.set_token('APID', appl_id);
1876: FND_MESSAGE.set_token('NAME', dflex_name);
1877: return(FALSE);
1878: WHEN OTHERS then

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

1871: FND_MESSAGE.set_name('FND', 'FLEX-NO ENABLED GLOBAL CONTEXT');
1872: return(FALSE);
1873: WHEN TOO_MANY_ROWS then
1874: FND_MESSAGE.set_name('FND', 'FLEX-DUPLICATE GLOBAL CONTEXTS');
1875: FND_MESSAGE.set_token('APID', appl_id);
1876: FND_MESSAGE.set_token('NAME', dflex_name);
1877: return(FALSE);
1878: WHEN OTHERS then
1879: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');

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

1872: return(FALSE);
1873: WHEN TOO_MANY_ROWS then
1874: FND_MESSAGE.set_name('FND', 'FLEX-DUPLICATE GLOBAL CONTEXTS');
1875: FND_MESSAGE.set_token('APID', appl_id);
1876: FND_MESSAGE.set_token('NAME', dflex_name);
1877: return(FALSE);
1878: WHEN OTHERS then
1879: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
1880: FND_MESSAGE.set_token('MSG','get_global_context() exception: '||SQLERRM);

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

1875: FND_MESSAGE.set_token('APID', appl_id);
1876: FND_MESSAGE.set_token('NAME', dflex_name);
1877: return(FALSE);
1878: WHEN OTHERS then
1879: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
1880: FND_MESSAGE.set_token('MSG','get_global_context() exception: '||SQLERRM);
1881: return(FALSE);
1882: END get_global_context;
1883:

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

1876: FND_MESSAGE.set_token('NAME', dflex_name);
1877: return(FALSE);
1878: WHEN OTHERS then
1879: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
1880: FND_MESSAGE.set_token('MSG','get_global_context() exception: '||SQLERRM);
1881: return(FALSE);
1882: END get_global_context;
1883:
1884: /* ----------------------------------------------------------------------- */