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

Line 144: -- Only set first value error message in FND_MESSAGE

140: g_debug_text VARCHAR2(2000);
141:
142: -- Error message information for value error message handling.
143: -- Value errors are generated by incorrect user input.
144: -- Only set first value error message in FND_MESSAGE
145: -- All other error messages override value errors.
146: value_error_set BOOLEAN;
147: entering_new_message BOOLEAN;
148:

Line 475: fnd_message.set_encoded(g_cache_value.varchar2_2);

471: px_error_code := g_cache_value.varchar2_1;
472: IF (px_error_code = FF_VVALID) THEN
473: RETURN(fnd_plsql_cache.CACHE_VALID);
474: ELSE
475: fnd_message.set_encoded(g_cache_value.varchar2_2);
476: RETURN(fnd_plsql_cache.CACHE_INVALID);
477: END IF;
478: ELSE
479: RETURN(g_cache_return_code);

Line 505: l_enc_err_msg := fnd_message.get_encoded;

501: p_value_set_id || '.' ||
502: p_value);
503:
504: IF (p_error_code <> FF_VVALID) THEN
505: l_enc_err_msg := fnd_message.get_encoded;
506: fnd_message.set_encoded(l_enc_err_msg);
507: END IF;
508:
509: fnd_plsql_cache.generic_cache_new_value

Line 506: fnd_message.set_encoded(l_enc_err_msg);

502: p_value);
503:
504: IF (p_error_code <> FF_VVALID) THEN
505: l_enc_err_msg := fnd_message.get_encoded;
506: fnd_message.set_encoded(l_enc_err_msg);
507: END IF;
508:
509: fnd_plsql_cache.generic_cache_new_value
510: (x_value => g_cache_value,

Line 746: FND_MESSAGE.set_name('FND', 'FLEX-NO PARENT SEGMENT');

742: exit;
743: end if;
744: end loop;
745: if(parentindex = 0) then
746: FND_MESSAGE.set_name('FND', 'FLEX-NO PARENT SEGMENT');
747: FND_MESSAGE.set_token('CHILD', to_char(segcounter));
748: l_return_code := -3;
749: GOTO goto_return;
750: end if;

Line 747: FND_MESSAGE.set_token('CHILD', to_char(segcounter));

743: end if;
744: end loop;
745: if(parentindex = 0) then
746: FND_MESSAGE.set_name('FND', 'FLEX-NO PARENT SEGMENT');
747: FND_MESSAGE.set_token('CHILD', to_char(segcounter));
748: l_return_code := -3;
749: GOTO goto_return;
750: end if;
751: end if;

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

781:
782: -- Note error if no enabled segments for this flexfield.
783: --
784: if(fstruct.isa_key_flexfield and (segcounter <= 0)) then
785: FND_MESSAGE.set_name('FND', 'FLEX-CANT FIND SEGMENTS');
786: FND_MESSAGE.set_token('ROUTINE', 'Validate Values');
787: FND_MESSAGE.set_token('APPID', to_char(fstruct.application_id));
788: FND_MESSAGE.set_token('CODE', fstruct.id_flex_code);
789: FND_MESSAGE.set_token('NUM', to_char(fstruct.id_flex_num));

Line 786: FND_MESSAGE.set_token('ROUTINE', 'Validate Values');

782: -- Note error if no enabled segments for this flexfield.
783: --
784: if(fstruct.isa_key_flexfield and (segcounter <= 0)) then
785: FND_MESSAGE.set_name('FND', 'FLEX-CANT FIND SEGMENTS');
786: FND_MESSAGE.set_token('ROUTINE', 'Validate Values');
787: FND_MESSAGE.set_token('APPID', to_char(fstruct.application_id));
788: FND_MESSAGE.set_token('CODE', fstruct.id_flex_code);
789: FND_MESSAGE.set_token('NUM', to_char(fstruct.id_flex_num));
790: l_return_code := -1;

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

783: --
784: if(fstruct.isa_key_flexfield and (segcounter <= 0)) then
785: FND_MESSAGE.set_name('FND', 'FLEX-CANT FIND SEGMENTS');
786: FND_MESSAGE.set_token('ROUTINE', 'Validate Values');
787: FND_MESSAGE.set_token('APPID', to_char(fstruct.application_id));
788: FND_MESSAGE.set_token('CODE', fstruct.id_flex_code);
789: FND_MESSAGE.set_token('NUM', to_char(fstruct.id_flex_num));
790: l_return_code := -1;
791: GOTO goto_return;

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

784: if(fstruct.isa_key_flexfield and (segcounter <= 0)) then
785: FND_MESSAGE.set_name('FND', 'FLEX-CANT FIND SEGMENTS');
786: FND_MESSAGE.set_token('ROUTINE', 'Validate Values');
787: FND_MESSAGE.set_token('APPID', to_char(fstruct.application_id));
788: FND_MESSAGE.set_token('CODE', fstruct.id_flex_code);
789: FND_MESSAGE.set_token('NUM', to_char(fstruct.id_flex_num));
790: l_return_code := -1;
791: GOTO goto_return;
792: end if;

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

785: FND_MESSAGE.set_name('FND', 'FLEX-CANT FIND SEGMENTS');
786: FND_MESSAGE.set_token('ROUTINE', 'Validate Values');
787: FND_MESSAGE.set_token('APPID', to_char(fstruct.application_id));
788: FND_MESSAGE.set_token('CODE', fstruct.id_flex_code);
789: FND_MESSAGE.set_token('NUM', to_char(fstruct.id_flex_num));
790: l_return_code := -1;
791: GOTO goto_return;
792: end if;
793:

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

804: IF (fnd_flex_server1.g_debug_level > 0) THEN
805: add_debug('EXCEPTION no_data_found SV1.vals_secured()');
806: END IF;
807: if(fstruct.isa_key_flexfield) then
808: FND_MESSAGE.set_name('FND', 'FLEX-CANT FIND SEGMENTS');
809: FND_MESSAGE.set_token('ROUTINE', 'Validate Values');
810: FND_MESSAGE.set_token('APPID', to_char(fstruct.application_id));
811: FND_MESSAGE.set_token('CODE', fstruct.id_flex_code);
812: FND_MESSAGE.set_token('NUM', to_char(fstruct.id_flex_num));

Line 809: FND_MESSAGE.set_token('ROUTINE', 'Validate Values');

805: add_debug('EXCEPTION no_data_found SV1.vals_secured()');
806: END IF;
807: if(fstruct.isa_key_flexfield) then
808: FND_MESSAGE.set_name('FND', 'FLEX-CANT FIND SEGMENTS');
809: FND_MESSAGE.set_token('ROUTINE', 'Validate Values');
810: FND_MESSAGE.set_token('APPID', to_char(fstruct.application_id));
811: FND_MESSAGE.set_token('CODE', fstruct.id_flex_code);
812: FND_MESSAGE.set_token('NUM', to_char(fstruct.id_flex_num));
813: return(-1);

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

806: END IF;
807: if(fstruct.isa_key_flexfield) then
808: FND_MESSAGE.set_name('FND', 'FLEX-CANT FIND SEGMENTS');
809: FND_MESSAGE.set_token('ROUTINE', 'Validate Values');
810: FND_MESSAGE.set_token('APPID', to_char(fstruct.application_id));
811: FND_MESSAGE.set_token('CODE', fstruct.id_flex_code);
812: FND_MESSAGE.set_token('NUM', to_char(fstruct.id_flex_num));
813: return(-1);
814: end if;

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

807: if(fstruct.isa_key_flexfield) then
808: FND_MESSAGE.set_name('FND', 'FLEX-CANT FIND SEGMENTS');
809: FND_MESSAGE.set_token('ROUTINE', 'Validate Values');
810: FND_MESSAGE.set_token('APPID', to_char(fstruct.application_id));
811: FND_MESSAGE.set_token('CODE', fstruct.id_flex_code);
812: FND_MESSAGE.set_token('NUM', to_char(fstruct.id_flex_num));
813: return(-1);
814: end if;
815: return(0);

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

808: FND_MESSAGE.set_name('FND', 'FLEX-CANT FIND SEGMENTS');
809: FND_MESSAGE.set_token('ROUTINE', 'Validate Values');
810: FND_MESSAGE.set_token('APPID', to_char(fstruct.application_id));
811: FND_MESSAGE.set_token('CODE', fstruct.id_flex_code);
812: FND_MESSAGE.set_token('NUM', to_char(fstruct.id_flex_num));
813: return(-1);
814: end if;
815: return(0);
816: WHEN OTHERS then

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

813: return(-1);
814: end if;
815: return(0);
816: WHEN OTHERS then
817: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
818: FND_MESSAGE.set_token('MSG', 'vals_secured() exception: ' || SQLERRM);
819: IF (fnd_flex_server1.g_debug_level > 0) THEN
820: add_debug('EXCEPTION others SV1.vals_secured()');
821: END IF;

Line 818: FND_MESSAGE.set_token('MSG', 'vals_secured() exception: ' || SQLERRM);

814: end if;
815: return(0);
816: WHEN OTHERS then
817: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
818: FND_MESSAGE.set_token('MSG', 'vals_secured() exception: ' || SQLERRM);
819: IF (fnd_flex_server1.g_debug_level > 0) THEN
820: add_debug('EXCEPTION others SV1.vals_secured()');
821: END IF;
822: return(-2);

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

1138: not ((nsegs_in = 0) and (dispsegcount = 1))) then
1139: --
1140: -- Not enough segment values are passed and this is not OK.
1141: --
1142: FND_MESSAGE.set_name('FND', 'FLEX-MISSING CONCAT VALUES');
1143: errseg_num := segcount;
1144: segcount := segcount - 1;
1145: return_code := VV_ERROR;
1146: goto return_values;

