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_GTP_PVT dependencies on OKL_API

Line 172: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

168: ----------------------------------------------
169: FUNCTION validate_record (
170: p_gtpv_rec IN gtpv_rec_type
171: ) RETURN VARCHAR2 IS
172: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
173: BEGIN
174:
175: IF ( p_gtpv_rec.display_yn = 'Y' AND ( p_gtpv_rec.update_yn NOT IN ( 'Y' , 'N' ) ) )
176: THEN

Line 177: okl_api.SET_MESSAGE( p_app_name => g_app_name,

173: BEGIN
174:
175: IF ( p_gtpv_rec.display_yn = 'Y' AND ( p_gtpv_rec.update_yn NOT IN ( 'Y' , 'N' ) ) )
176: THEN
177: okl_api.SET_MESSAGE( p_app_name => g_app_name,
178: p_msg_name => 'OKL_DUMMY_MESSAGE',
179: p_token1 => 'TOKEN1',
180: p_token1_value => 'UPDATE_YN cannot have a value with out a value in DISPLAY_YN');
181: l_return_status := Okl_Api.G_RET_STS_ERROR;

Line 181: l_return_status := Okl_Api.G_RET_STS_ERROR;

177: okl_api.SET_MESSAGE( p_app_name => g_app_name,
178: p_msg_name => 'OKL_DUMMY_MESSAGE',
179: p_token1 => 'TOKEN1',
180: p_token1_value => 'UPDATE_YN cannot have a value with out a value in DISPLAY_YN');
181: l_return_status := Okl_Api.G_RET_STS_ERROR;
182: RAISE G_EXCEPTION_HALT_VALIDATION;
183: END IF;
184:
185: RETURN (l_return_status);

Line 194: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME

190: NULL;
191:
192: WHEN OTHERS THEN
193: -- store SQL error message on message stack for caller
194: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME
195: ,p_msg_name => G_UNEXPECTED_ERROR
196: ,p_token1 => G_SQLCODE_TOKEN
197: ,p_token1_value => SQLCODE
198: ,p_token2 => G_SQLERRM_TOKEN

Line 202: l_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

198: ,p_token2 => G_SQLERRM_TOKEN
199: ,p_token2_value => SQLERRM);
200:
201: -- notify caller of an UNEXPECTED error
202: l_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
203:
204: END validate_record;
205:
206:

Line 226: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

222: ) IS
223:
224: BEGIN
225: -- initialize return status
226: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
227:
228: IF p_gtpv_rec.id = Okl_Api.G_MISS_NUM OR
229: p_gtpv_rec.id IS NULL
230: THEN

Line 228: IF p_gtpv_rec.id = Okl_Api.G_MISS_NUM OR

224: BEGIN
225: -- initialize return status
226: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
227:
228: IF p_gtpv_rec.id = Okl_Api.G_MISS_NUM OR
229: p_gtpv_rec.id IS NULL
230: THEN
231: Okl_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'id');
232: x_return_status := Okl_Api.G_RET_STS_ERROR;

Line 231: Okl_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'id');

227:
228: IF p_gtpv_rec.id = Okl_Api.G_MISS_NUM OR
229: p_gtpv_rec.id IS NULL
230: THEN
231: Okl_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'id');
232: x_return_status := Okl_Api.G_RET_STS_ERROR;
233: RAISE G_EXCEPTION_HALT_VALIDATION;
234: END IF;
235:

Line 232: x_return_status := Okl_Api.G_RET_STS_ERROR;

228: IF p_gtpv_rec.id = Okl_Api.G_MISS_NUM OR
229: p_gtpv_rec.id IS NULL
230: THEN
231: Okl_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'id');
232: x_return_status := Okl_Api.G_RET_STS_ERROR;
233: RAISE G_EXCEPTION_HALT_VALIDATION;
234: END IF;
235:
236: EXCEPTION

Line 243: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME

239: -- with the next column
240: NULL;
241: WHEN OTHERS THEN
242: -- store SQL error message on message stack for caller
243: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME
244: ,p_msg_name => G_UNEXPECTED_ERROR
245: ,p_token1 => G_SQLCODE_TOKEN
246: ,p_token1_value => SQLCODE
247: ,p_token2 => G_SQLERRM_TOKEN

Line 251: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

247: ,p_token2 => G_SQLERRM_TOKEN
248: ,p_token2_value => SQLERRM);
249:
250: -- notify caller of an UNEXPECTED error
251: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
252:
253: END Validate_Id;
254:
255: ---------------------------------------------------------------------------

Line 275: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

271:
272: BEGIN
273:
274: -- initialize return status
275: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
276:
277: IF p_gtpv_rec.object_version_number = Okl_Api.G_MISS_NUM OR
278: p_gtpv_rec.object_version_number IS NULL
279: THEN

Line 277: IF p_gtpv_rec.object_version_number = Okl_Api.G_MISS_NUM OR

273:
274: -- initialize return status
275: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
276:
277: IF p_gtpv_rec.object_version_number = Okl_Api.G_MISS_NUM OR
278: p_gtpv_rec.object_version_number IS NULL
279: THEN
280: Okl_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'object_version_number');
281: x_return_status := Okl_Api.G_RET_STS_ERROR;

Line 280: Okl_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'object_version_number');

276:
277: IF p_gtpv_rec.object_version_number = Okl_Api.G_MISS_NUM OR
278: p_gtpv_rec.object_version_number IS NULL
279: THEN
280: Okl_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'object_version_number');
281: x_return_status := Okl_Api.G_RET_STS_ERROR;
282: RAISE G_EXCEPTION_HALT_VALIDATION;
283: END IF;
284:

Line 281: x_return_status := Okl_Api.G_RET_STS_ERROR;

277: IF p_gtpv_rec.object_version_number = Okl_Api.G_MISS_NUM OR
278: p_gtpv_rec.object_version_number IS NULL
279: THEN
280: Okl_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'object_version_number');
281: x_return_status := Okl_Api.G_RET_STS_ERROR;
282: RAISE G_EXCEPTION_HALT_VALIDATION;
283: END IF;
284:
285: EXCEPTION

Line 293: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME

289: NULL;
290:
291: WHEN OTHERS THEN
292: -- store SQL error message on message stack for caller
293: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME
294: ,p_msg_name => G_UNEXPECTED_ERROR
295: ,p_token1 => G_SQLCODE_TOKEN
296: ,p_token1_value => SQLCODE
297: ,p_token2 => G_SQLERRM_TOKEN

Line 301: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

297: ,p_token2 => G_SQLERRM_TOKEN
298: ,p_token2_value => SQLERRM);
299:
300: -- notify caller of an UNEXPECTED error
301: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
302: END Validate_Object_Version_Number;
303:
304: PROCEDURE Validate_name(
305: p_gtpv_rec IN gtpv_rec_type,

Line 316: l_name_in_use VARCHAR2(1) := okl_api.G_FALSE;

312: NAME PRC_PARAM_NAME
313: FROM OKL_ST_GEN_PRC_PARAMS gtp
314: WHERE UPPER(gtp.name) = upper( p_name )
315: AND gtp.gtt_id = p_gtt_id;
316: l_name_in_use VARCHAR2(1) := okl_api.G_FALSE;
317: BEGIN
318: -- initialize return status
319: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
320: IF p_gtpv_rec.name = Okl_Api.G_MISS_CHAR OR

Line 319: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

315: AND gtp.gtt_id = p_gtt_id;
316: l_name_in_use VARCHAR2(1) := okl_api.G_FALSE;
317: BEGIN
318: -- initialize return status
319: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
320: IF p_gtpv_rec.name = Okl_Api.G_MISS_CHAR OR
321: p_gtpv_rec.name IS NULL
322: THEN
323: Okl_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'PRICING_PARAM_NAME');

Line 320: IF p_gtpv_rec.name = Okl_Api.G_MISS_CHAR OR

316: l_name_in_use VARCHAR2(1) := okl_api.G_FALSE;
317: BEGIN
318: -- initialize return status
319: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
320: IF p_gtpv_rec.name = Okl_Api.G_MISS_CHAR OR
321: p_gtpv_rec.name IS NULL
322: THEN
323: Okl_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'PRICING_PARAM_NAME');
324: x_return_status := Okl_Api.G_RET_STS_ERROR;

Line 323: Okl_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'PRICING_PARAM_NAME');

319: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
320: IF p_gtpv_rec.name = Okl_Api.G_MISS_CHAR OR
321: p_gtpv_rec.name IS NULL
322: THEN
323: Okl_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'PRICING_PARAM_NAME');
324: x_return_status := Okl_Api.G_RET_STS_ERROR;
325: RAISE G_EXCEPTION_HALT_VALIDATION;
326: ELSE
327: -- Check for the pricing parameter within this template and with the same name

Line 324: x_return_status := Okl_Api.G_RET_STS_ERROR;

320: IF p_gtpv_rec.name = Okl_Api.G_MISS_CHAR OR
321: p_gtpv_rec.name IS NULL
322: THEN
323: Okl_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'PRICING_PARAM_NAME');
324: x_return_status := Okl_Api.G_RET_STS_ERROR;
325: RAISE G_EXCEPTION_HALT_VALIDATION;
326: ELSE
327: -- Check for the pricing parameter within this template and with the same name
328: -- and with different ID. Because in Update you may update the existing pricing param name.

Line 333: l_name_in_use := Okl_Api.G_TRUE;

329: FOR gtpv_temp_rec In okl_st_gen_prc_params_csr(p_gtpv_rec.name,p_gtpv_rec.gtt_id)
330: LOOP
331: IF( gtpv_temp_rec.id <> p_gtpv_rec.id )
332: THEN
333: l_name_in_use := Okl_Api.G_TRUE;
334: END IF;
335: END LOOP;
336: IF ( l_name_in_use = Okl_Api.G_TRUE )
337: THEN

Line 336: IF ( l_name_in_use = Okl_Api.G_TRUE )

332: THEN
333: l_name_in_use := Okl_Api.G_TRUE;
334: END IF;
335: END LOOP;
336: IF ( l_name_in_use = Okl_Api.G_TRUE )
337: THEN
338: okl_api.set_message(G_APP_NAME,
339: G_INVALID_VALUE,
340: G_COL_NAME_TOKEN,

Line 338: okl_api.set_message(G_APP_NAME,

334: END IF;
335: END LOOP;
336: IF ( l_name_in_use = Okl_Api.G_TRUE )
337: THEN
338: okl_api.set_message(G_APP_NAME,
339: G_INVALID_VALUE,
340: G_COL_NAME_TOKEN,
341: 'PRICING_PARAM_NAME');
342: x_return_status := okl_api.G_RET_STS_ERROR;

Line 342: x_return_status := okl_api.G_RET_STS_ERROR;

338: okl_api.set_message(G_APP_NAME,
339: G_INVALID_VALUE,
340: G_COL_NAME_TOKEN,
341: 'PRICING_PARAM_NAME');
342: x_return_status := okl_api.G_RET_STS_ERROR;
343: RAISE G_EXCEPTION_HALT_VALIDATION;
344: END IF;
345: END IF;
346: EXCEPTION

Line 354: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME

350: NULL;
351:
352: WHEN OTHERS THEN
353: -- store SQL error message on message stack for caller
354: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME
355: ,p_msg_name => G_UNEXPECTED_ERROR
356: ,p_token1 => G_SQLCODE_TOKEN
357: ,p_token1_value => SQLCODE
358: ,p_token2 => G_SQLERRM_TOKEN

Line 362: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

358: ,p_token2 => G_SQLERRM_TOKEN
359: ,p_token2_value => SQLERRM);
360:
361: -- notify caller of an UNEXPECTED error
362: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
363:
364: END Validate_name;
365:
366: PROCEDURE validate_gtt_id (p_gtpv_rec IN gtpv_rec_type

Line 370: l_dummy VARCHAR2(1) := Okl_Api.G_FALSE;

366: PROCEDURE validate_gtt_id (p_gtpv_rec IN gtpv_rec_type
367: ,x_return_status OUT NOCOPY VARCHAR2 )
368: IS
369:
370: l_dummy VARCHAR2(1) := Okl_Api.G_FALSE;
371:
372: CURSOR gtt_csr(p_gtt_id NUMBER) IS
373: SELECT '1'
374: FROM OKL_ST_GEN_TEMPLATES

Line 379: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

375: WHERE OKL_ST_GEN_TEMPLATES.ID = p_gtt_id;
376:
377:
378: BEGIN
379: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
380:
381: IF (p_gtpv_rec.gtt_id IS NOT NULL) AND (p_gtpv_rec.gtt_id <> Okl_Api.G_MISS_NUM) THEN
382: OPEN gtt_csr(p_gtpv_rec.gtt_id);
383: FETCH gtt_csr INTO l_dummy;

Line 381: IF (p_gtpv_rec.gtt_id IS NOT NULL) AND (p_gtpv_rec.gtt_id <> Okl_Api.G_MISS_NUM) THEN

377:
378: BEGIN
379: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
380:
381: IF (p_gtpv_rec.gtt_id IS NOT NULL) AND (p_gtpv_rec.gtt_id <> Okl_Api.G_MISS_NUM) THEN
382: OPEN gtt_csr(p_gtpv_rec.gtt_id);
383: FETCH gtt_csr INTO l_dummy;
384: IF (gtt_csr%NOTFOUND) THEN
385: Okl_Api.SET_MESSAGE(p_app_name => g_app_name

Line 385: Okl_Api.SET_MESSAGE(p_app_name => g_app_name

381: IF (p_gtpv_rec.gtt_id IS NOT NULL) AND (p_gtpv_rec.gtt_id <> Okl_Api.G_MISS_NUM) THEN
382: OPEN gtt_csr(p_gtpv_rec.gtt_id);
383: FETCH gtt_csr INTO l_dummy;
384: IF (gtt_csr%NOTFOUND) THEN
385: Okl_Api.SET_MESSAGE(p_app_name => g_app_name
386: ,p_msg_name => g_invalid_value
387: ,p_token1 => g_col_name_token
388: ,p_token1_value => 'GTT_ID');
389: x_return_status := Okl_Api.G_RET_STS_ERROR;

Line 389: x_return_status := Okl_Api.G_RET_STS_ERROR;

385: Okl_Api.SET_MESSAGE(p_app_name => g_app_name
386: ,p_msg_name => g_invalid_value
387: ,p_token1 => g_col_name_token
388: ,p_token1_value => 'GTT_ID');
389: x_return_status := Okl_Api.G_RET_STS_ERROR;
390: CLOSE gtt_csr;
391: RAISE G_EXCEPTION_HALT_VALIDATION;
392: END IF;
393: CLOSE gtt_csr;

Line 395: Okl_Api.SET_MESSAGE(p_app_name => g_app_name

391: RAISE G_EXCEPTION_HALT_VALIDATION;
392: END IF;
393: CLOSE gtt_csr;
394: ELSE
395: Okl_Api.SET_MESSAGE(p_app_name => g_app_name
396: ,p_msg_name => g_invalid_value
397: ,p_token1 => g_col_name_token
398: ,p_token1_value => 'GTT_ID');
399: x_return_status := Okl_Api.G_RET_STS_ERROR;

Line 399: x_return_status := Okl_Api.G_RET_STS_ERROR;

395: Okl_Api.SET_MESSAGE(p_app_name => g_app_name
396: ,p_msg_name => g_invalid_value
397: ,p_token1 => g_col_name_token
398: ,p_token1_value => 'GTT_ID');
399: x_return_status := Okl_Api.G_RET_STS_ERROR;
400: RAISE G_EXCEPTION_HALT_VALIDATION;
401: END IF;
402:
403: EXCEPTION

Line 411: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,

407: NULL;
408:
409: WHEN OTHERS THEN
410: -- store SQL error message on message stack for caller
411: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,
412: p_msg_name => g_unexpected_error,
413: p_token1 => g_sqlcode_token,
414: p_token1_value => SQLCODE,
415: p_token2 => g_sqlerrm_token,

Line 419: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

415: p_token2 => g_sqlerrm_token,
416: p_token2_value => SQLERRM);
417:
418: -- notify caller of an UNEXPECTED error
419: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
420:
421: END validate_gtt_id;
422:
423: PROCEDURE Validate_prc_eng_ident(

Line 429: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

425: x_return_status OUT NOCOPY VARCHAR2
426: ) IS
427: BEGIN
428: -- initialize return status
429: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
430:
431: IF p_gtpv_rec.prc_eng_ident = Okl_Api.G_MISS_CHAR OR
432: p_gtpv_rec.prc_eng_ident IS NULL
433: THEN

Line 431: IF p_gtpv_rec.prc_eng_ident = Okl_Api.G_MISS_CHAR OR

427: BEGIN
428: -- initialize return status
429: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
430:
431: IF p_gtpv_rec.prc_eng_ident = Okl_Api.G_MISS_CHAR OR
432: p_gtpv_rec.prc_eng_ident IS NULL
433: THEN
434: Okl_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'PRC_ENG_IDENT');
435: x_return_status := Okl_Api.G_RET_STS_ERROR;

Line 434: Okl_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'PRC_ENG_IDENT');

430:
431: IF p_gtpv_rec.prc_eng_ident = Okl_Api.G_MISS_CHAR OR
432: p_gtpv_rec.prc_eng_ident IS NULL
433: THEN
434: Okl_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'PRC_ENG_IDENT');
435: x_return_status := Okl_Api.G_RET_STS_ERROR;
436: RAISE G_EXCEPTION_HALT_VALIDATION;
437: END IF;
438:

Line 435: x_return_status := Okl_Api.G_RET_STS_ERROR;

431: IF p_gtpv_rec.prc_eng_ident = Okl_Api.G_MISS_CHAR OR
432: p_gtpv_rec.prc_eng_ident IS NULL
433: THEN
434: Okl_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'PRC_ENG_IDENT');
435: x_return_status := Okl_Api.G_RET_STS_ERROR;
436: RAISE G_EXCEPTION_HALT_VALIDATION;
437: END IF;
438:
439: EXCEPTION

