DBA Data[Home] [Help]

PACKAGE: APPS.APP_EXCEPTION

Source


1 package app_exception AUTHID CURRENT_USER as
2 /* $Header: AFEXCEPS.pls 115.4 2002/12/13 02:33:10 tmorrow ship $ */
3 
4 
5 --
6 -- Package
7 --   app_exception
8 -- Purpose
9 --   Exception handling utilities
10 -- History
11 --   08/09/93	K Brodersen	Created
12 --
13 
14   --
15   -- PUBLIC VARIABLES
16   --
17 
18   -- Exceptions
19   application_exception exception;
20   record_lock_exception exception;
21 
22   -- Exception Pragmas
23   pragma exception_init(application_exception, -20001);
24   pragma exception_init(record_lock_exception,  -0054);
25 
26   --
27   -- PUBLIC FUNCTIONS
28   --
29 
30   --
31   -- Name
32   --   raise_exception
33   -- Purpose
34   --   Stores exception information and raises
35   --   app_exception.application_exception.
36   -- Arguments
37   --   exception_type		Exception type
38   --   exception_code		Exception code
39   --   exception_text		Additional context information
40   --
41   procedure raise_exception(exception_type varchar2 default null,
42                             exception_code number   default null,
43                             exception_text varchar2 default null);
44 
45   --
46   -- Name
47   --   get_exception
48   -- Purpose
49   --   Returns stored exception information.
50   -- Arguments
51   --   exception_type		Retrieved exception type
52   --   exception_code		Retrieved exception code
53   --   exception_text		Retrieved context information
54   --
55   procedure get_exception(exception_type OUT NOCOPY varchar2,
56                           exception_code OUT NOCOPY number,
57                           exception_text OUT NOCOPY varchar2);
58   pragma restrict_references(get_exception, WNDS, WNPS, RNDS);
59 
60   --
61   -- Name
62   --   get_type
63   -- Purpose
64   --   Returns stored exception type.
65   -- Arguments
66   --   *None*
67   --
68   function get_type return varchar2;
69   pragma restrict_references(get_type, WNDS, WNPS, RNDS);
70 
71   --
72   -- Name
73   --   get_code
74   -- Purpose
75   --   Returns stored exception code.
76   -- Arguments
77   --   *None*
78   --
79   function get_code return number;
80   pragma restrict_references(get_code, WNDS, WNPS, RNDS);
81 
82   --
83   -- Name
84   --   get_text
85   -- Purpose
86   --   Returns stored exception text.
87   -- Arguments
88   --   *None*
89   --
90   function get_text return varchar2;
91   pragma restrict_references(get_text, WNDS, WNPS, RNDS);
92 
93   --
94   -- Name
95   --   invalid_argument
96   -- Purpose
97   --   Display invalid argument error message and raise exception
98   -- Arguments
99   --   procname		Name  of procedure
100   --   argument		Name  of argument
101   --   value		Value of argument
102   --
103   procedure invalid_argument(procname varchar2,
104                              argument varchar2,
105                              value    varchar2);
106 
107 end app_exception;