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

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

240: return(TRUE);
241:
242: EXCEPTION
243: WHEN NO_DATA_FOUND then
244: FND_MESSAGE.set_name('FND', 'FLEX-CANNOT FIND STRUCT DEF');
245: FND_MESSAGE.set_token('ROUTINE', 'SV2.GET_KEYSTRUCT');
246: FND_MESSAGE.set_token('APPL', appl_sname);
247: FND_MESSAGE.set_token('CODE', flex_code);
248: FND_MESSAGE.set_token('NUM', to_char(flex_num));

Line 245: FND_MESSAGE.set_token('ROUTINE', 'SV2.GET_KEYSTRUCT');

241:
242: EXCEPTION
243: WHEN NO_DATA_FOUND then
244: FND_MESSAGE.set_name('FND', 'FLEX-CANNOT FIND STRUCT DEF');
245: FND_MESSAGE.set_token('ROUTINE', 'SV2.GET_KEYSTRUCT');
246: FND_MESSAGE.set_token('APPL', appl_sname);
247: FND_MESSAGE.set_token('CODE', flex_code);
248: FND_MESSAGE.set_token('NUM', to_char(flex_num));
249: return(FALSE);

Line 246: FND_MESSAGE.set_token('APPL', appl_sname);

242: EXCEPTION
243: WHEN NO_DATA_FOUND then
244: FND_MESSAGE.set_name('FND', 'FLEX-CANNOT FIND STRUCT DEF');
245: FND_MESSAGE.set_token('ROUTINE', 'SV2.GET_KEYSTRUCT');
246: FND_MESSAGE.set_token('APPL', appl_sname);
247: FND_MESSAGE.set_token('CODE', flex_code);
248: FND_MESSAGE.set_token('NUM', to_char(flex_num));
249: return(FALSE);
250: WHEN TOO_MANY_ROWS then

Line 247: FND_MESSAGE.set_token('CODE', flex_code);

243: WHEN NO_DATA_FOUND then
244: FND_MESSAGE.set_name('FND', 'FLEX-CANNOT FIND STRUCT DEF');
245: FND_MESSAGE.set_token('ROUTINE', 'SV2.GET_KEYSTRUCT');
246: FND_MESSAGE.set_token('APPL', appl_sname);
247: FND_MESSAGE.set_token('CODE', flex_code);
248: FND_MESSAGE.set_token('NUM', to_char(flex_num));
249: return(FALSE);
250: WHEN TOO_MANY_ROWS then
251: FND_MESSAGE.set_name('FND', 'FLEX-DUPLICATE STRUCT DEF');

Line 248: FND_MESSAGE.set_token('NUM', to_char(flex_num));

244: FND_MESSAGE.set_name('FND', 'FLEX-CANNOT FIND STRUCT DEF');
245: FND_MESSAGE.set_token('ROUTINE', 'SV2.GET_KEYSTRUCT');
246: FND_MESSAGE.set_token('APPL', appl_sname);
247: FND_MESSAGE.set_token('CODE', flex_code);
248: FND_MESSAGE.set_token('NUM', to_char(flex_num));
249: return(FALSE);
250: WHEN TOO_MANY_ROWS then
251: FND_MESSAGE.set_name('FND', 'FLEX-DUPLICATE STRUCT DEF');
252: FND_MESSAGE.set_token('ROUTINE', 'SV2.GET_KEYSTRUCT');

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

247: FND_MESSAGE.set_token('CODE', flex_code);
248: FND_MESSAGE.set_token('NUM', to_char(flex_num));
249: return(FALSE);
250: WHEN TOO_MANY_ROWS then
251: FND_MESSAGE.set_name('FND', 'FLEX-DUPLICATE STRUCT DEF');
252: FND_MESSAGE.set_token('ROUTINE', 'SV2.GET_KEYSTRUCT');
253: FND_MESSAGE.set_token('APPL', appl_sname);
254: FND_MESSAGE.set_token('CODE', flex_code);
255: FND_MESSAGE.set_token('NUM', to_char(flex_num));