Line 1213: -- error message will only have been put into FND_MESSAGE if it is the

1209: -- on the server, then set errseg_num to current segment since this error has
1210: -- overwritten any prior value errors, and then return.
1211: -- If value is secured or other value error note the error in the local flag
1212: -- and optionally stop depending on the vflags. In these cases the value
1213: -- error message will only have been put into FND_MESSAGE if it is the
1214: -- first error, so set errseg_num only if it's null.
1215: --
1216: IF (v_status = FF_VVALID) then
1217: this_dval.start_valid := l_flexvalue.start_valid;

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

1255: end loop;
1256:
1257: if(fstruct.isa_key_flexfield) then
1258: if(segcount <= 0) then
1259: FND_MESSAGE.set_name('FND', 'FLEX-CANT FIND SEGMENTS');
1260: FND_MESSAGE.set_token('ROUTINE', 'Validate Values');
1261: FND_MESSAGE.set_token('APPID', to_char(fstruct.application_id));
1262: FND_MESSAGE.set_token('CODE', fstruct.id_flex_code);
1263: FND_MESSAGE.set_token('NUM', to_char(fstruct.id_flex_num));

Line 1260: FND_MESSAGE.set_token('ROUTINE', 'Validate Values');

1256:
1257: if(fstruct.isa_key_flexfield) then
1258: if(segcount <= 0) then
1259: FND_MESSAGE.set_name('FND', 'FLEX-CANT FIND SEGMENTS');
1260: FND_MESSAGE.set_token('ROUTINE', 'Validate Values');
1261: FND_MESSAGE.set_token('APPID', to_char(fstruct.application_id));
1262: FND_MESSAGE.set_token('CODE', fstruct.id_flex_code);
1263: FND_MESSAGE.set_token('NUM', to_char(fstruct.id_flex_num));
1264: return_code := VV_ERROR;

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

1257: if(fstruct.isa_key_flexfield) then
1258: if(segcount <= 0) then
1259: FND_MESSAGE.set_name('FND', 'FLEX-CANT FIND SEGMENTS');
1260: FND_MESSAGE.set_token('ROUTINE', 'Validate Values');
1261: FND_MESSAGE.set_token('APPID', to_char(fstruct.application_id));
1262: FND_MESSAGE.set_token('CODE', fstruct.id_flex_code);
1263: FND_MESSAGE.set_token('NUM', to_char(fstruct.id_flex_num));
1264: return_code := VV_ERROR;
1265: goto return_values;

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

1258: if(segcount <= 0) then
1259: FND_MESSAGE.set_name('FND', 'FLEX-CANT FIND SEGMENTS');
1260: FND_MESSAGE.set_token('ROUTINE', 'Validate Values');
1261: FND_MESSAGE.set_token('APPID', to_char(fstruct.application_id));
1262: FND_MESSAGE.set_token('CODE', fstruct.id_flex_code);
1263: FND_MESSAGE.set_token('NUM', to_char(fstruct.id_flex_num));
1264: return_code := VV_ERROR;
1265: goto return_values;
1266: end if;

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

1259: FND_MESSAGE.set_name('FND', 'FLEX-CANT FIND SEGMENTS');
1260: FND_MESSAGE.set_token('ROUTINE', 'Validate Values');
1261: FND_MESSAGE.set_token('APPID', to_char(fstruct.application_id));
1262: FND_MESSAGE.set_token('CODE', fstruct.id_flex_code);
1263: FND_MESSAGE.set_token('NUM', to_char(fstruct.id_flex_num));
1264: return_code := VV_ERROR;
1265: goto return_values;
1266: end if;
1267: ELSE

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

1275: -- Do not complain if dispsegcount is 1 in that case.
1276: --
1277: if(vflags.exact_nsegs_required and (dispsegcount <> nsegs_in) and
1278: not ((nsegs_in = 0) and (dispsegcount = 1))) then
1279: FND_MESSAGE.set_name('FND', 'FLEX-TOO MANY SEGS');
1280: FND_MESSAGE.set_token('NSEGS', to_char(dispsegcount));
1281: return_code := VV_ERROR;
1282: goto return_values;
1283: end if;

Line 1280: FND_MESSAGE.set_token('NSEGS', to_char(dispsegcount));

1276: --
1277: if(vflags.exact_nsegs_required and (dispsegcount <> nsegs_in) and
1278: not ((nsegs_in = 0) and (dispsegcount = 1))) then
1279: FND_MESSAGE.set_name('FND', 'FLEX-TOO MANY SEGS');
1280: FND_MESSAGE.set_token('NSEGS', to_char(dispsegcount));
1281: return_code := VV_ERROR;
1282: goto return_values;
1283: end if;
1284:

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

1324: IF (fnd_flex_server1.g_debug_level > 0) THEN
1325: FND_FLEX_SERVER1.add_debug('EXCEPTION no_data_found SV1.validate_struct() ');
1326: END IF;
1327: if(fstruct.isa_key_flexfield) then
1328: FND_MESSAGE.set_name('FND', 'FLEX-CANT FIND SEGMENTS');
1329: FND_MESSAGE.set_token('ROUTINE', 'Validate Values');
1330: FND_MESSAGE.set_token('APPID', to_char(fstruct.application_id));
1331: FND_MESSAGE.set_token('CODE', fstruct.id_flex_code);
1332: FND_MESSAGE.set_token('NUM', to_char(fstruct.id_flex_num));

Line 1329: FND_MESSAGE.set_token('ROUTINE', 'Validate Values');

1325: FND_FLEX_SERVER1.add_debug('EXCEPTION no_data_found SV1.validate_struct() ');
1326: END IF;
1327: if(fstruct.isa_key_flexfield) then
1328: FND_MESSAGE.set_name('FND', 'FLEX-CANT FIND SEGMENTS');
1329: FND_MESSAGE.set_token('ROUTINE', 'Validate Values');
1330: FND_MESSAGE.set_token('APPID', to_char(fstruct.application_id));
1331: FND_MESSAGE.set_token('CODE', fstruct.id_flex_code);
1332: FND_MESSAGE.set_token('NUM', to_char(fstruct.id_flex_num));
1333: return(VV_ERROR);

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

1326: END IF;
1327: if(fstruct.isa_key_flexfield) then
1328: FND_MESSAGE.set_name('FND', 'FLEX-CANT FIND SEGMENTS');
1329: FND_MESSAGE.set_token('ROUTINE', 'Validate Values');
1330: FND_MESSAGE.set_token('APPID', to_char(fstruct.application_id));
1331: FND_MESSAGE.set_token('CODE', fstruct.id_flex_code);
1332: FND_MESSAGE.set_token('NUM', to_char(fstruct.id_flex_num));
1333: return(VV_ERROR);
1334: end if;

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

1327: if(fstruct.isa_key_flexfield) then
1328: FND_MESSAGE.set_name('FND', 'FLEX-CANT FIND SEGMENTS');
1329: FND_MESSAGE.set_token('ROUTINE', 'Validate Values');
1330: FND_MESSAGE.set_token('APPID', to_char(fstruct.application_id));
1331: FND_MESSAGE.set_token('CODE', fstruct.id_flex_code);
1332: FND_MESSAGE.set_token('NUM', to_char(fstruct.id_flex_num));
1333: return(VV_ERROR);
1334: end if;
1335: return(VV_VALID);

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

