APPS.OKL_SUBSIDY_PUB dependencies on OKL_API

Line 16: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

12: x_subv_rec OUT NOCOPY subv_rec_type) IS
13:
14: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_SUBSIDY';
15: l_api_version CONSTANT NUMBER := 1.0;
16: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
17:
18: l_subv_rec subv_rec_type;
19: Begin
20: -- call START_ACTIVITY to create savepoint, check compatibility

Line 23: l_return_status := OKL_API.START_ACTIVITY(

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

Line 33: If (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then

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

Line 34: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

Line 35: Elsif (l_return_status = OKL_API.G_RET_STS_ERROR) then

31:
32: -- check if activity started successfully
33: If (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
34: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
35: Elsif (l_return_status = OKL_API.G_RET_STS_ERROR) then
36: raise OKL_API.G_EXCEPTION_ERROR;
37: End If;
38:
39: l_subv_rec := p_subv_rec;

Line 36: raise OKL_API.G_EXCEPTION_ERROR;

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

Line 51: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then

47: p_subv_rec => l_subv_rec,
48: x_subv_rec => x_subv_rec);
49:
50: -- check return status
51: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
52: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
53: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
54: raise OKL_API.G_EXCEPTION_ERROR;
55: End If;

Line 52: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

48: x_subv_rec => x_subv_rec);
49:
50: -- check return status
51: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
52: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
53: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
54: raise OKL_API.G_EXCEPTION_ERROR;
55: End If;
56:

Line 53: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then

49:
50: -- check return status
51: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
52: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
53: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
54: raise OKL_API.G_EXCEPTION_ERROR;
55: End If;
56:
57: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

Line 54: raise OKL_API.G_EXCEPTION_ERROR;

50: -- check return status
51: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
52: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
53: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
54: raise OKL_API.G_EXCEPTION_ERROR;
55: End If;
56:
57: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
58: x_msg_data => x_msg_data);

Line 57: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

53: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
54: raise OKL_API.G_EXCEPTION_ERROR;
55: End If;
56:
57: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
58: x_msg_data => x_msg_data);
59: EXCEPTION
60: when OKL_API.G_EXCEPTION_ERROR then
61: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

Line 60: when OKL_API.G_EXCEPTION_ERROR then

56:
57: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
58: x_msg_data => x_msg_data);
59: EXCEPTION
60: when OKL_API.G_EXCEPTION_ERROR then
61: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
62: p_api_name => l_api_name,
63: p_pkg_name => g_pkg_name,
64: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

Line 61: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

57: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
58: x_msg_data => x_msg_data);
59: EXCEPTION
60: when OKL_API.G_EXCEPTION_ERROR then
61: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
62: p_api_name => l_api_name,
63: p_pkg_name => g_pkg_name,
64: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
65: x_msg_count => x_msg_count,

Line 64: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

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

Line 69: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then

65: x_msg_count => x_msg_count,
66: x_msg_data => x_msg_data,
67: p_api_type => g_api_type);
68:
69: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
70: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
71: p_api_name => l_api_name,
72: p_pkg_name => g_pkg_name,
73: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 70: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

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

Line 73: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

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

Line 79: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

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

Line 101: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

97: x_subv_tbl OUT NOCOPY subv_tbl_type) IS
98:
99: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_SUBSIDY';
100: l_api_version CONSTANT NUMBER := 1.0;
101: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
102:
103: l_subv_tbl subv_tbl_type;
104: Begin
105: -- call START_ACTIVITY to create savepoint, check compatibility

Line 108: l_return_status := OKL_API.START_ACTIVITY(

104: Begin
105: -- call START_ACTIVITY to create savepoint, check compatibility
106: -- and initialize message list
107:
108: l_return_status := OKL_API.START_ACTIVITY(
109: p_api_name => l_api_name,
110: p_pkg_name => g_pkg_name,
111: p_init_msg_list => p_init_msg_list,
112: l_api_version => l_api_version,

Line 118: If (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then

114: p_api_type => g_api_type,
115: x_return_status => x_return_status);
116:
117: -- check if activity started successfully
118: If (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
119: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
120: Elsif (l_return_status = OKL_API.G_RET_STS_ERROR) then
121: raise OKL_API.G_EXCEPTION_ERROR;
122: End If;

Line 119: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

115: x_return_status => x_return_status);
116:
117: -- check if activity started successfully
118: If (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
119: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
120: Elsif (l_return_status = OKL_API.G_RET_STS_ERROR) then
121: raise OKL_API.G_EXCEPTION_ERROR;
122: End If;
123:

Line 120: Elsif (l_return_status = OKL_API.G_RET_STS_ERROR) then

116:
117: -- check if activity started successfully
118: If (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
119: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
120: Elsif (l_return_status = OKL_API.G_RET_STS_ERROR) then
121: raise OKL_API.G_EXCEPTION_ERROR;
122: End If;
123:
124: l_subv_tbl := p_subv_tbl;

Line 121: raise OKL_API.G_EXCEPTION_ERROR;

117: -- check if activity started successfully
118: If (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
119: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
120: Elsif (l_return_status = OKL_API.G_RET_STS_ERROR) then
121: raise OKL_API.G_EXCEPTION_ERROR;
122: End If;
123:
124: l_subv_tbl := p_subv_tbl;
125:

Line 136: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then

132: p_subv_tbl => l_subv_tbl,
133: x_subv_tbl => x_subv_tbl);
134:
135: -- check return status
136: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
137: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
138: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
139: raise OKL_API.G_EXCEPTION_ERROR;
140: End If;

Line 137: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

133: x_subv_tbl => x_subv_tbl);
134:
135: -- check return status
136: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
137: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
138: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
139: raise OKL_API.G_EXCEPTION_ERROR;
140: End If;
141:

Line 138: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then

134:
135: -- check return status
136: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
137: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
138: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
139: raise OKL_API.G_EXCEPTION_ERROR;
140: End If;
141:
142: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

Line 139: raise OKL_API.G_EXCEPTION_ERROR;

135: -- check return status
136: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
137: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
138: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
139: raise OKL_API.G_EXCEPTION_ERROR;
140: End If;
141:
142: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
143: x_msg_data => x_msg_data);

Line 142: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

138: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
139: raise OKL_API.G_EXCEPTION_ERROR;
140: End If;
141:
142: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
143: x_msg_data => x_msg_data);
144: EXCEPTION
145: when OKL_API.G_EXCEPTION_ERROR then
146: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

Line 145: when OKL_API.G_EXCEPTION_ERROR then

141:
142: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
143: x_msg_data => x_msg_data);
144: EXCEPTION
145: when OKL_API.G_EXCEPTION_ERROR then
146: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
147: p_api_name => l_api_name,
148: p_pkg_name => g_pkg_name,
149: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

Line 146: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

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

Line 149: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

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

Line 154: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then

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

Line 155: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

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

Line 158: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

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

Line 164: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

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

Line 185: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

181: x_subv_rec OUT NOCOPY subv_rec_type) IS
182:
183: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_SUBSIDY';
184: l_api_version CONSTANT NUMBER := 1.0;
185: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
186:
187: l_subv_rec subv_rec_type;
188: Begin
189: -- call START_ACTIVITY to create savepoint, check compatibility

Line 192: l_return_status := OKL_API.START_ACTIVITY(

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

Line 202: If (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then

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

Line 203: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

Line 204: Elsif (l_return_status = OKL_API.G_RET_STS_ERROR) then

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

Line 205: raise OKL_API.G_EXCEPTION_ERROR;

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

Line 220: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then

216: p_subv_rec => l_subv_rec,
217: x_subv_rec => x_subv_rec);
218:
219: -- check return status
220: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
221: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
222: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
223: raise OKL_API.G_EXCEPTION_ERROR;
224: End If;

Line 221: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

217: x_subv_rec => x_subv_rec);
218:
219: -- check return status
220: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
221: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
222: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
223: raise OKL_API.G_EXCEPTION_ERROR;
224: End If;
225:

Line 222: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then

218:
219: -- check return status
220: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
221: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
222: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
223: raise OKL_API.G_EXCEPTION_ERROR;
224: End If;
225:
226: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

Line 223: raise OKL_API.G_EXCEPTION_ERROR;

219: -- check return status
220: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
221: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
222: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
223: raise OKL_API.G_EXCEPTION_ERROR;
224: End If;
225:
226: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
227: x_msg_data => x_msg_data);

Line 226: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

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

Line 229: when OKL_API.G_EXCEPTION_ERROR then

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

Line 230: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

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

Line 233: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

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

Line 238: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then

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

Line 239: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

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

Line 242: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

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

Line 248: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

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

Line 268: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

264: x_subv_tbl OUT NOCOPY subv_tbl_type) IS
265:
266: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_SUBSIDY';
267: l_api_version CONSTANT NUMBER := 1.0;
268: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
269:
270: l_subv_tbl subv_tbl_type;
271: Begin
272: -- call START_ACTIVITY to create savepoint, check compatibility

Line 275: l_return_status := OKL_API.START_ACTIVITY(

271: Begin
272: -- call START_ACTIVITY to create savepoint, check compatibility
273: -- and initialize message list
274:
275: l_return_status := OKL_API.START_ACTIVITY(
276: p_api_name => l_api_name,
277: p_pkg_name => g_pkg_name,
278: p_init_msg_list => p_init_msg_list,
279: l_api_version => l_api_version,

Line 285: If (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then

281: p_api_type => g_api_type,
282: x_return_status => x_return_status);
283:
284: -- check if activity started successfully
285: If (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
286: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
287: Elsif (l_return_status = OKL_API.G_RET_STS_ERROR) then
288: raise OKL_API.G_EXCEPTION_ERROR;
289: End If;

Line 286: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

282: x_return_status => x_return_status);
283:
284: -- check if activity started successfully
285: If (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
286: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
287: Elsif (l_return_status = OKL_API.G_RET_STS_ERROR) then
288: raise OKL_API.G_EXCEPTION_ERROR;
289: End If;
290:

Line 287: Elsif (l_return_status = OKL_API.G_RET_STS_ERROR) then

283:
284: -- check if activity started successfully
285: If (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
286: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
287: Elsif (l_return_status = OKL_API.G_RET_STS_ERROR) then
288: raise OKL_API.G_EXCEPTION_ERROR;
289: End If;
290:
291: l_subv_tbl := p_subv_tbl;

Line 288: raise OKL_API.G_EXCEPTION_ERROR;

284: -- check if activity started successfully
285: If (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
286: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
287: Elsif (l_return_status = OKL_API.G_RET_STS_ERROR) then
288: raise OKL_API.G_EXCEPTION_ERROR;
289: End If;
290:
291: l_subv_tbl := p_subv_tbl;
292:

Line 303: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then

299: p_subv_tbl => l_subv_tbl,
300: x_subv_tbl => x_subv_tbl);
301:
302: -- check return status
303: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
304: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
305: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
306: raise OKL_API.G_EXCEPTION_ERROR;
307: End If;

Line 304: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

300: x_subv_tbl => x_subv_tbl);
301:
302: -- check return status
303: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
304: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
305: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
306: raise OKL_API.G_EXCEPTION_ERROR;
307: End If;
308:

Line 305: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then

301:
302: -- check return status
303: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
304: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
305: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
306: raise OKL_API.G_EXCEPTION_ERROR;
307: End If;
308:
309: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

Line 306: raise OKL_API.G_EXCEPTION_ERROR;

302: -- check return status
303: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
304: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
305: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
306: raise OKL_API.G_EXCEPTION_ERROR;
307: End If;
308:
309: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
310: x_msg_data => x_msg_data);

Line 309: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

305: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
306: raise OKL_API.G_EXCEPTION_ERROR;
307: End If;
308:
309: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
310: x_msg_data => x_msg_data);
311: EXCEPTION
312: when OKL_API.G_EXCEPTION_ERROR then
313: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

Line 312: when OKL_API.G_EXCEPTION_ERROR then

308:
309: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
310: x_msg_data => x_msg_data);
311: EXCEPTION
312: when OKL_API.G_EXCEPTION_ERROR then
313: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
314: p_api_name => l_api_name,
315: p_pkg_name => g_pkg_name,
316: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

Line 313: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

309: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
310: x_msg_data => x_msg_data);
311: EXCEPTION
312: when OKL_API.G_EXCEPTION_ERROR then
313: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
314: p_api_name => l_api_name,
315: p_pkg_name => g_pkg_name,
316: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
317: x_msg_count => x_msg_count,

Line 316: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

