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.VEA_EXCEPTIONS_SV dependencies on VEA_EXCEPTIONS

Line 1: PACKAGE BODY VEA_EXCEPTIONS_SV as

1: PACKAGE BODY VEA_EXCEPTIONS_SV as
2: /* $Header: VEAVAEXB.pls 115.4 2003/04/28 17:43:25 heali noship $ */
3: --{
4: /*====================== vea_EXCEPTIONS_sv =========================*/
5: /*========================================================================

Line 4: /====================== vea_EXCEPTIONS_sv =========================/

1: PACKAGE BODY VEA_EXCEPTIONS_SV as
2: /* $Header: VEAVAEXB.pls 115.4 2003/04/28 17:43:25 heali noship $ */
3: --{
4: /*====================== vea_EXCEPTIONS_sv =========================*/
5: /*========================================================================
6: PURPOSE: Table handler package for table VEA_EXCEPTIONS
7:
8: NOTES: To run the script:

Line 6: PURPOSE: Table handler package for table VEA_EXCEPTIONS

2: /* $Header: VEAVAEXB.pls 115.4 2003/04/28 17:43:25 heali noship $ */
3: --{
4: /*====================== vea_EXCEPTIONS_sv =========================*/
5: /*========================================================================
6: PURPOSE: Table handler package for table VEA_EXCEPTIONS
7:
8: NOTES: To run the script:
9:
10: sql> start VEAVAPKB.pls

Line 17: G_PACKAGE_NAME CONSTANT VARCHAR2(30) := 'VEA_EXCEPTIONS_SV';

13: Created BMUNAGAL 04/13/2000
14:
15: =========================================================================*/
16:
17: G_PACKAGE_NAME CONSTANT VARCHAR2(30) := 'VEA_EXCEPTIONS_SV';
18: --
19: --
20: /*========================================================================
21:

Line 24: PURPOSE: Inserts a record into VEA_EXCEPTIONS table

20: /*========================================================================
21:
22: PROCEDURE NAME: insert_row
23:
24: PURPOSE: Inserts a record into VEA_EXCEPTIONS table
25:
26: ========================================================================*/
27: PROCEDURE
28: insert_row

Line 30: p_exception_id IN VEA_EXCEPTIONS.exception_id%TYPE,

26: ========================================================================*/
27: PROCEDURE
28: insert_row
29: (
30: p_exception_id IN VEA_EXCEPTIONS.exception_id%TYPE,
31: p_release_id IN VEA_EXCEPTIONS.release_id%TYPE,
32: p_layer_provider_code IN VEA_EXCEPTIONS.layer_provider_code%TYPE,
33: p_message_name IN VEA_EXCEPTIONS.message_name%TYPE,
34: p_exception_level IN VEA_EXCEPTIONS.exception_level%TYPE,

Line 31: p_release_id IN VEA_EXCEPTIONS.release_id%TYPE,

27: PROCEDURE
28: insert_row
29: (
30: p_exception_id IN VEA_EXCEPTIONS.exception_id%TYPE,
31: p_release_id IN VEA_EXCEPTIONS.release_id%TYPE,
32: p_layer_provider_code IN VEA_EXCEPTIONS.layer_provider_code%TYPE,
33: p_message_name IN VEA_EXCEPTIONS.message_name%TYPE,
34: p_exception_level IN VEA_EXCEPTIONS.exception_level%TYPE,
35: p_message_text IN VEA_EXCEPTIONS.message_text%TYPE,

Line 32: p_layer_provider_code IN VEA_EXCEPTIONS.layer_provider_code%TYPE,

28: insert_row
29: (
30: p_exception_id IN VEA_EXCEPTIONS.exception_id%TYPE,
31: p_release_id IN VEA_EXCEPTIONS.release_id%TYPE,
32: p_layer_provider_code IN VEA_EXCEPTIONS.layer_provider_code%TYPE,
33: p_message_name IN VEA_EXCEPTIONS.message_name%TYPE,
34: p_exception_level IN VEA_EXCEPTIONS.exception_level%TYPE,
35: p_message_text IN VEA_EXCEPTIONS.message_text%TYPE,
36: p_description IN VEA_EXCEPTIONS.description%TYPE

Line 33: p_message_name IN VEA_EXCEPTIONS.message_name%TYPE,

29: (
30: p_exception_id IN VEA_EXCEPTIONS.exception_id%TYPE,
31: p_release_id IN VEA_EXCEPTIONS.release_id%TYPE,
32: p_layer_provider_code IN VEA_EXCEPTIONS.layer_provider_code%TYPE,
33: p_message_name IN VEA_EXCEPTIONS.message_name%TYPE,
34: p_exception_level IN VEA_EXCEPTIONS.exception_level%TYPE,
35: p_message_text IN VEA_EXCEPTIONS.message_text%TYPE,
36: p_description IN VEA_EXCEPTIONS.description%TYPE
37: )

Line 34: p_exception_level IN VEA_EXCEPTIONS.exception_level%TYPE,

30: p_exception_id IN VEA_EXCEPTIONS.exception_id%TYPE,
31: p_release_id IN VEA_EXCEPTIONS.release_id%TYPE,
32: p_layer_provider_code IN VEA_EXCEPTIONS.layer_provider_code%TYPE,
33: p_message_name IN VEA_EXCEPTIONS.message_name%TYPE,
34: p_exception_level IN VEA_EXCEPTIONS.exception_level%TYPE,
35: p_message_text IN VEA_EXCEPTIONS.message_text%TYPE,
36: p_description IN VEA_EXCEPTIONS.description%TYPE
37: )
38: IS

Line 35: p_message_text IN VEA_EXCEPTIONS.message_text%TYPE,

31: p_release_id IN VEA_EXCEPTIONS.release_id%TYPE,
32: p_layer_provider_code IN VEA_EXCEPTIONS.layer_provider_code%TYPE,
33: p_message_name IN VEA_EXCEPTIONS.message_name%TYPE,
34: p_exception_level IN VEA_EXCEPTIONS.exception_level%TYPE,
35: p_message_text IN VEA_EXCEPTIONS.message_text%TYPE,
36: p_description IN VEA_EXCEPTIONS.description%TYPE
37: )
38: IS
39: --{

Line 36: p_description IN VEA_EXCEPTIONS.description%TYPE

32: p_layer_provider_code IN VEA_EXCEPTIONS.layer_provider_code%TYPE,
33: p_message_name IN VEA_EXCEPTIONS.message_name%TYPE,
34: p_exception_level IN VEA_EXCEPTIONS.exception_level%TYPE,
35: p_message_text IN VEA_EXCEPTIONS.message_text%TYPE,
36: p_description IN VEA_EXCEPTIONS.description%TYPE
37: )
38: IS
39: --{
40: l_api_name CONSTANT VARCHAR2(30) := 'insert_row';

Line 51: INSERT INTO vea_EXCEPTIONS

47: BEGIN
48: --{
49: l_location := '0010';
50: --
51: INSERT INTO vea_EXCEPTIONS
52: (
53: exception_id, release_id, layer_provider_code,
54: message_name, exception_level,
55: message_text, description,

Line 90: PURPOSE: Updates a record into VEA_EXCEPTIONS table

86: /*========================================================================
87:
88: PROCEDURE NAME: update_row
89:
90: PURPOSE: Updates a record into VEA_EXCEPTIONS table
91:
92: ========================================================================*/
93: PROCEDURE
94: update_row

Line 96: p_exception_id IN VEA_EXCEPTIONS.exception_id%TYPE,

92: ========================================================================*/
93: PROCEDURE
94: update_row
95: (
96: p_exception_id IN VEA_EXCEPTIONS.exception_id%TYPE,
97: p_release_id IN VEA_EXCEPTIONS.release_id%TYPE,
98: p_layer_provider_code IN VEA_EXCEPTIONS.layer_provider_code%TYPE,
99: p_message_name IN VEA_EXCEPTIONS.message_name%TYPE,
100: p_exception_level IN VEA_EXCEPTIONS.exception_level%TYPE,

Line 97: p_release_id IN VEA_EXCEPTIONS.release_id%TYPE,

93: PROCEDURE
94: update_row
95: (
96: p_exception_id IN VEA_EXCEPTIONS.exception_id%TYPE,
97: p_release_id IN VEA_EXCEPTIONS.release_id%TYPE,
98: p_layer_provider_code IN VEA_EXCEPTIONS.layer_provider_code%TYPE,
99: p_message_name IN VEA_EXCEPTIONS.message_name%TYPE,
100: p_exception_level IN VEA_EXCEPTIONS.exception_level%TYPE,
101: p_message_text IN VEA_EXCEPTIONS.message_text%TYPE,

Line 98: p_layer_provider_code IN VEA_EXCEPTIONS.layer_provider_code%TYPE,

94: update_row
95: (
96: p_exception_id IN VEA_EXCEPTIONS.exception_id%TYPE,
97: p_release_id IN VEA_EXCEPTIONS.release_id%TYPE,
98: p_layer_provider_code IN VEA_EXCEPTIONS.layer_provider_code%TYPE,
99: p_message_name IN VEA_EXCEPTIONS.message_name%TYPE,
100: p_exception_level IN VEA_EXCEPTIONS.exception_level%TYPE,
101: p_message_text IN VEA_EXCEPTIONS.message_text%TYPE,
102: p_description IN VEA_EXCEPTIONS.description%TYPE

Line 99: p_message_name IN VEA_EXCEPTIONS.message_name%TYPE,

95: (
96: p_exception_id IN VEA_EXCEPTIONS.exception_id%TYPE,
97: p_release_id IN VEA_EXCEPTIONS.release_id%TYPE,
98: p_layer_provider_code IN VEA_EXCEPTIONS.layer_provider_code%TYPE,
99: p_message_name IN VEA_EXCEPTIONS.message_name%TYPE,
100: p_exception_level IN VEA_EXCEPTIONS.exception_level%TYPE,
101: p_message_text IN VEA_EXCEPTIONS.message_text%TYPE,
102: p_description IN VEA_EXCEPTIONS.description%TYPE
103: )

Line 100: p_exception_level IN VEA_EXCEPTIONS.exception_level%TYPE,

96: p_exception_id IN VEA_EXCEPTIONS.exception_id%TYPE,
97: p_release_id IN VEA_EXCEPTIONS.release_id%TYPE,
98: p_layer_provider_code IN VEA_EXCEPTIONS.layer_provider_code%TYPE,
99: p_message_name IN VEA_EXCEPTIONS.message_name%TYPE,
100: p_exception_level IN VEA_EXCEPTIONS.exception_level%TYPE,
101: p_message_text IN VEA_EXCEPTIONS.message_text%TYPE,
102: p_description IN VEA_EXCEPTIONS.description%TYPE
103: )
104: IS

Line 101: p_message_text IN VEA_EXCEPTIONS.message_text%TYPE,

97: p_release_id IN VEA_EXCEPTIONS.release_id%TYPE,
98: p_layer_provider_code IN VEA_EXCEPTIONS.layer_provider_code%TYPE,
99: p_message_name IN VEA_EXCEPTIONS.message_name%TYPE,
100: p_exception_level IN VEA_EXCEPTIONS.exception_level%TYPE,
101: p_message_text IN VEA_EXCEPTIONS.message_text%TYPE,
102: p_description IN VEA_EXCEPTIONS.description%TYPE
103: )
104: IS
105: --{

Line 102: p_description IN VEA_EXCEPTIONS.description%TYPE

98: p_layer_provider_code IN VEA_EXCEPTIONS.layer_provider_code%TYPE,
99: p_message_name IN VEA_EXCEPTIONS.message_name%TYPE,
100: p_exception_level IN VEA_EXCEPTIONS.exception_level%TYPE,
101: p_message_text IN VEA_EXCEPTIONS.message_text%TYPE,
102: p_description IN VEA_EXCEPTIONS.description%TYPE
103: )
104: IS
105: --{
106: l_api_name CONSTANT VARCHAR2(30) := 'update_row';

Line 117: UPDATE vea_EXCEPTIONS

113: BEGIN
114: --{
115: l_location := '0010';
116: --
117: UPDATE vea_EXCEPTIONS
118: SET release_id = p_release_id,
119: message_name = p_message_name,
120: exception_level = p_exception_level,
121: message_text = p_message_text,

Line 149: PURPOSE: Table hadndler API for VEA_EXCEPTIONS table.

145: /*========================================================================
146:
147: PROCEDURE NAME: process
148:
149: PURPOSE: Table hadndler API for VEA_EXCEPTIONS table.
150:
151: It inserts/updates a record in VEA_EXCEPTIONS table.
152:
153: ========================================================================*/

Line 151: It inserts/updates a record in VEA_EXCEPTIONS table.

147: PROCEDURE NAME: process
148:
149: PURPOSE: Table hadndler API for VEA_EXCEPTIONS table.
150:
151: It inserts/updates a record in VEA_EXCEPTIONS table.
152:
153: ========================================================================*/
154: PROCEDURE
155: process

Line 164: x_id OUT NOCOPY vea_EXCEPTIONS.exception_id%TYPE,

160: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
161: x_return_status OUT NOCOPY VARCHAR2,
162: x_msg_count OUT NOCOPY NUMBER,
163: x_msg_data OUT NOCOPY VARCHAR2,
164: x_id OUT NOCOPY vea_EXCEPTIONS.exception_id%TYPE,
165: p_release_id IN VEA_EXCEPTIONS.release_id%TYPE,
166: p_layer_provider_code IN VEA_EXCEPTIONS.layer_provider_code%TYPE,
167: p_message_name IN VEA_EXCEPTIONS.message_name%TYPE,
168: p_exception_level IN VEA_EXCEPTIONS.exception_level%TYPE,

Line 165: p_release_id IN VEA_EXCEPTIONS.release_id%TYPE,

161: x_return_status OUT NOCOPY VARCHAR2,
162: x_msg_count OUT NOCOPY NUMBER,
163: x_msg_data OUT NOCOPY VARCHAR2,
164: x_id OUT NOCOPY vea_EXCEPTIONS.exception_id%TYPE,
165: p_release_id IN VEA_EXCEPTIONS.release_id%TYPE,
166: p_layer_provider_code IN VEA_EXCEPTIONS.layer_provider_code%TYPE,
167: p_message_name IN VEA_EXCEPTIONS.message_name%TYPE,
168: p_exception_level IN VEA_EXCEPTIONS.exception_level%TYPE,
169: p_message_text IN VEA_EXCEPTIONS.message_text%TYPE,

Line 166: p_layer_provider_code IN VEA_EXCEPTIONS.layer_provider_code%TYPE,

162: x_msg_count OUT NOCOPY NUMBER,
163: x_msg_data OUT NOCOPY VARCHAR2,
164: x_id OUT NOCOPY vea_EXCEPTIONS.exception_id%TYPE,
165: p_release_id IN VEA_EXCEPTIONS.release_id%TYPE,
166: p_layer_provider_code IN VEA_EXCEPTIONS.layer_provider_code%TYPE,
167: p_message_name IN VEA_EXCEPTIONS.message_name%TYPE,
168: p_exception_level IN VEA_EXCEPTIONS.exception_level%TYPE,
169: p_message_text IN VEA_EXCEPTIONS.message_text%TYPE,
170: p_description IN VEA_EXCEPTIONS.description%TYPE,

Line 167: p_message_name IN VEA_EXCEPTIONS.message_name%TYPE,

163: x_msg_data OUT NOCOPY VARCHAR2,
164: x_id OUT NOCOPY vea_EXCEPTIONS.exception_id%TYPE,
165: p_release_id IN VEA_EXCEPTIONS.release_id%TYPE,
166: p_layer_provider_code IN VEA_EXCEPTIONS.layer_provider_code%TYPE,
167: p_message_name IN VEA_EXCEPTIONS.message_name%TYPE,
168: p_exception_level IN VEA_EXCEPTIONS.exception_level%TYPE,
169: p_message_text IN VEA_EXCEPTIONS.message_text%TYPE,
170: p_description IN VEA_EXCEPTIONS.description%TYPE,
171: p_id IN VEA_EXCEPTIONS.exception_id%TYPE := NULL

Line 168: p_exception_level IN VEA_EXCEPTIONS.exception_level%TYPE,

164: x_id OUT NOCOPY vea_EXCEPTIONS.exception_id%TYPE,
165: p_release_id IN VEA_EXCEPTIONS.release_id%TYPE,
166: p_layer_provider_code IN VEA_EXCEPTIONS.layer_provider_code%TYPE,
167: p_message_name IN VEA_EXCEPTIONS.message_name%TYPE,
168: p_exception_level IN VEA_EXCEPTIONS.exception_level%TYPE,
169: p_message_text IN VEA_EXCEPTIONS.message_text%TYPE,
170: p_description IN VEA_EXCEPTIONS.description%TYPE,
171: p_id IN VEA_EXCEPTIONS.exception_id%TYPE := NULL
172: )

Line 169: p_message_text IN VEA_EXCEPTIONS.message_text%TYPE,

165: p_release_id IN VEA_EXCEPTIONS.release_id%TYPE,
166: p_layer_provider_code IN VEA_EXCEPTIONS.layer_provider_code%TYPE,
167: p_message_name IN VEA_EXCEPTIONS.message_name%TYPE,
168: p_exception_level IN VEA_EXCEPTIONS.exception_level%TYPE,
169: p_message_text IN VEA_EXCEPTIONS.message_text%TYPE,
170: p_description IN VEA_EXCEPTIONS.description%TYPE,
171: p_id IN VEA_EXCEPTIONS.exception_id%TYPE := NULL
172: )
173: IS

Line 170: p_description IN VEA_EXCEPTIONS.description%TYPE,

166: p_layer_provider_code IN VEA_EXCEPTIONS.layer_provider_code%TYPE,
167: p_message_name IN VEA_EXCEPTIONS.message_name%TYPE,
168: p_exception_level IN VEA_EXCEPTIONS.exception_level%TYPE,
169: p_message_text IN VEA_EXCEPTIONS.message_text%TYPE,
170: p_description IN VEA_EXCEPTIONS.description%TYPE,
171: p_id IN VEA_EXCEPTIONS.exception_id%TYPE := NULL
172: )
173: IS
174: --{

Line 171: p_id IN VEA_EXCEPTIONS.exception_id%TYPE := NULL

167: p_message_name IN VEA_EXCEPTIONS.message_name%TYPE,
168: p_exception_level IN VEA_EXCEPTIONS.exception_level%TYPE,
169: p_message_text IN VEA_EXCEPTIONS.message_text%TYPE,
170: p_description IN VEA_EXCEPTIONS.description%TYPE,
171: p_id IN VEA_EXCEPTIONS.exception_id%TYPE := NULL
172: )
173: IS
174: --{
175: l_api_name CONSTANT VARCHAR2(30) := 'process';

Line 226: SELECT NVL( x_id, vea_EXCEPTIONS_s.NEXTVAL )

222: THEN
223: --{
224: l_location := '0070';
225: --
226: SELECT NVL( x_id, vea_EXCEPTIONS_s.NEXTVAL )
227: INTO x_id
228: FROM DUAL;
229: --
230: --

Line 331: END VEA_EXCEPTIONS_SV;

327: --}
328: --}
329: END process;
330: --}
331: END VEA_EXCEPTIONS_SV;