Line 447: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME

443: NULL;
444:
445: WHEN OTHERS THEN
446: -- store SQL error message on message stack for caller
447: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME
448: ,p_msg_name => G_UNEXPECTED_ERROR
449: ,p_token1 => G_SQLCODE_TOKEN
450: ,p_token1_value => SQLCODE
451: ,p_token2 => G_SQLERRM_TOKEN

Line 455: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

451: ,p_token2 => G_SQLERRM_TOKEN
452: ,p_token2_value => SQLERRM);
453:
454: -- notify caller of an UNEXPECTED error
455: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
456: END Validate_prc_eng_ident;
457:
458: PROCEDURE Validate_default_value(
459: p_gtpv_rec IN gtpv_rec_type,

Line 464: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

460: x_return_status OUT NOCOPY VARCHAR2
461: ) IS
462: BEGIN
463: -- initialize return status
464: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
465:
466: IF p_gtpv_rec.default_value = Okl_Api.G_MISS_CHAR OR
467: p_gtpv_rec.default_value IS NULL
468: THEN

Line 466: IF p_gtpv_rec.default_value = Okl_Api.G_MISS_CHAR OR

462: BEGIN
463: -- initialize return status
464: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
465:
466: IF p_gtpv_rec.default_value = Okl_Api.G_MISS_CHAR OR
467: p_gtpv_rec.default_value IS NULL
468: THEN
469: Okl_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'DEFAULT_VALUE');
470: x_return_status := Okl_Api.G_RET_STS_ERROR;

Line 469: Okl_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'DEFAULT_VALUE');

465:
466: IF p_gtpv_rec.default_value = Okl_Api.G_MISS_CHAR OR
467: p_gtpv_rec.default_value IS NULL
468: THEN
469: Okl_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'DEFAULT_VALUE');
470: x_return_status := Okl_Api.G_RET_STS_ERROR;
471: RAISE G_EXCEPTION_HALT_VALIDATION;
472: END IF;
473:

Line 470: x_return_status := Okl_Api.G_RET_STS_ERROR;

466: IF p_gtpv_rec.default_value = Okl_Api.G_MISS_CHAR OR
467: p_gtpv_rec.default_value IS NULL
468: THEN
469: Okl_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'DEFAULT_VALUE');
470: x_return_status := Okl_Api.G_RET_STS_ERROR;
471: RAISE G_EXCEPTION_HALT_VALIDATION;
472: END IF;
473:
474: EXCEPTION

Line 482: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME

478: NULL;
479:
480: WHEN OTHERS THEN
481: -- store SQL error message on message stack for caller
482: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME
483: ,p_msg_name => G_UNEXPECTED_ERROR
484: ,p_token1 => G_SQLCODE_TOKEN
485: ,p_token1_value => SQLCODE
486: ,p_token2 => G_SQLERRM_TOKEN

Line 490: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

486: ,p_token2 => G_SQLERRM_TOKEN
487: ,p_token2_value => SQLERRM);
488:
489: -- notify caller of an UNEXPECTED error
490: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
491: END Validate_default_value;
492:
493: PROCEDURE Validate_update_yn(
494: p_gtpv_rec IN gtpv_rec_type,

Line 500: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

496: ) IS
497:
498: BEGIN
499: -- initialize return status
500: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
501:
502: IF p_gtpv_rec.update_yn IS NOT NULL AND p_gtpv_rec.update_yn NOT IN ( 'Y', 'N' )
503: AND p_gtpv_rec.update_yn <> Okl_Api.G_MISS_CHAR THEN
504: Okl_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'UPDATE_YN');

Line 503: AND p_gtpv_rec.update_yn <> Okl_Api.G_MISS_CHAR THEN

499: -- initialize return status
500: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
501:
502: IF p_gtpv_rec.update_yn IS NOT NULL AND p_gtpv_rec.update_yn NOT IN ( 'Y', 'N' )
503: AND p_gtpv_rec.update_yn <> Okl_Api.G_MISS_CHAR THEN
504: Okl_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'UPDATE_YN');
505: x_return_status := Okl_Api.G_RET_STS_ERROR;
506: RAISE G_EXCEPTION_HALT_VALIDATION;
507: END IF;

Line 504: Okl_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'UPDATE_YN');

500: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
501:
502: IF p_gtpv_rec.update_yn IS NOT NULL AND p_gtpv_rec.update_yn NOT IN ( 'Y', 'N' )
503: AND p_gtpv_rec.update_yn <> Okl_Api.G_MISS_CHAR THEN
504: Okl_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'UPDATE_YN');
505: x_return_status := Okl_Api.G_RET_STS_ERROR;
506: RAISE G_EXCEPTION_HALT_VALIDATION;
507: END IF;
508:

Line 505: x_return_status := Okl_Api.G_RET_STS_ERROR;

501:
502: IF p_gtpv_rec.update_yn IS NOT NULL AND p_gtpv_rec.update_yn NOT IN ( 'Y', 'N' )
503: AND p_gtpv_rec.update_yn <> Okl_Api.G_MISS_CHAR THEN
504: Okl_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'UPDATE_YN');
505: x_return_status := Okl_Api.G_RET_STS_ERROR;
506: RAISE G_EXCEPTION_HALT_VALIDATION;
507: END IF;
508:
509: EXCEPTION

Line 517: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME

513: NULL;
514:
515: WHEN OTHERS THEN
516: -- store SQL error message on message stack for caller
517: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME
518: ,p_msg_name => G_UNEXPECTED_ERROR
519: ,p_token1 => G_SQLCODE_TOKEN
520: ,p_token1_value => SQLCODE
521: ,p_token2 => G_SQLERRM_TOKEN

Line 525: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

521: ,p_token2 => G_SQLERRM_TOKEN
522: ,p_token2_value => SQLERRM);
523:
524: -- notify caller of an UNEXPECTED error
525: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
526:
527: END Validate_update_yn;
528:
529: PROCEDURE Validate_display_yn(

Line 536: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

532: ) IS
533:
534: BEGIN
535: -- initialize return status
536: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
537:
538: IF p_gtpv_rec.display_yn IS NOT NULL AND p_gtpv_rec.display_yn NOT IN ( 'Y', 'N' )
539: AND p_gtpv_rec.display_yn <> Okl_Api.G_MISS_CHAR THEN
540: Okl_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'DISPLAY_YN');

Line 539: AND p_gtpv_rec.display_yn <> Okl_Api.G_MISS_CHAR THEN

535: -- initialize return status
536: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
537:
538: IF p_gtpv_rec.display_yn IS NOT NULL AND p_gtpv_rec.display_yn NOT IN ( 'Y', 'N' )
539: AND p_gtpv_rec.display_yn <> Okl_Api.G_MISS_CHAR THEN
540: Okl_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'DISPLAY_YN');
541: x_return_status := Okl_Api.G_RET_STS_ERROR;
542: RAISE G_EXCEPTION_HALT_VALIDATION;
543: END IF;

Line 540: Okl_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'DISPLAY_YN');

536: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
537:
538: IF p_gtpv_rec.display_yn IS NOT NULL AND p_gtpv_rec.display_yn NOT IN ( 'Y', 'N' )
539: AND p_gtpv_rec.display_yn <> Okl_Api.G_MISS_CHAR THEN
540: Okl_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'DISPLAY_YN');
541: x_return_status := Okl_Api.G_RET_STS_ERROR;
542: RAISE G_EXCEPTION_HALT_VALIDATION;
543: END IF;
544:

Line 541: x_return_status := Okl_Api.G_RET_STS_ERROR;

537:
538: IF p_gtpv_rec.display_yn IS NOT NULL AND p_gtpv_rec.display_yn NOT IN ( 'Y', 'N' )
539: AND p_gtpv_rec.display_yn <> Okl_Api.G_MISS_CHAR THEN
540: Okl_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'DISPLAY_YN');
541: x_return_status := Okl_Api.G_RET_STS_ERROR;
542: RAISE G_EXCEPTION_HALT_VALIDATION;
543: END IF;
544:
545: EXCEPTION

Line 553: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME

549: NULL;
550:
551: WHEN OTHERS THEN
552: -- store SQL error message on message stack for caller
553: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME
554: ,p_msg_name => G_UNEXPECTED_ERROR
555: ,p_token1 => G_SQLCODE_TOKEN
556: ,p_token1_value => SQLCODE
557: ,p_token2 => G_SQLERRM_TOKEN

Line 561: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

557: ,p_token2 => G_SQLERRM_TOKEN
558: ,p_token2_value => SQLERRM);
559:
560: -- notify caller of an UNEXPECTED error
561: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
562:
563: END Validate_display_yn;
564:
565: ---------------------------------------------------------------------------

Line 582: x_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

578: FUNCTION Validate_Attributes (
579: p_gtpv_rec IN gtpv_rec_type
580: ) RETURN VARCHAR2 IS
581:
582: x_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
583: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
584: BEGIN
585: -- call each column-level validation
586:

Line 583: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

579: p_gtpv_rec IN gtpv_rec_type
580: ) RETURN VARCHAR2 IS
581:
582: x_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
583: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
584: BEGIN
585: -- call each column-level validation
586:
587:

Line 590: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN

586:
587:
588: -- Validate_Id
589: Validate_Id(p_gtpv_rec, x_return_status);
590: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
591: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
592: -- need to exit
593: l_return_status := x_return_status;
594: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 591: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

587:
588: -- Validate_Id
589: Validate_Id(p_gtpv_rec, x_return_status);
590: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
591: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
592: -- need to exit
593: l_return_status := x_return_status;
594: RAISE G_EXCEPTION_HALT_VALIDATION;
595: ELSE

Line 602: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN

598: END IF;
599: END IF;
600: -- Validate_Object_Version_Number
601: validate_object_version_number(p_gtpv_rec, x_return_status);
602: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
603: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
604: -- need to exit
605: l_return_status := x_return_status;
606: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 603: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

599: END IF;
600: -- Validate_Object_Version_Number
601: validate_object_version_number(p_gtpv_rec, x_return_status);
602: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
603: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
604: -- need to exit
605: l_return_status := x_return_status;
606: RAISE G_EXCEPTION_HALT_VALIDATION;
607: ELSE

Line 614: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN

610: END IF;
611: END IF;
612: -- validate_name
613: validate_name(p_gtpv_rec, x_return_status);
614: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
615: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
616: -- need to exit
617: l_return_status := x_return_status;
618: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 615: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

611: END IF;
612: -- validate_name
613: validate_name(p_gtpv_rec, x_return_status);
614: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
615: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
616: -- need to exit
617: l_return_status := x_return_status;
618: RAISE G_EXCEPTION_HALT_VALIDATION;
619: ELSE

Line 626: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN

622: END IF;
623: END IF;
624: -- Validate_display_yn
625: Validate_display_yn(p_gtpv_rec, x_return_status);
626: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
627: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
628: -- need to exit
629: l_return_status := x_return_status;
630: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 627: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

623: END IF;
624: -- Validate_display_yn
625: Validate_display_yn(p_gtpv_rec, x_return_status);
626: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
627: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
628: -- need to exit
629: l_return_status := x_return_status;
630: RAISE G_EXCEPTION_HALT_VALIDATION;
631: ELSE

Line 638: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN

634: END IF;
635: END IF;
636: -- Validate_update_yn
637: Validate_update_yn(p_gtpv_rec, x_return_status);
638: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
639: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
640: -- need to exit
641: l_return_status := x_return_status;
642: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 639: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

635: END IF;
636: -- Validate_update_yn
637: Validate_update_yn(p_gtpv_rec, x_return_status);
638: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
639: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
640: -- need to exit
641: l_return_status := x_return_status;
642: RAISE G_EXCEPTION_HALT_VALIDATION;
643: ELSE

Line 651: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN

647: END IF;
648:
649: -- validate_gtt_id
650: validate_gtt_id(p_gtpv_rec, x_return_status);
651: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
652: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
653: -- need to exit
654: l_return_status := x_return_status;
655: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 652: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

648:
649: -- validate_gtt_id
650: validate_gtt_id(p_gtpv_rec, x_return_status);
651: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
652: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
653: -- need to exit
654: l_return_status := x_return_status;
655: RAISE G_EXCEPTION_HALT_VALIDATION;
656: ELSE

Line 699: IF (l_gtpv_rec.id = Okl_Api.G_MISS_NUM) THEN

695: p_gtpv_rec IN gtpv_rec_type
696: ) RETURN gtpv_rec_type IS
697: l_gtpv_rec gtpv_rec_type := p_gtpv_rec;
698: BEGIN
699: IF (l_gtpv_rec.id = Okl_Api.G_MISS_NUM) THEN
700: l_gtpv_rec.id := NULL;
701: END IF;
702: IF (l_gtpv_rec.object_version_number = Okl_Api.G_MISS_NUM) THEN
703: l_gtpv_rec.object_version_number := NULL;

