APPS.FND_SEQNUM dependencies on FND_DOC_SEQUENCE_CATEGORIES

Line 910: select TABLE_NAME into v_prdTabNm from FND_DOC_SEQUENCE_CATEGORIES

906: return( FND_SEQNUM.ORAFAIL );
907: end; /* NAME check block */
908:
909: begin /* get the table name for category_code */
910: select TABLE_NAME into v_prdTabNm from FND_DOC_SEQUENCE_CATEGORIES
911: where CODE = cat_code and APPLICATION_ID = app_id;
912: exception
913: when NO_DATA_FOUND then
914: return( FND_SEQNUM.BADCODE );

Line 921: fnd_message.set_token( 'SQLSTMT', 'select TABLE_NAME from FND_DOC_SEQUENCE_CATEGORIES where CODE = ' || cat_code, FALSE );

917: fnd_message.set_token( 'ERRNO', sqlcode, FALSE );
918: fnd_message.set_token( 'ROUTINE', 'assign_doc_seq', FALSE );
919: fnd_message.set_token( 'REASON', sqlerrm, FALSE );
920: fnd_message.set_token( 'ERRFILE', 'AFSQNUMB.pls', FALSE );
921: fnd_message.set_token( 'SQLSTMT', 'select TABLE_NAME from FND_DOC_SEQUENCE_CATEGORIES where CODE = ' || cat_code, FALSE );
922: app_exception.raise_exception;
923: return( FND_SEQNUM.ORAFAIL );
924: end; /* table name for category_code block */
925: