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

Line 208: IF (l_sstv_rec.object_version_number = Okl_Api.G_MISS_NUM) THEN

204: p_sstv_rec IN sstv_rec_type
205: ) RETURN sstv_rec_type IS
206: l_sstv_rec sstv_rec_type := p_sstv_rec;
207: BEGIN
208: IF (l_sstv_rec.object_version_number = Okl_Api.G_MISS_NUM) THEN
209: l_sstv_rec.object_version_number := NULL;
210: END IF;
211: IF (l_sstv_rec.sty_id = Okl_Api.G_MISS_NUM) THEN
212: l_sstv_rec.sty_id := NULL;

Line 211: IF (l_sstv_rec.sty_id = Okl_Api.G_MISS_NUM) THEN

207: BEGIN
208: IF (l_sstv_rec.object_version_number = Okl_Api.G_MISS_NUM) THEN
209: l_sstv_rec.object_version_number := NULL;
210: END IF;
211: IF (l_sstv_rec.sty_id = Okl_Api.G_MISS_NUM) THEN
212: l_sstv_rec.sty_id := NULL;
213: END IF;
214: IF (l_sstv_rec.cah_id = Okl_Api.G_MISS_NUM) THEN
215: l_sstv_rec.cah_id := NULL;

Line 214: IF (l_sstv_rec.cah_id = Okl_Api.G_MISS_NUM) THEN

210: END IF;
211: IF (l_sstv_rec.sty_id = Okl_Api.G_MISS_NUM) THEN
212: l_sstv_rec.sty_id := NULL;
213: END IF;
214: IF (l_sstv_rec.cah_id = Okl_Api.G_MISS_NUM) THEN
215: l_sstv_rec.cah_id := NULL;
216: END IF;
217: IF (l_sstv_rec.add_yn = Okl_Api.G_MISS_CHAR) THEN
218: l_sstv_rec.add_yn := NULL;

Line 217: IF (l_sstv_rec.add_yn = Okl_Api.G_MISS_CHAR) THEN

213: END IF;
214: IF (l_sstv_rec.cah_id = Okl_Api.G_MISS_NUM) THEN
215: l_sstv_rec.cah_id := NULL;
216: END IF;
217: IF (l_sstv_rec.add_yn = Okl_Api.G_MISS_CHAR) THEN
218: l_sstv_rec.add_yn := NULL;
219: END IF;
220: IF (l_sstv_rec.attribute_category = Okl_Api.G_MISS_CHAR) THEN
221: l_sstv_rec.attribute_category := NULL;

Line 220: IF (l_sstv_rec.attribute_category = Okl_Api.G_MISS_CHAR) THEN

216: END IF;
217: IF (l_sstv_rec.add_yn = Okl_Api.G_MISS_CHAR) THEN
218: l_sstv_rec.add_yn := NULL;
219: END IF;
220: IF (l_sstv_rec.attribute_category = Okl_Api.G_MISS_CHAR) THEN
221: l_sstv_rec.attribute_category := NULL;
222: END IF;
223: IF (l_sstv_rec.attribute1 = Okl_Api.G_MISS_CHAR) THEN
224: l_sstv_rec.attribute1 := NULL;

Line 223: IF (l_sstv_rec.attribute1 = Okl_Api.G_MISS_CHAR) THEN

219: END IF;
220: IF (l_sstv_rec.attribute_category = Okl_Api.G_MISS_CHAR) THEN
221: l_sstv_rec.attribute_category := NULL;
222: END IF;
223: IF (l_sstv_rec.attribute1 = Okl_Api.G_MISS_CHAR) THEN
224: l_sstv_rec.attribute1 := NULL;
225: END IF;
226: IF (l_sstv_rec.attribute2 = Okl_Api.G_MISS_CHAR) THEN
227: l_sstv_rec.attribute2 := NULL;

Line 226: IF (l_sstv_rec.attribute2 = Okl_Api.G_MISS_CHAR) THEN

222: END IF;
223: IF (l_sstv_rec.attribute1 = Okl_Api.G_MISS_CHAR) THEN
224: l_sstv_rec.attribute1 := NULL;
225: END IF;
226: IF (l_sstv_rec.attribute2 = Okl_Api.G_MISS_CHAR) THEN
227: l_sstv_rec.attribute2 := NULL;
228: END IF;
229: IF (l_sstv_rec.attribute3 = Okl_Api.G_MISS_CHAR) THEN
230: l_sstv_rec.attribute3 := NULL;

Line 229: IF (l_sstv_rec.attribute3 = Okl_Api.G_MISS_CHAR) THEN

225: END IF;
226: IF (l_sstv_rec.attribute2 = Okl_Api.G_MISS_CHAR) THEN
227: l_sstv_rec.attribute2 := NULL;
228: END IF;
229: IF (l_sstv_rec.attribute3 = Okl_Api.G_MISS_CHAR) THEN
230: l_sstv_rec.attribute3 := NULL;
231: END IF;
232: IF (l_sstv_rec.attribute4 = Okl_Api.G_MISS_CHAR) THEN
233: l_sstv_rec.attribute4 := NULL;

Line 232: IF (l_sstv_rec.attribute4 = Okl_Api.G_MISS_CHAR) THEN

228: END IF;
229: IF (l_sstv_rec.attribute3 = Okl_Api.G_MISS_CHAR) THEN
230: l_sstv_rec.attribute3 := NULL;
231: END IF;
232: IF (l_sstv_rec.attribute4 = Okl_Api.G_MISS_CHAR) THEN
233: l_sstv_rec.attribute4 := NULL;
234: END IF;
235: IF (l_sstv_rec.attribute5 = Okl_Api.G_MISS_CHAR) THEN
236: l_sstv_rec.attribute5 := NULL;

Line 235: IF (l_sstv_rec.attribute5 = Okl_Api.G_MISS_CHAR) THEN

231: END IF;
232: IF (l_sstv_rec.attribute4 = Okl_Api.G_MISS_CHAR) THEN
233: l_sstv_rec.attribute4 := NULL;
234: END IF;
235: IF (l_sstv_rec.attribute5 = Okl_Api.G_MISS_CHAR) THEN
236: l_sstv_rec.attribute5 := NULL;
237: END IF;
238: IF (l_sstv_rec.attribute6 = Okl_Api.G_MISS_CHAR) THEN
239: l_sstv_rec.attribute6 := NULL;

Line 238: IF (l_sstv_rec.attribute6 = Okl_Api.G_MISS_CHAR) THEN

234: END IF;
235: IF (l_sstv_rec.attribute5 = Okl_Api.G_MISS_CHAR) THEN
236: l_sstv_rec.attribute5 := NULL;
237: END IF;
238: IF (l_sstv_rec.attribute6 = Okl_Api.G_MISS_CHAR) THEN
239: l_sstv_rec.attribute6 := NULL;
240: END IF;
241: IF (l_sstv_rec.attribute7 = Okl_Api.G_MISS_CHAR) THEN
242: l_sstv_rec.attribute7 := NULL;

Line 241: IF (l_sstv_rec.attribute7 = Okl_Api.G_MISS_CHAR) THEN

237: END IF;
238: IF (l_sstv_rec.attribute6 = Okl_Api.G_MISS_CHAR) THEN
239: l_sstv_rec.attribute6 := NULL;
240: END IF;
241: IF (l_sstv_rec.attribute7 = Okl_Api.G_MISS_CHAR) THEN
242: l_sstv_rec.attribute7 := NULL;
243: END IF;
244: IF (l_sstv_rec.attribute8 = Okl_Api.G_MISS_CHAR) THEN
245: l_sstv_rec.attribute8 := NULL;

Line 244: IF (l_sstv_rec.attribute8 = Okl_Api.G_MISS_CHAR) THEN

240: END IF;
241: IF (l_sstv_rec.attribute7 = Okl_Api.G_MISS_CHAR) THEN
242: l_sstv_rec.attribute7 := NULL;
243: END IF;
244: IF (l_sstv_rec.attribute8 = Okl_Api.G_MISS_CHAR) THEN
245: l_sstv_rec.attribute8 := NULL;
246: END IF;
247: IF (l_sstv_rec.attribute9 = Okl_Api.G_MISS_CHAR) THEN
248: l_sstv_rec.attribute9 := NULL;

Line 247: IF (l_sstv_rec.attribute9 = Okl_Api.G_MISS_CHAR) THEN

243: END IF;
244: IF (l_sstv_rec.attribute8 = Okl_Api.G_MISS_CHAR) THEN
245: l_sstv_rec.attribute8 := NULL;
246: END IF;
247: IF (l_sstv_rec.attribute9 = Okl_Api.G_MISS_CHAR) THEN
248: l_sstv_rec.attribute9 := NULL;
249: END IF;
250: IF (l_sstv_rec.attribute10 = Okl_Api.G_MISS_CHAR) THEN
251: l_sstv_rec.attribute10 := NULL;

Line 250: IF (l_sstv_rec.attribute10 = Okl_Api.G_MISS_CHAR) THEN

246: END IF;
247: IF (l_sstv_rec.attribute9 = Okl_Api.G_MISS_CHAR) THEN
248: l_sstv_rec.attribute9 := NULL;
249: END IF;
250: IF (l_sstv_rec.attribute10 = Okl_Api.G_MISS_CHAR) THEN
251: l_sstv_rec.attribute10 := NULL;
252: END IF;
253: IF (l_sstv_rec.attribute11 = Okl_Api.G_MISS_CHAR) THEN
254: l_sstv_rec.attribute11 := NULL;

Line 253: IF (l_sstv_rec.attribute11 = Okl_Api.G_MISS_CHAR) THEN

249: END IF;
250: IF (l_sstv_rec.attribute10 = Okl_Api.G_MISS_CHAR) THEN
251: l_sstv_rec.attribute10 := NULL;
252: END IF;
253: IF (l_sstv_rec.attribute11 = Okl_Api.G_MISS_CHAR) THEN
254: l_sstv_rec.attribute11 := NULL;
255: END IF;
256: IF (l_sstv_rec.attribute12 = Okl_Api.G_MISS_CHAR) THEN
257: l_sstv_rec.attribute12 := NULL;

Line 256: IF (l_sstv_rec.attribute12 = Okl_Api.G_MISS_CHAR) THEN

252: END IF;
253: IF (l_sstv_rec.attribute11 = Okl_Api.G_MISS_CHAR) THEN
254: l_sstv_rec.attribute11 := NULL;
255: END IF;
256: IF (l_sstv_rec.attribute12 = Okl_Api.G_MISS_CHAR) THEN
257: l_sstv_rec.attribute12 := NULL;
258: END IF;
259: IF (l_sstv_rec.attribute13 = Okl_Api.G_MISS_CHAR) THEN
260: l_sstv_rec.attribute13 := NULL;

Line 259: IF (l_sstv_rec.attribute13 = Okl_Api.G_MISS_CHAR) THEN

255: END IF;
256: IF (l_sstv_rec.attribute12 = Okl_Api.G_MISS_CHAR) THEN
257: l_sstv_rec.attribute12 := NULL;
258: END IF;
259: IF (l_sstv_rec.attribute13 = Okl_Api.G_MISS_CHAR) THEN
260: l_sstv_rec.attribute13 := NULL;
261: END IF;
262: IF (l_sstv_rec.attribute14 = Okl_Api.G_MISS_CHAR) THEN
263: l_sstv_rec.attribute14 := NULL;

Line 262: IF (l_sstv_rec.attribute14 = Okl_Api.G_MISS_CHAR) THEN

258: END IF;
259: IF (l_sstv_rec.attribute13 = Okl_Api.G_MISS_CHAR) THEN
260: l_sstv_rec.attribute13 := NULL;
261: END IF;
262: IF (l_sstv_rec.attribute14 = Okl_Api.G_MISS_CHAR) THEN
263: l_sstv_rec.attribute14 := NULL;
264: END IF;
265: IF (l_sstv_rec.attribute15 = Okl_Api.G_MISS_CHAR) THEN
266: l_sstv_rec.attribute15 := NULL;

Line 265: IF (l_sstv_rec.attribute15 = Okl_Api.G_MISS_CHAR) THEN

261: END IF;
262: IF (l_sstv_rec.attribute14 = Okl_Api.G_MISS_CHAR) THEN
263: l_sstv_rec.attribute14 := NULL;
264: END IF;
265: IF (l_sstv_rec.attribute15 = Okl_Api.G_MISS_CHAR) THEN
266: l_sstv_rec.attribute15 := NULL;
267: END IF;
268: IF (l_sstv_rec.created_by = Okl_Api.G_MISS_NUM) THEN
269: l_sstv_rec.created_by := NULL;

Line 268: IF (l_sstv_rec.created_by = Okl_Api.G_MISS_NUM) THEN

264: END IF;
265: IF (l_sstv_rec.attribute15 = Okl_Api.G_MISS_CHAR) THEN
266: l_sstv_rec.attribute15 := NULL;
267: END IF;
268: IF (l_sstv_rec.created_by = Okl_Api.G_MISS_NUM) THEN
269: l_sstv_rec.created_by := NULL;
270: END IF;
271: IF (l_sstv_rec.creation_date = Okl_Api.G_MISS_DATE) THEN
272: l_sstv_rec.creation_date := NULL;

Line 271: IF (l_sstv_rec.creation_date = Okl_Api.G_MISS_DATE) THEN

267: END IF;
268: IF (l_sstv_rec.created_by = Okl_Api.G_MISS_NUM) THEN
269: l_sstv_rec.created_by := NULL;
270: END IF;
271: IF (l_sstv_rec.creation_date = Okl_Api.G_MISS_DATE) THEN
272: l_sstv_rec.creation_date := NULL;
273: END IF;
274: IF (l_sstv_rec.last_updated_by = Okl_Api.G_MISS_NUM) THEN
275: l_sstv_rec.last_updated_by := NULL;

Line 274: IF (l_sstv_rec.last_updated_by = Okl_Api.G_MISS_NUM) THEN

270: END IF;
271: IF (l_sstv_rec.creation_date = Okl_Api.G_MISS_DATE) THEN
272: l_sstv_rec.creation_date := NULL;
273: END IF;
274: IF (l_sstv_rec.last_updated_by = Okl_Api.G_MISS_NUM) THEN
275: l_sstv_rec.last_updated_by := NULL;
276: END IF;
277: IF (l_sstv_rec.last_update_date = Okl_Api.G_MISS_DATE) THEN
278: l_sstv_rec.last_update_date := NULL;

Line 277: IF (l_sstv_rec.last_update_date = Okl_Api.G_MISS_DATE) THEN

273: END IF;
274: IF (l_sstv_rec.last_updated_by = Okl_Api.G_MISS_NUM) THEN
275: l_sstv_rec.last_updated_by := NULL;
276: END IF;
277: IF (l_sstv_rec.last_update_date = Okl_Api.G_MISS_DATE) THEN
278: l_sstv_rec.last_update_date := NULL;
279: END IF;
280: IF (l_sstv_rec.last_update_login = Okl_Api.G_MISS_NUM) THEN
281: l_sstv_rec.last_update_login := NULL;

Line 280: IF (l_sstv_rec.last_update_login = Okl_Api.G_MISS_NUM) THEN

276: END IF;
277: IF (l_sstv_rec.last_update_date = Okl_Api.G_MISS_DATE) THEN
278: l_sstv_rec.last_update_date := NULL;
279: END IF;
280: IF (l_sstv_rec.last_update_login = Okl_Api.G_MISS_NUM) THEN
281: l_sstv_rec.last_update_login := NULL;
282: END IF;
283: RETURN(l_sstv_rec);
284: END null_out_defaults;

Line 309: x_return_status:=Okl_Api.G_RET_STS_SUCCESS;

305:
306: l_dummy_var VARCHAR2(1):='0';
307:
308: BEGIN
309: x_return_status:=Okl_Api.G_RET_STS_SUCCESS;
310: --check not null
311: IF (p_sstv_rec.cah_id IS NULL) OR (p_sstv_rec.cah_id = Okl_Api.G_MISS_NUM) THEN
312: x_return_status:=Okl_Api.G_RET_STS_ERROR;
313: --set error message in message stack

Line 311: IF (p_sstv_rec.cah_id IS NULL) OR (p_sstv_rec.cah_id = Okl_Api.G_MISS_NUM) THEN

307:
308: BEGIN
309: x_return_status:=Okl_Api.G_RET_STS_SUCCESS;
310: --check not null
311: IF (p_sstv_rec.cah_id IS NULL) OR (p_sstv_rec.cah_id = Okl_Api.G_MISS_NUM) THEN
312: x_return_status:=Okl_Api.G_RET_STS_ERROR;
313: --set error message in message stack
314: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,
315: p_msg_name => G_REQUIRED_VALUE,

Line 312: x_return_status:=Okl_Api.G_RET_STS_ERROR;

308: BEGIN
309: x_return_status:=Okl_Api.G_RET_STS_SUCCESS;
310: --check not null
311: IF (p_sstv_rec.cah_id IS NULL) OR (p_sstv_rec.cah_id = Okl_Api.G_MISS_NUM) THEN
312: x_return_status:=Okl_Api.G_RET_STS_ERROR;
313: --set error message in message stack
314: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,
315: p_msg_name => G_REQUIRED_VALUE,
316: p_token1 => G_COL_NAME_TOKEN,

Line 314: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,

310: --check not null
311: IF (p_sstv_rec.cah_id IS NULL) OR (p_sstv_rec.cah_id = Okl_Api.G_MISS_NUM) THEN
312: x_return_status:=Okl_Api.G_RET_STS_ERROR;
313: --set error message in message stack
314: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,
315: p_msg_name => G_REQUIRED_VALUE,
316: p_token1 => G_COL_NAME_TOKEN,
317: p_token1_value => 'CAH_ID');
318: -- RAISE G_EXCEPTION_HALT_VALIDATION;

Line 328: x_return_status:= Okl_Api.G_RET_STS_ERROR;

324: CLOSE l_cah_id_csr;
325: IF (l_dummy_var<>'1') THEN
326:
327: --Corresponding Column value not found
328: x_return_status:= Okl_Api.G_RET_STS_ERROR;
329: --set error message in message stack
330: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,
331: p_msg_name => G_NO_PARENT_RECORD,
332: p_token1 => G_COL_NAME_TOKEN,

Line 330: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,

326:
327: --Corresponding Column value not found
328: x_return_status:= Okl_Api.G_RET_STS_ERROR;
329: --set error message in message stack
330: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,
331: p_msg_name => G_NO_PARENT_RECORD,
332: p_token1 => G_COL_NAME_TOKEN,
333: p_token1_value => 'CAH_ID',
334: p_token2 => G_CHILD_TABLE_TOKEN,

Line 348: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,

344: NULL;
345: -- other appropriate handlers
346: WHEN OTHERS THEN
347: -- store SQL error message on message stack
348: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,
349: p_msg_name => G_UNEXPECTED_ERROR,
350: p_token1 => G_SQLCODE_TOKEN,
351: p_token1_value => SQLCODE,
352: p_token2 => G_SQLERRM_TOKEN,

Line 356: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

352: p_token2 => G_SQLERRM_TOKEN,
353: p_token2_value => SQLERRM);
354:
355: -- notify UNEXPECTED error
356: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
357:
358: END validate_cah_id;
359:
360: -- Start of comments

Line 379: x_return_status:=Okl_Api.G_RET_STS_SUCCESS;

375:
376: l_dummy_var VARCHAR2(1):='0';
377:
378: BEGIN
379: x_return_status:=Okl_Api.G_RET_STS_SUCCESS;
380: --check not null
381: IF (p_sstv_rec.sty_id IS NULL) OR (p_sstv_rec.sty_id = Okl_Api.G_MISS_NUM) THEN
382:
383: x_return_status:=Okl_Api.G_RET_STS_ERROR;

Line 381: IF (p_sstv_rec.sty_id IS NULL) OR (p_sstv_rec.sty_id = Okl_Api.G_MISS_NUM) THEN

377:
378: BEGIN
379: x_return_status:=Okl_Api.G_RET_STS_SUCCESS;
380: --check not null
381: IF (p_sstv_rec.sty_id IS NULL) OR (p_sstv_rec.sty_id = Okl_Api.G_MISS_NUM) THEN
382:
383: x_return_status:=Okl_Api.G_RET_STS_ERROR;
384:
385: Okl_Api.SET_MESSAGE(p_app_name => 'OKL'

Line 383: x_return_status:=Okl_Api.G_RET_STS_ERROR;

379: x_return_status:=Okl_Api.G_RET_STS_SUCCESS;
380: --check not null
381: IF (p_sstv_rec.sty_id IS NULL) OR (p_sstv_rec.sty_id = Okl_Api.G_MISS_NUM) THEN
382:
383: x_return_status:=Okl_Api.G_RET_STS_ERROR;
384:
385: Okl_Api.SET_MESSAGE(p_app_name => 'OKL'
386: ,p_msg_name => 'OKL_BPD_MISSING_BILL_TYP');
387:

Line 385: Okl_Api.SET_MESSAGE(p_app_name => 'OKL'

381: IF (p_sstv_rec.sty_id IS NULL) OR (p_sstv_rec.sty_id = Okl_Api.G_MISS_NUM) THEN
382:
383: x_return_status:=Okl_Api.G_RET_STS_ERROR;
384:
385: Okl_Api.SET_MESSAGE(p_app_name => 'OKL'
386: ,p_msg_name => 'OKL_BPD_MISSING_BILL_TYP');
387:
388: RAISE G_EXCEPTION_HALT_VALIDATION;
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 => 'OKL'
386: ,p_msg_name => 'OKL_BPD_MISSING_BILL_TYP');
387:
388: RAISE G_EXCEPTION_HALT_VALIDATION;
389: -- x_return_status := Okl_Api.G_RET_STS_ERROR;
390:
391: END IF;
392:
393: END validate_sty_id;

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

400: WHERE sty_id = p_sstv_rec.sty_id
401: AND cah_id = p_sstv_rec.cah_id
402: AND id <> NVL(p_sstv_rec.id,-99999);
403:
404: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
405: l_dummy VARCHAR2(1);
406: l_found BOOLEAN;
407:
408: BEGIN

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

412: l_found := l_chr_csr%FOUND;
413: CLOSE l_chr_csr;
414:
415: IF (l_found) THEN
416: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,
417: p_msg_name => 'YOU HAVE SELECTED DUPLICATE BILLING TYPES',
418: p_token1 => 'VALUE1',
419: p_token1_value => p_sstv_rec.sty_id,
420: p_token2 => 'VALUE2',

Line 423: l_return_status := Okl_Api.G_RET_STS_ERROR;

419: p_token1_value => p_sstv_rec.sty_id,
420: p_token2 => 'VALUE2',
421: p_token2_value => NVL(p_sstv_rec.cah_id,' '));
422: -- notify caller of an error
423: l_return_status := Okl_Api.G_RET_STS_ERROR;
424: END IF;
425: RETURN (l_return_status);
426:
427: EXCEPTION

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

440: --------------------------------------------------
441: FUNCTION Validate_Attributes (
442: p_sstv_rec IN sstv_rec_type
443: ) RETURN VARCHAR2 IS
444: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
445: x_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
446:
447: BEGIN
448:

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

441: FUNCTION Validate_Attributes (
442: p_sstv_rec IN sstv_rec_type
443: ) RETURN VARCHAR2 IS
444: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
445: x_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
446:
447: BEGIN
448:
449: --Added 04/23/2001 Bruno Vaghela ---

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

448:
449: --Added 04/23/2001 Bruno Vaghela ---
450:
451: validate_cah_id(p_sstv_rec, x_return_status);
452: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
453: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN -- need to leave
454: l_return_status := x_return_status;
455: RAISE G_EXCEPTION_HALT_VALIDATION;
456: ELSE

Line 453: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN -- need to leave

449: --Added 04/23/2001 Bruno Vaghela ---
450:
451: validate_cah_id(p_sstv_rec, x_return_status);
452: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
453: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN -- need to leave
454: l_return_status := x_return_status;
455: RAISE G_EXCEPTION_HALT_VALIDATION;
456: ELSE
457: l_return_status := x_return_status; -- record that there was an error

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

458: END IF;
459: END IF;
460:
461: validate_sty_id(p_sstv_rec, x_return_status);
462: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
463: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN -- need to leave
464: l_return_status := x_return_status;
465: RAISE G_EXCEPTION_HALT_VALIDATION;
466: ELSE

Line 463: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN -- need to leave

459: END IF;
460:
461: validate_sty_id(p_sstv_rec, x_return_status);
462: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
463: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN -- need to leave
464: l_return_status := x_return_status;
465: RAISE G_EXCEPTION_HALT_VALIDATION;
466: ELSE
467: l_return_status := x_return_status; -- record that there was an error

Line 473: IF p_sstv_rec.id = Okl_Api.G_MISS_NUM OR

469: END IF;
470:
471: --END Added 04/23/2001 Bruno Vaghela ---
472:
473: IF p_sstv_rec.id = Okl_Api.G_MISS_NUM OR
474: p_sstv_rec.id IS NULL
475: THEN
476: Okl_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'id');
477: l_return_status := Okl_Api.G_RET_STS_ERROR;

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

472:
473: IF p_sstv_rec.id = Okl_Api.G_MISS_NUM OR
474: p_sstv_rec.id IS NULL
475: THEN
476: Okl_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'id');
477: l_return_status := Okl_Api.G_RET_STS_ERROR;
478: ELSIF p_sstv_rec.object_version_number = Okl_Api.G_MISS_NUM OR
479: p_sstv_rec.object_version_number IS NULL
480: THEN

Line 477: l_return_status := Okl_Api.G_RET_STS_ERROR;

473: IF p_sstv_rec.id = Okl_Api.G_MISS_NUM OR
474: p_sstv_rec.id IS NULL
475: THEN
476: Okl_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'id');
477: l_return_status := Okl_Api.G_RET_STS_ERROR;
478: ELSIF p_sstv_rec.object_version_number = Okl_Api.G_MISS_NUM OR
479: p_sstv_rec.object_version_number IS NULL
480: THEN
481: Okl_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'object_version_number');

Line 478: ELSIF p_sstv_rec.object_version_number = Okl_Api.G_MISS_NUM OR

474: p_sstv_rec.id IS NULL
475: THEN
476: Okl_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'id');
477: l_return_status := Okl_Api.G_RET_STS_ERROR;
478: ELSIF p_sstv_rec.object_version_number = Okl_Api.G_MISS_NUM OR
479: p_sstv_rec.object_version_number IS NULL
480: THEN
481: Okl_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'object_version_number');
482: l_return_status := Okl_Api.G_RET_STS_ERROR;

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

477: l_return_status := Okl_Api.G_RET_STS_ERROR;
478: ELSIF p_sstv_rec.object_version_number = Okl_Api.G_MISS_NUM OR
479: p_sstv_rec.object_version_number IS NULL
480: THEN
481: Okl_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'object_version_number');
482: l_return_status := Okl_Api.G_RET_STS_ERROR;
483: ELSIF p_sstv_rec.sty_id = Okl_Api.G_MISS_NUM OR
484: p_sstv_rec.sty_id IS NULL
485: THEN

Line 482: l_return_status := Okl_Api.G_RET_STS_ERROR;

478: ELSIF p_sstv_rec.object_version_number = Okl_Api.G_MISS_NUM OR
479: p_sstv_rec.object_version_number IS NULL
480: THEN
481: Okl_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'object_version_number');
482: l_return_status := Okl_Api.G_RET_STS_ERROR;
483: ELSIF p_sstv_rec.sty_id = Okl_Api.G_MISS_NUM OR
484: p_sstv_rec.sty_id IS NULL
485: THEN
486: Okl_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'sty_id');

Line 483: ELSIF p_sstv_rec.sty_id = Okl_Api.G_MISS_NUM OR

479: p_sstv_rec.object_version_number IS NULL
480: THEN
481: Okl_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'object_version_number');
482: l_return_status := Okl_Api.G_RET_STS_ERROR;
483: ELSIF p_sstv_rec.sty_id = Okl_Api.G_MISS_NUM OR
484: p_sstv_rec.sty_id IS NULL
485: THEN
486: Okl_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'sty_id');
487: l_return_status := Okl_Api.G_RET_STS_ERROR;

Line 486: Okl_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'sty_id');

482: l_return_status := Okl_Api.G_RET_STS_ERROR;
483: ELSIF p_sstv_rec.sty_id = Okl_Api.G_MISS_NUM OR
484: p_sstv_rec.sty_id IS NULL
485: THEN
486: Okl_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'sty_id');
487: l_return_status := Okl_Api.G_RET_STS_ERROR;
488: ELSIF p_sstv_rec.cah_id = Okl_Api.G_MISS_NUM OR
489: p_sstv_rec.cah_id IS NULL
490: THEN

Line 487: l_return_status := Okl_Api.G_RET_STS_ERROR;

483: ELSIF p_sstv_rec.sty_id = Okl_Api.G_MISS_NUM OR
484: p_sstv_rec.sty_id IS NULL
485: THEN
486: Okl_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'sty_id');
487: l_return_status := Okl_Api.G_RET_STS_ERROR;
488: ELSIF p_sstv_rec.cah_id = Okl_Api.G_MISS_NUM OR
489: p_sstv_rec.cah_id IS NULL
490: THEN
491: Okl_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'cah_id');

Line 488: ELSIF p_sstv_rec.cah_id = Okl_Api.G_MISS_NUM OR

484: p_sstv_rec.sty_id IS NULL
485: THEN
486: Okl_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'sty_id');
487: l_return_status := Okl_Api.G_RET_STS_ERROR;
488: ELSIF p_sstv_rec.cah_id = Okl_Api.G_MISS_NUM OR
489: p_sstv_rec.cah_id IS NULL
490: THEN
491: Okl_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'cah_id');
492: l_return_status := Okl_Api.G_RET_STS_ERROR;

Line 491: Okl_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'cah_id');

487: l_return_status := Okl_Api.G_RET_STS_ERROR;
488: ELSIF p_sstv_rec.cah_id = Okl_Api.G_MISS_NUM OR
489: p_sstv_rec.cah_id IS NULL
490: THEN
491: Okl_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'cah_id');
492: l_return_status := Okl_Api.G_RET_STS_ERROR;
493: END IF;
494: RETURN(l_return_status);
495: END Validate_Attributes;

Line 492: l_return_status := Okl_Api.G_RET_STS_ERROR;

488: ELSIF p_sstv_rec.cah_id = Okl_Api.G_MISS_NUM OR
489: p_sstv_rec.cah_id IS NULL
490: THEN
491: Okl_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'cah_id');
492: l_return_status := Okl_Api.G_RET_STS_ERROR;
493: END IF;
494: RETURN(l_return_status);
495: END Validate_Attributes;
496:

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

505:
506: FUNCTION Validate_Record (
507: p_sstv_rec IN sstv_rec_type
508: ) RETURN VARCHAR2 IS
509: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
510: BEGIN
511:
512: l_return_status := IS_UNIQUE(p_sstv_rec);
513:

Line 629: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

625: -- validate_row for:OKL_SRCH_STRM_TYPS_V --
626: -------------------------------------------
627: PROCEDURE validate_row(
628: p_api_version IN NUMBER,
629: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
630: x_return_status OUT NOCOPY VARCHAR2,
631: x_msg_count OUT NOCOPY NUMBER,
632: x_msg_data OUT NOCOPY VARCHAR2,
633: p_sstv_rec IN sstv_rec_type) IS

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

633: p_sstv_rec IN sstv_rec_type) IS
634:
635: l_api_version CONSTANT NUMBER := 1;
636: l_api_name CONSTANT VARCHAR2(30) := 'V_validate_row';
637: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
638: l_sstv_rec sstv_rec_type := p_sstv_rec;
639: l_sst_rec sst_rec_type;
640: BEGIN
641: l_return_status := Okl_Api.START_ACTIVITY(l_api_name,

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

637: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
638: l_sstv_rec sstv_rec_type := p_sstv_rec;
639: l_sst_rec sst_rec_type;
640: BEGIN
641: l_return_status := Okl_Api.START_ACTIVITY(l_api_name,
642: G_PKG_NAME,
643: p_init_msg_list,
644: l_api_version,
645: p_api_version,

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

644: l_api_version,
645: p_api_version,
646: '_PVT',
647: x_return_status);
648: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
649: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
650: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
651: RAISE Okl_Api.G_EXCEPTION_ERROR;
652: END IF;

Line 649: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

645: p_api_version,
646: '_PVT',
647: x_return_status);
648: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
649: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
650: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
651: RAISE Okl_Api.G_EXCEPTION_ERROR;
652: END IF;
653: --- Validate all non-missing attributes (Item Level Validation)

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

646: '_PVT',
647: x_return_status);
648: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
649: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
650: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
651: RAISE Okl_Api.G_EXCEPTION_ERROR;
652: END IF;
653: --- Validate all non-missing attributes (Item Level Validation)
654: l_return_status := Validate_Attributes(l_sstv_rec);

Line 651: RAISE Okl_Api.G_EXCEPTION_ERROR;

647: x_return_status);
648: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
649: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
650: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
651: RAISE Okl_Api.G_EXCEPTION_ERROR;
652: END IF;
653: --- Validate all non-missing attributes (Item Level Validation)
654: l_return_status := Validate_Attributes(l_sstv_rec);
655: --- If any errors happen abort API

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

652: END IF;
653: --- Validate all non-missing attributes (Item Level Validation)
654: l_return_status := Validate_Attributes(l_sstv_rec);
655: --- If any errors happen abort API
656: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
657: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
658: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
659: RAISE Okl_Api.G_EXCEPTION_ERROR;
660: END IF;

Line 657: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

653: --- Validate all non-missing attributes (Item Level Validation)
654: l_return_status := Validate_Attributes(l_sstv_rec);
655: --- If any errors happen abort API
656: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
657: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
658: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
659: RAISE Okl_Api.G_EXCEPTION_ERROR;
660: END IF;
661: l_return_status := Validate_Record(l_sstv_rec);

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

654: l_return_status := Validate_Attributes(l_sstv_rec);
655: --- If any errors happen abort API
656: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
657: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
658: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
659: RAISE Okl_Api.G_EXCEPTION_ERROR;
660: END IF;
661: l_return_status := Validate_Record(l_sstv_rec);
662: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

Line 659: RAISE Okl_Api.G_EXCEPTION_ERROR;

655: --- If any errors happen abort API
656: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
657: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
658: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
659: RAISE Okl_Api.G_EXCEPTION_ERROR;
660: END IF;
661: l_return_status := Validate_Record(l_sstv_rec);
662: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
663: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

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

658: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
659: RAISE Okl_Api.G_EXCEPTION_ERROR;
660: END IF;
661: l_return_status := Validate_Record(l_sstv_rec);
662: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
663: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
664: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
665: RAISE Okl_Api.G_EXCEPTION_ERROR;
666: END IF;

Line 663: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

659: RAISE Okl_Api.G_EXCEPTION_ERROR;
660: END IF;
661: l_return_status := Validate_Record(l_sstv_rec);
662: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
663: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
664: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
665: RAISE Okl_Api.G_EXCEPTION_ERROR;
666: END IF;
667: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);

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

660: END IF;
661: l_return_status := Validate_Record(l_sstv_rec);
662: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
663: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
664: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
665: RAISE Okl_Api.G_EXCEPTION_ERROR;
666: END IF;
667: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
668: EXCEPTION

Line 665: RAISE Okl_Api.G_EXCEPTION_ERROR;

661: l_return_status := Validate_Record(l_sstv_rec);
662: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
663: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
664: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
665: RAISE Okl_Api.G_EXCEPTION_ERROR;
666: END IF;
667: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
668: EXCEPTION
669: WHEN Okl_Api.G_EXCEPTION_ERROR THEN

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

663: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
664: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
665: RAISE Okl_Api.G_EXCEPTION_ERROR;
666: END IF;
667: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
668: EXCEPTION
669: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
670: x_return_status := Okl_Api.HANDLE_EXCEPTIONS
671: (

Line 669: WHEN Okl_Api.G_EXCEPTION_ERROR THEN

665: RAISE Okl_Api.G_EXCEPTION_ERROR;
666: END IF;
667: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
668: EXCEPTION
669: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
670: x_return_status := Okl_Api.HANDLE_EXCEPTIONS
671: (
672: l_api_name,
673: G_PKG_NAME,

Line 670: x_return_status := Okl_Api.HANDLE_EXCEPTIONS

666: END IF;
667: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
668: EXCEPTION
669: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
670: x_return_status := Okl_Api.HANDLE_EXCEPTIONS
671: (
672: l_api_name,
673: G_PKG_NAME,
674: 'Okl_Api.G_RET_STS_ERROR',

Line 674: 'Okl_Api.G_RET_STS_ERROR',

670: x_return_status := Okl_Api.HANDLE_EXCEPTIONS
671: (
672: l_api_name,
673: G_PKG_NAME,
674: 'Okl_Api.G_RET_STS_ERROR',
675: x_msg_count,
676: x_msg_data,
677: '_PVT'
678: );

Line 679: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

675: x_msg_count,
676: x_msg_data,
677: '_PVT'
678: );
679: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
680: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS
681: (
682: l_api_name,
683: G_PKG_NAME,

Line 680: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS

676: x_msg_data,
677: '_PVT'
678: );
679: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
680: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS
681: (
682: l_api_name,
683: G_PKG_NAME,
684: 'Okl_Api.G_RET_STS_UNEXP_ERROR',

Line 684: 'Okl_Api.G_RET_STS_UNEXP_ERROR',

680: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS
681: (
682: l_api_name,
683: G_PKG_NAME,
684: 'Okl_Api.G_RET_STS_UNEXP_ERROR',
685: x_msg_count,
686: x_msg_data,
687: '_PVT'
688: );

Line 690: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS

686: x_msg_data,
687: '_PVT'
688: );
689: WHEN OTHERS THEN
690: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS
691: (
692: l_api_name,
693: G_PKG_NAME,
694: 'OTHERS',

Line 705: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

701: -- PL/SQL TBL validate_row for:SSTV_TBL --
702: ------------------------------------------
703: PROCEDURE validate_row(
704: p_api_version IN NUMBER,
705: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
706: x_return_status OUT NOCOPY VARCHAR2,
707: x_msg_count OUT NOCOPY NUMBER,
708: x_msg_data OUT NOCOPY VARCHAR2,
709: p_sstv_tbl IN sstv_tbl_type) IS

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

709: p_sstv_tbl IN sstv_tbl_type) IS
710:
711: l_api_version CONSTANT NUMBER := 1;
712: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_validate_row';
713: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
714: i NUMBER := 0;
715: -- Begin Post-Generation Change
716: -- overall error status
717: l_overall_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

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

713: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
714: i NUMBER := 0;
715: -- Begin Post-Generation Change
716: -- overall error status
717: l_overall_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
718: -- End Post-Generation Change
719: BEGIN
720: Okl_Api.init_msg_list(p_init_msg_list);
721: -- Make sure PL/SQL table has records in it before passing

Line 720: Okl_Api.init_msg_list(p_init_msg_list);

716: -- overall error status
717: l_overall_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
718: -- End Post-Generation Change
719: BEGIN
720: Okl_Api.init_msg_list(p_init_msg_list);
721: -- Make sure PL/SQL table has records in it before passing
722: IF (p_sstv_tbl.COUNT > 0) THEN
723: i := p_sstv_tbl.FIRST;
724: LOOP

Line 727: p_init_msg_list => Okl_Api.G_FALSE,

723: i := p_sstv_tbl.FIRST;
724: LOOP
725: validate_row (
726: p_api_version => p_api_version,
727: p_init_msg_list => Okl_Api.G_FALSE,
728: x_return_status => x_return_status,
729: x_msg_count => x_msg_count,
730: x_msg_data => x_msg_data,
731: p_sstv_rec => p_sstv_tbl(i));

Line 735: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN

731: p_sstv_rec => p_sstv_tbl(i));
732:
733: -- Begin Post-Generation Change
734: -- store the highest degree of error
735: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
736: IF l_overall_status <> Okl_Api.G_RET_STS_UNEXP_ERROR THEN
737: l_overall_status := x_return_status;
738: END IF;
739: END IF;

Line 736: IF l_overall_status <> Okl_Api.G_RET_STS_UNEXP_ERROR THEN

732:
733: -- Begin Post-Generation Change
734: -- store the highest degree of error
735: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
736: IF l_overall_status <> Okl_Api.G_RET_STS_UNEXP_ERROR THEN
737: l_overall_status := x_return_status;
738: END IF;
739: END IF;
740: -- End Post-Generation Change

Line 753: WHEN Okl_Api.G_EXCEPTION_ERROR THEN

749: -- End Post-Generation Change
750:
751: END IF;
752: EXCEPTION
753: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
754: x_return_status := Okl_Api.HANDLE_EXCEPTIONS
755: (
756: l_api_name,
757: G_PKG_NAME,

Line 754: x_return_status := Okl_Api.HANDLE_EXCEPTIONS

750:
751: END IF;
752: EXCEPTION
753: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
754: x_return_status := Okl_Api.HANDLE_EXCEPTIONS
755: (
756: l_api_name,
757: G_PKG_NAME,
758: 'Okl_Api.G_RET_STS_ERROR',

Line 758: 'Okl_Api.G_RET_STS_ERROR',

754: x_return_status := Okl_Api.HANDLE_EXCEPTIONS
755: (
756: l_api_name,
757: G_PKG_NAME,
758: 'Okl_Api.G_RET_STS_ERROR',
759: x_msg_count,
760: x_msg_data,
761: '_PVT'
762: );

Line 763: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

759: x_msg_count,
760: x_msg_data,
761: '_PVT'
762: );
763: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
764: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS
765: (
766: l_api_name,
767: G_PKG_NAME,

Line 764: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS

760: x_msg_data,
761: '_PVT'
762: );
763: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
764: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS
765: (
766: l_api_name,
767: G_PKG_NAME,
768: 'Okl_Api.G_RET_STS_UNEXP_ERROR',

Line 768: 'Okl_Api.G_RET_STS_UNEXP_ERROR',

764: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS
765: (
766: l_api_name,
767: G_PKG_NAME,
768: 'Okl_Api.G_RET_STS_UNEXP_ERROR',
769: x_msg_count,
770: x_msg_data,
771: '_PVT'
772: );

Line 774: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS

770: x_msg_data,
771: '_PVT'
772: );
773: WHEN OTHERS THEN
774: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS
775: (
776: l_api_name,
777: G_PKG_NAME,
778: 'OTHERS',

Line 793: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

789: -- insert_row for:OKL_SRCH_STRM_TYPS_H --
790: -----------------------------------------
791: /* -- history tables not supported -- 04 APR 2002
792: PROCEDURE insert_row(
793: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
794: x_return_status OUT NOCOPY VARCHAR2,
795: x_msg_count OUT NOCOPY NUMBER,
796: x_msg_data OUT NOCOPY VARCHAR2,
797: p_okl_srch_strm_typs_h_rec IN okl_srch_strm_typs_h_rec_type,

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

798: x_okl_srch_strm_typs_h_rec OUT NOCOPY okl_srch_strm_typs_h_rec_type) IS
799:
800: l_api_version CONSTANT NUMBER := 1;
801: l_api_name CONSTANT VARCHAR2(30) := 'H_insert_row';
802: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
803: l_okl_srch_strm_typs_h_rec okl_srch_strm_typs_h_rec_type := p_okl_srch_strm_typs_h_rec;
804: ldefoklsrchstrmtypshrec okl_srch_strm_typs_h_rec_type;
805: ---------------------------------------------
806: -- Set_Attributes for:OKL_SRCH_STRM_TYPS_H --

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

808: FUNCTION Set_Attributes (
809: p_okl_srch_strm_typs_h_rec IN okl_srch_strm_typs_h_rec_type,
810: x_okl_srch_strm_typs_h_rec OUT NOCOPY okl_srch_strm_typs_h_rec_type
811: ) RETURN VARCHAR2 IS
812: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
813: BEGIN
814: x_okl_srch_strm_typs_h_rec := p_okl_srch_strm_typs_h_rec;
815: RETURN(l_return_status);
816: END Set_Attributes;

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

814: x_okl_srch_strm_typs_h_rec := p_okl_srch_strm_typs_h_rec;
815: RETURN(l_return_status);
816: END Set_Attributes;
817: BEGIN
818: l_return_status := Okl_Api.START_ACTIVITY(l_api_name,
819: p_init_msg_list,
820: '_PVT',
821: x_return_status);
822: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

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

818: l_return_status := Okl_Api.START_ACTIVITY(l_api_name,
819: p_init_msg_list,
820: '_PVT',
821: x_return_status);
822: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
823: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
824: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
825: RAISE Okl_Api.G_EXCEPTION_ERROR;
826: END IF;

Line 823: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

819: p_init_msg_list,
820: '_PVT',
821: x_return_status);
822: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
823: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
824: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
825: RAISE Okl_Api.G_EXCEPTION_ERROR;
826: END IF;
827: --- Setting item attributes

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

820: '_PVT',
821: x_return_status);
822: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
823: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
824: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
825: RAISE Okl_Api.G_EXCEPTION_ERROR;
826: END IF;
827: --- Setting item attributes
828: l_return_status := Set_Attributes(

Line 825: RAISE Okl_Api.G_EXCEPTION_ERROR;

821: x_return_status);
822: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
823: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
824: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
825: RAISE Okl_Api.G_EXCEPTION_ERROR;
826: END IF;
827: --- Setting item attributes
828: l_return_status := Set_Attributes(
829: p_okl_srch_strm_typs_h_rec, -- IN

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

828: l_return_status := Set_Attributes(
829: p_okl_srch_strm_typs_h_rec, -- IN
830: l_okl_srch_strm_typs_h_rec); -- OUT
831: --- If any errors happen abort API
832: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
833: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
834: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
835: RAISE Okl_Api.G_EXCEPTION_ERROR;
836: END IF;

Line 833: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

829: p_okl_srch_strm_typs_h_rec, -- IN
830: l_okl_srch_strm_typs_h_rec); -- OUT
831: --- If any errors happen abort API
832: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
833: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
834: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
835: RAISE Okl_Api.G_EXCEPTION_ERROR;
836: END IF;
837: INSERT INTO OKL_SRCH_STRM_TYPS_H(

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

830: l_okl_srch_strm_typs_h_rec); -- OUT
831: --- If any errors happen abort API
832: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
833: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
834: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
835: RAISE Okl_Api.G_EXCEPTION_ERROR;
836: END IF;
837: INSERT INTO OKL_SRCH_STRM_TYPS_H(
838: id,

Line 835: RAISE Okl_Api.G_EXCEPTION_ERROR;

831: --- If any errors happen abort API
832: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
833: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
834: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
835: RAISE Okl_Api.G_EXCEPTION_ERROR;
836: END IF;
837: INSERT INTO OKL_SRCH_STRM_TYPS_H(
838: id,
839: major_version,

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

891: l_okl_srch_strm_typs_h_rec.last_update_date,
892: l_okl_srch_strm_typs_h_rec.last_update_login);
893: -- Set OUT values
894: x_okl_srch_strm_typs_h_rec := l_okl_srch_strm_typs_h_rec;
895: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
896: EXCEPTION
897: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
898: x_return_status := Okl_Api.HANDLE_EXCEPTIONS
899: (

Line 897: WHEN Okl_Api.G_EXCEPTION_ERROR THEN

893: -- Set OUT values
894: x_okl_srch_strm_typs_h_rec := l_okl_srch_strm_typs_h_rec;
895: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
896: EXCEPTION
897: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
898: x_return_status := Okl_Api.HANDLE_EXCEPTIONS
899: (
900: l_api_name,
901: G_PKG_NAME,

Line 898: x_return_status := Okl_Api.HANDLE_EXCEPTIONS

894: x_okl_srch_strm_typs_h_rec := l_okl_srch_strm_typs_h_rec;
895: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
896: EXCEPTION
897: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
898: x_return_status := Okl_Api.HANDLE_EXCEPTIONS
899: (
900: l_api_name,
901: G_PKG_NAME,
902: 'Okl_Api.G_RET_STS_ERROR',

Line 902: 'Okl_Api.G_RET_STS_ERROR',

898: x_return_status := Okl_Api.HANDLE_EXCEPTIONS
899: (
900: l_api_name,
901: G_PKG_NAME,
902: 'Okl_Api.G_RET_STS_ERROR',
903: x_msg_count,
904: x_msg_data,
905: '_PVT'
906: );

Line 907: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

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

Line 908: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS

904: x_msg_data,
905: '_PVT'
906: );
907: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
908: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS
909: (
910: l_api_name,
911: G_PKG_NAME,
912: 'Okl_Api.G_RET_STS_UNEXP_ERROR',

Line 912: 'Okl_Api.G_RET_STS_UNEXP_ERROR',

908: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS
909: (
910: l_api_name,
911: G_PKG_NAME,
912: 'Okl_Api.G_RET_STS_UNEXP_ERROR',
913: x_msg_count,
914: x_msg_data,
915: '_PVT'
916: );

Line 918: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS

914: x_msg_data,
915: '_PVT'
916: );
917: WHEN OTHERS THEN
918: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS
919: (
920: l_api_name,
921: G_PKG_NAME,
922: 'OTHERS',

Line 934: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

930: ---------------------------------------
931: -- insert_row for:OKL_SRCH_STRM_TYPS --
932: ---------------------------------------
933: PROCEDURE insert_row(
934: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
935: x_return_status OUT NOCOPY VARCHAR2,
936: x_msg_count OUT NOCOPY NUMBER,
937: x_msg_data OUT NOCOPY VARCHAR2,
938: p_sst_rec IN sst_rec_type,

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

939: x_sst_rec OUT NOCOPY sst_rec_type) IS
940:
941: l_api_version CONSTANT NUMBER := 1;
942: l_api_name CONSTANT VARCHAR2(30) := 'TYPS_insert_row';
943: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
944: l_sst_rec sst_rec_type := p_sst_rec;
945: l_def_sst_rec sst_rec_type;
946: -------------------------------------------
947: -- Set_Attributes for:OKL_SRCH_STRM_TYPS --

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

949: FUNCTION Set_Attributes (
950: p_sst_rec IN sst_rec_type,
951: x_sst_rec OUT NOCOPY sst_rec_type
952: ) RETURN VARCHAR2 IS
953: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
954: BEGIN
955: x_sst_rec := p_sst_rec;
956: RETURN(l_return_status);
957: END Set_Attributes;

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

955: x_sst_rec := p_sst_rec;
956: RETURN(l_return_status);
957: END Set_Attributes;
958: BEGIN
959: l_return_status := Okl_Api.START_ACTIVITY(l_api_name,
960: p_init_msg_list,
961: '_PVT',
962: x_return_status);
963: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

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

959: l_return_status := Okl_Api.START_ACTIVITY(l_api_name,
960: p_init_msg_list,
961: '_PVT',
962: x_return_status);
963: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
964: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
965: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
966: RAISE Okl_Api.G_EXCEPTION_ERROR;
967: END IF;

Line 964: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

960: p_init_msg_list,
961: '_PVT',
962: x_return_status);
963: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
964: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
965: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
966: RAISE Okl_Api.G_EXCEPTION_ERROR;
967: END IF;
968: --- Setting item attributes

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

961: '_PVT',
962: x_return_status);
963: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
964: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
965: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
966: RAISE Okl_Api.G_EXCEPTION_ERROR;
967: END IF;
968: --- Setting item attributes
969: l_return_status := Set_Attributes(

Line 966: RAISE Okl_Api.G_EXCEPTION_ERROR;

962: x_return_status);
963: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
964: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
965: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
966: RAISE Okl_Api.G_EXCEPTION_ERROR;
967: END IF;
968: --- Setting item attributes
969: l_return_status := Set_Attributes(
970: p_sst_rec, -- IN

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

969: l_return_status := Set_Attributes(
970: p_sst_rec, -- IN
971: l_sst_rec); -- OUT
972: --- If any errors happen abort API
973: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
974: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
975: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
976: RAISE Okl_Api.G_EXCEPTION_ERROR;
977: END IF;

Line 974: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

970: p_sst_rec, -- IN
971: l_sst_rec); -- OUT
972: --- If any errors happen abort API
973: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
974: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
975: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
976: RAISE Okl_Api.G_EXCEPTION_ERROR;
977: END IF;
978: INSERT INTO OKL_SRCH_STRM_TYPS(

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

971: l_sst_rec); -- OUT
972: --- If any errors happen abort API
973: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
974: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
975: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
976: RAISE Okl_Api.G_EXCEPTION_ERROR;
977: END IF;
978: INSERT INTO OKL_SRCH_STRM_TYPS(
979: id,

Line 976: RAISE Okl_Api.G_EXCEPTION_ERROR;

972: --- If any errors happen abort API
973: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
974: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
975: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
976: RAISE Okl_Api.G_EXCEPTION_ERROR;
977: END IF;
978: INSERT INTO OKL_SRCH_STRM_TYPS(
979: id,
980: sty_id,

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

1030: l_sst_rec.last_update_date,
1031: l_sst_rec.last_update_login);
1032: -- Set OUT values
1033: x_sst_rec := l_sst_rec;
1034: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1035: EXCEPTION
1036: WHEN okl_api.G_EXCEPTION_ERROR THEN
1037: x_return_status := 'E';
1038: NULL;

Line 1036: WHEN okl_api.G_EXCEPTION_ERROR THEN

1032: -- Set OUT values
1033: x_sst_rec := l_sst_rec;
1034: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1035: EXCEPTION
1036: WHEN okl_api.G_EXCEPTION_ERROR THEN
1037: x_return_status := 'E';
1038: NULL;
1039: /*
1040: x_return_status := okl_api.HANDLE_EXCEPTIONS

Line 1040: x_return_status := okl_api.HANDLE_EXCEPTIONS

1036: WHEN okl_api.G_EXCEPTION_ERROR THEN
1037: x_return_status := 'E';
1038: NULL;
1039: /*
1040: x_return_status := okl_api.HANDLE_EXCEPTIONS
1041: (
1042: l_api_name,
1043: G_PKG_NAME,
1044: 'okl_api.G_RET_STS_ERROR',

Line 1044: 'okl_api.G_RET_STS_ERROR',

1040: x_return_status := okl_api.HANDLE_EXCEPTIONS
1041: (
1042: l_api_name,
1043: G_PKG_NAME,
1044: 'okl_api.G_RET_STS_ERROR',
1045: x_msg_count,
1046: x_msg_data,
1047: '_PVT'
1048: );

Line 1050: WHEN okl_api.G_EXCEPTION_UNEXPECTED_ERROR THEN

1046: x_msg_data,
1047: '_PVT'
1048: );
1049: */
1050: WHEN okl_api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1051: x_return_status := 'U';
1052: NULL;
1053: /*
1054: x_return_status :=okl_api.HANDLE_EXCEPTIONS

Line 1054: x_return_status :=okl_api.HANDLE_EXCEPTIONS

1050: WHEN okl_api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1051: x_return_status := 'U';
1052: NULL;
1053: /*
1054: x_return_status :=okl_api.HANDLE_EXCEPTIONS
1055: (
1056: l_api_name,
1057: G_PKG_NAME,
1058: 'okl_api.G_RET_STS_UNEXP_ERROR',

Line 1058: 'okl_api.G_RET_STS_UNEXP_ERROR',

1054: x_return_status :=okl_api.HANDLE_EXCEPTIONS
1055: (
1056: l_api_name,
1057: G_PKG_NAME,
1058: 'okl_api.G_RET_STS_UNEXP_ERROR',
1059: x_msg_count,
1060: x_msg_data,
1061: '_PVT'
1062: );

Line 1068: x_return_status :=okl_api.HANDLE_EXCEPTIONS

1064: WHEN OTHERS THEN
1065: x_return_status := 'U';
1066: NULL;
1067: /*
1068: x_return_status :=okl_api.HANDLE_EXCEPTIONS
1069: (
1070: l_api_name,
1071: G_PKG_NAME,
1072: 'OTHERS',

Line 1084: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

1080: -- insert_row for:OKL_SRCH_STRM_TYPS_V --
1081: -----------------------------------------
1082: PROCEDURE insert_row(
1083: p_api_version IN NUMBER,
1084: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
1085: x_return_status OUT NOCOPY VARCHAR2,
1086: x_msg_count OUT NOCOPY NUMBER,
1087: x_msg_data OUT NOCOPY VARCHAR2,
1088: p_sstv_rec IN sstv_rec_type,

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

1089: x_sstv_rec OUT NOCOPY sstv_rec_type) IS
1090:
1091: l_api_version CONSTANT NUMBER := 1;
1092: l_api_name CONSTANT VARCHAR2(30) := 'V_insert_row';
1093: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1094: l_sstv_rec sstv_rec_type;
1095: l_def_sstv_rec sstv_rec_type;
1096: l_sst_rec sst_rec_type;
1097: lx_sst_rec sst_rec_type;

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

1116: FUNCTION Set_Attributes (
1117: p_sstv_rec IN sstv_rec_type,
1118: x_sstv_rec OUT NOCOPY sstv_rec_type
1119: ) RETURN VARCHAR2 IS
1120: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1121: BEGIN
1122: x_sstv_rec := p_sstv_rec;
1123: x_sstv_rec.OBJECT_VERSION_NUMBER := 1;
1124: RETURN(l_return_status);

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

1123: x_sstv_rec.OBJECT_VERSION_NUMBER := 1;
1124: RETURN(l_return_status);
1125: END Set_Attributes;
1126: BEGIN
1127: l_return_status := Okl_Api.START_ACTIVITY(l_api_name,
1128: G_PKG_NAME,
1129: p_init_msg_list,
1130: l_api_version,
1131: p_api_version,

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

1130: l_api_version,
1131: p_api_version,
1132: '_PVT',
1133: x_return_status);
1134: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1135: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1136: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1137: RAISE Okl_Api.G_EXCEPTION_ERROR;
1138: END IF;

Line 1135: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1131: p_api_version,
1132: '_PVT',
1133: x_return_status);
1134: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1135: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1136: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1137: RAISE Okl_Api.G_EXCEPTION_ERROR;
1138: END IF;
1139: l_sstv_rec := null_out_defaults(p_sstv_rec);

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

1132: '_PVT',
1133: x_return_status);
1134: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1135: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1136: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1137: RAISE Okl_Api.G_EXCEPTION_ERROR;
1138: END IF;
1139: l_sstv_rec := null_out_defaults(p_sstv_rec);
1140: -- Set primary key value

Line 1137: RAISE Okl_Api.G_EXCEPTION_ERROR;

1133: x_return_status);
1134: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1135: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1136: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1137: RAISE Okl_Api.G_EXCEPTION_ERROR;
1138: END IF;
1139: l_sstv_rec := null_out_defaults(p_sstv_rec);
1140: -- Set primary key value
1141: l_sstv_rec.ID := get_seq_id;

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

1143: l_return_status := Set_Attributes(
1144: l_sstv_rec, -- IN
1145: l_def_sstv_rec); -- OUT
1146: --- If any errors happen abort API
1147: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1148: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1149: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1150: RAISE Okl_Api.G_EXCEPTION_ERROR;
1151: END IF;

Line 1148: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1144: l_sstv_rec, -- IN
1145: l_def_sstv_rec); -- OUT
1146: --- If any errors happen abort API
1147: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1148: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1149: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1150: RAISE Okl_Api.G_EXCEPTION_ERROR;
1151: END IF;
1152: l_def_sstv_rec := fill_who_columns(l_def_sstv_rec);

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

1145: l_def_sstv_rec); -- OUT
1146: --- If any errors happen abort API
1147: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1148: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1149: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1150: RAISE Okl_Api.G_EXCEPTION_ERROR;
1151: END IF;
1152: l_def_sstv_rec := fill_who_columns(l_def_sstv_rec);
1153: --- Validate all non-missing attributes (Item Level Validation)

Line 1150: RAISE Okl_Api.G_EXCEPTION_ERROR;

1146: --- If any errors happen abort API
1147: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1148: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1149: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1150: RAISE Okl_Api.G_EXCEPTION_ERROR;
1151: END IF;
1152: l_def_sstv_rec := fill_who_columns(l_def_sstv_rec);
1153: --- Validate all non-missing attributes (Item Level Validation)
1154: l_return_status := Validate_Attributes(l_def_sstv_rec);

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

1152: l_def_sstv_rec := fill_who_columns(l_def_sstv_rec);
1153: --- Validate all non-missing attributes (Item Level Validation)
1154: l_return_status := Validate_Attributes(l_def_sstv_rec);
1155: --- If any errors happen abort API
1156: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1157: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1158: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1159: RAISE Okl_Api.G_EXCEPTION_ERROR;
1160: END IF;

Line 1157: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1153: --- Validate all non-missing attributes (Item Level Validation)
1154: l_return_status := Validate_Attributes(l_def_sstv_rec);
1155: --- If any errors happen abort API
1156: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1157: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1158: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1159: RAISE Okl_Api.G_EXCEPTION_ERROR;
1160: END IF;
1161: l_return_status := Validate_Record(l_def_sstv_rec);

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

1154: l_return_status := Validate_Attributes(l_def_sstv_rec);
1155: --- If any errors happen abort API
1156: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1157: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1158: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1159: RAISE Okl_Api.G_EXCEPTION_ERROR;
1160: END IF;
1161: l_return_status := Validate_Record(l_def_sstv_rec);
1162: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

Line 1159: RAISE Okl_Api.G_EXCEPTION_ERROR;

1155: --- If any errors happen abort API
1156: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1157: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1158: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1159: RAISE Okl_Api.G_EXCEPTION_ERROR;
1160: END IF;
1161: l_return_status := Validate_Record(l_def_sstv_rec);
1162: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1163: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

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

1158: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1159: RAISE Okl_Api.G_EXCEPTION_ERROR;
1160: END IF;
1161: l_return_status := Validate_Record(l_def_sstv_rec);
1162: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1163: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1164: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1165: RAISE Okl_Api.G_EXCEPTION_ERROR;
1166: END IF;

Line 1163: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1159: RAISE Okl_Api.G_EXCEPTION_ERROR;
1160: END IF;
1161: l_return_status := Validate_Record(l_def_sstv_rec);
1162: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1163: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1164: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1165: RAISE Okl_Api.G_EXCEPTION_ERROR;
1166: END IF;
1167: --------------------------------------

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

1160: END IF;
1161: l_return_status := Validate_Record(l_def_sstv_rec);
1162: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1163: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1164: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1165: RAISE Okl_Api.G_EXCEPTION_ERROR;
1166: END IF;
1167: --------------------------------------
1168: -- Move VIEW record to "Child" records

Line 1165: RAISE Okl_Api.G_EXCEPTION_ERROR;

1161: l_return_status := Validate_Record(l_def_sstv_rec);
1162: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1163: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1164: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1165: RAISE Okl_Api.G_EXCEPTION_ERROR;
1166: END IF;
1167: --------------------------------------
1168: -- Move VIEW record to "Child" records
1169: --------------------------------------

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

1178: x_msg_data,
1179: l_sst_rec,
1180: lx_sst_rec
1181: );
1182: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1183: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1184: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1185: RAISE Okl_Api.G_EXCEPTION_ERROR;
1186: END IF;

Line 1183: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1179: l_sst_rec,
1180: lx_sst_rec
1181: );
1182: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1183: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1184: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1185: RAISE Okl_Api.G_EXCEPTION_ERROR;
1186: END IF;
1187: migrate(lx_sst_rec, l_def_sstv_rec);

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

1180: lx_sst_rec
1181: );
1182: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1183: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1184: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1185: RAISE Okl_Api.G_EXCEPTION_ERROR;
1186: END IF;
1187: migrate(lx_sst_rec, l_def_sstv_rec);
1188: -- Set OUT values

Line 1185: RAISE Okl_Api.G_EXCEPTION_ERROR;

1181: );
1182: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1183: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1184: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1185: RAISE Okl_Api.G_EXCEPTION_ERROR;
1186: END IF;
1187: migrate(lx_sst_rec, l_def_sstv_rec);
1188: -- Set OUT values
1189: x_sstv_rec := l_def_sstv_rec;

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

1186: END IF;
1187: migrate(lx_sst_rec, l_def_sstv_rec);
1188: -- Set OUT values
1189: x_sstv_rec := l_def_sstv_rec;
1190: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1191: EXCEPTION
1192: WHEN okl_api.G_EXCEPTION_ERROR THEN
1193: x_return_status := 'E';
1194: NULL;

Line 1192: WHEN okl_api.G_EXCEPTION_ERROR THEN

1188: -- Set OUT values
1189: x_sstv_rec := l_def_sstv_rec;
1190: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1191: EXCEPTION
1192: WHEN okl_api.G_EXCEPTION_ERROR THEN
1193: x_return_status := 'E';
1194: NULL;
1195: /*
1196: x_return_status := okl_api.HANDLE_EXCEPTIONS

Line 1196: x_return_status := okl_api.HANDLE_EXCEPTIONS

1192: WHEN okl_api.G_EXCEPTION_ERROR THEN
1193: x_return_status := 'E';
1194: NULL;
1195: /*
1196: x_return_status := okl_api.HANDLE_EXCEPTIONS
1197: (
1198: l_api_name,
1199: G_PKG_NAME,
1200: 'okl_api.G_RET_STS_ERROR',

Line 1200: 'okl_api.G_RET_STS_ERROR',

1196: x_return_status := okl_api.HANDLE_EXCEPTIONS
1197: (
1198: l_api_name,
1199: G_PKG_NAME,
1200: 'okl_api.G_RET_STS_ERROR',
1201: x_msg_count,
1202: x_msg_data,
1203: '_PVT'
1204: );

Line 1206: WHEN okl_api.G_EXCEPTION_UNEXPECTED_ERROR THEN

1202: x_msg_data,
1203: '_PVT'
1204: );
1205: */
1206: WHEN okl_api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1207: x_return_status := 'U';
1208: NULL;
1209: /*
1210: x_return_status :=okl_api.HANDLE_EXCEPTIONS

Line 1210: x_return_status :=okl_api.HANDLE_EXCEPTIONS

1206: WHEN okl_api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1207: x_return_status := 'U';
1208: NULL;
1209: /*
1210: x_return_status :=okl_api.HANDLE_EXCEPTIONS
1211: (
1212: l_api_name,
1213: G_PKG_NAME,
1214: 'okl_api.G_RET_STS_UNEXP_ERROR',

Line 1214: 'okl_api.G_RET_STS_UNEXP_ERROR',

1210: x_return_status :=okl_api.HANDLE_EXCEPTIONS
1211: (
1212: l_api_name,
1213: G_PKG_NAME,
1214: 'okl_api.G_RET_STS_UNEXP_ERROR',
1215: x_msg_count,
1216: x_msg_data,
1217: '_PVT'
1218: );

Line 1224: x_return_status :=okl_api.HANDLE_EXCEPTIONS

1220: WHEN OTHERS THEN
1221: x_return_status := 'U';
1222: NULL;
1223: /*
1224: x_return_status :=okl_api.HANDLE_EXCEPTIONS
1225: (
1226: l_api_name,
1227: G_PKG_NAME,
1228: 'OTHERS',

Line 1240: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

1236: -- PL/SQL TBL insert_row for:SSTV_TBL --
1237: ----------------------------------------
1238: PROCEDURE insert_row(
1239: p_api_version IN NUMBER,
1240: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
1241: x_return_status OUT NOCOPY VARCHAR2,
1242: x_msg_count OUT NOCOPY NUMBER,
1243: x_msg_data OUT NOCOPY VARCHAR2,
1244: p_sstv_tbl IN sstv_tbl_type,

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

1245: x_sstv_tbl OUT NOCOPY sstv_tbl_type) IS
1246:
1247: l_api_version CONSTANT NUMBER := 1;
1248: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_insert_row';
1249: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1250: i NUMBER := 0;
1251: -- Begin Post-Generation Change
1252: -- overall error status
1253: l_overall_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

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

1249: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1250: i NUMBER := 0;
1251: -- Begin Post-Generation Change
1252: -- overall error status
1253: l_overall_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1254: -- End Post-Generation Change
1255:
1256: BEGIN
1257: Okl_Api.init_msg_list(p_init_msg_list);

Line 1257: Okl_Api.init_msg_list(p_init_msg_list);

1253: l_overall_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1254: -- End Post-Generation Change
1255:
1256: BEGIN
1257: Okl_Api.init_msg_list(p_init_msg_list);
1258: -- Make sure PL/SQL table has records in it before passing
1259: IF (p_sstv_tbl.COUNT > 0) THEN
1260: i := p_sstv_tbl.FIRST;
1261: LOOP

Line 1264: p_init_msg_list => Okl_Api.G_FALSE,

1260: i := p_sstv_tbl.FIRST;
1261: LOOP
1262: insert_row (
1263: p_api_version => p_api_version,
1264: p_init_msg_list => Okl_Api.G_FALSE,
1265: x_return_status => x_return_status,
1266: x_msg_count => x_msg_count,
1267: x_msg_data => x_msg_data,
1268: p_sstv_rec => p_sstv_tbl(i),

Line 1273: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN

1269: x_sstv_rec => x_sstv_tbl(i));
1270:
1271: -- Begin Post-Generation Change
1272: -- store the highest degree of error
1273: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
1274: IF l_overall_status <> Okl_Api.G_RET_STS_UNEXP_ERROR THEN
1275: l_overall_status := x_return_status;
1276: END IF;
1277: END IF;

Line 1274: IF l_overall_status <> Okl_Api.G_RET_STS_UNEXP_ERROR THEN

1270:
1271: -- Begin Post-Generation Change
1272: -- store the highest degree of error
1273: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
1274: IF l_overall_status <> Okl_Api.G_RET_STS_UNEXP_ERROR THEN
1275: l_overall_status := x_return_status;
1276: END IF;
1277: END IF;
1278: -- End Post-Generation Change

Line 1291: WHEN Okl_Api.G_EXCEPTION_ERROR THEN

1287: -- End Post-Generation Change
1288:
1289: END IF;
1290: EXCEPTION
1291: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
1292: x_return_status := Okl_Api.HANDLE_EXCEPTIONS
1293: (
1294: l_api_name,
1295: G_PKG_NAME,

Line 1292: x_return_status := Okl_Api.HANDLE_EXCEPTIONS

1288:
1289: END IF;
1290: EXCEPTION
1291: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
1292: x_return_status := Okl_Api.HANDLE_EXCEPTIONS
1293: (
1294: l_api_name,
1295: G_PKG_NAME,
1296: 'Okl_Api.G_RET_STS_ERROR',

Line 1296: 'Okl_Api.G_RET_STS_ERROR',

1292: x_return_status := Okl_Api.HANDLE_EXCEPTIONS
1293: (
1294: l_api_name,
1295: G_PKG_NAME,
1296: 'Okl_Api.G_RET_STS_ERROR',
1297: x_msg_count,
1298: x_msg_data,
1299: '_PVT'
1300: );

Line 1301: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

1297: x_msg_count,
1298: x_msg_data,
1299: '_PVT'
1300: );
1301: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1302: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS
1303: (
1304: l_api_name,
1305: G_PKG_NAME,

Line 1302: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS

1298: x_msg_data,
1299: '_PVT'
1300: );
1301: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1302: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS
1303: (
1304: l_api_name,
1305: G_PKG_NAME,
1306: 'Okl_Api.G_RET_STS_UNEXP_ERROR',

Line 1306: 'Okl_Api.G_RET_STS_UNEXP_ERROR',

1302: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS
1303: (
1304: l_api_name,
1305: G_PKG_NAME,
1306: 'Okl_Api.G_RET_STS_UNEXP_ERROR',
1307: x_msg_count,
1308: x_msg_data,
1309: '_PVT'
1310: );

Line 1312: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS

1308: x_msg_data,
1309: '_PVT'
1310: );
1311: WHEN OTHERS THEN
1312: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS
1313: (
1314: l_api_name,
1315: G_PKG_NAME,
1316: 'OTHERS',

Line 1330: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

1326: -------------------------------------
1327: -- lock_row for:OKL_SRCH_STRM_TYPS --
1328: -------------------------------------
1329: PROCEDURE lock_row(
1330: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
1331: x_return_status OUT NOCOPY VARCHAR2,
1332: x_msg_count OUT NOCOPY NUMBER,
1333: x_msg_data OUT NOCOPY VARCHAR2,
1334: p_sst_rec IN sst_rec_type) IS

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

1347: FROM OKL_SRCH_STRM_TYPS
1348: WHERE ID = p_sst_rec.id;
1349: l_api_version CONSTANT NUMBER := 1;
1350: l_api_name CONSTANT VARCHAR2(30) := 'TYPS_lock_row';
1351: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1352: l_object_version_number OKL_SRCH_STRM_TYPS.OBJECT_VERSION_NUMBER%TYPE;
1353: lc_object_version_number OKL_SRCH_STRM_TYPS.OBJECT_VERSION_NUMBER%TYPE;
1354: l_row_notfound BOOLEAN := FALSE;
1355: lc_row_notfound BOOLEAN := FALSE;

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

1353: lc_object_version_number OKL_SRCH_STRM_TYPS.OBJECT_VERSION_NUMBER%TYPE;
1354: l_row_notfound BOOLEAN := FALSE;
1355: lc_row_notfound BOOLEAN := FALSE;
1356: BEGIN
1357: l_return_status := Okl_Api.START_ACTIVITY(l_api_name,
1358: p_init_msg_list,
1359: '_PVT',
1360: x_return_status);
1361: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

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

1357: l_return_status := Okl_Api.START_ACTIVITY(l_api_name,
1358: p_init_msg_list,
1359: '_PVT',
1360: x_return_status);
1361: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1362: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1363: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1364: RAISE Okl_Api.G_EXCEPTION_ERROR;
1365: END IF;

Line 1362: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1358: p_init_msg_list,
1359: '_PVT',
1360: x_return_status);
1361: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1362: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1363: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1364: RAISE Okl_Api.G_EXCEPTION_ERROR;
1365: END IF;
1366: BEGIN

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

1359: '_PVT',
1360: x_return_status);
1361: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1362: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1363: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1364: RAISE Okl_Api.G_EXCEPTION_ERROR;
1365: END IF;
1366: BEGIN
1367: OPEN lock_csr(p_sst_rec);

Line 1364: RAISE Okl_Api.G_EXCEPTION_ERROR;

1360: x_return_status);
1361: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1362: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1363: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1364: RAISE Okl_Api.G_EXCEPTION_ERROR;
1365: END IF;
1366: BEGIN
1367: OPEN lock_csr(p_sst_rec);
1368: FETCH lock_csr INTO l_object_version_number;

Line 1376: Okl_Api.set_message(G_FND_APP,G_FORM_UNABLE_TO_RESERVE_REC);

1372: WHEN E_Resource_Busy THEN
1373: IF (lock_csr%ISOPEN) THEN
1374: CLOSE lock_csr;
1375: END IF;
1376: Okl_Api.set_message(G_FND_APP,G_FORM_UNABLE_TO_RESERVE_REC);
1377: RAISE App_Exceptions.RECORD_LOCK_EXCEPTION;
1378: END;
1379:
1380: IF ( l_row_notfound ) THEN

Line 1387: Okl_Api.set_message(G_FND_APP,G_FORM_RECORD_DELETED);

1383: lc_row_notfound := lchk_csr%NOTFOUND;
1384: CLOSE lchk_csr;
1385: END IF;
1386: IF (lc_row_notfound) THEN
1387: Okl_Api.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
1388: RAISE Okl_Api.G_EXCEPTION_ERROR;
1389: ELSIF lc_object_version_number > p_sst_rec.object_version_number THEN
1390: Okl_Api.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1391: RAISE Okl_Api.G_EXCEPTION_ERROR;

Line 1388: RAISE Okl_Api.G_EXCEPTION_ERROR;

1384: CLOSE lchk_csr;
1385: END IF;
1386: IF (lc_row_notfound) THEN
1387: Okl_Api.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
1388: RAISE Okl_Api.G_EXCEPTION_ERROR;
1389: ELSIF lc_object_version_number > p_sst_rec.object_version_number THEN
1390: Okl_Api.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1391: RAISE Okl_Api.G_EXCEPTION_ERROR;
1392: ELSIF lc_object_version_number <> p_sst_rec.object_version_number THEN

Line 1390: Okl_Api.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);

1386: IF (lc_row_notfound) THEN
1387: Okl_Api.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
1388: RAISE Okl_Api.G_EXCEPTION_ERROR;
1389: ELSIF lc_object_version_number > p_sst_rec.object_version_number THEN
1390: Okl_Api.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1391: RAISE Okl_Api.G_EXCEPTION_ERROR;
1392: ELSIF lc_object_version_number <> p_sst_rec.object_version_number THEN
1393: Okl_Api.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1394: RAISE Okl_Api.G_EXCEPTION_ERROR;

Line 1391: RAISE Okl_Api.G_EXCEPTION_ERROR;

1387: Okl_Api.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
1388: RAISE Okl_Api.G_EXCEPTION_ERROR;
1389: ELSIF lc_object_version_number > p_sst_rec.object_version_number THEN
1390: Okl_Api.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1391: RAISE Okl_Api.G_EXCEPTION_ERROR;
1392: ELSIF lc_object_version_number <> p_sst_rec.object_version_number THEN
1393: Okl_Api.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1394: RAISE Okl_Api.G_EXCEPTION_ERROR;
1395: ELSIF lc_object_version_number = -1 THEN

Line 1393: Okl_Api.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);

1389: ELSIF lc_object_version_number > p_sst_rec.object_version_number THEN
1390: Okl_Api.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1391: RAISE Okl_Api.G_EXCEPTION_ERROR;
1392: ELSIF lc_object_version_number <> p_sst_rec.object_version_number THEN
1393: Okl_Api.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1394: RAISE Okl_Api.G_EXCEPTION_ERROR;
1395: ELSIF lc_object_version_number = -1 THEN
1396: Okl_Api.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
1397: RAISE Okl_Api.G_EXCEPTION_ERROR;

Line 1394: RAISE Okl_Api.G_EXCEPTION_ERROR;

1390: Okl_Api.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1391: RAISE Okl_Api.G_EXCEPTION_ERROR;
1392: ELSIF lc_object_version_number <> p_sst_rec.object_version_number THEN
1393: Okl_Api.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1394: RAISE Okl_Api.G_EXCEPTION_ERROR;
1395: ELSIF lc_object_version_number = -1 THEN
1396: Okl_Api.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
1397: RAISE Okl_Api.G_EXCEPTION_ERROR;
1398: END IF;

Line 1396: Okl_Api.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);

1392: ELSIF lc_object_version_number <> p_sst_rec.object_version_number THEN
1393: Okl_Api.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1394: RAISE Okl_Api.G_EXCEPTION_ERROR;
1395: ELSIF lc_object_version_number = -1 THEN
1396: Okl_Api.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
1397: RAISE Okl_Api.G_EXCEPTION_ERROR;
1398: END IF;
1399: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1400: EXCEPTION

Line 1397: RAISE Okl_Api.G_EXCEPTION_ERROR;

1393: Okl_Api.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1394: RAISE Okl_Api.G_EXCEPTION_ERROR;
1395: ELSIF lc_object_version_number = -1 THEN
1396: Okl_Api.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
1397: RAISE Okl_Api.G_EXCEPTION_ERROR;
1398: END IF;
1399: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1400: EXCEPTION
1401: WHEN Okl_Api.G_EXCEPTION_ERROR THEN

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

1395: ELSIF lc_object_version_number = -1 THEN
1396: Okl_Api.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
1397: RAISE Okl_Api.G_EXCEPTION_ERROR;
1398: END IF;
1399: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1400: EXCEPTION
1401: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
1402: x_return_status := Okl_Api.HANDLE_EXCEPTIONS
1403: (

Line 1401: WHEN Okl_Api.G_EXCEPTION_ERROR THEN

1397: RAISE Okl_Api.G_EXCEPTION_ERROR;
1398: END IF;
1399: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1400: EXCEPTION
1401: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
1402: x_return_status := Okl_Api.HANDLE_EXCEPTIONS
1403: (
1404: l_api_name,
1405: G_PKG_NAME,

Line 1402: x_return_status := Okl_Api.HANDLE_EXCEPTIONS

1398: END IF;
1399: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1400: EXCEPTION
1401: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
1402: x_return_status := Okl_Api.HANDLE_EXCEPTIONS
1403: (
1404: l_api_name,
1405: G_PKG_NAME,
1406: 'Okl_Api.G_RET_STS_ERROR',

Line 1406: 'Okl_Api.G_RET_STS_ERROR',

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

Line 1411: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

1407: x_msg_count,
1408: x_msg_data,
1409: '_PVT'
1410: );
1411: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1412: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS
1413: (
1414: l_api_name,
1415: G_PKG_NAME,

Line 1412: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS

1408: x_msg_data,
1409: '_PVT'
1410: );
1411: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1412: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS
1413: (
1414: l_api_name,
1415: G_PKG_NAME,
1416: 'Okl_Api.G_RET_STS_UNEXP_ERROR',

Line 1416: 'Okl_Api.G_RET_STS_UNEXP_ERROR',

1412: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS
1413: (
1414: l_api_name,
1415: G_PKG_NAME,
1416: 'Okl_Api.G_RET_STS_UNEXP_ERROR',
1417: x_msg_count,
1418: x_msg_data,
1419: '_PVT'
1420: );

Line 1422: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS

1418: x_msg_data,
1419: '_PVT'
1420: );
1421: WHEN OTHERS THEN
1422: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS
1423: (
1424: l_api_name,
1425: G_PKG_NAME,
1426: 'OTHERS',

Line 1437: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

1433: -- lock_row for:OKL_SRCH_STRM_TYPS_V --
1434: ---------------------------------------
1435: PROCEDURE lock_row(
1436: p_api_version IN NUMBER,
1437: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
1438: x_return_status OUT NOCOPY VARCHAR2,
1439: x_msg_count OUT NOCOPY NUMBER,
1440: x_msg_data OUT NOCOPY VARCHAR2,
1441: p_sstv_rec IN sstv_rec_type) IS

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

1441: p_sstv_rec IN sstv_rec_type) IS
1442:
1443: l_api_version CONSTANT NUMBER := 1;
1444: l_api_name CONSTANT VARCHAR2(30) := 'V_lock_row';
1445: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1446: l_sst_rec sst_rec_type;
1447: BEGIN
1448: l_return_status := Okl_Api.START_ACTIVITY(l_api_name,
1449: G_PKG_NAME,

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

1444: l_api_name CONSTANT VARCHAR2(30) := 'V_lock_row';
1445: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1446: l_sst_rec sst_rec_type;
1447: BEGIN
1448: l_return_status := Okl_Api.START_ACTIVITY(l_api_name,
1449: G_PKG_NAME,
1450: p_init_msg_list,
1451: l_api_version,
1452: p_api_version,

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

1451: l_api_version,
1452: p_api_version,
1453: '_PVT',
1454: x_return_status);
1455: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1456: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1457: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1458: RAISE Okl_Api.G_EXCEPTION_ERROR;
1459: END IF;

Line 1456: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1452: p_api_version,
1453: '_PVT',
1454: x_return_status);
1455: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1456: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1457: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1458: RAISE Okl_Api.G_EXCEPTION_ERROR;
1459: END IF;
1460: --------------------------------------

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

1453: '_PVT',
1454: x_return_status);
1455: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1456: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1457: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1458: RAISE Okl_Api.G_EXCEPTION_ERROR;
1459: END IF;
1460: --------------------------------------
1461: -- Move VIEW record to "Child" records

Line 1458: RAISE Okl_Api.G_EXCEPTION_ERROR;

1454: x_return_status);
1455: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1456: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1457: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1458: RAISE Okl_Api.G_EXCEPTION_ERROR;
1459: END IF;
1460: --------------------------------------
1461: -- Move VIEW record to "Child" records
1462: --------------------------------------

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

1470: x_msg_count,
1471: x_msg_data,
1472: l_sst_rec
1473: );
1474: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1475: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1476: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1477: RAISE Okl_Api.G_EXCEPTION_ERROR;
1478: END IF;

Line 1475: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1471: x_msg_data,
1472: l_sst_rec
1473: );
1474: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1475: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1476: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1477: RAISE Okl_Api.G_EXCEPTION_ERROR;
1478: END IF;
1479: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);

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

1472: l_sst_rec
1473: );
1474: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1475: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1476: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1477: RAISE Okl_Api.G_EXCEPTION_ERROR;
1478: END IF;
1479: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1480: EXCEPTION

Line 1477: RAISE Okl_Api.G_EXCEPTION_ERROR;

1473: );
1474: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1475: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1476: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1477: RAISE Okl_Api.G_EXCEPTION_ERROR;
1478: END IF;
1479: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1480: EXCEPTION
1481: WHEN Okl_Api.G_EXCEPTION_ERROR THEN

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

1475: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1476: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1477: RAISE Okl_Api.G_EXCEPTION_ERROR;
1478: END IF;
1479: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1480: EXCEPTION
1481: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
1482: x_return_status := Okl_Api.HANDLE_EXCEPTIONS
1483: (

Line 1481: WHEN Okl_Api.G_EXCEPTION_ERROR THEN

1477: RAISE Okl_Api.G_EXCEPTION_ERROR;
1478: END IF;
1479: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1480: EXCEPTION
1481: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
1482: x_return_status := Okl_Api.HANDLE_EXCEPTIONS
1483: (
1484: l_api_name,
1485: G_PKG_NAME,

Line 1482: x_return_status := Okl_Api.HANDLE_EXCEPTIONS

1478: END IF;
1479: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1480: EXCEPTION
1481: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
1482: x_return_status := Okl_Api.HANDLE_EXCEPTIONS
1483: (
1484: l_api_name,
1485: G_PKG_NAME,
1486: 'Okl_Api.G_RET_STS_ERROR',

Line 1486: 'Okl_Api.G_RET_STS_ERROR',

1482: x_return_status := Okl_Api.HANDLE_EXCEPTIONS
1483: (
1484: l_api_name,
1485: G_PKG_NAME,
1486: 'Okl_Api.G_RET_STS_ERROR',
1487: x_msg_count,
1488: x_msg_data,
1489: '_PVT'
1490: );

Line 1491: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

1487: x_msg_count,
1488: x_msg_data,
1489: '_PVT'
1490: );
1491: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1492: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS
1493: (
1494: l_api_name,
1495: G_PKG_NAME,

Line 1492: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS

1488: x_msg_data,
1489: '_PVT'
1490: );
1491: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1492: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS
1493: (
1494: l_api_name,
1495: G_PKG_NAME,
1496: 'Okl_Api.G_RET_STS_UNEXP_ERROR',

Line 1496: 'Okl_Api.G_RET_STS_UNEXP_ERROR',

1492: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS
1493: (
1494: l_api_name,
1495: G_PKG_NAME,
1496: 'Okl_Api.G_RET_STS_UNEXP_ERROR',
1497: x_msg_count,
1498: x_msg_data,
1499: '_PVT'
1500: );

Line 1502: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS

1498: x_msg_data,
1499: '_PVT'
1500: );
1501: WHEN OTHERS THEN
1502: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS
1503: (
1504: l_api_name,
1505: G_PKG_NAME,
1506: 'OTHERS',

Line 1517: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

1513: -- PL/SQL TBL lock_row for:SSTV_TBL --
1514: --------------------------------------
1515: PROCEDURE lock_row(
1516: p_api_version IN NUMBER,
1517: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
1518: x_return_status OUT NOCOPY VARCHAR2,
1519: x_msg_count OUT NOCOPY NUMBER,
1520: x_msg_data OUT NOCOPY VARCHAR2,
1521: p_sstv_tbl IN sstv_tbl_type) IS

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

1521: p_sstv_tbl IN sstv_tbl_type) IS
1522:
1523: l_api_version CONSTANT NUMBER := 1;
1524: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_lock_row';
1525: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1526: i NUMBER := 0;
1527: -- Begin Post-Generation Change
1528: -- overall error status
1529: l_overall_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

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

1525: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1526: i NUMBER := 0;
1527: -- Begin Post-Generation Change
1528: -- overall error status
1529: l_overall_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1530: -- End Post-Generation Change
1531:
1532: BEGIN
1533: Okl_Api.init_msg_list(p_init_msg_list);

Line 1533: Okl_Api.init_msg_list(p_init_msg_list);

1529: l_overall_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1530: -- End Post-Generation Change
1531:
1532: BEGIN
1533: Okl_Api.init_msg_list(p_init_msg_list);
1534: -- Make sure PL/SQL table has records in it before passing
1535: IF (p_sstv_tbl.COUNT > 0) THEN
1536: i := p_sstv_tbl.FIRST;
1537: LOOP

Line 1540: p_init_msg_list => Okl_Api.G_FALSE,

1536: i := p_sstv_tbl.FIRST;
1537: LOOP
1538: lock_row (
1539: p_api_version => p_api_version,
1540: p_init_msg_list => Okl_Api.G_FALSE,
1541: x_return_status => x_return_status,
1542: x_msg_count => x_msg_count,
1543: x_msg_data => x_msg_data,
1544: p_sstv_rec => p_sstv_tbl(i));

Line 1548: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN

1544: p_sstv_rec => p_sstv_tbl(i));
1545:
1546: -- Begin Post-Generation Change
1547: -- store the highest degree of error
1548: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
1549: IF l_overall_status <> Okl_Api.G_RET_STS_UNEXP_ERROR THEN
1550: l_overall_status := x_return_status;
1551: END IF;
1552: END IF;

Line 1549: IF l_overall_status <> Okl_Api.G_RET_STS_UNEXP_ERROR THEN

1545:
1546: -- Begin Post-Generation Change
1547: -- store the highest degree of error
1548: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
1549: IF l_overall_status <> Okl_Api.G_RET_STS_UNEXP_ERROR THEN
1550: l_overall_status := x_return_status;
1551: END IF;
1552: END IF;
1553: -- End Post-Generation Change

Line 1566: WHEN Okl_Api.G_EXCEPTION_ERROR THEN

1562: -- End Post-Generation Change
1563:
1564: END IF;
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:
1564: END IF;
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 1605: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

1601: ---------------------------------------
1602: -- update_row for:OKL_SRCH_STRM_TYPS --
1603: ---------------------------------------
1604: PROCEDURE update_row(
1605: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
1606: x_return_status OUT NOCOPY VARCHAR2,
1607: x_msg_count OUT NOCOPY NUMBER,
1608: x_msg_data OUT NOCOPY VARCHAR2,
1609: p_sst_rec IN sst_rec_type,

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

1610: x_sst_rec OUT NOCOPY sst_rec_type) IS
1611:
1612: l_api_version CONSTANT NUMBER := 1;
1613: l_api_name CONSTANT VARCHAR2(30) := 'TYPS_update_row';
1614: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1615: l_sst_rec sst_rec_type := p_sst_rec;
1616: l_def_sst_rec sst_rec_type;
1617: l_row_notfound BOOLEAN := TRUE;
1618: -- history tables not supported -- 04 APR 2002

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

1626: x_sst_rec OUT NOCOPY sst_rec_type
1627: ) RETURN VARCHAR2 IS
1628: l_sst_rec sst_rec_type;
1629: l_row_notfound BOOLEAN := TRUE;
1630: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1631: BEGIN
1632: x_sst_rec := p_sst_rec;
1633: -- Get current database values
1634: l_sst_rec := get_rec(p_sst_rec, l_row_notfound);

Line 1636: l_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

1632: x_sst_rec := p_sst_rec;
1633: -- Get current database values
1634: l_sst_rec := get_rec(p_sst_rec, l_row_notfound);
1635: IF (l_row_notfound) THEN
1636: l_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
1637: END IF;
1638: -- Move the "old" record to the history record:
1639: -- (1) to get the "old" version
1640: -- (2) to avoid 2 hits to the database

Line 1642: IF (x_sst_rec.id = Okl_Api.G_MISS_NUM)

1638: -- Move the "old" record to the history record:
1639: -- (1) to get the "old" version
1640: -- (2) to avoid 2 hits to the database
1641: -- migrate(l_sst_rec, l_okl_srch_strm_typs_h_rec);
1642: IF (x_sst_rec.id = Okl_Api.G_MISS_NUM)
1643: THEN
1644: x_sst_rec.id := l_sst_rec.id;
1645: END IF;
1646: IF (x_sst_rec.sty_id = Okl_Api.G_MISS_NUM)

Line 1646: IF (x_sst_rec.sty_id = Okl_Api.G_MISS_NUM)

1642: IF (x_sst_rec.id = Okl_Api.G_MISS_NUM)
1643: THEN
1644: x_sst_rec.id := l_sst_rec.id;
1645: END IF;
1646: IF (x_sst_rec.sty_id = Okl_Api.G_MISS_NUM)
1647: THEN
1648: x_sst_rec.sty_id := l_sst_rec.sty_id;
1649: END IF;
1650: IF (x_sst_rec.cah_id = Okl_Api.G_MISS_NUM)

Line 1650: IF (x_sst_rec.cah_id = Okl_Api.G_MISS_NUM)

1646: IF (x_sst_rec.sty_id = Okl_Api.G_MISS_NUM)
1647: THEN
1648: x_sst_rec.sty_id := l_sst_rec.sty_id;
1649: END IF;
1650: IF (x_sst_rec.cah_id = Okl_Api.G_MISS_NUM)
1651: THEN
1652: x_sst_rec.cah_id := l_sst_rec.cah_id;
1653: END IF;
1654: IF (x_sst_rec.object_version_number = Okl_Api.G_MISS_NUM)

Line 1654: IF (x_sst_rec.object_version_number = Okl_Api.G_MISS_NUM)

1650: IF (x_sst_rec.cah_id = Okl_Api.G_MISS_NUM)
1651: THEN
1652: x_sst_rec.cah_id := l_sst_rec.cah_id;
1653: END IF;
1654: IF (x_sst_rec.object_version_number = Okl_Api.G_MISS_NUM)
1655: THEN
1656: x_sst_rec.object_version_number := l_sst_rec.object_version_number;
1657: END IF;
1658: IF (x_sst_rec.add_yn = Okl_Api.G_MISS_CHAR)

Line 1658: IF (x_sst_rec.add_yn = Okl_Api.G_MISS_CHAR)

1654: IF (x_sst_rec.object_version_number = Okl_Api.G_MISS_NUM)
1655: THEN
1656: x_sst_rec.object_version_number := l_sst_rec.object_version_number;
1657: END IF;
1658: IF (x_sst_rec.add_yn = Okl_Api.G_MISS_CHAR)
1659: THEN
1660: x_sst_rec.add_yn := l_sst_rec.add_yn;
1661: END IF;
1662: IF (x_sst_rec.attribute_category = Okl_Api.G_MISS_CHAR)

Line 1662: IF (x_sst_rec.attribute_category = Okl_Api.G_MISS_CHAR)

1658: IF (x_sst_rec.add_yn = Okl_Api.G_MISS_CHAR)
1659: THEN
1660: x_sst_rec.add_yn := l_sst_rec.add_yn;
1661: END IF;
1662: IF (x_sst_rec.attribute_category = Okl_Api.G_MISS_CHAR)
1663: THEN
1664: x_sst_rec.attribute_category := l_sst_rec.attribute_category;
1665: END IF;
1666: IF (x_sst_rec.attribute1 = Okl_Api.G_MISS_CHAR)

Line 1666: IF (x_sst_rec.attribute1 = Okl_Api.G_MISS_CHAR)

1662: IF (x_sst_rec.attribute_category = Okl_Api.G_MISS_CHAR)
1663: THEN
1664: x_sst_rec.attribute_category := l_sst_rec.attribute_category;
1665: END IF;
1666: IF (x_sst_rec.attribute1 = Okl_Api.G_MISS_CHAR)
1667: THEN
1668: x_sst_rec.attribute1 := l_sst_rec.attribute1;
1669: END IF;
1670: IF (x_sst_rec.attribute2 = Okl_Api.G_MISS_CHAR)

Line 1670: IF (x_sst_rec.attribute2 = Okl_Api.G_MISS_CHAR)

1666: IF (x_sst_rec.attribute1 = Okl_Api.G_MISS_CHAR)
1667: THEN
1668: x_sst_rec.attribute1 := l_sst_rec.attribute1;
1669: END IF;
1670: IF (x_sst_rec.attribute2 = Okl_Api.G_MISS_CHAR)
1671: THEN
1672: x_sst_rec.attribute2 := l_sst_rec.attribute2;
1673: END IF;
1674: IF (x_sst_rec.attribute3 = Okl_Api.G_MISS_CHAR)

Line 1674: IF (x_sst_rec.attribute3 = Okl_Api.G_MISS_CHAR)

1670: IF (x_sst_rec.attribute2 = Okl_Api.G_MISS_CHAR)
1671: THEN
1672: x_sst_rec.attribute2 := l_sst_rec.attribute2;
1673: END IF;
1674: IF (x_sst_rec.attribute3 = Okl_Api.G_MISS_CHAR)
1675: THEN
1676: x_sst_rec.attribute3 := l_sst_rec.attribute3;
1677: END IF;
1678: IF (x_sst_rec.attribute4 = Okl_Api.G_MISS_CHAR)

Line 1678: IF (x_sst_rec.attribute4 = Okl_Api.G_MISS_CHAR)

1674: IF (x_sst_rec.attribute3 = Okl_Api.G_MISS_CHAR)
1675: THEN
1676: x_sst_rec.attribute3 := l_sst_rec.attribute3;
1677: END IF;
1678: IF (x_sst_rec.attribute4 = Okl_Api.G_MISS_CHAR)
1679: THEN
1680: x_sst_rec.attribute4 := l_sst_rec.attribute4;
1681: END IF;
1682: IF (x_sst_rec.attribute5 = Okl_Api.G_MISS_CHAR)

Line 1682: IF (x_sst_rec.attribute5 = Okl_Api.G_MISS_CHAR)

1678: IF (x_sst_rec.attribute4 = Okl_Api.G_MISS_CHAR)
1679: THEN
1680: x_sst_rec.attribute4 := l_sst_rec.attribute4;
1681: END IF;
1682: IF (x_sst_rec.attribute5 = Okl_Api.G_MISS_CHAR)
1683: THEN
1684: x_sst_rec.attribute5 := l_sst_rec.attribute5;
1685: END IF;
1686: IF (x_sst_rec.attribute6 = Okl_Api.G_MISS_CHAR)

Line 1686: IF (x_sst_rec.attribute6 = Okl_Api.G_MISS_CHAR)

1682: IF (x_sst_rec.attribute5 = Okl_Api.G_MISS_CHAR)
1683: THEN
1684: x_sst_rec.attribute5 := l_sst_rec.attribute5;
1685: END IF;
1686: IF (x_sst_rec.attribute6 = Okl_Api.G_MISS_CHAR)
1687: THEN
1688: x_sst_rec.attribute6 := l_sst_rec.attribute6;
1689: END IF;
1690: IF (x_sst_rec.attribute7 = Okl_Api.G_MISS_CHAR)

Line 1690: IF (x_sst_rec.attribute7 = Okl_Api.G_MISS_CHAR)

1686: IF (x_sst_rec.attribute6 = Okl_Api.G_MISS_CHAR)
1687: THEN
1688: x_sst_rec.attribute6 := l_sst_rec.attribute6;
1689: END IF;
1690: IF (x_sst_rec.attribute7 = Okl_Api.G_MISS_CHAR)
1691: THEN
1692: x_sst_rec.attribute7 := l_sst_rec.attribute7;
1693: END IF;
1694: IF (x_sst_rec.attribute8 = Okl_Api.G_MISS_CHAR)

Line 1694: IF (x_sst_rec.attribute8 = Okl_Api.G_MISS_CHAR)

1690: IF (x_sst_rec.attribute7 = Okl_Api.G_MISS_CHAR)
1691: THEN
1692: x_sst_rec.attribute7 := l_sst_rec.attribute7;
1693: END IF;
1694: IF (x_sst_rec.attribute8 = Okl_Api.G_MISS_CHAR)
1695: THEN
1696: x_sst_rec.attribute8 := l_sst_rec.attribute8;
1697: END IF;
1698: IF (x_sst_rec.attribute9 = Okl_Api.G_MISS_CHAR)

Line 1698: IF (x_sst_rec.attribute9 = Okl_Api.G_MISS_CHAR)

1694: IF (x_sst_rec.attribute8 = Okl_Api.G_MISS_CHAR)
1695: THEN
1696: x_sst_rec.attribute8 := l_sst_rec.attribute8;
1697: END IF;
1698: IF (x_sst_rec.attribute9 = Okl_Api.G_MISS_CHAR)
1699: THEN
1700: x_sst_rec.attribute9 := l_sst_rec.attribute9;
1701: END IF;
1702: IF (x_sst_rec.attribute10 = Okl_Api.G_MISS_CHAR)

Line 1702: IF (x_sst_rec.attribute10 = Okl_Api.G_MISS_CHAR)

1698: IF (x_sst_rec.attribute9 = Okl_Api.G_MISS_CHAR)
1699: THEN
1700: x_sst_rec.attribute9 := l_sst_rec.attribute9;
1701: END IF;
1702: IF (x_sst_rec.attribute10 = Okl_Api.G_MISS_CHAR)
1703: THEN
1704: x_sst_rec.attribute10 := l_sst_rec.attribute10;
1705: END IF;
1706: IF (x_sst_rec.attribute11 = Okl_Api.G_MISS_CHAR)

Line 1706: IF (x_sst_rec.attribute11 = Okl_Api.G_MISS_CHAR)

1702: IF (x_sst_rec.attribute10 = Okl_Api.G_MISS_CHAR)
1703: THEN
1704: x_sst_rec.attribute10 := l_sst_rec.attribute10;
1705: END IF;
1706: IF (x_sst_rec.attribute11 = Okl_Api.G_MISS_CHAR)
1707: THEN
1708: x_sst_rec.attribute11 := l_sst_rec.attribute11;
1709: END IF;
1710: IF (x_sst_rec.attribute12 = Okl_Api.G_MISS_CHAR)

Line 1710: IF (x_sst_rec.attribute12 = Okl_Api.G_MISS_CHAR)

1706: IF (x_sst_rec.attribute11 = Okl_Api.G_MISS_CHAR)
1707: THEN
1708: x_sst_rec.attribute11 := l_sst_rec.attribute11;
1709: END IF;
1710: IF (x_sst_rec.attribute12 = Okl_Api.G_MISS_CHAR)
1711: THEN
1712: x_sst_rec.attribute12 := l_sst_rec.attribute12;
1713: END IF;
1714: IF (x_sst_rec.attribute13 = Okl_Api.G_MISS_CHAR)

Line 1714: IF (x_sst_rec.attribute13 = Okl_Api.G_MISS_CHAR)

1710: IF (x_sst_rec.attribute12 = Okl_Api.G_MISS_CHAR)
1711: THEN
1712: x_sst_rec.attribute12 := l_sst_rec.attribute12;
1713: END IF;
1714: IF (x_sst_rec.attribute13 = Okl_Api.G_MISS_CHAR)
1715: THEN
1716: x_sst_rec.attribute13 := l_sst_rec.attribute13;
1717: END IF;
1718: IF (x_sst_rec.attribute14 = Okl_Api.G_MISS_CHAR)

Line 1718: IF (x_sst_rec.attribute14 = Okl_Api.G_MISS_CHAR)

1714: IF (x_sst_rec.attribute13 = Okl_Api.G_MISS_CHAR)
1715: THEN
1716: x_sst_rec.attribute13 := l_sst_rec.attribute13;
1717: END IF;
1718: IF (x_sst_rec.attribute14 = Okl_Api.G_MISS_CHAR)
1719: THEN
1720: x_sst_rec.attribute14 := l_sst_rec.attribute14;
1721: END IF;
1722: IF (x_sst_rec.attribute15 = Okl_Api.G_MISS_CHAR)

Line 1722: IF (x_sst_rec.attribute15 = Okl_Api.G_MISS_CHAR)

1718: IF (x_sst_rec.attribute14 = Okl_Api.G_MISS_CHAR)
1719: THEN
1720: x_sst_rec.attribute14 := l_sst_rec.attribute14;
1721: END IF;
1722: IF (x_sst_rec.attribute15 = Okl_Api.G_MISS_CHAR)
1723: THEN
1724: x_sst_rec.attribute15 := l_sst_rec.attribute15;
1725: END IF;
1726: IF (x_sst_rec.created_by = Okl_Api.G_MISS_NUM)

Line 1726: IF (x_sst_rec.created_by = Okl_Api.G_MISS_NUM)

1722: IF (x_sst_rec.attribute15 = Okl_Api.G_MISS_CHAR)
1723: THEN
1724: x_sst_rec.attribute15 := l_sst_rec.attribute15;
1725: END IF;
1726: IF (x_sst_rec.created_by = Okl_Api.G_MISS_NUM)
1727: THEN
1728: x_sst_rec.created_by := l_sst_rec.created_by;
1729: END IF;
1730: IF (x_sst_rec.creation_date = Okl_Api.G_MISS_DATE)

Line 1730: IF (x_sst_rec.creation_date = Okl_Api.G_MISS_DATE)

1726: IF (x_sst_rec.created_by = Okl_Api.G_MISS_NUM)
1727: THEN
1728: x_sst_rec.created_by := l_sst_rec.created_by;
1729: END IF;
1730: IF (x_sst_rec.creation_date = Okl_Api.G_MISS_DATE)
1731: THEN
1732: x_sst_rec.creation_date := l_sst_rec.creation_date;
1733: END IF;
1734: IF (x_sst_rec.last_updated_by = Okl_Api.G_MISS_NUM)

Line 1734: IF (x_sst_rec.last_updated_by = Okl_Api.G_MISS_NUM)

1730: IF (x_sst_rec.creation_date = Okl_Api.G_MISS_DATE)
1731: THEN
1732: x_sst_rec.creation_date := l_sst_rec.creation_date;
1733: END IF;
1734: IF (x_sst_rec.last_updated_by = Okl_Api.G_MISS_NUM)
1735: THEN
1736: x_sst_rec.last_updated_by := l_sst_rec.last_updated_by;
1737: END IF;
1738: IF (x_sst_rec.last_update_date = Okl_Api.G_MISS_DATE)

Line 1738: IF (x_sst_rec.last_update_date = Okl_Api.G_MISS_DATE)

1734: IF (x_sst_rec.last_updated_by = Okl_Api.G_MISS_NUM)
1735: THEN
1736: x_sst_rec.last_updated_by := l_sst_rec.last_updated_by;
1737: END IF;
1738: IF (x_sst_rec.last_update_date = Okl_Api.G_MISS_DATE)
1739: THEN
1740: x_sst_rec.last_update_date := l_sst_rec.last_update_date;
1741: END IF;
1742: IF (x_sst_rec.last_update_login = Okl_Api.G_MISS_NUM)

Line 1742: IF (x_sst_rec.last_update_login = Okl_Api.G_MISS_NUM)

1738: IF (x_sst_rec.last_update_date = Okl_Api.G_MISS_DATE)
1739: THEN
1740: x_sst_rec.last_update_date := l_sst_rec.last_update_date;
1741: END IF;
1742: IF (x_sst_rec.last_update_login = Okl_Api.G_MISS_NUM)
1743: THEN
1744: x_sst_rec.last_update_login := l_sst_rec.last_update_login;
1745: END IF;
1746: RETURN(l_return_status);

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

1751: FUNCTION Set_Attributes (
1752: p_sst_rec IN sst_rec_type,
1753: x_sst_rec OUT NOCOPY sst_rec_type
1754: ) RETURN VARCHAR2 IS
1755: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1756: BEGIN
1757: x_sst_rec := p_sst_rec;
1758: RETURN(l_return_status);
1759: END Set_Attributes;

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

1757: x_sst_rec := p_sst_rec;
1758: RETURN(l_return_status);
1759: END Set_Attributes;
1760: BEGIN
1761: l_return_status := Okl_Api.START_ACTIVITY(l_api_name,
1762: p_init_msg_list,
1763: '_PVT',
1764: x_return_status);
1765: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

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

1761: l_return_status := Okl_Api.START_ACTIVITY(l_api_name,
1762: p_init_msg_list,
1763: '_PVT',
1764: x_return_status);
1765: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1766: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1767: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1768: RAISE Okl_Api.G_EXCEPTION_ERROR;
1769: END IF;

Line 1766: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1762: p_init_msg_list,
1763: '_PVT',
1764: x_return_status);
1765: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1766: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1767: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1768: RAISE Okl_Api.G_EXCEPTION_ERROR;
1769: END IF;
1770: --- Setting item attributes

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

1763: '_PVT',
1764: x_return_status);
1765: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1766: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1767: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1768: RAISE Okl_Api.G_EXCEPTION_ERROR;
1769: END IF;
1770: --- Setting item attributes
1771: l_return_status := Set_Attributes(

Line 1768: RAISE Okl_Api.G_EXCEPTION_ERROR;

1764: x_return_status);
1765: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1766: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1767: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1768: RAISE Okl_Api.G_EXCEPTION_ERROR;
1769: END IF;
1770: --- Setting item attributes
1771: l_return_status := Set_Attributes(
1772: p_sst_rec, -- IN

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

1771: l_return_status := Set_Attributes(
1772: p_sst_rec, -- IN
1773: l_sst_rec); -- OUT
1774: --- If any errors happen abort API
1775: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1776: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1777: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1778: RAISE Okl_Api.G_EXCEPTION_ERROR;
1779: END IF;

Line 1776: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1772: p_sst_rec, -- IN
1773: l_sst_rec); -- OUT
1774: --- If any errors happen abort API
1775: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1776: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1777: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1778: RAISE Okl_Api.G_EXCEPTION_ERROR;
1779: END IF;
1780: l_return_status := populate_new_record(l_sst_rec, l_def_sst_rec);

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

1773: l_sst_rec); -- OUT
1774: --- If any errors happen abort API
1775: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1776: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1777: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1778: RAISE Okl_Api.G_EXCEPTION_ERROR;
1779: END IF;
1780: l_return_status := populate_new_record(l_sst_rec, l_def_sst_rec);
1781: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

Line 1778: RAISE Okl_Api.G_EXCEPTION_ERROR;

1774: --- If any errors happen abort API
1775: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1776: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1777: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1778: RAISE Okl_Api.G_EXCEPTION_ERROR;
1779: END IF;
1780: l_return_status := populate_new_record(l_sst_rec, l_def_sst_rec);
1781: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1782: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

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

1777: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1778: RAISE Okl_Api.G_EXCEPTION_ERROR;
1779: END IF;
1780: l_return_status := populate_new_record(l_sst_rec, l_def_sst_rec);
1781: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1782: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1783: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1784: RAISE Okl_Api.G_EXCEPTION_ERROR;
1785: END IF;

Line 1782: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1778: RAISE Okl_Api.G_EXCEPTION_ERROR;
1779: END IF;
1780: l_return_status := populate_new_record(l_sst_rec, l_def_sst_rec);
1781: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1782: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1783: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1784: RAISE Okl_Api.G_EXCEPTION_ERROR;
1785: END IF;
1786: UPDATE OKL_SRCH_STRM_TYPS

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

1779: END IF;
1780: l_return_status := populate_new_record(l_sst_rec, l_def_sst_rec);
1781: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1782: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1783: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1784: RAISE Okl_Api.G_EXCEPTION_ERROR;
1785: END IF;
1786: UPDATE OKL_SRCH_STRM_TYPS
1787: SET STY_ID = l_def_sst_rec.sty_id,

Line 1784: RAISE Okl_Api.G_EXCEPTION_ERROR;

1780: l_return_status := populate_new_record(l_sst_rec, l_def_sst_rec);
1781: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1782: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1783: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1784: RAISE Okl_Api.G_EXCEPTION_ERROR;
1785: END IF;
1786: UPDATE OKL_SRCH_STRM_TYPS
1787: SET STY_ID = l_def_sst_rec.sty_id,
1788: CAH_ID = l_def_sst_rec.cah_id,

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

1821: l_okl_srch_strm_typs_h_rec,
1822: lx_okl_srch_strm_typs_h_rec
1823: );
1824: */
1825: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1826: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1827: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1828: RAISE Okl_Api.G_EXCEPTION_ERROR;
1829: END IF;

Line 1826: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1822: lx_okl_srch_strm_typs_h_rec
1823: );
1824: */
1825: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1826: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1827: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1828: RAISE Okl_Api.G_EXCEPTION_ERROR;
1829: END IF;
1830: x_sst_rec := l_def_sst_rec;

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

1823: );
1824: */
1825: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1826: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1827: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1828: RAISE Okl_Api.G_EXCEPTION_ERROR;
1829: END IF;
1830: x_sst_rec := l_def_sst_rec;
1831: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);