Line 702: IF (l_gtpv_rec.object_version_number = Okl_Api.G_MISS_NUM) THEN

698: BEGIN
699: IF (l_gtpv_rec.id = Okl_Api.G_MISS_NUM) THEN
700: l_gtpv_rec.id := NULL;
701: END IF;
702: IF (l_gtpv_rec.object_version_number = Okl_Api.G_MISS_NUM) THEN
703: l_gtpv_rec.object_version_number := NULL;
704: END IF;
705: IF (l_gtpv_rec.name = Okl_Api.G_MISS_CHAR) THEN
706: l_gtpv_rec.name := NULL;

Line 705: IF (l_gtpv_rec.name = Okl_Api.G_MISS_CHAR) THEN

701: END IF;
702: IF (l_gtpv_rec.object_version_number = Okl_Api.G_MISS_NUM) THEN
703: l_gtpv_rec.object_version_number := NULL;
704: END IF;
705: IF (l_gtpv_rec.name = Okl_Api.G_MISS_CHAR) THEN
706: l_gtpv_rec.name := NULL;
707: END IF;
708: IF (l_gtpv_rec.description = Okl_Api.G_MISS_CHAR) THEN
709: l_gtpv_rec.description := NULL;

Line 708: IF (l_gtpv_rec.description = Okl_Api.G_MISS_CHAR) THEN

704: END IF;
705: IF (l_gtpv_rec.name = Okl_Api.G_MISS_CHAR) THEN
706: l_gtpv_rec.name := NULL;
707: END IF;
708: IF (l_gtpv_rec.description = Okl_Api.G_MISS_CHAR) THEN
709: l_gtpv_rec.description := NULL;
710: END IF;
711: IF (l_gtpv_rec.display_yn = Okl_Api.G_MISS_CHAR) THEN
712: l_gtpv_rec.display_yn := NULL;

Line 711: IF (l_gtpv_rec.display_yn = Okl_Api.G_MISS_CHAR) THEN

707: END IF;
708: IF (l_gtpv_rec.description = Okl_Api.G_MISS_CHAR) THEN
709: l_gtpv_rec.description := NULL;
710: END IF;
711: IF (l_gtpv_rec.display_yn = Okl_Api.G_MISS_CHAR) THEN
712: l_gtpv_rec.display_yn := NULL;
713: END IF;
714: IF (l_gtpv_rec.update_yn = Okl_Api.G_MISS_CHAR) THEN
715: l_gtpv_rec.update_yn := NULL;

Line 714: IF (l_gtpv_rec.update_yn = Okl_Api.G_MISS_CHAR) THEN

710: END IF;
711: IF (l_gtpv_rec.display_yn = Okl_Api.G_MISS_CHAR) THEN
712: l_gtpv_rec.display_yn := NULL;
713: END IF;
714: IF (l_gtpv_rec.update_yn = Okl_Api.G_MISS_CHAR) THEN
715: l_gtpv_rec.update_yn := NULL;
716: END IF;
717: IF (l_gtpv_rec.prc_eng_ident = Okl_Api.G_MISS_CHAR) THEN
718: l_gtpv_rec.prc_eng_ident := NULL;

Line 717: IF (l_gtpv_rec.prc_eng_ident = Okl_Api.G_MISS_CHAR) THEN

713: END IF;
714: IF (l_gtpv_rec.update_yn = Okl_Api.G_MISS_CHAR) THEN
715: l_gtpv_rec.update_yn := NULL;
716: END IF;
717: IF (l_gtpv_rec.prc_eng_ident = Okl_Api.G_MISS_CHAR) THEN
718: l_gtpv_rec.prc_eng_ident := NULL;
719: END IF;
720: IF (l_gtpv_rec.default_value = Okl_Api.G_MISS_CHAR) THEN
721: l_gtpv_rec.default_value := NULL;

Line 720: IF (l_gtpv_rec.default_value = Okl_Api.G_MISS_CHAR) THEN

716: END IF;
717: IF (l_gtpv_rec.prc_eng_ident = Okl_Api.G_MISS_CHAR) THEN
718: l_gtpv_rec.prc_eng_ident := NULL;
719: END IF;
720: IF (l_gtpv_rec.default_value = Okl_Api.G_MISS_CHAR) THEN
721: l_gtpv_rec.default_value := NULL;
722: END IF;
723: IF (l_gtpv_rec.org_id = Okl_Api.G_MISS_NUM) THEN
724: l_gtpv_rec.org_id := NULL;

Line 723: IF (l_gtpv_rec.org_id = Okl_Api.G_MISS_NUM) THEN

719: END IF;
720: IF (l_gtpv_rec.default_value = Okl_Api.G_MISS_CHAR) THEN
721: l_gtpv_rec.default_value := NULL;
722: END IF;
723: IF (l_gtpv_rec.org_id = Okl_Api.G_MISS_NUM) THEN
724: l_gtpv_rec.org_id := NULL;
725: END IF;
726: IF (l_gtpv_rec.created_by = Okl_Api.G_MISS_NUM) THEN
727: l_gtpv_rec.created_by := NULL;

Line 726: IF (l_gtpv_rec.created_by = Okl_Api.G_MISS_NUM) THEN

722: END IF;
723: IF (l_gtpv_rec.org_id = Okl_Api.G_MISS_NUM) THEN
724: l_gtpv_rec.org_id := NULL;
725: END IF;
726: IF (l_gtpv_rec.created_by = Okl_Api.G_MISS_NUM) THEN
727: l_gtpv_rec.created_by := NULL;
728: END IF;
729: IF (l_gtpv_rec.creation_date = Okl_Api.G_MISS_DATE) THEN
730: l_gtpv_rec.creation_date := NULL;

Line 729: IF (l_gtpv_rec.creation_date = Okl_Api.G_MISS_DATE) THEN

725: END IF;
726: IF (l_gtpv_rec.created_by = Okl_Api.G_MISS_NUM) THEN
727: l_gtpv_rec.created_by := NULL;
728: END IF;
729: IF (l_gtpv_rec.creation_date = Okl_Api.G_MISS_DATE) THEN
730: l_gtpv_rec.creation_date := NULL;
731: END IF;
732: IF (l_gtpv_rec.last_updated_by = Okl_Api.G_MISS_NUM) THEN
733: l_gtpv_rec.last_updated_by := NULL;

Line 732: IF (l_gtpv_rec.last_updated_by = Okl_Api.G_MISS_NUM) THEN

728: END IF;
729: IF (l_gtpv_rec.creation_date = Okl_Api.G_MISS_DATE) THEN
730: l_gtpv_rec.creation_date := NULL;
731: END IF;
732: IF (l_gtpv_rec.last_updated_by = Okl_Api.G_MISS_NUM) THEN
733: l_gtpv_rec.last_updated_by := NULL;
734: END IF;
735: IF (l_gtpv_rec.last_update_date = Okl_Api.G_MISS_DATE) THEN
736: l_gtpv_rec.last_update_date := NULL;

Line 735: IF (l_gtpv_rec.last_update_date = Okl_Api.G_MISS_DATE) THEN

731: END IF;
732: IF (l_gtpv_rec.last_updated_by = Okl_Api.G_MISS_NUM) THEN
733: l_gtpv_rec.last_updated_by := NULL;
734: END IF;
735: IF (l_gtpv_rec.last_update_date = Okl_Api.G_MISS_DATE) THEN
736: l_gtpv_rec.last_update_date := NULL;
737: END IF;
738: IF (l_gtpv_rec.last_update_login = Okl_Api.G_MISS_NUM) THEN
739: l_gtpv_rec.last_update_login := NULL;

Line 738: IF (l_gtpv_rec.last_update_login = Okl_Api.G_MISS_NUM) THEN

734: END IF;
735: IF (l_gtpv_rec.last_update_date = Okl_Api.G_MISS_DATE) THEN
736: l_gtpv_rec.last_update_date := NULL;
737: END IF;
738: IF (l_gtpv_rec.last_update_login = Okl_Api.G_MISS_NUM) THEN
739: l_gtpv_rec.last_update_login := NULL;
740: END IF;
741: IF (l_gtpv_rec.gtt_id = Okl_Api.G_MISS_NUM) THEN
742: l_gtpv_rec.gtt_id := NULL;

Line 741: IF (l_gtpv_rec.gtt_id = Okl_Api.G_MISS_NUM) THEN

737: END IF;
738: IF (l_gtpv_rec.last_update_login = Okl_Api.G_MISS_NUM) THEN
739: l_gtpv_rec.last_update_login := NULL;
740: END IF;
741: IF (l_gtpv_rec.gtt_id = Okl_Api.G_MISS_NUM) THEN
742: l_gtpv_rec.gtt_id := NULL;
743: END IF;
744:
745: RETURN(l_gtpv_rec);

Line 816: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

812: ---------------------------------------------------------------------------
813:
814: PROCEDURE insert_row(
815: p_api_version IN NUMBER,
816: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
817: x_return_status OUT NOCOPY VARCHAR2,
818: x_msg_count OUT NOCOPY NUMBER,
819: x_msg_data OUT NOCOPY VARCHAR2,
820: p_gtp_rec IN gtp_rec_type,

Line 826: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

822:
823: -- Local Variables within the function
824: l_api_version CONSTANT NUMBER := 1;
825: l_api_name CONSTANT VARCHAR2(30) := 'insert_row';
826: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
827: l_gtp_rec gtp_rec_type := p_gtp_rec;
828: l_def_gtp_rec gtp_rec_type;
829: ---------------------------------------------
830: -- Set_Attributes for:OKL_ST_GEN_PRC_PARAMS --

Line 836: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

832: FUNCTION Set_Attributes (
833: p_gtp_rec IN gtp_rec_type,
834: x_gtp_rec OUT NOCOPY gtp_rec_type
835: ) RETURN VARCHAR2 IS
836: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
837: BEGIN
838: x_gtp_rec := p_gtp_rec;
839: RETURN(l_return_status);
840: END Set_Attributes;

Line 842: l_return_status := Okl_Api.START_ACTIVITY(l_api_name,

838: x_gtp_rec := p_gtp_rec;
839: RETURN(l_return_status);
840: END Set_Attributes;
841: BEGIN
842: l_return_status := Okl_Api.START_ACTIVITY(l_api_name,
843: p_init_msg_list,
844: '_PVT',
845: x_return_status);
846: --- If any errors happen abort API

Line 847: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

843: p_init_msg_list,
844: '_PVT',
845: x_return_status);
846: --- If any errors happen abort API
847: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
848: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
849: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
850: RAISE Okl_Api.G_EXCEPTION_ERROR;
851: END IF;

Line 848: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

844: '_PVT',
845: x_return_status);
846: --- If any errors happen abort API
847: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
848: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
849: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
850: RAISE Okl_Api.G_EXCEPTION_ERROR;
851: END IF;
852:

Line 849: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN

845: x_return_status);
846: --- If any errors happen abort API
847: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
848: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
849: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
850: RAISE Okl_Api.G_EXCEPTION_ERROR;
851: END IF;
852:
853: --- Setting item attributes

Line 850: RAISE Okl_Api.G_EXCEPTION_ERROR;

846: --- If any errors happen abort API
847: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
848: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
849: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
850: RAISE Okl_Api.G_EXCEPTION_ERROR;
851: END IF;
852:
853: --- Setting item attributes
854: l_return_status := Set_Attributes(

Line 859: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

855: p_gtp_rec, -- IN
856: l_gtp_rec -- OUT
857: );
858: --- If any errors happen abort API
859: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
860: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
861: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
862: RAISE Okl_Api.G_EXCEPTION_ERROR;
863: END IF;

Line 860: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

856: l_gtp_rec -- OUT
857: );
858: --- If any errors happen abort API
859: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
860: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
861: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
862: RAISE Okl_Api.G_EXCEPTION_ERROR;
863: END IF;
864:

Line 861: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN

857: );
858: --- If any errors happen abort API
859: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
860: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
861: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
862: RAISE Okl_Api.G_EXCEPTION_ERROR;
863: END IF;
864:
865: INSERT INTO OKL_ST_GEN_PRC_PARAMS(

Line 862: RAISE Okl_Api.G_EXCEPTION_ERROR;

858: --- If any errors happen abort API
859: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
860: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
861: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
862: RAISE Okl_Api.G_EXCEPTION_ERROR;
863: END IF;
864:
865: INSERT INTO OKL_ST_GEN_PRC_PARAMS(
866: ID

Line 902: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);

898: );
899:
900: -- Set OUT values
901: x_gtp_rec := l_gtp_rec;
902: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
903:
904: EXCEPTION
905: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
906: x_return_status := Okl_Api.HANDLE_EXCEPTIONS

Line 905: WHEN Okl_Api.G_EXCEPTION_ERROR THEN