312: when OKL_API.G_EXCEPTION_ERROR then
313: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
314: p_api_name => l_api_name,
315: p_pkg_name => g_pkg_name,
316: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
317: x_msg_count => x_msg_count,
318: x_msg_data => x_msg_data,
319: p_api_type => g_api_type);
320:

Line 321: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then

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

Line 322: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

318: x_msg_data => x_msg_data,
319: p_api_type => g_api_type);
320:
321: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
322: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
323: p_api_name => l_api_name,
324: p_pkg_name => g_pkg_name,
325: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
326: x_msg_count => x_msg_count,

Line 325: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

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

Line 331: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

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

Line 351: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

347: p_subv_rec IN subv_rec_type) IS
348:
349: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_SUBSIDY';
350: l_api_version CONSTANT NUMBER := 1.0;
351: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
352:
353: l_subv_rec subv_rec_type;
354: Begin
355: -- call START_ACTIVITY to create savepoint, check compatibility

Line 358: l_return_status := OKL_API.START_ACTIVITY(

354: Begin
355: -- call START_ACTIVITY to create savepoint, check compatibility
356: -- and initialize message list
357:
358: l_return_status := OKL_API.START_ACTIVITY(
359: p_api_name => l_api_name,
360: p_pkg_name => g_pkg_name,
361: p_init_msg_list => p_init_msg_list,
362: l_api_version => l_api_version,

Line 368: If (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then

364: p_api_type => g_api_type,
365: x_return_status => x_return_status);
366:
367: -- check if activity started successfully
368: If (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
369: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
370: Elsif (l_return_status = OKL_API.G_RET_STS_ERROR) then
371: raise OKL_API.G_EXCEPTION_ERROR;
372: End If;

Line 369: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

365: x_return_status => x_return_status);
366:
367: -- check if activity started successfully
368: If (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
369: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
370: Elsif (l_return_status = OKL_API.G_RET_STS_ERROR) then
371: raise OKL_API.G_EXCEPTION_ERROR;
372: End If;
373:

Line 370: Elsif (l_return_status = OKL_API.G_RET_STS_ERROR) then

366:
367: -- check if activity started successfully
368: If (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
369: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
370: Elsif (l_return_status = OKL_API.G_RET_STS_ERROR) then
371: raise OKL_API.G_EXCEPTION_ERROR;
372: End If;
373:
374: l_subv_rec := p_subv_rec;

Line 371: raise OKL_API.G_EXCEPTION_ERROR;

367: -- check if activity started successfully
368: If (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
369: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
370: Elsif (l_return_status = OKL_API.G_RET_STS_ERROR) then
371: raise OKL_API.G_EXCEPTION_ERROR;
372: End If;
373:
374: l_subv_rec := p_subv_rec;
375:

Line 385: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then

381: x_msg_data => x_msg_data,
382: p_subv_rec => l_subv_rec);
383:
384: -- check return status
385: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
386: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
387: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
388: raise OKL_API.G_EXCEPTION_ERROR;
389: End If;

Line 386: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

382: p_subv_rec => l_subv_rec);
383:
384: -- check return status
385: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
386: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
387: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
388: raise OKL_API.G_EXCEPTION_ERROR;
389: End If;
390:

Line 387: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then

383:
384: -- check return status
385: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
386: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
387: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
388: raise OKL_API.G_EXCEPTION_ERROR;
389: End If;
390:
391: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

Line 388: raise OKL_API.G_EXCEPTION_ERROR;

384: -- check return status
385: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
386: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
387: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
388: raise OKL_API.G_EXCEPTION_ERROR;
389: End If;
390:
391: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
392: x_msg_data => x_msg_data);

Line 391: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

387: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
388: raise OKL_API.G_EXCEPTION_ERROR;
389: End If;
390:
391: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
392: x_msg_data => x_msg_data);
393: EXCEPTION
394: when OKL_API.G_EXCEPTION_ERROR then
395: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

Line 394: when OKL_API.G_EXCEPTION_ERROR then

390:
391: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
392: x_msg_data => x_msg_data);
393: EXCEPTION
394: when OKL_API.G_EXCEPTION_ERROR then
395: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
396: p_api_name => l_api_name,
397: p_pkg_name => g_pkg_name,
398: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

Line 395: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

391: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
392: x_msg_data => x_msg_data);
393: EXCEPTION
394: when OKL_API.G_EXCEPTION_ERROR then
395: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
396: p_api_name => l_api_name,
397: p_pkg_name => g_pkg_name,
398: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
399: x_msg_count => x_msg_count,

Line 398: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

394: when OKL_API.G_EXCEPTION_ERROR then
395: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
396: p_api_name => l_api_name,
397: p_pkg_name => g_pkg_name,
398: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
399: x_msg_count => x_msg_count,
400: x_msg_data => x_msg_data,
401: p_api_type => g_api_type);
402:

Line 403: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then

399: x_msg_count => x_msg_count,
400: x_msg_data => x_msg_data,
401: p_api_type => g_api_type);
402:
403: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
404: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
405: p_api_name => l_api_name,
406: p_pkg_name => g_pkg_name,
407: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 404: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

400: x_msg_data => x_msg_data,
401: p_api_type => g_api_type);
402:
403: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
404: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
405: p_api_name => l_api_name,
406: p_pkg_name => g_pkg_name,
407: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
408: x_msg_count => x_msg_count,

Line 407: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

403: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
404: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
405: p_api_name => l_api_name,
406: p_pkg_name => g_pkg_name,
407: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
408: x_msg_count => x_msg_count,
409: x_msg_data => x_msg_data,
410: p_api_type => g_api_type);
411:

Line 413: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

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

Line 433: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

429: p_subv_tbl IN subv_tbl_type) Is
430:
431: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_SUBSIDY';
432: l_api_version CONSTANT NUMBER := 1.0;
433: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
434:
435: l_subv_tbl subv_tbl_type;
436: Begin
437: -- call START_ACTIVITY to create savepoint, check compatibility

Line 440: l_return_status := OKL_API.START_ACTIVITY(

436: Begin
437: -- call START_ACTIVITY to create savepoint, check compatibility
438: -- and initialize message list
439:
440: l_return_status := OKL_API.START_ACTIVITY(
441: p_api_name => l_api_name,
442: p_pkg_name => g_pkg_name,
443: p_init_msg_list => p_init_msg_list,
444: l_api_version => l_api_version,

Line 450: If (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then

446: p_api_type => g_api_type,
447: x_return_status => x_return_status);
448:
449: -- check if activity started successfully
450: If (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
451: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
452: Elsif (l_return_status = OKL_API.G_RET_STS_ERROR) then
453: raise OKL_API.G_EXCEPTION_ERROR;
454: End If;

Line 451: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

447: x_return_status => x_return_status);
448:
449: -- check if activity started successfully
450: If (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
451: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
452: Elsif (l_return_status = OKL_API.G_RET_STS_ERROR) then
453: raise OKL_API.G_EXCEPTION_ERROR;
454: End If;
455:

Line 452: Elsif (l_return_status = OKL_API.G_RET_STS_ERROR) then

448:
449: -- check if activity started successfully
450: If (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
451: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
452: Elsif (l_return_status = OKL_API.G_RET_STS_ERROR) then
453: raise OKL_API.G_EXCEPTION_ERROR;
454: End If;
455:
456: l_subv_tbl := p_subv_tbl;

Line 453: raise OKL_API.G_EXCEPTION_ERROR;

449: -- check if activity started successfully
450: If (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
451: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
452: Elsif (l_return_status = OKL_API.G_RET_STS_ERROR) then
453: raise OKL_API.G_EXCEPTION_ERROR;
454: End If;
455:
456: l_subv_tbl := p_subv_tbl;
457:

Line 467: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then

463: x_msg_data => x_msg_data,
464: p_subv_tbl => l_subv_tbl);
465:
466: -- check return status
467: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
468: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
469: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
470: raise OKL_API.G_EXCEPTION_ERROR;
471: End If;

Line 468: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

464: p_subv_tbl => l_subv_tbl);
465:
466: -- check return status
467: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
468: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
469: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
470: raise OKL_API.G_EXCEPTION_ERROR;
471: End If;
472:

Line 469: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then

465:
466: -- check return status
467: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
468: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
469: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
470: raise OKL_API.G_EXCEPTION_ERROR;
471: End If;
472:
473: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

Line 470: raise OKL_API.G_EXCEPTION_ERROR;

466: -- check return status
467: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
468: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
469: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
470: raise OKL_API.G_EXCEPTION_ERROR;
471: End If;
472:
473: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
474: x_msg_data => x_msg_data);

Line 473: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

469: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
470: raise OKL_API.G_EXCEPTION_ERROR;
471: End If;
472:
473: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
474: x_msg_data => x_msg_data);
475: EXCEPTION
476: when OKL_API.G_EXCEPTION_ERROR then
477: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

Line 476: when OKL_API.G_EXCEPTION_ERROR then

472:
473: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
474: x_msg_data => x_msg_data);
475: EXCEPTION
476: when OKL_API.G_EXCEPTION_ERROR then
477: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
478: p_api_name => l_api_name,
479: p_pkg_name => g_pkg_name,
480: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

Line 477: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

473: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
474: x_msg_data => x_msg_data);
475: EXCEPTION
476: when OKL_API.G_EXCEPTION_ERROR then
477: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
478: p_api_name => l_api_name,
479: p_pkg_name => g_pkg_name,
480: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
481: x_msg_count => x_msg_count,

Line 480: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

476: when OKL_API.G_EXCEPTION_ERROR then
477: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
478: p_api_name => l_api_name,
479: p_pkg_name => g_pkg_name,
480: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
481: x_msg_count => x_msg_count,
482: x_msg_data => x_msg_data,
483: p_api_type => g_api_type);
484:

Line 485: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then

481: x_msg_count => x_msg_count,
482: x_msg_data => x_msg_data,
483: p_api_type => g_api_type);
484:
485: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
486: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
487: p_api_name => l_api_name,
488: p_pkg_name => g_pkg_name,
489: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 486: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

482: x_msg_data => x_msg_data,
483: p_api_type => g_api_type);
484:
485: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
486: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
487: p_api_name => l_api_name,
488: p_pkg_name => g_pkg_name,
489: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
490: x_msg_count => x_msg_count,

Line 489: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

485: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
486: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
487: p_api_name => l_api_name,
488: p_pkg_name => g_pkg_name,
489: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
490: x_msg_count => x_msg_count,
491: x_msg_data => x_msg_data,
492: p_api_type => g_api_type);
493:

Line 495: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

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

Line 514: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

510: p_subv_rec IN subv_rec_type) IS
511:
512: l_api_name CONSTANT VARCHAR2(30) := 'LOCK_SUBSIDY';
513: l_api_version CONSTANT NUMBER := 1.0;
514: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
515:
516: l_subv_rec subv_rec_type;
517: Begin
518: -- call START_ACTIVITY to create savepoint, check compatibility

