APPS.OKE_STANDARD_NOTES_PUB dependencies on OKE_API

Line 7: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,

3: g_api_type CONSTANT VARCHAR2(4) := '_PUB';
4:
5: PROCEDURE create_standard_note(
6: p_api_version IN NUMBER,
7: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
8: x_return_status OUT NOCOPY VARCHAR2,
9: x_msg_count OUT NOCOPY NUMBER,
10: x_msg_data OUT NOCOPY VARCHAR2,
11: p_note_rec IN oke_note_pvt.note_rec_type,

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

15: l_note_rec oke_note_pvt.note_rec_type;
16:
17: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_STANDARD_NOTE';
18: l_api_version CONSTANT NUMBER := 1.0;
19: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;
20: l_line_number VARCHAR2(120);
21:
22: BEGIN
23: -- call START_ACTIVITY to create savepoint, check compatibility

Line 25: l_return_status := OKE_API.START_ACTIVITY(

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

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

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

Line 36: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

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

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

Line 38: raise OKE_API.G_EXCEPTION_ERROR;

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

Line 55: If x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR Then

51: p_note_rec => l_note_rec,
52: x_note_rec => x_note_rec);
53:
54:
55: If x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR Then
56: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
57: Elsif x_return_status = OKE_API.G_RET_STS_ERROR Then
58: raise OKE_API.G_EXCEPTION_ERROR;
59: End If;

Line 56: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

Line 57: Elsif x_return_status = OKE_API.G_RET_STS_ERROR Then

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

Line 58: raise OKE_API.G_EXCEPTION_ERROR;

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

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

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

Line 64: when OKE_API.G_EXCEPTION_ERROR then

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

Line 65: x_return_status := OKE_API.HANDLE_EXCEPTIONS(

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

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

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

Line 73: when OKE_API.G_EXCEPTION_UNEXPECTED_ERROR then

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

Line 74: x_return_status := OKE_API.HANDLE_EXCEPTIONS(

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

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

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

Line 83: x_return_status := OKE_API.HANDLE_EXCEPTIONS(

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

Line 97: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,

93:
94:
95: PROCEDURE create_standard_note(
96: p_api_version IN NUMBER,
97: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
98: x_return_status OUT NOCOPY VARCHAR2,
99: x_msg_count OUT NOCOPY NUMBER,
100: x_msg_data OUT NOCOPY VARCHAR2,
101: p_note_tbl IN oke_note_pvt.note_tbl_type,

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

102: x_note_tbl OUT NOCOPY oke_note_pvt.note_tbl_type) IS
103:
104: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_STANDARD_NOTE';
105: l_api_version CONSTANT NUMBER := 1.0;
106: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;
107: l_overall_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;
108: i NUMBER;
109: l_note_tbl oke_note_pvt.note_tbl_type;
110: BEGIN

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

103:
104: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_STANDARD_NOTE';
105: l_api_version CONSTANT NUMBER := 1.0;
106: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;
107: l_overall_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;
108: i NUMBER;
109: l_note_tbl oke_note_pvt.note_tbl_type;
110: BEGIN
111: -- call START_ACTIVITY to create savepoint, check compatibility

Line 113: l_return_status := OKE_API.START_ACTIVITY(

109: l_note_tbl oke_note_pvt.note_tbl_type;
110: BEGIN
111: -- call START_ACTIVITY to create savepoint, check compatibility
112: -- and initialize message list
113: l_return_status := OKE_API.START_ACTIVITY(
114: p_api_name => l_api_name,
115: p_pkg_name => g_pkg_name,
116: p_init_msg_list => p_init_msg_list,
117: l_api_version => l_api_version,

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

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

Line 124: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

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

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

Line 126: raise OKE_API.G_EXCEPTION_ERROR;

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

Line 139: If x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR Then

135: p_note_tbl => p_note_tbl,
136: x_note_tbl => x_note_tbl);
137:
138:
139: If x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR Then
140: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
141: Elsif x_return_status = OKE_API.G_RET_STS_ERROR Then
142: raise OKE_API.G_EXCEPTION_ERROR;
143: End If;

Line 140: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

Line 141: Elsif x_return_status = OKE_API.G_RET_STS_ERROR Then

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

Line 142: raise OKE_API.G_EXCEPTION_ERROR;

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

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

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

Line 148: when OKE_API.G_EXCEPTION_ERROR then

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

Line 149: x_return_status := OKE_API.HANDLE_EXCEPTIONS(

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

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

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

Line 157: when OKE_API.G_EXCEPTION_UNEXPECTED_ERROR then

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

Line 158: x_return_status := OKE_API.HANDLE_EXCEPTIONS(

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

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

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

Line 167: x_return_status := OKE_API.HANDLE_EXCEPTIONS(

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

Line 179: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,

175: END create_standard_note;
176:
177: PROCEDURE update_standard_note(
178: p_api_version IN NUMBER,
179: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
180: x_return_status OUT NOCOPY VARCHAR2,
181: x_msg_count OUT NOCOPY NUMBER,
182: x_msg_data OUT NOCOPY VARCHAR2,
183: p_note_rec IN oke_note_pvt.note_rec_type,

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

184: x_note_rec OUT NOCOPY oke_note_pvt.note_rec_type) IS
185:
186: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_STANDARD_NOTE';
187: l_api_version CONSTANT NUMBER := 1.0;
188: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;
189: BEGIN
190: -- call START_ACTIVITY to create savepoint, check compatibility
191: -- and initialize message list
192:

Line 193: l_return_status := OKE_API.START_ACTIVITY(

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

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

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

Line 204: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

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

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

Line 206: raise OKE_API.G_EXCEPTION_ERROR;

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

Line 221: If x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR Then

217: p_note_rec => p_note_rec,
218: x_note_rec => x_note_rec);
219:
220:
221: If x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR Then
222: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
223: Elsif x_return_status = OKE_API.G_RET_STS_ERROR Then
224: raise OKE_API.G_EXCEPTION_ERROR;
225: End If;

Line 222: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

Line 223: Elsif x_return_status = OKE_API.G_RET_STS_ERROR Then

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

Line 224: raise OKE_API.G_EXCEPTION_ERROR;

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

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

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

Line 231: when OKE_API.G_EXCEPTION_ERROR then

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

Line 232: x_return_status := OKE_API.HANDLE_EXCEPTIONS(

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

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

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

Line 240: when OKE_API.G_EXCEPTION_UNEXPECTED_ERROR then

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

Line 241: x_return_status := OKE_API.HANDLE_EXCEPTIONS(

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

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

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

Line 250: x_return_status := OKE_API.HANDLE_EXCEPTIONS(

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

Line 263: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,

259:
260:
261: PROCEDURE update_standard_note(
262: p_api_version IN NUMBER,
263: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
264: x_return_status OUT NOCOPY VARCHAR2,
265: x_msg_count OUT NOCOPY NUMBER,
266: x_msg_data OUT NOCOPY VARCHAR2,
267: p_note_tbl IN oke_note_pvt.note_tbl_type,

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

268: x_note_tbl OUT NOCOPY oke_note_pvt.note_tbl_type) IS
269:
270: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_STANDARD_NOTE';
271: l_api_version CONSTANT NUMBER := 1.0;
272: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;
273: l_overall_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;
274: i NUMBER;
275: BEGIN
276: -- call START_ACTIVITY to create savepoint, check compatibility

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

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

Line 279: l_return_status := OKE_API.START_ACTIVITY(

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

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

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

Line 290: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

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

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

Line 292: raise OKE_API.G_EXCEPTION_ERROR;

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

Line 307: If x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR Then

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

Line 308: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

Line 309: Elsif x_return_status = OKE_API.G_RET_STS_ERROR Then

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

Line 310: raise OKE_API.G_EXCEPTION_ERROR;

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

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

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

Line 317: when OKE_API.G_EXCEPTION_ERROR then

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

Line 318: x_return_status := OKE_API.HANDLE_EXCEPTIONS(

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

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

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

Line 326: when OKE_API.G_EXCEPTION_UNEXPECTED_ERROR then

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

Line 327: x_return_status := OKE_API.HANDLE_EXCEPTIONS(

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

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

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

Line 336: x_return_status := OKE_API.HANDLE_EXCEPTIONS(

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

Line 350: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,

346:
347:
348: PROCEDURE validate_standard_note(
349: p_api_version IN NUMBER,
350: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
351: x_return_status OUT NOCOPY VARCHAR2,
352: x_msg_count OUT NOCOPY NUMBER,
353: x_msg_data OUT NOCOPY VARCHAR2,
354: p_note_rec IN oke_note_pvt.note_rec_type) IS

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

355:
356: l_note_rec oke_note_pvt.note_rec_type;
357: l_api_name CONSTANT VARCHAR2(30) := 'VALIDATE_STANDARD_NOTE';
358: l_api_version CONSTANT NUMBER := 1.0;
359: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;
360:
361: BEGIN
362: -- call START_ACTIVITY to create savepoint, check compatibility
363: -- and initialize message list

Line 364: l_return_status := OKE_API.START_ACTIVITY(

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

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

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

Line 375: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

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

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

Line 377: raise OKE_API.G_EXCEPTION_ERROR;

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

Line 394: If x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR Then

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

Line 395: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

Line 396: Elsif x_return_status = OKE_API.G_RET_STS_ERROR Then

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

Line 397: raise OKE_API.G_EXCEPTION_ERROR;

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

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

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

Line 404: when OKE_API.G_EXCEPTION_ERROR then

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

Line 405: x_return_status := OKE_API.HANDLE_EXCEPTIONS(

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

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

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

Line 413: when OKE_API.G_EXCEPTION_UNEXPECTED_ERROR then

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

Line 414: x_return_status := OKE_API.HANDLE_EXCEPTIONS(

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

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

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

Line 423: x_return_status := OKE_API.HANDLE_EXCEPTIONS(

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

Line 435: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,

431: END validate_standard_note;
432:
433: PROCEDURE validate_standard_note(
434: p_api_version IN NUMBER,
435: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
436: x_return_status OUT NOCOPY VARCHAR2,
437: x_msg_count OUT NOCOPY NUMBER,
438: x_msg_data OUT NOCOPY VARCHAR2,
439: p_note_tbl IN oke_note_pvt.note_tbl_type) IS

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

440:
441: l_api_name CONSTANT VARCHAR2(30) := 'VALIDATE_STANDARD_NOTE';
442:
443: l_api_version CONSTANT NUMBER := 1.0;
444: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;
445: l_overall_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;
446: i NUMBER;
447: l_note_tbl oke_note_pvt.note_tbl_type := p_note_tbl;
448: BEGIN

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

441: l_api_name CONSTANT VARCHAR2(30) := 'VALIDATE_STANDARD_NOTE';
442:
443: l_api_version CONSTANT NUMBER := 1.0;
444: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;
445: l_overall_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;
446: i NUMBER;
447: l_note_tbl oke_note_pvt.note_tbl_type := p_note_tbl;
448: BEGIN
449: -- call START_ACTIVITY to create savepoint, check compatibility

Line 451: l_return_status := OKE_API.START_ACTIVITY(

447: l_note_tbl oke_note_pvt.note_tbl_type := p_note_tbl;
448: BEGIN
449: -- call START_ACTIVITY to create savepoint, check compatibility
450: -- and initialize message list
451: l_return_status := OKE_API.START_ACTIVITY(
452: p_api_name => l_api_name,
453: p_pkg_name => g_pkg_name,
454: p_init_msg_list => p_init_msg_list,
455: l_api_version => l_api_version,

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

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

Line 462: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

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

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

Line 464: raise OKE_API.G_EXCEPTION_ERROR;

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

Line 477: If x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR Then

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

Line 478: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

Line 479: Elsif x_return_status = OKE_API.G_RET_STS_ERROR Then

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

Line 480: raise OKE_API.G_EXCEPTION_ERROR;

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

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

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

Line 487: when OKE_API.G_EXCEPTION_ERROR then

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

Line 488: x_return_status := OKE_API.HANDLE_EXCEPTIONS(

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

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

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

Line 496: when OKE_API.G_EXCEPTION_UNEXPECTED_ERROR then

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

Line 497: x_return_status := OKE_API.HANDLE_EXCEPTIONS(

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

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

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

Line 506: x_return_status := OKE_API.HANDLE_EXCEPTIONS(

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

Line 522: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,

518:
519: PROCEDURE delete_standard_note(
520:
521: p_api_version IN NUMBER,
522: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
523: x_return_status OUT NOCOPY VARCHAR2,
524: x_msg_count OUT NOCOPY NUMBER,
525: x_msg_data OUT NOCOPY VARCHAR2,
526: p_note_rec IN oke_note_pvt.note_rec_type) IS

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

527:
528: l_note_rec oke_note_pvt.note_rec_type;
529: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_STANDARD_NOTE';
530: l_api_version CONSTANT NUMBER := 1.0;
531: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;
532: BEGIN
533: -- call START_ACTIVITY to create savepoint, check compatibility
534: -- and initialize message list
535: l_return_status := OKE_API.START_ACTIVITY(

Line 535: l_return_status := OKE_API.START_ACTIVITY(

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

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

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

Line 546: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

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

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

Line 548: raise OKE_API.G_EXCEPTION_ERROR;

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

Line 564: If x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR Then

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

Line 565: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

Line 566: Elsif x_return_status = OKE_API.G_RET_STS_ERROR Then

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

Line 567: raise OKE_API.G_EXCEPTION_ERROR;

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

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

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

Line 574: when OKE_API.G_EXCEPTION_ERROR then

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

Line 575: x_return_status := OKE_API.HANDLE_EXCEPTIONS(

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

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

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

Line 583: when OKE_API.G_EXCEPTION_UNEXPECTED_ERROR then

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

Line 584: x_return_status := OKE_API.HANDLE_EXCEPTIONS(

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

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

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

Line 593: x_return_status := OKE_API.HANDLE_EXCEPTIONS(

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

Line 605: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,

601: END delete_standard_note;
602:
603: PROCEDURE delete_standard_note(
604: p_api_version IN NUMBER,
605: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
606: x_return_status OUT NOCOPY VARCHAR2,
607: x_msg_count OUT NOCOPY NUMBER,
608: x_msg_data OUT NOCOPY VARCHAR2,
609: p_note_tbl IN oke_note_pvt.note_tbl_type) IS

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

609: p_note_tbl IN oke_note_pvt.note_tbl_type) IS
610:
611: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_STANDARD_NOTE';
612: l_api_version CONSTANT NUMBER := 1.0;
613: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;
614: l_overall_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;
615: i NUMBER;
616: BEGIN
617: -- call START_ACTIVITY to create savepoint, check compatibility

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

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

Line 619: l_return_status := OKE_API.START_ACTIVITY(

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

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

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

Line 630: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

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

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

Line 632: raise OKE_API.G_EXCEPTION_ERROR;

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

Line 646: If x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR Then

642: p_note_tbl => p_note_tbl);
643:
644:
645:
646: If x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR Then
647: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
648: Elsif x_return_status = OKE_API.G_RET_STS_ERROR Then
649: raise OKE_API.G_EXCEPTION_ERROR;
650: End If;

Line 647: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

643:
644:
645:
646: If x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR Then
647: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
648: Elsif x_return_status = OKE_API.G_RET_STS_ERROR Then
649: raise OKE_API.G_EXCEPTION_ERROR;
650: End If;
651:

Line 648: Elsif x_return_status = OKE_API.G_RET_STS_ERROR Then

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

Line 649: raise OKE_API.G_EXCEPTION_ERROR;

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

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

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

Line 655: when OKE_API.G_EXCEPTION_ERROR then

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

Line 656: x_return_status := OKE_API.HANDLE_EXCEPTIONS(

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

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

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

Line 664: when OKE_API.G_EXCEPTION_UNEXPECTED_ERROR then

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

Line 665: x_return_status := OKE_API.HANDLE_EXCEPTIONS(

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

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

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

Line 674: x_return_status := OKE_API.HANDLE_EXCEPTIONS(

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

Line 687: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,

683:
684: PROCEDURE delete_standard_note(
685:
686: p_api_version IN NUMBER,
687: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
688: x_return_status OUT NOCOPY VARCHAR2,
689: x_msg_count OUT NOCOPY NUMBER,
690: x_msg_data OUT NOCOPY VARCHAR2,
691: p_note_id IN NUMBER) IS

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

692:
693: l_note_rec oke_note_pvt.note_rec_type;
694: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_STANDARD_NOTE';
695: l_api_version CONSTANT NUMBER := 1.0;
696: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;
697: l_check_num1 NUMBER;
698: l_check_num2 NUMBER;
699:
700: BEGIN

Line 703: l_return_status := OKE_API.START_ACTIVITY(

699:
700: BEGIN
701: -- call START_ACTIVITY to create savepoint, check compatibility
702: -- and initialize message list
703: l_return_status := OKE_API.START_ACTIVITY(
704: p_api_name => l_api_name,
705: p_pkg_name => g_pkg_name,
706: p_init_msg_list => p_init_msg_list,
707: l_api_version => l_api_version,

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

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

Line 714: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

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

711:
712: -- check if activity started successfully
713: If (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then
714: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
715: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then
716: raise OKE_API.G_EXCEPTION_ERROR;
717: End If;
718:
719: SELECT COUNT(*) INTO l_check_num1 FROM OKE_K_STANDARD_NOTES_B

Line 716: raise OKE_API.G_EXCEPTION_ERROR;

712: -- check if activity started successfully
713: If (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then
714: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
715: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then
716: raise OKE_API.G_EXCEPTION_ERROR;
717: End If;
718:
719: SELECT COUNT(*) INTO l_check_num1 FROM OKE_K_STANDARD_NOTES_B
720: WHERE STANDARD_NOTES_ID = p_note_id;

Line 726: raise OKE_API.G_EXCEPTION_ERROR;

722: SELECT COUNT(*) INTO l_check_num2 FROM OKE_K_STANDARD_NOTES_TL
723: WHERE STANDARD_NOTES_ID = p_note_id;
724:
725: If(l_check_num1<1)OR(l_check_num2<1) then
726: raise OKE_API.G_EXCEPTION_ERROR;
727: End If;
728:
729: l_note_rec.STANDARD_NOTES_ID := p_note_id;
730:

Line 742: If x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR Then

738: x_msg_data => x_msg_data,
739: p_note_rec => l_note_rec);
740:
741:
742: If x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR Then
743: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
744: Elsif x_return_status = OKE_API.G_RET_STS_ERROR Then
745: raise OKE_API.G_EXCEPTION_ERROR;
746: End If;

Line 743: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

739: p_note_rec => l_note_rec);
740:
741:
742: If x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR Then
743: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
744: Elsif x_return_status = OKE_API.G_RET_STS_ERROR Then
745: raise OKE_API.G_EXCEPTION_ERROR;
746: End If;
747:

Line 744: Elsif x_return_status = OKE_API.G_RET_STS_ERROR Then

740:
741:
742: If x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR Then
743: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
744: Elsif x_return_status = OKE_API.G_RET_STS_ERROR Then
745: raise OKE_API.G_EXCEPTION_ERROR;
746: End If;
747:
748:

Line 745: raise OKE_API.G_EXCEPTION_ERROR;

741:
742: If x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR Then
743: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
744: Elsif x_return_status = OKE_API.G_RET_STS_ERROR Then
745: raise OKE_API.G_EXCEPTION_ERROR;
746: End If;
747:
748:
749: OKE_API.END_ACTIVITY( x_msg_count => x_msg_count,

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

745: raise OKE_API.G_EXCEPTION_ERROR;
746: End If;
747:
748:
749: OKE_API.END_ACTIVITY( x_msg_count => x_msg_count,
750: x_msg_data => x_msg_data);
751: EXCEPTION
752: when OKE_API.G_EXCEPTION_ERROR then
753: x_return_status := OKE_API.HANDLE_EXCEPTIONS(

Line 752: when OKE_API.G_EXCEPTION_ERROR then

748:
749: OKE_API.END_ACTIVITY( x_msg_count => x_msg_count,
750: x_msg_data => x_msg_data);
751: EXCEPTION
752: when OKE_API.G_EXCEPTION_ERROR then
753: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
754: p_api_name => l_api_name,
755: p_pkg_name => g_pkg_name,
756: p_exc_name => 'OKE_API.G_RET_STS_ERROR',

Line 753: x_return_status := OKE_API.HANDLE_EXCEPTIONS(

749: OKE_API.END_ACTIVITY( x_msg_count => x_msg_count,
750: x_msg_data => x_msg_data);
751: EXCEPTION
752: when OKE_API.G_EXCEPTION_ERROR then
753: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
754: p_api_name => l_api_name,
755: p_pkg_name => g_pkg_name,
756: p_exc_name => 'OKE_API.G_RET_STS_ERROR',
757: x_msg_count => x_msg_count,

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

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

Line 761: when OKE_API.G_EXCEPTION_UNEXPECTED_ERROR then

757: x_msg_count => x_msg_count,
758: x_msg_data => x_msg_data,
759: p_api_type => g_api_type);
760:
761: when OKE_API.G_EXCEPTION_UNEXPECTED_ERROR then
762: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
763: p_api_name => l_api_name,
764: p_pkg_name => g_pkg_name,
765: p_exc_name => 'OKE_API.G_RET_STS_UNEXP_ERROR',

Line 762: x_return_status := OKE_API.HANDLE_EXCEPTIONS(

758: x_msg_data => x_msg_data,
759: p_api_type => g_api_type);
760:
761: when OKE_API.G_EXCEPTION_UNEXPECTED_ERROR then
762: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
763: p_api_name => l_api_name,
764: p_pkg_name => g_pkg_name,
765: p_exc_name => 'OKE_API.G_RET_STS_UNEXP_ERROR',
766: x_msg_count => x_msg_count,

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

761: when OKE_API.G_EXCEPTION_UNEXPECTED_ERROR then
762: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
763: p_api_name => l_api_name,
764: p_pkg_name => g_pkg_name,
765: p_exc_name => 'OKE_API.G_RET_STS_UNEXP_ERROR',
766: x_msg_count => x_msg_count,
767: x_msg_data => x_msg_data,
768: p_api_type => g_api_type);
769:

Line 771: x_return_status := OKE_API.HANDLE_EXCEPTIONS(

767: x_msg_data => x_msg_data,
768: p_api_type => g_api_type);
769:
770: when OTHERS then
771: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
772: p_api_name => l_api_name,
773: p_pkg_name => g_pkg_name,
774: p_exc_name => 'OTHERS',
775: x_msg_count => x_msg_count,

Line 786: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,

782:
783: PROCEDURE delete_standard_note(
784:
785: p_api_version IN NUMBER,
786: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
787: x_return_status OUT NOCOPY VARCHAR2,
788: x_msg_count OUT NOCOPY NUMBER,
789: x_msg_data OUT NOCOPY VARCHAR2,
790: p_hdr_id IN NUMBER,

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

793:
794: l_note_rec oke_note_pvt.note_rec_type;
795: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_STANDARD_NOTE';
796: l_api_version CONSTANT NUMBER := 1.0;
797: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;
798: l_check_num1 NUMBER;
799: l_check_num2 NUMBER;
800:
801: BEGIN

Line 804: l_return_status := OKE_API.START_ACTIVITY(

800:
801: BEGIN
802: -- call START_ACTIVITY to create savepoint, check compatibility
803: -- and initialize message list
804: l_return_status := OKE_API.START_ACTIVITY(
805: p_api_name => l_api_name,
806: p_pkg_name => g_pkg_name,
807: p_init_msg_list => p_init_msg_list,
808: l_api_version => l_api_version,

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

810: p_api_type => g_api_type,
811: x_return_status => x_return_status);
812:
813: -- check if activity started successfully
814: If (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then
815: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
816: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then
817: raise OKE_API.G_EXCEPTION_ERROR;
818: End If;

Line 815: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

811: x_return_status => x_return_status);
812:
813: -- check if activity started successfully
814: If (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then
815: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
816: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then
817: raise OKE_API.G_EXCEPTION_ERROR;
818: End If;
819:

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

812:
813: -- check if activity started successfully
814: If (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then
815: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
816: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then
817: raise OKE_API.G_EXCEPTION_ERROR;
818: End If;
819:
820: If (p_del_id IS NOT NULL) Then

Line 817: raise OKE_API.G_EXCEPTION_ERROR;

813: -- check if activity started successfully
814: If (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then
815: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
816: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then
817: raise OKE_API.G_EXCEPTION_ERROR;
818: End If;
819:
820: If (p_del_id IS NOT NULL) Then
821: OKE_NOTE_PVT.delete_row(

Line 850: raise OKE_API.G_EXCEPTION_ERROR;

846: x_msg_data => x_msg_data,
847: p_hdr_id => p_hdr_id);
848:
849: Else
850: raise OKE_API.G_EXCEPTION_ERROR;
851: End If;
852:
853:
854:

Line 855: If x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR Then

851: End If;
852:
853:
854:
855: If x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR Then
856: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
857: Elsif x_return_status = OKE_API.G_RET_STS_ERROR Then
858: raise OKE_API.G_EXCEPTION_ERROR;
859: End If;

Line 856: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

852:
853:
854:
855: If x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR Then
856: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
857: Elsif x_return_status = OKE_API.G_RET_STS_ERROR Then
858: raise OKE_API.G_EXCEPTION_ERROR;
859: End If;
860:

Line 857: Elsif x_return_status = OKE_API.G_RET_STS_ERROR Then

853:
854:
855: If x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR Then
856: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
857: Elsif x_return_status = OKE_API.G_RET_STS_ERROR Then
858: raise OKE_API.G_EXCEPTION_ERROR;
859: End If;
860:
861: OKE_API.END_ACTIVITY( x_msg_count => x_msg_count,

Line 858: raise OKE_API.G_EXCEPTION_ERROR;

854:
855: If x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR Then
856: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
857: Elsif x_return_status = OKE_API.G_RET_STS_ERROR Then
858: raise OKE_API.G_EXCEPTION_ERROR;
859: End If;
860:
861: OKE_API.END_ACTIVITY( x_msg_count => x_msg_count,
862: x_msg_data => x_msg_data);

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

857: Elsif x_return_status = OKE_API.G_RET_STS_ERROR Then
858: raise OKE_API.G_EXCEPTION_ERROR;
859: End If;
860:
861: OKE_API.END_ACTIVITY( x_msg_count => x_msg_count,
862: x_msg_data => x_msg_data);
863: EXCEPTION
864: when OKE_API.G_EXCEPTION_ERROR then
865: x_return_status := OKE_API.HANDLE_EXCEPTIONS(

Line 864: when OKE_API.G_EXCEPTION_ERROR then

860:
861: OKE_API.END_ACTIVITY( x_msg_count => x_msg_count,
862: x_msg_data => x_msg_data);
863: EXCEPTION
864: when OKE_API.G_EXCEPTION_ERROR then
865: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
866: p_api_name => l_api_name,
867: p_pkg_name => g_pkg_name,
868: p_exc_name => 'OKE_API.G_RET_STS_ERROR',

Line 865: x_return_status := OKE_API.HANDLE_EXCEPTIONS(

861: OKE_API.END_ACTIVITY( x_msg_count => x_msg_count,
862: x_msg_data => x_msg_data);
863: EXCEPTION
864: when OKE_API.G_EXCEPTION_ERROR then
865: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
866: p_api_name => l_api_name,
867: p_pkg_name => g_pkg_name,
868: p_exc_name => 'OKE_API.G_RET_STS_ERROR',
869: x_msg_count => x_msg_count,

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

864: when OKE_API.G_EXCEPTION_ERROR then
865: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
866: p_api_name => l_api_name,
867: p_pkg_name => g_pkg_name,
868: p_exc_name => 'OKE_API.G_RET_STS_ERROR',
869: x_msg_count => x_msg_count,
870: x_msg_data => x_msg_data,
871: p_api_type => g_api_type);
872:

Line 873: when OKE_API.G_EXCEPTION_UNEXPECTED_ERROR then

869: x_msg_count => x_msg_count,
870: x_msg_data => x_msg_data,
871: p_api_type => g_api_type);
872:
873: when OKE_API.G_EXCEPTION_UNEXPECTED_ERROR then
874: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
875: p_api_name => l_api_name,
876: p_pkg_name => g_pkg_name,
877: p_exc_name => 'OKE_API.G_RET_STS_UNEXP_ERROR',

Line 874: x_return_status := OKE_API.HANDLE_EXCEPTIONS(

870: x_msg_data => x_msg_data,
871: p_api_type => g_api_type);
872:
873: when OKE_API.G_EXCEPTION_UNEXPECTED_ERROR then
874: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
875: p_api_name => l_api_name,
876: p_pkg_name => g_pkg_name,
877: p_exc_name => 'OKE_API.G_RET_STS_UNEXP_ERROR',
878: x_msg_count => x_msg_count,

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

873: when OKE_API.G_EXCEPTION_UNEXPECTED_ERROR then
874: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
875: p_api_name => l_api_name,
876: p_pkg_name => g_pkg_name,
877: p_exc_name => 'OKE_API.G_RET_STS_UNEXP_ERROR',
878: x_msg_count => x_msg_count,
879: x_msg_data => x_msg_data,
880: p_api_type => g_api_type);
881:

Line 883: x_return_status := OKE_API.HANDLE_EXCEPTIONS(

879: x_msg_data => x_msg_data,
880: p_api_type => g_api_type);
881:
882: when OTHERS then
883: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
884: p_api_name => l_api_name,
885: p_pkg_name => g_pkg_name,
886: p_exc_name => 'OTHERS',
887: x_msg_count => x_msg_count,

Line 896: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,

892:
893:
894: PROCEDURE copy_standard_note(
895: p_api_version IN NUMBER,
896: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
897: x_return_status OUT NOCOPY VARCHAR2,
898: x_msg_count OUT NOCOPY NUMBER,
899: x_msg_data OUT NOCOPY VARCHAR2,
900: p_from_hdr_id IN NUMBER,

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

909: l_note_tbl oke_note_pvt.note_tbl_type;
910: l_note_rec oke_note_pvt.note_rec_type;
911: l_api_name CONSTANT VARCHAR2(30) := 'COPY_STANDARD_NOTE';
912: l_api_version CONSTANT NUMBER := 1.0;
913: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;
914: l_rec_num NUMBER:=0;
915:
916: x_note_tbl oke_note_pvt.note_tbl_type;
917:

Line 1036: l_return_status := OKE_API.START_ACTIVITY(

1032: BEGIN
1033:
1034: -- call START_ACTIVITY to create savepoint, check compatibility
1035: -- and initialize message list
1036: l_return_status := OKE_API.START_ACTIVITY(
1037: p_api_name => l_api_name,
1038: p_pkg_name => g_pkg_name,
1039: p_init_msg_list => p_init_msg_list,
1040: l_api_version => l_api_version,

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

1042: p_api_type => g_api_type,
1043: x_return_status => x_return_status);
1044:
1045: -- check if activity started successfully
1046: If (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then
1047: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1048: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then
1049: raise OKE_API.G_EXCEPTION_ERROR;
1050: End If;

Line 1047: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

1043: x_return_status => x_return_status);
1044:
1045: -- check if activity started successfully
1046: If (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then
1047: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1048: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then
1049: raise OKE_API.G_EXCEPTION_ERROR;
1050: End If;
1051:

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

1044:
1045: -- check if activity started successfully
1046: If (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then
1047: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1048: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then
1049: raise OKE_API.G_EXCEPTION_ERROR;
1050: End If;
1051:
1052: IF(

Line 1049: raise OKE_API.G_EXCEPTION_ERROR;

1045: -- check if activity started successfully
1046: If (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then
1047: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1048: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then
1049: raise OKE_API.G_EXCEPTION_ERROR;
1050: End If;
1051:
1052: IF(
1053: (p_from_hdr_id IS NOT NULL)AND

Line 1130: If x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR Then

1126: x_msg_data => x_msg_data,
1127: p_note_tbl => l_note_tbl,
1128: x_note_tbl => x_note_tbl);
1129:
1130: If x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR Then
1131: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1132: Elsif x_return_status = OKE_API.G_RET_STS_ERROR Then
1133: raise OKE_API.G_EXCEPTION_ERROR;
1134: End If;

Line 1131: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

1127: p_note_tbl => l_note_tbl,
1128: x_note_tbl => x_note_tbl);
1129:
1130: If x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR Then
1131: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1132: Elsif x_return_status = OKE_API.G_RET_STS_ERROR Then
1133: raise OKE_API.G_EXCEPTION_ERROR;
1134: End If;
1135:

Line 1132: Elsif x_return_status = OKE_API.G_RET_STS_ERROR Then

1128: x_note_tbl => x_note_tbl);
1129:
1130: If x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR Then
1131: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1132: Elsif x_return_status = OKE_API.G_RET_STS_ERROR Then
1133: raise OKE_API.G_EXCEPTION_ERROR;
1134: End If;
1135:
1136:

Line 1133: raise OKE_API.G_EXCEPTION_ERROR;

1129:
1130: If x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR Then
1131: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1132: Elsif x_return_status = OKE_API.G_RET_STS_ERROR Then
1133: raise OKE_API.G_EXCEPTION_ERROR;
1134: End If;
1135:
1136:
1137: ELSIF(

Line 1215: If x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR Then

1211: x_msg_data => x_msg_data,
1212: p_note_tbl => l_note_tbl,
1213: x_note_tbl => x_note_tbl);
1214:
1215: If x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR Then
1216: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1217: Elsif x_return_status = OKE_API.G_RET_STS_ERROR Then
1218: raise OKE_API.G_EXCEPTION_ERROR;
1219: End If;

Line 1216: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

1212: p_note_tbl => l_note_tbl,
1213: x_note_tbl => x_note_tbl);
1214:
1215: If x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR Then
1216: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1217: Elsif x_return_status = OKE_API.G_RET_STS_ERROR Then
1218: raise OKE_API.G_EXCEPTION_ERROR;
1219: End If;
1220:

Line 1217: Elsif x_return_status = OKE_API.G_RET_STS_ERROR Then

1213: x_note_tbl => x_note_tbl);
1214:
1215: If x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR Then
1216: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1217: Elsif x_return_status = OKE_API.G_RET_STS_ERROR Then
1218: raise OKE_API.G_EXCEPTION_ERROR;
1219: End If;
1220:
1221:

Line 1218: raise OKE_API.G_EXCEPTION_ERROR;

1214:
1215: If x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR Then
1216: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1217: Elsif x_return_status = OKE_API.G_RET_STS_ERROR Then
1218: raise OKE_API.G_EXCEPTION_ERROR;
1219: End If;
1220:
1221:
1222: ELSIF(

Line 1300: If x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR Then

1296: p_note_tbl => l_note_tbl,
1297: x_note_tbl => x_note_tbl);
1298:
1299:
1300: If x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR Then
1301: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1302: Elsif x_return_status = OKE_API.G_RET_STS_ERROR Then
1303: raise OKE_API.G_EXCEPTION_ERROR;
1304: End If;

Line 1301: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

1297: x_note_tbl => x_note_tbl);
1298:
1299:
1300: If x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR Then
1301: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1302: Elsif x_return_status = OKE_API.G_RET_STS_ERROR Then
1303: raise OKE_API.G_EXCEPTION_ERROR;
1304: End If;
1305:

Line 1302: Elsif x_return_status = OKE_API.G_RET_STS_ERROR Then

1298:
1299:
1300: If x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR Then
1301: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1302: Elsif x_return_status = OKE_API.G_RET_STS_ERROR Then
1303: raise OKE_API.G_EXCEPTION_ERROR;
1304: End If;
1305:
1306: ELSE

Line 1303: raise OKE_API.G_EXCEPTION_ERROR;

1299:
1300: If x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR Then
1301: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1302: Elsif x_return_status = OKE_API.G_RET_STS_ERROR Then
1303: raise OKE_API.G_EXCEPTION_ERROR;
1304: End If;
1305:
1306: ELSE
1307: raise OKE_API.G_EXCEPTION_ERROR;

Line 1307: raise OKE_API.G_EXCEPTION_ERROR;

1303: raise OKE_API.G_EXCEPTION_ERROR;
1304: End If;
1305:
1306: ELSE
1307: raise OKE_API.G_EXCEPTION_ERROR;
1308: END IF;
1309:
1310: OKE_API.END_ACTIVITY( x_msg_count => x_msg_count,
1311: x_msg_data => x_msg_data);

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

1306: ELSE
1307: raise OKE_API.G_EXCEPTION_ERROR;
1308: END IF;
1309:
1310: OKE_API.END_ACTIVITY( x_msg_count => x_msg_count,
1311: x_msg_data => x_msg_data);
1312: EXCEPTION
1313: when OKE_API.G_EXCEPTION_ERROR then
1314: x_return_status := OKE_API.HANDLE_EXCEPTIONS(

Line 1313: when OKE_API.G_EXCEPTION_ERROR then

1309:
1310: OKE_API.END_ACTIVITY( x_msg_count => x_msg_count,
1311: x_msg_data => x_msg_data);
1312: EXCEPTION
1313: when OKE_API.G_EXCEPTION_ERROR then
1314: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
1315: p_api_name => l_api_name,
1316: p_pkg_name => g_pkg_name,
1317: p_exc_name => 'OKE_API.G_RET_STS_ERROR',

Line 1314: x_return_status := OKE_API.HANDLE_EXCEPTIONS(

1310: OKE_API.END_ACTIVITY( x_msg_count => x_msg_count,
1311: x_msg_data => x_msg_data);
1312: EXCEPTION
1313: when OKE_API.G_EXCEPTION_ERROR then
1314: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
1315: p_api_name => l_api_name,
1316: p_pkg_name => g_pkg_name,
1317: p_exc_name => 'OKE_API.G_RET_STS_ERROR',
1318: x_msg_count => x_msg_count,

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

1313: when OKE_API.G_EXCEPTION_ERROR then
1314: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
1315: p_api_name => l_api_name,
1316: p_pkg_name => g_pkg_name,
1317: p_exc_name => 'OKE_API.G_RET_STS_ERROR',
1318: x_msg_count => x_msg_count,
1319: x_msg_data => x_msg_data,
1320: p_api_type => g_api_type);
1321:

Line 1322: when OKE_API.G_EXCEPTION_UNEXPECTED_ERROR then

1318: x_msg_count => x_msg_count,
1319: x_msg_data => x_msg_data,
1320: p_api_type => g_api_type);
1321:
1322: when OKE_API.G_EXCEPTION_UNEXPECTED_ERROR then
1323: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
1324: p_api_name => l_api_name,
1325: p_pkg_name => g_pkg_name,
1326: p_exc_name => 'OKE_API.G_RET_STS_UNEXP_ERROR',

Line 1323: x_return_status := OKE_API.HANDLE_EXCEPTIONS(

1319: x_msg_data => x_msg_data,
1320: p_api_type => g_api_type);
1321:
1322: when OKE_API.G_EXCEPTION_UNEXPECTED_ERROR then
1323: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
1324: p_api_name => l_api_name,
1325: p_pkg_name => g_pkg_name,
1326: p_exc_name => 'OKE_API.G_RET_STS_UNEXP_ERROR',
1327: x_msg_count => x_msg_count,

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

1322: when OKE_API.G_EXCEPTION_UNEXPECTED_ERROR then
1323: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
1324: p_api_name => l_api_name,
1325: p_pkg_name => g_pkg_name,
1326: p_exc_name => 'OKE_API.G_RET_STS_UNEXP_ERROR',
1327: x_msg_count => x_msg_count,
1328: x_msg_data => x_msg_data,
1329: p_api_type => g_api_type);
1330:

Line 1332: x_return_status := OKE_API.HANDLE_EXCEPTIONS(

1328: x_msg_data => x_msg_data,
1329: p_api_type => g_api_type);
1330:
1331: when OTHERS then
1332: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
1333: p_api_name => l_api_name,
1334: p_pkg_name => g_pkg_name,
1335: p_exc_name => 'OTHERS',
1336: x_msg_count => x_msg_count,

Line 1345: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,

1341:
1342:
1343: PROCEDURE lock_standard_note(
1344: p_api_version IN NUMBER,
1345: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
1346: x_return_status OUT NOCOPY VARCHAR2,
1347: x_msg_count OUT NOCOPY NUMBER,
1348: x_msg_data OUT NOCOPY VARCHAR2,
1349: p_note_rec IN OKE_NOTE_PVT.note_rec_type) IS

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

1351:
1352: l_del_rec oke_deliverable_pvt.del_rec_type;
1353: l_api_name CONSTANT VARCHAR2(30) := 'LOCK_STANDARD_NOTE';
1354: l_api_version CONSTANT NUMBER := 1.0;
1355: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;
1356:
1357: BEGIN
1358: l_return_status := OKE_API.START_ACTIVITY(
1359: p_api_name => l_api_name,

Line 1358: l_return_status := OKE_API.START_ACTIVITY(

1354: l_api_version CONSTANT NUMBER := 1.0;
1355: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;
1356:
1357: BEGIN
1358: l_return_status := OKE_API.START_ACTIVITY(
1359: p_api_name => l_api_name,
1360: p_pkg_name => g_pkg_name,
1361: p_init_msg_list => p_init_msg_list,
1362: l_api_version => l_api_version,

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

1364: p_api_type => g_api_type,
1365: x_return_status => x_return_status);
1366:
1367: -- check if activity started successfully
1368: If (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then
1369: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1370: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then
1371: raise OKE_API.G_EXCEPTION_ERROR;
1372: End If;

Line 1369: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

1365: x_return_status => x_return_status);
1366:
1367: -- check if activity started successfully
1368: If (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then
1369: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1370: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then
1371: raise OKE_API.G_EXCEPTION_ERROR;
1372: End If;
1373:

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

1366:
1367: -- check if activity started successfully
1368: If (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then
1369: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1370: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then
1371: raise OKE_API.G_EXCEPTION_ERROR;
1372: End If;
1373:
1374: OKE_NOTE_PVT.Lock_Row(

Line 1371: raise OKE_API.G_EXCEPTION_ERROR;

1367: -- check if activity started successfully
1368: If (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then
1369: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1370: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then
1371: raise OKE_API.G_EXCEPTION_ERROR;
1372: End If;
1373:
1374: OKE_NOTE_PVT.Lock_Row(
1375: p_api_version => p_api_version,

Line 1383: If x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR Then

1379: x_msg_data => x_msg_data,
1380: p_note_rec => p_note_rec);
1381:
1382: -- check return status
1383: If x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR Then
1384: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1385: Elsif x_return_status = OKE_API.G_RET_STS_ERROR Then
1386: raise OKE_API.G_EXCEPTION_ERROR;
1387: End If;

Line 1384: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

1380: p_note_rec => p_note_rec);
1381:
1382: -- check return status
1383: If x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR Then
1384: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1385: Elsif x_return_status = OKE_API.G_RET_STS_ERROR Then
1386: raise OKE_API.G_EXCEPTION_ERROR;
1387: End If;
1388:

Line 1385: Elsif x_return_status = OKE_API.G_RET_STS_ERROR Then

1381:
1382: -- check return status
1383: If x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR Then
1384: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1385: Elsif x_return_status = OKE_API.G_RET_STS_ERROR Then
1386: raise OKE_API.G_EXCEPTION_ERROR;
1387: End If;
1388:
1389: OKE_API.END_ACTIVITY( x_msg_count => x_msg_count,

Line 1386: raise OKE_API.G_EXCEPTION_ERROR;

1382: -- check return status
1383: If x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR Then
1384: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1385: Elsif x_return_status = OKE_API.G_RET_STS_ERROR Then
1386: raise OKE_API.G_EXCEPTION_ERROR;
1387: End If;
1388:
1389: OKE_API.END_ACTIVITY( x_msg_count => x_msg_count,
1390: x_msg_data => x_msg_data);

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

1385: Elsif x_return_status = OKE_API.G_RET_STS_ERROR Then
1386: raise OKE_API.G_EXCEPTION_ERROR;
1387: End If;
1388:
1389: OKE_API.END_ACTIVITY( x_msg_count => x_msg_count,
1390: x_msg_data => x_msg_data);
1391: EXCEPTION
1392: when OKE_API.G_EXCEPTION_ERROR then
1393: x_return_status := OKE_API.HANDLE_EXCEPTIONS(

Line 1392: when OKE_API.G_EXCEPTION_ERROR then

1388:
1389: OKE_API.END_ACTIVITY( x_msg_count => x_msg_count,
1390: x_msg_data => x_msg_data);
1391: EXCEPTION
1392: when OKE_API.G_EXCEPTION_ERROR then
1393: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
1394: p_api_name => l_api_name,
1395: p_pkg_name => g_pkg_name,
1396: p_exc_name => 'OKE_API.G_RET_STS_ERROR',

Line 1393: x_return_status := OKE_API.HANDLE_EXCEPTIONS(

1389: OKE_API.END_ACTIVITY( x_msg_count => x_msg_count,
1390: x_msg_data => x_msg_data);
1391: EXCEPTION
1392: when OKE_API.G_EXCEPTION_ERROR then
1393: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
1394: p_api_name => l_api_name,
1395: p_pkg_name => g_pkg_name,
1396: p_exc_name => 'OKE_API.G_RET_STS_ERROR',
1397: x_msg_count => x_msg_count,

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

1392: when OKE_API.G_EXCEPTION_ERROR then
1393: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
1394: p_api_name => l_api_name,
1395: p_pkg_name => g_pkg_name,
1396: p_exc_name => 'OKE_API.G_RET_STS_ERROR',
1397: x_msg_count => x_msg_count,
1398: x_msg_data => x_msg_data,
1399: p_api_type => g_api_type);
1400:

Line 1401: when OKE_API.G_EXCEPTION_UNEXPECTED_ERROR then

1397: x_msg_count => x_msg_count,
1398: x_msg_data => x_msg_data,
1399: p_api_type => g_api_type);
1400:
1401: when OKE_API.G_EXCEPTION_UNEXPECTED_ERROR then
1402: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
1403: p_api_name => l_api_name,
1404: p_pkg_name => g_pkg_name,
1405: p_exc_name => 'OKE_API.G_RET_STS_UNEXP_ERROR',

Line 1402: x_return_status := OKE_API.HANDLE_EXCEPTIONS(

1398: x_msg_data => x_msg_data,
1399: p_api_type => g_api_type);
1400:
1401: when OKE_API.G_EXCEPTION_UNEXPECTED_ERROR then
1402: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
1403: p_api_name => l_api_name,
1404: p_pkg_name => g_pkg_name,
1405: p_exc_name => 'OKE_API.G_RET_STS_UNEXP_ERROR',
1406: x_msg_count => x_msg_count,

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

1401: when OKE_API.G_EXCEPTION_UNEXPECTED_ERROR then
1402: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
1403: p_api_name => l_api_name,
1404: p_pkg_name => g_pkg_name,
1405: p_exc_name => 'OKE_API.G_RET_STS_UNEXP_ERROR',
1406: x_msg_count => x_msg_count,
1407: x_msg_data => x_msg_data,
1408: p_api_type => g_api_type);
1409:

Line 1411: x_return_status := OKE_API.HANDLE_EXCEPTIONS(

1407: x_msg_data => x_msg_data,
1408: p_api_type => g_api_type);
1409:
1410: when OTHERS then
1411: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
1412: p_api_name => l_api_name,
1413: p_pkg_name => g_pkg_name,
1414: p_exc_name => 'OTHERS',
1415: x_msg_count => x_msg_count,

Line 1423: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,

1419: END lock_standard_note;
1420:
1421: PROCEDURE lock_standard_note(
1422: p_api_version IN NUMBER,
1423: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
1424: x_return_status OUT NOCOPY VARCHAR2,
1425: x_msg_count OUT NOCOPY NUMBER,
1426: x_msg_data OUT NOCOPY VARCHAR2,
1427: p_note_tbl IN oke_note_pvt.note_tbl_type) IS

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

1427: p_note_tbl IN oke_note_pvt.note_tbl_type) IS
1428:
1429: l_api_name CONSTANT VARCHAR2(30) := 'LOCK_STANDARD_NOTE';
1430: l_api_version CONSTANT NUMBER := 1.0;
1431: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;
1432: l_overall_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;
1433: i NUMBER;
1434: BEGIN
1435: -- call START_ACTIVITY to create savepoint, check compatibility

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

1428:
1429: l_api_name CONSTANT VARCHAR2(30) := 'LOCK_STANDARD_NOTE';
1430: l_api_version CONSTANT NUMBER := 1.0;
1431: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;
1432: l_overall_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;
1433: i NUMBER;
1434: BEGIN
1435: -- call START_ACTIVITY to create savepoint, check compatibility
1436: -- and initialize message list

Line 1437: l_return_status := OKE_API.START_ACTIVITY(

1433: i NUMBER;
1434: BEGIN
1435: -- call START_ACTIVITY to create savepoint, check compatibility
1436: -- and initialize message list
1437: l_return_status := OKE_API.START_ACTIVITY(
1438: p_api_name => l_api_name,
1439: p_pkg_name => g_pkg_name,
1440: p_init_msg_list => p_init_msg_list,
1441: l_api_version => l_api_version,

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

1443: p_api_type => g_api_type,
1444: x_return_status => x_return_status);
1445:
1446: -- check if activity started successfully
1447: If (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then
1448: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1449: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then
1450: raise OKE_API.G_EXCEPTION_ERROR;
1451: End If;

Line 1448: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

1444: x_return_status => x_return_status);
1445:
1446: -- check if activity started successfully
1447: If (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then
1448: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1449: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then
1450: raise OKE_API.G_EXCEPTION_ERROR;
1451: End If;
1452:

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

1445:
1446: -- check if activity started successfully
1447: If (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then
1448: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1449: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then
1450: raise OKE_API.G_EXCEPTION_ERROR;
1451: End If;
1452:
1453: If (p_note_tbl.COUNT > 0) Then

Line 1450: raise OKE_API.G_EXCEPTION_ERROR;

1446: -- check if activity started successfully
1447: If (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then
1448: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1449: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then
1450: raise OKE_API.G_EXCEPTION_ERROR;
1451: End If;
1452:
1453: If (p_note_tbl.COUNT > 0) Then
1454: i := p_note_tbl.FIRST;

Line 1466: If x_return_status <> OKE_API.G_RET_STS_SUCCESS Then

1462: x_msg_data => x_msg_data,
1463: p_note_rec => p_note_tbl(i));
1464:
1465: -- store the highest degree of error
1466: If x_return_status <> OKE_API.G_RET_STS_SUCCESS Then
1467: If l_overall_status <> OKE_API.G_RET_STS_UNEXP_ERROR Then
1468: l_overall_status := x_return_status;
1469: End If;
1470: End If;

Line 1467: If l_overall_status <> OKE_API.G_RET_STS_UNEXP_ERROR Then

1463: p_note_rec => p_note_tbl(i));
1464:
1465: -- store the highest degree of error
1466: If x_return_status <> OKE_API.G_RET_STS_SUCCESS Then
1467: If l_overall_status <> OKE_API.G_RET_STS_UNEXP_ERROR Then
1468: l_overall_status := x_return_status;
1469: End If;
1470: End If;
1471: EXIT WHEN (i = p_note_tbl.LAST);

Line 1478: If x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR Then

1474: -- return overall status
1475: x_return_status := l_overall_status;
1476: End If;
1477:
1478: If x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR Then
1479: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1480: Elsif x_return_status = OKE_API.G_RET_STS_ERROR Then
1481: raise OKE_API.G_EXCEPTION_ERROR;
1482: End If;

Line 1479: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

1475: x_return_status := l_overall_status;
1476: End If;
1477:
1478: If x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR Then
1479: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1480: Elsif x_return_status = OKE_API.G_RET_STS_ERROR Then
1481: raise OKE_API.G_EXCEPTION_ERROR;
1482: End If;
1483:

Line 1480: Elsif x_return_status = OKE_API.G_RET_STS_ERROR Then

1476: End If;
1477:
1478: If x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR Then
1479: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1480: Elsif x_return_status = OKE_API.G_RET_STS_ERROR Then
1481: raise OKE_API.G_EXCEPTION_ERROR;
1482: End If;
1483:
1484: -- end activity

Line 1481: raise OKE_API.G_EXCEPTION_ERROR;

1477:
1478: If x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR Then
1479: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1480: Elsif x_return_status = OKE_API.G_RET_STS_ERROR Then
1481: raise OKE_API.G_EXCEPTION_ERROR;
1482: End If;
1483:
1484: -- end activity
1485: OKE_API.END_ACTIVITY( x_msg_count => x_msg_count,

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

1481: raise OKE_API.G_EXCEPTION_ERROR;
1482: End If;
1483:
1484: -- end activity
1485: OKE_API.END_ACTIVITY( x_msg_count => x_msg_count,
1486: x_msg_data => x_msg_data);
1487: EXCEPTION
1488: when OKE_API.G_EXCEPTION_ERROR then
1489: x_return_status := OKE_API.HANDLE_EXCEPTIONS(

Line 1488: when OKE_API.G_EXCEPTION_ERROR then

1484: -- end activity
1485: OKE_API.END_ACTIVITY( x_msg_count => x_msg_count,
1486: x_msg_data => x_msg_data);
1487: EXCEPTION
1488: when OKE_API.G_EXCEPTION_ERROR then
1489: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
1490: p_api_name => l_api_name,
1491: p_pkg_name => g_pkg_name,
1492: p_exc_name => 'OKE_API.G_RET_STS_ERROR',

Line 1489: x_return_status := OKE_API.HANDLE_EXCEPTIONS(

1485: OKE_API.END_ACTIVITY( x_msg_count => x_msg_count,
1486: x_msg_data => x_msg_data);
1487: EXCEPTION
1488: when OKE_API.G_EXCEPTION_ERROR then
1489: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
1490: p_api_name => l_api_name,
1491: p_pkg_name => g_pkg_name,
1492: p_exc_name => 'OKE_API.G_RET_STS_ERROR',
1493: x_msg_count => x_msg_count,

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

1488: when OKE_API.G_EXCEPTION_ERROR then
1489: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
1490: p_api_name => l_api_name,
1491: p_pkg_name => g_pkg_name,
1492: p_exc_name => 'OKE_API.G_RET_STS_ERROR',
1493: x_msg_count => x_msg_count,
1494: x_msg_data => x_msg_data,
1495: p_api_type => g_api_type);
1496:

Line 1497: when OKE_API.G_EXCEPTION_UNEXPECTED_ERROR then

1493: x_msg_count => x_msg_count,
1494: x_msg_data => x_msg_data,
1495: p_api_type => g_api_type);
1496:
1497: when OKE_API.G_EXCEPTION_UNEXPECTED_ERROR then
1498: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
1499: p_api_name => l_api_name,
1500: p_pkg_name => g_pkg_name,
1501: p_exc_name => 'OKE_API.G_RET_STS_UNEXP_ERROR',

Line 1498: x_return_status := OKE_API.HANDLE_EXCEPTIONS(

1494: x_msg_data => x_msg_data,
1495: p_api_type => g_api_type);
1496:
1497: when OKE_API.G_EXCEPTION_UNEXPECTED_ERROR then
1498: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
1499: p_api_name => l_api_name,
1500: p_pkg_name => g_pkg_name,
1501: p_exc_name => 'OKE_API.G_RET_STS_UNEXP_ERROR',
1502: x_msg_count => x_msg_count,

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

1497: when OKE_API.G_EXCEPTION_UNEXPECTED_ERROR then
1498: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
1499: p_api_name => l_api_name,
1500: p_pkg_name => g_pkg_name,
1501: p_exc_name => 'OKE_API.G_RET_STS_UNEXP_ERROR',
1502: x_msg_count => x_msg_count,
1503: x_msg_data => x_msg_data,
1504: p_api_type => g_api_type);
1505:

Line 1507: x_return_status := OKE_API.HANDLE_EXCEPTIONS(

1503: x_msg_data => x_msg_data,
1504: p_api_type => g_api_type);
1505:
1506: when OTHERS then
1507: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
1508: p_api_name => l_api_name,
1509: p_pkg_name => g_pkg_name,
1510: p_exc_name => 'OTHERS',
1511: x_msg_count => x_msg_count,