231: return(return_status);
232:
233: EXCEPTION
234: WHEN OTHERS then
235: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
236: FND_MESSAGE.set_token('MSG', 'load_desc() exception: ' || SQLERRM);
237: err_msg := FND_MESSAGE.get_encoded;
238: return(FALSE);
239:
232:
233: EXCEPTION
234: WHEN OTHERS then
235: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
236: FND_MESSAGE.set_token('MSG', 'load_desc() exception: ' || SQLERRM);
237: err_msg := FND_MESSAGE.get_encoded;
238: return(FALSE);
239:
240: END load_desc;
233: EXCEPTION
234: WHEN OTHERS then
235: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
236: FND_MESSAGE.set_token('MSG', 'load_desc() exception: ' || SQLERRM);
237: err_msg := FND_MESSAGE.get_encoded;
238: return(FALSE);
239:
240: END load_desc;
241:
301: return(return_status);
302:
303: EXCEPTION
304: WHEN OTHERS then
305: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
306: FND_MESSAGE.set_token('MSG', 'check_desc() exception: ' || SQLERRM);
307: err_msg := FND_MESSAGE.get_encoded;
308: return(FALSE);
309:
302:
303: EXCEPTION
304: WHEN OTHERS then
305: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
306: FND_MESSAGE.set_token('MSG', 'check_desc() exception: ' || SQLERRM);
307: err_msg := FND_MESSAGE.get_encoded;
308: return(FALSE);
309:
310: END check_desc;
303: EXCEPTION
304: WHEN OTHERS then
305: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
306: FND_MESSAGE.set_token('MSG', 'check_desc() exception: ' || SQLERRM);
307: err_msg := FND_MESSAGE.get_encoded;
308: return(FALSE);
309:
310: END check_desc;
311:
375: return(return_status);
376:
377: EXCEPTION
378: WHEN OTHERS then
379: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
380: FND_MESSAGE.set_token('MSG', 'val_desc() exception: ' || SQLERRM);
381: err_msg := FND_MESSAGE.get_encoded;
382: return(FALSE);
383:
376:
377: EXCEPTION
378: WHEN OTHERS then
379: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
380: FND_MESSAGE.set_token('MSG', 'val_desc() exception: ' || SQLERRM);
381: err_msg := FND_MESSAGE.get_encoded;
382: return(FALSE);
383:
384: END val_desc;
377: EXCEPTION
378: WHEN OTHERS then
379: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
380: FND_MESSAGE.set_token('MSG', 'val_desc() exception: ' || SQLERRM);
381: err_msg := FND_MESSAGE.get_encoded;
382: return(FALSE);
383:
384: END val_desc;
385:
455: return(return_status);
456:
457: EXCEPTION
458: WHEN OTHERS then
459: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
460: FND_MESSAGE.set_token('MSG', 'validate_desccols() exception: '||SQLERRM);
461: err_msg := FND_MESSAGE.get_encoded;
462: return(FALSE);
463:
456:
457: EXCEPTION
458: WHEN OTHERS then
459: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
460: FND_MESSAGE.set_token('MSG', 'validate_desccols() exception: '||SQLERRM);
461: err_msg := FND_MESSAGE.get_encoded;
462: return(FALSE);
463:
464: END validate_desccols;
457: EXCEPTION
458: WHEN OTHERS then
459: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
460: FND_MESSAGE.set_token('MSG', 'validate_desccols() exception: '||SQLERRM);
461: err_msg := FND_MESSAGE.get_encoded;
462: return(FALSE);
463:
464: END validate_desccols;
465:
551:
552: FUNCTION error_message RETURN VARCHAR2 IS
553: BEGIN
554: if((err_text is null) and (err_msg is not null)) then
555: FND_MESSAGE.set_encoded(err_msg);
556: err_text := FND_MESSAGE.get;
557: end if;
558: return(err_text);
559: END error_message;
552: FUNCTION error_message RETURN VARCHAR2 IS
553: BEGIN
554: if((err_text is null) and (err_msg is not null)) then
555: FND_MESSAGE.set_encoded(err_msg);
556: err_text := FND_MESSAGE.get;
557: end if;
558: return(err_text);
559: END error_message;
560:
751: return(TRUE);
752:
753: EXCEPTION
754: WHEN OTHERS then
755: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
756: FND_MESSAGE.set_token('MSG','init_all() exception: ' || SQLERRM);
757: return(FALSE);
758: END init_all;
759:
752:
753: EXCEPTION
754: WHEN OTHERS then
755: FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
756: FND_MESSAGE.set_token('MSG','init_all() exception: ' || SQLERRM);
757: return(FALSE);
758: END init_all;
759:
760: /* ------------------------------------------------------------------------ */
802:
803: FUNCTION return_status RETURN BOOLEAN IS
804: BEGIN
805: if(not sta_valid) then
806: err_msg := FND_MESSAGE.get_encoded;
807: clear_all_but_error;
808: end if;
809: return(sta_valid);
810: END return_status;