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.OKE_RELATED_ENTITIES_PUB dependencies on OKE_API

Line 9: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,

5:
6:
7: PROCEDURE create_related_entity(
8: p_api_version IN NUMBER,
9: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
10: x_return_status OUT NOCOPY VARCHAR2,
11: x_msg_count OUT NOCOPY NUMBER,
12: x_msg_data OUT NOCOPY VARCHAR2,
13: p_rle_rec IN oke_rle_pvt.rle_rec_type,

Line 21: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;

17: l_rle_rec oke_rle_pvt.rle_rec_type;
18:
19: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_RELATED_ENTITY';
20: l_api_version CONSTANT NUMBER := 1.0;
21: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;
22: l_line_number VARCHAR2(120);
23:
24: BEGIN
25: -- call START_ACTIVITY to create savepoint, check compatibility

Line 27: l_return_status := OKE_API.START_ACTIVITY(

23:
24: BEGIN
25: -- call START_ACTIVITY to create savepoint, check compatibility
26: -- and initialize message list
27: l_return_status := OKE_API.START_ACTIVITY(
28: p_api_name => l_api_name,
29: p_pkg_name => g_pkg_name,
30: p_init_msg_list => p_init_msg_list,
31: l_api_version => l_api_version,

Line 37: If (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then

33: p_api_type => g_api_type,
34: x_return_status => x_return_status);
35:
36: -- check if activity started successfully
37: If (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then
38: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
39: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then
40: raise OKE_API.G_EXCEPTION_ERROR;
41: End If;

Line 38: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

34: x_return_status => x_return_status);
35:
36: -- check if activity started successfully
37: If (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then
38: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
39: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then
40: raise OKE_API.G_EXCEPTION_ERROR;
41: End If;
42:

Line 39: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then

35:
36: -- check if activity started successfully
37: If (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then
38: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
39: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then
40: raise OKE_API.G_EXCEPTION_ERROR;
41: End If;
42:
43: l_rle_rec := p_rle_rec;

Line 40: raise OKE_API.G_EXCEPTION_ERROR;

36: -- check if activity started successfully
37: If (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then
38: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
39: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then
40: raise OKE_API.G_EXCEPTION_ERROR;
41: End If;
42:
43: l_rle_rec := p_rle_rec;
44:

Line 57: If x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR Then

53: p_rle_rec => l_rle_rec,
54: x_rle_rec => x_rle_rec);
55:
56:
57: If x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR Then
58: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
59: Elsif x_return_status = OKE_API.G_RET_STS_ERROR Then
60: raise OKE_API.G_EXCEPTION_ERROR;
61: End If;

Line 58: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

54: x_rle_rec => x_rle_rec);
55:
56:
57: If x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR Then
58: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
59: Elsif x_return_status = OKE_API.G_RET_STS_ERROR Then
60: raise OKE_API.G_EXCEPTION_ERROR;
61: End If;
62:

Line 59: Elsif x_return_status = OKE_API.G_RET_STS_ERROR Then

55:
56:
57: If x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR Then
58: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
59: Elsif x_return_status = OKE_API.G_RET_STS_ERROR Then
60: raise OKE_API.G_EXCEPTION_ERROR;
61: End If;
62:
63: OKE_API.END_ACTIVITY( x_msg_count => x_msg_count,

Line 60: raise OKE_API.G_EXCEPTION_ERROR;

56:
57: If x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR Then
58: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
59: Elsif x_return_status = OKE_API.G_RET_STS_ERROR Then
60: raise OKE_API.G_EXCEPTION_ERROR;
61: End If;
62:
63: OKE_API.END_ACTIVITY( x_msg_count => x_msg_count,
64: x_msg_data => x_msg_data);

Line 63: OKE_API.END_ACTIVITY( x_msg_count => x_msg_count,

59: Elsif x_return_status = OKE_API.G_RET_STS_ERROR Then
60: raise OKE_API.G_EXCEPTION_ERROR;
61: End If;
62:
63: OKE_API.END_ACTIVITY( x_msg_count => x_msg_count,
64: x_msg_data => x_msg_data);
65: EXCEPTION
66: when OKE_API.G_EXCEPTION_ERROR then
67: x_return_status := OKE_API.HANDLE_EXCEPTIONS(

Line 66: when OKE_API.G_EXCEPTION_ERROR then

62:
63: OKE_API.END_ACTIVITY( x_msg_count => x_msg_count,
64: x_msg_data => x_msg_data);
65: EXCEPTION
66: when OKE_API.G_EXCEPTION_ERROR then
67: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
68: p_api_name => l_api_name,
69: p_pkg_name => g_pkg_name,
70: p_exc_name => 'OKE_API.G_RET_STS_ERROR',

Line 67: x_return_status := OKE_API.HANDLE_EXCEPTIONS(

63: OKE_API.END_ACTIVITY( x_msg_count => x_msg_count,
64: x_msg_data => x_msg_data);
65: EXCEPTION
66: when OKE_API.G_EXCEPTION_ERROR then
67: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
68: p_api_name => l_api_name,
69: p_pkg_name => g_pkg_name,
70: p_exc_name => 'OKE_API.G_RET_STS_ERROR',
71: x_msg_count => x_msg_count,

Line 70: p_exc_name => 'OKE_API.G_RET_STS_ERROR',

66: when OKE_API.G_EXCEPTION_ERROR then
67: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
68: p_api_name => l_api_name,
69: p_pkg_name => g_pkg_name,
70: p_exc_name => 'OKE_API.G_RET_STS_ERROR',
71: x_msg_count => x_msg_count,
72: x_msg_data => x_msg_data,
73: p_api_type => g_api_type);
74:

Line 75: when OKE_API.G_EXCEPTION_UNEXPECTED_ERROR then

71: x_msg_count => x_msg_count,
72: x_msg_data => x_msg_data,
73: p_api_type => g_api_type);
74:
75: when OKE_API.G_EXCEPTION_UNEXPECTED_ERROR then
76: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
77: p_api_name => l_api_name,
78: p_pkg_name => g_pkg_name,
79: p_exc_name => 'OKE_API.G_RET_STS_UNEXP_ERROR',

Line 76: x_return_status := OKE_API.HANDLE_EXCEPTIONS(

72: x_msg_data => x_msg_data,
73: p_api_type => g_api_type);
74:
75: when OKE_API.G_EXCEPTION_UNEXPECTED_ERROR then
76: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
77: p_api_name => l_api_name,
78: p_pkg_name => g_pkg_name,
79: p_exc_name => 'OKE_API.G_RET_STS_UNEXP_ERROR',
80: x_msg_count => x_msg_count,

Line 79: p_exc_name => 'OKE_API.G_RET_STS_UNEXP_ERROR',

75: when OKE_API.G_EXCEPTION_UNEXPECTED_ERROR then
76: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
77: p_api_name => l_api_name,
78: p_pkg_name => g_pkg_name,
79: p_exc_name => 'OKE_API.G_RET_STS_UNEXP_ERROR',
80: x_msg_count => x_msg_count,
81: x_msg_data => x_msg_data,
82: p_api_type => g_api_type);
83:

Line 85: x_return_status := OKE_API.HANDLE_EXCEPTIONS(

81: x_msg_data => x_msg_data,
82: p_api_type => g_api_type);
83:
84: when OTHERS then
85: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
86: p_api_name => l_api_name,
87: p_pkg_name => g_pkg_name,
88: p_exc_name => 'OTHERS',
89: x_msg_count => x_msg_count,

Line 99: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,

95:
96:
97: PROCEDURE create_related_entity(
98: p_api_version IN NUMBER,
99: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
100: x_return_status OUT NOCOPY VARCHAR2,
101: x_msg_count OUT NOCOPY NUMBER,
102: x_msg_data OUT NOCOPY VARCHAR2,
103: p_rle_tbl IN oke_rle_pvt.rle_tbl_type,

Line 108: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;

104: x_rle_tbl OUT NOCOPY oke_rle_pvt.rle_tbl_type) IS
105:
106: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_RELATED_ENTITY';
107: l_api_version CONSTANT NUMBER := 1.0;
108: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;
109: l_overall_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;
110: i NUMBER;
111: l_rle_tbl oke_rle_pvt.rle_tbl_type;
112: BEGIN

Line 109: l_overall_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;

105:
106: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_RELATED_ENTITY';
107: l_api_version CONSTANT NUMBER := 1.0;
108: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;
109: l_overall_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;
110: i NUMBER;
111: l_rle_tbl oke_rle_pvt.rle_tbl_type;
112: BEGIN
113: -- call START_ACTIVITY to create savepoint, check compatibility

Line 115: l_return_status := OKE_API.START_ACTIVITY(

111: l_rle_tbl oke_rle_pvt.rle_tbl_type;
112: BEGIN
113: -- call START_ACTIVITY to create savepoint, check compatibility
114: -- and initialize message list
115: l_return_status := OKE_API.START_ACTIVITY(
116: p_api_name => l_api_name,
117: p_pkg_name => g_pkg_name,
118: p_init_msg_list => p_init_msg_list,
119: l_api_version => l_api_version,

Line 125: If (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then

121: p_api_type => g_api_type,
122: x_return_status => x_return_status);
123:
124: -- check if activity started successfully
125: If (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then
126: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
127: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then
128: raise OKE_API.G_EXCEPTION_ERROR;
129: End If;

Line 126: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

122: x_return_status => x_return_status);
123:
124: -- check if activity started successfully
125: If (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then
126: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
127: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then
128: raise OKE_API.G_EXCEPTION_ERROR;
129: End If;
130:

Line 127: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then

123:
124: -- check if activity started successfully
125: If (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then
126: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
127: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then
128: raise OKE_API.G_EXCEPTION_ERROR;
129: End If;
130:
131: OKE_RLE_PVT.Insert_Row(

Line 128: raise OKE_API.G_EXCEPTION_ERROR;

124: -- check if activity started successfully
125: If (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then
126: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
127: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then
128: raise OKE_API.G_EXCEPTION_ERROR;
129: End If;
130:
131: OKE_RLE_PVT.Insert_Row(
132: p_api_version => p_api_version,

Line 141: If x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR Then

137: p_rle_tbl => p_rle_tbl,
138: x_rle_tbl => x_rle_tbl);
139:
140:
141: If x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR Then
142: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
143: Elsif x_return_status = OKE_API.G_RET_STS_ERROR Then
144: raise OKE_API.G_EXCEPTION_ERROR;
145: End If;

Line 142: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

138: x_rle_tbl => x_rle_tbl);
139:
140:
141: If x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR Then
142: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
143: Elsif x_return_status = OKE_API.G_RET_STS_ERROR Then
144: raise OKE_API.G_EXCEPTION_ERROR;
145: End If;
146:

Line 143: Elsif x_return_status = OKE_API.G_RET_STS_ERROR Then

139:
140:
141: If x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR Then
142: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
143: Elsif x_return_status = OKE_API.G_RET_STS_ERROR Then
144: raise OKE_API.G_EXCEPTION_ERROR;
145: End If;
146:
147: OKE_API.END_ACTIVITY( x_msg_count => x_msg_count,

Line 144: raise OKE_API.G_EXCEPTION_ERROR;

140:
141: If x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR Then
142: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
143: Elsif x_return_status = OKE_API.G_RET_STS_ERROR Then
144: raise OKE_API.G_EXCEPTION_ERROR;
145: End If;
146:
147: OKE_API.END_ACTIVITY( x_msg_count => x_msg_count,
148: x_msg_data => x_msg_data);

Line 147: OKE_API.END_ACTIVITY( x_msg_count => x_msg_count,

143: Elsif x_return_status = OKE_API.G_RET_STS_ERROR Then
144: raise OKE_API.G_EXCEPTION_ERROR;
145: End If;
146:
147: OKE_API.END_ACTIVITY( x_msg_count => x_msg_count,
148: x_msg_data => x_msg_data);
149: EXCEPTION
150: when OKE_API.G_EXCEPTION_ERROR then
151: x_return_status := OKE_API.HANDLE_EXCEPTIONS(

Line 150: when OKE_API.G_EXCEPTION_ERROR then

146:
147: OKE_API.END_ACTIVITY( x_msg_count => x_msg_count,
148: x_msg_data => x_msg_data);
149: EXCEPTION
150: when OKE_API.G_EXCEPTION_ERROR then
151: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
152: p_api_name => l_api_name,
153: p_pkg_name => g_pkg_name,
154: p_exc_name => 'OKE_API.G_RET_STS_ERROR',

Line 151: x_return_status := OKE_API.HANDLE_EXCEPTIONS(

147: OKE_API.END_ACTIVITY( x_msg_count => x_msg_count,
148: x_msg_data => x_msg_data);
149: EXCEPTION
150: when OKE_API.G_EXCEPTION_ERROR then
151: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
152: p_api_name => l_api_name,
153: p_pkg_name => g_pkg_name,
154: p_exc_name => 'OKE_API.G_RET_STS_ERROR',
155: x_msg_count => x_msg_count,

Line 154: p_exc_name => 'OKE_API.G_RET_STS_ERROR',

150: when OKE_API.G_EXCEPTION_ERROR then
151: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
152: p_api_name => l_api_name,
153: p_pkg_name => g_pkg_name,
154: p_exc_name => 'OKE_API.G_RET_STS_ERROR',
155: x_msg_count => x_msg_count,
156: x_msg_data => x_msg_data,
157: p_api_type => g_api_type);
158:

Line 159: when OKE_API.G_EXCEPTION_UNEXPECTED_ERROR then

155: x_msg_count => x_msg_count,
156: x_msg_data => x_msg_data,
157: p_api_type => g_api_type);
158:
159: when OKE_API.G_EXCEPTION_UNEXPECTED_ERROR then
160: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
161: p_api_name => l_api_name,
162: p_pkg_name => g_pkg_name,
163: p_exc_name => 'OKE_API.G_RET_STS_UNEXP_ERROR',

Line 160: x_return_status := OKE_API.HANDLE_EXCEPTIONS(

156: x_msg_data => x_msg_data,
157: p_api_type => g_api_type);
158:
159: when OKE_API.G_EXCEPTION_UNEXPECTED_ERROR then
160: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
161: p_api_name => l_api_name,
162: p_pkg_name => g_pkg_name,
163: p_exc_name => 'OKE_API.G_RET_STS_UNEXP_ERROR',
164: x_msg_count => x_msg_count,

Line 163: p_exc_name => 'OKE_API.G_RET_STS_UNEXP_ERROR',

159: when OKE_API.G_EXCEPTION_UNEXPECTED_ERROR then
160: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
161: p_api_name => l_api_name,
162: p_pkg_name => g_pkg_name,
163: p_exc_name => 'OKE_API.G_RET_STS_UNEXP_ERROR',
164: x_msg_count => x_msg_count,
165: x_msg_data => x_msg_data,
166: p_api_type => g_api_type);
167:

Line 169: x_return_status := OKE_API.HANDLE_EXCEPTIONS(

165: x_msg_data => x_msg_data,
166: p_api_type => g_api_type);
167:
168: when OTHERS then
169: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
170: p_api_name => l_api_name,
171: p_pkg_name => g_pkg_name,
172: p_exc_name => 'OTHERS',
173: x_msg_count => x_msg_count,

Line 181: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,

177: END create_related_entity;
178:
179: PROCEDURE update_related_entity(
180: p_api_version IN NUMBER,
181: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
182: x_return_status OUT NOCOPY VARCHAR2,
183: x_msg_count OUT NOCOPY NUMBER,
184: x_msg_data OUT NOCOPY VARCHAR2,
185: p_rle_rec IN oke_rle_pvt.rle_rec_type,

Line 190: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;

186: x_rle_rec OUT NOCOPY oke_rle_pvt.rle_rec_type) IS
187:
188: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_RELATED_ENTITY';
189: l_api_version CONSTANT NUMBER := 1.0;
190: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;
191: BEGIN
192: -- call START_ACTIVITY to create savepoint, check compatibility
193: -- and initialize message list
194:

Line 195: l_return_status := OKE_API.START_ACTIVITY(

191: BEGIN
192: -- call START_ACTIVITY to create savepoint, check compatibility
193: -- and initialize message list
194:
195: l_return_status := OKE_API.START_ACTIVITY(
196: p_api_name => l_api_name,
197: p_pkg_name => g_pkg_name,
198: p_init_msg_list => p_init_msg_list,
199: l_api_version => l_api_version,

Line 205: If (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then

201: p_api_type => g_api_type,
202: x_return_status => x_return_status);
203:
204: -- check if activity started successfully
205: If (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then
206: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
207: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then
208: raise OKE_API.G_EXCEPTION_ERROR;
209: End If;

Line 206: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

202: x_return_status => x_return_status);
203:
204: -- check if activity started successfully
205: If (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then
206: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
207: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then
208: raise OKE_API.G_EXCEPTION_ERROR;
209: End If;
210:

Line 207: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then

203:
204: -- check if activity started successfully
205: If (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then
206: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
207: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then
208: raise OKE_API.G_EXCEPTION_ERROR;
209: End If;
210:
211: -- call complex api

Line 208: raise OKE_API.G_EXCEPTION_ERROR;

204: -- check if activity started successfully
205: If (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then
206: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
207: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then
208: raise OKE_API.G_EXCEPTION_ERROR;
209: End If;
210:
211: -- call complex api
212:

Line 223: If x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR Then

219: p_rle_rec => p_rle_rec,
220: x_rle_rec => x_rle_rec);
221:
222:
223: If x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR Then
224: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
225: Elsif x_return_status = OKE_API.G_RET_STS_ERROR Then
226: raise OKE_API.G_EXCEPTION_ERROR;
227: End If;

Line 224: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

220: x_rle_rec => x_rle_rec);
221:
222:
223: If x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR Then
224: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
225: Elsif x_return_status = OKE_API.G_RET_STS_ERROR Then
226: raise OKE_API.G_EXCEPTION_ERROR;
227: End If;
228:

Line 225: Elsif x_return_status = OKE_API.G_RET_STS_ERROR Then

221:
222:
223: If x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR Then
224: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
225: Elsif x_return_status = OKE_API.G_RET_STS_ERROR Then
226: raise OKE_API.G_EXCEPTION_ERROR;
227: End If;
228:
229: OKE_API.END_ACTIVITY( x_msg_count => x_msg_count,

Line 226: raise OKE_API.G_EXCEPTION_ERROR;

222:
223: If x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR Then
224: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
225: Elsif x_return_status = OKE_API.G_RET_STS_ERROR Then
226: raise OKE_API.G_EXCEPTION_ERROR;
227: End If;
228:
229: OKE_API.END_ACTIVITY( x_msg_count => x_msg_count,
230: x_msg_data => x_msg_data);

Line 229: OKE_API.END_ACTIVITY( x_msg_count => x_msg_count,

225: Elsif x_return_status = OKE_API.G_RET_STS_ERROR Then
226: raise OKE_API.G_EXCEPTION_ERROR;
227: End If;
228:
229: OKE_API.END_ACTIVITY( x_msg_count => x_msg_count,
230: x_msg_data => x_msg_data);
231:
232: EXCEPTION
233: when OKE_API.G_EXCEPTION_ERROR then

Line 233: when OKE_API.G_EXCEPTION_ERROR then

229: OKE_API.END_ACTIVITY( x_msg_count => x_msg_count,
230: x_msg_data => x_msg_data);
231:
232: EXCEPTION
233: when OKE_API.G_EXCEPTION_ERROR then
234: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
235: p_api_name => l_api_name,
236: p_pkg_name => g_pkg_name,
237: p_exc_name => 'OKE_API.G_RET_STS_ERROR',

Line 234: x_return_status := OKE_API.HANDLE_EXCEPTIONS(

230: x_msg_data => x_msg_data);
231:
232: EXCEPTION
233: when OKE_API.G_EXCEPTION_ERROR then
234: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
235: p_api_name => l_api_name,
236: p_pkg_name => g_pkg_name,
237: p_exc_name => 'OKE_API.G_RET_STS_ERROR',
238: x_msg_count => x_msg_count,

Line 237: p_exc_name => 'OKE_API.G_RET_STS_ERROR',

233: when OKE_API.G_EXCEPTION_ERROR then
234: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
235: p_api_name => l_api_name,
236: p_pkg_name => g_pkg_name,
237: p_exc_name => 'OKE_API.G_RET_STS_ERROR',
238: x_msg_count => x_msg_count,
239: x_msg_data => x_msg_data,
240: p_api_type => g_api_type);
241:

Line 242: when OKE_API.G_EXCEPTION_UNEXPECTED_ERROR then

238: x_msg_count => x_msg_count,
239: x_msg_data => x_msg_data,
240: p_api_type => g_api_type);
241:
242: when OKE_API.G_EXCEPTION_UNEXPECTED_ERROR then
243: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
244: p_api_name => l_api_name,
245: p_pkg_name => g_pkg_name,
246: p_exc_name => 'OKE_API.G_RET_STS_UNEXP_ERROR',

Line 243: x_return_status := OKE_API.HANDLE_EXCEPTIONS(

239: x_msg_data => x_msg_data,
240: p_api_type => g_api_type);
241:
242: when OKE_API.G_EXCEPTION_UNEXPECTED_ERROR then
243: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
244: p_api_name => l_api_name,
245: p_pkg_name => g_pkg_name,
246: p_exc_name => 'OKE_API.G_RET_STS_UNEXP_ERROR',
247: x_msg_count => x_msg_count,

Line 246: p_exc_name => 'OKE_API.G_RET_STS_UNEXP_ERROR',

242: when OKE_API.G_EXCEPTION_UNEXPECTED_ERROR then
243: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
244: p_api_name => l_api_name,
245: p_pkg_name => g_pkg_name,
246: p_exc_name => 'OKE_API.G_RET_STS_UNEXP_ERROR',
247: x_msg_count => x_msg_count,
248: x_msg_data => x_msg_data,
249: p_api_type => g_api_type);
250:

Line 252: x_return_status := OKE_API.HANDLE_EXCEPTIONS(

248: x_msg_data => x_msg_data,
249: p_api_type => g_api_type);
250:
251: when OTHERS then
252: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
253: p_api_name => l_api_name,
254: p_pkg_name => g_pkg_name,
255: p_exc_name => 'OTHERS',
256: x_msg_count => x_msg_count,

Line 265: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,

261:
262:
263: PROCEDURE update_related_entity(
264: p_api_version IN NUMBER,
265: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
266: x_return_status OUT NOCOPY VARCHAR2,
267: x_msg_count OUT NOCOPY NUMBER,
268: x_msg_data OUT NOCOPY VARCHAR2,
269: p_rle_tbl IN oke_rle_pvt.rle_tbl_type,

Line 274: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;

270: x_rle_tbl OUT NOCOPY oke_rle_pvt.rle_tbl_type) IS
271:
272: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_RELATED_ENTITY';
273: l_api_version CONSTANT NUMBER := 1.0;
274: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;
275: l_overall_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;
276: i NUMBER;
277: BEGIN
278: -- call START_ACTIVITY to create savepoint, check compatibility

Line 275: l_overall_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;

271:
272: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_RELATED_ENTITY';
273: l_api_version CONSTANT NUMBER := 1.0;
274: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;
275: l_overall_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;
276: i NUMBER;
277: BEGIN
278: -- call START_ACTIVITY to create savepoint, check compatibility
279: -- and initialize message list

Line 281: l_return_status := OKE_API.START_ACTIVITY(

277: BEGIN
278: -- call START_ACTIVITY to create savepoint, check compatibility
279: -- and initialize message list
280:
281: l_return_status := OKE_API.START_ACTIVITY(
282: p_api_name => l_api_name,
283: p_pkg_name => g_pkg_name,
284: p_init_msg_list => p_init_msg_list,
285: l_api_version => l_api_version,

Line 291: If (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then

287: p_api_type => g_api_type,
288: x_return_status => x_return_status);
289:
290: -- check if activity started successfully
291: If (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then
292: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
293: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then
294: raise OKE_API.G_EXCEPTION_ERROR;
295:

Line 292: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

288: x_return_status => x_return_status);
289:
290: -- check if activity started successfully
291: If (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then
292: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
293: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then
294: raise OKE_API.G_EXCEPTION_ERROR;
295:
296: End If;

Line 293: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then

289:
290: -- check if activity started successfully
291: If (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then
292: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
293: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then
294: raise OKE_API.G_EXCEPTION_ERROR;
295:
296: End If;
297:

Line 294: raise OKE_API.G_EXCEPTION_ERROR;

290: -- check if activity started successfully
291: If (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then
292: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
293: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then
294: raise OKE_API.G_EXCEPTION_ERROR;
295:
296: End If;
297:
298: OKE_RLE_PVT.Update_Row(

Line 309: If x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR Then

305: x_rle_tbl => x_rle_tbl);
306:
307:
308:
309: If x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR Then
310: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
311: Elsif x_return_status = OKE_API.G_RET_STS_ERROR Then
312: raise OKE_API.G_EXCEPTION_ERROR;
313: End If;

Line 310: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

306:
307:
308:
309: If x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR Then
310: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
311: Elsif x_return_status = OKE_API.G_RET_STS_ERROR Then
312: raise OKE_API.G_EXCEPTION_ERROR;
313: End If;
314:

Line 311: Elsif x_return_status = OKE_API.G_RET_STS_ERROR Then

307:
308:
309: If x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR Then
310: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
311: Elsif x_return_status = OKE_API.G_RET_STS_ERROR Then
312: raise OKE_API.G_EXCEPTION_ERROR;
313: End If;
314:
315: OKE_API.END_ACTIVITY( x_msg_count => x_msg_count,

Line 312: raise OKE_API.G_EXCEPTION_ERROR;

308:
309: If x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR Then
310: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
311: Elsif x_return_status = OKE_API.G_RET_STS_ERROR Then
312: raise OKE_API.G_EXCEPTION_ERROR;
313: End If;
314:
315: OKE_API.END_ACTIVITY( x_msg_count => x_msg_count,
316: x_msg_data => x_msg_data);

Line 315: OKE_API.END_ACTIVITY( x_msg_count => x_msg_count,

311: Elsif x_return_status = OKE_API.G_RET_STS_ERROR Then
312: raise OKE_API.G_EXCEPTION_ERROR;
313: End If;
314:
315: OKE_API.END_ACTIVITY( x_msg_count => x_msg_count,
316: x_msg_data => x_msg_data);
317:
318: EXCEPTION
319: when OKE_API.G_EXCEPTION_ERROR then

Line 319: when OKE_API.G_EXCEPTION_ERROR then

315: OKE_API.END_ACTIVITY( x_msg_count => x_msg_count,
316: x_msg_data => x_msg_data);
317:
318: EXCEPTION
319: when OKE_API.G_EXCEPTION_ERROR then
320: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
321: p_api_name => l_api_name,
322: p_pkg_name => g_pkg_name,
323: p_exc_name => 'OKE_API.G_RET_STS_ERROR',

Line 320: x_return_status := OKE_API.HANDLE_EXCEPTIONS(

316: x_msg_data => x_msg_data);
317:
318: EXCEPTION
319: when OKE_API.G_EXCEPTION_ERROR then
320: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
321: p_api_name => l_api_name,
322: p_pkg_name => g_pkg_name,
323: p_exc_name => 'OKE_API.G_RET_STS_ERROR',
324: x_msg_count => x_msg_count,

Line 323: p_exc_name => 'OKE_API.G_RET_STS_ERROR',

319: when OKE_API.G_EXCEPTION_ERROR then
320: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
321: p_api_name => l_api_name,
322: p_pkg_name => g_pkg_name,
323: p_exc_name => 'OKE_API.G_RET_STS_ERROR',
324: x_msg_count => x_msg_count,
325: x_msg_data => x_msg_data,
326: p_api_type => g_api_type);
327:

Line 328: when OKE_API.G_EXCEPTION_UNEXPECTED_ERROR then

324: x_msg_count => x_msg_count,
325: x_msg_data => x_msg_data,
326: p_api_type => g_api_type);
327:
328: when OKE_API.G_EXCEPTION_UNEXPECTED_ERROR then
329: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
330: p_api_name => l_api_name,
331: p_pkg_name => g_pkg_name,
332: p_exc_name => 'OKE_API.G_RET_STS_UNEXP_ERROR',

Line 329: x_return_status := OKE_API.HANDLE_EXCEPTIONS(

325: x_msg_data => x_msg_data,
326: p_api_type => g_api_type);
327:
328: when OKE_API.G_EXCEPTION_UNEXPECTED_ERROR then
329: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
330: p_api_name => l_api_name,
331: p_pkg_name => g_pkg_name,
332: p_exc_name => 'OKE_API.G_RET_STS_UNEXP_ERROR',
333: x_msg_count => x_msg_count,

Line 332: p_exc_name => 'OKE_API.G_RET_STS_UNEXP_ERROR',

328: when OKE_API.G_EXCEPTION_UNEXPECTED_ERROR then
329: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
330: p_api_name => l_api_name,
331: p_pkg_name => g_pkg_name,
332: p_exc_name => 'OKE_API.G_RET_STS_UNEXP_ERROR',
333: x_msg_count => x_msg_count,
334: x_msg_data => x_msg_data,
335: p_api_type => g_api_type);
336:

Line 338: x_return_status := OKE_API.HANDLE_EXCEPTIONS(

334: x_msg_data => x_msg_data,
335: p_api_type => g_api_type);
336:
337: when OTHERS then
338: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
339: p_api_name => l_api_name,
340: p_pkg_name => g_pkg_name,
341: p_exc_name => 'OTHERS',
342: x_msg_count => x_msg_count,

Line 352: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,

348:
349:
350: PROCEDURE validate_related_entity(
351: p_api_version IN NUMBER,
352: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
353: x_return_status OUT NOCOPY VARCHAR2,
354: x_msg_count OUT NOCOPY NUMBER,
355: x_msg_data OUT NOCOPY VARCHAR2,
356: p_rle_rec IN oke_rle_pvt.rle_rec_type) IS

Line 361: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;

357:
358: l_rle_rec oke_rle_pvt.rle_rec_type;
359: l_api_name CONSTANT VARCHAR2(30) := 'VALIDATE_RELATED_ENTITY';
360: l_api_version CONSTANT NUMBER := 1.0;
361: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;
362:
363: BEGIN
364: -- call START_ACTIVITY to create savepoint, check compatibility
365: -- and initialize message list

Line 366: l_return_status := OKE_API.START_ACTIVITY(

362:
363: BEGIN
364: -- call START_ACTIVITY to create savepoint, check compatibility
365: -- and initialize message list
366: l_return_status := OKE_API.START_ACTIVITY(
367: p_api_name => l_api_name,
368: p_pkg_name => g_pkg_name,
369: p_init_msg_list => p_init_msg_list,
370: l_api_version => l_api_version,

Line 376: If (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then

372: p_api_type => g_api_type,
373: x_return_status => x_return_status);
374:
375: -- check if activity started successfully
376: If (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then
377: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
378: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then
379: raise OKE_API.G_EXCEPTION_ERROR;
380: End If;

Line 377: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

373: x_return_status => x_return_status);
374:
375: -- check if activity started successfully
376: If (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then
377: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
378: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then
379: raise OKE_API.G_EXCEPTION_ERROR;
380: End If;
381:

Line 378: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then

374:
375: -- check if activity started successfully
376: If (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then
377: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
378: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then
379: raise OKE_API.G_EXCEPTION_ERROR;
380: End If;
381:
382: -- call BEFORE user hook

Line 379: raise OKE_API.G_EXCEPTION_ERROR;

375: -- check if activity started successfully
376: If (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then
377: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
378: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then
379: raise OKE_API.G_EXCEPTION_ERROR;
380: End If;
381:
382: -- call BEFORE user hook
383: l_rle_rec := p_rle_rec;

Line 396: If x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR Then

392: x_msg_data => x_msg_data,
393: p_rle_rec => p_rle_rec);
394:
395:
396: If x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR Then
397: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
398: Elsif x_return_status = OKE_API.G_RET_STS_ERROR Then
399: raise OKE_API.G_EXCEPTION_ERROR;
400: End If;

Line 397: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

393: p_rle_rec => p_rle_rec);
394:
395:
396: If x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR Then
397: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
398: Elsif x_return_status = OKE_API.G_RET_STS_ERROR Then
399: raise OKE_API.G_EXCEPTION_ERROR;
400: End If;
401:

Line 398: Elsif x_return_status = OKE_API.G_RET_STS_ERROR Then

394:
395:
396: If x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR Then
397: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
398: Elsif x_return_status = OKE_API.G_RET_STS_ERROR Then
399: raise OKE_API.G_EXCEPTION_ERROR;
400: End If;
401:
402: -- end activity

Line 399: raise OKE_API.G_EXCEPTION_ERROR;

395:
396: If x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR Then
397: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
398: Elsif x_return_status = OKE_API.G_RET_STS_ERROR Then
399: raise OKE_API.G_EXCEPTION_ERROR;
400: End If;
401:
402: -- end activity
403: OKE_API.END_ACTIVITY( x_msg_count => x_msg_count,

Line 403: OKE_API.END_ACTIVITY( x_msg_count => x_msg_count,

399: raise OKE_API.G_EXCEPTION_ERROR;
400: End If;
401:
402: -- end activity
403: OKE_API.END_ACTIVITY( x_msg_count => x_msg_count,
404: x_msg_data => x_msg_data);
405: EXCEPTION
406: when OKE_API.G_EXCEPTION_ERROR then
407: x_return_status := OKE_API.HANDLE_EXCEPTIONS(

Line 406: when OKE_API.G_EXCEPTION_ERROR then

402: -- end activity
403: OKE_API.END_ACTIVITY( x_msg_count => x_msg_count,
404: x_msg_data => x_msg_data);
405: EXCEPTION
406: when OKE_API.G_EXCEPTION_ERROR then
407: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
408: p_api_name => l_api_name,
409: p_pkg_name => g_pkg_name,
410: p_exc_name => 'OKE_API.G_RET_STS_ERROR',

Line 407: x_return_status := OKE_API.HANDLE_EXCEPTIONS(

403: OKE_API.END_ACTIVITY( x_msg_count => x_msg_count,
404: x_msg_data => x_msg_data);
405: EXCEPTION
406: when OKE_API.G_EXCEPTION_ERROR then
407: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
408: p_api_name => l_api_name,
409: p_pkg_name => g_pkg_name,
410: p_exc_name => 'OKE_API.G_RET_STS_ERROR',
411: x_msg_count => x_msg_count,

Line 410: p_exc_name => 'OKE_API.G_RET_STS_ERROR',

406: when OKE_API.G_EXCEPTION_ERROR then
407: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
408: p_api_name => l_api_name,
409: p_pkg_name => g_pkg_name,
410: p_exc_name => 'OKE_API.G_RET_STS_ERROR',
411: x_msg_count => x_msg_count,
412: x_msg_data => x_msg_data,
413: p_api_type => g_api_type);
414:

Line 415: when OKE_API.G_EXCEPTION_UNEXPECTED_ERROR then

411: x_msg_count => x_msg_count,
412: x_msg_data => x_msg_data,
413: p_api_type => g_api_type);
414:
415: when OKE_API.G_EXCEPTION_UNEXPECTED_ERROR then
416: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
417: p_api_name => l_api_name,
418: p_pkg_name => g_pkg_name,
419: p_exc_name => 'OKE_API.G_RET_STS_UNEXP_ERROR',

Line 416: x_return_status := OKE_API.HANDLE_EXCEPTIONS(

412: x_msg_data => x_msg_data,
413: p_api_type => g_api_type);
414:
415: when OKE_API.G_EXCEPTION_UNEXPECTED_ERROR then
416: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
417: p_api_name => l_api_name,
418: p_pkg_name => g_pkg_name,
419: p_exc_name => 'OKE_API.G_RET_STS_UNEXP_ERROR',
420: x_msg_count => x_msg_count,

Line 419: p_exc_name => 'OKE_API.G_RET_STS_UNEXP_ERROR',

415: when OKE_API.G_EXCEPTION_UNEXPECTED_ERROR then
416: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
417: p_api_name => l_api_name,
418: p_pkg_name => g_pkg_name,
419: p_exc_name => 'OKE_API.G_RET_STS_UNEXP_ERROR',
420: x_msg_count => x_msg_count,
421: x_msg_data => x_msg_data,
422: p_api_type => g_api_type);
423:

Line 425: x_return_status := OKE_API.HANDLE_EXCEPTIONS(

421: x_msg_data => x_msg_data,
422: p_api_type => g_api_type);
423:
424: when OTHERS then
425: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
426: p_api_name => l_api_name,
427: p_pkg_name => g_pkg_name,
428: p_exc_name => 'OTHERS',
429: x_msg_count => x_msg_count,

Line 437: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,

433: END validate_related_entity;
434:
435: PROCEDURE validate_related_entity(
436: p_api_version IN NUMBER,
437: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
438: x_return_status OUT NOCOPY VARCHAR2,
439: x_msg_count OUT NOCOPY NUMBER,
440: x_msg_data OUT NOCOPY VARCHAR2,
441: p_rle_tbl IN oke_rle_pvt.rle_tbl_type) IS

Line 446: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;

442:
443: l_api_name CONSTANT VARCHAR2(30) := 'VALIDATE_RELATED_ENTITY';
444:
445: l_api_version CONSTANT NUMBER := 1.0;
446: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;
447: l_overall_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;
448: i NUMBER;
449: l_rle_tbl oke_rle_pvt.rle_tbl_type := p_rle_tbl;
450: BEGIN

Line 447: l_overall_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;

443: l_api_name CONSTANT VARCHAR2(30) := 'VALIDATE_RELATED_ENTITY';
444:
445: l_api_version CONSTANT NUMBER := 1.0;
446: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;
447: l_overall_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;
448: i NUMBER;
449: l_rle_tbl oke_rle_pvt.rle_tbl_type := p_rle_tbl;
450: BEGIN
451: -- call START_ACTIVITY to create savepoint, check compatibility

Line 453: l_return_status := OKE_API.START_ACTIVITY(

449: l_rle_tbl oke_rle_pvt.rle_tbl_type := p_rle_tbl;
450: BEGIN
451: -- call START_ACTIVITY to create savepoint, check compatibility
452: -- and initialize message list
453: l_return_status := OKE_API.START_ACTIVITY(
454: p_api_name => l_api_name,
455: p_pkg_name => g_pkg_name,
456: p_init_msg_list => p_init_msg_list,
457: l_api_version => l_api_version,

Line 463: If (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then

459: p_api_type => g_api_type,
460: x_return_status => x_return_status);
461:
462: -- check if activity started successfully
463: If (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then
464: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
465: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then
466: raise OKE_API.G_EXCEPTION_ERROR;
467: End If;

Line 464: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

460: x_return_status => x_return_status);
461:
462: -- check if activity started successfully
463: If (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then
464: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
465: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then
466: raise OKE_API.G_EXCEPTION_ERROR;
467: End If;
468:

Line 465: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then

461:
462: -- check if activity started successfully
463: If (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then
464: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
465: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then
466: raise OKE_API.G_EXCEPTION_ERROR;
467: End If;
468:
469:

Line 466: raise OKE_API.G_EXCEPTION_ERROR;

462: -- check if activity started successfully
463: If (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then
464: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
465: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then
466: raise OKE_API.G_EXCEPTION_ERROR;
467: End If;
468:
469:
470: OKE_RLE_PVT.Validate_Row(

Line 479: If x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR Then

475: x_msg_data => x_msg_data,
476: p_rle_tbl => p_rle_tbl);
477:
478:
479: If x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR Then
480: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
481: Elsif x_return_status = OKE_API.G_RET_STS_ERROR Then
482: raise OKE_API.G_EXCEPTION_ERROR;
483: End If;

Line 480: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

476: p_rle_tbl => p_rle_tbl);
477:
478:
479: If x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR Then
480: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
481: Elsif x_return_status = OKE_API.G_RET_STS_ERROR Then
482: raise OKE_API.G_EXCEPTION_ERROR;
483: End If;
484:

Line 481: Elsif x_return_status = OKE_API.G_RET_STS_ERROR Then

477:
478:
479: If x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR Then
480: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
481: Elsif x_return_status = OKE_API.G_RET_STS_ERROR Then
482: raise OKE_API.G_EXCEPTION_ERROR;
483: End If;
484:
485: -- end activity

Line 482: raise OKE_API.G_EXCEPTION_ERROR;

478:
479: If x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR Then
480: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
481: Elsif x_return_status = OKE_API.G_RET_STS_ERROR Then
482: raise OKE_API.G_EXCEPTION_ERROR;
483: End If;
484:
485: -- end activity
486: OKE_API.END_ACTIVITY( x_msg_count => x_msg_count,

Line 486: OKE_API.END_ACTIVITY( x_msg_count => x_msg_count,

482: raise OKE_API.G_EXCEPTION_ERROR;
483: End If;
484:
485: -- end activity
486: OKE_API.END_ACTIVITY( x_msg_count => x_msg_count,
487: x_msg_data => x_msg_data);
488: EXCEPTION
489: when OKE_API.G_EXCEPTION_ERROR then
490: x_return_status := OKE_API.HANDLE_EXCEPTIONS(

Line 489: when OKE_API.G_EXCEPTION_ERROR then

485: -- end activity
486: OKE_API.END_ACTIVITY( x_msg_count => x_msg_count,
487: x_msg_data => x_msg_data);
488: EXCEPTION
489: when OKE_API.G_EXCEPTION_ERROR then
490: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
491: p_api_name => l_api_name,
492: p_pkg_name => g_pkg_name,
493: p_exc_name => 'OKE_API.G_RET_STS_ERROR',

Line 490: x_return_status := OKE_API.HANDLE_EXCEPTIONS(

486: OKE_API.END_ACTIVITY( x_msg_count => x_msg_count,
487: x_msg_data => x_msg_data);
488: EXCEPTION
489: when OKE_API.G_EXCEPTION_ERROR then
490: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
491: p_api_name => l_api_name,
492: p_pkg_name => g_pkg_name,
493: p_exc_name => 'OKE_API.G_RET_STS_ERROR',
494: x_msg_count => x_msg_count,

Line 493: p_exc_name => 'OKE_API.G_RET_STS_ERROR',

489: when OKE_API.G_EXCEPTION_ERROR then
490: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
491: p_api_name => l_api_name,
492: p_pkg_name => g_pkg_name,
493: p_exc_name => 'OKE_API.G_RET_STS_ERROR',
494: x_msg_count => x_msg_count,
495: x_msg_data => x_msg_data,
496: p_api_type => g_api_type);
497:

Line 498: when OKE_API.G_EXCEPTION_UNEXPECTED_ERROR then

494: x_msg_count => x_msg_count,
495: x_msg_data => x_msg_data,
496: p_api_type => g_api_type);
497:
498: when OKE_API.G_EXCEPTION_UNEXPECTED_ERROR then
499: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
500: p_api_name => l_api_name,
501: p_pkg_name => g_pkg_name,
502: p_exc_name => 'OKE_API.G_RET_STS_UNEXP_ERROR',

Line 499: x_return_status := OKE_API.HANDLE_EXCEPTIONS(

495: x_msg_data => x_msg_data,
496: p_api_type => g_api_type);
497:
498: when OKE_API.G_EXCEPTION_UNEXPECTED_ERROR then
499: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
500: p_api_name => l_api_name,
501: p_pkg_name => g_pkg_name,
502: p_exc_name => 'OKE_API.G_RET_STS_UNEXP_ERROR',
503: x_msg_count => x_msg_count,

Line 502: p_exc_name => 'OKE_API.G_RET_STS_UNEXP_ERROR',

498: when OKE_API.G_EXCEPTION_UNEXPECTED_ERROR then
499: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
500: p_api_name => l_api_name,
501: p_pkg_name => g_pkg_name,
502: p_exc_name => 'OKE_API.G_RET_STS_UNEXP_ERROR',
503: x_msg_count => x_msg_count,
504: x_msg_data => x_msg_data,
505: p_api_type => g_api_type);
506:

Line 508: x_return_status := OKE_API.HANDLE_EXCEPTIONS(

504: x_msg_data => x_msg_data,
505: p_api_type => g_api_type);
506:
507: when OTHERS then
508: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
509: p_api_name => l_api_name,
510: p_pkg_name => g_pkg_name,
511: p_exc_name => 'OTHERS',
512: x_msg_count => x_msg_count,

Line 524: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,

520:
521: PROCEDURE delete_related_entity(
522:
523: p_api_version IN NUMBER,
524: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
525: x_return_status OUT NOCOPY VARCHAR2,
526: x_msg_count OUT NOCOPY NUMBER,
527: x_msg_data OUT NOCOPY VARCHAR2,
528: p_rle_rec IN oke_rle_pvt.rle_rec_type) IS

Line 533: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;

529:
530: l_rle_rec oke_rle_pvt.rle_rec_type;
531: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_RELATED_ENTITY';
532: l_api_version CONSTANT NUMBER := 1.0;
533: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;
534: BEGIN
535: -- call START_ACTIVITY to create savepoint, check compatibility
536: -- and initialize message list
537: l_return_status := OKE_API.START_ACTIVITY(

Line 537: l_return_status := OKE_API.START_ACTIVITY(

533: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;
534: BEGIN
535: -- call START_ACTIVITY to create savepoint, check compatibility
536: -- and initialize message list
537: l_return_status := OKE_API.START_ACTIVITY(
538: p_api_name => l_api_name,
539: p_pkg_name => g_pkg_name,
540: p_init_msg_list => p_init_msg_list,
541: l_api_version => l_api_version,

Line 547: If (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then

543: p_api_type => g_api_type,
544: x_return_status => x_return_status);
545:
546: -- check if activity started successfully
547: If (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then
548: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
549: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then
550: raise OKE_API.G_EXCEPTION_ERROR;
551: End If;

Line 548: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

544: x_return_status => x_return_status);
545:
546: -- check if activity started successfully
547: If (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then
548: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
549: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then
550: raise OKE_API.G_EXCEPTION_ERROR;
551: End If;
552:

Line 549: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then

545:
546: -- check if activity started successfully
547: If (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then
548: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
549: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then
550: raise OKE_API.G_EXCEPTION_ERROR;
551: End If;
552:
553: l_rle_rec := p_rle_rec;

Line 550: raise OKE_API.G_EXCEPTION_ERROR;

546: -- check if activity started successfully
547: If (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then
548: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
549: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then
550: raise OKE_API.G_EXCEPTION_ERROR;
551: End If;
552:
553: l_rle_rec := p_rle_rec;
554:

Line 566: If x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR Then

562: x_msg_data => x_msg_data,
563: p_rle_rec => p_rle_rec);
564:
565:
566: If x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR Then
567: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
568: Elsif x_return_status = OKE_API.G_RET_STS_ERROR Then
569: raise OKE_API.G_EXCEPTION_ERROR;
570: End If;

Line 567: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

563: p_rle_rec => p_rle_rec);
564:
565:
566: If x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR Then
567: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
568: Elsif x_return_status = OKE_API.G_RET_STS_ERROR Then
569: raise OKE_API.G_EXCEPTION_ERROR;
570: End If;
571:

Line 568: Elsif x_return_status = OKE_API.G_RET_STS_ERROR Then

564:
565:
566: If x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR Then
567: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
568: Elsif x_return_status = OKE_API.G_RET_STS_ERROR Then
569: raise OKE_API.G_EXCEPTION_ERROR;
570: End If;
571:
572:

Line 569: raise OKE_API.G_EXCEPTION_ERROR;

565:
566: If x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR Then
567: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
568: Elsif x_return_status = OKE_API.G_RET_STS_ERROR Then
569: raise OKE_API.G_EXCEPTION_ERROR;
570: End If;
571:
572:
573: OKE_API.END_ACTIVITY( x_msg_count => x_msg_count,

Line 573: OKE_API.END_ACTIVITY( x_msg_count => x_msg_count,

569: raise OKE_API.G_EXCEPTION_ERROR;
570: End If;
571:
572:
573: OKE_API.END_ACTIVITY( x_msg_count => x_msg_count,
574: x_msg_data => x_msg_data);
575: EXCEPTION
576: when OKE_API.G_EXCEPTION_ERROR then
577: x_return_status := OKE_API.HANDLE_EXCEPTIONS(

Line 576: when OKE_API.G_EXCEPTION_ERROR then

572:
573: OKE_API.END_ACTIVITY( x_msg_count => x_msg_count,
574: x_msg_data => x_msg_data);
575: EXCEPTION
576: when OKE_API.G_EXCEPTION_ERROR then
577: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
578: p_api_name => l_api_name,
579: p_pkg_name => g_pkg_name,
580: p_exc_name => 'OKE_API.G_RET_STS_ERROR',

Line 577: x_return_status := OKE_API.HANDLE_EXCEPTIONS(

573: OKE_API.END_ACTIVITY( x_msg_count => x_msg_count,
574: x_msg_data => x_msg_data);
575: EXCEPTION
576: when OKE_API.G_EXCEPTION_ERROR then
577: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
578: p_api_name => l_api_name,
579: p_pkg_name => g_pkg_name,
580: p_exc_name => 'OKE_API.G_RET_STS_ERROR',
581: x_msg_count => x_msg_count,

Line 580: p_exc_name => 'OKE_API.G_RET_STS_ERROR',

576: when OKE_API.G_EXCEPTION_ERROR then
577: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
578: p_api_name => l_api_name,
579: p_pkg_name => g_pkg_name,
580: p_exc_name => 'OKE_API.G_RET_STS_ERROR',
581: x_msg_count => x_msg_count,
582: x_msg_data => x_msg_data,
583: p_api_type => g_api_type);
584:

Line 585: when OKE_API.G_EXCEPTION_UNEXPECTED_ERROR then

581: x_msg_count => x_msg_count,
582: x_msg_data => x_msg_data,
583: p_api_type => g_api_type);
584:
585: when OKE_API.G_EXCEPTION_UNEXPECTED_ERROR then
586: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
587: p_api_name => l_api_name,
588: p_pkg_name => g_pkg_name,
589: p_exc_name => 'OKE_API.G_RET_STS_UNEXP_ERROR',

Line 586: x_return_status := OKE_API.HANDLE_EXCEPTIONS(

582: x_msg_data => x_msg_data,
583: p_api_type => g_api_type);
584:
585: when OKE_API.G_EXCEPTION_UNEXPECTED_ERROR then
586: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
587: p_api_name => l_api_name,
588: p_pkg_name => g_pkg_name,
589: p_exc_name => 'OKE_API.G_RET_STS_UNEXP_ERROR',
590: x_msg_count => x_msg_count,

Line 589: p_exc_name => 'OKE_API.G_RET_STS_UNEXP_ERROR',

585: when OKE_API.G_EXCEPTION_UNEXPECTED_ERROR then
586: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
587: p_api_name => l_api_name,
588: p_pkg_name => g_pkg_name,
589: p_exc_name => 'OKE_API.G_RET_STS_UNEXP_ERROR',
590: x_msg_count => x_msg_count,
591: x_msg_data => x_msg_data,
592: p_api_type => g_api_type);
593:

Line 595: x_return_status := OKE_API.HANDLE_EXCEPTIONS(

591: x_msg_data => x_msg_data,
592: p_api_type => g_api_type);
593:
594: when OTHERS then
595: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
596: p_api_name => l_api_name,
597: p_pkg_name => g_pkg_name,
598: p_exc_name => 'OTHERS',
599: x_msg_count => x_msg_count,

Line 608: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,

604:
605:
606: PROCEDURE delete_related_entity(
607: p_api_version IN NUMBER,
608: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
609: x_return_status OUT NOCOPY VARCHAR2,
610: x_msg_count OUT NOCOPY NUMBER,
611: x_msg_data OUT NOCOPY VARCHAR2,
612: p_rle_tbl IN oke_rle_pvt.rle_tbl_type) IS

Line 616: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;

612: p_rle_tbl IN oke_rle_pvt.rle_tbl_type) IS
613:
614: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_RELATED_ENTITY';
615: l_api_version CONSTANT NUMBER := 1.0;
616: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;
617: l_overall_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;
618: i NUMBER;
619: BEGIN
620: -- call START_ACTIVITY to create savepoint, check compatibility

Line 617: l_overall_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;

613:
614: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_RELATED_ENTITY';
615: l_api_version CONSTANT NUMBER := 1.0;
616: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;
617: l_overall_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;
618: i NUMBER;
619: BEGIN
620: -- call START_ACTIVITY to create savepoint, check compatibility
621: -- and initialize message list

Line 622: l_return_status := OKE_API.START_ACTIVITY(

618: i NUMBER;
619: BEGIN
620: -- call START_ACTIVITY to create savepoint, check compatibility
621: -- and initialize message list
622: l_return_status := OKE_API.START_ACTIVITY(
623: p_api_name => l_api_name,
624: p_pkg_name => g_pkg_name,
625: p_init_msg_list => p_init_msg_list,
626: l_api_version => l_api_version,

Line 632: If (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then

628: p_api_type => g_api_type,
629: x_return_status => x_return_status);
630:
631: -- check if activity started successfully
632: If (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then
633: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
634: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then
635: raise OKE_API.G_EXCEPTION_ERROR;
636: End If;

Line 633: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

629: x_return_status => x_return_status);
630:
631: -- check if activity started successfully
632: If (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then
633: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
634: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then
635: raise OKE_API.G_EXCEPTION_ERROR;
636: End If;
637:

Line 634: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then

630:
631: -- check if activity started successfully
632: If (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then
633: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
634: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then
635: raise OKE_API.G_EXCEPTION_ERROR;
636: End If;
637:
638:

Line 635: raise OKE_API.G_EXCEPTION_ERROR;

631: -- check if activity started successfully
632: If (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then
633: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
634: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then
635: raise OKE_API.G_EXCEPTION_ERROR;
636: End If;
637:
638:
639: OKE_RLE_PVT.Delete_Row(

Line 649: If x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR Then

645: p_rle_tbl => p_rle_tbl);
646:
647:
648:
649: If x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR Then
650: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
651: Elsif x_return_status = OKE_API.G_RET_STS_ERROR Then
652: raise OKE_API.G_EXCEPTION_ERROR;
653: End If;

Line 650: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

646:
647:
648:
649: If x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR Then
650: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
651: Elsif x_return_status = OKE_API.G_RET_STS_ERROR Then
652: raise OKE_API.G_EXCEPTION_ERROR;
653: End If;
654:

Line 651: Elsif x_return_status = OKE_API.G_RET_STS_ERROR Then

647:
648:
649: If x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR Then
650: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
651: Elsif x_return_status = OKE_API.G_RET_STS_ERROR Then
652: raise OKE_API.G_EXCEPTION_ERROR;
653: End If;
654:
655: OKE_API.END_ACTIVITY( x_msg_count => x_msg_count,

Line 652: raise OKE_API.G_EXCEPTION_ERROR;

648:
649: If x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR Then
650: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
651: Elsif x_return_status = OKE_API.G_RET_STS_ERROR Then
652: raise OKE_API.G_EXCEPTION_ERROR;
653: End If;
654:
655: OKE_API.END_ACTIVITY( x_msg_count => x_msg_count,
656: x_msg_data => x_msg_data);

Line 655: OKE_API.END_ACTIVITY( x_msg_count => x_msg_count,

651: Elsif x_return_status = OKE_API.G_RET_STS_ERROR Then
652: raise OKE_API.G_EXCEPTION_ERROR;
653: End If;
654:
655: OKE_API.END_ACTIVITY( x_msg_count => x_msg_count,
656: x_msg_data => x_msg_data);
657: EXCEPTION
658: when OKE_API.G_EXCEPTION_ERROR then
659: x_return_status := OKE_API.HANDLE_EXCEPTIONS(

Line 658: when OKE_API.G_EXCEPTION_ERROR then

654:
655: OKE_API.END_ACTIVITY( x_msg_count => x_msg_count,
656: x_msg_data => x_msg_data);
657: EXCEPTION
658: when OKE_API.G_EXCEPTION_ERROR then
659: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
660: p_api_name => l_api_name,
661: p_pkg_name => g_pkg_name,
662: p_exc_name => 'OKE_API.G_RET_STS_ERROR',

Line 659: x_return_status := OKE_API.HANDLE_EXCEPTIONS(

655: OKE_API.END_ACTIVITY( x_msg_count => x_msg_count,
656: x_msg_data => x_msg_data);
657: EXCEPTION
658: when OKE_API.G_EXCEPTION_ERROR then
659: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
660: p_api_name => l_api_name,
661: p_pkg_name => g_pkg_name,
662: p_exc_name => 'OKE_API.G_RET_STS_ERROR',
663: x_msg_count => x_msg_count,

Line 662: p_exc_name => 'OKE_API.G_RET_STS_ERROR',

658: when OKE_API.G_EXCEPTION_ERROR then
659: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
660: p_api_name => l_api_name,
661: p_pkg_name => g_pkg_name,
662: p_exc_name => 'OKE_API.G_RET_STS_ERROR',
663: x_msg_count => x_msg_count,
664: x_msg_data => x_msg_data,
665: p_api_type => g_api_type);
666:

Line 667: when OKE_API.G_EXCEPTION_UNEXPECTED_ERROR then

663: x_msg_count => x_msg_count,
664: x_msg_data => x_msg_data,
665: p_api_type => g_api_type);
666:
667: when OKE_API.G_EXCEPTION_UNEXPECTED_ERROR then
668: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
669: p_api_name => l_api_name,
670: p_pkg_name => g_pkg_name,
671: p_exc_name => 'OKE_API.G_RET_STS_UNEXP_ERROR',

Line 668: x_return_status := OKE_API.HANDLE_EXCEPTIONS(

664: x_msg_data => x_msg_data,
665: p_api_type => g_api_type);
666:
667: when OKE_API.G_EXCEPTION_UNEXPECTED_ERROR then
668: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
669: p_api_name => l_api_name,
670: p_pkg_name => g_pkg_name,
671: p_exc_name => 'OKE_API.G_RET_STS_UNEXP_ERROR',
672: x_msg_count => x_msg_count,

Line 671: p_exc_name => 'OKE_API.G_RET_STS_UNEXP_ERROR',

667: when OKE_API.G_EXCEPTION_UNEXPECTED_ERROR then
668: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
669: p_api_name => l_api_name,
670: p_pkg_name => g_pkg_name,
671: p_exc_name => 'OKE_API.G_RET_STS_UNEXP_ERROR',
672: x_msg_count => x_msg_count,
673: x_msg_data => x_msg_data,
674: p_api_type => g_api_type);
675:

Line 677: x_return_status := OKE_API.HANDLE_EXCEPTIONS(

673: x_msg_data => x_msg_data,
674: p_api_type => g_api_type);
675:
676: when OTHERS then
677: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
678: p_api_name => l_api_name,
679: p_pkg_name => g_pkg_name,
680: p_exc_name => 'OTHERS',
681: x_msg_count => x_msg_count,

Line 692: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,

688:
689:
690: PROCEDURE lock_related_entity(
691: p_api_version IN NUMBER,
692: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
693: x_return_status OUT NOCOPY VARCHAR2,
694: x_msg_count OUT NOCOPY NUMBER,
695: x_msg_data OUT NOCOPY VARCHAR2,
696: p_rle_rec IN OKE_RLE_PVT.rle_rec_type) IS

Line 701: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;

697:
698:
699: l_api_name CONSTANT VARCHAR2(30) := 'LOCK_RELATED_ENTITY';
700: l_api_version CONSTANT NUMBER := 1.0;
701: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;
702:
703: BEGIN
704: l_return_status := OKE_API.START_ACTIVITY(
705: p_api_name => l_api_name,

Line 704: l_return_status := OKE_API.START_ACTIVITY(

700: l_api_version CONSTANT NUMBER := 1.0;
701: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;
702:
703: BEGIN
704: l_return_status := OKE_API.START_ACTIVITY(
705: p_api_name => l_api_name,
706: p_pkg_name => g_pkg_name,
707: p_init_msg_list => p_init_msg_list,
708: l_api_version => l_api_version,

Line 714: If (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then

710: p_api_type => g_api_type,
711: x_return_status => x_return_status);
712:
713: -- check if activity started successfully
714: If (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then
715: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
716: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then
717: raise OKE_API.G_EXCEPTION_ERROR;
718: End If;

Line 715: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

711: x_return_status => x_return_status);
712:
713: -- check if activity started successfully
714: If (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then
715: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
716: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then
717: raise OKE_API.G_EXCEPTION_ERROR;
718: End If;
719:

Line 716: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then

712:
713: -- check if activity started successfully
714: If (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then
715: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
716: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then
717: raise OKE_API.G_EXCEPTION_ERROR;
718: End If;
719:
720: OKE_RLE_PVT.Lock_Row(

Line 717: raise OKE_API.G_EXCEPTION_ERROR;

713: -- check if activity started successfully
714: If (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then
715: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
716: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then
717: raise OKE_API.G_EXCEPTION_ERROR;
718: End If;
719:
720: OKE_RLE_PVT.Lock_Row(
721: p_api_version => p_api_version,

Line 729: If x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR Then

725: x_msg_data => x_msg_data,
726: p_rle_rec => p_rle_rec);
727:
728: -- check return status
729: If x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR Then
730: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
731: Elsif x_return_status = OKE_API.G_RET_STS_ERROR Then
732: raise OKE_API.G_EXCEPTION_ERROR;
733: End If;

Line 730: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

726: p_rle_rec => p_rle_rec);
727:
728: -- check return status
729: If x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR Then
730: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
731: Elsif x_return_status = OKE_API.G_RET_STS_ERROR Then
732: raise OKE_API.G_EXCEPTION_ERROR;
733: End If;
734:

Line 731: Elsif x_return_status = OKE_API.G_RET_STS_ERROR Then

727:
728: -- check return status
729: If x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR Then
730: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
731: Elsif x_return_status = OKE_API.G_RET_STS_ERROR Then
732: raise OKE_API.G_EXCEPTION_ERROR;
733: End If;
734:
735: OKE_API.END_ACTIVITY( x_msg_count => x_msg_count,

Line 732: raise OKE_API.G_EXCEPTION_ERROR;

728: -- check return status
729: If x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR Then
730: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
731: Elsif x_return_status = OKE_API.G_RET_STS_ERROR Then
732: raise OKE_API.G_EXCEPTION_ERROR;
733: End If;
734:
735: OKE_API.END_ACTIVITY( x_msg_count => x_msg_count,
736: x_msg_data => x_msg_data);

Line 735: OKE_API.END_ACTIVITY( x_msg_count => x_msg_count,

731: Elsif x_return_status = OKE_API.G_RET_STS_ERROR Then
732: raise OKE_API.G_EXCEPTION_ERROR;
733: End If;
734:
735: OKE_API.END_ACTIVITY( x_msg_count => x_msg_count,
736: x_msg_data => x_msg_data);
737: EXCEPTION
738: when OKE_API.G_EXCEPTION_ERROR then
739: x_return_status := OKE_API.HANDLE_EXCEPTIONS(

Line 738: when OKE_API.G_EXCEPTION_ERROR then

734:
735: OKE_API.END_ACTIVITY( x_msg_count => x_msg_count,
736: x_msg_data => x_msg_data);
737: EXCEPTION
738: when OKE_API.G_EXCEPTION_ERROR then
739: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
740: p_api_name => l_api_name,
741: p_pkg_name => g_pkg_name,
742: p_exc_name => 'OKE_API.G_RET_STS_ERROR',

Line 739: x_return_status := OKE_API.HANDLE_EXCEPTIONS(

735: OKE_API.END_ACTIVITY( x_msg_count => x_msg_count,
736: x_msg_data => x_msg_data);
737: EXCEPTION
738: when OKE_API.G_EXCEPTION_ERROR then
739: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
740: p_api_name => l_api_name,
741: p_pkg_name => g_pkg_name,
742: p_exc_name => 'OKE_API.G_RET_STS_ERROR',
743: x_msg_count => x_msg_count,

Line 742: p_exc_name => 'OKE_API.G_RET_STS_ERROR',

738: when OKE_API.G_EXCEPTION_ERROR then
739: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
740: p_api_name => l_api_name,
741: p_pkg_name => g_pkg_name,
742: p_exc_name => 'OKE_API.G_RET_STS_ERROR',
743: x_msg_count => x_msg_count,
744: x_msg_data => x_msg_data,
745: p_api_type => g_api_type);
746:

Line 747: when OKE_API.G_EXCEPTION_UNEXPECTED_ERROR then

743: x_msg_count => x_msg_count,
744: x_msg_data => x_msg_data,
745: p_api_type => g_api_type);
746:
747: when OKE_API.G_EXCEPTION_UNEXPECTED_ERROR then
748: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
749: p_api_name => l_api_name,
750: p_pkg_name => g_pkg_name,
751: p_exc_name => 'OKE_API.G_RET_STS_UNEXP_ERROR',

Line 748: x_return_status := OKE_API.HANDLE_EXCEPTIONS(

744: x_msg_data => x_msg_data,
745: p_api_type => g_api_type);
746:
747: when OKE_API.G_EXCEPTION_UNEXPECTED_ERROR then
748: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
749: p_api_name => l_api_name,
750: p_pkg_name => g_pkg_name,
751: p_exc_name => 'OKE_API.G_RET_STS_UNEXP_ERROR',
752: x_msg_count => x_msg_count,

Line 751: p_exc_name => 'OKE_API.G_RET_STS_UNEXP_ERROR',

747: when OKE_API.G_EXCEPTION_UNEXPECTED_ERROR then
748: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
749: p_api_name => l_api_name,
750: p_pkg_name => g_pkg_name,
751: p_exc_name => 'OKE_API.G_RET_STS_UNEXP_ERROR',
752: x_msg_count => x_msg_count,
753: x_msg_data => x_msg_data,
754: p_api_type => g_api_type);
755:

Line 757: x_return_status := OKE_API.HANDLE_EXCEPTIONS(

753: x_msg_data => x_msg_data,
754: p_api_type => g_api_type);
755:
756: when OTHERS then
757: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
758: p_api_name => l_api_name,
759: p_pkg_name => g_pkg_name,
760: p_exc_name => 'OTHERS',
761: x_msg_count => x_msg_count,

Line 769: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,

765: END lock_related_entity;
766:
767: PROCEDURE lock_related_entity(
768: p_api_version IN NUMBER,
769: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
770: x_return_status OUT NOCOPY VARCHAR2,
771: x_msg_count OUT NOCOPY NUMBER,
772: x_msg_data OUT NOCOPY VARCHAR2,
773: p_rle_tbl IN oke_rle_pvt.rle_tbl_type) IS

Line 777: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;

773: p_rle_tbl IN oke_rle_pvt.rle_tbl_type) IS
774:
775: l_api_name CONSTANT VARCHAR2(30) := 'LOCK_RELATED_ENTITY';
776: l_api_version CONSTANT NUMBER := 1.0;
777: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;
778: l_overall_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;
779: i NUMBER;
780: BEGIN
781: -- call START_ACTIVITY to create savepoint, check compatibility

Line 778: l_overall_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;

774:
775: l_api_name CONSTANT VARCHAR2(30) := 'LOCK_RELATED_ENTITY';
776: l_api_version CONSTANT NUMBER := 1.0;
777: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;
778: l_overall_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;
779: i NUMBER;
780: BEGIN
781: -- call START_ACTIVITY to create savepoint, check compatibility
782: -- and initialize message list

Line 783: l_return_status := OKE_API.START_ACTIVITY(

779: i NUMBER;
780: BEGIN
781: -- call START_ACTIVITY to create savepoint, check compatibility
782: -- and initialize message list
783: l_return_status := OKE_API.START_ACTIVITY(
784: p_api_name => l_api_name,
785: p_pkg_name => g_pkg_name,
786: p_init_msg_list => p_init_msg_list,
787: l_api_version => l_api_version,

Line 793: If (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then

789: p_api_type => g_api_type,
790: x_return_status => x_return_status);
791:
792: -- check if activity started successfully
793: If (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then
794: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
795: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then
796: raise OKE_API.G_EXCEPTION_ERROR;
797: End If;

Line 794: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

790: x_return_status => x_return_status);
791:
792: -- check if activity started successfully
793: If (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then
794: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
795: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then
796: raise OKE_API.G_EXCEPTION_ERROR;
797: End If;
798:

Line 795: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then

791:
792: -- check if activity started successfully
793: If (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then
794: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
795: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then
796: raise OKE_API.G_EXCEPTION_ERROR;
797: End If;
798:
799: If (p_rle_tbl.COUNT > 0) Then

Line 796: raise OKE_API.G_EXCEPTION_ERROR;

792: -- check if activity started successfully
793: If (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then
794: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
795: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then
796: raise OKE_API.G_EXCEPTION_ERROR;
797: End If;
798:
799: If (p_rle_tbl.COUNT > 0) Then
800: i := p_rle_tbl.FIRST;

Line 812: If x_return_status <> OKE_API.G_RET_STS_SUCCESS Then

808: x_msg_data => x_msg_data,
809: p_rle_rec => p_rle_tbl(i));
810:
811: -- store the highest degree of error
812: If x_return_status <> OKE_API.G_RET_STS_SUCCESS Then
813: If l_overall_status <> OKE_API.G_RET_STS_UNEXP_ERROR Then
814: l_overall_status := x_return_status;
815: End If;
816: End If;

Line 813: If l_overall_status <> OKE_API.G_RET_STS_UNEXP_ERROR Then

809: p_rle_rec => p_rle_tbl(i));
810:
811: -- store the highest degree of error
812: If x_return_status <> OKE_API.G_RET_STS_SUCCESS Then
813: If l_overall_status <> OKE_API.G_RET_STS_UNEXP_ERROR Then
814: l_overall_status := x_return_status;
815: End If;
816: End If;
817: EXIT WHEN (i = p_rle_tbl.LAST);

Line 824: If x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR Then

820: -- return overall status
821: x_return_status := l_overall_status;
822: End If;
823:
824: If x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR Then
825: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
826: Elsif x_return_status = OKE_API.G_RET_STS_ERROR Then
827: raise OKE_API.G_EXCEPTION_ERROR;
828: End If;

Line 825: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

821: x_return_status := l_overall_status;
822: End If;
823:
824: If x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR Then
825: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
826: Elsif x_return_status = OKE_API.G_RET_STS_ERROR Then
827: raise OKE_API.G_EXCEPTION_ERROR;
828: End If;
829:

Line 826: Elsif x_return_status = OKE_API.G_RET_STS_ERROR Then

822: End If;
823:
824: If x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR Then
825: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
826: Elsif x_return_status = OKE_API.G_RET_STS_ERROR Then
827: raise OKE_API.G_EXCEPTION_ERROR;
828: End If;
829:
830: -- end activity

Line 827: raise OKE_API.G_EXCEPTION_ERROR;

823:
824: If x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR Then
825: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
826: Elsif x_return_status = OKE_API.G_RET_STS_ERROR Then
827: raise OKE_API.G_EXCEPTION_ERROR;
828: End If;
829:
830: -- end activity
831: OKE_API.END_ACTIVITY( x_msg_count => x_msg_count,

Line 831: OKE_API.END_ACTIVITY( x_msg_count => x_msg_count,

827: raise OKE_API.G_EXCEPTION_ERROR;
828: End If;
829:
830: -- end activity
831: OKE_API.END_ACTIVITY( x_msg_count => x_msg_count,
832: x_msg_data => x_msg_data);
833: EXCEPTION
834: when OKE_API.G_EXCEPTION_ERROR then
835: x_return_status := OKE_API.HANDLE_EXCEPTIONS(

Line 834: when OKE_API.G_EXCEPTION_ERROR then

830: -- end activity
831: OKE_API.END_ACTIVITY( x_msg_count => x_msg_count,
832: x_msg_data => x_msg_data);
833: EXCEPTION
834: when OKE_API.G_EXCEPTION_ERROR then
835: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
836: p_api_name => l_api_name,
837: p_pkg_name => g_pkg_name,
838: p_exc_name => 'OKE_API.G_RET_STS_ERROR',

Line 835: x_return_status := OKE_API.HANDLE_EXCEPTIONS(

831: OKE_API.END_ACTIVITY( x_msg_count => x_msg_count,
832: x_msg_data => x_msg_data);
833: EXCEPTION
834: when OKE_API.G_EXCEPTION_ERROR then
835: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
836: p_api_name => l_api_name,
837: p_pkg_name => g_pkg_name,
838: p_exc_name => 'OKE_API.G_RET_STS_ERROR',
839: x_msg_count => x_msg_count,

Line 838: p_exc_name => 'OKE_API.G_RET_STS_ERROR',

834: when OKE_API.G_EXCEPTION_ERROR then
835: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
836: p_api_name => l_api_name,
837: p_pkg_name => g_pkg_name,
838: p_exc_name => 'OKE_API.G_RET_STS_ERROR',
839: x_msg_count => x_msg_count,
840: x_msg_data => x_msg_data,
841: p_api_type => g_api_type);
842:

Line 843: when OKE_API.G_EXCEPTION_UNEXPECTED_ERROR then

839: x_msg_count => x_msg_count,
840: x_msg_data => x_msg_data,
841: p_api_type => g_api_type);
842:
843: when OKE_API.G_EXCEPTION_UNEXPECTED_ERROR then
844: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
845: p_api_name => l_api_name,
846: p_pkg_name => g_pkg_name,
847: p_exc_name => 'OKE_API.G_RET_STS_UNEXP_ERROR',

Line 844: x_return_status := OKE_API.HANDLE_EXCEPTIONS(

840: x_msg_data => x_msg_data,
841: p_api_type => g_api_type);
842:
843: when OKE_API.G_EXCEPTION_UNEXPECTED_ERROR then
844: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
845: p_api_name => l_api_name,
846: p_pkg_name => g_pkg_name,
847: p_exc_name => 'OKE_API.G_RET_STS_UNEXP_ERROR',
848: x_msg_count => x_msg_count,

Line 847: p_exc_name => 'OKE_API.G_RET_STS_UNEXP_ERROR',

843: when OKE_API.G_EXCEPTION_UNEXPECTED_ERROR then
844: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
845: p_api_name => l_api_name,
846: p_pkg_name => g_pkg_name,
847: p_exc_name => 'OKE_API.G_RET_STS_UNEXP_ERROR',
848: x_msg_count => x_msg_count,
849: x_msg_data => x_msg_data,
850: p_api_type => g_api_type);
851:

Line 853: x_return_status := OKE_API.HANDLE_EXCEPTIONS(

849: x_msg_data => x_msg_data,
850: p_api_type => g_api_type);
851:
852: when OTHERS then
853: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
854: p_api_name => l_api_name,
855: p_pkg_name => g_pkg_name,
856: p_exc_name => 'OTHERS',
857: x_msg_count => x_msg_count,