Line 521: l_return_status := OKL_API.START_ACTIVITY(

517: Begin
518: -- call START_ACTIVITY to create savepoint, check compatibility
519: -- and initialize message list
520:
521: l_return_status := OKL_API.START_ACTIVITY(
522: p_api_name => l_api_name,
523: p_pkg_name => g_pkg_name,
524: p_init_msg_list => p_init_msg_list,
525: l_api_version => l_api_version,

Line 531: If (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then

527: p_api_type => g_api_type,
528: x_return_status => x_return_status);
529:
530: -- check if activity started successfully
531: If (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
532: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
533: Elsif (l_return_status = OKL_API.G_RET_STS_ERROR) then
534: raise OKL_API.G_EXCEPTION_ERROR;
535: End If;

Line 532: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

528: x_return_status => x_return_status);
529:
530: -- check if activity started successfully
531: If (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
532: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
533: Elsif (l_return_status = OKL_API.G_RET_STS_ERROR) then
534: raise OKL_API.G_EXCEPTION_ERROR;
535: End If;
536:

Line 533: Elsif (l_return_status = OKL_API.G_RET_STS_ERROR) then

529:
530: -- check if activity started successfully
531: If (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
532: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
533: Elsif (l_return_status = OKL_API.G_RET_STS_ERROR) then
534: raise OKL_API.G_EXCEPTION_ERROR;
535: End If;
536:
537: l_subv_rec := p_subv_rec;

Line 534: raise OKL_API.G_EXCEPTION_ERROR;

530: -- check if activity started successfully
531: If (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
532: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
533: Elsif (l_return_status = OKL_API.G_RET_STS_ERROR) then
534: raise OKL_API.G_EXCEPTION_ERROR;
535: End If;
536:
537: l_subv_rec := p_subv_rec;
538:

Line 548: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then

544: x_msg_data => x_msg_data,
545: p_subv_rec => l_subv_rec);
546:
547: -- check return status
548: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
549: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
550: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
551: raise OKL_API.G_EXCEPTION_ERROR;
552: End If;

Line 549: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

545: p_subv_rec => l_subv_rec);
546:
547: -- check return status
548: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
549: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
550: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
551: raise OKL_API.G_EXCEPTION_ERROR;
552: End If;
553:

Line 550: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then

546:
547: -- check return status
548: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
549: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
550: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
551: raise OKL_API.G_EXCEPTION_ERROR;
552: End If;
553:
554: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

Line 551: raise OKL_API.G_EXCEPTION_ERROR;

547: -- check return status
548: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
549: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
550: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
551: raise OKL_API.G_EXCEPTION_ERROR;
552: End If;
553:
554: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
555: x_msg_data => x_msg_data);

Line 554: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

550: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
551: raise OKL_API.G_EXCEPTION_ERROR;
552: End If;
553:
554: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
555: x_msg_data => x_msg_data);
556: EXCEPTION
557: when OKL_API.G_EXCEPTION_ERROR then
558: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

Line 557: when OKL_API.G_EXCEPTION_ERROR then

553:
554: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
555: x_msg_data => x_msg_data);
556: EXCEPTION
557: when OKL_API.G_EXCEPTION_ERROR then
558: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
559: p_api_name => l_api_name,
560: p_pkg_name => g_pkg_name,
561: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

Line 558: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

554: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
555: x_msg_data => x_msg_data);
556: EXCEPTION
557: when OKL_API.G_EXCEPTION_ERROR then
558: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
559: p_api_name => l_api_name,
560: p_pkg_name => g_pkg_name,
561: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
562: x_msg_count => x_msg_count,

Line 561: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

557: when OKL_API.G_EXCEPTION_ERROR then
558: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
559: p_api_name => l_api_name,
560: p_pkg_name => g_pkg_name,
561: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
562: x_msg_count => x_msg_count,
563: x_msg_data => x_msg_data,
564: p_api_type => g_api_type);
565:

Line 566: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then

562: x_msg_count => x_msg_count,
563: x_msg_data => x_msg_data,
564: p_api_type => g_api_type);
565:
566: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
567: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
568: p_api_name => l_api_name,
569: p_pkg_name => g_pkg_name,
570: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 567: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

563: x_msg_data => x_msg_data,
564: p_api_type => g_api_type);
565:
566: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
567: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
568: p_api_name => l_api_name,
569: p_pkg_name => g_pkg_name,
570: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
571: x_msg_count => x_msg_count,

Line 570: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

566: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
567: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
568: p_api_name => l_api_name,
569: p_pkg_name => g_pkg_name,
570: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
571: x_msg_count => x_msg_count,
572: x_msg_data => x_msg_data,
573: p_api_type => g_api_type);
574:

Line 576: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

572: x_msg_data => x_msg_data,
573: p_api_type => g_api_type);
574:
575: when OTHERS then
576: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
577: p_api_name => l_api_name,
578: p_pkg_name => g_pkg_name,
579: p_exc_name => 'OTHERS',
580: x_msg_count => x_msg_count,

Line 595: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

591: p_subv_tbl IN subv_tbl_type) IS
592:
593: l_api_name CONSTANT VARCHAR2(30) := 'LOCK_SUBSIDY';
594: l_api_version CONSTANT NUMBER := 1.0;
595: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
596:
597: l_subv_tbl subv_tbl_type;
598: Begin
599: -- call START_ACTIVITY to create savepoint, check compatibility

Line 602: l_return_status := OKL_API.START_ACTIVITY(

598: Begin
599: -- call START_ACTIVITY to create savepoint, check compatibility
600: -- and initialize message list
601:
602: l_return_status := OKL_API.START_ACTIVITY(
603: p_api_name => l_api_name,
604: p_pkg_name => g_pkg_name,
605: p_init_msg_list => p_init_msg_list,
606: l_api_version => l_api_version,

Line 612: If (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then

608: p_api_type => g_api_type,
609: x_return_status => x_return_status);
610:
611: -- check if activity started successfully
612: If (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
613: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
614: Elsif (l_return_status = OKL_API.G_RET_STS_ERROR) then
615: raise OKL_API.G_EXCEPTION_ERROR;
616: End If;

Line 613: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

609: x_return_status => x_return_status);
610:
611: -- check if activity started successfully
612: If (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
613: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
614: Elsif (l_return_status = OKL_API.G_RET_STS_ERROR) then
615: raise OKL_API.G_EXCEPTION_ERROR;
616: End If;
617:

Line 614: Elsif (l_return_status = OKL_API.G_RET_STS_ERROR) then

610:
611: -- check if activity started successfully
612: If (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
613: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
614: Elsif (l_return_status = OKL_API.G_RET_STS_ERROR) then
615: raise OKL_API.G_EXCEPTION_ERROR;
616: End If;
617:
618: l_subv_tbl := p_subv_tbl;

Line 615: raise OKL_API.G_EXCEPTION_ERROR;

611: -- check if activity started successfully
612: If (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
613: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
614: Elsif (l_return_status = OKL_API.G_RET_STS_ERROR) then
615: raise OKL_API.G_EXCEPTION_ERROR;
616: End If;
617:
618: l_subv_tbl := p_subv_tbl;
619:

Line 629: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then

625: x_msg_data => x_msg_data,
626: p_subv_tbl => l_subv_tbl);
627:
628: -- check return status
629: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
630: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
631: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
632: raise OKL_API.G_EXCEPTION_ERROR;
633: End If;

Line 630: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

626: p_subv_tbl => l_subv_tbl);
627:
628: -- check return status
629: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
630: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
631: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
632: raise OKL_API.G_EXCEPTION_ERROR;
633: End If;
634:

Line 631: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then

627:
628: -- check return status
629: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
630: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
631: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
632: raise OKL_API.G_EXCEPTION_ERROR;
633: End If;
634:
635: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

Line 632: raise OKL_API.G_EXCEPTION_ERROR;

628: -- check return status
629: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
630: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
631: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
632: raise OKL_API.G_EXCEPTION_ERROR;
633: End If;
634:
635: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
636: x_msg_data => x_msg_data);

Line 635: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

631: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
632: raise OKL_API.G_EXCEPTION_ERROR;
633: End If;
634:
635: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
636: x_msg_data => x_msg_data);
637: EXCEPTION
638: when OKL_API.G_EXCEPTION_ERROR then
639: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

Line 638: when OKL_API.G_EXCEPTION_ERROR then

634:
635: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
636: x_msg_data => x_msg_data);
637: EXCEPTION
638: when OKL_API.G_EXCEPTION_ERROR then
639: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
640: p_api_name => l_api_name,
641: p_pkg_name => g_pkg_name,
642: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

Line 639: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

635: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
636: x_msg_data => x_msg_data);
637: EXCEPTION
638: when OKL_API.G_EXCEPTION_ERROR then
639: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
640: p_api_name => l_api_name,
641: p_pkg_name => g_pkg_name,
642: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
643: x_msg_count => x_msg_count,

Line 642: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

638: when OKL_API.G_EXCEPTION_ERROR then
639: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
640: p_api_name => l_api_name,
641: p_pkg_name => g_pkg_name,
642: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
643: x_msg_count => x_msg_count,
644: x_msg_data => x_msg_data,
645: p_api_type => g_api_type);
646:

Line 647: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then

643: x_msg_count => x_msg_count,
644: x_msg_data => x_msg_data,
645: p_api_type => g_api_type);
646:
647: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
648: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
649: p_api_name => l_api_name,
650: p_pkg_name => g_pkg_name,
651: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 648: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

644: x_msg_data => x_msg_data,
645: p_api_type => g_api_type);
646:
647: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
648: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
649: p_api_name => l_api_name,
650: p_pkg_name => g_pkg_name,
651: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
652: x_msg_count => x_msg_count,

Line 651: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

647: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
648: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
649: p_api_name => l_api_name,
650: p_pkg_name => g_pkg_name,
651: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
652: x_msg_count => x_msg_count,
653: x_msg_data => x_msg_data,
654: p_api_type => g_api_type);
655:

Line 657: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

653: x_msg_data => x_msg_data,
654: p_api_type => g_api_type);
655:
656: when OTHERS then
657: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
658: p_api_name => l_api_name,
659: p_pkg_name => g_pkg_name,
660: p_exc_name => 'OTHERS',
661: x_msg_count => x_msg_count,

Line 679: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

675:
676:
677: l_api_name CONSTANT VARCHAR2(30) := 'VALIDATE_SUBSIDY';
678: l_api_version CONSTANT NUMBER := 1.0;
679: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
680:
681: l_subv_rec subv_rec_type;
682: Begin
683: -- call START_ACTIVITY to create savepoint, check compatibility

Line 686: l_return_status := OKL_API.START_ACTIVITY(

682: Begin
683: -- call START_ACTIVITY to create savepoint, check compatibility
684: -- and initialize message list
685:
686: l_return_status := OKL_API.START_ACTIVITY(
687: p_api_name => l_api_name,
688: p_pkg_name => g_pkg_name,
689: p_init_msg_list => p_init_msg_list,
690: l_api_version => l_api_version,

Line 696: If (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then

692: p_api_type => g_api_type,
693: x_return_status => x_return_status);
694:
695: -- check if activity started successfully
696: If (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
697: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
698: Elsif (l_return_status = OKL_API.G_RET_STS_ERROR) then
699: raise OKL_API.G_EXCEPTION_ERROR;
700: End If;

Line 697: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

693: x_return_status => x_return_status);
694:
695: -- check if activity started successfully
696: If (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
697: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
698: Elsif (l_return_status = OKL_API.G_RET_STS_ERROR) then
699: raise OKL_API.G_EXCEPTION_ERROR;
700: End If;
701:

Line 698: Elsif (l_return_status = OKL_API.G_RET_STS_ERROR) then

694:
695: -- check if activity started successfully
696: If (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
697: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
698: Elsif (l_return_status = OKL_API.G_RET_STS_ERROR) then
699: raise OKL_API.G_EXCEPTION_ERROR;
700: End If;
701:
702: l_subv_rec := p_subv_rec;

Line 699: raise OKL_API.G_EXCEPTION_ERROR;

695: -- check if activity started successfully
696: If (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
697: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
698: Elsif (l_return_status = OKL_API.G_RET_STS_ERROR) then
699: raise OKL_API.G_EXCEPTION_ERROR;
700: End If;
701:
702: l_subv_rec := p_subv_rec;
703:

Line 713: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then

709: x_msg_data => x_msg_data,
710: p_subv_rec => l_subv_rec);
711:
712: -- check return status
713: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
714: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
715: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
716: raise OKL_API.G_EXCEPTION_ERROR;
717: End If;

Line 714: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

710: p_subv_rec => l_subv_rec);
711:
712: -- check return status
713: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
714: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
715: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
716: raise OKL_API.G_EXCEPTION_ERROR;
717: End If;
718:

Line 715: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then

711:
712: -- check return status
713: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
714: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
715: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
716: raise OKL_API.G_EXCEPTION_ERROR;
717: End If;
718:
719: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

Line 716: raise OKL_API.G_EXCEPTION_ERROR;

712: -- check return status
713: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
714: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
715: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
716: raise OKL_API.G_EXCEPTION_ERROR;
717: End If;
718:
719: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
720: x_msg_data => x_msg_data);

Line 719: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

715: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
716: raise OKL_API.G_EXCEPTION_ERROR;
717: End If;
718:
719: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
720: x_msg_data => x_msg_data);
721: EXCEPTION
722: when OKL_API.G_EXCEPTION_ERROR then
723: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

Line 722: when OKL_API.G_EXCEPTION_ERROR then

718:
719: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
720: x_msg_data => x_msg_data);
721: EXCEPTION
722: when OKL_API.G_EXCEPTION_ERROR then
723: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
724: p_api_name => l_api_name,
725: p_pkg_name => g_pkg_name,
726: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

Line 723: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

719: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
720: x_msg_data => x_msg_data);
721: EXCEPTION
722: when OKL_API.G_EXCEPTION_ERROR then
723: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
724: p_api_name => l_api_name,
725: p_pkg_name => g_pkg_name,
726: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
727: x_msg_count => x_msg_count,