Line 252: FND_MESSAGE.set_token('ROUTINE', 'SV2.GET_KEYSTRUCT');

248: FND_MESSAGE.set_token('NUM', to_char(flex_num));
249: return(FALSE);
250: WHEN TOO_MANY_ROWS then
251: FND_MESSAGE.set_name('FND', 'FLEX-DUPLICATE STRUCT DEF');
252: FND_MESSAGE.set_token('ROUTINE', 'SV2.GET_KEYSTRUCT');
253: FND_MESSAGE.set_token('APPL', appl_sname);
254: FND_MESSAGE.set_token('CODE', flex_code);
255: FND_MESSAGE.set_token('NUM', to_char(flex_num));
256: return(FALSE);

Line 253: FND_MESSAGE.set_token('APPL', appl_sname);

249: return(FALSE);
250: WHEN TOO_MANY_ROWS then
251: FND_MESSAGE.set_name('FND', 'FLEX-DUPLICATE STRUCT DEF');
252: FND_MESSAGE.set_token('ROUTINE', 'SV2.GET_KEYSTRUCT');
253: FND_MESSAGE.set_token('APPL', appl_sname);
254: FND_MESSAGE.set_token('CODE', flex_code);
255: FND_MESSAGE.set_token('NUM', to_char(flex_num));
256: return(FALSE);
257: WHEN OTHERS then

Line 254: FND_MESSAGE.set_token('CODE', flex_code);

250: WHEN TOO_MANY_ROWS then
251: FND_MESSAGE.set_name('FND', 'FLEX-DUPLICATE STRUCT DEF');
252: FND_MESSAGE.set_token('ROUTINE', 'SV2.GET_KEYSTRUCT');
253: FND_MESSAGE.set_token('APPL', appl_sname);
254: FND_MESSAGE.set_token('CODE', flex_code);
255: FND_MESSAGE.set_token('NUM', to_char(flex_num));
256: return(FALSE);
257: WHEN OTHERS then
258: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');

Line 255: FND_MESSAGE.set_token('NUM', to_char(flex_num));

251: FND_MESSAGE.set_name('FND', 'FLEX-DUPLICATE STRUCT DEF');
252: FND_MESSAGE.set_token('ROUTINE', 'SV2.GET_KEYSTRUCT');
253: FND_MESSAGE.set_token('APPL', appl_sname);
254: FND_MESSAGE.set_token('CODE', flex_code);
255: FND_MESSAGE.set_token('NUM', to_char(flex_num));
256: return(FALSE);
257: WHEN OTHERS then
258: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
259: FND_MESSAGE.set_token('MSG', 'SV2.get_keystruct() exception: ' || SQLERRM);

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

254: FND_MESSAGE.set_token('CODE', flex_code);
255: FND_MESSAGE.set_token('NUM', to_char(flex_num));
256: return(FALSE);
257: WHEN OTHERS then
258: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
259: FND_MESSAGE.set_token('MSG', 'SV2.get_keystruct() exception: ' || SQLERRM);
260: return(FALSE);
261:
262: END get_keystruct;

Line 259: FND_MESSAGE.set_token('MSG', 'SV2.get_keystruct() exception: ' || SQLERRM);

255: FND_MESSAGE.set_token('NUM', to_char(flex_num));
256: return(FALSE);
257: WHEN OTHERS then
258: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
259: FND_MESSAGE.set_token('MSG', 'SV2.get_keystruct() exception: ' || SQLERRM);
260: return(FALSE);
261:
262: END get_keystruct;
263:

Line 267: /* FND_MESSAGE to error name if not found or error. */

