506: v_SeqInfoCache.initFlag := TRUE;
507:
508: /* This call will retrieve the value of the "Sequential Numbering" profile option
509: 'A' = Always Used, 'N' = Not Used, 'P' = Partially Used */
510: FND_PROFILE.GET( 'UNIQUE:SEQ_NUMBERS', v_profVal );
511: IF v_profVal = 'N' THEN
512: v_SeqInfoCache.retStat := FND_SEQNUM.NOTUSED;
513: return( v_SeqInfoCache.retStat );
514: ELSIF v_profVal <> 'P' AND v_profVal <> 'A' THEN
666: END IF;
667: END IF;
668:
669: /* This call will retrieve the value of the "USER_ID" profile option */
670: FND_PROFILE.GET( 'USER_ID', v_profVal );
671: IF v_profVal IS NULL THEN
672: fnd_message.set_name( 'FND', 'USER' ); -- this should never happen, BUT...
673: app_exception.raise_exception;
674: return( FND_SEQNUM.BADPROF );