Line 726: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

722: when OKL_API.G_EXCEPTION_ERROR then
723: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
724: p_api_name => l_api_name,
725: p_pkg_name => g_pkg_name,
726: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
727: x_msg_count => x_msg_count,
728: x_msg_data => x_msg_data,
729: p_api_type => g_api_type);
730:

Line 731: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then

727: x_msg_count => x_msg_count,
728: x_msg_data => x_msg_data,
729: p_api_type => g_api_type);
730:
731: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
732: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
733: p_api_name => l_api_name,
734: p_pkg_name => g_pkg_name,
735: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 732: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

728: x_msg_data => x_msg_data,
729: p_api_type => g_api_type);
730:
731: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
732: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
733: p_api_name => l_api_name,
734: p_pkg_name => g_pkg_name,
735: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
736: x_msg_count => x_msg_count,

Line 735: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

731: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
732: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
733: p_api_name => l_api_name,
734: p_pkg_name => g_pkg_name,
735: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
736: x_msg_count => x_msg_count,
737: x_msg_data => x_msg_data,
738: p_api_type => g_api_type);
739:

Line 741: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

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

Line 760: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

756: p_subv_tbl IN subv_tbl_type) IS
757:
758: l_api_name CONSTANT VARCHAR2(30) := 'VALIDATE_SUBSIDY';
759: l_api_version CONSTANT NUMBER := 1.0;
760: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
761:
762: l_subv_tbl subv_tbl_type;
763: Begin
764: -- call START_ACTIVITY to create savepoint, check compatibility

Line 767: l_return_status := OKL_API.START_ACTIVITY(

763: Begin
764: -- call START_ACTIVITY to create savepoint, check compatibility
765: -- and initialize message list
766:
767: l_return_status := OKL_API.START_ACTIVITY(
768: p_api_name => l_api_name,
769: p_pkg_name => g_pkg_name,
770: p_init_msg_list => p_init_msg_list,
771: l_api_version => l_api_version,

Line 777: If (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then

773: p_api_type => g_api_type,
774: x_return_status => x_return_status);
775:
776: -- check if activity started successfully
777: If (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
778: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
779: Elsif (l_return_status = OKL_API.G_RET_STS_ERROR) then
780: raise OKL_API.G_EXCEPTION_ERROR;
781: End If;

Line 778: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

774: x_return_status => x_return_status);
775:
776: -- check if activity started successfully
777: If (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
778: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
779: Elsif (l_return_status = OKL_API.G_RET_STS_ERROR) then
780: raise OKL_API.G_EXCEPTION_ERROR;
781: End If;
782:

Line 779: Elsif (l_return_status = OKL_API.G_RET_STS_ERROR) then

775:
776: -- check if activity started successfully
777: If (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
778: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
779: Elsif (l_return_status = OKL_API.G_RET_STS_ERROR) then
780: raise OKL_API.G_EXCEPTION_ERROR;
781: End If;
782:
783: l_subv_tbl := p_subv_tbl;

Line 780: raise OKL_API.G_EXCEPTION_ERROR;

776: -- check if activity started successfully
777: If (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
778: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
779: Elsif (l_return_status = OKL_API.G_RET_STS_ERROR) then
780: raise OKL_API.G_EXCEPTION_ERROR;
781: End If;
782:
783: l_subv_tbl := p_subv_tbl;
784:

Line 794: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then

790: x_msg_data => x_msg_data,
791: p_subv_tbl => l_subv_tbl);
792:
793: -- check return status
794: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
795: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
796: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
797: raise OKL_API.G_EXCEPTION_ERROR;
798: End If;

Line 795: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

791: p_subv_tbl => l_subv_tbl);
792:
793: -- check return status
794: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
795: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
796: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
797: raise OKL_API.G_EXCEPTION_ERROR;
798: End If;
799:

Line 796: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then

792:
793: -- check return status
794: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
795: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
796: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
797: raise OKL_API.G_EXCEPTION_ERROR;
798: End If;
799:
800: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

Line 797: raise OKL_API.G_EXCEPTION_ERROR;

793: -- check return status
794: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
795: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
796: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
797: raise OKL_API.G_EXCEPTION_ERROR;
798: End If;
799:
800: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
801: x_msg_data => x_msg_data);

Line 800: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

796: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
797: raise OKL_API.G_EXCEPTION_ERROR;
798: End If;
799:
800: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
801: x_msg_data => x_msg_data);
802: EXCEPTION
803: when OKL_API.G_EXCEPTION_ERROR then
804: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

Line 803: when OKL_API.G_EXCEPTION_ERROR then

799:
800: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
801: x_msg_data => x_msg_data);
802: EXCEPTION
803: when OKL_API.G_EXCEPTION_ERROR then
804: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
805: p_api_name => l_api_name,
806: p_pkg_name => g_pkg_name,
807: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

Line 804: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

800: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
801: x_msg_data => x_msg_data);
802: EXCEPTION
803: when OKL_API.G_EXCEPTION_ERROR then
804: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
805: p_api_name => l_api_name,
806: p_pkg_name => g_pkg_name,
807: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
808: x_msg_count => x_msg_count,

Line 807: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

803: when OKL_API.G_EXCEPTION_ERROR then
804: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
805: p_api_name => l_api_name,
806: p_pkg_name => g_pkg_name,
807: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
808: x_msg_count => x_msg_count,
809: x_msg_data => x_msg_data,
810: p_api_type => g_api_type);
811:

Line 812: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then

808: x_msg_count => x_msg_count,
809: x_msg_data => x_msg_data,
810: p_api_type => g_api_type);
811:
812: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
813: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
814: p_api_name => l_api_name,
815: p_pkg_name => g_pkg_name,
816: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 813: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

809: x_msg_data => x_msg_data,
810: p_api_type => g_api_type);
811:
812: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
813: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
814: p_api_name => l_api_name,
815: p_pkg_name => g_pkg_name,
816: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
817: x_msg_count => x_msg_count,

Line 816: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

812: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
813: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
814: p_api_name => l_api_name,
815: p_pkg_name => g_pkg_name,
816: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
817: x_msg_count => x_msg_count,
818: x_msg_data => x_msg_data,
819: p_api_type => g_api_type);
820:

Line 822: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

818: x_msg_data => x_msg_data,
819: p_api_type => g_api_type);
820:
821: when OTHERS then
822: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
823: p_api_name => l_api_name,
824: p_pkg_name => g_pkg_name,
825: p_exc_name => 'OTHERS',
826: x_msg_count => x_msg_count,

Line 843: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

839: x_sucv_rec OUT NOCOPY sucv_rec_type) IS
840:
841: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_SUBSIDY_CRITERIA';
842: l_api_version CONSTANT NUMBER := 1.0;
843: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
844:
845: l_sucv_rec sucv_rec_type;
846: Begin
847: -- call START_ACTIVITY to create savepoint, check compatibility

Line 850: l_return_status := OKL_API.START_ACTIVITY(

846: Begin
847: -- call START_ACTIVITY to create savepoint, check compatibility
848: -- and initialize message list
849:
850: l_return_status := OKL_API.START_ACTIVITY(
851: p_api_name => l_api_name,
852: p_pkg_name => g_pkg_name,
853: p_init_msg_list => p_init_msg_list,
854: l_api_version => l_api_version,

Line 860: If (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then

856: p_api_type => g_api_type,
857: x_return_status => x_return_status);
858:
859: -- check if activity started successfully
860: If (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
861: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
862: Elsif (l_return_status = OKL_API.G_RET_STS_ERROR) then
863: raise OKL_API.G_EXCEPTION_ERROR;
864: End If;

Line 861: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

857: x_return_status => x_return_status);
858:
859: -- check if activity started successfully
860: If (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
861: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
862: Elsif (l_return_status = OKL_API.G_RET_STS_ERROR) then
863: raise OKL_API.G_EXCEPTION_ERROR;
864: End If;
865:

Line 862: Elsif (l_return_status = OKL_API.G_RET_STS_ERROR) then

858:
859: -- check if activity started successfully
860: If (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
861: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
862: Elsif (l_return_status = OKL_API.G_RET_STS_ERROR) then
863: raise OKL_API.G_EXCEPTION_ERROR;
864: End If;
865:
866: l_sucv_rec := p_sucv_rec;

Line 863: raise OKL_API.G_EXCEPTION_ERROR;

859: -- check if activity started successfully
860: If (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
861: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
862: Elsif (l_return_status = OKL_API.G_RET_STS_ERROR) then
863: raise OKL_API.G_EXCEPTION_ERROR;
864: End If;
865:
866: l_sucv_rec := p_sucv_rec;
867:

Line 878: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then

874: p_sucv_rec => l_sucv_rec,
875: x_sucv_rec => x_sucv_rec);
876:
877: -- check return status
878: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
879: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
880: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
881: raise OKL_API.G_EXCEPTION_ERROR;
882: End If;

Line 879: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

875: x_sucv_rec => x_sucv_rec);
876:
877: -- check return status
878: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
879: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
880: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
881: raise OKL_API.G_EXCEPTION_ERROR;
882: End If;
883:

Line 880: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then

876:
877: -- check return status
878: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
879: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
880: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
881: raise OKL_API.G_EXCEPTION_ERROR;
882: End If;
883:
884: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

Line 881: raise OKL_API.G_EXCEPTION_ERROR;

877: -- check return status
878: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
879: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
880: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
881: raise OKL_API.G_EXCEPTION_ERROR;
882: End If;
883:
884: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
885: x_msg_data => x_msg_data);

Line 884: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

880: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
881: raise OKL_API.G_EXCEPTION_ERROR;
882: End If;
883:
884: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
885: x_msg_data => x_msg_data);
886: EXCEPTION
887: when OKL_API.G_EXCEPTION_ERROR then
888: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

Line 887: when OKL_API.G_EXCEPTION_ERROR then

883:
884: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
885: x_msg_data => x_msg_data);
886: EXCEPTION
887: when OKL_API.G_EXCEPTION_ERROR then
888: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
889: p_api_name => l_api_name,
890: p_pkg_name => g_pkg_name,
891: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

Line 888: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

884: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
885: x_msg_data => x_msg_data);
886: EXCEPTION
887: when OKL_API.G_EXCEPTION_ERROR then
888: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
889: p_api_name => l_api_name,
890: p_pkg_name => g_pkg_name,
891: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
892: x_msg_count => x_msg_count,

Line 891: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

887: when OKL_API.G_EXCEPTION_ERROR then
888: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
889: p_api_name => l_api_name,
890: p_pkg_name => g_pkg_name,
891: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
892: x_msg_count => x_msg_count,
893: x_msg_data => x_msg_data,
894: p_api_type => g_api_type);
895:

Line 896: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then

892: x_msg_count => x_msg_count,
893: x_msg_data => x_msg_data,
894: p_api_type => g_api_type);
895:
896: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
897: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
898: p_api_name => l_api_name,
899: p_pkg_name => g_pkg_name,
900: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 897: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

893: x_msg_data => x_msg_data,
894: p_api_type => g_api_type);
895:
896: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
897: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
898: p_api_name => l_api_name,
899: p_pkg_name => g_pkg_name,
900: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
901: x_msg_count => x_msg_count,

Line 900: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

896: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
897: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
898: p_api_name => l_api_name,
899: p_pkg_name => g_pkg_name,
900: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
901: x_msg_count => x_msg_count,
902: x_msg_data => x_msg_data,
903: p_api_type => g_api_type);
904:

Line 906: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

902: x_msg_data => x_msg_data,
903: p_api_type => g_api_type);
904:
905: when OTHERS then
906: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
907: p_api_name => l_api_name,
908: p_pkg_name => g_pkg_name,
909: p_exc_name => 'OTHERS',
910: x_msg_count => x_msg_count,

Line 928: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

924: x_sucv_tbl OUT NOCOPY sucv_tbl_type) IS
925:
926: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_SUBSIDY_CRITERIA';
927: l_api_version CONSTANT NUMBER := 1.0;
928: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
929:
930: l_sucv_tbl sucv_tbl_type;
931: Begin
932: -- call START_ACTIVITY to create savepoint, check compatibility