Line 1828: RAISE Okl_Api.G_EXCEPTION_ERROR;

1824: */
1825: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1826: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1827: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1828: RAISE Okl_Api.G_EXCEPTION_ERROR;
1829: END IF;
1830: x_sst_rec := l_def_sst_rec;
1831: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1832: EXCEPTION

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

1827: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1828: RAISE Okl_Api.G_EXCEPTION_ERROR;
1829: END IF;
1830: x_sst_rec := l_def_sst_rec;
1831: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1832: EXCEPTION
1833: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
1834: x_return_status := Okl_Api.HANDLE_EXCEPTIONS
1835: (

Line 1833: WHEN Okl_Api.G_EXCEPTION_ERROR THEN

1829: END IF;
1830: x_sst_rec := l_def_sst_rec;
1831: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1832: EXCEPTION
1833: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
1834: x_return_status := Okl_Api.HANDLE_EXCEPTIONS
1835: (
1836: l_api_name,
1837: G_PKG_NAME,

Line 1834: x_return_status := Okl_Api.HANDLE_EXCEPTIONS

1830: x_sst_rec := l_def_sst_rec;
1831: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1832: EXCEPTION
1833: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
1834: x_return_status := Okl_Api.HANDLE_EXCEPTIONS
1835: (
1836: l_api_name,
1837: G_PKG_NAME,
1838: 'Okl_Api.G_RET_STS_ERROR',

Line 1838: 'Okl_Api.G_RET_STS_ERROR',

1834: x_return_status := Okl_Api.HANDLE_EXCEPTIONS
1835: (
1836: l_api_name,
1837: G_PKG_NAME,
1838: 'Okl_Api.G_RET_STS_ERROR',
1839: x_msg_count,
1840: x_msg_data,
1841: '_PVT'
1842: );

Line 1843: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

1839: x_msg_count,
1840: x_msg_data,
1841: '_PVT'
1842: );
1843: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1844: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS
1845: (
1846: l_api_name,
1847: G_PKG_NAME,

Line 1844: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS

1840: x_msg_data,
1841: '_PVT'
1842: );
1843: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1844: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS
1845: (
1846: l_api_name,
1847: G_PKG_NAME,
1848: 'Okl_Api.G_RET_STS_UNEXP_ERROR',

Line 1848: 'Okl_Api.G_RET_STS_UNEXP_ERROR',

1844: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS
1845: (
1846: l_api_name,
1847: G_PKG_NAME,
1848: 'Okl_Api.G_RET_STS_UNEXP_ERROR',
1849: x_msg_count,
1850: x_msg_data,
1851: '_PVT'
1852: );

Line 1854: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS

1850: x_msg_data,
1851: '_PVT'
1852: );
1853: WHEN OTHERS THEN
1854: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS
1855: (
1856: l_api_name,
1857: G_PKG_NAME,
1858: 'OTHERS',

Line 1869: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

1865: -- update_row for:OKL_SRCH_STRM_TYPS_V --
1866: -----------------------------------------
1867: PROCEDURE update_row(
1868: p_api_version IN NUMBER,
1869: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
1870: x_return_status OUT NOCOPY VARCHAR2,
1871: x_msg_count OUT NOCOPY NUMBER,
1872: x_msg_data OUT NOCOPY VARCHAR2,
1873: p_sstv_rec IN sstv_rec_type,

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

1874: x_sstv_rec OUT NOCOPY sstv_rec_type) IS
1875:
1876: l_api_version CONSTANT NUMBER := 1;
1877: l_api_name CONSTANT VARCHAR2(30) := 'V_update_row';
1878: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1879: l_sstv_rec sstv_rec_type := p_sstv_rec;
1880: l_def_sstv_rec sstv_rec_type;
1881: l_sst_rec sst_rec_type;
1882: lx_sst_rec sst_rec_type;

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

1901: x_sstv_rec OUT NOCOPY sstv_rec_type
1902: ) RETURN VARCHAR2 IS
1903: l_sstv_rec sstv_rec_type;
1904: l_row_notfound BOOLEAN := TRUE;
1905: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1906: BEGIN
1907: x_sstv_rec := p_sstv_rec;
1908: -- Get current database values
1909: l_sstv_rec := get_rec(p_sstv_rec, l_row_notfound);

Line 1911: l_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

1907: x_sstv_rec := p_sstv_rec;
1908: -- Get current database values
1909: l_sstv_rec := get_rec(p_sstv_rec, l_row_notfound);
1910: IF (l_row_notfound) THEN
1911: l_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
1912: END IF;
1913: IF (x_sstv_rec.id = Okl_Api.G_MISS_NUM)
1914: THEN
1915: x_sstv_rec.id := l_sstv_rec.id;

Line 1913: IF (x_sstv_rec.id = Okl_Api.G_MISS_NUM)

1909: l_sstv_rec := get_rec(p_sstv_rec, l_row_notfound);
1910: IF (l_row_notfound) THEN
1911: l_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
1912: END IF;
1913: IF (x_sstv_rec.id = Okl_Api.G_MISS_NUM)
1914: THEN
1915: x_sstv_rec.id := l_sstv_rec.id;
1916: END IF;
1917: IF (x_sstv_rec.object_version_number = Okl_Api.G_MISS_NUM)

Line 1917: IF (x_sstv_rec.object_version_number = Okl_Api.G_MISS_NUM)

1913: IF (x_sstv_rec.id = Okl_Api.G_MISS_NUM)
1914: THEN
1915: x_sstv_rec.id := l_sstv_rec.id;
1916: END IF;
1917: IF (x_sstv_rec.object_version_number = Okl_Api.G_MISS_NUM)
1918: THEN
1919: x_sstv_rec.object_version_number := l_sstv_rec.object_version_number;
1920: END IF;
1921: IF (x_sstv_rec.sty_id = Okl_Api.G_MISS_NUM)

Line 1921: IF (x_sstv_rec.sty_id = Okl_Api.G_MISS_NUM)

1917: IF (x_sstv_rec.object_version_number = Okl_Api.G_MISS_NUM)
1918: THEN
1919: x_sstv_rec.object_version_number := l_sstv_rec.object_version_number;
1920: END IF;
1921: IF (x_sstv_rec.sty_id = Okl_Api.G_MISS_NUM)
1922: THEN
1923: x_sstv_rec.sty_id := l_sstv_rec.sty_id;
1924: END IF;
1925: IF (x_sstv_rec.cah_id = Okl_Api.G_MISS_NUM)

Line 1925: IF (x_sstv_rec.cah_id = Okl_Api.G_MISS_NUM)

1921: IF (x_sstv_rec.sty_id = Okl_Api.G_MISS_NUM)
1922: THEN
1923: x_sstv_rec.sty_id := l_sstv_rec.sty_id;
1924: END IF;
1925: IF (x_sstv_rec.cah_id = Okl_Api.G_MISS_NUM)
1926: THEN
1927: x_sstv_rec.cah_id := l_sstv_rec.cah_id;
1928: END IF;
1929: IF (x_sstv_rec.add_yn = Okl_Api.G_MISS_CHAR)

Line 1929: IF (x_sstv_rec.add_yn = Okl_Api.G_MISS_CHAR)

1925: IF (x_sstv_rec.cah_id = Okl_Api.G_MISS_NUM)
1926: THEN
1927: x_sstv_rec.cah_id := l_sstv_rec.cah_id;
1928: END IF;
1929: IF (x_sstv_rec.add_yn = Okl_Api.G_MISS_CHAR)
1930: THEN
1931: x_sstv_rec.add_yn := l_sstv_rec.add_yn;
1932: END IF;
1933: IF (x_sstv_rec.attribute_category = Okl_Api.G_MISS_CHAR)

Line 1933: IF (x_sstv_rec.attribute_category = Okl_Api.G_MISS_CHAR)

1929: IF (x_sstv_rec.add_yn = Okl_Api.G_MISS_CHAR)
1930: THEN
1931: x_sstv_rec.add_yn := l_sstv_rec.add_yn;
1932: END IF;
1933: IF (x_sstv_rec.attribute_category = Okl_Api.G_MISS_CHAR)
1934: THEN
1935: x_sstv_rec.attribute_category := l_sstv_rec.attribute_category;
1936: END IF;
1937: IF (x_sstv_rec.attribute1 = Okl_Api.G_MISS_CHAR)

Line 1937: IF (x_sstv_rec.attribute1 = Okl_Api.G_MISS_CHAR)

1933: IF (x_sstv_rec.attribute_category = Okl_Api.G_MISS_CHAR)
1934: THEN
1935: x_sstv_rec.attribute_category := l_sstv_rec.attribute_category;
1936: END IF;
1937: IF (x_sstv_rec.attribute1 = Okl_Api.G_MISS_CHAR)
1938: THEN
1939: x_sstv_rec.attribute1 := l_sstv_rec.attribute1;
1940: END IF;
1941: IF (x_sstv_rec.attribute2 = Okl_Api.G_MISS_CHAR)

Line 1941: IF (x_sstv_rec.attribute2 = Okl_Api.G_MISS_CHAR)

1937: IF (x_sstv_rec.attribute1 = Okl_Api.G_MISS_CHAR)
1938: THEN
1939: x_sstv_rec.attribute1 := l_sstv_rec.attribute1;
1940: END IF;
1941: IF (x_sstv_rec.attribute2 = Okl_Api.G_MISS_CHAR)
1942: THEN
1943: x_sstv_rec.attribute2 := l_sstv_rec.attribute2;
1944: END IF;
1945: IF (x_sstv_rec.attribute3 = Okl_Api.G_MISS_CHAR)

Line 1945: IF (x_sstv_rec.attribute3 = Okl_Api.G_MISS_CHAR)

1941: IF (x_sstv_rec.attribute2 = Okl_Api.G_MISS_CHAR)
1942: THEN
1943: x_sstv_rec.attribute2 := l_sstv_rec.attribute2;
1944: END IF;
1945: IF (x_sstv_rec.attribute3 = Okl_Api.G_MISS_CHAR)
1946: THEN
1947: x_sstv_rec.attribute3 := l_sstv_rec.attribute3;
1948: END IF;
1949: IF (x_sstv_rec.attribute4 = Okl_Api.G_MISS_CHAR)

Line 1949: IF (x_sstv_rec.attribute4 = Okl_Api.G_MISS_CHAR)

1945: IF (x_sstv_rec.attribute3 = Okl_Api.G_MISS_CHAR)
1946: THEN
1947: x_sstv_rec.attribute3 := l_sstv_rec.attribute3;
1948: END IF;
1949: IF (x_sstv_rec.attribute4 = Okl_Api.G_MISS_CHAR)
1950: THEN
1951: x_sstv_rec.attribute4 := l_sstv_rec.attribute4;
1952: END IF;
1953: IF (x_sstv_rec.attribute5 = Okl_Api.G_MISS_CHAR)

Line 1953: IF (x_sstv_rec.attribute5 = Okl_Api.G_MISS_CHAR)

1949: IF (x_sstv_rec.attribute4 = Okl_Api.G_MISS_CHAR)
1950: THEN
1951: x_sstv_rec.attribute4 := l_sstv_rec.attribute4;
1952: END IF;
1953: IF (x_sstv_rec.attribute5 = Okl_Api.G_MISS_CHAR)
1954: THEN
1955: x_sstv_rec.attribute5 := l_sstv_rec.attribute5;
1956: END IF;
1957: IF (x_sstv_rec.attribute6 = Okl_Api.G_MISS_CHAR)

Line 1957: IF (x_sstv_rec.attribute6 = Okl_Api.G_MISS_CHAR)

1953: IF (x_sstv_rec.attribute5 = Okl_Api.G_MISS_CHAR)
1954: THEN
1955: x_sstv_rec.attribute5 := l_sstv_rec.attribute5;
1956: END IF;
1957: IF (x_sstv_rec.attribute6 = Okl_Api.G_MISS_CHAR)
1958: THEN
1959: x_sstv_rec.attribute6 := l_sstv_rec.attribute6;
1960: END IF;
1961: IF (x_sstv_rec.attribute7 = Okl_Api.G_MISS_CHAR)

Line 1961: IF (x_sstv_rec.attribute7 = Okl_Api.G_MISS_CHAR)

1957: IF (x_sstv_rec.attribute6 = Okl_Api.G_MISS_CHAR)
1958: THEN
1959: x_sstv_rec.attribute6 := l_sstv_rec.attribute6;
1960: END IF;
1961: IF (x_sstv_rec.attribute7 = Okl_Api.G_MISS_CHAR)
1962: THEN
1963: x_sstv_rec.attribute7 := l_sstv_rec.attribute7;
1964: END IF;
1965: IF (x_sstv_rec.attribute8 = Okl_Api.G_MISS_CHAR)

Line 1965: IF (x_sstv_rec.attribute8 = Okl_Api.G_MISS_CHAR)

1961: IF (x_sstv_rec.attribute7 = Okl_Api.G_MISS_CHAR)
1962: THEN
1963: x_sstv_rec.attribute7 := l_sstv_rec.attribute7;
1964: END IF;
1965: IF (x_sstv_rec.attribute8 = Okl_Api.G_MISS_CHAR)
1966: THEN
1967: x_sstv_rec.attribute8 := l_sstv_rec.attribute8;
1968: END IF;
1969: IF (x_sstv_rec.attribute9 = Okl_Api.G_MISS_CHAR)

Line 1969: IF (x_sstv_rec.attribute9 = Okl_Api.G_MISS_CHAR)

1965: IF (x_sstv_rec.attribute8 = Okl_Api.G_MISS_CHAR)
1966: THEN
1967: x_sstv_rec.attribute8 := l_sstv_rec.attribute8;
1968: END IF;
1969: IF (x_sstv_rec.attribute9 = Okl_Api.G_MISS_CHAR)
1970: THEN
1971: x_sstv_rec.attribute9 := l_sstv_rec.attribute9;
1972: END IF;
1973: IF (x_sstv_rec.attribute10 = Okl_Api.G_MISS_CHAR)

Line 1973: IF (x_sstv_rec.attribute10 = Okl_Api.G_MISS_CHAR)

1969: IF (x_sstv_rec.attribute9 = Okl_Api.G_MISS_CHAR)
1970: THEN
1971: x_sstv_rec.attribute9 := l_sstv_rec.attribute9;
1972: END IF;
1973: IF (x_sstv_rec.attribute10 = Okl_Api.G_MISS_CHAR)
1974: THEN
1975: x_sstv_rec.attribute10 := l_sstv_rec.attribute10;
1976: END IF;
1977: IF (x_sstv_rec.attribute11 = Okl_Api.G_MISS_CHAR)

Line 1977: IF (x_sstv_rec.attribute11 = Okl_Api.G_MISS_CHAR)

1973: IF (x_sstv_rec.attribute10 = Okl_Api.G_MISS_CHAR)
1974: THEN
1975: x_sstv_rec.attribute10 := l_sstv_rec.attribute10;
1976: END IF;
1977: IF (x_sstv_rec.attribute11 = Okl_Api.G_MISS_CHAR)
1978: THEN
1979: x_sstv_rec.attribute11 := l_sstv_rec.attribute11;
1980: END IF;
1981: IF (x_sstv_rec.attribute12 = Okl_Api.G_MISS_CHAR)

Line 1981: IF (x_sstv_rec.attribute12 = Okl_Api.G_MISS_CHAR)

1977: IF (x_sstv_rec.attribute11 = Okl_Api.G_MISS_CHAR)
1978: THEN
1979: x_sstv_rec.attribute11 := l_sstv_rec.attribute11;
1980: END IF;
1981: IF (x_sstv_rec.attribute12 = Okl_Api.G_MISS_CHAR)
1982: THEN
1983: x_sstv_rec.attribute12 := l_sstv_rec.attribute12;
1984: END IF;
1985: IF (x_sstv_rec.attribute13 = Okl_Api.G_MISS_CHAR)

Line 1985: IF (x_sstv_rec.attribute13 = Okl_Api.G_MISS_CHAR)

1981: IF (x_sstv_rec.attribute12 = Okl_Api.G_MISS_CHAR)
1982: THEN
1983: x_sstv_rec.attribute12 := l_sstv_rec.attribute12;
1984: END IF;
1985: IF (x_sstv_rec.attribute13 = Okl_Api.G_MISS_CHAR)
1986: THEN
1987: x_sstv_rec.attribute13 := l_sstv_rec.attribute13;
1988: END IF;
1989: IF (x_sstv_rec.attribute14 = Okl_Api.G_MISS_CHAR)

Line 1989: IF (x_sstv_rec.attribute14 = Okl_Api.G_MISS_CHAR)

1985: IF (x_sstv_rec.attribute13 = Okl_Api.G_MISS_CHAR)
1986: THEN
1987: x_sstv_rec.attribute13 := l_sstv_rec.attribute13;
1988: END IF;
1989: IF (x_sstv_rec.attribute14 = Okl_Api.G_MISS_CHAR)
1990: THEN
1991: x_sstv_rec.attribute14 := l_sstv_rec.attribute14;
1992: END IF;
1993: IF (x_sstv_rec.attribute15 = Okl_Api.G_MISS_CHAR)

Line 1993: IF (x_sstv_rec.attribute15 = Okl_Api.G_MISS_CHAR)

1989: IF (x_sstv_rec.attribute14 = Okl_Api.G_MISS_CHAR)
1990: THEN
1991: x_sstv_rec.attribute14 := l_sstv_rec.attribute14;
1992: END IF;
1993: IF (x_sstv_rec.attribute15 = Okl_Api.G_MISS_CHAR)
1994: THEN
1995: x_sstv_rec.attribute15 := l_sstv_rec.attribute15;
1996: END IF;
1997: IF (x_sstv_rec.created_by = Okl_Api.G_MISS_NUM)

Line 1997: IF (x_sstv_rec.created_by = Okl_Api.G_MISS_NUM)

1993: IF (x_sstv_rec.attribute15 = Okl_Api.G_MISS_CHAR)
1994: THEN
1995: x_sstv_rec.attribute15 := l_sstv_rec.attribute15;
1996: END IF;
1997: IF (x_sstv_rec.created_by = Okl_Api.G_MISS_NUM)
1998: THEN
1999: x_sstv_rec.created_by := l_sstv_rec.created_by;
2000: END IF;
2001: IF (x_sstv_rec.creation_date = Okl_Api.G_MISS_DATE)

Line 2001: IF (x_sstv_rec.creation_date = Okl_Api.G_MISS_DATE)

1997: IF (x_sstv_rec.created_by = Okl_Api.G_MISS_NUM)
1998: THEN
1999: x_sstv_rec.created_by := l_sstv_rec.created_by;
2000: END IF;
2001: IF (x_sstv_rec.creation_date = Okl_Api.G_MISS_DATE)
2002: THEN
2003: x_sstv_rec.creation_date := l_sstv_rec.creation_date;
2004: END IF;
2005: IF (x_sstv_rec.last_updated_by = Okl_Api.G_MISS_NUM)

Line 2005: IF (x_sstv_rec.last_updated_by = Okl_Api.G_MISS_NUM)

2001: IF (x_sstv_rec.creation_date = Okl_Api.G_MISS_DATE)
2002: THEN
2003: x_sstv_rec.creation_date := l_sstv_rec.creation_date;
2004: END IF;
2005: IF (x_sstv_rec.last_updated_by = Okl_Api.G_MISS_NUM)
2006: THEN
2007: x_sstv_rec.last_updated_by := l_sstv_rec.last_updated_by;
2008: END IF;
2009: IF (x_sstv_rec.last_update_date = Okl_Api.G_MISS_DATE)

Line 2009: IF (x_sstv_rec.last_update_date = Okl_Api.G_MISS_DATE)

2005: IF (x_sstv_rec.last_updated_by = Okl_Api.G_MISS_NUM)
2006: THEN
2007: x_sstv_rec.last_updated_by := l_sstv_rec.last_updated_by;
2008: END IF;
2009: IF (x_sstv_rec.last_update_date = Okl_Api.G_MISS_DATE)
2010: THEN
2011: x_sstv_rec.last_update_date := l_sstv_rec.last_update_date;
2012: END IF;
2013: IF (x_sstv_rec.last_update_login = Okl_Api.G_MISS_NUM)

Line 2013: IF (x_sstv_rec.last_update_login = Okl_Api.G_MISS_NUM)

2009: IF (x_sstv_rec.last_update_date = Okl_Api.G_MISS_DATE)
2010: THEN
2011: x_sstv_rec.last_update_date := l_sstv_rec.last_update_date;
2012: END IF;
2013: IF (x_sstv_rec.last_update_login = Okl_Api.G_MISS_NUM)
2014: THEN
2015: x_sstv_rec.last_update_login := l_sstv_rec.last_update_login;
2016: END IF;
2017: RETURN(l_return_status);

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

2022: FUNCTION Set_Attributes (
2023: p_sstv_rec IN sstv_rec_type,
2024: x_sstv_rec OUT NOCOPY sstv_rec_type
2025: ) RETURN VARCHAR2 IS
2026: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
2027: BEGIN
2028: x_sstv_rec := p_sstv_rec;
2029: x_sstv_rec.OBJECT_VERSION_NUMBER := NVL(x_sstv_rec.OBJECT_VERSION_NUMBER, 0) + 1;
2030: RETURN(l_return_status);

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

2029: x_sstv_rec.OBJECT_VERSION_NUMBER := NVL(x_sstv_rec.OBJECT_VERSION_NUMBER, 0) + 1;
2030: RETURN(l_return_status);
2031: END Set_Attributes;
2032: BEGIN
2033: l_return_status := Okl_Api.START_ACTIVITY(l_api_name,
2034: G_PKG_NAME,
2035: p_init_msg_list,
2036: l_api_version,
2037: p_api_version,

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

2036: l_api_version,
2037: p_api_version,
2038: '_PVT',
2039: x_return_status);
2040: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2041: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2042: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2043: RAISE Okl_Api.G_EXCEPTION_ERROR;
2044: END IF;

Line 2041: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

2037: p_api_version,
2038: '_PVT',
2039: x_return_status);
2040: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2041: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2042: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2043: RAISE Okl_Api.G_EXCEPTION_ERROR;
2044: END IF;
2045: --- Setting item attributes

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

2038: '_PVT',
2039: x_return_status);
2040: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2041: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2042: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2043: RAISE Okl_Api.G_EXCEPTION_ERROR;
2044: END IF;
2045: --- Setting item attributes
2046: l_return_status := Set_Attributes(

Line 2043: RAISE Okl_Api.G_EXCEPTION_ERROR;

2039: x_return_status);
2040: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2041: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2042: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2043: RAISE Okl_Api.G_EXCEPTION_ERROR;
2044: END IF;
2045: --- Setting item attributes
2046: l_return_status := Set_Attributes(
2047: p_sstv_rec, -- IN

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

2046: l_return_status := Set_Attributes(
2047: p_sstv_rec, -- IN
2048: l_sstv_rec); -- OUT
2049: --- If any errors happen abort API
2050: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2051: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2052: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2053: RAISE Okl_Api.G_EXCEPTION_ERROR;
2054: END IF;

Line 2051: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

2047: p_sstv_rec, -- IN
2048: l_sstv_rec); -- OUT
2049: --- If any errors happen abort API
2050: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2051: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2052: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2053: RAISE Okl_Api.G_EXCEPTION_ERROR;
2054: END IF;
2055: l_return_status := populate_new_record(l_sstv_rec, l_def_sstv_rec);

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