901: x_gtp_rec := l_gtp_rec;
902: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
903:
904: EXCEPTION
905: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
906: x_return_status := Okl_Api.HANDLE_EXCEPTIONS
907: (
908: l_api_name,
909: G_PKG_NAME,

Line 906: x_return_status := Okl_Api.HANDLE_EXCEPTIONS

902: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
903:
904: EXCEPTION
905: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
906: x_return_status := Okl_Api.HANDLE_EXCEPTIONS
907: (
908: l_api_name,
909: G_PKG_NAME,
910: 'Okl_Api.G_RET_STS_ERROR',

Line 910: 'Okl_Api.G_RET_STS_ERROR',

906: x_return_status := Okl_Api.HANDLE_EXCEPTIONS
907: (
908: l_api_name,
909: G_PKG_NAME,
910: 'Okl_Api.G_RET_STS_ERROR',
911: x_msg_count,
912: x_msg_data,
913: '_PVT'
914: );

Line 915: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

911: x_msg_count,
912: x_msg_data,
913: '_PVT'
914: );
915: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
916: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS
917: (
918: l_api_name,
919: G_PKG_NAME,

Line 916: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS

912: x_msg_data,
913: '_PVT'
914: );
915: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
916: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS
917: (
918: l_api_name,
919: G_PKG_NAME,
920: 'Okl_Api.G_RET_STS_UNEXP_ERROR',

Line 920: 'Okl_Api.G_RET_STS_UNEXP_ERROR',

916: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS
917: (
918: l_api_name,
919: G_PKG_NAME,
920: 'Okl_Api.G_RET_STS_UNEXP_ERROR',
921: x_msg_count,
922: x_msg_data,
923: '_PVT'
924: );

Line 926: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS

922: x_msg_data,
923: '_PVT'
924: );
925: WHEN OTHERS THEN
926: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS
927: (
928: l_api_name,
929: G_PKG_NAME,
930: 'OTHERS',

Line 939: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

935: END insert_row;
936:
937: PROCEDURE insert_row(
938: p_api_version IN NUMBER,
939: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
940: x_return_status OUT NOCOPY VARCHAR2,
941: x_msg_count OUT NOCOPY NUMBER,
942: x_msg_data OUT NOCOPY VARCHAR2,
943: p_gtpv_rec IN gtpv_rec_type,

Line 949: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

945:
946: -- Local Variables within the function
947: l_api_version CONSTANT NUMBER := 1;
948: l_api_name CONSTANT VARCHAR2(30) := 'V_insert_row';
949: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
950: l_gtpv_rec gtpv_rec_type;
951: l_def_gtpv_rec gtpv_rec_type;
952: l_gtp_rec gtp_rec_type;
953: lx_gtp_rec gtp_rec_type;

Line 977: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

973: FUNCTION Set_Attributes (
974: p_gtpv_rec IN gtpv_rec_type,
975: x_gtpv_rec OUT NOCOPY gtpv_rec_type
976: ) RETURN VARCHAR2 IS
977: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
978: BEGIN
979: x_gtpv_rec := p_gtpv_rec;
980: x_gtpv_rec.OBJECT_VERSION_NUMBER := 1;
981: x_gtpv_rec.ORG_ID := MO_GLOBAL.GET_CURRENT_ORG_ID();

Line 988: l_return_status := Okl_Api.START_ACTIVITY(l_api_name,

984: END Set_Attributes;
985:
986: BEGIN
987:
988: l_return_status := Okl_Api.START_ACTIVITY(l_api_name,
989: G_PKG_NAME,
990: p_init_msg_list,
991: l_api_version,
992: p_api_version,

Line 995: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

991: l_api_version,
992: p_api_version,
993: '_PVT',
994: x_return_status);
995: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
996: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
997: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
998: RAISE Okl_Api.G_EXCEPTION_ERROR;
999: END IF;

Line 996: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

992: p_api_version,
993: '_PVT',
994: x_return_status);
995: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
996: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
997: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
998: RAISE Okl_Api.G_EXCEPTION_ERROR;
999: END IF;
1000:

Line 997: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN

993: '_PVT',
994: x_return_status);
995: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
996: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
997: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
998: RAISE Okl_Api.G_EXCEPTION_ERROR;
999: END IF;
1000:
1001: l_gtpv_rec := null_out_defaults(p_gtpv_rec);

Line 998: RAISE Okl_Api.G_EXCEPTION_ERROR;

994: x_return_status);
995: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
996: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
997: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
998: RAISE Okl_Api.G_EXCEPTION_ERROR;
999: END IF;
1000:
1001: l_gtpv_rec := null_out_defaults(p_gtpv_rec);
1002:

Line 1012: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

1008: l_gtpv_rec, -- IN
1009: l_def_gtpv_rec); -- OUT
1010:
1011: --- If any errors happen abort API
1012: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1013: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1014: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1015: RAISE Okl_Api.G_EXCEPTION_ERROR;
1016: END IF;

Line 1013: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1009: l_def_gtpv_rec); -- OUT
1010:
1011: --- If any errors happen abort API
1012: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1013: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1014: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1015: RAISE Okl_Api.G_EXCEPTION_ERROR;
1016: END IF;
1017:

Line 1014: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN

1010:
1011: --- If any errors happen abort API
1012: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1013: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1014: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1015: RAISE Okl_Api.G_EXCEPTION_ERROR;
1016: END IF;
1017:
1018: -- fill who columns for the l_def_gtpv_rec

Line 1015: RAISE Okl_Api.G_EXCEPTION_ERROR;

1011: --- If any errors happen abort API
1012: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1013: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1014: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1015: RAISE Okl_Api.G_EXCEPTION_ERROR;
1016: END IF;
1017:
1018: -- fill who columns for the l_def_gtpv_rec
1019: l_def_gtpv_rec := fill_who_columns(l_def_gtpv_rec);

Line 1024: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

1020:
1021: --- Validate all non-missing attributes (Item Level Validation)
1022: l_return_status := Validate_Attributes(l_def_gtpv_rec);
1023: --- If any errors happen abort API
1024: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1025: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1026: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1027: RAISE Okl_Api.G_EXCEPTION_ERROR;
1028: END IF;

Line 1025: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1021: --- Validate all non-missing attributes (Item Level Validation)
1022: l_return_status := Validate_Attributes(l_def_gtpv_rec);
1023: --- If any errors happen abort API
1024: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1025: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1026: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1027: RAISE Okl_Api.G_EXCEPTION_ERROR;
1028: END IF;
1029: -- Perfrom all row level validations

Line 1026: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN

1022: l_return_status := Validate_Attributes(l_def_gtpv_rec);
1023: --- If any errors happen abort API
1024: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1025: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1026: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1027: RAISE Okl_Api.G_EXCEPTION_ERROR;
1028: END IF;
1029: -- Perfrom all row level validations
1030: l_return_status := validate_record(l_def_gtpv_rec);

Line 1027: RAISE Okl_Api.G_EXCEPTION_ERROR;

1023: --- If any errors happen abort API
1024: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1025: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1026: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1027: RAISE Okl_Api.G_EXCEPTION_ERROR;
1028: END IF;
1029: -- Perfrom all row level validations
1030: l_return_status := validate_record(l_def_gtpv_rec);
1031: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

Line 1031: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

1027: RAISE Okl_Api.G_EXCEPTION_ERROR;
1028: END IF;
1029: -- Perfrom all row level validations
1030: l_return_status := validate_record(l_def_gtpv_rec);
1031: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1032: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1033: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1034: RAISE Okl_Api.G_EXCEPTION_ERROR;
1035: END IF;

Line 1032: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1028: END IF;
1029: -- Perfrom all row level validations
1030: l_return_status := validate_record(l_def_gtpv_rec);
1031: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1032: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1033: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1034: RAISE Okl_Api.G_EXCEPTION_ERROR;
1035: END IF;
1036:

Line 1033: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN

1029: -- Perfrom all row level validations
1030: l_return_status := validate_record(l_def_gtpv_rec);
1031: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1032: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1033: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1034: RAISE Okl_Api.G_EXCEPTION_ERROR;
1035: END IF;
1036:
1037: --------------------------------------

Line 1034: RAISE Okl_Api.G_EXCEPTION_ERROR;

1030: l_return_status := validate_record(l_def_gtpv_rec);
1031: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1032: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1033: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1034: RAISE Okl_Api.G_EXCEPTION_ERROR;
1035: END IF;
1036:
1037: --------------------------------------
1038: -- Move VIEW record to "Child" records

Line 1054: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

1050: ,x_msg_data => x_msg_data
1051: ,p_gtp_rec => l_gtp_rec
1052: ,x_gtp_rec => lx_gtp_rec
1053: );
1054: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1055: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1056: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1057: RAISE Okl_Api.G_EXCEPTION_ERROR;
1058: END IF;

Line 1055: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1051: ,p_gtp_rec => l_gtp_rec
1052: ,x_gtp_rec => lx_gtp_rec
1053: );
1054: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1055: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1056: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1057: RAISE Okl_Api.G_EXCEPTION_ERROR;
1058: END IF;
1059:

Line 1056: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN

1052: ,x_gtp_rec => lx_gtp_rec
1053: );
1054: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1055: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1056: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1057: RAISE Okl_Api.G_EXCEPTION_ERROR;
1058: END IF;
1059:
1060: migrate(lx_gtp_rec, l_def_gtpv_rec);

Line 1057: RAISE Okl_Api.G_EXCEPTION_ERROR;

1053: );
1054: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1055: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1056: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1057: RAISE Okl_Api.G_EXCEPTION_ERROR;
1058: END IF;
1059:
1060: migrate(lx_gtp_rec, l_def_gtpv_rec);
1061:

Line 1064: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);

1060: migrate(lx_gtp_rec, l_def_gtpv_rec);
1061:
1062: -- Set OUT values
1063: x_gtpv_rec := l_def_gtpv_rec;
1064: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1065:
1066: EXCEPTION
1067: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
1068: x_return_status := Okl_Api.HANDLE_EXCEPTIONS

Line 1067: WHEN Okl_Api.G_EXCEPTION_ERROR THEN