263:
264: /* ----------------------------------------------------------------------- */
265: /* Function to get descriptive flexfield information. */
266: /* Returns TRUE and DescFlexInfo on success or FALSE and sets */
267: /* FND_MESSAGE to error name if not found or error. */
268: /* ----------------------------------------------------------------------- */
269:
270: FUNCTION get_descstruct(flex_app_sname IN VARCHAR2,
271: desc_flex_name IN VARCHAR2,

Line 341: FND_MESSAGE.set_name('FND', 'FLEX-DESC DEF NOT FOUND');

337: return(TRUE);
338:
339: EXCEPTION
340: WHEN NO_DATA_FOUND then
341: FND_MESSAGE.set_name('FND', 'FLEX-DESC DEF NOT FOUND');
342: FND_MESSAGE.set_token('APPID', flex_app_sname);
343: FND_MESSAGE.set_token('DESCR_FLEX_NAME', desc_flex_name);
344: return(FALSE);
345: WHEN OTHERS then

Line 342: FND_MESSAGE.set_token('APPID', flex_app_sname);

338:
339: EXCEPTION
340: WHEN NO_DATA_FOUND then
341: FND_MESSAGE.set_name('FND', 'FLEX-DESC DEF NOT FOUND');
342: FND_MESSAGE.set_token('APPID', flex_app_sname);
343: FND_MESSAGE.set_token('DESCR_FLEX_NAME', desc_flex_name);
344: return(FALSE);
345: WHEN OTHERS then
346: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');

Line 343: FND_MESSAGE.set_token('DESCR_FLEX_NAME', desc_flex_name);

339: EXCEPTION
340: WHEN NO_DATA_FOUND then
341: FND_MESSAGE.set_name('FND', 'FLEX-DESC DEF NOT FOUND');
342: FND_MESSAGE.set_token('APPID', flex_app_sname);
343: FND_MESSAGE.set_token('DESCR_FLEX_NAME', desc_flex_name);
344: return(FALSE);
345: WHEN OTHERS then
346: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
347: FND_MESSAGE.set_token('MSG','SV2.get_descstruct() exception: ' || SQLERRM);

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

342: FND_MESSAGE.set_token('APPID', flex_app_sname);
343: FND_MESSAGE.set_token('DESCR_FLEX_NAME', desc_flex_name);
344: return(FALSE);
345: WHEN OTHERS then
346: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
347: FND_MESSAGE.set_token('MSG','SV2.get_descstruct() exception: ' || SQLERRM);
348: return(FALSE);
349:
350: END get_descstruct;

Line 347: FND_MESSAGE.set_token('MSG','SV2.get_descstruct() exception: ' || SQLERRM);

343: FND_MESSAGE.set_token('DESCR_FLEX_NAME', desc_flex_name);
344: return(FALSE);
345: WHEN OTHERS then
346: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
347: FND_MESSAGE.set_token('MSG','SV2.get_descstruct() exception: ' || SQLERRM);
348: return(FALSE);
349:
350: END get_descstruct;
351:

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

450: g_cache_values);
451: END IF;
452:
453: IF (g_cache_numof_values < 1) THEN
454: FND_MESSAGE.set_name('FND', 'FLEX-CANT FIND SEGMENTS');
455: FND_MESSAGE.set_token('ROUTINE', 'Get Comb Table Column Names');
456: FND_MESSAGE.set_token('APPID', to_char(fstruct.application_id));
457: FND_MESSAGE.set_token('CODE', fstruct.id_flex_code);
458: FND_MESSAGE.set_token('NUM', to_char(fstruct.id_flex_num));

Line 455: FND_MESSAGE.set_token('ROUTINE', 'Get Comb Table Column Names');

451: END IF;
452:
453: IF (g_cache_numof_values < 1) THEN
454: FND_MESSAGE.set_name('FND', 'FLEX-CANT FIND SEGMENTS');
455: FND_MESSAGE.set_token('ROUTINE', 'Get Comb Table Column Names');
456: FND_MESSAGE.set_token('APPID', to_char(fstruct.application_id));
457: FND_MESSAGE.set_token('CODE', fstruct.id_flex_code);
458: FND_MESSAGE.set_token('NUM', to_char(fstruct.id_flex_num));
459: return(FALSE);

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