1328: FND_MESSAGE.set_name('FND', 'FLEX-CANT FIND SEGMENTS');
1329: FND_MESSAGE.set_token('ROUTINE', 'Validate Values');
1330: FND_MESSAGE.set_token('APPID', to_char(fstruct.application_id));
1331: FND_MESSAGE.set_token('CODE', fstruct.id_flex_code);
1332: FND_MESSAGE.set_token('NUM', to_char(fstruct.id_flex_num));
1333: return(VV_ERROR);
1334: end if;
1335: return(VV_VALID);
1336: WHEN OTHERS then

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

1333: return(VV_ERROR);
1334: end if;
1335: return(VV_VALID);
1336: WHEN OTHERS then
1337: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
1338: FND_MESSAGE.set_token('MSG', 'validate_struct() exception: '||SQLERRM);
1339: IF (fnd_flex_server1.g_debug_level > 0) THEN
1340: FND_FLEX_SERVER1.add_debug('EXCEPTION others SV1.validate_struct() ');
1341: END IF;

Line 1338: FND_MESSAGE.set_token('MSG', 'validate_struct() exception: '||SQLERRM);

1334: end if;
1335: return(VV_VALID);
1336: WHEN OTHERS then
1337: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
1338: FND_MESSAGE.set_token('MSG', 'validate_struct() exception: '||SQLERRM);
1339: IF (fnd_flex_server1.g_debug_level > 0) THEN
1340: FND_FLEX_SERVER1.add_debug('EXCEPTION others SV1.validate_struct() ');
1341: END IF;
1342:

Line 1641: FND_MESSAGE.set_name('FND', 'FLEX-NO PARENT SEGMENT');

1637: goto return_val;
1638: end if;
1639:
1640: IF (l_parent_index = 0) then
1641: FND_MESSAGE.set_name('FND', 'FLEX-NO PARENT SEGMENT');
1642: FND_MESSAGE.set_token('CHILD', kseg.segname);
1643: vcode := FF_VERROR;
1644: goto return_val;
1645: end if;

Line 1642: FND_MESSAGE.set_token('CHILD', kseg.segname);

1638: end if;
1639:
1640: IF (l_parent_index = 0) then
1641: FND_MESSAGE.set_name('FND', 'FLEX-NO PARENT SEGMENT');
1642: FND_MESSAGE.set_token('CHILD', kseg.segname);
1643: vcode := FF_VERROR;
1644: goto return_val;
1645: end if;
1646:

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

1785: return(vcode);
1786:
1787: EXCEPTION
1788: WHEN OTHERS then
1789: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
1790: FND_MESSAGE.set_token('MSG', 'validate_seg() exception: ' || SQLERRM);
1791: IF (fnd_flex_server1.g_debug_level > 0) THEN
1792: FND_FLEX_SERVER1.add_debug('EXCEPTION others SV1.validate_seg() ');
1793: END IF;

Line 1790: FND_MESSAGE.set_token('MSG', 'validate_seg() exception: ' || SQLERRM);

1786:
1787: EXCEPTION
1788: WHEN OTHERS then
1789: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
1790: FND_MESSAGE.set_token('MSG', 'validate_seg() exception: ' || SQLERRM);
1791: IF (fnd_flex_server1.g_debug_level > 0) THEN
1792: FND_FLEX_SERVER1.add_debug('EXCEPTION others SV1.validate_seg() ');
1793: END IF;
1794: return(FF_VERROR);

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

1866: return(TRUE);
1867:
1868: EXCEPTION
1869: WHEN OTHERS then
1870: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
1871: FND_MESSAGE.set_token('MSG', 'derive_values() exception: ' || SQLERRM);
1872: return(FALSE);
1873:
1874: END derive_values;

Line 1871: FND_MESSAGE.set_token('MSG', 'derive_values() exception: ' || SQLERRM);

1867:
1868: EXCEPTION
1869: WHEN OTHERS then
1870: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
1871: FND_MESSAGE.set_token('MSG', 'derive_values() exception: ' || SQLERRM);
1872: return(FALSE);
1873:
1874: END derive_values;
1875:

Line 1916: -- fnd_message, we will do a stacking trick here.

1912: x_display_value := user_value;
1913:
1914: --
1915: -- Since validation utility is setting messages by using
1916: -- fnd_message, we will do a stacking trick here.
1917: --
1918: -- For different result, different style of messaging is used.
1919: -- If the error is serious, always overwrite the existing message.
1920: --

Line 1922: l_ssv_enc_message := fnd_message.get_encoded;

