eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FND_SEQNUM dependencies on APP_EXCEPTION

Line 113: app_exception.raise_exception;

109: fnd_message.set_token( 'ROUTINE', 'get_next_auto_seq', FALSE );
110: fnd_message.set_token( 'REASON', sqlerrm, FALSE );
111: fnd_message.set_token( 'ERRFILE', 'AFSQNUMB.pls', FALSE );
112: fnd_message.set_token( 'SQLSTMT', v_proc_stmt, FALSE );
113: app_exception.raise_exception;
114: return( NULL );
115:
116: end get_next_auto_seq;
117:

Line 185: app_exception.raise_exception;

181: exception
182: when NO_DATA_FOUND then
183: fnd_message.set_name('FND', 'GET_NEXT_SEQ_VALUE_ERROR');
184: fnd_message.set_token('SEQUENCE', dbseqnm, FALSE);
185: app_exception.raise_exception;
186:
187: end get_next_auto_sequence;
188:
189: function get_next_auto_sequence (appid in number,

Line 235: app_exception.raise_exception;

231: exception
232: when NO_DATA_FOUND then
233: fnd_message.set_name('FND', 'GET_NEXT_SEQ_VALUE_ERROR');
234: fnd_message.set_token('SEQUENCE', dbseqnm, FALSE);
235: app_exception.raise_exception;
236:
237: end get_next_auto_sequence;
238:
239: procedure create_gapless_sequences

Line 274: app_exception.raise_exception;

270: fnd_message.set_token('ROUTINE', 'create_gapless_sequence', FALSE);
271: fnd_message.set_token('REASON', sqlerrm, FALSE);
272: fnd_message.set_token('ERRFILE', 'AFSQNUMB.pls', FALSE);
273: fnd_message.set_token('SQLSTMT', 'select seq.doc_Sequence_id ...', FALSE);
274: app_exception.raise_exception;
275:
276: end create_gapless_sequences;
277:
278: /* This function creates a row in the fnd_doc_sequence_users

Line 339: app_exception.raise_exception;

335: fnd_message.set_token('ROUTINE', 'create_gapless_sequence( '|| seqid || ' )', FALSE);
336: fnd_message.set_token('REASON', sqlerrm, FALSE);
337: fnd_message.set_token('ERRFILE', 'AFSQNUMB.pls', FALSE);
338: fnd_message.set_token('SQLSTMT', 'insert into fnd_doc_sequence_users ...', FALSE);
339: app_exception.raise_exception;
340: return(0);
341:
342: end create_gapless_sequence;
343:

Line 373: app_exception.raise_exception;

369: exception
370: when no_data_found then
371: fnd_message.set_name( 'FND','SQL-ERROR SELECTING' );
372: fnd_message.set_token( 'TABLENAME', 'FND_DOC_SEQUENCE_USERS' ,FALSE);
373: app_exception.raise_exception;
374: return(0);
375:
376: when others then
377: fnd_message.set_name( 'FND', 'SQL-GENERIC ERROR' );

Line 383: app_exception.raise_exception;

379: fnd_message.set_token( 'ROUTINE', 'get_next_user_sequence', FALSE );
380: fnd_message.set_token( 'REASON', sqlerrm, FALSE );
381: fnd_message.set_token( 'ERRFILE', 'AFSQNUMB.pls', FALSE );
382: fnd_message.set_token( 'SQLSTMT', 'update fnd_doc_sequence_users ... nextval', FALSE );
383: app_exception.raise_exception;
384: return(0);
385: end get_next_user_sequence;
386:
387:

Line 441: app_exception.raise_exception;

437: fnd_message.set_token('SQLSTMT', 'SELECT fou.oracle_username into v_fnd_schema ...', FALSE);
438: ELSE
439: fnd_message.set_token('SQLSTMT', ad_ddl.error_buf, FALSE);
440: END IF;
441: app_exception.raise_exception;
442:
443: end create_db_seq;
444:
445: /*

Line 517: app_exception.raise_exception;

513: return( v_SeqInfoCache.retStat );
514: ELSIF v_profVal <> 'P' AND v_profVal <> 'A' THEN
515: v_SeqInfoCache.retStat := FND_SEQNUM.BADPROF;
516: fnd_message.set_name( 'FND', 'PROFILES-VALUES' ); -- this should never happen, BUT...
517: app_exception.raise_exception;
518: return( v_SeqInfoCache.retStat );
519: END IF; /* v_profVal */
520:
521: /* do our select into the cache */

Line 562: app_exception.raise_exception;

558: IF v_profVal = 'P' THEN
559: v_SeqInfoCache.retStat := FND_SEQNUM.NOASSIGN;
560: IF upper(suppress_warn) = 'N' THEN
561: fnd_message.set_name( 'FND', 'UNIQUE-NO ASSIGNMENT' );
562: app_exception.raise_exception;
563: END IF;
564: ELSIF v_profVal = 'A' THEN
565: v_SeqInfoCache.retStat := FND_SEQNUM.ALWAYS;
566: IF upper(suppress_error) = 'N' THEN

Line 568: app_exception.raise_exception;

564: ELSIF v_profVal = 'A' THEN
565: v_SeqInfoCache.retStat := FND_SEQNUM.ALWAYS;
566: IF upper(suppress_error) = 'N' THEN
567: fnd_message.set_name( 'FND', 'UNIQUE-ALWAYS USED' );
568: app_exception.raise_exception;
569: END IF;
570: END IF;
571: return( v_SeqInfoCache.retStat );
572:

Line 581: app_exception.raise_exception;

577: fnd_message.set_token( 'ROUTINE', 'get_seq_info', FALSE );
578: fnd_message.set_token( 'REASON', sqlerrm, FALSE );
579: fnd_message.set_token( 'ERRFILE', 'AFSQNUMB.pls', FALSE );
580: fnd_message.set_token( 'SQLSTMT', 'select SEQ.DOC_SEQUENCE_ID, SEQ.TYPE, SEQ.NAME ...', FALSE );
581: app_exception.raise_exception;
582: return( v_SeqInfoCache.retStat );
583:
584: end get_seq_info;
585:

Line 611: app_exception.raise_exception;

607:
608: exception
609: when dup_val_on_index then
610: fnd_message.set_name( 'FND', 'UNIQUE-DUPLICATE SEQUENCE' );
611: app_exception.raise_exception;
612: return( FND_SEQNUM.NOTUNIQ );
613: when others then
614: fnd_message.set_name( 'FND', 'SQL-GENERIC ERROR' );
615: fnd_message.set_token( 'ERRNO', sqlcode, FALSE );

Line 620: app_exception.raise_exception;

616: fnd_message.set_token( 'ROUTINE', 'create_audit_rec', FALSE );
617: fnd_message.set_token( 'REASON', sqlerrm, FALSE );
618: fnd_message.set_token( 'ERRFILE', 'AFSQNUMB.pls', FALSE );
619: fnd_message.set_token( 'SQLSTMT', v_proc_stmt, FALSE );
620: app_exception.raise_exception;
621: return( FND_SEQNUM.ORAFAIL );
622:
623: end create_audit_rec;
624:

Line 673: app_exception.raise_exception;

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 );
675: END IF;
676: /* we found a good Doc_Seq assignment so we proceed ...
677: first we check the Seq Type from the FND_DOCUMENT_SEQUENCES.TYPE - valid values are :

Line 690: app_exception.raise_exception;

686: ELSIF v_seqType = 'M' THEN
687: IF seq_val IS NULL THEN
688: fnd_message.set_name( 'FND', 'UNIQUE-NO VALUE' );
689: fnd_message.set_token( 'SEQUENCE', v_seqName, FALSE );
690: app_exception.raise_exception;
691: return( FND_SEQNUM.NOVALUE );
692: END IF;
693: /* i don't actually have a routine to check the uniqueness of the Manual DocSeq
694: like they did in the 'C' code since the very next call from #FND SEQVAL updates

Line 745: app_exception.raise_exception;

741: fnd_message.set_token( 'ROUTINE', 'define_doc_seq', FALSE );
742: fnd_message.set_token( 'REASON', sqlerrm, FALSE );
743: fnd_message.set_token( 'ERRFILE', 'AFSQNUMB.pls', FALSE );
744: fnd_message.set_token( 'SQLSTMT', 'select count from FND_APPLICATION where APPLICATION_ID = ' || to_char(app_id), FALSE );
745: app_exception.raise_exception;
746: return( FND_SEQNUM.ORAFAIL );
747: end; /* APPLICATION_ID check block */
748:
749: begin /* FND_DOCUMENT_SEQUENCES.NAME uniqueness check block */

