eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_TXL_ITM_INSTS_PVT dependencies on OKC_API

Line 79: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

75:
76:
77: PROCEDURE Create_txl_itm_insts(
78: p_api_version IN NUMBER,
79: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
80: x_return_status OUT NOCOPY VARCHAR2,
81: x_msg_count OUT NOCOPY NUMBER,
82: x_msg_data OUT NOCOPY VARCHAR2,
83: p_iivv_rec IN iivv_rec_type,

Line 87: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

83: p_iivv_rec IN iivv_rec_type,
84: x_iivv_rec OUT NOCOPY iivv_rec_type)
85: IS
86: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_TXL_ITM_INSTS';
87: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
88:
89: /*
90: * sjalasut aug 18, 04: added cursor to derive the dnz_chr_id from the dnz_cle_id
91: * to pass the parameters to the business event. BEGIN

Line 107: l_return_status := OKC_API.START_ACTIVITY (l_api_name

103:
104: BEGIN
105: -- Call start_activity to create savepoint, check compatibility
106: -- and initialize message list
107: l_return_status := OKC_API.START_ACTIVITY (l_api_name
108: ,p_init_msg_list
109: ,'_PVT'
110: ,x_return_status);
111: -- Check if activity started successfully

Line 112: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

108: ,p_init_msg_list
109: ,'_PVT'
110: ,x_return_status);
111: -- Check if activity started successfully
112: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
113: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
114: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
115: RAISE OKC_API.G_EXCEPTION_ERROR;
116: END IF;

Line 113: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

109: ,'_PVT'
110: ,x_return_status);
111: -- Check if activity started successfully
112: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
113: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
114: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
115: RAISE OKC_API.G_EXCEPTION_ERROR;
116: END IF;
117: -- evaluate conditions, build outcomes for true conditions and

Line 114: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

110: ,x_return_status);
111: -- Check if activity started successfully
112: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
113: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
114: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
115: RAISE OKC_API.G_EXCEPTION_ERROR;
116: END IF;
117: -- evaluate conditions, build outcomes for true conditions and
118: -- put them on outcome queue

Line 115: RAISE OKC_API.G_EXCEPTION_ERROR;

111: -- Check if activity started successfully
112: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
113: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
114: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
115: RAISE OKC_API.G_EXCEPTION_ERROR;
116: END IF;
117: -- evaluate conditions, build outcomes for true conditions and
118: -- put them on outcome queue
119: OKL_ITI_PVT.insert_row(p_api_version,

Line 157: OKC_API.END_ACTIVITY (x_msg_count

153: /*
154: * sjalasut: oct 14, 04 added code to enable business event. END
155: */
156:
157: OKC_API.END_ACTIVITY (x_msg_count
158: ,x_msg_data );
159: EXCEPTION
160: WHEN OKC_API.G_EXCEPTION_ERROR THEN
161: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 160: WHEN OKC_API.G_EXCEPTION_ERROR THEN

