[Home] [Help]
3994:
3995: END call_fdfgli;
3996:
3997: /* ----------------------------------------------------------------------- */
3998: /* Calls user PLSQL validation function FND_FLEX_PLSQL.validate(). */
3999: /* Requires FND_FLEX_PLSQL stub package for compilation. */
4000: /* The validate() function is called with both concatenated and */
4001: /* individual segment ids in order they are defined in the flexfield */
4002: /* structure. It will return TRUE if combination passes all user */
3995: END call_fdfgli;
3996:
3997: /* ----------------------------------------------------------------------- */
3998: /* Calls user PLSQL validation function FND_FLEX_PLSQL.validate(). */
3999: /* Requires FND_FLEX_PLSQL stub package for compilation. */
4000: /* The validate() function is called with both concatenated and */
4001: /* individual segment ids in order they are defined in the flexfield */
4002: /* structure. It will return TRUE if combination passes all user */
4003: /* defined validation rules, or FALSE on error or if it does not */
4037: -- Next save the debugging info to the standard server debug string.
4038: -- Note this is different from the client which will save it to a
4039: -- file fdfplv.log. Use errmsg as temporary string to store debug info.
4040: --
4041: errmsg := ' Calling FND_FLEX_PLSQL.validate(';
4042: errmsg := errmsg || to_char(fstruct.application_id) || ', ';
4043: errmsg := errmsg || fstruct.id_flex_code || ', ';
4044: errmsg := errmsg || to_char(fstruct.id_flex_num) || ', ';
4045: errmsg := errmsg || to_char(vdate, FND_FLEX_SERVER1.DATETIME_FMT) || ', ';
4053: errmsg := NULL;
4054:
4055: -- Now call the function
4056: --
4057: if(FND_FLEX_PLSQL.validate(fstruct.application_id, fstruct.id_flex_code,
4058: fstruct.id_flex_num, vdate, delim, catids, nids, ids(1), ids(2),
4059: ids(3), ids(4), ids(5), ids(6), ids(7), ids(8), ids(9),
4060: ids(10), ids(11), ids(12), ids(13), ids(14), ids(15), ids(16),
4061: ids(17), ids(18), ids(19), ids(20), ids(21), ids(22), ids(23),