18: EXCEPTION
19: WHEN OTHERS THEN
20: err_num := SQLCODE;
21: err_msg := SUBSTR(SQLERRM, 1, 240);
22: FND_MESSAGE.set_name('FND', 'SQL_PLSQL_ERROR');
23: FND_MESSAGE.set_token('ERRNO', TO_CHAR(err_num));
24: FND_MESSAGE.set_token('REASON', err_msg);
25: FND_MESSAGE.set_token('ROUTINE', 'FND_FLEX_DATE.CONVERT_FORMAT');
26: RETURN (FALSE);
19: WHEN OTHERS THEN
20: err_num := SQLCODE;
21: err_msg := SUBSTR(SQLERRM, 1, 240);
22: FND_MESSAGE.set_name('FND', 'SQL_PLSQL_ERROR');
23: FND_MESSAGE.set_token('ERRNO', TO_CHAR(err_num));
24: FND_MESSAGE.set_token('REASON', err_msg);
25: FND_MESSAGE.set_token('ROUTINE', 'FND_FLEX_DATE.CONVERT_FORMAT');
26: RETURN (FALSE);
27: END convert_format;
20: err_num := SQLCODE;
21: err_msg := SUBSTR(SQLERRM, 1, 240);
22: FND_MESSAGE.set_name('FND', 'SQL_PLSQL_ERROR');
23: FND_MESSAGE.set_token('ERRNO', TO_CHAR(err_num));
24: FND_MESSAGE.set_token('REASON', err_msg);
25: FND_MESSAGE.set_token('ROUTINE', 'FND_FLEX_DATE.CONVERT_FORMAT');
26: RETURN (FALSE);
27: END convert_format;
28:
21: err_msg := SUBSTR(SQLERRM, 1, 240);
22: FND_MESSAGE.set_name('FND', 'SQL_PLSQL_ERROR');
23: FND_MESSAGE.set_token('ERRNO', TO_CHAR(err_num));
24: FND_MESSAGE.set_token('REASON', err_msg);
25: FND_MESSAGE.set_token('ROUTINE', 'FND_FLEX_DATE.CONVERT_FORMAT');
26: RETURN (FALSE);
27: END convert_format;
28:
29: END FND_FLEX_DATE;