Line 935: l_return_status := OKL_API.START_ACTIVITY(

931: Begin
932: -- call START_ACTIVITY to create savepoint, check compatibility
933: -- and initialize message list
934:
935: l_return_status := OKL_API.START_ACTIVITY(
936: p_api_name => l_api_name,
937: p_pkg_name => g_pkg_name,
938: p_init_msg_list => p_init_msg_list,
939: l_api_version => l_api_version,

Line 945: If (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then

941: p_api_type => g_api_type,
942: x_return_status => x_return_status);
943:
944: -- check if activity started successfully
945: If (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
946: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
947: Elsif (l_return_status = OKL_API.G_RET_STS_ERROR) then
948: raise OKL_API.G_EXCEPTION_ERROR;
949: End If;

Line 946: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

942: x_return_status => x_return_status);
943:
944: -- check if activity started successfully
945: If (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
946: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
947: Elsif (l_return_status = OKL_API.G_RET_STS_ERROR) then
948: raise OKL_API.G_EXCEPTION_ERROR;
949: End If;
950:

Line 947: Elsif (l_return_status = OKL_API.G_RET_STS_ERROR) then

943:
944: -- check if activity started successfully
945: If (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
946: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
947: Elsif (l_return_status = OKL_API.G_RET_STS_ERROR) then
948: raise OKL_API.G_EXCEPTION_ERROR;
949: End If;
950:
951: l_sucv_tbl := p_sucv_tbl;

Line 948: raise OKL_API.G_EXCEPTION_ERROR;

944: -- check if activity started successfully
945: If (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
946: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
947: Elsif (l_return_status = OKL_API.G_RET_STS_ERROR) then
948: raise OKL_API.G_EXCEPTION_ERROR;
949: End If;
950:
951: l_sucv_tbl := p_sucv_tbl;
952:

Line 963: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then

959: p_sucv_tbl => l_sucv_tbl,
960: x_sucv_tbl => x_sucv_tbl);
961:
962: -- check return status
963: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
964: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
965: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
966: raise OKL_API.G_EXCEPTION_ERROR;
967: End If;

Line 964: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

960: x_sucv_tbl => x_sucv_tbl);
961:
962: -- check return status
963: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
964: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
965: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
966: raise OKL_API.G_EXCEPTION_ERROR;
967: End If;
968:

Line 965: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then

961:
962: -- check return status
963: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
964: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
965: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
966: raise OKL_API.G_EXCEPTION_ERROR;
967: End If;
968:
969: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

Line 966: raise OKL_API.G_EXCEPTION_ERROR;

962: -- check return status
963: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
964: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
965: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
966: raise OKL_API.G_EXCEPTION_ERROR;
967: End If;
968:
969: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
970: x_msg_data => x_msg_data);

Line 969: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

965: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
966: raise OKL_API.G_EXCEPTION_ERROR;
967: End If;
968:
969: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
970: x_msg_data => x_msg_data);
971: EXCEPTION
972: when OKL_API.G_EXCEPTION_ERROR then
973: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

Line 972: when OKL_API.G_EXCEPTION_ERROR then

968:
969: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
970: x_msg_data => x_msg_data);
971: EXCEPTION
972: when OKL_API.G_EXCEPTION_ERROR then
973: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
974: p_api_name => l_api_name,
975: p_pkg_name => g_pkg_name,
976: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

Line 973: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

969: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
970: x_msg_data => x_msg_data);
971: EXCEPTION
972: when OKL_API.G_EXCEPTION_ERROR then
973: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
974: p_api_name => l_api_name,
975: p_pkg_name => g_pkg_name,
976: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
977: x_msg_count => x_msg_count,

Line 976: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

972: when OKL_API.G_EXCEPTION_ERROR then
973: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
974: p_api_name => l_api_name,
975: p_pkg_name => g_pkg_name,
976: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
977: x_msg_count => x_msg_count,
978: x_msg_data => x_msg_data,
979: p_api_type => g_api_type);
980:

Line 981: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then

977: x_msg_count => x_msg_count,
978: x_msg_data => x_msg_data,
979: p_api_type => g_api_type);
980:
981: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
982: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
983: p_api_name => l_api_name,
984: p_pkg_name => g_pkg_name,
985: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 982: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

978: x_msg_data => x_msg_data,
979: p_api_type => g_api_type);
980:
981: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
982: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
983: p_api_name => l_api_name,
984: p_pkg_name => g_pkg_name,
985: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
986: x_msg_count => x_msg_count,

Line 985: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

981: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
982: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
983: p_api_name => l_api_name,
984: p_pkg_name => g_pkg_name,
985: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
986: x_msg_count => x_msg_count,
987: x_msg_data => x_msg_data,
988: p_api_type => g_api_type);
989:

Line 991: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

987: x_msg_data => x_msg_data,
988: p_api_type => g_api_type);
989:
990: when OTHERS then
991: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
992: p_api_name => l_api_name,
993: p_pkg_name => g_pkg_name,
994: p_exc_name => 'OTHERS',
995: x_msg_count => x_msg_count,

Line 1012: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

1008: x_sucv_rec OUT NOCOPY sucv_rec_type) IS
1009:
1010: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_SUBSIDY_CRITERIA';
1011: l_api_version CONSTANT NUMBER := 1.0;
1012: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1013:
1014: l_sucv_rec sucv_rec_type;
1015: Begin
1016: -- call START_ACTIVITY to create savepoint, check compatibility

Line 1019: l_return_status := OKL_API.START_ACTIVITY(

1015: Begin
1016: -- call START_ACTIVITY to create savepoint, check compatibility
1017: -- and initialize message list
1018:
1019: l_return_status := OKL_API.START_ACTIVITY(
1020: p_api_name => l_api_name,
1021: p_pkg_name => g_pkg_name,
1022: p_init_msg_list => p_init_msg_list,
1023: l_api_version => l_api_version,

Line 1029: If (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then

1025: p_api_type => g_api_type,
1026: x_return_status => x_return_status);
1027:
1028: -- check if activity started successfully
1029: If (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
1030: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1031: Elsif (l_return_status = OKL_API.G_RET_STS_ERROR) then
1032: raise OKL_API.G_EXCEPTION_ERROR;
1033: End If;

Line 1030: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1026: x_return_status => x_return_status);
1027:
1028: -- check if activity started successfully
1029: If (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
1030: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1031: Elsif (l_return_status = OKL_API.G_RET_STS_ERROR) then
1032: raise OKL_API.G_EXCEPTION_ERROR;
1033: End If;
1034:

Line 1031: Elsif (l_return_status = OKL_API.G_RET_STS_ERROR) then

1027:
1028: -- check if activity started successfully
1029: If (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
1030: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1031: Elsif (l_return_status = OKL_API.G_RET_STS_ERROR) then
1032: raise OKL_API.G_EXCEPTION_ERROR;
1033: End If;
1034:
1035: l_sucv_rec := p_sucv_rec;

Line 1032: raise OKL_API.G_EXCEPTION_ERROR;

1028: -- check if activity started successfully
1029: If (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
1030: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1031: Elsif (l_return_status = OKL_API.G_RET_STS_ERROR) then
1032: raise OKL_API.G_EXCEPTION_ERROR;
1033: End If;
1034:
1035: l_sucv_rec := p_sucv_rec;
1036:

Line 1047: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then

1043: p_sucv_rec => l_sucv_rec,
1044: x_sucv_rec => x_sucv_rec);
1045:
1046: -- check return status
1047: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
1048: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1049: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
1050: raise OKL_API.G_EXCEPTION_ERROR;
1051: End If;

Line 1048: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1044: x_sucv_rec => x_sucv_rec);
1045:
1046: -- check return status
1047: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
1048: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1049: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
1050: raise OKL_API.G_EXCEPTION_ERROR;
1051: End If;
1052:

Line 1049: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then

1045:
1046: -- check return status
1047: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
1048: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1049: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
1050: raise OKL_API.G_EXCEPTION_ERROR;
1051: End If;
1052:
1053: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

Line 1050: raise OKL_API.G_EXCEPTION_ERROR;

1046: -- check return status
1047: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
1048: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1049: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
1050: raise OKL_API.G_EXCEPTION_ERROR;
1051: End If;
1052:
1053: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
1054: x_msg_data => x_msg_data);

Line 1053: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

1049: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
1050: raise OKL_API.G_EXCEPTION_ERROR;
1051: End If;
1052:
1053: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
1054: x_msg_data => x_msg_data);
1055: EXCEPTION
1056: when OKL_API.G_EXCEPTION_ERROR then
1057: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

Line 1056: when OKL_API.G_EXCEPTION_ERROR then

1052:
1053: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
1054: x_msg_data => x_msg_data);
1055: EXCEPTION
1056: when OKL_API.G_EXCEPTION_ERROR then
1057: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1058: p_api_name => l_api_name,
1059: p_pkg_name => g_pkg_name,
1060: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

Line 1057: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

1053: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
1054: x_msg_data => x_msg_data);
1055: EXCEPTION
1056: when OKL_API.G_EXCEPTION_ERROR then
1057: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1058: p_api_name => l_api_name,
1059: p_pkg_name => g_pkg_name,
1060: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
1061: x_msg_count => x_msg_count,

Line 1060: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

1056: when OKL_API.G_EXCEPTION_ERROR then
1057: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1058: p_api_name => l_api_name,
1059: p_pkg_name => g_pkg_name,
1060: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
1061: x_msg_count => x_msg_count,
1062: x_msg_data => x_msg_data,
1063: p_api_type => g_api_type);
1064:

Line 1065: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then

1061: x_msg_count => x_msg_count,
1062: x_msg_data => x_msg_data,
1063: p_api_type => g_api_type);
1064:
1065: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
1066: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1067: p_api_name => l_api_name,
1068: p_pkg_name => g_pkg_name,
1069: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 1066: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

1062: x_msg_data => x_msg_data,
1063: p_api_type => g_api_type);
1064:
1065: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
1066: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1067: p_api_name => l_api_name,
1068: p_pkg_name => g_pkg_name,
1069: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
1070: x_msg_count => x_msg_count,

Line 1069: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

1065: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
1066: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1067: p_api_name => l_api_name,
1068: p_pkg_name => g_pkg_name,
1069: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
1070: x_msg_count => x_msg_count,
1071: x_msg_data => x_msg_data,
1072: p_api_type => g_api_type);
1073:

Line 1075: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

1071: x_msg_data => x_msg_data,
1072: p_api_type => g_api_type);
1073:
1074: when OTHERS then
1075: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1076: p_api_name => l_api_name,
1077: p_pkg_name => g_pkg_name,
1078: p_exc_name => 'OTHERS',
1079: x_msg_count => x_msg_count,

Line 1095: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

1091: x_sucv_tbl OUT NOCOPY sucv_tbl_type) IS
1092:
1093: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_SUBSIDY_CRITERIA';
1094: l_api_version CONSTANT NUMBER := 1.0;
1095: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1096:
1097: l_sucv_tbl sucv_tbl_type;
1098: Begin
1099: -- call START_ACTIVITY to create savepoint, check compatibility