2048: l_sstv_rec); -- OUT
2049: --- If any errors happen abort API
2050: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2051: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2052: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2053: RAISE Okl_Api.G_EXCEPTION_ERROR;
2054: END IF;
2055: l_return_status := populate_new_record(l_sstv_rec, l_def_sstv_rec);
2056: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

Line 2053: RAISE Okl_Api.G_EXCEPTION_ERROR;

2049: --- If any errors happen abort API
2050: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2051: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2052: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2053: RAISE Okl_Api.G_EXCEPTION_ERROR;
2054: END IF;
2055: l_return_status := populate_new_record(l_sstv_rec, l_def_sstv_rec);
2056: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2057: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

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

2052: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2053: RAISE Okl_Api.G_EXCEPTION_ERROR;
2054: END IF;
2055: l_return_status := populate_new_record(l_sstv_rec, l_def_sstv_rec);
2056: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2057: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2058: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2059: RAISE Okl_Api.G_EXCEPTION_ERROR;
2060: END IF;

Line 2057: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

2053: RAISE Okl_Api.G_EXCEPTION_ERROR;
2054: END IF;
2055: l_return_status := populate_new_record(l_sstv_rec, l_def_sstv_rec);
2056: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2057: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2058: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2059: RAISE Okl_Api.G_EXCEPTION_ERROR;
2060: END IF;
2061: l_def_sstv_rec := fill_who_columns(l_def_sstv_rec);

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

