PACKAGE: APPS.MSC_X_USER_EXCEP_GEN

Source

1 PACKAGE MSC_X_USER_EXCEP_GEN AUTHID CURRENT_USER AS
2 /* $Header: MSCUDERS.pls 115.5 2002/11/06 19:28:49 praman ship $ */
3 
4 
5    G_SUCCESS                    CONSTANT NUMBER := 0;
6    G_WARNING                    CONSTANT NUMBER := 1;
7    G_ERROR                      CONSTANT NUMBER := 2;
8 
9 vBatchSize                      INTEGER := 1000;
10 vNotificationSep                VARCHAR2(3) := '@';
11 vPMFLabel                       VARCHAR2(30) := 'GETTHRESHOLD';
12 v_msg_name                      VARCHAR2(30) := 'USEREXCEPTIONNTFMESSAGE';
13 
14 Procedure GenerateException(ERRBUF out nocopy Varchar2,
15                             RETCODE out nocopy number,
16                              pException_Id   In NUMBER,
17                              pFullLoad       In VARCHAR2  default NULL );
18 
19 Procedure ValidateDefinition( pExceptionId   In NUMBER ,
20                               oSqlStmt       OUT NOCOPY VARCHAR2,
21                               oErrorMessage  OUT NOCOPY VARCHAR2,
22                               oErrorPosition OUT NOCOPY NUMBER
23                               ) ;
24 procedure SEND_NTF(p_item_type      IN VARCHAR2,
25                    pItemKey       IN VARCHAR2,
26                    p_actid          IN NUMBER,
27                    p_funcmode       IN VARCHAR2,
28                    p_result         OUT NOCOPY VARCHAR2);
29 
30 procedure setMesgAttribute(
31 command in varchar2,
32 context in varchar2,
33 attr_name in varchar2,
34 attr_type in varchar2,
35 text_value in out nocopy varchar2,
36 number_value in out nocopy number,
37 date_value in out nocopy date);
38 
39 
40 FUNCTION GET_MESSAGE_GROUP(p_exception_group in Number) RETURN Varchar2;
41 Procedure copyException(newExName      IN Varchar2,
42                         newDescription IN Varchar2,
43                         exceptionId    IN Number,
44                         status         OUT NOCOPY NUMBER,
45                         returnMessage  OUT NOCOPY VARCHAR2);
46 Procedure deleteException(exceptionId IN NUMBER,
47                           status      OUT NOCOPY NUMBER,
48                           returnMessage OUT NOCOPY VARCHAR2);
49 
50 Procedure ValidateCalculation(pCalculationString in varchar2,
51                               oErrorMessage  OUT NOCOPY VARCHAR2,
52                               oErrorPosition OUT NOCOPY NUMBER );
53 
54 Procedure  ValidateCondition(pAdvCondition  in varchar2,
55                               oErrorMessage  OUT NOCOPY VARCHAR2,
56                               oErrorPosition OUT NOCOPY NUMBER ) ;
57 
58 Procedure RunCustomExcepWithNetting;
59 
60 END MSC_X_USER_EXCEP_GEN;