Line 1102: l_return_status := OKL_API.START_ACTIVITY(

1098: Begin
1099: -- call START_ACTIVITY to create savepoint, check compatibility
1100: -- and initialize message list
1101:
1102: l_return_status := OKL_API.START_ACTIVITY(
1103: p_api_name => l_api_name,
1104: p_pkg_name => g_pkg_name,
1105: p_init_msg_list => p_init_msg_list,
1106: l_api_version => l_api_version,

Line 1112: If (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then

1108: p_api_type => g_api_type,
1109: x_return_status => x_return_status);
1110:
1111: -- check if activity started successfully
1112: If (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
1113: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1114: Elsif (l_return_status = OKL_API.G_RET_STS_ERROR) then
1115: raise OKL_API.G_EXCEPTION_ERROR;
1116: End If;

Line 1113: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1109: x_return_status => x_return_status);
1110:
1111: -- check if activity started successfully
1112: If (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
1113: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1114: Elsif (l_return_status = OKL_API.G_RET_STS_ERROR) then
1115: raise OKL_API.G_EXCEPTION_ERROR;
1116: End If;
1117:

Line 1114: Elsif (l_return_status = OKL_API.G_RET_STS_ERROR) then

1110:
1111: -- check if activity started successfully
1112: If (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
1113: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1114: Elsif (l_return_status = OKL_API.G_RET_STS_ERROR) then
1115: raise OKL_API.G_EXCEPTION_ERROR;
1116: End If;
1117:
1118: l_sucv_tbl := p_sucv_tbl;

Line 1115: raise OKL_API.G_EXCEPTION_ERROR;

1111: -- check if activity started successfully
1112: If (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
1113: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1114: Elsif (l_return_status = OKL_API.G_RET_STS_ERROR) then
1115: raise OKL_API.G_EXCEPTION_ERROR;
1116: End If;
1117:
1118: l_sucv_tbl := p_sucv_tbl;
1119:

Line 1130: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then

1126: p_sucv_tbl => l_sucv_tbl,
1127: x_sucv_tbl => x_sucv_tbl);
1128:
1129: -- check return status
1130: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
1131: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1132: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
1133: raise OKL_API.G_EXCEPTION_ERROR;
1134: End If;

Line 1131: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1127: x_sucv_tbl => x_sucv_tbl);
1128:
1129: -- check return status
1130: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
1131: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1132: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
1133: raise OKL_API.G_EXCEPTION_ERROR;
1134: End If;
1135:

Line 1132: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then

1128:
1129: -- check return status
1130: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
1131: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1132: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
1133: raise OKL_API.G_EXCEPTION_ERROR;
1134: End If;
1135:
1136: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

Line 1133: raise OKL_API.G_EXCEPTION_ERROR;

1129: -- check return status
1130: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
1131: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1132: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
1133: raise OKL_API.G_EXCEPTION_ERROR;
1134: End If;
1135:
1136: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
1137: x_msg_data => x_msg_data);

Line 1136: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

1132: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
1133: raise OKL_API.G_EXCEPTION_ERROR;
1134: End If;
1135:
1136: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
1137: x_msg_data => x_msg_data);
1138: EXCEPTION
1139: when OKL_API.G_EXCEPTION_ERROR then
1140: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

Line 1139: when OKL_API.G_EXCEPTION_ERROR then

1135:
1136: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
1137: x_msg_data => x_msg_data);
1138: EXCEPTION
1139: when OKL_API.G_EXCEPTION_ERROR then
1140: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1141: p_api_name => l_api_name,
1142: p_pkg_name => g_pkg_name,
1143: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

Line 1140: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

1136: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
1137: x_msg_data => x_msg_data);
1138: EXCEPTION
1139: when OKL_API.G_EXCEPTION_ERROR then
1140: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1141: p_api_name => l_api_name,
1142: p_pkg_name => g_pkg_name,
1143: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
1144: x_msg_count => x_msg_count,

Line 1143: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

1139: when OKL_API.G_EXCEPTION_ERROR then
1140: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1141: p_api_name => l_api_name,
1142: p_pkg_name => g_pkg_name,
1143: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
1144: x_msg_count => x_msg_count,
1145: x_msg_data => x_msg_data,
1146: p_api_type => g_api_type);
1147:

Line 1148: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then

1144: x_msg_count => x_msg_count,
1145: x_msg_data => x_msg_data,
1146: p_api_type => g_api_type);
1147:
1148: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
1149: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1150: p_api_name => l_api_name,
1151: p_pkg_name => g_pkg_name,
1152: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 1149: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

1145: x_msg_data => x_msg_data,
1146: p_api_type => g_api_type);
1147:
1148: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
1149: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1150: p_api_name => l_api_name,
1151: p_pkg_name => g_pkg_name,
1152: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
1153: x_msg_count => x_msg_count,

Line 1152: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

1148: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
1149: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1150: p_api_name => l_api_name,
1151: p_pkg_name => g_pkg_name,
1152: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
1153: x_msg_count => x_msg_count,
1154: x_msg_data => x_msg_data,
1155: p_api_type => g_api_type);
1156:

Line 1158: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

1154: x_msg_data => x_msg_data,
1155: p_api_type => g_api_type);
1156:
1157: when OTHERS then
1158: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1159: p_api_name => l_api_name,
1160: p_pkg_name => g_pkg_name,
1161: p_exc_name => 'OTHERS',
1162: x_msg_count => x_msg_count,

Line 1178: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

1174: p_sucv_rec IN sucv_rec_type) IS
1175:
1176: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_SUBSIDY_CRITERIA';
1177: l_api_version CONSTANT NUMBER := 1.0;
1178: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1179:
1180: l_sucv_rec sucv_rec_type;
1181: Begin
1182: -- call START_ACTIVITY to create savepoint, check compatibility

Line 1185: l_return_status := OKL_API.START_ACTIVITY(

1181: Begin
1182: -- call START_ACTIVITY to create savepoint, check compatibility
1183: -- and initialize message list
1184:
1185: l_return_status := OKL_API.START_ACTIVITY(
1186: p_api_name => l_api_name,
1187: p_pkg_name => g_pkg_name,
1188: p_init_msg_list => p_init_msg_list,
1189: l_api_version => l_api_version,

Line 1195: If (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then

1191: p_api_type => g_api_type,
1192: x_return_status => x_return_status);
1193:
1194: -- check if activity started successfully
1195: If (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
1196: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1197: Elsif (l_return_status = OKL_API.G_RET_STS_ERROR) then
1198: raise OKL_API.G_EXCEPTION_ERROR;
1199: End If;

Line 1196: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1192: x_return_status => x_return_status);
1193:
1194: -- check if activity started successfully
1195: If (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
1196: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1197: Elsif (l_return_status = OKL_API.G_RET_STS_ERROR) then
1198: raise OKL_API.G_EXCEPTION_ERROR;
1199: End If;
1200:

Line 1197: Elsif (l_return_status = OKL_API.G_RET_STS_ERROR) then

1193:
1194: -- check if activity started successfully
1195: If (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
1196: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1197: Elsif (l_return_status = OKL_API.G_RET_STS_ERROR) then
1198: raise OKL_API.G_EXCEPTION_ERROR;
1199: End If;
1200:
1201: l_sucv_rec := p_sucv_rec;

Line 1198: raise OKL_API.G_EXCEPTION_ERROR;

1194: -- check if activity started successfully
1195: If (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
1196: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1197: Elsif (l_return_status = OKL_API.G_RET_STS_ERROR) then
1198: raise OKL_API.G_EXCEPTION_ERROR;
1199: End If;
1200:
1201: l_sucv_rec := p_sucv_rec;
1202:

Line 1212: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then

1208: x_msg_data => x_msg_data,
1209: p_sucv_rec => l_sucv_rec);
1210:
1211: -- check return status
1212: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
1213: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1214: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
1215: raise OKL_API.G_EXCEPTION_ERROR;
1216: End If;

Line 1213: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1209: p_sucv_rec => l_sucv_rec);
1210:
1211: -- check return status
1212: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
1213: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1214: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
1215: raise OKL_API.G_EXCEPTION_ERROR;
1216: End If;
1217:

Line 1214: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then

1210:
1211: -- check return status
1212: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
1213: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1214: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
1215: raise OKL_API.G_EXCEPTION_ERROR;
1216: End If;
1217:
1218: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

Line 1215: raise OKL_API.G_EXCEPTION_ERROR;

1211: -- check return status
1212: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
1213: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1214: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
1215: raise OKL_API.G_EXCEPTION_ERROR;
1216: End If;
1217:
1218: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
1219: x_msg_data => x_msg_data);

Line 1218: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

1214: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
1215: raise OKL_API.G_EXCEPTION_ERROR;
1216: End If;
1217:
1218: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
1219: x_msg_data => x_msg_data);
1220: EXCEPTION
1221: when OKL_API.G_EXCEPTION_ERROR then
1222: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

Line 1221: when OKL_API.G_EXCEPTION_ERROR then

1217:
1218: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
1219: x_msg_data => x_msg_data);
1220: EXCEPTION
1221: when OKL_API.G_EXCEPTION_ERROR then
1222: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1223: p_api_name => l_api_name,
1224: p_pkg_name => g_pkg_name,
1225: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

Line 1222: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

1218: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
1219: x_msg_data => x_msg_data);
1220: EXCEPTION
1221: when OKL_API.G_EXCEPTION_ERROR then
1222: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1223: p_api_name => l_api_name,
1224: p_pkg_name => g_pkg_name,
1225: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
1226: x_msg_count => x_msg_count,

Line 1225: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

1221: when OKL_API.G_EXCEPTION_ERROR then
1222: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1223: p_api_name => l_api_name,
1224: p_pkg_name => g_pkg_name,
1225: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
1226: x_msg_count => x_msg_count,
1227: x_msg_data => x_msg_data,
1228: p_api_type => g_api_type);
1229:

Line 1230: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then

1226: x_msg_count => x_msg_count,
1227: x_msg_data => x_msg_data,
1228: p_api_type => g_api_type);
1229:
1230: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
1231: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1232: p_api_name => l_api_name,
1233: p_pkg_name => g_pkg_name,
1234: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 1231: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

1227: x_msg_data => x_msg_data,
1228: p_api_type => g_api_type);
1229:
1230: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
1231: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1232: p_api_name => l_api_name,
1233: p_pkg_name => g_pkg_name,
1234: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
1235: x_msg_count => x_msg_count,

Line 1234: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

1230: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
1231: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1232: p_api_name => l_api_name,
1233: p_pkg_name => g_pkg_name,
1234: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
1235: x_msg_count => x_msg_count,
1236: x_msg_data => x_msg_data,
1237: p_api_type => g_api_type);
1238:

Line 1240: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

1236: x_msg_data => x_msg_data,
1237: p_api_type => g_api_type);
1238:
1239: when OTHERS then
1240: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1241: p_api_name => l_api_name,
1242: p_pkg_name => g_pkg_name,
1243: p_exc_name => 'OTHERS',
1244: x_msg_count => x_msg_count,

Line 1260: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

1256: p_sucv_tbl IN sucv_tbl_type) Is
1257:
1258: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_SUBSIDY_CRITERIA';
1259: l_api_version CONSTANT NUMBER := 1.0;
1260: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1261:
1262: l_sucv_tbl sucv_tbl_type;
1263: Begin
1264: -- call START_ACTIVITY to create savepoint, check compatibility

Line 1267: l_return_status := OKL_API.START_ACTIVITY(

1263: Begin
1264: -- call START_ACTIVITY to create savepoint, check compatibility
1265: -- and initialize message list
1266:
1267: l_return_status := OKL_API.START_ACTIVITY(
1268: p_api_name => l_api_name,
1269: p_pkg_name => g_pkg_name,
1270: p_init_msg_list => p_init_msg_list,
1271: l_api_version => l_api_version,

Line 1277: If (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then

1273: p_api_type => g_api_type,
1274: x_return_status => x_return_status);
1275:
1276: -- check if activity started successfully
1277: If (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
1278: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1279: Elsif (l_return_status = OKL_API.G_RET_STS_ERROR) then
1280: raise OKL_API.G_EXCEPTION_ERROR;
1281: End If;

Line 1278: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1274: x_return_status => x_return_status);
1275:
1276: -- check if activity started successfully
1277: If (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
1278: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1279: Elsif (l_return_status = OKL_API.G_RET_STS_ERROR) then
1280: raise OKL_API.G_EXCEPTION_ERROR;
1281: End If;
1282:

Line 1279: Elsif (l_return_status = OKL_API.G_RET_STS_ERROR) then

1275:
1276: -- check if activity started successfully
1277: If (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
1278: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1279: Elsif (l_return_status = OKL_API.G_RET_STS_ERROR) then
1280: raise OKL_API.G_EXCEPTION_ERROR;
1281: End If;
1282:
1283: l_sucv_tbl := p_sucv_tbl;

Line 1280: raise OKL_API.G_EXCEPTION_ERROR;

1276: -- check if activity started successfully
1277: If (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
1278: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1279: Elsif (l_return_status = OKL_API.G_RET_STS_ERROR) then
1280: raise OKL_API.G_EXCEPTION_ERROR;
1281: End If;
1282:
1283: l_sucv_tbl := p_sucv_tbl;
1284:

Line 1294: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then

1290: x_msg_data => x_msg_data,
1291: p_sucv_tbl => l_sucv_tbl);
1292:
1293: -- check return status
1294: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
1295: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1296: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
1297: raise OKL_API.G_EXCEPTION_ERROR;
1298: End If;

Line 1295: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1291: p_sucv_tbl => l_sucv_tbl);
1292:
1293: -- check return status
1294: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
1295: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1296: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
1297: raise OKL_API.G_EXCEPTION_ERROR;
1298: End If;
1299:

Line 1296: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then

1292:
1293: -- check return status
1294: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
1295: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1296: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
1297: raise OKL_API.G_EXCEPTION_ERROR;
1298: End If;
1299:
1300: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

Line 1297: raise OKL_API.G_EXCEPTION_ERROR;

1293: -- check return status
1294: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
1295: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1296: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
1297: raise OKL_API.G_EXCEPTION_ERROR;
1298: End If;
1299:
1300: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
1301: x_msg_data => x_msg_data);

Line 1300: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

1296: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
1297: raise OKL_API.G_EXCEPTION_ERROR;
1298: End If;
1299:
1300: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
1301: x_msg_data => x_msg_data);
1302: EXCEPTION
1303: when OKL_API.G_EXCEPTION_ERROR then
1304: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

Line 1303: when OKL_API.G_EXCEPTION_ERROR then

1299:
1300: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
1301: x_msg_data => x_msg_data);
1302: EXCEPTION
1303: when OKL_API.G_EXCEPTION_ERROR then
1304: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1305: p_api_name => l_api_name,
1306: p_pkg_name => g_pkg_name,
1307: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