452:
453: IF (g_cache_numof_values < 1) THEN
454: FND_MESSAGE.set_name('FND', 'FLEX-CANT FIND SEGMENTS');
455: FND_MESSAGE.set_token('ROUTINE', 'Get Comb Table Column Names');
456: FND_MESSAGE.set_token('APPID', to_char(fstruct.application_id));
457: FND_MESSAGE.set_token('CODE', fstruct.id_flex_code);
458: FND_MESSAGE.set_token('NUM', to_char(fstruct.id_flex_num));
459: return(FALSE);
460: END IF;

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

453: IF (g_cache_numof_values < 1) THEN
454: FND_MESSAGE.set_name('FND', 'FLEX-CANT FIND SEGMENTS');
455: FND_MESSAGE.set_token('ROUTINE', 'Get Comb Table Column Names');
456: FND_MESSAGE.set_token('APPID', to_char(fstruct.application_id));
457: FND_MESSAGE.set_token('CODE', fstruct.id_flex_code);
458: FND_MESSAGE.set_token('NUM', to_char(fstruct.id_flex_num));
459: return(FALSE);
460: END IF;
461: ELSE

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

454: FND_MESSAGE.set_name('FND', 'FLEX-CANT FIND SEGMENTS');
455: FND_MESSAGE.set_token('ROUTINE', 'Get Comb Table Column Names');
456: FND_MESSAGE.set_token('APPID', to_char(fstruct.application_id));
457: FND_MESSAGE.set_token('CODE', fstruct.id_flex_code);
458: FND_MESSAGE.set_token('NUM', to_char(fstruct.id_flex_num));
459: return(FALSE);
460: END IF;
461: ELSE
462: g_cache_key := ('DFF.' ||

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

512: RETURN(TRUE);
513:
514: EXCEPTION
515: WHEN OTHERS then
516: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
517: FND_MESSAGE.set_token('MSG', 'SV2.get_struct_cols() exception: '||SQLERRM);
518: return(FALSE);
519: END get_struct_cols;
520:

Line 517: FND_MESSAGE.set_token('MSG', 'SV2.get_struct_cols() exception: '||SQLERRM);

513:
514: EXCEPTION
515: WHEN OTHERS then
516: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
517: FND_MESSAGE.set_token('MSG', 'SV2.get_struct_cols() exception: '||SQLERRM);
518: return(FALSE);
519: END get_struct_cols;
520:
521: /* ----------------------------------------------------------------------- */

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

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

Line 590: FND_MESSAGE.set_token('MSG', 'SV2.get_all_segquals() exception: ' ||SQLERRM);

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

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

722: END IF;
723: end loop;
724: -- Key flexfield must have enabled segments
725: if(n_fqual <= 0) then
726: FND_MESSAGE.set_name('FND', 'FLEX-CANT FIND SEGMENTS');
727: FND_MESSAGE.set_token('ROUTINE', 'FND_FLEX_SERVER2.get_qualsegs()');
728: FND_MESSAGE.set_token('APPID', to_char(fstruct.application_id));
729: FND_MESSAGE.set_token('CODE', fstruct.id_flex_code);
730: FND_MESSAGE.set_token('NUM', to_char(fstruct.id_flex_num));

Line 727: FND_MESSAGE.set_token('ROUTINE', 'FND_FLEX_SERVER2.get_qualsegs()');

723: end loop;
724: -- Key flexfield must have enabled segments
725: if(n_fqual <= 0) then
726: FND_MESSAGE.set_name('FND', 'FLEX-CANT FIND SEGMENTS');
727: FND_MESSAGE.set_token('ROUTINE', 'FND_FLEX_SERVER2.get_qualsegs()');
728: FND_MESSAGE.set_token('APPID', to_char(fstruct.application_id));
729: FND_MESSAGE.set_token('CODE', fstruct.id_flex_code);
730: FND_MESSAGE.set_token('NUM', to_char(fstruct.id_flex_num));
731: return(FALSE);

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

724: -- Key flexfield must have enabled segments
725: if(n_fqual <= 0) then
726: FND_MESSAGE.set_name('FND', 'FLEX-CANT FIND SEGMENTS');
727: FND_MESSAGE.set_token('ROUTINE', 'FND_FLEX_SERVER2.get_qualsegs()');
728: FND_MESSAGE.set_token('APPID', to_char(fstruct.application_id));
729: FND_MESSAGE.set_token('CODE', fstruct.id_flex_code);
730: FND_MESSAGE.set_token('NUM', to_char(fstruct.id_flex_num));
731: return(FALSE);
732: end if;

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

725: if(n_fqual <= 0) then
726: FND_MESSAGE.set_name('FND', 'FLEX-CANT FIND SEGMENTS');
727: FND_MESSAGE.set_token('ROUTINE', 'FND_FLEX_SERVER2.get_qualsegs()');
728: FND_MESSAGE.set_token('APPID', to_char(fstruct.application_id));
729: FND_MESSAGE.set_token('CODE', fstruct.id_flex_code);
730: FND_MESSAGE.set_token('NUM', to_char(fstruct.id_flex_num));
731: return(FALSE);
732: end if;
733: else

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

726: FND_MESSAGE.set_name('FND', 'FLEX-CANT FIND SEGMENTS');
727: FND_MESSAGE.set_token('ROUTINE', 'FND_FLEX_SERVER2.get_qualsegs()');
728: FND_MESSAGE.set_token('APPID', to_char(fstruct.application_id));
729: FND_MESSAGE.set_token('CODE', fstruct.id_flex_code);
730: FND_MESSAGE.set_token('NUM', to_char(fstruct.id_flex_num));
731: return(FALSE);
732: end if;
733: else
734: -- Descriptive flexfield segments

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

797: WHEN OTHERS THEN
798: IF (fnd_flex_server1.g_debug_level > 0) THEN
799: fnd_flex_server1.add_debug('EXCEPTION others SV2.get_qualsegs()');
800: END IF;
801: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
802: FND_MESSAGE.set_token('MSG','SV2.get_qualsegs() exception: ' || SQLERRM);
803: return(FALSE);
804:
805: END get_qualsegs;

Line 802: FND_MESSAGE.set_token('MSG','SV2.get_qualsegs() exception: ' || SQLERRM);

798: IF (fnd_flex_server1.g_debug_level > 0) THEN
799: fnd_flex_server1.add_debug('EXCEPTION others SV2.get_qualsegs()');
800: END IF;
801: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
802: FND_MESSAGE.set_token('MSG','SV2.get_qualsegs() exception: ' || SQLERRM);
803: return(FALSE);
804:
805: END get_qualsegs;
806:

Line 812: /* FND_MESSAGE if not valid. */

808: /* Performes cross-validation against validation rules. */
809: /* Returns VV_VALID if combination valid, VV_CROSSVAL if */
810: /* rule violated or VV_ERROR if error. */
811: /* Returns error_column_name and sets error message in */
812: /* FND_MESSAGE if not valid. */
813: /* Segment array is 1-based containing entries for 1 <= i <= nsegs */
814: /* ----------------------------------------------------------------------- */
815:
816: FUNCTION cross_validate(nsegs IN NUMBER,

Line 880: FND_MESSAGE.set_name('FND', 'FLEX-EXCLUDED BY XVAL RULE');

876: where application_id = fstruct.application_id
877: and id_flex_code = fstruct.id_flex_code
878: and id_flex_num = fstruct.id_flex_num
879: and flex_validation_rule_name = rulename;
880: FND_MESSAGE.set_name('FND', 'FLEX-EXCLUDED BY XVAL RULE');
881: FND_MESSAGE.set_token('MESSAGE', rulemsg);
882: return(FND_FLEX_SERVER1.VV_CROSSVAL);
883: end if;
884: return(FND_FLEX_SERVER1.VV_ERROR);

Line 881: FND_MESSAGE.set_token('MESSAGE', rulemsg);

877: and id_flex_code = fstruct.id_flex_code
878: and id_flex_num = fstruct.id_flex_num
879: and flex_validation_rule_name = rulename;
880: FND_MESSAGE.set_name('FND', 'FLEX-EXCLUDED BY XVAL RULE');
881: FND_MESSAGE.set_token('MESSAGE', rulemsg);
882: return(FND_FLEX_SERVER1.VV_CROSSVAL);
883: end if;
884: return(FND_FLEX_SERVER1.VV_ERROR);
885: end if;

Line 890: FND_MESSAGE.set_name('FND', 'FLEX-XVAL RULE MSG NOT FOUND');

886: return(FND_FLEX_SERVER1.VV_VALID);
887:
888: EXCEPTION
889: WHEN NO_DATA_FOUND then
890: FND_MESSAGE.set_name('FND', 'FLEX-XVAL RULE MSG NOT FOUND');
891: FND_MESSAGE.set_token('RULENAME', rulename);
892: return(FND_FLEX_SERVER1.VV_ERROR);
893: WHEN TOO_MANY_ROWS then
894: FND_MESSAGE.set_name('FND', 'FLEX-XVAL RULE MSG NOT UNIQUE');

Line 891: FND_MESSAGE.set_token('RULENAME', rulename);

887:
888: EXCEPTION
889: WHEN NO_DATA_FOUND then
890: FND_MESSAGE.set_name('FND', 'FLEX-XVAL RULE MSG NOT FOUND');
891: FND_MESSAGE.set_token('RULENAME', rulename);
892: return(FND_FLEX_SERVER1.VV_ERROR);
893: WHEN TOO_MANY_ROWS then
894: FND_MESSAGE.set_name('FND', 'FLEX-XVAL RULE MSG NOT UNIQUE');
895: FND_MESSAGE.set_token('RULENAME', rulename);

Line 894: FND_MESSAGE.set_name('FND', 'FLEX-XVAL RULE MSG NOT UNIQUE');

890: FND_MESSAGE.set_name('FND', 'FLEX-XVAL RULE MSG NOT FOUND');
891: FND_MESSAGE.set_token('RULENAME', rulename);
892: return(FND_FLEX_SERVER1.VV_ERROR);
893: WHEN TOO_MANY_ROWS then
894: FND_MESSAGE.set_name('FND', 'FLEX-XVAL RULE MSG NOT UNIQUE');
895: FND_MESSAGE.set_token('RULENAME', rulename);
896: return(FND_FLEX_SERVER1.VV_ERROR);
897: WHEN OTHERS then
898: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');

Line 895: FND_MESSAGE.set_token('RULENAME', rulename);

891: FND_MESSAGE.set_token('RULENAME', rulename);
892: return(FND_FLEX_SERVER1.VV_ERROR);
893: WHEN TOO_MANY_ROWS then
894: FND_MESSAGE.set_name('FND', 'FLEX-XVAL RULE MSG NOT UNIQUE');
895: FND_MESSAGE.set_token('RULENAME', rulename);
896: return(FND_FLEX_SERVER1.VV_ERROR);
897: WHEN OTHERS then
898: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
899: FND_MESSAGE.set_token('MSG','SV2.cross_validate() exception: '||SQLERRM);

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

894: FND_MESSAGE.set_name('FND', 'FLEX-XVAL RULE MSG NOT UNIQUE');
895: FND_MESSAGE.set_token('RULENAME', rulename);
896: return(FND_FLEX_SERVER1.VV_ERROR);
897: WHEN OTHERS then
898: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
899: FND_MESSAGE.set_token('MSG','SV2.cross_validate() exception: '||SQLERRM);
900: return(FND_FLEX_SERVER1.VV_ERROR);
901: END cross_validate;
902:

Line 899: FND_MESSAGE.set_token('MSG','SV2.cross_validate() exception: '||SQLERRM);

895: FND_MESSAGE.set_token('RULENAME', rulename);
896: return(FND_FLEX_SERVER1.VV_ERROR);
897: WHEN OTHERS then
898: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
899: FND_MESSAGE.set_token('MSG','SV2.cross_validate() exception: '||SQLERRM);
900: return(FND_FLEX_SERVER1.VV_ERROR);
901: END cross_validate;
902:
903: /* ----------------------------------------------------------------------- */

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

986: return(isviolated);
987:
988: EXCEPTION
989: WHEN OTHERS then
990: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
991: FND_MESSAGE.set_token('MSG','SV2.cv_rule_violated() exception: ' || SQLERRM);
992: rule_name := NULL;
993: return(TRUE);
994: END cv_rule_violated;

Line 991: FND_MESSAGE.set_token('MSG','SV2.cv_rule_violated() exception: ' || SQLERRM);

987:
988: EXCEPTION
989: WHEN OTHERS then
990: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
991: FND_MESSAGE.set_token('MSG','SV2.cv_rule_violated() exception: ' || SQLERRM);
992: rule_name := NULL;
993: return(TRUE);
994: END cv_rule_violated;
995:

Line 1056: FND_MESSAGE.set_name('FND', 'FLEX-DSQL EXCEPTION');

1052: WHEN OTHERS then
1053: if(dbms_sql.is_open(cursornum)) then
1054: dbms_sql.close_cursor(cursornum);
1055: end if;
1056: FND_MESSAGE.set_name('FND', 'FLEX-DSQL EXCEPTION');
1057: FND_MESSAGE.set_token('MSG', SQLERRM);
1058: FND_MESSAGE.set_token('SQLSTR', SUBSTRB(sql_str, 1, 1000));
1059: return(-1);
1060: END x_cv_rule_select;

Line 1057: FND_MESSAGE.set_token('MSG', SQLERRM);

1053: if(dbms_sql.is_open(cursornum)) then
1054: dbms_sql.close_cursor(cursornum);
1055: end if;
1056: FND_MESSAGE.set_name('FND', 'FLEX-DSQL EXCEPTION');
1057: FND_MESSAGE.set_token('MSG', SQLERRM);
1058: FND_MESSAGE.set_token('SQLSTR', SUBSTRB(sql_str, 1, 1000));
1059: return(-1);
1060: END x_cv_rule_select;
1061:

Line 1058: FND_MESSAGE.set_token('SQLSTR', SUBSTRB(sql_str, 1, 1000));

1054: dbms_sql.close_cursor(cursornum);
1055: end if;
1056: FND_MESSAGE.set_name('FND', 'FLEX-DSQL EXCEPTION');
1057: FND_MESSAGE.set_token('MSG', SQLERRM);
1058: FND_MESSAGE.set_token('SQLSTR', SUBSTRB(sql_str, 1, 1000));
1059: return(-1);
1060: END x_cv_rule_select;
1061:
1062: /* ----------------------------------------------------------------------- */

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

1125:
1126: return(TRUE);
1127: EXCEPTION
1128: WHEN OTHERS then
1129: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
1130: FND_MESSAGE.set_token('MSG','SV2.x_xvc_check_cache() exception: ' || SQLERRM);
1131: return(FALSE);
1132: END x_xvc_check_cache;
1133:

Line 1130: FND_MESSAGE.set_token('MSG','SV2.x_xvc_check_cache() exception: ' || SQLERRM);

1126: return(TRUE);
1127: EXCEPTION
1128: WHEN OTHERS then
1129: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
1130: FND_MESSAGE.set_token('MSG','SV2.x_xvc_check_cache() exception: ' || SQLERRM);
1131: return(FALSE);
1132: END x_xvc_check_cache;
1133:
1134: /* ----------------------------------------------------------------------- */

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

1213: return(TRUE);
1214:
1215: EXCEPTION
1216: WHEN OTHERS then
1217: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
1218: FND_MESSAGE.set_token('MSG','SV2.x_xvc_cache_result() exception: ' || SQLERRM);
1219: return(FALSE);
1220:
1221: END x_xvc_update_cache;

Line 1218: FND_MESSAGE.set_token('MSG','SV2.x_xvc_cache_result() exception: ' || SQLERRM);

1214:
1215: EXCEPTION
1216: WHEN OTHERS then
1217: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
1218: FND_MESSAGE.set_token('MSG','SV2.x_xvc_cache_result() exception: ' || SQLERRM);
1219: return(FALSE);
1220:
1221: END x_xvc_update_cache;
1222:

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

1277: return(TRUE);
1278:
1279: EXCEPTION
1280: WHEN OTHERS then
1281: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
1282: FND_MESSAGE.set_token('MSG','SV2.x_drop_cached_cv_result() exception: '
1283: || SQLERRM);
1284: return(FALSE);
1285:

Line 1282: FND_MESSAGE.set_token('MSG','SV2.x_drop_cached_cv_result() exception: '

1278:
1279: EXCEPTION
1280: WHEN OTHERS then
1281: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
1282: FND_MESSAGE.set_token('MSG','SV2.x_drop_cached_cv_result() exception: '
1283: || SQLERRM);
1284: return(FALSE);
1285:
1286: END x_drop_cached_cv_result;

Line 1309: /* and sets error using FND_MESSAGE on error. */

1305: /* in which case the delimiter is not substituted. */
1306: /* The parsed displayed segments token is input to count the number */
1307: /* of segments expected. */
1308: /* Returns TRUE and nsegs_out > 0 if all ok, or FALSE, nsegs_out = 0, */
1309: /* and sets error using FND_MESSAGE on error. */
1310: /* ----------------------------------------------------------------------- */
1311:
1312: FUNCTION breakup_catsegs(catsegs IN VARCHAR2,
1313: delim IN VARCHAR2,

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

1398:
1399: -- Check to make sure there are not too many segments.
1400: --
1401: if(disp_nsegs > MAX_NSEGS) then
1402: FND_MESSAGE.set_name('FND', 'FLEX-TOO MANY SEGS');
1403: FND_MESSAGE.set_token('NSEGS', MAX_NSEGS);
1404: return(FALSE);
1405: end if;
1406:

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

1399: -- Check to make sure there are not too many segments.
1400: --
1401: if(disp_nsegs > MAX_NSEGS) then
1402: FND_MESSAGE.set_name('FND', 'FLEX-TOO MANY SEGS');
1403: FND_MESSAGE.set_token('NSEGS', MAX_NSEGS);
1404: return(FALSE);
1405: end if;
1406:
1407: -- Return the segment count

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

1409: return(TRUE);
1410:
1411: EXCEPTION
1412: WHEN OTHERS then
1413: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
1414: FND_MESSAGE.set_token('MSG','SV2.breakup_catsegs() exception: '||SQLERRM);
1415: return(FALSE);
1416:
1417: END breakup_catsegs;

Line 1414: FND_MESSAGE.set_token('MSG','SV2.breakup_catsegs() exception: '||SQLERRM);

1410:
1411: EXCEPTION
1412: WHEN OTHERS then
1413: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
1414: FND_MESSAGE.set_token('MSG','SV2.breakup_catsegs() exception: '||SQLERRM);
1415: return(FALSE);
1416:
1417: END breakup_catsegs;
1418:

Line 1653: cp_debug('MESSAGE : ' || fnd_message.get);

1649:
1650: IF (l_sub_request_id = 0) THEN
1651: null;
1652: cp_debug('ERROR : Unable to submit sub request.');
1653: cp_debug('MESSAGE : ' || fnd_message.get);
1654: END IF;
1655: END LOOP;
1656:
1657: END;