Line 763: app_exception.raise_exception;

759: fnd_message.set_token( 'ROUTINE', 'define_doc_seq', FALSE );
760: fnd_message.set_token( 'REASON', sqlerrm, FALSE );
761: fnd_message.set_token( 'ERRFILE', 'AFSQNUMB.pls', FALSE );
762: fnd_message.set_token( 'SQLSTMT', 'select count from FND_DOCUMENT_SEQUENCES where NAME = ' || docseq_name, FALSE );
763: app_exception.raise_exception;
764: return( FND_SEQNUM.ORAFAIL );
765: end; /* NAME check block */
766: /* validate the type */
767: -- IF docseq_type NOT IN ( 'A', 'G', 'M', 'U' ) THEN /* we do not do User any more ?? */

Line 800: app_exception.raise_exception;

796: fnd_message.set_token( 'ROUTINE', 'define_doc_seq', FALSE );
797: fnd_message.set_token( 'REASON', sqlerrm, FALSE );
798: fnd_message.set_token( 'ERRFILE', 'AFSQNUMB.pls', FALSE );
799: fnd_message.set_token( 'SQLSTMT', 'select DECODE(' || to_char(app_id) || '...) from dual', FALSE );
800: app_exception.raise_exception;
801: return( FND_SEQNUM.ORAFAIL );
802: end; /* Audit Table name block */
803:
804: /* hopefully we have checked enough to do an insert so lets pop the id sequence */