Line 1304: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

1300: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
1301: x_msg_data => x_msg_data);
1302: EXCEPTION
1303: when OKL_API.G_EXCEPTION_ERROR then
1304: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1305: p_api_name => l_api_name,
1306: p_pkg_name => g_pkg_name,
1307: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
1308: x_msg_count => x_msg_count,

Line 1307: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

1303: when OKL_API.G_EXCEPTION_ERROR then
1304: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1305: p_api_name => l_api_name,
1306: p_pkg_name => g_pkg_name,
1307: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
1308: x_msg_count => x_msg_count,
1309: x_msg_data => x_msg_data,
1310: p_api_type => g_api_type);
1311:

Line 1312: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then

1308: x_msg_count => x_msg_count,
1309: x_msg_data => x_msg_data,
1310: p_api_type => g_api_type);
1311:
1312: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
1313: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1314: p_api_name => l_api_name,
1315: p_pkg_name => g_pkg_name,
1316: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 1313: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

1309: x_msg_data => x_msg_data,
1310: p_api_type => g_api_type);
1311:
1312: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
1313: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1314: p_api_name => l_api_name,
1315: p_pkg_name => g_pkg_name,
1316: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
1317: x_msg_count => x_msg_count,

Line 1316: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

1312: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
1313: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1314: p_api_name => l_api_name,
1315: p_pkg_name => g_pkg_name,
1316: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
1317: x_msg_count => x_msg_count,
1318: x_msg_data => x_msg_data,
1319: p_api_type => g_api_type);
1320:

Line 1322: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

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

Line 1341: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

1337: p_sucv_rec IN sucv_rec_type) IS
1338:
1339: l_api_name CONSTANT VARCHAR2(30) := 'LOCK_SUBSIDY_CRITERIA';
1340: l_api_version CONSTANT NUMBER := 1.0;
1341: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1342:
1343: l_sucv_rec sucv_rec_type;
1344: Begin
1345: -- call START_ACTIVITY to create savepoint, check compatibility

Line 1348: l_return_status := OKL_API.START_ACTIVITY(

1344: Begin
1345: -- call START_ACTIVITY to create savepoint, check compatibility
1346: -- and initialize message list
1347:
1348: l_return_status := OKL_API.START_ACTIVITY(
1349: p_api_name => l_api_name,
1350: p_pkg_name => g_pkg_name,
1351: p_init_msg_list => p_init_msg_list,
1352: l_api_version => l_api_version,

Line 1358: If (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then

1354: p_api_type => g_api_type,
1355: x_return_status => x_return_status);
1356:
1357: -- check if activity started successfully
1358: If (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
1359: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1360: Elsif (l_return_status = OKL_API.G_RET_STS_ERROR) then
1361: raise OKL_API.G_EXCEPTION_ERROR;
1362: End If;

Line 1359: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1355: x_return_status => x_return_status);
1356:
1357: -- check if activity started successfully
1358: If (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
1359: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1360: Elsif (l_return_status = OKL_API.G_RET_STS_ERROR) then
1361: raise OKL_API.G_EXCEPTION_ERROR;
1362: End If;
1363:

Line 1360: Elsif (l_return_status = OKL_API.G_RET_STS_ERROR) then

1356:
1357: -- check if activity started successfully
1358: If (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
1359: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1360: Elsif (l_return_status = OKL_API.G_RET_STS_ERROR) then
1361: raise OKL_API.G_EXCEPTION_ERROR;
1362: End If;
1363:
1364: l_sucv_rec := p_sucv_rec;

Line 1361: raise OKL_API.G_EXCEPTION_ERROR;

1357: -- check if activity started successfully
1358: If (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
1359: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1360: Elsif (l_return_status = OKL_API.G_RET_STS_ERROR) then
1361: raise OKL_API.G_EXCEPTION_ERROR;
1362: End If;
1363:
1364: l_sucv_rec := p_sucv_rec;
1365:

Line 1375: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then

1371: x_msg_data => x_msg_data,
1372: p_sucv_rec => l_sucv_rec);
1373:
1374: -- check return status
1375: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
1376: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1377: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
1378: raise OKL_API.G_EXCEPTION_ERROR;
1379: End If;

Line 1376: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1372: p_sucv_rec => l_sucv_rec);
1373:
1374: -- check return status
1375: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
1376: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1377: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
1378: raise OKL_API.G_EXCEPTION_ERROR;
1379: End If;
1380:

Line 1377: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then

1373:
1374: -- check return status
1375: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
1376: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1377: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
1378: raise OKL_API.G_EXCEPTION_ERROR;
1379: End If;
1380:
1381: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

Line 1378: raise OKL_API.G_EXCEPTION_ERROR;

1374: -- check return status
1375: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
1376: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1377: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
1378: raise OKL_API.G_EXCEPTION_ERROR;
1379: End If;
1380:
1381: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
1382: x_msg_data => x_msg_data);

Line 1381: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

1377: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
1378: raise OKL_API.G_EXCEPTION_ERROR;
1379: End If;
1380:
1381: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
1382: x_msg_data => x_msg_data);
1383: EXCEPTION
1384: when OKL_API.G_EXCEPTION_ERROR then
1385: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

Line 1384: when OKL_API.G_EXCEPTION_ERROR then

1380:
1381: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
1382: x_msg_data => x_msg_data);
1383: EXCEPTION
1384: when OKL_API.G_EXCEPTION_ERROR then
1385: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1386: p_api_name => l_api_name,
1387: p_pkg_name => g_pkg_name,
1388: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

Line 1385: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

1381: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
1382: x_msg_data => x_msg_data);
1383: EXCEPTION
1384: when OKL_API.G_EXCEPTION_ERROR then
1385: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1386: p_api_name => l_api_name,
1387: p_pkg_name => g_pkg_name,
1388: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
1389: x_msg_count => x_msg_count,

Line 1388: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

1384: when OKL_API.G_EXCEPTION_ERROR then
1385: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1386: p_api_name => l_api_name,
1387: p_pkg_name => g_pkg_name,
1388: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
1389: x_msg_count => x_msg_count,
1390: x_msg_data => x_msg_data,
1391: p_api_type => g_api_type);
1392:

Line 1393: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then

1389: x_msg_count => x_msg_count,
1390: x_msg_data => x_msg_data,
1391: p_api_type => g_api_type);
1392:
1393: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
1394: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1395: p_api_name => l_api_name,
1396: p_pkg_name => g_pkg_name,
1397: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 1394: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

1390: x_msg_data => x_msg_data,
1391: p_api_type => g_api_type);
1392:
1393: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
1394: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1395: p_api_name => l_api_name,
1396: p_pkg_name => g_pkg_name,
1397: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
1398: x_msg_count => x_msg_count,

Line 1397: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

1393: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
1394: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1395: p_api_name => l_api_name,
1396: p_pkg_name => g_pkg_name,
1397: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
1398: x_msg_count => x_msg_count,
1399: x_msg_data => x_msg_data,
1400: p_api_type => g_api_type);
1401:

Line 1403: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

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

Line 1422: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

1418: p_sucv_tbl IN sucv_tbl_type) IS
1419:
1420: l_api_name CONSTANT VARCHAR2(30) := 'LOCK_SUBSIDY_CRITERIA';
1421: l_api_version CONSTANT NUMBER := 1.0;
1422: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1423:
1424: l_sucv_tbl sucv_tbl_type;
1425: Begin
1426: -- call START_ACTIVITY to create savepoint, check compatibility

Line 1429: l_return_status := OKL_API.START_ACTIVITY(

1425: Begin
1426: -- call START_ACTIVITY to create savepoint, check compatibility
1427: -- and initialize message list
1428:
1429: l_return_status := OKL_API.START_ACTIVITY(
1430: p_api_name => l_api_name,
1431: p_pkg_name => g_pkg_name,
1432: p_init_msg_list => p_init_msg_list,
1433: l_api_version => l_api_version,

Line 1439: If (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then

1435: p_api_type => g_api_type,
1436: x_return_status => x_return_status);
1437:
1438: -- check if activity started successfully
1439: If (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
1440: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1441: Elsif (l_return_status = OKL_API.G_RET_STS_ERROR) then
1442: raise OKL_API.G_EXCEPTION_ERROR;
1443: End If;

Line 1440: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1436: x_return_status => x_return_status);
1437:
1438: -- check if activity started successfully
1439: If (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
1440: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1441: Elsif (l_return_status = OKL_API.G_RET_STS_ERROR) then
1442: raise OKL_API.G_EXCEPTION_ERROR;
1443: End If;
1444:

Line 1441: Elsif (l_return_status = OKL_API.G_RET_STS_ERROR) then

1437:
1438: -- check if activity started successfully
1439: If (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
1440: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1441: Elsif (l_return_status = OKL_API.G_RET_STS_ERROR) then
1442: raise OKL_API.G_EXCEPTION_ERROR;
1443: End If;
1444:
1445: l_sucv_tbl := p_sucv_tbl;

Line 1442: raise OKL_API.G_EXCEPTION_ERROR;

1438: -- check if activity started successfully
1439: If (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
1440: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1441: Elsif (l_return_status = OKL_API.G_RET_STS_ERROR) then
1442: raise OKL_API.G_EXCEPTION_ERROR;
1443: End If;
1444:
1445: l_sucv_tbl := p_sucv_tbl;
1446:

Line 1456: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then

1452: x_msg_data => x_msg_data,
1453: p_sucv_tbl => l_sucv_tbl);
1454:
1455: -- check return status
1456: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
1457: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1458: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
1459: raise OKL_API.G_EXCEPTION_ERROR;
1460: End If;

Line 1457: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1453: p_sucv_tbl => l_sucv_tbl);
1454:
1455: -- check return status
1456: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
1457: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1458: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
1459: raise OKL_API.G_EXCEPTION_ERROR;
1460: End If;
1461:

Line 1458: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then

1454:
1455: -- check return status
1456: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
1457: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1458: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
1459: raise OKL_API.G_EXCEPTION_ERROR;
1460: End If;
1461:
1462: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

Line 1459: raise OKL_API.G_EXCEPTION_ERROR;

1455: -- check return status
1456: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
1457: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1458: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
1459: raise OKL_API.G_EXCEPTION_ERROR;
1460: End If;
1461:
1462: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
1463: x_msg_data => x_msg_data);

Line 1462: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

1458: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
1459: raise OKL_API.G_EXCEPTION_ERROR;
1460: End If;
1461:
1462: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
1463: x_msg_data => x_msg_data);
1464: EXCEPTION
1465: when OKL_API.G_EXCEPTION_ERROR then
1466: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

Line 1465: when OKL_API.G_EXCEPTION_ERROR then

1461:
1462: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
1463: x_msg_data => x_msg_data);
1464: EXCEPTION
1465: when OKL_API.G_EXCEPTION_ERROR then
1466: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1467: p_api_name => l_api_name,
1468: p_pkg_name => g_pkg_name,
1469: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

Line 1466: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

1462: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
1463: x_msg_data => x_msg_data);
1464: EXCEPTION
1465: when OKL_API.G_EXCEPTION_ERROR then
1466: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1467: p_api_name => l_api_name,
1468: p_pkg_name => g_pkg_name,
1469: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
1470: x_msg_count => x_msg_count,

Line 1469: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

1465: when OKL_API.G_EXCEPTION_ERROR then
1466: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1467: p_api_name => l_api_name,
1468: p_pkg_name => g_pkg_name,
1469: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
1470: x_msg_count => x_msg_count,
1471: x_msg_data => x_msg_data,
1472: p_api_type => g_api_type);
1473:

Line 1474: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then

1470: x_msg_count => x_msg_count,
1471: x_msg_data => x_msg_data,
1472: p_api_type => g_api_type);
1473:
1474: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
1475: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1476: p_api_name => l_api_name,
1477: p_pkg_name => g_pkg_name,
1478: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 1475: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