1918: -- For different result, different style of messaging is used.
1919: -- If the error is serious, always overwrite the existing message.
1920: --
1921: IF (value_error_set) THEN
1922: l_ssv_enc_message := fnd_message.get_encoded;
1923: END IF;
1924:
1925: fnd_flex_val_util.validate_value_ssv
1926: (p_value => user_value,

Line 1952: fnd_message.set_encoded(l_ssv_enc_message);

1948: l_return := FF_VVALID;
1949: x_storage_value := l_storage_value;
1950: x_display_value := l_display_value;
1951: IF (value_error_set) THEN
1952: fnd_message.set_encoded(l_ssv_enc_message);
1953: END IF;
1954: ELSE
1955: --
1956: -- Since this is an error case, get the message.

Line 1958: l_utv_enc_message := fnd_message.get_encoded;

1954: ELSE
1955: --
1956: -- Since this is an error case, get the message.
1957: --
1958: l_utv_enc_message := fnd_message.get_encoded;
1959:
1960: IF ((l_success = fnd_flex_val_util.g_ret_value_too_long) OR
1961: (l_success = fnd_flex_val_util.g_ret_invalid_number) OR
1962: (l_success = fnd_flex_val_util.g_ret_invalid_date)) THEN

Line 1968: fnd_message.set_encoded(l_ssv_enc_message);

1964: -- Format Errors.
1965: --
1966: l_return := FF_VFORMAT;
1967: IF (value_error_set) THEN
1968: fnd_message.set_encoded(l_ssv_enc_message);
1969: ELSE
1970: fnd_message.set_encoded(l_utv_enc_message);
1971: END IF;
1972: ELSIF ((l_success = fnd_flex_val_util.g_ret_vs_bad_precision) OR

Line 1970: fnd_message.set_encoded(l_utv_enc_message);

1966: l_return := FF_VFORMAT;
1967: IF (value_error_set) THEN
1968: fnd_message.set_encoded(l_ssv_enc_message);
1969: ELSE
1970: fnd_message.set_encoded(l_utv_enc_message);
1971: END IF;
1972: ELSIF ((l_success = fnd_flex_val_util.g_ret_vs_bad_precision) OR
1973: (l_success = fnd_flex_val_util.g_ret_vs_bad_format) OR
1974: (l_success = fnd_flex_val_util.g_ret_vs_bad_numrange) OR

Line 1982: fnd_message.set_encoded(l_utv_enc_message);

1978: --
1979: -- Serious errors.
1980: --
1981: l_return := FF_VERROR;
1982: fnd_message.set_encoded(l_utv_enc_message);
1983:
1984: ELSIF (l_success = fnd_flex_val_util.g_ret_val_out_of_range) THEN
1985: --
1986: -- Bound Check Error.

Line 1990: fnd_message.set_encoded(l_ssv_enc_message);

1986: -- Bound Check Error.
1987: --
1988: l_return := FF_VBOUNDS;
1989: IF (value_error_set) THEN
1990: fnd_message.set_encoded(l_ssv_enc_message);
1991: ELSE
1992: fnd_message.set_encoded(l_utv_enc_message);
1993: END IF;
1994: ELSE

Line 1992: fnd_message.set_encoded(l_utv_enc_message);

1988: l_return := FF_VBOUNDS;
1989: IF (value_error_set) THEN
1990: fnd_message.set_encoded(l_ssv_enc_message);
1991: ELSE
1992: fnd_message.set_encoded(l_utv_enc_message);
1993: END IF;
1994: ELSE
1995: --
1996: -- Other errors. This part is added, in case there will be changes

Line 2000: fnd_message.set_encoded(l_utv_enc_message);

1996: -- Other errors. This part is added, in case there will be changes
1997: -- in UTV package. As of 26-APR-99 code should not enter here.
1998: --
1999: l_return := FF_VERROR;
2000: fnd_message.set_encoded(l_utv_enc_message);
2001: END IF;
2002: --
2003: -- We are in error case, set messaging globals.
2004: --

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

2017: IF (fnd_flex_server1.g_debug_level > 0) THEN
2018: FND_FLEX_SERVER1.add_debug('EXCEPTION SV1.coerce_format() ');
2019: END IF;
2020:
2021: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
2022: FND_MESSAGE.set_token('MSG', 'coerce_format() exception: ' || SQLERRM);
2023: return(FF_VERROR);
2024: END coerce_format;
2025:

Line 2022: FND_MESSAGE.set_token('MSG', 'coerce_format() exception: ' || SQLERRM);

2018: FND_FLEX_SERVER1.add_debug('EXCEPTION SV1.coerce_format() ');
2019: END IF;
2020:
2021: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
2022: FND_MESSAGE.set_token('MSG', 'coerce_format() exception: ' || SQLERRM);
2023: return(FF_VERROR);
2024: END coerce_format;
2025:
2026: /* ----------------------------------------------------------------------- */

Line 2384: FND_MESSAGE.set_name('FND', 'FLEX-SSV UNSUPPORTED VDATION');

2380:
2381: -- Pair or Special validation unsupported.
2382: --
2383: ELSIF (p_vs_info.valtype in ('P', 'U')) then
2384: FND_MESSAGE.set_name('FND', 'FLEX-SSV UNSUPPORTED VDATION');
2385: FND_MESSAGE.set_token('VSNAME', p_vs_info.vsname);
2386: v_code := FF_VUNKNOWN;
2387:
2388: -- Undefined validation type

Line 2385: FND_MESSAGE.set_token('VSNAME', p_vs_info.vsname);

2381: -- Pair or Special validation unsupported.
2382: --
2383: ELSIF (p_vs_info.valtype in ('P', 'U')) then
2384: FND_MESSAGE.set_name('FND', 'FLEX-SSV UNSUPPORTED VDATION');
2385: FND_MESSAGE.set_token('VSNAME', p_vs_info.vsname);
2386: v_code := FF_VUNKNOWN;
2387:
2388: -- Undefined validation type
2389: --

Line 2391: FND_MESSAGE.set_name('FND', 'FLEX-VS BAD VDATION TYPE');

2387:
2388: -- Undefined validation type
2389: --
2390: else
2391: FND_MESSAGE.set_name('FND', 'FLEX-VS BAD VDATION TYPE');
2392: FND_MESSAGE.set_token('VSNAME', p_vs_info.vsname);
2393: FND_MESSAGE.set_token('VTYPE', p_vs_info.valtype);
2394: v_code := FF_VERROR;
2395: end if;

Line 2392: FND_MESSAGE.set_token('VSNAME', p_vs_info.vsname);

2388: -- Undefined validation type
2389: --
2390: else
2391: FND_MESSAGE.set_name('FND', 'FLEX-VS BAD VDATION TYPE');
2392: FND_MESSAGE.set_token('VSNAME', p_vs_info.vsname);
2393: FND_MESSAGE.set_token('VTYPE', p_vs_info.valtype);
2394: v_code := FF_VERROR;
2395: end if;
2396:

Line 2393: FND_MESSAGE.set_token('VTYPE', p_vs_info.valtype);

2389: --
2390: else
2391: FND_MESSAGE.set_name('FND', 'FLEX-VS BAD VDATION TYPE');
2392: FND_MESSAGE.set_token('VSNAME', p_vs_info.vsname);
2393: FND_MESSAGE.set_token('VTYPE', p_vs_info.valtype);
2394: v_code := FF_VERROR;
2395: end if;
2396:
2397: <>

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

2409:
2410: return(v_code);
2411: EXCEPTION
2412: WHEN OTHERS then
2413: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
2414: FND_MESSAGE.set_token('MSG', 'find_value() exception: ' || SQLERRM);
2415: IF (fnd_flex_server1.g_debug_level > 0) THEN
2416: FND_FLEX_SERVER1.add_debug('EXCEPTION others SV1.find_value()');
2417: END IF;

Line 2414: FND_MESSAGE.set_token('MSG', 'find_value() exception: ' || SQLERRM);

2410: return(v_code);
2411: EXCEPTION
2412: WHEN OTHERS then
2413: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
2414: FND_MESSAGE.set_token('MSG', 'find_value() exception: ' || SQLERRM);
2415: IF (fnd_flex_server1.g_debug_level > 0) THEN
2416: FND_FLEX_SERVER1.add_debug('EXCEPTION others SV1.find_value()');
2417: END IF;
2418:

Line 2500: FND_MESSAGE.set_name('FND', 'FLEX-SSV MISSING TBLVS');

2496: open TBL_cursor(p_vs_info.vsid);
2497: FETCH tbl_cursor INTO l_tbl_rec;
2498: IF (TBL_cursor%NOTFOUND) THEN
2499: close TBL_cursor;
2500: FND_MESSAGE.set_name('FND', 'FLEX-SSV MISSING TBLVS');
2501: FND_MESSAGE.set_token('VSNAME', p_vs_info.vsname);
2502: return(FF_VERROR);
2503: end if;
2504: close TBL_cursor;

Line 2501: FND_MESSAGE.set_token('VSNAME', p_vs_info.vsname);

2497: FETCH tbl_cursor INTO l_tbl_rec;
2498: IF (TBL_cursor%NOTFOUND) THEN
2499: close TBL_cursor;
2500: FND_MESSAGE.set_name('FND', 'FLEX-SSV MISSING TBLVS');
2501: FND_MESSAGE.set_token('VSNAME', p_vs_info.vsname);
2502: return(FF_VERROR);
2503: end if;
2504: close TBL_cursor;
2505: END IF;

Line 2516: FND_MESSAGE.set_name('FND', 'FLEX-SSV NO TBL VS');

2512:
2513: -- Return error if unsupported validation.
2514: --
2515: if((l_tbl_rec.additional_quickpick_columns is not null) and (INSTR(UPPER(l_tbl_rec.additional_quickpick_columns),'INTO') > 0)) then
2516: FND_MESSAGE.set_name('FND', 'FLEX-SSV NO TBL VS');
2517: FND_MESSAGE.set_token('VSNAME', p_vs_info.vsname);
2518: return(FF_VUNKNOWN);
2519: end if;
2520:

Line 2517: FND_MESSAGE.set_token('VSNAME', p_vs_info.vsname);

2513: -- Return error if unsupported validation.
2514: --
2515: if((l_tbl_rec.additional_quickpick_columns is not null) and (INSTR(UPPER(l_tbl_rec.additional_quickpick_columns),'INTO') > 0)) then
2516: FND_MESSAGE.set_name('FND', 'FLEX-SSV NO TBL VS');
2517: FND_MESSAGE.set_token('VSNAME', p_vs_info.vsname);
2518: return(FF_VUNKNOWN);
2519: end if;
2520:
2521: -- Default column names if null

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

2696: return(FF_VERROR);
2697:
2698: EXCEPTION
2699: WHEN OTHERS then
2700: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
2701: FND_MESSAGE.set_token('MSG', 'table_validate() exception: ' || SQLERRM);
2702: return(FF_VERROR);
2703:
2704: END table_validate;

Line 2701: FND_MESSAGE.set_token('MSG', 'table_validate() exception: ' || SQLERRM);

2697:
2698: EXCEPTION
2699: WHEN OTHERS then
2700: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
2701: FND_MESSAGE.set_token('MSG', 'table_validate() exception: ' || SQLERRM);
2702: return(FF_VERROR);
2703:
2704: END table_validate;
2705:

Line 2815: FND_MESSAGE.set_name('FND', 'FLEX-DFLT MULTIPLE SQL ROWS');

2811: END LOOP;
2812:
2813: nfound := x_dsql_select_one(stored_val);
2814: IF (nfound > 1) then
2815: FND_MESSAGE.set_name('FND', 'FLEX-DFLT MULTIPLE SQL ROWS');
2816: FND_MESSAGE.set_token('SQLSTR', SUBSTRB(fnd_dsql.get_text(FALSE), 1, 1000));
2817: v_code := FF_VERROR;
2818: ELSIF (nfound < 0) then
2819: v_code := FF_VERROR;

Line 2816: FND_MESSAGE.set_token('SQLSTR', SUBSTRB(fnd_dsql.get_text(FALSE), 1, 1000));

2812:
2813: nfound := x_dsql_select_one(stored_val);
2814: IF (nfound > 1) then
2815: FND_MESSAGE.set_name('FND', 'FLEX-DFLT MULTIPLE SQL ROWS');
2816: FND_MESSAGE.set_token('SQLSTR', SUBSTRB(fnd_dsql.get_text(FALSE), 1, 1000));
2817: v_code := FF_VERROR;
2818: ELSIF (nfound < 0) then
2819: v_code := FF_VERROR;
2820: else

Line 2827: FND_MESSAGE.set_name('FND', 'FLEX-SSV UNSUPPORTED DEFAULT');

2823: end if;
2824:
2825: ELSIF (def_type = 'F') then
2826: -- 'F' => :block.field (the colon may or may not be in the def_text string)
2827: FND_MESSAGE.set_name('FND', 'FLEX-SSV UNSUPPORTED DEFAULT');
2828: v_code := FF_VUNKNOWN;
2829:
2830: ELSIF (def_type = 'E') then
2831: -- Environment variable

Line 2832: FND_MESSAGE.set_name('FND', 'FLEX-SSV UNSUPPORTED DEFAULT');

2828: v_code := FF_VUNKNOWN;
2829:
2830: ELSIF (def_type = 'E') then
2831: -- Environment variable
2832: FND_MESSAGE.set_name('FND', 'FLEX-SSV UNSUPPORTED DEFAULT');
2833: v_code := FF_VUNKNOWN;
2834:
2835: ELSE
2836: -- Unknown type.

Line 2837: FND_MESSAGE.set_name('FND', 'FLEX-INVALID DEFAULT TYPE');

2833: v_code := FF_VUNKNOWN;
2834:
2835: ELSE
2836: -- Unknown type.
2837: FND_MESSAGE.set_name('FND', 'FLEX-INVALID DEFAULT TYPE');
2838: FND_MESSAGE.set_token('SEGNAME', seg_name);
2839: v_code := FF_VERROR;
2840:
2841: END IF;

Line 2838: FND_MESSAGE.set_token('SEGNAME', seg_name);

2834:
2835: ELSE
2836: -- Unknown type.
2837: FND_MESSAGE.set_name('FND', 'FLEX-INVALID DEFAULT TYPE');
2838: FND_MESSAGE.set_token('SEGNAME', seg_name);
2839: v_code := FF_VERROR;
2840:
2841: END IF;
2842:

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

2847: end if;
2848: return(v_code);
2849: EXCEPTION
2850: WHEN OTHERS then
2851: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
2852: FND_MESSAGE.set_token('MSG', 'default_val() exception: ' || SQLERRM);
2853: return(FF_VERROR);
2854: END default_val;
2855:

Line 2852: FND_MESSAGE.set_token('MSG', 'default_val() exception: ' || SQLERRM);

2848: return(v_code);
2849: EXCEPTION
2850: WHEN OTHERS then
2851: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
2852: FND_MESSAGE.set_token('MSG', 'default_val() exception: ' || SQLERRM);
2853: return(FF_VERROR);
2854: END default_val;
2855:
2856: /* ------------------------------------------------------------------------- */

Line 2878: FND_MESSAGE.set_name('FND', 'FLEX-NO FLEX IN WHERE TOKEN');

2874: BEGIN
2875:
2876: if(clause_in is not null) then
2877: if(INSTR(clause_in, ':$FLEX$') > 0) then
2878: FND_MESSAGE.set_name('FND', 'FLEX-NO FLEX IN WHERE TOKEN');
2879: return(VV_ERROR);
2880: end if;
2881: vcode := substitute_flex_binds3(clause_in, 0,
2882: dummy_dispvls, dummy_vals,

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

2909: return(VV_VALID);
2910:
2911: EXCEPTION
2912: WHEN OTHERS then
2913: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
2914: FND_MESSAGE.set_token('MSG', 'parse_where_token() exception: '||SQLERRM);
2915: return(VV_ERROR);
2916:
2917: END parse_where_token;

Line 2914: FND_MESSAGE.set_token('MSG', 'parse_where_token() exception: '||SQLERRM);

2910:
2911: EXCEPTION
2912: WHEN OTHERS then
2913: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
2914: FND_MESSAGE.set_token('MSG', 'parse_where_token() exception: '||SQLERRM);
2915: return(VV_ERROR);
2916:
2917: END parse_where_token;
2918:

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

2982: WHEN OTHERS then
2983: IF (fnd_flex_server1.g_debug_level > 0) THEN
2984: add_debug('EXCEPTION SV1.substitute_flex_binds3()');
2985: END IF;
2986: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
2987: FND_MESSAGE.set_token('MSG', 'substitute_flex_binds3() exception: '
2988: || SQLERRM);
2989: return(FF_VERROR);
2990: END substitute_flex_binds3;

Line 2987: FND_MESSAGE.set_token('MSG', 'substitute_flex_binds3() exception: '

2983: IF (fnd_flex_server1.g_debug_level > 0) THEN
2984: add_debug('EXCEPTION SV1.substitute_flex_binds3()');
2985: END IF;
2986: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
2987: FND_MESSAGE.set_token('MSG', 'substitute_flex_binds3() exception: '
2988: || SQLERRM);
2989: return(FF_VERROR);
2990: END substitute_flex_binds3;
2991:

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

3047: WHEN OTHERS then
3048: IF (fnd_flex_server1.g_debug_level > 0) THEN
3049: add_debug('EXCEPTION SV1.substitute_flex_binds5()');
3050: END IF;
3051: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
3052: FND_MESSAGE.set_token('MSG', 'substitute_flex_binds5() exception: '
3053: || SQLERRM);
3054: return(FF_VERROR);
3055: END substitute_flex_binds5;

Line 3052: FND_MESSAGE.set_token('MSG', 'substitute_flex_binds5() exception: '

3048: IF (fnd_flex_server1.g_debug_level > 0) THEN
3049: add_debug('EXCEPTION SV1.substitute_flex_binds5()');
3050: END IF;
3051: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
3052: FND_MESSAGE.set_token('MSG', 'substitute_flex_binds5() exception: '
3053: || SQLERRM);
3054: return(FF_VERROR);
3055: END substitute_flex_binds5;
3056:

Line 3133: FND_MESSAGE.set_name('FND','FLEX-INVALID PORTION');

3129: end if;
3130: end if;
3131:
3132: if (dot_pointer > col_pointer) then
3133: FND_MESSAGE.set_name('FND','FLEX-INVALID PORTION');
3134: FND_MESSAGE.set_token('BTOKEN',bind_token);
3135: l_return_code := FF_VERROR;
3136: GOTO goto_return;
3137: end if;

Line 3134: FND_MESSAGE.set_token('BTOKEN',bind_token);

3130: end if;
3131:
3132: if (dot_pointer > col_pointer) then
3133: FND_MESSAGE.set_name('FND','FLEX-INVALID PORTION');
3134: FND_MESSAGE.set_token('BTOKEN',bind_token);
3135: l_return_code := FF_VERROR;
3136: GOTO goto_return;
3137: end if;
3138:

Line 3167: FND_MESSAGE.set_name('FND', 'FLEX-INVALID PORTION');

3163: bind_val := prev_ids(s_index);
3164: elsif(seg_portion = 'MEANING') then
3165: bind_val := prev_descs(s_index);
3166: else
3167: FND_MESSAGE.set_name('FND', 'FLEX-INVALID PORTION');
3168: FND_MESSAGE.set_token('BTOKEN', bind_token);
3169: l_return_code := FF_VERROR;
3170: GOTO goto_return;
3171: end if;

Line 3168: FND_MESSAGE.set_token('BTOKEN', bind_token);

3164: elsif(seg_portion = 'MEANING') then
3165: bind_val := prev_descs(s_index);
3166: else
3167: FND_MESSAGE.set_name('FND', 'FLEX-INVALID PORTION');
3168: FND_MESSAGE.set_token('BTOKEN', bind_token);
3169: l_return_code := FF_VERROR;
3170: GOTO goto_return;
3171: end if;
3172: else

Line 3173: FND_MESSAGE.set_name('FND', 'FLEX-PRIOR SEG NOTFOUND');

3169: l_return_code := FF_VERROR;
3170: GOTO goto_return;
3171: end if;
3172: else
3173: FND_MESSAGE.set_name('FND', 'FLEX-PRIOR SEG NOTFOUND');
3174: FND_MESSAGE.set_token('BTOKEN', bind_token);
3175: l_return_code := FF_VERROR;
3176: GOTO goto_return;
3177: end if;

Line 3174: FND_MESSAGE.set_token('BTOKEN', bind_token);

3170: GOTO goto_return;
3171: end if;
3172: else
3173: FND_MESSAGE.set_name('FND', 'FLEX-PRIOR SEG NOTFOUND');
3174: FND_MESSAGE.set_token('BTOKEN', bind_token);
3175: l_return_code := FF_VERROR;
3176: GOTO goto_return;
3177: end if;
3178:

Line 3183: FND_MESSAGE.set_name('FND', 'FLEX-UNSUPPORTED FLEX BIND');

3179: else
3180:
3181: -- :BLOCK.FIELD cannot be handled here
3182: --
3183: FND_MESSAGE.set_name('FND', 'FLEX-UNSUPPORTED FLEX BIND');
3184: l_return_code := FF_VUNKNOWN;
3185: GOTO goto_return;
3186:
3187: end if;

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

3198: WHEN OTHERS then
3199: IF (fnd_flex_server1.g_debug_level > 0) THEN
3200: add_debug('EXCEPTION others SV1.convert_bind_token()');
3201: END IF;
3202: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
3203: FND_MESSAGE.set_token('MSG','convert_bind_token() exception: '||SQLERRM);
3204: return(FF_VERROR);
3205: END convert_bind_token;
3206:

Line 3203: FND_MESSAGE.set_token('MSG','convert_bind_token() exception: '||SQLERRM);

3199: IF (fnd_flex_server1.g_debug_level > 0) THEN
3200: add_debug('EXCEPTION others SV1.convert_bind_token()');
3201: END IF;
3202: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
3203: FND_MESSAGE.set_token('MSG','convert_bind_token() exception: '||SQLERRM);
3204: return(FF_VERROR);
3205: END convert_bind_token;
3206:
3207: --

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

3281: WHEN OTHERS then
3282: IF (fnd_flex_server1.g_debug_level > 0) THEN
3283: add_debug('EXCEPTION others SV1.convert_bind_token2()');
3284: END IF;
3285: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
3286: FND_MESSAGE.set_token('MSG','convert_bind_token2() exception: '||SQLERRM);
3287: return(FF_VERROR);
3288: END convert_bind_token2;
3289:

Line 3286: FND_MESSAGE.set_token('MSG','convert_bind_token2() exception: '||SQLERRM);

3282: IF (fnd_flex_server1.g_debug_level > 0) THEN
3283: add_debug('EXCEPTION others SV1.convert_bind_token2()');
3284: END IF;
3285: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
3286: FND_MESSAGE.set_token('MSG','convert_bind_token2() exception: '||SQLERRM);
3287: return(FF_VERROR);
3288: END convert_bind_token2;
3289:
3290: /* ----------------------------------------------------------------------- */

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

3341: return(FF_VVALID);
3342:
3343: EXCEPTION
3344: WHEN OTHERS then
3345: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
3346: FND_MESSAGE.set_token('MSG', 'check_vrules() exception: ' || SQLERRM);
3347: return(FF_VERROR);
3348:
3349: END check_vrules;

Line 3346: FND_MESSAGE.set_token('MSG', 'check_vrules() exception: ' || SQLERRM);

3342:
3343: EXCEPTION
3344: WHEN OTHERS then
3345: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
3346: FND_MESSAGE.set_token('MSG', 'check_vrules() exception: ' || SQLERRM);
3347: return(FF_VERROR);
3348:
3349: END check_vrules;
3350:

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

3389: return(retcode);
3390:
3391: EXCEPTION
3392: WHEN OTHERS then
3393: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
3394: FND_MESSAGE.set_token('MSG','check_comb_vrules() exception: '||SQLERRM);
3395: return(VV_ERROR);
3396:
3397: END check_comb_vrules;

Line 3394: FND_MESSAGE.set_token('MSG','check_comb_vrules() exception: '||SQLERRM);

3390:
3391: EXCEPTION
3392: WHEN OTHERS then
3393: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
3394: FND_MESSAGE.set_token('MSG','check_comb_vrules() exception: '||SQLERRM);
3395: return(VV_ERROR);
3396:
3397: END check_comb_vrules;
3398:

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

3485: END IF;
3486: RETURN(l_return_code);
3487: EXCEPTION
3488: WHEN OTHERS then
3489: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
3490: FND_MESSAGE.set_token('MSG','check_security() exception: ' || SQLERRM);
3491: IF (fnd_flex_server1.g_debug_level > 0) THEN
3492: add_debug('EXCEPTION SV1.check_security()');
3493: END IF;

Line 3490: FND_MESSAGE.set_token('MSG','check_security() exception: ' || SQLERRM);

3486: RETURN(l_return_code);
3487: EXCEPTION
3488: WHEN OTHERS then
3489: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
3490: FND_MESSAGE.set_token('MSG','check_security() exception: ' || SQLERRM);
3491: IF (fnd_flex_server1.g_debug_level > 0) THEN
3492: add_debug('EXCEPTION SV1.check_security()');
3493: END IF;
3494:

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

3512: return(TRUE);
3513:
3514: EXCEPTION
3515: WHEN OTHERS then
3516: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
3517: FND_MESSAGE.set_token('MSG','check_displayed() exception: ' ||SQLERRM);
3518: return(FALSE);
3519:
3520: END check_displayed;

Line 3517: FND_MESSAGE.set_token('MSG','check_displayed() exception: ' ||SQLERRM);

3513:
3514: EXCEPTION
3515: WHEN OTHERS then
3516: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
3517: FND_MESSAGE.set_token('MSG','check_displayed() exception: ' ||SQLERRM);
3518: return(FALSE);
3519:
3520: END check_displayed;
3521:

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

3646: return(cva_index);
3647:
3648: EXCEPTION
3649: WHEN OTHERS then
3650: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
3651: FND_MESSAGE.set_token('MSG', 'qualifier_values() exception: '||SQLERRM);
3652: return(-1);
3653:
3654: END qualifier_values;

Line 3651: FND_MESSAGE.set_token('MSG', 'qualifier_values() exception: '||SQLERRM);

3647:
3648: EXCEPTION
3649: WHEN OTHERS then
3650: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
3651: FND_MESSAGE.set_token('MSG', 'qualifier_values() exception: '||SQLERRM);
3652: return(-1);
3653:
3654: END qualifier_values;
3655:

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

3744:
3745: RETURN(sqcount);
3746: EXCEPTION
3747: WHEN OTHERS then
3748: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
3749: FND_MESSAGE.set_token('MSG', 'get_qualifiers() exception: ' || SQLERRM);
3750: IF (fnd_flex_server1.g_debug_level > 0) THEN
3751: fnd_flex_server1.add_debug('EXCEPTION SV1.get_qualifiers()');
3752: END IF;

Line 3749: FND_MESSAGE.set_token('MSG', 'get_qualifiers() exception: ' || SQLERRM);

3745: RETURN(sqcount);
3746: EXCEPTION
3747: WHEN OTHERS then
3748: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
3749: FND_MESSAGE.set_token('MSG', 'get_qualifiers() exception: ' || SQLERRM);
3750: IF (fnd_flex_server1.g_debug_level > 0) THEN
3751: fnd_flex_server1.add_debug('EXCEPTION SV1.get_qualifiers()');
3752: END IF;
3753:

Line 3830: FND_MESSAGE.set_name('FND', 'FLEX-VALUE SET NOT FOUND');

3826: END IF;
3827: return(TRUE);
3828: EXCEPTION
3829: WHEN NO_DATA_FOUND then
3830: FND_MESSAGE.set_name('FND', 'FLEX-VALUE SET NOT FOUND');
3831: FND_MESSAGE.set_token('SEGMENT', segment_name);
3832: return(FALSE);
3833: WHEN OTHERS then
3834: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');

Line 3831: FND_MESSAGE.set_token('SEGMENT', segment_name);

3827: return(TRUE);
3828: EXCEPTION
3829: WHEN NO_DATA_FOUND then
3830: FND_MESSAGE.set_name('FND', 'FLEX-VALUE SET NOT FOUND');
3831: FND_MESSAGE.set_token('SEGMENT', segment_name);
3832: return(FALSE);
3833: WHEN OTHERS then
3834: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
3835: FND_MESSAGE.set_token('MSG', 'get_value_set() exception: ' || SQLERRM);

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

3830: FND_MESSAGE.set_name('FND', 'FLEX-VALUE SET NOT FOUND');
3831: FND_MESSAGE.set_token('SEGMENT', segment_name);
3832: return(FALSE);
3833: WHEN OTHERS then
3834: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
3835: FND_MESSAGE.set_token('MSG', 'get_value_set() exception: ' || SQLERRM);
3836: return(FALSE);
3837: END get_value_set;
3838:

Line 3835: FND_MESSAGE.set_token('MSG', 'get_value_set() exception: ' || SQLERRM);

3831: FND_MESSAGE.set_token('SEGMENT', segment_name);
3832: return(FALSE);
3833: WHEN OTHERS then
3834: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
3835: FND_MESSAGE.set_token('MSG', 'get_value_set() exception: ' || SQLERRM);
3836: return(FALSE);
3837: END get_value_set;
3838:
3839: /* ----------------------------------------------------------------------- */

Line 3863: FND_MESSAGE.set_name('FND', 'FLEX-VALUE SET REQUIRED');

3859: vs_info.capsonly := 'N';
3860: vs_info.zfill := 'N';
3861: return(TRUE);
3862: end if;
3863: FND_MESSAGE.set_name('FND', 'FLEX-VALUE SET REQUIRED');
3864: FND_MESSAGE.set_token('SEGMENT', segment_name);
3865: return(FALSE);
3866:
3867: EXCEPTION

Line 3864: FND_MESSAGE.set_token('SEGMENT', segment_name);

3860: vs_info.zfill := 'N';
3861: return(TRUE);
3862: end if;
3863: FND_MESSAGE.set_name('FND', 'FLEX-VALUE SET REQUIRED');
3864: FND_MESSAGE.set_token('SEGMENT', segment_name);
3865: return(FALSE);
3866:
3867: EXCEPTION
3868: WHEN OTHERS then

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

3865: return(FALSE);
3866:
3867: EXCEPTION
3868: WHEN OTHERS then
3869: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
3870: FND_MESSAGE.set_token('MSG','virtual_value_set() exception: '||SQLERRM);
3871: return(FALSE);
3872:
3873: END virtual_value_set;

Line 3870: FND_MESSAGE.set_token('MSG','virtual_value_set() exception: '||SQLERRM);

3866:
3867: EXCEPTION
3868: WHEN OTHERS then
3869: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
3870: FND_MESSAGE.set_token('MSG','virtual_value_set() exception: '||SQLERRM);
3871: return(FALSE);
3872:
3873: END virtual_value_set;
3874:

Line 3878: /* error encountered. This handler makes sure that FND_MESSAGE */

3874:
3875: /* ----------------------------------------------------------------------- */
3876: /* Message handler functions for value validation errors. Needed */
3877: /* because value validation does not always stop at the first */
3878: /* error encountered. This handler makes sure that FND_MESSAGE */
3879: /* error is set to the first value error if there are no other */
3880: /* errors. For more serious errors, we set the message directly */
3881: /* using the FND_MESSAGE package. Note this assumes the main */
3882: /* validate_struct() function knows to stop on the first serious */

Line 3881: /* using the FND_MESSAGE package. Note this assumes the main */

3877: /* because value validation does not always stop at the first */
3878: /* error encountered. This handler makes sure that FND_MESSAGE */
3879: /* error is set to the first value error if there are no other */
3880: /* errors. For more serious errors, we set the message directly */
3881: /* using the FND_MESSAGE package. Note this assumes the main */
3882: /* validate_struct() function knows to stop on the first serious */
3883: /* error otherwise we risk overwriting a more serious error with */
3884: /* a value error. */
3885: /* If the application short name is null, then we use the */

Line 3915: FND_MESSAGE.set_name('FND', 'FLEX-USER DEFINED ERROR');

3911: errmsg_name IN VARCHAR2) IS
3912: BEGIN
3913: if(value_error_set = FALSE) then
3914: if(appl_sname is null) then
3915: FND_MESSAGE.set_name('FND', 'FLEX-USER DEFINED ERROR');
3916: FND_MESSAGE.set_token('MSG', errmsg_name);
3917: else
3918: FND_MESSAGE.set_name(appl_sname, errmsg_name);
3919: end if;

Line 3916: FND_MESSAGE.set_token('MSG', errmsg_name);

3912: BEGIN
3913: if(value_error_set = FALSE) then
3914: if(appl_sname is null) then
3915: FND_MESSAGE.set_name('FND', 'FLEX-USER DEFINED ERROR');
3916: FND_MESSAGE.set_token('MSG', errmsg_name);
3917: else
3918: FND_MESSAGE.set_name(appl_sname, errmsg_name);
3919: end if;
3920: value_error_set := TRUE;

Line 3918: FND_MESSAGE.set_name(appl_sname, errmsg_name);

3914: if(appl_sname is null) then
3915: FND_MESSAGE.set_name('FND', 'FLEX-USER DEFINED ERROR');
3916: FND_MESSAGE.set_token('MSG', errmsg_name);
3917: else
3918: FND_MESSAGE.set_name(appl_sname, errmsg_name);
3919: end if;
3920: value_error_set := TRUE;
3921: entering_new_message := TRUE;
3922: else

Line 3941: FND_MESSAGE.set_token(token_name, token_value);

3937: PROCEDURE value_error_token(token_name IN VARCHAR2,
3938: token_value IN VARCHAR2) IS
3939: BEGIN
3940: if(entering_new_message) then
3941: FND_MESSAGE.set_token(token_name, token_value);
3942: end if;
3943: EXCEPTION
3944: WHEN OTHERS then
3945: IF (fnd_flex_server1.g_debug_level > 0) THEN

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

4116: END IF;
4117:
4118: EXCEPTION
4119: WHEN OTHERS then
4120: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
4121: FND_MESSAGE.set_token('MSG',
4122: 'displayed_date_format() exception: ' || SQLERRM);
4123: return(NULL);
4124:

Line 4121: FND_MESSAGE.set_token('MSG',

4117:
4118: EXCEPTION
4119: WHEN OTHERS then
4120: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
4121: FND_MESSAGE.set_token('MSG',
4122: 'displayed_date_format() exception: ' || SQLERRM);
4123: return(NULL);
4124:
4125: END displayed_date_format;

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

4146: END IF;
4147:
4148: EXCEPTION
4149: WHEN OTHERS then
4150: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
4151: FND_MESSAGE.set_token('MSG',
4152: 'stored_date_format() exception: ' || SQLERRM);
4153: return(NULL);
4154:

Line 4151: FND_MESSAGE.set_token('MSG',

4147:
4148: EXCEPTION
4149: WHEN OTHERS then
4150: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
4151: FND_MESSAGE.set_token('MSG',
4152: 'stored_date_format() exception: ' || SQLERRM);
4153: return(NULL);
4154:
4155: END stored_date_format;

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

4170: return(TRUE);
4171:
4172: EXCEPTION
4173: WHEN OTHERS then
4174: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
4175: FND_MESSAGE.set_token('MSG', 'init_globals() exception: ' || SQLERRM);
4176: return(FALSE);
4177:
4178: END init_globals;

Line 4175: FND_MESSAGE.set_token('MSG', 'init_globals() exception: ' || SQLERRM);

4171:
4172: EXCEPTION
4173: WHEN OTHERS then
4174: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
4175: FND_MESSAGE.set_token('MSG', 'init_globals() exception: ' || SQLERRM);
4176: return(FALSE);
4177:
4178: END init_globals;
4179:

Line 4357: -- /* and sets FND_MESSAGE if error. This is called only from trigger */

4353: -- /* ----------------------------------------------------------------------- */
4354: -- /* MADE NULL TO MAKE MORE ROOM FOR USEFUL CODE. */
4355: -- /* Breaks concatenated segments in rule lines table into separate */
4356: -- /* columns for each segment. Returns number of segments or < 0 */
4357: -- /* and sets FND_MESSAGE if error. This is called only from trigger */
4358: -- /* FND_FLEX_VALIDATION_RULE_LINES_T1. The trigger should use */
4359: -- /* FND_MESSAGE.raise_exception if this function returns error. */
4360: -- /* ----------------------------------------------------------------------- */
4361: -- FUNCTION breakup_segs(appid IN NUMBER,

Line 4359: -- /* FND_MESSAGE.raise_exception if this function returns error. */

4355: -- /* Breaks concatenated segments in rule lines table into separate */
4356: -- /* columns for each segment. Returns number of segments or < 0 */
4357: -- /* and sets FND_MESSAGE if error. This is called only from trigger */
4358: -- /* FND_FLEX_VALIDATION_RULE_LINES_T1. The trigger should use */
4359: -- /* FND_MESSAGE.raise_exception if this function returns error. */
4360: -- /* ----------------------------------------------------------------------- */
4361: -- FUNCTION breakup_segs(appid IN NUMBER,
4362: -- flex_code IN VARCHAR2, flex_num IN NUMBER,
4363: -- catsegs IN VARCHAR2, nsegs OUT NUMBER,

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

4385: -- return(-1);
4386: --
4387: -- EXCEPTION
4388: -- WHEN OTHERS then
4389: -- FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
4390: -- FND_MESSAGE.set_token('MSG', 'breakup_segs() exception: ' || SQLERRM);
4391: -- return(-2);
4392: --
4393: -- END breakup_segs;

Line 4390: -- FND_MESSAGE.set_token('MSG', 'breakup_segs() exception: ' || SQLERRM);

4386: --
4387: -- EXCEPTION
4388: -- WHEN OTHERS then
4389: -- FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
4390: -- FND_MESSAGE.set_token('MSG', 'breakup_segs() exception: ' || SQLERRM);
4391: -- return(-2);
4392: --
4393: -- END breakup_segs;
4394:

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

4428: WHEN OTHERS then
4429: if(dbms_sql.is_open(cursornum)) then
4430: dbms_sql.close_cursor(cursornum);
4431: end if;
4432: FND_MESSAGE.set_name('FND', 'FLEX-DSQL EXCEPTION');
4433: FND_MESSAGE.set_token('MSG', SQLERRM);
4434: FND_MESSAGE.set_token('SQLSTR', SUBSTRB(sql_statement, 1, 1000));
4435: return(-1);
4436:

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

4429: if(dbms_sql.is_open(cursornum)) then
4430: dbms_sql.close_cursor(cursornum);
4431: end if;
4432: FND_MESSAGE.set_name('FND', 'FLEX-DSQL EXCEPTION');
4433: FND_MESSAGE.set_token('MSG', SQLERRM);
4434: FND_MESSAGE.set_token('SQLSTR', SUBSTRB(sql_statement, 1, 1000));
4435: return(-1);
4436:
4437: END x_dsql_execute;

Line 4434: FND_MESSAGE.set_token('SQLSTR', SUBSTRB(sql_statement, 1, 1000));

4430: dbms_sql.close_cursor(cursornum);
4431: end if;
4432: FND_MESSAGE.set_name('FND', 'FLEX-DSQL EXCEPTION');
4433: FND_MESSAGE.set_token('MSG', SQLERRM);
4434: FND_MESSAGE.set_token('SQLSTR', SUBSTRB(sql_statement, 1, 1000));
4435: return(-1);
4436:
4437: END x_dsql_execute;
4438:

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

4478: END IF;
4479: else
4480: num_returned := -1;
4481: returned_column := NULL;
4482: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
4483: FND_MESSAGE.set_token('MSG', 'x_dsql_select_one() could not fetch rows');
4484: end if;
4485: dbms_sql.close_cursor(cursornum);
4486: return(num_returned);

Line 4483: FND_MESSAGE.set_token('MSG', 'x_dsql_select_one() could not fetch rows');

4479: else
4480: num_returned := -1;
4481: returned_column := NULL;
4482: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
4483: FND_MESSAGE.set_token('MSG', 'x_dsql_select_one() could not fetch rows');
4484: end if;
4485: dbms_sql.close_cursor(cursornum);
4486: return(num_returned);
4487:

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

4504: WHEN OTHERS then
4505: if(dbms_sql.is_open(cursornum)) then
4506: dbms_sql.close_cursor(cursornum);
4507: end if;
4508: FND_MESSAGE.set_name('FND', 'FLEX-DSQL EXCEPTION');
4509: FND_MESSAGE.set_token('MSG', SQLERRM);
4510: FND_MESSAGE.set_token('SQLSTR', SUBSTRB(sql_statement, 1, 1000));
4511: return(-2);
4512:

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

4505: if(dbms_sql.is_open(cursornum)) then
4506: dbms_sql.close_cursor(cursornum);
4507: end if;
4508: FND_MESSAGE.set_name('FND', 'FLEX-DSQL EXCEPTION');
4509: FND_MESSAGE.set_token('MSG', SQLERRM);
4510: FND_MESSAGE.set_token('SQLSTR', SUBSTRB(sql_statement, 1, 1000));
4511: return(-2);
4512:
4513: END x_dsql_select_one;

Line 4510: FND_MESSAGE.set_token('SQLSTR', SUBSTRB(sql_statement, 1, 1000));

4506: dbms_sql.close_cursor(cursornum);
4507: end if;
4508: FND_MESSAGE.set_name('FND', 'FLEX-DSQL EXCEPTION');
4509: FND_MESSAGE.set_token('MSG', SQLERRM);
4510: FND_MESSAGE.set_token('SQLSTR', SUBSTRB(sql_statement, 1, 1000));
4511: return(-2);
4512:
4513: END x_dsql_select_one;
4514:

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

4562: add_debug(')');
4563: END IF;
4564: else
4565: num_returned := -1;
4566: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
4567: FND_MESSAGE.set_token('MSG', 'x_dsql_select() could not fetch rows');
4568: end if;
4569: dbms_sql.close_cursor(cursornum);
4570: returned_columns := selected_cols;

Line 4567: FND_MESSAGE.set_token('MSG', 'x_dsql_select() could not fetch rows');

4563: END IF;
4564: else
4565: num_returned := -1;
4566: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
4567: FND_MESSAGE.set_token('MSG', 'x_dsql_select() could not fetch rows');
4568: end if;
4569: dbms_sql.close_cursor(cursornum);
4570: returned_columns := selected_cols;
4571: return(num_returned);

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

4597: WHEN OTHERS then
4598: if(dbms_sql.is_open(cursornum)) then
4599: dbms_sql.close_cursor(cursornum);
4600: end if;
4601: FND_MESSAGE.set_name('FND', 'FLEX-DSQL EXCEPTION');
4602: FND_MESSAGE.set_token('MSG', SQLERRM);
4603: FND_MESSAGE.set_token('SQLSTR', SUBSTRB(sql_statement, 1, 1000));
4604: return(-2);
4605:

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

4598: if(dbms_sql.is_open(cursornum)) then
4599: dbms_sql.close_cursor(cursornum);
4600: end if;
4601: FND_MESSAGE.set_name('FND', 'FLEX-DSQL EXCEPTION');
4602: FND_MESSAGE.set_token('MSG', SQLERRM);
4603: FND_MESSAGE.set_token('SQLSTR', SUBSTRB(sql_statement, 1, 1000));
4604: return(-2);
4605:
4606: END x_dsql_select;

Line 4603: FND_MESSAGE.set_token('SQLSTR', SUBSTRB(sql_statement, 1, 1000));

4599: dbms_sql.close_cursor(cursornum);
4600: end if;
4601: FND_MESSAGE.set_name('FND', 'FLEX-DSQL EXCEPTION');
4602: FND_MESSAGE.set_token('MSG', SQLERRM);
4603: FND_MESSAGE.set_token('SQLSTR', SUBSTRB(sql_statement, 1, 1000));
4604: return(-2);
4605:
4606: END x_dsql_select;
4607:

Line 5195: FND_MESSAGE.set_name('FND', 'FLEX-SQL MISSING QUOTE');

5191: if (l_quote_pos = 0) then
5192: --
5193: -- Error, not terminated properly
5194: --
5195: FND_MESSAGE.set_name('FND', 'FLEX-SQL MISSING QUOTE');
5196: FND_MESSAGE.set_token('CLAUSE', p_sql_string);
5197:
5198: raise_application_error
5199: (-20001,

Line 5196: FND_MESSAGE.set_token('CLAUSE', p_sql_string);

5192: --
5193: -- Error, not terminated properly
5194: --
5195: FND_MESSAGE.set_name('FND', 'FLEX-SQL MISSING QUOTE');
5196: FND_MESSAGE.set_token('CLAUSE', p_sql_string);
5197:
5198: raise_application_error
5199: (-20001,
5200: 'Error: Single Quote is not terminated properly. ' ||