Line 815: app_exception.raise_exception;

811: fnd_message.set_token( 'ROUTINE', 'define_doc_seq', FALSE );
812: fnd_message.set_token( 'REASON', sqlerrm, FALSE );
813: fnd_message.set_token( 'ERRFILE', 'AFSQNUMB.pls', FALSE );
814: fnd_message.set_token( 'SQLSTMT', 'select FND_DOCUMENT_SEQUENCES_S.nextval from dual', FALSE );
815: app_exception.raise_exception;
816: return( FND_SEQNUM.ORAFAIL );
817: end; /* FND_DOCUMENT_SEQUENCES_S block */
818:
819: IF docseq_type = 'A' THEN

Line 845: app_exception.raise_exception;

841: fnd_message.set_token( 'ROUTINE', 'define_doc_seq', FALSE );
842: fnd_message.set_token( 'REASON', sqlerrm, FALSE );
843: fnd_message.set_token( 'ERRFILE', 'AFSQNUMB.pls', FALSE );
844: fnd_message.set_token( 'SQLSTMT', 'insert into FND_DOCUMENT_SEQUENCES ..' || docseq_name || '...', FALSE );
845: app_exception.raise_exception;
846: return( FND_SEQNUM.ORAFAIL );
847:
848: end define_doc_seq;
849:

Line 888: app_exception.raise_exception;

