DBA Data[Home] [Help]

APPS.FND_SEQNUM dependencies on GL_SETS_OF_BOOKS

Line 934: from GL_SETS_OF_BOOKS where SET_OF_BOOKS_ID = sob_id;

930: and DESCRIPTIVE_FLEX_CONTEXT_CODE = 'Global Data Elements';
931: IF v_enabled = 'Y' THEN
932: begin /* verify the Set of Books ID */
933: select count( SET_OF_BOOKS_ID ) into v_numRows
934: from GL_SETS_OF_BOOKS where SET_OF_BOOKS_ID = sob_id;
935: IF v_numRows = 0 THEN
936: return ( FND_SEQNUM.BADSOB );
937: END IF;
938: exception

Line 945: fnd_message.set_token( 'SQLSTMT', 'select count from GL_SETS_OF_BOOKS where SET_OF_BOOKS_ID = ' || to_char( sob_id ), FALSE );

941: fnd_message.set_token( 'ERRNO', sqlcode, FALSE );
942: fnd_message.set_token( 'ROUTINE', 'assign_doc_seq', FALSE );
943: fnd_message.set_token( 'REASON', sqlerrm, FALSE );
944: fnd_message.set_token( 'ERRFILE', 'AFSQNUMB.pls', FALSE );
945: fnd_message.set_token( 'SQLSTMT', 'select count from GL_SETS_OF_BOOKS where SET_OF_BOOKS_ID = ' || to_char( sob_id ), FALSE );
946: app_exception.raise_exception;
947: return( FND_SEQNUM.ORAFAIL );
948: end; /* SOB block */
949: END IF;