2054: END IF;
2055: l_return_status := populate_new_record(l_sstv_rec, l_def_sstv_rec);
2056: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2057: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2058: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2059: RAISE Okl_Api.G_EXCEPTION_ERROR;
2060: END IF;
2061: l_def_sstv_rec := fill_who_columns(l_def_sstv_rec);
2062: --- Validate all non-missing attributes (Item Level Validation)

Line 2059: RAISE Okl_Api.G_EXCEPTION_ERROR;

2055: l_return_status := populate_new_record(l_sstv_rec, l_def_sstv_rec);
2056: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2057: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2058: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2059: RAISE Okl_Api.G_EXCEPTION_ERROR;
2060: END IF;
2061: l_def_sstv_rec := fill_who_columns(l_def_sstv_rec);
2062: --- Validate all non-missing attributes (Item Level Validation)
2063: l_return_status := Validate_Attributes(l_def_sstv_rec);

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

2061: l_def_sstv_rec := fill_who_columns(l_def_sstv_rec);
2062: --- Validate all non-missing attributes (Item Level Validation)
2063: l_return_status := Validate_Attributes(l_def_sstv_rec);
2064: --- If any errors happen abort API
2065: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2066: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2067: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2068: RAISE Okl_Api.G_EXCEPTION_ERROR;
2069: END IF;