1063: x_gtpv_rec := l_def_gtpv_rec;
1064: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1065:
1066: EXCEPTION
1067: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
1068: x_return_status := Okl_Api.HANDLE_EXCEPTIONS
1069: (
1070: l_api_name,
1071: G_PKG_NAME,

Line 1068: x_return_status := Okl_Api.HANDLE_EXCEPTIONS

1064: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1065:
1066: EXCEPTION
1067: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
1068: x_return_status := Okl_Api.HANDLE_EXCEPTIONS
1069: (
1070: l_api_name,
1071: G_PKG_NAME,
1072: 'Okl_Api.G_RET_STS_ERROR',

Line 1072: 'Okl_Api.G_RET_STS_ERROR',

1068: x_return_status := Okl_Api.HANDLE_EXCEPTIONS
1069: (
1070: l_api_name,
1071: G_PKG_NAME,
1072: 'Okl_Api.G_RET_STS_ERROR',
1073: x_msg_count,
1074: x_msg_data,
1075: '_PVT'
1076: );

Line 1077: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

1073: x_msg_count,
1074: x_msg_data,
1075: '_PVT'
1076: );
1077: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1078: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS
1079: (
1080: l_api_name,
1081: G_PKG_NAME,

Line 1078: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS

1074: x_msg_data,
1075: '_PVT'
1076: );
1077: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1078: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS
1079: (
1080: l_api_name,
1081: G_PKG_NAME,
1082: 'Okl_Api.G_RET_STS_UNEXP_ERROR',

Line 1082: 'Okl_Api.G_RET_STS_UNEXP_ERROR',

1078: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS
1079: (
1080: l_api_name,
1081: G_PKG_NAME,
1082: 'Okl_Api.G_RET_STS_UNEXP_ERROR',
1083: x_msg_count,
1084: x_msg_data,
1085: '_PVT'
1086: );

Line 1088: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS

1084: x_msg_data,
1085: '_PVT'
1086: );
1087: WHEN OTHERS THEN
1088: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS
1089: (
1090: l_api_name,
1091: G_PKG_NAME,
1092: 'OTHERS',

Line 1104: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

1100: -- PL/SQL TBL insert_row for:GTLV_TBL --
1101: ----------------------------------------
1102: PROCEDURE insert_row(
1103: p_api_version IN NUMBER,
1104: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
1105: x_return_status OUT NOCOPY VARCHAR2,
1106: x_msg_count OUT NOCOPY NUMBER,
1107: x_msg_data OUT NOCOPY VARCHAR2,
1108: p_gtpv_tbl IN gtpv_tbl_type,

Line 1113: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

1109: x_gtpv_tbl OUT NOCOPY gtpv_tbl_type) IS
1110:
1111: l_api_version CONSTANT NUMBER := 1;
1112: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_insert_row';
1113: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1114: i NUMBER := 0;
1115: l_overall_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1116: BEGIN
1117: Okl_Api.init_msg_list(p_init_msg_list);

Line 1115: l_overall_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

1111: l_api_version CONSTANT NUMBER := 1;
1112: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_insert_row';
1113: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1114: i NUMBER := 0;
1115: l_overall_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1116: BEGIN
1117: Okl_Api.init_msg_list(p_init_msg_list);
1118:
1119: -- Making sure PL/SQL table has records in it before passing

Line 1117: Okl_Api.init_msg_list(p_init_msg_list);

1113: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1114: i NUMBER := 0;
1115: l_overall_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1116: BEGIN
1117: Okl_Api.init_msg_list(p_init_msg_list);
1118:
1119: -- Making sure PL/SQL table has records in it before passing
1120: IF (p_gtpv_tbl.COUNT > 0) THEN
1121: i := p_gtpv_tbl.FIRST;

Line 1126: p_init_msg_list => Okl_Api.G_FALSE,

1122: LOOP
1123:
1124: insert_row (
1125: p_api_version => l_api_version,
1126: p_init_msg_list => Okl_Api.G_FALSE,
1127: x_return_status => x_return_status,
1128: x_msg_count => x_msg_count,
1129: x_msg_data => x_msg_data,
1130: p_gtpv_rec => p_gtpv_tbl(i),

Line 1134: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN

1130: p_gtpv_rec => p_gtpv_tbl(i),
1131: x_gtpv_rec => x_gtpv_tbl(i));
1132:
1133: -- store the highest degree of error
1134: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
1135: IF l_overall_status <> Okl_Api.G_RET_STS_UNEXP_ERROR THEN
1136: l_overall_status := x_return_status;
1137: END IF;
1138: END IF;

Line 1135: IF l_overall_status <> Okl_Api.G_RET_STS_UNEXP_ERROR THEN

1131: x_gtpv_rec => x_gtpv_tbl(i));
1132:
1133: -- store the highest degree of error
1134: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
1135: IF l_overall_status <> Okl_Api.G_RET_STS_UNEXP_ERROR THEN
1136: l_overall_status := x_return_status;
1137: END IF;
1138: END IF;
1139: EXIT WHEN (i = p_gtpv_tbl.LAST);

Line 1147: WHEN Okl_Api.G_EXCEPTION_ERROR THEN

1143: -- return overall status
1144: x_return_status := l_overall_status;
1145: END IF;
1146: EXCEPTION
1147: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
1148: x_return_status := Okl_Api.HANDLE_EXCEPTIONS
1149: (
1150: l_api_name,
1151: G_PKG_NAME,

Line 1148: x_return_status := Okl_Api.HANDLE_EXCEPTIONS

1144: x_return_status := l_overall_status;
1145: END IF;
1146: EXCEPTION
1147: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
1148: x_return_status := Okl_Api.HANDLE_EXCEPTIONS
1149: (
1150: l_api_name,
1151: G_PKG_NAME,
1152: 'Okl_Api.G_RET_STS_ERROR',

Line 1152: 'Okl_Api.G_RET_STS_ERROR',

1148: x_return_status := Okl_Api.HANDLE_EXCEPTIONS
1149: (
1150: l_api_name,
1151: G_PKG_NAME,
1152: 'Okl_Api.G_RET_STS_ERROR',
1153: x_msg_count,
1154: x_msg_data,
1155: '_PVT'
1156: );

Line 1157: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

1153: x_msg_count,
1154: x_msg_data,
1155: '_PVT'
1156: );
1157: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1158: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS
1159: (
1160: l_api_name,
1161: G_PKG_NAME,

Line 1158: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS

1154: x_msg_data,
1155: '_PVT'
1156: );
1157: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1158: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS
1159: (
1160: l_api_name,
1161: G_PKG_NAME,
1162: 'Okl_Api.G_RET_STS_UNEXP_ERROR',

Line 1162: 'Okl_Api.G_RET_STS_UNEXP_ERROR',

1158: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS
1159: (
1160: l_api_name,
1161: G_PKG_NAME,
1162: 'Okl_Api.G_RET_STS_UNEXP_ERROR',
1163: x_msg_count,
1164: x_msg_data,
1165: '_PVT'
1166: );

Line 1168: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS

1164: x_msg_data,
1165: '_PVT'
1166: );
1167: WHEN OTHERS THEN
1168: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS
1169: (
1170: l_api_name,
1171: G_PKG_NAME,
1172: 'OTHERS',

Line 1194: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

1190: -- End of comments
1191: --------------------------------------------------------------------------
1192:
1193: PROCEDURE update_row(
1194: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
1195: x_return_status OUT NOCOPY VARCHAR2,
1196: x_msg_count OUT NOCOPY NUMBER,
1197: x_msg_data OUT NOCOPY VARCHAR2,
1198: p_gtp_rec IN gtp_rec_type,

Line 1203: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

1199: x_gtp_rec OUT NOCOPY gtp_rec_type) IS
1200:
1201: l_api_version CONSTANT NUMBER := 1;
1202: l_api_name CONSTANT VARCHAR2(30) := 'OPTS_update_row';
1203: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1204: l_gtp_rec gtp_rec_type := p_gtp_rec;
1205: l_def_gtp_rec gtp_rec_type;
1206: l_row_notfound BOOLEAN := TRUE;
1207: ----------------------------------

Line 1216: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

1212: x_gtp_rec OUT NOCOPY gtp_rec_type
1213: ) RETURN VARCHAR2 IS
1214: l_gtp_rec gtp_rec_type;
1215: l_row_notfound BOOLEAN := TRUE;
1216: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1217: BEGIN
1218: x_gtp_rec := p_gtp_rec;
1219:
1220: -- Get current database values

Line 1224: l_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

1220: -- Get current database values
1221: l_gtp_rec := get_rec( p_gtp_rec, l_row_notfound);
1222:
1223: IF (l_row_notfound) THEN
1224: l_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
1225: END IF;
1226: IF (x_gtp_rec.id = Okl_Api.G_MISS_NUM)
1227: THEN
1228: x_gtp_rec.id := l_gtp_rec.id;

Line 1226: IF (x_gtp_rec.id = Okl_Api.G_MISS_NUM)

1222:
1223: IF (l_row_notfound) THEN
1224: l_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
1225: END IF;
1226: IF (x_gtp_rec.id = Okl_Api.G_MISS_NUM)
1227: THEN
1228: x_gtp_rec.id := l_gtp_rec.id;
1229: END IF;
1230: IF (x_gtp_rec.object_version_number = Okl_Api.G_MISS_NUM)

Line 1230: IF (x_gtp_rec.object_version_number = Okl_Api.G_MISS_NUM)

1226: IF (x_gtp_rec.id = Okl_Api.G_MISS_NUM)
1227: THEN
1228: x_gtp_rec.id := l_gtp_rec.id;
1229: END IF;
1230: IF (x_gtp_rec.object_version_number = Okl_Api.G_MISS_NUM)
1231: THEN
1232: x_gtp_rec.object_version_number := l_gtp_rec.object_version_number;
1233: END IF;
1234: IF (x_gtp_rec.name = Okl_Api.G_MISS_CHAR) THEN

Line 1234: IF (x_gtp_rec.name = Okl_Api.G_MISS_CHAR) THEN

1230: IF (x_gtp_rec.object_version_number = Okl_Api.G_MISS_NUM)
1231: THEN
1232: x_gtp_rec.object_version_number := l_gtp_rec.object_version_number;
1233: END IF;
1234: IF (x_gtp_rec.name = Okl_Api.G_MISS_CHAR) THEN
1235: x_gtp_rec.name := l_gtp_rec.name;
1236: END IF;
1237: IF (x_gtp_rec.description = Okl_Api.G_MISS_CHAR) THEN
1238: x_gtp_rec.description := l_gtp_rec.description;

Line 1237: IF (x_gtp_rec.description = Okl_Api.G_MISS_CHAR) THEN

1233: END IF;
1234: IF (x_gtp_rec.name = Okl_Api.G_MISS_CHAR) THEN
1235: x_gtp_rec.name := l_gtp_rec.name;
1236: END IF;
1237: IF (x_gtp_rec.description = Okl_Api.G_MISS_CHAR) THEN
1238: x_gtp_rec.description := l_gtp_rec.description;
1239: END IF;
1240: IF (x_gtp_rec.display_yn = Okl_Api.G_MISS_CHAR) THEN
1241: x_gtp_rec.display_yn := l_gtp_rec.display_yn;

Line 1240: IF (x_gtp_rec.display_yn = Okl_Api.G_MISS_CHAR) THEN

1236: END IF;
1237: IF (x_gtp_rec.description = Okl_Api.G_MISS_CHAR) THEN
1238: x_gtp_rec.description := l_gtp_rec.description;
1239: END IF;
1240: IF (x_gtp_rec.display_yn = Okl_Api.G_MISS_CHAR) THEN
1241: x_gtp_rec.display_yn := l_gtp_rec.display_yn;
1242: END IF;
1243: IF (x_gtp_rec.update_yn = Okl_Api.G_MISS_CHAR) THEN
1244: x_gtp_rec.update_yn := l_gtp_rec.update_yn;

Line 1243: IF (x_gtp_rec.update_yn = Okl_Api.G_MISS_CHAR) THEN

1239: END IF;
1240: IF (x_gtp_rec.display_yn = Okl_Api.G_MISS_CHAR) THEN
1241: x_gtp_rec.display_yn := l_gtp_rec.display_yn;
1242: END IF;
1243: IF (x_gtp_rec.update_yn = Okl_Api.G_MISS_CHAR) THEN
1244: x_gtp_rec.update_yn := l_gtp_rec.update_yn;
1245: END IF;
1246: IF (x_gtp_rec.prc_eng_ident = Okl_Api.G_MISS_CHAR) THEN
1247: x_gtp_rec.prc_eng_ident := l_gtp_rec.prc_eng_ident;

Line 1246: IF (x_gtp_rec.prc_eng_ident = Okl_Api.G_MISS_CHAR) THEN

1242: END IF;
1243: IF (x_gtp_rec.update_yn = Okl_Api.G_MISS_CHAR) THEN
1244: x_gtp_rec.update_yn := l_gtp_rec.update_yn;
1245: END IF;
1246: IF (x_gtp_rec.prc_eng_ident = Okl_Api.G_MISS_CHAR) THEN
1247: x_gtp_rec.prc_eng_ident := l_gtp_rec.prc_eng_ident;
1248: END IF;
1249: IF (x_gtp_rec.default_value = Okl_Api.G_MISS_CHAR) THEN
1250: x_gtp_rec.default_value := l_gtp_rec.default_value;

Line 1249: IF (x_gtp_rec.default_value = Okl_Api.G_MISS_CHAR) THEN

1245: END IF;
1246: IF (x_gtp_rec.prc_eng_ident = Okl_Api.G_MISS_CHAR) THEN
1247: x_gtp_rec.prc_eng_ident := l_gtp_rec.prc_eng_ident;
1248: END IF;
1249: IF (x_gtp_rec.default_value = Okl_Api.G_MISS_CHAR) THEN
1250: x_gtp_rec.default_value := l_gtp_rec.default_value;
1251: END IF;
1252: IF (x_gtp_rec.org_id = Okl_Api.G_MISS_NUM)
1253: THEN

Line 1252: IF (x_gtp_rec.org_id = Okl_Api.G_MISS_NUM)

1248: END IF;
1249: IF (x_gtp_rec.default_value = Okl_Api.G_MISS_CHAR) THEN
1250: x_gtp_rec.default_value := l_gtp_rec.default_value;
1251: END IF;
1252: IF (x_gtp_rec.org_id = Okl_Api.G_MISS_NUM)
1253: THEN
1254: x_gtp_rec.org_id := l_gtp_rec.org_id;
1255: END IF;
1256: IF (x_gtp_rec.created_by = Okl_Api.G_MISS_NUM)

Line 1256: IF (x_gtp_rec.created_by = Okl_Api.G_MISS_NUM)

1252: IF (x_gtp_rec.org_id = Okl_Api.G_MISS_NUM)
1253: THEN
1254: x_gtp_rec.org_id := l_gtp_rec.org_id;
1255: END IF;
1256: IF (x_gtp_rec.created_by = Okl_Api.G_MISS_NUM)
1257: THEN
1258: x_gtp_rec.created_by := l_gtp_rec.created_by;
1259: END IF;
1260: IF (x_gtp_rec.creation_date = Okl_Api.G_MISS_DATE)

Line 1260: IF (x_gtp_rec.creation_date = Okl_Api.G_MISS_DATE)

1256: IF (x_gtp_rec.created_by = Okl_Api.G_MISS_NUM)
1257: THEN
1258: x_gtp_rec.created_by := l_gtp_rec.created_by;
1259: END IF;
1260: IF (x_gtp_rec.creation_date = Okl_Api.G_MISS_DATE)
1261: THEN
1262: x_gtp_rec.creation_date := l_gtp_rec.creation_date;
1263: END IF;
1264: IF (x_gtp_rec.last_updated_by = Okl_Api.G_MISS_NUM)

Line 1264: IF (x_gtp_rec.last_updated_by = Okl_Api.G_MISS_NUM)

1260: IF (x_gtp_rec.creation_date = Okl_Api.G_MISS_DATE)
1261: THEN
1262: x_gtp_rec.creation_date := l_gtp_rec.creation_date;
1263: END IF;
1264: IF (x_gtp_rec.last_updated_by = Okl_Api.G_MISS_NUM)
1265: THEN
1266: x_gtp_rec.last_updated_by := l_gtp_rec.last_updated_by;
1267: END IF;
1268: IF (x_gtp_rec.last_update_date = Okl_Api.G_MISS_DATE)

Line 1268: IF (x_gtp_rec.last_update_date = Okl_Api.G_MISS_DATE)

1264: IF (x_gtp_rec.last_updated_by = Okl_Api.G_MISS_NUM)
1265: THEN
1266: x_gtp_rec.last_updated_by := l_gtp_rec.last_updated_by;
1267: END IF;
1268: IF (x_gtp_rec.last_update_date = Okl_Api.G_MISS_DATE)
1269: THEN
1270: x_gtp_rec.last_update_date := l_gtp_rec.last_update_date;
1271: END IF;
1272: IF (x_gtp_rec.last_update_login = Okl_Api.G_MISS_NUM)

Line 1272: IF (x_gtp_rec.last_update_login = Okl_Api.G_MISS_NUM)

1268: IF (x_gtp_rec.last_update_date = Okl_Api.G_MISS_DATE)
1269: THEN
1270: x_gtp_rec.last_update_date := l_gtp_rec.last_update_date;
1271: END IF;
1272: IF (x_gtp_rec.last_update_login = Okl_Api.G_MISS_NUM)
1273: THEN
1274: x_gtp_rec.last_update_login := l_gtp_rec.last_update_login;
1275: END IF;
1276: IF (x_gtp_rec.gtt_id = Okl_Api.G_MISS_NUM)

Line 1276: IF (x_gtp_rec.gtt_id = Okl_Api.G_MISS_NUM)

1272: IF (x_gtp_rec.last_update_login = Okl_Api.G_MISS_NUM)
1273: THEN
1274: x_gtp_rec.last_update_login := l_gtp_rec.last_update_login;
1275: END IF;
1276: IF (x_gtp_rec.gtt_id = Okl_Api.G_MISS_NUM)
1277: THEN
1278: x_gtp_rec.gtt_id := l_gtp_rec.gtt_id;
1279: END IF;
1280: RETURN(l_return_status);

Line 1289: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

1285: FUNCTION Set_Attributes (
1286: p_gtp_rec IN gtp_rec_type,
1287: x_gtp_rec OUT NOCOPY gtp_rec_type
1288: ) RETURN VARCHAR2 IS
1289: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1290: BEGIN
1291: x_gtp_rec := p_gtp_rec;
1292: RETURN(l_return_status);
1293: END Set_Attributes;

Line 1295: l_return_status := Okl_Api.START_ACTIVITY(l_api_name,

1291: x_gtp_rec := p_gtp_rec;
1292: RETURN(l_return_status);
1293: END Set_Attributes;
1294: BEGIN
1295: l_return_status := Okl_Api.START_ACTIVITY(l_api_name,
1296: p_init_msg_list,
1297: '_PVT',
1298: x_return_status);
1299: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

Line 1299: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

1295: l_return_status := Okl_Api.START_ACTIVITY(l_api_name,
1296: p_init_msg_list,
1297: '_PVT',
1298: x_return_status);
1299: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1300: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1301: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1302: RAISE Okl_Api.G_EXCEPTION_ERROR;
1303: END IF;

Line 1300: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1296: p_init_msg_list,
1297: '_PVT',
1298: x_return_status);
1299: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1300: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1301: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1302: RAISE Okl_Api.G_EXCEPTION_ERROR;
1303: END IF;
1304:

Line 1301: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN

1297: '_PVT',
1298: x_return_status);
1299: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1300: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1301: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1302: RAISE Okl_Api.G_EXCEPTION_ERROR;
1303: END IF;
1304:
1305: --- Setting item attributes

Line 1302: RAISE Okl_Api.G_EXCEPTION_ERROR;

1298: x_return_status);
1299: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1300: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1301: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1302: RAISE Okl_Api.G_EXCEPTION_ERROR;
1303: END IF;
1304:
1305: --- Setting item attributes
1306: l_return_status := Set_Attributes(

Line 1310: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

1306: l_return_status := Set_Attributes(
1307: p_gtp_rec, -- IN
1308: l_gtp_rec); -- OUT
1309: --- If any errors happen abort API
1310: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1311: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1312: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1313: RAISE Okl_Api.G_EXCEPTION_ERROR;
1314: END IF;

Line 1311: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1307: p_gtp_rec, -- IN
1308: l_gtp_rec); -- OUT
1309: --- If any errors happen abort API
1310: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1311: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1312: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1313: RAISE Okl_Api.G_EXCEPTION_ERROR;
1314: END IF;
1315:

Line 1312: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN

1308: l_gtp_rec); -- OUT
1309: --- If any errors happen abort API
1310: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1311: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1312: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1313: RAISE Okl_Api.G_EXCEPTION_ERROR;
1314: END IF;
1315:
1316: l_return_status := populate_new_record(l_gtp_rec, l_def_gtp_rec);

Line 1313: RAISE Okl_Api.G_EXCEPTION_ERROR;

1309: --- If any errors happen abort API
1310: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1311: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1312: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1313: RAISE Okl_Api.G_EXCEPTION_ERROR;
1314: END IF;
1315:
1316: l_return_status := populate_new_record(l_gtp_rec, l_def_gtp_rec);
1317: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

Line 1317: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

1313: RAISE Okl_Api.G_EXCEPTION_ERROR;
1314: END IF;
1315:
1316: l_return_status := populate_new_record(l_gtp_rec, l_def_gtp_rec);
1317: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1318: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1319: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1320: RAISE Okl_Api.G_EXCEPTION_ERROR;
1321: END IF;

Line 1318: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1314: END IF;
1315:
1316: l_return_status := populate_new_record(l_gtp_rec, l_def_gtp_rec);
1317: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1318: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1319: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1320: RAISE Okl_Api.G_EXCEPTION_ERROR;
1321: END IF;
1322:

Line 1319: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN

1315:
1316: l_return_status := populate_new_record(l_gtp_rec, l_def_gtp_rec);
1317: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1318: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1319: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1320: RAISE Okl_Api.G_EXCEPTION_ERROR;
1321: END IF;
1322:
1323: UPDATE OKL_ST_GEN_PRC_PARAMS

Line 1320: RAISE Okl_Api.G_EXCEPTION_ERROR;

1316: l_return_status := populate_new_record(l_gtp_rec, l_def_gtp_rec);
1317: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1318: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1319: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1320: RAISE Okl_Api.G_EXCEPTION_ERROR;
1321: END IF;
1322:
1323: UPDATE OKL_ST_GEN_PRC_PARAMS
1324: SET ID = l_def_gtp_rec.id

Line 1342: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);