156:
157: OKC_API.END_ACTIVITY (x_msg_count
158: ,x_msg_data );
159: EXCEPTION
160: WHEN OKC_API.G_EXCEPTION_ERROR THEN
161: x_return_status := OKC_API.HANDLE_EXCEPTIONS
162: (l_api_name,
163: G_PKG_NAME,
164: 'OKC_API.G_RET_STS_ERROR',

Line 161: x_return_status := OKC_API.HANDLE_EXCEPTIONS

157: OKC_API.END_ACTIVITY (x_msg_count
158: ,x_msg_data );
159: EXCEPTION
160: WHEN OKC_API.G_EXCEPTION_ERROR THEN
161: x_return_status := OKC_API.HANDLE_EXCEPTIONS
162: (l_api_name,
163: G_PKG_NAME,
164: 'OKC_API.G_RET_STS_ERROR',
165: x_msg_count,

Line 164: 'OKC_API.G_RET_STS_ERROR',

160: WHEN OKC_API.G_EXCEPTION_ERROR THEN
161: x_return_status := OKC_API.HANDLE_EXCEPTIONS
162: (l_api_name,
163: G_PKG_NAME,
164: 'OKC_API.G_RET_STS_ERROR',
165: x_msg_count,
166: x_msg_data,
167: '_PVT');
168: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 168: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

164: 'OKC_API.G_RET_STS_ERROR',
165: x_msg_count,
166: x_msg_data,
167: '_PVT');
168: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
169: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
170: (l_api_name,
171: G_PKG_NAME,
172: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 169: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

165: x_msg_count,
166: x_msg_data,
167: '_PVT');
168: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
169: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
170: (l_api_name,
171: G_PKG_NAME,
172: 'OKC_API.G_RET_STS_UNEXP_ERROR',
173: x_msg_count,

Line 172: 'OKC_API.G_RET_STS_UNEXP_ERROR',

168: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
169: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
170: (l_api_name,
171: G_PKG_NAME,
172: 'OKC_API.G_RET_STS_UNEXP_ERROR',
173: x_msg_count,
174: x_msg_data,
175: '_PVT');
176: WHEN OTHERS THEN x_return_status :=OKC_API.HANDLE_EXCEPTIONS

Line 176: WHEN OTHERS THEN x_return_status :=OKC_API.HANDLE_EXCEPTIONS

172: 'OKC_API.G_RET_STS_UNEXP_ERROR',
173: x_msg_count,
174: x_msg_data,
175: '_PVT');
176: WHEN OTHERS THEN x_return_status :=OKC_API.HANDLE_EXCEPTIONS
177: (l_api_name,
178: G_PKG_NAME,
179: 'OTHERS',
180: x_msg_count,

Line 187: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

183: END Create_txl_itm_insts;
184:
185: PROCEDURE Create_txl_itm_insts(
186: p_api_version IN NUMBER,
187: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
188: x_return_status OUT NOCOPY VARCHAR2,
189: x_msg_count OUT NOCOPY NUMBER,
190: x_msg_data OUT NOCOPY VARCHAR2,
191: p_iivv_tbl IN iivv_tbl_type,

Line 195: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

191: p_iivv_tbl IN iivv_tbl_type,
192: x_iivv_tbl OUT NOCOPY iivv_tbl_type)
193: IS
194: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_TXL_ITM_INSTS';
195: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
196: BEGIN
197: -- Call start_activity to create savepoint, check compatibility
198: -- and initialize message list
199: l_return_status := OKC_API.START_ACTIVITY (l_api_name

Line 199: l_return_status := OKC_API.START_ACTIVITY (l_api_name

195: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
196: BEGIN
197: -- Call start_activity to create savepoint, check compatibility
198: -- and initialize message list
199: l_return_status := OKC_API.START_ACTIVITY (l_api_name
200: ,p_init_msg_list
201: ,'_PVT'
202: , x_return_status);
203: -- Check if activity started successfully

Line 204: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

200: ,p_init_msg_list
201: ,'_PVT'
202: , x_return_status);
203: -- Check if activity started successfully
204: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
205: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
206: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
207: RAISE OKC_API.G_EXCEPTION_ERROR;
208: END IF;

Line 205: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

201: ,'_PVT'
202: , x_return_status);
203: -- Check if activity started successfully
204: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
205: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
206: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
207: RAISE OKC_API.G_EXCEPTION_ERROR;
208: END IF;
209: -- evaluate conditions, build outcomes for true conditions and

Line 206: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

202: , x_return_status);
203: -- Check if activity started successfully
204: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
205: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
206: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
207: RAISE OKC_API.G_EXCEPTION_ERROR;
208: END IF;
209: -- evaluate conditions, build outcomes for true conditions and
210: -- put them on outcome queue

Line 207: RAISE OKC_API.G_EXCEPTION_ERROR;

203: -- Check if activity started successfully
204: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
205: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
206: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
207: RAISE OKC_API.G_EXCEPTION_ERROR;
208: END IF;
209: -- evaluate conditions, build outcomes for true conditions and
210: -- put them on outcome queue
211: OKL_ITI_PVT.insert_row(p_api_version,

Line 219: OKC_API.END_ACTIVITY (x_msg_count

215: x_msg_data,
216: p_iivv_tbl,
217: x_iivv_tbl);
218:
219: OKC_API.END_ACTIVITY (x_msg_count
220: ,x_msg_data );
221:
222: EXCEPTION
223: WHEN OKC_API.G_EXCEPTION_ERROR THEN

Line 223: WHEN OKC_API.G_EXCEPTION_ERROR THEN

219: OKC_API.END_ACTIVITY (x_msg_count
220: ,x_msg_data );
221:
222: EXCEPTION
223: WHEN OKC_API.G_EXCEPTION_ERROR THEN
224: x_return_status := OKC_API.HANDLE_EXCEPTIONS
225: (l_api_name,
226: G_PKG_NAME,
227: 'OKC_API.G_RET_STS_ERROR',

Line 224: x_return_status := OKC_API.HANDLE_EXCEPTIONS

220: ,x_msg_data );
221:
222: EXCEPTION
223: WHEN OKC_API.G_EXCEPTION_ERROR THEN
224: x_return_status := OKC_API.HANDLE_EXCEPTIONS
225: (l_api_name,
226: G_PKG_NAME,
227: 'OKC_API.G_RET_STS_ERROR',
228: x_msg_count,

Line 227: 'OKC_API.G_RET_STS_ERROR',

223: WHEN OKC_API.G_EXCEPTION_ERROR THEN
224: x_return_status := OKC_API.HANDLE_EXCEPTIONS
225: (l_api_name,
226: G_PKG_NAME,
227: 'OKC_API.G_RET_STS_ERROR',
228: x_msg_count,
229: x_msg_data,
230: '_PVT');
231: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 231: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

227: 'OKC_API.G_RET_STS_ERROR',
228: x_msg_count,
229: x_msg_data,
230: '_PVT');
231: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
232: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
233: (l_api_name,
234: G_PKG_NAME,
235: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 232: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

228: x_msg_count,
229: x_msg_data,
230: '_PVT');
231: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
232: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
233: (l_api_name,
234: G_PKG_NAME,
235: 'OKC_API.G_RET_STS_UNEXP_ERROR',
236: x_msg_count,

Line 235: 'OKC_API.G_RET_STS_UNEXP_ERROR',

231: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
232: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
233: (l_api_name,
234: G_PKG_NAME,
235: 'OKC_API.G_RET_STS_UNEXP_ERROR',
236: x_msg_count,
237: x_msg_data,
238: '_PVT');
239: WHEN OTHERS THEN x_return_status :=OKC_API.HANDLE_EXCEPTIONS

Line 239: WHEN OTHERS THEN x_return_status :=OKC_API.HANDLE_EXCEPTIONS

235: 'OKC_API.G_RET_STS_UNEXP_ERROR',
236: x_msg_count,
237: x_msg_data,
238: '_PVT');
239: WHEN OTHERS THEN x_return_status :=OKC_API.HANDLE_EXCEPTIONS
240: ( l_api_name,
241: G_PKG_NAME,
242: 'OTHERS',
243: x_msg_count,

Line 250: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

246: END Create_txl_itm_insts;
247:
248: PROCEDURE lock_txl_itm_insts(
249: p_api_version IN NUMBER,
250: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
251: x_return_status OUT NOCOPY VARCHAR2,
252: x_msg_count OUT NOCOPY NUMBER,
253: x_msg_data OUT NOCOPY VARCHAR2,
254: p_iivv_rec IN iivv_rec_type)

Line 257: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

253: x_msg_data OUT NOCOPY VARCHAR2,
254: p_iivv_rec IN iivv_rec_type)
255: IS
256: l_api_name CONSTANT VARCHAR2(30) := 'LOCK_TXL_ITM_INSTS';
257: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
258: BEGIN
259: -- Call start_activity to create savepoint, check compatibility
260: -- and initialize message list
261: l_return_status := OKC_API.START_ACTIVITY (l_api_name

Line 261: l_return_status := OKC_API.START_ACTIVITY (l_api_name

257: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
258: BEGIN
259: -- Call start_activity to create savepoint, check compatibility
260: -- and initialize message list
261: l_return_status := OKC_API.START_ACTIVITY (l_api_name
262: ,p_init_msg_list
263: ,'_PVT'
264: ,x_return_status);
265: -- Check if activity started successfully

Line 266: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

262: ,p_init_msg_list
263: ,'_PVT'
264: ,x_return_status);
265: -- Check if activity started successfully
266: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
267: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
268: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
269: RAISE OKC_API.G_EXCEPTION_ERROR;
270: END IF;

Line 267: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

263: ,'_PVT'
264: ,x_return_status);
265: -- Check if activity started successfully
266: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
267: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
268: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
269: RAISE OKC_API.G_EXCEPTION_ERROR;
270: END IF;
271: -- evaluate conditions, build outcomes for true conditions and

Line 268: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

264: ,x_return_status);
265: -- Check if activity started successfully
266: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
267: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
268: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
269: RAISE OKC_API.G_EXCEPTION_ERROR;
270: END IF;
271: -- evaluate conditions, build outcomes for true conditions and
272: -- put them on outcome queue

Line 269: RAISE OKC_API.G_EXCEPTION_ERROR;

265: -- Check if activity started successfully
266: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
267: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
268: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
269: RAISE OKC_API.G_EXCEPTION_ERROR;
270: END IF;
271: -- evaluate conditions, build outcomes for true conditions and
272: -- put them on outcome queue
273: OKL_ITI_PVT.lock_row(p_api_version,

Line 279: OKC_API.END_ACTIVITY (x_msg_count

275: x_return_status,
276: x_msg_count,
277: x_msg_data,
278: p_iivv_rec);
279: OKC_API.END_ACTIVITY (x_msg_count
280: ,x_msg_data );
281: EXCEPTION
282: WHEN OKC_API.G_EXCEPTION_ERROR THEN
283: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 282: WHEN OKC_API.G_EXCEPTION_ERROR THEN

278: p_iivv_rec);
279: OKC_API.END_ACTIVITY (x_msg_count
280: ,x_msg_data );
281: EXCEPTION
282: WHEN OKC_API.G_EXCEPTION_ERROR THEN
283: x_return_status := OKC_API.HANDLE_EXCEPTIONS
284: (l_api_name,
285: G_PKG_NAME,
286: 'OKC_API.G_RET_STS_ERROR',

Line 283: x_return_status := OKC_API.HANDLE_EXCEPTIONS

279: OKC_API.END_ACTIVITY (x_msg_count
280: ,x_msg_data );
281: EXCEPTION
282: WHEN OKC_API.G_EXCEPTION_ERROR THEN
283: x_return_status := OKC_API.HANDLE_EXCEPTIONS
284: (l_api_name,
285: G_PKG_NAME,
286: 'OKC_API.G_RET_STS_ERROR',
287: x_msg_count,

Line 286: 'OKC_API.G_RET_STS_ERROR',

282: WHEN OKC_API.G_EXCEPTION_ERROR THEN
283: x_return_status := OKC_API.HANDLE_EXCEPTIONS
284: (l_api_name,
285: G_PKG_NAME,
286: 'OKC_API.G_RET_STS_ERROR',
287: x_msg_count,
288: x_msg_data,
289: '_PVT');
290: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 290: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

286: 'OKC_API.G_RET_STS_ERROR',
287: x_msg_count,
288: x_msg_data,
289: '_PVT');
290: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
291: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
292: (l_api_name,
293: G_PKG_NAME,
294: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 291: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

287: x_msg_count,
288: x_msg_data,
289: '_PVT');
290: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
291: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
292: (l_api_name,
293: G_PKG_NAME,
294: 'OKC_API.G_RET_STS_UNEXP_ERROR',
295: x_msg_count,

Line 294: 'OKC_API.G_RET_STS_UNEXP_ERROR',

290: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
291: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
292: (l_api_name,
293: G_PKG_NAME,
294: 'OKC_API.G_RET_STS_UNEXP_ERROR',
295: x_msg_count,
296: x_msg_data,
297: '_PVT');
298: WHEN OTHERS THEN x_return_status :=OKC_API.HANDLE_EXCEPTIONS

Line 298: WHEN OTHERS THEN x_return_status :=OKC_API.HANDLE_EXCEPTIONS

294: 'OKC_API.G_RET_STS_UNEXP_ERROR',
295: x_msg_count,
296: x_msg_data,
297: '_PVT');
298: WHEN OTHERS THEN x_return_status :=OKC_API.HANDLE_EXCEPTIONS
299: (l_api_name,
300: G_PKG_NAME,
301: 'OTHERS',
302: x_msg_count,

Line 309: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

305: END lock_txl_itm_insts;
306:
307: PROCEDURE lock_txl_itm_insts(
308: p_api_version IN NUMBER,
309: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
310: x_return_status OUT NOCOPY VARCHAR2,
311: x_msg_count OUT NOCOPY NUMBER,
312: x_msg_data OUT NOCOPY VARCHAR2,
313: p_iivv_tbl IN iivv_tbl_type)

Line 316: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

312: x_msg_data OUT NOCOPY VARCHAR2,
313: p_iivv_tbl IN iivv_tbl_type)
314: IS
315: l_api_name CONSTANT VARCHAR2(30) := 'LOCK_TXL_ITM_INSTS';
316: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
317: BEGIN
318: -- Call start_activity to create savepoint, check compatibility
319: -- and initialize message list
320: l_return_status := OKC_API.START_ACTIVITY (l_api_name

Line 320: l_return_status := OKC_API.START_ACTIVITY (l_api_name

316: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
317: BEGIN
318: -- Call start_activity to create savepoint, check compatibility
319: -- and initialize message list
320: l_return_status := OKC_API.START_ACTIVITY (l_api_name
321: ,p_init_msg_list
322: ,'_PVT'
323: ,x_return_status);
324: -- Check if activity started successfully

Line 325: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

321: ,p_init_msg_list
322: ,'_PVT'
323: ,x_return_status);
324: -- Check if activity started successfully
325: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
326: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
327: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
328: RAISE OKC_API.G_EXCEPTION_ERROR;
329: END IF;

Line 326: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

322: ,'_PVT'
323: ,x_return_status);
324: -- Check if activity started successfully
325: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
326: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
327: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
328: RAISE OKC_API.G_EXCEPTION_ERROR;
329: END IF;
330: -- evaluate conditions, build outcomes for true conditions and

Line 327: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

323: ,x_return_status);
324: -- Check if activity started successfully
325: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
326: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
327: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
328: RAISE OKC_API.G_EXCEPTION_ERROR;
329: END IF;
330: -- evaluate conditions, build outcomes for true conditions and
331: -- put them on outcome queue

Line 328: RAISE OKC_API.G_EXCEPTION_ERROR;

324: -- Check if activity started successfully
325: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
326: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
327: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
328: RAISE OKC_API.G_EXCEPTION_ERROR;
329: END IF;
330: -- evaluate conditions, build outcomes for true conditions and
331: -- put them on outcome queue
332: OKL_ITI_PVT.lock_row(p_api_version,

Line 338: OKC_API.END_ACTIVITY (x_msg_count

334: x_return_status,
335: x_msg_count,
336: x_msg_data,
337: p_iivv_tbl);
338: OKC_API.END_ACTIVITY (x_msg_count
339: ,x_msg_data );
340: EXCEPTION
341: WHEN OKC_API.G_EXCEPTION_ERROR THEN
342: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 341: WHEN OKC_API.G_EXCEPTION_ERROR THEN

337: p_iivv_tbl);
338: OKC_API.END_ACTIVITY (x_msg_count
339: ,x_msg_data );
340: EXCEPTION
341: WHEN OKC_API.G_EXCEPTION_ERROR THEN
342: x_return_status := OKC_API.HANDLE_EXCEPTIONS
343: (l_api_name,
344: G_PKG_NAME,
345: 'OKC_API.G_RET_STS_ERROR',

Line 342: x_return_status := OKC_API.HANDLE_EXCEPTIONS

338: OKC_API.END_ACTIVITY (x_msg_count
339: ,x_msg_data );
340: EXCEPTION
341: WHEN OKC_API.G_EXCEPTION_ERROR THEN
342: x_return_status := OKC_API.HANDLE_EXCEPTIONS
343: (l_api_name,
344: G_PKG_NAME,
345: 'OKC_API.G_RET_STS_ERROR',
346: x_msg_count,

Line 345: 'OKC_API.G_RET_STS_ERROR',

341: WHEN OKC_API.G_EXCEPTION_ERROR THEN
342: x_return_status := OKC_API.HANDLE_EXCEPTIONS
343: (l_api_name,
344: G_PKG_NAME,
345: 'OKC_API.G_RET_STS_ERROR',
346: x_msg_count,
347: x_msg_data,
348: '_PVT');
349: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 349: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

345: 'OKC_API.G_RET_STS_ERROR',
346: x_msg_count,
347: x_msg_data,
348: '_PVT');
349: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
350: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
351: (l_api_name,
352: G_PKG_NAME,
353: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 350: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

346: x_msg_count,
347: x_msg_data,
348: '_PVT');
349: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
350: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
351: (l_api_name,
352: G_PKG_NAME,
353: 'OKC_API.G_RET_STS_UNEXP_ERROR',
354: x_msg_count,

Line 353: 'OKC_API.G_RET_STS_UNEXP_ERROR',

349: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
350: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
351: (l_api_name,
352: G_PKG_NAME,
353: 'OKC_API.G_RET_STS_UNEXP_ERROR',
354: x_msg_count,
355: x_msg_data,
356: '_PVT');
357: WHEN OTHERS THEN x_return_status :=OKC_API.HANDLE_EXCEPTIONS

Line 357: WHEN OTHERS THEN x_return_status :=OKC_API.HANDLE_EXCEPTIONS

353: 'OKC_API.G_RET_STS_UNEXP_ERROR',
354: x_msg_count,
355: x_msg_data,
356: '_PVT');
357: WHEN OTHERS THEN x_return_status :=OKC_API.HANDLE_EXCEPTIONS
358: (l_api_name,
359: G_PKG_NAME,
360: 'OTHERS',
361: x_msg_count,

Line 368: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

364: END lock_txl_itm_insts;
365:
366: PROCEDURE update_txl_itm_insts(
367: p_api_version IN NUMBER,
368: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
369: x_return_status OUT NOCOPY VARCHAR2,
370: x_msg_count OUT NOCOPY NUMBER,
371: x_msg_data OUT NOCOPY VARCHAR2,
372: p_iivv_rec IN iivv_rec_type,

Line 394: x_return_status := OKC_API.G_RET_STS_SUCCESS;

390: l_old_serial_num okl_txl_itm_insts.serial_number%TYPE;
391: l_asset_id okl_txl_itm_insts.dnz_cle_id%TYPE;
392: --vthiruva..09-Dec-2004..Added code to enable Business Events..END
393: BEGIN
394: x_return_status := OKC_API.G_RET_STS_SUCCESS;
395: -- Call start_activity to create savepoint, check compatibility
396: -- and initialize message list
397: x_return_status := OKC_API.START_ACTIVITY (l_api_name
398: ,p_init_msg_list

Line 397: x_return_status := OKC_API.START_ACTIVITY (l_api_name

393: BEGIN
394: x_return_status := OKC_API.G_RET_STS_SUCCESS;
395: -- Call start_activity to create savepoint, check compatibility
396: -- and initialize message list
397: x_return_status := OKC_API.START_ACTIVITY (l_api_name
398: ,p_init_msg_list
399: ,'_PVT'
400: ,x_return_status);
401: -- Check if activity started successfully

Line 402: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

398: ,p_init_msg_list
399: ,'_PVT'
400: ,x_return_status);
401: -- Check if activity started successfully
402: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
403: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
404: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
405: RAISE OKC_API.G_EXCEPTION_ERROR;
406: END IF;

Line 403: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

399: ,'_PVT'
400: ,x_return_status);
401: -- Check if activity started successfully
402: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
403: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
404: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
405: RAISE OKC_API.G_EXCEPTION_ERROR;
406: END IF;
407:

Line 404: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

400: ,x_return_status);
401: -- Check if activity started successfully
402: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
403: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
404: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
405: RAISE OKC_API.G_EXCEPTION_ERROR;
406: END IF;
407:
408: --vthiruva..09-Dec-2004..Added code to enable Business Events..START

Line 405: RAISE OKC_API.G_EXCEPTION_ERROR;

401: -- Check if activity started successfully
402: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
403: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
404: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
405: RAISE OKC_API.G_EXCEPTION_ERROR;
406: END IF;
407:
408: --vthiruva..09-Dec-2004..Added code to enable Business Events..START
409: OPEN get_serial_num(p_iivv_rec.id);

Line 411: RAISE OKC_API.G_EXCEPTION_ERROR;

407:
408: --vthiruva..09-Dec-2004..Added code to enable Business Events..START
409: OPEN get_serial_num(p_iivv_rec.id);
410: IF get_serial_num%NOTFOUND THEN
411: RAISE OKC_API.G_EXCEPTION_ERROR;
412: END IF;
413: FETCH get_serial_num INTO l_old_serial_num, l_asset_id;
414: CLOSE get_serial_num;
415: --vthiruva..09-Dec-2004..Added code to enable Business Events..END

Line 425: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

421: x_msg_count,
422: x_msg_data,
423: p_iivv_rec,
424: x_iivv_rec);
425: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
426: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
427: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
428: RAISE OKC_API.G_EXCEPTION_ERROR;
429: END IF;

Line 426: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

422: x_msg_data,
423: p_iivv_rec,
424: x_iivv_rec);
425: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
426: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
427: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
428: RAISE OKC_API.G_EXCEPTION_ERROR;
429: END IF;
430: IF x_iivv_rec.tal_type in ('CFA','CIB','CRB','CRL','CRV','CSP','ALI') THEN

Line 427: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

423: p_iivv_rec,
424: x_iivv_rec);
425: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
426: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
427: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
428: RAISE OKC_API.G_EXCEPTION_ERROR;
429: END IF;
430: IF x_iivv_rec.tal_type in ('CFA','CIB','CRB','CRL','CRV','CSP','ALI') THEN
431: OPEN get_chr_id(x_iivv_rec.kle_Id);