884: fnd_message.set_token( 'ROUTINE', 'assign_doc_seq', FALSE );
885: fnd_message.set_token( 'REASON', sqlerrm, FALSE );
886: fnd_message.set_token( 'ERRFILE', 'AFSQNUMB.pls', FALSE );
887: fnd_message.set_token( 'SQLSTMT', 'select count from FND_APPLICATION where APPLICATION_ID = ' || to_char(app_id), FALSE );
888: app_exception.raise_exception;
889: return( FND_SEQNUM.ORAFAIL );
890: end; /* APPLICATION_ID check block */
891:
892: begin /* FND_DOCUMENT_SEQUENCES.NAME check block */

Line 905: app_exception.raise_exception;

901: fnd_message.set_token( 'ROUTINE', 'assign_doc_seq', FALSE );
902: fnd_message.set_token( 'REASON', sqlerrm, FALSE );
903: fnd_message.set_token( 'ERRFILE', 'AFSQNUMB.pls', FALSE );
904: fnd_message.set_token( 'SQLSTMT', 'select DOC_SEQUENCE_ID from FND_DOCUMENT_SEQUENCES where NAME = ' || docseq_name, FALSE );
905: app_exception.raise_exception;
906: return( FND_SEQNUM.ORAFAIL );
907: end; /* NAME check block */
908:
909: begin /* get the table name for category_code */

Line 922: app_exception.raise_exception;

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:
926: begin /* check for Set of Books in Document Flexfield */

Line 946: app_exception.raise_exception;

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;
950: exception

Line 958: app_exception.raise_exception;

954: fnd_message.set_token( 'ROUTINE', 'assign_doc_seq', FALSE );
955: fnd_message.set_token( 'REASON', sqlerrm, FALSE );
956: fnd_message.set_token( 'ERRFILE', 'AFSQNUMB.pls', FALSE );
957: fnd_message.set_token( 'SQLSTMT', 'select ENABLED_FLAG from ... SET_OF_BOOKS_ID', FALSE );
958: app_exception.raise_exception;
959: return( FND_SEQNUM.ORAFAIL );
960: end; /* Document Flexfield block */
961:
962: begin /* check for Method Code in Document Flexfield */

Line 980: app_exception.raise_exception;

976: fnd_message.set_token( 'ROUTINE', 'assign_doc_seq', FALSE );
977: fnd_message.set_token( 'REASON', sqlerrm, FALSE );
978: fnd_message.set_token( 'ERRFILE', 'AFSQNUMB.pls', FALSE );
979: fnd_message.set_token( 'SQLSTMT', 'select ENABLED_FLAG from ... METHOD_CODE', FALSE );
980: app_exception.raise_exception;
981: return( FND_SEQNUM.ORAFAIL );
982: end; /* Document Flexfield block */
983:
984: begin /* DATE check - again most of this code in forms so dual maintain */

Line 1001: -- app_exception.raise_exception;

997: IF v_numRows > 0 THEN
998: -- ERROR! there is another row with a null end_date!
999: FND_MESSAGE.SET_NAME('FND','UNIQUE-NULL END DATE');
1000: return( FND_SEQNUM.BADDATE ); /* comment out this line and uncomment the next for debugging */
1001: -- app_exception.raise_exception;
1002: ELSE
1003: -- See if there is another row for this document with dates that overlap
1004: select count( DOC_SEQUENCE_ASSIGNMENT_ID ) into v_numRows
1005: from FND_DOC_SEQUENCE_ASSIGNMENTS

Line 1015: -- app_exception.raise_exception;

1011: IF v_numRows > 0 THEN
1012: -- ERROR! there is a date overlap problem.
1013: FND_MESSAGE.SET_NAME('FND','UNIQUE-DATE OVERLAP');
1014: return( FND_SEQNUM.BADDATE ); /* comment out this line and uncomment the next for debugging */
1015: -- app_exception.raise_exception;
1016: END IF;
1017: END IF;
1018: ELSE
1019: -- see if there is another row in the database for the same document

Line 1041: -- app_exception.raise_exception;