1338: ,GTT_ID = l_def_gtp_rec.gtt_id
1339: WHERE ID = l_def_gtp_rec.id;
1340:
1341: x_gtp_rec := l_def_gtp_rec;
1342: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1343: EXCEPTION
1344: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
1345: x_return_status := Okl_Api.HANDLE_EXCEPTIONS
1346: (

Line 1344: WHEN Okl_Api.G_EXCEPTION_ERROR THEN

1340:
1341: x_gtp_rec := l_def_gtp_rec;
1342: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1343: EXCEPTION
1344: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
1345: x_return_status := Okl_Api.HANDLE_EXCEPTIONS
1346: (
1347: l_api_name,
1348: G_PKG_NAME,

Line 1345: x_return_status := Okl_Api.HANDLE_EXCEPTIONS

1341: x_gtp_rec := l_def_gtp_rec;
1342: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1343: EXCEPTION
1344: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
1345: x_return_status := Okl_Api.HANDLE_EXCEPTIONS
1346: (
1347: l_api_name,
1348: G_PKG_NAME,
1349: 'Okl_Api.G_RET_STS_ERROR',

Line 1349: 'Okl_Api.G_RET_STS_ERROR',

1345: x_return_status := Okl_Api.HANDLE_EXCEPTIONS
1346: (
1347: l_api_name,
1348: G_PKG_NAME,
1349: 'Okl_Api.G_RET_STS_ERROR',
1350: x_msg_count,
1351: x_msg_data,
1352: '_PVT'
1353: );

Line 1354: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

1350: x_msg_count,
1351: x_msg_data,
1352: '_PVT'
1353: );
1354: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1355: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS
1356: (
1357: l_api_name,
1358: G_PKG_NAME,

Line 1355: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS

1351: x_msg_data,
1352: '_PVT'
1353: );
1354: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1355: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS
1356: (
1357: l_api_name,
1358: G_PKG_NAME,
1359: 'Okl_Api.G_RET_STS_UNEXP_ERROR',

Line 1359: 'Okl_Api.G_RET_STS_UNEXP_ERROR',

1355: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS
1356: (
1357: l_api_name,
1358: G_PKG_NAME,
1359: 'Okl_Api.G_RET_STS_UNEXP_ERROR',
1360: x_msg_count,
1361: x_msg_data,
1362: '_PVT'
1363: );

Line 1365: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS

1361: x_msg_data,
1362: '_PVT'
1363: );
1364: WHEN OTHERS THEN
1365: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS
1366: (
1367: l_api_name,
1368: G_PKG_NAME,
1369: 'OTHERS',

Line 1379: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

1375:
1376:
1377: PROCEDURE update_row(
1378: p_api_version IN NUMBER,
1379: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
1380: x_return_status OUT NOCOPY VARCHAR2,
1381: x_msg_count OUT NOCOPY NUMBER,
1382: x_msg_data OUT NOCOPY VARCHAR2,
1383: p_gtpv_rec IN gtpv_rec_type,

Line 1388: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

1384: x_gtpv_rec OUT NOCOPY gtpv_rec_type) IS
1385:
1386: l_api_version CONSTANT NUMBER := 1;
1387: l_api_name CONSTANT VARCHAR2(30) := 'V_update_row';
1388: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1389: l_gtpv_rec gtpv_rec_type := p_gtpv_rec;
1390: l_def_gtpv_rec gtpv_rec_type;
1391: l_gtp_rec gtp_rec_type;
1392: lx_gtp_rec gtp_rec_type;

Line 1415: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

1411: x_gtpv_rec OUT NOCOPY gtpv_rec_type
1412: ) RETURN VARCHAR2 IS
1413: l_gtpv_rec gtpv_rec_type;
1414: l_row_notfound BOOLEAN := TRUE;
1415: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1416: BEGIN
1417: x_gtpv_rec := p_gtpv_rec;
1418: -- Get current database values
1419: l_gtpv_rec := get_rec(p_gtpv_rec, l_row_notfound);

Line 1422: l_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

1418: -- Get current database values
1419: l_gtpv_rec := get_rec(p_gtpv_rec, l_row_notfound);
1420:
1421: IF (l_row_notfound) THEN
1422: l_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
1423: END IF;
1424:
1425: IF (x_gtpv_rec.id = Okl_Api.G_MISS_NUM)
1426: THEN

Line 1425: IF (x_gtpv_rec.id = Okl_Api.G_MISS_NUM)

1421: IF (l_row_notfound) THEN
1422: l_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
1423: END IF;
1424:
1425: IF (x_gtpv_rec.id = Okl_Api.G_MISS_NUM)
1426: THEN
1427: x_gtpv_rec.id := l_gtp_rec.id;
1428: END IF;
1429: IF (x_gtpv_rec.object_version_number = Okl_Api.G_MISS_NUM)

Line 1429: IF (x_gtpv_rec.object_version_number = Okl_Api.G_MISS_NUM)

1425: IF (x_gtpv_rec.id = Okl_Api.G_MISS_NUM)
1426: THEN
1427: x_gtpv_rec.id := l_gtp_rec.id;
1428: END IF;
1429: IF (x_gtpv_rec.object_version_number = Okl_Api.G_MISS_NUM)
1430: THEN
1431: x_gtpv_rec.object_version_number := l_gtpv_rec.object_version_number;
1432: END IF;
1433: IF (x_gtpv_rec.name = Okl_Api.G_MISS_CHAR) THEN

Line 1433: IF (x_gtpv_rec.name = Okl_Api.G_MISS_CHAR) THEN

1429: IF (x_gtpv_rec.object_version_number = Okl_Api.G_MISS_NUM)
1430: THEN
1431: x_gtpv_rec.object_version_number := l_gtpv_rec.object_version_number;
1432: END IF;
1433: IF (x_gtpv_rec.name = Okl_Api.G_MISS_CHAR) THEN
1434: x_gtpv_rec.name := l_gtpv_rec.name;
1435: END IF;
1436: IF (x_gtpv_rec.description = Okl_Api.G_MISS_CHAR) THEN
1437: x_gtpv_rec.description := l_gtpv_rec.description;

Line 1436: IF (x_gtpv_rec.description = Okl_Api.G_MISS_CHAR) THEN

1432: END IF;
1433: IF (x_gtpv_rec.name = Okl_Api.G_MISS_CHAR) THEN
1434: x_gtpv_rec.name := l_gtpv_rec.name;
1435: END IF;
1436: IF (x_gtpv_rec.description = Okl_Api.G_MISS_CHAR) THEN
1437: x_gtpv_rec.description := l_gtpv_rec.description;
1438: END IF;
1439: IF (x_gtpv_rec.display_yn = Okl_Api.G_MISS_CHAR) THEN
1440: x_gtpv_rec.display_yn := l_gtpv_rec.display_yn;

Line 1439: IF (x_gtpv_rec.display_yn = Okl_Api.G_MISS_CHAR) THEN

1435: END IF;
1436: IF (x_gtpv_rec.description = Okl_Api.G_MISS_CHAR) THEN
1437: x_gtpv_rec.description := l_gtpv_rec.description;
1438: END IF;
1439: IF (x_gtpv_rec.display_yn = Okl_Api.G_MISS_CHAR) THEN
1440: x_gtpv_rec.display_yn := l_gtpv_rec.display_yn;
1441: END IF;
1442: IF (x_gtpv_rec.update_yn = Okl_Api.G_MISS_CHAR) THEN
1443: x_gtpv_rec.update_yn := l_gtpv_rec.update_yn;

Line 1442: IF (x_gtpv_rec.update_yn = Okl_Api.G_MISS_CHAR) THEN

1438: END IF;
1439: IF (x_gtpv_rec.display_yn = Okl_Api.G_MISS_CHAR) THEN
1440: x_gtpv_rec.display_yn := l_gtpv_rec.display_yn;
1441: END IF;
1442: IF (x_gtpv_rec.update_yn = Okl_Api.G_MISS_CHAR) THEN
1443: x_gtpv_rec.update_yn := l_gtpv_rec.update_yn;
1444: END IF;
1445: IF (x_gtpv_rec.prc_eng_ident = Okl_Api.G_MISS_CHAR) THEN
1446: x_gtpv_rec.prc_eng_ident := l_gtpv_rec.prc_eng_ident;

Line 1445: IF (x_gtpv_rec.prc_eng_ident = Okl_Api.G_MISS_CHAR) THEN

1441: END IF;
1442: IF (x_gtpv_rec.update_yn = Okl_Api.G_MISS_CHAR) THEN
1443: x_gtpv_rec.update_yn := l_gtpv_rec.update_yn;
1444: END IF;
1445: IF (x_gtpv_rec.prc_eng_ident = Okl_Api.G_MISS_CHAR) THEN
1446: x_gtpv_rec.prc_eng_ident := l_gtpv_rec.prc_eng_ident;
1447: END IF;
1448: IF (x_gtpv_rec.default_value = Okl_Api.G_MISS_CHAR) THEN
1449: x_gtpv_rec.default_value := l_gtpv_rec.default_value;

Line 1448: IF (x_gtpv_rec.default_value = Okl_Api.G_MISS_CHAR) THEN

1444: END IF;
1445: IF (x_gtpv_rec.prc_eng_ident = Okl_Api.G_MISS_CHAR) THEN
1446: x_gtpv_rec.prc_eng_ident := l_gtpv_rec.prc_eng_ident;
1447: END IF;
1448: IF (x_gtpv_rec.default_value = Okl_Api.G_MISS_CHAR) THEN
1449: x_gtpv_rec.default_value := l_gtpv_rec.default_value;
1450: END IF;
1451:
1452: IF (x_gtpv_rec.org_id = Okl_Api.G_MISS_NUM)

Line 1452: IF (x_gtpv_rec.org_id = Okl_Api.G_MISS_NUM)

1448: IF (x_gtpv_rec.default_value = Okl_Api.G_MISS_CHAR) THEN
1449: x_gtpv_rec.default_value := l_gtpv_rec.default_value;
1450: END IF;
1451:
1452: IF (x_gtpv_rec.org_id = Okl_Api.G_MISS_NUM)
1453: THEN
1454: x_gtpv_rec.org_id := l_gtpv_rec.org_id;
1455: END IF;
1456: IF (x_gtpv_rec.created_by = Okl_Api.G_MISS_NUM)

Line 1456: IF (x_gtpv_rec.created_by = Okl_Api.G_MISS_NUM)

1452: IF (x_gtpv_rec.org_id = Okl_Api.G_MISS_NUM)
1453: THEN
1454: x_gtpv_rec.org_id := l_gtpv_rec.org_id;
1455: END IF;
1456: IF (x_gtpv_rec.created_by = Okl_Api.G_MISS_NUM)
1457: THEN
1458: x_gtpv_rec.created_by := l_gtpv_rec.created_by;
1459: END IF;
1460: IF (x_gtpv_rec.creation_date = Okl_Api.G_MISS_DATE)

Line 1460: IF (x_gtpv_rec.creation_date = Okl_Api.G_MISS_DATE)

1456: IF (x_gtpv_rec.created_by = Okl_Api.G_MISS_NUM)
1457: THEN
1458: x_gtpv_rec.created_by := l_gtpv_rec.created_by;
1459: END IF;
1460: IF (x_gtpv_rec.creation_date = Okl_Api.G_MISS_DATE)
1461: THEN
1462: x_gtpv_rec.creation_date := l_gtpv_rec.creation_date;
1463: END IF;
1464: IF (x_gtpv_rec.last_updated_by = Okl_Api.G_MISS_NUM)

Line 1464: IF (x_gtpv_rec.last_updated_by = Okl_Api.G_MISS_NUM)

1460: IF (x_gtpv_rec.creation_date = Okl_Api.G_MISS_DATE)
1461: THEN
1462: x_gtpv_rec.creation_date := l_gtpv_rec.creation_date;
1463: END IF;
1464: IF (x_gtpv_rec.last_updated_by = Okl_Api.G_MISS_NUM)
1465: THEN
1466: x_gtpv_rec.last_updated_by := l_gtpv_rec.last_updated_by;
1467: END IF;
1468: IF (x_gtpv_rec.last_update_date = Okl_Api.G_MISS_DATE)

Line 1468: IF (x_gtpv_rec.last_update_date = Okl_Api.G_MISS_DATE)

1464: IF (x_gtpv_rec.last_updated_by = Okl_Api.G_MISS_NUM)
1465: THEN
1466: x_gtpv_rec.last_updated_by := l_gtpv_rec.last_updated_by;
1467: END IF;
1468: IF (x_gtpv_rec.last_update_date = Okl_Api.G_MISS_DATE)
1469: THEN
1470: x_gtpv_rec.last_update_date := l_gtpv_rec.last_update_date;
1471: END IF;
1472: IF (x_gtpv_rec.last_update_login = Okl_Api.G_MISS_NUM)

Line 1472: IF (x_gtpv_rec.last_update_login = Okl_Api.G_MISS_NUM)

1468: IF (x_gtpv_rec.last_update_date = Okl_Api.G_MISS_DATE)
1469: THEN
1470: x_gtpv_rec.last_update_date := l_gtpv_rec.last_update_date;
1471: END IF;
1472: IF (x_gtpv_rec.last_update_login = Okl_Api.G_MISS_NUM)
1473: THEN
1474: x_gtpv_rec.last_update_login := l_gtpv_rec.last_update_login;
1475: END IF;
1476: IF (x_gtpv_rec.gtt_id = Okl_Api.G_MISS_NUM)

Line 1476: IF (x_gtpv_rec.gtt_id = Okl_Api.G_MISS_NUM)

1472: IF (x_gtpv_rec.last_update_login = Okl_Api.G_MISS_NUM)
1473: THEN
1474: x_gtpv_rec.last_update_login := l_gtpv_rec.last_update_login;
1475: END IF;
1476: IF (x_gtpv_rec.gtt_id = Okl_Api.G_MISS_NUM)
1477: THEN
1478: x_gtpv_rec.gtt_id := l_gtpv_rec.gtt_id;
1479: END IF;
1480: RETURN(l_return_status);

Line 1489: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

1485: FUNCTION Set_Attributes (
1486: p_gtpv_rec IN gtpv_rec_type,
1487: x_gtpv_rec OUT NOCOPY gtpv_rec_type
1488: ) RETURN VARCHAR2 IS
1489: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1490: BEGIN
1491: x_gtpv_rec := p_gtpv_rec;
1492: RETURN(l_return_status);
1493: END Set_Attributes;

Line 1495: l_return_status := Okl_Api.START_ACTIVITY(l_api_name,

1491: x_gtpv_rec := p_gtpv_rec;
1492: RETURN(l_return_status);
1493: END Set_Attributes;
1494: BEGIN
1495: l_return_status := Okl_Api.START_ACTIVITY(l_api_name,
1496: G_PKG_NAME,
1497: p_init_msg_list,
1498: l_api_version,
1499: p_api_version,

Line 1502: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

1498: l_api_version,
1499: p_api_version,
1500: '_PVT',
1501: x_return_status);
1502: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1503: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1504: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1505: RAISE Okl_Api.G_EXCEPTION_ERROR;
1506: END IF;

Line 1503: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1499: p_api_version,
1500: '_PVT',
1501: x_return_status);
1502: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1503: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1504: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1505: RAISE Okl_Api.G_EXCEPTION_ERROR;
1506: END IF;
1507: --- Setting item attributes

Line 1504: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN

1500: '_PVT',
1501: x_return_status);
1502: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1503: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1504: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1505: RAISE Okl_Api.G_EXCEPTION_ERROR;
1506: END IF;
1507: --- Setting item attributes
1508: l_return_status := Set_Attributes(

Line 1505: RAISE Okl_Api.G_EXCEPTION_ERROR;

1501: x_return_status);
1502: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1503: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1504: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1505: RAISE Okl_Api.G_EXCEPTION_ERROR;
1506: END IF;
1507: --- Setting item attributes
1508: l_return_status := Set_Attributes(
1509: p_gtpv_rec, -- IN

Line 1512: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

1508: l_return_status := Set_Attributes(
1509: p_gtpv_rec, -- IN
1510: l_gtpv_rec); -- OUT
1511: --- If any errors happen abort API
1512: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1513: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1514: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1515: RAISE Okl_Api.G_EXCEPTION_ERROR;
1516: END IF;

Line 1513: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1509: p_gtpv_rec, -- IN
1510: l_gtpv_rec); -- OUT
1511: --- If any errors happen abort API
1512: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1513: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1514: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1515: RAISE Okl_Api.G_EXCEPTION_ERROR;
1516: END IF;
1517: l_return_status := populate_new_record(l_gtpv_rec, l_def_gtpv_rec);

Line 1514: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN

1510: l_gtpv_rec); -- OUT
1511: --- If any errors happen abort API
1512: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1513: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1514: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1515: RAISE Okl_Api.G_EXCEPTION_ERROR;
1516: END IF;
1517: l_return_status := populate_new_record(l_gtpv_rec, l_def_gtpv_rec);
1518: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

Line 1515: RAISE Okl_Api.G_EXCEPTION_ERROR;

1511: --- If any errors happen abort API
1512: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1513: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1514: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1515: RAISE Okl_Api.G_EXCEPTION_ERROR;
1516: END IF;
1517: l_return_status := populate_new_record(l_gtpv_rec, l_def_gtpv_rec);
1518: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1519: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

Line 1518: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

1514: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1515: RAISE Okl_Api.G_EXCEPTION_ERROR;
1516: END IF;
1517: l_return_status := populate_new_record(l_gtpv_rec, l_def_gtpv_rec);
1518: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1519: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1520: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1521: RAISE Okl_Api.G_EXCEPTION_ERROR;
1522: END IF;

Line 1519: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1515: RAISE Okl_Api.G_EXCEPTION_ERROR;
1516: END IF;
1517: l_return_status := populate_new_record(l_gtpv_rec, l_def_gtpv_rec);
1518: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1519: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1520: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1521: RAISE Okl_Api.G_EXCEPTION_ERROR;
1522: END IF;
1523: l_def_gtpv_rec := fill_who_columns(l_def_gtpv_rec);

Line 1520: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN

1516: END IF;
1517: l_return_status := populate_new_record(l_gtpv_rec, l_def_gtpv_rec);
1518: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1519: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1520: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1521: RAISE Okl_Api.G_EXCEPTION_ERROR;
1522: END IF;
1523: l_def_gtpv_rec := fill_who_columns(l_def_gtpv_rec);
1524: --- Validate all non-missing attributes (Item Level Validation)

Line 1521: RAISE Okl_Api.G_EXCEPTION_ERROR;

1517: l_return_status := populate_new_record(l_gtpv_rec, l_def_gtpv_rec);
1518: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1519: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1520: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1521: RAISE Okl_Api.G_EXCEPTION_ERROR;
1522: END IF;
1523: l_def_gtpv_rec := fill_who_columns(l_def_gtpv_rec);
1524: --- Validate all non-missing attributes (Item Level Validation)
1525: l_return_status := Validate_Attributes(l_def_gtpv_rec);

Line 1527: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

1523: l_def_gtpv_rec := fill_who_columns(l_def_gtpv_rec);
1524: --- Validate all non-missing attributes (Item Level Validation)
1525: l_return_status := Validate_Attributes(l_def_gtpv_rec);
1526: --- If any errors happen abort API
1527: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1528: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1529: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1530: RAISE Okl_Api.G_EXCEPTION_ERROR;
1531: END IF;

Line 1528: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1524: --- Validate all non-missing attributes (Item Level Validation)
1525: l_return_status := Validate_Attributes(l_def_gtpv_rec);
1526: --- If any errors happen abort API
1527: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1528: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1529: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1530: RAISE Okl_Api.G_EXCEPTION_ERROR;
1531: END IF;
1532:

Line 1529: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN

1525: l_return_status := Validate_Attributes(l_def_gtpv_rec);
1526: --- If any errors happen abort API
1527: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1528: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1529: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1530: RAISE Okl_Api.G_EXCEPTION_ERROR;
1531: END IF;
1532:
1533: l_return_status := Validate_Record(l_def_gtpv_rec);

Line 1530: RAISE Okl_Api.G_EXCEPTION_ERROR;

1526: --- If any errors happen abort API
1527: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1528: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1529: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1530: RAISE Okl_Api.G_EXCEPTION_ERROR;
1531: END IF;
1532:
1533: l_return_status := Validate_Record(l_def_gtpv_rec);
1534: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

Line 1534: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

1530: RAISE Okl_Api.G_EXCEPTION_ERROR;
1531: END IF;
1532:
1533: l_return_status := Validate_Record(l_def_gtpv_rec);
1534: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1535: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1536: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1537: RAISE Okl_Api.G_EXCEPTION_ERROR;
1538: END IF;

Line 1535: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1531: END IF;
1532:
1533: l_return_status := Validate_Record(l_def_gtpv_rec);
1534: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1535: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1536: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1537: RAISE Okl_Api.G_EXCEPTION_ERROR;
1538: END IF;
1539:

Line 1536: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN

1532:
1533: l_return_status := Validate_Record(l_def_gtpv_rec);
1534: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1535: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1536: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1537: RAISE Okl_Api.G_EXCEPTION_ERROR;
1538: END IF;
1539:
1540: --------------------------------------

Line 1537: RAISE Okl_Api.G_EXCEPTION_ERROR;

1533: l_return_status := Validate_Record(l_def_gtpv_rec);
1534: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1535: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1536: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1537: RAISE Okl_Api.G_EXCEPTION_ERROR;
1538: END IF;
1539:
1540: --------------------------------------
1541: -- Move VIEW record to "Child" records

Line 1555: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

1551: x_msg_data => x_msg_data,
1552: p_gtp_rec => l_gtp_rec,
1553: x_gtp_rec => lx_gtp_rec
1554: );
1555: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1556: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1557: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1558: RAISE Okl_Api.G_EXCEPTION_ERROR;
1559: END IF;

Line 1556: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1552: p_gtp_rec => l_gtp_rec,
1553: x_gtp_rec => lx_gtp_rec
1554: );
1555: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1556: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1557: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1558: RAISE Okl_Api.G_EXCEPTION_ERROR;
1559: END IF;
1560:

Line 1557: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN

1553: x_gtp_rec => lx_gtp_rec
1554: );
1555: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1556: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1557: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1558: RAISE Okl_Api.G_EXCEPTION_ERROR;
1559: END IF;
1560:
1561: migrate(lx_gtp_rec, l_def_gtpv_rec);

Line 1558: RAISE Okl_Api.G_EXCEPTION_ERROR;

1554: );
1555: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1556: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1557: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1558: RAISE Okl_Api.G_EXCEPTION_ERROR;
1559: END IF;
1560:
1561: migrate(lx_gtp_rec, l_def_gtpv_rec);
1562:

Line 1564: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);

1560:
1561: migrate(lx_gtp_rec, l_def_gtpv_rec);
1562:
1563: x_gtpv_rec := l_def_gtpv_rec;
1564: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1565: EXCEPTION
1566: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
1567: x_return_status := Okl_Api.HANDLE_EXCEPTIONS
1568: (

Line 1566: WHEN Okl_Api.G_EXCEPTION_ERROR THEN

1562:
1563: x_gtpv_rec := l_def_gtpv_rec;
1564: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1565: EXCEPTION
1566: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
1567: x_return_status := Okl_Api.HANDLE_EXCEPTIONS
1568: (
1569: l_api_name,
1570: G_PKG_NAME,

Line 1567: x_return_status := Okl_Api.HANDLE_EXCEPTIONS

1563: x_gtpv_rec := l_def_gtpv_rec;
1564: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1565: EXCEPTION
1566: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
1567: x_return_status := Okl_Api.HANDLE_EXCEPTIONS
1568: (
1569: l_api_name,
1570: G_PKG_NAME,
1571: 'Okl_Api.G_RET_STS_ERROR',

Line 1571: 'Okl_Api.G_RET_STS_ERROR',

1567: x_return_status := Okl_Api.HANDLE_EXCEPTIONS
1568: (
1569: l_api_name,
1570: G_PKG_NAME,
1571: 'Okl_Api.G_RET_STS_ERROR',
1572: x_msg_count,
1573: x_msg_data,
1574: '_PVT'
1575: );

Line 1576: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

1572: x_msg_count,
1573: x_msg_data,
1574: '_PVT'
1575: );
1576: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1577: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS
1578: (
1579: l_api_name,
1580: G_PKG_NAME,

Line 1577: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS

1573: x_msg_data,
1574: '_PVT'
1575: );
1576: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1577: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS
1578: (
1579: l_api_name,
1580: G_PKG_NAME,
1581: 'Okl_Api.G_RET_STS_UNEXP_ERROR',

Line 1581: 'Okl_Api.G_RET_STS_UNEXP_ERROR',

1577: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS
1578: (
1579: l_api_name,
1580: G_PKG_NAME,
1581: 'Okl_Api.G_RET_STS_UNEXP_ERROR',
1582: x_msg_count,
1583: x_msg_data,
1584: '_PVT'
1585: );

Line 1587: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS

1583: x_msg_data,
1584: '_PVT'
1585: );
1586: WHEN OTHERS THEN
1587: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS
1588: (
1589: l_api_name,
1590: G_PKG_NAME,
1591: 'OTHERS',

Line 1603: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

1599: -- PL/SQL TBL update_row for:OKL_ST_GEN_PRC_PARAMS_V --
1600: -------------------------------------------------------
1601: PROCEDURE update_row(
1602: p_api_version IN NUMBER,
1603: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
1604: x_return_status OUT NOCOPY VARCHAR2,
1605: x_msg_count OUT NOCOPY NUMBER,
1606: x_msg_data OUT NOCOPY VARCHAR2,
1607: p_gtpv_tbl IN gtpv_tbl_type,

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

1608: x_gtpv_tbl OUT NOCOPY gtpv_tbl_type) IS
1609:
1610: l_api_version CONSTANT NUMBER := 1;
1611: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_update_row';
1612: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1613: i NUMBER := 0;
1614:
1615: l_overall_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1616: BEGIN

Line 1615: l_overall_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

1611: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_update_row';
1612: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1613: i NUMBER := 0;
1614:
1615: l_overall_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1616: BEGIN
1617: Okl_Api.init_msg_list(p_init_msg_list);
1618: -- Make sure PL/SQL table has records in it before passing
1619: IF (p_gtpv_tbl.COUNT > 0) THEN

Line 1617: Okl_Api.init_msg_list(p_init_msg_list);

1613: i NUMBER := 0;
1614:
1615: l_overall_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1616: BEGIN
1617: Okl_Api.init_msg_list(p_init_msg_list);
1618: -- Make sure PL/SQL table has records in it before passing
1619: IF (p_gtpv_tbl.COUNT > 0) THEN
1620: i := p_gtpv_tbl.FIRST;
1621: LOOP

Line 1624: p_init_msg_list => Okl_Api.G_FALSE,

1620: i := p_gtpv_tbl.FIRST;
1621: LOOP
1622: update_row (
1623: p_api_version => l_api_version,
1624: p_init_msg_list => Okl_Api.G_FALSE,
1625: x_return_status => x_return_status,
1626: x_msg_count => x_msg_count,
1627: x_msg_data => x_msg_data,
1628: p_gtpv_rec => p_gtpv_tbl(i),

Line 1631: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN

1627: x_msg_data => x_msg_data,
1628: p_gtpv_rec => p_gtpv_tbl(i),
1629: x_gtpv_rec => x_gtpv_tbl(i));
1630:
1631: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
1632: IF l_overall_status <> Okl_Api.G_RET_STS_UNEXP_ERROR THEN
1633: l_overall_status := x_return_status;
1634: END IF;
1635: END IF;

Line 1632: IF l_overall_status <> Okl_Api.G_RET_STS_UNEXP_ERROR THEN

1628: p_gtpv_rec => p_gtpv_tbl(i),
1629: x_gtpv_rec => x_gtpv_tbl(i));
1630:
1631: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
1632: IF l_overall_status <> Okl_Api.G_RET_STS_UNEXP_ERROR THEN
1633: l_overall_status := x_return_status;
1634: END IF;
1635: END IF;
1636:

Line 1645: WHEN Okl_Api.G_EXCEPTION_ERROR THEN

1641: x_return_status := l_overall_status;
1642:
1643: END IF;
1644: EXCEPTION
1645: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
1646: x_return_status := Okl_Api.HANDLE_EXCEPTIONS
1647: (
1648: l_api_name,
1649: G_PKG_NAME,

Line 1646: x_return_status := Okl_Api.HANDLE_EXCEPTIONS

1642:
1643: END IF;
1644: EXCEPTION
1645: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
1646: x_return_status := Okl_Api.HANDLE_EXCEPTIONS
1647: (
1648: l_api_name,
1649: G_PKG_NAME,
1650: 'Okl_Api.G_RET_STS_ERROR',

Line 1650: 'Okl_Api.G_RET_STS_ERROR',

1646: x_return_status := Okl_Api.HANDLE_EXCEPTIONS
1647: (
1648: l_api_name,
1649: G_PKG_NAME,
1650: 'Okl_Api.G_RET_STS_ERROR',
1651: x_msg_count,
1652: x_msg_data,
1653: '_PVT'
1654: );

Line 1655: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

1651: x_msg_count,
1652: x_msg_data,
1653: '_PVT'
1654: );
1655: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1656: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS
1657: (
1658: l_api_name,
1659: G_PKG_NAME,

Line 1656: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS

1652: x_msg_data,
1653: '_PVT'
1654: );
1655: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1656: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS
1657: (
1658: l_api_name,
1659: G_PKG_NAME,
1660: 'Okl_Api.G_RET_STS_UNEXP_ERROR',

Line 1660: 'Okl_Api.G_RET_STS_UNEXP_ERROR',

1656: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS
1657: (
1658: l_api_name,
1659: G_PKG_NAME,
1660: 'Okl_Api.G_RET_STS_UNEXP_ERROR',
1661: x_msg_count,
1662: x_msg_data,
1663: '_PVT'
1664: );

Line 1666: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS

1662: x_msg_data,
1663: '_PVT'
1664: );
1665: WHEN OTHERS THEN
1666: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS
1667: (
1668: l_api_name,
1669: G_PKG_NAME,
1670: 'OTHERS',

Line 1684: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

1680: ------------------------------------------
1681: -- delete_row for:OKL_ST_GEN_PRC_PARAMS --
1682: ------------------------------------------
1683: PROCEDURE delete_row(
1684: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
1685: x_return_status OUT NOCOPY VARCHAR2,
1686: x_msg_count OUT NOCOPY NUMBER,
1687: x_msg_data OUT NOCOPY VARCHAR2,
1688: p_gtp_rec IN gtp_rec_type) IS

Line 1692: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

1688: p_gtp_rec IN gtp_rec_type) IS
1689:
1690: l_api_version CONSTANT NUMBER := 1;
1691: l_api_name CONSTANT VARCHAR2(30) := 'OPTS_delete_row';
1692: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1693: l_gtp_rec gtp_rec_type:= p_gtp_rec;
1694: l_row_notfound BOOLEAN := TRUE;
1695: BEGIN
1696: l_return_status := Okl_Api.START_ACTIVITY(l_api_name,

Line 1696: l_return_status := Okl_Api.START_ACTIVITY(l_api_name,

1692: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1693: l_gtp_rec gtp_rec_type:= p_gtp_rec;
1694: l_row_notfound BOOLEAN := TRUE;
1695: BEGIN
1696: l_return_status := Okl_Api.START_ACTIVITY(l_api_name,
1697: p_init_msg_list,
1698: '_PVT',
1699: x_return_status);
1700: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

Line 1700: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

1696: l_return_status := Okl_Api.START_ACTIVITY(l_api_name,
1697: p_init_msg_list,
1698: '_PVT',
1699: x_return_status);
1700: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1701: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1702: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1703: RAISE Okl_Api.G_EXCEPTION_ERROR;
1704: END IF;

Line 1701: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1697: p_init_msg_list,
1698: '_PVT',
1699: x_return_status);
1700: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1701: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1702: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1703: RAISE Okl_Api.G_EXCEPTION_ERROR;
1704: END IF;
1705:

Line 1702: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN

1698: '_PVT',
1699: x_return_status);
1700: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1701: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1702: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1703: RAISE Okl_Api.G_EXCEPTION_ERROR;
1704: END IF;
1705:
1706: -- Actual deletion of the row

Line 1703: RAISE Okl_Api.G_EXCEPTION_ERROR;

1699: x_return_status);
1700: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1701: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1702: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1703: RAISE Okl_Api.G_EXCEPTION_ERROR;
1704: END IF;
1705:
1706: -- Actual deletion of the row
1707: DELETE FROM OKL_ST_GEN_PRC_PARAMS

Line 1710: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);

1706: -- Actual deletion of the row
1707: DELETE FROM OKL_ST_GEN_PRC_PARAMS
1708: WHERE ID = l_gtp_rec.id;
1709:
1710: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1711:
1712: EXCEPTION
1713: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
1714: x_return_status := Okl_Api.HANDLE_EXCEPTIONS

Line 1713: WHEN Okl_Api.G_EXCEPTION_ERROR THEN

1709:
1710: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1711:
1712: EXCEPTION
1713: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
1714: x_return_status := Okl_Api.HANDLE_EXCEPTIONS
1715: (
1716: l_api_name,
1717: G_PKG_NAME,

Line 1714: x_return_status := Okl_Api.HANDLE_EXCEPTIONS

1710: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1711:
1712: EXCEPTION
1713: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
1714: x_return_status := Okl_Api.HANDLE_EXCEPTIONS
1715: (
1716: l_api_name,
1717: G_PKG_NAME,
1718: 'Okl_Api.G_RET_STS_ERROR',

Line 1718: 'Okl_Api.G_RET_STS_ERROR',

1714: x_return_status := Okl_Api.HANDLE_EXCEPTIONS
1715: (
1716: l_api_name,
1717: G_PKG_NAME,
1718: 'Okl_Api.G_RET_STS_ERROR',
1719: x_msg_count,
1720: x_msg_data,
1721: '_PVT'
1722: );

Line 1723: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

1719: x_msg_count,
1720: x_msg_data,
1721: '_PVT'
1722: );
1723: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1724: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS
1725: (
1726: l_api_name,
1727: G_PKG_NAME,

Line 1724: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS

1720: x_msg_data,
1721: '_PVT'
1722: );
1723: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1724: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS
1725: (
1726: l_api_name,
1727: G_PKG_NAME,
1728: 'Okl_Api.G_RET_STS_UNEXP_ERROR',

Line 1728: 'Okl_Api.G_RET_STS_UNEXP_ERROR',

1724: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS
1725: (
1726: l_api_name,
1727: G_PKG_NAME,
1728: 'Okl_Api.G_RET_STS_UNEXP_ERROR',
1729: x_msg_count,
1730: x_msg_data,
1731: '_PVT'
1732: );

Line 1734: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS

1730: x_msg_data,
1731: '_PVT'
1732: );
1733: WHEN OTHERS THEN
1734: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS
1735: (
1736: l_api_name,
1737: G_PKG_NAME,
1738: 'OTHERS',

Line 1750: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

1746: -- delete_row for:OKL_ST_GEN_PRC_PARAMS_V --
1747: --------------------------------------------
1748: PROCEDURE delete_row(
1749: p_api_version IN NUMBER,
1750: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
1751: x_return_status OUT NOCOPY VARCHAR2,
1752: x_msg_count OUT NOCOPY NUMBER,
1753: x_msg_data OUT NOCOPY VARCHAR2,
1754: p_gtpv_rec IN gtpv_rec_type) IS

Line 1758: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

1754: p_gtpv_rec IN gtpv_rec_type) IS
1755:
1756: l_api_version CONSTANT NUMBER := 1;
1757: l_api_name CONSTANT VARCHAR2(30) := 'V_delete_row';
1758: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1759: l_gtpv_rec gtpv_rec_type := p_gtpv_rec;
1760: l_gtp_rec gtp_rec_type;
1761: BEGIN
1762: l_return_status := Okl_Api.START_ACTIVITY(l_api_name,

Line 1762: l_return_status := Okl_Api.START_ACTIVITY(l_api_name,

1758: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1759: l_gtpv_rec gtpv_rec_type := p_gtpv_rec;
1760: l_gtp_rec gtp_rec_type;
1761: BEGIN
1762: l_return_status := Okl_Api.START_ACTIVITY(l_api_name,
1763: G_PKG_NAME,
1764: p_init_msg_list,
1765: l_api_version,
1766: p_api_version,

Line 1769: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

1765: l_api_version,
1766: p_api_version,
1767: '_PVT',
1768: x_return_status);
1769: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1770: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1771: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1772: RAISE Okl_Api.G_EXCEPTION_ERROR;
1773: END IF;

Line 1770: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1766: p_api_version,
1767: '_PVT',
1768: x_return_status);
1769: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1770: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1771: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1772: RAISE Okl_Api.G_EXCEPTION_ERROR;
1773: END IF;
1774: --------------------------------------

Line 1771: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN

1767: '_PVT',
1768: x_return_status);
1769: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1770: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1771: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1772: RAISE Okl_Api.G_EXCEPTION_ERROR;
1773: END IF;
1774: --------------------------------------
1775: -- Move VIEW record to "Child" records

Line 1772: RAISE Okl_Api.G_EXCEPTION_ERROR;

1768: x_return_status);
1769: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1770: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1771: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1772: RAISE Okl_Api.G_EXCEPTION_ERROR;
1773: END IF;
1774: --------------------------------------
1775: -- Move VIEW record to "Child" records
1776: --------------------------------------

Line 1789: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

1785: x_msg_data => x_msg_data,
1786: p_gtp_rec => l_gtp_rec
1787: );
1788:
1789: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1790: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1791: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1792: RAISE Okl_Api.G_EXCEPTION_ERROR;
1793: END IF;

