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 1654: FND_MESSAGE.set_name('FND', 'FLEX-NO PARENT SEGMENT');

1650: goto return_val;
1651: end if;
1652:
1653: IF (l_parent_index = 0) then
1654: FND_MESSAGE.set_name('FND', 'FLEX-NO PARENT SEGMENT');
1655: FND_MESSAGE.set_token('CHILD', kseg.segname);
1656: vcode := FF_VERROR;
1657: goto return_val;
1658: end if;

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

1651: end if;
1652:
1653: IF (l_parent_index = 0) then
1654: FND_MESSAGE.set_name('FND', 'FLEX-NO PARENT SEGMENT');
1655: FND_MESSAGE.set_token('CHILD', kseg.segname);
1656: vcode := FF_VERROR;
1657: goto return_val;
1658: end if;
1659:

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

1799: return(vcode);
1800:
1801: EXCEPTION
1802: WHEN OTHERS then
1803: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
1804: FND_MESSAGE.set_token('MSG', 'validate_seg() exception: ' || SQLERRM);
1805: IF (fnd_flex_server1.g_debug_level > 0) THEN
1806: FND_FLEX_SERVER1.add_debug('EXCEPTION others SV1.validate_seg() ');
1807: END IF;

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

1800:
1801: EXCEPTION
1802: WHEN OTHERS then
1803: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
1804: FND_MESSAGE.set_token('MSG', 'validate_seg() exception: ' || SQLERRM);
1805: IF (fnd_flex_server1.g_debug_level > 0) THEN
1806: FND_FLEX_SERVER1.add_debug('EXCEPTION others SV1.validate_seg() ');
1807: END IF;
1808: return(FF_VERROR);

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

1880: return(TRUE);
1881:
1882: EXCEPTION
1883: WHEN OTHERS then
1884: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
1885: FND_MESSAGE.set_token('MSG', 'derive_values() exception: ' || SQLERRM);
1886: return(FALSE);
1887:
1888: END derive_values;

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

1881:
1882: EXCEPTION
1883: WHEN OTHERS then
1884: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
1885: FND_MESSAGE.set_token('MSG', 'derive_values() exception: ' || SQLERRM);
1886: return(FALSE);
1887:
1888: END derive_values;
1889:

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

1926: x_display_value := user_value;
1927:
1928: --
1929: -- Since validation utility is setting messages by using
1930: -- fnd_message, we will do a stacking trick here.
1931: --
1932: -- For different result, different style of messaging is used.
1933: -- If the error is serious, always overwrite the existing message.
1934: --

Line 1936: l_ssv_enc_message := fnd_message.get_encoded;

1932: -- For different result, different style of messaging is used.
1933: -- If the error is serious, always overwrite the existing message.
1934: --
1935: IF (value_error_set) THEN
1936: l_ssv_enc_message := fnd_message.get_encoded;
1937: END IF;
1938:
1939: fnd_flex_val_util.validate_value_ssv
1940: (p_value => user_value,

Line 1966: fnd_message.set_encoded(l_ssv_enc_message);

1962: l_return := FF_VVALID;
1963: x_storage_value := l_storage_value;
1964: x_display_value := l_display_value;
1965: IF (value_error_set) THEN
1966: fnd_message.set_encoded(l_ssv_enc_message);
1967: END IF;
1968: ELSE
1969: --
1970: -- Since this is an error case, get the message.

Line 1972: l_utv_enc_message := fnd_message.get_encoded;

1968: ELSE
1969: --
1970: -- Since this is an error case, get the message.
1971: --
1972: l_utv_enc_message := fnd_message.get_encoded;
1973:
1974: IF ((l_success = fnd_flex_val_util.g_ret_value_too_long) OR
1975: (l_success = fnd_flex_val_util.g_ret_invalid_number) OR
1976: (l_success = fnd_flex_val_util.g_ret_invalid_date)) THEN

Line 1982: fnd_message.set_encoded(l_ssv_enc_message);

1978: -- Format Errors.
1979: --
1980: l_return := FF_VFORMAT;
1981: IF (value_error_set) THEN
1982: fnd_message.set_encoded(l_ssv_enc_message);
1983: ELSE
1984: fnd_message.set_encoded(l_utv_enc_message);
1985: END IF;
1986: ELSIF ((l_success = fnd_flex_val_util.g_ret_vs_bad_precision) OR

Line 1984: fnd_message.set_encoded(l_utv_enc_message);

1980: l_return := FF_VFORMAT;
1981: IF (value_error_set) THEN
1982: fnd_message.set_encoded(l_ssv_enc_message);
1983: ELSE
1984: fnd_message.set_encoded(l_utv_enc_message);
1985: END IF;
1986: ELSIF ((l_success = fnd_flex_val_util.g_ret_vs_bad_precision) OR
1987: (l_success = fnd_flex_val_util.g_ret_vs_bad_format) OR
1988: (l_success = fnd_flex_val_util.g_ret_vs_bad_numrange) OR

Line 1996: fnd_message.set_encoded(l_utv_enc_message);

1992: --
1993: -- Serious errors.
1994: --
1995: l_return := FF_VERROR;
1996: fnd_message.set_encoded(l_utv_enc_message);
1997:
1998: ELSIF (l_success = fnd_flex_val_util.g_ret_val_out_of_range) THEN
1999: --
2000: -- Bound Check Error.

Line 2004: fnd_message.set_encoded(l_ssv_enc_message);

2000: -- Bound Check Error.
2001: --
2002: l_return := FF_VBOUNDS;
2003: IF (value_error_set) THEN
2004: fnd_message.set_encoded(l_ssv_enc_message);
2005: ELSE
2006: fnd_message.set_encoded(l_utv_enc_message);
2007: END IF;
2008: ELSE

Line 2006: fnd_message.set_encoded(l_utv_enc_message);

2002: l_return := FF_VBOUNDS;
2003: IF (value_error_set) THEN
2004: fnd_message.set_encoded(l_ssv_enc_message);
2005: ELSE
2006: fnd_message.set_encoded(l_utv_enc_message);
2007: END IF;
2008: ELSE
2009: --
2010: -- Other errors. This part is added, in case there will be changes

Line 2014: fnd_message.set_encoded(l_utv_enc_message);

2010: -- Other errors. This part is added, in case there will be changes
2011: -- in UTV package. As of 26-APR-99 code should not enter here.
2012: --
2013: l_return := FF_VERROR;
2014: fnd_message.set_encoded(l_utv_enc_message);
2015: END IF;
2016: --
2017: -- We are in error case, set messaging globals.
2018: --

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

2031: IF (fnd_flex_server1.g_debug_level > 0) THEN
2032: FND_FLEX_SERVER1.add_debug('EXCEPTION SV1.coerce_format() ');
2033: END IF;
2034:
2035: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
2036: FND_MESSAGE.set_token('MSG', 'coerce_format() exception: ' || SQLERRM);
2037: return(FF_VERROR);
2038: END coerce_format;
2039:

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

2032: FND_FLEX_SERVER1.add_debug('EXCEPTION SV1.coerce_format() ');
2033: END IF;
2034:
2035: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
2036: FND_MESSAGE.set_token('MSG', 'coerce_format() exception: ' || SQLERRM);
2037: return(FF_VERROR);
2038: END coerce_format;
2039:
2040: /* ----------------------------------------------------------------------- */

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

2399:
2400: -- Pair or Special validation unsupported.
2401: --
2402: ELSIF (p_vs_info.valtype in ('P', 'U')) then
2403: FND_MESSAGE.set_name('FND', 'FLEX-SSV UNSUPPORTED VDATION');
2404: FND_MESSAGE.set_token('VSNAME', p_vs_info.vsname);
2405: v_code := FF_VUNKNOWN;
2406:
2407: -- Undefined validation type

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

2400: -- Pair or Special validation unsupported.
2401: --
2402: ELSIF (p_vs_info.valtype in ('P', 'U')) then
2403: FND_MESSAGE.set_name('FND', 'FLEX-SSV UNSUPPORTED VDATION');
2404: FND_MESSAGE.set_token('VSNAME', p_vs_info.vsname);
2405: v_code := FF_VUNKNOWN;
2406:
2407: -- Undefined validation type
2408: --

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

2406:
2407: -- Undefined validation type
2408: --
2409: else
2410: FND_MESSAGE.set_name('FND', 'FLEX-VS BAD VDATION TYPE');
2411: FND_MESSAGE.set_token('VSNAME', p_vs_info.vsname);
2412: FND_MESSAGE.set_token('VTYPE', p_vs_info.valtype);
2413: v_code := FF_VERROR;
2414: end if;

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

2407: -- Undefined validation type
2408: --
2409: else
2410: FND_MESSAGE.set_name('FND', 'FLEX-VS BAD VDATION TYPE');
2411: FND_MESSAGE.set_token('VSNAME', p_vs_info.vsname);
2412: FND_MESSAGE.set_token('VTYPE', p_vs_info.valtype);
2413: v_code := FF_VERROR;
2414: end if;
2415:

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

2408: --
2409: else
2410: FND_MESSAGE.set_name('FND', 'FLEX-VS BAD VDATION TYPE');
2411: FND_MESSAGE.set_token('VSNAME', p_vs_info.vsname);
2412: FND_MESSAGE.set_token('VTYPE', p_vs_info.valtype);
2413: v_code := FF_VERROR;
2414: end if;
2415:
2416: <>

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

2428:
2429: return(v_code);
2430: EXCEPTION
2431: WHEN OTHERS then
2432: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
2433: FND_MESSAGE.set_token('MSG', 'find_value() exception: ' || SQLERRM);
2434: IF (fnd_flex_server1.g_debug_level > 0) THEN
2435: FND_FLEX_SERVER1.add_debug('EXCEPTION others SV1.find_value()');
2436: END IF;

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

2429: return(v_code);
2430: EXCEPTION
2431: WHEN OTHERS then
2432: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
2433: FND_MESSAGE.set_token('MSG', 'find_value() exception: ' || SQLERRM);
2434: IF (fnd_flex_server1.g_debug_level > 0) THEN
2435: FND_FLEX_SERVER1.add_debug('EXCEPTION others SV1.find_value()');
2436: END IF;
2437:

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

2515: open TBL_cursor(p_vs_info.vsid);
2516: FETCH tbl_cursor INTO l_tbl_rec;
2517: IF (TBL_cursor%NOTFOUND) THEN
2518: close TBL_cursor;
2519: FND_MESSAGE.set_name('FND', 'FLEX-SSV MISSING TBLVS');
2520: FND_MESSAGE.set_token('VSNAME', p_vs_info.vsname);
2521: return(FF_VERROR);
2522: end if;
2523: close TBL_cursor;

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

2516: FETCH tbl_cursor INTO l_tbl_rec;
2517: IF (TBL_cursor%NOTFOUND) THEN
2518: close TBL_cursor;
2519: FND_MESSAGE.set_name('FND', 'FLEX-SSV MISSING TBLVS');
2520: FND_MESSAGE.set_token('VSNAME', p_vs_info.vsname);
2521: return(FF_VERROR);
2522: end if;
2523: close TBL_cursor;
2524: END IF;

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

2531:
2532: -- Return error if unsupported validation.
2533: --
2534: if((l_tbl_rec.additional_quickpick_columns is not null) and (INSTR(UPPER(l_tbl_rec.additional_quickpick_columns),'INTO') > 0)) then
2535: FND_MESSAGE.set_name('FND', 'FLEX-SSV NO TBL VS');
2536: FND_MESSAGE.set_token('VSNAME', p_vs_info.vsname);
2537: return(FF_VUNKNOWN);
2538: end if;
2539:

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

2532: -- Return error if unsupported validation.
2533: --
2534: if((l_tbl_rec.additional_quickpick_columns is not null) and (INSTR(UPPER(l_tbl_rec.additional_quickpick_columns),'INTO') > 0)) then
2535: FND_MESSAGE.set_name('FND', 'FLEX-SSV NO TBL VS');
2536: FND_MESSAGE.set_token('VSNAME', p_vs_info.vsname);
2537: return(FF_VUNKNOWN);
2538: end if;
2539:
2540: -- Default column names if null

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

2716: return(FF_VERROR);
2717:
2718: EXCEPTION
2719: WHEN OTHERS then
2720: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
2721: FND_MESSAGE.set_token('MSG', 'table_validate() exception: ' || SQLERRM);
2722: return(FF_VERROR);
2723:
2724: END table_validate;

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

2717:
2718: EXCEPTION
2719: WHEN OTHERS then
2720: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
2721: FND_MESSAGE.set_token('MSG', 'table_validate() exception: ' || SQLERRM);
2722: return(FF_VERROR);
2723:
2724: END table_validate;
2725:

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

2831: END LOOP;
2832:
2833: nfound := x_dsql_select_one(stored_val);
2834: IF (nfound > 1) then
2835: FND_MESSAGE.set_name('FND', 'FLEX-DFLT MULTIPLE SQL ROWS');
2836: FND_MESSAGE.set_token('SQLSTR', SUBSTRB(fnd_dsql.get_text(FALSE), 1, 1000));
2837: v_code := FF_VERROR;
2838: ELSIF (nfound < 0) then
2839: v_code := FF_VERROR;

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

2832:
2833: nfound := x_dsql_select_one(stored_val);
2834: IF (nfound > 1) then
2835: FND_MESSAGE.set_name('FND', 'FLEX-DFLT MULTIPLE SQL ROWS');
2836: FND_MESSAGE.set_token('SQLSTR', SUBSTRB(fnd_dsql.get_text(FALSE), 1, 1000));
2837: v_code := FF_VERROR;
2838: ELSIF (nfound < 0) then
2839: v_code := FF_VERROR;
2840: else

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

2843: end if;
2844:
2845: ELSIF (def_type = 'F') then
2846: -- 'F' => :block.field (the colon may or may not be in the def_text string)
2847: FND_MESSAGE.set_name('FND', 'FLEX-SSV UNSUPPORTED DEFAULT');
2848: v_code := FF_VUNKNOWN;
2849:
2850: ELSIF (def_type = 'E') then
2851: -- Environment variable

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

2848: v_code := FF_VUNKNOWN;
2849:
2850: ELSIF (def_type = 'E') then
2851: -- Environment variable
2852: FND_MESSAGE.set_name('FND', 'FLEX-SSV UNSUPPORTED DEFAULT');
2853: v_code := FF_VUNKNOWN;
2854:
2855: ELSE
2856: -- Unknown type.

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

2853: v_code := FF_VUNKNOWN;
2854:
2855: ELSE
2856: -- Unknown type.
2857: FND_MESSAGE.set_name('FND', 'FLEX-INVALID DEFAULT TYPE');
2858: FND_MESSAGE.set_token('SEGNAME', seg_name);
2859: v_code := FF_VERROR;
2860:
2861: END IF;

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

2854:
2855: ELSE
2856: -- Unknown type.
2857: FND_MESSAGE.set_name('FND', 'FLEX-INVALID DEFAULT TYPE');
2858: FND_MESSAGE.set_token('SEGNAME', seg_name);
2859: v_code := FF_VERROR;
2860:
2861: END IF;
2862:

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

2867: end if;
2868: return(v_code);
2869: EXCEPTION
2870: WHEN OTHERS then
2871: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
2872: FND_MESSAGE.set_token('MSG', 'default_val() exception: ' || SQLERRM);
2873: return(FF_VERROR);
2874: END default_val;
2875:

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

2868: return(v_code);
2869: EXCEPTION
2870: WHEN OTHERS then
2871: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
2872: FND_MESSAGE.set_token('MSG', 'default_val() exception: ' || SQLERRM);
2873: return(FF_VERROR);
2874: END default_val;
2875:
2876: /* ------------------------------------------------------------------------- */

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

2894: BEGIN
2895:
2896: if(clause_in is not null) then
2897: if(INSTR(clause_in, ':$FLEX$') > 0) then
2898: FND_MESSAGE.set_name('FND', 'FLEX-NO FLEX IN WHERE TOKEN');
2899: return(VV_ERROR);
2900: end if;
2901: vcode := substitute_flex_binds3(clause_in, 0,
2902: dummy_dispvls, dummy_vals,

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

2929: return(VV_VALID);
2930:
2931: EXCEPTION
2932: WHEN OTHERS then
2933: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
2934: FND_MESSAGE.set_token('MSG', 'parse_where_token() exception: '||SQLERRM);
2935: return(VV_ERROR);
2936:
2937: END parse_where_token;

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

2930:
2931: EXCEPTION
2932: WHEN OTHERS then
2933: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
2934: FND_MESSAGE.set_token('MSG', 'parse_where_token() exception: '||SQLERRM);
2935: return(VV_ERROR);
2936:
2937: END parse_where_token;
2938:

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

3002: WHEN OTHERS then
3003: IF (fnd_flex_server1.g_debug_level > 0) THEN
3004: add_debug('EXCEPTION SV1.substitute_flex_binds3()');
3005: END IF;
3006: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
3007: FND_MESSAGE.set_token('MSG', 'substitute_flex_binds3() exception: '
3008: || SQLERRM);
3009: return(FF_VERROR);
3010: END substitute_flex_binds3;

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

3003: IF (fnd_flex_server1.g_debug_level > 0) THEN
3004: add_debug('EXCEPTION SV1.substitute_flex_binds3()');
3005: END IF;
3006: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
3007: FND_MESSAGE.set_token('MSG', 'substitute_flex_binds3() exception: '
3008: || SQLERRM);
3009: return(FF_VERROR);
3010: END substitute_flex_binds3;
3011:

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

3067: WHEN OTHERS then
3068: IF (fnd_flex_server1.g_debug_level > 0) THEN
3069: add_debug('EXCEPTION SV1.substitute_flex_binds5()');
3070: END IF;
3071: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
3072: FND_MESSAGE.set_token('MSG', 'substitute_flex_binds5() exception: '
3073: || SQLERRM);
3074: return(FF_VERROR);
3075: END substitute_flex_binds5;

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

3068: IF (fnd_flex_server1.g_debug_level > 0) THEN
3069: add_debug('EXCEPTION SV1.substitute_flex_binds5()');
3070: END IF;
3071: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
3072: FND_MESSAGE.set_token('MSG', 'substitute_flex_binds5() exception: '
3073: || SQLERRM);
3074: return(FF_VERROR);
3075: END substitute_flex_binds5;
3076:

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

3149: end if;
3150: end if;
3151:
3152: if (dot_pointer > col_pointer) then
3153: FND_MESSAGE.set_name('FND','FLEX-INVALID PORTION');
3154: FND_MESSAGE.set_token('BTOKEN',bind_token);
3155: l_return_code := FF_VERROR;
3156: GOTO goto_return;
3157: end if;

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

3150: end if;
3151:
3152: if (dot_pointer > col_pointer) then
3153: FND_MESSAGE.set_name('FND','FLEX-INVALID PORTION');
3154: FND_MESSAGE.set_token('BTOKEN',bind_token);
3155: l_return_code := FF_VERROR;
3156: GOTO goto_return;
3157: end if;
3158:

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

3183: bind_val := prev_ids(s_index);
3184: elsif(seg_portion = 'MEANING') then
3185: bind_val := prev_descs(s_index);
3186: else
3187: FND_MESSAGE.set_name('FND', 'FLEX-INVALID PORTION');
3188: FND_MESSAGE.set_token('BTOKEN', bind_token);
3189: l_return_code := FF_VERROR;
3190: GOTO goto_return;
3191: end if;

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

3184: elsif(seg_portion = 'MEANING') then
3185: bind_val := prev_descs(s_index);
3186: else
3187: FND_MESSAGE.set_name('FND', 'FLEX-INVALID PORTION');
3188: FND_MESSAGE.set_token('BTOKEN', bind_token);
3189: l_return_code := FF_VERROR;
3190: GOTO goto_return;
3191: end if;
3192: else

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

3189: l_return_code := FF_VERROR;
3190: GOTO goto_return;
3191: end if;
3192: else
3193: FND_MESSAGE.set_name('FND', 'FLEX-PRIOR SEG NOTFOUND');
3194: FND_MESSAGE.set_token('BTOKEN', bind_token);
3195: l_return_code := FF_VERROR;
3196: GOTO goto_return;
3197: end if;

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

3190: GOTO goto_return;
3191: end if;
3192: else
3193: FND_MESSAGE.set_name('FND', 'FLEX-PRIOR SEG NOTFOUND');
3194: FND_MESSAGE.set_token('BTOKEN', bind_token);
3195: l_return_code := FF_VERROR;
3196: GOTO goto_return;
3197: end if;
3198:

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

3199: else
3200:
3201: -- :BLOCK.FIELD cannot be handled here
3202: --
3203: FND_MESSAGE.set_name('FND', 'FLEX-UNSUPPORTED FLEX BIND');
3204: l_return_code := FF_VUNKNOWN;
3205: GOTO goto_return;
3206:
3207: end if;

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

3218: WHEN OTHERS then
3219: IF (fnd_flex_server1.g_debug_level > 0) THEN
3220: add_debug('EXCEPTION others SV1.convert_bind_token()');
3221: END IF;
3222: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
3223: FND_MESSAGE.set_token('MSG','convert_bind_token() exception: '||SQLERRM);
3224: return(FF_VERROR);
3225: END convert_bind_token;
3226:

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

3219: IF (fnd_flex_server1.g_debug_level > 0) THEN
3220: add_debug('EXCEPTION others SV1.convert_bind_token()');
3221: END IF;
3222: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
3223: FND_MESSAGE.set_token('MSG','convert_bind_token() exception: '||SQLERRM);
3224: return(FF_VERROR);
3225: END convert_bind_token;
3226:
3227: --

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

3301: WHEN OTHERS then
3302: IF (fnd_flex_server1.g_debug_level > 0) THEN
3303: add_debug('EXCEPTION others SV1.convert_bind_token2()');
3304: END IF;
3305: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
3306: FND_MESSAGE.set_token('MSG','convert_bind_token2() exception: '||SQLERRM);
3307: return(FF_VERROR);
3308: END convert_bind_token2;
3309:

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

3302: IF (fnd_flex_server1.g_debug_level > 0) THEN
3303: add_debug('EXCEPTION others SV1.convert_bind_token2()');
3304: END IF;
3305: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
3306: FND_MESSAGE.set_token('MSG','convert_bind_token2() exception: '||SQLERRM);
3307: return(FF_VERROR);
3308: END convert_bind_token2;
3309:
3310: /* ----------------------------------------------------------------------- */

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

3361: return(FF_VVALID);
3362:
3363: EXCEPTION
3364: WHEN OTHERS then
3365: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
3366: FND_MESSAGE.set_token('MSG', 'check_vrules() exception: ' || SQLERRM);
3367: return(FF_VERROR);
3368:
3369: END check_vrules;

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

3362:
3363: EXCEPTION
3364: WHEN OTHERS then
3365: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
3366: FND_MESSAGE.set_token('MSG', 'check_vrules() exception: ' || SQLERRM);
3367: return(FF_VERROR);
3368:
3369: END check_vrules;
3370:

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

3409: return(retcode);
3410:
3411: EXCEPTION
3412: WHEN OTHERS then
3413: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
3414: FND_MESSAGE.set_token('MSG','check_comb_vrules() exception: '||SQLERRM);
3415: return(VV_ERROR);
3416:
3417: END check_comb_vrules;

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

3410:
3411: EXCEPTION
3412: WHEN OTHERS then
3413: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
3414: FND_MESSAGE.set_token('MSG','check_comb_vrules() exception: '||SQLERRM);
3415: return(VV_ERROR);
3416:
3417: END check_comb_vrules;
3418:

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

3505: END IF;
3506: RETURN(l_return_code);
3507: EXCEPTION
3508: WHEN OTHERS then
3509: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
3510: FND_MESSAGE.set_token('MSG','check_security() exception: ' || SQLERRM);
3511: IF (fnd_flex_server1.g_debug_level > 0) THEN
3512: add_debug('EXCEPTION SV1.check_security()');
3513: END IF;

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

3506: RETURN(l_return_code);
3507: EXCEPTION
3508: WHEN OTHERS then
3509: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
3510: FND_MESSAGE.set_token('MSG','check_security() exception: ' || SQLERRM);
3511: IF (fnd_flex_server1.g_debug_level > 0) THEN
3512: add_debug('EXCEPTION SV1.check_security()');
3513: END IF;
3514:

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

3532: return(TRUE);
3533:
3534: EXCEPTION
3535: WHEN OTHERS then
3536: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
3537: FND_MESSAGE.set_token('MSG','check_displayed() exception: ' ||SQLERRM);
3538: return(FALSE);
3539:
3540: END check_displayed;

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

3533:
3534: EXCEPTION
3535: WHEN OTHERS then
3536: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
3537: FND_MESSAGE.set_token('MSG','check_displayed() exception: ' ||SQLERRM);
3538: return(FALSE);
3539:
3540: END check_displayed;
3541:

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

3666: return(cva_index);
3667:
3668: EXCEPTION
3669: WHEN OTHERS then
3670: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
3671: FND_MESSAGE.set_token('MSG', 'qualifier_values() exception: '||SQLERRM);
3672: return(-1);
3673:
3674: END qualifier_values;

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

3667:
3668: EXCEPTION
3669: WHEN OTHERS then
3670: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
3671: FND_MESSAGE.set_token('MSG', 'qualifier_values() exception: '||SQLERRM);
3672: return(-1);
3673:
3674: END qualifier_values;
3675:

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

3764:
3765: RETURN(sqcount);
3766: EXCEPTION
3767: WHEN OTHERS then
3768: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
3769: FND_MESSAGE.set_token('MSG', 'get_qualifiers() exception: ' || SQLERRM);
3770: IF (fnd_flex_server1.g_debug_level > 0) THEN
3771: fnd_flex_server1.add_debug('EXCEPTION SV1.get_qualifiers()');
3772: END IF;

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

3765: RETURN(sqcount);
3766: EXCEPTION
3767: WHEN OTHERS then
3768: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
3769: FND_MESSAGE.set_token('MSG', 'get_qualifiers() exception: ' || SQLERRM);
3770: IF (fnd_flex_server1.g_debug_level > 0) THEN
3771: fnd_flex_server1.add_debug('EXCEPTION SV1.get_qualifiers()');
3772: END IF;
3773:

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

3846: END IF;
3847: return(TRUE);
3848: EXCEPTION
3849: WHEN NO_DATA_FOUND then
3850: FND_MESSAGE.set_name('FND', 'FLEX-VALUE SET NOT FOUND');
3851: FND_MESSAGE.set_token('SEGMENT', segment_name);
3852: return(FALSE);
3853: WHEN OTHERS then
3854: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');

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

3847: return(TRUE);
3848: EXCEPTION
3849: WHEN NO_DATA_FOUND then
3850: FND_MESSAGE.set_name('FND', 'FLEX-VALUE SET NOT FOUND');
3851: FND_MESSAGE.set_token('SEGMENT', segment_name);
3852: return(FALSE);
3853: WHEN OTHERS then
3854: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
3855: FND_MESSAGE.set_token('MSG', 'get_value_set() exception: ' || SQLERRM);

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

3850: FND_MESSAGE.set_name('FND', 'FLEX-VALUE SET NOT FOUND');
3851: FND_MESSAGE.set_token('SEGMENT', segment_name);
3852: return(FALSE);
3853: WHEN OTHERS then
3854: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
3855: FND_MESSAGE.set_token('MSG', 'get_value_set() exception: ' || SQLERRM);
3856: return(FALSE);
3857: END get_value_set;
3858:

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

3851: FND_MESSAGE.set_token('SEGMENT', segment_name);
3852: return(FALSE);
3853: WHEN OTHERS then
3854: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
3855: FND_MESSAGE.set_token('MSG', 'get_value_set() exception: ' || SQLERRM);
3856: return(FALSE);
3857: END get_value_set;
3858:
3859: /* ----------------------------------------------------------------------- */

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

3879: vs_info.capsonly := 'N';
3880: vs_info.zfill := 'N';
3881: return(TRUE);
3882: end if;
3883: FND_MESSAGE.set_name('FND', 'FLEX-VALUE SET REQUIRED');
3884: FND_MESSAGE.set_token('SEGMENT', segment_name);
3885: return(FALSE);
3886:
3887: EXCEPTION

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

3880: vs_info.zfill := 'N';
3881: return(TRUE);
3882: end if;
3883: FND_MESSAGE.set_name('FND', 'FLEX-VALUE SET REQUIRED');
3884: FND_MESSAGE.set_token('SEGMENT', segment_name);
3885: return(FALSE);
3886:
3887: EXCEPTION
3888: WHEN OTHERS then

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

3885: return(FALSE);
3886:
3887: EXCEPTION
3888: WHEN OTHERS then
3889: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
3890: FND_MESSAGE.set_token('MSG','virtual_value_set() exception: '||SQLERRM);
3891: return(FALSE);
3892:
3893: END virtual_value_set;

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

3886:
3887: EXCEPTION
3888: WHEN OTHERS then
3889: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
3890: FND_MESSAGE.set_token('MSG','virtual_value_set() exception: '||SQLERRM);
3891: return(FALSE);
3892:
3893: END virtual_value_set;
3894:

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

3894:
3895: /* ----------------------------------------------------------------------- */
3896: /* Message handler functions for value validation errors. Needed */
3897: /* because value validation does not always stop at the first */
3898: /* error encountered. This handler makes sure that FND_MESSAGE */
3899: /* error is set to the first value error if there are no other */
3900: /* errors. For more serious errors, we set the message directly */
3901: /* using the FND_MESSAGE package. Note this assumes the main */
3902: /* validate_struct() function knows to stop on the first serious */

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

3897: /* because value validation does not always stop at the first */
3898: /* error encountered. This handler makes sure that FND_MESSAGE */
3899: /* error is set to the first value error if there are no other */
3900: /* errors. For more serious errors, we set the message directly */
3901: /* using the FND_MESSAGE package. Note this assumes the main */
3902: /* validate_struct() function knows to stop on the first serious */
3903: /* error otherwise we risk overwriting a more serious error with */
3904: /* a value error. */
3905: /* If the application short name is null, then we use the */

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

3931: errmsg_name IN VARCHAR2) IS
3932: BEGIN
3933: if(value_error_set = FALSE) then
3934: if(appl_sname is null) then
3935: FND_MESSAGE.set_name('FND', 'FLEX-USER DEFINED ERROR');
3936: FND_MESSAGE.set_token('MSG', errmsg_name);
3937: else
3938: FND_MESSAGE.set_name(appl_sname, errmsg_name);
3939: end if;

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

3932: BEGIN
3933: if(value_error_set = FALSE) then
3934: if(appl_sname is null) then
3935: FND_MESSAGE.set_name('FND', 'FLEX-USER DEFINED ERROR');
3936: FND_MESSAGE.set_token('MSG', errmsg_name);
3937: else
3938: FND_MESSAGE.set_name(appl_sname, errmsg_name);
3939: end if;
3940: value_error_set := TRUE;

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

3934: if(appl_sname is null) then
3935: FND_MESSAGE.set_name('FND', 'FLEX-USER DEFINED ERROR');
3936: FND_MESSAGE.set_token('MSG', errmsg_name);
3937: else
3938: FND_MESSAGE.set_name(appl_sname, errmsg_name);
3939: end if;
3940: value_error_set := TRUE;
3941: entering_new_message := TRUE;
3942: else

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

3957: PROCEDURE value_error_token(token_name IN VARCHAR2,
3958: token_value IN VARCHAR2) IS
3959: BEGIN
3960: if(entering_new_message) then
3961: FND_MESSAGE.set_token(token_name, token_value);
3962: end if;
3963: EXCEPTION
3964: WHEN OTHERS then
3965: IF (fnd_flex_server1.g_debug_level > 0) THEN

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

4136: END IF;
4137:
4138: EXCEPTION
4139: WHEN OTHERS then
4140: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
4141: FND_MESSAGE.set_token('MSG',
4142: 'displayed_date_format() exception: ' || SQLERRM);
4143: return(NULL);
4144:

Line 4141: FND_MESSAGE.set_token('MSG',

4137:
4138: EXCEPTION
4139: WHEN OTHERS then
4140: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
4141: FND_MESSAGE.set_token('MSG',
4142: 'displayed_date_format() exception: ' || SQLERRM);
4143: return(NULL);
4144:
4145: END displayed_date_format;

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

4166: END IF;
4167:
4168: EXCEPTION
4169: WHEN OTHERS then
4170: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
4171: FND_MESSAGE.set_token('MSG',
4172: 'stored_date_format() exception: ' || SQLERRM);
4173: return(NULL);
4174:

Line 4171: FND_MESSAGE.set_token('MSG',

4167:
4168: EXCEPTION
4169: WHEN OTHERS then
4170: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
4171: FND_MESSAGE.set_token('MSG',
4172: 'stored_date_format() exception: ' || SQLERRM);
4173: return(NULL);
4174:
4175: END stored_date_format;

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

4190: return(TRUE);
4191:
4192: EXCEPTION
4193: WHEN OTHERS then
4194: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
4195: FND_MESSAGE.set_token('MSG', 'init_globals() exception: ' || SQLERRM);
4196: return(FALSE);
4197:
4198: END init_globals;

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

4191:
4192: EXCEPTION
4193: WHEN OTHERS then
4194: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
4195: FND_MESSAGE.set_token('MSG', 'init_globals() exception: ' || SQLERRM);
4196: return(FALSE);
4197:
4198: END init_globals;
4199:

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

4373: -- /* ----------------------------------------------------------------------- */
4374: -- /* MADE NULL TO MAKE MORE ROOM FOR USEFUL CODE. */
4375: -- /* Breaks concatenated segments in rule lines table into separate */
4376: -- /* columns for each segment. Returns number of segments or < 0 */
4377: -- /* and sets FND_MESSAGE if error. This is called only from trigger */
4378: -- /* FND_FLEX_VALIDATION_RULE_LINES_T1. The trigger should use */
4379: -- /* FND_MESSAGE.raise_exception if this function returns error. */
4380: -- /* ----------------------------------------------------------------------- */
4381: -- FUNCTION breakup_segs(appid IN NUMBER,

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

4375: -- /* Breaks concatenated segments in rule lines table into separate */
4376: -- /* columns for each segment. Returns number of segments or < 0 */
4377: -- /* and sets FND_MESSAGE if error. This is called only from trigger */
4378: -- /* FND_FLEX_VALIDATION_RULE_LINES_T1. The trigger should use */
4379: -- /* FND_MESSAGE.raise_exception if this function returns error. */
4380: -- /* ----------------------------------------------------------------------- */
4381: -- FUNCTION breakup_segs(appid IN NUMBER,
4382: -- flex_code IN VARCHAR2, flex_num IN NUMBER,
4383: -- catsegs IN VARCHAR2, nsegs OUT NUMBER,

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

4405: -- return(-1);
4406: --
4407: -- EXCEPTION
4408: -- WHEN OTHERS then
4409: -- FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
4410: -- FND_MESSAGE.set_token('MSG', 'breakup_segs() exception: ' || SQLERRM);
4411: -- return(-2);
4412: --
4413: -- END breakup_segs;

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

4406: --
4407: -- EXCEPTION
4408: -- WHEN OTHERS then
4409: -- FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
4410: -- FND_MESSAGE.set_token('MSG', 'breakup_segs() exception: ' || SQLERRM);
4411: -- return(-2);
4412: --
4413: -- END breakup_segs;
4414:

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

4448: WHEN OTHERS then
4449: if(dbms_sql.is_open(cursornum)) then
4450: dbms_sql.close_cursor(cursornum);
4451: end if;
4452: FND_MESSAGE.set_name('FND', 'FLEX-DSQL EXCEPTION');
4453: FND_MESSAGE.set_token('MSG', SQLERRM);
4454: FND_MESSAGE.set_token('SQLSTR', SUBSTRB(sql_statement, 1, 1000));
4455: return(-1);
4456:

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

4449: if(dbms_sql.is_open(cursornum)) then
4450: dbms_sql.close_cursor(cursornum);
4451: end if;
4452: FND_MESSAGE.set_name('FND', 'FLEX-DSQL EXCEPTION');
4453: FND_MESSAGE.set_token('MSG', SQLERRM);
4454: FND_MESSAGE.set_token('SQLSTR', SUBSTRB(sql_statement, 1, 1000));
4455: return(-1);
4456:
4457: END x_dsql_execute;

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

4450: dbms_sql.close_cursor(cursornum);
4451: end if;
4452: FND_MESSAGE.set_name('FND', 'FLEX-DSQL EXCEPTION');
4453: FND_MESSAGE.set_token('MSG', SQLERRM);
4454: FND_MESSAGE.set_token('SQLSTR', SUBSTRB(sql_statement, 1, 1000));
4455: return(-1);
4456:
4457: END x_dsql_execute;
4458:

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

4498: END IF;
4499: else
4500: num_returned := -1;
4501: returned_column := NULL;
4502: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
4503: FND_MESSAGE.set_token('MSG', 'x_dsql_select_one() could not fetch rows');
4504: end if;
4505: dbms_sql.close_cursor(cursornum);
4506: return(num_returned);

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

4499: else
4500: num_returned := -1;
4501: returned_column := NULL;
4502: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
4503: FND_MESSAGE.set_token('MSG', 'x_dsql_select_one() could not fetch rows');
4504: end if;
4505: dbms_sql.close_cursor(cursornum);
4506: return(num_returned);
4507:

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

4524: WHEN OTHERS then
4525: if(dbms_sql.is_open(cursornum)) then
4526: dbms_sql.close_cursor(cursornum);
4527: end if;
4528: FND_MESSAGE.set_name('FND', 'FLEX-DSQL EXCEPTION');
4529: FND_MESSAGE.set_token('MSG', SQLERRM);
4530: FND_MESSAGE.set_token('SQLSTR', SUBSTRB(sql_statement, 1, 1000));
4531: return(-2);
4532:

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

4525: if(dbms_sql.is_open(cursornum)) then
4526: dbms_sql.close_cursor(cursornum);
4527: end if;
4528: FND_MESSAGE.set_name('FND', 'FLEX-DSQL EXCEPTION');
4529: FND_MESSAGE.set_token('MSG', SQLERRM);
4530: FND_MESSAGE.set_token('SQLSTR', SUBSTRB(sql_statement, 1, 1000));
4531: return(-2);
4532:
4533: END x_dsql_select_one;

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

4526: dbms_sql.close_cursor(cursornum);
4527: end if;
4528: FND_MESSAGE.set_name('FND', 'FLEX-DSQL EXCEPTION');
4529: FND_MESSAGE.set_token('MSG', SQLERRM);
4530: FND_MESSAGE.set_token('SQLSTR', SUBSTRB(sql_statement, 1, 1000));
4531: return(-2);
4532:
4533: END x_dsql_select_one;
4534:

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

4582: add_debug(')');
4583: END IF;
4584: else
4585: num_returned := -1;
4586: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
4587: FND_MESSAGE.set_token('MSG', 'x_dsql_select() could not fetch rows');
4588: end if;
4589: dbms_sql.close_cursor(cursornum);
4590: returned_columns := selected_cols;

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

4583: END IF;
4584: else
4585: num_returned := -1;
4586: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
4587: FND_MESSAGE.set_token('MSG', 'x_dsql_select() could not fetch rows');
4588: end if;
4589: dbms_sql.close_cursor(cursornum);
4590: returned_columns := selected_cols;
4591: return(num_returned);

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

4617: WHEN OTHERS then
4618: if(dbms_sql.is_open(cursornum)) then
4619: dbms_sql.close_cursor(cursornum);
4620: end if;
4621: FND_MESSAGE.set_name('FND', 'FLEX-DSQL EXCEPTION');
4622: FND_MESSAGE.set_token('MSG', SQLERRM);
4623: FND_MESSAGE.set_token('SQLSTR', SUBSTRB(sql_statement, 1, 1000));
4624: return(-2);
4625:

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

4618: if(dbms_sql.is_open(cursornum)) then
4619: dbms_sql.close_cursor(cursornum);
4620: end if;
4621: FND_MESSAGE.set_name('FND', 'FLEX-DSQL EXCEPTION');
4622: FND_MESSAGE.set_token('MSG', SQLERRM);
4623: FND_MESSAGE.set_token('SQLSTR', SUBSTRB(sql_statement, 1, 1000));
4624: return(-2);
4625:
4626: END x_dsql_select;

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

4619: dbms_sql.close_cursor(cursornum);
4620: end if;
4621: FND_MESSAGE.set_name('FND', 'FLEX-DSQL EXCEPTION');
4622: FND_MESSAGE.set_token('MSG', SQLERRM);
4623: FND_MESSAGE.set_token('SQLSTR', SUBSTRB(sql_statement, 1, 1000));
4624: return(-2);
4625:
4626: END x_dsql_select;
4627:

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

5211: if (l_quote_pos = 0) then
5212: --
5213: -- Error, not terminated properly
5214: --
5215: FND_MESSAGE.set_name('FND', 'FLEX-SQL MISSING QUOTE');
5216: FND_MESSAGE.set_token('CLAUSE', p_sql_string);
5217:
5218: raise_application_error
5219: (-20001,

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

5212: --
5213: -- Error, not terminated properly
5214: --
5215: FND_MESSAGE.set_name('FND', 'FLEX-SQL MISSING QUOTE');
5216: FND_MESSAGE.set_token('CLAUSE', p_sql_string);
5217:
5218: raise_application_error
5219: (-20001,
5220: 'Error: Single Quote is not terminated properly. ' ||