1471: x_msg_data => x_msg_data,
1472: p_api_type => g_api_type);
1473:
1474: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
1475: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1476: p_api_name => l_api_name,
1477: p_pkg_name => g_pkg_name,
1478: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
1479: x_msg_count => x_msg_count,

Line 1478: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

1474: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
1475: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1476: p_api_name => l_api_name,
1477: p_pkg_name => g_pkg_name,
1478: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
1479: x_msg_count => x_msg_count,
1480: x_msg_data => x_msg_data,
1481: p_api_type => g_api_type);
1482:

Line 1484: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

1480: x_msg_data => x_msg_data,
1481: p_api_type => g_api_type);
1482:
1483: when OTHERS then
1484: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1485: p_api_name => l_api_name,
1486: p_pkg_name => g_pkg_name,
1487: p_exc_name => 'OTHERS',
1488: x_msg_count => x_msg_count,

Line 1506: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

1502:
1503:
1504: l_api_name CONSTANT VARCHAR2(30) := 'VALIDATE_SUBSIDY_CRITERIA';
1505: l_api_version CONSTANT NUMBER := 1.0;
1506: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1507:
1508: l_sucv_rec sucv_rec_type;
1509: Begin
1510: -- call START_ACTIVITY to create savepoint, check compatibility

Line 1513: l_return_status := OKL_API.START_ACTIVITY(

1509: Begin
1510: -- call START_ACTIVITY to create savepoint, check compatibility
1511: -- and initialize message list
1512:
1513: l_return_status := OKL_API.START_ACTIVITY(
1514: p_api_name => l_api_name,
1515: p_pkg_name => g_pkg_name,
1516: p_init_msg_list => p_init_msg_list,
1517: l_api_version => l_api_version,

Line 1523: If (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then

1519: p_api_type => g_api_type,
1520: x_return_status => x_return_status);
1521:
1522: -- check if activity started successfully
1523: If (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
1524: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1525: Elsif (l_return_status = OKL_API.G_RET_STS_ERROR) then
1526: raise OKL_API.G_EXCEPTION_ERROR;
1527: End If;

Line 1524: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1520: x_return_status => x_return_status);
1521:
1522: -- check if activity started successfully
1523: If (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
1524: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1525: Elsif (l_return_status = OKL_API.G_RET_STS_ERROR) then
1526: raise OKL_API.G_EXCEPTION_ERROR;
1527: End If;
1528:

Line 1525: Elsif (l_return_status = OKL_API.G_RET_STS_ERROR) then

1521:
1522: -- check if activity started successfully
1523: If (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
1524: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1525: Elsif (l_return_status = OKL_API.G_RET_STS_ERROR) then
1526: raise OKL_API.G_EXCEPTION_ERROR;
1527: End If;
1528:
1529: l_sucv_rec := p_sucv_rec;

Line 1526: raise OKL_API.G_EXCEPTION_ERROR;

1522: -- check if activity started successfully
1523: If (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
1524: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1525: Elsif (l_return_status = OKL_API.G_RET_STS_ERROR) then
1526: raise OKL_API.G_EXCEPTION_ERROR;
1527: End If;
1528:
1529: l_sucv_rec := p_sucv_rec;
1530:

Line 1540: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then

1536: x_msg_data => x_msg_data,
1537: p_sucv_rec => l_sucv_rec);
1538:
1539: -- check return status
1540: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
1541: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1542: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
1543: raise OKL_API.G_EXCEPTION_ERROR;
1544: End If;

Line 1541: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1537: p_sucv_rec => l_sucv_rec);
1538:
1539: -- check return status
1540: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
1541: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1542: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
1543: raise OKL_API.G_EXCEPTION_ERROR;
1544: End If;
1545:

Line 1542: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then

1538:
1539: -- check return status
1540: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
1541: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1542: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
1543: raise OKL_API.G_EXCEPTION_ERROR;
1544: End If;
1545:
1546: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

Line 1543: raise OKL_API.G_EXCEPTION_ERROR;

1539: -- check return status
1540: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
1541: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1542: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
1543: raise OKL_API.G_EXCEPTION_ERROR;
1544: End If;
1545:
1546: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
1547: x_msg_data => x_msg_data);

Line 1546: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

1542: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
1543: raise OKL_API.G_EXCEPTION_ERROR;
1544: End If;
1545:
1546: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
1547: x_msg_data => x_msg_data);
1548: EXCEPTION
1549: when OKL_API.G_EXCEPTION_ERROR then
1550: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

Line 1549: when OKL_API.G_EXCEPTION_ERROR then

1545:
1546: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
1547: x_msg_data => x_msg_data);
1548: EXCEPTION
1549: when OKL_API.G_EXCEPTION_ERROR then
1550: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1551: p_api_name => l_api_name,
1552: p_pkg_name => g_pkg_name,
1553: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

Line 1550: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

1546: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
1547: x_msg_data => x_msg_data);
1548: EXCEPTION
1549: when OKL_API.G_EXCEPTION_ERROR then
1550: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1551: p_api_name => l_api_name,
1552: p_pkg_name => g_pkg_name,
1553: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
1554: x_msg_count => x_msg_count,

Line 1553: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

1549: when OKL_API.G_EXCEPTION_ERROR then
1550: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1551: p_api_name => l_api_name,
1552: p_pkg_name => g_pkg_name,
1553: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
1554: x_msg_count => x_msg_count,
1555: x_msg_data => x_msg_data,
1556: p_api_type => g_api_type);
1557:

Line 1558: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then

1554: x_msg_count => x_msg_count,
1555: x_msg_data => x_msg_data,
1556: p_api_type => g_api_type);
1557:
1558: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
1559: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1560: p_api_name => l_api_name,
1561: p_pkg_name => g_pkg_name,
1562: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 1559: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

1555: x_msg_data => x_msg_data,
1556: p_api_type => g_api_type);
1557:
1558: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
1559: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1560: p_api_name => l_api_name,
1561: p_pkg_name => g_pkg_name,
1562: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
1563: x_msg_count => x_msg_count,

Line 1562: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

1558: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
1559: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1560: p_api_name => l_api_name,
1561: p_pkg_name => g_pkg_name,
1562: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
1563: x_msg_count => x_msg_count,
1564: x_msg_data => x_msg_data,
1565: p_api_type => g_api_type);
1566:

Line 1568: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

1564: x_msg_data => x_msg_data,
1565: p_api_type => g_api_type);
1566:
1567: when OTHERS then
1568: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1569: p_api_name => l_api_name,
1570: p_pkg_name => g_pkg_name,
1571: p_exc_name => 'OTHERS',
1572: x_msg_count => x_msg_count,

Line 1587: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

1583: p_sucv_tbl IN sucv_tbl_type) IS
1584:
1585: l_api_name CONSTANT VARCHAR2(30) := 'VALIDATE_SUBSIDY_CRITERIA';
1586: l_api_version CONSTANT NUMBER := 1.0;
1587: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1588:
1589: l_sucv_tbl sucv_tbl_type;
1590: Begin
1591: -- call START_ACTIVITY to create savepoint, check compatibility

Line 1594: l_return_status := OKL_API.START_ACTIVITY(

1590: Begin
1591: -- call START_ACTIVITY to create savepoint, check compatibility
1592: -- and initialize message list
1593:
1594: l_return_status := OKL_API.START_ACTIVITY(
1595: p_api_name => l_api_name,
1596: p_pkg_name => g_pkg_name,
1597: p_init_msg_list => p_init_msg_list,
1598: l_api_version => l_api_version,

Line 1604: If (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then

1600: p_api_type => g_api_type,
1601: x_return_status => x_return_status);
1602:
1603: -- check if activity started successfully
1604: If (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
1605: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1606: Elsif (l_return_status = OKL_API.G_RET_STS_ERROR) then
1607: raise OKL_API.G_EXCEPTION_ERROR;
1608: End If;

Line 1605: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1601: x_return_status => x_return_status);
1602:
1603: -- check if activity started successfully
1604: If (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
1605: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1606: Elsif (l_return_status = OKL_API.G_RET_STS_ERROR) then
1607: raise OKL_API.G_EXCEPTION_ERROR;
1608: End If;
1609:

Line 1606: Elsif (l_return_status = OKL_API.G_RET_STS_ERROR) then

1602:
1603: -- check if activity started successfully
1604: If (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
1605: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1606: Elsif (l_return_status = OKL_API.G_RET_STS_ERROR) then
1607: raise OKL_API.G_EXCEPTION_ERROR;
1608: End If;
1609:
1610: l_sucv_tbl := p_sucv_tbl;

Line 1607: raise OKL_API.G_EXCEPTION_ERROR;

1603: -- check if activity started successfully
1604: If (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
1605: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1606: Elsif (l_return_status = OKL_API.G_RET_STS_ERROR) then
1607: raise OKL_API.G_EXCEPTION_ERROR;
1608: End If;
1609:
1610: l_sucv_tbl := p_sucv_tbl;
1611:

Line 1621: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then

1617: x_msg_data => x_msg_data,
1618: p_sucv_tbl => l_sucv_tbl);
1619:
1620: -- check return status
1621: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
1622: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1623: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
1624: raise OKL_API.G_EXCEPTION_ERROR;
1625: End If;

Line 1622: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1618: p_sucv_tbl => l_sucv_tbl);
1619:
1620: -- check return status
1621: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
1622: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1623: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
1624: raise OKL_API.G_EXCEPTION_ERROR;
1625: End If;
1626:

Line 1623: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then

1619:
1620: -- check return status
1621: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
1622: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1623: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
1624: raise OKL_API.G_EXCEPTION_ERROR;
1625: End If;
1626:
1627: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

Line 1624: raise OKL_API.G_EXCEPTION_ERROR;

1620: -- check return status
1621: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
1622: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1623: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
1624: raise OKL_API.G_EXCEPTION_ERROR;
1625: End If;
1626:
1627: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
1628: x_msg_data => x_msg_data);

Line 1627: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

1623: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
1624: raise OKL_API.G_EXCEPTION_ERROR;
1625: End If;
1626:
1627: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
1628: x_msg_data => x_msg_data);
1629: EXCEPTION
1630: when OKL_API.G_EXCEPTION_ERROR then
1631: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

Line 1630: when OKL_API.G_EXCEPTION_ERROR then

1626:
1627: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
1628: x_msg_data => x_msg_data);
1629: EXCEPTION
1630: when OKL_API.G_EXCEPTION_ERROR then
1631: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1632: p_api_name => l_api_name,
1633: p_pkg_name => g_pkg_name,
1634: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

Line 1631: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

1627: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
1628: x_msg_data => x_msg_data);
1629: EXCEPTION
1630: when OKL_API.G_EXCEPTION_ERROR then
1631: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1632: p_api_name => l_api_name,
1633: p_pkg_name => g_pkg_name,
1634: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
1635: x_msg_count => x_msg_count,

Line 1634: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

1630: when OKL_API.G_EXCEPTION_ERROR then
1631: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1632: p_api_name => l_api_name,
1633: p_pkg_name => g_pkg_name,
1634: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
1635: x_msg_count => x_msg_count,
1636: x_msg_data => x_msg_data,
1637: p_api_type => g_api_type);
1638:

Line 1639: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then

1635: x_msg_count => x_msg_count,
1636: x_msg_data => x_msg_data,
1637: p_api_type => g_api_type);
1638:
1639: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
1640: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1641: p_api_name => l_api_name,
1642: p_pkg_name => g_pkg_name,
1643: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 1640: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

1636: x_msg_data => x_msg_data,
1637: p_api_type => g_api_type);
1638:
1639: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
1640: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1641: p_api_name => l_api_name,
1642: p_pkg_name => g_pkg_name,
1643: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
1644: x_msg_count => x_msg_count,

Line 1643: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

1639: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
1640: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1641: p_api_name => l_api_name,
1642: p_pkg_name => g_pkg_name,
1643: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
1644: x_msg_count => x_msg_count,
1645: x_msg_data => x_msg_data,
1646: p_api_type => g_api_type);
1647:

Line 1649: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

1645: x_msg_data => x_msg_data,
1646: p_api_type => g_api_type);
1647:
1648: when OTHERS then
1649: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1650: p_api_name => l_api_name,
1651: p_pkg_name => g_pkg_name,
1652: p_exc_name => 'OTHERS',
1653: x_msg_count => x_msg_count,