Line 1790: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1786: p_gtp_rec => l_gtp_rec
1787: );
1788:
1789: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1790: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1791: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1792: RAISE Okl_Api.G_EXCEPTION_ERROR;
1793: END IF;
1794: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);

Line 1791: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN

1787: );
1788:
1789: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1790: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1791: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1792: RAISE Okl_Api.G_EXCEPTION_ERROR;
1793: END IF;
1794: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1795:

Line 1792: RAISE Okl_Api.G_EXCEPTION_ERROR;

1788:
1789: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1790: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1791: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1792: RAISE Okl_Api.G_EXCEPTION_ERROR;
1793: END IF;
1794: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1795:
1796: EXCEPTION

Line 1794: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);

1790: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1791: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1792: RAISE Okl_Api.G_EXCEPTION_ERROR;
1793: END IF;
1794: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1795:
1796: EXCEPTION
1797: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
1798: x_return_status := Okl_Api.HANDLE_EXCEPTIONS

Line 1797: WHEN Okl_Api.G_EXCEPTION_ERROR THEN

1793: END IF;
1794: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1795:
1796: EXCEPTION
1797: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
1798: x_return_status := Okl_Api.HANDLE_EXCEPTIONS
1799: (
1800: l_api_name,
1801: G_PKG_NAME,

Line 1798: x_return_status := Okl_Api.HANDLE_EXCEPTIONS

1794: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1795:
1796: EXCEPTION
1797: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
1798: x_return_status := Okl_Api.HANDLE_EXCEPTIONS
1799: (
1800: l_api_name,
1801: G_PKG_NAME,
1802: 'Okl_Api.G_RET_STS_ERROR',

Line 1802: 'Okl_Api.G_RET_STS_ERROR',

1798: x_return_status := Okl_Api.HANDLE_EXCEPTIONS
1799: (
1800: l_api_name,
1801: G_PKG_NAME,
1802: 'Okl_Api.G_RET_STS_ERROR',
1803: x_msg_count,
1804: x_msg_data,
1805: '_PVT'
1806: );

Line 1807: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

1803: x_msg_count,
1804: x_msg_data,
1805: '_PVT'
1806: );
1807: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1808: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS
1809: (
1810: l_api_name,
1811: G_PKG_NAME,

Line 1808: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS

1804: x_msg_data,
1805: '_PVT'
1806: );
1807: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1808: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS
1809: (
1810: l_api_name,
1811: G_PKG_NAME,
1812: 'Okl_Api.G_RET_STS_UNEXP_ERROR',

Line 1812: 'Okl_Api.G_RET_STS_UNEXP_ERROR',

1808: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS
1809: (
1810: l_api_name,
1811: G_PKG_NAME,
1812: 'Okl_Api.G_RET_STS_UNEXP_ERROR',
1813: x_msg_count,
1814: x_msg_data,
1815: '_PVT'
1816: );

Line 1818: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS

1814: x_msg_data,
1815: '_PVT'
1816: );
1817: WHEN OTHERS THEN
1818: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS
1819: (
1820: l_api_name,
1821: G_PKG_NAME,
1822: 'OTHERS',

Line 1836: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

1832: -- PL/SQL TBL delete_row for: OKL_ST_GEN_PRC_PARAMS_V --
1833: --------------------------------------------------------
1834: PROCEDURE delete_row(
1835: p_api_version IN NUMBER,
1836: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
1837: x_return_status OUT NOCOPY VARCHAR2,
1838: x_msg_count OUT NOCOPY NUMBER,
1839: x_msg_data OUT NOCOPY VARCHAR2,
1840: p_gtpv_tbl IN gtpv_tbl_type) IS

Line 1844: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

1840: p_gtpv_tbl IN gtpv_tbl_type) IS
1841:
1842: l_api_version CONSTANT NUMBER := 1;
1843: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_delete_row';
1844: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1845: i NUMBER := 0;
1846: l_overall_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1847:
1848: BEGIN

Line 1846: l_overall_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

1842: l_api_version CONSTANT NUMBER := 1;
1843: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_delete_row';
1844: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1845: i NUMBER := 0;
1846: l_overall_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1847:
1848: BEGIN
1849: Okl_Api.init_msg_list(p_init_msg_list);
1850:

Line 1849: Okl_Api.init_msg_list(p_init_msg_list);

1845: i NUMBER := 0;
1846: l_overall_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1847:
1848: BEGIN
1849: Okl_Api.init_msg_list(p_init_msg_list);
1850:
1851: -- Make sure PL/SQL table has records in it before passing
1852: IF (p_gtpv_tbl.COUNT > 0) THEN
1853: i := p_gtpv_tbl.FIRST;

Line 1857: p_init_msg_list => Okl_Api.G_FALSE,

1853: i := p_gtpv_tbl.FIRST;
1854: LOOP
1855: delete_row (
1856: p_api_version => l_api_version,
1857: p_init_msg_list => Okl_Api.G_FALSE,
1858: x_return_status => x_return_status,
1859: x_msg_count => x_msg_count,
1860: x_msg_data => x_msg_data,
1861: p_gtpv_rec => p_gtpv_tbl(i));

Line 1863: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN

1859: x_msg_count => x_msg_count,
1860: x_msg_data => x_msg_data,
1861: p_gtpv_rec => p_gtpv_tbl(i));
1862:
1863: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
1864: IF l_overall_status <> Okl_Api.G_RET_STS_UNEXP_ERROR THEN
1865: l_overall_status := x_return_status;
1866: END IF;
1867: END IF;

Line 1864: IF l_overall_status <> Okl_Api.G_RET_STS_UNEXP_ERROR THEN

1860: x_msg_data => x_msg_data,
1861: p_gtpv_rec => p_gtpv_tbl(i));
1862:
1863: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
1864: IF l_overall_status <> Okl_Api.G_RET_STS_UNEXP_ERROR THEN
1865: l_overall_status := x_return_status;
1866: END IF;
1867: END IF;
1868:

Line 1876: WHEN Okl_Api.G_EXCEPTION_ERROR THEN

1872:
1873: x_return_status := l_overall_status;
1874: END IF;
1875: EXCEPTION
1876: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
1877: x_return_status := Okl_Api.HANDLE_EXCEPTIONS
1878: (
1879: l_api_name,
1880: G_PKG_NAME,

Line 1877: x_return_status := Okl_Api.HANDLE_EXCEPTIONS

1873: x_return_status := l_overall_status;
1874: END IF;
1875: EXCEPTION
1876: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
1877: x_return_status := Okl_Api.HANDLE_EXCEPTIONS
1878: (
1879: l_api_name,
1880: G_PKG_NAME,
1881: 'Okl_Api.G_RET_STS_ERROR',

Line 1881: 'Okl_Api.G_RET_STS_ERROR',

1877: x_return_status := Okl_Api.HANDLE_EXCEPTIONS
1878: (
1879: l_api_name,
1880: G_PKG_NAME,
1881: 'Okl_Api.G_RET_STS_ERROR',
1882: x_msg_count,
1883: x_msg_data,
1884: '_PVT'
1885: );

Line 1886: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

1882: x_msg_count,
1883: x_msg_data,
1884: '_PVT'
1885: );
1886: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1887: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS
1888: (
1889: l_api_name,
1890: G_PKG_NAME,

Line 1887: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS

1883: x_msg_data,
1884: '_PVT'
1885: );
1886: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1887: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS
1888: (
1889: l_api_name,
1890: G_PKG_NAME,
1891: 'Okl_Api.G_RET_STS_UNEXP_ERROR',

Line 1891: 'Okl_Api.G_RET_STS_UNEXP_ERROR',

1887: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS
1888: (
1889: l_api_name,
1890: G_PKG_NAME,
1891: 'Okl_Api.G_RET_STS_UNEXP_ERROR',
1892: x_msg_count,
1893: x_msg_data,
1894: '_PVT'
1895: );

Line 1897: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS

1893: x_msg_data,
1894: '_PVT'
1895: );
1896: WHEN OTHERS THEN
1897: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS
1898: (
1899: l_api_name,
1900: G_PKG_NAME,
1901: 'OTHERS',