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_SEL_PVT dependencies on OKC_API

Line 212: IF (l_selv_rec.object_version_number = Okc_Api.G_MISS_NUM) THEN

208: p_selv_rec IN selv_rec_type
209: ) RETURN selv_rec_type IS
210: l_selv_rec selv_rec_type := p_selv_rec;
211: BEGIN
212: IF (l_selv_rec.object_version_number = Okc_Api.G_MISS_NUM) THEN
213: l_selv_rec.object_version_number := NULL;
214: END IF;
215: IF (l_selv_rec.stm_id = Okc_Api.G_MISS_NUM) THEN
216: l_selv_rec.stm_id := NULL;

Line 215: IF (l_selv_rec.stm_id = Okc_Api.G_MISS_NUM) THEN

211: BEGIN
212: IF (l_selv_rec.object_version_number = Okc_Api.G_MISS_NUM) THEN
213: l_selv_rec.object_version_number := NULL;
214: END IF;
215: IF (l_selv_rec.stm_id = Okc_Api.G_MISS_NUM) THEN
216: l_selv_rec.stm_id := NULL;
217: END IF;
218: IF (l_selv_rec.amount = Okc_Api.G_MISS_NUM) THEN
219: l_selv_rec.amount := NULL;

Line 218: IF (l_selv_rec.amount = Okc_Api.G_MISS_NUM) THEN

214: END IF;
215: IF (l_selv_rec.stm_id = Okc_Api.G_MISS_NUM) THEN
216: l_selv_rec.stm_id := NULL;
217: END IF;
218: IF (l_selv_rec.amount = Okc_Api.G_MISS_NUM) THEN
219: l_selv_rec.amount := NULL;
220: END IF;
221: IF (l_selv_rec.comments = Okc_Api.G_MISS_CHAR) THEN
222: l_selv_rec.comments := NULL;

Line 221: IF (l_selv_rec.comments = Okc_Api.G_MISS_CHAR) THEN

217: END IF;
218: IF (l_selv_rec.amount = Okc_Api.G_MISS_NUM) THEN
219: l_selv_rec.amount := NULL;
220: END IF;
221: IF (l_selv_rec.comments = Okc_Api.G_MISS_CHAR) THEN
222: l_selv_rec.comments := NULL;
223: END IF;
224: IF (l_selv_rec.accrued_yn = Okc_Api.G_MISS_CHAR) THEN
225: l_selv_rec.accrued_yn := NULL;

Line 224: IF (l_selv_rec.accrued_yn = Okc_Api.G_MISS_CHAR) THEN

220: END IF;
221: IF (l_selv_rec.comments = Okc_Api.G_MISS_CHAR) THEN
222: l_selv_rec.comments := NULL;
223: END IF;
224: IF (l_selv_rec.accrued_yn = Okc_Api.G_MISS_CHAR) THEN
225: l_selv_rec.accrued_yn := NULL;
226: END IF;
227: IF (l_selv_rec.stream_element_date = Okc_Api.G_MISS_DATE) THEN
228: l_selv_rec.stream_element_date := NULL;

Line 227: IF (l_selv_rec.stream_element_date = Okc_Api.G_MISS_DATE) THEN

223: END IF;
224: IF (l_selv_rec.accrued_yn = Okc_Api.G_MISS_CHAR) THEN
225: l_selv_rec.accrued_yn := NULL;
226: END IF;
227: IF (l_selv_rec.stream_element_date = Okc_Api.G_MISS_DATE) THEN
228: l_selv_rec.stream_element_date := NULL;
229: END IF;
230:
231:

Line 234: IF (l_selv_rec.program_id = OKC_API.G_MISS_NUM) THEN

230:
231:
232: -- as per the standards - the concurrent program columns should not be nulled out
233: /*
234: IF (l_selv_rec.program_id = OKC_API.G_MISS_NUM) THEN
235: l_selv_rec.program_id := NULL;
236: END IF;
237: IF (l_selv_rec.request_id = OKC_API.G_MISS_NUM) THEN
238: l_selv_rec.request_id := NULL;

Line 237: IF (l_selv_rec.request_id = OKC_API.G_MISS_NUM) THEN

233: /*
234: IF (l_selv_rec.program_id = OKC_API.G_MISS_NUM) THEN
235: l_selv_rec.program_id := NULL;
236: END IF;
237: IF (l_selv_rec.request_id = OKC_API.G_MISS_NUM) THEN
238: l_selv_rec.request_id := NULL;
239: END IF;
240: IF (l_selv_rec.program_application_id = OKC_API.G_MISS_NUM) THEN
241: l_selv_rec.program_application_id := NULL;

Line 240: IF (l_selv_rec.program_application_id = OKC_API.G_MISS_NUM) THEN

236: END IF;
237: IF (l_selv_rec.request_id = OKC_API.G_MISS_NUM) THEN
238: l_selv_rec.request_id := NULL;
239: END IF;
240: IF (l_selv_rec.program_application_id = OKC_API.G_MISS_NUM) THEN
241: l_selv_rec.program_application_id := NULL;
242: END IF;
243: IF (l_selv_rec.program_update_date = OKC_API.G_MISS_DATE) THEN
244: l_selv_rec.program_update_date := NULL;

Line 243: IF (l_selv_rec.program_update_date = OKC_API.G_MISS_DATE) THEN

239: END IF;
240: IF (l_selv_rec.program_application_id = OKC_API.G_MISS_NUM) THEN
241: l_selv_rec.program_application_id := NULL;
242: END IF;
243: IF (l_selv_rec.program_update_date = OKC_API.G_MISS_DATE) THEN
244: l_selv_rec.program_update_date := NULL;
245: END IF;
246:
247: */

Line 248: IF (l_selv_rec.se_line_number = Okc_Api.G_MISS_NUM) THEN

244: l_selv_rec.program_update_date := NULL;
245: END IF;
246:
247: */
248: IF (l_selv_rec.se_line_number = Okc_Api.G_MISS_NUM) THEN
249: l_selv_rec.se_line_number := NULL;
250: END IF;
251:
252: IF (l_selv_rec.date_billed = Okc_Api.G_MISS_DATE) THEN

Line 252: IF (l_selv_rec.date_billed = Okc_Api.G_MISS_DATE) THEN

248: IF (l_selv_rec.se_line_number = Okc_Api.G_MISS_NUM) THEN
249: l_selv_rec.se_line_number := NULL;
250: END IF;
251:
252: IF (l_selv_rec.date_billed = Okc_Api.G_MISS_DATE) THEN
253: l_selv_rec.date_billed := NULL;
254: END IF;
255:
256: IF (l_selv_rec.created_by = Okc_Api.G_MISS_NUM) THEN

Line 256: IF (l_selv_rec.created_by = Okc_Api.G_MISS_NUM) THEN

252: IF (l_selv_rec.date_billed = Okc_Api.G_MISS_DATE) THEN
253: l_selv_rec.date_billed := NULL;
254: END IF;
255:
256: IF (l_selv_rec.created_by = Okc_Api.G_MISS_NUM) THEN
257: l_selv_rec.created_by := NULL;
258: END IF;
259: IF (l_selv_rec.creation_date = Okc_Api.G_MISS_DATE) THEN
260: l_selv_rec.creation_date := NULL;

Line 259: IF (l_selv_rec.creation_date = Okc_Api.G_MISS_DATE) THEN

255:
256: IF (l_selv_rec.created_by = Okc_Api.G_MISS_NUM) THEN
257: l_selv_rec.created_by := NULL;
258: END IF;
259: IF (l_selv_rec.creation_date = Okc_Api.G_MISS_DATE) THEN
260: l_selv_rec.creation_date := NULL;
261: END IF;
262: IF (l_selv_rec.last_updated_by = Okc_Api.G_MISS_NUM) THEN
263: l_selv_rec.last_updated_by := NULL;

Line 262: IF (l_selv_rec.last_updated_by = Okc_Api.G_MISS_NUM) THEN

258: END IF;
259: IF (l_selv_rec.creation_date = Okc_Api.G_MISS_DATE) THEN
260: l_selv_rec.creation_date := NULL;
261: END IF;
262: IF (l_selv_rec.last_updated_by = Okc_Api.G_MISS_NUM) THEN
263: l_selv_rec.last_updated_by := NULL;
264: END IF;
265: IF (l_selv_rec.last_update_date = Okc_Api.G_MISS_DATE) THEN
266: l_selv_rec.last_update_date := NULL;

Line 265: IF (l_selv_rec.last_update_date = Okc_Api.G_MISS_DATE) THEN

261: END IF;
262: IF (l_selv_rec.last_updated_by = Okc_Api.G_MISS_NUM) THEN
263: l_selv_rec.last_updated_by := NULL;
264: END IF;
265: IF (l_selv_rec.last_update_date = Okc_Api.G_MISS_DATE) THEN
266: l_selv_rec.last_update_date := NULL;
267: END IF;
268: IF (l_selv_rec.last_update_login = Okc_Api.G_MISS_NUM) THEN
269: l_selv_rec.last_update_login := NULL;

Line 268: IF (l_selv_rec.last_update_login = Okc_Api.G_MISS_NUM) THEN

264: END IF;
265: IF (l_selv_rec.last_update_date = Okc_Api.G_MISS_DATE) THEN
266: l_selv_rec.last_update_date := NULL;
267: END IF;
268: IF (l_selv_rec.last_update_login = Okc_Api.G_MISS_NUM) THEN
269: l_selv_rec.last_update_login := NULL;
270: END IF;
271: IF (l_selv_rec.sel_id = Okc_Api.G_MISS_NUM) THEN
272: l_selv_rec.sel_id := NULL;

Line 271: IF (l_selv_rec.sel_id = Okc_Api.G_MISS_NUM) THEN

267: END IF;
268: IF (l_selv_rec.last_update_login = Okc_Api.G_MISS_NUM) THEN
269: l_selv_rec.last_update_login := NULL;
270: END IF;
271: IF (l_selv_rec.sel_id = Okc_Api.G_MISS_NUM) THEN
272: l_selv_rec.sel_id := NULL;
273: END IF;
274: -- Added by Keerthi 15-Sep-2003
275: IF (l_selv_rec.source_id = Okc_Api.G_MISS_NUM) THEN

Line 275: IF (l_selv_rec.source_id = Okc_Api.G_MISS_NUM) THEN

271: IF (l_selv_rec.sel_id = Okc_Api.G_MISS_NUM) THEN
272: l_selv_rec.sel_id := NULL;
273: END IF;
274: -- Added by Keerthi 15-Sep-2003
275: IF (l_selv_rec.source_id = Okc_Api.G_MISS_NUM) THEN
276: l_selv_rec.source_id := NULL;
277: END IF;
278: IF (l_selv_rec.source_table = Okc_Api.G_MISS_CHAR) THEN
279: l_selv_rec.source_table := NULL;

Line 278: IF (l_selv_rec.source_table = Okc_Api.G_MISS_CHAR) THEN

274: -- Added by Keerthi 15-Sep-2003
275: IF (l_selv_rec.source_id = Okc_Api.G_MISS_NUM) THEN
276: l_selv_rec.source_id := NULL;
277: END IF;
278: IF (l_selv_rec.source_table = Okc_Api.G_MISS_CHAR) THEN
279: l_selv_rec.source_table := NULL;
280: END IF;
281: -- Added by rgooty: 4212626
282: IF (l_selv_rec.bill_adj_flag = Okc_Api.G_MISS_CHAR) THEN

Line 282: IF (l_selv_rec.bill_adj_flag = Okc_Api.G_MISS_CHAR) THEN

278: IF (l_selv_rec.source_table = Okc_Api.G_MISS_CHAR) THEN
279: l_selv_rec.source_table := NULL;
280: END IF;
281: -- Added by rgooty: 4212626
282: IF (l_selv_rec.bill_adj_flag = Okc_Api.G_MISS_CHAR) THEN
283: l_selv_rec.bill_adj_flag := NULL;
284: END IF;
285: IF (l_selv_rec.accrual_adj_flag = Okc_Api.G_MISS_CHAR) THEN
286: l_selv_rec.accrual_adj_flag := NULL;

Line 285: IF (l_selv_rec.accrual_adj_flag = Okc_Api.G_MISS_CHAR) THEN

281: -- Added by rgooty: 4212626
282: IF (l_selv_rec.bill_adj_flag = Okc_Api.G_MISS_CHAR) THEN
283: l_selv_rec.bill_adj_flag := NULL;
284: END IF;
285: IF (l_selv_rec.accrual_adj_flag = Okc_Api.G_MISS_CHAR) THEN
286: l_selv_rec.accrual_adj_flag := NULL;
287: END IF;
288: -- Added by hkpatel for bug 4350255
289: IF (l_selv_rec.date_disbursed = Okc_Api.G_MISS_DATE) THEN

Line 289: IF (l_selv_rec.date_disbursed = Okc_Api.G_MISS_DATE) THEN

285: IF (l_selv_rec.accrual_adj_flag = Okc_Api.G_MISS_CHAR) THEN
286: l_selv_rec.accrual_adj_flag := NULL;
287: END IF;
288: -- Added by hkpatel for bug 4350255
289: IF (l_selv_rec.date_disbursed = Okc_Api.G_MISS_DATE) THEN
290: l_selv_rec.date_disbursed := NULL;
291: END IF;
292:
293:

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

308: -------------------------------------------------
309: FUNCTION Validate_Attributes (
310: p_selv_rec IN selv_rec_type
311: ) RETURN VARCHAR2 IS
312: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
313: BEGIN
314: IF p_selv_rec.id = OKC_API.G_MISS_NUM OR
315: p_selv_rec.id IS NULL
316: THEN

Line 314: IF p_selv_rec.id = OKC_API.G_MISS_NUM OR

310: p_selv_rec IN selv_rec_type
311: ) RETURN VARCHAR2 IS
312: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
313: BEGIN
314: IF p_selv_rec.id = OKC_API.G_MISS_NUM OR
315: p_selv_rec.id IS NULL
316: THEN
317: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'id');
318: l_return_status := OKC_API.G_RET_STS_ERROR;

Line 317: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'id');

313: BEGIN
314: IF p_selv_rec.id = OKC_API.G_MISS_NUM OR
315: p_selv_rec.id IS NULL
316: THEN
317: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'id');
318: l_return_status := OKC_API.G_RET_STS_ERROR;
319: ELSIF p_selv_rec.object_version_number = OKC_API.G_MISS_NUM OR
320: p_selv_rec.object_version_number IS NULL
321: THEN

Line 318: l_return_status := OKC_API.G_RET_STS_ERROR;

314: IF p_selv_rec.id = OKC_API.G_MISS_NUM OR
315: p_selv_rec.id IS NULL
316: THEN
317: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'id');
318: l_return_status := OKC_API.G_RET_STS_ERROR;
319: ELSIF p_selv_rec.object_version_number = OKC_API.G_MISS_NUM OR
320: p_selv_rec.object_version_number IS NULL
321: THEN
322: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'object_version_number');

Line 319: ELSIF p_selv_rec.object_version_number = OKC_API.G_MISS_NUM OR

315: p_selv_rec.id IS NULL
316: THEN
317: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'id');
318: l_return_status := OKC_API.G_RET_STS_ERROR;
319: ELSIF p_selv_rec.object_version_number = OKC_API.G_MISS_NUM OR
320: p_selv_rec.object_version_number IS NULL
321: THEN
322: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'object_version_number');
323: l_return_status := OKC_API.G_RET_STS_ERROR;

Line 322: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'object_version_number');

318: l_return_status := OKC_API.G_RET_STS_ERROR;
319: ELSIF p_selv_rec.object_version_number = OKC_API.G_MISS_NUM OR
320: p_selv_rec.object_version_number IS NULL
321: THEN
322: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'object_version_number');
323: l_return_status := OKC_API.G_RET_STS_ERROR;
324: ELSIF p_selv_rec.stm_id = OKC_API.G_MISS_NUM OR
325: p_selv_rec.stm_id IS NULL
326: THEN

Line 323: l_return_status := OKC_API.G_RET_STS_ERROR;

319: ELSIF p_selv_rec.object_version_number = OKC_API.G_MISS_NUM OR
320: p_selv_rec.object_version_number IS NULL
321: THEN
322: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'object_version_number');
323: l_return_status := OKC_API.G_RET_STS_ERROR;
324: ELSIF p_selv_rec.stm_id = OKC_API.G_MISS_NUM OR
325: p_selv_rec.stm_id IS NULL
326: THEN
327: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'stm_id');

Line 324: ELSIF p_selv_rec.stm_id = OKC_API.G_MISS_NUM OR

320: p_selv_rec.object_version_number IS NULL
321: THEN
322: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'object_version_number');
323: l_return_status := OKC_API.G_RET_STS_ERROR;
324: ELSIF p_selv_rec.stm_id = OKC_API.G_MISS_NUM OR
325: p_selv_rec.stm_id IS NULL
326: THEN
327: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'stm_id');
328: l_return_status := OKC_API.G_RET_STS_ERROR;

Line 327: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'stm_id');

323: l_return_status := OKC_API.G_RET_STS_ERROR;
324: ELSIF p_selv_rec.stm_id = OKC_API.G_MISS_NUM OR
325: p_selv_rec.stm_id IS NULL
326: THEN
327: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'stm_id');
328: l_return_status := OKC_API.G_RET_STS_ERROR;
329: ELSIF p_selv_rec.amount = OKC_API.G_MISS_NUM OR
330: p_selv_rec.amount IS NULL
331: THEN

Line 328: l_return_status := OKC_API.G_RET_STS_ERROR;

324: ELSIF p_selv_rec.stm_id = OKC_API.G_MISS_NUM OR
325: p_selv_rec.stm_id IS NULL
326: THEN
327: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'stm_id');
328: l_return_status := OKC_API.G_RET_STS_ERROR;
329: ELSIF p_selv_rec.amount = OKC_API.G_MISS_NUM OR
330: p_selv_rec.amount IS NULL
331: THEN
332: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'amount');

Line 329: ELSIF p_selv_rec.amount = OKC_API.G_MISS_NUM OR

325: p_selv_rec.stm_id IS NULL
326: THEN
327: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'stm_id');
328: l_return_status := OKC_API.G_RET_STS_ERROR;
329: ELSIF p_selv_rec.amount = OKC_API.G_MISS_NUM OR
330: p_selv_rec.amount IS NULL
331: THEN
332: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'amount');
333: l_return_status := OKC_API.G_RET_STS_ERROR;

Line 332: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'amount');

328: l_return_status := OKC_API.G_RET_STS_ERROR;
329: ELSIF p_selv_rec.amount = OKC_API.G_MISS_NUM OR
330: p_selv_rec.amount IS NULL
331: THEN
332: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'amount');
333: l_return_status := OKC_API.G_RET_STS_ERROR;
334: END IF;
335: RETURN(l_return_status);
336: END Validate_Attributes;

Line 333: l_return_status := OKC_API.G_RET_STS_ERROR;

329: ELSIF p_selv_rec.amount = OKC_API.G_MISS_NUM OR
330: p_selv_rec.amount IS NULL
331: THEN
332: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'amount');
333: l_return_status := OKC_API.G_RET_STS_ERROR;
334: END IF;
335: RETURN(l_return_status);
336: END Validate_Attributes;
337:

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

344: ---------------------------------------
345: FUNCTION Validate_Record (
346: p_selv_rec IN selv_rec_type
347: ) RETURN VARCHAR2 IS
348: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
349: BEGIN
350: RETURN (l_return_status);
351: END Validate_Record;
352: */

Line 371: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

367: PROCEDURE Validate_Id(p_selv_rec IN selv_rec_type,x_return_status OUT NOCOPY VARCHAR2)
368:
369: IS
370:
371: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
372:
373: BEGIN
374: -- initialize return status
375: x_return_status := Okc_Api.G_RET_STS_SUCCESS;

Line 375: x_return_status := Okc_Api.G_RET_STS_SUCCESS;

371: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
372:
373: BEGIN
374: -- initialize return status
375: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
376: -- check for data before processing
377: IF (p_selv_rec.id IS NULL) THEN
378:
379: Okc_Api.SET_MESSAGE(p_app_name => g_app_name

Line 379: Okc_Api.SET_MESSAGE(p_app_name => g_app_name

375: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
376: -- check for data before processing
377: IF (p_selv_rec.id IS NULL) THEN
378:
379: Okc_Api.SET_MESSAGE(p_app_name => g_app_name
380: ,p_msg_name => g_required_value
381: ,p_token1 => g_col_name_token
382: ,p_token1_value => 'id');
383: x_return_status := Okc_Api.G_RET_STS_ERROR;

Line 383: x_return_status := Okc_Api.G_RET_STS_ERROR;

379: Okc_Api.SET_MESSAGE(p_app_name => g_app_name
380: ,p_msg_name => g_required_value
381: ,p_token1 => g_col_name_token
382: ,p_token1_value => 'id');
383: x_return_status := Okc_Api.G_RET_STS_ERROR;
384: RAISE G_EXCEPTION_HALT_VALIDATION;
385: END IF;
386:
387: EXCEPTION

Line 395: Okc_Api.SET_MESSAGE(p_app_name => g_app_name,

391: NULL;
392:
393: WHEN OTHERS THEN
394: -- store SQL error message on message stack for caller
395: Okc_Api.SET_MESSAGE(p_app_name => g_app_name,
396: p_msg_name => g_unexpected_error,
397: p_token1 => g_sqlcode_token,
398: p_token1_value => SQLCODE,
399: p_token2 => g_sqlerrm_token,

Line 403: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;

399: p_token2 => g_sqlerrm_token,
400: p_token2_value => SQLERRM);
401:
402: -- notify caller of an UNEXPECTED error
403: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;
404:
405: END Validate_Id;
406: /*
407: This validation is not required.

Line 438: x_return_status := Okc_Api.G_RET_STS_SUCCESS;

434:
435: BEGIN
436:
437: -- initialize return status
438: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
439: OPEN okl_sel_uk_csr(p_selv_rec);
440: FETCH okl_sel_uk_csr INTO l_dummy;
441: l_row_found := okl_sel_uk_csr%FOUND;
442: CLOSE okl_sel_uk_csr;

Line 444: Okc_Api.set_message(G_APP_NAME,G_UNQS);

440: FETCH okl_sel_uk_csr INTO l_dummy;
441: l_row_found := okl_sel_uk_csr%FOUND;
442: CLOSE okl_sel_uk_csr;
443: IF l_row_found THEN
444: Okc_Api.set_message(G_APP_NAME,G_UNQS);
445: x_return_status := Okc_Api.G_RET_STS_ERROR;
446: END IF;
447: EXCEPTION
448: WHEN G_EXCEPTION_HALT_VALIDATION THEN

Line 445: x_return_status := Okc_Api.G_RET_STS_ERROR;

441: l_row_found := okl_sel_uk_csr%FOUND;
442: CLOSE okl_sel_uk_csr;
443: IF l_row_found THEN
444: Okc_Api.set_message(G_APP_NAME,G_UNQS);
445: x_return_status := Okc_Api.G_RET_STS_ERROR;
446: END IF;
447: EXCEPTION
448: WHEN G_EXCEPTION_HALT_VALIDATION THEN
449: -- no processing necessary; validation can continue

Line 455: Okc_Api.SET_MESSAGE(p_app_name => g_app_name,

451: NULL;
452:
453: WHEN OTHERS THEN
454: -- store SQL error message on message stack for caller
455: Okc_Api.SET_MESSAGE(p_app_name => g_app_name,
456: p_msg_name => g_unexpected_error,
457: p_token1 => g_sqlcode_token,
458: p_token1_value => SQLCODE,
459: p_token2 => g_sqlerrm_token,

Line 463: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;

459: p_token2 => g_sqlerrm_token,
460: p_token2_value => SQLERRM);
461:
462: -- notify caller of an UNEXPECTED error
463: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;
464: IF okl_sel_uk_csr%ISOPEN
465: THEN
466: CLOSE okl_sel_uk_csr;
467: END IF;

Line 490: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

486: PROCEDURE Validate_Amount(p_selv_rec IN selv_rec_type,x_return_status OUT NOCOPY VARCHAR2)
487:
488: IS
489:
490: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
491:
492: BEGIN
493: -- initialize return status
494: x_return_status := Okc_Api.G_RET_STS_SUCCESS;

Line 494: x_return_status := Okc_Api.G_RET_STS_SUCCESS;

490: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
491:
492: BEGIN
493: -- initialize return status
494: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
495: -- check for data before processing
496: IF (p_selv_rec.amount IS NULL) THEN
497:
498: Okc_Api.SET_MESSAGE(p_app_name => g_app_name

Line 498: Okc_Api.SET_MESSAGE(p_app_name => g_app_name

494: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
495: -- check for data before processing
496: IF (p_selv_rec.amount IS NULL) THEN
497:
498: Okc_Api.SET_MESSAGE(p_app_name => g_app_name
499: ,p_msg_name => g_required_value
500: ,p_token1 => g_col_name_token
501: ,p_token1_value => 'amount');
502: x_return_status := Okc_Api.G_RET_STS_ERROR;

Line 502: x_return_status := Okc_Api.G_RET_STS_ERROR;

498: Okc_Api.SET_MESSAGE(p_app_name => g_app_name
499: ,p_msg_name => g_required_value
500: ,p_token1 => g_col_name_token
501: ,p_token1_value => 'amount');
502: x_return_status := Okc_Api.G_RET_STS_ERROR;
503: RAISE G_EXCEPTION_HALT_VALIDATION;
504: END IF;
505:
506: EXCEPTION

Line 514: Okc_Api.SET_MESSAGE(p_app_name => g_app_name,

510: NULL;
511:
512: WHEN OTHERS THEN
513: -- store SQL error message on message stack for caller
514: Okc_Api.SET_MESSAGE(p_app_name => g_app_name,
515: p_msg_name => g_unexpected_error,
516: p_token1 => g_sqlcode_token,
517: p_token1_value => SQLCODE,
518: p_token2 => g_sqlerrm_token,

Line 522: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;

518: p_token2 => g_sqlerrm_token,
519: p_token2_value => SQLERRM);
520:
521: -- notify caller of an UNEXPECTED error
522: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;
523:
524: END Validate_Amount;
525:
526:

Line 555: x_return_status := Okc_Api.G_RET_STS_SUCCESS;

551:
552: l_row_notfound BOOLEAN :=TRUE;
553: BEGIN
554: -- initialize return status
555: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
556:
557: -- check for data before processing
558: IF (p_selv_rec.stm_id IS NULL) THEN
559: Okc_Api.SET_MESSAGE(p_app_name => g_app_name

Line 559: Okc_Api.SET_MESSAGE(p_app_name => g_app_name

555: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
556:
557: -- check for data before processing
558: IF (p_selv_rec.stm_id IS NULL) THEN
559: Okc_Api.SET_MESSAGE(p_app_name => g_app_name
560: ,p_msg_name => g_required_value
561: ,p_token1 => g_col_name_token
562: ,p_token1_value => 'stm_id');
563: x_return_status := Okc_Api.G_RET_STS_ERROR;

Line 563: x_return_status := Okc_Api.G_RET_STS_ERROR;

559: Okc_Api.SET_MESSAGE(p_app_name => g_app_name
560: ,p_msg_name => g_required_value
561: ,p_token1 => g_col_name_token
562: ,p_token1_value => 'stm_id');
563: x_return_status := Okc_Api.G_RET_STS_ERROR;
564: RAISE G_EXCEPTION_HALT_VALIDATION;
565:
566: ELSIF p_selv_rec.stm_id IS NOT NULL THEN
567: --Check if stm_id exists in the stream level table or not

Line 574: Okc_Api.set_message(g_app_name,g_no_parent_record,g_col_name_token,'stm_id',g_child_table_token,'okl_strm_elements_v',g_parent_table_token,'okl_stream_levels_v');

570: l_row_notfound :=l_stmid_csr%NOTFOUND;
571: CLOSE l_stmid_csr;
572:
573: IF(l_row_notfound ) THEN
574: Okc_Api.set_message(g_app_name,g_no_parent_record,g_col_name_token,'stm_id',g_child_table_token,'okl_strm_elements_v',g_parent_table_token,'okl_stream_levels_v');
575:
576: x_return_status := Okc_Api.G_RET_STS_ERROR;
577: -- raise the exception as there's no matching foreign key value
578:

Line 576: x_return_status := Okc_Api.G_RET_STS_ERROR;

572:
573: IF(l_row_notfound ) THEN
574: Okc_Api.set_message(g_app_name,g_no_parent_record,g_col_name_token,'stm_id',g_child_table_token,'okl_strm_elements_v',g_parent_table_token,'okl_stream_levels_v');
575:
576: x_return_status := Okc_Api.G_RET_STS_ERROR;
577: -- raise the exception as there's no matching foreign key value
578:
579: RAISE G_EXCEPTION_HALT_VALIDATION;
580: END IF;

Line 592: Okc_Api.SET_MESSAGE(p_app_name => g_app_name,

588: NULL;
589:
590: WHEN OTHERS THEN
591: -- store SQL error message on message stack for caller
592: Okc_Api.SET_MESSAGE(p_app_name => g_app_name,
593: p_msg_name => g_unexpected_error,
594: p_token1 => g_sqlcode_token,
595: p_token1_value => SQLCODE,
596: p_token2 => g_sqlerrm_token,

Line 599: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;

595: p_token1_value => SQLCODE,
596: p_token2 => g_sqlerrm_token,
597: p_token2_value => SQLERRM);
598: -- notify caller of an UNEXPECTED error
599: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;
600:
601: IF l_stmid_csr%ISOPEN
602: THEN
603: CLOSE l_stmid_csr;

Line 626: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

622: PROCEDURE Validate_Stream_Element_Date(p_selv_rec IN selv_rec_type,x_return_status OUT NOCOPY VARCHAR2) IS
623:
624:
625:
626: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
627:
628: BEGIN
629: -- initialize return status
630: x_return_status := Okc_Api.G_RET_STS_SUCCESS;

Line 630: x_return_status := Okc_Api.G_RET_STS_SUCCESS;

626: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
627:
628: BEGIN
629: -- initialize return status
630: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
631: -- check for data before processing
632:
633:
634: IF (p_selv_rec.stream_element_date) IS NULL THEN

Line 638: Okc_Api.SET_MESSAGE(p_app_name => g_app_name

634: IF (p_selv_rec.stream_element_date) IS NULL THEN
635:
636:
637:
638: Okc_Api.SET_MESSAGE(p_app_name => g_app_name
639: ,p_msg_name => g_required_value
640: ,p_token1 => g_col_name_token
641: ,p_token1_value => 'stream_element_date');
642:

Line 643: x_return_status := Okc_Api.G_RET_STS_ERROR;

639: ,p_msg_name => g_required_value
640: ,p_token1 => g_col_name_token
641: ,p_token1_value => 'stream_element_date');
642:
643: x_return_status := Okc_Api.G_RET_STS_ERROR;
644: RAISE G_EXCEPTION_HALT_VALIDATION;
645: END IF;
646:
647: EXCEPTION

Line 655: Okc_Api.SET_MESSAGE(p_app_name => g_app_name,

651: NULL;
652:
653: WHEN OTHERS THEN
654: -- store SQL error message on message stack for caller
655: Okc_Api.SET_MESSAGE(p_app_name => g_app_name,
656: p_msg_name => g_unexpected_error,
657: p_token1 => g_sqlcode_token,
658: p_token1_value => SQLCODE,
659: p_token2 => g_sqlerrm_token,

Line 664: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;

660: p_token2_value => SQLERRM);
661:
662:
663: -- notify caller of an UNEXPECTED error
664: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;
665:
666: END Validate_Stream_Element_Date;
667:
668: ---------------------------------------------------------------------------

Line 685: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

681: PROCEDURE Validate_Object_Version_Number(p_selv_rec IN selv_rec_type,x_return_status OUT NOCOPY VARCHAR2)
682:
683: IS
684:
685: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
686:
687: BEGIN
688: -- initialize return status
689: x_return_status := Okc_Api.G_RET_STS_SUCCESS;

Line 689: x_return_status := Okc_Api.G_RET_STS_SUCCESS;

685: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
686:
687: BEGIN
688: -- initialize return status
689: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
690: -- check for data before processing
691: IF (p_selv_rec.object_version_number IS NULL)THEN
692: Okc_Api.SET_MESSAGE(p_app_name => g_app_name
693: ,p_msg_name => g_required_value

Line 692: Okc_Api.SET_MESSAGE(p_app_name => g_app_name

688: -- initialize return status
689: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
690: -- check for data before processing
691: IF (p_selv_rec.object_version_number IS NULL)THEN
692: Okc_Api.SET_MESSAGE(p_app_name => g_app_name
693: ,p_msg_name => g_required_value
694: ,p_token1 => g_col_name_token
695: ,p_token1_value => 'object_version_number');
696: x_return_status := Okc_Api.G_RET_STS_ERROR;

Line 696: x_return_status := Okc_Api.G_RET_STS_ERROR;

692: Okc_Api.SET_MESSAGE(p_app_name => g_app_name
693: ,p_msg_name => g_required_value
694: ,p_token1 => g_col_name_token
695: ,p_token1_value => 'object_version_number');
696: x_return_status := Okc_Api.G_RET_STS_ERROR;
697: RAISE G_EXCEPTION_HALT_VALIDATION;
698: END IF;
699:
700: EXCEPTION

Line 708: Okc_Api.SET_MESSAGE(p_app_name => g_app_name,

704: NULL;
705:
706: WHEN OTHERS THEN
707: -- store SQL error message on message stack for caller
708: Okc_Api.SET_MESSAGE(p_app_name => g_app_name,
709: p_msg_name => g_unexpected_error,
710: p_token1 => g_sqlcode_token,
711: p_token1_value => SQLCODE,
712: p_token2 => g_sqlerrm_token,

Line 716: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;

712: p_token2 => g_sqlerrm_token,
713: p_token2_value => SQLERRM);
714:
715: -- notify caller of an UNEXPECTED error
716: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;
717:
718: END Validate_Object_Version_Number;
719:
720: --------------------------------------------------------------------------

Line 735: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

731: ---------------------------------------------------------------------------
732:
733: PROCEDURE Validate_Se_Line_Number(p_selv_rec IN selv_rec_type,x_return_status OUT NOCOPY VARCHAR2)
734: IS
735: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
736: BEGIN
737: -- initialize return status
738: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
739: -- check for data before processing

Line 738: x_return_status := Okc_Api.G_RET_STS_SUCCESS;

734: IS
735: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
736: BEGIN
737: -- initialize return status
738: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
739: -- check for data before processing
740: IF (p_selv_rec.se_line_number IS NULL) THEN
741:
742: Okc_Api.SET_MESSAGE(p_app_name => g_app_name

Line 742: Okc_Api.SET_MESSAGE(p_app_name => g_app_name

738: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
739: -- check for data before processing
740: IF (p_selv_rec.se_line_number IS NULL) THEN
741:
742: Okc_Api.SET_MESSAGE(p_app_name => g_app_name
743: ,p_msg_name => g_required_value
744: ,p_token1 => g_col_name_token
745: ,p_token1_value => 'se_line_number');
746: x_return_status := Okc_Api.G_RET_STS_ERROR;

Line 746: x_return_status := Okc_Api.G_RET_STS_ERROR;

742: Okc_Api.SET_MESSAGE(p_app_name => g_app_name
743: ,p_msg_name => g_required_value
744: ,p_token1 => g_col_name_token
745: ,p_token1_value => 'se_line_number');
746: x_return_status := Okc_Api.G_RET_STS_ERROR;
747: RAISE G_EXCEPTION_HALT_VALIDATION;
748: END IF;
749:
750: EXCEPTION

Line 758: Okc_Api.SET_MESSAGE(p_app_name => g_app_name,

754: NULL;
755:
756: WHEN OTHERS THEN
757: -- store SQL error message on message stack for caller
758: Okc_Api.SET_MESSAGE(p_app_name => g_app_name,
759: p_msg_name => g_unexpected_error,
760: p_token1 => g_sqlcode_token,
761: p_token1_value => SQLCODE,
762: p_token2 => g_sqlerrm_token,

Line 766: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;

762: p_token2 => g_sqlerrm_token,
763: p_token2_value => SQLERRM);
764:
765: -- notify caller of an UNEXPECTED error
766: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;
767:
768: END Validate_Se_Line_Number;
769:
770:

Line 789: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

785: x_return_status OUT NOCOPY VARCHAR2)
786:
787: IS
788:
789: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
790:
791: CURSOR sel_csr (p_sel_id NUMBER)
792: IS
793: SELECT ID

Line 801: x_return_status := Okc_Api.G_RET_STS_SUCCESS;

797: l_sel_id NUMBER := NULL;
798:
799: BEGIN
800:
801: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
802:
803: IF (p_selv_rec.sel_id IS NOT NULL) THEN
804:
805: OPEN sel_csr(p_selv_rec.sel_id);

Line 811: Okc_Api.SET_MESSAGE(p_app_name => G_APP_NAME

807: CLOSE sel_csr;
808:
809: IF (l_sel_id IS NULL) THEN
810:
811: Okc_Api.SET_MESSAGE(p_app_name => G_APP_NAME
812: ,p_msg_name => g_invalid_value
813: ,p_token1 => g_col_name_token
814: ,p_token1_value => 'sel_id');
815: x_return_status := Okc_Api.G_RET_STS_ERROR;

Line 815: x_return_status := Okc_Api.G_RET_STS_ERROR;

811: Okc_Api.SET_MESSAGE(p_app_name => G_APP_NAME
812: ,p_msg_name => g_invalid_value
813: ,p_token1 => g_col_name_token
814: ,p_token1_value => 'sel_id');
815: x_return_status := Okc_Api.G_RET_STS_ERROR;
816: RAISE G_EXCEPTION_HALT_VALIDATION;
817: END IF;
818:
819: END IF;

Line 829: Okc_Api.SET_MESSAGE(p_app_name => g_app_name,

825: NULL;
826:
827: WHEN OTHERS THEN
828: -- store SQL error message on message stack for caller
829: Okc_Api.SET_MESSAGE(p_app_name => g_app_name,
830: p_msg_name => g_unexpected_error,
831: p_token1 => g_sqlcode_token,
832: p_token1_value => SQLCODE,
833: p_token2 => g_sqlerrm_token,

Line 836: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;

832: p_token1_value => SQLCODE,
833: p_token2 => g_sqlerrm_token,
834: p_token2_value => SQLERRM);
835:
836: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;
837:
838: END Validate_sel_Id;
839:
840:

Line 858: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

854: PROCEDURE Validate_Source_Id_Table(p_selv_rec IN selv_rec_type,x_return_status OUT NOCOPY VARCHAR2)
855:
856: IS
857:
858: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
859: l_dummy VARCHAR2(1) := OKC_API.G_FALSE;
860:
861: BEGIN
862: -- initialize return status

Line 859: l_dummy VARCHAR2(1) := OKC_API.G_FALSE;

855:
856: IS
857:
858: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
859: l_dummy VARCHAR2(1) := OKC_API.G_FALSE;
860:
861: BEGIN
862: -- initialize return status
863: x_return_status := Okc_Api.G_RET_STS_SUCCESS;

Line 863: x_return_status := Okc_Api.G_RET_STS_SUCCESS;

859: l_dummy VARCHAR2(1) := OKC_API.G_FALSE;
860:
861: BEGIN
862: -- initialize return status
863: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
864: -- check for data before processing
865:
866:
867: IF (p_selv_rec.source_id IS NOT NULL) THEN

Line 870: Okc_Api.SET_MESSAGE(p_app_name => g_app_name

866:
867: IF (p_selv_rec.source_id IS NOT NULL) THEN
868:
869: IF (p_selv_rec.source_table IS NULL) THEN
870: Okc_Api.SET_MESSAGE(p_app_name => g_app_name
871: ,p_msg_name => g_invalid_value
872: ,p_token1 => g_col_name_token
873: ,p_token1_value => 'SOURCE_TABLE');
874: x_return_status := Okc_Api.G_RET_STS_ERROR;

Line 874: x_return_status := Okc_Api.G_RET_STS_ERROR;

870: Okc_Api.SET_MESSAGE(p_app_name => g_app_name
871: ,p_msg_name => g_invalid_value
872: ,p_token1 => g_col_name_token
873: ,p_token1_value => 'SOURCE_TABLE');
874: x_return_status := Okc_Api.G_RET_STS_ERROR;
875: RAISE G_EXCEPTION_HALT_VALIDATION;
876: ELSE
877: l_dummy := OKL_ACCOUNTING_UTIL.VALIDATE_LOOKUP_CODE(p_lookup_type => 'OKL_SEL_SOURCE',
878: p_lookup_code => p_selv_rec.source_table);

Line 880: IF (l_dummy = Okc_Api.G_FALSE) THEN

876: ELSE
877: l_dummy := OKL_ACCOUNTING_UTIL.VALIDATE_LOOKUP_CODE(p_lookup_type => 'OKL_SEL_SOURCE',
878: p_lookup_code => p_selv_rec.source_table);
879:
880: IF (l_dummy = Okc_Api.G_FALSE) THEN
881: Okc_Api.SET_MESSAGE(p_app_name => g_app_name
882: ,p_msg_name => g_invalid_value
883: ,p_token1 => g_col_name_token
884: ,p_token1_value => 'SOURCE_TABLE');

Line 881: Okc_Api.SET_MESSAGE(p_app_name => g_app_name

877: l_dummy := OKL_ACCOUNTING_UTIL.VALIDATE_LOOKUP_CODE(p_lookup_type => 'OKL_SEL_SOURCE',
878: p_lookup_code => p_selv_rec.source_table);
879:
880: IF (l_dummy = Okc_Api.G_FALSE) THEN
881: Okc_Api.SET_MESSAGE(p_app_name => g_app_name
882: ,p_msg_name => g_invalid_value
883: ,p_token1 => g_col_name_token
884: ,p_token1_value => 'SOURCE_TABLE');
885: x_return_status := Okc_Api.G_RET_STS_ERROR;

Line 885: x_return_status := Okc_Api.G_RET_STS_ERROR;

881: Okc_Api.SET_MESSAGE(p_app_name => g_app_name
882: ,p_msg_name => g_invalid_value
883: ,p_token1 => g_col_name_token
884: ,p_token1_value => 'SOURCE_TABLE');
885: x_return_status := Okc_Api.G_RET_STS_ERROR;
886: RAISE G_EXCEPTION_HALT_VALIDATION;
887: END IF;
888:
889: END IF;

Line 903: Okc_Api.SET_MESSAGE(p_app_name => g_app_name,

899: NULL;
900:
901: WHEN OTHERS THEN
902: -- store SQL error message on message stack for caller
903: Okc_Api.SET_MESSAGE(p_app_name => g_app_name,
904: p_msg_name => g_unexpected_error,
905: p_token1 => g_sqlcode_token,
906: p_token1_value => SQLCODE,
907: p_token2 => g_sqlerrm_token,

Line 911: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;

907: p_token2 => g_sqlerrm_token,
908: p_token2_value => SQLERRM);
909:
910: -- notify caller of an UNEXPECTED error
911: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;
912:
913: END Validate_Source_Id_Table;
914:
915:

Line 935: x_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

931: FUNCTION Validate_Attributes (
932: p_selv_rec IN selv_rec_type
933: ) RETURN VARCHAR2 IS
934:
935: x_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
936: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
937: BEGIN
938:
939: -- call each column-level validation

Line 936: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

932: p_selv_rec IN selv_rec_type
933: ) RETURN VARCHAR2 IS
934:
935: x_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
936: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
937: BEGIN
938:
939: -- call each column-level validation
940:

Line 945: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN

941:
942: -- Validate_Id
943: Validate_Id(p_selv_rec, x_return_status);
944: -- store the highest degree of error
945: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
946: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
947: -- need to leave
948: l_return_status := x_return_status;
949: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 946: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

942: -- Validate_Id
943: Validate_Id(p_selv_rec, x_return_status);
944: -- store the highest degree of error
945: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
946: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
947: -- need to leave
948: l_return_status := x_return_status;
949: RAISE G_EXCEPTION_HALT_VALIDATION;
950: ELSE

Line 959: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN

955:
956: -- Validate_Object_Version_Number
957: Validate_Object_Version_Number(p_selv_rec, x_return_status);
958: -- store the highest degree of error
959: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
960: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
961: -- need to leave
962: l_return_status := x_return_status;
963: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 960: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

956: -- Validate_Object_Version_Number
957: Validate_Object_Version_Number(p_selv_rec, x_return_status);
958: -- store the highest degree of error
959: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
960: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
961: -- need to leave
962: l_return_status := x_return_status;
963: RAISE G_EXCEPTION_HALT_VALIDATION;
964: ELSE

Line 973: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN

969:
970: -- Validate_Amount
971: Validate_Amount(p_selv_rec, x_return_status);
972: -- store the highest degree of error
973: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
974: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
975: -- need to leave
976: l_return_status := x_return_status;
977: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 974: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

970: -- Validate_Amount
971: Validate_Amount(p_selv_rec, x_return_status);
972: -- store the highest degree of error
973: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
974: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
975: -- need to leave
976: l_return_status := x_return_status;
977: RAISE G_EXCEPTION_HALT_VALIDATION;
978: ELSE

Line 989: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN

985: -- Validate_Stm_Id
986: Validate_Stm_Id(p_selv_rec, x_return_status);
987:
988: -- store the highest degree of error
989: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
990: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
991: -- need to leave
992: l_return_status := x_return_status;
993: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 990: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

986: Validate_Stm_Id(p_selv_rec, x_return_status);
987:
988: -- store the highest degree of error
989: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
990: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
991: -- need to leave
992: l_return_status := x_return_status;
993: RAISE G_EXCEPTION_HALT_VALIDATION;
994: ELSE

Line 1003: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN

999:
1000: -- Validate_Stream_Element_Date
1001: Validate_Stream_Element_Date(p_selv_rec, x_return_status);
1002: -- store the highest degree of error
1003: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
1004: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1005: -- need to leave
1006: l_return_status := x_return_status;
1007: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 1004: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

1000: -- Validate_Stream_Element_Date
1001: Validate_Stream_Element_Date(p_selv_rec, x_return_status);
1002: -- store the highest degree of error
1003: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
1004: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1005: -- need to leave
1006: l_return_status := x_return_status;
1007: RAISE G_EXCEPTION_HALT_VALIDATION;
1008: ELSE

Line 1017: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN

1013:
1014: -- Validate_Se_Line_Number
1015: Validate_Se_Line_Number(p_selv_rec, x_return_status);
1016: -- store the highest degree of error
1017: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
1018: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1019: -- need to leave
1020: l_return_status := x_return_status;
1021: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 1018: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

1014: -- Validate_Se_Line_Number
1015: Validate_Se_Line_Number(p_selv_rec, x_return_status);
1016: -- store the highest degree of error
1017: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
1018: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1019: -- need to leave
1020: l_return_status := x_return_status;
1021: RAISE G_EXCEPTION_HALT_VALIDATION;
1022: ELSE

Line 1031: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN

1027:
1028: -- Validate_sel_id
1029: Validate_Sel_ID(p_selv_rec, x_return_status);
1030: -- store the highest degree of error
1031: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
1032: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1033: -- need to leave
1034: l_return_status := x_return_status;
1035: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 1032: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

1028: -- Validate_sel_id
1029: Validate_Sel_ID(p_selv_rec, x_return_status);
1030: -- store the highest degree of error
1031: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
1032: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1033: -- need to leave
1034: l_return_status := x_return_status;
1035: RAISE G_EXCEPTION_HALT_VALIDATION;
1036: ELSE

Line 1045: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN

1041:
1042: -- Validate source_id and Source_table (Added by Keerthi 15-Sep-2003)
1043: Validate_Source_Id_Table(p_selv_rec, x_return_status);
1044: -- store the highest degree of error
1045: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
1046: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1047: -- need to leave
1048: l_return_status := x_return_status;
1049: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 1046: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

1042: -- Validate source_id and Source_table (Added by Keerthi 15-Sep-2003)
1043: Validate_Source_Id_Table(p_selv_rec, x_return_status);
1044: -- store the highest degree of error
1045: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
1046: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1047: -- need to leave
1048: l_return_status := x_return_status;
1049: RAISE G_EXCEPTION_HALT_VALIDATION;
1050: ELSE

Line 1067: Okc_Api.SET_MESSAGE(p_app_name => g_app_name,

1063: RETURN (l_return_status);
1064:
1065: WHEN OTHERS THEN
1066: -- store SQL error message on message stack for caller
1067: Okc_Api.SET_MESSAGE(p_app_name => g_app_name,
1068: p_msg_name => g_unexpected_error,
1069: p_token1 => g_sqlcode_token,
1070: p_token1_value => SQLCODE,
1071: p_token2 => g_sqlerrm_token,

Line 1074: l_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;

1070: p_token1_value => SQLCODE,
1071: p_token2 => g_sqlerrm_token,
1072: p_token2_value => SQLERRM);
1073: -- notify caller of an UNEXPECTED error
1074: l_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;
1075: RETURN(l_return_status);
1076:
1077: END Validate_Attributes;
1078:

Line 1111: x_return_status := Okc_Api.G_RET_STS_SUCCESS;

1107: AND id <> NVL(p_rec.id,-9999);
1108:
1109: BEGIN
1110: -- initialize return status
1111: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
1112: OPEN okl_sel_uk_csr(p_selv_rec);
1113: FETCH okl_sel_uk_csr INTO l_dummy;
1114: l_row_found := okl_sel_uk_csr%FOUND;
1115: CLOSE okl_sel_uk_csr;

Line 1117: Okc_Api.set_message(G_APP_NAME,G_UNQS);

1113: FETCH okl_sel_uk_csr INTO l_dummy;
1114: l_row_found := okl_sel_uk_csr%FOUND;
1115: CLOSE okl_sel_uk_csr;
1116: IF l_row_found THEN
1117: Okc_Api.set_message(G_APP_NAME,G_UNQS);
1118: x_return_status := Okc_Api.G_RET_STS_ERROR;
1119: END IF;
1120:
1121: EXCEPTION

Line 1118: x_return_status := Okc_Api.G_RET_STS_ERROR;

1114: l_row_found := okl_sel_uk_csr%FOUND;
1115: CLOSE okl_sel_uk_csr;
1116: IF l_row_found THEN
1117: Okc_Api.set_message(G_APP_NAME,G_UNQS);
1118: x_return_status := Okc_Api.G_RET_STS_ERROR;
1119: END IF;
1120:
1121: EXCEPTION
1122: WHEN G_EXCEPTION_HALT_VALIDATION THEN

Line 1129: Okc_Api.SET_MESSAGE(p_app_name => g_app_name,

1125: NULL;
1126:
1127: WHEN OTHERS THEN
1128: -- store SQL error message on message stack for caller
1129: Okc_Api.SET_MESSAGE(p_app_name => g_app_name,
1130: p_msg_name => g_unexpected_error,
1131: p_token1 => g_sqlcode_token,
1132: p_token1_value => SQLCODE,
1133: p_token2 => g_sqlerrm_token,

Line 1137: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;

1133: p_token2 => g_sqlerrm_token,
1134: p_token2_value => SQLERRM);
1135:
1136: -- notify caller of an UNEXPECTED error
1137: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;
1138:
1139: END Validate_Unique_Sel_Record;
1140:
1141: ---------------------------------------------------------------------------

Line 1157: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

1153:
1154: FUNCTION Validate_Record (
1155: p_selv_rec IN selv_rec_type
1156: ) RETURN VARCHAR2 IS
1157: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1158: x_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1159: BEGIN
1160: -- Validate_Unique_sel_Record
1161: Validate_Unique_Sel_Record(p_selv_rec, x_return_status);

Line 1158: x_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

1154: FUNCTION Validate_Record (
1155: p_selv_rec IN selv_rec_type
1156: ) RETURN VARCHAR2 IS
1157: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1158: x_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1159: BEGIN
1160: -- Validate_Unique_sel_Record
1161: Validate_Unique_Sel_Record(p_selv_rec, x_return_status);
1162: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN

Line 1162: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN

1158: x_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1159: BEGIN
1160: -- Validate_Unique_sel_Record
1161: Validate_Unique_Sel_Record(p_selv_rec, x_return_status);
1162: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
1163: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1164: -- need to leave
1165: l_return_status := x_return_status;
1166: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 1163: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

1159: BEGIN
1160: -- Validate_Unique_sel_Record
1161: Validate_Unique_Sel_Record(p_selv_rec, x_return_status);
1162: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
1163: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1164: -- need to leave
1165: l_return_status := x_return_status;
1166: RAISE G_EXCEPTION_HALT_VALIDATION;
1167: ELSE

Line 1182: Okc_Api.SET_MESSAGE(p_app_name => g_app_name,

1178: RETURN (l_return_status);
1179:
1180: WHEN OTHERS THEN
1181: -- store SQL error message on message stack for caller
1182: Okc_Api.SET_MESSAGE(p_app_name => g_app_name,
1183: p_msg_name => g_unexpected_error,
1184: p_token1 => g_sqlcode_token,
1185: p_token1_value => SQLCODE,
1186: p_token2 => g_sqlerrm_token,

Line 1189: l_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;

1185: p_token1_value => SQLCODE,
1186: p_token2 => g_sqlerrm_token,
1187: p_token2_value => SQLERRM);
1188: -- notify caller of an UNEXPECTED error
1189: l_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;
1190: RETURN(l_return_status);
1191: END Validate_Record;
1192: -- END change : mvasudev
1193:

Line 1273: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,

1269: -- validate_row for:OKL_STRM_ELEMENTS_V --
1270: ------------------------------------------
1271: PROCEDURE validate_row(
1272: p_api_version IN NUMBER,
1273: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
1274: x_return_status OUT NOCOPY VARCHAR2,
1275: x_msg_count OUT NOCOPY NUMBER,
1276: x_msg_data OUT NOCOPY VARCHAR2,
1277: p_selv_rec IN selv_rec_type) IS

Line 1281: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

1277: p_selv_rec IN selv_rec_type) IS
1278:
1279: l_api_version CONSTANT NUMBER := 1;
1280: l_api_name CONSTANT VARCHAR2(30) := 'V_validate_row';
1281: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1282: l_selv_rec selv_rec_type := p_selv_rec;
1283: l_sel_rec sel_rec_type;
1284: BEGIN
1285: l_return_status := Okc_Api.START_ACTIVITY(l_api_name,

Line 1285: l_return_status := Okc_Api.START_ACTIVITY(l_api_name,

1281: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1282: l_selv_rec selv_rec_type := p_selv_rec;
1283: l_sel_rec sel_rec_type;
1284: BEGIN
1285: l_return_status := Okc_Api.START_ACTIVITY(l_api_name,
1286: G_PKG_NAME,
1287: p_init_msg_list,
1288: l_api_version,
1289: p_api_version,

Line 1292: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

1288: l_api_version,
1289: p_api_version,
1290: '_PVT',
1291: x_return_status);
1292: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1293: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1294: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1295: RAISE Okc_Api.G_EXCEPTION_ERROR;
1296: END IF;

Line 1293: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1289: p_api_version,
1290: '_PVT',
1291: x_return_status);
1292: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1293: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1294: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1295: RAISE Okc_Api.G_EXCEPTION_ERROR;
1296: END IF;
1297: --- Validate all non-missing attributes (Item Level Validation)

Line 1294: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN

1290: '_PVT',
1291: x_return_status);
1292: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1293: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1294: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1295: RAISE Okc_Api.G_EXCEPTION_ERROR;
1296: END IF;
1297: --- Validate all non-missing attributes (Item Level Validation)
1298: l_return_status := Validate_Attributes(l_selv_rec);

Line 1295: RAISE Okc_Api.G_EXCEPTION_ERROR;

1291: x_return_status);
1292: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1293: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1294: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1295: RAISE Okc_Api.G_EXCEPTION_ERROR;
1296: END IF;
1297: --- Validate all non-missing attributes (Item Level Validation)
1298: l_return_status := Validate_Attributes(l_selv_rec);
1299: --- If any errors happen abort API

Line 1300: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

1296: END IF;
1297: --- Validate all non-missing attributes (Item Level Validation)
1298: l_return_status := Validate_Attributes(l_selv_rec);
1299: --- If any errors happen abort API
1300: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1301: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1302: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1303: RAISE Okc_Api.G_EXCEPTION_ERROR;
1304: END IF;

Line 1301: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1297: --- Validate all non-missing attributes (Item Level Validation)
1298: l_return_status := Validate_Attributes(l_selv_rec);
1299: --- If any errors happen abort API
1300: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1301: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1302: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1303: RAISE Okc_Api.G_EXCEPTION_ERROR;
1304: END IF;
1305: l_return_status := Validate_Record(l_selv_rec);

Line 1302: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN

1298: l_return_status := Validate_Attributes(l_selv_rec);
1299: --- If any errors happen abort API
1300: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1301: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1302: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1303: RAISE Okc_Api.G_EXCEPTION_ERROR;
1304: END IF;
1305: l_return_status := Validate_Record(l_selv_rec);
1306: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

Line 1303: RAISE Okc_Api.G_EXCEPTION_ERROR;

1299: --- If any errors happen abort API
1300: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1301: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1302: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1303: RAISE Okc_Api.G_EXCEPTION_ERROR;
1304: END IF;
1305: l_return_status := Validate_Record(l_selv_rec);
1306: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1307: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

Line 1306: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

1302: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1303: RAISE Okc_Api.G_EXCEPTION_ERROR;
1304: END IF;
1305: l_return_status := Validate_Record(l_selv_rec);
1306: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1307: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1308: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1309: RAISE Okc_Api.G_EXCEPTION_ERROR;
1310: END IF;

Line 1307: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1303: RAISE Okc_Api.G_EXCEPTION_ERROR;
1304: END IF;
1305: l_return_status := Validate_Record(l_selv_rec);
1306: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1307: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1308: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1309: RAISE Okc_Api.G_EXCEPTION_ERROR;
1310: END IF;
1311: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);

Line 1308: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN

1304: END IF;
1305: l_return_status := Validate_Record(l_selv_rec);
1306: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1307: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1308: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1309: RAISE Okc_Api.G_EXCEPTION_ERROR;
1310: END IF;
1311: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1312: EXCEPTION

Line 1309: RAISE Okc_Api.G_EXCEPTION_ERROR;

1305: l_return_status := Validate_Record(l_selv_rec);
1306: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1307: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1308: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1309: RAISE Okc_Api.G_EXCEPTION_ERROR;
1310: END IF;
1311: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1312: EXCEPTION
1313: WHEN Okc_Api.G_EXCEPTION_ERROR THEN

Line 1311: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);

1307: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1308: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1309: RAISE Okc_Api.G_EXCEPTION_ERROR;
1310: END IF;
1311: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1312: EXCEPTION
1313: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
1314: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
1315: (

Line 1313: WHEN Okc_Api.G_EXCEPTION_ERROR THEN

1309: RAISE Okc_Api.G_EXCEPTION_ERROR;
1310: END IF;
1311: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1312: EXCEPTION
1313: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
1314: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
1315: (
1316: l_api_name,
1317: G_PKG_NAME,

Line 1314: x_return_status := Okc_Api.HANDLE_EXCEPTIONS

1310: END IF;
1311: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1312: EXCEPTION
1313: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
1314: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
1315: (
1316: l_api_name,
1317: G_PKG_NAME,
1318: 'OKC_API.G_RET_STS_ERROR',

Line 1318: 'OKC_API.G_RET_STS_ERROR',

1314: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
1315: (
1316: l_api_name,
1317: G_PKG_NAME,
1318: 'OKC_API.G_RET_STS_ERROR',
1319: x_msg_count,
1320: x_msg_data,
1321: '_PVT'
1322: );

Line 1323: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

1319: x_msg_count,
1320: x_msg_data,
1321: '_PVT'
1322: );
1323: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1324: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
1325: (
1326: l_api_name,
1327: G_PKG_NAME,

Line 1324: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS

1320: x_msg_data,
1321: '_PVT'
1322: );
1323: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1324: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
1325: (
1326: l_api_name,
1327: G_PKG_NAME,
1328: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1328: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1324: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
1325: (
1326: l_api_name,
1327: G_PKG_NAME,
1328: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1329: x_msg_count,
1330: x_msg_data,
1331: '_PVT'
1332: );

Line 1334: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS

1330: x_msg_data,
1331: '_PVT'
1332: );
1333: WHEN OTHERS THEN
1334: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
1335: (
1336: l_api_name,
1337: G_PKG_NAME,
1338: 'OTHERS',

Line 1349: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,

1345: -- PL/SQL TBL validate_row for:SELV_TBL --
1346: ------------------------------------------
1347: PROCEDURE validate_row(
1348: p_api_version IN NUMBER,
1349: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
1350: x_return_status OUT NOCOPY VARCHAR2,
1351: x_msg_count OUT NOCOPY NUMBER,
1352: x_msg_data OUT NOCOPY VARCHAR2,
1353: p_selv_tbl IN selv_tbl_type) IS

Line 1357: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

1353: p_selv_tbl IN selv_tbl_type) IS
1354:
1355: l_api_version CONSTANT NUMBER := 1;
1356: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_validate_row';
1357: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1358: i NUMBER := 0;
1359: -- START change : akjain, 05/15/2001
1360: -- Adding OverAll Status Flag
1361: l_overall_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

Line 1361: l_overall_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

1357: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1358: i NUMBER := 0;
1359: -- START change : akjain, 05/15/2001
1360: -- Adding OverAll Status Flag
1361: l_overall_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1362: -- END change : akjain
1363:
1364: BEGIN
1365: Okc_Api.init_msg_list(p_init_msg_list);

Line 1365: Okc_Api.init_msg_list(p_init_msg_list);

1361: l_overall_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1362: -- END change : akjain
1363:
1364: BEGIN
1365: Okc_Api.init_msg_list(p_init_msg_list);
1366: -- Make sure PL/SQL table has records in it before passing
1367: IF (p_selv_tbl.COUNT > 0) THEN
1368: i := p_selv_tbl.FIRST;
1369: LOOP

Line 1372: p_init_msg_list => Okc_Api.G_FALSE,

1368: i := p_selv_tbl.FIRST;
1369: LOOP
1370: validate_row (
1371: p_api_version => p_api_version,
1372: p_init_msg_list => Okc_Api.G_FALSE,
1373: x_return_status => x_return_status,
1374: x_msg_count => x_msg_count,
1375: x_msg_data => x_msg_data,
1376: p_selv_rec => p_selv_tbl(i));

Line 1379: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS THEN

1375: x_msg_data => x_msg_data,
1376: p_selv_rec => p_selv_tbl(i));
1377: -- START change : akjain, 05/15/2001
1378: -- store the highest degree of error
1379: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS THEN
1380: IF l_overall_status <> Okc_Api.G_RET_STS_UNEXP_ERROR THEN
1381: l_overall_status := x_return_status;
1382: END IF;
1383: END IF;

Line 1380: IF l_overall_status <> Okc_Api.G_RET_STS_UNEXP_ERROR THEN

1376: p_selv_rec => p_selv_tbl(i));
1377: -- START change : akjain, 05/15/2001
1378: -- store the highest degree of error
1379: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS THEN
1380: IF l_overall_status <> Okc_Api.G_RET_STS_UNEXP_ERROR THEN
1381: l_overall_status := x_return_status;
1382: END IF;
1383: END IF;
1384: -- END change : akjain

Line 1396: WHEN Okc_Api.G_EXCEPTION_ERROR THEN

1392: -- END change : akjain
1393:
1394: END IF;
1395: EXCEPTION
1396: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
1397: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
1398: (
1399: l_api_name,
1400: G_PKG_NAME,

Line 1397: x_return_status := Okc_Api.HANDLE_EXCEPTIONS

1393:
1394: END IF;
1395: EXCEPTION
1396: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
1397: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
1398: (
1399: l_api_name,
1400: G_PKG_NAME,
1401: 'OKC_API.G_RET_STS_ERROR',

Line 1401: 'OKC_API.G_RET_STS_ERROR',

1397: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
1398: (
1399: l_api_name,
1400: G_PKG_NAME,
1401: 'OKC_API.G_RET_STS_ERROR',
1402: x_msg_count,
1403: x_msg_data,
1404: '_PVT'
1405: );

Line 1406: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

1402: x_msg_count,
1403: x_msg_data,
1404: '_PVT'
1405: );
1406: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1407: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
1408: (
1409: l_api_name,
1410: G_PKG_NAME,

Line 1407: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS

1403: x_msg_data,
1404: '_PVT'
1405: );
1406: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1407: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
1408: (
1409: l_api_name,
1410: G_PKG_NAME,
1411: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1411: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1407: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
1408: (
1409: l_api_name,
1410: G_PKG_NAME,
1411: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1412: x_msg_count,
1413: x_msg_data,
1414: '_PVT'
1415: );

Line 1417: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS

1413: x_msg_data,
1414: '_PVT'
1415: );
1416: WHEN OTHERS THEN
1417: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
1418: (
1419: l_api_name,
1420: G_PKG_NAME,
1421: 'OTHERS',

Line 1435: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,

1431: --------------------------------------
1432: -- insert_row for:OKL_STRM_ELEMENTS --
1433: --------------------------------------
1434: PROCEDURE insert_row(
1435: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
1436: x_return_status OUT NOCOPY VARCHAR2,
1437: x_msg_count OUT NOCOPY NUMBER,
1438: x_msg_data OUT NOCOPY VARCHAR2,
1439: p_sel_rec IN sel_rec_type,

Line 1444: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

1440: x_sel_rec OUT NOCOPY sel_rec_type) IS
1441:
1442: l_api_version CONSTANT NUMBER := 1;
1443: l_api_name CONSTANT VARCHAR2(30) := 'ELEMENTS_insert_row';
1444: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1445: l_sel_rec sel_rec_type := p_sel_rec;
1446: l_def_sel_rec sel_rec_type;
1447: ------------------------------------------
1448: -- Set_Attributes for:OKL_STRM_ELEMENTS --

Line 1454: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

1450: FUNCTION Set_Attributes (
1451: p_sel_rec IN sel_rec_type,
1452: x_sel_rec OUT NOCOPY sel_rec_type
1453: ) RETURN VARCHAR2 IS
1454: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1455: BEGIN
1456: x_sel_rec := p_sel_rec;
1457: RETURN(l_return_status);
1458: END Set_Attributes;

Line 1460: l_return_status := Okc_Api.START_ACTIVITY(l_api_name,

1456: x_sel_rec := p_sel_rec;
1457: RETURN(l_return_status);
1458: END Set_Attributes;
1459: BEGIN
1460: l_return_status := Okc_Api.START_ACTIVITY(l_api_name,
1461: p_init_msg_list,
1462: '_PVT',
1463: x_return_status);
1464: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

Line 1464: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

1460: l_return_status := Okc_Api.START_ACTIVITY(l_api_name,
1461: p_init_msg_list,
1462: '_PVT',
1463: x_return_status);
1464: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1465: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1466: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1467: RAISE Okc_Api.G_EXCEPTION_ERROR;
1468: END IF;

Line 1465: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1461: p_init_msg_list,
1462: '_PVT',
1463: x_return_status);
1464: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1465: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1466: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1467: RAISE Okc_Api.G_EXCEPTION_ERROR;
1468: END IF;
1469: --- Setting item attributes

Line 1466: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN

1462: '_PVT',
1463: x_return_status);
1464: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1465: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1466: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1467: RAISE Okc_Api.G_EXCEPTION_ERROR;
1468: END IF;
1469: --- Setting item attributes
1470: l_return_status := Set_Attributes(

Line 1467: RAISE Okc_Api.G_EXCEPTION_ERROR;

1463: x_return_status);
1464: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1465: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1466: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1467: RAISE Okc_Api.G_EXCEPTION_ERROR;
1468: END IF;
1469: --- Setting item attributes
1470: l_return_status := Set_Attributes(
1471: p_sel_rec, -- IN

Line 1474: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

1470: l_return_status := Set_Attributes(
1471: p_sel_rec, -- IN
1472: l_sel_rec); -- OUT
1473: --- If any errors happen abort API
1474: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1475: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1476: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1477: RAISE Okc_Api.G_EXCEPTION_ERROR;
1478: END IF;

Line 1475: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1471: p_sel_rec, -- IN
1472: l_sel_rec); -- OUT
1473: --- If any errors happen abort API
1474: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1475: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1476: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1477: RAISE Okc_Api.G_EXCEPTION_ERROR;
1478: END IF;
1479:

Line 1476: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN

1472: l_sel_rec); -- OUT
1473: --- If any errors happen abort API
1474: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1475: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1476: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1477: RAISE Okc_Api.G_EXCEPTION_ERROR;
1478: END IF;
1479:
1480:

Line 1477: RAISE Okc_Api.G_EXCEPTION_ERROR;

1473: --- If any errors happen abort API
1474: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1475: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1476: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1477: RAISE Okc_Api.G_EXCEPTION_ERROR;
1478: END IF;
1479:
1480:
1481: INSERT INTO OKL_STRM_ELEMENTS(

Line 1538: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);

1534: l_sel_rec.date_disbursed);
1535:
1536: -- Set OUT values
1537: x_sel_rec := l_sel_rec;
1538: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1539: EXCEPTION
1540: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
1541: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
1542: (

Line 1540: WHEN Okc_Api.G_EXCEPTION_ERROR THEN

1536: -- Set OUT values
1537: x_sel_rec := l_sel_rec;
1538: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1539: EXCEPTION
1540: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
1541: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
1542: (
1543: l_api_name,
1544: G_PKG_NAME,

Line 1541: x_return_status := Okc_Api.HANDLE_EXCEPTIONS

1537: x_sel_rec := l_sel_rec;
1538: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1539: EXCEPTION
1540: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
1541: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
1542: (
1543: l_api_name,
1544: G_PKG_NAME,
1545: 'OKC_API.G_RET_STS_ERROR',

Line 1545: 'OKC_API.G_RET_STS_ERROR',

1541: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
1542: (
1543: l_api_name,
1544: G_PKG_NAME,
1545: 'OKC_API.G_RET_STS_ERROR',
1546: x_msg_count,
1547: x_msg_data,
1548: '_PVT'
1549: );

Line 1550: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

1546: x_msg_count,
1547: x_msg_data,
1548: '_PVT'
1549: );
1550: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1551: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
1552: (
1553: l_api_name,
1554: G_PKG_NAME,

Line 1551: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS

1547: x_msg_data,
1548: '_PVT'
1549: );
1550: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1551: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
1552: (
1553: l_api_name,
1554: G_PKG_NAME,
1555: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1555: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1551: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
1552: (
1553: l_api_name,
1554: G_PKG_NAME,
1555: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1556: x_msg_count,
1557: x_msg_data,
1558: '_PVT'
1559: );

Line 1561: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS

1557: x_msg_data,
1558: '_PVT'
1559: );
1560: WHEN OTHERS THEN
1561: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
1562: (
1563: l_api_name,
1564: G_PKG_NAME,
1565: 'OTHERS',

Line 1576: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,

1572: -- insert_row for:OKL_STRM_ELEMENTS_V --
1573: ----------------------------------------
1574: PROCEDURE insert_row(
1575: p_api_version IN NUMBER,
1576: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
1577: x_return_status OUT NOCOPY VARCHAR2,
1578: x_msg_count OUT NOCOPY NUMBER,
1579: x_msg_data OUT NOCOPY VARCHAR2,
1580: p_selv_rec IN selv_rec_type,

Line 1585: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

1581: x_selv_rec OUT NOCOPY selv_rec_type) IS
1582:
1583: l_api_version CONSTANT NUMBER := 1;
1584: l_api_name CONSTANT VARCHAR2(30) := 'V_insert_row';
1585: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1586: l_selv_rec selv_rec_type;
1587: l_def_selv_rec selv_rec_type;
1588: l_sel_rec sel_rec_type;
1589: lx_sel_rec sel_rec_type;

Line 1612: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

1608: FUNCTION Set_Attributes (
1609: p_selv_rec IN selv_rec_type,
1610: x_selv_rec OUT NOCOPY selv_rec_type
1611: ) RETURN VARCHAR2 IS
1612: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1613: BEGIN
1614: x_selv_rec := p_selv_rec;
1615: x_selv_rec.OBJECT_VERSION_NUMBER := 1;
1616:

Line 1634: l_return_status := Okc_Api.START_ACTIVITY(l_api_name,

1630:
1631: RETURN(l_return_status);
1632: END Set_Attributes;
1633: BEGIN
1634: l_return_status := Okc_Api.START_ACTIVITY(l_api_name,
1635: G_PKG_NAME,
1636: p_init_msg_list,
1637: l_api_version,
1638: p_api_version,

Line 1641: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

1637: l_api_version,
1638: p_api_version,
1639: '_PVT',
1640: x_return_status);
1641: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1642: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1643: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1644: RAISE Okc_Api.G_EXCEPTION_ERROR;
1645: END IF;

Line 1642: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1638: p_api_version,
1639: '_PVT',
1640: x_return_status);
1641: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1642: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1643: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1644: RAISE Okc_Api.G_EXCEPTION_ERROR;
1645: END IF;
1646: l_selv_rec := null_out_defaults(p_selv_rec);

Line 1643: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN

1639: '_PVT',
1640: x_return_status);
1641: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1642: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1643: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1644: RAISE Okc_Api.G_EXCEPTION_ERROR;
1645: END IF;
1646: l_selv_rec := null_out_defaults(p_selv_rec);
1647: -- Set primary key value

Line 1644: RAISE Okc_Api.G_EXCEPTION_ERROR;

1640: x_return_status);
1641: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1642: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1643: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1644: RAISE Okc_Api.G_EXCEPTION_ERROR;
1645: END IF;
1646: l_selv_rec := null_out_defaults(p_selv_rec);
1647: -- Set primary key value
1648: l_selv_rec.ID := get_seq_id;

Line 1654: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

1650: l_return_status := Set_Attributes(
1651: l_selv_rec, -- IN
1652: l_def_selv_rec); -- OUT
1653: --- If any errors happen abort API
1654: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1655: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1656: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1657: RAISE Okc_Api.G_EXCEPTION_ERROR;
1658: END IF;

Line 1655: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1651: l_selv_rec, -- IN
1652: l_def_selv_rec); -- OUT
1653: --- If any errors happen abort API
1654: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1655: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1656: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1657: RAISE Okc_Api.G_EXCEPTION_ERROR;
1658: END IF;
1659: l_def_selv_rec := fill_who_columns(l_def_selv_rec);

Line 1656: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN

1652: l_def_selv_rec); -- OUT
1653: --- If any errors happen abort API
1654: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1655: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1656: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1657: RAISE Okc_Api.G_EXCEPTION_ERROR;
1658: END IF;
1659: l_def_selv_rec := fill_who_columns(l_def_selv_rec);
1660: --- Validate all non-missing attributes (Item Level Validation)

Line 1657: RAISE Okc_Api.G_EXCEPTION_ERROR;

1653: --- If any errors happen abort API
1654: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1655: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1656: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1657: RAISE Okc_Api.G_EXCEPTION_ERROR;
1658: END IF;
1659: l_def_selv_rec := fill_who_columns(l_def_selv_rec);
1660: --- Validate all non-missing attributes (Item Level Validation)
1661: l_return_status := Validate_Attributes(l_def_selv_rec);

Line 1663: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

1659: l_def_selv_rec := fill_who_columns(l_def_selv_rec);
1660: --- Validate all non-missing attributes (Item Level Validation)
1661: l_return_status := Validate_Attributes(l_def_selv_rec);
1662: --- If any errors happen abort API
1663: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1664: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1665: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1666: RAISE Okc_Api.G_EXCEPTION_ERROR;
1667: END IF;

Line 1664: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1660: --- Validate all non-missing attributes (Item Level Validation)
1661: l_return_status := Validate_Attributes(l_def_selv_rec);
1662: --- If any errors happen abort API
1663: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1664: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1665: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1666: RAISE Okc_Api.G_EXCEPTION_ERROR;
1667: END IF;
1668:

Line 1665: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN

1661: l_return_status := Validate_Attributes(l_def_selv_rec);
1662: --- If any errors happen abort API
1663: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1664: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1665: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1666: RAISE Okc_Api.G_EXCEPTION_ERROR;
1667: END IF;
1668:
1669: l_return_status := Validate_Record(l_def_selv_rec);

Line 1666: RAISE Okc_Api.G_EXCEPTION_ERROR;

1662: --- If any errors happen abort API
1663: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1664: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1665: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1666: RAISE Okc_Api.G_EXCEPTION_ERROR;
1667: END IF;
1668:
1669: l_return_status := Validate_Record(l_def_selv_rec);
1670: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

Line 1670: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

1666: RAISE Okc_Api.G_EXCEPTION_ERROR;
1667: END IF;
1668:
1669: l_return_status := Validate_Record(l_def_selv_rec);
1670: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1671: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1672: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1673: RAISE Okc_Api.G_EXCEPTION_ERROR;
1674: END IF;

Line 1671: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1667: END IF;
1668:
1669: l_return_status := Validate_Record(l_def_selv_rec);
1670: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1671: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1672: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1673: RAISE Okc_Api.G_EXCEPTION_ERROR;
1674: END IF;
1675: --------------------------------------

Line 1672: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN

1668:
1669: l_return_status := Validate_Record(l_def_selv_rec);
1670: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1671: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1672: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1673: RAISE Okc_Api.G_EXCEPTION_ERROR;
1674: END IF;
1675: --------------------------------------
1676: -- Move VIEW record to "Child" records

Line 1673: RAISE Okc_Api.G_EXCEPTION_ERROR;

1669: l_return_status := Validate_Record(l_def_selv_rec);
1670: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1671: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1672: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1673: RAISE Okc_Api.G_EXCEPTION_ERROR;
1674: END IF;
1675: --------------------------------------
1676: -- Move VIEW record to "Child" records
1677: --------------------------------------

Line 1690: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

1686: x_msg_data,
1687: l_sel_rec,
1688: lx_sel_rec
1689: );
1690: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1691: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1692: ELSIF (x_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1693: RAISE Okc_Api.G_EXCEPTION_ERROR;
1694: END IF;

Line 1691: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1687: l_sel_rec,
1688: lx_sel_rec
1689: );
1690: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1691: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1692: ELSIF (x_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1693: RAISE Okc_Api.G_EXCEPTION_ERROR;
1694: END IF;
1695: migrate(lx_sel_rec, l_def_selv_rec);

Line 1692: ELSIF (x_return_status = Okc_Api.G_RET_STS_ERROR) THEN

1688: lx_sel_rec
1689: );
1690: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1691: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1692: ELSIF (x_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1693: RAISE Okc_Api.G_EXCEPTION_ERROR;
1694: END IF;
1695: migrate(lx_sel_rec, l_def_selv_rec);
1696: -- Set OUT values

Line 1693: RAISE Okc_Api.G_EXCEPTION_ERROR;

1689: );
1690: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1691: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1692: ELSIF (x_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1693: RAISE Okc_Api.G_EXCEPTION_ERROR;
1694: END IF;
1695: migrate(lx_sel_rec, l_def_selv_rec);
1696: -- Set OUT values
1697: x_selv_rec := l_def_selv_rec;

Line 1698: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);

1694: END IF;
1695: migrate(lx_sel_rec, l_def_selv_rec);
1696: -- Set OUT values
1697: x_selv_rec := l_def_selv_rec;
1698: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1699: EXCEPTION
1700: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
1701: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
1702: (

Line 1700: WHEN Okc_Api.G_EXCEPTION_ERROR THEN

1696: -- Set OUT values
1697: x_selv_rec := l_def_selv_rec;
1698: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1699: EXCEPTION
1700: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
1701: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
1702: (
1703: l_api_name,
1704: G_PKG_NAME,

Line 1701: x_return_status := Okc_Api.HANDLE_EXCEPTIONS

1697: x_selv_rec := l_def_selv_rec;
1698: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1699: EXCEPTION
1700: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
1701: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
1702: (
1703: l_api_name,
1704: G_PKG_NAME,
1705: 'OKC_API.G_RET_STS_ERROR',

Line 1705: 'OKC_API.G_RET_STS_ERROR',

1701: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
1702: (
1703: l_api_name,
1704: G_PKG_NAME,
1705: 'OKC_API.G_RET_STS_ERROR',
1706: x_msg_count,
1707: x_msg_data,
1708: '_PVT'
1709: );

Line 1710: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

1706: x_msg_count,
1707: x_msg_data,
1708: '_PVT'
1709: );
1710: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1711: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
1712: (
1713: l_api_name,
1714: G_PKG_NAME,

Line 1711: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS

1707: x_msg_data,
1708: '_PVT'
1709: );
1710: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1711: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
1712: (
1713: l_api_name,
1714: G_PKG_NAME,
1715: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1715: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1711: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
1712: (
1713: l_api_name,
1714: G_PKG_NAME,
1715: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1716: x_msg_count,
1717: x_msg_data,
1718: '_PVT'
1719: );

Line 1721: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS

1717: x_msg_data,
1718: '_PVT'
1719: );
1720: WHEN OTHERS THEN
1721: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
1722: (
1723: l_api_name,
1724: G_PKG_NAME,
1725: 'OTHERS',

Line 1736: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,

1732: -- PL/SQL TBL insert_row for:SELV_TBL --
1733: ----------------------------------------
1734: PROCEDURE insert_row(
1735: p_api_version IN NUMBER,
1736: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
1737: x_return_status OUT NOCOPY VARCHAR2,
1738: x_msg_count OUT NOCOPY NUMBER,
1739: x_msg_data OUT NOCOPY VARCHAR2,
1740: p_selv_tbl IN selv_tbl_type,

Line 1745: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

1741: x_selv_tbl OUT NOCOPY selv_tbl_type) IS
1742:
1743: l_api_version CONSTANT NUMBER := 1;
1744: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_insert_row';
1745: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1746:
1747: -- START change : akjain, 05/15/2001
1748: -- Adding OverAll Status Flag
1749: l_overall_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

Line 1749: l_overall_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

1745: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1746:
1747: -- START change : akjain, 05/15/2001
1748: -- Adding OverAll Status Flag
1749: l_overall_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1750: -- END change : akjain
1751:
1752: in_id Okl_Streams_Util.NumberTabTyp;
1753: in_stm_id Okl_Streams_Util.NumberTabTyp;

Line 1787: Okc_Api.init_msg_list(p_init_msg_list);

1783:
1784:
1785: BEGIN
1786:
1787: Okc_Api.init_msg_list(p_init_msg_list);
1788: l_return_status := Okc_Api.START_ACTIVITY(l_api_name,
1789: p_init_msg_list,
1790: '_PVT',
1791: x_return_status);

Line 1788: l_return_status := Okc_Api.START_ACTIVITY(l_api_name,

1784:
1785: BEGIN
1786:
1787: Okc_Api.init_msg_list(p_init_msg_list);
1788: l_return_status := Okc_Api.START_ACTIVITY(l_api_name,
1789: p_init_msg_list,
1790: '_PVT',
1791: x_return_status);
1792: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

Line 1792: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

1788: l_return_status := Okc_Api.START_ACTIVITY(l_api_name,
1789: p_init_msg_list,
1790: '_PVT',
1791: x_return_status);
1792: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1793: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1794: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1795: RAISE Okc_Api.G_EXCEPTION_ERROR;
1796: END IF;

Line 1793: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1789: p_init_msg_list,
1790: '_PVT',
1791: x_return_status);
1792: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1793: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1794: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1795: RAISE Okc_Api.G_EXCEPTION_ERROR;
1796: END IF;
1797:

Line 1794: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN

1790: '_PVT',
1791: x_return_status);
1792: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1793: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1794: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1795: RAISE Okc_Api.G_EXCEPTION_ERROR;
1796: END IF;
1797:
1798: --prasjain :start for bug 5474827

Line 1795: RAISE Okc_Api.G_EXCEPTION_ERROR;

1791: x_return_status);
1792: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1793: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1794: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1795: RAISE Okc_Api.G_EXCEPTION_ERROR;
1796: END IF;
1797:
1798: --prasjain :start for bug 5474827
1799: x_selv_tbl := p_selv_tbl;

Line 1911: x_return_status := Okc_Api.G_RET_STS_SUCCESS;

1907: --x_selv_tbl := p_selv_tbl;
1908: --prasjain:End
1909:
1910:
1911: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
1912: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1913:
1914: EXCEPTION
1915: WHEN Okc_Api.G_EXCEPTION_ERROR THEN

Line 1912: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);

1908: --prasjain:End
1909:
1910:
1911: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
1912: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1913:
1914: EXCEPTION
1915: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
1916: x_return_status := Okc_Api.HANDLE_EXCEPTIONS

Line 1915: WHEN Okc_Api.G_EXCEPTION_ERROR THEN

1911: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
1912: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1913:
1914: EXCEPTION
1915: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
1916: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
1917: (
1918: l_api_name,
1919: G_PKG_NAME,

Line 1916: x_return_status := Okc_Api.HANDLE_EXCEPTIONS

1912: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1913:
1914: EXCEPTION
1915: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
1916: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
1917: (
1918: l_api_name,
1919: G_PKG_NAME,
1920: 'OKC_API.G_RET_STS_ERROR',

Line 1920: 'OKC_API.G_RET_STS_ERROR',

1916: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
1917: (
1918: l_api_name,
1919: G_PKG_NAME,
1920: 'OKC_API.G_RET_STS_ERROR',
1921: x_msg_count,
1922: x_msg_data,
1923: '_PVT'
1924: );

Line 1925: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

1921: x_msg_count,
1922: x_msg_data,
1923: '_PVT'
1924: );
1925: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1926: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
1927: (
1928: l_api_name,
1929: G_PKG_NAME,

Line 1926: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS

1922: x_msg_data,
1923: '_PVT'
1924: );
1925: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1926: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
1927: (
1928: l_api_name,
1929: G_PKG_NAME,
1930: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1930: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1926: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
1927: (
1928: l_api_name,
1929: G_PKG_NAME,
1930: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1931: x_msg_count,
1932: x_msg_data,
1933: '_PVT'
1934: );

Line 1936: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS

1932: x_msg_data,
1933: '_PVT'
1934: );
1935: WHEN OTHERS THEN
1936: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
1937: (
1938: l_api_name,
1939: G_PKG_NAME,
1940: 'OTHERS',

Line 1954: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,

1950: ------------------------------------
1951: -- lock_row for:OKL_STRM_ELEMENTS --
1952: ------------------------------------
1953: PROCEDURE lock_row(
1954: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
1955: x_return_status OUT NOCOPY VARCHAR2,
1956: x_msg_count OUT NOCOPY NUMBER,
1957: x_msg_data OUT NOCOPY VARCHAR2,
1958: p_sel_rec IN sel_rec_type) IS

Line 1975: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

1971: FROM OKL_STRM_ELEMENTS
1972: WHERE ID = p_sel_rec.id;
1973: l_api_version CONSTANT NUMBER := 1;
1974: l_api_name CONSTANT VARCHAR2(30) := 'ELEMENTS_lock_row';
1975: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1976: l_object_version_number OKL_STRM_ELEMENTS.OBJECT_VERSION_NUMBER%TYPE;
1977: lc_object_version_number OKL_STRM_ELEMENTS.OBJECT_VERSION_NUMBER%TYPE;
1978: l_row_notfound BOOLEAN := FALSE;
1979: lc_row_notfound BOOLEAN := FALSE;

Line 1981: l_return_status := Okc_Api.START_ACTIVITY(l_api_name,

1977: lc_object_version_number OKL_STRM_ELEMENTS.OBJECT_VERSION_NUMBER%TYPE;
1978: l_row_notfound BOOLEAN := FALSE;
1979: lc_row_notfound BOOLEAN := FALSE;
1980: BEGIN
1981: l_return_status := Okc_Api.START_ACTIVITY(l_api_name,
1982: p_init_msg_list,
1983: '_PVT',
1984: x_return_status);
1985: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

Line 1985: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

1981: l_return_status := Okc_Api.START_ACTIVITY(l_api_name,
1982: p_init_msg_list,
1983: '_PVT',
1984: x_return_status);
1985: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1986: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1987: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1988: RAISE Okc_Api.G_EXCEPTION_ERROR;
1989: END IF;

Line 1986: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1982: p_init_msg_list,
1983: '_PVT',
1984: x_return_status);
1985: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1986: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1987: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1988: RAISE Okc_Api.G_EXCEPTION_ERROR;
1989: END IF;
1990: BEGIN

Line 1987: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN

1983: '_PVT',
1984: x_return_status);
1985: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1986: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1987: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1988: RAISE Okc_Api.G_EXCEPTION_ERROR;
1989: END IF;
1990: BEGIN
1991: OPEN lock_csr(p_sel_rec);

Line 1988: RAISE Okc_Api.G_EXCEPTION_ERROR;

1984: x_return_status);
1985: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1986: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1987: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1988: RAISE Okc_Api.G_EXCEPTION_ERROR;
1989: END IF;
1990: BEGIN
1991: OPEN lock_csr(p_sel_rec);
1992: FETCH lock_csr INTO l_object_version_number;

Line 2000: Okc_Api.set_message(G_FND_APP,G_FORM_UNABLE_TO_RESERVE_REC);

1996: WHEN E_Resource_Busy THEN
1997: IF (lock_csr%ISOPEN) THEN
1998: CLOSE lock_csr;
1999: END IF;
2000: Okc_Api.set_message(G_FND_APP,G_FORM_UNABLE_TO_RESERVE_REC);
2001: RAISE APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION;
2002: END;
2003:
2004: IF ( l_row_notfound ) THEN

Line 2011: Okc_Api.set_message(G_FND_APP,G_FORM_RECORD_DELETED);

2007: lc_row_notfound := lchk_csr%NOTFOUND;
2008: CLOSE lchk_csr;
2009: END IF;
2010: IF (lc_row_notfound) THEN
2011: Okc_Api.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
2012: RAISE Okc_Api.G_EXCEPTION_ERROR;
2013: ELSIF lc_object_version_number > p_sel_rec.object_version_number THEN
2014: Okc_Api.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
2015: RAISE Okc_Api.G_EXCEPTION_ERROR;

Line 2012: RAISE Okc_Api.G_EXCEPTION_ERROR;

2008: CLOSE lchk_csr;
2009: END IF;
2010: IF (lc_row_notfound) THEN
2011: Okc_Api.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
2012: RAISE Okc_Api.G_EXCEPTION_ERROR;
2013: ELSIF lc_object_version_number > p_sel_rec.object_version_number THEN
2014: Okc_Api.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
2015: RAISE Okc_Api.G_EXCEPTION_ERROR;
2016: ELSIF lc_object_version_number <> p_sel_rec.object_version_number THEN

Line 2014: Okc_Api.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);

2010: IF (lc_row_notfound) THEN
2011: Okc_Api.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
2012: RAISE Okc_Api.G_EXCEPTION_ERROR;
2013: ELSIF lc_object_version_number > p_sel_rec.object_version_number THEN
2014: Okc_Api.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
2015: RAISE Okc_Api.G_EXCEPTION_ERROR;
2016: ELSIF lc_object_version_number <> p_sel_rec.object_version_number THEN
2017: Okc_Api.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
2018: RAISE Okc_Api.G_EXCEPTION_ERROR;

Line 2015: RAISE Okc_Api.G_EXCEPTION_ERROR;

2011: Okc_Api.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
2012: RAISE Okc_Api.G_EXCEPTION_ERROR;
2013: ELSIF lc_object_version_number > p_sel_rec.object_version_number THEN
2014: Okc_Api.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
2015: RAISE Okc_Api.G_EXCEPTION_ERROR;
2016: ELSIF lc_object_version_number <> p_sel_rec.object_version_number THEN
2017: Okc_Api.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
2018: RAISE Okc_Api.G_EXCEPTION_ERROR;
2019: ELSIF lc_object_version_number = -1 THEN

Line 2017: Okc_Api.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);

2013: ELSIF lc_object_version_number > p_sel_rec.object_version_number THEN
2014: Okc_Api.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
2015: RAISE Okc_Api.G_EXCEPTION_ERROR;
2016: ELSIF lc_object_version_number <> p_sel_rec.object_version_number THEN
2017: Okc_Api.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
2018: RAISE Okc_Api.G_EXCEPTION_ERROR;
2019: ELSIF lc_object_version_number = -1 THEN
2020: Okc_Api.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
2021: RAISE Okc_Api.G_EXCEPTION_ERROR;

Line 2018: RAISE Okc_Api.G_EXCEPTION_ERROR;

2014: Okc_Api.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
2015: RAISE Okc_Api.G_EXCEPTION_ERROR;
2016: ELSIF lc_object_version_number <> p_sel_rec.object_version_number THEN
2017: Okc_Api.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
2018: RAISE Okc_Api.G_EXCEPTION_ERROR;
2019: ELSIF lc_object_version_number = -1 THEN
2020: Okc_Api.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
2021: RAISE Okc_Api.G_EXCEPTION_ERROR;
2022: END IF;

Line 2020: Okc_Api.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);

2016: ELSIF lc_object_version_number <> p_sel_rec.object_version_number THEN
2017: Okc_Api.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
2018: RAISE Okc_Api.G_EXCEPTION_ERROR;
2019: ELSIF lc_object_version_number = -1 THEN
2020: Okc_Api.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
2021: RAISE Okc_Api.G_EXCEPTION_ERROR;
2022: END IF;
2023: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
2024: EXCEPTION

Line 2021: RAISE Okc_Api.G_EXCEPTION_ERROR;

2017: Okc_Api.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
2018: RAISE Okc_Api.G_EXCEPTION_ERROR;
2019: ELSIF lc_object_version_number = -1 THEN
2020: Okc_Api.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
2021: RAISE Okc_Api.G_EXCEPTION_ERROR;
2022: END IF;
2023: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
2024: EXCEPTION
2025: WHEN Okc_Api.G_EXCEPTION_ERROR THEN

Line 2023: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);

2019: ELSIF lc_object_version_number = -1 THEN
2020: Okc_Api.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
2021: RAISE Okc_Api.G_EXCEPTION_ERROR;
2022: END IF;
2023: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
2024: EXCEPTION
2025: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
2026: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
2027: (

Line 2025: WHEN Okc_Api.G_EXCEPTION_ERROR THEN

2021: RAISE Okc_Api.G_EXCEPTION_ERROR;
2022: END IF;
2023: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
2024: EXCEPTION
2025: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
2026: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
2027: (
2028: l_api_name,
2029: G_PKG_NAME,

Line 2026: x_return_status := Okc_Api.HANDLE_EXCEPTIONS

2022: END IF;
2023: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
2024: EXCEPTION
2025: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
2026: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
2027: (
2028: l_api_name,
2029: G_PKG_NAME,
2030: 'OKC_API.G_RET_STS_ERROR',

Line 2030: 'OKC_API.G_RET_STS_ERROR',

2026: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
2027: (
2028: l_api_name,
2029: G_PKG_NAME,
2030: 'OKC_API.G_RET_STS_ERROR',
2031: x_msg_count,
2032: x_msg_data,
2033: '_PVT'
2034: );

Line 2035: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

2031: x_msg_count,
2032: x_msg_data,
2033: '_PVT'
2034: );
2035: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
2036: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
2037: (
2038: l_api_name,
2039: G_PKG_NAME,

Line 2036: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS

2032: x_msg_data,
2033: '_PVT'
2034: );
2035: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
2036: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
2037: (
2038: l_api_name,
2039: G_PKG_NAME,
2040: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 2040: 'OKC_API.G_RET_STS_UNEXP_ERROR',

2036: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
2037: (
2038: l_api_name,
2039: G_PKG_NAME,
2040: 'OKC_API.G_RET_STS_UNEXP_ERROR',
2041: x_msg_count,
2042: x_msg_data,
2043: '_PVT'
2044: );

Line 2046: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS

2042: x_msg_data,
2043: '_PVT'
2044: );
2045: WHEN OTHERS THEN
2046: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
2047: (
2048: l_api_name,
2049: G_PKG_NAME,
2050: 'OTHERS',

Line 2061: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,

2057: -- lock_row for:OKL_STRM_ELEMENTS_V --
2058: --------------------------------------
2059: PROCEDURE lock_row(
2060: p_api_version IN NUMBER,
2061: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
2062: x_return_status OUT NOCOPY VARCHAR2,
2063: x_msg_count OUT NOCOPY NUMBER,
2064: x_msg_data OUT NOCOPY VARCHAR2,
2065: p_selv_rec IN selv_rec_type) IS

Line 2069: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

2065: p_selv_rec IN selv_rec_type) IS
2066:
2067: l_api_version CONSTANT NUMBER := 1;
2068: l_api_name CONSTANT VARCHAR2(30) := 'V_lock_row';
2069: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
2070: l_sel_rec sel_rec_type;
2071: BEGIN
2072: l_return_status := Okc_Api.START_ACTIVITY(l_api_name,
2073: G_PKG_NAME,

Line 2072: l_return_status := Okc_Api.START_ACTIVITY(l_api_name,

2068: l_api_name CONSTANT VARCHAR2(30) := 'V_lock_row';
2069: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
2070: l_sel_rec sel_rec_type;
2071: BEGIN
2072: l_return_status := Okc_Api.START_ACTIVITY(l_api_name,
2073: G_PKG_NAME,
2074: p_init_msg_list,
2075: l_api_version,
2076: p_api_version,

Line 2079: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

2075: l_api_version,
2076: p_api_version,
2077: '_PVT',
2078: x_return_status);
2079: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2080: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2081: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2082: RAISE Okc_Api.G_EXCEPTION_ERROR;
2083: END IF;

Line 2080: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

2076: p_api_version,
2077: '_PVT',
2078: x_return_status);
2079: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2080: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2081: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2082: RAISE Okc_Api.G_EXCEPTION_ERROR;
2083: END IF;
2084: --------------------------------------

Line 2081: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN

2077: '_PVT',
2078: x_return_status);
2079: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2080: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2081: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2082: RAISE Okc_Api.G_EXCEPTION_ERROR;
2083: END IF;
2084: --------------------------------------
2085: -- Move VIEW record to "Child" records

Line 2082: RAISE Okc_Api.G_EXCEPTION_ERROR;

2078: x_return_status);
2079: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2080: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2081: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2082: RAISE Okc_Api.G_EXCEPTION_ERROR;
2083: END IF;
2084: --------------------------------------
2085: -- Move VIEW record to "Child" records
2086: --------------------------------------

Line 2098: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

2094: x_msg_count,
2095: x_msg_data,
2096: l_sel_rec
2097: );
2098: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2099: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2100: ELSIF (x_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2101: RAISE Okc_Api.G_EXCEPTION_ERROR;
2102: END IF;

Line 2099: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

2095: x_msg_data,
2096: l_sel_rec
2097: );
2098: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2099: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2100: ELSIF (x_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2101: RAISE Okc_Api.G_EXCEPTION_ERROR;
2102: END IF;
2103: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);

Line 2100: ELSIF (x_return_status = Okc_Api.G_RET_STS_ERROR) THEN

2096: l_sel_rec
2097: );
2098: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2099: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2100: ELSIF (x_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2101: RAISE Okc_Api.G_EXCEPTION_ERROR;
2102: END IF;
2103: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
2104: EXCEPTION

Line 2101: RAISE Okc_Api.G_EXCEPTION_ERROR;

2097: );
2098: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2099: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2100: ELSIF (x_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2101: RAISE Okc_Api.G_EXCEPTION_ERROR;
2102: END IF;
2103: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
2104: EXCEPTION
2105: WHEN Okc_Api.G_EXCEPTION_ERROR THEN

Line 2103: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);

2099: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2100: ELSIF (x_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2101: RAISE Okc_Api.G_EXCEPTION_ERROR;
2102: END IF;
2103: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
2104: EXCEPTION
2105: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
2106: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
2107: (

Line 2105: WHEN Okc_Api.G_EXCEPTION_ERROR THEN

2101: RAISE Okc_Api.G_EXCEPTION_ERROR;
2102: END IF;
2103: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
2104: EXCEPTION
2105: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
2106: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
2107: (
2108: l_api_name,
2109: G_PKG_NAME,

Line 2106: x_return_status := Okc_Api.HANDLE_EXCEPTIONS

2102: END IF;
2103: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
2104: EXCEPTION
2105: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
2106: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
2107: (
2108: l_api_name,
2109: G_PKG_NAME,
2110: 'OKC_API.G_RET_STS_ERROR',

Line 2110: 'OKC_API.G_RET_STS_ERROR',

2106: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
2107: (
2108: l_api_name,
2109: G_PKG_NAME,
2110: 'OKC_API.G_RET_STS_ERROR',
2111: x_msg_count,
2112: x_msg_data,
2113: '_PVT'
2114: );

Line 2115: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

2111: x_msg_count,
2112: x_msg_data,
2113: '_PVT'
2114: );
2115: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
2116: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
2117: (
2118: l_api_name,
2119: G_PKG_NAME,

Line 2116: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS

2112: x_msg_data,
2113: '_PVT'
2114: );
2115: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
2116: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
2117: (
2118: l_api_name,
2119: G_PKG_NAME,
2120: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 2120: 'OKC_API.G_RET_STS_UNEXP_ERROR',

2116: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
2117: (
2118: l_api_name,
2119: G_PKG_NAME,
2120: 'OKC_API.G_RET_STS_UNEXP_ERROR',
2121: x_msg_count,
2122: x_msg_data,
2123: '_PVT'
2124: );

Line 2126: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS

2122: x_msg_data,
2123: '_PVT'
2124: );
2125: WHEN OTHERS THEN
2126: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
2127: (
2128: l_api_name,
2129: G_PKG_NAME,
2130: 'OTHERS',

Line 2141: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,

2137: -- PL/SQL TBL lock_row for:SELV_TBL --
2138: --------------------------------------
2139: PROCEDURE lock_row(
2140: p_api_version IN NUMBER,
2141: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
2142: x_return_status OUT NOCOPY VARCHAR2,
2143: x_msg_count OUT NOCOPY NUMBER,
2144: x_msg_data OUT NOCOPY VARCHAR2,
2145: p_selv_tbl IN selv_tbl_type) IS

Line 2149: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

2145: p_selv_tbl IN selv_tbl_type) IS
2146:
2147: l_api_version CONSTANT NUMBER := 1;
2148: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_lock_row';
2149: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
2150: i NUMBER := 0;
2151: -- START change : akjain, 05/15/2001
2152: -- Adding OverAll Status Flag
2153: l_overall_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

Line 2153: l_overall_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

2149: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
2150: i NUMBER := 0;
2151: -- START change : akjain, 05/15/2001
2152: -- Adding OverAll Status Flag
2153: l_overall_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
2154: -- END change : akjain
2155:
2156: BEGIN
2157: Okc_Api.init_msg_list(p_init_msg_list);

Line 2157: Okc_Api.init_msg_list(p_init_msg_list);

2153: l_overall_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
2154: -- END change : akjain
2155:
2156: BEGIN
2157: Okc_Api.init_msg_list(p_init_msg_list);
2158: -- Make sure PL/SQL table has records in it before passing
2159: IF (p_selv_tbl.COUNT > 0) THEN
2160: i := p_selv_tbl.FIRST;
2161: LOOP

Line 2164: p_init_msg_list => Okc_Api.G_FALSE,

2160: i := p_selv_tbl.FIRST;
2161: LOOP
2162: lock_row (
2163: p_api_version => p_api_version,
2164: p_init_msg_list => Okc_Api.G_FALSE,
2165: x_return_status => x_return_status,
2166: x_msg_count => x_msg_count,
2167: x_msg_data => x_msg_data,
2168: p_selv_rec => p_selv_tbl(i));

Line 2172: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS THEN

2168: p_selv_rec => p_selv_tbl(i));
2169:
2170: -- START change : akjain, 05/15/2001
2171: -- store the highest degree of error
2172: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS THEN
2173: IF l_overall_status <> Okc_Api.G_RET_STS_UNEXP_ERROR THEN
2174: l_overall_status := x_return_status;
2175: END IF;
2176: END IF;

Line 2173: IF l_overall_status <> Okc_Api.G_RET_STS_UNEXP_ERROR THEN

2169:
2170: -- START change : akjain, 05/15/2001
2171: -- store the highest degree of error
2172: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS THEN
2173: IF l_overall_status <> Okc_Api.G_RET_STS_UNEXP_ERROR THEN
2174: l_overall_status := x_return_status;
2175: END IF;
2176: END IF;
2177: -- END change : akjain

Line 2189: WHEN Okc_Api.G_EXCEPTION_ERROR THEN

2185: x_return_status := l_overall_status;
2186: -- END change : akjain
2187: END IF;
2188: EXCEPTION
2189: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
2190: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
2191: (
2192: l_api_name,
2193: G_PKG_NAME,

Line 2190: x_return_status := Okc_Api.HANDLE_EXCEPTIONS

2186: -- END change : akjain
2187: END IF;
2188: EXCEPTION
2189: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
2190: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
2191: (
2192: l_api_name,
2193: G_PKG_NAME,
2194: 'OKC_API.G_RET_STS_ERROR',

Line 2194: 'OKC_API.G_RET_STS_ERROR',

2190: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
2191: (
2192: l_api_name,
2193: G_PKG_NAME,
2194: 'OKC_API.G_RET_STS_ERROR',
2195: x_msg_count,
2196: x_msg_data,
2197: '_PVT'
2198: );

Line 2199: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

2195: x_msg_count,
2196: x_msg_data,
2197: '_PVT'
2198: );
2199: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
2200: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
2201: (
2202: l_api_name,
2203: G_PKG_NAME,

Line 2200: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS

2196: x_msg_data,
2197: '_PVT'
2198: );
2199: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
2200: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
2201: (
2202: l_api_name,
2203: G_PKG_NAME,
2204: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 2204: 'OKC_API.G_RET_STS_UNEXP_ERROR',

2200: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
2201: (
2202: l_api_name,
2203: G_PKG_NAME,
2204: 'OKC_API.G_RET_STS_UNEXP_ERROR',
2205: x_msg_count,
2206: x_msg_data,
2207: '_PVT'
2208: );

Line 2210: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS

2206: x_msg_data,
2207: '_PVT'
2208: );
2209: WHEN OTHERS THEN
2210: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
2211: (
2212: l_api_name,
2213: G_PKG_NAME,
2214: 'OTHERS',

Line 2228: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,

2224: --------------------------------------
2225: -- update_row for:OKL_STRM_ELEMENTS --
2226: --------------------------------------
2227: PROCEDURE update_row(
2228: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
2229: x_return_status OUT NOCOPY VARCHAR2,
2230: x_msg_count OUT NOCOPY NUMBER,
2231: x_msg_data OUT NOCOPY VARCHAR2,
2232: p_sel_rec IN sel_rec_type,

Line 2237: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

2233: x_sel_rec OUT NOCOPY sel_rec_type) IS
2234:
2235: l_api_version CONSTANT NUMBER := 1;
2236: l_api_name CONSTANT VARCHAR2(30) := 'ELEMENTS_update_row';
2237: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
2238: l_sel_rec sel_rec_type := p_sel_rec;
2239: l_def_sel_rec sel_rec_type;
2240: l_row_notfound BOOLEAN := TRUE;
2241: ----------------------------------

Line 2250: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

2246: x_sel_rec OUT NOCOPY sel_rec_type
2247: ) RETURN VARCHAR2 IS
2248: l_sel_rec sel_rec_type;
2249: l_row_notfound BOOLEAN := TRUE;
2250: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
2251: BEGIN
2252: x_sel_rec := p_sel_rec;
2253: -- Get current database values
2254: l_sel_rec := get_rec(p_sel_rec, l_row_notfound);

Line 2256: l_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;

2252: x_sel_rec := p_sel_rec;
2253: -- Get current database values
2254: l_sel_rec := get_rec(p_sel_rec, l_row_notfound);
2255: IF (l_row_notfound) THEN
2256: l_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;
2257: END IF;
2258: IF (x_sel_rec.id IS NULL)THEN
2259: x_sel_rec.id := l_sel_rec.id;
2260: ELSIF (x_sel_rec.id = Okc_Api.G_MISS_NUM) THEN

Line 2260: ELSIF (x_sel_rec.id = Okc_Api.G_MISS_NUM) THEN

2256: l_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;
2257: END IF;
2258: IF (x_sel_rec.id IS NULL)THEN
2259: x_sel_rec.id := l_sel_rec.id;
2260: ELSIF (x_sel_rec.id = Okc_Api.G_MISS_NUM) THEN
2261: x_sel_rec.id := NULL;
2262: END IF;
2263: IF (x_sel_rec.stm_id IS NULL)THEN
2264: x_sel_rec.stm_id := l_sel_rec.stm_id;

Line 2265: ELSIF (x_sel_rec.stm_id = Okc_Api.G_MISS_NUM) THEN

2261: x_sel_rec.id := NULL;
2262: END IF;
2263: IF (x_sel_rec.stm_id IS NULL)THEN
2264: x_sel_rec.stm_id := l_sel_rec.stm_id;
2265: ELSIF (x_sel_rec.stm_id = Okc_Api.G_MISS_NUM) THEN
2266: x_sel_rec.stm_id := NULL;
2267: END IF;
2268: IF (x_sel_rec.object_version_number IS NULL)THEN
2269: x_sel_rec.object_version_number := l_sel_rec.object_version_number;

Line 2270: ELSIF (x_sel_rec.object_version_number = Okc_Api.G_MISS_NUM) THEN

2266: x_sel_rec.stm_id := NULL;
2267: END IF;
2268: IF (x_sel_rec.object_version_number IS NULL)THEN
2269: x_sel_rec.object_version_number := l_sel_rec.object_version_number;
2270: ELSIF (x_sel_rec.object_version_number = Okc_Api.G_MISS_NUM) THEN
2271: x_sel_rec.object_version_number := NULL;
2272: END IF;
2273: IF (x_sel_rec.stream_element_date IS NULL)THEN
2274: x_sel_rec.stream_element_date := l_sel_rec.stream_element_date;

Line 2275: ELSIF (x_sel_rec.stream_element_date = Okc_Api.G_MISS_DATE) THEN

2271: x_sel_rec.object_version_number := NULL;
2272: END IF;
2273: IF (x_sel_rec.stream_element_date IS NULL)THEN
2274: x_sel_rec.stream_element_date := l_sel_rec.stream_element_date;
2275: ELSIF (x_sel_rec.stream_element_date = Okc_Api.G_MISS_DATE) THEN
2276: x_sel_rec.stream_element_date := NULL;
2277: END IF;
2278: IF (x_sel_rec.amount IS NULL) THEN
2279: x_sel_rec.amount := l_sel_rec.amount;

Line 2280: ELSIF (x_sel_rec.amount = Okc_Api.G_MISS_NUM) THEN

2276: x_sel_rec.stream_element_date := NULL;
2277: END IF;
2278: IF (x_sel_rec.amount IS NULL) THEN
2279: x_sel_rec.amount := l_sel_rec.amount;
2280: ELSIF (x_sel_rec.amount = Okc_Api.G_MISS_NUM) THEN
2281: x_sel_rec.amount := NULL;
2282: END IF;
2283: IF (x_sel_rec.comments IS NULL)THEN
2284: x_sel_rec.comments := l_sel_rec.comments;

Line 2285: ELSIF (x_sel_rec.comments = Okc_Api.G_MISS_CHAR) THEN

2281: x_sel_rec.amount := NULL;
2282: END IF;
2283: IF (x_sel_rec.comments IS NULL)THEN
2284: x_sel_rec.comments := l_sel_rec.comments;
2285: ELSIF (x_sel_rec.comments = Okc_Api.G_MISS_CHAR) THEN
2286: x_sel_rec.comments := NULL;
2287: END IF;
2288: IF (x_sel_rec.accrued_yn IS NULL) THEN
2289: x_sel_rec.accrued_yn := l_sel_rec.accrued_yn;

Line 2290: ELSIF (x_sel_rec.accrued_yn = Okc_Api.G_MISS_CHAR) THEN

2286: x_sel_rec.comments := NULL;
2287: END IF;
2288: IF (x_sel_rec.accrued_yn IS NULL) THEN
2289: x_sel_rec.accrued_yn := l_sel_rec.accrued_yn;
2290: ELSIF (x_sel_rec.accrued_yn = Okc_Api.G_MISS_CHAR) THEN
2291: x_sel_rec.accrued_yn := NULL;
2292: END IF;
2293: IF (x_sel_rec.program_id IS NULL)THEN
2294: x_sel_rec.program_id := l_sel_rec.program_id;

Line 2295: ELSIF (x_sel_rec.program_id = Okc_Api.G_MISS_NUM) THEN

2291: x_sel_rec.accrued_yn := NULL;
2292: END IF;
2293: IF (x_sel_rec.program_id IS NULL)THEN
2294: x_sel_rec.program_id := l_sel_rec.program_id;
2295: ELSIF (x_sel_rec.program_id = Okc_Api.G_MISS_NUM) THEN
2296: x_sel_rec.program_id := NULL;
2297: END IF;
2298: IF (x_sel_rec.request_id IS NULL) THEN
2299: x_sel_rec.request_id := l_sel_rec.request_id;

Line 2300: ELSIF (x_sel_rec.request_id = Okc_Api.G_MISS_NUM) THEN

2296: x_sel_rec.program_id := NULL;
2297: END IF;
2298: IF (x_sel_rec.request_id IS NULL) THEN
2299: x_sel_rec.request_id := l_sel_rec.request_id;
2300: ELSIF (x_sel_rec.request_id = Okc_Api.G_MISS_NUM) THEN
2301: x_sel_rec.request_id := NULL;
2302: END IF;
2303: IF (x_sel_rec.program_application_id IS NULL)THEN
2304: x_sel_rec.program_application_id := l_sel_rec.program_application_id;

Line 2305: ELSIF (x_sel_rec.program_application_id = Okc_Api.G_MISS_NUM) THEN

2301: x_sel_rec.request_id := NULL;
2302: END IF;
2303: IF (x_sel_rec.program_application_id IS NULL)THEN
2304: x_sel_rec.program_application_id := l_sel_rec.program_application_id;
2305: ELSIF (x_sel_rec.program_application_id = Okc_Api.G_MISS_NUM) THEN
2306: x_sel_rec.program_application_id := NULL;
2307: END IF;
2308: IF (x_sel_rec.program_update_date IS NULL) THEN
2309: x_sel_rec.program_update_date := l_sel_rec.program_update_date;

Line 2310: ELSIF (x_sel_rec.program_update_date = Okc_Api.G_MISS_DATE) THEN

2306: x_sel_rec.program_application_id := NULL;
2307: END IF;
2308: IF (x_sel_rec.program_update_date IS NULL) THEN
2309: x_sel_rec.program_update_date := l_sel_rec.program_update_date;
2310: ELSIF (x_sel_rec.program_update_date = Okc_Api.G_MISS_DATE) THEN
2311: x_sel_rec.program_update_date := NULL;
2312: END IF;
2313: IF (x_sel_rec.se_line_number IS NULL)THEN
2314: x_sel_rec.se_line_number := l_sel_rec.se_line_number;

Line 2315: ELSIF (x_sel_rec.se_line_number = Okc_Api.G_MISS_NUM) THEN

2311: x_sel_rec.program_update_date := NULL;
2312: END IF;
2313: IF (x_sel_rec.se_line_number IS NULL)THEN
2314: x_sel_rec.se_line_number := l_sel_rec.se_line_number;
2315: ELSIF (x_sel_rec.se_line_number = Okc_Api.G_MISS_NUM) THEN
2316: x_sel_rec.se_line_number := NULL;
2317: END IF;
2318: IF (x_sel_rec.date_billed IS NULL)THEN
2319: x_sel_rec.date_billed := l_sel_rec.date_billed;

Line 2320: ELSIF (x_sel_rec.date_billed = Okc_Api.G_MISS_DATE) THEN

2316: x_sel_rec.se_line_number := NULL;
2317: END IF;
2318: IF (x_sel_rec.date_billed IS NULL)THEN
2319: x_sel_rec.date_billed := l_sel_rec.date_billed;
2320: ELSIF (x_sel_rec.date_billed = Okc_Api.G_MISS_DATE) THEN
2321: x_sel_rec.date_billed := NULL;
2322: END IF;
2323: IF (x_sel_rec.created_by IS NULL) THEN
2324: x_sel_rec.created_by := l_sel_rec.created_by;

Line 2325: ELSIF (x_sel_rec.created_by = Okc_Api.G_MISS_NUM) THEN

2321: x_sel_rec.date_billed := NULL;
2322: END IF;
2323: IF (x_sel_rec.created_by IS NULL) THEN
2324: x_sel_rec.created_by := l_sel_rec.created_by;
2325: ELSIF (x_sel_rec.created_by = Okc_Api.G_MISS_NUM) THEN
2326: x_sel_rec.created_by := NULL;
2327: END IF;
2328: IF (x_sel_rec.creation_date IS NULL)THEN
2329: x_sel_rec.creation_date := l_sel_rec.creation_date;

Line 2330: ELSIF (x_sel_rec.created_by = Okc_Api.G_MISS_NUM) THEN

2326: x_sel_rec.created_by := NULL;
2327: END IF;
2328: IF (x_sel_rec.creation_date IS NULL)THEN
2329: x_sel_rec.creation_date := l_sel_rec.creation_date;
2330: ELSIF (x_sel_rec.created_by = Okc_Api.G_MISS_NUM) THEN
2331: x_sel_rec.created_by := NULL;
2332: END IF;
2333: IF (x_sel_rec.last_updated_by IS NULL) THEN
2334: x_sel_rec.last_updated_by := l_sel_rec.last_updated_by;

Line 2335: ELSIF (x_sel_rec.last_updated_by = Okc_Api.G_MISS_NUM) THEN

2331: x_sel_rec.created_by := NULL;
2332: END IF;
2333: IF (x_sel_rec.last_updated_by IS NULL) THEN
2334: x_sel_rec.last_updated_by := l_sel_rec.last_updated_by;
2335: ELSIF (x_sel_rec.last_updated_by = Okc_Api.G_MISS_NUM) THEN
2336: x_sel_rec.last_updated_by := NULL;
2337: END IF;
2338: IF (x_sel_rec.last_update_date IS NULL)THEN
2339: x_sel_rec.last_update_date := l_sel_rec.last_update_date;

Line 2340: ELSIF (x_sel_rec.last_update_date = Okc_Api.G_MISS_DATE) THEN

2336: x_sel_rec.last_updated_by := NULL;
2337: END IF;
2338: IF (x_sel_rec.last_update_date IS NULL)THEN
2339: x_sel_rec.last_update_date := l_sel_rec.last_update_date;
2340: ELSIF (x_sel_rec.last_update_date = Okc_Api.G_MISS_DATE) THEN
2341: x_sel_rec.last_update_date := NULL;
2342: END IF;
2343: IF (x_sel_rec.last_update_login IS NULL)THEN
2344: x_sel_rec.last_update_login := l_sel_rec.last_update_login;

Line 2345: ELSIF (x_sel_rec.last_update_login = Okc_Api.G_MISS_NUM) THEN

2341: x_sel_rec.last_update_date := NULL;
2342: END IF;
2343: IF (x_sel_rec.last_update_login IS NULL)THEN
2344: x_sel_rec.last_update_login := l_sel_rec.last_update_login;
2345: ELSIF (x_sel_rec.last_update_login = Okc_Api.G_MISS_NUM) THEN
2346: x_sel_rec.last_update_login := NULL;
2347: END IF;
2348: IF (x_sel_rec.sel_id IS NULL)THEN
2349: x_sel_rec.sel_id := l_sel_rec.sel_id;

Line 2350: ELSIF (x_sel_rec.sel_id = Okc_Api.G_MISS_NUM) THEN

2346: x_sel_rec.last_update_login := NULL;
2347: END IF;
2348: IF (x_sel_rec.sel_id IS NULL)THEN
2349: x_sel_rec.sel_id := l_sel_rec.sel_id;
2350: ELSIF (x_sel_rec.sel_id = Okc_Api.G_MISS_NUM) THEN
2351: x_sel_rec.sel_id := NULL;
2352: END IF;
2353: --Added by Keerthi 15-Sep-2003
2354: IF (x_sel_rec.source_id IS NULL)THEN

Line 2356: ELSIF ( x_sel_rec.source_id = Okc_Api.G_MISS_NUM) THEN

2352: END IF;
2353: --Added by Keerthi 15-Sep-2003
2354: IF (x_sel_rec.source_id IS NULL)THEN
2355: x_sel_rec.source_id := l_sel_rec.source_id;
2356: ELSIF ( x_sel_rec.source_id = Okc_Api.G_MISS_NUM) THEN
2357: x_sel_rec.source_id := NULL;
2358: END IF;
2359: IF (x_sel_rec.source_table IS NULL)THEN
2360: x_sel_rec.source_table := l_sel_rec.source_table;

Line 2361: ELSIF (x_sel_rec.source_table = Okc_Api.G_MISS_CHAR) THEN

2357: x_sel_rec.source_id := NULL;
2358: END IF;
2359: IF (x_sel_rec.source_table IS NULL)THEN
2360: x_sel_rec.source_table := l_sel_rec.source_table;
2361: ELSIF (x_sel_rec.source_table = Okc_Api.G_MISS_CHAR) THEN
2362: x_sel_rec.source_table := NULL;
2363: END IF;
2364: -- Added by rgooty: 4212626
2365: IF (x_sel_rec.bill_adj_flag IS NULL)THEN

Line 2367: ELSIF (x_sel_rec.bill_adj_flag = Okc_Api.G_MISS_CHAR) THEN

2363: END IF;
2364: -- Added by rgooty: 4212626
2365: IF (x_sel_rec.bill_adj_flag IS NULL)THEN
2366: x_sel_rec.bill_adj_flag := l_sel_rec.bill_adj_flag;
2367: ELSIF (x_sel_rec.bill_adj_flag = Okc_Api.G_MISS_CHAR) THEN
2368: x_sel_rec.bill_adj_flag := NULL;
2369: END IF;
2370: IF (x_sel_rec.accrual_adj_flag IS NULL)THEN
2371: x_sel_rec.accrual_adj_flag := l_sel_rec.accrual_adj_flag;

Line 2372: ELSIF (x_sel_rec.accrual_adj_flag = Okc_Api.G_MISS_CHAR) THEN

2368: x_sel_rec.bill_adj_flag := NULL;
2369: END IF;
2370: IF (x_sel_rec.accrual_adj_flag IS NULL)THEN
2371: x_sel_rec.accrual_adj_flag := l_sel_rec.accrual_adj_flag;
2372: ELSIF (x_sel_rec.accrual_adj_flag = Okc_Api.G_MISS_CHAR) THEN
2373: x_sel_rec.accrual_adj_flag := NULL;
2374: END IF;
2375: -- Added by hkpatel for bug 4350255
2376: IF (x_sel_rec.date_disbursed IS NULL)THEN

Line 2378: ELSIF (x_sel_rec.date_disbursed = Okc_Api.G_MISS_DATE) THEN

2374: END IF;
2375: -- Added by hkpatel for bug 4350255
2376: IF (x_sel_rec.date_disbursed IS NULL)THEN
2377: x_sel_rec.date_disbursed := l_sel_rec.date_disbursed;
2378: ELSIF (x_sel_rec.date_disbursed = Okc_Api.G_MISS_DATE) THEN
2379: x_sel_rec.date_disbursed := NULL;
2380: END IF;
2381:
2382:

Line 2392: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

2388: FUNCTION Set_Attributes (
2389: p_sel_rec IN sel_rec_type,
2390: x_sel_rec OUT NOCOPY sel_rec_type
2391: ) RETURN VARCHAR2 IS
2392: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
2393: BEGIN
2394: x_sel_rec := p_sel_rec;
2395: RETURN(l_return_status);
2396: END Set_Attributes;

Line 2398: l_return_status := Okc_Api.START_ACTIVITY(l_api_name,

2394: x_sel_rec := p_sel_rec;
2395: RETURN(l_return_status);
2396: END Set_Attributes;
2397: BEGIN
2398: l_return_status := Okc_Api.START_ACTIVITY(l_api_name,
2399: p_init_msg_list,
2400: '_PVT',
2401: x_return_status);
2402: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

Line 2402: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

2398: l_return_status := Okc_Api.START_ACTIVITY(l_api_name,
2399: p_init_msg_list,
2400: '_PVT',
2401: x_return_status);
2402: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2403: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2404: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2405: RAISE Okc_Api.G_EXCEPTION_ERROR;
2406: END IF;

Line 2403: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

2399: p_init_msg_list,
2400: '_PVT',
2401: x_return_status);
2402: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2403: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2404: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2405: RAISE Okc_Api.G_EXCEPTION_ERROR;
2406: END IF;
2407: --- Setting item attributes

Line 2404: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN

2400: '_PVT',
2401: x_return_status);
2402: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2403: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2404: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2405: RAISE Okc_Api.G_EXCEPTION_ERROR;
2406: END IF;
2407: --- Setting item attributes
2408: l_return_status := Set_Attributes(

Line 2405: RAISE Okc_Api.G_EXCEPTION_ERROR;

2401: x_return_status);
2402: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2403: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2404: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2405: RAISE Okc_Api.G_EXCEPTION_ERROR;
2406: END IF;
2407: --- Setting item attributes
2408: l_return_status := Set_Attributes(
2409: p_sel_rec, -- IN

Line 2412: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

2408: l_return_status := Set_Attributes(
2409: p_sel_rec, -- IN
2410: l_sel_rec); -- OUT
2411: --- If any errors happen abort API
2412: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2413: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2414: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2415: RAISE Okc_Api.G_EXCEPTION_ERROR;
2416: END IF;

Line 2413: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

2409: p_sel_rec, -- IN
2410: l_sel_rec); -- OUT
2411: --- If any errors happen abort API
2412: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2413: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2414: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2415: RAISE Okc_Api.G_EXCEPTION_ERROR;
2416: END IF;
2417: l_return_status := populate_new_record(l_sel_rec, l_def_sel_rec);

Line 2414: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN

2410: l_sel_rec); -- OUT
2411: --- If any errors happen abort API
2412: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2413: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2414: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2415: RAISE Okc_Api.G_EXCEPTION_ERROR;
2416: END IF;
2417: l_return_status := populate_new_record(l_sel_rec, l_def_sel_rec);
2418: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

Line 2415: RAISE Okc_Api.G_EXCEPTION_ERROR;

2411: --- If any errors happen abort API
2412: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2413: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2414: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2415: RAISE Okc_Api.G_EXCEPTION_ERROR;
2416: END IF;
2417: l_return_status := populate_new_record(l_sel_rec, l_def_sel_rec);
2418: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2419: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

Line 2418: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

2414: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2415: RAISE Okc_Api.G_EXCEPTION_ERROR;
2416: END IF;
2417: l_return_status := populate_new_record(l_sel_rec, l_def_sel_rec);
2418: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2419: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2420: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2421: RAISE Okc_Api.G_EXCEPTION_ERROR;
2422: END IF;

Line 2419: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

2415: RAISE Okc_Api.G_EXCEPTION_ERROR;
2416: END IF;
2417: l_return_status := populate_new_record(l_sel_rec, l_def_sel_rec);
2418: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2419: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2420: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2421: RAISE Okc_Api.G_EXCEPTION_ERROR;
2422: END IF;
2423: UPDATE OKL_STRM_ELEMENTS

Line 2420: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN

2416: END IF;
2417: l_return_status := populate_new_record(l_sel_rec, l_def_sel_rec);
2418: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2419: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2420: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2421: RAISE Okc_Api.G_EXCEPTION_ERROR;
2422: END IF;
2423: UPDATE OKL_STRM_ELEMENTS
2424: SET STM_ID = l_def_sel_rec.stm_id,

Line 2421: RAISE Okc_Api.G_EXCEPTION_ERROR;

2417: l_return_status := populate_new_record(l_sel_rec, l_def_sel_rec);
2418: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2419: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2420: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2421: RAISE Okc_Api.G_EXCEPTION_ERROR;
2422: END IF;
2423: UPDATE OKL_STRM_ELEMENTS
2424: SET STM_ID = l_def_sel_rec.stm_id,
2425: OBJECT_VERSION_NUMBER = l_def_sel_rec.object_version_number,

Line 2453: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);

2449: DATE_DISBURSED = l_def_sel_rec.date_disbursed
2450: WHERE ID = l_def_sel_rec.id;
2451:
2452: x_sel_rec := l_def_sel_rec;
2453: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
2454: EXCEPTION
2455: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
2456: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
2457: (

Line 2455: WHEN Okc_Api.G_EXCEPTION_ERROR THEN

2451:
2452: x_sel_rec := l_def_sel_rec;
2453: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
2454: EXCEPTION
2455: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
2456: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
2457: (
2458: l_api_name,
2459: G_PKG_NAME,

Line 2456: x_return_status := Okc_Api.HANDLE_EXCEPTIONS

2452: x_sel_rec := l_def_sel_rec;
2453: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
2454: EXCEPTION
2455: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
2456: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
2457: (
2458: l_api_name,
2459: G_PKG_NAME,
2460: 'OKC_API.G_RET_STS_ERROR',

Line 2460: 'OKC_API.G_RET_STS_ERROR',

2456: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
2457: (
2458: l_api_name,
2459: G_PKG_NAME,
2460: 'OKC_API.G_RET_STS_ERROR',
2461: x_msg_count,
2462: x_msg_data,
2463: '_PVT'
2464: );

Line 2465: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

2461: x_msg_count,
2462: x_msg_data,
2463: '_PVT'
2464: );
2465: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
2466: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
2467: (
2468: l_api_name,
2469: G_PKG_NAME,

Line 2466: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS

2462: x_msg_data,
2463: '_PVT'
2464: );
2465: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
2466: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
2467: (
2468: l_api_name,
2469: G_PKG_NAME,
2470: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 2470: 'OKC_API.G_RET_STS_UNEXP_ERROR',

2466: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
2467: (
2468: l_api_name,
2469: G_PKG_NAME,
2470: 'OKC_API.G_RET_STS_UNEXP_ERROR',
2471: x_msg_count,
2472: x_msg_data,
2473: '_PVT'
2474: );

Line 2476: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS

2472: x_msg_data,
2473: '_PVT'
2474: );
2475: WHEN OTHERS THEN
2476: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
2477: (
2478: l_api_name,
2479: G_PKG_NAME,
2480: 'OTHERS',

Line 2491: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,

2487: -- update_row for:OKL_STRM_ELEMENTS_V --
2488: ----------------------------------------
2489: PROCEDURE update_row(
2490: p_api_version IN NUMBER,
2491: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
2492: x_return_status OUT NOCOPY VARCHAR2,
2493: x_msg_count OUT NOCOPY NUMBER,
2494: x_msg_data OUT NOCOPY VARCHAR2,
2495: p_selv_rec IN selv_rec_type,

Line 2500: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

2496: x_selv_rec OUT NOCOPY selv_rec_type) IS
2497:
2498: l_api_version CONSTANT NUMBER := 1;
2499: l_api_name CONSTANT VARCHAR2(30) := 'V_update_row';
2500: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
2501: l_selv_rec selv_rec_type := p_selv_rec;
2502: l_def_selv_rec selv_rec_type;
2503: l_sel_rec sel_rec_type;
2504: lx_sel_rec sel_rec_type;

Line 2527: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

2523: x_selv_rec OUT NOCOPY selv_rec_type
2524: ) RETURN VARCHAR2 IS
2525: l_selv_rec selv_rec_type;
2526: l_row_notfound BOOLEAN := TRUE;
2527: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
2528: BEGIN
2529: x_selv_rec := p_selv_rec;
2530: -- Get current database values
2531: l_selv_rec := get_rec(p_selv_rec, l_row_notfound);

Line 2533: l_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;

2529: x_selv_rec := p_selv_rec;
2530: -- Get current database values
2531: l_selv_rec := get_rec(p_selv_rec, l_row_notfound);
2532: IF (l_row_notfound) THEN
2533: l_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;
2534: END IF;
2535: IF (x_selv_rec.id IS NULL)THEN
2536: x_selv_rec.id := l_selv_rec.id;
2537: ELSIF (x_selv_rec.id = Okc_Api.G_MISS_NUM) THEN

Line 2537: ELSIF (x_selv_rec.id = Okc_Api.G_MISS_NUM) THEN

2533: l_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;
2534: END IF;
2535: IF (x_selv_rec.id IS NULL)THEN
2536: x_selv_rec.id := l_selv_rec.id;
2537: ELSIF (x_selv_rec.id = Okc_Api.G_MISS_NUM) THEN
2538: x_selv_rec.id := NULL;
2539: END IF;
2540: IF (x_selv_rec.object_version_number IS NULL)THEN
2541: x_selv_rec.object_version_number := l_selv_rec.object_version_number;

Line 2542: ELSIF (x_selv_rec.object_version_number = Okc_Api.G_MISS_NUM ) THEN

2538: x_selv_rec.id := NULL;
2539: END IF;
2540: IF (x_selv_rec.object_version_number IS NULL)THEN
2541: x_selv_rec.object_version_number := l_selv_rec.object_version_number;
2542: ELSIF (x_selv_rec.object_version_number = Okc_Api.G_MISS_NUM ) THEN
2543: x_selv_rec.object_version_number := NULL;
2544: END IF;
2545: IF (x_selv_rec.stm_id IS NULL)THEN
2546: x_selv_rec.stm_id := l_selv_rec.stm_id;

Line 2547: ELSIF (x_selv_rec.stm_id = Okc_Api.G_MISS_NUM) THEN

2543: x_selv_rec.object_version_number := NULL;
2544: END IF;
2545: IF (x_selv_rec.stm_id IS NULL)THEN
2546: x_selv_rec.stm_id := l_selv_rec.stm_id;
2547: ELSIF (x_selv_rec.stm_id = Okc_Api.G_MISS_NUM) THEN
2548: x_selv_rec.stm_id := NULL;
2549: END IF;
2550: IF (x_selv_rec.amount IS NULL)THEN
2551: x_selv_rec.amount := l_selv_rec.amount;

Line 2552: ELSIF (x_selv_rec.amount = Okc_Api.G_MISS_NUM) THEN

2548: x_selv_rec.stm_id := NULL;
2549: END IF;
2550: IF (x_selv_rec.amount IS NULL)THEN
2551: x_selv_rec.amount := l_selv_rec.amount;
2552: ELSIF (x_selv_rec.amount = Okc_Api.G_MISS_NUM) THEN
2553: x_selv_rec.amount := NULL;
2554: END IF;
2555: IF (x_selv_rec.comments IS NULL)THEN
2556: x_selv_rec.comments := l_selv_rec.comments;

Line 2557: ELSIF (x_selv_rec.comments = Okc_Api.G_MISS_CHAR) THEN

2553: x_selv_rec.amount := NULL;
2554: END IF;
2555: IF (x_selv_rec.comments IS NULL)THEN
2556: x_selv_rec.comments := l_selv_rec.comments;
2557: ELSIF (x_selv_rec.comments = Okc_Api.G_MISS_CHAR) THEN
2558: x_selv_rec.comments := NULL ;
2559: END IF;
2560: IF (x_selv_rec.accrued_yn IS NULL) THEN
2561: x_selv_rec.accrued_yn := l_selv_rec.accrued_yn;

Line 2562: ELSIF (x_selv_rec.accrued_yn = Okc_Api.G_MISS_CHAR) THEN

2558: x_selv_rec.comments := NULL ;
2559: END IF;
2560: IF (x_selv_rec.accrued_yn IS NULL) THEN
2561: x_selv_rec.accrued_yn := l_selv_rec.accrued_yn;
2562: ELSIF (x_selv_rec.accrued_yn = Okc_Api.G_MISS_CHAR) THEN
2563: x_selv_rec.accrued_yn := NULL;
2564: END IF;
2565: IF (x_selv_rec.stream_element_date IS NULL)THEN
2566: x_selv_rec.stream_element_date := l_selv_rec.stream_element_date;

Line 2567: ELSIF (x_selv_rec.stream_element_date = Okc_Api.G_MISS_DATE) THEN

2563: x_selv_rec.accrued_yn := NULL;
2564: END IF;
2565: IF (x_selv_rec.stream_element_date IS NULL)THEN
2566: x_selv_rec.stream_element_date := l_selv_rec.stream_element_date;
2567: ELSIF (x_selv_rec.stream_element_date = Okc_Api.G_MISS_DATE) THEN
2568: x_selv_rec.stream_element_date := NULL;
2569: END IF;
2570: IF (x_selv_rec.program_id IS NULL) THEN
2571: x_selv_rec.program_id := l_selv_rec.program_id;

Line 2572: ELSIF (x_selv_rec.program_id = Okc_Api.G_MISS_NUM) THEN

2568: x_selv_rec.stream_element_date := NULL;
2569: END IF;
2570: IF (x_selv_rec.program_id IS NULL) THEN
2571: x_selv_rec.program_id := l_selv_rec.program_id;
2572: ELSIF (x_selv_rec.program_id = Okc_Api.G_MISS_NUM) THEN
2573: x_selv_rec.program_id := NULL;
2574: END IF;
2575: IF (x_selv_rec.request_id IS NULL)THEN
2576: x_selv_rec.request_id := l_selv_rec.request_id;

Line 2577: ELSIF (x_selv_rec.request_id = Okc_Api.G_MISS_NUM) THEN

2573: x_selv_rec.program_id := NULL;
2574: END IF;
2575: IF (x_selv_rec.request_id IS NULL)THEN
2576: x_selv_rec.request_id := l_selv_rec.request_id;
2577: ELSIF (x_selv_rec.request_id = Okc_Api.G_MISS_NUM) THEN
2578: x_selv_rec.request_id := NULL;
2579: END IF;
2580: IF (x_selv_rec.program_application_id IS NULL)THEN
2581: x_selv_rec.program_application_id := l_selv_rec.program_application_id;

Line 2582: ELSIF (x_selv_rec.program_application_id = Okc_Api.G_MISS_NUM) THEN

2578: x_selv_rec.request_id := NULL;
2579: END IF;
2580: IF (x_selv_rec.program_application_id IS NULL)THEN
2581: x_selv_rec.program_application_id := l_selv_rec.program_application_id;
2582: ELSIF (x_selv_rec.program_application_id = Okc_Api.G_MISS_NUM) THEN
2583: x_selv_rec.program_application_id := NULL;
2584: END IF;
2585: IF (x_selv_rec.program_update_date IS NULL)THEN
2586: x_selv_rec.program_update_date := l_selv_rec.program_update_date;

Line 2587: ELSIF (x_selv_rec.program_update_date = Okc_Api.G_MISS_DATE)THEN

2583: x_selv_rec.program_application_id := NULL;
2584: END IF;
2585: IF (x_selv_rec.program_update_date IS NULL)THEN
2586: x_selv_rec.program_update_date := l_selv_rec.program_update_date;
2587: ELSIF (x_selv_rec.program_update_date = Okc_Api.G_MISS_DATE)THEN
2588: x_selv_rec.program_update_date := NULL;
2589: END IF;
2590: IF (x_selv_rec.se_line_number IS NULL)THEN
2591: x_selv_rec.se_line_number := l_selv_rec.se_line_number;

Line 2592: ELSIF (x_selv_rec.se_line_number = Okc_Api.G_MISS_NUM) THEN

2588: x_selv_rec.program_update_date := NULL;
2589: END IF;
2590: IF (x_selv_rec.se_line_number IS NULL)THEN
2591: x_selv_rec.se_line_number := l_selv_rec.se_line_number;
2592: ELSIF (x_selv_rec.se_line_number = Okc_Api.G_MISS_NUM) THEN
2593: x_selv_rec.se_line_number := NULL;
2594: END IF;
2595: IF (x_selv_rec.date_billed IS NULL)THEN
2596: x_selv_rec.date_billed := l_selv_rec.date_billed;

Line 2597: ELSIF (x_selv_rec.date_billed = Okc_Api.G_MISS_DATE) THEN

2593: x_selv_rec.se_line_number := NULL;
2594: END IF;
2595: IF (x_selv_rec.date_billed IS NULL)THEN
2596: x_selv_rec.date_billed := l_selv_rec.date_billed;
2597: ELSIF (x_selv_rec.date_billed = Okc_Api.G_MISS_DATE) THEN
2598: x_selv_rec.date_billed := NULL;
2599: END IF;
2600: IF (x_selv_rec.created_by IS NULL)THEN
2601: x_selv_rec.created_by := l_selv_rec.created_by;

Line 2602: ELSIF (x_selv_rec.created_by = Okc_Api.G_MISS_NUM) THEN

2598: x_selv_rec.date_billed := NULL;
2599: END IF;
2600: IF (x_selv_rec.created_by IS NULL)THEN
2601: x_selv_rec.created_by := l_selv_rec.created_by;
2602: ELSIF (x_selv_rec.created_by = Okc_Api.G_MISS_NUM) THEN
2603: x_selv_rec.created_by := NULL;
2604: END IF;
2605: IF (x_selv_rec.creation_date IS NULL)THEN
2606: x_selv_rec.creation_date := l_selv_rec.creation_date;

Line 2607: ELSIF (x_selv_rec.creation_date = Okc_Api.G_MISS_DATE) THEN

2603: x_selv_rec.created_by := NULL;
2604: END IF;
2605: IF (x_selv_rec.creation_date IS NULL)THEN
2606: x_selv_rec.creation_date := l_selv_rec.creation_date;
2607: ELSIF (x_selv_rec.creation_date = Okc_Api.G_MISS_DATE) THEN
2608: x_selv_rec.creation_date := NULL;
2609: END IF;
2610: IF (x_selv_rec.last_updated_by IS NULL)THEN
2611: x_selv_rec.last_updated_by := l_selv_rec.last_updated_by;

Line 2612: ELSIF (x_selv_rec.last_updated_by = Okc_Api.G_MISS_NUM) THEN

2608: x_selv_rec.creation_date := NULL;
2609: END IF;
2610: IF (x_selv_rec.last_updated_by IS NULL)THEN
2611: x_selv_rec.last_updated_by := l_selv_rec.last_updated_by;
2612: ELSIF (x_selv_rec.last_updated_by = Okc_Api.G_MISS_NUM) THEN
2613: x_selv_rec.last_updated_by := NULL;
2614: END IF;
2615: IF (x_selv_rec.last_update_date IS NULL)THEN
2616: x_selv_rec.last_update_date := l_selv_rec.last_update_date;

Line 2617: ELSIF (x_selv_rec.last_update_date = Okc_Api.G_MISS_DATE) THEN

2613: x_selv_rec.last_updated_by := NULL;
2614: END IF;
2615: IF (x_selv_rec.last_update_date IS NULL)THEN
2616: x_selv_rec.last_update_date := l_selv_rec.last_update_date;
2617: ELSIF (x_selv_rec.last_update_date = Okc_Api.G_MISS_DATE) THEN
2618: x_selv_rec.last_update_date := NULL;
2619: END IF;
2620: IF (x_selv_rec.last_update_login IS NULL)THEN
2621: x_selv_rec.last_update_login := l_selv_rec.last_update_login;

Line 2622: ELSIF (x_selv_rec.last_update_login = Okc_Api.G_MISS_NUM) THEN

2618: x_selv_rec.last_update_date := NULL;
2619: END IF;
2620: IF (x_selv_rec.last_update_login IS NULL)THEN
2621: x_selv_rec.last_update_login := l_selv_rec.last_update_login;
2622: ELSIF (x_selv_rec.last_update_login = Okc_Api.G_MISS_NUM) THEN
2623: x_selv_rec.last_update_login := NULL;
2624: END IF;
2625: IF (x_selv_rec.sel_id IS NULL)THEN
2626: x_selv_rec.sel_id := l_selv_rec.sel_id;

Line 2627: ELSIF (x_selv_rec.sel_id = Okc_Api.G_MISS_NUM) THEN

2623: x_selv_rec.last_update_login := NULL;
2624: END IF;
2625: IF (x_selv_rec.sel_id IS NULL)THEN
2626: x_selv_rec.sel_id := l_selv_rec.sel_id;
2627: ELSIF (x_selv_rec.sel_id = Okc_Api.G_MISS_NUM) THEN
2628: x_selv_rec.sel_id := NULL;
2629: END IF;
2630: -- Added by Keerthi 15-Sep-2003
2631: IF (x_selv_rec.source_id IS NULL)THEN

Line 2633: ELSIF (x_selv_rec.source_id = Okc_Api.G_MISS_NUM) THEN

2629: END IF;
2630: -- Added by Keerthi 15-Sep-2003
2631: IF (x_selv_rec.source_id IS NULL)THEN
2632: x_selv_rec.source_id := l_selv_rec.source_id;
2633: ELSIF (x_selv_rec.source_id = Okc_Api.G_MISS_NUM) THEN
2634: x_selv_rec.source_id := NULL;
2635: END IF;
2636: IF (x_selv_rec.source_table IS NULL) THEN
2637: x_selv_rec.source_table := l_selv_rec.source_table;

Line 2638: ELSIF (x_selv_rec.source_table = Okc_Api.G_MISS_CHAR) THEN

2634: x_selv_rec.source_id := NULL;
2635: END IF;
2636: IF (x_selv_rec.source_table IS NULL) THEN
2637: x_selv_rec.source_table := l_selv_rec.source_table;
2638: ELSIF (x_selv_rec.source_table = Okc_Api.G_MISS_CHAR) THEN
2639: x_selv_rec.source_table := NULL;
2640: END IF;
2641: -- Added by rgooty: 4212626
2642: IF (x_selv_rec.bill_adj_flag IS NULL) THEN

Line 2644: ELSIF (x_selv_rec.bill_adj_flag = Okc_Api.G_MISS_CHAR) THEN

2640: END IF;
2641: -- Added by rgooty: 4212626
2642: IF (x_selv_rec.bill_adj_flag IS NULL) THEN
2643: x_selv_rec.bill_adj_flag := l_selv_rec.bill_adj_flag;
2644: ELSIF (x_selv_rec.bill_adj_flag = Okc_Api.G_MISS_CHAR) THEN
2645: x_selv_rec.bill_adj_flag := NULL;
2646: END IF;
2647: IF (x_selv_rec.accrual_adj_flag IS NULL) THEN
2648: x_selv_rec.accrual_adj_flag := l_selv_rec.accrual_adj_flag;

Line 2649: ELSIF (x_selv_rec.accrual_adj_flag = Okc_Api.G_MISS_CHAR) THEN

2645: x_selv_rec.bill_adj_flag := NULL;
2646: END IF;
2647: IF (x_selv_rec.accrual_adj_flag IS NULL) THEN
2648: x_selv_rec.accrual_adj_flag := l_selv_rec.accrual_adj_flag;
2649: ELSIF (x_selv_rec.accrual_adj_flag = Okc_Api.G_MISS_CHAR) THEN
2650: x_selv_rec.accrual_adj_flag := NULL;
2651: END IF;
2652: -- Added by hkpatel for bug 4350255
2653: IF (x_selv_rec.date_billed IS NULL)THEN

Line 2655: ELSIF (x_selv_rec.date_billed = Okc_Api.G_MISS_DATE) THEN

2651: END IF;
2652: -- Added by hkpatel for bug 4350255
2653: IF (x_selv_rec.date_billed IS NULL)THEN
2654: x_selv_rec.date_billed := l_selv_rec.date_billed;
2655: ELSIF (x_selv_rec.date_billed = Okc_Api.G_MISS_DATE) THEN
2656: x_selv_rec.date_billed := NULL;
2657: END IF;
2658:
2659:

Line 2686: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

2682: FUNCTION Set_Attributes (
2683: p_selv_rec IN selv_rec_type,
2684: x_selv_rec OUT NOCOPY selv_rec_type
2685: ) RETURN VARCHAR2 IS
2686: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
2687: BEGIN
2688: x_selv_rec := p_selv_rec;
2689: x_selv_rec.OBJECT_VERSION_NUMBER := NVL(x_selv_rec.OBJECT_VERSION_NUMBER, 0) + 1;
2690: RETURN(l_return_status);

Line 2693: l_return_status := Okc_Api.START_ACTIVITY(l_api_name,

2689: x_selv_rec.OBJECT_VERSION_NUMBER := NVL(x_selv_rec.OBJECT_VERSION_NUMBER, 0) + 1;
2690: RETURN(l_return_status);
2691: END Set_Attributes;
2692: BEGIN
2693: l_return_status := Okc_Api.START_ACTIVITY(l_api_name,
2694: G_PKG_NAME,
2695: p_init_msg_list,
2696: l_api_version,
2697: p_api_version,

Line 2700: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

2696: l_api_version,
2697: p_api_version,
2698: '_PVT',
2699: x_return_status);
2700: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2701: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2702: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2703: RAISE Okc_Api.G_EXCEPTION_ERROR;
2704: END IF;

Line 2701: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

2697: p_api_version,
2698: '_PVT',
2699: x_return_status);
2700: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2701: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2702: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2703: RAISE Okc_Api.G_EXCEPTION_ERROR;
2704: END IF;
2705: --- Setting item attributes

Line 2702: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN

2698: '_PVT',
2699: x_return_status);
2700: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2701: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2702: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2703: RAISE Okc_Api.G_EXCEPTION_ERROR;
2704: END IF;
2705: --- Setting item attributes
2706: l_return_status := Set_Attributes(

Line 2703: RAISE Okc_Api.G_EXCEPTION_ERROR;

2699: x_return_status);
2700: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2701: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2702: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2703: RAISE Okc_Api.G_EXCEPTION_ERROR;
2704: END IF;
2705: --- Setting item attributes
2706: l_return_status := Set_Attributes(
2707: p_selv_rec, -- IN

Line 2710: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

2706: l_return_status := Set_Attributes(
2707: p_selv_rec, -- IN
2708: l_selv_rec); -- OUT
2709: --- If any errors happen abort API
2710: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2711: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2712: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2713: RAISE Okc_Api.G_EXCEPTION_ERROR;
2714: END IF;

Line 2711: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

2707: p_selv_rec, -- IN
2708: l_selv_rec); -- OUT
2709: --- If any errors happen abort API
2710: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2711: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2712: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2713: RAISE Okc_Api.G_EXCEPTION_ERROR;
2714: END IF;
2715: l_return_status := populate_new_record(l_selv_rec, l_def_selv_rec);

Line 2712: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN

2708: l_selv_rec); -- OUT
2709: --- If any errors happen abort API
2710: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2711: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2712: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2713: RAISE Okc_Api.G_EXCEPTION_ERROR;
2714: END IF;
2715: l_return_status := populate_new_record(l_selv_rec, l_def_selv_rec);
2716: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

Line 2713: RAISE Okc_Api.G_EXCEPTION_ERROR;

2709: --- If any errors happen abort API
2710: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2711: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2712: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2713: RAISE Okc_Api.G_EXCEPTION_ERROR;
2714: END IF;
2715: l_return_status := populate_new_record(l_selv_rec, l_def_selv_rec);
2716: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2717: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

Line 2716: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

2712: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2713: RAISE Okc_Api.G_EXCEPTION_ERROR;
2714: END IF;
2715: l_return_status := populate_new_record(l_selv_rec, l_def_selv_rec);
2716: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2717: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2718: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2719: RAISE Okc_Api.G_EXCEPTION_ERROR;
2720: END IF;

Line 2717: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

2713: RAISE Okc_Api.G_EXCEPTION_ERROR;
2714: END IF;
2715: l_return_status := populate_new_record(l_selv_rec, l_def_selv_rec);
2716: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2717: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2718: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2719: RAISE Okc_Api.G_EXCEPTION_ERROR;
2720: END IF;
2721: l_def_selv_rec := fill_who_columns(l_def_selv_rec);

Line 2718: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN

2714: END IF;
2715: l_return_status := populate_new_record(l_selv_rec, l_def_selv_rec);
2716: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2717: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2718: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2719: RAISE Okc_Api.G_EXCEPTION_ERROR;
2720: END IF;
2721: l_def_selv_rec := fill_who_columns(l_def_selv_rec);
2722: --- Validate all non-missing attributes (Item Level Validation)

Line 2719: RAISE Okc_Api.G_EXCEPTION_ERROR;

2715: l_return_status := populate_new_record(l_selv_rec, l_def_selv_rec);
2716: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2717: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2718: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2719: RAISE Okc_Api.G_EXCEPTION_ERROR;
2720: END IF;
2721: l_def_selv_rec := fill_who_columns(l_def_selv_rec);
2722: --- Validate all non-missing attributes (Item Level Validation)
2723: l_return_status := Validate_Attributes(l_def_selv_rec);

Line 2725: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

2721: l_def_selv_rec := fill_who_columns(l_def_selv_rec);
2722: --- Validate all non-missing attributes (Item Level Validation)
2723: l_return_status := Validate_Attributes(l_def_selv_rec);
2724: --- If any errors happen abort API
2725: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2726: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2727: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2728: RAISE Okc_Api.G_EXCEPTION_ERROR;
2729: END IF;

Line 2726: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

2722: --- Validate all non-missing attributes (Item Level Validation)
2723: l_return_status := Validate_Attributes(l_def_selv_rec);
2724: --- If any errors happen abort API
2725: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2726: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2727: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2728: RAISE Okc_Api.G_EXCEPTION_ERROR;
2729: END IF;
2730: l_return_status := Validate_Record(l_def_selv_rec);

Line 2727: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN

2723: l_return_status := Validate_Attributes(l_def_selv_rec);
2724: --- If any errors happen abort API
2725: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2726: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2727: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2728: RAISE Okc_Api.G_EXCEPTION_ERROR;
2729: END IF;
2730: l_return_status := Validate_Record(l_def_selv_rec);
2731: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

Line 2728: RAISE Okc_Api.G_EXCEPTION_ERROR;

2724: --- If any errors happen abort API
2725: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2726: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2727: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2728: RAISE Okc_Api.G_EXCEPTION_ERROR;
2729: END IF;
2730: l_return_status := Validate_Record(l_def_selv_rec);
2731: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2732: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

Line 2731: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

2727: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2728: RAISE Okc_Api.G_EXCEPTION_ERROR;
2729: END IF;
2730: l_return_status := Validate_Record(l_def_selv_rec);
2731: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2732: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2733: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2734: RAISE Okc_Api.G_EXCEPTION_ERROR;
2735: END IF;

Line 2732: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

2728: RAISE Okc_Api.G_EXCEPTION_ERROR;
2729: END IF;
2730: l_return_status := Validate_Record(l_def_selv_rec);
2731: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2732: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2733: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2734: RAISE Okc_Api.G_EXCEPTION_ERROR;
2735: END IF;
2736:

Line 2733: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN

2729: END IF;
2730: l_return_status := Validate_Record(l_def_selv_rec);
2731: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2732: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2733: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2734: RAISE Okc_Api.G_EXCEPTION_ERROR;
2735: END IF;
2736:
2737: --------------------------------------

Line 2734: RAISE Okc_Api.G_EXCEPTION_ERROR;

2730: l_return_status := Validate_Record(l_def_selv_rec);
2731: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2732: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2733: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2734: RAISE Okc_Api.G_EXCEPTION_ERROR;
2735: END IF;
2736:
2737: --------------------------------------
2738: -- Move VIEW record to "Child" records

Line 2752: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

2748: x_msg_data,
2749: l_sel_rec,
2750: lx_sel_rec
2751: );
2752: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2753: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2754: ELSIF (x_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2755: RAISE Okc_Api.G_EXCEPTION_ERROR;
2756: END IF;

Line 2753: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

2749: l_sel_rec,
2750: lx_sel_rec
2751: );
2752: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2753: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2754: ELSIF (x_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2755: RAISE Okc_Api.G_EXCEPTION_ERROR;
2756: END IF;
2757: migrate(lx_sel_rec, l_def_selv_rec);

Line 2754: ELSIF (x_return_status = Okc_Api.G_RET_STS_ERROR) THEN

2750: lx_sel_rec
2751: );
2752: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2753: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2754: ELSIF (x_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2755: RAISE Okc_Api.G_EXCEPTION_ERROR;
2756: END IF;
2757: migrate(lx_sel_rec, l_def_selv_rec);
2758: x_selv_rec := l_def_selv_rec;

Line 2755: RAISE Okc_Api.G_EXCEPTION_ERROR;

2751: );
2752: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2753: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2754: ELSIF (x_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2755: RAISE Okc_Api.G_EXCEPTION_ERROR;
2756: END IF;
2757: migrate(lx_sel_rec, l_def_selv_rec);
2758: x_selv_rec := l_def_selv_rec;
2759: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);

Line 2759: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);

2755: RAISE Okc_Api.G_EXCEPTION_ERROR;
2756: END IF;
2757: migrate(lx_sel_rec, l_def_selv_rec);
2758: x_selv_rec := l_def_selv_rec;
2759: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
2760: EXCEPTION
2761: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
2762: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
2763: (

Line 2761: WHEN Okc_Api.G_EXCEPTION_ERROR THEN

2757: migrate(lx_sel_rec, l_def_selv_rec);
2758: x_selv_rec := l_def_selv_rec;
2759: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
2760: EXCEPTION
2761: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
2762: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
2763: (
2764: l_api_name,
2765: G_PKG_NAME,

Line 2762: x_return_status := Okc_Api.HANDLE_EXCEPTIONS

2758: x_selv_rec := l_def_selv_rec;
2759: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
2760: EXCEPTION
2761: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
2762: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
2763: (
2764: l_api_name,
2765: G_PKG_NAME,
2766: 'OKC_API.G_RET_STS_ERROR',

Line 2766: 'OKC_API.G_RET_STS_ERROR',

2762: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
2763: (
2764: l_api_name,
2765: G_PKG_NAME,
2766: 'OKC_API.G_RET_STS_ERROR',
2767: x_msg_count,
2768: x_msg_data,
2769: '_PVT'
2770: );

Line 2771: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

2767: x_msg_count,
2768: x_msg_data,
2769: '_PVT'
2770: );
2771: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
2772: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
2773: (
2774: l_api_name,
2775: G_PKG_NAME,

Line 2772: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS

2768: x_msg_data,
2769: '_PVT'
2770: );
2771: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
2772: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
2773: (
2774: l_api_name,
2775: G_PKG_NAME,
2776: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 2776: 'OKC_API.G_RET_STS_UNEXP_ERROR',

2772: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
2773: (
2774: l_api_name,
2775: G_PKG_NAME,
2776: 'OKC_API.G_RET_STS_UNEXP_ERROR',
2777: x_msg_count,
2778: x_msg_data,
2779: '_PVT'
2780: );

Line 2782: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS

2778: x_msg_data,
2779: '_PVT'
2780: );
2781: WHEN OTHERS THEN
2782: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
2783: (
2784: l_api_name,
2785: G_PKG_NAME,
2786: 'OTHERS',

Line 2797: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,

2793: -- PL/SQL TBL update_row for:SELV_TBL --
2794: ----------------------------------------
2795: PROCEDURE update_row(
2796: p_api_version IN NUMBER,
2797: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
2798: x_return_status OUT NOCOPY VARCHAR2,
2799: x_msg_count OUT NOCOPY NUMBER,
2800: x_msg_data OUT NOCOPY VARCHAR2,
2801: p_selv_tbl IN selv_tbl_type,

Line 2806: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

2802: x_selv_tbl OUT NOCOPY selv_tbl_type) IS
2803:
2804: l_api_version CONSTANT NUMBER := 1;
2805: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_update_row';
2806: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
2807: i NUMBER := 0;
2808: -- START change : akjain, 05/15/2001
2809: -- Adding OverAll Status Flag
2810: l_overall_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

Line 2810: l_overall_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

2806: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
2807: i NUMBER := 0;
2808: -- START change : akjain, 05/15/2001
2809: -- Adding OverAll Status Flag
2810: l_overall_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
2811: -- END change : akjain
2812:
2813:
2814: BEGIN

Line 2815: Okc_Api.init_msg_list(p_init_msg_list);

2811: -- END change : akjain
2812:
2813:
2814: BEGIN
2815: Okc_Api.init_msg_list(p_init_msg_list);
2816: -- Make sure PL/SQL table has records in it before passing
2817: IF (p_selv_tbl.COUNT > 0) THEN
2818: i := p_selv_tbl.FIRST;
2819: LOOP

Line 2822: p_init_msg_list => Okc_Api.G_FALSE,

2818: i := p_selv_tbl.FIRST;
2819: LOOP
2820: update_row (
2821: p_api_version => p_api_version,
2822: p_init_msg_list => Okc_Api.G_FALSE,
2823: x_return_status => x_return_status,
2824: x_msg_count => x_msg_count,
2825: x_msg_data => x_msg_data,
2826: p_selv_rec => p_selv_tbl(i),

Line 2830: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS THEN

2826: p_selv_rec => p_selv_tbl(i),
2827: x_selv_rec => x_selv_tbl(i));
2828: -- START change : akjain, 05/15/2001
2829: -- store the highest degree of error
2830: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS THEN
2831: IF l_overall_status <> Okc_Api.G_RET_STS_UNEXP_ERROR THEN
2832: l_overall_status := x_return_status;
2833: END IF;
2834: END IF;

Line 2831: IF l_overall_status <> Okc_Api.G_RET_STS_UNEXP_ERROR THEN

2827: x_selv_rec => x_selv_tbl(i));
2828: -- START change : akjain, 05/15/2001
2829: -- store the highest degree of error
2830: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS THEN
2831: IF l_overall_status <> Okc_Api.G_RET_STS_UNEXP_ERROR THEN
2832: l_overall_status := x_return_status;
2833: END IF;
2834: END IF;
2835: -- END change : akjain

Line 2847: WHEN Okc_Api.G_EXCEPTION_ERROR THEN

2843: x_return_status := l_overall_status;
2844: -- END change : akjain
2845: END IF;
2846: EXCEPTION
2847: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
2848: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
2849: (
2850: l_api_name,
2851: G_PKG_NAME,

Line 2848: x_return_status := Okc_Api.HANDLE_EXCEPTIONS

2844: -- END change : akjain
2845: END IF;
2846: EXCEPTION
2847: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
2848: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
2849: (
2850: l_api_name,
2851: G_PKG_NAME,
2852: 'OKC_API.G_RET_STS_ERROR',

Line 2852: 'OKC_API.G_RET_STS_ERROR',

2848: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
2849: (
2850: l_api_name,
2851: G_PKG_NAME,
2852: 'OKC_API.G_RET_STS_ERROR',
2853: x_msg_count,
2854: x_msg_data,
2855: '_PVT'
2856: );

Line 2857: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

2853: x_msg_count,
2854: x_msg_data,
2855: '_PVT'
2856: );
2857: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
2858: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
2859: (
2860: l_api_name,
2861: G_PKG_NAME,

Line 2858: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS

2854: x_msg_data,
2855: '_PVT'
2856: );
2857: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
2858: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
2859: (
2860: l_api_name,
2861: G_PKG_NAME,
2862: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 2862: 'OKC_API.G_RET_STS_UNEXP_ERROR',

2858: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
2859: (
2860: l_api_name,
2861: G_PKG_NAME,
2862: 'OKC_API.G_RET_STS_UNEXP_ERROR',
2863: x_msg_count,
2864: x_msg_data,
2865: '_PVT'
2866: );

Line 2868: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS

2864: x_msg_data,
2865: '_PVT'
2866: );
2867: WHEN OTHERS THEN
2868: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
2869: (
2870: l_api_name,
2871: G_PKG_NAME,
2872: 'OTHERS',

Line 2886: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,

2882: --------------------------------------
2883: -- delete_row for:OKL_STRM_ELEMENTS --
2884: --------------------------------------
2885: PROCEDURE delete_row(
2886: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
2887: x_return_status OUT NOCOPY VARCHAR2,
2888: x_msg_count OUT NOCOPY NUMBER,
2889: x_msg_data OUT NOCOPY VARCHAR2,
2890: p_sel_rec IN sel_rec_type) IS

Line 2894: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

2890: p_sel_rec IN sel_rec_type) IS
2891:
2892: l_api_version CONSTANT NUMBER := 1;
2893: l_api_name CONSTANT VARCHAR2(30) := 'ELEMENTS_delete_row';
2894: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
2895: l_sel_rec sel_rec_type:= p_sel_rec;
2896: l_row_notfound BOOLEAN := TRUE;
2897: BEGIN
2898: l_return_status := Okc_Api.START_ACTIVITY(l_api_name,

Line 2898: l_return_status := Okc_Api.START_ACTIVITY(l_api_name,

2894: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
2895: l_sel_rec sel_rec_type:= p_sel_rec;
2896: l_row_notfound BOOLEAN := TRUE;
2897: BEGIN
2898: l_return_status := Okc_Api.START_ACTIVITY(l_api_name,
2899: p_init_msg_list,
2900: '_PVT',
2901: x_return_status);
2902: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

Line 2902: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

2898: l_return_status := Okc_Api.START_ACTIVITY(l_api_name,
2899: p_init_msg_list,
2900: '_PVT',
2901: x_return_status);
2902: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2903: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2904: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2905: RAISE Okc_Api.G_EXCEPTION_ERROR;
2906: END IF;

Line 2903: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

2899: p_init_msg_list,
2900: '_PVT',
2901: x_return_status);
2902: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2903: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2904: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2905: RAISE Okc_Api.G_EXCEPTION_ERROR;
2906: END IF;
2907: DELETE FROM OKL_STRM_ELEMENTS

Line 2904: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN

2900: '_PVT',
2901: x_return_status);
2902: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2903: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2904: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2905: RAISE Okc_Api.G_EXCEPTION_ERROR;
2906: END IF;
2907: DELETE FROM OKL_STRM_ELEMENTS
2908: WHERE ID = l_sel_rec.id;

Line 2905: RAISE Okc_Api.G_EXCEPTION_ERROR;

2901: x_return_status);
2902: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2903: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2904: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2905: RAISE Okc_Api.G_EXCEPTION_ERROR;
2906: END IF;
2907: DELETE FROM OKL_STRM_ELEMENTS
2908: WHERE ID = l_sel_rec.id;
2909:

Line 2910: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);

2906: END IF;
2907: DELETE FROM OKL_STRM_ELEMENTS
2908: WHERE ID = l_sel_rec.id;
2909:
2910: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
2911: EXCEPTION
2912: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
2913: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
2914: (

Line 2912: WHEN Okc_Api.G_EXCEPTION_ERROR THEN

2908: WHERE ID = l_sel_rec.id;
2909:
2910: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
2911: EXCEPTION
2912: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
2913: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
2914: (
2915: l_api_name,
2916: G_PKG_NAME,

Line 2913: x_return_status := Okc_Api.HANDLE_EXCEPTIONS

2909:
2910: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
2911: EXCEPTION
2912: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
2913: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
2914: (
2915: l_api_name,
2916: G_PKG_NAME,
2917: 'OKC_API.G_RET_STS_ERROR',

Line 2917: 'OKC_API.G_RET_STS_ERROR',

2913: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
2914: (
2915: l_api_name,
2916: G_PKG_NAME,
2917: 'OKC_API.G_RET_STS_ERROR',
2918: x_msg_count,
2919: x_msg_data,
2920: '_PVT'
2921: );

Line 2922: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

2918: x_msg_count,
2919: x_msg_data,
2920: '_PVT'
2921: );
2922: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
2923: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
2924: (
2925: l_api_name,
2926: G_PKG_NAME,

Line 2923: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS

2919: x_msg_data,
2920: '_PVT'
2921: );
2922: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
2923: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
2924: (
2925: l_api_name,
2926: G_PKG_NAME,
2927: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 2927: 'OKC_API.G_RET_STS_UNEXP_ERROR',

2923: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
2924: (
2925: l_api_name,
2926: G_PKG_NAME,
2927: 'OKC_API.G_RET_STS_UNEXP_ERROR',
2928: x_msg_count,
2929: x_msg_data,
2930: '_PVT'
2931: );

Line 2933: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS

2929: x_msg_data,
2930: '_PVT'
2931: );
2932: WHEN OTHERS THEN
2933: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
2934: (
2935: l_api_name,
2936: G_PKG_NAME,
2937: 'OTHERS',

Line 2948: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,

2944: -- delete_row for:OKL_STRM_ELEMENTS_V --
2945: ----------------------------------------
2946: PROCEDURE delete_row(
2947: p_api_version IN NUMBER,
2948: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
2949: x_return_status OUT NOCOPY VARCHAR2,
2950: x_msg_count OUT NOCOPY NUMBER,
2951: x_msg_data OUT NOCOPY VARCHAR2,
2952: p_selv_rec IN selv_rec_type) IS

Line 2956: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

2952: p_selv_rec IN selv_rec_type) IS
2953:
2954: l_api_version CONSTANT NUMBER := 1;
2955: l_api_name CONSTANT VARCHAR2(30) := 'V_delete_row';
2956: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
2957: l_selv_rec selv_rec_type := p_selv_rec;
2958: l_sel_rec sel_rec_type;
2959: BEGIN
2960: l_return_status := Okc_Api.START_ACTIVITY(l_api_name,

Line 2960: l_return_status := Okc_Api.START_ACTIVITY(l_api_name,

2956: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
2957: l_selv_rec selv_rec_type := p_selv_rec;
2958: l_sel_rec sel_rec_type;
2959: BEGIN
2960: l_return_status := Okc_Api.START_ACTIVITY(l_api_name,
2961: G_PKG_NAME,
2962: p_init_msg_list,
2963: l_api_version,
2964: p_api_version,

Line 2967: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

2963: l_api_version,
2964: p_api_version,
2965: '_PVT',
2966: x_return_status);
2967: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2968: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2969: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2970: RAISE Okc_Api.G_EXCEPTION_ERROR;
2971: END IF;

Line 2968: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

2964: p_api_version,
2965: '_PVT',
2966: x_return_status);
2967: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2968: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2969: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2970: RAISE Okc_Api.G_EXCEPTION_ERROR;
2971: END IF;
2972: --------------------------------------

Line 2969: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN

2965: '_PVT',
2966: x_return_status);
2967: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2968: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2969: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2970: RAISE Okc_Api.G_EXCEPTION_ERROR;
2971: END IF;
2972: --------------------------------------
2973: -- Move VIEW record to "Child" records

Line 2970: RAISE Okc_Api.G_EXCEPTION_ERROR;

2966: x_return_status);
2967: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2968: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2969: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2970: RAISE Okc_Api.G_EXCEPTION_ERROR;
2971: END IF;
2972: --------------------------------------
2973: -- Move VIEW record to "Child" records
2974: --------------------------------------

Line 2986: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

2982: x_msg_count,
2983: x_msg_data,
2984: l_sel_rec
2985: );
2986: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2987: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2988: ELSIF (x_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2989: RAISE Okc_Api.G_EXCEPTION_ERROR;
2990: END IF;

Line 2987: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

2983: x_msg_data,
2984: l_sel_rec
2985: );
2986: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2987: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2988: ELSIF (x_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2989: RAISE Okc_Api.G_EXCEPTION_ERROR;
2990: END IF;
2991: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);

Line 2988: ELSIF (x_return_status = Okc_Api.G_RET_STS_ERROR) THEN

2984: l_sel_rec
2985: );
2986: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2987: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2988: ELSIF (x_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2989: RAISE Okc_Api.G_EXCEPTION_ERROR;
2990: END IF;
2991: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
2992: EXCEPTION

Line 2989: RAISE Okc_Api.G_EXCEPTION_ERROR;

2985: );
2986: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2987: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2988: ELSIF (x_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2989: RAISE Okc_Api.G_EXCEPTION_ERROR;
2990: END IF;
2991: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
2992: EXCEPTION
2993: WHEN Okc_Api.G_EXCEPTION_ERROR THEN

Line 2991: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);

2987: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2988: ELSIF (x_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2989: RAISE Okc_Api.G_EXCEPTION_ERROR;
2990: END IF;
2991: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
2992: EXCEPTION
2993: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
2994: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
2995: (

Line 2993: WHEN Okc_Api.G_EXCEPTION_ERROR THEN

2989: RAISE Okc_Api.G_EXCEPTION_ERROR;
2990: END IF;
2991: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
2992: EXCEPTION
2993: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
2994: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
2995: (
2996: l_api_name,
2997: G_PKG_NAME,

Line 2994: x_return_status := Okc_Api.HANDLE_EXCEPTIONS

2990: END IF;
2991: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
2992: EXCEPTION
2993: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
2994: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
2995: (
2996: l_api_name,
2997: G_PKG_NAME,
2998: 'OKC_API.G_RET_STS_ERROR',

Line 2998: 'OKC_API.G_RET_STS_ERROR',

2994: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
2995: (
2996: l_api_name,
2997: G_PKG_NAME,
2998: 'OKC_API.G_RET_STS_ERROR',
2999: x_msg_count,
3000: x_msg_data,
3001: '_PVT'
3002: );

Line 3003: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

2999: x_msg_count,
3000: x_msg_data,
3001: '_PVT'
3002: );
3003: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
3004: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
3005: (
3006: l_api_name,
3007: G_PKG_NAME,

Line 3004: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS

3000: x_msg_data,
3001: '_PVT'
3002: );
3003: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
3004: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
3005: (
3006: l_api_name,
3007: G_PKG_NAME,
3008: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 3008: 'OKC_API.G_RET_STS_UNEXP_ERROR',

3004: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
3005: (
3006: l_api_name,
3007: G_PKG_NAME,
3008: 'OKC_API.G_RET_STS_UNEXP_ERROR',
3009: x_msg_count,
3010: x_msg_data,
3011: '_PVT'
3012: );

Line 3014: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS

3010: x_msg_data,
3011: '_PVT'
3012: );
3013: WHEN OTHERS THEN
3014: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
3015: (
3016: l_api_name,
3017: G_PKG_NAME,
3018: 'OTHERS',

Line 3029: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,

3025: -- PL/SQL TBL delete_row for:SELV_TBL --
3026: ----------------------------------------
3027: PROCEDURE delete_row(
3028: p_api_version IN NUMBER,
3029: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
3030: x_return_status OUT NOCOPY VARCHAR2,
3031: x_msg_count OUT NOCOPY NUMBER,
3032: x_msg_data OUT NOCOPY VARCHAR2,
3033: p_selv_tbl IN selv_tbl_type) IS

Line 3037: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

3033: p_selv_tbl IN selv_tbl_type) IS
3034:
3035: l_api_version CONSTANT NUMBER := 1;
3036: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_delete_row';
3037: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
3038: i NUMBER := 0;
3039: -- START change : akjain, 05/15/2001
3040: -- Adding OverAll Status Flag
3041: l_overall_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

Line 3041: l_overall_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

3037: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
3038: i NUMBER := 0;
3039: -- START change : akjain, 05/15/2001
3040: -- Adding OverAll Status Flag
3041: l_overall_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
3042: -- END change : akjain
3043:
3044:
3045: BEGIN

Line 3046: Okc_Api.init_msg_list(p_init_msg_list);

3042: -- END change : akjain
3043:
3044:
3045: BEGIN
3046: Okc_Api.init_msg_list(p_init_msg_list);
3047: -- Make sure PL/SQL table has records in it before passing
3048: IF (p_selv_tbl.COUNT > 0) THEN
3049: i := p_selv_tbl.FIRST;
3050: LOOP

Line 3053: p_init_msg_list => Okc_Api.G_FALSE,

3049: i := p_selv_tbl.FIRST;
3050: LOOP
3051: delete_row (
3052: p_api_version => p_api_version,
3053: p_init_msg_list => Okc_Api.G_FALSE,
3054: x_return_status => x_return_status,
3055: x_msg_count => x_msg_count,
3056: x_msg_data => x_msg_data,
3057: p_selv_rec => p_selv_tbl(i));

Line 3060: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS THEN

3056: x_msg_data => x_msg_data,
3057: p_selv_rec => p_selv_tbl(i));
3058: -- START change : akjain, 05/15/2001
3059: -- store the highest degree of error
3060: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS THEN
3061: IF l_overall_status <> Okc_Api.G_RET_STS_UNEXP_ERROR THEN
3062: l_overall_status := x_return_status;
3063: END IF;
3064: END IF;

Line 3061: IF l_overall_status <> Okc_Api.G_RET_STS_UNEXP_ERROR THEN

3057: p_selv_rec => p_selv_tbl(i));
3058: -- START change : akjain, 05/15/2001
3059: -- store the highest degree of error
3060: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS THEN
3061: IF l_overall_status <> Okc_Api.G_RET_STS_UNEXP_ERROR THEN
3062: l_overall_status := x_return_status;
3063: END IF;
3064: END IF;
3065: -- END change : akjain

Line 3077: WHEN Okc_Api.G_EXCEPTION_ERROR THEN

3073: x_return_status := l_overall_status;
3074: -- END change : akjain
3075: END IF;
3076: EXCEPTION
3077: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
3078: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
3079: (
3080: l_api_name,
3081: G_PKG_NAME,

Line 3078: x_return_status := Okc_Api.HANDLE_EXCEPTIONS

3074: -- END change : akjain
3075: END IF;
3076: EXCEPTION
3077: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
3078: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
3079: (
3080: l_api_name,
3081: G_PKG_NAME,
3082: 'OKC_API.G_RET_STS_ERROR',

Line 3082: 'OKC_API.G_RET_STS_ERROR',

3078: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
3079: (
3080: l_api_name,
3081: G_PKG_NAME,
3082: 'OKC_API.G_RET_STS_ERROR',
3083: x_msg_count,
3084: x_msg_data,
3085: '_PVT'
3086: );

Line 3087: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

3083: x_msg_count,
3084: x_msg_data,
3085: '_PVT'
3086: );
3087: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
3088: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
3089: (
3090: l_api_name,
3091: G_PKG_NAME,

Line 3088: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS

3084: x_msg_data,
3085: '_PVT'
3086: );
3087: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
3088: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
3089: (
3090: l_api_name,
3091: G_PKG_NAME,
3092: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 3092: 'OKC_API.G_RET_STS_UNEXP_ERROR',

3088: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
3089: (
3090: l_api_name,
3091: G_PKG_NAME,
3092: 'OKC_API.G_RET_STS_UNEXP_ERROR',
3093: x_msg_count,
3094: x_msg_data,
3095: '_PVT'
3096: );

Line 3098: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS

3094: x_msg_data,
3095: '_PVT'
3096: );
3097: WHEN OTHERS THEN
3098: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
3099: (
3100: l_api_name,
3101: G_PKG_NAME,
3102: 'OTHERS',