Line 428: RAISE OKC_API.G_EXCEPTION_ERROR;

424: x_iivv_rec);
425: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
426: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
427: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
428: RAISE OKC_API.G_EXCEPTION_ERROR;
429: END IF;
430: IF x_iivv_rec.tal_type in ('CFA','CIB','CRB','CRL','CRV','CSP','ALI') THEN
431: OPEN get_chr_id(x_iivv_rec.kle_Id);
432: IF get_chr_id%NOTFOUND THEN

Line 433: RAISE OKC_API.G_EXCEPTION_ERROR;

429: END IF;
430: IF x_iivv_rec.tal_type in ('CFA','CIB','CRB','CRL','CRV','CSP','ALI') THEN
431: OPEN get_chr_id(x_iivv_rec.kle_Id);
432: IF get_chr_id%NOTFOUND THEN
433: RAISE OKC_API.G_EXCEPTION_ERROR;
434: END IF;
435: FETCH get_chr_id INTO ln_chr_id;
436: CLOSE get_chr_id;
437: -- We need to change the status of the header whenever there is updating happening

Line 450: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

446: x_msg_count => x_msg_count,
447: x_msg_data => x_msg_data,
448: p_chr_id => ln_chr_id);
449: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
450: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
451: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
452: RAISE OKC_API.G_EXCEPTION_ERROR;
453: END IF;
454: END IF;

Line 452: RAISE OKC_API.G_EXCEPTION_ERROR;

448: p_chr_id => ln_chr_id);
449: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
450: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
451: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
452: RAISE OKC_API.G_EXCEPTION_ERROR;
453: END IF;
454: END IF;
455: --vthiruva..09-Dec-2004..Added code to enable Business Events..START
456: IF(OKL_LLA_UTIL_PVT.is_lease_contract(ln_chr_id)= OKL_API.G_TRUE)THEN

Line 497: OKC_API.END_ACTIVITY (x_msg_count

493: END IF;
494: END IF;
495: --vthiruva..09-Dec-2004..Added code to enable Business Events..END
496: END IF;
497: OKC_API.END_ACTIVITY (x_msg_count
498: ,x_msg_data );
499: EXCEPTION
500: WHEN OKC_API.G_EXCEPTION_ERROR THEN
501: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 500: WHEN OKC_API.G_EXCEPTION_ERROR THEN

496: END IF;
497: OKC_API.END_ACTIVITY (x_msg_count
498: ,x_msg_data );
499: EXCEPTION
500: WHEN OKC_API.G_EXCEPTION_ERROR THEN
501: x_return_status := OKC_API.HANDLE_EXCEPTIONS
502: (l_api_name,
503: G_PKG_NAME,
504: 'OKC_API.G_RET_STS_ERROR',

Line 501: x_return_status := OKC_API.HANDLE_EXCEPTIONS

497: OKC_API.END_ACTIVITY (x_msg_count
498: ,x_msg_data );
499: EXCEPTION
500: WHEN OKC_API.G_EXCEPTION_ERROR THEN
501: x_return_status := OKC_API.HANDLE_EXCEPTIONS
502: (l_api_name,
503: G_PKG_NAME,
504: 'OKC_API.G_RET_STS_ERROR',
505: x_msg_count,

Line 504: 'OKC_API.G_RET_STS_ERROR',

500: WHEN OKC_API.G_EXCEPTION_ERROR THEN
501: x_return_status := OKC_API.HANDLE_EXCEPTIONS
502: (l_api_name,
503: G_PKG_NAME,
504: 'OKC_API.G_RET_STS_ERROR',
505: x_msg_count,
506: x_msg_data,
507: '_PVT');
508: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 508: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

504: 'OKC_API.G_RET_STS_ERROR',
505: x_msg_count,
506: x_msg_data,
507: '_PVT');
508: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
509: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
510: (l_api_name,
511: G_PKG_NAME,
512: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 509: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

505: x_msg_count,
506: x_msg_data,
507: '_PVT');
508: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
509: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
510: (l_api_name,
511: G_PKG_NAME,
512: 'OKC_API.G_RET_STS_UNEXP_ERROR',
513: x_msg_count,

Line 512: 'OKC_API.G_RET_STS_UNEXP_ERROR',

508: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
509: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
510: (l_api_name,
511: G_PKG_NAME,
512: 'OKC_API.G_RET_STS_UNEXP_ERROR',
513: x_msg_count,
514: x_msg_data,
515: '_PVT');
516: WHEN OTHERS THEN x_return_status :=OKC_API.HANDLE_EXCEPTIONS

Line 516: WHEN OTHERS THEN x_return_status :=OKC_API.HANDLE_EXCEPTIONS

512: 'OKC_API.G_RET_STS_UNEXP_ERROR',
513: x_msg_count,
514: x_msg_data,
515: '_PVT');
516: WHEN OTHERS THEN x_return_status :=OKC_API.HANDLE_EXCEPTIONS
517: (l_api_name,
518: G_PKG_NAME,
519: 'OTHERS',
520: x_msg_count,

Line 527: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

523: END update_txl_itm_insts;
524:
525: PROCEDURE update_txl_itm_insts(
526: p_api_version IN NUMBER,
527: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
528: x_return_status OUT NOCOPY VARCHAR2,
529: x_msg_count OUT NOCOPY NUMBER,
530: x_msg_data OUT NOCOPY VARCHAR2,
531: p_iivv_tbl IN iivv_tbl_type,

Line 535: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

531: p_iivv_tbl IN iivv_tbl_type,
532: x_iivv_tbl OUT NOCOPY iivv_tbl_type)
533: IS
534: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_TXL_ITM_INSTS';
535: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
536: BEGIN
537: -- Call start_activity to create savepoint, check compatibility
538: -- and initialize message list
539: l_return_status := OKC_API.START_ACTIVITY (l_api_name

Line 539: l_return_status := OKC_API.START_ACTIVITY (l_api_name

535: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
536: BEGIN
537: -- Call start_activity to create savepoint, check compatibility
538: -- and initialize message list
539: l_return_status := OKC_API.START_ACTIVITY (l_api_name
540: ,p_init_msg_list
541: ,'_PVT'
542: ,x_return_status);
543: -- Check if activity started successfully

Line 544: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

540: ,p_init_msg_list
541: ,'_PVT'
542: ,x_return_status);
543: -- Check if activity started successfully
544: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
545: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
546: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
547: RAISE OKC_API.G_EXCEPTION_ERROR;
548: END IF;

Line 545: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

541: ,'_PVT'
542: ,x_return_status);
543: -- Check if activity started successfully
544: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
545: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
546: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
547: RAISE OKC_API.G_EXCEPTION_ERROR;
548: END IF;
549: -- evaluate conditions, build outcomes for true conditions and

Line 546: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

542: ,x_return_status);
543: -- Check if activity started successfully
544: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
545: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
546: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
547: RAISE OKC_API.G_EXCEPTION_ERROR;
548: END IF;
549: -- evaluate conditions, build outcomes for true conditions and
550: -- put them on outcome queue

Line 547: RAISE OKC_API.G_EXCEPTION_ERROR;

543: -- Check if activity started successfully
544: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
545: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
546: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
547: RAISE OKC_API.G_EXCEPTION_ERROR;
548: END IF;
549: -- evaluate conditions, build outcomes for true conditions and
550: -- put them on outcome queue
551: OKL_ITI_PVT.update_row(p_api_version,

Line 558: OKC_API.END_ACTIVITY (x_msg_count

554: x_msg_count,
555: x_msg_data,
556: p_iivv_tbl,
557: x_iivv_tbl);
558: OKC_API.END_ACTIVITY (x_msg_count
559: ,x_msg_data );
560: EXCEPTION
561: WHEN OKC_API.G_EXCEPTION_ERROR THEN
562: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 561: WHEN OKC_API.G_EXCEPTION_ERROR THEN

557: x_iivv_tbl);
558: OKC_API.END_ACTIVITY (x_msg_count
559: ,x_msg_data );
560: EXCEPTION
561: WHEN OKC_API.G_EXCEPTION_ERROR THEN
562: x_return_status := OKC_API.HANDLE_EXCEPTIONS
563: (l_api_name,
564: G_PKG_NAME,
565: 'OKC_API.G_RET_STS_ERROR',

Line 562: x_return_status := OKC_API.HANDLE_EXCEPTIONS

558: OKC_API.END_ACTIVITY (x_msg_count
559: ,x_msg_data );
560: EXCEPTION
561: WHEN OKC_API.G_EXCEPTION_ERROR THEN
562: x_return_status := OKC_API.HANDLE_EXCEPTIONS
563: (l_api_name,
564: G_PKG_NAME,
565: 'OKC_API.G_RET_STS_ERROR',
566: x_msg_count,

Line 565: 'OKC_API.G_RET_STS_ERROR',

561: WHEN OKC_API.G_EXCEPTION_ERROR THEN
562: x_return_status := OKC_API.HANDLE_EXCEPTIONS
563: (l_api_name,
564: G_PKG_NAME,
565: 'OKC_API.G_RET_STS_ERROR',
566: x_msg_count,
567: x_msg_data,
568: '_PVT');
569: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 569: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

565: 'OKC_API.G_RET_STS_ERROR',
566: x_msg_count,
567: x_msg_data,
568: '_PVT');
569: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
570: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
571: (l_api_name,
572: G_PKG_NAME,
573: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 570: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

566: x_msg_count,
567: x_msg_data,
568: '_PVT');
569: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
570: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
571: (l_api_name,
572: G_PKG_NAME,
573: 'OKC_API.G_RET_STS_UNEXP_ERROR',
574: x_msg_count,

Line 573: 'OKC_API.G_RET_STS_UNEXP_ERROR',

569: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
570: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
571: (l_api_name,
572: G_PKG_NAME,
573: 'OKC_API.G_RET_STS_UNEXP_ERROR',
574: x_msg_count,
575: x_msg_data,
576: '_PVT');
577: WHEN OTHERS THEN x_return_status :=OKC_API.HANDLE_EXCEPTIONS

Line 577: WHEN OTHERS THEN x_return_status :=OKC_API.HANDLE_EXCEPTIONS

573: 'OKC_API.G_RET_STS_UNEXP_ERROR',
574: x_msg_count,
575: x_msg_data,
576: '_PVT');
577: WHEN OTHERS THEN x_return_status :=OKC_API.HANDLE_EXCEPTIONS
578: (l_api_name,
579: G_PKG_NAME,
580: 'OTHERS',
581: x_msg_count,

Line 588: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

584: END update_txl_itm_insts;
585:
586: PROCEDURE delete_txl_itm_insts(
587: p_api_version IN NUMBER,
588: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
589: x_return_status OUT NOCOPY VARCHAR2,
590: x_msg_count OUT NOCOPY NUMBER,
591: x_msg_data OUT NOCOPY VARCHAR2,
592: p_iivv_rec IN iivv_rec_type)

Line 622: x_return_status := OKC_API.G_RET_STS_SUCCESS;

618: * from the item instance to pass the parameters to the business event. EMD
619: */
620:
621: BEGIN
622: x_return_status := OKC_API.G_RET_STS_SUCCESS;
623: -- Call start_activity to create savepoint, check compatibility
624: -- and initialize message list
625: x_return_status := OKC_API.START_ACTIVITY (l_api_name
626: ,p_init_msg_list

Line 625: x_return_status := OKC_API.START_ACTIVITY (l_api_name

621: BEGIN
622: x_return_status := OKC_API.G_RET_STS_SUCCESS;
623: -- Call start_activity to create savepoint, check compatibility
624: -- and initialize message list
625: x_return_status := OKC_API.START_ACTIVITY (l_api_name
626: ,p_init_msg_list
627: ,'_PVT'
628: ,x_return_status);
629: -- Check if activity started successfully

Line 630: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

626: ,p_init_msg_list
627: ,'_PVT'
628: ,x_return_status);
629: -- Check if activity started successfully
630: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
631: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
632: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
633: RAISE OKC_API.G_EXCEPTION_ERROR;
634: END IF;

Line 631: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

627: ,'_PVT'
628: ,x_return_status);
629: -- Check if activity started successfully
630: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
631: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
632: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
633: RAISE OKC_API.G_EXCEPTION_ERROR;
634: END IF;
635: /*

Line 632: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

628: ,x_return_status);
629: -- Check if activity started successfully
630: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
631: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
632: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
633: RAISE OKC_API.G_EXCEPTION_ERROR;
634: END IF;
635: /*
636: * sjalasut: oct 19, 04 added cursor to fetch the contract in context. BEGIN

Line 633: RAISE OKC_API.G_EXCEPTION_ERROR;

629: -- Check if activity started successfully
630: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
631: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
632: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
633: RAISE OKC_API.G_EXCEPTION_ERROR;
634: END IF;
635: /*
636: * sjalasut: oct 19, 04 added cursor to fetch the contract in context. BEGIN
637: *

Line 654: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

650: x_return_status,
651: x_msg_count,
652: x_msg_data,
653: p_iivv_rec);
654: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
655: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
656: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
657: RAISE OKC_API.G_EXCEPTION_ERROR;
658: END IF;

Line 655: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

651: x_msg_count,
652: x_msg_data,
653: p_iivv_rec);
654: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
655: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
656: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
657: RAISE OKC_API.G_EXCEPTION_ERROR;
658: END IF;
659: /*

Line 656: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

652: x_msg_data,
653: p_iivv_rec);
654: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
655: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
656: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
657: RAISE OKC_API.G_EXCEPTION_ERROR;
658: END IF;
659: /*
660: * sjalasut: oct 14, 04 added code to enable business event. BEGIN

Line 657: RAISE OKC_API.G_EXCEPTION_ERROR;

653: p_iivv_rec);
654: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
655: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
656: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
657: RAISE OKC_API.G_EXCEPTION_ERROR;
658: END IF;
659: /*
660: * sjalasut: oct 14, 04 added code to enable business event. BEGIN
661: * raise business event only if the contract is a LEASE contract

Line 687: RAISE OKC_API.G_EXCEPTION_ERROR;

683:
684: IF p_iivv_rec.tal_type in ('CFA','CIB','CRB','CRL','CRV','CSP','ALI') THEN
685: OPEN get_chr_id(p_iivv_rec.kle_Id);
686: IF get_chr_id%NOTFOUND THEN
687: RAISE OKC_API.G_EXCEPTION_ERROR;
688: END IF;
689: FETCH get_chr_id INTO ln_chr_id;
690: CLOSE get_chr_id;
691: -- We need to change the status of the header whenever there is updating happening

Line 704: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

700: x_msg_count => x_msg_count,
701: x_msg_data => x_msg_data,
702: p_chr_id => ln_chr_id);
703: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
704: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
705: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
706: RAISE OKC_API.G_EXCEPTION_ERROR;
707: END IF;
708: END IF;

Line 706: RAISE OKC_API.G_EXCEPTION_ERROR;

702: p_chr_id => ln_chr_id);
703: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
704: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
705: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
706: RAISE OKC_API.G_EXCEPTION_ERROR;
707: END IF;
708: END IF;
709: END IF;
710:

Line 711: OKC_API.END_ACTIVITY (x_msg_count

707: END IF;
708: END IF;
709: END IF;
710:
711: OKC_API.END_ACTIVITY (x_msg_count
712: ,x_msg_data );
713: EXCEPTION
714: WHEN OKC_API.G_EXCEPTION_ERROR THEN
715: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 714: WHEN OKC_API.G_EXCEPTION_ERROR THEN

710:
711: OKC_API.END_ACTIVITY (x_msg_count
712: ,x_msg_data );
713: EXCEPTION
714: WHEN OKC_API.G_EXCEPTION_ERROR THEN
715: x_return_status := OKC_API.HANDLE_EXCEPTIONS
716: (l_api_name,
717: G_PKG_NAME,
718: 'OKC_API.G_RET_STS_ERROR',

Line 715: x_return_status := OKC_API.HANDLE_EXCEPTIONS

711: OKC_API.END_ACTIVITY (x_msg_count
712: ,x_msg_data );
713: EXCEPTION
714: WHEN OKC_API.G_EXCEPTION_ERROR THEN
715: x_return_status := OKC_API.HANDLE_EXCEPTIONS
716: (l_api_name,
717: G_PKG_NAME,
718: 'OKC_API.G_RET_STS_ERROR',
719: x_msg_count,

Line 718: 'OKC_API.G_RET_STS_ERROR',

714: WHEN OKC_API.G_EXCEPTION_ERROR THEN
715: x_return_status := OKC_API.HANDLE_EXCEPTIONS
716: (l_api_name,
717: G_PKG_NAME,
718: 'OKC_API.G_RET_STS_ERROR',
719: x_msg_count,
720: x_msg_data,
721: '_PVT');
722: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 722: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

718: 'OKC_API.G_RET_STS_ERROR',
719: x_msg_count,
720: x_msg_data,
721: '_PVT');
722: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
723: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
724: (l_api_name,
725: G_PKG_NAME,
726: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 723: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

719: x_msg_count,
720: x_msg_data,
721: '_PVT');
722: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
723: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
724: (l_api_name,
725: G_PKG_NAME,
726: 'OKC_API.G_RET_STS_UNEXP_ERROR',
727: x_msg_count,

Line 726: 'OKC_API.G_RET_STS_UNEXP_ERROR',

722: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
723: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
724: (l_api_name,
725: G_PKG_NAME,
726: 'OKC_API.G_RET_STS_UNEXP_ERROR',
727: x_msg_count,
728: x_msg_data,
729: '_PVT');
730: WHEN OTHERS THEN x_return_status :=OKC_API.HANDLE_EXCEPTIONS

Line 730: WHEN OTHERS THEN x_return_status :=OKC_API.HANDLE_EXCEPTIONS

726: 'OKC_API.G_RET_STS_UNEXP_ERROR',
727: x_msg_count,
728: x_msg_data,
729: '_PVT');
730: WHEN OTHERS THEN x_return_status :=OKC_API.HANDLE_EXCEPTIONS
731: (l_api_name,
732: G_PKG_NAME,
733: 'OTHERS',
734: x_msg_count,

Line 741: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

737: END delete_txl_itm_insts;
738:
739: PROCEDURE delete_txl_itm_insts(
740: p_api_version IN NUMBER,
741: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
742: x_return_status OUT NOCOPY VARCHAR2,
743: x_msg_count OUT NOCOPY NUMBER,
744: x_msg_data OUT NOCOPY VARCHAR2,
745: p_iivv_tbl IN iivv_tbl_type)

Line 748: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

744: x_msg_data OUT NOCOPY VARCHAR2,
745: p_iivv_tbl IN iivv_tbl_type)
746: IS
747: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_TXL_ITM_INSTS';
748: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
749: BEGIN
750: -- Call start_activity to create savepoint, check compatibility
751: -- and initialize message list
752: l_return_status := OKC_API.START_ACTIVITY (l_api_name

Line 752: l_return_status := OKC_API.START_ACTIVITY (l_api_name

748: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
749: BEGIN
750: -- Call start_activity to create savepoint, check compatibility
751: -- and initialize message list
752: l_return_status := OKC_API.START_ACTIVITY (l_api_name
753: ,p_init_msg_list
754: ,'_PVT'
755: ,x_return_status);
756: -- Check if activity started successfully

Line 757: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

753: ,p_init_msg_list
754: ,'_PVT'
755: ,x_return_status);
756: -- Check if activity started successfully
757: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
758: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
759: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
760: RAISE OKC_API.G_EXCEPTION_ERROR;
761: END IF;

Line 758: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

754: ,'_PVT'
755: ,x_return_status);
756: -- Check if activity started successfully
757: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
758: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
759: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
760: RAISE OKC_API.G_EXCEPTION_ERROR;
761: END IF;
762: -- evaluate conditions, build outcomes for true conditions and

Line 759: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

755: ,x_return_status);
756: -- Check if activity started successfully
757: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
758: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
759: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
760: RAISE OKC_API.G_EXCEPTION_ERROR;
761: END IF;
762: -- evaluate conditions, build outcomes for true conditions and
763: -- put them on outcome queue

Line 760: RAISE OKC_API.G_EXCEPTION_ERROR;

756: -- Check if activity started successfully
757: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
758: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
759: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
760: RAISE OKC_API.G_EXCEPTION_ERROR;
761: END IF;
762: -- evaluate conditions, build outcomes for true conditions and
763: -- put them on outcome queue
764: OKL_ITI_PVT.delete_row(p_api_version,

Line 770: OKC_API.END_ACTIVITY (x_msg_count

766: x_return_status,
767: x_msg_count,
768: x_msg_data,
769: p_iivv_tbl);
770: OKC_API.END_ACTIVITY (x_msg_count
771: ,x_msg_data );
772: EXCEPTION
773: WHEN OKC_API.G_EXCEPTION_ERROR THEN
774: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 773: WHEN OKC_API.G_EXCEPTION_ERROR THEN

769: p_iivv_tbl);
770: OKC_API.END_ACTIVITY (x_msg_count
771: ,x_msg_data );
772: EXCEPTION
773: WHEN OKC_API.G_EXCEPTION_ERROR THEN
774: x_return_status := OKC_API.HANDLE_EXCEPTIONS
775: (l_api_name,
776: G_PKG_NAME,
777: 'OKC_API.G_RET_STS_ERROR',

Line 774: x_return_status := OKC_API.HANDLE_EXCEPTIONS

770: OKC_API.END_ACTIVITY (x_msg_count
771: ,x_msg_data );
772: EXCEPTION
773: WHEN OKC_API.G_EXCEPTION_ERROR THEN
774: x_return_status := OKC_API.HANDLE_EXCEPTIONS
775: (l_api_name,
776: G_PKG_NAME,
777: 'OKC_API.G_RET_STS_ERROR',
778: x_msg_count,

Line 777: 'OKC_API.G_RET_STS_ERROR',

773: WHEN OKC_API.G_EXCEPTION_ERROR THEN
774: x_return_status := OKC_API.HANDLE_EXCEPTIONS
775: (l_api_name,
776: G_PKG_NAME,
777: 'OKC_API.G_RET_STS_ERROR',
778: x_msg_count,
779: x_msg_data,
780: '_PVT');
781: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 781: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

777: 'OKC_API.G_RET_STS_ERROR',
778: x_msg_count,
779: x_msg_data,
780: '_PVT');
781: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
782: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
783: (l_api_name,
784: G_PKG_NAME,
785: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 782: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

778: x_msg_count,
779: x_msg_data,
780: '_PVT');
781: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
782: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
783: (l_api_name,
784: G_PKG_NAME,
785: 'OKC_API.G_RET_STS_UNEXP_ERROR',
786: x_msg_count,

Line 785: 'OKC_API.G_RET_STS_UNEXP_ERROR',

781: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
782: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
783: (l_api_name,
784: G_PKG_NAME,
785: 'OKC_API.G_RET_STS_UNEXP_ERROR',
786: x_msg_count,
787: x_msg_data,
788: '_PVT');
789: WHEN OTHERS THEN x_return_status :=OKC_API.HANDLE_EXCEPTIONS

Line 789: WHEN OTHERS THEN x_return_status :=OKC_API.HANDLE_EXCEPTIONS

785: 'OKC_API.G_RET_STS_UNEXP_ERROR',
786: x_msg_count,
787: x_msg_data,
788: '_PVT');
789: WHEN OTHERS THEN x_return_status :=OKC_API.HANDLE_EXCEPTIONS
790: (l_api_name,
791: G_PKG_NAME,
792: 'OTHERS',
793: x_msg_count,

Line 800: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

796: END delete_txl_itm_insts;
797:
798: PROCEDURE validate_txl_itm_insts(
799: p_api_version IN NUMBER,
800: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
801: x_return_status OUT NOCOPY VARCHAR2,
802: x_msg_count OUT NOCOPY NUMBER,
803: x_msg_data OUT NOCOPY VARCHAR2,
804: p_iivv_rec IN iivv_rec_type)

Line 807: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

803: x_msg_data OUT NOCOPY VARCHAR2,
804: p_iivv_rec IN iivv_rec_type)
805: IS
806: l_api_name CONSTANT VARCHAR2(30) := 'VALIDATE_TXL_ITM_INSTS';
807: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
808: BEGIN
809: -- Call start_activity to create savepoint, check compatibility
810: -- and initialize message list
811: l_return_status := OKC_API.START_ACTIVITY (l_api_name

Line 811: l_return_status := OKC_API.START_ACTIVITY (l_api_name

807: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
808: BEGIN
809: -- Call start_activity to create savepoint, check compatibility
810: -- and initialize message list
811: l_return_status := OKC_API.START_ACTIVITY (l_api_name
812: ,p_init_msg_list
813: ,'_PVT'
814: ,x_return_status);
815: -- Check if activity started successfully

Line 816: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

812: ,p_init_msg_list
813: ,'_PVT'
814: ,x_return_status);
815: -- Check if activity started successfully
816: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
817: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
818: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
819: RAISE OKC_API.G_EXCEPTION_ERROR;
820: END IF;

Line 817: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

813: ,'_PVT'
814: ,x_return_status);
815: -- Check if activity started successfully
816: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
817: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
818: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
819: RAISE OKC_API.G_EXCEPTION_ERROR;
820: END IF;
821: -- evaluate conditions, build outcomes for true conditions and

Line 818: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

814: ,x_return_status);
815: -- Check if activity started successfully
816: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
817: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
818: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
819: RAISE OKC_API.G_EXCEPTION_ERROR;
820: END IF;
821: -- evaluate conditions, build outcomes for true conditions and
822: -- put them on outcome queue

Line 819: RAISE OKC_API.G_EXCEPTION_ERROR;

815: -- Check if activity started successfully
816: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
817: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
818: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
819: RAISE OKC_API.G_EXCEPTION_ERROR;
820: END IF;
821: -- evaluate conditions, build outcomes for true conditions and
822: -- put them on outcome queue
823: OKL_ITI_PVT.validate_row(p_api_version,

Line 829: OKC_API.END_ACTIVITY (x_msg_count

825: x_return_status,
826: x_msg_count,
827: x_msg_data,
828: p_iivv_rec);
829: OKC_API.END_ACTIVITY (x_msg_count
830: ,x_msg_data );
831: EXCEPTION
832: WHEN OKC_API.G_EXCEPTION_ERROR THEN
833: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 832: WHEN OKC_API.G_EXCEPTION_ERROR THEN

828: p_iivv_rec);
829: OKC_API.END_ACTIVITY (x_msg_count
830: ,x_msg_data );
831: EXCEPTION
832: WHEN OKC_API.G_EXCEPTION_ERROR THEN
833: x_return_status := OKC_API.HANDLE_EXCEPTIONS
834: (l_api_name,
835: G_PKG_NAME,
836: 'OKC_API.G_RET_STS_ERROR',

Line 833: x_return_status := OKC_API.HANDLE_EXCEPTIONS

829: OKC_API.END_ACTIVITY (x_msg_count
830: ,x_msg_data );
831: EXCEPTION
832: WHEN OKC_API.G_EXCEPTION_ERROR THEN
833: x_return_status := OKC_API.HANDLE_EXCEPTIONS
834: (l_api_name,
835: G_PKG_NAME,
836: 'OKC_API.G_RET_STS_ERROR',
837: x_msg_count,

Line 836: 'OKC_API.G_RET_STS_ERROR',

832: WHEN OKC_API.G_EXCEPTION_ERROR THEN
833: x_return_status := OKC_API.HANDLE_EXCEPTIONS
834: (l_api_name,
835: G_PKG_NAME,
836: 'OKC_API.G_RET_STS_ERROR',
837: x_msg_count,
838: x_msg_data,
839: '_PVT');
840: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 840: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

836: 'OKC_API.G_RET_STS_ERROR',
837: x_msg_count,
838: x_msg_data,
839: '_PVT');
840: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
841: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
842: (l_api_name,
843: G_PKG_NAME,
844: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 841: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

837: x_msg_count,
838: x_msg_data,
839: '_PVT');
840: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
841: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
842: (l_api_name,
843: G_PKG_NAME,
844: 'OKC_API.G_RET_STS_UNEXP_ERROR',
845: x_msg_count,

Line 844: 'OKC_API.G_RET_STS_UNEXP_ERROR',

840: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
841: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
842: (l_api_name,
843: G_PKG_NAME,
844: 'OKC_API.G_RET_STS_UNEXP_ERROR',
845: x_msg_count,
846: x_msg_data,
847: '_PVT');
848: WHEN OTHERS THEN x_return_status :=OKC_API.HANDLE_EXCEPTIONS

Line 848: WHEN OTHERS THEN x_return_status :=OKC_API.HANDLE_EXCEPTIONS

844: 'OKC_API.G_RET_STS_UNEXP_ERROR',
845: x_msg_count,
846: x_msg_data,
847: '_PVT');
848: WHEN OTHERS THEN x_return_status :=OKC_API.HANDLE_EXCEPTIONS
849: (l_api_name,
850: G_PKG_NAME,
851: 'OTHERS',
852: x_msg_count,

Line 859: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

855: END validate_txl_itm_insts;
856:
857: PROCEDURE validate_txl_itm_insts(
858: p_api_version IN NUMBER,
859: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
860: x_return_status OUT NOCOPY VARCHAR2,
861: x_msg_count OUT NOCOPY NUMBER,
862: x_msg_data OUT NOCOPY VARCHAR2,
863: p_iivv_tbl IN iivv_tbl_type)

Line 866: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

862: x_msg_data OUT NOCOPY VARCHAR2,
863: p_iivv_tbl IN iivv_tbl_type)
864: IS
865: l_api_name CONSTANT VARCHAR2(30) := 'VALIDATE_TXL_ITM_INSTS';
866: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
867: BEGIN
868: -- Call start_activity to create savepoint, check compatibility
869: -- and initialize message list
870: l_return_status := OKC_API.START_ACTIVITY (l_api_name

Line 870: l_return_status := OKC_API.START_ACTIVITY (l_api_name

866: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
867: BEGIN
868: -- Call start_activity to create savepoint, check compatibility
869: -- and initialize message list
870: l_return_status := OKC_API.START_ACTIVITY (l_api_name
871: ,p_init_msg_list
872: ,'_PVT'
873: ,x_return_status);
874: -- Check if activity started successfully

Line 875: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

871: ,p_init_msg_list
872: ,'_PVT'
873: ,x_return_status);
874: -- Check if activity started successfully
875: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
876: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
877: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
878: RAISE OKC_API.G_EXCEPTION_ERROR;
879: END IF;

Line 876: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

872: ,'_PVT'
873: ,x_return_status);
874: -- Check if activity started successfully
875: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
876: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
877: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
878: RAISE OKC_API.G_EXCEPTION_ERROR;
879: END IF;
880: -- evaluate conditions, build outcomes for true conditions and

Line 877: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

873: ,x_return_status);
874: -- Check if activity started successfully
875: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
876: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
877: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
878: RAISE OKC_API.G_EXCEPTION_ERROR;
879: END IF;
880: -- evaluate conditions, build outcomes for true conditions and
881: -- put them on outcome queue

Line 878: RAISE OKC_API.G_EXCEPTION_ERROR;

874: -- Check if activity started successfully
875: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
876: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
877: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
878: RAISE OKC_API.G_EXCEPTION_ERROR;
879: END IF;
880: -- evaluate conditions, build outcomes for true conditions and
881: -- put them on outcome queue
882: OKL_ITI_PVT.validate_row(p_api_version,

Line 888: OKC_API.END_ACTIVITY (x_msg_count

884: x_return_status,
885: x_msg_count,
886: x_msg_data,
887: p_iivv_tbl);
888: OKC_API.END_ACTIVITY (x_msg_count
889: ,x_msg_data );
890: EXCEPTION
891: WHEN OKC_API.G_EXCEPTION_ERROR THEN
892: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 891: WHEN OKC_API.G_EXCEPTION_ERROR THEN

887: p_iivv_tbl);
888: OKC_API.END_ACTIVITY (x_msg_count
889: ,x_msg_data );
890: EXCEPTION
891: WHEN OKC_API.G_EXCEPTION_ERROR THEN
892: x_return_status := OKC_API.HANDLE_EXCEPTIONS
893: (l_api_name,
894: G_PKG_NAME,
895: 'OKC_API.G_RET_STS_ERROR',

Line 892: x_return_status := OKC_API.HANDLE_EXCEPTIONS

888: OKC_API.END_ACTIVITY (x_msg_count
889: ,x_msg_data );
890: EXCEPTION
891: WHEN OKC_API.G_EXCEPTION_ERROR THEN
892: x_return_status := OKC_API.HANDLE_EXCEPTIONS
893: (l_api_name,
894: G_PKG_NAME,
895: 'OKC_API.G_RET_STS_ERROR',
896: x_msg_count,

Line 895: 'OKC_API.G_RET_STS_ERROR',

891: WHEN OKC_API.G_EXCEPTION_ERROR THEN
892: x_return_status := OKC_API.HANDLE_EXCEPTIONS
893: (l_api_name,
894: G_PKG_NAME,
895: 'OKC_API.G_RET_STS_ERROR',
896: x_msg_count,
897: x_msg_data,
898: '_PVT');
899: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 899: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

895: 'OKC_API.G_RET_STS_ERROR',
896: x_msg_count,
897: x_msg_data,
898: '_PVT');
899: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
900: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
901: (l_api_name,
902: G_PKG_NAME,
903: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 900: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

896: x_msg_count,
897: x_msg_data,
898: '_PVT');
899: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
900: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
901: (l_api_name,
902: G_PKG_NAME,
903: 'OKC_API.G_RET_STS_UNEXP_ERROR',
904: x_msg_count,

Line 903: 'OKC_API.G_RET_STS_UNEXP_ERROR',

899: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
900: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
901: (l_api_name,
902: G_PKG_NAME,
903: 'OKC_API.G_RET_STS_UNEXP_ERROR',
904: x_msg_count,
905: x_msg_data,
906: '_PVT');
907: WHEN OTHERS THEN x_return_status :=OKC_API.HANDLE_EXCEPTIONS

Line 907: WHEN OTHERS THEN x_return_status :=OKC_API.HANDLE_EXCEPTIONS

903: 'OKC_API.G_RET_STS_UNEXP_ERROR',
904: x_msg_count,
905: x_msg_data,
906: '_PVT');
907: WHEN OTHERS THEN x_return_status :=OKC_API.HANDLE_EXCEPTIONS
908: (l_api_name,
909: G_PKG_NAME,
910: 'OTHERS',
911: x_msg_count,

Line 946: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

942: -- End of comments
943:
944: PROCEDURE reset_item_srl_number(
945: p_api_version IN NUMBER,
946: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
947: x_return_status OUT NOCOPY VARCHAR2,
948: x_msg_count OUT NOCOPY NUMBER,
949: x_msg_data OUT NOCOPY VARCHAR2,
950: p_chr_id IN NUMBER,

Line 1138: l_return_status := OKC_API.START_ACTIVITY (l_api_name

1134: x_return_status := OKL_API.G_RET_STS_SUCCESS;
1135:
1136: -- Call start_activity to create savepoint, check compatibility
1137: -- and initialize message list
1138: l_return_status := OKC_API.START_ACTIVITY (l_api_name
1139: ,p_init_msg_list
1140: ,'_PVT'
1141: ,x_return_status);
1142: -- Check if activity started successfully

Line 1143: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1139: ,p_init_msg_list
1140: ,'_PVT'
1141: ,x_return_status);
1142: -- Check if activity started successfully
1143: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1144: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1145: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1146: RAISE OKC_API.G_EXCEPTION_ERROR;
1147: END IF;

Line 1144: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1140: ,'_PVT'
1141: ,x_return_status);
1142: -- Check if activity started successfully
1143: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1144: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1145: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1146: RAISE OKC_API.G_EXCEPTION_ERROR;
1147: END IF;
1148:

Line 1145: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

1141: ,x_return_status);
1142: -- Check if activity started successfully
1143: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1144: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1145: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1146: RAISE OKC_API.G_EXCEPTION_ERROR;
1147: END IF;
1148:
1149: l_chr_valid := 'N';

Line 1146: RAISE OKC_API.G_EXCEPTION_ERROR;

1142: -- Check if activity started successfully
1143: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1144: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1145: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1146: RAISE OKC_API.G_EXCEPTION_ERROR;
1147: END IF;
1148:
1149: l_chr_valid := 'N';
1150: OPEN chr_csr(p_chr_id);

Line 1163: RAISE OKC_API.G_EXCEPTION_ERROR;

1159: p_token1_value => 'p_chr_id'
1160: );
1161:
1162: --dbms_output.put_line('No data found: CHR_ID');
1163: RAISE OKC_API.G_EXCEPTION_ERROR;
1164: END IF;
1165:
1166: IF (p_asset_line_id IS NOT NULL) THEN -- check for FREE_FORM1 line
1167:

Line 1179: RAISE OKC_API.G_EXCEPTION_ERROR;

1175: p_token1 => 'COL_NAME',
1176: p_token1_value => 'p_asset_line_id'
1177: );
1178: --dbms_output.put_line('No data found: LINE_ID');
1179: RAISE OKC_API.G_EXCEPTION_ERROR;
1180: END IF;
1181: CLOSE ff1_csr;
1182: END IF;
1183:

Line 1208: RAISE OKC_API.G_EXCEPTION_ERROR;

1204: p_msg_name => 'OKL_LLA_SRL_CNTRL',
1205: p_token1 => 'ITEM_DESC',
1206: p_token1_value => l_item_desc
1207: );
1208: RAISE OKC_API.G_EXCEPTION_ERROR;
1209: END IF;
1210: ELSE -- reset serial number
1211: FOR inst_rec IN inst_csr(ff1_rec.asset_id)
1212: LOOP

Line 1221: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1217:
1218: IF (x_no_data_found) THEN
1219:
1220: --dbms_output.put_line('No Data Found');
1221: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1222: END IF;
1223:
1224: l_iivv_rec := l_itiv_rec;
1225: l_iivv_rec.serial_number := NULL; -- reset serial number to NULL

Line 1242: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1238: );
1239: --dbms_output.put_line('After Update call...'||x_return_status);
1240: --dbms_output.put_line('Error: '||x_msg_data);
1241:
1242: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1243: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1244: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1245: RAISE OKC_API.G_EXCEPTION_ERROR;
1246: END IF;

Line 1243: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1239: --dbms_output.put_line('After Update call...'||x_return_status);
1240: --dbms_output.put_line('Error: '||x_msg_data);
1241:
1242: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1243: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1244: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1245: RAISE OKC_API.G_EXCEPTION_ERROR;
1246: END IF;
1247:

Line 1244: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

1240: --dbms_output.put_line('Error: '||x_msg_data);
1241:
1242: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1243: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1244: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1245: RAISE OKC_API.G_EXCEPTION_ERROR;
1246: END IF;
1247:
1248: END LOOP; --inst_csr

Line 1245: RAISE OKC_API.G_EXCEPTION_ERROR;

1241:
1242: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1243: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1244: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1245: RAISE OKC_API.G_EXCEPTION_ERROR;
1246: END IF;
1247:
1248: END LOOP; --inst_csr
1249:

Line 1254: OKC_API.END_ACTIVITY (x_msg_count

1250: END IF; -- l_non_srl
1251:
1252: END LOOP; --ff1_csr
1253:
1254: OKC_API.END_ACTIVITY (x_msg_count
1255: ,x_msg_data );
1256:
1257: EXCEPTION
1258:

Line 1259: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1255: ,x_msg_data );
1256:
1257: EXCEPTION
1258:
1259: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1260: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1261: (l_api_name,
1262: G_PKG_NAME,
1263: 'OKC_API.G_RET_STS_ERROR',

Line 1260: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1256:
1257: EXCEPTION
1258:
1259: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1260: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1261: (l_api_name,
1262: G_PKG_NAME,
1263: 'OKC_API.G_RET_STS_ERROR',
1264: x_msg_count,

Line 1263: 'OKC_API.G_RET_STS_ERROR',

1259: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1260: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1261: (l_api_name,
1262: G_PKG_NAME,
1263: 'OKC_API.G_RET_STS_ERROR',
1264: x_msg_count,
1265: x_msg_data,
1266: '_PVT');
1267: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 1267: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1263: 'OKC_API.G_RET_STS_ERROR',
1264: x_msg_count,
1265: x_msg_data,
1266: '_PVT');
1267: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1268: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1269: (l_api_name,
1270: G_PKG_NAME,
1271: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1268: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1264: x_msg_count,
1265: x_msg_data,
1266: '_PVT');
1267: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1268: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1269: (l_api_name,
1270: G_PKG_NAME,
1271: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1272: x_msg_count,

Line 1271: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1267: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1268: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1269: (l_api_name,
1270: G_PKG_NAME,
1271: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1272: x_msg_count,
1273: x_msg_data,
1274: '_PVT');
1275: WHEN OTHERS THEN x_return_status :=OKC_API.HANDLE_EXCEPTIONS

Line 1275: WHEN OTHERS THEN x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1271: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1272: x_msg_count,
1273: x_msg_data,
1274: '_PVT');
1275: WHEN OTHERS THEN x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1276: (l_api_name,
1277: G_PKG_NAME,
1278: 'OTHERS',
1279: x_msg_count,