Line 2066: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

2062: --- Validate all non-missing attributes (Item Level Validation)
2063: l_return_status := Validate_Attributes(l_def_sstv_rec);
2064: --- If any errors happen abort API
2065: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2066: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2067: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2068: RAISE Okl_Api.G_EXCEPTION_ERROR;
2069: END IF;
2070: l_return_status := Validate_Record(l_def_sstv_rec);

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

2063: l_return_status := Validate_Attributes(l_def_sstv_rec);
2064: --- If any errors happen abort API
2065: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2066: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2067: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2068: RAISE Okl_Api.G_EXCEPTION_ERROR;
2069: END IF;
2070: l_return_status := Validate_Record(l_def_sstv_rec);
2071: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

Line 2068: RAISE Okl_Api.G_EXCEPTION_ERROR;

2064: --- If any errors happen abort API
2065: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2066: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2067: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2068: RAISE Okl_Api.G_EXCEPTION_ERROR;
2069: END IF;
2070: l_return_status := Validate_Record(l_def_sstv_rec);
2071: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2072: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

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

2067: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2068: RAISE Okl_Api.G_EXCEPTION_ERROR;
2069: END IF;
2070: l_return_status := Validate_Record(l_def_sstv_rec);
2071: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2072: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2073: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2074: RAISE Okl_Api.G_EXCEPTION_ERROR;
2075: END IF;

Line 2072: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

2068: RAISE Okl_Api.G_EXCEPTION_ERROR;
2069: END IF;
2070: l_return_status := Validate_Record(l_def_sstv_rec);
2071: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2072: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2073: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2074: RAISE Okl_Api.G_EXCEPTION_ERROR;
2075: END IF;
2076:

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

2069: END IF;
2070: l_return_status := Validate_Record(l_def_sstv_rec);
2071: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2072: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2073: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2074: RAISE Okl_Api.G_EXCEPTION_ERROR;
2075: END IF;
2076:
2077: --------------------------------------

Line 2074: RAISE Okl_Api.G_EXCEPTION_ERROR;

2070: l_return_status := Validate_Record(l_def_sstv_rec);
2071: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2072: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2073: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2074: RAISE Okl_Api.G_EXCEPTION_ERROR;
2075: END IF;
2076:
2077: --------------------------------------
2078: -- Move VIEW record to "Child" records

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

2088: x_msg_data,
2089: l_sst_rec,
2090: lx_sst_rec
2091: );
2092: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2093: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2094: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2095: RAISE Okl_Api.G_EXCEPTION_ERROR;
2096: END IF;

Line 2093: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

2089: l_sst_rec,
2090: lx_sst_rec
2091: );
2092: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2093: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2094: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2095: RAISE Okl_Api.G_EXCEPTION_ERROR;
2096: END IF;
2097: migrate(lx_sst_rec, l_def_sstv_rec);

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

2090: lx_sst_rec
2091: );
2092: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2093: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2094: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2095: RAISE Okl_Api.G_EXCEPTION_ERROR;
2096: END IF;
2097: migrate(lx_sst_rec, l_def_sstv_rec);
2098: x_sstv_rec := l_def_sstv_rec;

Line 2095: RAISE Okl_Api.G_EXCEPTION_ERROR;

2091: );
2092: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2093: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2094: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2095: RAISE Okl_Api.G_EXCEPTION_ERROR;
2096: END IF;
2097: migrate(lx_sst_rec, l_def_sstv_rec);
2098: x_sstv_rec := l_def_sstv_rec;
2099: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);

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

2095: RAISE Okl_Api.G_EXCEPTION_ERROR;
2096: END IF;
2097: migrate(lx_sst_rec, l_def_sstv_rec);
2098: x_sstv_rec := l_def_sstv_rec;
2099: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
2100: EXCEPTION
2101: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
2102: x_return_status := Okl_Api.HANDLE_EXCEPTIONS
2103: (

Line 2101: WHEN Okl_Api.G_EXCEPTION_ERROR THEN

2097: migrate(lx_sst_rec, l_def_sstv_rec);
2098: x_sstv_rec := l_def_sstv_rec;
2099: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
2100: EXCEPTION
2101: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
2102: x_return_status := Okl_Api.HANDLE_EXCEPTIONS
2103: (
2104: l_api_name,
2105: G_PKG_NAME,

Line 2102: x_return_status := Okl_Api.HANDLE_EXCEPTIONS

2098: x_sstv_rec := l_def_sstv_rec;
2099: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
2100: EXCEPTION
2101: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
2102: x_return_status := Okl_Api.HANDLE_EXCEPTIONS
2103: (
2104: l_api_name,
2105: G_PKG_NAME,
2106: 'Okl_Api.G_RET_STS_ERROR',

Line 2106: 'Okl_Api.G_RET_STS_ERROR',

2102: x_return_status := Okl_Api.HANDLE_EXCEPTIONS
2103: (
2104: l_api_name,
2105: G_PKG_NAME,
2106: 'Okl_Api.G_RET_STS_ERROR',
2107: x_msg_count,
2108: x_msg_data,
2109: '_PVT'
2110: );

Line 2111: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

2107: x_msg_count,
2108: x_msg_data,
2109: '_PVT'
2110: );
2111: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
2112: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS
2113: (
2114: l_api_name,
2115: G_PKG_NAME,

Line 2112: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS

2108: x_msg_data,
2109: '_PVT'
2110: );
2111: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
2112: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS
2113: (
2114: l_api_name,
2115: G_PKG_NAME,
2116: 'Okl_Api.G_RET_STS_UNEXP_ERROR',

Line 2116: 'Okl_Api.G_RET_STS_UNEXP_ERROR',

2112: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS
2113: (
2114: l_api_name,
2115: G_PKG_NAME,
2116: 'Okl_Api.G_RET_STS_UNEXP_ERROR',
2117: x_msg_count,
2118: x_msg_data,
2119: '_PVT'
2120: );

Line 2122: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS

2118: x_msg_data,
2119: '_PVT'
2120: );
2121: WHEN OTHERS THEN
2122: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS
2123: (
2124: l_api_name,
2125: G_PKG_NAME,
2126: 'OTHERS',

Line 2137: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

2133: -- PL/SQL TBL update_row for:SSTV_TBL --
2134: ----------------------------------------
2135: PROCEDURE update_row(
2136: p_api_version IN NUMBER,
2137: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
2138: x_return_status OUT NOCOPY VARCHAR2,
2139: x_msg_count OUT NOCOPY NUMBER,
2140: x_msg_data OUT NOCOPY VARCHAR2,
2141: p_sstv_tbl IN sstv_tbl_type,

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

2142: x_sstv_tbl OUT NOCOPY sstv_tbl_type) IS
2143:
2144: l_api_version CONSTANT NUMBER := 1;
2145: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_update_row';
2146: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
2147: i NUMBER := 0;
2148: -- Begin Post-Generation Change
2149: -- overall error status
2150: l_overall_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

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

2146: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
2147: i NUMBER := 0;
2148: -- Begin Post-Generation Change
2149: -- overall error status
2150: l_overall_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
2151: -- End Post-Generation Change
2152: BEGIN
2153: Okl_Api.init_msg_list(p_init_msg_list);
2154: -- Make sure PL/SQL table has records in it before passing

Line 2153: Okl_Api.init_msg_list(p_init_msg_list);

2149: -- overall error status
2150: l_overall_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
2151: -- End Post-Generation Change
2152: BEGIN
2153: Okl_Api.init_msg_list(p_init_msg_list);
2154: -- Make sure PL/SQL table has records in it before passing
2155: IF (p_sstv_tbl.COUNT > 0) THEN
2156: i := p_sstv_tbl.FIRST;
2157: LOOP

Line 2160: p_init_msg_list => Okl_Api.G_FALSE,

2156: i := p_sstv_tbl.FIRST;
2157: LOOP
2158: update_row (
2159: p_api_version => p_api_version,
2160: p_init_msg_list => Okl_Api.G_FALSE,
2161: x_return_status => x_return_status,
2162: x_msg_count => x_msg_count,
2163: x_msg_data => x_msg_data,
2164: p_sstv_rec => p_sstv_tbl(i),

Line 2169: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN

2165: x_sstv_rec => x_sstv_tbl(i));
2166:
2167: -- Begin Post-Generation Change
2168: -- store the highest degree of error
2169: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
2170: IF l_overall_status <> Okl_Api.G_RET_STS_UNEXP_ERROR THEN
2171: l_overall_status := x_return_status;
2172: END IF;
2173: END IF;

Line 2170: IF l_overall_status <> Okl_Api.G_RET_STS_UNEXP_ERROR THEN

2166:
2167: -- Begin Post-Generation Change
2168: -- store the highest degree of error
2169: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
2170: IF l_overall_status <> Okl_Api.G_RET_STS_UNEXP_ERROR THEN
2171: l_overall_status := x_return_status;
2172: END IF;
2173: END IF;
2174: -- End Post-Generation Change

Line 2187: WHEN Okl_Api.G_EXCEPTION_ERROR THEN

2183: -- End Post-Generation Change
2184:
2185: END IF;
2186: EXCEPTION
2187: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
2188: x_return_status := Okl_Api.HANDLE_EXCEPTIONS
2189: (
2190: l_api_name,
2191: G_PKG_NAME,

Line 2188: x_return_status := Okl_Api.HANDLE_EXCEPTIONS

2184:
2185: END IF;
2186: EXCEPTION
2187: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
2188: x_return_status := Okl_Api.HANDLE_EXCEPTIONS
2189: (
2190: l_api_name,
2191: G_PKG_NAME,
2192: 'Okl_Api.G_RET_STS_ERROR',

Line 2192: 'Okl_Api.G_RET_STS_ERROR',

2188: x_return_status := Okl_Api.HANDLE_EXCEPTIONS
2189: (
2190: l_api_name,
2191: G_PKG_NAME,
2192: 'Okl_Api.G_RET_STS_ERROR',
2193: x_msg_count,
2194: x_msg_data,
2195: '_PVT'
2196: );

Line 2197: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

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

Line 2198: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS

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

Line 2202: 'Okl_Api.G_RET_STS_UNEXP_ERROR',

2198: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS
2199: (
2200: l_api_name,
2201: G_PKG_NAME,
2202: 'Okl_Api.G_RET_STS_UNEXP_ERROR',
2203: x_msg_count,
2204: x_msg_data,
2205: '_PVT'
2206: );

Line 2208: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS

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

Line 2226: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

2222: ---------------------------------------
2223: -- delete_row for:OKL_SRCH_STRM_TYPS --
2224: ---------------------------------------
2225: PROCEDURE delete_row(
2226: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
2227: x_return_status OUT NOCOPY VARCHAR2,
2228: x_msg_count OUT NOCOPY NUMBER,
2229: x_msg_data OUT NOCOPY VARCHAR2,
2230: p_sst_rec IN sst_rec_type) IS

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

2230: p_sst_rec IN sst_rec_type) IS
2231:
2232: l_api_version CONSTANT NUMBER := 1;
2233: l_api_name CONSTANT VARCHAR2(30) := 'TYPS_delete_row';
2234: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
2235: l_sst_rec sst_rec_type:= p_sst_rec;
2236: l_row_notfound BOOLEAN := TRUE;
2237:
2238: -- history tables not supported -- 04 APR 2002

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

2239: -- l_okl_srch_strm_typs_h_rec okl_srch_strm_typs_h_rec_type;
2240: -- lx_okl_srch_strm_typs_h_rec okl_srch_strm_typs_h_rec_type;
2241:
2242: BEGIN
2243: l_return_status := Okl_Api.START_ACTIVITY(l_api_name,
2244: p_init_msg_list,
2245: '_PVT',
2246: x_return_status);
2247: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

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

2243: l_return_status := Okl_Api.START_ACTIVITY(l_api_name,
2244: p_init_msg_list,
2245: '_PVT',
2246: x_return_status);
2247: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2248: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2249: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2250: RAISE Okl_Api.G_EXCEPTION_ERROR;
2251: END IF;

Line 2248: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

2244: p_init_msg_list,
2245: '_PVT',
2246: x_return_status);
2247: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2248: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2249: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2250: RAISE Okl_Api.G_EXCEPTION_ERROR;
2251: END IF;
2252: -- Insert into History table

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

2245: '_PVT',
2246: x_return_status);
2247: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2248: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2249: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2250: RAISE Okl_Api.G_EXCEPTION_ERROR;
2251: END IF;
2252: -- Insert into History table
2253: /*

Line 2250: RAISE Okl_Api.G_EXCEPTION_ERROR;

2246: x_return_status);
2247: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2248: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2249: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2250: RAISE Okl_Api.G_EXCEPTION_ERROR;
2251: END IF;
2252: -- Insert into History table
2253: /*
2254: l_sst_rec := get_rec(l_sst_rec, l_row_notfound);

Line 2256: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

2252: -- Insert into History table
2253: /*
2254: l_sst_rec := get_rec(l_sst_rec, l_row_notfound);
2255: IF (l_row_notfound) THEN
2256: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2257: END IF;
2258: migrate(l_sst_rec, l_okl_srch_strm_typs_h_rec);
2259: insert_row(
2260: p_init_msg_list,

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

2264: l_okl_srch_strm_typs_h_rec,
2265: lx_okl_srch_strm_typs_h_rec
2266: );
2267: */
2268: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2269: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2270: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2271: RAISE Okl_Api.G_EXCEPTION_ERROR;
2272: END IF;

Line 2269: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

2265: lx_okl_srch_strm_typs_h_rec
2266: );
2267: */
2268: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2269: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2270: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2271: RAISE Okl_Api.G_EXCEPTION_ERROR;
2272: END IF;
2273: DELETE FROM OKL_SRCH_STRM_TYPS

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

2266: );
2267: */
2268: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2269: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2270: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2271: RAISE Okl_Api.G_EXCEPTION_ERROR;
2272: END IF;
2273: DELETE FROM OKL_SRCH_STRM_TYPS
2274: WHERE ID = l_sst_rec.id;

Line 2271: RAISE Okl_Api.G_EXCEPTION_ERROR;

2267: */
2268: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2269: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2270: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2271: RAISE Okl_Api.G_EXCEPTION_ERROR;
2272: END IF;
2273: DELETE FROM OKL_SRCH_STRM_TYPS
2274: WHERE ID = l_sst_rec.id;
2275:

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

2272: END IF;
2273: DELETE FROM OKL_SRCH_STRM_TYPS
2274: WHERE ID = l_sst_rec.id;
2275:
2276: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
2277: EXCEPTION
2278: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
2279: x_return_status := Okl_Api.HANDLE_EXCEPTIONS
2280: (

Line 2278: WHEN Okl_Api.G_EXCEPTION_ERROR THEN

2274: WHERE ID = l_sst_rec.id;
2275:
2276: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
2277: EXCEPTION
2278: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
2279: x_return_status := Okl_Api.HANDLE_EXCEPTIONS
2280: (
2281: l_api_name,
2282: G_PKG_NAME,

Line 2279: x_return_status := Okl_Api.HANDLE_EXCEPTIONS

2275:
2276: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
2277: EXCEPTION
2278: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
2279: x_return_status := Okl_Api.HANDLE_EXCEPTIONS
2280: (
2281: l_api_name,
2282: G_PKG_NAME,
2283: 'Okl_Api.G_RET_STS_ERROR',

Line 2283: 'Okl_Api.G_RET_STS_ERROR',

2279: x_return_status := Okl_Api.HANDLE_EXCEPTIONS
2280: (
2281: l_api_name,
2282: G_PKG_NAME,
2283: 'Okl_Api.G_RET_STS_ERROR',
2284: x_msg_count,
2285: x_msg_data,
2286: '_PVT'
2287: );

Line 2288: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

2284: x_msg_count,
2285: x_msg_data,
2286: '_PVT'
2287: );
2288: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
2289: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS
2290: (
2291: l_api_name,
2292: G_PKG_NAME,

Line 2289: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS

2285: x_msg_data,
2286: '_PVT'
2287: );
2288: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
2289: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS
2290: (
2291: l_api_name,
2292: G_PKG_NAME,
2293: 'Okl_Api.G_RET_STS_UNEXP_ERROR',

Line 2293: 'Okl_Api.G_RET_STS_UNEXP_ERROR',

2289: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS
2290: (
2291: l_api_name,
2292: G_PKG_NAME,
2293: 'Okl_Api.G_RET_STS_UNEXP_ERROR',
2294: x_msg_count,
2295: x_msg_data,
2296: '_PVT'
2297: );

Line 2299: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS

2295: x_msg_data,
2296: '_PVT'
2297: );
2298: WHEN OTHERS THEN
2299: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS
2300: (
2301: l_api_name,
2302: G_PKG_NAME,
2303: 'OTHERS',

Line 2314: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

2310: -- delete_row for:OKL_SRCH_STRM_TYPS_V --
2311: -----------------------------------------
2312: PROCEDURE delete_row(
2313: p_api_version IN NUMBER,
2314: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
2315: x_return_status OUT NOCOPY VARCHAR2,
2316: x_msg_count OUT NOCOPY NUMBER,
2317: x_msg_data OUT NOCOPY VARCHAR2,
2318: p_sstv_rec IN sstv_rec_type) IS

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

2318: p_sstv_rec IN sstv_rec_type) IS
2319:
2320: l_api_version CONSTANT NUMBER := 1;
2321: l_api_name CONSTANT VARCHAR2(30) := 'V_delete_row';
2322: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
2323: l_sstv_rec sstv_rec_type := p_sstv_rec;
2324: l_sst_rec sst_rec_type;
2325: BEGIN
2326: l_return_status := Okl_Api.START_ACTIVITY(l_api_name,

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

2322: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
2323: l_sstv_rec sstv_rec_type := p_sstv_rec;
2324: l_sst_rec sst_rec_type;
2325: BEGIN
2326: l_return_status := Okl_Api.START_ACTIVITY(l_api_name,
2327: G_PKG_NAME,
2328: p_init_msg_list,
2329: l_api_version,
2330: p_api_version,

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

2329: l_api_version,
2330: p_api_version,
2331: '_PVT',
2332: x_return_status);
2333: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2334: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2335: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2336: RAISE Okl_Api.G_EXCEPTION_ERROR;
2337: END IF;

Line 2334: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

2330: p_api_version,
2331: '_PVT',
2332: x_return_status);
2333: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2334: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2335: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2336: RAISE Okl_Api.G_EXCEPTION_ERROR;
2337: END IF;
2338: --------------------------------------

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

2331: '_PVT',
2332: x_return_status);
2333: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2334: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2335: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2336: RAISE Okl_Api.G_EXCEPTION_ERROR;
2337: END IF;
2338: --------------------------------------
2339: -- Move VIEW record to "Child" records

Line 2336: RAISE Okl_Api.G_EXCEPTION_ERROR;

2332: x_return_status);
2333: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2334: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2335: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2336: RAISE Okl_Api.G_EXCEPTION_ERROR;
2337: END IF;
2338: --------------------------------------
2339: -- Move VIEW record to "Child" records
2340: --------------------------------------

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

2348: x_msg_count,
2349: x_msg_data,
2350: l_sst_rec
2351: );
2352: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2353: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2354: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2355: RAISE Okl_Api.G_EXCEPTION_ERROR;
2356: END IF;

Line 2353: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

2349: x_msg_data,
2350: l_sst_rec
2351: );
2352: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2353: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2354: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2355: RAISE Okl_Api.G_EXCEPTION_ERROR;
2356: END IF;
2357: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);

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

2350: l_sst_rec
2351: );
2352: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2353: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2354: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2355: RAISE Okl_Api.G_EXCEPTION_ERROR;
2356: END IF;
2357: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
2358: EXCEPTION

Line 2355: RAISE Okl_Api.G_EXCEPTION_ERROR;

2351: );
2352: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2353: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2354: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2355: RAISE Okl_Api.G_EXCEPTION_ERROR;
2356: END IF;
2357: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
2358: EXCEPTION
2359: WHEN Okl_Api.G_EXCEPTION_ERROR THEN

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

2353: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2354: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2355: RAISE Okl_Api.G_EXCEPTION_ERROR;
2356: END IF;
2357: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
2358: EXCEPTION
2359: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
2360: x_return_status := Okl_Api.HANDLE_EXCEPTIONS
2361: (

Line 2359: WHEN Okl_Api.G_EXCEPTION_ERROR THEN

2355: RAISE Okl_Api.G_EXCEPTION_ERROR;
2356: END IF;
2357: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
2358: EXCEPTION
2359: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
2360: x_return_status := Okl_Api.HANDLE_EXCEPTIONS
2361: (
2362: l_api_name,
2363: G_PKG_NAME,

Line 2360: x_return_status := Okl_Api.HANDLE_EXCEPTIONS

2356: END IF;
2357: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
2358: EXCEPTION
2359: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
2360: x_return_status := Okl_Api.HANDLE_EXCEPTIONS
2361: (
2362: l_api_name,
2363: G_PKG_NAME,
2364: 'Okl_Api.G_RET_STS_ERROR',

Line 2364: 'Okl_Api.G_RET_STS_ERROR',

2360: x_return_status := Okl_Api.HANDLE_EXCEPTIONS
2361: (
2362: l_api_name,
2363: G_PKG_NAME,
2364: 'Okl_Api.G_RET_STS_ERROR',
2365: x_msg_count,
2366: x_msg_data,
2367: '_PVT'
2368: );

Line 2369: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

2365: x_msg_count,
2366: x_msg_data,
2367: '_PVT'
2368: );
2369: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
2370: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS
2371: (
2372: l_api_name,
2373: G_PKG_NAME,

Line 2370: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS

2366: x_msg_data,
2367: '_PVT'
2368: );
2369: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
2370: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS
2371: (
2372: l_api_name,
2373: G_PKG_NAME,
2374: 'Okl_Api.G_RET_STS_UNEXP_ERROR',

Line 2374: 'Okl_Api.G_RET_STS_UNEXP_ERROR',

2370: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS
2371: (
2372: l_api_name,
2373: G_PKG_NAME,
2374: 'Okl_Api.G_RET_STS_UNEXP_ERROR',
2375: x_msg_count,
2376: x_msg_data,
2377: '_PVT'
2378: );

Line 2380: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS

2376: x_msg_data,
2377: '_PVT'
2378: );
2379: WHEN OTHERS THEN
2380: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS
2381: (
2382: l_api_name,
2383: G_PKG_NAME,
2384: 'OTHERS',

Line 2395: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

2391: -- PL/SQL TBL delete_row for:SSTV_TBL --
2392: ----------------------------------------
2393: PROCEDURE delete_row(
2394: p_api_version IN NUMBER,
2395: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
2396: x_return_status OUT NOCOPY VARCHAR2,
2397: x_msg_count OUT NOCOPY NUMBER,
2398: x_msg_data OUT NOCOPY VARCHAR2,
2399: p_sstv_tbl IN sstv_tbl_type) IS

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

2399: p_sstv_tbl IN sstv_tbl_type) IS
2400:
2401: l_api_version CONSTANT NUMBER := 1;
2402: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_delete_row';
2403: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
2404: i NUMBER := 0;
2405: -- Begin Post-Generation Change
2406: -- overall error status
2407: l_overall_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

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

2403: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
2404: i NUMBER := 0;
2405: -- Begin Post-Generation Change
2406: -- overall error status
2407: l_overall_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
2408: -- End Post-Generation Change
2409:
2410: BEGIN
2411: Okl_Api.init_msg_list(p_init_msg_list);

Line 2411: Okl_Api.init_msg_list(p_init_msg_list);

2407: l_overall_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
2408: -- End Post-Generation Change
2409:
2410: BEGIN
2411: Okl_Api.init_msg_list(p_init_msg_list);
2412: -- Make sure PL/SQL table has records in it before passing
2413: IF (p_sstv_tbl.COUNT > 0) THEN
2414: i := p_sstv_tbl.FIRST;
2415: LOOP

Line 2418: p_init_msg_list => Okl_Api.G_FALSE,

2414: i := p_sstv_tbl.FIRST;
2415: LOOP
2416: delete_row (
2417: p_api_version => p_api_version,
2418: p_init_msg_list => Okl_Api.G_FALSE,
2419: x_return_status => x_return_status,
2420: x_msg_count => x_msg_count,
2421: x_msg_data => x_msg_data,
2422: p_sstv_rec => p_sstv_tbl(i));

Line 2426: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN

2422: p_sstv_rec => p_sstv_tbl(i));
2423:
2424: -- Begin Post-Generation Change
2425: -- store the highest degree of error
2426: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
2427: IF l_overall_status <> Okl_Api.G_RET_STS_UNEXP_ERROR THEN
2428: l_overall_status := x_return_status;
2429: END IF;
2430: END IF;

Line 2427: IF l_overall_status <> Okl_Api.G_RET_STS_UNEXP_ERROR THEN

2423:
2424: -- Begin Post-Generation Change
2425: -- store the highest degree of error
2426: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
2427: IF l_overall_status <> Okl_Api.G_RET_STS_UNEXP_ERROR THEN
2428: l_overall_status := x_return_status;
2429: END IF;
2430: END IF;
2431: -- End Post-Generation Change

Line 2444: WHEN Okl_Api.G_EXCEPTION_ERROR THEN

2440: -- End Post-Generation Change
2441:
2442: END IF;
2443: EXCEPTION
2444: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
2445: x_return_status := Okl_Api.HANDLE_EXCEPTIONS
2446: (
2447: l_api_name,
2448: G_PKG_NAME,

Line 2445: x_return_status := Okl_Api.HANDLE_EXCEPTIONS

2441:
2442: END IF;
2443: EXCEPTION
2444: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
2445: x_return_status := Okl_Api.HANDLE_EXCEPTIONS
2446: (
2447: l_api_name,
2448: G_PKG_NAME,
2449: 'Okl_Api.G_RET_STS_ERROR',

Line 2449: 'Okl_Api.G_RET_STS_ERROR',

2445: x_return_status := Okl_Api.HANDLE_EXCEPTIONS
2446: (
2447: l_api_name,
2448: G_PKG_NAME,
2449: 'Okl_Api.G_RET_STS_ERROR',
2450: x_msg_count,
2451: x_msg_data,
2452: '_PVT'
2453: );

Line 2454: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

2450: x_msg_count,
2451: x_msg_data,
2452: '_PVT'
2453: );
2454: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
2455: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS
2456: (
2457: l_api_name,
2458: G_PKG_NAME,

Line 2455: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS

2451: x_msg_data,
2452: '_PVT'
2453: );
2454: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
2455: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS
2456: (
2457: l_api_name,
2458: G_PKG_NAME,
2459: 'Okl_Api.G_RET_STS_UNEXP_ERROR',

Line 2459: 'Okl_Api.G_RET_STS_UNEXP_ERROR',

2455: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS
2456: (
2457: l_api_name,
2458: G_PKG_NAME,
2459: 'Okl_Api.G_RET_STS_UNEXP_ERROR',
2460: x_msg_count,
2461: x_msg_data,
2462: '_PVT'
2463: );

Line 2465: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS

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