1037: IF v_numRows > 0 THEN
1038: -- ERROR! there is a date overlap problem.
1039: FND_MESSAGE.SET_NAME('FND','UNIQUE-DATE OVERLAP');
1040: return( FND_SEQNUM.BADDATE ); /* comment out this line and uncomment the next for debugging */
1041: -- app_exception.raise_exception;
1042: END IF;
1043: END IF;
1044: END IF;
1045: exception

Line 1053: app_exception.raise_exception;

1049: fnd_message.set_token( 'ROUTINE', 'assign_doc_seq', FALSE );
1050: fnd_message.set_token( 'REASON', sqlerrm, FALSE );
1051: fnd_message.set_token( 'ERRFILE', 'AFSQNUMB.pls', FALSE );
1052: fnd_message.set_token( 'SQLSTMT', 'select count( DOC_SEQUENCE_ASSIGNMENT_ID ) .. DATE checks', FALSE );
1053: app_exception.raise_exception;
1054: return( FND_SEQNUM.ORAFAIL );
1055: end; /* DATE check block */
1056:
1057: /* hopefully we have checked enough to do an insert so lets pop the id sequence */

Line 1068: app_exception.raise_exception;

1064: fnd_message.set_token( 'ROUTINE', 'define_doc_seq', FALSE );
1065: fnd_message.set_token( 'REASON', sqlerrm, FALSE );
1066: fnd_message.set_token( 'ERRFILE', 'AFSQNUMB.pls', FALSE );
1067: fnd_message.set_token( 'SQLSTMT', 'select FND_DOC_SEQUENCE_ASSIGNMENTS_S.nextval from dual', FALSE );
1068: app_exception.raise_exception;
1069: return( FND_SEQNUM.ORAFAIL );
1070: end; /* FND_DOC_SEQUENCE_ASSIGNMENTS_S block */
1071:
1072: insert into FND_DOC_SEQUENCE_ASSIGNMENTS ( DOC_SEQUENCE_ASSIGNMENT_ID, DOC_SEQUENCE_ID,

Line 1090: app_exception.raise_exception;

1086: fnd_message.set_token( 'ROUTINE', 'assign_doc_seq', FALSE );
1087: fnd_message.set_token( 'REASON', sqlerrm, FALSE );
1088: fnd_message.set_token( 'ERRFILE', 'AFSQNUMB.pls', FALSE );
1089: fnd_message.set_token( 'SQLSTMT', 'update FND_DOCUMENT_SEQUENCES set TABLE_NAME (..' || docseq_name || '..)', FALSE );
1090: app_exception.raise_exception;
1091: return( FND_SEQNUM.ORAFAIL );
1092: end; /* Doc_Seq update block */
1093:
1094: IF v_type = 'G' THEN

Line 1112: app_exception.raise_exception;

1108: fnd_message.set_token( 'ROUTINE', 'assign_doc_seq', FALSE );
1109: fnd_message.set_token( 'REASON', sqlerrm, FALSE );
1110: fnd_message.set_token( 'ERRFILE', 'AFSQNUMB.pls', FALSE );
1111: fnd_message.set_token( 'SQLSTMT', 'select count(DOC_SEQUENCE_ID) from FND_DOC_SEQUENCE_USERS', FALSE );
1112: app_exception.raise_exception;
1113: return( FND_SEQNUM.ORAFAIL );
1114: end; /* Gapless check block */
1115: END IF;
1116:

Line 1128: app_exception.raise_exception;

1124: fnd_message.set_token( 'ROUTINE', 'assign_doc_seq', FALSE );
1125: fnd_message.set_token( 'REASON', sqlerrm, FALSE );
1126: fnd_message.set_token( 'ERRFILE', 'AFSQNUMB.pls', FALSE );
1127: fnd_message.set_token( 'SQLSTMT', 'insert into FND_DOC_SEQUENCE_ASSIGNMENTS (..' || docseq_name || '..)', FALSE );
1128: app_exception.raise_exception;
1129: return( FND_SEQNUM.ORAFAIL );
1130:
1131: end assign_doc_seq;
1132: