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

Line 236: IF (l_stmv_rec.object_version_number = OKC_API.G_MISS_NUM) THEN

232: p_stmv_rec IN stmv_rec_type
233: ) RETURN stmv_rec_type IS
234: l_stmv_rec stmv_rec_type := p_stmv_rec;
235: BEGIN
236: IF (l_stmv_rec.object_version_number = OKC_API.G_MISS_NUM) THEN
237: l_stmv_rec.object_version_number := NULL;
238: END IF;
239: IF (l_stmv_rec.sgn_code = OKC_API.G_MISS_CHAR) THEN
240: l_stmv_rec.sgn_code := NULL;

Line 239: IF (l_stmv_rec.sgn_code = OKC_API.G_MISS_CHAR) THEN

235: BEGIN
236: IF (l_stmv_rec.object_version_number = OKC_API.G_MISS_NUM) THEN
237: l_stmv_rec.object_version_number := NULL;
238: END IF;
239: IF (l_stmv_rec.sgn_code = OKC_API.G_MISS_CHAR) THEN
240: l_stmv_rec.sgn_code := NULL;
241: END IF;
242: IF (l_stmv_rec.say_code = OKC_API.G_MISS_CHAR) THEN
243: l_stmv_rec.say_code := NULL;

Line 242: IF (l_stmv_rec.say_code = OKC_API.G_MISS_CHAR) THEN

238: END IF;
239: IF (l_stmv_rec.sgn_code = OKC_API.G_MISS_CHAR) THEN
240: l_stmv_rec.sgn_code := NULL;
241: END IF;
242: IF (l_stmv_rec.say_code = OKC_API.G_MISS_CHAR) THEN
243: l_stmv_rec.say_code := NULL;
244: END IF;
245: IF (l_stmv_rec.sty_id = OKC_API.G_MISS_NUM) THEN
246: l_stmv_rec.sty_id := NULL;

Line 245: IF (l_stmv_rec.sty_id = OKC_API.G_MISS_NUM) THEN

241: END IF;
242: IF (l_stmv_rec.say_code = OKC_API.G_MISS_CHAR) THEN
243: l_stmv_rec.say_code := NULL;
244: END IF;
245: IF (l_stmv_rec.sty_id = OKC_API.G_MISS_NUM) THEN
246: l_stmv_rec.sty_id := NULL;
247: END IF;
248: IF (l_stmv_rec.kle_id = OKC_API.G_MISS_NUM) THEN
249: l_stmv_rec.kle_id := NULL;

Line 248: IF (l_stmv_rec.kle_id = OKC_API.G_MISS_NUM) THEN

244: END IF;
245: IF (l_stmv_rec.sty_id = OKC_API.G_MISS_NUM) THEN
246: l_stmv_rec.sty_id := NULL;
247: END IF;
248: IF (l_stmv_rec.kle_id = OKC_API.G_MISS_NUM) THEN
249: l_stmv_rec.kle_id := NULL;
250: END IF;
251: IF (l_stmv_rec.khr_id = OKC_API.G_MISS_NUM) THEN
252: l_stmv_rec.khr_id := NULL;

Line 251: IF (l_stmv_rec.khr_id = OKC_API.G_MISS_NUM) THEN

247: END IF;
248: IF (l_stmv_rec.kle_id = OKC_API.G_MISS_NUM) THEN
249: l_stmv_rec.kle_id := NULL;
250: END IF;
251: IF (l_stmv_rec.khr_id = OKC_API.G_MISS_NUM) THEN
252: l_stmv_rec.khr_id := NULL;
253: END IF;
254: IF (l_stmv_rec.transaction_number = OKC_API.G_MISS_NUM) THEN
255: l_stmv_rec.transaction_number := NULL;

Line 254: IF (l_stmv_rec.transaction_number = OKC_API.G_MISS_NUM) THEN

250: END IF;
251: IF (l_stmv_rec.khr_id = OKC_API.G_MISS_NUM) THEN
252: l_stmv_rec.khr_id := NULL;
253: END IF;
254: IF (l_stmv_rec.transaction_number = OKC_API.G_MISS_NUM) THEN
255: l_stmv_rec.transaction_number := NULL;
256: END IF;
257: IF (l_stmv_rec.active_yn = OKC_API.G_MISS_CHAR) THEN
258: l_stmv_rec.active_yn := NULL;

Line 257: IF (l_stmv_rec.active_yn = OKC_API.G_MISS_CHAR) THEN

253: END IF;
254: IF (l_stmv_rec.transaction_number = OKC_API.G_MISS_NUM) THEN
255: l_stmv_rec.transaction_number := NULL;
256: END IF;
257: IF (l_stmv_rec.active_yn = OKC_API.G_MISS_CHAR) THEN
258: l_stmv_rec.active_yn := NULL;
259: END IF;
260: IF (l_stmv_rec.date_current = OKC_API.G_MISS_DATE) THEN
261: l_stmv_rec.date_current := NULL;

Line 260: IF (l_stmv_rec.date_current = OKC_API.G_MISS_DATE) THEN

256: END IF;
257: IF (l_stmv_rec.active_yn = OKC_API.G_MISS_CHAR) THEN
258: l_stmv_rec.active_yn := NULL;
259: END IF;
260: IF (l_stmv_rec.date_current = OKC_API.G_MISS_DATE) THEN
261: l_stmv_rec.date_current := NULL;
262: END IF;
263: IF (l_stmv_rec.date_working = OKC_API.G_MISS_DATE) THEN
264: l_stmv_rec.date_working := NULL;

Line 263: IF (l_stmv_rec.date_working = OKC_API.G_MISS_DATE) THEN

259: END IF;
260: IF (l_stmv_rec.date_current = OKC_API.G_MISS_DATE) THEN
261: l_stmv_rec.date_current := NULL;
262: END IF;
263: IF (l_stmv_rec.date_working = OKC_API.G_MISS_DATE) THEN
264: l_stmv_rec.date_working := NULL;
265: END IF;
266: IF (l_stmv_rec.date_history = OKC_API.G_MISS_DATE) THEN
267: l_stmv_rec.date_history := NULL;

Line 266: IF (l_stmv_rec.date_history = OKC_API.G_MISS_DATE) THEN

262: END IF;
263: IF (l_stmv_rec.date_working = OKC_API.G_MISS_DATE) THEN
264: l_stmv_rec.date_working := NULL;
265: END IF;
266: IF (l_stmv_rec.date_history = OKC_API.G_MISS_DATE) THEN
267: l_stmv_rec.date_history := NULL;
268: END IF;
269: IF (l_stmv_rec.comments = OKC_API.G_MISS_CHAR) THEN
270: l_stmv_rec.comments := NULL;

Line 269: IF (l_stmv_rec.comments = OKC_API.G_MISS_CHAR) THEN

265: END IF;
266: IF (l_stmv_rec.date_history = OKC_API.G_MISS_DATE) THEN
267: l_stmv_rec.date_history := NULL;
268: END IF;
269: IF (l_stmv_rec.comments = OKC_API.G_MISS_CHAR) THEN
270: l_stmv_rec.comments := NULL;
271: END IF;
272: IF (l_stmv_rec.created_by = OKC_API.G_MISS_NUM) THEN
273: l_stmv_rec.created_by := NULL;

Line 272: IF (l_stmv_rec.created_by = OKC_API.G_MISS_NUM) THEN

268: END IF;
269: IF (l_stmv_rec.comments = OKC_API.G_MISS_CHAR) THEN
270: l_stmv_rec.comments := NULL;
271: END IF;
272: IF (l_stmv_rec.created_by = OKC_API.G_MISS_NUM) THEN
273: l_stmv_rec.created_by := NULL;
274: END IF;
275: IF (l_stmv_rec.creation_date = OKC_API.G_MISS_DATE) THEN
276: l_stmv_rec.creation_date := NULL;

Line 275: IF (l_stmv_rec.creation_date = OKC_API.G_MISS_DATE) THEN

271: END IF;
272: IF (l_stmv_rec.created_by = OKC_API.G_MISS_NUM) THEN
273: l_stmv_rec.created_by := NULL;
274: END IF;
275: IF (l_stmv_rec.creation_date = OKC_API.G_MISS_DATE) THEN
276: l_stmv_rec.creation_date := NULL;
277: END IF;
278: IF (l_stmv_rec.last_updated_by = OKC_API.G_MISS_NUM) THEN
279: l_stmv_rec.last_updated_by := NULL;

Line 278: IF (l_stmv_rec.last_updated_by = OKC_API.G_MISS_NUM) THEN

274: END IF;
275: IF (l_stmv_rec.creation_date = OKC_API.G_MISS_DATE) THEN
276: l_stmv_rec.creation_date := NULL;
277: END IF;
278: IF (l_stmv_rec.last_updated_by = OKC_API.G_MISS_NUM) THEN
279: l_stmv_rec.last_updated_by := NULL;
280: END IF;
281: IF (l_stmv_rec.last_update_date = OKC_API.G_MISS_DATE) THEN
282: l_stmv_rec.last_update_date := NULL;

Line 281: IF (l_stmv_rec.last_update_date = OKC_API.G_MISS_DATE) THEN

277: END IF;
278: IF (l_stmv_rec.last_updated_by = OKC_API.G_MISS_NUM) THEN
279: l_stmv_rec.last_updated_by := NULL;
280: END IF;
281: IF (l_stmv_rec.last_update_date = OKC_API.G_MISS_DATE) THEN
282: l_stmv_rec.last_update_date := NULL;
283: END IF;
284: /*
285: IF (l_stmv_rec.program_id = OKC_API.G_MISS_NUM) THEN

Line 285: IF (l_stmv_rec.program_id = OKC_API.G_MISS_NUM) THEN

281: IF (l_stmv_rec.last_update_date = OKC_API.G_MISS_DATE) THEN
282: l_stmv_rec.last_update_date := NULL;
283: END IF;
284: /*
285: IF (l_stmv_rec.program_id = OKC_API.G_MISS_NUM) THEN
286: l_stmv_rec.program_id := NULL;
287: END IF;
288: IF (l_stmv_rec.request_id = OKC_API.G_MISS_NUM) THEN
289: l_stmv_rec.request_id := NULL;

Line 288: IF (l_stmv_rec.request_id = OKC_API.G_MISS_NUM) THEN

284: /*
285: IF (l_stmv_rec.program_id = OKC_API.G_MISS_NUM) THEN
286: l_stmv_rec.program_id := NULL;
287: END IF;
288: IF (l_stmv_rec.request_id = OKC_API.G_MISS_NUM) THEN
289: l_stmv_rec.request_id := NULL;
290: END IF;
291: IF (l_stmv_rec.program_application_id = OKC_API.G_MISS_NUM) THEN
292: l_stmv_rec.program_application_id := NULL;

Line 291: IF (l_stmv_rec.program_application_id = OKC_API.G_MISS_NUM) THEN

287: END IF;
288: IF (l_stmv_rec.request_id = OKC_API.G_MISS_NUM) THEN
289: l_stmv_rec.request_id := NULL;
290: END IF;
291: IF (l_stmv_rec.program_application_id = OKC_API.G_MISS_NUM) THEN
292: l_stmv_rec.program_application_id := NULL;
293: END IF;
294: IF (l_stmv_rec.program_update_date = OKC_API.G_MISS_DATE) THEN
295: l_stmv_rec.program_update_date := NULL;

Line 294: IF (l_stmv_rec.program_update_date = OKC_API.G_MISS_DATE) THEN

290: END IF;
291: IF (l_stmv_rec.program_application_id = OKC_API.G_MISS_NUM) THEN
292: l_stmv_rec.program_application_id := NULL;
293: END IF;
294: IF (l_stmv_rec.program_update_date = OKC_API.G_MISS_DATE) THEN
295: l_stmv_rec.program_update_date := NULL;
296: END IF;
297: */
298: IF (l_stmv_rec.last_update_login = OKC_API.G_MISS_NUM) THEN

Line 298: IF (l_stmv_rec.last_update_login = OKC_API.G_MISS_NUM) THEN

294: IF (l_stmv_rec.program_update_date = OKC_API.G_MISS_DATE) THEN
295: l_stmv_rec.program_update_date := NULL;
296: END IF;
297: */
298: IF (l_stmv_rec.last_update_login = OKC_API.G_MISS_NUM) THEN
299: l_stmv_rec.last_update_login := NULL;
300: END IF;
301:
302: -- mvasudev, Bug#2650599

Line 303: IF (l_stmv_rec.purpose_code = OKC_API.G_MISS_CHAR) THEN

299: l_stmv_rec.last_update_login := NULL;
300: END IF;
301:
302: -- mvasudev, Bug#2650599
303: IF (l_stmv_rec.purpose_code = OKC_API.G_MISS_CHAR) THEN
304: l_stmv_rec.purpose_code := NULL;
305: END IF;
306: --IF (l_stmv_rec.sty_code = OKC_API.G_MISS_CHAR) THEN
307: --l_stmv_rec.sty_code := NULL;

Line 306: --IF (l_stmv_rec.sty_code = OKC_API.G_MISS_CHAR) THEN

302: -- mvasudev, Bug#2650599
303: IF (l_stmv_rec.purpose_code = OKC_API.G_MISS_CHAR) THEN
304: l_stmv_rec.purpose_code := NULL;
305: END IF;
306: --IF (l_stmv_rec.sty_code = OKC_API.G_MISS_CHAR) THEN
307: --l_stmv_rec.sty_code := NULL;
308: --END IF;
309: -- end, mvasudev, Bug#2650599
310: IF (l_stmv_rec.stm_id = OKC_API.G_MISS_NUM) THEN

Line 310: IF (l_stmv_rec.stm_id = OKC_API.G_MISS_NUM) THEN

306: --IF (l_stmv_rec.sty_code = OKC_API.G_MISS_CHAR) THEN
307: --l_stmv_rec.sty_code := NULL;
308: --END IF;
309: -- end, mvasudev, Bug#2650599
310: IF (l_stmv_rec.stm_id = OKC_API.G_MISS_NUM) THEN
311: l_stmv_rec.stm_id := NULL;
312: END IF;
313:
314: -- Added by Keerthi for Bug 3166890

Line 315: IF (l_stmv_rec.source_id = OKC_API.G_MISS_NUM) THEN

311: l_stmv_rec.stm_id := NULL;
312: END IF;
313:
314: -- Added by Keerthi for Bug 3166890
315: IF (l_stmv_rec.source_id = OKC_API.G_MISS_NUM) THEN
316: l_stmv_rec.source_id := NULL;
317: END IF;
318:
319: IF (l_stmv_rec.source_table = OKC_API.G_MISS_CHAR) THEN

Line 319: IF (l_stmv_rec.source_table = OKC_API.G_MISS_CHAR) THEN

315: IF (l_stmv_rec.source_id = OKC_API.G_MISS_NUM) THEN
316: l_stmv_rec.source_id := NULL;
317: END IF;
318:
319: IF (l_stmv_rec.source_table = OKC_API.G_MISS_CHAR) THEN
320: l_stmv_rec.source_table := NULL;
321: END IF;
322: -- Added by rgooty: 4212626
323: IF (l_stmv_rec.trx_id = OKC_API.G_MISS_NUM) THEN

Line 323: IF (l_stmv_rec.trx_id = OKC_API.G_MISS_NUM) THEN

319: IF (l_stmv_rec.source_table = OKC_API.G_MISS_CHAR) THEN
320: l_stmv_rec.source_table := NULL;
321: END IF;
322: -- Added by rgooty: 4212626
323: IF (l_stmv_rec.trx_id = OKC_API.G_MISS_NUM) THEN
324: l_stmv_rec.trx_id := NULL;
325: END IF;
326: IF (l_stmv_rec.link_hist_stream_id = OKC_API.G_MISS_NUM) THEN
327: l_stmv_rec.link_hist_stream_id := NULL;

Line 326: IF (l_stmv_rec.link_hist_stream_id = OKC_API.G_MISS_NUM) THEN

322: -- Added by rgooty: 4212626
323: IF (l_stmv_rec.trx_id = OKC_API.G_MISS_NUM) THEN
324: l_stmv_rec.trx_id := NULL;
325: END IF;
326: IF (l_stmv_rec.link_hist_stream_id = OKC_API.G_MISS_NUM) THEN
327: l_stmv_rec.link_hist_stream_id := NULL;
328: END IF;
329:
330: RETURN(l_stmv_rec);

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

339: -------------------------------------------
340: FUNCTION Validate_Attributes (
341: p_stmv_rec IN stmv_rec_type
342: ) RETURN VARCHAR2 IS
343: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
344: BEGIN
345: IF p_stmv_rec.id = OKC_API.G_MISS_NUM OR
346: p_stmv_rec.id IS NULL
347: THEN

Line 345: IF p_stmv_rec.id = OKC_API.G_MISS_NUM OR

341: p_stmv_rec IN stmv_rec_type
342: ) RETURN VARCHAR2 IS
343: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
344: BEGIN
345: IF p_stmv_rec.id = OKC_API.G_MISS_NUM OR
346: p_stmv_rec.id IS NULL
347: THEN
348: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'id');
349: l_return_status := OKC_API.G_RET_STS_ERROR;

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

344: BEGIN
345: IF p_stmv_rec.id = OKC_API.G_MISS_NUM OR
346: p_stmv_rec.id IS NULL
347: THEN
348: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'id');
349: l_return_status := OKC_API.G_RET_STS_ERROR;
350: ELSIF p_stmv_rec.object_version_number = OKC_API.G_MISS_NUM OR
351: p_stmv_rec.object_version_number IS NULL
352: THEN

Line 349: l_return_status := OKC_API.G_RET_STS_ERROR;

345: IF p_stmv_rec.id = OKC_API.G_MISS_NUM OR
346: p_stmv_rec.id IS NULL
347: THEN
348: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'id');
349: l_return_status := OKC_API.G_RET_STS_ERROR;
350: ELSIF p_stmv_rec.object_version_number = OKC_API.G_MISS_NUM OR
351: p_stmv_rec.object_version_number IS NULL
352: THEN
353: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'object_version_number');

Line 350: ELSIF p_stmv_rec.object_version_number = OKC_API.G_MISS_NUM OR

346: p_stmv_rec.id IS NULL
347: THEN
348: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'id');
349: l_return_status := OKC_API.G_RET_STS_ERROR;
350: ELSIF p_stmv_rec.object_version_number = OKC_API.G_MISS_NUM OR
351: p_stmv_rec.object_version_number IS NULL
352: THEN
353: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'object_version_number');
354: l_return_status := OKC_API.G_RET_STS_ERROR;

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

349: l_return_status := OKC_API.G_RET_STS_ERROR;
350: ELSIF p_stmv_rec.object_version_number = OKC_API.G_MISS_NUM OR
351: p_stmv_rec.object_version_number IS NULL
352: THEN
353: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'object_version_number');
354: l_return_status := OKC_API.G_RET_STS_ERROR;
355: ELSIF p_stmv_rec.sgn_code = OKC_API.G_MISS_CHAR OR
356: p_stmv_rec.sgn_code IS NULL
357: THEN

Line 354: l_return_status := OKC_API.G_RET_STS_ERROR;

350: ELSIF p_stmv_rec.object_version_number = OKC_API.G_MISS_NUM OR
351: p_stmv_rec.object_version_number IS NULL
352: THEN
353: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'object_version_number');
354: l_return_status := OKC_API.G_RET_STS_ERROR;
355: ELSIF p_stmv_rec.sgn_code = OKC_API.G_MISS_CHAR OR
356: p_stmv_rec.sgn_code IS NULL
357: THEN
358: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'sgn_code');

Line 355: ELSIF p_stmv_rec.sgn_code = OKC_API.G_MISS_CHAR OR

351: p_stmv_rec.object_version_number IS NULL
352: THEN
353: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'object_version_number');
354: l_return_status := OKC_API.G_RET_STS_ERROR;
355: ELSIF p_stmv_rec.sgn_code = OKC_API.G_MISS_CHAR OR
356: p_stmv_rec.sgn_code IS NULL
357: THEN
358: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'sgn_code');
359: l_return_status := OKC_API.G_RET_STS_ERROR;

Line 358: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'sgn_code');

354: l_return_status := OKC_API.G_RET_STS_ERROR;
355: ELSIF p_stmv_rec.sgn_code = OKC_API.G_MISS_CHAR OR
356: p_stmv_rec.sgn_code IS NULL
357: THEN
358: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'sgn_code');
359: l_return_status := OKC_API.G_RET_STS_ERROR;
360: ELSIF p_stmv_rec.say_code = OKC_API.G_MISS_CHAR OR
361: p_stmv_rec.say_code IS NULL
362: THEN

Line 359: l_return_status := OKC_API.G_RET_STS_ERROR;

355: ELSIF p_stmv_rec.sgn_code = OKC_API.G_MISS_CHAR OR
356: p_stmv_rec.sgn_code IS NULL
357: THEN
358: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'sgn_code');
359: l_return_status := OKC_API.G_RET_STS_ERROR;
360: ELSIF p_stmv_rec.say_code = OKC_API.G_MISS_CHAR OR
361: p_stmv_rec.say_code IS NULL
362: THEN
363: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'say_code');

Line 360: ELSIF p_stmv_rec.say_code = OKC_API.G_MISS_CHAR OR

356: p_stmv_rec.sgn_code IS NULL
357: THEN
358: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'sgn_code');
359: l_return_status := OKC_API.G_RET_STS_ERROR;
360: ELSIF p_stmv_rec.say_code = OKC_API.G_MISS_CHAR OR
361: p_stmv_rec.say_code IS NULL
362: THEN
363: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'say_code');
364: l_return_status := OKC_API.G_RET_STS_ERROR;

Line 363: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'say_code');

359: l_return_status := OKC_API.G_RET_STS_ERROR;
360: ELSIF p_stmv_rec.say_code = OKC_API.G_MISS_CHAR OR
361: p_stmv_rec.say_code IS NULL
362: THEN
363: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'say_code');
364: l_return_status := OKC_API.G_RET_STS_ERROR;
365: ELSIF p_stmv_rec.sty_id = OKC_API.G_MISS_NUM OR
366: p_stmv_rec.sty_id IS NULL
367: THEN

Line 364: l_return_status := OKC_API.G_RET_STS_ERROR;

360: ELSIF p_stmv_rec.say_code = OKC_API.G_MISS_CHAR OR
361: p_stmv_rec.say_code IS NULL
362: THEN
363: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'say_code');
364: l_return_status := OKC_API.G_RET_STS_ERROR;
365: ELSIF p_stmv_rec.sty_id = OKC_API.G_MISS_NUM OR
366: p_stmv_rec.sty_id IS NULL
367: THEN
368: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'sty_id');

Line 365: ELSIF p_stmv_rec.sty_id = OKC_API.G_MISS_NUM OR

361: p_stmv_rec.say_code IS NULL
362: THEN
363: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'say_code');
364: l_return_status := OKC_API.G_RET_STS_ERROR;
365: ELSIF p_stmv_rec.sty_id = OKC_API.G_MISS_NUM OR
366: p_stmv_rec.sty_id IS NULL
367: THEN
368: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'sty_id');
369: l_return_status := OKC_API.G_RET_STS_ERROR;

Line 368: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'sty_id');

364: l_return_status := OKC_API.G_RET_STS_ERROR;
365: ELSIF p_stmv_rec.sty_id = OKC_API.G_MISS_NUM OR
366: p_stmv_rec.sty_id IS NULL
367: THEN
368: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'sty_id');
369: l_return_status := OKC_API.G_RET_STS_ERROR;
370: ELSIF p_stmv_rec.active_yn = OKC_API.G_MISS_CHAR OR
371: p_stmv_rec.active_yn IS NULL
372: THEN

Line 369: l_return_status := OKC_API.G_RET_STS_ERROR;

365: ELSIF p_stmv_rec.sty_id = OKC_API.G_MISS_NUM OR
366: p_stmv_rec.sty_id IS NULL
367: THEN
368: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'sty_id');
369: l_return_status := OKC_API.G_RET_STS_ERROR;
370: ELSIF p_stmv_rec.active_yn = OKC_API.G_MISS_CHAR OR
371: p_stmv_rec.active_yn IS NULL
372: THEN
373: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'active_yn');

Line 370: ELSIF p_stmv_rec.active_yn = OKC_API.G_MISS_CHAR OR

366: p_stmv_rec.sty_id IS NULL
367: THEN
368: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'sty_id');
369: l_return_status := OKC_API.G_RET_STS_ERROR;
370: ELSIF p_stmv_rec.active_yn = OKC_API.G_MISS_CHAR OR
371: p_stmv_rec.active_yn IS NULL
372: THEN
373: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'active_yn');
374: l_return_status := OKC_API.G_RET_STS_ERROR;

Line 373: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'active_yn');

369: l_return_status := OKC_API.G_RET_STS_ERROR;
370: ELSIF p_stmv_rec.active_yn = OKC_API.G_MISS_CHAR OR
371: p_stmv_rec.active_yn IS NULL
372: THEN
373: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'active_yn');
374: l_return_status := OKC_API.G_RET_STS_ERROR;
375: END IF;
376: RETURN(l_return_status);
377: END Validate_Attributes;

Line 374: l_return_status := OKC_API.G_RET_STS_ERROR;

370: ELSIF p_stmv_rec.active_yn = OKC_API.G_MISS_CHAR OR
371: p_stmv_rec.active_yn IS NULL
372: THEN
373: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'active_yn');
374: l_return_status := OKC_API.G_RET_STS_ERROR;
375: END IF;
376: RETURN(l_return_status);
377: END Validate_Attributes;
378:

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

384: ---------------------------------------
385: FUNCTION Validate_Record (
386: p_stmv_rec IN stmv_rec_type
387: ) RETURN VARCHAR2 IS
388: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
389: BEGIN
390: RETURN (l_return_status);
391: END Validate_Record;
392:

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

409: PROCEDURE Validate_Object_Version_Number(p_stmv_rec IN stmv_rec_type,x_return_status OUT NOCOPY VARCHAR2)
410:
411: IS
412:
413: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
414:
415: BEGIN
416: -- initialize return status
417: x_return_status := Okc_Api.G_RET_STS_SUCCESS;

Line 417: x_return_status := Okc_Api.G_RET_STS_SUCCESS;

413: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
414:
415: BEGIN
416: -- initialize return status
417: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
418: -- check for data before processing
419: IF (p_stmv_rec.object_version_number IS NULL) THEN
420: Okc_Api.SET_MESSAGE(p_app_name => G_OKC_APP
421: ,p_msg_name => g_required_value

Line 420: Okc_Api.SET_MESSAGE(p_app_name => G_OKC_APP

416: -- initialize return status
417: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
418: -- check for data before processing
419: IF (p_stmv_rec.object_version_number IS NULL) THEN
420: Okc_Api.SET_MESSAGE(p_app_name => G_OKC_APP
421: ,p_msg_name => g_required_value
422: ,p_token1 => g_col_name_token
423: ,p_token1_value => 'object_version_number');
424: x_return_status := Okc_Api.G_RET_STS_ERROR;

Line 424: x_return_status := Okc_Api.G_RET_STS_ERROR;

420: Okc_Api.SET_MESSAGE(p_app_name => G_OKC_APP
421: ,p_msg_name => g_required_value
422: ,p_token1 => g_col_name_token
423: ,p_token1_value => 'object_version_number');
424: x_return_status := Okc_Api.G_RET_STS_ERROR;
425: RAISE G_EXCEPTION_HALT_VALIDATION;
426: END IF;
427:
428: EXCEPTION

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

432: NULL;
433:
434: WHEN OTHERS THEN
435: -- store SQL error message on message stack for caller
436: Okc_Api.SET_MESSAGE(p_app_name => g_app_name,
437: p_msg_name => G_OKL_UNEXPECTED_ERROR,
438: p_token1 => G_OKL_SQLCODE_TOKEN,
439: p_token1_value => SQLCODE,
440: p_token2 => G_OKL_SQLERRM_TOKEN,

Line 445: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;

441: p_token2_value => SQLERRM);
442:
443: -- notify caller of an UNEXPECTED error
444:
445: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;
446:
447: END Validate_Object_Version_Number;
448:
449:

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

463: PROCEDURE Validate_Id(p_stmv_rec IN stmv_rec_type,x_return_status OUT NOCOPY VARCHAR2)
464:
465: IS
466:
467: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
468:
469: BEGIN
470: -- initialize return status
471: x_return_status := Okc_Api.G_RET_STS_SUCCESS;

Line 471: x_return_status := Okc_Api.G_RET_STS_SUCCESS;

467: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
468:
469: BEGIN
470: -- initialize return status
471: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
472: -- check for data before processing
473: IF (p_stmv_rec.id IS NULL) THEN
474:
475: Okc_Api.SET_MESSAGE(p_app_name => G_OKC_APP

Line 475: Okc_Api.SET_MESSAGE(p_app_name => G_OKC_APP

471: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
472: -- check for data before processing
473: IF (p_stmv_rec.id IS NULL) THEN
474:
475: Okc_Api.SET_MESSAGE(p_app_name => G_OKC_APP
476: ,p_msg_name => g_required_value
477: ,p_token1 => g_col_name_token
478: ,p_token1_value => 'id');
479: x_return_status := Okc_Api.G_RET_STS_ERROR;

Line 479: x_return_status := Okc_Api.G_RET_STS_ERROR;

475: Okc_Api.SET_MESSAGE(p_app_name => G_OKC_APP
476: ,p_msg_name => g_required_value
477: ,p_token1 => g_col_name_token
478: ,p_token1_value => 'id');
479: x_return_status := Okc_Api.G_RET_STS_ERROR;
480: RAISE G_EXCEPTION_HALT_VALIDATION;
481: END IF;
482:
483: EXCEPTION

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

487: NULL;
488:
489: WHEN OTHERS THEN
490: -- store SQL error message on message stack for caller
491: Okc_Api.SET_MESSAGE(p_app_name => g_app_name,
492: p_msg_name => G_OKL_UNEXPECTED_ERROR,
493: p_token1 => G_OKL_SQLCODE_TOKEN,
494: p_token1_value => SQLCODE,
495: p_token2 => G_OKL_SQLERRM_TOKEN,

Line 499: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;

495: p_token2 => G_OKL_SQLERRM_TOKEN,
496: p_token2_value => SQLERRM);
497:
498: -- notify caller of an UNEXPECTED error
499: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;
500:
501: END Validate_Id;
502:
503: ------------------------------------------------------------------------

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

514: ---------------------------------------------------------------------------
515:
516: PROCEDURE Validate_Transaction_Number(p_stmv_rec IN stmv_rec_type,x_return_status OUT NOCOPY VARCHAR2)
517: IS
518: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
519: BEGIN
520: -- initialize return status
521: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
522: -- check for data before processing

Line 521: x_return_status := Okc_Api.G_RET_STS_SUCCESS;

517: IS
518: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
519: BEGIN
520: -- initialize return status
521: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
522: -- check for data before processing
523: IF (p_stmv_rec.transaction_number IS NULL) THEN
524: Okc_Api.SET_MESSAGE(p_app_name => G_OKC_APP
525: ,p_msg_name => g_required_value

Line 524: Okc_Api.SET_MESSAGE(p_app_name => G_OKC_APP

520: -- initialize return status
521: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
522: -- check for data before processing
523: IF (p_stmv_rec.transaction_number IS NULL) THEN
524: Okc_Api.SET_MESSAGE(p_app_name => G_OKC_APP
525: ,p_msg_name => g_required_value
526: ,p_token1 => g_col_name_token
527: ,p_token1_value => 'Transaction_Number');
528: x_return_status := Okc_Api.G_RET_STS_ERROR;

Line 528: x_return_status := Okc_Api.G_RET_STS_ERROR;

524: Okc_Api.SET_MESSAGE(p_app_name => G_OKC_APP
525: ,p_msg_name => g_required_value
526: ,p_token1 => g_col_name_token
527: ,p_token1_value => 'Transaction_Number');
528: x_return_status := Okc_Api.G_RET_STS_ERROR;
529: RAISE G_EXCEPTION_HALT_VALIDATION;
530: END IF;
531:
532: EXCEPTION

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

536: NULL;
537:
538: WHEN OTHERS THEN
539: -- store SQL error message on message stack for caller
540: Okc_Api.SET_MESSAGE(p_app_name => g_app_name,
541: p_msg_name => G_OKL_UNEXPECTED_ERROR,
542: p_token1 => G_OKL_SQLCODE_TOKEN,
543: p_token1_value => SQLCODE,
544: p_token2 => G_OKL_SQLERRM_TOKEN,

Line 548: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;

544: p_token2 => G_OKL_SQLERRM_TOKEN,
545: p_token2_value => SQLERRM);
546:
547: -- notify caller of an UNEXPECTED error
548: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;
549:
550: END Validate_Transaction_Number;
551:
552: ---------------------------------------------------------------------

Line 574: x_return_status := Okc_Api.G_RET_STS_SUCCESS;

570: l_found VARCHAR2(1);
571:
572: BEGIN
573: -- initialize return status
574: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
575: -- check for data before processing
576: IF (p_stmv_rec .active_yn IS NULL) THEN
577: Okc_Api.SET_MESSAGE(p_app_name => G_OKC_APP
578: ,p_msg_name => g_required_value

Line 577: Okc_Api.SET_MESSAGE(p_app_name => G_OKC_APP

573: -- initialize return status
574: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
575: -- check for data before processing
576: IF (p_stmv_rec .active_yn IS NULL) THEN
577: Okc_Api.SET_MESSAGE(p_app_name => G_OKC_APP
578: ,p_msg_name => g_required_value
579: ,p_token1 => g_col_name_token
580: ,p_token1_value => 'active_yn');
581: x_return_status := Okc_Api.G_RET_STS_ERROR;

Line 581: x_return_status := Okc_Api.G_RET_STS_ERROR;

577: Okc_Api.SET_MESSAGE(p_app_name => G_OKC_APP
578: ,p_msg_name => g_required_value
579: ,p_token1 => g_col_name_token
580: ,p_token1_value => 'active_yn');
581: x_return_status := Okc_Api.G_RET_STS_ERROR;
582: RAISE G_EXCEPTION_HALT_VALIDATION;
583:
584: ELSIF p_stmv_rec.active_yn IS NOT NULL THEN
585: --Check if active_yn exists in the fnd_common_lookups or not

Line 593: OKC_API.set_message(G_OKC_APP, G_INVALID_VALUE,G_COL_NAME_TOKEN,'Active_YN');

589: p_view_app_id => 0);
590:
591:
592: IF (l_found <> OKL_API.G_TRUE ) THEN
593: OKC_API.set_message(G_OKC_APP, G_INVALID_VALUE,G_COL_NAME_TOKEN,'Active_YN');
594: x_return_status := Okc_Api.G_RET_STS_ERROR;
595: -- raise the exception as there's no matching foreign key value
596: RAISE G_EXCEPTION_HALT_VALIDATION;
597: END IF; END IF;

Line 594: x_return_status := Okc_Api.G_RET_STS_ERROR;

590:
591:
592: IF (l_found <> OKL_API.G_TRUE ) THEN
593: OKC_API.set_message(G_OKC_APP, G_INVALID_VALUE,G_COL_NAME_TOKEN,'Active_YN');
594: x_return_status := Okc_Api.G_RET_STS_ERROR;
595: -- raise the exception as there's no matching foreign key value
596: RAISE G_EXCEPTION_HALT_VALIDATION;
597: END IF; END IF;
598:

Line 606: OKC_API.SET_MESSAGE(p_app_name => g_app_name,

602: -- with the next column
603: NULL;
604: WHEN OTHERS THEN
605: -- store SQL error message on message stack for caller
606: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
607: p_msg_name => G_OKL_UNEXPECTED_ERROR,
608: p_token1 => G_OKL_SQLCODE_TOKEN,
609: p_token1_value => SQLCODE,
610: p_token2 => G_OKL_SQLERRM_TOKEN,

Line 615: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

611: p_token2_value => SQLERRM);
612:
613: -- notify caller of an UNEXPECTED error
614:
615: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
616:
617: END Validate_Active_yn;
618:
619:

Line 646: x_return_status := Okc_Api.G_RET_STS_SUCCESS;

642: l_dummy_sty_id VARCHAR2(1);
643: l_row_notfound BOOLEAN :=TRUE;
644: BEGIN
645: -- initialize return status
646: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
647:
648: -- check for data before processing
649: IF (p_stmv_rec.sty_id IS NULL)THEN
650: Okc_Api.SET_MESSAGE(p_app_name => G_OKC_APP

Line 650: Okc_Api.SET_MESSAGE(p_app_name => G_OKC_APP

646: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
647:
648: -- check for data before processing
649: IF (p_stmv_rec.sty_id IS NULL)THEN
650: Okc_Api.SET_MESSAGE(p_app_name => G_OKC_APP
651: ,p_msg_name => g_required_value
652: ,p_token1 => g_col_name_token
653: ,p_token1_value => 'sty_id');
654: x_return_status := Okc_Api.G_RET_STS_ERROR;

Line 654: x_return_status := Okc_Api.G_RET_STS_ERROR;

650: Okc_Api.SET_MESSAGE(p_app_name => G_OKC_APP
651: ,p_msg_name => g_required_value
652: ,p_token1 => g_col_name_token
653: ,p_token1_value => 'sty_id');
654: x_return_status := Okc_Api.G_RET_STS_ERROR;
655: RAISE G_EXCEPTION_HALT_VALIDATION;
656:
657: ELSIF p_stmv_rec.sty_id IS NOT NULL THEN
658: --Check if sty_id exists in the stream type or not

Line 665: OKC_API.SET_MESSAGE(G_APP_NAME,G_OKL_STM_NO_PARENT_RECORD,G_COL_NAME_TOKEN,'STY_ID',G_PARENT_TABLE_TOKEN,'OKL_STRM_TYPE_V');

661: l_row_notfound :=l_styid_csr%NOTFOUND;
662: CLOSE l_styid_csr;
663:
664: IF(l_row_notfound ) THEN
665: OKC_API.SET_MESSAGE(G_APP_NAME,G_OKL_STM_NO_PARENT_RECORD,G_COL_NAME_TOKEN,'STY_ID',G_PARENT_TABLE_TOKEN,'OKL_STRM_TYPE_V');
666: x_return_status := Okc_Api.G_RET_STS_ERROR;
667: -- raise the exception as there's no matching foreign key value
668:
669: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 666: x_return_status := Okc_Api.G_RET_STS_ERROR;

662: CLOSE l_styid_csr;
663:
664: IF(l_row_notfound ) THEN
665: OKC_API.SET_MESSAGE(G_APP_NAME,G_OKL_STM_NO_PARENT_RECORD,G_COL_NAME_TOKEN,'STY_ID',G_PARENT_TABLE_TOKEN,'OKL_STRM_TYPE_V');
666: x_return_status := Okc_Api.G_RET_STS_ERROR;
667: -- raise the exception as there's no matching foreign key value
668:
669: RAISE G_EXCEPTION_HALT_VALIDATION;
670: END IF;

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

676: NULL;
677:
678: WHEN OTHERS THEN
679: -- store SQL error message on message stack for caller
680: Okc_Api.SET_MESSAGE(p_app_name => g_app_name,
681: p_msg_name => G_OKL_UNEXPECTED_ERROR,
682: p_token1 => G_OKL_SQLCODE_TOKEN,
683: p_token1_value => SQLCODE,
684: p_token2 => G_OKL_SQLERRM_TOKEN,

Line 688: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;

684: p_token2 => G_OKL_SQLERRM_TOKEN,
685: p_token2_value => SQLERRM);
686: -- notify caller of an UNEXPECTED error
687:
688: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;
689: END Validate_Sty_Id;
690:
691:
692: ---------------------------------------------------------------------------

Line 718: x_return_status := Okc_Api.G_RET_STS_SUCCESS;

714: l_dummy_khr_id VARCHAR2(1);
715: l_row_notfound BOOLEAN :=TRUE;
716: BEGIN
717: -- initialize return status
718: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
719:
720: -- check for data before processing
721: IF (p_stmv_rec.khr_id IS NULL) THEN
722: Okc_Api.SET_MESSAGE(p_app_name => G_OKC_APP

Line 722: Okc_Api.SET_MESSAGE(p_app_name => G_OKC_APP

718: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
719:
720: -- check for data before processing
721: IF (p_stmv_rec.khr_id IS NULL) THEN
722: Okc_Api.SET_MESSAGE(p_app_name => G_OKC_APP
723: ,p_msg_name => g_required_value
724: ,p_token1 => g_col_name_token
725: ,p_token1_value => 'khr_id');
726: x_return_status := Okc_Api.G_RET_STS_ERROR;

Line 726: x_return_status := Okc_Api.G_RET_STS_ERROR;

722: Okc_Api.SET_MESSAGE(p_app_name => G_OKC_APP
723: ,p_msg_name => g_required_value
724: ,p_token1 => g_col_name_token
725: ,p_token1_value => 'khr_id');
726: x_return_status := Okc_Api.G_RET_STS_ERROR;
727: RAISE G_EXCEPTION_HALT_VALIDATION;
728:
729: ELSIF p_stmv_rec.khr_id IS NOT NULL THEN
730: --Check if khr_id exists in the okl_k_headers or not

Line 737: OKC_API.SET_MESSAGE(G_APP_NAME,G_OKL_NO_PARENT_RECORD,G_COL_NAME_TOKEN,'KHR_ID',G_CHILD_TABLE_TOKEN,'OKL_STREAMS',G_PARENT_TABLE_TOKEN,'OKL_K_HEADERS_V');

733: l_row_notfound :=l_khrid_csr%NOTFOUND;
734: CLOSE l_khrid_csr;
735:
736: IF(l_row_notfound ) THEN
737: OKC_API.SET_MESSAGE(G_APP_NAME,G_OKL_NO_PARENT_RECORD,G_COL_NAME_TOKEN,'KHR_ID',G_CHILD_TABLE_TOKEN,'OKL_STREAMS',G_PARENT_TABLE_TOKEN,'OKL_K_HEADERS_V');
738:
739: x_return_status := Okc_Api.G_RET_STS_ERROR;
740: -- raise the exception as there's no matching foreign key value
741:

Line 739: x_return_status := Okc_Api.G_RET_STS_ERROR;

735:
736: IF(l_row_notfound ) THEN
737: OKC_API.SET_MESSAGE(G_APP_NAME,G_OKL_NO_PARENT_RECORD,G_COL_NAME_TOKEN,'KHR_ID',G_CHILD_TABLE_TOKEN,'OKL_STREAMS',G_PARENT_TABLE_TOKEN,'OKL_K_HEADERS_V');
738:
739: x_return_status := Okc_Api.G_RET_STS_ERROR;
740: -- raise the exception as there's no matching foreign key value
741:
742: RAISE G_EXCEPTION_HALT_VALIDATION;
743: END IF;

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

749: NULL;
750:
751: WHEN OTHERS THEN
752: -- store SQL error message on message stack for caller
753: Okc_Api.SET_MESSAGE(p_app_name => g_app_name,
754: p_msg_name => G_OKL_UNEXPECTED_ERROR,
755: p_token1 => G_OKL_SQLCODE_TOKEN,
756: p_token1_value => SQLCODE,
757: p_token2 => G_OKL_SQLERRM_TOKEN,

Line 760: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;

756: p_token1_value => SQLCODE,
757: p_token2 => G_OKL_SQLERRM_TOKEN,
758: p_token2_value => SQLERRM);
759: -- notify caller of an UNEXPECTED error
760: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;
761: END Validate_Khr_Id;
762:
763:
764:

Line 793: x_return_status := Okc_Api.G_RET_STS_SUCCESS;

789:
790:
791: BEGIN
792: -- initialize return status
793: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
794:
795: -- check for data before processing
796: IF (p_stmv_rec.kle_id IS NULL) THEN
797: Okc_Api.SET_MESSAGE(p_app_name => G_OKC_APP

Line 797: Okc_Api.SET_MESSAGE(p_app_name => G_OKC_APP

793: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
794:
795: -- check for data before processing
796: IF (p_stmv_rec.kle_id IS NULL) THEN
797: Okc_Api.SET_MESSAGE(p_app_name => G_OKC_APP
798: ,p_msg_name => g_required_value
799: ,p_token1 => g_col_name_token
800: ,p_token1_value => 'kle_id');
801: x_return_status := Okc_Api.G_RET_STS_ERROR;

Line 801: x_return_status := Okc_Api.G_RET_STS_ERROR;

797: Okc_Api.SET_MESSAGE(p_app_name => G_OKC_APP
798: ,p_msg_name => g_required_value
799: ,p_token1 => g_col_name_token
800: ,p_token1_value => 'kle_id');
801: x_return_status := Okc_Api.G_RET_STS_ERROR;
802: RAISE G_EXCEPTION_HALT_VALIDATION;
803:
804: ELSIF p_stmv_rec.kle_id IS NOT NULL THEN
805: --Check if kle_id exists in the okl_k_lines or not

Line 813: OKC_API.SET_MESSAGE(G_APP_NAME,G_OKL_NO_PARENT_RECORD,G_COL_NAME_TOKEN,'KLE_ID',G_CHILD_TABLE_TOKEN,'OKL_STREAMS',G_PARENT_TABLE_TOKEN,'OKL_K_LINES_V');

809: CLOSE l_kleid_csr;
810:
811: IF(l_row_notfound ) THEN
812:
813: OKC_API.SET_MESSAGE(G_APP_NAME,G_OKL_NO_PARENT_RECORD,G_COL_NAME_TOKEN,'KLE_ID',G_CHILD_TABLE_TOKEN,'OKL_STREAMS',G_PARENT_TABLE_TOKEN,'OKL_K_LINES_V');
814:
815: x_return_status := Okc_Api.G_RET_STS_ERROR;
816: -- raise the exception as there's no matching foreign key value
817:

Line 815: x_return_status := Okc_Api.G_RET_STS_ERROR;

811: IF(l_row_notfound ) THEN
812:
813: OKC_API.SET_MESSAGE(G_APP_NAME,G_OKL_NO_PARENT_RECORD,G_COL_NAME_TOKEN,'KLE_ID',G_CHILD_TABLE_TOKEN,'OKL_STREAMS',G_PARENT_TABLE_TOKEN,'OKL_K_LINES_V');
814:
815: x_return_status := Okc_Api.G_RET_STS_ERROR;
816: -- raise the exception as there's no matching foreign key value
817:
818: RAISE G_EXCEPTION_HALT_VALIDATION;
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_OKL_UNEXPECTED_ERROR,
831: p_token1 => G_OKL_SQLCODE_TOKEN,
832: p_token1_value => SQLCODE,
833: p_token2 => G_OKL_SQLERRM_TOKEN,

Line 836: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;

832: p_token1_value => SQLCODE,
833: p_token2 => G_OKL_SQLERRM_TOKEN,
834: p_token2_value => SQLERRM);
835: -- notify caller of an UNEXPECTED error
836: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;
837: END Validate_Kle_Id;
838:
839:
840: ---------------------------------------------------------------------------

Line 862: x_return_status := Okc_Api.G_RET_STS_SUCCESS;

858: l_found VARCHAR2(1);
859:
860: BEGIN
861: -- initialize return status
862: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
863:
864: -- check for data before processing
865: IF (p_stmv_rec.sgn_code IS NULL)THEN
866: Okc_Api.SET_MESSAGE(p_app_name => G_OKC_APP

Line 866: Okc_Api.SET_MESSAGE(p_app_name => G_OKC_APP

862: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
863:
864: -- check for data before processing
865: IF (p_stmv_rec.sgn_code IS NULL)THEN
866: Okc_Api.SET_MESSAGE(p_app_name => G_OKC_APP
867: ,p_msg_name => g_required_value
868: ,p_token1 => g_col_name_token
869: ,p_token1_value => 'sgn_code');
870: x_return_status := Okc_Api.G_RET_STS_ERROR;

Line 870: x_return_status := Okc_Api.G_RET_STS_ERROR;

866: Okc_Api.SET_MESSAGE(p_app_name => G_OKC_APP
867: ,p_msg_name => g_required_value
868: ,p_token1 => g_col_name_token
869: ,p_token1_value => 'sgn_code');
870: x_return_status := Okc_Api.G_RET_STS_ERROR;
871: RAISE G_EXCEPTION_HALT_VALIDATION;
872:
873: ELSE
874: l_found := okl_accounting_util.validate_lookup_code(p_lookup_type => 'OKL_STREAM_GENERATOR',

Line 879: OKC_API.set_message(G_OKC_APP, G_INVALID_VALUE,G_COL_NAME_TOKEN,'SPS_CODE');

875: p_lookup_code => p_stmv_rec.sgn_code);
876:
877:
878: IF (l_found <> OKL_API.G_TRUE ) THEN
879: OKC_API.set_message(G_OKC_APP, G_INVALID_VALUE,G_COL_NAME_TOKEN,'SPS_CODE');
880: x_return_status := Okc_Api.G_RET_STS_ERROR;
881: -- raise the exception as there's no matching foreign key value
882: RAISE G_EXCEPTION_HALT_VALIDATION;
883: END IF;

Line 880: x_return_status := Okc_Api.G_RET_STS_ERROR;

876:
877:
878: IF (l_found <> OKL_API.G_TRUE ) THEN
879: OKC_API.set_message(G_OKC_APP, G_INVALID_VALUE,G_COL_NAME_TOKEN,'SPS_CODE');
880: x_return_status := Okc_Api.G_RET_STS_ERROR;
881: -- raise the exception as there's no matching foreign key value
882: RAISE G_EXCEPTION_HALT_VALIDATION;
883: END IF;
884: END IF;

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

889: NULL;
890:
891: WHEN OTHERS THEN
892: -- store SQL error message on message stack for caller
893: Okc_Api.SET_MESSAGE(p_app_name => g_app_name,
894: p_msg_name => G_OKL_UNEXPECTED_ERROR,
895: p_token1 => G_OKL_SQLCODE_TOKEN,
896: p_token1_value => SQLCODE,
897: p_token2 => G_OKL_SQLERRM_TOKEN,

Line 901: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;

897: p_token2 => G_OKL_SQLERRM_TOKEN,
898: p_token2_value => SQLERRM);
899:
900: -- notify caller of an UNEXPECTED error
901: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;
902: END Validate_Sgn_Code;
903:
904:
905: -----------------------------------------------------------------------------

Line 925: x_return_status := Okc_Api.G_RET_STS_SUCCESS;

921: l_found VARCHAR2(1);
922:
923: BEGIN
924: -- initialize return status
925: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
926:
927: -- check for data before processing
928: IF (p_stmv_rec.say_code IS NULL)THEN
929: Okc_Api.SET_MESSAGE(p_app_name => G_OKC_APP

Line 929: Okc_Api.SET_MESSAGE(p_app_name => G_OKC_APP

925: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
926:
927: -- check for data before processing
928: IF (p_stmv_rec.say_code IS NULL)THEN
929: Okc_Api.SET_MESSAGE(p_app_name => G_OKC_APP
930: ,p_msg_name => g_required_value
931: ,p_token1 => g_col_name_token
932: ,p_token1_value => 'say_code');
933: x_return_status := Okc_Api.G_RET_STS_ERROR;

Line 933: x_return_status := Okc_Api.G_RET_STS_ERROR;

929: Okc_Api.SET_MESSAGE(p_app_name => G_OKC_APP
930: ,p_msg_name => g_required_value
931: ,p_token1 => g_col_name_token
932: ,p_token1_value => 'say_code');
933: x_return_status := Okc_Api.G_RET_STS_ERROR;
934: RAISE G_EXCEPTION_HALT_VALIDATION;
935:
936: ELSIF p_stmv_rec.say_code IS NOT NULL THEN
937: --Check if say_code exists in the fnd_common_lookups or not

Line 943: OKC_API.set_message(G_OKC_APP, G_INVALID_VALUE,G_COL_NAME_TOKEN,'SPS_CODE');

939: p_lookup_code => p_stmv_rec.say_code);
940:
941:
942: IF (l_found <> OKL_API.G_TRUE ) THEN
943: OKC_API.set_message(G_OKC_APP, G_INVALID_VALUE,G_COL_NAME_TOKEN,'SPS_CODE');
944: x_return_status := Okc_Api.G_RET_STS_ERROR;
945: -- raise the exception as there's no matching foreign key value
946: RAISE G_EXCEPTION_HALT_VALIDATION;
947: END IF;

Line 944: x_return_status := Okc_Api.G_RET_STS_ERROR;

940:
941:
942: IF (l_found <> OKL_API.G_TRUE ) THEN
943: OKC_API.set_message(G_OKC_APP, G_INVALID_VALUE,G_COL_NAME_TOKEN,'SPS_CODE');
944: x_return_status := Okc_Api.G_RET_STS_ERROR;
945: -- raise the exception as there's no matching foreign key value
946: RAISE G_EXCEPTION_HALT_VALIDATION;
947: END IF;
948: END IF;

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

954: NULL;
955:
956: WHEN OTHERS THEN
957: -- store SQL error message on message stack for caller
958: Okc_Api.SET_MESSAGE(p_app_name => g_app_name,
959: p_msg_name => G_OKL_UNEXPECTED_ERROR,
960: p_token1 => G_OKL_SQLCODE_TOKEN,
961: p_token1_value => SQLCODE,
962: p_token2 => G_OKL_SQLERRM_TOKEN,

Line 966: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;

962: p_token2 => G_OKL_SQLERRM_TOKEN,
963: p_token2_value => SQLERRM);
964:
965: -- notify caller of an UNEXPECTED error
966: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;
967: END Validate_Say_Code;
968:
969:
970: ------------------------------------------------------------------------

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

984: x_return_status OUT NOCOPY VARCHAR2)
985:
986: IS
987:
988: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
989:
990: CURSOR stm_csr (p_stm_id NUMBER)
991: IS
992: SELECT ID

Line 1000: x_return_status := Okc_Api.G_RET_STS_SUCCESS;

996: l_stm_id NUMBER := NULL;
997:
998: BEGIN
999:
1000: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
1001:
1002: IF (p_stmv_rec.stm_id <> OKC_API.G_MISS_NUM) AND (p_stmv_rec.stm_id IS NOT NULL) THEN
1003:
1004: OPEN stm_csr(p_stmv_rec.stm_id);

Line 1002: IF (p_stmv_rec.stm_id <> OKC_API.G_MISS_NUM) AND (p_stmv_rec.stm_id IS NOT NULL) THEN

998: BEGIN
999:
1000: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
1001:
1002: IF (p_stmv_rec.stm_id <> OKC_API.G_MISS_NUM) AND (p_stmv_rec.stm_id IS NOT NULL) THEN
1003:
1004: OPEN stm_csr(p_stmv_rec.stm_id);
1005: FETCH stm_csr INTO l_stm_id;
1006: CLOSE stm_csr;

Line 1010: Okc_Api.SET_MESSAGE(p_app_name => G_OKC_APP

1006: CLOSE stm_csr;
1007:
1008: IF (l_stm_id IS NULL) THEN
1009:
1010: Okc_Api.SET_MESSAGE(p_app_name => G_OKC_APP
1011: ,p_msg_name => g_invalid_value
1012: ,p_token1 => g_col_name_token
1013: ,p_token1_value => 'stm_id');
1014: x_return_status := Okc_Api.G_RET_STS_ERROR;

Line 1014: x_return_status := Okc_Api.G_RET_STS_ERROR;

1010: Okc_Api.SET_MESSAGE(p_app_name => G_OKC_APP
1011: ,p_msg_name => g_invalid_value
1012: ,p_token1 => g_col_name_token
1013: ,p_token1_value => 'stm_id');
1014: x_return_status := Okc_Api.G_RET_STS_ERROR;
1015: RAISE G_EXCEPTION_HALT_VALIDATION;
1016: END IF;
1017:
1018: END IF;

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

1024: NULL;
1025:
1026: WHEN OTHERS THEN
1027: -- store SQL error message on message stack for caller
1028: Okc_Api.SET_MESSAGE(p_app_name => g_app_name,
1029: p_msg_name => G_OKL_UNEXPECTED_ERROR,
1030: p_token1 => G_OKL_SQLCODE_TOKEN,
1031: p_token1_value => SQLCODE,
1032: p_token2 => G_OKL_SQLERRM_TOKEN,

Line 1036: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;

1032: p_token2 => G_OKL_SQLERRM_TOKEN,
1033: p_token2_value => SQLERRM);
1034:
1035: -- notify caller of an UNEXPECTED error
1036: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;
1037:
1038: END Validate_stm_Id;
1039:
1040:

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

1054: PROCEDURE Validate_Source_Id_Table(p_stmv_rec IN stmv_rec_type,x_return_status OUT NOCOPY VARCHAR2)
1055:
1056: IS
1057:
1058: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1059: l_dummy VARCHAR2(1) := OKC_API.G_FALSE;
1060:
1061: BEGIN
1062: -- initialize return status

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

1055:
1056: IS
1057:
1058: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1059: l_dummy VARCHAR2(1) := OKC_API.G_FALSE;
1060:
1061: BEGIN
1062: -- initialize return status
1063: x_return_status := Okc_Api.G_RET_STS_SUCCESS;

Line 1063: x_return_status := Okc_Api.G_RET_STS_SUCCESS;

1059: l_dummy VARCHAR2(1) := OKC_API.G_FALSE;
1060:
1061: BEGIN
1062: -- initialize return status
1063: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
1064: -- check for data before processing
1065:
1066:
1067: IF (p_stmv_rec.source_id IS NOT NULL) THEN

Line 1070: Okc_Api.SET_MESSAGE(p_app_name => g_app_name

1066:
1067: IF (p_stmv_rec.source_id IS NOT NULL) THEN
1068:
1069: IF (p_stmv_rec.source_table IS NULL) THEN
1070: Okc_Api.SET_MESSAGE(p_app_name => g_app_name
1071: ,p_msg_name => g_invalid_value
1072: ,p_token1 => g_col_name_token
1073: ,p_token1_value => 'SOURCE_TABLE');
1074: x_return_status := Okc_Api.G_RET_STS_ERROR;

Line 1074: x_return_status := Okc_Api.G_RET_STS_ERROR;

1070: Okc_Api.SET_MESSAGE(p_app_name => g_app_name
1071: ,p_msg_name => g_invalid_value
1072: ,p_token1 => g_col_name_token
1073: ,p_token1_value => 'SOURCE_TABLE');
1074: x_return_status := Okc_Api.G_RET_STS_ERROR;
1075: RAISE G_EXCEPTION_HALT_VALIDATION;
1076: ELSE
1077: l_dummy := OKL_ACCOUNTING_UTIL.VALIDATE_LOOKUP_CODE(p_lookup_type => 'OKL_STM_SOURCE',
1078: p_lookup_code => p_stmv_rec.source_table);

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

1076: ELSE
1077: l_dummy := OKL_ACCOUNTING_UTIL.VALIDATE_LOOKUP_CODE(p_lookup_type => 'OKL_STM_SOURCE',
1078: p_lookup_code => p_stmv_rec.source_table);
1079:
1080: IF (l_dummy = Okc_Api.G_FALSE) THEN
1081: Okc_Api.SET_MESSAGE(p_app_name => g_app_name
1082: ,p_msg_name => g_invalid_value
1083: ,p_token1 => g_col_name_token
1084: ,p_token1_value => 'SOURCE_TABLE');

Line 1081: Okc_Api.SET_MESSAGE(p_app_name => g_app_name

1077: l_dummy := OKL_ACCOUNTING_UTIL.VALIDATE_LOOKUP_CODE(p_lookup_type => 'OKL_STM_SOURCE',
1078: p_lookup_code => p_stmv_rec.source_table);
1079:
1080: IF (l_dummy = Okc_Api.G_FALSE) THEN
1081: Okc_Api.SET_MESSAGE(p_app_name => g_app_name
1082: ,p_msg_name => g_invalid_value
1083: ,p_token1 => g_col_name_token
1084: ,p_token1_value => 'SOURCE_TABLE');
1085: x_return_status := Okc_Api.G_RET_STS_ERROR;

Line 1085: x_return_status := Okc_Api.G_RET_STS_ERROR;

1081: Okc_Api.SET_MESSAGE(p_app_name => g_app_name
1082: ,p_msg_name => g_invalid_value
1083: ,p_token1 => g_col_name_token
1084: ,p_token1_value => 'SOURCE_TABLE');
1085: x_return_status := Okc_Api.G_RET_STS_ERROR;
1086: RAISE G_EXCEPTION_HALT_VALIDATION;
1087: END IF;
1088: END IF;
1089:

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

1098: NULL;
1099:
1100: WHEN OTHERS THEN
1101: -- store SQL error message on message stack for caller
1102: Okc_Api.SET_MESSAGE(p_app_name => g_app_name,
1103: p_msg_name => g_okl_unexpected_error,
1104: p_token1 => g_okl_sqlcode_token,
1105: p_token1_value => SQLCODE,
1106: p_token2 => g_okl_sqlerrm_token,

Line 1110: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;

1106: p_token2 => g_okl_sqlerrm_token,
1107: p_token2_value => SQLERRM);
1108:
1109: -- notify caller of an UNEXPECTED error
1110: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;
1111:
1112: END Validate_Source_Id_Table;
1113:
1114:

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

1135: FUNCTION Validate_Attributes (
1136: p_stmv_rec IN stmv_rec_type
1137: ) RETURN VARCHAR2 IS
1138:
1139: x_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1140: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1141: BEGIN
1142:
1143: -- call each column-level validation

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

1136: p_stmv_rec IN stmv_rec_type
1137: ) RETURN VARCHAR2 IS
1138:
1139: x_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1140: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1141: BEGIN
1142:
1143: -- call each column-level validation
1144:

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

1144:
1145: -- Validate_Id
1146: Validate_Id(p_stmv_rec, x_return_status);
1147: -- store the highest degree of error
1148: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
1149: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1150: -- need to leave
1151: l_return_status := x_return_status;
1152: RAISE G_EXCEPTION_HALT_VALIDATION;

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

1145: -- Validate_Id
1146: Validate_Id(p_stmv_rec, x_return_status);
1147: -- store the highest degree of error
1148: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
1149: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1150: -- need to leave
1151: l_return_status := x_return_status;
1152: RAISE G_EXCEPTION_HALT_VALIDATION;
1153: ELSE

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

1158:
1159: -- Validate_Object_Version_Number
1160: Validate_Object_Version_Number(p_stmv_rec, x_return_status);
1161: -- store the highest degree of error
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: -- Validate_Object_Version_Number
1160: Validate_Object_Version_Number(p_stmv_rec, x_return_status);
1161: -- store the highest degree of error
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 1176: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN

1172:
1173: -- Validate_Sty_Id
1174: Validate_Sty_Id(p_stmv_rec, x_return_status);
1175: -- store the highest degree of error
1176: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
1177: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1178: -- need to leave
1179: l_return_status := x_return_status;
1180: RAISE G_EXCEPTION_HALT_VALIDATION;

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

1173: -- Validate_Sty_Id
1174: Validate_Sty_Id(p_stmv_rec, x_return_status);
1175: -- store the highest degree of error
1176: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
1177: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1178: -- need to leave
1179: l_return_status := x_return_status;
1180: RAISE G_EXCEPTION_HALT_VALIDATION;
1181: ELSE

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

1187: IF (p_stmv_rec.khr_id IS NULL) THEN
1188: -- Validate_Kle_Id
1189: Validate_Kle_Id(p_stmv_rec, x_return_status);
1190: -- store the highest degree of error
1191: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
1192: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1193: -- need to leave
1194: l_return_status := x_return_status;
1195: RAISE G_EXCEPTION_HALT_VALIDATION;

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

1188: -- Validate_Kle_Id
1189: Validate_Kle_Id(p_stmv_rec, x_return_status);
1190: -- store the highest degree of error
1191: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
1192: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1193: -- need to leave
1194: l_return_status := x_return_status;
1195: RAISE G_EXCEPTION_HALT_VALIDATION;
1196: ELSE

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

1200: END IF;
1201: ELSIF (p_stmv_rec.kle_id IS NULL) THEN
1202: Validate_Khr_Id(p_stmv_rec, x_return_status);
1203: -- store the highest degree of error
1204: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
1205: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1206: -- need to leave
1207: l_return_status := x_return_status;
1208: RAISE G_EXCEPTION_HALT_VALIDATION;

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

1201: ELSIF (p_stmv_rec.kle_id IS NULL) THEN
1202: Validate_Khr_Id(p_stmv_rec, x_return_status);
1203: -- store the highest degree of error
1204: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
1205: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1206: -- need to leave
1207: l_return_status := x_return_status;
1208: RAISE G_EXCEPTION_HALT_VALIDATION;
1209: ELSE

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

1215: ELSE
1216: -- Validate_Khr_Id
1217: Validate_Khr_Id(p_stmv_rec, x_return_status);
1218: -- store the highest degree of error
1219: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
1220: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1221: -- need to leave
1222: l_return_status := x_return_status;
1223: RAISE G_EXCEPTION_HALT_VALIDATION;

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

1216: -- Validate_Khr_Id
1217: Validate_Khr_Id(p_stmv_rec, x_return_status);
1218: -- store the highest degree of error
1219: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
1220: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1221: -- need to leave
1222: l_return_status := x_return_status;
1223: RAISE G_EXCEPTION_HALT_VALIDATION;
1224: ELSE

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

1228: END IF;
1229: -- Validate_Kle_Id
1230: Validate_Kle_Id(p_stmv_rec, x_return_status);
1231: -- store the highest degree of error
1232: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
1233: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1234: -- need to leave
1235: l_return_status := x_return_status;
1236: RAISE G_EXCEPTION_HALT_VALIDATION;

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

1229: -- Validate_Kle_Id
1230: Validate_Kle_Id(p_stmv_rec, x_return_status);
1231: -- store the highest degree of error
1232: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
1233: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1234: -- need to leave
1235: l_return_status := x_return_status;
1236: RAISE G_EXCEPTION_HALT_VALIDATION;
1237: ELSE

Line 1248: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

1244:
1245: -- Validate_Sgn_Code
1246: Validate_Sgn_Code(p_stmv_rec, x_return_status);
1247: -- store the highest degree of error
1248: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1249: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1250: -- need to leave
1251: l_return_status := x_return_status;
1252: RAISE G_EXCEPTION_HALT_VALIDATION;

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

1245: -- Validate_Sgn_Code
1246: Validate_Sgn_Code(p_stmv_rec, x_return_status);
1247: -- store the highest degree of error
1248: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1249: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1250: -- need to leave
1251: l_return_status := x_return_status;
1252: RAISE G_EXCEPTION_HALT_VALIDATION;
1253: ELSE

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

1258:
1259: -- Validate_Say_Code
1260: Validate_Say_Code(p_stmv_rec, x_return_status);
1261: -- store the highest degree of error
1262: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
1263: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1264: -- need to leave
1265: l_return_status := x_return_status;
1266: RAISE G_EXCEPTION_HALT_VALIDATION;

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

1259: -- Validate_Say_Code
1260: Validate_Say_Code(p_stmv_rec, x_return_status);
1261: -- store the highest degree of error
1262: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
1263: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1264: -- need to leave
1265: l_return_status := x_return_status;
1266: RAISE G_EXCEPTION_HALT_VALIDATION;
1267: ELSE

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

1273:
1274: -- Validate_Transaction_Number
1275: Validate_Transaction_Number(p_stmv_rec, x_return_status);
1276: -- store the highest degree of error
1277: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
1278: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1279: l_return_status := x_return_status;
1280: RAISE G_EXCEPTION_HALT_VALIDATION;
1281: ELSE

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

1274: -- Validate_Transaction_Number
1275: Validate_Transaction_Number(p_stmv_rec, x_return_status);
1276: -- store the highest degree of error
1277: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
1278: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1279: l_return_status := x_return_status;
1280: RAISE G_EXCEPTION_HALT_VALIDATION;
1281: ELSE
1282: l_return_status := x_return_status;

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

1287:
1288: -- Validate_active_yn
1289: Validate_Active_yn(p_stmv_rec, x_return_status);
1290: -- store the highest degree of error
1291: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
1292: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1293: -- need to leave
1294: l_return_status := x_return_status;
1295: RAISE G_EXCEPTION_HALT_VALIDATION;

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

1288: -- Validate_active_yn
1289: Validate_Active_yn(p_stmv_rec, x_return_status);
1290: -- store the highest degree of error
1291: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
1292: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1293: -- need to leave
1294: l_return_status := x_return_status;
1295: RAISE G_EXCEPTION_HALT_VALIDATION;
1296: ELSE

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

1301:
1302: -- Validate_stm_id
1303: Validate_stm_id(p_stmv_rec, x_return_status);
1304: -- store the highest degree of error
1305: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
1306: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1307: -- need to leave
1308: l_return_status := x_return_status;
1309: RAISE G_EXCEPTION_HALT_VALIDATION;

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

1302: -- Validate_stm_id
1303: Validate_stm_id(p_stmv_rec, x_return_status);
1304: -- store the highest degree of error
1305: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
1306: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1307: -- need to leave
1308: l_return_status := x_return_status;
1309: RAISE G_EXCEPTION_HALT_VALIDATION;
1310: ELSE

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

1316: -- Added by Keerthi for Bug 3166890
1317: -- Validate_source_id_table
1318: Validate_Source_Id_Table(p_stmv_rec, x_return_status);
1319: -- store the highest degree of error
1320: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
1321: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1322: -- need to leave
1323: l_return_status := x_return_status;
1324: RAISE G_EXCEPTION_HALT_VALIDATION;

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

1317: -- Validate_source_id_table
1318: Validate_Source_Id_Table(p_stmv_rec, x_return_status);
1319: -- store the highest degree of error
1320: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
1321: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1322: -- need to leave
1323: l_return_status := x_return_status;
1324: RAISE G_EXCEPTION_HALT_VALIDATION;
1325: ELSE

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

1338: RETURN (l_return_status);
1339:
1340: WHEN OTHERS THEN
1341: -- store SQL error message on message stack for caller
1342: Okc_Api.SET_MESSAGE(p_app_name => g_app_name,
1343: p_msg_name => G_OKL_UNEXPECTED_ERROR,
1344: p_token1 => G_OKL_SQLCODE_TOKEN,
1345: p_token1_value => SQLCODE,
1346: p_token2 => G_OKL_SQLERRM_TOKEN,

Line 1351: l_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;

1347: p_token2_value => SQLERRM);
1348:
1349:
1350: -- notify caller of an UNEXPECTED error
1351: l_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;
1352: RETURN(l_return_status);
1353:
1354: END Validate_Attributes;
1355:

Line 1387: x_return_status := Okc_Api.G_RET_STS_SUCCESS;

1383: AND id <> NVL(p_rec.id,-9999);
1384:
1385: BEGIN
1386: -- initialize return status
1387: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
1388: OPEN okl_stm_uk_csr(p_stmv_rec);
1389: FETCH okl_stm_uk_csr INTO l_dummy;
1390: l_row_found := okl_stm_uk_csr%FOUND;
1391: CLOSE okl_stm_uk_csr;

Line 1393: Okc_Api.set_message(G_APP_NAME,G_OKL_UNQS);

1389: FETCH okl_stm_uk_csr INTO l_dummy;
1390: l_row_found := okl_stm_uk_csr%FOUND;
1391: CLOSE okl_stm_uk_csr;
1392: IF l_row_found THEN
1393: Okc_Api.set_message(G_APP_NAME,G_OKL_UNQS);
1394: x_return_status := Okc_Api.G_RET_STS_ERROR;
1395: END IF;
1396:
1397: EXCEPTION

Line 1394: x_return_status := Okc_Api.G_RET_STS_ERROR;

1390: l_row_found := okl_stm_uk_csr%FOUND;
1391: CLOSE okl_stm_uk_csr;
1392: IF l_row_found THEN
1393: Okc_Api.set_message(G_APP_NAME,G_OKL_UNQS);
1394: x_return_status := Okc_Api.G_RET_STS_ERROR;
1395: END IF;
1396:
1397: EXCEPTION
1398: WHEN G_EXCEPTION_HALT_VALIDATION THEN

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

1401: NULL;
1402:
1403: WHEN OTHERS THEN
1404: -- store SQL error message on message stack for caller
1405: Okc_Api.SET_MESSAGE(p_app_name => g_app_name,
1406: p_msg_name => G_OKL_UNEXPECTED_ERROR,
1407: p_token1 => G_OKL_SQLCODE_TOKEN,
1408: p_token1_value => SQLCODE,
1409: p_token2 => G_OKL_SQLERRM_TOKEN,

Line 1413: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;

1409: p_token2 => G_OKL_SQLERRM_TOKEN,
1410: p_token2_value => SQLERRM);
1411:
1412: -- notify caller of an UNEXPECTED error
1413: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;
1414:
1415: END Validate_Unique_Stm_Record;
1416:
1417: ---------------------------------------------------------------------------

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

1429:
1430: FUNCTION Validate_Record (
1431: p_stmv_rec IN stmv_rec_type
1432: ) RETURN VARCHAR2 IS
1433: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1434: x_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1435: BEGIN
1436: -- Validate_Unique_stm_Record
1437: Validate_Unique_Stm_Record(p_stmv_rec, x_return_status);

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

1430: FUNCTION Validate_Record (
1431: p_stmv_rec IN stmv_rec_type
1432: ) RETURN VARCHAR2 IS
1433: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1434: x_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1435: BEGIN
1436: -- Validate_Unique_stm_Record
1437: Validate_Unique_Stm_Record(p_stmv_rec, x_return_status);
1438: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN

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

1434: x_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1435: BEGIN
1436: -- Validate_Unique_stm_Record
1437: Validate_Unique_Stm_Record(p_stmv_rec, x_return_status);
1438: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
1439: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1440: -- need to leave
1441: l_return_status := x_return_status;
1442: RAISE G_EXCEPTION_HALT_VALIDATION;

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

1435: BEGIN
1436: -- Validate_Unique_stm_Record
1437: Validate_Unique_Stm_Record(p_stmv_rec, x_return_status);
1438: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
1439: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1440: -- need to leave
1441: l_return_status := x_return_status;
1442: RAISE G_EXCEPTION_HALT_VALIDATION;
1443: ELSE

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

1454: RETURN (l_return_status);
1455:
1456: WHEN OTHERS THEN
1457: -- store SQL error message on message stack for caller
1458: Okc_Api.SET_MESSAGE(p_app_name => g_app_name,
1459: p_msg_name => G_OKL_UNEXPECTED_ERROR,
1460: p_token1 => G_OKL_SQLCODE_TOKEN,
1461: p_token1_value => SQLCODE,
1462: p_token2 => G_OKL_SQLERRM_TOKEN,

Line 1465: l_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;

1461: p_token1_value => SQLCODE,
1462: p_token2 => G_OKL_SQLERRM_TOKEN,
1463: p_token2_value => SQLERRM);
1464: -- notify caller of an UNEXPECTED error
1465: l_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;
1466: RETURN(l_return_status);
1467: END Validate_Record;
1468: -- END change : mvasudev
1469:

Line 1562: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

1558: ------------------------------------
1559:
1560: PROCEDURE validate_row(
1561: p_api_version IN NUMBER,
1562: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1563: x_return_status OUT NOCOPY VARCHAR2,
1564: x_msg_count OUT NOCOPY NUMBER,
1565: x_msg_data OUT NOCOPY VARCHAR2,
1566: p_stmv_rec IN stmv_rec_type) IS

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

1566: p_stmv_rec IN stmv_rec_type) IS
1567:
1568: l_api_version CONSTANT NUMBER := 1;
1569: l_api_name CONSTANT VARCHAR2(30) := 'V_validate_row';
1570: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1571: l_stmv_rec stmv_rec_type := p_stmv_rec;
1572: l_stm_rec stm_rec_type;
1573: BEGIN
1574: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 1574: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

1570: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1571: l_stmv_rec stmv_rec_type := p_stmv_rec;
1572: l_stm_rec stm_rec_type;
1573: BEGIN
1574: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1575: G_PKG_NAME,
1576: p_init_msg_list,
1577: l_api_version,
1578: p_api_version,

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

1577: l_api_version,
1578: p_api_version,
1579: '_PVT',
1580: x_return_status);
1581: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1582:
1583:
1584: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1585: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 1584: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1580: x_return_status);
1581: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1582:
1583:
1584: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1585: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1586: RAISE OKC_API.G_EXCEPTION_ERROR;
1587: END IF;
1588: --- Validate all non-missing attributes (Item Level Validation)

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

1581: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1582:
1583:
1584: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1585: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1586: RAISE OKC_API.G_EXCEPTION_ERROR;
1587: END IF;
1588: --- Validate all non-missing attributes (Item Level Validation)
1589: l_return_status := Validate_Attributes(l_stmv_rec);

Line 1586: RAISE OKC_API.G_EXCEPTION_ERROR;

1582:
1583:
1584: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1585: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1586: RAISE OKC_API.G_EXCEPTION_ERROR;
1587: END IF;
1588: --- Validate all non-missing attributes (Item Level Validation)
1589: l_return_status := Validate_Attributes(l_stmv_rec);
1590: --- If any errors happen abort API

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

1587: END IF;
1588: --- Validate all non-missing attributes (Item Level Validation)
1589: l_return_status := Validate_Attributes(l_stmv_rec);
1590: --- If any errors happen abort API
1591: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1592:
1593:
1594: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1595: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 1594: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1590: --- If any errors happen abort API
1591: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1592:
1593:
1594: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1595: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1596:
1597: RAISE OKC_API.G_EXCEPTION_ERROR;
1598: END IF;

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

1591: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1592:
1593:
1594: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1595: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1596:
1597: RAISE OKC_API.G_EXCEPTION_ERROR;
1598: END IF;
1599:

Line 1597: RAISE OKC_API.G_EXCEPTION_ERROR;

1593:
1594: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1595: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1596:
1597: RAISE OKC_API.G_EXCEPTION_ERROR;
1598: END IF;
1599:
1600: l_return_status := Validate_Record(l_stmv_rec);
1601:

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

1598: END IF;
1599:
1600: l_return_status := Validate_Record(l_stmv_rec);
1601:
1602: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1603:
1604:
1605: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1606: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 1605: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1601:
1602: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1603:
1604:
1605: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1606: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1607: RAISE OKC_API.G_EXCEPTION_ERROR;
1608: END IF;
1609: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

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

1602: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1603:
1604:
1605: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1606: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1607: RAISE OKC_API.G_EXCEPTION_ERROR;
1608: END IF;
1609: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1610: EXCEPTION

Line 1607: RAISE OKC_API.G_EXCEPTION_ERROR;

1603:
1604:
1605: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1606: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1607: RAISE OKC_API.G_EXCEPTION_ERROR;
1608: END IF;
1609: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1610: EXCEPTION
1611: WHEN OKC_API.G_EXCEPTION_ERROR THEN

Line 1609: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

1605: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1606: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1607: RAISE OKC_API.G_EXCEPTION_ERROR;
1608: END IF;
1609: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1610: EXCEPTION
1611: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1612:
1613: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 1611: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1607: RAISE OKC_API.G_EXCEPTION_ERROR;
1608: END IF;
1609: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1610: EXCEPTION
1611: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1612:
1613: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1614: (
1615: l_api_name,

Line 1613: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1609: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1610: EXCEPTION
1611: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1612:
1613: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1614: (
1615: l_api_name,
1616: G_PKG_NAME,
1617: 'OKC_API.G_RET_STS_ERROR',

Line 1617: 'OKC_API.G_RET_STS_ERROR',

1613: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1614: (
1615: l_api_name,
1616: G_PKG_NAME,
1617: 'OKC_API.G_RET_STS_ERROR',
1618: x_msg_count,
1619: x_msg_data,
1620: '_PVT'
1621: );

Line 1622: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1618: x_msg_count,
1619: x_msg_data,
1620: '_PVT'
1621: );
1622: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1623:
1624: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1625: (
1626: l_api_name,

Line 1624: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1620: '_PVT'
1621: );
1622: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1623:
1624: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1625: (
1626: l_api_name,
1627: G_PKG_NAME,
1628: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1628: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1624: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1625: (
1626: l_api_name,
1627: G_PKG_NAME,
1628: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1629: x_msg_count,
1630: x_msg_data,
1631: '_PVT'
1632: );

Line 1635: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1631: '_PVT'
1632: );
1633: WHEN OTHERS THEN
1634:
1635: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1636: (
1637: l_api_name,
1638: G_PKG_NAME,
1639: 'OTHERS',

Line 1650: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

1646: -- PL/SQL TBL validate_row for:STMV_TBL --
1647: ------------------------------------------
1648: PROCEDURE validate_row(
1649: p_api_version IN NUMBER,
1650: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1651: x_return_status OUT NOCOPY VARCHAR2,
1652: x_msg_count OUT NOCOPY NUMBER,
1653: x_msg_data OUT NOCOPY VARCHAR2,
1654: p_stmv_tbl IN stmv_tbl_type) IS

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

1654: p_stmv_tbl IN stmv_tbl_type) IS
1655:
1656: l_api_version CONSTANT NUMBER := 1;
1657: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_validate_row';
1658: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1659: l_overall_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1660: i NUMBER := 0;
1661: BEGIN
1662: OKC_API.init_msg_list(p_init_msg_list);

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

1655:
1656: l_api_version CONSTANT NUMBER := 1;
1657: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_validate_row';
1658: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1659: l_overall_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1660: i NUMBER := 0;
1661: BEGIN
1662: OKC_API.init_msg_list(p_init_msg_list);
1663: -- Make sure PL/SQL table has records in it before passing

Line 1662: OKC_API.init_msg_list(p_init_msg_list);

1658: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1659: l_overall_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1660: i NUMBER := 0;
1661: BEGIN
1662: OKC_API.init_msg_list(p_init_msg_list);
1663: -- Make sure PL/SQL table has records in it before passing
1664: IF (p_stmv_tbl.COUNT > 0) THEN
1665: i := p_stmv_tbl.FIRST;
1666: LOOP

Line 1669: p_init_msg_list => OKC_API.G_FALSE,

1665: i := p_stmv_tbl.FIRST;
1666: LOOP
1667: validate_row (
1668: p_api_version => p_api_version,
1669: p_init_msg_list => OKC_API.G_FALSE,
1670: x_return_status => x_return_status,
1671: x_msg_count => x_msg_count,
1672: x_msg_data => x_msg_data,
1673: p_stmv_rec => p_stmv_tbl(i));

Line 1676: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN

1672: x_msg_data => x_msg_data,
1673: p_stmv_rec => p_stmv_tbl(i));
1674: /* Begin Post Generation Change */
1675: -- store the highest degree of error
1676: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
1677: IF l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR THEN
1678: l_overall_status := x_return_status;
1679: END IF;
1680: END IF;

Line 1677: IF l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR THEN

1673: p_stmv_rec => p_stmv_tbl(i));
1674: /* Begin Post Generation Change */
1675: -- store the highest degree of error
1676: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
1677: IF l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR THEN
1678: l_overall_status := x_return_status;
1679: END IF;
1680: END IF;
1681: /* End Post Generation Change */

Line 1690: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1686: -- return overall status
1687: x_return_status :=l_overall_status;
1688: END IF;
1689: EXCEPTION
1690: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1691: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1692: (
1693: l_api_name,
1694: G_PKG_NAME,

Line 1691: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1687: x_return_status :=l_overall_status;
1688: END IF;
1689: EXCEPTION
1690: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1691: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1692: (
1693: l_api_name,
1694: G_PKG_NAME,
1695: 'OKC_API.G_RET_STS_ERROR',

Line 1695: 'OKC_API.G_RET_STS_ERROR',

1691: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1692: (
1693: l_api_name,
1694: G_PKG_NAME,
1695: 'OKC_API.G_RET_STS_ERROR',
1696: x_msg_count,
1697: x_msg_data,
1698: '_PVT'
1699: );

Line 1700: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1696: x_msg_count,
1697: x_msg_data,
1698: '_PVT'
1699: );
1700: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1701:
1702: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1703: (
1704: l_api_name,

Line 1702: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1698: '_PVT'
1699: );
1700: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1701:
1702: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1703: (
1704: l_api_name,
1705: G_PKG_NAME,
1706: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1706: 'OKC_API.G_RET_STS_UNEXP_ERROR',

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

Line 1712: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

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

Line 1730: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

1726: --------------------------------
1727: -- insert_row for:OKL_STREAMS --
1728: --------------------------------
1729: PROCEDURE insert_row(
1730: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1731: x_return_status OUT NOCOPY VARCHAR2,
1732: x_msg_count OUT NOCOPY NUMBER,
1733: x_msg_data OUT NOCOPY VARCHAR2,
1734: p_stm_rec IN stm_rec_type,

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

1735: x_stm_rec OUT NOCOPY stm_rec_type) IS
1736:
1737: l_api_version CONSTANT NUMBER := 1;
1738: l_api_name CONSTANT VARCHAR2(30) := 'STREAMS_insert_row';
1739: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1740: l_stm_rec stm_rec_type := p_stm_rec;
1741: l_def_stm_rec stm_rec_type;
1742: ------------------------------------
1743: -- Set_Attributes for:OKL_STREAMS --

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

1745: FUNCTION Set_Attributes (
1746: p_stm_rec IN stm_rec_type,
1747: x_stm_rec OUT NOCOPY stm_rec_type
1748: ) RETURN VARCHAR2 IS
1749: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1750: BEGIN
1751: x_stm_rec := p_stm_rec;
1752: RETURN(l_return_status);
1753: END Set_Attributes;

Line 1755: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

1751: x_stm_rec := p_stm_rec;
1752: RETURN(l_return_status);
1753: END Set_Attributes;
1754: BEGIN
1755: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1756: p_init_msg_list,
1757: '_PVT',
1758: x_return_status);
1759: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

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

1755: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1756: p_init_msg_list,
1757: '_PVT',
1758: x_return_status);
1759: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1760:
1761:
1762: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1763: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 1762: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1758: x_return_status);
1759: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1760:
1761:
1762: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1763: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1764: RAISE OKC_API.G_EXCEPTION_ERROR;
1765: END IF;
1766: --- Setting item attributes

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

1759: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1760:
1761:
1762: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1763: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1764: RAISE OKC_API.G_EXCEPTION_ERROR;
1765: END IF;
1766: --- Setting item attributes
1767: l_return_status := Set_Attributes(

Line 1764: RAISE OKC_API.G_EXCEPTION_ERROR;

1760:
1761:
1762: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1763: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1764: RAISE OKC_API.G_EXCEPTION_ERROR;
1765: END IF;
1766: --- Setting item attributes
1767: l_return_status := Set_Attributes(
1768: p_stm_rec, -- IN

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

1767: l_return_status := Set_Attributes(
1768: p_stm_rec, -- IN
1769: l_stm_rec); -- OUT
1770: --- If any errors happen abort API
1771: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1772:
1773:
1774: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1775: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 1774: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1770: --- If any errors happen abort API
1771: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1772:
1773:
1774: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1775: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1776: RAISE OKC_API.G_EXCEPTION_ERROR;
1777: END IF;
1778:

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

1771: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1772:
1773:
1774: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1775: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1776: RAISE OKC_API.G_EXCEPTION_ERROR;
1777: END IF;
1778:
1779: INSERT INTO OKL_STREAMS(

Line 1776: RAISE OKC_API.G_EXCEPTION_ERROR;

1772:
1773:
1774: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1775: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1776: RAISE OKC_API.G_EXCEPTION_ERROR;
1777: END IF;
1778:
1779: INSERT INTO OKL_STREAMS(
1780: id,

Line 1851: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

1847: );
1848:
1849: -- Set OUT values
1850: x_stm_rec := l_stm_rec;
1851: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1852: EXCEPTION
1853: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1854:
1855: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 1853: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1849: -- Set OUT values
1850: x_stm_rec := l_stm_rec;
1851: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1852: EXCEPTION
1853: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1854:
1855: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1856: (
1857: l_api_name,

Line 1855: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1851: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1852: EXCEPTION
1853: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1854:
1855: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1856: (
1857: l_api_name,
1858: G_PKG_NAME,
1859: 'OKC_API.G_RET_STS_ERROR',

Line 1859: 'OKC_API.G_RET_STS_ERROR',

1855: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1856: (
1857: l_api_name,
1858: G_PKG_NAME,
1859: 'OKC_API.G_RET_STS_ERROR',
1860: x_msg_count,
1861: x_msg_data,
1862: '_PVT'
1863: );

Line 1864: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1860: x_msg_count,
1861: x_msg_data,
1862: '_PVT'
1863: );
1864: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1865:
1866: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1867: (
1868: l_api_name,

Line 1866: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1862: '_PVT'
1863: );
1864: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1865:
1866: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1867: (
1868: l_api_name,
1869: G_PKG_NAME,
1870: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1870: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1866: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1867: (
1868: l_api_name,
1869: G_PKG_NAME,
1870: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1871: x_msg_count,
1872: x_msg_data,
1873: '_PVT'
1874: );

Line 1877: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1873: '_PVT'
1874: );
1875: WHEN OTHERS THEN
1876:
1877: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1878: (
1879: l_api_name,
1880: G_PKG_NAME,
1881: 'OTHERS',

Line 1892: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

1888: -- insert_row for:OKL_STREAMS_V --
1889: ----------------------------------
1890: PROCEDURE insert_row(
1891: p_api_version IN NUMBER,
1892: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1893: x_return_status OUT NOCOPY VARCHAR2,
1894: x_msg_count OUT NOCOPY NUMBER,
1895: x_msg_data OUT NOCOPY VARCHAR2,
1896: p_stmv_rec IN stmv_rec_type,

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

1897: x_stmv_rec OUT NOCOPY stmv_rec_type) IS
1898:
1899: l_api_version CONSTANT NUMBER := 1;
1900: l_api_name CONSTANT VARCHAR2(30) := 'V_insert_row';
1901: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1902: l_stmv_rec stmv_rec_type;
1903: l_def_stmv_rec stmv_rec_type;
1904: l_stm_rec stm_rec_type;
1905: lx_stm_rec stm_rec_type;

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

1924: FUNCTION Set_Attributes (
1925: p_stmv_rec IN stmv_rec_type,
1926: x_stmv_rec OUT NOCOPY stmv_rec_type
1927: ) RETURN VARCHAR2 IS
1928: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1929: BEGIN
1930: x_stmv_rec := p_stmv_rec;
1931: x_stmv_rec.OBJECT_VERSION_NUMBER := 1;
1932: SELECT DECODE(Fnd_Global.CONC_REQUEST_ID, -1, NULL, Fnd_Global.CONC_REQUEST_ID),

Line 1962: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

1958: RETURN(l_return_status);
1959: END Set_Attributes;
1960: BEGIN
1961:
1962: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1963: G_PKG_NAME,
1964: p_init_msg_list,
1965: l_api_version,
1966: p_api_version,

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

1966: p_api_version,
1967: '_PVT',
1968: x_return_status);
1969:
1970: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1971:
1972:
1973: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1974: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 1973: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1969:
1970: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1971:
1972:
1973: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1974: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1975:
1976: RAISE OKC_API.G_EXCEPTION_ERROR;
1977: END IF;

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

1970: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1971:
1972:
1973: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1974: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1975:
1976: RAISE OKC_API.G_EXCEPTION_ERROR;
1977: END IF;
1978: l_stmv_rec := null_out_defaults(p_stmv_rec);

Line 1976: RAISE OKC_API.G_EXCEPTION_ERROR;

1972:
1973: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1974: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1975:
1976: RAISE OKC_API.G_EXCEPTION_ERROR;
1977: END IF;
1978: l_stmv_rec := null_out_defaults(p_stmv_rec);
1979: -- Set primary key value
1980: l_stmv_rec.ID := get_seq_id;

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

1982: l_return_status := Set_Attributes(
1983: l_stmv_rec, -- IN
1984: l_def_stmv_rec); -- OUT
1985: --- If any errors happen abort API
1986: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1987:
1988: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1989: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1990: RAISE OKC_API.G_EXCEPTION_ERROR;

Line 1988: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1984: l_def_stmv_rec); -- OUT
1985: --- If any errors happen abort API
1986: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1987:
1988: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1989: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1990: RAISE OKC_API.G_EXCEPTION_ERROR;
1991: END IF;
1992: l_def_stmv_rec := fill_who_columns(l_def_stmv_rec);

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

1985: --- If any errors happen abort API
1986: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1987:
1988: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1989: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1990: RAISE OKC_API.G_EXCEPTION_ERROR;
1991: END IF;
1992: l_def_stmv_rec := fill_who_columns(l_def_stmv_rec);
1993: --- Validate all non-missing attributes (Item Level Validation)

Line 1990: RAISE OKC_API.G_EXCEPTION_ERROR;

1986: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1987:
1988: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1989: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1990: RAISE OKC_API.G_EXCEPTION_ERROR;
1991: END IF;
1992: l_def_stmv_rec := fill_who_columns(l_def_stmv_rec);
1993: --- Validate all non-missing attributes (Item Level Validation)
1994: l_return_status := Validate_Attributes(l_def_stmv_rec);

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

1992: l_def_stmv_rec := fill_who_columns(l_def_stmv_rec);
1993: --- Validate all non-missing attributes (Item Level Validation)
1994: l_return_status := Validate_Attributes(l_def_stmv_rec);
1995: --- If any errors happen abort API
1996: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1997:
1998: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1999: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2000: RAISE OKC_API.G_EXCEPTION_ERROR;

Line 1998: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1994: l_return_status := Validate_Attributes(l_def_stmv_rec);
1995: --- If any errors happen abort API
1996: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1997:
1998: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1999: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2000: RAISE OKC_API.G_EXCEPTION_ERROR;
2001: END IF;
2002: l_return_status := Validate_Record(l_def_stmv_rec);

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

1995: --- If any errors happen abort API
1996: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1997:
1998: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1999: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2000: RAISE OKC_API.G_EXCEPTION_ERROR;
2001: END IF;
2002: l_return_status := Validate_Record(l_def_stmv_rec);
2003: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 2000: RAISE OKC_API.G_EXCEPTION_ERROR;

1996: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1997:
1998: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1999: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2000: RAISE OKC_API.G_EXCEPTION_ERROR;
2001: END IF;
2002: l_return_status := Validate_Record(l_def_stmv_rec);
2003: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2004:

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

1999: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2000: RAISE OKC_API.G_EXCEPTION_ERROR;
2001: END IF;
2002: l_return_status := Validate_Record(l_def_stmv_rec);
2003: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2004:
2005: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2006: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2007: RAISE OKC_API.G_EXCEPTION_ERROR;

Line 2005: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2001: END IF;
2002: l_return_status := Validate_Record(l_def_stmv_rec);
2003: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2004:
2005: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2006: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2007: RAISE OKC_API.G_EXCEPTION_ERROR;
2008: END IF;
2009: --------------------------------------

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

2002: l_return_status := Validate_Record(l_def_stmv_rec);
2003: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2004:
2005: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2006: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2007: RAISE OKC_API.G_EXCEPTION_ERROR;
2008: END IF;
2009: --------------------------------------
2010: -- Move VIEW record to "Child" records

Line 2007: RAISE OKC_API.G_EXCEPTION_ERROR;

2003: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2004:
2005: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2006: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2007: RAISE OKC_API.G_EXCEPTION_ERROR;
2008: END IF;
2009: --------------------------------------
2010: -- Move VIEW record to "Child" records
2011: --------------------------------------

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

2021: x_msg_data,
2022: l_stm_rec,
2023: lx_stm_rec
2024: );
2025: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2026:
2027: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2028: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2029: RAISE OKC_API.G_EXCEPTION_ERROR;

Line 2027: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2023: lx_stm_rec
2024: );
2025: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2026:
2027: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2028: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2029: RAISE OKC_API.G_EXCEPTION_ERROR;
2030: END IF;
2031: migrate(lx_stm_rec, l_def_stmv_rec);

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

2024: );
2025: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2026:
2027: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2028: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2029: RAISE OKC_API.G_EXCEPTION_ERROR;
2030: END IF;
2031: migrate(lx_stm_rec, l_def_stmv_rec);
2032: -- Set OUT values

Line 2029: RAISE OKC_API.G_EXCEPTION_ERROR;

2025: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2026:
2027: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2028: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2029: RAISE OKC_API.G_EXCEPTION_ERROR;
2030: END IF;
2031: migrate(lx_stm_rec, l_def_stmv_rec);
2032: -- Set OUT values
2033: x_stmv_rec := l_def_stmv_rec;

Line 2034: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

2030: END IF;
2031: migrate(lx_stm_rec, l_def_stmv_rec);
2032: -- Set OUT values
2033: x_stmv_rec := l_def_stmv_rec;
2034: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2035: EXCEPTION
2036: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2037:
2038: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 2036: WHEN OKC_API.G_EXCEPTION_ERROR THEN

2032: -- Set OUT values
2033: x_stmv_rec := l_def_stmv_rec;
2034: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2035: EXCEPTION
2036: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2037:
2038: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2039: (
2040: l_api_name,

Line 2038: x_return_status := OKC_API.HANDLE_EXCEPTIONS

2034: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2035: EXCEPTION
2036: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2037:
2038: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2039: (
2040: l_api_name,
2041: G_PKG_NAME,
2042: 'OKC_API.G_RET_STS_ERROR',

Line 2042: 'OKC_API.G_RET_STS_ERROR',

2038: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2039: (
2040: l_api_name,
2041: G_PKG_NAME,
2042: 'OKC_API.G_RET_STS_ERROR',
2043: x_msg_count,
2044: x_msg_data,
2045: '_PVT'
2046: );

Line 2047: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2043: x_msg_count,
2044: x_msg_data,
2045: '_PVT'
2046: );
2047: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2048:
2049: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2050: (
2051: l_api_name,

Line 2049: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

2045: '_PVT'
2046: );
2047: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2048:
2049: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2050: (
2051: l_api_name,
2052: G_PKG_NAME,
2053: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 2053: 'OKC_API.G_RET_STS_UNEXP_ERROR',

2049: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2050: (
2051: l_api_name,
2052: G_PKG_NAME,
2053: 'OKC_API.G_RET_STS_UNEXP_ERROR',
2054: x_msg_count,
2055: x_msg_data,
2056: '_PVT'
2057: );

Line 2060: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

2056: '_PVT'
2057: );
2058: WHEN OTHERS THEN
2059:
2060: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2061: (
2062: l_api_name,
2063: G_PKG_NAME,
2064: 'OTHERS',

Line 2075: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

2071: -- PL/SQL TBL insert_row for:STMV_TBL --
2072: ----------------------------------------
2073: PROCEDURE insert_row(
2074: p_api_version IN NUMBER,
2075: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2076: x_return_status OUT NOCOPY VARCHAR2,
2077: x_msg_count OUT NOCOPY NUMBER,
2078: x_msg_data OUT NOCOPY VARCHAR2,
2079: p_stmv_tbl IN stmv_tbl_type,

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

2080: x_stmv_tbl OUT NOCOPY stmv_tbl_type) IS
2081:
2082: l_api_version CONSTANT NUMBER := 1;
2083: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_insert_row';
2084: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2085: l_overall_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
2086: i NUMBER := 0;
2087: BEGIN
2088: OKC_API.init_msg_list(p_init_msg_list);

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

2081:
2082: l_api_version CONSTANT NUMBER := 1;
2083: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_insert_row';
2084: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2085: l_overall_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
2086: i NUMBER := 0;
2087: BEGIN
2088: OKC_API.init_msg_list(p_init_msg_list);
2089: -- Make sure PL/SQL table has records in it before passing

Line 2088: OKC_API.init_msg_list(p_init_msg_list);

2084: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2085: l_overall_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
2086: i NUMBER := 0;
2087: BEGIN
2088: OKC_API.init_msg_list(p_init_msg_list);
2089: -- Make sure PL/SQL table has records in it before passing
2090: IF (p_stmv_tbl.COUNT > 0) THEN
2091: i := p_stmv_tbl.FIRST;
2092: LOOP

Line 2095: p_init_msg_list => OKC_API.G_FALSE,

2091: i := p_stmv_tbl.FIRST;
2092: LOOP
2093: insert_row (
2094: p_api_version => p_api_version,
2095: p_init_msg_list => OKC_API.G_FALSE,
2096: x_return_status => x_return_status,
2097: x_msg_count => x_msg_count,
2098: x_msg_data => x_msg_data,
2099: p_stmv_rec => p_stmv_tbl(i),

Line 2103: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN

2099: p_stmv_rec => p_stmv_tbl(i),
2100: x_stmv_rec => x_stmv_tbl(i));
2101: /* Begin Post Generation Change */
2102: -- store the highest degree of error
2103: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
2104: IF l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR THEN
2105: l_overall_status := x_return_status;
2106: END IF;
2107: END IF;

Line 2104: IF l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR THEN

2100: x_stmv_rec => x_stmv_tbl(i));
2101: /* Begin Post Generation Change */
2102: -- store the highest degree of error
2103: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
2104: IF l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR THEN
2105: l_overall_status := x_return_status;
2106: END IF;
2107: END IF;
2108: /* End Post Generation Change */

Line 2118: WHEN OKC_API.G_EXCEPTION_ERROR THEN

2114: -- return overall status
2115: x_return_status :=l_overall_status;
2116: END IF;
2117: EXCEPTION
2118: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2119: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2120: (
2121: l_api_name,
2122: G_PKG_NAME,

Line 2119: x_return_status := OKC_API.HANDLE_EXCEPTIONS

2115: x_return_status :=l_overall_status;
2116: END IF;
2117: EXCEPTION
2118: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2119: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2120: (
2121: l_api_name,
2122: G_PKG_NAME,
2123: 'OKC_API.G_RET_STS_ERROR',

Line 2123: 'OKC_API.G_RET_STS_ERROR',

2119: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2120: (
2121: l_api_name,
2122: G_PKG_NAME,
2123: 'OKC_API.G_RET_STS_ERROR',
2124: x_msg_count,
2125: x_msg_data,
2126: '_PVT'
2127: );

Line 2128: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2124: x_msg_count,
2125: x_msg_data,
2126: '_PVT'
2127: );
2128: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2129: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2130: (
2131: l_api_name,
2132: G_PKG_NAME,

Line 2129: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

2125: x_msg_data,
2126: '_PVT'
2127: );
2128: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2129: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2130: (
2131: l_api_name,
2132: G_PKG_NAME,
2133: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 2133: 'OKC_API.G_RET_STS_UNEXP_ERROR',

2129: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2130: (
2131: l_api_name,
2132: G_PKG_NAME,
2133: 'OKC_API.G_RET_STS_UNEXP_ERROR',
2134: x_msg_count,
2135: x_msg_data,
2136: '_PVT'
2137: );

Line 2139: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

2135: x_msg_data,
2136: '_PVT'
2137: );
2138: WHEN OTHERS THEN
2139: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2140: (
2141: l_api_name,
2142: G_PKG_NAME,
2143: 'OTHERS',

Line 2159: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

2155: -- PL/SQL TBL insert_row for:STMV_TBL --
2156: ----------------------------------------
2157: PROCEDURE insert_row_perf(
2158: p_api_version IN NUMBER,
2159: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2160: x_return_status OUT NOCOPY VARCHAR2,
2161: x_msg_count OUT NOCOPY NUMBER,
2162: x_msg_data OUT NOCOPY VARCHAR2,
2163: p_stmv_tbl IN stmv_tbl_type,

Line 2205: x_return_Status := OKC_API.G_RET_STS_SUCCESS;

2201: i INTEGER;
2202: j INTEGER;
2203:
2204: BEGIN
2205: x_return_Status := OKC_API.G_RET_STS_SUCCESS;
2206: i := p_stmv_tbl.FIRST; j:=0;
2207: --Assigning the values for the who columns
2208: l_created_by := FND_GLOBAL.USER_ID;
2209: l_last_updated_by := FND_GLOBAL.USER_ID;

Line 2340: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

2336: ------------------------------
2337: -- lock_row for:OKL_STREAMS --
2338: ------------------------------
2339: PROCEDURE lock_row(
2340: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2341: x_return_status OUT NOCOPY VARCHAR2,
2342: x_msg_count OUT NOCOPY NUMBER,
2343: x_msg_data OUT NOCOPY VARCHAR2,
2344: p_stm_rec IN stm_rec_type) IS

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

2357: FROM OKL_STREAMS
2358: WHERE ID = p_stm_rec.id;
2359: l_api_version CONSTANT NUMBER := 1;
2360: l_api_name CONSTANT VARCHAR2(30) := 'STREAMS_lock_row';
2361: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2362: l_object_version_number OKL_STREAMS.OBJECT_VERSION_NUMBER%TYPE;
2363: lc_object_version_number OKL_STREAMS.OBJECT_VERSION_NUMBER%TYPE;
2364: l_row_notfound BOOLEAN := FALSE;
2365: lc_row_notfound BOOLEAN := FALSE;

Line 2367: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

2363: lc_object_version_number OKL_STREAMS.OBJECT_VERSION_NUMBER%TYPE;
2364: l_row_notfound BOOLEAN := FALSE;
2365: lc_row_notfound BOOLEAN := FALSE;
2366: BEGIN
2367: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
2368: p_init_msg_list,
2369: '_PVT',
2370: x_return_status);
2371: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

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

2367: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
2368: p_init_msg_list,
2369: '_PVT',
2370: x_return_status);
2371: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2372:
2373:
2374: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2375: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 2374: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2370: x_return_status);
2371: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2372:
2373:
2374: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2375: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2376: RAISE OKC_API.G_EXCEPTION_ERROR;
2377: END IF;
2378: BEGIN

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

2371: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2372:
2373:
2374: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2375: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2376: RAISE OKC_API.G_EXCEPTION_ERROR;
2377: END IF;
2378: BEGIN
2379: OPEN lock_csr(p_stm_rec);

Line 2376: RAISE OKC_API.G_EXCEPTION_ERROR;

2372:
2373:
2374: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2375: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2376: RAISE OKC_API.G_EXCEPTION_ERROR;
2377: END IF;
2378: BEGIN
2379: OPEN lock_csr(p_stm_rec);
2380: FETCH lock_csr INTO l_object_version_number;

Line 2388: OKC_API.set_message(G_FND_APP,G_FORM_UNABLE_TO_RESERVE_REC);

2384: WHEN E_Resource_Busy THEN
2385: IF (lock_csr%ISOPEN) THEN
2386: CLOSE lock_csr;
2387: END IF;
2388: OKC_API.set_message(G_FND_APP,G_FORM_UNABLE_TO_RESERVE_REC);
2389: RAISE APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION;
2390: END;
2391:
2392: IF ( l_row_notfound ) THEN

Line 2399: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);

2395: lc_row_notfound := lchk_csr%NOTFOUND;
2396: CLOSE lchk_csr;
2397: END IF;
2398: IF (lc_row_notfound) THEN
2399: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
2400: RAISE OKC_API.G_EXCEPTION_ERROR;
2401: ELSIF lc_object_version_number > p_stm_rec.object_version_number THEN
2402: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
2403: RAISE OKC_API.G_EXCEPTION_ERROR;

Line 2400: RAISE OKC_API.G_EXCEPTION_ERROR;

2396: CLOSE lchk_csr;
2397: END IF;
2398: IF (lc_row_notfound) THEN
2399: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
2400: RAISE OKC_API.G_EXCEPTION_ERROR;
2401: ELSIF lc_object_version_number > p_stm_rec.object_version_number THEN
2402: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
2403: RAISE OKC_API.G_EXCEPTION_ERROR;
2404: ELSIF lc_object_version_number <> p_stm_rec.object_version_number THEN

Line 2402: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);

2398: IF (lc_row_notfound) THEN
2399: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
2400: RAISE OKC_API.G_EXCEPTION_ERROR;
2401: ELSIF lc_object_version_number > p_stm_rec.object_version_number THEN
2402: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
2403: RAISE OKC_API.G_EXCEPTION_ERROR;
2404: ELSIF lc_object_version_number <> p_stm_rec.object_version_number THEN
2405: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
2406: RAISE OKC_API.G_EXCEPTION_ERROR;

Line 2403: RAISE OKC_API.G_EXCEPTION_ERROR;

2399: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
2400: RAISE OKC_API.G_EXCEPTION_ERROR;
2401: ELSIF lc_object_version_number > p_stm_rec.object_version_number THEN
2402: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
2403: RAISE OKC_API.G_EXCEPTION_ERROR;
2404: ELSIF lc_object_version_number <> p_stm_rec.object_version_number THEN
2405: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
2406: RAISE OKC_API.G_EXCEPTION_ERROR;
2407: ELSIF lc_object_version_number = -1 THEN

Line 2405: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);

2401: ELSIF lc_object_version_number > p_stm_rec.object_version_number THEN
2402: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
2403: RAISE OKC_API.G_EXCEPTION_ERROR;
2404: ELSIF lc_object_version_number <> p_stm_rec.object_version_number THEN
2405: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
2406: RAISE OKC_API.G_EXCEPTION_ERROR;
2407: ELSIF lc_object_version_number = -1 THEN
2408: OKC_API.set_message(G_OKC_APP,G_RECORD_LOGICALLY_DELETED);
2409: RAISE OKC_API.G_EXCEPTION_ERROR;

Line 2406: RAISE OKC_API.G_EXCEPTION_ERROR;

2402: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
2403: RAISE OKC_API.G_EXCEPTION_ERROR;
2404: ELSIF lc_object_version_number <> p_stm_rec.object_version_number THEN
2405: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
2406: RAISE OKC_API.G_EXCEPTION_ERROR;
2407: ELSIF lc_object_version_number = -1 THEN
2408: OKC_API.set_message(G_OKC_APP,G_RECORD_LOGICALLY_DELETED);
2409: RAISE OKC_API.G_EXCEPTION_ERROR;
2410: END IF;

Line 2408: OKC_API.set_message(G_OKC_APP,G_RECORD_LOGICALLY_DELETED);

2404: ELSIF lc_object_version_number <> p_stm_rec.object_version_number THEN
2405: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
2406: RAISE OKC_API.G_EXCEPTION_ERROR;
2407: ELSIF lc_object_version_number = -1 THEN
2408: OKC_API.set_message(G_OKC_APP,G_RECORD_LOGICALLY_DELETED);
2409: RAISE OKC_API.G_EXCEPTION_ERROR;
2410: END IF;
2411: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2412: EXCEPTION

Line 2409: RAISE OKC_API.G_EXCEPTION_ERROR;

2405: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
2406: RAISE OKC_API.G_EXCEPTION_ERROR;
2407: ELSIF lc_object_version_number = -1 THEN
2408: OKC_API.set_message(G_OKC_APP,G_RECORD_LOGICALLY_DELETED);
2409: RAISE OKC_API.G_EXCEPTION_ERROR;
2410: END IF;
2411: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2412: EXCEPTION
2413: WHEN OKC_API.G_EXCEPTION_ERROR THEN

Line 2411: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

2407: ELSIF lc_object_version_number = -1 THEN
2408: OKC_API.set_message(G_OKC_APP,G_RECORD_LOGICALLY_DELETED);
2409: RAISE OKC_API.G_EXCEPTION_ERROR;
2410: END IF;
2411: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2412: EXCEPTION
2413: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2414: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2415: (

Line 2413: WHEN OKC_API.G_EXCEPTION_ERROR THEN

2409: RAISE OKC_API.G_EXCEPTION_ERROR;
2410: END IF;
2411: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2412: EXCEPTION
2413: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2414: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2415: (
2416: l_api_name,
2417: G_PKG_NAME,

Line 2414: x_return_status := OKC_API.HANDLE_EXCEPTIONS

2410: END IF;
2411: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2412: EXCEPTION
2413: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2414: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2415: (
2416: l_api_name,
2417: G_PKG_NAME,
2418: 'OKC_API.G_RET_STS_ERROR',

Line 2418: 'OKC_API.G_RET_STS_ERROR',

2414: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2415: (
2416: l_api_name,
2417: G_PKG_NAME,
2418: 'OKC_API.G_RET_STS_ERROR',
2419: x_msg_count,
2420: x_msg_data,
2421: '_PVT'
2422: );

Line 2423: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2419: x_msg_count,
2420: x_msg_data,
2421: '_PVT'
2422: );
2423: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2424: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2425: (
2426: l_api_name,
2427: G_PKG_NAME,

Line 2424: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

2420: x_msg_data,
2421: '_PVT'
2422: );
2423: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2424: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2425: (
2426: l_api_name,
2427: G_PKG_NAME,
2428: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 2428: 'OKC_API.G_RET_STS_UNEXP_ERROR',

2424: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2425: (
2426: l_api_name,
2427: G_PKG_NAME,
2428: 'OKC_API.G_RET_STS_UNEXP_ERROR',
2429: x_msg_count,
2430: x_msg_data,
2431: '_PVT'
2432: );

Line 2434: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

2430: x_msg_data,
2431: '_PVT'
2432: );
2433: WHEN OTHERS THEN
2434: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2435: (
2436: l_api_name,
2437: G_PKG_NAME,
2438: 'OTHERS',

Line 2449: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

2445: -- lock_row for:OKL_STREAMS_V --
2446: --------------------------------
2447: PROCEDURE lock_row(
2448: p_api_version IN NUMBER,
2449: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2450: x_return_status OUT NOCOPY VARCHAR2,
2451: x_msg_count OUT NOCOPY NUMBER,
2452: x_msg_data OUT NOCOPY VARCHAR2,
2453: p_stmv_rec IN stmv_rec_type) IS

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

2453: p_stmv_rec IN stmv_rec_type) IS
2454:
2455: l_api_version CONSTANT NUMBER := 1;
2456: l_api_name CONSTANT VARCHAR2(30) := 'V_lock_row';
2457: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2458: l_stm_rec stm_rec_type;
2459: BEGIN
2460: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
2461: G_PKG_NAME,

Line 2460: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

2456: l_api_name CONSTANT VARCHAR2(30) := 'V_lock_row';
2457: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2458: l_stm_rec stm_rec_type;
2459: BEGIN
2460: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
2461: G_PKG_NAME,
2462: p_init_msg_list,
2463: l_api_version,
2464: p_api_version,

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

2463: l_api_version,
2464: p_api_version,
2465: '_PVT',
2466: x_return_status);
2467: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2468:
2469:
2470: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2471: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 2470: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2466: x_return_status);
2467: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2468:
2469:
2470: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2471: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2472: RAISE OKC_API.G_EXCEPTION_ERROR;
2473: END IF;
2474: --------------------------------------

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

2467: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2468:
2469:
2470: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2471: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2472: RAISE OKC_API.G_EXCEPTION_ERROR;
2473: END IF;
2474: --------------------------------------
2475: -- Move VIEW record to "Child" records

Line 2472: RAISE OKC_API.G_EXCEPTION_ERROR;

2468:
2469:
2470: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2471: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2472: RAISE OKC_API.G_EXCEPTION_ERROR;
2473: END IF;
2474: --------------------------------------
2475: -- Move VIEW record to "Child" records
2476: --------------------------------------

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

2484: x_msg_count,
2485: x_msg_data,
2486: l_stm_rec
2487: );
2488: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2489:
2490:
2491: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2492: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 2491: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2487: );
2488: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2489:
2490:
2491: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2492: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2493: RAISE OKC_API.G_EXCEPTION_ERROR;
2494: END IF;
2495: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

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

2488: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2489:
2490:
2491: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2492: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2493: RAISE OKC_API.G_EXCEPTION_ERROR;
2494: END IF;
2495: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2496: EXCEPTION

Line 2493: RAISE OKC_API.G_EXCEPTION_ERROR;

2489:
2490:
2491: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2492: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2493: RAISE OKC_API.G_EXCEPTION_ERROR;
2494: END IF;
2495: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2496: EXCEPTION
2497: WHEN OKC_API.G_EXCEPTION_ERROR THEN

Line 2495: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

2491: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2492: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2493: RAISE OKC_API.G_EXCEPTION_ERROR;
2494: END IF;
2495: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2496: EXCEPTION
2497: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2498: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2499: (

Line 2497: WHEN OKC_API.G_EXCEPTION_ERROR THEN

2493: RAISE OKC_API.G_EXCEPTION_ERROR;
2494: END IF;
2495: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2496: EXCEPTION
2497: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2498: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2499: (
2500: l_api_name,
2501: G_PKG_NAME,

Line 2498: x_return_status := OKC_API.HANDLE_EXCEPTIONS

2494: END IF;
2495: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2496: EXCEPTION
2497: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2498: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2499: (
2500: l_api_name,
2501: G_PKG_NAME,
2502: 'OKC_API.G_RET_STS_ERROR',

Line 2502: 'OKC_API.G_RET_STS_ERROR',

2498: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2499: (
2500: l_api_name,
2501: G_PKG_NAME,
2502: 'OKC_API.G_RET_STS_ERROR',
2503: x_msg_count,
2504: x_msg_data,
2505: '_PVT'
2506: );

Line 2507: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2503: x_msg_count,
2504: x_msg_data,
2505: '_PVT'
2506: );
2507: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2508: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2509: (
2510: l_api_name,
2511: G_PKG_NAME,

Line 2508: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

2504: x_msg_data,
2505: '_PVT'
2506: );
2507: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2508: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2509: (
2510: l_api_name,
2511: G_PKG_NAME,
2512: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 2512: 'OKC_API.G_RET_STS_UNEXP_ERROR',

2508: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2509: (
2510: l_api_name,
2511: G_PKG_NAME,
2512: 'OKC_API.G_RET_STS_UNEXP_ERROR',
2513: x_msg_count,
2514: x_msg_data,
2515: '_PVT'
2516: );

Line 2518: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

2514: x_msg_data,
2515: '_PVT'
2516: );
2517: WHEN OTHERS THEN
2518: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2519: (
2520: l_api_name,
2521: G_PKG_NAME,
2522: 'OTHERS',

Line 2533: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

2529: -- PL/SQL TBL lock_row for:STMV_TBL --
2530: --------------------------------------
2531: PROCEDURE lock_row(
2532: p_api_version IN NUMBER,
2533: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2534: x_return_status OUT NOCOPY VARCHAR2,
2535: x_msg_count OUT NOCOPY NUMBER,
2536: x_msg_data OUT NOCOPY VARCHAR2,
2537: p_stmv_tbl IN stmv_tbl_type) IS

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

2537: p_stmv_tbl IN stmv_tbl_type) IS
2538:
2539: l_api_version CONSTANT NUMBER := 1;
2540: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_lock_row';
2541: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2542: l_overall_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
2543:
2544: i NUMBER := 0;
2545: BEGIN

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

2538:
2539: l_api_version CONSTANT NUMBER := 1;
2540: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_lock_row';
2541: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2542: l_overall_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
2543:
2544: i NUMBER := 0;
2545: BEGIN
2546: OKC_API.init_msg_list(p_init_msg_list);

Line 2546: OKC_API.init_msg_list(p_init_msg_list);

2542: l_overall_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
2543:
2544: i NUMBER := 0;
2545: BEGIN
2546: OKC_API.init_msg_list(p_init_msg_list);
2547: -- Make sure PL/SQL table has records in it before passing
2548: IF (p_stmv_tbl.COUNT > 0) THEN
2549: i := p_stmv_tbl.FIRST;
2550: LOOP

Line 2553: p_init_msg_list => OKC_API.G_FALSE,

2549: i := p_stmv_tbl.FIRST;
2550: LOOP
2551: lock_row (
2552: p_api_version => p_api_version,
2553: p_init_msg_list => OKC_API.G_FALSE,
2554: x_return_status => x_return_status,
2555: x_msg_count => x_msg_count,
2556: x_msg_data => x_msg_data,
2557: p_stmv_rec => p_stmv_tbl(i));

Line 2561: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN

2557: p_stmv_rec => p_stmv_tbl(i));
2558:
2559: /* Begin Post Generation Change */
2560: -- store the highest degree of error
2561: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
2562: IF l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR THEN
2563: l_overall_status := x_return_status;
2564: END IF;
2565: END IF;

Line 2562: IF l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR THEN

2558:
2559: /* Begin Post Generation Change */
2560: -- store the highest degree of error
2561: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
2562: IF l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR THEN
2563: l_overall_status := x_return_status;
2564: END IF;
2565: END IF;
2566: /* End Post Generation Change */

Line 2575: WHEN OKC_API.G_EXCEPTION_ERROR THEN

2571: -- return the overall status
2572: x_return_status :=l_overall_status;
2573: END IF;
2574: EXCEPTION
2575: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2576: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2577: (
2578: l_api_name,
2579: G_PKG_NAME,

Line 2576: x_return_status := OKC_API.HANDLE_EXCEPTIONS

2572: x_return_status :=l_overall_status;
2573: END IF;
2574: EXCEPTION
2575: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2576: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2577: (
2578: l_api_name,
2579: G_PKG_NAME,
2580: 'OKC_API.G_RET_STS_ERROR',

Line 2580: 'OKC_API.G_RET_STS_ERROR',

2576: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2577: (
2578: l_api_name,
2579: G_PKG_NAME,
2580: 'OKC_API.G_RET_STS_ERROR',
2581: x_msg_count,
2582: x_msg_data,
2583: '_PVT'
2584: );

Line 2585: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2581: x_msg_count,
2582: x_msg_data,
2583: '_PVT'
2584: );
2585: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2586: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2587: (
2588: l_api_name,
2589: G_PKG_NAME,

Line 2586: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

2582: x_msg_data,
2583: '_PVT'
2584: );
2585: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2586: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2587: (
2588: l_api_name,
2589: G_PKG_NAME,
2590: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 2590: 'OKC_API.G_RET_STS_UNEXP_ERROR',

2586: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2587: (
2588: l_api_name,
2589: G_PKG_NAME,
2590: 'OKC_API.G_RET_STS_UNEXP_ERROR',
2591: x_msg_count,
2592: x_msg_data,
2593: '_PVT'
2594: );

Line 2596: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

2592: x_msg_data,
2593: '_PVT'
2594: );
2595: WHEN OTHERS THEN
2596: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2597: (
2598: l_api_name,
2599: G_PKG_NAME,
2600: 'OTHERS',

Line 2614: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

2610: --------------------------------
2611: -- update_row for:OKL_STREAMS --
2612: --------------------------------
2613: PROCEDURE update_row(
2614: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2615: x_return_status OUT NOCOPY VARCHAR2,
2616: x_msg_count OUT NOCOPY NUMBER,
2617: x_msg_data OUT NOCOPY VARCHAR2,
2618: p_stm_rec IN stm_rec_type,

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

2619: x_stm_rec OUT NOCOPY stm_rec_type) IS
2620:
2621: l_api_version CONSTANT NUMBER := 1;
2622: l_api_name CONSTANT VARCHAR2(30) := 'STREAMS_update_row';
2623: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2624: l_stm_rec stm_rec_type := p_stm_rec;
2625: l_def_stm_rec stm_rec_type;
2626: l_row_notfound BOOLEAN := TRUE;
2627: ----------------------------------

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

2632: x_stm_rec OUT NOCOPY stm_rec_type
2633: ) RETURN VARCHAR2 IS
2634: l_stm_rec stm_rec_type;
2635: l_row_notfound BOOLEAN := TRUE;
2636: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2637: BEGIN
2638: x_stm_rec := p_stm_rec;
2639: -- Get current database values
2640: l_stm_rec := get_rec(p_stm_rec, l_row_notfound);

Line 2642: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

2638: x_stm_rec := p_stm_rec;
2639: -- Get current database values
2640: l_stm_rec := get_rec(p_stm_rec, l_row_notfound);
2641: IF (l_row_notfound) THEN
2642: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
2643: END IF;
2644: IF (x_stm_rec.id IS NULL) THEN
2645: x_stm_rec.id := l_stm_rec.id;
2646: ELSIF (x_stm_rec.id = OKC_API.G_MISS_NUM) THEN

Line 2646: ELSIF (x_stm_rec.id = OKC_API.G_MISS_NUM) THEN

2642: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
2643: END IF;
2644: IF (x_stm_rec.id IS NULL) THEN
2645: x_stm_rec.id := l_stm_rec.id;
2646: ELSIF (x_stm_rec.id = OKC_API.G_MISS_NUM) THEN
2647: x_stm_rec.id := NULL;
2648: END IF;
2649: IF (x_stm_rec.sty_id IS NULL) THEN
2650: x_stm_rec.sty_id := l_stm_rec.sty_id;

Line 2651: ELSIF (x_stm_rec.sty_id = OKC_API.G_MISS_NUM) THEN

2647: x_stm_rec.id := NULL;
2648: END IF;
2649: IF (x_stm_rec.sty_id IS NULL) THEN
2650: x_stm_rec.sty_id := l_stm_rec.sty_id;
2651: ELSIF (x_stm_rec.sty_id = OKC_API.G_MISS_NUM) THEN
2652: x_stm_rec.sty_id := NULL;
2653: END IF;
2654: IF (x_stm_rec.khr_id IS NULL) THEN
2655: x_stm_rec.khr_id := l_stm_rec.khr_id;

Line 2656: ELSIF (x_stm_rec.khr_id = OKC_API.G_MISS_NUM) THEN

2652: x_stm_rec.sty_id := NULL;
2653: END IF;
2654: IF (x_stm_rec.khr_id IS NULL) THEN
2655: x_stm_rec.khr_id := l_stm_rec.khr_id;
2656: ELSIF (x_stm_rec.khr_id = OKC_API.G_MISS_NUM) THEN
2657: x_stm_rec.khr_id := NULL;
2658: END IF;
2659: IF (x_stm_rec.kle_id IS NULL)THEN
2660: x_stm_rec.kle_id := l_stm_rec.kle_id;

Line 2661: ELSIF (x_stm_rec.kle_id = OKC_API.G_MISS_NUM) THEN

2657: x_stm_rec.khr_id := NULL;
2658: END IF;
2659: IF (x_stm_rec.kle_id IS NULL)THEN
2660: x_stm_rec.kle_id := l_stm_rec.kle_id;
2661: ELSIF (x_stm_rec.kle_id = OKC_API.G_MISS_NUM) THEN
2662: x_stm_rec.kle_id := NULL;
2663: END IF;
2664: IF (x_stm_rec.sgn_code IS NULL) THEN
2665: x_stm_rec.sgn_code := l_stm_rec.sgn_code;

Line 2666: ELSIF (x_stm_rec.sgn_code = OKC_API.G_MISS_CHAR) THEN

2662: x_stm_rec.kle_id := NULL;
2663: END IF;
2664: IF (x_stm_rec.sgn_code IS NULL) THEN
2665: x_stm_rec.sgn_code := l_stm_rec.sgn_code;
2666: ELSIF (x_stm_rec.sgn_code = OKC_API.G_MISS_CHAR) THEN
2667: x_stm_rec.sgn_code := NULL;
2668: END IF;
2669: IF (x_stm_rec.say_code IS NULL) THEN
2670: x_stm_rec.say_code := l_stm_rec.say_code;

Line 2671: ELSIF (x_stm_rec.say_code = OKC_API.G_MISS_CHAR) THEN

2667: x_stm_rec.sgn_code := NULL;
2668: END IF;
2669: IF (x_stm_rec.say_code IS NULL) THEN
2670: x_stm_rec.say_code := l_stm_rec.say_code;
2671: ELSIF (x_stm_rec.say_code = OKC_API.G_MISS_CHAR) THEN
2672: x_stm_rec.say_code := NULL;
2673: END IF;
2674: IF (x_stm_rec.transaction_number IS NULL) THEN
2675: x_stm_rec.transaction_number := l_stm_rec.transaction_number;

Line 2676: ELSIF (x_stm_rec.transaction_number = OKC_API.G_MISS_NUM) THEN

2672: x_stm_rec.say_code := NULL;
2673: END IF;
2674: IF (x_stm_rec.transaction_number IS NULL) THEN
2675: x_stm_rec.transaction_number := l_stm_rec.transaction_number;
2676: ELSIF (x_stm_rec.transaction_number = OKC_API.G_MISS_NUM) THEN
2677: x_stm_rec.transaction_number := NULL;
2678: END IF;
2679: IF (x_stm_rec.active_yn IS NULL) THEN
2680: x_stm_rec.active_yn := l_stm_rec.active_yn;

Line 2681: ELSIF (x_stm_rec.active_yn = OKC_API.G_MISS_CHAR) THEN

2677: x_stm_rec.transaction_number := NULL;
2678: END IF;
2679: IF (x_stm_rec.active_yn IS NULL) THEN
2680: x_stm_rec.active_yn := l_stm_rec.active_yn;
2681: ELSIF (x_stm_rec.active_yn = OKC_API.G_MISS_CHAR) THEN
2682: x_stm_rec.active_yn := NULL;
2683: END IF;
2684: IF (x_stm_rec.object_version_number IS NULL) THEN
2685: x_stm_rec.object_version_number := l_stm_rec.object_version_number;

Line 2686: ELSIF (x_stm_rec.object_version_number = OKC_API.G_MISS_NUM)THEN

2682: x_stm_rec.active_yn := NULL;
2683: END IF;
2684: IF (x_stm_rec.object_version_number IS NULL) THEN
2685: x_stm_rec.object_version_number := l_stm_rec.object_version_number;
2686: ELSIF (x_stm_rec.object_version_number = OKC_API.G_MISS_NUM)THEN
2687: x_stm_rec.object_version_number := NULL;
2688: END IF;
2689: IF (x_stm_rec.created_by IS NULL)THEN
2690: x_stm_rec.created_by := l_stm_rec.created_by;

Line 2691: ELSIF (x_stm_rec.created_by = OKC_API.G_MISS_NUM) THEN

2687: x_stm_rec.object_version_number := NULL;
2688: END IF;
2689: IF (x_stm_rec.created_by IS NULL)THEN
2690: x_stm_rec.created_by := l_stm_rec.created_by;
2691: ELSIF (x_stm_rec.created_by = OKC_API.G_MISS_NUM) THEN
2692: x_stm_rec.created_by := NULL;
2693: END IF;
2694: IF (x_stm_rec.creation_date IS NULL)THEN
2695: x_stm_rec.creation_date := l_stm_rec.creation_date;

Line 2696: ELSIF (x_stm_rec.creation_date = OKC_API.G_MISS_DATE) THEN

2692: x_stm_rec.created_by := NULL;
2693: END IF;
2694: IF (x_stm_rec.creation_date IS NULL)THEN
2695: x_stm_rec.creation_date := l_stm_rec.creation_date;
2696: ELSIF (x_stm_rec.creation_date = OKC_API.G_MISS_DATE) THEN
2697: x_stm_rec.creation_date := NULL;
2698: END IF;
2699: IF (x_stm_rec.last_updated_by IS NULL) THEN
2700: x_stm_rec.last_updated_by := l_stm_rec.last_updated_by;

Line 2701: ELSIF (x_stm_rec.last_updated_by = OKC_API.G_MISS_NUM) THEN

2697: x_stm_rec.creation_date := NULL;
2698: END IF;
2699: IF (x_stm_rec.last_updated_by IS NULL) THEN
2700: x_stm_rec.last_updated_by := l_stm_rec.last_updated_by;
2701: ELSIF (x_stm_rec.last_updated_by = OKC_API.G_MISS_NUM) THEN
2702: x_stm_rec.last_updated_by := NULL;
2703: END IF;
2704: IF (x_stm_rec.last_update_date IS NULL) THEN
2705: x_stm_rec.last_update_date := l_stm_rec.last_update_date;

Line 2706: ELSIF (x_stm_rec.last_update_date = OKC_API.G_MISS_DATE) THEN

2702: x_stm_rec.last_updated_by := NULL;
2703: END IF;
2704: IF (x_stm_rec.last_update_date IS NULL) THEN
2705: x_stm_rec.last_update_date := l_stm_rec.last_update_date;
2706: ELSIF (x_stm_rec.last_update_date = OKC_API.G_MISS_DATE) THEN
2707: x_stm_rec.last_update_date := NULL;
2708: END IF;
2709: IF (x_stm_rec.date_current IS NULL)THEN
2710: x_stm_rec.date_current := l_stm_rec.date_current;

Line 2711: ELSIF (x_stm_rec.date_current = OKC_API.G_MISS_DATE) THEN

2707: x_stm_rec.last_update_date := NULL;
2708: END IF;
2709: IF (x_stm_rec.date_current IS NULL)THEN
2710: x_stm_rec.date_current := l_stm_rec.date_current;
2711: ELSIF (x_stm_rec.date_current = OKC_API.G_MISS_DATE) THEN
2712: x_stm_rec.date_current := NULL;
2713: END IF;
2714: IF (x_stm_rec.date_working IS NULL ) THEN
2715: x_stm_rec.date_working := l_stm_rec.date_working;

Line 2716: ELSIF (x_stm_rec.date_working = OKC_API.G_MISS_DATE) THEN

2712: x_stm_rec.date_current := NULL;
2713: END IF;
2714: IF (x_stm_rec.date_working IS NULL ) THEN
2715: x_stm_rec.date_working := l_stm_rec.date_working;
2716: ELSIF (x_stm_rec.date_working = OKC_API.G_MISS_DATE) THEN
2717: x_stm_rec.date_working := NULL;
2718: END IF;
2719: IF (x_stm_rec.date_history IS NULL) THEN
2720: x_stm_rec.date_history := l_stm_rec.date_history;

Line 2721: ELSIF (x_stm_rec.date_history = OKC_API.G_MISS_DATE) THEN

2717: x_stm_rec.date_working := NULL;
2718: END IF;
2719: IF (x_stm_rec.date_history IS NULL) THEN
2720: x_stm_rec.date_history := l_stm_rec.date_history;
2721: ELSIF (x_stm_rec.date_history = OKC_API.G_MISS_DATE) THEN
2722: x_stm_rec.date_history := NULL;
2723: END IF;
2724: IF (x_stm_rec.comments IS NULL) THEN
2725: x_stm_rec.comments := l_stm_rec.comments;

Line 2726: ELSIF (x_stm_rec.comments = OKC_API.G_MISS_CHAR) THEN

2722: x_stm_rec.date_history := NULL;
2723: END IF;
2724: IF (x_stm_rec.comments IS NULL) THEN
2725: x_stm_rec.comments := l_stm_rec.comments;
2726: ELSIF (x_stm_rec.comments = OKC_API.G_MISS_CHAR) THEN
2727: x_stm_rec.comments := NULL;
2728: END IF;
2729: IF (x_stm_rec.program_id IS NULL) THEN
2730: x_stm_rec.program_id := l_stm_rec.program_id;

Line 2731: ELSIF (x_stm_rec.program_id = OKC_API.G_MISS_NUM) THEN

2727: x_stm_rec.comments := NULL;
2728: END IF;
2729: IF (x_stm_rec.program_id IS NULL) THEN
2730: x_stm_rec.program_id := l_stm_rec.program_id;
2731: ELSIF (x_stm_rec.program_id = OKC_API.G_MISS_NUM) THEN
2732: x_stm_rec.program_id := NULL ;
2733: END IF;
2734: IF (x_stm_rec.request_id IS NULL) THEN
2735: x_stm_rec.request_id := l_stm_rec.request_id;

Line 2736: ELSIF (x_stm_rec.request_id = OKC_API.G_MISS_NUM) THEN

2732: x_stm_rec.program_id := NULL ;
2733: END IF;
2734: IF (x_stm_rec.request_id IS NULL) THEN
2735: x_stm_rec.request_id := l_stm_rec.request_id;
2736: ELSIF (x_stm_rec.request_id = OKC_API.G_MISS_NUM) THEN
2737: x_stm_rec.request_id := NULL;
2738: END IF;
2739: IF (x_stm_rec.program_application_id IS NULL) THEN
2740: x_stm_rec.program_application_id := l_stm_rec.program_application_id;

Line 2741: ELSIF(x_stm_rec.program_application_id = OKC_API.G_MISS_NUM) THEN

2737: x_stm_rec.request_id := NULL;
2738: END IF;
2739: IF (x_stm_rec.program_application_id IS NULL) THEN
2740: x_stm_rec.program_application_id := l_stm_rec.program_application_id;
2741: ELSIF(x_stm_rec.program_application_id = OKC_API.G_MISS_NUM) THEN
2742: x_stm_rec.program_application_id := NULL;
2743: END IF;
2744: IF (x_stm_rec.program_update_date IS NULL )THEN
2745: x_stm_rec.program_update_date := l_stm_rec.program_update_date;

Line 2746: ELSIF (x_stm_rec.program_update_date = OKC_API.G_MISS_DATE) THEN

2742: x_stm_rec.program_application_id := NULL;
2743: END IF;
2744: IF (x_stm_rec.program_update_date IS NULL )THEN
2745: x_stm_rec.program_update_date := l_stm_rec.program_update_date;
2746: ELSIF (x_stm_rec.program_update_date = OKC_API.G_MISS_DATE) THEN
2747: x_stm_rec.program_update_date := NULL;
2748: END IF;
2749: IF (x_stm_rec.last_update_login IS NULL)THEN
2750: x_stm_rec.last_update_login := l_stm_rec.last_update_login;

Line 2751: ELSIF(x_stm_rec.last_update_login = OKC_API.G_MISS_NUM)THEN

2747: x_stm_rec.program_update_date := NULL;
2748: END IF;
2749: IF (x_stm_rec.last_update_login IS NULL)THEN
2750: x_stm_rec.last_update_login := l_stm_rec.last_update_login;
2751: ELSIF(x_stm_rec.last_update_login = OKC_API.G_MISS_NUM)THEN
2752: x_stm_rec.last_update_login := NULL;
2753: END IF;
2754:
2755: -- mvasudev, Bug#2650599

Line 2758: ELSIF (x_stm_rec.purpose_code = OKC_API.G_MISS_CHAR) THEN

2754:
2755: -- mvasudev, Bug#2650599
2756: IF (x_stm_rec.purpose_code IS NULL) THEN
2757: x_stm_rec.purpose_code := l_stm_rec.purpose_code;
2758: ELSIF (x_stm_rec.purpose_code = OKC_API.G_MISS_CHAR) THEN
2759: x_stm_rec.purpose_code := NULL;
2760: END IF;
2761: --IF (x_stm_rec.sty_code = OKC_API.G_MISS_CHAR)
2762: --THEN

Line 2761: --IF (x_stm_rec.sty_code = OKC_API.G_MISS_CHAR)

2757: x_stm_rec.purpose_code := l_stm_rec.purpose_code;
2758: ELSIF (x_stm_rec.purpose_code = OKC_API.G_MISS_CHAR) THEN
2759: x_stm_rec.purpose_code := NULL;
2760: END IF;
2761: --IF (x_stm_rec.sty_code = OKC_API.G_MISS_CHAR)
2762: --THEN
2763: -- x_stm_rec.sty_code := l_stm_rec.sty_code;
2764: --END IF;
2765: -- end, mvasudev, Bug#2650599

Line 2769: ELSIF (x_stm_rec.stm_id = OKC_API.G_MISS_NUM) THEN

2765: -- end, mvasudev, Bug#2650599
2766:
2767: IF (x_stm_rec.stm_id IS NULL)THEN
2768: x_stm_rec.stm_id := l_stm_rec.stm_id;
2769: ELSIF (x_stm_rec.stm_id = OKC_API.G_MISS_NUM) THEN
2770: x_stm_rec.stm_id := NULL;
2771: END IF;
2772:
2773: -- Added by Keerthi for Bug 3166890

Line 2777: ELSIF (x_stm_rec.source_id = OKC_API.G_MISS_NUM) THEN

2773: -- Added by Keerthi for Bug 3166890
2774:
2775: IF (x_stm_rec.source_id IS NULL)THEN
2776: x_stm_rec.source_id := l_stm_rec.source_id;
2777: ELSIF (x_stm_rec.source_id = OKC_API.G_MISS_NUM) THEN
2778: x_stm_rec.source_id := NULL;
2779: END IF;
2780:
2781: IF (x_stm_rec.source_table IS NULL)THEN

Line 2783: ELSIF (x_stm_rec.source_table = OKC_API.G_MISS_CHAR) THEN

2779: END IF;
2780:
2781: IF (x_stm_rec.source_table IS NULL)THEN
2782: x_stm_rec.source_table := l_stm_rec.source_table;
2783: ELSIF (x_stm_rec.source_table = OKC_API.G_MISS_CHAR) THEN
2784: x_stm_rec.source_table := NULL;
2785: END IF;
2786: -- Added by rgooty: 4212626
2787: IF (x_stm_rec.trx_id IS NULL)THEN

Line 2789: ELSIF (x_stm_rec.trx_id = OKC_API.G_MISS_NUM) THEN

2785: END IF;
2786: -- Added by rgooty: 4212626
2787: IF (x_stm_rec.trx_id IS NULL)THEN
2788: x_stm_rec.trx_id := l_stm_rec.trx_id;
2789: ELSIF (x_stm_rec.trx_id = OKC_API.G_MISS_NUM) THEN
2790: x_stm_rec.trx_id := NULL;
2791: END IF;
2792:
2793: IF (x_stm_rec.link_hist_stream_id IS NULL)THEN

Line 2795: ELSIF (x_stm_rec.link_hist_stream_id = OKC_API.G_MISS_NUM) THEN

2791: END IF;
2792:
2793: IF (x_stm_rec.link_hist_stream_id IS NULL)THEN
2794: x_stm_rec.link_hist_stream_id := l_stm_rec.link_hist_stream_id;
2795: ELSIF (x_stm_rec.link_hist_stream_id = OKC_API.G_MISS_NUM) THEN
2796: x_stm_rec.link_hist_stream_id := NULL;
2797: END IF;
2798:
2799: RETURN(l_return_status);

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

2804: FUNCTION Set_Attributes (
2805: p_stm_rec IN stm_rec_type,
2806: x_stm_rec OUT NOCOPY stm_rec_type
2807: ) RETURN VARCHAR2 IS
2808: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2809: BEGIN
2810: x_stm_rec := p_stm_rec;
2811: RETURN(l_return_status);
2812: END Set_Attributes;

Line 2814: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

2810: x_stm_rec := p_stm_rec;
2811: RETURN(l_return_status);
2812: END Set_Attributes;
2813: BEGIN
2814: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
2815: p_init_msg_list,
2816: '_PVT',
2817: x_return_status);
2818: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

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

2814: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
2815: p_init_msg_list,
2816: '_PVT',
2817: x_return_status);
2818: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2819:
2820:
2821: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2822: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 2821: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2817: x_return_status);
2818: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2819:
2820:
2821: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2822: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2823: RAISE OKC_API.G_EXCEPTION_ERROR;
2824: END IF;
2825: --- Setting item attributes

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

2818: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2819:
2820:
2821: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2822: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2823: RAISE OKC_API.G_EXCEPTION_ERROR;
2824: END IF;
2825: --- Setting item attributes
2826: l_return_status := Set_Attributes(

Line 2823: RAISE OKC_API.G_EXCEPTION_ERROR;

2819:
2820:
2821: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2822: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2823: RAISE OKC_API.G_EXCEPTION_ERROR;
2824: END IF;
2825: --- Setting item attributes
2826: l_return_status := Set_Attributes(
2827: p_stm_rec, -- IN

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

2826: l_return_status := Set_Attributes(
2827: p_stm_rec, -- IN
2828: l_stm_rec); -- OUT
2829: --- If any errors happen abort API
2830: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2831:
2832:
2833: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2834: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 2833: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2829: --- If any errors happen abort API
2830: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2831:
2832:
2833: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2834: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2835: RAISE OKC_API.G_EXCEPTION_ERROR;
2836: END IF;
2837: l_return_status := populate_new_record(l_stm_rec, l_def_stm_rec);

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

2830: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2831:
2832:
2833: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2834: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2835: RAISE OKC_API.G_EXCEPTION_ERROR;
2836: END IF;
2837: l_return_status := populate_new_record(l_stm_rec, l_def_stm_rec);
2838: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 2835: RAISE OKC_API.G_EXCEPTION_ERROR;

2831:
2832:
2833: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2834: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2835: RAISE OKC_API.G_EXCEPTION_ERROR;
2836: END IF;
2837: l_return_status := populate_new_record(l_stm_rec, l_def_stm_rec);
2838: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2839:

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

2834: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2835: RAISE OKC_API.G_EXCEPTION_ERROR;
2836: END IF;
2837: l_return_status := populate_new_record(l_stm_rec, l_def_stm_rec);
2838: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2839:
2840:
2841: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2842: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 2841: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2837: l_return_status := populate_new_record(l_stm_rec, l_def_stm_rec);
2838: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2839:
2840:
2841: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2842: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2843: RAISE OKC_API.G_EXCEPTION_ERROR;
2844: END IF;
2845: UPDATE OKL_STREAMS

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

2838: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2839:
2840:
2841: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2842: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2843: RAISE OKC_API.G_EXCEPTION_ERROR;
2844: END IF;
2845: UPDATE OKL_STREAMS
2846: SET STY_ID = l_def_stm_rec.sty_id,

Line 2843: RAISE OKC_API.G_EXCEPTION_ERROR;

2839:
2840:
2841: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2842: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2843: RAISE OKC_API.G_EXCEPTION_ERROR;
2844: END IF;
2845: UPDATE OKL_STREAMS
2846: SET STY_ID = l_def_stm_rec.sty_id,
2847: KHR_ID = l_def_stm_rec.khr_id,

Line 2881: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

2877: link_hist_stream_id = l_def_stm_rec.link_hist_stream_id
2878: WHERE ID = l_def_stm_rec.id;
2879:
2880: x_stm_rec := l_def_stm_rec;
2881: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2882: EXCEPTION
2883: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2884: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2885: (

Line 2883: WHEN OKC_API.G_EXCEPTION_ERROR THEN

2879:
2880: x_stm_rec := l_def_stm_rec;
2881: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2882: EXCEPTION
2883: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2884: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2885: (
2886: l_api_name,
2887: G_PKG_NAME,

Line 2884: x_return_status := OKC_API.HANDLE_EXCEPTIONS

2880: x_stm_rec := l_def_stm_rec;
2881: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2882: EXCEPTION
2883: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2884: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2885: (
2886: l_api_name,
2887: G_PKG_NAME,
2888: 'OKC_API.G_RET_STS_ERROR',

Line 2888: 'OKC_API.G_RET_STS_ERROR',

2884: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2885: (
2886: l_api_name,
2887: G_PKG_NAME,
2888: 'OKC_API.G_RET_STS_ERROR',
2889: x_msg_count,
2890: x_msg_data,
2891: '_PVT'
2892: );

Line 2893: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2889: x_msg_count,
2890: x_msg_data,
2891: '_PVT'
2892: );
2893: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2894: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2895: (
2896: l_api_name,
2897: G_PKG_NAME,

Line 2894: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

2890: x_msg_data,
2891: '_PVT'
2892: );
2893: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2894: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2895: (
2896: l_api_name,
2897: G_PKG_NAME,
2898: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 2898: 'OKC_API.G_RET_STS_UNEXP_ERROR',

2894: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2895: (
2896: l_api_name,
2897: G_PKG_NAME,
2898: 'OKC_API.G_RET_STS_UNEXP_ERROR',
2899: x_msg_count,
2900: x_msg_data,
2901: '_PVT'
2902: );

Line 2904: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

2900: x_msg_data,
2901: '_PVT'
2902: );
2903: WHEN OTHERS THEN
2904: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2905: (
2906: l_api_name,
2907: G_PKG_NAME,
2908: 'OTHERS',

Line 2919: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

2915: -- update_row for:OKL_STREAMS_V --
2916: ----------------------------------
2917: PROCEDURE update_row(
2918: p_api_version IN NUMBER,
2919: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2920: x_return_status OUT NOCOPY VARCHAR2,
2921: x_msg_count OUT NOCOPY NUMBER,
2922: x_msg_data OUT NOCOPY VARCHAR2,
2923: p_stmv_rec IN stmv_rec_type,

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

2924: x_stmv_rec OUT NOCOPY stmv_rec_type) IS
2925:
2926: l_api_version CONSTANT NUMBER := 1;
2927: l_api_name CONSTANT VARCHAR2(30) := 'V_update_row';
2928: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2929: l_stmv_rec stmv_rec_type := p_stmv_rec;
2930: l_def_stmv_rec stmv_rec_type;
2931: l_stm_rec stm_rec_type;
2932: lx_stm_rec stm_rec_type;

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

2951: x_stmv_rec OUT NOCOPY stmv_rec_type
2952: ) RETURN VARCHAR2 IS
2953: l_stmv_rec stmv_rec_type;
2954: l_row_notfound BOOLEAN := TRUE;
2955: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2956: BEGIN
2957: x_stmv_rec := p_stmv_rec;
2958: -- Get current database values
2959: l_stmv_rec := get_rec(p_stmv_rec, l_row_notfound);

Line 2963: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

2959: l_stmv_rec := get_rec(p_stmv_rec, l_row_notfound);
2960: IF (l_row_notfound) THEN
2961:
2962:
2963: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
2964: END IF;
2965: IF (x_stmv_rec.id IS NULL)THEN
2966: x_stmv_rec.id := l_stmv_rec.id;
2967: ELSIF (x_stmv_rec.id = OKC_API.G_MISS_NUM) THEN

Line 2967: ELSIF (x_stmv_rec.id = OKC_API.G_MISS_NUM) THEN

2963: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
2964: END IF;
2965: IF (x_stmv_rec.id IS NULL)THEN
2966: x_stmv_rec.id := l_stmv_rec.id;
2967: ELSIF (x_stmv_rec.id = OKC_API.G_MISS_NUM) THEN
2968: x_stmv_rec.id := NULL;
2969: END IF;
2970: IF (x_stmv_rec.object_version_number IS NULL) THEN
2971: x_stmv_rec.object_version_number := l_stmv_rec.object_version_number;

Line 2972: ELSIF (x_stmv_rec.object_version_number = OKC_API.G_MISS_NUM) THEN

2968: x_stmv_rec.id := NULL;
2969: END IF;
2970: IF (x_stmv_rec.object_version_number IS NULL) THEN
2971: x_stmv_rec.object_version_number := l_stmv_rec.object_version_number;
2972: ELSIF (x_stmv_rec.object_version_number = OKC_API.G_MISS_NUM) THEN
2973: x_stmv_rec.object_version_number := NULL;
2974: END IF;
2975: IF (x_stmv_rec.sgn_code IS NULL)THEN
2976: x_stmv_rec.sgn_code := l_stmv_rec.sgn_code;

Line 2977: ELSIF (x_stmv_rec.sgn_code = OKC_API.G_MISS_CHAR) THEN

2973: x_stmv_rec.object_version_number := NULL;
2974: END IF;
2975: IF (x_stmv_rec.sgn_code IS NULL)THEN
2976: x_stmv_rec.sgn_code := l_stmv_rec.sgn_code;
2977: ELSIF (x_stmv_rec.sgn_code = OKC_API.G_MISS_CHAR) THEN
2978: x_stmv_rec.sgn_code := NULL;
2979: END IF;
2980: IF (x_stmv_rec.say_code IS NULL)THEN
2981: x_stmv_rec.say_code := l_stmv_rec.say_code;

Line 2982: ELSIF (x_stmv_rec.say_code = OKC_API.G_MISS_CHAR) THEN

2978: x_stmv_rec.sgn_code := NULL;
2979: END IF;
2980: IF (x_stmv_rec.say_code IS NULL)THEN
2981: x_stmv_rec.say_code := l_stmv_rec.say_code;
2982: ELSIF (x_stmv_rec.say_code = OKC_API.G_MISS_CHAR) THEN
2983: x_stmv_rec.say_code := NULL;
2984: END IF;
2985: IF (x_stmv_rec.sty_id IS NULL)THEN
2986: x_stmv_rec.sty_id := l_stmv_rec.sty_id;

Line 2987: ELSIF (x_stmv_rec.sty_id = OKC_API.G_MISS_NUM) THEN

2983: x_stmv_rec.say_code := NULL;
2984: END IF;
2985: IF (x_stmv_rec.sty_id IS NULL)THEN
2986: x_stmv_rec.sty_id := l_stmv_rec.sty_id;
2987: ELSIF (x_stmv_rec.sty_id = OKC_API.G_MISS_NUM) THEN
2988: x_stmv_rec.sty_id := NULL;
2989: END IF;
2990: IF (x_stmv_rec.kle_id IS NULL)THEN
2991: x_stmv_rec.kle_id := l_stmv_rec.kle_id;

Line 2992: ELSIF (x_stmv_rec.kle_id = OKC_API.G_MISS_NUM) THEN

2988: x_stmv_rec.sty_id := NULL;
2989: END IF;
2990: IF (x_stmv_rec.kle_id IS NULL)THEN
2991: x_stmv_rec.kle_id := l_stmv_rec.kle_id;
2992: ELSIF (x_stmv_rec.kle_id = OKC_API.G_MISS_NUM) THEN
2993: x_stmv_rec.kle_id := NULL;
2994: END IF;
2995: IF (x_stmv_rec.khr_id IS NULL)THEN
2996: x_stmv_rec.khr_id := l_stmv_rec.khr_id;

Line 2997: ELSIF (x_stmv_rec.khr_id = OKC_API.G_MISS_NUM) THEN

2993: x_stmv_rec.kle_id := NULL;
2994: END IF;
2995: IF (x_stmv_rec.khr_id IS NULL)THEN
2996: x_stmv_rec.khr_id := l_stmv_rec.khr_id;
2997: ELSIF (x_stmv_rec.khr_id = OKC_API.G_MISS_NUM) THEN
2998: x_stmv_rec.khr_id := NULL;
2999: END IF;
3000: IF (x_stmv_rec.transaction_number IS NULL)THEN
3001: x_stmv_rec.transaction_number := l_stmv_rec.transaction_number;

Line 3002: ELSIF (x_stmv_rec.transaction_number = OKC_API.G_MISS_NUM) THEN

2998: x_stmv_rec.khr_id := NULL;
2999: END IF;
3000: IF (x_stmv_rec.transaction_number IS NULL)THEN
3001: x_stmv_rec.transaction_number := l_stmv_rec.transaction_number;
3002: ELSIF (x_stmv_rec.transaction_number = OKC_API.G_MISS_NUM) THEN
3003: x_stmv_rec.transaction_number := NULL;
3004: END IF;
3005: IF (x_stmv_rec.active_yn IS NULL) THEN
3006: x_stmv_rec.active_yn := l_stmv_rec.active_yn;

Line 3007: ELSIF (x_stmv_rec.active_yn = OKC_API.G_MISS_CHAR) THEN

3003: x_stmv_rec.transaction_number := NULL;
3004: END IF;
3005: IF (x_stmv_rec.active_yn IS NULL) THEN
3006: x_stmv_rec.active_yn := l_stmv_rec.active_yn;
3007: ELSIF (x_stmv_rec.active_yn = OKC_API.G_MISS_CHAR) THEN
3008: x_stmv_rec.active_yn := NULL;
3009: END IF;
3010: IF (x_stmv_rec.date_current IS NULL)THEN
3011: x_stmv_rec.date_current := l_stmv_rec.date_current;

Line 3012: ELSIF (x_stmv_rec.date_current = OKC_API.G_MISS_DATE) THEN

3008: x_stmv_rec.active_yn := NULL;
3009: END IF;
3010: IF (x_stmv_rec.date_current IS NULL)THEN
3011: x_stmv_rec.date_current := l_stmv_rec.date_current;
3012: ELSIF (x_stmv_rec.date_current = OKC_API.G_MISS_DATE) THEN
3013: x_stmv_rec.date_current := NULL;
3014: END IF;
3015: IF (x_stmv_rec.date_working IS NULL)THEN
3016: x_stmv_rec.date_working := l_stmv_rec.date_working;

Line 3017: ELSIF (x_stmv_rec.date_working = OKC_API.G_MISS_DATE) THEN

3013: x_stmv_rec.date_current := NULL;
3014: END IF;
3015: IF (x_stmv_rec.date_working IS NULL)THEN
3016: x_stmv_rec.date_working := l_stmv_rec.date_working;
3017: ELSIF (x_stmv_rec.date_working = OKC_API.G_MISS_DATE) THEN
3018: x_stmv_rec.date_working := NULL;
3019: END IF;
3020: IF (x_stmv_rec.date_history IS NULL)THEN
3021: x_stmv_rec.date_history := l_stmv_rec.date_history;

Line 3022: ELSIF (x_stmv_rec.date_history = OKC_API.G_MISS_DATE) THEN

3018: x_stmv_rec.date_working := NULL;
3019: END IF;
3020: IF (x_stmv_rec.date_history IS NULL)THEN
3021: x_stmv_rec.date_history := l_stmv_rec.date_history;
3022: ELSIF (x_stmv_rec.date_history = OKC_API.G_MISS_DATE) THEN
3023: x_stmv_rec.date_history := NULL;
3024: END IF;
3025: IF (x_stmv_rec.comments IS NULL)THEN
3026: x_stmv_rec.comments := l_stmv_rec.comments;

Line 3027: ELSIF (x_stmv_rec.comments = OKC_API.G_MISS_CHAR) THEN

3023: x_stmv_rec.date_history := NULL;
3024: END IF;
3025: IF (x_stmv_rec.comments IS NULL)THEN
3026: x_stmv_rec.comments := l_stmv_rec.comments;
3027: ELSIF (x_stmv_rec.comments = OKC_API.G_MISS_CHAR) THEN
3028: x_stmv_rec.comments := NULL;
3029: END IF;
3030: IF (x_stmv_rec.created_by IS NULL)THEN
3031: x_stmv_rec.created_by := l_stmv_rec.created_by;

Line 3032: ELSIF (x_stmv_rec.created_by = OKC_API.G_MISS_NUM)THEN

3028: x_stmv_rec.comments := NULL;
3029: END IF;
3030: IF (x_stmv_rec.created_by IS NULL)THEN
3031: x_stmv_rec.created_by := l_stmv_rec.created_by;
3032: ELSIF (x_stmv_rec.created_by = OKC_API.G_MISS_NUM)THEN
3033: x_stmv_rec.created_by := NULL;
3034: END IF;
3035: IF (x_stmv_rec.creation_date IS NULL)THEN
3036: x_stmv_rec.creation_date := l_stmv_rec.creation_date;

Line 3037: ELSIF (x_stmv_rec.creation_date = OKC_API.G_MISS_DATE) THEN

3033: x_stmv_rec.created_by := NULL;
3034: END IF;
3035: IF (x_stmv_rec.creation_date IS NULL)THEN
3036: x_stmv_rec.creation_date := l_stmv_rec.creation_date;
3037: ELSIF (x_stmv_rec.creation_date = OKC_API.G_MISS_DATE) THEN
3038: x_stmv_rec.creation_date := NULL;
3039: END IF;
3040: IF (x_stmv_rec.last_updated_by IS NULL)THEN
3041: x_stmv_rec.last_updated_by := l_stmv_rec.last_updated_by;

Line 3042: ELSIF (x_stmv_rec.last_updated_by = OKC_API.G_MISS_NUM) THEN

3038: x_stmv_rec.creation_date := NULL;
3039: END IF;
3040: IF (x_stmv_rec.last_updated_by IS NULL)THEN
3041: x_stmv_rec.last_updated_by := l_stmv_rec.last_updated_by;
3042: ELSIF (x_stmv_rec.last_updated_by = OKC_API.G_MISS_NUM) THEN
3043: x_stmv_rec.last_updated_by := NULL ;
3044: END IF;
3045: IF (x_stmv_rec.last_update_date IS NULL)THEN
3046: x_stmv_rec.last_update_date := l_stmv_rec.last_update_date;

Line 3047: ELSIF(x_stmv_rec.last_update_date = OKC_API.G_MISS_DATE) THEN

3043: x_stmv_rec.last_updated_by := NULL ;
3044: END IF;
3045: IF (x_stmv_rec.last_update_date IS NULL)THEN
3046: x_stmv_rec.last_update_date := l_stmv_rec.last_update_date;
3047: ELSIF(x_stmv_rec.last_update_date = OKC_API.G_MISS_DATE) THEN
3048: x_stmv_rec.last_update_date := NULL;
3049: END IF;
3050: IF (x_stmv_rec.program_id IS NULL)THEN
3051: x_stmv_rec.program_id := l_stmv_rec.program_id;

Line 3052: ELSIF (x_stmv_rec.program_id = OKC_API.G_MISS_NUM) THEN

3048: x_stmv_rec.last_update_date := NULL;
3049: END IF;
3050: IF (x_stmv_rec.program_id IS NULL)THEN
3051: x_stmv_rec.program_id := l_stmv_rec.program_id;
3052: ELSIF (x_stmv_rec.program_id = OKC_API.G_MISS_NUM) THEN
3053: x_stmv_rec.program_id := NULL;
3054: END IF;
3055: IF (x_stmv_rec.request_id IS NULL)THEN
3056: x_stmv_rec.request_id := l_stmv_rec.request_id;

Line 3057: ELSIF (x_stmv_rec.request_id = OKC_API.G_MISS_NUM) THEN

3053: x_stmv_rec.program_id := NULL;
3054: END IF;
3055: IF (x_stmv_rec.request_id IS NULL)THEN
3056: x_stmv_rec.request_id := l_stmv_rec.request_id;
3057: ELSIF (x_stmv_rec.request_id = OKC_API.G_MISS_NUM) THEN
3058: x_stmv_rec.request_id := NULL;
3059: END IF;
3060: IF (x_stmv_rec.program_application_id IS NULL)THEN
3061: x_stmv_rec.program_application_id := l_stmv_rec.program_application_id;

Line 3062: ELSIF (x_stmv_rec.program_application_id = OKC_API.G_MISS_NUM) THEN

3058: x_stmv_rec.request_id := NULL;
3059: END IF;
3060: IF (x_stmv_rec.program_application_id IS NULL)THEN
3061: x_stmv_rec.program_application_id := l_stmv_rec.program_application_id;
3062: ELSIF (x_stmv_rec.program_application_id = OKC_API.G_MISS_NUM) THEN
3063: x_stmv_rec.program_application_id := NULL;
3064: END IF;
3065: IF (x_stmv_rec.program_update_date IS NULL )THEN
3066: x_stmv_rec.program_update_date := l_stmv_rec.program_update_date;

Line 3067: ELSIF (x_stmv_rec.program_update_date = OKC_API.G_MISS_DATE) THEN

3063: x_stmv_rec.program_application_id := NULL;
3064: END IF;
3065: IF (x_stmv_rec.program_update_date IS NULL )THEN
3066: x_stmv_rec.program_update_date := l_stmv_rec.program_update_date;
3067: ELSIF (x_stmv_rec.program_update_date = OKC_API.G_MISS_DATE) THEN
3068: x_stmv_rec.program_update_date := NULL;
3069: END IF;
3070: IF (x_stmv_rec.last_update_login IS NULL)THEN
3071: x_stmv_rec.last_update_login := l_stmv_rec.last_update_login;

Line 3072: ELSIF (x_stmv_rec.last_update_login = OKC_API.G_MISS_NUM) THEN

3068: x_stmv_rec.program_update_date := NULL;
3069: END IF;
3070: IF (x_stmv_rec.last_update_login IS NULL)THEN
3071: x_stmv_rec.last_update_login := l_stmv_rec.last_update_login;
3072: ELSIF (x_stmv_rec.last_update_login = OKC_API.G_MISS_NUM) THEN
3073: x_stmv_rec.last_update_login := NULL;
3074: END IF;
3075:
3076: -- mvasudev, Bug#2650599

Line 3079: ELSIF (x_stmv_rec.purpose_code = OKC_API.G_MISS_CHAR) THEN

3075:
3076: -- mvasudev, Bug#2650599
3077: IF (x_stmv_rec.purpose_code IS NULL)THEN
3078: x_stmv_rec.purpose_code := l_stmv_rec.purpose_code;
3079: ELSIF (x_stmv_rec.purpose_code = OKC_API.G_MISS_CHAR) THEN
3080: x_stmv_rec.purpose_code := NULL;
3081: END IF;
3082:
3083:

Line 3084: --IF (x_stmv_rec.sty_code = OKC_API.G_MISS_CHAR)

3080: x_stmv_rec.purpose_code := NULL;
3081: END IF;
3082:
3083:
3084: --IF (x_stmv_rec.sty_code = OKC_API.G_MISS_CHAR)
3085: --THEN
3086: --x_stmv_rec.sty_code := l_stmv_rec.sty_code;
3087: --END IF;
3088: -- end, mvasudev, Bug#2650599

Line 3092: ELSIF (x_stmv_rec.stm_id = OKC_API.G_MISS_NUM) THEN

3088: -- end, mvasudev, Bug#2650599
3089:
3090: IF (x_stmv_rec.stm_id IS NULL) THEN
3091: x_stmv_rec.stm_id := l_stmv_rec.stm_id;
3092: ELSIF (x_stmv_rec.stm_id = OKC_API.G_MISS_NUM) THEN
3093: x_stmv_rec.stm_id := NULL;
3094: END IF;
3095:
3096: -- Added by Keerthi for Bug 3166890

Line 3100: ELSIF (x_stmv_rec.source_id = OKC_API.G_MISS_NUM) THEN

3096: -- Added by Keerthi for Bug 3166890
3097:
3098: IF (x_stmv_rec.source_id IS NULL) THEN
3099: x_stmv_rec.source_id := l_stmv_rec.source_id;
3100: ELSIF (x_stmv_rec.source_id = OKC_API.G_MISS_NUM) THEN
3101: x_stmv_rec.source_id := NULL;
3102: END IF;
3103:
3104: IF (x_stmv_rec.source_table IS NULL) THEN

Line 3106: ELSIF (x_stmv_rec.source_table = OKC_API.G_MISS_CHAR) THEN

3102: END IF;
3103:
3104: IF (x_stmv_rec.source_table IS NULL) THEN
3105: x_stmv_rec.source_table := l_stmv_rec.source_table;
3106: ELSIF (x_stmv_rec.source_table = OKC_API.G_MISS_CHAR) THEN
3107: x_stmv_rec.source_table := NULL;
3108: END IF;
3109: -- Added by rgooty: 4212626
3110: IF (x_stmv_rec.trx_id IS NULL) THEN

Line 3112: ELSIF (x_stmv_rec.trx_id = OKC_API.G_MISS_NUM) THEN

3108: END IF;
3109: -- Added by rgooty: 4212626
3110: IF (x_stmv_rec.trx_id IS NULL) THEN
3111: x_stmv_rec.trx_id := l_stmv_rec.trx_id;
3112: ELSIF (x_stmv_rec.trx_id = OKC_API.G_MISS_NUM) THEN
3113: x_stmv_rec.trx_id := NULL;
3114: END IF;
3115: IF (x_stmv_rec.link_hist_stream_id IS NULL) THEN
3116: x_stmv_rec.link_hist_stream_id := l_stmv_rec.link_hist_stream_id;

Line 3117: ELSIF (x_stmv_rec.link_hist_stream_id = OKC_API.G_MISS_NUM) THEN

3113: x_stmv_rec.trx_id := NULL;
3114: END IF;
3115: IF (x_stmv_rec.link_hist_stream_id IS NULL) THEN
3116: x_stmv_rec.link_hist_stream_id := l_stmv_rec.link_hist_stream_id;
3117: ELSIF (x_stmv_rec.link_hist_stream_id = OKC_API.G_MISS_NUM) THEN
3118: x_stmv_rec.link_hist_stream_id := NULL;
3119: END IF;
3120:
3121: RETURN(l_return_status);

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

3127: FUNCTION Set_Attributes (
3128: p_stmv_rec IN stmv_rec_type,
3129: x_stmv_rec OUT NOCOPY stmv_rec_type
3130: ) RETURN VARCHAR2 IS
3131: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3132: BEGIN
3133: x_stmv_rec := p_stmv_rec;
3134: x_stmv_rec.OBJECT_VERSION_NUMBER := NVL(x_stmv_rec.OBJECT_VERSION_NUMBER, 0) + 1;
3135:

Line 3171: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

3167:
3168: RETURN(l_return_status);
3169: END Set_Attributes;
3170: BEGIN
3171: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
3172: G_PKG_NAME,
3173: p_init_msg_list,
3174: l_api_version,
3175: p_api_version,

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

3174: l_api_version,
3175: p_api_version,
3176: '_PVT',
3177: x_return_status);
3178: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3179:
3180:
3181: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3182: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 3181: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

3177: x_return_status);
3178: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3179:
3180:
3181: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3182: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3183: RAISE OKC_API.G_EXCEPTION_ERROR;
3184: END IF;
3185: --- Setting item attributes

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

3178: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3179:
3180:
3181: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3182: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3183: RAISE OKC_API.G_EXCEPTION_ERROR;
3184: END IF;
3185: --- Setting item attributes
3186: l_return_status := Set_Attributes(

Line 3183: RAISE OKC_API.G_EXCEPTION_ERROR;

3179:
3180:
3181: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3182: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3183: RAISE OKC_API.G_EXCEPTION_ERROR;
3184: END IF;
3185: --- Setting item attributes
3186: l_return_status := Set_Attributes(
3187: p_stmv_rec, -- IN

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

3186: l_return_status := Set_Attributes(
3187: p_stmv_rec, -- IN
3188: l_stmv_rec); -- OUT
3189: --- If any errors happen abort API
3190: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3191:
3192:
3193: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3194: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 3193: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

3189: --- If any errors happen abort API
3190: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3191:
3192:
3193: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3194: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3195: RAISE OKC_API.G_EXCEPTION_ERROR;
3196: END IF;
3197: l_return_status := populate_new_record(l_stmv_rec, l_def_stmv_rec);

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

3190: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3191:
3192:
3193: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3194: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3195: RAISE OKC_API.G_EXCEPTION_ERROR;
3196: END IF;
3197: l_return_status := populate_new_record(l_stmv_rec, l_def_stmv_rec);
3198: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 3195: RAISE OKC_API.G_EXCEPTION_ERROR;

3191:
3192:
3193: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3194: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3195: RAISE OKC_API.G_EXCEPTION_ERROR;
3196: END IF;
3197: l_return_status := populate_new_record(l_stmv_rec, l_def_stmv_rec);
3198: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3199:

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

3194: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3195: RAISE OKC_API.G_EXCEPTION_ERROR;
3196: END IF;
3197: l_return_status := populate_new_record(l_stmv_rec, l_def_stmv_rec);
3198: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3199:
3200:
3201: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3202: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 3201: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

3197: l_return_status := populate_new_record(l_stmv_rec, l_def_stmv_rec);
3198: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3199:
3200:
3201: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3202: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3203: RAISE OKC_API.G_EXCEPTION_ERROR;
3204: END IF;
3205: l_def_stmv_rec := fill_who_columns(l_def_stmv_rec);

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

3198: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3199:
3200:
3201: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3202: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3203: RAISE OKC_API.G_EXCEPTION_ERROR;
3204: END IF;
3205: l_def_stmv_rec := fill_who_columns(l_def_stmv_rec);
3206: --- Validate all non-missing attributes (Item Level Validation)

Line 3203: RAISE OKC_API.G_EXCEPTION_ERROR;

3199:
3200:
3201: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3202: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3203: RAISE OKC_API.G_EXCEPTION_ERROR;
3204: END IF;
3205: l_def_stmv_rec := fill_who_columns(l_def_stmv_rec);
3206: --- Validate all non-missing attributes (Item Level Validation)
3207: l_return_status := Validate_Attributes(l_def_stmv_rec);

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

3205: l_def_stmv_rec := fill_who_columns(l_def_stmv_rec);
3206: --- Validate all non-missing attributes (Item Level Validation)
3207: l_return_status := Validate_Attributes(l_def_stmv_rec);
3208: --- If any errors happen abort API
3209: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3210:
3211:
3212: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3213: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 3212: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

3208: --- If any errors happen abort API
3209: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3210:
3211:
3212: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3213: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3214: RAISE OKC_API.G_EXCEPTION_ERROR;
3215: END IF;
3216: l_return_status := Validate_Record(l_def_stmv_rec);

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

3209: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3210:
3211:
3212: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3213: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3214: RAISE OKC_API.G_EXCEPTION_ERROR;
3215: END IF;
3216: l_return_status := Validate_Record(l_def_stmv_rec);
3217: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 3214: RAISE OKC_API.G_EXCEPTION_ERROR;

3210:
3211:
3212: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3213: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3214: RAISE OKC_API.G_EXCEPTION_ERROR;
3215: END IF;
3216: l_return_status := Validate_Record(l_def_stmv_rec);
3217: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3218:

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

3213: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3214: RAISE OKC_API.G_EXCEPTION_ERROR;
3215: END IF;
3216: l_return_status := Validate_Record(l_def_stmv_rec);
3217: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3218:
3219:
3220: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3221: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 3220: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

3216: l_return_status := Validate_Record(l_def_stmv_rec);
3217: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3218:
3219:
3220: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3221: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3222: RAISE OKC_API.G_EXCEPTION_ERROR;
3223: END IF;
3224:

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

3217: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3218:
3219:
3220: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3221: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3222: RAISE OKC_API.G_EXCEPTION_ERROR;
3223: END IF;
3224:
3225: --------------------------------------

Line 3222: RAISE OKC_API.G_EXCEPTION_ERROR;

3218:
3219:
3220: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3221: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3222: RAISE OKC_API.G_EXCEPTION_ERROR;
3223: END IF;
3224:
3225: --------------------------------------
3226: -- Move VIEW record to "Child" records

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

3236: x_msg_data,
3237: l_stm_rec,
3238: lx_stm_rec
3239: );
3240: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3241: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3242: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3243: RAISE OKC_API.G_EXCEPTION_ERROR;
3244: END IF;

Line 3241: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

3237: l_stm_rec,
3238: lx_stm_rec
3239: );
3240: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3241: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3242: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3243: RAISE OKC_API.G_EXCEPTION_ERROR;
3244: END IF;
3245: migrate(lx_stm_rec, l_def_stmv_rec);

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

3238: lx_stm_rec
3239: );
3240: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3241: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3242: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3243: RAISE OKC_API.G_EXCEPTION_ERROR;
3244: END IF;
3245: migrate(lx_stm_rec, l_def_stmv_rec);
3246: x_stmv_rec := l_def_stmv_rec;

Line 3243: RAISE OKC_API.G_EXCEPTION_ERROR;

3239: );
3240: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3241: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3242: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3243: RAISE OKC_API.G_EXCEPTION_ERROR;
3244: END IF;
3245: migrate(lx_stm_rec, l_def_stmv_rec);
3246: x_stmv_rec := l_def_stmv_rec;
3247: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 3247: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

3243: RAISE OKC_API.G_EXCEPTION_ERROR;
3244: END IF;
3245: migrate(lx_stm_rec, l_def_stmv_rec);
3246: x_stmv_rec := l_def_stmv_rec;
3247: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
3248: EXCEPTION
3249: WHEN OKC_API.G_EXCEPTION_ERROR THEN
3250: x_return_status := OKC_API.HANDLE_EXCEPTIONS
3251: (

Line 3249: WHEN OKC_API.G_EXCEPTION_ERROR THEN

3245: migrate(lx_stm_rec, l_def_stmv_rec);
3246: x_stmv_rec := l_def_stmv_rec;
3247: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
3248: EXCEPTION
3249: WHEN OKC_API.G_EXCEPTION_ERROR THEN
3250: x_return_status := OKC_API.HANDLE_EXCEPTIONS
3251: (
3252: l_api_name,
3253: G_PKG_NAME,

Line 3250: x_return_status := OKC_API.HANDLE_EXCEPTIONS

3246: x_stmv_rec := l_def_stmv_rec;
3247: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
3248: EXCEPTION
3249: WHEN OKC_API.G_EXCEPTION_ERROR THEN
3250: x_return_status := OKC_API.HANDLE_EXCEPTIONS
3251: (
3252: l_api_name,
3253: G_PKG_NAME,
3254: 'OKC_API.G_RET_STS_ERROR',

Line 3254: 'OKC_API.G_RET_STS_ERROR',

3250: x_return_status := OKC_API.HANDLE_EXCEPTIONS
3251: (
3252: l_api_name,
3253: G_PKG_NAME,
3254: 'OKC_API.G_RET_STS_ERROR',
3255: x_msg_count,
3256: x_msg_data,
3257: '_PVT'
3258: );

Line 3259: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

3255: x_msg_count,
3256: x_msg_data,
3257: '_PVT'
3258: );
3259: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
3260: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
3261: (
3262: l_api_name,
3263: G_PKG_NAME,

Line 3260: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

3256: x_msg_data,
3257: '_PVT'
3258: );
3259: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
3260: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
3261: (
3262: l_api_name,
3263: G_PKG_NAME,
3264: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 3264: 'OKC_API.G_RET_STS_UNEXP_ERROR',

3260: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
3261: (
3262: l_api_name,
3263: G_PKG_NAME,
3264: 'OKC_API.G_RET_STS_UNEXP_ERROR',
3265: x_msg_count,
3266: x_msg_data,
3267: '_PVT'
3268: );

Line 3270: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

3266: x_msg_data,
3267: '_PVT'
3268: );
3269: WHEN OTHERS THEN
3270: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
3271: (
3272: l_api_name,
3273: G_PKG_NAME,
3274: 'OTHERS',

Line 3285: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

3281: -- PL/SQL TBL update_row for:STMV_TBL --
3282: ----------------------------------------
3283: PROCEDURE update_row(
3284: p_api_version IN NUMBER,
3285: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
3286: x_return_status OUT NOCOPY VARCHAR2,
3287: x_msg_count OUT NOCOPY NUMBER,
3288: x_msg_data OUT NOCOPY VARCHAR2,
3289: p_stmv_tbl IN stmv_tbl_type,

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

3290: x_stmv_tbl OUT NOCOPY stmv_tbl_type) IS
3291:
3292: l_api_version CONSTANT NUMBER := 1;
3293: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_update_row';
3294: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3295: l_overall_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
3296: i NUMBER := 0;
3297: BEGIN
3298: OKC_API.init_msg_list(p_init_msg_list);

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

3291:
3292: l_api_version CONSTANT NUMBER := 1;
3293: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_update_row';
3294: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3295: l_overall_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
3296: i NUMBER := 0;
3297: BEGIN
3298: OKC_API.init_msg_list(p_init_msg_list);
3299: -- Make sure PL/SQL table has records in it before passing

Line 3298: OKC_API.init_msg_list(p_init_msg_list);

3294: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3295: l_overall_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
3296: i NUMBER := 0;
3297: BEGIN
3298: OKC_API.init_msg_list(p_init_msg_list);
3299: -- Make sure PL/SQL table has records in it before passing
3300: IF (p_stmv_tbl.COUNT > 0) THEN
3301: i := p_stmv_tbl.FIRST;
3302: LOOP

Line 3305: p_init_msg_list => OKC_API.G_FALSE,

3301: i := p_stmv_tbl.FIRST;
3302: LOOP
3303: update_row (
3304: p_api_version => p_api_version,
3305: p_init_msg_list => OKC_API.G_FALSE,
3306: x_return_status => x_return_status,
3307: x_msg_count => x_msg_count,
3308: x_msg_data => x_msg_data,
3309: p_stmv_rec => p_stmv_tbl(i),

Line 3313: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN

3309: p_stmv_rec => p_stmv_tbl(i),
3310: x_stmv_rec => x_stmv_tbl(i));
3311: /* Begin Post Generation Change */
3312: -- store the highest degree of error
3313: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
3314: IF l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR THEN
3315: l_overall_status := x_return_status;
3316: END IF;
3317: END IF;

Line 3314: IF l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR THEN

3310: x_stmv_rec => x_stmv_tbl(i));
3311: /* Begin Post Generation Change */
3312: -- store the highest degree of error
3313: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
3314: IF l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR THEN
3315: l_overall_status := x_return_status;
3316: END IF;
3317: END IF;
3318: /* End Post Generation Change */

Line 3326: WHEN OKC_API.G_EXCEPTION_ERROR THEN

3322: -- return the overall status
3323: x_return_status :=l_overall_status;
3324: END IF;
3325: EXCEPTION
3326: WHEN OKC_API.G_EXCEPTION_ERROR THEN
3327: x_return_status := OKC_API.HANDLE_EXCEPTIONS
3328: (
3329: l_api_name,
3330: G_PKG_NAME,

Line 3327: x_return_status := OKC_API.HANDLE_EXCEPTIONS

3323: x_return_status :=l_overall_status;
3324: END IF;
3325: EXCEPTION
3326: WHEN OKC_API.G_EXCEPTION_ERROR THEN
3327: x_return_status := OKC_API.HANDLE_EXCEPTIONS
3328: (
3329: l_api_name,
3330: G_PKG_NAME,
3331: 'OKC_API.G_RET_STS_ERROR',

Line 3331: 'OKC_API.G_RET_STS_ERROR',

3327: x_return_status := OKC_API.HANDLE_EXCEPTIONS
3328: (
3329: l_api_name,
3330: G_PKG_NAME,
3331: 'OKC_API.G_RET_STS_ERROR',
3332: x_msg_count,
3333: x_msg_data,
3334: '_PVT'
3335: );

Line 3336: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

3332: x_msg_count,
3333: x_msg_data,
3334: '_PVT'
3335: );
3336: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
3337: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
3338: (
3339: l_api_name,
3340: G_PKG_NAME,

Line 3337: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

3333: x_msg_data,
3334: '_PVT'
3335: );
3336: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
3337: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
3338: (
3339: l_api_name,
3340: G_PKG_NAME,
3341: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 3341: 'OKC_API.G_RET_STS_UNEXP_ERROR',

3337: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
3338: (
3339: l_api_name,
3340: G_PKG_NAME,
3341: 'OKC_API.G_RET_STS_UNEXP_ERROR',
3342: x_msg_count,
3343: x_msg_data,
3344: '_PVT'
3345: );

Line 3347: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

3343: x_msg_data,
3344: '_PVT'
3345: );
3346: WHEN OTHERS THEN
3347: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
3348: (
3349: l_api_name,
3350: G_PKG_NAME,
3351: 'OTHERS',

Line 3365: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

3361: --------------------------------
3362: -- delete_row for:OKL_STREAMS --
3363: --------------------------------
3364: PROCEDURE delete_row(
3365: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
3366: x_return_status OUT NOCOPY VARCHAR2,
3367: x_msg_count OUT NOCOPY NUMBER,
3368: x_msg_data OUT NOCOPY VARCHAR2,
3369: p_stm_rec IN stm_rec_type) IS

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

3369: p_stm_rec IN stm_rec_type) IS
3370:
3371: l_api_version CONSTANT NUMBER := 1;
3372: l_api_name CONSTANT VARCHAR2(30) := 'STREAMS_delete_row';
3373: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3374: l_stm_rec stm_rec_type:= p_stm_rec;
3375: l_row_notfound BOOLEAN := TRUE;
3376: BEGIN
3377: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 3377: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

3373: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3374: l_stm_rec stm_rec_type:= p_stm_rec;
3375: l_row_notfound BOOLEAN := TRUE;
3376: BEGIN
3377: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
3378: p_init_msg_list,
3379: '_PVT',
3380: x_return_status);
3381: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

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

3377: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
3378: p_init_msg_list,
3379: '_PVT',
3380: x_return_status);
3381: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3382: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3383: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3384: RAISE OKC_API.G_EXCEPTION_ERROR;
3385: END IF;

Line 3382: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

3378: p_init_msg_list,
3379: '_PVT',
3380: x_return_status);
3381: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3382: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3383: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3384: RAISE OKC_API.G_EXCEPTION_ERROR;
3385: END IF;
3386: DELETE FROM OKL_STREAMS

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

3379: '_PVT',
3380: x_return_status);
3381: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3382: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3383: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3384: RAISE OKC_API.G_EXCEPTION_ERROR;
3385: END IF;
3386: DELETE FROM OKL_STREAMS
3387: WHERE ID = l_stm_rec.id;

Line 3384: RAISE OKC_API.G_EXCEPTION_ERROR;

3380: x_return_status);
3381: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3382: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3383: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3384: RAISE OKC_API.G_EXCEPTION_ERROR;
3385: END IF;
3386: DELETE FROM OKL_STREAMS
3387: WHERE ID = l_stm_rec.id;
3388:

Line 3389: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

3385: END IF;
3386: DELETE FROM OKL_STREAMS
3387: WHERE ID = l_stm_rec.id;
3388:
3389: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
3390: EXCEPTION
3391: WHEN OKC_API.G_EXCEPTION_ERROR THEN
3392: x_return_status := OKC_API.HANDLE_EXCEPTIONS
3393: (

Line 3391: WHEN OKC_API.G_EXCEPTION_ERROR THEN

3387: WHERE ID = l_stm_rec.id;
3388:
3389: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
3390: EXCEPTION
3391: WHEN OKC_API.G_EXCEPTION_ERROR THEN
3392: x_return_status := OKC_API.HANDLE_EXCEPTIONS
3393: (
3394: l_api_name,
3395: G_PKG_NAME,

Line 3392: x_return_status := OKC_API.HANDLE_EXCEPTIONS

3388:
3389: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
3390: EXCEPTION
3391: WHEN OKC_API.G_EXCEPTION_ERROR THEN
3392: x_return_status := OKC_API.HANDLE_EXCEPTIONS
3393: (
3394: l_api_name,
3395: G_PKG_NAME,
3396: 'OKC_API.G_RET_STS_ERROR',

Line 3396: 'OKC_API.G_RET_STS_ERROR',

3392: x_return_status := OKC_API.HANDLE_EXCEPTIONS
3393: (
3394: l_api_name,
3395: G_PKG_NAME,
3396: 'OKC_API.G_RET_STS_ERROR',
3397: x_msg_count,
3398: x_msg_data,
3399: '_PVT'
3400: );

Line 3401: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

3397: x_msg_count,
3398: x_msg_data,
3399: '_PVT'
3400: );
3401: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
3402: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
3403: (
3404: l_api_name,
3405: G_PKG_NAME,

Line 3402: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

3398: x_msg_data,
3399: '_PVT'
3400: );
3401: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
3402: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
3403: (
3404: l_api_name,
3405: G_PKG_NAME,
3406: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 3406: 'OKC_API.G_RET_STS_UNEXP_ERROR',

3402: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
3403: (
3404: l_api_name,
3405: G_PKG_NAME,
3406: 'OKC_API.G_RET_STS_UNEXP_ERROR',
3407: x_msg_count,
3408: x_msg_data,
3409: '_PVT'
3410: );

Line 3412: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

3408: x_msg_data,
3409: '_PVT'
3410: );
3411: WHEN OTHERS THEN
3412: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
3413: (
3414: l_api_name,
3415: G_PKG_NAME,
3416: 'OTHERS',

Line 3427: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

3423: -- delete_row for:OKL_STREAMS_V --
3424: ----------------------------------
3425: PROCEDURE delete_row(
3426: p_api_version IN NUMBER,
3427: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
3428: x_return_status OUT NOCOPY VARCHAR2,
3429: x_msg_count OUT NOCOPY NUMBER,
3430: x_msg_data OUT NOCOPY VARCHAR2,
3431: p_stmv_rec IN stmv_rec_type) IS

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

3431: p_stmv_rec IN stmv_rec_type) IS
3432:
3433: l_api_version CONSTANT NUMBER := 1;
3434: l_api_name CONSTANT VARCHAR2(30) := 'V_delete_row';
3435: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3436: l_stmv_rec stmv_rec_type := p_stmv_rec;
3437: l_stm_rec stm_rec_type;
3438: BEGIN
3439: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 3439: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

3435: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3436: l_stmv_rec stmv_rec_type := p_stmv_rec;
3437: l_stm_rec stm_rec_type;
3438: BEGIN
3439: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
3440: G_PKG_NAME,
3441: p_init_msg_list,
3442: l_api_version,
3443: p_api_version,

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

3442: l_api_version,
3443: p_api_version,
3444: '_PVT',
3445: x_return_status);
3446: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3447: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3448: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3449: RAISE OKC_API.G_EXCEPTION_ERROR;
3450: END IF;

Line 3447: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

3443: p_api_version,
3444: '_PVT',
3445: x_return_status);
3446: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3447: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3448: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3449: RAISE OKC_API.G_EXCEPTION_ERROR;
3450: END IF;
3451: --------------------------------------

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

3444: '_PVT',
3445: x_return_status);
3446: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3447: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3448: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3449: RAISE OKC_API.G_EXCEPTION_ERROR;
3450: END IF;
3451: --------------------------------------
3452: -- Move VIEW record to "Child" records

Line 3449: RAISE OKC_API.G_EXCEPTION_ERROR;

3445: x_return_status);
3446: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3447: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3448: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3449: RAISE OKC_API.G_EXCEPTION_ERROR;
3450: END IF;
3451: --------------------------------------
3452: -- Move VIEW record to "Child" records
3453: --------------------------------------

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

3461: x_msg_count,
3462: x_msg_data,
3463: l_stm_rec
3464: );
3465: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3466: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3467: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3468: RAISE OKC_API.G_EXCEPTION_ERROR;
3469: END IF;

Line 3466: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

3462: x_msg_data,
3463: l_stm_rec
3464: );
3465: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3466: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3467: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3468: RAISE OKC_API.G_EXCEPTION_ERROR;
3469: END IF;
3470: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

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

3463: l_stm_rec
3464: );
3465: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3466: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3467: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3468: RAISE OKC_API.G_EXCEPTION_ERROR;
3469: END IF;
3470: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
3471: EXCEPTION

Line 3468: RAISE OKC_API.G_EXCEPTION_ERROR;

3464: );
3465: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3466: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3467: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3468: RAISE OKC_API.G_EXCEPTION_ERROR;
3469: END IF;
3470: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
3471: EXCEPTION
3472: WHEN OKC_API.G_EXCEPTION_ERROR THEN

Line 3470: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

3466: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3467: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3468: RAISE OKC_API.G_EXCEPTION_ERROR;
3469: END IF;
3470: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
3471: EXCEPTION
3472: WHEN OKC_API.G_EXCEPTION_ERROR THEN
3473: x_return_status := OKC_API.HANDLE_EXCEPTIONS
3474: (

Line 3472: WHEN OKC_API.G_EXCEPTION_ERROR THEN

3468: RAISE OKC_API.G_EXCEPTION_ERROR;
3469: END IF;
3470: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
3471: EXCEPTION
3472: WHEN OKC_API.G_EXCEPTION_ERROR THEN
3473: x_return_status := OKC_API.HANDLE_EXCEPTIONS
3474: (
3475: l_api_name,
3476: G_PKG_NAME,

Line 3473: x_return_status := OKC_API.HANDLE_EXCEPTIONS

3469: END IF;
3470: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
3471: EXCEPTION
3472: WHEN OKC_API.G_EXCEPTION_ERROR THEN
3473: x_return_status := OKC_API.HANDLE_EXCEPTIONS
3474: (
3475: l_api_name,
3476: G_PKG_NAME,
3477: 'OKC_API.G_RET_STS_ERROR',

Line 3477: 'OKC_API.G_RET_STS_ERROR',

3473: x_return_status := OKC_API.HANDLE_EXCEPTIONS
3474: (
3475: l_api_name,
3476: G_PKG_NAME,
3477: 'OKC_API.G_RET_STS_ERROR',
3478: x_msg_count,
3479: x_msg_data,
3480: '_PVT'
3481: );

Line 3482: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

3478: x_msg_count,
3479: x_msg_data,
3480: '_PVT'
3481: );
3482: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
3483: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
3484: (
3485: l_api_name,
3486: G_PKG_NAME,

Line 3483: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

3479: x_msg_data,
3480: '_PVT'
3481: );
3482: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
3483: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
3484: (
3485: l_api_name,
3486: G_PKG_NAME,
3487: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 3487: 'OKC_API.G_RET_STS_UNEXP_ERROR',

3483: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
3484: (
3485: l_api_name,
3486: G_PKG_NAME,
3487: 'OKC_API.G_RET_STS_UNEXP_ERROR',
3488: x_msg_count,
3489: x_msg_data,
3490: '_PVT'
3491: );

Line 3493: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

3489: x_msg_data,
3490: '_PVT'
3491: );
3492: WHEN OTHERS THEN
3493: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
3494: (
3495: l_api_name,
3496: G_PKG_NAME,
3497: 'OTHERS',

Line 3508: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

3504: -- PL/SQL TBL delete_row for:STMV_TBL --
3505: ----------------------------------------
3506: PROCEDURE delete_row(
3507: p_api_version IN NUMBER,
3508: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
3509: x_return_status OUT NOCOPY VARCHAR2,
3510: x_msg_count OUT NOCOPY NUMBER,
3511: x_msg_data OUT NOCOPY VARCHAR2,
3512: p_stmv_tbl IN stmv_tbl_type) IS

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

3512: p_stmv_tbl IN stmv_tbl_type) IS
3513:
3514: l_api_version CONSTANT NUMBER := 1;
3515: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_delete_row';
3516: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3517: l_overall_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
3518:
3519: i NUMBER := 0;
3520: BEGIN

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

3513:
3514: l_api_version CONSTANT NUMBER := 1;
3515: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_delete_row';
3516: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3517: l_overall_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
3518:
3519: i NUMBER := 0;
3520: BEGIN
3521: OKC_API.init_msg_list(p_init_msg_list);

Line 3521: OKC_API.init_msg_list(p_init_msg_list);

3517: l_overall_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
3518:
3519: i NUMBER := 0;
3520: BEGIN
3521: OKC_API.init_msg_list(p_init_msg_list);
3522: -- Make sure PL/SQL table has records in it before passing
3523: IF (p_stmv_tbl.COUNT > 0) THEN
3524: i := p_stmv_tbl.FIRST;
3525: LOOP

Line 3528: p_init_msg_list => OKC_API.G_FALSE,

3524: i := p_stmv_tbl.FIRST;
3525: LOOP
3526: delete_row (
3527: p_api_version => p_api_version,
3528: p_init_msg_list => OKC_API.G_FALSE,
3529: x_return_status => x_return_status,
3530: x_msg_count => x_msg_count,
3531: x_msg_data => x_msg_data,
3532: p_stmv_rec => p_stmv_tbl(i));

Line 3536: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN

3532: p_stmv_rec => p_stmv_tbl(i));
3533:
3534: /* Begin Post Generation Change */
3535: -- store the highest degree of error
3536: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
3537: IF l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR THEN
3538: l_overall_status := x_return_status;
3539: END IF;
3540: END IF;

Line 3537: IF l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR THEN

3533:
3534: /* Begin Post Generation Change */
3535: -- store the highest degree of error
3536: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
3537: IF l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR THEN
3538: l_overall_status := x_return_status;
3539: END IF;
3540: END IF;
3541: /* End Post Generation Change */

Line 3550: WHEN OKC_API.G_EXCEPTION_ERROR THEN

3546: x_return_status :=l_overall_status;
3547:
3548: END IF;
3549: EXCEPTION
3550: WHEN OKC_API.G_EXCEPTION_ERROR THEN
3551: x_return_status := OKC_API.HANDLE_EXCEPTIONS
3552: (
3553: l_api_name,
3554: G_PKG_NAME,

Line 3551: x_return_status := OKC_API.HANDLE_EXCEPTIONS

3547:
3548: END IF;
3549: EXCEPTION
3550: WHEN OKC_API.G_EXCEPTION_ERROR THEN
3551: x_return_status := OKC_API.HANDLE_EXCEPTIONS
3552: (
3553: l_api_name,
3554: G_PKG_NAME,
3555: 'OKC_API.G_RET_STS_ERROR',

Line 3555: 'OKC_API.G_RET_STS_ERROR',

3551: x_return_status := OKC_API.HANDLE_EXCEPTIONS
3552: (
3553: l_api_name,
3554: G_PKG_NAME,
3555: 'OKC_API.G_RET_STS_ERROR',
3556: x_msg_count,
3557: x_msg_data,
3558: '_PVT'
3559: );

Line 3560: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

3556: x_msg_count,
3557: x_msg_data,
3558: '_PVT'
3559: );
3560: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
3561: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
3562: (
3563: l_api_name,
3564: G_PKG_NAME,

Line 3561: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

3557: x_msg_data,
3558: '_PVT'
3559: );
3560: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
3561: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
3562: (
3563: l_api_name,
3564: G_PKG_NAME,
3565: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 3565: 'OKC_API.G_RET_STS_UNEXP_ERROR',

3561: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
3562: (
3563: l_api_name,
3564: G_PKG_NAME,
3565: 'OKC_API.G_RET_STS_UNEXP_ERROR',
3566: x_msg_count,
3567: x_msg_data,
3568: '_PVT'
3569: );

Line 3571: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

3567: x_msg_data,
3568: '_PVT'
3569: );
3570: WHEN OTHERS THEN
3571: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
3572: (
3573: l_api_name,
3574: G_PKG_NAME,
3575: 'OTHERS',